{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Inschrijving","Flightindeling"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":1,"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":"Inschrijving","index":0,"n_rows":51,"n_cols":14,"rows_kept":51,"cut":false,"hidden":false,"merged":[]}
["Inschrijf nr","Lidcode","Ehcp","TeeboxGeel","TeeboxWit","TeeboxBlauw","TeeboxRood","Betaald ja",null,"Deelnemer","Inschrijfnummer","Ehcp","Teebox keuze","Betaald"]
[1,"aaaa",null,null,null,null,null,null,null,"aSmit",{"$f":"A2","v":1},{"$f":"C2","v":0},null,{"$f":"H2","v":0}]
[2,"bbbb",null,null,null,null,null,null,null,"bSmit",2,0,null,0]
[3,"cccc",null,null,null,null,null,null,null,"cSmit",3,0,null,0]
[4,"dddd",null,null,null,null,null,null,null,"dSmit",4,0,null,0]
[5,"emields",null,null,null,null,null,null,null,"eSmit",5,0,null,0]
[6,"ffff",null,null,null,null,null,null,null,"fSmit",6,0,null,0]
[7,"gggg",null,null,null,null,null,null,null,"gSmit",7,0,null,0]
[8,"hhhh",null,null,null,null,null,null,null,"hSmit",8,0,null,0]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B11=\"\",\"\",IF(ISERROR(VLOOKUP(B11,[1]Blad2!$E$3:$F$545,2,0)),\"persoonscode NIET herkend !!\",VLOOKUP(B11,[1]Blad2!$E$3:$F$545,2,0)))","v":""},{"$f":"IF(J12=\"\",\"\",A11)","v":""},{"$f":"IF(J12=\"\",\"\",VALUE(SUBSTITUTE(C11,\".\",\",\")))","v":""},{"$f":"IF(J12=\"\",\"\",IF(D11=TRUE,\"G\",IF(E11=TRUE,\"W\",IF(F11=TRUE,\"B\",IF(G11=TRUE,\"R\",\"\")))))","v":""},{"$f":"IF(J12=\"\",\"\",IF(H11=TRUE,\"Ja\",\"Nee\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B12=\"\",\"\",IF(ISERROR(VLOOKUP(B12,[1]Blad2!$E$3:$F$545,2,0)),\"persoonscode NIET herkend !!\",VLOOKUP(B12,[1]Blad2!$E$3:$F$545,2,0)))","v":""},{"$f":"IF(J13=\"\",\"\",A12)","v":""},{"$f":"IF(J13=\"\",\"\",VALUE(SUBSTITUTE(C12,\".\",\",\")))","v":""},{"$f":"IF(J13=\"\",\"\",IF(D12=TRUE,\"G\",IF(E12=TRUE,\"W\",IF(F12=TRUE,\"B\",IF(G12=TRUE,\"R\",\"\")))))","v":""},{"$f":"IF(J13=\"\",\"\",IF(H12=TRUE,\"Ja\",\"Nee\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B13=\"\",\"\",IF(ISERROR(VLOOKUP(B13,[1]Blad2!$E$3:$F$545,2,0)),\"persoonscode NIET herkend !!\",VLOOKUP(B13,[1]Blad2!$E$3:$F$545,2,0)))","v":""},{"$f":"IF(J14=\"\",\"\",A13)","v":""},{"$f":"IF(J14=\"\",\"\",VALUE(SUBSTITUTE(C13,\".\",\",\")))","v":""},{"$f":"IF(J14=\"\",\"\",IF(D13=TRUE,\"G\",IF(E13=TRUE,\"W\",IF(F13=TRUE,\"B\",IF(G13=TRUE,\"R\",\"\")))))","v":""},{"$f":"IF(J14=\"\",\"\",IF(H13=TRUE,\"Ja\",\"Nee\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B14=\"\",\"\",IF(ISERROR(VLOOKUP(B14,[1]Blad2!$E$3:$F$545,2,0)),\"persoonscode NIET herkend !!\",VLOOKUP(B14,[1]Blad2!$E$3:$F$545,2,0)))","v":""},{"$f":"IF(J15=\"\",\"\",A14)","v":""},{"$f":"IF(J15=\"\",\"\",VALUE(SUBSTITUTE(C14,\".\",\",\")))","v":""},{"$f":"IF(J15=\"\",\"\",IF(D14=TRUE,\"G\",IF(E14=TRUE,\"W\",IF(F14=TRUE,\"B\",IF(G14=TRUE,\"R\",\"\")))))","v":""},{"$f":"IF(J15=\"\",\"\",IF(H14=TRUE,\"Ja\",\"Nee\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B15=\"\",\"\",IF(ISERROR(VLOOKUP(B15,[1]Blad2!$E$3:$F$545,2,0)),\"persoonscode NIET herkend !!\",VLOOKUP(B15,[1]Blad2!$E$3:$F$545,2,0)))","v":""},{"$f":"IF(J16=\"\",\"\",A15)","v":""},{"$f":"IF(J16=\"\",\"\",VALUE(SUBSTITUTE(C15,\".\",\",\")))","v":""},{"$f":"IF(J16=\"\",\"\",IF(D15=TRUE,\"G\",IF(E15=TRUE,\"W\",IF(F15=TRUE,\"B\",IF(G15=TRUE,\"R\",\"\")))))","v":""},{"$f":"IF(J16=\"\",\"\",IF(H15=TRUE,\"Ja\",\"Nee\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B16=\"\",\"\",IF(ISERROR(VLOOKUP(B16,[1]Blad2!$E$3:$F$545,2,0)),\"persoonscode NIET herkend !!\",VLOOKUP(B16,[1]Blad2!$E$3:$F$545,2,0)))","v":""},{"$f":"IF(J17=\"\",\"\",A16)","v":""},{"$f":"IF(J17=\"\",\"\",VALUE(SUBSTITUTE(C16,\".\",\",\")))","v":""},{"$f":"IF(J17=\"\",\"\",IF(D16=TRUE,\"G\",IF(E16=TRUE,\"W\",IF(F16=TRUE,\"B\",IF(G16=TRUE,\"R\",\"\")))))","v":""},{"$f":"IF(J17=\"\",\"\",IF(H16=TRUE,\"Ja\",\"Nee\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B17=\"\",\"\",IF(ISERROR(VLOOKUP(B17,[1]Blad2!$E$3:$F$545,2,0)),\"persoonscode NIET herkend !!\",VLOOKUP(B17,[1]Blad2!$E$3:$F$545,2,0)))","v":""},{"$f":"IF(J18=\"\",\"\",A17)","v":""},{"$f":"IF(J18=\"\",\"\",VALUE(SUBSTITUTE(C17,\".\",\",\")))","v":""},{"$f":"IF(J18=\"\",\"\",IF(D17=TRUE,\"G\",IF(E17=TRUE,\"W\",IF(F17=TRUE,\"B\",IF(G17=TRUE,\"R\",\"\")))))","v":""},{"$f":"IF(J18=\"\",\"\",IF(H17=TRUE,\"Ja\",\"Nee\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B18=\"\",\"\",IF(ISERROR(VLOOKUP(B18,[1]Blad2!$E$3:$F$545,2,0)),\"persoonscode NIET herkend !!\",VLOOKUP(B18,[1]Blad2!$E$3:$F$545,2,0)))","v":""},{"$f":"IF(J19=\"\",\"\",A18)","v":""},{"$f":"IF(J19=\"\",\"\",VALUE(SUBSTITUTE(C18,\".\",\",\")))","v":""},{"$f":"IF(J19=\"\",\"\",IF(D18=TRUE,\"G\",IF(E18=TRUE,\"W\",IF(F18=TRUE,\"B\",IF(G18=TRUE,\"R\",\"\")))))","v":""},{"$f":"IF(J19=\"\",\"\",IF(H18=TRUE,\"Ja\",\"Nee\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B19=\"\",\"\",IF(ISERROR(VLOOKUP(B19,[1]Blad2!$E$3:$F$545,2,0)),\"persoonscode NIET herkend !!\",VLOOKUP(B19,[1]Blad2!$E$3:$F$545,2,0)))","v":""},{"$f":"IF(J20=\"\",\"\",A19)","v":""},{"$f":"IF(J20=\"\",\"\",VALUE(SUBSTITUTE(C19,\".\",\",\")))","v":""},{"$f":"IF(J20=\"\",\"\",IF(D19=TRUE,\"G\",IF(E19=TRUE,\"W\",IF(F19=TRUE,\"B\",IF(G19=TRUE,\"R\",\"\")))))","v":""},{"$f":"IF(J20=\"\",\"\",IF(H19=TRUE,\"Ja\",\"Nee\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B20=\"\",\"\",IF(ISERROR(VLOOKUP(B20,[1]Blad2!$E$3:$F$545,2,0)),\"persoonscode NIET herkend !!\",VLOOKUP(B20,[1]Blad2!$E$3:$F$545,2,0)))","v":""},{"$f":"IF(J21=\"\",\"\",A20)","v":""},{"$f":"IF(J21=\"\",\"\",VALUE(SUBSTITUTE(C20,\".\",\",\")))","v":""},{"$f":"IF(J21=\"\",\"\",IF(D20=TRUE,\"G\",IF(E20=TRUE,\"W\",IF(F20=TRUE,\"B\",IF(G20=TRUE,\"R\",\"\")))))","v":""},{"$f":"IF(J21=\"\",\"\",IF(H20=TRUE,\"Ja\",\"Nee\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B21=\"\",\"\",IF(ISERROR(VLOOKUP(B21,[1]Blad2!$E$3:$F$545,2,0)),\"persoonscode NIET herkend !!\",VLOOKUP(B21,[1]Blad2!$E$3:$F$545,2,0)))","v":""},{"$f":"IF(J22=\"\",\"\",A21)","v":""},{"$f":"IF(J22=\"\",\"\",VALUE(SUBSTITUTE(C21,\".\",\",\")))","v":""},{"$f":"IF(J22=\"\",\"\",IF(D21=TRUE,\"G\",IF(E21=TRUE,\"W\",IF(F21=TRUE,\"B\",IF(G21=TRUE,\"R\",\"\")))))","v":""},{"$f":"IF(J22=\"\",\"\",IF(H21=TRUE,\"Ja\",\"Nee\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B22=\"\",\"\",IF(ISERROR(VLOOKUP(B22,[1]Blad2!$E$3:$F$545,2,0)),\"persoonscode NIET herkend !!\",VLOOKUP(B22,[1]Blad2!$E$3:$F$545,2,0)))","v":""},{"$f":"IF(J23=\"\",\"\",A22)","v":""},{"$f":"IF(J23=\"\",\"\",VALUE(SUBSTITUTE(C22,\".\",\",\")))","v":""},{"$f":"IF(J23=\"\",\"\",IF(D22=TRUE,\"G\",IF(E22=TRUE,\"W\",IF(F22=TRUE,\"B\",IF(G22=TRUE,\"R\",\"\")))))","v":""},{"$f":"IF(J23=\"\",\"\",IF(H22=TRUE,\"Ja\",\"Nee\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B23=\"\",\"\",IF(ISERROR(VLOOKUP(B23,[1]Blad2!$E$3:$F$545,2,0)),\"persoonscode NIET herkend !!\",VLOOKUP(B23,[1]Blad2!$E$3:$F$545,2,0)))","v":""},{"$f":"IF(J24=\"\",\"\",A23)","v":""},{"$f":"IF(J24=\"\",\"\",VALUE(SUBSTITUTE(C23,\".\",\",\")))","v":""},{"$f":"IF(J24=\"\",\"\",IF(D23=TRUE,\"G\",IF(E23=TRUE,\"W\",IF(F23=TRUE,\"B\",IF(G23=TRUE,\"R\",\"\")))))","v":""},{"$f":"IF(J24=\"\",\"\",IF(H23=TRUE,\"Ja\",\"Nee\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B24=\"\",\"\",IF(ISERROR(VLOOKUP(B24,[1]Blad2!$E$3:$F$545,2,0)),\"persoonscode NIET herkend !!\",VLOOKUP(B24,[1]Blad2!$E$3:$F$545,2,0)))","v":""},{"$f":"IF(J25=\"\",\"\",A24)","v":""},{"$f":"IF(J25=\"\",\"\",VALUE(SUBSTITUTE(C24,\".\",\",\")))","v":""},{"$f":"IF(J25=\"\",\"\",IF(D24=TRUE,\"G\",IF(E24=TRUE,\"W\",IF(F24=TRUE,\"B\",IF(G24=TRUE,\"R\",\"\")))))","v":""},{"$f":"IF(J25=\"\",\"\",IF(H24=TRUE,\"Ja\",\"Nee\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B25=\"\",\"\",IF(ISERROR(VLOOKUP(B25,[1]Blad2!$E$3:$F$545,2,0)),\"persoonscode NIET herkend !!\",VLOOKUP(B25,[1]Blad2!$E$3:$F$545,2,0)))","v":""},{"$f":"IF(J26=\"\",\"\",A25)","v":""},{"$f":"IF(J26=\"\",\"\",VALUE(SUBSTITUTE(C25,\".\",\",\")))","v":""},{"$f":"IF(J26=\"\",\"\",IF(D25=TRUE,\"G\",IF(E25=TRUE,\"W\",IF(F25=TRUE,\"B\",IF(G25=TRUE,\"R\",\"\")))))","v":""},{"$f":"IF(J26=\"\",\"\",IF(H25=TRUE,\"Ja\",\"Nee\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B26=\"\",\"\",IF(ISERROR(VLOOKUP(B26,[1]Blad2!$E$3:$F$545,2,0)),\"persoonscode NIET herkend !!\",VLOOKUP(B26,[1]Blad2!$E$3:$F$545,2,0)))","v":""},{"$f":"IF(J27=\"\",\"\",A26)","v":""},{"$f":"IF(J27=\"\",\"\",VALUE(SUBSTITUTE(C26,\".\",\",\")))","v":""},{"$f":"IF(J27=\"\",\"\",IF(D26=TRUE,\"G\",IF(E26=TRUE,\"W\",IF(F26=TRUE,\"B\",IF(G26=TRUE,\"R\",\"\")))))","v":""},{"$f":"IF(J27=\"\",\"\",IF(H26=TRUE,\"Ja\",\"Nee\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B27=\"\",\"\",IF(ISERROR(VLOOKUP(B27,[1]Blad2!$E$3:$F$545,2,0)),\"persoonscode NIET herkend !!\",VLOOKUP(B27,[1]Blad2!$E$3:$F$545,2,0)))","v":""},{"$f":"IF(J28=\"\",\"\",A27)","v":""},{"$f":"IF(J28=\"\",\"\",VALUE(SUBSTITUTE(C27,\".\",\",\")))","v":""},{"$f":"IF(J28=\"\",\"\",IF(D27=TRUE,\"G\",IF(E27=TRUE,\"W\",IF(F27=TRUE,\"B\",IF(G27=TRUE,\"R\",\"\")))))","v":""},{"$f":"IF(J28=\"\",\"\",IF(H27=TRUE,\"Ja\",\"Nee\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B28=\"\",\"\",IF(ISERROR(VLOOKUP(B28,[1]Blad2!$E$3:$F$545,2,0)),\"persoonscode NIET herkend !!\",VLOOKUP(B28,[1]Blad2!$E$3:$F$545,2,0)))","v":""},{"$f":"IF(J29=\"\",\"\",A28)","v":""},{"$f":"IF(J29=\"\",\"\",VALUE(SUBSTITUTE(C28,\".\",\",\")))","v":""},{"$f":"IF(J29=\"\",\"\",IF(D28=TRUE,\"G\",IF(E28=TRUE,\"W\",IF(F28=TRUE,\"B\",IF(G28=TRUE,\"R\",\"\")))))","v":""},{"$f":"IF(J29=\"\",\"\",IF(H28=TRUE,\"Ja\",\"Nee\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B29=\"\",\"\",IF(ISERROR(VLOOKUP(B29,[1]Blad2!$E$3:$F$545,2,0)),\"persoonscode NIET herkend !!\",VLOOKUP(B29,[1]Blad2!$E$3:$F$545,2,0)))","v":""},{"$f":"IF(J30=\"\",\"\",A29)","v":""},{"$f":"IF(J30=\"\",\"\",VALUE(SUBSTITUTE(C29,\".\",\",\")))","v":""},{"$f":"IF(J30=\"\",\"\",IF(D29=TRUE,\"G\",IF(E29=TRUE,\"W\",IF(F29=TRUE,\"B\",IF(G29=TRUE,\"R\",\"\")))))","v":""},{"$f":"IF(J30=\"\",\"\",IF(H29=TRUE,\"Ja\",\"Nee\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B30=\"\",\"\",IF(ISERROR(VLOOKUP(B30,[1]Blad2!$E$3:$F$545,2,0)),\"persoonscode NIET herkend !!\",VLOOKUP(B30,[1]Blad2!$E$3:$F$545,2,0)))","v":""},{"$f":"IF(J31=\"\",\"\",A30)","v":""},{"$f":"IF(J31=\"\",\"\",VALUE(SUBSTITUTE(C30,\".\",\",\")))","v":""},{"$f":"IF(J31=\"\",\"\",IF(D30=TRUE,\"G\",IF(E30=TRUE,\"W\",IF(F30=TRUE,\"B\",IF(G30=TRUE,\"R\",\"\")))))","v":""},{"$f":"IF(J31=\"\",\"\",IF(H30=TRUE,\"Ja\",\"Nee\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B31=\"\",\"\",IF(ISERROR(VLOOKUP(B31,[1]Blad2!$E$3:$F$545,2,0)),\"persoonscode NIET herkend !!\",VLOOKUP(B31,[1]Blad2!$E$3:$F$545,2,0)))","v":""},{"$f":"IF(J32=\"\",\"\",A31)","v":""},{"$f":"IF(J32=\"\",\"\",VALUE(SUBSTITUTE(C31,\".\",\",\")))","v":""},{"$f":"IF(J32=\"\",\"\",IF(D31=TRUE,\"G\",IF(E31=TRUE,\"W\",IF(F31=TRUE,\"B\",IF(G31=TRUE,\"R\",\"\")))))","v":""},{"$f":"IF(J32=\"\",\"\",IF(H31=TRUE,\"Ja\",\"Nee\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B32=\"\",\"\",IF(ISERROR(VLOOKUP(B32,[1]Blad2!$E$3:$F$545,2,0)),\"persoonscode NIET herkend !!\",VLOOKUP(B32,[1]Blad2!$E$3:$F$545,2,0)))","v":""},{"$f":"IF(J33=\"\",\"\",A32)","v":""},{"$f":"IF(J33=\"\",\"\",VALUE(SUBSTITUTE(C32,\".\",\",\")))","v":""},{"$f":"IF(J33=\"\",\"\",IF(D32=TRUE,\"G\",IF(E32=TRUE,\"W\",IF(F32=TRUE,\"B\",IF(G32=TRUE,\"R\",\"\")))))","v":""},{"$f":"IF(J33=\"\",\"\",IF(H32=TRUE,\"Ja\",\"Nee\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B33=\"\",\"\",IF(ISERROR(VLOOKUP(B33,[1]Blad2!$E$3:$F$545,2,0)),\"persoonscode NIET herkend !!\",VLOOKUP(B33,[1]Blad2!$E$3:$F$545,2,0)))","v":""},{"$f":"IF(J34=\"\",\"\",A33)","v":""},{"$f":"IF(J34=\"\",\"\",VALUE(SUBSTITUTE(C33,\".\",\",\")))","v":""},{"$f":"IF(J34=\"\",\"\",IF(D33=TRUE,\"G\",IF(E33=TRUE,\"W\",IF(F33=TRUE,\"B\",IF(G33=TRUE,\"R\",\"\")))))","v":""},{"$f":"IF(J34=\"\",\"\",IF(H33=TRUE,\"Ja\",\"Nee\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B34=\"\",\"\",IF(ISERROR(VLOOKUP(B34,[1]Blad2!$E$3:$F$545,2,0)),\"persoonscode NIET herkend !!\",VLOOKUP(B34,[1]Blad2!$E$3:$F$545,2,0)))","v":""},{"$f":"IF(J35=\"\",\"\",A34)","v":""},{"$f":"IF(J35=\"\",\"\",VALUE(SUBSTITUTE(C34,\".\",\",\")))","v":""},{"$f":"IF(J35=\"\",\"\",IF(D34=TRUE,\"G\",IF(E34=TRUE,\"W\",IF(F34=TRUE,\"B\",IF(G34=TRUE,\"R\",\"\")))))","v":""},{"$f":"IF(J35=\"\",\"\",IF(H34=TRUE,\"Ja\",\"Nee\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B35=\"\",\"\",IF(ISERROR(VLOOKUP(B35,[1]Blad2!$E$3:$F$545,2,0)),\"persoonscode NIET herkend !!\",VLOOKUP(B35,[1]Blad2!$E$3:$F$545,2,0)))","v":""},{"$f":"IF(J36=\"\",\"\",A35)","v":""},{"$f":"IF(J36=\"\",\"\",VALUE(SUBSTITUTE(C35,\".\",\",\")))","v":""},{"$f":"IF(J36=\"\",\"\",IF(D35=TRUE,\"G\",IF(E35=TRUE,\"W\",IF(F35=TRUE,\"B\",IF(G35=TRUE,\"R\",\"\")))))","v":""},{"$f":"IF(J36=\"\",\"\",IF(H35=TRUE,\"Ja\",\"Nee\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B36=\"\",\"\",IF(ISERROR(VLOOKUP(B36,[1]Blad2!$E$3:$F$545,2,0)),\"persoonscode NIET herkend !!\",VLOOKUP(B36,[1]Blad2!$E$3:$F$545,2,0)))","v":""},{"$f":"IF(J37=\"\",\"\",A36)","v":""},{"$f":"IF(J37=\"\",\"\",VALUE(SUBSTITUTE(C36,\".\",\",\")))","v":""},{"$f":"IF(J37=\"\",\"\",IF(D36=TRUE,\"G\",IF(E36=TRUE,\"W\",IF(F36=TRUE,\"B\",IF(G36=TRUE,\"R\",\"\")))))","v":""},{"$f":"IF(J37=\"\",\"\",IF(H36=TRUE,\"Ja\",\"Nee\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B37=\"\",\"\",IF(ISERROR(VLOOKUP(B37,[1]Blad2!$E$3:$F$545,2,0)),\"persoonscode NIET herkend !!\",VLOOKUP(B37,[1]Blad2!$E$3:$F$545,2,0)))","v":""},{"$f":"IF(J38=\"\",\"\",A37)","v":""},{"$f":"IF(J38=\"\",\"\",VALUE(SUBSTITUTE(C37,\".\",\",\")))","v":""},{"$f":"IF(J38=\"\",\"\",IF(D37=TRUE,\"G\",IF(E37=TRUE,\"W\",IF(F37=TRUE,\"B\",IF(G37=TRUE,\"R\",\"\")))))","v":""},{"$f":"IF(J38=\"\",\"\",IF(H37=TRUE,\"Ja\",\"Nee\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B38=\"\",\"\",IF(ISERROR(VLOOKUP(B38,[1]Blad2!$E$3:$F$545,2,0)),\"persoonscode NIET herkend !!\",VLOOKUP(B38,[1]Blad2!$E$3:$F$545,2,0)))","v":""},{"$f":"IF(J39=\"\",\"\",A38)","v":""},{"$f":"IF(J39=\"\",\"\",VALUE(SUBSTITUTE(C38,\".\",\",\")))","v":""},{"$f":"IF(J39=\"\",\"\",IF(D38=TRUE,\"G\",IF(E38=TRUE,\"W\",IF(F38=TRUE,\"B\",IF(G38=TRUE,\"R\",\"\")))))","v":""},{"$f":"IF(J39=\"\",\"\",IF(H38=TRUE,\"Ja\",\"Nee\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B39=\"\",\"\",IF(ISERROR(VLOOKUP(B39,[1]Blad2!$E$3:$F$545,2,0)),\"persoonscode NIET herkend !!\",VLOOKUP(B39,[1]Blad2!$E$3:$F$545,2,0)))","v":""},{"$f":"IF(J40=\"\",\"\",A39)","v":""},{"$f":"IF(J40=\"\",\"\",VALUE(SUBSTITUTE(C39,\".\",\",\")))","v":""},{"$f":"IF(J40=\"\",\"\",IF(D39=TRUE,\"G\",IF(E39=TRUE,\"W\",IF(F39=TRUE,\"B\",IF(G39=TRUE,\"R\",\"\")))))","v":""},{"$f":"IF(J40=\"\",\"\",IF(H39=TRUE,\"Ja\",\"Nee\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B40=\"\",\"\",IF(ISERROR(VLOOKUP(B40,[1]Blad2!$E$3:$F$545,2,0)),\"persoonscode NIET herkend !!\",VLOOKUP(B40,[1]Blad2!$E$3:$F$545,2,0)))","v":""},{"$f":"IF(J41=\"\",\"\",A40)","v":""},{"$f":"IF(J41=\"\",\"\",VALUE(SUBSTITUTE(C40,\".\",\",\")))","v":""},{"$f":"IF(J41=\"\",\"\",IF(D40=TRUE,\"G\",IF(E40=TRUE,\"W\",IF(F40=TRUE,\"B\",IF(G40=TRUE,\"R\",\"\")))))","v":""},{"$f":"IF(J41=\"\",\"\",IF(H40=TRUE,\"Ja\",\"Nee\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B41=\"\",\"\",IF(ISERROR(VLOOKUP(B41,[1]Blad2!$E$3:$F$545,2,0)),\"persoonscode NIET herkend !!\",VLOOKUP(B41,[1]Blad2!$E$3:$F$545,2,0)))","v":""},{"$f":"IF(J42=\"\",\"\",A41)","v":""},{"$f":"IF(J42=\"\",\"\",VALUE(SUBSTITUTE(C41,\".\",\",\")))","v":""},{"$f":"IF(J42=\"\",\"\",IF(D41=TRUE,\"G\",IF(E41=TRUE,\"W\",IF(F41=TRUE,\"B\",IF(G41=TRUE,\"R\",\"\")))))","v":""},{"$f":"IF(J42=\"\",\"\",IF(H41=TRUE,\"Ja\",\"Nee\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B42=\"\",\"\",IF(ISERROR(VLOOKUP(B42,[1]Blad2!$E$3:$F$545,2,0)),\"persoonscode NIET herkend !!\",VLOOKUP(B42,[1]Blad2!$E$3:$F$545,2,0)))","v":""},{"$f":"IF(J43=\"\",\"\",A42)","v":""},{"$f":"IF(J43=\"\",\"\",VALUE(SUBSTITUTE(C42,\".\",\",\")))","v":""},{"$f":"IF(J43=\"\",\"\",IF(D42=TRUE,\"G\",IF(E42=TRUE,\"W\",IF(F42=TRUE,\"B\",IF(G42=TRUE,\"R\",\"\")))))","v":""},{"$f":"IF(J43=\"\",\"\",IF(H42=TRUE,\"Ja\",\"Nee\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B43=\"\",\"\",IF(ISERROR(VLOOKUP(B43,[1]Blad2!$E$3:$F$545,2,0)),\"persoonscode NIET herkend !!\",VLOOKUP(B43,[1]Blad2!$E$3:$F$545,2,0)))","v":""},{"$f":"IF(J44=\"\",\"\",A43)","v":""},{"$f":"IF(J44=\"\",\"\",VALUE(SUBSTITUTE(C43,\".\",\",\")))","v":""},{"$f":"IF(J44=\"\",\"\",IF(D43=TRUE,\"G\",IF(E43=TRUE,\"W\",IF(F43=TRUE,\"B\",IF(G43=TRUE,\"R\",\"\")))))","v":""},{"$f":"IF(J44=\"\",\"\",IF(H43=TRUE,\"Ja\",\"Nee\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B44=\"\",\"\",IF(ISERROR(VLOOKUP(B44,[1]Blad2!$E$3:$F$545,2,0)),\"persoonscode NIET herkend !!\",VLOOKUP(B44,[1]Blad2!$E$3:$F$545,2,0)))","v":""},{"$f":"IF(J45=\"\",\"\",A44)","v":""},{"$f":"IF(J45=\"\",\"\",VALUE(SUBSTITUTE(C44,\".\",\",\")))","v":""},{"$f":"IF(J45=\"\",\"\",IF(D44=TRUE,\"G\",IF(E44=TRUE,\"W\",IF(F44=TRUE,\"B\",IF(G44=TRUE,\"R\",\"\")))))","v":""},{"$f":"IF(J45=\"\",\"\",IF(H44=TRUE,\"Ja\",\"Nee\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B45=\"\",\"\",IF(ISERROR(VLOOKUP(B45,[1]Blad2!$E$3:$F$545,2,0)),\"persoonscode NIET herkend !!\",VLOOKUP(B45,[1]Blad2!$E$3:$F$545,2,0)))","v":""},{"$f":"IF(J46=\"\",\"\",A45)","v":""},{"$f":"IF(J46=\"\",\"\",VALUE(SUBSTITUTE(C45,\".\",\",\")))","v":""},{"$f":"IF(J46=\"\",\"\",IF(D45=TRUE,\"G\",IF(E45=TRUE,\"W\",IF(F45=TRUE,\"B\",IF(G45=TRUE,\"R\",\"\")))))","v":""},{"$f":"IF(J46=\"\",\"\",IF(H45=TRUE,\"Ja\",\"Nee\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B46=\"\",\"\",IF(ISERROR(VLOOKUP(B46,[1]Blad2!$E$3:$F$545,2,0)),\"persoonscode NIET herkend !!\",VLOOKUP(B46,[1]Blad2!$E$3:$F$545,2,0)))","v":""},{"$f":"IF(J47=\"\",\"\",A46)","v":""},{"$f":"IF(J47=\"\",\"\",VALUE(SUBSTITUTE(C46,\".\",\",\")))","v":""},{"$f":"IF(J47=\"\",\"\",IF(D46=TRUE,\"G\",IF(E46=TRUE,\"W\",IF(F46=TRUE,\"B\",IF(G46=TRUE,\"R\",\"\")))))","v":""},{"$f":"IF(J47=\"\",\"\",IF(H46=TRUE,\"Ja\",\"Nee\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B47=\"\",\"\",IF(ISERROR(VLOOKUP(B47,[1]Blad2!$E$3:$F$545,2,0)),\"persoonscode NIET herkend !!\",VLOOKUP(B47,[1]Blad2!$E$3:$F$545,2,0)))","v":""},{"$f":"IF(J48=\"\",\"\",A47)","v":""},{"$f":"IF(J48=\"\",\"\",VALUE(SUBSTITUTE(C47,\".\",\",\")))","v":""},{"$f":"IF(J48=\"\",\"\",IF(D47=TRUE,\"G\",IF(E47=TRUE,\"W\",IF(F47=TRUE,\"B\",IF(G47=TRUE,\"R\",\"\")))))","v":""},{"$f":"IF(J48=\"\",\"\",IF(H47=TRUE,\"Ja\",\"Nee\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B48=\"\",\"\",IF(ISERROR(VLOOKUP(B48,[1]Blad2!$E$3:$F$545,2,0)),\"persoonscode NIET herkend !!\",VLOOKUP(B48,[1]Blad2!$E$3:$F$545,2,0)))","v":""},{"$f":"IF(J49=\"\",\"\",A48)","v":""},{"$f":"IF(J49=\"\",\"\",VALUE(SUBSTITUTE(C48,\".\",\",\")))","v":""},{"$f":"IF(J49=\"\",\"\",IF(D48=TRUE,\"G\",IF(E48=TRUE,\"W\",IF(F48=TRUE,\"B\",IF(G48=TRUE,\"R\",\"\")))))","v":""},{"$f":"IF(J49=\"\",\"\",IF(H48=TRUE,\"Ja\",\"Nee\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B49=\"\",\"\",IF(ISERROR(VLOOKUP(B49,[1]Blad2!$E$3:$F$545,2,0)),\"persoonscode NIET herkend !!\",VLOOKUP(B49,[1]Blad2!$E$3:$F$545,2,0)))","v":""},{"$f":"IF(J50=\"\",\"\",A49)","v":""},{"$f":"IF(J50=\"\",\"\",VALUE(SUBSTITUTE(C49,\".\",\",\")))","v":""},{"$f":"IF(J50=\"\",\"\",IF(D49=TRUE,\"G\",IF(E49=TRUE,\"W\",IF(F49=TRUE,\"B\",IF(G49=TRUE,\"R\",\"\")))))","v":""},{"$f":"IF(J50=\"\",\"\",IF(H49=TRUE,\"Ja\",\"Nee\"))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(B50=\"\",\"\",IF(ISERROR(VLOOKUP(B50,[1]Blad2!$E$3:$F$545,2,0)),\"persoonscode NIET herkend !!\",VLOOKUP(B50,[1]Blad2!$E$3:$F$545,2,0)))","v":""},{"$f":"IF(J51=\"\",\"\",A50)","v":""},{"$f":"IF(J51=\"\",\"\",VALUE(SUBSTITUTE(C50,\".\",\",\")))","v":""},{"$f":"IF(J51=\"\",\"\",IF(D50=TRUE,\"G\",IF(E50=TRUE,\"W\",IF(F50=TRUE,\"B\",IF(G50=TRUE,\"R\",\"\")))))","v":""},{"$f":"IF(J51=\"\",\"\",IF(H50=TRUE,\"Ja\",\"Nee\"))","v":""}]

