{"text_format":"1","workbook":"xlsx","n_sheets":14,"sheets":["TOT-0316","LI-03 (1)","LI-03 (2)","LI-03 (3)","LI-03 (4)","LI-03 (5)","T-03 (1)","T-03 (2)","T-03 (3)","SA-03 (1)","SA-03 (2)","SA-03 (3)","RE-03 (1)","DATO"],"not_rendered":{"charts":0,"images":2,"macros":1,"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":"TOT-0316","index":0,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[null,"ANEXO IV 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 Marzo 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-03 (5)'!AC42","v":652417.32999999996}]
[]
[null,null,"2.-","CONEXIÓN"]
[]
[null,null,null,"2.1.-","Transformación",null,null,null,{"$f":"'T-03 (3)'!AC43","v":23453.040000000001}]
[]
[null,null,null,"2.2.-","Salidas",null,null,null,{"$f":"'SA-03 (3)'!V43","v":12425.26}]
[]
[null,null,"3.-","Equipamiento propio Res. 01_03",null,null,null,null,{"$f":"'RE-03 (1)'!AD44","v":170.93}]
[]
[]
[null,null,null,null,null,"TOTAL ",{"$f":"ROUND(SUM(I18:I27),2)","v":688466.56}]
[]
[null,null,"Valores remuneratorios según Acuerdo SEE-ENRE-TRANSBA - 2016-2017"]

{"sheet":"LI-03 (1)","index":1,"n_rows":42,"n_cols":29,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"+'TOT-0316'!B2","v":"ANEXO IV 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-0316'!B14","v":"Desde el 01 al 31 de Marzo 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-0316'!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-0316'!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-0316'!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,1,299941,2616,"PIGUE - GUATRACHE",132,102,"C",{"$f":"IF(G21=220,$G$14,IF(G21=132,$G$15,$G$16))*IF(H21>25,H21,25)/100","v":382.9896},"2016-03-01T08:26:00","2016-03-01T17:25:00",{"$f":"IF(F21=\"\",\"\",(L21-K21)*24)","v":8.9833333332790062},{"$f":"IF(F21=\"\",\"\",ROUND((L21-K21)*24*60,0))","v":539},"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":343.92466079999997},{"$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":343.92466079999997}]
[null,null,2,299943,1543,"PUNTA ALTA - BAHIA BLANCA",132,24.100000381469727,"C",93.87,"2016-03-01T10:41:00","2016-03-01T17:06:00",6.4166666666278616,385,"P","0,000",10,60.264539999999997,"--","--","--","--","--","--","--","--","--","SI",0]
[null,null,3,299944,1407,"SALADILLO - LAS FLORES",132,76.300003051757813,"C",286.49125145874024,"2016-03-01T10:58:00","2016-03-01T14:36:00",3.6333333333022892,218,"P","0,000",10,103.99632427952271,"--","--","--","--","--","--","--","--","--","SI",103.99632427952271]
[null,null,4,299945,2616,"PIGUE - GUATRACHE",132,102,"C",382.9896,"2016-03-02T08:27:00","2016-03-02T17:16:00",8.8166666667675599,529,"P","0,000",10,337.7968272,"--","--","--","--","--","--","--","--","--","SI",337.7968272]
[null,null,5,299946,1407,"SALADILLO - LAS FLORES",132,76.300003051757813,"C",286.49125145874024,"2016-03-02T08:51:00","2016-03-02T18:25:00",9.566666666592937,574,"P","0,000",10,274.17212764601442,"--","--","--","--","--","--","--","--","--","SI",274.17212764601442]
[null,null,6,299947,2714,"VILLA LIA \"T\" - NUEVA CAMPANA",132,35,"C",131.41800000000001,"2016-03-02T08:56:00","2016-03-02T15:33:00",6.6166666667559184,397,"P","0,000",10,86.998716000000002,"--","--","--","--","--","--","--","--","--","SI",0]
[null,null,7,299949,1543,"PUNTA ALTA - BAHIA BLANCA",132,24.100000381469727,"C",93.87,"2016-03-02T09:36:00","2016-03-02T17:34:00",7.96666666661622,478,"P","0,000",10,74.814390000000003,"--","--","--","--","--","--","--","--","--","SI",74.814390000000003]
[null,null,8,299951,1536,"CARLOS CASARES - 9 DE JULIO",66,46.799999237060547,"C",175.72463713531496,"2016-03-03T07:20:00","2016-03-03T09:55:00",2.5833333333721384,155,"P","0,000",10,45.336956380911261,"--","--","--","--","--","--","--","--","--","SI",45.336956380911261]
[null,null,9,299952,2616,"PIGUE - GUATRACHE",132,102,"C",382.9896,"2016-03-03T08:30:00","2016-03-03T17:09:00",8.6500000000814907,519,"P","0,000",10,331.28600400000005,"--","--","--","--","--","--","--","--","--","SI",331.28600400000005]
[null,null,10,299955,1543,"PUNTA ALTA - BAHIA BLANCA",132,24.100000381469727,"C",93.87,"2016-03-03T09:41:00","2016-03-03T17:43:00",8.0333333333255723,482,"P","0,000",10,75.37760999999999,"--","--","--","--","--","--","--","--","--","SI",75.37760999999999]
[null,null,11,299956,1407,"SALADILLO - LAS FLORES",132,76.300003051757813,"C",286.49125145874024,"2016-03-03T09:59:00","2016-03-03T14:31:00",4.5333333332673647,272,"P","0,000",10,129.78053691080933,"--","--","--","--","--","--","--","--","--","SI",129.78053691080933]
[null,null,12,299959,2616,"PIGUE - GUATRACHE",132,102,"C",382.9896,"2016-03-04T08:24:00","2016-03-04T13:48:00",5.3999999999650754,324,"P","0,000",10,206.81438400000002,"--","--","--","--","--","--","--","--","--","SI",206.81438400000002]
[null,null,13,299960,1543,"PUNTA ALTA - BAHIA BLANCA",132,24.100000381469727,"C",93.87,"2016-03-04T09:04:00","2016-03-04T15:50:00",6.7666666665463708,406,"P","0,000",10,63.549990000000001,"--","--","--","--","--","--","--","--","--","SI",63.549990000000001]
[null,null,14,299971,1424,"ZARATE - ATUCHA I",132,22.1,"C",93.87,"2016-03-05T09:42:00","2016-06-05T20:02:00",2218.3333333333139,133100,"P","0,000",10,20823.46371,"--","--","--","--","--","--","--","--","--","SI",0]
[null,null,15,299972,4328,"MAR DE AJO - MAR DEL TUYU - LAS TONINAS",132,29.569999694824219,"C",111.02943485412598,"2016-03-05T09:46:00","2016-03-05T12:59:00",3.2166666666744277,193,"P","0,000",10,35.751478023028568,"--","--","--","--","--","--","--","--","--","SI",35.751478023028568]
[null,null,16,299974,1419,"PERGAMINO - SAN NICOLÁS",132,70.8,"C",265.83983999999998,"2016-03-06T07:24:00","2016-03-06T12:59:00",5.5833333333721384,335,"P","0,000",10,148.33863072,"--","--","--","--","--","--","--","--","--","SI",148.33863072]
[null,null,17,299975,1402,"TRENQUE LAUQUEN - HENDERSON",132,105.40000152587891,"A",395.75592572937012,"2016-03-06T07:27:00","2016-03-06T17:06:00",9.6500000000232831,579,"P","0,000",150,5728.5670249326331,"--","--","--","--","--","--","--","--","--","SI",5728.5670249326331]
[null,null,18,300216,1437,"DOLORES - CHASCOMUS",132,90.230003356933594,"C",338.79561660461428,"2016-03-07T09:16:00","2016-03-07T15:08:00",5.8666666667559184,352,"P","0,000",10,198.87302694690857,"--","--","--","--","--","--","--","--","--","SI",198.87302694690857]
[null,null,19,300217,1536,"CARLOS CASARES - 9 DE JULIO",66,46.799999237060547,"C",175.72463713531496,"2016-03-07T09:40:00","2016-03-07T15:01:00",5.3499999999767169,321,"P","0,000",10,94.012680867393499,"--","--","--","--","--","--","--","--","--","SI",94.012680867393499]
[]
[]
[null,null,"(²)","P - PROGRAMADA  ; F - FORZADA",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R19:R41)","v":29163.119618707224},0,0,0,0,0,0,0,0,0,null,{"$f":"ROUND(SUM(AC19:AC41),2)","v":8192.39}]

