{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["TOT-0416","LI-04 (1)","TR-04 (1)","TR-ECLESUR-04 (1)","SA-EDERSA-04 (1)","SUP-EDERSA ","SUP-ECLESUR","DATO"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":30,"comments":2,"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-0416","index":0,"n_rows":35,"n_cols":9,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[null,"ANEXO IV al Memorandum  D.T.E.E. N° 279 / 2017"]
[]
["ENTE NACIONAL REGULADOR "]
["DE LA ELECTRICIDAD"]
[]
[null,"SISTEMA DE TRANSPORTE DE ENERGÍA ELÉCTRICA POR DISTRIBUCIÓN TRONCAL"]
[]
[null,"TRANSPA S.A."]
[]
[null,"TOTAL DE PENALIZACIONES "]
[]
[null,1]
[null,"Desde el 01 al 30 de abril de 2016"]
[]
[null,{"$f":"IF(B13=2,\"Sanciones duplicadas por tasa de falla > 4 Sal. x año/100km.\",\"\")","v":""}]
[null,null,"1.-","LÍNEAS"]
[null,null,null,"1.1.-","Equipamiento propio",null,null,null,{"$f":"'LI-04 (1)'!AA43","v":46374.19}]
[]
[null,null,"2.-","CONEXIÓN"]
[]
[null,null,null,"2.1.-","Transformación"]
[null,null,null,null,"2.1.1.-","Equipamiento propio",null,null,{"$f":"'TR-04 (1)'!AC45","v":382.43}]
[null,null,null,null,"2.1.2.-","Transp. Indep. ECLESUR  La Esperanza - Calafate",null,null,{"$f":"'TR-ECLESUR-04 (1)'!AC45","v":96.45}]
[]
[null,null,null,"2.2.-","Salidas"]
[null,null,null,null,"2.2.1.-","Transportista Independiente E.D.E.R.S.A.",null,null,{"$f":"'SA-EDERSA-04 (1)'!V45","v":19.24503}]
[]
[null,null,"3.-","SUPERVISIÓN"]
[null,null,null,"3.1.-","Transportista Independiente E.D.E.R.S.A.",null,null,null,{"$f":"'SUP-EDERSA '!I57","v":5.2239546301741431}]
[null,null,null,"3.2.-","Transp. Indep. ECLESUR La Esperanza - Calafate",null,null,null,{"$f":"'SUP-ECLESUR'!I55","v":50.711734553378626}]
[]
[null,null,null,null,null,"TOTAL ",{"$f":"SUM(I18:I31)","v":46928.250719183547}]
[]
[null,null,"Valores remuneratorios de acuerdo al Acuerdo S.E.E. - ENRE - TRANSPA S.A. 2016-2017"]

{"sheet":"LI-04 (1)","index":1,"n_rows":43,"n_cols":27,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"+'TOT-0416'!B2","v":"ANEXO IV al Memorandum  D.T.E.E. N° 279 / 2017"}]
[]
["ENTE NACIONAL REGULADOR "]
["        DE LA ELECTRICIDAD"]
[]
[]
[null,null,null,null,null,"SISTEMA DE TRANSPORTE DE ENERGÍA ELÉCTRICA POR DISTRIBUCIÓN TRONCAL - TRANSPA S.A."]
[]
[null,null,null,null,null,"1.- LÍNEAS"]
[]
[null,null,null,null,null,"1.1.- Equipamiento propio"]
[]
[null,{"$f":"+'TOT-0416'!B14","v":"Desde el 01 al 30 de abril de 2016"}]
[]
[null,null,null,null,null,"$/100 km-h : LINEAS 330 kV ",273.24299999999999]
[null,null,null,null,null,"$/100 km-h : LINEAS 132 kV ",261.09899999999999,null,null,null,"FACTOR DE PENALIZACION  K =",{"$f":"30*'TOT-0416'!B13","v":30},{"$f":"IF(L17=30,\" \",IF(L17=60,\"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]
[null,null,"N°","INDISP","ID EQUIPO","LÍNEAS","U\n[kV]","Long.\n[km]","$/h","Salida","Entrada","Hs. \nIndisp","Minutos\nIndisp","Tipo \nSal.(²)","C.R.\n%","PENALIZ.\nPROGRAM.","REDUCC.\nPROGRAM.","PENALIZACION FORZADA\nPor Salida   1ras 3 hs.   hs. Restante",null,null,"REDUCC. FORZADA\nPor Salida   1ras 3 hs.   hs. Restante",null,null,"RESTANTE\nFORZADA","REDUCC.\nRESTANTE","Informó\nen Térm.","TOTAL\nPENALIZAC."]
[]
[]
[null,null,1,301235,1629,"PLANTA ALUMINIO DGPA - TRELEW",132,62,{"$f":"IF(H22>25,H22,25)*IF(G22=330,$G$16,$G$17)/100","v":161.88137999999998},"2016-04-06T06:41:00","2016-04-06T15:00:00",{"$f":"IF(F22=\"\",\"\",(K22-J22)*24)","v":8.3166666667093523},{"$f":"IF(F22=\"\",\"\",ROUND((K22-J22)*24*60,0))","v":499},"P","0,000",{"$f":"IF(N22=\"P\",ROUND(M22/60,2)*I22*$L$17*0.01,\"--\")","v":404.05592447999999},{"$f":"IF(N22=\"RP\",ROUND(M22/60,2)*I22*$L$17*0.01*O22/100,\"--\")","v":"--"},{"$f":"IF(N22=\"F\",I22*$L$17,\"--\")","v":"--"},{"$f":"IF(AND(M22>10,N22=\"F\"),I22*$L$17*IF(M22>180,3,ROUND(M22/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(M22>180,N22=\"F\"),(ROUND(M22/60,2)-3)*I22*$L$17*0.1,\"--\")","v":"--"},{"$f":"IF(N22=\"R\",I22*$L$17*O22/100,\"--\")","v":"--"},{"$f":"IF(AND(M22>10,N22=\"R\"),I22*$L$17*O22/100*IF(M22>180,3,ROUND(M22/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(M22>180,N22=\"R\"),(ROUND(M22/60,2)-3)*O22/100*I22*$L$17*0.1,\"--\")","v":"--"},{"$f":"IF(N22=\"RF\",ROUND(M22/60,2)*I22*$L$17*0.1,\"--\")","v":"--"},{"$f":"IF(N22=\"RR\",ROUND(M22/60,2)*O22/100*I22*$L$17*0.1,\"--\")","v":"--"},"SI",{"$f":"IF(F22=\"\",\"\",SUM(P22:Y22)*IF(Z22=\"SI\",1,2))","v":404.05592447999999}]
[null,null,2,301772,2035,"COMODORO RIVADAVIA (A1) - ESTACION PATAGONIA",132,6.9,65.274749999999997,"2016-04-23T07:26:00","2016-04-23T18:19:00",10.883333333360497,653,"F","0,000","--","--",1958.2424999999998,5874.7274999999991,1543.0950900000003,"--","--","--","--","--","SI",9376.0650900000001]
[null,null,3,302056,1630,"PLANTA ALUMINIO DGPA - PTO MADRYN",132,5.7,65.274749999999997,"2016-04-26T13:37:00","2016-04-26T14:13:00",0.6000000000349246,36,"F","0,000","--","--",1958.2424999999998,1174.9454999999998,"--","--","--","--","--","--","SI",3133.1879999999996]
[null,null,4,302055,1629,"PLANTA ALUMINIO DGPA - TRELEW",132,62,161.88137999999998,"2016-04-26T13:37:00","2016-04-27T21:31:00",{"$f":"IF(F25=\"\",\"\",(K25-J25)*24)","v":31.899999999906868},{"$f":"IF(F25=\"\",\"\",ROUND((K25-J25)*24*60,0))","v":1914},"F","0,000",{"$f":"IF(N25=\"P\",ROUND(M25/60,2)*I25*$L$17*0.01,\"--\")","v":"--"},{"$f":"IF(N25=\"RP\",ROUND(M25/60,2)*I25*$L$17*0.01*O25/100,\"--\")","v":"--"},{"$f":"IF(N25=\"F\",I25*$L$17,\"--\")","v":4856.4413999999997},{"$f":"IF(AND(M25>10,N25=\"F\"),I25*$L$17*IF(M25>180,3,ROUND(M25/60,2)),\"--\")","v":14569.324199999999},{"$f":"IF(AND(M25>180,N25=\"F\"),(ROUND(M25/60,2)-3)*I25*$L$17*0.1,\"--\")","v":14035.115645999998},{"$f":"IF(N25=\"R\",I25*$L$17*O25/100,\"--\")","v":"--"},{"$f":"IF(AND(M25>10,N25=\"R\"),I25*$L$17*O25/100*IF(M25>180,3,ROUND(M25/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(M25>180,N25=\"R\"),(ROUND(M25/60,2)-3)*O25/100*I25*$L$17*0.1,\"--\")","v":"--"},{"$f":"IF(N25=\"RF\",ROUND(M25/60,2)*I25*$L$17*0.1,\"--\")","v":"--"},{"$f":"IF(N25=\"RR\",ROUND(M25/60,2)*O25/100*I25*$L$17*0.1,\"--\")","v":"--"},"SI",33460.881245999997]
[null,null,null,null,null,null,null,null,65.274749999999997,null,null,null,null,null,null,"--","--","--","--","--","--","--","--","--","--"]
[null,null,null,null,null,null,null,null,65.274749999999997,null,null,null,null,null,null,"--","--","--","--","--","--","--","--","--","--"]
[null,null,null,null,null,null,null,null,65.274749999999997,null,null,"","",null,{"$f":"IF(F28=\"\",\"\",\"--\")","v":""},"--","--","--","--","--","--","--","--","--","--",{"$f":"IF(F28=\"\",\"\",\"SI\")","v":""},""]
[null,null,null,null,null,null,null,null,65.274749999999997,null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,65.274749999999997,null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,65.274749999999997,null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,65.274749999999997,null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,65.274749999999997,null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,65.274749999999997,null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,65.274749999999997,null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,65.274749999999997,null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,65.274749999999997,null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,65.274749999999997,null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,{"$f":"IF(H39>25,H39,25)*IF(G39=330,$G$16,$G$17)/100","v":65.274749999999997},null,null,{"$f":"IF(F39=\"\",\"\",(K39-J39)*24)","v":""},{"$f":"IF(F39=\"\",\"\",ROUND((K39-J39)*24*60,0))","v":""},null,{"$f":"IF(F39=\"\",\"\",\"--\")","v":""},{"$f":"IF(N39=\"P\",ROUND(M39/60,2)*I39*$L$17*0.01,\"--\")","v":"--"},{"$f":"IF(N39=\"RP\",ROUND(M39/60,2)*I39*$L$17*0.01*O39/100,\"--\")","v":"--"},{"$f":"IF(N39=\"F\",I39*$L$17,\"--\")","v":"--"},{"$f":"IF(AND(M39>10,N39=\"F\"),I39*$L$17*IF(M39>180,3,ROUND(M39/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(M39>180,N39=\"F\"),(ROUND(M39/60,2)-3)*I39*$L$17*0.1,\"--\")","v":"--"},{"$f":"IF(N39=\"R\",I39*$L$17*O39/100,\"--\")","v":"--"},{"$f":"IF(AND(M39>10,N39=\"R\"),I39*$L$17*O39/100*IF(M39>180,3,ROUND(M39/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(M39>180,N39=\"R\"),(ROUND(M39/60,2)-3)*O39/100*I39*$L$17*0.1,\"--\")","v":"--"},{"$f":"IF(N39=\"RF\",ROUND(M39/60,2)*I39*$L$17*0.1,\"--\")","v":"--"},{"$f":"IF(N39=\"RR\",ROUND(M39/60,2)*O39/100*I39*$L$17*0.1,\"--\")","v":"--"},{"$f":"IF(F39=\"\",\"\",\"SI\")","v":""},{"$f":"IF(F39=\"\",\"\",SUM(P39:Y39)*IF(Z39=\"SI\",1,2))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(H40>25,H40,25)*IF(G40=330,$G$16,$G$17)/100","v":65.274749999999997},null,null,{"$f":"IF(F40=\"\",\"\",(K40-J40)*24)","v":""},{"$f":"IF(F40=\"\",\"\",ROUND((K40-J40)*24*60,0))","v":""},null,{"$f":"IF(F40=\"\",\"\",\"--\")","v":""},{"$f":"IF(N40=\"P\",ROUND(M40/60,2)*I40*$L$17*0.01,\"--\")","v":"--"},{"$f":"IF(N40=\"RP\",ROUND(M40/60,2)*I40*$L$17*0.01*O40/100,\"--\")","v":"--"},{"$f":"IF(N40=\"F\",I40*$L$17,\"--\")","v":"--"},{"$f":"IF(AND(M40>10,N40=\"F\"),I40*$L$17*IF(M40>180,3,ROUND(M40/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(M40>180,N40=\"F\"),(ROUND(M40/60,2)-3)*I40*$L$17*0.1,\"--\")","v":"--"},{"$f":"IF(N40=\"R\",I40*$L$17*O40/100,\"--\")","v":"--"},{"$f":"IF(AND(M40>10,N40=\"R\"),I40*$L$17*O40/100*IF(M40>180,3,ROUND(M40/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(M40>180,N40=\"R\"),(ROUND(M40/60,2)-3)*O40/100*I40*$L$17*0.1,\"--\")","v":"--"},{"$f":"IF(N40=\"RF\",ROUND(M40/60,2)*I40*$L$17*0.1,\"--\")","v":"--"},{"$f":"IF(N40=\"RR\",ROUND(M40/60,2)*O40/100*I40*$L$17*0.1,\"--\")","v":"--"},{"$f":"IF(F40=\"\",\"\",\"SI\")","v":""},{"$f":"IF(F40=\"\",\"\",SUM(P40:Y40)*IF(Z40=\"SI\",1,2))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(H41>25,H41,25)*IF(G41=330,$G$16,$G$17)/100","v":65.274749999999997},null,null,{"$f":"IF(F41=\"\",\"\",(K41-J41)*24)","v":""},{"$f":"IF(F41=\"\",\"\",ROUND((K41-J41)*24*60,0))","v":""},null,{"$f":"IF(F41=\"\",\"\",\"--\")","v":""},{"$f":"IF(N41=\"P\",ROUND(M41/60,2)*I41*$L$17*0.01,\"--\")","v":"--"},{"$f":"IF(N41=\"RP\",ROUND(M41/60,2)*I41*$L$17*0.01*O41/100,\"--\")","v":"--"},{"$f":"IF(N41=\"F\",I41*$L$17,\"--\")","v":"--"},{"$f":"IF(AND(M41>10,N41=\"F\"),I41*$L$17*IF(M41>180,3,ROUND(M41/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(M41>180,N41=\"F\"),(ROUND(M41/60,2)-3)*I41*$L$17*0.1,\"--\")","v":"--"},{"$f":"IF(N41=\"R\",I41*$L$17*O41/100,\"--\")","v":"--"},{"$f":"IF(AND(M41>10,N41=\"R\"),I41*$L$17*O41/100*IF(M41>180,3,ROUND(M41/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(M41>180,N41=\"R\"),(ROUND(M41/60,2)-3)*O41/100*I41*$L$17*0.1,\"--\")","v":"--"},{"$f":"IF(N41=\"RF\",ROUND(M41/60,2)*I41*$L$17*0.1,\"--\")","v":"--"},{"$f":"IF(N41=\"RR\",ROUND(M41/60,2)*O41/100*I41*$L$17*0.1,\"--\")","v":"--"},{"$f":"IF(F41=\"\",\"\",\"SI\")","v":""},{"$f":"IF(F41=\"\",\"\",SUM(P41:Y41)*IF(Z41=\"SI\",1,2))","v":""}]
[]
[null,null,"(²)","P - PROGRAMADA  ; F - FORZADA",null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(P20:P42),2)","v":404.06},0,8772.93,21619,15578.21,0,0,0,0,0,null,{"$f":"ROUND(SUM(AA20:AA42),2)","v":46374.19}]

{"sheet":"TR-04 (1)","index":2,"n_rows":45,"n_cols":29,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"+'TOT-0416'!B2","v":"ANEXO IV al Memorandum  D.T.E.E. N° 279 / 2017"}]
[]
["ENTE NACIONAL REGULADOR "]
["        DE LA ELECTRICIDAD"]
[]
[]
[null,null,null,null,null,"SISTEMA DE TRANSPORTE DE ENERGÍA ELÉCTRICA POR DISTRIBUCIÓN TRONCAL - TRANSPA S.A."]
[]
[null,null,null,null,null,"2.- CONEXIÓN"]
[]
[null,null,null,null,null,"2.1.- Transformación"]
[]
[null,null,null,null,null,"2.1.1.- Equipamiento propio"]
[]
[null,{"$f":"+'TOT-0416'!B14","v":"Desde el 01 al 30 de abril de 2016"}]
[]
[null,null,null,null,null,"Por Transformador por MVA    $ =",null,null,0.90900000000000003]
[null,null,null,null,null,"Coeficiente de penalización por salida forzada   =",null,null,30,null,{"$f":"IF(I19=30,\" \",IF(I19=60,\"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.","Mtos.\nIndisp.","Tipo \nSal.(²)","AUT.","REST.\n%","E.N.S.","K (P;ENS)","PENALIZ.\nPROGRAM.","REDUCC.\nPROGRAM.","PENALIZACIONES\nPor Salida  hs. Restantes",null,"PENALIZACIONES\nPor Salida  hs. Restantes",null,"RESTANTE\nFORZADA","REDUCC.\nRESTANTE","Informó\nen Térm.","TOTAL\nPENALIZAC."]
[]
[]
[null,null,5,300947,1810,"TRELEW","TRAFO 3",30,"132/33/13,2",{"$f":"H24*$I$18","v":27.27},"2016-04-01T08:46:00","2016-04-01T12:22:00",{"$f":"IF(F24=\"\",\"\",(L24-K24)*24)","v":3.6000000000349246},{"$f":"IF(F24=\"\",\"\",ROUND((L24-K24)*24*60,0))","v":216},"P",{"$f":"IF(F24=\"\",\"\",IF(OR(O24=\"P\",O24=\"RP\"),\"--\",\"NO\"))","v":"--"},{"$f":"IF(F24=\"\",\"\",\"--\")","v":"--"},{"$f":"IF(F24=\"\",\"\",\"NO\")","v":"NO"},{"$f":"$I$19*IF(OR(O24=\"P\",O24=\"RP\"),0.1,1)*IF(R24=\"SI\",1,0.1)","v":0.30000000000000004},{"$f":"IF(O24=\"P\",J24*S24*ROUND(N24/60,2),\"--\")","v":29.451600000000003},{"$f":"IF(O24=\"RP\",J24*S24*ROUND(N24/60,2)*Q24/100,\"--\")","v":"--"},{"$f":"IF(AND(O24=\"F\",P24=\"NO\"),J24*S24,\"--\")","v":"--"},{"$f":"IF(O24=\"F\",J24*S24*ROUND(N24/60,2),\"--\")","v":"--"},{"$f":"IF(AND(O24=\"R\",P24=\"NO\"),J24*S24*Q24/100,\"--\")","v":"--"},{"$f":"IF(O24=\"R\",J24*S24*ROUND(N24/60,2)*Q24/100,\"--\")","v":"--"},{"$f":"IF(O24=\"RF\",J24*S24*ROUND(N24/60,2),\"--\")","v":"--"},{"$f":"IF(O24=\"RR\",J24*S24*ROUND(N24/60,2)*Q24/100,\"--\")","v":"--"},"SI",{"$f":"IF(F24=\"\",\"\",SUM(T24:AA24)*IF(AB24=\"SI\",1,2))","v":29.451600000000003}]
[null,null,6,301550,1788,"COM. RIVADAV.A1","TRAFO 5",30,"132/33/13,2",{"$f":"H25*$I$18","v":27.27},"2016-04-12T07:19:00","2016-04-12T18:58:00",11.650000000081491,699,"P","--","--","NO",{"$f":"$I$19*IF(OR(O25=\"P\",O25=\"RP\"),0.1,1)*IF(R25=\"SI\",1,0.1)","v":0.30000000000000004},{"$f":"IF(O25=\"P\",J25*S25*ROUND(N25/60,2),\"--\")","v":95.308650000000014},{"$f":"IF(O25=\"RP\",J25*S25*ROUND(N25/60,2)*Q25/100,\"--\")","v":"--"},{"$f":"IF(AND(O25=\"F\",P25=\"NO\"),J25*S25,\"--\")","v":"--"},{"$f":"IF(O25=\"F\",J25*S25*ROUND(N25/60,2),\"--\")","v":"--"},{"$f":"IF(AND(O25=\"R\",P25=\"NO\"),J25*S25*Q25/100,\"--\")","v":"--"},{"$f":"IF(O25=\"R\",J25*S25*ROUND(N25/60,2)*Q25/100,\"--\")","v":"--"},{"$f":"IF(O25=\"RF\",J25*S25*ROUND(N25/60,2),\"--\")","v":"--"},{"$f":"IF(O25=\"RR\",J25*S25*ROUND(N25/60,2)*Q25/100,\"--\")","v":"--"},"SI",{"$f":"IF(F25=\"\",\"\",SUM(T25:AA25)*IF(AB25=\"SI\",1,2))","v":95.308650000000014}]
[null,null,7,301769,1794,"PICO TRUNCADO 1","AU07",20,"132/66/13.2",{"$f":"H26*$I$18","v":18.18},"2016-04-19T09:20:00","2016-04-19T15:27:00",6.1166666666977108,367,"P",{"$f":"IF(F26=\"\",\"\",IF(OR(O26=\"P\",O26=\"RP\"),\"--\",\"NO\"))","v":"--"},{"$f":"IF(F26=\"\",\"\",\"--\")","v":"--"},"NO",{"$f":"$I$19*IF(OR(O26=\"P\",O26=\"RP\"),0.1,1)*IF(R26=\"SI\",1,0.1)","v":0.30000000000000004},{"$f":"IF(O26=\"P\",J26*S26*ROUND(N26/60,2),\"--\")","v":33.378480000000003},{"$f":"IF(O26=\"RP\",J26*S26*ROUND(N26/60,2)*Q26/100,\"--\")","v":"--"},{"$f":"IF(AND(O26=\"F\",P26=\"NO\"),J26*S26,\"--\")","v":"--"},{"$f":"IF(O26=\"F\",J26*S26*ROUND(N26/60,2),\"--\")","v":"--"},{"$f":"IF(AND(O26=\"R\",P26=\"NO\"),J26*S26*Q26/100,\"--\")","v":"--"},{"$f":"IF(O26=\"R\",J26*S26*ROUND(N26/60,2)*Q26/100,\"--\")","v":"--"},{"$f":"IF(O26=\"RF\",J26*S26*ROUND(N26/60,2),\"--\")","v":"--"},{"$f":"IF(O26=\"RR\",J26*S26*ROUND(N26/60,2)*Q26/100,\"--\")","v":"--"},"SI",{"$f":"IF(F26=\"\",\"\",SUM(T26:AA26)*IF(AB26=\"SI\",1,2))","v":33.378480000000003}]
[null,null,8,301770,1794,"PICO TRUNCADO 1","AU07",20,"132/66/13.2",18.18,"2016-04-21T08:26:00","2016-04-21T14:31:00",6.0833333332557231,365,"P",{"$f":"IF(F27=\"\",\"\",IF(OR(O27=\"P\",O27=\"RP\"),\"--\",\"NO\"))","v":"--"},{"$f":"IF(F27=\"\",\"\",\"--\")","v":"--"},"NO",0.30000000000000004,33.160320000000006,"--","--","--","--","--","--","--",{"$f":"IF(F27=\"\",\"\",\"SI\")","v":"SI"},{"$f":"IF(F27=\"\",\"\",SUM(T27:AA27)*IF(AB27=\"SI\",1,2))","v":33.160320000000006}]
[null,null,9,301771,1794,"PICO TRUNCADO 1","AU07",20,"132/66/13.2",18.18,"2016-04-22T08:26:00","2016-04-22T17:09:00",8.71666666661622,523,"P","--","--","NO",0.30000000000000004,47.558880000000009,"--","--","--","--","--","--","--","SI",47.558880000000009]
[null,null,10,302054,1801,"PUERTO MADRYN     ","AU01",60,"330/132/33",54.54,"2016-04-25T13:35:00","2016-04-25T16:01:00",2.433333333407063,146,"P","--","--","NO",0.30000000000000004,39.759660000000004,"--","--","--","--","--","--","--","SI",39.759660000000004]
[null,null,11,302062,1788,"COM. RIVADAV.A1","TRAFO 5",30,"132/33/13,2",27.27,"2016-04-27T09:33:00","2016-04-27T13:31:00",3.9666666666744277,238,"P","--","--","NO",0.30000000000000004,32.478570000000005,"--","--","--","--","--","--","--","SI",32.478570000000005]
[null,null,12,302063,1788,"COM. RIVADAV.A1","TRAFO 5",30,"132/33/13,2",27.27,"2016-04-28T09:46:00","2016-04-28T13:41:00",3.9166666666860692,235,"P","--","--","NO",0.30000000000000004,32.069520000000004,"--","--","--","--","--","--","--","SI",32.069520000000004]
[null,null,13,302064,1788,"COM. RIVADAV.A1","TRAFO 5",30,"132/33/13,2",27.27,"2016-04-29T10:04:00","2016-04-29T14:52:00",4.7999999999301508,288,"P","--","--","NO",0.30000000000000004,39.268800000000006,"--","--","--","--","--","--","--","SI",39.268800000000006]
[null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,3,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,3,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"H35*$I$18","v":0},null,null,{"$f":"IF(F35=\"\",\"\",(L35-K35)*24)","v":""},{"$f":"IF(F35=\"\",\"\",ROUND((L35-K35)*24*60,0))","v":""},null,"","","",{"$f":"$I$19*IF(OR(O35=\"P\",O35=\"RP\"),0.1,1)*IF(R35=\"SI\",1,0.1)","v":3},{"$f":"IF(O35=\"P\",J35*S35*ROUND(N35/60,2),\"--\")","v":"--"},{"$f":"IF(O35=\"RP\",J35*S35*ROUND(N35/60,2)*Q35/100,\"--\")","v":"--"},{"$f":"IF(AND(O35=\"F\",P35=\"NO\"),J35*S35,\"--\")","v":"--"},{"$f":"IF(O35=\"F\",J35*S35*ROUND(N35/60,2),\"--\")","v":"--"},{"$f":"IF(AND(O35=\"R\",P35=\"NO\"),J35*S35*Q35/100,\"--\")","v":"--"},{"$f":"IF(O35=\"R\",J35*S35*ROUND(N35/60,2)*Q35/100,\"--\")","v":"--"},{"$f":"IF(O35=\"RF\",J35*S35*ROUND(N35/60,2),\"--\")","v":"--"},{"$f":"IF(O35=\"RR\",J35*S35*ROUND(N35/60,2)*Q35/100,\"--\")","v":"--"},{"$f":"IF(F35=\"\",\"\",\"SI\")","v":""},""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",3,"--","--","--","--","--","--","--","--","",{"$f":"IF(F36=\"\",\"\",SUM(T36:AA36)*IF(AB36=\"SI\",1,2))","v":""}]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",3,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",3,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",3,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",3,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",3,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",3,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",3,"--","--","--","--","--","--","--","--","",""]
[]
[null,null,"(²)","P - PROGRAMADA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T22:T44)","v":382.43448000000006},0,0,0,0,0,0,0,null,{"$f":"ROUND(SUM(AC22:AC44),2)","v":382.43}]

{"sheet":"TR-ECLESUR-04 (1)","index":3,"n_rows":45,"n_cols":29,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'TOT-0416'!B2","v":"ANEXO IV al Memorandum  D.T.E.E. N° 279 / 2017"}]
[]
["ENTE NACIONAL REGULADOR "]
["        DE LA ELECTRICIDAD"]
[]
[]
[null,null,null,null,null,"SISTEMA DE TRANSPORTE DE ENERGÍA ELÉCTRICA POR DISTRIBUCIÓN TRONCAL - TRANSPA S.A."]
[]
[]
[null,null,null,null,null," 2.1.2.- Transportista Independiente ECLESUR LA ESPERANZA - CALAFATE"]
[]
[]
[null,{"$f":"'TOT-0416'!B14","v":"Desde el 01 al 30 de abril de 2016"}]
[]
[]
[null,null,null,null,null,"Por Transformador por MVA    $ =",null,null,0.14580000000000001]
[null,null,null,null,null,"Coeficiente de penalización por salida forzada   =",null,null,{"$f":"30*'TOT-0416'!B13","v":30},null,{"$f":"IF(I18=30,\" \",IF(I18=60,\"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.","Mtos.\nIndisp.","Tipo \nSal.(²)","AUT.","REST.\n%","E.N.S.","K (P;ENS)","PENALIZ.\nPROGRAM.","REDUCC.\nPROGRAM.","PENALIZACIONES\nPor Salida  hs. Restantes",null,"PENALIZACIONES\nPor Salida  hs. Restantes",null,"RESTANTE\nFORZADA","REDUCC.\nRESTANTE","Informó\nen Térm.","TOTAL\nPENALIZAC."]
[]
[]
[null,null,14,301773,5469,"EL CALAFATE","TRAFO 2",15,"132/33/13.2",{"$f":"H24*$I$17","v":2.1870000000000003},"2016-04-19T22:54:00","2016-04-19T23:22:00",{"$f":"IF(F24=\"\",\"\",(L24-K24)*24)","v":0.46666666661622003},{"$f":"IF(F24=\"\",\"\",ROUND((L24-K24)*24*60,0))","v":28},"F",{"$f":"IF(F24=\"\",\"\",IF(OR(O24=\"P\",O24=\"RP\"),\"--\",\"NO\"))","v":"NO"},{"$f":"IF(F24=\"\",\"\",\"--\")","v":"--"},"SI",{"$f":"$I$18*IF(OR(O24=\"P\",O24=\"RP\"),0.1,1)*IF(R24=\"SI\",1,0.1)","v":30},{"$f":"IF(O24=\"P\",J24*S24*ROUND(N24/60,2),\"--\")","v":"--"},{"$f":"IF(O24=\"RP\",J24*S24*ROUND(N24/60,2)*Q24/100,\"--\")","v":"--"},{"$f":"IF(AND(O24=\"F\",P24=\"NO\"),J24*S24,\"--\")","v":65.610000000000014},{"$f":"IF(O24=\"F\",J24*S24*ROUND(N24/60,2),\"--\")","v":30.836700000000004},{"$f":"IF(AND(O24=\"R\",P24=\"NO\"),J24*S24*Q24/100,\"--\")","v":"--"},{"$f":"IF(O24=\"R\",J24*S24*ROUND(N24/60,2)*Q24/100,\"--\")","v":"--"},{"$f":"IF(O24=\"RF\",J24*S24*ROUND(N24/60,2),\"--\")","v":"--"},{"$f":"IF(O24=\"RR\",J24*S24*ROUND(N24/60,2)*Q24/100,\"--\")","v":"--"},{"$f":"IF(F24=\"\",\"\",\"SI\")","v":"SI"},{"$f":"IF(F24=\"\",\"\",SUM(T24:AA24)*IF(AB24=\"SI\",1,2))","v":96.446700000000021}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$I$18*IF(OR(O25=\"P\",O25=\"RP\"),0.1,1)*IF(R25=\"SI\",1,0.1)","v":3},{"$f":"IF(O25=\"P\",J25*S25*ROUND(N25/60,2),\"--\")","v":"--"},{"$f":"IF(O25=\"RP\",J25*S25*ROUND(N25/60,2)*Q25/100,\"--\")","v":"--"},{"$f":"IF(AND(O25=\"F\",P25=\"NO\"),J25*S25,\"--\")","v":"--"},{"$f":"IF(O25=\"F\",J25*S25*ROUND(N25/60,2),\"--\")","v":"--"},{"$f":"IF(AND(O25=\"R\",P25=\"NO\"),J25*S25*Q25/100,\"--\")","v":"--"},{"$f":"IF(O25=\"R\",J25*S25*ROUND(N25/60,2)*Q25/100,\"--\")","v":"--"},{"$f":"IF(O25=\"RF\",J25*S25*ROUND(N25/60,2),\"--\")","v":"--"},{"$f":"IF(O25=\"RR\",J25*S25*ROUND(N25/60,2)*Q25/100,\"--\")","v":"--"}]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","",{"$f":"IF(F26=\"\",\"\",\"NO\")","v":""},3,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",3,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",3,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",3,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",3,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",3,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",3,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",3,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",3,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",3,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",3,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",3,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",3,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",3,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",3,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",3,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",3,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",3,"--","--","--","--","--","--","--","--","",""]
[]
[null,null,"(²)","F - FORZADA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T22:T44)","v":0},0,65.610000000000014,30.836700000000004,0,0,0,0,null,{"$f":"ROUND(SUM(AC22:AC44),2)","v":96.45}]

{"sheet":"SA-EDERSA-04 (1)","index":4,"n_rows":45,"n_cols":22,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"+'TOT-0416'!B2","v":"ANEXO IV al Memorandum  D.T.E.E. N° 279 / 2017"}]
[]
["ENTE NACIONAL REGULADOR "]
["        DE LA ELECTRICIDAD"]
[]
[]
[null,null,null,null,null,"SISTEMA DE TRANSPORTE DE ENERGÍA ELÉCTRICA POR DISTRIBUCIÓN TRONCAL - TRANSPA S.A."]
[]
[null,null,null,null,null,"2.2.1.- Transportista Independiente E.D.E.R.S.A."]
[]
[null,{"$f":"+'TOT-0416'!B14","v":"Desde el 01 al 30 de abril de 2016"}]
[]
[]
[null,null,null,null,null,"Salida en 330 kV"," - ",{"$f":"60*'TOT-0416'!B13","v":60},null,{"$f":"IF(H15=60,\" \",IF(H15=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 = ",3.2429999999999999,{"$f":"50*'TOT-0416'!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 33 kV ",2.4329999999999998,{"$f":"25*'TOT-0416'!B13","v":25},null,{"$f":"IF(H17=25,\" \",IF(H17=50,\"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 =",2.4329999999999998,{"$f":"20*'TOT-0416'!B13","v":20},null,{"$f":"IF(H18=20,\" \",IF(H18=40,\"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.","Mtos.\nIndisp.","Tipo \nSal.(²)","AUT.","K (U)","PENALIZ.\nPROGRAM.","PENALIZACIONES\nPor Salida  hs. Restantes",null,"RESTANTE\nFORZADA","Informó\nen Térm.","TOTAL\nPENALIZAC."]
[]
[]
[null,null,15,301774,1773,"VIEDMA","SALIDA ALIM.5 VIEDMA 2",13.2,{"$f":"IF(H24=330,$G$15,IF(AND(H24<=132,H24>=66),$G$16,IF(AND(H24<66,H24>=33),$G$17,$G$18)))","v":2.4329999999999998},"2016-04-18T09:02:00","2016-04-18T09:13:00",{"$f":"IF(F24=\"\",\"\",(K24-J24)*24)","v":0.18333333340706304},{"$f":"IF(F24=\"\",\"\",ROUND((K24-J24)*24*60,0))","v":11},"P",{"$f":"IF(F24=\"\",\"\",IF(N24=\"P\",\"--\",\"NO\"))","v":"--"},{"$f":"IF(H24=330,$H$15,IF(AND(H24<=132,H24>=66),$H$16,IF(AND(H24<66,H24>13.2),$H$17,$H$18)))","v":20},{"$f":"IF(N24=\"P\",I24*P24*ROUND(M24/60,2)*0.1,\"--\")","v":0.87587999999999999},{"$f":"IF(AND(N24=\"F\",O24=\"NO\"),I24*P24,\"--\")","v":"--"},{"$f":"IF(N24=\"F\",I24*P24*ROUND(M24/60,2),\"--\")","v":"--"},{"$f":"IF(N24=\"RF\",I24*P24*ROUND(M24/60,2),\"--\")","v":"--"},{"$f":"IF(F24=\"\",\"\",\"SI\")","v":"SI"},{"$f":"IF(F24=\"\",\"\",SUM(Q24:T24)*IF(U24=\"SI\",1,2)*IF(H24=\"500/220\",0,1))","v":0.87587999999999999}]
[null,null,16,301775,1756,"S.A. ESTE","SALIDA 2-PUERTO",33,2.4329999999999998,"2016-04-21T09:02:00","2016-04-21T12:03:00",3.0166666667209938,181,"P","--",25,18.369150000000001,"--","--",{"$f":"IF(N25=\"RF\",I25*P25*ROUND(M25/60,2),\"--\")","v":"--"},"SI",18.369150000000001]
[null,null,null,null,null,null,null,null,2.4329999999999998,null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,2.4329999999999998,null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,2.4329999999999998,null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,2.4329999999999998,null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,2.4329999999999998,null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,2.4329999999999998,null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,2.4329999999999998,null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,2.4329999999999998,null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,2.4329999999999998,null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,2.4329999999999998,null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,2.4329999999999998,null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,2.4329999999999998,null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,2.4329999999999998,null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,2.4329999999999998,null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,2.4329999999999998,null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,2.4329999999999998,null,null,"","",null,"",20,"--","--","--",{"$f":"IF(N41=\"RF\",I41*P41*ROUND(M41/60,2),\"--\")","v":"--"},"",""]
[null,null,null,null,null,null,null,null,2.4329999999999998,null,null,"","",null,"",20,"--","--","--",{"$f":"IF(N42=\"RF\",I42*P42*ROUND(M42/60,2),\"--\")","v":"--"},"",""]
[null,null,null,null,null,null,null,null,2.4329999999999998,null,null,"","",null,"",20,"--","--","--",{"$f":"IF(N43=\"RF\",I43*P43*ROUND(M43/60,2),\"--\")","v":"--"},"",""]
[]
[null,null,"(²)","P - PROGRAMADA",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(Q22:Q44),2)","v":19.25},{"$f":"SUM(R22:R44)","v":0},{"$f":"SUM(S22:S44)","v":0},{"$f":"SUM(T22:T44)","v":0},null,{"$f":"SUM(V22:V44)","v":19.24503}]

{"sheet":"SUP-EDERSA ","index":5,"n_rows":57,"n_cols":14,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'TOT-0416'!B2","v":"ANEXO IV al Memorandum  D.T.E.E. N° 279 / 2017"}]
["           ENTE NACIONAL REGULADOR "]
["                   DE LA ELECTRICIDAD"]
[]
[]
[null,null,null,"SISTEMA DE TRANSPORTE DE ENERGÍA ELÉCTRICA POR DISTRIBUCIÓN TRONCAL - TRANSPA S.A."]
[]
[null,null,null,"3.1.- SUPERVISIÓN - Transportista Independiente E.D.E.R.S.A."]
[]
[null,{"$f":"'TOT-0416'!B14","v":"Desde el 01 al 30 de abril de 2016"}]
[]
[]
[]
[null,null,"a) Datos"]
[null,null,null,null,null,null,null,null,null,null,null,"Salida en 132 kV = ",12.14]
[null,null,null,"Tiempo de servicio =",{"$f":"MID(B11,16,2)*24","v":720},"hs",null,null,"$/100 km-h : LÍNEAS 132 kV ",261.09899999999999,null,"Salida en 33 kV ",9.1110000000000007]
[null,null,null,"Porcentaje por Supervisión  =",2.5000000000000001E-2,null,null,null,"Cargo por Transformador por MVA = ",0.90900000000000003,null,"Salida en 13,2 kV =",9.1110000000000007]
[]
[null,null,"b) SM:  es la suma de las sanciones a que en cada mes se hiciere pasible el Transportista Independiente, valorizadas con idénticos criterios que los que se aplican a la Concesionaria."]
[]
[null,null,null,"SANCIÓN al T.I.",null,"LÍNEAS",null,null,0]
[null,null,null,null,null,"TRANSFORMACIÓN",null,null,0]
[null,null,null,null,null,"SALIDAS",null,null,72.069999999999993,null,null,"SEGÚN 2.2.1."]
[]
[null,null,null,null,null,null,null,"SM =",{"$f":"SUM(I22:I25)","v":72.069999999999993}]
[]
[null,null,"c) RM : es la remuneración que mensualmente recibiría el Transportista Independiente, si su servicio fuera valorizado conforme al régimen remuneratorio que se aplica a la Concesionaria."]
[]
[null,null,null,"Cargo por Capacidad de Transporte","U [kV]","Long [km]",null,"  RM por Cap. Transporte","        RM por Energía Transportada",null,null,"TOTAL"]
[null,null,null,"PUNTA COLORADA - SIERRA GRANDE",132,31,null,{"$f":"F31*$J$17*$E$17/100","v":58277.296799999996},0,"(DTE 0416)",null,{"$f":"SUM(H31:K31)","v":58277.296799999996}]
[null,null,null,"S.A. OESTE - SIERRA GRANDE",132,110.3,null,{"$f":"F32*$J$17*$E$17/100","v":207354.38183999996},15537,"(DTE 0416)",null,{"$f":"SUM(H32:K32)","v":222891.38183999996}]
[null,null,null,"S.A. OESTE - VIEDMA",132,185.6,null,{"$f":"F33*$J$17*$E$17/100","v":348911.81567999994},13057,"(DTE 0416)",null,{"$f":"SUM(H33:K33)","v":361968.81567999994}]
[null,null,null,"VIEDMA - CARMEN DE PATAGONES",132,7,null,{"$f":"F34*$J$17*$E$17/100","v":13159.3896},0,"(DTE 0416)",null,{"$f":"SUM(H34:K34)","v":13159.3896}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L31:L34)","v":656296.88391999982}]
[]
[null,null,null,"Cargo por Capacidad de Transformación","Equipo","Pot  E.T. [MVA]",null,"RM Cap. Transformación",null,"E.T",null,"Salida","U [kV]","Cargo"]
[null,null,null,"PUNTA COLORADA","TRAFOS 1y2",30,null,{"$f":"+F38*$J$18*$E$17","v":19634.400000000001},null,"C. DE PATAGONES",null,"Salida Viedma",132,{"$f":"M16*E17","v":8740.8000000000011}]
[null,null,null,"SIERRA GRANDE","Tr 1, 2, 4 y 5",88,null,{"$f":"+F39*$J$18*$E$17","v":57594.240000000005},null,"SAN ANTONIO ESTE",null,"Salida Conesa y SA Oeste",33,{"$f":"+M17*E17*2","v":13119.84}]
[null,null,null,"SAN ANTONIO ESTE","TRAFO 1",7.5,null,{"$f":"+F40*$J$18*$E$17","v":4908.6000000000004},null,"SAN ANTONIO OESTE",null,"Salidas Valcheta, SA Oeste y SA Este",33,{"$f":"3*M17*E17","v":19679.760000000002}]
[null,null,null,"SAN ANTONIO OESTE","TRAFO 1",15,null,{"$f":"+F41*$J$18*$E$17","v":9817.2000000000007},null,"VIEDMA",null,"Alimentadores 1,2,3,5,6 y 8",13.2,{"$f":"+M18*E17*6","v":39359.520000000004}]
[null,null,null,"VIEDMA","TRAFOS 1 y 2",30,null,{"$f":"+F42*$J$18*$E$17","v":19634.400000000001},null,"PUNTA COLORADA",null,"Alimentadores en 33 y 6,6 (2)",null,{"$f":"+M17*E17+M18*E17*2","v":19679.760000000002}]
[null,null,null,null,null,null,null,{"$f":"SUM(H38:H42)","v":111588.84000000003},null,"SIERRA GRANDE",null,"Salidas en 132, 33, 13,2 (3), 6,6 (2)",null,{"$f":"(M16+M17+M18*5)*E17","v":48100.320000000007}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N38:N43)","v":148680.00000000003}]
[]
[null,null,null,null,null,null,null,"RM =",{"$f":"+H43+N44+L35","v":916565.7239199999},null,"RM * =",265747.06575999997]
[]
[null,null,"d) CS: Es el cargo por Supervisión de la Operación que la Transportista percibe por supervisar la operación y mantenimiento del Transportista Independiente."]
[]
[null,null,null,"Cargo por Supervisión afectado a la sanción ",null,null,null,"CS =",{"$f":"E18*L46","v":6643.6766439999992},null,"RM * = VALOR EMPLEADO PARA CALCULAR \"CS\""]
[]
[null,null,"e) SANCIÓN"]
[null,null,null,"Sanción Calculada",{"$f":"10*I26*I50/I46","v":5.2239546301741431}]
[]
[null,null,null,"TOTAL A PENALIZAR A TRANSPA S.A. POR SUPERVISIÓN A EDERSA"]
[]
[null,null,null,null,null,null,null,"SANCIÓN  =",{"$f":"IF($E$53>3*I50,3*I50,$E$53)","v":5.2239546301741431}]

{"sheet":"SUP-ECLESUR","index":6,"n_rows":55,"n_cols":14,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'TOT-0416'!B2","v":"ANEXO IV al Memorandum  D.T.E.E. N° 279 / 2017"}]
["           ENTE NACIONAL REGULADOR "]
["                   DE LA ELECTRICIDAD"]
[]
[]
[null,null,null,"SISTEMA DE TRANSPORTE DE ENERGÍA ELÉCTRICA POR DISTRIBUCIÓN TRONCAL - TRANSPA S.A."]
[]
[null,null,null,"3.2.- SUPERVISIÓN - Transportista Independiente ECLESUR La Esperanza - Calafate"]
[]
[null,{"$f":"'TOT-0416'!B14","v":"Desde el 01 al 30 de abril de 2016"}]
[]
[]
[]
[null,null,"a) Datos"]
[null,null,null,null,null,null,null,null,null,null,null,"Salida en 132 kV o 66 kV = "," - "]
[null,null,null,"Tiempo de servicio =",{"$f":"MID(B11,16,2)*24","v":720},"hs",null,null,"$/100 km-h : LÍNEAS 132 kV ",261.09899999999999,null,"Salida en 33 kV ",9.1110000000000007]
[null,null,null,"Porcentaje por Supervisión  =",0.04,null,null,null,"Cargo por Transformador por MVA = ",0.90900000000000003,null,"Salida en 13,2 kV =",9.1110000000000007]
[]
[null,null,"b) SM:  es la suma de las sanciones a que en cada mes se hiciere pasible el Transportista Independiente, valorizadas con idénticos criterios que los que se aplican a la Concesionaria."]
[]
[null,null,null,"SANCIÓN al T.I.",null,"LÍNEAS",null,null,0]
[null,null,null,null,null,"TRANSFORMACIÓN",null,null,601.29999999999995,null,null,"SEGÚN 2.1.2."]
[null,null,null,null,null,"SALIDAS",null,null,0]
[]
[null,null,null,null,null,null,null,"SM =",{"$f":"SUM(I22:I25)","v":601.29999999999995}]
[]
[null,null,"c) RM : es la remuneración que mensualmente recibiría el Transportista Independiente, si su servicio fuera valorizado conforme al régimen remuneratorio que se aplica a la Concesionaria."]
[]
[null,null,null,"Cargo por Capacidad de Transporte","U [kV]","Long [km]",null,"  RM por Cap. Transporte","        RM por Energía Transportada",null,null,"TOTAL"]
[null,null,null,"ESPERANZA - EL CALAFATE",132,141.5,null,{"$f":"F31*$J$17*$E$17/100","v":266007.66119999997},5378,"(DTE 0416)",null,{"$f":"SUM(H31:K31)","v":271385.66119999997}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H32:K32)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L31:L32)","v":271385.66119999997}]
[]
[null,null,null,"Cargo por Capacidad de Transformación","Equipo","Pot  E.T. [MVA]",null,"RM Cap. Transformación",null,"E.T",null,"Salida","U [kV]","Cargo"]
[null,null,null,"EL CALAFATE","TRAFOS 2",15,null,{"$f":"+F36*$J$18*$E$17","v":9817.2000000000007},null,"EL CALAFATE",null,"Salida TRAFO 02",13.2,{"$f":"M18*E17","v":6559.92}]
[null,null,null,"EL CALAFATE","TRAFOS 3",15,null,{"$f":"+F37*$J$18*$E$17","v":9817.2000000000007},null,"EL CALAFATE",null,"Salida TRAFO 03",13.2,{"$f":"M18*E17","v":6559.92}]
[null,null,null,null,null,null,null,{"$f":"+F38*$J$18*$E$17","v":0},null,"EL CALAFATE",null,"Salida TRAFO 02",33,{"$f":"M17*E17","v":6559.92}]
[null,null,null,null,null,null,null,{"$f":"+F39*$J$18*$E$17","v":0},null,"EL CALAFATE",null,"Salida TRAFO 03",33,{"$f":"M17*E17","v":6559.92}]
[null,null,null,null,null,null,null,{"$f":"+F40*$J$18*$E$17","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(H36:H40)","v":19634.400000000001}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N36:N41)","v":26239.68}]
[]
[null,null,null,null,null,null,null,"RM =",{"$f":"+H41+N42+L33","v":317259.74119999999},null,"RM * =",66891.700400000002]
[]
[null,null,"d) CS: Es el cargo por Supervisión de la Operación que la Transportista percibe por supervisar la operación y mantenimiento del Transportista Independiente."]
[]
[null,null,null,"Cargo por Supervisión afectado a la sanción ",null,null,null,"CS =",{"$f":"E18*L44","v":2675.6680160000001}]
[]
[null,null,"e) SANCIÓN"]
[null,null,null,"Sanción Calculada",{"$f":"10*I26*I48/I44","v":50.711734553378626}]
[]
[null,null,null,"TOTAL A PENALIZAR A TRANSPA S.A. POR SUPERVISIÓN A ECLESUR LA ESPERANZA - CALAFATE"]
[]
[null,null,null,null,null,null,null,"SANCIÓN  =",{"$f":"IF($E$51>3*I48,3*I48,$E$51)","v":50.711734553378626},null,"RM* = VALOR EMPLEADO PARA CALCULAR CS"]

{"sheet":"DATO","index":7,"n_rows":31,"n_cols":29,"rows_kept":31,"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,4,{"$f":"CELL(\"CONTENIDO\",OFFSET(A1,B14,0))","v":"abril"},{"$f":"CELL(\"CONTENIDO\",OFFSET(C1,B14,0))","v":30},{"$f":"CELL(\"CONTENIDO\",OFFSET(D1,A14,0))","v":2016},{"$f":"\"Desde el 01 al \" & D14 & \" de \" & C14 & \" de \" & E14","v":"Desde el 01 al 30 de abril de 2016"},{"$f":"CELL(\"CONTENIDO\",OFFSET(B1,B14,0))","v":"04"},{"$f":"RIGHT(E14,2)","v":"16"},"B14"]
[null,{"$f":"\"\\\\rugor\\files\\Transporte\\Transporte\\AA PROCESO AUT ARCHIVOS J\\TRANSPA\\\" &E14","v":"\\\\rugor\\files\\Transporte\\Transporte\\AA PROCESO AUT ARCHIVOS J\\TRANSPA\\2016"},null,null,null,null,{"$f":"\"J\"&G14&H14&\"TPA\"","v":"J0416TPA"}]
[null,{"$f":"\"\\\\rugor\\files\\Transporte\\transporte\\AA PROCESO AUT\\INTERCAMBIO\\\" &H14&G14","v":"\\\\rugor\\files\\Transporte\\transporte\\AA PROCESO AUT\\INTERCAMBIO\\1604"}]
["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",22,20,12,{"$f":"\"LI-\" & $G$14","v":"LI-04"},"TRANSPA_INDISPONIBILIDADES_LINEAS_TRANSPA.XLS",3,5,4,6,7,8,0,10,11,14,0,26,15,0,0,0,19,9,43,27,20,27,14]
["MODELO L EDERSA",22,20,12,{"$f":"\"LI-EDERSA-\" & $G$14","v":"LI-EDERSA-04"},"TRANSPA_INDISPONIBILIDADES_LINEAS_EDERSA.XLS",3,5,4,6,7,8,0,10,11,14,0,26,15,0,0,0,20,9,43,27,20,27,14]
["MODELO L SPSE",22,20,12,{"$f":"\"LI-SPSE-\" & $G$14","v":"LI-SPSE-04"},"TRANSPA_INDISPONIBILIDADES_LINEAS_SPSE.XLS",3,5,4,6,7,8,0,10,11,14,0,26,15,0,0,0,21,9,43,27,20,27,14]
["MODELO L TRANSACUE",22,20,12,{"$f":"\"LI-TRANSACUE-\" & $G$14","v":"LI-TRANSACUE-04"},"TRANSPA_INDISPONIBILIDADES_LINEAS_TRANSACUE.XLS",3,5,4,6,7,8,0,10,11,14,0,26,15,0,0,0,22,9,43,27,20,27,14]
["MODELO T",24,20,13,{"$f":"\"TR-\" & $G$14","v":"TR-04"},"TRANSPA_INDISPONIBILIDADES_TRAFOS_TRANSPA.XLS",3,5,4,6,7,8,9,11,12,15,16,18,28,0,0,0,27,9,45,29,22,29,15]
["MODELO T EDERSA",24,20,13,{"$f":"\"TR-EDERSA-\" & $G$14","v":"TR-EDERSA-04"},"TRANSPA_INDISPONIBILIDADES_TRAFOS_EDERSA.XLS",3,5,4,6,7,8,9,11,12,15,16,18,28,0,0,0,28,9,45,29,22,29,15]
["MODELO T SPSE",24,20,13,{"$f":"\"TR-SPSE-\" & $G$14","v":"TR-SPSE-04"},"TRANSPA_INDISPONIBILIDADES_TRAFOS_SPSE.XLS",3,5,4,6,7,8,9,11,12,15,16,18,28,0,0,0,29,9,45,29,22,29,15]
["MODELO S",24,20,10,{"$f":"\"SA-\" & $G$14","v":"SA-04"},"TRANSPA_INDISPONIBILIDADES_SALIDAS_TRANSPA.XLS",3,5,4,6,7,8,10,11,14,15,21,0,0,0,0,0,32,9,45,22,22,22,21]
["MODELO S EDERSA",24,20,10,{"$f":"\"SA-EDERSA-\" & $G$14","v":"SA-EDERSA-04"},"TRANSPA_INDISPONIBILIDADES_SALIDAS_EDERSA.XLS",3,5,4,6,7,8,10,11,14,15,21,0,0,0,0,0,33,9,45,22,22,22,21]
["MODELO S SPSE",24,20,10,{"$f":"\"SA-SPSE-\" & $G$14","v":"SA-SPSE-04"},"TRANSPA_INDISPONIBILIDADES_SALIDAS_SPSE.XLS",3,5,4,6,7,8,10,11,14,15,21,0,0,0,0,0,34,9,45,22,22,22,21]
["MODELO S TRANSACUE",24,20,10,{"$f":"\"SA-TRANSACUE-\" & $G$14","v":"SA-TRANSACUE-04"},"TRANSPA_INDISPONIBILIDADES_SALIDAS_TRANSACUE.XLS",3,5,4,6,7,8,10,11,14,15,21,0,0,0,0,0,35,9,45,22,22,22,21]
["MODELO R",22,20,12,{"$f":"\"RE-\" & $G$14","v":"RE-04"},"TRANSPA_INDISPONIBILIDADES_REACTIVOS_TRANSPA.XLS",3,5,4,6,7,8,10,11,14,15,21,0,0,0,0,0,37,9,43,22,20,22,21]
["MODELO VST",19,24,4,{"$f":"\"CAUSAS-VST-\" & $G$14","v":"CAUSAS-VST-04"},"TRANSPA_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]
[null,30,10,11,"DAG","TRANSPA_INDISPONIBILIDADES_DAG.XLS",3,5,0,4,5,6,8,9,10,13,15,16,0,0,0,0,0,0,0,0,0,0,0]