MCAAC Ticket Allocation (Spring 2023)

Ticket Allocation Logic

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); Available = # tickets allocated (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;

Tickets Granted (g_ij = 0 / 1 / 2) … for each event i, use the data subset S_ij

n.Members > Available, then set g_ij = 1 for the first Available 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 < Available but n.Total > Available, set g_ij = 1 for all j, then increment g_ij by 1 for the (Available - 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 =< Available, set g_ij = d_ij … If enough tickets to satisfy all requests, do so.

Survey Data

Let’s read the Survey data using the “by event” file.

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 > Available) - 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 > Available but n.Members < Available)

Here is an example of the data set we have now, including the newly added columns.

X	Name	Event	Ranking	Number.of.Tickets	Priority	plusone	plusone.Priority	n.Total	n.Members	Available	Email	Accessibility.Needs
78	Jessica Lee	Theatre Heroes \| Sunday, May 7, 2023 \| 2:00 PM	2	2	3	1	3	16	8	12	jkmlee@ucdavis.edu
79	Pauline Moreira	Theatre Heroes \| Sunday, May 7, 2023 \| 2:00 PM	4	2	4	1	4	16	8	12	pmetzgar@ucdavis.edu	none
55	Jennie Moylan	Jad Abumrad \| Thursday, April 20, 2023 \| 7:30 PM	2	2	2	1	1	9	5	12	jwmoylan@ucdavis.edu	none
31	Hemant Kumar Bhargava	Recovered Voices \| Monday, April 10, 2023 \| 7:30 PM	8	2	2	1	2	4	2	12	hemantb@ucdavis.edu
61	Molly McCarthy	Ukulele Orchestra of Great Britain \| Friday, April 28, 2023 \| 7:30 PM	2	1	3	0	7	15	9	12	molmccarthy@ucdavis.edu

Allocation

Now we allocate the tickets based on number requested, your Rank for the event (i.e., converted into Priority and plusone.Priority).

The basic idea is that if an event is over-demamded, then members who have Priority level lower than available tickets (i.e., a higher number than Available) unfortunately do not get a ticket.

Otherwise if n.Members < (or equal to) Available then everyone gets at least one ticket. If n.Total < Available then everyone gets as many tickets as they asked for (i.e., 1 or 2) If n.Total > Available then only a few people (= Available - n.Members) can get 2 tickets, and these are the ones with the best plusone.Priority levels.

Allocation Report by Event

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.

Alexander String Quartet 3 | Sunday, April 2, 2023 | 2:00 PM
Event	Name	N.Tickets	Priority	Granted	Deficit	Ranking	plusone.Priority	n.Members	n.Total
Alexander String Quartet 3 \| Sunday, April 2, 2023 \| 2:00 PM	Lee Miller	2	1	2	0	3	1	2	3
Alexander String Quartet 3 \| Sunday, April 2, 2023 \| 2:00 PM	Lauren Camp	1	2	1	0	10	2	2	3

Alvin Ailey American Dance Theater | Tuesday, April 18, 2023 | 7:30 PM
Event	Name	N.Tickets	Priority	Granted	Deficit	Ranking	plusone.Priority	n.Members	n.Total
Alvin Ailey American Dance Theater \| Tuesday, April 18, 2023 \| 7:30 PM	Elisa White	2	1	2	0	1	1	8	15
Alvin Ailey American Dance Theater \| Tuesday, April 18, 2023 \| 7:30 PM	Susette S Min	2	2	2	0	1	2	8	15
Alvin Ailey American Dance Theater \| Tuesday, April 18, 2023 \| 7:30 PM	Inga Renate Langford	2	3	2	0	1	3	8	15
Alvin Ailey American Dance Theater \| Tuesday, April 18, 2023 \| 7:30 PM	Jennie Moylan	2	4	2	0	1	4	8	15
Alvin Ailey American Dance Theater \| Tuesday, April 18, 2023 \| 7:30 PM	Satinder Kaur Bhatti	2	5	1	1	1	5	8	15
Alvin Ailey American Dance Theater \| Tuesday, April 18, 2023 \| 7:30 PM	Morgan Wong	1	6	1	0	2	8	8	15
Alvin Ailey American Dance Theater \| Tuesday, April 18, 2023 \| 7:30 PM	Laurie San Martin	2	7	1	1	3	6	8	15
Alvin Ailey American Dance Theater \| Tuesday, April 18, 2023 \| 7:30 PM	Tom Patten	2	8	1	1	7	7	8	15

