Province Management Spreadsheet

Quote:

---

Originally Posted by rob418

Absolutely this started off as your spreadsheet

---

Quote:

---

Originally Posted by rob418

EDIT: Also I'll say it again, thanks for your work creating/maintaining this sheet

---

... hrm

Nevermind, it didnt open in docs before so it didnt allow me to edit. I am good now :D

Quote:

---

Originally Posted by rob418

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.

---

Just to clarify, this is Tadpole's sheet, not mine. I've also been maintaining it with her permission, something I'm not sure you've done yourself (you certainly never asked me). You didn't create anything; you copied everything from Tadpole's sheet and changed the layout, but literally just about everything is the same. That's the problem I have with this.

You can say thanks all you want and say you didn't intend to take someone else's work, but that's exactly what you've done here.

Is it really work when you're doing what you love?

Does it incorporate the Dryad's "Each acre produces food" bonus? (I checked the "Suggested Farms" cell and it doesn't seem to.)

Of course, the final changes don't tell us how many food per acre, so I imagine it'd be hard to incorporate that at this moment, lol.

https://drive.google.com/open?id=0Bz...m1LRVdnNms4LTA

These sheets have it working correctly. Please make sure all credit goes to Crystopher though as it is his thread.

Swagsheet has macro tools such as chain simulation and automated solver-based optimization (no "playing around with variables" necessary). The spreadsheet is just a spreadsheet. For the fearful and non-trusting types.

Quote:

---

Originally Posted by yootohpeega

Does it incorporate the Dryad's "Each acre produces food" bonus? (I checked the "Suggested Farms" cell and it doesn't seem to.)

Of course, the final changes don't tell us how many food per acre, so I imagine it'd be hard to incorporate that at this moment, lol.

---

That's exactly right. Once I know the actual figure then I'll incorporate it into the sheet.

Quote:

---

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

---

I just opened this and it seems wrong?

The default is set to orc wh - which is listed in the sheet as +25 gains (this might be right but thought it was 26%) and +20 offensive and defensive losses?

Quote:

---

Originally Posted by Pillz

I just opened this and it seems wrong?

The default is set to orc wh - which is listed in the sheet as +25 gains (this might be right but thought it was 26%) and +20 offensive and defensive losses?

---

Just to clarify, there's no default, it was just the last race that was tested. Since the gains question is cleared up in your EDIT comment, that just leaves the losses question:

I'm not sure where you're getting +20% offensive/defensive losses, but that's meant to be read as +10% military casualties (which is the same as +10% defensive casualties and +10% offensive casualties).

Ya it was saying - 80 not +110 I just got internally confused and then noticed the hosps which cleared it up for me sorry I that wasn't clear in the edit.

Also it doesn't seem Warrior ome isn't being counted? Trying changing it to war as well.

Quote:

---

Originally Posted by Pillz

Ya it was saying - 80 not +110 I just got internally confused and then noticed the hosps which cleared it up for me sorry I that wasn't clear in the edit.

Also it doesn't seem Warrior ome isn't being counted? Trying changing it to war as well.

---

Ah, I see the confusion on that one. It's being applied to the max offense so it's being counted, but not to the OME value as it should be. I'll have that updated by this evening.

EDIT: Fixed!

Utopia Province Management Spreadsheet v1.4a

Utopia Province Management Spreadsheet v1.4b

== NEW VERSION 1.4b ==

> Now shows scientist spawn rate (including scientists earned per RL day and # of ticks to obtain 1 scientist)
> Now shows current science effectiveness
> Bugfixes

~ COMING SOON ~
> Draft costs included in Econ/Resources section
> Option to show Offense w/ and w/o Mercenaries/Prisoners

Enjoy :)

Looking forward to the changes in 1.4b keep up the good work.

The spreadsheet has been updated with the changes for Age 73! I've also made a few formula improvements and added a few new features:

* You can now choose to add Mercenaries to your offense calcs (mostly for Dryads)
* There is now a setting for EoWCF
* The spreadsheet will now reflect your birth rate (no pezzie/tick calcs, although that may come in a future update)
- With BR being added, I've also added L&P and Storms to the spells section
* There is now a section to calculate training costs and time
* Draft costs have been added to the Economy section (will monitor this as the formula may need further tweaking)

Utopia Province Management Spreadsheet v1.5

As always, let me know if you have any questions about the sheet, or if you spot any errors/bugs that need to be corrected. Enjoy!

Hi, did you take into account the cleric Sci pop bonus?

looking good!

Quote:

---

