{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["MODE D'EMPLOI","Résultat 1er Manche"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":1,"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":"MODE D'EMPLOI","index":0,"n_rows":54,"n_cols":3,"rows_kept":54,"cut":false,"hidden":false,"merged":[[43,0,43,6],[46,0,46,3],[48,0,48,6],[49,0,51,6],[38,0,38,6],[39,0,39,6],[40,0,40,6],[41,0,41,6],[29,0,29,3],[31,0,32,6],[34,0,34,6],[36,0,36,3],[22,0,22,6],[23,0,23,6],[25,0,25,6],[27,0,27,6],[15,0,16,6],[18,0,18,6],[20,0,20,3],[8,0,8,6],[9,0,9,6],[10,0,10,6],[11,0,11,6],[1,2,2,4],[4,0,4,2],[6,0,6,6],[7,0,7,6],[13,0,13,3]]}
[]
[null,null,"MODE D'EMPLOI"]
[]
[]
["LORS DE L' INSCRIPTION"]
[]
["1° >   Inscrire :  Nom du Skipper dans \"RESULTAT 1ér MANCHE\""]
["2° >   Inscrire :  Nom du BATEAU dans \"RESULTAT 1ér MANCHE\""]
["3° >   Inscrire :  Type du Voilier dans \"RESULTAT 1ér MANCHE\""]
["4° >   Inscrire : Rating dans \"RESULTAT 1ér MANCHE\""]
["5° >  Inscrire :  Nom du CLUB dans \"RESULTAT 1ér MANCHE\""]
[]
[]
["LORS DU DEPART DE LA 1ér MANCHE"]
[]
["1° >   Inscrire :Heure du départ sur la ligne Cagnard N°1 dans \"RESULTAT 1ér MANCHE\" sous la forme >ex:12:25:12 (=12h 25min 12sec)"]
[]
[]
["2° >   Inscrire :  L' heure de la férmeture de la ligne d'arrivée"]
[]
["LORS DE L' ARRIVEE DE LA 1ér MANCHE"]
[]
["1° >   Inscrire :Heure de l'arrivée pour chaque concurrent dans \"RESULTAT 1ér MANCHE\""]
["sous la forme >ex:12:25:12 (=12h 25min 12sec)"]
[]
["2° >  Si abandon :L' heure d'arrivée du bateau = 00:00:00"]
[]
["3° >  Si arrivée \"Hors temps\" :L' heure d'arrivée du bateau = L' heure de la férmeture de la ligne d'arrivée"]
[]
["LORS DU DEPART DE LA 2ém MANCHE"]
[]
["1° >   Inscrire :Heure du départ sur la ligne Cagnard N°1 dans \"RESULTAT 2ém MANCHE\" sous la forme >ex:12:25:12 (=12h 25min 12sec)"]
[]
[]
["2° >   Inscrire :  L' heure de  la férmeture de la ligne d'arrivée"]
[]
["LORS DE L' ARRIVEE DE LA 2ém MANCHE"]
[]
["1° >   Inscrire :Heure de l'arrivée pour chaque concurrent dans \"RESULTAT 2ém MANCHE\""]
["sous la forme >ex:12:25:12 (=12h 25min 12sec)"]
[]
["2° >  Si abandon :L' heure d'arrivée du bateau = 00:00:00"]
[]
["3° >  Si arrivée \"Hors temps\" :L' heure d'arrivée du bateau = L' heure de la férmeture de la ligne d'arrivée"]
[]
[]
["MEME OPERATION POUR LA 3emeMANCHE"]
[]
[]
["Les temps réels , compensés et le classement par point se calculent automatiquement ainsi que la feuille \"CLASSEMENT GENERAL\""]
[]
[]
[]
["! ","Les feuilles sont protégeés, Les cellules comportant les calcules ne peuvent etre éffacées"]

{"sheet":"Résultat 1er Manche","index":1,"n_rows":33,"n_cols":14,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,7,32,8],[31,15,32,15],[35,13,36,13],[35,15,35,16],[31,16,32,16],[32,11,32,12],[37,4,37,5],[37,6,37,11],[37,15,38,16],[34,3,34,12],[35,0,35,1],[35,11,36,12],[29,1,29,2],[29,3,29,4],[30,1,30,2],[30,3,30,4],[33,0,33,1],[33,4,33,5],[32,4,32,5],[32,0,32,3],[27,1,27,2],[27,3,27,4],[28,1,28,2],[28,3,28,4],[25,1,25,2],[25,3,25,4],[26,1,26,2],[26,3,26,4],[23,1,23,2],[23,3,23,4],[24,1,24,2],[24,3,24,4],[21,1,21,2],[21,3,21,4],[22,1,22,2],[22,3,22,4],[19,1,19,2],[19,3,19,4],[20,1,20,2],[20,3,20,4],[17,1,17,2],[17,3,17,4],[18,1,18,2],[18,3,18,4],[15,1,15,2],[15,3,15,4],[16,1,16,2],[16,3,16,4],[13,1,13,2],[13,3,13,4],[14,1,14,2],[14,3,14,4],[11,1,11,2],[11,3,11,4],[12,1,12,2],[12,3,12,4],[9,1,9,2],[9,3,9,4],[10,1,10,2],[10,3,10,4],[7,1,7,2],[7,3,7,4],[8,1,8,2],[8,3,8,4],[4,16,5,16],[6,1,6,2],[6,3,6,4],[4,10,5,10],[4,11,5,11],[4,12,5,12],[4,15,5,15],[4,9,5,9],[0,0,1,13],[2,1,2,4],[4,0,5,0],[4,1,5,2],[4,3,5,4],[2,5,2,10],[4,13,5,13],[4,5,5,5],[4,6,5,6],[4,7,5,7],[4,8,5,8]]}
["CALCUL DES TEMPS REGATE CPG"]
[]
[]
[]
["N° VOILE","NOM du SKIPPER",null,"NOM DU VOILIER",null,"TYPE du VOILIER","RATING","HEURE DÉPART","HEURE ARRIVÉE","TEMPS RÉEL","TEMPS COMPENSE",null,"POINTS","CLUB"]
[]
[27867,"CHARLES. PAIN ",null,"HEGOA",null,"FIRST 33.7 !",0.85350000000000004,"09:00:00",0.47118055555555555,{"$f":"IF((B7)=0,\" \",IF((I7)=0,\" 0 \",IF((I7)=($E$33),\" 0 \",(I7-H7))))","v":9.6180555555555547E-2},{"$f":"IF((B7)=0,\" \",(IF((J7*G7)=0,\" 0 \",(J7*G7))))","v":8.2090104166666664E-2},{"$f":"IF((B7)=0,\" \",(IF((I7=$E$33),\"Abandon\",(IF((I7>$E$33),\"Hors temps\",(IF((I7)=0,\"Non Partant\",(RANK(K7,$K$7:$K$31,1)))))))))","v":5},{"$f":"IF((B7)=0,\" \",(IF((L7)=\"Non Partant\",(1*0),(IF((L7)=\"Abandon\",(((101*((($N$33-$J$33)+1)/($N$33+1)))/2)),(IF((L7)=\"Hors temps\",(((101*((($N$33-$J$33)+1)/($N$33+1)))/2)),((((($N$33-L7)+1)/($N$33+1))*(101))))))))))","v":71.294117647058826},"CPG"]
[null,null,null,null,null,null,null,null,null,null," "," "," ","CPG"]
[null,null,null,null,null,null,null,{"$f":"IF(B9=0,\" \",$H$7)","v":" "},null,{"$f":"IF((B9)=0,\" \",IF((I9)=0,\" 0 \",IF((I9)=($E$33),\" 0 \",(I9-H9))))","v":" "}," "," "," ","CPG"]
[null,"JEREMY BEUVE ",null,"GO FISH",null,"GRD SURPRISE 7/8",0.92589999999999995,0.375,null," 0 "," 0 ","Non Partant",0,"CPG"]
[3363,"DIDIER.TOUROUDE",null,"BALABAC",null,"FIRST 32S5 !",0.8075,0.375,0.47361111111111115,9.8611111111111149E-2,7.9628472222222246E-2,3,83.17647058823529,"CPG"]
[13349,"HUBERT LEFEVRE",null,"BANQUE POPULAIRE ",null,"FIRST 32S5 !",0.8075,0.375,"11:18:12",9.5972222222222181E-2,7.7497569444444414E-2,1,95.058823529411768,"CPG"]
[null,null,null,null,null,null,null," ",null,null," "," "," ","CPG"]
[null,null,null,null,null,null,0.8075,0.375,"12:00:00"," "," "," "," ","CPG"]
[28773,"OLIVIER. GUILLON",null,"PACHA",null,"CENTURION 32",0.75660000000000005,0.375,"11:58:50",0.12418981481481484,9.3962013888888918E-2,7,59.411764705882355,"CPG"]
[16711,null,null,null,null,null,null,{"$f":"IF(B16=0,\" \",$H$7)","v":" "},null,null," "," "," ","CPG"]
[28326,"JEAN  VAROTSI",null,"FIDELIO",null,"FIRST 310",0.82989999999999997,0.375,0.4685185185185185,9.3518518518518501E-2,7.7611018518518496E-2,2,89.117647058823522,"CPG"]
[34836,"J.P DUPONT ",null,"FLEUR OCEANE",null,"FIRST 33.7",0.84150000000000003,0.375,null," 0 "," 0 ","Non Partant",0,"CPG"]
[14525,"PATRICE  BUISSON",null,"CLAIR DE L'HUNE",null,"FIRST 35S5",0.84750000000000003,0.375,null," 0 "," 0 ","Non Partant",0,"CPG"]
[null,"CHRISTIAN VIGER",null,"EVASION",null,"OCEANIS 411",0.86580000000000001,0.375,null," 0 "," 0 ","Non Partant",0,"CPG"]
[null,"VINCENT. BUISSON",null,"LOUJUTI",null,"FIRST 33.7 !",0.85350000000000004,0.375,0.47100694444444446,9.6006944444444464E-2,8.1941927083333352E-2,4,77.235294117647058,"CPG"]
[37822,"MICHEL. LARGER ",null,"KARIC 3",null,"BAVARIA 30 CR",0.8075,0.375,null," 0 "," 0 ","Non Partant",0,"CPG"]
[null,"PHILIPPE. MAURICE ",null,null,null,"FEELING 920",0.8075,0.375,null," 0 "," 0 ","Non Partant",0,"CPG"]
[null,null,null,null,null,null,null," ",null," "," ",null," ","CPG"]
[null,"GERARD HUET",null,"ANTOLA",null,"FIRST 31.7",0.84150000000000003,0.375,0.47488425925925926,9.9884259259259256E-2,8.405260416666667E-2,{"$f":"IF((B25)=0,\" \",(IF((I25=$E$33),\"Abandon\",(IF((I25>$E$33),\"Hors temps\",(IF((I25)=0,\"Non Partant\",(RANK(K25,$K$7:$K$31,1)))))))))","v":6},65.352941176470594,"CPG"]
[null,"⁸",null,null,null,null,0.72250000000000003,0.375,null," 0 "," 0 ","Non Partant",0,"CPG"]
[null,null,null,null,null,"BRIN DE FOLIE ",0.72250000000000003," ",null," "," "," "," ","CPG"]
[null,null,null,null,null,null,0.91879999999999995," ",null," "," "," "," ","CPG"]
[null,"FRANCOIS LEMENAGER",null,"LIFOU",null,"FIRST 31.7",0.84150000000000003,0.375,null," 0 "," 0 ","Non Partant",0,"CPG"]
[null,"PATRICE ETESSE ",null,"CIAO",null,"GRD SOLEIL 46",0.97089999999999999,0.375,null," 0 "," 0 ","Non Partant",0,"CPG"]
[null,null,null,null,null,null,null," ",null," "," "," "," ","CPG"]
[]
["Heure de férmeture de la ligne d'arrivée :",null,null,null,"19:00:00",null,null,"Concurrents Classés :",null,{"$f":"COUNT(L7:L31)","v":7},null,"Nombre de Concurrents :",null,{"$f":"COUNTA(B7:C31)","v":16}]