{"sheet":"LI-03 (2)","index":2,"n_rows":42,"n_cols":29,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"+'TOT-0316'!B2","v":"ANEXO IV 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-0316'!B14","v":"Desde el 01 al 31 de Marzo 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-0316'!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-0316'!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-0316'!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-03 (1)'!AC42","v":8192.39}]
[]
[null,null,20,300218,2616,"PIGUE - GUATRACHE",132,102,"C",{"$f":"IF(G21=220,$G$14,IF(G21=132,$G$15,$G$16))*IF(H21>25,H21,25)/100","v":382.9896},"2016-03-07T11:32:00","2016-03-07T17:26:00",{"$f":"IF(F21=\"\",\"\",(L21-K21)*24)","v":5.9000000000232831},{"$f":"IF(F21=\"\",\"\",ROUND((L21-K21)*24*60,0))","v":354},"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":225.96386400000003},{"$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":"--"},{"$f":"IF(F21=\"\",\"\",\"SI\")","v":"SI"},{"$f":"IF(F21=\"\",\"\",SUM(R21:AA21)*IF(AB21=\"SI\",1,2))","v":225.96386400000003}]
[null,null,21,300220,2616,"PIGUE - GUATRACHE",132,102,"C",382.9896,"2016-03-08T08:23:00","2016-03-08T17:25:00",9.0333333332673647,542,"P","0,000",10,345.83960880000001,"--","--","--","--","--","--","--","--","--","SI",345.83960880000001]
[null,null,22,300221,1437,"DOLORES - CHASCOMUS",132,90.230003356933594,"C",338.79561660461428,"2016-03-08T08:28:00","2016-03-08T15:44:00",7.2666666666045785,436,"P","0,000",10,246.30441327155458,"--","--","--","--","--","--","--","--","--","SI",246.30441327155458]
[null,null,23,300222,1536,"CARLOS CASARES - 9 DE JULIO",66,46.799999237060547,"C",175.72463713531496,"2016-03-08T08:49:00","2016-03-08T13:28:00",4.6500000001396984,279,"P","0,000",10,81.711956267921465,"--","--","--","--","--","--","--","--","--","SI",81.711956267921465]
[null,null,24,300225,3796,"C. SARMIENTO - S. A. ARECO",66,31.5,"C",118.2762,"2016-03-08T09:39:00","2016-03-08T15:13:00",5.5666666666511446,334,"P","0,000",10,65.879843400000013,"--","--","--","--","--","--","--","--","--","SI",65.879843400000013]
[null,null,25,300231,1437,"DOLORES - CHASCOMUS",132,90.230003356933594,"C",338.79561660461428,"2016-03-09T08:34:00","2016-03-09T15:35:00",7.0166666666627862,421,"P","0,000",10,237.83452285643921,"--","--","--","--","--","--","--","--","--","SI",237.83452285643921]
[null,null,26,300232,1421,"ARRECIFES - CAP. SARMIENTO",66,31.899999618530273,"C",119.77811856765747,"2016-03-09T08:56:00","2016-03-09T16:11:00",7.2500000000582077,435,"P","0,000",10,86.839135961551662,"--","--","--","--","--","--","--","--","--","SI",86.839135961551662]
[null,null,27,300234,2616,"PIGUE - GUATRACHE",132,102,"C",382.9896,"2016-03-09T09:51:00","2016-03-09T16:56:00",7.0833333333721384,425,"P","0,000",10,271.1566368,"--","--","--","--","--","--","--","--","--","SI",271.1566368]
[null,null,28,300238,1531,"BAHIA BLANCA - PRINGLES",132,102.08999633789062,"C",383.32751824951168,"2016-03-10T08:30:00","2016-03-10T17:28:00",8.9666666667326353,538,"P","0,000",10,343.84478386981203,"--","--","--","--","--","--","--","--","--","SI",343.84478386981203]
[null,null,29,300239,2616,"PIGUE - GUATRACHE",132,102,"C",382.9896,"2016-03-10T08:31:00","2016-03-10T17:34:00",9.0499999999883585,543,"P","0,000",10,346.60558800000007,"--","--","--","--","--","--","--","--","--","SI",346.60558800000007]
[null,null,30,300241,3797,"S. A. ARECO - LUJAN",66,49.799999237060547,"C",186.98903713531493,"2016-03-10T08:39:00","2016-03-10T15:40:00",7.0166666666627862,421,"P","0,000",10,131.26630406899108,"--","--","--","--","--","--","--","--","--","SI",131.26630406899108]
[null,null,31,300242,1437,"DOLORES - CHASCOMUS",132,90.230003356933594,"C",338.79561660461428,"2016-03-10T08:56:00","2016-03-10T17:16:00",8.3333333334303461,500,"P","0,000",10,282.21674863164372,"--","--","--","--","--","--","--","--","--","SI",282.21674863164372]
[null,null,32,300243,1421,"ARRECIFES - CAP. SARMIENTO",66,31.899999618530273,"C",119.77811856765747,"2016-03-10T09:06:00","2016-03-10T16:13:00",7.1166666666395031,427,"P","0,000",10,85.282020420172117,"--","--","--","--","--","--","--","--","--","SI",85.282020420172117]
[null,null,33,300245,1536,"CARLOS CASARES - 9 DE JULIO",66,46.799999237060547,"C",175.72463713531496,"2016-03-10T09:33:00","2016-03-10T15:09:00",5.5999999999185093,336,"P","0,000",10,98.405796795776368,"--","--","--","--","--","--","--","--","--","SI",98.405796795776368]
[null,null,34,300247,4075,"AZUL - CACHARI",132,55.700000762939453,"C",209.14236286468505,"2016-03-11T05:23:00","2016-03-11T09:29:00",4.0999999999185093,246,"F","0,000",10,"--","--",2091.4236286468504,6274.2708859405511,230.05659915115348,"--","--","--","--","--","SI",8595.7511137385554]
[null,null,35,300248,1536,"CARLOS CASARES - 9 DE JULIO",66,46.799999237060547,"C",175.72463713531496,"2016-03-11T08:20:00","2016-03-11T15:23:00",7.0500000001047738,423,"P","0,000",{"$f":"IF(I36=\"A\",$M$14,IF(I36=\"B\",$M$15,$M$16))","v":10},{"$f":"IF(O36=\"P\",ROUND(N36/60,2)*J36*Q36*0.01,\"--\")","v":123.88586918039707},{"$f":"IF(O36=\"RP\",ROUND(N36/60,2)*J36*Q36*0.01*P36/100,\"--\")","v":"--"},{"$f":"IF(O36=\"F\",J36*Q36,\"--\")","v":"--"},{"$f":"IF(AND(N36>10,O36=\"F\"),J36*Q36*IF(N36>180,3,ROUND((N36)/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(O36=\"F\",N36>180),(ROUND(N36/60,2)-3)*J36*Q36*0.1,\"--\")","v":"--"},{"$f":"IF(O36=\"R\",J36*Q36*P36/100,\"--\")","v":"--"},{"$f":"IF(AND(N36>10,O36=\"R\"),Q36*J36*P36/100*IF(N36>180,3,ROUND((N36)/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(O36=\"R\",N36>180),(ROUND(N36/60,2)-3)*J36*Q36*0.1*P36/100,\"--\")","v":"--"},{"$f":"IF(O36=\"RF\",ROUND(N36/60,2)*J36*Q36*0.1,\"--\")","v":"--"},{"$f":"IF(O36=\"RR\",ROUND(N36/60,2)*J36*Q36*0.1*P36/100,\"--\")","v":"--"},{"$f":"IF(F36=\"\",\"\",\"SI\")","v":"SI"},123.88586918039707]
[null,null,36,300250,1441,"PERGAMINO - ARRECIFES",66,43.8,"B",164.46024,"2016-03-11T08:51:00","2016-03-11T14:31:00",5.6666666666278616,340,"P","0,000",50,466.24478039999997,"--","--","--","--","--","--","--","--","--","SI",466.24478039999997]
[null,null,37,300251,2616,"PIGUE - GUATRACHE",132,102,"C",382.9896,"2016-03-11T08:56:00","2016-03-11T16:47:00",7.8500000000931323,471,"P","0,000",10,300.64683599999995,"--","--","--","--","--","--","--","--","--","SI",300.64683599999995]
[null,null,38,300254,1437,"DOLORES - CHASCOMUS",132,90.230003356933594,"C",338.79561660461428,"2016-03-11T09:40:00","2016-03-11T15:01:00",5.3499999999767169,321,"P","0,000",10,181.25565488346862,"--","--","--","--","--","--","--","--","--","SI",181.25565488346862]
[null,null,null,null,null,null,null,null,null,93.87,null,null,"","",null,{"$f":"IF(F40=\"\",\"\",\"--\")","v":""},10,"--","--","--","--","--","--","--","--","--","--",{"$f":"IF(F40=\"\",\"\",\"SI\")","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":3921.1843636077283},0,2091.4236286468504,6274.2708859405511,230.05659915115348,0,0,0,0,0,null,{"$f":"ROUND(SUM(AC19:AC41),2)","v":20709.330000000002}]

{"sheet":"LI-03 (3)","index":3,"n_rows":42,"n_cols":29,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'TOT-0316'!B2","v":"ANEXO IV 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-0316'!B14","v":"Desde el 01 al 31 de Marzo 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-0316'!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-0316'!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-0316'!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-03 (2)'!AC42","v":20709.330000000002}]
[]
[null,null,39,300258,1450,"OLAVARRIA - AZUL",132,51.400001525878906,"C",{"$f":"IF(G21=220,$G$14,IF(G21=132,$G$15,$G$16))*IF(H21>25,H21,25)/100","v":192.99672572937013},"2016-03-12T08:15:00","2016-03-12T15:41:00",{"$f":"IF(F21=\"\",\"\",(L21-K21)*24)","v":7.4333333332906477},{"$f":"IF(F21=\"\",\"\",ROUND((L21-K21)*24*60,0))","v":446},"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":143.39656721692199},{"$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":143.39656721692199}]
[null,null,40,300259,5684,"CORCEMAR  - TOYOTA",132,2.9,"C",93.87,"2016-03-12T08:23:00","2016-03-12T17:43:00",9.3333333331975155,560,"P","0,000",10,87.580710000000025,"--","--","--","--","--","--","--","--","--","SI",87.580710000000025]
[null,null,41,300260,1434,"9 DE JULIO - BRAGADO",66,60.939998626708984,"C",228.81750684356692,"2016-03-13T08:31:00","2016-03-13T17:11:00",8.6666666666278616,520,"P","0,000",10,198.38477843337253,"--","--","--","--","--","--","--","--","--","SI",198.38477843337253]
[null,null,42,300426,1439,"SAN CLEMENTE - DOLORES",132,102.6,"C",385.24248,"2016-03-14T10:10:00","2016-03-14T13:15:00",3.0833333334303461,185,"P","0,000",10,118.65468384,"--","--","--","--","--","--","--","--","--","SI",118.65468384]
[null,null,43,300427,1537,"CNEL. SUAREZ - PIGUE",132,47.6,"C",178.72848000000002,"2016-03-14T11:12:00","2016-03-14T17:20:00",6.1333333332440816,368,"P","0,000",10,109.56055823999999,"--","--","--","--","--","--","--","--","--","SI",109.56055823999999]
[null,null,44,300435,1537,"CNEL. SUAREZ - PIGUE",132,47.6,"C",178.72848000000002,"2016-03-15T08:09:00","2016-03-15T17:40:00",9.5166666666045785,571,"P","0,000",10,170.14951296000004,"--","--","--","--","--","--","--","--","--","SI",170.14951296000004]
[null,null,45,300436,1417,"MONTE - CHASCOMUS",132,114,"C",428.04720000000003,"2016-03-15T08:13:00","2016-03-15T15:15:00",7.033333333209157,422,"P","0,000",10,300.91718160000005,"--","--","--","--","--","--","--","--","--","SI",300.91718160000005]
[null,null,46,300441,1452,"LOMA NEGRA - OLAVARRIA",132,51.509998321533203,"C",193.40974169769288,"2016-03-15T09:28:00","2016-03-15T14:10:00",4.7000000001280569,282,"P","0,000",10,90.90257859791565,"--","--","--","--","--","--","--","--","--","SI",90.90257859791565]
[null,null,47,300444,1537,"CNEL. SUAREZ - PIGUE",132,47.6,"C",178.72848000000002,"2016-03-16T08:14:00","2016-03-16T17:27:00",9.2166666666744277,553,"P","0,000",10,164.78765856000001,"--","--","--","--","--","--","--","--","--","SI",164.78765856000001]
[null,null,48,300445,1417,"MONTE - CHASCOMUS",132,114,"C",428.04720000000003,"2016-03-16T08:32:00","2016-03-16T15:37:00",7.0833333331975155,425,"P","0,000",10,303.05741760000001,"--","--","--","--","--","--","--","--","--","SI",303.05741760000001]
[null,null,49,300448,1452,"LOMA NEGRA - OLAVARRIA",132,51.509998321533203,"C",193.40974169769288,"2016-03-16T09:36:00","2016-03-16T15:07:00",5.5166666666627862,331,"P","0,000",10,106.76217741712647,"--","--","--","--","--","--","--","--","--","SI",106.76217741712647]
[null,null,50,300454,1537,"CNEL. SUAREZ - PIGUE",132,47.6,"C",178.72848000000002,"2016-03-17T08:20:00","2016-03-17T17:17:00",8.9500000000116415,537,"P","0,000",10,159.96198960000001,"--","--","--","--","--","--","--","--","--","SI",159.96198960000001]
[null,null,51,300455,1417,"MONTE - CHASCOMUS",132,114,"C",428.04720000000003,"2016-03-17T08:27:00","2016-03-17T15:33:00",7.1000000000931323,426,"P","0,000",10,303.91351199999997,"--","--","--","--","--","--","--","--","--","SI",303.91351199999997]
[null,null,52,300459,1452,"LOMA NEGRA - OLAVARRIA",132,51.509998321533203,"C",193.40974169769288,"2016-03-17T09:30:00","2016-03-17T17:22:00",7.8666666666395031,472,"P","0,000",10,152.2134667160843,"--","--","--","--","--","--","--","--","--","SI",152.2134667160843]
[null,null,53,300460,1438,"CHASCOMUS - VERONICA",132,70.800003051757813,"B",265.83985145874021,"2016-03-18T02:06:00","2016-03-18T21:57:00",19.849999999918509,1191,"F","0,000",50,"--","--",13291.992572937012,39875.977718811031,{"$f":"IF(AND(O35=\"F\",N35>180),(ROUND(N35/60,2)-3)*J35*Q35*0.1,\"--\")","v":22397.007485398863},"--","--","--","--","--","SI",75564.977777146909]
[]
[null,null,55,300463,1537,"CNEL. SUAREZ - PIGUE",132,47.6,"C",178.72848000000002,"2016-03-18T08:25:00","2016-03-18T14:15:00",5.8333333333139308,350,"P","0,000",10,104.19870384000002,"--","--","--","--","--","--","--","--","--","SI",104.19870384000002]
[null,null,56,300464,1536,"CARLOS CASARES - 9 DE JULIO",66,46.799999237060547,"C",175.72463713531496,"2016-03-18T08:48:00","2016-03-18T11:37:00",2.816666666592937,169,"P","0,000",10,49.554347672158819,"--","--","--","--","--","--","--","--","--","SI",49.554347672158819]
[null,null,57,300467,1529,"MIRAMAR - NECOCHEA",132,103.29000091552734,"A",387.8332954376221,"2016-03-18T09:40:00","2016-03-18T18:45:00",9.0833333332557231,545,"P","0,000",150,5282.2894838604125,"--","--","--","--","--","--","--","--","--","SI",5282.2894838604125]
[null,null,null,null,null,null,null,null,null,93.87,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R40=\"\",\"\",\"--\")","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":7846.2853281539919},0,13291.992572937012,39875.977718811031,22397.007485398863,0,0,0,0,0,null,{"$f":"ROUND(SUM(AC19:AC41),2)","v":104120.59}]

