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
50	Satinder Bhatti	Becca Stevens \| Thursday, February 9, 2023 \| 7:30 PM	5	2	7	1	4	14	9	12	skbhatti@ucdavis.edu
83	Molly McCarthy	Ballet Preljocaj - Swan Lake \| Sunday, March 5, 2023 \| 1:59 PM	2	2	5	1	5	30	15	12	molmccarthy@ucdavis.edu
78	Lauren Camp	Yamato - Hintori: The Wings of Phoenix \| Sunday, February 26, 2023 \| 1:59 PM	8	2	8	1	7	15	8	12	lcamp@ucdavis.edu	None
58	Jennie Moylan	Tig Notaro \| Saturday, February 11, 2023 \| 7:30 PM	2	2	6	1	6	19	10	12	jwmoylan@ucdavis.edu	none
31	Jennie Moylan	A Conversation with Nina Totenberg \| Friday, February 3, 2023 \| 7:30 PM	4	2	4	1	4	11	6	12	jwmoylan@ucdavis.edu	none

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.

A Conversation with Nina Totenberg | Friday, February 3, 2023 | 7:30 PM
Event	Name	N.Tickets	Granted	Ranking	Priority	plusone.Priority	n.Members	n.Total
A Conversation with Nina Totenberg \| Friday, February 3, 2023 \| 7:30 PM	Tom Patten	2	2	2	1	1	6	11
A Conversation with Nina Totenberg \| Friday, February 3, 2023 \| 7:30 PM	Satinder Bhatti	2	2	2	2	2	6	11
A Conversation with Nina Totenberg \| Friday, February 3, 2023 \| 7:30 PM	Hemant Bhargava	2	2	4	3	3	6	11
A Conversation with Nina Totenberg \| Friday, February 3, 2023 \| 7:30 PM	Jennie Moylan	2	2	4	4	4	6	11
A Conversation with Nina Totenberg \| Friday, February 3, 2023 \| 7:30 PM	Heather Martin	2	2	4	5	5	6	11
A Conversation with Nina Totenberg \| Friday, February 3, 2023 \| 7:30 PM	Lauren Camp	1	1	6	6	6	6	11

Alexander String Quartet 2 | Sunday, January 15, 2023 | 1:59 PM
Event	Name	N.Tickets	Granted	Ranking	Priority	plusone.Priority	n.Members	n.Total
Alexander String Quartet 2 \| Sunday, January 15, 2023 \| 1:59 PM	Lee Miller	2	2	2	1	1	2	4
Alexander String Quartet 2 \| Sunday, January 15, 2023 \| 1:59 PM	Pauline Moreira	2	2	6	2	2	2	4

Alfredo Rodriguez & Pedrito Martinez Duo | Saturday, February 25, 2023 | 7:30 PM
Event	Name	N.Tickets	Granted	Ranking	Priority	plusone.Priority	n.Members	n.Total
Alfredo Rodriguez & Pedrito Martinez Duo \| Saturday, February 25, 2023 \| 7:30 PM	Cecilia Giulivi	2	2	1	1	1	3	6
Alfredo Rodriguez & Pedrito Martinez Duo \| Saturday, February 25, 2023 \| 7:30 PM	Mark	2	2	4	2	2	3	6
Alfredo Rodriguez & Pedrito Martinez Duo \| Saturday, February 25, 2023 \| 7:30 PM	Hemant Bhargava	2	2	7	3	3	3	6

