Re: $80 USD: Updating a schedule using multiple criteria: time/date calcs and boolean

**Hi GCExcel, thanks for responding. Here are some answers:**

**- How many lessons / day?**

Typically 1 lesson per day for each GradeLevel. However, there may be two adjacent rows that have a value of 0.5 in the DaysHours column. So, there could be two consecutive lessons for a GradeLevel. I don't think I'll allow any decimal values that aren't 0.5.

**- How many lessons / week ?**

This could vary per GradeLevel. A GradeLevel like HS may have five 1-period (1 in the DaysHours column) lessons, such as Lesson# 6, 7, 8, 9 and 10. However, another GradeLevel, such as 4G, may have ten lessons that have 0.5 in the DaysHours column, and spanning Lesson#s 11, 12, 13, 14, 15, 16, 17, 18, 19 and 10.

**- If you have 2 lessons on the same but with different start date, does it mean the week number is different?**

This could be tricky. Some classes, such as HS and 4G, are all-year classes, and their start date is basically 8/21. Other classes are only a quarter or semester long, and their start dates are listed in C1:C7. So, week numbers (starting on a Sunday) should be different for classes that have different starting dates. However, this code is the least of my worries at this point.

**- How to determine which lessons has priority over an other one? I guess all lesson no1, should be first, then is it based on the Grade Level or the Category or ???**

Priority is given in this order - grouped by GradeLevel, then by Category, then by Lesson#.

**- DaysHours values represent #hours / lesson or #days/lesson?**

Sorry about this. I'm trying to write lessons such that one lesson (row) pretty much takes up 1 period, which is an hour, which in essence, is one day (to advance the next lesson to the next day's date). So a 1 means one period or one day. A 2 means 2 periods or 2 days. However, some lessons may have a 0.5. This would be a half a period. There could be 2 lessons combined in 1 period.

This part could probably be played with, but if a lesson goes over 1 period, then I won't allow 1.5 or 2.5--it'll just be 1 or 2, to make the date calculation advance properly.