{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Catégories Combat KFK","Catégories Technique KFK","Informations","Taolu individuel - KFK","Dui lian","Formes collectives (Jiti)","Dianda"],"not_rendered":{"images":2,"defined_names":26},"read":"whole","date_system":"1900"}

{"sheet":"Catégories Combat KFK","index":0,"n_rows":9,"n_cols":11,"rows_kept":9,"hidden":true,"merged":[[0,0,0,2],[0,5,0,10],[1,6,1,10],[5,6,5,10]]}
["Dianda",{"$nulls":4},"Catégorie de poids en fonction de la catégorie d'âge"]
[null,"Minimum","Maximum",{"$nulls":3},"Féminine"]
["Poussins",{"v":6,"d":"06 ans"},{"v":7,"d":"07 ans"},null,null,"Poussins",{"v":-25,"d":"≤ 25 kg"},{"v":-30,"d":"≤ 30 kg"},{"v":-35,"d":"≤ 35 kg"},{"v":-40,"d":"≤ 40 kg"},{"$f":"-INDIRECT(ADDRESS(ROW(),COLUMN()-1))","v":{"v":40,"d":"> 40 kg"}}]
["Pupilles",{"v":8,"d":"08 ans"},{"v":9,"d":"09 ans"},null,null,"Pupilles",{"v":-30,"d":"≤ 30 kg"},{"v":-35,"d":"≤ 35 kg"},{"v":-40,"d":"≤ 40 kg"},{"v":-45,"d":"≤ 45 kg"},{"$f":"-INDIRECT(ADDRESS(ROW(),COLUMN()-1))","v":{"v":45,"d":"> 45 kg"}}]
["Benjamins",{"v":10,"d":"10 ans"},{"v":11,"d":"11 ans"},null,null,"Benjamins",{"v":-35,"d":"≤ 35 kg"},{"v":-40,"d":"≤ 40 kg"},{"v":-45,"d":"≤ 45 kg"},{"v":-50,"d":"≤ 50 kg"},{"$f":"-INDIRECT(ADDRESS(ROW(),COLUMN()-1))","v":{"v":50,"d":"> 50 kg"}}]
[{"$nulls":6},"Masculin"]
[{"$nulls":5},"Poussins",{"v":-25,"d":"≤ 25 kg"},{"v":-30,"d":"≤ 30 kg"},{"v":-35,"d":"≤ 35 kg"},{"v":-40,"d":"≤ 40 kg"},{"$f":"-INDIRECT(ADDRESS(ROW(),COLUMN()-1))","v":{"v":40,"d":"> 40 kg"}}]
["Sexe","Féminine","Masculin",null,null,"Pupilles",{"v":-30,"d":"≤ 30 kg"},{"v":-35,"d":"≤ 35 kg"},{"v":-40,"d":"≤ 40 kg"},{"v":-45,"d":"≤ 45 kg"},{"$f":"-INDIRECT(ADDRESS(ROW(),COLUMN()-1))","v":{"v":45,"d":"> 45 kg"}}]
[{"$nulls":5},"Benjamins",{"v":-35,"d":"≤ 35 kg"},{"v":-40,"d":"≤ 40 kg"},{"v":-45,"d":"≤ 45 kg"},{"v":-50,"d":"≤ 50 kg"},{"$f":"-INDIRECT(ADDRESS(ROW(),COLUMN()-1))","v":{"v":50,"d":"> 50 kg"}}]

{"sheet":"Catégories Technique KFK","index":1,"n_rows":13,"n_cols":10,"rows_kept":13,"hidden":true,"merged":[[1,4,3,4],[1,5,2,5],[7,5,9,5],[11,5,12,5]]}
["Technique",{"$nulls":5},"Mini-poussins","Poussins","Pupilles","Benjamins"]
[null,"Minimum","Maximum",null,"Mains nues","Taolu Individuel - Moderne","Changquan - Taolu < 32 mvts","Changquan - Taolu < 32 mvts","Changquan - Taolu ≈ 32 mvts","Changquan - Taolu ≈ 50 mvts"]
["Mini-poussins",4,5,{"$nulls":3},"Nanquan - Taolu < 32 mvts","Nanquan - Taolu < 32 mvts","Nanquan - Taolu ≈ 32 mvts","Nanquan - Taolu ≈ 50 mvts"]
["Poussins",6,7,null,null,"Taolu Individuel - Traditionnel","Style de Wushu traditionnel à mains nues","Style de Wushu traditionnel à mains nues","Style de Wushu traditionnel à mains nues","Style de Wushu traditionnel à mains nues"]
["Pupilles",8,9,null,"Armes Courtes","Taolu Individuel","Armes courtes sans disctinction de style","Armes courtes sans disctinction de style","Armes courtes sans disctinction de style","Armes courtes sans disctinction de style"]
["Benjamins",10,11,null,"Armes Longues","Taolu Individuel","Armes longues sans disctinction de style","Armes longues sans disctinction de style","Armes longues sans disctinction de style","Armes longues sans disctinction de style"]
[]
[{"$nulls":5},"Dui Lian","Mains nues(Túshǒuduìliàn)"]
[{"$nulls":6},"Avec armes(Qìxièduìliàn)"]
[{"$nulls":6},"Mixte(Túshǒuyǔqìxièduìliàn)"]
[]
[{"$nulls":5},"Jítxiàngmù","Jiti"]
[{"$nulls":6},"Taolu synchronisée"]

{"sheet":"Informations","index":2,"n_rows":14,"n_cols":11,"rows_kept":14,"merged":[[0,0,0,11],[2,0,2,2],[2,3,2,11],[3,0,3,2],[3,3,3,11],[4,0,4,2],[4,3,4,11],[5,0,5,2],[5,3,5,11],[6,0,6,2],[6,3,6,11],[7,0,7,2],[7,3,7,11],[8,0,8,2],[8,3,8,11],[9,0,9,2],[9,3,9,11],[11,3,11,5],[11,6,11,7],[11,8,11,9],[11,10,11,11],[12,0,12,2],[12,3,12,5],[12,6,12,7],[12,8,12,9],[12,10,12,11],[13,0,15,2],[13,3,13,5],[13,6,13,7],[13,8,13,9],[13,10,13,11],[14,3,14,5],[14,6,14,7],[14,8,14,9],[14,10,14,11],[15,3,15,5],[15,6,15,7],[15,8,15,9],[15,10,15,11]]}
["Trophée national KungFu Kids 12-13/12/2015\nCentre sportif Elisabeth, 7-15 Avenue Paul Appell, 75014 Paris, France"]
[]
["Nom du club :"]
["Numéro d'affilliation :"]
["Code Postal :"]
["Ville :"]
["Ligue :"]
["Zone Wushu :"]
["Téléphone :"]
["Courriel :"]
[]
[{"$nulls":3},"Nom",null,null,"Prénom",null,"N° Licence",null,"N° de mobile"]
["Représentant du club pour les contrôles :"]
["Coach(s) :"]

{"sheet":"Taolu individuel - KFK","index":3,"n_rows":71,"n_cols":15,"rows_kept":71}
[null,"Nom","Prénom","Numéro de licence","Sexe","Date de naissance","Catégorie d'age","Forme à mains nues","Forme avec arme courte","Forme avec arme longue",null,null,"TCR","LicOK","bdOk"]
[{"$f":"IF(K2=\"ü\",IF(ISNUMBER(A1),A1+1,1),\"\")","v":1},"a","a","12345687a","Masculin","2005-11-30",{"$f":"IF(OR(ISBLANK(E2),ISBLANK(F2)),\"\",INDEX(tabTL,MATCH(YEAR(TODAY())-YEAR(F2),INDEX(tabTL,,2)),1))","v":"Benjamins"},"Changquan - Taolu ≈ 50 mvts","Armes courtes sans disctinction de style",null,{"$f":"IFERROR(IF(AND(M2:O2),\"ü\",\"û\"),\"û\")","v":"ü"},{"$f":"COUNTA(B2:J2)","v":8},{"$f":"AND(L2>=7,L2<=9)","v":true},{"$f":"IF(LEN(D2)=9,AND(IFERROR(VALUE(LEFT(D2,8))>0,FALSE),ISTEXT(RIGHT(D2,1))),FALSE)","v":true},{"$f":"IFERROR(AND(F2>=DATE(YEAR(NOW())-VLOOKUP(G2,tabTL,3,FALSE),1,1),F2<=DATE(YEAR(NOW())-VLOOKUP(G2,tabTL,2,FALSE),12,31)),FALSE)","v":true}]
[2,"b","b","12354679b","Féminine","2010-12-31","Mini-poussins",null,null,"Armes longues sans disctinction de style","ü",7,{"$f":"AND(L3>=7,L3<=9)","v":true},true,true]
[3,"c","c","45678912c","Masculin","2004-01-01","Benjamins","Style de Wushu traditionnel à mains nues",null,null,"ü",7,true,true,true]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
[{"$f":"IF(K34=\"ü\",IF(ISNUMBER(A33),A33+1,1),\"\")","v":""},{"$nulls":5},"",{"$nulls":3},"û",{"$f":"COUNTA(B34:J34)","v":1},false,{"$f":"IF(LEN(D34)=9,AND(IFERROR(VALUE(LEFT(D34,8))>0,FALSE),ISTEXT(RIGHT(D34,1))),FALSE)","v":false},{"$f":"IFERROR(AND(F34>=DATE(YEAR(NOW())-VLOOKUP(G34,tabTL,3,FALSE),1,1),F34<=DATE(YEAR(NOW())-VLOOKUP(G34,tabTL,2,FALSE),12,31)),FALSE)","v":false}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
[{"$f":"IF(K66=\"ü\",IF(ISNUMBER(A65),A65+1,1),\"\")","v":""},{"$nulls":5},{"$f":"IF(OR(ISBLANK(E66),ISBLANK(F66)),\"\",INDEX(tabTL,MATCH(YEAR(TODAY())-YEAR(F66),INDEX(tabTL,,2)),1))","v":""},{"$nulls":3},"û",{"$f":"COUNTA(B66:J66)","v":1},false,false,{"$f":"IFERROR(AND(F66>=DATE(YEAR(NOW())-VLOOKUP(G66,tabTL,3,FALSE),1,1),F66<=DATE(YEAR(NOW())-VLOOKUP(G66,tabTL,2,FALSE),12,31)),FALSE)","v":false}]
["",{"$nulls":5},"",{"$nulls":3},{"$f":"IFERROR(IF(AND(M67:O67),\"ü\",\"û\"),\"û\")","v":"û"},1,{"$f":"AND(L67>=7,L67<=9)","v":false},{"$f":"IF(LEN(D67)=9,AND(IFERROR(VALUE(LEFT(D67,8))>0,FALSE),ISTEXT(RIGHT(D67,1))),FALSE)","v":false},false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,false]

{"sheet":"Dui lian","index":4,"n_rows":46,"n_cols":20,"rows_kept":46,"merged":[[1,0,3,0],[1,7,3,7],[1,8,3,8],[4,0,6,0],[4,7,6,7],[4,8,6,8],[7,0,9,0],[7,7,9,7],[7,8,9,8],[10,0,12,0],[10,7,12,7],[10,8,12,8],[13,0,15,0],[13,7,15,7],[13,8,15,8],[16,0,18,0],[16,7,18,7],[16,8,18,8],[19,0,21,0],[19,7,21,7],[19,8,21,8],[22,0,24,0],[22,7,24,7],[22,8,24,8],[25,0,27,0],[25,7,27,7],[25,8,27,8],[28,0,30,0],[28,7,30,7],[28,8,30,8],[31,0,33,0],[31,7,33,7],[31,8,33,8],[34,0,36,0],[34,7,36,7],[34,8,36,8],[37,0,39,0],[37,7,39,7],[37,8,39,8],[40,0,42,0],[40,7,42,7],[40,8,42,8],[43,0,45,0],[43,7,45,7],[43,8,45,8]]}
[null,"Nom","Prénom","Numéro de licence","Sexe","Date de naissance","Catégorie d'age","Forme",null,null,"TCR","LicOK","bdOk"]
[{"$f":"IF(I2=\"ü\",IF(ISNUMBER(A1),A1+1,1),\"\")","v":1},"a","a","12345687a","Masculin","2005-11-30",{"$f":"IF(OR(ISBLANK(E2),ISBLANK(F2)),\"\",INDEX(tabTL,MATCH(YEAR(TODAY())-YEAR(F2),INDEX(tabTL,,2)),1))","v":"Benjamins"},"Avec armes(Qìxièduìliàn)",{"$f":"IF(AND(IF(AND(K4:M4),K2:M4,IF(J4=1,K2:M3,FALSE)),T3:T4),\"ü\",\"û\")","v":"ü"},{"$f":"COUNTA(B2:G2,H2)","v":7},{"$f":"OR(J2=0,J2=7)","v":true},{"$f":"IF(LEN(D2)=9,AND(IFERROR(VALUE(LEFT(D2,8))>0,FALSE),ISTEXT(RIGHT(D2,1))),FALSE)","v":true},{"$f":"IF(K2,AND(F2>=DATE(YEAR(NOW())-VLOOKUP(G2,tabTL,3,FALSE),1,1),F2<=DATE(YEAR(NOW())-VLOOKUP(G2,tabTL,2,FALSE),12,31)),FALSE)","v":true},{"$f":"MATCH(G2,INDEX(tabTL,,1),0)","v":4},{"$f":"IF(N2=1,1,IF(N2=8,7,N2-1))-1","v":2},{"$f":"IF(N2=1,2,IF(N2=8,8,N2+1))","v":5},{"$f":"IF(OR(N2<O2,N2>P2),FALSE,TRUE)","v":true},{"$f":"IF(K4,MIN(N2:N4),MIN(N2:N3))","v":3},{"$f":"COUNTIF(N2:N4,R2)","v":1}]
[null,"b","b","12354679b","Féminine","2007-12-31","Pupilles",null,null,{"$f":"COUNTA(B3:G3)","v":6},{"$f":"OR(J3=0,J3=6)","v":true},{"$f":"IF(LEN(D3)=9,AND(IFERROR(VALUE(LEFT(D3,8))>0,FALSE),ISTEXT(RIGHT(D3,1))),FALSE)","v":true},true,3,{"$f":"IF(N2=N3,O2,MAX(N2:N3)-1)","v":3},{"$f":"MAX(N2:N3)","v":4},{"$f":"IF(OR(N3<O3,N3>P3),FALSE,TRUE)","v":true},{"$f":"IF(K4,MAX(N2:N4),MAX(N2:N3))","v":4},{"$f":"COUNTIF(N2:N4,R3)","v":2},{"$f":"(S3>=COUNT(N2:N4)-1)","v":true}]
[null,"c","c","45678945f","Masculin","2004-04-12","Benjamins",null,null,{"$f":"COUNTA(B4:G4)","v":6},{"$f":"OR(J4=0,J4=6)","v":true},{"$f":"IF(J4=0,TRUE,IF(LEN(D4)=9,AND(IFERROR(VALUE(LEFT(D4,8))>0,FALSE),ISTEXT(RIGHT(D4,1))),FALSE))","v":true},true,4,{"$f":"IF(N3=N4,O3,MAX(N2:N4)-1)","v":3},{"$f":"MAX(N2:N4)","v":4},{"$f":"IF(N4=\"\",TRUE,IF(OR(N4<O4,N4>P4),FALSE,TRUE))","v":true},{"$f":"R3-R2","v":1},{"$f":"IF(R4=1,S2+S3,3)","v":3},{"$f":"IFERROR(R4<=1,FALSE)","v":true}]
[{"$f":"IF(I5=\"ü\",IF(ISNUMBER(A2),A2+1,1),\"\")","v":""},{"$nulls":5},"",null,{"$f":"IF(AND(IF(AND(K7:M7),K5:M7,IF(J7=1,K5:M6,FALSE)),T6:T7),\"ü\",\"û\")","v":"û"},{"$f":"COUNTA(B5:G5,H5)","v":1},{"$f":"OR(J5=0,J5=7)","v":false},{"$f":"IF(LEN(D5)=9,AND(IFERROR(VALUE(LEFT(D5,8))>0,FALSE),ISTEXT(RIGHT(D5,1))),FALSE)","v":false},false,{"$f":"MATCH(G5,INDEX(tabTL,,1),0)","v":{"$error":"#N/A"}},{"$f":"IF(N5=1,1,IF(N5=8,7,N5-1))-1","v":{"$error":"#N/A"}},{"$f":"IF(N5=1,2,IF(N5=8,8,N5+1))","v":{"$error":"#N/A"}},{"$f":"IF(OR(N5<O5,N5>P5),FALSE,TRUE)","v":{"$error":"#N/A"}},{"$f":"IF(K7,MIN(N5:N7),MIN(N5:N6))","v":{"$error":"#N/A"}},{"$f":"COUNTIF(N5:N7,R5)","v":3}]
[{"$nulls":6},"",null,null,{"$f":"COUNTA(B6:G6)","v":1},{"$f":"OR(J6=0,J6=6)","v":false},false,false,{"$error":"#N/A"},{"$f":"IF(N5=N6,O5,MAX(N5:N6)-1)","v":{"$error":"#N/A"}},{"$f":"MAX(N5:N6)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(K7,MAX(N5:N7),MAX(N5:N6))","v":{"$error":"#N/A"}},{"$f":"COUNTIF(N5:N7,R6)","v":3},{"$f":"(S6>=COUNT(N5:N7)-1)","v":true}]
[{"$nulls":6},"",null,null,1,false,{"$f":"IF(J7=0,TRUE,IF(LEN(D7)=9,AND(IFERROR(VALUE(LEFT(D7,8))>0,FALSE),ISTEXT(RIGHT(D7,1))),FALSE))","v":false},false,{"$error":"#N/A"},{"$f":"IF(N6=N7,O6,MAX(N5:N7)-1)","v":{"$error":"#N/A"}},{"$f":"MAX(N5:N7)","v":{"$error":"#N/A"}},{"$f":"IF(N7=\"\",TRUE,IF(OR(N7<O7,N7>P7),FALSE,TRUE))","v":{"$error":"#N/A"}},{"$f":"R6-R5","v":{"$error":"#N/A"}},{"$f":"IF(R7=1,S5+S6,3)","v":{"$error":"#N/A"}},{"$f":"IFERROR(R7<=1,FALSE)","v":false}]
[{"$f":"IF(I8=\"ü\",IF(ISNUMBER(A5),A5+1,1),\"\")","v":""},{"$nulls":5},"",null,{"$f":"IF(AND(IF(AND(K10:M10),K8:M10,IF(J10=1,K8:M9,FALSE)),T9:T10),\"ü\",\"û\")","v":"û"},{"$f":"COUNTA(B8:G8,H8)","v":1},{"$f":"OR(J8=0,J8=7)","v":false},{"$f":"IF(LEN(D8)=9,AND(IFERROR(VALUE(LEFT(D8,8))>0,FALSE),ISTEXT(RIGHT(D8,1))),FALSE)","v":false},false,{"$error":"#N/A"},{"$f":"IF(N8=1,1,IF(N8=8,7,N8-1))-1","v":{"$error":"#N/A"}},{"$f":"IF(N8=1,2,IF(N8=8,8,N8+1))","v":{"$error":"#N/A"}},{"$f":"IF(OR(N8<O8,N8>P8),FALSE,TRUE)","v":{"$error":"#N/A"}},{"$f":"IF(K10,MIN(N8:N10),MIN(N8:N9))","v":{"$error":"#N/A"}},{"$f":"COUNTIF(N8:N10,R8)","v":3}]
[{"$nulls":6},"",null,null,{"$f":"COUNTA(B9:G9)","v":1},{"$f":"OR(J9=0,J9=6)","v":false},false,false,{"$error":"#N/A"},{"$f":"IF(N8=N9,O8,MAX(N8:N9)-1)","v":{"$error":"#N/A"}},{"$f":"MAX(N8:N9)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(K10,MAX(N8:N10),MAX(N8:N9))","v":{"$error":"#N/A"}},{"$f":"COUNTIF(N8:N10,R9)","v":3},{"$f":"(S9>=COUNT(N8:N10)-1)","v":true}]
[{"$nulls":6},"",null,null,1,false,{"$f":"IF(J10=0,TRUE,IF(LEN(D10)=9,AND(IFERROR(VALUE(LEFT(D10,8))>0,FALSE),ISTEXT(RIGHT(D10,1))),FALSE))","v":false},false,{"$error":"#N/A"},{"$f":"IF(N9=N10,O9,MAX(N8:N10)-1)","v":{"$error":"#N/A"}},{"$f":"MAX(N8:N10)","v":{"$error":"#N/A"}},{"$f":"IF(N10=\"\",TRUE,IF(OR(N10<O10,N10>P10),FALSE,TRUE))","v":{"$error":"#N/A"}},{"$f":"R9-R8","v":{"$error":"#N/A"}},{"$f":"IF(R10=1,S8+S9,3)","v":{"$error":"#N/A"}},{"$f":"IFERROR(R10<=1,FALSE)","v":false}]
[{"$f":"IF(I11=\"ü\",IF(ISNUMBER(A8),A8+1,1),\"\")","v":""},{"$nulls":5},"",null,{"$f":"IF(AND(IF(AND(K13:M13),K11:M13,IF(J13=1,K11:M12,FALSE)),T12:T13),\"ü\",\"û\")","v":"û"},{"$f":"COUNTA(B11:G11,H11)","v":1},{"$f":"OR(J11=0,J11=7)","v":false},{"$f":"IF(LEN(D11)=9,AND(IFERROR(VALUE(LEFT(D11,8))>0,FALSE),ISTEXT(RIGHT(D11,1))),FALSE)","v":false},false,{"$error":"#N/A"},{"$f":"IF(N11=1,1,IF(N11=8,7,N11-1))-1","v":{"$error":"#N/A"}},{"$f":"IF(N11=1,2,IF(N11=8,8,N11+1))","v":{"$error":"#N/A"}},{"$f":"IF(OR(N11<O11,N11>P11),FALSE,TRUE)","v":{"$error":"#N/A"}},{"$f":"IF(K13,MIN(N11:N13),MIN(N11:N12))","v":{"$error":"#N/A"}},{"$f":"COUNTIF(N11:N13,R11)","v":3}]
[{"$nulls":6},"",null,null,{"$f":"COUNTA(B12:G12)","v":1},{"$f":"OR(J12=0,J12=6)","v":false},false,false,{"$error":"#N/A"},{"$f":"IF(N11=N12,O11,MAX(N11:N12)-1)","v":{"$error":"#N/A"}},{"$f":"MAX(N11:N12)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(K13,MAX(N11:N13),MAX(N11:N12))","v":{"$error":"#N/A"}},{"$f":"COUNTIF(N11:N13,R12)","v":3},{"$f":"(S12>=COUNT(N11:N13)-1)","v":true}]
[{"$nulls":6},"",null,null,1,false,{"$f":"IF(J13=0,TRUE,IF(LEN(D13)=9,AND(IFERROR(VALUE(LEFT(D13,8))>0,FALSE),ISTEXT(RIGHT(D13,1))),FALSE))","v":false},false,{"$error":"#N/A"},{"$f":"IF(N12=N13,O12,MAX(N11:N13)-1)","v":{"$error":"#N/A"}},{"$f":"MAX(N11:N13)","v":{"$error":"#N/A"}},{"$f":"IF(N13=\"\",TRUE,IF(OR(N13<O13,N13>P13),FALSE,TRUE))","v":{"$error":"#N/A"}},{"$f":"R12-R11","v":{"$error":"#N/A"}},{"$f":"IF(R13=1,S11+S12,3)","v":{"$error":"#N/A"}},{"$f":"IFERROR(R13<=1,FALSE)","v":false}]
[{"$f":"IF(I14=\"ü\",IF(ISNUMBER(A11),A11+1,1),\"\")","v":""},{"$nulls":5},"",null,{"$f":"IF(AND(IF(AND(K16:M16),K14:M16,IF(J16=1,K14:M15,FALSE)),T15:T16),\"ü\",\"û\")","v":"û"},{"$f":"COUNTA(B14:G14,H14)","v":1},{"$f":"OR(J14=0,J14=7)","v":false},{"$f":"IF(LEN(D14)=9,AND(IFERROR(VALUE(LEFT(D14,8))>0,FALSE),ISTEXT(RIGHT(D14,1))),FALSE)","v":false},false,{"$error":"#N/A"},{"$f":"IF(N14=1,1,IF(N14=8,7,N14-1))-1","v":{"$error":"#N/A"}},{"$f":"IF(N14=1,2,IF(N14=8,8,N14+1))","v":{"$error":"#N/A"}},{"$f":"IF(OR(N14<O14,N14>P14),FALSE,TRUE)","v":{"$error":"#N/A"}},{"$f":"IF(K16,MIN(N14:N16),MIN(N14:N15))","v":{"$error":"#N/A"}},{"$f":"COUNTIF(N14:N16,R14)","v":3}]
[{"$nulls":6},"",null,null,{"$f":"COUNTA(B15:G15)","v":1},{"$f":"OR(J15=0,J15=6)","v":false},false,false,{"$error":"#N/A"},{"$f":"IF(N14=N15,O14,MAX(N14:N15)-1)","v":{"$error":"#N/A"}},{"$f":"MAX(N14:N15)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(K16,MAX(N14:N16),MAX(N14:N15))","v":{"$error":"#N/A"}},{"$f":"COUNTIF(N14:N16,R15)","v":3},{"$f":"(S15>=COUNT(N14:N16)-1)","v":true}]
[{"$nulls":6},"",null,null,1,false,{"$f":"IF(J16=0,TRUE,IF(LEN(D16)=9,AND(IFERROR(VALUE(LEFT(D16,8))>0,FALSE),ISTEXT(RIGHT(D16,1))),FALSE))","v":false},false,{"$error":"#N/A"},{"$f":"IF(N15=N16,O15,MAX(N14:N16)-1)","v":{"$error":"#N/A"}},{"$f":"MAX(N14:N16)","v":{"$error":"#N/A"}},{"$f":"IF(N16=\"\",TRUE,IF(OR(N16<O16,N16>P16),FALSE,TRUE))","v":{"$error":"#N/A"}},{"$f":"R15-R14","v":{"$error":"#N/A"}},{"$f":"IF(R16=1,S14+S15,3)","v":{"$error":"#N/A"}},{"$f":"IFERROR(R16<=1,FALSE)","v":false}]
[{"$f":"IF(I17=\"ü\",IF(ISNUMBER(A14),A14+1,1),\"\")","v":""},{"$nulls":5},"",null,{"$f":"IF(AND(IF(AND(K19:M19),K17:M19,IF(J19=1,K17:M18,FALSE)),T18:T19),\"ü\",\"û\")","v":"û"},{"$f":"COUNTA(B17:G17,H17)","v":1},{"$f":"OR(J17=0,J17=7)","v":false},{"$f":"IF(LEN(D17)=9,AND(IFERROR(VALUE(LEFT(D17,8))>0,FALSE),ISTEXT(RIGHT(D17,1))),FALSE)","v":false},false,{"$error":"#N/A"},{"$f":"IF(N17=1,1,IF(N17=8,7,N17-1))-1","v":{"$error":"#N/A"}},{"$f":"IF(N17=1,2,IF(N17=8,8,N17+1))","v":{"$error":"#N/A"}},{"$f":"IF(OR(N17<O17,N17>P17),FALSE,TRUE)","v":{"$error":"#N/A"}},{"$f":"IF(K19,MIN(N17:N19),MIN(N17:N18))","v":{"$error":"#N/A"}},{"$f":"COUNTIF(N17:N19,R17)","v":3}]
[{"$nulls":6},"",null,null,{"$f":"COUNTA(B18:G18)","v":1},{"$f":"OR(J18=0,J18=6)","v":false},false,false,{"$error":"#N/A"},{"$f":"IF(N17=N18,O17,MAX(N17:N18)-1)","v":{"$error":"#N/A"}},{"$f":"MAX(N17:N18)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(K19,MAX(N17:N19),MAX(N17:N18))","v":{"$error":"#N/A"}},{"$f":"COUNTIF(N17:N19,R18)","v":3},{"$f":"(S18>=COUNT(N17:N19)-1)","v":true}]
[{"$nulls":6},"",null,null,1,false,{"$f":"IF(J19=0,TRUE,IF(LEN(D19)=9,AND(IFERROR(VALUE(LEFT(D19,8))>0,FALSE),ISTEXT(RIGHT(D19,1))),FALSE))","v":false},false,{"$error":"#N/A"},{"$f":"IF(N18=N19,O18,MAX(N17:N19)-1)","v":{"$error":"#N/A"}},{"$f":"MAX(N17:N19)","v":{"$error":"#N/A"}},{"$f":"IF(N19=\"\",TRUE,IF(OR(N19<O19,N19>P19),FALSE,TRUE))","v":{"$error":"#N/A"}},{"$f":"R18-R17","v":{"$error":"#N/A"}},{"$f":"IF(R19=1,S17+S18,3)","v":{"$error":"#N/A"}},{"$f":"IFERROR(R19<=1,FALSE)","v":false}]
[{"$f":"IF(I20=\"ü\",IF(ISNUMBER(A17),A17+1,1),\"\")","v":""},{"$nulls":5},"",null,{"$f":"IF(AND(IF(AND(K22:M22),K20:M22,IF(J22=1,K20:M21,FALSE)),T21:T22),\"ü\",\"û\")","v":"û"},{"$f":"COUNTA(B20:G20,H20)","v":1},{"$f":"OR(J20=0,J20=7)","v":false},{"$f":"IF(LEN(D20)=9,AND(IFERROR(VALUE(LEFT(D20,8))>0,FALSE),ISTEXT(RIGHT(D20,1))),FALSE)","v":false},false,{"$error":"#N/A"},{"$f":"IF(N20=1,1,IF(N20=8,7,N20-1))-1","v":{"$error":"#N/A"}},{"$f":"IF(N20=1,2,IF(N20=8,8,N20+1))","v":{"$error":"#N/A"}},{"$f":"IF(OR(N20<O20,N20>P20),FALSE,TRUE)","v":{"$error":"#N/A"}},{"$f":"IF(K22,MIN(N20:N22),MIN(N20:N21))","v":{"$error":"#N/A"}},{"$f":"COUNTIF(N20:N22,R20)","v":3}]
[{"$nulls":6},"",null,null,{"$f":"COUNTA(B21:G21)","v":1},{"$f":"OR(J21=0,J21=6)","v":false},false,false,{"$error":"#N/A"},{"$f":"IF(N20=N21,O20,MAX(N20:N21)-1)","v":{"$error":"#N/A"}},{"$f":"MAX(N20:N21)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(K22,MAX(N20:N22),MAX(N20:N21))","v":{"$error":"#N/A"}},{"$f":"COUNTIF(N20:N22,R21)","v":3},{"$f":"(S21>=COUNT(N20:N22)-1)","v":true}]
[{"$nulls":6},"",null,null,1,false,{"$f":"IF(J22=0,TRUE,IF(LEN(D22)=9,AND(IFERROR(VALUE(LEFT(D22,8))>0,FALSE),ISTEXT(RIGHT(D22,1))),FALSE))","v":false},false,{"$error":"#N/A"},{"$f":"IF(N21=N22,O21,MAX(N20:N22)-1)","v":{"$error":"#N/A"}},{"$f":"MAX(N20:N22)","v":{"$error":"#N/A"}},{"$f":"IF(N22=\"\",TRUE,IF(OR(N22<O22,N22>P22),FALSE,TRUE))","v":{"$error":"#N/A"}},{"$f":"R21-R20","v":{"$error":"#N/A"}},{"$f":"IF(R22=1,S20+S21,3)","v":{"$error":"#N/A"}},{"$f":"IFERROR(R22<=1,FALSE)","v":false}]
[{"$f":"IF(I23=\"ü\",IF(ISNUMBER(A20),A20+1,1),\"\")","v":""},{"$nulls":5},"",null,{"$f":"IF(AND(IF(AND(K25:M25),K23:M25,IF(J25=1,K23:M24,FALSE)),T24:T25),\"ü\",\"û\")","v":"û"},{"$f":"COUNTA(B23:G23,H23)","v":1},{"$f":"OR(J23=0,J23=7)","v":false},{"$f":"IF(LEN(D23)=9,AND(IFERROR(VALUE(LEFT(D23,8))>0,FALSE),ISTEXT(RIGHT(D23,1))),FALSE)","v":false},false,{"$error":"#N/A"},{"$f":"IF(N23=1,1,IF(N23=8,7,N23-1))-1","v":{"$error":"#N/A"}},{"$f":"IF(N23=1,2,IF(N23=8,8,N23+1))","v":{"$error":"#N/A"}},{"$f":"IF(OR(N23<O23,N23>P23),FALSE,TRUE)","v":{"$error":"#N/A"}},{"$f":"IF(K25,MIN(N23:N25),MIN(N23:N24))","v":{"$error":"#N/A"}},{"$f":"COUNTIF(N23:N25,R23)","v":3}]
[{"$nulls":6},"",null,null,{"$f":"COUNTA(B24:G24)","v":1},{"$f":"OR(J24=0,J24=6)","v":false},false,false,{"$error":"#N/A"},{"$f":"IF(N23=N24,O23,MAX(N23:N24)-1)","v":{"$error":"#N/A"}},{"$f":"MAX(N23:N24)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(K25,MAX(N23:N25),MAX(N23:N24))","v":{"$error":"#N/A"}},{"$f":"COUNTIF(N23:N25,R24)","v":3},{"$f":"(S24>=COUNT(N23:N25)-1)","v":true}]
[{"$nulls":6},"",null,null,1,false,{"$f":"IF(J25=0,TRUE,IF(LEN(D25)=9,AND(IFERROR(VALUE(LEFT(D25,8))>0,FALSE),ISTEXT(RIGHT(D25,1))),FALSE))","v":false},false,{"$error":"#N/A"},{"$f":"IF(N24=N25,O24,MAX(N23:N25)-1)","v":{"$error":"#N/A"}},{"$f":"MAX(N23:N25)","v":{"$error":"#N/A"}},{"$f":"IF(N25=\"\",TRUE,IF(OR(N25<O25,N25>P25),FALSE,TRUE))","v":{"$error":"#N/A"}},{"$f":"R24-R23","v":{"$error":"#N/A"}},{"$f":"IF(R25=1,S23+S24,3)","v":{"$error":"#N/A"}},{"$f":"IFERROR(R25<=1,FALSE)","v":false}]
[{"$f":"IF(I26=\"ü\",IF(ISNUMBER(A23),A23+1,1),\"\")","v":""},{"$nulls":5},"",null,{"$f":"IF(AND(IF(AND(K28:M28),K26:M28,IF(J28=1,K26:M27,FALSE)),T27:T28),\"ü\",\"û\")","v":"û"},{"$f":"COUNTA(B26:G26,H26)","v":1},{"$f":"OR(J26=0,J26=7)","v":false},{"$f":"IF(LEN(D26)=9,AND(IFERROR(VALUE(LEFT(D26,8))>0,FALSE),ISTEXT(RIGHT(D26,1))),FALSE)","v":false},false,{"$error":"#N/A"},{"$f":"IF(N26=1,1,IF(N26=8,7,N26-1))-1","v":{"$error":"#N/A"}},{"$f":"IF(N26=1,2,IF(N26=8,8,N26+1))","v":{"$error":"#N/A"}},{"$f":"IF(OR(N26<O26,N26>P26),FALSE,TRUE)","v":{"$error":"#N/A"}},{"$f":"IF(K28,MIN(N26:N28),MIN(N26:N27))","v":{"$error":"#N/A"}},{"$f":"COUNTIF(N26:N28,R26)","v":3}]
[{"$nulls":6},"",null,null,{"$f":"COUNTA(B27:G27)","v":1},{"$f":"OR(J27=0,J27=6)","v":false},false,false,{"$error":"#N/A"},{"$f":"IF(N26=N27,O26,MAX(N26:N27)-1)","v":{"$error":"#N/A"}},{"$f":"MAX(N26:N27)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(K28,MAX(N26:N28),MAX(N26:N27))","v":{"$error":"#N/A"}},{"$f":"COUNTIF(N26:N28,R27)","v":3},{"$f":"(S27>=COUNT(N26:N28)-1)","v":true}]
[{"$nulls":6},"",null,null,1,false,{"$f":"IF(J28=0,TRUE,IF(LEN(D28)=9,AND(IFERROR(VALUE(LEFT(D28,8))>0,FALSE),ISTEXT(RIGHT(D28,1))),FALSE))","v":false},false,{"$error":"#N/A"},{"$f":"IF(N27=N28,O27,MAX(N26:N28)-1)","v":{"$error":"#N/A"}},{"$f":"MAX(N26:N28)","v":{"$error":"#N/A"}},{"$f":"IF(N28=\"\",TRUE,IF(OR(N28<O28,N28>P28),FALSE,TRUE))","v":{"$error":"#N/A"}},{"$f":"R27-R26","v":{"$error":"#N/A"}},{"$f":"IF(R28=1,S26+S27,3)","v":{"$error":"#N/A"}},{"$f":"IFERROR(R28<=1,FALSE)","v":false}]
[{"$f":"IF(I29=\"ü\",IF(ISNUMBER(A26),A26+1,1),\"\")","v":""},{"$nulls":5},"",null,{"$f":"IF(AND(IF(AND(K31:M31),K29:M31,IF(J31=1,K29:M30,FALSE)),T30:T31),\"ü\",\"û\")","v":"û"},{"$f":"COUNTA(B29:G29,H29)","v":1},{"$f":"OR(J29=0,J29=7)","v":false},{"$f":"IF(LEN(D29)=9,AND(IFERROR(VALUE(LEFT(D29,8))>0,FALSE),ISTEXT(RIGHT(D29,1))),FALSE)","v":false},false,{"$error":"#N/A"},{"$f":"IF(N29=1,1,IF(N29=8,7,N29-1))-1","v":{"$error":"#N/A"}},{"$f":"IF(N29=1,2,IF(N29=8,8,N29+1))","v":{"$error":"#N/A"}},{"$f":"IF(OR(N29<O29,N29>P29),FALSE,TRUE)","v":{"$error":"#N/A"}},{"$f":"IF(K31,MIN(N29:N31),MIN(N29:N30))","v":{"$error":"#N/A"}},{"$f":"COUNTIF(N29:N31,R29)","v":3}]
[{"$nulls":6},"",null,null,{"$f":"COUNTA(B30:G30)","v":1},{"$f":"OR(J30=0,J30=6)","v":false},false,false,{"$error":"#N/A"},{"$f":"IF(N29=N30,O29,MAX(N29:N30)-1)","v":{"$error":"#N/A"}},{"$f":"MAX(N29:N30)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(K31,MAX(N29:N31),MAX(N29:N30))","v":{"$error":"#N/A"}},{"$f":"COUNTIF(N29:N31,R30)","v":3},{"$f":"(S30>=COUNT(N29:N31)-1)","v":true}]
[{"$nulls":6},"",null,null,1,false,{"$f":"IF(J31=0,TRUE,IF(LEN(D31)=9,AND(IFERROR(VALUE(LEFT(D31,8))>0,FALSE),ISTEXT(RIGHT(D31,1))),FALSE))","v":false},false,{"$error":"#N/A"},{"$f":"IF(N30=N31,O30,MAX(N29:N31)-1)","v":{"$error":"#N/A"}},{"$f":"MAX(N29:N31)","v":{"$error":"#N/A"}},{"$f":"IF(N31=\"\",TRUE,IF(OR(N31<O31,N31>P31),FALSE,TRUE))","v":{"$error":"#N/A"}},{"$f":"R30-R29","v":{"$error":"#N/A"}},{"$f":"IF(R31=1,S29+S30,3)","v":{"$error":"#N/A"}},{"$f":"IFERROR(R31<=1,FALSE)","v":false}]
[{"$f":"IF(I32=\"ü\",IF(ISNUMBER(A29),A29+1,1),\"\")","v":""},{"$nulls":5},"",null,{"$f":"IF(AND(IF(AND(K34:M34),K32:M34,IF(J34=1,K32:M33,FALSE)),T33:T34),\"ü\",\"û\")","v":"û"},{"$f":"COUNTA(B32:G32,H32)","v":1},{"$f":"OR(J32=0,J32=7)","v":false},{"$f":"IF(LEN(D32)=9,AND(IFERROR(VALUE(LEFT(D32,8))>0,FALSE),ISTEXT(RIGHT(D32,1))),FALSE)","v":false},false,{"$error":"#N/A"},{"$f":"IF(N32=1,1,IF(N32=8,7,N32-1))-1","v":{"$error":"#N/A"}},{"$f":"IF(N32=1,2,IF(N32=8,8,N32+1))","v":{"$error":"#N/A"}},{"$f":"IF(OR(N32<O32,N32>P32),FALSE,TRUE)","v":{"$error":"#N/A"}},{"$f":"IF(K34,MIN(N32:N34),MIN(N32:N33))","v":{"$error":"#N/A"}},{"$f":"COUNTIF(N32:N34,R32)","v":3}]
[{"$nulls":6},"",null,null,{"$f":"COUNTA(B33:G33)","v":1},{"$f":"OR(J33=0,J33=6)","v":false},false,false,{"$error":"#N/A"},{"$f":"IF(N32=N33,O32,MAX(N32:N33)-1)","v":{"$error":"#N/A"}},{"$f":"MAX(N32:N33)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(K34,MAX(N32:N34),MAX(N32:N33))","v":{"$error":"#N/A"}},{"$f":"COUNTIF(N32:N34,R33)","v":3},{"$f":"(S33>=COUNT(N32:N34)-1)","v":true}]
[{"$nulls":6},"",null,null,1,false,{"$f":"IF(J34=0,TRUE,IF(LEN(D34)=9,AND(IFERROR(VALUE(LEFT(D34,8))>0,FALSE),ISTEXT(RIGHT(D34,1))),FALSE))","v":false},false,{"$error":"#N/A"},{"$f":"IF(N33=N34,O33,MAX(N32:N34)-1)","v":{"$error":"#N/A"}},{"$f":"MAX(N32:N34)","v":{"$error":"#N/A"}},{"$f":"IF(N34=\"\",TRUE,IF(OR(N34<O34,N34>P34),FALSE,TRUE))","v":{"$error":"#N/A"}},{"$f":"R33-R32","v":{"$error":"#N/A"}},{"$f":"IF(R34=1,S32+S33,3)","v":{"$error":"#N/A"}},{"$f":"IFERROR(R34<=1,FALSE)","v":false}]
[{"$f":"IF(I35=\"ü\",IF(ISNUMBER(A32),A32+1,1),\"\")","v":""},{"$nulls":5},"",null,{"$f":"IF(AND(IF(AND(K37:M37),K35:M37,IF(J37=1,K35:M36,FALSE)),T36:T37),\"ü\",\"û\")","v":"û"},{"$f":"COUNTA(B35:G35,H35)","v":1},{"$f":"OR(J35=0,J35=7)","v":false},{"$f":"IF(LEN(D35)=9,AND(IFERROR(VALUE(LEFT(D35,8))>0,FALSE),ISTEXT(RIGHT(D35,1))),FALSE)","v":false},false,{"$error":"#N/A"},{"$f":"IF(N35=1,1,IF(N35=8,7,N35-1))-1","v":{"$error":"#N/A"}},{"$f":"IF(N35=1,2,IF(N35=8,8,N35+1))","v":{"$error":"#N/A"}},{"$f":"IF(OR(N35<O35,N35>P35),FALSE,TRUE)","v":{"$error":"#N/A"}},{"$f":"IF(K37,MIN(N35:N37),MIN(N35:N36))","v":{"$error":"#N/A"}},{"$f":"COUNTIF(N35:N37,R35)","v":3}]
[{"$nulls":6},"",null,null,{"$f":"COUNTA(B36:G36)","v":1},{"$f":"OR(J36=0,J36=6)","v":false},false,false,{"$error":"#N/A"},{"$f":"IF(N35=N36,O35,MAX(N35:N36)-1)","v":{"$error":"#N/A"}},{"$f":"MAX(N35:N36)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(K37,MAX(N35:N37),MAX(N35:N36))","v":{"$error":"#N/A"}},{"$f":"COUNTIF(N35:N37,R36)","v":3},{"$f":"(S36>=COUNT(N35:N37)-1)","v":true}]
[{"$nulls":6},"",null,null,1,false,{"$f":"IF(J37=0,TRUE,IF(LEN(D37)=9,AND(IFERROR(VALUE(LEFT(D37,8))>0,FALSE),ISTEXT(RIGHT(D37,1))),FALSE))","v":false},false,{"$error":"#N/A"},{"$f":"IF(N36=N37,O36,MAX(N35:N37)-1)","v":{"$error":"#N/A"}},{"$f":"MAX(N35:N37)","v":{"$error":"#N/A"}},{"$f":"IF(N37=\"\",TRUE,IF(OR(N37<O37,N37>P37),FALSE,TRUE))","v":{"$error":"#N/A"}},{"$f":"R36-R35","v":{"$error":"#N/A"}},{"$f":"IF(R37=1,S35+S36,3)","v":{"$error":"#N/A"}},{"$f":"IFERROR(R37<=1,FALSE)","v":false}]
[{"$f":"IF(I38=\"ü\",IF(ISNUMBER(A35),A35+1,1),\"\")","v":""},{"$nulls":5},"",null,{"$f":"IF(AND(IF(AND(K40:M40),K38:M40,IF(J40=1,K38:M39,FALSE)),T39:T40),\"ü\",\"û\")","v":"û"},{"$f":"COUNTA(B38:G38,H38)","v":1},{"$f":"OR(J38=0,J38=7)","v":false},{"$f":"IF(LEN(D38)=9,AND(IFERROR(VALUE(LEFT(D38,8))>0,FALSE),ISTEXT(RIGHT(D38,1))),FALSE)","v":false},false,{"$error":"#N/A"},{"$f":"IF(N38=1,1,IF(N38=8,7,N38-1))-1","v":{"$error":"#N/A"}},{"$f":"IF(N38=1,2,IF(N38=8,8,N38+1))","v":{"$error":"#N/A"}},{"$f":"IF(OR(N38<O38,N38>P38),FALSE,TRUE)","v":{"$error":"#N/A"}},{"$f":"IF(K40,MIN(N38:N40),MIN(N38:N39))","v":{"$error":"#N/A"}},{"$f":"COUNTIF(N38:N40,R38)","v":3}]
[{"$nulls":6},"",null,null,{"$f":"COUNTA(B39:G39)","v":1},{"$f":"OR(J39=0,J39=6)","v":false},false,false,{"$error":"#N/A"},{"$f":"IF(N38=N39,O38,MAX(N38:N39)-1)","v":{"$error":"#N/A"}},{"$f":"MAX(N38:N39)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(K40,MAX(N38:N40),MAX(N38:N39))","v":{"$error":"#N/A"}},{"$f":"COUNTIF(N38:N40,R39)","v":3},{"$f":"(S39>=COUNT(N38:N40)-1)","v":true}]
[{"$nulls":6},"",null,null,1,false,{"$f":"IF(J40=0,TRUE,IF(LEN(D40)=9,AND(IFERROR(VALUE(LEFT(D40,8))>0,FALSE),ISTEXT(RIGHT(D40,1))),FALSE))","v":false},false,{"$error":"#N/A"},{"$f":"IF(N39=N40,O39,MAX(N38:N40)-1)","v":{"$error":"#N/A"}},{"$f":"MAX(N38:N40)","v":{"$error":"#N/A"}},{"$f":"IF(N40=\"\",TRUE,IF(OR(N40<O40,N40>P40),FALSE,TRUE))","v":{"$error":"#N/A"}},{"$f":"R39-R38","v":{"$error":"#N/A"}},{"$f":"IF(R40=1,S38+S39,3)","v":{"$error":"#N/A"}},{"$f":"IFERROR(R40<=1,FALSE)","v":false}]
[{"$f":"IF(I41=\"ü\",IF(ISNUMBER(A38),A38+1,1),\"\")","v":""},{"$nulls":5},"",null,{"$f":"IF(AND(IF(AND(K43:M43),K41:M43,IF(J43=1,K41:M42,FALSE)),T42:T43),\"ü\",\"û\")","v":"û"},{"$f":"COUNTA(B41:G41,H41)","v":1},{"$f":"OR(J41=0,J41=7)","v":false},{"$f":"IF(LEN(D41)=9,AND(IFERROR(VALUE(LEFT(D41,8))>0,FALSE),ISTEXT(RIGHT(D41,1))),FALSE)","v":false},false,{"$error":"#N/A"},{"$f":"IF(N41=1,1,IF(N41=8,7,N41-1))-1","v":{"$error":"#N/A"}},{"$f":"IF(N41=1,2,IF(N41=8,8,N41+1))","v":{"$error":"#N/A"}},{"$f":"IF(OR(N41<O41,N41>P41),FALSE,TRUE)","v":{"$error":"#N/A"}},{"$f":"IF(K43,MIN(N41:N43),MIN(N41:N42))","v":{"$error":"#N/A"}},{"$f":"COUNTIF(N41:N43,R41)","v":3}]
[{"$nulls":6},"",null,null,{"$f":"COUNTA(B42:G42)","v":1},{"$f":"OR(J42=0,J42=6)","v":false},false,false,{"$error":"#N/A"},{"$f":"IF(N41=N42,O41,MAX(N41:N42)-1)","v":{"$error":"#N/A"}},{"$f":"MAX(N41:N42)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(K43,MAX(N41:N43),MAX(N41:N42))","v":{"$error":"#N/A"}},{"$f":"COUNTIF(N41:N43,R42)","v":3},{"$f":"(S42>=COUNT(N41:N43)-1)","v":true}]
[{"$nulls":6},"",null,null,1,false,{"$f":"IF(J43=0,TRUE,IF(LEN(D43)=9,AND(IFERROR(VALUE(LEFT(D43,8))>0,FALSE),ISTEXT(RIGHT(D43,1))),FALSE))","v":false},false,{"$error":"#N/A"},{"$f":"IF(N42=N43,O42,MAX(N41:N43)-1)","v":{"$error":"#N/A"}},{"$f":"MAX(N41:N43)","v":{"$error":"#N/A"}},{"$f":"IF(N43=\"\",TRUE,IF(OR(N43<O43,N43>P43),FALSE,TRUE))","v":{"$error":"#N/A"}},{"$f":"R42-R41","v":{"$error":"#N/A"}},{"$f":"IF(R43=1,S41+S42,3)","v":{"$error":"#N/A"}},{"$f":"IFERROR(R43<=1,FALSE)","v":false}]
[{"$f":"IF(I44=\"ü\",IF(ISNUMBER(A41),A41+1,1),\"\")","v":""},{"$nulls":5},"",null,{"$f":"IF(AND(IF(AND(K46:M46),K44:M46,IF(J46=1,K44:M45,FALSE)),T45:T46),\"ü\",\"û\")","v":"û"},{"$f":"COUNTA(B44:G44,H44)","v":1},{"$f":"OR(J44=0,J44=7)","v":false},{"$f":"IF(LEN(D44)=9,AND(IFERROR(VALUE(LEFT(D44,8))>0,FALSE),ISTEXT(RIGHT(D44,1))),FALSE)","v":false},false,{"$error":"#N/A"},{"$f":"IF(N44=1,1,IF(N44=8,7,N44-1))-1","v":{"$error":"#N/A"}},{"$f":"IF(N44=1,2,IF(N44=8,8,N44+1))","v":{"$error":"#N/A"}},{"$f":"IF(OR(N44<O44,N44>P44),FALSE,TRUE)","v":{"$error":"#N/A"}},{"$f":"IF(K46,MIN(N44:N46),MIN(N44:N45))","v":{"$error":"#N/A"}},{"$f":"COUNTIF(N44:N46,R44)","v":3}]
[{"$nulls":6},"",null,null,{"$f":"COUNTA(B45:G45)","v":1},{"$f":"OR(J45=0,J45=6)","v":false},false,false,{"$error":"#N/A"},{"$f":"IF(N44=N45,O44,MAX(N44:N45)-1)","v":{"$error":"#N/A"}},{"$f":"MAX(N44:N45)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"IF(K46,MAX(N44:N46),MAX(N44:N45))","v":{"$error":"#N/A"}},{"$f":"COUNTIF(N44:N46,R45)","v":3},{"$f":"(S45>=COUNT(N44:N46)-1)","v":true}]
[{"$nulls":6},"",null,null,1,false,{"$f":"IF(J46=0,TRUE,IF(LEN(D46)=9,AND(IFERROR(VALUE(LEFT(D46,8))>0,FALSE),ISTEXT(RIGHT(D46,1))),FALSE))","v":false},false,{"$error":"#N/A"},{"$f":"IF(N45=N46,O45,MAX(N44:N46)-1)","v":{"$error":"#N/A"}},{"$f":"MAX(N44:N46)","v":{"$error":"#N/A"}},{"$f":"IF(N46=\"\",TRUE,IF(OR(N46<O46,N46>P46),FALSE,TRUE))","v":{"$error":"#N/A"}},{"$f":"R45-R44","v":{"$error":"#N/A"}},{"$f":"IF(R46=1,S44+S45,3)","v":{"$error":"#N/A"}},{"$f":"IFERROR(R46<=1,FALSE)","v":false}]

{"sheet":"Formes collectives (Jiti)","index":5,"n_rows":91,"n_cols":14,"rows_kept":91,"merged":[[1,0,9,0],[1,7,9,7],[1,8,9,8],[10,0,18,0],[10,7,18,7],[10,8,18,8],[19,0,27,0],[19,7,27,7],[19,8,27,8],[28,0,36,0],[28,7,36,7],[28,8,36,8],[37,0,45,0],[37,7,45,7],[37,8,45,8],[46,0,54,0],[46,7,54,7],[46,8,54,8],[55,0,63,0],[55,7,63,7],[55,8,63,8],[64,0,72,0],[64,7,72,7],[64,8,72,8],[73,0,81,0],[73,7,81,7],[73,8,81,8],[82,0,90,0],[82,7,90,7],[82,8,90,8]]}
[null,"Nom","Prénom","Numéro de licence","Sexe","Date de naissance","Catégorie d'age","Forme",null,null,"TCR","LicOK","bdOk","BlankRow"]
[{"$f":"IF(I2=\"ü\",IF(ISNUMBER(A1),A1+1,1),\"\")","v":1},"a","a","12345687a","Masculin","2005-11-30","Benjamins","Taolu synchronisée",{"$f":"IF(AND(N2,COUNTIF(J2:J10,\"=1\")<=6,COUNTIF(K2:M10,TRUE)/3=9-COUNTIF(J2:J10,\"=1\")),\"ü\",\"û\")","v":"ü"},{"$f":"COUNTA(B2:G2,H2)","v":7},{"$f":"OR(J2=0,J2=7)","v":true},{"$f":"IF(LEN(D2)=9,AND(IFERROR(VALUE(LEFT(D2,8))>0,FALSE),ISTEXT(RIGHT(D2,1))),FALSE)","v":true},{"$f":"IF(ISNUMBER(F2),AND(F2>=DATE(YEAR(NOW())-VLOOKUP(G2,tabTL,3,FALSE),1,1),F2<=DATE(YEAR(NOW())-VLOOKUP(G2,tabTL,2,FALSE),12,31)),FALSE)","v":true},{"$f":"AND(N3:N10)","v":true}]
[null,"b","b","12354679b","Féminine","2006-12-31","Pupilles",null,null,{"$f":"COUNTA(B3:G3)","v":6},{"$f":"OR(J3=0,J3=6)","v":true},{"$f":"IF(LEN(D3)=9,AND(IFERROR(VALUE(LEFT(D3,8))>0,FALSE),ISTEXT(RIGHT(D3,1))),FALSE)","v":true},true,{"$f":"IF(M3=AND(K2:M3),TRUE,FALSE)","v":true}]
[null,"c","c","45678912c","Masculin","2004-01-01",{"$f":"IF(OR(ISBLANK(E4),ISBLANK(F4)),\"\",INDEX(tabTL,MATCH(YEAR(TODAY())-YEAR(F4),INDEX(tabTL,,2)),1))","v":"Benjamins"},null,null,{"$f":"COUNTA(B4:G4)","v":6},{"$f":"OR(J4=0,J4=6)","v":true},{"$f":"IF(J4=0,TRUE,IF(LEN(D4)=9,AND(IFERROR(VALUE(LEFT(D4,8))>0,FALSE),ISTEXT(RIGHT(D4,1))),FALSE))","v":true},true,true]
[{"$nulls":6},"",null,null,{"$f":"COUNTA(B5:G5)","v":1},{"$f":"OR(J5=0,J5=6)","v":false},{"$f":"IF(J5=0,TRUE,IF(LEN(D5)=9,AND(IFERROR(VALUE(LEFT(D5,8))>0,FALSE),ISTEXT(RIGHT(D5,1))),FALSE))","v":false},false,true]
[{"$nulls":6},"",null,null,{"$f":"COUNTA(B6:G6)","v":1},false,{"$f":"IF(J6=0,TRUE,IF(LEN(D6)=9,AND(IFERROR(VALUE(LEFT(D6,8))>0,FALSE),ISTEXT(RIGHT(D6,1))),FALSE))","v":false},false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$f":"IF(I11=\"ü\",IF(ISNUMBER(A10),A10+1,1),\"\")","v":1},"a","a","12345687a","Masculin","2005-11-30","Benjamins","Jiti",{"$f":"IF(AND(N11,COUNTIF(J11:J19,\"=1\")<=6,COUNTIF(K11:M19,TRUE)/3=9-COUNTIF(J11:J19,\"=1\")),\"ü\",\"û\")","v":"ü"},{"$f":"COUNTA(B11:G11,H11)","v":7},{"$f":"OR(J11=0,J11=7)","v":true},{"$f":"IF(LEN(D11)=9,AND(IFERROR(VALUE(LEFT(D11,8))>0,FALSE),ISTEXT(RIGHT(D11,1))),FALSE)","v":true},true,{"$f":"AND(N12:N19)","v":true}]
[null,"b","b","12354679b","Féminine","2008-12-31","Poussins",null,null,{"$f":"COUNTA(B12:G12)","v":6},{"$f":"OR(J12=0,J12=6)","v":true},{"$f":"IF(LEN(D12)=9,AND(IFERROR(VALUE(LEFT(D12,8))>0,FALSE),ISTEXT(RIGHT(D12,1))),FALSE)","v":true},true,{"$f":"IF(M12=AND(K11:M12),TRUE,FALSE)","v":true}]
[null,"c","d","45678912c","Masculin","2004-01-01","Benjamins",null,null,{"$f":"COUNTA(B13:G13)","v":6},{"$f":"OR(J13=0,J13=6)","v":true},{"$f":"IF(J13=0,TRUE,IF(LEN(D13)=9,AND(IFERROR(VALUE(LEFT(D13,8))>0,FALSE),ISTEXT(RIGHT(D13,1))),FALSE))","v":true},true,true]
[null,"d","d","45678976d","Féminine","2007-06-04","Pupilles",null,null,{"$f":"COUNTA(B14:G14)","v":6},{"$f":"OR(J14=0,J14=6)","v":true},{"$f":"IF(J14=0,TRUE,IF(LEN(D14)=9,AND(IFERROR(VALUE(LEFT(D14,8))>0,FALSE),ISTEXT(RIGHT(D14,1))),FALSE))","v":true},true,true]
[null,"e","e","45123976d","Masculin","2011-06-05","Mini-poussins",null,null,{"$f":"COUNTA(B15:G15)","v":6},true,{"$f":"IF(J15=0,TRUE,IF(LEN(D15)=9,AND(IFERROR(VALUE(LEFT(D15,8))>0,FALSE),ISTEXT(RIGHT(D15,1))),FALSE))","v":true},true,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$f":"IF(I20=\"ü\",IF(ISNUMBER(A19),A19+1,1),\"\")","v":""},{"$nulls":5},"",null,{"$f":"IF(AND(N20,COUNTIF(J20:J28,\"=1\")<=6,COUNTIF(K20:M28,TRUE)/3=9-COUNTIF(J20:J28,\"=1\")),\"ü\",\"û\")","v":"û"},{"$f":"COUNTA(B20:G20,H20)","v":1},{"$f":"OR(J20=0,J20=7)","v":false},{"$f":"IF(LEN(D20)=9,AND(IFERROR(VALUE(LEFT(D20,8))>0,FALSE),ISTEXT(RIGHT(D20,1))),FALSE)","v":false},false,{"$f":"AND(N21:N28)","v":true}]
[{"$nulls":6},"",null,null,{"$f":"COUNTA(B21:G21)","v":1},{"$f":"OR(J21=0,J21=6)","v":false},false,false,{"$f":"IF(M21=AND(K20:M21),TRUE,FALSE)","v":true}]
[{"$nulls":6},"",null,null,1,false,{"$f":"IF(J22=0,TRUE,IF(LEN(D22)=9,AND(IFERROR(VALUE(LEFT(D22,8))>0,FALSE),ISTEXT(RIGHT(D22,1))),FALSE))","v":false},false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$f":"IF(I29=\"ü\",IF(ISNUMBER(A28),A28+1,1),\"\")","v":""},{"$nulls":5},"",null,{"$f":"IF(AND(N29,COUNTIF(J29:J37,\"=1\")<=6,COUNTIF(K29:M37,TRUE)/3=9-COUNTIF(J29:J37,\"=1\")),\"ü\",\"û\")","v":"û"},{"$f":"COUNTA(B29:G29,H29)","v":1},{"$f":"OR(J29=0,J29=7)","v":false},{"$f":"IF(LEN(D29)=9,AND(IFERROR(VALUE(LEFT(D29,8))>0,FALSE),ISTEXT(RIGHT(D29,1))),FALSE)","v":false},false,{"$f":"AND(N30:N37)","v":true}]
[{"$nulls":6},"",null,null,{"$f":"COUNTA(B30:G30)","v":1},{"$f":"OR(J30=0,J30=6)","v":false},false,false,{"$f":"IF(M30=AND(K29:M30),TRUE,FALSE)","v":true}]
[{"$nulls":6},"",null,null,1,false,{"$f":"IF(J31=0,TRUE,IF(LEN(D31)=9,AND(IFERROR(VALUE(LEFT(D31,8))>0,FALSE),ISTEXT(RIGHT(D31,1))),FALSE))","v":false},false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},{"$f":"IF(OR(ISBLANK(E34),ISBLANK(F34)),\"\",INDEX(tabTL,MATCH(YEAR(TODAY())-YEAR(F34),INDEX(tabTL,,2)),1))","v":""},null,null,1,false,false,{"$f":"IF(ISNUMBER(F34),AND(F34>=DATE(YEAR(NOW())-VLOOKUP(G34,tabTL,3,FALSE),1,1),F34<=DATE(YEAR(NOW())-VLOOKUP(G34,tabTL,2,FALSE),12,31)),FALSE)","v":false},true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$f":"IF(I38=\"ü\",IF(ISNUMBER(A37),A37+1,1),\"\")","v":""},{"$nulls":5},"",null,{"$f":"IF(AND(N38,COUNTIF(J38:J46,\"=1\")<=6,COUNTIF(K38:M46,TRUE)/3=9-COUNTIF(J38:J46,\"=1\")),\"ü\",\"û\")","v":"û"},{"$f":"COUNTA(B38:G38,H38)","v":1},{"$f":"OR(J38=0,J38=7)","v":false},{"$f":"IF(LEN(D38)=9,AND(IFERROR(VALUE(LEFT(D38,8))>0,FALSE),ISTEXT(RIGHT(D38,1))),FALSE)","v":false},false,{"$f":"AND(N39:N46)","v":true}]
[{"$nulls":6},"",null,null,{"$f":"COUNTA(B39:G39)","v":1},{"$f":"OR(J39=0,J39=6)","v":false},false,false,{"$f":"IF(M39=AND(K38:M39),TRUE,FALSE)","v":true}]
[{"$nulls":6},"",null,null,1,false,{"$f":"IF(J40=0,TRUE,IF(LEN(D40)=9,AND(IFERROR(VALUE(LEFT(D40,8))>0,FALSE),ISTEXT(RIGHT(D40,1))),FALSE))","v":false},false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$f":"IF(I47=\"ü\",IF(ISNUMBER(A46),A46+1,1),\"\")","v":""},{"$nulls":5},"",null,{"$f":"IF(AND(N47,COUNTIF(J47:J55,\"=1\")<=6,COUNTIF(K47:M55,TRUE)/3=9-COUNTIF(J47:J55,\"=1\")),\"ü\",\"û\")","v":"û"},{"$f":"COUNTA(B47:G47,H47)","v":1},{"$f":"OR(J47=0,J47=7)","v":false},{"$f":"IF(LEN(D47)=9,AND(IFERROR(VALUE(LEFT(D47,8))>0,FALSE),ISTEXT(RIGHT(D47,1))),FALSE)","v":false},false,{"$f":"AND(N48:N55)","v":true}]
[{"$nulls":6},"",null,null,{"$f":"COUNTA(B48:G48)","v":1},{"$f":"OR(J48=0,J48=6)","v":false},false,false,{"$f":"IF(M48=AND(K47:M48),TRUE,FALSE)","v":true}]
[{"$nulls":6},"",null,null,1,false,{"$f":"IF(J49=0,TRUE,IF(LEN(D49)=9,AND(IFERROR(VALUE(LEFT(D49,8))>0,FALSE),ISTEXT(RIGHT(D49,1))),FALSE))","v":false},false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$f":"IF(I56=\"ü\",IF(ISNUMBER(A55),A55+1,1),\"\")","v":""},{"$nulls":5},"",null,{"$f":"IF(AND(N56,COUNTIF(J56:J64,\"=1\")<=6,COUNTIF(K56:M64,TRUE)/3=9-COUNTIF(J56:J64,\"=1\")),\"ü\",\"û\")","v":"û"},{"$f":"COUNTA(B56:G56,H56)","v":1},{"$f":"OR(J56=0,J56=7)","v":false},{"$f":"IF(LEN(D56)=9,AND(IFERROR(VALUE(LEFT(D56,8))>0,FALSE),ISTEXT(RIGHT(D56,1))),FALSE)","v":false},false,{"$f":"AND(N57:N64)","v":true}]
[{"$nulls":6},"",null,null,{"$f":"COUNTA(B57:G57)","v":1},{"$f":"OR(J57=0,J57=6)","v":false},false,false,{"$f":"IF(M57=AND(K56:M57),TRUE,FALSE)","v":true}]
[{"$nulls":6},"",null,null,1,false,{"$f":"IF(J58=0,TRUE,IF(LEN(D58)=9,AND(IFERROR(VALUE(LEFT(D58,8))>0,FALSE),ISTEXT(RIGHT(D58,1))),FALSE))","v":false},false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$f":"IF(I65=\"ü\",IF(ISNUMBER(A64),A64+1,1),\"\")","v":""},{"$nulls":5},"",null,"û",{"$f":"COUNTA(B65:G65,H65)","v":1},{"$f":"OR(J65=0,J65=7)","v":false},{"$f":"IF(LEN(D65)=9,AND(IFERROR(VALUE(LEFT(D65,8))>0,FALSE),ISTEXT(RIGHT(D65,1))),FALSE)","v":false},false,{"$f":"AND(N66:N73)","v":true}]
[{"$nulls":6},{"$f":"IF(OR(ISBLANK(E66),ISBLANK(F66)),\"\",INDEX(tabTL,MATCH(YEAR(TODAY())-YEAR(F66),INDEX(tabTL,,2)),1))","v":""},null,null,{"$f":"COUNTA(B66:G66)","v":1},{"$f":"OR(J66=0,J66=6)","v":false},false,{"$f":"IF(ISNUMBER(F66),AND(F66>=DATE(YEAR(NOW())-VLOOKUP(G66,tabTL,3,FALSE),1,1),F66<=DATE(YEAR(NOW())-VLOOKUP(G66,tabTL,2,FALSE),12,31)),FALSE)","v":false},{"$f":"IF(M66=AND(K65:M66),TRUE,FALSE)","v":true}]
[{"$nulls":6},"",null,null,1,false,{"$f":"IF(J67=0,TRUE,IF(LEN(D67)=9,AND(IFERROR(VALUE(LEFT(D67,8))>0,FALSE),ISTEXT(RIGHT(D67,1))),FALSE))","v":false},false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$f":"IF(I74=\"ü\",IF(ISNUMBER(A73),A73+1,1),\"\")","v":""},{"$nulls":5},"",null,"û",{"$f":"COUNTA(B74:G74,H74)","v":1},{"$f":"OR(J74=0,J74=7)","v":false},{"$f":"IF(LEN(D74)=9,AND(IFERROR(VALUE(LEFT(D74,8))>0,FALSE),ISTEXT(RIGHT(D74,1))),FALSE)","v":false},false,{"$f":"AND(N75:N82)","v":true}]
[{"$nulls":6},"",null,null,{"$f":"COUNTA(B75:G75)","v":1},{"$f":"OR(J75=0,J75=6)","v":false},false,false,{"$f":"IF(M75=AND(K74:M75),TRUE,FALSE)","v":true}]
[{"$nulls":6},"",null,null,1,false,{"$f":"IF(J76=0,TRUE,IF(LEN(D76)=9,AND(IFERROR(VALUE(LEFT(D76,8))>0,FALSE),ISTEXT(RIGHT(D76,1))),FALSE))","v":false},false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$f":"IF(I83=\"ü\",IF(ISNUMBER(A82),A82+1,1),\"\")","v":""},{"$nulls":5},"",null,{"$f":"IF(AND(N83,COUNTIF(J83:J91,\"=1\")<=6,COUNTIF(K83:M91,TRUE)/3=9-COUNTIF(J83:J91,\"=1\")),\"ü\",\"û\")","v":"û"},{"$f":"COUNTA(B83:G83,H83)","v":1},{"$f":"OR(J83=0,J83=7)","v":false},{"$f":"IF(LEN(D83)=9,AND(IFERROR(VALUE(LEFT(D83,8))>0,FALSE),ISTEXT(RIGHT(D83,1))),FALSE)","v":false},false,{"$f":"AND(N84:N91)","v":true}]
[{"$nulls":6},"",null,null,{"$f":"COUNTA(B84:G84)","v":1},{"$f":"OR(J84=0,J84=6)","v":false},false,false,{"$f":"IF(M84=AND(K83:M84),TRUE,FALSE)","v":true}]
[{"$nulls":6},"",null,null,1,false,{"$f":"IF(J85=0,TRUE,IF(LEN(D85)=9,AND(IFERROR(VALUE(LEFT(D85,8))>0,FALSE),ISTEXT(RIGHT(D85,1))),FALSE))","v":false},false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]
[{"$nulls":6},"",null,null,1,false,false,false,true]

{"sheet":"Dianda","index":6,"n_rows":72,"n_cols":16,"rows_kept":72,"merged":[[0,8,0,9]]}
[{"$nulls":8},"réservé aux contrôles"]
[null,"Nom","Prénom","Numéro de licence","Sexe","Date de naissance","Catégorie d'age","Catégorie de poids","Poids de pesée","Signature",null,null,"TCR","LicOK","bdOk","cpOk"]
[{"$f":"IF(K3=\"ü\",IF(ISNUMBER(A2),A2+1,1),\"\")","v":1},"a","a","12345678z","Masculin","2005-11-30",{"$f":"IF(OR(ISBLANK(E3),ISBLANK(F3)),\"\",INDEX(TabDD,MATCH(YEAR(TODAY())-YEAR(F3),INDEX(TabDD,,2)),1))","v":"Benjamins"},{"v":-35,"d":"≤ 35 kg"},null,null,{"$f":"IFERROR(IF(AND(M3:P3),\"ü\",\"û\"),\"û\")","v":"ü"},{"$f":"COUNTA(B3:H3)","v":7},{"$f":"OR(L3=0,L3=7)","v":true},{"$f":"IF(LEN(D3)=9,AND(IFERROR(VALUE(LEFT(D3,8))>0,FALSE),ISTEXT(RIGHT(D3,1))),FALSE)","v":true},{"$f":"AND(F3>=DATE(YEAR(NOW())-VLOOKUP(G3,TabDD,3,FALSE),1,1),F3<=DATE(YEAR(NOW())-VLOOKUP(G3,TabDD,2,FALSE),12,31))","v":true},{"$f":"HLOOKUP(H3,INDIRECT(\"lp\"&LOWER(LEFT(E3,1))&G3),1,FALSE)","v":{"v":-35,"d":"≤ 35 kg"}}]
[{"$f":"IF(K4=\"ü\",IF(ISNUMBER(A3),A3+1,1),\"\")","v":2},"b","b","45687912e","Féminine","2007-05-01","Pupilles",{"v":-40,"d":"≤ 40 kg"},null,null,{"$f":"IFERROR(IF(AND(M4:P4),\"ü\",\"û\"),\"û\")","v":"ü"},{"$f":"COUNTA(B4:H4)","v":7},{"$f":"OR(L4=0,L4=7)","v":true},{"$f":"IF(LEN(D4)=9,AND(IFERROR(VALUE(LEFT(D4,8))>0,FALSE),ISTEXT(RIGHT(D4,1))),FALSE)","v":true},true,{"$f":"HLOOKUP(H4,INDIRECT(\"lp\"&LOWER(LEFT(E4,1))&G4),1,FALSE)","v":{"v":-40,"d":"≤ 40 kg"}}]
[3,"c","c","78913456q","Masculin","2009-09-06","Poussins",{"v":40,"d":"> 40 kg"},null,null,"ü",7,true,true,true,{"v":40,"d":"> 40 kg"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},{"$f":"IF(OR(ISBLANK(E35),ISBLANK(F35)),\"\",INDEX(TabDD,MATCH(YEAR(TODAY())-YEAR(F35),INDEX(TabDD,,2)),1))","v":""},{"$nulls":3},"û",1,false,false,{"$f":"AND(F35>=DATE(YEAR(NOW())-VLOOKUP(G35,TabDD,3,FALSE),1,1),F35<=DATE(YEAR(NOW())-VLOOKUP(G35,TabDD,2,FALSE),12,31))","v":{"$error":"#N/A"}},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},{"$f":"IF(OR(ISBLANK(E67),ISBLANK(F67)),\"\",INDEX(TabDD,MATCH(YEAR(TODAY())-YEAR(F67),INDEX(TabDD,,2)),1))","v":""},{"$nulls":3},"û",1,false,false,{"$f":"AND(F67>=DATE(YEAR(NOW())-VLOOKUP(G67,TabDD,3,FALSE),1,1),F67<=DATE(YEAR(NOW())-VLOOKUP(G67,TabDD,2,FALSE),12,31))","v":{"$error":"#N/A"}},{"$error":"#REF!"}]
[{"$f":"IF(K68=\"ü\",IF(ISNUMBER(A67),A67+1,1),\"\")","v":""},{"$nulls":5},"",{"$nulls":3},{"$f":"IFERROR(IF(AND(M68:P68),\"ü\",\"û\"),\"û\")","v":"û"},{"$f":"COUNTA(B68:H68)","v":1},{"$f":"OR(L68=0,L68=7)","v":false},{"$f":"IF(LEN(D68)=9,AND(IFERROR(VALUE(LEFT(D68,8))>0,FALSE),ISTEXT(RIGHT(D68,1))),FALSE)","v":false},{"$error":"#N/A"},{"$f":"HLOOKUP(H68,INDIRECT(\"lp\"&LOWER(LEFT(E68,1))&G68),1,FALSE)","v":{"$error":"#REF!"}}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]
["",{"$nulls":5},"",{"$nulls":3},"û",1,false,false,{"$error":"#N/A"},{"$error":"#REF!"}]