{"sheet":"LI-03 (4)","index":4,"n_rows":42,"n_cols":29,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'TOT-0316'!B2","v":"ANEXO IV 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-0316'!B14","v":"Desde el 01 al 31 de Marzo 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-0316'!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-0316'!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-0316'!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-03 (3)'!AC42","v":104120.59}]
[]
[null,null,58,300472,1529,"MIRAMAR - NECOCHEA",132,103.29000091552734,"A",{"$f":"IF(G21=220,$G$14,IF(G21=132,$G$15,$G$16))*IF(H21>25,H21,25)/100","v":387.8332954376221},"2016-03-19T08:14:00","2016-03-19T18:13:00",{"$f":"IF(F21=\"\",\"\",(L21-K21)*24)","v":9.9833333333954215},{"$f":"IF(F21=\"\",\"\",ROUND((L21-K21)*24*60,0))","v":599},"P","0,000",{"$f":"IF(I21=\"A\",$M$14,IF(I21=\"B\",$M$15,$M$16))","v":150},{"$f":"IF(O21=\"P\",ROUND(N21/60,2)*J21*Q21*0.01,\"--\")","v":5805.8644327012034},{"$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":5805.8644327012034}]
[null,null,59,300474,1529,"MIRAMAR - NECOCHEA",132,103.29000091552734,"A",387.8332954376221,"2016-03-20T08:11:00","2016-03-20T17:54:00",9.7166666667326353,583,"P","0,000",150,5654.6094474805313,"--","--","--","--","--","--","--","--","--","SI",5654.6094474805313]
[null,null,60,300475,1530,"PEHUAJO - CARLOS CASARES",66,53.1,"C",199.37988000000001,"2016-03-20T08:24:00","2016-03-20T18:42:00",10.300000000046566,618,"P","0,000",10,205.36127640000007,"--","--","--","--","--","--","--","--","--","SI",205.36127640000007]
[null,null,61,300638,1529,"MIRAMAR - NECOCHEA",132,103.29000091552734,"A",387.8332954376221,"2016-03-21T08:17:00","2016-03-21T17:53:00",9.6000000000349246,576,"P","0,000",150,5584.7994543017576,"--","--","--","--","--","--","--","--","--","SI",5584.7994543017576]
[null,null,62,300639,1382,"URBANA SAN NICOLÁS - SAN NICOLAS",132,6.5,"C",93.87,"2016-03-21T10:01:00","2016-03-21T15:05:00",5.066666666592937,304,"P","0,000",10,47.592090000000006,"--","--","--","--","--","--","--","--","--","SI",47.592090000000006]
[null,null,63,300640,4328,"MAR DE AJO - MAR DEL TUYU - LAS TONINAS",132,29.569999694824219,"C",111.02943485412598,"2016-03-21T10:22:00","2016-03-21T16:21:00",5.9833333334536292,359,"P","0,000",10,66.395602042767337,"--","--","--","--","--","--","--","--","--","SI",66.395602042767337]
[null,null,64,300643,4328,"MAR DE AJO - MAR DEL TUYU - LAS TONINAS",132,29.569999694824219,"C",111.02943485412598,"2016-03-22T08:33:00","2016-03-22T16:59:00",8.433333333407063,506,"P","0,000",10,93.597813582028195,"--","--","--","--","--","--","--","--","--","SI",93.597813582028195]
[null,null,65,300644,1529,"MIRAMAR - NECOCHEA",132,103.29000091552734,"A",387.8332954376221,"2016-03-22T08:36:00","2016-03-22T18:49:00",10.216666666790843,613,"P","0,000",150,5945.4844190587464,"--","--","--","--","--","--","--","--","--","SI",5945.4844190587464]
[null,null,66,300647,1382,"URBANA SAN NICOLÁS - SAN NICOLAS",132,6.5,"C",93.87,"2016-03-22T09:13:00","2016-03-22T16:09:00",6.933333333407063,416,"P","0,000",10,65.051909999999992,"--","--","--","--","--","--","--","--","--","SI",65.051909999999992]
[null,null,67,300653,4095,"LAS FLORES - ROSAS",132,28.399999618530273,"C",106.63631856765747,"2016-03-22T17:24:00","2016-03-22T17:45:00",0.35000000009313226,21,"P","0,000",10,3.7322711498680117,"--","--","--","--","--","--","--","--","--","SI",3.7322711498680117]
[null,null,68,300657,1529,"MIRAMAR - NECOCHEA",132,103.29000091552734,"A",387.8332954376221,"2016-03-23T08:37:00","2016-03-23T17:05:00",8.4666666666744277,508,"P","0,000",150,4927.4220185349895,"--","--","--","--","--","--","--","--","--","SI",4927.4220185349895]
[null,null,69,300658,1382,"URBANA SAN NICOLÁS - SAN NICOLAS",132,6.5,"C",93.87,"2016-03-23T08:47:00","2016-03-23T14:51:00",6.0666666667093523,364,"P","0,000",10,56.979090000000006,"--","--","--","--","--","--","--","--","--","SI",56.979090000000006]
[null,null,70,300659,4328,"MAR DE AJO - MAR DEL TUYU - LAS TONINAS",132,29.569999694824219,"C",111.02943485412598,"2016-03-23T09:04:00","2016-03-23T17:37:00",8.5499999999301508,513,"P","0,000",10,94.930166800277732,"--","--","--","--","--","--","--","--","--","SI",94.930166800277732]
[null,null,71,300660,1434,"9 DE JULIO - BRAGADO",66,60.94,"C",228.81751199999999,"2016-03-24T07:37:00","2016-03-24T09:08:00",1.5166666667209938,91,"P","0,000",10,34.780261824,"--","--","--","--","--","--","--","--","--","SI",34.780261824]
[null,null,72,300662,4933,"ZARATE - LAS PALMAS",132,8.6999999999999993,"C",93.87,"2016-03-24T08:14:00","2016-03-24T18:00:00",9.7666666667209938,586,"P","0,000",10,91.71099000000001,"--","--","--","--","--","--","--","--","--","SI",91.71099000000001]
[null,null,73,300667,1409,"CHIVILCOY - MERCEDES B.A.",132,69.099998474121094,"C",259.45667427062989,"2016-03-26T07:58:00","2016-03-26T10:00:00",2.0333333333255723,122,"P","0,000",10,52.669704876937871,"--","--","--","--","--","--","--","--","--","SI",52.669704876937871]
[null,null,74,300668,1410,"MERCEDES B.A. - LUJAN",132,41.3,"B",155.07324,"2016-03-26T10:09:00","2016-03-26T13:04:00",2.9166666665696539,175,"P","0,000",50,226.40693039999999,"--","--","--","--","--","--","--","--","--","SI",226.40693039999999]
[null,null,75,300669,1403,"BRAGADO - HENDERSON",220,177,"A",{"$f":"IF(G38=220,$G$14,IF(G38=132,$G$15,$G$16))*IF(H38>25,H38,25)/100","v":695.50380000000007},"2016-03-27T02:35:00","2016-03-27T13:34:00",10.983333333337214,659,"F","0,000",{"$f":"IF(I38=\"A\",$M$14,IF(I38=\"B\",$M$15,$M$16))","v":150},{"$f":"IF(O38=\"P\",ROUND(N38/60,2)*J38*Q38*0.01,\"--\")","v":"--"},{"$f":"IF(O38=\"RP\",ROUND(N38/60,2)*J38*Q38*0.01*P38/100,\"--\")","v":"--"},{"$f":"IF(O38=\"F\",J38*Q38,\"--\")","v":104325.57},{"$f":"IF(AND(N38>10,O38=\"F\"),J38*Q38*IF(N38>180,3,ROUND((N38)/60,2)),\"--\")","v":312976.71000000002},{"$f":"IF(AND(O38=\"F\",N38>180),(ROUND(N38/60,2)-3)*J38*Q38*0.1,\"--\")","v":83251.804860000018},"--","--","--","--","--","SI",{"$f":"IF(F38=\"\",\"\",SUM(R38:AA38)*IF(AB38=\"SI\",1,2))","v":500554.08486000006}]
[null,null,76,300670,1406,"BRAGADO - CHACABUCO",132,60.6,"B",227.54088000000004,"2016-03-27T08:20:00","2016-03-27T11:50:00",3.5000000000582077,210,"P","0,000",50,398.19654000000008,"--","--","--","--","--","--","--","--","--","SI",398.19654000000008]
[null,null,null,null,null,null,null,null,null,93.87,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R40=\"\",\"\",\"--\")","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":29355.584419153107},0,104325.57,312976.71000000002,83251.804860000018,0,0,0,0,0,null,{"$f":"ROUND(SUM(AC19:AC41),2)","v":634030.26}]

