I receive orders for plants months in advance. For example November week 47 2017. These plants start as little babes in October 2016 and need to be chopped up numerous times (ie 100 plants will eventually make 10 000 in a year). Each plant variety takes different interval timeframes ie 4 weeks for some and 6 weeks for others.
To make life extra interesting there are four stages - Initiation which are the original 100 plants - Multiplication which recycles on the time intervals until numbers are reached - Rooting - when growing hormones are relpaced with rooting hormones before exiting to the greenhouse - Storage, which is where extras are placed on nutrient media only in the coolroom
How do I
Write code so that a sequence of steps can be communicated to a weekly worksheet for instance nutrient media made, x plants cut up
Recalculate the process if an order appears in the system part way through the process ie February. Eventually would like this to tell me the order is impossible or possible
The thought is to use weeks as the calculating point, however plant propagation is my forte and coding is about 4th on the list of my capabilities