{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Budget","Instructor Pay Breakdown"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Budget","index":0,"n_rows":115,"n_cols":7,"rows_kept":115,"cut":false,"hidden":false,"merged":[[118,5,119,5]]}
["McMaster Marching Band"]
["Projected Budget 2019–2020"]
["Carryover",null,null,29336.0,29336.0]
["Earnings","Notes","Rates + Breakdown","Planned","Actual"," "]
["Membership","53 new approx.","$40/person",2120.0]
["Summer Instrument Rental","3 Instruments","$100/person",300.0]
["Santa Claus Parades","Kitchener",null,2000.0]
[null,"Hamilton",null,1500.0]
[null,"Pickering",null,1500.0]
[null,"Smithville",null,1200.0]
[null,"Burlington",null,1900.0]
[null,"Brantford",null,1750.0]
[null,"Flamborough",null,1200.0]
["St. Patrick's Day Parades","Toronto",null,1500.0]
[null,"Buffalo",null,967.0]
["Events","Twitter Event",null,1985.0,1985.0]
[null,"Sportchek Photoshoot",null,850.0]
[null,"Niagara Grape and Wine Festival",null,1700.0]
[null,"Peterborough Event",null,3000.0]
["Donations","Alumni",null,0.0]
[null,"Faculty Fest",null,200.0]
["Sponsorship (Goal: 1500)",null,null,1500.0]
["Merchandise","Spirit Wear",null,500.0]
["MSU Referendum Funding",null,"$0.99/student",18500.0]
[null,"Min: ",0.95]
[null,"Max:",30000.0]
["Total Current Earnings",null,null,{"$f":"sum(D6:D25)","v":42052},1985]
["Total Earnings + Carryover",null,null,{"$f":"SUM(D3:D25)","v":73508},{"$f":"sum(E3:E25)","v":31321}]
[]
["Expenses ","Notes","Rates + Breakdown","Planned","Actual"]
["Membership",null,null,2120.0]
["Summer Instrument Rental",null,null,300.0,300.0]
["Santa Clause Parades","Kitchener",null,585.0]
[null,"Hamilton",null,415.0]
[null,"Pickering",null,750.0]
[null,"Smithville/Flamborough",null,600.0]
[null,"Brantford",null,550.0]
[null,"Burlington",null,300.0]
["St. Patrick's Day Parades ","Toronto",null,585.0]
[null,"Buffalo","Bus + Hotel",{"$f":"1582+928.33","v":2510.33}]
["Events","Twitter Event",null,0.0]
[null,"Niagara Grape and Wine",null,600.0,575.0]
[null,"Collaboration",null,0.0]
[null,"Peterborough",null,800.0]
["Space Rentals","United Church",null,900.0]
["Promotions","Posters ",null,50.0,25.76]
[null,"Stickers/Buttons",null,0.0]
[null,"Clubsfest",null,20.0,20.0]
[null,"Facebook Ads",null,50.0]
[null,"Faculty Fest",null,0.0]
[null,"Giveaways",null,350.0,120.6]
[null,"Website",null,172.29]
[null,"Equipment Transport",null,17.0,16.5]
[null,"Email Domain",null,25.24]
["Sponsorship","Poster Commision",null,0.0]
[null,"Banner Logos",null,25.0]
["Fundraising Expenses","Coffee House",null,0.0]
["Equipment","Lyres",null,30.0]
[null,"Folios",null,100.0]
[null,"Baritone Sax Harness",null,50.0]
[null,"Drum Stands",null,200.0]
[null,"Mallets/Drum Sticks",null,25.0]
[null,"Drum Heads",null,500.0]
[null,"Drum Tape ",null,5.0]
[null,"Instrument Purchases ","Baritone Saxophone",4500.0,4490.62]
[null,null,"2 Mellophones + 4 Baritone Horns",6000.0,5910.15]
[null,null,"Tax Orders",800.0,1025.23]
[null,"Tech Equipment",null,3000.0,1998.97]
[null,"Instrument Rentals",null,0.0]
[null,"Reeds, Mouthpieces, etc",null,160.0]
[null,"Spirit Wear",null,500.0]
[null,"Dinkles",null,700.0]
[null,"Colourguard Poles",null,300.0,276.49]
[null,"Colourguard Flags",null,350.0,340.0]
[null,"Uniforms","$185.9/person",4000.0,3830.31]
[null,"Banner Pole",null,40.0]
[null,"Printer Cord",null,35.0,31.63]
[null,"Printer/Paper",null,200.0,193.0]
[null,"Water Filter",null,200.0,164.97]
[null,"Water Cooler",null,103.0,101.67]
[null,"Garmet Bags",null,60.0,59.97]
[null,"Paper Cutter",null,30.0]
["Music","Scores",null,0.0]
[null,"Arrangements","$75/each",350.0,342.52]
["Mailing ","Envelopes",null,0.0]
[null,"Stamps ",null,10.0]
[null,"Shipping",null,200.0]
[null,"Express Mailing",null,30.0,14.29]
[null,"Cheques",null,400.0]
["Maintenance","Cleaning Supplies ",null,40.0]
[null,"Education Course",null,75.0,75.0]
[null,"Push Pins/Tape",null,5.0,4.24]
[null,"Instrument Repairs",null,500.0,455.05,"Printing Total this year","113.86 total"]
["Instructors (Fall Term)","Woodwinds Instructor",{"$f":"concatenate(\"$\",TEXT('Instructor Pay Breakdown'!B3,\"0.00\"),\"/hr\")","v":"$40.00/hr"},{"$f":"'Instructor Pay Breakdown'!I3","v":1320},420.0]
[null,"Brass Instructor",{"$f":"concatenate(\"$\",TEXT('Instructor Pay Breakdown'!B4,\"0.00\"),\"/hr\")","v":"$40.00/hr"},{"$f":"'Instructor Pay Breakdown'!I4","v":1320}]
[null,"Drumline Instructor",{"$f":"concatenate(\"$\",TEXT('Instructor Pay Breakdown'!B5,\"0.00\"),\"/hr\")","v":"$40.00/hr"},{"$f":"'Instructor Pay Breakdown'!I5","v":1320},420.0,"As of Sept 24"]
[null,"Colourguard Instructor",{"$f":"concatenate(\"$\",TEXT('Instructor Pay Breakdown'!B6,\"0.00\"),\"/hr\")","v":"$40.00/hr"},{"$f":"'Instructor Pay Breakdown'!I6","v":1320},240.0]
[null,"Beginning of Year Clinicians","$100/rhrsl",800.0,800.0]
["Instructors (Winter Term)","Woodwinds Instructor",{"$f":"concatenate(\"$\",TEXT('Instructor Pay Breakdown'!B8,\"0.00\"),\"/hr\")","v":"$40.00/hr"},{"$f":"'Instructor Pay Breakdown'!I8","v":1320}]
[null,"Brass Instructor",{"$f":"concatenate(\"$\",TEXT('Instructor Pay Breakdown'!B9,\"0.00\"),\"/hr\")","v":"$40.00/hr"},{"$f":"'Instructor Pay Breakdown'!I9","v":1320}]
[null,"Drumline Instructor",{"$f":"concatenate(\"$\",TEXT('Instructor Pay Breakdown'!B10,\"0.00\"),\"/hr\")","v":"$40.00/hr"},{"$f":"'Instructor Pay Breakdown'!I10","v":1320}]
[null,"Colourguard Instructor",{"$f":"concatenate(\"$\",TEXT('Instructor Pay Breakdown'!B11,\"0.00\"),\"/hr\")","v":"$40.00/hr"},{"$f":"'Instructor Pay Breakdown'!I11","v":1320}]
[null,"Clinicians",null,100.0]
[null,"Meeting Expenses",null,50.0,47.9]
["Socials","Tea Hut",null,50.0,152.55]
[null,"IT Social",null,300.0,250.0]
[null,"Winter Social",null,150.0]
[null,"Drumline Social",null,0.0]
[null,"Brass Social",null,0.0]
[null,"Woodwind Social",null,0.0]
[null,"End of Year Social",null,150.0]
["Total Expected Expenses",null,null,{"$f":"SUM(D33:D111)","v":44962.86},{"$f":"sum(E33:E111)","v":22402.42}]
["Safety Buffer",null,null,10000.0]
["Expected Total Surplus/Deficit",null,null,{"$f":"D28-D112","v":28545.14},8918.58]
["Expected Available Surplus/Deficit",null,null,{"$f":"D114-D113","v":18545.14}]

