Province Management Spreadsheet

Printable View

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

23-04-2018, 19:46
oreko

Looks like softcap needs to be updated on sci, 35 across the board.
23-04-2018, 20:54
Tadpole

Also, power rankings included in the sheet this time! Compare races! Much exciting! :)
23-04-2018, 22:58
Crystopher

Quote:

Originally Posted by oreko

Looks like softcap needs to be updated on sci, 35 across the board.

Yea, I was waiting to verify values in-game, they've been added
01-05-2018, 12:10
HoneyBadger

Hey, i have been using your spreadsheet, excellent job, thank you! I did fill up my numbers (triple checked) and everything else is spot on, but wizards trained per day is +2,0 off than it is in game. Didnt manage to figure it out myself, so decided to ask here if you could take a look. Thanks!

EDIT: Im an Elf/Heretic.
01-05-2018, 15:39
HoneyBadger

Okei, if I remove "*G8" from the first part then it gives correct answer.

Guilds effect formula: =(L21*0,02*G8)*LOOKUP(C5;Y19:Y27;AE19:AE27)
01-05-2018, 16:48
Crystopher

Quote:

Originally Posted by HoneyBadger

Hey, i have been using your spreadsheet, excellent job, thank you! I did fill up my numbers (triple checked) and everything else is spot on, but wizards trained per day is +2,0 off than it is in game. Didnt manage to figure it out myself, so decided to ask here if you could take a look. Thanks!

EDIT: Im an Elf/Heretic.

Looks like it was a holdover from a previous debate about whether or not guilds were affected by BE. I just got confirmation on it and will have it updated this afternoon. Thanks :)
19-05-2018, 09:11
GhettoWitch

Wanted to take a second to thank you for this. It has been a great tool for me and I appreciate you keeping it up. It really has made my province management much easier!
26-05-2018, 12:58
Tadpole

Quote:

Originally Posted by GhettoWitch

Wanted to take a second to thank you for this. It has been a great tool for me and I appreciate you keeping it up. It really has made my province management much easier!

yw! :)
03-06-2018, 02:05
Crystopher

Quote:

Originally Posted by GhettoWitch

Wanted to take a second to thank you for this. It has been a great tool for me and I appreciate you keeping it up. It really has made my province management much easier!

You're very welcome, sorry for taking so long to respond to this (RL issues). I'm glad that y'all are getting mileage out of this, and I'll keep this up as long as the community needs :)

Hats off to Tadpole for creating it and helping me with some of her more complex formulas ;P
09-07-2018, 15:43
Crystopher

Hey all!

The spreadsheet will be updated the night after Final Changes come out (Sunday, July 15th), barring any unforeseen delays. As always, the link to the sheet can be found in the first post of this thread.

Thank you! :)
14-07-2018, 13:39
Crystopher

Since the Final Changes were released a day early, I thought it'd be fitting to release this update a day early as well :)

The sheet has now been updated with all Age 77 changes; as always, the link can be found in the first post of this thread. If you find any bugs, please let me know here and I'll address them in the next few days.

Thank you!
14-07-2018, 13:54
vipbluesky

Thanks for the quick work.
14-07-2018, 19:30
djakdarippa

Good work as always!

Just a quick question. Have honour bonuses changed? Yours are different compared to the wiki.
15-07-2018, 00:49
oreko

<3 ty sir!
15-07-2018, 02:24
Crystopher

Quote:

Originally Posted by djakdarippa

Good work as always!

Just a quick question. Have honour bonuses changed? Yours are different compared to the wiki.

Thank you!

No, the honor bonuses haven't changed. The values in the sheet are the exact same as found in the wiki. They're expressed as a percentage, which could be why they appear differently.
15-07-2018, 08:35
djakdarippa

Quote:

Originally Posted by Crystopher

Thank you!

No, the honor bonuses haven't changed. The values in the sheet are the exact same as found in the wiki. They're expressed as a percentage, which could be why they appear differently.

Yes, my bad, mixed up Knight/Lady with Lord/Noble Lady!
16-07-2018, 01:32
Avenger

Sci spawn rate is more like 9.5 btw, I initially set a placeholder 10 in wiki, then the *expected* 7.5*1.3 = 9.75 or 9.7 floor but that was not the case.
16-07-2018, 13:45
Crystopher

Quote:

Originally Posted by Avenger

Sci spawn rate is more like 9.5 btw, I initially set a placeholder 10 in wiki, then the *expected* 7.5*1.3 = 9.75 or 9.7 floor but that was not the case.

Can you tell me how you determined it to be 9.5 vs the 9.75? I thought the only way to know for sure was for age to start and monitor the progression. I'll update the sheet with the proper value once it's confirmed.
16-07-2018, 16:46
Avenger

Monitored progression over 10+ ticks on the test server :)
16-07-2018, 18:11
Crystopher

Quote:

Originally Posted by Avenger

Monitored progression over 10+ ticks on the test server :)

Touche lol, I forgot about the test server :D
06-10-2018, 13:36
Crystopher

