Updated for age 83 by Hex. Enjoy.
https://docs.google.com/spreadsheets...5JxMkzHqw/copy
Printable View
Updated for age 83 by Hex. Enjoy.
https://docs.google.com/spreadsheets...5JxMkzHqw/copy
Good job Hex!
Updated for age 84. Mostly by Hex. Added a Homes razing calculator too.
https://docs.google.com/spreadsheets...H8IP3kZlQ/copy
41k views on this thread, and yet only 200 replies - mostly by me. Such shame.
but the real MVP is Chrystopher!
You mean "Crystopher" ;)Quote:
Originally Posted by Korp
Dammit already edited it once. But yeah.
Ya you guys are awesome for this!
When update :)
Pending :)
Soon™
Update complete. Enjoy :)
Thanx, bro!Quote:
Originally Posted by Crystopher
Some things seem incomplete on the new updated sheet, getting some errors and looked like some values were old
I've taken another look and it appears the sciences values are off. I'll be working on that over the weekend and any information y'all could provide would be much appreciated?
Can you give me some specifics?Quote:
Originally Posted by Mrboombastic
Made updates to the way the sheet handles rituals and fixed the "Training Costs & Time" section. Details below:
v 2.4a - Crystopher revisions 3/25/2020
->FORMULA UPDATES
--Moved Ritual Strength (B18) to new cell (B19)
--Renamed Ritual Strength (B18) to Ritual Casts
--Added ritual effectiveness formula to (C19)
--Fixed training cost formulas (G53-G55) to accurately reflect training discount from Expedient
--Fixed training time formula (I56) to accurately reflect training discount from Expedient
--Updated training time formula (I56) to account for Avian racial bonus
EDIT: Science values are still off, currently researching the proper values/formulas
Updated complete, see changelog below :)
v 2.5 - Crystopher revisions 5/16/2020
- Fully updated for Age 86
->FORMULA UPDATES
--Fixed max population formula (D37) to properly calculate pop and incorporate Halfling racial bonus
--Fixed Offense per Acre formulas (H30, H31) to properly calculate Human racial bonus to War Horse strength
--Fixed Training cost formulas (G53-G55) to properly reflect Halfing racial bonus
v 2.5a - Crystopher revisions 5/26/2020
-> FORMULA UPDATES
--Fixed Thieves Dens formulas (N23, N24) to account for personality bonuses
Thanks for this! I think there's a small bug with the networth formula at the end where it should be a + rather than a * between the prisoners & science components.
Hey y'all, I'm currently working on updating the sheet and plan to have it completed by tomorrow evening. I've been getting quite a few requests for access and want to remind everyone that you'll need to save a copy yourself to use it properly.
Update complete with all age changes! Enjoy :)
Quote:
Originally Posted by Crystopher
awesome thanks
One last little update :D
v 2.6a - Crystopher revisions 7/21/2020
-> FORMULA UPDATES
--Updated Base ME formula (G38) for Age 87 changes
Another update has been released to address a bug with the Honor formula for WPA/TPA.
v 2.6b - Crystopher revisions 7/28/2020
- Cleaned up Honor formula section for greater clarity (expanded decimals, updated wording)
-> FORMULA UPDATES
--Fixed Honor formula for WPA/TPA (C42) to calculate bonus properly
v 2.6c - Crystopher revisions 8/18/2020
-> FORMULA UPDATES
--Fixed a bug with the Networth formula (C8), was previously multiplying NW of books instead of adding
hi i think your max-pop formula is missing a set of brackets on d37
should be =(((((SUM(L5:L33)*25)+(L34*15))*LOOKUP(C4,AJ9:AJ14,AK9:AK14))+O6)*(1+Q42)*(1+C40))
instead of =((((SUM(L5:L33)*25)+(L34*15)*LOOKUP(C4,AJ9:AJ14,AK9:AK14))+O6)*(1+Q42)*(1+C40))
only noticed cause i rolled a gnome and max pop was 9200 instead of 8450 as stated in spreadsheet (i know its a new age but the pop bonus is the same from last age)
thanks again for the spreadsheet
Thanks, I'll make sure that's corrected in the update :)
Speaking of which, the update may take a bit, I've got a pretty full week. Thanks for your patience!
EDIT: Ok, found some time and the sheet is now updated for Age 88! Enjoy :)
thanks :)
Hello Crys,
First and foremost, thank you so much for this spreadsheet. It made the experience of coming back after 8 years much easier. There are few things I did on the file that might help the community. I'm sharing the file here where I have added "Data Dump" tab which allow the user to just copy paste the pages in the game (i.e. Throne page, Science page and Building council page) and the values on this file (Land size, troop counts, science learned and building count) automatically gets updated. The user need to exactly select the same text indicated in the "data dump" tab.
Link - gofile .io/d/askmFB (i don't have much post so can't post the link, please delete the SPACE after ".io")
Second, I notice that the calculation on the max population doesn't seem to tie up with the actual population. I might be wrong but shouldn't the calculation be like this ==>> (((total acres * 25)+Homes Population) * (1+honor bonus) * (1+science bonus)*(1+Race Bonus)) whereas the current max population is taking into account built and barren acres which I think is supposed to mean number of population that can be housed? Currently, I'm at 860 acres with 160 unbuilt land (in progress) with the following details:
1. Human/War Hero - No Pop bonus
2. Lord as Honor level - 2% Pop bonus
3. Pop Science - 0%
4. Homes at 5% - 43 bldgs or 430 additional population
The State page shows my max population is 22369 and total population is 22369 as well. Using the original formula in your excel template:
((((built acres * 25)+(barren acres * 15)) * (1+Race bonus)+Homes Pop)*(1+Honor bonus)*(1*Science bonus))
((((700 * 25)+(160 * 15)) * (1+0)+430)*(1+2%)*(1*0%))
((((17,500)+(2,400)) * (1)+430)*(1.02)*(1))
((((17,500)+(2,400)) * (1)+430)*(1.02)*(1))
(((19,900 * (1)+430)*(1.02)*(1))
((20,330*(1.02)*(1))
=20,736.6
The calculated max population does not tie up with the ones showing on my State page. However, using this formula:
(((total acres * 25)+Homes Population) * (1+honor bonus) * (1+science bonus)*(1+Race Bonus))
(((860*25)+430)*(1+2%)*(1+0%)*(1+0%)
((21,500+430)*(1.02)*(1)*(1))
((21,930)*(1.02)*(1)*(1))
=22,368.6
The above formula matches the actual max population. I hope this helps improving the file.