{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Deelname weekend","Groepsindeling","Kamer bezetting"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Deelname weekend","index":0,"n_rows":55,"n_cols":15,"rows_kept":55,"cut":false,"hidden":false,"merged":[[56,7,56,9],[47,1,47,5],[54,9,54,12],[50,7,50,9],[51,7,51,9],[52,7,52,9]]}
["http://www.fuenfmaedelhaus.de/willkommen.htm","Gaat mee","Aantal","Kamer","Kind -4","Kind+4","Bonus","Betaald","Te ontvangen","Niet mee","Cash",null,"Motoren",null,"Kamer prijs"]
["Ivo Treverlo","J",1,"DZ",null,null,null,80,{"$f":"IF(AND(B2=\"J\",(H2-(C2*$O2+E2*$M$49+F2*$M$50))>0),(C2*$O2+E2*$M$49+F2*$M$50),(C2-G2)*$O2-H2+E2*$M$49+F2*$M$50)","v":0},{"$f":"IF(B2=\"N\",1,0)","v":0},null,{"$f":"COUNTIF(K2,\"cash\")*C2","v":0},1,null,{"$f":"IF(D2=$M$46,$M$48,IF(D2=$N$46,$N$48,0))","v":80}]
["Heinz Kessels","J",1,"EZ",null,null,null,100,0,{"$f":"IF(B3=\"N\",1,0)","v":0},null,0,1,null,{"$f":"IF(D3=$M$46,$M$48,IF(D3=$N$46,$N$48,0))","v":100}]
["Dick Willemsen","J",1,"DZ",null,null,null,80,0,{"$f":"IF(B4=\"N\",1,0)","v":0},null,0,1,null,80]
["Eric & Wietske Kuijpers","J",2,"DZ",null,null,null,160,0,0,null,0,1,null,80]
["Wan Merks","J",1,"DZ",null,null,null,80,{"$f":"IF(AND(B6=\"J\",(H6-(C6*$O6+E6*$M$49+F6*$M$50))>0),(C6*$O6+E6*$M$49+F6*$M$50),(C6-G6)*$O6-H6+E6*$M$49+F6*$M$50)","v":0},{"$f":"IF(B6=\"N\",1,0)","v":0},null,{"$f":"COUNTIF(K6,\"cash\")*C6","v":0},1,null,80]
["Richard & Esther Alsem","J",2,"DZ",null,null,null,160,0,0,null,0,2,null,80]
["Jean-Pierre van Daal","J",1,"DZ",null,null,null,80,0,0,null,0,1,null,80]
["Piet Hendrikx","J",1,"DZ",null,null,null,80,0,0,null,0,1,null,80]
["Toon & Els Trouwen","J",2,"DZ",null,null,null,160,0,0,null,0,1,null,80]
["Bastiaan Lier","J",1,"DZ",null,null,null,80,0,0,null,0,1,null,80]
["Erik Bekkers","J",1,"DZ",null,null,null,80,0,0,null,0,1,null,80]
["Ronnie van der Heyden","J",1,"DZ",null,null,null,80,0,0,null,0,1,null,80]
["Willy Schuurmans","J",1,"EZ",null,null,null,100,0,0,null,0,1,null,100]
["Jo Sieben","J",1,"DZ",null,null,null,80,{"$f":"IF(AND(B15=\"J\",(H15-(C15*$O15+E15*$M$49+F15*$M$50))>0),(C15*$O15+E15*$M$49+F15*$M$50),(C15-G15)*$O15-H15+E15*$M$49+F15*$M$50)","v":0},0,null,0,1,null,80]
["Gilbert Claessen","J",1,"DZ",null,null,null,80,{"$f":"IF(AND(B16=\"J\",(H16-(C16*$O16+E16*$M$49+F16*$M$50))>0),(C16*$O16+E16*$M$49+F16*$M$50),(C16-G16)*$O16-H16+E16*$M$49+F16*$M$50)","v":0},0,null,0,1,null,80]
["Eric van Meensel","J",1,"DZ",null,null,null,80,0,0,null,0,1,null,80]
["Theo van den Broek","J",1,"DZ",null,null,null,80,0,0,null,0,1,null,80]
["Rinus Willemsen","J",1,"DZ",null,null,null,80,0,0,null,0,1,null,80]
["Frans & Brigitte Smulders","J",2,"DZ",null,null,null,160,0,0,null,0,1,null,80]
["Marc Verbaten","J",1,"DZ",null,null,null,80,0,0,null,0,1,null,80]
["Jelena Sjatskig","J",1,"EZ",null,null,null,100,{"$f":"IF(AND(B22=\"J\",(H22-(C22*$O22+E22*$M$49+F22*$M$50))>0),(C22*$O22+E22*$M$49+F22*$M$50),(C22-G22)*$O22-H22+E22*$M$49+F22*$M$50)","v":0},0,null,0,1,null,100]
["Albert van de Vorstenbosch","J",1,"DZ",null,null,null,80,0,0,null,0,1,null,80]
["Gert-Jan Robeerst","J",1,"DZ",null,null,null,80,0,0,null,{"$f":"COUNTIF(K24,\"cash\")*C24","v":0},1,null,80]
[null,null,null,null,null,null,null,null,0,0,null,0,null,null,0]
[null,null,null,null,null,null,null,null,0,0,null,0,null,null,0]
[null,null,null,null,null,null,null,null,0,0,null,0,null,null,0]
[null,null,null,null,null,null,null,null,0,0,null,0,null,null,0]
[null,null,null,null,null,null,null,null,0,0,null,0,null,null,0]
[null,null,null,null,null,null,null,null,0,0,null,0,null,null,0]
[null,null,null,null,null,null,null,null,0,0,null,0,null,null,0]
[null,null,null,null,null,null,null,null,0,0,null,0,null,null,0]
[null,null,null,null,null,null,null,null,0,0,null,0,null,null,0]
[null,null,null,null,null,null,null,null,0,0,null,0,null,null,0]
[null,null,null,null,null,null,null,null,0,0,null,0,null,null,0]
[null,null,null,null,null,null,null,null,0,0,null,0,null,null,0]
[null,null,null,null,null,null,null,null,0,0,null,0,null,null,0]
[null,null,null,null,null,null,null,null,0,0,null,0,null,null,0]
[null,null,null,null,null,null,null,null,0,0,null,0,null,null,0]
[null,null,null,null,null,null,null,null,0,0,null,0,null,null,0]
[null,null,null,null,null,null,null,null,0,0,null,0,null,null,0]
[null,null,null,null,null,null,null,null,0,0,null,0,null,null,0]
[null,null,null,null,null,null,null,null,0,0,null,0,null,null,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Motoren)","v":24}]
[null,null,null,null,null,null,null,null,null,null,null,null,"DZ","EZ","DBZ"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Kamer bezetting'!H2","v":0},{"$f":"'Kamer bezetting'!H3","v":0},{"$f":"'Kamer bezetting'!H4","v":0}]
["Datum:","9+10+11 september",null,null,null,null,null,"Kosten per persoon:",null,null,null,null,80,100]
[null,null,null,null,null,null,null,"Kinderen tot 4 jaar:",null,null,null,null,0]
[null,null,null,null,null,null,null,"Kinderen 4 tot 14 jaar:",null,null,null,null,0]
["Ontvangen:",{"$f":"SUM(Betaald)","v":2220}]
["Nog te ontvangen cash:",{"$f":"K54","v":0},null,null,null,null,null,"Aantal betaald:"]
["Nog te ontvangen per bank:",{"$f":"SUM(Te_ontvangen)","v":0},null,null,null,null,null,"Nog te betalen:"]
["Er gaan mee:",{"$f":"SUM(Deelnemers)","v":27},null,null,{"$f":"SUM(E2:E43)","v":0},{"$f":"SUM(F2:F43)","v":0},null,"Te betalen cash:",null,null,{"$f":"SUM(L2:L43)*M48","v":0}]
["Zeker niet:",{"$f":"SUM(J2:J43)","v":0},null,null,null,null,null,null,"Update:","2016-09-06"]

{"sheet":"Groepsindeling","index":1,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[8,4,8,5],[6,2,6,3],[6,4,6,5],[0,6,0,7],[1,6,1,7],[2,6,2,7],[4,4,4,5],[5,4,5,5],[5,6,5,7],[4,0,4,1],[3,6,3,7],[4,6,4,7],[3,4,3,5],[4,2,4,3],[3,2,3,3],[2,0,2,1],[2,2,2,3],[2,4,2,5],[3,0,3,1],[2,8,2,9],[7,0,7,1],[7,2,7,3],[7,4,7,5],[5,0,5,1],[9,8,9,9],[5,2,5,3],[6,0,6,1],[9,0,9,1],[9,2,9,3],[9,4,9,5],[8,0,8,1],[8,2,8,3],[7,6,7,7],[8,6,8,7],[9,6,9,7],[6,6,6,7],[0,8,0,9],[6,8,6,9],[7,8,7,9],[8,8,8,9],[1,8,1,9],[5,8,5,9],[0,0,0,1],[0,2,0,3],[0,4,0,5],[1,0,1,1],[1,2,1,3],[1,4,1,5]]}
["Groep Eric Kuijpers",null,"Groep Richard Alsem",null,"Groep Toon Trouwen",null,"Groep Dick Willemsen",null,"Groep Frans Smulders"]
["Eric Kuijpers",null,{"$f":"'Deelname weekend'!A7","v":"Richard & Esther Alsem"},null,"Toon Trouwen",null,"Dick Willemsen",null,"Frans Smulders"]
[{"$f":"'Deelname weekend'!A6","v":"Wan Merks"},null,{"$f":"'Deelname weekend'!A22","v":"Jelena Sjatskig"},null,{"$f":"'Deelname weekend'!A2","v":"Ivo Treverlo"},null,{"$f":"'Deelname weekend'!A3","v":"Heinz Kessels"},null,{"$f":"'Deelname weekend'!A14","v":"Willy Schuurmans"}]
[{"$f":"'Deelname weekend'!A9","v":"Piet Hendrikx"},null,{"$f":"'Deelname weekend'!A11","v":"Bastiaan Lier"},null,{"$f":"'Deelname weekend'!A12","v":"Erik Bekkers"},null,{"$f":"'Deelname weekend'!A19","v":"Rinus Willemsen"},null,{"$f":"'Deelname weekend'!A15","v":"Jo Sieben"}]
[{"$f":"'Deelname weekend'!A16","v":"Gilbert Claessen"},null,null,null,{"$f":"'Deelname weekend'!A13","v":"Ronnie van der Heyden"},null,{"$f":"'Deelname weekend'!A8","v":"Jean-Pierre van Daal"},null,{"$f":"'Deelname weekend'!A23","v":"Albert van de Vorstenbosch"}]
[{"$f":"'Deelname weekend'!A17","v":"Eric van Meensel"},null,null,null,{"$f":"'Deelname weekend'!A21","v":"Marc Verbaten"},null,{"$f":"'Deelname weekend'!A18","v":"Theo van den Broek"},null,{"$f":"'Deelname weekend'!A24","v":"Gert-Jan Robeerst"}]
[]
[]
[]
[]
[5,"Motoren",4,"Motoren",5,"Motoren",5,"Motoren",5,"Motoren"]
[]
[null,null,null,null,null,null,null,"Autovervoer:"]
[null,"Totaal:",{"$f":"SUM(A11+C11+E11+G11 +I11)","v":24},{"$f":"IF(C14='Deelname weekend'!M45,\"Oké\",\"Fout\")","v":"Oké"},null,null,null,"Wietske Kuijpers"]
[null,null,null,null,null,null,null,"Els Trouwen"]