Alvin Ailey American Dance Theater | Wednesday, April 19, 2023 | 7:30 PM
Event	Name	N.Tickets	Priority	Granted	Deficit	Ranking	plusone.Priority	n.Members	n.Total
Alvin Ailey American Dance Theater \| Wednesday, April 19, 2023 \| 7:30 PM	Molly McCarthy	2	1	2	0	1	1	10	18
Alvin Ailey American Dance Theater \| Wednesday, April 19, 2023 \| 7:30 PM	Inga Renate Langford	2	2	2	0	2	2	10	18
Alvin Ailey American Dance Theater \| Wednesday, April 19, 2023 \| 7:30 PM	Cecilia Giulivi	2	3	1	1	2	3	10	18
Alvin Ailey American Dance Theater \| Wednesday, April 19, 2023 \| 7:30 PM	Pauline Moreira	2	4	1	1	2	4	10	18
Alvin Ailey American Dance Theater \| Wednesday, April 19, 2023 \| 7:30 PM	Morgan Wong	1	5	1	0	3	9	10	18
Alvin Ailey American Dance Theater \| Wednesday, April 19, 2023 \| 7:30 PM	Ian Earley	2	6	1	1	3	5	10	18
Alvin Ailey American Dance Theater \| Wednesday, April 19, 2023 \| 7:30 PM	Lauren Camp	1	7	1	0	4	10	10	18
Alvin Ailey American Dance Theater \| Wednesday, April 19, 2023 \| 7:30 PM	Laurie San Martin	2	8	1	1	4	6	10	18
Alvin Ailey American Dance Theater \| Wednesday, April 19, 2023 \| 7:30 PM	mark Brunet	2	9	1	1	4	7	10	18
Alvin Ailey American Dance Theater \| Wednesday, April 19, 2023 \| 7:30 PM	Hemant Kumar Bhargava	2	10	1	1	7	8	10	18

Curtis Symphony | Sunday, May 21, 2023 | 2:00 PM
Event	Name	N.Tickets	Priority	Granted	Ranking	plusone.Priority	n.Members	n.Total
Curtis Symphony \| Sunday, May 21, 2023 \| 2:00 PM	Naoki Saito	2	1	2	1	1	6	11
Curtis Symphony \| Sunday, May 21, 2023 \| 2:00 PM	Hemant Kumar Bhargava	2	2	2	2	2	6	11
Curtis Symphony \| Sunday, May 21, 2023 \| 2:00 PM	Jessica Lee	2	3	2	3	3	6	11
Curtis Symphony \| Sunday, May 21, 2023 \| 2:00 PM	Morgan Wong	1	4	1	4	6	6	11
Curtis Symphony \| Sunday, May 21, 2023 \| 2:00 PM	Lee Miller	2	5	2	4	4	6	11
Curtis Symphony \| Sunday, May 21, 2023 \| 2:00 PM	Laurie San Martin	2	6	2	5	5	6	11

Jad Abumrad | Thursday, April 20, 2023 | 7:30 PM
Event	Name	N.Tickets	Priority	Granted	Ranking	plusone.Priority	n.Members	n.Total
Jad Abumrad \| Thursday, April 20, 2023 \| 7:30 PM	Aidan Carr	1	1	1	1	5	5	9
Jad Abumrad \| Thursday, April 20, 2023 \| 7:30 PM	Jennie Moylan	2	2	2	2	1	5	9
Jad Abumrad \| Thursday, April 20, 2023 \| 7:30 PM	Tom Patten	2	3	2	3	2	5	9
Jad Abumrad \| Thursday, April 20, 2023 \| 7:30 PM	Heather Martin	2	4	2	3	3	5	9
Jad Abumrad \| Thursday, April 20, 2023 \| 7:30 PM	Cecilia Giulivi	2	5	2	3	4	5	9

Lara Downes & John McWhorter | Friday, May 5, 2023 | 7:30 PM
Event	Name	N.Tickets	Priority	Granted	Ranking	plusone.Priority	n.Members	n.Total
Lara Downes & John McWhorter \| Friday, May 5, 2023 \| 7:30 PM	Naoki Saito	1	1	1	4	2	3	4
Lara Downes & John McWhorter \| Friday, May 5, 2023 \| 7:30 PM	Tom Patten	2	2	2	6	1	3	4
Lara Downes & John McWhorter \| Friday, May 5, 2023 \| 7:30 PM	Lauren Camp	1	3	1	6	3	3	4

