{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["TOT-0116","LI-01 (1)","LI-01 (2)","LI-01 (3)","Condiciones Climaticas 313-01","T-01 (1)","T-01 (2)","SA-01 (1)","SA-01 (2)","DATO"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":21,"comments":1,"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":"TOT-0116","index":0,"n_rows":30,"n_cols":9,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[null,"ANEXO II al Memorándum D.T.E.E. N° 243 / 2017"]
[]
["ENTE NACIONAL REGULADOR "]
["DE LA ELECTRICIDAD"]
[]
[null,"PRESTADOR DE LA FUNCIÓN TÉCNICA DE TRANSPORTE DE ENERGÍA ELÉCTRICA"]
[]
[null,"TRANSBA S.A."]
[]
[null,"TOTAL DE PENALIZACIONES A APLICAR"]
[]
[null,1,false]
[null,"Desde el 01 al 31 de enero de 2016"]
[]
[null,"Sanciones duplicadas por tasa de falla > 4 Sal. x año/100km."]
[]
[null,null,"1.-","LÍNEAS",null,null,null,null,{"$f":"'LI-01 (3)'!AC42","v":317571.33}]
[null,null,null,"1.1 -Condiciones climáticas extremas. Resolución ENRE 313/01",null,null,null,null,{"$f":"+'Condiciones Climaticas 313-01'!AM32","v":140.25}]
[]
[null,null,"2.-","CONEXIÓN"]
[]
[null,null,null,"2.1.-","Transformación",null,null,null,{"$f":"'T-01 (2)'!AC44","v":27458.32}]
[]
[null,null,null,"2.2.-","Salidas",null,null,null,{"$f":"'SA-01 (2)'!V43","v":8990.1}]
[]
[]
[null,null,null,null,null,"TOTAL ",{"$f":"ROUND(SUM(I18:I26),2)","v":354160}]
[]
[null,null,"Valores remuneratorios según Acuerdo SEE-ENRE-TRANSBA - 2016-2017"]

{"sheet":"LI-01 (1)","index":1,"n_rows":42,"n_cols":29,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'TOT-0116'!B2","v":"ANEXO II al Memorándum D.T.E.E. N° 243 / 2017"}]
[]
["ENTE NACIONAL REGULADOR "]
["DE LA ELECTRICIDAD"]
[]
[]
[null,null,null,null,null,"SISTEMA DE TRANSPORTE DE ENERGÍA ELÉCTRICA POR DISTRIBUCIÓN TRONCAL - TRANSBA S.A."]
[]
[null,null,null,null,null,"1.- LÍNEAS"]
[]
[null,{"$f":"+'TOT-0116'!B14","v":"Desde el 01 al 31 de enero de 2016"}]
[]
[null,null,null,null,null,"$/100 km-h : LÍNEAS 220 kV ",392.94,null,null,null,null,"FACTOR DE PENALIZACIÓN (CLASE A)  K=",{"$f":"150*'TOT-0116'!B13","v":150},{"$f":"IF(M14=150,\" \",IF(M14=300,\"Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"REVISAR COEFICIENTE\"))","v":" "}]
[null,null,null,null,null,"$/100 km-h : LÍNEAS 132 kV ",375.48,null,null,null,null,"FACTOR DE PENALIZACIÓN (CLASE B)  K=",{"$f":"50*'TOT-0116'!B13","v":50},{"$f":"IF(M15=50,\" \",IF(M15=100,\"Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"REVISAR COEFICIENTE\"))","v":" "}]
[null,null,null,null,null,"$/100 km-h : LÍNEAS 66 kV ",375.48,null,null,null,null,"FACTOR DE PENALIZACIÓN (CLASE C)  K=",{"$f":"10*'TOT-0116'!B13","v":10},{"$f":"IF(M16=10,\" \",IF(M16=20,\"Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"REVISAR COEFICIENTE\"))","v":" "}]
[null,null,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
[null,null,"N°","INDISP","ID EQUIPO","LÍNEAS","U\n[kV]","Long.\n[km]","CLASE","$/h","Salida","Entrada","Hs. \nIndisp","Minutos\nIndisp.","Tipo \nSal.(²)","C.R.\n%","K\n(CLASE)","PENALIZ.\nPROGRAM.","REDUCC.\nPROGRAM.","PENALIZACIÓN FORZADA\nPor Salida   1ras. 3 hs.   hs. Restantes",null,null,"REDUCC. FORZADA\nPor Salida   1ras. 3 hs.   hs. Restantes",null,null,"RESTANTE\nFORZADA","REDUCC.\nRESTANTE","Informó\nen Térm.","TOTAL\nPENALIZAC."]
[]
[]
[]
[null,null,2,297205,1421,"ARRECIFES - CAP. SARMIENTO",66,31.899999618530273,"C",{"$f":"IF(G22=220,$G$14,IF(G22=132,$G$15,$G$16))*IF(H22>25,H22,25)/100","v":119.77811856765747},"2016-01-04T10:13:00","2016-01-04T12:54:00",{"$f":"IF(F22=\"\",\"\",(L22-K22)*24)","v":2.6833333333488554},{"$f":"IF(F22=\"\",\"\",ROUND((L22-K22)*24*60,0))","v":161},"F","0,000",{"$f":"IF(I22=\"A\",$M$14,IF(I22=\"B\",$M$15,$M$16))","v":10},{"$f":"IF(O22=\"P\",ROUND(N22/60,2)*J22*Q22*0.01,\"--\")","v":"--"},{"$f":"IF(O22=\"RP\",ROUND(N22/60,2)*J22*Q22*0.01*P22/100,\"--\")","v":"--"},{"$f":"IF(O22=\"F\",J22*Q22,\"--\")","v":1197.7811856765748},{"$f":"IF(AND(N22>10,O22=\"F\"),J22*Q22*IF(N22>180,3,ROUND((N22)/60,2)),\"--\")","v":3210.0535776132206},{"$f":"IF(AND(O22=\"F\",N22>180),(ROUND(N22/60,2)-3)*J22*Q22*0.1,\"--\")","v":"--"},{"$f":"IF(O22=\"R\",J22*Q22*P22/100,\"--\")","v":"--"},{"$f":"IF(AND(N22>10,O22=\"R\"),Q22*J22*P22/100*IF(N22>180,3,ROUND((N22)/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(O22=\"R\",N22>180),(ROUND(N22/60,2)-3)*J22*Q22*0.1*P22/100,\"--\")","v":"--"},{"$f":"IF(O22=\"RF\",ROUND(N22/60,2)*J22*Q22*0.1,\"--\")","v":"--"},{"$f":"IF(O22=\"RR\",ROUND(N22/60,2)*J22*Q22*0.1*P22/100,\"--\")","v":"--"},"SI",{"$f":"IF(F22=\"\",\"\",SUM(R22:AA22)*IF(AB22=\"SI\",1,2))","v":4407.8347632897949}]
[null,null,3,297206,1543,"PUNTA ALTA - BAHIA BLANCA",132,24.100000381469727,"C",93.87,"2016-01-04T11:21:00","2016-01-04T17:10:00",5.8166666667675599,349,"P","0,000",10,54.632340000000013,"--","--","--","--","--","--","--","--","--","SI",54.632340000000013]
[null,null,4,297207,1522,"BALCARCE - MAR DEL PLATA",132,62.900001525878906,"C",236.17692572937011,"2016-01-04T16:26:00","2016-01-04T16:51:00",0.41666666662786156,25,"F","0,000",10,"--","--",2361.7692572937012,991.94308806335448,"--","--","--","--","--","--","SI",3353.7123453570557]
[null,null,5,297208,1439,"SAN CLEMENTE - DOLORES",132,102.59999847412109,"C",385.24247427062988,"2016-01-05T01:35:00","2016-01-05T07:44:00",6.1500000001396984,369,"F","0,000",10,"--","--",3852.4247427062987,11557.274228118897,1213.5137939524845,"--","--","--","--","--","SI",16623.21276477768]
[null,null,6,297215,1520,"LAS ARMAS - DOLORES",132,88.199996948242188,"C",331.17334854125977,"2016-01-05T01:35:00","2016-01-05T02:22:00",0.78333333344198763,47,"F","0,000",10,"--","--",3311.7334854125975,2583.152118621826,"--","--","--","--","--","--","SI",5894.8856040344235]
[null,null,7,297216,1437,"DOLORES - CHASCOMUS",132,90.230003356933594,"C",338.79561660461428,"2016-01-05T01:35:00","2016-01-05T02:21:00",0.76666666672099382,46,"F","0,000",10,"--","--",3387.9561660461427,2608.7262478555299,"--","--","--","--","--","--","SI",5996.6824139016726]
[null,null,8,297221,1434,"9 DE JULIO - BRAGADO",66,60.939998626708984,"C",228.81750684356692,"2016-01-05T06:20:00","2016-01-05T08:13:00",1.8833333333604969,113,"P","0,000",10,43.017691286590583,"--","--","--","--","--","--","--","--","--","SI",43.017691286590583]
[null,null,9,297222,2713,"VILLA LIA \"T\" - VILLA LÍA",132,8,"C",93.87,"2016-01-05T07:17:00","2016-01-05T20:07:00",12.833333333255723,770,"P","0,000",10,120.43521000000001,"--","--","--","--","--","--","--","--","--","SI",120.43521000000001]
[null,null,10,297224,1543,"PUNTA ALTA - BAHIA BLANCA",132,24.100000381469727,"C",93.87,"2016-01-05T10:06:00","2016-01-05T17:10:00",7.0666666668257676,424,"P","0,000",10,66.36609,"--","--","--","--","--","--","--","--","--","SI",66.36609]
[null,null,11,297225,3575,"NUEVA CAMPANA - PRAXAIR",132,6.0999999046325684,"C",93.87,"2016-01-06T08:45:00","2016-01-06T16:41:00",7.9333333333488554,476,"P","0,000",10,74.438909999999993,"--","--","--","--","--","--","--","--","--","SI",74.438909999999993]
[null,null,12,297227,2713,"VILLA LIA \"T\" - VILLA LÍA",132,8,"C",93.87,"2016-01-06T09:25:00","2016-01-06T19:55:00",10.5,630,"P","0,000",10,98.563500000000005,"--","--","--","--","--","--","--","--","--","SI",98.563500000000005]
[null,null,13,297228,1543,"PUNTA ALTA - BAHIA BLANCA",132,24.100000381469727,"C",93.87,"2016-01-06T10:51:00","2016-01-06T17:08:00",6.28333333338378,377,"P","0,000",10,58.950360000000003,"--","--","--","--","--","--","--","--","--","SI",58.950360000000003]
[null,null,14,297229,3576,"CAMPANA - PRAXAIR",132,1.1000000238418579,"C",93.87,"2016-01-07T07:36:00","2016-01-07T17:58:00",10.366666666755918,622,"P","0,000",10,97.343189999999993,"--","--","--","--","--","--","--","--","--","SI",97.343189999999993]
[null,null,15,297230,1543,"PUNTA ALTA - BAHIA BLANCA",132,24.100000381469727,"C",93.87,"2016-01-07T09:16:00","2016-01-07T17:19:00",8.0500000000465661,483,"P","0,000",10,75.565350000000024,"--","--","--","--","--","--","--","--","--","SI",75.565350000000024]
[null,null,16,297232,2713,"VILLA LIA \"T\" - VILLA LÍA",132,8,"C",93.87,"2016-01-07T09:35:00","2016-01-07T18:38:00",9.0499999999883585,543,"P","0,000",10,84.95235000000001,"--","--","--","--","--","--","--","--","--","SI",84.95235000000001]
[null,null,17,297234,2712,"FICTICIO PICO - T. LAUQUEN",132,77.400001525878906,"C",290.62152572937009,"2016-01-08T07:08:00","2016-01-08T09:40:00",2.53333333338378,152,"P","0,000",10,73.527246009530629,"--","--","--","--","--","--","--","--","--","SI",73.527246009530629]
[null,null,18,297236,2713,"VILLA LIA \"T\" - VILLA LÍA",132,8,"C",93.87,"2016-01-08T08:15:00","2016-01-08T12:25:00",4.1666666666278616,250,"P","0,000",10,39.143790000000003,"--","--","--","--","--","--","--","--","--","SI",39.143790000000003]
[null,null,19,297238,3576,"CAMPANA - PRAXAIR",132,1.1000000238418579,"C",93.87,"2016-01-08T08:50:00","2016-01-08T13:31:00",4.683333333407063,281,"P","0,000",10,43.931159999999998,"--","--","--","--","--","--","--","--","--","SI",43.931159999999998]
[]
[]
[null,null,"(²)","P - PROGRAMADA  ; F - FORZADA",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R19:R41)","v":930.86718729612119},0,14111.664837135313,20951.149260272829,1213.5137939524845,0,0,0,0,0,null,{"$f":"ROUND(SUM(AC19:AC41),2)","v":37207.199999999997}]

{"sheet":"LI-01 (2)","index":2,"n_rows":42,"n_cols":29,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'TOT-0116'!B2","v":"ANEXO II al Memorándum D.T.E.E. N° 243 / 2017"}]
[]
["ENTE NACIONAL REGULADOR "]
["DE LA ELECTRICIDAD"]
[]
[]
[null,null,null,null,null,"SISTEMA DE TRANSPORTE DE ENERGÍA ELÉCTRICA POR DISTRIBUCIÓN TRONCAL - TRANSBA S.A."]
[]
[null,null,null,null,null,"1.- LÍNEAS"]
[]
[null,{"$f":"+'TOT-0116'!B14","v":"Desde el 01 al 31 de enero de 2016"}]
[]
[null,null,null,null,null,"$/100 km-h : LÍNEAS 220 kV ",392.94,null,null,null,null,"FACTOR DE PENALIZACIÓN (CLASE A)  K=",{"$f":"150*'TOT-0116'!B13","v":150},{"$f":"IF(M14=150,\" \",IF(M14=300,\"Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"REVISAR COEFICIENTE\"))","v":" "}]
[null,null,null,null,null,"$/100 km-h : LÍNEAS 132 kV ",375.48,null,null,null,null,"FACTOR DE PENALIZACIÓN (CLASE B)  K=",{"$f":"50*'TOT-0116'!B13","v":50},{"$f":"IF(M15=50,\" \",IF(M15=100,\"Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"REVISAR COEFICIENTE\"))","v":" "}]
[null,null,null,null,null,"$/100 km-h : LÍNEAS 66 kV ",375.48,null,null,null,null,"FACTOR DE PENALIZACIÓN (CLASE C)  K=",{"$f":"10*'TOT-0116'!B13","v":10},{"$f":"IF(M16=10,\" \",IF(M16=20,\"Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"REVISAR COEFICIENTE\"))","v":" "}]
[null,null,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
[null,null,"N°","INDISP","ID EQUIPO","LÍNEAS","U\n[kV]","Long.\n[km]","CLASE","$/h","Salida","Entrada","Hs. \nIndisp","Minutos\nIndisp.","Tipo \nSal.(²)","C.R.\n%","K\n(CLASE)","PENALIZ.\nPROGRAM.","REDUCC.\nPROGRAM.","PENALIZACIÓN FORZADA\nPor Salida   1ras. 3 hs.   hs. Restantes",null,null,"REDUCC. FORZADA\nPor Salida   1ras. 3 hs.   hs. Restantes",null,null,"RESTANTE\nFORZADA","REDUCC.\nRESTANTE","Informó\nen Térm.","TOTAL\nPENALIZAC."]
[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,null,null,null,{"$f":"'LI-01 (1)'!AC42","v":37207.199999999997}]
[]
[null,null,20,297241,1543,"PUNTA ALTA - BAHIA BLANCA",132,24.100000381469727,"C",{"$f":"IF(G21=220,$G$14,IF(G21=132,$G$15,$G$16))*IF(H21>25,H21,25)/100","v":93.87},"2016-01-08T11:01:00","2016-01-08T17:23:00",{"$f":"IF(F21=\"\",\"\",(L21-K21)*24)","v":6.3666666668141261},{"$f":"IF(F21=\"\",\"\",ROUND((L21-K21)*24*60,0))","v":382},"P","0,000",{"$f":"IF(I21=\"A\",$M$14,IF(I21=\"B\",$M$15,$M$16))","v":10},{"$f":"IF(O21=\"P\",ROUND(N21/60,2)*J21*Q21*0.01,\"--\")","v":59.795190000000005},{"$f":"IF(O21=\"RP\",ROUND(N21/60,2)*J21*Q21*0.01*P21/100,\"--\")","v":"--"},{"$f":"IF(O21=\"F\",J21*Q21,\"--\")","v":"--"},{"$f":"IF(AND(N21>10,O21=\"F\"),J21*Q21*IF(N21>180,3,ROUND((N21)/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(O21=\"F\",N21>180),(ROUND(N21/60,2)-3)*J21*Q21*0.1,\"--\")","v":"--"},{"$f":"IF(O21=\"R\",J21*Q21*P21/100,\"--\")","v":"--"},{"$f":"IF(AND(N21>10,O21=\"R\"),Q21*J21*P21/100*IF(N21>180,3,ROUND((N21)/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(O21=\"R\",N21>180),(ROUND(N21/60,2)-3)*J21*Q21*0.1*P21/100,\"--\")","v":"--"},{"$f":"IF(O21=\"RF\",ROUND(N21/60,2)*J21*Q21*0.1,\"--\")","v":"--"},{"$f":"IF(O21=\"RR\",ROUND(N21/60,2)*J21*Q21*0.1*P21/100,\"--\")","v":"--"},"SI",{"$f":"IF(F21=\"\",\"\",SUM(R21:AA21)*IF(AB21=\"SI\",1,2))","v":59.795190000000005}]
[null,null,21,297703,1534,"BAHIA BLANCA - NORTE II",132,19,"C",93.87,"2016-01-11T09:02:00","2016-01-11T13:53:00",4.8500000000931323,291,"P","0,000",10,45.526949999999999,"--","--","--","--","--","--","--","--","--","SI",45.526949999999999]
[null,null,22,297712,4328,"MAR DE AJO - MAR DEL TUYU - LAS TONINAS",132,29.569999694824219,"C",111.02943485412598,"2016-01-12T06:11:00","2016-01-12T08:19:00",2.1333333333022892,128,"P","0,000",10,23.649269623928834,"--","--","--","--","--","--","--","--","--","SI",23.649269623928834]
[null,null,23,297713,1534,"BAHIA BLANCA - NORTE II",132,19,"C",93.87,"2016-01-12T07:56:00","2016-01-12T13:52:00",5.9333333332906477,356,"P","0,000",10,55.664909999999999,"--","--","--","--","--","--","--","--","--","SI",55.664909999999999]
[null,null,24,297717,1534,"BAHIA BLANCA - NORTE II",132,19,"C",93.87,"2016-01-13T08:04:00","2016-01-13T13:39:00",5.5833333333721384,335,"P","0,000",10,52.379460000000009,"--","--","--","--","--","--","--","--","--","SI",52.379460000000009]
[null,null,25,297720,1531,"BAHIA BLANCA - PRINGLES",132,102.08999633789062,"C",383.32751824951168,"2016-01-14T07:49:00","2016-01-14T17:09:00",9.3333333333721384,560,"P","0,000",10,357.64457452679437,"--","--","--","--","--","--","--","--","--","SI",357.64457452679437]
[null,null,26,297724,3797,"S. A. ARECO - LUJAN",66,49.799999237060547,"C",186.98903713531493,"2016-01-14T09:35:00","2016-01-14T14:17:00",4.6999999999534339,282,"P","0,000",10,87.884847453598027,"--","--","--","--","--","--","--","--","--","SI",87.884847453598027]
[null,null,27,297727,1531,"BAHIA BLANCA - PRINGLES",132,102.08999633789062,"C",383.32751824951168,"2016-01-15T07:55:00","2016-01-15T14:40:00",6.75,405,"P","0,000",10,258.74607481842037,"--","--","--","--","--","--","--","--","--","SI",258.74607481842037]
[null,null,28,297728,3797,"S. A. ARECO - LUJAN",66,49.799999237060547,"C",186.98903713531493,"2016-01-15T09:39:00","2016-01-15T14:36:00",4.9499999998952262,297,"P","0,000",10,92.559573381980897,"--","--","--","--","--","--","--","--","--","SI",92.559573381980897]
[null,null,29,297736,1450,"OLAVARRIA - AZUL",132,51.400001525878906,"C",192.99672572937013,"2016-01-17T06:33:00","2016-01-17T08:39:00",2.1000000000349246,126,"P","0,000",10,40.529312403167729,"--","--","--","--","--","--","--","--","--","SI",40.529312403167729]
[null,null,30,297737,5043,"RAMALLO - SIDERAR  1",132,6.75,"C",93.87,"2016-01-17T09:30:00","2016-01-17T15:57:00",6.4499999998952262,387,"P","0,000",10,60.546149999999997,"--","--","--","--","--","--","--","--","--","SI",0]
[null,null,31,298071,4831,"NORTE II - LOS CHAÑARES",132,15.729999542236328,"C",93.87,"2016-01-18T08:29:00","2016-01-18T13:33:00",5.066666666592937,304,"P","0,000",10,47.592090000000006,"--","--","--","--","--","--","--","--","--","SI",47.592090000000006]
[null,null,32,298073,2713,"VILLA LIA \"T\" - VILLA LÍA",132,8,"C",93.87,"2016-01-18T12:25:00","2016-01-18T16:54:00",4.4833333334536292,269,"P","0,000",10,42.053760000000004,"--","--","--","--","--","--","--","--","--","SI",0]
[null,null,33,298074,4831,"NORTE II - LOS CHAÑARES",132,15.729999542236328,"C",93.87,"2016-01-19T08:30:00","2016-01-19T13:52:00",5.3666666666977108,322,"P","0,000",10,50.408190000000005,"--","--","--","--","--","--","--","--","--","SI",50.408190000000005]
[null,null,34,298081,4831,"NORTE II - LOS CHAÑARES",132,15.729999542236328,"C",93.87,"2016-01-20T08:24:00","2016-01-20T13:48:00",5.3999999999650754,324,"P","0,000",10,50.689800000000005,"--","--","--","--","--","--","--","--","--","SI",50.689800000000005]
[null,null,35,298083,2713,"VILLA LIA \"T\" - VILLA LÍA",132,8,"C",93.87,"2016-01-20T09:47:00","2016-01-21T18:41:00",32.900000000023283,1974,"P","0,000",10,308.83229999999998,"--","--","--","--","--","--","--","--","--","SI",0]
[null,null,36,298084,1451,"OLAVARRIA VIEJA - OLAVARRIA",132,35.590000152587891,"C",133.63333257293701,"2016-01-20T11:26:00","2016-01-20T13:27:00",2.0166666666045785,121,"P","0,000",10,26.993933179733276,"--","--","--","--","--","--","--","--","--","SI",26.993933179733276]
[null,null,37,298085,4831,"NORTE II - LOS CHAÑARES",132,15.729999542236328,"C",93.87,"2016-01-21T08:18:00","2016-01-21T13:44:00",5.433333333407063,326,"P","0,000",10,50.971409999999999,"--","--","--","--","--","--","--","--","--","SI",50.971409999999999]
[null,null,38,298088,4831,"NORTE II - LOS CHAÑARES",132,15.729999542236328,"C",93.87,"2016-01-22T08:19:00","2016-01-22T13:54:00",5.5833333333721384,335,"P","0,000",10,52.379460000000009,"--","--","--","--","--","--","--","--","--","SI",52.379460000000009]
[null,null,39,298090,2713,"VILLA LIA \"T\" - VILLA LÍA",132,8,"C",93.87,"2016-01-22T08:26:00","2016-01-22T17:46:00",9.3333333331975155,560,"P","0,000",10,{"$f":"IF(O40=\"P\",ROUND(N40/60,2)*J40*Q40*0.01,\"--\")","v":87.580710000000025},"--","--","--","--","--","--","--","--","--","SI",0]
[]
[null,null,"(²)","P - PROGRAMADA",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R19:R41)","v":1852.4279653876238},0,0,0,0,0,0,0,0,0,null,{"$f":"ROUND(SUM(AC19:AC41),2)","v":38560.620000000003}]

{"sheet":"LI-01 (3)","index":3,"n_rows":42,"n_cols":29,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'TOT-0116'!B2","v":"ANEXO II al Memorándum D.T.E.E. N° 243 / 2017"}]
[]
["ENTE NACIONAL REGULADOR "]
["DE LA ELECTRICIDAD"]
[]
[]
[null,null,null,null,null,"SISTEMA DE TRANSPORTE DE ENERGÍA ELÉCTRICA POR DISTRIBUCIÓN TRONCAL - TRANSBA S.A."]
[]
[null,null,null,null,null,"1.- LÍNEAS"]
[]
[null,{"$f":"+'TOT-0116'!B14","v":"Desde el 01 al 31 de enero de 2016"}]
[]
[null,null,null,null,null,"$/100 km-h : LÍNEAS 220 kV ",392.94,null,null,null,null,"FACTOR DE PENALIZACIÓN (CLASE A)  K=",{"$f":"150*'TOT-0116'!B13","v":150},{"$f":"IF(M14=150,\" \",IF(M14=300,\"Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"REVISAR COEFICIENTE\"))","v":" "}]
[null,null,null,null,null,"$/100 km-h : LÍNEAS 132 kV ",375.48,null,null,null,null,"FACTOR DE PENALIZACIÓN (CLASE B)  K=",{"$f":"50*'TOT-0116'!B13","v":50},{"$f":"IF(M15=50,\" \",IF(M15=100,\"Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"REVISAR COEFICIENTE\"))","v":" "}]
[null,null,null,null,null,"$/100 km-h : LÍNEAS 66 kV ",375.48,null,null,null,null,"FACTOR DE PENALIZACIÓN (CLASE C)  K=",{"$f":"10*'TOT-0116'!B13","v":10},{"$f":"IF(M16=10,\" \",IF(M16=20,\"Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"REVISAR COEFICIENTE\"))","v":" "}]
[null,null,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
[null,null,"N°","INDISP","ID EQUIPO","LÍNEAS","U\n[kV]","Long.\n[km]","CLASE","$/h","Salida","Entrada","Hs. \nIndisp","Minutos\nIndisp.","Tipo \nSal.(²)","C.R.\n%","K\n(CLASE)","PENALIZ.\nPROGRAM.","REDUCC.\nPROGRAM.","PENALIZACIÓN FORZADA\nPor Salida   1ras. 3 hs.   hs. Restantes",null,null,"REDUCC. FORZADA\nPor Salida   1ras. 3 hs.   hs. Restantes",null,null,"RESTANTE\nFORZADA","REDUCC.\nRESTANTE","Informó\nen Térm.","TOTAL\nPENALIZAC."]
[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,null,null,null,{"$f":"'LI-01 (2)'!AC42","v":38560.620000000003}]
[]
[]
[null,null,41,298094,3535,"BARADERO - PAPEL PRENSA",132,24,"C",{"$f":"IF(G22=220,$G$14,IF(G22=132,$G$15,$G$16))*IF(H22>25,H22,25)/100","v":93.87},"2016-01-23T14:46:00","2016-01-23T16:13:00",{"$f":"IF(F22=\"\",\"\",(L22-K22)*24)","v":1.4500000000116415},{"$f":"IF(F22=\"\",\"\",ROUND((L22-K22)*24*60,0))","v":87},"F","0,000",{"$f":"IF(I22=\"A\",$M$14,IF(I22=\"B\",$M$15,$M$16))","v":10},{"$f":"IF(O22=\"P\",ROUND(N22/60,2)*J22*Q22*0.01,\"--\")","v":"--"},{"$f":"IF(O22=\"RP\",ROUND(N22/60,2)*J22*Q22*0.01*P22/100,\"--\")","v":"--"},{"$f":"IF(O22=\"F\",J22*Q22,\"--\")","v":938.7},{"$f":"IF(AND(N22>10,O22=\"F\"),J22*Q22*IF(N22>180,3,ROUND((N22)/60,2)),\"--\")","v":1361.115},{"$f":"IF(AND(O22=\"F\",N22>180),(ROUND(N22/60,2)-3)*J22*Q22*0.1,\"--\")","v":"--"},{"$f":"IF(O22=\"R\",J22*Q22*P22/100,\"--\")","v":"--"},{"$f":"IF(AND(N22>10,O22=\"R\"),Q22*J22*P22/100*IF(N22>180,3,ROUND((N22)/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(O22=\"R\",N22>180),(ROUND(N22/60,2)-3)*J22*Q22*0.1*P22/100,\"--\")","v":"--"},{"$f":"IF(O22=\"RF\",ROUND(N22/60,2)*J22*Q22*0.1,\"--\")","v":"--"},{"$f":"IF(O22=\"RR\",ROUND(N22/60,2)*J22*Q22*0.1*P22/100,\"--\")","v":"--"},"SI",{"$f":"IF(F22=\"\",\"\",SUM(R22:AA22)*IF(AB22=\"SI\",1,2))","v":2299.8150000000001}]
[null,null,42,298105,1421,"ARRECIFES - CAP. SARMIENTO",66,31.899999618530273,"C",119.77811856765747,"2016-01-24T07:08:00","2016-01-24T13:56:00",6.7999999999883585,408,"P","0,000",10,81.449120626007087,"--","--","--","--","--","--","--","--","--","SI",81.449120626007087]
[null,null,43,298106,3689,"LAPRIDA - LA PAMPITA",132,72.199996948242188,"C",271.09654854125978,"2016-01-24T18:19:00","2016-01-25T20:26:00",26.116666666755918,1567,"F","0,000",10,"--","--",2710.9654854125979,8132.8964562377932,6267.7522022739277,"--","--","--","--","--","SI",17111.614143924318]
[null,null,44,298107,4965,"VALERIA DEL MAR - VILLA GESELL",132,14.279999732971191,"C",93.87,"2016-01-24T23:45:00","2016-01-25T00:01:00",0.26666666666278616,16,"F","0,000",10,"--","--",938.7,253.44900000000004,"--","--","--","--","--","--","SI",1192.1490000000001]
[null,null,45,298399,1529,"MIRAMAR - NECOCHEA",132,103.29000091552734,"A",387.8332954376221,"2016-01-25T08:14:00","2016-01-25T15:36:00",7.3666666667559184,442,"F","0,000",150,"--","--",58174.994315643315,174524.98294692993,25422.47251593613,"--","--","--","--","--","SI",258122.44977850938]
[null,null,46,298400,1544,"PUNTA ALTA - C. PIEDRABUENA",132,25,"C",93.87,"2016-01-25T09:28:00","2016-01-25T13:50:00",4.3666666667559184,262,"P","0,000",10,41.021190000000004,"--","--","--","--","--","--","--","--","--","SI",41.021190000000004]
[null,null,47,298407,2713,"VILLA LIA \"T\" - VILLA LÍA",132,8,"C",93.87,"2016-01-26T07:41:00","2016-01-26T18:37:00",10.933333333174232,656,"P","0,000",10,102.59991000000001,"--","--","--","--","--","--","--","--","--","SI",0]
[null,null,48,298410,1544,"PUNTA ALTA - C. PIEDRABUENA",132,25,"C",93.87,"2016-01-26T09:55:00","2016-01-26T13:39:00",3.7333333332790062,224,"P","0,000",10,35.013510000000004,"--","--","--","--","--","--","--","--","--","SI",35.013510000000004]
[null,null,49,298411,1544,"PUNTA ALTA - C. PIEDRABUENA",132,25,"C",93.87,"2016-01-27T08:54:00","2016-01-27T13:15:00",4.3500000000349246,261,"P","0,000",10,40.833449999999999,"--","--","--","--","--","--","--","--","--","SI",40.833449999999999]
[null,null,50,298414,1544,"PUNTA ALTA - C. PIEDRABUENA",132,25,"C",93.87,"2016-01-28T08:36:00","2016-01-28T13:18:00",4.7000000001280569,282,"P","0,000",10,44.118900000000004,"--","--","--","--","--","--","--","--","--","SI",44.118900000000004]
[null,null,51,298416,1544,"PUNTA ALTA - C. PIEDRABUENA",132,25,"C",93.87,"2016-01-29T08:53:00","2016-01-29T13:23:00",4.5,270,"P","0,000",10,42.241500000000009,"--","--","--","--","--","--","--","--","--","SI",42.241500000000009]
[null,null,null,null,null,null,null,null,null,93.87,null,null,"","",null,{"$f":"IF(F33=\"\",\"\",\"--\")","v":""},10,"--","--","--","--","--","--","--","--","--","--",{"$f":"IF(F33=\"\",\"\",\"SI\")","v":""},""]
[null,null,null,null,null,null,null,null,null,93.87,null,null,"","",null,"",10,"--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,93.87,null,null,"","",null,"",10,"--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,93.87,null,null,"","",null,"",10,"--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,93.87,null,null,"","",null,"",10,"--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,93.87,null,null,"","",null,"",10,"--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,93.87,null,null,"","",null,"",10,"--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,93.87,null,null,"","",null,"",10,{"$f":"IF(O40=\"P\",ROUND(N40/60,2)*J40*Q40*0.01,\"--\")","v":"--"},"--","--","--","--","--","--","--","--","--","",""]
[]
[null,null,"(²)","P - PROGRAMADA  ; F - FORZADA",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R19:R41)","v":387.27758062600708},0,62763.359801055914,184272.44340316771,31690.224718210058,0,0,0,0,0,null,{"$f":"ROUND(SUM(AC19:AC41),2)","v":317571.33}]

{"sheet":"Condiciones Climaticas 313-01","index":4,"n_rows":36,"n_cols":39,"rows_kept":36,"cut":false,"hidden":false,"merged":[[16,6,16,7],[23,2,25,2],[26,2,29,2]]}
[]
[null,{"$f":"+'TOT-0116'!B2","v":"ANEXO II al Memorándum D.T.E.E. N° 243 / 2017"}]
[]
["ENTE NACIONAL REGULADOR "]
["DE LA ELECTRICIDAD"]
[]
[]
[]
[]
[null,null,null,null,null,"SISTEMA DE TRANSPORTE DE ENERGÍA ELÉCTRICA POR DISTRIBUCIÓN TRONCAL - TRANSBA S.A."]
[]
[null,null,null,null,null,"1.1 - Indisponibilidades de LAT causadas por condiciones climáticas extremas. Resolución ENRE 313/01"]
[]
[]
[null,{"$f":"+'TOT-0116'!B14","v":"Desde el 01 al 31 de enero de 2016"}]
[]
[null,null,null,null,null,"$/100 km-h : LINEAS 220 kV ",392.94,null,null,null,null,null,null,null,null,null,null,null,null,"FORMULAS UTILIZADAS PARA EL CALCULO ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FORMULAS UTILIZADAS PARA EL CALCULO "]
[null,null,null,null,null,"$/100 km-h : LINEAS 132 kV ",375.48,null,null,null,null,null,null,null,null,null,null,null,null,"DE LAS SANCIONES SEGÚN REGIMEN NORMAL,",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"DE SANCION SEGÚN REGIMEN NORMAL para"]
[null,null,null,null,null,"$/100 km-h : LINEAS 66 kV ",375.48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," PARA UN TIEMPO Tst= Tdt+Trt",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"el tiempo real de indisponibilidad TI"]
[null,null,null,"orden","N°","LÍNEAS","U\n[kV]","Long.\n[km]","CL","K","$/h","Salida","Entrada","Hs.\nIndisp.","Mtos.\nIndisp.","Tipo \nSal.(²)","Rest.\n%","R.D.","AUT.","PENALIZACIÓN FORZADA\nPor Salida    1ras 3 hs.   hs. Restantes",null,null,"PC en Tst","Informó\nen Térm.","N° de estruc. caidas","Td [hs]","Tf [hs]","fp","Tdt + Tf\n [hs]","Trt [hs]","Tst=Tdt+Trt\n[hs]","Tst [min]","alfa","beta","PENALIZACIÓN FORZADA\nPor Salida    1ras 3 hs.   hs. Restantes",null,null,"TOTAL REGIMEN NORMAL \n(en Ti)","TOTAL\nPENALIZAC."]
[]
[]
[null,null,"EVENTO",1,40,"LAS ARMAS - DOLORES",132,88.199996948242188,"C",10,{"$f":"IF(G24=220,$G$17,IF(G24=132,$G$18,$G$19)*IF(H24>25,H24,25)/100)","v":331.17334854125977},"2016-01-22T17:37:00","2016-01-25T14:47:00",{"$f":"IF(F24=\"\",\"\",(M24-L24)*24)","v":69.166666666686069},{"$f":"IF(F24=\"\",\"\",ROUND((M24-L24)*24*60,0))","v":4150},"F",{"$f":"IF(F24=\"\",\"\",\"--\")","v":"--"},{"$f":"IF(F24=\"\",\"\",\"NO\")","v":"NO"},{"$f":"IF(F24=\"\",\"\",IF(OR(P24=\"P\",P24=\"RP\"),\"--\",\"NO\"))","v":"NO"},{"$f":"IF(AND(P24=\"F\",S24=\"NO\"),K24*J24*IF(R24=\"SI\",1.2,1),\"--\")","v":3311.7334854125975},{"$f":"IF(AND(P24=\"F\",AF24>=10),K24*J24*IF(R24=\"SI\",1.2,1)*IF(AF24<=180,ROUND(AF24/60,2),3),\"--\")","v":9935.2004562377915},{"$f":"IF(AND(P24=\"F\",AF24>180),(ROUND(AF24/60,2)-3)*K24*J24*0.1*IF(R24=\"SI\",1.2,1),\"--\")","v":50669.522326812745},{"$f":"IF(F24=\"\",\"\",SUM(T24:V24)*IF(X24=\"SI\",1,2))","v":63916.456268463138},{"$f":"IF(F24=\"\",\"\",\"SI\")","v":"SI"},5,{"$f":"IF(F24=\"\",\"\",IF(Y24<=10,48,72))","v":48},0,{"$f":"IF(F24=\"\",\"\",0.9)","v":0.9},{"$f":"IF(F24=\"\",\"\",Z24+AA24)","v":48},{"$f":"IF(F24=\"\",\"\",AB24*24*Y24)","v":108},{"$f":"IF(F24=\"\",\"\",AD24+AC24)","v":156},{"$f":"AE24*60","v":9360},{"$f":"LOG(W24)/LOG(AD24)","v":2.3633109799859806},{"$f":"1/(2*Y24)","v":0.1},{"$f":"IF(AND(P24=\"F\",S24=\"NO\"),K24*J24*IF(R24=\"SI\",1.2,1),\"--\")","v":3311.7334854125975},{"$f":"IF(AND(P24=\"F\",O24>=10),K24*J24*IF(R24=\"SI\",1.2,1)*IF(O24<=180,ROUND(O24/60,2),3),\"--\")","v":9935.2004562377915},{"$f":"IF(AND(P24=\"F\",O24>180),(ROUND(O24/60,2)-3)*K24*J24*0.1*IF(R24=\"SI\",1.2,1),\"--\")","v":21913.740472975158},{"$f":"IF(F24=\"\",\"\",SUM(AI24:AK24)*IF(X24=\"SI\",1,2))","v":35160.674414625551},{"$f":"IF(F24=\"\",\" \",IF(N24<=AC24,0,(IF(N24>AE24,AL24,(N24-AC24)^AG24*1/(1-AH24*(N24-AE24))))))","v":140.25041575534894}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,"","","",null,null,null,"","",null,{"$f":"IF(F25=\"\",\"\",IF(#REF!<=#REF!,0,IF(Y25<=10,48,72)))","v":""},null,{"$f":"IF(F25=\"\",\"\",IF(#REF!<=#REF!,1,0.9))","v":""},{"$f":"IF(F25=\"\",\"\",IF(#REF!<=#REF!,#REF!+AA25,Z25+AA25))","v":""},{"$f":"IF(F25=\"\",\"\",IF(#REF!<=#REF!,AB25*Y25*24,AB25*Y25*24))","v":""},"",null,null,null,null,null,null,""," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,"","","",null,null,null,"","",null,{"$f":"IF(F26=\"\",\"\",IF(N25<=AE25,0,IF(Y26<=10,48,72)))","v":""},null,{"$f":"IF(F26=\"\",\"\",IF(N25<=AE25,1,0.9))","v":""},{"$f":"IF(F26=\"\",\"\",IF(N25<=AE25,N25+AA26,Z26+AA26))","v":""},{"$f":"IF(F26=\"\",\"\",IF(N25<=AE25,AB26*Y26*24,AB26*Y26*24))","v":""},"",null,null,null,null,null,null,""," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,"","","",null,null,null,"","",null,{"$f":"IF(F27=\"\",\"\",IF(Y27<=10,48,72))","v":""},null,{"$f":"IF(F27=\"\",\"\",0.9)","v":""},{"$f":"IF(F27=\"\",\"\",Z27+AA27)","v":""},{"$f":"IF(F27=\"\",\"\",AB27*24*Y27)","v":""},"",null,null,null,null,null,null,""," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,"","","",null,null,null,"","",null,{"$f":"IF(F28=\"\",\"\",IF(N27<=AE27,0,IF(Y28<=10,48,72)))","v":""},null,{"$f":"IF(F28=\"\",\"\",IF(N27<=AE27,1,0.9))","v":""},{"$f":"IF(F28=\"\",\"\",IF(N27<=AE27,N27+AA28,Z28+AA28))","v":""},{"$f":"IF(F28=\"\",\"\",IF(N27<=AE27,AB28*Y28*24,AB28*Y28*24))","v":""},"",null,null,null,null,null,null,""," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,"","","",null,null,null,"","",null,{"$f":"IF(F29=\"\",\"\",IF(N28<=AE28,0,IF(Y29<=10,48,72)))","v":""},null,{"$f":"IF(F29=\"\",\"\",IF(N28<=AE28,1,0.9))","v":""},{"$f":"IF(F29=\"\",\"\",IF(N28<=AE28,N28+AA29,Z29+AA29))","v":""},{"$f":"IF(F29=\"\",\"\",IF(N28<=AE28,AB29*Y29*24,AB29*Y29*24))","v":""},"",null,null,null,null,null,null,""," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"","",null,"","","",null,null,null,"","",null,{"$f":"IF(F30=\"\",\"\",IF(N29<=AE29,0,IF(Y30<=10,48,72)))","v":""},null,{"$f":"IF(F30=\"\",\"\",IF(N29<=AE29,1,0.9))","v":""},{"$f":"IF(F30=\"\",\"\",IF(N29<=AE29,N29+AA30,Z30+AA30))","v":""},{"$f":"IF(F30=\"\",\"\",IF(N29<=AE29,AB30*Y30*24,AB30*Y30*24))","v":""},"",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,{"$f":"SUM(T22:T31)","v":3311.7334854125975},{"$f":"SUM(U22:U31)","v":9935.2004562377915},{"$f":"SUM(V22:V31)","v":50669.522326812745},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AI22:AI31)","v":3311.7334854125975},{"$f":"SUM(AJ22:AJ31)","v":9935.2004562377915},{"$f":"SUM(AK22:AK31)","v":21913.740472975158},null,{"$f":"ROUND(SUM(AM22:AM31),2)","v":140.25}]
[null,null,null,null,"Td:","hasta 10 estructuras caídas, Td=48hs, si no 72 horas."]
[null,null,null,null,"Tr:","24 horas por estructura caída."]
[null,null,null,null,"Tdt:","será igual a Tind. o a Td, dependiendo de si el Ti fue menor o no al Tst."]
[null,null,null,null,"fp :","igual a 0,9 o 1 p/ Cond. Climáticas Ext. e igual a 1 p/ Atentados."]

{"sheet":"T-01 (1)","index":5,"n_rows":43,"n_cols":29,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'TOT-0116'!B2","v":"ANEXO II al Memorándum D.T.E.E. N° 243 / 2017"}]
[]
["ENTE NACIONAL REGULADOR "]
["DE LA ELECTRICIDAD"]
[]
[]
[null,null,null,null,null,"SISTEMA DE TRANSPORTE DE ENERGÍA ELÉCTRICA POR DISTRIBUCIÓN TRONCAL - TRANSBA S.A."]
[]
[null,null,null,null,null,"2.- CONEXIÓN"]
[]
[null,null,null,null,null,"2.1.- Transformación"]
[]
[null,{"$f":"'TOT-0116'!B14","v":"Desde el 01 al 31 de enero de 2016"}]
[]
[null,null,null,null,null,"Por Transformador por MVA    $ =",null,null,1.31]
[null,null,null,null,null,"Coeficiente de penalización por salida forzada   =",null,null,{"$f":"60*'TOT-0116'!B13","v":60},null,{"$f":"IF(I17=60,\" \",IF(I17=120,\"    Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"    REVISAR COEFICIENTE\"))","v":" "}]
[null,null,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
[null,null,"N°","INDISP","ID EQUIPO","ESTACIÓN \nTRANSFORMADORA","EQUIPO","POT.\n[MVA]","U\n[kV]","$/h","Salida","Entrada","Hs\nIndisp.","Minutos.\nIndisp.","Tipo \nSal.(²)","AUT.","C.R.\n%","E.N.S.","K (P y ENS)","PENALIZ.\nPROGRAM.","REDUCC.\nPROGRAM.","PENALIZACIÓN FORZADA\nPor Salida   hs. Restantes",null,"REDUCC. FORZADA\nPor Salida   hs. Restantes",null,"RESTANTE\nFORZADA","REDUCC.\nRESTANTE","Informó \nen Térm.","TOTAL\nPENALIZAC."]
[]
[]
[]
[null,null,53,297223,2069,"VILLA LIA","Autotrafo",150,"220/132/13,2",{"$f":"H23*$I$16","v":196.5},"2016-01-05T07:19:00","2016-01-05T20:07:00",{"$f":"IF(F23=\"\",\"\",(L23-K23)*24)","v":12.799999999988358},{"$f":"IF(F23=\"\",\"\",ROUND((L23-K23)*24*60,0))","v":768},"P",{"$f":"IF(F23=\"\",\"\",IF(OR(O23=\"P\",O23=\"RP\"),\"--\",\"NO\"))","v":"--"},"0,000",{"$f":"IF(F23=\"\",\"\",\"NO\")","v":"NO"},{"$f":"$I$17*IF(OR(O23=\"P\",O23=\"RP\"),0.1,1)*IF(R23=\"SI\",1,0.1)","v":0.60000000000000009},{"$f":"IF(O23=\"P\",J23*S23*ROUND(N23/60,2),\"--\")","v":1509.1200000000003},{"$f":"IF(O23=\"RP\",J23*S23*ROUND(N23/60,2)*Q23/100,\"--\")","v":"--"},{"$f":"IF(AND(O23=\"F\",P23=\"NO\"),J23*S23,\"--\")","v":"--"},{"$f":"IF(O23=\"F\",J23*S23*ROUND(N23/60,2),\"--\")","v":"--"},{"$f":"IF(AND(O23=\"R\",P23=\"NO\"),J23*S23*Q23/100,\"--\")","v":"--"},{"$f":"IF(O23=\"R\",J23*S23*ROUND(N23/60,2)*Q23/100,\"--\")","v":"--"},{"$f":"IF(O23=\"RF\",J23*S23*ROUND(N23/60,2),\"--\")","v":"--"},{"$f":"IF(O23=\"RR\",J23*S23*ROUND(N23/60,2)*Q23/100,\"--\")","v":"--"},"SI",{"$f":"IF(F23=\"\",\"\",SUM(T23:AA23)*IF(AB23=\"SI\",1,2)*IF(AND(Q23<>\"0,000\",O23=\"RF\"),Q23/100,1))","v":1509.1200000000003}]
[null,null,54,297226,2069,"VILLA LIA","Autotrafo",150,"220/132/13,2",196.5,"2016-01-06T09:25:00","2016-01-06T19:55:00",10.5,630,"P","--","0,000","NO",0.60000000000000009,1237.9500000000003,"--","--","--","--","--","--","--","SI",1237.9500000000003]
[null,null,55,297231,2069,"VILLA LIA","Autotrafo",150,"220/132/13,2",196.5,"2016-01-07T09:35:00","2016-01-07T18:38:00",9.0499999999883585,543,"P","--","0,000","NO",0.60000000000000009,1066.9950000000003,"--","--","--","--","--","--","--","SI",1066.9950000000003]
[null,null,56,297233,5386,"SALTO","TRAFO 2",30,"132/33/13,2",39.300000000000004,"2016-01-07T10:25:00","2016-01-07T17:04:00",6.6499999998486601,399,"P","--","0,000","NO",0.60000000000000009,156.80700000000004,"--","--","--","--","--","--","--","SI",156.80700000000004]
[null,null,57,297235,2069,"VILLA LIA","Autotrafo",150,"220/132/13,2",196.5,"2016-01-08T08:15:00","2016-01-08T12:25:00",4.1666666666278616,250,"P","--","0,000","NO",0.60000000000000009,491.64300000000009,"--","--","--","--","--","--","--","SI",0]
[null,null,58,297237,5386,"SALTO","TRAFO 2",30,"132/33/13,2",39.300000000000004,"2016-01-08T08:49:00","2016-01-08T11:53:00",3.0666666667093523,184,"P","--","0,000","NO",0.60000000000000009,72.390600000000006,"--","--","--","--","--","--","--","SI",72.390600000000006]
[null,null,59,297239,2510,"URBANA BBCA","Trafo 1",40,"132/33/13,2",52.400000000000006,"2016-01-08T09:39:00","2016-01-08T17:45:00",8.1000000000349246,486,"P","--","0,000","NO",0.60000000000000009,254.66400000000004,"--","--","--","--","--","--","--","SI",254.66400000000004]
[null,null,60,297704,4676,"COLON","TRAFO 1",30,"132/22/13,2",39.300000000000004,"2016-01-11T18:55:00","2016-01-11T20:03:00",1.1333333333604969,68,"F","NO","0,000","SI",60,"--","--",2358.0000000000005,2664.5400000000004,"--","--","--","--","SI",5022.5400000000009]
[null,null,61,297779,4676,"COLON","TRAFO 1",30,"132/33/13,2",39.300000000000004,"2016-01-11T20:04:00","2016-01-12T15:40:00",19.60000000015134,1176,"R","NO",40,"NO",6,"--","--","--","--",94.32,1848.672,"--","--","SI",1942.992]
[null,null,62,297714,2297,"OLAVARRIA VIEJA","T2OA",30,"132/33/13,2",39.300000000000004,"2016-01-12T08:13:00","2016-01-12T12:53:00",4.6666666666860692,280,"P","--","0,000","NO",0.60000000000000009,110.11860000000003,"--","--","--","--","--","--","--","SI",110.11860000000003]
[null,null,63,297718,2296,"OLAVARRIA VIEJA","T1OA",30,"132/33/13,2",39.300000000000004,"2016-01-13T08:19:00","2016-01-13T12:03:00",3.7333333332790062,224,"P","--","0,000","NO",0.60000000000000009,87.953400000000016,"--","--","--","--","--","--","--","SI",87.953400000000016]
[null,null,64,297719,5732,"LUJAN II","TRAFO 2",30,"132/33/13,2",39.300000000000004,"2016-01-13T11:24:00","2016-01-13T13:42:00",2.2999999999883585,138,"P","--","0,000","NO",0.60000000000000009,54.234000000000009,"--","--","--","--","--","--","--","SI",54.234000000000009]
[null,null,65,297723,2501,"PUNTA ALTA","Trafo 2",15,"132/33/13,2",19.650000000000002,"2016-01-14T09:13:00","2016-01-14T17:24:00",8.1833333332906477,491,"P","--","0,000","NO",0.60000000000000009,96.442200000000014,"--","--","--","--","--","--","--","SI",96.442200000000014]
[null,null,66,297725,2483,"LAPRIDA","Trafo 2 ",10,"132/33/13,2",13.100000000000001,"2016-01-14T20:39:00","2016-01-14T21:06:00",0.44999999989522621,27,"F","NO","0,000","SI",60,"--","--",786.00000000000011,353.70000000000005,"--","--","--","--","SI",1139.7000000000003]
[null,null,"66b",297725,2483,"LAPRIDA","Trafo 2 ",10,"132/33/13,2",13.100000000000001,"2016-01-14T21:06:00","2016-01-15T01:40:00",{"$f":"IF(F37=\"\",\"\",(L37-K37)*24)","v":4.5666666667093523},{"$f":"IF(F37=\"\",\"\",ROUND((L37-K37)*24*60,0))","v":274},"RF",{"$f":"IF(F37=\"\",\"\",IF(OR(O37=\"P\",O37=\"RP\"),\"--\",\"NO\"))","v":"NO"},"0,000","NO",{"$f":"$I$17*IF(OR(O37=\"P\",O37=\"RP\"),0.1,1)*IF(R37=\"SI\",1,0.1)","v":6},{"$f":"IF(O37=\"P\",J37*S37*ROUND(N37/60,2),\"--\")","v":"--"},{"$f":"IF(O37=\"RP\",J37*S37*ROUND(N37/60,2)*Q37/100,\"--\")","v":"--"},{"$f":"IF(AND(O37=\"F\",P37=\"NO\"),J37*S37,\"--\")","v":"--"},{"$f":"IF(O37=\"F\",J37*S37*ROUND(N37/60,2),\"--\")","v":"--"},{"$f":"IF(AND(O37=\"R\",P37=\"NO\"),J37*S37*Q37/100,\"--\")","v":"--"},{"$f":"IF(O37=\"R\",J37*S37*ROUND(N37/60,2)*Q37/100,\"--\")","v":"--"},{"$f":"IF(O37=\"RF\",J37*S37*ROUND(N37/60,2),\"--\")","v":359.20200000000006},{"$f":"IF(O37=\"RR\",J37*S37*ROUND(N37/60,2)*Q37/100,\"--\")","v":"--"},"SI",{"$f":"IF(F37=\"\",\"\",SUM(T37:AA37)*IF(AB37=\"SI\",1,2)*IF(AND(Q37<>\"0,000\",O37=\"RF\"),Q37/100,1))","v":359.20200000000006}]
[null,null,67,297730,5288,"BRAGADO","TRAFO 6",15,"132/33/13,2",19.650000000000002,"2016-01-16T07:26:00","2016-01-17T19:12:00",35.766666666779201,2146,"P","--","0,000","NO",0.60000000000000009,421.72830000000016,"--","--","--","--","--","--","--","SI",421.72830000000016]
[null,null,68,298072,2069,"VILLA LIA","Autotrafo",150,"220/132/13,2",196.5,"2016-01-18T12:25:00","2016-01-18T16:54:00",4.4833333334536292,269,"P","--","0,000","NO",0.60000000000000009,528.19200000000012,"--","--","--","--","--","--","--","SI",0]
[null,null,69,298082,2069,"VILLA LIA","Autotrafo",150,"220/132/13,2",196.5,"2016-01-20T09:47:00","2016-01-21T18:41:00",32.900000000023283,1974,"P","--","0,000","NO",0.60000000000000009,3878.9100000000003,"--","--","--","--","--","--","--","SI",0]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"",{"$f":"IF(F41=\"\",\"\",\"--\")","v":""},"",6,"--","--","--","--","--","--","--","--",{"$f":"IF(F41=\"\",\"\",\"SI\")","v":""},""]
[]
[null,null,"(²)"," P - PROGRAMADA  ; F - FORZADA  ; R - REDUCCIÓN FORZADA  ; RF - RESTANTE FORZADA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T20:T42)","v":9967.1481000000022},{"$f":"SUM(U20:U42)","v":0},{"$f":"SUM(V20:V42)","v":3144.0000000000005},{"$f":"SUM(W22:W42)","v":3018.2400000000007},{"$f":"SUM(X20:X42)","v":94.32},{"$f":"SUM(Y22:Y42)","v":1848.672},{"$f":"SUM(Z20:Z42)","v":359.20200000000006},{"$f":"SUM(AA22:AA42)","v":0},null,{"$f":"ROUND(SUM(AC20:AC42),2)","v":13532.84}]

{"sheet":"T-01 (2)","index":6,"n_rows":44,"n_cols":29,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'TOT-0116'!B2","v":"ANEXO II al Memorándum D.T.E.E. N° 243 / 2017"}]
[]
["ENTE NACIONAL REGULADOR "]
["DE LA ELECTRICIDAD"]
[]
[]
[null,null,null,null,null,"SISTEMA DE TRANSPORTE DE ENERGÍA ELÉCTRICA POR DISTRIBUCIÓN TRONCAL - TRANSBA S.A."]
[]
[null,null,null,null,null,"2.- CONEXIÓN"]
[]
[null,null,null,null,null,"2.1.- Transformación"]
[]
[null,{"$f":"'TOT-0116'!B14","v":"Desde el 01 al 31 de enero de 2016"}]
[]
[null,null,null,null,null,"Por Transformador por MVA    $ =",null,null,1.31]
[null,null,null,null,null,"Coeficiente de penalización por salida forzada   =",null,null,{"$f":"60*'TOT-0116'!B13","v":60},null,{"$f":"IF(I17=60,\" \",IF(I17=120,\"    Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"    REVISAR COEFICIENTE\"))","v":" "}]
[null,null,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
[null,null,"N°","INDISP","ID EQUIPO","ESTACIÓN \nTRANSFORMADORA","EQUIPO","POT.\n[MVA]","U\n[kV]","$/h","Salida","Entrada","Hs\nIndisp.","Minutos.\nIndisp.","Tipo \nSal.(²)","AUT.","C.R.\n%","E.N.S.","K (P y ENS)","PENALIZ.\nPROGRAM.","REDUCC.\nPROGRAM.","PENALIZACIÓN FORZADA\nPor Salida   hs. Restantes",null,"REDUCC. FORZADA\nPor Salida   hs. Restantes",null,"RESTANTE\nFORZADA","REDUCC.\nRESTANTE","Informó \nen Térm.","TOTAL\nPENALIZAC."]
[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,null,null,null,{"$f":"'T-01 (1)'!AC43","v":13532.84}]
[]
[null,null,70,298086,3550,"PETROQUIMICA","Trafo 2",40,"132/33/13,2",{"$f":"H22*$I$16","v":52.400000000000006},"2016-01-21T08:51:00","2016-01-21T12:43:00",{"$f":"IF(F22=\"\",\"\",(L22-K22)*24)","v":3.8666666666977108},{"$f":"IF(F22=\"\",\"\",ROUND((L22-K22)*24*60,0))","v":232},"P",{"$f":"IF(F22=\"\",\"\",IF(OR(O22=\"P\",O22=\"RP\"),\"--\",\"NO\"))","v":"--"},"0,000",{"$f":"IF(F22=\"\",\"\",\"NO\")","v":"NO"},{"$f":"$I$17*IF(OR(O22=\"P\",O22=\"RP\"),0.1,1)*IF(R22=\"SI\",1,0.1)","v":0.60000000000000009},{"$f":"IF(O22=\"P\",J22*S22*ROUND(N22/60,2),\"--\")","v":121.67280000000004},{"$f":"IF(O22=\"RP\",J22*S22*ROUND(N22/60,2)*Q22/100,\"--\")","v":"--"},{"$f":"IF(AND(O22=\"F\",P22=\"NO\"),J22*S22,\"--\")","v":"--"},{"$f":"IF(O22=\"F\",J22*S22*ROUND(N22/60,2),\"--\")","v":"--"},{"$f":"IF(AND(O22=\"R\",P22=\"NO\"),J22*S22*Q22/100,\"--\")","v":"--"},{"$f":"IF(O22=\"R\",J22*S22*ROUND(N22/60,2)*Q22/100,\"--\")","v":"--"},{"$f":"IF(O22=\"RF\",J22*S22*ROUND(N22/60,2),\"--\")","v":"--"},{"$f":"IF(O22=\"RR\",J22*S22*ROUND(N22/60,2)*Q22/100,\"--\")","v":"--"},"SI",{"$f":"IF(F22=\"\",\"\",SUM(T22:AA22)*IF(AB22=\"SI\",1,2)*IF(AND(Q22<>\"0,000\",O22=\"RF\"),Q22/100,1))","v":121.67280000000004}]
[null,null,71,298087,4210,"URBANA BBCA","Trafo 2",40,"132/33/13,2",52.400000000000006,"2016-01-21T15:58:00","2016-01-22T20:19:00",28.350000000034925,1701,"F",{"$f":"IF(F23=\"\",\"\",IF(OR(O23=\"P\",O23=\"RP\"),\"--\",\"NO\"))","v":"NO"},"0,000","NO",6,"--","--",314.40000000000003,8913.2400000000016,"--","--","--","--","SI",{"$f":"IF(F23=\"\",\"\",SUM(T23:AA23)*IF(AB23=\"SI\",1,2)*IF(AND(Q23<>\"0,000\",O23=\"RF\"),Q23/100,1))","v":9227.6400000000012}]
[null,null,72,298089,2069,"VILLA LIA","Autotrafo",150,"220/132/13,2",196.5,"2016-01-22T08:26:00","2016-01-22T17:46:00",9.3333333331975155,560,"P","--","0,000","NO",0.60000000000000009,1100.0070000000003,"--","--","--","--","--","--","--","SI",0]
[null,null,73,298091,3550,"PETROQUIMICA","Trafo 2",40,"132/33/13,2",52.400000000000006,"2016-01-22T08:46:00","2016-01-22T09:33:00",0.78333333344198763,47,"P","--","0,000","NO",0.60000000000000009,24.523200000000006,"--","--","--","--","--","--","--","SI",24.523200000000006]
[null,null,74,298401,2296,"OLAVARRIA VIEJA","T1OA",30,"132/33/13,2",39.300000000000004,"2016-01-25T19:06:00","2016-01-25T19:39:00",0.55000000004656613,33,"F","NO","0,000","SI",60,"--","--",2358.0000000000005,1296.9000000000003,"--","--","--","--","SI",3654.9000000000005]
[null,null,"74b",298401,2296,"OLAVARRIA VIEJA","T1OA",30,"132/33/13,2",39.300000000000004,"2016-01-25T19:39:00","2016-01-25T22:42:00",{"$f":"IF(F27=\"\",\"\",(L27-K27)*24)","v":3.0499999999883585},{"$f":"IF(F27=\"\",\"\",ROUND((L27-K27)*24*60,0))","v":183},"RF",{"$f":"IF(F27=\"\",\"\",IF(OR(O27=\"P\",O27=\"RP\"),\"--\",\"NO\"))","v":"NO"},"0,000","NO",{"$f":"$I$17*IF(OR(O27=\"P\",O27=\"RP\"),0.1,1)*IF(R27=\"SI\",1,0.1)","v":6},{"$f":"IF(O27=\"P\",J27*S27*ROUND(N27/60,2),\"--\")","v":"--"},{"$f":"IF(O27=\"RP\",J27*S27*ROUND(N27/60,2)*Q27/100,\"--\")","v":"--"},{"$f":"IF(AND(O27=\"F\",P27=\"NO\"),J27*S27,\"--\")","v":"--"},{"$f":"IF(O27=\"F\",J27*S27*ROUND(N27/60,2),\"--\")","v":"--"},{"$f":"IF(AND(O27=\"R\",P27=\"NO\"),J27*S27*Q27/100,\"--\")","v":"--"},{"$f":"IF(O27=\"R\",J27*S27*ROUND(N27/60,2)*Q27/100,\"--\")","v":"--"},{"$f":"IF(O27=\"RF\",J27*S27*ROUND(N27/60,2),\"--\")","v":719.18999999999994},{"$f":"IF(O27=\"RR\",J27*S27*ROUND(N27/60,2)*Q27/100,\"--\")","v":"--"},"SI",{"$f":"IF(F27=\"\",\"\",SUM(T27:AA27)*IF(AB27=\"SI\",1,2)*IF(AND(Q27<>\"0,000\",O27=\"RF\"),Q27/100,1))","v":719.18999999999994}]
[null,null,75,298406,2069,"VILLA LIA","Autotrafo",150,"220/132/13,2",196.5,"2016-01-26T07:41:00","2016-01-26T18:37:00",10.933333333174232,656,"P","--","0,000","NO",0.60000000000000009,1288.6470000000002,"--","--","--","--","--","--","--","SI",0]
[null,null,76,298415,4718,"T. LAUQUEN","T6TL",30,"132/33/13,2",39.300000000000004,"2016-01-28T08:58:00","2016-01-28T16:30:00",7.5333333332673647,452,"P","--","0,000","NO",0.60000000000000009,177.55740000000006,"--","--","--","--","--","--","--","SI",177.55740000000006]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"",{"$f":"IF(F30=\"\",\"\",\"--\")","v":""},"",6,"--","--","--","--","--","--","--","--",{"$f":"IF(F30=\"\",\"\",\"SI\")","v":""},""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[]
[null,null,"(²)","P - PROGRAMADA  ; F - FORZADA  ; RF - RESTANTE FORZADA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T20:T43)","v":2712.4074000000005},{"$f":"SUM(U20:U43)","v":0},{"$f":"SUM(V20:V43)","v":2672.4000000000005},{"$f":"SUM(W22:W43)","v":10210.140000000001},{"$f":"SUM(X20:X43)","v":0},{"$f":"SUM(Y22:Y43)","v":0},{"$f":"SUM(Z20:Z43)","v":719.18999999999994},{"$f":"SUM(AA22:AA43)","v":0},null,{"$f":"ROUND(SUM(AC20:AC43),2)","v":27458.32}]

{"sheet":"SA-01 (1)","index":7,"n_rows":42,"n_cols":22,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'TOT-0116'!B2","v":"ANEXO II al Memorándum D.T.E.E. N° 243 / 2017"}]
[]
["ENTE NACIONAL REGULADOR "]
["DE LA ELECTRICIDAD"]
[]
[]
[null,null,null,null,null,"SISTEMA DE TRANSPORTE DE ENERGÍA ELÉCTRICA POR DISTRIBUCIÓN TRONCAL -  TRANSBA S.A."]
[]
[null,null,null,null,null,"2.2.- Salidas"]
[]
[null,{"$f":"'TOT-0116'!B14","v":"Desde el 01 al 31 de enero de 2016"}]
[]
[null,null,null,null,null,"Salida en 220 kV",34.93,{"$f":"60*'TOT-0116'!B13","v":60},null,{"$f":"IF(H14=60,\" \",IF(H14=120,\"    Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"    REVISAR COEFICIENTE\"))","v":" "}]
[null,null,null,null,null,"Salida en 132 kV o 66 kV = ",17.466000000000001,{"$f":"50*'TOT-0116'!B13","v":50},null,{"$f":"IF(H15=50,\" \",IF(H15=100,\"    Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"    REVISAR COEFICIENTE\"))","v":" "}]
[null,null,null,null,null,"Salida en 33 kV ",13.097,{"$f":"50*'TOT-0116'!B13","v":50},null,{"$f":"IF(H16=50,\" \",IF(H16=100,\"    Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"    REVISAR COEFICIENTE\"))","v":" "}]
[null,null,null,null,null,"Salida en 13,2 kV =",13.097,{"$f":"40*'TOT-0116'!B13","v":40},null,{"$f":"IF(H17=40,\" \",IF(H17=80,\"    Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"    REVISAR COEFICIENTE\"))","v":" "}]
[null,null,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22]
[null,null,"N°","INDISP","ID EQUIPO","ESTACIÓN \nTRANSFORMADORA","EQUIPO","U\n[kV]","$/h","Salida","Entrada","Hs\nIndisp.","Minutos.\nIndisp.","Tipo \nSal.(²)","AUT.","K (U)","PENALIZAC.\nPROGRAM.","PENALIZACIÓN FORZADA\nPor Salida   hs. Restantes",null,"RESTANTE\nFORZADA","Informó\nen Térm.","TOTAL\nPENALIZAC."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,90,297240,2516,"ET URBANA BBCA","Alimentador a ET \"B\"",33,{"$f":"IF(H35=220,$G$14,IF(AND(H35<=132,H35>=66),$G$15,IF(AND(H35<66,H35>=33),$G$16,$G$17)))","v":13.097},"2016-01-08T09:55:00","2016-01-08T17:00:00",{"$f":"IF(F35=\"\",\"\",(K35-J35)*24)","v":7.0833333333721384},{"$f":"IF(F35=\"\",\"\",ROUND((K35-J35)*24*60,0))","v":425},"P",{"$f":"IF(F35=\"\",\"\",IF(OR(N35=\"P\",N35=\"RP\"),\"--\",\"NO\"))","v":"--"},{"$f":"IF(H35=220,$H$14,IF(AND(H35<=132,H35>=66),$H$15,IF(AND(H35<66,H35>13.2),$H$16,$H$17)))","v":50},{"$f":"IF(N35=\"P\",I35*P35*ROUND(M35/60,2)*0.1,\"--\")","v":463.63380000000006},{"$f":"IF(AND(N35=\"F\",O35=\"NO\"),I35*P35,\"--\")","v":"--"},{"$f":"IF(N35=\"F\",I35*P35*ROUND(M35/60,2),\"--\")","v":"--"},{"$f":"IF(N35=\"RF\",I35*P35*ROUND(M35/60,2),\"--\")","v":"--"},"SI",{"$f":"IF(F35=\"\",\"\",SUM(Q35:T35)*IF(U35=\"SI\",1,2)*IF(H35=\"500/220\",0,1))","v":463.63380000000006}]
[null,null,91,297242,2512,"ET URBANA BBCA","Alimentador a ET ING. WHITE 2",33,13.097,"2016-01-08T12:22:00","2016-01-08T17:00:00",4.6333333334187046,278,"P","--",50,303.19555000000003,"--","--","--","SI",303.19555000000003]
[null,null,92,297702,2480,"LAS FLORES","Alimentador 2 a Coop. LAS FLORES",13.199999809265137,13.097,"2016-01-11T06:24:00","2016-01-11T09:13:00",2.816666666592937,169,"P","--",40,147.73416,"--","--","--","SI",147.73416]
[null,null,93,297705,5060,"COLON","SALIDA C.T. COLON",13.2,13.097,"2016-01-11T18:55:00","2016-01-11T20:13:00",1.3000000000465661,78,"F","NO",40,"--",523.88,681.04399999999998,"--","SI",1204.924]
[null,null,94,297715,3577,"PRAXAIR","Alimentador a PRAXAIR",132,17.466000000000001,"2016-01-12T08:48:00","2016-01-12T14:54:00",6.0999999999767169,366,"P","--",50,532.71300000000008,"--","--","--","SI",532.71300000000008]
[null,null,null,null,null,null,null,null,13.097,null,null,"","",null,"",40,"--","--","--","--",{"$f":"IF(F40=\"\",\"\",\"SI\")","v":""},""]
[]
[null,null,"(²)","P - PROGRAMADA  ; F - FORZADA",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q20:Q41)","v":1447.2765100000001},{"$f":"SUM(R20:R41)","v":523.88},{"$f":"SUM(S20:S41)","v":681.04399999999998},{"$f":"SUM(T20:T41)","v":0},null,{"$f":"ROUND(SUM(V20:V41),2)","v":2652.2}]

{"sheet":"SA-01 (2)","index":8,"n_rows":43,"n_cols":22,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'TOT-0116'!B2","v":"ANEXO II al Memorándum D.T.E.E. N° 243 / 2017"}]
[]
["ENTE NACIONAL REGULADOR "]
["DE LA ELECTRICIDAD"]
[]
[]
[null,null,null,null,null,"SISTEMA DE TRANSPORTE DE ENERGÍA ELÉCTRICA POR DISTRIBUCIÓN TRONCAL -  TRANSBA S.A."]
[]
[null,null,null,null,null,"2.2.- Salidas"]
[]
[null,{"$f":"'TOT-0116'!B14","v":"Desde el 01 al 31 de enero de 2016"}]
[]
[null,null,null,null,null,"Salida en 220 kV",34.93,{"$f":"60*'TOT-0116'!B13","v":60},null,{"$f":"IF(H14=60,\" \",IF(H14=120,\"    Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"    REVISAR COEFICIENTE\"))","v":" "}]
[null,null,null,null,null,"Salida en 132 kV o 66 kV = ",17.466000000000001,{"$f":"50*'TOT-0116'!B13","v":50},null,{"$f":"IF(H15=50,\" \",IF(H15=100,\"    Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"    REVISAR COEFICIENTE\"))","v":" "}]
[null,null,null,null,null,"Salida en 33 kV ",13.097,{"$f":"50*'TOT-0116'!B13","v":50},null,{"$f":"IF(H16=50,\" \",IF(H16=100,\"    Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"    REVISAR COEFICIENTE\"))","v":" "}]
[null,null,null,null,null,"Salida en 13,2 kV =",13.097,{"$f":"40*'TOT-0116'!B13","v":40},null,{"$f":"IF(H17=40,\" \",IF(H17=80,\"    Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"    REVISAR COEFICIENTE\"))","v":" "}]
[null,null,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22]
[null,null,"N°","INDISP","ID EQUIPO","ESTACIÓN \nTRANSFORMADORA","EQUIPO","U\n[kV]","$/h","Salida","Entrada","Hs\nIndisp.","Minutos.\nIndisp.","Tipo \nSal.(²)","AUT.","K (U)","PENALIZAC.\nPROGRAM.","PENALIZACIÓN FORZADA\nPor Salida   hs. Restantes",null,"RESTANTE\nFORZADA","Informó\nen Térm.","TOTAL\nPENALIZAC."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'SA-01 (1)'!V42","v":2652.2}]
[]
[]
[null,null,96,297721,2507,"PUNTA ALTA","Alimentador a Coop. PUNTA ALTA 5",33,{"$f":"IF(H23=220,$G$14,IF(AND(H23<=132,H23>=66),$G$15,IF(AND(H23<66,H23>=33),$G$16,$G$17)))","v":13.097},"2016-01-14T08:29:00","2016-01-14T17:56:00",{"$f":"IF(F23=\"\",\"\",(K23-J23)*24)","v":9.4499999998952262},{"$f":"IF(F23=\"\",\"\",ROUND((K23-J23)*24*60,0))","v":567},"P",{"$f":"IF(F23=\"\",\"\",IF(OR(N23=\"P\",N23=\"RP\"),\"--\",\"NO\"))","v":"--"},{"$f":"IF(H23=220,$H$14,IF(AND(H23<=132,H23>=66),$H$15,IF(AND(H23<66,H23>13.2),$H$16,$H$17)))","v":50},{"$f":"IF(N23=\"P\",I23*P23*ROUND(M23/60,2)*0.1,\"--\")","v":618.83325000000002},{"$f":"IF(AND(N23=\"F\",O23=\"NO\"),I23*P23,\"--\")","v":"--"},{"$f":"IF(N23=\"F\",I23*P23*ROUND(M23/60,2),\"--\")","v":"--"},{"$f":"IF(N23=\"RF\",I23*P23*ROUND(M23/60,2),\"--\")","v":"--"},"SI",{"$f":"IF(F23=\"\",\"\",SUM(Q23:T23)*IF(U23=\"SI\",1,2)*IF(H23=\"500/220\",0,1))","v":618.83325000000002}]
[null,null,97,297722,2503,"PUNTA ALTA","Alimentador a P.S. GRUNBEIN 2",33,13.097,"2016-01-14T08:35:00","2016-01-14T17:55:00",9.3333333333721384,560,"P","--",50,610.97505000000001,"--","--","--","SI",610.97505000000001]
[null,null,98,297729,2503,"PUNTA ALTA","Alimentador a P.S. GRUNBEIN 2",33,13.097,"2016-01-15T09:53:00","2016-01-15T17:26:00",7.5499999999883585,453,"P","--",50,494.41175000000004,"--","--","--","SI",494.41175000000004]
[]
[null,null,100,298075,2127,"PERGAMINO","Alimentador a ALFONSO",33,13.097,"2016-01-19T09:25:00","2016-01-19T15:44:00",6.3166666666511446,379,"P","--",50,413.86520000000002,"--","--","--","SI",413.86520000000002]
[null,null,101,298092,2141,"ARRECIFES","Alimentador a SALTO 2",33,13.097,"2016-01-22T10:20:00","2016-01-22T14:57:00",4.6166666666977108,277,"P","--",50,302.54070000000002,"--","--","--","SI",302.54070000000002]
[null,null,102,298104,2354,"BALCARCE","Alimentador Mc. CAIN",33,13.097,"2016-01-24T07:06:00","2016-01-24T16:24:00",9.3000000001047738,558,"P","--",50,609.01050000000009,"--","--","--","SI",609.01050000000009]
[null,null,103,298108,2448,"MAR DE AJO","Alimentador 7 a MAR DE AJO",13.199999809265137,13.097,"2016-01-24T23:45:00","2016-01-25T00:29:00",0.73333333327900618,44,"F","NO",40,"--",523.88,382.43239999999997,"--","SI",906.31240000000003]
[null,null,104,298109,2450,"MAR DE AJO","Alimentador 5 a SAN BERNARDO",13.199999809265137,13.097,"2016-01-24T23:45:00","2016-01-25T00:14:00",0.48333333333721384,29,"F","NO",40,"--",523.88,251.4624,"--","SI",775.3424]
[null,null,105,298408,2344,"QUEQUEN","Alimentador a LOBERIA.PIERES",33,13.097,"2016-01-26T09:13:00","2016-01-26T10:16:00",1.0499999999301508,63,"P","--",50,68.759250000000009,"--","--","--","SI",68.759250000000009]
[null,null,106,298409,4988,"CAMPANA III","SALIDA 2 PARQ. IND.",33,13.097,"2016-01-26T09:41:00","2016-01-26T14:28:00",4.78333333338378,287,"P","--",50,313.01830000000007,"--","--","--","SI",313.01830000000007]
[null,null,107,298412,5106,"CAMPANA III","ALIMENT. A CAMPANA CENTRO",13.199999809265137,13.097,"2016-01-27T09:09:00","2016-01-27T12:56:00",3.7833333334419876,227,"P","--",40,198.02664000000001,"--","--","--","SI",198.02664000000001]
[]
[null,null,109,298417,2057,"SAN PEDRO","Alimentador a BARADERO  2-32",33,13.097,"2016-01-29T09:54:00","2016-01-29T12:13:00",2.3166666667093523,139,"P","--",50,151.92519999999999,"--","--","--","SI",151.92519999999999]
[]
[]
[null,null,112,298211,2434,"VILLA GESELL","Alimentador 3 a  VILLA GESELL",13.199999809265137,13.097,"2016-01-30T07:33:00","2016-01-30T19:28:00",11.916666666744277,715,"P","--",40,624.46496000000002,"--","--","--","SI",624.46496000000002]
[null,null,113,298218,2434,"VILLA GESELL","Alimentador 3 a  VILLA GESELL",13.199999809265137,13.097,"2016-01-31T07:37:00","2016-01-31T12:24:00",4.78333333338378,287,"P","--",40,250.41464000000002,"--","--","--","SI",250.41464000000002]
[null,null,null,null,null,null,null,null,13.097,null,null,"","",null,"",40,"--","--","--","--",{"$f":"IF(F41=\"\",\"\",\"SI\")","v":""},""]
[]
[null,null,"(²)","P - PROGRAMADA  ; F - FORZADA",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q20:Q42)","v":4656.2454400000006},{"$f":"SUM(R20:R42)","v":1047.76},{"$f":"SUM(S20:S42)","v":633.89480000000003},{"$f":"SUM(T20:T42)","v":0},null,{"$f":"ROUND(SUM(V20:V42),2)","v":8990.1}]

{"sheet":"DATO","index":9,"n_rows":22,"n_cols":29,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Mes","Mes","Dia","Año"]
["enero","01",31,2006]
["febrero","02",{"$f":"IF(MOD(E14,4)=0,29,28)","v":29},{"$f":"+D2+1","v":2007}]
["marzo","03",31,2008]
["abril","04",30,2009]
["mayo","05",31,2010]
["junio","06",30,2011]
["julio","07",31,2012]
["agosto","08",31,2013]
["septiembre","09",30,2014]
["octubre","10",31,2015]
["noviembre","11",30,2016]
["diciembre","12",31,null,null,null,null,null,"Total"]
[11,1,{"$f":"CELL(\"CONTENIDO\",OFFSET(A1,B14,0))","v":"enero"},{"$f":"CELL(\"CONTENIDO\",OFFSET(C1,B14,0))","v":31},{"$f":"CELL(\"CONTENIDO\",OFFSET(D1,A14,0))","v":2016},{"$f":"\"Desde el 01 al \" & D14 & \" de \" & C14 & \" de \" & E14","v":"Desde el 01 al 31 de enero de 2016"},{"$f":"CELL(\"CONTENIDO\",OFFSET(B1,B14,0))","v":"01"},{"$f":"RIGHT(E14,2)","v":"16"},"B14"]
[null,{"$f":"\"\\\\rugor\\files\\Transporte\\Transporte\\AA PROCESO AUT ARCHIVOS J\\TRANSBA\\\" &E14","v":"\\\\rugor\\files\\Transporte\\Transporte\\AA PROCESO AUT ARCHIVOS J\\TRANSBA\\2016"},null,null,null,null,{"$f":"\"J\"&G14&H14&\"TBA\"","v":"J0116TBA"}]
[null,{"$f":"\"\\\\rugor\\files\\Transporte\\transporte\\AA PROCESO AUT\\INTERCAMBIO\\\" &H14&G14","v":"\\\\rugor\\files\\Transporte\\transporte\\AA PROCESO AUT\\INTERCAMBIO\\1601"}]
["Hoja","FilaInicio","FilasPlantilla","Columnas","NombreHoja","OrigenDeDatos","Col00","Col01","Col02","Col03","Col04","Col05","Col06","Col07","Col08","Col09","Col10","Col11","Col12","Col13","Col14","Col15","FILHTOTAL","COLHTOTAL","FILHCALC","COLHCALC","FILTRANSP","COLTRANSP","COL TSAL"]
["MODELO L",21,20,12,{"$f":"\"LI-\" & $G$14","v":"LI-01"},"TRANSBA_INDISPONIBILIDADES_LINEAS_TRANSBA.XLS",3,5,4,6,7,8,9,11,12,15,0,28,16,0,0,0,18,9,42,29,19,29,15]
["MODELO T",22,20,13,{"$f":"\"T-\" & $G$14","v":"T-01"},"TRANSBA_INDISPONIBILIDADES_TRAFOS_TRANSBA.XLS",3,5,4,6,7,8,9,11,12,15,16,18,28,17,0,0,22,9,43,29,20,29,15]
["MODELO S",22,20,10,{"$f":"\"SA-\" & $G$14","v":"SA-01"},"TRANSBA_INDISPONIBILIDADES_SALIDAS_TRANSBA.XLS",3,5,4,6,7,8,10,11,14,15,21,0,0,0,0,0,24,9,43,22,20,22,14]
["MODELO R",21,20,12,{"$f":"\"RE-\" & $G$14","v":"RE-01"},"TRANSBA_INDISPONIBILIDADES_REACTIVOS_TRANSBA.XLS",3,5,4,6,7,8,9,10,12,13,16,17,29,18,0,0,26,9,43,30,20,30,16]
["MODELO VST",19,24,4,{"$f":"\"CAUSAS-VST-\" & $G$14","v":"CAUSAS-VST-01"},"TRANSBA_CAUSAS_VST.XLS",3,4,5,6,7,0,0,0,0,0,0,0,0,0,0,0,999,999,0,0,0,0,0]