R Notebook

knitr::opts_chunk$set(
  comment = "#>", echo = FALSE, fig.width = 6, warning = FALSE, include=FALSE
)

Reading and Preparing the Data

First read the data from the Excel file. In the notation, we will index Events by i, and Members (or more precisely, Email) by j. The preferences data set has rankings and number of tickets asked, both of which are indexed over both i and j.

Let’s start by defining 3 metrics for each event:

S_i = # seats made available for event i M_i = # members asking for seats Req_ij = number of event i seats requested by member j

Now with this, partition the event list into 3 sets E : easy case, Req_i < S_i G : good case, M_i < S_i H : hard case, M_i > S_i

Assignments

The Easy Ones

For all events in E, assign everyone as many seats as they asked for. For each assignment, increment member score Score_j by (1/r_ij)*Req_ij, where r_ij is rank and Req_ij is number of seats asked.

These assignments are ready to go. Focus on the Email, Event, and Allot columns.

Test

Email	Event	Allot	Req_ij
mcguzel@ucdavis.edu	Kinetech Arts | 3/09/2022 | 8:30 PM	2	2
boving@ucdavis.edu	Kinetech Arts | 3/10/2022 | 7:30 PM	2	2
lcamp@ucdavis.edu	Kinetech Arts | 3/10/2022 | 7:30 PM	1	1
hemantb@ucdavis.edu	Kinetech Arts | 3/10/2022 | 7:30 PM	2	2
sgini@ucdavis.edu	Kinetech Arts | 3/10/2022 | 7:30 PM	1	1
ejowhite@ucdavis.edu	Kinetech Arts | 3/10/2022 | 8:30 PM	2	2
twpatten@ucdavis.edu	Dresher Davel Invented Instrument Duo | 3/12/2022 | 7:30 PM	1	1
ejowhite@ucdavis.edu	Dresher Davel Invented Instrument Duo | 3/12/2022 | 7:30 PM	2	2
ekaplan@ucdavis.edu	Academy of St Martin in the Fields with Joshua Bell | 3/12/2022 | 7:30 PM	2	2
mcguzel@ucdavis.edu	Academy of St Martin in the Fields with Joshua Bell | 3/12/2022 | 7:30 PM	2	2
tdiacova@ucdavis.edu	Academy of St Martin in the Fields with Joshua Bell | 3/12/2022 | 7:30 PM	2	2
ekaplan@ucdavis.edu	Matthew Whitaker Quartet | 3/25/2022 | 7:30 PM	2	2
molmccarthy@ucdavis.edu	Matthew Whitaker Quartet | 3/25/2022 | 7:30 PM	1	1
Mbrunet@ucdavis.edu	Matthew Whitaker Quartet | 3/25/2022 | 7:30 PM	2	2
tdiacova@ucdavis.edu	Matthew Whitaker Quartet | 3/25/2022 | 7:30 PM	2	2
ejowhite@ucdavis.edu	Matthew Whitaker Quartet | 3/25/2022 | 7:30 PM	2	2
lcamp@ucdavis.edu	Matthew Whitaker Quartet | 3/25/2022 | 7:30 PM	1	1
sgini@ucdavis.edu	Matthew Whitaker Quartet | 3/25/2022 | 7:30 PM	1	1
ejowhite@ucdavis.edu	Dr. Ibram X. Kendi | 3/31/2022 | 7:30 PM	2	2
tdiacova@ucdavis.edu	Dr. Ibram X. Kendi | 3/31/2022 | 7:30 PM	2	2
hemantb@ucdavis.edu	Dr. Ibram X. Kendi | 3/31/2022 | 7:30 PM	2	2
sgini@ucdavis.edu	Dr. Ibram X. Kendi | 3/31/2022 | 7:30 PM	1	1
Mbrunet@ucdavis.edu	Dr. Ibram X. Kendi | 3/31/2022 | 7:30 PM	2	2
twpatten@ucdavis.edu	Dr. Ibram X. Kendi | 3/31/2022 | 7:30 PM	1	1
jkmlee@ucdavis.edu	Ashwini Bhatt & Forrest Gander | 4/15/2022 | 7:30 PM	2	2
hemantb@ucdavis.edu	Ashwini Bhatt & Forrest Gander | 4/15/2022 | 7:30 PM	2	2
twpatten@ucdavis.edu	Ashwini Bhatt & Forrest Gander | 4/15/2022 | 7:30 PM	1	1
lcamp@ucdavis.edu	Ashwini Bhatt & Forrest Gander | 4/15/2022 | 7:30 PM	1	1
mcguzel@ucdavis.edu	Christopher Taylor, Piano | 4/22/2022 | 7:30 PM	2	2
aiberlot@ucdavis.edu	Christopher Taylor, Piano | 4/24/2022 | 2:00 PM	1	1
emalliende@ucdavis.edu	Christopher Taylor, Piano | 4/24/2022 | 2:00 PM	2	2
tdiacova@ucdavis.edu	Christopher Taylor, Piano | 4/24/2022 | 2:00 PM	2	2
lcamp@ucdavis.edu	Christopher Taylor, Piano | 4/24/2022 | 2:00 PM	1	1
jkmlee@ucdavis.edu	Ashwini Bhatt & Forrest Gander | 4/28/2022 | 7:30 PM	2	2
aiberlot@ucdavis.edu	Lara Downes | 5/06/2022 | 7:30 PM	1	1
tdiacova@ucdavis.edu	Lara Downes | 5/06/2022 | 7:30 PM	2	2
twpatten@ucdavis.edu	Lara Downes | 5/06/2022 | 7:30 PM	1	1
ladebartolo@ucdavis.edu	Alexander String Quartet 3 | 5/15/2022 | 2:00 PM	2	2
aiberlot@ucdavis.edu	Alexander String Quartet 3 | 5/15/2022 | 2:00 PM	1	1
ekaplan@ucdavis.edu	Alexander String Quartet 3 | 5/15/2022 | 2:00 PM	1	1
Mbrunet@ucdavis.edu	Alexander String Quartet 3 | 5/15/2022 | 2:00 PM	2	2
jkmlee@ucdavis.edu	Alexander String Quartet 3 | 5/15/2022 | 2:00 PM	2	2
molmccarthy@ucdavis.edu	Alexander String Quartet 3 | 5/15/2022 | 2:00 PM	1	1
lcamp@ucdavis.edu	Alexander String Quartet 3 | 5/15/2022 | 2:00 PM	1	1

