Random result grapher spreadsheet

[dave_w11]

I made this little spreadsheet to draw random results graphs based on finishing distribution. Perhaps it could be useful to help demonstrate variance to someone in a more visual manner than the ROI Simulator and a less soul crushing one than experience.

The results seem pretty much just like searching for winning players on sharkscope, but it's perhaps reassuring to see what swings can happen with no "tilt" or change in the players skill whatsoever.

I don't have anywhere to upload it hopefully this is ok.

http://www.megaupload.com/?d=6VVWLJ1Q

[DMMx69]

this is pretty cool. where is the calculate now button tho? i cant find it

[DMMx69]

nevermind, thought u actually added a "button" on the sheet.
for anyone else: tools|options|calculations

thanks again, this is very cool

[Slim Pickens]

F9

[RexWoo]

This is fantastic, for real.

Thank you.

[Fightins11]

this is awesome, ty

[DMMx69]

my keyboard doesnt have Function Keys....

[CheeseMoney]

This is [censored] sweet. Sticky this in the tools post, please. Nice work! Hope we can find someone to host it for real.

[vers]

Ok, I've never used an roi simulator or anything before, so can someone just tell me what and where I'm supposed to input stuff? Do I fill in my info in the grey shaded boxes then hit f9 and simulated ROI/simulated profit is what it could be w/ variance?

[DMMx69]

yes, only alter the info in the grey boxes... just input the STT u play most often, and your own stats, and keep pressing F9. its been entertaining me for hours....

after u get bored with that you can fool around with other numbers, but the most interesting thing is the amount of variance and how it shows up on the graph given the same conditions.