8th Ed. MathhAmmer and tetto

[Gator]

I'm just wondering if anyone has come across a mathhammer spreadsheet that incorporates tetto eko's re rolling 1s ability in the magic phase. If not does anyone have the ability to do this?

 

[conquahex]

Working on it

 

[Gator]

Working on it

That's awesome man thanks

 

[rantapanda]

http://imgur.com/MJ5MMDi

I copypasted this from this site. Dont remember the thread.

Not really what you are looking for, but something like it.

 

[n810]

you should repost this in the Lizardmen Tacticia.

 

[hdctambien]

This is my attempt to calculate the chance of rolling "at least X" while rerolling 1's.

I rounded to the hundredths, so there are some 100%'s that are more like 99.999% ... but that's pretty darn close.

						num dice					
roll	1		2		3		4		5		6
1		100		100		100		100		100		100
2		97.22	100		100		100		100		100
3		77.78	99.92	100		100		100		100
4		58.33	98.84	100		100		100		100
5		38.89	93.98	99.95	100		100		100
6		19.44	85.34	99.59	100		100		100
7		0		72.91	98.18	99.98	100		100
8		0		56.71	94.99	99.86	100		100
9		0		37.8	89.27	99.42	99.99	100
10		0		22.68	80.34	98.28	99.95	100
11		0		11.34	68.05	95.95	99.81	100
12		0		3.78	53.87	91.8	99.41	99.98
13		0		0		39.27	85.27	98.51	99.94
14		0		0		25.72	76.25	96.73	99.8
15		0		0		14.7	65.04	93.65	99.46
16		0		0		7.34	52.37	88.83	98.74
17		0		0		2.93	39.41	82.01	97.38
18		0		0		0.73	27.48	73.18	95.05
19		0		0		0		17.51	62.66	91.42
20		0		0		0		10		51.15	86.21
21		0		0		0		4.99	39.52	79.26
22		0		0		0		2.13	28.67	70.67
23		0		0		0		0.7		19.38	60.78
24		0		0		0		0.13	12.09	50.15
25		0		0		0		0		6.87	39.49

Also the chances of rolling double 6's (or more):

1 dice: 0%
2 dice: 3.78108025%
3 dice: 9.8731189379975%
4 dice: 17.234714852663%
5 dice: 25.14205299987%
6 dice: 33.104778444438%

And the chances of breaking concentration:

1 die: 22.223%
2 dice: 7.717284%

Feel free to check my math! I wrote a PHP script to run these numbers and they checked out for my manual calculations for 2 dice ... I just went with whatever it told me for more than 2 dice.

To get the percentages I changed the weight of each side of the die by making 2-6 worth 1/6 + 1/36 and making a 1 worth 1/36 (since you have a 1/6 change to roll a 1 and then a 1/6 chance to reroll any other number making each number worth 1/6 * 1/6 more likely to happen)

 

[Gator]

Great job,looks great!