The Good Ones: Enough Tickets for Members (but not Guests)

In the next set you can assign 1 ticket to each member who requested as seat, but some of them asked for two, and we’re not ready to assign the 2nd ticket yet. It could still occur, after we examine the remaining shows where there are stronger conflicts (requests exceed avaialble seats).

Test

Email	Event	Allot	Req_ij
heamartin@ucdavis.edu	Ballet Folklorico de Mexico | 3/18/2022 | 7:30 PM	1	2
molmccarthy@ucdavis.edu	Ballet Folklorico de Mexico | 3/18/2022 | 7:30 PM	1	1
tdiacova@ucdavis.edu	Ballet Folklorico de Mexico | 3/18/2022 | 7:30 PM	1	2
twpatten@ucdavis.edu	Ballet Folklorico de Mexico | 3/18/2022 | 7:30 PM	1	2
hemantb@ucdavis.edu	Ballet Folklorico de Mexico | 3/18/2022 | 7:30 PM	1	2
sgini@ucdavis.edu	Ballet Folklorico de Mexico | 3/18/2022 | 7:30 PM	1	2
ejowhite@ucdavis.edu	Ballet Folklorico de Mexico | 3/18/2022 | 7:30 PM	1	2
lasanmartin@ucdavis.edu	Heather McGhee | 4/03/2022 | 7:30 PM	1	2
ejowhite@ucdavis.edu	Heather McGhee | 4/03/2022 | 7:30 PM	1	2
ladebartolo@ucdavis.edu	Heather McGhee | 4/03/2022 | 7:30 PM	1	2
emalliende@ucdavis.edu	Heather McGhee | 4/03/2022 | 7:30 PM	1	2
twpatten@ucdavis.edu	Heather McGhee | 4/03/2022 | 7:30 PM	1	1
lcamp@ucdavis.edu	Heather McGhee | 4/03/2022 | 7:30 PM	1	2
sgini@ucdavis.edu	Heather McGhee | 4/03/2022 | 7:30 PM	1	1
tdiacova@ucdavis.edu	Heather McGhee | 4/03/2022 | 7:30 PM	1	2
hemantb@ucdavis.edu	Las Cafeteras | 4/28/2022 | 7:30 PM	1	2
sgini@ucdavis.edu	Las Cafeteras | 4/28/2022 | 7:30 PM	1	2
jkmlee@ucdavis.edu	Las Cafeteras | 4/28/2022 | 7:30 PM	1	2
Mbrunet@ucdavis.edu	Las Cafeteras | 4/28/2022 | 7:30 PM	1	2
mcguzel@ucdavis.edu	Las Cafeteras | 4/28/2022 | 7:30 PM	1	2
boving@ucdavis.edu	Las Cafeteras | 4/28/2022 | 7:30 PM	1	2
lcamp@ucdavis.edu	Las Cafeteras | 4/28/2022 | 7:30 PM	1	2
ekaplan@ucdavis.edu	Las Cafeteras | 4/28/2022 | 7:30 PM	1	1
molmccarthy@ucdavis.edu	Las Cafeteras | 4/28/2022 | 7:30 PM	1	1
ejowhite@ucdavis.edu	Las Cafeteras | 4/28/2022 | 7:30 PM	1	2
tdiacova@ucdavis.edu	Las Cafeteras | 4/28/2022 | 7:30 PM	1	2
lcamp@ucdavis.edu	David Sedaris | 5/01/2022 | 7:30 PM	1	1
twpatten@ucdavis.edu	David Sedaris | 5/01/2022 | 7:30 PM	1	2
lasanmartin@ucdavis.edu	David Sedaris | 5/01/2022 | 7:30 PM	1	2
heamartin@ucdavis.edu	David Sedaris | 5/01/2022 | 7:30 PM	1	2
molmccarthy@ucdavis.edu	David Sedaris | 5/01/2022 | 7:30 PM	1	1
emalliende@ucdavis.edu	David Sedaris | 5/01/2022 | 7:30 PM	1	2
hemantb@ucdavis.edu	David Sedaris | 5/01/2022 | 7:30 PM	1	2
sgini@ucdavis.edu	David Sedaris | 5/01/2022 | 7:30 PM	1	1
ejowhite@ucdavis.edu	David Sedaris | 5/01/2022 | 7:30 PM	1	2
tdiacova@ucdavis.edu	David Sedaris | 5/01/2022 | 7:30 PM	1	2

Visualization