{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["TAB Gen","TAB Fundición","TAB Deformación","TAB Vibraciones Mec","TAB Tribología","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":"TAB Gen","index":0,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[0,1,0,3]]}
["SUBESTACION","TABLERO GENERAL LABORATORIO DE 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,"BIPOLAR (A)","CONDUCTORES DE COBRE","(M)","Ω/KM","%","VATIOS"]
["CUARTO ELÉCTRICO"]
[{"$f":"'TAB Deformación'!S38","v":"TABLERO Deformación"},{"$f":"'TAB Deformación'!T38","v":"T-DF"},{"$f":"'TAB Deformación'!U38","v":43522},{"$f":"'TAB Deformación'!V38","v":22801},{"$f":"'TAB Deformación'!W38","v":0.95},{"$f":"'TAB Deformación'!X38","v":66.622214846051008},{"$f":"'TAB Deformación'!Y38","v":70},{"$f":"'TAB Deformación'!Z38","v":"5H CABLE CU No 2 THHN"},{"$f":"'TAB Deformación'!AA38","v":30},{"$f":"'TAB Deformación'!AB38","v":0.623},{"$f":"'TAB Deformación'!AC38","v":0.98028774843577493},{"$f":"'TAB Deformación'!AD38","v":248.86778898139877}]
[{"$f":"'TAB Vibraciones Mec'!S37","v":"TABLERO Vibraciones Mecánicas"},{"$f":"'TAB Vibraciones Mec'!T37","v":"T-VM"},{"$f":"'TAB Vibraciones Mec'!U37","v":12100},{"$f":"'TAB Vibraciones Mec'!V37","v":6290},{"$f":"'TAB Vibraciones Mec'!W37","v":0.95},{"$f":"'TAB Vibraciones Mec'!X37","v":18.378743536759828},{"$f":"'TAB Vibraciones Mec'!Y37","v":30},{"$f":"'TAB Vibraciones Mec'!Z37","v":"5H CABLE CU No 8 THHN"},{"$f":"'TAB Vibraciones Mec'!AA37","v":30},{"$f":"'TAB Vibraciones Mec'!AB37","v":2.2599999999999998},{"$f":"'TAB Vibraciones Mec'!AC37","v":0.98100386455649624},{"$f":"'TAB Vibraciones Mec'!AD37","v":68.704088725564191}]
[{"$f":"'TAB Fundición'!S34","v":"TABLERO Fundición"},{"$f":"'TAB Fundición'!T34","v":"TB- FD"},{"$f":"'TAB Fundición'!U34","v":386430},{"$f":"'TAB Fundición'!V34","v":193855},{"$f":"'TAB Fundición'!W34","v":0.95},{"$f":"'TAB Fundición'!X34","v":267.7644010298684},{"$f":"'TAB Fundición'!Y34","v":300},{"$f":"'TAB Fundición'!Z34","v":"5H CABLE CU No 2/0 THHN"},{"$f":"'TAB Fundición'!AA34","v":30},{"$f":"'TAB Fundición'!AB34","v":0.36099999999999999},{"$f":"'TAB Fundición'!AC34","v":2.2830030991735537},{"$f":"'TAB Fundición'!AD34","v":2329.460692169147}]
[{"$f":"'TAB Tribología'!S36","v":"TABLERO Tribología"},{"$f":"'TAB Tribología'!T36","v":"TB-TRIB"},{"$f":"'TAB Tribología'!U36","v":11792},{"$f":"'TAB Tribología'!V36","v":5712},{"$f":"'TAB Tribología'!W36","v":0.95},{"$f":"'TAB Tribología'!X36","v":16.689886022571088},{"$f":"'TAB Tribología'!Y36","v":30},{"$f":"'TAB Tribología'!Z36","v":"5H CABLE CU No 8 THHN"},{"$f":"'TAB Tribología'!AA36","v":30},{"$f":"'TAB Tribología'!AB36","v":2.2599999999999998},{"$f":"'TAB Tribología'!AC36","v":0.89085756348914258},{"$f":"'TAB Tribología'!AD36","v":56.657536893800554}]
["TOTAL",null,{"$f":"SUM(C6:C9)","v":453844},{"$f":"SUM(D6:D9)","v":228658},0.95,{"$f":"+D10/(208*1.732*E10*2)","v":334.05776944582101},120,{"$f":"\"5H CABLE CU No \"&VLOOKUP(J10,'CONSTANTES K'!$I$6:$J$16,2,FALSE)&\" THHN\"","v":"5H CABLE CU No 4/0 THHN"},30,0.24299999999999999,{"$f":"+(F10*I10*J10*1.732*100)/(1000*220)","v":1.9172304241810822},{"$f":"3*J10*I10*F10*F10/1000","v":2440.5737560640555}]
[null,null,null,null,null,"X2",null,"2X4/0"]

{"sheet":"TAB Fundición","index":1,"n_rows":35,"n_cols":30,"rows_kept":35,"cut":false,"hidden":false,"merged":[[21,2,21,5],[21,7,21,8],[22,7,22,8],[0,0,0,16],[1,0,1,12],[2,0,2,8],[3,2,3,4],[3,5,3,6],[3,12,3,14],[27,19,27,29],[28,19,28,29],[18,6,18,13],[19,7,19,8],[20,7,20,8]]}
["TABLERO Fundición"]
[]
[{"$f":"A1","v":"TABLERO Fundición"}]
["CTO","Lamp","TOMAS",null,null,"TRIFASICO",null,"POTENCIA","CALIBRE","PROTECC.(AMPS.)",null,null,"   FASES",null,null,"DESCRIPCIÓN"]
[null,"160W","110V","220V","OTRO","220V","440V","VA","AWG","1X","2X","3X","F1","F2","F3"]
["1-3-5",null,null,null,null,1,null,20000,4,null,null,100,{"$f":"+H6/220","v":90.909090909090907},{"$f":"+H6/220","v":90.909090909090907},{"$f":"+H6/220","v":90.909090909090907},"Horno de inducción para fusión"]
["2-4-6",null,null,null,null,1,null,110000,"1/0",null,null,200,160,160,160,"Máquina de fundición a presión"]
["7-9-11",null,null,null,null,1,null,250000,"1/0",null,null,500,320,320,320,"Horno de inducción para temple"]
["8-10-12",null,null,null,null,1,null,4400,8,null,null,30,{"$f":"+H9/220","v":20},{"$f":"+H9/220","v":20},{"$f":"+H9/220","v":20},"Máquina universal "]
[13,null,5,null,null,null,null,{"$f":"+B10*40+C10*150+D10*1*746+E10+F10*2*746+G10","v":750},12,20,null,null,{"$f":"+H10/120","v":6.25},null,null,"Tomacorrientes de uso general"]
[14,8,null,null,null,null,null,{"$f":"+B11*160+C11*150+D11*1*746+E11+F11*2*746+G11","v":1280},12,20,null,null,null,{"$f":"+H11/110","v":11.636363636363637},null,"Iluminación Fundición"]
[15,null,null,null,null,null,null,0,12,20,null,null,null,null,{"$f":"+H12/120","v":0},"Reserva"]
[16,null,null,null,null,null,null,0,12,20,null,null,{"$f":"+H13/120","v":0},null,null,"Reserva"]
[17,null,null,null,null,null,null,0,12,20,null,null,null,{"$f":"+H14/110","v":0},null,"Reserva"]
[18,null,null,null,null,null,null,0,12,20,null,null,null,null,{"$f":"+H15/120","v":0},"Reserva"]
[]
["SUBTOTAL ",null,null,null,null,null,null,{"$f":"SUM(H6:H16)","v":386430},null,null,null,null,{"$f":"SUM(M6:M16)","v":597.15909090909088},{"$f":"SUM(N6:N16)","v":602.5454545454545},{"$f":"SUM(O6:O16)","v":590.90909090909088}]
[]
[null,null,null,null,null,null,"CALCULO DE LA DEMANDA PARCIAL"]
[null,null,"SUBTOTAL ILUMINACION",null,null,null,null,{"$f":"H11","v":1280},null,null,null,"AL",1,{"$f":"+H20*M20","v":1280}]
[null,null,"SUBTOTAL TOMACORRIENTES",null,null,null,null,{"$f":"SUM(H6:H10)","v":385150},null,null,null,"AL",0.5,{"$f":"+H21*M21","v":192575}]
[null,null,"SUBTOTAL TOMACORRIENTES ESPECIALES",null,null,null,null,{"$f":"H16","v":0},null,null,null,"AL",1,{"$f":"+H22*M22","v":0}]
[null,null,"TOTAL DEMANDA",null,null,null,null,{"$f":"SUM(H20:I22)","v":386430},null,null,null,null,null,{"$f":"SUM(N20:N22)","v":193855}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PROYECTO","Tablero de fundición"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CONTIENE","TB-FD"]
[]
[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,"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,{"$f":"A3","v":"TABLERO Fundición"},"TB- FD",{"$f":"H17","v":386430},{"$f":"N23","v":193855},0.95,{"$f":"+V33/(220*1.732*W33*2)","v":267.7644010298684},300,{"$f":"\"5H CABLE CU No \"&VLOOKUP(AB33,'CONSTANTES K'!$I$6:$J$16,2,FALSE)&\" THHN\"","v":"5H CABLE CU No 2/0 THHN"},30,0.36099999999999999,{"$f":"+(X33*AA33*AB33*1.732*100)/(1000*220)","v":2.2830030991735537},{"$f":"3*AB33*AA33*X33*X33/1000","v":2329.460692169147}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S33","v":"TABLERO Fundición"},{"$f":"T33","v":"TB- FD"},{"$f":"SUM(U33:U33)","v":386430},{"$f":"SUM(V33:V33)","v":193855},{"$f":"W33","v":0.95},{"$f":"+V34/(220*1.732*W34*2)","v":267.7644010298684},{"$f":"Y33","v":300},{"$f":"\"5H CABLE CU No \"&VLOOKUP(AB34,'CONSTANTES K'!$I$6:$J$16,2,FALSE)&\" THHN\"","v":"5H CABLE CU No 2/0 THHN"},30,0.36099999999999999,{"$f":"+(X34*AA34*AB34*1.732*100)/(1000*220)","v":2.2830030991735537},{"$f":"3*AB34*AA34*X34*X34/1000","v":2329.460692169147}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2x",null,"2x"]

