{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["SUBESTACION","TAB CORROSION","TAB METALOGRAFÍA","TAB MODELOS","UTILI DUCTOS","CONSTANTES K"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"SUBESTACION","index":0,"n_rows":15,"n_cols":12,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3],[0,1,0,3]]}
["SUBESTACION","LABORATORIOS MECÁNICA"]
["CONTIENE","MEMORIAS DE CALCULO"]
["TABLERO T GEN (TABLERO GENERAL)","DENOMINACION","CARGA TOTAL","DEMANDA ","F.P","I (A)","PROTECCION","ALIMENTADOR","LONGITUD","R","Reg ","PERDIDAS"]
["UBICACIÓN",null,"VA","VA",null,null,"TRIPOLAR (A)","CONDUCTORES DE COBRE","(M)","Ω/KM","%","VATIOS"]
["TABLERO GENERAL"]
[{"$f":"'TAB CORROSION'!V36","v":"LABORATORIO DE CORROSIÓN"},{"$f":"'TAB CORROSION'!W36","v":"T. CORR"},{"$f":"'TAB CORROSION'!X36","v":9918},{"$f":"'TAB CORROSION'!Y36","v":5347},{"$f":"'TAB CORROSION'!Z36","v":0.95},{"$f":"'TAB CORROSION'!AA36","v":15.623392955652591},{"$f":"'TAB CORROSION'!AB36","v":20},{"$f":"'TAB CORROSION'!AC36","v":"5H CABLE CU No 10 THHN"},{"$f":"'TAB CORROSION'!AD36","v":20},{"$f":"'TAB CORROSION'!AE36","v":3.61},{"$f":"'TAB CORROSION'!AF36","v":0.88805069930069924},{"$f":"'TAB CORROSION'!AG36","v":52.869982252962792}]
[{"$f":"'TAB METALOGRAFÍA'!V58","v":"LABORATORIO DE METALOGRAFÍA"},{"$f":"'TAB METALOGRAFÍA'!W58","v":"T. MET"},{"$f":"'TAB METALOGRAFÍA'!X58","v":52358},{"$f":"'TAB METALOGRAFÍA'!Y58","v":26707},{"$f":"'TAB METALOGRAFÍA'!Z58","v":0.95},{"$f":"'TAB METALOGRAFÍA'!AA58","v":78.035151611485645},{"$f":"'TAB METALOGRAFÍA'!AB58","v":90},{"$f":"'TAB METALOGRAFÍA'!AC58","v":"5H CABLE CU No 2 THHN"},{"$f":"'TAB METALOGRAFÍA'!AD58","v":25},{"$f":"'TAB METALOGRAFÍA'!AE58","v":0.623},{"$f":"'TAB METALOGRAFÍA'!AF58","v":0.95684929379830697},{"$f":"'TAB METALOGRAFÍA'!AG58","v":284.53118134636236}]
[{"$f":"'TAB MODELOS'!V37","v":"LABORATORIO DE MODELOS"},{"$f":"'TAB MODELOS'!W37","v":"T. MOD"},{"$f":"'TAB MODELOS'!X37","v":10484},{"$f":"'TAB MODELOS'!Y37","v":5682},{"$f":"'TAB MODELOS'!Z37","v":0.95},{"$f":"'TAB MODELOS'!AA37","v":16.602229058166827},{"$f":"'TAB MODELOS'!AB37","v":30},{"$f":"'TAB MODELOS'!AC37","v":"5H CABLE CU No 8 THHN"},{"$f":"'TAB MODELOS'!AD37","v":30},{"$f":"'TAB MODELOS'!AE37","v":2.2599999999999998},{"$f":"'TAB MODELOS'!AF37","v":0.8861786897313213},{"$f":"'TAB MODELOS'!AG37","v":56.063957572947238}]
["TOTAL",null,{"$f":"SUM(C6:C8)","v":72760},{"$f":"SUM(D6:D8)","v":37736},0.95,{"$f":"+D9/(208*1.732*E9)/2","v":55.130386812652532},70,"5H CABLE CU No 6 THHN",30,1.44,{"$f":"+(F9*I9*J9*1.732*100)/(1000*220)","v":1.8749944792050055},{"$f":"3*J9*I9*F9*F9/1000","v":393.900997694605}]
[]
[]
["SE REQUIERE TRANSFORMADOR DE 150 KVA 220V/208V  TRIFÁSICO CONVENCIONAL EN ACEITE"]
[]
[]
["SE REQUIERE PLANTA DE EMERGENCIA DE 150 KVA 220V TRIFASICA"]

