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

{"sheet":"Expenses","index":0,"n_rows":32,"n_cols":8,"rows_kept":32,"merged":[[0,1,0,3],[2,1,3,1]]}
[null,"Event Budget for [Event Name] ",{"$nulls":5},"EXPENSES"]
[]
[null,"TOTAL EXPENSES",{"$nulls":4},"Estimated","Actual"]
[{"$nulls":6},{"$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":302,"d":"$302.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,Table1[Estimated])","v":{"v":500,"d":"$500.00"}},{"$f":"SUBTOTAL(103,Table1[Actual])","v":{"v":0,"d":"$0.00"}},null,"Total",{"$f":"SUBTOTAL(109,Table3[Estimated])","v":{"v":20,"d":"$20.00"}},{"$f":"SUBTOTAL(103,Table3[Actual])","v":{"v":1,"d":"$1.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,Table4[Estimated])","v":{"v":200,"d":"$200.00"}},{"$f":"SUBTOTAL(109,Table4[Actual])","v":{"v":300,"d":"$300.00"}},null,"Total",{"$f":"SUBTOTAL(109,Table5[Estimated])","v":{"v":30,"d":"$30.00"}},{"$f":"SUBTOTAL(103,Table5[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,Table7[Estimated])","v":{"v":100,"d":"$100.00"}},{"$f":"SUBTOTAL(103,Table7[Actual])","v":{"v":0,"d":"$0.00"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Table6[Estimated])","v":{"v":20,"d":"$20.00"}},{"$f":"SUBTOTAL(103,Table6[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,Table8[Estimated])","v":{"v":12,"d":"$12.00"}},{"$f":"SUBTOTAL(103,Table8[Actual])","v":{"v":1,"d":"$1.00"}}]

{"sheet":"Income","index":1,"n_rows":33,"n_cols":7,"rows_kept":33,"merged":[[0,1,0,3],[2,1,3,1]]}
[null,"Event Budget for [Event Name] ",{"$nulls":4},"INCOME"]
[]
[null,"TOTAL EXPENSES",{"$nulls":3},"Estimated","Actual"]
[{"$nulls":5},{"$f":"SUM(C11,C19,C25,C32,G11,G19,G24)","v":{"v":1831,"d":"$1,831.00"}},{"$f":"SUM(D11,D19,D25,D32,H11,H19,H24)","v":{"v":0,"d":"$0.00"}}]
[]
[null,"ADMISSIONS"]
[null,"Estimated No.","Actual No.","Type","Price","Estimated Income","Actual Income"]
[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"},{"$f":"B10*E10","v":{"v":42,"d":"$42.00"}},{"$f":"C10*E10","v":{"v":51,"d":"$51.00"}}]
[null,"Total",{"$nulls":3},{"$f":"SUBTOTAL(109,Table9[Estimated Income])","v":{"v":1936,"d":"$1,936.00"}},{"$f":"SUBTOTAL(109,Table9[Actual Income])","v":{"v":1831,"d":"$1,831.00"}}]
[]
[null,"ADS IN PROGRAM"]
[null,"Estimated No.","Actual No.","Type","Price","Estimated Income","Actual Income"]
[null,12,null,"Covers @",null,{"$f":"B15*E15","v":{"v":0,"d":"$0.00"}},{"$f":"C15*E15","v":{"v":0,"d":"$0.00"}}]
[null,null,158,"Half-pages @",null,{"$f":"B16*E16","v":{"v":0,"d":"$0.00"}},{"$f":"C16*E16","v":{"v":0,"d":"$0.00"}}]
[null,4,null,"Quarter-pages @",null,{"$f":"B17*E17","v":{"v":0,"d":"$0.00"}},{"$f":"C17*E17","v":{"v":0,"d":"$0.00"}}]
[null,"Total",{"$nulls":3},{"$f":"SUBTOTAL(109,Table10[Estimated Income])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,Table10[Actual Income])","v":{"v":0,"d":"$0.00"}}]
[]
[null,"EXHIBITORS/VENDORS"]
[null,"Estimated No.","Actual No.","Type","Price","Estimated Income","Actual Income"]
[null,23,null,"Large booths @",null,{"$f":"B22*E22","v":{"v":0,"d":"$0.00"}},{"$f":"C22*E22","v":{"v":0,"d":"$0.00"}}]
[null,354,null,"Med. booths @",null,{"$f":"B23*E23","v":{"v":0,"d":"$0.00"}},{"$f":"C23*E23","v":{"v":0,"d":"$0.00"}}]
[null,56,null,"Small booths @",null,{"$f":"B24*E24","v":{"v":0,"d":"$0.00"}},{"$f":"C24*E24","v":{"v":0,"d":"$0.00"}}]
[null,"Total",{"$nulls":3},{"$f":"SUBTOTAL(109,Table11[Estimated Income])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,Table11[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":"B29*E29","v":{"v":0,"d":"$0.00"}},{"$f":"C29*E29","v":{"v":0,"d":"$0.00"}}]
[null,123,null,"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"}}]
[null,13,null,"Items @",null,{"$f":"B32*E32","v":{"v":0,"d":"$0.00"}},{"$f":"C32*E32","v":{"v":0,"d":"$0.00"}}]
[null,"Total",{"$nulls":3},{"$f":"SUBTOTAL(109,Table12[Estimated Income])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,Table12[Actual Income])","v":{"v":0,"d":"$0.00"}}]

{"sheet":"Profit - Loss Summary","index":2,"n_rows":9,"n_cols":7,"rows_kept":9,"merged":[[0,1,0,3]]}
[null,"Event Budget for [Event Name] ",{"$nulls":4},"PROFIT "]
[{"$nulls":6},"Loss Summary"]
[]
[]
[null,null,"Estimated","Actual"]
[null,"Total income",{"$f":"Income!F11","v":{"v":1936,"d":"$1,936.00"}},{"$f":"Income!F4","v":{"v":1831,"d":"$1,831.00"}}]
[null,"Total expenses",{"$f":"Expenses!G4","v":{"v":882,"d":"$882.00"}},{"$f":"Expenses!H4","v":{"v":302,"d":"$302.00"}}]
[]
[null,"Total profit              (or loss)",{"$f":"C6-C7","v":{"v":1054,"d":"$1,054.00"}},{"$f":"D6-D7","v":{"v":1529,"d":"$1,529.00"}}]