{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["DASHBOARD","EXPENSES","INCOME"],"not_rendered":{"charts":3,"images":2},"read":"whole","date_system":"1900"}

{"sheet":"DASHBOARD","index":0,"n_rows":8,"n_cols":4,"rows_kept":8}
[]
[null,"Event Budget for [Event Name]"]
[null,"Profit - Loss Summary"]
[]
[null," ","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":850,"d":"$850.00"}},{"$f":"EXPENSES!H5","v":{"v":300,"d":"$300.00"}}]
[null,"TOTAL PROFIT",{"$f":"C6-C7","v":{"v":1086,"d":"$1,086.00"}},{"$f":"D6-D7","v":{"v":1531,"d":"$1,531.00"}}]

{"sheet":"EXPENSES","index":1,"n_rows":36,"n_cols":8,"rows_kept":36,"merged":[[12,1,12,3],[12,5,12,7],[21,1,21,3],[21,5,21,7],[27,5,27,7],[28,1,28,3],[36,1,36,3]]}
[]
[null,{"$f":"DASHBOARD!B2","v":"Event Budget for [Event Name]"}]
[null,"Expenses"]
[{"$nulls":5},"TOTAL EXPENSES","Estimated","Actual"]
[{"$nulls":6},{"$f":"SUBTOTAL(109,tblSite[Estimated],tblRefreshments[Estimated],tblPrograms[Estimated],tblDecorations[Estimated],tblPrizes[Estimated],tblPublicity[Estimated],tblMisc[Estimated])","v":{"v":850,"d":"$850.00"}},{"$f":"SUBTOTAL(109,tblSite[Actual],tblRefreshments[Actual],tblPrograms[Actual],tblDecorations[Actual],tblPrizes[Actual],tblPublicity[Actual],tblMisc[Actual])","v":{"v":300,"d":"$300.00"}}]
[]
[null,"Site","Estimated","Actual",null,"Refreshments","Estimated","Actual"]
[null,"Room and hall fees",{"v":500,"d":"$500.00"},null,null,"Food",{"v":150,"d":"$150.00"}]
[null,"Site staff",{"$nulls":3},"Drinks"]
[null,"Equipment",{"$nulls":3},"Linens"]
[null,"Tables and chairs",{"$nulls":3},"Staff and gratuities"]
[null,"Total",{"$f":"SUBTOTAL(109,tblSite[Estimated])","v":{"v":500,"d":"$500.00"}},{"$f":"SUBTOTAL(109,tblSite[Actual])","v":{"v":0,"d":"$0.00"}},null,"Total",{"$f":"SUBTOTAL(109,tblRefreshments[Estimated])","v":{"v":150,"d":"$150.00"}},{"$f":"SUBTOTAL(109,tblRefreshments[Actual])","v":{"v":0,"d":"$0.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"]
[null,"Lighting",{"$nulls":3},"Travel"]
[null,"Balloons",{"$nulls":3},"Hotel"]
[null,"Paper supplies",{"$nulls":3},"Other"]
[null,"Total",{"$f":"SUBTOTAL(109,tblDecorations[Estimated])","v":{"v":200,"d":"$200.00"}},{"$f":"SUBTOTAL(109,tblDecorations[Actual])","v":{"v":300,"d":"$300.00"}},null,"Total",{"$f":"SUBTOTAL(109,tblPrograms[Estimated])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,tblPrograms[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",{"$nulls":3},"Gifts"]
[null,"Postage",{"$nulls":3},"Total",{"$f":"SUBTOTAL(109,tblPrizes[Estimated])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,tblPrizes[Actual])","v":{"v":0,"d":"$0.00"}}]
[null,"Total",{"$f":"SUBTOTAL(109,tblPublicity[Estimated])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,tblPublicity[Actual])","v":{"v":0,"d":"$0.00"}}]
[]
[]
[null,"Miscellaneous","Estimated","Actual"]
[null,"Telephone"]
[null,"Transportation"]
[null,"Stationery supplies"]
[null,"Fax services"]
[null,"Total",{"$f":"SUBTOTAL(109,tblMisc[Estimated])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,tblMisc[Actual])","v":{"v":0,"d":"$0.00"}}]

{"sheet":"INCOME","index":2,"n_rows":33,"n_cols":7,"rows_kept":33}
[]
[null,{"$f":"DASHBOARD!B2","v":"Event Budget for [Event Name]"}]
[null,"Income"]
[{"$nulls":4},"TOTAL INCOME","Estimated","Actual"]
[{"$nulls":5},{"$f":"SUBTOTAL(109,tblAdmissions[[Estimated ]],tblAds[[Estimated ]],tblVendors[[Estimated ]],tblItems[[Estimated ]])","v":{"v":1936,"d":"$1,936.00"}},{"$f":"SUBTOTAL(109,tblAdmissions[[Actual ]],tblAds[[Actual ]],tblVendors[[Actual ]],tblItems[[Actual ]])","v":{"v":1831,"d":"$1,831.00"}}]
[null,"Admissions"]
[null,"Estimated","Actual"," ","  ","Estimated ","Actual "]
[null,300,278,"Adults @",{"v":5,"d":"$5.00"},{"$f":"tblAdmissions[[#This Row],[  ]]*tblAdmissions[[#This Row],[Estimated]]","v":{"v":1500,"d":"$1,500.00"}},{"$f":"tblAdmissions[[#This Row],[  ]]*tblAdmissions[[#This Row],[Actual]]","v":{"v":1390,"d":"$1,390.00"}}]
[null,197,195,"Children @",{"v":2,"d":"$2.00"},{"$f":"tblAdmissions[[#This Row],[  ]]*tblAdmissions[[#This Row],[Estimated]]","v":{"v":394,"d":"$394.00"}},{"$f":"tblAdmissions[[#This Row],[  ]]*tblAdmissions[[#This Row],[Actual]]","v":{"v":390,"d":"$390.00"}}]
[null,42,51,"Other @",{"v":1,"d":"$1.00"},{"$f":"tblAdmissions[[#This Row],[  ]]*tblAdmissions[[#This Row],[Estimated]]","v":{"v":42,"d":"$42.00"}},{"$f":"tblAdmissions[[#This Row],[  ]]*tblAdmissions[[#This Row],[Actual]]","v":{"v":51,"d":"$51.00"}}]
[null,"Total",{"$nulls":3},{"$f":"SUBTOTAL(109,tblAdmissions[[Estimated ]])","v":{"v":1936,"d":"$1,936.00"}},{"$f":"SUBTOTAL(109,tblAdmissions[[Actual ]])","v":{"v":1831,"d":"$1,831.00"}}]
[]
[null,"Ads in program"]
[null,"Estimated","Actual"," ","  ","Estimated ","Actual "]
[{"$nulls":3},"Covers @",null,{"$f":"tblAds[[#This Row],[  ]]*tblAds[[#This Row],[Estimated]]","v":{"v":0,"d":"$0.00"}},{"$f":"tblAds[[#This Row],[  ]]*tblAds[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},"Half-pages @",null,{"$f":"tblAds[[#This Row],[  ]]*tblAds[[#This Row],[Estimated]]","v":{"v":0,"d":"$0.00"}},{"$f":"tblAds[[#This Row],[  ]]*tblAds[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},"Quarter-pages @",null,{"$f":"tblAds[[#This Row],[  ]]*tblAds[[#This Row],[Estimated]]","v":{"v":0,"d":"$0.00"}},{"$f":"tblAds[[#This Row],[  ]]*tblAds[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
[null,"Total",{"$nulls":3},{"$f":"SUBTOTAL(109,tblAds[[Estimated ]])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,tblAds[[Actual ]])","v":{"v":0,"d":"$0.00"}}]
[]
[null,"Exhibitors/vendors"]
[null,"Estimated","Actual"," ","  ","Estimated ","Actual "]
[{"$nulls":3},"Large booths @",null,{"$f":"tblVendors[[#This Row],[  ]]*tblVendors[[#This Row],[Estimated]]","v":{"v":0,"d":"$0.00"}},{"$f":"tblVendors[[#This Row],[  ]]*tblVendors[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},"Med. booths @",null,{"$f":"tblVendors[[#This Row],[  ]]*tblVendors[[#This Row],[Estimated]]","v":{"v":0,"d":"$0.00"}},{"$f":"tblVendors[[#This Row],[  ]]*tblVendors[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},"Small booths @",null,{"$f":"tblVendors[[#This Row],[  ]]*tblVendors[[#This Row],[Estimated]]","v":{"v":0,"d":"$0.00"}},{"$f":"tblVendors[[#This Row],[  ]]*tblVendors[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
[null,"Total",{"$nulls":3},{"$f":"SUBTOTAL(109,tblVendors[[Estimated ]])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,tblVendors[[Actual ]])","v":{"v":0,"d":"$0.00"}}]
[]
[null,"Sale of items"]
[null,"Estimated","Actual"," ","  ","Estimated ","Actual "]
[{"$nulls":3},"Items @",null,{"$f":"tblItems[[#This Row],[  ]]*tblItems[[#This Row],[Estimated]]","v":{"v":0,"d":"$0.00"}},{"$f":"tblItems[[#This Row],[  ]]*tblItems[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},"Items @",null,{"$f":"tblItems[[#This Row],[  ]]*tblItems[[#This Row],[Estimated]]","v":{"v":0,"d":"$0.00"}},{"$f":"tblItems[[#This Row],[  ]]*tblItems[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},"Items @",null,{"$f":"tblItems[[#This Row],[  ]]*tblItems[[#This Row],[Estimated]]","v":{"v":0,"d":"$0.00"}},{"$f":"tblItems[[#This Row],[  ]]*tblItems[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
[{"$nulls":3},"Items @",null,{"$f":"tblItems[[#This Row],[  ]]*tblItems[[#This Row],[Estimated]]","v":{"v":0,"d":"$0.00"}},{"$f":"tblItems[[#This Row],[  ]]*tblItems[[#This Row],[Actual]]","v":{"v":0,"d":"$0.00"}}]
[null,"Total",{"$nulls":3},{"$f":"SUBTOTAL(109,tblItems[[Estimated ]])","v":{"v":0,"d":"$0.00"}},{"$f":"SUBTOTAL(109,tblItems[[Actual ]])","v":{"v":0,"d":"$0.00"}}]