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

{"sheet":"Deelname weekend","index":0,"n_rows":54,"n_cols":19,"rows_kept":54,"merged":[[36,1,36,5],[38,7,38,9],[39,7,39,9],[40,7,40,9],[41,7,41,9],[41,11,41,12],[42,9,42,10],[43,9,43,13],[45,7,45,9],[45,11,45,12],[46,11,46,12],[48,8,48,12],[49,8,49,12],[50,8,50,12],[51,8,51,12],[52,8,52,12]]}
["Hotel Bliesbrück","Gaat mee","Aantal","Kamer","Kind","Voorschot","Bonus","Betaald","Nog te ontvangen","Niet mee","Cash",null,"Motoren","Auto","Kamer prijs","Nog te betalen","Gemeld","Afgemeld","Wel mee"]
["Gert-Jan Robeerst","J",1,"EZ",null,{"v":50,"d":"€ 50.00"},null,{"v":290,"d":"€ 290.00"},{"$f":"IF(AND(B2=\"J\",((H2+F2)-(Deelnemers*$O2+E2*$M$38))>0),(Deelnemers*$O2+E2*$M$38),(Deelnemers-G2)*$O2-(H2+F2)+E2*$M$38)","v":0},{"$f":"IF(B2=\"N\",1,0)","v":0},null,{"$f":"COUNTIF(K2,\"cash\")*Deelnemers","v":0},1,null,{"$f":"IF(D2=$M$35,$M$37,IF(D2=$N$35,$N$37,IF(D2=$O$35,$O$37,IF(D2=$P$35,$P$37,IF(D2=$Q$35,$Q$37,0)))))","v":{"v":340,"d":"€ 340.00"}},{"$f":"IF(H2=\"\",I2,IF(H2+F2=(O2*C2),\"\",(O2*C2-H2)))","v":""}]
["Richard Alsem","J",1,"EZ",null,{"v":50,"d":"€ 50.00"},null,{"v":290,"d":"€ 290.00"},0,0,null,0,1,null,{"v":340,"d":"€ 340.00"},""]
["Hans Ophof","J",1,"EZ",null,{"v":50,"d":"€ 50.00"},null,{"v":290,"d":"€ 290.00"},0,{"$f":"IF(B4=\"N\",1,0)","v":0},null,{"$f":"COUNTIF(K4,\"cash\")*Deelnemers","v":0},1,null,{"v":340,"d":"€ 340.00"},""]
["Heinz Kessels","J",1,"EZ",null,{"v":50,"d":"€ 50.00"},null,{"v":290,"d":"€ 290.00"},0,{"$f":"IF(B5=\"N\",1,0)","v":0},null,{"$f":"COUNTIF(K5,\"cash\")*Deelnemers","v":0},1,null,{"v":340,"d":"€ 340.00"},""]
["Jan van Wijngaarden","j",1,"EZ",{"$nulls":3},{"v":340,"d":"€ 340.00"},0,{"$f":"IF(B6=\"N\",1,0)","v":0},null,{"$f":"COUNTIF(K6,\"cash\")*Deelnemers","v":0},1,null,{"v":340,"d":"€ 340.00"}]
["Theo van den Broek","J",1,"DZ",null,{"v":50,"d":"€ 50.00"},null,{"v":245,"d":"€ 245.00"},0,0,null,0,1,null,{"v":295,"d":"€ 295.00"},""]
["Wan & Dian Merks","J",2,"DZ",null,{"v":100,"d":"€ 100.00"},null,{"v":490,"d":"€ 490.00"},0,0,null,{"$f":"COUNTIF(K8,\"cash\")*Deelnemers","v":0},1,1,{"v":295,"d":"€ 295.00"},{"$f":"IF(H8=\"\",I8,IF(H8+F8=(O8*C8),\"\",(O8*C8-H8)))","v":""}]
["Toon & Els Trouwen","J",2,"DZ",null,{"v":100,"d":"€ 100.00"},null,{"v":490,"d":"€ 490.00"},0,{"$f":"IF(B9=\"N\",1,0)","v":0},null,{"$f":"COUNTIF(K9,\"cash\")*Deelnemers","v":0},1,1,{"v":295,"d":"€ 295.00"},""]
["Jos Soetens","J",1,"DZ",null,{"v":50,"d":"€ 50.00"},null,{"v":245,"d":"€ 245.00"},0,0,null,0,1,null,{"v":295,"d":"€ 295.00"},""]
["Peter & Jozee van Zeeland","J",2,"DZ",null,{"v":100,"d":"€ 100.00"},null,{"v":490,"d":"€ 490.00"},0,0,null,0,1,1,{"v":295,"d":"€ 295.00"},""]
["Frans & Brigitte Smulders","J",2,"DZ",null,{"v":100,"d":"€ 100.00"},null,{"v":490,"d":"€ 490.00"},0,0,null,0,1,null,{"v":295,"d":"€ 295.00"},""]
["Erik Bekkers","J",1,"DZ",null,{"v":50,"d":"€ 50.00"},null,{"v":245,"d":"€ 245.00"},0,0,null,0,1,null,{"v":295,"d":"€ 295.00"},""]
["Ivo Treverlo","J",1,"DZ",null,{"v":50,"d":"€ 50.00"},null,{"v":245,"d":"€ 245.00"},0,0,null,0,1,null,{"v":295,"d":"€ 295.00"},""]
["Jean-Pierre van Daal","J",1,"DZ",null,{"v":50,"d":"€ 50.00"},null,{"v":245,"d":"€ 245.00"},0,{"$f":"IF(B15=\"N\",1,0)","v":0},null,{"$f":"COUNTIF(K15,\"cash\")*Deelnemers","v":0},1,null,{"v":295,"d":"€ 295.00"},""]
["Willy & Marion Schuurmans","J",2,"DZ",null,{"v":100,"d":"€ 100.00"},null,{"v":490,"d":"€ 490.00"},0,{"$f":"IF(B16=\"N\",1,0)","v":0},null,{"$f":"COUNTIF(K16,\"cash\")*Deelnemers","v":0},1,null,{"v":295,"d":"€ 295.00"},""]
["Onno & Sandra Kruik - Geenen","J",2,"DZ",null,{"v":100,"d":"€ 100.00"},null,{"v":490,"d":"€ 490.00"},0,0,null,0,2,null,{"v":295,"d":"€ 295.00"},""]
["Wil & Nollie Langenberg","J",2,"DZ",null,{"v":100,"d":"€ 100.00"},null,{"v":490,"d":"€ 490.00"},0,0,null,0,1,null,{"v":295,"d":"€ 295.00"},""]
["Thomas & Desiree van Gerwen","J",2,"DZ",null,{"v":100,"d":"€ 100.00"},null,{"v":490,"d":"€ 490.00"},0,0,null,0,1,1,{"v":295,"d":"€ 295.00"},""]
["Eric & Wietske Kuijpers","J",2,"DZ",null,{"v":100,"d":"€ 100.00"},null,{"v":490,"d":"€ 490.00"},0,0,null,0,1,1,{"v":295,"d":"€ 295.00"},""]
["Marc Verbaten","J",1,"DZ",null,{"v":50,"d":"€ 50.00"},null,{"v":245,"d":"€ 245.00"},0,0,null,0,1,null,{"v":295,"d":"€ 295.00"},""]
["Rinus Willemsen","J",1,"DZ",null,{"v":50,"d":"€ 50.00"},null,{"v":245,"d":"€ 245.00"},0,0,null,0,1,null,{"v":295,"d":"€ 295.00"},""]
["Dick Willemsen","J",1,"DZ",null,{"v":50,"d":"€ 50.00"},null,{"v":245,"d":"€ 245.00"},0,{"$f":"IF(B23=\"N\",1,0)","v":0},null,{"$f":"COUNTIF(K23,\"cash\")*Deelnemers","v":0},1,null,{"v":295,"d":"€ 295.00"},""]
["Dennis Soetens","J",1,"DZ",null,{"v":50,"d":"€ 50.00"},null,{"v":245,"d":"€ 245.00"},0,0,null,0,1,null,{"v":295,"d":"€ 295.00"},{"$f":"IF(H24=\"\",I24,IF(H24+F24=(O24*C24),\"\",(O24*C24-H24)))","v":""}]
["Martien van Abeelen","J",1,"DZ",null,{"v":50,"d":"€ 50.00"},null,{"v":245,"d":"€ 245.00"},0,0,null,0,1,null,{"v":295,"d":"€ 295.00"},{"$f":"IF(H25=\"\",I25,IF(H25+F25=(O25*C25),\"\",(O25*C25-H25)))","v":""}]
["Bram van Abeelen","J",1,"DZ",null,{"v":50,"d":"€ 50.00"},null,{"v":245,"d":"€ 245.00"},0,0,null,0,1,null,{"v":295,"d":"€ 295.00"},{"$f":"IF(H26=\"\",I26,IF(H26+F26=(O26*C26),\"\",(O26*C26-H26)))","v":""}]
["Femke Smulders & Patrick van Lierop & Joep & Gijs","J",2,"DZ",2,{"v":50,"d":"€ 50.00"},null,{"v":540,"d":"€ 540.00"},0,0,null,0,1,1,{"v":295,"d":"€ 295.00"},{"$f":"IF(H27=\"\",I27,IF(H27+F27=(O27*C27),\"\",(O27*C27-H27)))","v":""}]
["Jac & Lies Keijsers","J",2,"DZ",null,{"v":100,"d":"€ 100.00"},null,{"v":490,"d":"€ 490.00"},0,0,null,0,1,1,{"v":295,"d":"€ 295.00"},{"$f":"IF(H28=\"\",I28,IF(H28+F28=(O28*C28),\"\",(O28*C28-H28)))","v":""}]
[{"$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":5},"Lege cellen"]
[{"$nulls":5},{"$f":"COUNTBLANK(Voorschot)","v":3},null,{"$f":"SUM(Betaald)/M37","v":{"v":32.66101694915254,"d":"33"}},{"$nulls":4},{"$f":"SUM(Motoren)","v":28},{"$f":"SUM(Auto)","v":7}]
[]
[]
[{"$nulls":12},"DZ","EZ","FZ","App.","3BZ"]
[{"$nulls":12},{"$f":"COUNTIF(Kamer,M$35)","v":22},{"$f":"COUNTIF(Kamer,N$35)","v":5},{"$f":"COUNTIF(Kamer,O$35)","v":0},{"$f":"COUNTIF(Kamer,P$35)","v":0},{"$f":"COUNTIF(Kamer,Q$35)","v":0}]
["Datum:","9+10+11+12 MEI 2024",{"$nulls":5},"Kosten per persoon:",{"$nulls":4},{"v":295,"d":"€ 295.00"},{"v":340,"d":"€ 340.00"}]
[]
[{"$nulls":7},"Kindertoeslag",{"$nulls":4},{"$f":"50%*M37","v":{"v":147.5,"d":"€ 147.50"}}]
["Ontvangen:",{"$f":"SUM(Betaald)+SUM(Voorschot)","v":{"v":11435,"d":"€ 11,435.00"}},{"$nulls":5},"Toeristenbelasting p.p.p.n.",{"$nulls":4},0]
["Nog te ontvangen cash:",{"$f":"J43","v":0},{"$nulls":5},"Aantal betaald totaal:"]
["Nog te ontvangen per bank:",{"$f":"SUM(Te_ontvangen)","v":0},{"$nulls":5},"Nog te betalen:",{"$nulls":3},{"$f":"SUM(Nog_te_betalen)","v":0}]
["Er gaan mee:",{"$f":"SUM(Deelnemers)","v":38},{"$f":"SUM(Kind)","v":2},{"$nulls":4},"Aantal betaald voorschot:",{"$nulls":4},{"$f":"SUM(Voorschot)/B45","v":36}]
["Zeker niet:",{"$f":"SUM(J2:J30)","v":0},{"$nulls":6},"Update:","2024-04-23"]
["Voorschot bedrag",{"v":50,"d":"€ 50.00"}]
["Aanbetaling 1:",{"$f":"SUM(Voorschot)","v":{"v":1800,"d":"€ 1,800.00"}}]
["Aanbetaling 2:",{"$f":"SUM(Betaald)","v":{"v":9635,"d":"€ 9,635.00"}}]
["Grote garage:",0]
["Garage box:",0,"pst",{"$nulls":4},"DZ","2 persoonskamer"]
["BBQ:",0,"pp",{"$nulls":4},"EZ","1 persoonskamer"]
[{"$nulls":7},"FZ","Familiekamer"]
[{"$nulls":7},"App","Appartement"]
["Mail 1 verzonden:","2024-01-11",{"$nulls":5},"3BZ","3 persoonskamer"]
["Mail 2 verzonden:","2024-02-07"]

