Hello, newbie here
I am working on 2 apps for my restaurant, but i am not sure how to efficiently structure the data. I have :
- Inventory : listing hundreds of ingredients (price, quantity etc…)
- Recipe book : listing dozens of recipes, each containing dozens of ingredients from the Inventory
For the Inventory, i think the data can come from a single large Google worksheet.
For the Recipe book, I am not sure. Should i go with : one worksheet to index all the recipes listing, then one worksheet per detailed recipe ?
How to handle that many worksheet ? I wonder about the loading speed… because each recipe will have a lot of data : multiple ingredients, weight, inventory units, converted unit, yields, adjusted prices, 3 different profit & margin calculation methods, etc…
Is there a more efficient data structure ? such as MySQL database (with which i am not familiar with) ?
Does someone have a similar example ?