Meow Meow | Friday, March 31, 2023 | 7:30 PM
Event	Name	N.Tickets	Priority	Granted	Deficit	Ranking	plusone.Priority	n.Members	n.Total
Meow Meow \| Friday, March 31, 2023 \| 7:30 PM	mark Brunet	2	1	2	0	1	1	8	14
Meow Meow \| Friday, March 31, 2023 \| 7:30 PM	Jessica Lee	2	2	2	0	1	2	8	14
Meow Meow \| Friday, March 31, 2023 \| 7:30 PM	Tom Patten	2	3	2	0	2	3	8	14
Meow Meow \| Friday, March 31, 2023 \| 7:30 PM	Heather Martin	2	4	2	0	2	4	8	14
Meow Meow \| Friday, March 31, 2023 \| 7:30 PM	Lauren Camp	1	5	1	0	3	7	8	14
Meow Meow \| Friday, March 31, 2023 \| 7:30 PM	Elisa White	2	6	1	1	4	5	8	14
Meow Meow \| Friday, March 31, 2023 \| 7:30 PM	Jennie Moylan	2	7	1	1	5	6	8	14
Meow Meow \| Friday, March 31, 2023 \| 7:30 PM	Aidan Carr	1	8	1	0	6	8	8	14

Ranky Tanky with Dom Flemons | Saturday, April 1, 2023 | 7:30 PM
Event	Name	N.Tickets	Priority	Granted	Ranking	plusone.Priority	n.Members	n.Total
Ranky Tanky with Dom Flemons \| Saturday, April 1, 2023 \| 7:30 PM	Femi-Jide Anthony Akinmoladun	2	1	2	1	1	7	12
Ranky Tanky with Dom Flemons \| Saturday, April 1, 2023 \| 7:30 PM	Pauline Moreira	2	2	2	1	2	7	12
Ranky Tanky with Dom Flemons \| Saturday, April 1, 2023 \| 7:30 PM	mark Brunet	2	3	2	2	3	7	12
Ranky Tanky with Dom Flemons \| Saturday, April 1, 2023 \| 7:30 PM	Tom Patten	1	4	1	5	6	7	12
Ranky Tanky with Dom Flemons \| Saturday, April 1, 2023 \| 7:30 PM	Aidan Carr	1	5	1	5	7	7	12
Ranky Tanky with Dom Flemons \| Saturday, April 1, 2023 \| 7:30 PM	Lauren Camp	2	6	2	5	4	7	12
Ranky Tanky with Dom Flemons \| Saturday, April 1, 2023 \| 7:30 PM	Elisa White	2	7	2	9	5	7	12

Recovered Voices | Monday, April 10, 2023 | 7:30 PM
Event	Name	N.Tickets	Priority	Granted	Deficit	Ranking	plusone.Priority	n.Members	n.Total
Recovered Voices \| Monday, April 10, 2023 \| 7:30 PM	Ian Earley	2	1	2	0	2	1	2	4
Recovered Voices \| Monday, April 10, 2023 \| 7:30 PM	Hemant Kumar Bhargava	2	2	2	0	8	2	2	4

Recovered Voices | Tuesday, April 11, 2023 | 7:30 PM
Event	Name	N.Tickets	Priority	Granted	Ranking	plusone.Priority	n.Members	n.Total
Recovered Voices \| Tuesday, April 11, 2023 \| 7:30 PM	Laurie San Martin	2	1	2	2	1	3	6
Recovered Voices \| Tuesday, April 11, 2023 \| 7:30 PM	Jennie Moylan	2	2	2	4	2	3	6
Recovered Voices \| Tuesday, April 11, 2023 \| 7:30 PM	Elisa White	2	3	2	7	3	3	6

