{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["2022-2023"],"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":"2022-2023","index":0,"n_rows":109,"n_cols":72,"rows_kept":109,"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,"2022-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,"2022-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,"2022-12-26","Crăciun 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,"2023-01-02","Anul Nou a doua 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,"2023-01-24","Ziua Unirii Principatelor României"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-04-14","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,"parteneri adiacenti","UR",null,null,null,null,null,null,null,null,null,null,null,"parteneri adiacenti","UR",null,"2023-04-17","A doua zi de Paste Ortodox"]
["EVIDENȚA LIMITĂRILOR ȘI/SAU ÎNTRERUPERILOR PLANIFICATE ȘI NEPLANIFICATE pentru anul gazier 2022 - 2023 / RECORD OF THE PLANNED AND UNPLANNED LIMITATIONS AND/OR INTERRUPTIONS related to the gas year 2022 - 2023",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":41},{"$f":"SUBTOTAL(9,AV:AV)","v":1171},null,"Lucrari programate",null,null,null,null,null,null,null,null,"NU5",{"$f":"SUBTOTAL(9,BG:BG)","v":4},{"$f":"SUBTOTAL(9,BJ:BJ)","v":82},null,"2023-05-01","Ziua muncii"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":41},{"$f":"SUBTOTAL(9,AW:AW)","v":1171},null,"Partener adiacent",null,null,"UR",null,null,null,null,null,"NUafectati ",{"$f":"SUBTOTAL(9,BH:BH)","v":4},{"$f":"SUBTOTAL(9,BK:BK)","v":82},null,"2023-06-01","Ziua copilului"]
["Nr. crt. / Item No.","Tip limitare/întrerupere / \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","UR/operator de sistem adiacent afectat /\nAffected network user/adjacent system operator",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":1212},"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":86},"IP61",null,"2023-06-05","A doua zi de Rusalii"]
[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":1212},{"$f":"IF(BC12=0,1,BC11/BC12)","v":1},null,null,null,null,null,null,null,null,null,null,"NUafectati ",{"$f":"BP10+BQ10","v":86},{"$f":"IF(BP12=0,1,BP11/BP12)","v":1},null,"2023-08-15","Adormirea Maicii Domnului"]
[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":3},"IP52",null,null,null,null,null,null,null,null,null,null,"NUreluare",{"$f":"SUBTOTAL(9,BM:BM)","v":86},"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,"UR / Network user","Operator de sistem adiacent / Adjacent system operator",null,null,null,null,null,null,null,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":3},{"$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":86},{"$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":"A15+1","v":1},"-","x","Relocare și adaptare la teren a instalației tehnologice SRM Poroterom Orăștie pe locația SRM Baru",88001,"Baru","Hunedoara",357044.71,442838.66,357044.71,442838.66,"-","-","SM0314D0","Baru","-","-","-","-","SM-SD001",null,"Delgaz Grid","martie - aprilie 2023",null,null,null,null,"Arad",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI 2022_A5_1",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":"-"}]
[2,"-","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","martie - aprilie 2023",null,null,null,null,"Mediaș",null,"Replanificare - nu s-a obținut autorizația de construire, fiind probleme cu acordul proprietarilor de teren",null,null,null,null,null,null,null,null,null,null,null,"PMDI_2022_A9_7",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[{"$f":"A17+1","v":3},"-","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","martie - aprilie 2023",null,null,null,null,"Mediaș",null,"Replanificare - nu s-a obținut autorizația de construire, fiind probleme cu acordul proprietarilor de teren",null,null,null,null,null,null,null,null,null,null,null,"PMDI_2022_A9_3",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[4,"-","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","martie - aprilie 2023",null,null,null,null,"Mediaș",null,"Replanificare - nu s-a obținut autorizația de construire, fiind probleme cu acordul proprietarilor de teren",null,null,null,null,null,null,null,null,null,null,null,"PMDI_2022_A9_3",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[5,"-","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","martie - aprilie 2023",null,null,null,null,"Mediaș",null,"Replanificare - nu s-a obținut autorizația de construire, fiind probleme cu acordul proprietarilor de teren",null,null,null,null,null,null,null,null,null,null,null,"PMDI_2022_A9_3",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[6,"-","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","martie - aprilie 2023",null,null,null,null,"Mediaș",null,"Replanificare - nu s-a obținut autorizația de construire, fiind probleme cu acordul proprietarilor de teren",null,null,null,null,null,null,null,null,null,null,null,"PMDI_2022_A9_3",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[7,"-","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","martie - aprilie 2023",null,null,null,null,"Mediaș",null,"Replanificare - nu s-a obținut autorizația de construire, fiind probleme cu acordul proprietarilor de teren",null,null,null,null,null,null,null,null,null,null,null,"PMDI_2022_A9_3",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[{"$f":"A22+1","v":8},"-","x","SRM Moinești I (Dealu Mare) racordare la SNTGN respectiv la Sistemul de distribuție gaze naturale",20885,"Moinești","Bacău",613113.21,553437.6,613113.21,553437.6,"-","-","SM0440D0","Moinești I Dealu Mare","-","-","-","-","SM-SD001",null,"Delgaz Grid","martie - aprilie 2023",null,null,null,null,"Bacău",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2022_A5_13",null,{"$f":"IF(B23=\"X\",IF(AN23=\"\",\"Afectat sau NU?\",IF(AN23=\"DA\",IF(((AK23+AL23)-(AE23+AF23))*24<-720,\"Neinformat\",((AK23+AL23)-(AE23+AF23))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B23=\"X\",IF(AN23=\"DA\",IF(AR23<6,LEN(TRIM(V23))-LEN(SUBSTITUTE(V23,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B23=\"X\",IF(AN23=\"DA\",LEN(TRIM(V23))-LEN(SUBSTITUTE(V23,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B23=\"X\",IF(AN23=\"\",\"Afectat sau NU?\",IF(AN23=\"DA\",IF(((AI23+AJ23)-(AE23+AF23))*24<-720,\"Neinformat\",((AI23+AJ23)-(AE23+AF23))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B23=\"X\",IF(AN23=\"DA\",IF(AU23<6,LEN(TRIM(U23))-LEN(SUBSTITUTE(U23,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B23=\"X\",IF(AN23=\"DA\",LEN(TRIM(U23))-LEN(SUBSTITUTE(U23,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B23=\"X\",IF(AN23=\"\",\"Afectat sau NU?\",IF(AN23=\"DA\",((AG23+AH23)-(AE23+AF23))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B23=\"X\",IF(AN23=\"DA\",IF(AX23>24,IF(BA23=\"NU\",0,LEN(TRIM(V23))-LEN(SUBSTITUTE(V23,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":""},{"$f":"IF(B23=\"X\",IF(AN23=\"DA\",IF(AX23>24,LEN(TRIM(V23))-LEN(SUBSTITUTE(V23,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(C23=\"X\",IF(AN23=\"\",\"Afectat sau NU?\",IF(AN23=\"DA\",IF(AK23=\"\",\"Neinformat\",NETWORKDAYS(AK23+AL23,AE23+AF23,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C23=\"X\",IF(AN23=\"DA\",IF(AND(BF23>=5,AK23<>\"\"),LEN(TRIM(V23))-LEN(SUBSTITUTE(V23,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C23=\"X\",IF(AN23=\"DA\",LEN(TRIM(V23))-LEN(SUBSTITUTE(V23,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C23=\"X\",IF(AN23=\"\",\"Afectat sau NU?\",IF(AN23=\"DA\",IF(AI23=\"\",\"Neinformat\",NETWORKDAYS(AI23+AJ23,AE23+AF23,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C23=\"X\",IF(AN23=\"DA\",IF(AND(BI23>=5,AI23<>\"\"),LEN(TRIM(U23))-LEN(SUBSTITUTE(U23,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C23=\"X\",IF(AN23=\"DA\",LEN(TRIM(U23))-LEN(SUBSTITUTE(U23,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C23=\"X\",IF(AN23=\"\",\"Afectat sau NU?\",IF(AN23=\"DA\",((AG23+AH23)-(Z23+AA23))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C23=\"X\",IF(AN23<>\"DA\",\"-\",IF(AND(AN23=\"DA\",BL23<=0),LEN(TRIM(V23))-LEN(SUBSTITUTE(V23,CHAR(44),\"\"))+1+LEN(TRIM(U23))-LEN(SUBSTITUTE(U23,CHAR(44),\"\"))+1,0)),\"\")","v":"-"},{"$f":"IF(C23=\"X\",IF(AN23=\"DA\",LEN(TRIM(V23))-LEN(SUBSTITUTE(V23,CHAR(44),\"\"))+1+LEN(TRIM(U23))-LEN(SUBSTITUTE(U23,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"}]
[{"$f":"A23+1","v":9},"-","x","SRM Moinești I (Dealu Mare) racordare la SNTGN respectiv la Sistemul de distribuție gaze naturale",20885,"Moinești","Bacău",612206.31999999995,550311.31999999995,612206.31999999995,550311.31999999995,"-","-","SM0437D0","Moinești II Văsâiești","-","-","-","-","SM-SD001",null,"Delgaz Grid","martie - aprilie 2023",null,null,null,null,"Bacău",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2022_A5_13",null,{"$f":"IF(B24=\"X\",IF(AN24=\"\",\"Afectat sau NU?\",IF(AN24=\"DA\",IF(((AK24+AL24)-(AE24+AF24))*24<-720,\"Neinformat\",((AK24+AL24)-(AE24+AF24))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B24=\"X\",IF(AN24=\"DA\",IF(AR24<6,LEN(TRIM(V24))-LEN(SUBSTITUTE(V24,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B24=\"X\",IF(AN24=\"DA\",LEN(TRIM(V24))-LEN(SUBSTITUTE(V24,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B24=\"X\",IF(AN24=\"\",\"Afectat sau NU?\",IF(AN24=\"DA\",IF(((AI24+AJ24)-(AE24+AF24))*24<-720,\"Neinformat\",((AI24+AJ24)-(AE24+AF24))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B24=\"X\",IF(AN24=\"DA\",IF(AU24<6,LEN(TRIM(U24))-LEN(SUBSTITUTE(U24,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B24=\"X\",IF(AN24=\"DA\",LEN(TRIM(U24))-LEN(SUBSTITUTE(U24,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B24=\"X\",IF(AN24=\"\",\"Afectat sau NU?\",IF(AN24=\"DA\",((AG24+AH24)-(AE24+AF24))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B24=\"X\",IF(AN24=\"DA\",IF(AX24>24,IF(BA24=\"NU\",0,LEN(TRIM(V24))-LEN(SUBSTITUTE(V24,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":""},{"$f":"IF(B24=\"X\",IF(AN24=\"DA\",IF(AX24>24,LEN(TRIM(V24))-LEN(SUBSTITUTE(V24,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},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","Modernizare Instalație Tehnologică SRMP Arad I",9271,"Arad","Arad",216711.59,524249.53,216711.59,524249.53,"-","-","SM0349D0","Arad I","-","-","-","-","SM-SD001",null,"Delgaz Grid","octombrie - decembrie 2022",null,null,null,null,"Arad",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2022_A5_14",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[11,"-","x","Conducta de transport gaze naturale Sighetu Marmației - Borșa",106398,"Sărăsău","Maramureș",412768.47,716349.94,412768.47,716349.94,"-","-","SM0992D0","Sighetu Marmației","-","-","-","-","SM-SD001",null,"Berg Sistem Gaz","octombrie - decembrie 2022",null,null,null,null,"Cluj",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2022_A17_5",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[12,"-","x","Conducta de transport gaze naturale SRM Timișoara I – SRM Timișoara III (inclusiv alimentare cu energie electrică, protecție catodică și fibră optică)",157013,"Foeni","Timiș",175362.53,453811.08,175362.53,453811.08,"-","-","SM1143D0","Foeni-Petrom","-","-","-","-","SM-CF001",null,"Petrom","aprilie - iunie 2023",null,null,null,null,"Arad",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2022_A3_8",null,{"$f":"IF(B27=\"X\",IF(AN27=\"\",\"Afectat sau NU?\",IF(AN27=\"DA\",IF(((AK27+AL27)-(AE27+AF27))*24<-720,\"Neinformat\",((AK27+AL27)-(AE27+AF27))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B27=\"X\",IF(AN27=\"DA\",IF(AR27<6,LEN(TRIM(V27))-LEN(SUBSTITUTE(V27,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B27=\"X\",IF(AN27=\"DA\",LEN(TRIM(V27))-LEN(SUBSTITUTE(V27,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B27=\"X\",IF(AN27=\"\",\"Afectat sau NU?\",IF(AN27=\"DA\",IF(((AI27+AJ27)-(AE27+AF27))*24<-720,\"Neinformat\",((AI27+AJ27)-(AE27+AF27))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B27=\"X\",IF(AN27=\"DA\",IF(AU27<6,LEN(TRIM(U27))-LEN(SUBSTITUTE(U27,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B27=\"X\",IF(AN27=\"DA\",LEN(TRIM(U27))-LEN(SUBSTITUTE(U27,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B27=\"X\",IF(AN27=\"\",\"Afectat sau NU?\",IF(AN27=\"DA\",((AG27+AH27)-(AE27+AF27))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B27=\"X\",IF(AN27=\"DA\",IF(AX27>24,IF(BA27=\"NU\",0,LEN(TRIM(V27))-LEN(SUBSTITUTE(V27,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":""},{"$f":"IF(B27=\"X\",IF(AN27=\"DA\",IF(AX27>24,LEN(TRIM(V27))-LEN(SUBSTITUTE(V27,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(C27=\"X\",IF(AN27=\"\",\"Afectat sau NU?\",IF(AN27=\"DA\",IF(AK27=\"\",\"Neinformat\",NETWORKDAYS(AK27+AL27,AE27+AF27,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C27=\"X\",IF(AN27=\"DA\",IF(AND(BF27>=5,AK27<>\"\"),LEN(TRIM(V27))-LEN(SUBSTITUTE(V27,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C27=\"X\",IF(AN27=\"DA\",LEN(TRIM(V27))-LEN(SUBSTITUTE(V27,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C27=\"X\",IF(AN27=\"\",\"Afectat sau NU?\",IF(AN27=\"DA\",IF(AI27=\"\",\"Neinformat\",NETWORKDAYS(AI27+AJ27,AE27+AF27,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C27=\"X\",IF(AN27=\"DA\",IF(AND(BI27>=5,AI27<>\"\"),LEN(TRIM(U27))-LEN(SUBSTITUTE(U27,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C27=\"X\",IF(AN27=\"DA\",LEN(TRIM(U27))-LEN(SUBSTITUTE(U27,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C27=\"X\",IF(AN27=\"\",\"Afectat sau NU?\",IF(AN27=\"DA\",((AG27+AH27)-(Z27+AA27))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C27=\"X\",IF(AN27<>\"DA\",\"-\",IF(AND(AN27=\"DA\",BL27<=0),LEN(TRIM(V27))-LEN(SUBSTITUTE(V27,CHAR(44),\"\"))+1+LEN(TRIM(U27))-LEN(SUBSTITUTE(U27,CHAR(44),\"\"))+1,0)),\"\")","v":"-"},{"$f":"IF(C27=\"X\",IF(AN27=\"DA\",LEN(TRIM(V27))-LEN(SUBSTITUTE(V27,CHAR(44),\"\"))+1+LEN(TRIM(U27))-LEN(SUBSTITUTE(U27,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"}]
[13,"-","x","Conducta de transport gaze naturale SRM Timișoara I – SRM Timișoara III (inclusiv alimentare cu energie electrică, protecție catodică și fibră optică)",158788,"Șag","Timiș",200431.79,468711.36,200431.79,468711.36,"-","-","SM0881D0","Șag","-","-","-","-","SM-SD001",null,"Gaz Vest","aprilie - iunie 2023",null,null,null,null,"Arad",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2022_A3_8",null,{"$f":"IF(B28=\"X\",IF(AN28=\"\",\"Afectat sau NU?\",IF(AN28=\"DA\",IF(((AK28+AL28)-(AE28+AF28))*24<-720,\"Neinformat\",((AK28+AL28)-(AE28+AF28))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B28=\"X\",IF(AN28=\"DA\",IF(AR28<6,LEN(TRIM(V28))-LEN(SUBSTITUTE(V28,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B28=\"X\",IF(AN28=\"DA\",LEN(TRIM(V28))-LEN(SUBSTITUTE(V28,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B28=\"X\",IF(AN28=\"\",\"Afectat sau NU?\",IF(AN28=\"DA\",IF(((AI28+AJ28)-(AE28+AF28))*24<-720,\"Neinformat\",((AI28+AJ28)-(AE28+AF28))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B28=\"X\",IF(AN28=\"DA\",IF(AU28<6,LEN(TRIM(U28))-LEN(SUBSTITUTE(U28,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B28=\"X\",IF(AN28=\"DA\",LEN(TRIM(U28))-LEN(SUBSTITUTE(U28,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B28=\"X\",IF(AN28=\"\",\"Afectat sau NU?\",IF(AN28=\"DA\",((AG28+AH28)-(AE28+AF28))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B28=\"X\",IF(AN28=\"DA\",IF(AX28>24,IF(BA28=\"NU\",0,LEN(TRIM(V28))-LEN(SUBSTITUTE(V28,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":""},{"$f":"IF(B28=\"X\",IF(AN28=\"DA\",IF(AX28>24,LEN(TRIM(V28))-LEN(SUBSTITUTE(V28,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},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","Conducta de transport gaze naturale SRM Timișoara I – SRM Timișoara III (inclusiv alimentare cu energie electrică, protecție catodică și fibră optică)",158074,"Peciu Nou","Timiș",193049.58,463240.68,193049.58,463240.68,"-","-","SM0335D0","Peciu Nou","-","-","-","-","SM-SD001",null,"Gaz Vest","aprilie - iunie 2023",null,null,null,null,"Arad",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2022_A3_8",null,{"$f":"IF(B29=\"X\",IF(AN29=\"\",\"Afectat sau NU?\",IF(AN29=\"DA\",IF(((AK29+AL29)-(AE29+AF29))*24<-720,\"Neinformat\",((AK29+AL29)-(AE29+AF29))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B29=\"X\",IF(AN29=\"DA\",IF(AR29<6,LEN(TRIM(V29))-LEN(SUBSTITUTE(V29,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B29=\"X\",IF(AN29=\"DA\",LEN(TRIM(V29))-LEN(SUBSTITUTE(V29,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B29=\"X\",IF(AN29=\"\",\"Afectat sau NU?\",IF(AN29=\"DA\",IF(((AI29+AJ29)-(AE29+AF29))*24<-720,\"Neinformat\",((AI29+AJ29)-(AE29+AF29))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B29=\"X\",IF(AN29=\"DA\",IF(AU29<6,LEN(TRIM(U29))-LEN(SUBSTITUTE(U29,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B29=\"X\",IF(AN29=\"DA\",LEN(TRIM(U29))-LEN(SUBSTITUTE(U29,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B29=\"X\",IF(AN29=\"\",\"Afectat sau NU?\",IF(AN29=\"DA\",((AG29+AH29)-(AE29+AF29))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B29=\"X\",IF(AN29=\"DA\",IF(AX29>24,IF(BA29=\"NU\",0,LEN(TRIM(V29))-LEN(SUBSTITUTE(V29,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":""},{"$f":"IF(B29=\"X\",IF(AN29=\"DA\",IF(AX29>24,LEN(TRIM(V29))-LEN(SUBSTITUTE(V29,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(C29=\"X\",IF(AN29=\"\",\"Afectat sau NU?\",IF(AN29=\"DA\",IF(AK29=\"\",\"Neinformat\",NETWORKDAYS(AK29+AL29,AE29+AF29,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C29=\"X\",IF(AN29=\"DA\",IF(AND(BF29>=5,AK29<>\"\"),LEN(TRIM(V29))-LEN(SUBSTITUTE(V29,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C29=\"X\",IF(AN29=\"DA\",LEN(TRIM(V29))-LEN(SUBSTITUTE(V29,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C29=\"X\",IF(AN29=\"\",\"Afectat sau NU?\",IF(AN29=\"DA\",IF(AI29=\"\",\"Neinformat\",NETWORKDAYS(AI29+AJ29,AE29+AF29,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C29=\"X\",IF(AN29=\"DA\",IF(AND(BI29>=5,AI29<>\"\"),LEN(TRIM(U29))-LEN(SUBSTITUTE(U29,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C29=\"X\",IF(AN29=\"DA\",LEN(TRIM(U29))-LEN(SUBSTITUTE(U29,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C29=\"X\",IF(AN29=\"\",\"Afectat sau NU?\",IF(AN29=\"DA\",((AG29+AH29)-(Z29+AA29))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C29=\"X\",IF(AN29<>\"DA\",\"-\",IF(AND(AN29=\"DA\",BL29<=0),LEN(TRIM(V29))-LEN(SUBSTITUTE(V29,CHAR(44),\"\"))+1+LEN(TRIM(U29))-LEN(SUBSTITUTE(U29,CHAR(44),\"\"))+1,0)),\"\")","v":"-"},{"$f":"IF(C29=\"X\",IF(AN29=\"DA\",LEN(TRIM(V29))-LEN(SUBSTITUTE(V29,CHAR(44),\"\"))+1+LEN(TRIM(U29))-LEN(SUBSTITUTE(U29,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"}]
[15,"-","x","Conducta de transport gaze naturale SRM Timișoara I – SRM Timișoara III (inclusiv alimentare cu energie electrică, protecție catodică și fibră optică)",155332,"Chișoda","Timiș",206214.98,473806.07,206214.98,473806.07,"-","-","SM0345D0","Chișoda","-","-","-","-","SM-SD001",null,"Delgaz Grid","aprilie - iunie 2023",null,null,null,null,"Arad",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2022_A3_8",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[16,"-","x","Conducta de transport gaze naturale SRM Timișoara I – SRM Timișoara III (inclusiv alimentare cu energie electrică, protecție catodică și fibră optică)",155252,"Timișoara","Timiș",203127.23,474111.4,203127.23,474111.4,"-","-","SM0343D0","SC Monlandy`s Timișoara","-","-","-","-","SM-CF001",null,"Monlandys","aprilie - iunie 2023",null,null,null,null,"Arad",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2022_A3_8",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[17,"-","x","Conducta de transport gaze naturale SRM Timișoara I – SRM Timișoara III (inclusiv alimentare cu energie electrică, protecție catodică și fibră optică)",155252,"Timișoara","Timiș",203448.03,473777.64,203448.03,473777.64,"-","-"," SM0337D0","SC Incontro I Timișoara","-","-","-","-","SM-CF001",null,"Incontro Prefabricați","aprilie - iunie 2023",null,null,null,null,"Arad",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2022_A3_8",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","Conducta de transport gaze naturale SRM Timișoara I – SRM Timișoara III (inclusiv alimentare cu energie electrică, protecție catodică și fibră optică)",155252,"Timișoara","Timiș",202928.22,474518.16,202928.22,474518.16,"-","-","SM0895D0","SC Agro Imobiliare Timișoara","-","-","-","-","SM-CF001",null,"Agro Imobiliare","aprilie - iunie 2023",null,null,null,null,"Arad",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2022_A3_8",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[19,"-","x","Conducta de transport gaze naturale SRM Timișoara I – SRM Timișoara III (inclusiv alimentare cu energie electrică, protecție catodică și fibră optică)",155252,"Timișoara","Timiș",203128.51,474110.73,203128.51,474110.73,"-","-","SM0342D0","SC IMP Romania Industrial Timișoara","-","-","-","-","SM-CF001",null,"IMP România Industrial","aprilie - iunie 2023",null,null,null,null,"Arad",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2022_A3_8",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[20,"-","x","Conducta de transport gaze naturale SRM Timișoara I – SRM Timișoara III (inclusiv alimentare cu energie electrică, protecție catodică și fibră optică)",158724,"Utvin","Timiș",199343.46,475200,199343.46,475200,"-","-","SM1021D0","Utvin","-","-","-","-","SM-SD001",null,"Premier Energy","aprilie - iunie 2023",null,null,null,null,"Arad",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2022_A3_8",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[21,"-","x","Conducta de transport gaze naturale SRM Timișoara I – SRM Timișoara III (inclusiv alimentare cu energie electrică, protecție catodică și fibră optică)",155252,"Timișoara","Timiș",201059.01,477033.06,201059.01,477033.06,"-","-","SM0338D0","Timișoara III","-","-","-","-","SM-SD001",null,"Delgaz Grid","aprilie - iunie 2023",null,null,null,null,"Arad",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2022_A3_8",null,{"$f":"IF(B36=\"X\",IF(AN36=\"\",\"Afectat sau NU?\",IF(AN36=\"DA\",IF(((AK36+AL36)-(AE36+AF36))*24<-720,\"Neinformat\",((AK36+AL36)-(AE36+AF36))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B36=\"X\",IF(AN36=\"DA\",IF(AR36<6,LEN(TRIM(V36))-LEN(SUBSTITUTE(V36,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B36=\"X\",IF(AN36=\"DA\",LEN(TRIM(V36))-LEN(SUBSTITUTE(V36,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B36=\"X\",IF(AN36=\"\",\"Afectat sau NU?\",IF(AN36=\"DA\",IF(((AI36+AJ36)-(AE36+AF36))*24<-720,\"Neinformat\",((AI36+AJ36)-(AE36+AF36))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B36=\"X\",IF(AN36=\"DA\",IF(AU36<6,LEN(TRIM(U36))-LEN(SUBSTITUTE(U36,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B36=\"X\",IF(AN36=\"DA\",LEN(TRIM(U36))-LEN(SUBSTITUTE(U36,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B36=\"X\",IF(AN36=\"\",\"Afectat sau NU?\",IF(AN36=\"DA\",((AG36+AH36)-(AE36+AF36))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B36=\"X\",IF(AN36=\"DA\",IF(AX36>24,IF(BA36=\"NU\",0,LEN(TRIM(V36))-LEN(SUBSTITUTE(V36,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":""},{"$f":"IF(B36=\"X\",IF(AN36=\"DA\",IF(AX36>24,LEN(TRIM(V36))-LEN(SUBSTITUTE(V36,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(C36=\"X\",IF(AN36=\"\",\"Afectat sau NU?\",IF(AN36=\"DA\",IF(AK36=\"\",\"Neinformat\",NETWORKDAYS(AK36+AL36,AE36+AF36,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C36=\"X\",IF(AN36=\"DA\",IF(AND(BF36>=5,AK36<>\"\"),LEN(TRIM(V36))-LEN(SUBSTITUTE(V36,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C36=\"X\",IF(AN36=\"DA\",LEN(TRIM(V36))-LEN(SUBSTITUTE(V36,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C36=\"X\",IF(AN36=\"\",\"Afectat sau NU?\",IF(AN36=\"DA\",IF(AI36=\"\",\"Neinformat\",NETWORKDAYS(AI36+AJ36,AE36+AF36,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C36=\"X\",IF(AN36=\"DA\",IF(AND(BI36>=5,AI36<>\"\"),LEN(TRIM(U36))-LEN(SUBSTITUTE(U36,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C36=\"X\",IF(AN36=\"DA\",LEN(TRIM(U36))-LEN(SUBSTITUTE(U36,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C36=\"X\",IF(AN36=\"\",\"Afectat sau NU?\",IF(AN36=\"DA\",((AG36+AH36)-(Z36+AA36))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C36=\"X\",IF(AN36<>\"DA\",\"-\",IF(AND(AN36=\"DA\",BL36<=0),LEN(TRIM(V36))-LEN(SUBSTITUTE(V36,CHAR(44),\"\"))+1+LEN(TRIM(U36))-LEN(SUBSTITUTE(U36,CHAR(44),\"\"))+1,0)),\"\")","v":"-"},{"$f":"IF(C36=\"X\",IF(AN36=\"DA\",LEN(TRIM(V36))-LEN(SUBSTITUTE(V36,CHAR(44),\"\"))+1+LEN(TRIM(U36))-LEN(SUBSTITUTE(U36,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"}]
[22,"-","x","Conducta de transport gaze naturale SRM Timișoara I – SRM Timișoara III (inclusiv alimentare cu energie electrică, protecție catodică și fibră optică)",157353,"Săcălaz","Timiș",196586.45,479174.93,196586.45,479174.93,"-","-","SM1028D0","Săcălaz","-","-","-","-","SM-SD001",null,"Gaz Vest","aprilie - iunie 2023",null,null,null,null,"Arad",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2022_A3_8",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":"-"}]
[23,"-","x","Înlocuire subtraversare DJ, CF Centura București și CF Progresu a conductei de transport gaze naturale DN 700 Inel București, tronson Moara Domnească – Măgurele",101154,"Berceni","Ilfov",593357.13,315818.77,593357.13,315818.77,"-","-","SM0907D0","Berceni IF","-","-","-","-","SM-SD001",null,"Progaz","aprilie - iunie 2023",null,null,null,null,"București",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2022_A3_12",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[{"$f":"SUM(1,A38)","v":24},"-","x","Înlocuire subtraversare DJ, CF Centura București și CF Progresu a conductei de transport gaze naturale DN 700 Inel București, tronson Moara Domnească – Măgurele",105945,"Vidra","Ilfov",588819.98,315459.76,588819.98,315459.76,"-","-","SM0152D0","Vidra","-","-","-","-","SM-SD001",null,"Distrigaz Sud Rețele","aprilie - iunie 2023",null,null,null,null,"București",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2022_A3_12",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[25,"-","x","Înlocuire subtraversare DJ, CF Centura București și CF Progresu a conductei de transport gaze naturale DN 700 Inel București, tronson Moara Domnească – Măgurele",179392,"Jilava","Ilfov",586543.5,317539.43,586543.5,317539.43,"-","-","SM1051D0","Jilava","-","-","-","-","SM-SD001",null,"Distrigaz Sud Rețele","aprilie - iunie 2023",null,null,null,null,"București",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI_2022_A3_12",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[26,"-","x","Înlocuire robinet 20” cuplare racord SRM Balotești",100978,"Balotești ","Ilfov",589605.26,346450.65,589605.26,346450.65,"-","-","SM0198D0","Balotești ","-","-","-","-","SM-SD001",null,"SC Megaconstruct SA","mai - septembrie 2023",null,null,null,null,"București",null,null,null,null,null,null,null,null,null,null,null,null,null,"Plan lucrări SM 2021, cap.A",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[27,"-","x","Înlocuire robinet 20” cuplare racord SRM Balotești",105179,"Snagov","Ilfov",589606.49,346458.63,589606.49,346458.63,"-","-","SM0922D0","Snagov","-","-","-","-","SM-SD001",null,"Premier Energy","mai - septembrie 2023",null,null,null,null,"București",null,null,null,null,null,null,null,null,null,null,null,null,null,"Plan lucrări SM 2021, cap.A",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[28,"-","x","Înlocuire robinet 20” cuplare racord SRM Balotești",102179,"Corbeanca","Ilfov",582902.09,344014.84,582902.09,344014.84,"-","-","SM0148D0","Corbeanca","-","-","-","-","SM-SD001",null," Distrigaz Sud Rețele","mai - septembrie 2023",null,null,null,null,"București",null,null,null,null,null,null,null,null,null,null,null,null,null,"Plan lucrări SM 2021, cap.A",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[29,"-","x","Modernizare/Sistematizare instalație tehnologică SRM Tunari",105589,"Tunari","Ilfov",590859.85,338211.21,590859.85,338211.21,"-","-","SM0168D0","București Tunari","-","-","-","-","SM-SD001",null," Distrigaz Sud Rețele","mai - septembrie 2023",null,null,null,null,"București",null,null,null,null,null,null,null,null,null,null,null,null,null,"Plan lucrări SM 2021, cap.A",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[30,"-","x","Modernizare/Sistematizare instalație tehnologică SRM Tunari",105589,"Tunari","Ilfov",590859.85,338211.21,590859.85,338211.21,"-","-","SM0168D1","Cartier Pipera","-","-","-","-","SM-SD001",null,"Premier Energy","mai - septembrie 2023",null,null,null,null,"București",null,null,null,null,null,null,null,null,null,null,null,null,null,"Plan lucrări SM 2021, cap.A",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[31,"-","x","Interconectare 32\" Moșu - Podișor cu 16\" Gura Șuții, zona Slobozia Moara și relocare Rv16 cu refulator.",68636,"Răcari","Dâmbovița",557141.14,348301.15,557141.14,348301.15,"-","-","SM0145D0","Răcari","-","-","-","-","SM-SD001",null," Distrigaz Sud Rețele","mai - septembrie 2023",null,null,null,null,"București",null,null,null,null,null,null,null,null,null,null,null,null,null,"Forțe proprii/SM",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[32,"-","x","Interconectare 32\" Moșu - Podișor cu 16\" Gura Șuții, zona Slobozia Moara și relocare Rv16 cu refulator.",105543,"Tărtășești","Dâmbovița",564729.06000000006,341811.75,564729.06000000006,341811.75,"-","-","SM0112D0","Tărtășești","-","-","-","-","SM-SD001",null,"Premier Energy","mai - septembrie 2023",null,null,null,null,"București",null,null,null,null,null,null,null,null,null,null,null,null,null,"Forțe proprii/SM",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[33,"-","x","Interconectare 32\" Moșu - Podișor cu 16\" Gura Șuții, zona Slobozia Moara și relocare Rv16 cu refulator.",104038,"Săbăreni","Giurgiu",569107.28,334140.34999999998,569107.28,334140.34999999998,"-","-","SM1086D0","Joița","-","-","-","-","SM-SD001",null,"Euro Seven Industry","mai - septembrie 2023",null,null,null,null,"București",null,null,null,null,null,null,null,null,null,null,null,null,null,"Forțe proprii/SM",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[34,"-","x","Eliminare R7 pe conducta 28” Coroi - București, zona Posada",131381,"Posada","Prahova",548893.69999999995,420137.21,548893.69999999995,420137.21,"-","-","SM0081D0","Posada","-","-","-","-","SM-SD001",null,"Distrigaz Sud Rețele","mai - septembrie 2023",null,null,null,null,"București",null,null,null,null,null,null,null,null,null,null,null,null,null,"Plan lucrări SM 2021, cap.A + forțe proprii",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[35,"-","x","Înlocuire flanșă electroizolantă pe conducta 4” racord SRM Cornești II Crivățu",67069,"Crivățu","Dâmbovița",571928,361161.04,571928,361161.04,"-","-","SM0908D0","Cornești 2 Crivățu","-","-","-","-","SM-SD001",null,"Distrigaz Sud Rețele","mai - septembrie 2023",null,null,null,null,"București",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?","-","-"]
[36,"-","x","Înlocuire instalație mecanică la SRM Finta",67489,"Finta","Dâmbovița",563895,366569.11,563895,366569.11,"-","-","SM0141D0","Finta","-","-","-","-","SM-SD001",null,"Distrigaz Sud Rețele","mai - septembrie 2023",null,null,null,null,"București",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?","-","-"]
[37,"-","x","Înlocuire flansă electroizolantă pe racord SRM Vidra",105945,"Vidra","Ilfov",588819.98,315459.76,588819.98,315459.76,"-","-","SM0152D0","Vidra","-","-","-","-","SM-SD001",null,"Distrigaz Sud Rețele","mai - septembrie 2023",null,null,null,null,"București",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?","-","-"]
[38,"x","-","Înlocuire robinet defect la intrare în SRM Ilieni",64434,"Ilieni","Covasna",559093.5,478002.97,559093.5,478002.97,"-","-","SM0389D0","Ilieni","-","-","-","-","SM-SD001","Alpha Metal, Nova Power, Bepco, Cez Vânzare, Cis Gaz, Conef Gaz, Crest Energy, Distrigaz Sud Retele, Distrigaz Vest, Engie, E.on Energie, Electrocentrale București, Electrocentrale Constanța, Electrica Furnizare, Electric Planners, Energy Distribution, Enel Energie, Enel Muntenia, Entrex, Euro Seven, Eye Mall, Premier Energy Trading, Gaz Est, Getica 95, Met România, Monsson, MVM Future, Next Energy Distribution, Next Energy Partners, Nord Gaz, Premier Energy, Petrom, Gas Provider, Renovatio, Romgaz, RWE Supply, Sustainable Energy, Tinmar, Transenergo","Distrigaz Sud Rețele","-","2022-10-19","09:10:00","2022-10-19","17:00:00","Brașov","Efectuată",null,"2022-10-19","09:10:00","2022-10-19","17:00:00","2022-10-19","09:52:00","2022-10-19","09:31:00","1930/17.10.2022","DA",null,null,null,{"$f":"IF(B53=\"X\",IF(AN53=\"\",\"Afectat sau NU?\",IF(AN53=\"DA\",IF(((AK53+AL53)-(AE53+AF53))*24<-720,\"Neinformat\",((AK53+AL53)-(AE53+AF53))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":0.34999999991850927},{"$f":"IF(B53=\"X\",IF(AN53=\"DA\",IF(AR53<6,LEN(TRIM(V53))-LEN(SUBSTITUTE(V53,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":1},{"$f":"IF(B53=\"X\",IF(AN53=\"DA\",LEN(TRIM(V53))-LEN(SUBSTITUTE(V53,CHAR(44),\"\"))+1,\"-\"),\"\")","v":1},{"$f":"IF(B53=\"X\",IF(AN53=\"\",\"Afectat sau NU?\",IF(AN53=\"DA\",IF(((AI53+AJ53)-(AE53+AF53))*24<-720,\"Neinformat\",((AI53+AJ53)-(AE53+AF53))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":0.70000000001164153},{"$f":"IF(B53=\"X\",IF(AN53=\"DA\",IF(AU53<6,LEN(TRIM(U53))-LEN(SUBSTITUTE(U53,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":39},{"$f":"IF(B53=\"X\",IF(AN53=\"DA\",LEN(TRIM(U53))-LEN(SUBSTITUTE(U53,CHAR(44),\"\"))+1,\"-\"),\"\")","v":39},{"$f":"IF(B53=\"X\",IF(AN53=\"\",\"Afectat sau NU?\",IF(AN53=\"DA\",((AG53+AH53)-(AE53+AF53))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":7.8333333333721384},{"$f":"IF(B53=\"X\",IF(AN53=\"DA\",IF(AX53>24,IF(BA53=\"NU\",0,LEN(TRIM(V53))-LEN(SUBSTITUTE(V53,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":0},{"$f":"IF(B53=\"X\",IF(AN53=\"DA\",IF(AX53>24,LEN(TRIM(V53))-LEN(SUBSTITUTE(V53,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":0},null,null,null,null,null,{"$f":"IF(C53=\"X\",IF(AN53=\"\",\"Afectat sau NU?\",IF(AN53=\"DA\",IF(AK53=\"\",\"Neinformat\",NETWORKDAYS(AK53+AL53,AE53+AF53,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C53=\"X\",IF(AN53=\"DA\",IF(AND(BF53>=5,AK53<>\"\"),LEN(TRIM(V53))-LEN(SUBSTITUTE(V53,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C53=\"X\",IF(AN53=\"DA\",LEN(TRIM(V53))-LEN(SUBSTITUTE(V53,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C53=\"X\",IF(AN53=\"\",\"Afectat sau NU?\",IF(AN53=\"DA\",IF(AI53=\"\",\"Neinformat\",NETWORKDAYS(AI53+AJ53,AE53+AF53,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C53=\"X\",IF(AN53=\"DA\",IF(AND(BI53>=5,AI53<>\"\"),LEN(TRIM(U53))-LEN(SUBSTITUTE(U53,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C53=\"X\",IF(AN53=\"DA\",LEN(TRIM(U53))-LEN(SUBSTITUTE(U53,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C53=\"X\",IF(AN53=\"\",\"Afectat sau NU?\",IF(AN53=\"DA\",((AG53+AH53)-(Z53+AA53))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C53=\"X\",IF(AN53<>\"DA\",\"-\",IF(AND(AN53=\"DA\",BL53<=0),LEN(TRIM(V53))-LEN(SUBSTITUTE(V53,CHAR(44),\"\"))+1+LEN(TRIM(U53))-LEN(SUBSTITUTE(U53,CHAR(44),\"\"))+1,0)),\"\")","v":""},{"$f":"IF(C53=\"X\",IF(AN53=\"DA\",LEN(TRIM(V53))-LEN(SUBSTITUTE(V53,CHAR(44),\"\"))+1+LEN(TRIM(U53))-LEN(SUBSTITUTE(U53,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""}]
[39,"x","-","Curățire cu PIG a conductei DN800 Șendreni - Butimanu",100692,"Urziceni","Ialomița",627362.46,359075.92,627362.46,359075.92,"-","-","SM1064D0","Urziceni Înmagazinat","-","-","-","-","VSM01","Alpha Metal, Nova Power, Azomures, Bepco, Berg Sistem, Cez Vânzare, Cis Gaz, Colterm, Conef Gaz, Cordun, CPL Concordia, MM Data, Delgaz, Distrigaz Vest, Engie, E.on Energie, Electrocentrale București, Electrocentrale Constanța, Electrica Furnizare, Energy Distribution, Enel Energie, Enel Muntenia, Entrex, Euro Seven, Eye Mall, Premier Energy Trading, Gas&Power, Gaz Est, Gaz Nord Est, Cet Govora, Instant Construct, Lord Energy, Megaconstruct, Mihoc Oil, Modern Calor, Met România, Termoenergetica București, MVM Future Energy, Next Energy Distribution, Next Energy Partners, Premier Energy, Petrom, Prisma Serv, Gas Provider, Romgaz, RWE Supply, Salgaz, Termo Calor, Termoficare Oradea, Tinmar, Termoelectrica Giurgiu, Vest Energo","Romgaz - Depogaz Ploiești","-","2022-10-20","02:07:00","2022-10-20","05:00:00","Brăila","Efectuată",null,"2022-10-20","02:07:00","2022-10-20","04:45:00","2022-10-20","02:28:00","2022-10-20","02:09:00","81965/18.10.2022","DA",null,null,null,3.3333333441987634E-2,1,1,0.35000000009313226,52,52,2.6333333333604969,0,0,null,null,null,null,null,"","","","","","","","",""]
[40,"x","-","Curățire cu PIG a conductei DN800 Șendreni - Butimanu",101573,"Butimanu","Dâmbovița",571023.43999999994,354405.72,571023.43999999994,354405.72,"-","-","SM1066D0","Butimanu Înmagazinat","-","-","-","-","VSM01","Alpha Metal, Nova Power, Azomures, Bepco, Berg Sistem, Cez Vânzare, Cis Gaz, Colterm, Conef Gaz, Cordun, CPL Concordia, MM Data, Delgaz, Distrigaz Vest, Engie, E.on Energie, Electrocentrale București, Electrocentrale Constanța, Electrica Furnizare, Energy Distribution, Enel Energie, Enel Muntenia, Entrex, Euro Seven, Eye Mall, Premier Energy Trading, Gas&Power, Gaz Est, Gaz Nord Est, Cet Govora, Instant Construct, Lord Energy, Megaconstruct, Mihoc Oil, Modern Calor, Met România, Termoenergetica București, MVM Future Energy, Next Energy Distribution, Next Energy Partners, Premier Energy, Petrom, Prisma Serv, Gas Provider, Romgaz, RWE Supply, Salgaz, Termo Calor, Termoficare Oradea, Tinmar, Termoelectrica Giurgiu, Vest Energo","Romgaz - Depogaz Ploiești","-","2022-10-20","08:37:00","2022-10-20","10:40:00","București","Efectuată",null,"2022-10-20","08:37:00","2022-10-20","10:03:00","2022-10-20","08:57:00","2022-10-20","08:50:00","82054/18.10.2022","DA",null,null,null,0.21666666667442769,1,1,0.33333333337213844,52,52,1.4333333332906477,0,0,null,null,null,null,null,"","","","","","","","",""]
[41,"x","-","Curățire cu PIG a conductei DN800 Șendreni - Butimanu",100692,"Urziceni","Ialomița",627362.46,359075.92,627362.46,359075.92,"-","-","SM1064D0","Urziceni Înmagazinat","-","-","-","-","VSM01","Alpha Metal, Nova Power, Azomures, Bepco, Berg Sistem, Cez Vânzare, Cis Gaz, Colterm, Conef Gaz, Cordun, CPL Concordia, MM Data, Delgaz, Distrigaz Vest, Engie, E.on Energie, Electrocentrale București, Electrocentrale Constanța, Electrica Furnizare, Energy Distribution, Enel Energie, Enel Muntenia, Entrex, Euro Seven, Eye Mall, Premier Energy Trading, Gas&Power, Gaz Est, Gazmir, Gaz Nord Est, Cet Govora, Instant Construct, Lord Energy, Megaconstruct, Mihoc Oil, Modern Calor, Met România, Termoenergetica București, MVM Future Energy, Next Energy Distribution, Next Energy Partners, Premier Energy, Petrom, Prisma Serv, Gas Provider, Romgaz, RWE Supply, Salgaz, Termo Calor, Termoficare Oradea, Tinmar, Termoelectrica Giurgiu, Vest Energo","Romgaz - Depogaz Ploiești","-","2022-10-27","03:00:00","2022-10-27","06:00:00","Brăila","Efectuată",null,"2022-10-27","03:00:00","2022-10-27","04:45:00","2022-10-27","03:18:00","2022-10-27","03:10:00","84038/25.10.2022","DA",null,null,null,0.16666666668606922,1,1,0.29999999993015081,53,53,1.7499999999417923,0,0,null,null,null,null,null,"","","","","","","","",""]
[42,"x","-","Curățire cu PIG a conductei DN800 Șendreni - Butimanu",101573,"Butimanu","Dâmbovița",571023.43999999994,354405.72,571023.44299999997,354405.72,"-","-","SM1066D0","Butimanu Înmagazinat","-","-","-","-","VSM01","Alpha Metal, Nova Power, Azomures, Bepco, Berg Sistem, Cez Vânzare, Cis Gaz, Colterm, Conef Gaz, Cordun, CPL Concordia, MM Data, Delgaz, Distrigaz Vest, Engie, E.on Energie, Electrocentrale București, Electrocentrale Constanța, Electrica Furnizare, Energy Distribution, Enel Energie, Enel Muntenia, Entrex, Euro Seven, Eye Mall, Premier Energy Trading, Gas&Power, Gaz Est, Gazmir, Gaz Nord Est, Cet Govora, Instant Construct, Lord Energy, Megaconstruct, Mihoc Oil, Modern Calor, Met România, Termoenergetica București, MVM Future Energy, Next Energy Distribution, Next Energy Partners, Premier Energy, Petrom, Prisma Serv, Gas Provider, Romgaz, RWE Supply, Salgaz, Termo Calor, Termoficare Oradea, Tinmar, Termoelectrica Giurgiu, Vest Energo","Romgaz - Depogaz Ploiești","-","2022-10-27","10:05:00","2022-10-27","12:00:00","București","Efectuată",null,"2022-10-27","10:05:00","2022-10-27","11:33:00","2022-10-27","08:57:00","2022-10-27","10:22:00","84053/25.10.2022","DA",null,null,null,0.28333333320915699,1,1,-1.1333333333604969,53,53,1.4666666665580124,0,0,null,null,null,null,null,"","","","","","","","",""]
[43,"x","-","Întrerupere accidentală SRM Carei I",136535,"Carei","Satu Mare",311106.3,688940.77,311106.3,688940.77,"-","-","SM0589D0","Carei I","-","-","-","-","SM-SD001","Nova Power, Cez Vânzare, CPL Concordia, Crest Energy, Delgaz, Design Proiect, Distrigaz Vest, Engie, Axpo, E.on Energie, Electrica Furnizare, Electric Planners, Energy Distribution, Enel Energie, Enel Muntenia, Entrex, Eye Mall, Premier Energy Trading, Gaz Est, Gazmir, Mihoc Oil, Met România, Monsson, MVM Future, Next Energy Distribution, Next Energy Partners, Premier Energy, Petrom, Prisma Serv, Gas Provider, Renovatio, Romgaz, RWE Supply, Tetarom, Tinmar","Delgaz Grid","-","2022-10-31","13:30:00","2022-10-31","17:00:00","Cluj","Efectuată",null,"2022-10-31","13:30:00","2022-10-31","17:00:00","2022-10-31","14:18:00","2022-10-31","14:02:00","-","DA",null,null,null,0.53333333332557231,1,1,0.79999999998835847,35,35,3.5000000000582077,0,0,null,null,null,null,null,"","","","","","","","",""]
[44,"x","-","Curățire cu PIG a conductei DN800 Șendreni - Butimanu",100692,"Urziceni","Ialomița",627362.46,359075.92,627362.46,359075.92,"-","-","-","-","-","-","PM0028","Urziceni Extras","VPM01","Alpha Metal, Alpha Project, Nova Power, AOT Energy, Azomures, Berg Sistem, Cez Vânzare, Cis Gaz, Conef Gaz, Cordun, CPL Concordia, MM Data, Delgaz, Distrigaz Vest, Engie, DXT International, E.on Energie, Electrocentrale București, Electrocentrale Constanța, Energy Distribution, Enel Energie, Enel Muntenia, Entrex, Euro Seven, Eye Mall, Premier Energy Trading, Gaz Est, Instant Construct, Megaconstruct, Mihoc Oil, Modern Calor, Met România, Termoenergetica București, MVM Future Energy, Next Energy Distribution, Premier Energy, Petrom, Gas Provider, Renovatio, Romgaz, RWE Supply, Sustainable Energy, Termoficare Oradea, Tinmar, Termoelectrica Giurgiu, Vest Energo","Romgaz - Depogaz Ploiești","-","2022-11-03","04:12:00","2022-11-03","07:15:00","Brăila","Efectuată",null,"2022-11-03","04:12:00","2022-11-03","05:30:00","2022-11-03","04:31:00","2022-11-03","04:14:00","86021/01.11.2022","DA",null,null,null,3.3333333267364651E-2,1,1,0.31666666665114462,46,46,1.2999999998719431,0,0,null,null,null,null,null,"","","","","","","","",""]
[45,"x","-","Remediere defect produs de persoane terțe pe conducta DN300 Urziceni - Călărași ",92578,"Călărași","Călărași",684827.36,306820.24,684827.36,306820.24,"-","-","SM1121D0","SC Donalam Călărași","-","-","-","-","SM-CF001","Engie","SC Donalam SRL","-","2022-11-09","19:03:00","2022-11-10","08:00:00","Brăila","Efectuată",null,"2022-11-09","19:03:00","2022-11-09","02:10:00","2022-11-09","19:10:00","2022-11-09","19:04:00","88891/09.11.2022","DA",null,null,null,1.6666666720993817E-2,1,1,0.11666666669771075,1,1,-16.883333333185874,0,0,null,null,null,null,null,"","","","","","","","",""]
[46,"x","-","Inspecție cu PIG de determinare a geometriei pe conducta DN800 Șendreni - Butimanu",100692,"Urziceni","Ialomița",627362.46,359075.92,627362.46,359075.92,"-","-","-","-","-","-","PM0028","Urziceni Extras","VPM01","Alpha Metal, Alpha Project, Nova Power, AOT Energy, Azomures, Berg Sistem, Cez Vânzare, Cis Gaz, Conef Gaz, Cordun, CPL Concordia, MM Data, Delgaz, Distrigaz Vest, Engie, DXT International, E.on Energie, Electrocentrale București, Electrocentrale Constanța, Energy Distribution, Enel Energie, Enel Muntenia, Entrex, Euro Seven, Eye Mall, Premier Energy Trading, Gaz Est, Instant Construct, Megaconstruct, Mihoc Oil, Modern Calor, Met România, Termoenergetica București, MVM Future Energy, Next Energy Distribution, Premier Energy, Petrom, Gas Provider, Renovatio, Romgaz, RWE Supply, Sustainable Energy, Termoficare Oradea, Tinmar, Termoelectrica Giurgiu, Vest Energo","Romgaz - Depogaz Ploiești","-","2022-11-11","03:45:00","2022-11-11","07:00:00","Brăila","Efectuată",null,"2022-11-11","03:45:00","2022-11-11","05:05:00","2022-11-11","04:00:00","2022-11-11","03:53:00","88580/09.11.2022","DA",null,null,null,0.13333333341870457,1,1,0.24999999994179234,46,46,1.3333333333139308,0,0,null,null,null,null,null,"","","","","","","","",""]
[47,"x","-","Înlocuire robinet sertar pană în SRM Petrotub Roman",120879,"Roman","Neamț",643792.36,608703.18000000005,643792.36,608703.18000000005,"-","-","SM0465D2","SC Elerom Roman","-","-","-","-","SM-CF001","Petrom","SC Elerom SA","-","2022-11-14","10:00:00","2022-11-14","16:00:00","Bacău","Efectuată",null,"2022-11-14","10:00:00","2022-11-14","16:00:00","2022-11-14","10:15:00","2022-11-14","10:06:00","89320/11.11.2022","DA",null,null,null,9.9999999976716936E-2,1,1,0.25000000011641532,1,1,6,0,0,null,null,null,null,null,"","","","","","","","",""]
[48,"x","-","Inspecție cu PIG inteligent a conductei DN800 Șendreni - Butimanu",100692,"Urziceni","Ialomița",627362.46,359075.92,627362.46,359075.92,"-","-","-","-","-","-","PM0028","Urziceni Extras","VPM01","Alpha Metal, Alpha Project, Nova Power, AOT Energy, Azomures, Berg Sistem, Cez Vânzare, Cis Gaz, Conef Gaz, Cordun, CPL Concordia, MM Data, Delgaz, Distrigaz Vest, Engie, DXT International, E.on Energie, Electrocentrale București, Electrocentrale Constanța, Energy Distribution, Enel Energie, Enel Muntenia, Entrex, Euro Seven, Eye Mall, Premier Energy Trading, Gaz Est, Instant Construct, Megaconstruct, Mihoc Oil, Modern Calor, Met România, Termoenergetica București, MVM Future Energy, Next Energy Distribution, Premier Energy, Petrom, Gas Provider, Renovatio, Romgaz, RWE Supply, Sustainable Energy, Termoficare Oradea, Tinmar, Termoelectrica Giurgiu, Vest Energo","Romgaz - Depogaz Ploiești","-","2022-11-17","04:35:00","2022-11-17","07:30:00","Brăila","Efectuată",null,"2022-11-17","04:35:00","2022-11-17","05:25:00","2022-11-17","04:45:00","2022-11-17","04:39:00","90537/15.11.2022","DA",null,null,null,6.6666666709352285E-2,1,1,0.16666666668606922,46,46,0.8333333334303461,0,0,null,null,null,null,null,"","","","","","","","",""]
[49,"x","-","Inspecție cu PIG inteligent a conductei DN800 Șendreni - Butimanu",101573,"Butimanu","Dâmbovița",571023.43999999994,354405.72,571023.44299999997,354405.72,"-","-","-","-","-","-","PM0040","Butimanu Extras","VPM01","Alpha Metal, Alpha Project, Nova Power, AOT Energy, Azomures, Berg Sistem, Cez Vânzare, Cis Gaz, Conef Gaz, Cordun, CPL Concordia, MM Data, Delgaz, Distrigaz Vest, Engie, DXT International, E.on Energie, Electrocentrale București, Electrocentrale Constanța, Energy Distribution, Enel Energie, Enel Muntenia, Entrex, Euro Seven, Eye Mall, Premier Energy Trading, Gaz Est, Instant Construct, Megaconstruct, Mihoc Oil, Modern Calor, Met România, Termoenergetica București, MVM Future Energy, Next Energy Distribution, Premier Energy, Petrom, Gas Provider, Renovatio, Romgaz, RWE Supply, Sustainable Energy, Termoficare Oradea, Tinmar, Termoelectrica Giurgiu, Vest Energo","Romgaz - Depogaz Ploiești","-","2022-11-17","11:42:00","2022-11-17","13:40:00","București","Efectuată",null,"2022-11-17","11:42:00","2022-11-17","13:09:00","2022-11-17","12:09:00","2022-11-17","11:42:00","90507/15.11.2022","DA",null,null,null,0,1,1,0.44999999989522621,46,46,1.4500000000116415,0,0,null,null,null,null,null,"","","","","","","","",""]
[50,"x","-","Înlocuire sistem de măsurare în SRM Hurezani",80515,"Hurezani","Gorj",394241.39,369194,394241.39,369194,"-","-","SM0135D0","Hurezani","-","-","-","-","SM-SD001","Alpha Metal, Nova Power, Bepco, Cez Vânzare, Cis Gaz, Conef Gaz, Crest Energy, Distrigaz Sud Retele, Distrigaz Vest, Engie, E.on Energie, Electrocentrale București, Electrocentrale Constanța, Electrica Furnizare, Electric Planners, Energy Distribution, Enel Energie, Enel Muntenia, Gas&Power, Entrex, Euro Seven, Eye Mall, Premier Energy Trading, Gaz Est, Getica 95, Met România, Monsson, Termoenergetica București, MVM Future, Next Energy Distribution, Next Energy Partners, Nord Gaz, Premier Energy, Petrom, Gas Provider, Renovatio, Romgaz, RWE Supply, Sustainable Energy, Termo Calor, Tinmar, Transenergo, Termoelectrica Giurgiu, Vest Energo","Distrigaz Sud Rețele","-","2022-11-17","11:05:00","2022-11-17","12:00:00","Craiova","Efectuată",null,"2022-11-17","11:05:00","2022-11-17","11:30:00","2022-11-17","11:20:00","2022-11-17","11:07:00","90899/17.11.2022","DA",null,null,null,3.3333333267364651E-2,1,1,0.24999999994179234,44,44,0.41666666662786156,0,0,null,null,null,null,null,"","","","","","","","",""]
[51,"x","-","Înlocuire regulator RPI și curățare filtru conic în SRM Fabrica de pâine Șerban Filipești",22585,"Filipești","Bacău",632633.77,526820.43999999994,632633.77,526820.43999999994,"-","-","SM0128D0","SC Fabrica de pâine Șerban","-","-","-","-","SM-CF001","E.on Energie","SC Fabrica de pâine Șerban SRL","-","2022-11-25","11:00:00","2022-11-25","15:30:00","Bacău","Efectuată",null,"2022-11-25","11:00:00","2022-11-25","15:15:00","2022-11-25","11:05:00","2022-11-25","11:00:00","92992/24.11.2022","DA",null,null,null,0,1,1,8.3333333255723119E-2,1,1,4.2499999998835847,0,0,null,null,null,null,null,"","","","","","","","",""]
[52,"x","-","Cuplare SRM Centrala Electrică Câmpia Turzii, nou",55366,"Câmpia Turzii","Cluj",411585.24,561567,411585.24,561567,"-","-","SM1306D0","Centrala Electrică Câmpia Turzii","-","-","-","-","SM-CF001","Nova Power","Nova Power","-","2022-11-29","08:15:00","2022-11-29","16:00:00","Cluj","Efectuată",null,"2022-11-29","08:15:00","2022-11-29","15:20:00","2022-11-29","08:39:00","2022-11-29","08:24:00","94135/28.11.2022","DA",null,null,null,0.1499999999650754,1,1,0.40000000008149073,1,1,7.0833333333721384,0,0,null,null,null,null,null,"","","","","","","","",""]
[53,"x","-","Întrerupere accidentală prin SRM Tălmăcel datorită avariei produsă pe conducta DN100 racord SRM Tălmăcel",145890,"Tălmăcel","Sibiu",441290.5,461208.57,441290.5,461208.57,"-","-","SM0735D0","Tălmăcel","-","-","-","-","SM-SD001","Nova Power, Cez Vânzare, Colterm, CPL Concordia, Crest Energy, Delgaz, Design Proiect, Distrigaz Vest, Engie, Axpo, E.on Energie, Electrica Furnizare, Electric Planners, Energy Distribution, Enel Energie, Enel Muntenia, Gas&Power, Entrex, Eye Mall, Premier Energy Trading, Gaz Est, Gazmir, Mihoc Oil, Met România, Monsson, MVM Future, Next Energy Distribution, Next Energy Partners, Premier Energy, Petrom, Prisma Serv, Gas Provider, Renovatio, Romgaz, RWE Supply, Tetarom, Tinmar","Delgaz Grid","-","2022-11-30","10:15:00","2022-11-30","17:00:00","Mediaș","Efectuată",null,"2022-11-30","10:15:00","2022-11-30","16:35:00","2022-11-30","11:05:00","2022-11-30","10:50:00","-","DA",null,null,null,0.58333333331393078,1,1,0.83333333325572312,37,37,6.3333333331975155,0,0,null,null,null,null,null,"","","","","","","","",""]
[54,"x","-","Întrerupere accidentală prin SRM Tălmăcel II datorită avariei produsă pe conducta DN100 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","Nova Power, Cez Vânzare, Colterm, CPL Concordia, Crest Energy, Delgaz, Design Proiect, Distrigaz Vest, Engie, Axpo, E.on Energie, Electrica Furnizare, Electric Planners, Energy Distribution, Enel Energie, Enel Muntenia, Gas&Power, Entrex, Eye Mall, Premier Energy Trading, Gaz Est, Gazmir, Mihoc Oil, Met România, Monsson, MVM Future, Next Energy Distribution, Next Energy Partners, Premier Energy, Petrom, Prisma Serv, Gas Provider, Renovatio, Romgaz, RWE Supply, Tetarom, Tinmar","Delgaz Grid","-","2022-11-30","10:15:00","2022-11-30","17:00:00","Mediaș","Efectuată",null,"2022-11-30","10:15:00","2022-11-30","16:35:00","2022-11-30","11:05:00","2022-11-30","10:50:00","-","NU",null,null,null,"Nu a fost afectat producator/consumator","-","-","Nu a fost afectat producator/consumator","-","-","Nu a fost afectat producator/consumator","-","-",null,null,null,null,null,"","","","","","","","",""]
[55,"x","-","Întrerupere accidentală prin SRM Boița datorită avariei produsă pe conducta DN100 racord SRM Tălmăcel",145845,"Boița","Sibiu",442446.2,460048.52,442446.2,460048.52,"-","-","SM0736D0","Boița","-","-","-","-","SM-SD001","Nova Power, Cez Vânzare, Colterm, CPL Concordia, Crest Energy, Delgaz, Design Proiect, Distrigaz Vest, Engie, Axpo, E.on Energie, Electrica Furnizare, Electric Planners, Energy Distribution, Enel Energie, Enel Muntenia, Gas&Power, Entrex, Eye Mall, Premier Energy Trading, Gaz Est, Gazmir, Mihoc Oil, Met România, Monsson, MVM Future, Next Energy Distribution, Next Energy Partners, Premier Energy, Petrom, Prisma Serv, Gas Provider, Renovatio, Romgaz, RWE Supply, Tetarom, Tinmar","Delgaz Grid","-","2022-11-30","10:15:00","2022-11-30","17:00:00","Mediaș","Efectuată",null,"2022-11-30","10:15:00","2022-11-30","16:35:00","2022-11-30","11:05:00","2022-11-30","10:50:00","-","DA",null,null,null,0.58333333331393078,1,1,0.83333333325572312,37,37,6.3333333331975155,0,0,null,null,null,null,null,"","","","","","","","",""]
[56,"x","-","Întrerupere accidentală prin SRM Pârâul Rece datorită efectuării unor lucrări în instalația tehnologică",40321,"Pârâul Rece","Brașov",539905,445947.62,539905,445947.62,"-","-","SM0064D0","Pârâul Rece","-","-","-","-","SM-SD001","Alpha Metal, Nova Power, Bepco, Cez Vânzare, Cis Gaz, Conef Gaz, Crest Energy, Distrigaz Sud Retele, Distrigaz Vest, Engie, E.on Energie, Electrocentrale București, Electrocentrale Constanța, Electrica Furnizare, Electric Planners, Energy Distribution, Enel Energie, Enel Muntenia, Gas&Power, Entrex, Euro Seven, Eye Mall, Premier Energy Trading, Gaz Est, Getica 95, Met România, Monsson, Termoenergetica București, MVM Future, Next Energy Distribution, Next Energy Partners, Nord Gaz, Premier Energy, Petrom, Gas Provider, Renovatio, Romgaz, RWE Supply, Sustainable Energy, Termo Calor, Tinmar, Transenergo, Termoelectrica Giurgiu, Vest Energo","Distrigaz Sud Rețele","-","2022-12-21","10:36:00","2022-12-21","14:00:00","Brașov","Efectuată",null,"2022-12-21","10:36:00","2022-12-21","12:00:00","2022-12-21","11:29:00","2022-12-21","10:57:00","-","DA",null,null,null,0.35000000009313226,1,1,0.88333333341870457,44,44,1.4000000000232831,0,0,null,null,null,null,null,"","","","","","","","",""]
[57,"x","-","Întrerupere accidentală prin SRM Ștefan Vodă datorită blocării sistemului de măsurare",94599,"Ștefan Vodă","Călărași",688361.75,318496.46999999997,688361.75,318496.46999999997,"-","-","SM1179D0","Ștefan Vodă","-","-","-","-","SM-SD001","Alpha Metal, Nova Power, Bepco, Cez Vânzare, Conef Gaz, Distrigaz Sud Rețele, Distrigaz Vest, Engie, E.on Energie, Electrocentrale București, Electrocentrale Constanța, Electrica Furnizare, Electric Planners, Energy Distribution, Enel Energie, Enel Muntenia, Gas&Power, Entrex, Euro Seven, Eye Mall, Premier Energy Trading, Gaz Est, Met România, Monsson, Termoenergetica București, MVM Future, Next Energy Distribution, Next Energy Partners, Nord Gaz, Premier Energy, Petrom, Gas Provider, Renovatio, Romgaz, RWE Supply, Sustainable Energy, Termo Calor, Tinmar, Transenergo, Termoelectrica Giurgiu, Vest Energo","Distrigaz Sud Rețele","-","2023-02-06","10:27:00","2023-02-06","12:30:00","Brăila","Efectuată",null,"2023-02-06","10:27:00","2023-02-06","11:35:00","2023-02-06","10:56:00","2023-02-06","10:45:00","9053/06.02.2023","DA",null,null,null,0.29999999993015081,1,1,0.48333333333721384,41,41,1.1333333333604969,0,0,null,null,null,null,null,"","","","","","","","",""]
[58,"x","-","Întrerupere accidentală prin SRM Soceram Cordun datorită închiderii dispozitivelor de blocare din cauza manevrelor din instalația de utilizare a beneficiarului",120897,"Cordun","Neamț",643240.04,608751.69999999995,643240.04,608751.69999999995,"-","-","SM1307D0","SC Soceram Cordun","-","-","-","-","SM-CF001","Engie","SC Soceram","-","2023-02-06","12:30:00","2023-02-06",1.6875,"Bacău","Efectuată",null,"2023-02-06","12:30:00","2023-02-06","14:10:00","2023-02-06","14:10:00","2023-02-06","14:00:00","-","DA",null,null,null,1.5,1,1,1.6666666666860692,1,1,1.6666666666860692,0,0,null,null,null,null,null,"","","","","","","","",""]
[59,"x","-","Întrerupere accidentală prin SRM Sanatoriul Predeal datorită unei avarii în rețeaua de distribuție.",40312,"Predeal","Brașov",542424.77,443966.51,542424.77,443966.51,"-","-","SM0065D0","Sanatoriul Predeal","-","-","-","-","SM-SD001","Alpha Metal, Nova Power, Bepco, Cez Vânzare, Conef Gaz, Distrigaz Sud Rețele, Distrigaz Vest, Engie, E.on Energie, Electrocentrale București, Electrocentrale Constanța, Electrica Furnizare, Electric Planners, Energy Distribution, Enel Energie, Enel Muntenia, Gas&Power, Entrex, Euro Seven, Eye Mall, Premier Energy Trading, Gaz Est, Met România, Monsson, Termoenergetica București, MVM Future, Next Energy Distribution, Next Energy Partners, Nord Gaz, Premier Energy, Petrom, Gas Provider, Renovatio, Romgaz, RWE Supply, Sustainable Energy, Termo Calor, Tinmar, Transenergo, Termoelectrica Giurgiu, Vest Energo","Distrigaz Sud Rețele","-","2023-02-07","10:20:00","2023-02-07","15:30:00","Brașov","Efectuată",null,"2023-02-07","10:20:00","2023-02-07","14:10:00","2023-02-07","10:51:00","2023-02-07","10:43:00","-","DA",null,null,null,0.38333333336049691,1,1,0.5166666666045785,41,41,3.8333333334303461,0,0,null,null,null,null,null,"","","","","","","","",""]
[60,"x","-","Lucrari de înlocuire robinet şi optimizare instalaţie tehnologică SRM Nutrientul Palota",28674,"Ciumeghiu","Bihor",240312.51,589580.34,240312.51,589580.34,"-","-","SM0372D0","SC Nutrientul Palota","-","-","-","-","SM-CF001","Petrom","SC Nutrientul Palota","-","2023-02-15","08:10:00","2023-02-16","16:00:00","Cluj","Efectuată",null,"2023-02-15","08:10:00","2023-02-16","15:10:00","2023-02-15","08:52:00","2023-02-15","08:43:00","11353/13.02.2023","DA",null,null,null,0.54999999987194315,1,1,0.69999999983701855,1,1,30.999999999941792,1,1,"DA",null,null,null,null,"","","","","","","","",""]
[61,"-","x","Mentenanţă şi reabilitare SRM Răzvad",65440,"Răzvad","Dâmbovița",542880.01300000004,380147.11,542880.01300000004,380147.11,"-","-","SM0105D0","Răzvad","-","-","-","-","SM-SD001",null,"Distrigaz Sud Rețele","mai - septembrie 2023",null,null,null,null,"București",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[62,"x","-","Întrerupere accidentală prin SRM Gordon Bulgăreni datorită avarie produse pe conducta de alimentare cu gaze naturale",84852,"Bulgăreni","Harghita",518631.57,539395.30000000005,518631.57,539395.30000000005,"-","-","SM0999D0","SC Gordon Prod Bulgăreni","-","-","-","-","SM-CF001","Engie","SC Gordon Prod SRL","-","2023-02-20","06:00:00","2023-02-20","15:00:00","Brașov","Efectuată",null,"2023-02-20","06:10:00","2023-02-20","19:42:00","2023-02-20","06:32:00","2023-02-20","06:19:00","-","DA",null,null,null,0.1499999999650754,1,1,0.36666666663950309,1,1,13.533333333267365,0,0,null,null,null,null,null,"","","","","","","","",""]
[63,"x","-","Cuplare în SNT a instalaţiei tehnologice definitive de la SRM Hotărel",29975,"Hotărel","Bihor",304249.06,562567.32999999996,304249.06,562567.32999999996,"-","-","SM1323D0","Hotărel","-","-","-","-","SM-SD001","E.on Energie, Electrica Furnizare, Enel Energie, Engie, Premier Energy Tranding, Enel Energie Muntenia, Nova Power & Gas, Petrom, Premier Energy, Romgaz, Tinmar Energy","Nova Power","-","2023-02-22","10:05:00","2023-02-22","13:00:00","Cluj","Efectuată",null,"2023-02-22","10:05:00","2023-02-22","12:30:00","2023-02-22","10:35:00","2023-02-22","10:16:00","12790/17.02.2023","NU",null,null,null,"Nu a fost afectat producator/consumator","-","-","Nu a fost afectat producator/consumator","-","-","Nu a fost afectat producator/consumator","-","-",null,null,null,null,null,"","","","","","","","",""]
[64,"x","-","Înlocuire contor cu turbină şi filtru conic DN150 la SRM Tăuţii Măgherăuş",106470,"Tăuţii Măgherăuş","Maramureș",383109.88,686104.05,383109.88,686104.05,"-","-","SM0579D0","Tăuţii Măgherăuş","-","-","-","-","SM-SD001","Nova Power, Cez Vânzare, Colterm, CPL Concordia, Delgaz, Design Proiect, Distrigaz Vest, Engie, Axpo, E.on Energie, Electrica Furnizare, Electric Planners, Energy Distribution, Enel Energie, Enel Muntenia, Gas&Power, Entrex, Eye Mall, Premier Energy Trading, Gaz Est, Gazmir, Mihoc Oil, Met România, Monsson, MVM Future, Next Energy Distribution, Next Energy Partners, Premier Energy, Petrom, Prisma Serv, Gas Provider, Renovatio, Romgaz, RWE Supply, Tetarom, Tinmar, Transenergo","Delgaz Grid","-","2023-02-22","13:00:00","2023-02-22","15:00:00","Cluj","Efectuată",null,"2023-02-22","13:00:00","2023-02-22","13:40:00","2023-02-22","13:18:00","2023-02-22","13:06:00","13344/21.02.2023","NU",null,null,null,"Nu a fost afectat producator/consumator","-","-","Nu a fost afectat producator/consumator","-","-","Nu a fost afectat producator/consumator","-","-",null,null,null,null,null,"","","","","","","","",""]
[65,"x","-","Remediere defect pe conducta DN80 racord SRM Bentonita Medieşu Aurit",138093,"Medieşu Aurit","Satu Mare",359697.45,698816.12,359697.45,698816.12,"-","-","SM0580D0","SC Bentonita Medieşu Aurit","-","-","-","-","SM-CF001","E.on Energie","SC Bentonita SA","-","2023-03-09","10:00:00","2023-03-09","14:00:00","Cluj","Efectuată",null,"2023-03-09","10:00:00","2023-03-09","13:40:00","2023-03-09","10:20:00","2023-03-09","10:14:00","17452/07.03.2023","DA",null,null,null,0.2333333333954215,1,1,0.33333333337213844,1,1,3.6666666667442769,0,0,null,null,null,null,null,"","","","","","","","",""]
[66,"-","x","Cuplare deviere pe conducta DN700 Inel București, zona Otopeni",179490,"Otopeni","Ilfov",586006.49,338926.93,586006.49,338926.93,"-","-","SM0127D0","Otopeni","-","-","-","-","SM-SD001",null,"Premier Energy","10 aprilie - august 2023",null,null,null,null,"București",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[67,"-","x","Cuplare deviere pe conducta DN700 Inel București, zona Otopeni",179490,"Otopeni","Ilfov",585204.41,338698.66,585204.41,338698.66,"-","-","SM0169D0","SC Eurial Invest Otopeni","-","-","-","-","SM-CF001",null,"Eurial Invest SRL","10 aprilie - august 2023",null,null,null,null,"București",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[68,"x","-","Remediere defect pe conducta DN80 racord SRM Bentonita Medieşu Aurit, la subtraversarea CF Medieşu Aurit",138093,"Medieşu Aurit","Satu Mare",359697.45,698816.12,359697.45,698816.12,"-","-","SM0580D0","SC Bentonita Medieşu Aurit","-","-","-","-","SM-CF001","E.on Energie","SC Bentonita SA","-","2023-03-16","10:13:00","2023-03-16","16:00:00","Cluj","Efectuată",null,"2023-03-16","10:13:00","2023-03-16","15:45:00","2023-03-16","10:24:00","2023-03-16","10:18:00","19049/13.03.2023","DA",null,null,null,{"$f":"IF(B83=\"X\",IF(AN83=\"\",\"Afectat sau NU?\",IF(AN83=\"DA\",IF(((AK83+AL83)-(AE83+AF83))*24<-720,\"Neinformat\",((AK83+AL83)-(AE83+AF83))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":8.3333333430346102E-2},{"$f":"IF(B83=\"X\",IF(AN83=\"DA\",IF(AR83<6,LEN(TRIM(V83))-LEN(SUBSTITUTE(V83,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":1},{"$f":"IF(B83=\"X\",IF(AN83=\"DA\",LEN(TRIM(V83))-LEN(SUBSTITUTE(V83,CHAR(44),\"\"))+1,\"-\"),\"\")","v":1},{"$f":"IF(B83=\"X\",IF(AN83=\"\",\"Afectat sau NU?\",IF(AN83=\"DA\",IF(((AI83+AJ83)-(AE83+AF83))*24<-720,\"Neinformat\",((AI83+AJ83)-(AE83+AF83))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":0.18333333340706304},{"$f":"IF(B83=\"X\",IF(AN83=\"DA\",IF(AU83<6,LEN(TRIM(U83))-LEN(SUBSTITUTE(U83,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":1},{"$f":"IF(B83=\"X\",IF(AN83=\"DA\",LEN(TRIM(U83))-LEN(SUBSTITUTE(U83,CHAR(44),\"\"))+1,\"-\"),\"\")","v":1},{"$f":"IF(B83=\"X\",IF(AN83=\"\",\"Afectat sau NU?\",IF(AN83=\"DA\",((AG83+AH83)-(AE83+AF83))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":5.53333333338378},{"$f":"IF(B83=\"X\",IF(AN83=\"DA\",IF(AX83>24,IF(BA83=\"NU\",0,LEN(TRIM(V83))-LEN(SUBSTITUTE(V83,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":0},{"$f":"IF(B83=\"X\",IF(AN83=\"DA\",IF(AX83>24,LEN(TRIM(V83))-LEN(SUBSTITUTE(V83,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":0},null,null,null,null,null,{"$f":"IF(C83=\"X\",IF(AN83=\"\",\"Afectat sau NU?\",IF(AN83=\"DA\",IF(AK83=\"\",\"Neinformat\",NETWORKDAYS(AK83+AL83,AE83+AF83,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C83=\"X\",IF(AN83=\"DA\",IF(AND(BF83>=5,AK83<>\"\"),LEN(TRIM(V83))-LEN(SUBSTITUTE(V83,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C83=\"X\",IF(AN83=\"DA\",LEN(TRIM(V83))-LEN(SUBSTITUTE(V83,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C83=\"X\",IF(AN83=\"\",\"Afectat sau NU?\",IF(AN83=\"DA\",IF(AI83=\"\",\"Neinformat\",NETWORKDAYS(AI83+AJ83,AE83+AF83,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C83=\"X\",IF(AN83=\"DA\",IF(AND(BI83>=5,AI83<>\"\"),LEN(TRIM(U83))-LEN(SUBSTITUTE(U83,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C83=\"X\",IF(AN83=\"DA\",LEN(TRIM(U83))-LEN(SUBSTITUTE(U83,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C83=\"X\",IF(AN83=\"\",\"Afectat sau NU?\",IF(AN83=\"DA\",((AG83+AH83)-(Z83+AA83))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C83=\"X\",IF(AN83<>\"DA\",\"-\",IF(AND(AN83=\"DA\",BL83<=0),LEN(TRIM(V83))-LEN(SUBSTITUTE(V83,CHAR(44),\"\"))+1+LEN(TRIM(U83))-LEN(SUBSTITUTE(U83,CHAR(44),\"\"))+1,0)),\"\")","v":""},{"$f":"IF(C83=\"X\",IF(AN83=\"DA\",LEN(TRIM(V83))-LEN(SUBSTITUTE(V83,CHAR(44),\"\"))+1+LEN(TRIM(U83))-LEN(SUBSTITUTE(U83,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""}]
[{"$f":"A83+1","v":69},"-","x","Înlocuire flanșă electroizolantă cu îmbinare electroizolantă monobloc pe conducta DN300 racord SRM Hoghiz, zona grupului de robineți Perșani",41596,"Grid","Brașov",515977.79,481000.46,515977.79,481000.46,"-","-","SM0023D0","Grid","-","-","-","-","SM-SD001","Alpha Metal, Nova Power, Bepco, Cez Vânzare, Conef Gaz, Distrigaz Sud Rețele, Distrigaz Vest, Engie, E.on Energie, Electrocentrale București, Electrocentrale Constanța, Electrica Furnizare, Electric Planners, Energy Distribution, Enel Energie, Enel Muntenia, Entrex, Euro Seven, Eye Mall, Premier Energy Trading, Gaz Est, Getica95, Megaconstruct, Met România, Monsson, Termoenergetica București, MVM Future, Next Energy Distribution, Next Energy Partners, Premier Energy, Petrom, Gas Provider, Renovatio, Romgaz, RWE Supply, Sustainable Energy, Termo Calor, Tinmar, Transenergo, Termoelectrica Giurgiu","Distrigaz Sud Rețele","20 aprilie - mai 2023","2023-05-24","08:00:00","2023-05-24","18:00:00","Mediaș","Efectuată",null,"2023-05-24","08:00:00","2023-05-24","18:00:00","2023-05-12","07:48:00","2023-05-12","07:38:00","2051/22.05.2023","DA",null,"forțe proprii",null,"","","","","","","","","",null,null,null,null,null,7,1,1,7,40,40,0,41,41]
[{"$f":"A84+1","v":70},"-","x","Înlocuire flanșă electroizolantă cu îmbinare electroizolantă monobloc pe conducta DN300 racord SRM Hoghiz, zona grupului de robineți Perșani",41603,"Veneția","Brașov",517457.96,485464.88,517457.96,485464.88,"-","-","SM0024D0","Veneția","-","-","-","-","SM-SD001","Alpha Metal, Nova Power, Bepco, Cez Vânzare, Conef Gaz, Distrigaz Sud Rețele, Distrigaz Vest, Engie, E.on Energie, Electrocentrale București, Electrocentrale Constanța, Electrica Furnizare, Electric Planners, Energy Distribution, Enel Energie, Enel Muntenia, Entrex, Euro Seven, Eye Mall, Premier Energy Trading, Gaz Est, Getica95, Megaconstruct, Met România, Monsson, Termoenergetica București, MVM Future, Next Energy Distribution, Next Energy Partners, Premier Energy, Petrom, Gas Provider, Renovatio, Romgaz, RWE Supply, Sustainable Energy, Termo Calor, Tinmar, Transenergo, Termoelectrica Giurgiu","Distrigaz Sud Rețele","20 aprilie - mai 2023","2023-05-24","08:00:00","2023-05-24","18:00:00","Mediaș","Efectuată",null,"2023-05-24","08:00:00","2023-05-24","18:00:00","2023-05-12","07:48:00","2023-05-12","07:38:00","2051/22.05.2023","DA",null,"forțe proprii",null,"","","","","","","","","",null,null,null,null,null,7,1,1,{"$f":"IF(C85=\"X\",IF(AN85=\"\",\"Afectat sau NU?\",IF(AN85=\"DA\",IF(AI85=\"\",\"Neinformat\",NETWORKDAYS(AI85+AJ85,AE85+AF85,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":7},40,40,0,41,41]
[71,"-","x","Înlocuire flanșă electroizolantă cu îmbinare electroizolantă monobloc pe conducta DN300 racord SRM Hoghiz, zona grupului de robineți Perșani",40786,"Beia","Brașov",516259.69,516736.49,516259.69,516736.49,"-","-","-","-","PM0009","Beia","-","-","PM-PP001","Romgaz","Romgaz","20 aprilie - mai 2023","2023-05-24","08:00:00","2023-05-24","18:00:00","Mediaș","Efectuată",null,"2023-05-24","08:00:00","2023-05-24","16:00:00","2023-05-12","07:45:00","2023-05-12","07:33:00","2051/22.05.2023","DA",null,"forțe proprii",null,"","","","","","","","","",null,null,null,null,null,7,1,1,7,1,1,-2.0000000000582077,2,2]
[72,"-","x","Înlocuire flanșă electroizolantă cu îmbinare electroizolantă monobloc pe conducta DN300 racord SRM Hoghiz, zona grupului de robineți Perșani",40713,"Bunești","Brașov",507522.86,512305.79,507522.86,512305.79,"-","-","-","-","PM0010","Bunești","-","-","PM-PP001","Romgaz","Romgaz","20 aprilie - mai 2023","2023-05-24","08:00:00","2023-05-24","18:00:00","Mediaș","Efectuată",null,"2023-05-24","08:00:00","2023-05-24","16:00:00","2023-05-12","07:45:00","2023-05-12","07:33:00","2051/22.05.2023","DA",null,"forțe proprii",null,"","","","","","","","","",null,null,null,null,null,7,1,1,7,1,1,-2.0000000000582077,2,2]
[73,"-","x","Înlocuire flanșă electroizolantă cu îmbinare electroizolantă monobloc pe conducta DN50 racord SRM Cârța",144517,"Cârța","Sibiu",467104.7,476951.43,467104.7,476951.43,"-","-","SM0813D0","Cârța","-","-","-","-","SM-SD001",null,"Delgaz Grid","iulie 2023",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?","-","-"]
[74,"x","-","Remediere defecte pe conducta DN500 Turburea - Ișalnița, fir III, zona Ișalnița",72418,"Ghercești","Dolj",411336.78,315622.86,411336.78,315622.86,"-","-","-","-","PM0275","Stația Centrală Ghercești Extras","-","-","VPM01","Alpha Metal, Alpha Project, Nova Power, AOT Energy, Azomures, BEPCO, Cez Vânzare, Colterm, Conef Gaz, Cordun, CPL Concordia, MM Data, Delgaz, Design Proiect, Distrigaz Vest, Engie, E.on Energie, Electrocentrale București, Electrica Furnizare, Energy Distribution, Enel Energie, Enel Muntenia, Entrex, Euro Seven, Eye Mall, Premier Energy Trading, Gas&Power, Gaz Est, Gazmir, Gaz Nord Est, Instant Construct, Lord Energy, Megaconstruct, Mihoc Oil, Modern Calor, Met România, Termoenergetica București, MVM Future Energy, Next Energy Distribution, Next Energy Partners, Premier Energy, Petrom, Prisma Serv, Gas Provider, Renovatio, Romgaz, RWE Supply, Salgaz, Sustainable Energy, Tinmar, Vest Energo","Romgaz - Depogaz Ploiești","-","2023-03-20","06:45:00","2023-03-21","19:00:00","Craiova","Efectuată",null,"2023-03-20","06:45:00","2023-03-21","16:50:00","2023-03-20","07:43:00","2023-03-20","07:27:00","20115/15.03.2023","DA",null,null,null,{"$f":"IF(B89=\"X\",IF(AN89=\"\",\"Afectat sau NU?\",IF(AN89=\"DA\",IF(((AK89+AL89)-(AE89+AF89))*24<-720,\"Neinformat\",((AK89+AL89)-(AE89+AF89))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":0.70000000001164153},{"$f":"IF(B89=\"X\",IF(AN89=\"DA\",IF(AR89<6,LEN(TRIM(V89))-LEN(SUBSTITUTE(V89,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":1},{"$f":"IF(B89=\"X\",IF(AN89=\"DA\",LEN(TRIM(V89))-LEN(SUBSTITUTE(V89,CHAR(44),\"\"))+1,\"-\"),\"\")","v":1},{"$f":"IF(B89=\"X\",IF(AN89=\"\",\"Afectat sau NU?\",IF(AN89=\"DA\",IF(((AI89+AJ89)-(AE89+AF89))*24<-720,\"Neinformat\",((AI89+AJ89)-(AE89+AF89))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":0.96666666667442769},{"$f":"IF(B89=\"X\",IF(AN89=\"DA\",IF(AU89<6,LEN(TRIM(U89))-LEN(SUBSTITUTE(U89,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":51},{"$f":"IF(B89=\"X\",IF(AN89=\"DA\",LEN(TRIM(U89))-LEN(SUBSTITUTE(U89,CHAR(44),\"\"))+1,\"-\"),\"\")","v":51},{"$f":"IF(B89=\"X\",IF(AN89=\"\",\"Afectat sau NU?\",IF(AN89=\"DA\",((AG89+AH89)-(AE89+AF89))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":34.083333333372138},{"$f":"IF(B89=\"X\",IF(AN89=\"DA\",IF(AX89>24,IF(BA89=\"NU\",0,LEN(TRIM(V89))-LEN(SUBSTITUTE(V89,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":1},{"$f":"IF(B89=\"X\",IF(AN89=\"DA\",IF(AX89>24,LEN(TRIM(V89))-LEN(SUBSTITUTE(V89,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":1},"DA",null,null,null,null,{"$f":"IF(C89=\"X\",IF(AN89=\"\",\"Afectat sau NU?\",IF(AN89=\"DA\",IF(AK89=\"\",\"Neinformat\",NETWORKDAYS(AK89+AL89,AE89+AF89,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C89=\"X\",IF(AN89=\"DA\",IF(AND(BF89>=5,AK89<>\"\"),LEN(TRIM(V89))-LEN(SUBSTITUTE(V89,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C89=\"X\",IF(AN89=\"DA\",LEN(TRIM(V89))-LEN(SUBSTITUTE(V89,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C89=\"X\",IF(AN89=\"\",\"Afectat sau NU?\",IF(AN89=\"DA\",IF(AI89=\"\",\"Neinformat\",NETWORKDAYS(AI89+AJ89,AE89+AF89,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C89=\"X\",IF(AN89=\"DA\",IF(AND(BI89>=5,AI89<>\"\"),LEN(TRIM(U89))-LEN(SUBSTITUTE(U89,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C89=\"X\",IF(AN89=\"DA\",LEN(TRIM(U89))-LEN(SUBSTITUTE(U89,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C89=\"X\",IF(AN89=\"\",\"Afectat sau NU?\",IF(AN89=\"DA\",((AG89+AH89)-(Z89+AA89))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C89=\"X\",IF(AN89<>\"DA\",\"-\",IF(AND(AN89=\"DA\",BL89<=0),LEN(TRIM(V89))-LEN(SUBSTITUTE(V89,CHAR(44),\"\"))+1+LEN(TRIM(U89))-LEN(SUBSTITUTE(U89,CHAR(44),\"\"))+1,0)),\"\")","v":""},{"$f":"IF(C89=\"X\",IF(AN89=\"DA\",LEN(TRIM(V89))-LEN(SUBSTITUTE(V89,CHAR(44),\"\"))+1+LEN(TRIM(U89))-LEN(SUBSTITUTE(U89,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""}]
[75,"x","-","Curățare filtru conic Fc1 DN80 din SRM SC FNC Safir Chițcani",163155,"Chițcani","Vaslui",715357.57,550449.48,715357.57,550449.48,"-","-","SM1256D0","SC FNC Safir Chițcani","-","-","-","-","SM-CF001","Engie, Safir-Star","SC Safir SRL","-","2023-03-27","10:05:00","2023-03-27","13:00:00","Brăila","Efectuată",null,"2023-03-27","10:05:00","2023-03-27","11:30:00","2023-03-27","10:15:00","2023-03-27","10:09:00","22042/22.03.2023","DA",null,null,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":6.6666666709352285E-2},{"$f":"IF(B90=\"X\",IF(AN90=\"DA\",IF(AR90<6,LEN(TRIM(V90))-LEN(SUBSTITUTE(V90,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":1},{"$f":"IF(B90=\"X\",IF(AN90=\"DA\",LEN(TRIM(V90))-LEN(SUBSTITUTE(V90,CHAR(44),\"\"))+1,\"-\"),\"\")","v":1},{"$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":0.16666666668606922},{"$f":"IF(B90=\"X\",IF(AN90=\"DA\",IF(AU90<6,LEN(TRIM(U90))-LEN(SUBSTITUTE(U90,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":2},{"$f":"IF(B90=\"X\",IF(AN90=\"DA\",LEN(TRIM(U90))-LEN(SUBSTITUTE(U90,CHAR(44),\"\"))+1,\"-\"),\"\")","v":2},{"$f":"IF(B90=\"X\",IF(AN90=\"\",\"Afectat sau NU?\",IF(AN90=\"DA\",((AG90+AH90)-(AE90+AF90))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":1.4166666665696539},{"$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":0},{"$f":"IF(B90=\"X\",IF(AN90=\"DA\",IF(AX90>24,LEN(TRIM(V90))-LEN(SUBSTITUTE(V90,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":0},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":""},{"$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":""},{"$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":""},{"$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","-","Întrerupere accidentală prin SRM Deleni VS datorită blocării sistemului de măsurare, cauzat de operațiuni de refulare efectuate în sistemul de distribuție, fără anunțarea prealabilă a OST.",163333,"Deleni","Vaslui",713355.01,565094.42000000004,713355.01,565094.42000000004,"-","-","SM1229D0","Deleni VS","-","-","-","-","SM-SD001","Nova Power, Cez Vânzare, Engie, E.on Energie, Electrica Furnizare, Enel Energie, Enel Muntenia, Eye Mall, Premier Energy Trading, Gas Est, Met România, Premier Energy, Petrom, Renovatio, Romgaz, Safi-Star, Tinmar","Gaz Est","-","2023-03-29","16:00:00","2023-03-29","18:00:00","Brăila","Efectuată",null,"2023-03-29","16:00:00","2023-03-29","17:59:00","2023-03-29","16:40:00","2023-03-29","16:32:00","-","DA",null,null,null,{"$f":"IF(B91=\"X\",IF(AN91=\"\",\"Afectat sau NU?\",IF(AN91=\"DA\",IF(((AK91+AL91)-(AE91+AF91))*24<-720,\"Neinformat\",((AK91+AL91)-(AE91+AF91))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":0.53333333332557231},{"$f":"IF(B91=\"X\",IF(AN91=\"DA\",IF(AR91<6,LEN(TRIM(V91))-LEN(SUBSTITUTE(V91,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":1},{"$f":"IF(B91=\"X\",IF(AN91=\"DA\",LEN(TRIM(V91))-LEN(SUBSTITUTE(V91,CHAR(44),\"\"))+1,\"-\"),\"\")","v":1},{"$f":"IF(B91=\"X\",IF(AN91=\"\",\"Afectat sau NU?\",IF(AN91=\"DA\",IF(((AI91+AJ91)-(AE91+AF91))*24<-720,\"Neinformat\",((AI91+AJ91)-(AE91+AF91))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":0.66666666674427688},{"$f":"IF(B91=\"X\",IF(AN91=\"DA\",IF(AU91<6,LEN(TRIM(U91))-LEN(SUBSTITUTE(U91,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":17},{"$f":"IF(B91=\"X\",IF(AN91=\"DA\",LEN(TRIM(U91))-LEN(SUBSTITUTE(U91,CHAR(44),\"\"))+1,\"-\"),\"\")","v":17},{"$f":"IF(B91=\"X\",IF(AN91=\"\",\"Afectat sau NU?\",IF(AN91=\"DA\",((AG91+AH91)-(AE91+AF91))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":1.9833333333372138},{"$f":"IF(B91=\"X\",IF(AN91=\"DA\",IF(AX91>24,IF(BA91=\"NU\",0,LEN(TRIM(V91))-LEN(SUBSTITUTE(V91,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":0},{"$f":"IF(B91=\"X\",IF(AN91=\"DA\",IF(AX91>24,LEN(TRIM(V91))-LEN(SUBSTITUTE(V91,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":0},null,null,null,null,null,{"$f":"IF(C91=\"X\",IF(AN91=\"\",\"Afectat sau NU?\",IF(AN91=\"DA\",IF(AK91=\"\",\"Neinformat\",NETWORKDAYS(AK91+AL91,AE91+AF91,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C91=\"X\",IF(AN91=\"DA\",IF(AND(BF91>=5,AK91<>\"\"),LEN(TRIM(V91))-LEN(SUBSTITUTE(V91,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C91=\"X\",IF(AN91=\"DA\",LEN(TRIM(V91))-LEN(SUBSTITUTE(V91,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C91=\"X\",IF(AN91=\"\",\"Afectat sau NU?\",IF(AN91=\"DA\",IF(AI91=\"\",\"Neinformat\",NETWORKDAYS(AI91+AJ91,AE91+AF91,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C91=\"X\",IF(AN91=\"DA\",IF(AND(BI91>=5,AI91<>\"\"),LEN(TRIM(U91))-LEN(SUBSTITUTE(U91,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C91=\"X\",IF(AN91=\"DA\",LEN(TRIM(U91))-LEN(SUBSTITUTE(U91,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C91=\"X\",IF(AN91=\"\",\"Afectat sau NU?\",IF(AN91=\"DA\",((AG91+AH91)-(Z91+AA91))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C91=\"X\",IF(AN91<>\"DA\",\"-\",IF(AND(AN91=\"DA\",BL91<=0),LEN(TRIM(V91))-LEN(SUBSTITUTE(V91,CHAR(44),\"\"))+1+LEN(TRIM(U91))-LEN(SUBSTITUTE(U91,CHAR(44),\"\"))+1,0)),\"\")","v":""},{"$f":"IF(C91=\"X\",IF(AN91=\"DA\",LEN(TRIM(V91))-LEN(SUBSTITUTE(V91,CHAR(44),\"\"))+1+LEN(TRIM(U91))-LEN(SUBSTITUTE(U91,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""}]
[77,"-","x","Mentenanță SRM București 16 Februarie",403,"București","București",580043.31999999995,331375.90000000002,580043.31999999995,331375.90000000002,"-","-","SM0144D0","București 16 Februarie","-","-","-","-","SM-SD001",null,"Distrigaz Sud Rețele","15 mai - septembrie 2023","2023-05-31","10:00:00","2023-06-29","10:00:00","București",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[78,"-","x","Mentenanță SRM București Cet Vest",403,"București","București",577613.28,325145.01,577613.28,325145.01,"-","-","SM0151D0","București Cet Vest","-","-","-","-","SM-SD001",null,"Distrigaz Sud Rețele","15 mai - septembrie 2023",null,null,null,null,"București",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[79,"-","x","Mentenanță SRM Măgurele București",179418,"Măgurele","Ilfov",583333.36,319855.82,583333.36,319855.82,"-","-","SM0252D0","Măgurele București","-","-","-","-","SM-SD001","Alpha Metal, Nova Power, Bepco, Cez Vânzare, Conef Gaz, Distrigaz Sud Rețele, Distrigaz Vest, Engie, E.on Energie, Electrocentrale București, Electrocentrale Constanța, Electrica Furnizare, Electric Planners, Energy Distribution, Enel Energie, Enel Muntenia, Entrex, Euro Seven, Eye Mall, Premier Energy Trading, Gaz Est, Getica95, Megaconstruct, Met România, Monsson, Termoenergetica București, MVM Future, Next Energy Distribution, Next Energy Partners, Premier Energy, Petrom, Gas Provider, Renovatio, Romgaz, RWE Supply, Sustainable Energy, Termo Calor, Tinmar, Transenergo, Termoelectrica Giurgiu","Distrigaz Sud Rețele","15 mai - septembrie 2023","2023-05-15","10:00:00","2023-05-30","10:00:00","București","Efectuată",null,"2023-05-15","10:00:00","2023-05-30","09:54:00","2023-05-05","09:32:00","2023-05-05","09:10:00","35150/12.05.2023","NU",null,null,null,"","","","","","","","","",null,null,null,null,null,"Nu a fost afectat producator/consumator","-","-","Nu a fost afectat producator/consumator","-","-","Nu a fost afectat producator/consumator","-","-"]
[80,"-","x","Mentenanță SRM București Titan",403,"București","București",594982.35,325100.93,594982.35,325100.93,"-","-","SM0157D0","București Titan","-","-","-","-","SM-SD001",null,"Distrigaz Sud Rețele","15 mai - septembrie 2023",null,null,null,null,"București",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[81,"x","-","Auditare sistem de măsurare DN50 din SRM Vințu de Jos II",8835,"Vințu de Jos","Alba",380155.81,497867.27,380155.81,497867.27,"-","-","SM0988D0","Vințu de Jos II","-","-","-","-","SM-SD001","Nova Power, Cet Hidrocarburi, Cez Vânzare, CPL Concordia, Delgaz, Design Proiect, Distrigaz Vest, Engie, Axpo, E.on Energie, Electrica Furnizare, Electric Planners, Energy Distribution, Enel Energie, Enel Muntenia, Entrex, Eye Mall, Premier Energy Trading, Gaz Est, Gazmir, Lord Energy, Mihoc Oil, Met România, Monsson, MVM Future, Next Energy Distribution, Next Energy Partners, Premier Energy, Petrom, Prisma Serv, Gas Provider, Renovatio, Romgaz, RWE Supply, Tetarom, Tinmar, Transenergo","Delgaz Grid","-","2023-04-24","14:01:00","2023-04-24","15:00:00","Arad","Efectuată",null,"2023-04-24","14:01:00","2023-04-24","15:15:00","2023-04-24","14:26:00","2023-04-24","14:09:00","29878/21.04.2023","DA",null,null,null,{"$f":"IF(B96=\"X\",IF(AN96=\"\",\"Afectat sau NU?\",IF(AN96=\"DA\",IF(((AK96+AL96)-(AE96+AF96))*24<-720,\"Neinformat\",((AK96+AL96)-(AE96+AF96))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":0.13333333341870457},{"$f":"IF(B96=\"X\",IF(AN96=\"DA\",IF(AR96<6,LEN(TRIM(V96))-LEN(SUBSTITUTE(V96,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":1},{"$f":"IF(B96=\"X\",IF(AN96=\"DA\",LEN(TRIM(V96))-LEN(SUBSTITUTE(V96,CHAR(44),\"\"))+1,\"-\"),\"\")","v":1},{"$f":"IF(B96=\"X\",IF(AN96=\"\",\"Afectat sau NU?\",IF(AN96=\"DA\",IF(((AI96+AJ96)-(AE96+AF96))*24<-720,\"Neinformat\",((AI96+AJ96)-(AE96+AF96))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":0.41666666680248454},{"$f":"IF(B96=\"X\",IF(AN96=\"DA\",IF(AU96<6,LEN(TRIM(U96))-LEN(SUBSTITUTE(U96,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":37},{"$f":"IF(B96=\"X\",IF(AN96=\"DA\",LEN(TRIM(U96))-LEN(SUBSTITUTE(U96,CHAR(44),\"\"))+1,\"-\"),\"\")","v":37},{"$f":"IF(B96=\"X\",IF(AN96=\"\",\"Afectat sau NU?\",IF(AN96=\"DA\",((AG96+AH96)-(AE96+AF96))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":1.2333333333372138},{"$f":"IF(B96=\"X\",IF(AN96=\"DA\",IF(AX96>24,IF(BA96=\"NU\",0,LEN(TRIM(V96))-LEN(SUBSTITUTE(V96,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":0},{"$f":"IF(B96=\"X\",IF(AN96=\"DA\",IF(AX96>24,LEN(TRIM(V96))-LEN(SUBSTITUTE(V96,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":0},null,null,null,null,null,{"$f":"IF(C96=\"X\",IF(AN96=\"\",\"Afectat sau NU?\",IF(AN96=\"DA\",IF(AK96=\"\",\"Neinformat\",NETWORKDAYS(AK96+AL96,AE96+AF96,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C96=\"X\",IF(AN96=\"DA\",IF(AND(BF96>=5,AK96<>\"\"),LEN(TRIM(V96))-LEN(SUBSTITUTE(V96,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C96=\"X\",IF(AN96=\"DA\",LEN(TRIM(V96))-LEN(SUBSTITUTE(V96,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C96=\"X\",IF(AN96=\"\",\"Afectat sau NU?\",IF(AN96=\"DA\",IF(AI96=\"\",\"Neinformat\",NETWORKDAYS(AI96+AJ96,AE96+AF96,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C96=\"X\",IF(AN96=\"DA\",IF(AND(BI96>=5,AI96<>\"\"),LEN(TRIM(U96))-LEN(SUBSTITUTE(U96,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C96=\"X\",IF(AN96=\"DA\",LEN(TRIM(U96))-LEN(SUBSTITUTE(U96,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C96=\"X\",IF(AN96=\"\",\"Afectat sau NU?\",IF(AN96=\"DA\",((AG96+AH96)-(Z96+AA96))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C96=\"X\",IF(AN96<>\"DA\",\"-\",IF(AND(AN96=\"DA\",BL96<=0),LEN(TRIM(V96))-LEN(SUBSTITUTE(V96,CHAR(44),\"\"))+1+LEN(TRIM(U96))-LEN(SUBSTITUTE(U96,CHAR(44),\"\"))+1,0)),\"\")","v":""},{"$f":"IF(C96=\"X\",IF(AN96=\"DA\",LEN(TRIM(V96))-LEN(SUBSTITUTE(V96,CHAR(44),\"\"))+1+LEN(TRIM(U96))-LEN(SUBSTITUTE(U96,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""}]
[82,"x","-","Cuplare deviere pe conducta DN600 Ernei - Corunca, fir I, zona Livezeni",116661,"Ernei","Mureș",471868.21,566230.16,471868.21,566230.16,"-","-","-","-","PM0125","Ernei - Golire SU","-","-","PM-PP001","Romgaz","Romgaz","-","2023-04-26","08:25:00","2023-04-27","16:00:00","Mediaș","Efectuată",null,"2023-04-26","08:25:00","2023-04-27","16:00:00","2023-04-26","09:03:00","2023-04-26","08:55:00","1667/24.04.2023","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.50000000005820766},{"$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.63333333330228925},{"$f":"IF(B97=\"X\",IF(AN97=\"DA\",IF(AU97<6,LEN(TRIM(U97))-LEN(SUBSTITUTE(U97,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":1},{"$f":"IF(B97=\"X\",IF(AN97=\"DA\",LEN(TRIM(U97))-LEN(SUBSTITUTE(U97,CHAR(44),\"\"))+1,\"-\"),\"\")","v":1},{"$f":"IF(B97=\"X\",IF(AN97=\"\",\"Afectat sau NU?\",IF(AN97=\"DA\",((AG97+AH97)-(AE97+AF97))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":31.583333333255723},{"$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":1},{"$f":"IF(B97=\"X\",IF(AN97=\"DA\",IF(AX97>24,LEN(TRIM(V97))-LEN(SUBSTITUTE(V97,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":1},"DA",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","-","Remediere în regim de urgență a unui defect pe conducta DN100 racord SRM Penitenciar Codlea CPPRCP Rodbav",41989,"Rodbav","Brașov",488971.09,489094.91,488971.09,489094.91,"-","-","SM0016D0","Penitenciar Codlea - CPPRCP Rodbav","-","-","-","-","SM-CF001","Petrom","Penitenciar Codlea","-","2023-04-27","10:09:00","2023-04-27","13:00:00","Mediaș","Efectuată",null,"2023-04-27","10:09:00","2023-04-27","13:00:00","2023-04-27","11:17:00","2023-04-27","10:54:00","1742/27.04.2023","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":0.75},{"$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":1.1333333331858739},{"$f":"IF(B98=\"X\",IF(AN98=\"DA\",IF(AU98<6,LEN(TRIM(U98))-LEN(SUBSTITUTE(U98,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":1},{"$f":"IF(B98=\"X\",IF(AN98=\"DA\",LEN(TRIM(U98))-LEN(SUBSTITUTE(U98,CHAR(44),\"\"))+1,\"-\"),\"\")","v":1},{"$f":"IF(B98=\"X\",IF(AN98=\"\",\"Afectat sau NU?\",IF(AN98=\"DA\",((AG98+AH98)-(AE98+AF98))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":2.8499999998603016},{"$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","-","Înlocuire contor cu pistoane rotative în SRM Pătrăuţi ",149842,"Pătrăuţi","Suceava",589430.87,690164.06,589430.87,690164.06,"-","-","SM1025D0","Pătrăuţi","-","-","-","-","SM-SD001","Nova Power, Cez Vânzare, Engie, E.on Energie, Electrica Furnizare, Enel Energie, Enel Muntenia, Premier Energy Trading, Mihoc Oil,Premier Energy, Petrom, Prisma Serv, Romgaz","Prisma Serv","-","2023-05-09","11:00:00","2023-05-09","12:30:00","Bacău","Efectuată",null,"2023-05-09","11:00:00","2023-05-09","11:24:00","2023-05-09","11:07:00","2023-05-09","11:00:00","33862/08.05.2023","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":0.11666666652308777},{"$f":"IF(B99=\"X\",IF(AN99=\"DA\",IF(AU99<6,LEN(TRIM(U99))-LEN(SUBSTITUTE(U99,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":13},{"$f":"IF(B99=\"X\",IF(AN99=\"DA\",LEN(TRIM(U99))-LEN(SUBSTITUTE(U99,CHAR(44),\"\"))+1,\"-\"),\"\")","v":13},{"$f":"IF(B99=\"X\",IF(AN99=\"\",\"Afectat sau NU?\",IF(AN99=\"DA\",((AG99+AH99)-(AE99+AF99))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":0.39999999990686774},{"$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":""}]
[85,"x","-","Lucrări de mentenanță în SRM Tg. Neamţ",121064,"Tg. Neamţ","Neamț",602678.26,634671.84,602678.26,634671.84,"-","-","SM0462D1","Vânători","-","-","-","-","SM-SD001","Nova Power, Cez Vânzare, Engie, E.on Energie, Enel Energie, Enel Muntenia, Premier Energy Trading, Mihoc Oil, Met România, Premier Energy, Petrom","Mihoc Oil","-","2023-05-10","10:00:00","2023-05-10","14:00:00","Bacău","Efectuată",null,"2023-05-10","10:00:00","2023-05-10","11:15:00","2023-05-10","10:17:00","2023-05-10","10:05:00","33950/08.05.2023","DA",null,null,null,{"$f":"IF(B100=\"X\",IF(AN100=\"\",\"Afectat sau NU?\",IF(AN100=\"DA\",IF(((AK100+AL100)-(AE100+AF100))*24<-720,\"Neinformat\",((AK100+AL100)-(AE100+AF100))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":8.3333333430346102E-2},{"$f":"IF(B100=\"X\",IF(AN100=\"DA\",IF(AR100<6,LEN(TRIM(V100))-LEN(SUBSTITUTE(V100,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":1},{"$f":"IF(B100=\"X\",IF(AN100=\"DA\",LEN(TRIM(V100))-LEN(SUBSTITUTE(V100,CHAR(44),\"\"))+1,\"-\"),\"\")","v":1},{"$f":"IF(B100=\"X\",IF(AN100=\"\",\"Afectat sau NU?\",IF(AN100=\"DA\",IF(((AI100+AJ100)-(AE100+AF100))*24<-720,\"Neinformat\",((AI100+AJ100)-(AE100+AF100))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":0.28333333338377997},{"$f":"IF(B100=\"X\",IF(AN100=\"DA\",IF(AU100<6,LEN(TRIM(U100))-LEN(SUBSTITUTE(U100,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":11},{"$f":"IF(B100=\"X\",IF(AN100=\"DA\",LEN(TRIM(U100))-LEN(SUBSTITUTE(U100,CHAR(44),\"\"))+1,\"-\"),\"\")","v":11},{"$f":"IF(B100=\"X\",IF(AN100=\"\",\"Afectat sau NU?\",IF(AN100=\"DA\",((AG100+AH100)-(AE100+AF100))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":1.2500000000582077},{"$f":"IF(B100=\"X\",IF(AN100=\"DA\",IF(AX100>24,IF(BA100=\"NU\",0,LEN(TRIM(V100))-LEN(SUBSTITUTE(V100,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":0},{"$f":"IF(B100=\"X\",IF(AN100=\"DA\",IF(AX100>24,LEN(TRIM(V100))-LEN(SUBSTITUTE(V100,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":0},null,null,null,null,null,{"$f":"IF(C100=\"X\",IF(AN100=\"\",\"Afectat sau NU?\",IF(AN100=\"DA\",IF(AK100=\"\",\"Neinformat\",NETWORKDAYS(AK100+AL100,AE100+AF100,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C100=\"X\",IF(AN100=\"DA\",IF(AND(BF100>=5,AK100<>\"\"),LEN(TRIM(V100))-LEN(SUBSTITUTE(V100,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C100=\"X\",IF(AN100=\"DA\",LEN(TRIM(V100))-LEN(SUBSTITUTE(V100,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C100=\"X\",IF(AN100=\"\",\"Afectat sau NU?\",IF(AN100=\"DA\",IF(AI100=\"\",\"Neinformat\",NETWORKDAYS(AI100+AJ100,AE100+AF100,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C100=\"X\",IF(AN100=\"DA\",IF(AND(BI100>=5,AI100<>\"\"),LEN(TRIM(U100))-LEN(SUBSTITUTE(U100,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C100=\"X\",IF(AN100=\"DA\",LEN(TRIM(U100))-LEN(SUBSTITUTE(U100,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C100=\"X\",IF(AN100=\"\",\"Afectat sau NU?\",IF(AN100=\"DA\",((AG100+AH100)-(Z100+AA100))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C100=\"X\",IF(AN100<>\"DA\",\"-\",IF(AND(AN100=\"DA\",BL100<=0),LEN(TRIM(V100))-LEN(SUBSTITUTE(V100,CHAR(44),\"\"))+1+LEN(TRIM(U100))-LEN(SUBSTITUTE(U100,CHAR(44),\"\"))+1,0)),\"\")","v":""},{"$f":"IF(C100=\"X\",IF(AN100=\"DA\",LEN(TRIM(V100))-LEN(SUBSTITUTE(V100,CHAR(44),\"\"))+1+LEN(TRIM(U100))-LEN(SUBSTITUTE(U100,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""}]
[86,"x","-","Înlocuire instalație tehnologică SRM Chețani II",116055,"Chețani","Mureș",427419.48,551606.43000000005,427419.48,551606.43000000005,"-","-","SM0651D0","Chețani II","-","-","-","-","SM-SD001","Nova Power, Cet Hidrocarburi, Cez Vânzare, CPL Concordia, Delgaz, Design Proiect, Distrigaz Vest, Engie, Axpo, E.on Energie, Electrica Furnizare, Electric Planners, Energy Distribution, Enel Energie, Enel Muntenia, Entrex, Eye Mall, Premier Energy Trading, Gaz Est, Gazmir, Lord Energy, Mihoc Oil, Met România, Monsson, MVM Future, Next Energy Distribution, Next Energy Partners, Premier Energy, Petrom, Prisma Serv, Gas Provider, Renovatio, Romgaz, RWE Supply, Tetarom, Tinmar, Transenergo","Delgaz Grid","-","2023-05-11","08:05:00","2023-05-11","18:00:00","Cluj","Efectuată",null,"2023-05-11","08:05:00","2023-05-11","16:10:00","2023-05-11","08:20:00","2023-05-11","08:11:00","34341/09.05.2023","DA",null,null,null,{"$f":"IF(B101=\"X\",IF(AN101=\"\",\"Afectat sau NU?\",IF(AN101=\"DA\",IF(((AK101+AL101)-(AE101+AF101))*24<-720,\"Neinformat\",((AK101+AL101)-(AE101+AF101))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":9.9999999976716936E-2},{"$f":"IF(B101=\"X\",IF(AN101=\"DA\",IF(AR101<6,LEN(TRIM(V101))-LEN(SUBSTITUTE(V101,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":1},{"$f":"IF(B101=\"X\",IF(AN101=\"DA\",LEN(TRIM(V101))-LEN(SUBSTITUTE(V101,CHAR(44),\"\"))+1,\"-\"),\"\")","v":1},{"$f":"IF(B101=\"X\",IF(AN101=\"\",\"Afectat sau NU?\",IF(AN101=\"DA\",IF(((AI101+AJ101)-(AE101+AF101))*24<-720,\"Neinformat\",((AI101+AJ101)-(AE101+AF101))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":0.24999999994179234},{"$f":"IF(B101=\"X\",IF(AN101=\"DA\",IF(AU101<6,LEN(TRIM(U101))-LEN(SUBSTITUTE(U101,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":37},{"$f":"IF(B101=\"X\",IF(AN101=\"DA\",LEN(TRIM(U101))-LEN(SUBSTITUTE(U101,CHAR(44),\"\"))+1,\"-\"),\"\")","v":37},{"$f":"IF(B101=\"X\",IF(AN101=\"\",\"Afectat sau NU?\",IF(AN101=\"DA\",((AG101+AH101)-(AE101+AF101))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":8.0833333333139308},{"$f":"IF(B101=\"X\",IF(AN101=\"DA\",IF(AX101>24,IF(BA101=\"NU\",0,LEN(TRIM(V101))-LEN(SUBSTITUTE(V101,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":0},{"$f":"IF(B101=\"X\",IF(AN101=\"DA\",IF(AX101>24,LEN(TRIM(V101))-LEN(SUBSTITUTE(V101,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":0},null,null,null,null,null,{"$f":"IF(C101=\"X\",IF(AN101=\"\",\"Afectat sau NU?\",IF(AN101=\"DA\",IF(AK101=\"\",\"Neinformat\",NETWORKDAYS(AK101+AL101,AE101+AF101,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C101=\"X\",IF(AN101=\"DA\",IF(AND(BF101>=5,AK101<>\"\"),LEN(TRIM(V101))-LEN(SUBSTITUTE(V101,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C101=\"X\",IF(AN101=\"DA\",LEN(TRIM(V101))-LEN(SUBSTITUTE(V101,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C101=\"X\",IF(AN101=\"\",\"Afectat sau NU?\",IF(AN101=\"DA\",IF(AI101=\"\",\"Neinformat\",NETWORKDAYS(AI101+AJ101,AE101+AF101,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C101=\"X\",IF(AN101=\"DA\",IF(AND(BI101>=5,AI101<>\"\"),LEN(TRIM(U101))-LEN(SUBSTITUTE(U101,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C101=\"X\",IF(AN101=\"DA\",LEN(TRIM(U101))-LEN(SUBSTITUTE(U101,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C101=\"X\",IF(AN101=\"\",\"Afectat sau NU?\",IF(AN101=\"DA\",((AG101+AH101)-(Z101+AA101))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C101=\"X\",IF(AN101<>\"DA\",\"-\",IF(AND(AN101=\"DA\",BL101<=0),LEN(TRIM(V101))-LEN(SUBSTITUTE(V101,CHAR(44),\"\"))+1+LEN(TRIM(U101))-LEN(SUBSTITUTE(U101,CHAR(44),\"\"))+1,0)),\"\")","v":""},{"$f":"IF(C101=\"X\",IF(AN101=\"DA\",LEN(TRIM(V101))-LEN(SUBSTITUTE(V101,CHAR(44),\"\"))+1+LEN(TRIM(U101))-LEN(SUBSTITUTE(U101,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""}]
[87,"x","-","Înlocuire două cupoane pe conducta DN600 Mihai Bravu - Năvodari",61381,"Cogealac","Constanța",782516.04,345108,782516.04,345108,"-","-","SM1002D0","Cogealac","-","-","-","-","SM-SD001","Alpha Metal, Nova Power, Bepco, Cez Vânzare, Conef Gaz, Distrigaz Sud Rețele, Distrigaz Vest, Engie, E.on Energie, Electrocentrale București, Electrocentrale Constanța, Electrica Furnizare, Electric Planners, Energy Distribution, Enel Energie, Enel Muntenia, Entrex, Euro Seven, Eye Mall, Premier Energy Trading, Gaz Est, Getica95, Megaconstruct, Met România, Monsson, Termoenergetica București, MVM Future, Next Energy Distribution, Next Energy Partners, Premier Energy, Petrom, Gas Provider, Renovatio, Romgaz, RWE Supply, Sustainable Energy, Termo Calor, Tinmar, Transenergo, Termoelectrica Giurgiu","Distrigaz Sud Rețele","-","2023-05-12","09:13:00","2023-05-13","07:00:00","Constanța","Efectuată",null,"2023-05-12","09:13:00","2023-05-12","19:00:00","2023-05-12","09:28:00","2023-05-12","09:21:00","34646/10.05.2023","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.13333333324408159},{"$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.24999999994179234},{"$f":"IF(B102=\"X\",IF(AN102=\"DA\",IF(AU102<6,LEN(TRIM(U102))-LEN(SUBSTITUTE(U102,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":40},{"$f":"IF(B102=\"X\",IF(AN102=\"DA\",LEN(TRIM(U102))-LEN(SUBSTITUTE(U102,CHAR(44),\"\"))+1,\"-\"),\"\")","v":40},{"$f":"IF(B102=\"X\",IF(AN102=\"\",\"Afectat sau NU?\",IF(AN102=\"DA\",((AG102+AH102)-(AE102+AF102))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":9.7833333332673647},{"$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","-","Întrerupere accidentală prin SRM Oradea I datorită închiderii accidentale a robinetului de ieșire din SRM",26671,"Palota","Bihor",257019.14,624573.64,257019.14,624573.64,"-","-","SM0300D0","Oradea I","-","-","-","-","SM-SD001","Nova Power, Cez Vânzare, Distrigaz Vest, Engie, AXPO Energy, E.on Energie, Electrica Furnizare, Energy Distribution, Enel Energie, Enel Muntenia, Eye Mall, Premier Energy Trading, Gaz Est, Gaz Vest, Lord Energy, Met România, MVM Future, Premier Energy, Petrom, Gas Provider, Renovatio, Romgaz, Tinmar","Gaz Vest","-","2023-05-16","13:20:00","2023-05-16","18:00:00","Cluj","Efectuată",null,"2023-05-16","13:20:00","2023-05-16","20:00:00","2023-05-16","14:38:00","2023-05-16","14:18: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.96666666667442769},{"$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":1.3000000000465661},{"$f":"IF(B103=\"X\",IF(AN103=\"DA\",IF(AU103<6,LEN(TRIM(U103))-LEN(SUBSTITUTE(U103,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":23},{"$f":"IF(B103=\"X\",IF(AN103=\"DA\",LEN(TRIM(U103))-LEN(SUBSTITUTE(U103,CHAR(44),\"\"))+1,\"-\"),\"\")","v":23},{"$f":"IF(B103=\"X\",IF(AN103=\"\",\"Afectat sau NU?\",IF(AN103=\"DA\",((AG103+AH103)-(AE103+AF103))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":6.6666666667442769},{"$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","-","Curățire cu PIG a conductei DN800 Șendreni - Butimanu",100692,"Urziceni","Ialomița",627362.46,359075.9,627362.46,359075.9,"-","-","SM1064D0","Urziceni Înmagazinat","-","-","-","-","VSM01","Alpha Metal, Nova Power, AOT Energy, Azomures, Bepco, Cez Vânzare, Colterm, Cordun, CPL Concordia, MM Data, Delgaz, Design Proiect, Distrigaz Vest, Engie, Axpo, E.on Energie, Electrocentrale București, Electrica Furnizare, Energy Distribution, Enel Energie, Enel Muntenia, Euro Seven, Eye Mall, Premier Energy Trading, Gaz Est, Gaz Nord Est, Cet Govora, Instant Construct, Lord Energy, Megaconstruct, Met Austria, Mihoc Oil, Modern Calor, Met România, Termoenergetica București, MVM Future Energy, Next Energy Distribution, Premier Energy, Petrom, Prisma Serv, Gas Provider, Renovatio, Romgaz, RWE Supply, Termo Calor, Termoficare Oradea, Termo Ploiești, Tinmar, Termoelectrica Giurgiu, Vest Energo","Romgaz - Depogaz Ploiești","-","2023-05-17","02:25:00","2023-05-17","05:30:00","Brăila","Efectuată",null,"2023-05-17","02:25:00","2023-05-17","03:30:00","2023-05-17","02:32:00","2023-05-17","02:27:00","35364/12.05.2023","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.11666666669771075},{"$f":"IF(B104=\"X\",IF(AN104=\"DA\",IF(AU104<6,LEN(TRIM(U104))-LEN(SUBSTITUTE(U104,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":50},{"$f":"IF(B104=\"X\",IF(AN104=\"DA\",LEN(TRIM(U104))-LEN(SUBSTITUTE(U104,CHAR(44),\"\"))+1,\"-\"),\"\")","v":50},{"$f":"IF(B104=\"X\",IF(AN104=\"\",\"Afectat sau NU?\",IF(AN104=\"DA\",((AG104+AH104)-(AE104+AF104))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":1.0833333333721384},{"$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","-","Curățire cu PIG a conductei DN800 Șendreni - Butimanu",101573,"Butimanu","Dâmbovița",571023.43999999994,354405.72,571023.43999999994,354405.72,"-","-","SM1066D0","Butimanu Înmagazinat","-","-","-","-","VSM01","Alpha Metal, Nova Power, AOT Energy, Azomures, Bepco, Cez Vânzare, Colterm, Cordun, CPL Concordia, MM Data, Delgaz, Design Proiect, Distrigaz Vest, Engie, Axpo, E.on Energie, Electrocentrale București, Electrica Furnizare, Energy Distribution, Enel Energie, Enel Muntenia, Euro Seven, Eye Mall, Premier Energy Trading, Gaz Est, Gaz Nord Est, Cet Govora, Instant Construct, Lord Energy, Megaconstruct, Met Austria, Mihoc Oil, Modern Calor, Met România, Termoenergetica București, MVM Future Energy, Next Energy Distribution, Premier Energy, Petrom, Prisma Serv, Gas Provider, Renovatio, Romgaz, RWE Supply, Termo Calor, Termoficare Oradea, Termo Ploiești, Tinmar, Termoelectrica Giurgiu, Vest Energo","Romgaz - Depogaz Ploiești","-","2023-05-17","08:54:00","2023-05-17","12:00:00","București","Efectuată",null,"2023-05-17","08:54:00","2023-05-17","12:00:00","2023-05-17","09:17:00","2023-05-17","09:11:00","35592/15.05.2023","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.28333333338377997},{"$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":0.38333333336049691},{"$f":"IF(B105=\"X\",IF(AN105=\"DA\",IF(AU105<6,LEN(TRIM(U105))-LEN(SUBSTITUTE(U105,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":50},{"$f":"IF(B105=\"X\",IF(AN105=\"DA\",LEN(TRIM(U105))-LEN(SUBSTITUTE(U105,CHAR(44),\"\"))+1,\"-\"),\"\")","v":50},{"$f":"IF(B105=\"X\",IF(AN105=\"\",\"Afectat sau NU?\",IF(AN105=\"DA\",((AG105+AH105)-(AE105+AF105))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":3.0999999999767169},{"$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 tronson de conductă de pe conducta DN200 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","Alpha Metal, Nova Power, Bepco, Cez Vânzare, Conef Gaz, Distrigaz Sud Rețele, Distrigaz Vest, Engie, E.on Energie, Electrocentrale București, Electrocentrale Constanța, Electrica Furnizare, Electric Planners, Energy Distribution, Enel Energie, Enel Muntenia, Entrex, Euro Seven, Eye Mall, Premier Energy Trading, Gaz Est, Getica95, Megaconstruct, Met România, Monsson, Termoenergetica București, MVM Future, Next Energy Distribution, Next Energy Partners, Premier Energy, Petrom, Gas Provider, Renovatio, Romgaz, RWE Supply, Sustainable Energy, Termo Calor, Tinmar, Transenergo, Termoelectrica Giurgiu","Distrigaz Sud Rețele","-","2023-05-17","07:00:00","2023-05-17","19:00:00","Brașov","Efectuată",null,"2023-05-17","07:00:00","2023-05-17","19:00:00","2023-05-17","07:34:00","2023-05-17","07:29:00","910/12.05.2023","DA",null,null,null,0.48333333333721384,1,1,0.56666666676755995,40,40,12,0,0,null,null,null,null,null,"","","","","","","","",""]
[92,"x","-","Înlocuire tronson de conductă de pe conducta DN200 racord SRM Poiana Brașov",42432,"Poiana Brașov","Brașov",543202.21,455663.91,543202.21,455663.91,"-","-","SM1113D0","Poiana Sticlăriei","-","-","-","-","SM-SD001","Alpha Metal, Nova Power, Bepco, Cez Vânzare, Conef Gaz, Distrigaz Sud Rețele, Distrigaz Vest, Engie, E.on Energie, Electrocentrale București, Electrocentrale Constanța, Electrica Furnizare, Electric Planners, Energy Distribution, Enel Energie, Enel Muntenia, Entrex, Euro Seven, Eye Mall, Premier Energy Trading, Gaz Est, Getica95, Megaconstruct, Met România, Monsson, Termoenergetica București, MVM Future, Next Energy Distribution, Next Energy Partners, Premier Energy, Petrom, Gas Provider, Renovatio, Romgaz, RWE Supply, Sustainable Energy, Termo Calor, Tinmar, Transenergo, Termoelectrica Giurgiu","Distrigaz Sud Rețele","-","2023-05-17","07:00:00","2023-05-17","19:00:00","Brașov","Efectuată",null,"2023-05-17","07:00:00","2023-05-17","19:00:00","2023-05-17","07:34:00","2023-05-17","07:29:00","910/12.05.2023","DA",null,null,null,{"$f":"IF(B107=\"X\",IF(AN107=\"\",\"Afectat sau NU?\",IF(AN107=\"DA\",IF(((AK107+AL107)-(AE107+AF107))*24<-720,\"Neinformat\",((AK107+AL107)-(AE107+AF107))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":0.48333333333721384},{"$f":"IF(B107=\"X\",IF(AN107=\"DA\",IF(AR107<6,LEN(TRIM(V107))-LEN(SUBSTITUTE(V107,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":1},{"$f":"IF(B107=\"X\",IF(AN107=\"DA\",LEN(TRIM(V107))-LEN(SUBSTITUTE(V107,CHAR(44),\"\"))+1,\"-\"),\"\")","v":1},{"$f":"IF(B107=\"X\",IF(AN107=\"\",\"Afectat sau NU?\",IF(AN107=\"DA\",IF(((AI107+AJ107)-(AE107+AF107))*24<-720,\"Neinformat\",((AI107+AJ107)-(AE107+AF107))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":0.56666666676755995},{"$f":"IF(B107=\"X\",IF(AN107=\"DA\",IF(AU107<6,LEN(TRIM(U107))-LEN(SUBSTITUTE(U107,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":40},{"$f":"IF(B107=\"X\",IF(AN107=\"DA\",LEN(TRIM(U107))-LEN(SUBSTITUTE(U107,CHAR(44),\"\"))+1,\"-\"),\"\")","v":40},{"$f":"IF(B107=\"X\",IF(AN107=\"\",\"Afectat sau NU?\",IF(AN107=\"DA\",((AG107+AH107)-(AE107+AF107))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":12},{"$f":"IF(B107=\"X\",IF(AN107=\"DA\",IF(AX107>24,IF(BA107=\"NU\",0,LEN(TRIM(V107))-LEN(SUBSTITUTE(V107,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":0},{"$f":"IF(B107=\"X\",IF(AN107=\"DA\",IF(AX107>24,LEN(TRIM(V107))-LEN(SUBSTITUTE(V107,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":0},null,null,null,null,null,{"$f":"IF(C107=\"X\",IF(AN107=\"\",\"Afectat sau NU?\",IF(AN107=\"DA\",IF(AK107=\"\",\"Neinformat\",NETWORKDAYS(AK107+AL107,AE107+AF107,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C107=\"X\",IF(AN107=\"DA\",IF(AND(BF107>=5,AK107<>\"\"),LEN(TRIM(V107))-LEN(SUBSTITUTE(V107,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C107=\"X\",IF(AN107=\"DA\",LEN(TRIM(V107))-LEN(SUBSTITUTE(V107,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C107=\"X\",IF(AN107=\"\",\"Afectat sau NU?\",IF(AN107=\"DA\",IF(AI107=\"\",\"Neinformat\",NETWORKDAYS(AI107+AJ107,AE107+AF107,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C107=\"X\",IF(AN107=\"DA\",IF(AND(BI107>=5,AI107<>\"\"),LEN(TRIM(U107))-LEN(SUBSTITUTE(U107,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C107=\"X\",IF(AN107=\"DA\",LEN(TRIM(U107))-LEN(SUBSTITUTE(U107,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C107=\"X\",IF(AN107=\"\",\"Afectat sau NU?\",IF(AN107=\"DA\",((AG107+AH107)-(Z107+AA107))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C107=\"X\",IF(AN107<>\"DA\",\"-\",IF(AND(AN107=\"DA\",BL107<=0),LEN(TRIM(V107))-LEN(SUBSTITUTE(V107,CHAR(44),\"\"))+1+LEN(TRIM(U107))-LEN(SUBSTITUTE(U107,CHAR(44),\"\"))+1,0)),\"\")","v":""},{"$f":"IF(C107=\"X\",IF(AN107=\"DA\",LEN(TRIM(V107))-LEN(SUBSTITUTE(V107,CHAR(44),\"\"))+1+LEN(TRIM(U107))-LEN(SUBSTITUTE(U107,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""}]
[93,"x","-","Lucrări de mentenanță în SRM Timișoara III",155252,"Timișoara","Timiș",201059.01,477033.06,201059.01,477033.06,"-","-","SM0338D0","Timișoara III","-","-","-","-","SM-SD001","Nova Power, Cet Hidrocarburi, Cez Vânzare, CPL Concordia, Delgaz, Design Proiect, Distrigaz Vest, Engie, Axpo, E.on Energie, Electrica Furnizare, Electric Planners, Energy Distribution, Enel Energie, Enel Muntenia, Entrex, Eye Mall, Premier Energy Trading, Gaz Est, Gazmir, Lord Energy, Mihoc Oil, Met România, Monsson, MVM Future, Next Energy Distribution, Next Energy Partners, Premier Energy, Petrom, Prisma Serv, Gas Provider, Renovatio, Romgaz, RWE Supply, Tetarom, Tinmar, Transenergo","Delgaz Grid","-","2023-05-17","08:45:00","2023-05-19","18:00:00","Arad","Efectuată",null,"2023-05-17","08:45:00","2023-05-19","10:54:00","2023-05-17","09:09:00","2023-05-17","09:00:00","35895/15.05.2023","NU",null,null,null,"Nu a fost afectat producator/consumator","-","-","Nu a fost afectat producator/consumator","-","-","Nu a fost afectat producator/consumator","-","-",null,null,null,null,null,"","","","","","","","",""]
[94,"x","-","Lucrări de mentenanță în SRM Giarmata-Vii",155305,"Giarmata-Vii","Timiș",211961.9,484303.83,211961.9,484303.83,"-","-","SM0346D0","Giarmata-Vii","-","-","-","-","SM-SD001","Nova Power, Cet Hidrocarburi, Cez Vânzare, CPL Concordia, Delgaz, Design Proiect, Distrigaz Vest, Engie, Axpo, E.on Energie, Electrica Furnizare, Electric Planners, Energy Distribution, Enel Energie, Enel Muntenia, Entrex, Eye Mall, Premier Energy Trading, Gaz Est, Gazmir, Lord Energy, Mihoc Oil, Met România, Monsson, MVM Future, Next Energy Distribution, Next Energy Partners, Premier Energy, Petrom, Prisma Serv, Gas Provider, Renovatio, Romgaz, RWE Supply, Tetarom, Tinmar, Transenergo","Delgaz Grid","-","2023-05-23","08:33:00","2023-05-23","17:00:00","Arad","Efectuată",null,"2023-05-23","08:33:00","2023-05-23","16:08:00","2023-05-23","09:29:00","2023-05-23","09:25:00","37167/19.05.2023","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.86666666669771075},{"$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":0.93333333340706304},{"$f":"IF(B109=\"X\",IF(AN109=\"DA\",IF(AU109<6,LEN(TRIM(U109))-LEN(SUBSTITUTE(U109,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":37},{"$f":"IF(B109=\"X\",IF(AN109=\"DA\",LEN(TRIM(U109))-LEN(SUBSTITUTE(U109,CHAR(44),\"\"))+1,\"-\"),\"\")","v":37},{"$f":"IF(B109=\"X\",IF(AN109=\"\",\"Afectat sau NU?\",IF(AN109=\"DA\",((AG109+AH109)-(AE109+AF109))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":7.5833333334303461},{"$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":""}]