|
Title: Excel bosses! Post by: cambridgealex on September 17, 2016, 12:38:44 AM I've managed to deleted 12 months worth of cash game results ;technophobe;
I know the monthly totals and know roughly how many sessions per month I play. I want to simulate 20 sessions per month such that the totals match up. To complicate things, I want the winning:losing sessions in a 60:40 ratio and to have an upper and lower bound. I think I can only get so far with this, so a few pointers would be much appreciated! So tilting by the way! Title: Re: Excel bosses! Post by: Marky147 on September 17, 2016, 12:44:40 AM I've emailed my old man what you asked mate, and hopefully he'll be able to help.
Title: Re: Excel bosses! Post by: Jon MW on September 17, 2016, 07:44:27 AM The rand() function is what you need. It gives you a number between 0 and 1, if you partner that with the right multiplication and the INT or ROUND functions you can generate any number between any range you want.
The rest of it is just working out the right maths and that shouldn't be too hard to figure out :) Title: Re: Excel bosses! Post by: cambridgealex on September 17, 2016, 04:01:42 PM Thanks both, job done. It was labourious but the geek inside of me enjoyed the challenge and it was quite satisfying when I build the model and got it working. Amazing that the only function needed was the randbetween - just needed imagination really!
I didn't manage to get the sessions in a 60/40 ratio though and never attempted to sort the standard deviation / distribution so that most results were centred around the mean but not particularly necessary I guess. Title: Re: Excel bosses! Post by: Marky147 on September 17, 2016, 04:18:30 PM Nice one.
Glad you got it sorted. |