{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["OTWH 200 EV","Calcul","Hygro A","Hygro B","Feuil1","PdC","Images"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":1,"defined_names":27,"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":"OTWH 200 EV","index":0,"n_rows":116,"n_cols":15,"rows_kept":116,"cut":false,"hidden":false,"merged":[[107,2,108,6],[111,14,112,14],[57,8,57,11],[111,13,112,13],[25,2,26,6],[83,2,84,4],[111,2,112,4],[32,2,32,3],[108,9,108,11],[111,7,112,11],[76,2,76,3],[68,2,68,3],[72,2,72,3],[34,2,34,3],[36,2,36,3],[38,2,38,3],[1,6,3,13],[16,5,16,9],[60,2,60,3],[64,2,64,3],[40,2,40,3],[8,1,8,13],[9,1,9,13],[10,1,10,13],[18,5,18,9],[20,5,20,9],[23,0,23,14],[5,0,5,14],[14,0,14,14],[29,7,29,11]]}
["ciddls"]
[null,null,null,null,null,null,"Chauffe-eau thermodynamique sur VMC\nOTWH 200 EV"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version 01/2019"]
["ciddls"]
[]
[null,"Référence de l'étude"]
[]
[]
[]
[]
[]
[null,null,"Données"]
[]
[]
[null,null,null,"Type de ventilation",null,"Hygro B"]
[]
[null,null,null,"Type de logement",null,"F1 (WC commun avec SbB)"]
[]
[null,null,null,"Type de réseau",null,"Multipiquage"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(F21=\"Multipiquage\",\"Attention : 3 piquages maximum\",\"\")","v":"Attention : 3 piquages maximum"}]
[null,null,"Pertes de charge"]
[]
[]
[null,null,"Perte de charge à la bouche d'extraction"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,80,"Pa"]
[]
[]
[null,null,{"$f":"IF(F21=\"Pieuvre (caisson)\",\"Perte de charge entre la bouche et le caisson\",\"Perte de charge entre la bouche et le OTWH\")","v":"Perte de charge entre la bouche et le OTWH"},null,null,null,null,{"$f":"IF(OR(AND(F33=\"Rigide\",H33=80),AND(F35=\"Rigide\",H35=80),AND(F37=\"Rigide\",H37=80),AND(F39=\"Rigide\",H39=80),AND(F41=\"Rigide\",H41=80)),\"Attention : Gaine rigide Ø 80 non fourni par Oertli\",\"\")","v":""}]
[]
[null,null,"Type de tronçon",null,null,"Type de gaine",null,"Diamètre (mm)",null,"Longueur (m)",null,"Nbr coudes"]
[null,null,null,null,null,null,null,{"$f":"PdC!F3","v":""}]
[]
[null,null,null,null,null,null,null,{"$f":"PdC!F4","v":""}]
[]
[null,null,"",null,null,null,null,{"$f":"PdC!F5","v":""}]
[]
[null,null,"",null,null,"Souple",null,{"$f":"PdC!F6","v":""}]
[]
[null,null,null,null,null,null,null,{"$f":"PdC!F7","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Tronçon le plus défavorable : \",PdC!N13)","v":"Tronçon le plus défavorable : 0"},null,{"$f":"IF(F21=\"Pieuvre (caisson)\",PdC!K8,IF(F21=\"Multipiquage\",PdC!K19,0))","v":0},"Pa"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"IF('OTWH 200 EV'!F21=\"Linéaire\",1,0)","v":0}]
[]
[null,null,null,null,null,null,null,{"$f":"PdC!A42","v":"Configuration non conforme"}]
[]
[]
[null,null,null,null,null,null,null,{"$f":"affichecache(H48,0,\"Aide\")","v":0}]
[]
[]
[]
[]
[null,null,"Perte de charge entre la bouche d'extraction et le OTWH",null,null,null,null,null,"Les tés et réductions sont intégrés au calcul"]
[]
[null,null,"Type de tronçon",null,null,"Type de gaine",null,"Diamètre (mm)",null,"Longueur (m)",null,"Nbr coudes"]
[null,null,"WC unique",null,"Tp 1 ","Rigide",null,80,null,3,null,1]
[]
[null,null,null,"Si supérieur à 1 m","Tr 1 ",null,null,{"$f":"PdC!F26","v":80}]
[]
[null,null,"Salle de bain",null,"Tp 2 ","Rigide",null,80,null,2,null,0]
[]
[null,null,null,"Si supérieur à 1 m","Tr 2 ","Souple",null,{"$f":"PdC!F28","v":80},null,3,null,0]
[]
[null,null,"Cuisine",null,"Tp 3 ","Rigide",null,160,null,8,null,1]
[]
[null,null,null,"Si supérieur à 1 m","Tr 3 ","Souple",null,{"$f":"PdC!F30","v":125},null,1,null,0]
[]
[null,null,null,null,"Tp 4 "]
[]
[null,null,null,"Si supérieur à 1 m","Tr 4 ",null,null,{"$f":"PdC!F32","v":""}]
[]
[null,null,null,null,"Tp 5 "]
[]
[null,null,null,"Si supérieur à 1 m","Tr 5",null,null,{"$f":"PdC!F34","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Tronçon le plus défavorable : \",PdC!N13)","v":"Tronçon le plus défavorable : 0"},null,{"$f":"PdC!M35","v":20.793288229298383},"Pa"]
[]
[]
[null,null,"Perte de charge du caisson"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(F21=\"Pieuvre (caisson)\",25,0)","v":0},"Pa"]
[]
[]
[null,null,"Perte de charge entre le caisson et le OTWH"]
[]
[null,null,{"$f":"IF(F21=\"Pieuvre (caisson)\",1,0)","v":0}]
[null,null,null,null,null,"Type de gaine",null,"Diamètre (mm)",null,"Longueur (m)",null,"Nbr coudes"]
[null,null,null,null,null,"Rigide",null,160,null,8,null,1]
[]
[null,null,{"$f":"affichecache(C90,0,\"AmontBal\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H92=160,\"Réduction 125/160 à installer sur le caisson\",IF(H92=125,\"Réduction 125/160 à installer sur le OTWH 200 EV\",\"\"))","v":"Réduction 125/160 à installer sur le caisson"},null,{"$f":"IF(F21=\"Pieuvre (caisson)\",PdC!K9,0)","v":0},"Pa"]
[]
[]
[null,null,"Perte de charge entre le OTWH et la bouche d'évacuation"]
[]
[]
[null,null,null,null,null,"Type de gaine",null,"Diamètre (mm)",null,"Longueur (m)",null,"Nbr coudes"]
[null,null,null,null,null,null,null,160]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"PdC!N5","v":0},"Pa"]
[]
[]
[null,null,"Perte de charge de la bouche d'évacuation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(J109,Calcul!A30:B31,2,FALSE),\"\")","v":""},"Pa"]
[]
[]
[null,null,"Pertes de charges totales",null,null,null,null,{"$f":"PdC!A40","v":"Configuration non conforme (valeur limite : 291,2 Pa)"},null,null,null,null,null,{"$f":"IFERROR(IF(F21=\"Linéaire\",N109+N105+N95+N85+N81+N27,N109+N105+N95+N85+N43+N27),\"\")","v":""},"Pa"]
[]
[]
[]
[null,"Les résultats de cette feuille de calcul sont donnés à titre indicatif. La responsabilité d'Oertli ne peut en aucun cas être engagée."]