Rodrigo Y Gabriela | Sunday, June 4, 2023 | 2:00 PM
Event	Name	N.Tickets	Priority	Granted	Deficit	Ranking	plusone.Priority	n.Members	n.Total
Rodrigo Y Gabriela \| Sunday, June 4, 2023 \| 2:00 PM	Ian Earley	2	1	2	0	1	1	11	21
Rodrigo Y Gabriela \| Sunday, June 4, 2023 \| 2:00 PM	Lauren Camp	2	2	1	1	1	2	11	21
Rodrigo Y Gabriela \| Sunday, June 4, 2023 \| 2:00 PM	Cecilia Giulivi	2	3	1	1	1	3	11	21
Rodrigo Y Gabriela \| Sunday, June 4, 2023 \| 2:00 PM	Tom Patten	2	4	1	1	1	4	11	21
Rodrigo Y Gabriela \| Sunday, June 4, 2023 \| 2:00 PM	Naoki Saito	1	5	1	0	2	11	11	21
Rodrigo Y Gabriela \| Sunday, June 4, 2023 \| 2:00 PM	Caroline Bamforth Firman	2	6	1	1	2	5	11	21
Rodrigo Y Gabriela \| Sunday, June 4, 2023 \| 2:00 PM	Aidan Carr	2	7	1	1	3	6	11	21
Rodrigo Y Gabriela \| Sunday, June 4, 2023 \| 2:00 PM	Satinder Kaur Bhatti	2	8	1	1	3	7	11	21
Rodrigo Y Gabriela \| Sunday, June 4, 2023 \| 2:00 PM	Hemant Kumar Bhargava	2	9	1	1	5	8	11	21
Rodrigo Y Gabriela \| Sunday, June 4, 2023 \| 2:00 PM	mark Brunet	2	10	1	1	6	9	11	21
Rodrigo Y Gabriela \| Sunday, June 4, 2023 \| 2:00 PM	Elisa White	2	11	1	1	8	10	11	21

Sammy Miller and The Congregation | Friday, April 7, 2023 | 7:30 PM
Event	Name	N.Tickets	Priority	Granted	Ranking	plusone.Priority	n.Members	n.Total
Sammy Miller and The Congregation \| Friday, April 7, 2023 \| 7:30 PM	mark Brunet	1	1	1	3	1	3	3
Sammy Miller and The Congregation \| Friday, April 7, 2023 \| 7:30 PM	Elisa White	1	2	1	6	2	3	3
Sammy Miller and The Congregation \| Friday, April 7, 2023 \| 7:30 PM	Lauren Camp	1	3	1	8	3	3	3

Sammy Miller and The Congregation | Saturday, April 8, 2023 | 7:30 PM
Event	Name	N.Tickets	Priority	Granted	Ranking	plusone.Priority	n.Members	n.Total
Sammy Miller and The Congregation \| Saturday, April 8, 2023 \| 7:30 PM	Lauren Camp	1	1	1	2	1	3	3
Sammy Miller and The Congregation \| Saturday, April 8, 2023 \| 7:30 PM	Heather Martin	1	2	1	4	2	3	3
Sammy Miller and The Congregation \| Saturday, April 8, 2023 \| 7:30 PM	Aidan Carr	1	3	1	4	3	3	3

Sammy Miller and The Congregation | Thursday, April 6, 2023 | 7:30 PM
Event	Name	N.Tickets	Priority	Granted	Ranking	plusone.Priority	n.Members	n.Total
Sammy Miller and The Congregation \| Thursday, April 6, 2023 \| 7:30 PM	Hemant Kumar Bhargava	1	1	1	1	1	3	3
Sammy Miller and The Congregation \| Thursday, April 6, 2023 \| 7:30 PM	Jennie Moylan	1	2	1	3	2	3	3
Sammy Miller and The Congregation \| Thursday, April 6, 2023 \| 7:30 PM	Lauren Camp	1	3	1	7	3	3	3

