WHFB

1 - 7 of 7 Posts

Joined

·
4,571 Posts

Joined

·
758 Posts

You wouldn't happen to know the math behind it would you?

Here's a quick comparison below - @LD5, going from 2D6 to 3D6 Coldblooded, the % chance to make the LD roll increases from 27.8% to 52.3%. Skinks are basically have a 50/50 shot to not panic which is a lot worse than LD6 in the previous edition of the book wihch was a 68.1% not to panic.

| |||||||||||||||||||||||||||||||||||||||||||||||||||||||

Joined

·
9,222 Posts

Joined

·
4,967 Posts

In columns A,B,C you have to write down all the permutations of 3D6 which streatches to 216 rows of data. eg 1,2,3,4,5,6 copied and pasted below each other 36 times, then 111111,222222,333333 etc in column B, then 1(36 times), 2(36 times) etc repeating in column C.

A B C D E F G H

Red D6 Green D6 Blue D6 Total (ignoring highest)

1 1 1 =SUM(A2:C2)-MAX(A2:C2) Leadership Count Probability

2 1 1 =SUM(A3:C3)-MAX(A3:C3) 2 =COUNTIF($D$2:$D$217,F3) =SUM($G$3:G3)/216

3 1 1 =SUM(A4:C4)-MAX(A4:C4) 3 =COUNTIF($D$2:$D$217,F4) =SUM($G$3:G4)/216

4 1 1 =SUM(A5:C5)-MAX(A5:C5) 4 =COUNTIF($D$2:$D$217,F5) =SUM($G$3:G5)/216

5 1 1 =SUM(A6:C6)-MAX(A6:C6) 5 =COUNTIF($D$2:$D$217,F6) =SUM($G$3:G6)/216

6 1 1 =SUM(A7:C7)-MAX(A7:C7) 6 =COUNTIF($D$2:$D$217,F7) =SUM($G$3:G7)/216

1 2 1 =SUM(A8:C8)-MAX(A8:C8) 7 =COUNTIF($D$2:$D$217,F8) =SUM($G$3:G8)/216

2 2 1 =SUM(A9:C9)-MAX(A9:C9) 8 =COUNTIF($D$2:$D$217,F9) =SUM($G$3:G9)/216

3 2 1 =SUM(A10:C10)-MAX(A10:C10) 9 =COUNTIF($D$2:$D$217,F10) =SUM($G$3:G10)/216

4 2 1 =SUM(A11:C11)-MAX(A11:C11) 10 =COUNTIF($D$2:$D$217,F11) =SUM($G$3:G11)/216

5 2 1 =SUM(A12:C12)-MAX(A12:C12) 11 =COUNTIF($D$2:$D$217,F12) =SUM($G$3:G12)/216

6 2 1 =SUM(A13:C13)-MAX(A13:C13) 12 =COUNTIF($D$2:$D$217,F13) =SUM($G$3:G13)/216

1 3 1 =SUM(A14:C14)-MAX(A14:C14)

The results in column H give the same as in your table from the troll dice roller website.

Joined

·
1 Posts

1 - 7 of 7 Posts

Join the discussion

Librarium Online Forums

A forum community dedicated to Wargamers, Wargaming 40K enthusiasts. Come join the discussion about Warhammer and Wargaming collections, miniatures, tactics, terrain, reviews, accessories, history, displays, models, styles, scales, reviews, accessories, classifieds, and more!

Full Forum Listing
Explore Our Forums

Recommended Communities

Join now to ask and comment!