{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["TOT-0216","LI-02 (1)","LI-02 (2)","T-02 (1)","T-02 (2)","SA-02 (1)","SA-02 (2)","RE-02 (1)","DATO"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"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-0216","index":0,"n_rows":31,"n_cols":9,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[]
[null,"ANEXO III al Memorándum D.T.E.E. N°   243 / 2017"]
[]
["ENTE NACIONAL REGULADOR "]
["DE LA ELECTRICIDAD"]
[]
[null,"PRESTADOR DE LA FUNCIÓN TÉCNICA DE TRANSPORTE DE ENERGÍA ELÉCTRICA"]
[]
[null,"TRANSBA S.A."]
[]
[null,"TOTAL DE PENALIZACIONES A APLICAR"]
[]
[null,1,false]
[null,"Desde el 01 al 29 de Febrero de 2016"]
[]
[null,"Sanciones duplicadas por tasa de falla > 4 Sal. x año/100km."]
[]
[null,null,"1.-","LÍNEAS",null,null,null,null,{"$f":"'LI-02 (2)'!AC42","v":154108.6}]
[]
[null,null,"2.-","CONEXIÓN"]
[]
[null,null,null,"2.1.-","Transformación",null,null,null,{"$f":"'T-02 (2)'!AC44","v":45584}]
[]
[null,null,null,"2.2.-","Salidas",null,null,null,{"$f":"'SA-02 (2)'!V43","v":8448.35}]
[]
[null,null,"3.-","Equipamiento propio Res. 01_03",null,null,null,null,{"$f":"'RE-02 (1)'!AD44","v":3470.75}]
[]
[]
[null,null,null,null,null,"TOTAL ",{"$f":"ROUND(SUM(I18:I27),2)","v":211611.7}]
[]
[null,null,"Valores remuneratorios según Acuerdo SEE-ENRE-TRANSBA - 2016-2017"]

{"sheet":"LI-02 (1)","index":1,"n_rows":42,"n_cols":29,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'TOT-0216'!B2","v":"ANEXO III al Memorándum D.T.E.E. N°   243 / 2017"}]
[]
["ENTE NACIONAL REGULADOR "]
["DE LA ELECTRICIDAD"]
[]
[]
[null,null,null,null,null,"SISTEMA DE TRANSPORTE DE ENERGÍA ELÉCTRICA POR DISTRIBUCIÓN TRONCAL - TRANSBA S.A."]
[]
[null,null,null,null,null,"1.- LÍNEAS"]
[]
[null,{"$f":"+'TOT-0216'!B14","v":"Desde el 01 al 29 de Febrero de 2016"}]
[]
[null,null,null,null,null,"$/100 km-h : LÍNEAS 220 kV ",392.94,null,null,null,null,"FACTOR DE PENALIZACIÓN (CLASE A)  K=",{"$f":"150*'TOT-0216'!B13","v":150},{"$f":"IF(M14=150,\" \",IF(M14=300,\"Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"REVISAR COEFICIENTE\"))","v":" "}]
[null,null,null,null,null,"$/100 km-h : LÍNEAS 132 kV ",375.48,null,null,null,null,"FACTOR DE PENALIZACIÓN (CLASE B)  K=",{"$f":"50*'TOT-0216'!B13","v":50},{"$f":"IF(M15=50,\" \",IF(M15=100,\"Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"REVISAR COEFICIENTE\"))","v":" "}]
[null,null,null,null,null,"$/100 km-h : LÍNEAS 66 kV ",375.48,null,null,null,null,"FACTOR DE PENALIZACIÓN (CLASE C)  K=",{"$f":"10*'TOT-0216'!B13","v":10},{"$f":"IF(M16=10,\" \",IF(M16=20,\"Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"REVISAR COEFICIENTE\"))","v":" "}]
[null,null,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
[null,null,"N°","INDISP","ID EQUIPO","LÍNEAS","U\n[kV]","Long.\n[km]","CLASE","$/h","Salida","Entrada","Hs. \nIndisp","Minutos\nIndisp.","Tipo \nSal.(²)","C.R.\n%","K\n(CLASE)","PENALIZ.\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ó\nen Térm.","TOTAL\nPENALIZAC."]
[]
[]
[null,null,1,298618,1524,"TORNQUIST - BAHIA BLANCA",132,77.3,"C",{"$f":"IF(G21=220,$G$14,IF(G21=132,$G$15,$G$16))*IF(H21>25,H21,25)/100","v":290.24603999999999},"2016-02-01T10:21:00","2016-02-03T16:53:00",{"$f":"IF(F21=\"\",\"\",(L21-K21)*24)","v":54.533333333325572},{"$f":"IF(F21=\"\",\"\",ROUND((L21-K21)*24*60,0))","v":3272},"P","0,000",{"$f":"IF(I21=\"A\",$M$14,IF(I21=\"B\",$M$15,$M$16))","v":10},{"$f":"IF(O21=\"P\",ROUND(N21/60,2)*J21*Q21*0.01,\"--\")","v":1582.71165612},{"$f":"IF(O21=\"RP\",ROUND(N21/60,2)*J21*Q21*0.01*P21/100,\"--\")","v":"--"},{"$f":"IF(O21=\"F\",J21*Q21,\"--\")","v":"--"},{"$f":"IF(AND(N21>10,O21=\"F\"),J21*Q21*IF(N21>180,3,ROUND((N21)/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(O21=\"F\",N21>180),(ROUND(N21/60,2)-3)*J21*Q21*0.1,\"--\")","v":"--"},{"$f":"IF(O21=\"R\",J21*Q21*P21/100,\"--\")","v":"--"},{"$f":"IF(AND(N21>10,O21=\"R\"),Q21*J21*P21/100*IF(N21>180,3,ROUND((N21)/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(O21=\"R\",N21>180),(ROUND(N21/60,2)-3)*J21*Q21*0.1*P21/100,\"--\")","v":"--"},{"$f":"IF(O21=\"RF\",ROUND(N21/60,2)*J21*Q21*0.1,\"--\")","v":"--"},{"$f":"IF(O21=\"RR\",ROUND(N21/60,2)*J21*Q21*0.1*P21/100,\"--\")","v":"--"},"SI",{"$f":"IF(F21=\"\",\"\",SUM(R21:AA21)*IF(AB21=\"SI\",1,2))","v":1582.71165612}]
[null,null,2,298624,1440,"PIGUE - TORNQUIST",132,55,"C",206.51400000000001,"2016-02-03T08:38:00","2016-02-05T17:14:00",56.599999999918509,3396,"P","0,000",10,1168.8692400000002,"--","--","--","--","--","--","--","--","--","SI",1168.8692400000002]
[null,null,3,298634,3797,"S. A. ARECO - LUJAN",66,49.799999237060547,"C",186.98903713531493,"2016-02-05T08:08:00","2016-02-05T14:08:00",6,360,"P","0,000",10,112.19342228118896,"--","--","--","--","--","--","--","--","--","SI",112.19342228118896]
[null,null,4,298635,1525,"MAR DEL PLATA - MIRAMAR",132,39.290000915527344,"C",147.52609543762208,"2016-02-05T20:38:00","2016-02-06T00:56:00",4.3000000000465661,258,"F","0,000",10,"--","--",1475.2609543762208,4425.782863128662,191.78392406890868,"--","--","--","--","--","SI",6092.8277415737921]
[null,null,5,298636,1410,"MERCEDES B.A. - LUJAN",132,41.299999237060547,"B",155.07323713531497,"2016-02-06T06:32:00","2016-02-06T08:50:00",2.2999999999883585,138,"P","0,000",50,178.33422270561221,"--","--","--","--","--","--","--","--","--","SI",178.33422270561221]
[null,null,6,298645,1515,"GONZALEZ CHAVEZ - TRES ARROYOS",132,40.220001220703125,"C",151.01806058349609,"2016-02-07T03:05:00","2016-02-07T04:15:00",1.1666666668024845,70,"F","0,000",10,"--","--",1510.1806058349609,1766.9113088269041,"--","--","--","--","--","--","SI",3277.0919146618653]
[null,null,7,298648,1434,"9 DE JULIO - BRAGADO",66,60.939998626708984,"C",228.81750684356692,"2016-02-07T14:05:00","2016-02-07T19:02:00",4.9500000000698492,297,"F","0,000",10,"--","--",2288.1750684356693,6864.525205307008,446.19413834495555,"--","--","--","--","--","SI",9598.8944120876331]
[null,null,8,298835,1401,"HENDERSON - CNEL. SUAREZ",132,126.90000152587891,"C",476.48412572937013,"2016-02-10T09:06:00","2016-02-10T14:12:00",5.1000000000349246,306,"P","0,000",10,243.00690412197875,"--","--","--","--","--","--","--","--","--","SI",243.00690412197875]
[null,null,9,298836,1532,"BAHIA BLANCA - P. LURO",132,141,"B",529.42679999999996,"2016-02-10T10:00:00","2016-02-10T12:53:00",2.8833333334769122,173,"P","0,000",50,762.37459199999989,"--","--","--","--","--","--","--","--","--","SI",762.37459199999989]
[]
[]
[null,null,12,298855,2621,"LUJAN - MORÓN 2",132,38.29,"A",143.77129200000002,"2016-02-12T12:00:00","2016-02-12T16:40:00",4.6666666666860692,280,"F","0,000",150,"--","--",21565.693800000001,64697.081400000003,3601.4708645999999,"--","--","--","--","--","SI",89864.246064600011]
[null,null,13,299397,1446,"OLAVARRIA - HENDERSON",132,139.89999389648437,"C",525.29649708251952,"2016-02-15T09:24:00","2016-02-15T13:55:00",4.5166666665463708,271,"P","0,000",10,237.43401668129883,"--","--","--","--","--","--","--","--","--","SI",237.43401668129883]
[null,null,14,299398,1547,"URBANA BB - C. PIEDRABUENA",132,1.8999999761581421,"C",93.87,"2016-02-16T07:52:00","2016-02-16T14:33:00",6.6833333332906477,401,"P","0,000",10,62.705159999999999,"--","--","--","--","--","--","--","--","--","SI",62.705159999999999]
[null,null,15,299402,1450,"OLAVARRIA - AZUL",132,51.400001525878906,"C",192.99672572937013,"2016-02-16T21:58:00","2016-02-17T00:58:00",3,180,"F","0,000",10,"--","--",1929.9672572937013,5789.9017718811037,"--","--","--","--","--","--","SI",7719.8690291748053]
[null,null,16,299403,1515,"GONZALEZ CHAVEZ - TRES ARROYOS",132,40.220001220703125,"C",151.01806058349609,"2016-02-17T06:08:00","2016-02-17T11:16:00",5.1333333333022892,308,"P","0,000",10,77.472265079333496,"--","--","--","--","--","--","--","--","--","SI",77.472265079333496]
[null,null,17,299404,1547,"URBANA BB - C. PIEDRABUENA",132,1.8999999761581421,"C",93.87,"2016-02-17T07:58:00","2016-02-17T14:14:00",6.2666666666627862,376,"P","0,000",10,58.856489999999994,"--","--","--","--","--","--","--","--","--","SI",58.856489999999994]
[null,null,18,299405,4888,"ZARATE - CAMPANA III",132,16.8,"C",93.87,"2016-02-17T09:52:00","2016-02-17T10:24:00",0.53333333332557231,32,"P","0,000",10,4.9751100000000008,"--","--","--","--","--","--","--","--","--","SI",4.9751100000000008]
[null,null,19,299411,1546,"PETROQ. BAHIA BLANCA - URBANA BB",132,3.2000000476837158,"C",93.87,"2016-02-18T08:18:00","2016-02-18T13:41:00",5.3833333334187046,323,"P","0,000",10,50.50206,"--","--","--","--","--","--","--","--","--","SI",50.50206]
[]
[]
[null,null,"(²)","P - PROGRAMADA  ; F - FORZADA",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R19:R41)","v":4539.4351389894127},0,28769.277685940553,83544.20254914368,4239.4489270138638,0,0,0,0,0,null,{"$f":"ROUND(SUM(AC19:AC41),2)","v":121092.36}]

{"sheet":"LI-02 (2)","index":2,"n_rows":42,"n_cols":29,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'TOT-0216'!B2","v":"ANEXO III al Memorándum D.T.E.E. N°   243 / 2017"}]
[]
["ENTE NACIONAL REGULADOR "]
["DE LA ELECTRICIDAD"]
[]
[]
[null,null,null,null,null,"SISTEMA DE TRANSPORTE DE ENERGÍA ELÉCTRICA POR DISTRIBUCIÓN TRONCAL - TRANSBA S.A."]
[]
[null,null,null,null,null,"1.- LÍNEAS"]
[]
[null,{"$f":"+'TOT-0216'!B14","v":"Desde el 01 al 29 de Febrero de 2016"}]
[]
[null,null,null,null,null,"$/100 km-h : LÍNEAS 220 kV ",392.94,null,null,null,null,"FACTOR DE PENALIZACIÓN (CLASE A)  K=",{"$f":"150*'TOT-0216'!B13","v":150},{"$f":"IF(M14=150,\" \",IF(M14=300,\"Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"REVISAR COEFICIENTE\"))","v":" "}]
[null,null,null,null,null,"$/100 km-h : LÍNEAS 132 kV ",375.48,null,null,null,null,"FACTOR DE PENALIZACIÓN (CLASE B)  K=",{"$f":"50*'TOT-0216'!B13","v":50},{"$f":"IF(M15=50,\" \",IF(M15=100,\"Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"REVISAR COEFICIENTE\"))","v":" "}]
[null,null,null,null,null,"$/100 km-h : LÍNEAS 66 kV ",375.48,null,null,null,null,"FACTOR DE PENALIZACIÓN (CLASE C)  K=",{"$f":"10*'TOT-0216'!B13","v":10},{"$f":"IF(M16=10,\" \",IF(M16=20,\"Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"REVISAR COEFICIENTE\"))","v":" "}]
[null,null,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
[null,null,"N°","INDISP","ID EQUIPO","LÍNEAS","U\n[kV]","Long.\n[km]","CLASE","$/h","Salida","Entrada","Hs. \nIndisp","Minutos\nIndisp.","Tipo \nSal.(²)","C.R.\n%","K\n(CLASE)","PENALIZ.\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ó\nen Té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":"'LI-02 (1)'!AC42","v":121092.36}]
[]
[null,null,20,299414,1401,"HENDERSON - CNEL. SUAREZ",132,126.90000152587891,"C",{"$f":"IF(G21=220,$G$14,IF(G21=132,$G$15,$G$16))*IF(H21>25,H21,25)/100","v":476.48412572937013},"2016-02-18T09:12:00","2016-02-18T12:05:00",{"$f":"IF(F21=\"\",\"\",(L21-K21)*24)","v":2.8833333333022892},{"$f":"IF(F21=\"\",\"\",ROUND((L21-K21)*24*60,0))","v":173},"P","0,000",{"$f":"IF(I21=\"A\",$M$14,IF(I21=\"B\",$M$15,$M$16))","v":10},{"$f":"IF(O21=\"P\",ROUND(N21/60,2)*J21*Q21*0.01,\"--\")","v":137.2274282100586},{"$f":"IF(O21=\"RP\",ROUND(N21/60,2)*J21*Q21*0.01*P21/100,\"--\")","v":"--"},{"$f":"IF(O21=\"F\",J21*Q21,\"--\")","v":"--"},{"$f":"IF(AND(N21>10,O21=\"F\"),J21*Q21*IF(N21>180,3,ROUND((N21)/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(O21=\"F\",N21>180),(ROUND(N21/60,2)-3)*J21*Q21*0.1,\"--\")","v":"--"},{"$f":"IF(O21=\"R\",J21*Q21*P21/100,\"--\")","v":"--"},{"$f":"IF(AND(N21>10,O21=\"R\"),Q21*J21*P21/100*IF(N21>180,3,ROUND((N21)/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(O21=\"R\",N21>180),(ROUND(N21/60,2)-3)*J21*Q21*0.1*P21/100,\"--\")","v":"--"},{"$f":"IF(O21=\"RF\",ROUND(N21/60,2)*J21*Q21*0.1,\"--\")","v":"--"},{"$f":"IF(O21=\"RR\",ROUND(N21/60,2)*J21*Q21*0.1*P21/100,\"--\")","v":"--"},"SI",{"$f":"IF(F21=\"\",\"\",SUM(R21:AA21)*IF(AB21=\"SI\",1,2))","v":137.2274282100586}]
[null,null,21,299416,1434,"9 DE JULIO - BRAGADO",66,60.939998626708984,"C",228.81750684356692,"2016-02-18T15:13:00","2016-02-18T19:21:00",4.1333333333604969,248,"F","0,000",10,"--","--",2288.1750684356693,6864.525205307008,258.56378273323065,"--","--","--","--","--","SI",9411.2640564759076]
[null,null,22,299417,1537,"CNEL. SUAREZ - PIGUE",132,47.599998474121094,"C",178.72847427062987,"2016-02-18T17:58:00","2016-02-19T03:05:00",9.1166666665230878,547,"F","0,000",10,"--","--",1787.2847427062989,5361.8542281188966,1093.8182625362549,"--","--","--","--","--","SI",8242.9572333614506]
[null,null,23,299419,3797,"S. A. ARECO - LUJAN",66,49.799999237060547,"C",186.98903713531493,"2016-02-19T02:56:00","2016-02-19T17:13:00",14.283333333441988,857,"F","0,000",10,"--","--",1869.8903713531492,5609.671114059448,2109.2363388863523,"--","--","--","--","--","SI",9588.7978242989484]
[null,null,24,299420,1546,"PETROQ. BAHIA BLANCA - URBANA BB",132,3.2000000476837158,"C",93.87,"2016-02-19T08:22:00","2016-02-19T16:03:00",7.6833333332324401,461,"P","0,000",10,72.092160000000007,"--","--","--","--","--","--","--","--","--","SI",72.092160000000007]
[null,null,25,299427,1442,"MAR DE AJO - PINAMAR",132,46.400001525878906,"C",174.22272572937015,"2016-02-20T07:50:00","2016-02-20T09:35:00",1.7499999999417923,105,"P","0,000",10,30.488977002639778,"--","--","--","--","--","--","--","--","--","SI",30.488977002639778]
[null,null,26,299429,3556,"N. CAMPANA - CORCEMAR   1",132,5,"C",93.87,"2016-02-21T08:07:00","2016-02-21T17:18:00",9.183333333407063,551,"P","0,000",10,86.172659999999993,"--","--","--","--","--","--","--","--","--","SI",86.172659999999993]
[null,null,27,299706,1456,"LAPRIDA - PRINGLES",132,71.5,"C",268.46820000000002,"2016-02-23T07:54:00","2016-02-23T16:09:00",8.25,495,"P","0,000",10,221.486265,"--","--","--","--","--","--","--","--","--","SI",221.486265]
[null,null,28,299707,4889,"CAMPANA III - MATHEU",132,21,"C",93.87,"2016-02-23T08:28:00","2016-02-23T12:01:00",3.5500000000465661,213,"P","0,000",10,33.32385,"--","--","--","--","--","--","--","--","--","SI",33.32385]
[null,null,29,299712,1456,"LAPRIDA - PRINGLES",132,71.5,"C",268.46820000000002,"2016-02-24T07:41:00","2016-02-24T16:29:00",8.7999999998719431,528,"P","0,000",10,236.25201600000005,"--","--","--","--","--","--","--","--","--","SI",236.25201600000005]
[null,null,30,299719,1456,"LAPRIDA - PRINGLES",132,71.5,"C",268.46820000000002,"2016-02-25T07:55:00","2016-02-25T16:24:00",8.4833333333954215,509,"P","0,000",10,227.66103360000002,"--","--","--","--","--","--","--","--","--","SI",227.66103360000002]
[null,null,31,299721,1444,"GRAL. MADARIAGA - LAS ARMAS",132,64.400001525878906,"C",241.80912572937012,"2016-02-26T07:34:00","2016-02-26T08:48:00",1.2333333333372138,74,"P","0,000",10,29.742522464712522,"--","--","--","--","--","--","--","--","--","SI",29.742522464712522]
[null,null,32,299722,1456,"LAPRIDA - PRINGLES",132,71.5,"C",268.46820000000002,"2016-02-26T07:51:00","2016-02-26T16:29:00",8.6333333333604969,518,"P","0,000",10,231.68805660000001,"--","--","--","--","--","--","--","--","--","SI",231.68805660000001]
[null,null,33,299726,5684,"CORCEMAR - TOYOTA   1",132,2.9,"C",93.87,"2016-02-28T07:50:00","2016-02-28T15:43:00",7.8833333333604969,473,"P","0,000",10,73.969560000000001,"--","--","--","--","--","--","--","--","--","SI",73.969560000000001]
[null,null,34,299728,1999,"SAN NICOLÁS - VILLA CONSTITUCIÓN IND.",132,14.699999809265137,"C",93.87,"2016-02-29T07:20:00","2016-02-29T17:08:00",9.7999999999883585,588,"F","0,000",10,"--","--",938.7,2816.1000000000004,638.31600000000026,"--","--","--","--","--","SI",4393.116]
[null,null,null,null,null,null,null,null,null,93.87,null,null,"","",null,{"$f":"IF(F36=\"\",\"\",\"--\")","v":""},{"$f":"IF(I36=\"A\",$M$14,IF(I36=\"B\",$M$15,$M$16))","v":10},{"$f":"IF(O36=\"P\",ROUND(N36/60,2)*J36*Q36*0.01,\"--\")","v":"--"},{"$f":"IF(O36=\"RP\",ROUND(N36/60,2)*J36*Q36*0.01*P36/100,\"--\")","v":"--"},{"$f":"IF(O36=\"F\",J36*Q36,\"--\")","v":"--"},{"$f":"IF(AND(N36>10,O36=\"F\"),J36*Q36*IF(N36>180,3,ROUND((N36)/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(O36=\"F\",N36>180),(ROUND(N36/60,2)-3)*J36*Q36*0.1,\"--\")","v":"--"},{"$f":"IF(O36=\"R\",J36*Q36*P36/100,\"--\")","v":"--"},{"$f":"IF(AND(N36>10,O36=\"R\"),Q36*J36*P36/100*IF(N36>180,3,ROUND((N36)/60,2)),\"--\")","v":"--"},{"$f":"IF(AND(O36=\"R\",N36>180),(ROUND(N36/60,2)-3)*J36*Q36*0.1*P36/100,\"--\")","v":"--"},{"$f":"IF(O36=\"RF\",ROUND(N36/60,2)*J36*Q36*0.1,\"--\")","v":"--"},{"$f":"IF(O36=\"RR\",ROUND(N36/60,2)*J36*Q36*0.1*P36/100,\"--\")","v":"--"},{"$f":"IF(F36=\"\",\"\",\"SI\")","v":""},""]
[null,null,null,null,null,null,null,null,null,93.87,null,null,"","",null,"",10,"--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,93.87,null,null,"","",null,"",10,"--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,93.87,null,null,"","",null,"",10,"--","--","--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,93.87,null,null,"","",null,{"$f":"IF(F40=\"\",\"\",\"--\")","v":""},10,"--","--","--","--","--","--","--","--","--","--",{"$f":"IF(F40=\"\",\"\",\"SI\")","v":""},""]
[]
[null,null,"(²)","P - PROGRAMADA  ; F - FORZADA",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R19:R41)","v":1380.104528877411},0,6884.050182495117,20652.150547485355,4099.9343841558384,0,0,0,0,0,null,{"$f":"ROUND(SUM(AC19:AC41),2)","v":154108.6}]

{"sheet":"T-02 (1)","index":3,"n_rows":45,"n_cols":29,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'TOT-0216'!B2","v":"ANEXO III al Memorándum D.T.E.E. N°   243 / 2017"}]
[]
["ENTE NACIONAL REGULADOR "]
["DE LA ELECTRICIDAD"]
[]
[]
[null,null,null,null,null,"SISTEMA DE TRANSPORTE DE ENERGÍA ELÉCTRICA POR DISTRIBUCIÓN TRONCAL - TRANSBA S.A."]
[]
[null,null,null,null,null,"2.- CONEXIÓN"]
[]
[null,null,null,null,null,"2.1.- Transformación"]
[]
[null,{"$f":"'TOT-0216'!B14","v":"Desde el 01 al 29 de Febrero de 2016"}]
[]
[null,null,null,null,null,"Por Transformador por MVA    $ =",null,null,1.31]
[null,null,null,null,null,"Coeficiente de penalización por salida forzada   =",null,null,{"$f":"60*'TOT-0216'!B13","v":60},null,{"$f":"IF(I17=60,\" \",IF(I17=120,\"    Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"    REVISAR COEFICIENTE\"))","v":" "}]
[null,null,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
[null,null,"N°","INDISP","ID EQUIPO","ESTACIÓN \nTRANSFORMADORA","EQUIPO","POT.\n[MVA]","U\n[kV]","$/h","Salida","Entrada","Hs\nIndisp.","Minutos.\nIndisp.","Tipo \nSal.(²)","AUT.","C.R.\n%","E.N.S.","K (P y 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ó \nen Térm.","TOTAL\nPENALIZAC."]
[]
[]
[null,null,35,298617,2297,"OLAVARRIA VIEJA","T2OA",30,"132/33/13,2",{"$f":"H22*$I$16","v":39.300000000000004},"2016-02-01T07:56:00","2016-02-01T14:11:00",{"$f":"IF(F22=\"\",\"\",(L22-K22)*24)","v":6.2499999999417923},{"$f":"IF(F22=\"\",\"\",ROUND((L22-K22)*24*60,0))","v":375},"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":147.37500000000003},{"$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)*IF(AND(Q22<>\"0,000\",O22=\"RF\"),Q22/100,1))","v":147.37500000000003}]
[null,null,36,298619,2296,"OLAVARRIA VIEJA","T1OA",30,"132/33/13,2",39.300000000000004,"2016-02-02T07:59:00","2016-02-02T12:44:00",4.7499999999417923,285,"P","--","0,000",{"$f":"IF(F23=\"\",\"\",\"NO\")","v":"NO"},0.60000000000000009,112.00500000000002,"--","--","--","--","--","--","--","SI",112.00500000000002]
[null,null,37,298622,2649,"TORNQUIST","TRAFO 1",15,"132/33/13,2",19.650000000000002,"2016-02-03T08:03:00","2016-02-03T16:55:00",8.8666666665812954,532,"P","--","0,000","NO",0.60000000000000009,104.57730000000001,"--","--","--","--","--","--","--","SI",104.57730000000001]
[null,null,38,298625,2663,"ARRECIFES","TRAFO 5",5,"66/33",6.5500000000000007,"2016-02-03T09:55:00","2016-02-03T14:51:00",4.9333333333488554,296,"P","--","0,000","NO",0.60000000000000009,19.374900000000004,"--","--","--","--","--","--","--","SI",19.374900000000004]
[null,null,39,298627,2404,"LAS ARMAS","TRAFO 1",10,"132/33/13,2",13.100000000000001,"2016-02-04T04:15:00","2016-02-04T07:31:00",3.2666666666627862,196,"P","--","0,000","NO",0.60000000000000009,25.702200000000008,"--","--","--","--","--","--","--","SI",25.702200000000008]
[null,null,40,298628,2663,"ARRECIFES","TRAFO 5",5,"66/33",6.5500000000000007,"2016-02-04T08:32:00","2016-02-04T12:37:00",4.0833333331975155,245,"P","--","0,000","NO",0.60000000000000009,16.034400000000005,"--","--","--","--","--","--","--","SI",16.034400000000005]
[null,null,41,298629,2468,"PINAMAR","TRAFO 1",15,"132/33/13,2",19.650000000000002,"2016-02-04T15:56:00","2016-02-04T16:48:00",0.86666666652308777,52,"F","NO","0,000","SI",60,"--","--",1179.0000000000002,1025.7300000000002,"--","--","--","--","SI",2204.7300000000005]
[null,null,"41b",298629,2468,"PINAMAR","TRAFO 1",15,"132/33/13,2",{"$f":"H29*$I$16","v":19.650000000000002},"2016-02-04T16:48:00","2016-02-04T18:34:00",{"$f":"IF(F29=\"\",\"\",(L29-K29)*24)","v":1.7666666666627862},{"$f":"IF(F29=\"\",\"\",ROUND((L29-K29)*24*60,0))","v":106},"RF",{"$f":"IF(F29=\"\",\"\",IF(OR(O29=\"P\",O29=\"RP\"),\"--\",\"NO\"))","v":"NO"},"0,000","NO",{"$f":"$I$17*IF(OR(O29=\"P\",O29=\"RP\"),0.1,1)*IF(R29=\"SI\",1,0.1)","v":6},{"$f":"IF(O29=\"P\",J29*S29*ROUND(N29/60,2),\"--\")","v":"--"},{"$f":"IF(O29=\"RP\",J29*S29*ROUND(N29/60,2)*Q29/100,\"--\")","v":"--"},{"$f":"IF(AND(O29=\"F\",P29=\"NO\"),J29*S29,\"--\")","v":"--"},{"$f":"IF(O29=\"F\",J29*S29*ROUND(N29/60,2),\"--\")","v":"--"},{"$f":"IF(AND(O29=\"R\",P29=\"NO\"),J29*S29*Q29/100,\"--\")","v":"--"},{"$f":"IF(O29=\"R\",J29*S29*ROUND(N29/60,2)*Q29/100,\"--\")","v":"--"},{"$f":"IF(O29=\"RF\",J29*S29*ROUND(N29/60,2),\"--\")","v":208.68300000000002},{"$f":"IF(O29=\"RR\",J29*S29*ROUND(N29/60,2)*Q29/100,\"--\")","v":"--"},{"$f":"IF(F29=\"\",\"\",\"SI\")","v":"SI"},{"$f":"IF(F29=\"\",\"\",SUM(T29:AA29)*IF(AB29=\"SI\",1,2)*IF(AND(Q29<>\"0,000\",O29=\"RF\"),Q29/100,1))","v":208.68300000000002}]
[null,null,42,298850,3727,"TRENQUE LAUQUEN","TRAFO 3",30,"132/33/13,2",39.300000000000004,"2016-02-11T07:20:00","2016-02-11T08:34:00",1.2333333333372138,74,"R","NO",60,"SI",60,"--","--","--","--",1414.8000000000002,1740.2040000000002,"--","--","SI",3155.0040000000004]
[null,null,"42b",298850,3727,"TRENQUE LAUQUEN","TRAFO 3",30,"132/33/13,2",{"$f":"H31*$I$16","v":39.300000000000004},"2016-02-11T08:34:00","2016-02-11T15:01:00",{"$f":"IF(F31=\"\",\"\",(L31-K31)*24)","v":6.4500000000698492},{"$f":"IF(F31=\"\",\"\",ROUND((L31-K31)*24*60,0))","v":387},"RR",{"$f":"IF(F31=\"\",\"\",IF(OR(O31=\"P\",O31=\"RP\"),\"--\",\"NO\"))","v":"NO"},60,"NO",{"$f":"$I$17*IF(OR(O31=\"P\",O31=\"RP\"),0.1,1)*IF(R31=\"SI\",1,0.1)","v":6},{"$f":"IF(O31=\"P\",J31*S31*ROUND(N31/60,2),\"--\")","v":"--"},{"$f":"IF(O31=\"RP\",J31*S31*ROUND(N31/60,2)*Q31/100,\"--\")","v":"--"},{"$f":"IF(AND(O31=\"F\",P31=\"NO\"),J31*S31,\"--\")","v":"--"},{"$f":"IF(O31=\"F\",J31*S31*ROUND(N31/60,2),\"--\")","v":"--"},{"$f":"IF(AND(O31=\"R\",P31=\"NO\"),J31*S31*Q31/100,\"--\")","v":"--"},{"$f":"IF(O31=\"R\",J31*S31*ROUND(N31/60,2)*Q31/100,\"--\")","v":"--"},{"$f":"IF(O31=\"RF\",J31*S31*ROUND(N31/60,2),\"--\")","v":"--"},{"$f":"IF(O31=\"RR\",J31*S31*ROUND(N31/60,2)*Q31/100,\"--\")","v":912.54600000000005},{"$f":"IF(F31=\"\",\"\",\"SI\")","v":"SI"},{"$f":"IF(F31=\"\",\"\",SUM(T31:AA31)*IF(AB31=\"SI\",1,2)*IF(AND(Q31<>\"0,000\",O31=\"RF\"),Q31/100,1))","v":912.54600000000005}]
[]
[null,null,44,298923,4676,"COLON","TRAFO 1",30,"132/22/13,2",39.300000000000004,"2016-02-13T06:15:00","2016-02-13T16:50:00",10.583333333430346,635,"RP","--",40,"NO",0.60000000000000009,"--",99.790560000000028,"--","--","--","--","--","--","SI",99.790560000000028]
[null,null,45,298925,4280,"TANDIL","TRAFO 3",30,"132/33/13,2",39.300000000000004,"2016-02-13T07:50:00","2016-02-13T11:00:00",3.1666666666860692,190,"P","--","0,000","NO",0.60000000000000009,74.74860000000001,"--","--","--","--","--","--","--","SI",74.74860000000001]
[null,null,46,298926,5553,"CHACABUCO","TRAFO1",30,"132/33/13,2",39.300000000000004,"2016-02-14T07:36:00","2016-02-14T18:06:00",10.5,630,"P","--","0,000","NO",0.60000000000000009,247.59000000000006,"--","--","--","--","--","--","--","SI",247.59000000000006]
[null,null,47,299399,5553,"CHACABUCO","TRAFO1",30,"132/33/13,2",39.300000000000004,"2016-02-16T08:06:00","2016-02-21T07:27:00",119.34999999997672,7161,"RP","--",40,"NO",0.60000000000000009,"--",1125.7092000000002,"--","--","--","--","--","--","SI",1125.7092000000002]
[null,null,48,299400,2166,"IMPSA","TRAFO 1",15,"132/33/13,2",19.650000000000002,"2016-02-16T08:11:00","2016-02-16T09:08:00",0.95000000012805685,57,"P","--","0,000","NO",0.60000000000000009,11.200500000000002,"--","--","--","--","--","--","--","SI",11.200500000000002]
[null,null,49,299410,2387,"AZUL","TRAFO 3",15,"132/33/132,2",19.650000000000002,"2016-02-18T08:07:00","2016-02-18T13:47:00",5.6666666668024845,340,"P","--","0,000","NO",0.60000000000000009,66.849300000000014,"--","--","--","--","--","--","--","SI",66.849300000000014]
[null,null,50,299422,2387,"AZUL","TRAFO 3",15,"132/33/132,2",19.650000000000002,"2016-02-19T08:45:00","2016-02-19T14:02:00",5.2833333332673647,317,"P","--","0,000","NO",0.60000000000000009,62.251200000000019,"--","--","--","--","--","--","--","SI",62.251200000000019]
[null,null,51,299423,2056,"SAN PEDRO ","TRAFO 2",15,"132/33",19.650000000000002,"2016-02-19T09:13:00","2016-02-19T10:00:00",0.78333333326736465,47,"F","NO","0,000","SI",60,"--","--",1179.0000000000002,919.62000000000023,"--","--","--","--","SI",2098.6200000000003]
[null,null,"51b",299423,2056,"SAN PEDRO ","TRAFO 2",15,"132/33",{"$f":"H41*$I$16","v":19.650000000000002},"2016-02-19T10:00:00","2016-02-26T22:06:00",{"$f":"IF(F41=\"\",\"\",(L41-K41)*24)","v":180.09999999997672},{"$f":"IF(F41=\"\",\"\",ROUND((L41-K41)*24*60,0))","v":10806},"RF",{"$f":"IF(F41=\"\",\"\",IF(OR(O41=\"P\",O41=\"RP\"),\"--\",\"NO\"))","v":"NO"},"0,000","NO",{"$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":21233.79},{"$f":"IF(O41=\"RR\",J41*S41*ROUND(N41/60,2)*Q41/100,\"--\")","v":"--"},{"$f":"IF(F41=\"\",\"\",\"SI\")","v":"SI"},{"$f":"IF(F41=\"\",\"\",SUM(T41:AA41)*IF(AB41=\"SI\",1,2)*IF(AND(Q41<>\"0,000\",O41=\"RF\"),Q41/100,1))","v":21233.79}]
[null,null,52,299428,5553,"CHACABUCO","TRAFO 1",30,"132/33/13,2",39.300000000000004,"2016-02-21T07:28:00","2016-02-21T19:14:00",11.766666666604578,706,"P","--","0,000","NO",0.60000000000000009,277.53660000000008,"--","--","--","--","--","--","--","SI",277.53660000000008]
[null,null,53,299430,2287,"CHACABUCO","TRAFO 2",15,"132/33/13,2",19.650000000000002,"2016-02-21T19:14:00","2016-02-21T19:38:00",0.40000000008149073,24,"F","NO","0,000","SI",60,"--","--",1179.0000000000002,471.60000000000014,"--","--","--","--","SI",1650.6000000000004]
[]
[null,null,"(²)"," P - PROGRAMADA  ; F - FORZADA  ; R - REDUCCIÓN FORZADA  ; RP - REDUCCIÓN PROGRAMADA  ; RF - RESTANTE FORZADA  ; RR - REDUCCIÓN RESTANTE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(T20:T44)","v":1165.2450000000003},{"$f":"SUM(U20:U44)","v":1225.4997600000002},{"$f":"SUM(V20:V44)","v":3537.0000000000009},{"$f":"SUM(W22:W44)","v":2416.9500000000007},{"$f":"SUM(X20:X44)","v":1414.8000000000002},{"$f":"SUM(Y22:Y44)","v":1740.2040000000002},{"$f":"SUM(Z20:Z44)","v":21442.473000000002},{"$f":"SUM(AA22:AA44)","v":912.54600000000005},null,{"$f":"ROUND(SUM(AC20:AC44),2)","v":33854.720000000001}]

{"sheet":"T-02 (2)","index":4,"n_rows":44,"n_cols":29,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'TOT-0216'!B2","v":"ANEXO III al Memorándum D.T.E.E. N°   243 / 2017"}]
[]
["ENTE NACIONAL REGULADOR "]
["DE LA ELECTRICIDAD"]
[]
[]
[null,null,null,null,null,"SISTEMA DE TRANSPORTE DE ENERGÍA ELÉCTRICA POR DISTRIBUCIÓN TRONCAL - TRANSBA S.A."]
[]
[null,null,null,null,null,"2.- CONEXIÓN"]
[]
[null,null,null,null,null,"2.1.- Transformación"]
[]
[null,{"$f":"'TOT-0216'!B14","v":"Desde el 01 al 29 de Febrero de 2016"}]
[]
[null,null,null,null,null,"Por Transformador por MVA    $ =",null,null,1.31]
[null,null,null,null,null,"Coeficiente de penalización por salida forzada   =",null,null,{"$f":"60*'TOT-0216'!B13","v":60},null,{"$f":"IF(I17=60,\" \",IF(I17=120,\"    Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"    REVISAR COEFICIENTE\"))","v":" "}]
[null,null,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29]
[null,null,"N°","INDISP","ID EQUIPO","ESTACIÓN \nTRANSFORMADORA","EQUIPO","POT.\n[MVA]","U\n[kV]","$/h","Salida","Entrada","Hs\nIndisp.","Minutos.\nIndisp.","Tipo \nSal.(²)","AUT.","C.R.\n%","E.N.S.","K (P y 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ó \nen Té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-02 (1)'!AC45","v":33854.720000000001}]
[]
[null,null,54,299443,5553,"CHACABUCO","TRAFO1",30,"132/33/13,2",{"$f":"H22*$I$16","v":39.300000000000004},"2016-02-21T19:15:00","2016-02-22T13:48:00",{"$f":"IF(F22=\"\",\"\",(L22-K22)*24)","v":18.549999999871943},{"$f":"IF(F22=\"\",\"\",ROUND((L22-K22)*24*60,0))","v":1113},"R",{"$f":"IF(F22=\"\",\"\",IF(OR(O22=\"P\",O22=\"RP\"),\"--\",\"NO\"))","v":"NO"},40,"NO",{"$f":"$I$17*IF(OR(O22=\"P\",O22=\"RP\"),0.1,1)*IF(R22=\"SI\",1,0.1)","v":6},{"$f":"IF(O22=\"P\",J22*S22*ROUND(N22/60,2),\"--\")","v":"--"},{"$f":"IF(O22=\"RP\",J22*S22*ROUND(N22/60,2)*Q22/100,\"--\")","v":"--"},{"$f":"IF(AND(O22=\"F\",P22=\"NO\"),J22*S22,\"--\")","v":"--"},{"$f":"IF(O22=\"F\",J22*S22*ROUND(N22/60,2),\"--\")","v":"--"},{"$f":"IF(AND(O22=\"R\",P22=\"NO\"),J22*S22*Q22/100,\"--\")","v":94.32},{"$f":"IF(O22=\"R\",J22*S22*ROUND(N22/60,2)*Q22/100,\"--\")","v":1749.636},{"$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)*IF(AND(Q22<>\"0,000\",O22=\"RF\"),Q22/100,1))","v":1843.9559999999999}]
[null,null,55,299703,2478,"LAS FLORES","TRAFO 2",15,"132/33/13,2",19.650000000000002,"2016-02-22T19:33:00","2016-02-22T20:45:00",1.2000000000698492,72,"F","NO","0,000","SI",60,"--","--",1179.0000000000002,1414.8000000000002,"--","--","--","--","SI",{"$f":"IF(F23=\"\",\"\",SUM(T23:AA23)*IF(AB23=\"SI\",1,2)*IF(AND(Q23<>\"0,000\",O23=\"RF\"),Q23/100,1))","v":2593.8000000000002}]
[null,null,"55b",299703,2478,"LAS FLORES","TRAFO 2",15,"132/33/13,2",{"$f":"H24*$I$16","v":19.650000000000002},"2016-02-22T20:45:00","2016-02-24T10:50:00",{"$f":"IF(F24=\"\",\"\",(L24-K24)*24)","v":38.083333333313931},{"$f":"IF(F24=\"\",\"\",ROUND((L24-K24)*24*60,0))","v":2285},"RF",{"$f":"IF(F24=\"\",\"\",IF(OR(O24=\"P\",O24=\"RP\"),\"--\",\"NO\"))","v":"NO"},"0,000","NO",{"$f":"$I$17*IF(OR(O24=\"P\",O24=\"RP\"),0.1,1)*IF(R24=\"SI\",1,0.1)","v":6},{"$f":"IF(O24=\"P\",J24*S24*ROUND(N24/60,2),\"--\")","v":"--"},{"$f":"IF(O24=\"RP\",J24*S24*ROUND(N24/60,2)*Q24/100,\"--\")","v":"--"},{"$f":"IF(AND(O24=\"F\",P24=\"NO\"),J24*S24,\"--\")","v":"--"},{"$f":"IF(O24=\"F\",J24*S24*ROUND(N24/60,2),\"--\")","v":"--"},{"$f":"IF(AND(O24=\"R\",P24=\"NO\"),J24*S24*Q24/100,\"--\")","v":"--"},{"$f":"IF(O24=\"R\",J24*S24*ROUND(N24/60,2)*Q24/100,\"--\")","v":"--"},{"$f":"IF(O24=\"RF\",J24*S24*ROUND(N24/60,2),\"--\")","v":4489.6319999999996},{"$f":"IF(O24=\"RR\",J24*S24*ROUND(N24/60,2)*Q24/100,\"--\")","v":"--"},{"$f":"IF(F24=\"\",\"\",\"SI\")","v":"SI"},{"$f":"IF(F24=\"\",\"\",SUM(T24:AA24)*IF(AB24=\"SI\",1,2)*IF(AND(Q24<>\"0,000\",O24=\"RF\"),Q24/100,1))","v":4489.6319999999996}]
[null,null,56,299708,4832,"CHAÑARES","TRAFO 1",30,"132/33/13,2",39.300000000000004,"2016-02-23T08:59:00","2016-02-23T13:46:00",4.78333333338378,287,"P","--","0,000","NO",0.60000000000000009,112.71240000000003,"--","--","--","--","--","--","--","SI",112.71240000000003]
[null,null,57,299713,2477,"LAS FLORES","TRAFO 1",15,"132/33/13,2",19.650000000000002,"2016-02-24T08:28:00","2016-02-24T13:32:00",5.066666666592937,304,"P","--","0,000","NO",0.60000000000000009,59.775300000000016,"--","--","--","--","--","--","--","SI",59.775300000000016]
[null,null,58,299714,4832,"CHAÑARES","TRAFO 1",30,"132/33/13,2",39.300000000000004,"2016-02-24T08:28:00","2016-02-24T13:32:00",5.066666666592937,304,"P","--","0,000","NO",0.60000000000000009,119.55060000000003,"--","--","--","--","--","--","--","SI",119.55060000000003]
[null,null,59,299720,4832,"CHAÑARES","TRAFO 1",30,"132/33/13,2",39.300000000000004,"2016-02-25T08:12:00","2016-02-25T16:00:00",7.7999999999301508,468,"P","--","0,000","NO",0.60000000000000009,183.92400000000004,"--","--","--","--","--","--","--","SI",183.92400000000004]
[null,null,60,299723,4832,"CHAÑARES","TRAFO 1",30,"132/33/13,2",39.300000000000004,"2016-02-26T08:59:00","2016-02-26T13:33:00",4.5666666667093523,274,"P","--","0,000","NO",0.60000000000000009,107.76060000000003,"--","--","--","--","--","--","--","SI",107.76060000000003]
[null,null,61,299724,2296,"OLAVARRIA VIEJA","T1OA",30,"132/33/13,2",39.300000000000004,"2016-02-26T09:34:00","2016-02-26T13:02:00",3.466666666790843,208,"P","--","0,000","NO",0.60000000000000009,81.822600000000023,"--","--","--","--","--","--","--","SI",81.822600000000023]
[null,null,62,299725,2431,"VILLA GESELL","TRAFO 3",40,"132/13,2",52.400000000000006,"2016-02-27T14:41:00","2016-02-27T19:23:00",4.6999999999534339,282,"F","NO","0,000","NO",{"$f":"$I$17*IF(OR(O31=\"P\",O31=\"RP\"),0.1,1)*IF(R31=\"SI\",1,0.1)","v":6},{"$f":"IF(O31=\"P\",J31*S31*ROUND(N31/60,2),\"--\")","v":"--"},{"$f":"IF(O31=\"RP\",J31*S31*ROUND(N31/60,2)*Q31/100,\"--\")","v":"--"},{"$f":"IF(AND(O31=\"F\",P31=\"NO\"),J31*S31,\"--\")","v":314.40000000000003},{"$f":"IF(O31=\"F\",J31*S31*ROUND(N31/60,2),\"--\")","v":1477.6800000000003},{"$f":"IF(AND(O31=\"R\",P31=\"NO\"),J31*S31*Q31/100,\"--\")","v":"--"},{"$f":"IF(O31=\"R\",J31*S31*ROUND(N31/60,2)*Q31/100,\"--\")","v":"--"},{"$f":"IF(O31=\"RF\",J31*S31*ROUND(N31/60,2),\"--\")","v":"--"},{"$f":"IF(O31=\"RR\",J31*S31*ROUND(N31/60,2)*Q31/100,\"--\")","v":"--"},"SI",1792.0800000000004]
[null,null,63,299727,2608,"CAMPANA","TRAFO 2",30,"132/33/13,2",39.300000000000004,"2016-02-28T08:23:00","2016-02-28T17:21:00",8.9666666665580124,538,"P","--","0,000","NO",0.60000000000000009,211.51260000000008,"--","--","--","--","--","--","--","SI",211.51260000000008]
[null,null,64,299729,2296,"OLAVARRIA VIEJA","T1OA",30,"132/33/13,2",39.300000000000004,"2016-02-29T09:06:00","2016-02-29T14:44:00",5.6333333333604969,338,"P","--","0,000","NO",0.60000000000000009,132.75540000000004,"--","--","--","--","--","--","--","SI",132.75540000000004]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"",{"$f":"IF(F34=\"\",\"\",\"--\")","v":""},{"$f":"IF(F34=\"\",\"\",\"NO\")","v":""},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,"","",{"$f":"IF(F39=\"\",\"\",\"NO\")","v":""},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,"--","--","--","--","--","--","--","--",{"$f":"IF(F41=\"\",\"\",\"SI\")","v":""},""]
[null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[]
[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:T43)","v":1009.8135000000002},{"$f":"SUM(U20:U43)","v":0},{"$f":"SUM(V20:V43)","v":1493.4000000000003},{"$f":"SUM(W22:W43)","v":2892.4800000000005},{"$f":"SUM(X20:X43)","v":94.32},{"$f":"SUM(Y22:Y43)","v":1749.636},{"$f":"SUM(Z20:Z43)","v":4489.6319999999996},{"$f":"SUM(AA22:AA43)","v":0},null,{"$f":"ROUND(SUM(AC20:AC43),2)","v":45584}]

{"sheet":"SA-02 (1)","index":5,"n_rows":42,"n_cols":22,"rows_kept":42,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'TOT-0216'!B2","v":"ANEXO III al Memorándum D.T.E.E. N°   243 / 2017"}]
[]
["ENTE NACIONAL REGULADOR "]
["DE LA ELECTRICIDAD"]
[]
[]
[null,null,null,null,null,"SISTEMA DE TRANSPORTE DE ENERGÍA ELÉCTRICA POR DISTRIBUCIÓN TRONCAL -  TRANSBA S.A."]
[]
[null,null,null,null,null,"2.2.- Salidas"]
[]
[null,{"$f":"'TOT-0216'!B14","v":"Desde el 01 al 29 de Febrero de 2016"}]
[]
[null,null,null,null,null,"Salida en 220 kV",34.93,{"$f":"60*'TOT-0216'!B13","v":60},null,{"$f":"IF(H14=60,\" \",IF(H14=120,\"    Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"    REVISAR COEFICIENTE\"))","v":" "}]
[null,null,null,null,null,"Salida en 132 kV o 66 kV = ",17.466000000000001,{"$f":"50*'TOT-0216'!B13","v":50},null,{"$f":"IF(H15=50,\" \",IF(H15=100,\"    Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"    REVISAR COEFICIENTE\"))","v":" "}]
[null,null,null,null,null,"Salida en 33 kV ",13.097,{"$f":"50*'TOT-0216'!B13","v":50},null,{"$f":"IF(H16=50,\" \",IF(H16=100,\"    Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"    REVISAR COEFICIENTE\"))","v":" "}]
[null,null,null,null,null,"Salida en 13,2 kV =",13.097,{"$f":"40*'TOT-0216'!B13","v":40},null,{"$f":"IF(H17=40,\" \",IF(H17=80,\"    Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"    REVISAR COEFICIENTE\"))","v":" "}]
[null,null,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22]
[null,null,"N°","INDISP","ID EQUIPO","ESTACIÓN \nTRANSFORMADORA","EQUIPO","U\n[kV]","$/h","Salida","Entrada","Hs\nIndisp.","Minutos.\nIndisp.","Tipo \nSal.(²)","AUT.","K (U)","PENALIZAC.\nPROGRAM.","PENALIZACIÓN FORZADA\nPor Salida   hs. Restantes",null,"RESTANTE\nFORZADA","Informó\nen Térm.","TOTAL\nPENALIZAC."]
[]
[]
[null,null,65,298620,2654,"TORNQUIST","Alimentador 1 PAPEL TORNQUIST",13.2,{"$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":13.097},"2016-02-03T07:47:00","2016-02-03T16:57:00",{"$f":"IF(F22=\"\",\"\",(K22-J22)*24)","v":9.1666666666860692},{"$f":"IF(F22=\"\",\"\",ROUND((K22-J22)*24*60,0))","v":550},"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>13.2),$H$16,$H$17)))","v":40},{"$f":"IF(N22=\"P\",I22*P22*ROUND(M22/60,2)*0.1,\"--\")","v":480.39796000000001},{"$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":480.39796000000001}]
[null,null,66,298621,2655,"TORNQUIST","Alimentador 2 PAPEL TORNQUIST",13.199999809265137,13.097,"2016-02-03T07:48:00","2016-02-03T16:57:00",9.1500000001396984,549,"P","--",40,479.35020000000009,"--","--","--","SI",479.35020000000009]
[null,null,67,298623,2650,"TORNQUIST","Alimentador 1",33,13.097,"2016-02-03T08:03:00","2016-02-03T17:08:00",9.0833333332557231,545,"P","--",50,594.60380000000009,"--","--","--","SI",594.60380000000009]
[null,null,68,298626,2408,"LAS ARMAS","Alimentador 1 a LAS ARMAS",13.199999809265137,13.097,"2016-02-04T04:03:00","2016-02-04T06:41:00",2.6333333333604969,158,"P","--",40,137.78044,"--","--","--","SI",137.78044]
[null,null,69,298637,2261,"HENDERSON","SALIDA TRAFO 500/132",132,17.466000000000001,"2016-02-06T09:17:00","2016-02-06T21:01:00",11.733333333337214,704,"P","--",50,1024.3809000000001,"--","--","--","SI",0]
[]
[null,null,71,298646,2092,"SAN NICOLAS","SALIDA A RyCSA",33,13.097,"2016-02-07T05:54:00","2016-02-07T13:10:00",7.2666666666045785,436,"P","--",50,476.07595000000003,"--","--","--","SI",476.07595000000003]
[null,null,72,298647,2261,"HENDERSON","SALIDA TRAFO 500/132",132,17.466000000000001,"2016-02-07T07:48:00","2016-02-07T13:38:00",5.8333333334885538,350,"P","--",50,509.1339000000001,"--","--","--","SI",0]
[null,null,73,298833,2261,"HENDERSON","SALIDA TRAFO 500/132",132,17.466000000000001,"2016-02-08T14:31:00","2016-02-08T14:50:00",0.31666666665114462,19,"P","--",50,27.945600000000002,"--","--","--","SI",0]
[null,null,74,298834,3146,"PROTISA","SALIDA A TRAFO 132/13,2",132,17.466000000000001,"2016-02-09T08:39:00","2016-02-09T12:52:00",4.21666666661622,253,"P","--",50,368.5326,"--","--","--","SI",0]
[null,null,75,298853,4447,"VILLA GESELL","SALIDA TG14",132,17.466000000000001,"2016-02-11T08:34:00","2016-02-11T12:26:00",3.8666666666977108,232,"P","--",50,337.96710000000007,"--","--","--","SI",0]
[null,null,76,298909,2178,"BRAGADO","SALIDA WARNER-O´BRIEN",33,13.097,"2016-02-12T12:00:00","2016-02-12T12:38:00",0.63333333330228925,38,"F","NO",50,"--",654.85,412.55549999999999,"--","SI",1067.4055000000001]
[]
[null,null,78,298910,2294,"CHACABUCO","SALIDA 7 A CHACABUCO",13.2,13.097,"2016-02-12T12:00:00","2016-02-12T12:31:00",0.5166666666045785,31,"F","NO",40,"--",523.88,272.41759999999999,"--","SI",796.29759999999999]
[null,null,79,298924,2634,"PETROQUIMICA","SALIDA CARGILL",33,13.097,"2016-02-13T07:35:00","2016-02-13T17:52:00",10.283333333325572,617,"P","--",50,673.18580000000009,"--","--","--","SI",673.18580000000009]
[]
[null,null,81,299401,2397,"TRES ARROYOS","SALIDA 1 A G. CHAVES",33,13.097,"2016-02-16T09:37:00","2016-02-16T13:53:00",4.2666666667792015,256,"P","--",50,279.62094999999999,"--","--","--","SI",279.62094999999999]
[null,null,82,299406,2398,"TRES ARROYOS","SALIDA 2 A G. CHAVES",33,13.097,"2016-02-17T11:35:00","2016-02-17T14:33:00",2.9666666665580124,178,"P","--",50,194.49045000000001,"--","--","--","SI",194.49045000000001]
[null,null,null,null,null,null,null,null,13.097,null,null,"","",null,"",40,"--","--","--","--",{"$f":"IF(F40=\"\",\"\",\"SI\")","v":""},""]
[]
[null,null,"(²)","P - PROGRAMADA  ; F - FORZADA",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q20:Q41)","v":5583.465650000001},{"$f":"SUM(R20:R41)","v":1178.73},{"$f":"SUM(S20:S41)","v":684.97309999999993},{"$f":"SUM(T20:T41)","v":0},null,{"$f":"ROUND(SUM(V20:V41),2)","v":5179.21}]

{"sheet":"SA-02 (2)","index":6,"n_rows":43,"n_cols":22,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'TOT-0216'!B2","v":"ANEXO III al Memorándum D.T.E.E. N°   243 / 2017"}]
[]
["ENTE NACIONAL REGULADOR "]
["DE LA ELECTRICIDAD"]
[]
[]
[null,null,null,null,null,"SISTEMA DE TRANSPORTE DE ENERGÍA ELÉCTRICA POR DISTRIBUCIÓN TRONCAL -  TRANSBA S.A."]
[]
[null,null,null,null,null,"2.2.- Salidas"]
[]
[null,{"$f":"'TOT-0216'!B14","v":"Desde el 01 al 29 de Febrero de 2016"}]
[]
[null,null,null,null,null,"Salida en 220 kV",34.93,{"$f":"60*'TOT-0216'!B13","v":60},null,{"$f":"IF(H14=60,\" \",IF(H14=120,\"    Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"    REVISAR COEFICIENTE\"))","v":" "}]
[null,null,null,null,null,"Salida en 132 kV o 66 kV = ",17.466000000000001,{"$f":"50*'TOT-0216'!B13","v":50},null,{"$f":"IF(H15=50,\" \",IF(H15=100,\"    Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"    REVISAR COEFICIENTE\"))","v":" "}]
[null,null,null,null,null,"Salida en 33 kV ",13.097,{"$f":"50*'TOT-0216'!B13","v":50},null,{"$f":"IF(H16=50,\" \",IF(H16=100,\"    Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"    REVISAR COEFICIENTE\"))","v":" "}]
[null,null,null,null,null,"Salida en 13,2 kV =",13.097,{"$f":"40*'TOT-0216'!B13","v":40},null,{"$f":"IF(H17=40,\" \",IF(H17=80,\"    Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"    REVISAR COEFICIENTE\"))","v":" "}]
[null,null,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22]
[null,null,"N°","INDISP","ID EQUIPO","ESTACIÓN \nTRANSFORMADORA","EQUIPO","U\n[kV]","$/h","Salida","Entrada","Hs\nIndisp.","Minutos.\nIndisp.","Tipo \nSal.(²)","AUT.","K (U)","PENALIZAC.\nPROGRAM.","PENALIZACIÓN FORZADA\nPor Salida   hs. Restantes",null,"RESTANTE\nFORZADA","Informó\nen Térm.","TOTAL\nPENALIZAC."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'SA-02 (1)'!V42","v":5179.21}]
[]
[null,null,83,299407,2324,"G. CHAVES","SALIDA A TRES ARROYOS",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":13.097},"2016-02-17T11:40:00","2016-02-17T14:30:00",{"$f":"IF(F22=\"\",\"\",(K22-J22)*24)","v":2.8333333333139308},{"$f":"IF(F22=\"\",\"\",ROUND((K22-J22)*24*60,0))","v":170},"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>13.2),$H$16,$H$17)))","v":50},{"$f":"IF(N22=\"P\",I22*P22*ROUND(M22/60,2)*0.1,\"--\")","v":185.32255000000001},{"$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":185.32255000000001}]
[null,null,84,299408,2324,"G. CHAVES","SALIDA A TRES ARROYOS",33,13.097,"2016-02-18T07:34:00","2016-02-18T12:53:00",5.3166666667093523,319,"P",{"$f":"IF(F23=\"\",\"\",IF(OR(N23=\"P\",N23=\"RP\"),\"--\",\"NO\"))","v":"--"},50,348.38020000000006,"--","--","--","SI",348.38020000000006]
[null,null,85,299409,2398,"TRES ARROYOS","SALIDA 2 A G. CHAVES",33,13.097,"2016-02-18T07:34:00","2016-02-18T12:39:00",5.0833333333139308,305,"P","--",50,332.66380000000004,"--","--","--","SI",332.66380000000004]
[null,null,86,299412,2502,"PUNTA ALTA","SALIDA 1 A P.S. GRUNBEIN",33,13.097,"2016-02-18T08:54:00","2016-02-18T16:39:00",7.7499999999417923,465,"P","--",50,507.50875000000008,"--","--","--","SI",507.50875000000008]
[null,null,87,299413,2504,"PUNTA ALTA","SALIDA 4 A B. NABAL P. BELGRANO",33,13.097,"2016-02-18T09:12:00","2016-02-18T16:04:00",6.8666666666977108,412,"P","--",50,449.88195000000007,"--","--","--","SI",449.88195000000007]
[null,null,88,299415,2142,"ARRECIFES","SALIDA 1 A ARRECIFES",13.2,13.097,"2016-02-18T11:22:00","2016-02-18T13:34:00",2.2000000000116415,132,"P","--",40,115.25360000000001,"--","--","--","SI",115.25360000000001]
[]
[null,null,90,299421,2545,"PIGUE","SALIDA 3 A SAAVEDRA",33,13.097,"2016-02-19T08:40:00","2016-02-19T16:00:00",7.3333333333139308,440,"P","--",50,480.00505000000004,"--","--","--","SI",480.00505000000004]
[null,null,91,299425,2505,"PUNTA ALTA","SALIDA 6 A B. NABAL P. BELGRANO",33,13.097,"2016-02-19T09:27:00","2016-02-19T16:00:00",6.5499999998719431,393,"P","--",50,428.92675000000003,"--","--","--","SI",428.92675000000003]
[null,null,92,299426,2503,"PUNTA ALTA","SALIDA 2 A P.S. GRUNBEIN",13.199999809265137,13.097,"2016-02-19T09:32:00","2016-02-19T16:21:00",6.8166666667093523,409,"P","--",40,357.28616000000005,"--","--","--","SI",357.28616000000005]
[null,null,93,299709,4447,"VILLA GESELL","SALIDA TG14",132,17.466000000000001,"2016-02-24T04:50:00","2016-02-24T11:35:00",6.75,405,"P","--",50,589.47750000000008,"--","--","--","SI",0]
[]
[]
[]
[null,null,97,299718,2384,"BARKER","Alimentador 3 a Coop.BARKER",13.2,13.097,"2016-02-25T07:32:00","2016-02-25T08:45:00",1.216666666790843,73,"P","--",40,63.913360000000004,"--","--","--","SI",63.913360000000004]
[null,null,null,null,null,null,null,null,13.097,null,null,"","",null,"",40,"--","--","--","--",null,""]
[null,null,null,null,null,null,null,null,13.097,null,null,"","",null,"",40,"--","--","--","--",null,""]
[null,null,null,null,null,null,null,null,13.097,null,null,"","",null,"",40,"--","--","--","--",null,""]
[null,null,null,null,null,null,null,null,13.097,null,null,"","",null,"",40,"--","--","--","--",null,""]
[null,null,null,null,null,null,null,null,13.097,null,null,"","",null,"",40,"--","--","--","--",{"$f":"IF(F41=\"\",\"\",\"SI\")","v":""},""]
[]
[null,null,"(²)","P - PROGRAMADA  ; F - FORZADA",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(Q20:Q42)","v":3858.6196700000005},{"$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":8448.35}]

{"sheet":"RE-02 (1)","index":7,"n_rows":44,"n_cols":30,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"'TOT-0216'!B2","v":"ANEXO III al Memorándum D.T.E.E. N°   243 / 2017"}]
[]
["ENTE NACIONAL REGULADOR "]
["DE LA ELECTRICIDAD"]
[]
[]
[null,null,null,null,null,"SISTEMA DE TRANSPORTE DE ENERGÍA ELÉCTRICA POR DISTRIBUCIÓN TRONCAL - TRANSBA S.A."]
[]
[null,null,null,null,null,"3.- REACTIVA"]
[]
[null,null,null,null,null,"3.- Equipamiento propio Res. 01_03"]
[]
[null,{"$f":"'TOT-0216'!B14","v":"Desde el 01 al 29 de Febrero de 2016"}]
[]
[null,null,null,null,null,"Coeficiente de penalización por salida forzada   =",null,null,null,{"$f":"60*'TOT-0216'!B13","v":60},null,{"$f":"IF(J16=60,\" \",IF(J16=120,\"    Coeficiente duplicado por tasa de falla >4 Sal. x año/100 km.\",\"    REVISAR COEFICIENTE\"))","v":" "}]
[null,null,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30]
[null,null,"N°","INDISP","ID EQUIPO","ESTACIÓN \nTRANSFORMADORA","EQUIPO","POT.\n[MVA]","MVA    $ =","U\n[kV]","$/h","Salida","Entrada","Hs\nIndisp.","Minutos.\nIndisp.","Tipo \nSal.(²)","AUT.","C.R.\n%","E.N.S.","K (P y 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ó \nen Térm.","TOTAL\nPENALIZAC."]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"H20*I20","v":0},null,null,{"$f":"IF(F20=\"\",\"\",(M20-L20)*24)","v":""},{"$f":"IF(F20=\"\",\"\",ROUND((M20-L20)*24*60,0))","v":""},null,null,null,null,{"$f":"$J$16*IF(OR(P20=\"P\",P20=\"RP\"),0.1,1)*IF(S20=\"SI\",1,0.1)","v":6},{"$f":"IF(P20=\"P\",K20*T20*ROUND(O20/60,2),\"--\")","v":"--"},{"$f":"IF(P20=\"RP\",K20*T20*ROUND(O20/60,2)*R20/100,\"--\")","v":"--"},{"$f":"IF(AND(P20=\"F\",Q20=\"NO\"),K20*T20,\"--\")","v":"--"},{"$f":"IF(P20=\"F\",K20*T20*ROUND(O20/60,2),\"--\")","v":"--"},{"$f":"IF(AND(P20=\"R\",Q20=\"NO\"),K20*T20*R20/100,\"--\")","v":"--"},{"$f":"IF(P20=\"R\",K20*T20*ROUND(O20/60,2)*R20/100,\"--\")","v":"--"},{"$f":"IF(P20=\"RF\",K20*T20*ROUND(O20/60,2),\"--\")","v":"--"},{"$f":"IF(P20=\"RR\",K20*T20*ROUND(O20/60,2)*R20/100,\"--\")","v":"--"},null,{"$f":"IF(F20=\"\",\"\",SUM(U20:AB20)*IF(AC20=\"SI\",1,2))","v":""}]
[null,null,98,298649,4450,"MERCEDES","CAP K1MD",1.5,4.8739999999999997,13.199999809265137,{"$f":"H21*I21","v":7.3109999999999999},"2016-02-07T17:03:00","2016-02-10T13:18:00",68.25,4095,"F",{"$f":"IF(F21=\"\",\"\",IF(OR(P21=\"P\",P21=\"RP\"),\"--\",\"NO\"))","v":"NO"},{"$f":"IF(F21=\"\",\"\",\"--\")","v":"--"},{"$f":"IF(F21=\"\",\"\",\"NO\")","v":"NO"},6,"--","--",43.866,2993.8544999999999,"--","--","--","--","SI",3037.7204999999999]
[null,null,99,298854,4460,"JUNIN","K1JU",1.5,4.8739999999999997,13.199999809265137,{"$f":"H22*I22","v":7.3109999999999999},"2016-02-12T11:09:00","2016-02-12T14:27:00",{"$f":"IF(F22=\"\",\"\",(M22-L22)*24)","v":3.2999999999301508},{"$f":"IF(F22=\"\",\"\",ROUND((M22-L22)*24*60,0))","v":198},"F",{"$f":"IF(F22=\"\",\"\",IF(OR(P22=\"P\",P22=\"RP\"),\"--\",\"NO\"))","v":"NO"},{"$f":"IF(F22=\"\",\"\",\"--\")","v":"--"},{"$f":"IF(F22=\"\",\"\",\"NO\")","v":"NO"},{"$f":"$J$16*IF(OR(P22=\"P\",P22=\"RP\"),0.1,1)*IF(S22=\"SI\",1,0.1)","v":6},{"$f":"IF(P22=\"P\",K22*T22*ROUND(O22/60,2),\"--\")","v":"--"},{"$f":"IF(P22=\"RP\",K22*T22*ROUND(O22/60,2)*R22/100,\"--\")","v":"--"},{"$f":"IF(AND(P22=\"F\",Q22=\"NO\"),K22*T22,\"--\")","v":43.866},{"$f":"IF(P22=\"F\",K22*T22*ROUND(O22/60,2),\"--\")","v":144.7578},{"$f":"IF(AND(P22=\"R\",Q22=\"NO\"),K22*T22*R22/100,\"--\")","v":"--"},{"$f":"IF(P22=\"R\",K22*T22*ROUND(O22/60,2)*R22/100,\"--\")","v":"--"},{"$f":"IF(P22=\"RF\",K22*T22*ROUND(O22/60,2),\"--\")","v":"--"},{"$f":"IF(P22=\"RR\",K22*T22*ROUND(O22/60,2)*R22/100,\"--\")","v":"--"},"SI",{"$f":"IF(F22=\"\",\"\",SUM(U22:AB22)*IF(AC22=\"SI\",1,2))","v":188.62380000000002}]
[null,null,100,298920,4460,"MERCEDES","CAP K1MD",1.5,4.8739999999999997,13.199999809265137,7.3109999999999999,"2015-12-10T16:12:00","2015-12-10T19:48:00",3.5999999998603016,216,"F",{"$f":"IF(F23=\"\",\"\",IF(OR(P23=\"P\",P23=\"RP\"),\"--\",\"NO\"))","v":"NO"},{"$f":"IF(F23=\"\",\"\",\"--\")","v":"--"},{"$f":"IF(F23=\"\",\"\",\"NO\")","v":"NO"},6,"--","--",43.866,157.91759999999999,"--","--","--","--","SI",201.78359999999998]
[null,null,101,299710,4458,"CHIVILCOY","K1CI",1.5,4.1980000000000004,13.199999809265137,6.2970000000000006,"2016-02-12T14:44:00","2016-02-12T16:25:00",1.683333333407063,101,"P","--","--","NO",0.60000000000000009,6.3473760000000015,"--","--","--","--","--","--","--","SI",6.3473760000000015]
[null,null,102,299711,4459,"CHIVILCOY","K2CI",3,4.1980000000000004,13.199999809265137,12.594000000000001,"2016-02-24T06:15:00","2016-02-24T11:03:00",4.8000000001047738,288,"P","--","--","NO",0.60000000000000009,36.270720000000004,"--","--","--","--","--","--","--","SI",36.270720000000004]
[null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--",{"$f":"IF(F26=\"\",\"\",\"SI\")","v":""},""]
[null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"H29*I29","v":0},null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,null,{"$f":"H30*I30","v":0},null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[null,null,null,null,null,null,null,null,null,null,0,null,null,"","",null,"","","",6,"--","--","--","--","--","--","--","--","",""]
[]
[null,null,"(²)","P - PROGRAMADA  ; F - FORZADA",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(U19:U43)","v":42.618096000000008},{"$f":"SUM(V19:V43)","v":0},{"$f":"SUM(W19:W43)","v":131.59800000000001},{"$f":"SUM(X21:X43)","v":3296.5298999999995},{"$f":"SUM(Y19:Y43)","v":0},{"$f":"SUM(Z21:Z43)","v":0},{"$f":"SUM(AA19:AA43)","v":0},{"$f":"SUM(AB21:AB43)","v":0},null,{"$f":"ROUND(SUM(AD19:AD43),2)","v":3470.75}]

{"sheet":"DATO","index":8,"n_rows":22,"n_cols":29,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Mes","Mes","Dia","Año"]
["enero","01",31,2006]
["febrero","02",{"$f":"IF(MOD(E14,4)=0,29,28)","v":29},{"$f":"+D2+1","v":2007}]
["marzo","03",31,2008]
["abril","04",30,2009]
["mayo","05",31,2010]
["junio","06",30,2011]
["julio","07",31,2012]
["agosto","08",31,2013]
["septiembre","09",30,2014]
["octubre","10",31,2015]
["noviembre","11",30,2016]
["diciembre","12",31,null,null,null,null,null,"Total"]
[11,2,{"$f":"CELL(\"CONTENIDO\",OFFSET(A1,B14,0))","v":"febrero"},{"$f":"CELL(\"CONTENIDO\",OFFSET(C1,B14,0))","v":29},{"$f":"CELL(\"CONTENIDO\",OFFSET(D1,A14,0))","v":2016},{"$f":"\"Desde el 01 al \" & D14 & \" de \" & C14 & \" de \" & E14","v":"Desde el 01 al 29 de febrero de 2016"},{"$f":"CELL(\"CONTENIDO\",OFFSET(B1,B14,0))","v":"02"},{"$f":"RIGHT(E14,2)","v":"16"},"B14"]
[null,{"$f":"\"\\\\rugor\\files\\Transporte\\Transporte\\AA PROCESO AUT ARCHIVOS J\\TRANSBA\\\" &E14","v":"\\\\rugor\\files\\Transporte\\Transporte\\AA PROCESO AUT ARCHIVOS J\\TRANSBA\\2016"},null,null,null,null,{"$f":"\"J\"&G14&H14&\"TBA\"","v":"J0216TBA"}]
[null,{"$f":"\"\\\\rugor\\files\\Transporte\\transporte\\AA PROCESO AUT\\INTERCAMBIO\\\" &H14&G14","v":"\\\\rugor\\files\\Transporte\\transporte\\AA PROCESO AUT\\INTERCAMBIO\\1602"}]
["Hoja","FilaInicio","FilasPlantilla","Columnas","NombreHoja","OrigenDeDatos","Col00","Col01","Col02","Col03","Col04","Col05","Col06","Col07","Col08","Col09","Col10","Col11","Col12","Col13","Col14","Col15","FILHTOTAL","COLHTOTAL","FILHCALC","COLHCALC","FILTRANSP","COLTRANSP","COL TSAL"]
["MODELO L",21,20,12,{"$f":"\"LI-\" & $G$14","v":"LI-02"},"TRANSBA_INDISPONIBILIDADES_LINEAS_TRANSBA.XLS",3,5,4,6,7,8,9,11,12,15,0,28,16,0,0,0,18,9,42,29,19,29,15]
["MODELO T",22,20,13,{"$f":"\"T-\" & $G$14","v":"T-02"},"TRANSBA_INDISPONIBILIDADES_TRAFOS_TRANSBA.XLS",3,5,4,6,7,8,9,11,12,15,16,18,28,17,0,0,22,9,43,29,20,29,15]
["MODELO S",22,20,10,{"$f":"\"SA-\" & $G$14","v":"SA-02"},"TRANSBA_INDISPONIBILIDADES_SALIDAS_TRANSBA.XLS",3,5,4,6,7,8,10,11,14,15,21,0,0,0,0,0,24,9,43,22,20,22,14]
["MODELO R",21,20,12,{"$f":"\"RE-\" & $G$14","v":"RE-02"},"TRANSBA_INDISPONIBILIDADES_REACTIVOS_TRANSBA.XLS",3,5,4,6,7,8,9,10,12,13,16,17,29,18,0,0,26,9,43,30,20,30,16]
["MODELO VST",19,24,4,{"$f":"\"CAUSAS-VST-\" & $G$14","v":"CAUSAS-VST-02"},"TRANSBA_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]