Theatre Heroes | Sunday, May 7, 2023 | 2:00 PM
Event	Name	N.Tickets	Priority	Granted	Deficit	Ranking	plusone.Priority	n.Members	n.Total
Theatre Heroes \| Sunday, May 7, 2023 \| 2:00 PM	Morgan Wong	2	1	2	0	1	1	8	16
Theatre Heroes \| Sunday, May 7, 2023 \| 2:00 PM	Satinder Kaur Bhatti	2	2	2	0	2	2	8	16
Theatre Heroes \| Sunday, May 7, 2023 \| 2:00 PM	Jessica Lee	2	3	2	0	2	3	8	16
Theatre Heroes \| Sunday, May 7, 2023 \| 2:00 PM	Pauline Moreira	2	4	2	0	4	4	8	16
Theatre Heroes \| Sunday, May 7, 2023 \| 2:00 PM	Cecilia Giulivi	2	5	1	1	4	5	8	16
Theatre Heroes \| Sunday, May 7, 2023 \| 2:00 PM	Elisa White	2	6	1	1	5	6	8	16
Theatre Heroes \| Sunday, May 7, 2023 \| 2:00 PM	Heather Martin	2	7	1	1	5	7	8	16
Theatre Heroes \| Sunday, May 7, 2023 \| 2:00 PM	Hemant Kumar Bhargava	2	8	1	1	6	8	8	16

Ukulele Orchestra of Great Britain | Friday, April 28, 2023 | 7:30 PM
Event	Name	N.Tickets	Priority	Granted	Deficit	Ranking	plusone.Priority	n.Members	n.Total
Ukulele Orchestra of Great Britain \| Friday, April 28, 2023 \| 7:30 PM	Heather Martin	2	1	2	0	1	1	9	15
Ukulele Orchestra of Great Britain \| Friday, April 28, 2023 \| 7:30 PM	Elisa White	2	2	2	0	2	2	9	15
Ukulele Orchestra of Great Britain \| Friday, April 28, 2023 \| 7:30 PM	Molly McCarthy	1	3	1	0	2	7	9	15
Ukulele Orchestra of Great Britain \| Friday, April 28, 2023 \| 7:30 PM	Aidan Carr	2	4	2	0	2	3	9	15
Ukulele Orchestra of Great Britain \| Friday, April 28, 2023 \| 7:30 PM	Naoki Saito	1	5	1	0	3	8	9	15
Ukulele Orchestra of Great Britain \| Friday, April 28, 2023 \| 7:30 PM	Hemant Kumar Bhargava	2	6	1	1	3	4	9	15
Ukulele Orchestra of Great Britain \| Friday, April 28, 2023 \| 7:30 PM	Tom Patten	2	7	1	1	4	5	9	15
Ukulele Orchestra of Great Britain \| Friday, April 28, 2023 \| 7:30 PM	mark Brunet	2	8	1	1	5	6	9	15
Ukulele Orchestra of Great Britain \| Friday, April 28, 2023 \| 7:30 PM	Lauren Camp	1	9	1	0	9	9	9	15

Ulysses Owens & J’Nai Bridges | Sunday, April 30, 2023 | 7:30 PM
Event	Name	N.Tickets	Priority	Granted	Ranking	plusone.Priority	n.Members	n.Total
Ulysses Owens & J’Nai Bridges \| Sunday, April 30, 2023 \| 7:30 PM	Lee Miller	2	1	2	1	1	5	9
Ulysses Owens & J’Nai Bridges \| Sunday, April 30, 2023 \| 7:30 PM	Femi-Jide Anthony Akinmoladun	1	2	1	2	5	5	9
Ulysses Owens & J’Nai Bridges \| Sunday, April 30, 2023 \| 7:30 PM	Elisa White	2	3	2	3	2	5	9
Ulysses Owens & J’Nai Bridges \| Sunday, April 30, 2023 \| 7:30 PM	Pauline Moreira	2	4	2	3	3	5	9
Ulysses Owens & J’Nai Bridges \| Sunday, April 30, 2023 \| 7:30 PM	Hemant Kumar Bhargava	2	5	2	4	4	5	9

Vladimir Feltsman, piano | Saturday, April 8, 2023 | 7:30 PM
Event	Name	N.Tickets	Priority	Granted	Ranking	plusone.Priority	n.Members	n.Total
Vladimir Feltsman, piano \| Saturday, April 8, 2023 \| 7:30 PM	Laurie San Martin	2	1	2	1	1	4	7
Vladimir Feltsman, piano \| Saturday, April 8, 2023 \| 7:30 PM	Caroline Bamforth Firman	2	2	2	1	2	4	7
Vladimir Feltsman, piano \| Saturday, April 8, 2023 \| 7:30 PM	Lee Miller	2	3	2	2	3	4	7
Vladimir Feltsman, piano \| Saturday, April 8, 2023 \| 7:30 PM	Morgan Wong	1	4	1	5	4	4	7

[[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

Allocation Report by Member