{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["TOT-0416","LI-04 (1)","LI-DPEC-04 (1)","LI-ENECOR-04 (1)","T-04 (1)","T-04 (2)","SA-04 (1)","SUP-DPEC","SUP-ENECOR","DATO"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":4,"defined_names":49,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"TOT-0416","index":0,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[null,"ANEXO IV al Memorandum D.T.E.E. N° 294  /2017"]
[]
["ENTE NACIONAL REGULADOR "]
["DE LA ELECTRICIDAD"]
[]
[null,"SISTEMA DE TRANSPORTE DE ENERGÍA ELÉCTRICA POR DISTRIBUCIÓN TRONCAL"]
[]
[null,"TRANSNEA S.A."]
[]
[null,"TOTAL DE PENALIZACIONES"]
[]
[null,2]
[null,"Desde el 01 al 30 de abril de 2016"]
[]
[null,"Sanciones duplicadas por tasa de falla > 4 Sal. x año/100km."]
[]
[null,null,"1.-","LÍNEAS"]
[]
[null,null,null,"1.1.-","Equipamiento propio",null,null,null,{"$f":"'LI-04 (1)'!AA43","v":582958.64}]
[null,null,null,"1.2.-","Transportista Independiente D.P.E.C.",null,null,null,{"$f":"'LI-DPEC-04 (1)'!AA44","v":17591.82}]
[null,null,null,"1.3.-","Transportista Independiente ENECOR",null,null,null,{"$f":"'LI-ENECOR-04 (1)'!AA44","v":2231.9}]
[]
[null,null,"2.-","CONEXIÓN"]
[]
[null,null,null,"2.1.-","Transformación"]
[null,null,null,null,"2.1.1.-","Equipamiento propio",null,null,{"$f":"+'T-04 (2)'!AC44","v":51113.73}]
[null,null,null,"2.2.-","Salidas"]
[null,null,null,null,"2.2.1.-","Equipamiento propio",null,null,{"$f":"'SA-04 (1)'!V43","v":2453.2399999999998}]
[]
[null,null,"3.-","SUPERVISIÓN"]
[]
[null,null,null,"3.1.-","Transportista Independiente D.P.E.C.",null,null,null,{"$f":"'SUP-DPEC'!I63","v":4396.6364664777684}]
[null,null,null,"3.2.-","Transportista Independiente ENECOR",null,null,null,{"$f":"'SUP-ENECOR'!I44","v":517.97388961977799}]
[]
[]
[null,null,null,null,null,"TOTAL ",{"$f":"SUM(I20:I34)","v":661263.94035609753}]

{"sheet":"LI-04 (1)","index":1,"n_rows":43,"n_cols":27,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"+'TOT-0416'!B2","v":"ANEXO IV al Memorandum D.T.E.E. N° 294  /2017"}]
[]
[" ENTE NACIONAL REGULADOR "]
["         DE LA ELECTRICIDAD"]
[]
[]
[null,null,null,null,null,"SISTEMA DE TRANSPORTE DE ENERGÍA ELÉCTRICA POR DISTRIBUCIÓN TRONCAL - TRANSNEA S.A."]
[]
[null,null,null,null,null,"1.- LÍNEAS"]
[]
[null,null,null,null,null,"1.1.- Líneas propias"]
[]
[null,{"$f":"+'TOT-0416'!B14","v":"Desde el 01 al 30 de abril de 2016"}]
[]
[null,null,null,null,null,"$/100 km-h : LÍNEAS 220 kV ",360.92500000000001]
[null,null,null,null,null,"$/100 km-h : LÍNEAS 132 kV ",345.49299999999999,null,null,null,"FACTOR DE PENALIZACIÓN K =",{"$f":"30*'TOT-0416'!B13","v":60},{"$f":"IF(L17=30,\" \",IF(L17=60,\"Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"REVISAR COEFICIENTE\"))","v":"Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km."}]
[null,null,null,null,null,"$/100 km-h : LÍNEAS 33 kV ",345.49299999999999]
[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%","PENALIZAC.\nPROGRAM.","REDUCC.\nPROGRAM.","PENALIZACIÓN FORZADA\nPor Salida    1ras. 3 hs.  hs. Restantes",null,null,"REDUCC. FORZADA\nPor Salida    1ras. 3 hs.  hs. Restantes",null,null,"RESTANTE\nFORZADA","REDUCC.\nRESTANTE","Informó\nenTérm.","TOTAL\nPENALIZAC."]
[]
[]
[null,null,1,261606,748,"STA. CATALINA - RESISTENCIA",132,42,{"$f":"IF(H23>25,H23,25)*IF(G23=220,$G$16,IF(G23=132,$G$17,$G$18))/100","v":145.10705999999999},"2016-04-01","2016-04-30T23:59:59",{"$f":"IF(F23=\"\",\"\",(K23-J23)*24)","v":719.99972222215729},{"$f":"IF(F23=\"\",\"\",ROUND((K23-J23)*24*60,0))","v":43200},"P",{"$f":"IF(F23=\"\",\"\",\"--\")","v":"--"},{"$f":"IF(N23=\"P\",ROUND(M23/60,2)*I23*$L$17*0.01,\"--\")","v":62686.249919999995},{"$f":"IF(N23=\"RP\",ROUND(M23/60,2)*I23*$L$17*0.01*O23/100,\"--\")","v":"--"},{"$f":"IF(N23=\"F\",I23*$L$17,\"--\")","v":"--"},{"$f":"IF(AND(M23>10,N23=\"F\"),I23*$L$17*IF(M23>180,3,ROUND(M23/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(N23=\"F\",M23>180),(ROUND(M23/60,2)-3)*I23*$L$17*0.1,\"--\")","v":"--"},{"$f":"IF(N23=\"R\",I23*$L$17*O23/100,\"--\")","v":"--"},{"$f":"IF(AND(M23>10,N23=\"R\"),I23*$L$17*O23/100*IF(M23>180,3,ROUND(M23/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(N23=\"R\",M23>180),(ROUND(M23/60,2)-3)*I23*$L$17*0.1*O23/100,\"--\")","v":"--"},{"$f":"IF(N23=\"RF\",ROUND(M23/60,2)*I23*$L$17*0.1,\"--\")","v":"--"},{"$f":"IF(N23=\"RR\",ROUND(M23/60,2)*I23*$L$17*0.1*O23/100,\"--\")","v":"--"},"SI",{"$f":"IF(F23=\"\",\"\",SUM(P23:Y23)*IF(Z23=\"SI\",1,2))","v":62686.249919999995}]
[null,null,2,291181,946,"PASO DE LOS LIBRES - URUGUAYANA",132,3.9000000953674316,{"$f":"IF(H24>25,H24,25)*IF(G24=220,$G$16,IF(G24=132,$G$17,$G$18))/100","v":86.373250000000013},"2016-04-01","2016-04-30T23:59:59",{"$f":"IF(F24=\"\",\"\",(K24-J24)*24)","v":719.99972222215729},{"$f":"IF(F24=\"\",\"\",ROUND((K24-J24)*24*60,0))","v":43200},"RF",{"$f":"IF(F24=\"\",\"\",\"--\")","v":"--"},{"$f":"IF(N24=\"P\",ROUND(M24/60,2)*I24*$L$17*0.01,\"--\")","v":"--"},{"$f":"IF(N24=\"RP\",ROUND(M24/60,2)*I24*$L$17*0.01*O24/100,\"--\")","v":"--"},{"$f":"IF(N24=\"F\",I24*$L$17,\"--\")","v":"--"},{"$f":"IF(AND(M24>10,N24=\"F\"),I24*$L$17*IF(M24>180,3,ROUND(M24/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(N24=\"F\",M24>180),(ROUND(M24/60,2)-3)*I24*$L$17*0.1,\"--\")","v":"--"},{"$f":"IF(N24=\"R\",I24*$L$17*O24/100,\"--\")","v":"--"},{"$f":"IF(AND(M24>10,N24=\"R\"),I24*$L$17*O24/100*IF(M24>180,3,ROUND(M24/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(N24=\"R\",M24>180),(ROUND(M24/60,2)-3)*I24*$L$17*0.1*O24/100,\"--\")","v":"--"},{"$f":"IF(N24=\"RF\",ROUND(M24/60,2)*I24*$L$17*0.1,\"--\")","v":373132.44000000012},{"$f":"IF(N24=\"RR\",ROUND(M24/60,2)*I24*$L$17*0.1*O24/100,\"--\")","v":"--"},"SI",{"$f":"IF(F24=\"\",\"\",SUM(P24:Y24)*IF(Z24=\"SI\",1,2))","v":373132.44000000012}]
[null,null,3,300812,746,"MONTE CASEROS - CHAJARÍ",132,74.5,257.39228500000002,"2016-04-02T08:58:00","2016-04-02T18:32:00",9.566666666592937,574,"F","--","--","--",15443.537100000001,46330.611300000004,10146.403874700001,"--","--","--","--","--","SI",71920.552274700007]
[null,null,4,301070,5394,"STA. CATALINA - COLONIA BRUGNE - B. VISTA",132,121,418.04652999999996,"2016-04-09T00:10:00","2016-04-09T00:36:00",0.43333333334885538,26,"F","--","--","--",25082.791799999999,10785.600473999999,"--","--","--","--","--","--","SI",35868.392273999998]
[null,null,5,301082,5047,"GRAN FORMOSA - CLORINDA   1",132,103.5,357.58525499999996,"2016-04-09T07:44:00","2016-04-09T07:52:00",0.13333333324408159,8,"F","--","--","--",21455.115299999998,"--","--","--","--","--","--","--","SI",21455.115299999998]
[null,null,6,301410,5394,"STA. CATALINA - COLONIA BRUGNE - B. VISTA",132,121,418.04652999999996,"2016-04-17T08:30:00","2016-04-17T10:07:00",1.6166666666977108,97,"P","--",406.34122716000002,"--","--","--","--","--","--","--","--","--","SI",406.34122716000002]
[null,null,7,301912,5034,"VIRASORO - S. TOME",132,59,203.84087,"2016-04-25T02:11:00","2016-04-25T02:37:00",0.43333333334885538,26,"F","--","--","--",12230.4522,5259.0944460000001,"--","--","--","--","--","--","SI",17489.546645999999]
[null,null,null,null,null,null,null,null,86.373250000000013,null,null,"","",null,{"$f":"IF(F30=\"\",\"\",\"--\")","v":""},{"$f":"IF(N30=\"P\",ROUND(M30/60,2)*I30*$L$17*0.01,\"--\")","v":"--"},{"$f":"IF(N30=\"RP\",ROUND(M30/60,2)*I30*$L$17*0.01*O30/100,\"--\")","v":"--"},{"$f":"IF(N30=\"F\",I30*$L$17,\"--\")","v":"--"},{"$f":"IF(AND(M30>10,N30=\"F\"),I30*$L$17*IF(M30>180,3,ROUND(M30/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(N30=\"F\",M30>180),(ROUND(M30/60,2)-3)*I30*$L$17*0.1,\"--\")","v":"--"},{"$f":"IF(N30=\"R\",I30*$L$17*O30/100,\"--\")","v":"--"},{"$f":"IF(AND(M30>10,N30=\"R\"),I30*$L$17*O30/100*IF(M30>180,3,ROUND(M30/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(N30=\"R\",M30>180),(ROUND(M30/60,2)-3)*I30*$L$17*0.1*O30/100,\"--\")","v":"--"},{"$f":"IF(N30=\"RF\",ROUND(M30/60,2)*I30*$L$17*0.1,\"--\")","v":"--"},{"$f":"IF(N30=\"RR\",ROUND(M30/60,2)*I30*$L$17*0.1*O30/100,\"--\")","v":"--"},{"$f":"IF(F30=\"\",\"\",\"SI\")","v":""},""]
[null,null,null,null,null,null,null,null,86.373250000000013,null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,86.373250000000013,null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,86.373250000000013,null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,86.373250000000013,null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,86.373250000000013,null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,86.373250000000013,null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--",{"$f":"IF(F36=\"\",\"\",\"SI\")","v":""},""]
[null,null,null,null,null,null,null,null,86.373250000000013,null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,86.373250000000013,null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,86.373250000000013,null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,{"$f":"IF(H40>25,H40,25)*IF(G40=220,$G$16,IF(G40=132,$G$17,$G$18))/100","v":86.373250000000013},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(N40=\"F\",M40>180),(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(N40=\"R\",M40>180),(ROUND(M40/60,2)-3)*I40*$L$17*0.1*O40/100,\"--\")","v":"--"},{"$f":"IF(N40=\"RF\",ROUND(M40/60,2)*I40*$L$17*0.1,\"--\")","v":"--"},{"$f":"IF(N40=\"RR\",ROUND(M40/60,2)*I40*$L$17*0.1*O40/100,\"--\")","v":"--"},{"$f":"IF(F40=\"\",\"\",\"SI\")","v":""},""]
[null,null,null,null,null,null,null,null,{"$f":"IF(H41>25,H41,25)*IF(G41=220,$G$16,IF(G41=132,$G$17,$G$18))/100","v":86.373250000000013},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(N41=\"F\",M41>180),(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(N41=\"R\",M41>180),(ROUND(M41/60,2)-3)*I41*$L$17*0.1*O41/100,\"--\")","v":"--"},{"$f":"IF(N41=\"RF\",ROUND(M41/60,2)*I41*$L$17*0.1,\"--\")","v":"--"},{"$f":"IF(N41=\"RR\",ROUND(M41/60,2)*I41*$L$17*0.1*O41/100,\"--\")","v":"--"},{"$f":"IF(F41=\"\",\"\",\"SI\")","v":""},""]
[]
[null,null,"(²)","P - PROGRAMADA  ; F - FORZADA  ; RF - RESTANTE FORZADA",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P21:P42)","v":63092.591147159997},{"$f":"SUM(Q21:Q42)","v":0},{"$f":"SUM(R21:R42)","v":74211.896399999998},62375.306220000006,10146.403874700001,0,0,0,373132.44000000012,0,null,{"$f":"ROUND(SUM(AA21:AA42),2)","v":582958.64}]

{"sheet":"LI-DPEC-04 (1)","index":2,"n_rows":44,"n_cols":27,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'TOT-0416'!B2","v":"ANEXO IV al Memorandum D.T.E.E. N° 294  /2017"}]
[]
[" ENTE NACIONAL REGULADOR "]
["         DE LA ELECTRICIDAD"]
[]
[]
[null,null,null,null,null,"SISTEMA DE TRANSPORTE DE ENERGÍA ELÉCTRICA POR DISTRIBUCIÓN TRONCAL - TRANSNEA S.A."]
[]
[null,null,null,null,null,"1.2.-Transportista Independiente - Dirección Provincial de Energía de Corrientes (D.P.E.C.)"]
[]
[null,{"$f":"'TOT-0416'!B14","v":"Desde el 01 al 30 de abril de 2016"}]
[]
[]
[null,null,null,null,null,"$/100 km-h : LÍNEAS 220 kV "," - "]
[null,null,null,null,null,"$/100 km-h : LÍNEAS 132 kV ",145.14699999999999,null,null,null,"FACTOR DE PENALIZACIÓN K =",{"$f":"30*'TOT-0416'!B13","v":60},{"$f":"IF(L16=30,\" \",IF(L16=60,\"Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"REVISAR COEFICIENTE\"))","v":"Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km."}]
[null,null,null,null,null,"$/100 km-h : LÍNEAS 66 kV "," - "]
[]
[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%","PENALIZAC.\nPROGRAM.","REDUCC.\nPROGRAM.","PENALIZACIÓN FORZADA\nPor Salida    1ras. 3 hs.  hs. Restantes",null,null,"REDUCC. FORZADA\nPor Salida    1ras. 3 hs.  hs. Restantes",null,null,"RESTANTE\nFORZADA","REDUCC.\nRESTANTE","Informó\nenTérm.","TOTAL\nPENALIZAC."]
[]
[]
[null,null,42,301066,1001,"PASO DE LOS LIBRES - MONTE CASEROS",132,101,{"$f":"IF(H23>25,H23,25)*IF(G23=220,$G$15,IF(G23=132,$G$16,$G$17))/100","v":146.59846999999999},"2016-04-06T21:16:00","2016-04-06T21:21:00",{"$f":"IF(F23=\"\",\"\",(K23-J23)*24)","v":8.3333333255723119E-2},{"$f":"IF(F23=\"\",\"\",ROUND((K23-J23)*24*60,0))","v":5},"F",{"$f":"IF(F23=\"\",\"\",\"--\")","v":"--"},{"$f":"IF(N23=\"P\",ROUND(M23/60,2)*I23*$L$16*0.01,\"--\")","v":"--"},{"$f":"IF(N23=\"RP\",ROUND(M23/60,2)*I23*$L$16*0.01*O23/100,\"--\")","v":"--"},{"$f":"IF(N23=\"F\",I23*$L$16,\"--\")","v":8795.9081999999999},{"$f":"IF(AND(M23>10,N23=\"F\"),I23*$L$16*IF(M23>180,3,ROUND(M23/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(N23=\"F\",M23>180),(ROUND(M23/60,2)-3)*I23*$L$16*0.1,\"--\")","v":"--"},{"$f":"IF(N23=\"R\",I23*$L$16*O23/100,\"--\")","v":"--"},{"$f":"IF(AND(M23>10,N23=\"R\"),I23*$L$16*O23/100*IF(M23>180,3,ROUND(M23/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(N23=\"R\",M23>180),(ROUND(M23/60,2)-3)*I23*$L$16*0.1*O23/100,\"--\")","v":"--"},{"$f":"IF(N23=\"RF\",ROUND(M23/60,2)*I23*$L$16*0.1,\"--\")","v":"--"},{"$f":"IF(N23=\"RR\",ROUND(M23/60,2)*I23*$L$16*0.1*O23/100,\"--\")","v":"--"},"SI",{"$f":"IF(F23=\"\",\"\",SUM(P23:Y23)*IF(Z23=\"SI\",1,2))","v":8795.9081999999999}]
[null,null,43,301384,1001,"PASO DE LOS LIBRES - MONTE CASEROS",132,101,{"$f":"IF(H24>25,H24,25)*IF(G24=220,$G$15,IF(G24=132,$G$16,$G$17))/100","v":146.59846999999999},"2016-04-13T05:20:00","2016-04-13T05:27:00",0.11666666669771075,{"$f":"IF(F24=\"\",\"\",ROUND((K24-J24)*24*60,0))","v":7},"F","--","--","--",{"$f":"IF(N24=\"F\",I24*$L$16,\"--\")","v":8795.9081999999999},"--","--","--","--","--",{"$f":"IF(N24=\"RF\",ROUND(M24/60,2)*I24*$L$16*0.1,\"--\")","v":"--"},{"$f":"IF(N24=\"RR\",ROUND(M24/60,2)*I24*$L$16*0.1*O24/100,\"--\")","v":"--"},"SI",{"$f":"IF(F24=\"\",\"\",SUM(P24:Y24)*IF(Z24=\"SI\",1,2))","v":8795.9081999999999}]
[null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--",{"$f":"IF(F25=\"\",\"\",\"SI\")","v":""},""]
[null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,{"$f":"IF(H40>25,H40,25)*IF(G40=220,$G$15,IF(G40=132,$G$16,$G$17))/100","v":{"$error":"#VALUE!"}},null,null,"",{"$f":"IF(F40=\"\",\"\",ROUND((K40-J40)*24*60,0))","v":""},null,"","--","--","--","--","--","--","--","--",{"$f":"IF(N40=\"RF\",ROUND(M40/60,2)*I40*$L$16*0.1,\"--\")","v":"--"},{"$f":"IF(N40=\"RR\",ROUND(M40/60,2)*I40*$L$16*0.1*O40/100,\"--\")","v":"--"},"",""]
[null,null,null,null,null,null,null,null,{"$f":"IF(H41>25,H41,25)*IF(G41=220,$G$15,IF(G41=132,$G$16,$G$17))/100","v":{"$error":"#VALUE!"}},null,null,"",{"$f":"IF(F41=\"\",\"\",ROUND((K41-J41)*24*60,0))","v":""},null,"","--","--","--","--","--","--","--","--",{"$f":"IF(N41=\"RF\",ROUND(M41/60,2)*I41*$L$16*0.1,\"--\")","v":"--"},{"$f":"IF(N41=\"RR\",ROUND(M41/60,2)*I41*$L$16*0.1*O41/100,\"--\")","v":"--"},"",""]
[null,null,null,null,null,null,null,null,{"$f":"IF(H42>25,H42,25)*IF(G42=220,$G$15,IF(G42=132,$G$16,$G$17))/100","v":{"$error":"#VALUE!"}},null,null,"",{"$f":"IF(F42=\"\",\"\",ROUND((K42-J42)*24*60,0))","v":""},null,"","--","--","--","--","--","--","--","--",{"$f":"IF(N42=\"RF\",ROUND(M42/60,2)*I42*$L$16*0.1,\"--\")","v":"--"},{"$f":"IF(N42=\"RR\",ROUND(M42/60,2)*I42*$L$16*0.1*O42/100,\"--\")","v":"--"},"",""]
[]
[null,null,"(²)","F - FORZADA",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P21:P43)","v":0},0,17591.8164,0,0,0,0,0,0,0,null,{"$f":"ROUND(SUM(AA21:AA43),2)","v":17591.82}]

{"sheet":"LI-ENECOR-04 (1)","index":3,"n_rows":44,"n_cols":27,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'TOT-0416'!B2","v":"ANEXO IV al Memorandum D.T.E.E. N° 294  /2017"}]
[]
[" ENTE NACIONAL REGULADOR "]
["       DE LA ELECTRICIDAD"]
[]
[]
[null,null,null,null,null,"SISTEMA DE TRANSPORTE DE ENERGÍA ELÉCTRICA POR DISTRIBUCIÓN TRONCAL - TRANSNEA S.A."]
[]
[null,null,null,null,null,"1.2.-Transportista Independiente - Energía de Corrientes S.A. (E.N.E.C.O.R. S.A.)"]
[]
[null,{"$f":"'TOT-0416'!B14","v":"Desde el 01 al 30 de abril de 2016"}]
[]
[]
[null,null,null,null,null,"$/100 km-h : LÍNEAS 220 kV "," - "]
[null,null,null,null,null,"$/100 km-h : LÍNEAS 132 kV ",112.72199999999999,null,null,null,"FACTOR DE PENALIZACIÓN K =",{"$f":"30*'TOT-0416'!B13","v":60},{"$f":"IF(L16=30,\" \",IF(L16=60,\"Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"REVISAR COEFICIENTE\"))","v":"Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km."}]
[null,null,null,null,null,"$/100 km-h : LÍNEAS 66 kV "," - "]
[]
[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%","PENALIZAC.\nPROGRAM.","REDUCC.\nPROGRAM.","PENALIZACIÓN FORZADA\nPor Salida    1ras. 3 hs.  hs. Restantes",null,null,"REDUCC. FORZADA\nPor Salida    1ras. 3 hs.  hs. Restantes",null,null,"RESTANTE\nFORZADA","REDUCC.\nRESTANTE","Informó\nenTérm.","TOTAL\nPENALIZAC."]
[]
[]
[null,null,44,301664,2868,"S. CATALINA - P. DE LA PATRIA    2",132,20.8,{"$f":"IF(H23>25,H23,25)*IF(G23=220,$G$15,IF(G23=132,$G$16,$G$17))/100","v":28.180499999999999},"2016-04-18T07:41:00","2016-04-18T08:00:00",{"$f":"IF(F23=\"\",\"\",(K23-J23)*24)","v":0.31666666665114462},{"$f":"IF(F23=\"\",\"\",ROUND((K23-J23)*24*60,0))","v":19},"F",{"$f":"IF(F23=\"\",\"\",\"--\")","v":"--"},{"$f":"IF(N23=\"P\",ROUND(M23/60,2)*I23*$L$16*0.01,\"--\")","v":"--"},{"$f":"IF(N23=\"RP\",ROUND(M23/60,2)*I23*$L$16*0.01*O23/100,\"--\")","v":"--"},{"$f":"IF(N23=\"F\",I23*$L$16,\"--\")","v":1690.83},{"$f":"IF(AND(M23>10,N23=\"F\"),I23*$L$16*IF(M23>180,3,ROUND(M23/60,2)),\"--\")","v":541.06560000000002},{"$f":"IF(AND(N23=\"F\",M23>180),(ROUND(M23/60,2)-3)*I23*$L$16*0.1,\"--\")","v":"--"},{"$f":"IF(N23=\"R\",I23*$L$16*O23/100,\"--\")","v":"--"},{"$f":"IF(AND(M23>10,N23=\"R\"),I23*$L$16*O23/100*IF(M23>180,3,ROUND(M23/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(N23=\"R\",M23>180),(ROUND(M23/60,2)-3)*I23*$L$16*0.1*O23/100,\"--\")","v":"--"},{"$f":"IF(N23=\"RF\",ROUND(M23/60,2)*I23*$L$16*0.1,\"--\")","v":"--"},{"$f":"IF(N23=\"RR\",ROUND(M23/60,2)*I23*$L$16*0.1*O23/100,\"--\")","v":"--"},{"$f":"IF(F23=\"\",\"\",\"SI\")","v":"SI"},{"$f":"IF(F23=\"\",\"\",SUM(P23:Y23)*IF(Z23=\"SI\",1,2))","v":2231.8955999999998}]
[null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--","",""]
[]
[null,null,"(²)","F - FORZADA",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P21:P43)","v":0},0,1690.83,541.06560000000002,0,0,0,0,0,0,null,{"$f":"ROUND(SUM(AA21:AA43),2)","v":2231.9}]

{"sheet":"T-04 (1)","index":4,"n_rows":44,"n_cols":29,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"+'TOT-0416'!B2","v":"ANEXO IV al Memorandum D.T.E.E. N° 294  /2017"}]
[]
[" ENTE NACIONAL REGULADOR "]
["       DE LA ELECTRICIDAD"]
[]
[]
[null,null,null,null,null,"SISTEMA DE TRANSPORTE DE ENERGÍA ELÉCTRICA POR DISTRIBUCIÓN TRONCAL - TRANSNEA S.A."]
[]
[null,null,null,null,null,"2.- CONEXIÓN"]
[]
[null,null,null,null,null,"2.1.- Transformación"]
[]
[null,{"$f":"+'TOT-0416'!B14","v":"Desde el 01 al 30 de abril de 2016"}]
[]
[null,null,null,null,null,"Por Transformador  [$ / h - MVA]  =",null,null,1.2350000000000001]
[null,null,null,null,null,"Coeficiente de penalización por salida forzada   =",null,null,{"$f":"30*'TOT-0416'!B13","v":60},null,{"$f":"IF(I17=30,\" \",IF(I17=60,\"  Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"  REVISAR COEFICIENTE\"))","v":"  Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km."}]
[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.","C.R.\n%","E.N.S.","K (P;ENS)","PENALIZ.\nPROGRAM.","REDUCC.\nPROGRAM.","PENALIZACIÓN FORZADA\nPor Salida    hs. Restantes",null,"REDUCC. FORZADA\nPor Salida    hs. Restantes",null,"RESTANTE\nFORZADA","REDUCC.\nRESTANTE","Informó\nenTérm.","TOTAL\nPENALIZAC."]
[]
[]
[null,null,8,299125,752,"BARRANQUERAS","TRAFO 7",30,"132/33/13,2",{"$f":"H22*$I$16","v":37.050000000000004},"2016-04-01","2016-04-13T11:38:00",{"$f":"IF(F22=\"\",\"\",(L22-K22)*24)","v":299.6333333333605},{"$f":"IF(F22=\"\",\"\",ROUND((L22-K22)*24*60,0))","v":17978},"RP",{"$f":"IF(F22=\"\",\"\",IF(OR(O22=\"P\",O22=\"RP\"),\"--\",\"NO\"))","v":"--"},50,{"$f":"IF(F22=\"\",\"\",\"NO\")","v":"NO"},{"$f":"$I$17*IF(OR(O22=\"P\",O22=\"RP\"),0.1,1)*IF(R22=\"SI\",1,0.1)","v":0.60000000000000009},{"$f":"IF(O22=\"P\",J22*S22*ROUND(N22/60,2),\"--\")","v":"--"},{"$f":"IF(O22=\"RP\",J22*S22*ROUND(N22/60,2)*Q22/100,\"--\")","v":3330.3874500000011},{"$f":"IF(AND(O22=\"F\",P22=\"NO\"),J22*S22,\"--\")","v":"--"},{"$f":"IF(O22=\"F\",J22*S22*ROUND(N22/60,2),\"--\")","v":"--"},{"$f":"IF(AND(O22=\"R\",P22=\"NO\"),J22*S22*Q22/100,\"--\")","v":"--"},{"$f":"IF(O22=\"R\",J22*S22*ROUND(N22/60,2)*Q22/100,\"--\")","v":"--"},{"$f":"IF(O22=\"RF\",J22*S22*ROUND(N22/60,2),\"--\")","v":"--"},{"$f":"IF(O22=\"RR\",J22*S22*ROUND(N22/60,2)*Q22/100,\"--\")","v":"--"},"SI",{"$f":"IF(F22=\"\",\"\",SUM(T22:AA22)*IF(AB22=\"SI\",1,2))","v":3330.3874500000011}]
[null,null,9,301048,459,"CORRIENTES","TRAFO 3",30,"132/33/13,2",{"$f":"H23*$I$16","v":37.050000000000004},"2016-04-04T15:50:00","2016-04-04T16:38:00",{"$f":"IF(F23=\"\",\"\",(L23-K23)*24)","v":0.80000000016298145},{"$f":"IF(F23=\"\",\"\",ROUND((L23-K23)*24*60,0))","v":48},"R",{"$f":"IF(F23=\"\",\"\",IF(OR(O23=\"P\",O23=\"RP\"),\"--\",\"NO\"))","v":"NO"},60,"SI",{"$f":"$I$17*IF(OR(O23=\"P\",O23=\"RP\"),0.1,1)*IF(R23=\"SI\",1,0.1)","v":60},{"$f":"IF(O23=\"P\",J23*S23*ROUND(N23/60,2),\"--\")","v":"--"},{"$f":"IF(O23=\"RP\",J23*S23*ROUND(N23/60,2)*Q23/100,\"--\")","v":"--"},{"$f":"IF(AND(O23=\"F\",P23=\"NO\"),J23*S23,\"--\")","v":"--"},{"$f":"IF(O23=\"F\",J23*S23*ROUND(N23/60,2),\"--\")","v":"--"},{"$f":"IF(AND(O23=\"R\",P23=\"NO\"),J23*S23*Q23/100,\"--\")","v":1333.8000000000002},{"$f":"IF(O23=\"R\",J23*S23*ROUND(N23/60,2)*Q23/100,\"--\")","v":1067.0400000000002},{"$f":"IF(O23=\"RF\",J23*S23*ROUND(N23/60,2),\"--\")","v":"--"},{"$f":"IF(O23=\"RR\",J23*S23*ROUND(N23/60,2)*Q23/100,\"--\")","v":"--"},"SI",{"$f":"IF(F23=\"\",\"\",SUM(T23:AA23)*IF(AB23=\"SI\",1,2))","v":2400.84}]
[null,null,10,301049,3625,"CORRIENTES","TRAFO 4",50,"132/33/13,2",61.750000000000007,"2016-04-04T15:50:00","2016-04-04T16:38:00",0.80000000016298145,48,"R","NO",60,"SI",60,"--",{"$f":"IF(O24=\"RP\",J24*S24*ROUND(N24/60,2)*Q24/100,\"--\")","v":"--"},"--","--",2223.0000000000005,1778.4000000000003,"--","--","SI",4001.4000000000005]
[null,null,11,301068,4204,"MTE. CASEROS","TRAFO 2",15,"132/33/13,2",18.525000000000002,"2016-04-06T21:16:00","2016-04-06T21:35:00",0.31666666665114462,19,"F","NO","0,000","SI",60,"--",{"$f":"IF(O25=\"RP\",J25*S25*ROUND(N25/60,2)*Q25/100,\"--\")","v":"--"},1111.5000000000002,355.68000000000006,"--","--","--","--","SI",1467.1800000000003]
[null,null,12,301383,3305,"FORMOSA","TRAFO 1",30,"132/33/13,2",37.050000000000004,"2016-04-12T07:09:00","2016-04-12T09:35:00",2.4333333332324401,146,"RP","--",40,"NO",0.60000000000000009,"--",21.607560000000007,"--","--","--","--","--","--","SI",21.607560000000007]
[null,null,13,301386,764,"FORMOSA","TRAFO 3",30,"132/33/13,2",37.050000000000004,"2016-04-13T07:27:00","2016-04-13T10:15:00",2.8000000000465661,168,"RP","--",60,"NO",0.60000000000000009,"--",37.34640000000001,"--","--","--","--","--","--","SI",37.34640000000001]
[null,null,14,301387,750,"BARRANQUERAS","TRAFO 4",15,"132/33/13.2",18.525000000000002,"2016-04-13T11:39:00","2016-04-13T12:30:00",0.84999999997671694,51,"R","NO",60,"SI",60,"--","--","--","--",666.90000000000009,566.86500000000012,"--","--","SI",1233.7650000000003]
[null,null,15,301388,2662,"BARRANQUERAS","TRAFO 5",15,"132/33/13,2",18.525000000000002,"2016-04-13T11:39:00","2016-04-13T12:29:00",0.83333333325572312,50,"R","NO",60,"SI",60,"--","--","--","--",666.90000000000009,553.52700000000016,"--","--","SI",1220.4270000000001]
[null,null,"15a",301388,2662,"BARRANQUERAS","TRAFO 5",15,"132/33/13,2",{"$f":"H30*$I$16","v":18.525000000000002},"2016-04-13T12:29:00","2016-04-13T16:00:00",{"$f":"IF(F30=\"\",\"\",(L30-K30)*24)","v":3.5166666666045785},{"$f":"IF(F30=\"\",\"\",ROUND((L30-K30)*24*60,0))","v":211},"R",{"$f":"IF(F30=\"\",\"\",IF(OR(O30=\"P\",O30=\"RP\"),\"--\",\"NO\"))","v":"NO"},60,"NO",{"$f":"$I$17*IF(OR(O30=\"P\",O30=\"RP\"),0.1,1)*IF(R30=\"SI\",1,0.1)","v":6},{"$f":"IF(O30=\"P\",J30*S30*ROUND(N30/60,2),\"--\")","v":"--"},{"$f":"IF(O30=\"RP\",J30*S30*ROUND(N30/60,2)*Q30/100,\"--\")","v":"--"},{"$f":"IF(AND(O30=\"F\",P30=\"NO\"),J30*S30,\"--\")","v":"--"},{"$f":"IF(O30=\"F\",J30*S30*ROUND(N30/60,2),\"--\")","v":"--"},{"$f":"IF(AND(O30=\"R\",P30=\"NO\"),J30*S30*Q30/100,\"--\")","v":66.69},{"$f":"IF(O30=\"R\",J30*S30*ROUND(N30/60,2)*Q30/100,\"--\")","v":234.74880000000005},{"$f":"IF(O30=\"RF\",J30*S30*ROUND(N30/60,2),\"--\")","v":"--"},{"$f":"IF(O30=\"RR\",J30*S30*ROUND(N30/60,2)*Q30/100,\"--\")","v":"--"},"SI",{"$f":"IF(F30=\"\",\"\",SUM(T30:AA30)*IF(AB30=\"SI\",1,2))","v":301.43880000000001}]
[null,null,16,301389,752,"BARRANQUERAS","TRAFO 7",30,"132/33/13,2",37.050000000000004,"2016-04-13T11:39:00","2016-04-13T12:29:00",0.83333333325572312,50,"R","NO",70,"SI",60,"--","--","--","--",1556.1000000000004,1291.5630000000003,"--","--","SI",2847.6630000000005]
[null,null,17,301390,753,"BARRANQUERAS","TR089",30,"132/33/13,2",37.050000000000004,"2016-04-13T11:39:00","2016-04-13T12:30:00",0.84999999997671694,51,"R","NO",60,"SI",60,"--","--","--","--",1333.8000000000002,1133.7300000000002,"--","--","SI",2467.5300000000007]
[null,null,18,301551,752,"BARRANQUERAS","TRAFO 7",30,"132/33/13,2",37.050000000000004,"2016-04-13T12:30:00","2016-04-27T07:30:00",330.99999999994179,19860,"RP","--",50,"NO",0.60000000000000009,"--",3679.065000000001,"--","--","--","--","--","--","SI",3679.065000000001]
[null,null,19,301407,1336,"FORMOSA","TRAFO 4",30,"132/33/13.2",37.050000000000004,"2016-04-14T07:15:00","2016-04-14T09:10:00",1.9166666666278616,115,"RP","--",60,"NO",0.60000000000000009,"--",25.608960000000007,"--","--","--","--","--","--","SI",25.608960000000007]
[null,null,20,301408,4611,"FORMOSA","TRAFO 5",30,"132/33/13,2",37.050000000000004,"2016-04-15T07:23:00","2016-04-15T11:25:00",4.03333333338378,242,"RP","--",50,"NO",0.60000000000000009,"--",44.793450000000021,"--","--","--","--","--","--","SI",44.793450000000021]
[null,null,21,301413,4204,"MTE. CASEROS","TRAFO 2",15,"132/33/13,2",18.525000000000002,"2016-04-17T22:44:00","2016-04-17T23:14:00",0.49999999988358468,30,"R","NO",60,"SI",60,"--","--","--","--",666.90000000000009,333.45000000000005,"--","--","SI",1000.3500000000001]
[null,null,22,301412,769,"MTE.CASER.CTES.","TRAFO 1",15,"132/33/13,2",18.525000000000002,"2016-04-17T22:44:00","2016-04-17T23:14:00",0.49999999988358468,30,"R","NO",40,"SI",60,"--","--","--","--",444.60000000000008,222.30000000000004,"--","--","SI",666.90000000000009]
[null,null,23,301642,771,"SANTA CATALINA","TRAFO 1",30,"132/33/13.2",37.050000000000004,"2016-04-18T02:02:00","2016-04-18T02:31:00",0.48333333333721384,29,"F","NO","0,000","SI",60,"--","--",2223.0000000000005,1067.0400000000002,"--","--","--","--","SI",3290.0400000000009]
[null,null,24,301643,772,"SANTA CATALINA","TRAFO 2",30,"132/33/13,2",37.050000000000004,"2016-04-18T02:02:00","2016-04-18T02:31:00",0.48333333333721384,29,"F","NO","0,000","SI",60,"--","--",2223.0000000000005,1067.0400000000002,"--","--","--","--","SI",3290.0400000000009]
[null,null,25,301644,773,"SANTA CATALINA","TRAFO 3",30,"132/33/13,2",37.050000000000004,"2016-04-18T02:02:00","2016-04-18T02:31:00",{"$f":"IF(F40=\"\",\"\",(L40-K40)*24)","v":0.48333333333721384},{"$f":"IF(F40=\"\",\"\",ROUND((L40-K40)*24*60,0))","v":29},"F","NO","0,000","SI",60,"--","--",2223.0000000000005,1067.0400000000002,"--","--","--","--","SI",3290.0400000000009]
[null,null,26,301645,4072,"SANTA CATALINA","TRAFO 4",30,"132/33/13.2",37.050000000000004,"2016-04-18T02:02:00","2016-04-18T02:31:00",{"$f":"IF(F41=\"\",\"\",(L41-K41)*24)","v":0.48333333333721384},{"$f":"IF(F41=\"\",\"\",ROUND((L41-K41)*24*60,0))","v":29},"F","NO","0,000","SI",60,"--","--",2223.0000000000005,1067.0400000000002,"--","--","--","--","SI",3290.0400000000009]
[null,null,27,301646,4719,"SANTA CATALINA","TRAFO 5",30,"132/33/13,2",37.050000000000004,"2016-04-18T02:02:00","2016-04-18T02:31:00",{"$f":"IF(F42=\"\",\"\",(L42-K42)*24)","v":0.48333333333721384},{"$f":"IF(F42=\"\",\"\",ROUND((L42-K42)*24*60,0))","v":29},"F","NO","0,000","SI",60,"--","--",2223.0000000000005,1067.0400000000002,"--","--","--","--",{"$f":"IF(F42=\"\",\"\",\"SI\")","v":"SI"},3290.0400000000009]
[]
[null,null,"(²)","F - FORZADA  ; RP - REDUCCIÓN PROGRAMADA  ; R - REDUCCIÓN FORZADA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T20:T43)","v":0},{"$f":"SUM(U20:U43)","v":7138.8088200000011},12226.500000000002,5690.88,8958.69,7181.6238000000012,0,0,null,{"$f":"ROUND(SUM(AC20:AC43),2)","v":41196.5}]

{"sheet":"T-04 (2)","index":5,"n_rows":44,"n_cols":29,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"+'TOT-0416'!B2","v":"ANEXO IV al Memorandum D.T.E.E. N° 294  /2017"}]
[]
[" ENTE NACIONAL REGULADOR "]
["       DE LA ELECTRICIDAD"]
[]
[]
[null,null,null,null,null,"SISTEMA DE TRANSPORTE DE ENERGÍA ELÉCTRICA POR DISTRIBUCIÓN TRONCAL - TRANSNEA S.A."]
[]
[null,null,null,null,null,"2.- CONEXIÓN"]
[]
[null,null,null,null,null,"2.1.- Transformación"]
[]
[null,{"$f":"+'TOT-0416'!B14","v":"Desde el 01 al 30 de abril de 2016"}]
[]
[null,null,null,null,null,"Por Transformador  [$ / h - MVA]  =",null,null,1.2350000000000001]
[null,null,null,null,null,"Coeficiente de penalización por salida forzada   =",null,null,{"$f":"30*'TOT-0416'!B13","v":60},null,{"$f":"IF(I17=30,\" \",IF(I17=60,\"  Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"  REVISAR COEFICIENTE\"))","v":"  Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km."}]
[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.","C.R.\n%","E.N.S.","K (P;ENS)","PENALIZ.\nPROGRAM.","REDUCC.\nPROGRAM.","PENALIZACIÓN FORZADA\nPor Salida    hs. Restantes",null,"REDUCC. FORZADA\nPor Salida    hs. Restantes",null,"RESTANTE\nFORZADA","REDUCC.\nRESTANTE","Informó\nenTérm.","TOTAL\nPENALIZAC."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+'T-04 (1)'!$AC$44","v":41196.5}]
[null,null,28,301665,3625,"CORRIENTES","TRAFO 4",50,"132/33/13,2",{"$f":"H22*$I$16","v":61.750000000000007},"2016-04-19T05:25:00","2016-04-19T05:29:00",{"$f":"IF(F22=\"\",\"\",(L22-K22)*24)","v":6.6666666709352285E-2},{"$f":"IF(F22=\"\",\"\",ROUND((L22-K22)*24*60,0))","v":4},"R",{"$f":"IF(F22=\"\",\"\",IF(OR(O22=\"P\",O22=\"RP\"),\"--\",\"NO\"))","v":"NO"},60,"SI",{"$f":"$I$17*IF(OR(O22=\"P\",O22=\"RP\"),0.1,1)*IF(R22=\"SI\",1,0.1)","v":60},{"$f":"IF(O22=\"P\",J22*S22*ROUND(N22/60,2),\"--\")","v":"--"},{"$f":"IF(O22=\"RP\",J22*S22*ROUND(N22/60,2)*Q22/100,\"--\")","v":"--"},{"$f":"IF(AND(O22=\"F\",P22=\"NO\"),J22*S22,\"--\")","v":"--"},{"$f":"IF(O22=\"F\",J22*S22*ROUND(N22/60,2),\"--\")","v":"--"},{"$f":"IF(AND(O22=\"R\",P22=\"NO\"),J22*S22*Q22/100,\"--\")","v":2223.0000000000005},{"$f":"IF(O22=\"R\",J22*S22*ROUND(N22/60,2)*Q22/100,\"--\")","v":155.61000000000004},{"$f":"IF(O22=\"RF\",J22*S22*ROUND(N22/60,2),\"--\")","v":"--"},{"$f":"IF(O22=\"RR\",J22*S22*ROUND(N22/60,2)*Q22/100,\"--\")","v":"--"},"SI",{"$f":"IF(F22=\"\",\"\",SUM(T22:AA22)*IF(AB22=\"SI\",1,2))","v":2378.6100000000006}]
[null,null,29,301675,3305,"FORMOSA","TRAFO 1",30,"132/33/13,2",{"$f":"H23*$I$16","v":37.050000000000004},"2016-04-20T07:42:00","2016-04-20T13:04:00",{"$f":"IF(F23=\"\",\"\",(L23-K23)*24)","v":5.3666666666977108},{"$f":"IF(F23=\"\",\"\",ROUND((L23-K23)*24*60,0))","v":322},"RP",{"$f":"IF(F23=\"\",\"\",IF(OR(O23=\"P\",O23=\"RP\"),\"--\",\"NO\"))","v":"--"},60,"NO",{"$f":"$I$17*IF(OR(O23=\"P\",O23=\"RP\"),0.1,1)*IF(R23=\"SI\",1,0.1)","v":0.60000000000000009},{"$f":"IF(O23=\"P\",J23*S23*ROUND(N23/60,2),\"--\")","v":"--"},{"$f":"IF(O23=\"RP\",J23*S23*ROUND(N23/60,2)*Q23/100,\"--\")","v":71.625060000000033},{"$f":"IF(AND(O23=\"F\",P23=\"NO\"),J23*S23,\"--\")","v":"--"},{"$f":"IF(O23=\"F\",J23*S23*ROUND(N23/60,2),\"--\")","v":"--"},{"$f":"IF(AND(O23=\"R\",P23=\"NO\"),J23*S23*Q23/100,\"--\")","v":"--"},{"$f":"IF(O23=\"R\",J23*S23*ROUND(N23/60,2)*Q23/100,\"--\")","v":"--"},{"$f":"IF(O23=\"RF\",J23*S23*ROUND(N23/60,2),\"--\")","v":"--"},{"$f":"IF(O23=\"RR\",J23*S23*ROUND(N23/60,2)*Q23/100,\"--\")","v":"--"},"SI",{"$f":"IF(F23=\"\",\"\",SUM(T23:AA23)*IF(AB23=\"SI\",1,2))","v":71.625060000000033}]
[null,null,30,301676,2662,"BARRANQUERAS","TRAFO 5",15,"132/33/13,2",18.525000000000002,"2016-04-22T08:00:00","2016-04-22T13:04:00",5.066666666592937,304,"P","--","0,000","NO",0.60000000000000009,56.353050000000025,"--","--","--","--","--","--","--","SI",56.353050000000025]
[null,null,31,301911,3955,"VIRASORO","TRAFO 1",30,"132/33/13,2",37.050000000000004,"2016-04-25T02:11:00","2016-04-25T02:27:00",0.26666666666278616,16,"F","NO","0,000","SI",60,"--","--",2223.0000000000005,600.21000000000015,"--","--","--","--","SI",2823.2100000000005]
[null,null,32,301930,769,"MTE. CASEROS","TRAFO 1",15,"132/33/13,2",18.525000000000002,"2016-04-27T05:44:00","2016-04-27T06:20:00",0.6000000000349246,36,"F","NO","0,000","SI",60,"--","--",1111.5000000000002,666.90000000000009,"--","--","--","--","SI",1778.4000000000003]
[null,null,"32a",301930,769,"MTE. CASEROS","TRAFO 1",15,"132/33/13,2",{"$f":"H27*$I$16","v":18.525000000000002},"2016-04-27T06:20:00","2016-04-27T09:44:00",{"$f":"IF(F27=\"\",\"\",(L27-K27)*24)","v":3.3999999999068677},{"$f":"IF(F27=\"\",\"\",ROUND((L27-K27)*24*60,0))","v":204},"RF",{"$f":"IF(F27=\"\",\"\",IF(OR(O27=\"P\",O27=\"RP\"),\"--\",\"NO\"))","v":"NO"},"0,000","NO",{"$f":"$I$17*IF(OR(O27=\"P\",O27=\"RP\"),0.1,1)*IF(R27=\"SI\",1,0.1)","v":6},{"$f":"IF(O27=\"P\",J27*S27*ROUND(N27/60,2),\"--\")","v":"--"},{"$f":"IF(O27=\"RP\",J27*S27*ROUND(N27/60,2)*Q27/100,\"--\")","v":"--"},{"$f":"IF(AND(O27=\"F\",P27=\"NO\"),J27*S27,\"--\")","v":"--"},{"$f":"IF(O27=\"F\",J27*S27*ROUND(N27/60,2),\"--\")","v":"--"},{"$f":"IF(AND(O27=\"R\",P27=\"NO\"),J27*S27*Q27/100,\"--\")","v":"--"},{"$f":"IF(O27=\"R\",J27*S27*ROUND(N27/60,2)*Q27/100,\"--\")","v":"--"},{"$f":"IF(O27=\"RF\",J27*S27*ROUND(N27/60,2),\"--\")","v":377.91},{"$f":"IF(O27=\"RR\",J27*S27*ROUND(N27/60,2)*Q27/100,\"--\")","v":"--"},"SI",{"$f":"IF(F27=\"\",\"\",SUM(T27:AA27)*IF(AB27=\"SI\",1,2))","v":377.91}]
[null,null,33,301936,752,"BARRANQUERAS","TRAFO 7",30,"132/33/13,2",37.050000000000004,"2016-04-27T07:31:00","2016-04-29T12:05:00",52.566666666534729,3154,"P","--","0,000","NO",0.60000000000000009,1168.6311000000005,"--","--","--","--","--","--","--","SI",1168.6311000000005]
[null,null,34,301940,764,"FORMOSA","TRAFO 3",30,"132/33/13,2",37.050000000000004,"2016-04-28T07:19:00","2016-04-28T11:33:00",4.2333333333372138,254,"RP","--",40,"NO",0.60000000000000009,"--",37.613160000000015,"--","--","--","--","--","--","SI",37.613160000000015]
[null,null,35,301941,1336,"FORMOSA","TRAFO 4",30,"132/33/13.2",37.050000000000004,"2016-04-29T07:24:00","2016-04-29T11:48:00",4.4000000000232831,264,"RP","--",40,"NO",0.60000000000000009,"--",39.124800000000015,"--","--","--","--","--","--","SI",39.124800000000015]
[null,null,36,301942,752,"BARRANQUERAS","TRAFO 7",30,"132/33/13,2",37.050000000000004,"2016-04-29T12:06:00","2016-04-30T23:59:00",35.883333333302289,2153,"RP","--",50,"NO",0.60000000000000009,"--",398.80620000000016,"--","--","--","--","--","--","SI",398.80620000000016]
[null,null,37,"301388b",2662,"BARRANQUERAS","TRAFO 5",15,"132/33/13,2",18.525000000000002,"2016-04-13T12:30:00","2016-04-13T16:00:00",3.4999999998835847,210,"R","NO",60,"NO",6,"--","--","--","--",66.69,233.41500000000005,"--","--",{"$f":"IF(F32=\"\",\"\",\"SI\")","v":"SI"},300.10500000000002]
[null,null,38,"301930b",769,"MTE. CASEROS","TRAFO 1",15,"132/33/13,2",18.525000000000002,"2016-04-27T06:21:00","2016-04-27T09:44:00",3.3833333333604969,203,"F","NO",0,"NO",6,"--","--",111.15,375.68700000000001,"--","--","--","--","SI",486.83699999999999]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"",null,null,6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"",null,null,6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"",null,null,6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"",null,null,6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,{"$f":"IF(F38=\"\",\"\",IF(OR(O38=\"P\",O38=\"RP\"),\"--\",\"NO\"))","v":""},null,null,6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"",null,null,6,"--","--","--","--","--","--","--","--",{"$f":"IF(F39=\"\",\"\",\"SI\")","v":""},""]
[null,null,null,null,null,null,null,null,null,{"$f":"H40*$I$16","v":0},null,null,{"$f":"IF(F40=\"\",\"\",(L40-K40)*24)","v":""},{"$f":"IF(F40=\"\",\"\",ROUND((L40-K40)*24*60,0))","v":""},null,"",null,null,6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"H41*$I$16","v":0},null,null,{"$f":"IF(F41=\"\",\"\",(L41-K41)*24)","v":""},{"$f":"IF(F41=\"\",\"\",ROUND((L41-K41)*24*60,0))","v":""},null,"",null,null,6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"H42*$I$16","v":0},null,null,{"$f":"IF(F42=\"\",\"\",(L42-K42)*24)","v":""},{"$f":"IF(F42=\"\",\"\",ROUND((L42-K42)*24*60,0))","v":""},null,"",null,null,6,"--","--","--","--","--","--","--","--",{"$f":"IF(F42=\"\",\"\",\"SI\")","v":""},""]
[]
[null,null,"(²)","F - FORZADA  ; RP - REDUCCIÓN PROGRAMADA  ; R - REDUCCIÓN FORZADA  ; RF - RESTANTE FORZADA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T20:T43)","v":1224.9841500000005},{"$f":"SUM(U20:U43)","v":547.16922000000022},3445.650000000001,1642.797,2289.6900000000005,389.02500000000009,377.91,0,null,{"$f":"ROUND(SUM(AC20:AC43),2)","v":51113.73}]

