There is a bug with D.Ball that I haven't seen mentioned yet - in AC191:AE203 (and all copies), the indexing into the attacking units do not match up. This causes other formulae to fail.
To fix, I believe you should replace:
Code:
DB
Unit Attack Speed
AO =IF(AF$11<=Z3,$D74*AB371,0) =IF(AB371<1,0,IF(AF$11<=Z3,$F74,0))
AW =IF(AF$11<=Z4,$D75*AB372,0) =IF(AB372<1,0,IF(AF$11<=Z4,$F75,0))
Asc =IF(AF$11<=Z5,$D76*AB373,0) =IF(AB373<1,0,IF(AF$11<=Z5,$F76,0))
AP =IF(AF$11<=Z6,$D77*AB374,0) =IF(AB374<1,0,IF(AF$11<=Z6,$F77,0))
AS =IF(AF$11<=Z7,$D78*AB375,0) =IF(AB375<1,0,IF(AF$11<=Z7,$F78,0))
AC =IF(AF$11<=Z8,$D79*AB376,0) =IF(AB377<1,0,IF(AF$11<=Z9,$F80,0))
Aph =IF(AF$11<=Z9,$D80*AB377,0) =IF(AB378<1,0,IF(AF$11<=Z10,$F81,0))
AR =IF(AF$11<=Z10,$D81*AB378,0) =IF(AB380<1,0,IF(AF$11<=Z12,$F83,0))
AA =IF(AF$11<=Z11,$D82*AB379,0) =IF(AB376<1,0,IF(AF$11<=Z8,$F79,0))
AB =IF(AF$11<=Z12,$D83*AB380,0) =IF(AB379<1,0,IF(AF$11<=Z11,$F82,0))
Acat =IF(AF$11<=Z13,$D84*AB381,0) =IF(AB381<1,0,IF(AF$11<=Z13,$F84,0))
with:
Code:
DB
Unit Attack Speed
AO =IF(AF$11<=Z3,$D74*AB371,0) =IF(AB371<1,0,IF(AF$11<=Z3,$F74,0))
AW =IF(AF$11<=Z4,$D75*AB372,0) =IF(AB372<1,0,IF(AF$11<=Z4,$F75,0))
Asc =IF(AF$11<=Z5,$D76*AB373,0) =IF(AB373<1,0,IF(AF$11<=Z5,$F76,0))
AP =IF(AF$11<=Z6,$D77*AB374,0) =IF(AB374<1,0,IF(AF$11<=Z6,$F77,0))
AS =IF(AF$11<=Z7,$D78*AB375,0) =IF(AB375<1,0,IF(AF$11<=Z7,$F78,0))
AC =IF(AF$11<=Z9,$D80*AB377,0) =IF(AB377<1,0,IF(AF$11<=Z9,$F80,0))
Aph =IF(AF$11<=Z10,$D81*AB378,0) =IF(AB378<1,0,IF(AF$11<=Z10,$F81,0))
AR =IF(AF$11<=Z12,$D83*AB380,0) =IF(AB380<1,0,IF(AF$11<=Z12,$F83,0))
AA =IF(AF$11<=Z8,$D79*AB376,0) =IF(AB376<1,0,IF(AF$11<=Z8,$F79,0))
AB =IF(AF$11<=Z11,$D82*AB379,0) =IF(AB379<1,0,IF(AF$11<=Z11,$F82,0))
Acat =IF(AF$11<=Z13,$D84*AB381,0) =IF(AB381<1,0,IF(AF$11<=Z13,$F84,0))
Bookmarks