{"sheet":"TAB CORROSION","index":1,"n_rows":36,"n_cols":33,"rows_kept":36,"cut":false,"hidden":false,"merged":[[30,22,30,32],[29,22,29,32],[3,16,3,18],[22,6,22,13],[23,7,23,8],[24,7,24,8],[3,13,3,15],[0,0,0,19],[25,2,25,5],[25,7,25,8],[1,0,1,12],[2,0,2,8],[3,2,3,5],[3,6,3,8],[3,9,3,10]]}
["TABLERO COMPRESORES CORROSIÓN"]
[]
["TABLERO: COMPRESORES"]
["CTO",null,null,null,null,null,"TOMAS",null,null,"TRIFASICO",null,"POTENCIA","CALIBRE","PROTECC.(AMPS.)",null,null,"   FASES",null,null,"DESCRIPCIÓN"]
[null,"18w","2X22w","40w","50w","63w","110V","220V","OTRO","220V","440V","VA","AWG","1X","2X","3X","F1","F2","F3"]
["1'-3'",null,null,null,null,null,null,null,null,null,null,3000,12,null,20,null,{"$f":"+L6/220","v":13.636363636363637},null,{"$f":"Q6","v":13.636363636363637},"COMPRESOR BIFÁSICO"]
["2'-4'-6'",null,null,null,null,null,6,null,null,null,null,3000,12,null,null,20,{"$f":"R7","v":13.636363636363637},{"$f":"+L7/220","v":13.636363636363637},{"$f":"R7","v":13.636363636363637},"COMPRESOR TRIFÁSICO"]
["5'",null,null,null,null,null,null,null,null,null,null,{"$f":"+B8*18+C8*2*22+D8*45+E8*63+F8*100+G8*180+H8*1*746+I8+J8*2*746+K8","v":0},12,20,null,null,null,{"$f":"+L8/120","v":0},null,"Reserva"]
["7'",2,8,null,null,null,null,null,null,null,null,{"$f":"+B9*18+C9*2*22+D9*45+E9*63+F9*100+G9*180+H9*1*746+I9+J9*2*746+K9","v":388},14,20,null,null,{"$f":"+L9/120","v":3.2333333333333334},null,null,"Iluminación Corrosión"]
["8'",null,null,null,null,null,6,null,null,null,null,{"$f":"+B10*18+C10*2*22+D10*45+E10*63+F10*100+G10*180+H10*1*746+I10+J10*2*746+K10","v":1080},12,20,null,null,null,{"$f":"+L10/120","v":9},null,"Tomacorrientes área cámara salina"]
["9'",null,null,null,null,null,null,null,null,null,null,{"$f":"+B11*18+C11*2*22+D11*45+E11*63+F11*100+G11*180+H11*1*746+I11+J11*2*746+K11","v":0},12,20,null,null,null,null,{"$f":"+L11/120","v":0},"Reserva"]
["10'",null,null,null,null,null,5,null,null,null,null,{"$f":"+B12*18+C12*2*22+D12*45+E12*63+F12*100+G12*180+H12*1*746+I12+J12*2*746+K12","v":900},12,20,null,null,{"$f":"+L12/120","v":7.5},null,null,"Tomacorrientes área general"]
["11'",null,null,null,null,null,null,null,null,null,null,50,12,20,null,null,null,{"$f":"+L13/120","v":0.41666666666666669},null,"Extractor"]
["12'-14'",null,null,null,null,null,null,null,null,null,null,1500,10,null,20,null,null,{"$f":"S14","v":6.8181818181818183},{"$f":"+L14/220","v":6.8181818181818183},"Mini Split"]
["13'",null,null,null,null,null,null,null,null,null,null,{"$f":"+B15*18+C15*2*22+D15*45+E15*63+F15*100+G15*180+H15*1*746+I15+J15*2*746+K15","v":0},12,20,null,null,{"$f":"+L15/120","v":0},null,null,"Reserva"]
["15'",null,null,null,null,null,null,null,null,null,null,0,12,20,null,null,null,null,{"$f":"+L16/120","v":0},"Reserva"]
["16'",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+L17/120","v":0},null,null,"Reserva"]
["17'",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+L18/120","v":0},null,"Reserva"]
["18'",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+L19/120","v":0},"Reserva"]
[]
["SUBTOTAL ",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L6:L20)","v":9918},null,null,null,null,{"$f":"SUM(Q6:Q20)","v":38.006060606060608},{"$f":"SUM(R6:R20)","v":29.871212121212125},{"$f":"SUM(S6:S20)","v":34.090909090909093}]
[]
[null,null,null,null,null,null,"CALCULO DE LA DEMANDA PARCIAL"]
[null,null,"SUBTOTAL ILUMINACION",null,null,null,null,{"$f":"L9","v":388},null,null,null,"AL",1,{"$f":"+H24*M24","v":388}]
[null,null,"SUBTOTAL TOMACORRIENTES",null,null,null,null,{"$f":"L21","v":9918},null,null,null,"AL",0.5,{"$f":"+H25*M25","v":4959}]
[null,null,"SUBTOTAL TOMACORRIENTES ESPECIALES",null,null,null,null,0,null,null,null,"AL",0,{"$f":"+H26*M26","v":0}]
[null,null,"TOTAL DEMANDA",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N24:N26)","v":5347}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PROYECTO",{"$f":"A1","v":"TABLERO COMPRESORES CORROSIÓN"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CONTIENE","TAB CORR"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TABLERO ","DENOMINACION","CARGA TOTAL","DEMANDA ","F.P","I (A)","PROTECCION","ALIMENTADOR","LONGITUD","RESISTENCIA","REGULACION ","PERDIDAS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UBICACIÓN",null,"VA","VA",null,null,"TRIPOLAR (A)","CONDUCTORES DE COBRE","(M)","OHMIOS /KM","PORCENTAJE","VATIOS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LABORATORIO DE CORROSIÓN","T. CORR",{"$f":"L21","v":9918},{"$f":"N27","v":5347},0.95,{"$f":"+Y35/(208*1.732*Z35)","v":15.623392955652591},20,{"$f":"\"5H CABLE CU No \"&VLOOKUP(AE35,'CONSTANTES K'!$I$6:$J$16,2,FALSE)&\" THHN\"","v":"5H CABLE CU No 10 THHN"},20,3.61,{"$f":"+(AA35*AD35*AE35*1.732*100)/(1000*220)","v":0.88805069930069924},{"$f":"3*AE35*AD35*AA35*AA35/1000","v":52.869982252962792}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V35","v":"LABORATORIO DE CORROSIÓN"},{"$f":"W35","v":"T. CORR"},{"$f":"SUM(X35:X35)","v":9918},{"$f":"SUM(Y35:Y35)","v":5347},0.95,{"$f":"+Y36/(208*1.732*Z36)","v":15.623392955652591},20,{"$f":"\"5H CABLE CU No \"&VLOOKUP(AE36,'CONSTANTES K'!$I$6:$J$16,2,FALSE)&\" THHN\"","v":"5H CABLE CU No 10 THHN"},{"$f":"AD35","v":20},3.61,{"$f":"+(AA36*AD36*AE36*1.732*100)/(1000*220)","v":0.88805069930069924},{"$f":"3*AE36*AD36*AA36*AA36/1000","v":52.869982252962792}]

{"sheet":"TAB METALOGRAFÍA","index":2,"n_rows":58,"n_cols":33,"rows_kept":58,"cut":false,"hidden":false,"merged":[[52,22,52,32],[22,0,22,19],[23,0,23,12],[24,0,24,8],[25,2,25,5],[25,6,25,8],[25,9,25,10],[25,13,25,15],[25,16,25,18],[44,6,44,13],[51,22,51,32],[45,7,45,8],[46,7,46,8],[47,2,47,5],[47,7,47,8],[15,6,15,13],[16,7,16,8],[17,7,17,8],[18,2,18,5],[18,7,18,8],[0,0,0,19],[1,0,1,12],[2,0,2,8],[3,2,3,5],[3,6,3,8],[3,9,3,10],[3,13,3,15],[3,16,3,18]]}
["TABLERO HORNOS"]
[]
["TABLERO: METALOGRAFÍA"]
["CTO",null,null,null,null,null,"TOMAS",null,null,"TRIFASICO",null,"POTENCIA","CALIBRE","PROTECC.(AMPS.)",null,null,"   FASES",null,null,"DESCRIPCIÓN"]
[null,"18w","2X22w","40w","50w","63w","110V","220V","OTRO","220V","440V","VA","AWG","1X","2X","3X","F1","F2","F3"]
["1'-3'",null,null,null,null,null,null,null,null,null,null,2800,8,null,20,null,{"$f":"+L6/220","v":12.727272727272727},null,{"$f":"Q6","v":12.727272727272727},"HORNO 1"]
["2'-4",null,null,null,null,null,null,null,null,null,null,4400,8,null,30,null,{"$f":"R7","v":20},{"$f":"+L7/220","v":20},{"$f":"R7","v":20},"HORNO 2"]
["5'-7'",null,null,null,null,null,null,null,null,null,null,7000,8,null,40,null,{"$f":"R8","v":31.818181818181817},{"$f":"+L8/220","v":31.818181818181817},null,"HORNO 3"]
["6'-8'",null,null,null,null,null,null,null,null,null,null,7000,8,null,40,null,null,{"$f":"S9","v":31.818181818181817},{"$f":"+L9/220","v":31.818181818181817},"HORNO 4"]
["9'-11'",null,null,null,null,null,null,null,null,null,null,7000,8,null,40,null,null,{"$f":"S10","v":31.818181818181817},{"$f":"+L10/220","v":31.818181818181817},"HORNO 5"]
["10'",null,null,null,null,null,null,null,null,null,null,{"$f":"+B11*18+C11*2*22+D11*45+E11*63+F11*100+G11*180+H11*1*746+I11+J11*2*746+K11","v":0},12,null,null,null,{"$f":"+L11/120","v":0},null,null,"Reserva"]
["12'",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+L12/120","v":0},null,null,"Reserva"]
[]
["SUBTOTAL ",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L6:L13)","v":28200},null,null,null,null,{"$f":"SUM(Q6:Q13)","v":64.545454545454547},{"$f":"SUM(R6:R13)","v":115.45454545454544},{"$f":"SUM(S6:S13)","v":96.36363636363636}]
[]
[null,null,null,null,null,null,"CALCULO DE LA DEMANDA PARCIAL"]
[null,null,"SUBTOTAL ILUMINACION",null,null,null,null,null,null,null,null,"AL",1,{"$f":"+H17*M17","v":0}]
[null,null,"SUBTOTAL TOMACORRIENTES",null,null,null,null,{"$f":"L14","v":28200},null,null,null,"AL",0.5,{"$f":"+H18*M18","v":14100}]
[null,null,"SUBTOTAL TOMACORRIENTES ESPECIALES",null,null,null,null,0,null,null,null,"AL",0,{"$f":"+H19*M19","v":0}]
[null,null,"TOTAL DEMANDA",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N17:N19)","v":14100}]
[]
[]
["TABLERO METALOGRAFÍA"]
[]
["TABLERO: METALOGRAFÍA"]
["CTO",null,null,null,null,null,"TOMAS",null,null,"TRIFASICO",null,"POTENCIA","CALIBRE","PROTECC.(AMPS.)",null,null,"   FASES",null,null,"DESCRIPCIÓN"]
[null,"18w","2X22w","40w","50w","63w","110V","220V","OTRO","220V","440V","VA","AWG","1X","2X","3X","F1","F2","F3"]
["1'",null,12,null,null,null,null,null,null,null,null,{"$f":"+B28*18+C28*2*22+D28*45+E28*63+F28*100+G28*180+H28*1*746+I28+J28*2*746+K28","v":528},14,20,null,null,{"$f":"+L28/120","v":4.4000000000000004},null,null,"Iluminación Metalografía"]
["2'",null,null,null,null,null,6,null,null,null,null,1080,12,20,null,null,null,{"$f":"+L29/120","v":9},null,"Tomacorrientes Área cortadora"]
["3'",null,null,null,null,null,null,null,null,null,null,0,12,20,null,null,null,null,{"$f":"+L30/120","v":0},"Reserva"]
["4'",null,null,null,null,null,10,null,null,null,null,1800,12,20,null,null,{"$f":"+L31/120","v":15},null,null,"Tomacorrientes área anexa"]
["5'-7'",null,null,null,null,null,null,null,null,null,null,2500,12,null,20,null,null,{"$f":"+L32/220","v":11.363636363636363},null,"Pulidora metalográfica"]
["6'",null,null,null,null,null,null,null,null,null,null,0,12,20,null,null,null,null,{"$f":"+L33/120","v":0},"Reserva"]
["8'-10'",null,null,null,null,null,null,null,null,null,null,250,12,null,20,null,{"$f":"R34","v":1.1363636363636365},{"$f":"+L34/220","v":1.1363636363636365},null,"Extractor"]
["9'-11'",null,null,null,null,null,null,null,null,null,null,1500,12,null,20,null,null,{"$f":"S35","v":12.5},{"$f":"+L35/120","v":12.5},"Mini Split"]
["12'-14'-16'",null,null,null,null,null,null,null,null,null,null,{"$f":"L14","v":28200},12,null,null,150,{"$f":"+L36/220","v":128.18181818181819},{"$f":"Q36","v":128.18181818181819},{"$f":"Q36","v":128.18181818181819},"Tablero Hornos"]
["13'-15'",null,null,null,null,null,null,null,null,null,null,3000,12,null,20,null,{"$f":"L37/220","v":13.636363636363637},null,{"$f":"Q37","v":13.636363636363637},"Pulidora fina"]
["17'-19'",null,null,null,null,null,null,null,null,null,null,3000,12,null,20,null,{"$f":"R38","v":13.636363636363637},{"$f":"+L38/220","v":13.636363636363637},null,"Reserva"]
["18'-20'",null,null,null,null,null,null,null,null,null,null,3000,12,null,20,null,null,{"$f":"S39","v":13.636363636363637},{"$f":"L39/220","v":13.636363636363637},"Reserva"]
["21'-23'",null,null,null,null,null,null,null,null,null,null,3000,12,null,20,null,null,null,{"$f":"L40/220","v":13.636363636363637},"Reserva"]
["22'-24'",null,null,null,null,null,null,null,null,null,null,4500,12,null,20,null,{"$f":"L41/220","v":20.454545454545453},null,null,"Cortadora metalográfica"]
[]
["SUBTOTAL ",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L28:L42)","v":52358},null,null,null,null,{"$f":"SUM(Q28:Q42)","v":196.44545454545454},{"$f":"SUM(R28:R42)","v":189.45454545454544},{"$f":"SUM(S28:S42)","v":181.59090909090907}]
[]
[null,null,null,null,null,null,"CALCULO DE LA DEMANDA PARCIAL"]
[null,null,"SUBTOTAL ILUMINACION",null,null,null,null,{"$f":"L28","v":528},null,null,null,"AL",1,{"$f":"+H46*M46","v":528}]
[null,null,"SUBTOTAL TOMACORRIENTES",null,null,null,null,{"$f":"L43","v":52358},null,null,null,"AL",0.5,{"$f":"+H47*M47","v":26179}]
[null,null,"SUBTOTAL TOMACORRIENTES ESPECIALES",null,null,null,null,0,null,null,null,"AL",0,{"$f":"+H48*M48","v":0}]
[null,null,"TOTAL DEMANDA",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N46:N48)","v":26707}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PROYECTO","METALOGRAFÍA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CONTIENE","TAB MET"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TABLERO ","DENOMINACION","CARGA TOTAL","DEMANDA ","F.P","I (A)","PROTECCION","ALIMENTADOR","LONGITUD","RESISTENCIA","REGULACION ","PERDIDAS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UBICACIÓN",null,"VA","VA",null,null,"TRIPOLAR (A)","CONDUCTORES DE COBRE","(M)","OHMIOS /KM","PORCENTAJE","VATIOS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LABORATORIO DE METALOGRAFÍA","T. MET",{"$f":"L43","v":52358},{"$f":"N49","v":26707},0.95,{"$f":"+Y57/(208*1.732*Z57)","v":78.035151611485645},90,{"$f":"\"5H CABLE CU No \"&VLOOKUP(AE57,'CONSTANTES K'!$I$6:$J$16,2,FALSE)&\" THHN\"","v":"5H CABLE CU No 2 THHN"},25,0.623,{"$f":"+(AA57*AD57*AE57*1.732*100)/(1000*220)","v":0.95684929379830697},{"$f":"3*AE57*AD57*AA57*AA57/1000","v":284.53118134636236}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V57","v":"LABORATORIO DE METALOGRAFÍA"},{"$f":"W57","v":"T. MET"},{"$f":"SUM(X57:X57)","v":52358},{"$f":"SUM(Y57:Y57)","v":26707},0.95,{"$f":"+Y58/(208*1.732*Z58)","v":78.035151611485645},90,{"$f":"\"5H CABLE CU No \"&VLOOKUP(AE58,'CONSTANTES K'!$I$6:$J$16,2,FALSE)&\" THHN\"","v":"5H CABLE CU No 2 THHN"},25,0.623,{"$f":"+(AA58*AD58*AE58*1.732*100)/(1000*220)","v":0.95684929379830697},{"$f":"3*AE58*AD58*AA58*AA58/1000","v":284.53118134636236}]

