Read This (instructions for MCAAC Chair and Staff)

Program Purpose

This document is prepared to facilitate ticket allocation and distribution for MCAAC members. We start with 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.

Action Items for You

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.
Later Cancellations and Additional Requests: Here’s how you can simplify the decisions. 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.

Back-end Code

Details hidden, but ask Hemant if you want to know more

Events, Available Tickets, and Survey Data

We first read the member survey data from the .csv file produced by the Qualtrics survey.

are there any NA rows?

Add Venue info because missing from Spring 2025 data

Next, make a distinction between Events and Shows. The idea is that some “events” (usually those at VST) are repeated for multiple “shows”. In our member survey, however, members can cast their preferences and ranks for multiple shows of the same event. But when we allocate, there isn’t much point in giving someone multiple shows for the same event.

There is some technical stuff to ensure that date columns are in the right format.

Event-demand and Priority

Now we need to assign Priorities to member-show matches based on the Rankings given by the members.

For each Show, we order all the “asks” for that show by Rank. Then Priority numbers are assigned according to this ordering. So, first row (highest rank) gets 1, next row gets Priority 2, and so on.

Further, also define a “plusone.Priority” column to indicate who gets priority for allocating 2 tickets (when n.Total > Allocation but n.Members < Allocation)

Allocations

Ready to make the allocations now. We will first solve the problem with general rules. Then, in case the allocations create some examples where the same member A was assigned to an event E multiple times (i.e., to multiple shows of the event) then we identify and resolve those in a second step.

General Allocations

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

If n.total < Allocation then Grant as many tickets (1 or 2) as requested (“Tickets.Requested”);

Otherwise, 2) if n.members >= Allocation, then Grant 1 ticket to members with highest priority;

Otherwise, 3) if n.members < Allocation, then Grant 1 seat to each member who requests, and grant a +1 to the ones with highest plusone.Priority

Resolving Multi-Show Events

For events that have multiple shows (usually the ones that are at VST) it is possible that the allocation assigns some member tickets to multiple shows of the same event. This might be wasteful under the following scenario: member A gets tickets to shows S1 and S2 (of the same event) while member B gets 0 tickets (across ALL shows of that event).

Let’s run the standard allocation (the allocate function), then for multi-show events that have a Member.Denied = 1 AND if it is true that some member received tickets for 2 shows of that event

… these are the ones we want to re-allocate.

To resolve this: 1) identify such scenarios, and 2) swap the allocation.

Reporting

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.

Mrs. Krishnan’s Party
Show	Event	Date	Time	Venue	Name	N.Tickets	Priority	Granted	Member.Denied	Deficit	Rank	plusone.Priority	n.Members	n.Total
Mrs. Krishnan’s Party (04/02/2025; 7:30pm )	Mrs. Krishnan’s Party	04/02/2025	7:30pm	Vanderhoef Studio Theatre	Daniel Herman	2	1	2	0	0	5	1	1	2

Mrs. Krishnan’s Party
Show	Event	Date	Time	Venue	Name	N.Tickets	Priority	Granted	Member.Denied	Deficit	Rank	plusone.Priority	n.Members	n.Total
Mrs. Krishnan’s Party (04/03/2025; 7:30pm)	Mrs. Krishnan’s Party	04/03/2025	7:30pm	Vanderhoef Studio Theatre	Lori Leong	2	1	2	0	0	3	1	1	2

Mrs. Krishnan’s Party
Show	Event	Date	Time	Venue	Name	N.Tickets	Priority	Granted	Member.Denied	Deficit	Rank	plusone.Priority	n.Members	n.Total
Mrs. Krishnan’s Party (04/03/2025; 7:30pm )	Mrs. Krishnan’s Party	04/03/2025	7:30pm	Vanderhoef Studio Theatre	John D Tupin	1	1	1	0	0	2	1	1	1

