Events and Performances

Gather a listing of the events and performances.

Event and Performance Columns: P_PLAY_YEAR,P_SHOW_CODE,PB_SHOW_CODE,P_PLAY_TITLE,PB_SERIES_CODE,PB_PERF_NOTES,PB_PERFORM_DATE,PB_PERFORM_TIME,gSalesMethod,gTax1Account,gAccount,gTaxRate,P_VE_SEQ,P_TM_SEQ,P_ACTIVE

To help create the Event Number for the Event Code, refer to the previous event code in the list:

• Column A = Season Year
• Column B = Event Title
• Column C = Event Number (calculated by the following)
• =IF(B2=B1,IF(A2=A1,C1,C1+1),C1+1)

• Column D = Performance Date
• Column E = Performance Time
• Column F = Show Code [YY-99](calculated by the following)
• =CONCATENATE(MID(A2,3,2),"-",IF(C2

To help create the Series Code, take the day of the week from the performance date.

• =weekday(Date)

Returns the day of the week corresponding to a date. The day is given as an integer, ranging from 1 (Sunday) to 7 (Saturday), by default.

• 1 = Sunday
• 2 = Monday
• 3 = Tuesday
• 4 = Wednesday
• 5 = Thursday
• 6 = Friday
• 7 = Saturday

or use the calcuation of:
=IF(WEEKDAY(G2)=1,"SUN",IF(WEEKDAY(G2)=2,"MON",IF(WEEKDAY(G2)=3,"TUE",IF(WEEKDAY(G2)=4,"WED",IF(WEEKDAY(G2)=5,"THU",IF(WEEKDAY(G2)=6,"FRI",IF(WEEKDAY(G2)=7,"SAT","error")))))))

gSalesMethod

• Troupe [0]
• Festival Seating [1]
• General Admission [1]
• Reserved Seating [2]
• Consignment [3]
• Inventory [4]
• Auction [5]
• Course [6]
• Class [6]

gTaxCode

• No Tax
• GST 5%
• HST 15%

For importing G/L Accounts, use the column titles of:

• gAccount = Earned Single Ticket Revenue
• gTax1Account = Deferred Ticket Revenue (optional)
• gTax2Account = Earned Season Revenue (optional)
• gTax3Account = Deferred Season Revenue (optional)
• If gTax1Account is not provided, gAccount will be used for Deferred Ticket Revenue
• If gTax2Account is not provided, gAccount will be used for Earned Season Revenue
• If gTax3Account is not provided, gTax2Account will be used for Deferred Season Revenue

Note: Best to remove any dashes from the account number before importing