{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Expenses","Income","Profit - Loss Summary"],"not_rendered":{"charts":4,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Expenses","index":0,"n_rows":54,"n_cols":6,"rows_kept":54,"merged":[[1,1,1,4],[2,1,2,7]]}
[]
[null,"Event Name",{"$nulls":3},"[Date]"]
[null,"Event Budget for Event Name: EXPENSES"]
[]
[null,"Site","Estimated","Actual",null,"Actual Cost Breakdown"]
[null,"Room and hall fees",{"v":500,"d":"$500.00"},{"v":300,"d":"$300.00"}]
[null,"Site staff"]
[null,"Equipment"]
[null,"Tables and chairs"]
[null,"Total",{"$f":"SUM(C6:C9)","v":{"v":500,"d":"$500.00"}},{"$f":"SUM(D6:D9)","v":{"v":300,"d":"$300.00"}}]
[]
[null,"Decorations","Estimated","Actual"]
[null,"Flowers",{"v":200,"d":"$200.00"},{"v":500,"d":"$500.00"}]
[null,"Candles"]
[null,"Lighting"]
[null,"Balloons"]
[null,"Paper supplies"]
[null,"Total",{"$f":"SUM(C13:C17)","v":{"v":200,"d":"$200.00"}},{"$f":"SUM(D13:D17)","v":{"v":500,"d":"$500.00"}}]
[]
[null,"Publicity","Estimated","Actual"]
[null,"Graphics work",{"v":500,"d":"$500.00"},{"v":800,"d":"$800.00"}]
[null,"Photocopying/Printing"]
[null,"Postage"]
[null,"Total",{"$f":"SUM(C21:C23)","v":{"v":500,"d":"$500.00"}},{"$f":"SUM(D21:D23)","v":{"v":800,"d":"$800.00"}}]
[]
[null,"Miscellaneous","Estimated","Actual",null,"Estimated vs. Actual"]
[null,"Telephone",{"v":500,"d":"$500.00"},{"v":600,"d":"$600.00"}]
[null,"Transportation"]
[null,"Stationery supplies"]
[null,"Fax services"]
[null,"Total",{"$f":"SUM(C27:C30)","v":{"v":500,"d":"$500.00"}},{"$f":"SUM(D27:D30)","v":{"v":600,"d":"$600.00"}}]
[]
[null,"Refreshments","Estimated","Actual"]
[null,"Food",{"v":600,"d":"$600.00"},{"v":800,"d":"$800.00"}]
[null,"Drinks"]
[null,"Linens"]
[null,"Staff and gratuities"]
[null,"Total",{"$f":"SUM(C34:C37)","v":{"v":600,"d":"$600.00"}},{"$f":"SUM(D34:D37)","v":{"v":800,"d":"$800.00"}}]
[]
[null,"Program","Estimated","Actual"]
[null,"Performers",{"v":300,"d":"$300.00"},{"v":500,"d":"$500.00"}]
[null,"Speakers"]
[null,"Travel"]
[null,"Hotel"]
[null,"Other"]
[null,"Total",{"$f":"SUM(C41:C45)","v":{"v":300,"d":"$300.00"}},{"$f":"SUM(D41:D45)","v":{"v":500,"d":"$500.00"}}]
[]
[null,"Prizes","Estimated","Actual"]
[null,"Ribbons/Plaques/Trophies",{"v":200,"d":"$200.00"},{"v":300,"d":"$300.00"}]
[null,"Gifts"]
[null,"Total",{"$f":"SUM(C49:C50)","v":{"v":200,"d":"$200.00"}},{"$f":"SUM(D49:D50)","v":{"v":300,"d":"$300.00"}}]
[]
[null,"Total Expenses","Estimated","Actual"]
[null,null,{"$f":"SUM(C10,C18,C24,C31,C38,C46,C51)","v":{"v":2800,"d":"$2,800.00"}},{"$f":"SUM(D10+D18+D24+D31+D38+D46+D51)","v":{"v":3800,"d":"$3,800.00"}}]

