{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["TOT-0116","LI-01 (1)","T-01 (1)","T-01 (2)","DATO"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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-0116","index":0,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[null,"ANEXO I 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 31 de enero 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-01 (1)'!AA45","v":1573663.47}]
[]
[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-01 (2)'!AC43","v":110761.19}]
[]
[]
[]
[null,null,null,null,null,"TOTAL ",{"$f":"SUM(I20:I25)","v":1684424.66}]

{"sheet":"LI-01 (1)","index":1,"n_rows":45,"n_cols":27,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"+'TOT-0116'!B2","v":"ANEXO I 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-0116'!B14","v":"Desde el 01 al 31 de enero 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-0116'!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-01-01","2016-01-31T23:59:59",{"$f":"IF(F23=\"\",\"\",(K23-J23)*24)","v":743.99972222215729},{"$f":"IF(F23=\"\",\"\",ROUND((K23-J23)*24*60,0))","v":44640},"P",{"$f":"IF(F23=\"\",\"\",\"--\")","v":"--"},{"$f":"IF(N23=\"P\",ROUND(M23/60,2)*I23*$L$17*0.01,\"--\")","v":64775.791583999991},{"$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":64775.791583999991}]
[null,null,2,289100,1002,"BARRANQUERAS - CORRIENTES 1",33,11.800000190734863,{"$f":"IF(H24>25,H24,25)*IF(G24=220,$G$16,IF(G24=132,$G$17,$G$18))/100","v":86.373250000000013},"2016-01-01","2016-01-31T23:59:59",{"$f":"IF(F24=\"\",\"\",(K24-J24)*24)","v":743.99972222215729},{"$f":"IF(F24=\"\",\"\",ROUND((K24-J24)*24*60,0))","v":44640},"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":385570.18800000008},{"$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":385570.18800000008}]
[null,null,3,291181,946,"PASO DE LOS LIBRES - URUGUAYANA",132,3.9000000953674316,86.373250000000013,"2016-01-01","2016-01-31T23:59:59",743.99972222215729,44640,"RF","--","--","--","--","--","--","--","--","--",385570.18800000008,"--","SI",385570.18800000008]
[null,null,4,296379,1003,"BARRANQUERAS - CORRIENTES 2",33,11.800000190734863,86.373250000000013,"2016-01-01","2016-01-31T23:59:59",743.99972222215729,44640,"RF","--","--","--","--","--","--","--","--","--",385570.18800000008,"--","SI",385570.18800000008]
[null,null,5,296625,743,"SALTO GRANDE  AR - CHAJARI",132,60.900001525878906,210.40524227180481,"2016-01-03T01:28:00","2016-01-03T01:40:00",0.19999999995343387,12,"F","--","--","--",12624.314536308288,2524.8629072616577,"--","--","--","--","--","--","SI",15149.177443569944]
[null,null,6,296642,5047,"GRAN FORMOSA - CLORINDA",132,103.5,357.58525499999996,"2016-01-03T05:13:00","2016-01-03T06:06:00",0.88333333324408159,53,"F","--","--","--",21455.115299999998,18880.501463999997,"--","--","--","--","--","--","SI",40335.616763999991]
[null,null,7,296660,5047,"GRAN FORMOSA - CLORINDA",132,103.5,357.58525499999996,"2016-01-03T08:03:00","2016-01-03T08:37:00",0.56666666659293696,34,"F","--","--","--",21455.115299999998,12229.415720999998,"--","--","--","--","--","--","SI",33684.531020999995]
[null,null,8,297140,4049,"RINCON - VIRASORO  1",132,104.7,361.73117100000002,"2016-01-05T09:55:00","2016-01-05T10:12:00",0.28333333338377997,17,"F","--","--","--",21703.87026,6077.0836728000004,"--","--","--","--","--","--","SI",27780.953932799999]
[null,null,9,297505,5047,"GRAN FORMOSA - CLORINDA",132,103.5,357.58525499999996,"2016-01-12T13:36:00","2016-01-12T13:55:00",0.31666666665114462,19,"F","--","--","--",21455.115299999998,6865.6368959999991,"--","--","--","--","--","--","SI",28320.752195999998]
[null,null,10,297543,4584,"EL COLORADO - PIRANE",132,79.150001525878906,273.45771477180483,"2016-01-12T14:10:00","2016-01-12T17:27:00",3.283333333209157,197,"F","--","--","--",16407.462886308291,49222.388658924872,459.40896081663186,"--","--","--","--","--","SI",66089.260506049788]
[null,null,11,297548,5047,"GRAN FORMOSA - CLORINDA",132,103.5,357.58525499999996,"2016-01-12T14:10:00","2016-01-12T14:43:00",0.54999999987194315,33,"F","--","--","--",21455.115299999998,11800.313415000001,"--","--","--","--","--","--","SI",33255.428715000002]
[null,null,12,297599,5047,"GRAN FORMOSA - CLORINDA",132,103.5,357.58525499999996,"2016-01-14T14:05:00","2016-01-14T14:23:00",0.30000000010477379,18,"F","--","--","--",21455.115299999998,6436.5345899999993,"--","--","--","--","--","--","SI",27891.649889999997]
[null,null,13,297968,5044,"GRAN FORMOSA - PIRANE   1",132,111.59999847412109,385.57018272819522,"2016-01-22T21:30:00","2016-01-22T21:46:00",0.26666666666278616,16,"F","--","--","--",23134.210963691712,6246.236960196763,"--","--","--","--","--","--","SI",29380.447923888474]
[null,null,14,297992,746,"MONTE CASEROS - CHAJARI",132,74.5,257.39228500000002,"2016-01-23T14:40:00","2016-01-23T15:05:00",0.41666666662786156,25,"F","--","--","--",15443.537100000001,6486.2855820000004,"--","--","--","--","--","--","SI",21929.822682000002]
[null,null,15,298008,4317,"PIRANE - IBARRETA",132,91.800003051757813,317.16258454360963,"2016-01-24T07:07:00","2016-01-24T08:53:00",1.7666666666627862,106,"P","--",336.82666478531343,"--","--","--","--","--","--","--","--","--","SI",336.82666478531343]
[null,null,16,298332,5426,"CLORINDA - LAGUNA BLANCA",132,59,203.84087,"2016-01-25T14:48:00","2016-01-25T15:00:00",0.19999999995343387,12,"F","--","--","--",12230.4522,2446.0904399999999,"--","--","--","--","--","--","SI",14676.54264]
[null,null,17,298339,743,"SALTO GRANDE  AR - CHAJARI",132,60.900001525878906,210.40524227180481,"2016-01-26T22:05:00","2016-01-26T22:09:00",6.6666666709352285E-2,4,"F","--","--","--",12624.314536308288,"--","--","--","--","--","--","--","SI",12624.314536308288]
[null,null,18,298357,5044,"GRAN FORMOSA - PIRANE   1",132,111.59999847412109,385.57018272819522,"2016-01-31T07:07:00","2016-01-31T10:14:00",3.1166666666977108,187,"P","--",721.78738206718151,"--","--","--","--","--","--","--","--","--","SI",721.78738206718151]
[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,null,null,null,null,null,null,{"$f":"IF(H43>25,H43,25)*IF(G43=220,$G$16,IF(G43=132,$G$17,$G$18))/100","v":86.373250000000013},null,null,{"$f":"IF(F43=\"\",\"\",(K43-J43)*24)","v":""},{"$f":"IF(F43=\"\",\"\",ROUND((K43-J43)*24*60,0))","v":""},null,{"$f":"IF(F43=\"\",\"\",\"--\")","v":""},{"$f":"IF(N43=\"P\",ROUND(M43/60,2)*I43*$L$17*0.01,\"--\")","v":"--"},{"$f":"IF(N43=\"RP\",ROUND(M43/60,2)*I43*$L$17*0.01*O43/100,\"--\")","v":"--"},{"$f":"IF(N43=\"F\",I43*$L$17,\"--\")","v":"--"},{"$f":"IF(AND(M43>10,N43=\"F\"),I43*$L$17*IF(M43>180,3,ROUND(M43/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(N43=\"F\",M43>180),(ROUND(M43/60,2)-3)*I43*$L$17*0.1,\"--\")","v":"--"},{"$f":"IF(N43=\"R\",I43*$L$17*O43/100,\"--\")","v":"--"},{"$f":"IF(AND(M43>10,N43=\"R\"),I43*$L$17*O43/100*IF(M43>180,3,ROUND(M43/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(N43=\"R\",M43>180),(ROUND(M43/60,2)-3)*I43*$L$17*0.1*O43/100,\"--\")","v":"--"},{"$f":"IF(N43=\"RF\",ROUND(M43/60,2)*I43*$L$17*0.1,\"--\")","v":"--"},{"$f":"IF(N43=\"RR\",ROUND(M43/60,2)*I43*$L$17*0.1*O43/100,\"--\")","v":"--"},{"$f":"IF(F43=\"\",\"\",\"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:P44)","v":65834.405630852489},{"$f":"SUM(Q21:Q44)","v":0},{"$f":"SUM(R21:R44)","v":221443.73898261657},129215.35030718327,459.40896081663186,0,0,0,1156710.5640000002,0,null,{"$f":"ROUND(SUM(AA21:AA44),2)","v":1573663.47}]

{"sheet":"T-01 (1)","index":2,"n_rows":43,"n_cols":29,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"+'TOT-0116'!B2","v":"ANEXO I 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-0116'!B14","v":"Desde el 01 al 31 de enero 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-0116'!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,19,296361,752,"BARRANQUERAS","TRAFO 7",30,"132/33/13,2",{"$f":"H22*$I$16","v":37.050000000000004},"2016-01-01","2016-01-31T23:59:59",{"$f":"IF(F22=\"\",\"\",(L22-K22)*24)","v":743.99972222215729},{"$f":"IF(F22=\"\",\"\",ROUND((L22-K22)*24*60,0))","v":44640},"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":8269.5600000000031},{"$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":8269.5600000000031}]
[null,null,20,297499,768,"GOYA","TRAFO 2",15,"132/33/13,2",{"$f":"H23*$I$16","v":18.525000000000002},"2016-01-11T14:39:00","2016-01-11T14:42:00",{"$f":"IF(F23=\"\",\"\",(L23-K23)*24)","v":4.9999999988358468E-2},{"$f":"IF(F23=\"\",\"\",ROUND((L23-K23)*24*60,0))","v":3},"R",{"$f":"IF(F23=\"\",\"\",IF(OR(O23=\"P\",O23=\"RP\"),\"--\",\"NO\"))","v":"NO"},40,"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":444.60000000000008},{"$f":"IF(O23=\"R\",J23*S23*ROUND(N23/60,2)*Q23/100,\"--\")","v":22.230000000000008},{"$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":466.8300000000001}]
[null,null,21,297503,5250,"EL  COLORADO","TRAFO 2",15,"132/33/13,2",18.525000000000002,"2016-01-11T15:38:00","2016-01-11T15:46:00",0.13333333341870457,8,"R","NO",40,"SI",60,"--","--","--","--",444.60000000000008,57.798000000000009,"--","--","SI",502.39800000000008]
[null,null,22,297523,759,"CORRIENTES","TRAFO 3",30,"132/33/13,2",37.050000000000004,"2016-01-12T13:36:00","2016-01-12T13:59:00",0.38333333336049691,23,"R","NO",60,"SI",60,"--","--","--","--",1333.8000000000002,506.84400000000016,"--","--","SI",1840.6440000000002]
[null,null,23,297524,3625,"CORRIENTES","TRAFO 4",50,"132/33/13,2",61.750000000000007,"2016-01-12T13:36:00","2016-01-12T13:59:00",0.38333333336049691,23,"F","NO","0,000","SI",60,"--","--",3705.0000000000005,1407.9,"--","--","--","--","SI",5112.9000000000005]
[null,null,24,297566,3305,"FORMOSA","TRAFO 1",30,"132/33/13,2",37.050000000000004,"2016-01-12T14:10:00","2016-01-12T14:23:00",0.21666666667442769,13,"F","NO","0,000","SI",60,"--","--",2223.0000000000005,489.06000000000012,"--","--","--","--","SI",2712.0600000000004]
[null,null,25,297567,764,"FORMOSA","TRAFO 3",30,"132/13,2",37.050000000000004,"2016-01-12T14:10:00","2016-01-12T14:23:00",0.21666666667442769,13,"F","NO","0,000","SI",60,"--","--",2223.0000000000005,489.06000000000012,"--","--","--","--","SI",2712.0600000000004]
[null,null,26,297568,765,"FORMOSA","TRAFO 2",15,"132/33/13,2",18.525000000000002,"2016-01-12T14:10:00","2016-01-12T14:23:00",0.21666666667442769,13,"F","NO","0,000","SI",60,"--","--",1111.5000000000002,244.53000000000006,"--","--","--","--","SI",1356.0300000000002]
[null,null,27,297569,1336,"FORMOSA","TRAFO 4",30,"132/33/13,2",37.050000000000004,"2016-01-12T14:10:00","2016-01-12T14:23:00",0.21666666667442769,13,"F","NO","0,000","SI",60,"--","--",2223.0000000000005,489.06000000000012,"--","--","--","--","SI",2712.0600000000004]
[null,null,28,297570,4611,"FORMOSA","TRAFO 5",30,"132/33/13,2",37.050000000000004,"2016-01-12T14:10:00","2016-01-12T14:23:00",0.21666666667442769,13,"F","NO","0,000","SI",60,"--","--",2223.0000000000005,489.06000000000012,"--","--","--","--","SI",2712.0600000000004]
[null,null,29,297596,4263,"BELLA VISTA","TRAFO 3",7.5,"132/33/13.2",9.2625000000000011,"2016-01-12T15:36:00","2016-01-12T16:04:00",0.46666666661622003,28,"R","NO",60,"SI",60,"--","--","--","--",333.45000000000005,156.72150000000002,"--","--","SI",490.17150000000004]
[null,null,30,297617,3305,"FORMOSA","TRAFO 1",30,"132/33/13,2",37.050000000000004,"2016-01-14T14:05:00","2016-01-14T14:24:00",0.31666666665114462,19,"F","NO","0,000","SI",60,"--","--",2223.0000000000005,711.36000000000013,"--","--","--","--","SI",2934.3600000000006]
[null,null,31,297618,764,"FORMOSA","TRAFO 3",30,"132/13,2",37.050000000000004,"2016-01-14T14:05:00","2016-01-14T14:24:00",0.31666666665114462,19,"F","NO","0,000","SI",60,"--","--",2223.0000000000005,711.36000000000013,"--","--","--","--","SI",2934.3600000000006]
[null,null,32,297619,765,"FORMOSA","TRAFO 2",15,"132/33/13,2",18.525000000000002,"2016-01-14T14:05:00","2016-01-14T14:24:00",0.31666666665114462,19,"F","NO","0,000","SI",60,"--","--",1111.5000000000002,355.68000000000006,"--","--","--","--","SI",1467.1800000000003]
[null,null,33,297620,1336,"FORMOSA","TRAFO 4",30,"132/33/13,2",37.050000000000004,"2016-01-14T14:05:00","2016-01-14T14:24:00",0.31666666665114462,19,"F","NO","0,000","SI",60,"--","--",2223.0000000000005,711.36000000000013,"--","--","--","--","SI",2934.3600000000006]
[null,null,34,297621,4611,"FORMOSA","TRAFO 5",30,"132/33/13,2",37.050000000000004,"2016-01-14T14:05:00","2016-01-14T14:24:00",0.31666666665114462,19,"F","NO","0,000","SI",60,"--","--",2223.0000000000005,711.36000000000013,"--","--","--","--","SI",2934.3600000000006]
[null,null,35,297647,754,"BARRANQUERAS","TRAFO 1",20,"33/13,2",24.700000000000003,"2016-01-15T08:27:00","2016-01-15T08:51:00",0.40000000008149073,24,"F","NO","0,000","SI",60,"--","--",1482.0000000000002,592.80000000000007,"--","--","--","--","SI",2074.8000000000002]
[null,null,36,297648,774,"BARRANQUERAS","TRAFO 2",20,"33/13,2",{"$f":"H39*$I$16","v":24.700000000000003},"2016-01-15T08:27:00","2016-01-15T08:51:00",{"$f":"IF(F39=\"\",\"\",(L39-K39)*24)","v":0.40000000008149073},{"$f":"IF(F39=\"\",\"\",ROUND((L39-K39)*24*60,0))","v":24},"F","NO","0,000","SI",{"$f":"$I$17*IF(OR(O39=\"P\",O39=\"RP\"),0.1,1)*IF(R39=\"SI\",1,0.1)","v":60},{"$f":"IF(O39=\"P\",J39*S39*ROUND(N39/60,2),\"--\")","v":"--"},{"$f":"IF(O39=\"RP\",J39*S39*ROUND(N39/60,2)*Q39/100,\"--\")","v":"--"},{"$f":"IF(AND(O39=\"F\",P39=\"NO\"),J39*S39,\"--\")","v":1482.0000000000002},{"$f":"IF(O39=\"F\",J39*S39*ROUND(N39/60,2),\"--\")","v":592.80000000000007},{"$f":"IF(AND(O39=\"R\",P39=\"NO\"),J39*S39*Q39/100,\"--\")","v":"--"},{"$f":"IF(O39=\"R\",J39*S39*ROUND(N39/60,2)*Q39/100,\"--\")","v":"--"},{"$f":"IF(O39=\"RF\",J39*S39*ROUND(N39/60,2),\"--\")","v":"--"},{"$f":"IF(O39=\"RR\",J39*S39*ROUND(N39/60,2)*Q39/100,\"--\")","v":"--"},"SI",2074.8000000000002]
[null,null,37,297846,759,"CORRIENTES","TRAFO 3",30,"132/33/13,2",{"$f":"H40*$I$16","v":37.050000000000004},"2016-01-20T14:36:00","2016-01-20T23:38:00",{"$f":"IF(F40=\"\",\"\",(L40-K40)*24)","v":9.0333333334419876},{"$f":"IF(F40=\"\",\"\",ROUND((L40-K40)*24*60,0))","v":542},"F","NO","0,000","SI",{"$f":"$I$17*IF(OR(O40=\"P\",O40=\"RP\"),0.1,1)*IF(R40=\"SI\",1,0.1)","v":60},{"$f":"IF(O40=\"P\",J40*S40*ROUND(N40/60,2),\"--\")","v":"--"},{"$f":"IF(O40=\"RP\",J40*S40*ROUND(N40/60,2)*Q40/100,\"--\")","v":"--"},{"$f":"IF(AND(O40=\"F\",P40=\"NO\"),J40*S40,\"--\")","v":2223.0000000000005},{"$f":"IF(O40=\"F\",J40*S40*ROUND(N40/60,2),\"--\")","v":20073.690000000002},{"$f":"IF(AND(O40=\"R\",P40=\"NO\"),J40*S40*Q40/100,\"--\")","v":"--"},{"$f":"IF(O40=\"R\",J40*S40*ROUND(N40/60,2)*Q40/100,\"--\")","v":"--"},{"$f":"IF(O40=\"RF\",J40*S40*ROUND(N40/60,2),\"--\")","v":"--"},{"$f":"IF(O40=\"RR\",J40*S40*ROUND(N40/60,2)*Q40/100,\"--\")","v":"--"},"SI",22296.690000000002]
[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,"",{"$f":"IF(F41=\"\",\"\",\"--\")","v":""},{"$f":"IF(F41=\"\",\"\",\"NO\")","v":""},{"$f":"$I$17*IF(OR(O41=\"P\",O41=\"RP\"),0.1,1)*IF(R41=\"SI\",1,0.1)","v":6},{"$f":"IF(O41=\"P\",J41*S41*ROUND(N41/60,2),\"--\")","v":"--"},{"$f":"IF(O41=\"RP\",J41*S41*ROUND(N41/60,2)*Q41/100,\"--\")","v":"--"},{"$f":"IF(AND(O41=\"F\",P41=\"NO\"),J41*S41,\"--\")","v":"--"},{"$f":"IF(O41=\"F\",J41*S41*ROUND(N41/60,2),\"--\")","v":"--"},{"$f":"IF(AND(O41=\"R\",P41=\"NO\"),J41*S41*Q41/100,\"--\")","v":"--"},{"$f":"IF(O41=\"R\",J41*S41*ROUND(N41/60,2)*Q41/100,\"--\")","v":"--"},{"$f":"IF(O41=\"RF\",J41*S41*ROUND(N41/60,2),\"--\")","v":"--"},{"$f":"IF(O41=\"RR\",J41*S41*ROUND(N41/60,2)*Q41/100,\"--\")","v":"--"},{"$f":"IF(F41=\"\",\"\",\"SI\")","v":""},""]
[]
[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:T42)","v":0},{"$f":"SUM(U20:U42)","v":8269.5600000000031},28899.000000000004,28069.080000000005,2556.4500000000007,743.59350000000018,0,0,null,{"$f":"ROUND(SUM(AC20:AC42),2)","v":68537.679999999993}]

