This code file processes survey data from MCAAC members (where each member identifies the event(s) they wish to review, their Ranking across chosen events (from 1 to n, the number of events they picked), and the number of seats they’re requesting (1 or 2). Then, using data about number of seats Allocation to MCAAC, the program assigns events to members, taking into account their preferences but also balancing allocations across MCAAC members. This is done by computing a “Priority” value: for each event, a member’s Priority is based on their Ranking or the event relative to the Ranking of other members.
For Initial Allocation at Start of Season: Click on “Allocation Report by Member”. The main column you want to focus on below is “Granted” – which tells you how many tickets to assign to a member for an event.
After the initial allocations … to deal with Cancellations and Additional Requests: Click on “Allocation Report by Event”. Now the column “Deficit” tells you if someone received fewer tickets than Requested, and the “plusone.Priority” column tells you who has highest priority for receiving a ticket when it becomes available.
Let’s read the Survey data using the “by event” file.
Combine the two data sets (“Event” + “Venue” + “Date” + “Time” is the common column), and bring in Allocation columns from events.df
Now extend the raw data by defining n.Members and n.Total. Then define Priority for allocating 1 Member ticket (this matters when n.Members > Allocation) - Priority is just your Rank relative to others’ Ranking for that event. Further, also define a “plusone.Priority” column to indicate who gets priority for allocating 2 tickets (when n.Total > Allocation but n.Members < Allocation)
Here is an example of the data set we have now, including the newly added columns.
| Event | Venue | Date | Time | Allocation | X | Name | Ranking | Tickets.Requested | Priority | plusone | n.Total | n.Members | plusone.Priority | EventDateTime | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Dance Theatre of Harlem | Jackson Hall | 2024-04-17 | 7:30 PM | 12 | 44 | Jennie Moylan | jwmoylan@ucdavis.edu | 1 | 2 | 5 | 1 | 28 | 14 | 5 | Dance Theatre of Harlem 2024-04-17 7:30 PM |
| Academy of St Martin in the Fields with Joshua Bell | Jackson Hall | 2024-04-06 | 7:30 PM | 12 | 34 | Stephanie Syphers | ssyphers@ucdavis.edu | 3 | 2 | 8 | 1 | 20 | 10 | 8 | Academy of St Martin in the Fields with Joshua Bell 2024-04-06 7:30 PM |
| Academy of St Martin in the Fields with Joshua Bell | Jackson Hall | 2024-04-06 | 7:30 PM | 12 | 7 | Pauline Moreira | pmetzgar@ucdavis.edu | 1 | 2 | 1 | 1 | 20 | 10 | 1 | Academy of St Martin in the Fields with Joshua Bell 2024-04-06 7:30 PM |
| Wanda Sykes | Jackson Hall | 2024-05-31 | 7:30 PM | 12 | 46 | Jennie Moylan | jwmoylan@ucdavis.edu | 3 | 2 | 11 | 1 | 33 | 17 | 11 | Wanda Sykes 2024-05-31 7:30 PM |
| Alexander String Quartet | Jackson Hall | 2024-05-05 | 2:00 PM | 12 | 38 | Stephanie Syphers | ssyphers@ucdavis.edu | 7 | 2 | 4 | 1 | 8 | 4 | 4 | Alexander String Quartet 2024-05-05 2:00 PM |
Now we allocate the tickets based on number requested, your Rank for the event (i.e., converted into Priority and plusone.Priority).
The top priority to Grant 1 ticket to each member who requests (and if too many members, then use Priority to pick who gets), otherwise Grant as many tickets (1 or 2) as requested when there’s enough allocation.
However, there is a twist here. If some events occur multiple times (i.e., two separate Date+Time combinations) then we do NOT want to assign members a ticket on multiple shows. At the same time, if some members requested TWO tickets and they can be granted (as above) for a particular show then we’d rather grant those tickets together on one show, and take them off the other shows (so that other members can get those tickets).
So, we will implement the allocations in two parts. First the events that only occur once, and then the events that occur multiple shows.
if an event is under-demand (Tickets.Requested < or = Allocation) then Grant them those tickets, Granted = Tickets.Requested (After doing this)
if an event is over-demanded, then members who have Priority level lower than available tickets (i.e., a higher number than Allocation) unfortunately do not get a ticket.
Otherwise if n.Members < (or equal to) Allocation then everyone gets at least one ticket. If n.Total < Allocation then everyone gets as many tickets as they asked for (i.e., 1 or 2) If n.Total > Allocation then only a few people (= Allocation - n.Members) can get 2 tickets, and these are the ones with the best plusone.Priority levels.
The main column you want to focus on below is “Granted” – which tells you how many tickets to assign to a member for an event. N.Tickets is the number they requested, Ranking is the Rank they assigned to that event (vs all others they picked), and Priority reflects their position relative to other members based on the Ranks everyone chose.
| Event | Date | Time | Name | N.Tickets | Priority | Granted | Deficit | Ranking | plusone.Priority | n.Members | n.Total |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Academy of St Martin in the Fields with Joshua Bell | 2024-04-06 | 7:30 PM | Pauline Moreira | 2 | 1 | 2 | 0 | 1 | 1 | 10 | 20 |
| Academy of St Martin in the Fields with Joshua Bell | 2024-04-06 | 7:30 PM | Hemant Bhargava | 2 | 2 | 2 | 0 | 1 | 2 | 10 | 20 |
| Academy of St Martin in the Fields with Joshua Bell | 2024-04-06 | 7:30 PM | Susette Min | 2 | 3 | 1 | 1 | 1 | 3 | 10 | 20 |
| Academy of St Martin in the Fields with Joshua Bell | 2024-04-06 | 7:30 PM | Lee Miller | 2 | 4 | 1 | 1 | 1 | 4 | 10 | 20 |
| Academy of St Martin in the Fields with Joshua Bell | 2024-04-06 | 7:30 PM | Mahek Bhora | 2 | 5 | 1 | 1 | 1 | 5 | 10 | 20 |
| Academy of St Martin in the Fields with Joshua Bell | 2024-04-06 | 7:30 PM | Laurie San Martin | 2 | 6 | 1 | 1 | 3 | 6 | 10 | 20 |
| Academy of St Martin in the Fields with Joshua Bell | 2024-04-06 | 7:30 PM | Shelby Campbell | 2 | 7 | 1 | 1 | 3 | 7 | 10 | 20 |
| Academy of St Martin in the Fields with Joshua Bell | 2024-04-06 | 7:30 PM | Stephanie Syphers | 2 | 8 | 1 | 1 | 3 | 8 | 10 | 20 |
| Academy of St Martin in the Fields with Joshua Bell | 2024-04-06 | 7:30 PM | Dan Herman | 2 | 9 | 1 | 1 | 5 | 9 | 10 | 20 |
| Academy of St Martin in the Fields with Joshua Bell | 2024-04-06 | 7:30 PM | Jennie Moylan | 2 | 10 | 1 | 1 | 5 | 10 | 10 | 20 |
| Event | Date | Time | Name | N.Tickets | Priority | Granted | Deficit | Ranking | plusone.Priority | n.Members | n.Total |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Alexander String Quartet | 2024-05-05 | 2:00 PM | Susette Min | 2 | 1 | 2 | 0 | 2 | 1 | 4 | 8 |
| Alexander String Quartet | 2024-05-05 | 2:00 PM | Lee Miller | 2 | 2 | 2 | 0 | 3 | 2 | 4 | 8 |
| Alexander String Quartet | 2024-05-05 | 2:00 PM | Dan Herman | 2 | 3 | 2 | 0 | 4 | 3 | 4 | 8 |
| Alexander String Quartet | 2024-05-05 | 2:00 PM | Stephanie Syphers | 2 | 4 | 2 | 0 | 7 | 4 | 4 | 8 |
| Event | Date | Time | Name | N.Tickets | Priority | Granted | Deficit | Ranking | plusone.Priority | n.Members | n.Total |
|---|---|---|---|---|---|---|---|---|---|---|---|
| An Evening with David Sedaris | 2024-05-08 | 7:30 PM | Kyla Hibbard | 1 | 1 | 1 | 0 | 2 | 9 | 10 | 18 |
| An Evening with David Sedaris | 2024-05-08 | 7:30 PM | Jennie Moylan | 2 | 2 | 2 | 0 | 2 | 1 | 10 | 18 |
| An Evening with David Sedaris | 2024-05-08 | 7:30 PM | inga renate langford | 2 | 3 | 2 | 0 | 2 | 2 | 10 | 18 |
| An Evening with David Sedaris | 2024-05-08 | 7:30 PM | Kelsey Hadfield | 2 | 4 | 1 | 1 | 3 | 3 | 10 | 18 |
| An Evening with David Sedaris | 2024-05-08 | 7:30 PM | Mahek Bhora | 2 | 5 | 1 | 1 | 3 | 4 | 10 | 18 |
| An Evening with David Sedaris | 2024-05-08 | 7:30 PM | Elisa White | 2 | 6 | 1 | 1 | 3 | 5 | 10 | 18 |
| An Evening with David Sedaris | 2024-05-08 | 7:30 PM | Jonah Messinger | 2 | 7 | 1 | 1 | 4 | 6 | 10 | 18 |
| An Evening with David Sedaris | 2024-05-08 | 7:30 PM | Laurie San Martin | 2 | 8 | 1 | 1 | 5 | 7 | 10 | 18 |
| An Evening with David Sedaris | 2024-05-08 | 7:30 PM | Hemant Bhargava | 2 | 9 | 1 | 1 | 6 | 8 | 10 | 18 |
| An Evening with David Sedaris | 2024-05-08 | 7:30 PM | Aidan Carr | 1 | 10 | 1 | 0 | 8 | 10 | 10 | 18 |
| Event | Date | Time | Name | N.Tickets | Priority | Granted | Deficit | Ranking | plusone.Priority | n.Members | n.Total |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Bedtime Stories by URLAND | 2024-04-24 | 7:30 PM | Jennie Moylan | 2 | 1 | 2 | 0 | 6 | 1 | 1 | 2 |
| Event | Date | Time | Name | N.Tickets | Priority | Granted | Deficit | Ranking | plusone.Priority | n.Members | n.Total |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Bedtime Stories by URLAND | 2024-04-25 | 7:30 PM | Jessica Lee | 2 | 1 | 2 | 0 | 4 | 1 | 2 | 4 |
| Bedtime Stories by URLAND | 2024-04-25 | 7:30 PM | Elisa White | 2 | 2 | 2 | 0 | 5 | 2 | 2 | 4 |
| Event | Date | Time | Name | N.Tickets | Priority | Granted | Deficit | Ranking | plusone.Priority | n.Members | n.Total |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Bedtime Stories by URLAND | 2024-04-26 | 7:30 PM | Kyla Hibbard | 1 | 1 | 1 | 0 | 5 | 1 | 1 | 1 |
| Event | Date | Time | Name | N.Tickets | Priority | Granted | Deficit | Ranking | plusone.Priority | n.Members | n.Total |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Bedtime Stories by URLAND | 2024-04-27 | 7:30 PM | Aidan Carr | 2 | 1 | 2 | 0 | 4 | 1 | 2 | 3 |
| Bedtime Stories by URLAND | 2024-04-27 | 7:30 PM | Stephanie Syphers | 1 | 2 | 1 | 0 | 5 | 2 | 2 | 3 |
| Event | Date | Time | Name | N.Tickets | Priority | Granted | Deficit | Ranking | plusone.Priority | n.Members | n.Total |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Dance Theatre of Harlem | 2024-04-17 | 7:30 PM | Elisa White | 2 | 1 | 1 | 1 | 1 | 1 | 14 | 28 |
| Dance Theatre of Harlem | 2024-04-17 | 7:30 PM | Mark Brunet | 2 | 2 | 1 | 1 | 1 | 2 | 14 | 28 |
| Dance Theatre of Harlem | 2024-04-17 | 7:30 PM | Stephanie Syphers | 2 | 3 | 1 | 1 | 1 | 3 | 14 | 28 |
| Dance Theatre of Harlem | 2024-04-17 | 7:30 PM | inga renate langford | 2 | 4 | 1 | 1 | 1 | 4 | 14 | 28 |
| Dance Theatre of Harlem | 2024-04-17 | 7:30 PM | Jennie Moylan | 2 | 5 | 1 | 1 | 1 | 5 | 14 | 28 |
| Dance Theatre of Harlem | 2024-04-17 | 7:30 PM | Kelsey Hadfield | 2 | 6 | 1 | 1 | 1 | 6 | 14 | 28 |
| Dance Theatre of Harlem | 2024-04-17 | 7:30 PM | Cecilia Giulivi | 2 | 7 | 1 | 1 | 1 | 7 | 14 | 28 |
| Dance Theatre of Harlem | 2024-04-17 | 7:30 PM | Lee Miller | 2 | 8 | 1 | 1 | 2 | 8 | 14 | 28 |
| Dance Theatre of Harlem | 2024-04-17 | 7:30 PM | Jessica Lee | 2 | 9 | 1 | 1 | 2 | 9 | 14 | 28 |
| Dance Theatre of Harlem | 2024-04-17 | 7:30 PM | Hemant Bhargava | 2 | 10 | 1 | 1 | 3 | 10 | 14 | 28 |
| Dance Theatre of Harlem | 2024-04-17 | 7:30 PM | Kyla Hibbard | 2 | 11 | 1 | 1 | 4 | 11 | 14 | 28 |
| Dance Theatre of Harlem | 2024-04-17 | 7:30 PM | Pauline Moreira | 2 | 12 | 1 | 1 | 4 | 12 | 14 | 28 |
| Dance Theatre of Harlem | 2024-04-17 | 7:30 PM | Laurie San Martin | 2 | 13 | 0 | 2 | 4 | 13 | 14 | 28 |
| Dance Theatre of Harlem | 2024-04-17 | 7:30 PM | Aidan Carr | 2 | 14 | 0 | 2 | 5 | 14 | 14 | 28 |
| Event | Date | Time | Name | N.Tickets | Priority | Granted | Deficit | Ranking | plusone.Priority | n.Members | n.Total |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Emmet Cohen Organ Trio | 2024-05-16 | 7:30 PM | Aidan Carr | 2 | 1 | 2 | 0 | 1 | 1 | 2 | 4 |
| Emmet Cohen Organ Trio | 2024-05-16 | 7:30 PM | Dan Herman | 2 | 2 | 2 | 0 | 6 | 2 | 2 | 4 |
| Event | Date | Time | Name | N.Tickets | Priority | Granted | Deficit | Ranking | plusone.Priority | n.Members | n.Total |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Emmet Cohen Organ Trio | 2024-05-17 | 7:30 PM | Naoki Saito | 1 | 1 | 1 | 0 | 1 | 3 | 3 | 5 |
| Emmet Cohen Organ Trio | 2024-05-17 | 7:30 PM | Shelby Campbell | 2 | 2 | 2 | 0 | 2 | 1 | 3 | 5 |
| Emmet Cohen Organ Trio | 2024-05-17 | 7:30 PM | Jonah Messinger | 2 | 3 | 1 | 1 | 5 | 2 | 3 | 5 |
| Event | Date | Time | Name | N.Tickets | Priority | Granted | Deficit | Ranking | plusone.Priority | n.Members | n.Total |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Emmet Cohen Organ Trio | 2024-05-18 | 7:30 PM | Kelsey Hadfield | 2 | 1 | 2 | 0 | 4 | 1 | 1 | 2 |
| Event | Date | Time | Name | N.Tickets | Priority | Granted | Deficit | Ranking | plusone.Priority | n.Members | n.Total |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Hiromi’s sonicwonder | 2024-04-18 | 7:30 PM | Kelsey Hadfield | 2 | 1 | 2 | 0 | 2 | 1 | 9 | 18 |
| Hiromi’s sonicwonder | 2024-04-18 | 7:30 PM | Aidan Carr | 2 | 2 | 2 | 0 | 2 | 2 | 9 | 18 |
| Hiromi’s sonicwonder | 2024-04-18 | 7:30 PM | Jonah Messinger | 2 | 3 | 2 | 0 | 2 | 3 | 9 | 18 |
| Hiromi’s sonicwonder | 2024-04-18 | 7:30 PM | Jessica Lee | 2 | 4 | 1 | 1 | 3 | 4 | 9 | 18 |
| Hiromi’s sonicwonder | 2024-04-18 | 7:30 PM | Dan Herman | 2 | 5 | 1 | 1 | 3 | 5 | 9 | 18 |
| Hiromi’s sonicwonder | 2024-04-18 | 7:30 PM | Kyla Hibbard | 2 | 6 | 1 | 1 | 3 | 6 | 9 | 18 |
| Hiromi’s sonicwonder | 2024-04-18 | 7:30 PM | Mahek Bhora | 2 | 7 | 1 | 1 | 4 | 7 | 9 | 18 |
| Hiromi’s sonicwonder | 2024-04-18 | 7:30 PM | Hemant Bhargava | 2 | 8 | 1 | 1 | 4 | 8 | 9 | 18 |
| Hiromi’s sonicwonder | 2024-04-18 | 7:30 PM | Elisa White | 2 | 9 | 1 | 1 | 6 | 9 | 9 | 18 |
| Event | Date | Time | Name | N.Tickets | Priority | Granted | Deficit | Ranking | plusone.Priority | n.Members | n.Total |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Jordi Savall & Hespèrion XXI | 2024-04-13 | 7:30 PM | Laurie San Martin | 2 | 1 | 2 | 0 | 1 | 1 | 3 | 6 |
| Jordi Savall & Hespèrion XXI | 2024-04-13 | 7:30 PM | Hemant Bhargava | 2 | 2 | 2 | 0 | 2 | 2 | 3 | 6 |
| Jordi Savall & Hespèrion XXI | 2024-04-13 | 7:30 PM | Shelby Campbell | 2 | 3 | 2 | 0 | 4 | 3 | 3 | 6 |
| Event | Date | Time | Name | N.Tickets | Priority | Granted | Deficit | Ranking | plusone.Priority | n.Members | n.Total |
|---|---|---|---|---|---|---|---|---|---|---|---|
| San Francisco Symphony | 2024-05-11 | 7:30 PM | Dan Herman | 2 | 1 | 2 | 0 | 1 | 1 | 7 | 14 |
| San Francisco Symphony | 2024-05-11 | 7:30 PM | Jonah Messinger | 2 | 2 | 2 | 0 | 1 | 2 | 7 | 14 |
| San Francisco Symphony | 2024-05-11 | 7:30 PM | Stephanie Syphers | 2 | 3 | 2 | 0 | 2 | 3 | 7 | 14 |
| San Francisco Symphony | 2024-05-11 | 7:30 PM | Laurie San Martin | 2 | 4 | 2 | 0 | 2 | 4 | 7 | 14 |
| San Francisco Symphony | 2024-05-11 | 7:30 PM | Aidan Carr | 2 | 5 | 2 | 0 | 3 | 5 | 7 | 14 |
| San Francisco Symphony | 2024-05-11 | 7:30 PM | Kelsey Hadfield | 2 | 6 | 1 | 1 | 5 | 6 | 7 | 14 |
| San Francisco Symphony | 2024-05-11 | 7:30 PM | Jennie Moylan | 2 | 7 | 1 | 1 | 7 | 7 | 7 | 14 |
| Event | Date | Time | Name | N.Tickets | Priority | Granted | Deficit | Ranking | plusone.Priority | n.Members | n.Total |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Triplets of Belleville | 2024-04-05 | 7:30 PM | Mahek Bhora | 2 | 1 | 2 | 0 | 2 | 1 | 6 | 11 |
| Triplets of Belleville | 2024-04-05 | 7:30 PM | Pauline Moreira | 2 | 2 | 2 | 0 | 3 | 2 | 6 | 11 |
| Triplets of Belleville | 2024-04-05 | 7:30 PM | Elisa White | 2 | 3 | 2 | 0 | 4 | 3 | 6 | 11 |
| Triplets of Belleville | 2024-04-05 | 7:30 PM | Jennie Moylan | 2 | 4 | 2 | 0 | 4 | 4 | 6 | 11 |
| Triplets of Belleville | 2024-04-05 | 7:30 PM | Stephanie Syphers | 2 | 5 | 2 | 0 | 4 | 5 | 6 | 11 |
| Triplets of Belleville | 2024-04-05 | 7:30 PM | Aidan Carr | 1 | 6 | 1 | 0 | 6 | 6 | 6 | 11 |
| Event | Date | Time | Name | N.Tickets | Priority | Granted | Deficit | Ranking | plusone.Priority | n.Members | n.Total |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Wanda Sykes | 2024-05-31 | 7:30 PM | Sheri Hagoes | 2 | 1 | 1 | 1 | 1 | 1 | 17 | 33 |
| Wanda Sykes | 2024-05-31 | 7:30 PM | Kyla Hibbard | 2 | 2 | 1 | 1 | 1 | 2 | 17 | 33 |
| Wanda Sykes | 2024-05-31 | 7:30 PM | Femi-Jide Akinmoladun | 2 | 3 | 1 | 1 | 1 | 3 | 17 | 33 |
| Wanda Sykes | 2024-05-31 | 7:30 PM | Jessica Lee | 2 | 4 | 1 | 1 | 1 | 4 | 17 | 33 |
| Wanda Sykes | 2024-05-31 | 7:30 PM | Ned Spang | 2 | 5 | 1 | 1 | 1 | 5 | 17 | 33 |
| Wanda Sykes | 2024-05-31 | 7:30 PM | Shelby Campbell | 2 | 6 | 1 | 1 | 1 | 6 | 17 | 33 |
| Wanda Sykes | 2024-05-31 | 7:30 PM | Dan Herman | 2 | 7 | 1 | 1 | 2 | 7 | 17 | 33 |
| Wanda Sykes | 2024-05-31 | 7:30 PM | Mark Brunet | 2 | 8 | 1 | 1 | 2 | 8 | 17 | 33 |
| Wanda Sykes | 2024-05-31 | 7:30 PM | Elisa White | 2 | 9 | 1 | 1 | 2 | 9 | 17 | 33 |
| Wanda Sykes | 2024-05-31 | 7:30 PM | Pauline Moreira | 2 | 10 | 1 | 1 | 2 | 10 | 17 | 33 |
| Wanda Sykes | 2024-05-31 | 7:30 PM | Jennie Moylan | 2 | 11 | 1 | 1 | 3 | 11 | 17 | 33 |
| Wanda Sykes | 2024-05-31 | 7:30 PM | Jonah Messinger | 2 | 12 | 1 | 1 | 3 | 12 | 17 | 33 |
| Wanda Sykes | 2024-05-31 | 7:30 PM | inga renate langford | 2 | 13 | 0 | 2 | 3 | 13 | 17 | 33 |
| Wanda Sykes | 2024-05-31 | 7:30 PM | Hemant Bhargava | 2 | 14 | 0 | 2 | 5 | 14 | 17 | 33 |
| Wanda Sykes | 2024-05-31 | 7:30 PM | Stephanie Syphers | 2 | 15 | 0 | 2 | 6 | 15 | 17 | 33 |
| Wanda Sykes | 2024-05-31 | 7:30 PM | Laurie San Martin | 2 | 16 | 0 | 2 | 6 | 16 | 17 | 33 |
| Wanda Sykes | 2024-05-31 | 7:30 PM | Aidan Carr | 1 | 17 | 0 | 1 | 7 | 17 | 17 | 33 |
[[1]] NULL
[[2]] NULL
[[3]] NULL
[[4]] NULL
[[5]] NULL
[[6]] NULL
[[7]] NULL
[[8]] NULL
[[9]] NULL
[[10]] NULL
[[11]] NULL
[[12]] NULL
[[13]] NULL
[[14]] NULL
[[15]] NULL
[[16]] NULL
The main column you want to focus on below is “Granted” – which tells you how many tickets to assign to a member for an event. N.Tickets is the number they requested, Ranking is the Rank they assigned to that event (vs all others they picked), and Priority reflects their position relative to other members based on the Ranks everyone chose.
| Event | Date | Time | Name | N.Tickets | Priority | Granted | Deficit | Ranking | plusone.Priority | n.Members | n.Total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Emmet Cohen Organ Trio | 2024-05-16 | 7:30 PM | Aidan Carr | 2 | 1 | 2 | 0 | 1 | 1 | 2 | 4 | ajcarr@ucdavis.edu |
| Hiromi’s sonicwonder | 2024-04-18 | 7:30 PM | Aidan Carr | 2 | 2 | 2 | 0 | 2 | 2 | 9 | 18 | ajcarr@ucdavis.edu |
| San Francisco Symphony | 2024-05-11 | 7:30 PM | Aidan Carr | 2 | 5 | 2 | 0 | 3 | 5 | 7 | 14 | ajcarr@ucdavis.edu |
| Bedtime Stories by URLAND | 2024-04-27 | 7:30 PM | Aidan Carr | 2 | 1 | 2 | 0 | 4 | 1 | 2 | 3 | ajcarr@ucdavis.edu |
| Dance Theatre of Harlem | 2024-04-17 | 7:30 PM | Aidan Carr | 2 | 14 | 0 | 2 | 5 | 14 | 14 | 28 | ajcarr@ucdavis.edu |
| Triplets of Belleville | 2024-04-05 | 7:30 PM | Aidan Carr | 1 | 6 | 1 | 0 | 6 | 6 | 6 | 11 | ajcarr@ucdavis.edu |
| Wanda Sykes | 2024-05-31 | 7:30 PM | Aidan Carr | 1 | 17 | 0 | 1 | 7 | 17 | 17 | 33 | ajcarr@ucdavis.edu |
| An Evening with David Sedaris | 2024-05-08 | 7:30 PM | Aidan Carr | 1 | 10 | 1 | 0 | 8 | 10 | 10 | 18 | ajcarr@ucdavis.edu |
| Event | Date | Time | Name | N.Tickets | Priority | Granted | Deficit | Ranking | plusone.Priority | n.Members | n.Total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Dance Theatre of Harlem | 2024-04-17 | 7:30 PM | Cecilia Giulivi | 2 | 7 | 1 | 1 | 1 | 7 | 14 | 28 | cgiulivi@ucdavis.edu |
| Event | Date | Time | Name | N.Tickets | Priority | Granted | Deficit | Ranking | plusone.Priority | n.Members | n.Total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| San Francisco Symphony | 2024-05-11 | 7:30 PM | Dan Herman | 2 | 1 | 2 | 0 | 1 | 1 | 7 | 14 | dcherman@ucdavis.edu |
| Wanda Sykes | 2024-05-31 | 7:30 PM | Dan Herman | 2 | 7 | 1 | 1 | 2 | 7 | 17 | 33 | dcherman@ucdavis.edu |
| Hiromi’s sonicwonder | 2024-04-18 | 7:30 PM | Dan Herman | 2 | 5 | 1 | 1 | 3 | 5 | 9 | 18 | dcherman@ucdavis.edu |
| Alexander String Quartet | 2024-05-05 | 2:00 PM | Dan Herman | 2 | 3 | 2 | 0 | 4 | 3 | 4 | 8 | dcherman@ucdavis.edu |
| Academy of St Martin in the Fields with Joshua Bell | 2024-04-06 | 7:30 PM | Dan Herman | 2 | 9 | 1 | 1 | 5 | 9 | 10 | 20 | dcherman@ucdavis.edu |
| Emmet Cohen Organ Trio | 2024-05-16 | 7:30 PM | Dan Herman | 2 | 2 | 2 | 0 | 6 | 2 | 2 | 4 | dcherman@ucdavis.edu |
| Event | Date | Time | Name | N.Tickets | Priority | Granted | Deficit | Ranking | plusone.Priority | n.Members | n.Total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Dance Theatre of Harlem | 2024-04-17 | 7:30 PM | Elisa White | 2 | 1 | 1 | 1 | 1 | 1 | 14 | 28 | ejowhite@ucdavis.edu |
| Wanda Sykes | 2024-05-31 | 7:30 PM | Elisa White | 2 | 9 | 1 | 1 | 2 | 9 | 17 | 33 | ejowhite@ucdavis.edu |
| An Evening with David Sedaris | 2024-05-08 | 7:30 PM | Elisa White | 2 | 6 | 1 | 1 | 3 | 5 | 10 | 18 | ejowhite@ucdavis.edu |
| Triplets of Belleville | 2024-04-05 | 7:30 PM | Elisa White | 2 | 3 | 2 | 0 | 4 | 3 | 6 | 11 | ejowhite@ucdavis.edu |
| Bedtime Stories by URLAND | 2024-04-25 | 7:30 PM | Elisa White | 2 | 2 | 2 | 0 | 5 | 2 | 2 | 4 | ejowhite@ucdavis.edu |
| Hiromi’s sonicwonder | 2024-04-18 | 7:30 PM | Elisa White | 2 | 9 | 1 | 1 | 6 | 9 | 9 | 18 | ejowhite@ucdavis.edu |
| Event | Date | Time | Name | N.Tickets | Priority | Granted | Deficit | Ranking | plusone.Priority | n.Members | n.Total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Wanda Sykes | 2024-05-31 | 7:30 PM | Femi-Jide Akinmoladun | 2 | 3 | 1 | 1 | 1 | 3 | 17 | 33 | jakinmola@ucdavis.edu |
| Event | Date | Time | Name | N.Tickets | Priority | Granted | Deficit | Ranking | plusone.Priority | n.Members | n.Total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Academy of St Martin in the Fields with Joshua Bell | 2024-04-06 | 7:30 PM | Hemant Bhargava | 2 | 2 | 2 | 0 | 1 | 2 | 10 | 20 | hemantb@ucdavis.edu |
| Jordi Savall & Hespèrion XXI | 2024-04-13 | 7:30 PM | Hemant Bhargava | 2 | 2 | 2 | 0 | 2 | 2 | 3 | 6 | hemantb@ucdavis.edu |
| Dance Theatre of Harlem | 2024-04-17 | 7:30 PM | Hemant Bhargava | 2 | 10 | 1 | 1 | 3 | 10 | 14 | 28 | hemantb@ucdavis.edu |
| Hiromi’s sonicwonder | 2024-04-18 | 7:30 PM | Hemant Bhargava | 2 | 8 | 1 | 1 | 4 | 8 | 9 | 18 | hemantb@ucdavis.edu |
| Wanda Sykes | 2024-05-31 | 7:30 PM | Hemant Bhargava | 2 | 14 | 0 | 2 | 5 | 14 | 17 | 33 | hemantb@ucdavis.edu |
| An Evening with David Sedaris | 2024-05-08 | 7:30 PM | Hemant Bhargava | 2 | 9 | 1 | 1 | 6 | 8 | 10 | 18 | hemantb@ucdavis.edu |
| Event | Date | Time | Name | N.Tickets | Priority | Granted | Deficit | Ranking | plusone.Priority | n.Members | n.Total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Dance Theatre of Harlem | 2024-04-17 | 7:30 PM | Jennie Moylan | 2 | 5 | 1 | 1 | 1 | 5 | 14 | 28 | jwmoylan@ucdavis.edu |
| An Evening with David Sedaris | 2024-05-08 | 7:30 PM | Jennie Moylan | 2 | 2 | 2 | 0 | 2 | 1 | 10 | 18 | jwmoylan@ucdavis.edu |
| Wanda Sykes | 2024-05-31 | 7:30 PM | Jennie Moylan | 2 | 11 | 1 | 1 | 3 | 11 | 17 | 33 | jwmoylan@ucdavis.edu |
| Triplets of Belleville | 2024-04-05 | 7:30 PM | Jennie Moylan | 2 | 4 | 2 | 0 | 4 | 4 | 6 | 11 | jwmoylan@ucdavis.edu |
| Academy of St Martin in the Fields with Joshua Bell | 2024-04-06 | 7:30 PM | Jennie Moylan | 2 | 10 | 1 | 1 | 5 | 10 | 10 | 20 | jwmoylan@ucdavis.edu |
| Bedtime Stories by URLAND | 2024-04-24 | 7:30 PM | Jennie Moylan | 2 | 1 | 2 | 0 | 6 | 1 | 1 | 2 | jwmoylan@ucdavis.edu |
| San Francisco Symphony | 2024-05-11 | 7:30 PM | Jennie Moylan | 2 | 7 | 1 | 1 | 7 | 7 | 7 | 14 | jwmoylan@ucdavis.edu |
| Event | Date | Time | Name | N.Tickets | Priority | Granted | Deficit | Ranking | plusone.Priority | n.Members | n.Total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Wanda Sykes | 2024-05-31 | 7:30 PM | Jessica Lee | 2 | 4 | 1 | 1 | 1 | 4 | 17 | 33 | jkmlee@ucdavis.edu |
| Dance Theatre of Harlem | 2024-04-17 | 7:30 PM | Jessica Lee | 2 | 9 | 1 | 1 | 2 | 9 | 14 | 28 | jkmlee@ucdavis.edu |
| Hiromi’s sonicwonder | 2024-04-18 | 7:30 PM | Jessica Lee | 2 | 4 | 1 | 1 | 3 | 4 | 9 | 18 | jkmlee@ucdavis.edu |
| Bedtime Stories by URLAND | 2024-04-25 | 7:30 PM | Jessica Lee | 2 | 1 | 2 | 0 | 4 | 1 | 2 | 4 | jkmlee@ucdavis.edu |
| Event | Date | Time | Name | N.Tickets | Priority | Granted | Deficit | Ranking | plusone.Priority | n.Members | n.Total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| San Francisco Symphony | 2024-05-11 | 7:30 PM | Jonah Messinger | 2 | 2 | 2 | 0 | 1 | 2 | 7 | 14 | jmessinger@ucdavis.edu |
| Hiromi’s sonicwonder | 2024-04-18 | 7:30 PM | Jonah Messinger | 2 | 3 | 2 | 0 | 2 | 3 | 9 | 18 | jmessinger@ucdavis.edu |
| Wanda Sykes | 2024-05-31 | 7:30 PM | Jonah Messinger | 2 | 12 | 1 | 1 | 3 | 12 | 17 | 33 | jmessinger@ucdavis.edu |
| An Evening with David Sedaris | 2024-05-08 | 7:30 PM | Jonah Messinger | 2 | 7 | 1 | 1 | 4 | 6 | 10 | 18 | jmessinger@ucdavis.edu |
| Emmet Cohen Organ Trio | 2024-05-17 | 7:30 PM | Jonah Messinger | 2 | 3 | 1 | 1 | 5 | 2 | 3 | 5 | jmessinger@ucdavis.edu |
| Event | Date | Time | Name | N.Tickets | Priority | Granted | Deficit | Ranking | plusone.Priority | n.Members | n.Total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Dance Theatre of Harlem | 2024-04-17 | 7:30 PM | Kelsey Hadfield | 2 | 6 | 1 | 1 | 1 | 6 | 14 | 28 | kthadfield@ucdavis.edu |
| Hiromi’s sonicwonder | 2024-04-18 | 7:30 PM | Kelsey Hadfield | 2 | 1 | 2 | 0 | 2 | 1 | 9 | 18 | kthadfield@ucdavis.edu |
| An Evening with David Sedaris | 2024-05-08 | 7:30 PM | Kelsey Hadfield | 2 | 4 | 1 | 1 | 3 | 3 | 10 | 18 | kthadfield@ucdavis.edu |
| Emmet Cohen Organ Trio | 2024-05-18 | 7:30 PM | Kelsey Hadfield | 2 | 1 | 2 | 0 | 4 | 1 | 1 | 2 | kthadfield@ucdavis.edu |
| San Francisco Symphony | 2024-05-11 | 7:30 PM | Kelsey Hadfield | 2 | 6 | 1 | 1 | 5 | 6 | 7 | 14 | kthadfield@ucdavis.edu |
| Event | Date | Time | Name | N.Tickets | Priority | Granted | Deficit | Ranking | plusone.Priority | n.Members | n.Total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Wanda Sykes | 2024-05-31 | 7:30 PM | Kyla Hibbard | 2 | 2 | 1 | 1 | 1 | 2 | 17 | 33 | kbcleary@ucdavis.edu |
| An Evening with David Sedaris | 2024-05-08 | 7:30 PM | Kyla Hibbard | 1 | 1 | 1 | 0 | 2 | 9 | 10 | 18 | kbcleary@ucdavis.edu |
| Hiromi’s sonicwonder | 2024-04-18 | 7:30 PM | Kyla Hibbard | 2 | 6 | 1 | 1 | 3 | 6 | 9 | 18 | kbcleary@ucdavis.edu |
| Dance Theatre of Harlem | 2024-04-17 | 7:30 PM | Kyla Hibbard | 2 | 11 | 1 | 1 | 4 | 11 | 14 | 28 | kbcleary@ucdavis.edu |
| Bedtime Stories by URLAND | 2024-04-26 | 7:30 PM | Kyla Hibbard | 1 | 1 | 1 | 0 | 5 | 1 | 1 | 1 | kbcleary@ucdavis.edu |
| Event | Date | Time | Name | N.Tickets | Priority | Granted | Deficit | Ranking | plusone.Priority | n.Members | n.Total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Jordi Savall & Hespèrion XXI | 2024-04-13 | 7:30 PM | Laurie San Martin | 2 | 1 | 2 | 0 | 1 | 1 | 3 | 6 | lasanmartin@ucdavis.edu |
| San Francisco Symphony | 2024-05-11 | 7:30 PM | Laurie San Martin | 2 | 4 | 2 | 0 | 2 | 4 | 7 | 14 | lasanmartin@ucdavis.edu |
| Academy of St Martin in the Fields with Joshua Bell | 2024-04-06 | 7:30 PM | Laurie San Martin | 2 | 6 | 1 | 1 | 3 | 6 | 10 | 20 | lasanmartin@ucdavis.edu |
| Dance Theatre of Harlem | 2024-04-17 | 7:30 PM | Laurie San Martin | 2 | 13 | 0 | 2 | 4 | 13 | 14 | 28 | lasanmartin@ucdavis.edu |
| An Evening with David Sedaris | 2024-05-08 | 7:30 PM | Laurie San Martin | 2 | 8 | 1 | 1 | 5 | 7 | 10 | 18 | lasanmartin@ucdavis.edu |
| Wanda Sykes | 2024-05-31 | 7:30 PM | Laurie San Martin | 2 | 16 | 0 | 2 | 6 | 16 | 17 | 33 | lasanmartin@ucdavis.edu |
| Event | Date | Time | Name | N.Tickets | Priority | Granted | Deficit | Ranking | plusone.Priority | n.Members | n.Total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Academy of St Martin in the Fields with Joshua Bell | 2024-04-06 | 7:30 PM | Lee Miller | 2 | 4 | 1 | 1 | 1 | 4 | 10 | 20 | leemiller@ucdavis.edu |
| Dance Theatre of Harlem | 2024-04-17 | 7:30 PM | Lee Miller | 2 | 8 | 1 | 1 | 2 | 8 | 14 | 28 | leemiller@ucdavis.edu |
| Alexander String Quartet | 2024-05-05 | 2:00 PM | Lee Miller | 2 | 2 | 2 | 0 | 3 | 2 | 4 | 8 | leemiller@ucdavis.edu |
| Event | Date | Time | Name | N.Tickets | Priority | Granted | Deficit | Ranking | plusone.Priority | n.Members | n.Total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Academy of St Martin in the Fields with Joshua Bell | 2024-04-06 | 7:30 PM | Mahek Bhora | 2 | 5 | 1 | 1 | 1 | 5 | 10 | 20 | mbhora@ucdavis.edu |
| Triplets of Belleville | 2024-04-05 | 7:30 PM | Mahek Bhora | 2 | 1 | 2 | 0 | 2 | 1 | 6 | 11 | mbhora@ucdavis.edu |
| An Evening with David Sedaris | 2024-05-08 | 7:30 PM | Mahek Bhora | 2 | 5 | 1 | 1 | 3 | 4 | 10 | 18 | mbhora@ucdavis.edu |
| Hiromi’s sonicwonder | 2024-04-18 | 7:30 PM | Mahek Bhora | 2 | 7 | 1 | 1 | 4 | 7 | 9 | 18 | mbhora@ucdavis.edu |
| Event | Date | Time | Name | N.Tickets | Priority | Granted | Deficit | Ranking | plusone.Priority | n.Members | n.Total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Dance Theatre of Harlem | 2024-04-17 | 7:30 PM | Mark Brunet | 2 | 2 | 1 | 1 | 1 | 2 | 14 | 28 | mbrunet@ucdavis.edu |
| Wanda Sykes | 2024-05-31 | 7:30 PM | Mark Brunet | 2 | 8 | 1 | 1 | 2 | 8 | 17 | 33 | mbrunet@ucdavis.edu |
| Event | Date | Time | Name | N.Tickets | Priority | Granted | Deficit | Ranking | plusone.Priority | n.Members | n.Total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Emmet Cohen Organ Trio | 2024-05-17 | 7:30 PM | Naoki Saito | 1 | 1 | 1 | 0 | 1 | 3 | 3 | 5 | nsaito@ucdavis.edu |
| Event | Date | Time | Name | N.Tickets | Priority | Granted | Deficit | Ranking | plusone.Priority | n.Members | n.Total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Wanda Sykes | 2024-05-31 | 7:30 PM | Ned Spang | 2 | 5 | 1 | 1 | 1 | 5 | 17 | 33 | esspang@ucdavis.edu |
| Event | Date | Time | Name | N.Tickets | Priority | Granted | Deficit | Ranking | plusone.Priority | n.Members | n.Total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Academy of St Martin in the Fields with Joshua Bell | 2024-04-06 | 7:30 PM | Pauline Moreira | 2 | 1 | 2 | 0 | 1 | 1 | 10 | 20 | pmetzgar@ucdavis.edu |
| Wanda Sykes | 2024-05-31 | 7:30 PM | Pauline Moreira | 2 | 10 | 1 | 1 | 2 | 10 | 17 | 33 | pmetzgar@ucdavis.edu |
| Triplets of Belleville | 2024-04-05 | 7:30 PM | Pauline Moreira | 2 | 2 | 2 | 0 | 3 | 2 | 6 | 11 | pmetzgar@ucdavis.edu |
| Dance Theatre of Harlem | 2024-04-17 | 7:30 PM | Pauline Moreira | 2 | 12 | 1 | 1 | 4 | 12 | 14 | 28 | pmetzgar@ucdavis.edu |
| Event | Date | Time | Name | N.Tickets | Priority | Granted | Deficit | Ranking | plusone.Priority | n.Members | n.Total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Wanda Sykes | 2024-05-31 | 7:30 PM | Shelby Campbell | 2 | 6 | 1 | 1 | 1 | 6 | 17 | 33 | slcampbell@ucdavis.edu |
| Emmet Cohen Organ Trio | 2024-05-17 | 7:30 PM | Shelby Campbell | 2 | 2 | 2 | 0 | 2 | 1 | 3 | 5 | slcampbell@ucdavis.edu |
| Academy of St Martin in the Fields with Joshua Bell | 2024-04-06 | 7:30 PM | Shelby Campbell | 2 | 7 | 1 | 1 | 3 | 7 | 10 | 20 | slcampbell@ucdavis.edu |
| Jordi Savall & Hespèrion XXI | 2024-04-13 | 7:30 PM | Shelby Campbell | 2 | 3 | 2 | 0 | 4 | 3 | 3 | 6 | slcampbell@ucdavis.edu |
| Event | Date | Time | Name | N.Tickets | Priority | Granted | Deficit | Ranking | plusone.Priority | n.Members | n.Total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Wanda Sykes | 2024-05-31 | 7:30 PM | Sheri Hagoes | 2 | 1 | 1 | 1 | 1 | 1 | 17 | 33 | shagoes@ucdavis.edu |
| Event | Date | Time | Name | N.Tickets | Priority | Granted | Deficit | Ranking | plusone.Priority | n.Members | n.Total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Dance Theatre of Harlem | 2024-04-17 | 7:30 PM | Stephanie Syphers | 2 | 3 | 1 | 1 | 1 | 3 | 14 | 28 | ssyphers@ucdavis.edu |
| San Francisco Symphony | 2024-05-11 | 7:30 PM | Stephanie Syphers | 2 | 3 | 2 | 0 | 2 | 3 | 7 | 14 | ssyphers@ucdavis.edu |
| Academy of St Martin in the Fields with Joshua Bell | 2024-04-06 | 7:30 PM | Stephanie Syphers | 2 | 8 | 1 | 1 | 3 | 8 | 10 | 20 | ssyphers@ucdavis.edu |
| Triplets of Belleville | 2024-04-05 | 7:30 PM | Stephanie Syphers | 2 | 5 | 2 | 0 | 4 | 5 | 6 | 11 | ssyphers@ucdavis.edu |
| Bedtime Stories by URLAND | 2024-04-27 | 7:30 PM | Stephanie Syphers | 1 | 2 | 1 | 0 | 5 | 2 | 2 | 3 | ssyphers@ucdavis.edu |
| Wanda Sykes | 2024-05-31 | 7:30 PM | Stephanie Syphers | 2 | 15 | 0 | 2 | 6 | 15 | 17 | 33 | ssyphers@ucdavis.edu |
| Alexander String Quartet | 2024-05-05 | 2:00 PM | Stephanie Syphers | 2 | 4 | 2 | 0 | 7 | 4 | 4 | 8 | ssyphers@ucdavis.edu |
| Event | Date | Time | Name | N.Tickets | Priority | Granted | Deficit | Ranking | plusone.Priority | n.Members | n.Total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Academy of St Martin in the Fields with Joshua Bell | 2024-04-06 | 7:30 PM | Susette Min | 2 | 3 | 1 | 1 | 1 | 3 | 10 | 20 | ssmin@ucdavis.edu |
| Alexander String Quartet | 2024-05-05 | 2:00 PM | Susette Min | 2 | 1 | 2 | 0 | 2 | 1 | 4 | 8 | ssmin@ucdavis.edu |
| Event | Date | Time | Name | N.Tickets | Priority | Granted | Deficit | Ranking | plusone.Priority | n.Members | n.Total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Dance Theatre of Harlem | 2024-04-17 | 7:30 PM | inga renate langford | 2 | 4 | 1 | 1 | 1 | 4 | 14 | 28 | irlangford@ucdavis.edu |
| An Evening with David Sedaris | 2024-05-08 | 7:30 PM | inga renate langford | 2 | 3 | 2 | 0 | 2 | 2 | 10 | 18 | irlangford@ucdavis.edu |
| Wanda Sykes | 2024-05-31 | 7:30 PM | inga renate langford | 2 | 13 | 0 | 2 | 3 | 13 | 17 | 33 | irlangford@ucdavis.edu |
[[1]] NULL
[[2]] NULL
[[3]] NULL
[[4]] NULL
[[5]] NULL
[[6]] NULL
[[7]] NULL
[[8]] NULL
[[9]] NULL
[[10]] NULL
[[11]] NULL
[[12]] NULL
[[13]] NULL
[[14]] NULL
[[15]] NULL
[[16]] NULL
[[17]] NULL
[[18]] NULL
[[19]] NULL
[[20]] NULL
[[21]] NULL
[[22]] NULL
[[23]] NULL
We are given d_ij = # tickets asked by member j for event i (this is your spreadsheet) and r_ij = member j’s rank for event i
For each event i, compute n.Members = # members who asked for tickets = sum(j : d_ij > 0); ask_ij = 1 if d_ij > 0, 0 if d_ij = 0; n.Total = # tickets asked = sum(j : d_ij); Allocation = # tickets Allocation (12 is default for Jackson Hall, 4 for VST); Priority = member’s Ranking within members who asked for that event;
S_ij = subset(data, ask_ij = 1) –> sort ascending by r_ij;
n.Members > Allocation, then set g_ij = 1 for the first (Allocation) members … If too many members asked, some get 1 (for whom this event has high rank), some get 0, no one gets 2
If n.Members < Allocation but n.Total > Allocation, set g_ij = 1 for all j, then increment g_ij by 1 for the (Allocation - n.Members) top-ranked j’s for whom d_ij = 2 … If enough tickets for members but not enough for their +1 requests, all get at least 1 ticket, some get 2 (for whom this was high rank)
If n.Total =< Allocation, set g_ij = d_ij … If enough tickets to satisfy all requests, do so.