Bugetul Secretariatului General al Guvernului / Bugetul rectificat centralizat SGG 2017 - pe ordonatori

ordonatori L1 SECRETARIATUL GENERAL AL GUVERNULUI L3 Institutiile din subordinea SGG finantate de la bugetul de stat prin bugetul SGG la momentul rectificarii prin OUG 63/13.09.2017 L5 Nr. crt. Denumirea institutiei Cod fiscal mnemonica L7 1 Secretariatul General al Guvernului - activitate proprie 4283422 SGG L8 2 Institutul Naţional de Statistică 7593088 INS L9 3 Agenţia Naţională pentru Resurse Minerale 4192790 ANRM L10 4 Agenţia Naţională pentru Romi 16998986 ANR L11 5 Oficiul National pentru Jocuri de Noroc 31717537 ONJN L12 6 Comisia Naţională pentru Controlul Activităţilor Nucleare 10792013 CNCAN L13 7 Departamentul pentru Lupta Antifraudă 28484059 DLAF L14 8 Institutul de Investigare a Crimelor Comunismului şi Memoria Exilului Românesc 26282150 IICCMER L15 9 Secretariatul de Stat pentru Culte 26429279 SSC L16 10 Administratia Rezervatiei Biosferei Delta Dunarii 3722040 ARBDD buget L1 SECRETARIATUL GENERAL AL GUVERNULUI L2 Buget 2017 - Repartizarea pe ordonatori a bugetului rectificat prin OUG nr.63/2017 L6 Titular: 13 mii lei L7 Cod Capitol Subcapitol Paragraf Grupa/ titlu Articol Alineat Cod Denumire indicator BUGET rectificat OUG 63/2017 din care: Cod L8 SGG INS DLAF ANR ANRM CNCAN ICCMER SSC ONJN ARBDD L9 000108 FONDURI EXTERNE NERAMBURSABILE - VENITURI =J10+J13+J16 =K10+K13+K16 =L10+L13+L16 =M10+M13+M16 =N10+N13+N16 =O10+O13+O16 =P10+P13+P16 =Q10+Q13+Q16 =R10+R13+R16 =S10+S13+S16 =T10+T13+T16 000108 L10 4008 Operatiuni financiare =J11 =K11 =L11 =M11 =N11 =O11 =P11 =Q11 =R11 =S11 =T11 4008 L11 400815 Sume utilizate din excedentul anului precedent =J12 =K12 =L12 =M12 =N12 =O12 =P12 =Q12 =R12 =S12 =T12 400815 L12 40081503 Sume utilizate de alte institutii din excedentul anului precedent 289 0 0 0 0 17 272 0 0 0 0 40081503 L13 4208 Subventii de la bugetul de stat =J14+J15 =K14+K15 =L14+L15 =M14+M15 =N14+N15 =O14+O15 =P14+P15 =Q14+Q15 =R14+R15 =S14+S15 =T14+T15 4208 L14 420860 Cofinanţare publică acordată în cadrul mecanismului SEE 47 0 0 0 0 11 0 0 0 0 36 420860 L15 420861 Cofinantare publica acordata in cadrul mecanismului norvegian 56 0 0 0 0 0 56 0 0 0 0 420861 L16 4508 Sume primite de la UE/alti donatori in contul platilor efectuate si prefinantari =J17+J19 =K17+K19 =L17+L19 =M17+M19 =N17+N19 =O17+O19 =P17+P19 =Q17+Q19 =R17+R19 =S17+S19 =T17+T19 4508 L17 450817 Mecanismul financiar SEE =J18 =K18 =L18 =M18 =N18 =O18 =P18 =Q18 =R18 =S18 =T18 450817 L18 45081703 Prefinantare 247 0 0 0 0 46 0 0 0 0 201 45081703 L19 450818 Mecanismul financiar norvegian =J20 =K20 =L20 =M20 =N20 =O20 =P20 =Q20 =R20 =S20 =T20 450818 L20 45081803 Prefinantare 46 0 0 0 0 0 46 0 0 0 0 45081803 L21 000110 VENITURI PROPRII - TOTAL VENITURI =J22 =K22 =L22 =M22 =N22 =O22 =P22 =Q22 =R22 =S22 =T22 000110 L22 000210 I. VENITURI CURENTE =J23 =K23 =L23 =M23 =N23 =O23 =P23 =Q23 =R23 =S23 =T23 000210 L23 290010 C. VENITURI NEFISCALE =J24 =K24 =L24 =M24 =N24 =O24 =P24 =Q24 =R24 =S24 =T24 290010 L24 300010 C1. VENITURI DIN PROPRIETATE =J25+J27 =K25+K27 =L25+L27 =M25+M27 =N25+N27 =O25+O27 =P25+P27 =Q25+Q27 =R25+R27 =S25+S27 =T25+T27 300010 L25 3410 Venituri din taxe administrative, eliberari permise =J26 =K26 =L26 =M26 =N26 =O26 =P26 =Q26 =R26 =S26 =T26 3410 L26 341050 Alte venituri din taxe administrative, eliberari permise 1900 0 0 0 0 0 0 0 0 0 1900 341050 L27 3610 Diverse venituri =J28 =K28 =L28 =M28 =N28 =O28 =P28 =Q28 =R28 =S28 =T28 3610 L28 361050 Alte venituri 0 0 0 0 0 0 0 0 0 0 0 361050 L30 5000 5000 TOTAL BUGET - CHELTUIELI =J31+J41+J43 =K31+K41+K43 =L31+L41+L43 =M31+M41+M43 =N31+N41+N43 =O31+O41+O43 =P31+P41+P43 =Q31+Q41+Q43 =R31+R41+R43 =S31+S41+S43 =T31+T41+T43 5000 L31 01 01 CHELTUIELI CURENTE =SUM(J32:J40) =SUM(K32:K40) =SUM(L32:L40) =SUM(M32:M40) =SUM(N32:N40) =SUM(O32:O40) =SUM(P32:P40) =SUM(Q32:Q40) =SUM(R32:R40) =SUM(S32:S40) =SUM(T32:T40) 01 L32 10 10 TITLUL I CHELTUIELI DE PERSONAL =J47+J904+J994 =K47+K904+K994 =L47+L904+L994 =M47+M904+M994 =N47+N904+N994 =O47+O904+O994 =P47+P904+P994 =Q47+Q904+Q994 =R47+R904+R994 =S47+S904+S994 =T47+T904+T994 10 L33 20 20 TITLUL II BUNURI ŞI SERVICII =J48+J905+J995 =K48+K905+K995 =L48+L905+L995 =M48+M905+M995 =N48+N905+N995 =O48+O905+O995 =P48+P905+P995 =Q48+Q905+Q995 =R48+R905+R995 =S48+S905+S995 =T48+T905+T995 20 L34 30 30 TITLUL III DOBANZI =J49 =K49 =L49 =M49 =N49 =O49 =P49 =Q49 =R49 =S49 =T49 30 L35 51 51 TITLUL VI TRANSFERURI INTRE UNITATI ALE ADM PUBL =J50 =K50 =L50 =M50 =N50 =O50 =P50 =Q50 =R50 =S50 =T50 51 L36 55 55 TITLUL VII ALTE TRANSFERURI =J51+J906+J996 =K51+K906+K996 =L51+L906+L996 =M51+M906+M996 =N51+N906+N996 =O51+O906+O996 =P51+P906+P996 =Q51+Q906+Q996 =R51+R906+R996 =S51+S906+S996 =T51+T906+T996 55 L37 56 56 TITLUL VIII PROIECTE CU FINANTARE DIN FONDURI EXTERNE NERAMBURSABILE (FEN) POSTADERARE =J52+J907 =K52+K907 =L52+L907 =M52+M907 =N52+N907 =O52+O907 =P52+P907 =Q52+Q907 =R52+R907 =S52+S907 =T52+T907 56 L38 58 58 TITLUL X PROIECTE CU FINANTARE DIN FEN AFERENTE CADRULUI FINANCIAR 2014-2020 =J53+J908 =K53+K908 =L53+L908 =M53+M908 =N53+N908 =O53+O908 =P53+P908 =Q53+Q908 =R53+R908 =S53+S908 =T53+T908 58 L39 59 59 TITLUL XI ALTE CHELTUIELI =J54 =K54 =L54 =M54 =N54 =O54 =P54 =Q54 =R54 =S54 =T54 59 L40 65 65 TITLUL XI CHELTUIELI AFERENTE PROGRAMELOR CU FINANTARE RAMBURSABILA =J55 =K55 =L55 =M55 =N55 =O55 =P55 =Q55 =R55 =S55 =T55 65 L41 70 70 CHELTUIELI DE CAPITAL =J42 =K42 =L42 =M42 =N42 =O42 =P42 =Q42 =R42 =S42 =T42 70 L42 71 71 TITLUL XIII ACTIVE NEFINANCIARE =J57+J910+J998 =K57+K910+K998 =L57+L910+L998 =M57+M910+M998 =N57+N910+N998 =O57+O910+O998 =P57+P910+P998 =Q57+Q910+Q998 =R57+R910+R998 =S57+S910+S998 =T57+T910+T998 71 L43 79 79 OPERATIUNI FINANCIARE =J44 =K44 =L44 =M44 =N44 =O44 =P44 =Q44 =R44 =S44 =T44 79 L44 81 81 TITLUL XVI RAMBURSARI DE CREDITE =J59 =K59 =L59 =M59 =N59 =O59 =P59 =Q59 =R59 =S59 =T59 81 L45 5001 5001 CHELTUIELI - BUGET DE STAT =J46+J56+J58 =K46+K56+K58 =L46+L56+L58 =M46+M56+M58 =N46+N56+N58 =O46+O56+O58 =P46+P56+P58 =Q46+Q56+Q58 =R46+R56+R58 =S46+S56+S58 =T46+T56+T58 5001 L46 01 01 CHELTUIELI CURENTE =SUM(J47:J55) =SUM(K47:K55) =SUM(L47:L55) =SUM(M47:M55) =SUM(N47:N55) =SUM(O47:O55) =SUM(P47:P55) =SUM(Q47:Q55) =SUM(R47:R55) =SUM(S47:S55) =SUM(T47:T55) 01 L47 10 10 TITLUL I CHELTUIELI DE PERSONAL =J62 =K62 =L62 =M62 =N62 =O62 =P62 =Q62 =R62 =S62 =T62 10 L48 20 20 TITLUL II BUNURI ŞI SERVICII =J88 =K88 =L88 =M88 =N88 =O88 =P88 =Q88 =R88 =S88 =T88 20 L49 30 30 TITLUL III DOBANZI =J129 =K129 =L129 =M129 =N129 =O129 =P129 =Q129 =R129 =S129 =T129 30 L50 51 51 TITLUL VI TRANSFERURI INTRE UNITATI ALE ADM PUBL =J132 =K132 =L132 =M132 =N132 =O132 =P132 =Q132 =R132 =S132 =T132 51 L51 55 55 TITLUL VII ALTE TRANSFERURI =J145 =K145 =L145 =M145 =N145 =O145 =P145 =Q145 =R145 =S145 =T145 55 L52 56 56 TITLUL VIII PROIECTE CU FINANTARE DIN FONDURI EXTERNE NERAMBURSABILE (FEN) POSTADERARE =J155 =K155 =L155 =M155 =N155 =O155 =P155 =Q155 =R155 =S155 =T155 56 L53 58 58 TITLUL X PROIECTE CU FINANTARE DIN FEN AFERENTE CADRULUI FINANCIAR 2014-2020 =J196 =K196 =L196 =M196 =N196 =O196 =P196 =Q196 =R196 =S196 =T196 58 L54 59 59 TITLUL XI ALTE CHELTUIELI =J206 =K206 =L206 =M206 =N206 =O206 =P206 =Q206 =R206 =S206 =T206 59 L55 65 65 TITLUL XI CHELTUIELI AFERENTE PROGRAMELOR CU FINANTARE RAMBURSABILA =J220 =K220 =L220 =M220 =N220 =O220 =P220 =Q220 =R220 =S220 =T220 65 L56 70 70 CHELTUIELI DE CAPITAL =J57 =K57 =L57 =M57 =N57 =O57 =P57 =Q57 =R57 =S57 =T57 70 L57 71 71 TITLUL XIII ACTIVE NEFINANCIARE =J223 =K223 =L223 =M223 =N223 =O223 =P223 =Q223 =R223 =S223 =T223 71 L58 79 79 OPERATIUNI FINANCIARE =J59 =K59 =L59 =M59 =N59 =O59 =P59 =Q59 =R59 =S59 =T59 79 L59 81 81 TITLUL XVI RAMBURSARI DE CREDITE =J231 =K231 =L231 =M231 =N231 =O231 =P231 =Q231 =R231 =S231 =T231 81 L60 =CONCATENATE("5001",H60) 5001 5001 CHELTUIELI - BUGET DE STAT =J61+J222+J230 =K61+K222+K230 =L61+L222+L230 =M61+M222+M230 =N61+N222+N230 =O61+O222+O230 =P61+P222+P230 =Q61+Q222+Q230 =R61+R222+R230 =S61+S222+S230 =T61+T222+T230 5001 L61 =CONCATENATE("5001",H61) =LEFT(A61,4) 01 01 CHELTUIELI CURENTE =J62+J88+J129+J132+J145+J155+J196+J206+J220 =K62+K88+K129+K132+K145+K155+K196+K206+K220 =L62+L88+L129+L132+L145+L155+L196+L206+L220 =M62+M88+M129+M132+M145+M155+M196+M206+M220 =N62+N88+N129+N132+N145+N155+N196+N206+N220 =O62+O88+O129+O132+O145+O155+O196+O206+O220 =P62+P88+P129+P132+P145+P155+P196+P206+P220 =Q62+Q88+Q129+Q132+Q145+Q155+Q196+Q206+Q220 =R62+R88+R129+R132+R145+R155+R196+R206+R220 =S62+S88+S129+S132+S145+S155+S196+S206+S220 =T62+T88+T129+T132+T145+T155+T196+T206+T220 01 L62 =CONCATENATE("5001",H62) =LEFT(A62,4) 10 10 TITLUL I CHELTUIELI DE PERSONAL =J63+J77+J82 =K63+K77+K82 =L63+L77+L82 =M63+M77+M82 =N63+N77+N82 =O63+O77+O82 =P63+P77+P82 =Q63+Q77+Q82 =R63+R77+R82 =S63+S77+S82 =T63+T77+T82 10 L63 =CONCATENATE("5001",H63) =LEFT(A63,4) 01 1001 Cheltuieli salariale în bani =SUM(J64:J76) =SUM(K64:K76) =SUM(L64:L76) =SUM(M64:M76) =SUM(N64:N76) =SUM(O64:O76) =SUM(P64:P76) =SUM(Q64:Q76) =SUM(R64:R76) =SUM(S64:S76) =SUM(T64:T76) 1001 L64 =CONCATENATE("5001",H64) =LEFT(A64,4) 01 100101 Salarii de baza =SUMIF($H$251:$H$901,$H64,J$251:J$901) =SUMIF($H$251:$H$901,$H64,K$251:K$901) =SUMIF($H$251:$H$901,$H64,L$251:L$901) =SUMIF($H$251:$H$901,$H64,M$251:M$901) =SUMIF($H$251:$H$901,$H64,N$251:N$901) =SUMIF($H$251:$H$901,$H64,O$251:O$901) =SUMIF($H$251:$H$901,$H64,P$251:P$901) =SUMIF($H$251:$H$901,$H64,Q$251:Q$901) =SUMIF($H$251:$H$901,$H64,R$251:R$901) =SUMIF($H$251:$H$901,$H64,S$251:S$901) =SUMIF($H$251:$H$901,$H64,T$251:T$901) 100101 L65 =CONCATENATE("5001",H65) =LEFT(A65,4) 05 100105 Sporuri pentru conditii de munca =SUMIF($H$251:$H$901,$H65,J$251:J$901) =SUMIF($H$251:$H$901,$H65,K$251:K$901) =SUMIF($H$251:$H$901,$H65,L$251:L$901) =SUMIF($H$251:$H$901,$H65,M$251:M$901) =SUMIF($H$251:$H$901,$H65,N$251:N$901) =SUMIF($H$251:$H$901,$H65,O$251:O$901) =SUMIF($H$251:$H$901,$H65,P$251:P$901) =SUMIF($H$251:$H$901,$H65,Q$251:Q$901) =SUMIF($H$251:$H$901,$H65,R$251:R$901) =SUMIF($H$251:$H$901,$H65,S$251:S$901) =SUMIF($H$251:$H$901,$H65,T$251:T$901) 100105 L66 =CONCATENATE("5001",H66) =LEFT(A66,4) 06 100106 Alte sporuri =SUMIF($H$251:$H$901,$H66,J$251:J$901) =SUMIF($H$251:$H$901,$H66,K$251:K$901) =SUMIF($H$251:$H$901,$H66,L$251:L$901) =SUMIF($H$251:$H$901,$H66,M$251:M$901) =SUMIF($H$251:$H$901,$H66,N$251:N$901) =SUMIF($H$251:$H$901,$H66,O$251:O$901) =SUMIF($H$251:$H$901,$H66,P$251:P$901) =SUMIF($H$251:$H$901,$H66,Q$251:Q$901) =SUMIF($H$251:$H$901,$H66,R$251:R$901) =SUMIF($H$251:$H$901,$H66,S$251:S$901) =SUMIF($H$251:$H$901,$H66,T$251:T$901) 100106 L67 =CONCATENATE("5001",H67) =LEFT(A67,4) 100107 Ore suplimentare =SUMIF($H$251:$H$901,$H67,J$251:J$901) =SUMIF($H$251:$H$901,$H67,K$251:K$901) =SUMIF($H$251:$H$901,$H67,L$251:L$901) =SUMIF($H$251:$H$901,$H67,M$251:M$901) =SUMIF($H$251:$H$901,$H67,N$251:N$901) =SUMIF($H$251:$H$901,$H67,O$251:O$901) =SUMIF($H$251:$H$901,$H67,P$251:P$901) =SUMIF($H$251:$H$901,$H67,Q$251:Q$901) =SUMIF($H$251:$H$901,$H67,R$251:R$901) =SUMIF($H$251:$H$901,$H67,S$251:S$901) =SUMIF($H$251:$H$901,$H67,T$251:T$901) 100107 L68 =CONCATENATE("5001",H68) =LEFT(A68,4) 100108 Fond de premii =SUMIF($H$251:$H$901,$H68,J$251:J$901) =SUMIF($H$251:$H$901,$H68,K$251:K$901) =SUMIF($H$251:$H$901,$H68,L$251:L$901) =SUMIF($H$251:$H$901,$H68,M$251:M$901) =SUMIF($H$251:$H$901,$H68,N$251:N$901) =SUMIF($H$251:$H$901,$H68,O$251:O$901) =SUMIF($H$251:$H$901,$H68,P$251:P$901) =SUMIF($H$251:$H$901,$H68,Q$251:Q$901) =SUMIF($H$251:$H$901,$H68,R$251:R$901) =SUMIF($H$251:$H$901,$H68,S$251:S$901) =SUMIF($H$251:$H$901,$H68,T$251:T$901) 100108 L69 =CONCATENATE("5001",H69) =LEFT(A69,4) 100109 Prima de vacanta =SUMIF($H$251:$H$901,$H69,J$251:J$901) =SUMIF($H$251:$H$901,$H69,K$251:K$901) =SUMIF($H$251:$H$901,$H69,L$251:L$901) =SUMIF($H$251:$H$901,$H69,M$251:M$901) =SUMIF($H$251:$H$901,$H69,N$251:N$901) =SUMIF($H$251:$H$901,$H69,O$251:O$901) =SUMIF($H$251:$H$901,$H69,P$251:P$901) =SUMIF($H$251:$H$901,$H69,Q$251:Q$901) =SUMIF($H$251:$H$901,$H69,R$251:R$901) =SUMIF($H$251:$H$901,$H69,S$251:S$901) =SUMIF($H$251:$H$901,$H69,T$251:T$901) 100109 L70 =CONCATENATE("5001",H70) =LEFT(A70,4) 100110 Fondul pentru posturi ocupate prin cumul =SUMIF($H$251:$H$901,$H70,J$251:J$901) =SUMIF($H$251:$H$901,$H70,K$251:K$901) =SUMIF($H$251:$H$901,$H70,L$251:L$901) =SUMIF($H$251:$H$901,$H70,M$251:M$901) =SUMIF($H$251:$H$901,$H70,N$251:N$901) =SUMIF($H$251:$H$901,$H70,O$251:O$901) =SUMIF($H$251:$H$901,$H70,P$251:P$901) =SUMIF($H$251:$H$901,$H70,Q$251:Q$901) =SUMIF($H$251:$H$901,$H70,R$251:R$901) =SUMIF($H$251:$H$901,$H70,S$251:S$901) =SUMIF($H$251:$H$901,$H70,T$251:T$901) 100110 L71 =CONCATENATE("5001",H71) =LEFT(A71,4) 12 100112 Indemnizatii platite unor persoane din afara unitatii =SUMIF($H$251:$H$901,$H71,J$251:J$901) =SUMIF($H$251:$H$901,$H71,K$251:K$901) =SUMIF($H$251:$H$901,$H71,L$251:L$901) =SUMIF($H$251:$H$901,$H71,M$251:M$901) =SUMIF($H$251:$H$901,$H71,N$251:N$901) =SUMIF($H$251:$H$901,$H71,O$251:O$901) =SUMIF($H$251:$H$901,$H71,P$251:P$901) =SUMIF($H$251:$H$901,$H71,Q$251:Q$901) =SUMIF($H$251:$H$901,$H71,R$251:R$901) =SUMIF($H$251:$H$901,$H71,S$251:S$901) =SUMIF($H$251:$H$901,$H71,T$251:T$901) 100112 L72 =CONCATENATE("5001",H72) =LEFT(A72,4) 13 100113 Indemnizatii de delegare =SUMIF($H$251:$H$901,$H72,J$251:J$901) =SUMIF($H$251:$H$901,$H72,K$251:K$901) =SUMIF($H$251:$H$901,$H72,L$251:L$901) =SUMIF($H$251:$H$901,$H72,M$251:M$901) =SUMIF($H$251:$H$901,$H72,N$251:N$901) =SUMIF($H$251:$H$901,$H72,O$251:O$901) =SUMIF($H$251:$H$901,$H72,P$251:P$901) =SUMIF($H$251:$H$901,$H72,Q$251:Q$901) =SUMIF($H$251:$H$901,$H72,R$251:R$901) =SUMIF($H$251:$H$901,$H72,S$251:S$901) =SUMIF($H$251:$H$901,$H72,T$251:T$901) 100113 L73 =CONCATENATE("5001",H73) =LEFT(A73,4) 14 100114 Indemnizatii detasare =SUMIF($H$251:$H$901,$H73,J$251:J$901) =SUMIF($H$251:$H$901,$H73,K$251:K$901) =SUMIF($H$251:$H$901,$H73,L$251:L$901) =SUMIF($H$251:$H$901,$H73,M$251:M$901) =SUMIF($H$251:$H$901,$H73,N$251:N$901) =SUMIF($H$251:$H$901,$H73,O$251:O$901) =SUMIF($H$251:$H$901,$H73,P$251:P$901) =SUMIF($H$251:$H$901,$H73,Q$251:Q$901) =SUMIF($H$251:$H$901,$H73,R$251:R$901) =SUMIF($H$251:$H$901,$H73,S$251:S$901) =SUMIF($H$251:$H$901,$H73,T$251:T$901) 100114 L74 =CONCATENATE("5001",H74) =LEFT(A74,4) 15 100115 Alocatii pt transport la si de la locul de munca =SUMIF($H$251:$H$901,$H74,J$251:J$901) =SUMIF($H$251:$H$901,$H74,K$251:K$901) =SUMIF($H$251:$H$901,$H74,L$251:L$901) =SUMIF($H$251:$H$901,$H74,M$251:M$901) =SUMIF($H$251:$H$901,$H74,N$251:N$901) =SUMIF($H$251:$H$901,$H74,O$251:O$901) =SUMIF($H$251:$H$901,$H74,P$251:P$901) =SUMIF($H$251:$H$901,$H74,Q$251:Q$901) =SUMIF($H$251:$H$901,$H74,R$251:R$901) =SUMIF($H$251:$H$901,$H74,S$251:S$901) =SUMIF($H$251:$H$901,$H74,T$251:T$901) 100115 L75 =CONCATENATE("5001",H75) =LEFT(A75,4) 16 100116 Alocatii pentru locuinte =SUMIF($H$251:$H$901,$H75,J$251:J$901) =SUMIF($H$251:$H$901,$H75,K$251:K$901) =SUMIF($H$251:$H$901,$H75,L$251:L$901) =SUMIF($H$251:$H$901,$H75,M$251:M$901) =SUMIF($H$251:$H$901,$H75,N$251:N$901) =SUMIF($H$251:$H$901,$H75,O$251:O$901) =SUMIF($H$251:$H$901,$H75,P$251:P$901) =SUMIF($H$251:$H$901,$H75,Q$251:Q$901) =SUMIF($H$251:$H$901,$H75,R$251:R$901) =SUMIF($H$251:$H$901,$H75,S$251:S$901) =SUMIF($H$251:$H$901,$H75,T$251:T$901) 100116 L76 =CONCATENATE("5001",H76) =LEFT(A76,4) 30 100130 Alte drepturi salariale in bani =SUMIF($H$251:$H$901,$H76,J$251:J$901) =SUMIF($H$251:$H$901,$H76,K$251:K$901) =SUMIF($H$251:$H$901,$H76,L$251:L$901) =SUMIF($H$251:$H$901,$H76,M$251:M$901) =SUMIF($H$251:$H$901,$H76,N$251:N$901) =SUMIF($H$251:$H$901,$H76,O$251:O$901) =SUMIF($H$251:$H$901,$H76,P$251:P$901) =SUMIF($H$251:$H$901,$H76,Q$251:Q$901) =SUMIF($H$251:$H$901,$H76,R$251:R$901) =SUMIF($H$251:$H$901,$H76,S$251:S$901) =SUMIF($H$251:$H$901,$H76,T$251:T$901) 100130 L77 =CONCATENATE("5001",H77) =LEFT(A77,4) 02 1002 Cheltuieli salariale în natură =SUM(J78:J81) =SUM(K78:K81) =SUM(L78:L81) =SUM(M78:M81) =SUM(N78:N81) =SUM(O78:O81) =SUM(P78:P81) =SUM(Q78:Q81) =SUM(R78:R81) =SUM(S78:S81) =SUM(T78:T81) 1002 L78 =CONCATENATE("5001",H78) =LEFT(A78,4) 100201 Tichete de masa =SUMIF($H$251:$H$901,$H78,J$251:J$901) =SUMIF($H$251:$H$901,$H78,K$251:K$901) =SUMIF($H$251:$H$901,$H78,L$251:L$901) =SUMIF($H$251:$H$901,$H78,M$251:M$901) =SUMIF($H$251:$H$901,$H78,N$251:N$901) =SUMIF($H$251:$H$901,$H78,O$251:O$901) =SUMIF($H$251:$H$901,$H78,P$251:P$901) =SUMIF($H$251:$H$901,$H78,Q$251:Q$901) =SUMIF($H$251:$H$901,$H78,R$251:R$901) =SUMIF($H$251:$H$901,$H78,S$251:S$901) =SUMIF($H$251:$H$901,$H78,T$251:T$901) 100201 L79 =CONCATENATE("5001",H79) =LEFT(A79,4) 02 100202 Norma de hrana =SUMIF($H$251:$H$901,$H79,J$251:J$901) =SUMIF($H$251:$H$901,$H79,K$251:K$901) =SUMIF($H$251:$H$901,$H79,L$251:L$901) =SUMIF($H$251:$H$901,$H79,M$251:M$901) =SUMIF($H$251:$H$901,$H79,N$251:N$901) =SUMIF($H$251:$H$901,$H79,O$251:O$901) =SUMIF($H$251:$H$901,$H79,P$251:P$901) =SUMIF($H$251:$H$901,$H79,Q$251:Q$901) =SUMIF($H$251:$H$901,$H79,R$251:R$901) =SUMIF($H$251:$H$901,$H79,S$251:S$901) =SUMIF($H$251:$H$901,$H79,T$251:T$901) 100202 L80 =CONCATENATE("5001",H80) =LEFT(A80,4) 04 100204 Locuinte de serviciu folosita de salariat si familia sa =SUMIF($H$251:$H$901,$H80,J$251:J$901) =SUMIF($H$251:$H$901,$H80,K$251:K$901) =SUMIF($H$251:$H$901,$H80,L$251:L$901) =SUMIF($H$251:$H$901,$H80,M$251:M$901) =SUMIF($H$251:$H$901,$H80,N$251:N$901) =SUMIF($H$251:$H$901,$H80,O$251:O$901) =SUMIF($H$251:$H$901,$H80,P$251:P$901) =SUMIF($H$251:$H$901,$H80,Q$251:Q$901) =SUMIF($H$251:$H$901,$H80,R$251:R$901) =SUMIF($H$251:$H$901,$H80,S$251:S$901) =SUMIF($H$251:$H$901,$H80,T$251:T$901) 100204 L81 =CONCATENATE("5001",H81) =LEFT(A81,4) 100230 Alte drepturi salariale in natura =SUMIF($H$251:$H$901,$H8