{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["TOT-0216","LI-02 (1)","LI-EDERSA-02 (1)","LI-TRANSACUE-02 (1)","TR-02 (1)","TR-EDERSA-02 (1)","TR-TRANSACUE-02 (1)","SA-02 (1)","SA-EDERSA-02 (1)","SA-TRANSACUE-02 (1)","SUP-EDERSA","SUP-TRANSACUE","DATO"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":4,"defined_names":90,"comments":3,"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-0216","index":0,"n_rows":40,"n_cols":9,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
[]
[null,"ANEXO II 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,{"$f":"DATO!F14","v":"Desde el 01 al 29 de febrero 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-02 (1)'!AA43","v":2914.52}]
[null,null,null,"1.2.-","Transportista Independiente E.D.E.R.S.A.",null,null,null,{"$f":"'LI-EDERSA-02 (1)'!AA43","v":5284.37}]
[null,null,null,"1.3.-","Transportista Independiente TRANSACUE S.A.",null,null,null,{"$f":"'LI-TRANSACUE-02 (1)'!AA43","v":3667.36}]
[]
[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-02 (1)'!AC45","v":617.16}]
[null,null,null,null,"2.1.2.-","Transportista Independiente E.D.E.R.S.A.",null,null,{"$f":"'TR-EDERSA-02 (1)'!AC45","v":148.93}]
[null,null,null,null,"2.1.3.-","Transportista Independiente TRANSACUE S.A.",null,null,{"$f":"'TR-TRANSACUE-02 (1)'!AC45","v":936.04}]
[]
[null,null,null,"2.2.-","Salidas"]
[null,null,null,null,"2.2.1.-","Equipamiento propio",null,null,{"$f":"'SA-02 (1)'!V45","v":91.05}]
[null,null,null,null,"2.2.2.-","Transportista Independiente E.D.E.R.S.A.",null,null,{"$f":"'SA-EDERSA-02 (1)'!V45","v":165.44399999999999}]
[null,null,null,null,"2.2.3.-","Transportista Independiente TRANSACUE S.A.",null,null,{"$f":"'SA-TRANSACUE-02 (1)'!V45","v":229.31024999999997}]
[]
[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":1490.8723744089557}]
[null,null,null,"3.2.-","Transportista Independiente TRANSACUE S.A.",null,null,null,{"$f":"'SUP-TRANSACUE'!I55","v":4523.4825000000001}]
[]
[null,null,null,null,null,"TOTAL ",{"$f":"SUM(I17:I36)","v":20068.539124408955}]
[]
[null,null,"Valores remuneratorios de acuerdo al Acuerdo S.E.E. - ENRE - TRANSPA S.A. 2016-2017"]

{"sheet":"LI-02 (1)","index":1,"n_rows":43,"n_cols":27,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"+'TOT-0216'!B2","v":"ANEXO II 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-0216'!B14","v":"Desde el 01 al 29 de febrero 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-0216'!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,298650,2034,"FLORENTINO AMEGHINO - ESTACION PATAGONIA",132,299.60000610351562,{"$f":"IF(H22>25,H22,25)*IF(G22=330,$G$16,$G$17)/100","v":782.25261993621825},"2016-02-02T09:00:00","2016-02-02T16:03:00",{"$f":"IF(F22=\"\",\"\",(K22-J22)*24)","v":7.0499999999301508},{"$f":"IF(F22=\"\",\"\",ROUND((K22-J22)*24*60,0))","v":423},"P","0,000",{"$f":"IF(N22=\"P\",ROUND(M22/60,2)*I22*$L$17*0.01,\"--\")","v":1654.4642911651015},{"$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":1654.4642911651015}]
[null,null,2,298652,1631,"PTO. MADRYN - SIERRA GRANDE",132,121.5,317.23528499999998,"2016-02-04T06:59:00","2016-02-04T11:29:00",4.5,270,"P","0,000",428.26763474999996,"--","--","--","--","--","--","--","--","--","SI",428.26763474999996]
[null,null,3,299731,1631,"PTO. MADRYN - SIERRA GRANDE",132,121.5,317.23528499999998,"2016-02-22T06:30:00","2016-02-22T09:52:00",3.3666666666395031,202,"P","0,000",320.72487313499994,"--","--","--","--","--","--","--","--","--","SI",320.72487313499994]
[null,null,4,299732,1631,"PTO. MADRYN - SIERRA GRANDE",132,121.5,317.23528499999998,"2016-02-24T05:50:00","2016-02-24T08:35:00",2.7500000000582077,165,"P","0,000",261.71911012499999,"--","--","--","--","--","--","--","--","--","SI",261.71911012499999]
[null,null,5,299735,1631,"PTO. MADRYN - SIERRA GRANDE",132,121.5,317.23528499999998,"2016-02-25T05:51:00","2016-02-25T08:28:00",2.6166666666395031,157,"P","0,000",249.34693400999998,"--","--","--","--","--","--","--","--","--","SI",249.34693400999998]
[null,null,null,null,null,null,null,null,65.274749999999997,null,null,"","",null,{"$f":"IF(F27=\"\",\"\",\"--\")","v":""},"--","--","--","--","--","--","--","--","--","--",{"$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,"",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",null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(P20:P42),2)","v":2914.52},0,0,0,0,0,0,0,0,0,null,{"$f":"ROUND(SUM(AA20:AA42),2)","v":2914.52}]

{"sheet":"LI-EDERSA-02 (1)","index":2,"n_rows":43,"n_cols":27,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"+'TOT-0216'!B2","v":"ANEXO II 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-0216'!B14","v":"Desde el 01 al 29 de febrero 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-0216'!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,6,298928,1634,"S.A. OESTE - S.A. ESTE",132,23,{"$f":"IF(H22>25,H22,25)*IF(G22=330,$G$15,$G$16)/100","v":17.430499999999999},"2016-02-10T12:15:00","2016-02-10T12:20:00",{"$f":"IF(F22=\"\",\"\",(K22-J22)*24)","v":8.3333333430346102E-2},{"$f":"IF(F22=\"\",\"\",ROUND((K22-J22)*24*60,0))","v":5},"F","0,000",{"$f":"IF(N22=\"P\",ROUND(M22/60,2)*I22*$L$16*0.01,\"--\")","v":"--"},{"$f":"IF(N22=\"RP\",ROUND(M22/60,2)*I22*$L$16*0.01*O22/100,\"--\")","v":"--"},{"$f":"IF(N22=\"F\",I22*$L$16,\"--\")","v":522.91499999999996},{"$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":"--"},"SI",{"$f":"IF(F22=\"\",\"\",SUM(P22:Y22)*IF(Z22=\"SI\",1,2))","v":522.91499999999996}]
[null,null,7,299447,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-02-18T09:08:00","2016-02-18T09:32:00",0.39999999990686774,24,"F","0,000","--",{"$f":"IF(N23=\"RP\",ROUND(M23/60,2)*I23*$L$16*0.01*O23/100,\"--\")","v":"--"},3401.0392876647948,1360.415715065918,"--","--","--","--","--","--","SI",4761.4550027307123]
[null,null,null,null,null,null,null,null,17.430499999999999,null,null,"","",null,null,"--","--","--","--","--","--","--","--","--","--",null,""]
[null,null,null,null,null,null,null,null,17.430499999999999,null,null,"","",null,{"$f":"IF(F25=\"\",\"\",\"--\")","v":""},"--","--","--","--","--","--","--","--","--","--",{"$f":"IF(F25=\"\",\"\",\"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,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  ; F - FORZADA",null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(P20:P42),2)","v":0},0,3923.95,1360.42,0,0,0,0,0,0,null,{"$f":"ROUND(SUM(AA20:AA42),2)","v":5284.37}]

{"sheet":"LI-TRANSACUE-02 (1)","index":3,"n_rows":43,"n_cols":27,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'TOT-0216'!B2","v":"ANEXO II 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.4.- Transportista Independiente TRANSACUE S.A."]
[]
[null,{"$f":"'TOT-0216'!B14","v":"Desde el 01 al 29 de febrero 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-0216'!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,8,299448,4586,"ESQUEL - EL COIHUE",132,127.98,{"$f":"IF(H22>25,H22,25)*IF(G22=330,$G$15,$G$16)/100","v":89.230215599999994},"2016-02-15T03:36:00","2016-02-15T03:58:00",{"$f":"IF(F22=\"\",\"\",(K22-J22)*24)","v":0.36666666663950309},{"$f":"IF(F22=\"\",\"\",ROUND((K22-J22)*24*60,0))","v":22},"F",{"$f":"IF(F22=\"\",\"\",\"--\")","v":"--"},{"$f":"IF(N22=\"P\",ROUND(M22/60,2)*I22*$L$16*0.01,\"--\")","v":"--"},{"$f":"IF(N22=\"RP\",ROUND(M22/60,2)*I22*$L$16*0.01*O22/100,\"--\")","v":"--"},{"$f":"IF(N22=\"F\",I22*$L$16,\"--\")","v":2676.9064679999997},{"$f":"IF(AND(M22>10,N22=\"F\"),I22*$L$16*IF(M22>180,3,ROUND(M22/60,2)),\"--\")","v":990.45539315999986},{"$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":3667.3618611599995}]
[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,null,null,null,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,{"$f":"IF(F34=\"\",\"\",\"--\")","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,"(²)","F - FORZADA",null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(P20:P42),2)","v":0},0,2676.91,990.46,0,0,0,0,0,0,null,{"$f":"ROUND(SUM(AA20:AA42),2)","v":3667.36}]

{"sheet":"TR-02 (1)","index":4,"n_rows":45,"n_cols":29,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"+'TOT-0216'!B2","v":"ANEXO II 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-0216'!B14","v":"Desde el 01 al 29 de febrero 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-0216'!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,9,298651,1798,"PLANTA DE ALUMINIO DGPA","TRAFO 2",40,"132/33/13,2",{"$f":"H24*$I$18","v":36.36},"2016-02-03T08:32:00","2016-02-03T13:23:00",{"$f":"IF(F24=\"\",\"\",(L24-K24)*24)","v":4.8499999999185093},{"$f":"IF(F24=\"\",\"\",ROUND((L24-K24)*24*60,0))","v":291},"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":52.903800000000004},{"$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":52.903800000000004}]
[null,null,10,299446,1788,"COMODORO RIVADAVIA A1","TRAFO 5",30,"132/33/13,2",27.27,"2016-02-17T10:13:00","2016-02-17T13:01:00",2.8000000000465661,168,"P","--","--","NO",0.30000000000000004,22.9068,"--","--","--","--","--","--","--","SI",22.9068]
[null,null,11,299733,5682,"RAWSON","TRAFO 2",15,"132/33/13,2",13.635,"2016-02-24T08:47:00","2016-02-24T14:32:00",5.7500000000582077,345,"P","--","--","NO",0.30000000000000004,23.520375000000001,"--","--","--","--","--","--","--","SI",23.520375000000001]
[null,null,12,299734,1788,"COMODORO RIVADAVIA A1","TRAFO 5",30,"132/33/13,2",27.27,"2016-02-24T08:59:00","2016-02-24T09:33:00",0.56666666676755995,34,"P","--","--","NO",0.30000000000000004,4.66317,"--","--","--","--","--","--","--","SI",4.66317]
[null,null,13,299736,1797,"PLANTA DE ALUMINIO DGPA","TRAFO 4",40,"132/33/13,2",36.36,"2016-02-25T07:23:00","2016-02-25T08:58:00",1.5833333334303461,95,"F","NO","--","NO",3,"--","--",109.08,172.34640000000002,"--","--","--","--","SI",281.4264]
[null,null,14,299737,4749,"RAWSON","TRAFO 1",15,"132/33/13,2",13.635,"2016-02-26T08:01:00","2016-02-26T14:32:00",6.5166666667792015,391,"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":26.670060000000003},{"$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":26.670060000000003}]
[null,null,15,299739,1797,"PLANTA DE ALUMINIO DGPA","TRAFO 4",40,"132/33/13,2",36.36,"2016-02-27T17:28:00","2016-02-27T18:21:00",0.88333333324408159,53,"F","NO","--","NO",3,"--","--",109.08,95.990399999999994,"--","--","--","--","SI",205.07040000000001]
[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":130.66420500000001},0,218.16,268.33680000000004,0,0,0,0,null,{"$f":"ROUND(SUM(AC22:AC44),2)","v":617.16}]

{"sheet":"TR-EDERSA-02 (1)","index":5,"n_rows":45,"n_cols":29,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'TOT-0216'!B2","v":"ANEXO II 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-0216'!B14","v":"Desde el 01 al 29 de febrero 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-0216'!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,16,299740,1812,"VIEDMA","TRAFO 4",15,"132/33/13,2",{"$f":"H24*$I$17","v":3.645},"2016-02-29T13:14:00","2016-02-29T13:20:00",{"$f":"IF(F24=\"\",\"\",(L24-K24)*24)","v":9.9999999976716936E-2},{"$f":"IF(F24=\"\",\"\",ROUND((L24-K24)*24*60,0))","v":6},"R",{"$f":"IF(F24=\"\",\"\",IF(OR(O24=\"P\",O24=\"RP\"),\"--\",\"NO\"))","v":"NO"},60,"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":"--"},{"$f":"IF(O24=\"F\",J24*S24*ROUND(N24/60,2),\"--\")","v":"--"},{"$f":"IF(AND(O24=\"R\",P24=\"NO\"),J24*S24*Q24/100,\"--\")","v":65.61},{"$f":"IF(O24=\"R\",J24*S24*ROUND(N24/60,2)*Q24/100,\"--\")","v":6.5609999999999999},{"$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":72.170999999999992}]
[null,null,17,299741,1813,"VIEDMA","TRAFO 5",15,"132/33/13,2",3.645,"2016-02-29T13:14:00","2016-02-29T13:24:00",0.16666666668606922,10,"R",{"$f":"IF(F25=\"\",\"\",IF(OR(O25=\"P\",O25=\"RP\"),\"--\",\"NO\"))","v":"NO"},60,"SI",30,"--","--","--","--",65.61,11.153700000000001,"--","--","SI",76.7637]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"",{"$f":"IF(F26=\"\",\"\",\"--\")","v":""},null,3,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","",{"$f":"IF(F27=\"\",\"\",\"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,"(²)"," R - REDUCCIÓN FORZADA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T22:T44)","v":0},0,0,0,131.22,17.714700000000001,0,0,null,{"$f":"ROUND(SUM(AC22:AC44),2)","v":148.93}]

{"sheet":"TR-TRANSACUE-02 (1)","index":6,"n_rows":45,"n_cols":29,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'TOT-0216'!B2","v":"ANEXO II 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.3.- Transportista Independiente TRANSACUE S.A."]
[]
[]
[null,{"$f":"'TOT-0216'!B14","v":"Desde el 01 al 29 de febrero 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-0216'!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,18,298653,4587,"EL COIHUE","TRAFO 1",15,"132/33/6,6",{"$f":"H24*$I$17","v":3.645},"2016-02-04T20:40:00","2016-02-04T23:30:00",{"$f":"IF(F24=\"\",\"\",(L24-K24)*24)","v":2.8333333333139308},{"$f":"IF(F24=\"\",\"\",ROUND((L24-K24)*24*60,0))","v":170},"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":109.35},{"$f":"IF(O24=\"F\",J24*S24*ROUND(N24/60,2),\"--\")","v":309.46049999999997},{"$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":418.81049999999993}]
[null,null,19,299449,4587,"EL COIHUE","TRAFO 1",15,"132/33/6,6",3.645,"2016-02-15T03:36:00","2016-02-15T07:20:00",3.7333333332790062,224,"F",{"$f":"IF(F25=\"\",\"\",IF(OR(O25=\"P\",O25=\"RP\"),\"--\",\"NO\"))","v":"NO"},"--","SI",30,"--","--",109.35,407.87549999999999,"--","--","--","--","SI",517.22550000000001]
[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,218.7,717.33600000000001,0,0,0,0,null,{"$f":"ROUND(SUM(AC22:AC44),2)","v":936.04}]

{"sheet":"SA-02 (1)","index":7,"n_rows":45,"n_cols":22,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'TOT-0216'!B2","v":"ANEXO II 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-0216'!B14","v":"Desde el 01 al 29 de febrero de 2016"}]
[]
[null,null,null,null,null,"Salida en 330 kV",30.358000000000001,{"$f":"60*'TOT-0216'!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-0216'!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-0216'!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-0216'!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,20,299738,3794,"EL TORDILLO","SALIDA ALIMENT. 124 TECPETROL",132,{"$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":12.14},"2016-02-26T08:24:00","2016-02-26T09:54:00",{"$f":"IF(F24=\"\",\"\",(K24-J24)*24)","v":1.5},{"$f":"IF(F24=\"\",\"\",ROUND((K24-J24)*24*60,0))","v":90},"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":50},{"$f":"IF(N24=\"P\",I24*P24*ROUND(M24/60,2)*0.1,\"--\")","v":91.050000000000011},{"$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":"--"},"SI",{"$f":"IF(F24=\"\",\"\",SUM(Q24:T24)*IF(U24=\"SI\",1,2)*IF(H24=\"500/220\",0,1))","v":91.050000000000011}]
[]
[]
[null,null,null,null,null,null,null,null,9.1110000000000007,null,null,"","",null,"",20,"--","--","--","--",{"$f":"IF(F27=\"\",\"\",\"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,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":91.050000000000011},{"$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":91.05}]

{"sheet":"SA-EDERSA-02 (1)","index":8,"n_rows":45,"n_cols":22,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"+'TOT-0216'!B2","v":"ANEXO II 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-0216'!B14","v":"Desde el 01 al 29 de febrero de 2016"}]
[]
[]
[null,null,null,null,null,"Salida en 330 kV"," - ",{"$f":"60*'TOT-0216'!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-0216'!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-0216'!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-0216'!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,299747,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-02-29T13:14:00","2016-02-29T15:38:00",{"$f":"IF(F24=\"\",\"\",(K24-J24)*24)","v":2.3999999999650754},{"$f":"IF(F24=\"\",\"\",ROUND((K24-J24)*24*60,0))","v":144},"F",{"$f":"IF(F24=\"\",\"\",IF(N24=\"P\",\"--\",\"NO\"))","v":"NO"},{"$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":"--"},{"$f":"IF(AND(N24=\"F\",O24=\"NO\"),I24*P24,\"--\")","v":48.66},{"$f":"IF(N24=\"F\",I24*P24*ROUND(M24/60,2),\"--\")","v":116.78399999999999},{"$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":165.44399999999999}]
[null,null,null,null,null,null,null,null,2.4329999999999998,null,null,"","",null,"",20,"--","--","--",{"$f":"IF(N25=\"RF\",I25*P25*ROUND(M25/60,2),\"--\")","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,"--","--","--","--","",""]
[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,"(²)","F - FORZADA",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(Q22:Q44),2)","v":0},{"$f":"SUM(R22:R44)","v":48.66},{"$f":"SUM(S22:S44)","v":116.78399999999999},{"$f":"SUM(T22:T44)","v":0},null,{"$f":"SUM(V22:V44)","v":165.44399999999999}]

{"sheet":"SA-TRANSACUE-02 (1)","index":9,"n_rows":45,"n_cols":22,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'TOT-0216'!B2","v":"ANEXO II 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.3.- Transportista Independiente TRANSACUE S.A."]
[]
[null,{"$f":"'TOT-0216'!B14","v":"Desde el 01 al 29 de febrero de 2016"}]
[]
[]
[null,null,null,null,null,"Salida en 330 kV"," - ",{"$f":"60*'TOT-0216'!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-0216'!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-0216'!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 ="," - ",{"$f":"20*'TOT-0216'!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,22,299453,4588,"EL COIHUE","ALIM. A LAGO PUELO",33,{"$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-02-18T13:02:00","2016-02-18T15:48:00",{"$f":"IF(F24=\"\",\"\",(K24-J24)*24)","v":2.7666666666045785},{"$f":"IF(F24=\"\",\"\",ROUND((K24-J24)*24*60,0))","v":166},"F",{"$f":"IF(F24=\"\",\"\",IF(N24=\"P\",\"--\",\"NO\"))","v":"NO"},{"$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":25},{"$f":"IF(N24=\"P\",I24*P24*ROUND(M24/60,2)*0.1,\"--\")","v":"--"},{"$f":"IF(AND(N24=\"F\",O24=\"NO\"),I24*P24,\"--\")","v":60.824999999999996},{"$f":"IF(N24=\"F\",I24*P24*ROUND(M24/60,2),\"--\")","v":168.48524999999998},{"$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":229.31024999999997}]
[null,null,null,null,null,null,null,null," - ",null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null," - ",null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null," - ",null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null," - ",null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null," - ",null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null," - ",null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null," - ",null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null," - ",null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null," - ",null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null," - ",null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null," - ",null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null," - ",null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null," - ",null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null," - ",null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null," - ",null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null," - ",null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null," - ",null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null," - ",null,null,"","",null,"",20,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null," - ",null,null,"","",null,"",20,"--","--","--","--","",""]
[]
[null,null,"(²)","F - FORZADA",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(SUM(Q22:Q44),2)","v":0},{"$f":"SUM(R22:R44)","v":60.824999999999996},{"$f":"SUM(S22:S44)","v":168.48524999999998},{"$f":"SUM(T22:T44)","v":0},null,{"$f":"SUM(V22:V44)","v":229.31024999999997}]

{"sheet":"SUP-EDERSA","index":10,"n_rows":57,"n_cols":14,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'TOT-0216'!B2","v":"ANEXO II 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":"'[4]TOT-0116'!B14","v":"Desde el 01 al 31 de enero 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,19789.22,null,null,"SEGÚN 1.2."]
[null,null,null,null,null,"TRANSFORMACIÓN",null,null,557.13,null,null,"SEGÚN 2.1.2."]
[null,null,null,null,null,"SALIDAS",null,null,619.54999999999995,null,null,"SEGÚN 2.2.2."]
[]
[null,null,null,null,null,null,null,"SM =",{"$f":"SUM(I22:I25)","v":20965.900000000001}]
[]
[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 0216)",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},12091,"(DTE 0216)",null,{"$f":"SUM(H32:K32)","v":226357.19456799998}]
[null,null,null,"S.A. OESTE - VIEDMA",132,185.6,null,{"$f":"F33*$J$17*$E$17/100","v":360542.20953599998},10175,"(DTE 0216)",null,{"$f":"SUM(H33:K33)","v":370717.20953599998}]
[null,null,null,"VIEDMA - CARMEN DE PATAGONES",132,7,null,{"$f":"F34*$J$17*$E$17/100","v":13598.03592},1,"(DTE 0216)",null,{"$f":"SUM(H34:K34)","v":13599.03592}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L31:L34)","v":670893.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":939837.78138400009},null,"RM * =",267325.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":6683.1291988000003},null,"RM * = VALOR EMPLEADO PARA CALCULAR \"CS\""]
[]
[null,null,"e) SANCIÓN"]
[null,null,null,"Sanción Calculada",{"$f":"10*I26*I50/I46","v":1490.8723744089557}]
[]
[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":1490.8723744089557}]

{"sheet":"SUP-TRANSACUE","index":11,"n_rows":55,"n_cols":14,"rows_kept":55,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'TOT-0216'!B2","v":"ANEXO II 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.4.- SUPERVISIÓN - Transportista Independiente TRANSACUE S.A."]
[]
[null,{"$f":"'[4]TOT-0116'!B14","v":"Desde el 01 al 31 de enero de 2016"}]
[]
[]
[]
[null,null,"a) Datos"]
[null,null,null,null,null,null,null,null,null,null,null,"Salida en 132 kV= ",3.2429999999999999]
[null,null,null,"Tiempo de servicio =",{"$f":"MID(B11,16,2)*24","v":744},"hs",null,null,"$/100 km-h : LÍNEAS 132 kV ",69.721999999999994,null,"Salida en 33 kV ",2.4329999999999998]
[null,null,null,"Porcentaje por Supervisión  =",2.5000000000000001E-2,null,null,null,"Cargo por Transformador por MVA = ",0.24299999999999999,null,"Salida en 13,2 kV ="," - "]
[]
[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,13733.75,null,null,"SEGÚN 1.3."]
[null,null,null,null,null,"TRANSFORMACIÓN",null,null,3501.47,null,null,"SEGÚN 2.1.3."]
[null,null,null,null,null,"SALIDAS",null,null,858.71,null,null,"SEGÚN 2.2.3."]
[]
[null,null,null,null,null,null,null,"SM =",{"$f":"SUM(I22:I25)","v":18093.93}]
[]
[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,"E.T. PATAGONIA - P. CASTILLO",132,42.6,null,{"$f":"F31*$J$17*$E$17/100","v":22097.969567999997},36992,"(DTE 0216)",null,{"$f":"SUM(H31:K31)","v":59089.969568}]
[null,null,null,"P. CASTILLO - VALLE HERMOSO",132,33.6,null,{"$f":"F32*$J$17*$E$17/100","v":17429.384448000001},9966,"(DTE 0216)",null,{"$f":"SUM(H32:K32)","v":27395.384448000001}]
[null,null,null,"VALLE HERMOSO - CERRO NEGRO",132,41,null,{"$f":"F33*$J$17*$E$17/100","v":21267.998879999999},1024,"(DTE 0216)",null,{"$f":"SUM(H33:K33)","v":22291.998879999999}]
[null,null,null,"ESQUEL - EL COIHUE",132,127.98,null,{"$f":"F34*$J$17*$E$17/100","v":66387.280406399994},4640,"(DTE 0216)",null,{"$f":"SUM(H34:K34)","v":71027.280406399994}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L31:L34)","v":179804.63330240001}]
[]
[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,null,null,null,null,{"$f":"+F38*$J$18*$E$17","v":0},null,"VALLE HERMOSO",null,"4 SALIDAS",132,{"$f":"$M$16*$E$17*4","v":9651.1679999999997}]
[null,null,null,null,null,null,null,{"$f":"+F39*$J$18*$E$17","v":0},null,"CERRO NEGRO",null,"1 SALIDA",132,{"$f":"$M$16*$E$17","v":2412.7919999999999}]
[null,null,null,null,null,null,null,{"$f":"+F39*$J$18*$E$17","v":0},null,"PAMPA DEL CASTILLO",null,"2 SALIDAS",132,{"$f":"$M$16*$E$17*2","v":4825.5839999999998}]
[null,null,null,null,null,null,null,{"$f":"SUM(H38:H40)","v":0},null,"EL COIHUE",null,"3 SALIDAS",33,{"$f":"$M$17*$E$17*3","v":5430.4559999999992}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N38:N41)","v":22319.999999999996}]
[]
[null,null,null,null,null,null,null,"RM =",{"$f":"+H41+N42+L35","v":202124.63330240001},null,"RM*  =",202124.63330240001]
[]
[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":5053.1158325600009},null,"RM* = VALOR EMPLEADO PARA CALCULAR CS"]
[]
[null,null,"e) SANCIÓN"]
[null,null,null,"Sanción Calculada",{"$f":"10*I26*I48/I44","v":4523.4825000000001}]
[]
[null,null,null,"TOTAL A PENALIZAR A TRANSPA S.A. POR SUPERVISIÓN A TRANSACUE"]
[]
[null,null,null,null,null,null,null,"SANCIÓN  =",{"$f":"IF($E$51>3*I48,3*I48,$E$51)","v":4523.4825000000001}]

{"sheet":"DATO","index":12,"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,2,{"$f":"CELL(\"CONTENIDO\",OFFSET(A1,B14,0))","v":"febrero"},{"$f":"CELL(\"CONTENIDO\",OFFSET(C1,B14,0))","v":29},{"$f":"CELL(\"CONTENIDO\",OFFSET(D1,A14,0))","v":2016},{"$f":"\"Desde el 01 al \" & D14 & \" de \" & C14 & \" de \" & E14","v":"Desde el 01 al 29 de febrero de 2016"},{"$f":"CELL(\"CONTENIDO\",OFFSET(B1,B14,0))","v":"02"},{"$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":"J0216TPA"}]
[null,{"$f":"\"\\\\rugor\\files\\Transporte\\transporte\\AA PROCESO AUT\\INTERCAMBIO\\\" &H14&G14","v":"\\\\rugor\\files\\Transporte\\transporte\\AA PROCESO AUT\\INTERCAMBIO\\1602"}]
["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-02"},"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-02"},"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-02"},"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-02"},"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-02"},"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-02"},"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-02"},"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-02"},"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-02"},"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-02"},"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-02"},"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-02"},"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-02"},"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]