Page 11 of 11 FirstFirst ... 91011
Results 151 to 155 of 155

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,447
    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
    753
    Such helpful this Octo.

  4. #154
    Post Fiend Crystopher's Avatar
    Join Date
    Aug 2008
    Posts
    238
    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

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
  •