Joshua Bell, violin Peter Dugan, piano
Show	Event	Date	Time	Venue	Name	N.Tickets	Priority	Granted	Deficit	Rank	plusone.Priority	n.Members	n.Total
Joshua Bell, violin Peter Dugan, piano (04/04/2025; 7:30pm )	Joshua Bell, violin Peter Dugan, piano	04/04/2025	7:30pm	Jackson Hall	Daniel Herman	2	1	2	0	1	1	10	19
Joshua Bell, violin Peter Dugan, piano (04/04/2025; 7:30pm )	Joshua Bell, violin Peter Dugan, piano	04/04/2025	7:30pm	Jackson Hall	Lee Miller	2	2	2	0	1	2	10	19
Joshua Bell, violin Peter Dugan, piano (04/04/2025; 7:30pm )	Joshua Bell, violin Peter Dugan, piano	04/04/2025	7:30pm	Jackson Hall	Jide Akinmoladun	2	3	1	1	1	3	10	19
Joshua Bell, violin Peter Dugan, piano (04/04/2025; 7:30pm )	Joshua Bell, violin Peter Dugan, piano	04/04/2025	7:30pm	Jackson Hall	Emma Nguyen	2	4	1	1	1	4	10	19
Joshua Bell, violin Peter Dugan, piano (04/04/2025; 7:30pm )	Joshua Bell, violin Peter Dugan, piano	04/04/2025	7:30pm	Jackson Hall	Pauline Moreira	2	5	1	1	2	5	10	19
Joshua Bell, violin Peter Dugan, piano (04/04/2025; 7:30pm )	Joshua Bell, violin Peter Dugan, piano	04/04/2025	7:30pm	Jackson Hall	Brandon Fong	2	6	1	1	2	6	10	19
Joshua Bell, violin Peter Dugan, piano (04/04/2025; 7:30pm )	Joshua Bell, violin Peter Dugan, piano	04/04/2025	7:30pm	Jackson Hall	Aydin Linzey	2	7	1	1	2	7	10	19
Joshua Bell, violin Peter Dugan, piano (04/04/2025; 7:30pm )	Joshua Bell, violin Peter Dugan, piano	04/04/2025	7:30pm	Jackson Hall	Max Gibson	2	8	1	1	3	8	10	19
Joshua Bell, violin Peter Dugan, piano (04/04/2025; 7:30pm )	Joshua Bell, violin Peter Dugan, piano	04/04/2025	7:30pm	Jackson Hall	Jonah Messinger	1	9	1	0	3	10	10	19
Joshua Bell, violin Peter Dugan, piano (04/04/2025; 7:30pm )	Joshua Bell, violin Peter Dugan, piano	04/04/2025	7:30pm	Jackson Hall	Daniel Herman	2	10	1	1	4	9	10	19

Mrs. Krishnan’s Party
Show	Event	Date	Time	Venue	Name	N.Tickets	Priority	Granted	Deficit	Rank	plusone.Priority	n.Members	n.Total
Mrs. Krishnan’s Party (04/04/2025; 7:30pm )	Mrs. Krishnan’s Party	04/04/2025	7:30pm	Vanderhoef Studio Theatre	Hemant Bhargava	2	1	1	1	1	1	4	8
Mrs. Krishnan’s Party (04/04/2025; 7:30pm )	Mrs. Krishnan’s Party	04/04/2025	7:30pm	Vanderhoef Studio Theatre	Aidan Carr	2	2	1	1	2	2	4	8
Mrs. Krishnan’s Party (04/04/2025; 7:30pm )	Mrs. Krishnan’s Party	04/04/2025	7:30pm	Vanderhoef Studio Theatre	Kelsey Hadfield	2	3	1	1	2	3	4	8
Mrs. Krishnan’s Party (04/04/2025; 7:30pm )	Mrs. Krishnan’s Party	04/04/2025	7:30pm	Vanderhoef Studio Theatre	Jocelyn Anderson	2	4	1	1	3	4	4	8

