Here is the data for a perpetual scheduling function by ISO 8601 Weeks
Calendar starts
| DATE | DOFM | DOW | ISOWeek |
|---|---|---|---|
| 2007-01-01 | 1 | 1 | 1 |
| 2034-12-31 | 31 | 3 | 52 |
ISOWEEK Perpetual Function data.csv (195.1 KB)
Have fun and load this anywhere your want for scheduling by week and converting to a date for accounting.
So your full batch id is = (date + ISOWeek + Your Batch Number (your batch number should be serial number) 1,2,3,4…)
example:
2019-01-01W01B000001
2019-01-01W01B000002
2019-01-01W01B000003
2019-01-08W02B000004
2019-01-08W02B000005
2019-01-08W02B000006
2019-01-08W02B000007
I generally refer to the crop as
Week 1 Batch 3
Week 2 Batch 6
This whole method lets me quickly find and compare crops year to year batch to batch
This keeps all your number is a row without padding for data