{"sheet":"T-01 (2)","index":3,"n_rows":43,"n_cols":29,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"+'TOT-0116'!B2","v":"ANEXO I 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-0116'!B14","v":"Desde el 01 al 31 de enero 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-0116'!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-01 (1)'!AC43","v":68537.679999999993}]
[]
[null,null,38,297847,3625,"CORRIENTES","TRAFO 4",50,"132/33/13,2",{"$f":"H22*$I$16","v":61.750000000000007},"2016-01-20T14:36:00","2016-01-20T21:09:00",{"$f":"IF(F22=\"\",\"\",(L22-K22)*24)","v":6.5500000000465661},{"$f":"IF(F22=\"\",\"\",ROUND((L22-K22)*24*60,0))","v":393},"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":3705.0000000000005},{"$f":"IF(O22=\"F\",J22*S22*ROUND(N22/60,2),\"--\")","v":24267.750000000004},{"$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":27972.750000000004}]
[null,null,39,297866,4263,"BELLA VISTA","TRAFO 3",7.5,"132/33/13.2",{"$f":"H23*$I$16","v":9.2625000000000011},"2016-01-20T14:36:00","2016-01-20T15:20:00",{"$f":"IF(F23=\"\",\"\",(L23-K23)*24)","v":0.73333333345362917},{"$f":"IF(F23=\"\",\"\",ROUND((L23-K23)*24*60,0))","v":44},"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":333.45000000000005},{"$f":"IF(O23=\"R\",J23*S23*ROUND(N23/60,2)*Q23/100,\"--\")","v":243.41850000000002},{"$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":576.86850000000004}]
[null,null,40,297869,3305,"FORMOSA","TRAFO 1",30,"132/33/13,2",37.050000000000004,"2016-01-20T14:36:00","2016-01-20T14:55:00",0.31666666682576761,19,"F","NO","0,000","SI",60,"--","--",2223.0000000000005,711.36000000000013,"--","--","--","--","SI",2934.3600000000006]
[null,null,41,297870,764,"FORMOSA","TRAFO 3",30,"132/13,2",37.050000000000004,"2016-01-20T14:36:00","2016-01-20T14:55:00",0.31666666682576761,19,"F","NO","0,000","SI",60,"--","--",2223.0000000000005,711.36000000000013,"--","--","--","--","SI",2934.3600000000006]
[null,null,42,297871,765,"FORMOSA","TRAFO 2",15,"132/33/13,2",18.525000000000002,"2016-01-20T14:36:00","2016-01-20T14:55:00",0.31666666682576761,19,"F","NO","0,000","SI",60,"--","--",1111.5000000000002,355.68000000000006,"--","--","--","--","SI",1467.1800000000003]
[null,null,43,297872,1336,"FORMOSA","TRAFO 4",30,"132/33/13,2",37.050000000000004,"2016-01-20T14:36:00","2016-01-20T14:55:00",0.31666666682576761,19,"F","NO","0,000","SI",60,"--","--",2223.0000000000005,711.36000000000013,"--","--","--","--","SI",2934.3600000000006]
[null,null,44,297873,4611,"FORMOSA","TRAFO 5",30,"132/33/13,2",37.050000000000004,"2016-01-20T14:36:00","2016-01-20T14:55:00",0.31666666682576761,19,"F","NO","0,000","SI",60,"--","--",2223.0000000000005,711.36000000000013,"--","--","--","--","SI",2934.3600000000006]
[null,null,45,297965,4263,"BELLA VISTA","TRAFO 3",7.5,"132/33/13.2",9.2625000000000011,"2016-01-21T15:09:00","2016-01-21T15:31:00",0.36666666663950309,22,"R","NO",60,"SI",60,"--","--","--","--",333.45000000000005,123.37650000000002,"--","--","SI",456.82650000000007]
[null,null,46,298356,4318,"PIRANE","TRAFO 1",15,"132/33/13.2",18.525000000000002,"2016-01-31T07:06:00","2016-01-31T08:13:00",1.1166666668141261,67,"P","--","0,000",{"$f":"IF(F30=\"\",\"\",\"NO\")","v":"NO"},0.60000000000000009,12.448800000000006,"--","--","--","--","--","--","--","SI",12.448800000000006]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"",{"$f":"IF(F31=\"\",\"\",\"--\")","v":""},"",6,"--","--","--","--","--","--","--","--",{"$f":"IF(F31=\"\",\"\",\"SI\")","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,"","",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,{"$f":"H39*$I$16","v":0},null,null,{"$f":"IF(F39=\"\",\"\",(L39-K39)*24)","v":""},{"$f":"IF(F39=\"\",\"\",ROUND((L39-K39)*24*60,0))","v":""},null,"",{"$f":"IF(F39=\"\",\"\",\"--\")","v":""},{"$f":"IF(F39=\"\",\"\",\"NO\")","v":""},{"$f":"$I$17*IF(OR(O39=\"P\",O39=\"RP\"),0.1,1)*IF(R39=\"SI\",1,0.1)","v":6},{"$f":"IF(O39=\"P\",J39*S39*ROUND(N39/60,2),\"--\")","v":"--"},{"$f":"IF(O39=\"RP\",J39*S39*ROUND(N39/60,2)*Q39/100,\"--\")","v":"--"},{"$f":"IF(AND(O39=\"F\",P39=\"NO\"),J39*S39,\"--\")","v":"--"},{"$f":"IF(O39=\"F\",J39*S39*ROUND(N39/60,2),\"--\")","v":"--"},{"$f":"IF(AND(O39=\"R\",P39=\"NO\"),J39*S39*Q39/100,\"--\")","v":"--"},{"$f":"IF(O39=\"R\",J39*S39*ROUND(N39/60,2)*Q39/100,\"--\")","v":"--"},{"$f":"IF(O39=\"RF\",J39*S39*ROUND(N39/60,2),\"--\")","v":"--"},{"$f":"IF(O39=\"RR\",J39*S39*ROUND(N39/60,2)*Q39/100,\"--\")","v":"--"},{"$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,"",{"$f":"IF(F40=\"\",\"\",\"--\")","v":""},{"$f":"IF(F40=\"\",\"\",\"NO\")","v":""},{"$f":"$I$17*IF(OR(O40=\"P\",O40=\"RP\"),0.1,1)*IF(R40=\"SI\",1,0.1)","v":6},{"$f":"IF(O40=\"P\",J40*S40*ROUND(N40/60,2),\"--\")","v":"--"},{"$f":"IF(O40=\"RP\",J40*S40*ROUND(N40/60,2)*Q40/100,\"--\")","v":"--"},{"$f":"IF(AND(O40=\"F\",P40=\"NO\"),J40*S40,\"--\")","v":"--"},{"$f":"IF(O40=\"F\",J40*S40*ROUND(N40/60,2),\"--\")","v":"--"},{"$f":"IF(AND(O40=\"R\",P40=\"NO\"),J40*S40*Q40/100,\"--\")","v":"--"},{"$f":"IF(O40=\"R\",J40*S40*ROUND(N40/60,2)*Q40/100,\"--\")","v":"--"},{"$f":"IF(O40=\"RF\",J40*S40*ROUND(N40/60,2),\"--\")","v":"--"},{"$f":"IF(O40=\"RR\",J40*S40*ROUND(N40/60,2)*Q40/100,\"--\")","v":"--"},{"$f":"IF(F40=\"\",\"\",\"SI\")","v":""},""]
[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,"",{"$f":"IF(F41=\"\",\"\",\"--\")","v":""},{"$f":"IF(F41=\"\",\"\",\"NO\")","v":""},{"$f":"$I$17*IF(OR(O41=\"P\",O41=\"RP\"),0.1,1)*IF(R41=\"SI\",1,0.1)","v":6},{"$f":"IF(O41=\"P\",J41*S41*ROUND(N41/60,2),\"--\")","v":"--"},{"$f":"IF(O41=\"RP\",J41*S41*ROUND(N41/60,2)*Q41/100,\"--\")","v":"--"},{"$f":"IF(AND(O41=\"F\",P41=\"NO\"),J41*S41,\"--\")","v":"--"},{"$f":"IF(O41=\"F\",J41*S41*ROUND(N41/60,2),\"--\")","v":"--"},{"$f":"IF(AND(O41=\"R\",P41=\"NO\"),J41*S41*Q41/100,\"--\")","v":"--"},{"$f":"IF(O41=\"R\",J41*S41*ROUND(N41/60,2)*Q41/100,\"--\")","v":"--"},{"$f":"IF(O41=\"RF\",J41*S41*ROUND(N41/60,2),\"--\")","v":"--"},{"$f":"IF(O41=\"RR\",J41*S41*ROUND(N41/60,2)*Q41/100,\"--\")","v":"--"},{"$f":"IF(F41=\"\",\"\",\"SI\")","v":""},""]
[]
[null,null,"(²)","P - PROGRAMADA  ; F - FORZADA  ; R - REDUCCIÓN FORZADA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T20:T42)","v":12.448800000000006},{"$f":"SUM(U20:U42)","v":0},13708.500000000002,27468.870000000006,666.90000000000009,366.79500000000007,0,0,null,{"$f":"ROUND(SUM(AC20:AC42),2)","v":110761.19}]

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