{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["TOT-0616","LI-06 (1)","LI-06 (2)","LI-DPEC-06 (1)","T-06 (1)","T-06 (2)","SA-06 (1)","SUP-DPEC","DATO"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"defined_names":25,"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-0616","index":0,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[null,"ANEXO VI 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 junio 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-06 (2)'!AA44","v":238296.17}]
[null,null,null,"1.2.-","Transportista Independiente D.P.E.C.",null,null,null,{"$f":"'LI-DPEC-06 (1)'!AA44","v":159865.63}]
[]
[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-06 (2)'!AC44","v":55068.05}]
[]
[null,null,null,"2.2.-","Salidas"]
[null,null,null,null,"2.2.1.-","Equipamiento propio",null,null,{"$f":"'SA-06 (1)'!V43","v":32666.55}]
[]
[null,null,"3.-","SUPERVISIÓN"]
[null,null,null,"3.1.-","Transportista Independiente D.P.E.C.",null,null,null,{"$f":"'SUP-DPEC'!I66","v":8618.131566}]
[]
[null,null,null,null,null,"TOTAL ",{"$f":"SUM(I20:I32)","v":494514.53156600002}]

{"sheet":"LI-06 (1)","index":1,"n_rows":44,"n_cols":27,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"+'TOT-0616'!B2","v":"ANEXO VI 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-0616'!B14","v":"Desde el 01 al 30 de junio 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-0616'!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 66 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-06-01","2016-06-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-06-01","2016-06-08T14:22:00",{"$f":"IF(F24=\"\",\"\",(K24-J24)*24)","v":182.36666666669771},{"$f":"IF(F24=\"\",\"\",ROUND((K24-J24)*24*60,0))","v":10942},"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":94511.337615000026},{"$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":94511.337615000026}]
[null,null,3,303335,739,"BARRANQUERAS - RESISTENCIA 1",132,31.399999618530273,108.48480068204879,"2016-06-01T08:05:00","2016-06-01T10:50:00",2.7500000000582077,165,"P","--",178.9999211253805,"--","--","--","--","--","--","--","--","--","SI",178.9999211253805]
[null,null,4,303337,4800,"RESISTENCIA - BARRANQUERAS (RESIST. N.)",132,12.600000381469727,86.373250000000013,"2016-06-03T07:06:00","2016-06-03T15:05:00",7.9833333333372138,479,"P","--",413.5551210000001,"--","--","--","--","--","--","--","--","--","SI",413.5551210000001]
[null,null,5,303636,741,"CORR. CENTRO - STA. CANTALINA",132,10.199999809265137,86.373250000000013,"2016-06-06T08:50:00","2016-06-06T15:28:00",6.6333333333022892,398,"P","--",343.5927885000001,"--","--","--","--","--","--","--","--","--","SI",343.5927885000001]
[null,null,6,303637,741,"CORR. CENTRO - STA. CANTALINA",132,10.199999809265137,86.373250000000013,"2016-06-07T07:47:00","2016-06-07T13:02:00",5.25,315,"P","--",272.07573750000006,"--","--","--","--","--","--","--","--","--","SI",272.07573750000006]
[null,null,7,303639,5047,"GRAN FORMOSA - CLORINDA",132,103.5,357.58525499999996,"2016-06-08T07:49:00","2016-06-08T12:28:00",4.6499999999650754,279,"P","--",997.66286144999992,"--","--","--","--","--","--","--","--","--","SI",997.66286144999992]
[null,null,8,303642,5557,"MANSILLA - RESISTENCIA 132 1",132,109.5,378.31483500000002,"2016-06-08T08:58:00","2016-06-08T10:53:00",1.9166666666278616,115,"P","--",435.81868992000005,"--","--","--","--","--","--","--","--","--","SI",435.81868992000005]
[null,null,9,303643,5047,"GRAN FORMOSA - CLORINDA",132,103.5,357.58525499999996,"2016-06-09T07:42:00","2016-06-09T13:25:00",5.716666666790843,343,"P","--",1227.2325951599998,"--","--","--","--","--","--","--","--","--","SI",1227.2325951599998]
[null,null,10,303751,746,"MONTE CASEROS - CHAJARI",132,74.5,257.39228500000002,"2016-06-14T08:19:00","2016-06-14T14:09:00",5.8333333333139308,350,"P","--",900.35821293000015,"--","--","--","--","--","--","--","--","--","SI",900.35821293000015]
[null,null,11,303753,746,"MONTE CASEROS - CHAJARI",132,74.5,257.39228500000002,"2016-06-15T07:52:00","2016-06-15T14:11:00",6.3166666666511446,379,"P","--",976.03154472000006,"--","--","--","--","--","--","--","--","--","SI",976.03154472000006]
[null,null,12,303754,746,"MONTE CASEROS - CHAJARI",132,74.5,257.39228500000002,"2016-06-16T07:45:00","2016-06-16T14:25:00",6.6666666667442769,400,"P","--",1030.0839245699999,"--","--","--","--","--","--","--","--","--","SI",1030.0839245699999]
[null,null,13,303755,4317,"PIRANE - IBARRETA",132,91.800003051757813,317.16258454360963,"2016-06-16T08:05:00","2016-06-16T11:04:00",2.9833333332790062,179,"P","--",567.086701163974,"--","--","--","--","--","--","--","--","--","SI",567.086701163974]
[null,null,14,303760,5044,"GRAN FORMOSA - PIRANE   1",132,111.59999847412109,385.57018272819522,"2016-06-19T22:35:00","2016-06-19T22:45:00",0.16666666668606922,10,"F","--","--","--",23134.210963691712,"--","--","--","--","--","--","--","SI",23134.210963691712]
[null,null,15,303987,743,"SALTO GRANDE  AR - CHAJARI",132,60.900001525878906,210.40524227180481,"2016-06-23T08:31:00","2016-06-23T13:28:00",4.9500000000698492,297,"P","--",624.9035695472603,"--","--","--","--","--","--","--","--","--","SI",624.9035695472603]
[null,null,16,303989,743,"SALTO GRANDE  AR - CHAJARI",132,60.900001525878906,210.40524227180481,"2016-06-24T08:15:00","2016-06-24T15:18:00",7.0499999999301508,423,"P","--",890.01417480973441,"--","--","--","--","--","--","--","--","--","SI",890.01417480973441]
[null,null,17,303990,742,"RESISTENCIA - CORR. CENTRO",132,33,114.01269000000001,"2016-06-24T09:05:00","2016-06-24T09:35:00",0.50000000005820766,30,"F","--","--","--",6840.7614000000003,3420.3807000000002,"--","--","--","--","--","--","SI",10261.142100000001]
[null,null,18,304244,743,"SALTO GRANDE  AR - CHAJARI",132,60.900001525878906,{"$f":"IF(H40>25,H40,25)*IF(G40=220,$G$16,IF(G40=132,$G$17,$G$18))/100","v":210.40524227180481},"2016-06-28T21:15:00","2016-06-28T21:23:00",{"$f":"IF(F40=\"\",\"\",(K40-J40)*24)","v":0.13333333341870457},{"$f":"IF(F40=\"\",\"\",ROUND((K40-J40)*24*60,0))","v":8},"F",{"$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":12624.314536308288},{"$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":"--"},"SI",12624.314536308288]
[null,null,19,304263,5394,"SANTA CATALINA -BELLA VISTA 132 1",132,121,{"$f":"IF(H41>25,H41,25)*IF(G41=220,$G$16,IF(G41=132,$G$17,$G$18))/100","v":418.04652999999996},"2016-06-30T01:09:00","2016-06-30T01:19:00",{"$f":"IF(F41=\"\",\"\",(K41-J41)*24)","v":0.16666666651144624},{"$f":"IF(F41=\"\",\"\",ROUND((K41-J41)*24*60,0))","v":10},"F",{"$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":25082.791799999999},{"$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":"--"},"SI",25082.791799999999]
[null,null,null,null,null,null,null,null,{"$f":"IF(H42>25,H42,25)*IF(G42=220,$G$16,IF(G42=132,$G$17,$G$18))/100","v":86.373250000000013},null,null,{"$f":"IF(F42=\"\",\"\",(K42-J42)*24)","v":""},{"$f":"IF(F42=\"\",\"\",ROUND((K42-J42)*24*60,0))","v":""},null,{"$f":"IF(F42=\"\",\"\",\"--\")","v":""},{"$f":"IF(N42=\"P\",ROUND(M42/60,2)*I42*$L$17*0.01,\"--\")","v":"--"},{"$f":"IF(N42=\"RP\",ROUND(M42/60,2)*I42*$L$17*0.01*O42/100,\"--\")","v":"--"},{"$f":"IF(N42=\"F\",I42*$L$17,\"--\")","v":"--"},{"$f":"IF(AND(M42>10,N42=\"F\"),I42*$L$17*IF(M42>180,3,ROUND(M42/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(N42=\"F\",M42>180),(ROUND(M42/60,2)-3)*I42*$L$17*0.1,\"--\")","v":"--"},{"$f":"IF(N42=\"R\",I42*$L$17*O42/100,\"--\")","v":"--"},{"$f":"IF(AND(M42>10,N42=\"R\"),I42*$L$17*O42/100*IF(M42>180,3,ROUND(M42/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(N42=\"R\",M42>180),(ROUND(M42/60,2)-3)*I42*$L$17*0.1*O42/100,\"--\")","v":"--"},{"$f":"IF(N42=\"RF\",ROUND(M42/60,2)*I42*$L$17*0.1,\"--\")","v":"--"},{"$f":"IF(N42=\"RR\",ROUND(M42/60,2)*I42*$L$17*0.1*O42/100,\"--\")","v":"--"},{"$f":"IF(F42=\"\",\"\",\"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:P43)","v":71543.665762396355},{"$f":"SUM(Q21:Q43)","v":0},{"$f":"SUM(R21:R43)","v":67682.078699999998},3420.3807000000002,0,0,0,0,94511.337615000026,0,null,{"$f":"ROUND(SUM(AA21:AA43),2)","v":237157.46}]

{"sheet":"LI-06 (2)","index":2,"n_rows":44,"n_cols":27,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"+'TOT-0616'!B2","v":"ANEXO VI 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-0616'!B14","v":"Desde el 01 al 30 de junio 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-0616'!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 66 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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'LI-06 (1)'!AA44","v":237157.46}]
[]
[null,null,20,304280,743,"SALTO GRANDE  AR - CHAJARI",132,60.900001525878906,{"$f":"IF(H23>25,H23,25)*IF(G23=220,$G$16,IF(G23=132,$G$17,$G$18))/100","v":210.40524227180481},"2016-06-30T08:00:00","2016-06-30T17:01:00",{"$f":"IF(F23=\"\",\"\",(K23-J23)*24)","v":9.0166666665463708},{"$f":"IF(F23=\"\",\"\",ROUND((K23-J23)*24*60,0))","v":541},"P",{"$f":"IF(F23=\"\",\"\",\"--\")","v":"--"},{"$f":"IF(N23=\"P\",ROUND(M23/60,2)*I23*$L$17*0.01,\"--\")","v":1138.7131711750076},{"$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":1138.7131711750076}]
[null,null,null,null,null,null,null,null,{"$f":"IF(H24>25,H24,25)*IF(G24=220,$G$16,IF(G24=132,$G$17,$G$18))/100","v":86.373250000000013},null,null,{"$f":"IF(F24=\"\",\"\",(K24-J24)*24)","v":""},{"$f":"IF(F24=\"\",\"\",ROUND((K24-J24)*24*60,0))","v":""},null,{"$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":"--"},{"$f":"IF(N24=\"RR\",ROUND(M24/60,2)*I24*$L$17*0.1*O24/100,\"--\")","v":"--"},{"$f":"IF(F24=\"\",\"\",\"SI\")","v":""},{"$f":"IF(F24=\"\",\"\",SUM(P24:Y24)*IF(Z24=\"SI\",1,2))","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,"","--","--","--","--","--","--","--","--","--","--","",""]
[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,"","--","--","--","--","--","--","--","--","--","--","",""]
[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,null,null,null,null,null,null,{"$f":"IF(H42>25,H42,25)*IF(G42=220,$G$16,IF(G42=132,$G$17,$G$18))/100","v":86.373250000000013},null,null,{"$f":"IF(F42=\"\",\"\",(K42-J42)*24)","v":""},{"$f":"IF(F42=\"\",\"\",ROUND((K42-J42)*24*60,0))","v":""},null,{"$f":"IF(F42=\"\",\"\",\"--\")","v":""},{"$f":"IF(N42=\"P\",ROUND(M42/60,2)*I42*$L$17*0.01,\"--\")","v":"--"},{"$f":"IF(N42=\"RP\",ROUND(M42/60,2)*I42*$L$17*0.01*O42/100,\"--\")","v":"--"},{"$f":"IF(N42=\"F\",I42*$L$17,\"--\")","v":"--"},{"$f":"IF(AND(M42>10,N42=\"F\"),I42*$L$17*IF(M42>180,3,ROUND(M42/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(N42=\"F\",M42>180),(ROUND(M42/60,2)-3)*I42*$L$17*0.1,\"--\")","v":"--"},{"$f":"IF(N42=\"R\",I42*$L$17*O42/100,\"--\")","v":"--"},{"$f":"IF(AND(M42>10,N42=\"R\"),I42*$L$17*O42/100*IF(M42>180,3,ROUND(M42/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(N42=\"R\",M42>180),(ROUND(M42/60,2)-3)*I42*$L$17*0.1*O42/100,\"--\")","v":"--"},{"$f":"IF(N42=\"RF\",ROUND(M42/60,2)*I42*$L$17*0.1,\"--\")","v":"--"},{"$f":"IF(N42=\"RR\",ROUND(M42/60,2)*I42*$L$17*0.1*O42/100,\"--\")","v":"--"},{"$f":"IF(F42=\"\",\"\",\"SI\")","v":""},""]
[]
[null,null,"(²)","P - PROGRAMADA",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P21:P43)","v":1138.7131711750076},{"$f":"SUM(Q21:Q43)","v":0},{"$f":"SUM(R21:R43)","v":0},0,0,0,0,0,0,0,null,{"$f":"ROUND(SUM(AA21:AA43),2)","v":238296.17}]

{"sheet":"LI-DPEC-06 (1)","index":3,"n_rows":44,"n_cols":27,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"+'TOT-0616'!B2","v":"ANEXO VI 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-0616'!B14","v":"Desde el 01 al 30 de junio 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-0616'!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,47,303677,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-06-12T02:47:00","2016-06-12T16:45:00",{"$f":"IF(F23=\"\",\"\",(K23-J23)*24)","v":13.96666666661622},{"$f":"IF(F23=\"\",\"\",ROUND((K23-J23)*24*60,0))","v":838},"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":26387.724600000001},{"$f":"IF(AND(N23=\"F\",M23>180),(ROUND(M23/60,2)-3)*I23*$L$16*0.1,\"--\")","v":9649.1112954},{"$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":44832.744095399998}]
[null,null,48,303748,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-06-13T06:30:00","2016-06-13T12:44:00",6.2333333332207985,{"$f":"IF(F24=\"\",\"\",ROUND((K24-J24)*24*60,0))","v":374},"F","--","--","--",8795.9081999999999,26387.724600000001,2841.0783486,"--","--","--",{"$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":38024.711148599999}]
[null,null,49,303756,1001,"PASO DE LOS LIBRES - MONTE CASEROS",132,101,146.59846999999999,"2016-06-18T02:05:00","2016-06-18T02:15:00",0.16666666668606922,10,"F","--","--","--",8795.9081999999999,"--","--","--","--","--","--","--","SI",8795.9081999999999]
[null,null,50,303758,1001,"PASO DE LOS LIBRES - MONTE CASEROS",132,101,146.59846999999999,"2016-06-18T03:42:00","2016-06-18T12:15:00",8.5499999999301508,513,"F","--","--","--",8795.9081999999999,26387.724600000001,4881.7290510000003,"--","--","--","--","--","SI",40065.361851000001]
[null,null,51,303981,1001,"PASO DE LOS LIBRES - MONTE CASEROS",132,101,146.59846999999999,"2016-06-22T05:55:00","2016-06-22T06:02:00",0.11666666652308777,7,"F","--","--","--",8795.9081999999999,"--","--","--","--","--","--","--","SI",8795.9081999999999]
[null,null,52,304240,1001,"PASO DE LOS LIBRES - MONTE CASEROS",132,101,146.59846999999999,"2016-06-27T22:54:00","2016-06-27T23:04:00",0.16666666651144624,10,"F","--","--","--",8795.9081999999999,"--","--","--","--","--","--","--","SI",8795.9081999999999]
[null,null,53,304261,1001,"PASO DE LOS LIBRES - MONTE CASEROS",132,101,146.59846999999999,"2016-06-29T06:38:00","2016-06-29T06:50:00",0.19999999995343387,12,"F","--","--","--",8795.9081999999999,1759.18164,"--","--","--","--","--","--","SI",10555.089840000001]
[null,null,null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,"","",null,"","--","--","--","--","--","--","--","--","--","--",{"$f":"IF(F30=\"\",\"\",\"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,{"$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,61571.357399999994,80922.355439999999,17371.918695,0,0,0,0,0,null,{"$f":"ROUND(SUM(AA21:AA43),2)","v":159865.63}]

{"sheet":"T-06 (1)","index":4,"n_rows":43,"n_cols":29,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"+'TOT-0616'!B2","v":"ANEXO VI 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-0616'!B14","v":"Desde el 01 al 30 de junio 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-0616'!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,21,303245,754,"BARRANQUERAS","TRAFO 1",20,"33/13,2",{"$f":"H21*$I$16","v":24.700000000000003},"2016-06-01","2016-06-03T14:20:00",{"$f":"IF(F21=\"\",\"\",(L21-K21)*24)","v":62.333333333255723},{"$f":"IF(F21=\"\",\"\",ROUND((L21-K21)*24*60,0))","v":3740},"P",{"$f":"IF(F21=\"\",\"\",IF(OR(O21=\"P\",O21=\"RP\"),\"--\",\"NO\"))","v":"--"},"0,000","NO",{"$f":"$I$17*IF(OR(O21=\"P\",O21=\"RP\"),0.1,1)*IF(R21=\"SI\",1,0.1)","v":0.60000000000000009},{"$f":"IF(O21=\"P\",J21*S21*ROUND(N21/60,2),\"--\")","v":923.73060000000021},{"$f":"IF(O21=\"RP\",J21*S21*ROUND(N21/60,2)*Q21/100,\"--\")","v":"--"},{"$f":"IF(AND(O21=\"F\",P21=\"NO\"),J21*S21,\"--\")","v":"--"},{"$f":"IF(O21=\"F\",J21*S21*ROUND(N21/60,2),\"--\")","v":"--"},{"$f":"IF(AND(O21=\"R\",P21=\"NO\"),J21*S21*Q21/100,\"--\")","v":"--"},{"$f":"IF(O21=\"R\",J21*S21*ROUND(N21/60,2)*Q21/100,\"--\")","v":"--"},{"$f":"IF(O21=\"RF\",J21*S21*ROUND(N21/60,2),\"--\")","v":"--"},{"$f":"IF(O21=\"RR\",J21*S21*ROUND(N21/60,2)*Q21/100,\"--\")","v":"--"},{"$f":"IF(F21=\"\",\"\",\"SI\")","v":"SI"},{"$f":"IF(F21=\"\",\"\",SUM(T21:AA21)*IF(AB21=\"SI\",1,2))","v":923.73060000000021}]
[null,null,22,303334,764,"FORMOSA","TRAFO 3",30,"132/13,2",{"$f":"H22*$I$16","v":37.050000000000004},"2016-06-01T07:35:00","2016-06-01T12:30:00",{"$f":"IF(F22=\"\",\"\",(L22-K22)*24)","v":4.9166666668024845},{"$f":"IF(F22=\"\",\"\",ROUND((L22-K22)*24*60,0))","v":295},"P",{"$f":"IF(F22=\"\",\"\",IF(OR(O22=\"P\",O22=\"RP\"),\"--\",\"NO\"))","v":"--"},"0,000","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":109.37160000000003},{"$f":"IF(O22=\"RP\",J22*S22*ROUND(N22/60,2)*Q22/100,\"--\")","v":"--"},{"$f":"IF(AND(O22=\"F\",P22=\"NO\"),J22*S22,\"--\")","v":"--"},{"$f":"IF(O22=\"F\",J22*S22*ROUND(N22/60,2),\"--\")","v":"--"},{"$f":"IF(AND(O22=\"R\",P22=\"NO\"),J22*S22*Q22/100,\"--\")","v":"--"},{"$f":"IF(O22=\"R\",J22*S22*ROUND(N22/60,2)*Q22/100,\"--\")","v":"--"},{"$f":"IF(O22=\"RF\",J22*S22*ROUND(N22/60,2),\"--\")","v":"--"},{"$f":"IF(O22=\"RR\",J22*S22*ROUND(N22/60,2)*Q22/100,\"--\")","v":"--"},{"$f":"IF(F22=\"\",\"\",\"SI\")","v":"SI"},{"$f":"IF(F22=\"\",\"\",SUM(T22:AA22)*IF(AB22=\"SI\",1,2))","v":109.37160000000003}]
[null,null,23,303336,4708,"GOYA","TRAFO 1",30,"132/33/13,2",{"$f":"H23*$I$16","v":37.050000000000004},"2016-06-02T08:48:00","2016-06-04T15:28:00",54.666666666569654,3280,"P","--","0,000","NO",0.60000000000000009,{"$f":"IF(O23=\"P\",J23*S23*ROUND(N23/60,2),\"--\")","v":1215.3141000000005},"--","--","--","--","--","--","--","SI",{"$f":"IF(F23=\"\",\"\",SUM(T23:AA23)*IF(AB23=\"SI\",1,2))","v":1215.3141000000005}]
[null,null,24,303338,4204,"MONTE CASEROS","TRAFO 2",15,"132/33/13,2",18.525000000000002,"2016-06-03T20:11:00","2016-06-03T20:18:00",0.11666666669771075,7,"F","NO","0,000","SI",60,"--","--",1111.5000000000002,133.38000000000002,"--","--","--","--","SI",1244.8800000000003]
[null,null,25,303341,5459,"LOMITAS NEA","TR1",30,"132/33/13.2",37.050000000000004,"2016-06-05T08:44:00","2016-06-05T10:34:00",1.8333333333721384,110,"P","--","0,000","NO",0.60000000000000009,40.680900000000015,"--","--","--","--","--","--","--","SI",40.680900000000015]
[null,null,26,303638,754,"BARRANQUERAS","TRAFO 1",20,"33/13,2",24.700000000000003,"2016-06-07T08:07:00","2016-06-07T13:07:00",5.0000000000582077,300,"P","--","0,000","NO",0.60000000000000009,74.100000000000023,"--","--","--","--","--","--","--","SI",74.100000000000023]
[null,null,27,303640,768,"GOYA","TRAFO 2",15,"132/33/13,2",18.525000000000002,"2016-06-08T08:27:00","2016-06-10T11:43:00",51.266666666662786,3076,"P","--","0,000","NO",0.60000000000000009,569.8660500000002,"--","--","--","--","--","--","--","SI",569.8660500000002]
[null,null,28,303644,750,"BARRANQUERAS","TRAFO 4",15,"132/33/13,2",18.525000000000002,"2016-06-09T08:21:00","2016-06-09T12:23:00",4.03333333338378,242,"F","NO","0,000","SI",60,"--","--",1111.5000000000002,4479.3450000000012,"--","--","--","--","SI",5590.8450000000012]
[null,null,29,303646,752,"BARRANQUERAS","TRAFO 7",30,"132/33/13,2",37.050000000000004,"2016-06-09T08:21:00","2016-06-09T12:23:00",4.03333333338378,242,"F","NO","0,000","SI",60,"--","--",2223.0000000000005,8958.6900000000023,"--","--","--","--","SI",11181.690000000002]
[null,null,30,303647,753,"BARRANQUERAS","TRAFO 9",30,"132/33/13,2",37.050000000000004,"2016-06-09T08:21:00","2016-06-09T12:23:00",4.03333333338378,242,"F","NO","0,000","SI",60,"--","--",2223.0000000000005,8958.6900000000023,"--","--","--","--","SI",11181.690000000002]
[null,null,31,303645,2662,"BARRANQUERAS","TRAFO 5",15,"132/33/13,2",18.525000000000002,"2016-06-09T08:21:00","2016-06-09T12:23:00",4.03333333338378,242,"F","NO","0,000","SI",60,"--","--",1111.5000000000002,4479.3450000000012,"--","--","--","--","SI",5590.8450000000012]
[null,null,32,303679,752,"BARRANQUERAS","TRAFO 7",30,"132/33/13,2",37.050000000000004,"2016-06-09T12:24:00","2016-06-30T23:59:00",515.58333333319752,30935,"RP","--",50,"NO",0.60000000000000009,"--",5730.6717000000026,"--","--","--","--","--","--","SI",5730.6717000000026]
[null,null,33,303750,764,"FORMOSA","TRAFO 3",30,"132/13,2",37.050000000000004,"2016-06-14T07:43:00","2016-06-14T12:28:00",4.7499999999417923,285,"RP","--",60,"NO",0.60000000000000009,"--",63.355500000000021,"--","--","--","--","--","--","SI",63.355500000000021]
[null,null,34,303752,1336,"FORMOSA","TRAFO 4",30,"132/34,5/13,8",37.050000000000004,"2016-06-15T07:38:00","2016-06-15T11:14:00",3.5999999998603016,216,"RP","--",60,"NO",0.60000000000000009,"--",48.016800000000018,"--","--","--","--","--","--","SI",48.016800000000018]
[null,null,35,302913,752,"BARRANQUERAS","TRAFO 7",30,"132/33/13,2",37.050000000000004,"2016-06-01","2016-06-09T08:20:00",200.33333333325572,12020,"RP","--",50,"NO",0.60000000000000009,"--",2226.6679500000009,"--","--","--","--","--","--","SI",2226.6679500000009]
[null,null,36,303983,3305,"FORMOSA","TRAFO 1",30,"132/33/13,8",37.050000000000004,"2016-06-22T07:41:00","2016-06-22T12:08:00",4.4500000000116415,267,"RP","--",40,"NO",0.60000000000000009,"--",39.569400000000016,"--","--","--","--","--","--","SI",35.884799999999998]
[null,null,37,303984,4204,"MONTE CASEROS","TRAFO 2",15,"132/33/13,2",18.525000000000002,"2016-06-22T21:07:00","2016-06-22T21:36:00",0.48333333333721384,29,"F","NO","0,000","SI",60,"--","--",1111.5000000000002,533.5200000000001,"--","--","--","--","SI",149.184]
[null,null,38,303986,1336,"FORMOSA","TRAFO 4",30,"132/34,5/13,8",37.050000000000004,"2016-06-23T07:31:00","2016-06-23T12:26:00",4.9166666666278616,295,"RP","--",60,"NO",0.60000000000000009,"--",65.62296000000002,"--","--","--","--","--","--","SI",59.512320000000003]
[null,null,39,303988,4866,"CLORINDA","TRAFO 3",150,"220/132/13,2",185.25000000000003,"2016-06-24T07:46:00","2016-06-24T12:20:00",4.5666666667093523,274,"P","--","0,000","NO",0.60000000000000009,507.9555000000002,"--","--","--","--","--","--","--","SI",460.65600000000006]
[null,null,40,304233,3305,"FORMOSA","TRAFO 1",30,"132/33/13,8",37.050000000000004,"2016-06-27T05:54:00","2016-06-27T06:17:00",0.38333333336049691,23,"F","NO","0,000","SI",60,"--","--",2223.0000000000005,844.74000000000024,"--","--","--","--","SI",1094.6879999999999]
[null,null,"40b","304233b",3305,"FORMOSA","TRAFO 1",30,"132/33/13,8",37.050000000000004,"2016-06-27T06:17:00","2016-06-27T10:20:00",4.0499999999301508,243,"RF","NO",0,"NO",6,"--","--","--","--","--","--",900.31500000000005,"--","SI",900.31500000000005]
[]
[null,null,"(²)","P - PROGRAMADA  ; F - FORZADA  ; RP - REDUCCIÓN PROGRAMADA  ; RF - RESTANTE FORZADA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T20:T42)","v":3441.0187500000006},{"$f":"SUM(U20:U42)","v":8173.9043100000035},11115.000000000002,28387.71000000001,0,0,900.31500000000005,0,null,{"$f":"ROUND(SUM(AC20:AC42),2)","v":48491.97}]

