Province Management Spreadsheet

[Tadpole]

Ive been using this, but Tadpoles spreadsheet just isnt the same without him :( (I smell some Eragon in there too btw, he needs a lil credit too).

Thanks for keeping the Tadpole alive Crystopher!

I'm not dead. Just login impaired..

[archidit]

Is the updated age 71 version out yet?

[Crystopher]

Is the updated age 71 version out yet?

I've actually finished with all of the updates, but the Sciences section still needs to be updated (which won't be complete until we determine what the new max scientist cap is)

I'll update this post with the current version later today. You can still use it for planning purposes (builds, troops per acre, etc), but the science values will not be accurate. On that note, any assistance the community can provide would be MUCH appreciated!

Utopia Province Management v1.3 (Age 71)

[rob418]

docs.google com/spreadsheets/d/1SSAEXkWCi92DPtgXmG5sYX2lgveU7fbdXaeTeCI461k

(Had to remove the . in .com link because new forum account)

I made updates for age 71 and reworked it so you can lock in mDPA, rTPA, rWPA and PeasPA. It will calculate the max OPA. This was primarily to compare races for an attacker role.

Feel free to take what works, add this as a seperate sheet or whatever you like.

[Bo To]

I've actually finished with all of the updates, but the Sciences section still needs to be updated (which won't be complete until we determine what the new values for diminishing returns are).

I don't use your spreadsheet but just to give a hint if you still don't know - there are no diminishing returns on sci, only increased number to achieve the max. The scaling is still linear.

[Crystopher]

I've actually finished with all of the updates, but the Sciences section still needs to be updated (which won't be complete until we determine what the new max scientist cap is)

I'll update this post with the current version later today. You can still use it for planning purposes (builds, troops per acre, etc), but the science values will not be accurate. On that note, any assistance the community can provide would be MUCH appreciated!

Utopia Province Management v1.3 (Age 71)

The sheet has now been updated with the correct science numbers. As always, please let me know if you have any questions or spot anything wrong! :)

[LilDutchPrincess]

I'm not dead. Just login impaired..

Pretty much the same to me.... both means no hugs and snuggles...

[Nim]

Thanks for sharing all of you!

[hwulf]

Does the Rune output account for Elves new bonus? It doesn't seem like it does in this update?

Also, I updated this spreadsheet similarly for use in our kd. For now, I assumed the Sci Maxes are the same as Age 70, save for Production which will now be %120. I just set up the formulas to required +%50 more profs. I think this is a good estimation for now, while people consider different race/pers?

[Crystopher]

Does the Rune output account for Elves new bonus? It doesn't seem like it does in this update?

Also, I updated this spreadsheet similarly for use in our kd. For now, I assumed the Sci Maxes are the same as Age 70, save for Production which will now be %120. I just set up the formulas to required +%50 more profs. I think this is a good estimation for now, while people consider different race/pers?

Ah, looks like I missed that one. Fixed! The link in my previous post is the updated version now.

As for science, that's what I'm going to assume for now, but I'd much rather have actual values. I'll be able to update it once the Recruits become Novices, and I'll be monitoring it closely as the age progresses. Any help would be greatly appreciated though :)

[astron]

Amazing work !!!

[hwulf]

Awesome, thank you!

Possible to convert the Libs and Schools to Labs and Universities? I've been using Libs and just change the %Science increase to match what I'm actually getting. (I think the just changing the 2 to 4, and the 0.5 to 0.95 in the formula should do the trick for labs)

[Crystopher]

Awesome, thank you!

Possible to convert the Libs and Schools to Labs and Universities? I've been using Libs and just change the %Science increase to match what I'm actually getting. (I think the just changing the 2 to 4, and the 0.5 to 0.95 in the formula should do the trick for labs)

Well, that's embarrassing. I literally forgot that change was a thing. I'll get to work on it right away :)

Utopia Province Management v1.3a (Age 71)

Alright, that's been fixed! In addition, I reviewed several other fields on the spreadsheet and made a few other additions/corrections as well. Refer to the changelog tab for more info, but I'll note one thing here: I plan on adding a section for negative spell modifiers (Blizzard BE reduction, Gluttony food consumption, etc.). Expect the next version within a week :)

[hwulf]

Looks like Labs are maxing out at %30 Sci Spawn rate. Should be %95? And Uni's should be 87.5%, not 37.5%?

Sorry for all the nit picking, this spreadsheet is excellent as is, so if you want me to stop, just say so. :)

[Crystopher]

Looks like Labs are maxing out at %30 Sci Spawn rate. Should be %95? And Uni's should be 87.5%, not 37.5%?

Sorry for all the nit picking, this spreadsheet is excellent as is, so if you want me to stop, just say so. :)

No no, keep it coming, please! I try to catch everything but I know I'll miss things here and there. Without you pointing out the the Universities/Laboratories name thing, I wouldn't have reviewed all the formulas like I did :)

Now, as for the max rate, the numbers were pulled directly from the wiki, which shows Labs at 30% max and Unis at 75% max. It looks like I forgot to delete a "3" for the Uni, but I can fix that. Is there another thread or any other source to confirm the Labs max? I've updated the Universities formula for now though.