Mrs. Krishnan’s Party
Show	Event	Date	Time	Venue	Name	N.Tickets	Priority	Granted	Member.Denied	Deficit	Rank	plusone.Priority	n.Members	n.Total
Mrs. Krishnan’s Party (04/05/2025; 2:00pm )	Mrs. Krishnan’s Party	04/05/2025	2:00pm	Vanderhoef Studio Theatre	Jo Anne Boorkman	1	1	1	0	0	2	2	2	3
Mrs. Krishnan’s Party (04/05/2025; 2:00pm )	Mrs. Krishnan’s Party	04/05/2025	2:00pm	Vanderhoef Studio Theatre	Emma Nguyen	2	2	2	0	0	2	1	2	3

Mrs. Krishnan’s Party
Show	Event	Date	Time	Venue	Name	N.Tickets	Priority	Granted	Member.Denied	Deficit	Rank	plusone.Priority	n.Members	n.Total
Mrs. Krishnan’s Party (04/05/2025; 7:30pm )	Mrs. Krishnan’s Party	04/05/2025	7:30pm	Vanderhoef Studio Theatre	Hemant Bhargava	2	1	2	0	0	5	1	1	2

Circa
Show	Event	Date	Time	Venue	Name	N.Tickets	Priority	Granted	Deficit	Rank	plusone.Priority	n.Members	n.Total
Circa (04/06/2025; 2:00pm)	Circa	04/06/2025	2:00pm	Jackson Hall	Wilson Xieu	2	1	2	0	1	1	7	14
Circa (04/06/2025; 2:00pm)	Circa	04/06/2025	2:00pm	Jackson Hall	Kelsey Hadfield	2	2	2	0	1	2	7	14
Circa (04/06/2025; 2:00pm)	Circa	04/06/2025	2:00pm	Jackson Hall	Lori Leong	2	3	2	0	2	3	7	14
Circa (04/06/2025; 2:00pm)	Circa	04/06/2025	2:00pm	Jackson Hall	Jocelyn Anderson	2	4	2	0	2	4	7	14
Circa (04/06/2025; 2:00pm)	Circa	04/06/2025	2:00pm	Jackson Hall	Pauline Moreira	2	5	2	0	3	5	7	14
Circa (04/06/2025; 2:00pm)	Circa	04/06/2025	2:00pm	Jackson Hall	Hemant Bhargava	2	6	1	1	4	6	7	14
Circa (04/06/2025; 2:00pm)	Circa	04/06/2025	2:00pm	Jackson Hall	Aydin Linzey	2	7	1	1	5	7	7	14

Mrs. Krishnan’s Party
Show	Event	Date	Time	Venue	Name	N.Tickets	Priority	Granted	Rank	plusone.Priority	n.Members	n.Total
Mrs. Krishnan’s Party (04/06/2025; 2:00pm )	Mrs. Krishnan’s Party	04/06/2025	2:00pm	Vanderhoef Studio Theatre	Christina Fiedler	1	1	1	2	2	3	4
Mrs. Krishnan’s Party (04/06/2025; 2:00pm )	Mrs. Krishnan’s Party	04/06/2025	2:00pm	Vanderhoef Studio Theatre	Kyla Hibbard	1	2	1	2	3	3	4
Mrs. Krishnan’s Party (04/06/2025; 2:00pm )	Mrs. Krishnan’s Party	04/06/2025	2:00pm	Vanderhoef Studio Theatre	Stephanie Syphers	2	3	2	3	1	3	4

DakhaBrakha
Show	Event	Date	Time	Venue	Name	N.Tickets	Priority	Granted	Rank	plusone.Priority	n.Members	n.Total
DakhaBrakha (04/09/2025; 7:30pm )	DakhaBrakha	04/09/2025	7:30pm	Jackson Hall	Max Gibson	2	1	2	1	1	5	10
DakhaBrakha (04/09/2025; 7:30pm )	DakhaBrakha	04/09/2025	7:30pm	Jackson Hall	Hemant Bhargava	2	2	2	2	2	5	10
DakhaBrakha (04/09/2025; 7:30pm )	DakhaBrakha	04/09/2025	7:30pm	Jackson Hall	Kyla Hibbard	2	3	2	4	3	5	10
DakhaBrakha (04/09/2025; 7:30pm )	DakhaBrakha	04/09/2025	7:30pm	Jackson Hall	Brandon Fong	2	4	2	5	4	5	10
DakhaBrakha (04/09/2025; 7:30pm )	DakhaBrakha	04/09/2025	7:30pm	Jackson Hall	Daniel Herman	2	5	2	6	5	5	10

