Timeline for How to easily determine the results distribution for multiple dice?
Current License: CC BY-SA 3.0
4 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Jan 23, 2021 at 11:38 | comment | added | High Plains Grifter |
This is very useful for someone like me who just wants a way to do it, without having to understand! If you don't mind the volatility of the OFFSET() function, you can make this dynamic using a named range. For eg I made a range called DiceSize to hold the number of sides and put the first "1" probability in B23. I used a dynamic named range called KingSum which refers to =OFFSET('Dice Rolls'!$A$22,-1*DiceSize,,DiceSize,1) . I could then used the formula =SUM(OFFSET(KingSum,ROW(A1),COLUMN(A1)))/DiceSize in Cell C23, dragged all over a large area to give a table reliant on DiceSize.
|
|
Jul 28, 2014 at 2:19 | history | edited | Glen_b | CC BY-SA 3.0 |
edited because Excel's AVERAGE works differently now, decided to add some images
|
Jul 28, 2014 at 2:12 | history | edited | Glen_b | CC BY-SA 3.0 |
edited because Excel's AVERAGE works differently now, decided to add some images
|
Oct 15, 2010 at 6:19 | history | answered | Glen_b | CC BY-SA 2.5 |