{"sheet":"LI-03 (5)","index":5,"n_rows":42,"n_cols":29,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'TOT-0316'!B2","v":"ANEXO IV 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-0316'!B14","v":"Desde el 01 al 31 de Marzo 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-0316'!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-0316'!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-0316'!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-03 (4)'!AC42","v":634030.26}]
[]
[null,null,77,300866,1456,"LAPRIDA - PRINGLES",132,71.5,"C",{"$f":"IF(G21=220,$G$14,IF(G21=132,$G$15,$G$16))*IF(H21>25,H21,25)/100","v":268.46820000000002},"2016-03-28T11:10:00","2016-03-28T17:10:00",{"$f":"IF(F21=\"\",\"\",(L21-K21)*24)","v":6},{"$f":"IF(F21=\"\",\"\",ROUND((L21-K21)*24*60,0))","v":360},"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":161.08092000000002},{"$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":161.08092000000002}]
[null,null,78,300872,4293,"S. CLEMENTE - LAS TONINAS",132,14.6,"B",93.87,"2016-03-29T09:07:00","2016-03-29T15:22:00",6.2499999999417923,375,"P","0,000",50,293.34375,"--","--","--","--","--","--","--","--","--","SI",293.34375]
[null,null,79,300873,1456,"LAPRIDA - PRINGLES",132,71.5,"C",268.46820000000002,"2016-03-29T09:10:00","2016-03-29T18:02:00",8.8666666665812954,532,"P","0,000",10,238.1312934,"--","--","--","--","--","--","--","--","--","SI",238.1312934]
[null,null,80,300875,1409,"CHIVILCOY - MERCEDES B.A.",132,69.099998474121094,"C",259.45667427062989,"2016-03-29T09:15:00","2016-03-29T14:30:00",5.25,315,"P","0,000",10,136.21475399208069,"--","--","--","--","--","--","--","--","--","SI",136.21475399208069]
[null,null,81,300878,2713,"VILLA LIA \"T\" - VILLA LÍA",132,8,"C",93.87,"2016-03-29T10:03:00","2016-03-29T15:05:00",5.0333333333255723,302,"P","0,000",10,47.216610000000003,"--","--","--","--","--","--","--","--","--","SI",47.216610000000003]
[null,null,82,300880,5434,"B. BLANCA - TORNQUIST - PIGUE",132,132.30000000000001,"C",496.76004000000006,"2016-03-29T13:47:00","2016-03-29T15:56:00",2.1500000000232831,129,"F","0,000",10,"--","--",4967.6004000000003,10680.34086,"--","--","--","--","--","--","SI",15647.94126]
[null,null,83,300887,4293,"S. CLEMENTE - LAS TONINAS",132,14.6,"B",93.87,"2016-03-30T08:24:00","2016-03-30T16:30:00",8.1000000000349246,486,"P","0,000",50,380.17349999999999,"--","--","--","--","--","--","--","--","--","SI",380.17349999999999]
[null,null,84,300888,1456,"LAPRIDA - PRINGLES",132,71.5,"C",268.46820000000002,"2016-03-30T08:52:00","2016-03-30T17:30:00",8.6333333333604969,518,"P","0,000",10,231.68805660000001,"--","--","--","--","--","--","--","--","--","SI",231.68805660000001]
[null,null,85,300892,1409,"CHIVILCOY - MERCEDES B.A.",132,69.099998474121094,"C",259.45667427062989,"2016-03-30T09:12:00","2016-03-30T14:37:00",5.4166666666860692,325,"P","0,000",10,140.62551745468139,"--","--","--","--","--","--","--","--","--","SI",140.62551745468139]
[null,null,86,300894,4293,"S. CLEMENTE - LAS TONINAS",132,14.6,"B",93.87,"2016-03-31T08:19:00","2016-03-31T16:42:00",8.3833333332440816,503,"P","0,000",50,393.31530000000009,"--","--","--","--","--","--","--","--","--","SI",393.31530000000009]
[null,null,87,300895,1456,"LAPRIDA - PRINGLES",132,71.5,"C",268.46820000000002,"2016-03-31T08:32:00","2016-03-31T17:27:00",8.9166666665696539,535,"P","0,000",10,239.47363440000004,"--","--","--","--","--","--","--","--","--","SI",239.47363440000004]
[null,null,88,300898,1519,"TANDIL - NECOCHEA",132,149.19999694824219,"C",560.21614854125983,"2016-03-31T09:07:00","2016-03-31T17:39:00",8.53333333338378,512,"P","0,000",10,477.86437470569467,"--","--","--","--","--","--","--","--","--","SI",477.86437470569467]
[null,null,null,null,null,null,null,null,null,93.87,null,null,"","",null,null,10,"--","--","--","--","--","--","--","--","--","--",{"$f":"IF(R33=\"\",\"\",\"--\")","v":"--"},""]
[null,null,null,null,null,null,null,null,null,93.87,null,null,"","",null,null,10,"--","--","--","--","--","--","--","--","--","--","--",""]
[null,null,null,null,null,null,null,null,null,93.87,null,null,"","",null,null,10,"--","--","--","--","--","--","--","--","--","--","--",""]
[null,null,null,null,null,null,null,null,null,93.87,null,null,"","",null,null,10,"--","--","--","--","--","--","--","--","--","--","--",""]
[null,null,null,null,null,null,null,null,null,93.87,null,null,"","",null,null,10,"--","--","--","--","--","--","--","--","--","--","--",""]
[null,null,null,null,null,null,null,null,null,93.87,null,null,"","",null,null,10,"--","--","--","--","--","--","--","--","--","--","--",""]
[null,null,null,null,null,null,null,null,null,93.87,null,null,"","",null,null,10,"--","--","--","--","--","--","--","--","--","--","--",""]
[null,null,null,null,null,null,null,null,null,93.87,null,null,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[null,null,"(²)","P - PROGRAMADA  ; F - FORZADA",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R19:R41)","v":2739.1277105524568},0,4967.6004000000003,10680.34086,0,0,0,0,0,0,null,{"$f":"ROUND(SUM(AC19:AC41),2)","v":652417.32999999996}]

{"sheet":"T-03 (1)","index":6,"n_rows":42,"n_cols":29,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'TOT-0316'!B2","v":"ANEXO IV 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-0316'!B14","v":"Desde el 01 al 31 de Marzo 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-0316'!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,89,299942,2296,"OLAVARRIA VIEJA","T1OA",30,"132/33/13,2",{"$f":"H22*$I$16","v":39.300000000000004},"2016-03-01T09:18:00","2016-03-01T14:59:00",{"$f":"IF(F22=\"\",\"\",(L22-K22)*24)","v":5.6833333333488554},{"$f":"IF(F22=\"\",\"\",ROUND((L22-K22)*24*60,0))","v":341},"P",{"$f":"IF(F22=\"\",\"\",IF(OR(O22=\"P\",O22=\"RP\"),\"--\",\"NO\"))","v":"--"},{"$f":"IF(F22=\"\",\"\",\"--\")","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":133.93440000000001},{"$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":"--"},{"$f":"IF(F22=\"\",\"\",\"SI\")","v":"SI"},{"$f":"IF(F22=\"\",\"\",SUM(T22:AA22)*IF(AB22=\"SI\",1,2)*IF(AND(Q22<>\"0,000\",O22=\"RF\"),Q22/100,1))","v":133.93440000000001}]
[null,null,90,299948,2296,"OLAVARRIA VIEJA","T1OA",30,"132/33/13,2",39.300000000000004,"2016-03-02T09:20:00","2016-03-02T14:30:00",5.1666666665696539,310,"P","--","--",{"$f":"IF(F23=\"\",\"\",\"NO\")","v":"NO"},0.60000000000000009,121.90860000000002,"--","--","--","--","--","--","--","SI",121.90860000000002]
[null,null,91,299953,4638,"PUNTA ALTA","TRAFO 1",15,"132/33/13,2",19.650000000000002,"2016-03-03T08:59:00","2016-03-11T16:08:00",199.15000000008149,11949,"P","--","--","NO",0.60000000000000009,2347.9785000000006,"--","--","--","--","--","--","--","SI",2347.9785000000006]
[null,null,92,299954,2296,"OLAVARRIA VIEJA","T1OA",30,"132/33/13,2",39.300000000000004,"2016-03-03T09:11:00","2016-03-03T14:54:00",5.71666666661622,343,"P","--","--","NO",0.60000000000000009,134.87760000000003,"--","--","--","--","--","--","--","SI",134.87760000000003]
[null,null,93,299961,4585,"JUNIN","TRAFO 2",30,"132/33/13,2",39.300000000000004,"2016-03-04T09:14:00","2016-03-04T12:40:00",3.4333333333488554,206,"P","--","--","NO",0.60000000000000009,80.879400000000018,"--","--","--","--","--","--","--","SI",80.879400000000018]
[null,null,94,299962,2374,"BARKER","Trafo 1",15,"132/33/13,2",19.650000000000002,"2016-03-04T16:17:00","2016-03-04T17:28:00",1.1833333333488554,71,"F","NO","--","SI",60,"--","--",1179.0000000000002,1391.2200000000003,"--","--","--","--","SI",2570.2200000000003]
[null,null,95,299963,5240,"BARKER","TRAFO 2",40,"132/33/13,2",52.400000000000006,"2016-03-04T16:17:00","2016-03-04T18:44:00",2.4499999999534339,147,"F","NO","--","SI",60,"--","--",3144.0000000000005,7702.800000000002,"--","--","--","--","SI",10846.800000000003]
[null,null,96,299973,2465,"MAR DEL TUYU","TRAFO 1",20,"132/33/13,2",26.200000000000003,"2016-03-05T09:46:00","2016-03-05T12:59:00",3.2166666666744277,193,"P","--","--","NO",0.60000000000000009,50.618400000000015,"--","--","--","--","--","--","--","SI",50.618400000000015]
[null,null,97,299976,5302,"AZUL","TRAFO 1",30,"132/33/13,2",39.300000000000004,"2016-03-06T08:57:00","2016-03-06T16:09:00",7.2000000000698492,432,"P","--","--","NO",0.60000000000000009,169.77600000000004,"--","--","--","--","--","--","--","SI",169.77600000000004]
[null,null,98,300223,2233,"SAN ANTONIO DE ARECO","TRAFO 1",5,"66/13,2",6.5500000000000007,"2016-03-08T09:16:00","2016-03-08T14:09:00",4.8833333333604969,293,"P","--","--","NO",0.60000000000000009,19.178400000000003,"--","--","--","--","--","--","--","SI",19.178400000000003]
[null,null,99,300224,2234,"SAN ANTONIO DE ARECO","TRAFO 2",5,"66/13,2",6.5500000000000007,"2016-03-08T09:17:00","2016-03-08T14:08:00",4.8499999999185093,291,"P","--","--","NO",0.60000000000000009,19.060500000000005,"--","--","--","--","--","--","--","SI",19.060500000000005]
[null,null,100,300227,2381,"BARKER","TRAFO 4",1.5,"33/13,2",1.9650000000000001,"2016-03-08T10:46:00","2016-03-08T14:07:00",3.3499999999185093,201,"P","--","--","NO",0.60000000000000009,3.949650000000001,"--","--","--","--","--","--","--","SI",3.949650000000001]
[null,null,101,300233,2374,"BARKER","TRAFO1",15,"132/33/13,2",19.650000000000002,"2016-03-09T09:48:00","2016-03-09T16:41:00",6.8833333334187046,413,"P","--","--","NO",0.60000000000000009,81.115200000000016,"--","--","--","--","--","--","--","SI",81.115200000000016]
[null,null,102,300235,2297,"OLAVARRIA VIEJA","TRAFO 2",30,"132/33/13,2",39.300000000000004,"2016-03-09T09:59:00","2016-03-09T10:37:00",0.63333333330228925,38,"P","--","--","NO",0.60000000000000009,14.855400000000003,"--","--","--","--","--","--","--","SI",14.855400000000003]
[null,null,103,300236,2381,"BARKER","TRAFO 4",1.5,"33/13,2",1.9650000000000001,"2016-03-09T11:30:00","2016-03-09T16:23:00",4.8833333333604969,293,"P","--","--","NO",0.60000000000000009,5.7535200000000009,"--","--","--","--","--","--","--","SI",5.7535200000000009]
[null,null,104,300244,2374,"BARKER","TRAFO 1",15,"132/33/13,2",19.650000000000002,"2016-03-10T09:12:00","2016-03-10T17:14:00",8.0333333333255723,482,"P","--","--","NO",0.60000000000000009,94.673700000000011,"--","--","--","--","--","--","--","SI",94.673700000000011]
[null,null,105,300246,4833,"LOS CHAÑARES","TRAFO 2",30,"132/33/13,2",39.300000000000004,"2016-03-10T09:54:00","2016-03-10T18:14:00",8.3333333334303461,500,"P","--","--","NO",0.60000000000000009,196.42140000000003,"--","--","--","--","--","--","--","SI",196.42140000000003]
[null,null,106,300253,2431,"VILLA GESELL","TRAFO 3",40,"132/13,2",52.400000000000006,"2016-03-11T09:39:00","2016-03-11T16:36:00",6.9499999999534339,417,"P","--","--","NO",0.60000000000000009,218.50800000000007,"--","--","--","--","--","--","--","SI",218.50800000000007]
[null,null,107,300255,4833,"LOS CHAÑARES","TRAFO 2",30,"132/33/13,2",39.300000000000004,"2016-03-11T09:45:00","2016-03-11T14:27:00",4.6999999999534339,282,"P","--",{"$f":"IF(F40=\"\",\"\",\"--\")","v":"--"},"NO",0.60000000000000009,110.82600000000004,"--","--","--","--","--","--","--","SI",110.82600000000004]
[]
[null,null,"(²)"," P - PROGRAMADA  ; F - FORZADA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T20:T41)","v":3804.3146700000007},{"$f":"SUM(U20:U41)","v":0},{"$f":"SUM(V20:V41)","v":4323.0000000000009},{"$f":"SUM(W22:W41)","v":9094.0200000000023},{"$f":"SUM(X20:X41)","v":0},{"$f":"SUM(Y22:Y41)","v":0},{"$f":"SUM(Z20:Z41)","v":0},{"$f":"SUM(AA22:AA41)","v":0},null,{"$f":"ROUND(SUM(AC20:AC41),2)","v":17221.330000000002}]