{"sheet":"Instructor Pay Breakdown","index":1,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["Instructor Pay Breakdown"]
["Fall Term","Hourly Rate","# of 3H Days","3H Day Pay","# of 2H Days","2H Day Pay","# of 1H Days","1H Day Pay","Total Payment"]
["Woodwinds",40.0,11.0,{"$f":"3*B3*C3","v":1320},0.0,{"$f":"2*D3*E3","v":0},0.0,{"$f":"1*F3*G3","v":0},{"$f":"D3+F3+H3","v":1320}]
["Brass",40.0,11.0,1320,0.0,0,0.0,0,1320]
["Drumline",40.0,11.0,1320,0.0,0,0.0,0,1320]
["Colour Guard",40.0,11.0,1320,0.0,0,0.0,0,1320]
["Winter Term","Hourly Rate","# of 3H Days","3H Day Pay","# of 2H Days","2H Day Pay","# of 1H Days","1H Day Pay","Total Payment"]
["Woodwinds",40.0,11.0,{"$f":"3*B8*C8","v":1320},0.0,{"$f":"2*D8*E8","v":0},0.0,{"$f":"1*F8*G8","v":0},{"$f":"D8+F8+H8","v":1320}]
["Brass",40.0,11.0,1320,0.0,0,0.0,0,1320]
["Drumline",40.0,11.0,1320,0.0,0,0.0,0,1320]
["Colour Guard",40.0,11.0,1320,0.0,0,0.0,0,1320]