{"text_format":"3","workbook":"xlsx","n_sheets":10,"sheets":["¿","Consumos TIPO","Tramos AF","Grupo AF","Propiedades agua","Tramos ACS","Retorno ACS","Tablas","RESUMEN","Graficos"],"not_rendered":{"charts":1,"images":21,"macros":1,"defined_names":19,"comments":4},"read":"whole","date_system":"1900"}

{"sheet":"¿","index":0,"n_rows":12,"n_cols":12,"rows_kept":12,"merged":[[3,10,7,13],[8,10,8,13],[10,10,10,13],[11,10,11,13]]}
[]
[null,"CTE HS4 SUMINISTRO DE AGUA ",{"$nulls":3},"Calculo de redes de distribución de agua fria y caliente",{"$nulls":5},"Versión v.3.1  Diciembre 2019"]
[]
[null,"Tan solo es necesario introducir datos en las casillas en color blanco.",{"$nulls":8},"Nota: La presente aplicación se proporciona bajo una licencia Creative Commons \"tal cual\", sin garantías implícitas o explícitas. Bajo ninguna circunstancia el autor se responsabiliza de su uso. "]
[null,"El resto de celdas indican los resultados de calculo"]
[]
[]
[]
[{"$nulls":10},"Actualizaciones y otras herramientas:"]
[]
[{"$nulls":10},"  Autor: Oscar Redondo Rivera   "]
[{"$nulls":10},"o.redondo.rivera@gmail.com"]

