{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Event Budget","Event Revenue","Event Profit Summary","Chart Data"],"not_rendered":{"charts":4,"images":2},"read":"whole","date_system":"1900"}

{"sheet":"Event Budget","index":0,"n_rows":66,"n_cols":6,"rows_kept":66,"merged":[[3,1,3,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[28,1,28,2],[29,1,29,2],[30,1,30,2],[31,1,31,2],[32,1,32,2],[33,1,33,2],[35,1,35,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[41,1,41,2],[42,1,42,2],[44,1,44,2],[45,1,45,2],[46,1,46,2],[47,1,47,2],[48,1,48,2],[49,1,49,2],[50,1,50,2],[52,1,52,2],[53,1,53,2],[54,1,54,2],[55,1,55,2],[56,1,56,2],[58,1,58,2],[59,1,59,2],[60,1,60,2],[61,1,61,2],[62,1,62,2],[63,1,63,2],[65,1,65,5]]}
[null,"EVENT BUDGET"]
[null,"Projected Subtotal to Date:",{"$f":"SUM(D5,D13,D18,D23,D28,D35,D44,D52,D58)","v":{"v":9500,"d":"$9,500.00"}}]
[null,"Actual Subtotal to Date:",{"$f":"SUM(E5,E13,E18,E23,E28,E35,E44,E52,E58)","v":{"v":7830,"d":"$7,830.00"}}]
[null,"CATEGORY",null,"PROJECTED SUBTOTAL","ACTUAL SUBTOTAL","COMMENTS"]
[null,"Venue","SUBTOTALS",{"$f":"SUM(D6:D12)","v":{"v":1500,"d":"$1,500.00"}},{"$f":"SUM(E6:E12)","v":{"v":1200,"d":"$1,200.00"}}]
[null,"Location Rental",null,{"v":1500,"d":"$1,500.00"},{"v":1200,"d":"$1,200.00"}]
[null,"Event Staff"]
[null,"Equipment Rental"]
[null,"Additional Tables / Chairs"]
[null,"AV"]
[]
[]
[null,"Travel","SUBTOTALS",{"$f":"SUM(D14:D17)","v":{"v":1600,"d":"$1,600.00"}},{"$f":"SUM(E14:E17)","v":{"v":1800,"d":"$1,800.00"}}]
[null,"Flight / Driving",null,{"v":1600,"d":"$1,600.00"},{"v":1800,"d":"$1,800.00"}]
[null,"Lodging"]
[null,"Per Diem"]
[]
[null,"Public Relations","SUBTOTALS",{"$f":"SUM(D19:D22)","v":{"v":1250,"d":"$1,250.00"}},{"$f":"SUM(E19:E22)","v":{"v":950,"d":"$950.00"}}]
[null,"Announcements",null,{"v":400,"d":"$400.00"},{"v":300,"d":"$300.00"}]
[null,"Graphics",null,{"v":600,"d":"$600.00"},{"v":400,"d":"$400.00"}]
[null,"Press Releases",null,{"v":250,"d":"$250.00"},{"v":250,"d":"$250.00"}]
[]
[null,"Décor","SUBTOTALS",{"$f":"SUM(D24:D27)","v":{"v":300,"d":"$300.00"}},{"$f":"SUM(E24:E27)","v":{"v":280,"d":"$280.00"}}]
[null,"Linens",null,{"v":300,"d":"$300.00"},{"v":280,"d":"$280.00"}]
[null,"Lighting"]
[null,"Additional Signage"]
[]
[null,"Event Programming","SUBTOTALS",{"$f":"SUM(D29:D34)","v":{"v":2000,"d":"$2,000.00"}},{"$f":"SUM(E29:E34)","v":{"v":1800,"d":"$1,800.00"}}]
[null,"Speakers",null,{"v":1500,"d":"$1,500.00"},{"v":1300,"d":"$1,300.00"}]
[null,"Performers",null,{"v":500,"d":"$500.00"},{"v":500,"d":"$500.00"}]
[null,"Video Production"]
[null,"Presentation Graphics"]
[]
[]
[null,"Social Media","SUBTOTALS",{"$f":"SUM(D36:D43)","v":{"v":350,"d":"$350.00"}},{"$f":"SUM(E36:E43)","v":{"v":350,"d":"$350.00"}}]
[null,"Twitter",null,{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"}]
[null,"Facebook",null,{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"}]
[null,"Pinterest",null,{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"}]
[null,"Instagram",null,{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"}]
[null,"Google+",null,{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"}]
[null,"LinkedIn",null,{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"}]
[null,"Snapchat",null,{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"}]
[]
[null,"Advertising","SUBTOTALS",{"$f":"SUM(D45:D51)","v":{"v":1400,"d":"$1,400.00"}},{"$f":"SUM(E45:E51)","v":{"v":500,"d":"$500.00"}}]
[null,"Online",null,{"v":400,"d":"$400.00"},{"v":300,"d":"$300.00"}]
[null,"Print",null,{"v":1000,"d":"$1,000.00"},{"v":200,"d":"$200.00"}]
[null,"Outdoor"]
[null,"Radio"]
[null,"Television"]
[]
[]
[null,"Refreshments","SUBTOTALS",{"$f":"SUM(D53:D57)","v":{"v":500,"d":"$500.00"}},{"$f":"SUM(E53:E57)","v":{"v":500,"d":"$500.00"}}]
[null,"Drinks",null,{"v":180,"d":"$180.00"},{"v":200,"d":"$200.00"}]
[null,"Food",null,{"v":320,"d":"$320.00"},{"v":300,"d":"$300.00"}]
[null,"Catering Staff"]
[]
[]
[null,"Other","SUBTOTALS",{"$f":"SUM(D59:D64)","v":{"v":600,"d":"$600.00"}},{"$f":"SUM(E59:E64)","v":{"v":450,"d":"$450.00"}}]
[null,"Gift Bags",null,{"v":600,"d":"$600.00"},{"v":450,"d":"$450.00"}]
[null,"Pens"]
[null,"Notebooks"]
[null,"Packet Printing"]
[]
[]
[]
[null,"CLICK HERE TO CREATE EVENT BUDGET TEMPLATES IN SMARTSHEET"]

{"sheet":"Event Revenue","index":1,"n_rows":46,"n_cols":11,"rows_kept":46,"merged":[[3,1,3,2],[3,3,3,4],[3,6,3,7],[3,8,3,9],[4,1,4,2],[5,1,5,2],[5,6,5,7],[5,8,5,9],[6,1,6,2],[6,6,6,7],[6,8,6,9],[7,1,7,2],[7,6,7,7],[7,8,7,9],[8,1,8,2],[8,6,8,7],[8,8,8,9],[9,1,9,2],[9,6,9,7],[9,8,9,9],[10,1,10,2],[10,6,10,7],[10,8,10,9],[11,1,11,2],[11,6,11,7],[11,8,11,9],[12,1,12,2],[13,1,13,2],[13,6,13,7],[13,8,13,9],[14,1,14,2],[14,6,14,7],[14,8,14,9],[15,1,15,2],[15,6,15,7],[15,8,15,9],[16,1,16,2],[16,6,16,7],[16,8,16,9],[17,1,17,2],[18,1,18,2],[18,6,18,7],[18,8,18,9],[19,1,19,2],[19,6,19,7],[19,8,19,9],[20,1,20,2],[20,6,20,7],[20,8,20,9],[21,1,21,2],[21,6,21,7],[21,8,21,9],[22,1,22,2],[22,6,22,7],[22,8,22,9],[23,1,23,2],[23,6,23,7],[23,8,23,9],[24,1,24,2],[24,6,24,7],[24,8,24,9],[25,1,25,2],[26,1,26,2],[26,6,26,7],[26,8,26,9],[27,1,27,2],[27,6,27,7],[27,8,27,9],[28,1,28,2],[28,6,28,7],[28,8,28,9],[29,1,29,2],[29,6,29,7],[29,8,29,9],[30,1,30,2],[31,1,31,2],[31,6,31,7],[31,8,31,9],[32,1,32,2],[32,6,32,7],[32,8,32,9],[33,1,33,2],[33,6,33,7],[33,8,33,9],[34,1,34,2],[34,6,34,7],[34,8,34,9],[35,1,35,2],[35,6,35,7],[35,8,35,9],[36,1,36,2],[36,6,36,7],[36,8,36,9],[37,1,37,2],[38,1,38,2],[38,6,38,7],[38,8,38,9],[39,1,39,2],[39,6,39,7],[39,8,39,9],[40,1,40,2],[40,6,40,7],[40,8,40,9],[41,1,41,2],[41,6,41,7],[41,8,41,9],[42,1,42,2],[42,6,42,7],[42,8,42,9],[43,1,43,2],[43,6,43,7],[43,8,43,9],[44,1,44,2],[44,6,44,7],[44,8,44,9],[45,1,45,2],[45,6,45,7],[45,8,45,9]]}
[null,"EVENT REVENUE"]
[null,"Projected Subtotal to Date:",{"$f":"SUM(H5,H13,H18,H26,H31,H38)","v":{"v":63800,"d":"$63,800.00"}}]
[null,"Actual Subtotal to Date:",{"$f":"SUM(J5,J13,J18,J26,J31,J38)","v":{"v":65725,"d":"$65,725.00"}}]
[null,"CATEGORY",null,"QUANTITY",null,"COST","PROJECTED SUBTOTAL",null,"ACTUAL SUBTOTAL",null,"COMMENTS"]
[null,"Vendors",null,"PROJECTED","ACTUAL",null,"SUBTOTAL",{"$f":"SUM(G6:H12)","v":{"v":23350,"d":"$23,350.00"}},"SUBTOTAL",{"$f":"SUM(I6:J12)","v":{"v":24200,"d":"$24,200.00"}}]
[null,"Entrance Kiosk",null,1,1,{"v":800,"d":"$800.00"},{"$f":"D6*F6","v":{"v":800,"d":"$800.00"}},null,{"$f":"E6*F6","v":{"v":800,"d":"$800.00"}}]
[null,"Exit Kiosk",null,1,1,{"v":800,"d":"$800.00"},{"$f":"D7*F7","v":{"v":800,"d":"$800.00"}},null,{"$f":"E7*F7","v":{"v":800,"d":"$800.00"}}]
[null,"Space - Large",null,15,14,{"v":650,"d":"$650.00"},{"$f":"D8*F8","v":{"v":9750,"d":"$9,750.00"}},null,{"v":9100,"d":"$9,100.00"}]
[null,"Space - Medium",null,20,20,{"v":450,"d":"$450.00"},{"v":9000,"d":"$9,000.00"},null,{"v":9000,"d":"$9,000.00"}]
[null,"Space - Small",null,10,15,{"v":300,"d":"$300.00"},{"v":3000,"d":"$3,000.00"},null,{"v":4500,"d":"$4,500.00"}]
[{"$nulls":6},0,null,0]
[{"$nulls":6},0,null,0]
[null,"Sponsor / Partnerships",null,"PROJECTED","ACTUAL",null,"SUBTOTAL",{"$f":"SUM(G14:H17)","v":{"v":7400,"d":"$7,400.00"}},"SUBTOTAL",{"$f":"SUM(I14:J17)","v":{"v":8600,"d":"$8,600.00"}}]
[null,"Named Sponsor",null,1,1,{"v":5000,"d":"$5,000.00"},{"$f":"D14*F14","v":{"v":5000,"d":"$5,000.00"}},null,{"$f":"E14*F14","v":{"v":5000,"d":"$5,000.00"}}]
[null,"Featured Vendor",null,2,3,{"v":1200,"d":"$1,200.00"},{"$f":"D15*F15","v":{"v":2400,"d":"$2,400.00"}},null,{"$f":"E15*F15","v":{"v":3600,"d":"$3,600.00"}}]
[{"$nulls":6},0,null,0]
[{"$nulls":6},0,null,0]
[null,"Program Ads",null,"PROJECTED","ACTUAL",null,"SUBTOTAL",{"$f":"SUM(G19:H25)","v":{"v":15800,"d":"$15,800.00"}},"SUBTOTAL",{"$f":"SUM(I19:J25)","v":{"v":16050,"d":"$16,050.00"}}]
[null,"Front Cover",null,1,1,{"v":800,"d":"$800.00"},{"$f":"D19*F19","v":{"v":800,"d":"$800.00"}},null,{"$f":"E19*F19","v":{"v":800,"d":"$800.00"}}]
[null,"Back Cover",null,1,1,{"v":750,"d":"$750.00"},{"$f":"D20*F20","v":{"v":750,"d":"$750.00"}},null,{"$f":"E20*F20","v":{"v":750,"d":"$750.00"}}]
[null,"Full Page",null,25,20,{"v":250,"d":"$250.00"},{"v":6250,"d":"$6,250.00"},null,{"v":5000,"d":"$5,000.00"}]
[null,"Half Page",null,50,60,{"v":150,"d":"$150.00"},{"v":7500,"d":"$7,500.00"},null,{"v":9000,"d":"$9,000.00"}]
[null,"Centerfold",null,1,1,{"v":500,"d":"$500.00"},{"v":500,"d":"$500.00"},null,{"v":500,"d":"$500.00"}]
[{"$nulls":6},0,null,0]
[{"$nulls":6},0,null,0]
[null,"Ticket Sales",null,"PROJECTED","ACTUAL",null,"SUBTOTAL",{"$f":"SUM(G27:H30)","v":{"v":11500,"d":"$11,500.00"}},"SUBTOTAL",{"$f":"SUM(I27:J30)","v":{"v":13325,"d":"$13,325.00"}}]
[null,"Adult",null,500,600,{"v":15,"d":"$15.00"},{"$f":"D27*F27","v":{"v":7500,"d":"$7,500.00"}},null,{"$f":"E27*F27","v":{"v":9000,"d":"$9,000.00"}}]
[null,"Senior",null,300,350,{"v":10,"d":"$10.00"},{"$f":"D28*F28","v":{"v":3000,"d":"$3,000.00"}},null,{"$f":"E28*F28","v":{"v":3500,"d":"$3,500.00"}}]
[null,"Child",null,200,165,{"v":5,"d":"$5.00"},{"v":1000,"d":"$1,000.00"},null,{"v":825,"d":"$825.00"}]
[{"$nulls":6},0,null,0]
[null,"Product Sales",null,"PROJECTED","ACTUAL",null,"SUBTOTAL",{"$f":"SUM(G32:H37)","v":{"v":3750,"d":"$3,750.00"}},"SUBTOTAL",{"$f":"SUM(I32:J37)","v":{"v":2950,"d":"$2,950.00"}}]
[null,"Product 1",null,100,50,{"v":15,"d":"$15.00"},{"$f":"D32*F32","v":{"v":1500,"d":"$1,500.00"}},null,{"$f":"E32*F32","v":{"v":750,"d":"$750.00"}}]
[null,"Product 2",null,100,110,{"v":10,"d":"$10.00"},{"$f":"D33*F33","v":{"v":1000,"d":"$1,000.00"}},null,{"$f":"E33*F33","v":{"v":1100,"d":"$1,100.00"}}]
[null,"Product 3",null,100,88,{"v":12.5,"d":"$12.50"},{"v":1250,"d":"$1,250.00"},null,{"v":1100,"d":"$1,100.00"}]
[{"$nulls":6},0,null,0]
[{"$nulls":6},0,null,{"$f":"E36*F36","v":0}]
[{"$nulls":6},0,null,{"$f":"E37*F37","v":0}]
[null,"Other",null,"PROJECTED","ACTUAL",null,"SUBTOTAL",{"$f":"SUM(G39:H46)","v":{"v":2000,"d":"$2,000.00"}},"SUBTOTAL",{"$f":"SUM(I39:J46)","v":{"v":600,"d":"$600.00"}}]
[null,"Other",null,100,30,{"v":20,"d":"$20.00"},{"$f":"D39*F39","v":{"v":2000,"d":"$2,000.00"}},null,{"$f":"E39*F39","v":{"v":600,"d":"$600.00"}}]
[{"$nulls":6},{"$f":"D40*F40","v":0},null,{"$f":"E40*F40","v":0}]
[{"$nulls":6},0,null,0]
[{"$nulls":6},0,null,0]
[{"$nulls":6},0,null,0]
[{"$nulls":6},0,null,0]
[{"$nulls":6},0,null,0]
[{"$nulls":6},{"$f":"D46*F46","v":0},null,{"$f":"E46*F46","v":0}]

{"sheet":"Event Profit Summary","index":2,"n_rows":10,"n_cols":4,"rows_kept":10,"merged":[[2,1,2,3],[7,1,7,3]]}
[null,"EVENT REVENUE"]
[]
[null,"BUDGET / REVENUE TOTALS"]
[null,null,"PROJECTED","ACTUAL"]
[null,"TOTAL BUDGET",{"$f":"'Event Budget'!$C$2","v":{"v":9500,"d":"$9,500.00"}},{"$f":"'Event Budget'!$C$3","v":{"v":7830,"d":"$7,830.00"}}]
[null,"TOTAL REVENUE",{"$f":"'Event Revenue'!C2","v":{"v":63800,"d":"$63,800.00"}},{"$f":"'Event Revenue'!C3","v":{"v":65725,"d":"$65,725.00"}}]
[]
[null,"PROFIT TOTALS"]
[null,null,"PROJECTED","ACTUAL"]
[null,"TOTALS",{"$f":"SUM(C6-C5)","v":{"v":54300,"d":"$54,300.00"}},{"$f":"SUM(D6-D5)","v":{"v":57895,"d":"$57,895.00"}}]

{"sheet":"Chart Data","index":3,"n_rows":13,"n_cols":4,"rows_kept":13}
[null,"CHART DATA"]
[]
[null,"CAMPAIGN TYPE","PROJECTED SUBTOTAL","%"]
[null,{"$f":"'Event Budget'!B5:C5","v":"Venue"},{"$f":"'Event Budget'!D5","v":{"v":1500,"d":"$1,500.00"}},{"$f":"C4/C13","v":{"v":0.15789473684210525,"d":"16%"}}]
[null,{"$f":"'Event Budget'!B13:C13","v":"Travel"},{"$f":"'Event Budget'!D13","v":{"v":1600,"d":"$1,600.00"}},{"$f":"C5/C13","v":{"v":0.16842105263157894,"d":"17%"}}]
[null,{"$f":"'Event Budget'!B18:C18","v":"Public Relations"},{"$f":"'Event Budget'!D18","v":{"v":1250,"d":"$1,250.00"}},{"$f":"C6/C13","v":{"v":0.13157894736842105,"d":"13%"}}]
[null,{"$f":"'Event Budget'!B23:C23","v":"Décor"},{"$f":"'Event Budget'!D23","v":{"v":300,"d":"$300.00"}},{"$f":"C7/C13","v":{"v":0.031578947368421054,"d":"3%"}}]
[null,{"$f":"'Event Budget'!B28:C28","v":"Event Programming"},{"$f":"'Event Budget'!D28","v":{"v":2000,"d":"$2,000.00"}},{"$f":"C8/C13","v":{"v":0.21052631578947367,"d":"21%"}}]
[null,{"$f":"'Event Budget'!B35:C35","v":"Social Media"},{"$f":"'Event Budget'!D35","v":{"v":350,"d":"$350.00"}},{"$f":"C9/C13","v":{"v":0.03684210526315789,"d":"4%"}}]
[null,{"$f":"'Event Budget'!B44:C44","v":"Advertising"},{"$f":"'Event Budget'!D44","v":{"v":1400,"d":"$1,400.00"}},{"$f":"C10/C13","v":{"v":0.14736842105263157,"d":"15%"}}]
[null,{"$f":"'Event Budget'!B52:C52","v":"Refreshments"},{"$f":"'Event Budget'!D52","v":{"v":500,"d":"$500.00"}},{"$f":"C11/C13","v":{"v":0.05263157894736842,"d":"5%"}}]
[null,{"$f":"'Event Budget'!B58:C58","v":"Other"},{"$f":"'Event Budget'!D58","v":{"v":600,"d":"$600.00"}},{"$f":"C12/C13","v":{"v":0.06315789473684211,"d":"6%"}}]
[null,null,{"$f":"SUM(C4:C12)","v":{"v":9500,"d":"$9,500.00"}}]