This is one I can't wrap my head around - this might be more of a math question, but maybe there's something in Excel that can help.
I'm looking to schedule a number of events over a period, and want to space them evenly out over yes and no times.
As an example, I'll say that I have a food calendar, and over two weeks, I want to eat vegetables 9 of 14 days. The schedule would looking something like this:
To make it work, it's somewhat irregular, especially towards the end, and fully manual.
I'm not sure how to wrap my head around the problem - like using modulo or something...? Kind of stumped.
Is there an easier way to generate a frequency or sequence? This example is pretty small, but I'd like to consider something fairly large, and variable (X occurrences over Y days).
Thanks!
I'm looking to schedule a number of events over a period, and want to space them evenly out over yes and no times.
As an example, I'll say that I have a food calendar, and over two weeks, I want to eat vegetables 9 of 14 days. The schedule would looking something like this:
| Day | Schedule | Alpha |
|---|---|---|
| 1 | 1 | yes |
| 2 | 1 | yes |
| 3 | 0 | no |
| 4 | 1 | yes |
| 5 | 1 | yes |
| 6 | 0 | no |
| 7 | 1 | yes |
| 8 | 1 | yes |
| 9 | 0 | no |
| 10 | 1 | yes |
| 11 | 1 | yes |
| 12 | 0 | no |
| 13 | 1 | yes |
| 14 | 0 | no |
To make it work, it's somewhat irregular, especially towards the end, and fully manual.
I'm not sure how to wrap my head around the problem - like using modulo or something...? Kind of stumped.
Is there an easier way to generate a frequency or sequence? This example is pretty small, but I'd like to consider something fairly large, and variable (X occurrences over Y days).
Thanks!
