BPC Runs miscalculation

gbrann / EVEProductionSuite

Eve Online - Production Suite is a set of Google and ESI tools to quickly and easily manage production, budget and basic corporate management with installing servers or adding any RL costs to your game play.

GNU General Public License v3.0

3 stars 0 forks source link

BPC Runs miscalculation #6

Closed wytsa closed 6 years ago

wytsa commented 6 years ago

sumif statement is throwing issue with if statement apparently removing access to range insumif

issue: =SUMIF('GESI-BLUEPRINTS'!$I:$I, concat($A4," Blueprint"), if('GESI-BLUEPRINTS'!$F:$F>0,'GESI-BLUEPRINTS'!$F:$F,0))

changed to: =SUMIF('GESI-BLUEPRINTS'!$I:$I, concat($A4," Blueprint"), 'GESI-BLUEPRINTS'!$F:$F)

will need to go over formula to remove counting of BPOs -1 in the sum

wytsa commented 6 years ago

corporate stock tab:

capital component BPCs and capital hull BPCs are now calculated correctly with only counting BPC runs

other sections of corporate stock sheet need updated as the above parts have been.

wytsa commented 6 years ago

new formula on corp stock tab: =SUMIFS('GESI-BLUEPRINTS'!$F:$F,'GESI-BLUEPRINTS'!$H:$H,vlookup(concat($A13," blueprint"),VLOOKUP!$B:$C,2,false),'GESI-BLUEPRINTS'!$F:$F,">0") janitors and marines formula pulls from gesi-assets