{"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: Dick Willemsen",null,"Groep: Wil Langenberg",null,"Groep: Eric Kuijpers",null,"Groep: Toon Trouwen"]
["Rinus Willemsen",null,"Theo van den Broek",null,"Thomas van Gerwen",null,"Erik Bekkers"]
["Richard Alsem",null,"Jean-Pierre van Daal",null,"Jack Keijsers",null,"Ivo Treverlo"]
["Wan Merks",null,"Jos Soetens",null,"Peter van Zeeland",null,"Marc Verbaten"]
[null,null,"Dennis Soetens",{"$nulls":3},"Gert-Jan Robeerst"]
[]
[]
[]
[]
[]
[4,"Motoren",5,"Motoren",4,"Motoren",5,"Motoren"]
[]
["Groep: Willy Schuurmans",null,"Groep: Frans Smulders",null,"Groep:"]
["Onno Kruiuk",null,"Bram Abeelen"]
["Sandra Geenen",null,"Martien Abeelen"]
["Hans Ophof",null,"Femke Smulders"]
["Heinz Kessels",null,"Jan van Wijngaarden"]
[]
[]
[]
[]
[]
[5,"Motoren",5,"Motoren",null,"Motoren"]
[]
[]
[null,"Totaal:",{"$f":"SUM(A11+C11+E11+G11+A23+C23+E23)","v":28},{"$f":"IF(C26='Deelname weekend'!M32,\"Oké\",\"Fout\")","v":"Oké"}]
[]
[null,"Autovervoer:",{"$f":"'Deelname weekend'!N32","v":7}]
{"$rows_empty":15}
[{"$nulls":12},289,334]
[]
[]
[]
[]
[]
[]
[{"$nulls":9},"2023-11-06"]

