Excel help needed - tracking attendance and fees

valve90210

valve90210

valve90210

Soldato
Joined
17 Jan 2006
Posts
4,313
Hi all

I am trying to put together a spread sheet to keep track of attendance and fees owing as a group of my friends and I have started playing badminton recently and as organiser it is falling to me to book the courts. I don't mind doing this but of course I don't want to be out of pocket.

What I would like to be able to do as follows:

  • Enter the date the court is booked
  • Enter the cost of the court
  • Mark who attended (there are only 5 of us at the moment but Might need to add
    a 6th player so Ideally that would need to be easy to do)

This would then allow the spread sheet to count the total number of players on that date, then divide the cost of the court between that number of players and add that cost to the total owing for each of the people that played on that date (the total owing would probably be best on a second sheet?)

I think then on the second sheet I would like to be able to record payments made by each individual player and have the spread sheet deduct that from the total owed.

I can sort of see in my mind how to do this but I don't know how to go about putting it together in excel, might anyone where be able to help me out with this?

Alternatively does anyone know of any such software (ideally free) that has this functionality??

Any help very much appreciated.

Valve
 
Made a simple excel spreadsheet doing all that. :)

(Havnt tested it much, but I reckon it works ;) )

Court Hire and cost goes in Sheet1, and mark the players attending with a "1".

Any payments made go in sheet two, and the balance in on the right.

Also, if you change the player names in Sheet 1, they are amended in the other sheet as well.

just need someway of getting it to you now :)

Al
 
You must log in or register to reply here.
Back
Top Bottom