Originally Posted by
Taint
Phorcys set bonus is not accounted for
If you feel ambitious you can make it automatically account for phorcys set bonus.
The "Gear" page has cell protection so you can't fiddle with certain cells. You'll have to turn that off. I am not sure exactly how to do with Excel to be honest though, as I use a different program.
Code:
+IF(COUNTIF(B3:B17,"Phorcys")=5,15,IF(COUNTIF(B3:B17,"Phorcys")=4,10,IF(COUNTIF(B3:B17,"Phorcys")=3,5,IF(COUNTIF(B3:B17,"Phorcys")=2,2,0))))
Add this to cells D20, G20, H20 and I20
Code:
+IF(COUNTIF(B25:B39,"Phorcys")=5,15,IF(COUNTIF(B25:B39,"Phorcys")=4,10,IF(COUNTIF(B25:B39,"Phorcys")=3,5,IF(COUNTIF(B25:B39,"Phorcys")=2,2,0))))
Add this to cells D42, G42, H42 and I42
Code:
+IF(COUNTIF(AB3:AB17,"Phorcys")=5,15,IF(COUNTIF(AB3:AB17,"Phorcys")=4,10,IF(COUNTIF(AB3:AB17,"Phorcys")=3,5,IF(COUNTIF(AB3:AB17,"Phorcys")=2,2,0))))
Add this to cells AD20, AG20, AH20 and AI20
Code:
+IF(COUNTIF(AB25:AB39,"Phorcys")=5,15,IF(COUNTIF(AB25:AB39,"Phorcys")=4,10,IF(COUNTIF(AB25:AB39,"Phorcys")=3,5,IF(COUNTIF(AB25:AB39,"Phorcys")=2,2,0))))
Add this to cells AD42, AG42, AH42 and AI42
Example: Cell AD20 currently is You want it to be
Code:
=SUM(AD3:AD18)+IF(COUNTIF(AB3:AB17,"Phorcys")=5,15,IF(COUNTIF(AB3:AB17,"Phorcys")=4,10,IF(COUNTIF(AB3:AB17,"Phorcys")=3,5,IF(COUNTIF(AB3:AB17,"Phorcys")=2,2,0))))
Changing those cells will make the total stats rows account for Phorcys Set Bonuses so you no longer have to manually enter them into the set bonus rows.