Includes:

-Rerolls for hit,wound, and saves

(a= reroll all failed,1=reroll 1's,0=no rerolls)

- factoring in morale loss to kill a unit

- points efficiency

-factoring in 5 marker lights (0= no , 1=yes)

These are my formulas. Fill them in exactly as shown. The right side is mapped out to help you put it in Excell correctly. Every thing in columns A->E(rows 1->28) is for basic use. Columns A->I are completely optional(advanced use)

Tips:

1.To simulate autohit (ie:flamers). Change bs score to "4" and double expected shots(ether 'weapons' or 'shots' x2 will do the trick). Review A13 to check your math

2. To simulate an invulnerable save, change AP to zero, and the save to what ever the invulnerable save would be.

3. I reccommend focusing on using A1 through D8 for basic use

4. Use "2" for a D3 roll, "3.5" for D6 rolls, and use"161/36" for 'pick best dice out of 2 D6(ie:fusion blaster at half range)

5. Everything under row 17 is the 'brains' of my formulas. It's important that it is present and untampered with .

6. To factor in hit modifiers just manually adjust your BS score(I haven't confirmed my math formulas on 'reroll all failed hits' on 'negative modifiers', yet)

P.s. Sorry-not-sorry for my bad handwriting lol