Random result grapher spreadsheet
 

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

Re: Random result grapher spreadsheet
 

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

Re: Random result grapher spreadsheet
 

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

thanks again, this is very cool

Re: Random result grapher spreadsheet
 

F9

Re: Random result grapher spreadsheet
 

This is fantastic, for real.

Thank you.

Re: Random result grapher spreadsheet
 

this is awesome, ty

Re: Random result grapher spreadsheet
 

my keyboard doesnt have Function Keys....

Re: Random result grapher spreadsheet
 

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

Re: Random result grapher spreadsheet
 

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?

Re: Random result grapher spreadsheet
 

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.