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

{"sheet":"Start","index":0,"n_rows":9,"n_cols":3,"rows_kept":9}
[null,null," "]
[null,"ABOUT THIS TEMPLATE"]
[null,"Use this event budget workbook to track expenses incurred on and income earned from an event."]
[null,"Enter details in tables in expenses worksheet and income worksheet."]
[null,"Total expenses and total income are auto-calculated."]
[null,"Profit & loss summary and chart are auto-updated in profit-loss summary worksheet."]
[null,"Note: "]
[null,"Additional instructions have been provided in column A in each worksheet. This text has been intentionally hidden. To remove text, select column A, then select DELETE. "]
[null,"To learn more about tables, press SHIFT and then F10 within a table, select the TABLE option, and then select ALTERNATIVE TEXT"]

{"sheet":"Expenses","index":1,"n_rows":33,"n_cols":9,"rows_kept":33,"merged":[[1,1,1,5],[3,1,4,1]]}
[{"$nulls":8}," "]
[null,"Event budget",{"$nulls":5},"EXPENSES"]
[]
[null,"TOTAL EXPENSES",{"$nulls":4},"Estimated","Actual"]
[{"$nulls":6},{"$f":"SUM(C12,C20,C26,C33,G12,G20,G25)","v":{"v":882,"d":"$882.00"}},{"$f":"SUM(D12,D20,D26,D33,H12,H20,H25)","v":{"v":333,"d":"$333.00"}}]
[]
[null,"Site","Estimated","Actual",null,"Refreshments","Estimated","Actual"]
[null,"Room and hall fees",{"v":500,"d":"$500.00"},null,null,"Food"]
[null,"Site staff",{"$nulls":3},"Drinks",{"v":20,"d":"$20.00"}]
[null,"Equipment",{"$nulls":3},"Linens",null,{"v":20,"d":"$20.00"}]
[null,"Tables and chairs",{"$nulls":3},"Staff and gratuities"]
[null,"Total",{"$f":"SUBTOTAL(109,SiteExpenses[Estimated])","v":{"v":500,"d":"$500.00"}},{"$f":"SUBTOTAL(109,SiteExpenses[Actual])","v":{"v":0,"d":"$0.00"}},null,"Total",{"$f":"SUBTOTAL(109,RefreshmentsExpenses[Estimated])","v":{"v":20,"d":"$20.00"}},{"$f":"SUBTOTAL(109,RefreshmentsExpenses[Actual])","v":{"v":20,"d":"$20.00"}}]
[]
[null,"Decorations","Estimated","Actual",null,"Program","Estimated","Actual"]
[null,"Flowers",{"v":200,"d":"$200.00"},{"v":300,"d":"$300.00"},null,"Performers"]
[null,"Candles",{"$nulls":3},"Speakers",{"v":30,"d":"$30.00"}]
[null,"Lighting",{"$nulls":3},"Travel"]
[null,"Balloons",{"$nulls":3},"Hotel"]
[null,"Paper supplies",{"$nulls":3},"Other"]
[null,"Total",{"$f":"SUBTOTAL(109,DecorationsExpenses[Estimated])","v":{"v":200,"d":"$200.00"}},{"$f":"SUBTOTAL(109,DecorationsExpenses[Actual])","v":{"v":300,"d":"$300.00"}},null,"Total",{"$f":"SUBTOTAL(109,ProgramExpenses[Estimated])","v":{"v":30,"d":"$30.00"}},{"$f":"SUBTOTAL(109,ProgramExpenses[Actual])","v":{"v":0,"d":"$0.00"}}]
[]
[null,"Publicity","Estimated","Actual",null,"Prizes","Estimated","Actual"]
[null,"Graphics work",{"$nulls":3},"Ribbons/Plaques/Trophies"]
[null,"Photocopying/Printing",{"v":20,"d":"$20.00"},null,null,"Gifts",{"v":100,"d":"$100.00"}]
[null,"Postage",{"$nulls":3},"Total",{"$f":"SUBTOTAL(109,PrizesExpenses[Estimated])","v":{"v":100,"d":"$100.00"}},{"$f":"SUBTOTAL(109,PrizesExpenses[Actual])","v":{"v":0,"d":"$0.00"}}]
[null,"Total",{"$f":"SUBTOTAL(109,PublicityExpenses[Estimated])","v":{"v":20,"d":"$20.00"}},{"$f":"SUBTOTAL(109,PublicityExpenses[Actual])","v":{"v":0,"d":"$0.00"}}]
[]
[null,"Miscellaneous","Estimated","Actual"]
[null,"Telephone",null,{"v":13,"d":"$13.00"}]
[null,"Transportation",{"v":12,"d":"$12.00"}]
[null,"Stationery supplies"]
[null,"Fax services"]
[null,"Total",{"$f":"SUBTOTAL(109,MiscellaneousExpenses[Estimated])","v":{"v":12,"d":"$12.00"}},{"$f":"SUBTOTAL(109,MiscellaneousExpenses[Actual])","v":{"v":13,"d":"$13.00"}}]

