{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["Deelname weekend","Groepsindeling","Kamer bezetting"],"not_rendered":{"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"Deelname weekend","index":0,"n_rows":70,"n_cols":18,"rows_kept":70,"merged":[[42,1,42,5],[44,7,44,9],[45,7,45,9],[46,7,46,9],[47,7,47,9],[48,9,48,10],[49,9,49,13],[51,7,51,9],[54,8,54,12],[55,8,55,12],[56,8,56,12],[57,8,57,12],[58,8,58,12]]}
["Hotel Heikenberg","Gaat mee","Aantal","Kamer","Kind","Voorschot","Bonus","Betaald","Te Ontvangen","Niet mee","Cash",null,"Motoren","Auto","Kamer prijs","Nog te betalen","Gemeld","Afgemeld"]
["Hans Ophof","J",1,"EZ",null,{"v":50,"d":"€ 50.00"},null,{"v":205,"d":"€ 205.00"},{"$f":"IF(AND(B2=\"J\",((H2+F2)-(Deelnemers*$O2+E2*$M$45))>0),(Deelnemers*$O2+E2*$M$45),(Deelnemers-G2)*$O2-(H2+F2)+E2*$M$45)","v":0},{"$f":"IF(B2=\"N\",1,0)","v":0},null,{"$f":"COUNTIF(K2,\"cash\")*Deelnemers","v":0},1,null,{"$f":"IF(D2=$M$41,$M$43,IF(D2=$N$41,$N$43,IF(D2=$O$41,$O$43,IF(D2=$P$41,$P$43,IF(D2=$Q$41,$Q$43,0)))))","v":{"v":255,"d":"€ 255.00"}},{"$f":"IF(H2=\"\",I2,IF(H2+F2=(O2*C2),\"\",(O2*C2-H2-F2)))","v":""},null,"Jack Keijsers"]
["Eric & Wietske Kuipers","J",2,"DZ",null,{"v":100,"d":"€ 100.00"},null,{"v":340,"d":"€ 340.00"},0,{"$f":"IF(B3=\"N\",1,0)","v":0},null,{"$f":"COUNTIF(K3,\"cash\")*Deelnemers","v":0},1,1,{"v":220,"d":"€ 220.00"},"",null,"Richard Alsem"]
["Toon & Els Trouwen","J",2,"DZ",null,{"v":100,"d":"€ 100.00"},null,{"v":340,"d":"€ 340.00"},0,0,null,0,1,1,{"v":220,"d":"€ 220.00"},"",null,"Dick Willemsen"]
["Wan & Dian Merks","J",2,"DZ",null,{"v":100,"d":"€ 100.00"},null,{"v":340,"d":"€ 340.00"},0,{"$f":"IF(B5=\"N\",1,0)","v":0},null,{"$f":"COUNTIF(K5,\"cash\")*Deelnemers","v":0},1,1,{"v":220,"d":"€ 220.00"},"",null,"Rinus Willemsen"]
["Frans & Brigitte Smulders","J",2,"DZ",null,{"v":100,"d":"€ 100.00"},null,{"v":340,"d":"€ 340.00"},0,0,null,0,1,null,{"v":220,"d":"€ 220.00"},"",null,"Eric van Meensel"]
["Femke Smulders & Patrick van Lierop & Joep","J",2,"DZ",null,{"v":100,"d":"€ 100.00"},null,{"v":340,"d":"€ 340.00"},0,0,null,{"$f":"COUNTIF(K7,\"cash\")*Deelnemers","v":0},1,1,{"v":220,"d":"€ 220.00"},"",null,"Hans Adriaans"]
["Theo van den Broek","J",1,"DZ",null,{"v":50,"d":"€ 50.00"},null,{"v":170,"d":"€ 170.00"},0,{"$f":"IF(B8=\"N\",1,0)","v":0},null,{"$f":"COUNTIF(K8,\"cash\")*Deelnemers","v":0},1,null,{"v":220,"d":"€ 220.00"},"",null,"Jos Leuwerink"]
["Jean-Pierre van Daal","J",1,"DZ",null,{"v":50,"d":"€ 50.00"},null,{"v":170,"d":"€ 170.00"},0,0,null,0,1,null,{"v":220,"d":"€ 220.00"},"",null,"Carolien van den Biggelaar"]
["Erik Bekkers","J",1,"DZ",null,{"v":50,"d":"€ 50.00"},null,{"v":170,"d":"€ 170.00"},0,0,null,0,1,null,{"v":220,"d":"€ 220.00"},"",null,"Piet Hendrikx"]
["Peter & Jozee van Zeeland","J",2,"DZ",null,{"v":100,"d":"€ 100.00"},null,{"v":340,"d":"€ 340.00"},0,0,null,0,1,1,{"v":220,"d":"€ 220.00"},"",null,"Gilbert Claessen"]
["Ivo Treverlo","J",1,"DZ",null,{"v":50,"d":"€ 50.00"},null,{"v":170,"d":"€ 170.00"},0,0,null,0,1,null,{"v":220,"d":"€ 220.00"},""]
["Heinz Kessels","J",1,"EZ",null,{"v":50,"d":"€ 50.00"},null,{"v":205,"d":"€ 205.00"},0,0,null,0,1,null,{"v":255,"d":"€ 255.00"},""]
["Jos Soetens","J",1,"DZ",null,{"v":50,"d":"€ 50.00"},null,{"v":170,"d":"€ 170.00"},0,{"$f":"IF(B14=\"N\",1,0)","v":0},null,{"$f":"COUNTIF(K14,\"cash\")*Deelnemers","v":0},1,null,{"v":220,"d":"€ 220.00"},""]
["Dennis Soetens","J",1,"DZ",null,{"v":50,"d":"€ 50.00"},null,{"v":170,"d":"€ 170.00"},0,{"$f":"IF(B15=\"N\",1,0)","v":0},null,{"$f":"COUNTIF(K15,\"cash\")*Deelnemers","v":0},1,null,{"v":220,"d":"€ 220.00"},""]
["Wil & Nollie Langenberg","J",2,"DZ",null,{"v":100,"d":"€ 100.00"},null,{"v":340,"d":"€ 340.00"},0,0,null,0,1,null,{"v":220,"d":"€ 220.00"},""]
["Wlly & Marion Schuurmans","J",2,"DZ",null,{"v":100,"d":"€ 100.00"},null,{"v":340,"d":"€ 340.00"},0,0,null,0,1,null,{"v":220,"d":"€ 220.00"},""]
["Bram & Angelique van Abeelen","J",2,"App",2,{"v":100,"d":"€ 100.00"},null,{"v":530,"d":"€ 530.00"},0,0,null,0,1,null,{"v":210,"d":"€ 210.00"},{"v":-210,"d":"€ -210.00"}]
["Martien van Abeelen","J",1,"EZ",null,{"v":50,"d":"€ 50.00"},null,{"v":205,"d":"€ 205.00"},0,0,null,0,1,null,{"v":255,"d":"€ 255.00"},""]
["Thomas van Gerwen","J",1,"EZ",null,{"v":50,"d":"€ 50.00"},null,{"v":205,"d":"€ 205.00"},0,0,null,0,1,null,{"v":255,"d":"€ 255.00"},""]
["Jo Sieben","J",1,"DZ",null,{"v":50,"d":"€ 50.00"},null,{"v":170,"d":"€ 170.00"},0,0,null,0,1,null,{"v":220,"d":"€ 220.00"},""]
["Ronnie van der Heijden","J",1,"EZ",null,{"v":50,"d":"€ 50.00"},null,{"v":205,"d":"€ 205.00"},0,{"$f":"IF(B22=\"N\",1,0)","v":0},null,{"$f":"COUNTIF(K22,\"cash\")*Deelnemers","v":0},1,null,{"v":255,"d":"€ 255.00"},""]
["Marc Verbaten","J",1,"DZ",null,{"v":50,"d":"€ 50.00"},null,{"v":170,"d":"€ 170.00"},0,0,null,0,1,null,{"v":220,"d":"€ 220.00"},{"$f":"IF(H23=\"\",I23,IF(H23+F23=(O23*C23),\"\",(O23*C23-H23-F23)))","v":""}]
["Onno & Sandra Kruik-Geenen","J",2,"DZ",null,{"v":100,"d":"€ 100.00"},null,{"v":340,"d":"€ 340.00"},0,0,null,0,2,null,{"v":220,"d":"€ 220.00"},{"$f":"IF(H24=\"\",I24,IF(H24+F24=(O24*C24),\"\",(O24*C24-H24-F24)))","v":""}]
["Piet van Zeeland","J",1,"DZ",null,{"v":50,"d":"€ 50.00"},null,{"v":170,"d":"€ 170.00"},0,0,null,0,1,null,{"v":220,"d":"€ 220.00"},""]
["Gert-Jan Robeerst","J",1,"DZ",null,{"v":50,"d":"€ 50.00"},null,{"v":170,"d":"€ 170.00"},0,0,null,0,1,null,{"v":220,"d":"€ 220.00"},""]
["Wil van de Weiden","J",1,"EZ",{"$nulls":3},{"v":255,"d":"€ 255.00"},0,0,null,0,1,null,{"v":255,"d":"€ 255.00"},""]
[{"$nulls":8},0,0,null,0,null,null,0,0]
[{"$nulls":8},0,0,null,0,null,null,0,0]
[{"$nulls":8},0,0,null,{"$f":"COUNTIF(K30,\"cash\")*Deelnemers","v":0},null,null,0,0]
[{"$nulls":8},0,0,null,0,null,null,0,0]
[{"$nulls":8},0,{"$f":"IF(B32=\"N\",1,0)","v":0},null,{"$f":"COUNTIF(K32,\"cash\")*Deelnemers","v":0},null,null,0,0]
[{"$nulls":8},0,0,null,0,null,null,0,0]
[{"$nulls":8},0,0,null,0,null,null,0,0]
[{"$nulls":8},0,0,null,0,null,null,0,0]
[{"$nulls":8},0,0,null,0,null,null,0,0]
[{"$nulls":5},"Lege cellen"]
[{"$nulls":5},{"$f":"COUNTBLANK(Voorschot)","v":10},null,{"$f":"SUM(Betaald)/M43","v":{"v":29.863636363636363,"d":"30"}},{"$nulls":4},{"$f":"SUM(Motoren)","v":27},{"$f":"SUM(Auto)","v":5}]
[]
[]
[{"$nulls":12},"DZ","EZ","FZ","App","3BZ"]
[{"$nulls":12},{"$f":"COUNTIF(Kamer,M$41)","v":19},{"$f":"COUNTIF(Kamer,N$41)","v":6},{"$f":"COUNTIF(Kamer,O$41)","v":0},{"$f":"COUNTIF(Kamer,P$41)","v":1},{"$f":"COUNTIF(Kamer,Q$41)","v":0}]
["Datum:","18+19+20+21 mei 2023",{"$nulls":5},"Kosten per persoon:",{"$nulls":4},{"v":220,"d":"€ 220.00"},{"v":255,"d":"€ 255.00"},null,{"v":210,"d":"€ 210.00"}]
[]
[{"$nulls":7},"Kindertoeslag",{"$nulls":4},{"$f":"50%*P43","v":{"v":105,"d":"€ 105.00"}}]
["Ontvangen:",{"$f":"SUM(Betaald)+SUM(Voorschot)","v":{"v":8320,"d":"€ 8,320.00"}},{"$nulls":5},"Toeristenbelasting p.p.p.n.",{"$nulls":4},0]
["Nog te ontvangen cash:",{"$f":"J49","v":0},{"$nulls":5},"Aantal betaald totaal:"]
["Nog te ontvangen per bank:",{"$f":"SUM(Te_ontvangen)","v":0},{"$nulls":5},"Nog te betalen:",{"$nulls":4},{"$f":"SUM(Nog_te_betalen)","v":{"v":-210,"d":"€ -210.00"}}]
["Er gaan mee:",{"$f":"SUM(Deelnemers)","v":36},{"$f":"SUM(Kind)","v":2},{"$nulls":4},"Aantal betaald voorschot:",{"$nulls":4},{"$f":"SUM(Voorschot)/B51","v":35}]
["Zeker niet:",{"$f":"SUM(J2:J36)","v":0},{"$nulls":6},"Update:","2023-05-12"]
["Voorschot bedrag",{"v":50,"d":"€ 50.00"},"pp"]
["Aanbetaling 1:",0,{"$nulls":5},"Voor rekening Motocaths",{"$nulls":4},{"$f":"'Kamer bezetting'!H36-'Deelname weekend'!B46-SUM(B52:B53)","v":{"v":-8320,"d":"€ -8,320.00"}},"MBBQ"]
["Aanbetaling 2:",0,{"$nulls":10},{"$f":"'Kamer bezetting'!H35-'Deelname weekend'!B46-SUM(B52:B53)","v":{"v":-8320,"d":"€ -8,320.00"}},"ZBBQ"]
["Grote garage:",0]
["Garage box:",0,"pst",{"$nulls":4},"DZ","2 persoonskamer",{"$nulls":4},{"v":208,"d":"€ 208.00"},{"$f":"N55+(3*$B$57)","v":{"v":215.5,"d":"€ 215.50"}}]
["BBQ:",0,"pp",{"$nulls":4},"EZ","1 persoonskamer",{"$nulls":4},{"v":242,"d":"€ 242.00"},{"$f":"N56+(3*$B$57)","v":{"v":249.5,"d":"€ 249.50"}}]
["Kurtax:",{"v":2.5,"d":"€ 2.50"},"pp/pd",{"$nulls":4},"FZ","Familiekamer"]
[{"$nulls":7},"App","Appartement",{"$nulls":4},{"v":592,"d":"€ 592.00"},{"$f":"N58+(6*B57)","v":{"v":607,"d":"€ 607.00"}}]
["Mail 1 verzonden:",{"$nulls":6},"3BZ","3 persoonskamer"]
["Mail 2 verzonden:"]
[]
["Betalingsverzoek voorschot:"]
[]
[]
[]
[]
["Vrije plaatsen (U+Frü):",null,{"v":160,"d":"€ 160.00"}]
[">15 personen",0.5,{"$f":"C67*B68","v":{"v":80,"d":"€ 80.00"}}]
[">20 personen",1,{"$f":"C67*B69","v":{"v":160,"d":"€ 160.00"}}]
[">30 personen",1.5,{"$f":"C67*B70","v":{"v":240,"d":"€ 240.00"}}]

{"sheet":"Groepsindeling","index":1,"n_rows":51,"n_cols":14,"rows_kept":51,"merged":[[0,0,0,1],[0,2,0,3],[0,4,0,5],[0,6,0,7],[1,0,1,1],[1,2,1,3],[1,4,1,5],[1,6,1,7],[2,0,2,1],[2,2,2,3],[2,4,2,5],[2,6,2,7],[3,0,3,1],[3,2,3,3],[3,4,3,5],[3,6,3,7],[4,0,4,1],[4,2,4,3],[4,4,4,5],[4,6,4,7],[5,0,5,1],[5,2,5,3],[5,4,5,5],[5,6,5,7],[6,0,6,1],[6,2,6,3],[6,4,6,5],[6,6,6,7],[7,0,7,1],[7,2,7,3],[7,4,7,5],[7,6,7,7],[8,0,8,1],[8,2,8,3],[8,4,8,5],[8,6,8,7],[9,0,9,1],[9,2,9,3],[9,4,9,5],[9,6,9,7],[12,0,12,1],[12,2,12,3],[12,4,12,5],[13,0,13,1],[13,2,13,3],[13,4,13,5],[14,0,14,1],[14,2,14,3],[14,4,14,5],[15,0,15,1],[15,2,15,3],[15,4,15,5],[16,0,16,1],[16,2,16,3],[16,4,16,5],[17,0,17,1],[17,2,17,3],[17,4,17,5],[18,0,18,1],[18,2,18,3],[18,4,18,5],[19,0,19,1],[19,2,19,3],[19,4,19,5],[20,0,20,1],[20,2,20,3],[20,4,20,5],[21,0,21,1],[21,2,21,3],[21,4,21,5]]}
["Groep: Wil Langenberg",null,"Groep: Erik Kuijpers",null,"Groep: Frans Smulders",null,"Groep:"]
["Theo van den Broek",null,"Peter & Jozee van Zeeland",null,"Femke Smulders & Patrick van Lierop & Joep"]
["Jean-Pierre van Daal",null,"Martien van Abeelen",null,"Bram & Angelique van Abeelen"]
["Jos Soetens",null,"Thomas van Gerwen",null,"Wan & Dian Merks"]
["Dennis Soetens",null,"Wil van de Weiden"]
["Jo Sieben"]
[]
[]
[]
[]
[6,"Motoren",6,"Motoren",3,"Motoren",null,"Motoren"]
[]
["Groep: Toon Trouwen",null,"Groep: Willy Schuurmans",null,"Groep: "]
["Marc Verbaten",null,"Hans Ophof"]
["Ronnie van der Heijden",null,"Heinz Kessels"]
["Erik Bekkers",null,"Onno & Sandra Kruik-Geenen"]
["Piet van Zeeland",null,"Gert-Jan Robeerst"]
["Ivo Treverlo"]
[]
[]
[]
[]
[6,"Motoren",6,"Motoren",null,"Motoren"]
[]
[null,"Totaal:",{"$f":"SUM(A11+C11+E11+G11+A23+C23+E23)","v":27},{"$f":"IF(C25='Deelname weekend'!M38,\"Oké\",\"Fout\")","v":"Oké"}]
[]
[null,"Autovervoer:"]
{"$rows_empty":16}
[{"$nulls":12},239,259]
[]
[]
[]
[]
[]
[]
[{"$nulls":9},"2021-10-12"]

{"sheet":"Kamer bezetting","index":2,"n_rows":65,"n_cols":14,"rows_kept":65,"merged":[[10,5,10,6],[11,5,11,6],[12,5,12,6],[13,5,13,6],[14,5,14,6],[29,5,29,6],[31,5,31,6],[32,5,32,6],[33,5,33,6],[34,5,34,6],[35,5,35,6]]}
["Naam","Naam","Naam","Kamer","Nr",null,null,"Kamers","Nachten"]
[{"$f":"'Deelname weekend'!A2","v":"Hans Ophof"},null,null,"EZ",null,null,"DZ",{"$f":"COUNTIF($D$2:$D$30,$G2)","v":14},{"$f":"3*H2*2","v":84}]
[{"$f":"'Deelname weekend'!A13","v":"Heinz Kessels"},null,null,"EZ",null,null,"EZ",{"$f":"COUNTIF($D$2:$D$30,$G3)","v":6},{"$f":"3*H3","v":18}]
[{"$f":"'Deelname weekend'!A19","v":"Martien van Abeelen"},null,null,"EZ",null,null,"App",1,{"$f":"3*H4*3","v":9}]
[{"$f":"'Deelname weekend'!A20","v":"Thomas van Gerwen"},null,null,"EZ",null,null,"FZ",0,{"$f":"3*H5*4","v":0}]
[{"$f":"'Deelname weekend'!A22","v":"Ronnie van der Heijden"},null,null,"EZ"]
["Wil van de Weiden",null,null,"EZ"]
[{"$f":"'Deelname weekend'!A3","v":"Eric & Wietske Kuipers"},null,null,"DZ"]
[{"$f":"'Deelname weekend'!A4","v":"Toon & Els Trouwen"},null,null,"DZ"]
[{"$f":"'Deelname weekend'!A5","v":"Wan & Dian Merks"},null,null,"DZ"]
[{"$f":"'Deelname weekend'!A6","v":"Frans & Brigitte Smulders"},null,null,"DZ"]
[{"$f":"'Deelname weekend'!A7","v":"Femke Smulders & Patrick van Lierop & Joep"},null,"Kinderbett dazu","DZ"]
[{"$f":"'Deelname weekend'!A11","v":"Peter & Jozee van Zeeland"},null,null,"DZ"]
[{"$f":"'Deelname weekend'!A16","v":"Wil & Nollie Langenberg"},null,null,"DZ",{"$nulls":5},"Korting"]
[{"$f":"'Deelname weekend'!A17","v":"Wlly & Marion Schuurmans"},null,null,"DZ"]
[{"$f":"'Deelname weekend'!A24","v":"Onno & Sandra Kruik-Geenen"},null,null,"DZ"]
[{"$f":"'Deelname weekend'!A8","v":"Theo van den Broek"},{"$f":"'Deelname weekend'!A9","v":"Jean-Pierre van Daal"},null,"DZ"]
[{"$f":"'Deelname weekend'!A23","v":"Marc Verbaten"},{"$f":"'Deelname weekend'!A10","v":"Erik Bekkers"},null,"DZ"]
[{"$f":"'Deelname weekend'!A14","v":"Jos Soetens"},{"$f":"'Deelname weekend'!A15","v":"Dennis Soetens"},null,"DZ"]
[{"$f":"'Deelname weekend'!A21","v":"Jo Sieben"},{"$f":"'Deelname weekend'!A26","v":"Gert-Jan Robeerst"},null,"DZ"]
[{"$f":"'Deelname weekend'!A12","v":"Ivo Treverlo"},"Piet van Zeeland",null,"DZ"]
[{"$f":"'Deelname weekend'!A18","v":"Bram & Angelique van Abeelen"},"mit 2 Kinder",null,"App"]
{"$rows_empty":35}
[null,"26+27+28+29 mei 2022",{"$nulls":10},239,259]
[]
[]
[]
[]
[]
[]
[{"$nulls":9},"2021-10-12"]