Originally Posted by adega

Hi, did you take into account the cleric Sci pop bonus?

---

Yes, that was part of the Age 73 changes. You should give it a try first :)

Hey.
I've attached my edit to the Taddy spreadsheet (still requires dl off googledrive). I've been updating off an older version, so there might be some differences in the formula section besides these listed edits.

List of edits:
Removed pastel colors for different colors.
Added a dark theme (easier on the eyes).
Modified the drop-down menus for easier access; can now just click the cell/name without clicking the drop-down arrow.
Added a summary box on the far right.
Moved the spell columns across the bottom.

https://drive.google.com/file/d/0B3g...ew?usp=sharing

I still need to update rituals and such, but it should be pretty stable.

Thanks for the great work you guys put into these!!!

Ok tnx.

Looks good but still cant match the data with exact same entrys on munk.... Labs and Uni numbers are completely off in munk... Maybe the formula needs an update?

Also the opa/dpa numbers dont match either....

Quote:

---

Originally Posted by moogle

Hey.
I've attached my edit to the Taddy spreadsheet (still requires dl off googledrive). I've been updating off an older version, so there might be some differences in the formula section besides these listed edits.

List of edits:
Removed pastel colors for different colors.
Added a dark theme (easier on the eyes).
Modified the drop-down menus for easier access; can now just click the cell/name without clicking the drop-down arrow.
Added a summary box on the far right.
Moved the spell columns across the bottom.

https://drive.google.com/file/d/0B3g...ew?usp=sharing

I still need to update rituals and such, but it should be pretty stable.

Thanks for the great work you guys put into these!!!

---

I mentioned this before in this thread, but I'll say it again: do NOT copy this spreadsheet and pass it off as your own. I have permission from the original creator to maintain this sheet in its original form, and any modifications should be passed through me for approval first. Your sheet is a carbon copy of the one I'm maintaining, right down to the changelog (which you aren't even notating). I have no problem with you creating your own spreadsheet with it's own original layout, but you need to put in the work on your own and not piggyback off the work of others.

Thank you!

Quote:

---

Originally Posted by adega

Ok tnx.

Looks good but still cant match the data with exact same entrys on munk.... Labs and Uni numbers are completely off in munk... Maybe the formula needs an update?

Also the opa/dpa numbers dont match either....

---

Are you referring to my spreadsheet? If so, what numbers and munk entries are you referring to?

Quote:

---

Originally Posted by Crystopher

Are you referring to my spreadsheet? If so, what numbers and munk entries are you referring to?

---

Yes, like i say above, opa and dpa dont match, neither do %effect numbers in labs and universities, try it out and compare numbers

I'm not going to compare my spreadsheet to munk, as that's another tool using the data from Utopia. The values present on my sheet are taken directly from the age changes and the wiki, and they all match.

Could you please PM me a screenshot of what you've entered on the spreadsheet so that I can get a better idea of what's going on?

I can, but if you are not comparing to munk what will u use it for? I was just trying to give you feedback so you could make sure your spreadsheet is uptodate, just dont know who's numbers to trust :)

This tool has absolutely nothing to do with munk; this is a planning resource, not an intel storage. I'm trying to get clarity on the feedback you're offering, because at the moment all you've told me is that it doesn't match munk, which is not what this spreadsheet is using. If you could please provide me a screenshot then that would go much further in shedding light on where the possible issue is.

Btw, at the end of the day, you can always trust the in-game numbers :)

Munk has a feature that is SIM wich lets you simulate numbers for a setup you want. I just did the match between munk and your sheet and numbers are diferent, thats all, i can give you the setup:

UD/WH: 400 acres 17,5% homes, 25% Banks, 10% Guilds, 5% Towers, 10% labs, 22,5% universities, 8% stables, 2% Dungeons

6opa, 2epa, 5dpa and 1 tpa, 0.025 wpa, 48.8 % draft, 100% wages, 4 gens sent, Lord (honor rank)

30 scientists in pop

With these numbers i get diferent opa and dpa when i compare munk sim to this sheet and also diferente %effects from labs and unis

Again, my sheet has nothing to do with munk's tool. This sheet was created using the formulas found on the Utopia Wiki, and I just went through and verified that my spreadsheet matches the formulas found in the wiki. I cannot speak for the discrepancy between my tool and munk's, only that if you're trying to point out errors within mine that you should refer back to the UtoWiki or link me a thread containing the correct info.

