Province Management Spreadsheet

[rob418]

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.

[Tadpole]

Absolutely this started off as your spreadsheet

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

... hrm

[Crystopher]

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.

[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

[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.

[bdbcoyote]

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

[octobrev]

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

[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.

[Crystopher]

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.

[octobrev]

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.

[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.

[Crystopher]

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

[Crystopher]

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 :)

[Raikon]

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

[Crystopher]

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!