{"sheet":"T-06 (2)","index":5,"n_rows":44,"n_cols":29,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"+'TOT-0616'!B2","v":"ANEXO VI 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-0616'!B14","v":"Desde el 01 al 30 de junio 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-0616'!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-06 (1)'!AC43","v":48491.97}]
[]
[null,null,41,304242,4204,"MONTE CASEROS","TRAFO 2",15,"132/33/13,2",{"$f":"H22*$I$16","v":18.525000000000002},"2016-06-28T11:34:00","2016-06-28T11:42:00",{"$f":"IF(F22=\"\",\"\",(L22-K22)*24)","v":0.13333333341870457},{"$f":"IF(F22=\"\",\"\",ROUND((L22-K22)*24*60,0))","v":8},"F",{"$f":"IF(F22=\"\",\"\",IF(OR(O22=\"P\",O22=\"RP\"),\"--\",\"NO\"))","v":"NO"},"0,000","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":1111.5000000000002},{"$f":"IF(O22=\"F\",J22*S22*ROUND(N22/60,2),\"--\")","v":144.49500000000003},{"$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":1255.9950000000003}]
[null,null,42,304274,4204,"MONTE CASEROS","TRAFO 2",15,"132/33/13,2",{"$f":"H23*$I$16","v":18.525000000000002},"2016-06-30T04:27:00","2016-06-30T05:02:00",0.58333333331393078,35,"F","NO","0,000","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":1111.5000000000002},{"$f":"IF(O23=\"F\",J23*S23*ROUND(N23/60,2),\"--\")","v":644.67000000000007},{"$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",1756.1700000000003]
[null,null,43,304276,4204,"MONTE CASEROS","TRAFO 2",15,"132/33/13,2",18.525000000000002,"2016-06-30T05:34:00","2016-06-30T05:42:00",0.13333333341870457,8,"F","NO","0,000","SI",60,"--","--",1111.5000000000002,144.49500000000003,"--","--","--","--","SI",1255.9950000000003]
[null,null,44,304278,4204,"MONTE CASEROS","TRAFO 2",15,"132/33/13,2",18.525000000000002,"2016-06-30T06:10:00","2016-06-30T06:43:00",0.55000000004656613,33,"F","NO","0,000","SI",60,"--","--",1111.5000000000002,611.32500000000016,"--","--","--","--","SI",1722.8250000000003]
[null,null,"44b",304278,4204,"MONTE CASEROS","TRAFO 2",15,"132/33/13,2",{"$f":"H26*$I$16","v":18.525000000000002},"2016-06-30T06:43:00","2016-06-30T11:06:00",4.3833333333022892,263,"RF","NO","0,000","NO",{"$f":"$I$17*IF(OR(O26=\"P\",O26=\"RP\"),0.1,1)*IF(R26=\"SI\",1,0.1)","v":6},{"$f":"IF(O26=\"P\",J26*S26*ROUND(N26/60,2),\"--\")","v":"--"},{"$f":"IF(O26=\"RP\",J26*S26*ROUND(N26/60,2)*Q26/100,\"--\")","v":"--"},{"$f":"IF(AND(O26=\"F\",P26=\"NO\"),J26*S26,\"--\")","v":"--"},{"$f":"IF(O26=\"F\",J26*S26*ROUND(N26/60,2),\"--\")","v":"--"},{"$f":"IF(AND(O26=\"R\",P26=\"NO\"),J26*S26*Q26/100,\"--\")","v":"--"},{"$f":"IF(O26=\"R\",J26*S26*ROUND(N26/60,2)*Q26/100,\"--\")","v":"--"},{"$f":"IF(O26=\"RF\",J26*S26*ROUND(N26/60,2),\"--\")","v":486.83699999999999},{"$f":"IF(O26=\"RR\",J26*S26*ROUND(N26/60,2)*Q26/100,\"--\")","v":"--"},"SI",486.83699999999999]
[null,null,45,304281,3305,"FORMOSA","TRAFO 1",30,"132/33/13,8",37.050000000000004,"2016-06-30T08:44:00","2016-06-30T13:09:00",4.4166666667442769,265,"P","--","0,000","NO",0.60000000000000009,98.256600000000034,"--","--","--","--","--","--","--",{"$f":"IF(F27=\"\",\"\",\"SI\")","v":"SI"},98.256600000000034]
[]
[null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"IF(F29=\"\",\"\",(L29-K29)*24)","v":""},{"$f":"IF(F29=\"\",\"\",ROUND((L29-K29)*24*60,0))","v":""},null,{"$f":"IF(F29=\"\",\"\",IF(OR(O29=\"P\",O29=\"RP\"),\"--\",\"NO\"))","v":""},{"$f":"IF(F29=\"\",\"\",\"--\")","v":""},{"$f":"IF(F29=\"\",\"\",\"NO\")","v":""},6,"--","--","--","--","--","--","--","--",{"$f":"IF(F29=\"\",\"\",\"SI\")","v":""},{"$f":"IF(F29=\"\",\"\",SUM(T29:AA29)*IF(AB29=\"SI\",1,2))","v":""}]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"IF(F31=\"\",\"\",(L31-K31)*24)","v":""},{"$f":"IF(F31=\"\",\"\",ROUND((L31-K31)*24*60,0))","v":""},null,{"$f":"IF(F31=\"\",\"\",IF(OR(O31=\"P\",O31=\"RP\"),\"--\",\"NO\"))","v":""},{"$f":"IF(F31=\"\",\"\",\"--\")","v":""},{"$f":"IF(F31=\"\",\"\",\"NO\")","v":""},6,"--","--","--","--","--","--","--","--",{"$f":"IF(F31=\"\",\"\",\"SI\")","v":""},{"$f":"IF(F31=\"\",\"\",SUM(T31:AA31)*IF(AB31=\"SI\",1,2))","v":""}]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,{"$f":"IF(F36=\"\",\"\",(L36-K36)*24)","v":""},{"$f":"IF(F36=\"\",\"\",ROUND((L36-K36)*24*60,0))","v":""},null,{"$f":"IF(F36=\"\",\"\",IF(OR(O36=\"P\",O36=\"RP\"),\"--\",\"NO\"))","v":""},{"$f":"IF(F36=\"\",\"\",\"--\")","v":""},{"$f":"IF(F36=\"\",\"\",\"NO\")","v":""},6,"--","--","--","--","--","--","--","--",{"$f":"IF(F36=\"\",\"\",\"SI\")","v":""},{"$f":"IF(F36=\"\",\"\",SUM(T36:AA36)*IF(AB36=\"SI\",1,2))","v":""}]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"",{"$f":"IF(F40=\"\",\"\",\"--\")","v":""},{"$f":"IF(F40=\"\",\"\",\"NO\")","v":""},6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"",{"$f":"IF(F41=\"\",\"\",\"--\")","v":""},{"$f":"IF(F41=\"\",\"\",\"NO\")","v":""},6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"",{"$f":"IF(F42=\"\",\"\",\"--\")","v":""},{"$f":"IF(F42=\"\",\"\",\"NO\")","v":""},6,"--","--","--","--","--","--","--","--","",""]
[]
[null,null,"(²)","P - PROGRAMADA  ; F - FORZADA  ; RF - RESTANTE FORZADA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T20:T43)","v":98.256600000000034},0,4446.0000000000009,1544.9850000000001,0,0,486.83699999999999,0,null,{"$f":"ROUND(SUM(AC20:AC43),2)","v":55068.05}]