{"sheet":"Income","index":1,"n_rows":34,"n_cols":10,"rows_kept":34,"merged":[[0,1,0,5],[1,1,1,7]]}
[null,{"$f":"Expenses!B2","v":"Event Name"}]
[null,"Event Budget for Event Name: INCOME"]
[]
[null,"Admissions",{"$nulls":4},"Estimated","Actual",null,"Income Comparison"]
[null,"Estimated","Actual"]
[null,300,100,"Adults @",{"v":5,"d":"$5.00"},null,{"$f":"B6*E6","v":{"v":1500,"d":"$1,500.00"}},{"$f":"C6*E6","v":{"v":500,"d":"$500.00"}}]
[null,200,50,"Children @",{"v":2,"d":"$2.00"},null,{"$f":"B7*E7","v":{"v":400,"d":"$400.00"}},{"$f":"C7*E7","v":{"v":100,"d":"$100.00"}}]
[null,100,50,"Other @",{"v":1,"d":"$1.00"},null,{"$f":"B8*E8","v":{"v":100,"d":"$100.00"}},{"$f":"C8*E8","v":{"v":50,"d":"$50.00"}}]
[{"$nulls":6},{"$f":"SUM(G6:G8)","v":{"v":2000,"d":"$2,000.00"}},{"$f":"SUM(H6:H8)","v":{"v":650,"d":"$650.00"}}]
[]
[null,"Ads in program",{"$nulls":4},"Estimated","Actual"]
[null,"Estimated","Actual"]
[null,300,100,"Covers @",{"v":20,"d":"$20.00"},null,{"$f":"B13*E13","v":{"v":6000,"d":"$6,000.00"}},{"$f":"C13*E13","v":{"v":2000,"d":"$2,000.00"}}]
[null,200,50,"Half-pages @",{"v":10,"d":"$10.00"},null,{"$f":"B14*E14","v":{"v":2000,"d":"$2,000.00"}},{"$f":"C14*E14","v":{"v":500,"d":"$500.00"}}]
[null,100,50,"Quarter-pages @",{"v":5,"d":"$5.00"},null,{"$f":"B15*E15","v":{"v":500,"d":"$500.00"}},{"$f":"C15*E15","v":{"v":250,"d":"$250.00"}}]
[{"$nulls":6},{"$f":"SUM(G13:G15)","v":{"v":8500,"d":"$8,500.00"}},{"$f":"SUM(H13:H15)","v":{"v":2750,"d":"$2,750.00"}}]
[]
[null,"Exhibitors/vendors",{"$nulls":4},"Estimated","Actual"]
[null,"Estimated","Actual"]
[null,100,50,"Large booths @",{"v":20,"d":"$20.00"},null,{"$f":"B20*E20","v":{"v":2000,"d":"$2,000.00"}},{"$f":"C20*E20","v":{"v":1000,"d":"$1,000.00"}}]
[null,100,10,"Med. booths @",{"v":50,"d":"$50.00"},null,{"$f":"B21*E21","v":{"v":5000,"d":"$5,000.00"}},{"$f":"C21*E21","v":{"v":500,"d":"$500.00"}}]
[null,50,2,"Small booths @",{"v":5,"d":"$5.00"},null,{"$f":"B22*E22","v":{"v":250,"d":"$250.00"}},{"$f":"C22*E22","v":{"v":10,"d":"$10.00"}}]
[{"$nulls":6},{"$f":"SUM(G20:G22)","v":{"v":7250,"d":"$7,250.00"}},{"$f":"SUM(H20:H22)","v":{"v":1510,"d":"$1,510.00"}}]
[]
[null,"Sale of items",{"$nulls":4},"Estimated","Actual"]
[null,"Estimated","Actual"]
[null,400,300,"Items @",{"v":20,"d":"$20.00"},null,{"$f":"B27*E27","v":{"v":8000,"d":"$8,000.00"}},{"$f":"C27*E27","v":{"v":6000,"d":"$6,000.00"}}]
[null,300,200,"Items @",{"v":15,"d":"$15.00"},null,{"$f":"B28*E28","v":{"v":4500,"d":"$4,500.00"}},{"$f":"C28*E28","v":{"v":3000,"d":"$3,000.00"}}]
[null,200,100,"Items @",{"v":10,"d":"$10.00"},null,{"$f":"B29*E29","v":{"v":2000,"d":"$2,000.00"}},{"$f":"C29*E29","v":{"v":1000,"d":"$1,000.00"}}]
[null,100,0,"Items @",{"v":5,"d":"$5.00"},null,{"$f":"B30*E30","v":{"v":500,"d":"$500.00"}},{"$f":"C30*E30","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":6},{"$f":"SUM(G27:G30)","v":{"v":15000,"d":"$15,000.00"}},{"$f":"SUM(H27:H30)","v":{"v":10000,"d":"$10,000.00"}}]
[]
[null,"Total Income",{"$nulls":4},"Estimated","Actual"]
[{"$nulls":6},{"$f":"SUM(G9,G16,G23,G31)","v":{"v":32750,"d":"$32,750.00"}},{"$f":"SUM(H9,H16,H23,H31)","v":{"v":14910,"d":"$14,910.00"}}]

{"sheet":"Profit - Loss Summary","index":2,"n_rows":9,"n_cols":7,"rows_kept":9,"merged":[[0,1,0,5],[1,1,1,6]]}
[null,{"$f":"Expenses!B2","v":"Event Name"},{"$nulls":4},"2008-09-18"]
[null,"Event Budget for Event Name: PROFIT/LOSS SUMMARY"]
[]
[null,null,"Estimated","Actual",null,"Profit vs. Loss"]
[null,"Total income",{"$f":"Income!G34","v":{"v":32750,"d":"$32,750.00"}},{"$f":"Income!H34","v":{"v":14910,"d":"$14,910.00"}}]
[null,"Total expenses",{"$f":"Expenses!C54","v":{"v":2800,"d":"$2,800.00"}},{"$f":"Expenses!D54","v":{"v":3800,"d":"$3,800.00"}}]
[]
[null,"Total profit (or loss)"]
[null,null,{"$f":"C5-C6","v":{"v":29950,"d":"$29,950.00"}},{"$f":"D5-D6","v":{"v":11110,"d":"$11,110.00"}}]