{"sheet":"Calcul","index":1,"n_rows":44,"n_cols":10,"rows_kept":44,"cut":false,"hidden":true,"merged":[[8,0,8,1],[43,0,43,1],[28,0,28,1]]}
["Diamètre Caisson","Type Conduit","Type VMC","Type evac","Type réseau",null,"Type de logement",null,"6-40/90",90]
[125,"Souple","Hygro A","Chapeau toiture","Linéaire",null,{"$f":"IF('OTWH 200 EV'!$F$17=\"Hygro B\",'Hygro B'!A3,'Hygro A'!A3)","v":"F1 (WC commun avec SbB)"},null,"10-45/135",135]
[160,"Rigide","Hygro B","Bouche murale","Multipiquage",null,{"$f":"IF('OTWH 200 EV'!$F$17=\"Hygro B\",'Hygro B'!A4,'Hygro A'!A4)","v":"F1 (WC séparé)"},null,"12-45/105",105]
[null,null,null,null,"Pieuvre (caisson)",null,{"$f":"IF('OTWH 200 EV'!$F$17=\"Hygro B\",'Hygro B'!A5,'Hygro A'!A5)","v":"F2 (WC commun avec SdB)"},null,"12-45/135",135]
["Diamètre Linéaire",null,null,null,null,null,{"$f":"IF('OTWH 200 EV'!$F$17=\"Hygro B\",'Hygro B'!A6,'Hygro A'!A6)","v":"F2 (WC séparé)"},null,"10-40",40]
[80,null,null,null,null,null,{"$f":"IF('OTWH 200 EV'!$F$17=\"Hygro B\",'Hygro B'!A7,'Hygro A'!A7)","v":"F3 Optimisé (WC commun avec SdB)"},null,"5-40",40]
[125,null,null,null,null,null,{"$f":"IF('OTWH 200 EV'!$F$17=\"Hygro B\",'Hygro B'!A8,'Hygro A'!A8)","v":"F3 Optimisé (WC séparé)"},null,"10-45",45]
[160,null,null,null,null,null,{"$f":"IF('OTWH 200 EV'!$F$17=\"Hygro B\",'Hygro B'!A9,'Hygro A'!A9)","v":"F3 (WC commun avec SdB)"},null,"5-45",45]
[null,null,null,null,null,null,{"$f":"IF('OTWH 200 EV'!$F$17=\"Hygro B\",'Hygro B'!A10,'Hygro A'!A10)","v":"F3 (WC séparé)"},null,"10-45/45",45]
[null,null,null,null,null,null,{"$f":"IF('OTWH 200 EV'!$F$17=\"Hygro B\",'Hygro B'!A11,'Hygro A'!A11)","v":"F4 (WC commun avec SdB)"},null,"5/30",30]
["Cuisine",{"$f":"IF('OTWH 200 EV'!$F$17=\"Hygro A\",VLOOKUP('OTWH 200 EV'!$F$19,'Hygro A'!$A$3:$I$13,4,FALSE),VLOOKUP('OTWH 200 EV'!$F$19,'Hygro B'!$A$3:$I$16,4,FALSE))","v":"6-40/90"},{"$f":"VLOOKUP(B11,$I$1:$J$15,2,FALSE)","v":90},{"$f":"IF(C11=0,\"\",A11)","v":"Cuisine"},{"$f":"D11","v":"Cuisine"},null,{"$f":"IF('OTWH 200 EV'!$F$17=\"Hygro B\",'Hygro B'!A12,'Hygro A'!A12)","v":"F4 (WC séparé)"},null,"Auto 30",30]
["Salle de bain",{"$f":"IF('OTWH 200 EV'!$F$17=\"Hygro A\",VLOOKUP('OTWH 200 EV'!$F$19,'Hygro A'!$A$3:$I$13,5,FALSE),VLOOKUP('OTWH 200 EV'!$F$19,'Hygro B'!$A$3:$I$16,5,FALSE))","v":"10-40"},40,{"$f":"IF(C12=0,\"\",A12)","v":"Salle de bain"},"Salle de bain",null,{"$f":"IF('OTWH 200 EV'!$F$17=\"Hygro B\",'Hygro B'!A13,'Hygro A'!A13)","v":"F5 (WC commun avec SdB)"},null,"Auto 15",15]
["Salle de bain 2",{"$f":"IF('OTWH 200 EV'!$F$17=\"Hygro A\",VLOOKUP('OTWH 200 EV'!$F$19,'Hygro A'!$A$3:$I$13,6,FALSE),VLOOKUP('OTWH 200 EV'!$F$19,'Hygro B'!$A$3:$I$16,6,FALSE))","v":"Non applicable"},0,"","",null,{"$f":"IF('OTWH 200 EV'!$F$17=\"Hygro B\",'Hygro B'!A14,\"\")","v":"F5 (WC séparé)"},null,"10-45/120",120]
["WC unique",{"$f":"IF('OTWH 200 EV'!$F$17=\"Hygro A\",VLOOKUP('OTWH 200 EV'!$F$19,'Hygro A'!$A$3:$I$13,7,FALSE),VLOOKUP('OTWH 200 EV'!$F$19,'Hygro B'!$A$3:$I$16,7,FALSE))","v":"Non applicable"},0,"","",null,{"$f":"IF('OTWH 200 EV'!$F$17=\"Hygro B\",'Hygro B'!A15,\"\")","v":"F6 et + (WC commun avec SdB)"}]
["WC multiple",{"$f":"IF('OTWH 200 EV'!$F$17=\"Hygro A\",VLOOKUP('OTWH 200 EV'!$F$19,'Hygro A'!$A$3:$I$13,8,FALSE),VLOOKUP('OTWH 200 EV'!$F$19,'Hygro B'!$A$3:$I$16,8,FALSE))","v":"Non applicable"},0,"","",null,{"$f":"IF('OTWH 200 EV'!$F$17=\"Hygro B\",'Hygro B'!A16,\"\")","v":"F6 et + (WC séparé)"},null,"Non applicable",0]
["Salle d'eau",{"$f":"IF('OTWH 200 EV'!$F$17=\"Hygro A\",VLOOKUP('OTWH 200 EV'!$F$19,'Hygro A'!$A$3:$I$13,9,FALSE),VLOOKUP('OTWH 200 EV'!$F$19,'Hygro B'!$A$3:$I$16,9,FALSE))","v":"5-40"},40,"Salle d'eau","Salle d'eau"]
[]
[]
[]
[]
["Type gaine 1","Type gaine 2","Type gaine 3","Type gaine 4","Type gaine 5"]
["Souple","Souple","Souple","Souple","Souple"]
["Rigide","Rigide","Rigide","Rigide","Rigide"]
[]
["Diam1","Diam2","Diam3","Diam4","Diam5"]
[{"$f":"IF(PdC!E25>72,\"\",80)","v":80},{"$f":"IF('OTWH 200 EV'!H61>80,\"\",IF(PdC!E27>72,\"\",80))","v":80},{"$f":"IF('OTWH 200 EV'!H65>80,\"\",IF(PdC!E29>72,\"\",80))","v":""},{"$f":"IF('OTWH 200 EV'!H69>80,\"\",IF(PdC!E31>72,\"\",80))","v":""},{"$f":"IF('OTWH 200 EV'!H73>80,\"\",IF(PdC!E33>72,\"\",80))","v":""}]
[{"$f":"IF(PdC!E25>177,\"\",125)","v":125},{"$f":"IF('OTWH 200 EV'!H61>125,\"\",IF(PdC!E27>177,\"\",125))","v":125},{"$f":"IF('OTWH 200 EV'!H65>125,\"\",IF(PdC!E29>177,\"\",125))","v":125},{"$f":"IF('OTWH 200 EV'!H69>125,\"\",IF(PdC!E31>177,\"\",125))","v":""},{"$f":"IF('OTWH 200 EV'!H73>125,\"\",IF(PdC!E33>177,\"\",125))","v":125}]
[{"$f":"IF(PdC!E25>289,\"\",160)","v":160},{"$f":"IF(PdC!E27>289,\"\",160)","v":160},{"$f":"IF(PdC!E29>289,\"\",160)","v":160},{"$f":"IF(PdC!E31>289,\"\",160)","v":160},{"$f":"IF(PdC!E33>289,\"\",160)","v":160}]
["PdC Evac Pieuvre"]
["Chapeau toiture",{"$f":"IF('OTWH 200 EV'!F21=\"Pieuvre (caisson)\",ROUND(0.000218570543*PdC!E11*PdC!E11-0.00930633216*PdC!E11+0.0606408439,0),IF('OTWH 200 EV'!F21=\"Multipiquage\",ROUND(0.000218570543*PdC!E20*PdC!E20-0.00930633216*PdC!E20+0.0606408439,0),ROUND(0.000218570543*PdC!E36*PdC!E36-0.00930633216*PdC!E36+0.0606408439,0)))","v":0}]
["Bouche murale",{"$f":"IF('OTWH 200 EV'!F21=\"Pieuvre (caisson)\",ROUND(0.000328449713*PdC!E11*PdC!E11-0.00570942987*PdC!E11+0.0575367606,0),IF('OTWH 200 EV'!F21=\"Multipiquage\",ROUND(0.000328449713*PdC!E20*PdC!E20-0.00570942987*PdC!E20+0.0575367606,0),ROUND(0.000328449713*PdC!E36*PdC!E36-0.00570942987*PdC!E36+0.0575367606,0)))","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Pression disponible",null,{"$f":"-0.00000003677*POWER(E40,4)+0.00001154422*POWER(E40,3)-0.000629507747*POWER(E40,2)-0.279286840456*E40+291.152612094602","v":291.15261209460198}]

{"sheet":"Hygro A","index":2,"n_rows":13,"n_cols":9,"rows_kept":13,"cut":false,"hidden":true,"merged":[[0,1,0,2],[0,3,0,8]]}
["Type","Modules d'entrées d'air",null,"Bouches d'extraction"]
[null,"Séjour","Par chambre","Cuisine","SbB 1","SbB 2","WC unique","WC multiple","Salle d'eau"]
["F1 (WC commun avec SbB)","2 x 30","Non applicable","6-40/90",{"$f":"\"10-40\"","v":"10-40"},"Non applicable","Non applicable","Non applicable",{"$f":"\"5-40\"","v":"5-40"}]
["F1 (WC séparé)","2 x 30","Non applicable","6-40/90",{"$f":"\"5-40\"","v":"5-40"},"Non applicable",{"$f":"\"5/30\"","v":"5/30"},{"$f":"\"5/30\"","v":"5/30"},"5-40"]
["F2 (WC commun avec SdB)",22,45,"6-40/90","10-45","Non applicable","Non applicable","Non applicable","5-40"]
["F2 (WC séparé)",22,45,"6-40/90",{"$f":"\"5-45\"","v":"5-45"},"Non applicable",{"$f":"\"5/30\"","v":"5/30"},{"$f":"\"5/30\"","v":"5/30"},"5-40"]
["F3 (WC commun avec SdB)",45,30,"10-45/135",{"$f":"\"10-45/45\"","v":"10-45/45"},"Non applicable","Non applicable","Non applicable","5-40"]
["F3",45,30,"10-45/135","10-45","Non applicable","5/30","5/30","5-40"]
["F3 Optimisé",45,30,"12-45/105","10-45","Non applicable","5/30","5/30","5-40"]
["F4",45,45,"10-45/135","10-45","Non applicable","5/30","5/30","5-40"]
["F5",45,30,"12-45/135","10-45","Non applicable","Auto 30","Auto 15","5-40"]
["F6","30 + 22",22,"12-45/135","10-45","Non applicable","Auto 30","Auto 15","5-40"]
["F7 et +",45,22,"10-45/135","10-45","Non applicable","Auto 30","Auto 15","5-40"]

{"sheet":"Hygro B","index":3,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":true,"merged":[[0,1,0,2],[0,3,0,8]]}
["Type","Modules d'entrées d'air",null,"Bouches d'extraction"]
[null,"Séjour","Par chambre","Cuisine","SbB 1","SbB 2","WC unique","WC multiple","Salle d'eau"]
["F1 (WC commun avec SbB)","2 x 30","Non applicable","6-40/90",{"$f":"\"10-40\"","v":"10-40"},"Non applicable","Non applicable","Non applicable",{"$f":"\"5-40\"","v":"5-40"}]
["F1 (WC séparé)","2 x 30","Non applicable","6-40/90",{"$f":"\"5-40\"","v":"5-40"},"Non applicable",{"$f":"\"5/30\"","v":"5/30"},"Non applicable","5-40"]
["F2 (WC commun avec SdB)",{"$f":"\"6 - 45\"","v":"6 - 45"},{"$f":"\"6 - 45\"","v":"6 - 45"},"6-40/90",{"$f":"\"10-45\"","v":"10-45"},"Non applicable","Non applicable","Non applicable","5-40"]
["F2 (WC séparé)",{"$f":"\"6 - 45\"","v":"6 - 45"},{"$f":"\"6 - 45\"","v":"6 - 45"},"6-40/90",{"$f":"\"5-45\"","v":"5-45"},"Non applicable",{"$f":"\"5/30\"","v":"5/30"},"Non applicable","5-40"]
["F3 Optimisé (WC commun avec SdB)",{"$f":"\"6 - 45 (x2)\"","v":"6 - 45 (x2)"},{"$f":"\"6 - 45\"","v":"6 - 45"},"12-45/105",{"$f":"\"10-45/45\"","v":"10-45/45"},"Non applicable","Non applicable","Non applicable","5-40"]
["F3 Optimisé (WC séparé)",{"$f":"\"6 - 45 (x2)\"","v":"6 - 45 (x2)"},"6 - 45","12-45/105",{"$f":"\"10-40\"","v":"10-40"},"Non applicable",{"$f":"\"5/30\"","v":"5/30"},"Non applicable","5-40"]
["F3 (WC commun avec SdB)",{"$f":"\"6 - 45\"","v":"6 - 45"},"6 - 45","10-45/120",{"$f":"\"10-45/45\"","v":"10-45/45"},"Non applicable","Non applicable","Non applicable","5-40"]
["F3 (WC séparé)",{"$f":"\"6 - 45\"","v":"6 - 45"},"6 - 45","10-45/120",{"$f":"\"10-40\"","v":"10-40"},"Non applicable","5/30","Non applicable","5-40"]
["F4 (WC commun avec SdB)",{"$f":"\"6 - 45\"","v":"6 - 45"},"6 - 45","10-45/120",{"$f":"\"10-45/45\"","v":"10-45/45"},"Non applicable","Non applicable","Non applicable","5-40"]
["F4 (WC séparé)",{"$f":"\"6 - 45\"","v":"6 - 45"},"6 - 45","10-45/120",{"$f":"\"10-40\"","v":"10-40"},"Non applicable","5/30","Non applicable","5-40"]
["F5 (WC commun avec SdB)",{"$f":"\"6 - 45 (x2)\"","v":"6 - 45 (x2)"},"6 - 45","10-45/135","10-45/45","Non applicable","Non applicable","Non applicable","5-40"]
["F5 (WC séparé)",{"$f":"\"6 - 45 (x2)\"","v":"6 - 45 (x2)"},"6 - 45","10-45/135",{"$f":"\"10-40\"","v":"10-40"},"Non applicable","5/30","Non applicable","5-40"]
["F6 et + (WC commun avec SdB)",{"$f":"\"6 - 45 (x2)\"","v":"6 - 45 (x2)"},"6 - 45","10-45/135","10-45/45",{"$f":"\"10-40\"","v":"10-40"},"Non applicable","Non applicable","5-40"]
["F6 et + (WC séparé)",{"$f":"\"6 - 45 (x2)\"","v":"6 - 45 (x2)"},"6 - 45","10-45/135",{"$f":"\"10-40\"","v":"10-40"},{"$f":"\"10-40\"","v":"10-40"},"5/30","Non applicable","5-40"]

{"sheet":"Feuil1","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"PdC","index":5,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":true,"merged":[[24,13,25,13],[26,13,27,13],[28,13,29,13],[30,13,31,13],[32,13,33,13],[24,14,25,14],[26,14,27,14],[28,14,29,14],[30,14,31,14],[32,14,33,14],[22,0,22,12],[0,0,0,10],[7,0,7,9],[9,0,9,10],[13,0,13,10],[18,0,18,9]]}
["PdC Pieuvre"]
["Tronçon","Gaine","Longueur","K","Q","D","PdC Linéique","Nbr coude","zéta","PdC sing","PdC tot"]
[{"$f":"'OTWH 200 EV'!C33","v":0},{"$f":"'OTWH 200 EV'!F33","v":0},{"$f":"'OTWH 200 EV'!J33","v":0},{"$f":"IF(B3=\"\",0,IF(B3=0,0,IF(B3=\"Rigide\",3000000,9000000)))","v":0},{"$f":"IF(OR(A3=\"\",A3=0),0,VLOOKUP(A3,Calcul!$A$11:$C$16,3,FALSE))","v":0},{"$f":"IF(OR(A3=\"\",A3=0),\"\",IF(A3=\"cuisine\",125,80))","v":""},{"$f":"IF(OR(A3=\"\",A3=0),0,D3*E3^1.9/F3^5*C3)","v":0},{"$f":"'OTWH 200 EV'!L33","v":0},{"$f":"IF(B3=\"Rigide\",0.29,1.22)","v":1.22},{"$f":"IF(OR(A3=\"\",A3=0),0,(H3*I3)*75000*E3^2/F3^4)","v":0},{"$f":"G3+J3","v":0},{"$f":"A3","v":0}]
[{"$f":"'OTWH 200 EV'!C35","v":0},{"$f":"'OTWH 200 EV'!F35","v":0},{"$f":"'OTWH 200 EV'!J35","v":0},{"$f":"IF(B4=\"\",0,IF(B4=0,0,IF(B4=\"Rigide\",3000000,9000000)))","v":0},{"$f":"IF(OR(A4=\"\",A4=0),0,VLOOKUP(A4,Calcul!$A$11:$C$16,3,FALSE))","v":0},{"$f":"IF(OR(A4=\"\",A4=0),\"\",IF(A4=\"cuisine\",125,80))","v":""},{"$f":"IF(OR(A4=\"\",A4=0),0,D4*E4^1.9/F4^5*C4)","v":0},{"$f":"'OTWH 200 EV'!L35","v":0},{"$f":"IF(B4=\"Rigide\",0.29,1.22)","v":1.22},{"$f":"IF(OR(A4=\"\",A4=0),0,(H4*I4)*75000*E4^2/F4^4)","v":0},{"$f":"G4+J4","v":0},{"$f":"A4","v":0},null,"PdC aval ballon"]
[{"$f":"'OTWH 200 EV'!C37","v":""},{"$f":"'OTWH 200 EV'!F37","v":0},{"$f":"'OTWH 200 EV'!J37","v":0},{"$f":"IF(B5=\"\",0,IF(B5=0,0,IF(B5=\"Rigide\",3000000,9000000)))","v":0},{"$f":"IF(OR(A5=\"\",A5=0),0,VLOOKUP(A5,Calcul!$A$11:$C$16,3,FALSE))","v":0},{"$f":"IF(OR(A5=\"\",A5=0),\"\",IF(A5=\"cuisine\",125,80))","v":""},{"$f":"IF(OR(A5=\"\",A5=0),0,D5*E5^1.9/F5^5*C5)","v":0},{"$f":"'OTWH 200 EV'!L37","v":0},1.22,{"$f":"IF(OR(A5=\"\",A5=0),0,(H5*I5)*75000*E5^2/F5^4)","v":0},{"$f":"G5+J5","v":0},{"$f":"A5","v":""},null,{"$f":"IF('OTWH 200 EV'!F21=\"Linéaire\",PdC!M36,IF('OTWH 200 EV'!F21=\"Multipiquage\",PdC!K20,PdC!K11))","v":0}]
[{"$f":"'OTWH 200 EV'!C39","v":""},{"$f":"'OTWH 200 EV'!F39","v":"Souple"},{"$f":"'OTWH 200 EV'!J39","v":0},{"$f":"IF(B6=\"\",0,IF(B6=0,0,IF(B6=\"Rigide\",3000000,9000000)))","v":9000000},{"$f":"IF(OR(A6=\"\",A6=0),0,VLOOKUP(A6,Calcul!$A$11:$C$16,3,FALSE))","v":0},{"$f":"IF(OR(A6=\"\",A6=0),\"\",IF(A6=\"cuisine\",125,80))","v":""},{"$f":"IF(OR(A6=\"\",A6=0),0,D6*E6^1.9/F6^5*C6)","v":0},{"$f":"'OTWH 200 EV'!L39","v":0},1.22,{"$f":"IF(OR(A6=\"\",A6=0),0,(H6*I6)*75000*E6^2/F6^4)","v":0},{"$f":"G6+J6","v":0},{"$f":"A6","v":""}]
[{"$f":"'OTWH 200 EV'!C41","v":0},{"$f":"'OTWH 200 EV'!F41","v":0},{"$f":"'OTWH 200 EV'!J41","v":0},{"$f":"IF(B7=\"\",0,IF(B7=0,0,IF(B7=\"Rigide\",3000000,9000000)))","v":0},{"$f":"IF(OR(A7=\"\",A7=0),0,VLOOKUP(A7,Calcul!$A$11:$C$16,3,FALSE))","v":0},{"$f":"IF(OR(A7=\"\",A7=0),\"\",IF(A7=\"cuisine\",125,80))","v":""},{"$f":"IF(OR(A7=\"\",A7=0),0,D7*E7^1.9/F7^5*C7)","v":0},{"$f":"'OTWH 200 EV'!L41","v":0},1.22,{"$f":"IF(OR(A7=\"\",A7=0),0,(H7*I7)*75000*E7^2/F7^4)","v":0},{"$f":"G7+J7","v":0},{"$f":"A7","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(K3:K7)","v":0},{"$f":"VLOOKUP(K8,K3:L7,2,FALSE)","v":0}]
["Aval caisson",{"$f":"'OTWH 200 EV'!F92","v":"Rigide"},{"$f":"'OTWH 200 EV'!J92","v":8},{"$f":"IF(B9=\"Rigide\",3000000,9000000)","v":3000000},{"$f":"SUM(E3:E7)","v":0},{"$f":"'OTWH 200 EV'!H92","v":160},{"$f":"D9*E9^1.9/F9^5*C9","v":0},{"$f":"'OTWH 200 EV'!L92","v":1},{"$f":"IF(B9=\"Rigide\",0.35,1.28)","v":0.35},{"$f":"(H9*I9)*75000*E9^2/F9^4","v":0},{"$f":"G9+J9","v":0}]
[]
["Aval ballon",{"$f":"'OTWH 200 EV'!F102","v":0},{"$f":"'OTWH 200 EV'!J102","v":0},{"$f":"IF(B11=\"Rigide\",3000000,9000000)","v":9000000},{"$f":"E9","v":0},{"$f":"'OTWH 200 EV'!H102","v":160},{"$f":"D11*E11^1.9/F11^5*C11","v":0},{"$f":"'OTWH 200 EV'!L102","v":0},1.22,{"$f":"(H11*I11)*75000*E11^2/F11^4","v":0},{"$f":"G11+J11","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"-0.00000003677*POWER(E11,4)+0.00001154422*POWER(E11,3)-0.000629507747*POWER(E11,2)-0.279286840456*E11+291.152612094602","v":291.15261209460198}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('OTWH 200 EV'!F21=\"Pieuvre (caisson)\",PdC!L8,IF('OTWH 200 EV'!F21=\"Multipiquage\",PdC!L19,IF('OTWH 200 EV'!F21=\"Linéaire\",O35,\"\")))","v":0}]
["PdC Multipiquage"]
["Tronçon","Gaine","Longueur","K","Q","D","PdC Linéique","Nbr coude","zéta","PdC sing","PdC tot"]
[{"$f":"'OTWH 200 EV'!C33","v":0},{"$f":"'OTWH 200 EV'!F33","v":0},{"$f":"'OTWH 200 EV'!J33","v":0},{"$f":"IF(B16=\"Rigide\",3000000,9000000)","v":9000000},{"$f":"IF(OR(A16=\"\",A16=0),0,VLOOKUP(A16,Calcul!$A$11:$C$16,3,FALSE))","v":0},{"$f":"IF(OR(A16=\"\",A16=0),\"\",IF(A16=\"cuisine\",125,80))","v":""},{"$f":"IF(OR(A16=\"\",A16=0),0,D16*E16^1.9/F16^5*C16)","v":0},{"$f":"'OTWH 200 EV'!L33","v":0},{"$f":"IF(B16=\"Rigide\",0.29,1.22)","v":1.22},{"$f":"IF(OR(A16=\"\",A16=0),0,IF(F16=125,((H16*I16)+0.06)*75000*E16^2/F16^4,(H16*I16)*75000*E16^2/F16^4))","v":0},{"$f":"G16+J16","v":0},{"$f":"A16","v":0}]
[{"$f":"'OTWH 200 EV'!C35","v":0},{"$f":"'OTWH 200 EV'!F35","v":0},{"$f":"'OTWH 200 EV'!J35","v":0},{"$f":"IF(B17=\"Rigide\",3000000,9000000)","v":9000000},{"$f":"IF(OR(A17=\"\",A17=0),0,VLOOKUP(A17,Calcul!$A$11:$C$16,3,FALSE))","v":0},{"$f":"IF(OR(A17=\"\",A17=0),\"\",IF(A17=\"cuisine\",125,80))","v":""},{"$f":"IF(OR(A17=\"\",A17=0),0,D17*E17^1.9/F17^5*C17)","v":0},{"$f":"'OTWH 200 EV'!L35","v":0},{"$f":"IF(B17=\"Rigide\",0.29,1.22)","v":1.22},{"$f":"IF(OR(A17=\"\",A17=0),0,IF(F17=125,((H17*I17)+0.06)*75000*E17^2/F17^4,(H17*I17)*75000*E17^2/F17^4))","v":0},{"$f":"G17+J17","v":0},{"$f":"A17","v":0}]
[{"$f":"'OTWH 200 EV'!C37","v":""},{"$f":"'OTWH 200 EV'!F37","v":0},{"$f":"'OTWH 200 EV'!J37","v":0},{"$f":"IF(B18=\"Rigide\",3000000,9000000)","v":9000000},{"$f":"IF(OR(A18=\"\",A18=0),0,VLOOKUP(A18,Calcul!$A$11:$C$16,3,FALSE))","v":0},{"$f":"IF(OR(A18=\"\",A18=0),\"\",IF(A18=\"cuisine\",125,80))","v":""},{"$f":"IF(OR(A18=\"\",A18=0),0,D18*E18^1.9/F18^5*C18)","v":0},{"$f":"'OTWH 200 EV'!L37","v":0},{"$f":"IF(B18=\"Rigide\",0.29,1.22)","v":1.22},{"$f":"IF(OR(A18=\"\",A18=0),0,IF(F18=125,((H18*I18)+0.06)*75000*E18^2/F18^4,(H18*I18)*75000*E18^2/F18^4))","v":0},{"$f":"G18+J18","v":0},{"$f":"A18","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"MAX(K16:K18)","v":0},{"$f":"VLOOKUP(K19,K16:L18,2,FALSE)","v":0}]
["Aval ballon",{"$f":"'OTWH 200 EV'!F102","v":0},{"$f":"'OTWH 200 EV'!J102","v":0},{"$f":"IF(B20=\"Rigide\",3000000,9000000)","v":9000000},{"$f":"SUM(E16:E18)","v":0},{"$f":"'OTWH 200 EV'!H102","v":160},{"$f":"D20*E20^1.9/F20^5*C20","v":0},{"$f":"'OTWH 200 EV'!L102","v":0},{"$f":"IF(B20=\"Rigide\",0.29,1.22)","v":1.22},{"$f":"(H20*I20)*75000*E20^2/F20^4","v":0},{"$f":"G20+J20","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"-0.00000003677*POWER(E20,4)+0.00001154422*POWER(E20,3)-0.000629507747*POWER(E20,2)-0.279286840456*E20+291.152612094602","v":291.15261209460198}]
[]
["PdC Linéaire"]
["Tronçon","Gaine","Longueur","K","Q","D","PdC Linéique","Nbr coude","Nbr tés","Réductions","zéta","PdC sing","PdC tot"]
[{"$f":"'OTWH 200 EV'!C61","v":"WC unique"},{"$f":"'OTWH 200 EV'!F61","v":"Rigide"},{"$f":"'OTWH 200 EV'!J61","v":3},{"$f":"IF(B25=\"\",0,IF(B25=0,0,IF(B25=\"Rigide\",3000000,9000000)))","v":3000000},{"$f":"IF(OR(A25=\"\",A25=0),0,VLOOKUP(A25,Calcul!$A$11:$C$16,3,FALSE))","v":0},{"$f":"'OTWH 200 EV'!H61","v":80},{"$f":"IF(OR(A25=\"\",A25=0,F25=0,F25=\"\"),0,D25*E25^1.9/F25^5*C25)","v":0},{"$f":"'OTWH 200 EV'!L61","v":1},0,{"$f":"IF(F27>F25,1,0)","v":0},{"$f":"IF(B25=\"Rigide\",H25*0.29,H25*1.22)+0.06*J25","v":0.28999999999999998},{"$f":"IF(OR(A25=\"\",A25=0,F25=0,F25=\"\"),0,K25*75000*E25^2/F25^4)","v":0},{"$f":"G25+L25","v":0},{"$f":"M25+M26+M27+M29+M31+M33","v":5.1399514481750161},{"$f":"A25","v":"WC unique"}]
[null,{"$f":"'OTWH 200 EV'!F63","v":0},{"$f":"'OTWH 200 EV'!J63","v":0},0,{"$f":"IF(OR(A25=\"\",A25=0),0,VLOOKUP(A25,Calcul!$A$11:$C$16,3,FALSE))","v":0},{"$f":"IF(OR(A25=\"\",A25=0),\"\",IF(A25=\"cuisine\",125,80))","v":80},{"$f":"IF(OR(A25=\"\",A25=0,F26=0,F26=\"\"),0,D26*E26^1.9/F26^5*C26)","v":0},{"$f":"'OTWH 200 EV'!L63","v":0},0,{"$f":"IF(F26<F25,1,0)","v":0},0,{"$f":"IF(OR(A25=\"\",A25=0,F26=0,F26=\"\"),0,(K26*75000*E26^2/F26^4)+L40)","v":0},0]
[{"$f":"'OTWH 200 EV'!C65","v":"Salle de bain"},{"$f":"'OTWH 200 EV'!F65","v":"Rigide"},{"$f":"'OTWH 200 EV'!J65","v":2},3000000,{"$f":"IF(OR(A27=\"\",A27=0),0+E25,VLOOKUP(A27,Calcul!$A$11:$C$16,3,FALSE)+E25)","v":40},{"$f":"'OTWH 200 EV'!H65","v":80},{"$f":"IF(OR(A27=\"\",A27=0,F27=0,F27=\"\"),0,D27*E27^1.9/F27^5*C27)","v":2.0258873794372239},{"$f":"'OTWH 200 EV'!L65","v":0},0,{"$f":"IF(F29>F27,1,0)","v":1},0.06,{"$f":"IF(OR(A27=\"\",A27=0,F27=0,F27=\"\"),0,K27*75000*E27^2/F27^4)","v":0.17578125},2.2016686294372239,{"$f":"M33+M31+M29+M28+M27","v":18.065038405642525},{"$f":"A27","v":"Salle de bain"}]
[null,{"$f":"'OTWH 200 EV'!F67","v":"Souple"},{"$f":"'OTWH 200 EV'!J67","v":3},9000000,{"$f":"IF(OR(A27=\"\",A27=0),0,VLOOKUP(A27,Calcul!$A$11:$C$16,3,FALSE))","v":40},{"$f":"IF(OR(A27=\"\",A27=0),\"\",IF(A27=\"cuisine\",125,80))","v":80},{"$f":"IF(OR(A27=\"\",A27=0,F28=0,F28=\"\"),0,D28*E28^1.9/F28^5*C28)","v":9.1164932074675082},{"$f":"'OTWH 200 EV'!L67","v":0},{"$f":"IF(OR(A27=\"\",A27=0),0,1)","v":1},{"$f":"IF(AND(F28=80,F27=160),1,0)","v":0},0,{"$f":"IF(OR(A27=\"\",A27=0,F28=0,F28=\"\"),0,(K28*75000*E28^2/F28^4)+L41)","v":3.80859375},12.925086957467508]
[{"$f":"'OTWH 200 EV'!C69","v":"Cuisine"},{"$f":"'OTWH 200 EV'!F69","v":"Rigide"},{"$f":"'OTWH 200 EV'!J69","v":8},3000000,{"$f":"IF(OR(A29=\"\",A29=0),0+E27,VLOOKUP(A29,Calcul!$A$11:$C$16,3,FALSE)+E27)","v":130},{"$f":"'OTWH 200 EV'!H69","v":160},{"$f":"IF(OR(A29=\"\",A29=0,F29=0,F29=\"\"),0,D29*E29^1.9/F29^5*C29)","v":2.3774078797729485},{"$f":"'OTWH 200 EV'!L69","v":1},0,{"$f":"IF(F31>F29,1,0)","v":0},0.28999999999999998,{"$f":"IF(OR(A29=\"\",A29=0,F29=0,F29=\"\"),0,K29*75000*E29^2/F29^4)","v":0.56087493896484375},2.9382828187377923,{"$f":"M33+M31+M30+M29","v":5.6665326423936486},{"$f":"A29","v":"Cuisine"}]
[null,{"$f":"'OTWH 200 EV'!F71","v":"Souple"},{"$f":"'OTWH 200 EV'!J71","v":1},9000000,{"$f":"IF(OR(A29=\"\",A29=0),0,VLOOKUP(A29,Calcul!$A$11:$C$16,3,FALSE))","v":90},{"$f":"IF(OR(A29=\"\",A29=0),\"\",IF(A29=\"cuisine\",125,80))","v":125},{"$f":"IF(OR(A29=\"\",A29=0,F30=0,F30=\"\"),0,D30*E30^1.9/F30^5*C30)","v":1.5231869574449188},{"$f":"'OTWH 200 EV'!L71","v":0},{"$f":"IF(OR(A29=\"\",A29=0),0,1)","v":1},{"$f":"IF(AND(F30=80,F29=160),1,0)","v":0},0,{"$f":"IF(OR(A29=\"\",A29=0,F30=0,F30=\"\"),0,(K30*75000*E30^2/F30^4)+L42)","v":1.2050628662109375},2.7282498236558563]
[{"$f":"'OTWH 200 EV'!C73","v":0},{"$f":"'OTWH 200 EV'!F73","v":0},{"$f":"'OTWH 200 EV'!J73","v":0},0,{"$f":"IF(OR(A31=\"\",A31=0),0+E29,VLOOKUP(A31,Calcul!$A$11:$C$16,3,FALSE)+E29)","v":130},{"$f":"'OTWH 200 EV'!H73","v":0},{"$f":"IF(OR(A31=\"\",A31=0),0,D31*E31^1.9/F31^5*C31)","v":0},{"$f":"'OTWH 200 EV'!L73","v":0},0,{"$f":"IF(F33>F31,1,0)","v":0},0,{"$f":"IF(OR(A31=\"\",A31=0,F31=0,F31=\"\"),0,K31*75000*E31^2/F31^4)","v":0},0,{"$f":"M33+M32+M31","v":0},{"$f":"A31","v":0}]
[null,{"$f":"'OTWH 200 EV'!F75","v":0},{"$f":"'OTWH 200 EV'!J75","v":0},0,{"$f":"IF(OR(A31=\"\",A31=0),0,VLOOKUP(A31,Calcul!$A$11:$C$16,3,FALSE))","v":0},{"$f":"IF(OR(A31=\"\",A31=0),\"\",IF(A31=\"cuisine\",125,80))","v":""},{"$f":"IF(OR(A31=\"\",A31=0),0,D32*E32^1.9/F32^5*C32)","v":0},{"$f":"'OTWH 200 EV'!L75","v":0},{"$f":"IF(OR(A31=\"\",A31=0),0,1)","v":0},{"$f":"IF(AND(F32=80,F31=160),1,0)","v":0},0,{"$f":"IF(OR(A31=\"\",A31=0,F32=0,F32=\"\"),0,(K32*75000*E32^2/F32^4)+L43)","v":0},0]
[{"$f":"'OTWH 200 EV'!C77","v":0},{"$f":"'OTWH 200 EV'!F77","v":0},{"$f":"'OTWH 200 EV'!J77","v":0},0,{"$f":"IF(OR(A33=\"\",A33=0),0+E31,VLOOKUP(A33,Calcul!$A$11:$C$16,3,FALSE)+E31)","v":130},{"$f":"'OTWH 200 EV'!H77","v":0},{"$f":"IF(OR(A33=\"\",A33=0),0,D33*E33^1.9/F33^5*C33)","v":0},{"$f":"'OTWH 200 EV'!L77","v":0},0,0,0,{"$f":"IF(OR(A33=\"\",A33=0,F33=0,F33=\"\"),0,K33*75000*E33^2/F33^4)","v":0},0,{"$f":"M34+M33","v":0},{"$f":"A33","v":0}]
[null,{"$f":"'OTWH 200 EV'!F79","v":0},{"$f":"'OTWH 200 EV'!J79","v":0},0,{"$f":"IF(OR(A33=\"\",A33=0),0,VLOOKUP(A33,Calcul!$A$11:$C$16,3,FALSE))","v":0},{"$f":"IF(OR(A33=\"\",A33=0),\"\",IF(A33=\"cuisine\",125,80))","v":""},{"$f":"IF(OR(A33=\"\",A33=0),0,D34*E34^1.9/F34^5*C34)","v":0},{"$f":"'OTWH 200 EV'!L79","v":0},{"$f":"IF(OR(A33=\"\",A33=0),0,1)","v":0},{"$f":"IF(AND(F34=80,F33=160),1,0)","v":0},0,{"$f":"IF(OR(A33=\"\",A33=0,F34=0,F34=\"\"),0,(K34*75000*E34^2/F34^4)+L44)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(M25:M34)+L46","v":20.793288229298383},{"$f":"MAX(N25:N34)","v":18.065038405642525},{"$f":"IF(N35=0,\"-\",VLOOKUP(N35,N25:O34,2,FALSE))","v":"Salle de bain"}]
["Aval ballon",{"$f":"'OTWH 200 EV'!F102","v":0},{"$f":"'OTWH 200 EV'!J102","v":0},{"$f":"IF(B36=\"\",0,IF(B36=0,0,IF(B36=\"Rigide\",3000000,9000000)))","v":0},{"$f":"E33","v":130},{"$f":"'OTWH 200 EV'!H102","v":160},{"$f":"D36*E36^1.9/F36^5*C36","v":0},{"$f":"'OTWH 200 EV'!L102","v":0},null,null,{"$f":"IF(OR(B36=0,B36=\"\"),0,IF(B36=\"Rigide\",0.29,1.22))","v":0},{"$f":"(H36*K36)*75000*E36^2/F36^4","v":0},{"$f":"G36+L36","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"-0.00000003677*POWER(E36,4)+0.00001154422*POWER(E36,3)-0.000629507747*POWER(E36,2)-0.279286840456*E36+291.152612094602","v":259.06741355102196}]
[]
[null,null,null,null,null,null,null,null,"zéta té","Q","D","PdC"]
[{"$f":"IF('OTWH 200 EV'!F21=\"Multipiquage\",IF('OTWH 200 EV'!N112<PdC!K21,CONCATENATE(\"Configuration conforme (valeur limite : \",ROUND(K21,1),\" Pa)\"),CONCATENATE(\"Configuration non conforme (valeur limite : \",ROUND(K21,1),\" Pa)\")),IF('OTWH 200 EV'!F21=\"Pieuvre (caisson)\",IF('OTWH 200 EV'!N112<PdC!K12,CONCATENATE(\"Configuration conforme (valeur limite : \",ROUND(K12,1),\" Pa)\"),CONCATENATE(\"Configuration non conforme (valeur limite : \",ROUND(K12,1),\" Pa)\")),IF('OTWH 200 EV'!F21=\"Linéaire\",IF('OTWH 200 EV'!N112<PdC!M37,CONCATENATE(\"Configuration conforme (valeur limite : \",ROUND(M37,1),\" Pa)\"),CONCATENATE(\"Configuration non conforme (valeur limite : \",ROUND(M37,1),\" Pa)\")))))","v":"Configuration non conforme (valeur limite : 291,2 Pa)"},null,null,null,null,null,null,{"$f":"A25","v":"WC unique"},{"$f":"I26*1.3","v":0},{"$f":"E26","v":0},{"$f":"F25","v":80},{"$f":"I40*75000*J40^2/K40^4","v":0}]
[null,null,null,null,null,null,null,{"$f":"A27","v":"Salle de bain"},{"$f":"I28*1.3","v":1.3},{"$f":"E28","v":40},{"$f":"F27","v":80},{"$f":"I41*75000*J41^2/K41^4","v":3.80859375}]
[{"$f":"IF('OTWH 200 EV'!F21=\"Multipiquage\",IF('OTWH 200 EV'!N112<PdC!K21,\"Configuration conforme\",\"Configuration non conforme\"),IF('OTWH 200 EV'!F21=\"Pieuvre (caisson)\",IF('OTWH 200 EV'!N112<PdC!K12,\"Configuration conforme\",\"Configuration non conforme\"),IF('OTWH 200 EV'!F21=\"Linéaire\",IF('OTWH 200 EV'!N112<PdC!M37,\"Configuration conforme\",\"Configuration non conforme\"))))","v":"Configuration non conforme"},null,null,null,null,null,null,{"$f":"A29","v":"Cuisine"},{"$f":"I30*1.3","v":1.3},{"$f":"E30","v":90},{"$f":"F29","v":160},{"$f":"I42*75000*J42^2/K42^4","v":1.2050628662109375}]
[null,null,null,null,null,null,null,{"$f":"A31","v":0},{"$f":"I32*1.3","v":0},{"$f":"E32","v":0},{"$f":"F31","v":0},{"$f":"IF(OR(H43=0,H43=\"\"),0,I43*75000*J43^2/K43^4)","v":0}]
[null,null,null,null,null,null,null,{"$f":"A33","v":0},{"$f":"I34*1.3","v":0},{"$f":"E34","v":0},{"$f":"F33","v":0},{"$f":"IF(OR(H44=0,H44=\"\"),0,I44*75000*J44^2/K44^4)","v":0}]
[]
[null,null,null,null,null,null,"réduction TWH",{"$f":"IF(OR(F25=160,F27=160,F29=160,F31=160,F33=160),0,1)","v":0},{"$f":"H46*0.06","v":0},{"$f":"E33","v":130},125,{"$f":"I46*75000*J46^2/K46^4","v":0}]

{"sheet":"Images","index":6,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}