{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["1 Point","2 Points","3 Points","5 Points","6 Points","Chek Liste Matériel"],"not_rendered":{"charts":10,"images":1,"macros":0,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"1 Point","index":0,"n_rows":76,"n_cols":33,"rows_kept":76,"cut":false,"hidden":false,"merged":[[39,1,39,13],[37,15,37,27],[44,1,44,4],[44,5,44,6],[44,7,44,10],[44,11,44,12],[37,1,37,13],[42,2,42,6],[42,8,42,13],[43,1,43,6],[43,7,43,8],[43,9,43,10],[43,11,43,12],[30,15,30,27],[23,1,23,13],[23,15,23,27],[30,1,30,13],[21,24,22,24],[21,25,22,25],[21,26,22,26],[19,1,19,13],[19,15,19,27],[21,0,22,0],[21,1,21,13],[21,15,22,15],[21,16,22,16],[21,17,22,17],[21,18,22,18],[21,19,22,19],[21,20,22,20],[21,27,22,27],[21,21,22,21],[21,22,22,22],[21,23,22,23],[12,4,12,5],[12,7,12,9],[12,10,12,13],[17,1,17,13],[17,15,17,27],[12,15,12,20],[12,21,12,25],[12,26,12,28],[14,18,14,19],[14,20,14,24],[11,4,11,5],[11,7,11,9],[11,10,11,13],[8,4,8,5],[8,7,8,9],[8,10,8,13],[9,4,9,5],[9,7,9,9],[9,10,9,13],[10,4,10,5],[10,7,10,9],[10,10,10,13],[9,15,9,20],[9,21,9,25],[8,15,8,28],[9,26,9,28],[0,1,0,13],[3,4,3,5],[4,4,4,5],[5,4,5,5],[6,4,6,5],[6,9,6,10],[6,12,6,13],[1,1,1,13],[30,28,30,33],[31,30,31,31],[31,32,31,33],[32,30,32,31],[32,32,32,33],[33,30,33,31],[33,32,33,33],[34,28,34,29],[34,30,34,31],[34,32,34,33],[35,28,35,29],[35,30,35,31],[35,32,35,33],[36,28,36,29],[36,30,36,31],[36,32,36,33],[37,28,37,29],[37,30,39,31],[37,32,39,33],[38,15,39,27],[38,28,39,29]]}
[null,"JAUGEAGE PAR EXPLORATION DU CHAMP DES VITESSES"]
[null,"METHODE POINTS ET FORMULES NORMALISEES"]
[]
[null,null,null,"Date :",null,null,null,"Maître d'ouvrage :"]
[null,null,null,"Heure de début :",null,null,null,"Nom de la prise :"]
[null,null,null,"Heure de fin :",null,null,null,"Localisation :"]
[null,null,null,"Durée de mesurage :",{"$f":"E6-E5","v":"00:00:00"},null,null,"GPS :","X :",null,null,"Y :"]
[]
[null,null,null,"Equipement en place :",null,null,null,"Equipement utilisé :",null,null,null,null,null,null,null,"Nombre de verticales recommandées par la norme NF EN ISO 748 selon la largeur du chenal"]
[null,null,null,"Forme du chenal :",null,null,null,"Type :",null,null,null,null,null,null,null,"Version de Janvier 2002",null,null,null,null,null,"Version de Avril 2009",null,null,null,null,"Version de Décembre 2021"]
[null,null,null,"Coefficient de rive :",0.8,null,null,"Référence de l'appareil :",null,null,null,null,null,null,null,"< 0,5",">0,5 et <1",">1 et <3",">3 et <5",">5 et <10","> 10","< 0,5",">0,5 et <1",">1 et <3",">3 et <5","> 5","< 0,5",">0,5 et <5","> 5"]
[null,null,null,"Largeur du chenal :",0.6,null,null,"Référence de l'hélice :",null,null,null,null,null,null,null,"3 ou 4","4 ou 5","5 à 8","8 à 10","10 à 20",">20","5 ou 6","6 ou 7","7 à 12","13 à 16","> 22","≥ 15","≥ 20","≥ 22"]
[null,null,null,"Profondeur moyenne :",0.45,null,null,"Opérateur(s) :",null,null,null,null,null,null,null,{"$f":"IF($E$12<0.5,\"3 ou 4\",IF($E$12<1,\"4 ou 5\",IF($E$12<3,\"5 à 8\",IF($E$12<5,\"8 à 10\",IF($E$12<10,\"10 à 20\",\"> 20\")))))","v":"4 ou 5"},null,null,null,null,null,{"$f":"IF($E$12<0.5,\"5 ou 6\",IF($E$12<1,\"6 ou 7\",IF($E$12<3,\"7 à 12\",IF($E$12<5,\"13 à 16\",\"> 22\"))))","v":"6 ou 7"},null,null,null,null,{"$f":"IF($E$12<0.5,\"≥ 15\",IF($E$12<5,\"≥ 20\",\"≥ 22\"))","v":"≥ 20"}]
[]
[null,null,null,null,"Nombre de verticales retenues : ",1,null,null,null,null,null,null,"Nombre de points retenus par verticale : ",1,null,null,null,"Distance entre verticales : ",{"$f":"IF(F15=1,E12/2,($E$12-0.1)/($F$15-1))","v":0.3},null,"Nombre de points conseillés par verticale : ",null,null,null,null,{"$f":"IF(MAX(B23:N23)>0.2,3,2)","v":2}]
[]
[null,"Rive Gauche",{"$f":"IF($F$15>=1,\"Vert. 01\",IF($F$15=0,\"Rive Droite\",\"\"))","v":"Vert. 01"},{"$f":"IF($F$15>=2,\"Vert. 02\",IF($F$15=1,\"Rive Droite\",\"\"))","v":"Rive Droite"},{"$f":"IF($F$15>=3,\"Vert. 03\",IF($F$15=2,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=4,\"Vert. 04\",IF($F$15=3,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=5,\"Vert. 05\",IF($F$15=4,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=6,\"Vert. 06\",IF($F$15=5,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=7,\"Vert. 07\",IF($F$15=6,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=8,\"Vert. 08\",IF($F$15=7,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=9,\"Vert. 09\",IF($F$15=8,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=10,\"Vert. 10\",IF($F$15=9,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=11,\"Vert. 11\",IF($F$15=10,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=12,\"Vert. 12\",IF($F$15=11,\"Rive Droite\",\"\"))","v":""},null,"Rive Gauche",{"$f":"IF($F$15>=1,\"Vert. 01\",IF($F$15=0,\"Rive Droite\",\"\"))","v":"Vert. 01"},{"$f":"IF($F$15>=2,\"Vert. 02\",IF($F$15=1,\"Rive Droite\",\"\"))","v":"Rive Droite"},{"$f":"IF($F$15>=3,\"Vert. 03\",IF($F$15=2,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=4,\"Vert. 04\",IF($F$15=3,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=5,\"Vert. 05\",IF($F$15=4,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=6,\"Vert. 06\",IF($F$15=5,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=7,\"Vert. 07\",IF($F$15=6,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=8,\"Vert. 08\",IF($F$15=7,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=9,\"Vert. 09\",IF($F$15=8,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=10,\"Vert. 10\",IF($F$15=9,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=11,\"Vert. 11\",IF($F$15=10,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=12,\"Vert. 12\",IF($F$15=1,\"Rive Droite\",\"\"))","v":"Rive Droite"}]
[null,"Distances à la rive retenues pour chaque verticale (en mètre par rapport à la rive gauche) :",null,null,null,null,null,null,null,null,null,null,null,null,null,"Distances à la rive conseillées pour chaque verticale (en mètre par rapport à la rive gauche) :"]
[null,{"$f":"0","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"0","v":0},{"$f":"0.05","v":0.05},{"$f":"IF(Q19=\"\",\"\",IF(R17=\"Rive Droite\",$E$12,IF(Q19+$S$15<$E$12,Q19+$S$15,\"\")))","v":0.6},"","","","","","","","","",""]
[null,"Distances retenues entre verticales (en mètre) :",null,null,null,null,null,null,null,null,null,null,null,null,null,"Distances conseillées entre verticales (en mètre) :"]
[null,0,{"$f":"IF(AND(B$19<>\"\",C$19<>\"\"),C$19-B$19,\"\")","v":""},{"$f":"IF(AND(C$19<>\"\",D$19<>\"\"),D$19-C$19,\"\")","v":""},"","","","","","","","","","",null,0,{"$f":"IF(AND(P$19<>\"\",Q$19<>\"\"),Q$19-P$19,\"\")","v":0.05},{"$f":"IF(AND(Q$19<>\"\",R$19<>\"\"),R$19-Q$19,\"\")","v":0.54999999999999993},{"$f":"IF(AND(R$19<>\"\",S$19<>\"\"),S$19-R$19,\"\")","v":""},"","","","","","","","","",null,"≥"]
[null,"Hauteurs d'eau mesurées à chaque verticale (en mètre) :",null,null,null,null,null,null,null,null,null,null,null,null,null,"Rive Gauche",{"$f":"IF($F$15>=1,\"Vert. 01\",IF($F$15=0,\"Rive Droite\",\"\"))","v":"Vert. 01"},{"$f":"IF($F$15>=2,\"Vert. 02\",IF($F$15=1,\"Rive Droite\",\"\"))","v":"Rive Droite"},{"$f":"IF($F$15>=3,\"Vert. 03\",IF($F$15=2,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=4,\"Vert. 04\",IF($F$15=3,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=5,\"Vert. 05\",IF($F$15=4,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=6,\"Vert. 06\",IF($F$15=5,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=7,\"Vert. 07\",IF($F$15=6,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=8,\"Vert. 08\",IF($F$15=7,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=9,\"Vert. 09\",IF($F$15=8,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=10,\"Vert. 10\",IF($F$15=9,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=11,\"Vert. 11\",IF($F$15=10,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=12,\"Vert. 12\",IF($F$15=1,\"Rive Droite\",\"\"))","v":"Rive Droite"}]
[]
[null,"Hauteurs retenues pour chaque point de mesure de la vitesse d'écoulement (en mètre par rapport au fond) :",null,null,null,null,null,null,null,null,null,null,null,null,null,"Hauteurs conseillées pour chaque point de mesure de la vitesse d'écoulement (en mètre par rapport au fond) :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q$17=\"\",Q$17=\"Rive Droite\"),\"\",IF($N$15<5,\"\",C$23))","v":""},{"$f":"IF(OR(R$17=\"\",R$17=\"Rive Droite\"),\"\",IF($N$15<5,\"\",D$23))","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q$17=\"\",Q$17=\"Rive Droite\"),\"\",IF($N$15>1,C$23*0.8,\"\"))","v":""},{"$f":"IF(OR(R$17=\"\",R$17=\"Rive Droite\"),\"\",IF($N$15>1,D$23*0.8,\"\"))","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q$17=\"\",Q$17=\"Rive Droite\"),\"\",IF($N$15=6,C$23*0.6,\"\"))","v":""},"","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q$17=\"\",Q$17=\"Rive Droite\"),\"\",IF(OR($N$15>2,$N$15=1),C$23*0.4,\"\"))","v":0},{"$f":"IF(OR(R$17=\"\",R$17=\"Rive Droite\"),\"\",IF(OR($N$15>2,$N$15=1),D$23*0.4,\"\"))","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q$17=\"\",Q$17=\"Rive Droite\"),\"\",IF($N$15>1,C$23*0.2,\"\"))","v":""},{"$f":"IF(OR(R$17=\"\",R$17=\"Rive Droite\"),\"\",IF($N$15>1,D$23*0.2,\"\"))","v":""},"","",{"$f":"IF(OR(U$17=\"\",U$17=\"Rive Droite\"),\"\",IF($N$15>1,G$23*0.2,\"\"))","v":""},"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q$17=\"\",Q$17=\"Rive Droite\"),\"\",IF($N$15>=5,0,\"\"))","v":""},"","","","","","","","","","",""]
[null,"Vitesses d'écoulement mesurées à chaque point de mesure (en m/s) :",null,null,null,null,null,null,null,null,null,null,null,null,null,"Ecarts de mesure entre 2 points adjacents :",null,null,null,null,null,null,null,null,null,null,null,null,"Positionnement des points de mesure"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(W$17=\"\",W$17=\"Rive Droite\"),\"\",IF($N$15<5,\"\",I$23))","v":""},"","","","","",null,null,"Fil d'eau",null,{"$f":"IF(SUM($B25:$N25)=0,\"-\",1-AVERAGE($B25:$N25)/$E$13)","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q$17=\"\",Q$17=\"Rive Droite\"),\"\",C33-C32)","v":0},{"$f":"IF(OR(R$17=\"\",R$17=\"Rive Droite\"),\"\",D33-D32)","v":""},"","","","","","","","","","",null,null,0.8,null,{"$f":"IF(SUM($B26:$N26)=0,\"-\",AVERAGE($B26:$N26)/$E$13)","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q$17=\"\",Q$17=\"Rive Droite\"),\"\",C34-C33)","v":0},"","","","","","","","","","","",null,null,0.6,null,{"$f":"IF(SUM($B27:$N27)=0,\"-\",AVERAGE($B27:$N27)/$E$13)","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","","","",null,null,0.4,null,{"$f":"IF(SUM($B28:$N28)=0,\"-\",AVERAGE($B28:$N28)/$E$13)","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","","","",null,null,0.2,null,{"$f":"IF(SUM($B29:$N29)=0,\"-\",AVERAGE($B29:$N29)/$E$13)","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"","","","","","","","","","","",null,null,"Radier",null,{"$f":"IF(SUM($B30:$N30)=0,\"-\",AVERAGE($B30:$N30)/$E$13)","v":"-"}]
[null,"Vitesses moyennes calculées pour chaque verticale selon le nombre de points de mesure (en m/s) :",null,null,null,null,null,null,null,null,null,null,null,null,null,"Vitesse maximum :",null,null,null,null,null,null,null,null,null,null,null,null," 1    2     3     5     6",null,"Hauteurs d'eau conseillées pour la mesure des vitesses",null,"Hauteurs d'eau retenues pour la mesure des vitesses"]
[null,{"$f":"IF(B17=\"Rive Gauche\",(2*$E$11-1)*C39,IF(B17=\"Rive Droite\",(2*$E$11-1)*A39,IF(COUNTA(B32:B37)=1,B35,IF(AND(COUNTA(B32:B37)=2,AND(B33<>\"\",B36<>\"\")),AVERAGE(B33,B36),IF(AND(COUNTA(B32:B37)=3,AND(B33<>\"\",B35<>\"\",B36<>\"\")),0.25*(B33+B35*2+B36),IF(AND(COUNTA(B32:B37)=5,AND(B32<>\"\",B33<>\"\",B35<>\"\",B36<>\"\",B37<>\"\")),0.1*(B32+3*B33+3*B35+2*B36+B37),IF(AND(COUNTA(B32:B37)=6,AND(B32<>\"\",B33<>\"\",B34<>\"\",B35<>\"\",B36<>\"\",B37<>\"\")),0.1*(B32+2*B33+2*B34+2*B35+2*B36+B37),\"\")))))))","v":{"$error":"#VALUE!"}},{"$f":"IF(C17=\"Rive Gauche\",(2*$E$11-1)*D39,IF(C17=\"Rive Droite\",(2*$E$11-1)*B39,IF(COUNTA(C32:C37)=1,C35,IF(AND(COUNTA(C32:C37)=2,AND(C33<>\"\",C36<>\"\")),AVERAGE(C33,C36),IF(AND(COUNTA(C32:C37)=3,AND(C33<>\"\",C35<>\"\",C36<>\"\")),0.25*(C33+C35*2+C36),IF(AND(COUNTA(C32:C37)=5,AND(C32<>\"\",C33<>\"\",C35<>\"\",C36<>\"\",C37<>\"\")),0.1*(C32+3*C33+3*C35+2*C36+C37),IF(AND(COUNTA(C32:C37)=6,AND(C32<>\"\",C33<>\"\",C34<>\"\",C35<>\"\",C36<>\"\",C37<>\"\")),0.1*(C32+2*C33+2*C34+2*C35+2*C36+C37),\"\")))))))","v":""},{"$f":"IF(D17=\"Rive Gauche\",(2*$E$11-1)*E39,IF(D17=\"Rive Droite\",(2*$E$11-1)*C39,IF(COUNTA(D32:D37)=1,D35,IF(AND(COUNTA(D32:D37)=2,AND(D33<>\"\",D36<>\"\")),AVERAGE(D33,D36),IF(AND(COUNTA(D32:D37)=3,AND(D33<>\"\",D35<>\"\",D36<>\"\")),0.25*(D33+D35*2+D36),IF(AND(COUNTA(D32:D37)=5,AND(D32<>\"\",D33<>\"\",D35<>\"\",D36<>\"\",D37<>\"\")),0.1*(D32+3*D33+3*D35+2*D36+D37),IF(AND(COUNTA(D32:D37)=6,AND(D32<>\"\",D33<>\"\",D34<>\"\",D35<>\"\",D36<>\"\",D37<>\"\")),0.1*(D32+2*D33+2*D34+2*D35+2*D36+D37),\"\")))))))","v":{"$error":"#VALUE!"}},"","","",{"$f":"IF(H17=\"Rive Gauche\",(2*$E$11-1)*I39,IF(H17=\"Rive Droite\",(2*$E$11-1)*G39,IF(COUNTA(H32:H37)=1,H35,IF(AND(COUNTA(H32:H37)=2,AND(H33<>\"\",H36<>\"\")),AVERAGE(H33,H36),IF(AND(COUNTA(H32:H37)=3,AND(H33<>\"\",H35<>\"\",H36<>\"\")),0.25*(H33+H35*2+H36),IF(AND(COUNTA(H32:H37)=5,AND(H32<>\"\",H33<>\"\",H35<>\"\",H36<>\"\",H37<>\"\")),0.1*(H32+3*H33+3*H35+2*H36+H37),IF(AND(COUNTA(H32:H37)=6,AND(H32<>\"\",H33<>\"\",H34<>\"\",H35<>\"\",H36<>\"\",H37<>\"\")),0.1*(H32+2*H33+2*H34+2*H35+2*H36+H37),\"\")))))))","v":""},"","","","","","",null,{"$f":"MAX(C32:M37)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Nombre de points\nde mesure"]
[null,"Débits unitaires par verticale - Méthode de la section moyenne (en m3/s) :"]
[null,null,{"$f":"IF(C21<>\"\",C21*AVERAGE(B23:C23)*AVERAGE(B39:C39),\"\")","v":""},{"$f":"IF(D21<>\"\",D21*AVERAGE(C23:D23)*AVERAGE(C39:D39),\"\")","v":""},"","","","","","","","","",{"$f":"IF(N21<>\"\",N21*AVERAGE(M23:N23)*AVERAGE(M39:N39),\"\")","v":""}]
[null,{"$f":"IF(B41=\"\",\"\",B41/$H$44)","v":""},{"$f":"IF(C41=\"\",\"\",C41/$H$44)","v":""},"","","","","","","","","","",""]
[null,{"$f":"COUNTIF(A42:M42,\">0,1\")/COUNTA(A42:M42)","v":0},"des débits unitaires dépassent 10% du débit total",null,null,null,null,{"$f":"COUNTIF(Q33:AB37,\">0,2xP39\")/COUNTA(Q33:AB37)","v":0},"de mesures adjacentes dépassent 20% de la vitesse max"]
[null,"Débits sur la totalité de la section de mesure :",null,null,null,null,null,{"$f":"SUM(C41:N41)","v":0},null,{"$f":"H44*60*60","v":0},null,{"$f":"J44*24","v":0}]
[null,"Surface mouillée totale :",null,null,null,{"$f":"IF(C21=\"\",0,C21*AVERAGE(B23:C23))+IF(D21=\"\",0,D21*AVERAGE(C23:D23))+IF(E21=\"\",0,E21*AVERAGE(D23:E23))+IF(F21=\"\",0,F21*AVERAGE(E23:F23))+IF(G21=\"\",0,G21*AVERAGE(F23:G23))+IF(H21=\"\",0,H21*AVERAGE(G23:H23))+IF(I21=\"\",0,I21*AVERAGE(H23:I23))+IF(J21=\"\",0,J21*AVERAGE(I23:J23))+IF(K21=\"\",0,K21*AVERAGE(J23:K23))+IF(L21=\"\",0,L21*AVERAGE(K23:L23))+IF(M21=\"\",0,M21*AVERAGE(L23:M23))+IF(N21=\"\",0,N21*AVERAGE(M23:N23))","v":0},null,"Vitesse moyenne jaugée :",null,null,null,{"$f":"H44/F45","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Formules de calcul des vitesses moyennes selon le nombre de points de mesure par verticale :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Méthode à 1 point : Vitesse moyenne = V0,4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Méthode à 2 points : Vitesse moyenne = 0,5 x (V0,2 + V0,8)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Méthode à 3 points : Vitesse moyenne = 0,25 x (V0,2 + 2V0,6 + V0,8)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Méthode à 5 points : Vitesse moyenne = 0,1 x (Vsurface + 3V0,2 + 3V0,6 + 2V0,8 + Vfond)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Méthode à 6 points : Vitesse moyenne = 0,1 x (Vsurface + 2V0,2 + 2V0,4 + 2V0,6 + 2V0,8 + Vfond)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coefficients de rive :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kr = 1 : Berges lisses de forme rectangulaire è Débit maximal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kr = 0,8 : Valeur par défaut à utiliser pour les canaux rectangulaires"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kr = 0,5 : Berges de forme triangulaire è Débit nul"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nombre de verticales :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Le débit unitaire de chaque verticale doit être inférieur à  5% du débit total, et en aucun cas il ne doit dépasser 10% du débit total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"La distance entre 2 verticales doit être supérieure à la largeur du capteur"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Les première et dernière verticales doivent être aussi proche que possible de la bordure de l'eau"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nombre de points par verticale :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"La différence des mesures de vitesse entre 2 points adjacents ne doit pas dépasser 20% de la vitesse la plus élevée"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Les incertitudes de mesure en fonction du nombre de point sont les suivantes : 5 points 2,5%, 2 points 3,5%, 1 point 7,5%"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Méthode de mesure par point:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Le chenal de mesure doit être rectiligne, de section et de pente uniforme, présenter des longueurs droites en amont ≥ 6 fois la largeur du chanal et en aval ≥ 3 fois la largeur du chenal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Les directions d'écoulement doivent être parrallèles les unes aux autres et perpendiculaires à la section de mesurage"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Le dispositif utilisé pour réaliser le mesurage de la vitesse doit être positionné dans l'axe du flux"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Le dispositif utilisé pour réaliser le mesurage de la vitesse doit être maintenu en position pendant au moins 30 secondes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Le niveau d'eau doit être lu au début et à la fin de la période de mesurage"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Deux cycles complets de mesurage doivent être réalisés, si les résultats diffèrent de plus de 10% l'opération doit être répétée"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Les courantomètres électromagnétiques ne doivent pas être utilisés lorsque la hauteur d'eau est inférieure à 3 fois l'épaisseur du capteur"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Les courantomètres rotatifs ne doivent pas être utilisés lorsque la hauteur d'eau est inférieure à 4 fois le diamètre de l'hélice utilisée"]

{"sheet":"2 Points","index":1,"n_rows":76,"n_cols":33,"rows_kept":76,"cut":false,"hidden":false,"merged":[[39,1,39,13],[37,15,37,27],[44,1,44,4],[44,5,44,6],[44,7,44,10],[44,11,44,12],[37,1,37,13],[42,2,42,6],[42,8,42,13],[43,1,43,6],[43,7,43,8],[43,9,43,10],[43,11,43,12],[30,15,30,27],[23,1,23,13],[23,15,23,27],[30,1,30,13],[21,24,22,24],[21,25,22,25],[21,26,22,26],[19,1,19,13],[19,15,19,27],[21,0,22,0],[21,1,21,13],[21,15,22,15],[21,16,22,16],[21,17,22,17],[21,18,22,18],[21,19,22,19],[21,20,22,20],[21,27,22,27],[21,21,22,21],[21,22,22,22],[21,23,22,23],[12,4,12,5],[12,7,12,9],[12,10,12,13],[17,1,17,13],[17,15,17,27],[14,18,14,19],[14,20,14,24],[11,4,11,5],[11,7,11,9],[11,10,11,13],[8,4,8,5],[8,7,8,9],[8,10,8,13],[9,4,9,5],[9,7,9,9],[9,10,9,13],[10,4,10,5],[10,7,10,9],[10,10,10,13],[0,1,0,13],[3,4,3,5],[4,4,4,5],[5,4,5,5],[6,4,6,5],[6,9,6,10],[6,12,6,13],[1,1,1,13],[8,15,8,28],[9,15,9,20],[9,21,9,25],[9,26,9,28],[12,15,12,20],[12,21,12,25],[12,26,12,28],[30,28,30,33],[31,30,31,31],[31,32,31,33],[32,30,32,31],[32,32,32,33],[33,30,33,31],[33,32,33,33],[34,28,34,29],[34,30,34,31],[34,32,34,33],[35,28,35,29],[35,30,35,31],[35,32,35,33],[36,28,36,29],[36,30,36,31],[36,32,36,33],[37,28,37,29],[37,30,39,31],[37,32,39,33],[38,15,39,27],[38,28,39,29]]}
[null,"JAUGEAGE PAR EXPLORATION DU CHAMP DES VITESSES"]
[null,"METHODE POINTS ET FORMULES NORMALISEES"]
[]
[null,null,null,"Date :",null,null,null,"Maître d'ouvrage :"]
[null,null,null,"Heure de début :",null,null,null,"Nom de la prise :"]
[null,null,null,"Heure de fin :",null,null,null,"Localisation :"]
[null,null,null,"Durée de mesurage :",{"$f":"E6-E5","v":"00:00:00"},null,null,"GPS :","X :",null,null,"Y :"]
[]
[null,null,null,"Equipement en place :",null,null,null,"Equipement utilisé :",null,null,null,null,null,null,null,"Nombre de verticales recommandées par la norme NF EN ISO 748 selon la largeur du chenal"]
[null,null,null,"Forme du chenal :",null,null,null,"Type :",null,null,null,null,null,null,null,"Version de Janvier 2002",null,null,null,null,null,"Version de Avril 2009",null,null,null,null,"Version de Décembre 2021"]
[null,null,null,"Coefficient de rive :",0.8,null,null,"Référence de l'appareil :",null,null,null,null,null,null,null,"< 0,5",">0,5 et <1",">1 et <3",">3 et <5",">5 et <10","> 10","< 0,5",">0,5 et <1",">1 et <3",">3 et <5","> 5","< 0,5",">0,5 et <5","> 5"]
[null,null,null,"Largeur du chenal :",0.6,null,null,"Référence de l'hélice :",null,null,null,null,null,null,null,"3 ou 4","4 ou 5","5 à 8","8 à 10","10 à 20",">20","5 ou 6","6 ou 7","7 à 12","13 à 16","> 22","≥ 15","≥ 20","≥ 22"]
[null,null,null,"Profondeur moyenne :",0.45,null,null,"Opérateur(s) :",null,null,null,null,null,null,null,{"$f":"IF($E$12<0.5,\"3 ou 4\",IF($E$12<1,\"4 ou 5\",IF($E$12<3,\"5 à 8\",IF($E$12<5,\"8 à 10\",IF($E$12<10,\"10 à 20\",\"> 20\")))))","v":"4 ou 5"},null,null,null,null,null,{"$f":"IF($E$12<0.5,\"5 ou 6\",IF($E$12<1,\"6 ou 7\",IF($E$12<3,\"7 à 12\",IF($E$12<5,\"13 à 16\",\"> 22\"))))","v":"6 ou 7"},null,null,null,null,{"$f":"IF($E$12<0.5,\"≥ 15\",IF($E$12<5,\"≥ 20\",\"≥ 22\"))","v":"≥ 20"}]
[]
[null,null,null,null,"Nombre de verticales retenues : ",2,null,null,null,null,null,null,"Nombre de points retenus par verticale : ",2,null,null,null,"Distance entre verticales : ",{"$f":"IF(F15=1,E12/2,($E$12-0.1)/($F$15-1))","v":0.5},null,"Nombre de points conseillés par verticale : ",null,null,null,null,{"$f":"IF(MAX(B23:N23)>0.2,3,2)","v":2}]
[]
[null,"Rive Gauche",{"$f":"IF($F$15>=1,\"Vert. 01\",IF($F$15=0,\"Rive Droite\",\"\"))","v":"Vert. 01"},{"$f":"IF($F$15>=2,\"Vert. 02\",IF($F$15=1,\"Rive Droite\",\"\"))","v":"Vert. 02"},{"$f":"IF($F$15>=3,\"Vert. 03\",IF($F$15=2,\"Rive Droite\",\"\"))","v":"Rive Droite"},{"$f":"IF($F$15>=4,\"Vert. 04\",IF($F$15=3,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=5,\"Vert. 05\",IF($F$15=4,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=6,\"Vert. 06\",IF($F$15=5,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=7,\"Vert. 07\",IF($F$15=6,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=8,\"Vert. 08\",IF($F$15=7,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=9,\"Vert. 09\",IF($F$15=8,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=10,\"Vert. 10\",IF($F$15=9,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=11,\"Vert. 11\",IF($F$15=10,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=12,\"Vert. 12\",IF($F$15=11,\"Rive Droite\",\"\"))","v":""},null,"Rive Gauche",{"$f":"IF($F$15>=1,\"Vert. 01\",IF($F$15=0,\"Rive Droite\",\"\"))","v":"Vert. 01"},{"$f":"IF($F$15>=2,\"Vert. 02\",IF($F$15=1,\"Rive Droite\",\"\"))","v":"Vert. 02"},{"$f":"IF($F$15>=3,\"Vert. 03\",IF($F$15=2,\"Rive Droite\",\"\"))","v":"Rive Droite"},{"$f":"IF($F$15>=4,\"Vert. 04\",IF($F$15=3,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=5,\"Vert. 05\",IF($F$15=4,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=6,\"Vert. 06\",IF($F$15=5,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=7,\"Vert. 07\",IF($F$15=6,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=8,\"Vert. 08\",IF($F$15=7,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=9,\"Vert. 09\",IF($F$15=8,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=10,\"Vert. 10\",IF($F$15=9,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=11,\"Vert. 11\",IF($F$15=10,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=12,\"Vert. 12\",IF($F$15=1,\"Rive Droite\",\"\"))","v":""}]
[null,"Distances à la rive retenues pour chaque verticale (en mètre par rapport à la rive gauche) :",null,null,null,null,null,null,null,null,null,null,null,null,null,"Distances à la rive conseillées pour chaque verticale (en mètre par rapport à la rive gauche) :"]
[null,{"$f":"0","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"0","v":0},{"$f":"0.05","v":0.05},{"$f":"IF(Q19=\"\",\"\",IF(R17=\"Rive Droite\",$E$12,IF(Q19+$U$13<$E$12,Q19+$U$13,\"\")))","v":0.05},0.6,"","","","","","","","",""]
[null,"Distances retenues entre verticales (en mètre) :",null,null,null,null,null,null,null,null,null,null,null,null,null,"Distances conseillées entre verticales (en mètre) :"]
[null,0,{"$f":"IF(AND(B$19<>\"\",C$19<>\"\"),C$19-B$19,\"\")","v":""},{"$f":"IF(AND(C$19<>\"\",D$19<>\"\"),D$19-C$19,\"\")","v":""},"","","","","","","","","","",null,0,{"$f":"IF(AND(P$19<>\"\",Q$19<>\"\"),Q$19-P$19,\"\")","v":0.05},{"$f":"IF(AND(Q$19<>\"\",R$19<>\"\"),R$19-Q$19,\"\")","v":0},{"$f":"IF(AND(R$19<>\"\",S$19<>\"\"),S$19-R$19,\"\")","v":0.54999999999999993},"","","","","","","","",""]
[null,"Hauteurs d'eau mesurées à chaque verticale (en mètre) :",null,null,null,null,null,null,null,null,null,null,null,null,null,"Rive Gauche",{"$f":"IF($F$15>=1,\"Vert. 01\",IF($F$15=0,\"Rive Droite\",\"\"))","v":"Vert. 01"},{"$f":"IF($F$15>=2,\"Vert. 02\",IF($F$15=1,\"Rive Droite\",\"\"))","v":"Vert. 02"},{"$f":"IF($F$15>=3,\"Vert. 03\",IF($F$15=2,\"Rive Droite\",\"\"))","v":"Rive Droite"},{"$f":"IF($F$15>=4,\"Vert. 04\",IF($F$15=3,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=5,\"Vert. 05\",IF($F$15=4,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=6,\"Vert. 06\",IF($F$15=5,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=7,\"Vert. 07\",IF($F$15=6,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=8,\"Vert. 08\",IF($F$15=7,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=9,\"Vert. 09\",IF($F$15=8,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=10,\"Vert. 10\",IF($F$15=9,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=11,\"Vert. 11\",IF($F$15=10,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=12,\"Vert. 12\",IF($F$15=1,\"Rive Droite\",\"\"))","v":""}]
[]
[null,"Hauteurs retenues pour chaque point de mesure de la vitesse d'écoulement (en mètre par rapport au fond) :",null,null,null,null,null,null,null,null,null,null,null,null,null,"Hauteurs conseillées pour chaque point de mesure de la vitesse d'écoulement (en mètre par rapport au fond) :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q$17=\"\",Q$17=\"Rive Droite\"),\"\",IF($N$15<5,\"\",C$23))","v":""},{"$f":"IF(OR(R$17=\"\",R$17=\"Rive Droite\"),\"\",IF($N$15<5,\"\",D$23))","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q$17=\"\",Q$17=\"Rive Droite\"),\"\",IF($N$15>1,C$23*0.8,\"\"))","v":0},{"$f":"IF(OR(R$17=\"\",R$17=\"Rive Droite\"),\"\",IF($N$15>1,D$23*0.8,\"\"))","v":0},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q$17=\"\",Q$17=\"Rive Droite\"),\"\",IF($N$15=6,C$23*0.6,\"\"))","v":""},"","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q$17=\"\",Q$17=\"Rive Droite\"),\"\",IF(OR($N$15>2,$N$15=1),C$23*0.8,\"\"))","v":""},{"$f":"IF(OR(R$17=\"\",R$17=\"Rive Droite\"),\"\",IF($N$15>=3,D$23*0.4,\"\"))","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q$17=\"\",Q$17=\"Rive Droite\"),\"\",IF($N$15>1,C$23*0.2,\"\"))","v":0},{"$f":"IF(OR(R$17=\"\",R$17=\"Rive Droite\"),\"\",IF($N$15>1,D$23*0.2,\"\"))","v":0},"","",{"$f":"IF(OR(U$17=\"\",U$17=\"Rive Droite\"),\"\",IF($N$15>1,G$23*0.2,\"\"))","v":""},"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q$17=\"\",Q$17=\"Rive Droite\"),\"\",IF($N$15>=5,0,\"\"))","v":""},"","","","","","","","","","",""]
[null,"Vitesses d'écoulement mesurées à chaque point de mesure (en m/s) :",null,null,null,null,null,null,null,null,null,null,null,null,null,"Ecarts de mesure entre 2 points adjacents :",null,null,null,null,null,null,null,null,null,null,null,null,"Positionnement des points de mesure"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(W$17=\"\",W$17=\"Rive Droite\"),\"\",IF($N$15<5,\"\",I$23))","v":""},"","","","","",null,null,"Fil d'eau",null,{"$f":"IF(SUM($B25:$N25)=0,\"-\",1-AVERAGE($B25:$N25)/$E$13)","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q$17=\"\",Q$17=\"Rive Droite\"),\"\",C33-C32)","v":0},{"$f":"IF(OR(R$17=\"\",R$17=\"Rive Droite\"),\"\",D33-D32)","v":0},"","","","","","","","","","",null,null,0.8,null,{"$f":"IF(SUM($B26:$N26)=0,\"-\",AVERAGE($B26:$N26)/$E$13)","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q$17=\"\",Q$17=\"Rive Droite\"),\"\",C34-C33)","v":0},0,"","","","","","","","","","",null,null,0.6,null,{"$f":"IF(SUM($B27:$N27)=0,\"-\",AVERAGE($B27:$N27)/$E$13)","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"","","","","","","","","","",null,null,0.4,null,{"$f":"IF(SUM($B28:$N28)=0,\"-\",AVERAGE($B28:$N28)/$E$13)","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"","","","","","","","","","",null,null,0.2,null,{"$f":"IF(SUM($B29:$N29)=0,\"-\",AVERAGE($B29:$N29)/$E$13)","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"","","","","","","","","","",null,null,"Radier",null,{"$f":"IF(SUM($B30:$N30)=0,\"-\",AVERAGE($B30:$N30)/$E$13)","v":"-"}]
[null,"Vitesses moyennes calculées pour chaque verticale selon le nombre de points de mesure (en m/s) :",null,null,null,null,null,null,null,null,null,null,null,null,null,"Vitesse maximum :",null,null,null,null,null,null,null,null,null,null,null,null," 1    2     3     5     6",null,"Hauteurs d'eau conseillées pour la mesure des vitesses",null,"Hauteurs d'eau retenues pour la mesure des vitesses"]
[null,{"$f":"IF(B17=\"Rive Gauche\",(2*$E$11-1)*C39,IF(B17=\"Rive Droite\",(2*$E$11-1)*A39,IF(COUNTA(B32:B37)=1,B35,IF(AND(COUNTA(B32:B37)=2,AND(B33<>\"\",B36<>\"\")),AVERAGE(B33,B36),IF(AND(COUNTA(B32:B37)=3,AND(B33<>\"\",B35<>\"\",B36<>\"\")),0.25*(B33+B35*2+B36),IF(AND(COUNTA(B32:B37)=5,AND(B32<>\"\",B33<>\"\",B35<>\"\",B36<>\"\",B37<>\"\")),0.1*(B32+3*B33+3*B35+2*B36+B37),IF(AND(COUNTA(B32:B37)=6,AND(B32<>\"\",B33<>\"\",B34<>\"\",B35<>\"\",B36<>\"\",B37<>\"\")),0.1*(B32+2*B33+2*B34+2*B35+2*B36+B37),\"\")))))))","v":{"$error":"#VALUE!"}},{"$f":"IF(C17=\"Rive Gauche\",(2*$E$11-1)*D39,IF(C17=\"Rive Droite\",(2*$E$11-1)*B39,IF(COUNTA(C32:C37)=1,C35,IF(AND(COUNTA(C32:C37)=2,AND(C33<>\"\",C36<>\"\")),AVERAGE(C33,C36),IF(AND(COUNTA(C32:C37)=3,AND(C33<>\"\",C35<>\"\",C36<>\"\")),0.25*(C33+C35*2+C36),IF(AND(COUNTA(C32:C37)=5,AND(C32<>\"\",C33<>\"\",C35<>\"\",C36<>\"\",C37<>\"\")),0.1*(C32+3*C33+3*C35+2*C36+C37),IF(AND(COUNTA(C32:C37)=6,AND(C32<>\"\",C33<>\"\",C34<>\"\",C35<>\"\",C36<>\"\",C37<>\"\")),0.1*(C32+2*C33+2*C34+2*C35+2*C36+C37),\"\")))))))","v":""},{"$f":"IF(D17=\"Rive Gauche\",(2*$E$11-1)*E39,IF(D17=\"Rive Droite\",(2*$E$11-1)*C39,IF(COUNTA(D32:D37)=1,D35,IF(AND(COUNTA(D32:D37)=2,AND(D33<>\"\",D36<>\"\")),AVERAGE(D33,D36),IF(AND(COUNTA(D32:D37)=3,AND(D33<>\"\",D35<>\"\",D36<>\"\")),0.25*(D33+D35*2+D36),IF(AND(COUNTA(D32:D37)=5,AND(D32<>\"\",D33<>\"\",D35<>\"\",D36<>\"\",D37<>\"\")),0.1*(D32+3*D33+3*D35+2*D36+D37),IF(AND(COUNTA(D32:D37)=6,AND(D32<>\"\",D33<>\"\",D34<>\"\",D35<>\"\",D36<>\"\",D37<>\"\")),0.1*(D32+2*D33+2*D34+2*D35+2*D36+D37),\"\")))))))","v":""},{"$error":"#VALUE!"},"","",{"$f":"IF(H17=\"Rive Gauche\",(2*$E$11-1)*I39,IF(H17=\"Rive Droite\",(2*$E$11-1)*G39,IF(COUNTA(H32:H37)=1,H35,IF(AND(COUNTA(H32:H37)=2,AND(H33<>\"\",H36<>\"\")),AVERAGE(H33,H36),IF(AND(COUNTA(H32:H37)=3,AND(H33<>\"\",H35<>\"\",H36<>\"\")),0.25*(H33+H35*2+H36),IF(AND(COUNTA(H32:H37)=5,AND(H32<>\"\",H33<>\"\",H35<>\"\",H36<>\"\",H37<>\"\")),0.1*(H32+3*H33+3*H35+2*H36+H37),IF(AND(COUNTA(H32:H37)=6,AND(H32<>\"\",H33<>\"\",H34<>\"\",H35<>\"\",H36<>\"\",H37<>\"\")),0.1*(H32+2*H33+2*H34+2*H35+2*H36+H37),\"\")))))))","v":""},"","","","","","",null,{"$f":"MAX(C32:M37)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Nombre de points\nde mesure"]
[null,"Débits unitaires par verticale - Méthode de la section moyenne (en m3/s) :"]
[null,null,{"$f":"IF(C21<>\"\",C21*AVERAGE(B23:C23)*AVERAGE(B39:C39),\"\")","v":""},{"$f":"IF(D21<>\"\",D21*AVERAGE(C23:D23)*AVERAGE(C39:D39),\"\")","v":""},"","","","","","","","","",{"$f":"IF(N21<>\"\",N21*AVERAGE(M23:N23)*AVERAGE(M39:N39),\"\")","v":""}]
[null,{"$f":"IF(B41=\"\",\"\",B41/$H$44)","v":""},{"$f":"IF(C41=\"\",\"\",C41/$H$44)","v":""},"","","","","","","","","","",""]
[null,{"$f":"COUNTIF(A42:M42,\">0,1\")/COUNTA(A42:M42)","v":0},"des débits unitaires dépassent 10% du débit total",null,null,null,null,{"$f":"COUNTIF(Q33:AB37,\">0,2xP39\")/COUNTA(Q33:AB37)","v":0},"de mesures adjacentes dépassent 20% de la vitesse max"]
[null,"Débits sur la totalité de la section de mesure :",null,null,null,null,null,{"$f":"SUM(C41:N41)","v":0},null,{"$f":"H44*60*60","v":0},null,{"$f":"J44*24","v":0}]
[null,"Surface mouillée totale :",null,null,null,{"$f":"IF(C21=\"\",0,C21*AVERAGE(B23:C23))+IF(D21=\"\",0,D21*AVERAGE(C23:D23))+IF(E21=\"\",0,E21*AVERAGE(D23:E23))+IF(F21=\"\",0,F21*AVERAGE(E23:F23))+IF(G21=\"\",0,G21*AVERAGE(F23:G23))+IF(H21=\"\",0,H21*AVERAGE(G23:H23))+IF(I21=\"\",0,I21*AVERAGE(H23:I23))+IF(J21=\"\",0,J21*AVERAGE(I23:J23))+IF(K21=\"\",0,K21*AVERAGE(J23:K23))+IF(L21=\"\",0,L21*AVERAGE(K23:L23))+IF(M21=\"\",0,M21*AVERAGE(L23:M23))+IF(N21=\"\",0,N21*AVERAGE(M23:N23))","v":0},null,"Vitesse moyenne jaugée :",null,null,null,{"$f":"H44/F45","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Formules de calcul des vitesses moyennes selon le nombre de points de mesure par verticale :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Méthode à 1 point : Vitesse moyenne = V0,4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Méthode à 2 points : Vitesse moyenne = 0,5 x (V0,2 + V0,8)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Méthode à 3 points : Vitesse moyenne = 0,25 x (V0,2 + 2V0,6 + V0,8)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Méthode à 5 points : Vitesse moyenne = 0,1 x (Vsurface + 3V0,2 + 3V0,6 + 2V0,8 + Vfond)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Méthode à 6 points : Vitesse moyenne = 0,1 x (Vsurface + 2V0,2 + 2V0,4 + 2V0,6 + 2V0,8 + Vfond)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coefficients de rive :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kr = 1 : Berges lisses de forme rectangulaire è Débit maximal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kr = 0,8 : Valeur par défaut à utiliser pour les canaux rectangulaires"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kr = 0,5 : Berges de forme triangulaire è Débit nul"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nombre de verticales :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Le débit unitaire de chaque verticale doit être inférieur à  5% du débit total, et en aucun cas il ne doit dépasser 10% du débit total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"La distance entre 2 verticales doit être supérieure à la largeur du capteur"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Les première et dernière verticales doivent être aussi proche que possible de la bordure de l'eau"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nombre de points par verticale :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"La différence des mesures de vitesse entre 2 points adjacents ne doit pas dépasser 20% de la vitesse la plus élevée"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Les incertitudes de mesure en fonction du nombre de point sont les suivantes : 5 points 2,5%, 2 points 3,5%, 1 point 7,5%"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Méthode de mesure par point:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Le chenal de mesure doit être rectiligne, de section et de pente uniforme, présenter des longueurs droites en amont ≥ 6 fois la largeur du chanal et en aval ≥ 3 fois la largeur du chenal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Les directions d'écoulement doivent être parrallèles les unes aux autres et perpendiculaires à la section de mesurage"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Le dispositif utilisé pour réaliser le mesurage de la vitesse doit être positionné dans l'axe du flux"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Le dispositif utilisé pour réaliser le mesurage de la vitesse doit être maintenu en position pendant au moins 30 secondes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Le niveau d'eau doit être lu au début et à la fin de la période de mesurage"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Deux cycles complets de mesurage doivent être réalisés, si les résultats diffèrent de plus de 10% l'opération doit être répétée"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Les courantomètres électromagnétiques ne doivent pas être utilisés lorsque la hauteur d'eau est inférieure à 3 fois l'épaisseur du capteur"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Les courantomètres rotatifs ne doivent pas être utilisés lorsque la hauteur d'eau est inférieure à 4 fois le diamètre de l'hélice utilisée"]

{"sheet":"3 Points","index":2,"n_rows":76,"n_cols":33,"rows_kept":76,"cut":false,"hidden":false,"merged":[[43,1,43,6],[43,7,43,8],[43,9,43,10],[43,11,43,12],[44,1,44,4],[44,5,44,6],[44,7,44,10],[44,11,44,12],[30,15,30,27],[23,1,23,13],[23,15,23,27],[30,1,30,13],[21,24,22,24],[21,25,22,25],[21,26,22,26],[19,1,19,13],[19,15,19,27],[21,0,22,0],[21,1,21,13],[21,15,22,15],[21,16,22,16],[21,17,22,17],[21,18,22,18],[21,19,22,19],[21,20,22,20],[21,27,22,27],[21,21,22,21],[21,22,22,22],[21,23,22,23],[12,4,12,5],[12,7,12,9],[12,10,12,13],[17,1,17,13],[17,15,17,27],[14,18,14,19],[14,20,14,24],[6,4,6,5],[6,9,6,10],[6,12,6,13],[11,4,11,5],[11,7,11,9],[11,10,11,13],[8,4,8,5],[8,7,8,9],[8,10,8,13],[9,4,9,5],[9,7,9,9],[9,10,9,13],[10,4,10,5],[10,7,10,9],[10,10,10,13],[1,1,1,13],[0,1,0,13],[3,4,3,5],[4,4,4,5],[5,4,5,5],[8,15,8,28],[9,15,9,20],[9,21,9,25],[9,26,9,28],[12,15,12,20],[12,21,12,25],[12,26,12,28],[30,28,30,33],[31,30,31,31],[31,32,31,33],[32,30,32,31],[32,32,32,33],[33,30,33,31],[33,32,33,33],[34,28,34,29],[34,30,34,31],[34,32,34,33],[35,28,35,29],[35,30,35,31],[35,32,35,33],[36,28,36,29],[36,30,36,31],[36,32,36,33],[42,2,42,6],[42,8,42,13],[37,28,37,29],[37,30,39,31],[37,32,39,33],[38,15,39,27],[38,28,39,29],[37,1,37,13],[39,1,39,13],[37,15,37,27]]}
[null,"JAUGEAGE PAR EXPLORATION DU CHAMP DES VITESSES"]
[null,"METHODE POINTS ET FORMULES NORMALISEES"]
[]
[null,null,null,"Date :",null,null,null,"Maître d'ouvrage :"]
[null,null,null,"Heure de début :",null,null,null,"Nom de la prise :"]
[null,null,null,"Heure de fin :",null,null,null,"Localisation :"]
[null,null,null,"Durée de mesurage :",{"$f":"E6-E5","v":"00:00:00"},null,null,"GPS :","X :",null,null,"Y :"]
[]
[null,null,null,"Equipement en place :",null,null,null,"Equipement utilisé :",null,null,null,null,null,null,null,"Nombre de verticales recommandées par la norme NF EN ISO 748 selon la largeur du chenal"]
[null,null,null,"Forme du chenal :",null,null,null,"Type :",null,null,null,null,null,null,null,"Version de Janvier 2002",null,null,null,null,null,"Version de Avril 2009",null,null,null,null,"Version de Décembre 2021"]
[null,null,null,"Coefficient de rive :",0.8,null,null,"Référence de l'appareil :",null,null,null,null,null,null,null,"< 0,5",">0,5 et <1",">1 et <3",">3 et <5",">5 et <10","> 10","< 0,5",">0,5 et <1",">1 et <3",">3 et <5","> 5","< 0,5",">0,5 et <5","> 5"]
[null,null,null,"Largeur du chenal :",0.6,null,null,"Référence de l'hélice :",null,null,null,null,null,null,null,"3 ou 4","4 ou 5","5 à 8","8 à 10","10 à 20",">20","5 ou 6","6 ou 7","7 à 12","13 à 16","> 22","≥ 15","≥ 20","≥ 22"]
[null,null,null,"Profondeur moyenne :",0.45,null,null,"Opérateur(s) :",null,null,null,null,null,null,null,{"$f":"IF($E$12<0.5,\"3 ou 4\",IF($E$12<1,\"4 ou 5\",IF($E$12<3,\"5 à 8\",IF($E$12<5,\"8 à 10\",IF($E$12<10,\"10 à 20\",\"> 20\")))))","v":"4 ou 5"},null,null,null,null,null,{"$f":"IF($E$12<0.5,\"5 ou 6\",IF($E$12<1,\"6 ou 7\",IF($E$12<3,\"7 à 12\",IF($E$12<5,\"13 à 16\",\"> 22\"))))","v":"6 ou 7"},null,null,null,null,{"$f":"IF($E$12<0.5,\"≥ 15\",IF($E$12<5,\"≥ 20\",\"≥ 22\"))","v":"≥ 20"}]
[]
[null,null,null,null,"Nombre de verticales retenues : ",6,null,null,null,null,null,null,"Nombre de points retenus par verticale : ",3,null,null,null,"Distance entre verticales : ",{"$f":"IF(F15=1,E12/2,($E$12-0.1)/($F$15-1))","v":0.1},null,"Nombre de points conseillés par verticale : ",null,null,null,null,{"$f":"IF(MAX(B23:N23)>0.2,3,2)","v":2}]
[]
[null,"Rive Gauche",{"$f":"IF($F$15>=1,\"Vert. 01\",IF($F$15=0,\"Rive Droite\",\"\"))","v":"Vert. 01"},{"$f":"IF($F$15>=2,\"Vert. 02\",IF($F$15=1,\"Rive Droite\",\"\"))","v":"Vert. 02"},{"$f":"IF($F$15>=3,\"Vert. 03\",IF($F$15=2,\"Rive Droite\",\"\"))","v":"Vert. 03"},{"$f":"IF($F$15>=4,\"Vert. 04\",IF($F$15=3,\"Rive Droite\",\"\"))","v":"Vert. 04"},{"$f":"IF($F$15>=5,\"Vert. 05\",IF($F$15=4,\"Rive Droite\",\"\"))","v":"Vert. 05"},{"$f":"IF($F$15>=6,\"Vert. 06\",IF($F$15=5,\"Rive Droite\",\"\"))","v":"Vert. 06"},{"$f":"IF($F$15>=7,\"Vert. 07\",IF($F$15=6,\"Rive Droite\",\"\"))","v":"Rive Droite"},{"$f":"IF($F$15>=8,\"Vert. 08\",IF($F$15=7,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=9,\"Vert. 09\",IF($F$15=8,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=10,\"Vert. 10\",IF($F$15=9,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=11,\"Vert. 11\",IF($F$15=10,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=12,\"Vert. 12\",IF($F$15=11,\"Rive Droite\",\"\"))","v":""},null,"Rive Gauche",{"$f":"IF($F$15>=1,\"Vert. 01\",IF($F$15=0,\"Rive Droite\",\"\"))","v":"Vert. 01"},{"$f":"IF($F$15>=2,\"Vert. 02\",IF($F$15=1,\"Rive Droite\",\"\"))","v":"Vert. 02"},{"$f":"IF($F$15>=3,\"Vert. 03\",IF($F$15=2,\"Rive Droite\",\"\"))","v":"Vert. 03"},{"$f":"IF($F$15>=4,\"Vert. 04\",IF($F$15=3,\"Rive Droite\",\"\"))","v":"Vert. 04"},{"$f":"IF($F$15>=5,\"Vert. 05\",IF($F$15=4,\"Rive Droite\",\"\"))","v":"Vert. 05"},{"$f":"IF($F$15>=6,\"Vert. 06\",IF($F$15=5,\"Rive Droite\",\"\"))","v":"Vert. 06"},{"$f":"IF($F$15>=7,\"Vert. 07\",IF($F$15=6,\"Rive Droite\",\"\"))","v":"Rive Droite"},{"$f":"IF($F$15>=8,\"Vert. 08\",IF($F$15=7,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=9,\"Vert. 09\",IF($F$15=8,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=10,\"Vert. 10\",IF($F$15=9,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=11,\"Vert. 11\",IF($F$15=10,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=12,\"Vert. 12\",IF($F$15=1,\"Rive Droite\",\"\"))","v":""}]
[null,"Distances à la rive retenues pour chaque verticale (en mètre par rapport à la rive gauche) :",null,null,null,null,null,null,null,null,null,null,null,null,null,"Distances à la rive conseillées pour chaque verticale (en mètre par rapport à la rive gauche) :"]
[null,{"$f":"0","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"0","v":0},{"$f":"0.05","v":0.05},{"$f":"IF(Q19=\"\",\"\",IF(R17=\"Rive Droite\",$E$12,IF(Q19+$U$13<$E$12,Q19+$U$13,\"\")))","v":0.05},0.05,0.05,0.05,0.05,0.6,"","","","","",null,264]
[null,"Distances retenues entre verticales (en mètre) :",null,null,null,null,null,null,null,null,null,null,null,null,null,"Distances conseillées entre verticales (en mètre) :",null,null,null,null,null,null,null,null,null,null,null,null,null,24]
[null,0,{"$f":"IF(AND(B$19<>\"\",C$19<>\"\"),C$19-B$19,\"\")","v":""},{"$f":"IF(AND(C$19<>\"\",D$19<>\"\"),D$19-C$19,\"\")","v":""},"","","","","","","","","","",null,0,{"$f":"IF(AND(P$19<>\"\",Q$19<>\"\"),Q$19-P$19,\"\")","v":0.05},{"$f":"IF(AND(Q$19<>\"\",R$19<>\"\"),R$19-Q$19,\"\")","v":0},{"$f":"IF(AND(R$19<>\"\",S$19<>\"\"),S$19-R$19,\"\")","v":0},0,0,0,0.54999999999999993,"","","","","",null,365]
[null,"Hauteurs d'eau mesurées à chaque verticale (en mètre) :",null,null,null,null,null,null,null,null,null,null,null,null,null,"Rive Gauche",{"$f":"IF($F$15>=1,\"Vert. 01\",IF($F$15=0,\"Rive Droite\",\"\"))","v":"Vert. 01"},{"$f":"IF($F$15>=2,\"Vert. 02\",IF($F$15=1,\"Rive Droite\",\"\"))","v":"Vert. 02"},{"$f":"IF($F$15>=3,\"Vert. 03\",IF($F$15=2,\"Rive Droite\",\"\"))","v":"Vert. 03"},{"$f":"IF($F$15>=4,\"Vert. 04\",IF($F$15=3,\"Rive Droite\",\"\"))","v":"Vert. 04"},{"$f":"IF($F$15>=5,\"Vert. 05\",IF($F$15=4,\"Rive Droite\",\"\"))","v":"Vert. 05"},{"$f":"IF($F$15>=6,\"Vert. 06\",IF($F$15=5,\"Rive Droite\",\"\"))","v":"Vert. 06"},{"$f":"IF($F$15>=7,\"Vert. 07\",IF($F$15=6,\"Rive Droite\",\"\"))","v":"Rive Droite"},{"$f":"IF($F$15>=8,\"Vert. 08\",IF($F$15=7,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=9,\"Vert. 09\",IF($F$15=8,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=10,\"Vert. 10\",IF($F$15=9,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=11,\"Vert. 11\",IF($F$15=10,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=12,\"Vert. 12\",IF($F$15=1,\"Rive Droite\",\"\"))","v":""},null,{"$f":"+AD19*AD20*AD21","v":2312640}]
[]
[null,"Hauteurs retenues pour chaque point de mesure de la vitesse d'écoulement (en mètre par rapport au fond) :",null,null,null,null,null,null,null,null,null,null,null,null,null,"Hauteurs conseillées pour chaque point de mesure de la vitesse d'écoulement (en mètre par rapport au fond) :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q$17=\"\",Q$17=\"Rive Droite\"),\"\",IF($N$15<5,\"\",C$23))","v":""},{"$f":"IF(OR(R$17=\"\",R$17=\"Rive Droite\"),\"\",IF($N$15<5,\"\",D$23))","v":""},"","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q$17=\"\",Q$17=\"Rive Droite\"),\"\",IF($N$15>1,C$23*0.8,\"\"))","v":0},{"$f":"IF(OR(R$17=\"\",R$17=\"Rive Droite\"),\"\",IF($N$15>1,D$23*0.8,\"\"))","v":0},0,0,0,0,"","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q$17=\"\",Q$17=\"Rive Droite\"),\"\",IF($N$15=6,C$23*0.6,\"\"))","v":""},"","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q$17=\"\",Q$17=\"Rive Droite\"),\"\",IF(OR($N$15>2,$N$15=1),C$23*0.4,\"\"))","v":0},{"$f":"IF(OR(R$17=\"\",R$17=\"Rive Droite\"),\"\",IF(OR($N$15>2,$N$15=1),D$23*0.4,\"\"))","v":0},0,0,0,0,"","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q$17=\"\",Q$17=\"Rive Droite\"),\"\",IF($N$15>1,C$23*0.2,\"\"))","v":0},{"$f":"IF(OR(R$17=\"\",R$17=\"Rive Droite\"),\"\",IF($N$15>1,D$23*0.2,\"\"))","v":0},0,0,{"$f":"IF(OR(U$17=\"\",U$17=\"Rive Droite\"),\"\",IF($N$15>1,G$23*0.2,\"\"))","v":0},0,"","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q$17=\"\",Q$17=\"Rive Droite\"),\"\",IF($N$15>=5,0,\"\"))","v":""},"","","","","","","","","","",""]
[null,"Vitesses d'écoulement mesurées pendant 30 secondes à chaque point de mesure (en m/s) :",null,null,null,null,null,null,null,null,null,null,null,null,null,"Ecarts de mesure entre 2 points adjacents :",null,null,null,null,null,null,null,null,null,null,null,null,"Positionnement des points de mesure"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(W$17=\"\",W$17=\"Rive Droite\"),\"\",IF($N$15<5,\"\",I$23))","v":""},"","","","","",null,null,"Fil d'eau",null,{"$f":"IF(SUM($B25:$N25)=0,\"-\",1-AVERAGE($B25:$N25)/$E$13)","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q$17=\"\",Q$17=\"Rive Droite\"),\"\",C33-C32)","v":0},{"$f":"IF(OR(R$17=\"\",R$17=\"Rive Droite\"),\"\",D33-D32)","v":0},0,0,0,0,"","","","","","",null,null,0.8,null,{"$f":"IF(SUM($B26:$N26)=0,\"-\",AVERAGE($B26:$N26)/$E$13)","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q$17=\"\",Q$17=\"Rive Droite\"),\"\",C34-C33)","v":0},0,0,0,0,0,"","","","","","",null,null,0.6,null,{"$f":"IF(SUM($B27:$N27)=0,\"-\",AVERAGE($B27:$N27)/$E$13)","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,"","","","","","",null,null,0.4,null,{"$f":"IF(SUM($B28:$N28)=0,\"-\",AVERAGE($B28:$N28)/$E$13)","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,"","","","","","",null,null,0.2,null,{"$f":"IF(SUM($B29:$N29)=0,\"-\",AVERAGE($B29:$N29)/$E$13)","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,"","","","","","",null,null,"Radier",null,{"$f":"IF(SUM($B30:$N30)=0,\"-\",AVERAGE($B30:$N30)/$E$13)","v":"-"}]
[null,"Vitesses moyennes calculées pour chaque verticale selon le nombre de points de mesure (en m/s) :",null,null,null,null,null,null,null,null,null,null,null,null,null,"Vitesse maximum :",null,null,null,null,null,null,null,null,null,null,null,null," 1    2     3     5     6",null,"Hauteurs d'eau conseillées pour la mesure des vitesses",null,"Hauteurs d'eau retenues pour la mesure des vitesses"]
[null,{"$f":"IF(B17=\"Rive Gauche\",(2*$E$11-1)*C39,IF(B17=\"Rive Droite\",(2*$E$11-1)*A39,IF(COUNTA(B32:B37)=1,B35,IF(AND(COUNTA(B32:B37)=2,AND(B33<>\"\",B36<>\"\")),AVERAGE(B33,B36),IF(AND(COUNTA(B32:B37)=3,AND(B33<>\"\",B35<>\"\",B36<>\"\")),0.25*(B33+B35*2+B36),IF(AND(COUNTA(B32:B37)=5,AND(B32<>\"\",B33<>\"\",B35<>\"\",B36<>\"\",B37<>\"\")),0.1*(B32+3*B33+3*B35+2*B36+B37),IF(AND(COUNTA(B32:B37)=6,AND(B32<>\"\",B33<>\"\",B34<>\"\",B35<>\"\",B36<>\"\",B37<>\"\")),0.1*(B32+2*B33+2*B34+2*B35+2*B36+B37),\"\")))))))","v":{"$error":"#VALUE!"}},{"$f":"IF(C17=\"Rive Gauche\",(2*$E$11-1)*D39,IF(C17=\"Rive Droite\",(2*$E$11-1)*B39,IF(COUNTA(C32:C37)=1,C35,IF(AND(COUNTA(C32:C37)=2,AND(C33<>\"\",C36<>\"\")),AVERAGE(C33,C36),IF(AND(COUNTA(C32:C37)=3,AND(C33<>\"\",C35<>\"\",C36<>\"\")),0.25*(C33+C35*2+C36),IF(AND(COUNTA(C32:C37)=5,AND(C32<>\"\",C33<>\"\",C35<>\"\",C36<>\"\",C37<>\"\")),0.1*(C32+3*C33+3*C35+2*C36+C37),IF(AND(COUNTA(C32:C37)=6,AND(C32<>\"\",C33<>\"\",C34<>\"\",C35<>\"\",C36<>\"\",C37<>\"\")),0.1*(C32+2*C33+2*C34+2*C35+2*C36+C37),\"\")))))))","v":""},{"$f":"IF(D17=\"Rive Gauche\",(2*$E$11-1)*E39,IF(D17=\"Rive Droite\",(2*$E$11-1)*C39,IF(COUNTA(D32:D37)=1,D35,IF(AND(COUNTA(D32:D37)=2,AND(D33<>\"\",D36<>\"\")),AVERAGE(D33,D36),IF(AND(COUNTA(D32:D37)=3,AND(D33<>\"\",D35<>\"\",D36<>\"\")),0.25*(D33+D35*2+D36),IF(AND(COUNTA(D32:D37)=5,AND(D32<>\"\",D33<>\"\",D35<>\"\",D36<>\"\",D37<>\"\")),0.1*(D32+3*D33+3*D35+2*D36+D37),IF(AND(COUNTA(D32:D37)=6,AND(D32<>\"\",D33<>\"\",D34<>\"\",D35<>\"\",D36<>\"\",D37<>\"\")),0.1*(D32+2*D33+2*D34+2*D35+2*D36+D37),\"\")))))))","v":""},"","","",{"$f":"IF(H17=\"Rive Gauche\",(2*$E$11-1)*I39,IF(H17=\"Rive Droite\",(2*$E$11-1)*G39,IF(COUNTA(H32:H37)=1,H35,IF(AND(COUNTA(H32:H37)=2,AND(H33<>\"\",H36<>\"\")),AVERAGE(H33,H36),IF(AND(COUNTA(H32:H37)=3,AND(H33<>\"\",H35<>\"\",H36<>\"\")),0.25*(H33+H35*2+H36),IF(AND(COUNTA(H32:H37)=5,AND(H32<>\"\",H33<>\"\",H35<>\"\",H36<>\"\",H37<>\"\")),0.1*(H32+3*H33+3*H35+2*H36+H37),IF(AND(COUNTA(H32:H37)=6,AND(H32<>\"\",H33<>\"\",H34<>\"\",H35<>\"\",H36<>\"\",H37<>\"\")),0.1*(H32+2*H33+2*H34+2*H35+2*H36+H37),\"\")))))))","v":""},{"$error":"#VALUE!"},"","","","","",null,{"$f":"MAX(C32:M37)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Nombre de points\nde mesure"]
[null,"Débits unitaires par verticale - Méthode de la section moyenne (en m3/s) :"]
[null,null,{"$f":"IF(C21<>\"\",C21*AVERAGE(B23:C23)*AVERAGE(B39:C39),\"\")","v":""},{"$f":"IF(D21<>\"\",D21*AVERAGE(C23:D23)*AVERAGE(C39:D39),\"\")","v":""},"","","","","","","","","",{"$f":"IF(N21<>\"\",N21*AVERAGE(M23:N23)*AVERAGE(M39:N39),\"\")","v":""}]
[null,{"$f":"IF(B41=\"\",\"\",B41/$H$44)","v":""},{"$f":"IF(C41=\"\",\"\",C41/$H$44)","v":""},"","","","","","","","","","",""]
[null,{"$f":"COUNTIF(A42:M42,\">0,1\")/COUNTA(A42:M42)","v":0},"des débits unitaires dépassent 10% du débit total",null,null,null,null,{"$f":"COUNTIF(Q33:AB37,\">0,2xP39\")/COUNTA(Q33:AB37)","v":0},"de mesures adjacentes dépassent 20% de la vitesse max"]
[null,"Débits sur la totalité de la section de mesure :",null,null,null,null,null,{"$f":"SUM(B41:N41)","v":0},null,{"$f":"H44*60*60","v":0},null,{"$f":"J44*24","v":0}]
[null,"Surface mouillée totale :",null,null,null,{"$f":"IF(C21=\"\",0,C21*AVERAGE(B23:C23))+IF(D21=\"\",0,D21*AVERAGE(C23:D23))+IF(E21=\"\",0,E21*AVERAGE(D23:E23))+IF(F21=\"\",0,F21*AVERAGE(E23:F23))+IF(G21=\"\",0,G21*AVERAGE(F23:G23))+IF(H21=\"\",0,H21*AVERAGE(G23:H23))+IF(I21=\"\",0,I21*AVERAGE(H23:I23))+IF(J21=\"\",0,J21*AVERAGE(I23:J23))+IF(K21=\"\",0,K21*AVERAGE(J23:K23))+IF(L21=\"\",0,L21*AVERAGE(K23:L23))+IF(M21=\"\",0,M21*AVERAGE(L23:M23))+IF(N21=\"\",0,N21*AVERAGE(M23:N23))","v":0},null,"Vitesse moyenne jaugée :",null,null,null,{"$f":"H44/F45","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Formules de calcul des vitesses moyennes selon le nombre de points de mesure par verticale :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Méthode à 1 point : Vitesse moyenne = V0,4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Méthode à 2 points : Vitesse moyenne = 0,5 x (V0,2 + V0,8)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Méthode à 3 points : Vitesse moyenne = 0,25 x (V0,2 + 2V0,6 + V0,8)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Méthode à 5 points : Vitesse moyenne = 0,1 x (Vsurface + 3V0,2 + 3V0,6 + 2V0,8 + Vfond)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Méthode à 6 points : Vitesse moyenne = 0,1 x (Vsurface + 2V0,2 + 2V0,4 + 2V0,6 + 2V0,8 + Vfond)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coefficients de rive :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kr = 1 : Berges lisses de forme rectangulaire è Débit maximal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kr = 0,8 : Valeur par défaut à utiliser pour les canaux rectangulaires"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kr = 0,5 : Berges de forme triangulaire è Débit nul"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nombre de verticales :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Le débit unitaire de chaque verticale doit être inférieur à  5% du débit total, et en aucun cas il ne doit dépasser 10% du débit total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"La distance entre 2 verticales doit être supérieure à la largeur du capteur"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Les première et dernière verticales doivent être aussi proche que possible de la bordure de l'eau"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nombre de points par verticale :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"La différence des mesures de vitesse entre 2 points adjacents ne doit pas dépasser 20% de la vitesse la plus élevée"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Les incertitudes de mesure en fonction du nombre de point sont les suivantes : 5 points 2,5%, 2 points 3,5%, 1 point 7,5%"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Méthode de mesure par point:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Le chenal de mesure doit être rectiligne, de section et de pente uniforme, présenter des longueurs droites en amont ≥ 6 fois la largeur du chanal et en aval ≥ 3 fois la largeur du chenal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Les directions d'écoulement doivent être parrallèles les unes aux autres et perpendiculaires à la section de mesurage"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Le dispositif utilisé pour réaliser le mesurage de la vitesse doit être positionné dans l'axe du flux"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Le dispositif utilisé pour réaliser le mesurage de la vitesse doit être maintenu en position pendant au moins 30 secondes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Le niveau d'eau doit être lu au début et à la fin de la période de mesurage"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Deux cycles complets de mesurage doivent être réalisés, si les résultats diffèrent de plus de 10% l'opération doit être répétée"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Les courantomètres électromagnétiques ne doivent pas être utilisés lorsque la hauteur d'eau est inférieure à 3 fois l'épaisseur du capteur"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Les courantomètres rotatifs ne doivent pas être utilisés lorsque la hauteur d'eau est inférieure à 4 fois le diamètre de l'hélice utilisée"]

{"sheet":"5 Points","index":3,"n_rows":76,"n_cols":33,"rows_kept":76,"cut":false,"hidden":false,"merged":[[39,1,39,13],[37,15,37,27],[44,1,44,4],[44,5,44,6],[44,7,44,10],[44,11,44,12],[37,1,37,13],[42,2,42,6],[42,8,42,13],[43,1,43,6],[43,7,43,8],[43,9,43,10],[43,11,43,12],[30,15,30,27],[23,1,23,13],[23,15,23,27],[30,1,30,13],[21,24,22,24],[21,25,22,25],[21,26,22,26],[19,1,19,13],[19,15,19,27],[21,0,22,0],[21,1,21,13],[21,15,22,15],[21,16,22,16],[21,17,22,17],[21,18,22,18],[21,19,22,19],[21,20,22,20],[21,27,22,27],[21,21,22,21],[21,22,22,22],[21,23,22,23],[12,4,12,5],[12,7,12,9],[12,10,12,13],[17,1,17,13],[17,15,17,27],[14,18,14,19],[14,20,14,24],[11,4,11,5],[11,7,11,9],[11,10,11,13],[8,4,8,5],[8,7,8,9],[8,10,8,13],[9,4,9,5],[9,7,9,9],[9,10,9,13],[10,4,10,5],[10,7,10,9],[10,10,10,13],[0,1,0,13],[3,4,3,5],[4,4,4,5],[5,4,5,5],[6,4,6,5],[6,9,6,10],[6,12,6,13],[1,1,1,13],[8,15,8,28],[9,15,9,20],[9,21,9,25],[9,26,9,28],[12,15,12,20],[12,21,12,25],[12,26,12,28],[30,28,30,33],[31,30,31,31],[31,32,31,33],[32,30,32,31],[32,32,32,33],[33,30,33,31],[33,32,33,33],[34,28,34,29],[34,30,34,31],[34,32,34,33],[35,28,35,29],[35,30,35,31],[35,32,35,33],[36,28,36,29],[36,30,36,31],[36,32,36,33],[37,28,37,29],[37,30,39,31],[37,32,39,33],[38,15,39,27],[38,28,39,29]]}
[null,"JAUGEAGE PAR EXPLORATION DU CHAMP DES VITESSES"]
[null,"METHODE POINTS ET FORMULES NORMALISEES"]
[]
[null,null,null,"Date :",null,null,null,"Maître d'ouvrage :"]
[null,null,null,"Heure de début :",null,null,null,"Nom de la prise :"]
[null,null,null,"Heure de fin :",null,null,null,"Localisation :"]
[null,null,null,"Durée de mesurage :",{"$f":"E6-E5","v":"00:00:00"},null,null,"GPS :","X :",null,null,"Y :"]
[]
[null,null,null,"Equipement en place :",null,null,null,"Equipement utilisé :",null,null,null,null,null,null,null,"Nombre de verticales recommandées par la norme NF EN ISO 748 selon la largeur du chenal"]
[null,null,null,"Forme du chenal :",null,null,null,"Type :",null,null,null,null,null,null,null,"Version de Janvier 2002",null,null,null,null,null,"Version de Avril 2009",null,null,null,null,"Version de Décembre 2021"]
[null,null,null,"Coefficient de rive :",0.8,null,null,"Référence de l'appareil :",null,null,null,null,null,null,null,"< 0,5",">0,5 et <1",">1 et <3",">3 et <5",">5 et <10","> 10","< 0,5",">0,5 et <1",">1 et <3",">3 et <5","> 5","< 0,5",">0,5 et <5","> 5"]
[null,null,null,"Largeur du chenal :",0.6,null,null,"Référence de l'hélice :",null,null,null,null,null,null,null,"3 ou 4","4 ou 5","5 à 8","8 à 10","10 à 20",">20","5 ou 6","6 ou 7","7 à 12","13 à 16","> 22","≥ 15","≥ 20","≥ 22"]
[null,null,null,"Profondeur moyenne :",0.45,null,null,"Opérateur(s) :",null,null,null,null,null,null,null,{"$f":"IF($E$12<0.5,\"3 ou 4\",IF($E$12<1,\"4 ou 5\",IF($E$12<3,\"5 à 8\",IF($E$12<5,\"8 à 10\",IF($E$12<10,\"10 à 20\",\"> 20\")))))","v":"4 ou 5"},null,null,null,null,null,{"$f":"IF($E$12<0.5,\"5 ou 6\",IF($E$12<1,\"6 ou 7\",IF($E$12<3,\"7 à 12\",IF($E$12<5,\"13 à 16\",\"> 22\"))))","v":"6 ou 7"},null,null,null,null,{"$f":"IF($E$12<0.5,\"≥ 15\",IF($E$12<5,\"≥ 20\",\"≥ 22\"))","v":"≥ 20"}]
[]
[null,null,null,null,"Nombre de verticales retenues : ",5,null,null,null,null,null,null,"Nombre de points retenus par verticale : ",5,null,null,null,"Distance entre verticales : ",{"$f":"IF(F15=1,E12/2,($E$12-0.1)/($F$15-1))","v":0.125},null,"Nombre de points conseillés par verticale : ",null,null,null,null,{"$f":"IF(MAX(B23:N23)>0.2,3,2)","v":2}]
[]
[null,"Rive Gauche",{"$f":"IF($F$15>=1,\"Vert. 01\",IF($F$15=0,\"Rive Droite\",\"\"))","v":"Vert. 01"},{"$f":"IF($F$15>=2,\"Vert. 02\",IF($F$15=1,\"Rive Droite\",\"\"))","v":"Vert. 02"},{"$f":"IF($F$15>=3,\"Vert. 03\",IF($F$15=2,\"Rive Droite\",\"\"))","v":"Vert. 03"},{"$f":"IF($F$15>=4,\"Vert. 04\",IF($F$15=3,\"Rive Droite\",\"\"))","v":"Vert. 04"},{"$f":"IF($F$15>=5,\"Vert. 05\",IF($F$15=4,\"Rive Droite\",\"\"))","v":"Vert. 05"},{"$f":"IF($F$15>=6,\"Vert. 06\",IF($F$15=5,\"Rive Droite\",\"\"))","v":"Rive Droite"},{"$f":"IF($F$15>=7,\"Vert. 07\",IF($F$15=6,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=8,\"Vert. 08\",IF($F$15=7,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=9,\"Vert. 09\",IF($F$15=8,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=10,\"Vert. 10\",IF($F$15=9,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=11,\"Vert. 11\",IF($F$15=10,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=12,\"Vert. 12\",IF($F$15=11,\"Rive Droite\",\"\"))","v":""},null,"Rive Gauche",{"$f":"IF($F$15>=1,\"Vert. 01\",IF($F$15=0,\"Rive Droite\",\"\"))","v":"Vert. 01"},{"$f":"IF($F$15>=2,\"Vert. 02\",IF($F$15=1,\"Rive Droite\",\"\"))","v":"Vert. 02"},{"$f":"IF($F$15>=3,\"Vert. 03\",IF($F$15=2,\"Rive Droite\",\"\"))","v":"Vert. 03"},{"$f":"IF($F$15>=4,\"Vert. 04\",IF($F$15=3,\"Rive Droite\",\"\"))","v":"Vert. 04"},{"$f":"IF($F$15>=5,\"Vert. 05\",IF($F$15=4,\"Rive Droite\",\"\"))","v":"Vert. 05"},{"$f":"IF($F$15>=6,\"Vert. 06\",IF($F$15=5,\"Rive Droite\",\"\"))","v":"Rive Droite"},{"$f":"IF($F$15>=7,\"Vert. 07\",IF($F$15=6,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=8,\"Vert. 08\",IF($F$15=7,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=9,\"Vert. 09\",IF($F$15=8,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=10,\"Vert. 10\",IF($F$15=9,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=11,\"Vert. 11\",IF($F$15=10,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=12,\"Vert. 12\",IF($F$15=1,\"Rive Droite\",\"\"))","v":""}]
[null,"Distances à la rive retenues pour chaque verticale (en mètre par rapport à la rive gauche) :",null,null,null,null,null,null,null,null,null,null,null,null,null,"Distances à la rive conseillées pour chaque verticale (en mètre par rapport à la rive gauche) :"]
[null,{"$f":"0","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"0","v":0},{"$f":"0.05","v":0.05},{"$f":"IF(Q19=\"\",\"\",IF(R17=\"Rive Droite\",$E$12,IF(Q19+$U$13<$E$12,Q19+$U$13,\"\")))","v":0.05},0.05,0.05,0.05,0.6,"","","","","",""]
[null,"Distances retenues entre verticales (en mètre) :",null,null,null,null,null,null,null,null,null,null,null,null,null,"Distances conseillées entre verticales (en mètre) :"]
[null,0,{"$f":"IF(AND(B$19<>\"\",C$19<>\"\"),C$19-B$19,\"\")","v":""},{"$f":"IF(AND(C$19<>\"\",D$19<>\"\"),D$19-C$19,\"\")","v":""},"","","","","","","","","","",null,0,{"$f":"IF(AND(P$19<>\"\",Q$19<>\"\"),Q$19-P$19,\"\")","v":0.05},{"$f":"IF(AND(Q$19<>\"\",R$19<>\"\"),R$19-Q$19,\"\")","v":0},{"$f":"IF(AND(R$19<>\"\",S$19<>\"\"),S$19-R$19,\"\")","v":0},0,0,0.54999999999999993,"","","","","",""]
[null,"Hauteurs d'eau mesurées à chaque verticale (en mètre) :",null,null,null,null,null,null,null,null,null,null,null,null,null,"Rive Gauche",{"$f":"IF($F$15>=1,\"Vert. 01\",IF($F$15=0,\"Rive Droite\",\"\"))","v":"Vert. 01"},{"$f":"IF($F$15>=2,\"Vert. 02\",IF($F$15=1,\"Rive Droite\",\"\"))","v":"Vert. 02"},{"$f":"IF($F$15>=3,\"Vert. 03\",IF($F$15=2,\"Rive Droite\",\"\"))","v":"Vert. 03"},{"$f":"IF($F$15>=4,\"Vert. 04\",IF($F$15=3,\"Rive Droite\",\"\"))","v":"Vert. 04"},{"$f":"IF($F$15>=5,\"Vert. 05\",IF($F$15=4,\"Rive Droite\",\"\"))","v":"Vert. 05"},{"$f":"IF($F$15>=6,\"Vert. 06\",IF($F$15=5,\"Rive Droite\",\"\"))","v":"Rive Droite"},{"$f":"IF($F$15>=7,\"Vert. 07\",IF($F$15=6,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=8,\"Vert. 08\",IF($F$15=7,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=9,\"Vert. 09\",IF($F$15=8,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=10,\"Vert. 10\",IF($F$15=9,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=11,\"Vert. 11\",IF($F$15=10,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=12,\"Vert. 12\",IF($F$15=1,\"Rive Droite\",\"\"))","v":""}]
[]
[null,"Hauteurs retenues pour chaque point de mesure de la vitesse d'écoulement (en mètre par rapport au fond) :",null,null,null,null,null,null,null,null,null,null,null,null,null,"Hauteurs conseillées pour chaque point de mesure de la vitesse d'écoulement (en mètre par rapport au fond) :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q$17=\"\",Q$17=\"Rive Droite\"),\"\",IF($N$15<5,\"\",C$23))","v":0},{"$f":"IF(OR(R$17=\"\",R$17=\"Rive Droite\"),\"\",IF($N$15<5,\"\",D$23))","v":0},0,0,0,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q$17=\"\",Q$17=\"Rive Droite\"),\"\",IF($N$15>1,C$23*0.8,\"\"))","v":0},{"$f":"IF(OR(R$17=\"\",R$17=\"Rive Droite\"),\"\",IF($N$15>1,D$23*0.8,\"\"))","v":0},0,0,0,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q$17=\"\",Q$17=\"Rive Droite\"),\"\",IF($N$15=6,C$23*0.6,\"\"))","v":""},"","","","","","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q$17=\"\",Q$17=\"Rive Droite\"),\"\",IF(OR($N$15>2,$N$15=1),C$23*0.4,\"\"))","v":0},{"$f":"IF(OR(R$17=\"\",R$17=\"Rive Droite\"),\"\",IF(OR($N$15>2,$N$15=1),D$23*0.4,\"\"))","v":0},0,0,0,"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q$17=\"\",Q$17=\"Rive Droite\"),\"\",IF($N$15>1,C$23*0.2,\"\"))","v":0},{"$f":"IF(OR(R$17=\"\",R$17=\"Rive Droite\"),\"\",IF($N$15>1,D$23*0.2,\"\"))","v":0},0,0,{"$f":"IF(OR(U$17=\"\",U$17=\"Rive Droite\"),\"\",IF($N$15>1,G$23*0.2,\"\"))","v":0},"","","","","","",""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q$17=\"\",Q$17=\"Rive Droite\"),\"\",IF($N$15>=5,0,\"\"))","v":0},0,0,0,0,"","","","","","",""]
[null,"Vitesses d'écoulement mesurées à chaque point de mesure (en m/s) :",null,null,null,null,null,null,null,null,null,null,null,null,null,"Ecarts de mesure entre 2 points adjacents :",null,null,null,null,null,null,null,null,null,null,null,null,"Positionnement des points de mesure"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(W$17=\"\",W$17=\"Rive Droite\"),\"\",IF($N$15<5,\"\",I$23))","v":""},"","","","","",null,null,"Fil d'eau",null,{"$f":"IF(SUM($B25:$N25)=0,\"-\",1-AVERAGE($B25:$N25)/$E$13)","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q$17=\"\",Q$17=\"Rive Droite\"),\"\",C33-C32)","v":0},{"$f":"IF(OR(R$17=\"\",R$17=\"Rive Droite\"),\"\",D33-D32)","v":0},0,0,0,"","","","","","","",null,null,0.8,null,{"$f":"IF(SUM($B26:$N26)=0,\"-\",AVERAGE($B26:$N26)/$E$13)","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q$17=\"\",Q$17=\"Rive Droite\"),\"\",C34-C33)","v":0},0,0,0,0,"","","","","","","",null,null,0.6,null,{"$f":"IF(SUM($B27:$N27)=0,\"-\",AVERAGE($B27:$N27)/$E$13)","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,"","","","","","","",null,null,0.4,null,{"$f":"IF(SUM($B28:$N28)=0,\"-\",AVERAGE($B28:$N28)/$E$13)","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,"","","","","","","",null,null,0.2,null,{"$f":"IF(SUM($B29:$N29)=0,\"-\",AVERAGE($B29:$N29)/$E$13)","v":"-"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,"","","","","","","",null,null,"Radier",null,{"$f":"IF(SUM($B30:$N30)=0,\"-\",AVERAGE($B30:$N30)/$E$13)","v":"-"}]
[null,"Vitesses moyennes calculées pour chaque verticale selon le nombre de points de mesure (en m/s) :",null,null,null,null,null,null,null,null,null,null,null,null,null,"Vitesse maximum :",null,null,null,null,null,null,null,null,null,null,null,null," 1    2     3     5     6",null,"Hauteurs d'eau conseillées pour la mesure des vitesses",null,"Hauteurs d'eau retenues pour la mesure des vitesses"]
[null,{"$f":"IF(B17=\"Rive Gauche\",(2*$E$11-1)*C39,IF(B17=\"Rive Droite\",(2*$E$11-1)*A39,IF(COUNTA(B32:B37)=1,B35,IF(AND(COUNTA(B32:B37)=2,AND(B33<>\"\",B36<>\"\")),AVERAGE(B33,B36),IF(AND(COUNTA(B32:B37)=3,AND(B33<>\"\",B35<>\"\",B36<>\"\")),0.25*(B33+B35*2+B36),IF(AND(COUNTA(B32:B37)=5,AND(B32<>\"\",B33<>\"\",B35<>\"\",B36<>\"\",B37<>\"\")),0.1*(B32+3*B33+3*B35+2*B36+B37),IF(AND(COUNTA(B32:B37)=6,AND(B32<>\"\",B33<>\"\",B34<>\"\",B35<>\"\",B36<>\"\",B37<>\"\")),0.1*(B32+2*B33+2*B34+2*B35+2*B36+B37),\"\")))))))","v":{"$error":"#VALUE!"}},{"$f":"IF(C17=\"Rive Gauche\",(2*$E$11-1)*D39,IF(C17=\"Rive Droite\",(2*$E$11-1)*B39,IF(COUNTA(C32:C37)=1,C35,IF(AND(COUNTA(C32:C37)=2,AND(C33<>\"\",C36<>\"\")),AVERAGE(C33,C36),IF(AND(COUNTA(C32:C37)=3,AND(C33<>\"\",C35<>\"\",C36<>\"\")),0.25*(C33+C35*2+C36),IF(AND(COUNTA(C32:C37)=5,AND(C32<>\"\",C33<>\"\",C35<>\"\",C36<>\"\",C37<>\"\")),0.1*(C32+3*C33+3*C35+2*C36+C37),IF(AND(COUNTA(C32:C37)=6,AND(C32<>\"\",C33<>\"\",C34<>\"\",C35<>\"\",C36<>\"\",C37<>\"\")),0.1*(C32+2*C33+2*C34+2*C35+2*C36+C37),\"\")))))))","v":""},{"$f":"IF(D17=\"Rive Gauche\",(2*$E$11-1)*E39,IF(D17=\"Rive Droite\",(2*$E$11-1)*C39,IF(COUNTA(D32:D37)=1,D35,IF(AND(COUNTA(D32:D37)=2,AND(D33<>\"\",D36<>\"\")),AVERAGE(D33,D36),IF(AND(COUNTA(D32:D37)=3,AND(D33<>\"\",D35<>\"\",D36<>\"\")),0.25*(D33+D35*2+D36),IF(AND(COUNTA(D32:D37)=5,AND(D32<>\"\",D33<>\"\",D35<>\"\",D36<>\"\",D37<>\"\")),0.1*(D32+3*D33+3*D35+2*D36+D37),IF(AND(COUNTA(D32:D37)=6,AND(D32<>\"\",D33<>\"\",D34<>\"\",D35<>\"\",D36<>\"\",D37<>\"\")),0.1*(D32+2*D33+2*D34+2*D35+2*D36+D37),\"\")))))))","v":""},"","","",{"$f":"IF(H17=\"Rive Gauche\",(2*$E$11-1)*I39,IF(H17=\"Rive Droite\",(2*$E$11-1)*G39,IF(COUNTA(H32:H37)=1,H35,IF(AND(COUNTA(H32:H37)=2,AND(H33<>\"\",H36<>\"\")),AVERAGE(H33,H36),IF(AND(COUNTA(H32:H37)=3,AND(H33<>\"\",H35<>\"\",H36<>\"\")),0.25*(H33+H35*2+H36),IF(AND(COUNTA(H32:H37)=5,AND(H32<>\"\",H33<>\"\",H35<>\"\",H36<>\"\",H37<>\"\")),0.1*(H32+3*H33+3*H35+2*H36+H37),IF(AND(COUNTA(H32:H37)=6,AND(H32<>\"\",H33<>\"\",H34<>\"\",H35<>\"\",H36<>\"\",H37<>\"\")),0.1*(H32+2*H33+2*H34+2*H35+2*H36+H37),\"\")))))))","v":{"$error":"#VALUE!"}},"","","","","","",null,{"$f":"MAX(C32:M37)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Nombre de points\nde mesure"]
[null,"Débits unitaires par verticale - Méthode de la section moyenne (en m3/s) :"]
[null,null,{"$f":"IF(C21<>\"\",C21*AVERAGE(B23:C23)*AVERAGE(B39:C39),\"\")","v":""},{"$f":"IF(D21<>\"\",D21*AVERAGE(C23:D23)*AVERAGE(C39:D39),\"\")","v":""},"","","","","","","","","",{"$f":"IF(N21<>\"\",N21*AVERAGE(M23:N23)*AVERAGE(M39:N39),\"\")","v":""}]
[null,{"$f":"IF(B41=\"\",\"\",B41/$H$44)","v":""},{"$f":"IF(C41=\"\",\"\",C41/$H$44)","v":""},"","","","","","","","","","",""]
[null,{"$f":"COUNTIF(A42:M42,\">0,1\")/COUNTA(A42:M42)","v":0},"des débits unitaires dépassent 10% du débit total",null,null,null,null,{"$f":"COUNTIF(Q33:AB37,\">0,2xP39\")/COUNTA(Q33:AB37)","v":0},"de mesures adjacentes dépassent 20% de la vitesse max"]
[null,"Débits sur la totalité de la section de mesure :",null,null,null,null,null,{"$f":"SUM(C41:N41)","v":0},null,{"$f":"H44*60*60","v":0},null,{"$f":"J44*24","v":0}]
[null,"Surface mouillée totale :",null,null,null,{"$f":"IF(C21=\"\",0,C21*AVERAGE(B23:C23))+IF(D21=\"\",0,D21*AVERAGE(C23:D23))+IF(E21=\"\",0,E21*AVERAGE(D23:E23))+IF(F21=\"\",0,F21*AVERAGE(E23:F23))+IF(G21=\"\",0,G21*AVERAGE(F23:G23))+IF(H21=\"\",0,H21*AVERAGE(G23:H23))+IF(I21=\"\",0,I21*AVERAGE(H23:I23))+IF(J21=\"\",0,J21*AVERAGE(I23:J23))+IF(K21=\"\",0,K21*AVERAGE(J23:K23))+IF(L21=\"\",0,L21*AVERAGE(K23:L23))+IF(M21=\"\",0,M21*AVERAGE(L23:M23))+IF(N21=\"\",0,N21*AVERAGE(M23:N23))","v":0},null,"Vitesse moyenne jaugée :",null,null,null,{"$f":"H44/F45","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Formules de calcul des vitesses moyennes selon le nombre de points de mesure par verticale :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Méthode à 1 point : Vitesse moyenne = V0,4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Méthode à 2 points : Vitesse moyenne = 0,5 x (V0,2 + V0,8)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Méthode à 3 points : Vitesse moyenne = 0,25 x (V0,2 + 2V0,6 + V0,8)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Méthode à 5 points : Vitesse moyenne = 0,1 x (Vsurface + 3V0,2 + 3V0,6 + 2V0,8 + Vfond)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Méthode à 6 points : Vitesse moyenne = 0,1 x (Vsurface + 2V0,2 + 2V0,4 + 2V0,6 + 2V0,8 + Vfond)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coefficients de rive :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kr = 1 : Berges lisses de forme rectangulaire è Débit maximal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kr = 0,8 : Valeur par défaut à utiliser pour les canaux rectangulaires"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kr = 0,5 : Berges de forme triangulaire è Débit nul"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nombre de verticales :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Le débit unitaire de chaque verticale doit être inférieur à  5% du débit total, et en aucun cas il ne doit dépasser 10% du débit total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"La distance entre 2 verticales doit être supérieure à la largeur du capteur"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Les première et dernière verticales doivent être aussi proche que possible de la bordure de l'eau"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nombre de points par verticale :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"La différence des mesures de vitesse entre 2 points adjacents ne doit pas dépasser 20% de la vitesse la plus élevée"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Les incertitudes de mesure en fonction du nombre de point sont les suivantes : 5 points 2,5%, 2 points 3,5%, 1 point 7,5%"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Méthode de mesure par point:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Le chenal de mesure doit être rectiligne, de section et de pente uniforme, présenter des longueurs droites en amont ≥ 6 fois la largeur du chanal et en aval ≥ 3 fois la largeur du chenal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Les directions d'écoulement doivent être parrallèles les unes aux autres et perpendiculaires à la section de mesurage"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Le dispositif utilisé pour réaliser le mesurage de la vitesse doit être positionné dans l'axe du flux"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Le dispositif utilisé pour réaliser le mesurage de la vitesse doit être maintenu en position pendant au moins 30 secondes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Le niveau d'eau doit être lu au début et à la fin de la période de mesurage"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Deux cycles complets de mesurage doivent être réalisés, si les résultats diffèrent de plus de 10% l'opération doit être répétée"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Les courantomètres électromagnétiques ne doivent pas être utilisés lorsque la hauteur d'eau est inférieure à 3 fois l'épaisseur du capteur"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Les courantomètres rotatifs ne doivent pas être utilisés lorsque la hauteur d'eau est inférieure à 4 fois le diamètre de l'hélice utilisée"]

{"sheet":"6 Points","index":4,"n_rows":76,"n_cols":33,"rows_kept":76,"cut":false,"hidden":false,"merged":[[30,1,30,13],[30,28,30,33],[33,30,33,31],[33,32,33,33],[34,28,34,29],[34,32,34,33],[34,30,34,31],[23,1,23,13],[12,10,12,13],[21,1,21,13],[19,1,19,13],[12,4,12,5],[0,1,0,13],[5,4,5,5],[6,4,6,5],[6,9,6,10],[6,12,6,13],[3,4,3,5],[4,4,4,5],[1,1,1,13],[11,10,11,13],[14,18,14,19],[8,10,8,13],[17,1,17,13],[9,10,9,13],[10,10,10,13],[10,4,10,5],[11,7,11,9],[8,4,8,5],[9,4,9,5],[11,4,11,5],[10,7,10,9],[8,7,8,9],[9,7,9,9],[12,7,12,9],[21,0,22,0],[21,25,22,25],[21,26,22,26],[21,27,22,27],[17,15,17,27],[21,20,22,20],[21,21,22,21],[21,22,22,22],[21,23,22,23],[21,24,22,24],[19,15,19,27],[43,11,43,12],[44,5,44,6],[44,11,44,12],[23,15,23,27],[21,15,22,15],[21,16,22,16],[21,17,22,17],[21,18,22,18],[21,19,22,19],[43,1,43,6],[44,1,44,4],[44,7,44,10],[43,7,43,8],[43,9,43,10],[37,1,37,13],[39,1,39,13],[8,15,8,28],[9,15,9,20],[9,21,9,25],[9,26,9,28],[12,15,12,20],[12,21,12,25],[12,26,12,28],[37,30,39,31],[37,32,39,33],[37,15,37,27],[14,20,14,24],[30,15,30,27],[31,30,31,31],[31,32,31,33],[32,30,32,31],[32,32,32,33],[35,28,35,29],[36,28,36,29],[35,32,35,33],[36,32,36,33],[35,30,35,31],[36,30,36,31],[42,2,42,6],[42,8,42,13],[38,15,39,27],[37,28,37,29],[38,28,39,29]]}
[null,"JAUGEAGE PAR EXPLORATION DU CHAMP DES VITESSES"]
[null,"METHODE POINTS ET FORMULES NORMALISEES"]
[]
[null,null,null,"Date :","2024-07-25",null,null,"Maître d'ouvrage :","ASA d'irrigation de la plaine de Silon"]
[null,null,null,"Heure de début :","10:00:00",null,null,"Nom de la prise :","Prise d'eau dans la Cance"]
[null,null,null,"Heure de fin :","11:00:00",null,null,"Localisation :","Sarras (07)"]
[null,null,null,"Durée de mesurage :",{"$f":"E6-E5","v":"01:00:00"},null,null,"GPS :","X :",45.204799999999999,null,"Y :",4.7945200000000003]
[]
[null,null,null,"Equipement en place :","Aucun",null,null,"Equipement utilisé :",null,null,"Vélocimètre",null,null,null,null,"Nombre de verticales recommandées par la norme NF EN ISO 748 selon la largeur du chenal"]
[null,null,null,"Forme du chenal :",null,null,null,"Type :",null,null,null,null,null,null,null,"Version de Janvier 2002",null,null,null,null,null,"Version de Avril 2009",null,null,null,null,"Version de Décembre 2021"]
[null,null,null,"Coefficient de rive :",0.8,null,null,"Référence de l'appareil :",null,null,null,null,null,null,null,"< 0,5",">0,5 et <1",">1 et <3",">3 et <5",">5 et <10","> 10","< 0,5",">0,5 et <1",">1 et <3",">3 et <5","> 5","< 0,5",">0,5 et <5","> 5"]
[null,null,null,"Largeur du chenal :",2.0499999999999998,null,null,"Référence de l'hélice :",null,null,"APAVE",null,null,null,null,"3 ou 4","4 ou 5","5 à 8","8 à 10","10 à 20",">20","5 ou 6","6 ou 7","7 à 12","13 à 16","> 22","≥ 15","≥ 20","≥ 22"]
[null,null,null,"Profondeur moyenne :",0.2,null,null,"Opérateur(s) :",null,null,"BRICNET Yann",null,null,null,null,{"$f":"IF($E$12<0.5,\"3 ou 4\",IF($E$12<1,\"4 ou 5\",IF($E$12<3,\"5 à 8\",IF($E$12<5,\"8 à 10\",IF($E$12<10,\"10 à 20\",\"> 20\")))))","v":"5 à 8"},null,null,null,null,null,{"$f":"IF($E$12<0.5,\"5 ou 6\",IF($E$12<1,\"6 ou 7\",IF($E$12<3,\"7 à 12\",IF($E$12<5,\"13 à 16\",\"> 22\"))))","v":"7 à 12"},null,null,null,null,{"$f":"IF($E$12<0.5,\"≥ 15\",IF($E$12<5,\"≥ 20\",\"≥ 22\"))","v":"≥ 20"}]
[]
[null,null,null,null,"Nombre de verticales retenues : ",6,null,null,null,null,null,null,"Nombre de points retenus par verticale : ",6,null,null,null,"Distance entre verticales : ",{"$f":"IF(F15=1,E12/2,($E$12-0.1)/($F$15-1))","v":0.38999999999999996},null,"Nombre de points conseillés par verticale : ",null,null,null,null,{"$f":"IF(MAX(B23:N23)>0.2,3,2)","v":3}]
[]
[null,"Rive Gauche",{"$f":"IF($F$15>=1,\"Vert. 01\",IF($F$15=0,\"Rive Droite\",\"\"))","v":"Vert. 01"},{"$f":"IF($F$15>=2,\"Vert. 02\",IF($F$15=1,\"Rive Droite\",\"\"))","v":"Vert. 02"},{"$f":"IF($F$15>=3,\"Vert. 03\",IF($F$15=2,\"Rive Droite\",\"\"))","v":"Vert. 03"},{"$f":"IF($F$15>=4,\"Vert. 04\",IF($F$15=3,\"Rive Droite\",\"\"))","v":"Vert. 04"},{"$f":"IF($F$15>=5,\"Vert. 05\",IF($F$15=4,\"Rive Droite\",\"\"))","v":"Vert. 05"},{"$f":"IF($F$15>=6,\"Vert. 06\",IF($F$15=5,\"Rive Droite\",\"\"))","v":"Vert. 06"},{"$f":"IF($F$15>=7,\"Vert. 07\",IF($F$15=6,\"Rive Droite\",\"\"))","v":"Rive Droite"},{"$f":"IF($F$15>=8,\"Vert. 08\",IF($F$15=7,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=9,\"Vert. 09\",IF($F$15=8,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=10,\"Vert. 10\",IF($F$15=9,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=11,\"Vert. 11\",IF($F$15=10,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=12,\"Vert. 12\",IF($F$15=11,\"Rive Droite\",\"\"))","v":""},null,"Rive Gauche",{"$f":"IF($F$15>=1,\"Vert. 01\",IF($F$15=0,\"Rive Droite\",\"\"))","v":"Vert. 01"},{"$f":"IF($F$15>=2,\"Vert. 02\",IF($F$15=1,\"Rive Droite\",\"\"))","v":"Vert. 02"},{"$f":"IF($F$15>=3,\"Vert. 03\",IF($F$15=2,\"Rive Droite\",\"\"))","v":"Vert. 03"},{"$f":"IF($F$15>=4,\"Vert. 04\",IF($F$15=3,\"Rive Droite\",\"\"))","v":"Vert. 04"},{"$f":"IF($F$15>=5,\"Vert. 05\",IF($F$15=4,\"Rive Droite\",\"\"))","v":"Vert. 05"},{"$f":"IF($F$15>=6,\"Vert. 06\",IF($F$15=5,\"Rive Droite\",\"\"))","v":"Vert. 06"},{"$f":"IF($F$15>=7,\"Vert. 07\",IF($F$15=6,\"Rive Droite\",\"\"))","v":"Rive Droite"},{"$f":"IF($F$15>=8,\"Vert. 08\",IF($F$15=7,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=9,\"Vert. 09\",IF($F$15=8,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=10,\"Vert. 10\",IF($F$15=9,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=11,\"Vert. 11\",IF($F$15=10,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=12,\"Vert. 12\",IF($F$15=1,\"Rive Droite\",\"\"))","v":""}]
[null,"Distances à la rive retenues pour chaque verticale (en mètre par rapport à la rive gauche) :",null,null,null,null,null,null,null,null,null,null,null,null,null,"Distances à la rive conseillées pour chaque verticale (en mètre par rapport à la rive gauche) :"]
[null,{"$f":"0","v":0},0.05,0.44,0.83,1.22,1.61,2,2.0499999999999998,null,null,null,null,null,null,{"$f":"0","v":0},{"$f":"0.05","v":0.05},{"$f":"IF(Q19=\"\",\"\",IF(R17=\"Rive Droite\",$E$12,IF(Q19+$U$13<$E$12,Q19+$U$13,\"\")))","v":0.05},0.05,0.05,0.05,0.05,2.0499999999999998,"","","","",""]
[null,"Distances retenues entre verticales (en mètre) :",null,null,null,null,null,null,null,null,null,null,null,null,null,"Distances conseillées entre verticales (en mètre) :"]
[null,0,{"$f":"IF(AND(B$19<>\"\",C$19<>\"\"),C$19-B$19,\"\")","v":0.05},{"$f":"IF(AND(C$19<>\"\",D$19<>\"\"),D$19-C$19,\"\")","v":0.39},0.38999999999999996,0.39,0.39000000000000012,0.3899999999999999,4.9999999999999822E-2,"","","","","",null,0,{"$f":"IF(AND(P$19<>\"\",Q$19<>\"\"),Q$19-P$19,\"\")","v":0.05},{"$f":"IF(AND(Q$19<>\"\",R$19<>\"\"),R$19-Q$19,\"\")","v":0},{"$f":"IF(AND(R$19<>\"\",S$19<>\"\"),S$19-R$19,\"\")","v":0},{"$f":"IF(AND(S$19<>\"\",T$19<>\"\"),T$19-S$19,\"\")","v":0},{"$f":"IF(AND(T$19<>\"\",U$19<>\"\"),U$19-T$19,\"\")","v":0},{"$f":"IF(AND(U$19<>\"\",V$19<>\"\"),V$19-U$19,\"\")","v":0},{"$f":"IF(AND(V$19<>\"\",W$19<>\"\"),W$19-V$19,\"\")","v":1.9999999999999998},{"$f":"IF(AND(W$19<>\"\",X$19<>\"\"),X$19-W$19,\"\")","v":""},{"$f":"IF(AND(X$19<>\"\",Y$19<>\"\"),Y$19-X$19,\"\")","v":""},{"$f":"IF(AND(Y$19<>\"\",Z$19<>\"\"),Z$19-Y$19,\"\")","v":""},{"$f":"IF(AND(Z$19<>\"\",AA$19<>\"\"),AA$19-Z$19,\"\")","v":""},{"$f":"IF(AND(AA$19<>\"\",AB$19<>\"\"),AB$19-AA$19,\"\")","v":""}]
[null,"Hauteurs d'eau mesurées à chaque verticale (en mètre) :",null,null,null,null,null,null,null,null,null,null,null,null,null,"Rive Gauche",{"$f":"IF($F$15>=1,\"Vert. 01\",IF($F$15=0,\"Rive Droite\",\"\"))","v":"Vert. 01"},{"$f":"IF($F$15>=2,\"Vert. 02\",IF($F$15=1,\"Rive Droite\",\"\"))","v":"Vert. 02"},{"$f":"IF($F$15>=3,\"Vert. 03\",IF($F$15=2,\"Rive Droite\",\"\"))","v":"Vert. 03"},{"$f":"IF($F$15>=4,\"Vert. 04\",IF($F$15=3,\"Rive Droite\",\"\"))","v":"Vert. 04"},{"$f":"IF($F$15>=5,\"Vert. 05\",IF($F$15=4,\"Rive Droite\",\"\"))","v":"Vert. 05"},{"$f":"IF($F$15>=6,\"Vert. 06\",IF($F$15=5,\"Rive Droite\",\"\"))","v":"Vert. 06"},{"$f":"IF($F$15>=7,\"Vert. 07\",IF($F$15=6,\"Rive Droite\",\"\"))","v":"Rive Droite"},{"$f":"IF($F$15>=8,\"Vert. 08\",IF($F$15=7,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=9,\"Vert. 09\",IF($F$15=8,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=10,\"Vert. 10\",IF($F$15=9,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=11,\"Vert. 11\",IF($F$15=10,\"Rive Droite\",\"\"))","v":""},{"$f":"IF($F$15>=12,\"Vert. 12\",IF($F$15=1,\"Rive Droite\",\"\"))","v":""}]
[null,0,0.05,0.17,0.23,0.2,0.20499999999999999,0.14000000000000001,0.12]
[null,"Hauteurs retenues pour chaque point de mesure de la vitesse d'écoulement (en mètre par rapport au fond) :",null,null,null,null,null,null,null,null,null,null,null,null,null,"Hauteurs conseillées pour chaque point de mesure de la vitesse d'écoulement (en mètre par rapport au fond) :"]
[null,null,0.05,0.17,0.23,0.2,0.20499999999999999,0.14000000000000001,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q$17=\"\",Q$17=\"Rive Droite\"),\"\",IF($N$15<5,\"\",C$23))","v":0.05},{"$f":"IF(OR(R$17=\"\",R$17=\"Rive Droite\"),\"\",IF($N$15<5,\"\",D$23))","v":0.17},0.23,0.2,0.20499999999999999,0.14000000000000001,"","","","","",""]
[null,null,0.04,0.13600000000000001,0.184,0.16,0.16400000000000001,0.112,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q$17=\"\",Q$17=\"Rive Droite\"),\"\",IF($N$15>1,C$23*0.8,\"\"))","v":4.0000000000000008E-2},{"$f":"IF(OR(R$17=\"\",R$17=\"Rive Droite\"),\"\",IF($N$15>1,D$23*0.8,\"\"))","v":0.13600000000000001},0.18400000000000002,0.16000000000000003,0.16400000000000001,0.11200000000000002,"","","","","",""]
[null,null,0.03,0.10199999999999999,0.13800000000000001,0.12,0.123,8.4000000000000005E-2,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q$17=\"\",Q$17=\"Rive Droite\"),\"\",IF($N$15=6,C$23*0.6,\"\"))","v":0.03},0.10200000000000001,0.13800000000000001,0.12,0.12299999999999998,8.4000000000000005E-2,"","","","","",""]
[null,null,0.02,6.8000000000000005E-2,9.1999999999999998E-2,0.08,8.2000000000000003E-2,5.6000000000000001E-2,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q$17=\"\",Q$17=\"Rive Droite\"),\"\",IF(OR($N$15>2,$N$15=1),C$23*0.4,\"\"))","v":2.0000000000000004E-2},{"$f":"IF(OR(R$17=\"\",R$17=\"Rive Droite\"),\"\",IF(OR($N$15>2,$N$15=1),D$23*0.4,\"\"))","v":6.8000000000000005E-2},9.2000000000000012E-2,8.0000000000000016E-2,8.2000000000000003E-2,5.6000000000000008E-2,"","","","","",""]
[null,null,0.01,3.4000000000000002E-2,4.5999999999999999E-2,0.04,4.1000000000000002E-2,2.8000000000000001E-2,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q$17=\"\",Q$17=\"Rive Droite\"),\"\",IF($N$15>1,C$23*0.2,\"\"))","v":1.0000000000000002E-2},{"$f":"IF(OR(R$17=\"\",R$17=\"Rive Droite\"),\"\",IF($N$15>1,D$23*0.2,\"\"))","v":3.4000000000000002E-2},4.6000000000000006E-2,4.0000000000000008E-2,{"$f":"IF(OR(U$17=\"\",U$17=\"Rive Droite\"),\"\",IF($N$15>1,G$23*0.2,\"\"))","v":4.1000000000000002E-2},2.8000000000000004E-2,"","","","","",""]
[null,null,0,0,0,0,0,0,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q$17=\"\",Q$17=\"Rive Droite\"),\"\",IF($N$15>=5,0,\"\"))","v":0},0,0,0,0,0,"","","","","",""]
[null,"Vitesses d'écoulement mesurées à chaque point de mesure (en m/s) :",null,null,null,null,null,null,null,null,null,null,null,null,null,"Ecarts de mesure entre 2 points adjacents :",null,null,null,null,null,null,null,null,null,null,null,null,"Positionnement des points de mesure"]
[null,null,0,0.08,0.1,0.19,0.16,0.11,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(W$17=\"\",W$17=\"Rive Droite\"),\"\",IF($N$15<5,\"\",I$23))","v":""},{"$f":"IF(OR(X$17=\"\",X$17=\"Rive Droite\"),\"\",IF($N$15<5,\"\",J$23))","v":""},{"$f":"IF(OR(Y$17=\"\",Y$17=\"Rive Droite\"),\"\",IF($N$15<5,\"\",K$23))","v":""},{"$f":"IF(OR(Z$17=\"\",Z$17=\"Rive Droite\"),\"\",IF($N$15<5,\"\",L$23))","v":""},{"$f":"IF(OR(AA$17=\"\",AA$17=\"Rive Droite\"),\"\",IF($N$15<5,\"\",M$23))","v":""},{"$f":"IF(OR(AB$17=\"\",AB$17=\"Rive Droite\"),\"\",IF($N$15<5,\"\",N$23))","v":""},null,null,"Fil d'eau",null,{"$f":"IF(SUM($B25:$N25)=0,\"-\",1-AVERAGE($B25:$N25)/$E$13)","v":0.17083333333333328}]
[null,null,0,0.13,0.1,0.16,0.13,0.13,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q$17=\"\",Q$17=\"Rive Droite\"),\"\",C33-C32)","v":0},{"$f":"IF(OR(R$17=\"\",R$17=\"Rive Droite\"),\"\",D33-D32)","v":0.05},{"$f":"IF(OR(S$17=\"\",S$17=\"Rive Droite\"),\"\",E33-E32)","v":0},{"$f":"IF(OR(T$17=\"\",T$17=\"Rive Droite\"),\"\",F33-F32)","v":-0.03},{"$f":"IF(OR(U$17=\"\",U$17=\"Rive Droite\"),\"\",G33-G32)","v":-0.03},{"$f":"IF(OR(V$17=\"\",V$17=\"Rive Droite\"),\"\",H33-H32)","v":2.0000000000000004E-2},{"$f":"IF(OR(W$17=\"\",W$17=\"Rive Droite\"),\"\",I33-I32)","v":""},{"$f":"IF(OR(X$17=\"\",X$17=\"Rive Droite\"),\"\",J33-J32)","v":""},{"$f":"IF(OR(Y$17=\"\",Y$17=\"Rive Droite\"),\"\",K33-K32)","v":""},{"$f":"IF(OR(Z$17=\"\",Z$17=\"Rive Droite\"),\"\",L33-L32)","v":""},{"$f":"IF(OR(AA$17=\"\",AA$17=\"Rive Droite\"),\"\",M33-M32)","v":""},{"$f":"IF(OR(AB$17=\"\",AB$17=\"Rive Droite\"),\"\",N33-N32)","v":""},null,null,0.8,null,{"$f":"IF(SUM($B26:$N26)=0,\"-\",AVERAGE($B26:$N26)/$E$13)","v":0.66333333333333333}]
[null,null,0,0.1,0.08,0.13500000000000001,0.13,0.11,null,null,null,null,null,null,null,null,{"$f":"IF(OR(Q$17=\"\",Q$17=\"Rive Droite\"),\"\",C34-C33)","v":0},-0.03,-2.0000000000000004E-2,-2.4999999999999994E-2,0,-2.0000000000000004E-2,"","","","","","",null,null,0.6,null,{"$f":"IF(SUM($B27:$N27)=0,\"-\",AVERAGE($B27:$N27)/$E$13)","v":0.49749999999999994}]
[null,null,0,0.08,0.08,0.13,0.11,0.08,null,null,null,null,null,null,null,null,0,-2.0000000000000004E-2,0,-5.0000000000000044E-3,-2.0000000000000004E-2,-0.03,"","","","","","",null,null,0.4,null,{"$f":"IF(SUM($B28:$N28)=0,\"-\",AVERAGE($B28:$N28)/$E$13)","v":0.33166666666666667}]
[null,null,0,0.05,0.06,0.11,0.08,0.05,null,null,null,null,null,null,null,null,0,-0.03,-2.0000000000000004E-2,-2.0000000000000004E-2,-0.03,-0.03,"","","","","","",null,null,0.2,null,{"$f":"IF(SUM($B29:$N29)=0,\"-\",AVERAGE($B29:$N29)/$E$13)","v":0.16583333333333333}]
[null,null,0,0.02,0.02,0.08,0.08,0.02,null,null,null,null,null,null,null,null,0,-3.0000000000000002E-2,-3.9999999999999994E-2,-0.03,0,-3.0000000000000002E-2,"","","","","","",null,null,"Radier",null,{"$f":"IF(SUM($B30:$N30)=0,\"-\",AVERAGE($B30:$N30)/$E$13)","v":"-"}]
[null,"Vitesses moyennes calculées pour chaque verticale selon le nombre de points de mesure (en m/s) :",null,null,null,null,null,null,null,null,null,null,null,null,null,"Vitesse maximum :",null,null,null,null,null,null,null,null,null,null,null,null," 1    2     3     5     6",null,"Hauteurs d'eau conseillées pour la mesure des vitesses",null,"Hauteurs d'eau retenues pour la mesure des vitesses"]
[null,{"$f":"IF(B17=\"Rive Gauche\",(2*$E$11-1)*C39,IF(B17=\"Rive Droite\",(2*$E$11-1)*A39,IF(COUNTA(B32:B37)=1,B35,IF(AND(COUNTA(B32:B37)=2,AND(B33<>\"\",B36<>\"\")),AVERAGE(B33,B36),IF(AND(COUNTA(B32:B37)=3,AND(B33<>\"\",B35<>\"\",B36<>\"\")),0.25*(B33+B35*2+B36),IF(AND(COUNTA(B32:B37)=5,AND(B32<>\"\",B33<>\"\",B35<>\"\",B36<>\"\",B37<>\"\")),0.1*(B32+3*B33+3*B35+2*B36+B37),IF(AND(COUNTA(B32:B37)=6,AND(B32<>\"\",B33<>\"\",B34<>\"\",B35<>\"\",B36<>\"\",B37<>\"\")),0.1*(B32+2*B33+2*B34+2*B35+2*B36+B37),\"\")))))))","v":0},{"$f":"IF(C17=\"Rive Gauche\",(2*$E$11-1)*D39,IF(C17=\"Rive Droite\",(2*$E$11-1)*B39,IF(COUNTA(C32:C37)=1,C35,IF(AND(COUNTA(C32:C37)=2,AND(C33<>\"\",C36<>\"\")),AVERAGE(C33,C36),IF(AND(COUNTA(C32:C37)=3,AND(C33<>\"\",C35<>\"\",C36<>\"\")),0.25*(C33+C35*2+C36),IF(AND(COUNTA(C32:C37)=5,AND(C32<>\"\",C33<>\"\",C35<>\"\",C36<>\"\",C37<>\"\")),0.1*(C32+3*C33+3*C35+2*C36+C37),IF(AND(COUNTA(C32:C37)=6,AND(C32<>\"\",C33<>\"\",C34<>\"\",C35<>\"\",C36<>\"\",C37<>\"\")),0.1*(C32+2*C33+2*C34+2*C35+2*C36+C37),\"\")))))))","v":0},{"$f":"IF(D17=\"Rive Gauche\",(2*$E$11-1)*E39,IF(D17=\"Rive Droite\",(2*$E$11-1)*C39,IF(COUNTA(D32:D37)=1,D35,IF(AND(COUNTA(D32:D37)=2,AND(D33<>\"\",D36<>\"\")),AVERAGE(D33,D36),IF(AND(COUNTA(D32:D37)=3,AND(D33<>\"\",D35<>\"\",D36<>\"\")),0.25*(D33+D35*2+D36),IF(AND(COUNTA(D32:D37)=5,AND(D32<>\"\",D33<>\"\",D35<>\"\",D36<>\"\",D37<>\"\")),0.1*(D32+3*D33+3*D35+2*D36+D37),IF(AND(COUNTA(D32:D37)=6,AND(D32<>\"\",D33<>\"\",D34<>\"\",D35<>\"\",D36<>\"\",D37<>\"\")),0.1*(D32+2*D33+2*D34+2*D35+2*D36+D37),\"\")))))))","v":8.2000000000000017E-2},7.6000000000000012E-2,0.13400000000000001,0.11400000000000002,{"$f":"IF(H17=\"Rive Gauche\",(2*$E$11-1)*I39,IF(H17=\"Rive Droite\",(2*$E$11-1)*G39,IF(COUNTA(H32:H37)=1,H35,IF(AND(COUNTA(H32:H37)=2,AND(H33<>\"\",H36<>\"\")),AVERAGE(H33,H36),IF(AND(COUNTA(H32:H37)=3,AND(H33<>\"\",H35<>\"\",H36<>\"\")),0.25*(H33+H35*2+H36),IF(AND(COUNTA(H32:H37)=5,AND(H32<>\"\",H33<>\"\",H35<>\"\",H36<>\"\",H37<>\"\")),0.1*(H32+3*H33+3*H35+2*H36+H37),IF(AND(COUNTA(H32:H37)=6,AND(H32<>\"\",H33<>\"\",H34<>\"\",H35<>\"\",H36<>\"\",H37<>\"\")),0.1*(H32+2*H33+2*H34+2*H35+2*H36+H37),\"\")))))))","v":8.7000000000000008E-2},5.220000000000001E-2,"","","","","",null,{"$f":"MAX(C32:M37)","v":0.19},null,null,null,null,null,null,null,null,null,null,null,null,"Nombre de points\nde mesure"]
[null,"Débits unitaires par verticale - Méthode de la section moyenne (en m3/s) :"]
[null,null,{"$f":"IF(C21<>\"\",C21*AVERAGE(B23:C23)*AVERAGE(B39:C39),\"\")","v":0},{"$f":"IF(D21<>\"\",D21*AVERAGE(C23:D23)*AVERAGE(C39:D39),\"\")","v":1.7589000000000007E-3},6.1620000000000008E-3,8.8042500000000013E-3,9.7929000000000054E-3,6.7611374999999975E-3,4.5239999999999847E-4,"","","","",{"$f":"IF(N21<>\"\",N21*AVERAGE(M23:N23)*AVERAGE(M39:N39),\"\")","v":""}]
[null,{"$f":"IF(B41=\"\",\"\",B41/$H$44)","v":""},{"$f":"IF(C41=\"\",\"\",C41/$H$44)","v":0},5.214400300608444E-2,0.18267743846920931,0.26100906161027848,0.29031838480771188,0.20043935080138153,1.3411761305334306E-2,"","","","",""]
[null,{"$f":"COUNTIF(A42:M42,\">0,1\")/COUNTA(A42:M42)","v":0.33333333333333331},0.30769230769230771,0.33333333333333331,0.36363636363636365,0.4,0.33333333333333331,0.25,0.14285714285714285,0,0,0,0,0]
[null,"Débits sur la totalité de la section de mesure :",null,null,null,null,null,{"$f":"SUM(C41:N41)","v":3.3731587500000007E-2},null,{"$f":"H44*60*60","v":121.43371500000002},null,{"$f":"J44*24","v":2914.4091600000006}]
[null,"Surface mouillée totale :",null,null,null,{"$f":"IF(C21=\"\",0,C21*AVERAGE(B23:C23))+IF(D21=\"\",0,D21*AVERAGE(C23:D23))+IF(E21=\"\",0,E21*AVERAGE(D23:E23))+IF(F21=\"\",0,F21*AVERAGE(E23:F23))+IF(G21=\"\",0,G21*AVERAGE(F23:G23))+IF(H21=\"\",0,H21*AVERAGE(G23:H23))+IF(I21=\"\",0,I21*AVERAGE(H23:I23))+IF(J21=\"\",0,J21*AVERAGE(I23:J23))+IF(K21=\"\",0,K21*AVERAGE(J23:K23))+IF(L21=\"\",0,L21*AVERAGE(K23:L23))+IF(M21=\"\",0,M21*AVERAGE(L23:M23))+IF(N21=\"\",0,N21*AVERAGE(M23:N23))","v":0.35874999999999996},null,"Vitesse moyenne jaugée :",null,null,null,{"$f":"H44/F45","v":9.4025331010452989E-2}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Formules de calcul des vitesses moyennes selon le nombre de points de mesure par verticale :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Méthode à 1 point : Vitesse moyenne = V0,4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Méthode à 2 points : Vitesse moyenne = 0,5 x (V0,2 + V0,8)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Méthode à 3 points : Vitesse moyenne = 0,25 x (V0,2 + 2V0,6 + V0,8)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Méthode à 5 points : Vitesse moyenne = 0,1 x (Vsurface + 3V0,2 + 3V0,6 + 2V0,8 + Vfond)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Méthode à 6 points : Vitesse moyenne = 0,1 x (Vsurface + 2V0,2 + 2V0,4 + 2V0,6 + 2V0,8 + Vfond)"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coefficients de rive :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kr = 1 : Berges lisses de forme rectangulaire è Débit maximal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kr = 0,8 : Valeur par défaut à utiliser pour les canaux rectangulaires"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kr = 0,5 : Berges de forme triangulaire è Débit nul"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nombre de verticales :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Le débit unitaire de chaque verticale doit être inférieur à  5% du débit total, et en aucun cas il ne doit dépasser 10% du débit total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"La distance entre 2 verticales doit être supérieure à la largeur du capteur"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Les première et dernière verticales doivent être aussi proche que possible de la bordure de l'eau"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nombre de points par verticale :"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"La différence des mesures de vitesse entre 2 points adjacents ne doit pas dépasser 20% de la vitesse la plus élevée"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Les incertitudes de mesure en fonction du nombre de point sont les suivantes : 5 points 2,5%, 2 points 3,5%, 1 point 7,5%"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Méthode de mesure par point:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Le chenal de mesure doit être rectiligne, de section et de pente uniforme, présenter des longueurs droites en amont ≥ 6 fois la largeur du chanal et en aval ≥ 3 fois la largeur du chenal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Les directions d'écoulement doivent être parrallèles les unes aux autres et perpendiculaires à la section de mesurage"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Le dispositif utilisé pour réaliser le mesurage de la vitesse doit être positionné dans l'axe du flux"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Le dispositif utilisé pour réaliser le mesurage de la vitesse doit être maintenu en position pendant au moins 30 secondes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Le niveau d'eau doit être lu au début et à la fin de la période de mesurage"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Deux cycles complets de mesurage doivent être réalisés, si les résultats diffèrent de plus de 10% l'opération doit être répétée"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Les courantomètres électromagnétiques ne doivent pas être utilisés lorsque la hauteur d'eau est inférieure à 3 fois l'épaisseur du capteur"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Les courantomètres rotatifs ne doivent pas être utilisés lorsque la hauteur d'eau est inférieure à 4 fois le diamètre de l'hélice utilisée"]

{"sheet":"Chek Liste Matériel","index":5,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Chek list du matériel à prendre pour réaliser les jaugeages dans les canaux découverts :"]
[null,"1 Courantomètre",null,null,"1 Paire de cuissarde",null,null,"1 Appareil photo"]
[null,"1 Mire télescopique",null,null,"1 Harnais + Trépied",null,null,"1 Fiche de terrain"]
[null,"1 Réglet d'un mètre",null,null,"1 Machette",null,null,"1 Pc portable"]
[null,"1 Décamètre",null,null,"1 Paire de gants vinyle"]
[null,"1 Mètre rubant à lecture directe",null,null,"1 Paire de gants de chantier"]
[null,"1 Télémètre laser",null,null,"1 Echelle télescopique"]
[null,"1 Fil à plomb"]
[null,"1 Saut"]