Greetings.
What I am looking to do may not be possible natively, but here goes.
I am working on scaling a recipie to commercial scale, and I'm trying to calculate how many units of a given ingredient I need at as the batch size changes. I additionally want to switch to the next unit size of an ingredient if the weight of the calculated quantity of the previous size meets or exceeds the wieght of a greater unit size.
This may well require some VBS programming, which I've not done in 20 years... but
I've attached a version of the spreadsheet I'm working with to reference the statements fo follow.
The key value in the calculation is G14, collumn heading buckets per run currently set at 18.
That value drives the required quantity calculations in colmn M N and O, and collum P is how many whole units of the ingredient at the unit weight in collumn K.
Rather than have fixed ingredient sizes/costs I'd like to be able to use a table of weights/costs (in ounces)
so that if the required weight in ounces (collumn N) is equal to the value in E29, then use the unit weight/cost in E29 and F29 instead of the values in C and D 29. Or if greater or equal to G29 but less then K 29, use the values in G29 and H29 if that makes sense.
Thans!
Bookmarks