{"sheet":"TAB MODELOS","index":3,"n_rows":37,"n_cols":33,"rows_kept":37,"cut":false,"hidden":false,"merged":[[31,22,31,32],[23,6,23,13],[24,7,24,8],[25,7,25,8],[26,2,26,5],[26,7,26,8],[30,22,30,32],[0,0,0,19],[1,0,1,12],[2,0,2,8],[3,2,3,5],[3,6,3,8],[3,9,3,10],[3,13,3,15],[3,16,3,18]]}
["TABLERO MODELOS"]
[]
["TABLERO: COMPRESORES"]
["CTO",null,null,null,null,null,"TOMAS",null,null,"TRIFASICO",null,"POTENCIA","CALIBRE","PROTECC.(AMPS.)",null,null,"   FASES",null,null,"DESCRIPCIÓN"]
[null,"18w","2X22w","40w","50w","63w","110V","220V","OTRO","220V","440V","VA","AWG","1X","2X","3X","F1","F2","F3"]
["1'",null,null,null,null,null,null,null,null,null,null,{"$f":"+B6*18+C6*2*22+D6*45+E6*63+F6*100+G6*180+H6*1*746+I6+J6*2*746+K6","v":0},14,20,null,null,{"$f":"+L6/120","v":0},null,null,"Reserva"]
["2'",null,null,null,null,null,7,null,null,null,null,1260,12,20,null,null,null,{"$f":"+L7/120","v":10.5},null,"Tomacorrientes equipos pc"]
["3'",null,10,null,null,null,null,null,null,null,null,440,12,20,null,null,null,null,{"$f":"+L8/120","v":3.6666666666666665},"Iluminación Modelos"]
["4'",null,null,null,null,null,4,null,null,null,null,720,12,20,null,null,{"$f":"+L9/120","v":6},null,null,"Tomacorrientes impresoras 3D"]
["5'",null,null,null,null,null,null,null,null,null,null,{"$f":"+B10*18+C10*2*22+D10*45+E10*63+F10*100+G10*180+H10*1*746+I10+J10*2*746+K10","v":0},12,20,null,null,null,{"$f":"+L10/120","v":0},null,"Reserva"]
["6'",null,null,null,null,null,5,null,null,null,null,{"$f":"+B11*18+C11*2*22+D11*45+E11*63+F11*100+G11*180+H11*1*746+I11+J11*2*746+K11","v":900},12,20,null,null,null,null,{"$f":"+L11/120","v":7.5},"Tomacorrientes Bodega"]
["7'-9'",null,null,null,null,null,null,1,null,null,null,500,14,null,20,null,{"$f":"+L12/220","v":2.2727272727272729},null,{"$f":"Q12","v":2.2727272727272729},"Cortadora Láser"]
["8'",null,null,null,null,null,6,null,null,null,null,{"$f":"+B13*18+C13*2*22+D13*45+E13*63+F13*100+G13*180+H13*1*746+I13+J13*2*746+K13","v":1080},12,20,null,null,null,{"$f":"+L13/120","v":9},null,"Reserva"]
["10'",null,null,null,null,null,5,null,null,null,null,{"$f":"+B14*18+C14*2*22+D14*45+E14*63+F14*100+G14*180+H14*1*746+I14+J14*2*746+K14","v":900},12,20,null,null,{"$f":"+L14/120","v":7.5},null,null,"Reserva"]
["11'",null,null,null,null,null,1,null,null,null,null,200,12,20,null,null,null,{"$f":"+L15/120","v":1.6666666666666667},null,"Extractor"]
["12'-14'",null,null,null,null,null,null,1,null,null,null,1500,10,null,20,null,null,{"$f":"S16","v":6.8181818181818183},{"$f":"+L16/220","v":6.8181818181818183},"Mini Split"]
["13'-15'",null,null,null,null,null,null,4,null,null,null,{"$f":"+B17*18+C17*2*22+D17*45+E17*63+F17*100+G17*180+H17*1*746+I17+J17*2*746+K17","v":2984},12,null,20,null,{"$f":"+L17/220","v":13.563636363636364},null,{"$f":"Q17","v":13.563636363636364},"Tomas 220 V mesa de trabajo"]
["16'",null,null,null,null,null,null,null,null,null,null,{"$f":"+B18*18+C18*2*22+D18*45+E18*63+F18*100+G18*180+H18*1*746+I18+J18*2*746+K18","v":0},12,20,null,null,{"$f":"+L18/120","v":0},null,null,"Reserva"]
["17'",null,null,null,null,null,null,null,null,null,null,0,12,20,null,null,null,{"$f":"+L19/120","v":0},null,"Reserva"]
["18'",null,null,null,null,null,null,null,null,null,null,0,12,20,null,null,null,null,{"$f":"+L20/120","v":0},"Reserva"]
[]
["SUBTOTAL ",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L6:L21)","v":10484},null,null,null,null,{"$f":"SUM(Q10:Q21)","v":23.336363636363636},{"$f":"SUM(R10:R21)","v":17.484848484848484},{"$f":"SUM(S10:S21)","v":30.154545454545456}]
[]
[null,null,null,null,null,null,"CALCULO DE LA DEMANDA PARCIAL"]
[null,null,"SUBTOTAL ILUMINACION",null,null,null,null,{"$f":"L8","v":440},null,null,null,"AL",1,{"$f":"+H25*M25","v":440}]
[null,null,"SUBTOTAL TOMACORRIENTES",null,null,null,null,{"$f":"L22","v":10484},null,null,null,"AL",0.5,{"$f":"+H26*M26","v":5242}]
[null,null,"SUBTOTAL TOMACORRIENTES ESPECIALES",null,null,null,null,0,null,null,null,"AL",0,{"$f":"+H27*M27","v":0}]
[null,null,"TOTAL DEMANDA",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N25:N27)","v":5682}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PROYECTO",{"$f":"A1","v":"TABLERO MODELOS"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CONTIENE","TAB MOD"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TABLERO ","DENOMINACION","CARGA TOTAL","DEMANDA ","F.P","I (A)","PROTECCION","ALIMENTADOR","LONGITUD","RESISTENCIA","REGULACION ","PERDIDAS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"UBICACIÓN",null,"VA","VA",null,null,"TRIPOLAR (A)","CONDUCTORES DE COBRE","(M)","OHMIOS /KM","PORCENTAJE","VATIOS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LABORATORIO DE MODELOS","T. MOD",{"$f":"L22","v":10484},{"$f":"N28","v":5682},0.95,{"$f":"+Y36/(208*1.732*Z36)","v":16.602229058166827},30,{"$f":"\"5H CABLE CU No \"&VLOOKUP(AE36,'CONSTANTES K'!$I$6:$J$16,2,FALSE)&\" THHN\"","v":"5H CABLE CU No 8 THHN"},30,2.2599999999999998,{"$f":"+(AA36*AD36*AE36*1.732*100)/(1000*220)","v":0.8861786897313213},{"$f":"3*AE36*AD36*AA36*AA36/1000","v":56.063957572947238}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"V36","v":"LABORATORIO DE MODELOS"},{"$f":"W36","v":"T. MOD"},{"$f":"SUM(X36:X36)","v":10484},{"$f":"SUM(Y36:Y36)","v":5682},0.95,{"$f":"+Y37/(208*1.732*Z37)","v":16.602229058166827},30,{"$f":"\"5H CABLE CU No \"&VLOOKUP(AE37,'CONSTANTES K'!$I$6:$J$16,2,FALSE)&\" THHN\"","v":"5H CABLE CU No 8 THHN"},{"$f":"AD36","v":30},2.2599999999999998,{"$f":"+(AA37*AD37*AE37*1.732*100)/(1000*220)","v":0.8861786897313213},{"$f":"3*AE37*AD37*AA37*AA37/1000","v":56.063957572947238}]