{"sheet":"T-03 (2)","index":7,"n_rows":42,"n_cols":29,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'TOT-0316'!B2","v":"ANEXO IV 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-0316'!B14","v":"Desde el 01 al 31 de Marzo 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-0316'!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-03 (1)'!AC42","v":17221.330000000002}]
[]
[null,null,108,300261,5424,"LUJAN","TRAFO 2",40,"132/33/13,2",{"$f":"H22*$I$16","v":52.400000000000006},"2016-03-13T10:33:00","2016-03-13T12:01:00",{"$f":"IF(F22=\"\",\"\",(L22-K22)*24)","v":1.4666666667326353},{"$f":"IF(F22=\"\",\"\",ROUND((L22-K22)*24*60,0))","v":88},"P",{"$f":"IF(F22=\"\",\"\",IF(OR(O22=\"P\",O22=\"RP\"),\"--\",\"NO\"))","v":"--"},{"$f":"IF(F22=\"\",\"\",\"--\")","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":46.216800000000013},{"$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":"--"},{"$f":"IF(F22=\"\",\"\",\"SI\")","v":"SI"},{"$f":"IF(F22=\"\",\"\",SUM(T22:AA22)*IF(AB22=\"SI\",1,2)*IF(AND(Q22<>\"0,000\",O22=\"RF\"),Q22/100,1))","v":46.216800000000013}]
[null,null,109,300424,2233,"SAN ANTONIO DE ARECO","TRAFO 1",5,"66/13,2",6.5500000000000007,"2016-03-14T09:45:00","2016-03-14T14:50:00",5.0833333333139308,305,"P","--","--",{"$f":"IF(F23=\"\",\"\",\"NO\")","v":"NO"},0.60000000000000009,19.964400000000005,"--","--","--","--","--","--","--","SI",19.964400000000005]
[null,null,110,300425,2234,"SAN ANTONIO DE ARECO","TRAFO 2",5,"66/13,2",6.5500000000000007,"2016-03-14T09:45:00","2016-03-14T14:51:00",5.1000000000349246,306,"P","--","--","NO",0.60000000000000009,20.043000000000003,"--","--","--","--","--","--","--","SI",20.043000000000003]
[null,null,111,300428,3606,"BALCARCE","TRAFO 2",30,"132/33/13,2",39.300000000000004,"2016-03-14T15:00:00","2016-03-14T16:13:00",1.21666666661622,73,"F","NO","--","NO",6,"--","--",235.8,287.67599999999999,"--","--","--","--","SI",523.476]
[null,null,112,300439,2233,"SAN ANTONIO DE ARECO","TRAFO 1",5,"66/13,2",6.5500000000000007,"2016-03-15T09:00:00","2016-03-15T14:36:00",5.5999999999185093,336,"P","--","--","NO",0.60000000000000009,22.008000000000006,"--","--","--","--","--","--","--","SI",22.008000000000006]
[null,null,113,300440,2234,"SAN ANTONIO DE ARECO","TRAFO 2",5,"66/13,2",6.5500000000000007,"2016-03-15T09:00:00","2016-03-15T14:37:00",5.6166666666395031,337,"P","--","--","NO",0.60000000000000009,22.086600000000008,"--","--","--","--","--","--","--","SI",22.086600000000008]
[null,null,114,300446,2233,"SAN ANTONIO DE ARECO","TRAFO 1",5,"66/13,2",6.5500000000000007,"2016-03-16T09:19:00","2016-03-16T14:46:00",5.4499999999534339,327,"P","--","--","NO",0.60000000000000009,21.418500000000005,"--","--","--","--","--","--","--","SI",21.418500000000005]
[null,null,115,300447,2234,"SAN ANTONIO DE ARECO","TRAFO 2",5,"66/13,2",6.5500000000000007,"2016-03-16T09:19:00","2016-03-16T14:46:00",5.4499999999534339,327,"P","--","--","NO",0.60000000000000009,21.418500000000005,"--","--","--","--","--","--","--","SI",21.418500000000005]
[null,null,116,300466,2431,"VILLA GESELL","TRAFO 3",40,"132/13,2",52.400000000000006,"2016-03-18T09:32:00","2016-03-18T10:53:00",1.3500000000349246,81,"P","--","--","NO",0.60000000000000009,{"$f":"IF(O30=\"P\",J30*S30*ROUND(N30/60,2),\"--\")","v":42.444000000000017},{"$f":"IF(O30=\"RP\",J30*S30*ROUND(N30/60,2)*Q30/100,\"--\")","v":"--"},{"$f":"IF(AND(O30=\"F\",P30=\"NO\"),J30*S30,\"--\")","v":"--"},{"$f":"IF(O30=\"F\",J30*S30*ROUND(N30/60,2),\"--\")","v":"--"},{"$f":"IF(AND(O30=\"R\",P30=\"NO\"),J30*S30*Q30/100,\"--\")","v":"--"},{"$f":"IF(O30=\"R\",J30*S30*ROUND(N30/60,2)*Q30/100,\"--\")","v":"--"},{"$f":"IF(O30=\"RF\",J30*S30*ROUND(N30/60,2),\"--\")","v":"--"},{"$f":"IF(O30=\"RR\",J30*S30*ROUND(N30/60,2)*Q30/100,\"--\")","v":"--"},{"$f":"IF(F30=\"\",\"\",\"SI\")","v":"SI"},{"$f":"IF(F30=\"\",\"\",SUM(T30:AA30)*IF(AB30=\"SI\",1,2)*IF(AND(Q30<>\"0,000\",O30=\"RF\"),Q30/100,1))","v":42.444000000000017}]
[null,null,117,300470,5758,"PUNTA ALTA","TRAFO 1",20,"132/22/13,2",26.200000000000003,"2016-03-18T10:14:00","2016-03-18T18:59:00",8.7500000000582077,525,"P","--","--","NO",0.60000000000000009,137.55000000000004,"--","--","--","--","--","--","--","SI",137.55000000000004]
[null,null,118,300473,2187,"CARLOS CASARES","TRAFO 2",5,"66/13,2",6.5500000000000007,"2016-03-20T08:03:00","2016-03-20T18:51:00",10.799999999930151,648,"P","--","--","NO",0.60000000000000009,42.444000000000017,"--","--","--","--","--","--","--","SI",42.444000000000017]
[null,null,119,300476,2136,"ARRECIFES","TRAFO1",10,"66/13,2",13.100000000000001,"2016-03-20T08:45:00","2016-03-20T16:16:00",7.5166666665463708,451,"P","--","--","NO",0.60000000000000009,59.107200000000013,"--","--","--","--","--","--","--","SI",59.107200000000013]
[null,null,120,300646,2465,"MAR DEL TUYU","TRAFO1",20,"132/33/13,2",26.200000000000003,"2016-03-22T08:52:00","2016-03-23T17:53:00",33.016666666720994,1981,"P","--","--","NO",0.60000000000000009,519.0744000000002,"--","--","--","--","--","--","--","SI",519.0744000000002]
[null,null,121,300648,2258,"HENDERSON","TRAFO 4",40,"220/132/13,2",52.400000000000006,"2016-03-22T09:39:00","2016-03-22T14:37:00",4.96666666661622,298,"P","--","--","NO",0.60000000000000009,156.25680000000003,"--","--","--","--","--","--","--","SI",156.25680000000003]
[null,null,122,300649,2070,"ZARATE","TRAFO 1",15,"132/33/132,2",19.650000000000002,"2016-03-22T09:39:00","2016-03-22T14:37:00",4.96666666661622,298,"P","--","--","NO",0.60000000000000009,58.596300000000014,"--","--","--","--","--","--","--","SI",58.596300000000014]
[null,null,123,300650,2138,"ARRECIFES","TRAFO 2",5,"66/33",6.5500000000000007,"2016-03-22T10:00:00","2016-03-22T15:19:00",5.3166666667093523,319,"P","--","--","NO",0.60000000000000009,20.907600000000006,"--","--","--","--","--","--","--","SI",20.907600000000006]
[null,null,124,300654,2070,"ZARATE","TRAFO 1",15,"132/33/13,2",19.650000000000002,"2016-03-23T08:03:00","2016-03-23T14:16:00",6.2166666666744277,373,"P","--","--","NO",0.60000000000000009,73.333800000000011,"--","--","--","--","--","--","--","SI",73.333800000000011]
[null,null,125,300656,2258,"HENDERSON","TRAFO 4",40,"220/132/13,2",52.400000000000006,"2016-03-23T08:28:00","2016-03-23T14:33:00",6.0833333332557231,365,"P","--","--","NO",0.60000000000000009,191.15520000000006,"--","--","--","--","--","--","--","SI",191.15520000000006]
[null,null,126,300661,2172,"BRAGADO","TRAFO 2",150,"220/132/13,2",196.5,"2016-03-24T07:53:00","2016-03-24T15:40:00",7.78333333338378,467,"P","--",{"$f":"IF(F40=\"\",\"\",\"--\")","v":"--"},"NO",0.60000000000000009,917.26200000000017,"--","--","--","--","--","--","--","SI",917.26200000000017]
[]
[null,null,"(²)"," P - PROGRAMADA  ; F - FORZADA ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T20:T41)","v":2391.2871000000005},{"$f":"SUM(U20:U41)","v":0},{"$f":"SUM(V20:V41)","v":235.8},{"$f":"SUM(W22:W41)","v":287.67599999999999},{"$f":"SUM(X20:X41)","v":0},{"$f":"SUM(Y22:Y41)","v":0},{"$f":"SUM(Z20:Z41)","v":0},{"$f":"SUM(AA22:AA41)","v":0},null,{"$f":"ROUND(SUM(AC20:AC41),2)","v":20136.09}]

