{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Expenses","Income","Profit & loss summary"],"not_rendered":{"charts":4,"images":6,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Expenses","index":0,"n_rows":31,"n_cols":9,"rows_kept":31,"merged":[[6,1,7,1]]}
[{"$nulls":8}," "]
[]
[null,"Product Launch Party"]
[null,"EXPENSES DETAILS"]
[]
[]
[null,"Total expenses","Estimated","Actual",null,"Program","Estimated","Actual"]
[null,null,{"$f":"SiteExpenses[[#Totals],[Estimated]]+DecorationsExpenses[[#Totals],[Estimated]]+PublicityExpenses[[#Totals],[Estimated]]+MiscellaneousExpenses[[#Totals],[Estimated]]+RefreshmentsExpenses[[#Totals],[Estimated]]+ProgramExpenses[[#Totals],[Estimated]]+PrizesExpenses[[#Totals],[Estimated]]","v":{"v":2090,"d":"$2,090.00"}},{"$f":"SiteExpenses[[#Totals],[Actual]]+DecorationsExpenses[[#Totals],[Actual]]+PublicityExpenses[[#Totals],[Actual]]+MiscellaneousExpenses[[#Totals],[Actual]]+RefreshmentsExpenses[[#Totals],[Actual]]+ProgramExpenses[[#Totals],[Actual]]+PrizesExpenses[[#Totals],[Actual]]","v":{"v":1640,"d":"$1,640.00"}},null,"Performers",{"v":750,"d":"$750.00"},{"v":700,"d":"$700.00"}]
[{"$nulls":5},"Speakers",{"v":150,"d":"$150.00"},{"v":0,"d":"$0.00"}]
[{"$nulls":5},"Travel"]
[null,"Site","Estimated","Actual",null,"Hotel"]
[null,"Room and hall fees",{"v":500,"d":"$500.00"},{"v":450,"d":"$450.00"},null,"Other"]
[null,"Site staff",{"$nulls":3},"Total",{"$f":"SUBTOTAL(109,ProgramExpenses[Estimated])","v":{"v":900,"d":"$900.00"}},{"$f":"SUBTOTAL(109,ProgramExpenses[Actual])","v":{"v":700,"d":"$700.00"}}]
[null,"Equipment"]
[null,"Tables and chairs",{"$nulls":3},"Publicity","Estimated","Actual"]
[null,"Total",{"$f":"SUBTOTAL(109,SiteExpenses[Estimated])","v":{"v":500,"d":"$500.00"}},{"$f":"SUBTOTAL(109,SiteExpenses[Actual])","v":{"v":450,"d":"$450.00"}},null,"Graphics work"]
[{"$nulls":5},"Photocopying / Printing",{"v":20,"d":"$20.00"},{"v":20,"d":"$20.00"}]
[null,"Decorations","Estimated","Actual",null,"Postage"]
[null,"Flowers",{"v":200,"d":"$200.00"},{"v":100,"d":"$100.00"},null,"Total",{"$f":"SUBTOTAL(109,PublicityExpenses[Estimated])","v":{"v":20,"d":"$20.00"}},{"$f":"SUBTOTAL(109,PublicityExpenses[Actual])","v":{"v":20,"d":"$20.00"}}]
[null,"Candles"]
[null,"Lighting",{"$nulls":3},"Prizes","Estimated","Actual"]
[null,"Balloons",{"$nulls":3},"Ribbons / Trophies"]
[null,"Paper supplies",{"$nulls":3},"Gifts",{"v":100,"d":"$100.00"},{"v":100,"d":"$100.00"}]
[null,"Total",{"$f":"SUBTOTAL(109,DecorationsExpenses[Estimated])","v":{"v":200,"d":"$200.00"}},{"$f":"SUBTOTAL(109,DecorationsExpenses[Actual])","v":{"v":100,"d":"$100.00"}},null,"Total",{"$f":"SUBTOTAL(109,PrizesExpenses[Estimated])","v":{"v":100,"d":"$100.00"}},{"$f":"SUBTOTAL(109,PrizesExpenses[Actual])","v":{"v":100,"d":"$100.00"}}]
[]
[null,"Refreshments","Estimated","Actual",null,"Miscellaneous","Estimated","Actual"]
[null,"Food",{"$nulls":3},"Telephone",{"v":50,"d":"$50.00"},{"v":50,"d":"$50.00"}]
[null,"Drinks",{"v":220,"d":"$220.00"},{"v":120,"d":"$120.00"},null,"Transportation",{"v":20,"d":"$20.00"},{"v":20,"d":"$20.00"}]
[null,"Linens",{"v":80,"d":"$80.00"},{"v":80,"d":"$80.00"},null,"Stationery supplies"]
[null,"Staff and gratuities",{"$nulls":3},"Fax services"]
[null,"Total",{"$f":"SUBTOTAL(109,RefreshmentsExpenses[Estimated])","v":{"v":300,"d":"$300.00"}},{"$f":"SUBTOTAL(109,RefreshmentsExpenses[Actual])","v":{"v":200,"d":"$200.00"}},null,"Total",{"$f":"SUBTOTAL(109,MiscellaneousExpenses[Estimated])","v":{"v":70,"d":"$70.00"}},{"$f":"SUBTOTAL(109,MiscellaneousExpenses[Actual])","v":{"v":70,"d":"$70.00"}}]

