{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Explication grandeurs à rentrer","sans masque de haut de grille","avec masque de haut de grille"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":0,"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":"Explication grandeurs à rentrer","index":0,"n_rows":46,"n_cols":5,"rows_kept":46,"cut":false,"hidden":false,"merged":[[2,7,26,15],[37,1,37,4],[28,7,42,15]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Largeur","Largeur du canal",null,"m"]
[null,"Hauteur","Hauteur d’eau dans le canal",null,"m"]
[null,"hgrille","Hauteur de la grille",null,"m"]
[null,"hc","hauteur de la surface colmatée",null,"m"]
[null,"hmasque","Hauteur masquée de la grille",null,"m"]
[null,"β","Angle d’inclinaison de la grille",null,"°"]
[]
[null,"vitesse (v1)","vitesse débitante dans le canal","V1 = Q/(Largeur*Hauteur)","m,s-1"]
[null,"vitesse (vturb)","Vitesse turbinée (grille)","Vturb = Qturb/(largeur*hgrille)","m,s-1"]
[]
[null,"ob","Obstruction des barreaux",null,"-"]
[null,"Kf","Coefficient de forme des barreaux",null,"-"]
[]
[null,"Dent","Diamètre des entretoises",null,"m"]
[null,"Kent","Coefficient de forme des entretoises",null,"-"]
[null,"Nent","Nombre d’entretoises",null,"-"]
[]
[null,"Dsupport","Diamètre des supports",null,"m"]
[null,"Ksupport","Coefficient de forme des supports",null,"-"]
[null,"Nsupport","Nombre de supports",null,"-"]
[]
[null,"oc","obstruction du colmatage",null,"-"]
[null,"oc1","Obstruction du colmatage supérieur"]
[null,"oc2","obstruction du colmatage inférieur"]
[null,"Pour un colmatage homogène oc1=oc2 et Tc=100 %"]
[]
[null,"Tc","Taux de surface colmaté",null,"-"]
[null,null,"sans masque","Tc=hc/hgrille"]
[null,null,"avec masque","Tc=hc/Hauteur"]
[]
[null,"Tm","Taux de surface masquée","Tm=hmasque/Hauteur","-"]
[]
[null,"Δhautres","perte de charge des autres éléments",null,"m"]

{"sheet":"sans masque de haut de grille","index":1,"n_rows":78,"n_cols":20,"rows_kept":78,"cut":false,"hidden":false,"merged":[[76,4,76,5],[76,6,76,7],[76,8,76,9],[76,10,76,11],[76,12,76,13],[77,4,77,5],[77,6,77,7],[77,8,77,9],[77,10,77,11],[77,12,77,13],[71,1,71,17],[73,6,73,7],[73,8,73,9],[73,10,73,11],[74,6,74,7],[74,8,74,9],[74,10,74,11],[65,10,65,12],[39,8,39,10],[41,11,41,16],[42,11,42,16],[46,1,46,17],[48,2,48,8],[48,10,48,16],[50,3,50,6],[50,11,50,14],[53,14,53,16],[54,14,54,16],[63,1,63,17],[2,1,7,18],[10,2,29,8],[10,11,29,17],[32,1,32,17],[34,2,34,4],[34,6,34,8],[34,10,34,12],[34,14,34,16]]}
[]
[]
[null,"Approche sans masque de haut de grille avec un colmatage homogène ou non"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Informations à fournir"]
[]
[null,null,"Prise d’eau",null,null,null,"Barreaux",null,null,null,"Entretoises",null,null,null,"supports"]
[null,null,"Largeur",7,"m",null,"ob",29,"%",null,"Dent",0.03,"m",null,"Dsupport",0.1,"m"]
[null,null,"hgrille",2,"m",null,"β",26,"°",null,"Nent",10,"-",null,"Nsupport",3,"-"]
[null,null,"vitese (vturb)",0.6,"m.s-1",null,"KF",3.85,"-",null,"Kent",1.79,"-",null,"Ksupport",{"$f":"IF(Q40=\"Oui\",P40,P41)","v":2.6648727099228777},"-",null,null,"Oui"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,"Colmatage",null,null,null,null,null,"Support classique",{"$f":"2.665*COS(RADIANS(H37-26.56))","v":2.6648727099228777},"Oui"]
[null,null,null,null,null,null,null,null,"oc1",50,"%",null,null,null,"Support optimisé",0.5]
[null,null,null,null,null,null,null,null,"oc2",0,"%","Oc2 = 0 si colmatage homogène ou colmatage due en haut de grille"]
[null,null,null,null,null,null,null,null,"Tc",100,"%","Tc = 100 % si colmatage homogène"]
[]
[]
[]
[null,"Calcul de la perte de charge"]
[]
[null,null,"Grille propre",null,null,null,null,null,null,null,"Grille colmatée"]
[]
[null,null,null,"Constantes intermédaires",null,null,null,null,null,null,null,"Constantes intermédaires"]
[null,null,null,"Oent",{"$f":"(1-H36/100)*(L37*L36)/D37","v":0.1065},"-",{"$f":"E52","v":0.1065},null,null,null,null,"otot,bas",{"$f":"H36/100+(1-H36/100)*J42/100","v":0.28999999999999998},"-",{"$f":"M52","v":0.28999999999999998}]
[null,null,null,"Osp",{"$f":"(1-H36/100)*(P37*P36)/P38","v":7.992877078401403E-2},"-",{"$f":"E53","v":7.992877078401403E-2}]
[null,null,null,null,null,null,null,null,null,null,null,"ξ1",{"$f":"H57+4.7*(100/(100-H36))^2*(J41/(100-J41))*(SIN(RADIANS(H37)))^2","v":2.7146341167927428},"-","Si oc1=100 % c’est normal que cela marque DIV/0"]
[null,null,null,null,null,null,null,null,null,null,null,"ξ2",{"$f":"H57+4.7*(100/(100-H36))^2*(J42/(100-J42))*(SIN(RADIANS(H37)))^2","v":0.92293498371457794},"-","pareil si oc2 = 100 %"]
[null,null,null,null,"barreaux","entretoises","supports","xipropre",null,null,null,"ξCd",{"$f":"3.04*(1-M52)*(J43/100)^1.23*(J41/100)^1.54*(1+(COS(RADIANS(H37)))^2)","v":1.3418485623658571},"-"]
[null,null,null,"ξpropre (-)",{"$f":"H38*(H36/(100-H36))^1.65*(SIN(RADIANS(H37)))^2","v":0.1688593346523293},{"$f":"L38*(E52/(1-E52))^0.77","v":0.34799212832339976},{"$f":"P38*(E53/(1-E53))^0.77","v":0.40608352073884896},{"$f":"E57+F57+G57","v":0.92293498371457794}]
[null,null,null,"Part [%]",{"$f":"E57/H57","v":0.18295907905962513},{"$f":"F57/H57","v":0.37704945035545212},{"$f":"G57/H57","v":0.43999147058492283},{"$f":"G58+F58+E58","v":1},null,null,null,"ξgrille",{"$f":"IF( AND(J41<>100,J42  <> 100),(1/((J43/100)/SQRT(M54)+(1-J43/100)/SQRT(M55+M56)))^2,IF(J41<>100,(1/((J43/100)/SQRT(M54)))^2,(1/((1-J43/100)/SQRT(M55+M56)))^2))","v":2.7146341167927432},"-"]
[null,null,null,null,null,null,null,null,null,null,null,"Δh",{"$f":"M58*D38^2/(2*9.81)","v":4.9809800308123722E-2},"m",{"$f":"M59*1000","v":49.80980030812372},"mm"]
[]
[]
[]
[]
[null,"Bonus : calcul de la perte de charge de la prise d’eau"]
[]
[null,null,null,null,null,null,null,"Δhautres",0,"m","!! grandeur à rentrer"]
[]
[null,null,null,null,null,null,null,"Δhtot",{"$f":"M59+I66","v":4.9809800308123722E-2},"m",{"$f":"I68*1000","v":49.80980030812372},"mm"]
[]
[]
[]
[null,"Résumé des résultats"]
[]
[null,null,null,null,null,null,"ξgrille",null,{"$f":"M58","v":2.7146341167927432},null,"-"]
[null,null,null,null,null,null,"ξtot",null,{"$f":"IF(I66<>0,2*9.81*G78/D38^2,\"Il manque une info\")","v":"Il manque une info"},null,"-"]
[]
[null,null,null,null,"Δhgrille",null,{"$f":"M59","v":4.9809800308123722E-2},null,"m",null,{"$f":"O59","v":49.80980030812372},null,"mm"]
[null,null,null,null,"Δhtot",null,{"$f":"IF(I66<>0,I68,\"il manque une info\")","v":"il manque une info"},null,"m",null,{"$f":"IF(I66<>0,K68,\"Il manque une info\")","v":"Il manque une info"},null,"mm"]

{"sheet":"avec masque de haut de grille","index":2,"n_rows":79,"n_cols":20,"rows_kept":79,"cut":false,"hidden":false,"merged":[[77,12,77,13],[78,4,78,5],[78,6,78,7],[78,8,78,9],[78,10,78,11],[78,12,78,13],[75,6,75,7],[75,8,75,9],[75,10,75,11],[77,4,77,5],[77,6,77,7],[77,8,77,9],[77,10,77,11],[64,1,64,17],[66,10,66,12],[72,1,72,17],[74,6,74,7],[74,8,74,9],[74,10,74,11],[50,3,50,7],[50,11,50,15],[2,1,7,18],[10,2,29,8],[10,11,29,17],[32,1,32,17],[34,2,34,4],[34,6,34,8],[34,10,34,12],[34,14,34,16],[39,8,39,10],[41,11,41,16],[46,1,46,17],[48,2,48,8],[48,10,48,16]]}
[]
[]
[null,"Approche sans masque de haut de grille avec un colmatage homogène ou non"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Informations à fournir"]
[]
[null,null,"Prise d’eau",null,null,null,"Barreaux",null,null,null,"Entretoises",null,null,null,"supports"]
[null,null,"Largeur",7,"m",null,"ob",29,"%",null,"Dent",0.03,"m",null,"Dsupport",0.1,"m"]
[null,null,"Hauteur",2,"m",null,"β",26,"°",null,"Nent",10,"-",null,"Nsupport",3,"-"]
[null,null,"vitese (v1)",0.6,"m.s-1",null,"KF",3.85,"-",null,"Kent",1.79,"-",null,"Ksupport",{"$f":"IF(Q40=\"Oui\",P40,P41)","v":2.6648727099228777},"-"]
[]
[null,null,null,null,null,null,null,null,"Colmatage",null,null,null,null,null,"Support classique",{"$f":"2.665*COS(RADIANS(H37-26.56))","v":2.6648727099228777},"Oui",null,null,"Oui"]
[null,null,null,null,null,null,null,null,"oc",50,"%",null,null,null,"Support optimisé",0.5,null,null,null,"Non"]
[null,null,null,null,null,null,null,null,"Tc",85,"%"]
[null,null,null,null,null,null,null,null,"Tm",15,"%"]
[]
[]
[]
[null,"Calcul de la perte de charge"]
[]
[null,null,"Grille propre",null,null,null,null,null,null,null,"Grille colmatée"]
[]
[null,null,null,"Constantes intermédaires",null,null,null,null,null,null,null,"Constantes intermédaires"]
[null,null,null,"Oent",{"$f":"(1-H36/100)*(L37*L36)/D37","v":0.1065},"-",{"$f":"E52*100","v":10.65},"%",null,null,null,"otot,colm",{"$f":"H36/100+(1-H36/100)*J41/100","v":0.64500000000000002},"-",{"$f":"M52","v":0.64500000000000002},"%"]
[null,null,null,"Osp",{"$f":"(1-H36/100)*(P37*P36)/P38","v":7.992877078401403E-2},"-",{"$f":"E53*100","v":7.9928770784014027},"%"]
[null,null,null,null,null,null,null,null,null,null,null,"ξ1",{"$f":"H57+4.7*(100/(100-H36))^2*(J41/(100-J41))*(SIN(RADIANS(H37)))^2","v":2.7146341167927428},"-"]
[null,null,null,null,null,null,null,null,null,null,null,"ξ2",{"$f":"H57","v":0.92293498371457794},"-"]
[null,null,null,null,"barreaux","entretoises","supports","xipropre",null,null,null,"ξCd1",{"$f":"3.04*(1-M52)*(J43/100)^1.2*(1+(COS(RADIANS(H37)))^2)","v":0.20024847332388862},"-"]
[null,null,null,"ξpropre (-)",{"$f":"H38*(H36/(100-H36))^1.65*(SIN(RADIANS(H37)))^2","v":0.1688593346523293},{"$f":"L38*(E52/(1-E52))^0.77","v":0.34799212832339976},{"$f":"P38*(E53/(1-E53))^0.77","v":0.40608352073884896},{"$f":"E57+F57+G57","v":0.92293498371457794},null,null,null,"ξCd2",{"$f":"3.04*(1-H36/100)*((J42/100)^1.2*(J41/100)^1.54+1.7*(J43/100)^1.2)*(1+(COS(RADIANS(H37)))^2)","v":1.784939232050136},"-"]
[null,null,null,"Part [%]",{"$f":"E57/$H$57","v":0.18295907905962513},{"$f":"F57/$H$57","v":0.37704945035545212},0.43999147058492283,{"$f":"G58+F58+E58","v":1}]
[null,null,null,null,null,null,null,null,null,null,null,"ξgrille",{"$f":"(1/((J42/100)/SQRT(M54+M56)+(1-J42/100-J43/100)/SQRT(M55+M57)))^2","v":4.0344395710956844},"-"]
[null,null,null,null,null,null,null,null,null,null,null,"Δh",{"$f":"M59*D38^2/(2*9.81)","v":7.4026414148544661E-2},"m",{"$f":"M60*1000","v":74.02641414854466},"mm"]
[]
[]
[]
[]
[null,"Bonus : calcul de la perte de charge de la prise d’eau"]
[]
[null,null,null,null,null,null,null,"Δhautres",0,"m","!! grandeur à rentrer"]
[]
[null,null,null,null,null,null,null,"Δhtot",{"$f":"M60+I67","v":7.4026414148544661E-2},"m",{"$f":"I69*1000","v":74.02641414854466},"mm"]
[]
[]
[]
[null,"Résumé des résultats"]
[]
[null,null,null,null,null,null,"ξgrille",null,{"$f":"M59","v":4.0344395710956844},null,"-"]
[null,null,null,null,null,null,"ξtot",null,{"$f":"IF(I67<>0,2*9.81*G79/D40^2,\"Il manque une info\")","v":"Il manque une info"},null,"-"]
[]
[null,null,null,null,"Δhgrille",null,{"$f":"M60","v":7.4026414148544661E-2},null,"m",null,{"$f":"O60","v":74.02641414854466},null,"mm"]
[null,null,null,null,"Δhtot",null,{"$f":"IF(I67<>0,I69,\"il manque une info\")","v":"il manque une info"},null,"m",null,{"$f":"IF(I67<>0,K69,\"Il manque une info\")","v":"Il manque une info"},null,"mm"]