Terence Blanchard: FLOW
Show	Event	Date	Time	Venue	Name	N.Tickets	Priority	Granted	Rank	plusone.Priority	n.Members	n.Total
Terence Blanchard: FLOW (04/11/2025; 7:30pm )	Terence Blanchard: FLOW	04/11/2025	7:30pm	Jackson Hall	Max Gibson	2	1	2	2	1	5	10
Terence Blanchard: FLOW (04/11/2025; 7:30pm )	Terence Blanchard: FLOW	04/11/2025	7:30pm	Jackson Hall	Daniel Herman	2	2	2	2	2	5	10
Terence Blanchard: FLOW (04/11/2025; 7:30pm )	Terence Blanchard: FLOW	04/11/2025	7:30pm	Jackson Hall	Stephanie Syphers	2	3	2	2	3	5	10
Terence Blanchard: FLOW (04/11/2025; 7:30pm )	Terence Blanchard: FLOW	04/11/2025	7:30pm	Jackson Hall	Brandon Fong	2	4	2	3	4	5	10
Terence Blanchard: FLOW (04/11/2025; 7:30pm )	Terence Blanchard: FLOW	04/11/2025	7:30pm	Jackson Hall	Jonah Messinger	2	5	2	5	5	5	10

Omar Offendum
Show	Event	Date	Time	Venue	Name	N.Tickets	Priority	Granted	Deficit	Rank	plusone.Priority	n.Members	n.Total
Omar Offendum (04/24/2025; 7:30pm )	Omar Offendum	04/24/2025	7:30pm	Vanderhoef Studio Theatre	John D Tupin	1	1	1	0	1	3	3	5
Omar Offendum (04/24/2025; 7:30pm )	Omar Offendum	04/24/2025	7:30pm	Vanderhoef Studio Theatre	Hemant Bhargava	2	2	2	0	3	1	3	5
Omar Offendum (04/24/2025; 7:30pm )	Omar Offendum	04/24/2025	7:30pm	Vanderhoef Studio Theatre	Max Gibson	2	3	1	1	4	2	3	5

Omar Offendum
Show	Event	Date	Time	Venue	Name	N.Tickets	Priority	Granted	Deficit	Rank	plusone.Priority	n.Members	n.Total
Omar Offendum (04/25/2025; 7:30pm )	Omar Offendum	04/25/2025	7:30pm	Vanderhoef Studio Theatre	Kyla Hibbard	2	1	2	0	3	1	3	6
Omar Offendum (04/25/2025; 7:30pm )	Omar Offendum	04/25/2025	7:30pm	Vanderhoef Studio Theatre	Jonah Messinger	2	2	1	1	4	2	3	6
Omar Offendum (04/25/2025; 7:30pm )	Omar Offendum	04/25/2025	7:30pm	Vanderhoef Studio Theatre	Brandon Fong	2	3	1	1	4	3	3	6

Michelle Cann, piano Erinys Quartet
Show	Event	Date	Time	Venue	Name	N.Tickets	Priority	Granted	Member.Denied	Deficit	Rank	plusone.Priority	n.Members	n.Total
Michelle Cann, piano Erinys Quartet (05/03/2025; 2:00 PM)	Michelle Cann, piano Erinys Quartet	05/03/2025	2:00 PM	Vanderhoef Studio Theatre	Caroline Bamforth	2	1	2	0	0	1	1	1	2

