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

[Shrooma]

I expanded this excelsheet with a simulating part (assuming it was open source [img]/images/graemlins/smile.gif[/img] ). It simulates a predefined number of profit graphs based on the input given. The best and worst profit graph are shown in a graph.

For example, my 22+2 results(200 simulations, ROI 8%):



Download links:

Excel 97/2003
Excel 2007

These sheets contain VB code so you might need to enable macros. I deleted the initial graph because otherwise for each simulation the graph is updated which takes a lot of time.
It's still kind of slow so I wouldn't recommend to enter a large amount of simulations (200 simulations takes about a minute on my dual core).

The sheet may be expanded by showing for example largest downswing, upswing, break even strike etc. in the graph, but i guess this is rather difficult to implement. However, I'll try if there is enough interest.

[DMMx69]

there is interest. very cool what you did so far.

[PepsPersson]

Im interested in that aswell [img]/images/graemlins/smile.gif[/img]

[CheeseMoney]

Please don't let Guthrie get a hold of this spreadsheet.