{"sheet":"TAB Deformación","index":2,"n_rows":38,"n_cols":30,"rows_kept":38,"cut":false,"hidden":false,"merged":[[25,2,25,5],[25,7,25,8],[26,7,26,8],[0,0,0,16],[1,0,1,12],[2,0,2,8],[3,2,3,4],[3,5,3,6],[3,12,3,14],[31,19,31,29],[32,19,32,29],[22,6,22,13],[23,7,23,8],[24,7,24,8]]}
["TABLERO Deformación"]
[]
[{"$f":"A1","v":"TABLERO Deformación"}]
["CTO","Lamp","TOMAS",null,null,"TRIFASICO",null,"POTENCIA","CALIBRE","PROTECC.(AMPS.)",null,null,"   FASES",null,null,"DESCRIPCIÓN"]
[null,"160W","110V","220V","OTRO","220V","440V","VA","AWG","1X","2X","3X","F1","F2","F3"]
["1-3-5",null,null,null,null,1,null,10000,8,null,null,60,{"$f":"+H6/220","v":45.454545454545453},{"$f":"+H6/220","v":45.454545454545453},{"$f":"+H6/220","v":45.454545454545453},"Troqueladora"]
["2-4-6",null,null,null,null,1,null,{"$f":"+B7*40+C7*150+D7*1*746+E7+F7*2*746+G7","v":1492},12,null,null,20,{"$f":"+H7/220","v":6.7818181818181822},{"$f":"+H7/220","v":6.7818181818181822},{"$f":"+H7/220","v":6.7818181818181822},"Brazo robótico"]
["7-9-11",null,null,null,null,1,null,500,12,null,null,20,2.2727272727272729,2.2727272727272729,2.2727272727272729,"Proyector digital de perfiles"]
["8-10-12",null,null,null,null,1,null,4000,12,null,null,30,18.181818181818183,18.181818181818183,18.181818181818183,"Plegadora hidráulica"]
["13-15-17",null,null,null,null,null,null,18000,12,null,null,100,81.818181818181813,81.818181818181813,81.818181818181813,"Dobladora de tubo"]
[14,null,5,null,null,null,null,{"$f":"+B11*40+C11*150+D11*1*746+E11+F11*2*746+G11","v":750},12,20,null,null,null,{"$f":"+H11/110","v":6.8181818181818183},null,"Tomacorrientes de uso general"]
[16,10,null,null,null,null,null,{"$f":"+B12*160+C12*150+D12*1*746+E12+F12*2*746+G12","v":1600},12,20,null,null,{"$f":"+H12/120","v":13.333333333333334},null,null,"Iluminación general"]
[18,8,null,null,null,null,null,{"$f":"+B13*160+C13*150+D13*1*746+E13+F13*2*746+G13","v":1280},12,20,null,null,null,null,{"$f":"+H13/120","v":10.666666666666666},"Iluminación Lab Fundición"]
[19,null,1,null,null,null,null,1300,12,20,null,null,10.833333333333334,null,null,"Compresor de tornillo Atlas Copco"]
[20,null,null,null,null,null,null,3000,12,30,null,null,null,{"$f":"+H15/110","v":27.272727272727273},null,"Electroerosionadora de hilo"]
[21,null,null,null,null,null,null,800,12,null,20,null,null,null,{"$f":"+H16/220","v":3.6363636363636362},"Caja de ventilación 2000 CFM para Fundición"]
[22,null,null,null,null,null,null,800,12,null,20,null,{"$f":"+H17/220","v":3.6363636363636362},null,null,"Caja de ventilación 2000 CFM para Fundición"]
[23,null,null,null,null,null,null,0,12,20,null,null,null,{"$f":"+H18/200","v":0},null,"Iluminación Deformación"]
[24,null,null,null,null,null,null,0,12,20,null,null,null,null,{"$f":"+H19/120","v":0},"Reserva"]
[]
["SUBTOTAL ",null,null,null,null,null,null,{"$f":"SUM(H6:H20)","v":43522},null,null,null,null,{"$f":"SUM(M6:M20)","v":182.31212121212121},{"$f":"SUM(N6:N20)","v":188.6},{"$f":"SUM(O6:O20)","v":168.81212121212118}]
[]
[null,null,null,null,null,null,"CALCULO DE LA DEMANDA PARCIAL"]
[null,null,"SUBTOTAL ILUMINACION",null,null,null,null,{"$f":"H12+H13","v":2880},null,null,null,"AL",1,{"$f":"+H24*M24","v":2880}]
[null,null,"SUBTOTAL TOMACORRIENTES",null,null,null,null,{"$f":"SUM(H6:H11)+H14+H16+H15","v":39842},null,null,null,"AL",0.5,{"$f":"+H25*M25","v":19921}]
[null,null,"SUBTOTAL TOMACORRIENTES ESPECIALES",null,null,null,null,{"$f":"H20","v":0},null,null,null,"AL",1,{"$f":"+H26*M26","v":0}]
[null,null,"TOTAL DEMANDA",null,null,null,null,{"$f":"SUM(H24:I26)","v":42722},null,null,null,null,null,{"$f":"SUM(N24:N26)","v":22801}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PROYECTO","BANCO DE DEFORMACIÓN"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CONTIENE","TB-DF"]
[]
[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,"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,{"$f":"A3","v":"TABLERO Deformación"},"T-DF",{"$f":"H21","v":43522},{"$f":"N27","v":22801},0.95,{"$f":"+V37/(208*1.732*W37)","v":66.622214846051008},70,{"$f":"\"5H CABLE CU No \"&VLOOKUP(AB37,'CONSTANTES K'!$I$6:$J$16,2,FALSE)&\" THHN\"","v":"5H CABLE CU No 2 THHN"},30,0.623,{"$f":"+(X37*AA37*AB37*1.732*100)/(1000*220)","v":0.98028774843577493},{"$f":"3*AB37*AA37*X37*X37/1000","v":248.86778898139877}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S37","v":"TABLERO Deformación"},{"$f":"T37","v":"T-DF"},{"$f":"SUM(U37:U37)","v":43522},{"$f":"SUM(V37:V37)","v":22801},0.95,{"$f":"+V38/(208*1.732*W38)","v":66.622214846051008},{"$f":"Y37","v":70},{"$f":"\"5H CABLE CU No \"&VLOOKUP(AB38,'CONSTANTES K'!$I$6:$J$16,2,FALSE)&\" THHN\"","v":"5H CABLE CU No 2 THHN"},{"$f":"AA37","v":30},0.623,{"$f":"+(X38*AA38*AB38*1.732*100)/(1000*220)","v":0.98028774843577493},{"$f":"3*AB38*AA38*X38*X38/1000","v":248.86778898139877}]

