Page 11 of 12 FirstFirst ... 9101112 LastLast
Results 151 to 165 of 180

Thread: Province Management Spreadsheet

  1. #151
    Post Fiend
    Join Date
    Sep 2008
    Posts
    171
    is it just me or the draft costs is off on the main sheet?
    Original wearer of the Raikonhat

  2. #152
    Forum Fanatic octobrev's Avatar
    Join Date
    Oct 2008
    Location
    us
    Posts
    2,509
    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~

  3. #153
    Veteran
    Join Date
    Jan 2012
    Posts
    787
    Such helpful this Octo.

  4. #154
    Post Fiend Crystopher's Avatar
    Join Date
    Aug 2008
    Posts
    252
    Quote Originally Posted by Raikon View Post
    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 View Post
    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 :)

  5. #155
    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

  6. #156
    Member
    Join Date
    Jun 2010
    Posts
    31
    Any update for age 76?

  7. #157
    Post Fiend Crystopher's Avatar
    Join Date
    Aug 2008
    Posts
    252
    Quote Originally Posted by oreko View Post
    Any update for age 76?
    Currently working on it, it should be up within the hour :)

  8. #158
    Member
    Join Date
    Apr 2013
    Posts
    12
    Hi there, just a quick note:

    DS bonus is not getting applyed in defense mWPA

  9. #159
    Post Fiend Crystopher's Avatar
    Join Date
    Aug 2008
    Posts
    252
    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

  10. #160
    Member
    Join Date
    Jun 2010
    Posts
    31
    Much appreciated!

  11. #161
    Member
    Join Date
    Jun 2010
    Posts
    31
    Looks like softcap needs to be updated on sci, 35 across the board.

  12. #162
    Veteran
    Join Date
    Jan 2012
    Posts
    787
    Also, power rankings included in the sheet this time! Compare races! Much exciting! :)

  13. #163
    Post Fiend Crystopher's Avatar
    Join Date
    Aug 2008
    Posts
    252
    Quote Originally Posted by oreko View Post
    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

  14. #164
    Enthusiast
    Join Date
    Apr 2011
    Location
    Estonia
    Posts
    330
    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.
    Last edited by HoneyBadger; 01-05-2018 at 12:15.

  15. #165
    Enthusiast
    Join Date
    Apr 2011
    Location
    Estonia
    Posts
    330
    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)

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 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
  •