Quote:
Originally Posted by StainlessSteelCynic
That's very nice of you... pfft, it's pretty damned awesome actually!
Thank you kind sir
Edit: Been giving the spreadsheet a good look and it's very, very handy. My only question is about the graph itself.
Was there meant to be annotation for the colours on the graph?
When I open the spreadsheet the graph displays fine but there's nothing stating which colour is what die.
While I'm certain that green is the d6 and blue is the d10, I'm assuming that they are both 2 dice (i.e. 2d6, 2d10) and I'm also assuming that the red plot is 3d10 and the purple is 3d6, is that correct?
Thanks again for this, it really has made the dud round results a lot easier to place onto a chart.
|
Hmmm. for the graph, there should be a key on the right side of the chart (about under column P)
The Blue inverted V is 2D6
The Red (flatter) inverted V is 2D10
The green curve is a 3D6 distribution
The purple curve is a 3D10 distribution
If I were a little smarter and demanded of Excel that it show curves, the inverted Vs would be a little softer looking, but their progression is rather regular (one more chance of a give outcome on 2 dice than the previous value)
The graph is comparing the distribution - Y axis is the % chance of a given outcome,
Uncle Ted