Euro and lotto syndicate spread sheet to track winnings/payments and share

Hi all,

i do apologise if this has been asked before.

i run my work lotto and euro syndicate, and although i can do basic sums on a spreadsheet this does not cover what i would like to do, so here i am .

we havea maximum of 10 players who have an equal share of winnings.
if one dosent pay one week then they do not participate in that week and have no share of any winnings.

what i would like to do is create a spreadsheet where i can enter who has paid/not paid, and automatically change the share of each player accordinly, and a running total for each member that updates with each win depending on who has paid and not paid.

does that make any sense?
i would need step by step instructions as i would like to tackle this myself so that i can gain knowledge of spreadsheets

i do use open office instead of excel but i presume they are very similer with sums etc

many many thanks in advance
Darren

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Originally Posted by darrenmbrown

Hi all,

i do apologise if this has been asked before.

i run my work lotto and euro syndicate, and although i can do basic sums on a spreadsheet this does not cover what i would like to do, so here i am .

we havea maximum of 10 players who have an equal share of winnings.
if one dosent pay one week then they do not participate in that week and have no share of any winnings.

what i would like to do is create a spreadsheet where i can enter who has paid/not paid, and automatically change the share of each player accordinly, and a running total for each member that updates with each win depending on who has paid and not paid.

does that make any sense?
i would need step by step instructions as i would like to tackle this myself so that i can gain knowledge of spreadsheets

i do use open office instead of excel but i presume they are very similer with sums etc

many many thanks in advance
Darren

I did a quick mock up of what your table could look like, cell range is A1:D10. A1 having "Name" in it:

Name Paid/Not Paid Amount Paid Possible Takings
Andy paid £5.00 £3.89
Gary paid £5.00 £3.89
Sophie £0.00 £0.00
Kirstie paid £5.00 £3.89
Darren paid £5.00 £3.89
Lisa £0.00 £0.00
Anne paid £5.00 £3.89
Joe paid £5.00 £3.89
Harry paid £5.00 £3.89


The formula to use in cells D2:D10 is:

Formula:

Please Login or Register  to view this content.

Hope this helps, if so please "Add Reputation"

Thanks

Sorry, I can't attach files at the moment so the table looks a bit hard to read, the four headings are "Name", "Paid/Not Paid", "Amount Paid" & "Possible Takings". Then the four inputs are beneath each column, so for the first row of data, "Andy", "paid", "£5.00" & "3.89"


Apologies for the confusion.

Hi Alexander,
this does not look like what i had in mind, sorry. i am thinking alon g the lines of something like this:
Max 10 people in syndicate

1 week all 10 players have paid, so there share would be 10%, and if £25 was won this would equal £2.50 each for that week, so all players totals are £2.50
2nd Week only 8 players have played, so 2 people would have no share and 8 would have a 12.5% share each, again £25 won again so 8 players would get £3.13 so players totals would be 2 would have £2.50 and 8 would have £5.63.

im looking for something that will calculate peoples share depending on weather they have paid or not, to add up said shares and display the total for each player, and display the actual amount won i.e £25, oh and must have a date inputting coulum as we play both the euro lottery and lotto uk.

this sounds very difficult for my non excel spreadsheet working out brain lol

many thnaks in advance
darren