{"text_format":"3","workbook":"xlsx","n_sheets":18,"sheets":["PERFORACIONES","TUBERIA Y FLUIDO","TERRENO","METODO","C.T. DIRECTO","C.T. GRADOS DIA","BOMBA DE CALOR","RESULTADOS","SENSIBILIDAD","DIM CALEFACCION","DIM REFRIGERACIÓN","DATOS TUBERIAS","DATOS FLUIDOS","PROPIEDAD FLUIDOS","DATOS SUELOS","INGRESO TERRENO","coefficients","Instructions"],"not_rendered":{"charts":1,"images":9,"macros":1,"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"PERFORACIONES","index":0,"n_rows":167,"n_cols":12,"rows_kept":167,"merged":[[0,0,0,3]]}
["CONFIGURACIÓN DE PERFORACIONES",{"$nulls":5},1,1,"1; Lineal 1X1",1,1,"1; Lineal 1X1"]
[{"$nulls":6},4,4,"4; Matricial 2X2",2,2]
["Tipo de perforación","Vertical",{"$nulls":4},5,4,"4; Lineal 4X1",4,1]
["Número de perforaciones",1,1,{"$nulls":3},6,5,"5; Lineal 5X1",5,1]
["Radio de perforacion",0.054,"m",{"$nulls":3},7,6,"6; Matricial 3X2",3,2]
["Distancia entre perforaciones",4.88,"m",{"$nulls":3},8,6,"6; Lineal 6X1",6,1]
["Geometría de perforación",1,{"$nulls":4},9,7,"7; Lineal 7X1",7,1]
["Conductividad Térmica Mortero",0.7,"W/m°K",{"$nulls":3},10,8,"8; Matricial 4X2",4,2]
["Ratio de diseño ",{"v":1,"d":"1.00"},{"$nulls":4},12,8,"8; Lineal 8X1",8,1]
[{"$nulls":6},14,9,"9; Matricial 3X3",3,3]
[{"$nulls":6},15,9,"9; Lineal 9X1",9,1]
[{"$nulls":6},16,10,"10; Matricial 5X2",5,2]
[{"$nulls":6},18,12,"12; Matricial 4X3",4,3]
[{"$nulls":6},20,12,"12; Matricial 6X2",6,2]
[{"$nulls":6},21,14,"14; Matricial 7X2",7,2]
[{"$nulls":6},22,15,"15; Matricial 5X3",5,3]
[{"$nulls":6},24,16,"16; Matricial 4X4",4,4]
[{"$nulls":6},25,16,"16; Matricial 8X2",8,2]
[{"$nulls":6},26,18,"18; Matricial 6X3",6,3]
[{"$nulls":6},27,18,"18; Matricial 9X2",9,2]
[{"$nulls":6},28,20,"20; Matricial 5X4",5,4]
[{"$nulls":6},30,20,"20; Matricial 10X2",10,2]
[{"$nulls":6},32,21,"21; Matricial 7X3",7,3]
[{"$nulls":6},33,22,"22; Matricial 11X2",11,2]
[{"$nulls":6},34,24,"24; Matricial 6X4",6,4]
[{"$nulls":6},35,24,"24; Matricial 8X3",8,3]
[{"$nulls":6},36,24,"24; Matricial 12X2",12,2]
[{"$nulls":6},39,25,"25; Matricial 5X5",5,5]
[{"$nulls":6},40,26,"26; Matricial 13X2",13,2]
[{"$nulls":6},42,27,"27; Matricial 9X3",9,3]
[{"$nulls":6},44,28,"28; Matricial 7X4",7,4]
[{"$nulls":6},45,28,"28; Matricial 14X2",14,2]
[{"$nulls":6},48,30,"30; Matricial 6X5",6,5]
[{"$nulls":6},49,30,"30; Matricial 10X3",10,3]
[{"$nulls":6},50,30,"30; Matricial 15X2",15,2]
[{"$nulls":6},51,32,"32; Matricial 8X4",8,4]
[{"$nulls":6},52,32,"32; Matricial 16X2",16,2]
[{"$nulls":6},54,33,"33; Matricial 11X3",11,3]
[{"$nulls":6},55,34,"34; Matricial 17X2",17,2]
[{"$nulls":6},56,35,"35; Matricial 7X5",7,5]
[{"$nulls":6},57,36,"36; Matricial 6X6",6,6]
[{"$nulls":6},60,36,"36; Matricial 9X4",9,4]
[{"$nulls":6},63,36,"36; Matricial 12X3",12,3]
[{"$nulls":6},64,36,"36; Matricial 18X2",18,2]
[{"$nulls":6},65,39,"39; Matricial 13X3",13,3]
[{"$nulls":6},66,40,"40; Matricial 8X5",8,5]
[{"$nulls":6},68,40,"40; Matricial 10X4",10,4]
[{"$nulls":6},69,42,"42; Matricial 7X6",7,6]
[{"$nulls":6},70,42,"42; Matricial 14X3",14,3]
[{"$nulls":6},72,44,"44; Matricial 11X4",11,4]
[{"$nulls":6},75,45,"45; Matricial 9X5",9,5]
[{"$nulls":6},76,45,"45; Matricial 15X3",15,3]
[{"$nulls":6},77,48,"48; Matricial 8X6",8,6]
[{"$nulls":6},78,48,"48; Matricial 12X4",12,4]
[{"$nulls":6},80,48,"48; Matricial 16X3",16,3]
[{"$nulls":6},81,49,"49; Matricial 7X7",7,7]
[{"$nulls":6},84,50,"50; Matricial 10X5",10,5]
[{"$nulls":6},85,51,"51; Matricial 17X3",17,3]
[{"$nulls":6},88,52,"52; Matricial 13X4",13,4]
[{"$nulls":6},90,54,"54; Matricial 9X6",9,6]
[{"$nulls":6},91,54,"54; Matricial 18X3",18,3]
[{"$nulls":6},92,55,"55; Matricial 11X5",11,5]
[{"$nulls":6},95,56,"56; Matricial 8X7",8,7]
[{"$nulls":6},96,56,"56; Matricial 14X4",14,4]
[{"$nulls":6},98,57,"57; Matricial 19X3",19,3]
[{"$nulls":6},99,60,"60; Matricial 10X6",10,6]
[{"$nulls":6},100,60,"60; Matricial 12X5",12,5]
[{"$nulls":6},102,60,"60; Matricial 15X4",15,4]
[{"$nulls":6},104,60,"60; Matricial 20X3",20,3]
[{"$nulls":6},105,63,"63; Matricial 9X7",9,7]
[{"$nulls":6},108,63,"63; Matricial 21X3",21,3]
[{"$nulls":6},110,64,"64; Matricial 8X8",8,8]
[{"$nulls":6},112,64,"64; Matricial 16X4",16,4]
[{"$nulls":6},114,65,"65; Matricial 13X5",13,5]
[{"$nulls":6},115,66,"66; Matricial 11X6",11,6]
[{"$nulls":6},116,66,"66; Matricial 22X3",22,3]
[{"$nulls":6},117,68,"68; Matricial 17X4",17,4]
[{"$nulls":6},119,69,"69; Matricial 23X3",23,3]
[{"$nulls":6},120,70,"70; Matricial 10X7",10,7]
[{"$nulls":6},121,70,"70; Matricial 14X5",14,5]
[{"$nulls":6},124,72,"72; Matricial 9X8",9,8]
[{"$nulls":6},125,72,"72; Matricial 12X6",12,6]
[{"$nulls":6},126,72,"72; Matricial 18X4",18,4]
[{"$nulls":6},128,72,"72; Matricial 24X3",24,3]
[{"$nulls":6},130,75,"75; Matricial 15X5",15,5]
[{"$nulls":6},132,75,"75; Matricial 25X3",25,3]
[{"$nulls":6},133,76,"76; Matricial 19X4",19,4]
[{"$nulls":6},135,77,"77; Matricial 11X7",11,7]
[{"$nulls":6},136,78,"78; Matricial 13X6",13,6]
[{"$nulls":6},138,78,"78; Matricial 26X3",26,3]
[{"$nulls":6},140,80,"80; Matricial 10X8",10,8]
[{"$nulls":6},143,80,"80; Matricial 16X5",16,5]
[{"$nulls":6},144,80,"80; Matricial 20X4",20,4]
[{"$nulls":7},81,"81; Matricial 9X9",9,9]
[{"$nulls":7},81,"81; Matricial 27X3",27,3]
[{"$nulls":7},84,"84; Matricial 12X7",12,7]
[{"$nulls":7},84,"84; Matricial 14X6",14,6]
[{"$nulls":7},84,"84; Matricial 21X4",21,4]
[{"$nulls":7},85,"85; Matricial 17X5",17,5]
[{"$nulls":7},88,"88; Matricial 11X8",11,8]
[{"$nulls":7},88,"88; Matricial 22X4",22,4]
[{"$nulls":7},90,"90; Matricial 10X9",10,9]
[{"$nulls":7},90,"90; Matricial 15X6",15,6]
[{"$nulls":7},90,"90; Matricial 18X5",18,5]
[{"$nulls":7},91,"91; Matricial 13X7",13,7]
[{"$nulls":7},92,"92; Matricial 23X4",23,4]
[{"$nulls":7},95,"95; Matricial 19X5",19,5]
[{"$nulls":7},96,"96; Matricial 12X8",12,8]
[{"$nulls":7},96,"96; Matricial 16X6",16,6]
[{"$nulls":7},96,"96; Matricial 24X4",24,4]
[{"$nulls":7},98,"98; Matricial 14X7",14,7]
[{"$nulls":7},99,"99; Matricial 11X9",11,9]
[{"$nulls":7},100,"100; Matricial 10X10",10,10]
[{"$nulls":7},100,"100; Matricial 20X5",20,5]
[{"$nulls":7},100,"100; Matricial 25X4",25,4]
[{"$nulls":7},102,"102; Matricial 17X6",17,6]
[{"$nulls":7},104,"104; Matricial 13X8",13,8]
[{"$nulls":7},104,"104; Matricial 26X4",26,4]
[{"$nulls":7},105,"105; Matricial 15X7",15,7]
[{"$nulls":7},105,"105; Matricial 21X5",21,5]
[{"$nulls":7},108,"108; Matricial 12X9",12,9]
[{"$nulls":7},108,"108; Matricial 18X6",18,6]
[{"$nulls":7},108,"108; Matricial 27X4",27,4]
[{"$nulls":7},110,"110; Matricial 11X10",11,10]
[{"$nulls":7},110,"110; Matricial 22X5",22,5]
[{"$nulls":7},112,"112; Matricial 14X8",14,8]
[{"$nulls":7},112,"112; Matricial 16X7",16,7]
[{"$nulls":7},112,"112; Matricial 28X4",28,4]
[{"$nulls":7},114,"114; Matricial 19X6",19,6]
[{"$nulls":7},115,"115; Matricial 23X5",23,5]
[{"$nulls":7},116,"116; Matricial 29X4",29,4]
[{"$nulls":7},117,"117; Matricial 13X9",13,9]
[{"$nulls":7},119,"119; Matricial 17X7",17,7]
[{"$nulls":7},120,"120; Matricial 12X10",12,10]
[{"$nulls":7},120,"120; Matricial 15X8",15,8]
[{"$nulls":7},120,"120; Matricial 20X6",20,6]
[{"$nulls":7},120,"120; Matricial 24X5",24,5]
[{"$nulls":7},120,"120; Matricial 30X4",30,4]
[{"$nulls":7},121,"121; Matricial 11X11",11,11]
[{"$nulls":7},124,"124; Matricial 31X4",31,4]
[{"$nulls":7},125,"125; Matricial 25X5",25,5]
[{"$nulls":7},126,"126; Matricial 14X9",14,9]
[{"$nulls":7},126,"126; Matricial 18X7",18,7]
[{"$nulls":7},126,"126; Matricial 21X6",21,6]
[{"$nulls":7},128,"128; Matricial 16X8",16,8]
[{"$nulls":7},128,"128; Matricial 32X4",32,4]
[{"$nulls":7},130,"130; Matricial 13X10",13,10]
[{"$nulls":7},130,"130; Matricial 26X5",26,5]
[{"$nulls":7},132,"132; Matricial 12X11",12,11]
[{"$nulls":7},132,"132; Matricial 22X6",22,6]
[{"$nulls":7},132,"132; Matricial 33X4",33,4]
[{"$nulls":7},133,"133; Matricial 19X7",19,7]
[{"$nulls":7},135,"135; Matricial 15X9",15,9]
[{"$nulls":7},135,"135; Matricial 27X5",27,5]
[{"$nulls":7},136,"136; Matricial 17X8",17,8]
[{"$nulls":7},136,"136; Matricial 34X4",34,4]
[{"$nulls":7},138,"138; Matricial 23X6",23,6]
[{"$nulls":7},140,"140; Matricial 14X10",14,10]
[{"$nulls":7},140,"140; Matricial 20X7",20,7]
[{"$nulls":7},140,"140; Matricial 28X5",28,5]
[{"$nulls":7},140,"140; Matricial 35X4",35,4]
[{"$nulls":7},143,"143; Matricial 13X11",13,11]
[{"$nulls":7},144,"144; Matricial 12X12",12,12]
[{"$nulls":7},144,"144; Matricial 16X9",16,9]
[{"$nulls":7},144,"144; Matricial 18X8",18,8]
[{"$nulls":7},144,"144; Matricial 24X6",24,6]
[{"$nulls":7},144,"144; Matricial 36X4",36,4]

{"sheet":"TUBERIA Y FLUIDO","index":1,"n_rows":13,"n_cols":11,"rows_kept":13,"merged":[[0,0,0,2],[0,3,0,6]]}
["SELECCIÓN TUBERIA",null,null,"SELECCIÓN FLUIDO",{"$nulls":3},{"$f":"B9","v":0.025},{"$f":"IF(B3=\"Polietileno\",\"PE32\",\"PB4\")","v":"PE32"},{"$f":"IF(B4=\"PE32\",\"PN4\",IF(OR(B4=\"PE50A\",B4=\"PE50B\",B4=\"PE80\",B4=\"PE100\"),\"PN6\",\"PN8\"))","v":"PN6"},{"$f":"IF(OR(AND(B4=\"PE50A\",B5=\"PN6\"),AND(B4=\"PE50A\",B5=\"PN16\"),AND(B4=\"PE50B\",B5=\"PN6\"),AND(B4=\"PE80\",B5=\"PN6\"),AND(B4=\"PE100\",B5=\"PN25\")),\"\",\"3/4''\")","v":""}]
[{"$nulls":7},{"$f":"B9+0.006","v":0.031},{"$f":"IF(B3=\"Polietileno\",\"PE50A\",\"PB5\")","v":"PE50A"},{"$f":"IF(B4=\"PE32\",\"PN6\",IF(OR(B4=\"PE50A\",B4=\"PE50B\",B4=\"PE80\",B4=\"PE100\"),\"PN10\",\"PN10\"))","v":"PN10"},{"$f":"IF(OR(AND(B4=\"PE50A\",B5=\"PN16\"),AND(B4=\"PE80\",B5=\"PN6\"),AND(B4=\"PB4\",B5=\"PN8\")),\"\",\"1''\")","v":"1''"}]
["Material","Polietileno",null,"Fluido","Agua Pura",null,null,{"$f":"(2*PERFORACIONES!B5-2*B9)/3+B9","v":{"v":0.044333333333333336,"d":"0.044"}},{"$f":"IF(B3=\"Polietileno\",\"PE50B\",\"\")","v":"PE50B"},{"$f":"IF(B4=\"PE32\",\"PN10\",IF(OR(B4=\"PE50A\",B4=\"PE50B\",B4=\"PE100\"),\"PN16\",\"\"))","v":"PN16"},{"$f":"IF(OR(AND(B4=\"PE80\",B5=\"PN6\"),AND(B4=\"PB4\",B5=\"PN8\")),\"\",\"1 1/4''\")","v":"1 1/4''"}]
["Tipo","PE50A",null,"% en peso Anticongelante",0,"%",null,{"$f":"2*PERFORACIONES!B5-B9","v":{"v":0.08299999999999999,"d":"0.083"}},{"$f":"IF(B3=\"Polietileno\",\"PE80\",\"\")","v":"PE80"},{"$f":"IF(B4=\"PE100\",\"PN25\",\"\")","v":""},{"$f":"IF(OR(AND(B4=\"PB4\",B5=\"PN8\")),\"\",\"1 1/2''\")","v":"1 1/2''"}]
["Presión Nominal","PN6",null,"Temperatura media fluido",32,"°C",null,null,{"$f":"IF(B3=\"Polietileno\",\"PE100\",\"\")","v":"PE100"},null,{"$f":"IF(OR(AND(B4=\"PB4\",B5=\"PN8\"),AND(B4=\"PB4\",B5=\"PN10\")),\"\",\"2''\")","v":"2''"}]
["Diámetro Nominal","1''",null,"Flujo total del sistema",{"v":1044.6,"d":"1,044.6"},"l/h",{"$nulls":4},{"$f":"IF(OR(AND(B4=\"PB4\",B5=\"PN8\"),AND(B4=\"PB4\",B5=\"PN10\")),\"\",\"2 1/2''\")","v":"2 1/2''"}]
["Distancia centro-centro U-tube",0.065,"m","Flujo por perforación",{"$f":"E6/PERFORACIONES!C4","v":{"v":1044.6,"d":"1045"}},"l/h"]
["Diametro Interno",{"$f":"VLOOKUP(CONCATENATE(B3,B4,B5,B6),'DATOS TUBERIAS'!$A$2:$H$108,7,FALSE)/1000","v":0.021},"m","Densidad ",{"$f":"VLOOKUP(E3,'DATOS FLUIDOS'!$A$2:$G$4,4,FALSE)","v":998.1},"kg/m3"]
["Diametro Externo",{"$f":"VLOOKUP(CONCATENATE(B3,B4,B5,B6),'DATOS TUBERIAS'!$A$2:$H$108,6,FALSE)/1000","v":0.025},"m","Capacidad Térmica",{"$f":"VLOOKUP(E3,'DATOS FLUIDOS'!$A$2:$G$4,5,FALSE)","v":{"v":4173,"d":"4,173.0"}},"J/kg°K"]
["Conductividad Térmica",{"$f":"VLOOKUP(CONCATENATE(B3,B4,B5,B6),'DATOS TUBERIAS'!$A$2:$H$108,8,FALSE)","v":{"v":0.43,"d":"0.430"}},"W/m°K","Conductividad Térmica",{"$f":"VLOOKUP(E3,'DATOS FLUIDOS'!$A$2:$G$4,6,FALSE)","v":{"v":0.5929,"d":"0.593"}},"W/m°K"]
[{"$nulls":3},"Viscosidad",{"$f":"VLOOKUP(E3,'DATOS FLUIDOS'!$A$2:$G$4,7,FALSE)","v":{"v":0.001002,"d":"0.00100"}},"Pa s"]
[{"$nulls":3},"Coeficiente de convección",{"$f":"'PROPIEDAD FLUIDOS'!H27*1000/3600","v":{"v":3737.2587904026327,"d":"3,737"}},"W/m2°K"]
[{"$nulls":3},"N° de Reynolds",{"$f":"'PROPIEDAD FLUIDOS'!H7","v":{"v":17524.461381157435,"d":"17,524"}}]

{"sheet":"TERRENO","index":2,"n_rows":7,"n_cols":3,"rows_kept":7,"merged":[[0,0,0,3]]}
["SELECCIÓN DEL TERRENO"]
[]
["Tipo Suelo","DEFINIDO POR EL USUARIO - Fort Polk"]
["Temperatura imperturbable",19.9,"°C"]
["Conductividad Térmica",{"$f":"VLOOKUP($B$3,'DATOS SUELOS'!$A$4:$F$42,4,FALSE)","v":2.423},"W/m°K"]
["Capacidad Térmica",{"$f":"VLOOKUP($B$3,'DATOS SUELOS'!$A$4:$F$42,6,FALSE)","v":2.676},"MJ/m3°K"]
["Difusividad Térmica",{"$f":"B5*3600*24/(B6*1000000)","v":{"v":0.07823139013452914,"d":"0.078"}},"m2/día"]

{"sheet":"METODO","index":3,"n_rows":3,"n_cols":4,"rows_kept":3,"merged":[[0,0,0,4]]}
["SELECCIÓN MÉTODO INGRESO DE CARGAS TÉRMICAS"]
[]
[1,"MÉTODO DIRECTO",null,"MÉTODO GRADOS DÍA"]

{"sheet":"C.T. DIRECTO","index":4,"n_rows":14,"n_cols":8,"rows_kept":14,"merged":[[0,0,0,7]]}
["INGRESO CARGAS TÉRMICAS - METODO DIRECTO"]
["Mes","Total Calefacción\nkWh","Total Refrigeración\nkWh","Pot. Max. Calefacción\nkW","Pot. Max. Refrigeración\nkW","Calor Absorbido\nkWh","Calor Inyectado\nkWh"]
["Enero",{"v":868.08,"d":"868.1"},{"v":0,"d":"0.0"},{"v":4.63,"d":"4.6"},{"v":0,"d":"0.0"},{"v":645.05,"d":"645.1"},{"v":0,"d":"0.0"},31]
["Febrero",{"v":550.39,"d":"550.4"},{"v":0,"d":"0.0"},{"v":4.48,"d":"4.5"},{"v":0,"d":"0.0"},{"v":408.25,"d":"408.3"},{"v":0,"d":"0.0"},28]
["Marzo",{"v":344.07,"d":"344.1"},{"v":0,"d":"0.0"},{"v":3.66,"d":"3.7"},{"v":0,"d":"0.0"},{"v":254.09,"d":"254.1"},{"v":0,"d":"0.0"},31]
["Abril",{"v":0,"d":"0.0"},{"v":83.82,"d":"83.8"},{"v":0,"d":"0.0"},{"v":3.17,"d":"3.2"},{"v":0,"d":"0.0"},{"v":97.01,"d":"97.0"},30]
["Mayo",{"v":0,"d":"0.0"},532.8,{"v":0,"d":"0.0"},{"v":4.48,"d":"4.5"},{"v":0,"d":"0.0"},{"v":625.12,"d":"625.1"},31]
["Junio",{"v":0,"d":"0.0"},{"v":837.01,"d":"837.0"},{"v":0,"d":"0.0"},{"v":4.81,"d":"4.8"},{"v":0,"d":"0.0"},{"v":987.36,"d":"987.4"},30]
["Julio",{"v":0,"d":"0.0"},{"v":1821.14,"d":"1,821.1"},{"v":0,"d":"0.0"},{"v":5.25,"d":"5.3"},{"v":0,"d":"0.0"},{"v":2263.68,"d":"2,263.7"},31]
["Agosto",{"v":0,"d":"0.0"},{"v":1825.54,"d":"1,825.5"},{"v":0,"d":"0.0"},{"v":5.66,"d":"5.7"},{"v":0,"d":"0.0"},{"v":2271.59,"d":"2,271.6"},31]
["Septiembre",{"v":0,"d":"0.0"},{"v":1205.69,"d":"1,205.7"},{"v":0,"d":"0.0"},5.1,{"v":0,"d":"0.0"},{"v":1491.44,"d":"1,491.4"},30]
["Octubre",{"v":86.75,"d":"86.8"},97.3,{"v":1.17,"d":"1.2"},{"v":3.63,"d":"3.6"},{"v":58.91,"d":"58.9"},{"v":120.16,"d":"120.2"},31]
["Noviembre",{"v":35.46,"d":"35.5"},{"v":0,"d":"0.0"},{"v":3.55,"d":"3.6"},{"v":0,"d":"0.0"},{"v":26.08,"d":"26.1"},{"v":0,"d":"0.0"},30]
["Diciembre",{"v":301.86,"d":"301.9"},{"v":0,"d":"0.0"},{"v":4.37,"d":"4.4"},{"v":0,"d":"0.0"},{"v":223.03,"d":"223.0"},{"v":0,"d":"0.0"},31]

{"sheet":"C.T. GRADOS DIA","index":5,"n_rows":24,"n_cols":6,"rows_kept":24,"merged":[[0,0,0,5],[7,1,7,2],[7,3,7,4]]}
["INGRESO CARGAS TÉRMICAS - MÉTODO GRADOS DIAS"]
[]
["Coef. Volumétrico de pérdidas",0.89,"W/°C m3"]
["Volumen a climatizar",224,"m3"]
["Coef. Uso de la instalación",1]
["Coef. Intermitencia instalación",0.85]
[]
[null,"CALEFACCIÓN",null,"REFRIGERACIÓN"]
["Temperatura Interior de Proyecto",21.1,"°C",23.3,"°C"]
["Temperatura Exterior de Proyecto",-5,"°C",35,"°C"]
[]
["MES","Grados día","Consumo [KWh]","Grados día","Consumo [KWh]"]
["Enero",502,{"$f":"$B$3*$B$4*$B$5*$B$6*B13*0.024","v":{"v":2041.6058880000003,"d":"2,041.6"}},16,{"$f":"$B$3*$B$4*$B$5*$B$6*D13*0.024","v":{"v":65.071104,"d":"65.1"}},31]
["Febrero",374,{"$f":"$B$3*$B$4*$B$5*$B$6*B14*0.024","v":{"v":1521.0370560000003,"d":"1,521.0"}},28,{"$f":"$B$3*$B$4*$B$5*$B$6*D14*0.024","v":{"v":113.874432,"d":"113.9"}},28]
["Marzo",219,{"v":890.660736,"d":"890.7"},84,{"v":341.62329600000004,"d":"341.6"},31]
["Abril",79,{"v":321.28857600000003,"d":"321.3"},174,{"v":707.6482560000002,"d":"707.6"},30]
["Mayo",16,{"v":65.071104,"d":"65.1"},333,{"v":1354.2923520000002,"d":"1,354.3"},31]
["Junio",0,{"v":0,"d":"0.0"},503,{"v":2045.6728320000002,"d":"2,045.7"},30]
["Julio",0,{"v":0,"d":"0.0"},535,{"v":2175.8150400000004,"d":"2,175.8"},31]
["Agosto",0,{"v":0,"d":"0.0"},563,{"v":2289.689472,"d":"2,289.7"},31]
["Septiembre",7,{"v":28.468608,"d":"28.5"},366,{"v":1488.5015040000003,"d":"1,488.5"},30]
["Octubre",120,{"v":488.03328000000005,"d":"488.0"},176,{"v":715.782144,"d":"715.8"},31]
["Noviembre",267,{"v":1085.8740480000001,"d":"1,085.9"},54,{"v":219.61497600000004,"d":"219.6"},30]
["Diciembre",460,{"v":1870.7942400000002,"d":"1,870.8"},21,{"v":85.40582400000001,"d":"85.4"},31]

{"sheet":"BOMBA DE CALOR","index":6,"n_rows":10,"n_cols":4,"rows_kept":10,"merged":[[0,0,0,4]]}
["CONFIGURACION BOMBA DE CALOR"]
[]
[null,"CALEFACCION","REFRIGERACION"]
["Temperatura Entrada Fluido",0,29.44,"°C"]
["COP Bomba de Calor",4.08,3.89]
["Potencia Nominal Bomba de Calor",3.63,5.33,"kW"]
["Potencia Máxima Demandada",{"$f":"IF(METODO!A3=1,MAX('C.T. DIRECTO'!$D$3:$D$14),'C.T. GRADOS DIA'!B3*'C.T. GRADOS DIA'!B4*('C.T. GRADOS DIA'!B9-'C.T. GRADOS DIA'!B10)/1000)","v":{"v":4.63,"d":"4.6"}},{"$f":"IF(METODO!A3=1,MAX('C.T. DIRECTO'!$E$3:$E$14),'C.T. GRADOS DIA'!B3*'C.T. GRADOS DIA'!B4*('C.T. GRADOS DIA'!D10-'C.T. GRADOS DIA'!D9)/1000)","v":{"v":5.66,"d":"5.7"}},"kW"]
["Carga máxima al terreno por hora",{"$f":"B7-B7/B5","v":{"v":3.4951960784313725,"d":"3.5"}},{"$f":"C7+C7/C5","v":{"v":7.1150128534704375,"d":"7.1"}},"kW"]
["Carga máxima al terreno por mes",{"$f":"IF(METODO!A3=1,VLOOKUP($B$7,'C.T. DIRECTO'!$D$3:$F$14,3,FALSE)/(VLOOKUP($B$7,'C.T. DIRECTO'!$D$3:$H$14,5,FALSE)*24),MAX('C.T. GRADOS DIA'!C13:C24)/(VLOOKUP(MAX('C.T. GRADOS DIA'!C13:C24),'C.T. GRADOS DIA'!C13:F24,4,FALSE)*24)-(MAX('C.T. GRADOS DIA'!C13:C24)/(VLOOKUP(MAX('C.T. GRADOS DIA'!C13:C24),'C.T. GRADOS DIA'!C13:F24,4,FALSE)*24))/B5)","v":{"v":0.867002688172043,"d":"0.9"}},{"$f":"IF(METODO!A3=1,VLOOKUP($C$7,'C.T. DIRECTO'!$E$3:$G$14,3,FALSE)/(VLOOKUP($C$7,'C.T. DIRECTO'!$E$3:$H$14,4,FALSE)*24),MAX('C.T. GRADOS DIA'!E13:E24)/(VLOOKUP(MAX('C.T. GRADOS DIA'!E13:E24),'C.T. GRADOS DIA'!E13:F24,2,FALSE)*24)+(MAX('C.T. GRADOS DIA'!E13:E24)/(VLOOKUP(MAX('C.T. GRADOS DIA'!E13:E24),'C.T. GRADOS DIA'!E13:F24,2,FALSE)*24))/C5)","v":{"v":3.053212365591398,"d":"3.1"}},"kW"]
["Carga promedio al terreno  por año",{"$f":"IF(METODO!A3=1,ABS((SUM('C.T. DIRECTO'!$F$3:$F$14)-SUM('C.T. DIRECTO'!$G$3:$G$14))/8760),ABS(((SUM('C.T. GRADOS DIA'!C13:C24)-SUM('C.T. GRADOS DIA'!C13:C24)/B5)-(SUM('C.T. GRADOS DIA'!E13:E24)+SUM('C.T. GRADOS DIA'!E13:E24)/C5))/8760))","v":{"v":0.7124372146118723,"d":"0.71"}},{"$f":"IF(METODO!A3=1,ABS((SUM('C.T. DIRECTO'!$F$3:$F$14)-SUM('C.T. DIRECTO'!$G$3:$G$14))/8760),ABS(((SUM('C.T. GRADOS DIA'!C13:C24)-SUM('C.T. GRADOS DIA'!C13:C24)/B5)-(SUM('C.T. GRADOS DIA'!E13:E24)+SUM('C.T. GRADOS DIA'!E13:E24)/C5))/8760))","v":{"v":0.7124372146118723,"d":"0.71"}},"kW"]

{"sheet":"RESULTADOS","index":7,"n_rows":20,"n_cols":7,"rows_kept":20,"merged":[[0,0,0,7],[2,0,3,0],[5,0,7,0],[9,0,12,0],[14,0,15,0],[17,0,19,0]]}
["RESULTADOS"]
[{"$nulls":3},"CALEFACCIÓN",null,"REFRIGERACIÓN"]
["GENERAL","Longitud Total","L",{"$f":"IF(PERFORACIONES!B4=1,'DIM CALEFACCION'!D35,'DIM CALEFACCION'!E69)","v":{"v":55.23783546342679,"d":"55.2"}},null,{"$f":"IF(PERFORACIONES!B4=1,'DIM REFRIGERACIÓN'!D35,'DIM REFRIGERACIÓN'!E69)","v":{"v":198.38187917132535,"d":"198.4"}},"m"]
[null,"Longitud por Perforación","H",{"$f":"IF(PERFORACIONES!B4=1,'DIM CALEFACCION'!D35,'DIM CALEFACCION'!E70)","v":{"v":55.23783546342679,"d":"55.2"}},null,{"$f":"IF(PERFORACIONES!B4=1,'DIM REFRIGERACIÓN'!D35,'DIM REFRIGERACIÓN'!E70)","v":{"v":198.38187917132535,"d":"198.4"}},"m"]
[]
["TERRENO","Resistencia Térmica Terreno 6h","R6h",{"$f":"'DIM CALEFACCION'!D29","v":{"v":0.09743189273030176,"d":"0.097"}},null,{"$f":"'DIM REFRIGERACIÓN'!D29","v":{"v":0.09743189273030176,"d":"0.097"}},"m°K/W"]
[null,"Resistencia Térmica Terreno 1m","R1m",{"$f":"'DIM CALEFACCION'!D30","v":{"v":0.14942257386901625,"d":"0.149"}},null,{"$f":"'DIM REFRIGERACIÓN'!D30","v":{"v":0.14942257386901625,"d":"0.149"}},"m°K/W"]
[null,"Resistencia Térmica Terreno 10y","R10y",{"$f":"'DIM CALEFACCION'!D31","v":{"v":0.15754126744095104,"d":"0.158"}},null,{"$f":"'DIM REFRIGERACIÓN'!D31","v":{"v":0.15754126744095104,"d":"0.158"}},"m°K/W"]
[]
["PERFORACIÓN","Resistencia Térmica Convectiva","Rconv",{"$f":"'DIM CALEFACCION'!D24","v":{"v":0.004055810549358974,"d":"0.004"}},null,{"$f":"'DIM REFRIGERACIÓN'!D24","v":{"v":0.004055810549358974,"d":"0.004"}},"m°K/W"]
[null,"Resistencia Térmica Tubería","Rp",{"$f":"'DIM CALEFACCION'!D25","v":{"v":0.06453303118350302,"d":"0.065"}},null,{"$f":"'DIM REFRIGERACIÓN'!D25","v":{"v":0.06453303118350302,"d":"0.065"}},"m°K/W"]
[null,"Resistencia Térmica Mortero","Rg",{"$f":"'DIM CALEFACCION'!D26","v":{"v":0.1364473126474551,"d":"0.136"}},null,{"$f":"'DIM REFRIGERACIÓN'!D26","v":{"v":0.1364473126474551,"d":"0.136"}},"m°K/W"]
[null,"Resietencia Térmica Perforación","Rb",{"$f":"'DIM CALEFACCION'!D27","v":{"v":0.1707417335138861,"d":"0.171"}},null,{"$f":"'DIM REFRIGERACIÓN'!D27","v":{"v":0.1707417335138861,"d":"0.171"}},"m°K/W"]
[]
["BOMBA DE CALOR","T° salida fluido bomba de calor","ToutHP",{"$f":"'DIM CALEFACCION'!D33","v":{"v":-2.89202194022162,"d":"-2.89"}},null,{"$f":"'DIM REFRIGERACIÓN'!D33","v":{"v":35.32715849281626,"d":"35.33"}},"°C"]
[null,"T° media fluido en perforación","Tm",{"$f":"'DIM CALEFACCION'!D34","v":{"v":-1.44601097011081,"d":"-1.45"}},null,{"$f":"'DIM REFRIGERACIÓN'!D34","v":{"v":32.38357924640813,"d":"32.38"}},"°C"]
[]
["INTERACCION PERFORACIONES","Ratio distancia-profundidad","B/H",{"$f":"IF(PERFORACIONES!B4=1,\"-\",'DIM CALEFACCION'!E64)","v":"-"},null,{"$f":"IF(PERFORACIONES!B4=1,\"-\",'DIM REFRIGERACIÓN'!E64)","v":"-"},"-"]
[null,"Logaritmo del tiempo adimensional","ln(t10y/ts)",{"$f":"IF(PERFORACIONES!B4=1,\"-\",'DIM CALEFACCION'!E65)","v":"-"},null,{"$f":"IF(PERFORACIONES!B4=1,\"-\",'DIM REFRIGERACIÓN'!E65)","v":"-"},"-"]
[null,"Penalización en temperatura","Tp",{"$f":"IF(PERFORACIONES!B4=1,\"-\",'DIM CALEFACCION'!E66)","v":"-"},null,{"$f":"IF(PERFORACIONES!B4=1,\"-\",'DIM REFRIGERACIÓN'!E66)","v":"-"},"°C"]

{"sheet":"SENSIBILIDAD","index":8,"n_rows":23,"n_cols":19,"rows_kept":23,"merged":[[0,1,0,3],[0,4,0,6],[0,7,0,9],[0,10,0,12],[0,13,0,15],[0,16,0,18]]}
[null,"Variación Distancia U-Tube",null,null,"Variación T° Imperturbable",null,null,"Variacion Distancia Entre Perforaciones",null,null,"Variacion Conductividad Termica mortero",null,null,"Variación Conductividad Termica Suelo",null,null,"Variación Capacidad Termica Suelo"]
["Delta Variable","Distancia U-Tube","Longitud Total","Delta Longitud","T° Imperturbable","Longitud Total","Delta Longitud","Distancia Entre Perforaciones","Longitud Total","Delta Longitud","Conductividad Termica mortero","Longitud Total","Delta Longitud","Conductividad Termica Suelo","Longitud Total","Delta Longitud","Capacidad Termica Suelo","Longitud Total","Delta Longitud"]
[{"v":-0.5,"d":"-50%"},{"$f":"B$13*(1+$A3)","v":{"v":0.0325,"d":"0.033"}},{"v":248.0265456569003,"d":"248.0"},{"$f":"C3/C$13-1","v":{"v":0.2502479898514376,"d":"25.0%"}},{"$f":"E$13*(1+$A3)","v":{"v":9.95,"d":"9.950"}},{"v":110.39325835992582,"d":"110.4"},{"$f":"F3/F$13-1","v":{"v":-0.4435315421899564,"d":"-44.4%"}},{"$f":"H$13*(1+$A3)","v":{"v":2.44,"d":"2.440"}},{"v":198.38187917132535,"d":"198.4"},{"$f":"I3/I$13-1","v":{"v":0,"d":"0.0%"}},{"$f":"K$13*(1+$A3)","v":{"v":0.35,"d":"0.350"}},{"v":272.58029916063106,"d":"272.6"},{"$f":"L3/L$13-1","v":{"v":0.3740181325998375,"d":"37.4%"}},{"$f":"N$13*(1+$A3)","v":{"v":1.2115,"d":"1.212"}},{"v":279.2749944469874,"d":"279.3"},{"$f":"O3/O$13-1","v":{"v":0.40776463865332,"d":"40.8%"}},{"$f":"Q$13*(1+$A3)","v":1.338},{"v":210.30566745142798,"d":"210.3"},{"$f":"R3/R$13-1","v":{"v":0.06010522901542381,"d":"6.0%"}}]
[{"v":-0.45,"d":"-45%"},{"v":0.035750000000000004,"d":"0.036"},{"v":241.71366834527475,"d":"241.7"},{"$f":"C4/C$13-1","v":{"v":0.218426145346307,"d":"21.8%"}},10.945,{"v":115.51679247128861,"d":"115.5"},{"$f":"F4/F$13-1","v":{"v":-0.41770491864568593,"d":"-41.8%"}},2.684,{"v":198.38187917132535,"d":"198.4"},{"$f":"I4/I$13-1","v":{"v":0,"d":"0.0%"}},0.385,{"v":259.12608154148825,"d":"259.1"},{"$f":"L4/L$13-1","v":{"v":0.306198341420606,"d":"30.6%"}},{"v":1.3326500000000001,"d":"1.333"},{"v":265.3476946094911,"d":"265.3"},{"$f":"O4/O$13-1","v":{"v":0.3375601426798318,"d":"33.8%"}},{"v":1.4718000000000002,"d":"1.472"},{"v":208.64153394082038,"d":"208.6"},{"$f":"R4/R$13-1","v":{"v":0.05171669313926919,"d":"5.2%"}}]
[{"v":-0.4,"d":"-40%"},0.039,{"v":235.89463151354923,"d":"235.9"},{"v":0.18909364352692393,"d":"18.9%"},{"v":11.94,"d":"11.940"},{"v":121.13905690568927,"d":"121.1"},{"v":-0.3893643037776051,"d":"-38.9%"},2.928,{"v":198.38187917132535,"d":"198.4"},{"v":0,"d":"0.0%"},{"v":0.42,"d":"0.420"},{"v":247.9060875048823,"d":"247.9"},{"v":0.2496407864489838,"d":"25.0%"},{"v":1.4538,"d":"1.454"},{"v":253.516697477074,"d":"253.5"},{"v":0.2779226537023245,"d":"27.8%"},{"v":1.6056000000000001,"d":"1.606"},{"v":207.12794950245706,"d":"207.1"},{"v":0.04408704246408757,"d":"4.4%"}]
[{"v":-0.35,"d":"-35%"},{"v":0.04225,"d":"0.042"},{"v":230.4742996350457,"d":"230.5"},{"v":0.16177092684964878,"d":"16.2%"},{"v":12.934999999999999,"d":"12.935"},{"v":127.33659761516921,"d":"127.3"},{"v":-0.3581238460535019,"d":"-35.8%"},3.172,{"v":198.38187917132535,"d":"198.4"},{"v":0,"d":"0.0%"},{"v":0.45499999999999996,"d":"0.455"},{"v":238.40500132874115,"d":"238.4"},{"v":0.20174787296399832,"d":"20.2%"},{"v":1.57495,"d":"1.575"},{"v":243.32991024221855,"d":"243.3"},{"v":0.22657326999143623,"d":"22.7%"},{"v":1.7394,"d":"1.739"},{"v":205.74095172587968,"d":"205.7"},{"v":0.037095487679088546,"d":"3.7%"}]
[{"v":-0.3,"d":"-30%"},{"v":0.0455,"d":"0.046"},{"v":225.3755631111859,"d":"225.4"},{"v":0.13606930256240002,"d":"13.6%"},{"v":13.929999999999998,"d":"13.930"},{"v":134.20246970075686,"d":"134.2"},{"v":-0.3235144749039415,"d":"-32.4%"},3.416,{"v":198.38187917132535,"d":"198.4"},{"v":0,"d":"0.0%"},{"v":0.48999999999999994,"d":"0.490"},{"v":230.25472811152872,"d":"230.3"},{"v":0.1606641144510863,"d":"16.1%"},{"v":1.6961,"d":"1.696"},{"v":234.4581424005937,"d":"234.5"},{"v":0.18185261365586913,"d":"18.2%"},{"v":1.8732,"d":"1.873"},{"v":204.46178655662152,"d":"204.5"},{"v":0.03064749366571662,"d":"3.1%"}]
[{"v":-0.25,"d":"-25%"},{"v":0.04875,"d":"0.049"},{"v":220.53383814469143,"d":"220.5"},{"v":0.1116632177590946,"d":"11.2%"},{"v":14.924999999999999,"d":"14.925"},{"v":141.850941862644,"d":"141.9"},{"v":-0.2849601866098892,"d":"-28.5%"},{"v":3.66,"d":"3.660"},{"v":198.38187917132535,"d":"198.4"},{"v":0,"d":"0.0%"},{"v":0.5249999999999999,"d":"0.525"},{"v":223.18532084371526,"d":"223.2"},{"v":0.1250287666191996,"d":"12.5%"},{"v":1.81725,"d":"1.817"},{"v":226.65569298826827,"d":"226.7"},{"v":0.1425221594585524,"d":"14.3%"},2.007,{"v":203.2755193262821,"d":"203.3"},{"v":0.024667778001692175,"d":"2.5%"}]
[{"v":-0.2,"d":"-20%"},{"v":0.052000000000000005,"d":"0.052"},{"v":215.89321556133532,"d":"215.9"},{"v":0.08827084642588212,"d":"8.8%"},{"v":15.92,"d":"15.920"},{"v":150.42390677148205,"d":"150.4"},{"v":-0.24174573101218644,"d":"-24.2%"},3.904,{"v":198.38187917132535,"d":"198.4"},{"v":0,"d":"0.0%"},{"v":0.5599999999999999,"d":"0.560"},{"v":216.99430978267893,"d":"217.0"},{"v":0.09382122343583421,"d":"9.4%"},{"v":1.9384000000000001,"d":"1.938"},{"v":219.73526246558416,"d":"219.7"},{"v":0.1076377710678793,"d":"10.8%"},{"v":2.1408,"d":"2.141"},{"v":202.17007455601973,"d":"202.2"},{"v":0.019095470818798033,"d":"1.9%"}]
[{"v":-0.15,"d":"-15%"},{"v":0.05525,"d":"0.055"},{"v":211.40360955751794,"d":"211.4"},{"v":0.06563971689645531,"d":"6.6%"},16.915,{"v":160.09976548180146,"d":"160.1"},{"v":-0.19297182711160288,"d":"-19.3%"},4.148,{"v":198.38187917132535,"d":"198.4"},{"v":0,"d":"0.0%"},0.595,{"v":211.5268567153977,"d":"211.5"},{"v":0.06626097907218731,"d":"6.6%"},{"v":2.0595499999999998,"d":"2.060"},{"v":213.55144232614026,"d":"213.6"},{"v":0.0764664757596849,"d":"7.6%"},{"v":2.2746,"d":"2.275"},{"v":201.13555677305473,"d":"201.1"},{"v":0.013880691186271443,"d":"1.4%"}]
[{"v":-0.1,"d":"-10%"},{"v":0.0585,"d":"0.059"},{"v":207.0184981675964,"d":"207.0"},{"v":0.043535322038220636,"d":"4.4%"},{"v":17.91,"d":"17.910"},{"v":171.10597645024075,"d":"171.1"},{"v":-0.1374919061913349,"d":"-13.7%"},4.392,{"v":198.38187917132535,"d":"198.4"},{"v":0,"d":"0.0%"},{"v":0.63,"d":"0.630"},{"v":206.6625244332819,"d":"206.7"},{"v":0.04174093569708193,"d":"4.2%"},{"v":2.1807000000000003,"d":"2.181"},{"v":207.98953383780946,"d":"208.0"},{"v":0.04843010211727461,"d":"4.8%"},{"v":2.4084000000000003,"d":"2.408"},{"v":200.16376003552142,"d":"200.2"},{"v":0.008982074732023282,"d":"0.9%"}]
[{"v":-0.05,"d":"-5%"},{"$f":"B$13*(1+$A12)","v":{"v":0.06175,"d":"0.062"}},{"v":202.69297359885985,"d":"202.7"},{"v":0.021731291414027742,"d":"2.2%"},{"$f":"E$13*(1+$A12)","v":{"v":18.904999999999998,"d":"18.905"}},{"v":183.7371628279414,"d":"183.7"},{"v":-0.07382083688569441,"d":"-7.4%"},{"$f":"H$13*(1+$A12)","v":4.636},{"v":198.38187917132535,"d":"198.4"},{"v":0,"d":"0.0%"},{"$f":"K$13*(1+$A12)","v":{"v":0.6649999999999999,"d":"0.665"}},{"v":202.30622423825392,"d":"202.3"},{"v":0.01978177181969043,"d":"2.0%"},{"$f":"N$13*(1+$A12)","v":{"v":2.30185,"d":"2.302"}},{"v":202.95778465011685,"d":"203.0"},{"v":0.023066146454030045,"d":"2.3%"},{"$f":"Q$13*(1+$A12)","v":{"v":2.5422000000000002,"d":"2.542"}},{"v":199.24780705592445,"d":"199.2"},{"v":0.004364954542301014,"d":"0.4%"}]
[{"v":0,"d":"0%"},0.065,{"v":198.38187917132535,"d":"198.4"},{"v":0,"d":"0.0%"},{"v":19.9,"d":"19.900"},{"v":198.38187917132535,"d":"198.4"},{"v":0,"d":"0.0%"},{"v":4.88,"d":"4.880"},{"v":198.38187917132535,"d":"198.4"},{"v":0,"d":"0.0%"},{"v":0.7,"d":"0.700"},{"v":198.38187917132535,"d":"198.4"},{"v":0,"d":"0.0%"},2.423,{"v":198.38187917132535,"d":"198.4"},{"v":0,"d":"0.0%"},2.676,{"v":198.38187917132535,"d":"198.4"},{"v":0,"d":"0.0%"}]
[{"v":0.05,"d":"5%"},{"$f":"B$13*(1+$A14)","v":{"v":0.06825,"d":"0.068"}},{"v":194.0378195650494,"d":"194.0"},{"v":-0.021897461725949086,"d":"-2.2%"},{"$f":"E$13*(1+$A14)","v":20.895},{"v":215.56328738045463,"d":"215.6"},{"v":0.08660775006718824,"d":"8.7%"},{"$f":"H$13*(1+$A14)","v":5.124},{"v":198.38187917132535,"d":"198.4"},{"v":0,"d":"0.0%"},{"$f":"K$13*(1+$A14)","v":0.735},{"v":194.82789772473555,"d":"194.8"},{"v":-0.01791484918600117,"d":"-1.8%"},{"$f":"N$13*(1+$A14)","v":{"v":2.54415,"d":"2.544"}},{"v":194.20095187881893,"d":"194.2"},{"v":-0.021075147135266925,"d":"-2.1%"},{"$f":"Q$13*(1+$A14)","v":{"v":2.8098,"d":"2.810"}},{"v":197.56101119478913,"d":"197.6"},{"v":-0.004137817324672666,"d":"-0.4%"}]
[{"v":0.1,"d":"10%"},{"$f":"B$13*(1+$A15)","v":{"v":0.07150000000000001,"d":"0.072"}},{"v":189.60879391466509,"d":"189.6"},{"v":-0.044223218840888756,"d":"-4.4%"},{"$f":"E$13*(1+$A15)","v":{"v":21.89,"d":"21.890"}},{"v":236.00297396470273,"d":"236.0"},{"v":0.18963977431067325,"d":"19.0%"},{"$f":"H$13*(1+$A15)","v":5.368},{"v":198.38187917132535,"d":"198.4"},{"v":0,"d":"0.0%"},{"$f":"K$13*(1+$A15)","v":{"v":0.77,"d":"0.770"}},{"v":191.5938819763535,"d":"191.6"},{"v":-0.03421682072640142,"d":"-3.4%"},{"$f":"N$13*(1+$A15)","v":{"v":2.6653000000000002,"d":"2.665"}},{"v":190.36465229069324,"d":"190.4"},{"v":-0.04041310080397176,"d":"-4.0%"},{"$f":"Q$13*(1+$A15)","v":{"v":2.9436000000000004,"d":"2.944"}},{"v":196.78093339726334,"d":"196.8"},{"v":-0.008070020209252182,"d":"-0.8%"}]
[{"v":0.15,"d":"15%"},{"v":0.07475,"d":"0.075"},{"v":185.03510090947762,"d":"185.0"},{"v":-0.06727821269563272,"d":"-6.7%"},{"v":22.884999999999998,"d":"22.885"},{"v":260.72487742028284,"d":"260.7"},{"v":0.31425752447438615,"d":"31.4%"},{"v":5.611999999999999,"d":"5.612"},{"v":198.38187917132535,"d":"198.4"},{"v":0,"d":"0.0%"},{"v":0.8049999999999999,"d":"0.805"},{"v":188.6381944540532,"d":"188.6"},{"v":-0.04911580008200933,"d":"-4.9%"},{"v":2.78645,"d":"2.786"},{"v":186.83095038355125,"d":"186.8"},{"v":-0.058225725232688985,"d":"-5.8%"},{"v":3.0774,"d":"3.077"},{"v":196.0379482592063,"d":"196.0"},{"v":-0.011815247047311184,"d":"-1.2%"}]
[{"v":0.2,"d":"20%"},0.078,{"v":180.24495759679635,"d":"180.2"},{"v":-0.09142428557633386,"d":"-9.1%"},{"v":23.88,"d":"23.880"},{"v":291.2321785832325,"d":"291.2"},{"v":0.4680382089319777,"d":"46.8%"},5.856,{"v":198.38187917132535,"d":"198.4"},{"v":0,"d":"0.0%"},{"v":0.84,"d":"0.840"},{"v":185.92613326841877,"d":"185.9"},{"v":-0.06278671194635488,"d":"-6.3%"},{"v":2.9076,"d":"2.908"},{"v":183.56447251064702,"d":"183.6"},{"v":-0.0746913312978642,"d":"-7.5%"},{"v":3.2112000000000003,"d":"3.211"},{"v":195.32883323798703,"d":"195.3"},{"v":-0.015389741976895355,"d":"-1.5%"}]
[{"v":0.25,"d":"25%"},{"v":0.08125,"d":"0.081"},{"v":175.1478577120066,"d":"175.1"},{"v":-0.11711765992121448,"d":"-11.7%"},24.875,{"v":329.8248348209537,"d":"329.8"},{"v":0.6625754136349942,"d":"66.3%"},{"v":6.1,"d":"6.100"},{"v":198.38187917132535,"d":"198.4"},{"v":0,"d":"0.0%"},0.875,{"v":183.42854519975714,"d":"183.4"},{"v":-0.075376511373069,"d":"-7.5%"},{"v":3.02875,"d":"3.029"},{"v":180.53522344433298,"d":"180.5"},{"v":-0.08996111843249421,"d":"-9.0%"},3.345,{"v":194.65076325446992,"d":"194.7"},{"v":-0.018807745608827475,"d":"-1.9%"}]
[{"v":0.3,"d":"30%"},{"$nulls":3},{"v":25.869999999999997,"d":"25.870"},{"v":380.2081491604266,"d":"380.2"},{"v":0.9165467670163239,"d":"91.7%"},6.344,{"v":198.38187917132535,"d":"198.4"},{"v":0,"d":"0.0%"},{"v":0.9099999999999999,"d":"0.910"},{"v":181.1207588296225,"d":"181.1"},{"v":-0.08700956162833762,"d":"-8.7%"},{"v":3.1499,"d":"3.150"},{"v":177.7175935156314,"d":"177.7"},{"v":-0.10416417942007694,"d":"-10.4%"},{"v":3.4788,"d":"3.479"},{"v":194.00124830468863,"d":"194.0"},{"v":-0.02208180951272043,"d":"-2.2%"}]
[{"v":0.35,"d":"35%"},{"$nulls":3},26.865,{"v":448.75968960643047,"d":"448.8"},{"v":1.2621002053260892,"d":"126.2%"},6.588,{"v":198.38187917132535,"d":"198.4"},{"v":0,"d":"0.0%"},0.945,{"v":178.9817547432124,"d":"179.0"},{"v":-0.09779181702053907,"d":"-9.8%"},{"v":3.2710500000000002,"d":"3.271"},{"v":175.08957902888622,"d":"175.1"},{"v":-0.11741143011516475,"d":"-11.7%"},{"v":3.6126000000000005,"d":"3.613"},{"v":193.37808280033872,"d":"193.4"},{"v":-0.025223051580559375,"d":"-2.5%"}]
[{"v":0.4,"d":"40%"},{"$nulls":3},{"v":27.859999999999996,"d":"27.860"},{"v":547.4682269914989,"d":"547.5"},{"v":1.7596685205239826,"d":"176.0%"},6.832,{"v":198.38187917132535,"d":"198.4"},{"v":0,"d":"0.0%"},{"v":0.9799999999999999,"d":"0.980"},{"v":176.99351353568264,"d":"177.0"},{"v":-0.10781410945891601,"d":"-10.8%"},{"v":3.3922,"d":"3.392"},{"v":172.63216414749937,"d":"172.6"},{"v":-0.12979872522322555,"d":"-13.0%"},{"v":3.7464,"d":"3.746"},{"v":192.77930409667346,"d":"192.8"},{"v":-0.028241365078578773,"d":"-2.8%"}]
[{"v":0.45,"d":"45%"},{"$nulls":3},{"v":28.854999999999997,"d":"28.855"},{"v":701.8450590864682,"d":"701.8"},{"v":2.5378486282023016,"d":"253.8%"},7.076,{"v":198.38187917132535,"d":"198.4"},{"v":0,"d":"0.0%"},1.015,{"v":175.14049870487136,"d":"175.1"},{"v":-0.11715475507912898,"d":"-11.7%"},{"v":3.51335,"d":"3.513"},{"v":170.32882638577232,"d":"170.3"},{"v":-0.1414093510089499,"d":"-14.1%"},{"v":3.8802000000000003,"d":"3.880"},{"v":192.20315828459172,"d":"192.2"},{"v":-0.031145591081923385,"d":"-3.1%"}]
[{"v":0.5,"d":"50%"},{"$nulls":3},{"v":29.849999999999998,"d":"29.850"},{"v":977.4771849736178,"d":"977.5"},{"v":3.927250357022049,"d":"392.7%"},{"v":7.32,"d":"7.320"},{"v":198.38187917132535,"d":"198.4"},{"v":0,"d":"0.0%"},{"v":1.0499999999999998,"d":"1.050"},{"v":173.40924295753982,"d":"173.4"},{"v":-0.12588163958371834,"d":"-12.6%"},{"v":3.6345,"d":"3.635"},{"v":168.165137689577,"d":"168.2"},{"v":-0.1523160361620164,"d":"-15.2%"},4.014,{"v":191.64807177628046,"d":"191.6"},{"v":-0.03394366170525831,"d":"-3.4%"}]

{"sheet":"DIM CALEFACCION","index":9,"n_rows":70,"n_cols":6,"rows_kept":70,"merged":[[1,0,1,2],[2,5,4,5],[5,0,5,2],[9,0,9,2],[13,0,13,2],[22,0,22,2],[27,0,27,2],[31,0,31,2],[36,0,36,2],[41,0,41,2]]}
["PRIMER SET DE INPUTS",null,"UNIDADES","Perforación única","Multiples perforaciones"]
["Calor inyectado/absorbido"]
["Carga máxima al terreno por hora","qh","W",{"$f":"-'BOMBA DE CALOR'!B8*1000","v":{"v":-3495.1960784313724,"d":"-3495"}},{"$f":"D3","v":{"v":-3495.1960784313724,"d":"-3495"}},"Convención de signos:\n+: Calor inyectado al terreno\n-: Calor absorbido del terreno"]
["Carga máxima al terreno por mes","qm","W",{"$f":"-'BOMBA DE CALOR'!B9*1000","v":{"v":-867.002688172043,"d":"-867"}},{"$f":"D4","v":{"v":-867.002688172043,"d":"-867"}}]
["Carga al terreno por año","qy","W",{"$f":"-'BOMBA DE CALOR'!B10*1000","v":{"v":-712.4372146118723,"d":"-712"}},{"$f":"D5","v":{"v":-712.4372146118723,"d":"-712"}}]
["Propiedades del terreno"]
["Conductividad Térmica","k","W.m-1K-1",{"$f":"TERRENO!B5","v":2.423},{"$f":"D7","v":2.423}]
["Difusividad Térmica","α","m2.día-1",{"$f":"TERRENO!B7","v":{"v":0.07823139013452914,"d":"0.078"}},{"$f":"D8","v":{"v":0.07823139013452914,"d":"0.078"}},"<- Aviso: α debe estar entre el rango 0,025 y 0,2 m²/day"]
["Temperatura imperturbable del terreno","Tg","°C",{"$f":"TERRENO!B4","v":19.9},{"$f":"D9","v":19.9}]
["Propiedades del fluido"]
["Calor Específico","Cp","J.kg-1.K-1",{"$f":"'TUBERIA Y FLUIDO'!E9","v":{"v":4173,"d":"4173.0"}},{"$f":"D11","v":{"v":4173,"d":"4173.0"}}]
["Ratio flujo másico total por carga máxima al terreno por hora","mfls","kg.s-1.kW-1",{"$f":"('TUBERIA Y FLUIDO'!E6/1000/3600*'TUBERIA Y FLUIDO'!E8)/'BOMBA DE CALOR'!B8","v":{"v":0.08286097360522847,"d":"0.083"}},{"$f":"D12","v":{"v":0.08286097360522847,"d":"0.083"}},"<- Flujo másico en kg/s dividido por el valor absoluto de la carga máxima al terreno por hora en kW"]
["max/min temperatura de entrada a bomba de calor","TinHP","°C",{"$f":"'BOMBA DE CALOR'!B4","v":0},{"$f":"D13","v":0},"<- Criterio de diseño para la operación de la bomba de calor"]
["Características de perforación"]
["Radio de perforacion","rbore","m",{"$f":"PERFORACIONES!B5","v":0.054},{"$f":"D15","v":0.054},"<- Aviso: rbore debe estar entre el rango 0,05 and 0,1 m"]
["Radio interno tubería","rpin","m",{"$f":"'TUBERIA Y FLUIDO'!B8/2","v":0.0105},0.0105]
["Radio externo tubería","rpext","m",{"$f":"'TUBERIA Y FLUIDO'!B9/2","v":0.0125},0.0125]
["Conductividad térmica mortero","kgrout","W.m-1.K-1",{"$f":"PERFORACIONES!B8","v":{"v":0.7,"d":"0.70"}},{"v":0.7,"d":"0.70"}]
["Conductividad térmica tubería","kpipe","W.m-1.K-1",{"$f":"'TUBERIA Y FLUIDO'!B10","v":0.43},0.43]
["Distancia entre centros de u-tubería","LU","m",{"$f":"'TUBERIA Y FLUIDO'!B7","v":{"v":0.065,"d":"0.0650"}},{"v":0.065,"d":"0.0650"}]
["Coeficiente de convección interna","hconv","W.m-2.K-1",{"$f":"'TUBERIA Y FLUIDO'!E12","v":{"v":3737.2587904026327,"d":"3737"}},{"v":3737.2587904026327,"d":"3737"}]
["PRIMER SET DE RESULTADOS"]
["Cálculo de la resistencia térmica efectiva de perforación"]
["Resistencia convectiva","Rconv","m.K.W-1",{"$f":"1/(2*PI()*D$16*D$21)","v":{"v":0.004055810549358974,"d":"0.004"}},{"$f":"1/(2*PI()*E$16*E$21)","v":{"v":0.004055810549358974,"d":"0.004"}}]
["Resistencia térmica tubería","Rp","m.K.W-1",{"$f":"LN(D$17/D$16)/(2*PI()*D$19)","v":{"v":0.06453303118350302,"d":"0.065"}},{"$f":"LN(E$17/E$16)/(2*PI()*E$19)","v":{"v":0.06453303118350302,"d":"0.065"}}]
["Resistencia térmica mortero","Rg","m.K.W-1",{"$f":"1/(4*PI()*D$18)*(LN(D$15/D$17)+LN(D$15/D$20)+(D$18-D$7)/(D$18+D$7)*LN(D$15^4/(D$15^4-(D$20/2)^4)))","v":{"v":0.1364473126474551,"d":"0.136"}},{"$f":"1/(4*PI()*E$18)*(LN(E$15/E$17)+LN(E$15/E$20)+(E$18-E$7)/(E$18+E$7)*LN(E$15^4/(E$15^4-(E$20/2)^4)))","v":{"v":0.1364473126474551,"d":"0.136"}}]
["Resistencia térmica efectiva perforación","Rb","m.K.W-1",{"$f":"D$26+(D$24+D$25)/2","v":{"v":0.1707417335138861,"d":"0.171"}},{"$f":"E$26+(E$24+E$25)/2","v":{"v":0.1707417335138861,"d":"0.171"}}]
["Cálculo de la resistencia térmica efectiva del terreno"]
["corto plazo (pulso 6 horas)","R6h","m.K.W-1",{"$f":"1/D$7*(coefficients!$C$4+coefficients!$C$5*D$15+coefficients!$C$6*D$15^2+coefficients!$C$7*D$8+coefficients!$C$8*D$8^2+coefficients!$C$9*LN(D$8)+coefficients!$C$10*LN(D$8)^2+coefficients!$C$11*D$15*D$8+coefficients!$C$12*D$15*LN(D$8)+coefficients!$C$13*D$8*LN(D$8))","v":{"v":0.09743189273030176,"d":"0.097"}},{"$f":"1/E$7*(coefficients!$C$4+coefficients!$C$5*E$15+coefficients!$C$6*E$15^2+coefficients!$C$7*E$8+coefficients!$C$8*E$8^2+coefficients!$C$9*LN(E$8)+coefficients!$C$10*LN(E$8)^2+coefficients!$C$11*E$15*E$8+coefficients!$C$12*E$15*LN(E$8)+coefficients!$C$13*E$8*LN(E$8))","v":{"v":0.09743189273030176,"d":"0.097"}}]
["mediano plazo (pulso 1 mes)","R1m","m.K.W-1",{"$f":"1/D$7*(coefficients!$D$4+coefficients!$D$5*D$15+coefficients!$D$6*D$15^2+coefficients!$D$7*D$8+coefficients!$D$8*D$8^2+coefficients!$D$9*LN(D$8)+coefficients!$D$10*LN(D$8)^2+coefficients!$D$11*D$15*D$8+coefficients!$D$12*D$15*LN(D$8)+coefficients!$D$13*D$8*LN(D$8))","v":{"v":0.14942257386901625,"d":"0.149"}},{"$f":"1/E$7*(coefficients!$D$4+coefficients!$D$5*E$15+coefficients!$D$6*E$15^2+coefficients!$D$7*E$8+coefficients!$D$8*E$8^2+coefficients!$D$9*LN(E$8)+coefficients!$D$10*LN(E$8)^2+coefficients!$D$11*E$15*E$8+coefficients!$D$12*E$15*LN(E$8)+coefficients!$D$13*E$8*LN(E$8))","v":{"v":0.14942257386901625,"d":"0.149"}}]
["largo plazo (pulso 10 años)","R10y","m.K.W-1",{"$f":"1/D$7*(coefficients!$E$4+coefficients!$E$5*D$15+coefficients!$E$6*D$15^2+coefficients!$E$7*D$8+coefficients!$E$8*D$8^2+coefficients!$E$9*LN(D$8)+coefficients!$E$10*LN(D$8)^2+coefficients!$E$11*D$15*D$8+coefficients!$E$12*D$15*LN(D$8)+coefficients!$E$13*D$8*LN(D$8))","v":{"v":0.15754126744095104,"d":"0.158"}},{"$f":"1/E$7*(coefficients!$E$4+coefficients!$E$5*E$15+coefficients!$E$6*E$15^2+coefficients!$E$7*E$8+coefficients!$E$8*E$8^2+coefficients!$E$9*LN(E$8)+coefficients!$E$10*LN(E$8)^2+coefficients!$E$11*E$15*E$8+coefficients!$E$12*E$15*LN(E$8)+coefficients!$E$13*E$8*LN(E$8))","v":{"v":0.15754126744095104,"d":"0.158"}}]
["Cálculo largo total sin interferencia térmica entre perforaciones"]
["Temperatura de salida del fluido en la bomba de calor","ToutHP","°C",{"$f":"D$13+D$3/(D$12*ABS(D$3)/1000*D$11)","v":{"v":-2.89202194022162,"d":"-2.9"}},{"$f":"E$13+E$3/(E$12*ABS(E$3)/1000*E$11)","v":{"v":-2.89202194022162,"d":"-2.9"}}]
["Temperatura media del fluido en la perforación","Tm","°C",{"$f":"(D$13+D$33)/2","v":{"v":-1.44601097011081,"d":"-1.4"}},{"$f":"(E$13+E$33)/2","v":{"v":-1.44601097011081,"d":"-1.4"}}]
["Largo total","L","m",{"$f":"(D$5*D$31+D$4*D$30+D$3*D$29+D$3*D$27)/(D$34-D$9)","v":{"v":55.23783546342679,"d":"55.2"}},{"$f":"(E$5*E$31+E$4*E$30+E$3*E$29+E$3*E$27)/(E$34-E$9)","v":{"v":55.23783546342679,"d":"55.2"}}]
["SEGUNDO SET DE INPUTS"]
["Características del campo de perforaciones"]
["Distancia entre perforaciones","B","m",null,{"$f":"PERFORACIONES!B6","v":4.88}]
["Número de perforaciones","NB","-",null,1,"<- Aviso: NB debe estar entre en el rango 4 y 144"]
["Ratio configuración de perforaciones","A","-",null,{"$f":"PERFORACIONES!B9","v":{"v":1,"d":"1.00"}},"<- Número de perforaciones en la dirección más extensa sobre número de perforaciones en la otra dirección, A debe estar entre el rango 1 y 9"]
["RESULTADOS FINALES"]
["Cálculo del largo total (con penalización Tp)"]
["Primera Iteración",{"$nulls":3},{"$f":"IF(E44<0.05,IF(E45<-2,\"! B/H<0.05 & ln(t10y/ts)<-2\",IF(E45>3,\"! B/H<0.05 & ln(t10y/ts)>3\",\"! B/H<0.05\")),IF(E44>0.1,IF(E45<-2,\"! B/H>0.1 & ln(t10y/ts)<-2\",IF(E45>3,\"! B/H>0.1 & ln(t10y/ts)>3\",\"! B/H>0.1\")),IF(E45<-2,\"! ln(t10y/ts)<-2\",IF(E45>3,\"! ln(t10y/ts)>3\",\"\"))))","v":""}]
["Ratio distancia-profundidad","B/H","-",null,{"$f":"E$38/(E$35/E$39)","v":{"v":0.08834524305774198,"d":"0.088"}},"Inota importante en el cálculo y evaluación de Tp:"]
["Logaritmo del tiempo adimensional","ln(t10y/ts)","-",null,{"$f":"LN(365.25*10/((E$35/E$39)^2/(9*E$8)))","v":{"v":-0.1709888697399577,"d":"-0.171"}},"La correlación para Tp está basada en 1485 simulaciones que cubren las siguientes configuraciones de perforaciones:"]
["Penalización en temperatura","Tp","°C",null,{"$f":"E$5/(2*PI()*E$7*E$35)*(coefficients!$H$4+coefficients!$H$5*E44+coefficients!$H$6*E44^2+coefficients!$H$7*E44^3+coefficients!$H$8*E45+coefficients!$H$9*E45^2+coefficients!$H$10*E45^3+coefficients!$H$11*E$39+coefficients!$H$12*E$39^2+coefficients!$H$13*E$39^3+coefficients!$H$14*E$40+coefficients!$H$15*E$40^2+coefficients!$H$16*E$40^3+coefficients!$H$17*E44*E45+coefficients!$H$18*E44*E45^2+coefficients!$H$19*E44*E$39+coefficients!$H$20*E44*E$39^2+coefficients!$H$21*E44*E$40+coefficients!$H$22*E44*E$40^2+coefficients!$H$23*E44^2*E45+coefficients!$H$24*E44^2*E45^2+coefficients!$H$25*E44^2*E$39+coefficients!$H$26*E44^2*E$39^2+coefficients!$H$27*E44^2*E$40+coefficients!$H$28*E44^2*E$40^2+coefficients!$H$29*E45*E$39+coefficients!$H$30*E45*E$39^2+coefficients!$H$31*E45*E$40+coefficients!$H$32*E45*E$40^2+coefficients!$H$33*E45^2*E$39+coefficients!$H$34*E45^2*E$39^2+coefficients!$H$35*E45^2*E$40+coefficients!$H$36*E45^2*E$40^2+coefficients!$H$37*E$39*E$40+coefficients!$H$38*E$39*E$40^2+coefficients!$H$39*E$39^2*E$40+coefficients!$H$40*E$39^2*E$40^2)","v":{"v":-2.3163974075664204,"d":"-2.316"}}]
["Largo total de perforaciones","L","m",null,{"$f":"(E$5*E$31+E$4*E$30+E$3*E$29+E$3*E$27)/(E$34-E$9-E46)","v":{"v":61.961712353859774,"d":"62.0"}}]
["Segunda Iteración",{"$nulls":3},{"$f":"IF(E49<0.05,IF(E50<-2,\"! B/H<0.05 & ln(t10y/ts)<-2\",IF(E50>3,\"! B/H<0.05 & ln(t10y/ts)>3\",\"! B/H<0.05\")),IF(E49>0.1,IF(E50<-2,\"! B/H>0.1 & ln(t10y/ts)<-2\",IF(E50>3,\"! B/H>0.1 & ln(t10y/ts)>3\",\"! B/H>0.1\")),IF(E50<-2,\"! ln(t10y/ts)<-2\",IF(E50>3,\"! ln(t10y/ts)>3\",\"\"))))","v":""}]
["Ratio distancia-profundidad","B/H","-",null,{"$f":"E$38/(E47/E$39)","v":{"v":0.07875831403965405,"d":"0.079"}}]
["Logaritmo del tiempo adimensional","ln(t10y/ts)","-",null,{"$f":"LN(365.25*10/((E47/E$39)^2/(9*E$8)))","v":{"v":-0.40072588585742996,"d":"-0.401"}}]
["Penalización en temperatura","Tp","°C",null,{"$f":"E$5/(2*PI()*E$7*E47)*(coefficients!$H$4+coefficients!$H$5*E49+coefficients!$H$6*E49^2+coefficients!$H$7*E49^3+coefficients!$H$8*E50+coefficients!$H$9*E50^2+coefficients!$H$10*E50^3+coefficients!$H$11*E$39+coefficients!$H$12*E$39^2+coefficients!$H$13*E$39^3+coefficients!$H$14*E$40+coefficients!$H$15*E$40^2+coefficients!$H$16*E$40^3+coefficients!$H$17*E49*E50+coefficients!$H$18*E49*E50^2+coefficients!$H$19*E49*E$39+coefficients!$H$20*E49*E$39^2+coefficients!$H$21*E49*E$40+coefficients!$H$22*E49*E$40^2+coefficients!$H$23*E49^2*E50+coefficients!$H$24*E49^2*E50^2+coefficients!$H$25*E49^2*E$39+coefficients!$H$26*E49^2*E$39^2+coefficients!$H$27*E49^2*E$40+coefficients!$H$28*E49^2*E$40^2+coefficients!$H$29*E50*E$39+coefficients!$H$30*E50*E$39^2+coefficients!$H$31*E50*E$40+coefficients!$H$32*E50*E$40^2+coefficients!$H$33*E50^2*E$39+coefficients!$H$34*E50^2*E$39^2+coefficients!$H$35*E50^2*E$40+coefficients!$H$36*E50^2*E$40^2+coefficients!$H$37*E$39*E$40+coefficients!$H$38*E$39*E$40^2+coefficients!$H$39*E$39^2*E$40+coefficients!$H$40*E$39^2*E$40^2)","v":{"v":-2.2067311888991763,"d":"-2.207"}}]
["Largo total de perforaciones","L","m",null,{"$f":"(E$5*E$31+E$4*E$30+E$3*E$29+E$3*E$27)/(E$34-E$9-E51)","v":{"v":61.606677745782946,"d":"61.6"}}]
["Tercera Iteración",{"$nulls":3},{"$f":"IF(E54<0.05,IF(E55<-2,\"! B/H<0.05 & ln(t10y/ts)<-2\",IF(E55>3,\"! B/H<0.05 & ln(t10y/ts)>3\",\"! B/H<0.05\")),IF(E54>0.1,IF(E55<-2,\"! B/H>0.1 & ln(t10y/ts)<-2\",IF(E55>3,\"! B/H>0.1 & ln(t10y/ts)>3\",\"! B/H>0.1\")),IF(E55<-2,\"! ln(t10y/ts)<-2\",IF(E55>3,\"! ln(t10y/ts)>3\",\"\"))))","v":""},"Cuando es utilizado en estos rangos, Tp tiene una precisión de un +/- 10%."]
["Ratio distancia-profundidad","B/H","-",null,{"$f":"E$38/(E52/E$39)","v":{"v":0.0792121922259319,"d":"0.079"}},"Sin embargo, en ciertos casos, cuando Tp es cercano a cero, los valores de Tp son menos precisos"]
["Logaritmo del tiempo adimensional","ln(t10y/ts)","-",null,{"$f":"LN(365.25*10/((E52/E$39)^2/(9*E$8)))","v":{"v":-0.38923312189882553,"d":"-0.389"}},"Esta inprecisión combinada con pequeños valores de (Tm-Tg) pueden llevar a valores de profundidad de perforación poco precisos"]
["Penalización en temperatura","Tp","°C",null,{"$f":"E$5/(2*PI()*E$7*E52)*(coefficients!$H$4+coefficients!$H$5*E54+coefficients!$H$6*E54^2+coefficients!$H$7*E54^3+coefficients!$H$8*E55+coefficients!$H$9*E55^2+coefficients!$H$10*E55^3+coefficients!$H$11*E$39+coefficients!$H$12*E$39^2+coefficients!$H$13*E$39^3+coefficients!$H$14*E$40+coefficients!$H$15*E$40^2+coefficients!$H$16*E$40^3+coefficients!$H$17*E54*E55+coefficients!$H$18*E54*E55^2+coefficients!$H$19*E54*E$39+coefficients!$H$20*E54*E$39^2+coefficients!$H$21*E54*E$40+coefficients!$H$22*E54*E$40^2+coefficients!$H$23*E54^2*E55+coefficients!$H$24*E54^2*E55^2+coefficients!$H$25*E54^2*E$39+coefficients!$H$26*E54^2*E$39^2+coefficients!$H$27*E54^2*E$40+coefficients!$H$28*E54^2*E$40^2+coefficients!$H$29*E55*E$39+coefficients!$H$30*E55*E$39^2+coefficients!$H$31*E55*E$40+coefficients!$H$32*E55*E$40^2+coefficients!$H$33*E55^2*E$39+coefficients!$H$34*E55^2*E$39^2+coefficients!$H$35*E55^2*E$40+coefficients!$H$36*E55^2*E$40^2+coefficients!$H$37*E$39*E$40+coefficients!$H$38*E$39*E$40^2+coefficients!$H$39*E$39^2*E$40+coefficients!$H$40*E$39^2*E$40^2)","v":{"v":-2.215256672307998,"d":"-2.215"}}]
["Largo total de perforaciones","L","m",null,{"$f":"(E$5*E$31+E$4*E$30+E$3*E$29+E$3*E$27)/(E$34-E$9-E56)","v":{"v":61.634132319754166,"d":"61.6"}}]
["Cuarta Iteración",{"$nulls":3},{"$f":"IF(E59<0.05,IF(E60<-2,\"! B/H<0.05 & ln(t10y/ts)<-2\",IF(E60>3,\"! B/H<0.05 & ln(t10y/ts)>3\",\"! B/H<0.05\")),IF(E59>0.1,IF(E60<-2,\"! B/H>0.1 & ln(t10y/ts)<-2\",IF(E60>3,\"! B/H>0.1 & ln(t10y/ts)>3\",\"! B/H>0.1\")),IF(E60<-2,\"! ln(t10y/ts)<-2\",IF(E60>3,\"! ln(t10y/ts)>3\",\"\"))))","v":""}]
["Ratio distancia-profundidad","B/H","-",null,{"$f":"E$38/(E57/E$39)","v":{"v":0.07917690760507269,"d":"0.079"}}]
["Logaritmo del tiempo adimensional","ln(t10y/ts)","-",null,{"$f":"LN(365.25*10/((E57/E$39)^2/(9*E$8)))","v":{"v":-0.39012420901228373,"d":"-0.390"}}]
["Penalización en temperatura","Tp","°C",null,{"$f":"E$5/(2*PI()*E$7*E57)*(coefficients!$H$4+coefficients!$H$5*E59+coefficients!$H$6*E59^2+coefficients!$H$7*E59^3+coefficients!$H$8*E60+coefficients!$H$9*E60^2+coefficients!$H$10*E60^3+coefficients!$H$11*E$39+coefficients!$H$12*E$39^2+coefficients!$H$13*E$39^3+coefficients!$H$14*E$40+coefficients!$H$15*E$40^2+coefficients!$H$16*E$40^3+coefficients!$H$17*E59*E60+coefficients!$H$18*E59*E60^2+coefficients!$H$19*E59*E$39+coefficients!$H$20*E59*E$39^2+coefficients!$H$21*E59*E$40+coefficients!$H$22*E59*E$40^2+coefficients!$H$23*E59^2*E60+coefficients!$H$24*E59^2*E60^2+coefficients!$H$25*E59^2*E$39+coefficients!$H$26*E59^2*E$39^2+coefficients!$H$27*E59^2*E$40+coefficients!$H$28*E59^2*E$40^2+coefficients!$H$29*E60*E$39+coefficients!$H$30*E60*E$39^2+coefficients!$H$31*E60*E$40+coefficients!$H$32*E60*E$40^2+coefficients!$H$33*E60^2*E$39+coefficients!$H$34*E60^2*E$39^2+coefficients!$H$35*E60^2*E$40+coefficients!$H$36*E60^2*E$40^2+coefficients!$H$37*E$39*E$40+coefficients!$H$38*E$39*E$40^2+coefficients!$H$39*E$39^2*E$40+coefficients!$H$40*E$39^2*E$40^2)","v":{"v":-2.2146059299594536,"d":"-2.215"}}]
["Largo total de perforaciones","L","m",null,{"$f":"(E$5*E$31+E$4*E$30+E$3*E$29+E$3*E$27)/(E$34-E$9-E61)","v":{"v":61.63203587467174,"d":"61.6"}}]
["Quinta Iteración",{"$nulls":3},{"$f":"IF(E64<0.05,IF(E65<-2,\"! B/H<0.05 & ln(t10y/ts)<-2\",IF(E65>3,\"! B/H<0.05 & ln(t10y/ts)>3\",\"! B/H<0.05\")),IF(E64>0.1,IF(E65<-2,\"! B/H>0.1 & ln(t10y/ts)<-2\",IF(E65>3,\"! B/H>0.1 & ln(t10y/ts)>3\",\"! B/H>0.1\")),IF(E65<-2,\"! ln(t10y/ts)<-2\",IF(E65>3,\"! ln(t10y/ts)>3\",\"\"))))","v":""}]
["Ratio distancia-profundidad","B/H","-",null,{"$f":"E$38/(E62/E$39)","v":{"v":0.07917960084790061,"d":"0.079"}}]
["Logaritmo del tiempo adimensional","ln(t10y/ts)","-",null,{"$f":"LN(365.25*10/((E62/E$39)^2/(9*E$8)))","v":{"v":-0.39005617915094104,"d":"-0.390"}}]
["Penalización en temperatura","Tp","°C",null,{"$f":"E$5/(2*PI()*E$7*E62)*(coefficients!$H$4+coefficients!$H$5*E64+coefficients!$H$6*E64^2+coefficients!$H$7*E64^3+coefficients!$H$8*E65+coefficients!$H$9*E65^2+coefficients!$H$10*E65^3+coefficients!$H$11*E$39+coefficients!$H$12*E$39^2+coefficients!$H$13*E$39^3+coefficients!$H$14*E$40+coefficients!$H$15*E$40^2+coefficients!$H$16*E$40^3+coefficients!$H$17*E64*E65+coefficients!$H$18*E64*E65^2+coefficients!$H$19*E64*E$39+coefficients!$H$20*E64*E$39^2+coefficients!$H$21*E64*E$40+coefficients!$H$22*E64*E$40^2+coefficients!$H$23*E64^2*E65+coefficients!$H$24*E64^2*E65^2+coefficients!$H$25*E64^2*E$39+coefficients!$H$26*E64^2*E$39^2+coefficients!$H$27*E64^2*E$40+coefficients!$H$28*E64^2*E$40^2+coefficients!$H$29*E65*E$39+coefficients!$H$30*E65*E$39^2+coefficients!$H$31*E65*E$40+coefficients!$H$32*E65*E$40^2+coefficients!$H$33*E65^2*E$39+coefficients!$H$34*E65^2*E$39^2+coefficients!$H$35*E65^2*E$40+coefficients!$H$36*E65^2*E$40^2+coefficients!$H$37*E$39*E$40+coefficients!$H$38*E$39*E$40^2+coefficients!$H$39*E$39^2*E$40+coefficients!$H$40*E$39^2*E$40^2)","v":{"v":-2.214655671989809,"d":"-2.215"}}]
["Largo total de perforaciones","L","m",null,{"$f":"(E$5*E$31+E$4*E$30+E$3*E$29+E$3*E$27)/(E$34-E$9-E66)","v":{"v":61.632196119596976,"d":"61.6"}}]
["Resultados Finales"]
["Largo total de perforaciones","L","m",null,{"$f":"E67","v":{"v":61.632196119596976,"d":"61.6"}}]
["Profundidad de perforación","H","m",null,{"$f":"E67/E$39","v":{"v":61.632196119596976,"d":"61.6"}}]

{"sheet":"DIM REFRIGERACIÓN","index":10,"n_rows":70,"n_cols":6,"rows_kept":70,"merged":[[1,0,1,2],[2,5,4,5],[5,0,5,2],[9,0,9,2],[13,0,13,2],[22,0,22,2],[27,0,27,2],[31,0,31,2],[36,0,36,2],[41,0,41,2]]}
["PRIMER SET DE INPUTS",null,"UNIDADES","Perforación única","Multiples perforaciones"]
["Calor inyectado/absorbido"]
["Carga máxima al terreno por hora","qh","W",{"$f":"'BOMBA DE CALOR'!C8*1000","v":{"v":7115.012853470437,"d":"7115"}},{"$f":"D3","v":{"v":7115.012853470437,"d":"7115"}},"Convención de signos:\n+: Calor inyectado al terreno\n-: Calor absorbido del terreno"]
["Carga máxima al terreno por mes","qm","W",{"$f":"'BOMBA DE CALOR'!C9*1000","v":{"v":3053.212365591398,"d":"3053"}},{"$f":"D4","v":{"v":3053.212365591398,"d":"3053"}}]
["Carga al terreno por año","qy","W",{"$f":"'BOMBA DE CALOR'!C10*1000","v":{"v":712.4372146118723,"d":"712"}},{"$f":"D5","v":{"v":712.4372146118723,"d":"712"}}]
["Propiedades del terreno"]
["Conductividad Térmica","k","W.m-1K-1",{"$f":"TERRENO!B5","v":2.423},{"$f":"D7","v":2.423}]
["Difusividad Térmica","α","m2.día-1",{"$f":"TERRENO!B7","v":{"v":0.07823139013452914,"d":"0.078"}},{"$f":"D8","v":{"v":0.07823139013452914,"d":"0.078"}},"<- Aviso: α debe estar entre el rango 0,025 y 0,2 m²/day"]
["Temperatura imperturbable del terreno","Tg","°C",{"$f":"TERRENO!B4","v":19.9},{"$f":"D9","v":19.9}]
["Propiedades del fluido"]
["Calor Específico","Cp","J.kg-1.K-1",{"$f":"'TUBERIA Y FLUIDO'!E9","v":4173},{"$f":"D11","v":4173}]
["Ratio flujo másico total por carga máxima al terreno por hora","mfls","kg.s-1.kW-1",{"$f":"('TUBERIA Y FLUIDO'!E6/1000/3600*'TUBERIA Y FLUIDO'!E8)/'BOMBA DE CALOR'!C8","v":{"v":0.040704824568059135,"d":"0.041"}},{"$f":"D12","v":{"v":0.040704824568059135,"d":"0.041"}},"<- Flujo másico en kg/s dividido por el valor absoluto de la carga máxima al terreno por hora en kW"]
["max/min temperatura de entrada a bomba de calor","TinHP","°C",{"$f":"'BOMBA DE CALOR'!C4","v":29.44},{"$f":"D13","v":29.44},"<- Criterio de diseño para la operación de la bomba de calor"]
["Características de perforación"]
["Radio de perforacion","rbore","m",{"$f":"PERFORACIONES!B5","v":0.054},{"$f":"D15","v":0.054},"<- Aviso: rbore debe estar entre el rango 0,05 and 0,1 m"]
["Radio interno tubería","rpin","m",{"$f":"'TUBERIA Y FLUIDO'!B8/2","v":0.0105},0.0105]
["Radio externo tubería","rpext","m",{"$f":"'TUBERIA Y FLUIDO'!B9/2","v":0.0125},0.0125]
["Conductividad térmica mortero","kgrout","W.m-1.K-1",{"$f":"PERFORACIONES!B8","v":{"v":0.7,"d":"0.70"}},{"v":0.7,"d":"0.70"}]
["Conductividad térmica tubería","kpipe","W.m-1.K-1",{"$f":"'TUBERIA Y FLUIDO'!B10","v":0.43},0.43]
["Distancia entre centros de u-tubería","LU","m",{"$f":"'TUBERIA Y FLUIDO'!B7","v":{"v":0.065,"d":"0.0650"}},{"v":0.065,"d":"0.0650"}]
["Coeficiente de convección interna","hconv","W.m-2.K-1",{"$f":"'TUBERIA Y FLUIDO'!E12","v":{"v":3737.2587904026327,"d":"3737"}},{"v":3737.2587904026327,"d":"3737"}]
["PRIMER SET DE RESULTADOS"]
["Cálculo de la resistencia térmica efectiva de perforación"]
["Resistencia convectiva","Rconv","m.K.W-1",{"$f":"1/(2*PI()*D$16*D$21)","v":{"v":0.004055810549358974,"d":"0.004"}},{"$f":"1/(2*PI()*E$16*E$21)","v":{"v":0.004055810549358974,"d":"0.004"}}]
["Resistencia térmica tubería","Rp","m.K.W-1",{"$f":"LN(D$17/D$16)/(2*PI()*D$19)","v":{"v":0.06453303118350302,"d":"0.065"}},{"$f":"LN(E$17/E$16)/(2*PI()*E$19)","v":{"v":0.06453303118350302,"d":"0.065"}}]
["Resistencia térmica mortero","Rg","m.K.W-1",{"$f":"1/(4*PI()*D$18)*(LN(D$15/D$17)+LN(D$15/D$20)+(D$18-D$7)/(D$18+D$7)*LN(D$15^4/(D$15^4-(D$20/2)^4)))","v":{"v":0.1364473126474551,"d":"0.136"}},{"$f":"1/(4*PI()*E$18)*(LN(E$15/E$17)+LN(E$15/E$20)+(E$18-E$7)/(E$18+E$7)*LN(E$15^4/(E$15^4-(E$20/2)^4)))","v":{"v":0.1364473126474551,"d":"0.136"}}]
["Resistencia térmica efectiva perforación","Rb","m.K.W-1",{"$f":"D$26+(D$24+D$25)/2","v":{"v":0.1707417335138861,"d":"0.171"}},{"$f":"E$26+(E$24+E$25)/2","v":{"v":0.1707417335138861,"d":"0.171"}}]
["Cálculo de la resistencia térmica efectiva del terreno"]
["corto plazo (pulso 6 horas)","R6h","m.K.W-1",{"$f":"1/D$7*(coefficients!$C$4+coefficients!$C$5*D$15+coefficients!$C$6*D$15^2+coefficients!$C$7*D$8+coefficients!$C$8*D$8^2+coefficients!$C$9*LN(D$8)+coefficients!$C$10*LN(D$8)^2+coefficients!$C$11*D$15*D$8+coefficients!$C$12*D$15*LN(D$8)+coefficients!$C$13*D$8*LN(D$8))","v":{"v":0.09743189273030176,"d":"0.097"}},{"$f":"1/E$7*(coefficients!$C$4+coefficients!$C$5*E$15+coefficients!$C$6*E$15^2+coefficients!$C$7*E$8+coefficients!$C$8*E$8^2+coefficients!$C$9*LN(E$8)+coefficients!$C$10*LN(E$8)^2+coefficients!$C$11*E$15*E$8+coefficients!$C$12*E$15*LN(E$8)+coefficients!$C$13*E$8*LN(E$8))","v":{"v":0.09743189273030176,"d":"0.097"}}]
["mediano plazo (pulso 1 mes)","R1m","m.K.W-1",{"$f":"1/D$7*(coefficients!$D$4+coefficients!$D$5*D$15+coefficients!$D$6*D$15^2+coefficients!$D$7*D$8+coefficients!$D$8*D$8^2+coefficients!$D$9*LN(D$8)+coefficients!$D$10*LN(D$8)^2+coefficients!$D$11*D$15*D$8+coefficients!$D$12*D$15*LN(D$8)+coefficients!$D$13*D$8*LN(D$8))","v":{"v":0.14942257386901625,"d":"0.149"}},{"$f":"1/E$7*(coefficients!$D$4+coefficients!$D$5*E$15+coefficients!$D$6*E$15^2+coefficients!$D$7*E$8+coefficients!$D$8*E$8^2+coefficients!$D$9*LN(E$8)+coefficients!$D$10*LN(E$8)^2+coefficients!$D$11*E$15*E$8+coefficients!$D$12*E$15*LN(E$8)+coefficients!$D$13*E$8*LN(E$8))","v":{"v":0.14942257386901625,"d":"0.149"}}]
["largo plazo (pulso 10 años)","R10y","m.K.W-1",{"$f":"1/D$7*(coefficients!$E$4+coefficients!$E$5*D$15+coefficients!$E$6*D$15^2+coefficients!$E$7*D$8+coefficients!$E$8*D$8^2+coefficients!$E$9*LN(D$8)+coefficients!$E$10*LN(D$8)^2+coefficients!$E$11*D$15*D$8+coefficients!$E$12*D$15*LN(D$8)+coefficients!$E$13*D$8*LN(D$8))","v":{"v":0.15754126744095104,"d":"0.158"}},{"$f":"1/E$7*(coefficients!$E$4+coefficients!$E$5*E$15+coefficients!$E$6*E$15^2+coefficients!$E$7*E$8+coefficients!$E$8*E$8^2+coefficients!$E$9*LN(E$8)+coefficients!$E$10*LN(E$8)^2+coefficients!$E$11*E$15*E$8+coefficients!$E$12*E$15*LN(E$8)+coefficients!$E$13*E$8*LN(E$8))","v":{"v":0.15754126744095104,"d":"0.158"}}]
["Cálculo largo total sin interferencia térmica entre perforaciones"]
["Temperatura de salida del fluido en la bomba de calor","ToutHP","°C",{"$f":"D$13+D$3/(D$12*ABS(D$3)/1000*D$11)","v":{"v":35.32715849281626,"d":"35.3"}},{"$f":"E$13+E$3/(E$12*ABS(E$3)/1000*E$11)","v":{"v":35.32715849281626,"d":"35.3"}}]
["Temperatura media del fluido en la perforación","Tm","°C",{"$f":"(D$13+D$33)/2","v":{"v":32.38357924640813,"d":"32.4"}},{"$f":"(E$13+E$33)/2","v":{"v":32.38357924640813,"d":"32.4"}}]
["Largo total","L","m",{"$f":"(D$5*D$31+D$4*D$30+D$3*D$29+D$3*D$27)/(D$34-D$9)","v":{"v":198.38187917132535,"d":"198.4"}},{"$f":"(E$5*E$31+E$4*E$30+E$3*E$29+E$3*E$27)/(E$34-E$9)","v":{"v":198.38187917132535,"d":"198.4"}}]
["SEGUNDO SET DE INPUTS"]
["Características del campo de perforaciones"]
["Distancia entre perforaciones","B","m",null,{"$f":"PERFORACIONES!B6","v":4.88}]
["Número de perforaciones","NB","-",null,1,"<- Aviso: NB debe estar entre en el rango 4 y 144"]
["Ratio configuración de perforaciones","A","-",null,{"$f":"PERFORACIONES!B9","v":{"v":1,"d":"1.00"}},"<- Número de perforaciones en la dirección más extensa sobre número de perforaciones en la otra dirección, A debe estar entre el rango 1 y 9"]
["RESULTADOS FINALES"]
["Cálculo del largo total (con penalización Tp)"]
["Primera Iteración",{"$nulls":3},{"$f":"IF(E44<0.05,IF(E45<-2,\"! B/H<0.05 & ln(t10y/ts)<-2\",IF(E45>3,\"! B/H<0.05 & ln(t10y/ts)>3\",\"! B/H<0.05\")),IF(E44>0.1,IF(E45<-2,\"! B/H>0.1 & ln(t10y/ts)<-2\",IF(E45>3,\"! B/H>0.1 & ln(t10y/ts)>3\",\"! B/H>0.1\")),IF(E45<-2,\"! ln(t10y/ts)<-2\",IF(E45>3,\"! ln(t10y/ts)>3\",\"\"))))","v":"! B/H<0.05 & ln(t10y/ts)<-2"}]
["Ratio distancia-profundidad","B/H","-",null,{"$f":"E$38/(E$35/E$39)","v":{"v":0.024599020940746126,"d":"0.025"}},"Inota importante en el cálculo y evaluación de Tp:"]
["Logaritmo del tiempo adimensional","ln(t10y/ts)","-",null,{"$f":"LN(365.25*10/((E$35/E$39)^2/(9*E$8)))","v":{"v":-2.7280802943577362,"d":"-2.728"}},"La correlación para Tp está basada en 1485 simulaciones que cubren las siguientes configuraciones de perforaciones:"]
["Penalización en temperatura","Tp","°C",null,{"$f":"E$5/(2*PI()*E$7*E$35)*(coefficients!$H$4+coefficients!$H$5*E44+coefficients!$H$6*E44^2+coefficients!$H$7*E44^3+coefficients!$H$8*E45+coefficients!$H$9*E45^2+coefficients!$H$10*E45^3+coefficients!$H$11*E$39+coefficients!$H$12*E$39^2+coefficients!$H$13*E$39^3+coefficients!$H$14*E$40+coefficients!$H$15*E$40^2+coefficients!$H$16*E$40^3+coefficients!$H$17*E44*E45+coefficients!$H$18*E44*E45^2+coefficients!$H$19*E44*E$39+coefficients!$H$20*E44*E$39^2+coefficients!$H$21*E44*E$40+coefficients!$H$22*E44*E$40^2+coefficients!$H$23*E44^2*E45+coefficients!$H$24*E44^2*E45^2+coefficients!$H$25*E44^2*E$39+coefficients!$H$26*E44^2*E$39^2+coefficients!$H$27*E44^2*E$40+coefficients!$H$28*E44^2*E$40^2+coefficients!$H$29*E45*E$39+coefficients!$H$30*E45*E$39^2+coefficients!$H$31*E45*E$40+coefficients!$H$32*E45*E$40^2+coefficients!$H$33*E45^2*E$39+coefficients!$H$34*E45^2*E$39^2+coefficients!$H$35*E45^2*E$40+coefficients!$H$36*E45^2*E$40^2+coefficients!$H$37*E$39*E$40+coefficients!$H$38*E$39*E$40^2+coefficients!$H$39*E$39^2*E$40+coefficients!$H$40*E$39^2*E$40^2)","v":{"v":-1.0043619605187701,"d":"-1.004"}}]
["Largo total de perforaciones","L","m",null,{"$f":"(E$5*E$31+E$4*E$30+E$3*E$29+E$3*E$27)/(E$34-E$9-E46)","v":{"v":183.60963112848958,"d":"183.6"}}]
["Segunda Iteración",{"$nulls":3},{"$f":"IF(E49<0.05,IF(E50<-2,\"! B/H<0.05 & ln(t10y/ts)<-2\",IF(E50>3,\"! B/H<0.05 & ln(t10y/ts)>3\",\"! B/H<0.05\")),IF(E49>0.1,IF(E50<-2,\"! B/H>0.1 & ln(t10y/ts)<-2\",IF(E50>3,\"! B/H>0.1 & ln(t10y/ts)>3\",\"! B/H>0.1\")),IF(E50<-2,\"! ln(t10y/ts)<-2\",IF(E50>3,\"! ln(t10y/ts)>3\",\"\"))))","v":"! B/H<0.05 & ln(t10y/ts)<-2"}]
["Ratio distancia-profundidad","B/H","-",null,{"$f":"E$38/(E47/E$39)","v":{"v":0.026578126485015306,"d":"0.027"}}]
["Logaritmo del tiempo adimensional","ln(t10y/ts)","-",null,{"$f":"LN(365.25*10/((E47/E$39)^2/(9*E$8)))","v":{"v":-2.573316450517472,"d":"-2.573"}}]
["Penalización en temperatura","Tp","°C",null,{"$f":"E$5/(2*PI()*E$7*E47)*(coefficients!$H$4+coefficients!$H$5*E49+coefficients!$H$6*E49^2+coefficients!$H$7*E49^3+coefficients!$H$8*E50+coefficients!$H$9*E50^2+coefficients!$H$10*E50^3+coefficients!$H$11*E$39+coefficients!$H$12*E$39^2+coefficients!$H$13*E$39^3+coefficients!$H$14*E$40+coefficients!$H$15*E$40^2+coefficients!$H$16*E$40^3+coefficients!$H$17*E49*E50+coefficients!$H$18*E49*E50^2+coefficients!$H$19*E49*E$39+coefficients!$H$20*E49*E$39^2+coefficients!$H$21*E49*E$40+coefficients!$H$22*E49*E$40^2+coefficients!$H$23*E49^2*E50+coefficients!$H$24*E49^2*E50^2+coefficients!$H$25*E49^2*E$39+coefficients!$H$26*E49^2*E$39^2+coefficients!$H$27*E49^2*E$40+coefficients!$H$28*E49^2*E$40^2+coefficients!$H$29*E50*E$39+coefficients!$H$30*E50*E$39^2+coefficients!$H$31*E50*E$40+coefficients!$H$32*E50*E$40^2+coefficients!$H$33*E50^2*E$39+coefficients!$H$34*E50^2*E$39^2+coefficients!$H$35*E50^2*E$40+coefficients!$H$36*E50^2*E$40^2+coefficients!$H$37*E$39*E$40+coefficients!$H$38*E$39*E$40^2+coefficients!$H$39*E$39^2*E$40+coefficients!$H$40*E$39^2*E$40^2)","v":{"v":-0.8468592515538675,"d":"-0.847"}}]
["Largo total de perforaciones","L","m",null,{"$f":"(E$5*E$31+E$4*E$30+E$3*E$29+E$3*E$27)/(E$34-E$9-E51)","v":{"v":185.77902820415252,"d":"185.8"}}]
["Tercera Iteración",{"$nulls":3},{"$f":"IF(E54<0.05,IF(E55<-2,\"! B/H<0.05 & ln(t10y/ts)<-2\",IF(E55>3,\"! B/H<0.05 & ln(t10y/ts)>3\",\"! B/H<0.05\")),IF(E54>0.1,IF(E55<-2,\"! B/H>0.1 & ln(t10y/ts)<-2\",IF(E55>3,\"! B/H>0.1 & ln(t10y/ts)>3\",\"! B/H>0.1\")),IF(E55<-2,\"! ln(t10y/ts)<-2\",IF(E55>3,\"! ln(t10y/ts)>3\",\"\"))))","v":"! B/H<0.05 & ln(t10y/ts)<-2"},"Cuando es utilizado en estos rangos, Tp tiene una precisión de un +/- 10%."]
["Ratio distancia-profundidad","B/H","-",null,{"$f":"E$38/(E52/E$39)","v":{"v":0.026267765781600328,"d":"0.026"}},"Sin embargo, en ciertos casos, cuando Tp es cercano a cero, los valores de Tp son menos precisos"]
["Logaritmo del tiempo adimensional","ln(t10y/ts)","-",null,{"$f":"LN(365.25*10/((E52/E$39)^2/(9*E$8)))","v":{"v":-2.5968084767421566,"d":"-2.597"}},"Esta inprecisión combinada con pequeños valores de (Tm-Tg) pueden llevar a valores de profundidad de perforación poco precisos"]
["Penalización en temperatura","Tp","°C",null,{"$f":"E$5/(2*PI()*E$7*E52)*(coefficients!$H$4+coefficients!$H$5*E54+coefficients!$H$6*E54^2+coefficients!$H$7*E54^3+coefficients!$H$8*E55+coefficients!$H$9*E55^2+coefficients!$H$10*E55^3+coefficients!$H$11*E$39+coefficients!$H$12*E$39^2+coefficients!$H$13*E$39^3+coefficients!$H$14*E$40+coefficients!$H$15*E$40^2+coefficients!$H$16*E$40^3+coefficients!$H$17*E54*E55+coefficients!$H$18*E54*E55^2+coefficients!$H$19*E54*E$39+coefficients!$H$20*E54*E$39^2+coefficients!$H$21*E54*E$40+coefficients!$H$22*E54*E$40^2+coefficients!$H$23*E54^2*E55+coefficients!$H$24*E54^2*E55^2+coefficients!$H$25*E54^2*E$39+coefficients!$H$26*E54^2*E$39^2+coefficients!$H$27*E54^2*E$40+coefficients!$H$28*E54^2*E$40^2+coefficients!$H$29*E55*E$39+coefficients!$H$30*E55*E$39^2+coefficients!$H$31*E55*E$40+coefficients!$H$32*E55*E$40^2+coefficients!$H$33*E55^2*E$39+coefficients!$H$34*E55^2*E$39^2+coefficients!$H$35*E55^2*E$40+coefficients!$H$36*E55^2*E$40^2+coefficients!$H$37*E$39*E$40+coefficients!$H$38*E$39*E$40^2+coefficients!$H$39*E$39^2*E$40+coefficients!$H$40*E$39^2*E$40^2)","v":{"v":-0.8718647623957616,"d":"-0.872"}}]
["Largo total de perforaciones","L","m",null,{"$f":"(E$5*E$31+E$4*E$30+E$3*E$29+E$3*E$27)/(E$34-E$9-E56)","v":{"v":185.4311925574385,"d":"185.4"}}]
["Cuarta Iteración",{"$nulls":3},{"$f":"IF(E59<0.05,IF(E60<-2,\"! B/H<0.05 & ln(t10y/ts)<-2\",IF(E60>3,\"! B/H<0.05 & ln(t10y/ts)>3\",\"! B/H<0.05\")),IF(E59>0.1,IF(E60<-2,\"! B/H>0.1 & ln(t10y/ts)<-2\",IF(E60>3,\"! B/H>0.1 & ln(t10y/ts)>3\",\"! B/H>0.1\")),IF(E60<-2,\"! ln(t10y/ts)<-2\",IF(E60>3,\"! ln(t10y/ts)>3\",\"\"))))","v":"! B/H<0.05 & ln(t10y/ts)<-2"}]
["Ratio distancia-profundidad","B/H","-",null,{"$f":"E$38/(E57/E$39)","v":{"v":0.02631703939717903,"d":"0.026"}}]
["Logaritmo del tiempo adimensional","ln(t10y/ts)","-",null,{"$f":"LN(365.25*10/((E57/E$39)^2/(9*E$8)))","v":{"v":-2.5930603498958256,"d":"-2.593"}}]
["Penalización en temperatura","Tp","°C",null,{"$f":"E$5/(2*PI()*E$7*E57)*(coefficients!$H$4+coefficients!$H$5*E59+coefficients!$H$6*E59^2+coefficients!$H$7*E59^3+coefficients!$H$8*E60+coefficients!$H$9*E60^2+coefficients!$H$10*E60^3+coefficients!$H$11*E$39+coefficients!$H$12*E$39^2+coefficients!$H$13*E$39^3+coefficients!$H$14*E$40+coefficients!$H$15*E$40^2+coefficients!$H$16*E$40^3+coefficients!$H$17*E59*E60+coefficients!$H$18*E59*E60^2+coefficients!$H$19*E59*E$39+coefficients!$H$20*E59*E$39^2+coefficients!$H$21*E59*E$40+coefficients!$H$22*E59*E$40^2+coefficients!$H$23*E59^2*E60+coefficients!$H$24*E59^2*E60^2+coefficients!$H$25*E59^2*E$39+coefficients!$H$26*E59^2*E$39^2+coefficients!$H$27*E59^2*E$40+coefficients!$H$28*E59^2*E$40^2+coefficients!$H$29*E60*E$39+coefficients!$H$30*E60*E$39^2+coefficients!$H$31*E60*E$40+coefficients!$H$32*E60*E$40^2+coefficients!$H$33*E60^2*E$39+coefficients!$H$34*E60^2*E$39^2+coefficients!$H$35*E60^2*E$40+coefficients!$H$36*E60^2*E$40^2+coefficients!$H$37*E$39*E$40+coefficients!$H$38*E$39*E$40^2+coefficients!$H$39*E$39^2*E$40+coefficients!$H$40*E$39^2*E$40^2)","v":{"v":-0.8679014467914332,"d":"-0.868"}}]
["Largo total de perforaciones","L","m",null,{"$f":"(E$5*E$31+E$4*E$30+E$3*E$29+E$3*E$27)/(E$34-E$9-E61)","v":{"v":185.4862368147669,"d":"185.5"}}]
["Quinta Iteración",{"$nulls":3},{"$f":"IF(E64<0.05,IF(E65<-2,\"! B/H<0.05 & ln(t10y/ts)<-2\",IF(E65>3,\"! B/H<0.05 & ln(t10y/ts)>3\",\"! B/H<0.05\")),IF(E64>0.1,IF(E65<-2,\"! B/H>0.1 & ln(t10y/ts)<-2\",IF(E65>3,\"! B/H>0.1 & ln(t10y/ts)>3\",\"! B/H>0.1\")),IF(E65<-2,\"! ln(t10y/ts)<-2\",IF(E65>3,\"! ln(t10y/ts)>3\",\"\"))))","v":"! B/H<0.05 & ln(t10y/ts)<-2"}]
["Ratio distancia-profundidad","B/H","-",null,{"$f":"E$38/(E62/E$39)","v":{"v":0.026309229643131635,"d":"0.026"}}]
["Logaritmo del tiempo adimensional","ln(t10y/ts)","-",null,{"$f":"LN(365.25*10/((E62/E$39)^2/(9*E$8)))","v":{"v":-2.5936539510951615,"d":"-2.594"}}]
["Penalización en temperatura","Tp","°C",null,{"$f":"E$5/(2*PI()*E$7*E62)*(coefficients!$H$4+coefficients!$H$5*E64+coefficients!$H$6*E64^2+coefficients!$H$7*E64^3+coefficients!$H$8*E65+coefficients!$H$9*E65^2+coefficients!$H$10*E65^3+coefficients!$H$11*E$39+coefficients!$H$12*E$39^2+coefficients!$H$13*E$39^3+coefficients!$H$14*E$40+coefficients!$H$15*E$40^2+coefficients!$H$16*E$40^3+coefficients!$H$17*E64*E65+coefficients!$H$18*E64*E65^2+coefficients!$H$19*E64*E$39+coefficients!$H$20*E64*E$39^2+coefficients!$H$21*E64*E$40+coefficients!$H$22*E64*E$40^2+coefficients!$H$23*E64^2*E65+coefficients!$H$24*E64^2*E65^2+coefficients!$H$25*E64^2*E$39+coefficients!$H$26*E64^2*E$39^2+coefficients!$H$27*E64^2*E$40+coefficients!$H$28*E64^2*E$40^2+coefficients!$H$29*E65*E$39+coefficients!$H$30*E65*E$39^2+coefficients!$H$31*E65*E$40+coefficients!$H$32*E65*E$40^2+coefficients!$H$33*E65^2*E$39+coefficients!$H$34*E65^2*E$39^2+coefficients!$H$35*E65^2*E$40+coefficients!$H$36*E65^2*E$40^2+coefficients!$H$37*E$39*E$40+coefficients!$H$38*E$39*E$40^2+coefficients!$H$39*E$39^2*E$40+coefficients!$H$40*E$39^2*E$40^2)","v":{"v":-0.8685297934901398,"d":"-0.869"}}]
["Largo total de perforaciones","L","m",null,{"$f":"(E$5*E$31+E$4*E$30+E$3*E$29+E$3*E$27)/(E$34-E$9-E66)","v":{"v":185.47750788181634,"d":"185.5"}}]
["Resultados Finales"]
["Largo total de perforaciones","L","m",null,{"$f":"E67","v":{"v":185.47750788181634,"d":"185.5"}}]
["Profundidad de perforación","H","m",null,{"$f":"E67/E$39","v":{"v":185.47750788181634,"d":"185.5"}}]

{"sheet":"DATOS TUBERIAS","index":11,"n_rows":130,"n_cols":8,"rows_kept":130}
[null,"Material","Tipo","Presión\n(Bar)","Diam Nominal\n(Pul)","DN=Do Exterior\n(mm)","Di Interior\n(mm)","Kp\n(W/m°K)"]
[{"$f":"CONCATENATE(B2,C2,\"PN\",D2,E2)","v":"PolietilenoPE32PN43/4''"},"Polietileno","PE32",4,"3/4''",20,17.6,0.40678]
[{"$f":"CONCATENATE(B3,C3,\"PN\",D3,E3)","v":"PolietilenoPE32PN41''"},"Polietileno","PE32",4,"1''",25,21,0.40678]
["PolietilenoPE32PN41 1/4''","Polietileno","PE32",4,"1 1/4''",32,28,0.40678]
["PolietilenoPE32PN41 1/2''","Polietileno","PE32",4,"1 1/2''",40,35.2,0.40678]
["PolietilenoPE32PN42''","Polietileno","PE32",4,"2''",50,44,0.40678]
["PolietilenoPE32PN42 1/2''","Polietileno","PE32",4,"2 1/2''",63,55.4,0.40678]
["PolietilenoPE32PN63/4''","Polietileno","PE32",6,"3/4''",20,16,0.40678]
["PolietilenoPE32PN61''","Polietileno","PE32",6,"1''",25,20.4,0.40678]
["PolietilenoPE32PN61 1/4''","Polietileno","PE32",6,"1 1/4''",32,26.2,0.40678]
["PolietilenoPE32PN61 1/2''","Polietileno","PE32",6,"1 1/2''",40,32.6,0.40678]
["PolietilenoPE32PN62''","Polietileno","PE32",6,"2''",50,40.8,0.40678]
["PolietilenoPE32PN62 1/2''","Polietileno","PE32",6,"2 1/2''",63,51.4,0.40678]
["PolietilenoPE32PN103/4''","Polietileno","PE32",10,"3/4''",20,14.4,0.40678]
["PolietilenoPE32PN101''","Polietileno","PE32",10,"1''",25,18,0.40678]
["PolietilenoPE32PN101 1/4''","Polietileno","PE32",10,"1 1/4''",32,23.2,0.40678]
["PolietilenoPE32PN101 1/2''","Polietileno","PE32",10,"1 1/2''",40,29,0.40678]
["PolietilenoPE32PN102''","Polietileno","PE32",10,"2''",50,36.2,0.40678]
["PolietilenoPE32PN102 1/2''","Polietileno","PE32",10,"2 1/2''",63,45.8,0.40678]
["PolietilenoPE50APN63/4''","Polietileno","PE50A",6,"3/4''","-","-",0.43]
["PolietilenoPE50APN61''","Polietileno","PE50A",6,"1''",25,21,0.43]
["PolietilenoPE50APN61 1/4''","Polietileno","PE50A",6,"1 1/4''",32,28,0.43]
["PolietilenoPE50APN61 1/2''","Polietileno","PE50A",6,"1 1/2''",40,35.2,0.43]
["PolietilenoPE50APN62''","Polietileno","PE50A",6,"2''",50,44,0.43]
["PolietilenoPE50APN62 1/2''","Polietileno","PE50A",6,"2 1/2''",63,55.4,0.43]
["PolietilenoPE50APN103/4''","Polietileno","PE50A",10,"3/4''",20,16,0.43]
["PolietilenoPE50APN101''","Polietileno","PE50A",10,"1''",25,20.4,0.43]
["PolietilenoPE50APN101 1/4''","Polietileno","PE50A",10,"1 1/4''",32,26.2,0.43]
["PolietilenoPE50APN101 1/2''","Polietileno","PE50A",10,"1 1/2''",40,32.6,0.43]
["PolietilenoPE50APN102''","Polietileno","PE50A",10,"2''",50,40.8,0.43]
["PolietilenoPE50APN102 1/2''","Polietileno","PE50A",10,"2 1/2''",63,51.4,0.43]
["PolietilenoPE50APN163/4''","Polietileno","PE50A",16,"3/4''","-","-",0.43]
["PolietilenoPE50APN161''","Polietileno","PE50A",16,"1''","-","-",0.43]
["PolietilenoPE50APN161 1/4''","Polietileno","PE50A",16,"1 1/4''",32,23.2,0.43]
["PolietilenoPE50APN161 1/2''","Polietileno","PE50A",16,"1 1/2''",40,29,0.43]
["PolietilenoPE50APN162''","Polietileno","PE50A",16,"2''",50,36.2,0.43]
["PolietilenoPE50APN162 1/2''","Polietileno","PE50A",16,"2 1/2''",63,45.8,0.43]
["PolietilenoPE50BPN63/4''","Polietileno","PE50B",6,"3/4''","-","-",0.29]
["PolietilenoPE50BPN61''","Polietileno","PE50B",6,"1''",25,21,0.29]
["PolietilenoPE50BPN61 1/4''","Polietileno","PE50B",6,"1 1/4''",32,28,0.29]
["PolietilenoPE50BPN61 1/2''","Polietileno","PE50B",6,"1 1/2''",40,35.2,0.29]
["PolietilenoPE50BPN62''","Polietileno","PE50B",6,"2''",50,44,0.29]
["PolietilenoPE50BPN62 1/2''","Polietileno","PE50B",6,"2 1/2''",63,55.4,0.29]
["PolietilenoPE50BPN103/4''","Polietileno","PE50B",10,"3/4''",20,16,0.29]
["PolietilenoPE50BPN101''","Polietileno","PE50B",10,"1''",25,20.4,0.29]
["PolietilenoPE50BPN101 1/4''","Polietileno","PE50B",10,"1 1/4''",32,26.2,0.29]
["PolietilenoPE50BPN101 1/2''","Polietileno","PE50B",10,"1 1/2''",40,32.6,0.29]
["PolietilenoPE50BPN102''","Polietileno","PE50B",10,"2''",50,40.8,0.29]
["PolietilenoPE50BPN102 1/2''","Polietileno","PE50B",10,"2 1/2''",63,51.4,0.29]
["PolietilenoPE50BPN163/4''","Polietileno","PE50B",16,"3/4''",20,14.4,0.29]
["PolietilenoPE50BPN161''","Polietileno","PE50B",16,"1''",25,18,0.29]
["PolietilenoPE50BPN161 1/4''","Polietileno","PE50B",16,"1 1/4''",32,23.2,0.29]
["PolietilenoPE50BPN161 1/2''","Polietileno","PE50B",16,"1 1/2''",40,29,0.29]
["PolietilenoPE50BPN162''","Polietileno","PE50B",16,"2''",50,36.2,0.29]
["PolietilenoPE50BPN162 1/2''","Polietileno","PE50B",16,"2 1/2''",63,45.8,0.29]
["PolietilenoPE80PN63/4''","Polietileno","PE80",6,"3/4''","-","-",0.43]
["PolietilenoPE80PN61''","Polietileno","PE80",6,"1''","-","-",0.43]
["PolietilenoPE80PN61 1/4''","Polietileno","PE80",6,"1 1/4''","-","-",0.43]
["PolietilenoPE80PN61 1/2''","Polietileno","PE80",6,"1 1/2''",40,35.4,0.43]
["PolietilenoPE80PN62''","Polietileno","PE80",6,"2''",50,45.2,0.43]
["PolietilenoPE80PN62 1/2''","Polietileno","PE80",6,"2 1/2''",63,57,0.43]
["PolietilenoPE80PN103/4''","Polietileno","PE80",10,"3/4''",20,16,0.43]
["PolietilenoPE80PN101''","Polietileno","PE80",10,"1''",25,21,0.43]
["PolietilenoPE80PN101 1/4''","Polietileno","PE80",10,"1 1/4''",32,27.2,0.43]
["PolietilenoPE80PN101 1/2''","Polietileno","PE80",10,"1 1/2''",40,34,0.43]
["PolietilenoPE80PN102''","Polietileno","PE80",10,"2''",50,42.6,0.43]
[{"$f":"CONCATENATE(B67,C67,\"PN\",D67,E67)","v":"PolietilenoPE80PN102 1/2''"},"Polietileno","PE80",10,"2 1/2''",63,53.6,0.43]
["PolietilenoPE100PN63/4''","Polietileno","PE100",6,"3/4''",20,16,0.43]
["PolietilenoPE100PN61''","Polietileno","PE100",6,"1''",25,21,0.43]
["PolietilenoPE100PN61 1/4''","Polietileno","PE100",6,"1 1/4''",32,28,0.43]
["PolietilenoPE100PN61 1/2''","Polietileno","PE100",6,"1 1/2''",40,35.4,0.43]
["PolietilenoPE100PN62''","Polietileno","PE100",6,"2''",50,45.4,0.43]
["PolietilenoPE100PN62 1/2''","Polietileno","PE100",6,"2 1/2''",63,58.2,0.43]
["PolietilenoPE100PN103/4''","Polietileno","PE100",10,"3/4''",20,16,0.43]
["PolietilenoPE100PN101''","Polietileno","PE100",10,"1''",25,21,0.43]
["PolietilenoPE100PN101 1/4''","Polietileno","PE100",10,"1 1/4''",32,27.2,0.43]
["PolietilenoPE100PN101 1/2''","Polietileno","PE100",10,"1 1/2''",40,35.2,0.43]
["PolietilenoPE100PN102''","Polietileno","PE100",10,"2''",50,44,0.43]
["PolietilenoPE100PN102 1/2''","Polietileno","PE100",10,"2 1/2''",63,55.4,0.43]
["PolietilenoPE100PN163/4''","Polietileno","PE100",16,"3/4''",20,16,0.43]
["PolietilenoPE100PN161''","Polietileno","PE100",16,"1''",25,20.4,0.43]
["PolietilenoPE100PN161 1/4''","Polietileno","PE100",16,"1 1/4''",32,26.2,0.43]
["PolietilenoPE100PN161 1/2''","Polietileno","PE100",16,"1 1/2''",40,32.6,0.43]
["PolietilenoPE100PN162''","Polietileno","PE100",16,"2''",50,40.8,0.43]
["PolietilenoPE100PN162 1/2''","Polietileno","PE100",16,"2 1/2''",63,51.4,0.43]
["PolietilenoPE100PN253/4''","Polietileno","PE100",25,"3/4''","-","-",0.43]
["PolietilenoPE100PN251''","Polietileno","PE100",25,"1''",25,18,0.43]
["PolietilenoPE100PN251 1/4''","Polietileno","PE100",25,"1 1/4''",32,23.2,0.43]
["PolietilenoPE100PN251 1/2''","Polietileno","PE100",25,"1 1/2''",40,29,0.43]
["PolietilenoPE100PN252''","Polietileno","PE100",25,"2''",50,36.2,0.43]
["PolietilenoPE100PN252 1/2''","Polietileno","PE100",25,"2 1/2''",63,45.8,0.43]
["PolibutilenoPB4PN83/4''","Polibutileno","PB4",8,"3/4''",22,17.2,0.36]
["PolibutilenoPB4PN103/4''","Polibutileno","PB4",10,"3/4''",22,17.2,0.36]
["PolibutilenoPB4PN101''","Polibutileno","PB4",10,"1''",25,20.4,0.36]
["PolibutilenoPB4PN101 1/4''","Polibutileno","PB4",10,"1 1/4''",32,26.2,0.36]
["PolibutilenoPB4PN101 1/2''","Polibutileno","PB4",10,"1 1/2''",40,32.6,0.36]
["PolibutilenoPB5PN83/4''","Polibutileno","PB5",8,"3/4''",22,17.2,0.38]
["PolibutilenoPB5PN81''","Polibutileno","PB5",8,"1''",25,20.4,0.38]
["PolibutilenoPB5PN81 1/4''","Polibutileno","PB5",8,"1 1/4''",32,26.2,0.38]
["PolibutilenoPB5PN81 1/2''","Polibutileno","PB5",8,"1 1/2''",40,32.6,0.38]
["PolibutilenoPB5PN82''","Polibutileno","PB5",8,"2''",50,40.8,0.38]
["PolibutilenoPB5PN82 1/2''","Polibutileno","PB5",8,"2 1/2''",63,51.4,0.38]
["PolibutilenoPB5PN103/4''","Polibutileno","PB5",10,"3/4''",22,17.2,0.38]
["PolibutilenoPB5PN101''","Polibutileno","PB5",10,"1''",25,20.4,0.38]
["PolibutilenoPB5PN101 1/4''","Polibutileno","PB5",10,"1 1/4''",32,26.2,0.38]
["PolibutilenoPB5PN101 1/2''","Polibutileno","PB5",10,"1 1/2''",40,32.6,0.38]
["PolibutilenoPB5PN102''","Polibutileno","PB5",10,"2''",50,40.8,0.38]
["PolibutilenoPB5PN102 1/2''","Polibutileno","PB5",10,"2 1/2''",63,51.4,0.38]
[]
["Polietileno"]
["Polibutileno"]
["PE32"]
["PE50A"]
["PE50B"]
["PE80"]
["PE100"]
["PB4"]
["PB5"]
["PN4"]
["PN6"]
["PN8"]
["PN10"]
["PN16"]
["PN25"]
["3/4”"]
["1”"]
["1 1/4”"]
["1 1/2”"]
["2”"]
["2 1/2”"]

{"sheet":"DATOS FLUIDOS","index":12,"n_rows":33,"n_cols":7,"rows_kept":33,"merged":[[16,0,16,6],[25,0,25,6]]}
["Tipo","T° Media\n°C","Punto Congelamiento\n°C","Densidad\nkg/m3","Capacidad Térmica\nJ/kg°K","Conductividad\nW/m°K","Viscosidad\nPa s"]
["Agua Pura",20,0,998.1,4173,0.5929,0.001002]
["Agua/Etilenglicol",{"$f":"B8-273.15","v":32},{"$f":"B15-273.15","v":0},{"$f":"B10","v":{"v":995.007128202877,"d":"995.0"}},{"$f":"B11*1000","v":{"v":4197.974372062434,"d":"4198.0"}},{"$f":"B12","v":{"v":0.6082432515064661,"d":"0.608"}},{"$f":"B13","v":{"v":7.5139959667272136E-4,"d":"0.000751"}}]
["Agua/Propilenglicol",{"$f":"C8-273.15","v":32},{"$f":"C15-273.15","v":0},{"$f":"C10","v":{"v":994.5227977925492,"d":"994.5"}},{"$f":"C11*1000","v":{"v":4220.01551381013,"d":"4220.0"}},{"$f":"C12","v":{"v":0.6190781802152782,"d":"0.619"}},{"$f":"C13","v":{"v":7.7895354146462149E-4,"d":"0.000779"}}]
[]
["Mezcla con","Etilenglicol","Propilenglico"]
["% Peso de la solución",{"$f":"'TUBERIA Y FLUIDO'!E4/100","v":0},{"$f":"'TUBERIA Y FLUIDO'!E4/100","v":0}]
["Temperatura media del fluido",{"$f":"'TUBERIA Y FLUIDO'!E5+273.15","v":305.15},{"$f":"'TUBERIA Y FLUIDO'!E5+273.15","v":305.15},"[K]"]
[]
["Densidad",{"$f":"B20+B21*B7+B22*273.15/B8+B23*B7*273.15/B8+B24*(273.15/B8)^2","v":995.007128202877},{"$f":"B29+B30*C7+B31*273.15/C8+B32*C7*273.15/C8+B33*(273.15/C8)^2","v":994.5227977925492},"[kg/m3]"]
["Capacidad Térmica",{"$f":"C20+C21*B7+C22*273.15/B8+C23*B7*273.15/B8+C24*(273.15/B8)^2","v":4.197974372062434},{"$f":"C29+C30*C7+C31*273.15/C8+C32*C7*273.15/C8+C33*(273.15/C8)^2","v":4.22001551381013},"[kJ/kg K]"]
["Conductividad Térmica",{"$f":"D20+D21*B7+D22*273.15/B8+D23*B7*273.15/B8+D24*(273.15/B8)^2","v":0.6082432515064661},{"$f":"D29+D30*C7+D31*273.15/C8+D32*C7*273.15/C8+D33*(273.15/C8)^2","v":0.6190781802152782},"[W/m K]"]
["Viscocidad Dinámica",{"$f":"EXP(E20+E21*B7+E22*273.15/B8+E23*B7*273.15/B8+E24*(273.15/B8)^2)","v":7.5139959667272136E-4},{"$f":"EXP(E29+E30*C7+E31*273.15/C8+E32*C7*273.15/C8+E33*(273.15/C8)^2)","v":7.7895354146462149E-4},"[Pa s]"]
["Prandtl Number",{"$f":"EXP(F20+F21*B7+F22*273.15/B8+F23*B7*273.15/B8+F24*(273.15/B8)^2)","v":5.135221482443658},{"$f":"EXP(F29+F30*C7+F31*273.15/C8+F32*C7*273.15/C8+F33*(273.15/C8)^2)","v":5.237386140371567}]
["T° Congelamiento",{"$f":"273.15*(G19+G20*B7+G21*(B7)^2)","v":273.15},{"$f":"273.15*(G28+G29*C7+G30*(C7)^2)","v":273.15},"[K]"]
[]
["Parámateros del modelo matematico de soluciones acuosas de etilenglicol"]
["Coef.","ρ\n[kg/m3]","Cp\n[kJ/kg K]","λ\n[W/m K]","µ\n[Pa s]","Pr","Tf\n[K]"]
[0,{"$nulls":5},1]
[1,658.49825,5.36449,0.83818,-4.63024,3.96951,-0.06982]
[2,-54.81501,0.78863,-1.3762,-2.14817,0.70076,-0.3578]
[3,664.71643,-2.59001,-0.07629,-12.70106,-12.98045]
[4,232.72605,-2.73187,1.0772,5.40536,2.64789]
[5,-322.61661,1.43759,-0.20174,10.9899,11.589]
[]
["Parámateros del modelo matematico de soluciones acuosas de propilenglicol"]
["Coef.","ρ\n[kg/m3]","Cp\n[kJ/kg K]","λ\n[W/m K]","µ\n[Pa s]","Pr","Tf\n[K]"]
[0,{"$nulls":5},1]
[1,508.41109,4.47642,1.18886,-1.02798,6.66139,-0.03736]
[2,-182.4082,0.60863,-1.4911,-10.03298,-6.9944,-0.4005]
[3,965.76507,-0.71497,-0.69682,-19.93497,-18.55114]
[4,280.29104,-1.93855,1.13633,14.65802,12.0464]
[5,-472.2251,0.47873,0.06735,14.6205,14.47735]

{"sheet":"PROPIEDAD FLUIDOS","index":13,"n_rows":54,"n_cols":11,"rows_kept":54}
["Forced Convection Heat Transfer Coefficient Correlations   (S.I. units)",{"$nulls":8},"      Equations for Forced Convection Flow inside Pipes"]
[]
["1. Turbulent Flow Inside a Circular Tube"]
[]
["Inputs",{"$nulls":4},"Calculations"]
[]
["Fluid =",{"$f":"'TUBERIA Y FLUIDO'!E3","v":"Agua Pura"},{"$nulls":3},"Reynolds Number, Re =",null,{"$f":"C13*C16*C18/C20","v":{"v":17524.461381157435,"d":"17,524"}}]
[]
["Ave. Fluid Temp, Tb =",null,{"$f":"VLOOKUP(B7,'DATOS FLUIDOS'!$A$2:$G$4,2,FALSE)","v":20},"oC",null,"Prandtl Number, Pr =",null,{"$f":"C20*C22/C28","v":{"v":7.052362961713613,"d":"7.05"}}]
[]
["Pipe Diam., D =",null,{"$f":"'TUBERIA Y FLUIDO'!B8*1000","v":21},"mm",null," Correlation #1, the Dittus Boelter Correlation",{"$nulls":4}," Correlation #1, the Dittus Boelter Correlation"]
[]
["Pipe Diam., D =",null,{"$f":"C11/1000","v":0.021},"m",null,"Twall > Tfluid:","   Nuo =",{"$f":"0.023*(H7^0.8)*(H9^0.4)","v":{"v":124.73187227613813,"d":"125"}}]
["     (calculated)"]
[{"$nulls":6},"   ho  =",{"$f":"H13*C$31/C$13","v":{"v":12677.747498146678,"d":"12678"}},"kJ/hr-m2-K"]
["Ave. Velocity, V =",null,{"$f":"('TUBERIA Y FLUIDO'!E7/(1000*3600))/(PI()*'TUBERIA Y FLUIDO'!B8^2/4)","v":0.8377588992380642},"m/s"]
[{"$nulls":5},"Twall > Tfluid:","   Nuo =",{"$f":"0.026*(H7^0.8)*(H9^0.3)","v":{"v":115.98170469201618,"d":"116"}}]
["Fluid Density, r =",null,{"$f":"'TUBERIA Y FLUIDO'!E8","v":998.1},"kg/m3 "]
[{"$nulls":6},"   ho  =",{"$f":"H17*C$31/C$13","v":{"v":11788.380464896522,"d":"11788"}},"kJ/hr-m2-K"]
["Fluid viscosity, m =",null,{"$f":"'TUBERIA Y FLUIDO'!E11","v":0.001002},"N-s/m2 "]
[{"$nulls":6},"    f =",{"$f":"(0.79*LN(H7)-1.64)^(-2)","v":{"v":0.027057209975315227,"d":"0.02706"}},null,null," Correlation #2, Convection H.T.,  Turb. Pipe Flow"]
["Fluid Sp. Heat, Cp =",null,{"$f":"'TUBERIA Y FLUIDO'!E9/1000","v":4.173},"kJ/kg-K"]
[{"$nulls":5}," Correlation #2:"]
["Fluid Thermal "]
["       Conductivity, k =",null,{"$f":"'TUBERIA Y FLUIDO'!E10","v":0.5929},"W/m-K",null,null,"   Nuo =",{"$f":"((H$21/8)*(H$7-1000)*H$9)/(1+(12.7*((H$21/8)^0.5)*((H$9^(2/3))-1)))","v":{"v":132.37044121851122,"d":"132"}}]
[]
["Fluid Thermal ",{"$nulls":5},"   ho  =",{"$f":"H25*C$31/C$13","v":{"v":13454.131645449479,"d":"13454"}},"kJ/hr-m2-K"]
["       Conductivity, k =",null,{"$f":"C25/1000","v":5.9289999999999994E-4},"kJ/s-m-K"]
[]
["Fluid Thermal ",{"$nulls":4}," Correlation #3:",{"$nulls":4},"Correlation #3, Convection H.T.,  Turb. Pipe Flow"]
["       Conductivity, k =",null,{"$f":"C28*3600","v":2.1344399999999997},"kJ/hr-m-K"]
[{"$nulls":6},"   Nuo =",{"$f":"((H$21/8)*(H$7-1000)*H$9)*(1+((C13/C33)^(2.3)))/(1+(12.7*((H$21/8)^0.5)*((H$9^(2/3))-1)))","v":{"v":132.37089334961453,"d":"132"}}]
["Pipe Length, L =",null,5,"m"]
[{"$nulls":6},"   ho  =",{"$f":"H32*C$31/C$13","v":{"v":13454.17760005482,"d":"13454"}},"kJ/hr-m2-K"]
[]
[]
[]
["Correction for Temperature Variation:  ( h  =  ho(mb/mw)0.14 "]
[]
["Inputs",{"$nulls":4},"Calculations"]
[]
["Ave. Fluid Temp, Tb =",null,30,"oC",null," Correlation #1, the Dittus Boelter Correlation"]
[]
["Fluid Visc. at Tb,  mb =",null,7.85E-4,"N-s/m2 ",null,"Twall > Tfluid:","h =",{"$f":"H15*(C$44/C$48)^0.14","v":{"v":13258.7129983654,"d":"13259"}},"kJ/hr-m2-K"]
[]
["Ave. Wall Temp, Tw =",null,50,"oC",null,"Twall > Tfluid:","h =",{"$f":"H19*(C$44/C$48)^0.14","v":{"v":12328.590179166222,"d":"12329"}},"kJ/hr-m2-K"]
[]
["Fluid Visc. at Tw,  mw =",null,0.00057,"N-s/m2 ",null," Correlation #2:"]
[]
[{"$nulls":6},"h =",{"$f":"H27*(C$44/C$48)^0.14","v":{"v":14070.675422058828,"d":"14071"}},"kJ/hr-m2-K"]
[]
[{"$nulls":5}," Correlation #3:"]
[]
[{"$nulls":6},"h =",{"$f":"H34*(C$44/C$48)^0.14","v":{"v":14070.723482561947,"d":"14071"}},"kJ/hr-m2-K"]

{"sheet":"DATOS SUELOS","index":14,"n_rows":42,"n_cols":6,"rows_kept":42,"merged":[[0,2,0,4]]}
[null,"TIPO DE ROCA","Conductividad térmica\n(W/mK)",null,null,"Capacidad térmica volumétrica (MJ/m3K)"]
[null,null,"Mín.","Valor típico","Máx."]
[null,"DEFINIDO POR EL USUARIO"]
[{"$f":"CONCATENATE($B$3,\" - \",B4)","v":"DEFINIDO POR EL USUARIO - Maxey Elementary School"},"Maxey Elementary School",null,2.25,null,2.877]
[{"$f":"CONCATENATE($B$3,\" - \",B5)","v":"DEFINIDO POR EL USUARIO - Fort Polk"},"Fort Polk",null,2.423,null,2.676]
[{"$f":"CONCATENATE($B$3,\" - \",B6)","v":"DEFINIDO POR EL USUARIO - "}]
[null,"ROCAS MAGMÁTICAS"]
[{"$f":"CONCATENATE($B$7,\" - \",B8)","v":"ROCAS MAGMÁTICAS - Basalto"},"Basalto",1.3,1.7,2.3,2.45]
["ROCAS MAGMÁTICAS - Diorita","Diorita",2,2.6,2.9,2.9]
["ROCAS MAGMÁTICAS - Grabo","Grabo",1.7,1.9,2.5,2.6]
["ROCAS MAGMÁTICAS - Granito","Granito",2.1,3.4,4.1,2.55]
["ROCAS MAGMÁTICAS - Peridotita","Peridotita",3.8,4,5.3,2.7]
["ROCAS MAGMÁTICAS - Riolita","Riolita",3.1,3.3,3.4,2.1]
[null,"ROCAS METAMÓRFICAS"]
[{"$f":"CONCATENATE($B$14,\" - \",B15)","v":"ROCAS METAMÓRFICAS - Gneis"},"Gneis",1.9,2.9,4,2]
[{"$f":"CONCATENATE($B$14,\" - \",B16)","v":"ROCAS METAMÓRFICAS - Mármol"},"Mármol",1.3,2.1,3.1,2]
[{"$f":"CONCATENATE($B$14,\" - \",B17)","v":"ROCAS METAMÓRFICAS - Metacuarcita"},"Metacuarcita",null,5.8,null,2.1]
[{"$f":"CONCATENATE($B$14,\" - \",B18)","v":"ROCAS METAMÓRFICAS - Micasquistos"},"Micasquistos",1.5,2,3.1,2.2]
[{"$f":"CONCATENATE($B$14,\" - \",B19)","v":"ROCAS METAMÓRFICAS - Esquistos arcillosos"},"Esquistos arcillosos",1.5,2.1,2.1,2.35]
[null,"ROCAS SEDIMENTARIAS"]
[{"$f":"CONCATENATE($B$20,\" - \",B21)","v":"ROCAS SEDIMENTARIAS - Caliza"},"Caliza",2.5,2.8,4,2.25]
["ROCAS SEDIMENTARIAS - Marga","Marga",1.5,2.1,3.5,2.25]
["ROCAS SEDIMENTARIAS - Cuarcita","Cuarcita",3.6,6,6.6,2.15]
["ROCAS SEDIMENTARIAS - Sal","Sal",5.3,5.4,6.4,1.2]
["ROCAS SEDIMENTARIAS - Arenisca","Arenisca",1.3,2.3,5.1,2.2]
["ROCAS SEDIMENTARIAS - Limolitas y argilitas","Limolitas y argilitas",1.1,2.2,3.5,2.25]
[null,"ROCAS NO CONSOLIDADAS"]
[{"$f":"CONCATENATE($B$27,\" - \",B28)","v":"ROCAS NO CONSOLIDADAS - Grava, seca"},"Grava, seca",0.4,0.4,0.5,1.5]
[{"$f":"CONCATENATE($B$27,\" - \",B29)","v":"ROCAS NO CONSOLIDADAS - Grava, saturada de agua"},"Grava, saturada de agua",null,1.8,null,2.4]
["ROCAS NO CONSOLIDADAS - Arena, seca","Arena, seca",0.3,0.4,0.8,1.45]
["ROCAS NO CONSOLIDADAS - Arena, saturada de agua","Arena, saturada de agua",1.7,2.4,5,2.55]
["ROCAS NO CONSOLIDADAS - Arcilla/limo, seco","Arcilla/limo, seco",0.4,0.5,1,1.55]
["ROCAS NO CONSOLIDADAS - Arcilla/limo, saturado de agua","Arcilla/limo, saturado de agua",0.9,1.7,2.3,2.5]
["ROCAS NO CONSOLIDADAS - Turba","Turba",0.2,0.4,0.7,2.15]
[null,"OTROS MATERIALES"]
[{"$f":"CONCATENATE($B$35,\" - \",B36)","v":"OTROS MATERIALES - Bentonita"},"Bentonita",0.5,0.6,0.8,3.9]
[{"$f":"CONCATENATE($B$35,\" - \",B37)","v":"OTROS MATERIALES - Hormigón"},"Hormigón",0.9,1.6,2,1.8]
["OTROS MATERIALES - Hielo (-10°C)","Hielo (-10°C)",null,2.32,null,1.87]
["OTROS MATERIALES - Plástico (PE)","Plástico (PE)",null,0.39]
["OTROS MATERIALES - Aire (0-20 °C, seco)","Aire (0-20 °C, seco)",null,0.02,null,0.0012]
["OTROS MATERIALES - Acero","Acero",null,60,null,3.12]
["OTROS MATERIALES - Agua (+ 10°C)","Agua (+ 10°C)",null,0.58,null,4.19]

{"sheet":"INGRESO TERRENO","index":15,"n_rows":5,"n_cols":3,"rows_kept":5,"merged":[[0,0,0,3]]}
["INGRESO TIPO SUELO"]
[]
["Tipo Suelo"]
["Conductividad Térmica",null,"W/m°K"]
["Capacidad Térmica",null,"MJ/m3°K"]

{"sheet":"coefficients","index":16,"n_rows":40,"n_cols":8,"rows_kept":40,"merged":[[2,6,2,7]]}
[]
[null,"Coefficients for f6h, f1m, f10y functions",{"$nulls":4},"Coefficients for Tp correlation"]
[null,null,"f6h","f1m","f10y",null,"Tp function's coefficients"]
[null,"a0",0.6619352,0.4132728,0.3057646,null,"b0",{"v":7.8189,"d":"7.8189E+00"}]
[null,"a1",-4.815693,0.2912981,0.08987446,null,"b1",{"v":-64.27,"d":"-6.4270E+01"}]
[null,"a2",15.03571,0.07589286,-0.09151786,null,"b2",{"v":153.87,"d":"1.5387E+02"}]
[null,"a3",{"v":-0.09879421000000001,"d":"-0.09879421"},0.1563978,{"v":-0.038724510000000004,"d":"-0.03872451"},null,"b3",{"v":-84.809,"d":"-8.4809E+01"}]
[null,"a4",0.02917889,-0.2289355,0.1690853,null,"b4",{"v":3.461,"d":"3.4610E+00"}]
[null,"a5",0.1138498,{"v":-0.004927554000000001,"d":"-0.004927554"},-0.02881681,null,"b5",{"v":-0.9475300000000001,"d":"-9.4753E-01"}]
[null,"a6",0.005610933,-0.002694979,-0.002886584,null,"b6",{"v":-0.060416,"d":"-6.0416E-02"}]
[null,"a7",0.7796329,{"v":-0.6380359999999999,"d":"-0.6380360"},-0.1723169,null,"b7",{"v":1.5631,"d":"1.5631E+00"}]
[null,"a8",{"v":-0.324388,"d":"-0.3243880"},0.2950815,0.03112034,null,"b8",{"v":-0.0089416,"d":"-8.9416E-03"}]
[null,"a9",{"v":-0.018241010000000002,"d":"-0.01824101"},{"v":0.149332,"d":"0.1493320"},-0.1188438,null,"b9",{"v":1.9061000000000003E-5,"d":"1.9061E-05"}]
[{"$nulls":6},"b10",{"v":-2.289,"d":"-2.2890E+00"}]
[{"$nulls":6},"b11",{"v":0.10187,"d":"1.0187E-01"}]
[{"$nulls":6},"b12",{"v":0.006568999999999999,"d":"6.5690E-03"}]
[{"$nulls":6},"b13",{"v":-40.918,"d":"-4.0918E+01"}]
[{"$nulls":6},"b14",{"v":15.557,"d":"1.5557E+01"}]
[{"$nulls":6},"b15",{"v":-19.107,"d":"-1.9107E+01"}]
[{"$nulls":6},"b16",{"v":0.10529000000000001,"d":"1.0529E-01"}]
[{"$nulls":6},"b17",{"v":25.501,"d":"2.5501E+01"}]
[{"$nulls":6},"b18",{"v":-2.1177,"d":"-2.1177E+00"}]
[{"$nulls":6},"b19",{"v":77.529,"d":"7.7529E+01"}]
[{"$nulls":6},"b20",{"v":-50.454,"d":"-5.0454E+01"}]
[{"$nulls":6},"b21",{"v":76.352,"d":"7.6352E+01"}]
[{"$nulls":6},"b22",{"v":-0.5371900000000001,"d":"-5.3719E-01"}]
[{"$nulls":6},"b23",{"v":-132,"d":"-1.3200E+02"}]
[{"$nulls":6},"b24",{"v":12.878,"d":"1.2878E+01"}]
[{"$nulls":6},"b25",{"v":0.12697,"d":"1.2697E-01"}]
[{"$nulls":6},"b26",{"v":-0.00040284,"d":"-4.0284E-04"}]
[{"$nulls":6},"b27",{"v":-0.07206499999999999,"d":"-7.2065E-02"}]
[{"$nulls":6},"b28",{"v":0.00095184,"d":"9.5184E-04"}]
[{"$nulls":6},"b29",{"v":-0.024166999999999998,"d":"-2.4167E-02"}]
[{"$nulls":6},"b30",{"v":9.6811e-05,"d":"9.6811E-05"}]
[{"$nulls":6},"b31",{"v":0.028317,"d":"2.8317E-02"}]
[{"$nulls":6},"b32",{"v":-1.0904999999999999E-3,"d":"-1.0905E-03"}]
[{"$nulls":6},"b33",{"v":0.12207000000000001,"d":"1.2207E-01"}]
[{"$nulls":6},"b34",{"v":-0.007104999999999999,"d":"-7.1050E-03"}]
[{"$nulls":6},"b35",{"v":-1.1129E-3,"d":"-1.1129E-03"}]
[{"$nulls":6},"b36",{"v":-0.00045566,"d":"-4.5566E-04"}]

{"sheet":"Instructions","index":17,"n_rows":12,"n_cols":5,"rows_kept":12,"merged":[[1,2,2,2],[1,4,5,4]]}
["Instructions for using the \"bh_sizing\" worksheet, v. 1"]
["1) Fill in the coloured cells (D3 to D21 or E3 to E21) of the section \"1st set of inputs\" with your input parameters",null,"Single  borehole design",null,"Multiple boreholes design"]
["2) The results of the calculations with Tp = 0 (without taking into account the thermal interference among boreholes) are given in section \"1st set of results\".  For single borehole designs, calculations stop here and the value in cell D35 is the required borehole depth. For multiple boreholes, the length given in cell D35 should be regarded as a first approximation of the total borehole length."]
["3) To size a borefield by taking into account the thermal interference, determine the three parameters B (borehole spacing) , NB (number of boreholes) and A (borefield aspect ratio). Use the  1st set of results, which gives a first approximation of the final value of the borehole length, to estimate these three parameters."]
["4) Fill in the coloured cells (E38, E39, E40) of the section \"2nd set of inputs\" with the values of B, NB, and A."]
["5) The final results are given at the end of the section \"final results\", i.e, cells E69 and E70."]
[]
[]
[]
[]
[]
["ASHRAE does not warrant nor guarantee the spreadsheet “Borehole Sizing.\" The entire risk of the use of any information contained herein is assumed by the user"]