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.
No comments:
Post a Comment