Like your idea. Much simpler than what we did last year. Here is a little more...
We created the spreadsheet out of desparation as we had 70 people camping from ages 1 to 65. We also had several different rates to contend with - the facility was a council property. It had a camping fee vs day use fee. Those fees also varied by age and if the person was registered with the Council. It also had activity fees that had mininum $ and also varied if the person had camped or was a day use. It was a nightmare to figure out. So we created a spreadsheet to try and manage the people coming, their status (child free under certain age, registered cub scout vs youth, registered adult vs adult)
We also had difficulty accessing the information on the spreadsheet while at camp since it was on the computer.
We have an event coming up this fall and it will have camping vs day use fees, but no difference based on age or registration status. That will help. Also no activity fees. (whew!)
I will be submitting my tour permit based on the rsvps received by due date. We don't accept any after that.
I am curious how you handle folks that rsvp they are attending and they either cancel or change the number attending at the last moment after you have started purchasing the food items. Do you issue refund and are they full or partial refunds? Does it matter what caused the change in attendance? (ie death in family, work conflict came up, etc) Does it matter when you get notified of the cancellation?
Looking to see how others have handled this issue.
Thanks!!!