is it just me or the draft costs is off on the main sheet?
Printable View
is it just me or the draft costs is off on the main sheet?
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~
Such helpful this Octo.
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
Any update for age 76?
Hi there, just a quick note:
DS bonus is not getting applyed in defense mWPA
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
Much appreciated!
Looks like softcap needs to be updated on sci, 35 across the board.
Also, power rankings included in the sheet this time! Compare races! Much exciting! :)
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.
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)