Forum: empire-en
Board: [818] General Discussion
Topic: [316880] Working Food Calculator
[-316880]
TPain (GB1) [GB1]
:: Aug. 18, 2016, 6:27 p.m.
A looong time in coming! I think this works, at least it does in preliminary testing. Predicts my Food Output in all locations correct to 1 decimal place.
Be aware it will not accurately account for fires. And there is a rumour that the Berimond Title food bonuses are not being added on properly in game, so if you have one, you could find a discrepancy because of this.
Link to download Microsoft Excel version:
https://we.tl/rNEf3V5JNR
Link to download Open Office version:
https://we.tl/8uqSMwTyfe
Please put to the test and let me know if there are any issues. Do double check you have put in all information correctly first though! (Instructions are on Sheet 2 if you are struggling).
Note of thanks to @abab (GB1) for helping out with some fine tuning at the end.
Note of thanks to @Klingon (RO1) for debugging a couple of issues on the Open Office version ('ice' and 'beri' issues now sorted).
Be aware it will not accurately account for fires. And there is a rumour that the Berimond Title food bonuses are not being added on properly in game, so if you have one, you could find a discrepancy because of this.
Link to download Microsoft Excel version:
https://we.tl/rNEf3V5JNR
Link to download Open Office version:
https://we.tl/8uqSMwTyfe
Please put to the test and let me know if there are any issues. Do double check you have put in all information correctly first though! (Instructions are on Sheet 2 if you are struggling).
Note of thanks to @abab (GB1) for helping out with some fine tuning at the end.
Note of thanks to @Klingon (RO1) for debugging a couple of issues on the Open Office version ('ice' and 'beri' issues now sorted).
[4534202]
TPain (GB1) [GB1]
:: Aug. 18, 2016, 7:37 p.m.
Both versions have now been updated to fix a few things and jazz them up a bit. Multiple sheets so you can save inputs for different locations.
[4534435]
millwall97 (GB1) [GB1]
:: Aug. 19, 2016, midnight
If it's producing the wrong predicted amount then you wouldn't be able able to rectify it anyways and there is so many variables that of course the predicted amount will more than likely be wrong.
[4534585]
TPain (GB1) [GB1]
:: Aug. 19, 2016, 8:19 a.m.
You could try it first before shunning it. It has correctly predicted all of my food outputs in all locations down to the decimal point. With all variables considered. It has also done the same for several other people.....
And surely you might consider as I have made the whole thing, I probably have the ability to 'rectify' it if a mistake is found. The only mistakes so far have been people not checking what they are putting in themselves.
And surely you might consider as I have made the whole thing, I probably have the ability to 'rectify' it if a mistake is found. The only mistakes so far have been people not checking what they are putting in themselves.
[4534740]
marc58 (GB1) [GB1]
:: Aug. 19, 2016, 10:45 a.m.
Anyone using Open Office version all you need to do is agree cookies
Great work Tom
Great work Tom
[4534781]
hornby19 (GB1) [GB1]
:: Aug. 19, 2016, 11:13 a.m.
Great work mate:)
[4535569]
Klingon (RO1) [None]
:: Aug. 20, 2016, 2:55 a.m.
Mine is without vlookup because granary is 88 + 3 * level, farm is 8+8*lvl, the workload is .75*previous workload level and so on ...
I think the PO-production formula (100% + 2*sqrt(PO)%) u took it from this thread (still checking each field if is right)
https://community.goodgamestudios.com/empire/en/discussion/comment/4492581/#Comment_4492581 , same for coment about beri titles, but i said only that widowmaker doesnt apply on green kingdom.
Ill show u something that doesnt match on PO calculation, so its better to use just PO points as its shown.
Overall its a great work, it look nice and it worked for some granaries i tested.
This is what i have wrong on total PO calculation (no farms no flour mill):
I think the PO-production formula (100% + 2*sqrt(PO)%) u took it from this thread (still checking each field if is right)
https://community.goodgamestudios.com/empire/en/discussion/comment/4492581/#Comment_4492581 , same for coment about beri titles, but i said only that widowmaker doesnt apply on green kingdom.
Ill show u something that doesnt match on PO calculation, so its better to use just PO points as its shown.
Overall its a great work, it look nice and it worked for some granaries i tested.
This is what i have wrong on total PO calculation (no farms no flour mill):
[4535609]
Klingon (RO1) [None]
:: Aug. 20, 2016, 5:32 a.m.
Found 2 things: beri title doesnt add nothing , ice work bad, give "#VALUE!" on many fields if u chose castle type "ice" (thats easy, change in V22 "Ice" with "Ice ")
Also maybe change the default value 0 with 2, green main (on same field V22).
For PO it work on R10: =SUM(R6:R9)*1.01.
I not finished checking all fields ...
Also maybe change the default value 0 with 2, green main (on same field V22).
For PO it work on R10: =SUM(R6:R9)*1.01.
I not finished checking all fields ...
[4535735]
TPain (GB1) [GB1]
:: Aug. 20, 2016, 10:01 a.m.
Thanks for trying to debug @Klingon (RO1) I shall try to find those errors. You're quite right I have probably written 'Ice' and 'ice' somewhere.
I don't understand what you mean by this: "Mine is without vlookup because granary is 88 + 3 * level, farm is 8+8*lvl, the workload is .75*previous workload level and so on ..."
And with regards to the PO adding up, that's why I have inputs for deco, population, protection and unrest, they don't add up correctly in game to the number at the bottom.
Do keep checking, I would like to be perfect!
I don't understand what you mean by this: "Mine is without vlookup because granary is 88 + 3 * level, farm is 8+8*lvl, the workload is .75*previous workload level and so on ..."
And with regards to the PO adding up, that's why I have inputs for deco, population, protection and unrest, they don't add up correctly in game to the number at the bottom.
Do keep checking, I would like to be perfect!
[4535737]
TPain (GB1) [GB1]
:: Aug. 20, 2016, 10:11 a.m.
@Klingon (RO1) I've just found the 'Ice' Error and fixed, and the Beri title error and fixed. Will just copy through the sheets now and resave and edit the first message in this thread with the updated files.
[4535939]
hacker (GB1) [GB1]
:: Aug. 20, 2016, 2:10 p.m.
guess the problem is not only in food i have one iron mine it's says in it's pannel i get 3 iron ore per hour but in the resource pannel it says 2.5
[4536017]
TPain (GB1) [GB1]
:: Aug. 20, 2016, 3:11 p.m.
@hacker (GB1) I think the panel doesn't show decimal places, so 2.5 rounds to 3.
[4543373]
Hards161 (AU1) [AU1]
:: Aug. 28, 2016, 2:44 a.m.
@TPain(GB1) Where about is the Metro Food Bonus included on the Excel Spreadsheet?
I input everything in and got the same amount as in game (another words - it works perfectly) , but I should have another +250 for the Metro Bonus.
Has this been overlooked or am I getting cheated by GGE?
I input everything in and got the same amount as in game (another words - it works perfectly) , but I should have another +250 for the Metro Bonus.
Has this been overlooked or am I getting cheated by GGE?
[4545813]
TPain (GB1) [GB1]
:: Aug. 30, 2016, 9:49 a.m.
That's been overlooked. I haven't had a metro bonus before so hadn't really thought about it. Quite busy at the moment but will make changes at some point in the future, and will add this in :-)
[4546997]
Gabeee (HU2) [HU2]
:: Aug. 31, 2016, 6:31 a.m.
I can't download it. 
"The download isn't available anymore"
"The download isn't available anymore"
[4547214]
TPain (GB1) [GB1]
:: Aug. 31, 2016, 10:18 a.m.
hmm maybe that site has a time limit, I will look into it at some point.