Ballet Preljocaj - Swan Lake | Sunday, March 5, 2023 | 1:59 PM
Event	Name	N.Tickets	Granted	Ranking	Priority	plusone.Priority	n.Members	n.Total
Ballet Preljocaj - Swan Lake \| Sunday, March 5, 2023 \| 1:59 PM	Jennie Moylan	2	1	1	1	1	15	30
Ballet Preljocaj - Swan Lake \| Sunday, March 5, 2023 \| 1:59 PM	Morgan Wong	2	1	1	2	2	15	30
Ballet Preljocaj - Swan Lake \| Sunday, March 5, 2023 \| 1:59 PM	Jessica Lee	2	1	2	3	3	15	30
Ballet Preljocaj - Swan Lake \| Sunday, March 5, 2023 \| 1:59 PM	Inga Langford	2	1	2	4	4	15	30
Ballet Preljocaj - Swan Lake \| Sunday, March 5, 2023 \| 1:59 PM	Molly McCarthy	2	1	2	5	5	15	30
Ballet Preljocaj - Swan Lake \| Sunday, March 5, 2023 \| 1:59 PM	Mark	2	1	2	6	6	15	30
Ballet Preljocaj - Swan Lake \| Sunday, March 5, 2023 \| 1:59 PM	Heather Martin	2	1	3	7	7	15	30
Ballet Preljocaj - Swan Lake \| Sunday, March 5, 2023 \| 1:59 PM	Jide Akinmoladun	2	1	3	8	8	15	30
Ballet Preljocaj - Swan Lake \| Sunday, March 5, 2023 \| 1:59 PM	Hemant Bhargava	2	1	3	9	9	15	30
Ballet Preljocaj - Swan Lake \| Sunday, March 5, 2023 \| 1:59 PM	Lee Miller	2	1	3	10	10	15	30
Ballet Preljocaj - Swan Lake \| Sunday, March 5, 2023 \| 1:59 PM	Lily Bhattacharjee	2	1	3	11	11	15	30
Ballet Preljocaj - Swan Lake \| Sunday, March 5, 2023 \| 1:59 PM	Cecilia Giulivi	2	1	3	12	12	15	30
Ballet Preljocaj - Swan Lake \| Sunday, March 5, 2023 \| 1:59 PM	Lauren Camp	2	0	4	13	13	15	30
Ballet Preljocaj - Swan Lake \| Sunday, March 5, 2023 \| 1:59 PM	Tom Patten	2	0	4	14	14	15	30
Ballet Preljocaj - Swan Lake \| Sunday, March 5, 2023 \| 1:59 PM	Satinder Bhatti	2	0	9	15	15	15	30

Barbara K Jackson Rising Stars of Opera | Sunday, February 5, 2023 | 1:59 PM
Event	Name	N.Tickets	Granted	Ranking	Priority	plusone.Priority	n.Members	n.Total
Barbara K Jackson Rising Stars of Opera \| Sunday, February 5, 2023 \| 1:59 PM	Caroline Bamforth Firman	2	2	2	1	1	3	6
Barbara K Jackson Rising Stars of Opera \| Sunday, February 5, 2023 \| 1:59 PM	Satinder Bhatti	2	2	3	2	2	3	6
Barbara K Jackson Rising Stars of Opera \| Sunday, February 5, 2023 \| 1:59 PM	Jessica Lee	2	2	4	3	3	3	6

Becca Stevens | Thursday, February 9, 2023 | 7:30 PM
Event	Name	N.Tickets	Granted	Ranking	Priority	plusone.Priority	n.Members	n.Total
Becca Stevens \| Thursday, February 9, 2023 \| 7:30 PM	Lily Bhattacharjee	2	2	2	1	1	9	14
Becca Stevens \| Thursday, February 9, 2023 \| 7:30 PM	Heather Martin	2	2	2	2	2	9	14
Becca Stevens \| Thursday, February 9, 2023 \| 7:30 PM	Aidan Carr	1	1	3	3	6	9	14
Becca Stevens \| Thursday, February 9, 2023 \| 7:30 PM	Molly McCarthy	1	1	3	4	7	9	14
Becca Stevens \| Thursday, February 9, 2023 \| 7:30 PM	Mark	2	2	3	5	3	9	14
Becca Stevens \| Thursday, February 9, 2023 \| 7:30 PM	Naoki Saito	1	1	4	6	8	9	14
Becca Stevens \| Thursday, February 9, 2023 \| 7:30 PM	Satinder Bhatti	2	1	5	7	4	9	14
Becca Stevens \| Thursday, February 9, 2023 \| 7:30 PM	Lauren Camp	1	1	7	8	9	9	14
Becca Stevens \| Thursday, February 9, 2023 \| 7:30 PM	Jennie Moylan	2	1	7	9	5	9	14