E.T. The Extra-Terrestrial In Concert with UC Davis Symphony
Show	Event	Date	Time	Venue	Name	N.Tickets	Priority	Granted	Deficit	Rank	plusone.Priority	n.Members	n.Total
E.T. The Extra-Terrestrial In Concert with UC Davis Symphony (05/03/2025; 7:30pm )	E.T. The Extra-Terrestrial In Concert with UC Davis Symphony	05/03/2025	7:30pm	Jackson Hall	Pauline Moreira	2	1	1	1	1	1	12	22
E.T. The Extra-Terrestrial In Concert with UC Davis Symphony (05/03/2025; 7:30pm )	E.T. The Extra-Terrestrial In Concert with UC Davis Symphony	05/03/2025	7:30pm	Jackson Hall	Jo Anne Boorkman	2	2	1	1	1	2	12	22
E.T. The Extra-Terrestrial In Concert with UC Davis Symphony (05/03/2025; 7:30pm )	E.T. The Extra-Terrestrial In Concert with UC Davis Symphony	05/03/2025	7:30pm	Jackson Hall	Christina Fiedler	2	3	1	1	1	3	12	22
E.T. The Extra-Terrestrial In Concert with UC Davis Symphony (05/03/2025; 7:30pm )	E.T. The Extra-Terrestrial In Concert with UC Davis Symphony	05/03/2025	7:30pm	Jackson Hall	Jocelyn Anderson	2	4	1	1	1	4	12	22
E.T. The Extra-Terrestrial In Concert with UC Davis Symphony (05/03/2025; 7:30pm )	E.T. The Extra-Terrestrial In Concert with UC Davis Symphony	05/03/2025	7:30pm	Jackson Hall	MJ Pothier	1	5	1	0	2	11	12	22
E.T. The Extra-Terrestrial In Concert with UC Davis Symphony (05/03/2025; 7:30pm )	E.T. The Extra-Terrestrial In Concert with UC Davis Symphony	05/03/2025	7:30pm	Jackson Hall	Pablo Ortiz	1	6	1	0	2	12	12	22
E.T. The Extra-Terrestrial In Concert with UC Davis Symphony (05/03/2025; 7:30pm )	E.T. The Extra-Terrestrial In Concert with UC Davis Symphony	05/03/2025	7:30pm	Jackson Hall	Jide Akinmoladun	2	7	1	1	2	5	12	22
E.T. The Extra-Terrestrial In Concert with UC Davis Symphony (05/03/2025; 7:30pm )	E.T. The Extra-Terrestrial In Concert with UC Davis Symphony	05/03/2025	7:30pm	Jackson Hall	Caroline Bamforth	2	8	1	1	3	6	12	22
E.T. The Extra-Terrestrial In Concert with UC Davis Symphony (05/03/2025; 7:30pm )	E.T. The Extra-Terrestrial In Concert with UC Davis Symphony	05/03/2025	7:30pm	Jackson Hall	Aydin Linzey	2	9	1	1	3	7	12	22
E.T. The Extra-Terrestrial In Concert with UC Davis Symphony (05/03/2025; 7:30pm )	E.T. The Extra-Terrestrial In Concert with UC Davis Symphony	05/03/2025	7:30pm	Jackson Hall	John D Tupin	2	10	1	1	3	8	12	22
E.T. The Extra-Terrestrial In Concert with UC Davis Symphony (05/03/2025; 7:30pm )	E.T. The Extra-Terrestrial In Concert with UC Davis Symphony	05/03/2025	7:30pm	Jackson Hall	Stephanie Syphers	2	11	1	1	4	9	12	22
E.T. The Extra-Terrestrial In Concert with UC Davis Symphony (05/03/2025; 7:30pm )	E.T. The Extra-Terrestrial In Concert with UC Davis Symphony	05/03/2025	7:30pm	Jackson Hall	Hemant Bhargava	2	12	1	1	6	10	12	22

