How to build a mathhammer excel sheet (DIY for 8th)

Discuss tactical and strategic development for 40K/Tau.
User avatar
Lostroninsoul
Shas'Saal
Posts: 312

How to build a mathhammer excel sheet (DIY for 8th)

Post#1 » Jan 27 2018 03:27

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
Last edited by Lostroninsoul on Jan 27 2018 04:11, edited 10 times in total.

User avatar
Lostroninsoul
Shas'Saal
Posts: 312

Re: How to build a mathhammer excel sheet (DIY for 8th)

Post#2 » Jan 27 2018 03:28

It took me about an hour to recreate following my instructions.

Image
Image
(Note: I forgot to draw a line between 27 and 28)
Image
Last edited by Lostroninsoul on Jan 27 2018 12:04, edited 1 time in total.

User avatar
Lostroninsoul
Shas'Saal
Posts: 312

Re: How to build a mathhammer excel sheet (DIY for 8th)

Post#3 » Jan 27 2018 03:54

When it's finished it can look like this (I formated g16 to be a percentage).
Image
Last edited by Lostroninsoul on Jan 27 2018 12:06, edited 1 time in total.

User avatar
Lostroninsoul
Shas'Saal
Posts: 312

Re: How to build a mathhammer excel sheet (DIY for 8th)

Post#4 » Jan 27 2018 11:09

An example of a fusion blaster commander shooting at 20 kroot hounds
Image
Same commander shooting >9" at an enemy shadowsun (no drones) with 5 markerlighter hits (using my tips to demonstrate invulnerable saves and hard to hit).
Image

User avatar
Arka0415
Shas'Vre
Shas'Vre
Posts: 3120

Re: How to build a mathhammer excel sheet (DIY for 8th)

Post#5 » Jan 28 2018 12:29

Thank you very much! This looks like it could be a great resource! If you could provide clear screenshots and instructions for how to do this it could make a very useful article!

Return to “Tau Tactics”

Who is online

Users browsing this forum: No registered users and 2 guests