{"sheet":"Income","index":1,"n_rows":37,"n_cols":8,"rows_kept":37,"merged":[[6,1,7,1],[9,1,9,6],[16,1,16,6],[23,1,23,6],[30,1,30,6]]}
[{"$nulls":7}," "]
[]
[null,{"$f":"Expenses!B3","v":"Product Launch Party"}]
[null,"INCOME DETAILS"]
[]
[]
[null,"Total income","Estimated","Actual"]
[null,null,{"$f":"SUM(Admissions[[#Totals],[Estimated income]],AdsInProgram[[#Totals],[Estimated income]],ExhibitorsAndVendors[[#Totals],[Estimated income]],SaleOfItems[[#Totals],[Estimated income]])","v":{"v":4450,"d":"$4,450.00"}},{"$f":"SUM(Admissions[[#Totals],[Actual income]],AdsInProgram[[#Totals],[Actual income]],ExhibitorsAndVendors[[#Totals],[Actual income]],SaleOfItems[[#Totals],[Actual income]])","v":{"v":4170,"d":"$4,170.00"}}]
[]
[null,"Admissions"]
[null,"Type","Estimated","Actual","Price","Estimated income","Actual income"]
[null,"Adults",30,25,{"v":20,"d":"$20.00"},{"$f":"C12*E12","v":{"v":600,"d":"$600.00"}},{"$f":"D12*E12","v":{"v":500,"d":"$500.00"}}]
[null,"Children",20,22,{"v":10,"d":"$10.00"},{"$f":"C13*E13","v":{"v":200,"d":"$200.00"}},{"$f":"D13*E13","v":{"v":220,"d":"$220.00"}}]
[null,"Other",10,10,{"v":10,"d":"$10.00"},{"$f":"C14*E14","v":{"v":100,"d":"$100.00"}},{"$f":"D14*E14","v":{"v":100,"d":"$100.00"}}]
[null,"Total",{"$f":"SUBTOTAL(109,Admissions[Estimated])","v":60},{"$f":"SUBTOTAL(109,Admissions[Actual])","v":57},null,{"$f":"SUBTOTAL(109,Admissions[Estimated income])","v":{"v":900,"d":"$900.00"}},{"$f":"SUBTOTAL(109,Admissions[Actual income])","v":{"v":820,"d":"$820.00"}}]
[]
[null,"Ads in program"]
[null,"Type","Estimated","Actual","Price","Estimated income","Actual income"]
[null,"Covers",2,4,{"v":50,"d":"$50.00"},{"$f":"C19*E19","v":{"v":100,"d":"$100.00"}},{"$f":"D19*E19","v":{"v":200,"d":"$200.00"}}]
[null,"Half-pages",2,2,{"v":30,"d":"$30.00"},{"$f":"C20*E20","v":{"v":60,"d":"$60.00"}},{"$f":"D20*E20","v":{"v":60,"d":"$60.00"}}]
[null,"Quarter-pages",2,2,{"v":20,"d":"$20.00"},{"$f":"C21*E21","v":{"v":40,"d":"$40.00"}},{"$f":"D21*E21","v":{"v":40,"d":"$40.00"}}]
[null,"Total",{"$f":"SUBTOTAL(109,AdsInProgram[Estimated])","v":6},{"$f":"SUBTOTAL(109,AdsInProgram[Actual])","v":8},null,{"$f":"SUBTOTAL(109,AdsInProgram[Estimated income])","v":{"v":200,"d":"$200.00"}},{"$f":"SUBTOTAL(109,AdsInProgram[Actual income])","v":{"v":300,"d":"$300.00"}}]
[]
[null,"Exhibitors / Vendors"]
[null,"Type","Estimated","Actual","Price","Estimated income","Actual income"]
[null,"Large booths",5,5,{"v":300,"d":"$300.00"},{"$f":"C26*E26","v":{"v":1500,"d":"$1,500.00"}},{"$f":"D26*E26","v":{"v":1500,"d":"$1,500.00"}}]
[null,"Med. booths",5,4,{"v":200,"d":"$200.00"},{"$f":"C27*E27","v":{"v":1000,"d":"$1,000.00"}},{"$f":"D27*E27","v":{"v":800,"d":"$800.00"}}]
[null,"Small booths",1,0,{"v":100,"d":"$100.00"},{"$f":"C28*E28","v":{"v":100,"d":"$100.00"}},{"$f":"D28*E28","v":{"v":0,"d":"$0.00"}}]
[null,"Total",{"$f":"SUBTOTAL(109,ExhibitorsAndVendors[Estimated])","v":11},{"$f":"SUBTOTAL(109,ExhibitorsAndVendors[Actual])","v":9},null,{"$f":"SUBTOTAL(109,ExhibitorsAndVendors[Estimated income])","v":{"v":2600,"d":"$2,600.00"}},{"$f":"SUBTOTAL(109,ExhibitorsAndVendors[Actual income])","v":{"v":2300,"d":"$2,300.00"}}]
[]
[null,"Sales of items"]
[null,"Type","Estimated","Actual","Price","Estimated income","Actual income"]
[null,"Item 1",2,2,{"v":150,"d":"$150.00"},{"$f":"C33*E33","v":{"v":300,"d":"$300.00"}},{"$f":"D33*E33","v":{"v":300,"d":"$300.00"}}]
[null,"Item 2",5,5,{"v":50,"d":"$50.00"},{"$f":"C34*E34","v":{"v":250,"d":"$250.00"}},{"$f":"D34*E34","v":{"v":250,"d":"$250.00"}}]
[null,"Item 3",5,5,{"v":20,"d":"$20.00"},{"$f":"C35*E35","v":{"v":100,"d":"$100.00"}},{"$f":"D35*E35","v":{"v":100,"d":"$100.00"}}]
[null,"Item 4",5,5,{"v":20,"d":"$20.00"},{"$f":"C36*E36","v":{"v":100,"d":"$100.00"}},{"$f":"D36*E36","v":{"v":100,"d":"$100.00"}}]
[null,"Total",{"$f":"SUBTOTAL(109,SaleOfItems[Estimated])","v":17},{"$f":"SUBTOTAL(109,SaleOfItems[Actual])","v":17},null,{"$f":"SUBTOTAL(109,SaleOfItems[Estimated income])","v":{"v":750,"d":"$750.00"}},{"$f":"SUBTOTAL(109,SaleOfItems[Actual income])","v":{"v":750,"d":"$750.00"}}]

