{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Données","Saisie","Listes","Clubs"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":35,"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":"Données","index":0,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Nom Prénom ","Départ.","Club","Date du test","Catégorie","Sexe","Putting","Chipping","Wedging","Driving","Atelier \nPhysique","Atelier \nRègles","Compét. 9 trous","Total"]
["CORTEZ Nina",30,"Nîmes-Campagne","2019-04-07","U10","Fille",3,1,3,1,6.666666666666667,4,0,{"$f":"SUM(Tableaudonnées[[#This Row],[Putting]:[Compét. 9 trous]])","v":18.666666666666668}]
["DELEUZE Maèl",30,"Nîmes-Campagne","2019-04-07","U10","Garçon",6,3,6,1,2.3333333333333335,4,9,{"$f":"SUM(Tableaudonnées[[#This Row],[Putting]:[Compét. 9 trous]])","v":31.333333333333332}]
["DELEUZE Matéo",30,"Nîmes-Campagne","2019-04-07","Poussin","Garçon",6,2,4,3,6.333333333333333,4.5,14,{"$f":"SUM(Tableaudonnées[[#This Row],[Putting]:[Compét. 9 trous]])","v":39.833333333333329}]
["DOLEAC Gaspard",30,"Nîmes-Campagne","2019-04-07","Poussin","Garçon",5,3,5,5,3.3333333333333335,3,15,{"$f":"SUM(Tableaudonnées[[#This Row],[Putting]:[Compét. 9 trous]])","v":39.333333333333329}]
["GABRIEL-PETON Antoine",30,"Nîmes-Campagne","2019-04-07","U10","Garçon",4,5,5,2,2,2,4,{"$f":"SUM(Tableaudonnées[[#This Row],[Putting]:[Compét. 9 trous]])","v":24}]
["GASPERINI Tony",30,"Nîmes Vacquerolles","2019-04-07","U10","Garçon",4,1,2,0,4,3,2,{"$f":"SUM(Tableaudonnées[[#This Row],[Putting]:[Compét. 9 trous]])","v":16}]
["GRIFFE Léonard",30,"Nîmes Vacquerolles","2019-04-07","U10","Garçon",4,1,3,1,2.6666666666666665,2,3,{"$f":"SUM(Tableaudonnées[[#This Row],[Putting]:[Compét. 9 trous]])","v":16.666666666666664}]
["MARTINEZ Jean-Baptiste",30,"Nîmes Vacquerolles","2019-04-07","U10","Garçon",4,1,1,0,0.66666666666666663,2,1,{"$f":"SUM(Tableaudonnées[[#This Row],[Putting]:[Compét. 9 trous]])","v":9.6666666666666679}]
["ROCHE-DECOMBE Kantin",30,"Nîmes-Campagne","2019-04-07","U10","Garçon",4,3,2,0,3.6666666666666665,4,6,{"$f":"SUM(Tableaudonnées[[#This Row],[Putting]:[Compét. 9 trous]])","v":22.666666666666664}]
["TUFFENIS-MARTINEZ Charles",30,"Nîmes Vacquerolles","2019-04-07","U10","Garçon",3,1,0,0,0.66666666666666663,2,1,{"$f":"SUM(Tableaudonnées[[#This Row],[Putting]:[Compét. 9 trous]])","v":7.666666666666667}]
["ZZ",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Tableaudonnées[[#This Row],[Putting]:[Compét. 9 trous]])","v":0}]

{"sheet":"Saisie","index":1,"n_rows":40,"n_cols":22,"rows_kept":40,"cut":false,"hidden":false,"merged":[[18,16,18,19],[19,16,19,18],[20,16,20,18],[17,0,17,4],[18,6,18,9],[19,6,19,8],[18,11,18,14],[19,11,19,13],[16,7,16,10],[16,11,16,12],[14,2,14,4],[0,0,0,5],[1,9,1,10],[1,11,1,12],[0,14,0,19],[15,16,15,18],[0,7,0,12],[15,7,15,10],[15,11,15,12]]}
["Atelier Chipping",null,null,null,null,null,null,"Atelier Putting",null,null,null,null,null,null,"Atelier Driving",null,null,null,null,null,null,"Date"]
["Zone d’arrêt de la balle :","Dans le trou  ","A 1m du trou ","Entre 1 et 2m du trou","Entre 2 et \n3 m du trou ","Entre 3 et \n5m du trou ",null,"Distance Putt","1 m","6 m",null,"10 m",null,null,"Distance arrêt balle :",">100 m",">120 m",">140 m",">160 m",">180 m"]
["Points",10,5,3,2,1,null,null,"Trou","Trou","<1 m","Trou","<1 m","Garçon","Points",{"$f":"IF($N3=\"Garçon\",2,IF($N3=\"Fille\",4,0))","v":2},{"$f":"IF($N3=\"Garçon\",4,IF($N3=\"Fille\",6,0))","v":4},{"$f":"IF($N3=\"Garçon\",6,IF($N3=\"Fille\",8,0))","v":6},{"$f":"IF($N3=\"Garçon\",8,IF($N3=\"Fille\",10,0))","v":8},{"$f":"IF($N3=\"Garçon\",10,IF($N3=\"Fille\",10,0))","v":10},null,{"$f":"TODAY()","v":"2019-04-09"}]
["Balle 1",null,null,null,null,1,null,"Points",1,2,1,2,1]
["Balle 2",null,null,null,null,null,null,"Balle1",1,null,null,null,null,null,"Balle 1"]
["Balle 3",null,null,3,null,null,null,"Balle2",null,null,1,null,null,null,"Balle 2"]
["Balle 4",null,null,null,null,1,null,"Balle3",1,null,null,null,1,null,"Balle 3"]
["Balle 5",null,null,3,null,null,null,"Balle4",null,null,null,null,1,null,"Balle 4"]
["Balle 6",null,null,null,null,null,null,"Balle5",1,null,null,null,1,null,"Balle 5"]
["Balle 7",null,null,null,null,1,null,"Balle6",null,null,null,null,null,null,"Balle 6"]
["Balle 8",null,null,null,null,null,null,"Balle7",null,null,null,null,null,null,"Balle 7"]
["Balle 9",null,null,null,null,null,null,"Balle8",null,null,null,null,null,null,"Balle 8"]
["Balle 10",null,null,null,null,null,null,"Balle9",null,null,null,null,null,null,"Balle 9"]
["Sous total",{"$f":"SUM(B4:B13)","v":0},{"$f":"SUM(C4:C13)","v":0},{"$f":"SUM(D4:D13)","v":6},{"$f":"SUM(E4:E13)","v":0},{"$f":"SUM(F4:F13)","v":3},null,"Balle10",1,null,null,null,null,null,"Balle 10"]
["Total points :",{"$f":"SUM(B14:F14)","v":9},"Note obtenue avec le barème :",null,null,{"$f":"IF(B15=0,F16,IF(B15>Listes!A4,Listes!B3,IF(B15>Listes!A5,Listes!B4,IF(B15>Listes!A6,Listes!B5,IF(B15>Listes!A7,Listes!B6,IF(B15>Listes!A8,Listes!B7,IF(B15>Listes!A9,Listes!B8,IF(B15>Listes!A10,Listes!B9,IF(B15>Listes!A11,Listes!B10,IF(B15>Listes!A12,Listes!B11,IF(B15>Listes!A13,Listes!B12,0)))))))))))","v":1},null,null,{"$f":"SUM(I5:I14)","v":4},{"$f":"SUM(J5:J14)","v":0},{"$f":"SUM(K5:K14)","v":1},{"$f":"SUM(L5:L14)","v":0},{"$f":"SUM(M5:M14)","v":3},null,"Sous total",{"$f":"SUM(P5:P14)","v":0},{"$f":"SUM(Q5:Q14)","v":0},{"$f":"SUM(R5:R14)","v":0},{"$f":"SUM(S5:S14)","v":0},{"$f":"SUM(T5:T14)","v":0}]
[null,null,null,null,null,null,null,"Total des points marqués au putting",null,null,null,{"$f":"SUM(I15:M15)","v":8},null,null,"Total points :",{"$f":"SUM(P15:T15)","v":0},"Note obtenue avec le barème :",null,null,{"$f":"IF(P16=0,T17,IF(Saisie!P16>Listes!G3,Listes!H3,IF(Saisie!P16>Listes!G4,Listes!H4,IF(Saisie!P16>Listes!G5,Listes!H5,IF(Saisie!P16>Listes!G6,Listes!H6,IF(Saisie!P16>Listes!G7,Listes!H7,IF(Saisie!P16>Listes!G8,Listes!H8,IF(Saisie!P16>Listes!G9,Listes!H9,IF(Saisie!P16>Listes!G10,Listes!H10,IF(Saisie!P16>Listes!G11,Listes!H11,IF(Saisie!P16>Listes!G12,Listes!H12,0)))))))))))","v":0}]
[null,null,null,null,null,null,null,"Note obtenue avec le barème :",null,null,null,{"$f":"IF(L16=0,M18,IF(L16>Listes!D4,Listes!E3,IF(L16>Listes!D5,Listes!E4,IF(L16>Listes!D6,Listes!E5,IF(L16>Listes!D7,Listes!E6,IF(L16>Listes!D8,Listes!E7,IF(L16>Listes!D9,Listes!E8,IF(L16>Listes!D10,Listes!E9,IF(L16>Listes!D11,Listes!E10,IF(L16>Listes!D12,Listes!E11,IF(L16>Listes!D13,Listes!E12,0)))))))))))","v":3}]
["Atelier Physique"]
["Saut corde","Pied droit","Pied Gauche","Lancer balle","Total points :",null,"Atelier Wedging",null,null,null,null,"Atelier Règles",null,null,null,null,"Compétition",null,null,null,"Par","Score-Par"]
[3,10,10,0,{"$f":"SUM(A20:D20)","v":23},null,"Nbres balles sur le green ",null,null,0,null,"Nbres balles sur le green ",null,null,2,null,"Score sur 9 trous ",null,null,71,35,{"$f":"T20-U20","v":36}]
[{"$f":"IF(A20>Listes!J4,Listes!K4,IF(A20>Listes!J5,Listes!K5,IF(A20>Listes!J6,Listes!K6,IF(A20>Listes!J7,Listes!K7,IF(A20>Listes!J8,Listes!K8,IF(A20>Listes!J9,Listes!K9,IF(A20>Listes!J10,Listes!K10,IF(A20>Listes!J11,Listes!K11,IF(A20>Listes!J12,Listes!K12,IF(A20>Listes!J13,Listes!K13,0))))))))))","v":0},{"$f":"IF(B20>Listes!M4,Listes!N4,IF(B20>Listes!M5,Listes!N5,IF(B20>Listes!M6,Listes!N6,IF(B20>Listes!M7,Listes!N7,IF(B20>Listes!M8,Listes!N8,0)))))","v":1},{"$f":"IF(C20>Listes!O4,Listes!P4,IF(C20>Listes!O5,Listes!P5,IF(C20>Listes!O6,Listes!P6,IF(C20>Listes!O7,Listes!P7,IF(C20>Listes!O8,Listes!P8,0)))))","v":1},{"$f":"D20","v":0},{"$f":"IF(E20=0,E22,SUM(A21:D21)/3)","v":0.66666666666666663},null,null,null,null,{"$f":"IF(J20=\"\",J22,J20)","v":0},null,"U10",null,"Note :",{"$f":"IF(O20=\"\",O22,IF(L21=\"Poussin\",O20*0.5,IF(L21=\"U10\",O20,0)))","v":2},null,"Note obtenue avec le barème :",null,null,{"$f":"IF(T20=\"\",T22,IF(V20>Listes!R22,Listes!S22,IF(V20>Listes!R21,Listes!S21,IF(V20>Listes!R20,Listes!S20,IF(V20>Listes!R19,Listes!S19,IF(V20>Listes!R18,Listes!S18,IF(V20>Listes!R17,Listes!S17,IF(V20>Listes!R16,Listes!S16,IF(V20>Listes!R15,Listes!S15,IF(V20>Listes!R14,Listes!S14,IF(V20>Listes!R13,Listes!S13,IF(V20=Listes!R12,Listes!S12,IF(V20=Listes!R11,Listes!S11,IF(V20=Listes!R10,Listes!S10,IF(V20=Listes!R9,Listes!S9,IF(V20=Listes!R8,Listes!S8,IF(V20=Listes!R7,Listes!S7,IF(V20=Listes!R6,Listes!S6,IF(V20=Listes!R5,Listes!S5,IF(V20=Listes!R4,Listes!S4,IF(V20=Listes!R3,Listes!S3,IF(V20<Listes!R3,Listes!S2,0))))))))))))))))))))))","v":1}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,""]

{"sheet":"Listes","index":2,"n_rows":22,"n_cols":19,"rows_kept":22,"cut":false,"hidden":false,"merged":[[1,12,1,15],[0,9,0,10],[0,12,0,15],[1,9,1,10],[0,0,0,1],[0,3,0,4],[0,6,0,7]]}
["Chipping",null,null,"Putting",null,null,"Driving",null,null,"Saut à la corde :",null,null,"Equilibre :",null,null,null,null,"Compét, 9 trous\nSCORE DU JOUEUR PAR RAPPORT AU PAR ","NOTE OBTENUE"]
["Points marqués","Note obtenue",null,"Points marqués","Note obtenue",null,"Points obtenus","Note",null,"Faire un maximum de sauts à la suite",null,null,"Appui sur un pied les yeux fermés ",null,null,null,null,"-1 ou mieux (score négatif)",20]
[50,10,null,null,10,null,99,10,null,"Nbre de sauts","Note",null,"Pied Droit","Garçon","Pied Gauche","NOTE",null,0,19]
[49,9,null,25,9,null,89,9,null,49,10,null,40,5,40,5,null,1,18]
[44,8,null,23,8,null,79,8,null,44,9,null,30,4,30,4,null,2,17]
[39,7,null,21,7,null,69,7,null,39,8,null,20,3,20,3,null,3,16]
[34,6,null,18,6,null,59,6,null,34,7,null,10,2,10,2,null,4,15]
[29,5,null,15,5,null,49,5,null,29,6,null,2,1,2,1,null,5,14]
[24,4,null,12,4,null,39,4,null,24,5,null,null,null,null,null,null,6,13]
[19,3,null,9,3,null,29,3,null,19,4,null,"Catégories",null,"Sexe",null,null,7,12]
[14,2,null,6,2,null,19,2,null,14,3,null,"Poussin",null,"Fille",null,null,8,11]
[9,1,null,4,1,null,9,1,null,9,2,null,"U10",null,"Garçon",null,null,9,10]
[4,0,null,2,0,null,null,null,null,4,1,null,null,null,null,null,null,9,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,8]
["Mot de passe",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15,7]
["a",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21,5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37,0]

{"sheet":"Clubs","index":3,"n_rows":15,"n_cols":29,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["30",null,"Colonne1",null,null,null,"09",null,"11/66",null,"12",null,"30",null,"31",null,"32",null,"34",null,"46",null,"48",null,"65",null,"81",null,"82"]
[null,null,{"$f":"IF(A$1=\"09\",_09,IF(A$1=\"11/66\",_11_66,IF(A$1=\"12\",_12,IF(A$1=\"30\",_30,IF(A$1=\"31\",_31,IF(A$1=\"32\",_32,IF(A$1=\"34\",_34,IF(A$1=\"46\",_46,IF(A$1=\"48\",_48,IF(A$1=\"65\",_65,IF(A$1=\"81\",_81,IF(A$1=\"82\",_82,0))))))))))))","v":"Alès-Ribaute"},null,{"$f":"IF(C2=0,\"\",C2)","v":"Alès-Ribaute"},null,"Appaméen",null,"Amélie-les-Bains",null,"Mezeyrac",null,"Alès-Ribaute",null,"Comminges",null,"Auch",null,"Coulondres",null,"Cahors",null,"Domaine de Barres",null,"Bigorre",null,"Aiguelèze",null,"Aiguillons"]
[null,null,"Nîmes Vacquerolles",null,{"$f":"IF(C3=0,\"\",C3)","v":"Nîmes Vacquerolles"},null,"Ariège",null,"Carcassonne",null,"Rodez",null,"Nîmes Vacquerolles",null,"Estolosa",null,"Barbet",null,"Fontcaude",null,"Montal",null,"Garde Guerin",null,"Hippodrome",null,"Albi",null,"Espalais"]
["09",null,"Nîmes-Campagne",null,"Nîmes-Campagne",null,null,null,"Falgos",null,"Totche",null,"Nîmes-Campagne",null,"Hippodromme",null,"Eauze",null,"Grande Motte",null,"Souillac",null,"Gorges du Tarn",null,"Lannemezan",null,"Castres",null,"Montauban"]
["11/66",null,"Uzès",null,"Uzès",null,null,null,"Font-Romeu",null,null,null,"Uzès",null,"Juillac",null,"Fleurance",null,"Lamalou",null,null,null,"Pommeraie",null,"Lourdes",null,"Fiac"]
[12,null,0,null,"",null,null,null,"Montescot",null,null,null,null,null,"La Ramée",null,"Gascogne",null,"Massane",null,null,null,null,null,"Tumulus",null,"Mazamet"]
[30,null,0,null,"",null,null,null,"Saint Cyprien",null,null,null,null,null,"Luchon",null,"Las Martines",null,"Saint Thomas"]
[31,null,0,null,"",null,null,null,"Sainte Rose",null,null,null,null,null,"Palmola",null,"Pallanne",null,"Castelnau le Lez"]
[32,null,0,null,"",null,null,null,null,null,null,null,null,null,"Saint Gabriel",null,null,null,"Cap d'Adge"]
[34,null,0,null,"",null,null,null,null,null,null,null,null,null,"Salies du Salat"]
[46,null,0,null,"",null,null,null,null,null,null,null,null,null,"Seilh"]
[48,null,{"$f":"IF(A$1=\"09\",_09,IF(A$1=\"11/66\",_11_66,IF(A$1=\"12\",_12,IF(A$1=\"30\",_30,IF(A$1=\"31\",_31,IF(A$1=\"32\",_32,IF(A$1=\"34\",_34,IF(A$1=\"46\",_46,IF(A$1=\"48\",_48,IF(A$1=\"65\",_65,IF(A$1=\"81\",_81,IF(A$1=\"82\",_82,0))))))))))))","v":0},null,"",null,null,null,null,null,null,null,null,null,"Téoula"]
[65,null,{"$f":"IF(A$1=\"09\",_09,IF(A$1=\"11/66\",_11_66,IF(A$1=\"12\",_12,IF(A$1=\"30\",_30,IF(A$1=\"31\",_31,IF(A$1=\"32\",_32,IF(A$1=\"34\",_34,IF(A$1=\"46\",_46,IF(A$1=\"48\",_48,IF(A$1=\"65\",_65,IF(A$1=\"81\",_81,IF(A$1=\"82\",_82,0))))))))))))","v":0},null,{"$f":"IF(C13=0,\"\",C13)","v":""},null,null,null,null,null,null,null,null,null,"Vieille Toulouse"]
[81]
[82]