{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Event Budget Template"],"read":"whole","date_system":"1900"}

{"sheet":"Event Budget Template","index":0,"n_rows":64,"n_cols":13,"rows_kept":64,"merged":[[3,0,3,2],[3,3,3,9]]}
[]
[]
[]
["Budget Summary",null,null,"Expenses and Income Summary"]
[null,"Total Expenses",{"$nulls":3},"Expenses",null,"Income Summary"]
[null,{"$f":"F13","v":{"v":3875,"d":"$3,875.00"}},null,null,"Venue",{"v":650,"d":"$650"},null,{"v":650,"d":"$650"}]
[null,"Total Actual Income",null,null,"Decorations",{"v":500,"d":"$500"},null,{"v":500,"d":"$500"}]
[null,{"$f":"H13","v":{"v":3875,"d":"$3,875.00"}},null,null,"Publicity",{"v":1350,"d":"$1,350"},null,{"v":1350,"d":"$1,350"}]
[null,"Balance",null,null,"Refreshments",{"v":500,"d":"$500"},null,{"v":500,"d":"$500"}]
[null,{"$f":"B8-B6","v":{"v":0,"d":"$0.00"}},null,null,"Program",{"v":675,"d":"$675"},null,{"v":675,"d":"$675"}]
[{"$nulls":4},"Prizes",{"v":200,"d":"$200"},null,{"v":200,"d":"$200"}]
[{"$nulls":4},"Miscellaneous",{"v":0,"d":"$0"},null,{"v":0,"d":"$0"}]
[{"$nulls":4},"Total",{"$f":"SUM(F6:F12)","v":{"v":3875,"d":"$3,875"}},"Total",{"$f":"SUM(H6:H12)","v":{"v":3875,"d":"$3,875"}}]
[]
[]
[]
["EXPENSES",{"$nulls":9},"INCOME"]
["Item","Assigned to","Status","Due Date","$ Each","Quantity","Estimated Budget","Actual Budget",null,null,"Budget Description","Estimated Budget","Actual Budget"]
["VENUE",{"$nulls":9},"Existing Budget"]
["Venue rental fee",{"$nulls":6},{"$f":"Table1[[#This Row],[Quantity]]*Table1[[#This Row],[$ Each]]","v":0},null,null,"Sponsor 1"]
["Venue staff fee",{"$nulls":6},{"$f":"Table1[[#This Row],[Quantity]]*Table1[[#This Row],[$ Each]]","v":0},null,null,"Sponsor 2"]
["Equipment fee ",{"$nulls":6},{"$f":"Table1[[#This Row],[Quantity]]*Table1[[#This Row],[$ Each]]","v":0},null,null,"Admissions"]
["Tables and chairs",{"$nulls":6},{"$f":"Table1[[#This Row],[Quantity]]*Table1[[#This Row],[$ Each]]","v":0},null,null,"Total"]
["Total",{"$nulls":6},{"$f":"SUM(H20:H23)","v":0}]
[{"$nulls":10},"TOTAL EXPENSES"]
["DECORATIONS"]
["Flowers",{"$nulls":6},{"$f":"Table1[[#This Row],[Quantity]]*Table1[[#This Row],[$ Each]]","v":0}]
["Candles",{"$nulls":6},{"$f":"Table1[[#This Row],[Quantity]]*Table1[[#This Row],[$ Each]]","v":0}]
["Lighting",{"$nulls":6},{"$f":"Table1[[#This Row],[Quantity]]*Table1[[#This Row],[$ Each]]","v":0}]
["Balloons",{"$nulls":6},{"$f":"Table1[[#This Row],[Quantity]]*Table1[[#This Row],[$ Each]]","v":0}]
["Paper supplies",{"$nulls":6},{"$f":"Table1[[#This Row],[Quantity]]*Table1[[#This Row],[$ Each]]","v":0}]
["Total",{"$nulls":6},{"$f":"SUM(H27:H31)","v":0}]
[]
["PUBLICITY"]
["Graphics work",{"$nulls":6},{"$f":"Table1[[#This Row],[Quantity]]*Table1[[#This Row],[$ Each]]","v":0}]
["Photocopying/ Printing",{"$nulls":6},{"$f":"Table1[[#This Row],[Quantity]]*Table1[[#This Row],[$ Each]]","v":0}]
["Postage",{"$nulls":6},{"$f":"Table1[[#This Row],[Quantity]]*Table1[[#This Row],[$ Each]]","v":0}]
["Total",{"$nulls":6},{"$f":"SUM(H35:H37)","v":0}]
[]
["REFRESHMENTS"]
["Food",{"$nulls":6},{"$f":"Table1[[#This Row],[Quantity]]*Table1[[#This Row],[$ Each]]","v":0}]
["Drinks",{"$nulls":6},{"$f":"Table1[[#This Row],[Quantity]]*Table1[[#This Row],[$ Each]]","v":0}]
["Total",{"$nulls":6},{"$f":"SUM(H41:H42)","v":0}]
[]
["PROGRAM"]
["Performers",{"$nulls":6},{"$f":"Table1[[#This Row],[Quantity]]*Table1[[#This Row],[$ Each]]","v":0}]
["Filming",{"$nulls":6},{"$f":"Table1[[#This Row],[Quantity]]*Table1[[#This Row],[$ Each]]","v":0}]
["Photographers",{"$nulls":6},{"$f":"Table1[[#This Row],[Quantity]]*Table1[[#This Row],[$ Each]]","v":0}]
["Other",{"$nulls":6},{"$f":"Table1[[#This Row],[Quantity]]*Table1[[#This Row],[$ Each]]","v":0}]
["Total",{"$nulls":6},{"$f":"SUM(H46:H49)","v":0}]
[]
["PRIZES"]
["Ribbons' Trophies",{"$nulls":6},{"$f":"Table1[[#This Row],[Quantity]]*Table1[[#This Row],[$ Each]]","v":0}]
["Gift bags",{"$nulls":6},{"$f":"Table1[[#This Row],[Quantity]]*Table1[[#This Row],[$ Each]]","v":0}]
["Total",{"$nulls":6},{"$f":"SUM(H53:H54)","v":0}]
[]
["MISCELLANEOUS"]
["Telephone",{"$nulls":6},{"$f":"Table1[[#This Row],[Quantity]]*Table1[[#This Row],[$ Each]]","v":0}]
["Transport",{"$nulls":6},{"$f":"Table1[[#This Row],[Quantity]]*Table1[[#This Row],[$ Each]]","v":0}]
["Stationery supplies",{"$nulls":6},{"$f":"Table1[[#This Row],[Quantity]]*Table1[[#This Row],[$ Each]]","v":0}]
["Fax services",{"$nulls":6},{"$f":"Table1[[#This Row],[Quantity]]*Table1[[#This Row],[$ Each]]","v":0}]
["Total",{"$nulls":6},{"$f":"SUM(H58:H61)","v":0}]
[]
["TOTAL EXPENSES",{"$nulls":6},{"$f":"SUM(H62+H55+H50+H43+H38+H32+H24)","v":0}]