is it just me or the draft costs is off on the main sheet?
is it just me or the draft costs is off on the main sheet?
Original wearer of the Raikonhat
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~
theHERETICS - Brute Force - Sonata - Dreams - The Pulsing Trollfags - The Expendables
Visit my home for banned, neglected, and otherwise disenfranchised players on Discord!
Such helpful this Octo.
RoughKnecS
--> Want art? <--
--> Or see Tadpole banners? <--
The industrys greats
** Cerberus ** Killah ** Shadowheart **
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! :)
RoughKnecS
--> Want art? <--
--> Or see Tadpole banners? <--
The industrys greats
** Cerberus ** Killah ** Shadowheart **
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.
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)
There are currently 3 users browsing this thread. (0 members and 3 guests)