Finished

I'm too shot to send it out yet but here's some detail on how I implemented leadership:



The formula for A.hero max stack in yellow table (N68)is:
=(B5*10+150)*B5
and for leadership AW:
Code:
=MAX(0;MIN(1;1-(Q43-$N$68)/100000))
now, in the number-killed formulas I replaced a reference like to Z59 with:
Code:
IF($N$61=0;$Z59;Z59)
where N61 is the leadership method (4th entry in yellow table). After copy to round 2 it becomes:
Code:
IF($N$61=0;$Z59;AI59)
etc. etc.

N61 pulls it's value from the summary/main sheet where I added it as another tweaking option.

I also replaced all the nested IF() functions with MIN()/MAX() where it made sense. After that (and still not happy with performance), I optimized the Location formulas. They have 3 MIN or MAX functions in them with a whole range of cells as parameters. I moved those MIN/MAX formulas to unused cells like AB3 & AC3 and reference those cells instead.

It'll never become a Ferrari but I'm happy enough with performance now so that even with all the added tweaks it's still reasonable.

I tested a bit with leadership and found that the difference between static for the whole wave and recalculated for each round is much less than the differences I see between HH and regular hero leading the same waves. I got the feeling the penalty might even be more severe...

cheers,
DeVerm.