{"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":7,"rows_kept":32,"merged":[[0,0,0,6]]}
["Event Budget for [Event Name]"]
["Expenses"]
[{"$nulls":5},"Estimated","Actual"]
["Total Expenses",{"$nulls":4},{"$f":"SUM(B11,B19,B25,B32,F11,F19,F24)","v":{"v":700,"d":"$700.00"}},{"$f":"SUM(C11,C19,C25,C32,G11,G19,G24)","v":{"v":300,"d":"$300.00"}}]
[]
["Site","Estimated","Actual",null,"Refreshments","Estimated","Actual"]
["Room and hall fees",{"v":500,"d":"$500.00"},null,null,"Food"]
["Site staff",{"$nulls":3},"Drinks"]
["Equipment",{"$nulls":3},"Linens"]
["Tables and chairs",{"$nulls":3},"Staff and gratuities"]
["Total",{"$f":"SUBTOTAL(109,[Estimated])","v":{"v":500,"d":"$500.00"}},{"$f":"SUBTOTAL(103,[Actual])","v":{"v":0,"d":"$0.00"}},null,"Total",{"$f":"SUBTOTAL(109,[Estimated])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(103,[Actual])","v":{"v":0,"d":"$0.00"}}]
[]
["Decorations","Estimated","Actual",null,"Program","Estimated","Actual"]
["Flowers",{"v":200,"d":"$200.00"},{"v":300,"d":"$300.00"},null,"Performers"]
["Candles",{"$nulls":3},"Speakers"]
["Lighting",{"$nulls":3},"Travel"]
["Balloons",{"$nulls":3},"Hotel"]
["Paper supplies",{"$nulls":3},"Other"]
["Total",{"$f":"SUBTOTAL(109,[Estimated])","v":{"v":200,"d":"$200.00"}},{"$f":"SUBTOTAL(109,[Actual])","v":{"v":300,"d":"$300.00"}},null,"Total",{"$f":"SUBTOTAL(109,[Estimated])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(103,[Actual])","v":{"v":0,"d":"$0.00"}}]
[]
["Publicity","Estimated","Actual",null,"Prizes","Estimated","Actual"]
["Graphics work",{"$nulls":3},"Ribbons/Plaques/Trophies"]
["Photocopying/Printing",{"$nulls":3},"Gifts"]
["Postage",{"$nulls":3},"Total",{"$f":"SUBTOTAL(109,[Estimated])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(103,[Actual])","v":{"v":0,"d":"$0.00"}}]
["Total",{"$f":"SUBTOTAL(109,[Estimated])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(103,[Actual])","v":{"v":0,"d":"$0.00"}}]
[]
["Miscellaneous","Estimated","Actual"]
["Telephone"]
["Transportation"]
["Stationery supplies"]
["Fax services"]
["Total",{"$f":"SUBTOTAL(109,[Estimated])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(103,[Actual])","v":{"v":0,"d":"$0.00"}}]