{"sheet":"Income","index":2,"n_rows":34,"n_cols":8,"rows_kept":34,"merged":[[1,1,1,4],[3,1,4,1]]}
[{"$nulls":7}," "]
[null,{"$f":"Expenses!B2","v":"Event budget"},{"$nulls":4},"INCOME"]
[]
[null,"TOTAL INCOME",{"$nulls":3},"Estimated","Actual"]
[{"$nulls":5},{"$f":"SUM(Admissions[[#Totals],[Estimated income]],AdsInProgram[[#Totals],[Estimated income]],ExhibitorsAndVendors[[#Totals],[Estimated income]],SaleOfItems[[#Totals],[Estimated income]])","v":{"v":1936,"d":"$1,936.00"}},{"$f":"SUM(Admissions[[#Totals],[Actual income]],AdsInProgram[[#Totals],[Actual income]],ExhibitorsAndVendors[[#Totals],[Actual income]],SaleOfItems[[#Totals],[Actual income]])","v":{"v":1831,"d":"$1,831.00"}}]
[]
[null,"ADMISSIONS"]
[null,"Estimated no.","Actual no.","Type","Price","Estimated income","Actual income"]
[null,300,278,"Adults @",{"v":5,"d":"$5.00"},{"$f":"B9*E9","v":{"v":1500,"d":"$1,500.00"}},{"$f":"C9*E9","v":{"v":1390,"d":"$1,390.00"}}]
[null,197,195,"Children @",{"v":2,"d":"$2.00"},{"$f":"B10*E10","v":{"v":394,"d":"$394.00"}},{"$f":"C10*E10","v":{"v":390,"d":"$390.00"}}]
[null,42,51,"Other @",{"v":1,"d":"$1.00"},{"$f":"B11*E11","v":{"v":42,"d":"$42.00"}},{"$f":"C11*E11","v":{"v":51,"d":"$51.00"}}]
[null,"Total",{"$nulls":3},{"$f":"SUBTOTAL(109,Admissions[Estimated income])","v":{"v":1936,"d":"$1,936.00"}},{"$f":"SUBTOTAL(109,Admissions[Actual income])","v":{"v":1831,"d":"$1,831.00"}}]
[]
[null,"ADS IN PROGRAM"]
[null,"Estimated no.","Actual no.","Type","Price","Estimated income","Actual income"]
[{"$nulls":3},"Covers @",null,{"$f":"B16*E16","v":{"v":0,"d":"$0.00"}},{"$f":"C16*E16","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},"Half-pages @",null,{"$f":"B17*E17","v":{"v":0,"d":"$0.00"}},{"$f":"C17*E17","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},"Quarter-pages @",null,{"$f":"B18*E18","v":{"v":0,"d":"$0.00"}},{"$f":"C18*E18","v":{"v":0,"d":"$0.00"}}]
[null,"Total",{"$nulls":3},{"$f":"SUBTOTAL(109,AdsInProgram[Estimated income])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,AdsInProgram[Actual income])","v":{"v":0,"d":"$0.00"}}]
[]
[null,"EXHIBITORS/VENDORS"]
[null,"Estimated no.","Actual no.","Type","Price","Estimated income","Actual income"]
[{"$nulls":3},"Large booths @",null,{"$f":"B23*E23","v":{"v":0,"d":"$0.00"}},{"$f":"C23*E23","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},"Med. booths @",null,{"$f":"B24*E24","v":{"v":0,"d":"$0.00"}},{"$f":"C24*E24","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},"Small booths @",null,{"$f":"B25*E25","v":{"v":0,"d":"$0.00"}},{"$f":"C25*E25","v":{"v":0,"d":"$0.00"}}]
[null,"Total",{"$nulls":3},{"$f":"SUBTOTAL(109,ExhibitorsAndVendors[Estimated income])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,ExhibitorsAndVendors[Actual income])","v":{"v":0,"d":"$0.00"}}]
[]
[null,"SALE OF ITEMS"]
[null,"Estimated no.","Actual no.","Type","Price","Estimated income","Actual income"]
[{"$nulls":3},"Items @",null,{"$f":"B30*E30","v":{"v":0,"d":"$0.00"}},{"$f":"C30*E30","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},"Items @",null,{"$f":"B31*E31","v":{"v":0,"d":"$0.00"}},{"$f":"C31*E31","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},"Items @",null,{"$f":"B32*E32","v":{"v":0,"d":"$0.00"}},{"$f":"C32*E32","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},"Items @",null,{"$f":"B33*E33","v":{"v":0,"d":"$0.00"}},{"$f":"C33*E33","v":{"v":0,"d":"$0.00"}}]
[null,"Total",{"$nulls":3},{"$f":"SUBTOTAL(109,SaleOfItems[Estimated income])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,SaleOfItems[Actual income])","v":{"v":0,"d":"$0.00"}}]

{"sheet":"Profit-loss Summary","index":3,"n_rows":10,"n_cols":8,"rows_kept":10,"merged":[[1,1,1,4],[3,1,4,1]]}
[{"$nulls":7}," "]
[null,{"$f":"Expenses!B2","v":"Event budget"},{"$nulls":4},"PROFIT "]
[]
[null,"LOSS SUMMARY"]
[]
[]
[null," Total","Estimated","Actual"]
[null,"Total income",{"$f":"Income!F5","v":{"v":1936,"d":"$1,936.00"}},{"$f":"Income!G5","v":{"v":1831,"d":"$1,831.00"}}]
[null,"Total expenses",{"$f":"Expenses!G5","v":{"v":882,"d":"$882.00"}},{"$f":"Expenses!H5","v":{"v":333,"d":"$333.00"}}]
[null,"Total profit (or loss)",{"$f":"C8-C9","v":{"v":1054,"d":"$1,054.00"}},{"$f":"D8-D9","v":{"v":1498,"d":"$1,498.00"}}]