Cecile McLorin Salvant Quintet | Friday, January 27, 2023 | 7:30 PM
Event	Name	N.Tickets	Granted	Ranking	Priority	plusone.Priority	n.Members	n.Total
Cecile McLorin Salvant Quintet \| Friday, January 27, 2023 \| 7:30 PM	Molly McCarthy	1	1	1	1	5	6	10
Cecile McLorin Salvant Quintet \| Friday, January 27, 2023 \| 7:30 PM	Satinder Bhatti	2	2	1	2	1	6	10
Cecile McLorin Salvant Quintet \| Friday, January 27, 2023 \| 7:30 PM	Ian Earley	2	2	2	3	2	6	10
Cecile McLorin Salvant Quintet \| Friday, January 27, 2023 \| 7:30 PM	Lauren Camp	2	2	2	4	3	6	10
Cecile McLorin Salvant Quintet \| Friday, January 27, 2023 \| 7:30 PM	Naoki Saito	1	1	3	5	6	6	10
Cecile McLorin Salvant Quintet \| Friday, January 27, 2023 \| 7:30 PM	Mark	2	2	8	6	4	6	10

Emanual Ax, Leonidas Kavakos, Yo-Yo Ma | Tuesday, January 24, 2023 | 7:30 PM
Event	Name	N.Tickets	Granted	Ranking	Priority	plusone.Priority	n.Members	n.Total
Emanual Ax, Leonidas Kavakos, Yo-Yo Ma \| Tuesday, January 24, 2023 \| 7:30 PM	Ian Earley	2	1	1	1	1	13	22
Emanual Ax, Leonidas Kavakos, Yo-Yo Ma \| Tuesday, January 24, 2023 \| 7:30 PM	Jide Akinmoladun	1	1	1	2	10	13	22
Emanual Ax, Leonidas Kavakos, Yo-Yo Ma \| Tuesday, January 24, 2023 \| 7:30 PM	Pauline Moreira	2	1	1	3	2	13	22
Emanual Ax, Leonidas Kavakos, Yo-Yo Ma \| Tuesday, January 24, 2023 \| 7:30 PM	Caroline Bamforth Firman	2	1	1	4	3	13	22
Emanual Ax, Leonidas Kavakos, Yo-Yo Ma \| Tuesday, January 24, 2023 \| 7:30 PM	Naoki Saito	2	1	2	5	4	13	22
Emanual Ax, Leonidas Kavakos, Yo-Yo Ma \| Tuesday, January 24, 2023 \| 7:30 PM	Morgan Wong	1	1	2	6	11	13	22
Emanual Ax, Leonidas Kavakos, Yo-Yo Ma \| Tuesday, January 24, 2023 \| 7:30 PM	Susette Min	2	1	2	7	5	13	22
Emanual Ax, Leonidas Kavakos, Yo-Yo Ma \| Tuesday, January 24, 2023 \| 7:30 PM	Aidan Carr	1	1	2	8	12	13	22
Emanual Ax, Leonidas Kavakos, Yo-Yo Ma \| Tuesday, January 24, 2023 \| 7:30 PM	Cecilia Giulivi	2	1	2	9	6	13	22
Emanual Ax, Leonidas Kavakos, Yo-Yo Ma \| Tuesday, January 24, 2023 \| 7:30 PM	Hemant Bhargava	2	1	2	10	7	13	22
Emanual Ax, Leonidas Kavakos, Yo-Yo Ma \| Tuesday, January 24, 2023 \| 7:30 PM	Lauren Camp	1	1	3	11	13	13	22
Emanual Ax, Leonidas Kavakos, Yo-Yo Ma \| Tuesday, January 24, 2023 \| 7:30 PM	Jennie Moylan	2	1	5	12	8	13	22
Emanual Ax, Leonidas Kavakos, Yo-Yo Ma \| Tuesday, January 24, 2023 \| 7:30 PM	Tom Patten	2	0	6	13	9	13	22

