{"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":8,"n_cols":2,"rows_kept":8}
[null,"ABOUT THIS TEMPLATE"]
[null,"Use this Event budget workbook to track Expenses incurred on and Income earned from 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 and 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. 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":32,"n_cols":8,"rows_kept":32,"merged":[[0,1,0,4],[2,1,3,1]]}
["Enter Estimated and Actual expenses for each category in respective tables in this worksheet, and Event name in cell D1 to customise the title of this and other worksheets. Subtitle of this worksheet is in cell H1. Helpful instructions on how to use this worksheet are in cells in this column. Next instruction is in cell A3.","Event Budget for event name",{"$nulls":5},"EXPENSES"]
[]
["Total expenses label is in cell to the right, Estimated label in cell G3 and Actual in H3.","TOTAL EXPENSES",{"$nulls":4},"Estimated","Actual"]
["Total estimated expenses in cell G4 and Total actual expenses in H4 are auto-calculated. Next instruction is in cell A6.",{"$nulls":5},{"$f":"SUM(C11,C19,C25,C32,G11,G19,G24)","v":{"v":882,"d":"£882.00"}},{"$f":"SUM(D11,D19,D25,D32,H11,H19,H24)","v":{"v":333,"d":"£333.00"}}]
[]
["Enter Site expenses in table starting in cell to the right and Refreshments expenses in table starting in cell F6. Next instruction is in cell A13.","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},"Linen",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"}}]
[]
["Enter Decorations expenses in table starting in cell to the right and Program expenses in table starting in cell F13. Next instruction is in cell A21.","Decorations","Estimated","Actual",null,"Programme","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"}}]
[]
["Enter Publicity expenses in table starting in cell to the right and Prizes expenses in table starting in cell F21. Next instruction is in cell A27","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"}}]
[]
["Enter Miscellaneous expenses in table starting in cell to the right.","Miscellaneous","Estimated","Actual"]
[null,"Telephone number",null,{"v":13,"d":"£13.00"}]
[null,"Transport",{"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":29,"n_cols":7,"rows_kept":29,"merged":[[0,1,0,3],[2,1,3,1]]}
["Enter Estimated and Actual incomes from each category in respective tables in this worksheet. Title of this worksheet is auto-updated in cells to the right. Subtitle is in cell G1. Helpful instructions on how to use this worksheet are in cells in this column. Next instruction is in cell A3.",{"$f":"Expenses!B1","v":"Event Budget for event name"},{"$nulls":4},"INCOME"]
[]
["Total income label is in cell to the right, Estimated label in cell F3 and Actual in G3.","TOTAL INCOME",{"$nulls":3},"Estimated","Actual"]
["Total Estimated income is auto-calculated in cell F4 and Total actual income is in G4.",{"$nulls":4},{"$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"}}]
["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 A11.","Estimated no.","Actual no.","Type","Price","Estimated income","Actual income"]
[null,300,278,"Adults @",{"v":5,"d":"£5.00"},{"$f":"B7*E7","v":{"v":1500,"d":"£1,500.00"}},{"$f":"C7*E7","v":{"v":1390,"d":"£1,390.00"}}]
[null,197,195,"Children @",{"v":2,"d":"£2.00"},{"$f":"B8*E8","v":{"v":394,"d":"£394.00"}},{"$f":"C8*E8","v":{"v":390,"d":"£390.00"}}]
[null,42,51,"Other @",{"v":1,"d":"£1.00"},{"$f":"B9*E9","v":{"v":42,"d":"£42.00"}},{"$f":"C9*E9","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"}}]
["Ads in program label is in cell to the right.","ADS IN PROGRAM"]
["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 A17.","Estimated no.","Actual no.","Type","Price","Estimated income","Actual income"]
[null,12,null,"Covers @",null,{"$f":"B13*E13","v":{"v":0,"d":"£0.00"}},{"$f":"C13*E13","v":{"v":0,"d":"£0.00"}}]
[null,null,158,"Half-pages @",null,{"$f":"B14*E14","v":{"v":0,"d":"£0.00"}},{"$f":"C14*E14","v":{"v":0,"d":"£0.00"}}]
[null,4,null,"Quarter-pages @",null,{"$f":"B15*E15","v":{"v":0,"d":"£0.00"}},{"$f":"C15*E15","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"}}]
["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 A23.","Estimated no.","Actual no.","Type","Price","Estimated income","Actual income"]
[null,23,null,"Large booths @",null,{"$f":"B19*E19","v":{"v":0,"d":"£0.00"}},{"$f":"C19*E19","v":{"v":0,"d":"£0.00"}}]
[null,354,null,"Med. booths @",null,{"$f":"B20*E20","v":{"v":0,"d":"£0.00"}},{"$f":"C20*E20","v":{"v":0,"d":"£0.00"}}]
[null,56,null,"Small booths @",null,{"$f":"B21*E21","v":{"v":0,"d":"£0.00"}},{"$f":"C21*E21","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"}}]
["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 no.","Actual no.","Type","Price","Estimated income","Actual income"]
[{"$nulls":3},"Items @",null,{"$f":"B25*E25","v":{"v":0,"d":"£0.00"}},{"$f":"C25*E25","v":{"v":0,"d":"£0.00"}}]
[null,123,null,"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"}}]
[null,13,null,"Items @",null,{"$f":"B28*E28","v":{"v":0,"d":"£0.00"}},{"$f":"C28*E28","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":8,"n_cols":7,"rows_kept":8,"merged":[[0,1,0,3],[2,4,11,6]]}
["Profit and loss summary and chart showing Total income and expenses are auto-updated in this worksheet. Title of this worksheet is auto-updated in cells to the right. Subtitle is in cells G1 and G2. Helpful instructions on how to use this worksheet are in cells in this column. Next instruction is in cell A3.",{"$f":"Expenses!B1","v":"Event Budget for event name"},{"$nulls":4},"PROFIT "]
[{"$nulls":6},"Loss summary"]
["Bar chart comparing Estimated income and expenses and Actual income and expenses is in cell E3.",{"$nulls":3},"Bar chart showing Estimated income and expenses and Actual income and expenses comparison is in this cell."]
["Summary table starting in cell to the right is auto-updated. Next instruction is in cell A8."," Total","Estimated","Actual"]
[null,"Total income",{"$f":"Income!F4","v":{"v":1936,"d":"£1,936.00"}},{"$f":"Income!G4","v":{"v":1831,"d":"£1,831.00"}}]
[null,"Total expenses",{"$f":"Expenses!G4","v":{"v":882,"d":"£882.00"}},{"$f":"Expenses!H4","v":{"v":333,"d":"£333.00"}}]
[]
["Total profit or loss estimated is auto-calculated in cell C8 and Total profit or actual loss is in cell D8.","Total profit              (or loss)",{"$f":"C5-C6","v":{"v":1054,"d":"£1,054.00"}},{"$f":"D5-D6","v":{"v":1498,"d":"£1,498.00"}}]