Hi,
I'm trying to prepare a study schedule/planner based on certain conditions:
Week starts on Monday
Study hours/day: 4 hours (Mon - Wed) & 12 hours (Thur - Sun)
Topics are assigned a time limit and will roll over to a new day until time limit expires.
In case a topic ends midway through a day, the remaining time of the day is allotted to the next topic.
Sample data would be:
[TABLE="width: 275"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Topic[/TD]
[TD]Hours Allotted[/TD]
[/TR]
[TR]
[TD]ET[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]PW+BF[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]II[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]EA[/TD]
[TD="align: right"]0
[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD="align: right"]17.5[/TD]
[/TR]
[TR]
[TD]FI[/TD]
[TD="align: right"]75.5
[/TD]
[/TR]
[TR]
[TD]EQ[/TD]
[TD="align: right"]43
[/TD]
[/TR]
</tbody>[/TABLE]
As an example, for PW+BF, if started on a Monday (May 07, 2018), would end on Friday (May 11, 2018) with 6 hours of study time for Friday remaining which will be allotted to AA and so on.
I've tried a few things by myself (IF/IFS/Weekday) but can't figure out a way to incorporate the variable study times during the week. Any help would be appreciated!
Best,
Joe
I'm trying to prepare a study schedule/planner based on certain conditions:
Week starts on Monday
Study hours/day: 4 hours (Mon - Wed) & 12 hours (Thur - Sun)
Topics are assigned a time limit and will roll over to a new day until time limit expires.
In case a topic ends midway through a day, the remaining time of the day is allotted to the next topic.
Sample data would be:
[TABLE="width: 275"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Topic[/TD]
[TD]Hours Allotted[/TD]
[/TR]
[TR]
[TD]ET[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]PW+BF[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]II[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]EA[/TD]
[TD="align: right"]0
[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD="align: right"]17.5[/TD]
[/TR]
[TR]
[TD]FI[/TD]
[TD="align: right"]75.5
[/TD]
[/TR]
[TR]
[TD]EQ[/TD]
[TD="align: right"]43
[/TD]
[/TR]
</tbody>[/TABLE]
As an example, for PW+BF, if started on a Monday (May 07, 2018), would end on Friday (May 11, 2018) with 6 hours of study time for Friday remaining which will be allotted to AA and so on.
I've tried a few things by myself (IF/IFS/Weekday) but can't figure out a way to incorporate the variable study times during the week. Any help would be appreciated!
Best,
Joe