{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Uitgaven","Inkomsten","Overzicht winst- en verlies"],"not_rendered":{"charts":4,"images":6,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Uitgaven","index":0,"n_rows":31,"n_cols":9,"rows_kept":31,"merged":[[6,1,7,1]]}
[{"$nulls":8}," "]
[]
[null,"Productlanceringsfeest"]
[null,"GEGEVENS ONKOSTEN"]
[]
[]
[null,"Totale onkosten","Geschat","Werkelijk",null,"Programma","Geschat","Werkelijk"]
[null,null,{"$f":"SiteExpenses[[#Totals],[Geschat]]+DecorationsExpenses[[#Totals],[Geschat]]+PublicityExpenses[[#Totals],[Geschat]]+MiscellaneousExpenses[[#Totals],[Geschat]]+RefreshmentsExpenses[[#Totals],[Geschat]]+ProgramExpenses[[#Totals],[Geschat]]+PrizesExpenses[[#Totals],[Geschat]]","v":{"v":2090,"d":"€ 2,090.00"}},{"$f":"SiteExpenses[[#Totals],[Werkelijk]]+DecorationsExpenses[[#Totals],[Werkelijk]]+PublicityExpenses[[#Totals],[Werkelijk]]+MiscellaneousExpenses[[#Totals],[Werkelijk]]+RefreshmentsExpenses[[#Totals],[Werkelijk]]+ProgramExpenses[[#Totals],[Werkelijk]]+PrizesExpenses[[#Totals],[Werkelijk]]","v":{"v":1640,"d":"€ 1,640.00"}},null,"Artiesten",{"v":750,"d":"€ 750.00"},{"v":700,"d":"€ 700.00"}]
[{"$nulls":5},"Sprekers",{"v":150,"d":"€ 150.00"},{"v":0,"d":"€ 0.00"}]
[{"$nulls":5},"Reis"]
[null,"Locatie","Geschat","Werkelijk",null,"Hotel"]
[null,"Kamer- en zaalkosten",{"v":500,"d":"€ 500.00"},{"v":450,"d":"€ 450.00"},null,"Anders"]
[null,"Personeel op locatie",{"$nulls":3},"Totaal",{"$f":"SUBTOTAL(109,ProgramExpenses[Geschat])","v":{"v":900,"d":"€ 900.00"}},{"$f":"SUBTOTAL(109,ProgramExpenses[Werkelijk])","v":{"v":700,"d":"€ 700.00"}}]
[null,"Apparatuur"]
[null,"Tafels en stoelen",{"$nulls":3},"Publiciteit","Geschat","Werkelijk"]
[null,"Totaal",{"$f":"SUBTOTAL(109,SiteExpenses[Geschat])","v":{"v":500,"d":"€ 500.00"}},{"$f":"SUBTOTAL(109,SiteExpenses[Werkelijk])","v":{"v":450,"d":"€ 450.00"}},null,"Grafisch werk"]
[{"$nulls":5},"Kopiëren/drukken",{"v":20,"d":"€ 20.00"},{"v":20,"d":"€ 20.00"}]
[null,"Versieringen","Geschat","Werkelijk",null,"Porto"]
[null,"Bloemen",{"v":200,"d":"€ 200.00"},{"v":100,"d":"€ 100.00"},null,"Totaal",{"$f":"SUBTOTAL(109,PublicityExpenses[Geschat])","v":{"v":20,"d":"€ 20.00"}},{"$f":"SUBTOTAL(109,PublicityExpenses[Werkelijk])","v":{"v":20,"d":"€ 20.00"}}]
[null,"Kaarsen"]
[null,"Verlichting",{"$nulls":3},"Prijzen","Geschat","Werkelijk"]
[null,"Ballonnen",{"$nulls":3},"Linten/trofeeën"]
[null,"Papier",{"$nulls":3},"Geschenken",{"v":100,"d":"€ 100.00"},{"v":100,"d":"€ 100.00"}]
[null,"Totaal",{"$f":"SUBTOTAL(109,DecorationsExpenses[Geschat])","v":{"v":200,"d":"€ 200.00"}},{"$f":"SUBTOTAL(109,DecorationsExpenses[Werkelijk])","v":{"v":100,"d":"€ 100.00"}},null,"Totaal",{"$f":"SUBTOTAL(109,PrizesExpenses[Geschat])","v":{"v":100,"d":"€ 100.00"}},{"$f":"SUBTOTAL(109,PrizesExpenses[Werkelijk])","v":{"v":100,"d":"€ 100.00"}}]
[]
[null,"Hapjes en drankjes","Geschat","Werkelijk",null,"Diversen","Geschat","Werkelijk"]
[null,"Eten en drinken",{"$nulls":3},"Telefoon",{"v":50,"d":"€ 50.00"},{"v":50,"d":"€ 50.00"}]
[null,"Drinken",{"v":220,"d":"€ 220.00"},{"v":120,"d":"€ 120.00"},null,"Vervoer",{"v":20,"d":"€ 20.00"},{"v":20,"d":"€ 20.00"}]
[null,"Linnengoed",{"v":80,"d":"€ 80.00"},{"v":80,"d":"€ 80.00"},null,"Kantoorbenodigdheden"]
[null,"Personeel en fooien",{"$nulls":3},"Faxkosten"]
[null,"Totaal",{"$f":"SUBTOTAL(109,RefreshmentsExpenses[Geschat])","v":{"v":300,"d":"€ 300.00"}},{"$f":"SUBTOTAL(109,RefreshmentsExpenses[Werkelijk])","v":{"v":200,"d":"€ 200.00"}},null,"Totaal",{"$f":"SUBTOTAL(109,MiscellaneousExpenses[Geschat])","v":{"v":70,"d":"€ 70.00"}},{"$f":"SUBTOTAL(109,MiscellaneousExpenses[Werkelijk])","v":{"v":70,"d":"€ 70.00"}}]