{"sheet":"TAB Vibraciones Mec","index":3,"n_rows":37,"n_cols":30,"rows_kept":37,"cut":false,"hidden":false,"merged":[[24,2,24,5],[24,7,24,8],[25,7,25,8],[0,0,0,16],[1,0,1,12],[2,0,2,8],[3,2,3,4],[3,5,3,6],[3,12,3,14],[30,19,30,29],[31,19,31,29],[21,6,21,13],[22,7,22,8],[23,7,23,8]]}
["TABLERO Vibraciones Mecánicas"]
[]
[{"$f":"A1","v":"TABLERO Vibraciones Mecánicas"}]
["CTO",null,"TOMAS",null,null,"TRIFASICO",null,"POTENCIA","CALIBRE","PROTECC.(AMPS.)",null,null,"   FASES",null,null,"DESCRIPCIÓN"]
[null,"160w","110V","220V","OTRO","220V","440V","VA","AWG","1X","2X","3X","F1","F2","F3"]
["1-3-5",null,null,null,null,1,null,{"$f":"+B6*40+C6*150+D6*1*746+E6+F6*2*746+G6","v":1492},12,null,null,20,{"$f":"+H6/220","v":6.7818181818181822},{"$f":"+H6/220","v":6.7818181818181822},{"$f":"+H6/220","v":6.7818181818181822},"Banco de alineación"]
["2-4-6",null,null,null,null,1,null,{"$f":"+B7*40+C7*150+D7*1*746+E7+F7*2*746+G7","v":1492},12,null,null,20,{"$f":"+H7/220","v":6.7818181818181822},{"$f":"+H7/220","v":6.7818181818181822},{"$f":"+H7/220","v":6.7818181818181822},"Banco de rodamientos"]
["7-9-11",null,null,null,null,1,null,1492,12,null,null,20,6.7818181818181822,6.7818181818181822,6.7818181818181822,"Banco de transmisiones dentadas"]
["8-10-12",null,null,null,null,1,null,1492,12,null,null,20,6.7818181818181822,6.7818181818181822,6.7818181818181822,"Banco de  alineación en voladizo"]
["13-15-17",null,null,null,null,1,null,1492,12,null,null,20,6.7818181818181822,6.7818181818181822,6.7818181818181822,"Banco de resistencias y generador"]
[14,null,4,null,null,null,null,{"$f":"+B11*40+C11*150+D11*1*746+E11+F11*2*746+G11+760","v":1360},12,30,null,null,null,{"$f":"+H11/110","v":12.363636363636363},null,"Banco de ejes con grietas + Computadores (2)"]
[16,null,8,null,null,null,null,1200,12,20,null,null,{"$f":"+H12/120","v":10},null,null,"Tomacorrientes de uso general"]
[18,10,null,null,null,null,null,{"$f":"+B13*48+C13*150+D13*1*746+E13+F13*2*746+G13","v":480},12,20,null,null,null,null,{"$f":"+H13/120","v":4},"Iluminación general"]
["19-21",null,null,1,null,null,null,1600,10,null,20,null,{"$f":"+H14/220","v":7.2727272727272725},{"$f":"M14","v":7.2727272727272725},null,"Aire acondicionado 24000 BTU"]
[20,null,null,null,null,null,null,0,12,20,null,null,null,{"$f":"+H15/110","v":0},null,"Reserva"]
[22,null,null,null,null,null,null,{"$f":"+B16*40+C16*150+D16*1*746+E16+F16*2*746+G16","v":0},14,20,null,null,null,null,null,"Reserva"]
[23,null,null,null,null,null,null,0,15,20,null,null,null,null,null,"Reserva"]
[24,null,null,null,null,null,null,0,16,20,null,null,null,null,null,"Reserva"]
[]
["SUBTOTAL ",null,null,null,null,null,null,{"$f":"SUM(H6:H19)","v":12100},null,null,null,null,{"$f":"SUM(M6:M19)","v":51.181818181818187},{"$f":"SUM(N6:N19)","v":53.545454545454554},{"$f":"SUM(O6:O19)","v":37.909090909090914}]
[]
[null,null,null,null,null,null,"CALCULO DE LA DEMANDA PARCIAL"]
[null,null,"SUBTOTAL ILUMINACION",null,null,null,null,{"$f":"H13","v":480},null,null,null,"AL",1,{"$f":"+H23*M23","v":480}]
[null,null,"SUBTOTAL TOMACORRIENTES",null,null,null,null,{"$f":"SUM(H6:H12)+H14","v":11620},null,null,null,"AL",0.5,{"$f":"+H24*M24","v":5810}]
[null,null,"SUBTOTAL TOMACORRIENTES ESPECIALES",null,null,null,null,{"$f":"H19","v":0},null,null,null,"AL",1,{"$f":"+H25*M25","v":0}]
[null,null,"TOTAL DEMANDA",null,null,null,null,{"$f":"SUM(H23:I25)","v":12100},null,null,null,null,null,{"$f":"SUM(N23:N25)","v":6290}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PROYECTO","TABLERO DE VIBRACIONES MECÁNICAS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CONTIENE","TB-VM"]
[]
[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,"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,{"$f":"A3","v":"TABLERO Vibraciones Mecánicas"},"T-VM",{"$f":"H20","v":12100},{"$f":"N26","v":6290},0.95,{"$f":"+V36/(208*1.732*W36)","v":18.378743536759828},30,{"$f":"\"5H CABLE CU No \"&VLOOKUP(AB36,'CONSTANTES K'!$I$6:$J$16,2,FALSE)&\" THHN\"","v":"5H CABLE CU No 8 THHN"},30,2.2599999999999998,{"$f":"+(X36*AA36*AB36*1.732*100)/(1000*220)","v":0.98100386455649624},{"$f":"3*AB36*AA36*X36*X36/1000","v":68.704088725564191}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S36","v":"TABLERO Vibraciones Mecánicas"},{"$f":"T36","v":"T-VM"},{"$f":"SUM(U36:U36)","v":12100},{"$f":"SUM(V36:V36)","v":6290},0.95,{"$f":"+V37/(208*1.732*W37)","v":18.378743536759828},30,{"$f":"\"5H CABLE CU No \"&VLOOKUP(AB37,'CONSTANTES K'!$I$6:$J$16,2,FALSE)&\" THHN\"","v":"5H CABLE CU No 8 THHN"},{"$f":"AA36","v":30},2.2599999999999998,{"$f":"+(X37*AA37*AB37*1.732*100)/(1000*220)","v":0.98100386455649624},{"$f":"3*AB37*AA37*X37*X37/1000","v":68.704088725564191}]