With that said, I did notice that on my spreadsheet the offense and defense values (not OPA/DPA) are off by 2.8pts and 1pt respectively. This is well within my margin of error, however, so I'm going to leave it as is. I should note that these calculations I used only 1gen as that's a more realistic scenario and gives a more accurate look at what needs to be corrected.

EDIT: Updated the OP of this thread with a link to the most recent version; not sure why I didn't think to do that sooner.

Quote:

---

Originally Posted by adega

With these numbers i get diferent opa and dpa when i compare munk sim to this sheet and also diferente %effects from labs and unis

---

It should be fairly easy to check whether Munk and/or the spreadsheet is wrong on labs and uni effects given that that there is only one thing in the labs formula (lab effects) and two in unis (uni effects and BE). If you post what Munk is telling you the effect is and what the spreadsheet is saying, then it would be possible to check.

there is an even bigger diference from munk and spreadsheet values compared to utopia numbers...

In munk 22,5% unis at 400 acres protected about 30% science, Spreadsheet 45% but real game protects 86%!!!!

So i guess i'll just try to guess some numbers based on this.

Cheers all and tnx

Quote:

---

Originally Posted by adega

there is an even bigger diference from munk and spreadsheet values compared to utopia numbers...

In munk 22,5% unis at 400 acres protected about 30% science, Spreadsheet 45% but real game protects 86%!!!!

So i guess i'll just try to guess some numbers based on this.

Cheers all and tnx

---

well that is a problem, because the Age changes clearly state;

Quote:

---

Universities - Effects from Universities will be reduced to a maximum reduction of 50%, and the rate of effect will begin at 2.5%

---

It would be dependent on BE, but I believe 22.5% Universities should provide ~35% protection with ~80% BE.

Even last Age I wouldn't expect Unis to protect that much at 22%, it would be more in the 50-60% range

Need to know what BE % that is at (in spreadsheet, munk and game) to be able to check which, if any, is right according to the expected formula.

If the game is saying 86% then I think that may be a bug as it was meant to be changed to cap at 50% - am in a rush now though and maybe missing something obvious.

Edit: RattleHead posted at the same time and said it better :)

Pretty much what Rattlehead said. The wiki has yet to be updated (I'll be getting to it over the next few days if nobody else gets to it first), so if you're going off those numbers then you're incorrect. You gotta remember to verify the new age changes vs the wiki, especially right after an age starts.

Any chance this was reported, or can be confirmed that Uni's are bugged?

Tumbs up for all your work chrystopher!

Quote:

---

Originally Posted by Crystopher

EDIT: Updated for Age 73:
Utopia Province Management Spreadsheet v1.5

----

Hello everyone! Anyone remember that spreadsheet that Tadpole made for macro-level province planning? If you don't, well, it was a pretty awesome tool and I've been using it for the past several ages to plan things out. At some point, around age 64, I didn't see any further updates to it and that made me a little sad. So I've since taken it upon myself to keep it updated for every new age and I thought it'd be nice to share the updated version with the community.

I've actually spoken with Tadpole and ran it by her first; I don't want to take credit for building the sheet (those formulas are beyond me, at least at the moment). I do plan to continue keeping it updated as necessary. I've kept the original layout and functionality, with the exception of the science calculator; the old version let you enter the percentage of books per category to see how many books you would need for each category, while with the new version you enter in the number of books to assign to each category. This was done for my own benefit, so if the older version is preferred I'll work with Tadpole to restore the original functionality.

Please let me know if you encounter any issues with the sheet :)

---

Pretty sure Tadpole is an amphibian and thus should be referred to as an 'it'. Stupid Tadpole who disbanded Roughknecks and made me loose my Icecream Truck full of unwilling gurlz :(

Thank you Tadpole and Crystopher! This is gold!!

Quote:

---

Originally Posted by Winter Lady

Thank you Tadpole and Crystopher! This is gold!!

---

Thanks :)

Crystropher: +OME Honor bonus in OME cell G39 is multiplied, but should be additive. So should read (G37+N13+C40)... and not G37+N13*(1+C40).

Cant wait for the new sheet :D

Ya, hurry up! :P

Quote:

---

Originally Posted by Tadpole

Thanks :)

Crystopher: +OME Honor bonus in OME cell G39 is multiplied, but should be additive. So should read (G37+N13+C40)... and not G37+N13*(1+C40).

---

Thanks Taddy! I'll get that corrected ASAP :)

@oreko and Rattlehead: Comin right up, I should have it completed by EOD tomorrow :)

I've been on a bit of a hiatus due to RL issues, but I'm back and raring to get back into Uto!

Good to hear! Looking forward to it