{"sheet":"T-03 (3)","index":8,"n_rows":43,"n_cols":29,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'TOT-0316'!B2","v":"ANEXO IV 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-0316'!B14","v":"Desde el 01 al 31 de Marzo 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-0316'!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-03 (2)'!AC42","v":20136.09}]
[]
[null,null,127,300663,2172,"BRAGADO","TRAFO 2",150,"220/132/13,2",{"$f":"H22*$I$16","v":196.5},"2016-03-25T08:41:00","2016-03-25T15:21:00",{"$f":"IF(F22=\"\",\"\",(L22-K22)*24)","v":6.6666666665696539},{"$f":"IF(F22=\"\",\"\",ROUND((L22-K22)*24*60,0))","v":400},"P",{"$f":"IF(F22=\"\",\"\",IF(OR(O22=\"P\",O22=\"RP\"),\"--\",\"NO\"))","v":"--"},{"$f":"IF(F22=\"\",\"\",\"--\")","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":786.39300000000014},{"$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":"--"},{"$f":"IF(F22=\"\",\"\",\"SI\")","v":"SI"},{"$f":"IF(F22=\"\",\"\",SUM(T22:AA22)*IF(AB22=\"SI\",1,2)*IF(AND(Q22<>\"0,000\",O22=\"RF\"),Q22/100,1))","v":786.39300000000014}]
[]
[null,null,129,300863,2095,"SAN NICOLAS URBANA","TRAFO 1",44,"132/13,2/13,2",57.64,"2016-03-28T08:24:00","2016-03-28T14:26:00",6.0333333334419876,362,"P","--","--","NO",0.60000000000000009,208.54152000000002,"--","--","--","--","--","--","--","SI",{"$f":"IF(F24=\"\",\"\",SUM(T24:AA24)*IF(AB24=\"SI\",1,2)*IF(AND(Q24<>\"0,000\",O24=\"RF\"),Q24/100,1))","v":208.54152000000002}]
[null,null,130,300864,2459,"SAN CLEMENTE","TRAFO 2",15,"132/33/13,2",19.650000000000002,"2016-03-28T09:59:00","2016-03-28T17:45:00",7.7666666666627862,466,"P","--","--","NO",0.60000000000000009,91.608300000000014,"--","--","--","--","--","--","--","SI",91.608300000000014]
[null,null,131,300865,2069,"VILLA LIA","TRAFO 1",150,"220/132/13,2",196.5,"2016-03-28T10:51:00","2016-03-28T14:50:00",3.9833333333954215,239,"P","--","--","NO",0.60000000000000009,469.24200000000008,"--","--","--","--","--","--","--","SI",469.24200000000008]
[null,null,132,300867,2095,"SAN NICOLAS URBANA","TRAFO 1",44,"132/13,2/13,2",57.64,"2016-03-29T08:09:00","2016-03-29T14:18:00",6.1499999999650754,369,"P","--","--","NO",0.60000000000000009,212.69160000000002,"--","--","--","--","--","--","--","SI",212.69160000000002]
[null,null,133,300868,2547,"CNEL. SUAREZ","TRAFO 1",15,"132/33/13,2",19.650000000000002,"2016-03-29T08:18:00","2016-03-29T17:33:00",9.2499999999417923,555,"P","--","--","NO",0.60000000000000009,109.05750000000002,"--","--","--","--","--","--","--","SI",109.05750000000002]
[null,null,134,300869,2139,"ARRECIFES","TRAFO 5",5,"66/33",6.5500000000000007,"2016-03-29T08:34:00","2016-03-29T15:59:00",7.4166666667442769,445,"P","--","--","NO",0.60000000000000009,29.160600000000006,"--","--","--","--","--","--","--","SI",29.160600000000006]
[null,null,135,300870,2458,"SAN CLEMENTE","TRAFO 1",15,"132/33/13,2",19.650000000000002,"2016-03-29T08:38:00","2016-03-29T17:01:00",8.3833333332440816,503,"P","--","--","NO",{"$f":"$I$17*IF(OR(O30=\"P\",O30=\"RP\"),0.1,1)*IF(R30=\"SI\",1,0.1)","v":0.60000000000000009},{"$f":"IF(O30=\"P\",J30*S30*ROUND(N30/60,2),\"--\")","v":98.800200000000032},{"$f":"IF(O30=\"RP\",J30*S30*ROUND(N30/60,2)*Q30/100,\"--\")","v":"--"},{"$f":"IF(AND(O30=\"F\",P30=\"NO\"),J30*S30,\"--\")","v":"--"},{"$f":"IF(O30=\"F\",J30*S30*ROUND(N30/60,2),\"--\")","v":"--"},{"$f":"IF(AND(O30=\"R\",P30=\"NO\"),J30*S30*Q30/100,\"--\")","v":"--"},{"$f":"IF(O30=\"R\",J30*S30*ROUND(N30/60,2)*Q30/100,\"--\")","v":"--"},{"$f":"IF(O30=\"RF\",J30*S30*ROUND(N30/60,2),\"--\")","v":"--"},{"$f":"IF(O30=\"RR\",J30*S30*ROUND(N30/60,2)*Q30/100,\"--\")","v":"--"},"SI",98.800200000000032]
[null,null,136,300877,2069,"VILLA LIA","TRAFO 1",150,"220/132/13,2",196.5,"2016-03-29T10:03:00","2016-03-29T15:05:00",5.0333333333255723,302,"P","--","--","NO",0.60000000000000009,593.03700000000015,"--","--","--","--","--","--","--","SI",593.03700000000015]
[null,null,137,300885,2095,"SAN NICOLAS URBANA","TRAFO 1",44,"132/13,2/13,2",57.64,"2016-03-30T08:11:00","2016-03-30T16:22:00",8.1833333332906477,491,"P","--","--","NO",0.60000000000000009,282.89712000000003,"--","--","--","--","--","--","--","SI",282.89712000000003]
[null,null,138,300886,2547,"CNEL. SUAREZ","TRAFO 1",15,"132/33/13,2",19.650000000000002,"2016-03-30T08:24:00","2016-03-30T17:19:00",8.9166666667442769,535,"P","--",{"$f":"IF(F33=\"\",\"\",\"--\")","v":"--"},{"$f":"IF(F33=\"\",\"\",\"NO\")","v":"NO"},0.60000000000000009,105.16680000000002,"--","--","--","--","--","--","--","SI",105.16680000000002]
[null,null,139,300889,4963,"TRES ARROYOS","TRAFO 1",30,"132/33/13,2",39.300000000000004,"2016-03-30T08:55:00","2016-03-30T10:00:00",1.0833333331975155,65,"P","--","--","NO",0.60000000000000009,25.466400000000007,"--","--","--","--","--","--","--","SI",25.466400000000007]
[null,null,140,300891,2458,"SAN CLEMENTE","TRAFO 1",15,"132/33/13,2",19.650000000000002,"2016-03-30T09:12:00","2016-03-30T17:38:00",8.433333333407063,506,"P","--","--","NO",0.60000000000000009,99.389700000000019,"--","--","--","--","--","--","--","SI",99.389700000000019]
[null,null,141,300896,2548,"CNEL. SUAREZ","TRAFO 2",15,"132/33/13,2",19.650000000000002,"2016-03-31T08:40:00","2016-03-31T17:28:00",8.8000000000465661,528,"P","--","--","NO",0.60000000000000009,103.75200000000004,"--","--","--","--","--","--","--","SI",103.75200000000004]
[null,null,142,300897,2459,"SAN CLEMENTE","TRAFO 2",15,"132/33/13,2",19.650000000000002,"2016-03-31T08:47:00","2016-03-31T17:25:00",8.6333333333604969,518,"P","--","--","NO",0.60000000000000009,101.74770000000004,"--","--","--","--","--","--","--","SI",101.74770000000004]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","",{"$f":"IF(F38=\"\",\"\",\"NO\")","v":""},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,"--","--","--","--","--","--","--","--",{"$f":"IF(F40=\"\",\"\",\"SI\")","v":""},""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[]
[null,null,"(²)","P - PROGRAMADA  ; F - FORZADA  ; R - REDUCCIÓN FORZADA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T20:T42)","v":3316.9514400000007},{"$f":"SUM(U20:U42)","v":0},{"$f":"SUM(V20:V42)","v":0},{"$f":"SUM(W22:W42)","v":0},{"$f":"SUM(X20:X42)","v":0},{"$f":"SUM(Y22:Y42)","v":0},{"$f":"SUM(Z20:Z42)","v":0},{"$f":"SUM(AA22:AA42)","v":0},null,{"$f":"ROUND(SUM(AC20:AC42),2)","v":23453.040000000001}]

