Province Management Spreadsheet

Printable View

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

04-11-2017, 12:57
Tadpole

Quote:

Originally Posted by Crystopher

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... was worried I'd have to update it myself :p
04-11-2017, 17:39
Crystopher

First post updated with link to latest version! :)
04-11-2017, 18:09
djakdarippa

I think you forgot about Dryad's different off values for Horses/Prisoners/Mercs
Also, really not liking cells being locked!

Otherwise stellar job!
04-11-2017, 23:45
Crystopher

Quote:

Originally Posted by djakdarippa

I think you forgot about Dryad's different off values for Horses/Prisoners/Mercs

Nope, it's in there. You have to add Stables and/or # of Mercs you're sending for it to actually show up in your offense. I did notice that the actual value for Dryad's horses was 3 instead of 4, and this has been corrected.

Quote:

Originally Posted by djakdarippa

Also, really not liking cells being locked!

What's not to like about it? The green cells are the only ones that need to be edited, so it shouldn't be an issue.

Quote:

Originally Posted by djakdarippa

Otherwise stellar job!

Thanks :)
05-11-2017, 00:03
SBWildFire

hey crystopher first off thanks for a great tool!

I found an issue where dryads do not have food produced by non farms being accounted for. think you can get that fixed up?

Thanks!
05-11-2017, 01:30
Crystopher

Quote:

Originally Posted by SBWildFire

hey crystopher first off thanks for a great tool!

I found an issue where dryads do not have food produced by non farms being accounted for. think you can get that fixed up?

Thanks!

Ah, I knew I'd forgotten something! I think I was waiting to discover just how much food they produced and forgot about it. I'm asking my KD now, but if anyone could tell me the amount of food each acre produces then I'll have the sheet updated right away :)
05-11-2017, 02:14
RattleHead

same as old shepherd, 4/acre
05-11-2017, 02:52
oreko

Thanks a ton for this Crystopher!
05-11-2017, 03:32
oreko

Looks like bocan offense and defense values are swapped. Has 4 as defense and 7 as offense.
05-11-2017, 05:40
Crystopher

Quote:

Originally Posted by RattleHead

same as old shepherd, 4/acre

Thanks! I've updated this on the sheet. Seeing it in raw numbers, that's a pretty significant boost there O.O

Quote:

Originally Posted by oreko

Looks like bocan offense and defense values are swapped. Has 4 as defense and 7 as offense.

D'oh, I was afraid I did that with one of the races. It's due to the fact that the columns are displayed with defense before offense. I've fixed this and also swapped the columns so I don't do it in the future :P

Thanks for the feedback everyone :)
05-11-2017, 17:43
adega

One more thing Crys,

Seems like sending one gen or 4 gens gets you the same off, is that ok or needs a tweek?
05-11-2017, 18:40
RattleHead

man i find that general calculation annoying on my sheet too! easier when no race has modified gens...

you should get a +0.03 OME, for each general above the original one to be sent, so 4 gens should be +0.09 OME as far as I know
05-11-2017, 19:07
Tadpole

Cool! Thx Chrystopher! Awesome work keeping this updated.

One thing though, I'm not sure I like protecting the sheet. For the reason of someone not messing up formulas by mistake I get it. But I didn't release it to the public to have it protected. I think its nice if people want to modify it to their own needs/try change or optimise the formulas... freedom of information and creativity and all. The problem of people stealing and passing it off as their own should be rather minimal in this environment anyhow...

Quote:

Originally Posted by RattleHead

man i find that general calculation annoying on my sheet too! easier when no race has modified gens...

you should get a +0.03 OME, for each general above the original one to be sent, so 4 gens should be +0.09 OME as far as I know

Hmm, yea. Something seems off with the "off" formula with regards to generals. It does add off sending more, but only a tiny bit. I haven't looked at the formula though. I'm sure Chrystopher will find whats wrong :)
06-11-2017, 14:30
Crystopher

EDIT: The issue with the generals has been fixed! The problem was with the formula being multiplied by zero if there were no Stables/Dungeons added. This was fixed by moving the generals calculation from Mod Offense to OME (which, incidentally, is where it belongs). Let me know if there's anything else I've missed :)

Quote:

Originally Posted by adega

One more thing Crys,

Seems like sending one gen or 4 gens gets you the same off, is that ok or needs a tweek?

HM, I just reviewed the formula and it's present there, but you're right that it's not contributing for some reason. I'll give it an in-depth look and have it fixed ASAP.

Quote:

Originally Posted by Tadpole

One thing though, I'm not sure I like protecting the sheet. For the reason of someone not messing up formulas by mistake I get it. But I didn't release it to the public to have it protected. I think its nice if people want to modify it to their own needs/try change or optimise the formulas... freedom of information and creativity and all. The problem of people stealing and passing it off as their own should be rather minimal in this environment anyhow...

Can't argue with that, very valid points. The current version shouldn't have any protection, but I'll double-check it just to be sure.
07-11-2017, 07:19
Tadpole

Coolio.

Dryad food production from acres is apparently enhanced by production sci. Don't think the sheet takes that into consideration...
30-12-2017, 10:33
t8x

i tried the spreadsheet. Everything looks good but sci on Thievery getting away with like 10%.
pessies are like 1k under in what i have in utopia. maybe i have done something wrong ?
27-01-2018, 13:13
Maeldun

Hoping for an update =)
28-01-2018, 02:36
ellivort

Prob going to take time since devs dragged ass posting final changes
28-01-2018, 02:39
Crystopher

Quote:

Originally Posted by ellivort

Prob going to take time since devs dragged ass posting final changes

Actually, this sheet is maintained by a player (me), and it'll be updated in my spare time. You'd know that if you actually read the first thread before taking a potshot at the devs for w/e reason :)
28-01-2018, 03:02
ellivort

