Excel bosses!

[cambridgealex]

I've managed to deleted 12 months worth of cash game results 

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!

[Marky147]

I've emailed my old man what you asked mate, and hopefully he'll be able to help.

[Jon MW]

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

[cambridgealex]

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.

[Marky147]

Nice one.

Glad you got it sorted.