Hello - have been using this tool for 24hrs and its great.
I am totally stumped on a few ways of solving what I think may be a simple process.
We are opening a microbrewery which will have an associated tap room.
The tables all seem simple except quantity values and here is why.
We have recipes that require stock taken from an inventory. Thats easy except, each recipe has different quantities. So, when we say, ok today we are making this beer, we need the ammounts by weight deducted from available stock. I can see how we can do all of this but some recipes have 15 ingredients, I want to avoid having 15 tables with the quantity of whats being deducted.
Similarly, we have the same with packaging. At the end of the process we have a volume of liquid. Say 1000 litres. We have 4 different kegs, 3 different bottles and other formats. We need to divide the 1000 by these different ammounts. Again, without getting stuck on having loads and loads of rows.
I can see a way both cases can be done but not without loads and loads of cells. That would somewhat make it not benenficial.
Any feedback on the obvious bit I think I am missing?
Many thanks,
Nick