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.
Now we need to assign Priorities to member-show matches based on the Rankings given by the members.
Combine the two data sets (“Show” is the common column), and bring in Allocation columns from shows.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.
| Show | Name | Rank | Priority | Allocation | X | Event | Venue | Date | Time | Tickets.Requested | Accessibility | plusone | n.Total | n.Members | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Youn Sun Nah (2024-11-09; 7:30 PM) | Daniel Herman | 4 | 1 | 4 | 16 | dcherman@ucdavis.edu | Youn Sun Nah | Vanderhoef Studio Theatre | 2024-11-09 | 7:30 PM | 1 | 0 | 3 | 2 | |
| Jazz at Lincoln Center Orchestra Big Band Holidays (2024-12-03; 7:30 PM) | Kyla Hibbard | 1 | 1 | 12 | 39 | kbcleary@ucdavis.edu | Jazz at Lincoln Center Orchestra Big Band Holidays | Jackson Hall | 2024-12-03 | 7:30 PM | 2 | 1 | 12 | 7 | |
| Encanto: The Sing-Along Film Concert (2024-11-22; 7:30 PM) | Hemant Bhargava | 6 | 1 | 12 | 6 | hemantb@gmail.com | Encanto: The Sing-Along Film Concert | Jackson Hall | 2024-11-22 | 7:30 PM | 2 | 1 | 6 | 3 | |
| Sean Mason (2024-10-11; 7:30 PM) | Hemant Bhargava | 3 | 2 | 4 | 3 | hemantb@gmail.com | Sean Mason | Vanderhoef Studio Theatre | 2024-10-11 | 7:30 PM | 1 | 0 | 5 | 3 | |
| Baratunde Thurston (2024-10-23; 7:30 PM) | Ned Spang | 2 | 1 | 12 | 24 | esspang@ucdavis.edu | Baratunde Thurston | Jackson Hall | 2024-10-23 | 7:30 PM | 2 | 1 | 8 | 5 |
Now we allocate the tickets based on number requested, your Rank for the event (i.e., converted into Priority and plusone.Priority).
If total event.demand < available.seats then Grant as many tickets (1 or 2) as requested;
Otherwise, if n.members >= available.seats, then Grant 1 ticket to members with highest priority;
Otherwise, if n.members < available.seats, then Grant 1 seat to each member who requests, and grant a +1 based on plusone.Priority
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 | Venue | Name | N.Tickets | Priority | Granted | Deficit | Rank | plusone.Priority | n.Members | n.Total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Aida Cuevas | 2024-10-05 | 7:30 PM | Jackson Hall | Daniel Herman | 2 | 1 | 2 | 0 | 7 | 1 | 2 | 4 |
| Aida Cuevas | 2024-10-05 | 7:30 PM | Jackson Hall | Hemant Bhargava | 2 | 2 | 2 | 0 | 8 | 2 | 2 | 4 |
| Event | Date | Time | Venue | Name | N.Tickets | Priority | Granted | Deficit | Rank | plusone.Priority | n.Members | n.Total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| London Philharmonic Orchestra | 2024-10-09 | 7:30 PM | Jackson Hall | Daniel Herman | 2 | 1 | 2 | 0 | 1 | 1 | 8 | 13 |
| London Philharmonic Orchestra | 2024-10-09 | 7:30 PM | Jackson Hall | Stephanie Syphers | 2 | 2 | 2 | 0 | 1 | 2 | 8 | 13 |
| London Philharmonic Orchestra | 2024-10-09 | 7:30 PM | Jackson Hall | Aidan Carr | 1 | 3 | 1 | 0 | 1 | 6 | 8 | 13 |
| London Philharmonic Orchestra | 2024-10-09 | 7:30 PM | Jackson Hall | Caroline Bamforth | 2 | 4 | 2 | 0 | 2 | 3 | 8 | 13 |
| London Philharmonic Orchestra | 2024-10-09 | 7:30 PM | Jackson Hall | Mahek Bhora | 1 | 5 | 1 | 0 | 2 | 7 | 8 | 13 |
| London Philharmonic Orchestra | 2024-10-09 | 7:30 PM | Jackson Hall | Pauline Moreira | 2 | 6 | 2 | 0 | 2 | 4 | 8 | 13 |
| London Philharmonic Orchestra | 2024-10-09 | 7:30 PM | Jackson Hall | Jonah Messinger | 2 | 7 | 1 | 1 | 3 | 5 | 8 | 13 |
| London Philharmonic Orchestra | 2024-10-09 | 7:30 PM | Jackson Hall | Kyla Hibbard | 1 | 8 | 1 | 0 | 5 | 8 | 8 | 13 |
| Event | Date | Time | Venue | Name | N.Tickets | Priority | Granted | Deficit | Rank | plusone.Priority | n.Members | n.Total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Sean Mason | 2024-10-10 | 7:30 PM | Vanderhoef Studio Theatre | Jonah Messinger | 2 | 1 | 2 | 0 | 1 | 1 | 3 | 5 |
| Sean Mason | 2024-10-10 | 7:30 PM | Vanderhoef Studio Theatre | Stephanie Syphers | 2 | 2 | 1 | 1 | 5 | 2 | 3 | 5 |
| Sean Mason | 2024-10-10 | 7:30 PM | Vanderhoef Studio Theatre | Daniel Herman | 1 | 3 | 1 | 0 | 5 | 3 | 3 | 5 |
| Event | Date | Time | Venue | Name | N.Tickets | Priority | Granted | Deficit | Rank | plusone.Priority | n.Members | n.Total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Sean Mason | 2024-10-11 | 7:30 PM | Vanderhoef Studio Theatre | Aidan Carr | 2 | 1 | 2 | 0 | 2 | 1 | 3 | 5 |
| Sean Mason | 2024-10-11 | 7:30 PM | Vanderhoef Studio Theatre | Hemant Bhargava | 1 | 2 | 1 | 0 | 3 | 3 | 3 | 5 |
| Sean Mason | 2024-10-11 | 7:30 PM | Vanderhoef Studio Theatre | Kyla Hibbard | 2 | 3 | 1 | 1 | 6 | 2 | 3 | 5 |
| Event | Date | Time | Venue | Name | N.Tickets | Priority | Granted | Deficit | Rank | plusone.Priority | n.Members | n.Total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Mariza | 2024-10-18 | 7:30 PM | Jackson Hall | Cecilia Giulivi | 2 | 1 | 2 | 0 | 3 | 1 | 2 | 4 |
| Mariza | 2024-10-18 | 7:30 PM | Jackson Hall | Kyla Hibbard | 2 | 2 | 2 | 0 | 10 | 2 | 2 | 4 |
| Event | Date | Time | Venue | Name | N.Tickets | Priority | Granted | Deficit | Rank | plusone.Priority | n.Members | n.Total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Spider-Man: Across the Spider-Verse Live in Concert | 2024-10-19 | 7:30 PM | Jackson Hall | Hemant Bhargava | 2 | 1 | 2 | 0 | 1 | 1 | 7 | 12 |
| Spider-Man: Across the Spider-Verse Live in Concert | 2024-10-19 | 7:30 PM | Jackson Hall | Caroline Bamforth | 2 | 2 | 2 | 0 | 1 | 2 | 7 | 12 |
| Spider-Man: Across the Spider-Verse Live in Concert | 2024-10-19 | 7:30 PM | Jackson Hall | Shruti Kakar | 2 | 3 | 2 | 0 | 1 | 3 | 7 | 12 |
| Spider-Man: Across the Spider-Verse Live in Concert | 2024-10-19 | 7:30 PM | Jackson Hall | Cecilia Giulivi | 2 | 4 | 2 | 0 | 1 | 4 | 7 | 12 |
| Spider-Man: Across the Spider-Verse Live in Concert | 2024-10-19 | 7:30 PM | Jackson Hall | Mahek Bhora | 1 | 5 | 1 | 0 | 1 | 6 | 7 | 12 |
| Spider-Man: Across the Spider-Verse Live in Concert | 2024-10-19 | 7:30 PM | Jackson Hall | Jonah Messinger | 2 | 6 | 2 | 0 | 2 | 5 | 7 | 12 |
| Spider-Man: Across the Spider-Verse Live in Concert | 2024-10-19 | 7:30 PM | Jackson Hall | Aidan Carr | 1 | 7 | 1 | 0 | 7 | 7 | 7 | 12 |
| Event | Date | Time | Venue | Name | N.Tickets | Priority | Granted | Deficit | Rank | plusone.Priority | n.Members | n.Total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Sons of Mystro | 2024-10-20 | 2:00 PM | Jackson Hall | Pauline Moreira | 2 | 1 | 2 | 0 | 1 | 1 | 4 | 8 |
| Sons of Mystro | 2024-10-20 | 2:00 PM | Jackson Hall | Jonah Messinger | 2 | 2 | 2 | 0 | 4 | 2 | 4 | 8 |
| Sons of Mystro | 2024-10-20 | 2:00 PM | Jackson Hall | Daniel Herman | 2 | 3 | 2 | 0 | 6 | 3 | 4 | 8 |
| Sons of Mystro | 2024-10-20 | 2:00 PM | Jackson Hall | Stephanie Syphers | 2 | 4 | 2 | 0 | 8 | 4 | 4 | 8 |
| Event | Date | Time | Venue | Name | N.Tickets | Priority | Granted | Deficit | Rank | plusone.Priority | n.Members | n.Total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Baratunde Thurston | 2024-10-23 | 7:30 PM | Jackson Hall | Ned Spang | 2 | 1 | 2 | 0 | 2 | 1 | 5 | 8 |
| Baratunde Thurston | 2024-10-23 | 7:30 PM | Jackson Hall | Hemant Bhargava | 2 | 2 | 2 | 0 | 2 | 2 | 5 | 8 |
| Baratunde Thurston | 2024-10-23 | 7:30 PM | Jackson Hall | Stephanie Syphers | 2 | 3 | 2 | 0 | 2 | 3 | 5 | 8 |
| Baratunde Thurston | 2024-10-23 | 7:30 PM | Jackson Hall | Kyla Hibbard | 1 | 4 | 1 | 0 | 4 | 4 | 5 | 8 |
| Baratunde Thurston | 2024-10-23 | 7:30 PM | Jackson Hall | Aidan Carr | 1 | 5 | 1 | 0 | 6 | 5 | 5 | 8 |
| Event | Date | Time | Venue | Name | N.Tickets | Priority | Granted | Deficit | Rank | plusone.Priority | n.Members | n.Total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| An Evening With Brittney Griner | 2024-11-03 | 7:30 PM | Jackson Hall | Kyla Hibbard | 1 | 1 | 1 | 0 | 2 | 2 | 2 | 3 |
| An Evening With Brittney Griner | 2024-11-03 | 7:30 PM | Jackson Hall | Hemant Bhargava | 2 | 2 | 2 | 0 | 7 | 1 | 2 | 3 |
| Event | Date | Time | Venue | Name | N.Tickets | Priority | Granted | Deficit | Rank | plusone.Priority | n.Members | n.Total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Cloud Gate Dance Theatre of Taiwan | 2024-11-07 | 7:30 PM | Jackson Hall | Stephanie Syphers | 2 | 1 | 2 | 0 | 4 | 1 | 3 | 4 |
| Cloud Gate Dance Theatre of Taiwan | 2024-11-07 | 7:30 PM | Jackson Hall | Aidan Carr | 1 | 2 | 1 | 0 | 5 | 2 | 3 | 4 |
| Cloud Gate Dance Theatre of Taiwan | 2024-11-07 | 7:30 PM | Jackson Hall | Kyla Hibbard | 1 | 3 | 1 | 0 | 7 | 3 | 3 | 4 |
| Event | Date | Time | Venue | Name | N.Tickets | Priority | Granted | Deficit | Rank | plusone.Priority | n.Members | n.Total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| An Evening With W. Kamau Bell | 2024-11-08 | 7:30 PM | Jackson Hall | Ned Spang | 2 | 1 | 2 | 0 | 1 | 1 | 5 | 9 |
| An Evening With W. Kamau Bell | 2024-11-08 | 7:30 PM | Jackson Hall | Langford | 2 | 2 | 2 | 0 | 1 | 2 | 5 | 9 |
| An Evening With W. Kamau Bell | 2024-11-08 | 7:30 PM | Jackson Hall | Stephanie Syphers | 2 | 3 | 2 | 0 | 3 | 3 | 5 | 9 |
| An Evening With W. Kamau Bell | 2024-11-08 | 7:30 PM | Jackson Hall | Kyla Hibbard | 1 | 4 | 1 | 0 | 3 | 5 | 5 | 9 |
| An Evening With W. Kamau Bell | 2024-11-08 | 7:30 PM | Jackson Hall | Cecilia Giulivi | 2 | 5 | 2 | 0 | 4 | 4 | 5 | 9 |
| Event | Date | Time | Venue | Name | N.Tickets | Priority | Granted | Deficit | Rank | plusone.Priority | n.Members | n.Total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Youn Sun Nah | 2024-11-08 | 7:30 PM | Vanderhoef Studio Theatre | Aidan Carr | 2 | 1 | 2 | 0 | 3 | 1 | 2 | 4 |
| Youn Sun Nah | 2024-11-08 | 7:30 PM | Vanderhoef Studio Theatre | Hemant Bhargava | 2 | 2 | 2 | 0 | 9 | 2 | 2 | 4 |
| Event | Date | Time | Venue | Name | N.Tickets | Priority | Granted | Deficit | Rank | plusone.Priority | n.Members | n.Total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Youn Sun Nah | 2024-11-09 | 7:30 PM | Vanderhoef Studio Theatre | Daniel Herman | 1 | 1 | 1 | 0 | 4 | 2 | 2 | 3 |
| Youn Sun Nah | 2024-11-09 | 7:30 PM | Vanderhoef Studio Theatre | Stephanie Syphers | 2 | 2 | 2 | 0 | 7 | 1 | 2 | 3 |
| Event | Date | Time | Venue | Name | N.Tickets | Priority | Granted | Deficit | Rank | plusone.Priority | n.Members | n.Total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Manetti Shrem Opera Gaetano Donizetti’s Don Pasquale | 2024-11-15 | 7:30 PM | Jackson Hall | Naoki Saito | 2 | 1 | 2 | 0 | 1 | 1 | 3 | 5 |
| Manetti Shrem Opera Gaetano Donizetti’s Don Pasquale | 2024-11-15 | 7:30 PM | Jackson Hall | Cecilia Giulivi | 2 | 2 | 2 | 0 | 2 | 2 | 3 | 5 |
| Manetti Shrem Opera Gaetano Donizetti’s Don Pasquale | 2024-11-15 | 7:30 PM | Jackson Hall | Kyla Hibbard | 1 | 3 | 1 | 0 | 9 | 3 | 3 | 5 |
| Event | Date | Time | Venue | Name | N.Tickets | Priority | Granted | Deficit | Rank | plusone.Priority | n.Members | n.Total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 123 Andrés | 2024-11-17 | 2:00 PM | Jackson Hall | Kyla Hibbard | 2 | 1 | 2 | 0 | 11 | 1 | 1 | 2 |
| Event | Date | Time | Venue | Name | N.Tickets | Priority | Granted | Deficit | Rank | plusone.Priority | n.Members | n.Total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Encanto: The Sing-Along Film Concert | 2024-11-22 | 7:30 PM | Jackson Hall | Hemant Bhargava | 2 | 1 | 2 | 0 | 6 | 1 | 3 | 6 |
| Encanto: The Sing-Along Film Concert | 2024-11-22 | 7:30 PM | Jackson Hall | Stephanie Syphers | 2 | 2 | 2 | 0 | 6 | 2 | 3 | 6 |
| Encanto: The Sing-Along Film Concert | 2024-11-22 | 7:30 PM | Jackson Hall | Kyla Hibbard | 2 | 3 | 2 | 0 | 12 | 3 | 3 | 6 |
| Event | Date | Time | Venue | Name | N.Tickets | Priority | Granted | Deficit | Rank | plusone.Priority | n.Members | n.Total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Alexander String Quartet with Robert Greenberg | 2024-12-01 | 2:00 PM | Jackson Hall | Pauline Moreira | 2 | 1 | 2 | 0 | 3 | 1 | 3 | 6 |
| Alexander String Quartet with Robert Greenberg | 2024-12-01 | 2:00 PM | Jackson Hall | Jonah Messinger | 2 | 2 | 2 | 0 | 6 | 2 | 3 | 6 |
| Alexander String Quartet with Robert Greenberg | 2024-12-01 | 2:00 PM | Jackson Hall | Stephanie Syphers | 2 | 3 | 2 | 0 | 9 | 3 | 3 | 6 |
| Event | Date | Time | Venue | Name | N.Tickets | Priority | Granted | Deficit | Rank | plusone.Priority | n.Members | n.Total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Jazz at Lincoln Center Orchestra Big Band Holidays | 2024-12-03 | 7:30 PM | Jackson Hall | Kyla Hibbard | 2 | 1 | 2 | 0 | 1 | 1 | 7 | 12 |
| Jazz at Lincoln Center Orchestra Big Band Holidays | 2024-12-03 | 7:30 PM | Jackson Hall | Naoki Saito | 1 | 2 | 1 | 0 | 2 | 6 | 7 | 12 |
| Jazz at Lincoln Center Orchestra Big Band Holidays | 2024-12-03 | 7:30 PM | Jackson Hall | Daniel Herman | 2 | 3 | 2 | 0 | 3 | 2 | 7 | 12 |
| Jazz at Lincoln Center Orchestra Big Band Holidays | 2024-12-03 | 7:30 PM | Jackson Hall | Langford | 2 | 4 | 2 | 0 | 3 | 3 | 7 | 12 |
| Jazz at Lincoln Center Orchestra Big Band Holidays | 2024-12-03 | 7:30 PM | Jackson Hall | Hemant Bhargava | 2 | 5 | 2 | 0 | 5 | 4 | 7 | 12 |
| Jazz at Lincoln Center Orchestra Big Band Holidays | 2024-12-03 | 7:30 PM | Jackson Hall | Jonah Messinger | 2 | 6 | 2 | 0 | 5 | 5 | 7 | 12 |
| Jazz at Lincoln Center Orchestra Big Band Holidays | 2024-12-03 | 7:30 PM | Jackson Hall | Aidan Carr | 1 | 7 | 1 | 0 | 8 | 7 | 7 | 12 |
| Event | Date | Time | Venue | Name | N.Tickets | Priority | Granted | Deficit | Rank | plusone.Priority | n.Members | n.Total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Pink Martini | 2024-12-04 | 7:30 PM | Jackson Hall | Langford | 2 | 1 | 2 | 0 | 2 | 1 | 5 | 9 |
| Pink Martini | 2024-12-04 | 7:30 PM | Jackson Hall | Daniel Herman | 2 | 2 | 2 | 0 | 2 | 2 | 5 | 9 |
| Pink Martini | 2024-12-04 | 7:30 PM | Jackson Hall | Hemant Bhargava | 2 | 3 | 2 | 0 | 4 | 3 | 5 | 9 |
| Pink Martini | 2024-12-04 | 7:30 PM | Jackson Hall | Aidan Carr | 2 | 4 | 2 | 0 | 4 | 4 | 5 | 9 |
| Pink Martini | 2024-12-04 | 7:30 PM | Jackson Hall | Kyla Hibbard | 1 | 5 | 1 | 0 | 8 | 5 | 5 | 9 |
[[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
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 | Venue | Name | N.Tickets | Priority | Granted | Deficit | Rank | plusone.Priority | n.Members | n.Total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| London Philharmonic Orchestra | 2024-10-09 | 7:30 PM | Jackson Hall | Aidan Carr | 1 | 3 | 1 | 0 | 1 | 6 | 8 | 13 | ajcarr@ucdavis.edu |
| Sean Mason | 2024-10-11 | 7:30 PM | Vanderhoef Studio Theatre | Aidan Carr | 2 | 1 | 2 | 0 | 2 | 1 | 3 | 5 | ajcarr@ucdavis.edu |
| Youn Sun Nah | 2024-11-08 | 7:30 PM | Vanderhoef Studio Theatre | Aidan Carr | 2 | 1 | 2 | 0 | 3 | 1 | 2 | 4 | ajcarr@ucdavis.edu |
| Pink Martini | 2024-12-04 | 7:30 PM | Jackson Hall | Aidan Carr | 2 | 4 | 2 | 0 | 4 | 4 | 5 | 9 | ajcarr@ucdavis.edu |
| Cloud Gate Dance Theatre of Taiwan | 2024-11-07 | 7:30 PM | Jackson Hall | Aidan Carr | 1 | 2 | 1 | 0 | 5 | 2 | 3 | 4 | ajcarr@ucdavis.edu |
| Baratunde Thurston | 2024-10-23 | 7:30 PM | Jackson Hall | Aidan Carr | 1 | 5 | 1 | 0 | 6 | 5 | 5 | 8 | ajcarr@ucdavis.edu |
| Spider-Man: Across the Spider-Verse Live in Concert | 2024-10-19 | 7:30 PM | Jackson Hall | Aidan Carr | 1 | 7 | 1 | 0 | 7 | 7 | 7 | 12 | ajcarr@ucdavis.edu |
| Jazz at Lincoln Center Orchestra Big Band Holidays | 2024-12-03 | 7:30 PM | Jackson Hall | Aidan Carr | 1 | 7 | 1 | 0 | 8 | 7 | 7 | 12 | ajcarr@ucdavis.edu |
| Event | Date | Time | Venue | Name | N.Tickets | Priority | Granted | Deficit | Rank | plusone.Priority | n.Members | n.Total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Spider-Man: Across the Spider-Verse Live in Concert | 2024-10-19 | 7:30 PM | Jackson Hall | Caroline Bamforth | 2 | 2 | 2 | 0 | 1 | 2 | 7 | 12 | cjbamforth@ucdavis.edu |
| London Philharmonic Orchestra | 2024-10-09 | 7:30 PM | Jackson Hall | Caroline Bamforth | 2 | 4 | 2 | 0 | 2 | 3 | 8 | 13 | cjbamforth@ucdavis.edu |
| Event | Date | Time | Venue | Name | N.Tickets | Priority | Granted | Deficit | Rank | plusone.Priority | n.Members | n.Total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Spider-Man: Across the Spider-Verse Live in Concert | 2024-10-19 | 7:30 PM | Jackson Hall | Cecilia Giulivi | 2 | 4 | 2 | 0 | 1 | 4 | 7 | 12 | cgiulivi@ucdavis.edu |
| Manetti Shrem Opera Gaetano Donizetti’s Don Pasquale | 2024-11-15 | 7:30 PM | Jackson Hall | Cecilia Giulivi | 2 | 2 | 2 | 0 | 2 | 2 | 3 | 5 | cgiulivi@ucdavis.edu |
| Mariza | 2024-10-18 | 7:30 PM | Jackson Hall | Cecilia Giulivi | 2 | 1 | 2 | 0 | 3 | 1 | 2 | 4 | cgiulivi@ucdavis.edu |
| An Evening With W. Kamau Bell | 2024-11-08 | 7:30 PM | Jackson Hall | Cecilia Giulivi | 2 | 5 | 2 | 0 | 4 | 4 | 5 | 9 | cgiulivi@ucdavis.edu |
| Event | Date | Time | Venue | Name | N.Tickets | Priority | Granted | Deficit | Rank | plusone.Priority | n.Members | n.Total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| London Philharmonic Orchestra | 2024-10-09 | 7:30 PM | Jackson Hall | Daniel Herman | 2 | 1 | 2 | 0 | 1 | 1 | 8 | 13 | dcherman@ucdavis.edu |
| Pink Martini | 2024-12-04 | 7:30 PM | Jackson Hall | Daniel Herman | 2 | 2 | 2 | 0 | 2 | 2 | 5 | 9 | dcherman@ucdavis.edu |
| Jazz at Lincoln Center Orchestra Big Band Holidays | 2024-12-03 | 7:30 PM | Jackson Hall | Daniel Herman | 2 | 3 | 2 | 0 | 3 | 2 | 7 | 12 | dcherman@ucdavis.edu |
| Youn Sun Nah | 2024-11-09 | 7:30 PM | Vanderhoef Studio Theatre | Daniel Herman | 1 | 1 | 1 | 0 | 4 | 2 | 2 | 3 | dcherman@ucdavis.edu |
| Sean Mason | 2024-10-10 | 7:30 PM | Vanderhoef Studio Theatre | Daniel Herman | 1 | 3 | 1 | 0 | 5 | 3 | 3 | 5 | dcherman@ucdavis.edu |
| Sons of Mystro | 2024-10-20 | 2:00 PM | Jackson Hall | Daniel Herman | 2 | 3 | 2 | 0 | 6 | 3 | 4 | 8 | dcherman@ucdavis.edu |
| Aida Cuevas | 2024-10-05 | 7:30 PM | Jackson Hall | Daniel Herman | 2 | 1 | 2 | 0 | 7 | 1 | 2 | 4 | dcherman@ucdavis.edu |
| Event | Date | Time | Venue | Name | N.Tickets | Priority | Granted | Deficit | Rank | plusone.Priority | n.Members | n.Total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Spider-Man: Across the Spider-Verse Live in Concert | 2024-10-19 | 7:30 PM | Jackson Hall | Hemant Bhargava | 2 | 1 | 2 | 0 | 1 | 1 | 7 | 12 | hemantb@gmail.com |
| Baratunde Thurston | 2024-10-23 | 7:30 PM | Jackson Hall | Hemant Bhargava | 2 | 2 | 2 | 0 | 2 | 2 | 5 | 8 | hemantb@gmail.com |
| Sean Mason | 2024-10-11 | 7:30 PM | Vanderhoef Studio Theatre | Hemant Bhargava | 1 | 2 | 1 | 0 | 3 | 3 | 3 | 5 | hemantb@gmail.com |
| Pink Martini | 2024-12-04 | 7:30 PM | Jackson Hall | Hemant Bhargava | 2 | 3 | 2 | 0 | 4 | 3 | 5 | 9 | hemantb@gmail.com |
| Jazz at Lincoln Center Orchestra Big Band Holidays | 2024-12-03 | 7:30 PM | Jackson Hall | Hemant Bhargava | 2 | 5 | 2 | 0 | 5 | 4 | 7 | 12 | hemantb@gmail.com |
| Encanto: The Sing-Along Film Concert | 2024-11-22 | 7:30 PM | Jackson Hall | Hemant Bhargava | 2 | 1 | 2 | 0 | 6 | 1 | 3 | 6 | hemantb@gmail.com |
| An Evening With Brittney Griner | 2024-11-03 | 7:30 PM | Jackson Hall | Hemant Bhargava | 2 | 2 | 2 | 0 | 7 | 1 | 2 | 3 | hemantb@gmail.com |
| Aida Cuevas | 2024-10-05 | 7:30 PM | Jackson Hall | Hemant Bhargava | 2 | 2 | 2 | 0 | 8 | 2 | 2 | 4 | hemantb@gmail.com |
| Youn Sun Nah | 2024-11-08 | 7:30 PM | Vanderhoef Studio Theatre | Hemant Bhargava | 2 | 2 | 2 | 0 | 9 | 2 | 2 | 4 | hemantb@gmail.com |
| Event | Date | Time | Venue | Name | N.Tickets | Priority | Granted | Deficit | Rank | plusone.Priority | n.Members | n.Total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Sean Mason | 2024-10-10 | 7:30 PM | Vanderhoef Studio Theatre | Jonah Messinger | 2 | 1 | 2 | 0 | 1 | 1 | 3 | 5 | jmessinger@ucdavis.edu |
| Spider-Man: Across the Spider-Verse Live in Concert | 2024-10-19 | 7:30 PM | Jackson Hall | Jonah Messinger | 2 | 6 | 2 | 0 | 2 | 5 | 7 | 12 | jmessinger@ucdavis.edu |
| London Philharmonic Orchestra | 2024-10-09 | 7:30 PM | Jackson Hall | Jonah Messinger | 2 | 7 | 1 | 1 | 3 | 5 | 8 | 13 | jmessinger@ucdavis.edu |
| Sons of Mystro | 2024-10-20 | 2:00 PM | Jackson Hall | Jonah Messinger | 2 | 2 | 2 | 0 | 4 | 2 | 4 | 8 | jmessinger@ucdavis.edu |
| Jazz at Lincoln Center Orchestra Big Band Holidays | 2024-12-03 | 7:30 PM | Jackson Hall | Jonah Messinger | 2 | 6 | 2 | 0 | 5 | 5 | 7 | 12 | jmessinger@ucdavis.edu |
| Alexander String Quartet with Robert Greenberg | 2024-12-01 | 2:00 PM | Jackson Hall | Jonah Messinger | 2 | 2 | 2 | 0 | 6 | 2 | 3 | 6 | jmessinger@ucdavis.edu |
| Event | Date | Time | Venue | Name | N.Tickets | Priority | Granted | Deficit | Rank | plusone.Priority | n.Members | n.Total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Jazz at Lincoln Center Orchestra Big Band Holidays | 2024-12-03 | 7:30 PM | Jackson Hall | Kyla Hibbard | 2 | 1 | 2 | 0 | 1 | 1 | 7 | 12 | kbcleary@ucdavis.edu |
| An Evening With Brittney Griner | 2024-11-03 | 7:30 PM | Jackson Hall | Kyla Hibbard | 1 | 1 | 1 | 0 | 2 | 2 | 2 | 3 | kbcleary@ucdavis.edu |
| An Evening With W. Kamau Bell | 2024-11-08 | 7:30 PM | Jackson Hall | Kyla Hibbard | 1 | 4 | 1 | 0 | 3 | 5 | 5 | 9 | kbcleary@ucdavis.edu |
| Baratunde Thurston | 2024-10-23 | 7:30 PM | Jackson Hall | Kyla Hibbard | 1 | 4 | 1 | 0 | 4 | 4 | 5 | 8 | kbcleary@ucdavis.edu |
| London Philharmonic Orchestra | 2024-10-09 | 7:30 PM | Jackson Hall | Kyla Hibbard | 1 | 8 | 1 | 0 | 5 | 8 | 8 | 13 | kbcleary@ucdavis.edu |
| Sean Mason | 2024-10-11 | 7:30 PM | Vanderhoef Studio Theatre | Kyla Hibbard | 2 | 3 | 1 | 1 | 6 | 2 | 3 | 5 | kbcleary@ucdavis.edu |
| Cloud Gate Dance Theatre of Taiwan | 2024-11-07 | 7:30 PM | Jackson Hall | Kyla Hibbard | 1 | 3 | 1 | 0 | 7 | 3 | 3 | 4 | kbcleary@ucdavis.edu |
| Pink Martini | 2024-12-04 | 7:30 PM | Jackson Hall | Kyla Hibbard | 1 | 5 | 1 | 0 | 8 | 5 | 5 | 9 | kbcleary@ucdavis.edu |
| Manetti Shrem Opera Gaetano Donizetti’s Don Pasquale | 2024-11-15 | 7:30 PM | Jackson Hall | Kyla Hibbard | 1 | 3 | 1 | 0 | 9 | 3 | 3 | 5 | kbcleary@ucdavis.edu |
| Mariza | 2024-10-18 | 7:30 PM | Jackson Hall | Kyla Hibbard | 2 | 2 | 2 | 0 | 10 | 2 | 2 | 4 | kbcleary@ucdavis.edu |
| 123 Andrés | 2024-11-17 | 2:00 PM | Jackson Hall | Kyla Hibbard | 2 | 1 | 2 | 0 | 11 | 1 | 1 | 2 | kbcleary@ucdavis.edu |
| Encanto: The Sing-Along Film Concert | 2024-11-22 | 7:30 PM | Jackson Hall | Kyla Hibbard | 2 | 3 | 2 | 0 | 12 | 3 | 3 | 6 | kbcleary@ucdavis.edu |
| Event | Date | Time | Venue | Name | N.Tickets | Priority | Granted | Deficit | Rank | plusone.Priority | n.Members | n.Total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| An Evening With W. Kamau Bell | 2024-11-08 | 7:30 PM | Jackson Hall | Langford | 2 | 2 | 2 | 0 | 1 | 2 | 5 | 9 | INGALANGFORD@gmail.com |
| Pink Martini | 2024-12-04 | 7:30 PM | Jackson Hall | Langford | 2 | 1 | 2 | 0 | 2 | 1 | 5 | 9 | INGALANGFORD@gmail.com |
| Jazz at Lincoln Center Orchestra Big Band Holidays | 2024-12-03 | 7:30 PM | Jackson Hall | Langford | 2 | 4 | 2 | 0 | 3 | 3 | 7 | 12 | INGALANGFORD@gmail.com |
| Event | Date | Time | Venue | Name | N.Tickets | Priority | Granted | Deficit | Rank | plusone.Priority | n.Members | n.Total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Spider-Man: Across the Spider-Verse Live in Concert | 2024-10-19 | 7:30 PM | Jackson Hall | Mahek Bhora | 1 | 5 | 1 | 0 | 1 | 6 | 7 | 12 | mbhora@ucdavis.edu |
| London Philharmonic Orchestra | 2024-10-09 | 7:30 PM | Jackson Hall | Mahek Bhora | 1 | 5 | 1 | 0 | 2 | 7 | 8 | 13 | mbhora@ucdavis.edu |
| Event | Date | Time | Venue | Name | N.Tickets | Priority | Granted | Deficit | Rank | plusone.Priority | n.Members | n.Total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Manetti Shrem Opera Gaetano Donizetti’s Don Pasquale | 2024-11-15 | 7:30 PM | Jackson Hall | Naoki Saito | 2 | 1 | 2 | 0 | 1 | 1 | 3 | 5 | nsaito@ucdavis.edu |
| Jazz at Lincoln Center Orchestra Big Band Holidays | 2024-12-03 | 7:30 PM | Jackson Hall | Naoki Saito | 1 | 2 | 1 | 0 | 2 | 6 | 7 | 12 | nsaito@ucdavis.edu |
| Event | Date | Time | Venue | Name | N.Tickets | Priority | Granted | Deficit | Rank | plusone.Priority | n.Members | n.Total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| An Evening With W. Kamau Bell | 2024-11-08 | 7:30 PM | Jackson Hall | Ned Spang | 2 | 1 | 2 | 0 | 1 | 1 | 5 | 9 | esspang@ucdavis.edu |
| Baratunde Thurston | 2024-10-23 | 7:30 PM | Jackson Hall | Ned Spang | 2 | 1 | 2 | 0 | 2 | 1 | 5 | 8 | esspang@ucdavis.edu |
| Event | Date | Time | Venue | Name | N.Tickets | Priority | Granted | Deficit | Rank | plusone.Priority | n.Members | n.Total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Sons of Mystro | 2024-10-20 | 2:00 PM | Jackson Hall | Pauline Moreira | 2 | 1 | 2 | 0 | 1 | 1 | 4 | 8 | pmetzgar@ucdavis.edu |
| London Philharmonic Orchestra | 2024-10-09 | 7:30 PM | Jackson Hall | Pauline Moreira | 2 | 6 | 2 | 0 | 2 | 4 | 8 | 13 | pmetzgar@ucdavis.edu |
| Alexander String Quartet with Robert Greenberg | 2024-12-01 | 2:00 PM | Jackson Hall | Pauline Moreira | 2 | 1 | 2 | 0 | 3 | 1 | 3 | 6 | pmetzgar@ucdavis.edu |
| Event | Date | Time | Venue | Name | N.Tickets | Priority | Granted | Deficit | Rank | plusone.Priority | n.Members | n.Total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Spider-Man: Across the Spider-Verse Live in Concert | 2024-10-19 | 7:30 PM | Jackson Hall | Shruti Kakar | 2 | 3 | 2 | 0 | 1 | 3 | 7 | 12 | skakar@ucdavis.edu |
| Event | Date | Time | Venue | Name | N.Tickets | Priority | Granted | Deficit | Rank | plusone.Priority | n.Members | n.Total | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| London Philharmonic Orchestra | 2024-10-09 | 7:30 PM | Jackson Hall | Stephanie Syphers | 2 | 2 | 2 | 0 | 1 | 2 | 8 | 13 | ssyphers@ucdavis.edu |
| Baratunde Thurston | 2024-10-23 | 7:30 PM | Jackson Hall | Stephanie Syphers | 2 | 3 | 2 | 0 | 2 | 3 | 5 | 8 | ssyphers@ucdavis.edu |
| An Evening With W. Kamau Bell | 2024-11-08 | 7:30 PM | Jackson Hall | Stephanie Syphers | 2 | 3 | 2 | 0 | 3 | 3 | 5 | 9 | ssyphers@ucdavis.edu |
| Cloud Gate Dance Theatre of Taiwan | 2024-11-07 | 7:30 PM | Jackson Hall | Stephanie Syphers | 2 | 1 | 2 | 0 | 4 | 1 | 3 | 4 | ssyphers@ucdavis.edu |
| Sean Mason | 2024-10-10 | 7:30 PM | Vanderhoef Studio Theatre | Stephanie Syphers | 2 | 2 | 1 | 1 | 5 | 2 | 3 | 5 | ssyphers@ucdavis.edu |
| Encanto: The Sing-Along Film Concert | 2024-11-22 | 7:30 PM | Jackson Hall | Stephanie Syphers | 2 | 2 | 2 | 0 | 6 | 2 | 3 | 6 | ssyphers@ucdavis.edu |
| Youn Sun Nah | 2024-11-09 | 7:30 PM | Vanderhoef Studio Theatre | Stephanie Syphers | 2 | 2 | 2 | 0 | 7 | 1 | 2 | 3 | ssyphers@ucdavis.edu |
| Sons of Mystro | 2024-10-20 | 2:00 PM | Jackson Hall | Stephanie Syphers | 2 | 4 | 2 | 0 | 8 | 4 | 4 | 8 | ssyphers@ucdavis.edu |
| Alexander String Quartet with Robert Greenberg | 2024-12-01 | 2:00 PM | Jackson Hall | Stephanie Syphers | 2 | 3 | 2 | 0 | 9 | 3 | 3 | 6 | ssyphers@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