{"sheet":"Profit & loss summary","index":2,"n_rows":29,"n_cols":16,"rows_kept":29,"merged":[[28,1,28,3],[28,4,28,6]]}
[{"$nulls":7}," "]
[]
[null,{"$f":"Expenses!B3","v":"Product Launch Party"}]
[null,"PROFIT + LOSS SUMMARY"]
[]
[]
[null,"Expenses summary","Estimated","Actual",null,"Actual expenses",{"$nulls":5},"Ranking","Expenses","Estimated","Actual","Ranking Value"]
[null,{"$f":"VLOOKUP(1,$L$8:$O$14,2,FALSE)","v":"Program"},{"$f":"VLOOKUP(1,$L$8:$O$14,3,FALSE)","v":{"v":900,"d":"$900.00"}},{"$f":"VLOOKUP(1,$L$8:$O$14,4,FALSE)","v":{"v":700,"d":"$700.00"}},{"$nulls":7},{"$f":"_xlfn.RANK.AVG(P8,$P$8:$P$14)","v":2},"Site",{"$f":"SiteExpenses[[#Totals],[Estimated]]","v":{"v":500,"d":"$500"}},{"$f":"SiteExpenses[[#Totals],[Actual]]","v":{"v":450,"d":"$450"}},{"$f":"O8+ROW(O8)/10000","v":450.0008}]
[null,{"$f":"VLOOKUP(2,$L$8:$O$14,2,FALSE)","v":"Site"},{"$f":"VLOOKUP(2,$L$8:$O$14,3,FALSE)","v":{"v":500,"d":"$500.00"}},{"$f":"VLOOKUP(2,$L$8:$O$14,4,FALSE)","v":{"v":450,"d":"$450.00"}},{"$nulls":7},5,"Decorations",{"$f":"DecorationsExpenses[[#Totals],[Estimated]]","v":{"v":200,"d":"$200"}},{"$f":"DecorationsExpenses[[#Totals],[Actual]]","v":{"v":100,"d":"$100"}},{"$f":"O9+ROW(O9)/10000","v":100.0009}]
[null,{"$f":"VLOOKUP(3,$L$8:$O$14,2,FALSE)","v":"Refreshments"},{"$f":"VLOOKUP(3,$L$8:$O$14,3,FALSE)","v":{"v":300,"d":"$300.00"}},{"$f":"VLOOKUP(3,$L$8:$O$14,4,FALSE)","v":{"v":200,"d":"$200.00"}},{"$nulls":7},3,"Refreshments",{"$f":"RefreshmentsExpenses[[#Totals],[Estimated]]","v":{"v":300,"d":"$300"}},{"$f":"RefreshmentsExpenses[[#Totals],[Actual]]","v":{"v":200,"d":"$200"}},{"v":200.001,"d":"200.0010"}]
[null,{"$f":"VLOOKUP(4,$L$8:$O$14,2,FALSE)","v":"Prizes"},{"$f":"VLOOKUP(4,$L$8:$O$14,3,FALSE)","v":{"v":100,"d":"$100.00"}},{"$f":"VLOOKUP(4,$L$8:$O$14,4,FALSE)","v":{"v":100,"d":"$100.00"}},{"$nulls":7},1,"Program",{"$f":"ProgramExpenses[[#Totals],[Estimated]]","v":{"v":900,"d":"$900"}},{"$f":"ProgramExpenses[[#Totals],[Actual]]","v":{"v":700,"d":"$700"}},700.0011]
[null,{"$f":"VLOOKUP(5,$L$8:$O$14,2,FALSE)","v":"Decorations"},{"$f":"VLOOKUP(5,$L$8:$O$14,3,FALSE)","v":{"v":200,"d":"$200.00"}},{"$f":"VLOOKUP(5,$L$8:$O$14,4,FALSE)","v":{"v":100,"d":"$100.00"}},{"$nulls":7},7,"Publicity",{"$f":"PublicityExpenses[[#Totals],[Estimated]]","v":{"v":20,"d":"$20"}},{"$f":"PublicityExpenses[[#Totals],[Actual]]","v":{"v":20,"d":"$20"}},20.0012]
[null,{"$f":"VLOOKUP(6,$L$8:$O$14,2,FALSE)","v":"Miscellaneous"},{"$f":"VLOOKUP(6,$L$8:$O$14,3,FALSE)","v":{"v":70,"d":"$70.00"}},{"$f":"VLOOKUP(6,$L$8:$O$14,4,FALSE)","v":{"v":70,"d":"$70.00"}},{"$nulls":7},4,"Prizes",{"$f":"PrizesExpenses[[#Totals],[Estimated]]","v":{"v":100,"d":"$100"}},{"$f":"PrizesExpenses[[#Totals],[Actual]]","v":{"v":100,"d":"$100"}},100.0013]
[null,{"$f":"VLOOKUP(7,$L$8:$O$14,2,FALSE)","v":"Publicity"},{"$f":"VLOOKUP(7,$L$8:$O$14,3,FALSE)","v":{"v":20,"d":"$20.00"}},{"$f":"VLOOKUP(7,$L$8:$O$14,4,FALSE)","v":{"v":20,"d":"$20.00"}},{"$nulls":7},6,"Miscellaneous",{"$f":"MiscellaneousExpenses[[#Totals],[Estimated]]","v":{"v":70,"d":"$70"}},{"$f":"MiscellaneousExpenses[[#Totals],[Actual]]","v":{"v":70,"d":"$70"}},70.0014]
[null,"Total",{"$f":"SUBTOTAL(109,ExpensesSummary[Estimated])","v":{"v":2090,"d":"$2,090.00"}},{"$f":"SUBTOTAL(109,ExpensesSummary[Actual])","v":{"v":1640,"d":"$1,640.00"}}]
[]
[null,"Income summary","Estimated","Actual",null,"Actual income",{"$nulls":5},"Ranking","Income","Estimated","Actual","Ranking Value"]
[null,{"$f":"VLOOKUP(1,$L$18:$O$21,2,FALSE)","v":"Exhibitors / Vendors"},{"$f":"VLOOKUP(1,$L$18:$O$21,3,FALSE)","v":{"v":2600,"d":"$2,600.00"}},{"$f":"VLOOKUP(1,$L$18:$O$21,4,FALSE)","v":{"v":2300,"d":"$2,300.00"}},{"$nulls":7},{"$f":"_xlfn.RANK.AVG(P18,$P$18:$P$21)","v":2},"Admissions",{"$f":"Admissions[[#Totals],[Estimated income]]","v":{"v":900,"d":"$900"}},{"$f":"Admissions[[#Totals],[Actual income]]","v":{"v":820,"d":"$820"}},{"$f":"O18+ROW(O18)/10000","v":820.0018}]
[null,{"$f":"VLOOKUP(2,$L$18:$O$21,2,FALSE)","v":"Admissions"},{"$f":"VLOOKUP(2,$L$18:$O$21,3,FALSE)","v":{"v":900,"d":"$900.00"}},{"$f":"VLOOKUP(2,$L$18:$O$21,4,FALSE)","v":{"v":820,"d":"$820.00"}},{"$nulls":7},{"$f":"_xlfn.RANK.AVG(P19,$P$18:$P$21)","v":4},"Ads in Program",{"$f":"AdsInProgram[[#Totals],[Estimated income]]","v":{"v":200,"d":"$200"}},{"$f":"AdsInProgram[[#Totals],[Actual income]]","v":{"v":300,"d":"$300"}},300.0019]
[null,"Sales of Items",{"$f":"VLOOKUP(3,$L$18:$O$21,3,FALSE)","v":{"v":750,"d":"$750.00"}},{"$f":"VLOOKUP(3,$L$18:$O$21,4,FALSE)","v":{"v":750,"d":"$750.00"}},{"$nulls":7},1,"Exhibitors / Vendors",{"$f":"ExhibitorsAndVendors[[#Totals],[Estimated income]]","v":{"v":2600,"d":"$2,600"}},{"$f":"ExhibitorsAndVendors[[#Totals],[Actual income]]","v":{"v":2300,"d":"$2,300"}},{"v":2300.002,"d":"2,300.0020"}]
[null,{"$f":"VLOOKUP(4,$L$18:$O$21,2,FALSE)","v":"Ads in Program"},{"$f":"VLOOKUP(4,$L$18:$O$21,3,FALSE)","v":{"v":200,"d":"$200.00"}},{"$f":"VLOOKUP(4,$L$18:$O$21,4,FALSE)","v":{"v":300,"d":"$300.00"}},{"$nulls":7},3,"Sales of Items",{"$f":"SaleOfItems[[#Totals],[Estimated income]]","v":{"v":750,"d":"$750"}},{"$f":"SaleOfItems[[#Totals],[Actual income]]","v":{"v":750,"d":"$750"}},750.0021]
[null,"Total",{"$f":"SUBTOTAL(109,IncomeSummary[Estimated])","v":{"v":4450,"d":"$4,450.00"}},{"$f":"SUBTOTAL(109,IncomeSummary[Actual])","v":{"v":4170,"d":"$4,170.00"}}]
[]
[null,"Profit & loss summary","Estimated","Actual"]
[null,"Total Income",{"$f":"IncomeSummary[[#Totals],[Estimated]]","v":{"v":4450,"d":"$4,450.00"}},{"$f":"IncomeSummary[[#Totals],[Actual]]","v":{"v":4170,"d":"$4,170.00"}}]
[null,"Total Expenses",{"$f":"ExpensesSummary[[#Totals],[Estimated]]","v":{"v":2090,"d":"$2,090.00"}},{"$f":"ExpensesSummary[[#Totals],[Actual]]","v":{"v":1640,"d":"$1,640.00"}}]
[null,"Profit or (Loss)",{"$f":"C25-C26","v":{"v":2360,"d":"$2,360.00"}},{"$f":"D25-D26","v":{"v":2530,"d":"$2,530.00"}}]
[]
[null,"Expenses to profit (loss) ratio",null,null,"Estimated vs actual costs"]