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

{"sheet":"Expenses","index":0,"n_rows":35,"n_cols":9,"rows_kept":35,"merged":[[0,6,0,8],[1,6,1,7],[2,1,2,8],[3,7,3,8]]}
[]
[]
[null,"Event Budget for \n[Event Name]"]
[{"$nulls":7}," Expenses"]
[]
[{"$nulls":7},"Estimated","Actual"]
[null,null,"Total Expenses",{"$nulls":4},{"$f":"SUM(D14,D22,D28,D35,H14,H22,H27)","v":{"v":1145,"d":"$1,145.00"}},{"$f":"SUM(E14,E22,E28,E35,I14,I22,I27)","v":{"v":395,"d":"$395.00"}}]
[]
[null,null,"Site","Estimated","Actual",null,"Refreshments","Estimated","Actual"]
[null,null,"Room and hall fees",{"v":500,"d":"$500.00"},{"v":250,"d":"$250.00"},null,"Food"]
[null,null,"Site staff",{"v":400,"d":"$400.00"},{"v":50,"d":"$50.00"},null,"Drinks"]
[null,null,"Equipment",{"$nulls":3},"Linens"]
[null,null,"Tables and chairs",{"$nulls":3},"Staff and gratuities"]
[null,null,"Total",{"$f":"SUBTOTAL(109,Table1[Estimated])","v":{"v":900,"d":"$900.00"}},{"$f":"SUBTOTAL(109,Table1[Actual])","v":{"v":300,"d":"$300.00"}},null,"Total",{"$f":"SUBTOTAL(109,Table5[Estimated])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,Table5[Actual])","v":{"v":0,"d":"$0.00"}}]
[]
[null,null,"Decorations","Estimated","Actual",null,"Program","Estimated","Actual"]
[null,null,"Flowers",{"v":200,"d":"$200.00"},{"v":50,"d":"$50.00"},null,"Performers"]
[null,null,"Candles",{"$nulls":3},"Speakers"]
[null,null,"Lighting",{"$nulls":3},"Travel"]
[null,null,"Balloons",{"$nulls":3},"Hotel"]
[null,null,"Paper supplies",{"$nulls":3},"Other"]
[null,null,"Total",{"$f":"SUBTOTAL(109,Table2[Estimated])","v":{"v":200,"d":"$200.00"}},{"$f":"SUBTOTAL(109,Table2[Actual])","v":{"v":50,"d":"$50.00"}},null,"Total",{"$f":"SUBTOTAL(109,Table6[Estimated])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,Table6[Actual])","v":{"v":0,"d":"$0.00"}}]
[]
[null,null,"Publicity","Estimated","Actual",null,"Prizes","Estimated","Actual"]
[null,null,"Graphics work",{"v":45,"d":"$45.00"},{"v":45,"d":"$45.00"},null,"Ribbons/Plaques/Trophies"]
[null,null,"Photocopying/Printing",{"$nulls":3},"Gifts"]
[null,null,"Postage",{"$nulls":3},"Total",{"$f":"SUBTOTAL(109,Table7[Estimated])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,Table7[Actual])","v":{"v":0,"d":"$0.00"}}]
[null,null,"Total",{"$f":"SUBTOTAL(109,Table3[Estimated])","v":{"v":45,"d":"$45.00"}},{"$f":"SUBTOTAL(109,Table3[Actual])","v":{"v":45,"d":"$45.00"}}]
[]
[null,null,"Miscellaneous","Estimated","Actual"]
[null,null,"Telephone"]
[null,null,"Transportation"]
[null,null,"Stationery supplies"]
[null,null,"Fax services"]
[null,null,"Total",{"$f":"SUBTOTAL(109,Table4[Estimated])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,Table4[Actual])","v":{"v":0,"d":"$0.00"}}]