{"sheet":"TAB Tribología","index":4,"n_rows":36,"n_cols":30,"rows_kept":36,"cut":false,"hidden":false,"merged":[[23,2,23,5],[23,7,23,8],[24,7,24,8],[0,0,0,16],[1,0,1,12],[2,0,2,8],[3,2,3,4],[3,5,3,6],[3,12,3,14],[29,19,29,29],[30,19,30,29],[20,6,20,13],[21,7,21,8],[22,7,22,8]]}
["TABLERO Tribología"]
[]
[{"$f":"A1","v":"TABLERO Tribología"}]
["CTO","Lamp","TOMAS",null,null,"TRIFASICO",null,"POTENCIA","CALIBRE","PROTECC.(AMPS.)",null,null,"   FASES",null,null,"DESCRIPCIÓN"]
[null,"160W","110V","220V","OTRO","220V","440V","VA","AWG","1X","2X","3X","F1","F2","F3"]
["1-3-5",null,null,null,null,1,null,{"$f":"+B6*40+C6*150+D6*1*746+E6+F6*2*746+G6","v":1492},10,null,null,20,{"$f":"+H6/220","v":6.7818181818181822},{"$f":"+H6/220","v":6.7818181818181822},{"$f":"+H6/220","v":6.7818181818181822},"Máquina para evaluación del desgaste abrasivo"]
["2-4-6",null,null,null,null,1,null,{"$f":"+B7*40+C7*150+D7*1*746+E7+F7*2*746+G7","v":1492},10,null,null,20,{"$f":"+H7/220","v":6.7818181818181822},{"$f":"+H7/220","v":6.7818181818181822},{"$f":"+H7/220","v":6.7818181818181822},"Máquina para evaluación del desgaste por fatiga"]
["7-9-11",null,null,null,null,1,null,1492,10,null,null,20,6.7818181818181822,6.7818181818181822,6.7818181818181822,"Dispositivo para evaluación del desgaste por erosión"]
["8-10-12",null,null,null,null,1,null,1492,10,null,null,20,{"$f":"+H9/220","v":6.7818181818181822},{"$f":"+H9/220","v":6.7818181818181822},{"$f":"+H9/220","v":6.7818181818181822},"Cortadora metalográfica"]
["13-15-17",null,null,null,null,1,null,1492,10,null,null,20,6.7818181818181822,6.7818181818181822,6.7818181818181822,"Horno de mufla"]
[14,null,2,null,null,null,null,300,12,20,null,null,null,{"$f":"+H11/110","v":2.7272727272727271},null,"Máquina para evaluación del desgate corrosivo y Pulidora metalográfica"]
[16,null,8,null,null,null,null,1200,12,20,null,null,{"$f":"+H12/120","v":10},null,null,"Tomacorrientes de uso general"]
[18,9,null,null,null,null,null,{"$f":"+B13*48+C13*150+D13*1*746+E13+F13*2*746+G13","v":432},12,20,null,null,null,null,{"$f":"+H13/120","v":3.6},"Iluminación general"]
["19-21",null,null,1,null,null,null,1600,10,null,20,null,null,{"$f":"O14","v":7.2727272727272725},{"$f":"+H14/220","v":7.2727272727272725},"Aire Acondicionado 18000 BTU"]
["20-22",null,null,1,null,null,null,800,10,null,20,null,{"$f":"+H15/110","v":7.2727272727272725},{"$f":"+H15/110","v":7.2727272727272725},null,"Aire Acondicionado 9000 BTU"]
[23,null,null,null,null,null,null,0,12,20,null,null,null,{"$f":"+H16/110","v":0},null,"Reserva"]
[24,null,null,null,null,null,null,0,12,20,null,null,null,null,{"$f":"+H17/120","v":0},"Reserva"]
[]
["SUBTOTAL ",null,null,null,null,null,null,{"$f":"SUM(H6:H18)","v":11792},null,null,null,null,{"$f":"SUM(M6:M18)","v":51.181818181818187},{"$f":"SUM(N6:N18)","v":51.181818181818187},{"$f":"SUM(O6:O18)","v":44.781818181818188}]
[]
[null,null,null,null,null,null,"CALCULO DE LA DEMANDA PARCIAL"]
[null,null,"SUBTOTAL ILUMINACION",null,null,null,null,{"$f":"H13","v":432},null,null,null,"AL",1,{"$f":"+H22*M22","v":432}]
[null,null,"SUBTOTAL TOMACORRIENTES",null,null,null,null,{"$f":"SUM(H6:H12)+H14","v":10560},null,null,null,"AL",0.5,{"$f":"+H23*M23","v":5280}]
[null,null,"SUBTOTAL TOMACORRIENTES ESPECIALES",null,null,null,null,{"$f":"H18","v":0},null,null,null,"AL",1,{"$f":"+H24*M24","v":0}]
[null,null,"TOTAL DEMANDA",null,null,null,null,{"$f":"SUM(H22:I24)","v":10992},null,null,null,null,null,{"$f":"SUM(N22:N24)","v":5712}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PROYECTO","TABLERO TRIBOLOGÍA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"CONTIENE","TB-TRIB"]
[]
[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,"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,{"$f":"A3","v":"TABLERO Tribología"},"TB-TRIB",{"$f":"H19","v":11792},{"$f":"N25","v":5712},0.95,{"$f":"+V35/(208*1.732*W35)","v":16.689886022571088},30,{"$f":"\"5H CABLE CU No \"&VLOOKUP(AB35,'CONSTANTES K'!$I$6:$J$16,2,FALSE)&\" THHN\"","v":"5H CABLE CU No 8 THHN"},30,2.2599999999999998,{"$f":"+(X35*AA35*AB35*1.732*100)/(1000*220)","v":0.89085756348914258},{"$f":"3*AB35*AA35*X35*X35/1000","v":56.657536893800554}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S35","v":"TABLERO Tribología"},{"$f":"T35","v":"TB-TRIB"},{"$f":"SUM(U35:U35)","v":11792},{"$f":"SUM(V35:V35)","v":5712},0.95,{"$f":"+V36/(208*1.732*W36)","v":16.689886022571088},30,{"$f":"\"5H CABLE CU No \"&VLOOKUP(AB36,'CONSTANTES K'!$I$6:$J$16,2,FALSE)&\" THHN\"","v":"5H CABLE CU No 8 THHN"},{"$f":"AA35","v":30},2.2599999999999998,{"$f":"+(X36*AA36*AB36*1.732*100)/(1000*220)","v":0.89085756348914258},{"$f":"3*AB36*AA36*X36*X36/1000","v":56.657536893800554}]

{"sheet":"UTILI DUCTOS","index":5,"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":6,"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]