I know it's maintained by you. Pot shot? It's Pure fact. Final changes AFTER freeze start = drag ass

If you had reading comp skills youd have understood I was saying update would be delayed since final changes were so late. Not that the devs do the updating.

Is there some prize for dev ass kissing?
28-01-2018, 03:55
Maeldun

Welcome to the internet, where every comment transforms into an argument. An argument I. Must. Win.
28-01-2018, 03:59
RattleHead

Hahaha, just ridiculous!

Keep up the good work Crys
28-01-2018, 23:29
octobrev

I suppose you can borrow this one until the devs let Crystopher finish his. Just please be sure to return it here when you're done as it's the only copy I have. :(

It definitely needs to be opened in excel to work and some other things if you want to use all the macro tools.~
29-01-2018, 12:47
toolian

Quote:

Originally Posted by octobrev

I suppose you can borrow this one until the devs let Crystopher finish his. Just please be sure to return it here when you're done as it's the only copy I have. :(

It definitely needs to be opened in excel to work and some other things if you want to use all the macro tools.~

computer says file is corrupted and won't open it
29-01-2018, 16:19
Crystopher

Update complete! Please use the link in the 1st post to view and download the sheet.

CLOSING NOTES FROM CHANGELOG:

I'm currently looking over the sheet to see where I can either add improvements or useful features. I'll also be updating the formulas for buildings once their values are known, and in the meantime I'll be looking over the draft cost formula to see where the bug is (cost isn't calculating properly). If anyone discovers the aforementioned values prior to an update, please be sure to let me know in the Utopia Wiki Questions and Edits thread!
30-01-2018, 01:49
Maeldun

<3 chrys, thanks a lot. I use the spreadsheet quite a bit.
30-01-2018, 15:53
Tadpole

Quote:

Originally Posted by octobrev

I suppose you can borrow this one until the devs let Crystopher finish his. Just please be sure to return it here when you're done as it's the only copy I have. :(

It definitely needs to be opened in excel to work and some other things if you want to use all the macro tools.~

It's a trap! macro for auto-access to your province courtesy of the black book of octo!! :P

Nice work Chrystofer, thx for keeping my lil darlin' up to date :)

Had always hoped to implement some race power-ranking/comparison with neat charts into the sheet at some point. But, well, teasing octo takes all my spare time away :(
30-01-2018, 20:55
octobrev

Omg a Tadpole! <33 You guys wanna 2v1 feature build? Competition is great for innovation and it sounds like you both have some things you want to add.

https://i.imgur.com/G3524Ml.png + https://i.imgur.com/IUFOGjn.png VS https://i.imgur.com/XfpUpHG.png !

Quote:

Originally Posted by toolian

computer says file is corrupted and won't open it

Dunno about that corruption business. Mayhaps a bit was flipped during download or an older version of excel was used? There are some known compatibility issues between versions relating to protected view.~
30-01-2018, 21:05
RattleHead

For what it is worth, I was able to make it load properly. Just dl and open worked for me :/

I also have a province sheet, which is what I have been using to create the posted Power Rankings for last few Ages, since Ethan had a brief hiatus.

Crys has a copy of mine from a few ages back, its pretty simple compared to you guy's
30-01-2018, 22:23
octobrev

Ahh upon zooming in I do now see your headset. Better pick a team!

https://i.imgur.com/EVdak2C.png
03-02-2018, 06:08
Raikon

is it just me or the draft costs is off on the main sheet?
03-02-2018, 17:58
octobrev

This is the correct formula: =LOOKUP(C12,BB17:BB21,BD17:BD21)*MAX(1,1.0154*((D29+D30+D31+D32)/D37)^2+1.1759*((D29+D30+D31+D32)/D37)+0.3633)*G20*IF(C15=TRUE,0.5,1)*(1-N15)*IF(C4=Y14,0,1)

There was a small error in the hypnotic series of parenthesizes~
04-02-2018, 10:30
Tadpole

Such helpful this Octo.
12-02-2018, 15:05
Crystopher

Quote:

Originally Posted by Raikon

is it just me or the draft costs is off on the main sheet?

Yes, I noted that in the changelog :)

Quote:

Originally Posted by Crystopher

Update complete! Please use the link in the 1st post to view and download the sheet.

CLOSING NOTES FROM CHANGELOG:

[I]I'll also be updating the formulas for buildings once their values are known, and in the meantime I'll be looking over the draft cost formula to see where the bug is (cost isn't calculating properly).[/I]

@Octo: You da real MVP. Thanks :)
25-02-2018, 06:19
an|on

Utopia Province Spreadsheet v1.7.1 (Age 75)
docs.google.com/spreadsheets/d/1-UFEqAo-OnZ2WWUJLVml2bg9CM9-WdawvQOc2igY9Sk/

---

- Added Ambush calc. to Prov. Sheet
- Added WPA calc. to Prov. Sheet
- Added OverPop calc. to Prov. Sheet
- Added NW Range calc. to Prov. Sheet
- Added Ceasefire Optimizer (in-progress)
- Optimized elements/modules to focus user input
- Changed color scheme
23-04-2018, 00:06
oreko

Any update for age 76?
23-04-2018, 15:28
Crystopher

Quote:

Originally Posted by oreko

Any update for age 76?

Currently working on it, it should be up within the hour :)
23-04-2018, 15:31
adega

Hi there, just a quick note:

DS bonus is not getting applyed in defense mWPA
23-04-2018, 15:56
Crystopher

The first post has been updated with the latest version, v1.8! The following features have been added:

- Ambush Calculator
- Target "to break" Calculator
- Attack times for each attack type

* See changelog for full list of updates
23-04-2018, 19:38
oreko

Much appreciated!

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