{"sheet":"Income","index":1,"n_rows":36,"n_cols":7,"rows_kept":36,"merged":[[2,1,2,6],[3,5,3,6],[14,1,14,6],[21,1,21,6],[28,1,28,6]]}
[]
[]
[null,"Event Budget for \n[Event Name]"]
[{"$nulls":5}," Income"]
[]
[{"$nulls":5},"Estimated","Actual"]
[null,"Total Income",{"$nulls":3},{"$f":"SUM(F14,F21,F28,F36)","v":{"v":1936,"d":"$1,936.00"}},{"$f":"SUM(G14,G21,G28,G36)","v":{"v":1831,"d":"$1,831.00"}}]
[]
[null,"Admissions"]
[null,"Estimated","Actual",null,null,"Estimated","Actual"]
[null,300,278,"Adults @",{"v":5,"d":"$5.00"},{"$f":"B11*E11","v":{"v":1500,"d":"$1,500.00"}},{"$f":"C11*E11","v":{"v":1390,"d":"$1,390.00"}}]
[null,197,195,"Children @",{"v":2,"d":"$2.00"},{"$f":"B12*E12","v":{"v":394,"d":"$394.00"}},{"$f":"C12*E12","v":{"v":390,"d":"$390.00"}}]
[null,42,51,"Other @",{"v":1,"d":"$1.00"},{"$f":"B13*E13","v":{"v":42,"d":"$42.00"}},{"$f":"C13*E13","v":{"v":51,"d":"$51.00"}}]
[{"$nulls":5},{"$f":"SUM(F11:F13)","v":{"v":1936,"d":"$1,936.00"}},{"$f":"SUM(G11:G13)","v":{"v":1831,"d":"$1,831.00"}}]
[]
[null,"Ads in program"]
[null,"Estimated","Actual",null,null,"Estimated","Actual"]
[{"$nulls":3},"Covers @",null,{"$f":"B18*E18","v":{"v":0,"d":"$0.00"}},{"$f":"C18*E18","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},"Half-pages @",null,{"$f":"B19*E19","v":{"v":0,"d":"$0.00"}},{"$f":"C19*E19","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},"Quarter-pages @",null,{"$f":"B20*E20","v":{"v":0,"d":"$0.00"}},{"$f":"C20*E20","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":5},{"$f":"SUM(F18:F20)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(G18:G20)","v":{"v":0,"d":"$0.00"}}]
[]
[null,"Exhibitors/vendors"]
[null,"Estimated","Actual",null,null,"Estimated","Actual"]
[{"$nulls":3},"Large booths @",null,{"$f":"B25*E25","v":{"v":0,"d":"$0.00"}},{"$f":"C25*E25","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},"Med. booths @",null,{"$f":"B26*E26","v":{"v":0,"d":"$0.00"}},{"$f":"C26*E26","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},"Small booths @",null,{"$f":"B27*E27","v":{"v":0,"d":"$0.00"}},{"$f":"C27*E27","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":5},{"$f":"SUM(F25:F27)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(G25:G27)","v":{"v":0,"d":"$0.00"}}]
[]
[null,"Sale of items"]
[null,"Estimated","Actual",null,null,"Estimated","Actual"]
[{"$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"}}]
[{"$nulls":3},"Items @",null,{"$f":"B34*E34","v":{"v":0,"d":"$0.00"}},{"$f":"C34*E34","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},"Items @",null,{"$f":"B35*E35","v":{"v":0,"d":"$0.00"}},{"$f":"C35*E35","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":5},{"$f":"SUM(F32:F35)","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(G32:G35)","v":{"v":0,"d":"$0.00"}}]

{"sheet":"Summary","index":2,"n_rows":9,"n_cols":7,"rows_kept":9,"merged":[[2,1,2,6],[3,5,3,6]]}
[]
[]
[null,"Event Budget for \n[Event Name]"]
[{"$nulls":5},"Profit-Loss Summary"]
[]
[{"$nulls":5},"Estimated","Actual"]
[null,"Total income",{"$nulls":3},{"$f":"Income!F7","v":{"v":1936,"d":"$1,936.00"}},{"$f":"Income!G7","v":{"v":1831,"d":"$1,831.00"}}]
[null,"Total expenses",{"$nulls":3},{"$f":"Expenses!H7","v":{"v":1145,"d":"$1,145.00"}},{"$f":"Expenses!I7","v":{"v":395,"d":"$395.00"}}]
[null,"Total profit (or loss)",{"$nulls":3},{"$f":"F7-F8","v":{"v":791,"d":"$791.00"}},{"$f":"G7-G8","v":{"v":1436,"d":"$1,436.00"}}]