bethlakshmi
commented
1 year ago So.. we still have the old "who gets what system", it let us figure out what to give out and what to exclude based on who bought what stuff, and who was doing what (and so deserve a comp). It definitely covers the roles of teachers & performers. I'd have to check on staff leads, but it sounds like we may have that covered anyway.
I think I can take that foundation and build a less visible side -- the occupancy view.
My thought is that occupancy != stuff we give to them on the packing list. For example:
- A whole shebang gets a badge
- A main event ticket buyer gets a ticket.
- A performer NOT in the Main Event gets a ticket (unless they bought the whole shebang)
- A performer performing in the Main Event may NOT get a ticket
But all 4 of these people count towards the occupancy in the upstairs hall.
I think I can use my rules system to say "this thing is invisible" - ie the occupany - and then draw up a list of criteria for that and count it and make you a report.
Question:
- definitely you want a report - right?
- would it also help to get a proactive email alert as you get close to a high water mark? Say you have 150 available, would you like an email to be sent at 130 estimated occupancy? Or maybe at a 130 and then every time it increases by X # of tickets?
There are 150 seats at the venue. That is the maximum number of Whole Shebangs we can sell, because each passholder is entitled to a seat.
Performers are entitled to seats at the shows. That means the number of Whole Shebangs we can sell is 150 - # of performers.
However, many performers will upgrade to a Whole Shebang, in which case the number of available weekend passes doesn't change. Any given performer is already guaranteed a seat. When they upgrade, they don't get more seats, they just get access to the classes, special events, etc.
Any time someone purchases an individual ticket to a show, we need to reduce the number of Whole Shebangs by that number of tickets. i.e., John Smith buys 2 tickets to Star Bras!, we now have two fewer Whole Shebangs we can sell.
However, if John Smith buys 1 ticket to Star Bras! and 1 ticket to The Main Event, we only reduce the number of Whole Shebangs by one. John is going to be sitting in the same seat (effectively) both nights.
The two cases with John Smith only apply to shows. If John buys a ticket to a Special Event, we don't care. Those aren't capped or if they are, we are asking people who have a Whole Shebang to make a reservation.
Last, I've created a "Staff Comp" that Marek is using to give people like you, me, John B, Mr Bergman, etc. Whole Shebangs. Those people aren't likely to be using a seat at any given show, so they don't count in our total.
That means the number of available Whole Shebangs is: 150 - # of performers + # of performers that have upgraded - the number of unique individual ticket holders - the number of Socialites sold - # of Whole Shebangs sold + # of staff Whole Shebangs
I can probably do this by hand (or ask Marek to) but it seems like this is something a computer would be good at.