{"sheet":"SA-03 (1)","index":9,"n_rows":42,"n_cols":22,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'TOT-0316'!B2","v":"ANEXO IV 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-0316'!B14","v":"Desde el 01 al 31 de Marzo de 2016"}]
[]
[null,null,null,null,null,"Salida en 220 kV",34.93,{"$f":"60*'TOT-0316'!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-0316'!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-0316'!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-0316'!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,143,299957,2243,"SALADILLO","SALIDA 2 A SALADILLO",13.2,{"$f":"IF(H22=220,$G$14,IF(AND(H22<=132,H22>=66),$G$15,IF(AND(H22<66,H22>=33),$G$16,$G$17)))","v":13.097},"2016-03-03T13:26:00","2016-03-03T14:02:00",{"$f":"IF(F22=\"\",\"\",(K22-J22)*24)","v":0.6000000000349246},{"$f":"IF(F22=\"\",\"\",ROUND((K22-J22)*24*60,0))","v":36},"P",{"$f":"IF(F22=\"\",\"\",IF(OR(N22=\"P\",N22=\"RP\"),\"--\",\"NO\"))","v":"--"},{"$f":"IF(H22=220,$H$14,IF(AND(H22<=132,H22>=66),$H$15,IF(AND(H22<66,H22>13.2),$H$16,$H$17)))","v":40},{"$f":"IF(N22=\"P\",I22*P22*ROUND(M22/60,2)*0.1,\"--\")","v":31.4328},{"$f":"IF(AND(N22=\"F\",O22=\"NO\"),I22*P22,\"--\")","v":"--"},{"$f":"IF(N22=\"F\",I22*P22*ROUND(M22/60,2),\"--\")","v":"--"},{"$f":"IF(N22=\"RF\",I22*P22*ROUND(M22/60,2),\"--\")","v":"--"},"SI",{"$f":"IF(F22=\"\",\"\",SUM(Q22:T22)*IF(U22=\"SI\",1,2)*IF(H22=\"500/220\",0,1))","v":31.4328}]
[null,null,144,299958,2245,"SALADILLO","SALIDA 6 A SALADILLO",13.2,13.097,"2016-03-03T14:05:00","2016-03-03T14:57:00",0.86666666669771075,52,"P","--",40,45.577560000000005,"--","--","--","SI",45.577560000000005]
[null,null,145,299776,2317,"TANDIL","SALIDA 4  A COOP. TANDIL",13.2,13.097,"2016-03-04T10:11:00","2016-03-04T14:12:00",4.0166666666627862,241,"P","--",40,210.59975999999997,"--","--","--","SI",210.59975999999997]
[]
[null,null,147,300219,2345,"QUEQUEN","SALIDA A LA DULCE",33,13.097,"2016-03-08T07:56:00","2016-03-08T14:30:00",6.566666666592937,394,"P","--",50,430.2364500000001,"--","--","--","SI",430.2364500000001]
[null,null,148,300226,2357,"BALCARCE","SALIDA 3 A COOP. BALCARCE",13.2,13.097,"2016-03-08T10:40:00","2016-03-08T17:28:00",6.7999999999883585,408,"P","--",40,356.23840000000001,"--","--","--","SI",356.23840000000001]
[null,null,149,300228,2118,"ROJAS","SALIDA 2 A COOP. ROJAS",13.2,13.097,"2016-03-08T11:54:00","2016-03-08T15:52:00",3.9666666666744277,238,"P","--",40,207.98036000000002,"--","--","--","SI",207.98036000000002]
[null,null,150,300229,2508,"PUNTA ALTA","SALIDA 5 A COOP. PUNTA ALTA",13.2,13.097,"2016-03-08T12:48:00","2016-03-08T13:00:00",0.19999999995343387,12,"F","NO",40,"--",523.88,104.77600000000001,"--","SI",628.65599999999995]
[null,null,151,300230,2344,"QUEQUEN","SALIDA A  LOBERÍA PIERES",33,13.097,"2016-03-09T07:59:00","2016-03-09T15:40:00",7.683333333407063,461,"P","--",50,502.9248,"--","--","--","SI",502.9248]
[null,null,152,300237,2249,"LINCOLN","SALIDA A PINTO",33,13.097,"2016-03-10T07:56:00","2016-03-10T14:32:00",6.6000000000349246,396,"P","--",50,432.20100000000002,"--","--","--","SI",432.20100000000002]
[null,null,153,300240,2222,"LUJAN","SALIDA A CAP. DEL SEÑOR",33,13.097,"2016-03-10T08:35:00","2016-03-10T12:44:00",4.1499999999068677,249,"P","--",50,271.76275000000004,"--","--","--","SI",271.76275000000004]
[null,null,154,300249,2549,"SUAREZ","SALIDA A A. CORTO",33,13.097,"2016-03-11T08:41:00","2016-03-11T18:50:00",10.149999999906868,609,"P","--",50,664.67275000000018,"--","--","--","SI",664.67275000000018]
[null,null,155,300252,2290,"CHACABUCO","SALIDA 1 A CHACABUCO",13.2,13.097,"2016-03-11T09:05:00","2016-03-11T12:26:00",3.3500000000931323,201,"P","--",40,175.49980000000002,"--","--","--","SI",175.49980000000002]
[null,null,156,300256,2293,"CHACABUCO","SALIDA 6 A CHACABUCO",13.2,13.097,"2016-03-11T11:35:00","2016-03-11T15:06:00",3.5166666666045785,211,"P","--",40,184.40576000000001,"--","--","--","SI",184.40576000000001]
[null,null,157,300257,4205,"SALTO","SALIDA 2 A ARRECIFES",33,13.097,"2016-03-11T11:50:00","2016-03-11T14:26:00",2.6000000000931323,156,"P","--",50,170.26100000000002,"--","--","--","SI",170.26100000000002]
[null,null,158,300433,2344,"QUEQUEN","SALIDA A  LOBERÍA PIERES",33,13.097,"2016-03-15T07:40:00","2016-03-15T13:35:00",5.9166666665696539,355,"P","--",50,387.6712,"--","--","--","SI",387.6712]
[null,null,159,300434,2267,"HENDERSON","SALIDA A URDAMPILLETA",33,13.097,"2016-03-15T07:49:00","2016-03-15T15:31:00",7.6999999999534339,462,"P","--",50,504.23450000000003,"--","--","--","SI",504.23450000000003]
[null,null,160,300437,2355,"BALCARCE","SALIDA 1 A COOP. BALCARCE ",13.2,13.097,"2016-03-15T08:40:00","2016-03-15T15:15:00",6.5833333333139308,395,"P","--",40,344.71304000000003,"--","--","--","SI",344.71304000000003]
[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":4920.4119299999993},{"$f":"SUM(R20:R41)","v":523.88},{"$f":"SUM(S20:S41)","v":104.77600000000001},{"$f":"SUM(T20:T41)","v":0},null,{"$f":"ROUND(SUM(V20:V41),2)","v":5549.07}]

{"sheet":"SA-03 (2)","index":10,"n_rows":43,"n_cols":22,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'TOT-0316'!B2","v":"ANEXO IV 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-0316'!B14","v":"Desde el 01 al 31 de Marzo de 2016"}]
[]
[null,null,null,null,null,"Salida en 220 kV",34.93,{"$f":"60*'TOT-0316'!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-0316'!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-0316'!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-0316'!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-03 (1)'!V42","v":5549.07}]
[]
[null,null,161,300438,2105,"SAN NICOLAS URBANA","SALIDA 9",13.2,{"$f":"IF(H22=220,$G$14,IF(AND(H22<=132,H22>=66),$G$15,IF(AND(H22<66,H22>=33),$G$16,$G$17)))","v":13.097},"2016-03-15T08:58:00","2016-03-15T12:49:00",{"$f":"IF(F22=\"\",\"\",(K22-J22)*24)","v":3.8499999999767169},{"$f":"IF(F22=\"\",\"\",ROUND((K22-J22)*24*60,0))","v":231},"P",{"$f":"IF(F22=\"\",\"\",IF(OR(N22=\"P\",N22=\"RP\"),\"--\",\"NO\"))","v":"--"},{"$f":"IF(H22=220,$H$14,IF(AND(H22<=132,H22>=66),$H$15,IF(AND(H22<66,H22>13.2),$H$16,$H$17)))","v":40},{"$f":"IF(N22=\"P\",I22*P22*ROUND(M22/60,2)*0.1,\"--\")","v":201.69380000000001},{"$f":"IF(AND(N22=\"F\",O22=\"NO\"),I22*P22,\"--\")","v":"--"},{"$f":"IF(N22=\"F\",I22*P22*ROUND(M22/60,2),\"--\")","v":"--"},{"$f":"IF(N22=\"RF\",I22*P22*ROUND(M22/60,2),\"--\")","v":"--"},"SI",{"$f":"IF(F22=\"\",\"\",SUM(Q22:T22)*IF(U22=\"SI\",1,2)*IF(H22=\"500/220\",0,1))","v":201.69380000000001}]
[null,null,162,300442,2360,"BALCARCE","SALIDA 9 A COOP. BALCARCE",13.2,13.097,"2016-03-16T07:30:00","2016-03-16T10:36:00",3.0999999999767169,186,"P",{"$f":"IF(F23=\"\",\"\",IF(OR(N23=\"P\",N23=\"RP\"),\"--\",\"NO\"))","v":"--"},40,162.40280000000001,"--","--","--","SI",162.40280000000001]
[null,null,163,300443,2707,"CHACABUCO","SALIDA 4 A CHACABUCO",13.2,13.097,"2016-03-16T07:55:00","2016-03-16T10:38:00",2.716666666790843,163,"P","--",40,142.49536000000001,"--","--","--","SI",142.49536000000001]
[null,null,164,300450,2551,"SUAREZ","SALIDA 1 A SUAREZ",13.2,13.097,"2016-03-16T09:48:00","2016-03-16T16:09:00",6.3500000000931323,381,"P","--",40,332.66380000000004,"--","--","--","SI",332.66380000000004]
[null,null,165,300451,2125,"PERGAMINO","SALIDA 2 A CRUCE",33,13.097,"2016-03-16T09:57:00","2016-03-16T13:28:00",3.5166666667792015,211,"P","--",50,230.50720000000001,"--","--","--","SI",230.50720000000001]
[null,null,166,300452,2291,"CHACABUCO","SALIDA 2 A CHACABUCO",13.2,13.097,"2016-03-17T07:58:00","2016-03-17T11:04:00",3.0999999999767169,186,"P","--",40,162.40280000000001,"--","--","--","SI",162.40280000000001]
[null,null,167,300456,2549,"SUAREZ","SALIDA A A. CORTO",33,13.097,"2016-03-17T08:44:00","2016-03-17T15:04:00",6.3333333333721384,380,"P","--",50,414.52005000000003,"--","--","--","SI",414.52005000000003]
[null,null,168,300457,5463,"SAN NICOLAS","SALIDA ALIMENT. 20 CONESA",13.2,13.097,"2016-03-17T09:03:00","2016-03-17T12:36:00",3.5500000000465661,213,"P","--",40,185.97739999999999,"--","--","--","SI",185.97739999999999]
[null,null,169,300458,2210,"MERCEDES","SALIDA 1 A MERCEDES",13.2,13.097,"2016-03-17T09:10:00","2016-03-17T13:53:00",4.7166666666744277,283,"P","--",40,247.27136000000002,"--","--","--","SI",247.27136000000002]
[null,null,170,300462,2295,"CHACABUCO","SALIDA 8 A CHACABUCO",13.199999809265137,13.097,"2016-03-18T08:10:00","2016-03-18T11:11:00",3.0166666665463708,181,"P","--",40,158.21176000000003,"--","--","--","SI",158.21176000000003]
[null,null,171,300465,2550,"SUAREZ","SALIDA A HUANGUELEN",33,13.097,"2016-03-18T08:56:00","2016-03-18T15:15:00",6.3166666666511446,379,"P","--",50,413.86520000000002,"--","--","--","SI",413.86520000000002]
[]
[null,null,173,300641,5176,"MAR DEL TUYU","SALIDA ALIM. TRAFO 1",13.2,13.097,"2016-03-21T16:43:00","2016-03-21T17:20:00",0.61666666658129543,37,"F","NO",40,"--",523.88,324.80559999999997,"--","SI",848.68560000000002]
[]
[null,null,175,300645,3469,"CHACABUCO","SALIDA 9 A CHACABUCO",13.2,13.097,"2016-03-22T08:43:00","2016-03-22T12:15:00",3.5333333333255723,212,"P","--",40,184.92964000000001,"--","--","--","SI",184.92964000000001]
[null,null,176,300651,4974,"LAS PALMAS","SALIDA 2 A PARQUE IND. ",33,13.097,"2016-03-22T11:02:00","2016-03-22T13:28:00",2.433333333407063,146,"P","--",50,159.12855000000002,"--","--","--",{"$f":"IF(F37=\"\",\"\",\"SI\")","v":"SI"},159.12855000000002]
[null,null,177,300652,2288,"CHACABUCO","SALIDA A RAWSON",33,13.097,"2016-03-22T11:31:00","2016-03-22T14:58:00",3.4500000000698492,207,"P","--",50,225.92325000000002,"--","--","--","SI",225.92325000000002]
[null,null,178,300655,2289,"CHACABUCO","SALIDA A JUNIN",33,13.097,"2016-03-23T08:16:00","2016-03-23T10:58:00",2.6999999998952262,162,"P","--",50,176.80950000000004,"--","--","--","SI",176.80950000000004]
[null,null,179,300871,2157,"JUNIN","SALIDA A VIAMONTE",33,13.097,"2016-03-29T08:43:00","2016-03-29T13:20:00",4.6166666666977108,277,"P","--",50,302.54070000000002,"--","--","--","SI",302.54070000000002]
[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":3701.3431700000001},{"$f":"SUM(R20:R42)","v":523.88},{"$f":"SUM(S20:S42)","v":324.80559999999997},{"$f":"SUM(T20:T42)","v":0},null,{"$f":"ROUND(SUM(V20:V42),2)","v":10099.1}]

{"sheet":"SA-03 (3)","index":11,"n_rows":43,"n_cols":22,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'TOT-0316'!B2","v":"ANEXO IV 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-0316'!B14","v":"Desde el 01 al 31 de Marzo de 2016"}]
[]
[null,null,null,null,null,"Salida en 220 kV",34.93,{"$f":"60*'TOT-0316'!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-0316'!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-0316'!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-0316'!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-03 (2)'!V43","v":10099.1}]
[]
[null,null,180,300874,4742,"JUNIN","SALIDA C.T. JUNIN",13.2,{"$f":"IF(H22=220,$G$14,IF(AND(H22<=132,H22>=66),$G$15,IF(AND(H22<66,H22>=33),$G$16,$G$17)))","v":13.097},"2016-03-29T09:12:00","2016-03-29T12:14:00",{"$f":"IF(F22=\"\",\"\",(K22-J22)*24)","v":3.0333333334419876},{"$f":"IF(F22=\"\",\"\",ROUND((K22-J22)*24*60,0))","v":182},"P",{"$f":"IF(F22=\"\",\"\",IF(OR(N22=\"P\",N22=\"RP\"),\"--\",\"NO\"))","v":"--"},{"$f":"IF(H22=220,$H$14,IF(AND(H22<=132,H22>=66),$H$15,IF(AND(H22<66,H22>13.2),$H$16,$H$17)))","v":40},{"$f":"IF(N22=\"P\",I22*P22*ROUND(M22/60,2)*0.1,\"--\")","v":158.73563999999999},{"$f":"IF(AND(N22=\"F\",O22=\"NO\"),I22*P22,\"--\")","v":"--"},{"$f":"IF(N22=\"F\",I22*P22*ROUND(M22/60,2),\"--\")","v":"--"},{"$f":"IF(N22=\"RF\",I22*P22*ROUND(M22/60,2),\"--\")","v":"--"},{"$f":"IF(F22=\"\",\"\",\"SI\")","v":"SI"},{"$f":"IF(F22=\"\",\"\",SUM(Q22:T22)*IF(U22=\"SI\",1,2)*IF(H22=\"500/220\",0,1))","v":158.73563999999999}]
[null,null,181,300876,2555,"SUAREZ","SALIDA 5 A SUAREZ",13.2,13.097,"2016-03-29T09:34:00","2016-03-29T15:52:00",6.3000000001047738,378,"P","--",40,330.0444,"--","--","--","SI",330.0444]
[null,null,182,300879,2165,"JUNIN","ALIMENT. 7 A JUNIN",13.2,13.097,"2016-03-29T12:40:00","2016-03-29T15:24:00",2.7333333333372138,164,"P","--",40,143.01924,"--","--","--","SI",143.01924]
[null,null,183,300890,4568,"JUNIN","ALIMENT. 8 A JUNIN",13.2,13.097,"2016-03-30T09:08:00","2016-03-30T14:28:00",5.3333333332557231,320,"P","--",40,279.22804000000002,"--","--","--","SI",279.22804000000002]
[null,null,184,300893,2556,"SUAREZ","SALIDA A LAS COLONIAS",13.2,13.097,"2016-03-30T09:21:00","2016-03-30T15:54:00",6.5500000000465661,393,"P","--",40,343.14139999999998,"--","--","--","SI",343.14139999999998]
[null,null,185,300899,2379,"BARKER","SALIDA 2 A LOMA NEGRA",33,13.097,"2016-03-31T09:20:00","2016-03-31T12:04:00",2.7333333333372138,164,"P","--",50,178.77405000000002,"--","--","--","SI",178.77405000000002]
[null,null,186,300900,2554,"SUAREZ","SALIDA 4 A SUAREZ",13.2,13.097,"2016-03-31T09:26:00","2016-03-31T16:53:00",7.4500000000116415,447,"P","--",40,390.29060000000004,"--","--","--","SI",390.29060000000004]
[null,null,187,300901,2217,"MERCEDES","SALIDA 8 A MERCEDES",13.2,13.097,"2016-03-31T09:40:00","2016-03-31T16:23:00",6.7166666665580124,403,"P","--",40,352.04736000000003,"--","--","--","SI",352.04736000000003]
[null,null,188,300902,2129,"PERGAMINO","ALIMENT. 2 A COOP. PERGAMINO",13.2,13.097,"2016-03-31T11:47:00","2016-03-31T14:40:00",2.8833333333022892,173,"P","--",40,150.87744000000001,"--","--","--","SI",150.87744000000001]
[null,null,null,null,null,null,null,null,13.097,null,null,"","",null,"",40,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,13.097,null,null,"","",null,"",40,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,13.097,null,null,"","",null,"",40,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,13.097,null,null,"","",null,"",40,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,13.097,null,null,"","",null,"",40,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,13.097,null,null,"","",null,"",40,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,13.097,null,null,"","",null,"",40,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,13.097,null,null,"","",null,"",40,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,13.097,null,null,"","",null,"",40,"--","--","--","--",{"$f":"IF(F39=\"\",\"\",\"SI\")","v":""},""]
[null,null,null,null,null,null,null,null,13.097,null,null,"","",null,"",40,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,13.097,null,null,"","",null,"",40,"--","--","--","--","",""]
[]
[null,null,"(²)","P - PROGRAMADA",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q20:Q42)","v":2326.1581700000002},{"$f":"SUM(R20:R42)","v":0},{"$f":"SUM(S20:S42)","v":0},{"$f":"SUM(T20:T42)","v":0},null,{"$f":"ROUND(SUM(V20:V42),2)","v":12425.26}]

{"sheet":"RE-03 (1)","index":12,"n_rows":44,"n_cols":30,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'TOT-0316'!B2","v":"ANEXO IV 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,"3.- REACTIVA"]
[]
[null,null,null,null,null,"3.- Equipamiento propio Res. 01_03"]
[]
[null,{"$f":"'TOT-0316'!B14","v":"Desde el 01 al 31 de Marzo de 2016"}]
[]
[null,null,null,null,null,"Coeficiente de penalización por salida forzada   =",null,null,null,{"$f":"60*'TOT-0316'!B13","v":60},null,{"$f":"IF(J16=60,\" \",IF(J16=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,30]
[null,null,"N°","INDISP","ID EQUIPO","ESTACIÓN \nTRANSFORMADORA","EQUIPO","POT.\n[MVA]","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,{"$f":"H20*I20","v":0},null,null,{"$f":"IF(F20=\"\",\"\",(M20-L20)*24)","v":""},{"$f":"IF(F20=\"\",\"\",ROUND((M20-L20)*24*60,0))","v":""},null,null,null,null,{"$f":"$J$16*IF(OR(P20=\"P\",P20=\"RP\"),0.1,1)*IF(S20=\"SI\",1,0.1)","v":6},{"$f":"IF(P20=\"P\",K20*T20*ROUND(O20/60,2),\"--\")","v":"--"},{"$f":"IF(P20=\"RP\",K20*T20*ROUND(O20/60,2)*R20/100,\"--\")","v":"--"},{"$f":"IF(AND(P20=\"F\",Q20=\"NO\"),K20*T20,\"--\")","v":"--"},{"$f":"IF(P20=\"F\",K20*T20*ROUND(O20/60,2),\"--\")","v":"--"},{"$f":"IF(AND(P20=\"R\",Q20=\"NO\"),K20*T20*R20/100,\"--\")","v":"--"},{"$f":"IF(P20=\"R\",K20*T20*ROUND(O20/60,2)*R20/100,\"--\")","v":"--"},{"$f":"IF(P20=\"RF\",K20*T20*ROUND(O20/60,2),\"--\")","v":"--"},{"$f":"IF(P20=\"RR\",K20*T20*ROUND(O20/60,2)*R20/100,\"--\")","v":"--"},null,{"$f":"IF(F20=\"\",\"\",SUM(U20:AB20)*IF(AC20=\"SI\",1,2))","v":""}]
[null,null,189,299950,4448,"9 DE JULIO","K1NJ",1.5,5.8780000000000001,13.199999809265137,{"$f":"H21*I21","v":8.8170000000000002},"2016-03-02T09:49:00","2016-03-02T12:08:00",2.3166666667093523,139,"P",{"$f":"IF(F21=\"\",\"\",IF(OR(P21=\"P\",P21=\"RP\"),\"--\",\"NO\"))","v":"--"},{"$f":"IF(F21=\"\",\"\",\"--\")","v":"--"},{"$f":"IF(F21=\"\",\"\",\"NO\")","v":"NO"},0.60000000000000009,12.273264000000001,"--","--","--","--","--","--","--","SI",12.273264000000001]
[null,null,190,300449,4456,"CHACABUCO","K1CB",3,6.2869999999999999,13.199999809265137,{"$f":"H22*I22","v":18.861000000000001},"2016-03-16T09:41:00","2016-03-16T15:15:00",{"$f":"IF(F22=\"\",\"\",(M22-L22)*24)","v":5.5666666666511446},{"$f":"IF(F22=\"\",\"\",ROUND((M22-L22)*24*60,0))","v":334},"P",{"$f":"IF(F22=\"\",\"\",IF(OR(P22=\"P\",P22=\"RP\"),\"--\",\"NO\"))","v":"--"},{"$f":"IF(F22=\"\",\"\",\"--\")","v":"--"},{"$f":"IF(F22=\"\",\"\",\"NO\")","v":"NO"},{"$f":"$J$16*IF(OR(P22=\"P\",P22=\"RP\"),0.1,1)*IF(S22=\"SI\",1,0.1)","v":0.60000000000000009},{"$f":"IF(P22=\"P\",K22*T22*ROUND(O22/60,2),\"--\")","v":63.033462000000021},{"$f":"IF(P22=\"RP\",K22*T22*ROUND(O22/60,2)*R22/100,\"--\")","v":"--"},{"$f":"IF(AND(P22=\"F\",Q22=\"NO\"),K22*T22,\"--\")","v":"--"},{"$f":"IF(P22=\"F\",K22*T22*ROUND(O22/60,2),\"--\")","v":"--"},{"$f":"IF(AND(P22=\"R\",Q22=\"NO\"),K22*T22*R22/100,\"--\")","v":"--"},{"$f":"IF(P22=\"R\",K22*T22*ROUND(O22/60,2)*R22/100,\"--\")","v":"--"},{"$f":"IF(P22=\"RF\",K22*T22*ROUND(O22/60,2),\"--\")","v":"--"},{"$f":"IF(P22=\"RR\",K22*T22*ROUND(O22/60,2)*R22/100,\"--\")","v":"--"},"SI",{"$f":"IF(F22=\"\",\"\",SUM(U22:AB22)*IF(AC22=\"SI\",1,2))","v":63.033462000000021}]
[null,null,191,300453,4457,"CHACABUCO","K3CB",3,6.2869999999999999,13.199999809265137,18.861000000000001,"2016-03-17T08:16:00","2016-03-17T13:20:00",5.066666666592937,304,"P",{"$f":"IF(F23=\"\",\"\",IF(OR(P23=\"P\",P23=\"RP\"),\"--\",\"NO\"))","v":"--"},{"$f":"IF(F23=\"\",\"\",\"--\")","v":"--"},{"$f":"IF(F23=\"\",\"\",\"NO\")","v":"NO"},0.60000000000000009,57.375162000000017,"--","--","--","--","--","--","--","SI",57.375162000000017]
[null,null,192,300468,4451,"MERCEDES","K3MD",3,4.8739999999999997,13.199999809265137,14.622,"2016-03-18T09:49:00","2016-03-18T12:40:00",2.8500000000349246,171,"P","--","--","NO",0.60000000000000009,25.003620000000005,"--","--","--","--","--","--","--","SI",25.003620000000005]
[null,null,193,300471,4450,"MERCEDES","K1MD",1.5,4.8739999999999997,13.199999809265137,7.3109999999999999,"2016-03-18T12:41:00","2016-03-18T15:42:00",3.0166666667209938,181,"P","--","--","NO",0.60000000000000009,13.247532000000001,"--","--","--","--","--","--","--","SI",13.247532000000001]
[null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--",{"$f":"IF(F26=\"\",\"\",\"SI\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"H29*I29","v":0},null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"H30*I30","v":0},null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[]
[null,null,"(²)","P - PROGRAMADA  ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U19:U43)","v":170.93304000000006},{"$f":"SUM(V19:V43)","v":0},{"$f":"SUM(W19:W43)","v":0},{"$f":"SUM(X21:X43)","v":0},{"$f":"SUM(Y19:Y43)","v":0},{"$f":"SUM(Z21:Z43)","v":0},{"$f":"SUM(AA19:AA43)","v":0},{"$f":"SUM(AB21:AB43)","v":0},null,{"$f":"ROUND(SUM(AD19:AD43),2)","v":170.93}]

{"sheet":"DATO","index":13,"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,3,{"$f":"CELL(\"CONTENIDO\",OFFSET(A1,B14,0))","v":"marzo"},{"$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 marzo de 2016"},{"$f":"CELL(\"CONTENIDO\",OFFSET(B1,B14,0))","v":"03"},{"$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":"J0316TBA"}]
[null,{"$f":"\"\\\\rugor\\files\\Transporte\\transporte\\AA PROCESO AUT\\INTERCAMBIO\\\" &H14&G14","v":"\\\\rugor\\files\\Transporte\\transporte\\AA PROCESO AUT\\INTERCAMBIO\\1603"}]
["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-03"},"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-03"},"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-03"},"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-03"},"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-03"},"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]