Michelle Cann, piano Erinys Quartet
Show	Event	Date	Time	Venue	Name	N.Tickets	Priority	Granted	Deficit	Rank	plusone.Priority	n.Members	n.Total
Michelle Cann, piano Erinys Quartet (05/04/2025; 2:00pm )	Michelle Cann, piano Erinys Quartet	05/04/2025	2:00pm	Vanderhoef Studio Theatre	Susette Min	2	1	2	0	2	1	3	6
Michelle Cann, piano Erinys Quartet (05/04/2025; 2:00pm )	Michelle Cann, piano Erinys Quartet	05/04/2025	2:00pm	Vanderhoef Studio Theatre	Lee Miller	2	2	1	1	2	2	3	6
Michelle Cann, piano Erinys Quartet (05/04/2025; 2:00pm )	Michelle Cann, piano Erinys Quartet	05/04/2025	2:00pm	Vanderhoef Studio Theatre	Daniel Herman	2	3	1	1	3	3	3	6

Michelle Cann, piano Erinys Quartet
Show	Event	Date	Time	Venue	Name	N.Tickets	Priority	Granted	Member.Denied	Deficit	Rank	plusone.Priority	n.Members	n.Total
Michelle Cann, piano Erinys Quartet (05/04/2025; 7:30pm )	Michelle Cann, piano Erinys Quartet	05/04/2025	7:30pm	Vanderhoef Studio Theatre	Jonah Messinger	2	1	2	0	0	1	1	2	3
Michelle Cann, piano Erinys Quartet (05/04/2025; 7:30pm )	Michelle Cann, piano Erinys Quartet	05/04/2025	7:30pm	Vanderhoef Studio Theatre	Aydin Linzey	1	2	1	0	0	6	2	2	3

Julia Keefe Indigenous Big Band
Show	Event	Date	Time	Venue	Name	N.Tickets	Priority	Granted	Deficit	Rank	plusone.Priority	n.Members	n.Total
Julia Keefe Indigenous Big Band (05/08/2025; 7:30pm )	Julia Keefe Indigenous Big Band	05/08/2025	7:30pm	Jackson Hall	Aidan Carr	2	1	2	0	1	1	7	13
Julia Keefe Indigenous Big Band (05/08/2025; 7:30pm )	Julia Keefe Indigenous Big Band	05/08/2025	7:30pm	Jackson Hall	Lori Leong	2	2	2	0	1	2	7	13
Julia Keefe Indigenous Big Band (05/08/2025; 7:30pm )	Julia Keefe Indigenous Big Band	05/08/2025	7:30pm	Jackson Hall	Kyla Hibbard	2	3	2	0	1	3	7	13
Julia Keefe Indigenous Big Band (05/08/2025; 7:30pm )	Julia Keefe Indigenous Big Band	05/08/2025	7:30pm	Jackson Hall	Jo Anne Boorkman	1	4	1	0	3	7	7	13
Julia Keefe Indigenous Big Band (05/08/2025; 7:30pm )	Julia Keefe Indigenous Big Band	05/08/2025	7:30pm	Jackson Hall	Aydin Linzey	2	5	2	0	4	4	7	13
Julia Keefe Indigenous Big Band (05/08/2025; 7:30pm )	Julia Keefe Indigenous Big Band	05/08/2025	7:30pm	Jackson Hall	Stephanie Syphers	2	6	2	0	5	5	7	13
Julia Keefe Indigenous Big Band (05/08/2025; 7:30pm )	Julia Keefe Indigenous Big Band	05/08/2025	7:30pm	Jackson Hall	Hemant Bhargava	2	7	1	1	7	6	7	13

San Francisco Symphony Orchestra
Show	Event	Date	Time	Venue	Name	N.Tickets	Priority	Granted	Rank	plusone.Priority	n.Members	n.Total
San Francisco Symphony Orchestra (05/31/2025; 7:30 PM)	San Francisco Symphony Orchestra	05/31/2025	7:30 PM	Jackson Hall	Pablo Ortiz	1	1	1	1	4	4	7
San Francisco Symphony Orchestra (05/31/2025; 7:30 PM)	San Francisco Symphony Orchestra	05/31/2025	7:30 PM	Jackson Hall	Mahek Bhora	2	2	2	1	1	4	7
San Francisco Symphony Orchestra (05/31/2025; 7:30 PM)	San Francisco Symphony Orchestra	05/31/2025	7:30 PM	Jackson Hall	Caroline Bamforth	2	3	2	2	2	4	7
San Francisco Symphony Orchestra (05/31/2025; 7:30 PM)	San Francisco Symphony Orchestra	05/31/2025	7:30 PM	Jackson Hall	Christina Fiedler	2	4	2	3	3	4	7