{"sheet":"SA-04 (1)","index":6,"n_rows":43,"n_cols":22,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'TOT-0416'!B2","v":"ANEXO IV al Memorandum D.T.E.E. N° 294  /2017"}]
[]
[" ENTE NACIONAL REGULADOR "]
["       DE LA ELECTRICIDAD"]
[]
[]
[null,null,null,null,null,"SISTEMA DE TRANSPORTE DE ENERGÍA ELÉCTRICA POR DISTRIBUCIÓN TRONCAL - TRANSNEA S.A."]
[]
[null,null,null,null,null,"2.2.- Salidas"]
[]
[null,{"$f":"'TOT-0416'!B14","v":"Desde el 01 al 30 de abril de 2016"}]
[]
[null,null,null,null,null,"Salida en 220 kV"," - ",{"$f":"60*'TOT-0416'!B13","v":120},null,{"$f":"IF(H14=60,\" \",IF(H14=120,\"  Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"  REVISAR COEFICIENTE\"))","v":"  Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km."}]
[null,null,null,null,null,"Salida en 132 kV = ",16.042999999999999,{"$f":"50*'TOT-0416'!B13","v":100},null,{"$f":"IF(H15=50,\" \",IF(H15=100,\"  Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"  REVISAR COEFICIENTE\"))","v":"  Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km."}]
[null,null,null,null,null,"Salida en 33 kV ",12.029,{"$f":"25*'TOT-0416'!B13","v":50},null,{"$f":"IF(H16=25,\" \",IF(H16=50,\"  Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"  REVISAR COEFICIENTE\"))","v":"  Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km."}]
[null,null,null,null,null,"Salida en 13,2 kV =",12.029,{"$f":"20*'TOT-0416'!B13","v":40},null,{"$f":"IF(H17=20,\" \",IF(H17=40,\"  Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"  REVISAR COEFICIENTE\"))","v":"  Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km."}]
[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","PENALIZ.\nPROGRAM.","PENALIZACIÓN FORZADA\nPor Salida    hs. Restantes",null,"RESTANTE\nFORZADA","Informó\nenTérm.","TOTAL\nPENALIZAC."]
[]
[]
[null,null,37,301100,855,"SALTO GRANDE","SALIDA LINEA CONCORDIA",132,{"$f":"IF(H22=220,$G$14,IF(AND(H22<=132,H22>=66),$G$15,IF(AND(H22<66,H22>=33),$G$16,$G$17)))","v":16.042999999999999},"2016-04-10T07:42:00","2016-04-10T15:17:00",{"$f":"IF(F22=\"\",\"\",(K22-J22)*24)","v":7.5833333334303461},{"$f":"IF(F22=\"\",\"\",ROUND((K22-J22)*24*60,0))","v":455},"P",{"$f":"IF(F22=\"\",\"\",IF(OR(N22=\"P\",N22=\"RP\"),\"--\",\"NO\"))","v":"--"},{"$f":"IF(H22=220,$H$14,IF(AND(H22<=132,H22>=66),$H$15,IF(AND(H22<66,H22>=33),$H$16,$H$17)))","v":100},{"$f":"IF(N22=\"P\",I22*P22*ROUND(M22/60,2)*0.1,\"--\")","v":1216.0593999999999},{"$f":"IF(AND(N22=\"F\",O22=\"NO\"),I22*P22,\"--\")","v":"--"},{"$f":"IF(N22=\"F\",I22*P22*ROUND(M22/60,2),\"--\")","v":"--"},{"$f":"IF(N22=\"RF\",I22*P22*ROUND(M22/60,2),\"--\")","v":"--"},"SI",{"$f":"IF(F22=\"\",\"\",SUM(Q22:T22)*IF(U22=\"SI\",1,2)*IF(H22=\"500/220\",0,1))","v":1216.0593999999999}]
[null,null,38,301409,848,"STA. CATALINA","SALIDA 17 DE AGOSTO",33,{"$f":"IF(H23=220,$G$14,IF(AND(H23<=132,H23>=66),$G$15,IF(AND(H23<66,H23>=33),$G$16,$G$17)))","v":12.029},"2016-04-17T08:04:00","2016-04-17T11:14:00",{"$f":"IF(F23=\"\",\"\",(K23-J23)*24)","v":3.1666666666860692},{"$f":"IF(F23=\"\",\"\",ROUND((K23-J23)*24*60,0))","v":190},"P","--",{"$f":"IF(H23=220,$H$14,IF(AND(H23<=132,H23>=66),$H$15,IF(AND(H23<66,H23>=33),$H$16,$H$17)))","v":50},{"$f":"IF(N23=\"P\",I23*P23*ROUND(M23/60,2)*0.1,\"--\")","v":190.65965000000003},{"$f":"IF(AND(N23=\"F\",O23=\"NO\"),I23*P23,\"--\")","v":"--"},{"$f":"IF(N23=\"F\",I23*P23*ROUND(M23/60,2),\"--\")","v":"--"},{"$f":"IF(N23=\"RF\",I23*P23*ROUND(M23/60,2),\"--\")","v":"--"},"SI",{"$f":"IF(F23=\"\",\"\",SUM(Q23:T23)*IF(U23=\"SI\",1,2)*IF(H23=\"500/220\",0,1))","v":190.65965000000003}]
[null,null,39,301937,828,"GOYA","SALIDA CENTRAL GOYA",33,12.029,"2016-04-27T14:24:00","2016-04-27T14:59:00",0.58333333331393078,35,"F","SI",50,"--","--",348.84100000000001,"--",{"$f":"IF(F24=\"\",\"\",\"SI\")","v":"SI"},348.84100000000001]
[null,null,40,301938,5174,"GOYA","SALIDA ALIM. LAVALLE",33,12.029,"2016-04-27T14:24:00","2016-04-27T14:59:00",0.58333333331393078,35,"F","SI",50,"--","--",348.84100000000001,"--","SI",348.84100000000001]
[null,null,41,301939,5175,"GOYA","SALIDA ALIM. SANTA LUCIA",33,12.029,"2016-04-27T14:24:00","2016-04-27T14:59:00",0.58333333331393078,35,"F","SI",50,"--","--",348.84100000000001,"--","SI",348.84100000000001]
[null,null,null,null,null,null,null,null,12.029,null,null,"","",null,"",40,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,12.029,null,null,"","",null,"",40,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,12.029,null,null,"","",null,"",40,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,12.029,null,null,"","",null,"",40,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,12.029,null,null,"","",null,"",40,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,12.029,null,null,"","",null,"",40,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,12.029,null,null,"","",null,"",40,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,12.029,null,null,"","",null,"",40,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,12.029,null,null,"","",null,"",40,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,12.029,null,null,"","",null,"",40,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,12.029,null,null,"","",null,"",40,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,12.029,null,null,"","",null,"",40,"--","--","--","--","",""]
[null,null,null,null,null,null,null,null,{"$f":"IF(H39=220,$G$14,IF(AND(H39<=132,H39>=66),$G$15,IF(AND(H39<66,H39>=33),$G$16,$G$17)))","v":12.029},null,null,{"$f":"IF(F39=\"\",\"\",(K39-J39)*24)","v":""},{"$f":"IF(F39=\"\",\"\",ROUND((K39-J39)*24*60,0))","v":""},null,"",{"$f":"IF(H39=220,$H$14,IF(AND(H39<=132,H39>=66),$H$15,IF(AND(H39<66,H39>=33),$H$16,$H$17)))","v":40},{"$f":"IF(N39=\"P\",I39*P39*ROUND(M39/60,2)*0.1,\"--\")","v":"--"},{"$f":"IF(AND(N39=\"F\",O39=\"NO\"),I39*P39,\"--\")","v":"--"},{"$f":"IF(N39=\"F\",I39*P39*ROUND(M39/60,2),\"--\")","v":"--"},{"$f":"IF(N39=\"RF\",I39*P39*ROUND(M39/60,2),\"--\")","v":"--"},{"$f":"IF(F39=\"\",\"\",\"SI\")","v":""},""]
[null,null,null,null,null,null,null,null,{"$f":"IF(H40=220,$G$14,IF(AND(H40<=132,H40>=66),$G$15,IF(AND(H40<66,H40>=33),$G$16,$G$17)))","v":12.029},null,null,{"$f":"IF(F40=\"\",\"\",(K40-J40)*24)","v":""},{"$f":"IF(F40=\"\",\"\",ROUND((K40-J40)*24*60,0))","v":""},null,"",{"$f":"IF(H40=220,$H$14,IF(AND(H40<=132,H40>=66),$H$15,IF(AND(H40<66,H40>=33),$H$16,$H$17)))","v":40},{"$f":"IF(N40=\"P\",I40*P40*ROUND(M40/60,2)*0.1,\"--\")","v":"--"},{"$f":"IF(AND(N40=\"F\",O40=\"NO\"),I40*P40,\"--\")","v":"--"},{"$f":"IF(N40=\"F\",I40*P40*ROUND(M40/60,2),\"--\")","v":"--"},{"$f":"IF(N40=\"RF\",I40*P40*ROUND(M40/60,2),\"--\")","v":"--"},{"$f":"IF(F40=\"\",\"\",\"SI\")","v":""},""]
[null,null,null,null,null,null,null,null,{"$f":"IF(H41=220,$G$14,IF(AND(H41<=132,H41>=66),$G$15,IF(AND(H41<66,H41>=33),$G$16,$G$17)))","v":12.029},null,null,{"$f":"IF(F41=\"\",\"\",(K41-J41)*24)","v":""},{"$f":"IF(F41=\"\",\"\",ROUND((K41-J41)*24*60,0))","v":""},null,"",{"$f":"IF(H41=220,$H$14,IF(AND(H41<=132,H41>=66),$H$15,IF(AND(H41<66,H41>=33),$H$16,$H$17)))","v":40},{"$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":""},""]
[]
[null,null,"(²)","F - FORZADA",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q20:Q42)","v":1406.7190499999999},{"$f":"SUM(R20:R42)","v":0},{"$f":"SUM(S20:S42)","v":1046.5230000000001},{"$f":"SUM(T20:T42)","v":0},null,{"$f":"ROUND(SUM(V20:V42),2)","v":2453.2399999999998}]

{"sheet":"SUP-DPEC","index":7,"n_rows":63,"n_cols":26,"rows_kept":63,"cut":false,"hidden":false,"merged":[[11,1,11,25]]}
[]
[null,{"$f":"'TOT-0416'!B2","v":"ANEXO IV al Memorandum D.T.E.E. N° 294  /2017"}]
[]
["ENTE NACIONAL REGULADOR "]
["DE LA ELECTRICIDAD"]
[]
[]
[null,null,null,"SISTEMA DE TRANSPORTE DE ENERGÍA ELÉCTRICA POR DISTRIBUCIÓN TRONCAL - TRANSNEA S.A."]
[]
[null,null,null,"3.1.-SUPERVISIÓN - Transportista Independiente D.P.E.C."]
[]
[null,{"$f":"'TOT-0416'!B14","v":"Desde el 01 al 30 de abril de 2016"}]
[]
[]
[]
[null,null,"a) Datos"]
[null,null,null,null,null,null,null,null,null,null,"K"]
[null,null,null,"Tiempo de servicio =",{"$f":"MID(B12,16,2)*24","v":720},"hs",null,"$/100 km-h : LÍNEAS 220 kV ",null," - ",{"$f":"30*'TOT-0416'!B13","v":60}]
[null,null,null,"Porcentaje por Supervisión  =",2.5000000000000001E-2,null,null,"$/100 km-h : LÍNEAS 132 kV ",null,345.49299999999999,null,null,"RM por Transformador =",null,null,null,null,null,null,null,null,null,null,null," - ","$/h-MVA"]
[null,null,null,null,null,null,null,"$/100 km-h : LÍNEAS 66 kV ",null," - ",null,null,"RM Salidas 132 kV =",null,null,null,null,null,null,null,null,null,null,null,16.042999999999999,"$/hs."]
[]
[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,"N°","LÍNEAS","U\n[kV]","Long.\n[km]","$/h","Salida","Entrada","Hs.\nIndisp. ","Minutos\nIndisp.","Tipo \nSal.(²)","C.R.\n%","PENALIZAC.\nPROGRAM.","REDUCC.\nPROGRAM.","PENALIZACIÓN FORZADA\nPor Salida    1ras. 3 hs.  hs. Restantes",null,null,"REDUCC. FORZADA\nPor Salida    1ras. 3 hs.  hs. Restantes",null,null,"RESTANTE\nFORZADA","REDUCC.\nRESTANTE","Informó\nenTérm.","TOTAL\nPENALIZAC."]
[]
[null,null,"I","PASO DE LOS LIBRES - MONTE CASEROS",132,101,{"$f":"IF(F26>25,F26,25)*IF(E26=220,$J$18,IF(E26=132,$J$19,$J$20))/100","v":348.94792999999999},"2016-04-06T21:16:00","2016-04-06T21:21:00",{"$f":"IF(D26=\"\",\"\",(I26-H26)*24)","v":8.3333333255723119E-2},{"$f":"IF(D26=\"\",\"\",ROUND((I26-H26)*24*60,0))","v":5},"F",{"$f":"IF(D26=\"\",\"\",\"--\")","v":"--"},{"$f":"IF(L26=\"P\",ROUND(K26/60,2)*G26*$K$18*0.01,\"--\")","v":"--"},{"$f":"IF(L26=\"RP\",ROUND(K26/60,2)*G26*$K$18*0.01*M26/100,\"--\")","v":"--"},{"$f":"IF(L26=\"F\",G26*$K$18,\"--\")","v":20936.875799999998},{"$f":"IF(AND(K26>10,L26=\"F\"),G26*$K$18*IF(K26>180,3,ROUND(K26/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(L26=\"F\",K26>180),(ROUND(K26/60,2)-3)*G26*$K$18*0.1,\"--\")","v":"--"},{"$f":"IF(L26=\"R\",G26*$K$18*M26/100,\"--\")","v":"--"},{"$f":"IF(AND(K26>10,L26=\"R\"),G26*$K$18*M26/100*IF(K26>180,3,ROUND(K26/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(L26=\"R\",K26>180),(ROUND(K26/60,2)-3)*G26*$K$18*0.1*M26/100,\"--\")","v":"--"},{"$f":"IF(L26=\"RF\",ROUND(K26/60,2)*G26*$K$18*0.1,\"--\")","v":"--"},{"$f":"IF(L26=\"RR\",ROUND(K26/60,2)*G26*$K$18*0.1*M26/100,\"--\")","v":"--"},"SI",{"$f":"IF(D26=\"\",\"\",SUM(N26:W26)*IF(X26=\"SI\",1,2))","v":20936.875799999998}]
[null,null,"II","PASO DE LOS LIBRES - MONTE CASEROS",132,101,{"$f":"IF(F27>25,F27,25)*IF(E27=220,$J$18,IF(E27=132,$J$19,$J$20))/100","v":348.94792999999999},"2016-04-13T05:20:00","2016-04-13T05:27:00",{"$f":"IF(D27=\"\",\"\",(I27-H27)*24)","v":0.11666666669771075},{"$f":"IF(D27=\"\",\"\",ROUND((I27-H27)*24*60,0))","v":7},"F",{"$f":"IF(D27=\"\",\"\",\"--\")","v":"--"},{"$f":"IF(L27=\"P\",ROUND(K27/60,2)*G27*$K$18*0.01,\"--\")","v":"--"},{"$f":"IF(L27=\"RP\",ROUND(K27/60,2)*G27*$K$18*0.01*M27/100,\"--\")","v":"--"},{"$f":"IF(L27=\"F\",G27*$K$18,\"--\")","v":20936.875799999998},{"$f":"IF(AND(K27>10,L27=\"F\"),G27*$K$18*IF(K27>180,3,ROUND(K27/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(L27=\"F\",K27>180),(ROUND(K27/60,2)-3)*G27*$K$18*0.1,\"--\")","v":"--"},{"$f":"IF(L27=\"R\",G27*$K$18*M27/100,\"--\")","v":"--"},{"$f":"IF(AND(K27>10,L27=\"R\"),G27*$K$18*M27/100*IF(K27>180,3,ROUND(K27/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(L27=\"R\",K27>180),(ROUND(K27/60,2)-3)*G27*$K$18*0.1*M27/100,\"--\")","v":"--"},{"$f":"IF(L27=\"RF\",ROUND(K27/60,2)*G27*$K$18*0.1,\"--\")","v":"--"},{"$f":"IF(L27=\"RR\",ROUND(K27/60,2)*G27*$K$18*0.1*M27/100,\"--\")","v":"--"},{"$f":"IF(D27=\"\",\"\",\"SI\")","v":"SI"},{"$f":"IF(D27=\"\",\"\",SUM(N27:W27)*IF(X27=\"SI\",1,2))","v":20936.875799999998}]
[null,null,"III",null,null,null,{"$f":"IF(F28>25,F28,25)*IF(E28=220,$J$18,IF(E28=132,$J$19,$J$20))/100","v":{"$error":"#VALUE!"}},null,null,{"$f":"IF(D28=\"\",\"\",(I28-H28)*24)","v":""},{"$f":"IF(D28=\"\",\"\",ROUND((I28-H28)*24*60,0))","v":""},null,{"$f":"IF(D28=\"\",\"\",\"--\")","v":""},{"$f":"IF(L28=\"P\",ROUND(K28/60,2)*G28*$K$18*0.01,\"--\")","v":"--"},{"$f":"IF(L28=\"RP\",ROUND(K28/60,2)*G28*$K$18*0.01*M28/100,\"--\")","v":"--"},{"$f":"IF(L28=\"F\",G28*$K$18,\"--\")","v":"--"},{"$f":"IF(AND(K28>10,L28=\"F\"),G28*$K$18*IF(K28>180,3,ROUND(K28/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(L28=\"F\",K28>180),(ROUND(K28/60,2)-3)*G28*$K$18*0.1,\"--\")","v":"--"},{"$f":"IF(L28=\"R\",G28*$K$18*M28/100,\"--\")","v":"--"},{"$f":"IF(AND(K28>10,L28=\"R\"),G28*$K$18*M28/100*IF(K28>180,3,ROUND(K28/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(L28=\"R\",K28>180),(ROUND(K28/60,2)-3)*G28*$K$18*0.1*M28/100,\"--\")","v":"--"},{"$f":"IF(L28=\"RF\",ROUND(K28/60,2)*G28*$K$18*0.1,\"--\")","v":"--"},{"$f":"IF(L28=\"RR\",ROUND(K28/60,2)*G28*$K$18*0.1*M28/100,\"--\")","v":"--"},{"$f":"IF(D28=\"\",\"\",\"SI\")","v":""},{"$f":"IF(D28=\"\",\"\",SUM(N28:W28)*IF(X28=\"SI\",1,2))","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(D29=\"\",\"\",(I29-H29)*24)","v":""},{"$f":"IF(D29=\"\",\"\",ROUND((I29-H29)*24*60,0))","v":""},null,{"$f":"IF(D29=\"\",\"\",\"--\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D29=\"\",\"\",\"SI\")","v":""},{"$f":"IF(D29=\"\",\"\",SUM(N29:W29)*IF(X29=\"SI\",1,2))","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Y26:Y29)","v":41873.751599999996}]
[]
[null,null,"N°","ESTACIÓN\nTRANSFORMADORA","EQUIPO","U\n[kV]","$/h","Salida","Entrada","Hs.\nIndisp.","Mtos.\nIndisp.","Tipo \nSal.(²)","AUT.","K","PENALIZ.\nPROGRAM.","PENALIZACIÓN FORZADA\nPor Salida    hs. Restantes",null,null,null,null,null,"RESTANTE\nFORZADA",null,"Informó\nenTérm.","TOTAL\nPENALIZAC."]
[]
[null,null,"I",null,null,null,{"$f":"Y20","v":16.042999999999999},null,null,{"$f":"IF(D34=\"\",\"\",(I34-H34)*24)","v":""},{"$f":"IF(D34=\"\",\"\",ROUND((I34-H34)*24*60,0))","v":""},null,{"$f":"IF(D34=\"\",\"\",IF(OR(L34=\"P\",L34=\"RP\"),\"--\",\"NO\"))","v":""},50,{"$f":"IF(L34=\"P\",G34*N34*ROUND(K34/60,2)*0.1,\"--\")","v":"--"},{"$f":"IF(AND(L34=\"F\",M34=\"NO\"),G34*N34,\"--\")","v":"--"},{"$f":"IF(L34=\"F\",G34*N34*ROUND(K34/60,2),\"--\")","v":"--"},null,null,null,null,{"$f":"IF(L34=\"RF\",G34*N34*ROUND(K34/60,2),\"--\")","v":"--"},null,{"$f":"IF(D34=\"\",\"\",\"SI\")","v":""},{"$f":"IF(D34=\"\",\"\",SUM(O34:V34)*IF(X34=\"SI\",1,2)*IF(F34=\"500/220\",0,1))","v":""}]
[null,null,"II",null,null,null,{"$f":"Y20","v":16.042999999999999},null,null,{"$f":"IF(D35=\"\",\"\",(I35-H35)*24)","v":""},{"$f":"IF(D35=\"\",\"\",ROUND((I35-H35)*24*60,0))","v":""},null,{"$f":"IF(D35=\"\",\"\",IF(OR(L35=\"P\",L35=\"RP\"),\"--\",\"NO\"))","v":""},50,{"$f":"IF(L35=\"P\",G35*N35*ROUND(K35/60,2)*0.1,\"--\")","v":"--"},{"$f":"IF(AND(L35=\"F\",M35=\"NO\"),G35*N35,\"--\")","v":"--"},{"$f":"IF(L35=\"F\",G35*N35*ROUND(K35/60,2),\"--\")","v":"--"},null,null,null,null,{"$f":"IF(L35=\"RF\",G35*N35*ROUND(K35/60,2),\"--\")","v":"--"},null,{"$f":"IF(D35=\"\",\"\",\"SI\")","v":""},{"$f":"IF(D35=\"\",\"\",SUM(O35:V35)*IF(X35=\"SI\",1,2)*IF(F35=\"500/220\",0,1))","v":""}]
[null,null,"III",null,null,null,{"$f":"Y20","v":16.042999999999999},null,null,{"$f":"IF(D36=\"\",\"\",(I36-H36)*24)","v":""},{"$f":"IF(D36=\"\",\"\",ROUND((I36-H36)*24*60,0))","v":""},null,{"$f":"IF(D36=\"\",\"\",IF(OR(L36=\"P\",L36=\"RP\"),\"--\",\"NO\"))","v":""},50,{"$f":"IF(L36=\"P\",G36*N36*ROUND(K36/60,2)*0.1,\"--\")","v":"--"},{"$f":"IF(AND(L36=\"F\",M36=\"NO\"),G36*N36,\"--\")","v":"--"},{"$f":"IF(L36=\"F\",G36*N36*ROUND(K36/60,2),\"--\")","v":"--"},null,null,null,null,{"$f":"IF(L36=\"RF\",G36*N36*ROUND(K36/60,2),\"--\")","v":"--"},null,{"$f":"IF(D36=\"\",\"\",\"SI\")","v":""},{"$f":"IF(D36=\"\",\"\",SUM(O36:V36)*IF(X36=\"SI\",1,2)*IF(F36=\"500/220\",0,1))","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Y34:Y37)","v":0}]
[null,null,null,null,null,null,null,"SM=",{"$f":"Y30+Y38","v":41873.751599999996}]
[]
[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","kV","km",null,null,"RM por Cap. Transporte",null,"RM por E. E. T.",null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL"]
[]
[null,null,null,"PASO DE LOS LIBRES - MONTE CASEROS",132,100.7,null,null,{"$f":"F45*$J$19*$E$18/100","v":250496.24472000002},null,27938,null,{"$f":"\"(DTE \"&DATO!$G$14&DATO!$H$14&\")\"","v":"(DTE 0416)"},null,null,null,null,null,null,null,null,null,null,{"$f":"I45+I49","v":262047.20472000001}]
[]
[null,null,null,"E.T.","kV","SALIDA","SALIDA",null,"RM por Conexión"]
[]
[null,null,null,"PASO DE LOS LIBRES",132,"INTERRUPTOR TRAFO 1",null,null,{"$f":"Y20*E18","v":11550.96}]
[]
[]
[null,null,null,null,null,null,null,"RM =",{"$f":"X45+I49","v":273598.16472},null,null,null,"RM * =",null,null,null,null,null,null,null,null,null,null,114908.42088000001]
[]
[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":"E19*X52","v":2872.7105220000003},null,null,"RM* = VALOR EMPLEADO PARA CALCULAR CS"]
[]
[null,null,"e) SANCIÓN"]
[null,null,null,"Sanción Calculada",{"$f":"10*Y30*I56/I52","v":4396.6364664777684}]
[]
[null,null,null,"TOTAL A PENALIZAR A TRANSNEA S.A. POR SUPERVISIÓN A  D.P.E.C."]
[]
[null,null,null,null,null,null,null,"SANCIÓN  =",{"$f":"IF(E59>3*I56,3*I56,$E$59)","v":4396.6364664777684}]

{"sheet":"SUP-ENECOR","index":8,"n_rows":44,"n_cols":20,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'TOT-0416'!B2","v":"ANEXO IV al Memorandum D.T.E.E. N° 294  /2017"}]
[]
["ENTE NACIONAL REGULADOR "]
["DE LA ELECTRICIDAD"]
[]
[]
[null,null,null,"SISTEMA DE TRANSPORTE DE ENERGÍA ELÉCTRICA POR DISTRIBUCIÓN TRONCAL - TRANSNEA S.A."]
[]
[null,null,null,"3.2.-SUPERVISIÓN - Transportista Independiente E.N.E.C.O.R. S.A."]
[]
[null,{"$f":"'TOT-0416'!B14","v":"Desde el 01 al 30 de abril de 2016"}]
[]
[]
[]
[null,null,"a) Datos"]
[]
[null,null,null,"Tiempo de servicio =",{"$f":"MID(B12,16,2)*24","v":720},"hs",null,null,"$/100 km-h : LÍNEAS 220 kV "," - "]
[null,null,null,"Porcentaje por Supervisión  =",2.5000000000000001E-2,null,null,null,"$/100 km-h : LÍNEAS 132 kV ",345.49299999999999]
[]
[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,"SEGÚN 1.3.",null,null,null,"SM =",3420.38]
[]
[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","kV","km",null,null,"RM por Cap. Transporte",null,"RM por E. E. T.",null,null,null,null,null,null,null,null,"TOTAL"]
[]
[null,null,null,"PASO DE LA PATRIA - STA. CATALINA 1",132,20.8,null,null,{"$f":"F29*$J$19*$E$18/100","v":51741.031679999993},null,73359,null,{"$f":"\"(DTE \"&[4]DATO!$G$14&[4]DATO!$H$14&\")\"","v":"(DTE 0416)"},null,null,null,null,null,null,{"$f":"SUM(I29:K29)","v":125100.03167999999}]
[null,null,null,"PASO DE LA PATRIA - STA. CATALINA 2",132,20.8,null,null,{"$f":"F30*$J$19*$E$18/100","v":51741.031679999993},null,0,null,{"$f":"\"(DTE \"&[4]DATO!$G$14&[4]DATO!$H$14&\")\"","v":"(DTE 0416)"},null,null,null,null,null,null,{"$f":"SUM(I30:K30)","v":51741.031679999993}]
[]
[]
[null,null,null,null,null,null,null,"RM =",{"$f":"SUM(T29:T30)","v":176841.06335999997},null,null,"RM *=",107121.49343999999]
[]
[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":"E19*M33","v":2678.0373359999999}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"hs"]
[null,null,"e) SANCIÓN"]
[null,null,null,"Sanción Calculada",{"$f":"10*I23*I37/I33","v":517.97388961977799}]
[]
[null,null,null,"TOTAL A PENALIZAR A TRANSNEA S.A. POR SUPERVISIÓN A  E.N.E.C.O.R. S.A."]
[]
[null,null,null,null,null,null,null,"SANCIÓN  =",{"$f":"IF(E40>3*I37,3*I37,$E$40)","v":517.97388961977799},null,null,"RM * = VALOR EMPLEADO PARA CALCULAR CS"]

{"sheet":"DATO","index":9,"n_rows":27,"n_cols":29,"rows_kept":27,"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,{"$f":"+D3+1","v":2008}]
["abril","04",30,{"$f":"+D4+1","v":2009}]
["mayo","05",31,2010]
["junio","06",30,2011]
["julio","07",31,2012]
["agosto","08",31,2013]
["septiembre","09",30,2014]
["octubre","10",31,2015]
["noviembre","11",30,2016]
["diciembre","12",31,null,null,null,null,null,"Total"]
[11,4,{"$f":"CELL(\"CONTENIDO\",OFFSET(A1,B14,0))","v":"abril"},{"$f":"CELL(\"CONTENIDO\",OFFSET(C1,B14,0))","v":30},{"$f":"CELL(\"CONTENIDO\",OFFSET(D1,A14,0))","v":2016},{"$f":"\"Desde el 01 al \" & D14 & \" de \" & C14 & \" de \" & E14","v":"Desde el 01 al 30 de abril de 2016"},{"$f":"CELL(\"CONTENIDO\",OFFSET(B1,B14,0))","v":"04"},{"$f":"RIGHT(E14,2)","v":"16"},"B14"]
[null,{"$f":"\"\\\\rugor\\files\\Transporte\\Transporte\\AA PROCESO AUT ARCHIVOS J\\TRANSNEA\\\" &E14","v":"\\\\rugor\\files\\Transporte\\Transporte\\AA PROCESO AUT ARCHIVOS J\\TRANSNEA\\2016"},null,null,null,null,{"$f":"\"J\"&G14&H14&\"NEA\"","v":"J0416NEA"}]
[null,{"$f":"\"\\\\rugor\\files\\Transporte\\transporte\\AA PROCESO AUT\\INTERCAMBIO\\\" &H14&G14","v":"\\\\rugor\\files\\Transporte\\transporte\\AA PROCESO AUT\\INTERCAMBIO\\1604"}]
["Hoja","FilaInicio","FilasPlantilla","Columnas","NombreHoja","OrigenDeDatos","Col00","Col01","Col02","Col03","Col04","Col05","Col06","Col07","Col08","Col09","Col10","Col11","Col12","Col13","Col14","Col15","FILHTOTAL","COLHTOTAL","FILHCALC","COLHCALC","FILTRANSP","COLTRANSP","COL TSAL"]
["MODELO L",23,20,11,{"$f":"\"LI-\" & $G$14","v":"LI-04"},"TRANSNEA_INDISPONIBILIDADES_LINEAS_TRANSNEA.XLS",3,5,4,6,7,8,0,10,11,14,0,26,0,0,0,0,20,9,44,27,21,27,14]
["MODELO T",22,20,13,{"$f":"\"T-\" & $G$14","v":"T-04"},"TRANSNEA_INDISPONIBILIDADES_TRAFOS_TRANSNEA.XLS",3,5,4,6,7,8,9,11,12,15,16,18,28,17,0,0,28,9,43,29,20,29,15]
["MODELO S",22,20,10,{"$f":"\"SA-\" & $G$14","v":"SA-04"},"TRANSNEA_INDISPONIBILIDADES_SALIDAS_TRANSNEA.XLS",3,5,4,6,7,8,10,11,14,15,21,0,0,0,0,0,32,9,43,22,20,22,14]
["MODELO L DPEC",23,20,11,{"$f":"\"LI-DPEC-\" & $G$14","v":"LI-DPEC-04"},"TRANSNEA_INDISPONIBILIDADES_LINEAS_DPEC.XLS",3,5,4,6,7,8,0,10,11,14,0,26,0,0,0,0,21,9,44,27,21,27,14]
["MODELO L ENECOR",23,20,11,{"$f":"\"LI-ENECOR-\" & $G$14","v":"LI-ENECOR-04"},"TRANSNEA_INDISPONIBILIDADES_LINEAS_ENECOR.XLS",3,5,4,6,7,8,0,10,11,14,0,26,0,0,0,0,22,9,44,27,21,27,14]
["MODELO L ELING",25,20,11,{"$f":"\"LI-ELECT-\" & $G$14","v":"LI-ELECT-04"},"TRANSNEA_INDISPONIBILIDADES_LINEAS_ELECTROINGENIERIA.XLS",3,5,4,6,7,8,0,10,11,14,0,26,0,0,0,0,23,9,44,27,21,27,14]
["MODELO T ELING",22,20,13,{"$f":"\"T-ELECT-\" & $G$14","v":"T-ELECT-04"},"TRANSNEA_INDISPONIBILIDADES_TRAFOS_ELECTROINGENIERIA.XLS",3,5,4,6,7,8,9,11,12,15,16,18,28,17,0,0,29,9,43,29,20,29,15]
["MODELO S ELING",22,20,10,{"$f":"\"SA-ELECT-\" & $G$14","v":"SA-ELECT-04"},"TRANSNEA_INDISPONIBILIDADES_SALIDAS_ELECTROINGENIERIA.XLS",3,5,4,6,7,8,10,11,14,15,21,0,0,0,0,0,33,9,43,22,20,22,14]
["SUP-DPEC",26,25,11,"SUP-DPEC","TRANSNEA_INDISPONIBILIDADES_LINEAS_DPEC.XLS",0,0,0,4,5,6,0,8,9,12,0,24,0,0,0,0,0,0,0,0,0,0,0]
["MODELO VST",19,24,4,{"$f":"\"CAUSAS-VST-\" & $G$14","v":"CAUSAS-VST-04"},"TRANSNEA_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]