{"sheet":"Flightindeling","index":1,"n_rows":77,"n_cols":12,"rows_kept":77,"cut":false,"hidden":false,"merged":[[71,1,73,1],[71,11,73,11],[74,1,76,1],[74,11,76,11],[62,1,64,1],[62,11,64,11],[65,1,67,1],[65,11,67,11],[68,1,70,1],[68,11,70,11],[53,1,55,1],[53,11,55,11],[56,1,58,1],[56,11,58,11],[59,1,61,1],[59,11,61,11],[44,1,46,1],[44,11,46,11],[47,1,49,1],[47,11,49,11],[50,1,52,1],[50,11,52,11],[35,1,37,1],[35,11,37,11],[38,1,40,1],[38,11,40,11],[41,1,43,1],[41,11,43,11],[26,1,28,1],[26,11,28,11],[29,1,31,1],[29,11,31,11],[32,1,34,1],[32,11,34,11],[17,1,19,1],[17,11,19,11],[20,1,22,1],[20,11,22,11],[23,1,25,1],[23,11,25,11],[8,1,10,1],[8,11,10,11],[11,1,13,1],[11,11,13,11],[14,1,16,1],[14,11,16,11],[0,5,0,6],[0,7,0,8],[2,1,4,1],[2,11,4,11],[5,1,7,1],[5,11,7,11]]}
["spelvorm","Svp keuze wedstrijdvorm maken","Nog geen keuze gemaakt, ga naar sheet inbrengen - opslaan gegevens!","Longest : ","Neary : ","Dubbel Neary : ",null,"Totaal betaald",null,0,"Niet van toepassing voor deze spelvorm","Niet van toepassing voor deze spelvorm"]
["nr inschrijving","Flght Nr","Naam","Persoonscode","Lidcode","Betaald","Starttijd","Ehcp","Keuze TeeBox","Phcp","Aantal slagen bij Amerikaantje of Match Play","Flight Phcp"]
[{"$f":"IF($B$1=7,1,1)","v":1},1]
[{"$f":"IF($B$1=7,B3*2,A3+1)","v":2}]
[{"$f":"IF($B$1=7,\"\",A4+1)","v":3}]
[{"$f":"IF($B$1=7,B6*2-1,A5+1)","v":4},{"$f":"B3+1","v":2}]
[{"$f":"IF($B$1=7,B6*2,A6+1)","v":5}]
[{"$f":"IF($B$1=7,\"\",A7+1)","v":6}]
[{"$f":"IF($B$1=7,B9*2-1,A8+1)","v":7},{"$f":"B6+1","v":3}]
[{"$f":"IF($B$1=7,B9*2,A9+1)","v":8}]
[{"$f":"IF($B$1=7,\"\",A10+1)","v":9}]
[{"$f":"IF($B$1=7,B12*2-1,A11+1)","v":10},{"$f":"B9+1","v":4}]
[{"$f":"IF($B$1=7,B12*2,A12+1)","v":11}]
[{"$f":"IF($B$1=7,\"\",A13+1)","v":12}]
[{"$f":"IF($B$1=7,B15*2-1,A14+1)","v":13},{"$f":"B12+1","v":5}]
[{"$f":"IF($B$1=7,B15*2,A15+1)","v":14}]
[{"$f":"IF($B$1=7,\"\",A16+1)","v":15}]
[{"$f":"IF($B$1=7,B18*2-1,A17+1)","v":16},{"$f":"B15+1","v":6}]
[{"$f":"IF($B$1=7,B18*2,A18+1)","v":17}]
[{"$f":"IF($B$1=7,\"\",A19+1)","v":18}]
[{"$f":"IF($B$1=7,B21*2-1,A20+1)","v":19},{"$f":"B18+1","v":7}]
[{"$f":"IF($B$1=7,B21*2,A21+1)","v":20}]
[{"$f":"IF($B$1=7,\"\",A22+1)","v":21}]
[{"$f":"IF($B$1=7,B24*2-1,A23+1)","v":22},{"$f":"B21+1","v":8}]
[{"$f":"IF($B$1=7,B24*2,A24+1)","v":23}]
[{"$f":"IF($B$1=7,\"\",A25+1)","v":24}]
[{"$f":"IF($B$1=7,B27*2-1,A26+1)","v":25},{"$f":"B24+1","v":9}]
[{"$f":"IF($B$1=7,B27*2,A27+1)","v":26}]
[{"$f":"IF($B$1=7,\"\",A28+1)","v":27}]
[{"$f":"IF($B$1=7,B30*2-1,A29+1)","v":28},{"$f":"B27+1","v":10}]
[{"$f":"IF($B$1=7,B30*2,A30+1)","v":29}]
[{"$f":"IF($B$1=7,\"\",A31+1)","v":30}]
[{"$f":"IF($B$1=7,B33*2-1,A32+1)","v":31},{"$f":"B30+1","v":11}]
[{"$f":"IF($B$1=7,B33*2,A33+1)","v":32}]
[{"$f":"IF($B$1=7,\"\",A34+1)","v":33}]
[{"$f":"IF($B$1=7,B36*2-1,A35+1)","v":34},{"$f":"B33+1","v":12}]
[{"$f":"IF($B$1=7,B36*2,A36+1)","v":35}]
[{"$f":"IF($B$1=7,\"\",A37+1)","v":36}]
[{"$f":"IF($B$1=7,B39*2-1,A38+1)","v":37},{"$f":"B36+1","v":13}]
[{"$f":"IF($B$1=7,B39*2,A39+1)","v":38}]
[{"$f":"IF($B$1=7,\"\",A40+1)","v":39}]
[{"$f":"IF($B$1=7,B42*2-1,A41+1)","v":40},{"$f":"B39+1","v":14}]
[{"$f":"IF($B$1=7,B42*2,A42+1)","v":41}]
[{"$f":"IF($B$1=7,\"\",A43+1)","v":42}]
[{"$f":"IF($B$1=7,B45*2-1,A44+1)","v":43},{"$f":"B42+1","v":15}]
[{"$f":"IF($B$1=7,B45*2,A45+1)","v":44}]
[{"$f":"IF($B$1=7,\"\",A46+1)","v":45}]
[{"$f":"IF($B$1=7,B48*2-1,A47+1)","v":46},{"$f":"B45+1","v":16}]
[{"$f":"IF($B$1=7,B48*2,A48+1)","v":47}]
[{"$f":"IF($B$1=7,\"\",A49+1)","v":48}]
[{"$f":"IF($B$1=7,B51*2-1,A50+1)","v":49},{"$f":"B48+1","v":17}]
[{"$f":"IF($B$1=7,B51*2,A51+1)","v":50}]
[{"$f":"IF($B$1=7,\"\",A52+1)","v":51}]
[{"$f":"IF($B$1=7,B54*2-1,A53+1)","v":52},{"$f":"B51+1","v":18}]
[{"$f":"IF($B$1=7,B54*2,A54+1)","v":53}]
[{"$f":"IF($B$1=7,\"\",A55+1)","v":54}]
[{"$f":"IF($B$1=7,B57*2-1,A56+1)","v":55},{"$f":"B54+1","v":19}]
[{"$f":"IF($B$1=7,B57*2,A57+1)","v":56}]
[{"$f":"IF($B$1=7,\"\",A58+1)","v":57}]
[{"$f":"IF($B$1=7,B60*2-1,A59+1)","v":58},{"$f":"B57+1","v":20}]
[{"$f":"IF($B$1=7,B60*2,A60+1)","v":59}]
[{"$f":"IF($B$1=7,\"\",A61+1)","v":60}]
[{"$f":"IF($B$1=7,B63*2-1,A62+1)","v":61},{"$f":"B60+1","v":21}]
[{"$f":"IF($B$1=7,B63*2,A63+1)","v":62}]
[{"$f":"IF($B$1=7,\"\",A64+1)","v":63}]
[{"$f":"IF($B$1=7,B66*2-1,A65+1)","v":64},{"$f":"B63+1","v":22}]
[{"$f":"IF($B$1=7,B66*2,A66+1)","v":65}]
[{"$f":"IF($B$1=7,\"\",A67+1)","v":66}]
[{"$f":"IF($B$1=7,B69*2-1,A68+1)","v":67},{"$f":"B66+1","v":23}]
[{"$f":"IF($B$1=7,B69*2,A69+1)","v":68}]
[{"$f":"IF($B$1=7,\"\",A70+1)","v":69}]
[{"$f":"IF($B$1=7,B72*2-1,A71+1)","v":70},{"$f":"B69+1","v":24}]
[{"$f":"IF($B$1=7,B72*2,A72+1)","v":71}]
[{"$f":"IF($B$1=7,\"\",A73+1)","v":72}]
[{"$f":"IF($B$1=7,B75*2-1,A74+1)","v":73},{"$f":"B72+1","v":25}]
[{"$f":"IF($B$1=7,B75*2,A75+1)","v":74}]
[{"$f":"IF($B$1=7,\"\",A76+1)","v":75}]