{"sheet":"Income","index":1,"n_rows":33,"n_cols":6,"rows_kept":33,"merged":[[0,0,0,5]]}
["Event Budget for [Event Name]"]
["Income"]
[{"$nulls":4},"Estimated","Actual"]
["Total income",{"$nulls":3},{"$f":"SUM(E11,E18,E25,E33)","v":{"v":1936,"d":"$1,936.00"}},{"$f":"SUM(F11,F18,F25,F33)","v":{"v":1831,"d":"$1,831.00"}}]
[]
["Admissions"]
["Estimated No.","Actual No.","Type","Price","Estimated Income","Actual Income"]
[300,278,"Adults @",{"v":5,"d":"$5.00"},{"$f":"A8*D8","v":{"v":1500,"d":"$1,500.00"}},{"$f":"B8*D8","v":{"v":1390,"d":"$1,390.00"}}]
[197,195,"Children @",{"v":2,"d":"$2.00"},{"$f":"A9*D9","v":{"v":394,"d":"$394.00"}},{"$f":"B9*D9","v":{"v":390,"d":"$390.00"}}]
[42,51,"Other @",{"v":1,"d":"$1.00"},{"$f":"A10*D10","v":{"v":42,"d":"$42.00"}},{"$f":"B10*D10","v":{"v":51,"d":"$51.00"}}]
["Total",{"$nulls":3},{"$f":"SUBTOTAL(109,[Estimated Income])","v":{"v":1936,"d":"$1,936.00"}},{"$f":"SUBTOTAL(109,[Actual Income])","v":{"v":1831,"d":"$1,831.00"}}]
[]
["Ads in program"]
["Estimated No.","Actual No.","Type","Price","Estimated Income","Actual Income"]
[null,null,"Covers @",null,{"$f":"A15*D15","v":{"v":0,"d":"$0.00"}},{"$f":"B15*D15","v":{"v":0,"d":"$0.00"}}]
[null,null,"Half-pages @",null,{"$f":"A16*D16","v":{"v":0,"d":"$0.00"}},{"$f":"B16*D16","v":{"v":0,"d":"$0.00"}}]
[null,null,"Quarter-pages @",null,{"$f":"A17*D17","v":{"v":0,"d":"$0.00"}},{"$f":"B17*D17","v":{"v":0,"d":"$0.00"}}]
["Total",{"$nulls":3},{"$f":"SUBTOTAL(109,[Estimated Income])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,[Actual Income])","v":{"v":0,"d":"$0.00"}}]
[]
["Exhibitors/vendors"]
["Estimated No.","Actual No.","Type","Price","Estimated Income","Actual Income"]
[null,null,"Large booths @",null,{"$f":"A22*D22","v":{"v":0,"d":"$0.00"}},{"$f":"B22*D22","v":{"v":0,"d":"$0.00"}}]
[null,null,"Med. booths @",null,{"$f":"A23*D23","v":{"v":0,"d":"$0.00"}},{"$f":"B23*D23","v":{"v":0,"d":"$0.00"}}]
[null,null,"Small booths @",null,{"$f":"A24*D24","v":{"v":0,"d":"$0.00"}},{"$f":"B24*D24","v":{"v":0,"d":"$0.00"}}]
["Total",{"$nulls":3},{"$f":"SUBTOTAL(109,[Estimated Income])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,[Actual Income])","v":{"v":0,"d":"$0.00"}}]
[]
["Sale of items"]
["Estimated No.","Actual No.","Type","Price","Estimated Income","Actual Income"]
[null,null,"Items @",null,{"$f":"A29*D29","v":{"v":0,"d":"$0.00"}},{"$f":"B29*D29","v":{"v":0,"d":"$0.00"}}]
[null,null,"Items @",null,{"$f":"A30*D30","v":{"v":0,"d":"$0.00"}},{"$f":"B30*D30","v":{"v":0,"d":"$0.00"}}]
[null,null,"Items @",null,{"$f":"A31*D31","v":{"v":0,"d":"$0.00"}},{"$f":"B31*D31","v":{"v":0,"d":"$0.00"}}]
[null,null,"Items @",null,{"$f":"A32*D32","v":{"v":0,"d":"$0.00"}},{"$f":"B32*D32","v":{"v":0,"d":"$0.00"}}]
["Total",{"$nulls":3},{"$f":"SUBTOTAL(109,[Estimated Income])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,[Actual Income])","v":{"v":0,"d":"$0.00"}}]

{"sheet":"Profit - Loss Summary","index":2,"n_rows":9,"n_cols":3,"rows_kept":9,"merged":[[0,0,0,6],[1,0,1,1]]}
["Event Budget for [Event Name]"]
["Profit - Loss Summary"]
[]
[]
[null,"Estimated","Actual"]
["Total income",{"$f":"Income!E4","v":{"v":1936,"d":"$1,936.00"}},{"$f":"Income!F4","v":{"v":1831,"d":"$1,831.00"}}]
["Total expenses",{"$f":"Expenses!F4","v":{"v":700,"d":"$700.00"}},{"$f":"Expenses!G4","v":{"v":300,"d":"$300.00"}}]
[]
["Total profit (or loss)",{"$f":"B6-B7","v":{"v":1236,"d":"$1,236.00"}},{"$f":"C6-C7","v":{"v":1531,"d":"$1,531.00"}}]