{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["TOT-0316","LI-03 (1)","LI-EDERSA-03 (1)","TR-03 (1)","TR-EDERSA-03 (1)","SA-03 (1)","SA-EDERSA-03 (1)","SUP-EDERSA","DATO"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":2,"defined_names":60,"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-0316","index":0,"n_rows":36,"n_cols":9,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
[]
[null,"ANEXO III 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 31 de Marzo 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-03 (1)'!AA43","v":19382.580000000002}]
[null,null,null,"1.2.-","Transportista Independiente E.D.E.R.S.A.",null,null,null,{"$f":"'LI-EDERSA-03 (1)'!AA43","v":1096.8399999999999}]
[]
[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-03 (1)'!AC45","v":709.17}]
[null,null,null,null,"2.1.2.-","Transportista Independiente E.D.E.R.S.A.",null,null,{"$f":"'TR-EDERSA-03 (1)'!AC45","v":200.03}]
[]
[null,null,null,"2.2.-","Salidas"]
[null,null,null,null,"2.2.1.-","Equipamiento propio",null,null,{"$f":"'SA-03 (1)'!V45","v":170.01}]
[null,null,null,null,"2.2.2.-","Transportista Independiente E.D.E.R.S.A.",null,null,{"$f":"'SA-EDERSA-03 (1)'!V45","v":10.60788}]
[]
[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":351.04350767988404}]
[]
[null,null,null,null,null,"TOTAL ",{"$f":"SUM(I17:I32)","v":21920.281387679883}]
[]
[null,null,"Valores remuneratorios de acuerdo al Acuerdo S.E.E. - ENRE - TRANSPA S.A. 2016-2017"]

{"sheet":"LI-03 (1)","index":1,"n_rows":43,"n_cols":27,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"+'TOT-0316'!B2","v":"ANEXO III 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-0316'!B14","v":"Desde el 01 al 31 de Marzo 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-0316'!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,300266,1629,"TRELEW - P. ALUMINIO DGPA",132,62,{"$f":"IF(H22>25,H22,25)*IF(G22=330,$G$16,$G$17)/100","v":161.88137999999998},"2016-03-07T07:00:00","2016-03-07T09:52:00",{"$f":"IF(F22=\"\",\"\",(K22-J22)*24)","v":2.8666666667559184},{"$f":"IF(F22=\"\",\"\",ROUND((K22-J22)*24*60,0))","v":172},"F",{"$f":"IF(F22=\"\",\"\",\"--\")","v":"--"},{"$f":"IF(N22=\"P\",ROUND(M22/60,2)*I22*$L$17*0.01,\"--\")","v":"--"},{"$f":"IF(N22=\"RP\",ROUND(M22/60,2)*I22*$L$17*0.01*O22/100,\"--\")","v":"--"},{"$f":"IF(N22=\"F\",I22*$L$17,\"--\")","v":4856.4413999999997},{"$f":"IF(AND(M22>10,N22=\"F\"),I22*$L$17*IF(M22>180,3,ROUND(M22/60,2)),\"--\")","v":13937.986817999999},{"$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":"--"},{"$f":"IF(F22=\"\",\"\",\"SI\")","v":"SI"},{"$f":"IF(F22=\"\",\"\",SUM(P22:Y22)*IF(Z22=\"SI\",1,2))","v":18794.428218000001}]
[null,null,2,300675,1631,"PTO. MADRYN - SIERRA GRANDE",132,121.5,317.23528499999998,"2016-03-22T08:49:00","2016-03-22T15:00:00",6.183333333407063,371,"P","--",588.15421838999998,"--","--","--","--","--","--","--","--","--","SI",588.15421838999998]
[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,"","--","--","--","--","--","--","--","--","--","--",{"$f":"IF(F27=\"\",\"\",\"SI\")","v":""},""]
[null,null,null,null,null,null,null,null,65.274749999999997,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,null,null,null,null,null,null,null,null,"","",null,{"$f":"IF(F30=\"\",\"\",\"--\")","v":""},null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,"","",null,"",null,null,null,null,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,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,{"$f":"IF(F37=\"\",\"\",\"--\")","v":""},"--","--","--","--","--","--","--","--","--","--",{"$f":"IF(F37=\"\",\"\",\"SI\")","v":""},""]
[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":588.15},0,4856.4399999999996,13937.99,0,0,0,0,0,0,null,{"$f":"ROUND(SUM(AA20:AA42),2)","v":19382.580000000002}]

{"sheet":"LI-EDERSA-03 (1)","index":2,"n_rows":43,"n_cols":27,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"+'TOT-0316'!B2","v":"ANEXO III 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.2.- Transportista Independiente E.D.E.R.S.A."]
[]
[null,{"$f":"+'TOT-0316'!B14","v":"Desde el 01 al 31 de Marzo de 2016"}]
[]
[]
[null,null,null,null,null,"$/100 km-h : LINEAS 330 kV "," - "]
[null,null,null,null,null,"$/100 km-h : LINEAS 132 kV ",69.721999999999994,null,null,null,"FACTOR DE PENALIZACION  K =",{"$f":"30*'TOT-0316'!B13","v":30},{"$f":"IF(L16=30,\" \",IF(L16=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,3,299981,1635,"S.A. ESTE - VIEDMA",132,162.60000610351562,{"$f":"IF(H22>25,H22,25)*IF(G22=330,$G$15,$G$16)/100","v":113.36797625549316},"2016-03-02T07:49:00","2016-03-02T15:42:00",{"$f":"IF(F22=\"\",\"\",(K22-J22)*24)","v":7.8833333333604969},{"$f":"IF(F22=\"\",\"\",ROUND((K22-J22)*24*60,0))","v":473},"P",{"$f":"IF(F22=\"\",\"\",\"--\")","v":"--"},{"$f":"IF(N22=\"P\",ROUND(M22/60,2)*I22*$L$16*0.01,\"--\")","v":268.00189586798587},{"$f":"IF(N22=\"RP\",ROUND(M22/60,2)*I22*$L$16*0.01*O22/100,\"--\")","v":"--"},{"$f":"IF(N22=\"F\",I22*$L$16,\"--\")","v":"--"},{"$f":"IF(AND(M22>10,N22=\"F\"),I22*$L$16*IF(M22>180,3,ROUND(M22/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(M22>180,N22=\"F\"),(ROUND(M22/60,2)-3)*I22*$L$16*0.1,\"--\")","v":"--"},{"$f":"IF(N22=\"R\",I22*$L$16*O22/100,\"--\")","v":"--"},{"$f":"IF(AND(M22>10,N22=\"R\"),I22*$L$16*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$16*0.1,\"--\")","v":"--"},{"$f":"IF(N22=\"RF\",ROUND(M22/60,2)*I22*$L$16*0.1,\"--\")","v":"--"},{"$f":"IF(N22=\"RR\",ROUND(M22/60,2)*O22/100*I22*$L$16*0.1,\"--\")","v":"--"},{"$f":"IF(F22=\"\",\"\",\"SI\")","v":"SI"},{"$f":"IF(F22=\"\",\"\",SUM(P22:Y22)*IF(Z22=\"SI\",1,2))","v":268.00189586798587}]
[null,null,4,299982,1635,"S.A. ESTE - VIEDMA",132,162.60000610351562,{"$f":"IF(H23>25,H23,25)*IF(G23=330,$G$15,$G$16)/100","v":113.36797625549316},"2016-03-03T08:07:00","2016-03-03T15:35:00",7.4666666667326353,448,"P","--",254.05763478856016,{"$f":"IF(N23=\"RP\",ROUND(M23/60,2)*I23*$L$16*0.01*O23/100,\"--\")","v":"--"},"--","--","--","--","--","--","--","--","SI",254.05763478856016]
[null,null,5,300272,1635,"S.A. ESTE - VIEDMA",132,162.60000610351562,113.36797625549316,"2016-03-08T08:01:00","2016-03-08T15:54:00",7.8833333333604969,473,"P","--",268.00189586798587,"--","--","--","--","--","--","--","--","--","SI",268.00189586798587]
[null,null,6,300481,1635,"S.A. ESTE - VIEDMA",132,162.60000610351562,113.36797625549316,"2016-03-15T08:19:00","2016-03-15T10:22:00",2.0499999998719431,123,"P","--",69.721305397128276,"--","--","--","--","--","--","--","--","--","SI",69.721305397128276]
[null,null,7,300946,1635,"S.A. ESTE - VIEDMA",132,162.60000610351562,113.36797625549316,"2016-03-30T08:07:00","2016-03-30T15:05:00",6.9666666666744277,418,"P",{"$f":"IF(F26=\"\",\"\",\"--\")","v":"--"},237.0524383502362,"--","--","--","--","--","--","--","--","--","SI",237.0524383502362]
[null,null,null,null,null,null,null,null,17.430499999999999,null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--",{"$f":"IF(F27=\"\",\"\",\"SI\")","v":""},""]
[null,null,null,null,null,null,null,null,17.430499999999999,null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,17.430499999999999,null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,17.430499999999999,null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,17.430499999999999,null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,17.430499999999999,null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,17.430499999999999,null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,17.430499999999999,null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,17.430499999999999,null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,17.430499999999999,null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,17.430499999999999,null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,17.430499999999999,null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,{"$f":"IF(H39>25,H39,25)*IF(G39=330,$G$15,$G$16)/100","v":17.430499999999999},null,null,"","",null,"","--",{"$f":"IF(N39=\"RP\",ROUND(M39/60,2)*I39*$L$16*0.01*O39/100,\"--\")","v":"--"},"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,{"$f":"IF(H40>25,H40,25)*IF(G40=330,$G$15,$G$16)/100","v":17.430499999999999},null,null,"","",null,"","--",{"$f":"IF(N40=\"RP\",ROUND(M40/60,2)*I40*$L$16*0.01*O40/100,\"--\")","v":"--"},"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,{"$f":"IF(H41>25,H41,25)*IF(G41=330,$G$15,$G$16)/100","v":17.430499999999999},null,null,"","",null,"","--",{"$f":"IF(N41=\"RP\",ROUND(M41/60,2)*I41*$L$16*0.01*O41/100,\"--\")","v":"--"},"--","--","--","--","--","--","--","--","",""]
[]
[null,null,"(²)","P - PROGRAMADA",null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(P20:P42),2)","v":1096.8399999999999},0,0,0,0,0,0,0,0,0,null,{"$f":"ROUND(SUM(AA20:AA42),2)","v":1096.8399999999999}]

{"sheet":"TR-03 (1)","index":3,"n_rows":45,"n_cols":29,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"+'TOT-0316'!B2","v":"ANEXO III 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-0316'!B14","v":"Desde el 01 al 31 de Marzo 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,{"$f":"30*'TOT-0316'!B13","v":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,8,299979,1797,"PLANTA DE ALUMINIO DGPA","TRAFO 4",40,"132/33/13,2",{"$f":"H24*$I$18","v":36.36},"2016-03-05T08:30:00","2016-03-05T09:03:00",{"$f":"IF(F24=\"\",\"\",(L24-K24)*24)","v":0.55000000004656613},{"$f":"IF(F24=\"\",\"\",ROUND((L24-K24)*24*60,0))","v":33},"F",{"$f":"IF(F24=\"\",\"\",IF(OR(O24=\"P\",O24=\"RP\"),\"--\",\"NO\"))","v":"NO"},{"$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":3},{"$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":109.08},{"$f":"IF(O24=\"F\",J24*S24*ROUND(N24/60,2),\"--\")","v":59.994000000000007},{"$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":169.07400000000001}]
[null,null,9,299980,1797,"PLANTA DE ALUMINIO DGPA","TRAFO 4",40,"132/33/13,2",36.36,"2016-03-06T08:09:00","2016-03-06T09:04:00",0.91666666668606922,55,"F","NO","--","NO",3,"--","--",109.08,100.3536,"--","--","--","--","SI",209.43360000000001]
[null,null,10,300267,1797,"PLANTA DE ALUMINIO DGPA","TRAFO 4",40,"132/33/13,2",36.36,"2016-03-07T08:48:00","2016-03-07T15:32:00",6.7333333332790062,404,"P","--","--","NO",0.30000000000000004,73.410840000000007,"--","--","--","--","--","--","--","SI",73.410840000000007]
[null,null,11,300268,1796,"PICO TRUNCADO 1 ","TRAFO 2",5,"33/13,2",4.5449999999999999,"2016-03-07T09:00:00","2016-03-11T11:47:00",98.783333333325572,5927,"P","--","--","NO",0.30000000000000004,134.68653,"--","--","--","--","--","--","--","SI",134.68653]
[null,null,12,300269,1797,"PLANTA DE ALUMINIO DGPA","TRAFO 4",40,"132/33/13,2",36.36,"2016-03-08T09:53:00","2016-03-08T13:49:00",3.9333333332324401,236,"P","--","--","NO",0.30000000000000004,42.868440000000007,"--","--","--","--","--","--","--","SI",42.868440000000007]
[null,null,13,300270,1798,"PLANTA DE ALUMINIO DGPA","TRAFO 2",40,"132/33/13,2",36.36,"2016-03-09T09:16:00","2016-03-09T15:26:00",6.1666666666860692,370,"P","--","--","NO",{"$f":"$I$19*IF(OR(O29=\"P\",O29=\"RP\"),0.1,1)*IF(R29=\"SI\",1,0.1)","v":0.30000000000000004},{"$f":"IF(O29=\"P\",J29*S29*ROUND(N29/60,2),\"--\")","v":67.302360000000007},{"$f":"IF(O29=\"RP\",J29*S29*ROUND(N29/60,2)*Q29/100,\"--\")","v":"--"},{"$f":"IF(AND(O29=\"F\",P29=\"NO\"),J29*S29,\"--\")","v":"--"},{"$f":"IF(O29=\"F\",J29*S29*ROUND(N29/60,2),\"--\")","v":"--"},{"$f":"IF(AND(O29=\"R\",P29=\"NO\"),J29*S29*Q29/100,\"--\")","v":"--"},{"$f":"IF(O29=\"R\",J29*S29*ROUND(N29/60,2)*Q29/100,\"--\")","v":"--"},{"$f":"IF(O29=\"RF\",J29*S29*ROUND(N29/60,2),\"--\")","v":"--"},{"$f":"IF(O29=\"RR\",J29*S29*ROUND(N29/60,2)*Q29/100,\"--\")","v":"--"},{"$f":"IF(F29=\"\",\"\",\"SI\")","v":"SI"},{"$f":"IF(F29=\"\",\"\",SUM(T29:AA29)*IF(AB29=\"SI\",1,2))","v":67.302360000000007}]
[null,null,14,300479,5682,"RAWSON","TRAFO 2",15,"132/33/13,2",13.635,"2016-03-15T08:23:00","2016-03-15T11:25:00",3.0333333332673647,182,"P","--","--","NO",0.30000000000000004,12.394215000000001,"--","--","--","--","--","--","--","SI",12.394215000000001]
[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,"","","",{"$f":"$I$19*IF(OR(O40=\"P\",O40=\"RP\"),0.1,1)*IF(R40=\"SI\",1,0.1)","v":3},{"$f":"IF(O40=\"P\",J40*S40*ROUND(N40/60,2),\"--\")","v":"--"},{"$f":"IF(O40=\"RP\",J40*S40*ROUND(N40/60,2)*Q40/100,\"--\")","v":"--"},{"$f":"IF(AND(O40=\"F\",P40=\"NO\"),J40*S40,\"--\")","v":"--"},{"$f":"IF(O40=\"F\",J40*S40*ROUND(N40/60,2),\"--\")","v":"--"},{"$f":"IF(AND(O40=\"R\",P40=\"NO\"),J40*S40*Q40/100,\"--\")","v":"--"},{"$f":"IF(O40=\"R\",J40*S40*ROUND(N40/60,2)*Q40/100,\"--\")","v":"--"},{"$f":"IF(O40=\"RF\",J40*S40*ROUND(N40/60,2),\"--\")","v":"--"},{"$f":"IF(O40=\"RR\",J40*S40*ROUND(N40/60,2)*Q40/100,\"--\")","v":"--"},{"$f":"IF(F40=\"\",\"\",\"SI\")","v":""},{"$f":"IF(F40=\"\",\"\",SUM(T40:AA40)*IF(AB40=\"SI\",1,2))","v":""}]
[null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"IF(F41=\"\",\"\",(L41-K41)*24)","v":""},{"$f":"IF(F41=\"\",\"\",ROUND((L41-K41)*24*60,0))","v":""},null,"","","",{"$f":"$I$19*IF(OR(O41=\"P\",O41=\"RP\"),0.1,1)*IF(R41=\"SI\",1,0.1)","v":3},{"$f":"IF(O41=\"P\",J41*S41*ROUND(N41/60,2),\"--\")","v":"--"},{"$f":"IF(O41=\"RP\",J41*S41*ROUND(N41/60,2)*Q41/100,\"--\")","v":"--"},{"$f":"IF(AND(O41=\"F\",P41=\"NO\"),J41*S41,\"--\")","v":"--"},{"$f":"IF(O41=\"F\",J41*S41*ROUND(N41/60,2),\"--\")","v":"--"},{"$f":"IF(AND(O41=\"R\",P41=\"NO\"),J41*S41*Q41/100,\"--\")","v":"--"},{"$f":"IF(O41=\"R\",J41*S41*ROUND(N41/60,2)*Q41/100,\"--\")","v":"--"},{"$f":"IF(O41=\"RF\",J41*S41*ROUND(N41/60,2),\"--\")","v":"--"},{"$f":"IF(O41=\"RR\",J41*S41*ROUND(N41/60,2)*Q41/100,\"--\")","v":"--"},{"$f":"IF(F41=\"\",\"\",\"SI\")","v":""},{"$f":"IF(F41=\"\",\"\",SUM(T41:AA41)*IF(AB41=\"SI\",1,2))","v":""}]
[null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"IF(F42=\"\",\"\",(L42-K42)*24)","v":""},{"$f":"IF(F42=\"\",\"\",ROUND((L42-K42)*24*60,0))","v":""},null,"","","",{"$f":"$I$19*IF(OR(O42=\"P\",O42=\"RP\"),0.1,1)*IF(R42=\"SI\",1,0.1)","v":3},{"$f":"IF(O42=\"P\",J42*S42*ROUND(N42/60,2),\"--\")","v":"--"},{"$f":"IF(O42=\"RP\",J42*S42*ROUND(N42/60,2)*Q42/100,\"--\")","v":"--"},{"$f":"IF(AND(O42=\"F\",P42=\"NO\"),J42*S42,\"--\")","v":"--"},{"$f":"IF(O42=\"F\",J42*S42*ROUND(N42/60,2),\"--\")","v":"--"},{"$f":"IF(AND(O42=\"R\",P42=\"NO\"),J42*S42*Q42/100,\"--\")","v":"--"},{"$f":"IF(O42=\"R\",J42*S42*ROUND(N42/60,2)*Q42/100,\"--\")","v":"--"},{"$f":"IF(O42=\"RF\",J42*S42*ROUND(N42/60,2),\"--\")","v":"--"},{"$f":"IF(O42=\"RR\",J42*S42*ROUND(N42/60,2)*Q42/100,\"--\")","v":"--"},{"$f":"IF(F42=\"\",\"\",\"SI\")","v":""},{"$f":"IF(F42=\"\",\"\",SUM(T42:AA42)*IF(AB42=\"SI\",1,2))","v":""}]
[null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"IF(F43=\"\",\"\",(L43-K43)*24)","v":""},{"$f":"IF(F43=\"\",\"\",ROUND((L43-K43)*24*60,0))","v":""},null,"","","",{"$f":"$I$19*IF(OR(O43=\"P\",O43=\"RP\"),0.1,1)*IF(R43=\"SI\",1,0.1)","v":3},{"$f":"IF(O43=\"P\",J43*S43*ROUND(N43/60,2),\"--\")","v":"--"},{"$f":"IF(O43=\"RP\",J43*S43*ROUND(N43/60,2)*Q43/100,\"--\")","v":"--"},{"$f":"IF(AND(O43=\"F\",P43=\"NO\"),J43*S43,\"--\")","v":"--"},{"$f":"IF(O43=\"F\",J43*S43*ROUND(N43/60,2),\"--\")","v":"--"},{"$f":"IF(AND(O43=\"R\",P43=\"NO\"),J43*S43*Q43/100,\"--\")","v":"--"},{"$f":"IF(O43=\"R\",J43*S43*ROUND(N43/60,2)*Q43/100,\"--\")","v":"--"},{"$f":"IF(O43=\"RF\",J43*S43*ROUND(N43/60,2),\"--\")","v":"--"},{"$f":"IF(O43=\"RR\",J43*S43*ROUND(N43/60,2)*Q43/100,\"--\")","v":"--"},{"$f":"IF(F43=\"\",\"\",\"SI\")","v":""},{"$f":"IF(F43=\"\",\"\",SUM(T43:AA43)*IF(AB43=\"SI\",1,2))","v":""}]
[]
[null,null,"(²)","P - PROGRAMADA  ; F - FORZADA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T22:T44)","v":330.66238500000003},0,218.16,160.3476,0,0,0,0,null,{"$f":"ROUND(SUM(AC22:AC44),2)","v":709.17}]

{"sheet":"TR-EDERSA-03 (1)","index":4,"n_rows":45,"n_cols":29,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'TOT-0316'!B2","v":"ANEXO III 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 E.D.E.R.S.A."]
[]
[]
[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,0.24299999999999999]
[null,null,null,null,null,"Coeficiente de penalización por salida forzada   =",null,null,{"$f":"30*'TOT-0316'!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,15,300273,4970,"S. ANTONIO ESTE","TRAFO 1",15,"132/33/13,2",{"$f":"H24*$I$17","v":3.645},"2016-03-09T09:22:00","2016-03-09T13:48:00",{"$f":"IF(F24=\"\",\"\",(L24-K24)*24)","v":4.4333333332906477},{"$f":"IF(F24=\"\",\"\",ROUND((L24-K24)*24*60,0))","v":266},"P",{"$f":"IF(F24=\"\",\"\",IF(OR(O24=\"P\",O24=\"RP\"),\"--\",\"NO\"))","v":"--"},{"$f":"IF(F24=\"\",\"\",\"--\")","v":"--"},{"$f":"IF(F24=\"\",\"\",\"NO\")","v":"NO"},{"$f":"$I$18*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":4.8442050000000005},{"$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":"--"},{"$f":"IF(F24=\"\",\"\",\"SI\")","v":"SI"},{"$f":"IF(F24=\"\",\"\",SUM(T24:AA24)*IF(AB24=\"SI\",1,2))","v":4.8442050000000005}]
[null,null,16,300696,1807,"SIERRA GRANDE","TRAFO 10",35,"132/33/13,2",8.504999999999999,"2016-03-22T22:14:00","2016-03-23T04:27:00",6.2166666666744277,373,"F",{"$f":"IF(F25=\"\",\"\",IF(OR(O25=\"P\",O25=\"RP\"),\"--\",\"NO\"))","v":"NO"},"--","NO",3,"--","--",25.514999999999997,158.70329999999998,"--","--","--","--","SI",184.21829999999997]
[null,null,17,300944,1807,"SIERRA GRANDE","TRAFO 10",35,"132/33/13,2",8.504999999999999,"2016-03-28T11:04:00","2016-03-28T15:22:00",4.3000000000465661,258,"P","--","--","NO",0.30000000000000004,10.971449999999999,"--","--","--","--","--","--","--","SI",10.971449999999999]
[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,"","",{"$f":"IF(F31=\"\",\"\",\"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,"(²)"," P - PROGRAMADA  ;  FORZADA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T22:T44)","v":15.815655},0,25.514999999999997,158.70329999999998,0,0,0,0,null,{"$f":"ROUND(SUM(AC22:AC44),2)","v":200.03}]

{"sheet":"SA-03 (1)","index":5,"n_rows":45,"n_cols":22,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'TOT-0316'!B2","v":"ANEXO III 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.- Salidas"]
[]
[null,null,null,null,null,"2.2.1.- Equipamiento propio"]
[]
[null,{"$f":"'TOT-0316'!B14","v":"Desde el 01 al 31 de Marzo de 2016"}]
[]
[null,null,null,null,null,"Salida en 330 kV",30.358000000000001,{"$f":"60*'TOT-0316'!B13","v":60},null,{"$f":"IF(H16=60,\" \",IF(H16=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 = ",12.14,{"$f":"50*'TOT-0316'!B13","v":50},null,{"$f":"IF(H17=50,\" \",IF(H17=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 ",9.1110000000000007,{"$f":"25*'TOT-0316'!B13","v":25},null,{"$f":"IF(H18=25,\" \",IF(H18=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 =",9.1110000000000007,{"$f":"20*'TOT-0316'!B13","v":20},null,{"$f":"IF(H19=20,\" \",IF(H19=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,18,300271,1703,"BARRIO SAN MARTIN","SALIDA ALIMENT. 6 A COOP.",13.2,{"$f":"IF(H24=330,$G$16,IF(AND(H24<=132,H24>=66),$G$17,IF(AND(H24<66,H24>=33),$G$18,$G$19)))","v":9.1110000000000007},"2016-03-10T08:02:00","2016-03-10T11:07:00",{"$f":"IF(F24=\"\",\"\",(K24-J24)*24)","v":3.0833333332557231},{"$f":"IF(F24=\"\",\"\",ROUND((K24-J24)*24*60,0))","v":185},"P",{"$f":"IF(F24=\"\",\"\",IF(N24=\"P\",\"--\",\"NO\"))","v":"--"},{"$f":"IF(H24=330,$H$16,IF(AND(H24<=132,H24>=66),$H$17,IF(AND(H24<66,H24>13.2),$H$18,$H$19)))","v":20},{"$f":"IF(N24=\"P\",I24*P24*ROUND(M24/60,2)*0.1,\"--\")","v":56.123760000000004},{"$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":56.123760000000004}]
[null,null,19,300480,1698,"BARRIO SAN MARTIN","SALIDA ALIMENT. 1 A COOP.",13.2,9.1110000000000007,"2016-03-17T08:00:00","2016-03-17T11:16:00",{"$f":"IF(F25=\"\",\"\",(K25-J25)*24)","v":3.2666666666627862},{"$f":"IF(F25=\"\",\"\",ROUND((K25-J25)*24*60,0))","v":196},"P","--",{"$f":"IF(H25=330,$H$16,IF(AND(H25<=132,H25>=66),$H$17,IF(AND(H25<66,H25>13.2),$H$18,$H$19)))","v":20},{"$f":"IF(N25=\"P\",I25*P25*ROUND(M25/60,2)*0.1,\"--\")","v":59.585940000000008},{"$f":"IF(AND(N25=\"F\",O25=\"NO\"),I25*P25,\"--\")","v":"--"},{"$f":"IF(N25=\"F\",I25*P25*ROUND(M25/60,2),\"--\")","v":"--"},{"$f":"IF(N25=\"RF\",I25*P25*ROUND(M25/60,2),\"--\")","v":"--"},{"$f":"IF(F25=\"\",\"\",\"SI\")","v":"SI"},{"$f":"IF(F25=\"\",\"\",SUM(Q25:T25)*IF(U25=\"SI\",1,2)*IF(H25=\"500/220\",0,1))","v":59.585940000000008}]
[null,null,20,300945,2004,"BARRIO SAN MARTIN","SALIDA ALIMENT. 8 A CONEX.",13.2,9.1110000000000007,"2016-03-30T08:28:00","2016-03-30T11:27:00",2.9833333332790062,179,"P","--",20,54.301560000000009,"--","--","--","SI",54.301560000000009]
[null,null,null,null,null,null,null,null,9.1110000000000007,null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,9.1110000000000007,null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,9.1110000000000007,null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,9.1110000000000007,null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,9.1110000000000007,null,null,"","",null,"",20,"--","--","--","--",{"$f":"IF(F31=\"\",\"\",\"SI\")","v":""},""]
[null,null,null,null,null,null,null,null,9.1110000000000007,null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,9.1110000000000007,null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,9.1110000000000007,null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,9.1110000000000007,null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,9.1110000000000007,null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,9.1110000000000007,null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,9.1110000000000007,null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,9.1110000000000007,null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,9.1110000000000007,null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,{"$f":"IF(H41=330,$G$16,IF(AND(H41<=132,H41>=66),$G$17,IF(AND(H41<66,H41>=33),$G$18,$G$19)))","v":9.1110000000000007},null,null,{"$f":"IF(F41=\"\",\"\",(K41-J41)*24)","v":""},{"$f":"IF(F41=\"\",\"\",ROUND((K41-J41)*24*60,0))","v":""},null,{"$f":"IF(F41=\"\",\"\",IF(N41=\"P\",\"--\",\"NO\"))","v":""},{"$f":"IF(H41=330,$H$16,IF(AND(H41<=132,H41>=66),$H$17,IF(AND(H41<66,H41>13.2),$H$18,$H$19)))","v":20},{"$f":"IF(N41=\"P\",I41*P41*ROUND(M41/60,2)*0.1,\"--\")","v":"--"},{"$f":"IF(AND(N41=\"F\",O41=\"NO\"),I41*P41,\"--\")","v":"--"},{"$f":"IF(N41=\"F\",I41*P41*ROUND(M41/60,2),\"--\")","v":"--"},{"$f":"IF(N41=\"RF\",I41*P41*ROUND(M41/60,2),\"--\")","v":"--"},{"$f":"IF(F41=\"\",\"\",\"SI\")","v":""},{"$f":"IF(F41=\"\",\"\",SUM(Q41:T41)*IF(U41=\"SI\",1,2)*IF(H41=\"500/220\",0,1))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(H42=330,$G$16,IF(AND(H42<=132,H42>=66),$G$17,IF(AND(H42<66,H42>=33),$G$18,$G$19)))","v":9.1110000000000007},null,null,{"$f":"IF(F42=\"\",\"\",(K42-J42)*24)","v":""},{"$f":"IF(F42=\"\",\"\",ROUND((K42-J42)*24*60,0))","v":""},null,{"$f":"IF(F42=\"\",\"\",IF(N42=\"P\",\"--\",\"NO\"))","v":""},{"$f":"IF(H42=330,$H$16,IF(AND(H42<=132,H42>=66),$H$17,IF(AND(H42<66,H42>13.2),$H$18,$H$19)))","v":20},{"$f":"IF(N42=\"P\",I42*P42*ROUND(M42/60,2)*0.1,\"--\")","v":"--"},{"$f":"IF(AND(N42=\"F\",O42=\"NO\"),I42*P42,\"--\")","v":"--"},{"$f":"IF(N42=\"F\",I42*P42*ROUND(M42/60,2),\"--\")","v":"--"},{"$f":"IF(N42=\"RF\",I42*P42*ROUND(M42/60,2),\"--\")","v":"--"},{"$f":"IF(F42=\"\",\"\",\"SI\")","v":""},{"$f":"IF(F42=\"\",\"\",SUM(Q42:T42)*IF(U42=\"SI\",1,2)*IF(H42=\"500/220\",0,1))","v":""}]
[null,null,null,null,null,null,null,null,{"$f":"IF(H43=330,$G$16,IF(AND(H43<=132,H43>=66),$G$17,IF(AND(H43<66,H43>=33),$G$18,$G$19)))","v":9.1110000000000007},null,null,{"$f":"IF(F43=\"\",\"\",(K43-J43)*24)","v":""},{"$f":"IF(F43=\"\",\"\",ROUND((K43-J43)*24*60,0))","v":""},null,{"$f":"IF(F43=\"\",\"\",IF(N43=\"P\",\"--\",\"NO\"))","v":""},{"$f":"IF(H43=330,$H$16,IF(AND(H43<=132,H43>=66),$H$17,IF(AND(H43<66,H43>13.2),$H$18,$H$19)))","v":20},{"$f":"IF(N43=\"P\",I43*P43*ROUND(M43/60,2)*0.1,\"--\")","v":"--"},{"$f":"IF(AND(N43=\"F\",O43=\"NO\"),I43*P43,\"--\")","v":"--"},{"$f":"IF(N43=\"F\",I43*P43*ROUND(M43/60,2),\"--\")","v":"--"},{"$f":"IF(N43=\"RF\",I43*P43*ROUND(M43/60,2),\"--\")","v":"--"},{"$f":"IF(F43=\"\",\"\",\"SI\")","v":""},{"$f":"IF(F43=\"\",\"\",SUM(Q43:T43)*IF(U43=\"SI\",1,2)*IF(H43=\"500/220\",0,1))","v":""}]
[]
[null,null,"(²)","P - PROGRAMADA",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q22:Q44)","v":170.01126000000002},{"$f":"SUM(R22:R44)","v":0},{"$f":"SUM(S22:S44)","v":0},{"$f":"SUM(T22:T44)","v":0},null,{"$f":"ROUND(SUM(V22:V44),2)","v":170.01}]

{"sheet":"SA-EDERSA-03 (1)","index":6,"n_rows":45,"n_cols":22,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"+'TOT-0316'!B2","v":"ANEXO III 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.2.- Transportista Independiente E.D.E.R.S.A."]
[]
[null,{"$f":"+'TOT-0316'!B14","v":"Desde el 01 al 31 de Marzo de 2016"}]
[]
[]
[null,null,null,null,null,"Salida en 330 kV"," - ",{"$f":"60*'TOT-0316'!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 = ",3.2429999999999999,{"$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 33 kV ",2.4329999999999998,{"$f":"25*'TOT-0316'!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-0316'!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,21,300274,4893,"VIEDMA","SALIDA ALIM. 4 VIEDMA",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-03-07T13:00:00","2016-03-07T14:41:00",{"$f":"IF(F24=\"\",\"\",(K24-J24)*24)","v":1.683333333407063},{"$f":"IF(F24=\"\",\"\",ROUND((K24-J24)*24*60,0))","v":101},"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":8.1748799999999999},{"$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":8.1748799999999999}]
[null,null,22,300677,1773,"VIEDMA","SALIDA ALIM. 5 VIEDMA 2",13.2,2.4329999999999998,"2016-03-22T13:08:00","2016-03-22T13:38:00",{"$f":"IF(F25=\"\",\"\",(K25-J25)*24)","v":0.50000000005820766},{"$f":"IF(F25=\"\",\"\",ROUND((K25-J25)*24*60,0))","v":30},"P","--",20,2.4329999999999998,"--","--","--","SI",2.4329999999999998]
[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,{"$f":"IF(F27=\"\",\"\",IF(N27=\"P\",\"--\",\"NO\"))","v":""},{"$f":"IF(H27=330,$H$15,IF(AND(H27<=132,H27>=66),$H$16,IF(AND(H27<66,H27>13.2),$H$17,$H$18)))","v":20},{"$f":"IF(N27=\"P\",I27*P27*ROUND(M27/60,2)*0.1,\"--\")","v":"--"},{"$f":"IF(AND(N27=\"F\",O27=\"NO\"),I27*P27,\"--\")","v":"--"},{"$f":"IF(N27=\"F\",I27*P27*ROUND(M27/60,2),\"--\")","v":"--"},{"$f":"IF(N27=\"RF\",I27*P27*ROUND(M27/60,2),\"--\")","v":"--"},{"$f":"IF(F27=\"\",\"\",\"SI\")","v":""},""]
[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":10.61},{"$f":"SUM(R22:R44)","v":0},{"$f":"SUM(S22:S44)","v":0},{"$f":"SUM(T22:T44)","v":0},null,{"$f":"SUM(V22:V44)","v":10.60788}]

{"sheet":"SUP-EDERSA","index":7,"n_rows":57,"n_cols":14,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'TOT-0316'!B2","v":"ANEXO III 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-0316'!B14","v":"Desde el 01 al 31 de Marzo 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":744},"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,4107.49,null,null,"SEGÚN 1.2."]
[null,null,null,null,null,"TRANSFORMACIÓN",null,null,748.28,null,null,"SEGÚN 2.1.2."]
[null,null,null,null,null,"SALIDAS",null,null,39.72,null,null,"SEGÚN 2.2.2."]
[]
[null,null,null,null,null,null,null,"SM =",{"$f":"SUM(I22:I25)","v":4895.49}]
[]
[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":60219.87335999999},0,"(DTE 0316)",null,{"$f":"SUM(H31:K31)","v":60219.87335999999}]
[null,null,null,"S.A. OESTE - SIERRA GRANDE",132,110.3,null,{"$f":"F32*$J$17*$E$17/100","v":214266.19456799998},13820,"(DTE 0316)",null,{"$f":"SUM(H32:K32)","v":228086.19456799998}]
[null,null,null,"S.A. OESTE - VIEDMA",132,185.6,null,{"$f":"F33*$J$17*$E$17/100","v":360542.20953599998},11599,"(DTE 0316)",null,{"$f":"SUM(H33:K33)","v":372141.20953599998}]
[null,null,null,"VIEDMA - CARMEN DE PATAGONES",132,7,null,{"$f":"F34*$J$17*$E$17/100","v":13598.03592},1,"(DTE 0316)",null,{"$f":"SUM(H34:K34)","v":13599.03592}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L31:L34)","v":674046.31338399998}]
[]
[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":20288.88},null,"C. DE PATAGONES",null,"Salida Viedma",132,{"$f":"M16*E17","v":9032.16}]
[null,null,null,"SIERRA GRANDE","Tr 1, 2, 4 y 5",88,null,{"$f":"+F39*$J$18*$E$17","v":59514.048000000003},null,"SAN ANTONIO ESTE",null,"Salida Conesa y SA Oeste",33,{"$f":"+M17*E17*2","v":13557.168000000001}]
[null,null,null,"SAN ANTONIO ESTE","TRAFO 1",7.5,null,{"$f":"+F40*$J$18*$E$17","v":5072.22},null,"SAN ANTONIO OESTE",null,"Salidas Valcheta, SA Oeste y SA Este",33,{"$f":"3*M17*E17","v":20335.752}]
[null,null,null,"SAN ANTONIO OESTE","TRAFO 1",15,null,{"$f":"+F41*$J$18*$E$17","v":10144.44},null,"VIEDMA",null,"Alimentadores 1,2,3,5,6 y 8",13.2,{"$f":"+M18*E17*6","v":40671.504000000001}]
[null,null,null,"VIEDMA","TRAFOS 1 y 2",30,null,{"$f":"+F42*$J$18*$E$17","v":20288.88},null,"PUNTA COLORADA",null,"Alimentadores en 33 y 6,6 (2)",null,{"$f":"+M17*E17+M18*E17*2","v":20335.752}]
[null,null,null,null,null,null,null,{"$f":"SUM(H38:H42)","v":115308.46800000001},null,"SIERRA GRANDE",null,"Salidas en 132, 33, 13,2 (3), 6,6 (2)",null,{"$f":"(M16+M17+M18*5)*E17","v":49703.664000000012}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N38:N43)","v":153636.00000000003}]
[]
[null,null,null,null,null,null,null,"RM =",{"$f":"+H43+N44+L35","v":942990.78138400009},null,"RM * =",270478.16795199999]
[]
[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":6761.9541988000001},null,"RM * = VALOR EMPLEADO PARA CALCULAR \"CS\""]
[]
[null,null,"e) SANCIÓN"]
[null,null,null,"Sanción Calculada",{"$f":"10*I26*I50/I46","v":351.04350767988404}]
[]
[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":351.04350767988404}]

{"sheet":"DATO","index":8,"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,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\\TRANSPA\\\" &E14","v":"\\\\rugor\\files\\Transporte\\Transporte\\AA PROCESO AUT ARCHIVOS J\\TRANSPA\\2016"},null,null,null,null,{"$f":"\"J\"&G14&H14&\"TPA\"","v":"J0316TPA"}]
[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",22,20,12,{"$f":"\"LI-\" & $G$14","v":"LI-03"},"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-03"},"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-03"},"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-03"},"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-03"},"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-03"},"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-03"},"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-03"},"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-03"},"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-03"},"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-03"},"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-03"},"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-03"},"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]