{"sheet":"Kamerindeling","index":2,"n_rows":52,"n_cols":14,"rows_kept":52}
["Nahme 1","Nahme 2","Nahme 3","Zimmer","Zimmer Nr"]
["Gert-Jan Robeerst",null,null,"EZ"]
["Richard Alsem",null,null,"EZ"]
["Hans Ophof",null,null,"EZ"]
["Heinz Kessels",null,null,"EZ"]
["Marc Verbaten",null,null,"EZ"]
["Janvan Wijngaarden",null,null,"EZ"]
["Theo van den Broek","Jean-Pierre van Daal",null,"DZ"]
["Wan & Dian Merks",null,null,"DZ"]
["Toon & Els Trouwen",null,null,"DZ"]
["Jos Soetens","Dennis Soetens",null,"DZ"]
["Peter & Jozee van Zeeland",null,null,"DZ"]
["Frans & Brigitte Smulders",null,null,"DZ"]
["Jac & Lies Keijsers",null,null,"DZ"]
["Erik Bekkers","Ivo Treverlo",null,"DZ"]
["Willy & Marion Schuurmans",null,null,"DZ"]
["Onno & Sandra Kruik - Geenen",null,null,"DZ"]
["Wil & Nollie Langenberg",null,null,"DZ"]
["Thomas & Desiree van Gerwen",null,null,"DZ"]
["Eric & Wietske Kuijpers",null,null,"DZ"]
["Dick Willemsen","Rinus Willemsen",null,"DZ"]
["Martien van Abeelen","Bram van Abeelen",null,"DZ"]
["Fenke Smulders","Patrick van Lierop","Joep & Gijs","APP"]
{"$rows_empty":21}
[{"$nulls":12},289,334]
[]
[]
[]
[]
[]
[]
[{"$nulls":9},"2023-11-06"]