{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["2020-2021"],"not_rendered":{"charts":0,"images":0,"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":"2020-2021","index":0,"n_rows":119,"n_cols":72,"rows_kept":119,"cut":false,"hidden":false,"merged":[[8,43,8,52],[8,57,8,65],[10,63,13,63],[10,64,13,64],[10,65,13,65],[10,51,13,51],[9,43,9,45],[9,46,9,48],[10,47,13,47],[10,48,13,48],[9,63,9,65],[9,60,9,62],[10,57,13,57],[10,58,13,58],[10,59,13,59],[10,60,13,60],[10,61,13,61],[10,62,13,62],[10,29,13,29],[10,27,13,27],[12,23,13,23],[10,40,13,40],[10,41,13,41],[10,30,11,31],[10,32,11,33],[12,30,13,30],[12,31,13,31],[12,32,13,32],[12,33,13,33],[10,25,11,26],[10,23,11,24],[10,28,13,28],[9,57,9,59],[10,52,13,52],[10,43,13,43],[10,44,13,44],[10,45,13,45],[10,46,13,46],[10,49,13,49],[10,50,13,50],[9,49,9,52],[10,0,13,0],[11,15,11,18],[12,17,12,18],[11,7,12,8],[10,3,13,3],[10,4,10,10],[11,6,13,6],[11,5,13,5],[11,4,13,4],[11,9,12,10],[11,11,11,14],[8,0,8,29],[10,39,13,39],[10,11,10,18],[12,15,12,16],[10,19,13,19],[10,20,12,21],[10,38,13,38],[12,13,12,14],[12,11,12,12],[12,37,13,37],[10,34,11,35],[10,36,11,37],[12,34,13,34],[10,1,11,2],[12,2,13,2],[12,1,13,1],[12,35,13,35],[12,36,13,36],[10,22,13,22],[12,26,13,26],[12,25,13,25],[12,24,13,24]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Data","Sarbatoare legala"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-11-30","Sf Andrei"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-12-01","Ziua Nationala"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-12-25","Craciun prima zi"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-01-01","Anul nou prima zi"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-04-30","Vinerea Mare"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-05-03","Paste"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"parteneri adiacenti","UR",null,null,null,null,null,null,null,null,null,null,null,"parteneri adiacenti","UR",null,"2021-06-01","Ziua copilului"]
["EVIDENȚA LIMITĂRILOR ȘI/SAU ÎNTRERUPERILOR PLANIFICATE ȘI NEPLANIFICATE pentru anul gazier 2020 - 2021 / RECORD OF THE PLANNED AND UNPLANNED LIMITATIONS AND/OR INTERRUPTIONS related to the gas year 2020 - 2021",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Lucrari neprogramate",null,null,null,null,null,null,null,null,null,"NU6 ",{"$f":"SUBTOTAL(9,AS:AS)","v":25},{"$f":"SUBTOTAL(9,AV:AV)","v":787},null,"Lucrari programate",null,null,null,null,null,null,null,null,"NU5",{"$f":"SUBTOTAL(9,BG:BG)","v":1},{"$f":"SUBTOTAL(9,BJ:BJ)","v":1},null,"2021-06-21","Rusalii"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Partener adiacent",null,null,"UR",null,null,null,null,null,null,"NUafectati ",{"$f":"SUBTOTAL(9,AT:AT)","v":25},{"$f":"SUBTOTAL(9,AW:AW)","v":787},null,"Partener adiacent",null,null,"UR",null,null,null,null,null,"NUafectati ",{"$f":"SUBTOTAL(9,BH:BH)","v":1},{"$f":"SUBTOTAL(9,BK:BK)","v":1}]
["Nr. crt. / Item No.","Tipul limitării/întreruperii / \nType of limitation/interruption",null,"Denumire lucrare/motiv limitare și/sau întrerupere / \nName of the works/reason for the limitation and/or interruption ","Locația limitării/întreruperii / Location of the limitation/interruption ",null,null,null,null,null,null,"Punct de ieșire/intrare afectat / Affected exit/entry point",null,null,null,null,null,null,null,"Cod punct relevant / Code of the relevant point","Utilizator ST afectat / Affected TS user ",null,"Perioada planificată de execuție a lucrării / Planned period for the execution of the works","Data și ora limitării/întreruperii / Date and hour of the limitation/interruption ",null,"Data și ora reluării prestării serviciului / Date and hour the service supply is resumed",null,"Exploatarea Teritorială / Regional Office","Observații / Comments","Justificarea modificării perioadei planificate de execuție a lucrări","Data și ora efectivă de limitare/întrerupere ",null,"Data și ora efectivă de reluare a prestării serviciului",null,"Data și ora informării UR",null,"Data și ora informării partenerului adiacent",null,"Foaia de manevră","A fost afectat producătorul (în cazul PM) sau consumatorul final (în cazul SM)? \n(DA/NU)","Observatii","Program bugetat",null,"Numar de ore de la producerea intreruperii / limitarii pana la anuntarea partenerului adiacent\n (trebuie sa fie mai mic decat 6)","NU6","NUafectati","Numar de ore de la producerea intreruperii / limitarii pana la anuntarea UR\n (trebuie sa fie mai mic decat 6)","NU6","NUafectati","Durata intreruperii / limitarii [ore]\n(daca este mai mare de 24, trebuie sa fie completata celula aferenta de pe coloana AZ)","NU24","Nuafectati","Partener adiacent informat din 12 in 12 ore, daca durata mai mare de 24h\n(DA/NU)","NU6 ",{"$f":"BC9+BD9","v":812},"IP51",null,"Numar de zile lucratoare de anuntare partener adiacent pana la limitare / intrerupere (trebuie sa fie mai mare de 5)","NU5","NUafectati","Numar de zile de anuntare UR pana la limitare / intrerupere \n(trebuie sa fie mai mare de 5)","NU5","NUafectati","Numar ore intre data anuntata si cea efectiva de reluare\n(trebuie sa fie mai mic sau egal cu 0)","NUreluate","NUafectati","NU5",{"$f":"BP9+BQ9","v":2},"IP61"]
[null,null,null,null,"Siruta / Siruta code","Localitate / Locality","Județ / County","Coordonate GPS început / GPS coordinates-beginning",null,"Coordonate GPS sfârșit / GPS coordinates-end",null,"Puncte de ieșire din SNT / NTS exit points",null,null,null,"Puncte de intrare în SNT / NTS entry points ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NUafectati ",{"$f":"BC10+BD10","v":812},{"$f":"IF(BC12=0,1,BC11/BC12)","v":1},null,null,null,null,null,null,null,null,null,null,"NUafectati ",{"$f":"BP10+BQ10","v":2},{"$f":"IF(BP12=0,1,BP11/BP12)","v":1}]
[null,"Neplanificată / Unplanned","Planificată / Planned",null,null,null,null,null,null,null,null,"Limitare / Limitation",null,"Întrerupere / Interruption",null,"Limitare / Limitation",null,"Întrerupere / Interruption",null,null,null,null,null,"Data / Date","Ora / Hour","Data / Date","Ora / Hour",null,null,null,"Data","Ora","Data","Ora","Data","Ora","Data","Ora",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NU24",{"$f":"SUBTOTAL(9,AY:AY)","v":0},"IP52",null,null,null,null,null,null,null,null,null,null,"NUreluare",{"$f":"SUBTOTAL(9,BM:BM)","v":2},"IP62"]
[null,null,null,null,null,null,null,"X1","Y1","X2","Y2","Cod / Code","Denumire / Name","Cod / Code","Denumire / Name","Cod / Code","Denumire / Name","Cod / Code","Denumire / Name",null,"Utilizator de rețea / Network User","Partener adiacent / Adjacent Partner",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NUafectati",{"$f":"SUBTOTAL(9,AZ:AZ)","v":0},{"$f":"IF(BC14=0,1,BC13/BC14)","v":1},null,null,null,null,null,null,null,null,null,null,"NUafectati",{"$f":"SUBTOTAL(9,BN:BN)","v":2},{"$f":"IF(BP14=0,1,BP13/BP14)","v":1}]
[0,1,2,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,31,32,33,34,35,36,37,38,39,40,41]
[{"$f":"SUM(1,A15)","v":1},"-","x","Punere în siguranță a conductei de transport gaze naturale 8” Cornățel -Avrig, zona Cornățel - Săcădate",145435,"Cornățel","Sibiu",449818.78,477723.02,449818.78,477723.02,"-","-","SM0795D0","Cornățel","-","-","-","-","SM-SD001",null,"Delgaz Grid","octombrie - decembrie 2020",null,null,null,null,"Mediaș",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2020_cap.A_2.1.B.6",null,{"$f":"IF(B16=\"X\",IF(AN16=\"\",\"Afectat sau NU?\",IF(AN16=\"DA\",IF(((AK16+AL16)-(AE16+AF16))*24<-720,\"Neinformat\",((AK16+AL16)-(AE16+AF16))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B16=\"X\",IF(AN16=\"DA\",IF(AR16<6,LEN(TRIM(V16))-LEN(SUBSTITUTE(V16,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B16=\"X\",IF(AN16=\"DA\",LEN(TRIM(V16))-LEN(SUBSTITUTE(V16,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B16=\"X\",IF(AN16=\"\",\"Afectat sau NU?\",IF(AN16=\"DA\",IF(((AI16+AJ16)-(AE16+AF16))*24<-720,\"Neinformat\",((AI16+AJ16)-(AE16+AF16))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B16=\"X\",IF(AN16=\"DA\",IF(AU16<6,LEN(TRIM(U16))-LEN(SUBSTITUTE(U16,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B16=\"X\",IF(AN16=\"DA\",LEN(TRIM(U16))-LEN(SUBSTITUTE(U16,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B16=\"X\",IF(AN16=\"\",\"Afectat sau NU?\",IF(AN16=\"DA\",((AG16+AH16)-(AE16+AF16))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B16=\"X\",IF(AN16=\"DA\",IF(AX16>24,IF(BA16=\"NU\",0,LEN(TRIM(V16))-LEN(SUBSTITUTE(V16,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":""},{"$f":"IF(B16=\"X\",IF(AN16=\"DA\",IF(AX16>24,LEN(TRIM(V16))-LEN(SUBSTITUTE(V16,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(C16=\"X\",IF(AN16=\"\",\"Afectat sau NU?\",IF(AN16=\"DA\",IF(AK16=\"\",\"Neinformat\",NETWORKDAYS(AK16+AL16,AE16+AF16,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C16=\"X\",IF(AN16=\"DA\",IF(AND(BF16>=5,AK16<>\"\"),LEN(TRIM(V16))-LEN(SUBSTITUTE(V16,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C16=\"X\",IF(AN16=\"DA\",LEN(TRIM(V16))-LEN(SUBSTITUTE(V16,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C16=\"X\",IF(AN16=\"\",\"Afectat sau NU?\",IF(AN16=\"DA\",IF(AI16=\"\",\"Neinformat\",NETWORKDAYS(AI16+AJ16,AE16+AF16,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C16=\"X\",IF(AN16=\"DA\",IF(AND(BI16>=5,AI16<>\"\"),LEN(TRIM(U16))-LEN(SUBSTITUTE(U16,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C16=\"X\",IF(AN16=\"DA\",LEN(TRIM(U16))-LEN(SUBSTITUTE(U16,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C16=\"X\",IF(AN16=\"\",\"Afectat sau NU?\",IF(AN16=\"DA\",((AG16+AH16)-(Z16+AA16))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C16=\"X\",IF(AN16<>\"DA\",\"-\",IF(AND(AN16=\"DA\",BL16<=0),LEN(TRIM(V16))-LEN(SUBSTITUTE(V16,CHAR(44),\"\"))+1+LEN(TRIM(U16))-LEN(SUBSTITUTE(U16,CHAR(44),\"\"))+1,0)),\"\")","v":"-"},{"$f":"IF(C16=\"X\",IF(AN16=\"DA\",LEN(TRIM(V16))-LEN(SUBSTITUTE(V16,CHAR(44),\"\"))+1+LEN(TRIM(U16))-LEN(SUBSTITUTE(U16,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"}]
[{"$f":"SUM(1,A16)","v":2},"-","x","Punere în siguranță a conductei de transport gaze naturale 8” Cornățel -Avrig, zona Cornățel - Săcădate",144072,"Bradu","Sibiu",448674.81,469982.34,448674.81,469982.34,"-","-","SM0801D0","Bradu","-","-","-","-","SM-SD001",null,"Delgaz Grid","octombrie - decembrie 2020",null,null,null,null,"Mediaș",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2020_cap.A_2.1.B.6",null,{"$f":"IF(B17=\"X\",IF(AN17=\"\",\"Afectat sau NU?\",IF(AN17=\"DA\",IF(((AK17+AL17)-(AE17+AF17))*24<-720,\"Neinformat\",((AK17+AL17)-(AE17+AF17))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B17=\"X\",IF(AN17=\"DA\",IF(AR17<6,LEN(TRIM(V17))-LEN(SUBSTITUTE(V17,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B17=\"X\",IF(AN17=\"DA\",LEN(TRIM(V17))-LEN(SUBSTITUTE(V17,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B17=\"X\",IF(AN17=\"\",\"Afectat sau NU?\",IF(AN17=\"DA\",IF(((AI17+AJ17)-(AE17+AF17))*24<-720,\"Neinformat\",((AI17+AJ17)-(AE17+AF17))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B17=\"X\",IF(AN17=\"DA\",IF(AU17<6,LEN(TRIM(U17))-LEN(SUBSTITUTE(U17,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B17=\"X\",IF(AN17=\"DA\",LEN(TRIM(U17))-LEN(SUBSTITUTE(U17,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B17=\"X\",IF(AN17=\"\",\"Afectat sau NU?\",IF(AN17=\"DA\",((AG17+AH17)-(AE17+AF17))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B17=\"X\",IF(AN17=\"DA\",IF(AX17>24,IF(BA17=\"NU\",0,LEN(TRIM(V17))-LEN(SUBSTITUTE(V17,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":""},{"$f":"IF(B17=\"X\",IF(AN17=\"DA\",IF(AX17>24,LEN(TRIM(V17))-LEN(SUBSTITUTE(V17,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(C17=\"X\",IF(AN17=\"\",\"Afectat sau NU?\",IF(AN17=\"DA\",IF(AK17=\"\",\"Neinformat\",NETWORKDAYS(AK17+AL17,AE17+AF17,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C17=\"X\",IF(AN17=\"DA\",IF(AND(BF17>=5,AK17<>\"\"),LEN(TRIM(V17))-LEN(SUBSTITUTE(V17,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C17=\"X\",IF(AN17=\"DA\",LEN(TRIM(V17))-LEN(SUBSTITUTE(V17,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C17=\"X\",IF(AN17=\"\",\"Afectat sau NU?\",IF(AN17=\"DA\",IF(AI17=\"\",\"Neinformat\",NETWORKDAYS(AI17+AJ17,AE17+AF17,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C17=\"X\",IF(AN17=\"DA\",IF(AND(BI17>=5,AI17<>\"\"),LEN(TRIM(U17))-LEN(SUBSTITUTE(U17,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C17=\"X\",IF(AN17=\"DA\",LEN(TRIM(U17))-LEN(SUBSTITUTE(U17,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C17=\"X\",IF(AN17=\"\",\"Afectat sau NU?\",IF(AN17=\"DA\",((AG17+AH17)-(Z17+AA17))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C17=\"X\",IF(AN17<>\"DA\",\"-\",IF(AND(AN17=\"DA\",BL17<=0),LEN(TRIM(V17))-LEN(SUBSTITUTE(V17,CHAR(44),\"\"))+1+LEN(TRIM(U17))-LEN(SUBSTITUTE(U17,CHAR(44),\"\"))+1,0)),\"\")","v":"-"},{"$f":"IF(C17=\"X\",IF(AN17=\"DA\",LEN(TRIM(V17))-LEN(SUBSTITUTE(V17,CHAR(44),\"\"))+1+LEN(TRIM(U17))-LEN(SUBSTITUTE(U17,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"}]
[{"$f":"SUM(1,A17)","v":3},"-","x","Punere în siguranță a conductei de transport gaze naturale 8” Cornățel -Avrig, zona Cornățel - Săcădate",144107,"Săcădate","Sibiu",452372.31,473781.88,452372.31,473781.88,"-","-","SM0796D0","Săcădate","-","-","-","-","SM-SD001",null,"Delgaz Grid","octombrie - decembrie 2020",null,null,null,null,"Mediaș",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2020_cap.A_2.1.B.6",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[{"$f":"SUM(1,A18)","v":4},"-","x","Punere în siguranță a conductei de transport gaze naturale 8” Cornățel -Avrig, zona Cornățel - Săcădate",144063,"Avrig","Sibiu",453991.75,471082.89,453991.75,471082.89,"-","-","SM0804D0","SC Premium Porc Sibiu - Avrig","-","-","-","-","SM-CF001",null,"SC Premium Porc Sibiu SRL","octombrie - decembrie 2020",null,null,null,null,"Mediaș",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2020_cap.A_2.1.B.6",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[5,"-","x","Punere în siguranță a conductei de transport gaze naturale 8” Cornățel -Avrig, zona Cornățel - Săcădate",144063,"Avrig","Sibiu",453138.85,469627.97,453138.85,469627.97,"-","-","SM0802D1","Avrig","-","-","-","-","SM-SD001",null,"Delgaz Grid","octombrie - decembrie 2020",null,null,null,null,"Mediaș",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2020_cap.A_2.1.B.6",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[6,"-","x","Punere în siguranță a conductei de transport gaze naturale 8” Cornățel -Avrig, zona Cornățel - Săcădate",144063,"Avrig","Sibiu",453138.85,469627.97,453138.85,469627.97,"-","-","SM0802D2","SC Fabrica de sticlă Avrig","-","-","-","-","SM-CF001",null,"SC Fabrica de sticlă Avrig SA","octombrie - decembrie 2020",null,null,null,null,"Mediaș",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2020_cap.A_2.1.B.6",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[7,"-","x","Punere în siguranță a conductei de transport gaze naturale 8” Cornățel -Avrig, zona Cornățel - Săcădate",144090,"Mârșa","Sibiu",451489.67,466968.99,451489.67,466968.99,"-","-","SM0819D1","Mârșa","-","-","-","-","SM-SD001",null,"Delgaz Grid","octombrie - decembrie 2020",null,null,null,null,"Mediaș",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2020_cap.A_2.1.B.6",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[8,"-","x","Punere în siguranță a conductei de transport gaze naturale 8” Cornățel -Avrig, zona Cornățel - Săcădate",145364,"Racovița","Sibiu",448491.14,465243.62,448491.14,465243.62,"-","-","SM0876D0","Racovița","-","-","-","-","SM-SD001",null,"Delgaz Grid","octombrie - decembrie 2020",null,null,null,null,"Mediaș",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2020_cap.A_2.1.B.6",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[9,"-","x","Punere în siguranță a conductei de transport gaze naturale 8” Cornățel -Avrig, zona Cornățel - Săcădate",145373,"Sebeșu de Sus","Sibiu",449528.49,462452.81,449528.49,462452.81,"-","-","SM0903D0","Sebeșu de Sus","-","-","-","-","SM-SD001",null,"Delgaz Grid","octombrie - decembrie 2020",null,null,null,null,"Mediaș",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2020_cap.A_2.1.B.6",null,"","","","","","","","","",null,null,null,null,null,{"$f":"IF(C24=\"X\",IF(AN24=\"\",\"Afectat sau NU?\",IF(AN24=\"DA\",IF(AK24=\"\",\"Neinformat\",NETWORKDAYS(AK24+AL24,AE24+AF24,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C24=\"X\",IF(AN24=\"DA\",IF(AND(BF24>=5,AK24<>\"\"),LEN(TRIM(V24))-LEN(SUBSTITUTE(V24,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C24=\"X\",IF(AN24=\"DA\",LEN(TRIM(V24))-LEN(SUBSTITUTE(V24,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C24=\"X\",IF(AN24=\"\",\"Afectat sau NU?\",IF(AN24=\"DA\",IF(AI24=\"\",\"Neinformat\",NETWORKDAYS(AI24+AJ24,AE24+AF24,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C24=\"X\",IF(AN24=\"DA\",IF(AND(BI24>=5,AI24<>\"\"),LEN(TRIM(U24))-LEN(SUBSTITUTE(U24,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C24=\"X\",IF(AN24=\"DA\",LEN(TRIM(U24))-LEN(SUBSTITUTE(U24,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C24=\"X\",IF(AN24=\"\",\"Afectat sau NU?\",IF(AN24=\"DA\",((AG24+AH24)-(Z24+AA24))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C24=\"X\",IF(AN24<>\"DA\",\"-\",IF(AND(AN24=\"DA\",BL24<=0),LEN(TRIM(V24))-LEN(SUBSTITUTE(V24,CHAR(44),\"\"))+1+LEN(TRIM(U24))-LEN(SUBSTITUTE(U24,CHAR(44),\"\"))+1,0)),\"\")","v":"-"},{"$f":"IF(C24=\"X\",IF(AN24=\"DA\",LEN(TRIM(V24))-LEN(SUBSTITUTE(V24,CHAR(44),\"\"))+1+LEN(TRIM(U24))-LEN(SUBSTITUTE(U24,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"}]
[10,"-","x","Punere în siguranță a conductei de transport gaze naturale 8” Cornățel -Avrig, zona Cornățel - Săcădate",145952,"Sebeșu de Jos","Sibiu",448296.46,461833.47,448296.46,461833.47,"-","-","SM1041D0","Sebeșu de Jos","-","-","-","-","SM-SD001",null,"Delgaz Grid","octombrie - decembrie 2020",null,null,null,null,"Mediaș",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2020_cap.A_2.1.B.6",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[11,"-","x","Punere în siguranță a conductei de transport gaze naturale 8” Cornățel -Avrig, zona Cornățel - Săcădate",145943,"Turnu Roșu","Sibiu",445948.45,460774.96,445948.45,460774.96,"-","-","SM0805D0","Turnu Roșu","-","-","-","-","SM-SD001",null,"Delgaz Grid","octombrie - decembrie 2020",null,null,null,null,"Mediaș",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2020_cap.A_2.1.B.6",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[12,"-","x","Punere în siguranță a conductei 8” racord PM Alămor, zona Alămor",144811,"Alămor","Sibiu",420533.37,493520.71,420533.37,493520.71,"-","-","-","-","-","-","PM0140","Alămor","PM-PP001",null,"Romgaz","octombrie - decembrie 2020",null,null,null,null,"Mediaș",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2020_cap.A_2.1.B.7",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[13,"-","x","Punere în siguranță a conductei 8” racord PM Alămor, zona Alămor",144811,"Alămor","Sibiu",422864.33,492914.95,422864.33,492914.95,"-","-","SM0748D0","Alămor","-","-","-","-","SM-SD001",null,"Delgaz Grid","octombrie - decembrie 2020",null,null,null,null,"Mediaș",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2020_cap.A_2.1.B.7",null,"","","","","","","","","",null,null,null,null,null,{"$f":"IF(C28=\"X\",IF(AN28=\"\",\"Afectat sau NU?\",IF(AN28=\"DA\",IF(AK28=\"\",\"Neinformat\",NETWORKDAYS(AK28+AL28,AE28+AF28,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C28=\"X\",IF(AN28=\"DA\",IF(AND(BF28>=5,AK28<>\"\"),LEN(TRIM(V28))-LEN(SUBSTITUTE(V28,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C28=\"X\",IF(AN28=\"DA\",LEN(TRIM(V28))-LEN(SUBSTITUTE(V28,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C28=\"X\",IF(AN28=\"\",\"Afectat sau NU?\",IF(AN28=\"DA\",IF(AI28=\"\",\"Neinformat\",NETWORKDAYS(AI28+AJ28,AE28+AF28,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C28=\"X\",IF(AN28=\"DA\",IF(AND(BI28>=5,AI28<>\"\"),LEN(TRIM(U28))-LEN(SUBSTITUTE(U28,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C28=\"X\",IF(AN28=\"DA\",LEN(TRIM(U28))-LEN(SUBSTITUTE(U28,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C28=\"X\",IF(AN28=\"\",\"Afectat sau NU?\",IF(AN28=\"DA\",((AG28+AH28)-(Z28+AA28))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C28=\"X\",IF(AN28<>\"DA\",\"-\",IF(AND(AN28=\"DA\",BL28<=0),LEN(TRIM(V28))-LEN(SUBSTITUTE(V28,CHAR(44),\"\"))+1+LEN(TRIM(U28))-LEN(SUBSTITUTE(U28,CHAR(44),\"\"))+1,0)),\"\")","v":"-"},{"$f":"IF(C28=\"X\",IF(AN28=\"DA\",LEN(TRIM(V28))-LEN(SUBSTITUTE(V28,CHAR(44),\"\"))+1+LEN(TRIM(U28))-LEN(SUBSTITUTE(U28,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"}]
[14,"-","x","Punere în siguranță a conductei 12” Agârbiciu - Sibiu, zona Șeica Mare",145676,"Șeica Mare","Sibiu",434864.28,502349.67,434864.28,502349.67,"-","-","SM0737D0","Șeica Mare","-","-","-","-","SM-SD001",null,"Delgaz Grid","iulie - septembrie 2021",null,null,null,null,"Mediaș",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2020_cap.A_2.1.B.10",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[15,"-","x","Refacere subtraversare râu Dâmbovița cu conducta Inel București, zona Bălăceanca",101760,"Cernica","Ilfov",602275.49,322657.23,602275.49,322657.23,"-","-","SM1133D0","Cernica II (Bălăceanca)","-","-","-","-","SM-SD001","Aderro GP, Nova Power, Cez Vânzare, Cis Gaz, Conef Gaz, Crest Energy, Distrigaz Vest, Engie, E.on Energie, Electrica Furnizare, Electric Planners, Electric&Gas, Energy Distribution, Enel Energie, Enel Muntenia, Gas&Power, Premier Energy Trading, Gaz Est, Gaz vest, Megaconstruct, Mehedinți Gaz, Met România, Monsson, Next Energy, Nord Gaz, Premier Energy, Petrom, Energy Gas Provider, Renovatio, Restart Energy, Tinmar, Transenergo, AIK Energy, Veolia, WIEE","Premier Energy","octombrie - decembrie 2020\nianuarie - martie 2021",null,null,null,null,"București",null,"Întârzieri în execuția forajului orizontal",null,null,null,null,null,null,null,null,null,null,null,"PMDI_2020_cap.A_2.1.B.13",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[16,"-","x","Conductă de transport gaze naturale 20” Plătărești - Bălăceanca",100629,"Oltenița","Călărași",632481.62,289201.63,632481.62,289201.63,"-","-","SM0962D0","Oltenita","-","-","-","-","SM-SD001",null,"Distrigaz Sud Rețele","iulie - septembrie 2021",null,null,null,null,"București",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2020_cap.A_2.1.B.14",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[17,"-","x","Conductă de transport gaze naturale 20” Plătărești - Bălăceanca",101813,"Chirnogi","Călărași",627947.05000000005,291419.55,627947.05000000005,291419.55,null,null,"SM1152D0","Chirnogi","-","-","-","-","SM-SD001",null,"Gazmir Iași","iulie - septembrie 2021",null,null,null,null,"București",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2020_cap.A_2.1.B.14",null,{"$f":"IF(B32=\"X\",IF(AN32=\"\",\"Afectat sau NU?\",IF(AN32=\"DA\",IF(((AK32+AL32)-(AE32+AF32))*24<-720,\"Neinformat\",((AK32+AL32)-(AE32+AF32))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B32=\"X\",IF(AN32=\"DA\",IF(AR32<6,LEN(TRIM(V32))-LEN(SUBSTITUTE(V32,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B32=\"X\",IF(AN32=\"DA\",LEN(TRIM(V32))-LEN(SUBSTITUTE(V32,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B32=\"X\",IF(AN32=\"\",\"Afectat sau NU?\",IF(AN32=\"DA\",IF(((AI32+AJ32)-(AE32+AF32))*24<-720,\"Neinformat\",((AI32+AJ32)-(AE32+AF32))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B32=\"X\",IF(AN32=\"DA\",IF(AU32<6,LEN(TRIM(U32))-LEN(SUBSTITUTE(U32,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B32=\"X\",IF(AN32=\"DA\",LEN(TRIM(U32))-LEN(SUBSTITUTE(U32,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B32=\"X\",IF(AN32=\"\",\"Afectat sau NU?\",IF(AN32=\"DA\",((AG32+AH32)-(AE32+AF32))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B32=\"X\",IF(AN32=\"DA\",IF(AX32>24,IF(BA32=\"NU\",0,LEN(TRIM(V32))-LEN(SUBSTITUTE(V32,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":""},{"$f":"IF(B32=\"X\",IF(AN32=\"DA\",IF(AX32>24,LEN(TRIM(V32))-LEN(SUBSTITUTE(V32,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(C32=\"X\",IF(AN32=\"\",\"Afectat sau NU?\",IF(AN32=\"DA\",IF(AK32=\"\",\"Neinformat\",NETWORKDAYS(AK32+AL32,AE32+AF32,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C32=\"X\",IF(AN32=\"DA\",IF(AND(BF32>=5,AK32<>\"\"),LEN(TRIM(V32))-LEN(SUBSTITUTE(V32,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C32=\"X\",IF(AN32=\"DA\",LEN(TRIM(V32))-LEN(SUBSTITUTE(V32,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C32=\"X\",IF(AN32=\"\",\"Afectat sau NU?\",IF(AN32=\"DA\",IF(AI32=\"\",\"Neinformat\",NETWORKDAYS(AI32+AJ32,AE32+AF32,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C32=\"X\",IF(AN32=\"DA\",IF(AND(BI32>=5,AI32<>\"\"),LEN(TRIM(U32))-LEN(SUBSTITUTE(U32,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C32=\"X\",IF(AN32=\"DA\",LEN(TRIM(U32))-LEN(SUBSTITUTE(U32,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C32=\"X\",IF(AN32=\"\",\"Afectat sau NU?\",IF(AN32=\"DA\",((AG32+AH32)-(Z32+AA32))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C32=\"X\",IF(AN32<>\"DA\",\"-\",IF(AND(AN32=\"DA\",BL32<=0),LEN(TRIM(V32))-LEN(SUBSTITUTE(V32,CHAR(44),\"\"))+1+LEN(TRIM(U32))-LEN(SUBSTITUTE(U32,CHAR(44),\"\"))+1,0)),\"\")","v":"-"},{"$f":"IF(C32=\"X\",IF(AN32=\"DA\",LEN(TRIM(V32))-LEN(SUBSTITUTE(V32,CHAR(44),\"\"))+1+LEN(TRIM(U32))-LEN(SUBSTITUTE(U32,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"}]
[18,"-","x","Conductă de transport gaze naturale 20” Plătărești - Bălăceanca",100647,"Mitreni","Călărași",628420.76,296597.06,628420.76,296597.06,null,null,"SM1234D0","Mitreni","-","-","-","-","SM-SD001",null,"Distrigaz Sud Rețele","iulie - septembrie 2021",null,null,null,null,"București",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2020_cap.A_2.1.B.14",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[19,"-","x","Conductă de transport gaze naturale Nadeș - Sighișoara",114596,"Hetiur","Mureș",481685.76000000001,529831.52,481685.76000000001,529831.52,null,null,"SM0834D0","Hetiur",null,null,null,null,"SM-SD001",null,"Delgaz Grid","iulie - septembrie 2021",null,null,null,null,"Brașov",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2020_cap.A_2.1.B.17",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[20,"-","x","Punere în siguranță a conductei 3” racord SRM Ucea de Jos și adaptare la teren SRM Ucea de Jos",42110,"Ucea de Jos","Braşov",474571.17,476371.61,474571.17,476371.61,"-","-","SM0811D0","Ucea de Jos","-","-","-","-","SM-SD001",null,"Distrigaz Sud Rețele","aprilie - iunie 2021",null,null,null,null,"Mediaș",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2020_cap.A_2.1.B.19",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[21,"-","x","Înlocuire tronson pe conducta de transport gaze naturale 8” racord SRM Poiana Brașov",42432,"Poiana Brașov","Braşov",543202.21,455663.91,543202.21,455663.91,"-","-","SM0054D0","Poiana Brașov","-","-","-","-","SM-SD001",null,"Distrigaz Sud Rețele","iulie - septembrie 2021",null,null,null,null,"Brașov",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2020_cap.A_2.1.B.22",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[22,"-","x","Înlocuire tronson pe conducta de transport gaze naturale 8” racord SRM Poiana Brașov",42432,"Poiana Brașov","Braşov",543067.84,456573.21,543067.84,456573.21,"-","-","SM1113D0","Poiana Sticlăriei","-","-","-","-","SM-SD001",null,"Distrigaz Sud Rețele","iulie - septembrie 2021",null,null,null,null,"Brașov",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2020_cap.A_2.1.B.22",null,{"$f":"IF(B37=\"X\",IF(AN37=\"\",\"Afectat sau NU?\",IF(AN37=\"DA\",IF(((AK37+AL37)-(AE37+AF37))*24<-720,\"Neinformat\",((AK37+AL37)-(AE37+AF37))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B37=\"X\",IF(AN37=\"DA\",IF(AR37<6,LEN(TRIM(V37))-LEN(SUBSTITUTE(V37,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B37=\"X\",IF(AN37=\"DA\",LEN(TRIM(V37))-LEN(SUBSTITUTE(V37,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B37=\"X\",IF(AN37=\"\",\"Afectat sau NU?\",IF(AN37=\"DA\",IF(((AI37+AJ37)-(AE37+AF37))*24<-720,\"Neinformat\",((AI37+AJ37)-(AE37+AF37))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B37=\"X\",IF(AN37=\"DA\",IF(AU37<6,LEN(TRIM(U37))-LEN(SUBSTITUTE(U37,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B37=\"X\",IF(AN37=\"DA\",LEN(TRIM(U37))-LEN(SUBSTITUTE(U37,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B37=\"X\",IF(AN37=\"\",\"Afectat sau NU?\",IF(AN37=\"DA\",((AG37+AH37)-(AE37+AF37))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B37=\"X\",IF(AN37=\"DA\",IF(AX37>24,IF(BA37=\"NU\",0,LEN(TRIM(V37))-LEN(SUBSTITUTE(V37,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":""},{"$f":"IF(B37=\"X\",IF(AN37=\"DA\",IF(AX37>24,LEN(TRIM(V37))-LEN(SUBSTITUTE(V37,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(C37=\"X\",IF(AN37=\"\",\"Afectat sau NU?\",IF(AN37=\"DA\",IF(AK37=\"\",\"Neinformat\",NETWORKDAYS(AK37+AL37,AE37+AF37,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C37=\"X\",IF(AN37=\"DA\",IF(AND(BF37>=5,AK37<>\"\"),LEN(TRIM(V37))-LEN(SUBSTITUTE(V37,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C37=\"X\",IF(AN37=\"DA\",LEN(TRIM(V37))-LEN(SUBSTITUTE(V37,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C37=\"X\",IF(AN37=\"\",\"Afectat sau NU?\",IF(AN37=\"DA\",IF(AI37=\"\",\"Neinformat\",NETWORKDAYS(AI37+AJ37,AE37+AF37,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C37=\"X\",IF(AN37=\"DA\",IF(AND(BI37>=5,AI37<>\"\"),LEN(TRIM(U37))-LEN(SUBSTITUTE(U37,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C37=\"X\",IF(AN37=\"DA\",LEN(TRIM(U37))-LEN(SUBSTITUTE(U37,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C37=\"X\",IF(AN37=\"\",\"Afectat sau NU?\",IF(AN37=\"DA\",((AG37+AH37)-(Z37+AA37))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C37=\"X\",IF(AN37<>\"DA\",\"-\",IF(AND(AN37=\"DA\",BL37<=0),LEN(TRIM(V37))-LEN(SUBSTITUTE(V37,CHAR(44),\"\"))+1+LEN(TRIM(U37))-LEN(SUBSTITUTE(U37,CHAR(44),\"\"))+1,0)),\"\")","v":"-"},{"$f":"IF(C37=\"X\",IF(AN37=\"DA\",LEN(TRIM(V37))-LEN(SUBSTITUTE(V37,CHAR(44),\"\"))+1+LEN(TRIM(U37))-LEN(SUBSTITUTE(U37,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"}]
[{"$f":"SUM(1,A37)","v":23},"-","x","Mărire capacitate SRM Uricani, județul Iași",95284,"Iași","Iași",688243.26,633571.56000000006,688243.26,633571.56000000006,"-","-","SM0480D2","Uricani","-","-","-","-","SM-SD001",null,"Delgaz Grid","iulie - septembrie 2021",null,null,null,null,"Bacău",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2020_cap.C_5",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[{"$f":"SUM(1,A38)","v":24},"-","x","Racord și SRM Lețcani, județul Iași",97688,"Lețcani","Iași",682858.38,636181.85,682858.38,636181.85,"-","-","SM0886D0","Lețcani","-","-","-","-","SM-SD001",null,"Delgaz Grid","aprilie - iunie 2021",null,null,null,null,"Bacău",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2020_cap.C_16",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[25,"-","x","SRM Clinceni - Eficientizarea sistemului de măsură prin completarea instalației tehnologice cu elemente/echipamente corespunzătoare",102044,"Clinceni","Ilfov",574454.57999999996,318647.90000000002,574454.57999999996,318647.90000000002,"-","-","SM0249D1","Clinceni","-","-","-","-","SM-SD001","Aderro GP, AIK Londra, Alpha Metal, Nova Power, Cez Vânzare, Cis Gaz, Conef Gaz, Crest Energy, Cyeb, Distrigaz Vest, Engie, E.On Energie, Electrocentrale București, Electrocentrale Constanța, Electrica Furnizare, Electric Planners, Electric&Gas, Energy Distribution, Enel Energie, Enel Muntenia, Gas&Power, Entrex, Euro Seven Industry, Premier Energy Trading, Gaz Est, Hargaz, Gaz Vest, Megaconstruct, Met România, Monsson, Next Energy Distribution, Nord Gaz, Oligopol, Premier Energy, Petrom, Progaz, Energy Gas Provider, Renovatio, Restart Energy, Romgaz, RWE Supply, Tinmar, Transenergo, AIK România, Veolia, WIEE","Distrigaz Sud Rețele","octombrie - decembrie 2020\nianuarie - aprilie 2021",null,null,null,null,"București",null,"Întârzieri în execuție",null,null,null,null,null,null,null,null,null,null,null,"PMDI_2020_1_Anexa_3",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[26,"-","x","SRM Clinceni - Eficientizarea sistemului de măsură prin completarea instalației tehnologice cu elemente/echipamente corespunzătoare",102222,"Clinceni","Ilfov",574454.57999999996,318647.90000000002,574454.57999999996,318647.90000000002,"-","-","SM0249D2","Cornetu","-","-","-","-","SM-SD001","Aderro GP, Nova Power, Cez Vânzare, Cis Gaz, Conef Gaz, Crest Energy, Distrigaz Vest, Engie, E.on Energie, Electrica Furnizare, Electric Planners, Electric&Gas, Energy Distribution, Enel Energie, Enel Muntenia, Gas&Power, Premier Energy Trading, Gaz Est, Gaz vest, Megaconstruct, Mehedinți Gaz, Met România, Monsson, Next Energy, Nord Gaz, Premier Energy, Petrom, Energy Gas Provider, Renovatio, Restart Energy, Tinmar, Transenergo, AIK Energy, Veolia, WIEE","Premier Energy","octombrie - decembrie 2020\nianuarie - aprilie 2021",null,null,null,null,"București",null,"Întârzieri în execuție",null,null,null,null,null,null,null,null,null,null,null,"PMDI_2020_1_Anexa_3",null,{"$f":"IF(B41=\"X\",IF(AN41=\"\",\"Afectat sau NU?\",IF(AN41=\"DA\",IF(((AK41+AL41)-(AE41+AF41))*24<-720,\"Neinformat\",((AK41+AL41)-(AE41+AF41))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B41=\"X\",IF(AN41=\"DA\",IF(AR41<6,LEN(TRIM(V41))-LEN(SUBSTITUTE(V41,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B41=\"X\",IF(AN41=\"DA\",LEN(TRIM(V41))-LEN(SUBSTITUTE(V41,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B41=\"X\",IF(AN41=\"\",\"Afectat sau NU?\",IF(AN41=\"DA\",IF(((AI41+AJ41)-(AE41+AF41))*24<-720,\"Neinformat\",((AI41+AJ41)-(AE41+AF41))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B41=\"X\",IF(AN41=\"DA\",IF(AU41<6,LEN(TRIM(U41))-LEN(SUBSTITUTE(U41,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B41=\"X\",IF(AN41=\"DA\",LEN(TRIM(U41))-LEN(SUBSTITUTE(U41,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B41=\"X\",IF(AN41=\"\",\"Afectat sau NU?\",IF(AN41=\"DA\",((AG41+AH41)-(AE41+AF41))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B41=\"X\",IF(AN41=\"DA\",IF(AX41>24,IF(BA41=\"NU\",0,LEN(TRIM(V41))-LEN(SUBSTITUTE(V41,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":""},{"$f":"IF(B41=\"X\",IF(AN41=\"DA\",IF(AX41>24,LEN(TRIM(V41))-LEN(SUBSTITUTE(V41,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(C41=\"X\",IF(AN41=\"\",\"Afectat sau NU?\",IF(AN41=\"DA\",IF(AK41=\"\",\"Neinformat\",NETWORKDAYS(AK41+AL41,AE41+AF41,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C41=\"X\",IF(AN41=\"DA\",IF(AND(BF41>=5,AK41<>\"\"),LEN(TRIM(V41))-LEN(SUBSTITUTE(V41,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C41=\"X\",IF(AN41=\"DA\",LEN(TRIM(V41))-LEN(SUBSTITUTE(V41,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C41=\"X\",IF(AN41=\"\",\"Afectat sau NU?\",IF(AN41=\"DA\",IF(AI41=\"\",\"Neinformat\",NETWORKDAYS(AI41+AJ41,AE41+AF41,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C41=\"X\",IF(AN41=\"DA\",IF(AND(BI41>=5,AI41<>\"\"),LEN(TRIM(U41))-LEN(SUBSTITUTE(U41,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C41=\"X\",IF(AN41=\"DA\",LEN(TRIM(U41))-LEN(SUBSTITUTE(U41,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C41=\"X\",IF(AN41=\"\",\"Afectat sau NU?\",IF(AN41=\"DA\",((AG41+AH41)-(Z41+AA41))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C41=\"X\",IF(AN41<>\"DA\",\"-\",IF(AND(AN41=\"DA\",BL41<=0),LEN(TRIM(V41))-LEN(SUBSTITUTE(V41,CHAR(44),\"\"))+1+LEN(TRIM(U41))-LEN(SUBSTITUTE(U41,CHAR(44),\"\"))+1,0)),\"\")","v":"-"},{"$f":"IF(C41=\"X\",IF(AN41=\"DA\",LEN(TRIM(V41))-LEN(SUBSTITUTE(V41,CHAR(44),\"\"))+1+LEN(TRIM(U41))-LEN(SUBSTITUTE(U41,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"}]
[27,"-","x","SRM Clinceni - Eficientizarea sistemului de măsură prin completarea instalației tehnologice cu elemente/echipamente corespunzătoare",102044,"Clinceni","Ilfov",574454.57999999996,318647.90000000002,574454.57999999996,318647.90000000002,"-","-","SM0249D3","Clinceni Aeroport","-","-","-","-","SM-SD001","Aderro GP, Nova Power, Cez Vânzare, Cis Gaz, Conef Gaz, Crest Energy, Distrigaz Vest, Engie, E.on Energie, Electrica Furnizare, Electric Planners, Electric&Gas, Energy Distribution, Enel Energie, Enel Muntenia, Gas&Power, Premier Energy Trading, Gaz Est, Gaz vest, Megaconstruct, Mehedinți Gaz, Met România, Monsson, Next Energy, Nord Gaz, Premier Energy, Petrom, Energy Gas Provider, Renovatio, Restart Energy, Tinmar, Transenergo, AIK Energy, Veolia, WIEE","Premier Energy","octombrie - decembrie 2020\nianuarie - aprilie 2021",null,null,null,null,"București",null,"Întârzieri în execuție",null,null,null,null,null,null,null,null,null,null,null,"PMDI_2020_1_Anexa_3",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[28,"-","x","Punere în siguranță a conductei 8” Cornățel - Avrig, zona Avrig",144090,"Mârșa","Sibiu",451489.67,466968.99,451489.67,466968.99,"-","-","SM0819D1","Mârșa","-","-","-","-","SM-SD001",null,"Delgaz Grid","iulie - septembrie 2021",null,null,null,null,"Mediaș",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2020_3_Anexa_7",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[29,"-","x","Punere în siguranță a conductei 8” Cornățel - Avrig, zona Avrig",145364,"Racovița","Sibiu",448491.14,465243.62,448491.14,465243.62,"-","-","SM0876D0","Racovița","-","-","-","-","SM-SD001",null,"Delgaz Grid","iulie - septembrie 2021",null,null,null,null,"Mediaș",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2020_3_Anexa_7",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[30,"-","x","Punere în siguranță a conductei 8” Cornățel - Avrig, zona Avrig",145373,"Sebeșu de Sus","Sibiu",449528.49,462452.81,449528.49,462452.81,"-","-","SM0903D0","Sebeșu de Sus","-","-","-","-","SM-SD001",null,"Delgaz Grid","iulie - septembrie 2021",null,null,null,null,"Mediaș",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2020_3_Anexa_7",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[31,"-","x","Punere în siguranță a conductei 8” Cornățel - Avrig, zona Avrig",145952,"Sebeșu de Jos","Sibiu",448296.46,461833.47,448296.46,461833.47,"-","-","SM1041D0","Sebeșu de Jos","-","-","-","-","SM-SD001",null,"Delgaz Grid","iulie - septembrie 2021",null,null,null,null,"Mediaș",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2020_3_Anexa_7",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[32,"-","x","Punere în siguranță a conductei 8” Cornățel - Avrig, zona Avrig",145943,"Turnu Roșu","Sibiu",445948.45,460774.96,445948.45,460774.96,"-","-","SM0805D0","Turnu Roșu","-","-","-","-","SM-SD001",null,"Delgaz Grid","iulie - septembrie 2021",null,null,null,null,"Mediaș",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2020_3_Anexa_7",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[33,"-","x","Punere în siguranță a conductei 12\" Vlădeni - Mănești, zona Vlădeni",67256,"Vlădeni","Dâmbovița",561573.52,374102.03,561573.52,374102.03,"-","-","SM0137D0","Vlădeni","-","-","-","-","SM-SD001","Aderro GP, Alpha Metal, Nova Power, Cez Vânzare, Cis Gaz, Conef Gaz, Crest Energy, Cyeb, Distrigaz Vest, Engie, E.On Energie, Electrocentrale București, Electrocentrale Constanța, Electrica Furnizare, Electric Planners, Electric&Gas, Energy Distribution, Enel, Enel Muntenia, Gas&Power, Entrex, Euro Seven Industry, Premier Energy Trading, Gaz Est, Hargaz, Megaconstruct, Met România, Monsson, Next Energy, Nord Gaz, Oligopol, Premier Energy, Petrom, Progaz, Energy Gas Provider, Renovatio, Restart Energy, Romgaz, RWE Supply, Tinmar, Transenergo, AIK România, Veolia, WIEE","Distrigaz Sud Rețele","octombrie 2020\n18-31 decembrie 2020\nfebruarie - martie 2021",null,null,null,null,"București",null,"Întârzieri în aprovizionarea cu materialele necesare\nCarantinarea unor zone care implică accesul restricționat al personalului implicat",null,null,null,null,null,null,null,null,null,null,null,"PRRASM_2020_IA7_Anexa_1",null,{"$f":"IF(B48=\"X\",IF(AN48=\"\",\"Afectat sau NU?\",IF(AN48=\"DA\",IF(((AK48+AL48)-(AE48+AF48))*24<-720,\"Neinformat\",((AK48+AL48)-(AE48+AF48))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B48=\"X\",IF(AN48=\"DA\",IF(AR48<6,LEN(TRIM(V48))-LEN(SUBSTITUTE(V48,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B48=\"X\",IF(AN48=\"DA\",LEN(TRIM(V48))-LEN(SUBSTITUTE(V48,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B48=\"X\",IF(AN48=\"\",\"Afectat sau NU?\",IF(AN48=\"DA\",IF(((AI48+AJ48)-(AE48+AF48))*24<-720,\"Neinformat\",((AI48+AJ48)-(AE48+AF48))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B48=\"X\",IF(AN48=\"DA\",IF(AU48<6,LEN(TRIM(U48))-LEN(SUBSTITUTE(U48,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B48=\"X\",IF(AN48=\"DA\",LEN(TRIM(U48))-LEN(SUBSTITUTE(U48,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B48=\"X\",IF(AN48=\"\",\"Afectat sau NU?\",IF(AN48=\"DA\",((AG48+AH48)-(AE48+AF48))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B48=\"X\",IF(AN48=\"DA\",IF(AX48>24,IF(BA48=\"NU\",0,LEN(TRIM(V48))-LEN(SUBSTITUTE(V48,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":""},{"$f":"IF(B48=\"X\",IF(AN48=\"DA\",IF(AX48>24,LEN(TRIM(V48))-LEN(SUBSTITUTE(V48,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(C48=\"X\",IF(AN48=\"\",\"Afectat sau NU?\",IF(AN48=\"DA\",IF(AK48=\"\",\"Neinformat\",NETWORKDAYS(AK48+AL48,AE48+AF48,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C48=\"X\",IF(AN48=\"DA\",IF(AND(BF48>=5,AK48<>\"\"),LEN(TRIM(V48))-LEN(SUBSTITUTE(V48,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C48=\"X\",IF(AN48=\"DA\",LEN(TRIM(V48))-LEN(SUBSTITUTE(V48,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C48=\"X\",IF(AN48=\"\",\"Afectat sau NU?\",IF(AN48=\"DA\",IF(AI48=\"\",\"Neinformat\",NETWORKDAYS(AI48+AJ48,AE48+AF48,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C48=\"X\",IF(AN48=\"DA\",IF(AND(BI48>=5,AI48<>\"\"),LEN(TRIM(U48))-LEN(SUBSTITUTE(U48,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C48=\"X\",IF(AN48=\"DA\",LEN(TRIM(U48))-LEN(SUBSTITUTE(U48,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C48=\"X\",IF(AN48=\"\",\"Afectat sau NU?\",IF(AN48=\"DA\",((AG48+AH48)-(Z48+AA48))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C48=\"X\",IF(AN48<>\"DA\",\"-\",IF(AND(AN48=\"DA\",BL48<=0),LEN(TRIM(V48))-LEN(SUBSTITUTE(V48,CHAR(44),\"\"))+1+LEN(TRIM(U48))-LEN(SUBSTITUTE(U48,CHAR(44),\"\"))+1,0)),\"\")","v":"-"},{"$f":"IF(C48=\"X\",IF(AN48=\"DA\",LEN(TRIM(V48))-LEN(SUBSTITUTE(V48,CHAR(44),\"\"))+1+LEN(TRIM(U48))-LEN(SUBSTITUTE(U48,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"}]
[34,"-","x","Punere în siguranță a conductei 12\" Vlădeni - Mănești, zona Vlădeni",134238,"Coada Izvorului","Prahova",566412.39,374268.11,566412.39,374268.11,"-","-","SM0033D0","Coada Izvorului","-","-","-","-","SM-SD001","Aderro GP, Alpha Metal, Nova Power, Cez Vânzare, Cis Gaz, Conef Gaz, Crest Energy, Cyeb, Distrigaz Vest, Engie, E.On Energie, Electrocentrale București, Electrocentrale Constanța, Electrica Furnizare, Electric Planners, Electric&Gas, Energy Distribution, Enel, Enel Muntenia, Gas&Power, Entrex, Euro Seven Industry, Premier Energy Trading, Gaz Est, Hargaz, Megaconstruct, Met România, Monsson, Next Energy, Nord Gaz, Oligopol, Premier Energy, Petrom, Progaz, Energy Gas Provider, Renovatio, Restart Energy, Romgaz, RWE Supply, Tinmar, Transenergo, AIK România, Veolia, WIEE","Distrigaz Sud Rețele","octombrie 2020\n18-31 decembrie 2020\nfebruarie - martie 2021",null,null,null,null,"București",null,"Întârzieri în aprovizionarea cu materialele necesare\nCarantinarea unor zone care implică accesul restricționat al personalului implicat",null,null,null,null,null,null,null,null,null,null,null,"PRRASM_2020_IA7_Anexa_1",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[35,"-","x","Punere în siguranță a conductei 12\" Vlădeni - Mănești, zona Vlădeni",67265,"Vlădeni","Dâmbovița",561822.71999999997,373131.93,561822.71999999997,373131.93,"-","-","-","-","-","-","PM0014","Vlădeni","PM-PP001","Romgaz, Amromco","Romgaz, Amromco","octombrie 2020\n18-31 decembrie 2020\nfebruarie - martie 2021",null,null,null,null,"București",null,"Întârzieri în aprovizionarea cu materialele necesare\nCarantinarea unor zone care implică accesul restricționat al personalului implicat",null,null,null,null,null,null,null,null,null,null,null,"PRRASM_2020_IA7_Anexa_1",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[36,"-","X","Înlocuire robineți la SRM Avrig",144063,"Avrig","Sibiu",453138.85,469627.97,453138.85,469627.97,"-","-","SM0802D1","Avrig","-","-","-","-","SM-SD001",null,"Delgaz Grid","mai 2021",null,null,null,null,"Mediaș",null,null,null,null,null,null,null,null,null,null,null,null,null,"Forțe proprii",null,{"$f":"IF(B51=\"X\",IF(AN51=\"\",\"Afectat sau NU?\",IF(AN51=\"DA\",IF(((AK51+AL51)-(AE51+AF51))*24<-720,\"Neinformat\",((AK51+AL51)-(AE51+AF51))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B51=\"X\",IF(AN51=\"DA\",IF(AR51<6,LEN(TRIM(V51))-LEN(SUBSTITUTE(V51,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B51=\"X\",IF(AN51=\"DA\",LEN(TRIM(V51))-LEN(SUBSTITUTE(V51,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B51=\"X\",IF(AN51=\"\",\"Afectat sau NU?\",IF(AN51=\"DA\",IF(((AI51+AJ51)-(AE51+AF51))*24<-720,\"Neinformat\",((AI51+AJ51)-(AE51+AF51))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B51=\"X\",IF(AN51=\"DA\",IF(AU51<6,LEN(TRIM(U51))-LEN(SUBSTITUTE(U51,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B51=\"X\",IF(AN51=\"DA\",LEN(TRIM(U51))-LEN(SUBSTITUTE(U51,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B51=\"X\",IF(AN51=\"\",\"Afectat sau NU?\",IF(AN51=\"DA\",((AG51+AH51)-(AE51+AF51))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B51=\"X\",IF(AN51=\"DA\",IF(AX51>24,IF(BA51=\"NU\",0,LEN(TRIM(V51))-LEN(SUBSTITUTE(V51,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":""},{"$f":"IF(B51=\"X\",IF(AN51=\"DA\",IF(AX51>24,LEN(TRIM(V51))-LEN(SUBSTITUTE(V51,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(C51=\"X\",IF(AN51=\"\",\"Afectat sau NU?\",IF(AN51=\"DA\",IF(AK51=\"\",\"Neinformat\",NETWORKDAYS(AK51+AL51,AE51+AF51,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C51=\"X\",IF(AN51=\"DA\",IF(AND(BF51>=5,AK51<>\"\"),LEN(TRIM(V51))-LEN(SUBSTITUTE(V51,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C51=\"X\",IF(AN51=\"DA\",LEN(TRIM(V51))-LEN(SUBSTITUTE(V51,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C51=\"X\",IF(AN51=\"\",\"Afectat sau NU?\",IF(AN51=\"DA\",IF(AI51=\"\",\"Neinformat\",NETWORKDAYS(AI51+AJ51,AE51+AF51,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C51=\"X\",IF(AN51=\"DA\",IF(AND(BI51>=5,AI51<>\"\"),LEN(TRIM(U51))-LEN(SUBSTITUTE(U51,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C51=\"X\",IF(AN51=\"DA\",LEN(TRIM(U51))-LEN(SUBSTITUTE(U51,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C51=\"X\",IF(AN51=\"\",\"Afectat sau NU?\",IF(AN51=\"DA\",((AG51+AH51)-(Z51+AA51))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C51=\"X\",IF(AN51<>\"DA\",\"-\",IF(AND(AN51=\"DA\",BL51<=0),LEN(TRIM(V51))-LEN(SUBSTITUTE(V51,CHAR(44),\"\"))+1+LEN(TRIM(U51))-LEN(SUBSTITUTE(U51,CHAR(44),\"\"))+1,0)),\"\")","v":"-"},{"$f":"IF(C51=\"X\",IF(AN51=\"DA\",LEN(TRIM(V51))-LEN(SUBSTITUTE(V51,CHAR(44),\"\"))+1+LEN(TRIM(U51))-LEN(SUBSTITUTE(U51,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"}]
[37,"-","X","Înlocuire robineți la SRM Mârșa",144090,"Mârșa","Sibiu",451489.67,466968.99,451489.67,466968.99,"-","-","SM0819D1","Mârșa","-","-","-","-","SM-SD001",null,"Delgaz Grid","mai 2021",null,null,null,null,"Mediaș",null,null,null,null,null,null,null,null,null,null,null,null,null,"Forțe proprii",null,{"$f":"IF(B52=\"X\",IF(AN52=\"\",\"Afectat sau NU?\",IF(AN52=\"DA\",IF(((AK52+AL52)-(AE52+AF52))*24<-720,\"Neinformat\",((AK52+AL52)-(AE52+AF52))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B52=\"X\",IF(AN52=\"DA\",IF(AR52<6,LEN(TRIM(V52))-LEN(SUBSTITUTE(V52,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B52=\"X\",IF(AN52=\"DA\",LEN(TRIM(V52))-LEN(SUBSTITUTE(V52,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B52=\"X\",IF(AN52=\"\",\"Afectat sau NU?\",IF(AN52=\"DA\",IF(((AI52+AJ52)-(AE52+AF52))*24<-720,\"Neinformat\",((AI52+AJ52)-(AE52+AF52))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B52=\"X\",IF(AN52=\"DA\",IF(AU52<6,LEN(TRIM(U52))-LEN(SUBSTITUTE(U52,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B52=\"X\",IF(AN52=\"DA\",LEN(TRIM(U52))-LEN(SUBSTITUTE(U52,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B52=\"X\",IF(AN52=\"\",\"Afectat sau NU?\",IF(AN52=\"DA\",((AG52+AH52)-(AE52+AF52))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B52=\"X\",IF(AN52=\"DA\",IF(AX52>24,IF(BA52=\"NU\",0,LEN(TRIM(V52))-LEN(SUBSTITUTE(V52,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":""},{"$f":"IF(B52=\"X\",IF(AN52=\"DA\",IF(AX52>24,LEN(TRIM(V52))-LEN(SUBSTITUTE(V52,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(C52=\"X\",IF(AN52=\"\",\"Afectat sau NU?\",IF(AN52=\"DA\",IF(AK52=\"\",\"Neinformat\",NETWORKDAYS(AK52+AL52,AE52+AF52,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C52=\"X\",IF(AN52=\"DA\",IF(AND(BF52>=5,AK52<>\"\"),LEN(TRIM(V52))-LEN(SUBSTITUTE(V52,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C52=\"X\",IF(AN52=\"DA\",LEN(TRIM(V52))-LEN(SUBSTITUTE(V52,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C52=\"X\",IF(AN52=\"\",\"Afectat sau NU?\",IF(AN52=\"DA\",IF(AI52=\"\",\"Neinformat\",NETWORKDAYS(AI52+AJ52,AE52+AF52,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C52=\"X\",IF(AN52=\"DA\",IF(AND(BI52>=5,AI52<>\"\"),LEN(TRIM(U52))-LEN(SUBSTITUTE(U52,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C52=\"X\",IF(AN52=\"DA\",LEN(TRIM(U52))-LEN(SUBSTITUTE(U52,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C52=\"X\",IF(AN52=\"\",\"Afectat sau NU?\",IF(AN52=\"DA\",((AG52+AH52)-(Z52+AA52))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C52=\"X\",IF(AN52<>\"DA\",\"-\",IF(AND(AN52=\"DA\",BL52<=0),LEN(TRIM(V52))-LEN(SUBSTITUTE(V52,CHAR(44),\"\"))+1+LEN(TRIM(U52))-LEN(SUBSTITUTE(U52,CHAR(44),\"\"))+1,0)),\"\")","v":"-"},{"$f":"IF(C52=\"X\",IF(AN52=\"DA\",LEN(TRIM(V52))-LEN(SUBSTITUTE(V52,CHAR(44),\"\"))+1+LEN(TRIM(U52))-LEN(SUBSTITUTE(U52,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"}]
[38,"-","X","Înlocuire robineță la SRM Rusciori",145818,"Rusciori","Sibiu",425238.47,479734.58,425238.47,479734.58,"-","-","SM0761D0","Rusciori","-","-","-","-","SM-SD001",null,"Delgaz Grid","iunie 2021",null,null,null,null,"Mediaș",null,null,null,null,null,null,null,null,null,null,null,null,null,"Forțe proprii",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[39,"-","X","Înlocuire robineți la SRM Ocna Sibiului",143860,"Ocna Sibiului","Sibiu",427912.33,486555.98,427912.33,486555.98,"-","-","SM0723D0","Ocna Sibiului","-","-","-","-","SM-SD001",null,"Delgaz Grid","iunie 2021",null,null,null,null,"Mediaș",null,null,null,null,null,null,null,null,null,null,null,null,null,"Forțe proprii",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[40,"-","X","Înlocuire robineți la SRM Șura Mare",145774,"Șura Mare","Sibiu",434542.96,483711.13,434542.96,483711.13,"-","-","SM0742D0","Șura Mare","-","-","-","-","SM-SD001",null,"Delgaz Grid","iulie 2021",null,null,null,null,"Mediaș",null,null,null,null,null,null,null,null,null,null,null,null,null,"Forțe proprii",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[41,"-","X","Înlocuire robineți la SRM Hosman",145186,"Hosman","Sibiu",455162.02,482490.4,455162.02,482490.4,"-","-","SM0791D0","Hosman","-","-","-","-","SM-SD001",null,"Delgaz Grid","august 2021",null,null,null,null,"Mediaș",null,null,null,null,null,null,null,null,null,null,null,null,null,"Forțe proprii",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[42,"-","X","Înlocuire robineți la SRM Ilimbav",144919,"Ilimbav","Sibiu",462643.39,486014.37,462643.39,486014.37,"-","-","SM0792D0","Ilimbav","-","-","-","-","SM-SD001",null,"Delgaz Grid","august 2021",null,null,null,null,"Mediaș",null,null,null,null,null,null,null,null,null,null,null,null,null,"Forțe proprii",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[43,"-","X","Înlocuire robineți la SRM Vârd",144483,"Vârd","Sibiu",468618.46,494023.26,468618.46,494023.26,"-","-","SM0789D0","Vârd","-","-","-","-","SM-SD001",null,"Delgaz Grid","septembrie 2021",null,null,null,null,"Mediaș",null,null,null,null,null,null,null,null,null,null,null,null,null,"Forțe proprii",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[44,"-","X","Înlocuire robineți la SRM Racovița",145364,"Racovița","Sibiu",448491.14,465243.62,448491.14,465243.62,"-","-","SM0876D0","Racovița","-","-","-","-","SM-SD001",null,"Delgaz Grid","septembrie 2021",null,null,null,null,"Mediaș",null,null,null,null,null,null,null,null,null,null,null,null,null,"Forțe proprii",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[45,"-","X","Montare îmbinare electroizolantă pe conducta 3\" racord SRM Vad",41845,"Vad","Brașov",511691.09,477821.71,511691.09,477821.71,"-","-","SM0021D0","Vad","-","-","-","-","SM-SD001",null,"Distrigaz Sud Rețele","mai 2021",null,null,null,null,"Mediaș",null,null,null,null,null,null,null,null,null,null,null,null,null,"Forțe proprii",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[46,"-","X","Lucrări privind sistematizarea și creșterea siguranței în funcționare a infrastructurii SNT  din zona NT Rodbav - SRM Făgăraș.",40571,"Calbor","Brașov",492123.16,486057.15,492123.16,486057.15,"-","-","SM0769D0","SRM Calbor","-","-","-","-","SM-SD001",null,"Distrigaz Sud Rețele","iulie 2021",null,null,null,null,"Mediaș",null,null,null,null,null,null,null,null,null,null,null,null,null,"Sucursala_2020_A_24",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[47,"-","X","Relocare instalație mecanică veche de la Aricești II la Stăncești (înlocuire SRM Stăncești)",130892,"Ploiești","Prahova",571593.42000000004,373696.77,571593.42000000004,373696.77,"-","-","SM0140D0","Stâncești","-","-","-","-","SM-SD001","Aderro GP, Alpha Metal, Nova Power, Cez Vânzare, Cis Gaz, Conef Gaz, Crest Energy, Cyeb, Distrigaz Vest, Engie, E.On Energie, Electrocentrale București, Electrocentrale Constanța, Electrica Furnizare, Electric Planners, Electric&Gas, Energy Distribution, Enel, Enel Muntenia, Gas&Power, Entrex, Euro Seven Industry, Premier Energy Trading, Gaz Est, Hargaz, Megaconstruct, Met România, Monsson, Next Energy, Nord Gaz, Oligopol, Premier Energy, Petrom, Progaz, Energy Gas Provider, Renovatio, Restart Energy, Romgaz, RWE Supply, Tinmar, Transenergo, AIK România, Veolia, WIEE","Distrigaz Sud Rețele","03 - 31 octombrie 2020\n18 decembrie 2020 - martie 2021",null,null,null,null,"București",null,"Întârzieri în aprovizionarea cu materialele necesare",null,null,null,null,null,null,null,null,null,null,null,"Forțe proprii",null,{"$f":"IF(B62=\"X\",IF(AN62=\"\",\"Afectat sau NU?\",IF(AN62=\"DA\",IF(((AK62+AL62)-(AE62+AF62))*24<-720,\"Neinformat\",((AK62+AL62)-(AE62+AF62))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B62=\"X\",IF(AN62=\"DA\",IF(AR62<6,LEN(TRIM(V62))-LEN(SUBSTITUTE(V62,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B62=\"X\",IF(AN62=\"DA\",LEN(TRIM(V62))-LEN(SUBSTITUTE(V62,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B62=\"X\",IF(AN62=\"\",\"Afectat sau NU?\",IF(AN62=\"DA\",IF(((AI62+AJ62)-(AE62+AF62))*24<-720,\"Neinformat\",((AI62+AJ62)-(AE62+AF62))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B62=\"X\",IF(AN62=\"DA\",IF(AU62<6,LEN(TRIM(U62))-LEN(SUBSTITUTE(U62,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B62=\"X\",IF(AN62=\"DA\",LEN(TRIM(U62))-LEN(SUBSTITUTE(U62,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B62=\"X\",IF(AN62=\"\",\"Afectat sau NU?\",IF(AN62=\"DA\",((AG62+AH62)-(AE62+AF62))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B62=\"X\",IF(AN62=\"DA\",IF(AX62>24,IF(BA62=\"NU\",0,LEN(TRIM(V62))-LEN(SUBSTITUTE(V62,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":""},{"$f":"IF(B62=\"X\",IF(AN62=\"DA\",IF(AX62>24,LEN(TRIM(V62))-LEN(SUBSTITUTE(V62,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(C62=\"X\",IF(AN62=\"\",\"Afectat sau NU?\",IF(AN62=\"DA\",IF(AK62=\"\",\"Neinformat\",NETWORKDAYS(AK62+AL62,AE62+AF62,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C62=\"X\",IF(AN62=\"DA\",IF(AND(BF62>=5,AK62<>\"\"),LEN(TRIM(V62))-LEN(SUBSTITUTE(V62,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C62=\"X\",IF(AN62=\"DA\",LEN(TRIM(V62))-LEN(SUBSTITUTE(V62,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C62=\"X\",IF(AN62=\"\",\"Afectat sau NU?\",IF(AN62=\"DA\",IF(AI62=\"\",\"Neinformat\",NETWORKDAYS(AI62+AJ62,AE62+AF62,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C62=\"X\",IF(AN62=\"DA\",IF(AND(BI62>=5,AI62<>\"\"),LEN(TRIM(U62))-LEN(SUBSTITUTE(U62,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C62=\"X\",IF(AN62=\"DA\",LEN(TRIM(U62))-LEN(SUBSTITUTE(U62,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C62=\"X\",IF(AN62=\"\",\"Afectat sau NU?\",IF(AN62=\"DA\",((AG62+AH62)-(Z62+AA62))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C62=\"X\",IF(AN62<>\"DA\",\"-\",IF(AND(AN62=\"DA\",BL62<=0),LEN(TRIM(V62))-LEN(SUBSTITUTE(V62,CHAR(44),\"\"))+1+LEN(TRIM(U62))-LEN(SUBSTITUTE(U62,CHAR(44),\"\"))+1,0)),\"\")","v":"-"},{"$f":"IF(C62=\"X\",IF(AN62=\"DA\",LEN(TRIM(V62))-LEN(SUBSTITUTE(V62,CHAR(44),\"\"))+1+LEN(TRIM(U62))-LEN(SUBSTITUTE(U62,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"}]
[48,"-","X","Modernizare NT Schitu Goleşti - montare gară godevil",18689,"Schitu Golești","Argeș",499964.40600000002,409075.77299999999,499964.40600000002,409075.77299999999,"-","-","SM1089D0","Schitu Golești","-","-","-","-","SM-SD001",null,"SC Distrigaz Sud Rețele","iulie - septembrie 2021",null,null,null,null,"Craiova",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI 2020_8 (Anexa 1)",null,{"$f":"IF(B63=\"X\",IF(AN63=\"\",\"Afectat sau NU?\",IF(AN63=\"DA\",IF(((AK63+AL63)-(AE63+AF63))*24<-720,\"Neinformat\",((AK63+AL63)-(AE63+AF63))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B63=\"X\",IF(AN63=\"DA\",IF(AR63<6,LEN(TRIM(V63))-LEN(SUBSTITUTE(V63,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B63=\"X\",IF(AN63=\"DA\",LEN(TRIM(V63))-LEN(SUBSTITUTE(V63,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B63=\"X\",IF(AN63=\"\",\"Afectat sau NU?\",IF(AN63=\"DA\",IF(((AI63+AJ63)-(AE63+AF63))*24<-720,\"Neinformat\",((AI63+AJ63)-(AE63+AF63))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B63=\"X\",IF(AN63=\"DA\",IF(AU63<6,LEN(TRIM(U63))-LEN(SUBSTITUTE(U63,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B63=\"X\",IF(AN63=\"DA\",LEN(TRIM(U63))-LEN(SUBSTITUTE(U63,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B63=\"X\",IF(AN63=\"\",\"Afectat sau NU?\",IF(AN63=\"DA\",((AG63+AH63)-(AE63+AF63))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B63=\"X\",IF(AN63=\"DA\",IF(AX63>24,IF(BA63=\"NU\",0,LEN(TRIM(V63))-LEN(SUBSTITUTE(V63,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":""},{"$f":"IF(B63=\"X\",IF(AN63=\"DA\",IF(AX63>24,LEN(TRIM(V63))-LEN(SUBSTITUTE(V63,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(C63=\"X\",IF(AN63=\"\",\"Afectat sau NU?\",IF(AN63=\"DA\",IF(AK63=\"\",\"Neinformat\",NETWORKDAYS(AK63+AL63,AE63+AF63,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C63=\"X\",IF(AN63=\"DA\",IF(AND(BF63>=5,AK63<>\"\"),LEN(TRIM(V63))-LEN(SUBSTITUTE(V63,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C63=\"X\",IF(AN63=\"DA\",LEN(TRIM(V63))-LEN(SUBSTITUTE(V63,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C63=\"X\",IF(AN63=\"\",\"Afectat sau NU?\",IF(AN63=\"DA\",IF(AI63=\"\",\"Neinformat\",NETWORKDAYS(AI63+AJ63,AE63+AF63,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C63=\"X\",IF(AN63=\"DA\",IF(AND(BI63>=5,AI63<>\"\"),LEN(TRIM(U63))-LEN(SUBSTITUTE(U63,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C63=\"X\",IF(AN63=\"DA\",LEN(TRIM(U63))-LEN(SUBSTITUTE(U63,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C63=\"X\",IF(AN63=\"\",\"Afectat sau NU?\",IF(AN63=\"DA\",((AG63+AH63)-(Z63+AA63))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C63=\"X\",IF(AN63<>\"DA\",\"-\",IF(AND(AN63=\"DA\",BL63<=0),LEN(TRIM(V63))-LEN(SUBSTITUTE(V63,CHAR(44),\"\"))+1+LEN(TRIM(U63))-LEN(SUBSTITUTE(U63,CHAR(44),\"\"))+1,0)),\"\")","v":"-"},{"$f":"IF(C63=\"X\",IF(AN63=\"DA\",LEN(TRIM(V63))-LEN(SUBSTITUTE(V63,CHAR(44),\"\"))+1+LEN(TRIM(U63))-LEN(SUBSTITUTE(U63,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"}]
[49,"-","X","Modernizare NT Schitu Goleşti - montare gară godevil",17254,"Mihăești","Argeș",500598.14502300002,401110.15465600003,500598.14502300002,401110.15465600003,"-","-","SM1243D0","Mihaești AG","-","-","-","-","SM-SD001",null,"SC Distrigaz Sud Rețele","iulie - septembrie 2021",null,null,null,null,"Craiova",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI 2020_8 (Anexa 1)",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[50,"-","X","Pregătire conductă 24” Paltin - Schitu Golești pentru transformare în conductă godevilabilă",13506,"Câmpulung","Argeș",506375.179,420606.43400000001,506375.179,420606.43400000001,"-","-","SM0429D0","SC Edilul Câmpulung","-","-","-","-","SM-CF001",null,"SC Edilul C.G.A. SA","iulie - august 2021",null,null,null,null,"Craiova",null,null,null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2020_II_A_3 (Anexa 1)",null,{"$f":"IF(B65=\"X\",IF(AN65=\"\",\"Afectat sau NU?\",IF(AN65=\"DA\",IF(((AK65+AL65)-(AE65+AF65))*24<-720,\"Neinformat\",((AK65+AL65)-(AE65+AF65))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B65=\"X\",IF(AN65=\"DA\",IF(AR65<6,LEN(TRIM(V65))-LEN(SUBSTITUTE(V65,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B65=\"X\",IF(AN65=\"DA\",LEN(TRIM(V65))-LEN(SUBSTITUTE(V65,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B65=\"X\",IF(AN65=\"\",\"Afectat sau NU?\",IF(AN65=\"DA\",IF(((AI65+AJ65)-(AE65+AF65))*24<-720,\"Neinformat\",((AI65+AJ65)-(AE65+AF65))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B65=\"X\",IF(AN65=\"DA\",IF(AU65<6,LEN(TRIM(U65))-LEN(SUBSTITUTE(U65,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B65=\"X\",IF(AN65=\"DA\",LEN(TRIM(U65))-LEN(SUBSTITUTE(U65,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B65=\"X\",IF(AN65=\"\",\"Afectat sau NU?\",IF(AN65=\"DA\",((AG65+AH65)-(AE65+AF65))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B65=\"X\",IF(AN65=\"DA\",IF(AX65>24,IF(BA65=\"NU\",0,LEN(TRIM(V65))-LEN(SUBSTITUTE(V65,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":""},{"$f":"IF(B65=\"X\",IF(AN65=\"DA\",IF(AX65>24,LEN(TRIM(V65))-LEN(SUBSTITUTE(V65,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(C65=\"X\",IF(AN65=\"\",\"Afectat sau NU?\",IF(AN65=\"DA\",IF(AK65=\"\",\"Neinformat\",NETWORKDAYS(AK65+AL65,AE65+AF65,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C65=\"X\",IF(AN65=\"DA\",IF(AND(BF65>=5,AK65<>\"\"),LEN(TRIM(V65))-LEN(SUBSTITUTE(V65,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C65=\"X\",IF(AN65=\"DA\",LEN(TRIM(V65))-LEN(SUBSTITUTE(V65,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C65=\"X\",IF(AN65=\"\",\"Afectat sau NU?\",IF(AN65=\"DA\",IF(AI65=\"\",\"Neinformat\",NETWORKDAYS(AI65+AJ65,AE65+AF65,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C65=\"X\",IF(AN65=\"DA\",IF(AND(BI65>=5,AI65<>\"\"),LEN(TRIM(U65))-LEN(SUBSTITUTE(U65,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C65=\"X\",IF(AN65=\"DA\",LEN(TRIM(U65))-LEN(SUBSTITUTE(U65,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C65=\"X\",IF(AN65=\"\",\"Afectat sau NU?\",IF(AN65=\"DA\",((AG65+AH65)-(Z65+AA65))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C65=\"X\",IF(AN65<>\"DA\",\"-\",IF(AND(AN65=\"DA\",BL65<=0),LEN(TRIM(V65))-LEN(SUBSTITUTE(V65,CHAR(44),\"\"))+1+LEN(TRIM(U65))-LEN(SUBSTITUTE(U65,CHAR(44),\"\"))+1,0)),\"\")","v":"-"},{"$f":"IF(C65=\"X\",IF(AN65=\"DA\",LEN(TRIM(V65))-LEN(SUBSTITUTE(V65,CHAR(44),\"\"))+1+LEN(TRIM(U65))-LEN(SUBSTITUTE(U65,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"}]
[51,"-","X","Pregătire conductă 24” Paltin - Schitu Golești pentru transformare în conductă godevilabilă",13506,"Câmpulung","Argeș",506435.56099999999,420938.47100000002,506435.56099999999,420938.47100000002,"-","-","SM0874D0","SC Complex Holcim Câmpulung Sediu","-","-","-","-","SM-CF001",null,"SC Holcim (România) SA","iulie - august 2021",null,null,null,null,"Craiova",null,null,null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2020_II_A_3 (Anexa 1)",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[52,"-","X","Pregătire conductă 24” Paltin - Schitu Golești pentru transformare în conductă godevilabilă",13506,"Câmpulung","Argeș",506492.15500000003,421280.19400000002,506492.15500000003,421280.19400000002,"-","-","SM0078D0","SC Romturingia Câmpulung","-","-","-","-","SM-CF001",null,"SC Romturingia SRL","iulie - august 2021",null,null,null,null,"Craiova",null,null,null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2020_II_A_3 (Anexa 1)",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[53,"-","X","Pregătire conductă 24” Paltin - Schitu Golești pentru transformare în conductă godevilabilă",13506,"Câmpulung","Argeș",509108.28096399998,421227.17672599998,509108.28096399998,421227.17672599998,"-","-","SM0213D1","SC Holcim Câmpulung","-","-","-","-","SM-CF001",null,"SC Holcim (România) SA","iulie - august 2021",null,null,null,null,"Craiova",null,null,null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2020_II_A_3 (Anexa 1)",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[54,"-","X","Pregătire conductă 24” Paltin - Schitu Golești pentru transformare în conductă godevilabilă",13506,"Câmpulung","Argeș",509108.28096399998,421227.17672599998,509108.28096399998,421227.17672599998,"-","-","SM0213D2","SC Carmeuse Holding Câmpulung","-","-","-","-","SM-CF001",null,"SC Carmeuse Holding SRL","iulie - august 2021",null,null,null,null,"Craiova",null,null,null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2020_II_A_3 (Anexa 1)",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[55,"-","X","Pregătire conductă 24” Paltin - Schitu Golești pentru transformare în conductă godevilabilă",13533,"Valea Mare Pravăț","Argeș",509108.28096399998,421227.17672599998,509108.28096399998,421227.17672599998,"-","-","SM0213D3","SC Star Multitrade Pravăț","-","-","-","-","SM-SD001",null,"SC Distrigaz Sud Rețele","iulie - august 2021",null,null,null,null,"Craiova",null,null,null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2020_II_A_3 (Anexa 1)",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[56,"-","X","Pregătire conductă 24” Paltin - Schitu Golești pentru transformare în conductă godevilabilă",13506,"Câmpulung","Argeș",504544.17111499998,418845.73154000001,504544.17111499998,418845.73154000001,"-","-","SM0216D0","Câmpulung Muscel","-","-","-","-","SM-SD001",null,"SC Distrigaz Sud Rețele","iulie - august 2021",null,null,null,null,"Craiova",null,null,null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2020_II_A_3 (Anexa 1)",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[57,"-","X","Pregătire conductă 24” Paltin - Schitu Golești pentru transformare în conductă godevilabilă",16917,"Lerești","Argeș",505375.83399999997,421813.47600000002,505375.83399999997,421813.47600000002,"-","-","SM1242D0","Lerești","-","-","-","-","SM-SD001",null,"SC Distrigaz Sud Rețele","iulie - august 2021",null,null,null,null,"Craiova",null,null,null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2020_II_A_3 (Anexa 1)",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[58,"-","X","Pregătire conductă 24” Paltin - Schitu Golești pentru transformare în conductă godevilabilă",16356,"Podu Dâmboviței","Argeș",515779.41327671334,434408.46333483607,515779.41327671334,434408.46333483607,"-","-","SM1088D0","Podu Dâmboviței","-","-","-","-","SM-SD001",null,"SC Distrigaz Sud Rețele","iulie - august 2021",null,null,null,null,"Brașov",null,null,null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2020_II_A_3 (Anexa 1)",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[59,"-","X","Pregătire conductă 24” Paltin - Schitu Golești pentru transformare în conductă godevilabilă",42272,"Rucăr","Argeș",514200.63511999999,431834.68708800001,514200.63511999999,431834.68708800001,"-","-","SM0938D0","Rucăr","-","-","-","-","SM-SD001",null,"SC Distrigaz Sud Rețele","iulie - august 2021",null,null,null,null,"Brașov",null,null,null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2020_II_A_3 (Anexa 1)",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[60,"-","X","Pregătire conductă 24” Paltin - Schitu Golești pentru transformare în conductă godevilabilă",41630,"Poiana Mărului","Brașov",523056.64230800001,457084.35658999998,523056.64230800001,457084.35658999998,"-","-","SM0212D0","Poiana Mărului","-","-","-","-","SM-SD001",null,"SC Distrigaz Sud Rețele","iulie - august 2021",null,null,null,null,"Brașov",null,null,null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2020_II_A_6 (Anexa 1)",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[61,"-","X","Pregătire conductă 24” Paltin - Schitu Golești pentru transformare în conductă godevilabilă",40508,"Zărnești","Brașov",525537.90700000001,451706.17499999999,525537.90700000001,451706.17499999999,"-","-","SM1251D0","DS Smith Paper Zărnești","-","-","-","-","SM-CF001",null,"DS Smith Paper Zarnești SRL","iulie - august 2021",null,null,null,null,"Brașov",null,null,null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2020_II_A_6 (Anexa 1)",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[62,"-","X","Pregătire conductă 24” Paltin - Schitu Golești pentru transformare în conductă godevilabilă",41480,"Moieciu de Jos","Brașov",520679.86340593785,445316.53378087026,520679.86340593785,445316.53378087026,"-","-","SM1139D0","Moieciu","-","-","-","-","SM-SD001",null,"SC Premier Energy SRL","iulie - august 2021",null,null,null,null,"Brașov",null,null,null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2020_II_A_6 (Anexa 1)",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[63,"-","X","Pregătirea conductei 20” Ișalnița - Cruce Ghercești pentru transformarea în conductă godevilabilă, zonele Melinești, CET II Craiova și Ghercești",72409,"Ghercești","Dolj",411337.338474622,315622.46369252302,411337.338474622,315622.46369252302,"-","-","-","-","PM0275","Stația Centrală Ghercești Extras","-","-","VPM01",null,"Depogaz Ploiești","5 octombrie - 30 noiembrie 2020\n8 februarie - 31 martie 2021",null,null,null,null,"Craiova",null,"Întârzieri în aprovizionarea cu materialele necesare datorită pandemiei COVID",null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2020_II_A_5 (Anexa 1)",null,{"$f":"IF(B78=\"X\",IF(AN78=\"\",\"Afectat sau NU?\",IF(AN78=\"DA\",IF(((AK78+AL78)-(AE78+AF78))*24<-720,\"Neinformat\",((AK78+AL78)-(AE78+AF78))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B78=\"X\",IF(AN78=\"DA\",IF(AR78<6,LEN(TRIM(V78))-LEN(SUBSTITUTE(V78,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B78=\"X\",IF(AN78=\"DA\",LEN(TRIM(V78))-LEN(SUBSTITUTE(V78,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B78=\"X\",IF(AN78=\"\",\"Afectat sau NU?\",IF(AN78=\"DA\",IF(((AI78+AJ78)-(AE78+AF78))*24<-720,\"Neinformat\",((AI78+AJ78)-(AE78+AF78))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B78=\"X\",IF(AN78=\"DA\",IF(AU78<6,LEN(TRIM(U78))-LEN(SUBSTITUTE(U78,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B78=\"X\",IF(AN78=\"DA\",LEN(TRIM(U78))-LEN(SUBSTITUTE(U78,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B78=\"X\",IF(AN78=\"\",\"Afectat sau NU?\",IF(AN78=\"DA\",((AG78+AH78)-(AE78+AF78))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B78=\"X\",IF(AN78=\"DA\",IF(AX78>24,IF(BA78=\"NU\",0,LEN(TRIM(V78))-LEN(SUBSTITUTE(V78,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":""},{"$f":"IF(B78=\"X\",IF(AN78=\"DA\",IF(AX78>24,LEN(TRIM(V78))-LEN(SUBSTITUTE(V78,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(C78=\"X\",IF(AN78=\"\",\"Afectat sau NU?\",IF(AN78=\"DA\",IF(AK78=\"\",\"Neinformat\",NETWORKDAYS(AK78+AL78,AE78+AF78,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C78=\"X\",IF(AN78=\"DA\",IF(AND(BF78>=5,AK78<>\"\"),LEN(TRIM(V78))-LEN(SUBSTITUTE(V78,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C78=\"X\",IF(AN78=\"DA\",LEN(TRIM(V78))-LEN(SUBSTITUTE(V78,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C78=\"X\",IF(AN78=\"\",\"Afectat sau NU?\",IF(AN78=\"DA\",IF(AI78=\"\",\"Neinformat\",NETWORKDAYS(AI78+AJ78,AE78+AF78,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C78=\"X\",IF(AN78=\"DA\",IF(AND(BI78>=5,AI78<>\"\"),LEN(TRIM(U78))-LEN(SUBSTITUTE(U78,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C78=\"X\",IF(AN78=\"DA\",LEN(TRIM(U78))-LEN(SUBSTITUTE(U78,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C78=\"X\",IF(AN78=\"\",\"Afectat sau NU?\",IF(AN78=\"DA\",((AG78+AH78)-(Z78+AA78))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C78=\"X\",IF(AN78<>\"DA\",\"-\",IF(AND(AN78=\"DA\",BL78<=0),LEN(TRIM(V78))-LEN(SUBSTITUTE(V78,CHAR(44),\"\"))+1+LEN(TRIM(U78))-LEN(SUBSTITUTE(U78,CHAR(44),\"\"))+1,0)),\"\")","v":"-"},{"$f":"IF(C78=\"X\",IF(AN78=\"DA\",LEN(TRIM(V78))-LEN(SUBSTITUTE(V78,CHAR(44),\"\"))+1+LEN(TRIM(U78))-LEN(SUBSTITUTE(U78,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"}]
[64,"-","X","Pregătirea conductei 20” Ișalnița - Cruce Ghercești pentru transformarea în conductă godevilabilă, zonele Melinești, CET II Craiova și Ghercești",72409,"Ghercești","Dolj",404873.43649811199,317922.64097540599,404873.43649811199,317922.64097540599,"-","-","SM1142D0","Stația Centrală Ghercești Înmagazinat","-","-","-","-","VSM01",null,"Depogaz Ploiești","5 octombrie - 30 noiembrie 2020\n8 februarie - 31 martie 2021",null,null,null,null,"Craiova",null,"Întârzieri în aprovizionarea cu materialele necesare datorită pandemiei COVID",null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2020_II_A_5 (Anexa 1)",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[65,"-","X","Pregătirea conductei 20” Ișalnița - Cruce Ghercești pentru transformarea în conductă godevilabilă, zonele Melinești, CET II Craiova și Ghercești",73246,"Mischii","Dolj",410109.20217399998,320464.25903700001,410109.20217399998,320464.25903700001,"-","-","SM1037D0","Mischii","-","-","-","-","SM-SD001",null,"SC Distrigaz Sud Rețele","5 octombrie - 30 noiembrie 2020\n8 februarie - 31 martie 2021",null,null,null,null,"Craiova",null,"Întârzieri în aprovizionarea cu materialele necesare datorită pandemiei COVID",null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2020_II_A_5 (Anexa 1)",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[66,"-","X","Pregătirea conductei 20” Ișalnița - Cruce Ghercești pentru transformarea în conductă godevilabilă, zonele Melinești, CET II Craiova și Ghercești",72418,"Ghercești","Dolj",412675.23300656455,316838.13070982782,412675.23300656455,316838.13070982782,"-","-","SM1146D0","Ghercești","-","-","-","-","SM-SD001",null,"SNGN Romgaz SA - Distribuție","5 octombrie - 30 noiembrie 2020\n8 februarie - 31 martie 2021",null,null,null,null,"Craiova",null,"Întârzieri în aprovizionarea cu materialele necesare datorită pandemiei COVID",null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2020_II_A_5 (Anexa 1)",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[67,"-","X","Pregătirea conductei 20” Ișalnița - Cruce Ghercești pentru transformarea în conductă godevilabilă, zonele Melinești, CET II Craiova și Ghercești",72409,"Ghercești","Dolj",409849.89834700001,314332.01364700001,409849.89834700001,314332.01364700001,"-","-","SM1194D0","Ghercești II","-","-","-","-","SM-SD001",null,"SNGN Romgaz SA - Distribuție","5 octombrie - 30 noiembrie 2020\n8 februarie - 31 martie 2021",null,null,null,null,"Craiova",null,"Întârzieri în aprovizionarea cu materialele necesare datorită pandemiei COVID",null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2020_II_A_5 (Anexa 1)",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[{"$f":"SUM(1,A82)","v":68},"-","X","Pregătirea conductei 20” Ișalnița - Cruce Ghercești pentru transformarea în conductă godevilabilă, zonele Melinești, CET II Craiova și Ghercești",73629,"Pielești","Dolj",414077.27518279653,316502.8502062328,414077.27518279653,316502.8502062328,"-","-","SM1187D0","Pielești","-","-","-","-","SM-SD001",null,"SC Megaconstruct SA","5 octombrie - 30 noiembrie 2020\n8 februarie - 31 martie 2021",null,null,null,null,"Craiova",null,"Întârzieri în aprovizionarea cu materialele necesare datorită pandemiei COVID",null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2020_II_A_5 (Anexa 1)",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[69,"-","X","Pregătirea conductei 20” Ișalnița - Cruce Ghercești pentru transformarea în conductă godevilabilă, zonele Melinești, CET II Craiova și Ghercești",69900,"Craiova","Dolj",404921.26517999999,317959.37717400002,404921.26517999999,317959.37717400002,"-","-","SM1158D0","CET Craiova II","-","-","-","-","SM-CF001",null,"Complexul Energetic Oltenia","5 octombrie - 30 noiembrie 2020\n8 februarie - 31 martie 2021",null,null,null,null,"Craiova",null,"Întârzieri în aprovizionarea cu materialele necesare datorită pandemiei COVID",null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2020_II_A_5 (Anexa 1)",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[70,"-","X","Pregătirea conductei 20” Ișalnița - Cruce Ghercești pentru transformarea în conductă godevilabilă, zonele Melinești, CET II Craiova și Ghercești",69900,"Craiova","Dolj",408229.28978400002,311000.13555200002,408229.28978400002,311000.13555200002,"-","-","SM0209D1","SC Ford Combinat","-","-","-","-","SM-CF001",null,"SC Ford România SA","5 octombrie - 30 noiembrie 2020\n8 februarie - 31 martie 2021",null,null,null,null,"Craiova",null,"Întârzieri în aprovizionarea cu materialele necesare datorită pandemiei COVID",null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2020_II_A_5 (Anexa 1)",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[71,"-","X","Pregătirea conductei 20” Ișalnița - Cruce Ghercești pentru transformarea în conductă godevilabilă, zonele Melinești, CET II Craiova și Ghercești",69900,"Craiova","Dolj",408229.28978400002,311000.13555200002,408229.28978400002,311000.13555200002,"-","-","SM0209D2","Ford Craiova Casnici","-","-","-","-","SM-SD001",null,"SC Distrigaz Sud Rețele","5 octombrie - 30 noiembrie 2020\n8 februarie - 31 martie 2021",null,null,null,null,"Craiova",null,"Întârzieri în aprovizionarea cu materialele necesare datorită pandemiei COVID",null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2020_II_A_5 (Anexa 1)",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[72,"-","X","Pregătirea conductei 20” Ișalnița - Cruce Ghercești pentru transformarea în conductă godevilabilă, zonele Melinești, CET II Craiova și Ghercești",69900,"Craiova","Dolj",404628.83991899999,311354.10385900002,404628.83991899999,311354.10385900002,"-","-","SM0208D0","Craiova Sud","-","-","-","-","SM-SD001",null,"SC Distrigaz Sud Rețele","5 octombrie - 30 noiembrie 2020\n8 februarie - 31 martie 2021",null,null,null,null,"Craiova",null,"Întârzieri în aprovizionarea cu materialele necesare datorită pandemiei COVID",null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2020_II_A_5 (Anexa 1)",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[73,"-","X","Pregătirea conductei 20” Ișalnița - Cruce Ghercești pentru transformarea în conductă godevilabilă, zonele Melinești, CET II Craiova și Ghercești",70110,"Podari","Dolj",404627.67373699998,311347.63970100001,404627.67373699998,311347.63970100001,"-","-","SM1053D0","Podari","-","-","-","-","SM-SD001",null,"SC Distrigaz Sud Rețele","5 octombrie - 30 noiembrie 2020\n8 februarie - 31 martie 2021",null,null,null,null,"Craiova",null,"Întârzieri în aprovizionarea cu materialele necesare datorită pandemiei COVID",null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2020_II_A_5 (Anexa 1)",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[74,"-","X","Reparație 6\" racord alimentare ELSID Titu, zona SRM Elsid",66090,"Titu","Dâmbovița",544542.71999999997,352331.07,544542.71999999997,352331.07,"-","-","SM0147D0","SC Elsid Titu","-","-","-","-","SM-CF001","E.on Energie","SC Elsid SA","5 octombrie - 30 noiembrie 2020\n14 - 31 decembrie 2020","2020-12-21","08:00:00","2020-12-21","18:00:00","București","Efectuată","Imposibilitate oprire alimentare cu gaze naturale datorită consumatorului direct ELSID, care pe perioada 09.11 - 10.12.2020 are instalația de calcinare în funcțiune.","2020-12-21","08:00:00","2020-12-21","17:10:00","2020-12-07","14:12:00","2020-12-07","13:37:00","5269/15.12.2020","DA",null,"PRRASM 2020_I_A_1 (Anexa 1)",null,"","","","","","","","","",null,null,null,null,null,9,1,1,9,1,1,-0.83333333325572312,2,2]
[75,"-","X","Lucrări de mentenanță în cadrul SRM Vlădeni",67265,"Vlădeni","Dâmbovița",561830.12,373144.01,567501.55000000005,372878.02,"-","-","SM0137D0","Vlădeni","-","-","-","-","SM-SD001","Aderro GP, Alpha Metal, Nova Power, Cez Vânzare, Cis Gaz, Conef Gaz, Crest Energy, Cyeb, Distrigaz Vest, Engie, E.On Energie, Electrocentrale București, Electrocentrale Constanța, Electrica Furnizare, Electric Planners, Electric&Gas, Energy Distribution, Enel, Enel Muntenia, Gas&Power, Entrex, Euro Seven Industry, Premier Energy Trading, Gaz Est, Hargaz, Megaconstruct, Met România, Monsson, Next Energy, Nord Gaz, Oligopol, Premier Energy, Petrom, Progaz, Energy Gas Provider, Renovatio, Restart Energy, Romgaz, RWE Supply, Tinmar, Transenergo, AIK România, Veolia, WIEE","Distrigaz Sud Rețele","5 octombrie - 30 noiembrie 2020\n18 - 31 decembrie 2020\nfebruarie - martie 2021",null,null,null,null,"București",null,"Lucrarea se va executa concomitent cu lucrarea de la pozițiile 33 - 35",null,null,null,null,null,null,null,null,null,null,null,"Lucrare realizată cu Sucursala Mediaș între lucrările planificate din Programul acesteia",null,{"$f":"IF(B90=\"X\",IF(AN90=\"\",\"Afectat sau NU?\",IF(AN90=\"DA\",IF(((AK90+AL90)-(AE90+AF90))*24<-720,\"Neinformat\",((AK90+AL90)-(AE90+AF90))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B90=\"X\",IF(AN90=\"DA\",IF(AR90<6,LEN(TRIM(V90))-LEN(SUBSTITUTE(V90,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B90=\"X\",IF(AN90=\"DA\",LEN(TRIM(V90))-LEN(SUBSTITUTE(V90,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B90=\"X\",IF(AN90=\"\",\"Afectat sau NU?\",IF(AN90=\"DA\",IF(((AI90+AJ90)-(AE90+AF90))*24<-720,\"Neinformat\",((AI90+AJ90)-(AE90+AF90))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B90=\"X\",IF(AN90=\"DA\",IF(AU90<6,LEN(TRIM(U90))-LEN(SUBSTITUTE(U90,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B90=\"X\",IF(AN90=\"DA\",LEN(TRIM(U90))-LEN(SUBSTITUTE(U90,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B90=\"X\",IF(AN90=\"\",\"Afectat sau NU?\",IF(AN90=\"DA\",((AG90+AH90)-(AE90+AF90))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B90=\"X\",IF(AN90=\"DA\",IF(AX90>24,IF(BA90=\"NU\",0,LEN(TRIM(V90))-LEN(SUBSTITUTE(V90,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":""},{"$f":"IF(B90=\"X\",IF(AN90=\"DA\",IF(AX90>24,LEN(TRIM(V90))-LEN(SUBSTITUTE(V90,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(C90=\"X\",IF(AN90=\"\",\"Afectat sau NU?\",IF(AN90=\"DA\",IF(AK90=\"\",\"Neinformat\",NETWORKDAYS(AK90+AL90,AE90+AF90,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C90=\"X\",IF(AN90=\"DA\",IF(AND(BF90>=5,AK90<>\"\"),LEN(TRIM(V90))-LEN(SUBSTITUTE(V90,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C90=\"X\",IF(AN90=\"DA\",LEN(TRIM(V90))-LEN(SUBSTITUTE(V90,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C90=\"X\",IF(AN90=\"\",\"Afectat sau NU?\",IF(AN90=\"DA\",IF(AI90=\"\",\"Neinformat\",NETWORKDAYS(AI90+AJ90,AE90+AF90,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C90=\"X\",IF(AN90=\"DA\",IF(AND(BI90>=5,AI90<>\"\"),LEN(TRIM(U90))-LEN(SUBSTITUTE(U90,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C90=\"X\",IF(AN90=\"DA\",LEN(TRIM(U90))-LEN(SUBSTITUTE(U90,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C90=\"X\",IF(AN90=\"\",\"Afectat sau NU?\",IF(AN90=\"DA\",((AG90+AH90)-(Z90+AA90))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C90=\"X\",IF(AN90<>\"DA\",\"-\",IF(AND(AN90=\"DA\",BL90<=0),LEN(TRIM(V90))-LEN(SUBSTITUTE(V90,CHAR(44),\"\"))+1+LEN(TRIM(U90))-LEN(SUBSTITUTE(U90,CHAR(44),\"\"))+1,0)),\"\")","v":"-"},{"$f":"IF(C90=\"X\",IF(AN90=\"DA\",LEN(TRIM(V90))-LEN(SUBSTITUTE(V90,CHAR(44),\"\"))+1+LEN(TRIM(U90))-LEN(SUBSTITUTE(U90,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"}]
[76,"-","X","Lucrări de sistematizare a înstalației tehnologice SRM Gura Suții",65690,"Găești","Dimbovita",540272,360540,540272,360540,"-","-","SM0877D2","Gura Șuții - Găești","-","-","-","-","SM-SD001",null,"Distrigaz Sud Rețele","5 octombrie - 30 noiembrie 2020",null,null,null,null,"București","Efectuată (Nu a mai fost necesară întreruperea)",null,null,null,null,null,null,null,null,null,null,null,null,"Lucrare realizată cu Sucursala Mediaș între lucrările planificate din Programul acesteia",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[77,"-","X","Lucrări de sistematizare a înstalației tehnologice SRM Gura Suții",67657,"Gura Șuții","Dimbovita",540272,360540,540272,360540,"-","-","SM0877D1","Gura Șuții","-","-","-","-","SM-SD001",null,"Distrigaz Sud Rețele","5 octombrie - 30 noiembrie 2020",null,null,null,null,"București","Efectuată (Nu a mai fost necesară întreruperea)",null,null,null,null,null,null,null,null,null,null,null,null,"Lucrare realizată cu Sucursala Mediaș între lucrările planificate din Programul acesteia",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[78,"-","X","Lucrări de sistematizare a înstalației tehnologice SRM Gura Suții",66090,"Titu","Dimbovita",540271.56000000006,360541.04,540271.56000000006,360541.04,"-","-","SM0147D0","SC ELSID Titu","-","-","-","-","SM-CF001",null,"SC ELSID SA","5 octombrie - 30 noiembrie 2020",null,null,null,null,"București","Efectuată (Nu a mai fost necesară întreruperea)",null,null,null,null,null,null,null,null,null,null,null,null,"Lucrare realizată cu Sucursala Mediaș între lucrările planificate din Programul acesteia",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[79,"-","X","Reparație conductă  4'' racord SRM Zagna Vădeni, zona Vădeni                                                                                                                                        ",44408,"Vădeni","Brăila",728803.97,433053.5,728803.97,433053.5,"-","-","SM0532D0","Zagna Vădeni","-","-","-","-","SM-SD001",null,"Distrigaz Sud Rețele","aprilie - septembrie 2021",null,null,null,null,"Brăila",null,null,null,null,null,null,null,null,null,null,null,null,null,"Sucursala A_13",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[80,"X","-","Eliminare emanații la robinetul RF12 în SRM Rulmentul Bârlad                                                                                                                              ",161801,"Bârlad","Vaslui",706749.84,532319.88,706749.84,532319.88,"-","-","SM0978D0","Rulmenți Bârlad","-","-","-","-","SM-CF001","Power&Gas, Cez Vânzare","SC Rulmenți SA","-","2020-10-03","08:05:00","2020-10-03","11:00:00","Brăila","Efectuată",null,"2020-10-03","08:05:00","2020-10-03","09:35:00","2020-10-03","08:24:00","2020-10-03","08:11:00","5720/29.09.2020","DA",null,null,null,{"$f":"IF(B95=\"X\",IF(AN95=\"\",\"Afectat sau NU?\",IF(AN95=\"DA\",IF(((AK95+AL95)-(AE95+AF95))*24<-720,\"Neinformat\",((AK95+AL95)-(AE95+AF95))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":9.9999999976716936E-2},{"$f":"IF(B95=\"X\",IF(AN95=\"DA\",IF(AR95<6,LEN(TRIM(V95))-LEN(SUBSTITUTE(V95,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":1},{"$f":"IF(B95=\"X\",IF(AN95=\"DA\",LEN(TRIM(V95))-LEN(SUBSTITUTE(V95,CHAR(44),\"\"))+1,\"-\"),\"\")","v":1},{"$f":"IF(B95=\"X\",IF(AN95=\"\",\"Afectat sau NU?\",IF(AN95=\"DA\",IF(((AI95+AJ95)-(AE95+AF95))*24<-720,\"Neinformat\",((AI95+AJ95)-(AE95+AF95))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":0.31666666665114462},{"$f":"IF(B95=\"X\",IF(AN95=\"DA\",IF(AU95<6,LEN(TRIM(U95))-LEN(SUBSTITUTE(U95,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":2},{"$f":"IF(B95=\"X\",IF(AN95=\"DA\",LEN(TRIM(U95))-LEN(SUBSTITUTE(U95,CHAR(44),\"\"))+1,\"-\"),\"\")","v":2},{"$f":"IF(B95=\"X\",IF(AN95=\"\",\"Afectat sau NU?\",IF(AN95=\"DA\",((AG95+AH95)-(AE95+AF95))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":1.5},{"$f":"IF(B95=\"X\",IF(AN95=\"DA\",IF(AX95>24,IF(BA95=\"NU\",0,LEN(TRIM(V95))-LEN(SUBSTITUTE(V95,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":0},{"$f":"IF(B95=\"X\",IF(AN95=\"DA\",IF(AX95>24,LEN(TRIM(V95))-LEN(SUBSTITUTE(V95,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":0},null,null,null,null,null,{"$f":"IF(C95=\"X\",IF(AN95=\"\",\"Afectat sau NU?\",IF(AN95=\"DA\",IF(AK95=\"\",\"Neinformat\",NETWORKDAYS(AK95+AL95,AE95+AF95,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C95=\"X\",IF(AN95=\"DA\",IF(AND(BF95>=5,AK95<>\"\"),LEN(TRIM(V95))-LEN(SUBSTITUTE(V95,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C95=\"X\",IF(AN95=\"DA\",LEN(TRIM(V95))-LEN(SUBSTITUTE(V95,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C95=\"X\",IF(AN95=\"\",\"Afectat sau NU?\",IF(AN95=\"DA\",IF(AI95=\"\",\"Neinformat\",NETWORKDAYS(AI95+AJ95,AE95+AF95,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C95=\"X\",IF(AN95=\"DA\",IF(AND(BI95>=5,AI95<>\"\"),LEN(TRIM(U95))-LEN(SUBSTITUTE(U95,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C95=\"X\",IF(AN95=\"DA\",LEN(TRIM(U95))-LEN(SUBSTITUTE(U95,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C95=\"X\",IF(AN95=\"\",\"Afectat sau NU?\",IF(AN95=\"DA\",((AG95+AH95)-(Z95+AA95))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C95=\"X\",IF(AN95<>\"DA\",\"-\",IF(AND(AN95=\"DA\",BL95<=0),LEN(TRIM(V95))-LEN(SUBSTITUTE(V95,CHAR(44),\"\"))+1+LEN(TRIM(U95))-LEN(SUBSTITUTE(U95,CHAR(44),\"\"))+1,0)),\"\")","v":""},{"$f":"IF(C95=\"X\",IF(AN95=\"DA\",LEN(TRIM(V95))-LEN(SUBSTITUTE(V95,CHAR(44),\"\"))+1+LEN(TRIM(U95))-LEN(SUBSTITUTE(U95,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""}]
[81,"X","-","Înlocuire robinet defect în SRM Chițcani",163155,"Chițcani","Vaslui",715362.07,550449.77,715362.07,550449.77,"-","-","SM1114D0","Chițcani","-","-","-","-","SM-SD001","Aderro, Power&Gas, Cez Vânzare, CIS Gaz, Engie România, E.On Energie, Electrica Furnizare, Electric&Gas, Energy Distribution, Enel Energie, Enel Energie Muntenia, Gas&Power, Premier Energy Trading, Gaz Est, Gaz Vest, Met România, Premier Energy, Petrom, Renovatio, Restart Energy, Safi-Star, Tinmar, AIK Energy","Gaz Est","-","2020-10-03","12:10:00","2020-10-03","14:00:00","Brăila","Efectuată",null,"2020-10-03","12:10:00","2020-10-03","12:35:00","2020-10-03","12:25:00","2020-10-03","12:15:00","5719/29.09.2020","DA",null,null,null,8.3333333255723119E-2,1,1,0.24999999994179234,23,23,0.41666666662786156,0,0,null,null,null,null,null,"","","","","","","","",""]
[82,"X","-","Înlocuire cupon pe conducta 4\" racord SRM Zagna Vădeni",44408,"Vădeni","Brăila",728803.97,433053.5,728803.97,433053.5,"-","-","SM0532D0","Zagna Vădeni","-","-","-","-","SM-SD001","Aderro GP, Alpha Metal, Nova Power, Cez Vânzare, Cis Gaz, Conef Gaz, Crest Energy, Cyeb, Distrigaz Vest, Engie, E.On Energie, Electrocentrale București, Electrocentrale Constanța, Electrica Furnizare, Electric Planners, Electric&Gas, Energy Distribution, Enel Energie, Enel Muntenia, Gas&Power, Entrex, Euro Seven Industry, Premier Energy Trading, Gaz Est, Hargaz, Gaz Vest, Megaconstruct, Met România, Monsson, Next Energy Distribution, Next Energy Parteners, Nord Gaz, Oligopol, Premier Energy, Petrom, Progaz, Energy Gas Provider, Renovatio, Res Energy Solutions, Restart Energy, Romgaz, RWE Supply, Tinmar, Transenergo, AIK România, Veolia, Wiee România","Distrigaz Sud Rețele","-","2020-10-08","07:05:00","2020-10-08","15:00:00","Brăila","Efectuată",null,"2020-10-08","07:05:00","2020-10-08","13:20:00","2020-10-08","07:37:00","2020-10-08","07:15:00","5901/06.10.2020","DA",null,null,null,{"$f":"IF(B97=\"X\",IF(AN97=\"\",\"Afectat sau NU?\",IF(AN97=\"DA\",IF(((AK97+AL97)-(AE97+AF97))*24<-720,\"Neinformat\",((AK97+AL97)-(AE97+AF97))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":0.16666666668606922},{"$f":"IF(B97=\"X\",IF(AN97=\"DA\",IF(AR97<6,LEN(TRIM(V97))-LEN(SUBSTITUTE(V97,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":1},{"$f":"IF(B97=\"X\",IF(AN97=\"DA\",LEN(TRIM(V97))-LEN(SUBSTITUTE(V97,CHAR(44),\"\"))+1,\"-\"),\"\")","v":1},{"$f":"IF(B97=\"X\",IF(AN97=\"\",\"Afectat sau NU?\",IF(AN97=\"DA\",IF(((AI97+AJ97)-(AE97+AF97))*24<-720,\"Neinformat\",((AI97+AJ97)-(AE97+AF97))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":0.53333333332557231},{"$f":"IF(B97=\"X\",IF(AN97=\"DA\",IF(AU97<6,LEN(TRIM(U97))-LEN(SUBSTITUTE(U97,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":47},{"$f":"IF(B97=\"X\",IF(AN97=\"DA\",LEN(TRIM(U97))-LEN(SUBSTITUTE(U97,CHAR(44),\"\"))+1,\"-\"),\"\")","v":47},{"$f":"IF(B97=\"X\",IF(AN97=\"\",\"Afectat sau NU?\",IF(AN97=\"DA\",((AG97+AH97)-(AE97+AF97))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":6.2499999999417923},{"$f":"IF(B97=\"X\",IF(AN97=\"DA\",IF(AX97>24,IF(BA97=\"NU\",0,LEN(TRIM(V97))-LEN(SUBSTITUTE(V97,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":0},{"$f":"IF(B97=\"X\",IF(AN97=\"DA\",IF(AX97>24,LEN(TRIM(V97))-LEN(SUBSTITUTE(V97,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":0},null,null,null,null,null,{"$f":"IF(C97=\"X\",IF(AN97=\"\",\"Afectat sau NU?\",IF(AN97=\"DA\",IF(AK97=\"\",\"Neinformat\",NETWORKDAYS(AK97+AL97,AE97+AF97,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C97=\"X\",IF(AN97=\"DA\",IF(AND(BF97>=5,AK97<>\"\"),LEN(TRIM(V97))-LEN(SUBSTITUTE(V97,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C97=\"X\",IF(AN97=\"DA\",LEN(TRIM(V97))-LEN(SUBSTITUTE(V97,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C97=\"X\",IF(AN97=\"\",\"Afectat sau NU?\",IF(AN97=\"DA\",IF(AI97=\"\",\"Neinformat\",NETWORKDAYS(AI97+AJ97,AE97+AF97,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C97=\"X\",IF(AN97=\"DA\",IF(AND(BI97>=5,AI97<>\"\"),LEN(TRIM(U97))-LEN(SUBSTITUTE(U97,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C97=\"X\",IF(AN97=\"DA\",LEN(TRIM(U97))-LEN(SUBSTITUTE(U97,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C97=\"X\",IF(AN97=\"\",\"Afectat sau NU?\",IF(AN97=\"DA\",((AG97+AH97)-(Z97+AA97))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C97=\"X\",IF(AN97<>\"DA\",\"-\",IF(AND(AN97=\"DA\",BL97<=0),LEN(TRIM(V97))-LEN(SUBSTITUTE(V97,CHAR(44),\"\"))+1+LEN(TRIM(U97))-LEN(SUBSTITUTE(U97,CHAR(44),\"\"))+1,0)),\"\")","v":""},{"$f":"IF(C97=\"X\",IF(AN97=\"DA\",LEN(TRIM(V97))-LEN(SUBSTITUTE(V97,CHAR(44),\"\"))+1+LEN(TRIM(U97))-LEN(SUBSTITUTE(U97,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""}]
[83,"X","-","Înlocuire robinet R2 și R3 în SRM Mihăești AG",17263,"Mihăești","Argeș",500598.14,401110.15,500598.14,401110.15,"-","-","SM1243D0","Mihăești AG","-","-","-","-","SM-SD001","Aderro GP, Alpha Metal, Nova Power, Cez Vânzare, Cis Gaz, Conef Gaz, Crest Energy, Cyeb, Distrigaz Vest, Engie, E.On Energie, Electrocentrale București, Electrocentrale Constanța, Electrica Furnizare, Electric Planners, Electric&Gas, Energy Distribution, Enel Energie, Enel Muntenia, Gas&Power, Entrex, Euro Seven Industry, Premier Energy Trading, Gaz Est, Hargaz, Gaz Vest, Megaconstruct, Met România, Monsson, Next Energy Distribution, Next Energy Parteners, Nord Gaz, Oligopol, Premier Energy, Petrom, Progaz, Energy Gas Provider, Renovatio, Res Energy Solutions, Restart Energy, Romgaz, RWE Supply, Tinmar, Transenergo, AIK România, Veolia, Wiee România","Distrigaz Sud Rețele","-","2020-10-14","09:35:00","2020-10-14","14:00:00","Craiova","Efectuată",null,"2020-10-14","09:35:00","2020-10-14","13:25:00","2020-10-14","09:46:00","2020-10-14","09:36:00","2450/13.10.2020","DA",null,null,null,{"$f":"IF(B98=\"X\",IF(AN98=\"\",\"Afectat sau NU?\",IF(AN98=\"DA\",IF(((AK98+AL98)-(AE98+AF98))*24<-720,\"Neinformat\",((AK98+AL98)-(AE98+AF98))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":1.6666666720993817E-2},{"$f":"IF(B98=\"X\",IF(AN98=\"DA\",IF(AR98<6,LEN(TRIM(V98))-LEN(SUBSTITUTE(V98,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":1},{"$f":"IF(B98=\"X\",IF(AN98=\"DA\",LEN(TRIM(V98))-LEN(SUBSTITUTE(V98,CHAR(44),\"\"))+1,\"-\"),\"\")","v":1},{"$f":"IF(B98=\"X\",IF(AN98=\"\",\"Afectat sau NU?\",IF(AN98=\"DA\",IF(((AI98+AJ98)-(AE98+AF98))*24<-720,\"Neinformat\",((AI98+AJ98)-(AE98+AF98))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":0.18333333340706304},{"$f":"IF(B98=\"X\",IF(AN98=\"DA\",IF(AU98<6,LEN(TRIM(U98))-LEN(SUBSTITUTE(U98,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":47},{"$f":"IF(B98=\"X\",IF(AN98=\"DA\",LEN(TRIM(U98))-LEN(SUBSTITUTE(U98,CHAR(44),\"\"))+1,\"-\"),\"\")","v":47},{"$f":"IF(B98=\"X\",IF(AN98=\"\",\"Afectat sau NU?\",IF(AN98=\"DA\",((AG98+AH98)-(AE98+AF98))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":3.8333333334303461},{"$f":"IF(B98=\"X\",IF(AN98=\"DA\",IF(AX98>24,IF(BA98=\"NU\",0,LEN(TRIM(V98))-LEN(SUBSTITUTE(V98,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":0},{"$f":"IF(B98=\"X\",IF(AN98=\"DA\",IF(AX98>24,LEN(TRIM(V98))-LEN(SUBSTITUTE(V98,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":0},null,null,null,null,null,{"$f":"IF(C98=\"X\",IF(AN98=\"\",\"Afectat sau NU?\",IF(AN98=\"DA\",IF(AK98=\"\",\"Neinformat\",NETWORKDAYS(AK98+AL98,AE98+AF98,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C98=\"X\",IF(AN98=\"DA\",IF(AND(BF98>=5,AK98<>\"\"),LEN(TRIM(V98))-LEN(SUBSTITUTE(V98,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C98=\"X\",IF(AN98=\"DA\",LEN(TRIM(V98))-LEN(SUBSTITUTE(V98,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C98=\"X\",IF(AN98=\"\",\"Afectat sau NU?\",IF(AN98=\"DA\",IF(AI98=\"\",\"Neinformat\",NETWORKDAYS(AI98+AJ98,AE98+AF98,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C98=\"X\",IF(AN98=\"DA\",IF(AND(BI98>=5,AI98<>\"\"),LEN(TRIM(U98))-LEN(SUBSTITUTE(U98,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C98=\"X\",IF(AN98=\"DA\",LEN(TRIM(U98))-LEN(SUBSTITUTE(U98,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C98=\"X\",IF(AN98=\"\",\"Afectat sau NU?\",IF(AN98=\"DA\",((AG98+AH98)-(Z98+AA98))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C98=\"X\",IF(AN98<>\"DA\",\"-\",IF(AND(AN98=\"DA\",BL98<=0),LEN(TRIM(V98))-LEN(SUBSTITUTE(V98,CHAR(44),\"\"))+1+LEN(TRIM(U98))-LEN(SUBSTITUTE(U98,CHAR(44),\"\"))+1,0)),\"\")","v":""},{"$f":"IF(C98=\"X\",IF(AN98=\"DA\",LEN(TRIM(V98))-LEN(SUBSTITUTE(V98,CHAR(44),\"\"))+1+LEN(TRIM(U98))-LEN(SUBSTITUTE(U98,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""}]
[84,"X","-","Întrerupere accidentală a SRM Adjud datorită blocării modulului de reglare cauzat de acumularea de impurități mecanice fine la sistemul de pilotare a regulatoarelor de pe ambele linii ale instalației",174897,"Adjudu Vechi","Vrancea",669494.85,517076.88,669494.85,517076.88,"-","-","SM0508D0","Adjud","-","-","-","-","SM-SD001","Aderro GP, Alpha Metal, Nova Power, Cez Vânzare, Cis Gaz, Conef Gaz, Crest Energy, Cyeb, Distrigaz Vest, Engie, E.On Energie, Electrocentrale București, Electrocentrale Constanța, Electrica Furnizare, Electric Planners, Electric&Gas, Energy Distribution, Enel Energie, Enel Muntenia, Gas&Power, Entrex, Euro Seven Industry, Premier Energy Trading, Gaz Est, Hargaz, Gaz Vest, Megaconstruct, Met România, Monsson, Next Energy Distribution, Next Energy Parteners, Nord Gaz, Oligopol, Premier Energy, Petrom, Progaz, Energy Gas Provider, Renovatio, Res Energy Solutions, Restart Energy, Romgaz, RWE Supply, Tinmar, Transenergo, AIK România, Veolia, Wiee România","Distrigaz Sud Rețele","-","2020-10-15","21:00:00","2020-10-16","07:30:00","Bacău","Efectuată",null,"2020-10-15","21:00:00","2020-10-16","07:30:00","2020-10-15","23:30:00","2020-10-15","21:00:00","-","DA",null,null,null,{"$f":"IF(B99=\"X\",IF(AN99=\"\",\"Afectat sau NU?\",IF(AN99=\"DA\",IF(((AK99+AL99)-(AE99+AF99))*24<-720,\"Neinformat\",((AK99+AL99)-(AE99+AF99))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":0},{"$f":"IF(B99=\"X\",IF(AN99=\"DA\",IF(AR99<6,LEN(TRIM(V99))-LEN(SUBSTITUTE(V99,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":1},{"$f":"IF(B99=\"X\",IF(AN99=\"DA\",LEN(TRIM(V99))-LEN(SUBSTITUTE(V99,CHAR(44),\"\"))+1,\"-\"),\"\")","v":1},{"$f":"IF(B99=\"X\",IF(AN99=\"\",\"Afectat sau NU?\",IF(AN99=\"DA\",IF(((AI99+AJ99)-(AE99+AF99))*24<-720,\"Neinformat\",((AI99+AJ99)-(AE99+AF99))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":2.4999999999417923},{"$f":"IF(B99=\"X\",IF(AN99=\"DA\",IF(AU99<6,LEN(TRIM(U99))-LEN(SUBSTITUTE(U99,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":47},{"$f":"IF(B99=\"X\",IF(AN99=\"DA\",LEN(TRIM(U99))-LEN(SUBSTITUTE(U99,CHAR(44),\"\"))+1,\"-\"),\"\")","v":47},{"$f":"IF(B99=\"X\",IF(AN99=\"\",\"Afectat sau NU?\",IF(AN99=\"DA\",((AG99+AH99)-(AE99+AF99))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":10.5},{"$f":"IF(B99=\"X\",IF(AN99=\"DA\",IF(AX99>24,IF(BA99=\"NU\",0,LEN(TRIM(V99))-LEN(SUBSTITUTE(V99,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":0},{"$f":"IF(B99=\"X\",IF(AN99=\"DA\",IF(AX99>24,LEN(TRIM(V99))-LEN(SUBSTITUTE(V99,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":0},null,null,null,null,null,{"$f":"IF(C99=\"X\",IF(AN99=\"\",\"Afectat sau NU?\",IF(AN99=\"DA\",IF(AK99=\"\",\"Neinformat\",NETWORKDAYS(AK99+AL99,AE99+AF99,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C99=\"X\",IF(AN99=\"DA\",IF(AND(BF99>=5,AK99<>\"\"),LEN(TRIM(V99))-LEN(SUBSTITUTE(V99,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C99=\"X\",IF(AN99=\"DA\",LEN(TRIM(V99))-LEN(SUBSTITUTE(V99,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C99=\"X\",IF(AN99=\"\",\"Afectat sau NU?\",IF(AN99=\"DA\",IF(AI99=\"\",\"Neinformat\",NETWORKDAYS(AI99+AJ99,AE99+AF99,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C99=\"X\",IF(AN99=\"DA\",IF(AND(BI99>=5,AI99<>\"\"),LEN(TRIM(U99))-LEN(SUBSTITUTE(U99,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C99=\"X\",IF(AN99=\"DA\",LEN(TRIM(U99))-LEN(SUBSTITUTE(U99,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C99=\"X\",IF(AN99=\"\",\"Afectat sau NU?\",IF(AN99=\"DA\",((AG99+AH99)-(Z99+AA99))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C99=\"X\",IF(AN99<>\"DA\",\"-\",IF(AND(AN99=\"DA\",BL99<=0),LEN(TRIM(V99))-LEN(SUBSTITUTE(V99,CHAR(44),\"\"))+1+LEN(TRIM(U99))-LEN(SUBSTITUTE(U99,CHAR(44),\"\"))+1,0)),\"\")","v":""},{"$f":"IF(C99=\"X\",IF(AN99=\"DA\",LEN(TRIM(V99))-LEN(SUBSTITUTE(V99,CHAR(44),\"\"))+1+LEN(TRIM(U99))-LEN(SUBSTITUTE(U99,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""}]
[{"$f":"SUM(1,A99)","v":85},"X","-","Remediere defecte de coroziune pe conducta 20\" Adjudul Vechi - Siliștea, zona Malul Alb",76709,"Matca","Galați",695489.22,484890.48,695489.22,484890.48,"-","-","SM0980D0","Matca(Vega93)","-","-","-","-","SM-SD001","Nova Power, Cez Vânzare, Engie, Electrica Furnizare, Enel Energie, Enel Muntenia, Premier Energy Trading, Met România, Petrom, Restart Energy, Tinmar, AIK România, Vega 93","Vega 93","-","2020-10-22","07:05:00","2020-10-22","17:00:00","Brăila","Efectuată",null,"2020-10-22","07:05:00","2020-10-22","16:20:00","2020-10-22","07:27:00","2020-10-22","07:14:00","6174/19.10.2020","DA",null,null,null,0.1499999999650754,1,1,0.36666666663950309,13,13,9.2499999999417923,0,0,null,null,null,null,null,"","","","","","","","",""]
[86,"X","-","Remediere defecte de coroziune pe conducta 20\" Adjudul Vechi - Siliștea, zona Malul Alb",76166,"Cudalbi","Galați",695290.48,477000.47,695290.48,477000.47,"-","-","-","-","-","-","PM0284","Cudalbi","PM-PP001","Amromco","Amromco","-","2020-10-22","07:07:00","2020-10-22","17:00:00","Brăila","Efectuată",null,"2020-10-22","07:07:00","2020-10-22","16:23:00","2020-10-22","07:24:00","2020-10-22","07:15:00","6174/19.10.2020","DA",null,null,null,0.13333333341870457,1,1,0.28333333338377997,1,1,9.2666666666627862,0,0,null,null,null,null,null,"","","","","","","","",""]
[87,"X","-","Întrerupere accidentală a SRM Venchi datorită blocării modulului de reglare.",116527,"Seleuș","Mureș",478337.54,526538,478337.54,526538,"-","-","SM0008D0","Venchi","-","-","-","-","SM-SD001","Aderro GP, Nova Power, Cez Vânzare, Cis Gaz, Conef Gaz, CPL Concordia, Crest Energy, Cyeb, Design Proiect, Distrigaz Vest, Engie, E.on Energie, Electrica Furnizare, Electric Planners, Electric&Gas, Energy Distribution, Enel Energie, Enel Muntenia, Gas&Power, Entrex, Premier Energy Trading, Gaz Est, Hargaz, Gazmir, Gaz Vest, Mihoc Oil, Met România, Monsson, Next Energy Distribution, Next Energy Partners, Pado Group, Premier Energy, Petrom, Prisma Serv, Gas Provider, Renovatio, Res Energy Solutions, Restart Energy, RWE Supply, SST Grup, Tetarom, Tinmar, AIK Energy, Veolia, Wiee","Delgaz Grid","-","2020-10-23","15:30:00","2020-10-23","17:00:00","Mediaș","Efectuată",null,"2020-10-23","15:30:00","2020-10-23","17:15:00","2020-10-23","16:04:00","2020-10-23","15:49:00","-","DA",null,null,null,{"$f":"IF(B102=\"X\",IF(AN102=\"\",\"Afectat sau NU?\",IF(AN102=\"DA\",IF(((AK102+AL102)-(AE102+AF102))*24<-720,\"Neinformat\",((AK102+AL102)-(AE102+AF102))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":0.31666666665114462},{"$f":"IF(B102=\"X\",IF(AN102=\"DA\",IF(AR102<6,LEN(TRIM(V102))-LEN(SUBSTITUTE(V102,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":1},{"$f":"IF(B102=\"X\",IF(AN102=\"DA\",LEN(TRIM(V102))-LEN(SUBSTITUTE(V102,CHAR(44),\"\"))+1,\"-\"),\"\")","v":1},{"$f":"IF(B102=\"X\",IF(AN102=\"\",\"Afectat sau NU?\",IF(AN102=\"DA\",IF(((AI102+AJ102)-(AE102+AF102))*24<-720,\"Neinformat\",((AI102+AJ102)-(AE102+AF102))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":0.56666666659293696},{"$f":"IF(B102=\"X\",IF(AN102=\"DA\",IF(AU102<6,LEN(TRIM(U102))-LEN(SUBSTITUTE(U102,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":45},{"$f":"IF(B102=\"X\",IF(AN102=\"DA\",LEN(TRIM(U102))-LEN(SUBSTITUTE(U102,CHAR(44),\"\"))+1,\"-\"),\"\")","v":45},{"$f":"IF(B102=\"X\",IF(AN102=\"\",\"Afectat sau NU?\",IF(AN102=\"DA\",((AG102+AH102)-(AE102+AF102))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":1.7499999999417923},{"$f":"IF(B102=\"X\",IF(AN102=\"DA\",IF(AX102>24,IF(BA102=\"NU\",0,LEN(TRIM(V102))-LEN(SUBSTITUTE(V102,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":0},{"$f":"IF(B102=\"X\",IF(AN102=\"DA\",IF(AX102>24,LEN(TRIM(V102))-LEN(SUBSTITUTE(V102,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":0},null,null,null,null,null,{"$f":"IF(C102=\"X\",IF(AN102=\"\",\"Afectat sau NU?\",IF(AN102=\"DA\",IF(AK102=\"\",\"Neinformat\",NETWORKDAYS(AK102+AL102,AE102+AF102,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C102=\"X\",IF(AN102=\"DA\",IF(AND(BF102>=5,AK102<>\"\"),LEN(TRIM(V102))-LEN(SUBSTITUTE(V102,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C102=\"X\",IF(AN102=\"DA\",LEN(TRIM(V102))-LEN(SUBSTITUTE(V102,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C102=\"X\",IF(AN102=\"\",\"Afectat sau NU?\",IF(AN102=\"DA\",IF(AI102=\"\",\"Neinformat\",NETWORKDAYS(AI102+AJ102,AE102+AF102,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C102=\"X\",IF(AN102=\"DA\",IF(AND(BI102>=5,AI102<>\"\"),LEN(TRIM(U102))-LEN(SUBSTITUTE(U102,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C102=\"X\",IF(AN102=\"DA\",LEN(TRIM(U102))-LEN(SUBSTITUTE(U102,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C102=\"X\",IF(AN102=\"\",\"Afectat sau NU?\",IF(AN102=\"DA\",((AG102+AH102)-(Z102+AA102))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C102=\"X\",IF(AN102<>\"DA\",\"-\",IF(AND(AN102=\"DA\",BL102<=0),LEN(TRIM(V102))-LEN(SUBSTITUTE(V102,CHAR(44),\"\"))+1+LEN(TRIM(U102))-LEN(SUBSTITUTE(U102,CHAR(44),\"\"))+1,0)),\"\")","v":""},{"$f":"IF(C102=\"X\",IF(AN102=\"DA\",LEN(TRIM(V102))-LEN(SUBSTITUTE(V102,CHAR(44),\"\"))+1+LEN(TRIM(U102))-LEN(SUBSTITUTE(U102,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""}]
[88,"X","-","Înlocuire robinet R11 în SRM Ișalnița (ieșire CET)",70101,"Ișalnița","Dolj",399102.24,320723.83,399102.24,320723.83,"-","-","SM0207D6","CET Ișalnița","-","-","-","-","SM-CF001","E.on Energie, Premier Energy","Complexul Energetic Oltenia","-","2020-10-27","09:13:00","2020-10-27","19:00:00","Craiova","Efectuată",null,"2020-10-27","09:13:00","2020-10-27","13:16:00","2020-10-27","09:35:00","2020-10-27","09:27:00","-","DA",null,null,null,{"$f":"IF(B103=\"X\",IF(AN103=\"\",\"Afectat sau NU?\",IF(AN103=\"DA\",IF(((AK103+AL103)-(AE103+AF103))*24<-720,\"Neinformat\",((AK103+AL103)-(AE103+AF103))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":0.2333333333954215},{"$f":"IF(B103=\"X\",IF(AN103=\"DA\",IF(AR103<6,LEN(TRIM(V103))-LEN(SUBSTITUTE(V103,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":1},{"$f":"IF(B103=\"X\",IF(AN103=\"DA\",LEN(TRIM(V103))-LEN(SUBSTITUTE(V103,CHAR(44),\"\"))+1,\"-\"),\"\")","v":1},{"$f":"IF(B103=\"X\",IF(AN103=\"\",\"Afectat sau NU?\",IF(AN103=\"DA\",IF(((AI103+AJ103)-(AE103+AF103))*24<-720,\"Neinformat\",((AI103+AJ103)-(AE103+AF103))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":0.36666666663950309},{"$f":"IF(B103=\"X\",IF(AN103=\"DA\",IF(AU103<6,LEN(TRIM(U103))-LEN(SUBSTITUTE(U103,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":2},{"$f":"IF(B103=\"X\",IF(AN103=\"DA\",LEN(TRIM(U103))-LEN(SUBSTITUTE(U103,CHAR(44),\"\"))+1,\"-\"),\"\")","v":2},{"$f":"IF(B103=\"X\",IF(AN103=\"\",\"Afectat sau NU?\",IF(AN103=\"DA\",((AG103+AH103)-(AE103+AF103))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":4.0499999999301508},{"$f":"IF(B103=\"X\",IF(AN103=\"DA\",IF(AX103>24,IF(BA103=\"NU\",0,LEN(TRIM(V103))-LEN(SUBSTITUTE(V103,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":0},{"$f":"IF(B103=\"X\",IF(AN103=\"DA\",IF(AX103>24,LEN(TRIM(V103))-LEN(SUBSTITUTE(V103,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":0},null,null,null,null,null,{"$f":"IF(C103=\"X\",IF(AN103=\"\",\"Afectat sau NU?\",IF(AN103=\"DA\",IF(AK103=\"\",\"Neinformat\",NETWORKDAYS(AK103+AL103,AE103+AF103,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C103=\"X\",IF(AN103=\"DA\",IF(AND(BF103>=5,AK103<>\"\"),LEN(TRIM(V103))-LEN(SUBSTITUTE(V103,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C103=\"X\",IF(AN103=\"DA\",LEN(TRIM(V103))-LEN(SUBSTITUTE(V103,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C103=\"X\",IF(AN103=\"\",\"Afectat sau NU?\",IF(AN103=\"DA\",IF(AI103=\"\",\"Neinformat\",NETWORKDAYS(AI103+AJ103,AE103+AF103,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C103=\"X\",IF(AN103=\"DA\",IF(AND(BI103>=5,AI103<>\"\"),LEN(TRIM(U103))-LEN(SUBSTITUTE(U103,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C103=\"X\",IF(AN103=\"DA\",LEN(TRIM(U103))-LEN(SUBSTITUTE(U103,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C103=\"X\",IF(AN103=\"\",\"Afectat sau NU?\",IF(AN103=\"DA\",((AG103+AH103)-(Z103+AA103))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C103=\"X\",IF(AN103<>\"DA\",\"-\",IF(AND(AN103=\"DA\",BL103<=0),LEN(TRIM(V103))-LEN(SUBSTITUTE(V103,CHAR(44),\"\"))+1+LEN(TRIM(U103))-LEN(SUBSTITUTE(U103,CHAR(44),\"\"))+1,0)),\"\")","v":""},{"$f":"IF(C103=\"X\",IF(AN103=\"DA\",LEN(TRIM(V103))-LEN(SUBSTITUTE(V103,CHAR(44),\"\"))+1+LEN(TRIM(U103))-LEN(SUBSTITUTE(U103,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""}]
[89,"X","-","Înlocuire instalație tehnologică SRM Dumitra",7419,"Dumitra","Alba",397685.98,511910.97,397685.98,511910.97,"-","-","SM0277D0","Dumitra","-","-","-","-","SM-SD001","Aderro GP, Nova Power, Cez Vânzare, Cis Gaz, Conef Gaz, CPL Concordia, Crest Energy, Cyeb, Design Proiect, Distrigaz Vest, Engie, E.on Energie, Electrica Furnizare, Electric Planners, Electric&Gas, Energy Distribution, Enel Energie, Enel Muntenia, Gas&Power, Entrex, Premier Energy Trading, Gaz Est, Hargaz, Gazmir, Gaz Vest, Mihoc Oil, Met România, Monsson, Next Energy Distribution, Next Energy Partners, Pado Group, Premier Energy, Petrom, Prisma Serv, Gas Provider, Renovatio, Res Energy Solutions, Restart Energy, RWE Supply, SST Grup, Tetarom, Tinmar, AIK Energy, Veolia, Wiee","Delgaz Grid","-","2020-10-28","08:00:00","2020-10-28","14:00:00","Mediaș","Efectuată",null,"2020-10-28","08:00:00","2020-10-28","14:00:00","2020-10-28","08:13:00","2020-10-28","08:02:00","-","DA",null,null,null,{"$f":"IF(B104=\"X\",IF(AN104=\"\",\"Afectat sau NU?\",IF(AN104=\"DA\",IF(((AK104+AL104)-(AE104+AF104))*24<-720,\"Neinformat\",((AK104+AL104)-(AE104+AF104))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":3.3333333267364651E-2},{"$f":"IF(B104=\"X\",IF(AN104=\"DA\",IF(AR104<6,LEN(TRIM(V104))-LEN(SUBSTITUTE(V104,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":1},{"$f":"IF(B104=\"X\",IF(AN104=\"DA\",LEN(TRIM(V104))-LEN(SUBSTITUTE(V104,CHAR(44),\"\"))+1,\"-\"),\"\")","v":1},{"$f":"IF(B104=\"X\",IF(AN104=\"\",\"Afectat sau NU?\",IF(AN104=\"DA\",IF(((AI104+AJ104)-(AE104+AF104))*24<-720,\"Neinformat\",((AI104+AJ104)-(AE104+AF104))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":0.21666666667442769},{"$f":"IF(B104=\"X\",IF(AN104=\"DA\",IF(AU104<6,LEN(TRIM(U104))-LEN(SUBSTITUTE(U104,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":45},{"$f":"IF(B104=\"X\",IF(AN104=\"DA\",LEN(TRIM(U104))-LEN(SUBSTITUTE(U104,CHAR(44),\"\"))+1,\"-\"),\"\")","v":45},{"$f":"IF(B104=\"X\",IF(AN104=\"\",\"Afectat sau NU?\",IF(AN104=\"DA\",((AG104+AH104)-(AE104+AF104))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":6},{"$f":"IF(B104=\"X\",IF(AN104=\"DA\",IF(AX104>24,IF(BA104=\"NU\",0,LEN(TRIM(V104))-LEN(SUBSTITUTE(V104,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":0},{"$f":"IF(B104=\"X\",IF(AN104=\"DA\",IF(AX104>24,LEN(TRIM(V104))-LEN(SUBSTITUTE(V104,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":0},null,null,null,null,null,{"$f":"IF(C104=\"X\",IF(AN104=\"\",\"Afectat sau NU?\",IF(AN104=\"DA\",IF(AK104=\"\",\"Neinformat\",NETWORKDAYS(AK104+AL104,AE104+AF104,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C104=\"X\",IF(AN104=\"DA\",IF(AND(BF104>=5,AK104<>\"\"),LEN(TRIM(V104))-LEN(SUBSTITUTE(V104,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C104=\"X\",IF(AN104=\"DA\",LEN(TRIM(V104))-LEN(SUBSTITUTE(V104,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C104=\"X\",IF(AN104=\"\",\"Afectat sau NU?\",IF(AN104=\"DA\",IF(AI104=\"\",\"Neinformat\",NETWORKDAYS(AI104+AJ104,AE104+AF104,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C104=\"X\",IF(AN104=\"DA\",IF(AND(BI104>=5,AI104<>\"\"),LEN(TRIM(U104))-LEN(SUBSTITUTE(U104,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C104=\"X\",IF(AN104=\"DA\",LEN(TRIM(U104))-LEN(SUBSTITUTE(U104,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C104=\"X\",IF(AN104=\"\",\"Afectat sau NU?\",IF(AN104=\"DA\",((AG104+AH104)-(Z104+AA104))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C104=\"X\",IF(AN104<>\"DA\",\"-\",IF(AND(AN104=\"DA\",BL104<=0),LEN(TRIM(V104))-LEN(SUBSTITUTE(V104,CHAR(44),\"\"))+1+LEN(TRIM(U104))-LEN(SUBSTITUTE(U104,CHAR(44),\"\"))+1,0)),\"\")","v":""},{"$f":"IF(C104=\"X\",IF(AN104=\"DA\",LEN(TRIM(V104))-LEN(SUBSTITUTE(V104,CHAR(44),\"\"))+1+LEN(TRIM(U104))-LEN(SUBSTITUTE(U104,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""}]
[90,"X","-","Oprire accidentală SRM Oradea I",26671,"Palota","Bihor",257019.14,624573.64,257019.14,624573.64,"-","-","SM0300D0","Oradea I","-","-","-","-","SM-SD001","Nova Power, Cez Vânzare, CIS Gaz, Cyeb, Distrigaz Vest, Engie, E.On Energie, Electrica Furnizare, Electric&Gas, Energy Distribution, Enel Energie, Enel Muntenia, Gas&Power, Premier Energy Trading, Gaz Est, Gaz Vest, Met România, Premier Energy, Petrom, Energy Gas Provider, Renovatio, Restart Energy, Tinmar, AIK România","Gaz Vest","-","2020-11-02","10:10:00","2020-11-02","13:00:00","Cluj","Efectuată",null,"2020-11-02","10:10:00","2020-11-02","13:00:00","2020-11-02","11:24:00","2020-11-02","10:57:00","-","DA",null,null,null,{"$f":"IF(B105=\"X\",IF(AN105=\"\",\"Afectat sau NU?\",IF(AN105=\"DA\",IF(((AK105+AL105)-(AE105+AF105))*24<-720,\"Neinformat\",((AK105+AL105)-(AE105+AF105))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":0.78333333344198763},{"$f":"IF(B105=\"X\",IF(AN105=\"DA\",IF(AR105<6,LEN(TRIM(V105))-LEN(SUBSTITUTE(V105,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":1},{"$f":"IF(B105=\"X\",IF(AN105=\"DA\",LEN(TRIM(V105))-LEN(SUBSTITUTE(V105,CHAR(44),\"\"))+1,\"-\"),\"\")","v":1},{"$f":"IF(B105=\"X\",IF(AN105=\"\",\"Afectat sau NU?\",IF(AN105=\"DA\",IF(((AI105+AJ105)-(AE105+AF105))*24<-720,\"Neinformat\",((AI105+AJ105)-(AE105+AF105))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":1.2333333333372138},{"$f":"IF(B105=\"X\",IF(AN105=\"DA\",IF(AU105<6,LEN(TRIM(U105))-LEN(SUBSTITUTE(U105,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":24},{"$f":"IF(B105=\"X\",IF(AN105=\"DA\",LEN(TRIM(U105))-LEN(SUBSTITUTE(U105,CHAR(44),\"\"))+1,\"-\"),\"\")","v":24},{"$f":"IF(B105=\"X\",IF(AN105=\"\",\"Afectat sau NU?\",IF(AN105=\"DA\",((AG105+AH105)-(AE105+AF105))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":2.8333333333139308},{"$f":"IF(B105=\"X\",IF(AN105=\"DA\",IF(AX105>24,IF(BA105=\"NU\",0,LEN(TRIM(V105))-LEN(SUBSTITUTE(V105,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":0},{"$f":"IF(B105=\"X\",IF(AN105=\"DA\",IF(AX105>24,LEN(TRIM(V105))-LEN(SUBSTITUTE(V105,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":0},null,null,null,null,null,{"$f":"IF(C105=\"X\",IF(AN105=\"\",\"Afectat sau NU?\",IF(AN105=\"DA\",IF(AK105=\"\",\"Neinformat\",NETWORKDAYS(AK105+AL105,AE105+AF105,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C105=\"X\",IF(AN105=\"DA\",IF(AND(BF105>=5,AK105<>\"\"),LEN(TRIM(V105))-LEN(SUBSTITUTE(V105,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C105=\"X\",IF(AN105=\"DA\",LEN(TRIM(V105))-LEN(SUBSTITUTE(V105,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C105=\"X\",IF(AN105=\"\",\"Afectat sau NU?\",IF(AN105=\"DA\",IF(AI105=\"\",\"Neinformat\",NETWORKDAYS(AI105+AJ105,AE105+AF105,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C105=\"X\",IF(AN105=\"DA\",IF(AND(BI105>=5,AI105<>\"\"),LEN(TRIM(U105))-LEN(SUBSTITUTE(U105,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C105=\"X\",IF(AN105=\"DA\",LEN(TRIM(U105))-LEN(SUBSTITUTE(U105,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C105=\"X\",IF(AN105=\"\",\"Afectat sau NU?\",IF(AN105=\"DA\",((AG105+AH105)-(Z105+AA105))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C105=\"X\",IF(AN105<>\"DA\",\"-\",IF(AND(AN105=\"DA\",BL105<=0),LEN(TRIM(V105))-LEN(SUBSTITUTE(V105,CHAR(44),\"\"))+1+LEN(TRIM(U105))-LEN(SUBSTITUTE(U105,CHAR(44),\"\"))+1,0)),\"\")","v":""},{"$f":"IF(C105=\"X\",IF(AN105=\"DA\",LEN(TRIM(V105))-LEN(SUBSTITUTE(V105,CHAR(44),\"\"))+1+LEN(TRIM(U105))-LEN(SUBSTITUTE(U105,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""}]
[91,"X","-","Înlocuire cupon de 50 ml pe conducta 16” Buhoci - Valea Malului, zona Poieni",20830,"Comănești","Bacău",612544.18000000005,546881.67000000004,612544.18000000005,546881.67000000004,"-","-","SM0432D1","Comănești","-","-","-","-","SM-SD001","Aderro GP, Nova Power, Cez Vânzare, Cis Gaz, Conef Gaz, CPL Concordia, Crest Energy, Cyeb, Design Proiect, Distrigaz Vest, Engie, E.on Energie, Electrica Furnizare, Electric Planners, Electric&Gas, Energy Distribution, Enel Energie, Enel Muntenia, Gas&Power, Entrex, Premier Energy Trading, Gaz Est, Hargaz, Gazmir, Gaz Vest, Mihoc Oil, Met România, Monsson, Next Energy Distribution, Next Energy Partners, Pado Group, Premier Energy, Petrom, Prisma Serv, Gas Provider, Renovatio, Res Energy Solutions, Restart Energy, RWE Supply, SST Grup, Tetarom, Tinmar, AIK Energy, Veolia, Wiee","Delgaz Grid","-","2020-11-04","09:04:00","2020-11-04","17:00:00","Bacău","Efectuată",null,"2020-11-04","09:04:00","2020-11-04","17:00:00","2020-11-04","09:26:00","2020-11-04","09:10:00","6156/02.11.2020","DA",null,null,null,{"$f":"IF(B106=\"X\",IF(AN106=\"\",\"Afectat sau NU?\",IF(AN106=\"DA\",IF(((AK106+AL106)-(AE106+AF106))*24<-720,\"Neinformat\",((AK106+AL106)-(AE106+AF106))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":9.9999999976716936E-2},{"$f":"IF(B106=\"X\",IF(AN106=\"DA\",IF(AR106<6,LEN(TRIM(V106))-LEN(SUBSTITUTE(V106,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":1},{"$f":"IF(B106=\"X\",IF(AN106=\"DA\",LEN(TRIM(V106))-LEN(SUBSTITUTE(V106,CHAR(44),\"\"))+1,\"-\"),\"\")","v":1},{"$f":"IF(B106=\"X\",IF(AN106=\"\",\"Afectat sau NU?\",IF(AN106=\"DA\",IF(((AI106+AJ106)-(AE106+AF106))*24<-720,\"Neinformat\",((AI106+AJ106)-(AE106+AF106))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":0.36666666663950309},{"$f":"IF(B106=\"X\",IF(AN106=\"DA\",IF(AU106<6,LEN(TRIM(U106))-LEN(SUBSTITUTE(U106,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":45},{"$f":"IF(B106=\"X\",IF(AN106=\"DA\",LEN(TRIM(U106))-LEN(SUBSTITUTE(U106,CHAR(44),\"\"))+1,\"-\"),\"\")","v":45},{"$f":"IF(B106=\"X\",IF(AN106=\"\",\"Afectat sau NU?\",IF(AN106=\"DA\",((AG106+AH106)-(AE106+AF106))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":7.9333333333488554},{"$f":"IF(B106=\"X\",IF(AN106=\"DA\",IF(AX106>24,IF(BA106=\"NU\",0,LEN(TRIM(V106))-LEN(SUBSTITUTE(V106,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":0},{"$f":"IF(B106=\"X\",IF(AN106=\"DA\",IF(AX106>24,LEN(TRIM(V106))-LEN(SUBSTITUTE(V106,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":0},null,null,null,null,null,{"$f":"IF(C106=\"X\",IF(AN106=\"\",\"Afectat sau NU?\",IF(AN106=\"DA\",IF(AK106=\"\",\"Neinformat\",NETWORKDAYS(AK106+AL106,AE106+AF106,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C106=\"X\",IF(AN106=\"DA\",IF(AND(BF106>=5,AK106<>\"\"),LEN(TRIM(V106))-LEN(SUBSTITUTE(V106,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C106=\"X\",IF(AN106=\"DA\",LEN(TRIM(V106))-LEN(SUBSTITUTE(V106,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C106=\"X\",IF(AN106=\"\",\"Afectat sau NU?\",IF(AN106=\"DA\",IF(AI106=\"\",\"Neinformat\",NETWORKDAYS(AI106+AJ106,AE106+AF106,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C106=\"X\",IF(AN106=\"DA\",IF(AND(BI106>=5,AI106<>\"\"),LEN(TRIM(U106))-LEN(SUBSTITUTE(U106,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C106=\"X\",IF(AN106=\"DA\",LEN(TRIM(U106))-LEN(SUBSTITUTE(U106,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C106=\"X\",IF(AN106=\"\",\"Afectat sau NU?\",IF(AN106=\"DA\",((AG106+AH106)-(Z106+AA106))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C106=\"X\",IF(AN106<>\"DA\",\"-\",IF(AND(AN106=\"DA\",BL106<=0),LEN(TRIM(V106))-LEN(SUBSTITUTE(V106,CHAR(44),\"\"))+1+LEN(TRIM(U106))-LEN(SUBSTITUTE(U106,CHAR(44),\"\"))+1,0)),\"\")","v":""},{"$f":"IF(C106=\"X\",IF(AN106=\"DA\",LEN(TRIM(V106))-LEN(SUBSTITUTE(V106,CHAR(44),\"\"))+1+LEN(TRIM(U106))-LEN(SUBSTITUTE(U106,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""}]
[92,"X","-","Înlocuire cupon de 50 ml pe conducta 16” Buhoci - Valea Malului, zona Poieni",20983,"Poieni","Bacău",620720.72,533623.9,620720.72,533623.9,"-","-","SM0430D0","Poieni","-","-","-","-","SM-SD001","Aderro GP, Nova Power, Cez Vânzare, Cis Gaz, Conef Gaz, CPL Concordia, Crest Energy, Cyeb, Design Proiect, Distrigaz Vest, Engie, E.on Energie, Electrica Furnizare, Electric Planners, Electric&Gas, Energy Distribution, Enel Energie, Enel Muntenia, Gas&Power, Entrex, Premier Energy Trading, Gaz Est, Hargaz, Gazmir, Gaz Vest, Mihoc Oil, Met România, Monsson, Next Energy Distribution, Next Energy Partners, Pado Group, Premier Energy, Petrom, Prisma Serv, Gas Provider, Renovatio, Res Energy Solutions, Restart Energy, RWE Supply, SST Grup, Tetarom, Tinmar, AIK Energy, Veolia, Wiee","Delgaz Grid","-","2020-11-04","09:04:00","2020-11-04","17:00:00","Bacău","Efectuată",null,"2020-11-04","09:04:00","2020-11-04","17:00:00","2020-11-04","09:26:00","2020-11-04","09:10:00","6156/02.11.2020","DA",null,null,null,9.9999999976716936E-2,1,1,0.36666666663950309,45,45,7.9333333333488554,0,0,null,null,null,null,null,"","","","","","","","",""]
[93,"X","-","Înlocuire cupon de 50 ml pe conducta 16” Buhoci - Valea Malului, zona Poieni",20885,"Moinești","Bacău",613113.19999999995,553437.6,613113.19999999995,553437.6,"-","-","SM0440D0","Moinești Dealu Mare","-","-","-","-","SM-SD001","Aderro GP, Nova Power, Cez Vânzare, Cis Gaz, Conef Gaz, CPL Concordia, Crest Energy, Cyeb, Design Proiect, Distrigaz Vest, Engie, E.on Energie, Electrica Furnizare, Electric Planners, Electric&Gas, Energy Distribution, Enel Energie, Enel Muntenia, Gas&Power, Entrex, Premier Energy Trading, Gaz Est, Hargaz, Gazmir, Gaz Vest, Mihoc Oil, Met România, Monsson, Next Energy Distribution, Next Energy Partners, Pado Group, Premier Energy, Petrom, Prisma Serv, Gas Provider, Renovatio, Res Energy Solutions, Restart Energy, RWE Supply, SST Grup, Tetarom, Tinmar, AIK Energy, Veolia, Wiee","Delgaz Grid","-","2020-11-04","09:04:00","2020-11-04","17:00:00","Bacău","Efectuată",null,"2020-11-04","09:04:00","2020-11-04","17:00:00","2020-11-04","09:26:00","2020-11-04","09:10:00","6156/02.11.2020","DA",null,null,null,9.9999999976716936E-2,1,1,0.36666666663950309,45,45,7.9333333333488554,0,0,null,null,null,null,null,"","","","","","","","",""]
[{"$f":"SUM(1,A108)","v":94},"X","-","Remediere definitivă a unui defect de coroziune pe conducta 20” Turburea - Ișalnița, fir I, zona Răcari",72418,"Ghercești","Bihor",412675.23,316838.13,412675.23,316838.13,"-","-","SM1142D0","Stația Centrală Ghercești Înmagazinat","-","-","-","-","VSM01","Amarad, Nova Power, Cez Vânzare, Cordun Gaz, CPL Concordia, MM Data, Distrigaz Vest, Engie, Axpo, E.on Energie, Enel, Enel Muntenia, Euro Seven, Gaz Est, Mehedinți Gaz, Met România, Nord Gaz, Premier Energy, Petrom, Progaz, Restart Energy, Romgaz, Tinmar","Depogaz Ploiești","-","2020-11-16","11:10:00","2020-11-16","23:00:00","Craiova","Efectuată (din motive tehnice a trebuit amânată)",null,"2020-11-16","11:10:00","2020-11-16","12:50:00","2020-11-16","12:28:00","2020-11-16","11:26:00","2717/13.11.2020","DA",null,null,null,{"$f":"IF(B109=\"X\",IF(AN109=\"\",\"Afectat sau NU?\",IF(AN109=\"DA\",IF(((AK109+AL109)-(AE109+AF109))*24<-720,\"Neinformat\",((AK109+AL109)-(AE109+AF109))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":0.26666666666278616},{"$f":"IF(B109=\"X\",IF(AN109=\"DA\",IF(AR109<6,LEN(TRIM(V109))-LEN(SUBSTITUTE(V109,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":1},{"$f":"IF(B109=\"X\",IF(AN109=\"DA\",LEN(TRIM(V109))-LEN(SUBSTITUTE(V109,CHAR(44),\"\"))+1,\"-\"),\"\")","v":1},{"$f":"IF(B109=\"X\",IF(AN109=\"\",\"Afectat sau NU?\",IF(AN109=\"DA\",IF(((AI109+AJ109)-(AE109+AF109))*24<-720,\"Neinformat\",((AI109+AJ109)-(AE109+AF109))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":1.2999999998719431},{"$f":"IF(B109=\"X\",IF(AN109=\"DA\",IF(AU109<6,LEN(TRIM(U109))-LEN(SUBSTITUTE(U109,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":23},{"$f":"IF(B109=\"X\",IF(AN109=\"DA\",LEN(TRIM(U109))-LEN(SUBSTITUTE(U109,CHAR(44),\"\"))+1,\"-\"),\"\")","v":23},{"$f":"IF(B109=\"X\",IF(AN109=\"\",\"Afectat sau NU?\",IF(AN109=\"DA\",((AG109+AH109)-(AE109+AF109))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":1.6666666665114462},{"$f":"IF(B109=\"X\",IF(AN109=\"DA\",IF(AX109>24,IF(BA109=\"NU\",0,LEN(TRIM(V109))-LEN(SUBSTITUTE(V109,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":0},{"$f":"IF(B109=\"X\",IF(AN109=\"DA\",IF(AX109>24,LEN(TRIM(V109))-LEN(SUBSTITUTE(V109,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":0},null,null,null,null,null,{"$f":"IF(C109=\"X\",IF(AN109=\"\",\"Afectat sau NU?\",IF(AN109=\"DA\",IF(AK109=\"\",\"Neinformat\",NETWORKDAYS(AK109+AL109,AE109+AF109,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C109=\"X\",IF(AN109=\"DA\",IF(AND(BF109>=5,AK109<>\"\"),LEN(TRIM(V109))-LEN(SUBSTITUTE(V109,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C109=\"X\",IF(AN109=\"DA\",LEN(TRIM(V109))-LEN(SUBSTITUTE(V109,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C109=\"X\",IF(AN109=\"\",\"Afectat sau NU?\",IF(AN109=\"DA\",IF(AI109=\"\",\"Neinformat\",NETWORKDAYS(AI109+AJ109,AE109+AF109,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C109=\"X\",IF(AN109=\"DA\",IF(AND(BI109>=5,AI109<>\"\"),LEN(TRIM(U109))-LEN(SUBSTITUTE(U109,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C109=\"X\",IF(AN109=\"DA\",LEN(TRIM(U109))-LEN(SUBSTITUTE(U109,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C109=\"X\",IF(AN109=\"\",\"Afectat sau NU?\",IF(AN109=\"DA\",((AG109+AH109)-(Z109+AA109))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C109=\"X\",IF(AN109<>\"DA\",\"-\",IF(AND(AN109=\"DA\",BL109<=0),LEN(TRIM(V109))-LEN(SUBSTITUTE(V109,CHAR(44),\"\"))+1+LEN(TRIM(U109))-LEN(SUBSTITUTE(U109,CHAR(44),\"\"))+1,0)),\"\")","v":""},{"$f":"IF(C109=\"X\",IF(AN109=\"DA\",LEN(TRIM(V109))-LEN(SUBSTITUTE(V109,CHAR(44),\"\"))+1+LEN(TRIM(U109))-LEN(SUBSTITUTE(U109,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""}]
[{"$f":"SUM(1,A109)","v":95},"X","-","Remediere definitivă a unui defect de coroziune pe conducta 20” Turburea - Ișalnița, fir I, zona Răcari",72418,"Ghercești","Bihor",412675.23,316838.13,412675.23,316838.13,"-","-","-","-","-","-","PM0275","Stația Centrală Ghercești Extras","VPM01","Aderro GP, Alpha Metal, Amarad, Nova Power, Cez Vânzare, Cordun Gaz, CPL Concordia, Cyeb, MM Data, Distrigaz Vest, Engie, E.on Energie, Electrica Furnizare, Electric&Gas, Energy Distribution, Enel Energie, Enel Muntenia, Gas&Power, Euro Seven, Premier Energy Trading, Gaz Est, Hargaz, Gazmir, Gaz Nord Est, Gaz Vest, Gecabuild, Măcin Gaz, Mehedinți Gaz, Met România, Nord Gaz, Oligopol, Pado Group, Premier Energy, Petrom, Prisma Serv, Progaz, Energy Gas Provider, Restart Energy, Romgaz, Tinmar, Vega 93, Veolia, Wiee","Depogaz Ploiești","-","2020-11-16","11:10:00","2020-11-16","23:00:00","Craiova","Efectuată (din motive tehnice a trebuit amânată)",null,"2020-11-16","11:10:00","2020-11-16","12:50:00","2020-11-16","12:28:00","2020-11-16","11:26:00","2717/13.11.2020","DA",null,null,null,{"$f":"IF(B110=\"X\",IF(AN110=\"\",\"Afectat sau NU?\",IF(AN110=\"DA\",IF(((AK110+AL110)-(AE110+AF110))*24<-720,\"Neinformat\",((AK110+AL110)-(AE110+AF110))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":0.26666666666278616},{"$f":"IF(B110=\"X\",IF(AN110=\"DA\",IF(AR110<6,LEN(TRIM(V110))-LEN(SUBSTITUTE(V110,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":1},{"$f":"IF(B110=\"X\",IF(AN110=\"DA\",LEN(TRIM(V110))-LEN(SUBSTITUTE(V110,CHAR(44),\"\"))+1,\"-\"),\"\")","v":1},{"$f":"IF(B110=\"X\",IF(AN110=\"\",\"Afectat sau NU?\",IF(AN110=\"DA\",IF(((AI110+AJ110)-(AE110+AF110))*24<-720,\"Neinformat\",((AI110+AJ110)-(AE110+AF110))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":1.2999999998719431},{"$f":"IF(B110=\"X\",IF(AN110=\"DA\",IF(AU110<6,LEN(TRIM(U110))-LEN(SUBSTITUTE(U110,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":43},{"$f":"IF(B110=\"X\",IF(AN110=\"DA\",LEN(TRIM(U110))-LEN(SUBSTITUTE(U110,CHAR(44),\"\"))+1,\"-\"),\"\")","v":43},{"$f":"IF(B110=\"X\",IF(AN110=\"\",\"Afectat sau NU?\",IF(AN110=\"DA\",((AG110+AH110)-(AE110+AF110))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":1.6666666665114462},{"$f":"IF(B110=\"X\",IF(AN110=\"DA\",IF(AX110>24,IF(BA110=\"NU\",0,LEN(TRIM(V110))-LEN(SUBSTITUTE(V110,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":0},{"$f":"IF(B110=\"X\",IF(AN110=\"DA\",IF(AX110>24,LEN(TRIM(V110))-LEN(SUBSTITUTE(V110,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":0},null,null,null,null,null,{"$f":"IF(C110=\"X\",IF(AN110=\"\",\"Afectat sau NU?\",IF(AN110=\"DA\",IF(AK110=\"\",\"Neinformat\",NETWORKDAYS(AK110+AL110,AE110+AF110,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C110=\"X\",IF(AN110=\"DA\",IF(AND(BF110>=5,AK110<>\"\"),LEN(TRIM(V110))-LEN(SUBSTITUTE(V110,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C110=\"X\",IF(AN110=\"DA\",LEN(TRIM(V110))-LEN(SUBSTITUTE(V110,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C110=\"X\",IF(AN110=\"\",\"Afectat sau NU?\",IF(AN110=\"DA\",IF(AI110=\"\",\"Neinformat\",NETWORKDAYS(AI110+AJ110,AE110+AF110,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C110=\"X\",IF(AN110=\"DA\",IF(AND(BI110>=5,AI110<>\"\"),LEN(TRIM(U110))-LEN(SUBSTITUTE(U110,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C110=\"X\",IF(AN110=\"DA\",LEN(TRIM(U110))-LEN(SUBSTITUTE(U110,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C110=\"X\",IF(AN110=\"\",\"Afectat sau NU?\",IF(AN110=\"DA\",((AG110+AH110)-(Z110+AA110))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C110=\"X\",IF(AN110<>\"DA\",\"-\",IF(AND(AN110=\"DA\",BL110<=0),LEN(TRIM(V110))-LEN(SUBSTITUTE(V110,CHAR(44),\"\"))+1+LEN(TRIM(U110))-LEN(SUBSTITUTE(U110,CHAR(44),\"\"))+1,0)),\"\")","v":""},{"$f":"IF(C110=\"X\",IF(AN110=\"DA\",LEN(TRIM(V110))-LEN(SUBSTITUTE(V110,CHAR(44),\"\"))+1+LEN(TRIM(U110))-LEN(SUBSTITUTE(U110,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""}]
[{"$f":"SUM(1,A110)","v":96},"X","-","Cuplare deviere conductă 4” racord SRM Tălmăcel",145845,"Boița","Sibiu",442446.2,460048.52,442446.2,460048.52,"-","-","SM0736D0","Boița","-","-","-","-","SM-SD001","Aderro GP, Nova Power, Cez Vânzare, Cis Gaz, Conef Gaz, CPL Concordia, Crest Energy, Cyeb, Design Proiect, Distrigaz Vest, Engie, E.on Energie, Electrica Furnizare, Electric Planners, Electric&Gas, Energy Distribution, Enel Energie, Enel Muntenia, Gas&Power, Entrex, Premier Energy Trading, Gaz Est, Hargaz, Gazmir, Gaz Vest, Mihoc Oil, Met România, Monsson, Next Energy Distribution, Next Energy Partners, Pado Group, Premier Energy, Petrom, Prisma Serv, Gas Provider, Renovatio, Res Energy Solutions, Restart Energy, RWE Supply, SST Grup, Tetarom, Tinmar, Veolia, Wiee","Delgaz Grid","-","2020-11-24","08:00:00","2020-11-24","15:00:00","Mediaș","Efectuată",null,"2020-11-24","08:00:00","2020-11-24","14:00:00","2020-11-24","08:29:00","2020-11-24","08:09:00","10487/23.11.2020","DA",null,null,null,{"$f":"IF(B111=\"X\",IF(AN111=\"\",\"Afectat sau NU?\",IF(AN111=\"DA\",IF(((AK111+AL111)-(AE111+AF111))*24<-720,\"Neinformat\",((AK111+AL111)-(AE111+AF111))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":0.1499999999650754},{"$f":"IF(B111=\"X\",IF(AN111=\"DA\",IF(AR111<6,LEN(TRIM(V111))-LEN(SUBSTITUTE(V111,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":1},{"$f":"IF(B111=\"X\",IF(AN111=\"DA\",LEN(TRIM(V111))-LEN(SUBSTITUTE(V111,CHAR(44),\"\"))+1,\"-\"),\"\")","v":1},{"$f":"IF(B111=\"X\",IF(AN111=\"\",\"Afectat sau NU?\",IF(AN111=\"DA\",IF(((AI111+AJ111)-(AE111+AF111))*24<-720,\"Neinformat\",((AI111+AJ111)-(AE111+AF111))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":0.48333333333721384},{"$f":"IF(B111=\"X\",IF(AN111=\"DA\",IF(AU111<6,LEN(TRIM(U111))-LEN(SUBSTITUTE(U111,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":44},{"$f":"IF(B111=\"X\",IF(AN111=\"DA\",LEN(TRIM(U111))-LEN(SUBSTITUTE(U111,CHAR(44),\"\"))+1,\"-\"),\"\")","v":44},{"$f":"IF(B111=\"X\",IF(AN111=\"\",\"Afectat sau NU?\",IF(AN111=\"DA\",((AG111+AH111)-(AE111+AF111))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":6},{"$f":"IF(B111=\"X\",IF(AN111=\"DA\",IF(AX111>24,IF(BA111=\"NU\",0,LEN(TRIM(V111))-LEN(SUBSTITUTE(V111,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":0},{"$f":"IF(B111=\"X\",IF(AN111=\"DA\",IF(AX111>24,LEN(TRIM(V111))-LEN(SUBSTITUTE(V111,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":0},null,null,null,null,null,{"$f":"IF(C111=\"X\",IF(AN111=\"\",\"Afectat sau NU?\",IF(AN111=\"DA\",IF(AK111=\"\",\"Neinformat\",NETWORKDAYS(AK111+AL111,AE111+AF111,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C111=\"X\",IF(AN111=\"DA\",IF(AND(BF111>=5,AK111<>\"\"),LEN(TRIM(V111))-LEN(SUBSTITUTE(V111,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C111=\"X\",IF(AN111=\"DA\",LEN(TRIM(V111))-LEN(SUBSTITUTE(V111,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C111=\"X\",IF(AN111=\"\",\"Afectat sau NU?\",IF(AN111=\"DA\",IF(AI111=\"\",\"Neinformat\",NETWORKDAYS(AI111+AJ111,AE111+AF111,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C111=\"X\",IF(AN111=\"DA\",IF(AND(BI111>=5,AI111<>\"\"),LEN(TRIM(U111))-LEN(SUBSTITUTE(U111,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C111=\"X\",IF(AN111=\"DA\",LEN(TRIM(U111))-LEN(SUBSTITUTE(U111,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C111=\"X\",IF(AN111=\"\",\"Afectat sau NU?\",IF(AN111=\"DA\",((AG111+AH111)-(Z111+AA111))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C111=\"X\",IF(AN111<>\"DA\",\"-\",IF(AND(AN111=\"DA\",BL111<=0),LEN(TRIM(V111))-LEN(SUBSTITUTE(V111,CHAR(44),\"\"))+1+LEN(TRIM(U111))-LEN(SUBSTITUTE(U111,CHAR(44),\"\"))+1,0)),\"\")","v":""},{"$f":"IF(C111=\"X\",IF(AN111=\"DA\",LEN(TRIM(V111))-LEN(SUBSTITUTE(V111,CHAR(44),\"\"))+1+LEN(TRIM(U111))-LEN(SUBSTITUTE(U111,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""}]
[{"$f":"SUM(1,A111)","v":97},"X","-","Cuplare deviere conductă 4” racord SRM Tălmăcel",145890,"Tălmăcel","Sibiu",441757.19,461422.55,441757.19,461422.55,"-","-","SM1160D0","Tălmăcel II","-","-","-","-","SM-SD001","Aderro GP, Nova Power, Cez Vânzare, Cis Gaz, Conef Gaz, CPL Concordia, Crest Energy, Cyeb, Design Proiect, Distrigaz Vest, Engie, E.on Energie, Electrica Furnizare, Electric Planners, Electric&Gas, Energy Distribution, Enel Energie, Enel Muntenia, Gas&Power, Entrex, Premier Energy Trading, Gaz Est, Hargaz, Gazmir, Gaz Vest, Mihoc Oil, Met România, Monsson, Next Energy Distribution, Next Energy Partners, Pado Group, Premier Energy, Petrom, Prisma Serv, Gas Provider, Renovatio, Res Energy Solutions, Restart Energy, RWE Supply, SST Grup, Tetarom, Tinmar, Veolia, Wiee","Delgaz Grid","-","2020-11-24","08:00:00","2020-11-24","15:00:00","Mediaș","Efectuată",null,"2020-11-24","08:00:00","2020-11-24","14:00:00","2020-11-24","08:29:00","2020-11-24","08:09:00","10487/23.11.2020","DA",null,null,null,{"$f":"IF(B112=\"X\",IF(AN112=\"\",\"Afectat sau NU?\",IF(AN112=\"DA\",IF(((AK112+AL112)-(AE112+AF112))*24<-720,\"Neinformat\",((AK112+AL112)-(AE112+AF112))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":0.1499999999650754},{"$f":"IF(B112=\"X\",IF(AN112=\"DA\",IF(AR112<6,LEN(TRIM(V112))-LEN(SUBSTITUTE(V112,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":1},{"$f":"IF(B112=\"X\",IF(AN112=\"DA\",LEN(TRIM(V112))-LEN(SUBSTITUTE(V112,CHAR(44),\"\"))+1,\"-\"),\"\")","v":1},{"$f":"IF(B112=\"X\",IF(AN112=\"\",\"Afectat sau NU?\",IF(AN112=\"DA\",IF(((AI112+AJ112)-(AE112+AF112))*24<-720,\"Neinformat\",((AI112+AJ112)-(AE112+AF112))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":0.48333333333721384},{"$f":"IF(B112=\"X\",IF(AN112=\"DA\",IF(AU112<6,LEN(TRIM(U112))-LEN(SUBSTITUTE(U112,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":44},{"$f":"IF(B112=\"X\",IF(AN112=\"DA\",LEN(TRIM(U112))-LEN(SUBSTITUTE(U112,CHAR(44),\"\"))+1,\"-\"),\"\")","v":44},{"$f":"IF(B112=\"X\",IF(AN112=\"\",\"Afectat sau NU?\",IF(AN112=\"DA\",((AG112+AH112)-(AE112+AF112))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":6},{"$f":"IF(B112=\"X\",IF(AN112=\"DA\",IF(AX112>24,IF(BA112=\"NU\",0,LEN(TRIM(V112))-LEN(SUBSTITUTE(V112,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":0},{"$f":"IF(B112=\"X\",IF(AN112=\"DA\",IF(AX112>24,LEN(TRIM(V112))-LEN(SUBSTITUTE(V112,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":0},null,null,null,null,null,{"$f":"IF(C112=\"X\",IF(AN112=\"\",\"Afectat sau NU?\",IF(AN112=\"DA\",IF(AK112=\"\",\"Neinformat\",NETWORKDAYS(AK112+AL112,AE112+AF112,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C112=\"X\",IF(AN112=\"DA\",IF(AND(BF112>=5,AK112<>\"\"),LEN(TRIM(V112))-LEN(SUBSTITUTE(V112,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C112=\"X\",IF(AN112=\"DA\",LEN(TRIM(V112))-LEN(SUBSTITUTE(V112,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C112=\"X\",IF(AN112=\"\",\"Afectat sau NU?\",IF(AN112=\"DA\",IF(AI112=\"\",\"Neinformat\",NETWORKDAYS(AI112+AJ112,AE112+AF112,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C112=\"X\",IF(AN112=\"DA\",IF(AND(BI112>=5,AI112<>\"\"),LEN(TRIM(U112))-LEN(SUBSTITUTE(U112,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C112=\"X\",IF(AN112=\"DA\",LEN(TRIM(U112))-LEN(SUBSTITUTE(U112,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C112=\"X\",IF(AN112=\"\",\"Afectat sau NU?\",IF(AN112=\"DA\",((AG112+AH112)-(Z112+AA112))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C112=\"X\",IF(AN112<>\"DA\",\"-\",IF(AND(AN112=\"DA\",BL112<=0),LEN(TRIM(V112))-LEN(SUBSTITUTE(V112,CHAR(44),\"\"))+1+LEN(TRIM(U112))-LEN(SUBSTITUTE(U112,CHAR(44),\"\"))+1,0)),\"\")","v":""},{"$f":"IF(C112=\"X\",IF(AN112=\"DA\",LEN(TRIM(V112))-LEN(SUBSTITUTE(V112,CHAR(44),\"\"))+1+LEN(TRIM(U112))-LEN(SUBSTITUTE(U112,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""}]
[{"$f":"SUM(1,A112)","v":98},"X","-","Cuplare deviere conductă 4” racord SRM Tălmăcel",145890,"Tălmăcel","Sibiu",441290.5,461208.57,441290.5,461208.57,"-","-","SM0735D0","Tălmăcel","-","-","-","-","SM-SD001","Aderro GP, Nova Power, Cez Vânzare, Cis Gaz, Conef Gaz, CPL Concordia, Crest Energy, Cyeb, Design Proiect, Distrigaz Vest, Engie, E.on Energie, Electrica Furnizare, Electric Planners, Electric&Gas, Energy Distribution, Enel Energie, Enel Muntenia, Gas&Power, Entrex, Premier Energy Trading, Gaz Est, Hargaz, Gazmir, Gaz Vest, Mihoc Oil, Met România, Monsson, Next Energy Distribution, Next Energy Partners, Pado Group, Premier Energy, Petrom, Prisma Serv, Gas Provider, Renovatio, Res Energy Solutions, Restart Energy, RWE Supply, SST Grup, Tetarom, Tinmar, Veolia, Wiee","Delgaz Grid","-","2020-11-24","08:00:00","2020-11-24","15:00:00","Mediaș","Efectuată",null,"2020-11-24","08:00:00","2020-11-24","14:00:00","2020-11-24","08:29:00","2020-11-24","08:09:00","10487/23.11.2020","DA",null,null,null,{"$f":"IF(B113=\"X\",IF(AN113=\"\",\"Afectat sau NU?\",IF(AN113=\"DA\",IF(((AK113+AL113)-(AE113+AF113))*24<-720,\"Neinformat\",((AK113+AL113)-(AE113+AF113))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":0.1499999999650754},{"$f":"IF(B113=\"X\",IF(AN113=\"DA\",IF(AR113<6,LEN(TRIM(V113))-LEN(SUBSTITUTE(V113,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":1},{"$f":"IF(B113=\"X\",IF(AN113=\"DA\",LEN(TRIM(V113))-LEN(SUBSTITUTE(V113,CHAR(44),\"\"))+1,\"-\"),\"\")","v":1},{"$f":"IF(B113=\"X\",IF(AN113=\"\",\"Afectat sau NU?\",IF(AN113=\"DA\",IF(((AI113+AJ113)-(AE113+AF113))*24<-720,\"Neinformat\",((AI113+AJ113)-(AE113+AF113))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":0.48333333333721384},{"$f":"IF(B113=\"X\",IF(AN113=\"DA\",IF(AU113<6,LEN(TRIM(U113))-LEN(SUBSTITUTE(U113,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":44},{"$f":"IF(B113=\"X\",IF(AN113=\"DA\",LEN(TRIM(U113))-LEN(SUBSTITUTE(U113,CHAR(44),\"\"))+1,\"-\"),\"\")","v":44},{"$f":"IF(B113=\"X\",IF(AN113=\"\",\"Afectat sau NU?\",IF(AN113=\"DA\",((AG113+AH113)-(AE113+AF113))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":6},{"$f":"IF(B113=\"X\",IF(AN113=\"DA\",IF(AX113>24,IF(BA113=\"NU\",0,LEN(TRIM(V113))-LEN(SUBSTITUTE(V113,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":0},{"$f":"IF(B113=\"X\",IF(AN113=\"DA\",IF(AX113>24,LEN(TRIM(V113))-LEN(SUBSTITUTE(V113,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":0},null,null,null,null,null,{"$f":"IF(C113=\"X\",IF(AN113=\"\",\"Afectat sau NU?\",IF(AN113=\"DA\",IF(AK113=\"\",\"Neinformat\",NETWORKDAYS(AK113+AL113,AE113+AF113,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C113=\"X\",IF(AN113=\"DA\",IF(AND(BF113>=5,AK113<>\"\"),LEN(TRIM(V113))-LEN(SUBSTITUTE(V113,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C113=\"X\",IF(AN113=\"DA\",LEN(TRIM(V113))-LEN(SUBSTITUTE(V113,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C113=\"X\",IF(AN113=\"\",\"Afectat sau NU?\",IF(AN113=\"DA\",IF(AI113=\"\",\"Neinformat\",NETWORKDAYS(AI113+AJ113,AE113+AF113,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C113=\"X\",IF(AN113=\"DA\",IF(AND(BI113>=5,AI113<>\"\"),LEN(TRIM(U113))-LEN(SUBSTITUTE(U113,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C113=\"X\",IF(AN113=\"DA\",LEN(TRIM(U113))-LEN(SUBSTITUTE(U113,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C113=\"X\",IF(AN113=\"\",\"Afectat sau NU?\",IF(AN113=\"DA\",((AG113+AH113)-(Z113+AA113))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C113=\"X\",IF(AN113<>\"DA\",\"-\",IF(AND(AN113=\"DA\",BL113<=0),LEN(TRIM(V113))-LEN(SUBSTITUTE(V113,CHAR(44),\"\"))+1+LEN(TRIM(U113))-LEN(SUBSTITUTE(U113,CHAR(44),\"\"))+1,0)),\"\")","v":""},{"$f":"IF(C113=\"X\",IF(AN113=\"DA\",LEN(TRIM(V113))-LEN(SUBSTITUTE(V113,CHAR(44),\"\"))+1+LEN(TRIM(U113))-LEN(SUBSTITUTE(U113,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""}]
[{"$f":"SUM(1,A113)","v":99},"X","-","Oprire accidentală SRM Vața",19962,"Vața","Argeș",474320.82,361923.01,474320.82,361923.01,"-","-","SM0219D0","Vața","-","-","-","-","SM-SD001","Aderro GP, Alpha Metal, Nova Power, Cez Vânzare, Cis Gaz, Conef Gaz, Crest Energy, Cyeb, Distrigaz Vest, Engie, E.on Energie, Electrocentrale București, Electrocentrale Constanța, Electrica Furnizare, Electric Planners, Electric&Gas, Energy Distribution, Enel Energie, Enel Muntenia, Gas&Power, Entrex, Euro Seven, Premier Energy Trading, Gaz Est, Hargaz, Gaz Vest, Megaconstruct, Met România, Monsson, Next Energy Distribution, Next Energy Partners, Nord Gaz, Oligopol, Premier Energy, Petrom, Progaz, Energy Gas Provider, Renovatio, Res Energy Solutions, Restart Energy, Romgaz, RWE Supply, Tinmar, Transenergo, Vega 93, Veolia, Wiee","Distrigaz Sud Rețele","-","2020-12-03","11:50:00","2020-12-03","14:00:00","Craiova","Efectuată",null,"2020-12-03","11:50:00","2020-12-03","14:00:00","2020-12-03","12:21:00","2020-12-03","12:14:00","-","DA",null,null,null,0.40000000008149073,1,1,0.5166666666045785,47,47,2.1666666667442769,0,0,null,null,null,null,null,"","","","","","","","",""]
[100,"X","-","Oprire accidentală SRM Gordon Prod Bulgăreni",84852,"Bulgăreni","Harghita",518631.57,539395.30000000005,518631.57,539395.30000000005,"-","-","SM0999D0","SC Gordon Prod Bulgăreni","-","-","-","-","SM-CF001","Nova Power","SC Gordon Prod SRL","-","2020-12-17","14:56:00","2020-12-18","14:00:00","Brașov","Efectuată",null,"2020-12-17","14:56:00","2020-12-18","10:00:00","2020-12-17","15:20:00","2020-12-17","15:03:00","3589/18.12.2020","DA",null,null,null,{"$f":"IF(B115=\"X\",IF(AN115=\"\",\"Afectat sau NU?\",IF(AN115=\"DA\",IF(((AK115+AL115)-(AE115+AF115))*24<-720,\"Neinformat\",((AK115+AL115)-(AE115+AF115))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":0.11666666669771075},{"$f":"IF(B115=\"X\",IF(AN115=\"DA\",IF(AR115<6,LEN(TRIM(V115))-LEN(SUBSTITUTE(V115,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":1},{"$f":"IF(B115=\"X\",IF(AN115=\"DA\",LEN(TRIM(V115))-LEN(SUBSTITUTE(V115,CHAR(44),\"\"))+1,\"-\"),\"\")","v":1},{"$f":"IF(B115=\"X\",IF(AN115=\"\",\"Afectat sau NU?\",IF(AN115=\"DA\",IF(((AI115+AJ115)-(AE115+AF115))*24<-720,\"Neinformat\",((AI115+AJ115)-(AE115+AF115))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":0.40000000008149073},{"$f":"IF(B115=\"X\",IF(AN115=\"DA\",IF(AU115<6,LEN(TRIM(U115))-LEN(SUBSTITUTE(U115,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":1},{"$f":"IF(B115=\"X\",IF(AN115=\"DA\",LEN(TRIM(U115))-LEN(SUBSTITUTE(U115,CHAR(44),\"\"))+1,\"-\"),\"\")","v":1},{"$f":"IF(B115=\"X\",IF(AN115=\"\",\"Afectat sau NU?\",IF(AN115=\"DA\",((AG115+AH115)-(AE115+AF115))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":19.066666666651145},{"$f":"IF(B115=\"X\",IF(AN115=\"DA\",IF(AX115>24,IF(BA115=\"NU\",0,LEN(TRIM(V115))-LEN(SUBSTITUTE(V115,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":0},{"$f":"IF(B115=\"X\",IF(AN115=\"DA\",IF(AX115>24,LEN(TRIM(V115))-LEN(SUBSTITUTE(V115,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":0},null,null,null,null,null,{"$f":"IF(C115=\"X\",IF(AN115=\"\",\"Afectat sau NU?\",IF(AN115=\"DA\",IF(AK115=\"\",\"Neinformat\",NETWORKDAYS(AK115+AL115,AE115+AF115,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C115=\"X\",IF(AN115=\"DA\",IF(AND(BF115>=5,AK115<>\"\"),LEN(TRIM(V115))-LEN(SUBSTITUTE(V115,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C115=\"X\",IF(AN115=\"DA\",LEN(TRIM(V115))-LEN(SUBSTITUTE(V115,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C115=\"X\",IF(AN115=\"\",\"Afectat sau NU?\",IF(AN115=\"DA\",IF(AI115=\"\",\"Neinformat\",NETWORKDAYS(AI115+AJ115,AE115+AF115,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C115=\"X\",IF(AN115=\"DA\",IF(AND(BI115>=5,AI115<>\"\"),LEN(TRIM(U115))-LEN(SUBSTITUTE(U115,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C115=\"X\",IF(AN115=\"DA\",LEN(TRIM(U115))-LEN(SUBSTITUTE(U115,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C115=\"X\",IF(AN115=\"\",\"Afectat sau NU?\",IF(AN115=\"DA\",((AG115+AH115)-(Z115+AA115))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C115=\"X\",IF(AN115<>\"DA\",\"-\",IF(AND(AN115=\"DA\",BL115<=0),LEN(TRIM(V115))-LEN(SUBSTITUTE(V115,CHAR(44),\"\"))+1+LEN(TRIM(U115))-LEN(SUBSTITUTE(U115,CHAR(44),\"\"))+1,0)),\"\")","v":""},{"$f":"IF(C115=\"X\",IF(AN115=\"DA\",LEN(TRIM(V115))-LEN(SUBSTITUTE(V115,CHAR(44),\"\"))+1+LEN(TRIM(U115))-LEN(SUBSTITUTE(U115,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""}]
[101,"X","-","Remediere defect pe conducta 32\" Moșu - Cogenerare Brazi la traversarea râului Prahova ",130721,"Brazii de sus","Prahova",578964.69999999995,376015.84,578964.69999999995,376015.84,"SM1248D0","CECC Brazi","-","-","-","-","-","-","SM-CF001","Nova Power, Cez Vânzare, Engie, E.on Energie, Electric&Gas, Enel, Premier Energy Trading, Gaz Est, Premier Energy, Petrom, Restart Energy","Petrom","-","2020-12-31","04:50:00","2020-12-31","14:00:00","București","Efectuată",null,"2020-12-31","04:50:00","2020-12-31","11:45:00","2020-12-31","06:09:00","2020-12-31","05:43:00","5519/31.12.2020","DA",null,null,null,{"$f":"IF(B116=\"X\",IF(AN116=\"\",\"Afectat sau NU?\",IF(AN116=\"DA\",IF(((AK116+AL116)-(AE116+AF116))*24<-720,\"Neinformat\",((AK116+AL116)-(AE116+AF116))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":0.88333333324408159},{"$f":"IF(B116=\"X\",IF(AN116=\"DA\",IF(AR116<6,LEN(TRIM(V116))-LEN(SUBSTITUTE(V116,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":1},{"$f":"IF(B116=\"X\",IF(AN116=\"DA\",LEN(TRIM(V116))-LEN(SUBSTITUTE(V116,CHAR(44),\"\"))+1,\"-\"),\"\")","v":1},{"$f":"IF(B116=\"X\",IF(AN116=\"\",\"Afectat sau NU?\",IF(AN116=\"DA\",IF(((AI116+AJ116)-(AE116+AF116))*24<-720,\"Neinformat\",((AI116+AJ116)-(AE116+AF116))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":1.316666666592937},{"$f":"IF(B116=\"X\",IF(AN116=\"DA\",IF(AU116<6,LEN(TRIM(U116))-LEN(SUBSTITUTE(U116,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":11},{"$f":"IF(B116=\"X\",IF(AN116=\"DA\",LEN(TRIM(U116))-LEN(SUBSTITUTE(U116,CHAR(44),\"\"))+1,\"-\"),\"\")","v":11},{"$f":"IF(B116=\"X\",IF(AN116=\"\",\"Afectat sau NU?\",IF(AN116=\"DA\",((AG116+AH116)-(AE116+AF116))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":6.9166666666860692},{"$f":"IF(B116=\"X\",IF(AN116=\"DA\",IF(AX116>24,IF(BA116=\"NU\",0,LEN(TRIM(V116))-LEN(SUBSTITUTE(V116,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":0},{"$f":"IF(B116=\"X\",IF(AN116=\"DA\",IF(AX116>24,LEN(TRIM(V116))-LEN(SUBSTITUTE(V116,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":0},null,null,null,null,null,{"$f":"IF(C116=\"X\",IF(AN116=\"\",\"Afectat sau NU?\",IF(AN116=\"DA\",IF(AK116=\"\",\"Neinformat\",NETWORKDAYS(AK116+AL116,AE116+AF116,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C116=\"X\",IF(AN116=\"DA\",IF(AND(BF116>=5,AK116<>\"\"),LEN(TRIM(V116))-LEN(SUBSTITUTE(V116,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C116=\"X\",IF(AN116=\"DA\",LEN(TRIM(V116))-LEN(SUBSTITUTE(V116,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C116=\"X\",IF(AN116=\"\",\"Afectat sau NU?\",IF(AN116=\"DA\",IF(AI116=\"\",\"Neinformat\",NETWORKDAYS(AI116+AJ116,AE116+AF116,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C116=\"X\",IF(AN116=\"DA\",IF(AND(BI116>=5,AI116<>\"\"),LEN(TRIM(U116))-LEN(SUBSTITUTE(U116,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C116=\"X\",IF(AN116=\"DA\",LEN(TRIM(U116))-LEN(SUBSTITUTE(U116,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C116=\"X\",IF(AN116=\"\",\"Afectat sau NU?\",IF(AN116=\"DA\",((AG116+AH116)-(Z116+AA116))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C116=\"X\",IF(AN116<>\"DA\",\"-\",IF(AND(AN116=\"DA\",BL116<=0),LEN(TRIM(V116))-LEN(SUBSTITUTE(V116,CHAR(44),\"\"))+1+LEN(TRIM(U116))-LEN(SUBSTITUTE(U116,CHAR(44),\"\"))+1,0)),\"\")","v":""},{"$f":"IF(C116=\"X\",IF(AN116=\"DA\",LEN(TRIM(V116))-LEN(SUBSTITUTE(V116,CHAR(44),\"\"))+1+LEN(TRIM(U116))-LEN(SUBSTITUTE(U116,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""}]
[102,"X","-","Limitare tehnică a conductei 20\" NT Mănești - Brazi Fir II",130721,"Brazii de sus","Prahova",578964.69999999995,376015.84,578964.69999999995,376015.84,"SM1248D0","CECC Brazi","-","-","-","-","-","-","SM-CF001","Nova Power, Cez Vânzare, Engie, E.on Energie, Electric&Gas, Enel, Premier Energy Trading, Gaz Est, Premier Energy, Petrom, Restart Energy","Petrom","-","2020-12-31","15:00:00","2021-01-01","04:00:00","București","Efectuată",null,"2020-12-31","15:00:00","2021-01-01","10:29:00","2020-12-31","15:48:00","2020-12-31","15:29:00",null,"DA",null,null,null,{"$f":"IF(B117=\"X\",IF(AN117=\"\",\"Afectat sau NU?\",IF(AN117=\"DA\",IF(((AK117+AL117)-(AE117+AF117))*24<-720,\"Neinformat\",((AK117+AL117)-(AE117+AF117))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":0.48333333333721384},{"$f":"IF(B117=\"X\",IF(AN117=\"DA\",IF(AR117<6,LEN(TRIM(V117))-LEN(SUBSTITUTE(V117,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":1},{"$f":"IF(B117=\"X\",IF(AN117=\"DA\",LEN(TRIM(V117))-LEN(SUBSTITUTE(V117,CHAR(44),\"\"))+1,\"-\"),\"\")","v":1},{"$f":"IF(B117=\"X\",IF(AN117=\"\",\"Afectat sau NU?\",IF(AN117=\"DA\",IF(((AI117+AJ117)-(AE117+AF117))*24<-720,\"Neinformat\",((AI117+AJ117)-(AE117+AF117))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":0.79999999998835847},{"$f":"IF(B117=\"X\",IF(AN117=\"DA\",IF(AU117<6,LEN(TRIM(U117))-LEN(SUBSTITUTE(U117,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":11},{"$f":"IF(B117=\"X\",IF(AN117=\"DA\",LEN(TRIM(U117))-LEN(SUBSTITUTE(U117,CHAR(44),\"\"))+1,\"-\"),\"\")","v":11},{"$f":"IF(B117=\"X\",IF(AN117=\"\",\"Afectat sau NU?\",IF(AN117=\"DA\",((AG117+AH117)-(AE117+AF117))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":19.483333333279006},{"$f":"IF(B117=\"X\",IF(AN117=\"DA\",IF(AX117>24,IF(BA117=\"NU\",0,LEN(TRIM(V117))-LEN(SUBSTITUTE(V117,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":0},{"$f":"IF(B117=\"X\",IF(AN117=\"DA\",IF(AX117>24,LEN(TRIM(V117))-LEN(SUBSTITUTE(V117,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":0},null,null,null,null,null,{"$f":"IF(C117=\"X\",IF(AN117=\"\",\"Afectat sau NU?\",IF(AN117=\"DA\",IF(AK117=\"\",\"Neinformat\",NETWORKDAYS(AK117+AL117,AE117+AF117,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C117=\"X\",IF(AN117=\"DA\",IF(AND(BF117>=5,AK117<>\"\"),LEN(TRIM(V117))-LEN(SUBSTITUTE(V117,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C117=\"X\",IF(AN117=\"DA\",LEN(TRIM(V117))-LEN(SUBSTITUTE(V117,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C117=\"X\",IF(AN117=\"\",\"Afectat sau NU?\",IF(AN117=\"DA\",IF(AI117=\"\",\"Neinformat\",NETWORKDAYS(AI117+AJ117,AE117+AF117,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C117=\"X\",IF(AN117=\"DA\",IF(AND(BI117>=5,AI117<>\"\"),LEN(TRIM(U117))-LEN(SUBSTITUTE(U117,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C117=\"X\",IF(AN117=\"DA\",LEN(TRIM(U117))-LEN(SUBSTITUTE(U117,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C117=\"X\",IF(AN117=\"\",\"Afectat sau NU?\",IF(AN117=\"DA\",((AG117+AH117)-(Z117+AA117))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C117=\"X\",IF(AN117<>\"DA\",\"-\",IF(AND(AN117=\"DA\",BL117<=0),LEN(TRIM(V117))-LEN(SUBSTITUTE(V117,CHAR(44),\"\"))+1+LEN(TRIM(U117))-LEN(SUBSTITUTE(U117,CHAR(44),\"\"))+1,0)),\"\")","v":""},{"$f":"IF(C117=\"X\",IF(AN117=\"DA\",LEN(TRIM(V117))-LEN(SUBSTITUTE(V117,CHAR(44),\"\"))+1+LEN(TRIM(U117))-LEN(SUBSTITUTE(U117,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""}]
[103,"X","-","Cuplare instalație tehnologică SRM Chișineu Criș la racord 8\" Chișineu Criș",9468,"Chișineu - Criș","Arad",233939.75,564386.76,233939.75,564386.76,"-","-","SM0357D0","Chișineu Criș I","-","-","-","-","SM-SD001","Aderro GP, Nova Power, Cez Vânzare, Cis Gaz, Conef Gaz, CPL Concordia, Crest Energy, Cyeb, Design Proiect, Distrigaz Vest, Engie, E.on Energie, Electrica Furnizare, Electric Planners, Electric&Gas, Energy Distribution, Enel Energie, Enel Muntenia, Gas&Power, Entrex, Premier Energy Trading, Gaz Est, Hargaz, Gazmir, Gaz Vest, Mihoc Oil, Met România, Monsson, Next Energy Distribution, Next Energy Partners, Pado Group, Premier Energy, Petrom, Prisma Serv, Gas Provider, Renovatio, Res Energy Solutions, Restart Energy, RWE Supply, SST Grup, Tetarom, Tinmar, Veolia, Wiee","Delgaz Grid","-","2021-01-05","09:00:00","2021-01-05","16:00:00","Arad","Efectuată",null,"2021-01-05","09:00:00","2021-01-05","18:00:00","2021-01-05","09:56:00","2021-01-05","09:34:00","12055/30.12.2020","DA",null,null,null,{"$f":"IF(B118=\"X\",IF(AN118=\"\",\"Afectat sau NU?\",IF(AN118=\"DA\",IF(((AK118+AL118)-(AE118+AF118))*24<-720,\"Neinformat\",((AK118+AL118)-(AE118+AF118))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":0.56666666659293696},{"$f":"IF(B118=\"X\",IF(AN118=\"DA\",IF(AR118<6,LEN(TRIM(V118))-LEN(SUBSTITUTE(V118,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":1},{"$f":"IF(B118=\"X\",IF(AN118=\"DA\",LEN(TRIM(V118))-LEN(SUBSTITUTE(V118,CHAR(44),\"\"))+1,\"-\"),\"\")","v":1},{"$f":"IF(B118=\"X\",IF(AN118=\"\",\"Afectat sau NU?\",IF(AN118=\"DA\",IF(((AI118+AJ118)-(AE118+AF118))*24<-720,\"Neinformat\",((AI118+AJ118)-(AE118+AF118))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":0.93333333340706304},{"$f":"IF(B118=\"X\",IF(AN118=\"DA\",IF(AU118<6,LEN(TRIM(U118))-LEN(SUBSTITUTE(U118,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":44},{"$f":"IF(B118=\"X\",IF(AN118=\"DA\",LEN(TRIM(U118))-LEN(SUBSTITUTE(U118,CHAR(44),\"\"))+1,\"-\"),\"\")","v":44},{"$f":"IF(B118=\"X\",IF(AN118=\"\",\"Afectat sau NU?\",IF(AN118=\"DA\",((AG118+AH118)-(AE118+AF118))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":9},{"$f":"IF(B118=\"X\",IF(AN118=\"DA\",IF(AX118>24,IF(BA118=\"NU\",0,LEN(TRIM(V118))-LEN(SUBSTITUTE(V118,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":0},{"$f":"IF(B118=\"X\",IF(AN118=\"DA\",IF(AX118>24,LEN(TRIM(V118))-LEN(SUBSTITUTE(V118,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":0},null,null,null,null,null,{"$f":"IF(C118=\"X\",IF(AN118=\"\",\"Afectat sau NU?\",IF(AN118=\"DA\",IF(AK118=\"\",\"Neinformat\",NETWORKDAYS(AK118+AL118,AE118+AF118,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C118=\"X\",IF(AN118=\"DA\",IF(AND(BF118>=5,AK118<>\"\"),LEN(TRIM(V118))-LEN(SUBSTITUTE(V118,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C118=\"X\",IF(AN118=\"DA\",LEN(TRIM(V118))-LEN(SUBSTITUTE(V118,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C118=\"X\",IF(AN118=\"\",\"Afectat sau NU?\",IF(AN118=\"DA\",IF(AI118=\"\",\"Neinformat\",NETWORKDAYS(AI118+AJ118,AE118+AF118,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C118=\"X\",IF(AN118=\"DA\",IF(AND(BI118>=5,AI118<>\"\"),LEN(TRIM(U118))-LEN(SUBSTITUTE(U118,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C118=\"X\",IF(AN118=\"DA\",LEN(TRIM(U118))-LEN(SUBSTITUTE(U118,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C118=\"X\",IF(AN118=\"\",\"Afectat sau NU?\",IF(AN118=\"DA\",((AG118+AH118)-(Z118+AA118))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C118=\"X\",IF(AN118<>\"DA\",\"-\",IF(AND(AN118=\"DA\",BL118<=0),LEN(TRIM(V118))-LEN(SUBSTITUTE(V118,CHAR(44),\"\"))+1+LEN(TRIM(U118))-LEN(SUBSTITUTE(U118,CHAR(44),\"\"))+1,0)),\"\")","v":""},{"$f":"IF(C118=\"X\",IF(AN118=\"DA\",LEN(TRIM(V118))-LEN(SUBSTITUTE(V118,CHAR(44),\"\"))+1+LEN(TRIM(U118))-LEN(SUBSTITUTE(U118,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""}]
[104,"X","-","Cuplare instalație tehnologică SRM Chișineu Criș la racord 8\" Chișineu Criș",9468,"Chișineu - Criș","Arad",234007.73,565309.06000000006,234007.73,565309.06000000006,"-","-","SM0356D0","SC Maricom Chișineu Criș III","-","-","-","-","SM-SD001","Aderro GP, Nova Power, Cez Vânzare, Cis Gaz, Conef Gaz, CPL Concordia, Crest Energy, Cyeb, Design Proiect, Distrigaz Vest, Engie, E.on Energie, Electrica Furnizare, Electric Planners, Electric&Gas, Energy Distribution, Enel Energie, Enel Muntenia, Gas&Power, Entrex, Premier Energy Trading, Gaz Est, Hargaz, Gazmir, Gaz Vest, Mihoc Oil, Met România, Monsson, Next Energy Distribution, Next Energy Partners, Pado Group, Premier Energy, Petrom, Prisma Serv, Gas Provider, Renovatio, Res Energy Solutions, Restart Energy, RWE Supply, SST Grup, Tetarom, Tinmar, Veolia, Wiee","Delgaz Grid","-","2021-01-05","09:00:00","2021-01-05","16:00:00","Arad","Efectuată",null,"2021-01-05","09:00:00","2021-01-05","16:25:00","2021-01-05","09:55:00","2021-01-05","09:38:00","12055/30.12.2020","DA",null,null,null,0.63333333330228925,1,1,0.91666666668606922,44,44,7.4166666667442769,0,0,null,null,null,null,null,"","","","","","","","",""]