Not sure how useful this will be for you chefs, but it can help give you an idea of what your food does for us combat types, and how different changes you make on how you experiment them can affect us without having to spend tens of thoudands of credits and many hours to see the effects. Granted its not exactly what you will see in the game, but its close.
I think its pretty straight forward, but then again I made it so what else would I think?
I locked the spreadsheets so only the values that will have an effect are modifyable, in order to make it easier to use.
On the first page (Buff Setup) there are 5 main sections.
Base stats are what your stats would be normally, so whatever you have on your character screen, put these stats in there.
There is room for 4 different buffs to be played with right now. May add more in a future version.
Fill in the name of the buff, the type of buff, either "Food" or "Drink" (without the quotes). Under the stats portion fill in the different stats that the food modifies. Filling put the filling % and duration put how long it lasts, rounded down to the nearest minute. The other blank is currently not functioning, but may some day let you see how long other food buffs last, like other stat modifiers.
Also on the first page you can modify the stomach decay time, to see how food would work if the decay times were changed.
Also the first page calculates SPF and RE for the foods, based on my other posts.
The second page (Buff Calculator) is where you can see how the buffs interact. The only fields you can modify are the ones that list your buffs. In order to eat or drink that item, placethe desired number of items to eatin the space for the time you wish to use it, so if you want todrink one brandy, put a "1" in the brandy column at the time you wish to consume(without the quotes). To not eat or drink at a given time, delete the number you entered.
Assuming you entered the stats right on the first page the calculator will then show how your stats and the stomach will react to the event. It keeps track of both food and drink stomachs, and will tell you you are "TOO FULL" ifeither stomach ever exceeds 100. The calculator currently goes out to the 2 hour mark, though it is easy to expand with copy and paste.
I locked all the pages so you could only modify the customizable variables, however there is no password so you can unlock and change anything you wish.
It is very wide due to the large amount of information, so you might have to scroll over to see all of the stats and stomachs