{"sheet":"Kamer bezetting","index":2,"n_rows":17,"n_cols":5,"rows_kept":17,"cut":false,"hidden":false,"merged":[[6,5,6,6],[5,5,5,6],[4,5,4,6],[8,5,8,6]]}
["Naam","Naam","Naam","Kamer","Nr"]
[{"$f":"'Deelname weekend'!A3","v":"Heinz Kessels"},null,null,"EZ"]
[{"$f":"'Deelname weekend'!A14","v":"Willy Schuurmans"},null,null,"EZ"]
[{"$f":"'Deelname weekend'!A5","v":"Eric & Wietske Kuijpers"},null,null,"DZ"]
[{"$f":"'Deelname weekend'!A7","v":"Richard & Esther Alsem"},null,null,"DZ"]
[{"$f":"'Deelname weekend'!A10","v":"Toon & Els Trouwen"},null,null,"DZ"]
[{"$f":"'Deelname weekend'!A4","v":"Dick Willemsen"},{"$f":"'Deelname weekend'!A19","v":"Rinus Willemsen"},null,"DZ"]
[{"$f":"'Deelname weekend'!A18","v":"Theo van den Broek"},{"$f":"'Deelname weekend'!A8","v":"Jean-Pierre van Daal"},null,"DZ"]
[{"$f":"'Deelname weekend'!A11","v":"Bastiaan Lier"},{"$f":"'Deelname weekend'!A15","v":"Jo Sieben"},null,"DZ"]
[{"$f":"'Deelname weekend'!A12","v":"Erik Bekkers"},{"$f":"'Deelname weekend'!A2","v":"Ivo Treverlo"},null,"DZ"]
[{"$f":"'Deelname weekend'!A9","v":"Piet Hendrikx"},{"$f":"'Deelname weekend'!A6","v":"Wan Merks"},null,"DZ"]
[{"$f":"'Deelname weekend'!A16","v":"Gilbert Claessen"},{"$f":"'Deelname weekend'!A17","v":"Eric van Meensel"},null,"DZ"]
[{"$f":"'Deelname weekend'!A13","v":"Ronnie van der Heyden"},{"$f":"'Deelname weekend'!A21","v":"Marc Verbaten"},null,"DZ"]
[{"$f":"'Deelname weekend'!A20","v":"Frans & Brigitte Smulders"},null,null,"DZ"]
[{"$f":"'Deelname weekend'!A22","v":"Jelena Sjatskig"},null,null,"EZ"]
[{"$f":"'Deelname weekend'!A23","v":"Albert van de Vorstenbosch"},null,"Ferienwohnung"]
[{"$f":"'Deelname weekend'!A24","v":"Gert-Jan Robeerst"},null,"Ferienwohnung"]