{"sheet":"UTILI DUCTOS","index":4,"n_rows":52,"n_cols":8,"rows_kept":52,"cut":false,"hidden":false,"merged":[[20,0,20,7],[30,0,30,3],[42,0,42,3],[0,0,0,5]]}
["CALCULO DE AREA UTILIZADA POR CONDUCTORES ELECTRICOS"]
[]
["ITEM","CONDUCTOR ","AREA DE SECCION mm2","DIAMETRO EXT. (mm)","R (ohm/1000pie)","R (Ohm/km)"]
[]
[1,"ALAMBRE DE COBRE No 12",{"$f":"0.785398*D5*D5","v":7.7931116549999997},3.15,2.0499999999999998,{"$f":"E5/0.3048","v":6.7257217847769022}]
[2,"ALAMBRE DE COBRE No 10",{"$f":"0.785398*D6*D6","v":12.254172295000002},3.95,1.29,{"$f":"E6/0.3048","v":4.2322834645669287}]
[3,"ALAMBRE DE COBRE No 8",21.237161920000002,5.2,0.81,2.6574803149606301]
[4,"CABLE DE COBRE No 8",24.018177698200006,5.53,0.81,2.6574803149606301]
[5,"CABLE DE COBRE No 6",32.877467138199997,6.47,0.51,1.6732283464566928]
[6,"CABLE DE COBRE No 4",53.197284194200009,8.23,0.32100000000000001,1.0531496062992125]
[7,"CABLE DE COBRE No 2",74.203146403200009,9.7200000000000006,0.20100000000000001,0.65944881889763785]
[8,"CABLE DE COBRE No 1/0  ",113.66350541819999,12.03,0.127,0.41666666666666663]
[9,"CABLE DE COBRE No 2/0",135.1940134912,13.12,0.10100000000000001,0.33136482939632544]
[10,"CABLE DE COBRE No 4/0",194.5804695448,15.74,6.2600000000000003E-2,0.20538057742782151]
[]
[11,"CABLE XLPE 15 KV 133% 1/0",593.95723750000002,27.5]
[12,"CABLE FLEXIBLE ST 2No 12",164.67471281920001,14.48]
[13,"CABLE FLEXIBLE ST 3No 12",181.93619006320003,15.22]
[]
[]
["RED SUBTERRANEA PARA BAJA TENSION CABLE DE COBRE THHN"]
[]
["CONDUCTOR "," KV","MATERIAL","SISTEMA","R (OH/KM)","Xl(OH/KM)","CONSTANTE K","In (A)"]
[]
[2,"0,208-120","Cu","TRIFASICO 4 H",0.58577999999999997,0.11977,1.3075999999999999E-3,115]
["1/0","0,208-120","Cu","TRIFASICO 4 H",0.36836000000000002,0.11758,8.6399999999999997E-4,150]
["2/0","0,208-120","Cu","TRIFASICO 4 H",0.29215000000000002,0.11507000000000001,7.092E-4,175]
[]
[]
[]
["CALCULO DE AREA UTILIZADA POR CONDUTORES ELECTRICOS"]
[]
["ITEM","DUCTO","AREA DE SECCION mm2","DIAMETRO"]
[1,"CONDUIT PVC DIAM 1/2",{"$f":"0.785398*D34*D34","v":126.67684341999998},12.7]
[2,"CONDUIT PVC DIAM 3/4",285.02289769500004,19.05]
[3,"CONDUIT PVC DIAM 1 ",506.70737367999993,25.4]
[4,"CONDUIT PVC DIAM 1 1/2",1140.0915907800002,38.1]
[5,"DUCTO ELECTRICO PVC DIAM 2\"",2026.8294947199997,50.8]
[6,"DUCTO ELECTRICO PVC DIAM 3",4560.3663631200006,76.2]
[7,"DUCTO ELECTRICO PVC DIAM 4",8107.3179788799989,101.6]
[]
[]
["CALCULO DE UTILIZACIO DE DUCTOS"]
["CONDUCTOR ","AREA DE SECCION","No DE COND ","TOTA AREA OCUPADA"]
[]
[{"$f":"+B14","v":"CABLE DE COBRE No 4/0"},{"$f":"+C14","v":194.5804695448},8,{"$f":"+B46*C46","v":1556.6437563584}]
[]
["AREA DEL DUCTO DEL TRAMO"]
[]
[{"$f":"+B39","v":"DUCTO ELECTRICO PVC DIAM 3"},{"$f":"+C39","v":4560.3663631200006}]
[]
["PORCENTAJE DE OCUPACION DEL DUCTO",null,null,{"$f":"+D46/B50","v":0.34134182046141864}]