{"sheet":"SA-06 (1)","index":6,"n_rows":43,"n_cols":22,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"+'TOT-0616'!B2","v":"ANEXO VI 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-0616'!B14","v":"Desde el 01 al 30 de junio de 2016"}]
[]
[null,null,null,null,null,"Salida en 220 kV",16.042999999999999,{"$f":"60*'TOT-0616'!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-0616'!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-0616'!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-0616'!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,46,303641,776,"BARRANQUERAS","LINEA CDAD. RESISTENCIA 1",33,{"$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":12.029},"2016-06-08T08:51:00","2016-06-30T23:59:00",{"$f":"IF(F22=\"\",\"\",(K22-J22)*24)","v":543.13333333324408},{"$f":"IF(F22=\"\",\"\",ROUND((K22-J22)*24*60,0))","v":32588},"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":50},{"$f":"IF(N22=\"P\",I22*P22*ROUND(M22/60,2)*0.1,\"--\")","v":32666.553850000004},{"$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":32666.553850000004}]
[null,null,null,null,null,null,null,null,{"$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},null,null,{"$f":"IF(F23=\"\",\"\",(K23-J23)*24)","v":""},{"$f":"IF(F23=\"\",\"\",ROUND((K23-J23)*24*60,0))","v":""},null,{"$f":"IF(F23=\"\",\"\",IF(OR(N23=\"P\",N23=\"RP\"),\"--\",\"NO\"))","v":""},{"$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":40},{"$f":"IF(N23=\"P\",I23*P23*ROUND(M23/60,2)*0.1,\"--\")","v":"--"},{"$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":"--"},{"$f":"IF(F23=\"\",\"\",\"SI\")","v":""},{"$f":"IF(F23=\"\",\"\",SUM(Q23:T23)*IF(U23=\"SI\",1,2)*IF(H23=\"500/220\",0,1))","v":""}]
[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,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,"(²)","P - PROGRAMADA",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q20:Q42)","v":32666.553850000004},{"$f":"SUM(R20:R42)","v":0},{"$f":"SUM(S20:S42)","v":0},{"$f":"SUM(T20:T42)","v":0},null,{"$f":"ROUND(SUM(V20:V42),2)","v":32666.55}]

{"sheet":"SUP-DPEC","index":7,"n_rows":66,"n_cols":26,"rows_kept":66,"cut":false,"hidden":false,"merged":[[11,1,11,25]]}
[]
[null,{"$f":"'TOT-0616'!B2","v":"ANEXO VI 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-0616'!B14","v":"Desde el 01 al 30 de junio 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-0616'!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-06-12T02:47:00","2016-06-12T16:45:00",{"$f":"IF(D26=\"\",\"\",(I26-H26)*24)","v":13.96666666661622},{"$f":"IF(D26=\"\",\"\",ROUND((I26-H26)*24*60,0))","v":838},"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":62810.627399999998},{"$f":"IF(AND(L26=\"F\",K26>180),(ROUND(K26/60,2)-3)*G26*$K$18*0.1,\"--\")","v":22967.752752600005},{"$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":"--"},{"$f":"IF(D26=\"\",\"\",\"SI\")","v":"SI"},{"$f":"IF(D26=\"\",\"\",SUM(N26:W26)*IF(X26=\"SI\",1,2))","v":106715.2559526}]
[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-06-13T06:30:00","2016-06-13T12:44:00",{"$f":"IF(D27=\"\",\"\",(I27-H27)*24)","v":6.2333333332207985},{"$f":"IF(D27=\"\",\"\",ROUND((I27-H27)*24*60,0))","v":374},"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":62810.627399999998},{"$f":"IF(AND(L27=\"F\",K27>180),(ROUND(K27/60,2)-3)*G27*$K$18*0.1,\"--\")","v":6762.6108834000006},{"$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":"--"},"SI",90510.114083399996]
[null,null,"III","PASO DE LOS LIBRES - MONTE CASEROS",132,101,{"$f":"IF(F28>25,F28,25)*IF(E28=220,$J$18,IF(E28=132,$J$19,$J$20))/100","v":348.94792999999999},"2016-06-18T02:05:00","2016-06-18T02:15:00",0.16666666668606922,10,"F",{"$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":20936.875799999998},{"$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":"--"},"SI",20936.875799999998]
[null,null,"IV","PASO DE LOS LIBRES - MONTE CASEROS",132,101,348.94792999999999,"2016-06-18T03:42:00","2016-06-18T12:15:00",8.5499999999301508,513,"F","--","--","--",20936.875799999998,62810.627399999998,11619.966069000002,"--","--","--","--","--","SI",95367.469268999994]
[null,null,"V","PASO DE LOS LIBRES - MONTE CASEROS",132,101,348.94792999999999,"2016-06-22T05:55:00","2016-06-22T06:02:00",0.11666666652308777,7,"F","--","--","--",20936.875799999998,"--","--","--","--","--","--","--","SI",20936.875799999998]
[null,null,"VI","PASO DE LOS LIBRES - MONTE CASEROS",132,101,348.94792999999999,"2016-06-27T22:54:00","2016-06-27T23:04:00",0.16666666651144624,10,"F","--","--","--",20936.875799999998,"--","--","--","--","--","--","--","SI",20936.875799999998]
[null,null,"VII","PASO DE LOS LIBRES - MONTE CASEROS",132,101,348.94792999999999,"2016-06-29T06:38:00","2016-06-29T06:50:00",0.19999999995343387,12,"F","--","--","--",20936.875799999998,4187.3751599999996,"--","--","--","--","--","--","SI",25124.250959999998]
[null,null,"VIII",null,null,null,{"$f":"IF(F33>25,F33,25)*IF(E33=220,$J$18,IF(E33=132,$J$19,$J$20))/100","v":{"$error":"#VALUE!"}},null,null,"","",null,{"$f":"IF(D33=\"\",\"\",\"--\")","v":""},"--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(D34=\"\",\"\",(I34-H34)*24)","v":""},{"$f":"IF(D34=\"\",\"\",ROUND((I34-H34)*24*60,0))","v":""},null,{"$f":"IF(D34=\"\",\"\",\"--\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(D34=\"\",\"\",\"SI\")","v":""},{"$f":"IF(D34=\"\",\"\",SUM(N34:W34)*IF(X34=\"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:Y34)","v":380527.71766499989}]
[]
[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(D39=\"\",\"\",(I39-H39)*24)","v":""},{"$f":"IF(D39=\"\",\"\",ROUND((I39-H39)*24*60,0))","v":""},null,{"$f":"IF(D39=\"\",\"\",IF(OR(L39=\"P\",L39=\"RP\"),\"--\",\"NO\"))","v":""},50,{"$f":"IF(L39=\"P\",G39*N39*ROUND(K39/60,2)*0.1,\"--\")","v":"--"},{"$f":"IF(AND(L39=\"F\",M39=\"NO\"),G39*N39,\"--\")","v":"--"},{"$f":"IF(L39=\"F\",G39*N39*ROUND(K39/60,2),\"--\")","v":"--"},null,null,null,null,{"$f":"IF(L39=\"RF\",G39*N39*ROUND(K39/60,2),\"--\")","v":"--"},null,{"$f":"IF(D39=\"\",\"\",\"SI\")","v":""},{"$f":"IF(D39=\"\",\"\",SUM(O39:V39)*IF(X39=\"SI\",1,2)*IF(F39=\"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(Y39:Y40)","v":0}]
[null,null,null,null,null,null,null,"SM=",{"$f":"Y35+Y41","v":380527.71766499989}]
[]
[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":"F48*$J$19*$E$18/100","v":250496.24472000002},null,57951,null,{"$f":"\"(DTE \"&[1]DATO!$G$14&[1]DATO!$H$14&\")\"","v":"(DTE 0516)"},null,null,null,null,null,null,null,null,null,null,{"$f":"I48+I52","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":"X48+I52","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*X55","v":2872.7105220000003},null,null,"RM* = VALOR EMPLEADO PARA CALCULAR CS"]
[]
[null,null,"e) SANCIÓN"]
[null,null,null,"Sanción Calculada",{"$f":"10*Y35*I59/I55","v":39954.433889116714}]
[]
[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(E62>3*I59,3*I59,$E$62)","v":8618.131566}]

{"sheet":"DATO","index":8,"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,6,{"$f":"CELL(\"CONTENIDO\",OFFSET(A1,B14,0))","v":"junio"},{"$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 junio de 2016"},{"$f":"CELL(\"CONTENIDO\",OFFSET(B1,B14,0))","v":"06"},{"$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":"J0616NEA"}]
[null,{"$f":"\"\\\\rugor\\files\\Transporte\\transporte\\AA PROCESO AUT\\INTERCAMBIO\\\" &H14&G14","v":"\\\\rugor\\files\\Transporte\\transporte\\AA PROCESO AUT\\INTERCAMBIO\\1606"}]
["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-06"},"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-06"},"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-06"},"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-06"},"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-06"},"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-06"},"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-06"},"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-06"},"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-06"},"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]