Itzak Perlman, violin & Rohan De Silva, piano | Saturday, January 14, 2023 | 7:30 PM
Event	Name	N.Tickets	Granted	Ranking	Priority	plusone.Priority	n.Members	n.Total
Itzak Perlman, violin & Rohan De Silva, piano \| Saturday, January 14, 2023 \| 7:30 PM	Hemant Bhargava	2	2	1	1	1	7	12
Itzak Perlman, violin & Rohan De Silva, piano \| Saturday, January 14, 2023 \| 7:30 PM	Naoki Saito	2	2	1	2	2	7	12
Itzak Perlman, violin & Rohan De Silva, piano \| Saturday, January 14, 2023 \| 7:30 PM	Pauline Moreira	2	2	2	3	3	7	12
Itzak Perlman, violin & Rohan De Silva, piano \| Saturday, January 14, 2023 \| 7:30 PM	Lily Bhattacharjee	1	1	4	4	6	7	12
Itzak Perlman, violin & Rohan De Silva, piano \| Saturday, January 14, 2023 \| 7:30 PM	Mark	2	2	7	5	4	7	12
Itzak Perlman, violin & Rohan De Silva, piano \| Saturday, January 14, 2023 \| 7:30 PM	Tom Patten	1	1	7	6	7	7	12
Itzak Perlman, violin & Rohan De Silva, piano \| Saturday, January 14, 2023 \| 7:30 PM	Jennie Moylan	2	2	10	7	5	7	12

Los Lobos with Gaby Moreno | Saturday, March 18, 2023 | 7:30 PM
Event	Name	N.Tickets	Granted	Ranking	Priority	plusone.Priority	n.Members	n.Total
Los Lobos with Gaby Moreno \| Saturday, March 18, 2023 \| 7:30 PM	Mark	2	2	1	1	1	8	15
Los Lobos with Gaby Moreno \| Saturday, March 18, 2023 \| 7:30 PM	Jennie Moylan	2	2	3	2	2	8	15
Los Lobos with Gaby Moreno \| Saturday, March 18, 2023 \| 7:30 PM	Jessica Lee	2	2	3	3	3	8	15
Los Lobos with Gaby Moreno \| Saturday, March 18, 2023 \| 7:30 PM	Pauline Moreira	2	2	3	4	4	8	15
Los Lobos with Gaby Moreno \| Saturday, March 18, 2023 \| 7:30 PM	Jide Akinmoladun	2	1	4	5	5	8	15
Los Lobos with Gaby Moreno \| Saturday, March 18, 2023 \| 7:30 PM	Lauren Camp	2	1	5	6	6	8	15
Los Lobos with Gaby Moreno \| Saturday, March 18, 2023 \| 7:30 PM	Aidan Carr	1	1	6	7	8	8	15
Los Lobos with Gaby Moreno \| Saturday, March 18, 2023 \| 7:30 PM	Tom Patten	2	1	9	8	7	8	15

Michael Barenboim & West-Eastern Divan Ensemble | Friday, March 10, 2023 | 7:30 PM
Event	Name	N.Tickets	Granted	Ranking	Priority	plusone.Priority	n.Members	n.Total
Michael Barenboim & West-Eastern Divan Ensemble \| Friday, March 10, 2023 \| 7:30 PM	Morgan Wong	1	1	4	1	4	4	7
Michael Barenboim & West-Eastern Divan Ensemble \| Friday, March 10, 2023 \| 7:30 PM	Hemant Bhargava	2	2	5	2	1	4	7
Michael Barenboim & West-Eastern Divan Ensemble \| Friday, March 10, 2023 \| 7:30 PM	Pauline Moreira	2	2	5	3	2	4	7
Michael Barenboim & West-Eastern Divan Ensemble \| Friday, March 10, 2023 \| 7:30 PM	Jennie Moylan	2	2	9	4	3	4	7

Pink Martini with China Forbes | Tuesday, February 7, 2023 | 7:30 PM
Event	Name	N.Tickets	Granted	Ranking	Priority	plusone.Priority	n.Members	n.Total
Pink Martini with China Forbes \| Tuesday, February 7, 2023 \| 7:30 PM	Aidan Carr	2	2	1	1	1	7	14
Pink Martini with China Forbes \| Tuesday, February 7, 2023 \| 7:30 PM	Inga Langford	2	2	1	2	2	7	14
Pink Martini with China Forbes \| Tuesday, February 7, 2023 \| 7:30 PM	Tom Patten	2	2	3	3	3	7	14
Pink Martini with China Forbes \| Tuesday, February 7, 2023 \| 7:30 PM	Pauline Moreira	2	2	4	4	4	7	14
Pink Martini with China Forbes \| Tuesday, February 7, 2023 \| 7:30 PM	Satinder Bhatti	2	2	4	5	5	7	14
Pink Martini with China Forbes \| Tuesday, February 7, 2023 \| 7:30 PM	Jennie Moylan	2	1	6	6	6	7	14
Pink Martini with China Forbes \| Tuesday, February 7, 2023 \| 7:30 PM	Mark	2	1	6	7	7	7	14