{"sheet":"CONSTANTES K","index":5,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[[3,2,3,4],[3,5,3,6],[3,7,4,7],[3,8,4,8]]}
[]
[]
[]
[null,null,"Resistencia a corriente alterna                    R (ohm/km)",null,null,"Reactancia Inductiva       XL (ohm/km)",null,"PESO     Kg/m","Zeficaz FP=0.85"]
[null,"Calibre AWG / kcmil","Conduit de PVC","Conduit de Aluminio","Conduit de Acero","Conduit de PVC o Aluminio","Conduit de Acero"]
[null,14,10.17,10.17,10.17,0.19,0.24,2.4500000000000001E-2,8.86,14]
[null,12,6.56,6.56,6.56,0.17699999999999999,0.223,3.6900000000000002E-2,5.58,12]
[null,10,3.94,3.94,3.94,0.16400000000000001,0.20699999999999999,5.8599999999999999E-2,3.61,10]
[null,8,2.56,2.56,2.56,0.17100000000000001,0.21299999999999999,9.5699999999999993E-2,2.2599999999999998,8]
[null,6,1.61,1.61,1.61,0.16700000000000001,0.21,0.14499999999999999,1.44,6]
[null,4,1.02,1.02,1.02,0.157,0.19700000000000001,0.23200000000000001,0.95099999999999996,4]
[null,2,0.623,0.65600000000000003,0.65600000000000003,0.14799999999999999,0.187,0.35599999999999998,0.623,2]
[null,"1/0",0.39400000000000002,0.42699999999999999,0.42699999999999999,0.14399999999999999,0.18,0.55600000000000005,0.42699999999999999,"1/0"]
[null,"2/0",0.32800000000000001,0.32800000000000001,0.32800000000000001,0.14099999999999999,0.17699999999999999,0.69099999999999995,0.36099999999999999,"2/0"]
[null,"3/0",0.253,0.26900000000000002,0.25900000000000001,0.13800000000000001,0.17100000000000001,0.86,0.28899999999999998,"3/0"]
[null,"4/0",0.20300000000000001,0.219,0.20699999999999999,0.13500000000000001,0.16700000000000001,1.0720000000000001,0.24299999999999999,"4/0"]
[null,250,null,null,null,null,null,1.278]
[null,300,null,null,null,null,null,1.52]
[null,350,null,null,null,null,null,1.7609999999999999]