{"sheet":"Consumos TIPO","index":1,"n_rows":48,"n_cols":27,"rows_kept":48,"merged":[[2,10,2,13],[6,1,6,2],[6,10,6,11],[6,15,6,16],[6,20,6,21],[7,1,7,2],[7,7,7,8],[8,1,8,2],[8,7,8,8],[9,1,9,2],[9,7,9,8],[10,1,10,2],[10,7,10,8],[11,1,11,2],[11,7,11,8],[12,1,12,2],[12,7,12,8],[13,1,13,2],[17,3,17,5],[17,9,17,11],[17,14,17,16],[17,19,17,21],[17,24,17,26],[18,3,18,5],[18,9,18,11],[18,14,18,16],[18,19,18,21],[18,24,18,26],[36,2,36,3],[36,8,36,9],[36,13,36,14],[36,18,36,19],[36,23,36,24],[38,2,38,3],[38,8,38,9],[38,13,38,14],[38,18,38,19],[38,23,38,24],[39,2,39,3],[39,8,39,9],[39,13,39,14],[39,18,39,19],[39,23,39,24]]}
[]
[{"$nulls":8},"Actualizaciones y otras herramientas en:"]
[null,"CTE HS4  SUMINISTRO DE AGUA",{"$nulls":7},"Autor:","Oscar Redondo Rivera  o.redondo.rivera@gmail.com"]
[]
[null,null,"1.- DATOS GENERALES",{"$nulls":4},"SUMINISTRO DE AGUA FRIA",{"$nulls":11},"SUMINISTRO ACS"]
[]
[null,"Tipo edificio",null,"Viviendas",{"$nulls":6},"Q Total AF",{"$nulls":4},"Q adicional AF",{"$nulls":4},"Q total ACS"]
[null,"Temp. AF",null,{"v":10,"d":"10 ºC"},{"$nulls":3},"Uds suministro",null,"Descripcion","Uds","Q (l/s)",null,"Uds","Otros usos","Q (l/s)","Q (l/s)","D(mm)",null,null,"Uds","Q (l/s)"]
[null,"Temp ACS",null,{"v":50,"d":"50 ºC"},null,{"$f":"IF(((19+K14)/(10*(1+K14)))<0.2,0.2,((19+K14)/(10*(1+K14))))","v":{"v":0.2,"d":"0.20"}},null,{"$f":"D18","v":"VIVIENDA TIPO A"},null,{"$f":"D19","v":"Cocina + 2 baños (ducha + bañera)"},20,{"$f":"K9*E36","v":{"v":33,"d":"33.00"}},null,1,"Basuras + Baldeo",{"v":0.2,"d":"0.20"},{"$f":"N9*P9","v":{"v":0.2,"d":"0.20"}},{"$f":"IF(X9<13.1,16,IF($C$46=\"Cobre\",INDEX(Tablas!$B$137:$B$146,MATCH(X9,Tablas!$C$137:$C$146,1)+1,1),INDEX(Tablas!$S$98:$S$111,MATCH(X9,Tablas!$R$98:$R$111,1)+1,1)))","v":16},null,{"$f":"H9","v":"VIVIENDA TIPO A"},2,{"$f":"F36*K9","v":{"v":18.2,"d":"18.20"}},null,{"$f":"(4000*P9/(3.1416*$D$11))^0.5","v":{"v":9.213166547046368,"d":"9.21"}},{"$f":"IF($C$46=\"Cobre\",VLOOKUP($R$9,Tablas!$B$137:$C$146,2,FALSE),INDEX(Tablas!$R$98:$R$111,MATCH(IF(X9<13,13,X9),Tablas!$R$98:$R$111,1)+1,1))","v":13.1},{"$f":"4000*P9/(3.1416*Y9*Y9)","v":1.483872230469337}]
[null,"Simultaneidad",null,"UNE 149.201/07",null,{"$f":"IF((L14+Q14)<20,0.682*((L14+Q14)^0.45)-0.14,1.7*((L14+Q14)^0.21)-0.7)/(L14+Q14)","v":{"v":0.06496329435222663,"d":"0.06"}},null,{"$f":"J18","v":"VIVIENDA TIPO B"},null,{"$f":"J19","v":"Duplex Cocina + 3 baños (2xducha + bañera)"},5,{"$f":"K10*K36","v":9.25},null,1,"Riego",{"v":1,"d":"1.00"},{"$f":"N10*P10","v":{"v":1,"d":"1.00"}},{"$f":"IF(X10<13.1,16,IF($C$46=\"Cobre\",INDEX(Tablas!$B$137:$B$146,MATCH(X10,Tablas!$C$137:$C$146,1)+1,1),INDEX(Tablas!$S$98:$S$111,MATCH(X10,Tablas!$R$98:$R$111,1)+1,1)))","v":32},null,{"$f":"H10","v":"VIVIENDA TIPO B"},4,{"$f":"L36*K10","v":5.05},null,{"$f":"(4000*P10/(3.1416*$D$11))^0.5","v":{"v":20.601266687222694,"d":"20.60"}},{"$f":"IF($C$46=\"Cobre\",VLOOKUP($R$9,Tablas!$B$137:$C$146,2,FALSE),INDEX(Tablas!$R$98:$R$111,MATCH(IF(X10<13,13,X10),Tablas!$R$98:$R$111,1)+1,1))","v":26.2},{"$f":"4000*P10/(3.1416*Y10*Y10)","v":1.8548402880866712}]
[null,"Vel. Int viv",null,{"v":3,"d":"3.00 m/s"},{"$f":"IF(D12<>Tablas!$B$87,\"\",(IF(D12=Tablas!$B$87,IF('Consumos TIPO'!D11>2,\"Revisar\",\"\"))))","v":""},{"$f":"IF(((19+K14)/(10*(1+K14)))<0.2,0.2,((19+K14)/(10*(1+K14))))","v":{"v":0.2,"d":"0.20"}},null,{"$f":"O18","v":"VIVIENDA TIPO C"},null,{"$f":"O19","v":"Cocina + 2 baños (ducha + bañera) + aseo"},0,{"$f":"K11*P36","v":{"v":0,"d":"0.00"}},null,1,"Sala Solar",{"$f":"D14*1.1","v":{"v":2.850682371881723,"d":"2.85"}},{"$f":"N11*P11","v":{"v":2.850682371881723,"d":"2.85"}},{"$f":"IF(X11<13.1,16,IF($C$46=\"Cobre\",INDEX(Tablas!$B$137:$B$146,MATCH(X11,Tablas!$C$137:$C$146,1)+1,1),INDEX(Tablas!$S$98:$S$111,MATCH(X11,Tablas!$R$98:$R$111,1)+1,1)))","v":50},null,{"$f":"H11","v":"VIVIENDA TIPO C"},38,{"$f":"Q36*K11","v":{"v":0,"d":"0.00"}},null,{"$f":"(4000*P11/(3.1416*$D$11))^0.5","v":{"v":34.783104317047645,"d":"34.78"}},{"$f":"IF($C$46=\"Cobre\",VLOOKUP($R$9,Tablas!$B$137:$C$146,2,FALSE),INDEX(Tablas!$R$98:$R$111,MATCH(IF(X11<13,13,X11),Tablas!$R$98:$R$111,1)+1,1))","v":40.9},{"$f":"4000*P11/(3.1416*Y11*Y11)","v":2.1697580943393784}]
[null,"Tuberia INTERIOR",null,"serie 5","Ke",{"$f":"IF((SUM(V9:V13))<20,0.682*((SUM(V9:V13))^0.45)-0.14,1.7*((SUM(V9:V13))^0.21)-0.7)/(SUM(V9:V13))","v":{"v":0.11146363135412406,"d":"0.11"}},null,{"$f":"T18","v":"VIVIENDA TIPO D"},null,{"$f":"T19","v":"Cocina + 3 baños (2 duchas + bañera)"},0,{"$f":"K12*U36","v":{"v":0,"d":"0.00"}},null,1,"Piscina",{"v":2,"d":"2.00"},{"$f":"N12*P12","v":{"v":2,"d":"2.00"}},{"$f":"IF(X12<13.1,16,IF($C$46=\"Cobre\",INDEX(Tablas!$B$137:$B$146,MATCH(X12,Tablas!$C$137:$C$146,1)+1,1),INDEX(Tablas!$S$98:$S$111,MATCH(X12,Tablas!$R$98:$R$111,1)+1,1)))","v":40},null,{"$f":"H12","v":"VIVIENDA TIPO D"},5,{"$f":"V36*K12","v":{"v":0,"d":"0.00"}},null,{"$f":"(4000*P12/(3.1416*$D$11))^0.5","v":{"v":29.134590751135377,"d":"29.13"}},{"$f":"IF($C$46=\"Cobre\",VLOOKUP($R$9,Tablas!$B$137:$C$146,2,FALSE),INDEX(Tablas!$R$98:$R$111,MATCH(IF(X12<13,13,X12),Tablas!$R$98:$R$111,1)+1,1))","v":32.7},{"$f":"4000*P12/(3.1416*Y12*Y12)","v":2.381461656527629}]
[null,"Q simul AF",null,{"$f":"(L14+Q14)*E13","v":{"v":3.137771446337956,"d":"3.14 l/s"}},{"$f":"IF(D10=\"UNE 149.201/07\",F10,F9)","v":{"v":0.06496329435222663,"d":"0.06"}},null,null,{"$f":"Y18","v":"VIVIENDA TIPO E"},null,{"$f":"Y19","v":"Cocina + 1 baño"},0,{"$f":"K13*Z36","v":{"v":0,"d":"0.00"}},null,0,"Vestuarios",{"v":0,"d":"0.00"},{"$f":"N13*P13","v":{"v":0,"d":"0.00"}},{"$f":"IF(X13<13.1,16,IF($C$46=\"Cobre\",INDEX(Tablas!$B$137:$B$146,MATCH(X13,Tablas!$C$137:$C$146,1)+1,1),INDEX(Tablas!$S$98:$S$111,MATCH(X13,Tablas!$R$98:$R$111,1)+1,1)))","v":16},null,{"$f":"H13","v":"VIVIENDA TIPO E"},5,{"$f":"AA36*K13","v":{"v":0,"d":"0.00"}},null,{"$f":"(4000*P13/(3.1416*$D$11))^0.5","v":{"v":0,"d":"0.00"}},{"$f":"IF($C$46=\"Cobre\",VLOOKUP($R$9,Tablas!$B$137:$C$146,2,FALSE),INDEX(Tablas!$R$98:$R$111,MATCH(IF(X13<13,13,X13),Tablas!$R$98:$R$111,1)+1,1))","v":13.1},{"$f":"4000*P13/(3.1416*Y13*Y13)","v":0}]
[null,"Q simul ACS",null,{"$f":"SUM(V9:V13)*E14","v":{"v":2.5915294289833843,"d":"2.59 l/s"}},{"$f":"IF(D10=\"UNE 149.201/07\",F12,F11)","v":{"v":0.11146363135412406,"d":"0.11"}},{"$nulls":5},{"$f":"SUM(K9:K13)","v":25},{"$f":"SUM(L9:L13)","v":42.25},null,{"$f":"SUM(N9:N13)","v":4},null,{"$f":"SUM(P9:P13)","v":{"v":6.050682371881723,"d":"6.05"}},{"$f":"SUM(Q9:Q13)","v":{"v":6.050682371881723,"d":"6.05"}},{"$nulls":3},{"$f":"SUM(U9:U13)","v":54},{"$f":"SUM(V9:V13)","v":23.25}]
[]
[null,null,"2.- CONSUMOS TIPO.     Caudal instantáneo según CTE-HS4"]
[]
[{"$nulls":3},"VIVIENDA TIPO A",{"$nulls":5},"VIVIENDA TIPO B",{"$nulls":4},"VIVIENDA TIPO C",{"$nulls":4},"VIVIENDA TIPO D",{"$nulls":4},"VIVIENDA TIPO E"]
[{"$nulls":3},"Cocina + 2 baños (ducha + bañera)",{"$nulls":5},"Duplex Cocina + 3 baños (2xducha + bañera)",{"$nulls":4},"Cocina + 2 baños (ducha + bañera) + aseo",{"$nulls":4},"Cocina + 3 baños (2 duchas + bañera)",{"$nulls":4},"Cocina + 1 baño"]
[null,null,{"$f":"SUM(C21:C31)","v":{"v":11,"d":"11 Uds"}},"Tipo de aparato","Caudal AF   (dm3/s)","Caudal ACS   (dm3/s)",null,null,{"$f":"SUM(I21:I31)","v":{"v":12,"d":"12 Uds"}},"Tipo de aparato","Caudal AF   (dm3/s)","Caudal ACS   (dm3/s)",null,{"$f":"SUM(N21:N31)","v":{"v":13,"d":"13 Uds"}},"Tipo de aparato","Caudal AF   (dm3/s)","Caudal ACS   (dm3/s)",null,{"$f":"SUM(S21:S31)","v":{"v":15,"d":"15 Uds"}},"Tipo de aparato","Caudal AF   (dm3/s)","Caudal ACS   (dm3/s)",null,{"$f":"SUM(X21:X31)","v":{"v":7,"d":"7 Uds"}},"Tipo de aparato","Caudal AF   (dm3/s)","Caudal ACS   (dm3/s)"]
[null,null,1,"Ducha",{"$f":"IF(D21=\"\",0,C21*VLOOKUP(D21,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0.2,"d":"0.20"}},{"$f":"IF(D21=\"\",0,C21*VLOOKUP(D21,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0.1,"d":"0.10"}},null,null,2,"Ducha",{"$f":"IF(J21=\"\",0,I21*VLOOKUP(J21,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0.4,"d":"0.40"}},{"$f":"IF(J21=\"\",0,I21*VLOOKUP(J21,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0.2,"d":"0.20"}},null,1,"Ducha",{"$f":"IF(O21=\"\",0,N21*VLOOKUP(O21,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0.2,"d":"0.20"}},{"$f":"IF(O21=\"\",0,N21*VLOOKUP(O21,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0.1,"d":"0.10"}},null,2,"Ducha",{"$f":"IF(T21=\"\",0,S21*VLOOKUP(T21,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0.4,"d":"0.40"}},{"$f":"IF(T21=\"\",0,S21*VLOOKUP(T21,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0.2,"d":"0.20"}},null,0,"Ducha",{"$f":"IF(Y21=\"\",0,X21*VLOOKUP(Y21,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0,"d":"0.00"}},{"$f":"IF(Y21=\"\",0,X21*VLOOKUP(Y21,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0,"d":"0.00"}}]
[null,null,2,"Inodoro con cisterna",{"$f":"IF(D22=\"\",0,C22*VLOOKUP(D22,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0.2,"d":"0.20"}},{"$f":"IF(D22=\"\",0,C22*VLOOKUP(D22,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0,"d":"0.00"}},null,null,2,"Inodoro con cisterna",{"$f":"IF(J22=\"\",0,I22*VLOOKUP(J22,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0.2,"d":"0.20"}},{"$f":"IF(J22=\"\",0,I22*VLOOKUP(J22,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0,"d":"0.00"}},null,3,"Inodoro con cisterna",{"$f":"IF(O22=\"\",0,N22*VLOOKUP(O22,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0.30000000000000004,"d":"0.30"}},{"$f":"IF(O22=\"\",0,N22*VLOOKUP(O22,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0,"d":"0.00"}},null,3,"Inodoro con cisterna",{"$f":"IF(T22=\"\",0,S22*VLOOKUP(T22,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0.30000000000000004,"d":"0.30"}},{"$f":"IF(T22=\"\",0,S22*VLOOKUP(T22,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0,"d":"0.00"}},null,1,"Inodoro con cisterna",{"$f":"IF(Y22=\"\",0,X22*VLOOKUP(Y22,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0.1,"d":"0.10"}},{"$f":"IF(Y22=\"\",0,X22*VLOOKUP(Y22,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0,"d":"0.00"}}]
[null,null,2,"Lavabo",{"$f":"IF(D23=\"\",0,C23*VLOOKUP(D23,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0.2,"d":"0.20"}},{"$f":"IF(D23=\"\",0,C23*VLOOKUP(D23,Tablas!$B$6:$D$26,3,FALSE))","v":0.13},null,null,2,"Lavabo",{"$f":"IF(J23=\"\",0,I23*VLOOKUP(J23,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0.2,"d":"0.20"}},{"$f":"IF(J23=\"\",0,I23*VLOOKUP(J23,Tablas!$B$6:$D$26,3,FALSE))","v":0.13},null,3,"Lavabo",{"$f":"IF(O23=\"\",0,N23*VLOOKUP(O23,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0.30000000000000004,"d":"0.30"}},{"$f":"IF(O23=\"\",0,N23*VLOOKUP(O23,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0.195,"d":"0.20"}},null,3,"Lavabo",{"$f":"IF(T23=\"\",0,S23*VLOOKUP(T23,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0.30000000000000004,"d":"0.30"}},{"$f":"IF(T23=\"\",0,S23*VLOOKUP(T23,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0.195,"d":"0.20"}},null,1,"Lavabo",{"$f":"IF(Y23=\"\",0,X23*VLOOKUP(Y23,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0.1,"d":"0.10"}},{"$f":"IF(Y23=\"\",0,X23*VLOOKUP(Y23,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0.065,"d":"0.07"}}]
[null,null,2,"Bidé",{"$f":"IF(D24=\"\",0,C24*VLOOKUP(D24,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0.2,"d":"0.20"}},{"$f":"IF(D24=\"\",0,C24*VLOOKUP(D24,Tablas!$B$6:$D$26,3,FALSE))","v":0.13},null,null,2,"Bidé",{"$f":"IF(J24=\"\",0,I24*VLOOKUP(J24,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0.2,"d":"0.20"}},{"$f":"IF(J24=\"\",0,I24*VLOOKUP(J24,Tablas!$B$6:$D$26,3,FALSE))","v":0.13},null,2,"Bidé",{"$f":"IF(O24=\"\",0,N24*VLOOKUP(O24,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0.2,"d":"0.20"}},{"$f":"IF(O24=\"\",0,N24*VLOOKUP(O24,Tablas!$B$6:$D$26,3,FALSE))","v":0.13},null,3,"Bidé",{"$f":"IF(T24=\"\",0,S24*VLOOKUP(T24,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0.30000000000000004,"d":"0.30"}},{"$f":"IF(T24=\"\",0,S24*VLOOKUP(T24,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0.195,"d":"0.20"}},null,1,"Bidé",{"$f":"IF(Y24=\"\",0,X24*VLOOKUP(Y24,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0.1,"d":"0.10"}},{"$f":"IF(Y24=\"\",0,X24*VLOOKUP(Y24,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0.065,"d":"0.07"}}]
[null,null,1,"Bañera 1,40 o más",{"$f":"IF(D25=\"\",0,C25*VLOOKUP(D25,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0.3,"d":"0.30"}},{"$f":"IF(D25=\"\",0,C25*VLOOKUP(D25,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0.2,"d":"0.20"}},null,null,1,"Bañera 1,40 o más",{"$f":"IF(J25=\"\",0,I25*VLOOKUP(J25,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0.3,"d":"0.30"}},{"$f":"IF(J25=\"\",0,I25*VLOOKUP(J25,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0.2,"d":"0.20"}},null,1,"Bañera 1,40 o más",{"$f":"IF(O25=\"\",0,N25*VLOOKUP(O25,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0.3,"d":"0.30"}},{"$f":"IF(O25=\"\",0,N25*VLOOKUP(O25,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0.2,"d":"0.20"}},null,1,"Bañera 1,40 o más",{"$f":"IF(T25=\"\",0,S25*VLOOKUP(T25,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0.3,"d":"0.30"}},{"$f":"IF(T25=\"\",0,S25*VLOOKUP(T25,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0.2,"d":"0.20"}},null,1,"Bañera 1,40 o más",{"$f":"IF(Y25=\"\",0,X25*VLOOKUP(Y25,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0.3,"d":"0.30"}},{"$f":"IF(Y25=\"\",0,X25*VLOOKUP(Y25,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0.2,"d":"0.20"}}]
[{"$nulls":4},{"$f":"IF(D26=\"\",0,C26*VLOOKUP(D26,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0,"d":"0.00"}},{"$f":"IF(D26=\"\",0,C26*VLOOKUP(D26,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0,"d":"0.00"}},{"$nulls":4},{"$f":"IF(J26=\"\",0,I26*VLOOKUP(J26,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0,"d":"0.00"}},{"$f":"IF(J26=\"\",0,I26*VLOOKUP(J26,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0,"d":"0.00"}},{"$nulls":3},{"$f":"IF(O26=\"\",0,N26*VLOOKUP(O26,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0,"d":"0.00"}},{"$f":"IF(O26=\"\",0,N26*VLOOKUP(O26,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0,"d":"0.00"}},{"$nulls":3},{"$f":"IF(T26=\"\",0,S26*VLOOKUP(T26,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0,"d":"0.00"}},{"$f":"IF(T26=\"\",0,S26*VLOOKUP(T26,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0,"d":"0.00"}},{"$nulls":3},{"$f":"IF(Y26=\"\",0,X26*VLOOKUP(Y26,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0,"d":"0.00"}},{"$f":"IF(Y26=\"\",0,X26*VLOOKUP(Y26,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0,"d":"0.00"}}]
[null,null,1,"Fregadero domestico",{"$f":"IF(D27=\"\",0,C27*VLOOKUP(D27,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0.2,"d":"0.20"}},{"$f":"IF(D27=\"\",0,C27*VLOOKUP(D27,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0.1,"d":"0.10"}},null,null,1,"Fregadero domestico",{"$f":"IF(J27=\"\",0,I27*VLOOKUP(J27,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0.2,"d":"0.20"}},{"$f":"IF(J27=\"\",0,I27*VLOOKUP(J27,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0.1,"d":"0.10"}},null,1,"Fregadero domestico",{"$f":"IF(O27=\"\",0,N27*VLOOKUP(O27,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0.2,"d":"0.20"}},{"$f":"IF(O27=\"\",0,N27*VLOOKUP(O27,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0.1,"d":"0.10"}},null,1,"Fregadero domestico",{"$f":"IF(T27=\"\",0,S27*VLOOKUP(T27,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0.2,"d":"0.20"}},{"$f":"IF(T27=\"\",0,S27*VLOOKUP(T27,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0.1,"d":"0.10"}},null,1,"Fregadero domestico",{"$f":"IF(Y27=\"\",0,X27*VLOOKUP(Y27,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0.2,"d":"0.20"}},{"$f":"IF(Y27=\"\",0,X27*VLOOKUP(Y27,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0.1,"d":"0.10"}}]
[null,null,1,"Lavavajillas domésticos",{"$f":"IF(D28=\"\",0,C28*VLOOKUP(D28,Tablas!$B$6:$D$26,2,FALSE))","v":0.15},{"$f":"IF(D28=\"\",0,C28*VLOOKUP(D28,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0.1,"d":"0.10"}},null,null,1,"Lavavajillas domésticos",{"$f":"IF(J28=\"\",0,I28*VLOOKUP(J28,Tablas!$B$6:$D$26,2,FALSE))","v":0.15},{"$f":"IF(J28=\"\",0,I28*VLOOKUP(J28,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0.1,"d":"0.10"}},null,1,"Lavavajillas domésticos",{"$f":"IF(O28=\"\",0,N28*VLOOKUP(O28,Tablas!$B$6:$D$26,2,FALSE))","v":0.15},{"$f":"IF(O28=\"\",0,N28*VLOOKUP(O28,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0.1,"d":"0.10"}},null,1,"Lavavajillas domésticos",{"$f":"IF(T28=\"\",0,S28*VLOOKUP(T28,Tablas!$B$6:$D$26,2,FALSE))","v":0.15},{"$f":"IF(T28=\"\",0,S28*VLOOKUP(T28,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0.1,"d":"0.10"}},null,1,"Lavavajillas domésticos",{"$f":"IF(Y28=\"\",0,X28*VLOOKUP(Y28,Tablas!$B$6:$D$26,2,FALSE))","v":0.15},{"$f":"IF(Y28=\"\",0,X28*VLOOKUP(Y28,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0.1,"d":"0.10"}}]
[null,null,1,"Lavavadora doméstica",{"$f":"IF(D29=\"\",0,C29*VLOOKUP(D29,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0.2,"d":"0.20"}},{"$f":"IF(D29=\"\",0,C29*VLOOKUP(D29,Tablas!$B$6:$D$26,3,FALSE))","v":0.15},null,null,1,"Lavavadora doméstica",{"$f":"IF(J29=\"\",0,I29*VLOOKUP(J29,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0.2,"d":"0.20"}},{"$f":"IF(J29=\"\",0,I29*VLOOKUP(J29,Tablas!$B$6:$D$26,3,FALSE))","v":0.15},null,1,"Lavavadora doméstica",{"$f":"IF(O29=\"\",0,N29*VLOOKUP(O29,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0.2,"d":"0.20"}},{"$f":"IF(O29=\"\",0,N29*VLOOKUP(O29,Tablas!$B$6:$D$26,3,FALSE))","v":0.15},null,1,"Lavavadora doméstica",{"$f":"IF(T29=\"\",0,S29*VLOOKUP(T29,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0.2,"d":"0.20"}},{"$f":"IF(T29=\"\",0,S29*VLOOKUP(T29,Tablas!$B$6:$D$26,3,FALSE))","v":0.15},null,1,"Lavavadora doméstica",{"$f":"IF(Y29=\"\",0,X29*VLOOKUP(Y29,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0.2,"d":"0.20"}},{"$f":"IF(Y29=\"\",0,X29*VLOOKUP(Y29,Tablas!$B$6:$D$26,3,FALSE))","v":0.15}]
[null,null,0,"Grifo aislado (solo AF)",{"$f":"IF(D30=\"\",0,C30*VLOOKUP(D30,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0,"d":"0.00"}},{"$f":"IF(D30=\"\",0,C30*VLOOKUP(D30,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0,"d":"0.00"}},null,null,0,"Grifo aislado (solo AF)",{"$f":"IF(J30=\"\",0,I30*VLOOKUP(J30,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0,"d":"0.00"}},{"$f":"IF(J30=\"\",0,I30*VLOOKUP(J30,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0,"d":"0.00"}},null,0,"Grifo aislado (solo AF)",{"$f":"IF(O30=\"\",0,N30*VLOOKUP(O30,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0,"d":"0.00"}},{"$f":"IF(O30=\"\",0,N30*VLOOKUP(O30,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0,"d":"0.00"}},null,0,"Grifo aislado (solo AF)",{"$f":"IF(T30=\"\",0,S30*VLOOKUP(T30,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0,"d":"0.00"}},{"$f":"IF(T30=\"\",0,S30*VLOOKUP(T30,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0,"d":"0.00"}},null,0,"Grifo aislado (solo AF)",{"$f":"IF(Y30=\"\",0,X30*VLOOKUP(Y30,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0,"d":"0.00"}},{"$f":"IF(Y30=\"\",0,X30*VLOOKUP(Y30,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0,"d":"0.00"}}]
[{"$nulls":4},{"$f":"IF(D31=\"\",0,C31*VLOOKUP(D31,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0,"d":"0.00"}},{"$f":"IF(D31=\"\",0,C31*VLOOKUP(D31,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0,"d":"0.00"}},{"$nulls":4},{"$f":"IF(J31=\"\",0,I31*VLOOKUP(J31,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0,"d":"0.00"}},{"$f":"IF(J31=\"\",0,I31*VLOOKUP(J31,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0,"d":"0.00"}},{"$nulls":3},{"$f":"IF(O31=\"\",0,N31*VLOOKUP(O31,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0,"d":"0.00"}},{"$f":"IF(O31=\"\",0,N31*VLOOKUP(O31,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0,"d":"0.00"}},{"$nulls":3},{"$f":"IF(T31=\"\",0,S31*VLOOKUP(T31,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0,"d":"0.00"}},{"$f":"IF(T31=\"\",0,S31*VLOOKUP(T31,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0,"d":"0.00"}},{"$nulls":3},{"$f":"IF(Y31=\"\",0,X31*VLOOKUP(Y31,Tablas!$B$6:$D$26,2,FALSE))","v":{"v":0,"d":"0.00"}},{"$f":"IF(Y31=\"\",0,X31*VLOOKUP(Y31,Tablas!$B$6:$D$26,3,FALSE))","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":4},{"$f":"SUM(E21:E31)","v":1.65},{"$f":"SUM(F21:F31)","v":0.91},"dm3/s",{"$nulls":3},{"$f":"SUM(K21:K31)","v":{"v":1.8499999999999999,"d":"1.85"}},{"$f":"SUM(L21:L31)","v":1.01},{"$nulls":3},{"$f":"SUM(P21:P31)","v":{"v":1.8499999999999999,"d":"1.85"}},{"$f":"SUM(Q21:Q31)","v":{"v":0.975,"d":"0.98"}},{"$nulls":3},{"$f":"SUM(U21:U31)","v":2.15},{"$f":"SUM(V21:V31)","v":1.14},{"$nulls":3},{"$f":"SUM(Z21:Z31)","v":{"v":1.1500000000000001,"d":"1.15"}},{"$f":"SUM(AA21:AA31)","v":0.68}]
[{"$nulls":4},{"$f":"E33*3600","v":5940},{"$f":"F33*3600","v":3276},"l/h",{"$nulls":3},{"$f":"K33*3600","v":{"v":6659.999999999999,"d":"6660"}},{"$f":"L33*3600","v":3636},{"$nulls":3},{"$f":"P33*3600","v":{"v":6659.999999999999,"d":"6660"}},{"$f":"Q33*3600","v":3510},{"$nulls":3},{"$f":"U33*3600","v":7740},{"$f":"V33*3600","v":4104},{"$nulls":3},{"$f":"Z33*3600","v":{"v":4140.000000000001,"d":"4140"}},{"$f":"AA33*3600","v":2448}]
[{"$nulls":4},{"$f":"E34/1000","v":5.94},{"$f":"F34/1000","v":{"v":3.276,"d":"3.28"}},"m3/h",{"$nulls":3},{"$f":"K34/1000","v":{"v":6.659999999999999,"d":"6.66"}},{"$f":"L34/1000","v":{"v":3.636,"d":"3.64"}},{"$nulls":3},{"$f":"P34/1000","v":{"v":6.659999999999999,"d":"6.66"}},{"$f":"Q34/1000","v":3.51},{"$nulls":3},{"$f":"U34/1000","v":7.74},{"$f":"V34/1000","v":{"v":4.104,"d":"4.10"}},{"$nulls":3},{"$f":"Z34/1000","v":{"v":4.140000000000001,"d":"4.14"}},{"$f":"AA34/1000","v":{"v":2.448,"d":"2.45"}}]
[null,null,"nº unidades ",1,{"$f":"E33*D36","v":1.65},{"$f":"F33*D36","v":0.91},"dm3/s",null,"nº unidades ",1,{"$f":"K33*J36","v":{"v":1.8499999999999999,"d":"1.85"}},{"$f":"L33*J36","v":1.01},null,"nº unidades ",1,{"$f":"P33*O36","v":{"v":1.8499999999999999,"d":"1.85"}},{"$f":"Q33*O36","v":{"v":0.975,"d":"0.98"}},null,"nº unidades ",1,{"$f":"U33*T36","v":2.15},{"$f":"V33*T36","v":1.14},null,"nº unidades ",1,{"$f":"Z33*Y36","v":{"v":1.1500000000000001,"d":"1.15"}},{"$f":"AA33*Y36","v":0.68}]
[null,null,"Caudal adicional",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,null,"Caudal adicional",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,"Caudal adicional",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,"Caudal adicional",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,"Caudal adicional",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
[null,null,"Simultaneidad vivienda",null,{"$f":"Tablas!$I$37","v":{"v":0.43295885873336687,"d":"0.43"}},{"$f":"Tablas!$H$37","v":{"v":0.5644633439181957,"d":"0.56"}},null,null,"Simultaneidad vivienda",null,{"$f":"Tablas!$I$37","v":{"v":0.43295885873336687,"d":"0.43"}},{"$f":"Tablas!$H$37","v":{"v":0.5644633439181957,"d":"0.56"}},null,"Simultaneidad vivienda",null,{"$f":"Tablas!$I$37","v":{"v":0.43295885873336687,"d":"0.43"}},{"$f":"Tablas!$H$37","v":{"v":0.5644633439181957,"d":"0.56"}},null,"Simultaneidad vivienda",null,{"$f":"Tablas!$I$37","v":{"v":0.43295885873336687,"d":"0.43"}},{"$f":"Tablas!$H$37","v":{"v":0.5644633439181957,"d":"0.56"}},null,"Simultaneidad vivienda",null,{"$f":"Tablas!$I$37","v":{"v":0.43295885873336687,"d":"0.43"}},{"$f":"Tablas!$H$37","v":{"v":0.5644633439181957,"d":"0.56"}}]
[null,null,"Simultaneidad varias unidades",null,{"$f":"F40","v":{"v":1,"d":"1.00"}},{"$f":"IF($D$10=\"UNE 149.201/07\",1,MAX(0.2,(19+D32)/(10*(D32+1))))","v":{"v":1,"d":"1.00"}},null,null,"Simultaneidad varias unidades",null,{"$f":"L40","v":{"v":1,"d":"1.00"}},{"$f":"IF($D$10=\"UNE 149.201/07\",1,MAX(0.2,(19+J32)/(10*(J32+1))))","v":{"v":1,"d":"1.00"}},null,"Simultaneidad varias unidades",null,{"$f":"Q40","v":{"v":1,"d":"1.00"}},{"$f":"IF($D$10=\"UNE 149.201/07\",1,MAX(0.2,(19+O32)/(10*(O32+1))))","v":{"v":1,"d":"1.00"}},null,"Simultaneidad varias unidades",null,{"$f":"V40","v":{"v":1,"d":"1.00"}},{"$f":"IF($D$10=\"UNE 149.201/07\",1,MAX(0.2,(19+T32)/(10*(T32+1))))","v":{"v":1,"d":"1.00"}},null,"Simultaneidad varias unidades",null,{"$f":"AA40","v":{"v":1,"d":"1.00"}},{"$f":"IF($D$10=\"UNE 149.201/07\",1,MAX(0.2,(19+Y32)/(10*(Y32+1))))","v":{"v":1,"d":"1.00"}}]
[]
[{"$nulls":3},"TOTAL  SIMULTÁNEO (l/s)",{"$f":"E36*E39*E40","v":{"v":0.7143821169100553,"d":"0.71"}},{"$f":"F36*F39*F40","v":{"v":0.5136616429655582,"d":"0.51"}},"dm3/s",null,null,"TOTAL  SIMULTÁNEO (l/s)",{"$f":"K36*K39*K40","v":{"v":0.8009738886567287,"d":"0.80"}},{"$f":"L36*L39*L40","v":{"v":0.5701079773573777,"d":"0.57"}},null,null,"TOTAL  SIMULTÁNEO (l/s)",{"$f":"P36*P39*P40","v":{"v":0.8009738886567287,"d":"0.80"}},{"$f":"Q36*Q39*Q40","v":{"v":0.5503517603202408,"d":"0.55"}},null,null,"TOTAL  SIMULTÁNEO (l/s)",{"$f":"U36*U39*U40","v":{"v":0.9308615462767388,"d":"0.93"}},{"$f":"V36*V39*V40","v":{"v":0.6434882120667431,"d":"0.64"}},null,null,"TOTAL  SIMULTÁNEO (l/s)",{"$f":"Z36*Z39*Z40","v":{"v":0.49790268754337197,"d":"0.50"}},{"$f":"AA36*AA39*AA40","v":{"v":0.38383507386437316,"d":"0.38"}}]
[]
[{"$nulls":3},"Dim int. calculo (mm2)",{"$f":"(4000*E42/(3.1416*$D$11))^0.5","v":{"v":17.412423096875365,"d":"17.41"}},{"$f":"(4000*F42/(3.1416*$D$11))^0.5","v":{"v":14.764967401149173,"d":"14.76"}},{"$nulls":3},"Dim int. calculo (mm2)",{"$f":"(4000*K42/(3.1416*$D$11))^0.5","v":{"v":18.437545430756686,"d":"18.44"}},{"$f":"(4000*L42/(3.1416*$D$11))^0.5","v":{"v":15.555088386245854,"d":"15.56"}},null,null,"Dim int. calculo (mm2)",{"$f":"(4000*P42/(3.1416*$D$11))^0.5","v":{"v":18.437545430756686,"d":"18.44"}},{"$f":"(4000*Q42/(3.1416*$D$11))^0.5","v":{"v":15.283193232518446,"d":"15.28"}},null,null,"Dim int. calculo (mm2)",{"$f":"(4000*U42/(3.1416*$D$11))^0.5","v":{"v":19.8763423853873,"d":"19.88"}},{"$f":"(4000*V42/(3.1416*$D$11))^0.5","v":{"v":16.525865809539912,"d":"16.53"}},null,null,"Dim int. calculo (mm2)",{"$f":"(4000*Z42/(3.1416*$D$11))^0.5","v":{"v":14.536711099421824,"d":"14.54"}},{"$f":"(4000*AA42/(3.1416*$D$11))^0.5","v":{"v":12.763396254879627,"d":"12.76"}}]
[]
[null,null,{"$f":"IF($D$12=Tablas!$B$87,\"Cobre\",\"Termoplastico\")","v":"Termoplastico"},"Dim comercial (mm2)",{"$f":"IF($C$46=\"Cobre\",INDEX(Tablas!$B$137:$B$146,MATCH(E44,Tablas!$C$137:$C$146,1)+1,1),INDEX(Tablas!$S$98:$S$111,MATCH(E44,Tablas!$R$98:$R$111,1)+1,1))","v":25},{"$f":"IF($C$46=\"Cobre\",INDEX(Tablas!$B$137:$B$146,MATCH(F44,Tablas!$C$137:$C$146,1)+1,1),INDEX(Tablas!$S$98:$S$111,MATCH(F44,Tablas!$R$98:$R$111,1)+1,1))","v":20},null,null,{"$f":"IF($D$12=Tablas!$B$87,\"Cobre\",\"Termoplastico\")","v":"Termoplastico"},"Dim comercial (mm2)",{"$f":"IF($I$46=\"Cobre\",INDEX(Tablas!$B$137:$B$146,MATCH(K44,Tablas!$C$137:$C$146,1)+1,1),INDEX(Tablas!$S$98:$S$111,MATCH(K44,Tablas!$R$98:$R$111,1)+1,1))","v":25},{"$f":"IF($I$46=\"Cobre\",INDEX(Tablas!$B$137:$B$146,MATCH(L44,Tablas!$C$137:$C$146,1)+1,1),INDEX(Tablas!$S$98:$S$111,MATCH(L44,Tablas!$R$98:$R$111,1)+1,1))","v":20},null,{"$f":"IF($D$12=Tablas!$B$87,\"Cobre\",\"Termoplastico\")","v":"Termoplastico"},"Dim comercial (mm2)",{"$f":"IF($N$46=\"Cobre\",INDEX(Tablas!$B$137:$B$146,MATCH(P44,Tablas!$C$137:$C$146,1)+1,1),INDEX(Tablas!$S$98:$S$111,MATCH(P44,Tablas!$R$98:$R$111,1)+1,1))","v":25},{"$f":"IF($N$46=\"Cobre\",INDEX(Tablas!$B$137:$B$146,MATCH(Q44,Tablas!$C$137:$C$146,1)+1,1),INDEX(Tablas!$S$98:$S$111,MATCH(Q44,Tablas!$R$98:$R$111,1)+1,1))","v":20},null,{"$f":"IF($D$12=Tablas!$B$87,\"Cobre\",\"Termoplastico\")","v":"Termoplastico"},"Dim comercial (mm2)",{"$f":"IF($S$46=\"Cobre\",INDEX(Tablas!$B$137:$B$146,MATCH(U44,Tablas!$C$137:$C$146,1)+1,1),INDEX(Tablas!$S$98:$S$111,MATCH(U44,Tablas!$R$98:$R$111,1)+1,1))","v":25},{"$f":"IF($S$46=\"Cobre\",INDEX(Tablas!$B$137:$B$146,MATCH(V44,Tablas!$C$137:$C$146,1)+1,1),INDEX(Tablas!$S$98:$S$111,MATCH(V44,Tablas!$R$98:$R$111,1)+1,1))","v":25},null,{"$f":"IF($D$12=Tablas!$B$87,\"Cobre\",\"Termoplastico\")","v":"Termoplastico"},"Dim comercial (mm2)",{"$f":"IF($X$46=\"Cobre\",INDEX(Tablas!$B$137:$B$146,MATCH(Z44,Tablas!$C$137:$C$146,1)+1,1),INDEX(Tablas!$S$98:$S$111,MATCH(Z44,Tablas!$R$98:$R$111,1)+1,1))","v":20},{"$f":"IF($X$46=\"Cobre\",INDEX(Tablas!$B$137:$B$146,MATCH(AA44,Tablas!$C$137:$C$146,1)+1,1),INDEX(Tablas!$S$98:$S$111,MATCH(AA44,Tablas!$R$98:$R$111,1)+1,1))","v":16}]
[null,null,{"$f":"IF(C46<>Tablas!$B$87,\"\",IF(F48>2,\"Velocidad excesiva\",\"\"))","v":""},"Dim int. Comercial",{"$f":"IF($C$46=\"Cobre\",VLOOKUP($E$46,Tablas!$B$137:$C$146,2,FALSE),INDEX(Tablas!$R$98:$R$111,MATCH(E44,Tablas!$R$98:$R$111,1)+1,1))","v":{"v":20.5,"d":"20.50"}},{"$f":"IF($C$46=\"Cobre\",VLOOKUP($F$46,Tablas!$B$137:$C$146,2,FALSE),INDEX(Tablas!$R$98:$R$111,MATCH(F44,Tablas!$R$98:$R$111,1)+1,1))","v":{"v":16.4,"d":"16.40"}},null,null,{"$f":"IF(I46<>Tablas!$B$87,\"\",IF(L48>2,\"Velocidad excesiva\",\"\"))","v":""},"Dim int. Comercial",{"$f":"IF($C$46=\"Cobre\",VLOOKUP($K$46,Tablas!$B$137:$C$146,2,FALSE),INDEX(Tablas!$R$98:$R$111,MATCH(K44,Tablas!$R$98:$R$111,1)+1,1))","v":{"v":20.5,"d":"20.50"}},{"$f":"IF($C$46=\"Cobre\",VLOOKUP($L$46,Tablas!$B$137:$C$146,2,FALSE),INDEX(Tablas!$R$98:$R$111,MATCH(L44,Tablas!$R$98:$R$111,1)+1,1))","v":{"v":16.4,"d":"16.40"}},null,{"$f":"IF(N46<>Tablas!$B$87,\"\",IF(Q48>2,\"Velocidad excesiva\",\"\"))","v":""},"Dim int. Comercial",{"$f":"IF($C$46=\"Cobre\",VLOOKUP($P$46,Tablas!$B$137:$C$146,2,FALSE),INDEX(Tablas!$R$98:$R$111,MATCH(P44,Tablas!$R$98:$R$111,1)+1,1))","v":{"v":20.5,"d":"20.50"}},{"$f":"IF($C$46=\"Cobre\",VLOOKUP($Q$46,Tablas!$B$137:$C$146,2,FALSE),INDEX(Tablas!$R$98:$R$111,MATCH(Q44,Tablas!$R$98:$R$111,1)+1,1))","v":{"v":16.4,"d":"16.40"}},null,{"$f":"IF(S46<>Tablas!$B$87,\"\",IF(V48>2,\"Velocidad excesiva\",\"\"))","v":""},"Dim int. Comercial",{"$f":"IF($C$46=\"Cobre\",VLOOKUP($U$46,Tablas!$B$137:$C$146,2,FALSE),INDEX(Tablas!$R$98:$R$111,MATCH(U44,Tablas!$R$98:$R$111,1)+1,1))","v":{"v":20.5,"d":"20.50"}},{"$f":"IF($C$46=\"Cobre\",VLOOKUP($V$46,Tablas!$B$137:$C$146,2,FALSE),INDEX(Tablas!$R$98:$R$111,MATCH(V44,Tablas!$R$98:$R$111,1)+1,1))","v":{"v":20.5,"d":"20.50"}},null,{"$f":"IF(X46<>Tablas!$B$87,\"\",IF(AA48>2,\"Velocidad excesiva\",\"\"))","v":""},"Dim int. Comercial",{"$f":"IF($C$46=\"Cobre\",VLOOKUP($Z$46,Tablas!$B$137:$C$146,2,FALSE),INDEX(Tablas!$R$98:$R$111,MATCH(Z44,Tablas!$R$98:$R$111,1)+1,1))","v":{"v":16.4,"d":"16.40"}},{"$f":"IF($C$46=\"Cobre\",VLOOKUP($AA$46,Tablas!$B$137:$C$146,2,FALSE),INDEX(Tablas!$R$98:$R$111,MATCH(AA44,Tablas!$R$98:$R$111,1)+1,1))","v":{"v":13.1,"d":"13.10"}}]
[null,null,{"$f":"IF(C46<>\"Termoplastico\",IF('Consumos TIPO'!F48>3.5,\"Velocidad excesiva\",\"\"),\"\")","v":""},"Velocidad suministro",{"$f":"4000*E42/(3.1416*E47*E47)","v":{"v":2.164372241079824,"d":"2.16"}},{"$f":"4000*F42/(3.1416*F47*F47)","v":{"v":2.4316358829230866,"d":"2.43"}},null,null,{"$f":"IF(I46<>\"Termoplastico\",IF('Consumos TIPO'!L48>3.5,\"Velocidad excesiva\",\"\"),\"\")","v":""},"Velocidad suministro",{"$f":"4000*K42/(3.1416*K47*K47)","v":{"v":2.426720391513742,"d":"2.43"}},{"$f":"4000*L42/(3.1416*L47*L47)","v":{"v":2.6988486173102393,"d":"2.70"}},null,{"$f":"IF(N46<>\"Termoplastico\",IF('Consumos TIPO'!Q48>3.5,\"Velocidad excesiva\",\"\"),\"\")","v":""},"Velocidad suministro",{"$f":"4000*P42/(3.1416*P47*P47)","v":{"v":2.426720391513742,"d":"2.43"}},{"$f":"4000*Q42/(3.1416*Q47*Q47)","v":{"v":2.6053241602747357,"d":"2.61"}},null,{"$f":"IF(S46<>\"Termoplastico\",IF('Consumos TIPO'!V48>3.5,\"Velocidad excesiva\",\"\"),\"\")","v":""},"Velocidad suministro",{"$f":"4000*U42/(3.1416*U47*U47)","v":{"v":2.820242617164619,"d":"2.82"}},{"$f":"4000*V42/(3.1416*V47*V47)","v":{"v":1.9495841100886635,"d":"1.95"}},null,{"$f":"IF(X46<>\"Termoplastico\",IF('Consumos TIPO'!AA48>3.5,\"Velocidad excesiva\",\"\"),\"\")","v":""},"Velocidad suministro",{"$f":"4000*Z42/(3.1416*Z47*Z47)","v":{"v":2.357034164054733,"d":"2.36"}},{"$f":"4000*AA42/(3.1416*AA47*AA47)","v":{"v":2.8478110359374504,"d":"2.85"}}]

{"sheet":"Tramos AF","index":2,"n_rows":17,"n_cols":84,"rows_kept":17,"merged":[[1,1,1,2],[1,5,1,7],[3,1,3,2],[4,1,4,2],[5,1,5,2],[8,1,8,2],[9,1,9,2],[11,1,11,2],[13,24,13,28],[14,24,14,28],[15,23,15,27]]}
[]
[null,"Altura max entre suminstro y consumo",null,{"v":17,"d":"17.00 m"},null,"INSTALACIÓN DE AGUA FRÍA",{"$nulls":13},"Medición  de tuberias según diámetro"]
[null,"Pres. mín. en punto suministro",null,{"v":1,"d":"1.00 bar"},{"$nulls":15},12,16,20,null,25,32,40,50,63,75,null,90,110,125,140,160]
[null,"Pres. max. en punto suministro",null,{"v":5,"d":"5.00 bar"},{"$nulls":15},{"$f":"SUM(BS:BS)","v":0},{"$f":"SUM(BT:BT)","v":0},{"$f":"SUM(BU:BU)","v":0},null,{"$f":"SUM(BV:BV)","v":0},{"$f":"SUM(BW:BW)","v":0},{"$f":"SUM(BX:BX)","v":0},{"$f":"SUM(BY:BY)","v":22},{"$f":"SUM(BZ:BZ)","v":0},{"$f":"SUM(CA:CA)","v":0},null,{"$f":"SUM(CB:CB)","v":0},{"$f":"SUM(CC:CC)","v":0},{"$f":"SUM(CD:CD)","v":0},{"$f":"SUM(CE:CE)","v":0},{"$f":"SUM(CF:CF)","v":0}]
[null,"Presión max. equipo bombeo",null,{"$f":"'Grupo AF'!D29","v":{"v":6.7235727632988755,"d":"6.72 bar"}},{"$nulls":47},"regimen"]
[null,"Perdida de carga tramo + desfavorable",null,{"$f":"SUM(BA:BA)","v":{"v":6.32251834033779,"d":"6.32 mca"}},{"$nulls":47},"turbulento"]
[{"$nulls":48},"Habitual",null,null,"agua fria"]
[1]
[null,"Tramo",null,"Consumos tipo","Unidades","Consumo","Consumo","Otros Consumos","Caudal","Uso","Qu","fila","suplemento","fila","fila ","fila ","Coef.","Coef.","Coef.","Q l/s","Q l/s","K",null,"Velocidad","Diámetro","Diámetro","Diámetro","Diámetro","Velocidad",null,"Pérdida","Pérdida","+25%","Pérdida","Pérdida",null,"ID","Presion","Presion",null,"Viscos.","Rugosidad","Número","Factor","Coef.","Coef.","Perdida","Perdida","Perdida","Flamant","Perdida","Perdida","Suma a",null,1,{"$f":"BC9+1","v":2},{"$f":"BD9+1","v":3},4,5,6,7,8,9,10,11,12,13,14,null,null,{"$f":"BC14","v":0},{"$f":"BD14","v":0},0,0,0,0,22,0,0,0,0,0,0,0]
[1,"Descripcion",null,null,"de cada","x unidad","instalado",null,"Otros",null,"mayor","tipo","fila","distinto","escuelas","busqueda","A","B","C","TOTAL","simult.","Simult.",null,"Teórica","Teórico Int","Nom. Ext.","Nom. Ext.","Nom. Int.","Real",null,"Tubería","Tubería","Accesorios","Total","TOTAL",null,"Tramo","Inicial","residual",null,"agua","Absoluta","Reynols","K/d","rugosidad","rugosidad","Carga","según","según","para ACS","según","según","tramo",null,12,16,20,25,32,40,50,63,75,90,110,125,140,160]
[{"$nulls":4},"tipologia","(l/s)","(l/s)",null,"(l/s)",null,null,"edificio",null,"escuelas",{"$nulls":5},"(l/s)","UNE 149","UNE 149",null,"(m/s)","(mm)","CALCULO","SELEC.","(mm)","(m/s)",null,"(mca/m)","(mca)","(mca)","(mca)","(KPa)",null,"Anterior","(bar)","(bar)",null,"(cm2/seg)","(mm)",null,null,"1 / l^0,5","Lamda","(mca/m)","Hazen","Flamant","Cu, 70ºC","Blasius","Manning","+ desfav.",null,{"$f":"INDEX(Tablas!$C$98:$P$111,BC9,BC12)","v":{"v":8.8,"d":"8.80"}},{"$f":"INDEX(Tablas!$C$98:$P$111,BD9,BD12)","v":{"v":11.7,"d":"11.70"}},{"$f":"INDEX(Tablas!$C$98:$P$111,BE9,BE12)","v":{"v":14.6,"d":"14.60"}},{"$f":"INDEX(Tablas!$C$98:$P$111,BF9,BF12)","v":{"v":18.2,"d":"18.20"}},{"$f":"INDEX(Tablas!$C$98:$P$111,BG9,BG12)","v":{"v":23.4,"d":"23.40"}},{"$f":"INDEX(Tablas!$C$98:$P$111,BH9,BH12)","v":{"v":29.2,"d":"29.20"}},{"$f":"INDEX(Tablas!$C$98:$P$111,BI9,BI12)","v":{"v":36.5,"d":"36.50"}},{"$f":"INDEX(Tablas!$C$98:$P$111,BJ9,BJ12)","v":{"v":46,"d":"46.00"}},{"$f":"INDEX(Tablas!$C$98:$P$111,BK9,BK12)","v":{"v":54.7,"d":"54.70"}},{"$f":"INDEX(Tablas!$C$98:$P$111,BL9,BL12)","v":{"v":65.7,"d":"65.70"}},{"$f":"INDEX(Tablas!$C$98:$P$111,BM9,BM12)","v":{"v":80.3,"d":"80.30"}},{"$f":"INDEX(Tablas!$C$98:$P$111,BN9,BN12)","v":{"v":91.2,"d":"91.20"}},{"$f":"INDEX(Tablas!$C$98:$P$111,BO9,BO12)","v":{"v":102.2,"d":"102.20"}},{"$f":"INDEX(Tablas!$C$98:$P$111,BP9,BP12)","v":{"v":116.8,"d":"116.80"}}]
[null,"ACS/Solar",null,{"$f":"'Consumos TIPO'!$H$9","v":"VIVIENDA TIPO A"},20,{"$f":"IF(E12=0,0,'Consumos TIPO'!$E$36+'Consumos TIPO'!$E$37)","v":1.65},{"$f":"E12*F12","v":{"v":33,"d":"33.00"}},{"$f":"'Consumos TIPO'!$O$9","v":"Basuras + Baldeo"},{"v":0,"d":"0.00"},{"$f":"'Consumos TIPO'!$D$7","v":"Viviendas"},{"$f":"Tablas!D47","v":{"v":0.3,"d":"0.30"}},{"$f":"VLOOKUP(J12,Tablas!$I$60:$K$65,3,FALSE)","v":{"v":1,"d":"1.00"}},{"$f":"IF(G12>20,3,IF(K12<0.5,0,IF(G12<=1,1,2)))","v":{"v":3,"d":"3.00"}},{"$f":"L12+M12","v":{"v":4,"d":"4.00"}},{"$f":"1+IF(G12<=1.5,0,IF(G12<=20,1,2))","v":{"v":3,"d":"3.00"}},{"$f":"IF(J12=Tablas!I65,O12,N12)","v":{"v":4,"d":"4.00"}},{"$f":"INDEX(Tablas!$E$59:$G$81,P12,1)","v":{"v":1.7,"d":"1.70"}},{"$f":"INDEX(Tablas!$E$59:$G$81,P12,2)","v":0.21},{"$f":"INDEX(Tablas!$E$59:$G$81,P12,3)","v":{"v":-0.7,"d":"-0.70"}},null,{"$f":"IF(G12=0,0,POWER(G12,R12)*Q12+S12)","v":{"v":2.842720160418497,"d":"2.84"}},{"$f":"IF(G12=0,0,U12/G12)","v":{"v":0.08614303516419689,"d":"0.09"}},null,{"v":3,"d":"3.00"},{"$f":"(4000*U17/(3.1416*$X$12))^0.5","v":{"v":36.172221828030075,"d":"36"}},{"$f":"INDEX(Tablas!$S$98:$S$111,MATCH(Y12,BC11:BP11,1)+1,1)","v":50},{"$f":"Z12","v":50},{"$f":"INDEX(Tablas!$C$98:$P$111,MATCH(AA12,Tablas!$B$98:$B$111,0),MATCH(Y15,Tablas!$C$96:$P$96,0))","v":{"v":36.5,"d":"37"}},{"$f":"4000*U17/(PI()*AB12*AB12)","v":{"v":2.946367479798517,"d":"2.95"}},null,{"$f":"IFERROR(AU12,AW12)","v":{"v":0.22990975783046508,"d":"0.23"}},{"$f":"AE12*(B16+C16)","v":{"v":5.0580146722702315,"d":"5.06"}},{"$f":"AF12*0.25","v":{"v":1.2645036680675579,"d":"1.26"}},{"$f":"AF12+AG12","v":{"v":6.32251834033779,"d":"6.32"}},{"$f":"AH12*9.8","v":{"v":61.96067973531034,"d":"61.96"}},null,"inicio",{"$f":"IF(AK12=\"inicio\",$D$5,INDEX($AM$9:$AM$11043,MATCH(AK12,$A$9:$A$11043,0)+2,1))","v":{"v":6.7235727632988755,"d":"6.72"}},{"$f":"AL12-(C16*0.098)-(AH12*0.098)","v":{"v":5.809965965945771,"d":"5.81"}},null,{"$f":"VLOOKUP('Consumos TIPO'!$D$8,'Propiedades agua'!$A$7:$K$27,5,FALSE)/100","v":0.013080000000000001},{"$f":"VLOOKUP(Y14,Tablas!$B$115:$C$125,2,FALSE)","v":1.5E-3},{"$f":"9.99*AC12*AB12/AO12","v":82136.75122296117},{"$f":"AP12/AB12","v":4.1095890410958905E-5},{"$f":"-2*LOG10((2.51*AS12/AQ12)+AR12/3.71)","v":{"v":7.264968615506596,"d":"7.265"}},{"$f":"1/(AS12*AS12)","v":0.018946653599365728},{"$f":"(AT12/AB12)*(AC12*AC12/(2*9.8))*1000","v":0.22990975783046508},{"$f":"10.674*((U17/1000)^1.852/(140^1.852*(AB12/1000)^4.781))","v":0.1892058165950292},{"$f":"(0.00056)*((AC12)^(7/4))/((AB12/1000)^(5/4))","v":0.23258089806565066},{"$f":"378*((U17*3600)^1.75)/(AB12^4.75)/1000","v":0.17211332104508745},{"$f":"(0.316/(AQ12^0.25))*999*AC12^2/(2*(AB12/1000))/10000","v":0.22175282196198723},{"$f":"10.3*(AS12^2*0.000001)*((U17/1000)^2/((AB12/1000)^5.33))","v":0.2377983229624603},{"$f":"IF(C14=\"NO\",0,AH12)","v":{"v":6.32251834033779,"d":"6.32"}},null,{"$f":"HLOOKUP(Y15,Tablas!$C$87:$I$94,8,FALSE)","v":6},{"$f":"BC12","v":6},{"$f":"BD12","v":6},6,6,6,6,6,6,6,6,6,6,6]
[{"$nulls":3},{"$f":"'Consumos TIPO'!$H$10","v":"VIVIENDA TIPO B"},5,{"$f":"IF(E13=0,0,'Consumos TIPO'!$K$36+'Consumos TIPO'!$K$37)","v":{"v":1.8499999999999999,"d":"1.85"}},{"$f":"E13*F13","v":9.25},{"$f":"'Consumos TIPO'!$O$10","v":"Riego"},{"v":0,"d":"0.00"},{"$f":"J12","v":"Viviendas"},{"$f":"Tablas!G47","v":{"v":0.4,"d":"0.40"}},{"$f":"VLOOKUP(J13,Tablas!$I$60:$K$65,3,FALSE)","v":{"v":1,"d":"1.00"}},{"$f":"IF(G13>20,3,IF(K13<0.5,0,IF(G13<=1,1,2)))","v":{"v":0,"d":"0.00"}},{"v":1,"d":"1.00"},{"v":2,"d":"2.00"},{"$f":"IF(J13=Tablas!I66,O13,N13)","v":{"v":1,"d":"1.00"}},{"$f":"INDEX(Tablas!$E$59:$G$81,P13,1)","v":{"v":0.682,"d":"0.68"}},{"$f":"INDEX(Tablas!$E$59:$G$81,P13,2)","v":0.45},{"$f":"INDEX(Tablas!$E$59:$G$81,P13,3)","v":-0.14},null,{"$f":"IF(G13=0,0,POWER(G13,R13)*Q13+S13)","v":{"v":1.715872576394474,"d":"1.72"}},{"$f":"IF(G13=0,0,U13/G13)","v":{"v":0.1854997379885918,"d":"0.19"}},{"$nulls":32},{"$f":"IF(BC10=Z12,1,0)","v":0},{"$f":"IF(BD10=AA12,1,0)","v":0},{"$f":"IF(BE10=AA12,1,0)","v":0},{"$f":"IF(BF10=AA12,1,0)","v":0},{"$f":"IF(BG10=AA12,1,0)","v":0},{"$f":"IF(BH10=AA12,1,0)","v":0},{"$f":"IF(BI10=AA12,1,0)","v":1},{"$f":"IF(BJ10=AA12,1,0)","v":0},{"$f":"IF(BK10=AA12,1,0)","v":0},{"$f":"IF(BL10=AA12,1,0)","v":0},{"$f":"IF(BM10=AA12,1,0)","v":0},{"$f":"IF(BN10=AA12,1,0)","v":0},{"$f":"IF(BO10=AA12,1,0)","v":0},{"$f":"IF(BP10=AA12,1,0)","v":0}]
[null,"Tramo desfavorable:","SI",{"$f":"'Consumos TIPO'!$H$11","v":"VIVIENDA TIPO C"},{"$f":"'Consumos TIPO'!$K$11","v":0},{"$f":"IF(E14=0,0,'Consumos TIPO'!$P$36+'Consumos TIPO'!$P$37)","v":{"v":0,"d":"0.00"}},{"$f":"E14*F14","v":{"v":0,"d":"0.00"}},{"$f":"'Consumos TIPO'!$O$11","v":"Sala Solar"},{"$f":"'Consumos TIPO'!P11","v":{"v":2.850682371881723,"d":"2.85"}},{"$f":"J13","v":"Viviendas"},{"$f":"Tablas!J47","v":{"v":0.30000000000000004,"d":"0.30"}},{"$f":"VLOOKUP(J14,Tablas!$I$60:$K$65,3,FALSE)","v":{"v":1,"d":"1.00"}},{"$f":"IF(G14>20,3,IF(K14<0.5,0,IF(G14<=1,1,2)))","v":{"v":0,"d":"0.00"}},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"$f":"IF(J14=Tablas!I67,O14,N14)","v":{"v":1,"d":"1.00"}},{"$f":"INDEX(Tablas!$E$59:$G$81,P14,1)","v":{"v":0.682,"d":"0.68"}},{"$f":"INDEX(Tablas!$E$59:$G$81,P14,2)","v":0.45},{"$f":"INDEX(Tablas!$E$59:$G$81,P14,3)","v":-0.14},null,{"$f":"IF(G14=0,0,POWER(G14,R14)*Q14+S14)","v":{"v":0,"d":"0.00"}},{"$f":"IF(G14=0,0,U14/G14)","v":{"v":0,"d":"0.00"}},null,"Tipo:","HDPE  (Polietileno de Alta Densidad)",{"$nulls":29},{"$f":"BC13*(B16+C16)","v":0},{"$f":"BD13*(B16+C16)","v":0},{"$f":"BE13*(B16+C16)","v":0},{"$f":"BF13*(B16+C16)","v":0},{"$f":"BG13*(B16+C16)","v":0},{"$f":"BH13*(B16+C16)","v":0},{"$f":"BI13*(B16+C16)","v":22},{"$f":"BJ13*(B16+C16)","v":0},{"$f":"BK13*(B16+C16)","v":0},{"$f":"BL13*(B16+C16)","v":0},{"$f":"BM13*(B16+C16)","v":0},{"$f":"BN13*(B16+C16)","v":0},{"$f":"BO13*(B16+C16)","v":0},{"$f":"BP13*(B16+C16)","v":0}]
[null,"Long. Horizontal","Long. Vertical",{"$f":"'Consumos TIPO'!$H$12","v":"VIVIENDA TIPO D"},{"$f":"'Consumos TIPO'!$K$12","v":0},{"$f":"IF(E15=0,0,'Consumos TIPO'!$U$36+'Consumos TIPO'!$U$37)","v":{"v":0,"d":"0.00"}},{"$f":"E15*F15","v":{"v":0,"d":"0.00"}},{"$f":"'Consumos TIPO'!$O$12","v":"Piscina"},{"v":0,"d":"0.00"},{"$f":"J14","v":"Viviendas"},{"$f":"Tablas!M47","v":{"v":0.4,"d":"0.40"}},{"$f":"VLOOKUP(J15,Tablas!$I$60:$K$65,3,FALSE)","v":{"v":1,"d":"1.00"}},{"$f":"IF(G15>20,3,IF(K15<0.5,0,IF(G15<=1,1,2)))","v":{"v":0,"d":"0.00"}},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"$f":"IF(J15=Tablas!I68,O15,N15)","v":{"v":1,"d":"1.00"}},{"$f":"INDEX(Tablas!$E$59:$G$81,P15,1)","v":{"v":0.682,"d":"0.68"}},{"$f":"INDEX(Tablas!$E$59:$G$81,P15,2)","v":0.45},{"$f":"INDEX(Tablas!$E$59:$G$81,P15,3)","v":-0.14},null,{"$f":"IF(G15=0,0,POWER(G15,R15)*Q15+S15)","v":{"v":0,"d":"0.00"}},{"$f":"IF(G15=0,0,U15/G15)","v":{"v":0,"d":"0.00"}},null,"Serie:","serie 3,2"]
[null,{"v":19,"d":"19.00 m"},{"v":3,"d":"3.00 m"},{"$f":"'Consumos TIPO'!$H$13","v":"VIVIENDA TIPO E"},{"$f":"'Consumos TIPO'!$K$13","v":0},{"$f":"IF(E16=0,0,'Consumos TIPO'!$Z$36+'Consumos TIPO'!$Z$37)","v":{"v":0,"d":"0.00"}},{"$f":"E16*F16","v":{"v":0,"d":"0.00"}},{"$f":"'Consumos TIPO'!$O$13","v":"Vestuarios"},{"$f":"'Consumos TIPO'!$Q$13","v":{"v":0,"d":"0.00"}},{"$f":"J15","v":"Viviendas"},{"$f":"Tablas!P47","v":{"v":0.3,"d":"0.30"}},{"$f":"VLOOKUP(J16,Tablas!$I$60:$K$65,3,FALSE)","v":{"v":1,"d":"1.00"}},{"$f":"IF(G16>20,3,IF(K16<0.5,0,IF(G16<=1,1,2)))","v":{"v":0,"d":"0.00"}},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"$f":"IF(J16=Tablas!I69,O16,N16)","v":{"v":1,"d":"1.00"}},{"$f":"INDEX(Tablas!$E$59:$G$81,P16,1)","v":{"v":0.682,"d":"0.68"}},{"$f":"INDEX(Tablas!$E$59:$G$81,P16,2)","v":0.45},{"$f":"INDEX(Tablas!$E$59:$G$81,P16,3)","v":-0.14},null,{"$f":"IF(G16=0,0,POWER(G16,R16)*Q16+S16)","v":{"v":0,"d":"0.00"}},{"$f":"IF(G16=0,0,U16/G16)","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(INDEX(Tablas!$C$88:$I$93,MATCH(Y14,Tablas!$L$88:$L$93,0),MATCH(Y15,serie,0))=\"SI\",\"\",\"La serie no existe en el materail seleccionado\")","v":""}]
[{"$nulls":4},{"$f":"SUM(E12:E16)","v":25},"TOTAL",{"$f":"SUM(G12:G16)","v":42.25},null,{"$f":"SUM(I12:I16)","v":{"v":2.850682371881723,"d":"2.85"}},{"$f":"J12","v":"Viviendas"},{"$f":"IF(E17=1,MAX(K12:K16),MAX(F12:F16,I12:I16))","v":{"v":2.850682371881723,"d":"2.85"}},{"$f":"VLOOKUP(J17,Tablas!$I$60:$K$65,3,FALSE)","v":{"v":1,"d":"1.00"}},{"$f":"IF(G17>20,3,IF(K17<0.5,0,IF(G16<=1,1,2)))","v":{"v":3,"d":"3.00"}},{"v":4,"d":"4.00"},{"v":3,"d":"3.00"},{"$f":"IF(J17=Tablas!I69,O17,N17)","v":{"v":4,"d":"4.00"}},{"$f":"INDEX(Tablas!$E$59:$G$81,P17,1)","v":{"v":1.7,"d":"1.70"}},{"$f":"INDEX(Tablas!$E$59:$G$81,P17,2)","v":0.21},{"$f":"INDEX(Tablas!$E$59:$G$81,P17,3)","v":{"v":-0.7,"d":"-0.70"}},{"$f":"G17+I17","v":{"v":45.100682371881724,"d":"45.10"}},{"$f":"IF(T17=0,0,POWER(T17,R17)*Q17+S17)","v":{"v":3.0829218988623595,"d":"3.08"}},{"$f":"IF(T17=0,0,U17/T17)","v":{"v":0.06835643579495872,"d":"0.07"}}]

{"sheet":"Grupo AF","index":3,"n_rows":43,"n_cols":15,"rows_kept":43,"merged":[[1,14,1,26],[17,7,17,8]]}
[]
[null,"GRUPO DE PRESIÓN AGUA FRÍA",null,"EQUIPOS DE CAUDAL VARIABLE",{"$nulls":8},"Grupos EBARA AP-MVP",null,"http://www.ebara.es/productos/bombas-centrifugas-verticales/mvp/"]
[{"$nulls":12},"Grupos EBARA 1 bomba"]
[null,"Número consumos tipo",{"$f":"SUM('Consumos TIPO'!K9:K13)","v":25}]
[null,"Caudal simutaneo total",{"$f":"'Consumos TIPO'!D13","v":{"v":3.137771446337956,"d":"3.14 l/s"}},{"$f":"C5*60","v":{"v":188.26628678027734,"d":"188 l/min"}},{"$f":"D5*0.06","v":{"v":11.29597720681664,"d":"11.30 m3/h"}}]
[]
[null,"Perdida de carga lineal",{"$f":"'Tramos AF'!D6","v":{"v":6.32251834033779,"d":"6.32 mca"}},null,{"$f":"C7/$C$12","v":{"v":0.16650303025212024,"d":"16.65%"}}]
[null,"Altura geométrica",{"$f":"'Tramos AF'!$D$2","v":{"v":17,"d":"17.00 m"}},null,{"$f":"C8/$C$12","v":{"v":0.44769368183988817,"d":"44.77%"}}]
[null,"Presion residual",{"v":1,"d":"1.00 bar"},{"$f":"C9*100/9.806","v":{"v":10.197838058331634,"d":"10.20 mca"}},{"$f":"D9/$C$12","v":{"v":0.2685592745377309,"d":"26.86%"}}]
[null,"Altura de aspiración",{"v":1,"d":"1.00 m"},null,{"v":0.02633492246116989,"d":"2.63%"}]
[null,"Coeficiente seguridad",{"v":1.1,"d":"1.10"}]
[null,"Perdida TOTAL",{"$f":"(C7+C8+D9+C10)*C11","v":{"v":37.97239203853636,"d":"37.97 mca"}},{"$f":"C12*9.806/100","v":{"v":3.7235727632988755,"d":"3.72 bar"}}]
[]
[null,"Deposito de regulación CTE-HS4 (opcional)"]
[]
[null,"Volumen 15min uso",{"$f":"15*C5*60","v":{"v":2823.99430170416,"d":"2,824 litros"}}]
[null,"Volumen 20min uso",{"$f":"20*C5*60","v":{"v":3765.325735605547,"d":"3,765 litros"}}]
[{"$nulls":7},"Medición de tuberías"]
[null,"Deposito de regulación CAM","Orden 2.106",{"$nulls":4},"Dim (mm)","Long (m)"]
[]
[null,"Volumen recomendable",{"$f":"('Consumos TIPO'!K14-1)*50+100","v":{"v":1300,"d":"1,300 litros"}},{"$nulls":4},12,{"$f":"'Tramos AF'!T4","v":{"v":0,"d":"0.00"}}]
[{"$nulls":7},16,{"$f":"'Tramos AF'!U4","v":{"v":0,"d":"0.00"}},{"$nulls":3},"Grupos EBARA 2 bombas"]
[null,"Grupo de presión caudal variable",{"$nulls":5},20,{"$f":"'Tramos AF'!V4","v":{"v":0,"d":"0.00"}}]
[]
[null,"Número de bombas",2,"Mínimo:",{"$f":"IF(C5<10,2,IF(C5<30,3,4))","v":2},null,null,25,{"$f":"'Tramos AF'!X4","v":{"v":0,"d":"0.00"}}]
[null,"Bombas en reserva",{"$f":"IF(C5<=3,IF(C34<=4,0),1)","v":1},"UNE 149202:2013",{"$nulls":3},32,{"$f":"'Tramos AF'!Y4","v":{"v":0,"d":"0.00"}}]
[]
[null,"Presión mínima (arranque)",{"$f":"(C7+C8+D9+C10)*C11","v":{"v":37.97239203853636,"d":"37.97 mca"}},{"$f":"C28*9.806/100","v":{"v":3.7235727632988755,"d":"3.72 bar"}},{"$nulls":3},40,{"$f":"'Tramos AF'!Z4","v":{"v":0,"d":"0.00"}}]
[null,"Presión maxima (parada)",{"$f":"C28+(3*100/9.806)","v":{"v":68.56590621353126,"d":"68.57 mca"}},{"$f":"C29*9.806/100","v":{"v":6.7235727632988755,"d":"6.72 bar"}},{"$nulls":3},50,{"$f":"'Tramos AF'!AA4","v":{"v":22,"d":"22.00"}}]
[null,"Caudal xUd bomba",{"$f":"C5*0.6","v":{"v":1.8826628678027735,"d":"1.88 l/s"}},{"$f":"C30*3.6","v":{"v":6.7775863240899845,"d":"6.78 m3/h"}},{"$f":"C30*60","v":{"v":112.95977206816642,"d":"113 l/min"}},null,null,63,{"$f":"'Tramos AF'!AB4","v":{"v":0,"d":"0.00"}}]
[]
[null,"Mínimo bomba individual",{"v":0.6,"d":"60%"},{"$f":"D5*C32","v":{"v":112.9597720681664,"d":"113 l/min"}},{"$nulls":3},75,{"$f":"'Tramos AF'!AC4","v":{"v":0,"d":"0.00"}}]
[null,"Coeficiente seguridad",1.1,{"$nulls":4},90,{"$f":"'Tramos AF'!AE4","v":{"v":0,"d":"0.00"}}]
[null,"Potencia min xUd bomba",{"$f":"C33*(D30*(D9+C8)*1)/(367*C32)","v":{"v":0.9208413478467704,"d":"0.92 kW"}},{"$f":"C34/0.736","v":{"v":1.251143135661373,"d":"1.25 CV"}},{"$nulls":3},110,{"$f":"'Tramos AF'!AF4","v":{"v":0,"d":"0.00"}}]
[{"$nulls":7},125,{"$f":"'Tramos AF'!AG4","v":{"v":0,"d":"0.00"}}]
[null,"Acumulador de membrana","s/ UNE 149202:2013",{"$nulls":4},140,{"$f":"'Tramos AF'!AH4","v":{"v":0,"d":"0.00"}}]
[]
[null,"Volumen deposito",{"$f":"MAX(200,(900*C5*(D28+3+1))/(4*35*(D29-D28)*(C25+C26)))","v":{"v":200,"d":"200 l"}},"     o según fabricante",{"$nulls":3},160,{"$f":"'Tramos AF'!AI4","v":{"v":0,"d":"0.00"}}]
[]
[]
[]
[null,"CRITERIO DE SELECCIÓN","1.- CAUDAL Y PERDIDA DE CARGA TOTAL DEL CONJUNTO DE BOMBAS",{"$nulls":9},"Grupos EBARA 3 bombas"]
[null,null,"2.- 1 BOMBA  DEL CONJUNTO 60% DEL CAUDAL Y PERDIDA DE CARGA TOTAL"]

{"sheet":"Propiedades agua","index":4,"n_rows":28,"n_cols":12,"rows_kept":28,"hidden":true}
[null,"TABLA. PROPIEDADES FÍSICAS DEL AGUA"]
[1,2,3,4,5,6,7,8,{"$nulls":3},1]
["Temperatura","Peso ","Densidad","Viscosidad","Viscosidad","Tensión","Carga a presión","Módulo","Temperatura",null,null,"Temperatura"]
[null,"específico",null,"dinámica","cinemática","superficial","de vapor","Elasticidad Vol."]
["T","g","r","m","n","s","pv *","B","T","Visc cinem T / Visc cinemT = 200C ","g T / g T = 20 0C","T"]
["( 0C )","N/ m3","Kg/ m3","Pa*s x 10 -3","cm2/ s x 10 -2","N / m x 10 -2","m","Pa","( 0C )","(adim.)","(adim.)","( 0C )"]
[0,9806,999.9,1.792,1.792,7.62,0.06,204,0,{"$f":"E7/$E$11","v":{"v":1.7795431976166833,"d":"1.780"}},{"$f":"B7/$B$11","v":{"v":1.001736643170906,"d":"1.002"}},0]
[{"$f":"A7+5","v":5},9807,{"v":1000,"d":"1000.0"},1.519,1.519,7.54,0.09,206,{"$f":"I7+5","v":5},{"v":1.5084409136047667,"d":"1.508"},{"v":1.0018387986515476,"d":"1.002"},{"$f":"L7+5","v":5}]
[10,9804,999.7,1.308,1.308,7.48,0.12,211,10,{"v":1.2989076464746774,"d":"1.299"},{"v":1.001532332209623,"d":"1.002"},10]
[15,9798,999.1,{"v":1.14,"d":"1.140"},1.141,7.41,0.17,214,15,{"v":1.1330685203574977,"d":"1.133"},{"v":1.000919399325774,"d":"1.001"},15]
[20,9789,998.2,1.005,1.007,7.36,0.25,220,20,{"v":1,"d":"1.000"},{"v":1,"d":"1.000"},20]
[25,9778,997.1,0.894,0.897,7.26,0.33,222,25,{"v":0.890764647467726,"d":"0.891"},{"v":0.9988762897129431,"d":"0.999"},25]
[30,9764,995.7,0.801,0.804,7.18,0.44,223,30,{"v":0.7984111221449852,"d":"0.798"},{"v":0.9974461129839616,"d":"0.997"},30]
[35,9749,994.1,0.723,0.727,{"v":7.1,"d":"7.10"},0.58,224,35,{"v":0.7219463753723933,"d":"0.722"},{"v":0.9959137807743386,"d":"0.996"},35]
[40,9730,992.2,0.656,0.661,7.01,0.76,227,40,{"v":0.6564051638530289,"d":"0.656"},{"v":0.9939728266421494,"d":"0.994"},40]
[45,9711,990.2,0.599,0.605,"6.92",0.98,229,45,{"v":0.6007944389275075,"d":"0.601"},{"v":0.9920318725099602,"d":"0.992"},45]
[50,9690,988.1,0.549,0.556,6.82,1.26,230,50,{"v":0.5521350546176764,"d":"0.552"},{"v":0.9898866074164879,"d":"0.990"},50]
[55,9666,985.7,0.506,0.513,6.74,1.61,231,55,{"v":0.509433962264151,"d":"0.509"},{"v":0.987434875881091,"d":"0.987"},55]
[60,9642,983.2,0.469,0.477,6.68,2.03,228,60,{"v":0.4736842105263158,"d":"0.474"},{"v":0.9849831443456941,"d":"0.985"},60]
[65,9616,980.6,0.436,0.444,6.58,2.56,226,65,{"v":0.4409136047666336,"d":"0.441"},{"v":0.9823271018490142,"d":"0.982"},65]
[70,9589,977.8,0.406,0.415,{"v":6.5,"d":"6.50"},{"v":3.2,"d":"3.20"},225,70,{"v":0.4121151936444886,"d":"0.412"},{"v":0.9795689038716927,"d":"0.980"},70]
[75,9560,974.9,{"v":0.38,"d":"0.380"},{"v":0.39,"d":"0.390"},{"v":6.4,"d":"6.40"},3.96,223,75,{"v":0.38728897715988087,"d":"0.387"},{"v":0.9766063949330882,"d":"0.977"},75]
[80,9530,971.8,0.357,0.367,{"v":6.3,"d":"6.30"},4.86,221,80,{"v":0.36444885799404175,"d":"0.364"},{"v":0.9735417305138421,"d":"0.974"},80]
[85,9499,968.6,0.336,0.347,{"v":6.2,"d":"6.20"},5.93,217,85,{"v":0.34458788480635555,"d":"0.345"},{"v":0.9703749106139544,"d":"0.970"},85]
[90,9466,965.3,0.317,0.328,6.12,7.18,216,90,{"v":0.32571996027805367,"d":"0.326"},{"v":0.9670037797527837,"d":"0.967"},90]
[95,9433,961.9,0.299,0.311,6.02,8.62,211,95,{"v":0.30883813306852037,"d":"0.309"},{"v":0.963632648891613,"d":"0.964"},95]
[100,9399,958.4,0.284,0.296,5.94,10.33,207,100,{"v":0.2939424031777557,"d":"0.294"},{"v":0.9601593625498008,"d":"0.960"},100]
[null,"* g = 9806 N/ m3"]

{"sheet":"Tramos ACS","index":5,"n_rows":17,"n_cols":80,"rows_kept":17,"merged":[[1,5,1,7],[3,1,3,2],[5,1,5,2],[8,1,8,2],[9,1,9,2],[11,1,11,2],[13,24,13,28],[14,24,14,28],[15,23,15,27]]}
[]
[{"$nulls":5},"INSTALACIÓN DE AGUA CALIENTE",{"$nulls":13},"Medición  de tuberias según diámetro"]
[{"$nulls":19},12,16,20,null,25,32,40,50,63,75,null,90,110,125,140,160]
[null,"Perdida TERMICA tramo + desfavorable",null,{"$f":"SUM(AX:AX)","v":{"v":109.50000000000001,"d":"110 W"}},{"$nulls":15},{"$f":"SUM(BO:BO)","v":0},{"$f":"SUM(BP:BP)","v":0},{"$f":"SUM(BQ:BQ)","v":0},null,{"$f":"SUM(BR:BR)","v":0},{"$f":"SUM(BS:BS)","v":0},{"$f":"SUM(BT:BT)","v":0},{"$f":"SUM(BU:BU)","v":15},{"$f":"SUM(BV:BV)","v":0},{"$f":"SUM(BW:BW)","v":0},null,{"$f":"SUM(BX:BX)","v":0},{"$f":"SUM(BY:BY)","v":0},{"$f":"SUM(BZ:BZ)","v":0},{"$f":"SUM(CA:CA)","v":0},{"$f":"SUM(CB:CB)","v":0}]
[{"$nulls":47},"regimen"]
[null,"Perdida de carga tramo + desfavorable",null,{"$f":"SUM(AW:AW)","v":{"v":2.666430685007481,"d":"2.67 mca"}},{"$nulls":43},"turbulento"]
[{"$nulls":44},"Habitual",null,null,"agua fria"]
[1]
[null,"Tramo",null,"Consumos tipo","Unidades","Consumo","Consumo","Otros Consumos","Caudal","Uso","Qu","fila","suplemento","fila","fila ","fila ","Coef.","Coef.","Coef.","Q l/s","Q l/s","K",null,"Velocidad","Diámetro","Diámetro","Diámetro","Diámetro","Velocidad",null,"Pérdida","Pérdida","+25%","Pérdida","Pérdida",null,"Viscos.","Rugosidad","Número","Factor","Coef.","Coef.","Perdida","Perdida","Perdida","Flamant","Perdida","Perdida","Suma a",null,1,{"$f":"AY9+1","v":2},{"$f":"AZ9+1","v":3},4,5,6,7,8,9,10,11,12,13,14,null,null,{"$f":"AY14","v":0},{"$f":"AZ14","v":0},0,0,0,0,15,0,0,0,0,0,0,0]
[1,"Descripcion",null,null,"de cada","x unidad","instalado",null,"Otros",null,"mayor","tipo","fila","distinto","escuelas","busqueda","A","B","C","TOTAL","simult.","Simult.",null,"Teórica","Teórico Int","Nom. Ext.","Nom. Ext.","Nom. Int.","Real",null,"Tubería","Tubería","Accesorios","Total","TOTAL",null,"agua","Absoluta","Reynols","K/d","rugosidad","rugosidad","Carga","según","según","para ACS","según","según","tramo",null,12,16,20,25,32,40,50,63,75,90,110,125,140,160]
[{"$nulls":4},"tipologia","(l/s)","(l/s)",null,"(l/s)",null,null,"edificio",null,"escuelas",{"$nulls":5},"(l/s)","UNE 149","UNE 149",null,"(m/s)","(mm)","CALCULO","SELEC.","(mm)","(m/s)",null,"(mca/m)","(mca)","(mca)","(mca)","(KPa)",null,"(cm2/seg)","(mm)",null,null,"1 / l^0,5","Lamda","(mca/m)","Hazen","Flamant","Cu, 70ºC","Blasius","Manning","+ desfav.",null,{"$f":"INDEX(Tablas!$C$98:$P$111,AY9,AY12)","v":{"v":8.8,"d":"8.80"}},{"$f":"INDEX(Tablas!$C$98:$P$111,AZ9,AZ12)","v":{"v":11.7,"d":"11.70"}},{"$f":"INDEX(Tablas!$C$98:$P$111,BA9,BA12)","v":{"v":14.6,"d":"14.60"}},{"$f":"INDEX(Tablas!$C$98:$P$111,BB9,BB12)","v":{"v":18.2,"d":"18.20"}},{"$f":"INDEX(Tablas!$C$98:$P$111,BC9,BC12)","v":{"v":23.4,"d":"23.40"}},{"$f":"INDEX(Tablas!$C$98:$P$111,BD9,BD12)","v":{"v":29.2,"d":"29.20"}},{"$f":"INDEX(Tablas!$C$98:$P$111,BE9,BE12)","v":{"v":36.5,"d":"36.50"}},{"$f":"INDEX(Tablas!$C$98:$P$111,BF9,BF12)","v":{"v":46,"d":"46.00"}},{"$f":"INDEX(Tablas!$C$98:$P$111,BG9,BG12)","v":{"v":54.7,"d":"54.70"}},{"$f":"INDEX(Tablas!$C$98:$P$111,BH9,BH12)","v":{"v":65.7,"d":"65.70"}},{"$f":"INDEX(Tablas!$C$98:$P$111,BI9,BI12)","v":{"v":80.3,"d":"80.30"}},{"$f":"INDEX(Tablas!$C$98:$P$111,BJ9,BJ12)","v":{"v":91.2,"d":"91.20"}},{"$f":"INDEX(Tablas!$C$98:$P$111,BK9,BK12)","v":{"v":102.2,"d":"102.20"}},{"$f":"INDEX(Tablas!$C$98:$P$111,BL9,BL12)","v":{"v":116.8,"d":"116.80"}}]
[null,"Inicio-Montante",null,{"$f":"'Consumos TIPO'!$H$9","v":"VIVIENDA TIPO A"},{"$f":"'Consumos TIPO'!$K$9","v":20},{"$f":"'Consumos TIPO'!$F$36","v":0.91},{"$f":"E12*F12","v":{"v":18.2,"d":"18.20"}},null,null,{"$f":"'Consumos TIPO'!$D$7","v":"Viviendas"},{"$f":"Tablas!$C$47","v":{"v":0.2,"d":"0.20"}},{"$f":"VLOOKUP(J12,Tablas!$I$60:$K$65,3,FALSE)","v":{"v":1,"d":"1.00"}},{"$f":"IF(G12>20,3,IF(K12<0.5,0,IF(G12<=1,1,2)))","v":{"v":0,"d":"0.00"}},{"$f":"L12+M12","v":{"v":1,"d":"1.00"}},{"$f":"1+IF(G12<=1.5,0,IF(G12<=20,1,2))","v":{"v":2,"d":"2.00"}},{"$f":"IF(J12=Tablas!I65,O12,N12)","v":{"v":1,"d":"1.00"}},{"$f":"INDEX(Tablas!$E$59:$G$81,P12,1)","v":{"v":0.682,"d":"0.68"}},{"$f":"INDEX(Tablas!$E$59:$G$81,P12,2)","v":0.45},{"$f":"INDEX(Tablas!$E$59:$G$81,P12,3)","v":-0.14},null,{"$f":"IF(G12=0,0,POWER(G12,R12)*Q12+S12)","v":{"v":2.3766133682721655,"d":"2.38"}},{"$f":"IF(G12=0,0,U12/G12)","v":{"v":0.13058315210286625,"d":"0.13"}},null,{"v":3,"d":"3.00"},{"$f":"(4000*U17/(3.1416*$X$12))^0.5","v":{"v":33.16438870413179,"d":"33"}},{"$f":"INDEX(Tablas!$S$98:$S$111,MATCH(Y12,AY11:BL11,1)+1,1)","v":50},{"$f":"Z12","v":50},{"$f":"INDEX(Tablas!$C$98:$P$111,MATCH(AA12,Tablas!$B$98:$B$111,0),MATCH(Y15,Tablas!$C$96:$P$96,0))","v":{"v":36.5,"d":"37"}},{"$f":"4000*U17/(PI()*AB12*AB12)","v":{"v":2.47674066453487,"d":"2.48"}},null,{"$f":"IFERROR(AQ12,AS12)","v":{"v":0.1422096365337323,"d":"0.14"}},{"$f":"AE12*(B16+C16)","v":{"v":2.1331445480059847,"d":"2.13"}},{"$f":"AF12*0.25","v":{"v":0.5332861370014962,"d":"0.53"}},{"$f":"AF12+AG12","v":{"v":2.666430685007481,"d":"2.67"}},{"$f":"AH12*9.8","v":{"v":26.131020713073315,"d":"26.13"}},null,{"$f":"VLOOKUP('Consumos TIPO'!$D$9,'Propiedades agua'!$A$7:$K$27,5,FALSE)/100","v":0.005560000000000001},{"$f":"VLOOKUP(Y14,Tablas!$B$115:$C$125,2,FALSE)","v":1.5E-3},{"$f":"9.99*AC12*AB12/AK12","v":162429.19644112812},{"$f":"AL12/AB12","v":4.1095890410958905E-5},{"$f":"-2*LOG10((2.51*AO12/AM12)+AN12/3.71)","v":{"v":7.765001671984769,"d":"7.765"}},{"$f":"1/(AO12*AO12)","v":0.01658505411255548},{"$f":"(AP12/AB12)*(AC12*AC12/(2*9.8))*1000","v":0.1422096365337323},{"$f":"10.674*((U17/1000)^1.852/(140^1.852*(AB12/1000)^4.781))","v":0.13717718039817386},{"$f":"(0.00056)*((AC12)^(7/4))/((AB12/1000)^(5/4))","v":0.17163777744076958},{"$f":"378*((U17*3600)^1.75)/(AB12^4.75)/1000","v":0.12701450608291048},{"$f":"(0.316/(AM12^0.25))*999*AC12^2/(2*(AB12/1000))/10000","v":0.1321370954415729},{"$f":"10.3*(AO12^2*0.000001)*((U17/1000)^2/((AB12/1000)^5.33))","v":0.1919604035543911},{"$f":"IF(C14=\"NO\",0,AH12)","v":{"v":2.666430685007481,"d":"2.67"}},null,{"$f":"HLOOKUP(Y15,Tablas!$C$87:$I$94,8,FALSE)","v":6},{"$f":"AY12","v":6},{"$f":"AZ12","v":6},6,6,6,6,6,6,6,6,6,6,6]
[{"$nulls":3},{"$f":"'Consumos TIPO'!$H$10","v":"VIVIENDA TIPO B"},{"$f":"'Consumos TIPO'!$K$10","v":5},{"$f":"'Consumos TIPO'!$L$36","v":1.01},{"$f":"E13*F13","v":5.05},null,null,{"$f":"J12","v":"Viviendas"},{"$f":"Tablas!$F$47","v":{"v":0.2,"d":"0.20"}},{"$f":"VLOOKUP(J13,Tablas!$I$60:$K$65,3,FALSE)","v":{"v":1,"d":"1.00"}},{"v":0,"d":"0.00"},{"v":1,"d":"1.00"},{"v":2,"d":"2.00"},{"$f":"IF(J13=Tablas!I66,O13,N13)","v":{"v":1,"d":"1.00"}},{"$f":"INDEX(Tablas!$E$59:$G$81,P13,1)","v":{"v":0.682,"d":"0.68"}},{"$f":"INDEX(Tablas!$E$59:$G$81,P13,2)","v":0.45},{"$f":"INDEX(Tablas!$E$59:$G$81,P13,3)","v":-0.14},null,{"$f":"IF(G13=0,0,POWER(G13,R13)*Q13+S13)","v":{"v":1.2734013272764781,"d":"1.27"}},{"$f":"IF(G13=0,0,U13/G13)","v":{"v":0.2521586786686095,"d":"0.25"}},{"$nulls":28},{"$f":"IF(AY10=Z12,1,0)","v":0},{"$f":"IF(AZ10=AA12,1,0)","v":0},{"$f":"IF(BA10=AA12,1,0)","v":0},{"$f":"IF(BB10=AA12,1,0)","v":0},{"$f":"IF(BC10=AA12,1,0)","v":0},{"$f":"IF(BD10=AA12,1,0)","v":0},{"$f":"IF(BE10=AA12,1,0)","v":1},{"$f":"IF(BF10=AA12,1,0)","v":0},{"$f":"IF(BG10=AA12,1,0)","v":0},{"$f":"IF(BH10=AA12,1,0)","v":0},{"$f":"IF(BI10=AA12,1,0)","v":0},{"$f":"IF(BJ10=AA12,1,0)","v":0},{"$f":"IF(BK10=AA12,1,0)","v":0},{"$f":"IF(BL10=AA12,1,0)","v":0}]
[null,"Tramo desfavorable:","SI",{"$f":"'Consumos TIPO'!$H$11","v":"VIVIENDA TIPO C"},{"$f":"'Consumos TIPO'!$K$11","v":0},{"$f":"'Consumos TIPO'!$Q$36","v":{"v":0.975,"d":"0.98"}},{"$f":"E14*F14","v":{"v":0,"d":"0.00"}},null,null,{"$f":"J13","v":"Viviendas"},{"$f":"Tablas!$I$47","v":{"v":0.2,"d":"0.20"}},{"$f":"VLOOKUP(J14,Tablas!$I$60:$K$65,3,FALSE)","v":{"v":1,"d":"1.00"}},{"v":0,"d":"0.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"$f":"IF(J14=Tablas!I67,O14,N14)","v":{"v":1,"d":"1.00"}},{"$f":"INDEX(Tablas!$E$59:$G$81,P14,1)","v":{"v":0.682,"d":"0.68"}},{"$f":"INDEX(Tablas!$E$59:$G$81,P14,2)","v":0.45},{"$f":"INDEX(Tablas!$E$59:$G$81,P14,3)","v":-0.14},null,{"$f":"IF(G14=0,0,POWER(G14,R14)*Q14+S14)","v":{"v":0,"d":"0.00"}},{"$f":"IF(G14=0,0,U14/G14)","v":{"v":0,"d":"0.00"}},null,"Tipo:","PEX (Polietileno reticulado)",{"$nulls":5},"Ubicación","Aislam.","Perdidas","Long.","Perdidas",{"$nulls":15},{"$f":"AY13*(B16+C16)","v":0},{"$f":"AZ13*(B16+C16)","v":0},{"$f":"BA13*(B16+C16)","v":0},{"$f":"BB13*(B16+C16)","v":0},{"$f":"BC13*(B16+C16)","v":0},{"$f":"BD13*(B16+C16)","v":0},{"$f":"BE13*(B16+C16)","v":15},{"$f":"BF13*(B16+C16)","v":0},{"$f":"BG13*(B16+C16)","v":0},{"$f":"BH13*(B16+C16)","v":0},{"$f":"BI13*(B16+C16)","v":0},{"$f":"BJ13*(B16+C16)","v":0},{"$f":"BK13*(B16+C16)","v":0},{"$f":"BL13*(B16+C16)","v":0}]
[null,"Long. Horizontal","Long. Vertical",{"$f":"'Consumos TIPO'!$H$12","v":"VIVIENDA TIPO D"},{"$f":"'Consumos TIPO'!$K$12","v":0},{"$f":"'Consumos TIPO'!$V$36","v":1.14},{"$f":"E15*F15","v":{"v":0,"d":"0.00"}},null,null,{"$f":"J14","v":"Viviendas"},{"$f":"Tablas!$L$47","v":{"v":0.2,"d":"0.20"}},{"$f":"VLOOKUP(J15,Tablas!$I$60:$K$65,3,FALSE)","v":{"v":1,"d":"1.00"}},{"v":0,"d":"0.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"$f":"IF(J15=Tablas!I68,O15,N15)","v":{"v":1,"d":"1.00"}},{"$f":"INDEX(Tablas!$E$59:$G$81,P15,1)","v":{"v":0.682,"d":"0.68"}},{"$f":"INDEX(Tablas!$E$59:$G$81,P15,2)","v":0.45},{"$f":"INDEX(Tablas!$E$59:$G$81,P15,3)","v":-0.14},null,{"$f":"IF(G15=0,0,POWER(G15,R15)*Q15+S15)","v":{"v":0,"d":"0.00"}},{"$f":"IF(G15=0,0,U15/G15)","v":{"v":0,"d":"0.00"}},null,"Serie:","serie 3,2",{"$nulls":5},"tubería","mínimo","térmicas","tuberia","térmicas"]
[null,{"v":15,"d":"15.00 m"},{"v":0,"d":"0.00 m"},{"$f":"'Consumos TIPO'!$H$13","v":"VIVIENDA TIPO E"},{"$f":"'Consumos TIPO'!$K$13","v":0},{"$f":"'Consumos TIPO'!$AA$36","v":0.68},{"$f":"E16*F16","v":{"v":0,"d":"0.00"}},null,null,{"$f":"J15","v":"Viviendas"},{"$f":"Tablas!$O$47","v":{"v":0.2,"d":"0.20"}},{"$f":"VLOOKUP(J16,Tablas!$I$60:$K$65,3,FALSE)","v":{"v":1,"d":"1.00"}},{"v":0,"d":"0.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"$f":"IF(J16=Tablas!I69,O16,N16)","v":{"v":1,"d":"1.00"}},{"$f":"INDEX(Tablas!$E$59:$G$81,P16,1)","v":{"v":0.682,"d":"0.68"}},{"$f":"INDEX(Tablas!$E$59:$G$81,P16,2)","v":0.45},{"$f":"INDEX(Tablas!$E$59:$G$81,P16,3)","v":-0.14},null,{"$f":"IF(G16=0,0,POWER(G16,R16)*Q16+S16)","v":{"v":0,"d":"0.00"}},{"$f":"IF(G16=0,0,U16/G16)","v":{"v":0,"d":"0.00"}},null,{"$f":"IF(INDEX(Tablas!$C$88:$I$93,MATCH(Y14,Tablas!$L$88:$L$93,0),MATCH(Y15,serie,0))=\"SI\",\"\",\"La serie no existe en el materail seleccionado\")","v":""},{"$nulls":7},"(mm)","(W/m)","(m)","(W)"]
[{"$nulls":4},{"$f":"SUM(E12:E16)","v":25},"TOTAL",{"$f":"SUM(G12:G16)","v":23.25},null,{"$f":"SUM(I12:I16)","v":{"v":0,"d":"0.00"}},{"$f":"J12","v":"Viviendas"},{"$f":"IF(E17=1,MAX(K12:K16),MAX(F12:F16,I12:I16))","v":1.14},{"$f":"VLOOKUP(J17,Tablas!$I$60:$K$65,3,FALSE)","v":{"v":1,"d":"1.00"}},{"v":3,"d":"3.00"},{"v":4,"d":"4.00"},{"v":3,"d":"3.00"},{"$f":"IF(J17=Tablas!I69,O17,N17)","v":{"v":4,"d":"4.00"}},{"$f":"INDEX(Tablas!$E$59:$G$81,P17,1)","v":{"v":1.7,"d":"1.70"}},{"$f":"INDEX(Tablas!$E$59:$G$81,P17,2)","v":0.21},{"$f":"INDEX(Tablas!$E$59:$G$81,P17,3)","v":{"v":-0.7,"d":"-0.70"}},{"$f":"G17+I17","v":23.25},{"$f":"IF(T17=0,0,POWER(T17,R17)*Q17+S17)","v":{"v":2.5915294289833843,"d":"2.59"}},{"$f":"IF(T17=0,0,U17/T17)","v":{"v":0.11146363135412406,"d":"0.11"}},{"$nulls":8},"Interior",{"$f":"INDEX(Tablas!$C$204:$D$208,MATCH(AA12,Tablas!$B$204:$B$208,1),IF(AE17=Tablas!$C$203,1,2))","v":35},{"$f":"IF('Consumos TIPO'!$D$9<=50,1,1.33)*INDEX(Tablas!$C$212:$G$225,MATCH(AA12,Tablas!$B$212:$B$225,0),MATCH(AF17,Tablas!$C$211:$G$211,0))","v":7.300000000000001},{"$f":"SUM(B16:C16)","v":{"v":15,"d":"15.00"}},{"$f":"AG17*AH17","v":{"v":109.50000000000001,"d":"110"}},{"$nulls":14},{"$f":"IF(C14=\"SI\",AI17,0)","v":{"v":109.50000000000001,"d":"110"}}]

{"sheet":"Retorno ACS","index":6,"n_rows":34,"n_cols":28,"rows_kept":34,"merged":[[3,2,3,3],[3,5,3,9],[3,11,3,15],[3,18,3,20],[3,21,3,22],[4,5,4,8],[4,11,4,14],[4,18,4,20],[4,21,4,22],[4,23,4,31],[5,5,5,8],[5,11,5,14],[6,5,6,8],[6,11,6,14]]}
[]
[null,null,"RETORNO ACS"]
[]
[null,null,"CRITERIO 1:   Caudal mín. por columna 250 l/h",null,null,"CRITERIO 2:   10% del Qsimultaneo",{"$nulls":5},"CRITERIO 3:   Dif. Temp. Max. 3º ",{"$nulls":6},"Caudal TOTAL",null,null,{"$f":"MAX(D6,J7,P7)*3.6","v":{"v":0.9329505944340185,"d":"0.93 m3/h"}},null,"Bomba de recirculacion ACS",{"$nulls":3},"Wilo Stratos Z"]
[null,null,"Número columnas",1,null,"Caudal suministro simultáneo",{"$nulls":3},{"$f":"'Consumos TIPO'!D14","v":{"v":2.5915294289833843,"d":"2.59 l/s"}},null,"Perdida térmica tramo más desfavorable",{"$nulls":3},{"$f":"'Tramos ACS'!D4","v":{"v":109.50000000000001,"d":"110 W"}},null,null,"Perdida de carga TOTAL",null,null,{"$f":"SUM(D22:P22)+SUM(D32:P32)","v":{"v":2.102890207927999,"d":"2.10 mca"}},null,"http://productfinder.wilo.com/be/en/c000000010002929a00040023/product.html#tab=1"]
[null,null,"Caudal mínimo TOTAL de retorno",{"$f":"D5*D7","v":{"v":0.06944444444444445,"d":"0.07 l/s"}},null,"Caudal mínimo TOTAL de retorno",{"$nulls":3},{"$f":"J5*0.1","v":{"v":0.25915294289833846,"d":"0.26 l/s"}},null,"Caudal mínimo TOTAL de retorno",{"$nulls":3},{"$f":"P5/3.48/3600","v":{"v":0.008740421455938698,"d":"0.01 l/s"}}]
[null,null,"Caudal mínimo por columna CTE HS4",{"$f":"250/3600","v":{"v":0.06944444444444445,"d":"0.07 l/s"}},null,"Caudal mínimo por columna CTE HS4",{"$nulls":3},{"$f":"J6/D5","v":{"v":0.25915294289833846,"d":"0.26 l/s"}},null,"Caudal mínimo por columna CTE HS4",{"$nulls":3},{"$f":"P6/D5","v":{"v":0.008740421455938698,"d":"0.01 l/s"}}]
[]
[null,null,"PEX (Polietileno reticulado)"]
[null,null,"serie 3,2"]
[]
[null,null,"COLUMNAS",1,{"$f":"D12+1","v":2},{"$f":"E12+1","v":3},4,5,6,7,8,9,10,11,12,13]
[null,null,"Nº columna de retorno",{"$f":"IF(D12<=$D$5,D12,\"A\")","v":1},{"$f":"IF(E12<=$D$5,E12,\"A\")","v":"A"},{"$f":"IF(F12<=$D$5,F12,\"A\")","v":"A"},{"$f":"IF(G12<=$D$5,G12,\"A\")","v":"A"},{"$f":"IF(H12<=$D$5,H12,\"A\")","v":"A"},{"$f":"IF(I12<=$D$5,I12,\"A\")","v":"A"},{"$f":"IF(J12<=$D$5,J12,\"A\")","v":"A"},{"$f":"IF(K12<=$D$5,K12,\"A\")","v":"A"},{"$f":"IF(L12<=$D$5,L12,\"A\")","v":"A"},{"$f":"IF(M12<=$D$5,M12,\"A\")","v":"A"},{"$f":"IF(N12<=$D$5,N12,\"A\")","v":"A"},{"$f":"IF(O12<=$D$5,O12,\"A\")","v":"A"},{"$f":"IF(P12<=$D$5,P12,\"A\")","v":"A"}]
[null,null,"Caudal por columna",{"$f":"IF(D13=\"A\",\"A\",$D$13*MAX($D$7,$J$7,$P$7))","v":{"v":0.25915294289833846,"d":"0.26"}},{"$f":"IF(E13=\"A\",\"A\",$D$13*MAX($D$7,$J$7,$P$7))","v":"A"},{"$f":"IF(F13=\"A\",\"A\",$D$13*MAX($D$7,$J$7,$P$7))","v":"A"},{"$f":"IF(G13=\"A\",\"A\",$D$13*MAX($D$7,$J$7,$P$7))","v":"A"},{"$f":"IF(H13=\"A\",\"A\",$D$13*MAX($D$7,$J$7,$P$7))","v":"A"},{"$f":"IF(I13=\"A\",\"A\",$D$13*MAX($D$7,$J$7,$P$7))","v":"A"},{"$f":"IF(J13=\"A\",\"A\",$D$13*MAX($D$7,$J$7,$P$7))","v":"A"},{"$f":"IF(K13=\"A\",\"A\",$D$13*MAX($D$7,$J$7,$P$7))","v":"A"},{"$f":"IF(L13=\"A\",\"A\",$D$13*MAX($D$7,$J$7,$P$7))","v":"A"},{"$f":"IF(M13=\"A\",\"A\",$D$13*MAX($D$7,$J$7,$P$7))","v":"A"},{"$f":"IF(N13=\"A\",\"A\",$D$13*MAX($D$7,$J$7,$P$7))","v":"A"},{"$f":"IF(O13=\"A\",\"A\",$D$13*MAX($D$7,$J$7,$P$7))","v":"A"},{"$f":"IF(P13=\"A\",\"A\",$D$13*MAX($D$7,$J$7,$P$7))","v":"A"}]
[null,null,"Diámetro nominal columna",{"$f":"IF(D13=\"A\",\"A\",INDEX(Tablas!$B$230:$B$235,MATCH(D14*3600,Tablas!$C$230:$C$235,1)+1,1))","v":32},{"$f":"IF(E13=\"A\",\"A\",INDEX(Tablas!$B$230:$B$235,MATCH(E14*3600,Tablas!$C$230:$C$235,1)+1,1))","v":"A"},{"$f":"IF(F13=\"A\",\"A\",INDEX(Tablas!$B$230:$B$235,MATCH(F14*3600,Tablas!$C$230:$C$235,1)+1,1))","v":"A"},{"$f":"IF(G13=\"A\",\"A\",INDEX(Tablas!$B$230:$B$235,MATCH(G14*3600,Tablas!$C$230:$C$235,1)+1,1))","v":"A"},{"$f":"IF(H13=\"A\",\"A\",INDEX(Tablas!$B$230:$B$235,MATCH(H14*3600,Tablas!$C$230:$C$235,1)+1,1))","v":"A"},{"$f":"IF(I13=\"A\",\"A\",INDEX(Tablas!$B$230:$B$235,MATCH(I14*3600,Tablas!$C$230:$C$235,1)+1,1))","v":"A"},{"$f":"IF(J13=\"A\",\"A\",INDEX(Tablas!$B$230:$B$235,MATCH(J14*3600,Tablas!$C$230:$C$235,1)+1,1))","v":"A"},{"$f":"IF(K13=\"A\",\"A\",INDEX(Tablas!$B$230:$B$235,MATCH(K14*3600,Tablas!$C$230:$C$235,1)+1,1))","v":"A"},{"$f":"IF(L13=\"A\",\"A\",INDEX(Tablas!$B$230:$B$235,MATCH(L14*3600,Tablas!$C$230:$C$235,1)+1,1))","v":"A"},{"$f":"IF(M13=\"A\",\"A\",INDEX(Tablas!$B$230:$B$235,MATCH(M14*3600,Tablas!$C$230:$C$235,1)+1,1))","v":"A"},{"$f":"IF(N13=\"A\",\"A\",INDEX(Tablas!$B$230:$B$235,MATCH(N14*3600,Tablas!$C$230:$C$235,1)+1,1))","v":"A"},{"$f":"IF(O13=\"A\",\"A\",INDEX(Tablas!$B$230:$B$235,MATCH(O14*3600,Tablas!$C$230:$C$235,1)+1,1))","v":"A"},{"$f":"IF(P13=\"A\",\"A\",INDEX(Tablas!$B$230:$B$235,MATCH(P14*3600,Tablas!$C$230:$C$235,1)+1,1))","v":"A"}]
[null,null,"diámetro interior (mm)",{"$f":"IF(D13=\"A\",\"A\",INDEX(Tablas!$C$98:$P$111,MATCH(D15,Tablas!$B$98:$B$111,0),MATCH($C$10,Tablas!$C$96:$P$96,0)))","v":{"v":23.4,"d":"23.40"}},{"$f":"IF(E13=\"A\",\"A\",INDEX(Tablas!$C$98:$P$111,MATCH(E15,Tablas!$B$98:$B$111,0),MATCH($C$10,Tablas!$C$96:$P$96,0)))","v":"A"},{"$f":"IF(F13=\"A\",\"A\",INDEX(Tablas!$C$98:$P$111,MATCH(F15,Tablas!$B$98:$B$111,0),MATCH($C$10,Tablas!$C$96:$P$96,0)))","v":"A"},{"$f":"IF(G13=\"A\",\"A\",INDEX(Tablas!$C$98:$P$111,MATCH(G15,Tablas!$B$98:$B$111,0),MATCH($C$10,Tablas!$C$96:$P$96,0)))","v":"A"},{"$f":"IF(H13=\"A\",\"A\",INDEX(Tablas!$C$98:$P$111,MATCH(H15,Tablas!$B$98:$B$111,0),MATCH($C$10,Tablas!$C$96:$P$96,0)))","v":"A"},{"$f":"IF(I13=\"A\",\"A\",INDEX(Tablas!$C$98:$P$111,MATCH(I15,Tablas!$B$98:$B$111,0),MATCH($C$10,Tablas!$C$96:$P$96,0)))","v":"A"},{"$f":"IF(J13=\"A\",\"A\",INDEX(Tablas!$C$98:$P$111,MATCH(J15,Tablas!$B$98:$B$111,0),MATCH($C$10,Tablas!$C$96:$P$96,0)))","v":"A"},{"$f":"IF(K13=\"A\",\"A\",INDEX(Tablas!$C$98:$P$111,MATCH(K15,Tablas!$B$98:$B$111,0),MATCH($C$10,Tablas!$C$96:$P$96,0)))","v":"A"},{"$f":"IF(L13=\"A\",\"A\",INDEX(Tablas!$C$98:$P$111,MATCH(L15,Tablas!$B$98:$B$111,0),MATCH($C$10,Tablas!$C$96:$P$96,0)))","v":"A"},{"$f":"IF(M13=\"A\",\"A\",INDEX(Tablas!$C$98:$P$111,MATCH(M15,Tablas!$B$98:$B$111,0),MATCH($C$10,Tablas!$C$96:$P$96,0)))","v":"A"},{"$f":"IF(N13=\"A\",\"A\",INDEX(Tablas!$C$98:$P$111,MATCH(N15,Tablas!$B$98:$B$111,0),MATCH($C$10,Tablas!$C$96:$P$96,0)))","v":"A"},{"$f":"IF(O13=\"A\",\"A\",INDEX(Tablas!$C$98:$P$111,MATCH(O15,Tablas!$B$98:$B$111,0),MATCH($C$10,Tablas!$C$96:$P$96,0)))","v":"A"},{"$f":"IF(P13=\"A\",\"A\",INDEX(Tablas!$C$98:$P$111,MATCH(P15,Tablas!$B$98:$B$111,0),MATCH($C$10,Tablas!$C$96:$P$96,0)))","v":"A"}]
[null,null,"Velocidad (m/s)",{"$f":"IF(D13=\"A\",\"A\",4000*D14/(PI()*D16*D16))","v":{"v":0.6026075225229347,"d":"0.60"}},{"$f":"IF(E13=\"A\",\"A\",4000*E14/(PI()*E16*E16))","v":"A"},{"$f":"IF(F13=\"A\",\"A\",4000*F14/(PI()*F16*F16))","v":"A"},{"$f":"IF(G13=\"A\",\"A\",4000*G14/(PI()*G16*G16))","v":"A"},{"$f":"IF(H13=\"A\",\"A\",4000*H14/(PI()*H16*H16))","v":"A"},{"$f":"IF(I13=\"A\",\"A\",4000*I14/(PI()*I16*I16))","v":"A"},{"$f":"IF(J13=\"A\",\"A\",4000*J14/(PI()*J16*J16))","v":"A"},{"$f":"IF(K13=\"A\",\"A\",4000*K14/(PI()*K16*K16))","v":"A"},{"$f":"IF(L13=\"A\",\"A\",4000*L14/(PI()*L16*L16))","v":"A"},{"$f":"IF(M13=\"A\",\"A\",4000*M14/(PI()*M16*M16))","v":"A"},{"$f":"IF(N13=\"A\",\"A\",4000*N14/(PI()*N16*N16))","v":"A"},{"$f":"IF(O13=\"A\",\"A\",4000*O14/(PI()*O16*O16))","v":"A"},{"$f":"IF(P13=\"A\",\"A\",4000*P14/(PI()*P16*P16))","v":"A"}]
[null,null,"Perdida de carga (mca/m)",{"$f":"IF(D13=\"A\",\"A\",9810*0.0056*D17^1.75*(D16/1000)^-1.25/100000)","v":{"v":0.02473988479915293,"d":"0.02"}},{"$f":"IF(E13=\"A\",\"A\",9810*0.0056*E17^1.75*(E16/1000)^-1.25/100000)","v":"A"},{"$f":"IF(F13=\"A\",\"A\",9810*0.0056*F17^1.75*(F16/1000)^-1.25/100000)","v":"A"},{"$f":"IF(G13=\"A\",\"A\",9810*0.0056*G17^1.75*(G16/1000)^-1.25/100000)","v":"A"},{"$f":"IF(H13=\"A\",\"A\",9810*0.0056*H17^1.75*(H16/1000)^-1.25/100000)","v":"A"},{"$f":"IF(I13=\"A\",\"A\",9810*0.0056*I17^1.75*(I16/1000)^-1.25/100000)","v":"A"},{"$f":"IF(J13=\"A\",\"A\",9810*0.0056*J17^1.75*(J16/1000)^-1.25/100000)","v":"A"},{"$f":"IF(K13=\"A\",\"A\",9810*0.0056*K17^1.75*(K16/1000)^-1.25/100000)","v":"A"},{"$f":"IF(L13=\"A\",\"A\",9810*0.0056*L17^1.75*(L16/1000)^-1.25/100000)","v":"A"},{"$f":"IF(M13=\"A\",\"A\",9810*0.0056*M17^1.75*(M16/1000)^-1.25/100000)","v":"A"},{"$f":"IF(N13=\"A\",\"A\",9810*0.0056*N17^1.75*(N16/1000)^-1.25/100000)","v":"A"},{"$f":"IF(O13=\"A\",\"A\",9810*0.0056*O17^1.75*(O16/1000)^-1.25/100000)","v":"A"},{"$f":"IF(P13=\"A\",\"A\",9810*0.0056*P17^1.75*(P16/1000)^-1.25/100000)","v":"A"}]
[null,null,"Longitud de tramo",18]
[null,null,"Tramo desfavorable","SI","NO","NO","NO","NO","NO","NO","NO","NO","NO","NO","NO","NO"]
[null,null,"Perdida de carga TOTAL (mca)",{"$f":"IF(D13=\"A\",\"A\",D19*D18*1.25)","v":{"v":0.5566474079809409,"d":"0.56"}},{"$f":"IF(E13=\"A\",\"A\",E19*E18*1.25)","v":"A"},{"$f":"IF(F13=\"A\",\"A\",F19*F18*1.25)","v":"A"},"A","A","A","A","A","A","A","A","A","A"]
[{"$nulls":3},{"$f":"IF(D13=\"A\",0,IF(D20=\"SI\",D21,0))","v":{"v":0.5566474079809409,"d":"0.56"}},{"$f":"IF(E13=\"A\",0,IF(E20=\"SI\",E21,0))","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,null,"TRAMO HORIZONTAL",{"$f":"IF(D13=\"A\",\"\",D13)","v":1},{"$f":"IF(E13=\"A\",\"\",E13)","v":""},"","","","","","","","","","",""]
[null,null,"Caudal acumulado",{"$f":"IF(D13=\"A\",\"A\",D13*MAX($D$7,$J$7,$P$7))","v":{"v":0.25915294289833846,"d":"0.26"}},{"$f":"IF(E13=\"A\",\"A\",E13*MAX($D$7,$J$7,$P$7))","v":"A"},{"$f":"IF(F13=\"A\",\"A\",F13*MAX($D$7,$J$7,$P$7))","v":"A"},"A","A","A","A","A","A","A","A","A","A"]
[null,null,"Diámetro de recirculación acumulado",{"$f":"IF(D13=\"A\",\"A\",INDEX(Tablas!$B$230:$B$235,MATCH(D24*3600,Tablas!$C$230:$C$235,1)+1,1))","v":32},{"$f":"IF(E13=\"A\",\"A\",INDEX(Tablas!$B$230:$B$235,MATCH(E24*3600,Tablas!$C$230:$C$235,1)+1,1))","v":"A"},{"$f":"IF(F13=\"A\",\"A\",INDEX(Tablas!$B$230:$B$235,MATCH(F24*3600,Tablas!$C$230:$C$235,1)+1,1))","v":"A"},{"$f":"IF(G13=\"A\",\"A\",INDEX(Tablas!$B$230:$B$235,MATCH(G24*3600,Tablas!$C$230:$C$235,1)+1,1))","v":"A"},{"$f":"IF(H13=\"A\",\"A\",INDEX(Tablas!$B$230:$B$235,MATCH(H24*3600,Tablas!$C$230:$C$235,1)+1,1))","v":"A"},{"$f":"IF(I13=\"A\",\"A\",INDEX(Tablas!$B$230:$B$235,MATCH(I24*3600,Tablas!$C$230:$C$235,1)+1,1))","v":"A"},{"$f":"IF(J13=\"A\",\"A\",INDEX(Tablas!$B$230:$B$235,MATCH(J24*3600,Tablas!$C$230:$C$235,1)+1,1))","v":"A"},{"$f":"IF(K13=\"A\",\"A\",INDEX(Tablas!$B$230:$B$235,MATCH(K24*3600,Tablas!$C$230:$C$235,1)+1,1))","v":"A"},{"$f":"IF(L13=\"A\",\"A\",INDEX(Tablas!$B$230:$B$235,MATCH(L24*3600,Tablas!$C$230:$C$235,1)+1,1))","v":"A"},{"$f":"IF(M13=\"A\",\"A\",INDEX(Tablas!$B$230:$B$235,MATCH(M24*3600,Tablas!$C$230:$C$235,1)+1,1))","v":"A"},{"$f":"IF(N13=\"A\",\"A\",INDEX(Tablas!$B$230:$B$235,MATCH(N24*3600,Tablas!$C$230:$C$235,1)+1,1))","v":"A"},{"$f":"IF(O13=\"A\",\"A\",INDEX(Tablas!$B$230:$B$235,MATCH(O24*3600,Tablas!$C$230:$C$235,1)+1,1))","v":"A"},{"$f":"IF(P13=\"A\",\"A\",INDEX(Tablas!$B$230:$B$235,MATCH(P24*3600,Tablas!$C$230:$C$235,1)+1,1))","v":"A"}]
[null,null,"diámetro interior (mm)",{"$f":"IF(D13=\"A\",\"A\",INDEX(Tablas!$C$98:$P$111,MATCH(D25,Tablas!$B$98:$B$111,0),MATCH($C$10,Tablas!$C$96:$P$96,0)))","v":{"v":23.4,"d":"23.40"}},{"$f":"IF(E13=\"A\",\"A\",INDEX(Tablas!$C$98:$P$111,MATCH(E25,Tablas!$B$98:$B$111,0),MATCH($C$10,Tablas!$C$96:$P$96,0)))","v":"A"},{"$f":"IF(F13=\"A\",\"A\",INDEX(Tablas!$C$98:$P$111,MATCH(F25,Tablas!$B$98:$B$111,0),MATCH($C$10,Tablas!$C$96:$P$96,0)))","v":"A"},{"$f":"IF(G13=\"A\",\"A\",INDEX(Tablas!$C$98:$P$111,MATCH(G25,Tablas!$B$98:$B$111,0),MATCH($C$10,Tablas!$C$96:$P$96,0)))","v":"A"},{"$f":"IF(H13=\"A\",\"A\",INDEX(Tablas!$C$98:$P$111,MATCH(H25,Tablas!$B$98:$B$111,0),MATCH($C$10,Tablas!$C$96:$P$96,0)))","v":"A"},{"$f":"IF(I13=\"A\",\"A\",INDEX(Tablas!$C$98:$P$111,MATCH(I25,Tablas!$B$98:$B$111,0),MATCH($C$10,Tablas!$C$96:$P$96,0)))","v":"A"},{"$f":"IF(J13=\"A\",\"A\",INDEX(Tablas!$C$98:$P$111,MATCH(J25,Tablas!$B$98:$B$111,0),MATCH($C$10,Tablas!$C$96:$P$96,0)))","v":"A"},{"$f":"IF(K13=\"A\",\"A\",INDEX(Tablas!$C$98:$P$111,MATCH(K25,Tablas!$B$98:$B$111,0),MATCH($C$10,Tablas!$C$96:$P$96,0)))","v":"A"},{"$f":"IF(L13=\"A\",\"A\",INDEX(Tablas!$C$98:$P$111,MATCH(L25,Tablas!$B$98:$B$111,0),MATCH($C$10,Tablas!$C$96:$P$96,0)))","v":"A"},{"$f":"IF(M13=\"A\",\"A\",INDEX(Tablas!$C$98:$P$111,MATCH(M25,Tablas!$B$98:$B$111,0),MATCH($C$10,Tablas!$C$96:$P$96,0)))","v":"A"},{"$f":"IF(N13=\"A\",\"A\",INDEX(Tablas!$C$98:$P$111,MATCH(N25,Tablas!$B$98:$B$111,0),MATCH($C$10,Tablas!$C$96:$P$96,0)))","v":"A"},{"$f":"IF(O13=\"A\",\"A\",INDEX(Tablas!$C$98:$P$111,MATCH(O25,Tablas!$B$98:$B$111,0),MATCH($C$10,Tablas!$C$96:$P$96,0)))","v":"A"},{"$f":"IF(P13=\"A\",\"A\",INDEX(Tablas!$C$98:$P$111,MATCH(P25,Tablas!$B$98:$B$111,0),MATCH($C$10,Tablas!$C$96:$P$96,0)))","v":"A"}]
[null,null,"Velocidad (m/s)",{"$f":"IF(D13=\"A\",\"A\",4000*D24/(PI()*D26*D26))","v":{"v":0.6026075225229347,"d":"0.60"}},{"$f":"IF(E13=\"A\",\"A\",4000*E24/(PI()*E26*E26))","v":"A"},{"$f":"IF(F13=\"A\",\"A\",4000*F24/(PI()*F26*F26))","v":"A"},{"$f":"IF(G13=\"A\",\"A\",4000*G24/(PI()*G26*G26))","v":"A"},{"$f":"IF(H13=\"A\",\"A\",4000*H24/(PI()*H26*H26))","v":"A"},{"$f":"IF(I13=\"A\",\"A\",4000*I24/(PI()*I26*I26))","v":"A"},{"$f":"IF(J13=\"A\",\"A\",4000*J24/(PI()*J26*J26))","v":"A"},{"$f":"IF(K13=\"A\",\"A\",4000*K24/(PI()*K26*K26))","v":"A"},{"$f":"IF(L13=\"A\",\"A\",4000*L24/(PI()*L26*L26))","v":"A"},{"$f":"IF(M13=\"A\",\"A\",4000*M24/(PI()*M26*M26))","v":"A"},{"$f":"IF(N13=\"A\",\"A\",4000*N24/(PI()*N26*N26))","v":"A"},{"$f":"IF(O13=\"A\",\"A\",4000*O24/(PI()*O26*O26))","v":"A"},{"$f":"IF(P13=\"A\",\"A\",4000*P24/(PI()*P26*P26))","v":"A"}]
[null,null,"Perdida de carga (mca/m)",{"$f":"IF(D13=\"A\",\"A\",9810*0.0056*D27^1.75*(D26/1000)^-1.25/100000)","v":{"v":0.02473988479915293,"d":"0.02"}},{"$f":"IF(E13=\"A\",\"A\",9810*0.0056*E27^1.75*(E26/1000)^-1.25/100000)","v":"A"},{"$f":"IF(F13=\"A\",\"A\",9810*0.0056*F27^1.75*(F26/1000)^-1.25/100000)","v":"A"},{"$f":"IF(G13=\"A\",\"A\",9810*0.0056*G27^1.75*(G26/1000)^-1.25/100000)","v":"A"},{"$f":"IF(H13=\"A\",\"A\",9810*0.0056*H27^1.75*(H26/1000)^-1.25/100000)","v":"A"},{"$f":"IF(I13=\"A\",\"A\",9810*0.0056*I27^1.75*(I26/1000)^-1.25/100000)","v":"A"},{"$f":"IF(J13=\"A\",\"A\",9810*0.0056*J27^1.75*(J26/1000)^-1.25/100000)","v":"A"},{"$f":"IF(K13=\"A\",\"A\",9810*0.0056*K27^1.75*(K26/1000)^-1.25/100000)","v":"A"},{"$f":"IF(L13=\"A\",\"A\",9810*0.0056*L27^1.75*(L26/1000)^-1.25/100000)","v":"A"},{"$f":"IF(M13=\"A\",\"A\",9810*0.0056*M27^1.75*(M26/1000)^-1.25/100000)","v":"A"},{"$f":"IF(N13=\"A\",\"A\",9810*0.0056*N27^1.75*(N26/1000)^-1.25/100000)","v":"A"},{"$f":"IF(O13=\"A\",\"A\",9810*0.0056*O27^1.75*(O26/1000)^-1.25/100000)","v":"A"},{"$f":"IF(P13=\"A\",\"A\",9810*0.0056*P27^1.75*(P26/1000)^-1.25/100000)","v":"A"}]
[null,null,"Longitud de tramo",50]
[null,null,"Tramo desfavorable","SI","SI","SI","SI","SI","SI","SI","SI","SI","SI","SI","SI","SI"]
[null,null,"Perdida de carga TOTAL (mca)",{"$f":"IF(D13=\"A\",\"A\",D29*D28*1.25)","v":{"v":1.5462427999470583,"d":"1.55"}},{"$f":"IF(E13=\"A\",\"A\",E29*E28*1.25)","v":"A"},{"$f":"IF(F13=\"A\",\"A\",F29*F28*1.25)","v":"A"},"A","A","A","A","A","A","A","A","A","A"]
[{"$nulls":3},{"$f":"IF(D13=\"A\",0,IF(D30=\"SI\",D31,0))","v":{"v":1.5462427999470583,"d":"1.55"}},{"$f":"IF(E13=\"A\",0,IF(E30=\"SI\",E31,0))","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
[{"$nulls":16}," "]

{"sheet":"Tablas","index":7,"n_rows":237,"n_cols":23,"rows_kept":237,"hidden":true,"merged":[[28,7,28,8],[28,10,28,11],[28,13,28,14],[28,16,28,17],[28,19,28,20],[41,2,41,3],[41,5,41,6],[41,8,41,9],[41,11,41,12],[41,14,41,15],[94,17,94,18],[95,17,95,18],[201,2,201,3]]}
[]
[]
[null,"HS4 tabla 2.1 Caudal Instantáneo mínimo por tipo de aparato",{"$nulls":4},"Tabla activa de diametros"]
[]
[null,"Tipo de aparato","Caudal AF   (dm3/s)","Caudal ACS   (dm3/s)",null,null,"Termo plastico","Cu","Activa"]
[null,"Lavamanos",0.05,0.03,null,"SI",12,6,{"$f":"IF('Consumos TIPO'!$C$46=\"Cobre\",Tablas!H6,Tablas!G6)","v":12}]
[null,"Lavabo",{"v":0.1,"d":"0.10"},{"v":0.065,"d":"0.07"},null,"NO",16,8,{"$f":"IF('Consumos TIPO'!$C$46=\"Cobre\",Tablas!H7,Tablas!G7)","v":16}]
[null,"Ducha",{"v":0.2,"d":"0.20"},{"v":0.1,"d":"0.10"},null,null,20,10,{"$f":"IF('Consumos TIPO'!$C$46=\"Cobre\",Tablas!H8,Tablas!G8)","v":20}]
[null,"Bañera 1,40 o más",{"v":0.3,"d":"0.30"},{"v":0.2,"d":"0.20"},null,null,25,12,{"$f":"IF('Consumos TIPO'!$C$46=\"Cobre\",Tablas!H9,Tablas!G9)","v":25}]
[null,"Bañera menos 1,40",{"v":0.2,"d":"0.20"},0.15,null,null,32,15,{"$f":"IF('Consumos TIPO'!$C$46=\"Cobre\",Tablas!H10,Tablas!G10)","v":32}]
[null,"Bidé",{"v":0.1,"d":"0.10"},{"v":0.065,"d":"0.07"},null,null,40,18,{"$f":"IF('Consumos TIPO'!$C$46=\"Cobre\",Tablas!H11,Tablas!G11)","v":40}]
[null,"Inodoro con cisterna",{"v":0.1,"d":"0.10"},{"$nulls":3},50,22,{"$f":"IF('Consumos TIPO'!$C$46=\"Cobre\",Tablas!H12,Tablas!G12)","v":50}]
[null,"Inodoro con fluxor",1.25,{"$nulls":3},63,28,{"$f":"IF('Consumos TIPO'!$C$46=\"Cobre\",Tablas!H13,Tablas!G13)","v":63}]
[null,"Urinarios con grifo temporizado",0.15,{"$nulls":3},75,35,{"$f":"IF('Consumos TIPO'!$C$46=\"Cobre\",Tablas!H14,Tablas!G14)","v":75}]
[null,"Urinarios con cisterna (c/u)",0.04,{"$nulls":3},90,42,{"$f":"IF('Consumos TIPO'!$C$46=\"Cobre\",Tablas!H15,Tablas!G15)","v":90}]
[null,"Fregadero domestico",{"v":0.2,"d":"0.20"},{"v":0.1,"d":"0.10"},null,null,110,"---",{"$f":"IF('Consumos TIPO'!$C$46=\"Cobre\",Tablas!H16,Tablas!G16)","v":110}]
[null,"Fegadero no domestico",{"v":0.3,"d":"0.30"},{"v":0.2,"d":"0.20"},null,null,125,"---",{"$f":"IF('Consumos TIPO'!$C$46=\"Cobre\",Tablas!H17,Tablas!G17)","v":125}]
[null,"Lavavajillas domésticos",0.15,{"v":0.1,"d":"0.10"},null,null,140,"---",{"$f":"IF('Consumos TIPO'!$C$46=\"Cobre\",Tablas!H18,Tablas!G18)","v":140}]
[null,"Lavavajillas industrial (20servicios)",0.25,{"v":0.2,"d":"0.20"},null,null,160,"---",{"$f":"IF('Consumos TIPO'!$C$46=\"Cobre\",Tablas!H19,Tablas!G19)","v":160}]
[null,"Lavadero",{"v":0.2,"d":"0.20"},{"v":0.1,"d":"0.10"}]
[null,"Lavavadora doméstica",{"v":0.2,"d":"0.20"},0.15]
[null,"Lavadora industrial (8kg)",{"v":0.6,"d":"0.60"},{"v":0.4,"d":"0.40"}]
[null,"Grifo aislado (solo AF)",0.15]
[null,"Grifo aislado (con ACS)",0.15,{"v":0.1,"d":"0.10"}]
[null,"Grifo garaje",{"v":0.2,"d":"0.20"}]
[null,"Vertedero",{"v":0.2,"d":"0.20"}]
[]
[null,"Calculo Potencia ACS"]
[null,null,"ACS",{"$nulls":4},"VIVIENDA 1",null,null,"VIVIENDA 2",null,null,"VIVIENDA 3",null,null,"VIVIENDA 4",null,null,"VIVIENDA 5"]
[null,"Caudal demandado",{"$f":"C44","v":{"v":0.5136616429655582,"d":"0.51"}},"l/s",null,null,"Simultaneidad","ACS","AF",null,"ACS","AF",null,"ACS","AF",null,"ACS","AF",null,"ACS","AF"]
[null,"Calos específico del agua ",1.16,"Wh/lºC","1 kcal/°C kg",null,"Confort Basico",0.5,0.5,null,0.5,0.5,null,0.5,0.5,null,0.5,0.5,null,0.5,0.5]
[{"$nulls":6},"Confort Medio",0.7,0.7,null,0.7,0.7,null,0.7,0.7,null,0.7,0.7,null,0.7,0.7]
[null,"Form. Tradicional",{"$nulls":4},"Confort Alto",0.9,0.9,null,0.9,0.9,null,0.9,0.9,null,0.9,0.9,null,0.9,0.9]
[null,"UNE 149.201/07",{"$nulls":4},"Form. Tradicional",{"$f":"MAX(1/(SUM('Consumos TIPO'!C21:C31)-1)^0.5,0.2)","v":{"v":0.31622776601683794,"d":"0.32"}},{"$f":"MAX(1/(SUM('Consumos TIPO'!C21:C31)-1)^0.5,0.2)","v":{"v":0.31622776601683794,"d":"0.32"}},null,{"$f":"MAX(1/(SUM('Consumos TIPO'!I21:I31)-1)^0.5,0.2)","v":{"v":0.30151134457776363,"d":"0.30"}},{"$f":"MAX(1/(SUM('Consumos TIPO'!I21:I31)-1)^0.5,0.2)","v":{"v":0.30151134457776363,"d":"0.30"}},null,{"$f":"MAX(1/(SUM('Consumos TIPO'!N21:N31)-1)^0.5,0.2)","v":{"v":0.2886751345948129,"d":"0.29"}},{"$f":"MAX(1/(SUM('Consumos TIPO'!N21:N31)-1)^0.5,0.2)","v":{"v":0.2886751345948129,"d":"0.29"}},null,{"$f":"MAX(1/(SUM('Consumos TIPO'!S21:S31)-1)^0.5,0.2)","v":{"v":0.2672612419124244,"d":"0.27"}},{"$f":"MAX(1/(SUM('Consumos TIPO'!S21:S31)-1)^0.5,0.2)","v":{"v":0.2672612419124244,"d":"0.27"}},null,{"$f":"MAX(1/(SUM('Consumos TIPO'!X21:X31)-1)^0.5,0.2)","v":{"v":0.4082482904638631,"d":"0.41"}},{"$f":"MAX(1/(SUM('Consumos TIPO'!X21:X31)-1)^0.5,0.2)","v":{"v":0.4082482904638631,"d":"0.41"}}]
[{"$nulls":6},"UNE 149.201/07",{"$f":"C44/C48","v":{"v":0.5644633439181957,"d":"0.56"}},{"$f":"D44/D48","v":{"v":0.43295885873336687,"d":"0.43"}},null,{"$f":"F44/F48","v":{"v":0.5396639639399502,"d":"0.54"}},{"$f":"G44/G48","v":{"v":0.41055227893526675,"d":"0.41"}},null,{"$f":"I44/I48","v":{"v":0.5479733940238813,"d":"0.55"}},{"$f":"J44/J48","v":{"v":0.41055227893526675,"d":"0.41"}},null,{"$f":"L44/L48","v":{"v":0.5117734588882074,"d":"0.51"}},{"$f":"M44/M48","v":{"v":0.38253849630081477,"d":"0.38"}},null,{"$f":"O44/O48","v":{"v":0.6372669254693224,"d":"0.64"}},{"$f":"P44/P48","v":{"v":0.5098004328564447,"d":"0.51"}}]
[]
[{"$nulls":5},"Selección",{"$f":"'Consumos TIPO'!D10","v":"UNE 149.201/07"},{"$f":"VLOOKUP($G$37,$G$31:$U$35,2,FALSE)","v":{"v":0.5644633439181957,"d":"0.56"}},{"$f":"VLOOKUP($G$37,$G$31:$U$35,3,FALSE)","v":{"v":0.43295885873336687,"d":"0.43"}},null,{"$f":"VLOOKUP($G$37,$G$31:$U$35,5,FALSE)","v":{"v":0.5396639639399502,"d":"0.54"}},{"$f":"VLOOKUP($G$37,$G$31:$U$35,6,FALSE)","v":{"v":0.41055227893526675,"d":"0.41"}},null,{"$f":"VLOOKUP($G$37,$G$31:$U$35,8,FALSE)","v":{"v":0.5479733940238813,"d":"0.55"}},{"$f":"VLOOKUP($G$37,$G$31:$U$35,9,FALSE)","v":{"v":0.41055227893526675,"d":"0.41"}},null,{"$f":"VLOOKUP($G$37,$G$31:$U$35,11,FALSE)","v":{"v":0.5117734588882074,"d":"0.51"}},{"$f":"VLOOKUP($G$37,$G$31:$U$35,12,FALSE)","v":{"v":0.38253849630081477,"d":"0.38"}},null,{"$f":"VLOOKUP($G$37,$G$31:$U$35,14,FALSE)","v":{"v":0.6372669254693224,"d":"0.64"}},{"$f":"VLOOKUP($G$37,$G$31:$U$35,15,FALSE)","v":{"v":0.5098004328564447,"d":"0.51"}}]
[null,"Potencia(W)=Caudal demandado de ACS(m3/h)*Diferencia de temperatura de ACS-temperatura AF de red(K)*calor específico del agua (1,16 W*h/kg*K)*peso específico del agua (1000 kg/m3)"]
[]
[null,"Tablas Coeficientes UNE 149.201/07"]
[]
[null,null,"VIVIENDA 1",null,null,"VIVIENDA 2",null,null,"VIVIENDA 3",null,null,"VIVIENDA 4",null,null,"VIVIENDA 5"]
[null,null,"ACS","AF",null,"ACS","AF",null,"ACS","AF",null,"ACS","AF",null,"ACS","AF"]
[null,"Qc=A * (Qt)^B + C",{"$f":"POWER(C48,C55)*C54+C56","v":{"v":0.5136616429655582,"d":"0.51"}},{"$f":"POWER(D48,D55)*D54+D56","v":{"v":0.7143821169100553,"d":"0.71"}},null,{"$f":"POWER(F48,F55)*F54+F56","v":{"v":0.5450606035793497,"d":"0.55"}},{"$f":"POWER(G48,G55)*G54+G56","v":{"v":0.7595217160302434,"d":"0.76"}},null,{"$f":"POWER(I48,I55)*I54+I56","v":{"v":0.5342740591732843,"d":"0.53"}},{"$f":"POWER(J48,J55)*J54+J56","v":{"v":0.7595217160302434,"d":"0.76"}},null,{"$f":"POWER(L48,L55)*L54+L56","v":{"v":0.5834217431325563,"d":"0.58"}},{"$f":"POWER(M48,M55)*M54+M56","v":{"v":0.8224577670467518,"d":"0.82"}},null,{"$f":"POWER(O48,O55)*O54+O56","v":{"v":0.4333415093191393,"d":"0.43"}},{"$f":"POWER(P48,P55)*P54+P56","v":{"v":0.5862704977849115,"d":"0.59"}}]
[]
[null,"Uso edificio",{"$f":"'Consumos TIPO'!D7","v":"Viviendas"},{"$f":"$C$46","v":"Viviendas"},null,{"$f":"$C$46","v":"Viviendas"},{"$f":"$C$46","v":"Viviendas"},null,{"$f":"$C$46","v":"Viviendas"},{"$f":"$C$46","v":"Viviendas"},null,{"$f":"$C$46","v":"Viviendas"},{"$f":"$C$46","v":"Viviendas"},null,{"$f":"$C$46","v":"Viviendas"},{"$f":"$C$46","v":"Viviendas"}]
[null,"Qu (Caudal unitario mayor en  l/s) ",{"$f":"MAX('Consumos TIPO'!F21:F31)","v":{"v":0.2,"d":"0.20"}},{"$f":"MAX('Consumos TIPO'!E21:E31)","v":{"v":0.3,"d":"0.30"}},null,{"$f":"MAX('Consumos TIPO'!L21:L32)","v":{"v":0.2,"d":"0.20"}},{"$f":"MAX('Consumos TIPO'!K21:K31)","v":{"v":0.4,"d":"0.40"}},null,{"$f":"MAX('Consumos TIPO'!Q21:Q31)","v":{"v":0.2,"d":"0.20"}},{"$f":"MAX('Consumos TIPO'!P21:P31)","v":{"v":0.30000000000000004,"d":"0.30"}},null,{"$f":"MAX('Consumos TIPO'!V21:V31)","v":{"v":0.2,"d":"0.20"}},{"$f":"MAX('Consumos TIPO'!U21:U31)","v":{"v":0.4,"d":"0.40"}},null,{"$f":"MAX('Consumos TIPO'!AA21:AA31)","v":{"v":0.2,"d":"0.20"}},{"$f":"MAX('Consumos TIPO'!Z21:Z31)","v":{"v":0.3,"d":"0.30"}}]
[null,"Qt (caudal total demandado en l/s)",{"$f":"'Consumos TIPO'!F36+'Consumos TIPO'!F37","v":0.91},{"$f":"'Consumos TIPO'!E36+'Consumos TIPO'!E37","v":1.65},null,{"$f":"'Consumos TIPO'!L33","v":1.01},{"$f":"'Consumos TIPO'!K33","v":{"v":1.8499999999999999,"d":"1.85"}},null,{"$f":"'Consumos TIPO'!Q33","v":{"v":0.975,"d":"0.98"}},{"$f":"'Consumos TIPO'!P33","v":{"v":1.8499999999999999,"d":"1.85"}},null,{"$f":"'Consumos TIPO'!V33","v":1.14},{"$f":"'Consumos TIPO'!U33","v":2.15},null,{"$f":"'Consumos TIPO'!AA33","v":0.68},{"$f":"'Consumos TIPO'!Z33","v":{"v":1.1500000000000001,"d":"1.15"}}]
[null,"fila por tipo edificio",{"$f":"VLOOKUP($C$46,$I$60:$K$65,3,FALSE)","v":{"v":1,"d":"1.0"}},{"$f":"VLOOKUP($D$46,$I$60:$K$65,3,FALSE)","v":{"v":1,"d":"1.0"}},null,{"$f":"VLOOKUP($C$46,$I$60:$K$65,3,FALSE)","v":{"v":1,"d":"1.0"}},{"$f":"VLOOKUP($D$46,$I$60:$K$65,3,FALSE)","v":{"v":1,"d":"1.0"}},null,{"$f":"VLOOKUP($C$46,$I$60:$K$65,3,FALSE)","v":{"v":1,"d":"1.0"}},{"$f":"VLOOKUP($D$46,$I$60:$K$65,3,FALSE)","v":{"v":1,"d":"1.0"}},null,{"$f":"VLOOKUP($C$46,$I$60:$K$65,3,FALSE)","v":{"v":1,"d":"1.0"}},{"$f":"VLOOKUP($D$46,$I$60:$K$65,3,FALSE)","v":{"v":1,"d":"1.0"}},null,{"$f":"VLOOKUP($C$46,$I$60:$K$65,3,FALSE)","v":{"v":1,"d":"1.0"}},{"$f":"VLOOKUP($D$46,$I$60:$K$65,3,FALSE)","v":{"v":1,"d":"1.0"}}]
[null,"Suplemento fila (segun Qu y Qt)",{"$f":"IF(C48>20,3,IF(C47<0.5,0,IF(C48<=1,1,2)))","v":{"v":0,"d":"0.0"}},{"$f":"IF(D48>20,3,IF(D47<0.5,0,IF(D48<=1,1,2)))","v":{"v":0,"d":"0.0"}},null,{"$f":"IF(F48>20,3,IF(F47<0.5,0,IF(F48<=1,1,2)))","v":{"v":0,"d":"0.0"}},{"$f":"IF(G48>20,3,IF(G47<0.5,0,IF(G48<=1,1,2)))","v":{"v":0,"d":"0.0"}},null,{"$f":"IF(I48>20,3,IF(I47<0.5,0,IF(I48<=1,1,2)))","v":{"v":0,"d":"0.0"}},{"$f":"IF(J48>20,3,IF(J47<0.5,0,IF(J48<=1,1,2)))","v":{"v":0,"d":"0.0"}},null,{"$f":"IF(L48>20,3,IF(L47<0.5,0,IF(L48<=1,1,2)))","v":{"v":0,"d":"0.0"}},{"$f":"IF(M48>20,3,IF(M47<0.5,0,IF(M48<=1,1,2)))","v":{"v":0,"d":"0.0"}},null,{"$f":"IF(O48>20,3,IF(O47<0.5,0,IF(O48<=1,1,2)))","v":{"v":0,"d":"0.0"}},{"$f":"IF(P48>20,3,IF(P47<0.5,0,IF(P48<=1,1,2)))","v":{"v":0,"d":"0.0"}}]
[null,"Fila edificio distinto escuelas",{"$f":"C49+C50","v":{"v":1,"d":"1.0"}},{"$f":"D49+D50","v":{"v":1,"d":"1.0"}},null,{"$f":"F49+F50","v":{"v":1,"d":"1.0"}},{"$f":"G49+G50","v":{"v":1,"d":"1.0"}},null,{"$f":"I49+I50","v":{"v":1,"d":"1.0"}},{"$f":"J49+J50","v":{"v":1,"d":"1.0"}},null,{"$f":"L49+L50","v":{"v":1,"d":"1.0"}},{"$f":"M49+M50","v":{"v":1,"d":"1.0"}},null,{"$f":"O49+O50","v":{"v":1,"d":"1.0"}},{"$f":"P49+P50","v":{"v":1,"d":"1.0"}}]
[null,"Fila para escuelas",{"$f":"1+IF(C48<=1.5,0,IF(C48<=20,1,2))","v":{"v":1,"d":"1.0"}},{"$f":"1+IF(D48<=1.5,0,IF(D48<=20,1,2))","v":{"v":2,"d":"2.0"}},null,{"$f":"1+IF(F48<=1.5,0,IF(F48<=20,1,2))","v":{"v":1,"d":"1.0"}},{"$f":"1+IF(G48<=1.5,0,IF(G48<=20,1,2))","v":{"v":2,"d":"2.0"}},null,{"$f":"1+IF(I48<=1.5,0,IF(I48<=20,1,2))","v":{"v":1,"d":"1.0"}},{"$f":"1+IF(J48<=1.5,0,IF(J48<=20,1,2))","v":{"v":2,"d":"2.0"}},null,{"$f":"1+IF(L48<=1.5,0,IF(L48<=20,1,2))","v":{"v":1,"d":"1.0"}},{"$f":"1+IF(M48<=1.5,0,IF(M48<=20,1,2))","v":{"v":2,"d":"2.0"}},null,{"$f":"1+IF(O48<=1.5,0,IF(O48<=20,1,2))","v":{"v":1,"d":"1.0"}},{"$f":"1+IF(P48<=1.5,0,IF(P48<=20,1,2))","v":{"v":1,"d":"1.0"}}]
[null,"Fila busqueda",{"$f":"IF(C46=$I$65,C52,C51)","v":{"v":1,"d":"1.0"}},{"$f":"IF(D46=$I$65,D52,D51)","v":{"v":1,"d":"1.0"}},null,{"$f":"IF(F46=$I$65,F52,F51)","v":{"v":1,"d":"1.0"}},{"$f":"IF(G46=$I$65,G52,G51)","v":{"v":1,"d":"1.0"}},null,{"$f":"IF(I46=$I$65,I52,I51)","v":{"v":1,"d":"1.0"}},{"$f":"IF(J46=$I$65,J52,J51)","v":{"v":1,"d":"1.0"}},null,{"$f":"IF(L46=$I$65,L52,L51)","v":{"v":1,"d":"1.0"}},{"$f":"IF(M46=$I$65,M52,M51)","v":{"v":1,"d":"1.0"}},null,{"$f":"IF(O46=$I$65,O52,O51)","v":{"v":1,"d":"1.0"}},{"$f":"IF(P46=$I$65,P52,P51)","v":{"v":1,"d":"1.0"}}]
[null,"Coeficiente A",{"$f":"INDEX($E$59:$G$81,$C$53,1)","v":{"v":0.682,"d":"0.68"}},{"$f":"INDEX($E$59:$G$81,$D$53,1)","v":{"v":0.682,"d":"0.68"}},null,{"$f":"INDEX($E$59:$G$81,$C$53,1)","v":{"v":0.682,"d":"0.68"}},{"$f":"INDEX($E$59:$G$81,$D$53,1)","v":{"v":0.682,"d":"0.68"}},null,{"$f":"INDEX($E$59:$G$81,$C$53,1)","v":{"v":0.682,"d":"0.68"}},{"$f":"INDEX($E$59:$G$81,$D$53,1)","v":{"v":0.682,"d":"0.68"}},null,{"$f":"INDEX($E$59:$G$81,$C$53,1)","v":{"v":0.682,"d":"0.68"}},{"$f":"INDEX($E$59:$G$81,$D$53,1)","v":{"v":0.682,"d":"0.68"}},null,{"$f":"INDEX($E$59:$G$81,$C$53,1)","v":{"v":0.682,"d":"0.68"}},{"$f":"INDEX($E$59:$G$81,$D$53,1)","v":{"v":0.682,"d":"0.68"}}]
[null,"Coeficiente B",{"$f":"INDEX($E$59:$G$81,$C$53,2)","v":0.45},{"$f":"INDEX($E$59:$G$81,$D$53,2)","v":0.45},null,{"$f":"INDEX($E$59:$G$81,$C$53,2)","v":0.45},{"$f":"INDEX($E$59:$G$81,$D$53,2)","v":0.45},null,{"$f":"INDEX($E$59:$G$81,$C$53,2)","v":0.45},{"$f":"INDEX($E$59:$G$81,$D$53,2)","v":0.45},null,{"$f":"INDEX($E$59:$G$81,$C$53,2)","v":0.45},{"$f":"INDEX($E$59:$G$81,$D$53,2)","v":0.45},null,{"$f":"INDEX($E$59:$G$81,$C$53,2)","v":0.45},{"$f":"INDEX($E$59:$G$81,$D$53,2)","v":0.45}]
[null,"Coeficiente C",{"$f":"INDEX($E$59:$G$81,$C$53,3)","v":-0.14},{"$f":"INDEX($E$59:$G$81,$D$53,3)","v":-0.14},null,{"$f":"INDEX($E$59:$G$81,$C$53,3)","v":-0.14},{"$f":"INDEX($E$59:$G$81,$D$53,3)","v":-0.14},null,{"$f":"INDEX($E$59:$G$81,$C$53,3)","v":-0.14},{"$f":"INDEX($E$59:$G$81,$D$53,3)","v":-0.14},null,{"$f":"INDEX($E$59:$G$81,$C$53,3)","v":-0.14},{"$f":"INDEX($E$59:$G$81,$D$53,3)","v":-0.14},null,{"$f":"INDEX($E$59:$G$81,$C$53,3)","v":-0.14},{"$f":"INDEX($E$59:$G$81,$D$53,3)","v":-0.14}]
[]
[null,null,"Qu","Qt","A","B","C",null,"Tipos edificios",null,"fila asociada"]
[1,{"$f":"I60","v":"Viviendas"},"<0,5","≤20",0.682,{"v":0.45,"d":"0.450"},{"v":-0.14,"d":"-0.140"}]
[{"$f":"A59+1","v":2},null,"≥0,5","≤1",{"v":1,"d":"1.000"},{"v":1,"d":"1.000"},{"v":0,"d":"0.000"},null,"Viviendas",null,1]
[{"$f":"A60+1","v":3},null,"≥0,5","≤20",{"v":1.7,"d":"1.700"},{"v":0.2,"d":"0.200"},{"v":-0.7,"d":"-0.700"},null,"Oficinas, estaciones, aeropuertos, etc",null,5]
[4,null,"Sin limite",">20",{"v":1.7,"d":"1.700"},{"v":0.21,"d":"0.210"},{"v":-0.7,"d":"-0.700"},null,"Hoteles, discotecas, museos",null,9]
[5,{"$f":"I61","v":"Oficinas, estaciones, aeropuertos, etc"},"<0,5","≤20",0.682,{"v":0.45,"d":"0.450"},{"v":-0.14,"d":"-0.140"},null,"Centros Comerciales",null,4]
[6,null,"≥0,5","≤1",{"v":1,"d":"1.000"},{"v":1,"d":"1.000"},{"v":0,"d":"0.000"},null,"Hospitales",null,5]
[7,null,"≥0,5","≤20",{"v":1.7,"d":"1.700"},{"v":0.21,"d":"0.210"},{"v":-0.7,"d":"-0.700"},null,"Escuelas, Polideportivos",null,6]
[8,null,"Sin limite",">20",{"v":0.4,"d":"0.400"},{"v":0.54,"d":"0.540"},{"v":0.48,"d":"0.480"}]
[9,{"$f":"I62","v":"Hoteles, discotecas, museos"},"<0,5","≤20",{"v":0.69,"d":"0.690"},{"v":0.5,"d":"0.500"},{"v":-0.12,"d":"-0.120"}]
[10,null,"≥0,5","≤1",{"v":1,"d":"1.000"},{"v":1,"d":"1.000"},{"v":0,"d":"0.000"}]
[11,null,"≥0,5","≤20",{"v":1,"d":"1.000"},0.366,{"v":0,"d":"0.000"}]
[12,null,"Sin limite",">20",{"v":1.08,"d":"1.080"},{"v":0.5,"d":"0.500"},{"v":-1.83,"d":"-1.830"}]
[13,{"$f":"I63","v":"Centros Comerciales"},"<0,5","≤20",0.698,{"v":0.5,"d":"0.500"},{"v":-0.12,"d":"-0.120"}]
[14,null,"≥0,5","≤1",{"v":1,"d":"1.000"},{"v":1,"d":"1.000"},{"v":0,"d":"0.000"}]
[15,null,"≥0,5","≤20",{"v":1,"d":"1.000"},0.366,{"v":0,"d":"0.000"}]
[16,null,"Sin limite",">20",{"v":4.3,"d":"4.300"},{"v":0.27,"d":"0.270"},{"v":-6.65,"d":"-6.650"}]
[17,{"$f":"I64","v":"Hospitales"},"<0,5","≤20",0.698,{"v":0.5,"d":"0.500"},{"v":-0.12,"d":"-0.120"}]
[18,null,"≥0,5","≤1",{"v":1,"d":"1.000"},{"v":1,"d":"1.000"},{"v":0,"d":"0.000"}]
[19,null,"≥0,5","≤20",{"v":1,"d":"1.000"},0.366,{"v":0,"d":"0.000"}]
[20,null,"Sin limite",">20",{"v":0.25,"d":"0.250"},{"v":0.65,"d":"0.650"},{"v":1.25,"d":"1.250"}]
[21,{"$f":"I65","v":"Escuelas, Polideportivos"},"Sin limite","≤1,5",{"v":1,"d":"1.000"},{"v":1,"d":"1.000"},{"v":0,"d":"0.000"}]
[22,null,"Sin limite","≤20",{"v":4.4,"d":"4.400"},{"v":0.27,"d":"0.270"},{"v":-3.4,"d":"-3.400"}]
[23,null,"Sin limite",">20",{"v":-22.5,"d":"-22.500"},{"v":-0.5,"d":"-0.500"},{"v":11.5,"d":"11.500"}]
[]
[]
[null,"Tabla tuberias termoplasticas"]
[{"$nulls":10},"PB"]
[null,"Series que existen en cada material",null,"PN20","PN16","PN12,5","PN10"]
[null,"Cobre","serie 2","serie 2,5","serie 3,2","serie 4","serie 5","serie 6,3","serie 8",null,{"$f":"'Consumos TIPO'!D12","v":"serie 5"},{"$nulls":3},"Serie activa",null,null,"PP (Polipropileno)","PEX (Polietileno reticulado)","HDPE  (Polietileno de Alta Densidad)","LDPE  (Polietileno de baja densidad)","PB (polibutileno)"," "]
[null,"PP (Polipropileno)","SI","SI","SI","---","SI","---","---",null,{"$f":"INDEX($C$88:$I$93,1,MATCH($K$87,$C$87:$I$87,0))","v":"SI"},"PP (Polipropileno)",{"$nulls":5},"serie 2","serie 3,2","serie 3,2","serie 3,2","serie 3,2"]
[null,"PEX (Polietileno reticulado)","---","---","SI","SI","SI","SI","---",null,{"$f":"INDEX($C$88:$I$93,2,MATCH($K$87,$C$87:$I$87,0))","v":"SI"},"PEX (Polietileno reticulado)",{"$nulls":5},"serie 2,5","serie 4","serie 4","serie 4","serie 4"]
[null,"HDPE  (Polietileno de Alta Densidad)","---","---","SI","SI","SI","SI","---",null,{"$f":"INDEX($C$88:$I$93,3,MATCH($K$87,$C$87:$I$87,0))","v":"SI"},"HDPE  (Polietileno de Alta Densidad)",{"$nulls":5},"serie 3,2","serie 5","serie 5","serie 5","serie 5"]
[null,"LDPE  (Polietileno de baja densidad)","---","---","SI","SI","SI","SI","---",null,{"$f":"INDEX($C$88:$I$93,4,MATCH($K$87,$C$87:$I$87,0))","v":"SI"},"LDPE  (Polietileno de baja densidad)",{"$nulls":5},"serie 5","serie 6,3","serie 6,3","serie 6,3","serie 6,3"]
[null,"PB (polibutileno)","---","---","SI","SI","SI","SI","SI",null,{"$f":"INDEX($C$88:$I$93,5,MATCH($K$87,$C$87:$I$87,0))","v":"SI"},"PB (polibutileno)",{"$nulls":9},"serie 8"]
[null,"PVC-C","---","---","---","SI","SI","SI","---",null,{"$f":"INDEX($C$88:$I$93,6,MATCH($K$87,$C$87:$I$87,0))","v":"SI"},"PVC-C"]
[null,"Columna",2,{"$f":"C94+2","v":4},6,8,10,12,14]
[{"$nulls":17},"selección"]
[null,null,"---","serie 2","---","serie 2,5","---","serie 3,2","---","serie 4","---","serie 5","---","serie 6,3","---","serie 8",null,{"$f":"'Consumos TIPO'!D12","v":"serie 5"}]
[null,"Diámetro comercial","Espesor","Dim int","Espesor","Dim int","Espesor","Dim int","Espesor","Dim int","Espesor","Dim int","Espesor","Dim int","Espesor","Dim int",null,"Dim int","Dim comer"]
[1,12,2.4,7.2,2,8,1.6,8.8,1.3,9.3,1.1,9.8,0.9,10.2,0.7,10.6,null,{"$f":"HLOOKUP($R$96,$C$96:$P$111,T98,FALSE)","v":9.8},12,3]
[{"$f":"A98+1","v":2},16,3.2,9.6,2.7,10.7,2.2,11.7,1.8,12.4,1.5,13.1,1.2,13.6,0.9,14.1,null,13.1,16,{"$f":"T98+1","v":4}]
[{"$f":"A99+1","v":3},20,4,12,3.3,13.3,2.7,14.6,2.2,15.6,1.8,16.4,1.5,17.1,1.2,17.6,null,16.4,20,{"$f":"T99+1","v":5}]
[4,25,5,15,4.2,16.7,3.4,18.2,2.8,19.4,2.3,20.5,1.8,21.3,1.5,22.1,null,20.5,25,6]
[5,32,6.4,19.2,5.3,21.3,4.3,23.4,3.6,24.9,2.9,26.2,2.4,27.3,1.9,28.2,null,26.2,32,7]
[6,40,8,24,6.7,26.7,5.4,29.2,4.4,31.1,3.6,32.7,2.9,34.1,2.4,35.3,null,32.7,40,8]
[7,50,10,30,8.3,33.3,6.8,36.5,5.6,38.9,4.5,40.9,3.7,42.6,2.9,44.1,null,40.9,50,9]
[8,63,12.6,37.8,10.5,42,8.5,46,7,49,5.7,51.5,4.6,53.7,3.7,55.6,null,51.5,63,10]
[9,75,15,45,12.5,50,10.1,54.7,8.3,58.3,6.8,61.4,5.5,64,4.4,66.2,null,61.4,75,11]
[10,90,18,54,15,60,12.2,65.7,10,70,8.2,73.6,6.6,76.8,5.3,79.4,null,73.6,90,12]
[11,110,22,66,18.3,73.3,14.9,80.3,12.2,85.6,10,90,8.1,93.8,6.5,97.1,null,90,110,13]
[12,125,25,75,20.8,83.3,16.9,91.2,13.9,97.2,11.4,102.3,9.2,106.6,7.4,110.3,null,102.3,125,14]
[13,140,28,84,23.3,93.3,18.9,102.2,15.6,108.9,12.7,114.5,10.3,119.4,8.2,123.5,null,114.5,140,15]
[14,160,32,96,26.7,106.7,21.6,116.8,17.8,124.4,14.5,130.9,11.8,136.5,9.4,141.2,null,130.9,160,16]
[]
[null,"Rugosidad absoluta tuberias (mm)"]
[]
[null,"PP (Polipropileno)",1.5E-3]
[null,"PEX (Polietileno reticulado)",1.5E-3]
[null,"HDPE  (Polietileno de Alta Densidad)",1.5E-3]
[null,"LDPE  (Polietileno de baja densidad)",1.5E-3]
[null,"PB (polibutileno)",1.5E-3]
[null,"PVC-C",1.5E-3]
[null,"PCV",0.02]
[null,"Cobre",1.5E-3]
[null,"Acero galvanizado",0.1]
[null,"Hormigon liso",0.5]
[null,"Hormigon rugoso",10]
[]
[]
[]
[]
[]
[]
[null,"Diámetros tuberias cobre"]
[]
[]
[null,"espesor 1mm"]
[null,"Dnominal","Dint","fila"]
[null,6,{"$f":"B137-2","v":4},1]
[null,8,{"$f":"B138-2","v":6},2]
[null,10,8,3]
[null,12,10,4]
[null,15,13,5]
[null,18,16,6]
[null,22,20,7]
[null,28,26,8]
[null,35,33,9]
[null,42,40,10]
{"$rows_empty":14}
[null,"Lista de tramos AF"]
[]
[null,null,"inicio",null,null,"nº tramos:",{"$f":"'Tramos AF'!A8","v":1}]
[null,1,{"$f":"IF(B164<G163,B164,\"\")","v":""}]
[null,2,{"$f":"IF(B165<G164,B165,\"\")","v":""}]
[null,3,""]
[null,4,""]
[null,5,""]
[null,6,""]
[null,7,""]
[null,8,""]
[null,9,""]
[null,10,""]
[null,11,""]
[null,12,""]
[null,13,""]
[null,14,""]
[null,15,""]
[null,16,""]
[null,17,""]
[null,18,""]
[null,19,""]
[null,20,""]
[null,21,""]
[null,22,""]
[null,23,""]
[null,24,""]
[null,25,""]
[null,26,""]
[null,27,""]
[null,28,""]
[null,29,""]
[null,30,""]
[null,31,""]
[null,32,""]
[null,33,""]
[null,34,""]
[null,35,""]
[]
[null,"Perdidas térmicas y aislamiento"]
[]
[null,null,"Ubicación"]
[null,"espesor (mm) aislamiento","Interior","Exterior"]
[null,0,30,40]
[null,36,35,45]
[null,61,35,45]
[null,91,35,45]
[null,141,40,50]
[]
[null,null,"espesor aislamiento"]
[null,"Perdidas (Salto 30ºC)",30,35,40,45,50]
[null,12,4.3,{"$f":"(C212+E212)/2","v":4.05},3.8,{"$f":"(E212+G212)/2","v":3.5999999999999996},{"$f":"3.4","v":3.4}]
[null,16,4.3,{"$f":"(C213+E213)/2","v":4.05},3.8,3.5999999999999996,{"$f":"3.4","v":3.4}]
[null,20,4.8,{"$f":"(C214+E214)/2","v":4.5},4.2,4,3.8]
[null,25,5.5,5.1,4.7,4.5,4.3]
[null,32,6.3,5.85,5.4,5.1,4.8]
[null,40,7.2,6.65,6.1,5.75,5.4]
[null,50,7.9,7.300000000000001,6.7,6.300000000000001,5.9]
[null,63,9.1,8.35,7.6,7.15,6.7]
[null,75,10.8,9.850000000000001,8.9,8.35,7.8]
[null,90,12.2,11.149999999999999,10.1,9.399999999999999,8.7]
[null,110,13.5,12.25,11,10.25,9.5]
[null,125,14.7,13.35,12,11.1,10.2]
[null,140,17.2,15.6,14,12.95,11.9]
[null,160,19.6,17.75,15.9,14.7,13.5]
[]
[null,"Diámetros tuberias retorno CTE HS4 "]
[]
[null,"diámetro nominal","l/h","l/s"]
[null,16,140,{"$f":"C230/3600","v":{"v":0.03888888888888889,"d":"0.039"}},16]
[null,20,300,{"v":0.08333333333333333,"d":"0.083"},20]
[null,25,600,{"v":0.16666666666666666,"d":"0.167"},25]
[null,32,1100,{"v":0.3055555555555556,"d":"0.306"},32]
[null,40,1800,{"v":0.5,"d":"0.500"},40]
[null,50,3300,{"v":0.9166666666666666,"d":"0.917"},50]
[]
[null,"Contadores"]

{"sheet":"RESUMEN","index":8,"n_rows":44,"n_cols":6,"rows_kept":44,"merged":[[1,2,1,5],[3,1,3,5],[33,1,33,5]]}
[]
[null,"Proyecto","25 viviendas Humanes"]
[]
[null,"Consumos tipo Agua Fria"]
[]
[null,{"$f":"'Consumos TIPO'!C46","v":"Termoplastico"},{"$f":"'Consumos TIPO'!D12","v":"serie 5"},"Qs (l/s)","Dnom (mm)","v(m/s)"]
[]
[null,{"$f":"'Consumos TIPO'!H9","v":"VIVIENDA TIPO A"},{"$f":"'Consumos TIPO'!D19","v":"Cocina + 2 baños (ducha + bañera)"},{"$f":"'Consumos TIPO'!E42","v":{"v":0.7143821169100553,"d":"0.71"}},{"$f":"'Consumos TIPO'!E46","v":25},{"$f":"'Consumos TIPO'!E48","v":{"v":2.164372241079824,"d":"2.16"}}]
[null,{"$f":"'Consumos TIPO'!H10","v":"VIVIENDA TIPO B"},{"$f":"'Consumos TIPO'!J19","v":"Duplex Cocina + 3 baños (2xducha + bañera)"},{"$f":"'Consumos TIPO'!K42","v":{"v":0.8009738886567287,"d":"0.80"}},{"$f":"'Consumos TIPO'!K46","v":25},{"$f":"'Consumos TIPO'!K48","v":{"v":2.426720391513742,"d":"2.43"}}]
[null,{"$f":"'Consumos TIPO'!H11","v":"VIVIENDA TIPO C"},{"$f":"'Consumos TIPO'!O19","v":"Cocina + 2 baños (ducha + bañera) + aseo"},{"$f":"'Consumos TIPO'!P42","v":{"v":0.8009738886567287,"d":"0.80"}},{"$f":"'Consumos TIPO'!P46","v":25},{"$f":"'Consumos TIPO'!P48","v":{"v":2.426720391513742,"d":"2.43"}}]
[null,{"$f":"'Consumos TIPO'!H12","v":"VIVIENDA TIPO D"},{"$f":"'Consumos TIPO'!T19","v":"Cocina + 3 baños (2 duchas + bañera)"},{"$f":"'Consumos TIPO'!U42","v":{"v":0.9308615462767388,"d":"0.93"}},{"$f":"'Consumos TIPO'!U46","v":25},{"$f":"'Consumos TIPO'!U48","v":{"v":2.820242617164619,"d":"2.82"}}]
[null,{"$f":"'Consumos TIPO'!H13","v":"VIVIENDA TIPO E"},{"$f":"'Consumos TIPO'!Y19","v":"Cocina + 1 baño"},{"$f":"'Consumos TIPO'!Z42","v":{"v":0.49790268754337197,"d":"0.50"}},{"$f":"'Consumos TIPO'!Z46","v":20},{"$f":"'Consumos TIPO'!Z48","v":{"v":2.357034164054733,"d":"2.36"}}]
[]
[null,null,{"$f":"'Consumos TIPO'!O9","v":"Basuras + Baldeo"},{"$f":"'Consumos TIPO'!P9","v":{"v":0.2,"d":"0.20"}},{"$f":"'Consumos TIPO'!R9","v":16},{"$f":"'Consumos TIPO'!Z9","v":{"v":1.483872230469337,"d":"1.48"}}]
[null,null,{"$f":"'Consumos TIPO'!O10","v":"Riego"},{"$f":"'Consumos TIPO'!P10","v":{"v":1,"d":"1.00"}},{"$f":"'Consumos TIPO'!R10","v":32},{"$f":"'Consumos TIPO'!Z10","v":{"v":1.8548402880866712,"d":"1.85"}}]
[null,null,{"$f":"'Consumos TIPO'!O11","v":"Sala Solar"},{"$f":"'Consumos TIPO'!P11","v":{"v":2.850682371881723,"d":"2.85"}},{"$f":"'Consumos TIPO'!R11","v":50},{"$f":"'Consumos TIPO'!Z11","v":{"v":2.1697580943393784,"d":"2.17"}}]
[null,null,{"$f":"'Consumos TIPO'!O12","v":"Piscina"},{"$f":"'Consumos TIPO'!P12","v":{"v":2,"d":"2.00"}},{"$f":"'Consumos TIPO'!R12","v":40},{"$f":"'Consumos TIPO'!Z12","v":{"v":2.381461656527629,"d":"2.38"}}]
[null,null,{"$f":"'Consumos TIPO'!O13","v":"Vestuarios"},{"$f":"'Consumos TIPO'!P13","v":{"v":0,"d":"0.00"}},{"$f":"'Consumos TIPO'!R13","v":16},{"$f":"'Consumos TIPO'!Z13","v":{"v":0,"d":"0.00"}}]
[]
[null,"TOTAL CONSUMO AF",null,{"$f":"'Consumos TIPO'!D13","v":{"v":3.137771446337956,"d":"3.14"}},{"$f":"'Tramos AF'!AA12","v":50},{"$f":"'Tramos AF'!AC12","v":{"v":2.946367479798517,"d":"2.95"}}]
[]
[null,"Perdida de carga lineal",{"$f":"'Tramos AF'!D6","v":{"v":6.32251834033779,"d":"6.32 mca"}}]
[null,"Altura suministro",{"$f":"'Grupo AF'!C8","v":{"v":17,"d":"17.00 m"}}]
[]
[null,"Perdida de carga TOTAL",{"$f":"'Grupo AF'!C12","v":{"v":37.97239203853636,"d":"37.97 mca"}}]
[null,"Caudal de suministro",{"$f":"D20","v":{"v":3.137771446337956,"d":"3.14 l/s"}}]
[]
[null,"Equipo seleccionado","EBARA AP MVP7-400/8-3"]
[null,"Bombas simultáneas",{"$f":"'Grupo AF'!C25","v":2}]
[null,"Bombas en reserva",{"$f":"'Grupo AF'!C26","v":1}]
[null,"Deposito de regulacion",{"$f":"'Grupo AF'!C21","v":{"v":1300,"d":"1,300 l"}}]
[null,"Depsito de membrana",{"$f":"'Grupo AF'!C38","v":{"v":200,"d":"200 l"}}]
[]
[null,"Consumos tipo ACS"]
[]
[null,{"$f":"B6","v":"Termoplastico"},{"$f":"C6","v":"serie 5"},"Qs (l/s)","Dnom (mm)","v(m/s)"]
[]
[null,{"$f":"B8","v":"VIVIENDA TIPO A"},{"$f":"C8","v":"Cocina + 2 baños (ducha + bañera)"},{"$f":"'Consumos TIPO'!F42","v":{"v":0.5136616429655582,"d":"0.51"}},{"$f":"'Consumos TIPO'!F46","v":20},{"$f":"'Consumos TIPO'!F48","v":{"v":2.4316358829230866,"d":"2.43"}}]
[null,{"$f":"B9","v":"VIVIENDA TIPO B"},"Duplex Cocina + 3 baños (2xducha + bañera)",{"$f":"'Consumos TIPO'!L42","v":{"v":0.5701079773573777,"d":"0.57"}},{"$f":"'Consumos TIPO'!L46","v":20},{"$f":"'Consumos TIPO'!L48","v":{"v":2.6988486173102393,"d":"2.70"}}]
[null,{"$f":"B10","v":"VIVIENDA TIPO C"},"Cocina + 2 baños (ducha + bañera) + aseo",{"$f":"'Consumos TIPO'!Q42","v":{"v":0.5503517603202408,"d":"0.55"}},{"$f":"'Consumos TIPO'!Q46","v":20},{"$f":"'Consumos TIPO'!Q48","v":{"v":2.6053241602747357,"d":"2.61"}}]
[null,{"$f":"B11","v":"VIVIENDA TIPO D"},"Cocina + 3 baños (2 duchas + bañera)",{"$f":"'Consumos TIPO'!V42","v":{"v":0.6434882120667431,"d":"0.64"}},{"$f":"'Consumos TIPO'!V46","v":25},{"$f":"'Consumos TIPO'!V48","v":{"v":1.9495841100886635,"d":"1.95"}}]
[null,{"$f":"B12","v":"VIVIENDA TIPO E"},"Cocina + 1 baño",{"$f":"'Consumos TIPO'!AA42","v":{"v":0.38383507386437316,"d":"0.38"}},{"$f":"'Consumos TIPO'!AA46","v":16},{"$f":"'Consumos TIPO'!AA48","v":{"v":2.8478110359374504,"d":"2.85"}}]
[]
[null,"TOTAL CONSUMO ACS",null,{"$f":"'Consumos TIPO'!D14","v":{"v":2.5915294289833843,"d":"2.59"}},{"$f":"'Tramos ACS'!AA12","v":50},{"$f":"'Tramos ACS'!AC12","v":{"v":2.47674066453487,"d":"2.48"}}]

{"sheet":"Graficos","index":9,"n_rows":43,"n_cols":12,"rows_kept":43,"hidden":true}
{"$rows_empty":42}
[{"$nulls":11},"Diámetro interior suministro:"]