{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Ingreso de Datos","Hoja1","Datos del Conductor","Gráficas Sf","Resultados Estudio Técnico","Datos Estudio Económico","Impresión","Estudio Económico"],"not_rendered":{"charts":1,"images":14,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Ingreso de Datos","index":0,"n_rows":213,"n_cols":9,"rows_kept":213,"cut":false,"hidden":false,"merged":[[197,0,197,8],[143,7,146,11],[145,3,145,4],[146,1,147,6],[151,7,151,11],[170,2,170,3],[169,7,171,8],[168,2,168,3],[162,2,162,3],[166,2,166,3],[167,2,167,3],[112,0,112,8],[15,7,19,12],[89,7,91,8],[59,2,59,3],[60,2,60,3],[54,2,57,5],[58,7,58,12],[48,2,48,3],[49,2,49,3],[50,2,50,3],[90,4,90,5],[92,2,92,3],[93,2,93,3],[94,2,94,3],[90,2,90,3],[85,2,85,3],[11,2,11,3],[15,2,15,5],[8,0,8,8],[82,0,82,8],[10,2,10,5],[12,2,12,3],[13,2,13,3],[15,0,15,1],[53,2,53,3],[77,2,77,3],[102,2,102,3],[103,2,103,3],[95,2,95,3],[101,2,101,3],[104,2,104,3],[96,2,96,3],[97,2,97,3],[98,2,98,3],[99,2,99,3],[100,2,100,3],[0,0,0,8],[199,2,201,5],[29,7,29,13],[1,0,1,4],[150,2,150,3],[151,2,151,3],[149,2,149,3],[119,2,119,3],[120,2,120,3],[127,2,127,3],[128,2,128,3],[129,2,129,3],[123,1,124,6],[105,2,105,3],[117,2,117,3],[117,4,117,5],[212,2,219,7],[122,3,122,4],[126,2,126,3],[141,2,141,3],[142,2,142,3],[143,2,143,3],[163,2,163,3],[164,2,164,3],[165,2,165,3],[169,2,169,3],[180,2,182,5],[192,2,194,5],[139,0,139,8],[160,0,160,8],[178,0,178,8],[190,0,190,8],[3,0,4,8],[2,0,2,8],[100,4,100,6],[101,4,101,6],[98,4,98,6],[87,2,87,3],[88,2,88,3],[84,2,84,3],[86,2,86,3],[52,2,52,3],[17,2,17,5],[37,2,37,3],[35,2,35,3],[36,2,36,3],[41,2,46,5],[39,2,39,3]]}
["Aplicativo para el Estudio Técnico y Económico para un Sistema de Puesta a Tierra\nBasado en la norma IEEE Std 80 - 2000 \"Guide for Safety in AC Substation Grounding\""]
["Realizado por: Ing Sonni Troncoso Mendoza",null,null,null,null,null,null,null,2014]
["ESTUDIO TÉCNICO"]
["Para iniciar el Estudio Técnico: \nPresione el botón NUEVO PROYECTO. Luego comience a digitar los datos de entrada. A continuación los botones serán quienes adelanten los datos para los cálculos, por lo tanto al finalizar cada etapa Presione el botón ENVIAR DATOS."]
[]
[]
[]
[]
["DATOS DEL TERRENO (PASO 1)"]
[]
[null,null,"Área disponible para la malla"]
[null,null,"Descripción ",null,"Valor / Cantidad","Unidad"]
[null,null,"Lado Mayor, Lx",null,null,"m"]
[null,null,"Lado Menor, Ly",null,null,"m"]
[]
[null,null,"MEDICIONES DE RESISTIVIDAD, MÉTODO WENNER",null,null,null,null,"                                                 ¿Cómo se completa?\n1. Digite las Distancias a las cuales realizó las mediciones.\n2. Si midió datos de Resistencia, digítelos y presione el botón Calcular Resistividades. Pero si midió Resistividad, digite los datos y presiones el botón Procesar mediciones."]
[]
[null,null,"TABLA DE MEDICIONES"]
[null,null,"Medida #","Distancia a (m)","R (Ω)","ρa=2πaR (Ω.m)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"GRÁFICA DE SUNDE"]
[]
[]
[]
[]
[]
[null,null,"Descripción",null,"Valor / Cantidad","Unidad"]
[null,null,"Resistividad de la primera capa (ρ1)",null,null,"Ω.m"]
[null,null,"Resistividad de la segunda capa (ρ2)",null,null,"Ω.m"]
[]
[null,null,"Relación ρ2 / ρ1",null,null,"Ω.m"]
[]
[null,null,"El Valor de ρ2/ρ1 debe ser ubicado en la Gráfica de Sunde, \"trazando\" una curva como las observadas que al valor ρ2/ρ1.\nSe selecciona un valor de ρa/ρ1 correspondiente a la zona curvada ρ2/ρ1.\n\nSe selecciona el valor correspondiente de a/h en el Eje X, tal que intersecte con el valor de ρa/ρ1 sobre la curva ρ2/ρ1.\n"]
[]
[]
[]
[]
[]
[]
[null,null,"Descripción",null,"Valor / Cantidad","Unidad"]
[null,null,"Relación ρa/ρ1",null,null,"-"]
[null,null,"Relación a/h",null,null,"-"]
[]
[null,null,"Resistividad calculada, ρa ",null,null,"Ω.m"]
[]
[null,null,"La Resistividad aparente, ρa calculada se traza en la gráfica  de Resistividad aparente de cada una de la mediciones, Gráfico  pa vs a, estableciendo el valor de a en el Eje X para ese valor de Resistividad aparente.\n"]
[]
[]
[]
[null,null,null,null,null,null,null,"Figura 1. Gráfica de Sunde (IEEE Std 80 - 2000)"]
[null,null,"Descripción",null,"Valor / Cantidad","Unidad"]
[null,null,"Distancia entre conductores, a (m) ",null,null,"m"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["PARA EL CÁLCULO DEL CONDUCTOR (PASO 2)"]
[]
[null,null,"Descripción ",null,"Valor / Cantidad","Unidad"]
[null,null,"Corriente de falla a tierra, Lado AT",null,null,"A"]
[null,null,"Corriente de falla a tierra, Lado BT",null,null,"A"]
[null,null,"Duración de la falla, Duración de Choque, tf y tc",null,null,"seg"]
[null,null,"Temperatura ambiente, ta",null,null,"°C"]
[null,null,null,null,null,null,null,"Seleccione Conductor. Nota: Lista Desplegable"]
[null,null,"Conductor a utilizar"]
[]
[null,null,"DESCRIPCIÓN"]
[null,null,"Cobre recocido"]
[null,null,"Cobre  estirado en frío "]
[null,null,"Acero revestido de cobre"]
[null,null,"Acero revestido de cobre"]
[null,null,"Acero revestido de cobre. b"]
[null,null,"Aluminio, EC"]
[null,null,"Aluminio, aleación 5005"]
[null,null,"Aluminio aleación 6201"]
[null,null,"Acero revestido de aluminio "]
[null,null,"Acero, 1020"]
[null,null,"Acero inoxidable revestido. c"]
[null,null,"Acero galvanizado "]
[null,null,"Acero inoxidable 304"]
[]
[]
[]
[]
[]
[]
["CRITERIO DE TENSIÓN DE PASO Y CONTACTO (PASO 3)"]
[]
[]
[]
[]
[null,null,"Criterio a utilizar"]
[]
[null,null,"Descripción ",null,"Valor / Cantidad","Unidad"]
[null,null,"Tiempo de Choque, tc",null,null,"seg"]
[]
[null,null,null,"CAPA SUPERFICIAL"]
[null,"Si va a utilizar Capa superficial en el terreno, digite los valores de profundidad de Capa superficial, hs, y de Resistividad de la capa superficial ρs. Y seleccione la opción \"Con capa superficial\", de lo contrario, seleccione la opción \"Sin capa superficial\"."]
[]
[]
[null,null,"Descripción ",null,"Valor / Cantidad","Unidad"]
[null,null,"Profundidad de capa superficial, hs",null,null,"m"]
[null,null,"Resistividad de la capa superficial, ρs",null,null,"Ω.m"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["DISEÑO PRELIMINAR (PASO 4)"]
[]
[null,null,"Descripción ",null,"Valor / Cantidad","Unidad"]
[null,null,"Distancia entre conductores, D",null,null,"m"]
[null,null,"Profundidad de la malla, hm",null,null,"Ω.m",null,"El valor de hm no puede ser menor a 0,5 m (Valor predeterminado). En el caso de utilizar Capa superficial, sumar el espesor de la capa al valor de hm."]
[]
[null,null,null,"TIPO DE ARREGLO"]
[null,"Escoja el tipo de arreglo a utilizar para el diseño preliminar del SPT. \nSi va a utilizar el Diseño Sin Varillas a tierra solo seleccione la opción a continuación. De lo contrario digite los valores de nr y Lr y seleccione la opción Con Varillas a Tierra."]
[]
[]
[null,null,"Descripción ",null,"Valor / Cantidad","Unidad"]
[null,null,"Número de varillas a tierra, nr",null,null,"-"]
[null,null,"Longitud de cada varilla a tierra, Lr",null,2.4,"m",null,"\"La Longitud mínima de la varilla a tierra es de 2,4 m\" "]
[]
[]
[]
[]
[]
[]
[]
[]
["CÁLCULO DE MÁXIMA CORRIENTE A DISIPAR (PASO 6)"]
[]
[null,null,"Descripción ",null,"Valor / Cantidad","Unidad"]
[null,null,"Duración de la falla, tf",null,null,"seg"]
[null,null,"Número de líneas de Transmisión",null,null,"-"]
[null,null,"Número de neutros de Distribución",null,null,"-"]
[null,null,"Resistencia equivalente cables linea transmision (R)",null,null,"Ω"]
[null,null,"Reactancia equivalente cables linea transmision (X)",null,null,"Ω"]
[]
[]
[null,null,"Factor de División de Corriente, Sf",null,null,"%"]
[]
[]
[]
[]
[]
[]
[]
["Elevación de Potencial a Tierra, GPR "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Em < Et   ¿?  (PASO 9)"]
[]
[]
[]
[]
[]
[]
["Ep < Ep(c)   ¿?  (PASO 10)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Este aplicativo fue realizado con base a los procedimientos de cálculos establecidos en la \nNorma IEEE Std 80 - 2000."]

{"sheet":"Hoja1","index":1,"n_rows":31,"n_cols":26,"rows_kept":31,"cut":false,"hidden":true,"merged":[[26,16,26,17],[27,16,27,17],[21,16,21,17],[22,16,22,17],[23,16,23,17],[24,16,24,17],[25,16,25,17],[16,16,16,17],[17,16,17,17],[18,16,18,17],[19,16,19,17],[20,16,20,17],[11,16,11,17],[12,16,12,17],[13,16,13,17],[14,16,14,17],[15,16,15,17],[6,16,6,17],[7,16,7,17],[8,16,8,17],[9,16,9,17],[10,16,10,17],[1,16,1,20],[2,16,2,17],[3,16,3,17],[4,16,4,17],[5,16,5,17],[1,11,1,13],[3,10,3,12],[4,10,4,12],[20,3,20,4],[2,2,2,4]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50]
[null,null,null,null,null,null,null,null,null,null,null,"Arreglo de varillas",null,null,null,null,"Cálculos"]
[null,null,"malla",null,null,null,null,null,null,null,null,null,null,"AV",null,null,"Descripción",null,"Valor ","Unidad",null,null,null,null,null,1]
["Cuadrada",1,null,2,"Km1",0.15915494309189535,null,null,null,null,"Con = 1, Sin = 0",null,null,1,null,null,"n, numero de conductores ",null,12.148782207071665]
["rectangular",2,null,null,"Km2",133.33333333333334,null,null,null,null,null,null,null,null,null,null,"Ki, Factor de Irregularidad",null,2.4420197666466064]
[null,null,null,null,"km3",52.083333333333336,null,null,null,null,null,null,null,null,null,null,"Kii",null,1]
[null,null,null,null,"km4",8.3333333333333339,null,null,null,null,null,null,null,null,null,null,"Kh",null,1.2247448713915889]
[null,null,null,"para sacar log nat","km5",177.08333333333334,null,null,null,null,null,null,null,null,null,null,"Km",null,0.53622376040424502]
[null,null,null,"sacando el log nat","km6",5.1766204315705169,null,null,null,null,null,null,null,null,null,null,"LM",null,1129.9408249344006]
[null,null,null,null,"km7",0.81649658092772615,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,395.96726260714576]
[null,null,null,null,"km8",-2.2136371676955813,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,222.02839557824569]
[null,null,null,null,"km7 * km8",-1.8074271788379777]
[null,null,null,null,"km6 +  km9",3.369193252732539]
[null,null,null,null,"km1 * km10",0.53622376040424502]
[]
[]
[]
[]
[]
[]
[null,null,null,"Datos del conductor "]
[null,null,null,null,97]
[null,null,null,null,3.81E-3]
[null,null,null,null,242]
[null,null,null,null,1084]
[null,null,null,null,1.78]
[null,null,null,null,3.42]
[]
[]
[null,null,null,null,0.39513286931046004]
[null,null,null,null,139.19368463570143]

{"sheet":"Datos del Conductor","index":2,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":true,"merged":[[1,1,2,7],[18,1,18,7]]}
[]
[null,"PARÁMETROS PARA CONDUCTOR"]
[]
[null,"Descripción ","Conductividad del material (%)","Factor αr a 20 °C (1/°C)","KO a 0 °C (0 °C)","Temperatura de fusión a Tm (°C)","ρr 20 °C (µΩ-cm)","TCAP capacidad térmica [J/(cm3.°C)]"]
[null,"Cobre recocido","100.0","0.00393",234,1083,"1.72","3.42"]
[null,"Cobre  estirado en frío ","97.0","0.00381",242,1084,"1.78","3.42"]
[null,"Acero revestido de cobre","40.0","0.00378",245,1084,"4.40","3.85"]
[null,"Acero revestido de cobre","30.0","0.00378",245,1084,"5.86","3.85"]
[null,"Acero revestido de cobre. b","20.0","0.00378",245,1084,"8.62","3.85"]
[null,"Aluminio, EC","61.0","0.00403",228,657,"2.86","2.56"]
[null,"Aluminio, aleación 5005","53.5","0.00353",263,652,"3.22","2.60"]
[null,"Aluminio aleación 6201","52.5","0.00347",268,654,"3.28","2.60"]
[null,"Acero revestido de aluminio ","20.3","0.00360",258,657,"8.48","3.58"]
[null,"Acero, 1020","10.8","0.00160",605,1510,"15.90","3.28"]
[null,"Acero inoxidable revestido. c","9.8","0.00160",605,1400,"17.50","4.44"]
[null,"Acero galvanizado ","8.6","0.00320",293,419,"20.10","3.93"]
[null,"Acero inoxidable 304","2.4","0.00130",749,1400,"72.00","4.03"]
[]
[null,"Tabla extraida de la norma IEEE Std 80, con datos utilizados para el cálculo del calibre del conductor"]

{"sheet":"Gráficas Sf","index":3,"n_rows":177,"n_cols":14,"rows_kept":177,"cut":false,"hidden":false,"merged":[[2,0,2,15],[0,0,1,22],[11,3,11,6],[10,3,10,6],[13,1,13,2],[14,1,14,2],[4,8,8,15],[4,1,4,4],[5,1,5,4],[113,1,114,9],[145,1,146,9],[176,1,177,9],[17,13,18,21],[49,13,50,21],[81,13,82,21],[113,13,114,21],[145,13,146,21],[176,13,177,21],[17,1,18,9],[49,1,50,9],[81,1,82,9]]}
["FACTOR DE DIVISIÓN DE CORRIENTE"]
[]
["Para Seleccionar el valor de Sf de las siguientes gráficas se debe tener el cuenta, el valor de la Resistencia de la malla, la cantidad de Líneas de Transmisión y Líneas de Distribución"]
[]
[null,"Descripción",null,null,null,"Valor","Unidad",null,"La identificación de la Gráfica a utilizar, se debe hacer a través de la cantidad de Líneas de Transmisión y de Distribución que se enumeran en el Paso 6. Relacionar el Valor de Rg según la Relación de N Líneas de Transmisión / N Líneas de Distribución (A/B) y Según sea el caso de las Respectivas Resistencias de tierra de pie de torre de Alta Tensión y de Baja Tensión; Rtg y Rdg"]
[null,"Resistencia de malla, Rg",null,null,null,2.5114125128753124,"Ω"]
[null,"Número de líneas de Transmisión",null,null,null,14,"-"]
[null,"Número de neutros de Distribución",null,null,null,0,"-"]
[]
[]
[null,null,null,"Descripción",null,null,null,"Valor","Unidad"]
[null,null,null,"Factor de división de Corriente",null,null,null,null,"%"]
[]
[]
[]
[]
[]
[null,"Para Rtg = 15 Ω y Rdg = 25 Ω - Líneas Trasmisión (1 -2) / Líneas de Distribución (2-8)",null,null,null,null,null,null,null,null,null,null,null,"Para Rtg = 100 Ω y Rdg = 200 Ω  - Líneas de Transmisión (1-2) / Líneas de Distribución (2-8)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Para Rtg = 15 Ω y Rdg = 25 Ω - Líneas Trasmisión (4) / Líneas de Distribución (0-10)",null,null,null,null,null,null,null,null,null,null,null,"Para Rtg = 100 Ω y Rdg = 200 Ω  - Líneas de Transmisión (4) / Líneas de Distribución (0-10)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Para Rtg = 15 Ω y Rdg = 25 Ω - Líneas Trasmisión (6) / Líneas de Distribución (0-10)",null,null,null,null,null,null,null,null,null,null,null,"Para Rtg = 100 Ω y Rdg = 200 Ω  - Líneas de Transmisión (6) / Líneas de Distribución (0-10)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Para Rtg = 15 Ω y Rdg = 25 Ω - Líneas Trasmisión (8) / Líneas de Distribución (0-10)",null,null,null,null,null,null,null,null,null,null,null,"Para Rtg = 100 Ω y Rdg = 200 Ω  - Líneas de Transmisión (8) / Líneas de Distribución (0-10)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Para Rtg = 15 Ω  - Líneas Trasmisión (2-16) /  SIN Líneas de Distribución ",null,null,null,null,null,null,null,null,null,null,null,"Para Rtg = 100 Ω y Rdg = 200 Ω  - Líneas de Transmisión (2-16) / SIN Líneas de Distribución"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Para Rtg = 15 Ω  - Líneas Trasmisión (2-16) /  SIN Líneas de Distribución ",null,null,null,null,null,null,null,null,null,null,null,"Para Rtg = 100 Ω y Rdg = 200 Ω  - Líneas de Transmisión (2-16) / SIN Líneas de Distribución"]

{"sheet":"Resultados Estudio Técnico","index":4,"n_rows":152,"n_cols":12,"rows_kept":152,"cut":false,"hidden":false,"merged":[[79,2,87,9],[40,2,40,5],[65,2,65,5],[66,2,66,5],[35,2,35,5],[36,2,36,5],[53,2,53,5],[57,1,57,9],[59,2,59,5],[60,2,60,5],[46,2,46,5],[38,1,38,9],[41,2,41,5],[42,2,42,5],[43,2,43,5],[74,2,74,5],[21,6,22,6],[30,1,30,9],[32,5,32,6],[34,2,34,5],[63,1,63,9],[53,9,54,10],[70,1,70,9],[72,2,72,5],[73,2,73,5],[7,1,7,9],[47,2,47,5],[50,1,50,9],[52,2,52,5],[9,2,9,5],[10,2,10,5],[11,2,11,5],[14,1,14,9],[21,4,22,4],[44,2,44,5],[45,2,45,5],[21,5,22,5],[17,3,18,5],[16,3,16,5],[19,3,19,5],[17,2,19,2],[0,0,0,8],[1,0,1,4],[12,4,12,5],[5,0,5,9]]}
["Aplicativo para el Estudio Técnico y Económico para un Sistema de Puesta a Tierra\nBasado en la norma IEEE Std 80 - 2000 \"Guide for Safety in AC Substation Grounding\""]
["Realizado por: Ing Sonni Troncoso Mendoza",null,null,null,null,null,null,null,2014]
[]
[]
[]
["RESULTADOS DE ESTUDIO TÉCNICO",null,null,null,null,null,null,null,null,null,null," "]
[]
[null,"PASO 1, CÁLCULO DEL ÁREA Y LA RESISTIVIDAD"]
[]
[null,null,"Descripción",null,null,null,"Valor / Cantidad","Unidad"]
[null,null,"Área disponible para la malla",null,null,null,null,"m²"]
[null,null,"Resistividad aparente",null,null,null,null,"Ω.m"]
[null,null,null,null,"Profundidad de la primera capa, h",null,null,"m"]
[]
[null,"PASO 2, CÁLCULO DEL CALIBRE DEL CONDUCTOR"]
[]
[null,null,"CONDUCTOR","Descripción ",null,null,"Valor / Cantidad","Unidad"]
[null,null,"Cobre  estirado en frío ","Calibre del conductor a utilizar",null,null,null,"mm²"]
[null,null,null,null,null,null,null,"AWG"]
[null,null,null,"Diamentro del conductor, dc",null,null,null,"m"]
[]
[null,null,null,null,"Calibre del cable, AWG","Sección nomimal, mm2","Diametro, m"]
[]
[null,null,null,null,"2/0",67.42,9.2999999999999992E-3]
[null,null,null,null,"3/0",85.03,1.04E-2]
[null,null,null,null,"4/0",107.2,1.17E-2]
[null,null,null,null,"250 kcmil",126.65,1.2699999999999999E-2]
[null,null,null,null,"350kcmil",177.36,1.4999999999999999E-2]
[null,null,null,null,"500 kcmil",253.4,1.7999999999999999E-2]
[]
[null,"PASO 3, CRITERIO DE TENSIÓN DE PASO Y CONTACTO"]
[]
[null,null,null,null,"Criterio utilizado"]
[]
[null,null,"Descripción ",null,null,null,"Valor / Cantidad","Unidad"]
[null,null,"Criterio de Tensión de paso, Es",null,null,null,null,"V"]
[null,null,"Criterio de Tensión de toque, Et",null,null,null,null,"V"]
[]
[null,"PASO 4, DISEÑO PRELIMINAR"]
[]
[null,null,"Descripción ",null,null,null,"Valor / Cantidad","Unidad"]
[null,null,"Distancia entre conductores en paralelo",null,null,null,null,"m"]
[null,null,"Número de Conductores paralelos al Eje X, N",null,null,null,null,"-"]
[null,null,"Número de Conductores paralelos al Eje Y, M",null,null,null,null,"-"]
[null,null,"Longitud total del conductor de la red, Lc",null,null,null,null,"m"]
[null,null,"Longitud total de conductor en la periféria, Lp",null,null,null,null,"m"]
[null,null,"Longitud total de varillas a tierra, LR",null,null,null,null,"m"]
[null,null,"Longitud total de conductores enterrados, LT",null,null,null,null,"m"]
[]
[]
[null,"PASO 5, CÁLCULO DE RESISTENCIA DE LA MALLA, Rg"]
[]
[null,null,"Descripción ",null,null,null,"Valor / Cantidad","Unidad"]
[null,null,"Resistencia de la malla, Rg",null,null,null,null,"Ω"]
[]
[]
[]
[null,"PASO 6, CÁLCULO DE CORRIENTE MÁXIMA A DISIPAR POR LA MALLA, IG"]
[]
[null,null,"Descripción ",null,null,null,"Valor / Cantidad","Unidad"]
[null,null,"Máxima Corriente a Disipar, IG",null,null,null,null,"A"]
[]
[]
[null,"PASO 7, CÁLCULO DE GPR Y COMPARACIÓN CON VALOR DE TENSIÓN DE CONTACTO"]
[]
[null,null,"Descripción ",null,null,null,"Valor / Cantidad","Unidad"]
[null,null,"Elevación de Potencial a Tierra, GPR",null,null,null,null,"V"]
[]
[]
[]
[null,"PASO 8, CÁLCULO DE LA TENSIÓN DE MALLA Y TENSIÓN REAL DE PASO"]
[]
[null,null,"Descripción ",null,null,null,"Valor / Cantidad","Unidad"]
[null,null,"Tensión máxima de la malla, Em",null,null,null,null,"V"]
[null,null,"Tensión real de paso, Ep",null,null,null,null,"V"]
[]
[]
[]
[]
[null,null,"Este aplicativo fue realizado con base a los procedimientos de cálculos establecidos en la \nNorma IEEE Std 80 - 2000."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,2.5]

{"sheet":"Datos Estudio Económico","index":5,"n_rows":32,"n_cols":17,"rows_kept":32,"cut":false,"hidden":false,"merged":[[1,0,1,4],[2,0,2,8],[31,6,32,7],[31,8,32,8],[7,8,8,8],[9,1,10,1],[9,2,10,2],[9,3,10,3],[7,3,8,3],[7,4,8,4],[7,1,8,2],[5,1,6,16],[7,10,8,10],[7,11,8,11],[7,12,8,12],[7,13,8,13],[24,10,24,12],[28,1,28,3],[7,14,8,14],[7,15,8,15],[19,5,19,6],[23,10,23,12],[9,4,10,16],[23,1,23,3],[7,16,8,16],[7,5,8,5],[7,6,8,6],[7,7,8,7],[17,3,17,4],[19,3,19,4],[21,8,22,8],[7,9,8,9],[21,10,22,16],[0,0,0,8],[26,10,26,12],[35,1,35,3],[30,1,30,3],[31,1,31,3],[32,1,32,3],[33,1,33,3],[34,1,34,3],[29,1,29,3],[21,1,22,5],[21,6,22,7],[26,1,26,3],[27,1,27,3],[24,1,24,3],[25,1,25,3],[42,1,42,3],[43,1,43,3],[44,1,44,3],[36,1,36,3],[37,1,37,3],[38,1,38,3],[39,1,39,3],[40,1,40,3],[25,10,25,12],[27,10,27,12],[28,10,28,12],[29,10,29,12],[41,1,41,3],[31,9,32,9]]}
["Aplicativo para el Estudio Técnico y Económico para un Sistema de Puesta a Tierra\nBasado en la norma IEEE Std 80 - 2000 \"Guide for Safety in AC Substation Grounding\""]
["Realizado por: Ing Sonni Troncoso Mendoza",null,null,null,null,null,null,null,2014]
["ESTUDIO ECONÓMICO"]
[]
[]
[null,"VALOR POR METRO"]
[]
[null,"X",null,"DESCRIPCIÓN","Cobre recocido","Cobre  estirado en frío ","Acero revestido de cobre","Acero revestido de cobre","Acero revestido de cobre. b","Aluminio, EC","Aluminio, aleación 5005","Aluminio aleación 6201","Acero revestido de aluminio ","Acero, 1020","Acero inoxidable revestido. c","Acero galvanizado ","Acero inoxidable 304"]
[]
[null,"Calibre del cable, AWG","Sección nomimal, mm2","Diametro, m","X"]
[]
[null,"2/0",67.42,9.2999999999999992E-3]
[null,"3/0",85.03,1.04E-2]
[null,"4/0",107.2,1.17E-2]
[null,"250 kcmil",126.65,1.2699999999999999E-2]
[null,"350kcmil",177.36,1.4999999999999999E-2]
[null,"500 kcmil",253.4,1.7999999999999999E-2]
[]
[]
[null,null,null,"CONDUCTOR A UTILIZAR",null,"Cobre  estirado en frío ",null,"177,36 mm²"]
[]
[null,"PRECIOS",null,null,null,null,"ELEMENTOS CALCULADOS EN EL ESTUDIO TÉCNICO",null,"COSTO TOTAL",null,"HERRAMIENTAS Y EQUIPOS "]
[]
[null,"DESCRIPCIÓN",null,null,"VALOR ","UNIDAD","CANTIDAD","UNIDAD","$",null,"DESCRIPCIÓN",null,null,"COSTO / DÍA","UNIDAD","DÍAS","$"]
[null,"Varilla de Cobre",null,null,80000,"m",25,"m",2000000,null,"Herramienta menor",null,null,40000,"Caja",1,40000]
[null,"Conductor a utilizar",null,null,2000,"m",1115,"m",2230000,null,"Cuadrilla linieros (OFICIAL+AYUDANTE)",null,null,800000,"Und",2,1600000]
[null,"Soldadura Tipo Cadwell",null,null,3000,"-",null,"-",0,null,"Telurómetro",null,null,1500000,"Und",1,1500000]
[]
[]
[]
[]
[null,null,null,null,null,null,"COSTO TOTAL",null,7370000,"$"]

{"sheet":"Impresión","index":6,"n_rows":46,"n_cols":6,"rows_kept":46,"cut":false,"hidden":true,"merged":[[45,1,46,5],[43,1,43,2],[38,1,38,2],[39,1,39,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[36,1,36,2],[41,1,41,2],[42,1,42,2],[32,1,32,2],[33,1,33,2],[34,1,34,2],[35,1,35,2],[40,1,40,2],[37,1,37,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[17,1,17,2],[15,1,15,2],[22,1,22,2],[16,1,16,2],[24,1,24,5],[29,1,31,2],[29,3,31,3],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[0,0,0,6],[11,1,11,2],[11,3,11,5],[2,1,2,5],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[10,3,10,5],[3,1,3,2]]}
["ESTUDIO TÉCNICO"]
[]
[null,"PARÁMETROS DE ENTRADA"]
[null,"DESCRIPCIÓN",null,"SIMBOLO ","VALOR","UNIDAD"]
[null,"Lado mayor de la malla, Lx",null,"Lx",50,"m"]
[null,"Lado menor de la malla, Ly",null,"Ly",40,"m"]
[null,"Corriente de falla, Lado AT",null,"-",55000,"A"]
[null,"Corriente de falla, Lado BT",null,"-",800,"A"]
[null,"Duración de la falla, choque",null,"ts, tf, tc",0.5,"seg"]
[null,"Temperatura ambiente",null,"ta",40,"°C"]
[null,"Conductor a utilizar",null,"Cobre  estirado en frío "]
[null,"Criterio Tensiones Paso y toque",null," Peso Corporal 50 Kg"]
[null,"Profundidad de Capa superficial",null,"hs",0,"m"]
[null,"Resistividad de Capa Superficial",null,"ρs",100,"Ω.m"]
[null,"Distancia entre conductores",null,"D",5,"m"]
[null,"Profundidad de enterramiento de malla",null,"h",0.5,"m"]
[null,"Cantidad de varillas enterradas",null,"nr",80,"-"]
[null,"Longitud de la varilla a tierra",null,"Lr",2.4,"m"]
[null,"Número de líneas de Transmisión",null,"A",14,"-"]
[null,"Número de neutros de Distribución",null,"B",0,"-"]
[null,"Resistencia eq. Cables de transmisión (R)",null,"R",0.9,"Ω"]
[null,"Reactancia eq. Cables de transmisión (X)",null,"X",0.89,"Ω"]
[null,"Factor de División de Corriente",null,"Sf",15,"%"]
[]
[null,"PARÁMETROS CALCULADOS"]
[null,"DESCRIPCIÓN",null,"SIMBOLO ","VALOR","UNIDAD"]
[null,"Área ",null,"A",2000,"m²"]
[null,"Resistividad ",null,"ρ",100,"Ω.m"]
[null,"Profundidad de la primera capa",null,"h1",0.83333333333333337,"m"]
[null,"Diámetro del conductor",null,"dc",177.36,"mm²"]
[null,null,null,null,"350kcmil","AWG"]
[null,null,null,null,1.4999999999999999E-2,"m"]
[null,"Tensión de paso (según criterio)",null,"Es",262.47803717644643,"V"]
[null,"Tensión de contacto (Según criterio)",null,"Et",188.65608922057089,"V"]
[null,"No. De Conductores paralelos a Eje X",null,"N",9,"-"]
[null,"No. De Conductores paralelos al Eje Y",null,"M",11,"-"]
[null,"Longitud total de Conductor de la red",null,"Lc",890,"m"]
[null,"Longitud total de varillas",null,"LR",192,"m"]
[null,"Longitud total de conductor enterrado",null,"LT",1082,"m"]
[null,"Resistencia de malla",null,"Rg",1.0686119179649678,"Ω"]
[null,"Máxima corriente a disipar",null,"IG",8271.612342601813,"A"]
[null,"Elevación de potencial a tierra",null,"GPR",8839.1435300904232,"V"]
[null,"Tensión máxima de la malla ",null,"Em",912.60541641406519,"V"]
[null,"Tensión real de paso ",null,"Ep",924.49253296704183,"V"]
[]
[null,"El Diseño del presente estudio no es el adecuado"]

{"sheet":"Estudio Económico","index":7,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":true,"merged":[[0,0,0,8],[1,0,1,4],[2,0,2,8]]}
["Aplicativo para el Estudio Técnico y Económico para un Sistema de Puesta a Tierra\nBasado en la norma IEEE Std 80 - 2000 \"Guide for Safety in AC Substation Grounding\""]
["Realizado por: Ing Sonni Troncoso Mendoza",null,null,null,null,null,null,null,2014]
["ESTUDIO ECONÓMICO"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"DESCRIPCIÓN","TIPO"]
[null,null,"Conductor"]