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

{"sheet":"Start","index":0,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"ABOUT THIS TEMPLATE"]
[null,"Use this Event budget workbook to track Expenses incurred and Income earned through an event."]
[null,"Fill in Event name and 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 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. To unhide text, select column A, then change font colour."]
[null,"To learn more about tables, press SHIFT and then F10 within a table, select the TABLE option, then select ALTERNATIVE TEXT."]

{"sheet":"Expenses","index":1,"n_rows":33,"n_cols":8,"rows_kept":33,"merged":[[0,5,0,7],[1,1,1,7],[2,6,2,7]]}
["Enter Estimated and Actual expenses for each category in respective tables in this worksheet. Total expenses are auto-calculated. Helpful instructions on how to use this worksheet are in cells in this column. Arrow-down to get started."]
["Enter Event name in cell to the right to customise the title of this and other worksheets.","Event budget for \nEvent name"]
["Expenses label is in cell G3.",{"$nulls":5}," Expenses"]
["Estimated label is in cell G4 and Actual label in cell H4.",{"$nulls":5},"Estimated","Actual"]
["Total expenses label is in cell to the right. Estimated total expenses are auto-calculated in cell G5. Actual total expenses and data bar depicting Actual total expenses are auto-updated in cell H5. Next instruction is in cell A7.","Total expenses",{"$nulls":4},{"$f":"SUM(C12,C20,C26,C33,G12,G20,G25)","v":{"v":1145,"d":"£1,145.00"}},{"$f":"SUM(D12,D20,D26,D33,H12,H20,H25)","v":{"v":395,"d":"£395.00"}}]
[]
["Enter Site expenses in table starting in cell to the right and Refreshments expenses in table starting in cell F7. Next instruction is in cell A14.","Site","Estimated","Actual",null,"Refreshments","Estimated","Actual"]
[null,"Room and hall fees",{"v":500,"d":"£500.00"},{"v":250,"d":"£250.00"},null,"Food"]
[null,"Site staff",{"v":400,"d":"£400.00"},{"v":50,"d":"£50.00"},null,"Drinks"]
[null,"Equipment",{"$nulls":3},"Linen"]
[null,"Tables and chairs",{"$nulls":3},"Staff and gratuities"]
[null,"Total",{"$f":"SUBTOTAL(109,SiteExpenses[Estimated])","v":{"v":900,"d":"£900.00"}},{"$f":"SUBTOTAL(109,SiteExpenses[Actual])","v":{"v":300,"d":"£300.00"}},null,"Total",{"$f":"SUBTOTAL(109,RefreshmentsExpenses[Estimated])","v":{"v":0,"d":"£0.00"}},{"$f":"SUBTOTAL(109,RefreshmentsExpenses[Actual])","v":{"v":0,"d":"£0.00"}}]
[]
["Enter Decorations expenses in table starting in cell to the right and Program expenses in table starting in cell F14. Next instruction is in cell A22.","Decorations","Estimated","Actual",null,"Programme","Estimated","Actual"]
[null,"Flowers",{"v":200,"d":"£200.00"},{"v":50,"d":"£50.00"},null,"Performers"]
[null,"Candles",{"$nulls":3},"Speakers"]
[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":50,"d":"£50.00"}},null,"Total",{"$f":"SUBTOTAL(109,ProgramExpenses[Estimated])","v":{"v":0,"d":"£0.00"}},{"$f":"SUBTOTAL(109,ProgramExpenses[Actual])","v":{"v":0,"d":"£0.00"}}]
[]
["Enter Publicity expenses in table starting in cell to the right and Prizes expenses in table starting in cell F22. Next instruction is in cell A28.","Publicity","Estimated","Actual",null,"Prizes","Estimated","Actual"]
[null,"Graphics work",{"v":45,"d":"£45.00"},{"v":45,"d":"£45.00"},null,"Ribbons/Plaques/Trophies"]
[null,"Photocopying/Printing",{"$nulls":3},"Gifts"]
[null,"Postage",{"$nulls":3},"Total",{"$f":"SUBTOTAL(109,PrizesExpenses[Estimated])","v":{"v":0,"d":"£0.00"}},{"$f":"SUBTOTAL(109,PrizesExpenses[Actual])","v":{"v":0,"d":"£0.00"}}]
[null,"Total",{"$f":"SUBTOTAL(109,PublicityExpenses[Estimated])","v":{"v":45,"d":"£45.00"}},{"$f":"SUBTOTAL(109,PublicityExpenses[Actual])","v":{"v":45,"d":"£45.00"}}]
[]
["Enter Miscellaneous expenses in table starting in cell to the right.","Miscellaneous","Estimated","Actual"]
[null,"Telephone number"]
[null,"Transport"]
[null,"Stationery supplies"]
[null,"Fax services"]
[null,"Total",{"$f":"SUBTOTAL(109,MiscellaneousExpenses[Estimated])","v":{"v":0,"d":"£0.00"}},{"$f":"SUBTOTAL(109,MiscellaneousExpenses[Actual])","v":{"v":0,"d":"£0.00"}}]

{"sheet":"Income","index":2,"n_rows":30,"n_cols":7,"rows_kept":30,"merged":[[1,1,1,6],[2,5,2,6]]}
["Enter Estimated and Actual incomes from each category in respective tables in this worksheet. Total income is auto-calculated. Helpful instructions on how to use this worksheet are in cells in this column. Arrow-down to get started."]
["Event name is auto-updated in cell to the right.",{"$f":"Expenses!B2","v":"Event budget for \nEvent name"}]
["Income label is in cell F3.",{"$nulls":4}," Income"]
["Estimated label is in cell F4 and Actual label in cell G4.",{"$nulls":4},"Estimated","Actual"]
["Total income label is in cell to the right. Estimated total income is auto-calculated in cell F5. Actual total income and data bar depicting Actual total income are auto-updated in cell G5.","Total income",{"$nulls":3},{"$f":"SUM(Admissions[[#Totals],[Estimated total]],AdsInProgram[[#Totals],[Estimated total]],ExhibitorsAndvendors[[#Totals],[Estimated total]],SaleOfItem[[#Totals],[Estimated total]])","v":{"v":1936,"d":"£1,936.00"}},{"$f":"SUM(Admissions[[#Totals],[Actual total]],AdsInProgram[[#Totals],[Actual total]],ExhibitorsAndvendors[[#Totals],[Actual total]],SaleOfItem[[#Totals],[Actual total]])","v":{"v":1831,"d":"£1,831.00"}}]
["Admissions label is in cell to the right.","Admissions"]
["Enter Estimated and Actual number of admissions with ticket rates in table starting in cell to the right. Estimated and Actual income from admissions is auto-calculated. Next instruction is in cell A12.","Estimated","Actual","Type","Price","Estimated total","Actual total"]
[null,300,278,"Adults @",{"v":5,"d":"£5.00"},{"$f":"B8*E8","v":{"v":1500,"d":"£1,500.00"}},{"$f":"C8*E8","v":{"v":1390,"d":"£1,390.00"}}]
[null,197,195,"Children @",{"v":2,"d":"£2.00"},{"$f":"B9*E9","v":{"v":394,"d":"£394.00"}},{"$f":"C9*E9","v":{"v":390,"d":"£390.00"}}]
[null,42,51,"Other @",{"v":1,"d":"£1.00"},{"v":42,"d":"£42.00"},{"v":51,"d":"£51.00"}]
[null," ",{"$nulls":3},{"$f":"SUBTOTAL(109,Admissions[Estimated total])","v":{"v":1936,"d":"£1,936.00"}},{"$f":"SUBTOTAL(109,Admissions[Actual total])","v":{"v":1831,"d":"£1,831.00"}}]
["Ads in programme label are in cell to the right.","Ads in programme"]
["Enter Estimated and Actual number of ads in programme and ad rates in table starting in cell to the right. Estimated and Actual income from ads is auto-calculated. Next instruction is in cell A18.","Estimated","Actual","Type","Price","Estimated total","Actual total"]
[{"$nulls":3},"Covers @",null,{"$f":"B14*E14","v":{"v":0,"d":"£0.00"}},{"$f":"C14*E14","v":{"v":0,"d":"£0.00"}}]
[{"$nulls":3},"Half-pages @",null,{"$f":"B15*E15","v":{"v":0,"d":"£0.00"}},{"$f":"C15*E15","v":{"v":0,"d":"£0.00"}}]
[{"$nulls":3},"Quarter-pages @",null,{"v":0,"d":"£0.00"},{"v":0,"d":"£0.00"}]
[null," ",{"$nulls":3},{"$f":"SUBTOTAL(109,AdsInProgram[Estimated total])","v":{"v":0,"d":"£0.00"}},{"$f":"SUBTOTAL(109,AdsInProgram[Actual total])","v":{"v":0,"d":"£0.00"}}]
["Exhibitors or Vendors label is in cell to the right.","Exhibitors/vendors"]
["Enter Estimated and Actual number of exhibitors and vendors and booth rates in table starting in cell to the right. Estimated and Actual income are auto-calculated. Next instruction is in cell A24.","Estimated","Actual","Type","Price","Estimated total","Actual total"]
[{"$nulls":3},"Large booths @",null,{"$f":"B20*E20","v":{"v":0,"d":"£0.00"}},{"$f":"C20*E20","v":{"v":0,"d":"£0.00"}}]
[{"$nulls":3},"Med. booths @",null,{"$f":"B21*E21","v":{"v":0,"d":"£0.00"}},{"$f":"C21*E21","v":{"v":0,"d":"£0.00"}}]
[{"$nulls":3},"Small booths @",null,{"v":0,"d":"£0.00"},{"v":0,"d":"£0.00"}]
[null," ",{"$nulls":3},{"$f":"SUBTOTAL(109,ExhibitorsAndvendors[Estimated total])","v":{"v":0,"d":"£0.00"}},{"$f":"SUBTOTAL(109,ExhibitorsAndvendors[Actual total])","v":{"v":0,"d":"£0.00"}}]
["Sale of items label is in cell to the right.","Sale of items"]
["Enter Estimated and Actual number of items sold and item rates in table starting in cell to the right. Estimated and Actual income are auto-calculated.","Estimated","Actual","Type","Price","Estimated total","Actual total"]
[{"$nulls":3},"Items @",null,{"$f":"B26*E26","v":{"v":0,"d":"£0.00"}},{"$f":"C26*E26","v":{"v":0,"d":"£0.00"}}]
[{"$nulls":3},"Items @",null,{"$f":"B27*E27","v":{"v":0,"d":"£0.00"}},{"$f":"C27*E27","v":{"v":0,"d":"£0.00"}}]
[{"$nulls":3},"Items @",null,{"v":0,"d":"£0.00"},{"v":0,"d":"£0.00"}]
[{"$nulls":3},"Items @",null,{"v":0,"d":"£0.00"},{"v":0,"d":"£0.00"}]
[null," ",{"$nulls":3},{"$f":"SUBTOTAL(109,SaleOfItem[Estimated total])","v":{"v":0,"d":"£0.00"}},{"$f":"SUBTOTAL(109,SaleOfItem[Actual total])","v":{"v":0,"d":"£0.00"}}]

{"sheet":"Summary","index":3,"n_rows":9,"n_cols":4,"rows_kept":9,"merged":[[1,1,1,3],[2,2,2,3],[8,1,8,4],[9,1,9,3]]}
["Profit and loss summary and chart showing Total income and expenses are auto-updated in this worksheet. Helpful instructions on how to use this worksheet are in cells in this column. Arrow-down to get started."]
["Event name is auto-updated in cell to the right.",{"$f":"Expenses!B2","v":"Event budget for \nEvent name"}]
["Profit loss summary label is in cell C3. Next instruction is in cell A5.",null,"Profit loss summary"]
[]
["Total table starting in cell to the right is auto-updated. Next instruction is in cell A9.","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":1145,"d":"£1,145.00"}},{"$f":"Expenses!H5","v":{"v":395,"d":"£395.00"}}]
[null,"Total profit (or loss)",{"$f":"C6-C7","v":{"v":791,"d":"£791.00"}},{"$f":"D6-D7","v":{"v":1436,"d":"£1,436.00"}}]
["Clustered column chart showing Estimated and Actual total income and Total expenses comparison is in cell to the right.","Clustered column chart showing Estimated and Actual total income and Total expenses comparison is in this cell."]