Random result grapher spreadsheet

vers · #1 11-28-2007, 07:17 PM

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 · #2 11-28-2007, 07:22 PM

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.

vers · #3 11-28-2007, 07:48 PM

This is a hell of a lot of fun. I would never think that over a 2500 game sample at 9 ROI I could run at -2 ROI. Great work OP

Salomonsson · #4 11-28-2007, 07:58 PM

http://www.2mt.dk/sng.xls

Nice tool!

mattiesmat · #5 11-28-2007, 08:06 PM

I don't get the finish distribution part.
What do you have to put in the grey areas?

vers · #6 11-28-2007, 08:08 PM

percentage of 1sts, 2nds and 3rds matties.

mattiesmat · #7 11-28-2007, 08:13 PM

Percentage of overall or of top3 only?
For example if I have played 100 sng's, I finished 10 times 1st, 10 times 2nd and 10 times 3rd.
Do I have to put 10%, 10, 0.1 or 1?
Or do I have to put 33% (because 30 ITM, and 10/30=33.3%)?