Excel Simulator: Version History

Feel free to report bugs and suggest ideas =)

edit

Apologies for the frequent update. Every update will contain at least 1 important bug that will affect simulations greatly. Furthermore, it is the start of age so I would like everyone to be updated as accurate as possible. Cheers =)

Soldier cost for shepherds is off. Should be 2/acre at the start.

I am suspecting that OMAC introduced the shepherd bonus twice to soldiers costs and none to GC costs. I have also emailed OMAC regarding the issue. For now I will assume it as 3. Thanks for the input ;)

No it's correct... but just barely:

Non-shep: ( 400 * 2/5 + 0 * 1 / 4 + 75 ) / 67 = 3.507463 (rounded to 4)
Shep: ( 400 * 2/5 + 0 * 1 / 4 + 75 ) / 67 * .7 = 2.455224 (rounded to 2)

Hi Godly,

I suspect the exploration cost for soldiers is inaccurate on utopia wiki.

A province from last age:
5507 acres, 8047 explored, 9419 lost in combat. Explore Cost is 16081gc and 35 soldiers.

Based on utopia wiki:
Gc: 3.16 * 5507 - 17.4 * SQRT( 5507 ) - 50 + 0 ) = 18643.359
Sols: 5507 * 2/5 + 0 * 1 / 4 + 75 ) / 67 = 33.997

Based on Excel Simulator (Also slightly modified from dragonportal):
Gc: 3.4* 5507 -15 * 5507^0.6 + 1.4 *(0)^1.01 + 50 = 16139.651
Sols: (Gc + 840) / 479.2 = 35.433

Illustration 2:
400 acres, 0 explored, new wol province.

Based on utopia wiki:
Gc: 3.16 * 400 - 17.4 * SQRT( 400 ) - 50 + 0 ) = 866
Sols: 5507 * 2/5 + 0 * 1 / 4 + 75 ) / 67 = 3.507

Based on Excel Simulator (Also slightly modified from dragonportal):
Gc: 3.4* 400 -15 * 400^0.6 + 1.4 *(0)^1.01 + 50 = 863.831
Sols: (Gc + 840) / 479.2 = 3.556

From illustration 2, you can see that even the based exploring cost for GC is inaccurate. Together with the research data from last age, I feel that the exploration costs on utopia wiki is inaccurate.

Cheers :)

I'm having some trouble loading data. When I copy paste into the proper box, the format becomes pretty weird. In the history page sometimes it runs into the first lines in other boxes for the other information such as Build page and In progress. When it does seemly copy paste right, there are still errors usually. For example money and food will display null values even at hour zero. I'm using MS Excel 2007 and I'm copying/pasting as the instructions instruct. Also version 1.06.

Other than that, everything else is working perfect. This is an awesome spreadsheet.

Some of the sections need to be formatted by Utopia Angel. Was that correct? The load function haven't been used much by everyone so I guess there might be lots of bugs :P However, I have tested a load province last age for 90 hours.

Correct. Throne and Build are both formatted by Angel V2.01 Alpha 2.

I will check again when I get back home. Thats on Friday :/

Tried it several different times and it finally worked. I did the exact same thing each time though so I'm not sure what happened.

Few bugs when importing:

You are automatically given 1,500 books of sci even after spending the original 1,500 free books that you start with. Example, it's hour 16 and it says I still have 1,500 free books.

Military training page shows #N/A "Gold Left" and "Gold Train" in every box. Cost of Offense Specs/Defensive Specs/Elites shows #N/A in every box except for the first row (H). Thieves show the correct cost.

Raze page shows #N/A for everything in the "Max Razable" row.

On the stats page, just about every rank past H shows #N/A.

I believe all of this is some error in reading the copy pastes.

I think they increased the birthrate.

Hi Tamer, it would be helpful if you can send me your load data to my gmail:

You can change your province name and ruler name away too ;)