{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["2021-2022"],"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":"2021-2022","index":0,"n_rows":97,"n_cols":72,"rows_kept":97,"cut":false,"hidden":false,"merged":[[12,35,13,35],[12,36,13,36],[10,22,13,22],[12,26,13,26],[12,25,13,25],[12,24,13,24],[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],[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],[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,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],[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]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"2021-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,"2021-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-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,"2022-04-22","Vinerea Mare"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022-04-25","A doua zi de Paste Ortodox"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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-06-01","Ziua copilului"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,"2022-06-13","A doua zi de Rusalii"]
["EVIDENȚA LIMITĂRILOR ȘI/SAU ÎNTRERUPERILOR PLANIFICATE ȘI NEPLANIFICATE pentru anul gazier 2021 - 2022 / RECORD OF THE PLANNED AND UNPLANNED LIMITATIONS AND/OR INTERRUPTIONS related to the gas year 2021 - 2022",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":0},{"$f":"SUBTOTAL(9,AV:AV)","v":0},null,"Lucrari programate",null,null,null,null,null,null,null,null,"NU5",{"$f":"SUBTOTAL(9,BG:BG)","v":0},{"$f":"SUBTOTAL(9,BJ:BJ)","v":0},null,"2022-08-15","Adormirea Maicii Domnului"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,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":0},{"$f":"SUBTOTAL(9,AW:AW)","v":0},null,"Partener adiacent",null,null,"UR",null,null,null,null,null,"NUafectati ",{"$f":"SUBTOTAL(9,BH:BH)","v":0},{"$f":"SUBTOTAL(9,BK:BK)","v":0}]
["Nr. crt. / Item No.","Tipul limitării/întreruperii / \nType of limitation/interruption",null,"Denumire lucrare/motiv limitare și/sau întrerupere / \nName of the works/reason for the limitation and/or interruption ","Locația limitării/întreruperii / Location of the limitation/interruption ",null,null,null,null,null,null,"Punct de ieșire/intrare afectat / Affected exit/entry point",null,null,null,null,null,null,null,"Cod punct relevant / Code of the relevant point","Utilizator ST afectat / Affected TS user ",null,"Perioada planificată de execuție a lucrării / Planned period for the execution of the works","Data și ora limitării/întreruperii / Date and hour of the limitation/interruption ",null,"Data și ora reluării prestării serviciului / Date and hour the service supply is resumed",null,"Exploatarea Teritorială / Regional Office","Observații / Comments","Justificarea modificării perioadei planificate de execuție a lucrări","Data și ora efectivă de limitare/întrerupere ",null,"Data și ora efectivă de reluare a prestării serviciului",null,"Data și ora informării UR",null,"Data și ora informării partenerului adiacent",null,"Foaia de manevră","A fost afectat producătorul (în cazul PM) sau consumatorul final (în cazul SM)? \n(DA/NU)","Observatii","Program bugetat",null,"Numar de ore de la producerea intreruperii / limitarii pana la anuntarea partenerului adiacent\n (trebuie sa fie mai mic decat 6)","NU6","NUafectati","Numar de ore de la producerea intreruperii / limitarii pana la anuntarea UR\n (trebuie sa fie mai mic decat 6)","NU6","NUafectati","Durata intreruperii / limitarii [ore]\n(daca este mai mare de 24, trebuie sa fie completata celula aferenta de pe coloana AZ)","NU24","Nuafectati","Partener adiacent informat din 12 in 12 ore, daca durata mai mare de 24h\n(DA/NU)","NU6 ",{"$f":"BC9+BD9","v":0},"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":0},"IP61"]
[null,null,null,null,"Siruta / Siruta code","Localitate / Locality","Județ / County","Coordonate GPS început / GPS coordinates-beginning",null,"Coordonate GPS sfârșit / GPS coordinates-end",null,"Puncte de ieșire din SNT / NTS exit points",null,null,null,"Puncte de intrare în SNT / NTS entry points ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NUafectati ",{"$f":"BC10+BD10","v":0},{"$f":"IF(BC12=0,1,BC11/BC12)","v":1},null,null,null,null,null,null,null,null,null,null,"NUafectati ",{"$f":"BP10+BQ10","v":0},{"$f":"IF(BP12=0,1,BP11/BP12)","v":1}]
[null,"Neplanificată / Unplanned","Planificată / Planned",null,null,null,null,null,null,null,null,"Limitare / Limitation",null,"Întrerupere / Interruption",null,"Limitare / Limitation",null,"Întrerupere / Interruption",null,null,null,null,null,"Data / Date","Ora / Hour","Data / Date","Ora / Hour",null,null,null,"Data","Ora","Data","Ora","Data","Ora","Data","Ora",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NU24",{"$f":"SUBTOTAL(9,AY:AY)","v":0},"IP52",null,null,null,null,null,null,null,null,null,null,"NUreluare",{"$f":"SUBTOTAL(9,BM:BM)","v":0},"IP62"]
[null,null,null,null,null,null,null,"X1","Y1","X2","Y2","Cod / Code","Denumire / Name","Cod / Code","Denumire / Name","Cod / Code","Denumire / Name","Cod / Code","Denumire / Name",null,"Utilizator de rețea / Network User","Partener adiacent / Adjacent Partner",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NUafectati",{"$f":"SUBTOTAL(9,AZ:AZ)","v":0},{"$f":"IF(BC14=0,1,BC13/BC14)","v":1},null,null,null,null,null,null,null,null,null,null,"NUafectati",{"$f":"SUBTOTAL(9,BN:BN)","v":0},{"$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]
[1,"-","x","Punere în siguranță subtraversare râu Bistrița cu conducta 12” Piatra Neamț - Bicaz, în zona Viișoara",124965,"Bisericani","Neamț",594524.28,607357.25,594524.28,607357.25,"-","-","SM0456D0","Spitalul de Pneumoftiziologie Bisericani","-","-","-","-","SM-CF001",null,"Spitalul de Pneumoftiziologie Bisericani","octombrie - decembrie 2021",null,null,null,null,"Bacău",null,null,null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2021_IB1_Anexa 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":"-"}]
[{"$f":"A16+1","v":2},"-","x","Punere în siguranță subtraversare râu Bistrița cu conducta 12” Piatra Neamț - Bicaz, în zona Viișoara",124992,"Vaduri","Neamț",595164.76,604317.65,595164.76,604317.65,"-","-","SM0457D0","SC Unopan Vaduri","-","-","-","-","SM-CF001",null,"SC Unopan SRL","octombrie - decembrie 2021",null,null,null,null,"Bacău",null,null,null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2021_IB1_Anexa 1",null,{"$f":"IF(B17=\"X\",IF(AN17=\"\",\"Afectat sau NU?\",IF(AN17=\"DA\",IF(((AK17+AL17)-(AE17+AF17))*24<-720,\"Neinformat\",((AK17+AL17)-(AE17+AF17))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B17=\"X\",IF(AN17=\"DA\",IF(AR17<6,LEN(TRIM(V17))-LEN(SUBSTITUTE(V17,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B17=\"X\",IF(AN17=\"DA\",LEN(TRIM(V17))-LEN(SUBSTITUTE(V17,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B17=\"X\",IF(AN17=\"\",\"Afectat sau NU?\",IF(AN17=\"DA\",IF(((AI17+AJ17)-(AE17+AF17))*24<-720,\"Neinformat\",((AI17+AJ17)-(AE17+AF17))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B17=\"X\",IF(AN17=\"DA\",IF(AU17<6,LEN(TRIM(U17))-LEN(SUBSTITUTE(U17,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B17=\"X\",IF(AN17=\"DA\",LEN(TRIM(U17))-LEN(SUBSTITUTE(U17,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B17=\"X\",IF(AN17=\"\",\"Afectat sau NU?\",IF(AN17=\"DA\",((AG17+AH17)-(AE17+AF17))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B17=\"X\",IF(AN17=\"DA\",IF(AX17>24,IF(BA17=\"NU\",0,LEN(TRIM(V17))-LEN(SUBSTITUTE(V17,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":""},{"$f":"IF(B17=\"X\",IF(AN17=\"DA\",IF(AX17>24,LEN(TRIM(V17))-LEN(SUBSTITUTE(V17,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(C17=\"X\",IF(AN17=\"\",\"Afectat sau NU?\",IF(AN17=\"DA\",IF(AK17=\"\",\"Neinformat\",NETWORKDAYS(AK17+AL17,AE17+AF17,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C17=\"X\",IF(AN17=\"DA\",IF(AND(BF17>=5,AK17<>\"\"),LEN(TRIM(V17))-LEN(SUBSTITUTE(V17,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C17=\"X\",IF(AN17=\"DA\",LEN(TRIM(V17))-LEN(SUBSTITUTE(V17,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C17=\"X\",IF(AN17=\"\",\"Afectat sau NU?\",IF(AN17=\"DA\",IF(AI17=\"\",\"Neinformat\",NETWORKDAYS(AI17+AJ17,AE17+AF17,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C17=\"X\",IF(AN17=\"DA\",IF(AND(BI17>=5,AI17<>\"\"),LEN(TRIM(U17))-LEN(SUBSTITUTE(U17,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C17=\"X\",IF(AN17=\"DA\",LEN(TRIM(U17))-LEN(SUBSTITUTE(U17,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C17=\"X\",IF(AN17=\"\",\"Afectat sau NU?\",IF(AN17=\"DA\",((AG17+AH17)-(Z17+AA17))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C17=\"X\",IF(AN17<>\"DA\",\"-\",IF(AND(AN17=\"DA\",BL17<=0),LEN(TRIM(V17))-LEN(SUBSTITUTE(V17,CHAR(44),\"\"))+1+LEN(TRIM(U17))-LEN(SUBSTITUTE(U17,CHAR(44),\"\"))+1,0)),\"\")","v":"-"},{"$f":"IF(C17=\"X\",IF(AN17=\"DA\",LEN(TRIM(V17))-LEN(SUBSTITUTE(V17,CHAR(44),\"\"))+1+LEN(TRIM(U17))-LEN(SUBSTITUTE(U17,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"}]
[{"$f":"A17+1","v":3},"-","x","Punere în siguranță subtraversare râu Bistrița cu conducta 12” Piatra Neamț - Bicaz, în zona Viișoara",124992,"Vaduri","Neamț",595078.51,604354.39,595078.51,604354.39,"-","-","SM0461D0","SC Kober Vaduri","-","-","-","-","SM-CF001",null,"SC Kober SRL - Sucursala Vaduri","octombrie - decembrie 2021",null,null,null,null,"Bacău",null,null,null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2021_IB1_Anexa 1",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[4,"-","x","Punere în siguranță subtraversare râu Bistrița cu conducta 12” Piatra Neamț - Bicaz, în zona Viișoara",124992,"Vaduri","Neamț",594758.28,604040.56000000006,594758.28,604040.56000000006,"-","-","SM1052D0","Vaduri","-","-","-","-","SM-SD001",null,"Delgaz Grid","octombrie - decembrie 2021",null,null,null,null,"Bacău",null,null,null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2021_IB1_Anexa 1",null,{"$f":"IF(B19=\"X\",IF(AN19=\"\",\"Afectat sau NU?\",IF(AN19=\"DA\",IF(((AK19+AL19)-(AE19+AF19))*24<-720,\"Neinformat\",((AK19+AL19)-(AE19+AF19))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B19=\"X\",IF(AN19=\"DA\",IF(AR19<6,LEN(TRIM(V19))-LEN(SUBSTITUTE(V19,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B19=\"X\",IF(AN19=\"DA\",LEN(TRIM(V19))-LEN(SUBSTITUTE(V19,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B19=\"X\",IF(AN19=\"\",\"Afectat sau NU?\",IF(AN19=\"DA\",IF(((AI19+AJ19)-(AE19+AF19))*24<-720,\"Neinformat\",((AI19+AJ19)-(AE19+AF19))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B19=\"X\",IF(AN19=\"DA\",IF(AU19<6,LEN(TRIM(U19))-LEN(SUBSTITUTE(U19,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B19=\"X\",IF(AN19=\"DA\",LEN(TRIM(U19))-LEN(SUBSTITUTE(U19,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B19=\"X\",IF(AN19=\"\",\"Afectat sau NU?\",IF(AN19=\"DA\",((AG19+AH19)-(AE19+AF19))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B19=\"X\",IF(AN19=\"DA\",IF(AX19>24,IF(BA19=\"NU\",0,LEN(TRIM(V19))-LEN(SUBSTITUTE(V19,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":""},{"$f":"IF(B19=\"X\",IF(AN19=\"DA\",IF(AX19>24,LEN(TRIM(V19))-LEN(SUBSTITUTE(V19,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(C19=\"X\",IF(AN19=\"\",\"Afectat sau NU?\",IF(AN19=\"DA\",IF(AK19=\"\",\"Neinformat\",NETWORKDAYS(AK19+AL19,AE19+AF19,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C19=\"X\",IF(AN19=\"DA\",IF(AND(BF19>=5,AK19<>\"\"),LEN(TRIM(V19))-LEN(SUBSTITUTE(V19,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C19=\"X\",IF(AN19=\"DA\",LEN(TRIM(V19))-LEN(SUBSTITUTE(V19,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C19=\"X\",IF(AN19=\"\",\"Afectat sau NU?\",IF(AN19=\"DA\",IF(AI19=\"\",\"Neinformat\",NETWORKDAYS(AI19+AJ19,AE19+AF19,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C19=\"X\",IF(AN19=\"DA\",IF(AND(BI19>=5,AI19<>\"\"),LEN(TRIM(U19))-LEN(SUBSTITUTE(U19,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C19=\"X\",IF(AN19=\"DA\",LEN(TRIM(U19))-LEN(SUBSTITUTE(U19,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C19=\"X\",IF(AN19=\"\",\"Afectat sau NU?\",IF(AN19=\"DA\",((AG19+AH19)-(Z19+AA19))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C19=\"X\",IF(AN19<>\"DA\",\"-\",IF(AND(AN19=\"DA\",BL19<=0),LEN(TRIM(V19))-LEN(SUBSTITUTE(V19,CHAR(44),\"\"))+1+LEN(TRIM(U19))-LEN(SUBSTITUTE(U19,CHAR(44),\"\"))+1,0)),\"\")","v":"-"},{"$f":"IF(C19=\"X\",IF(AN19=\"DA\",LEN(TRIM(V19))-LEN(SUBSTITUTE(V19,CHAR(44),\"\"))+1+LEN(TRIM(U19))-LEN(SUBSTITUTE(U19,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"}]
[5,"-","x","Punere în siguranță subtraversare râu Bistrița cu conducta 12” Piatra Neamț - Bicaz, în zona Viișoara",122604,"Stejaru","Neamț",589703.30000000005,602610.30000000005,589703.30000000005,602610.30000000005,"-","-","SM0458D0","Stejaru","-","-","-","-","SM-SD001",null,"Delgaz Grid","octombrie - decembrie 2021",null,null,null,null,"Bacău",null,null,null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2021_IB1_Anexa 1",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-",{"$f":"IF(C20=\"X\",IF(AN20=\"\",\"Afectat sau NU?\",IF(AN20=\"DA\",IF(AI20=\"\",\"Neinformat\",NETWORKDAYS(AI20+AJ20,AE20+AF20,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},"-","-","Afectat sau NU?","-","-"]
[6,"-","x","Punere în siguranță subtraversare râu Bistrița cu conducta 12” Piatra Neamț - Bicaz, în zona Viișoara",120977,"Bicaz","Neamț",583336.32999999996,601827.11,583336.32999999996,601827.11,"-","-","SM0459D0","Bicaz","-","-","-","-","SM-SD001",null,"Delgaz Grid","octombrie - decembrie 2021",null,null,null,null,"Bacău",null,null,null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2021_IB1_Anexa 1",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-",{"$f":"IF(C21=\"X\",IF(AN21=\"\",\"Afectat sau NU?\",IF(AN21=\"DA\",((AG21+AH21)-(Z21+AA21))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},"-","-"]
[{"$f":"A21+1","v":7},"-","x","Pregătire conductă 24” Paltin - Schitu Golești pentru transformare în conductă godevilabilă (jud. Argeș)",13506,"Câmpulung","Argeș",506375.179,420606.43400000001,506375.179,420606.43400000001,"-","-","SM0429D0","SC Edilul Câmpulung","-","-","-","-","SM-CF001",null,"SC Edilul C.G.A. SA","iulie - septembrie 2022",null,null,null,null,"Craiova",null,null,null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2021_IIA2_Anexa 1",null,"","","","","","","","","",null,null,null,null,null,{"$f":"IF(C22=\"X\",IF(AN22=\"\",\"Afectat sau NU?\",IF(AN22=\"DA\",IF(AK22=\"\",\"Neinformat\",NETWORKDAYS(AK22+AL22,AE22+AF22,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C22=\"X\",IF(AN22=\"DA\",IF(AND(BF22>=5,AK22<>\"\"),LEN(TRIM(V22))-LEN(SUBSTITUTE(V22,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C22=\"X\",IF(AN22=\"DA\",LEN(TRIM(V22))-LEN(SUBSTITUTE(V22,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C22=\"X\",IF(AN22=\"\",\"Afectat sau NU?\",IF(AN22=\"DA\",IF(AI22=\"\",\"Neinformat\",NETWORKDAYS(AI22+AJ22,AE22+AF22,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C22=\"X\",IF(AN22=\"DA\",IF(AND(BI22>=5,AI22<>\"\"),LEN(TRIM(U22))-LEN(SUBSTITUTE(U22,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C22=\"X\",IF(AN22=\"DA\",LEN(TRIM(U22))-LEN(SUBSTITUTE(U22,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C22=\"X\",IF(AN22=\"\",\"Afectat sau NU?\",IF(AN22=\"DA\",((AG22+AH22)-(Z22+AA22))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C22=\"X\",IF(AN22<>\"DA\",\"-\",IF(AND(AN22=\"DA\",BL22<=0),LEN(TRIM(V22))-LEN(SUBSTITUTE(V22,CHAR(44),\"\"))+1+LEN(TRIM(U22))-LEN(SUBSTITUTE(U22,CHAR(44),\"\"))+1,0)),\"\")","v":"-"},{"$f":"IF(C22=\"X\",IF(AN22=\"DA\",LEN(TRIM(V22))-LEN(SUBSTITUTE(V22,CHAR(44),\"\"))+1+LEN(TRIM(U22))-LEN(SUBSTITUTE(U22,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"}]
[8,"-","x","Pregătire conductă 24” Paltin - Schitu Golești pentru transformare în conductă godevilabilă (jud. Argeș)",13506,"Câmpulung","Argeș",506435.56099999999,420938.47100000002,506435.56099999999,420938.47100000002,"-","-","SM0874D0","SC Complex Holcim Câmpulung Sediu","-","-","-","-","SM-CF001",null,"SC Holcim (România) SA","iulie - septembrie 2022",null,null,null,null,"Craiova",null,null,null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2021_IIA2_Anexa 1",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[9,"-","x","Pregătire conductă 24” Paltin - Schitu Golești pentru transformare în conductă godevilabilă (jud. Argeș)",13506,"Câmpulung","Argeș",506492.15500000003,421280.19400000002,506492.15500000003,421280.19400000002,"-","-","SM0078D0","SC Romturingia Câmpulung","-","-","-","-","SM-CF001",null,"SC Romturingia SRL","iulie - septembrie 2022",null,null,null,null,"Craiova",null,null,null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2021_IIA2_Anexa 1",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[10,"-","x","Pregătire conductă 24” Paltin - Schitu Golești pentru transformare în conductă godevilabilă (jud. Argeș)",13506,"Câmpulung","Argeș",509108.28096399998,421227.17672599998,509108.28096399998,421227.17672599998,"-","-","SM0213D1","SC Holcim Câmpulung","-","-","-","-","SM-CF001",null,"SC Holcim (România) SA","iulie - septembrie 2022",null,null,null,null,"Craiova",null,null,null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2021_IIA2_Anexa 1",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[11,"-","x","Pregătire conductă 24” Paltin - Schitu Golești pentru transformare în conductă godevilabilă (jud. Argeș)",13506,"Câmpulung","Argeș",509108.28096399998,421227.17672599998,509108.28096399998,421227.17672599998,"-","-","SM0213D2","SC Carmeuse Holding Câmpulung","-","-","-","-","SM-CF001",null,"SC Carmeuse Holding SRL","iulie - septembrie 2022",null,null,null,null,"Craiova",null,null,null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2021_IIA2_Anexa 1",null,{"$f":"IF(B26=\"X\",IF(AN26=\"\",\"Afectat sau NU?\",IF(AN26=\"DA\",IF(((AK26+AL26)-(AE26+AF26))*24<-720,\"Neinformat\",((AK26+AL26)-(AE26+AF26))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B26=\"X\",IF(AN26=\"DA\",IF(AR26<6,LEN(TRIM(V26))-LEN(SUBSTITUTE(V26,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B26=\"X\",IF(AN26=\"DA\",LEN(TRIM(V26))-LEN(SUBSTITUTE(V26,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B26=\"X\",IF(AN26=\"\",\"Afectat sau NU?\",IF(AN26=\"DA\",IF(((AI26+AJ26)-(AE26+AF26))*24<-720,\"Neinformat\",((AI26+AJ26)-(AE26+AF26))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B26=\"X\",IF(AN26=\"DA\",IF(AU26<6,LEN(TRIM(U26))-LEN(SUBSTITUTE(U26,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B26=\"X\",IF(AN26=\"DA\",LEN(TRIM(U26))-LEN(SUBSTITUTE(U26,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B26=\"X\",IF(AN26=\"\",\"Afectat sau NU?\",IF(AN26=\"DA\",((AG26+AH26)-(AE26+AF26))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B26=\"X\",IF(AN26=\"DA\",IF(AX26>24,IF(BA26=\"NU\",0,LEN(TRIM(V26))-LEN(SUBSTITUTE(V26,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":""},{"$f":"IF(B26=\"X\",IF(AN26=\"DA\",IF(AX26>24,LEN(TRIM(V26))-LEN(SUBSTITUTE(V26,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(C26=\"X\",IF(AN26=\"\",\"Afectat sau NU?\",IF(AN26=\"DA\",IF(AK26=\"\",\"Neinformat\",NETWORKDAYS(AK26+AL26,AE26+AF26,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C26=\"X\",IF(AN26=\"DA\",IF(AND(BF26>=5,AK26<>\"\"),LEN(TRIM(V26))-LEN(SUBSTITUTE(V26,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C26=\"X\",IF(AN26=\"DA\",LEN(TRIM(V26))-LEN(SUBSTITUTE(V26,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C26=\"X\",IF(AN26=\"\",\"Afectat sau NU?\",IF(AN26=\"DA\",IF(AI26=\"\",\"Neinformat\",NETWORKDAYS(AI26+AJ26,AE26+AF26,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C26=\"X\",IF(AN26=\"DA\",IF(AND(BI26>=5,AI26<>\"\"),LEN(TRIM(U26))-LEN(SUBSTITUTE(U26,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C26=\"X\",IF(AN26=\"DA\",LEN(TRIM(U26))-LEN(SUBSTITUTE(U26,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C26=\"X\",IF(AN26=\"\",\"Afectat sau NU?\",IF(AN26=\"DA\",((AG26+AH26)-(Z26+AA26))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C26=\"X\",IF(AN26<>\"DA\",\"-\",IF(AND(AN26=\"DA\",BL26<=0),LEN(TRIM(V26))-LEN(SUBSTITUTE(V26,CHAR(44),\"\"))+1+LEN(TRIM(U26))-LEN(SUBSTITUTE(U26,CHAR(44),\"\"))+1,0)),\"\")","v":"-"},{"$f":"IF(C26=\"X\",IF(AN26=\"DA\",LEN(TRIM(V26))-LEN(SUBSTITUTE(V26,CHAR(44),\"\"))+1+LEN(TRIM(U26))-LEN(SUBSTITUTE(U26,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"}]
[12,"-","x","Pregătire conductă 24” Paltin - Schitu Golești pentru transformare în conductă godevilabilă (jud. Argeș)",13533,"Valea Mare Pravăț","Argeș",509108.28096399998,421227.17672599998,509108.28096399998,421227.17672599998,"-","-","SM0213D3","SC Star Multitrade Pravăț","-","-","-","-","SM-SD001",null,"SC Distrigaz Sud Rețele","iulie - septembrie 2022",null,null,null,null,"Craiova",null,null,null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2021_IIA2_Anexa 1",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[13,"-","x","Pregătire conductă 24” Paltin - Schitu Golești pentru transformare în conductă godevilabilă (jud. Argeș)",13506,"Câmpulung","Argeș",504544.17111499998,418845.73154000001,504544.17111499998,418845.73154000001,"-","-","SM0216D0","Câmpulung Muscel","-","-","-","-","SM-SD001",null,"SC Distrigaz Sud Rețele","iulie - septembrie 2022",null,null,null,null,"Craiova",null,null,null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2021_IIA2_Anexa 1",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[14,"-","x","Pregătire conductă 24” Paltin - Schitu Golești pentru transformare în conductă godevilabilă (jud. Argeș)",16917,"Lerești","Argeș",505375.83399999997,421813.47600000002,505375.83399999997,421813.47600000002,"-","-","SM1242D0","Lerești","-","-","-","-","SM-SD001",null,"SC Distrigaz Sud Rețele","iulie - septembrie 2022",null,null,null,null,"Craiova",null,null,null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2021_IIA2_Anexa 1",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[15,"-","x","Pregătire conductă 24” Paltin - Schitu Golești pentru transformare în conductă godevilabilă (jud. Argeș)",16356,"Podu Dâmboviței","Argeș",515779.41327671334,434408.46333483607,515779.41327671334,434408.46333483607,"-","-","SM1088D0","Podu Dâmboviței","-","-","-","-","SM-SD001",null,"SC Distrigaz Sud Rețele","iulie - septembrie 2022",null,null,null,null,"Brașov",null,null,null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2021_IIA2_Anexa 1",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[16,"-","x","Pregătire conductă 24” Paltin - Schitu Golești pentru transformare în conductă godevilabilă (jud. Argeș)",18536,"Rucăr","Argeș",514200.63,431834.68,514200.63,431834.68,"-","-","SM0938D0","Rucăr","-","-","-","-","SM-SD001",null,"Distrigaz Sud Rețele","iulie - septembrie 2022",null,null,null,null,"Brașov",null,null,null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2021_IIA2_Anexa 1",null,{"$f":"IF(B31=\"X\",IF(AN31=\"\",\"Afectat sau NU?\",IF(AN31=\"DA\",IF(((AK31+AL31)-(AE31+AF31))*24<-720,\"Neinformat\",((AK31+AL31)-(AE31+AF31))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B31=\"X\",IF(AN31=\"DA\",IF(AR31<6,LEN(TRIM(V31))-LEN(SUBSTITUTE(V31,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B31=\"X\",IF(AN31=\"DA\",LEN(TRIM(V31))-LEN(SUBSTITUTE(V31,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B31=\"X\",IF(AN31=\"\",\"Afectat sau NU?\",IF(AN31=\"DA\",IF(((AI31+AJ31)-(AE31+AF31))*24<-720,\"Neinformat\",((AI31+AJ31)-(AE31+AF31))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B31=\"X\",IF(AN31=\"DA\",IF(AU31<6,LEN(TRIM(U31))-LEN(SUBSTITUTE(U31,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B31=\"X\",IF(AN31=\"DA\",LEN(TRIM(U31))-LEN(SUBSTITUTE(U31,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B31=\"X\",IF(AN31=\"\",\"Afectat sau NU?\",IF(AN31=\"DA\",((AG31+AH31)-(AE31+AF31))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B31=\"X\",IF(AN31=\"DA\",IF(AX31>24,IF(BA31=\"NU\",0,LEN(TRIM(V31))-LEN(SUBSTITUTE(V31,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":""},{"$f":"IF(B31=\"X\",IF(AN31=\"DA\",IF(AX31>24,LEN(TRIM(V31))-LEN(SUBSTITUTE(V31,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(C31=\"X\",IF(AN31=\"\",\"Afectat sau NU?\",IF(AN31=\"DA\",IF(AK31=\"\",\"Neinformat\",NETWORKDAYS(AK31+AL31,AE31+AF31,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C31=\"X\",IF(AN31=\"DA\",IF(AND(BF31>=5,AK31<>\"\"),LEN(TRIM(V31))-LEN(SUBSTITUTE(V31,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C31=\"X\",IF(AN31=\"DA\",LEN(TRIM(V31))-LEN(SUBSTITUTE(V31,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C31=\"X\",IF(AN31=\"\",\"Afectat sau NU?\",IF(AN31=\"DA\",IF(AI31=\"\",\"Neinformat\",NETWORKDAYS(AI31+AJ31,AE31+AF31,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C31=\"X\",IF(AN31=\"DA\",IF(AND(BI31>=5,AI31<>\"\"),LEN(TRIM(U31))-LEN(SUBSTITUTE(U31,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C31=\"X\",IF(AN31=\"DA\",LEN(TRIM(U31))-LEN(SUBSTITUTE(U31,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C31=\"X\",IF(AN31=\"\",\"Afectat sau NU?\",IF(AN31=\"DA\",((AG31+AH31)-(Z31+AA31))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C31=\"X\",IF(AN31<>\"DA\",\"-\",IF(AND(AN31=\"DA\",BL31<=0),LEN(TRIM(V31))-LEN(SUBSTITUTE(V31,CHAR(44),\"\"))+1+LEN(TRIM(U31))-LEN(SUBSTITUTE(U31,CHAR(44),\"\"))+1,0)),\"\")","v":"-"},{"$f":"IF(C31=\"X\",IF(AN31=\"DA\",LEN(TRIM(V31))-LEN(SUBSTITUTE(V31,CHAR(44),\"\"))+1+LEN(TRIM(U31))-LEN(SUBSTITUTE(U31,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"}]
[17,"-","x","Pregătire conductă 28” Seleuș - Cristur - Bățani pentru transformare în conductă godevilabilă, etapa 2B (jud. Harghita)",85582,"Secuieni HG","Harghita",528595,498017,528595,498017,"-","-","SM0374D0","Secuieni I HG","-","-","-","-","SM-SD001",null,"Hargaz Harghita Gaz","aprilie - iunie 2022",null,null,null,null,"Brașov",null,null,null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2021_IIA6_Anexa 1",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[18,"-","x","Pregătire conductă 28” Seleuș - Cristur - Bățani pentru transformare în conductă godevilabilă, etapa 2B (jud. Harghita)",85582,"Secuieni HG","Harghita",528595,498017,528595,498017,"-","-","SM0374D1","Secuieni II HG","-","-","-","-","SM-SD001",null,"Hargaz Harghita Gaz","aprilie - iunie 2022",null,null,null,null,"Brașov",null,null,null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2021_IIA6_Anexa 1",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[19,"-","x","Pregătire conductă 28” Seleuș - Cristur - Bățani pentru transformare în conductă godevilabilă, etapa 2B (jud. Harghita)",83525,"Cristuru Secuiesc","Harghita",502769,530742,502769,530742,"-","-","SM0373D0","Cristuru Secuiesc","-","-","-","-","SM-SD001",null,"Delgaz Grid","aprilie - iunie 2022",null,null,null,null,"Brașov",null,null,null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2021_IIA6_Anexa 1",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[20,"-","x","Pregătire conductă 28” Seleuș - Cristur - Bățani pentru transformare în conductă godevilabilă, etapa 2B (jud. Harghita)",85127,"Porumbenii Mici","Harghita",508388,530078,508388,530078,"-","-","SM0382D0","Porumbenii Mici","-","-","-","-","SM-SD001",null,"Hargaz Harghita Gaz","aprilie - iunie 2022",null,null,null,null,"Brașov",null,null,null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2021_IIA6_Anexa 1",null,{"$f":"IF(B35=\"X\",IF(AN35=\"\",\"Afectat sau NU?\",IF(AN35=\"DA\",IF(((AK35+AL35)-(AE35+AF35))*24<-720,\"Neinformat\",((AK35+AL35)-(AE35+AF35))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B35=\"X\",IF(AN35=\"DA\",IF(AR35<6,LEN(TRIM(V35))-LEN(SUBSTITUTE(V35,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B35=\"X\",IF(AN35=\"DA\",LEN(TRIM(V35))-LEN(SUBSTITUTE(V35,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B35=\"X\",IF(AN35=\"\",\"Afectat sau NU?\",IF(AN35=\"DA\",IF(((AI35+AJ35)-(AE35+AF35))*24<-720,\"Neinformat\",((AI35+AJ35)-(AE35+AF35))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B35=\"X\",IF(AN35=\"DA\",IF(AU35<6,LEN(TRIM(U35))-LEN(SUBSTITUTE(U35,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B35=\"X\",IF(AN35=\"DA\",LEN(TRIM(U35))-LEN(SUBSTITUTE(U35,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B35=\"X\",IF(AN35=\"\",\"Afectat sau NU?\",IF(AN35=\"DA\",((AG35+AH35)-(AE35+AF35))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B35=\"X\",IF(AN35=\"DA\",IF(AX35>24,IF(BA35=\"NU\",0,LEN(TRIM(V35))-LEN(SUBSTITUTE(V35,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":""},{"$f":"IF(B35=\"X\",IF(AN35=\"DA\",IF(AX35>24,LEN(TRIM(V35))-LEN(SUBSTITUTE(V35,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(C35=\"X\",IF(AN35=\"\",\"Afectat sau NU?\",IF(AN35=\"DA\",IF(AK35=\"\",\"Neinformat\",NETWORKDAYS(AK35+AL35,AE35+AF35,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C35=\"X\",IF(AN35=\"DA\",IF(AND(BF35>=5,AK35<>\"\"),LEN(TRIM(V35))-LEN(SUBSTITUTE(V35,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C35=\"X\",IF(AN35=\"DA\",LEN(TRIM(V35))-LEN(SUBSTITUTE(V35,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C35=\"X\",IF(AN35=\"\",\"Afectat sau NU?\",IF(AN35=\"DA\",IF(AI35=\"\",\"Neinformat\",NETWORKDAYS(AI35+AJ35,AE35+AF35,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C35=\"X\",IF(AN35=\"DA\",IF(AND(BI35>=5,AI35<>\"\"),LEN(TRIM(U35))-LEN(SUBSTITUTE(U35,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C35=\"X\",IF(AN35=\"DA\",LEN(TRIM(U35))-LEN(SUBSTITUTE(U35,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C35=\"X\",IF(AN35=\"\",\"Afectat sau NU?\",IF(AN35=\"DA\",((AG35+AH35)-(Z35+AA35))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C35=\"X\",IF(AN35<>\"DA\",\"-\",IF(AND(AN35=\"DA\",BL35<=0),LEN(TRIM(V35))-LEN(SUBSTITUTE(V35,CHAR(44),\"\"))+1+LEN(TRIM(U35))-LEN(SUBSTITUTE(U35,CHAR(44),\"\"))+1,0)),\"\")","v":"-"},{"$f":"IF(C35=\"X\",IF(AN35=\"DA\",LEN(TRIM(V35))-LEN(SUBSTITUTE(V35,CHAR(44),\"\"))+1+LEN(TRIM(U35))-LEN(SUBSTITUTE(U35,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"}]
[21,"-","x","Pregătire conductă 28” Seleuș - Cristur - Bățani pentru transformare în conductă godevilabilă, etapa 2B (jud. Harghita)",85127,"Porumbenii Mari","Harghita",510975,529795,510975,529795,"-","-","SM0383D0","Porumbenii Mari","-","-","-","-","SM-SD001",null,"Hargaz Harghita Gaz","aprilie - iunie 2022",null,null,null,null,"Brașov",null,null,null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2021_IIA6_Anexa 1",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[22,"-","x","Pregătire conductă 28” Seleuș - Cristur - Bățani pentru transformare în conductă godevilabilă, etapa 2B (jud. Harghita)",85127,"Lutița","Harghita",514498,528363,514498,528363,"-","-","SM0384D0","Lutița","-","-","-","-","SM-SD001",null,"Delgaz Grid","aprilie - iunie 2022",null,null,null,null,"Brașov",null,null,null,null,null,null,null,null,null,null,null,null,null,"PRRASM 2021_IIA6_Anexa 1",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[{"$f":"SUM(1,A37)","v":23},"-","x","Conductă de transport gaze naturale Nadeș - Sighișoara",114596,"Hetiur","Mureș",481685.76000000001,529831.52,481685.76000000001,529831.52,null,null,"SM0834D0","Hetiur",null,null,null,null,"SM-SD001",null,"Delgaz Grid","octombrie - decembrie 2021",null,null,null,null,"Brașov",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI 2021_cap.A_2.1.B.3",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[24,"-","x","Înlocuire tronson pe conducta de transport gaze naturale 8” racord SRM Poiana Brașov",42432,"Poiana Brașov","Braşov",543202.21,455663.91,543202.21,455663.91,"-","-","SM0054D0","Poiana Brașov","-","-","-","-","SM-SD001",null,"Distrigaz Sud Rețele","octombrie - decembrie 2021",null,null,null,null,"Brașov",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI 2021_cap.A_2.1.B.6",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[25,"-","x","Înlocuire tronson pe conducta de transport gaze naturale 8” racord SRM Poiana Brașov",42432,"Poiana Brașov","Braşov",543067.84,456573.21,543067.84,456573.21,"-","-","SM1113D0","Poiana Sticlăriei","-","-","-","-","SM-SD001",null,"Distrigaz Sud Rețele","octombrie - decembrie 2021",null,null,null,null,"Brașov",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI 2021_cap.A_2.1.B.6",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[26,"-","x","Punere în siguranță traversare aeriană peste canal râul Bistrița cu conducta 12” Piatra Neamț - Bicaz, zona Pângărați",122604,"Stejaru","Neamț",589703.30000000005,602610.30000000005,589703.30000000005,602610.30000000005,"-","-","SM0458D0","Stejaru","-","-","-","-","SM-SD001",null,"Delgaz Grid","aprilie - iunie 2022",null,null,null,null,"Bacău",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI 2021_cap.A_2.1.B.15",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[27,"-","x","Punere în siguranță traversare aeriană peste canal râul Bistrița cu conducta 12” Piatra Neamț - Bicaz, zona Pângărați",120977,"Bicaz","Neamț",583336.32999999996,601827.11,583336.32999999996,601827.11,"-","-","SM0459D0","Bicaz","-","-","-","-","SM-SD001",null,"Delgaz Grid","aprilie - iunie 2022",null,null,null,null,"Bacău",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI 2021_cap.A_2.1.B.15",null,{"$f":"IF(B42=\"X\",IF(AN42=\"\",\"Afectat sau NU?\",IF(AN42=\"DA\",IF(((AK42+AL42)-(AE42+AF42))*24<-720,\"Neinformat\",((AK42+AL42)-(AE42+AF42))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B42=\"X\",IF(AN42=\"DA\",IF(AR42<6,LEN(TRIM(V42))-LEN(SUBSTITUTE(V42,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B42=\"X\",IF(AN42=\"DA\",LEN(TRIM(V42))-LEN(SUBSTITUTE(V42,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B42=\"X\",IF(AN42=\"\",\"Afectat sau NU?\",IF(AN42=\"DA\",IF(((AI42+AJ42)-(AE42+AF42))*24<-720,\"Neinformat\",((AI42+AJ42)-(AE42+AF42))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B42=\"X\",IF(AN42=\"DA\",IF(AU42<6,LEN(TRIM(U42))-LEN(SUBSTITUTE(U42,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B42=\"X\",IF(AN42=\"DA\",LEN(TRIM(U42))-LEN(SUBSTITUTE(U42,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B42=\"X\",IF(AN42=\"\",\"Afectat sau NU?\",IF(AN42=\"DA\",((AG42+AH42)-(AE42+AF42))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B42=\"X\",IF(AN42=\"DA\",IF(AX42>24,IF(BA42=\"NU\",0,LEN(TRIM(V42))-LEN(SUBSTITUTE(V42,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":""},{"$f":"IF(B42=\"X\",IF(AN42=\"DA\",IF(AX42>24,LEN(TRIM(V42))-LEN(SUBSTITUTE(V42,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(C42=\"X\",IF(AN42=\"\",\"Afectat sau NU?\",IF(AN42=\"DA\",IF(AK42=\"\",\"Neinformat\",NETWORKDAYS(AK42+AL42,AE42+AF42,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C42=\"X\",IF(AN42=\"DA\",IF(AND(BF42>=5,AK42<>\"\"),LEN(TRIM(V42))-LEN(SUBSTITUTE(V42,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C42=\"X\",IF(AN42=\"DA\",LEN(TRIM(V42))-LEN(SUBSTITUTE(V42,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C42=\"X\",IF(AN42=\"\",\"Afectat sau NU?\",IF(AN42=\"DA\",IF(AI42=\"\",\"Neinformat\",NETWORKDAYS(AI42+AJ42,AE42+AF42,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C42=\"X\",IF(AN42=\"DA\",IF(AND(BI42>=5,AI42<>\"\"),LEN(TRIM(U42))-LEN(SUBSTITUTE(U42,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C42=\"X\",IF(AN42=\"DA\",LEN(TRIM(U42))-LEN(SUBSTITUTE(U42,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C42=\"X\",IF(AN42=\"\",\"Afectat sau NU?\",IF(AN42=\"DA\",((AG42+AH42)-(Z42+AA42))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C42=\"X\",IF(AN42<>\"DA\",\"-\",IF(AND(AN42=\"DA\",BL42<=0),LEN(TRIM(V42))-LEN(SUBSTITUTE(V42,CHAR(44),\"\"))+1+LEN(TRIM(U42))-LEN(SUBSTITUTE(U42,CHAR(44),\"\"))+1,0)),\"\")","v":"-"},{"$f":"IF(C42=\"X\",IF(AN42=\"DA\",LEN(TRIM(V42))-LEN(SUBSTITUTE(V42,CHAR(44),\"\"))+1+LEN(TRIM(U42))-LEN(SUBSTITUTE(U42,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"}]
[28,"-","x","Punere în siguranță traversare aeriană peste canal râu Bistrița cu conducta 12” Piatra Neamț - Bicaz, zona Bicaz",120977,"Bicaz","Neamț",583336.32999999996,601827.11,583336.32999999996,601827.11,"-","-","SM0459D0","Bicaz","-","-","-","-","SM-SD001",null,"Delgaz Grid","aprilie - iunie 2022",null,null,null,null,"Bacău",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI 2021_cap.A_2.1.B.16",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[29,"-","x","Punere în siguranță subtraversare râu Moldovița cu conducta de transport gaze naturale 12” Frasin - Câmpulung Moldovenesc, zona localității Vama",146511,"Câmpulung Moldovenesc","Suceava",541635.5,669718.05000000005,541635.5,669718.05000000005,"-","-","SM1126D0","Câmpulung Moldovenesc","-","-","-","-","SM-SD001",null,"Nova Power&Gas","octombrie - decembrie 2021",null,null,null,null,"Bacău",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI 2021_cap.A_2.1.B.10",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[30,"-","x","Punere în siguranță conductă 20” Medieșu Aurit - Abrămuț, zona Culciu Mare",137559,"Culciu Mare","Satu Mare",355830.22,696040.63,355830.22,696040.63,"-","-","SM1083D0","Culciu","-","-","-","-","SM-SD001",null,"CPL Concordia","iulie - septembrie 2022",null,null,null,null,"Cluj",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI 2021_cap.A_2.1.B.11",null,{"$f":"IF(B45=\"X\",IF(AN45=\"\",\"Afectat sau NU?\",IF(AN45=\"DA\",IF(((AK45+AL45)-(AE45+AF45))*24<-720,\"Neinformat\",((AK45+AL45)-(AE45+AF45))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B45=\"X\",IF(AN45=\"DA\",IF(AR45<6,LEN(TRIM(V45))-LEN(SUBSTITUTE(V45,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B45=\"X\",IF(AN45=\"DA\",LEN(TRIM(V45))-LEN(SUBSTITUTE(V45,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B45=\"X\",IF(AN45=\"\",\"Afectat sau NU?\",IF(AN45=\"DA\",IF(((AI45+AJ45)-(AE45+AF45))*24<-720,\"Neinformat\",((AI45+AJ45)-(AE45+AF45))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B45=\"X\",IF(AN45=\"DA\",IF(AU45<6,LEN(TRIM(U45))-LEN(SUBSTITUTE(U45,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B45=\"X\",IF(AN45=\"DA\",LEN(TRIM(U45))-LEN(SUBSTITUTE(U45,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B45=\"X\",IF(AN45=\"\",\"Afectat sau NU?\",IF(AN45=\"DA\",((AG45+AH45)-(AE45+AF45))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B45=\"X\",IF(AN45=\"DA\",IF(AX45>24,IF(BA45=\"NU\",0,LEN(TRIM(V45))-LEN(SUBSTITUTE(V45,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":""},{"$f":"IF(B45=\"X\",IF(AN45=\"DA\",IF(AX45>24,LEN(TRIM(V45))-LEN(SUBSTITUTE(V45,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(C45=\"X\",IF(AN45=\"\",\"Afectat sau NU?\",IF(AN45=\"DA\",IF(AK45=\"\",\"Neinformat\",NETWORKDAYS(AK45+AL45,AE45+AF45,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C45=\"X\",IF(AN45=\"DA\",IF(AND(BF45>=5,AK45<>\"\"),LEN(TRIM(V45))-LEN(SUBSTITUTE(V45,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C45=\"X\",IF(AN45=\"DA\",LEN(TRIM(V45))-LEN(SUBSTITUTE(V45,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C45=\"X\",IF(AN45=\"\",\"Afectat sau NU?\",IF(AN45=\"DA\",IF(AI45=\"\",\"Neinformat\",NETWORKDAYS(AI45+AJ45,AE45+AF45,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C45=\"X\",IF(AN45=\"DA\",IF(AND(BI45>=5,AI45<>\"\"),LEN(TRIM(U45))-LEN(SUBSTITUTE(U45,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C45=\"X\",IF(AN45=\"DA\",LEN(TRIM(U45))-LEN(SUBSTITUTE(U45,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C45=\"X\",IF(AN45=\"\",\"Afectat sau NU?\",IF(AN45=\"DA\",((AG45+AH45)-(Z45+AA45))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C45=\"X\",IF(AN45<>\"DA\",\"-\",IF(AND(AN45=\"DA\",BL45<=0),LEN(TRIM(V45))-LEN(SUBSTITUTE(V45,CHAR(44),\"\"))+1+LEN(TRIM(U45))-LEN(SUBSTITUTE(U45,CHAR(44),\"\"))+1,0)),\"\")","v":"-"},{"$f":"IF(C45=\"X\",IF(AN45=\"DA\",LEN(TRIM(V45))-LEN(SUBSTITUTE(V45,CHAR(44),\"\"))+1+LEN(TRIM(U45))-LEN(SUBSTITUTE(U45,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"}]
[31,"-","x","Punere în siguranță traversare aeriană peste canal râul Bistrița cu conducta 12” Piatra Neamț - Bicaz, zona Stejaru",122604,"Stejaru","Neamț",589703.30000000005,602610.30000000005,589703.30000000005,602610.30000000005,"-","-","SM0458D0","Stejaru","-","-","-","-","SM-SD001",null,"Delgaz Grid","ianuarie - martie 2022",null,null,null,null,"Bacău",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI 2021_cap.A_2.1.B.28",null,{"$f":"IF(B46=\"X\",IF(AN46=\"\",\"Afectat sau NU?\",IF(AN46=\"DA\",IF(((AK46+AL46)-(AE46+AF46))*24<-720,\"Neinformat\",((AK46+AL46)-(AE46+AF46))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B46=\"X\",IF(AN46=\"DA\",IF(AR46<6,LEN(TRIM(V46))-LEN(SUBSTITUTE(V46,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B46=\"X\",IF(AN46=\"DA\",LEN(TRIM(V46))-LEN(SUBSTITUTE(V46,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B46=\"X\",IF(AN46=\"\",\"Afectat sau NU?\",IF(AN46=\"DA\",IF(((AI46+AJ46)-(AE46+AF46))*24<-720,\"Neinformat\",((AI46+AJ46)-(AE46+AF46))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B46=\"X\",IF(AN46=\"DA\",IF(AU46<6,LEN(TRIM(U46))-LEN(SUBSTITUTE(U46,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B46=\"X\",IF(AN46=\"DA\",LEN(TRIM(U46))-LEN(SUBSTITUTE(U46,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B46=\"X\",IF(AN46=\"\",\"Afectat sau NU?\",IF(AN46=\"DA\",((AG46+AH46)-(AE46+AF46))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B46=\"X\",IF(AN46=\"DA\",IF(AX46>24,IF(BA46=\"NU\",0,LEN(TRIM(V46))-LEN(SUBSTITUTE(V46,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":""},{"$f":"IF(B46=\"X\",IF(AN46=\"DA\",IF(AX46>24,LEN(TRIM(V46))-LEN(SUBSTITUTE(V46,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(C46=\"X\",IF(AN46=\"\",\"Afectat sau NU?\",IF(AN46=\"DA\",IF(AK46=\"\",\"Neinformat\",NETWORKDAYS(AK46+AL46,AE46+AF46,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C46=\"X\",IF(AN46=\"DA\",IF(AND(BF46>=5,AK46<>\"\"),LEN(TRIM(V46))-LEN(SUBSTITUTE(V46,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C46=\"X\",IF(AN46=\"DA\",LEN(TRIM(V46))-LEN(SUBSTITUTE(V46,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C46=\"X\",IF(AN46=\"\",\"Afectat sau NU?\",IF(AN46=\"DA\",IF(AI46=\"\",\"Neinformat\",NETWORKDAYS(AI46+AJ46,AE46+AF46,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C46=\"X\",IF(AN46=\"DA\",IF(AND(BI46>=5,AI46<>\"\"),LEN(TRIM(U46))-LEN(SUBSTITUTE(U46,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C46=\"X\",IF(AN46=\"DA\",LEN(TRIM(U46))-LEN(SUBSTITUTE(U46,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C46=\"X\",IF(AN46=\"\",\"Afectat sau NU?\",IF(AN46=\"DA\",((AG46+AH46)-(Z46+AA46))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C46=\"X\",IF(AN46<>\"DA\",\"-\",IF(AND(AN46=\"DA\",BL46<=0),LEN(TRIM(V46))-LEN(SUBSTITUTE(V46,CHAR(44),\"\"))+1+LEN(TRIM(U46))-LEN(SUBSTITUTE(U46,CHAR(44),\"\"))+1,0)),\"\")","v":"-"},{"$f":"IF(C46=\"X\",IF(AN46=\"DA\",LEN(TRIM(V46))-LEN(SUBSTITUTE(V46,CHAR(44),\"\"))+1+LEN(TRIM(U46))-LEN(SUBSTITUTE(U46,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"}]
[32,"-","x","Punere în siguranță traversare aeriană peste canal râul Bistrița cu conducta 12” Piatra Neamț - Bicaz, zona Stejaru",120977,"Bicaz","Neamț",583336.32999999996,601827.11,583336.32999999996,601827.11,"-","-","SM0459D0","Bicaz","-","-","-","-","SM-SD001",null,"Delgaz Grid","ianuarie - martie 2022",null,null,null,null,"Bacău",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI 2021_cap.A_2.1.B.28",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[33,"-","x","Mărire capacitate SRM Brașov IV, jud. Brașov",40205,"Brașov","Brașov",543022.21,463921.21,543022.21,463921.21,"-","-","SM1135D0","Brașov IV","-","-","-","-","SM-SD001",null,"Distrigaz Sud Rețele","iulie - septembrie 2022",null,null,null,null,"Brașov",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI 2021_cap.C_19",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[34,"-","x","Racord și SRM Turnătorie Silnef Metal Casting, Codlea, Jud. Brașov",40250,"Codlea","Brașov",536853.73,468564.83,536853.73,468564.83,"-","-","SM1191D0","SC Silnef Metal Casting Codlea","-","-","-","-","SM-SD001",null,"Silnef","octombrie - decembrie 2021",null,null,null,null,"Brașov",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI 2021_cap.C_19",null,{"$f":"IF(B49=\"X\",IF(AN49=\"\",\"Afectat sau NU?\",IF(AN49=\"DA\",IF(((AK49+AL49)-(AE49+AF49))*24<-720,\"Neinformat\",((AK49+AL49)-(AE49+AF49))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B49=\"X\",IF(AN49=\"DA\",IF(AR49<6,LEN(TRIM(V49))-LEN(SUBSTITUTE(V49,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B49=\"X\",IF(AN49=\"DA\",LEN(TRIM(V49))-LEN(SUBSTITUTE(V49,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B49=\"X\",IF(AN49=\"\",\"Afectat sau NU?\",IF(AN49=\"DA\",IF(((AI49+AJ49)-(AE49+AF49))*24<-720,\"Neinformat\",((AI49+AJ49)-(AE49+AF49))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B49=\"X\",IF(AN49=\"DA\",IF(AU49<6,LEN(TRIM(U49))-LEN(SUBSTITUTE(U49,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B49=\"X\",IF(AN49=\"DA\",LEN(TRIM(U49))-LEN(SUBSTITUTE(U49,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B49=\"X\",IF(AN49=\"\",\"Afectat sau NU?\",IF(AN49=\"DA\",((AG49+AH49)-(AE49+AF49))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B49=\"X\",IF(AN49=\"DA\",IF(AX49>24,IF(BA49=\"NU\",0,LEN(TRIM(V49))-LEN(SUBSTITUTE(V49,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":""},{"$f":"IF(B49=\"X\",IF(AN49=\"DA\",IF(AX49>24,LEN(TRIM(V49))-LEN(SUBSTITUTE(V49,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(C49=\"X\",IF(AN49=\"\",\"Afectat sau NU?\",IF(AN49=\"DA\",IF(AK49=\"\",\"Neinformat\",NETWORKDAYS(AK49+AL49,AE49+AF49,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C49=\"X\",IF(AN49=\"DA\",IF(AND(BF49>=5,AK49<>\"\"),LEN(TRIM(V49))-LEN(SUBSTITUTE(V49,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C49=\"X\",IF(AN49=\"DA\",LEN(TRIM(V49))-LEN(SUBSTITUTE(V49,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C49=\"X\",IF(AN49=\"\",\"Afectat sau NU?\",IF(AN49=\"DA\",IF(AI49=\"\",\"Neinformat\",NETWORKDAYS(AI49+AJ49,AE49+AF49,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C49=\"X\",IF(AN49=\"DA\",IF(AND(BI49>=5,AI49<>\"\"),LEN(TRIM(U49))-LEN(SUBSTITUTE(U49,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C49=\"X\",IF(AN49=\"DA\",LEN(TRIM(U49))-LEN(SUBSTITUTE(U49,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C49=\"X\",IF(AN49=\"\",\"Afectat sau NU?\",IF(AN49=\"DA\",((AG49+AH49)-(Z49+AA49))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C49=\"X\",IF(AN49<>\"DA\",\"-\",IF(AND(AN49=\"DA\",BL49<=0),LEN(TRIM(V49))-LEN(SUBSTITUTE(V49,CHAR(44),\"\"))+1+LEN(TRIM(U49))-LEN(SUBSTITUTE(U49,CHAR(44),\"\"))+1,0)),\"\")","v":"-"},{"$f":"IF(C49=\"X\",IF(AN49=\"DA\",LEN(TRIM(V49))-LEN(SUBSTITUTE(V49,CHAR(44),\"\"))+1+LEN(TRIM(U49))-LEN(SUBSTITUTE(U49,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"}]
[35,"-","x","Racord și SRM Sagem Cucorani, jud. Botoșani",38143,"Manolești","Botoșani",620967.59,695527.58,620967.59,695527.58,"-","-","SM1192D0","SC Sagem Cucorani","-","-","-","-","SM-SD001",null,"Sagem","ianuarie - martie 2022",null,null,null,null,"Bacău",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI 2021_cap.C_19",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[36,"-","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","iulie - septembrie 2022",null,null,null,null,"Arad",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI 2021_cap.C_19",null,{"$f":"IF(B51=\"X\",IF(AN51=\"\",\"Afectat sau NU?\",IF(AN51=\"DA\",IF(((AK51+AL51)-(AE51+AF51))*24<-720,\"Neinformat\",((AK51+AL51)-(AE51+AF51))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B51=\"X\",IF(AN51=\"DA\",IF(AR51<6,LEN(TRIM(V51))-LEN(SUBSTITUTE(V51,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B51=\"X\",IF(AN51=\"DA\",LEN(TRIM(V51))-LEN(SUBSTITUTE(V51,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B51=\"X\",IF(AN51=\"\",\"Afectat sau NU?\",IF(AN51=\"DA\",IF(((AI51+AJ51)-(AE51+AF51))*24<-720,\"Neinformat\",((AI51+AJ51)-(AE51+AF51))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B51=\"X\",IF(AN51=\"DA\",IF(AU51<6,LEN(TRIM(U51))-LEN(SUBSTITUTE(U51,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B51=\"X\",IF(AN51=\"DA\",LEN(TRIM(U51))-LEN(SUBSTITUTE(U51,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B51=\"X\",IF(AN51=\"\",\"Afectat sau NU?\",IF(AN51=\"DA\",((AG51+AH51)-(AE51+AF51))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B51=\"X\",IF(AN51=\"DA\",IF(AX51>24,IF(BA51=\"NU\",0,LEN(TRIM(V51))-LEN(SUBSTITUTE(V51,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":""},{"$f":"IF(B51=\"X\",IF(AN51=\"DA\",IF(AX51>24,LEN(TRIM(V51))-LEN(SUBSTITUTE(V51,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(C51=\"X\",IF(AN51=\"\",\"Afectat sau NU?\",IF(AN51=\"DA\",IF(AK51=\"\",\"Neinformat\",NETWORKDAYS(AK51+AL51,AE51+AF51,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C51=\"X\",IF(AN51=\"DA\",IF(AND(BF51>=5,AK51<>\"\"),LEN(TRIM(V51))-LEN(SUBSTITUTE(V51,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C51=\"X\",IF(AN51=\"DA\",LEN(TRIM(V51))-LEN(SUBSTITUTE(V51,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C51=\"X\",IF(AN51=\"\",\"Afectat sau NU?\",IF(AN51=\"DA\",IF(AI51=\"\",\"Neinformat\",NETWORKDAYS(AI51+AJ51,AE51+AF51,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C51=\"X\",IF(AN51=\"DA\",IF(AND(BI51>=5,AI51<>\"\"),LEN(TRIM(U51))-LEN(SUBSTITUTE(U51,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C51=\"X\",IF(AN51=\"DA\",LEN(TRIM(U51))-LEN(SUBSTITUTE(U51,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C51=\"X\",IF(AN51=\"\",\"Afectat sau NU?\",IF(AN51=\"DA\",((AG51+AH51)-(Z51+AA51))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C51=\"X\",IF(AN51<>\"DA\",\"-\",IF(AND(AN51=\"DA\",BL51<=0),LEN(TRIM(V51))-LEN(SUBSTITUTE(V51,CHAR(44),\"\"))+1+LEN(TRIM(U51))-LEN(SUBSTITUTE(U51,CHAR(44),\"\"))+1,0)),\"\")","v":"-"},{"$f":"IF(C51=\"X\",IF(AN51=\"DA\",LEN(TRIM(V51))-LEN(SUBSTITUTE(V51,CHAR(44),\"\"))+1+LEN(TRIM(U51))-LEN(SUBSTITUTE(U51,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"}]
[{"$f":"A51+1","v":37},"-","x","SRM Clinceni - Eficientizarea sistemului de măsură prin completarea instalației tehnologice cu elemente/echipamente corespunzătoare",102044,"Clinceni","Ilfov",574454.57999999996,318647.90000000002,574454.57999999996,318647.90000000002,"-","-","SM0249D1","Clinceni","-","-","-","-","SM-SD001",null,"Distrigaz Sud Rețele","octombrie - decembrie 2021",null,null,null,null,"București",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI 2021_1_Anexa 3",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[{"$f":"A52+1","v":38},"-","x","SRM Clinceni - Eficientizarea sistemului de măsură prin completarea instalației tehnologice cu elemente/echipamente corespunzătoare",102222,"Clinceni","Ilfov",574454.57999999996,318647.90000000002,574454.57999999996,318647.90000000002,"-","-","SM0249D2","Cornetu","-","-","-","-","SM-SD001",null,"Premier Energy","octombrie - decembrie 2021",null,null,null,null,"București",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI 2021_1_Anexa 3",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":""},{"$f":"IF(B53=\"X\",IF(AN53=\"DA\",IF(AR53<6,LEN(TRIM(V53))-LEN(SUBSTITUTE(V53,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B53=\"X\",IF(AN53=\"DA\",LEN(TRIM(V53))-LEN(SUBSTITUTE(V53,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$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":""},{"$f":"IF(B53=\"X\",IF(AN53=\"DA\",IF(AU53<6,LEN(TRIM(U53))-LEN(SUBSTITUTE(U53,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B53=\"X\",IF(AN53=\"DA\",LEN(TRIM(U53))-LEN(SUBSTITUTE(U53,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B53=\"X\",IF(AN53=\"\",\"Afectat sau NU?\",IF(AN53=\"DA\",((AG53+AH53)-(AE53+AF53))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$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":""},{"$f":"IF(B53=\"X\",IF(AN53=\"DA\",IF(AX53>24,LEN(TRIM(V53))-LEN(SUBSTITUTE(V53,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},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":"Afectat sau NU?"},{"$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":"Afectat sau NU?"},{"$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":"Afectat sau NU?"},{"$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":"-"}]
[{"$f":"A53+1","v":39},"-","x","SRM Clinceni - Eficientizarea sistemului de măsură prin completarea instalației tehnologice cu elemente/echipamente corespunzătoare",102044,"Clinceni","Ilfov",574454.57999999996,318647.90000000002,574454.57999999996,318647.90000000002,"-","-","SM0249D3","Clinceni Aeroport","-","-","-","-","SM-SD001",null,"Premier Energy","octombrie - decembrie 2021",null,null,null,null,"București",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI 2021_1_Anexa 3",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[40,"-","x","Racord și SRM Lețcani, județul Iași",97688,"Lețcani","Iași",682858.38,636181.85,682858.38,636181.85,"-","-","SM0886D0","Lețcani","-","-","-","-","SM-SD001",null,"Delgaz Grid","octombrie - decembrie 2021",null,null,null,null,"Bacău",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI 2021_cap.C_8",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[41,"-","x","Mărire capacitate SRM Uricani, județul Iași",95284,"Iași","Iași",688243.26,633571.56000000006,688243.26,633571.56000000006,"-","-","SM0480D2","Uricani","-","-","-","-","SM-SD001",null,"Delgaz Grid","octombrie - decembrie 2021",null,null,null,null,"Bacău",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI 2021_cap.C_5",null,{"$f":"IF(B56=\"X\",IF(AN56=\"\",\"Afectat sau NU?\",IF(AN56=\"DA\",IF(((AK56+AL56)-(AE56+AF56))*24<-720,\"Neinformat\",((AK56+AL56)-(AE56+AF56))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B56=\"X\",IF(AN56=\"DA\",IF(AR56<6,LEN(TRIM(V56))-LEN(SUBSTITUTE(V56,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B56=\"X\",IF(AN56=\"DA\",LEN(TRIM(V56))-LEN(SUBSTITUTE(V56,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B56=\"X\",IF(AN56=\"\",\"Afectat sau NU?\",IF(AN56=\"DA\",IF(((AI56+AJ56)-(AE56+AF56))*24<-720,\"Neinformat\",((AI56+AJ56)-(AE56+AF56))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B56=\"X\",IF(AN56=\"DA\",IF(AU56<6,LEN(TRIM(U56))-LEN(SUBSTITUTE(U56,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B56=\"X\",IF(AN56=\"DA\",LEN(TRIM(U56))-LEN(SUBSTITUTE(U56,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B56=\"X\",IF(AN56=\"\",\"Afectat sau NU?\",IF(AN56=\"DA\",((AG56+AH56)-(AE56+AF56))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B56=\"X\",IF(AN56=\"DA\",IF(AX56>24,IF(BA56=\"NU\",0,LEN(TRIM(V56))-LEN(SUBSTITUTE(V56,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":""},{"$f":"IF(B56=\"X\",IF(AN56=\"DA\",IF(AX56>24,LEN(TRIM(V56))-LEN(SUBSTITUTE(V56,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(C56=\"X\",IF(AN56=\"\",\"Afectat sau NU?\",IF(AN56=\"DA\",IF(AK56=\"\",\"Neinformat\",NETWORKDAYS(AK56+AL56,AE56+AF56,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C56=\"X\",IF(AN56=\"DA\",IF(AND(BF56>=5,AK56<>\"\"),LEN(TRIM(V56))-LEN(SUBSTITUTE(V56,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C56=\"X\",IF(AN56=\"DA\",LEN(TRIM(V56))-LEN(SUBSTITUTE(V56,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C56=\"X\",IF(AN56=\"\",\"Afectat sau NU?\",IF(AN56=\"DA\",IF(AI56=\"\",\"Neinformat\",NETWORKDAYS(AI56+AJ56,AE56+AF56,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C56=\"X\",IF(AN56=\"DA\",IF(AND(BI56>=5,AI56<>\"\"),LEN(TRIM(U56))-LEN(SUBSTITUTE(U56,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C56=\"X\",IF(AN56=\"DA\",LEN(TRIM(U56))-LEN(SUBSTITUTE(U56,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C56=\"X\",IF(AN56=\"\",\"Afectat sau NU?\",IF(AN56=\"DA\",((AG56+AH56)-(Z56+AA56))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C56=\"X\",IF(AN56<>\"DA\",\"-\",IF(AND(AN56=\"DA\",BL56<=0),LEN(TRIM(V56))-LEN(SUBSTITUTE(V56,CHAR(44),\"\"))+1+LEN(TRIM(U56))-LEN(SUBSTITUTE(U56,CHAR(44),\"\"))+1,0)),\"\")","v":"-"},{"$f":"IF(C56=\"X\",IF(AN56=\"DA\",LEN(TRIM(V56))-LEN(SUBSTITUTE(V56,CHAR(44),\"\"))+1+LEN(TRIM(U56))-LEN(SUBSTITUTE(U56,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"}]
[42,"-","x","Modernizare NT Schitu Goleşti - montare gară godevil",18689,"Schitu Golești","Argeș",499964.40600000002,409075.77299999999,499964.40600000002,409075.77299999999,"-","-","SM1089D0","Schitu Golești","-","-","-","-","SM-SD001",null,"Distrigaz Sud Rețele","octombrie - decembrie 2021",null,null,null,null,"Craiova",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI 2021_4_Anexa 1",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[43,"-","x","Modernizare NT Schitu Goleşti - montare gară godevil",17254,"Mihăești","Argeș",500598.14502300002,401110.15465600003,500598.14502300002,401110.15465600003,"-","-","SM1243D0","Mihaești AG","-","-","-","-","SM-SD001",null,"Distrigaz Sud Rețele","octombrie - decembrie 2021",null,null,null,null,"Craiova",null,null,null,null,null,null,null,null,null,null,null,null,null,"PMDI 2021_4_Anexa 1",null,"","","","","","","","","",null,null,null,null,null,"Afectat sau NU?","-","-","Afectat sau NU?","-","-","Afectat sau NU?","-","-"]
[44,"-","x","Refacere ocolitor exterior la SRM Vânători",120263,"Vânători","Mureș",494351.98,527481.18000000005,494351.98,527481.18000000005,"-","-","SM0375DO","SRM Vânători","-","-","-","-","SM-SD001",null,"Delgaz Grid","octombrie 2021",null,null,null,null,"Brașov",null,null,null,null,null,null,null,null,null,null,null,null,null,"Forțe proprii",null,{"$f":"IF(B59=\"X\",IF(AN59=\"\",\"Afectat sau NU?\",IF(AN59=\"DA\",IF(((AK59+AL59)-(AE59+AF59))*24<-720,\"Neinformat\",((AK59+AL59)-(AE59+AF59))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B59=\"X\",IF(AN59=\"DA\",IF(AR59<6,LEN(TRIM(V59))-LEN(SUBSTITUTE(V59,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B59=\"X\",IF(AN59=\"DA\",LEN(TRIM(V59))-LEN(SUBSTITUTE(V59,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B59=\"X\",IF(AN59=\"\",\"Afectat sau NU?\",IF(AN59=\"DA\",IF(((AI59+AJ59)-(AE59+AF59))*24<-720,\"Neinformat\",((AI59+AJ59)-(AE59+AF59))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B59=\"X\",IF(AN59=\"DA\",IF(AU59<6,LEN(TRIM(U59))-LEN(SUBSTITUTE(U59,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B59=\"X\",IF(AN59=\"DA\",LEN(TRIM(U59))-LEN(SUBSTITUTE(U59,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B59=\"X\",IF(AN59=\"\",\"Afectat sau NU?\",IF(AN59=\"DA\",((AG59+AH59)-(AE59+AF59))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B59=\"X\",IF(AN59=\"DA\",IF(AX59>24,IF(BA59=\"NU\",0,LEN(TRIM(V59))-LEN(SUBSTITUTE(V59,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":""},{"$f":"IF(B59=\"X\",IF(AN59=\"DA\",IF(AX59>24,LEN(TRIM(V59))-LEN(SUBSTITUTE(V59,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(C59=\"X\",IF(AN59=\"\",\"Afectat sau NU?\",IF(AN59=\"DA\",IF(AK59=\"\",\"Neinformat\",NETWORKDAYS(AK59+AL59,AE59+AF59,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C59=\"X\",IF(AN59=\"DA\",IF(AND(BF59>=5,AK59<>\"\"),LEN(TRIM(V59))-LEN(SUBSTITUTE(V59,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C59=\"X\",IF(AN59=\"DA\",LEN(TRIM(V59))-LEN(SUBSTITUTE(V59,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C59=\"X\",IF(AN59=\"\",\"Afectat sau NU?\",IF(AN59=\"DA\",IF(AI59=\"\",\"Neinformat\",NETWORKDAYS(AI59+AJ59,AE59+AF59,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C59=\"X\",IF(AN59=\"DA\",IF(AND(BI59>=5,AI59<>\"\"),LEN(TRIM(U59))-LEN(SUBSTITUTE(U59,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C59=\"X\",IF(AN59=\"DA\",LEN(TRIM(U59))-LEN(SUBSTITUTE(U59,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C59=\"X\",IF(AN59=\"\",\"Afectat sau NU?\",IF(AN59=\"DA\",((AG59+AH59)-(Z59+AA59))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C59=\"X\",IF(AN59<>\"DA\",\"-\",IF(AND(AN59=\"DA\",BL59<=0),LEN(TRIM(V59))-LEN(SUBSTITUTE(V59,CHAR(44),\"\"))+1+LEN(TRIM(U59))-LEN(SUBSTITUTE(U59,CHAR(44),\"\"))+1,0)),\"\")","v":"-"},{"$f":"IF(C59=\"X\",IF(AN59=\"DA\",LEN(TRIM(V59))-LEN(SUBSTITUTE(V59,CHAR(44),\"\"))+1+LEN(TRIM(U59))-LEN(SUBSTITUTE(U59,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"}]
[45,"-","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 2022",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,{"$f":"IF(B60=\"X\",IF(AN60=\"\",\"Afectat sau NU?\",IF(AN60=\"DA\",IF(((AK60+AL60)-(AE60+AF60))*24<-720,\"Neinformat\",((AK60+AL60)-(AE60+AF60))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B60=\"X\",IF(AN60=\"DA\",IF(AR60<6,LEN(TRIM(V60))-LEN(SUBSTITUTE(V60,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B60=\"X\",IF(AN60=\"DA\",LEN(TRIM(V60))-LEN(SUBSTITUTE(V60,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B60=\"X\",IF(AN60=\"\",\"Afectat sau NU?\",IF(AN60=\"DA\",IF(((AI60+AJ60)-(AE60+AF60))*24<-720,\"Neinformat\",((AI60+AJ60)-(AE60+AF60))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B60=\"X\",IF(AN60=\"DA\",IF(AU60<6,LEN(TRIM(U60))-LEN(SUBSTITUTE(U60,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B60=\"X\",IF(AN60=\"DA\",LEN(TRIM(U60))-LEN(SUBSTITUTE(U60,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B60=\"X\",IF(AN60=\"\",\"Afectat sau NU?\",IF(AN60=\"DA\",((AG60+AH60)-(AE60+AF60))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B60=\"X\",IF(AN60=\"DA\",IF(AX60>24,IF(BA60=\"NU\",0,LEN(TRIM(V60))-LEN(SUBSTITUTE(V60,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":""},{"$f":"IF(B60=\"X\",IF(AN60=\"DA\",IF(AX60>24,LEN(TRIM(V60))-LEN(SUBSTITUTE(V60,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(C60=\"X\",IF(AN60=\"\",\"Afectat sau NU?\",IF(AN60=\"DA\",IF(AK60=\"\",\"Neinformat\",NETWORKDAYS(AK60+AL60,AE60+AF60,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C60=\"X\",IF(AN60=\"DA\",IF(AND(BF60>=5,AK60<>\"\"),LEN(TRIM(V60))-LEN(SUBSTITUTE(V60,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C60=\"X\",IF(AN60=\"DA\",LEN(TRIM(V60))-LEN(SUBSTITUTE(V60,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C60=\"X\",IF(AN60=\"\",\"Afectat sau NU?\",IF(AN60=\"DA\",IF(AI60=\"\",\"Neinformat\",NETWORKDAYS(AI60+AJ60,AE60+AF60,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C60=\"X\",IF(AN60=\"DA\",IF(AND(BI60>=5,AI60<>\"\"),LEN(TRIM(U60))-LEN(SUBSTITUTE(U60,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C60=\"X\",IF(AN60=\"DA\",LEN(TRIM(U60))-LEN(SUBSTITUTE(U60,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C60=\"X\",IF(AN60=\"\",\"Afectat sau NU?\",IF(AN60=\"DA\",((AG60+AH60)-(Z60+AA60))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C60=\"X\",IF(AN60<>\"DA\",\"-\",IF(AND(AN60=\"DA\",BL60<=0),LEN(TRIM(V60))-LEN(SUBSTITUTE(V60,CHAR(44),\"\"))+1+LEN(TRIM(U60))-LEN(SUBSTITUTE(U60,CHAR(44),\"\"))+1,0)),\"\")","v":"-"},{"$f":"IF(C60=\"X\",IF(AN60=\"DA\",LEN(TRIM(V60))-LEN(SUBSTITUTE(V60,CHAR(44),\"\"))+1+LEN(TRIM(U60))-LEN(SUBSTITUTE(U60,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"}]
[46,"-","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,"SC Premier Energy SRL","mai - septembrie 2022",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?","-","-"]
[47,"-","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 2022",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?","-","-"]
[48,"-","x","Modernizare/Sistematizare instalație tehnologică SRM Tunari",105589,"Tunari","Ilfov",590882.06000000006,338200.31,590882.06000000006,338200.31,"-","-","SM0168D0","București Tunari","-","-","-","-","SM-SD001",null," Distrigaz Sud Rețele","mai - septembrie 2022",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?","-","-"]
[49,"-","x","Modernizare/Sistematizare instalație tehnologică SRM Tunari",105589,"Tunari","Ilfov",590882.06000000006,338200.31,590882.06000000006,338200.31,"-","-","SM0168D1","Cartier Pipera","-","-","-","-","SM-SD001",null,"SC Premier Energy SRL","mai - septembrie 2022",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?","-","-"]
[50,"-","x","Montare flanșă electroizolantă pe racord SRM Videle",151914,"Videle ","Teleorman",543275.88,310029.43,543275.88,310029.43,"-","-","SM1111D0","Videle ","-","-","-","-","SM-SD001",null,"SC Premier Energy SRL","mai - septembrie 2022",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?","-","-"]
[51,"-","x","Curățire interioara cu PIG a conductei 12” racord SRM Videle",151914,"Videle ","Teleorman",543275.88,310029.43,543275.88,310029.43,"-","-","SM1111D0","Videle ","-","-","-","-","SM-SD001",null,"SC Premier Energy SRL","mai - septembrie 2022",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?","-","-"]
[52,"-","x","Curățire interioara cu PIG a conductei 12” racord SRM Videle",104234,"Mârșa ","Giurgiu",543811.16,313253.82,543811.16,313253.82,"-","-","SM1165D0","Depozit 160 Videle","-","-","-","-","SM-CF001",null,"PETROM","mai - septembrie 2022",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?","-","-"]
[53,"-","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 2022",null,null,null,null,"București",null,null,null,null,null,null,null,null,null,null,null,null,null,"Forțe proprii/SM",null,{"$f":"IF(B68=\"X\",IF(AN68=\"\",\"Afectat sau NU?\",IF(AN68=\"DA\",IF(((AK68+AL68)-(AE68+AF68))*24<-720,\"Neinformat\",((AK68+AL68)-(AE68+AF68))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B68=\"X\",IF(AN68=\"DA\",IF(AR68<6,LEN(TRIM(V68))-LEN(SUBSTITUTE(V68,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B68=\"X\",IF(AN68=\"DA\",LEN(TRIM(V68))-LEN(SUBSTITUTE(V68,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B68=\"X\",IF(AN68=\"\",\"Afectat sau NU?\",IF(AN68=\"DA\",IF(((AI68+AJ68)-(AE68+AF68))*24<-720,\"Neinformat\",((AI68+AJ68)-(AE68+AF68))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B68=\"X\",IF(AN68=\"DA\",IF(AU68<6,LEN(TRIM(U68))-LEN(SUBSTITUTE(U68,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B68=\"X\",IF(AN68=\"DA\",LEN(TRIM(U68))-LEN(SUBSTITUTE(U68,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B68=\"X\",IF(AN68=\"\",\"Afectat sau NU?\",IF(AN68=\"DA\",((AG68+AH68)-(AE68+AF68))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B68=\"X\",IF(AN68=\"DA\",IF(AX68>24,IF(BA68=\"NU\",0,LEN(TRIM(V68))-LEN(SUBSTITUTE(V68,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":""},{"$f":"IF(B68=\"X\",IF(AN68=\"DA\",IF(AX68>24,LEN(TRIM(V68))-LEN(SUBSTITUTE(V68,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(C68=\"X\",IF(AN68=\"\",\"Afectat sau NU?\",IF(AN68=\"DA\",IF(AK68=\"\",\"Neinformat\",NETWORKDAYS(AK68+AL68,AE68+AF68,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C68=\"X\",IF(AN68=\"DA\",IF(AND(BF68>=5,AK68<>\"\"),LEN(TRIM(V68))-LEN(SUBSTITUTE(V68,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C68=\"X\",IF(AN68=\"DA\",LEN(TRIM(V68))-LEN(SUBSTITUTE(V68,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C68=\"X\",IF(AN68=\"\",\"Afectat sau NU?\",IF(AN68=\"DA\",IF(AI68=\"\",\"Neinformat\",NETWORKDAYS(AI68+AJ68,AE68+AF68,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C68=\"X\",IF(AN68=\"DA\",IF(AND(BI68>=5,AI68<>\"\"),LEN(TRIM(U68))-LEN(SUBSTITUTE(U68,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C68=\"X\",IF(AN68=\"DA\",LEN(TRIM(U68))-LEN(SUBSTITUTE(U68,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C68=\"X\",IF(AN68=\"\",\"Afectat sau NU?\",IF(AN68=\"DA\",((AG68+AH68)-(Z68+AA68))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C68=\"X\",IF(AN68<>\"DA\",\"-\",IF(AND(AN68=\"DA\",BL68<=0),LEN(TRIM(V68))-LEN(SUBSTITUTE(V68,CHAR(44),\"\"))+1+LEN(TRIM(U68))-LEN(SUBSTITUTE(U68,CHAR(44),\"\"))+1,0)),\"\")","v":"-"},{"$f":"IF(C68=\"X\",IF(AN68=\"DA\",LEN(TRIM(V68))-LEN(SUBSTITUTE(V68,CHAR(44),\"\"))+1+LEN(TRIM(U68))-LEN(SUBSTITUTE(U68,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"}]
[54,"-","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,"SC Premier Energy SRL","mai - septembrie 2022",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?","-","-"]
[55,"-","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 2022",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?","-","-"]
[56,"-","x","Înlocuit robinet R4 Inel București, zona Chiajna",179258,"Chiajna","Ilfov",576624.93999999994,327167.40999999997,576624.93999999994,327167.40999999997,"-","-","SM0170D0","SC Complex Carrefour Chiajna","-","-","-","-","SM-SD001",null,"Distrigaz Sud Rețele","mai - septembrie 2022",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?","-","-"]
[57,"-","x","Înlocuit robinet R4 Inel București, zona Chiajna",179258,"Chiajna","Ilfov",576726.56999999995,326494.11,576726.56999999995,326494.11,"-","-","SM0154D0","SC Linde Gaz București","-","-","-","-","SM-SD001",null,"Distrigaz Sud Rețele","mai - septembrie 2022",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?","-","-"]
[58,"-","x","Adapare panou măsură si eliminare instalație odorizare veche SRM Măgureni",134069,"Măgureni","Prahova",558807.9,394540.02,558807.9,394540.02,"-","-","SM0506D0","Măgureni","-","-","-","-","SM-SD001",null,"MMDATA","mai - septembrie 2022",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?","-","-"]
[59,"-","x","Înlocuire robinet R33 pe conducta 28” Stâlp89 - Filipești, zona Talea",131121,"Breaza de Sus ","Prahova",551059.15,410660.89,551059.15,410660.89,"-","-","SM0085D1","Breaza PH","-","-","-","-","SM-SD001",null,"Distrigaz Sud Rețele","mai - septembrie 2022",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?","-","-"]
[60,"-","x","Înlocuire robinet R33 pe conducta 28” Stâlp89 - Filipești, zona Talea",131121,"Breaza de Sus ","Prahova",551059.15,410660.89,551059.15,410660.89,"-","-","SM0085D2","SC Parc Industrial Breaza","-","-","-","-","SM-CF001",null,"SC Parc Industrial Breaza SRL","mai - septembrie 2022",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?","-","-"]
[61,"-","x","Înlocuire robinet R98 pe conducta 28” Stâlp89 - Filipești, zona Provița",134862,"Provița de Jos","Prahova",552168.05000000005,402387.58,552168.05000000005,402387.58,"-","-","SM0096D0","Provița de Jos","-","-","-","-","SM-SD001",null,"Distrigaz Sud Rețele","mai - septembrie 2022",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,{"$f":"IF(B76=\"X\",IF(AN76=\"\",\"Afectat sau NU?\",IF(AN76=\"DA\",IF(((AK76+AL76)-(AE76+AF76))*24<-720,\"Neinformat\",((AK76+AL76)-(AE76+AF76))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B76=\"X\",IF(AN76=\"DA\",IF(AR76<6,LEN(TRIM(V76))-LEN(SUBSTITUTE(V76,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B76=\"X\",IF(AN76=\"DA\",LEN(TRIM(V76))-LEN(SUBSTITUTE(V76,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B76=\"X\",IF(AN76=\"\",\"Afectat sau NU?\",IF(AN76=\"DA\",IF(((AI76+AJ76)-(AE76+AF76))*24<-720,\"Neinformat\",((AI76+AJ76)-(AE76+AF76))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B76=\"X\",IF(AN76=\"DA\",IF(AU76<6,LEN(TRIM(U76))-LEN(SUBSTITUTE(U76,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B76=\"X\",IF(AN76=\"DA\",LEN(TRIM(U76))-LEN(SUBSTITUTE(U76,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B76=\"X\",IF(AN76=\"\",\"Afectat sau NU?\",IF(AN76=\"DA\",((AG76+AH76)-(AE76+AF76))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B76=\"X\",IF(AN76=\"DA\",IF(AX76>24,IF(BA76=\"NU\",0,LEN(TRIM(V76))-LEN(SUBSTITUTE(V76,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":""},{"$f":"IF(B76=\"X\",IF(AN76=\"DA\",IF(AX76>24,LEN(TRIM(V76))-LEN(SUBSTITUTE(V76,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(C76=\"X\",IF(AN76=\"\",\"Afectat sau NU?\",IF(AN76=\"DA\",IF(AK76=\"\",\"Neinformat\",NETWORKDAYS(AK76+AL76,AE76+AF76,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C76=\"X\",IF(AN76=\"DA\",IF(AND(BF76>=5,AK76<>\"\"),LEN(TRIM(V76))-LEN(SUBSTITUTE(V76,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C76=\"X\",IF(AN76=\"DA\",LEN(TRIM(V76))-LEN(SUBSTITUTE(V76,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C76=\"X\",IF(AN76=\"\",\"Afectat sau NU?\",IF(AN76=\"DA\",IF(AI76=\"\",\"Neinformat\",NETWORKDAYS(AI76+AJ76,AE76+AF76,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C76=\"X\",IF(AN76=\"DA\",IF(AND(BI76>=5,AI76<>\"\"),LEN(TRIM(U76))-LEN(SUBSTITUTE(U76,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":"-"},{"$f":"IF(C76=\"X\",IF(AN76=\"DA\",LEN(TRIM(U76))-LEN(SUBSTITUTE(U76,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"},{"$f":"IF(C76=\"X\",IF(AN76=\"\",\"Afectat sau NU?\",IF(AN76=\"DA\",((AG76+AH76)-(Z76+AA76))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":"Afectat sau NU?"},{"$f":"IF(C76=\"X\",IF(AN76<>\"DA\",\"-\",IF(AND(AN76=\"DA\",BL76<=0),LEN(TRIM(V76))-LEN(SUBSTITUTE(V76,CHAR(44),\"\"))+1+LEN(TRIM(U76))-LEN(SUBSTITUTE(U76,CHAR(44),\"\"))+1,0)),\"\")","v":"-"},{"$f":"IF(C76=\"X\",IF(AN76=\"DA\",LEN(TRIM(V76))-LEN(SUBSTITUTE(V76,CHAR(44),\"\"))+1+LEN(TRIM(U76))-LEN(SUBSTITUTE(U76,CHAR(44),\"\"))+1,\"-\"),\"\")","v":"-"}]
[62,"-","x","Mentenanță si reabilitare SRM Răzvad ",65440,"Târgoviște ","Dâmbovița",542880.01,380147.11,542880.01,380147.11,"-","-","SM0105D0","Răzvad ","-","-","-","-","SM-SD001",null,"Distrigaz Sud Rețele","mai - septembrie 2022",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?","-","-"]
[63,"-","x","Adaptare sistem de măsură SRM Comarnic",131345,"Comarnic","Prahova",549781.52,415513.83,549781.52,415513.83,"-","-","SM0084D1","Comarnic","-","-","-","-","SM-SD001",null,"Distrigaz Sud Rețele","mai - septembrie 2022",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?","-","-"]
[64,"-","x","Adaptare sistem de măsură SRM Comarnic",131345,"Comarnic","Prahova",549781.52,415513.83,549781.52,415513.83,"-","-","SM0084D2","SC Vulturul Comarnic","-","-","-","-","SM-CF001",null,"SC Vulturul SA","mai - septembrie 2022",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?","-","-"]
[65,"-","x","Înlocuire robinet R15 în SRM Posada și 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 2022",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?","-","-"]
[66,"-","x","Modernizare alimentare cu gaze Municipiul Ploiești ",130543,"Ploiești ","Prahova",581446.93000000005,385348.31,581446.93000000005,385348.31,"-","-","SM0130D1","SC Vega Ploiești","-","-","-","-","SM-CF001",null,"Rompetrol Vega Ploiești","mai - septembrie 2022",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?","-","-"]
[67,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","",null,null,null,null,null,"","","","","","","","",""]
[68,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","",null,null,null,null,null,"","","","","","","","",""]
[69,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","",null,null,null,null,null,"","","","","","","","",""]
[70,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","",null,null,null,null,null,"","","","","","","","",""]
[{"$f":"A85+1","v":71},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","",null,null,null,null,null,"","","","","","","","",""]
[72,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","",null,null,null,null,null,"","","","","","","","",""]
[73,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B88=\"X\",IF(AN88=\"\",\"Afectat sau NU?\",IF(AN88=\"DA\",IF(((AK88+AL88)-(AE88+AF88))*24<-720,\"Neinformat\",((AK88+AL88)-(AE88+AF88))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B88=\"X\",IF(AN88=\"DA\",IF(AR88<6,LEN(TRIM(V88))-LEN(SUBSTITUTE(V88,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B88=\"X\",IF(AN88=\"DA\",LEN(TRIM(V88))-LEN(SUBSTITUTE(V88,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B88=\"X\",IF(AN88=\"\",\"Afectat sau NU?\",IF(AN88=\"DA\",IF(((AI88+AJ88)-(AE88+AF88))*24<-720,\"Neinformat\",((AI88+AJ88)-(AE88+AF88))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B88=\"X\",IF(AN88=\"DA\",IF(AU88<6,LEN(TRIM(U88))-LEN(SUBSTITUTE(U88,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B88=\"X\",IF(AN88=\"DA\",LEN(TRIM(U88))-LEN(SUBSTITUTE(U88,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B88=\"X\",IF(AN88=\"\",\"Afectat sau NU?\",IF(AN88=\"DA\",((AG88+AH88)-(AE88+AF88))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B88=\"X\",IF(AN88=\"DA\",IF(AX88>24,IF(BA88=\"NU\",0,LEN(TRIM(V88))-LEN(SUBSTITUTE(V88,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":""},{"$f":"IF(B88=\"X\",IF(AN88=\"DA\",IF(AX88>24,LEN(TRIM(V88))-LEN(SUBSTITUTE(V88,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(C88=\"X\",IF(AN88=\"\",\"Afectat sau NU?\",IF(AN88=\"DA\",IF(AK88=\"\",\"Neinformat\",NETWORKDAYS(AK88+AL88,AE88+AF88,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C88=\"X\",IF(AN88=\"DA\",IF(AND(BF88>=5,AK88<>\"\"),LEN(TRIM(V88))-LEN(SUBSTITUTE(V88,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C88=\"X\",IF(AN88=\"DA\",LEN(TRIM(V88))-LEN(SUBSTITUTE(V88,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C88=\"X\",IF(AN88=\"\",\"Afectat sau NU?\",IF(AN88=\"DA\",IF(AI88=\"\",\"Neinformat\",NETWORKDAYS(AI88+AJ88,AE88+AF88,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C88=\"X\",IF(AN88=\"DA\",IF(AND(BI88>=5,AI88<>\"\"),LEN(TRIM(U88))-LEN(SUBSTITUTE(U88,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C88=\"X\",IF(AN88=\"DA\",LEN(TRIM(U88))-LEN(SUBSTITUTE(U88,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C88=\"X\",IF(AN88=\"\",\"Afectat sau NU?\",IF(AN88=\"DA\",((AG88+AH88)-(Z88+AA88))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C88=\"X\",IF(AN88<>\"DA\",\"-\",IF(AND(AN88=\"DA\",BL88<=0),LEN(TRIM(V88))-LEN(SUBSTITUTE(V88,CHAR(44),\"\"))+1+LEN(TRIM(U88))-LEN(SUBSTITUTE(U88,CHAR(44),\"\"))+1,0)),\"\")","v":""},{"$f":"IF(C88=\"X\",IF(AN88=\"DA\",LEN(TRIM(V88))-LEN(SUBSTITUTE(V88,CHAR(44),\"\"))+1+LEN(TRIM(U88))-LEN(SUBSTITUTE(U88,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""}]
[74,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","",null,null,null,null,null,"","","","","","","","",""]
[75,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","",null,null,null,null,null,"","","","","","","","",""]
[76,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","",null,null,null,null,null,"","","","","","","","",""]
[77,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","",null,null,null,null,null,"","","","","","","","",""]
[78,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B93=\"X\",IF(AN93=\"\",\"Afectat sau NU?\",IF(AN93=\"DA\",IF(((AK93+AL93)-(AE93+AF93))*24<-720,\"Neinformat\",((AK93+AL93)-(AE93+AF93))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B93=\"X\",IF(AN93=\"DA\",IF(AR93<6,LEN(TRIM(V93))-LEN(SUBSTITUTE(V93,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B93=\"X\",IF(AN93=\"DA\",LEN(TRIM(V93))-LEN(SUBSTITUTE(V93,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B93=\"X\",IF(AN93=\"\",\"Afectat sau NU?\",IF(AN93=\"DA\",IF(((AI93+AJ93)-(AE93+AF93))*24<-720,\"Neinformat\",((AI93+AJ93)-(AE93+AF93))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B93=\"X\",IF(AN93=\"DA\",IF(AU93<6,LEN(TRIM(U93))-LEN(SUBSTITUTE(U93,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B93=\"X\",IF(AN93=\"DA\",LEN(TRIM(U93))-LEN(SUBSTITUTE(U93,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B93=\"X\",IF(AN93=\"\",\"Afectat sau NU?\",IF(AN93=\"DA\",((AG93+AH93)-(AE93+AF93))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B93=\"X\",IF(AN93=\"DA\",IF(AX93>24,IF(BA93=\"NU\",0,LEN(TRIM(V93))-LEN(SUBSTITUTE(V93,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":""},{"$f":"IF(B93=\"X\",IF(AN93=\"DA\",IF(AX93>24,LEN(TRIM(V93))-LEN(SUBSTITUTE(V93,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(C93=\"X\",IF(AN93=\"\",\"Afectat sau NU?\",IF(AN93=\"DA\",IF(AK93=\"\",\"Neinformat\",NETWORKDAYS(AK93+AL93,AE93+AF93,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C93=\"X\",IF(AN93=\"DA\",IF(AND(BF93>=5,AK93<>\"\"),LEN(TRIM(V93))-LEN(SUBSTITUTE(V93,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C93=\"X\",IF(AN93=\"DA\",LEN(TRIM(V93))-LEN(SUBSTITUTE(V93,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C93=\"X\",IF(AN93=\"\",\"Afectat sau NU?\",IF(AN93=\"DA\",IF(AI93=\"\",\"Neinformat\",NETWORKDAYS(AI93+AJ93,AE93+AF93,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C93=\"X\",IF(AN93=\"DA\",IF(AND(BI93>=5,AI93<>\"\"),LEN(TRIM(U93))-LEN(SUBSTITUTE(U93,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C93=\"X\",IF(AN93=\"DA\",LEN(TRIM(U93))-LEN(SUBSTITUTE(U93,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C93=\"X\",IF(AN93=\"\",\"Afectat sau NU?\",IF(AN93=\"DA\",((AG93+AH93)-(Z93+AA93))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C93=\"X\",IF(AN93<>\"DA\",\"-\",IF(AND(AN93=\"DA\",BL93<=0),LEN(TRIM(V93))-LEN(SUBSTITUTE(V93,CHAR(44),\"\"))+1+LEN(TRIM(U93))-LEN(SUBSTITUTE(U93,CHAR(44),\"\"))+1,0)),\"\")","v":""},{"$f":"IF(C93=\"X\",IF(AN93=\"DA\",LEN(TRIM(V93))-LEN(SUBSTITUTE(V93,CHAR(44),\"\"))+1+LEN(TRIM(U93))-LEN(SUBSTITUTE(U93,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""}]
[79,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"","","","","","","","","",null,null,null,null,null,"","","","","","","","",""]
[80,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B95=\"X\",IF(AN95=\"\",\"Afectat sau NU?\",IF(AN95=\"DA\",IF(((AK95+AL95)-(AE95+AF95))*24<-720,\"Neinformat\",((AK95+AL95)-(AE95+AF95))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B95=\"X\",IF(AN95=\"DA\",IF(AR95<6,LEN(TRIM(V95))-LEN(SUBSTITUTE(V95,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B95=\"X\",IF(AN95=\"DA\",LEN(TRIM(V95))-LEN(SUBSTITUTE(V95,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B95=\"X\",IF(AN95=\"\",\"Afectat sau NU?\",IF(AN95=\"DA\",IF(((AI95+AJ95)-(AE95+AF95))*24<-720,\"Neinformat\",((AI95+AJ95)-(AE95+AF95))*24),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B95=\"X\",IF(AN95=\"DA\",IF(AU95<6,LEN(TRIM(U95))-LEN(SUBSTITUTE(U95,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B95=\"X\",IF(AN95=\"DA\",LEN(TRIM(U95))-LEN(SUBSTITUTE(U95,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B95=\"X\",IF(AN95=\"\",\"Afectat sau NU?\",IF(AN95=\"DA\",((AG95+AH95)-(AE95+AF95))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(B95=\"X\",IF(AN95=\"DA\",IF(AX95>24,IF(BA95=\"NU\",0,LEN(TRIM(V95))-LEN(SUBSTITUTE(V95,CHAR(44),\"\"))+1),0),\"-\"),\"\")","v":""},{"$f":"IF(B95=\"X\",IF(AN95=\"DA\",IF(AX95>24,LEN(TRIM(V95))-LEN(SUBSTITUTE(V95,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(C95=\"X\",IF(AN95=\"\",\"Afectat sau NU?\",IF(AN95=\"DA\",IF(AK95=\"\",\"Neinformat\",NETWORKDAYS(AK95+AL95,AE95+AF95,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C95=\"X\",IF(AN95=\"DA\",IF(AND(BF95>=5,AK95<>\"\"),LEN(TRIM(V95))-LEN(SUBSTITUTE(V95,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C95=\"X\",IF(AN95=\"DA\",LEN(TRIM(V95))-LEN(SUBSTITUTE(V95,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C95=\"X\",IF(AN95=\"\",\"Afectat sau NU?\",IF(AN95=\"DA\",IF(AI95=\"\",\"Neinformat\",NETWORKDAYS(AI95+AJ95,AE95+AF95,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C95=\"X\",IF(AN95=\"DA\",IF(AND(BI95>=5,AI95<>\"\"),LEN(TRIM(U95))-LEN(SUBSTITUTE(U95,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C95=\"X\",IF(AN95=\"DA\",LEN(TRIM(U95))-LEN(SUBSTITUTE(U95,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C95=\"X\",IF(AN95=\"\",\"Afectat sau NU?\",IF(AN95=\"DA\",((AG95+AH95)-(Z95+AA95))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C95=\"X\",IF(AN95<>\"DA\",\"-\",IF(AND(AN95=\"DA\",BL95<=0),LEN(TRIM(V95))-LEN(SUBSTITUTE(V95,CHAR(44),\"\"))+1+LEN(TRIM(U95))-LEN(SUBSTITUTE(U95,CHAR(44),\"\"))+1,0)),\"\")","v":""},{"$f":"IF(C95=\"X\",IF(AN95=\"DA\",LEN(TRIM(V95))-LEN(SUBSTITUTE(V95,CHAR(44),\"\"))+1+LEN(TRIM(U95))-LEN(SUBSTITUTE(U95,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""}]
[81,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"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":""},{"$f":"IF(B96=\"X\",IF(AN96=\"DA\",IF(AR96<6,LEN(TRIM(V96))-LEN(SUBSTITUTE(V96,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B96=\"X\",IF(AN96=\"DA\",LEN(TRIM(V96))-LEN(SUBSTITUTE(V96,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$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":""},{"$f":"IF(B96=\"X\",IF(AN96=\"DA\",IF(AU96<6,LEN(TRIM(U96))-LEN(SUBSTITUTE(U96,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B96=\"X\",IF(AN96=\"DA\",LEN(TRIM(U96))-LEN(SUBSTITUTE(U96,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B96=\"X\",IF(AN96=\"\",\"Afectat sau NU?\",IF(AN96=\"DA\",((AG96+AH96)-(AE96+AF96))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$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":""},{"$f":"IF(B96=\"X\",IF(AN96=\"DA\",IF(AX96>24,LEN(TRIM(V96))-LEN(SUBSTITUTE(V96,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"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":""},{"$f":"IF(B97=\"X\",IF(AN97=\"DA\",IF(AR97<6,LEN(TRIM(V97))-LEN(SUBSTITUTE(V97,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B97=\"X\",IF(AN97=\"DA\",LEN(TRIM(V97))-LEN(SUBSTITUTE(V97,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$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":""},{"$f":"IF(B97=\"X\",IF(AN97=\"DA\",IF(AU97<6,LEN(TRIM(U97))-LEN(SUBSTITUTE(U97,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(B97=\"X\",IF(AN97=\"DA\",LEN(TRIM(U97))-LEN(SUBSTITUTE(U97,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(B97=\"X\",IF(AN97=\"\",\"Afectat sau NU?\",IF(AN97=\"DA\",((AG97+AH97)-(AE97+AF97))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$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":""},{"$f":"IF(B97=\"X\",IF(AN97=\"DA\",IF(AX97>24,LEN(TRIM(V97))-LEN(SUBSTITUTE(V97,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},null,null,null,null,null,{"$f":"IF(C97=\"X\",IF(AN97=\"\",\"Afectat sau NU?\",IF(AN97=\"DA\",IF(AK97=\"\",\"Neinformat\",NETWORKDAYS(AK97+AL97,AE97+AF97,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C97=\"X\",IF(AN97=\"DA\",IF(AND(BF97>=5,AK97<>\"\"),LEN(TRIM(V97))-LEN(SUBSTITUTE(V97,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C97=\"X\",IF(AN97=\"DA\",LEN(TRIM(V97))-LEN(SUBSTITUTE(V97,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C97=\"X\",IF(AN97=\"\",\"Afectat sau NU?\",IF(AN97=\"DA\",IF(AI97=\"\",\"Neinformat\",NETWORKDAYS(AI97+AJ97,AE97+AF97,$BS$2:$BS$14)-2),\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C97=\"X\",IF(AN97=\"DA\",IF(AND(BI97>=5,AI97<>\"\"),LEN(TRIM(U97))-LEN(SUBSTITUTE(U97,CHAR(44),\"\"))+1,0),\"-\"),\"\")","v":""},{"$f":"IF(C97=\"X\",IF(AN97=\"DA\",LEN(TRIM(U97))-LEN(SUBSTITUTE(U97,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""},{"$f":"IF(C97=\"X\",IF(AN97=\"\",\"Afectat sau NU?\",IF(AN97=\"DA\",((AG97+AH97)-(Z97+AA97))*24,\"Nu a fost afectat producator/consumator\")),\"\")","v":""},{"$f":"IF(C97=\"X\",IF(AN97<>\"DA\",\"-\",IF(AND(AN97=\"DA\",BL97<=0),LEN(TRIM(V97))-LEN(SUBSTITUTE(V97,CHAR(44),\"\"))+1+LEN(TRIM(U97))-LEN(SUBSTITUTE(U97,CHAR(44),\"\"))+1,0)),\"\")","v":""},{"$f":"IF(C97=\"X\",IF(AN97=\"DA\",LEN(TRIM(V97))-LEN(SUBSTITUTE(V97,CHAR(44),\"\"))+1+LEN(TRIM(U97))-LEN(SUBSTITUTE(U97,CHAR(44),\"\"))+1,\"-\"),\"\")","v":""}]