Tig Notaro | Saturday, February 11, 2023 | 7:30 PM
Event	Name	N.Tickets	Granted	Ranking	Priority	plusone.Priority	n.Members	n.Total
Tig Notaro \| Saturday, February 11, 2023 \| 7:30 PM	Lily Bhattacharjee	2	2	1	1	1	10	19
Tig Notaro \| Saturday, February 11, 2023 \| 7:30 PM	Susette Min	2	2	1	2	2	10	19
Tig Notaro \| Saturday, February 11, 2023 \| 7:30 PM	Tom Patten	2	1	1	3	3	10	19
Tig Notaro \| Saturday, February 11, 2023 \| 7:30 PM	Lauren Camp	2	1	1	4	4	10	19
Tig Notaro \| Saturday, February 11, 2023 \| 7:30 PM	Heather Martin	2	1	1	5	5	10	19
Tig Notaro \| Saturday, February 11, 2023 \| 7:30 PM	Jennie Moylan	2	1	2	6	6	10	19
Tig Notaro \| Saturday, February 11, 2023 \| 7:30 PM	Ian Earley	2	1	3	7	7	10	19
Tig Notaro \| Saturday, February 11, 2023 \| 7:30 PM	Aidan Carr	1	1	4	8	10	10	19
Tig Notaro \| Saturday, February 11, 2023 \| 7:30 PM	Satinder Bhatti	2	1	6	9	8	10	19
Tig Notaro \| Saturday, February 11, 2023 \| 7:30 PM	Hemant Bhargava	2	1	6	10	9	10	19

Yamato - Hintori: The Wings of Phoenix | Sunday, February 26, 2023 | 1:59 PM
Event	Name	N.Tickets	Granted	Ranking	Priority	plusone.Priority	n.Members	n.Total
Yamato - Hintori: The Wings of Phoenix \| Sunday, February 26, 2023 \| 1:59 PM	Lee Miller	2	2	1	1	1	8	15
Yamato - Hintori: The Wings of Phoenix \| Sunday, February 26, 2023 \| 1:59 PM	Jessica Lee	2	2	1	2	2	8	15
Yamato - Hintori: The Wings of Phoenix \| Sunday, February 26, 2023 \| 1:59 PM	Jide Akinmoladun	2	2	2	3	3	8	15
Yamato - Hintori: The Wings of Phoenix \| Sunday, February 26, 2023 \| 1:59 PM	Morgan Wong	2	2	3	4	4	8	15
Yamato - Hintori: The Wings of Phoenix \| Sunday, February 26, 2023 \| 1:59 PM	Aidan Carr	1	1	5	5	8	8	15
Yamato - Hintori: The Wings of Phoenix \| Sunday, February 26, 2023 \| 1:59 PM	Tom Patten	2	1	5	6	5	8	15
Yamato - Hintori: The Wings of Phoenix \| Sunday, February 26, 2023 \| 1:59 PM	Satinder Bhatti	2	1	8	7	6	8	15
Yamato - Hintori: The Wings of Phoenix \| Sunday, February 26, 2023 \| 1:59 PM	Lauren Camp	2	1	8	8	7	8	15

Zach Norris (Campus Community Book Project) | Thursday, February 16, 2023 | 7:30 PM
Event	Name	N.Tickets	Granted	Ranking	Priority	plusone.Priority	n.Members	n.Total
Zach Norris (Campus Community Book Project) \| Thursday, February 16, 2023 \| 7:30 PM	Susette Min	1	1	3	1	4	5	8
Zach Norris (Campus Community Book Project) \| Thursday, February 16, 2023 \| 7:30 PM	Mark	2	2	5	2	1	5	8
Zach Norris (Campus Community Book Project) \| Thursday, February 16, 2023 \| 7:30 PM	Satinder Bhatti	2	2	7	3	2	5	8
Zach Norris (Campus Community Book Project) \| Thursday, February 16, 2023 \| 7:30 PM	Jennie Moylan	2	2	8	4	3	5	8
Zach Norris (Campus Community Book Project) \| Thursday, February 16, 2023 \| 7:30 PM	Tom Patten	1	1	8	5	5	5	8

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

Allocation Report by Member