Province Management Spreadsheet

Printable View

Show 40 post(s) from this thread on one page

18-12-2016, 14:26
Drac1

can anyone confirm if this has been updated for age 70 yet?
19-12-2016, 16:52
Platapus

Please see the Age 70 update below this post.
19-12-2016, 18:08
Crystopher

Utopia Province Spreadsheet v1.2

Updated for Age 70. Please let me know if you encounter any errors!

EDIT: Including known issues that I'm awaiting values and calculations for:

- Building and soldier NW changes from Age 69
- Laboratories bonus increase for age 70 (need to know value)
- Magic sci buffing wizard production not included (need to verify if full sci value contributes)
22-12-2016, 20:55
Crystopher

Utopia Province Spreadsheet v1.2

Updated a few formulas, most notably the Heretic and Rogue sci bonuses. Enjoy!
12-01-2017, 08:14
LilDutchPrincess

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!
14-02-2017, 15:04
Tadpole

Quote:

Originally Posted by LilDutchPrincess

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..
09-03-2017, 19:43
archidit

Is the updated age 71 version out yet?
09-03-2017, 21:54
Crystopher

Quote:

Originally Posted by archidit

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)
09-03-2017, 22:52
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.
09-03-2017, 23:24
Nim

Thanks for sharing all of you!
10-03-2017, 10:30
Bo To

Quote:

Originally Posted by 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 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.
10-03-2017, 13:50
Crystopher

Quote:

Originally Posted by Bo To

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.

Thanks for the correction, I just looked back and saw I had read the blurb from the "Proposed Changes."

Either way, it'll still take time to update the science section since the max# of scientists needed has changed.
10-03-2017, 14:17
Crystopher

Quote:

Originally Posted by 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.

I'll check the science values, as that's really the only thing mine is missing, and add them to the main sheet (with your permission, of course). Also, Tadpole noted this to me in a previous post here, but if you're going to make any updates/changes to her sheet then you should maintain the changelog section as well (something I'd appreciate as well since I've been maintaining it also).
10-03-2017, 16:05
rob418

Quote:

Originally Posted by Crystopher

I'll check the science values, as that's really the only thing mine is missing, and add them to the main sheet (with your permission, of course). Also, Tadpole noted this to me in a previous post here, but if you're going to make any updates/changes to her sheet then you should maintain the changelog section as well (something I'd appreciate as well since I've been maintaining it also).

Sorry I just got back into utopia after about 10 years so the spreadsheet started as a personal tool, then KD tool, now I figure if anyone gets value from it I might as well make it public. I miss the strategy talk. Now it all seems so private.
10-03-2017, 16:38
Crystopher

Quote:

Originally Posted by rob418

Sorry I just got back into utopia after about 10 years so the spreadsheet started as a personal tool, then KD tool, now I figure if anyone gets value from it I might as well make it public. I miss the strategy talk. Now it all seems so private.

That's sort of how I started, but I was using Tadpole's sheet. Figured might as well share it if it's of use to others. I'm always happy to collab with others on keeping these kinds of tools going, as I know there's things about Excel that I don't know well enough.
10-03-2017, 22:31
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?
11-03-2017, 17:47
Crystopher

Quote:

Originally Posted by 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?

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 :)
15-03-2017, 16:31
LilDutchPrincess

Quote:

Originally Posted by Tadpole

I'm not dead. Just login impaired..

Pretty much the same to me.... both means no hugs and snuggles...
16-03-2017, 05:54
Crystopher

Quote:

Originally Posted by 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! :)
16-03-2017, 06:32
astron

Amazing work !!!
16-03-2017, 15:53
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)
16-03-2017, 23:20
Crystopher

Quote:

Originally Posted by 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)

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 :)
17-03-2017, 16:06
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. :)
19-03-2017, 10:40
Crystopher

Quote:

Originally Posted by 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. :)

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.
19-03-2017, 18:50
Bo To

The cap on lab's bonus is not 30%, probably it's 100% like last age:
Laboratories 140 14.8% 50.48% increase in new scientists (2.77%)

Also the base is 4% and it's not affected by BE.
19-03-2017, 19:33
Chris121

Laboratories [ ] 39.2% 95.0% increase in new scientists (0.0%)
20-03-2017, 02:48
hwulf

Wiki shows 95% for labs and 87.5% for unis. ("Percent MAX" column)
20-03-2017, 05:16
Crystopher

Quote:

Originally Posted by hwulf

Wiki shows 95% for labs and 87.5% for unis. ("Percent MAX" column)

Ah, I found the disconnect. The "Growth" page in the wiki has the correct values. I was looking at the "Building Formulas" page, which does not. Updates incoming.

http://wiki.utopia-game.com/index.ph...ulas#Buildings
24-03-2017, 15:14
Tadpole

Glad this is still used and kept alive :)
24-03-2017, 17:45
Crystopher

Thanks! It's been fun keep up with it, especially with the science changes and all.

More on-point, the OP of this thread has now been updated with the most recent version, for quality-of-life purposes. Expect this to happen going forward :)

EDIT: The spreadsheet has been updated to v1.3b! This update adds functionality for duration debuff spells (Gluttony, Greed, etc.).
19-05-2017, 06:51
Tadpole

