How would you work out the odds on winning the lottery in a syndicate of 40 people each buying 1combination each?

3 numbers £10 per winner 55.656 to 1
4 numbers 22% of remaining fund 1,031.4 to 1
5 numbers 10% of remaining fund 55,490 to 1
5 numbers and bonus ball 16% of remaining fund 2,330,635 to 1
6 numbers 52% of remaining fund 13,983,815 to 1
The overall odds of winning any prize is 52.655 to 1

Divide any of those numbers by 40 if you are going to buy 40 tickets.

So for an average syndicate of say 5 people, these are the following odds:
3 numbers £10 per winner 11.1312 to 1
4 numbers 22% of remaining fund 206.28 to 1
5 numbers 10% of remaining fund 11098 to 1
5 numbers and bonus ball 16% of remaining fund 466,127 to 1
6 numbers 52% of remaining fund 2,796,763 to 1
The overall odds of winning any prize is 10.531 to 1

Lottery syndicates are really the way forward. What's the point in playing on your own?... Most people reading this are probably thinking why should I play with a group when I want all the winnings to myself. It is a fact that a syndicate will increase your chances and to win any prize, your proof is in the new higher odds for a win created. Yes you will win less because the money prize gets split, but it also about putting you in a winning frame of mind, lets face it would all feel more achieved if we were winning something as apposed to nothing. Lottery Syndicates put you in the winning spirit.

My worst chore

I took over the running of a syndicate at my office and its turning out to be like a second job.

I'm currently using an Excel, with two spread sheets, Money in and Money out. I've put it up on Google documents and shared with all the players. My first spread sheet contains a column for the date, each players money paid in, the draw we played and numbers for that draw.

I have a second spread sheet labelled money out. If we have any wins for a draw I would split the amount against all the members, along the label of the draw row. This is to show any winnings we have had and how they have been distributed across the board. The data input is still a pain. (I'll post a screen shot soon.) 


The other problems are remembering to buy the tickets, some of my members want to only play the Euro millions when the draws are bigger

My question to everyone reading, how do you manage your syndicates or do you have a better constructed spreadsheet template, solution to make this faster and less of a job?

Look forward to the responses.