{"sheet":"Inkomsten","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":"Uitgaven!B3","v":"Productlanceringsfeest"}]
[null,"GEGEVENS INKOMSTEN"]
[]
[]
[null,"Totale inkomsten","Geschat","Werkelijk"]
[null,null,{"$f":"SUM(Toegangsbewijzen[[#Totals],[Geschatte inkomsten]],Advertenties_in_programmaboekje[[#Totals],[Geschatte inkomsten]],ExhibitorsAndVendors[[#Totals],[Geschatte inkomsten]],Verkoop_van_artikelen[[#Totals],[Geschatte inkomsten]])","v":{"v":4450,"d":"€ 4,450.00"}},{"$f":"SUM(Toegangsbewijzen[[#Totals],[Werkelijke inkomsten]],Advertenties_in_programmaboekje[[#Totals],[Werkelijke inkomsten]],ExhibitorsAndVendors[[#Totals],[Werkelijke inkomsten]],Verkoop_van_artikelen[[#Totals],[Werkelijke inkomsten]])","v":{"v":4170,"d":"€ 4,170.00"}}]
[]
[null,"Toegangsbewijzen"]
[null,"Soort","Geschat","Werkelijk","Prijs","Geschatte inkomsten","Werkelijke inkomsten"]
[null,"Volwassenen",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,"Kinderen",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,"Overige",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,"Totaal",{"$f":"SUBTOTAL(109,Toegangsbewijzen[Geschat])","v":60},{"$f":"SUBTOTAL(109,Toegangsbewijzen[Werkelijk])","v":57},null,{"$f":"SUBTOTAL(109,Toegangsbewijzen[Geschatte inkomsten])","v":{"v":900,"d":"€ 900.00"}},{"$f":"SUBTOTAL(109,Toegangsbewijzen[Werkelijke inkomsten])","v":{"v":820,"d":"€ 820.00"}}]
[]
[null,"Advertenties in programmaboekje"]
[null,"Soort","Geschat","Werkelijk","Prijs","Geschatte inkomsten","Werkelijke inkomsten"]
[null,"Omslagen",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,"Halve pagina's",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,"Kwart pagina's",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,"Totaal",{"$f":"SUBTOTAL(109,Advertenties_in_programmaboekje[Geschat])","v":6},{"$f":"SUBTOTAL(109,Advertenties_in_programmaboekje[Werkelijk])","v":8},null,{"$f":"SUBTOTAL(109,Advertenties_in_programmaboekje[Geschatte inkomsten])","v":{"v":200,"d":"€ 200.00"}},{"$f":"SUBTOTAL(109,Advertenties_in_programmaboekje[Werkelijke inkomsten])","v":{"v":300,"d":"€ 300.00"}}]
[]
[null,"Exposanten/verkopers"]
[null,"Soort","Geschat","Werkelijk","Prijs","Geschatte inkomsten","Werkelijke inkomsten"]
[null,"Grote stands",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,"Middelgrote stands",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,"Kleine stands",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,"Totaal",{"$f":"SUBTOTAL(109,ExhibitorsAndVendors[Geschat])","v":11},{"$f":"SUBTOTAL(109,ExhibitorsAndVendors[Werkelijk])","v":9},null,{"$f":"SUBTOTAL(109,ExhibitorsAndVendors[Geschatte inkomsten])","v":{"v":2600,"d":"€ 2,600.00"}},{"$f":"SUBTOTAL(109,ExhibitorsAndVendors[Werkelijke inkomsten])","v":{"v":2300,"d":"€ 2,300.00"}}]
[]
[null,"Verkoop van artikelen"]
[null,"Soort","Geschat","Werkelijk","Prijs","Geschatte inkomsten","Werkelijke inkomsten"]
[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,"Artikel 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,"Artikel 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,"Artikel 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,"Totaal",{"$f":"SUBTOTAL(109,Verkoop_van_artikelen[Geschat])","v":17},{"$f":"SUBTOTAL(109,Verkoop_van_artikelen[Werkelijk])","v":17},null,{"$f":"SUBTOTAL(109,Verkoop_van_artikelen[Geschatte inkomsten])","v":{"v":750,"d":"€ 750.00"}},{"$f":"SUBTOTAL(109,Verkoop_van_artikelen[Werkelijke inkomsten])","v":{"v":750,"d":"€ 750.00"}}]

{"sheet":"Overzicht winst- en verlies","index":2,"n_rows":29,"n_cols":16,"rows_kept":29,"merged":[[28,1,28,3],[28,4,28,6]]}
[{"$nulls":7}," "]
[]
[null,{"$f":"Uitgaven!B3","v":"Productlanceringsfeest"}]
[null,"OVERZICHT WINST- EN VERLIES"]
[]
[]
[null,"Overzicht van uitgaven","Geschat","Werkelijk",null,"Werkelijke kosten",{"$nulls":5},"Rangorde","Onkosten","Geschat","Werkelijk","Rang"]
[null,{"$f":"VLOOKUP(1,$L$8:$O$14,2,FALSE)","v":"Programma"},{"$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},"Locatie",{"$f":"SiteExpenses[[#Totals],[Geschat]]","v":{"v":500,"d":"€ 500"}},{"$f":"SiteExpenses[[#Totals],[Werkelijk]]","v":{"v":450,"d":"€ 450"}},{"$f":"O8+ROW(O8)/10000","v":450.0008}]
[null,{"$f":"VLOOKUP(2,$L$8:$O$14,2,FALSE)","v":"Locatie"},{"$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,"Versieringen",{"$f":"DecorationsExpenses[[#Totals],[Geschat]]","v":{"v":200,"d":"€ 200"}},{"$f":"DecorationsExpenses[[#Totals],[Werkelijk]]","v":{"v":100,"d":"€ 100"}},{"$f":"O9+ROW(O9)/10000","v":100.0009}]
[null,{"$f":"VLOOKUP(3,$L$8:$O$14,2,FALSE)","v":"Hapjes en drankjes"},{"$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,"Hapjes en drankjes",{"$f":"RefreshmentsExpenses[[#Totals],[Geschat]]","v":{"v":300,"d":"€ 300"}},{"$f":"RefreshmentsExpenses[[#Totals],[Werkelijk]]","v":{"v":200,"d":"€ 200"}},{"v":200.001,"d":"200.0010"}]
[null,{"$f":"VLOOKUP(4,$L$8:$O$14,2,FALSE)","v":"Prijzen"},{"$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,"Programma",{"$f":"ProgramExpenses[[#Totals],[Geschat]]","v":{"v":900,"d":"€ 900"}},{"$f":"ProgramExpenses[[#Totals],[Werkelijk]]","v":{"v":700,"d":"€ 700"}},700.0011]
[null,{"$f":"VLOOKUP(5,$L$8:$O$14,2,FALSE)","v":"Versieringen"},{"$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,"Publiciteit",{"$f":"PublicityExpenses[[#Totals],[Geschat]]","v":{"v":20,"d":"€ 20"}},{"$f":"PublicityExpenses[[#Totals],[Werkelijk]]","v":{"v":20,"d":"€ 20"}},20.0012]
[null,{"$f":"VLOOKUP(6,$L$8:$O$14,2,FALSE)","v":"Diversen"},{"$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,"Prijzen",{"$f":"PrizesExpenses[[#Totals],[Geschat]]","v":{"v":100,"d":"€ 100"}},{"$f":"PrizesExpenses[[#Totals],[Werkelijk]]","v":{"v":100,"d":"€ 100"}},100.0013]
[null,{"$f":"VLOOKUP(7,$L$8:$O$14,2,FALSE)","v":"Publiciteit"},{"$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,"Diversen",{"$f":"MiscellaneousExpenses[[#Totals],[Geschat]]","v":{"v":70,"d":"€ 70"}},{"$f":"MiscellaneousExpenses[[#Totals],[Werkelijk]]","v":{"v":70,"d":"€ 70"}},70.0014]
[null,"Totaal",{"$f":"SUBTOTAL(109,Overzicht_van_uitgaven[Geschat])","v":{"v":2090,"d":"€ 2,090.00"}},{"$f":"SUBTOTAL(109,Overzicht_van_uitgaven[Werkelijk])","v":{"v":1640,"d":"€ 1,640.00"}}]
[]
[null,"Overzicht van inkomsten","Geschat","Werkelijk",null,"Werkelijke inkomsten",{"$nulls":5},"Rangorde","Inkomsten","Geschat","Werkelijk","Rang"]
[null,{"$f":"VLOOKUP(1,$L$18:$O$21,2,FALSE)","v":"Exposanten/verkopers"},{"$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},"Toegangsbewijzen",{"$f":"Toegangsbewijzen[[#Totals],[Geschatte inkomsten]]","v":{"v":900,"d":"€ 900"}},{"$f":"Toegangsbewijzen[[#Totals],[Werkelijke inkomsten]]","v":{"v":820,"d":"€ 820"}},{"$f":"O18+ROW(O18)/10000","v":820.0018}]
[null,{"$f":"VLOOKUP(2,$L$18:$O$21,2,FALSE)","v":"Toegangsbewijzen"},{"$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},"Advertenties in programmaboekje",{"$f":"Advertenties_in_programmaboekje[[#Totals],[Geschatte inkomsten]]","v":{"v":200,"d":"€ 200"}},{"$f":"Advertenties_in_programmaboekje[[#Totals],[Werkelijke inkomsten]]","v":{"v":300,"d":"€ 300"}},300.0019]
[null,"Verkoop van artikelen",{"$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,"Exposanten/verkopers",{"$f":"ExhibitorsAndVendors[[#Totals],[Geschatte inkomsten]]","v":{"v":2600,"d":"€ 2,600"}},{"$f":"ExhibitorsAndVendors[[#Totals],[Werkelijke inkomsten]]","v":{"v":2300,"d":"€ 2,300"}},{"v":2300.002,"d":"2,300.0020"}]
[null,{"$f":"VLOOKUP(4,$L$18:$O$21,2,FALSE)","v":"Advertenties in programmaboekje"},{"$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,"Verkoop van artikelen",{"$f":"Verkoop_van_artikelen[[#Totals],[Geschatte inkomsten]]","v":{"v":750,"d":"€ 750"}},{"$f":"Verkoop_van_artikelen[[#Totals],[Werkelijke inkomsten]]","v":{"v":750,"d":"€ 750"}},750.0021]
[null,"Totaal",{"$f":"SUBTOTAL(109,Overzicht_van_inkomsten[Geschat])","v":{"v":4450,"d":"€ 4,450.00"}},{"$f":"SUBTOTAL(109,Overzicht_van_inkomsten[Werkelijk])","v":{"v":4170,"d":"€ 4,170.00"}}]
[]
[null,"Overzicht winst- en verlies","Geschat","Werkelijk"]
[null,"Totale inkomsten",{"$f":"Overzicht_van_inkomsten[[#Totals],[Geschat]]","v":{"v":4450,"d":"€ 4,450.00"}},{"$f":"Overzicht_van_inkomsten[[#Totals],[Werkelijk]]","v":{"v":4170,"d":"€ 4,170.00"}}]
[null,"Totale onkosten",{"$f":"Overzicht_van_uitgaven[[#Totals],[Geschat]]","v":{"v":2090,"d":"€ 2,090.00"}},{"$f":"Overzicht_van_uitgaven[[#Totals],[Werkelijk]]","v":{"v":1640,"d":"€ 1,640.00"}}]
[null,"Winst (of verlies)",{"$f":"C25-C26","v":{"v":2360,"d":"€ 2,360.00"}},{"$f":"D25-D26","v":{"v":2530,"d":"€ 2,530.00"}}]
[]
[null,"Verhouding uitgaven/winst (verlies)",null,null,"Geplande versus werkelijke kosten"]