Chrystopher, can we count on this being updated with final age changes in a timely manner? Ie. Before age start..
19-05-2017, 12:39
Crystopher

Quote:

Originally Posted by Tadpole

Crystopher, can we count on this being updated with final age changes in a timely manner? Ie. Before age start..

Yea, I'm back to playing again so I'll be on top of this as soon as the changes drop. Expect an update no later than EOD on May 20th.

Also, keep that extra "H" outta my name :P
19-05-2017, 14:28
Tadpole

Quote:

Originally Posted by Crystopher

Yea, I'm back to playing again so I'll be on top of this as soon as the changes drop. Expect an update no later than EOD on May 20th.

Also, keep that extra "H" outta my name :P

Coolio!

And sorry, got a few friends with that spelling. It's in my fingers :p
20-05-2017, 20:10
Crystopher

EDIT: Added Dryad, updates complete!

Greetings everyone! The Province Management Spreadsheet has been updated with the Age 72 changes. It can be accessed via the link below:

Utopia Province Management Spreadsheet v1.4

As always, please let me know if you have any suggestions or if you spot any errors/bugs. Thanks!

~Crystopher~
21-05-2017, 06:41
rob418

Here's the version I use, updated with all new changes. It works a bit differently from the other one in that you can lock in desired DPA/TPA/WPA and play with different things to maximise OPA. Or alternatively it will tell you max DPA (w/0 OPA) for the T/Ms.

Also reworked basically every formula and the tables to update race/personality modifiers so it's easier in future.

https://drive.google.com/open?id=0B5...jBBczFnLWY1TnM

At some point I'll create a version that allows you to compare multiple province setups in the one sheet, so you can test different races/personalities/builds/etc and tweak your strategy.
21-05-2017, 06:55
Crystopher

Quote:

Originally Posted by rob418

Here's the version I use, updated with all new changes. It works a bit differently from the other one in that you can lock in desired DPA/TPA/WPA and play with different things to maximise OPA. Or alternatively it will tell you max DPA (w/0 OPA) for the T/Ms.

Also reworked basically every formula and the tables to update race/personality modifiers so it's easier in future.

https://drive.google.com/open?id=0B5...jBBczFnLWY1TnM

At some point I'll create a version that allows you to compare multiple province setups in the one sheet, so you can test different races/personalities/builds/etc and tweak your strategy.

Just wanted to respond to the bolded portions real quick:

1) You can also lock in desired TPA/DPA/WPA on the sheet I'm maintaining. It's misleading to indicate otherwise.
2) You say reworked, but it really looks like you directly ripped off many of the formulas and fields.

I'm all for maintaining and sharing this tool for community usage, but I'm not a fan of having the work I put in being passed off as someone else's.
21-05-2017, 06:59
Panthira

Quote:

Originally Posted by Crystopher

Just wanted to respond to the bolded portions real quick:

1) You can also lock in desired TPA/DPA/WPA on the sheet I'm maintaining. It's misleading to indicate otherwise.
2) You say reworked, but it really looks like you directly ripped off many of the formulas and fields.

I'm all for maintaining and sharing this tool for community usage, but I'm not a fan of having the work I put in being passed off as someone else's.

Thanks for the sheet, and the work you did on it.
21-05-2017, 07:30
rob418

Quote:

Originally Posted by Crystopher

Just wanted to respond to the bolded portions real quick:

1) You can also lock in desired TPA/DPA/WPA on the sheet I'm maintaining. It's misleading to indicate otherwise.
2) You say reworked, but it really looks like you directly ripped off many of the formulas and fields.

I'm all for maintaining and sharing this tool for community usage, but I'm not a fan of having the work I put in being passed off as someone else's.

There's a credit on the top row 'Created by Tadpole aka Tadarch. Maintained by Crystopher. Last Updated by rob418 Age 72 (final changes)'

I've created this for my own use and am sharing it because others might get something from the changes I've made. Posting in this thread and including a reference to the people who created and maintained the sheet seems a reasonable way to give credit.

Absolutely this started off as your spreadsheet a while ago and has changed since then to meet my needs. The fields and layout are largely the same, the formulas have be re-written. The locking in DPA thing works differently if you take a look. Mine locks in a mDPA. Yours uses elites/defs per acre. My original issue was that it was difficult to keep the exact mDPA I wanted while playing with various other inputs.

EDIT: Also I'll say it again, thanks for your work creating/maintaining this sheet, if it hadn't been maintained I wouldn't have been able to customise what I want. In no way do i want to take any credit from you.
21-05-2017, 12:07
rob418

Latest version... the first sheet allows you to compare multiple provinces in the one view. E.g. I've loaded it with 8 different attacker strats to compare the new race to UD, Orc, Avian.

https://drive.google.com/open?id=1su...PzVro_p7RAokWM
21-05-2017, 14:23
bdbcoyote

Do you have the scenarios for Human Sage and Human Tact? I really like this spreed sheet but it seems very overwhelming for me to mess with, without fear of messing it all up.

Show 40 post(s) from this thread on one page

All times are GMT. The time now is 00:16.

MUGA GAMING, LLC