I'll be working over the weekend to get the sheet updated, but I don't expect to have it finished until Monday at the earliest. The science changes particularly will take a bit of time to work out.
07-10-2018, 18:07
Crystopher

The latest version is now available for download. Please see the first post for the download link.

As always, let me know if you encounter any bugs/issues so that I can fix them ASAP. Thanks :)
08-10-2018, 11:52
Haas

Looks good! I'll try it this age.
08-10-2018, 17:59
Bo To

In the wiki there is some info about the new sci(from the test server).
08-10-2018, 19:14
Tadpole

Quote:

Originally Posted by Bo To

In the wiki there is some info about the new sci(from the test server).

Numbers seem to deviate quite a bit from test server. WoL seems to be the new test server...

Thx Chrystopher for the update.
08-10-2018, 20:30
Crystopher

Quote:

Originally Posted by Tadpole

Numbers seem to deviate quite a bit from test server. WoL seems to be the new test server...

Thx Chrystopher for the update.

And diminishing returns are going to make this a NIGHTMARE to formulate. I'll be pretty busy with that for awhile :P

Thanks Taddy, it's a labor of love at this point, even if it makes me wanna tear my hair out :D
09-10-2018, 23:44
Tadpole

Quote:

Originally Posted by Crystopher

And diminishing returns are going to make this a NIGHTMARE to formulate. I'll be pretty busy with that for awhile :P

Thanks Taddy, it's a labor of love at this point, even if it makes me wanna tear my hair out :D

All in the wiki now :)
10-10-2018, 04:07
Crystopher

Quote:

Originally Posted by Tadpole

All in the wiki now :)

My heroine <3
10-10-2018, 04:30
Niko

Y'all are both heroes for doing this. Thank you. :)
17-10-2018, 21:08
Tadpole

Oki - updated the sheet so that sci works. Mods might be a lil off, but should work nicely for now.

Power ranking sheet is up to date too.

https://drive.google.com/file/d/1ssX...ew?usp=sharing
22-10-2018, 13:35
Crystopher

Quote:

Originally Posted by Tadpole

Oki - updated the sheet so that sci works. Mods might be a lil off, but should work nicely for now.

Power ranking sheet is up to date too.

https://drive.google.com/file/d/1ssX...ew?usp=sharing

You're a saint <3

EDIT - 10/24/18: First post has been updated with link to latest version.

- Incorporated Tadpole's changes into main sheet (checkboxes were lost in latest update, they've now been restored)
18-11-2018, 00:25
Crystopher

This sheet has been updated for Age 79. Please see the first post for link.
24-11-2018, 02:30
kalorful

A few comments:

1. Cell N28 - School's efficiency formula is mislinked to watch tower
2. Cell 032 - dungeons hold 30 prisoners not 20

Thanks for all the hard work!
27-11-2018, 15:59
Xhavez

Fantastic file! Love the work that's been put into it. Simply amazing!

I did notice the Books/Tick needed updated to reflect the lower amount in the new age.

Recruit: 100 (same)
Novice: 150
Graduate: 200
Professor: 250
04-02-2019, 15:11
djakdarippa

Will we be getting a new one this age? Hope so!
10-02-2019, 17:46
Tadpole

Quote:

Originally Posted by djakdarippa

Will we be getting a new one this age? Hope so!

I'll wait a few days on chrystopher, or I'll update it myself with age changes. Might need a reminder on discord though.
08-03-2019, 20:48
honda910

Is it available?
28-04-2019, 18:33
Tadpole

The prov sheet has been updated, and a few more calc sheets added.

It's now a google sheet, and I've been dealing with a quite outdated sheet, so will be bugs and **** in it. I figured I'd push it out sooner rather than later for people to play around with though.

Please do contact me if you noticed bugs or faulty formulas and stuff like that. Posting in here or discord or whatevs.

For link, contact me on discord. You can copy it from there and share with people.

I know I've said I'd release a kd prep sheet too. But meh. Need some more bug testing. Perhaps later in age :)
07-05-2019, 22:51
Crystopher

Quote:

Originally Posted by Tadpole

The prov sheet has been updated, and a few more calc sheets added.

It's now a google sheet, and I've been dealing with a quite outdated sheet, so will be bugs and **** in it. I figured I'd push it out sooner rather than later for people to play around with though.

Please do contact me if you noticed bugs or faulty formulas and stuff like that. Posting in here or discord or whatevs.

For link, contact me on discord. You can copy it from there and share with people.

I know I've said I'd release a kd prep sheet too. But meh. Need some more bug testing. Perhaps later in age :)

Thanks for taking care of this Taddy :)

I started a new job a few months ago that's taken up the majority of my time and so I've stepped away from Uto for a bit until I can find my pace again. I still try to check in here every so often tho... :)
23-07-2019, 23:36
Avenger

https://docs.google.com/spreadsheets...SFgEhGVrE/copy

Age 82 update, please create a copy of the sheet when playing around with it.

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

All times are GMT. The time now is 15:32.

MUGA GAMING, LLC