San Francisco Symphony Orchestra
Show	Event	Date	Time	Venue	Name	N.Tickets	Priority	Granted	Member.Denied	Deficit	Rank	plusone.Priority	n.Members	n.Total
San Francisco Symphony Orchestra (05/31/2025; 7:30pm )	San Francisco Symphony Orchestra	05/31/2025	7:30pm	Jackson Hall	MJ Pothier	1	1	1	0	0	1	14	14	27
San Francisco Symphony Orchestra (05/31/2025; 7:30pm )	San Francisco Symphony Orchestra	05/31/2025	7:30pm	Jackson Hall	Cecilia Giulivi	2	2	1	0	1	1	1	14	27
San Francisco Symphony Orchestra (05/31/2025; 7:30pm )	San Francisco Symphony Orchestra	05/31/2025	7:30pm	Jackson Hall	Susette Min	2	3	1	0	1	1	2	14	27
San Francisco Symphony Orchestra (05/31/2025; 7:30pm )	San Francisco Symphony Orchestra	05/31/2025	7:30pm	Jackson Hall	Naoki Saito	2	4	1	0	1	1	3	14	27
San Francisco Symphony Orchestra (05/31/2025; 7:30pm )	San Francisco Symphony Orchestra	05/31/2025	7:30pm	Jackson Hall	Brandon Fong	2	5	1	0	1	1	4	14	27
San Francisco Symphony Orchestra (05/31/2025; 7:30pm )	San Francisco Symphony Orchestra	05/31/2025	7:30pm	Jackson Hall	Stephanie Syphers	2	6	1	0	1	1	5	14	27
San Francisco Symphony Orchestra (05/31/2025; 7:30pm )	San Francisco Symphony Orchestra	05/31/2025	7:30pm	Jackson Hall	Aydin Linzey	2	7	1	0	1	1	6	14	27
San Francisco Symphony Orchestra (05/31/2025; 7:30pm )	San Francisco Symphony Orchestra	05/31/2025	7:30pm	Jackson Hall	Shruti Kakar	2	8	1	0	1	1	7	14	27
San Francisco Symphony Orchestra (05/31/2025; 7:30pm )	San Francisco Symphony Orchestra	05/31/2025	7:30pm	Jackson Hall	Jonah Messinger	2	9	1	0	1	2	8	14	27
San Francisco Symphony Orchestra (05/31/2025; 7:30pm )	San Francisco Symphony Orchestra	05/31/2025	7:30pm	Jackson Hall	Aidan Carr	2	10	1	0	1	3	9	14	27
San Francisco Symphony Orchestra (05/31/2025; 7:30pm )	San Francisco Symphony Orchestra	05/31/2025	7:30pm	Jackson Hall	Lee Miller	2	11	1	0	1	3	10	14	27
San Francisco Symphony Orchestra (05/31/2025; 7:30pm )	San Francisco Symphony Orchestra	05/31/2025	7:30pm	Jackson Hall	Kelsey Hadfield	2	12	1	0	1	3	11	14	27
San Francisco Symphony Orchestra (05/31/2025; 7:30pm )	San Francisco Symphony Orchestra	05/31/2025	7:30pm	Jackson Hall	Max Gibson	2	13	0	1	2	5	12	14	27
San Francisco Symphony Orchestra (05/31/2025; 7:30pm )	San Francisco Symphony Orchestra	05/31/2025	7:30pm	Jackson Hall	Kyla Hibbard	2	14	0	1	2	5	13	14	27

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

Allocation Report by Member