Page 15 of 16 FirstFirst ... 513141516 LastLast
Results 211 to 225 of 229

Thread: Province Management Spreadsheet

  1. #211
    Director of Age Changes
    Join Date
    Nov 2008
    Location
    EU
    Posts
    1,936
    Soon™
    Discord: Hex | IRC: Hextor / Avenger

  2. #212
    Post Fiend Crystopher's Avatar
    Join Date
    Aug 2008
    Location
    Minnesota, USA
    Posts
    281
    Update complete. Enjoy :)

  3. #213
    Post Fiend
    Join Date
    Aug 2009
    Posts
    286
    Quote Originally Posted by Crystopher View Post
    Update complete. Enjoy :)
    Thanx, bro!
    #Plaidovia

  4. #214
    Member
    Join Date
    Jan 2017
    Posts
    24
    Some things seem incomplete on the new updated sheet, getting some errors and looked like some values were old

  5. #215
    Post Fiend Crystopher's Avatar
    Join Date
    Aug 2008
    Location
    Minnesota, USA
    Posts
    281
    I've taken another look and it appears the sciences values are off. I'll be working on that over the weekend and any information y'all could provide would be much appreciated?

    Quote Originally Posted by Mrboombastic View Post
    Some things seem incomplete on the new updated sheet, getting some errors and looked like some values were old
    Can you give me some specifics?

  6. #216
    Post Fiend Crystopher's Avatar
    Join Date
    Aug 2008
    Location
    Minnesota, USA
    Posts
    281
    Made updates to the way the sheet handles rituals and fixed the "Training Costs & Time" section. Details below:

    v 2.4a - Crystopher revisions 3/25/2020
    ->FORMULA UPDATES
    --Moved Ritual Strength (B18) to new cell (B19)
    --Renamed Ritual Strength (B18) to Ritual Casts
    --Added ritual effectiveness formula to (C19)
    --Fixed training cost formulas (G53-G55) to accurately reflect training discount from Expedient
    --Fixed training time formula (I56) to accurately reflect training discount from Expedient
    --Updated training time formula (I56) to account for Avian racial bonus

    EDIT: Science values are still off, currently researching the proper values/formulas

  7. #217
    Post Fiend Crystopher's Avatar
    Join Date
    Aug 2008
    Location
    Minnesota, USA
    Posts
    281
    Updated complete, see changelog below :)

    v 2.5 - Crystopher revisions 5/16/2020
    - Fully updated for Age 86

    ->FORMULA UPDATES

    --Fixed max population formula (D37) to properly calculate pop and incorporate Halfling racial bonus
    --Fixed Offense per Acre formulas (H30, H31) to properly calculate Human racial bonus to War Horse strength
    --Fixed Training cost formulas (G53-G55) to properly reflect Halfing racial bonus
    Last edited by Crystopher; 16-05-2020 at 15:58. Reason: Updated

  8. #218
    Post Fiend Crystopher's Avatar
    Join Date
    Aug 2008
    Location
    Minnesota, USA
    Posts
    281
    v 2.5a - Crystopher revisions 5/26/2020
    -> FORMULA UPDATES
    --Fixed Thieves Dens formulas (N23, N24) to account for personality bonuses

  9. #219
    Member
    Join Date
    Oct 2008
    Posts
    41
    Thanks for this! I think there's a small bug with the networth formula at the end where it should be a + rather than a * between the prisoners & science components.

  10. #220
    Post Fiend Crystopher's Avatar
    Join Date
    Aug 2008
    Location
    Minnesota, USA
    Posts
    281
    Hey y'all, I'm currently working on updating the sheet and plan to have it completed by tomorrow evening. I've been getting quite a few requests for access and want to remind everyone that you'll need to save a copy yourself to use it properly.

  11. #221
    Post Fiend Crystopher's Avatar
    Join Date
    Aug 2008
    Location
    Minnesota, USA
    Posts
    281
    Update complete with all age changes! Enjoy :)

  12. #222
    Member
    Join Date
    Sep 2014
    Location
    UK
    Posts
    10
    Quote Originally Posted by Crystopher View Post
    Update complete with all age changes! Enjoy :)

    awesome thanks

  13. #223
    Post Fiend Crystopher's Avatar
    Join Date
    Aug 2008
    Location
    Minnesota, USA
    Posts
    281
    One last little update :D

    v 2.6a - Crystopher revisions 7/21/2020
    -> FORMULA UPDATES
    --Updated Base ME formula (G38) for Age 87 changes

  14. #224
    Post Fiend Crystopher's Avatar
    Join Date
    Aug 2008
    Location
    Minnesota, USA
    Posts
    281
    Another update has been released to address a bug with the Honor formula for WPA/TPA.

    v 2.6b - Crystopher revisions 7/28/2020
    - Cleaned up Honor formula section for greater clarity (expanded decimals, updated wording)
    -> FORMULA UPDATES
    --Fixed Honor formula for WPA/TPA (C42) to calculate bonus properly

  15. #225
    Post Fiend Crystopher's Avatar
    Join Date
    Aug 2008
    Location
    Minnesota, USA
    Posts
    281
    v 2.6c - Crystopher revisions 8/18/2020
    -> FORMULA UPDATES
    --Fixed a bug with the Networth formula (C8), was previously multiplying NW of books instead of adding

Thread Information

Users Browsing this Thread

There are currently 7 users browsing this thread. (0 members and 7 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •