Bugetul Secretariatului General al Guvernului / 2018 Buget SGG și instituții finanțate de la bugetul de stat

Sheet1 L1 SECRETARIATUL GENERAL AL GUVERNULUI L2 Repartizarea pe ordonatori a bugetului aprobat prin Legea bugetului de stat pe anul 2018 nr.2/2018 L3 Institutii finantate de la bugetul de stat L6 Titular: 13 mii lei L7 Cod Capi-tol Sub-capi-tol Paragraf Gru-pa/ titlu Arti-col Ali-neat Cod Denumire indicator Program 2018 din care: Cod L8 SGG INS DLAF ANR ANRM CNCAN CNP 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 =U10+U13+U16 000108 L10 4008 Operatiuni financiare =J11 =K11 =L11 =M11 =N11 =O11 =P11 =Q11 =R11 =S11 =T11 =U11 4008 L11 400815 Sume utilizate din excedentul anului precedent =J12 =K12 =L12 =M12 =N12 =O12 =P12 =Q12 =R12 =S12 =T12 =U12 400815 L12 40081503 Sume utilizate de alte institutii din excedentul anului precedent 0 0 0 0 0 0 0 0 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 =U14+U15 4208 L14 420860 Cofinanţare publică acordată în cadrul mecanismului SEE 0 0 0 0 0 0 0 0 0 0 0 0 420860 L15 420861 Cofinantare publica acordata in cadrul mecanismului norvegian 0 0 0 0 0 0 0 0 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 =U17+U19 4508 L17 450817 Mecanismul financiar SEE =J18 =K18 =L18 =M18 =N18 =O18 =P18 =Q18 =R18 =S18 =T18 =U18 450817 L18 45081703 Prefinantare 0 0 0 0 0 0 0 0 0 0 0 0 45081703 L19 450818 Mecanismul financiar norvegian =J20 =K20 =L20 =M20 =N20 =O20 =P20 =Q20 =R20 =S20 =T20 =U20 450818 L20 45081803 Prefinantare 0 0 0 0 0 0 0 0 0 0 0 0 45081803 L21 000110 VENITURI PROPRII - TOTAL =J22 =K22 =L22 =M22 =N22 =O22 =P22 =Q22 =R22 =S22 =T22 =U22 000110 L22 000210 I. VENITURI CURENTE =J23 =K23 =L23 =M23 =N23 =O23 =P23 =Q23 =R23 =S23 =T23 =U23 000210 L23 290010 C. VENITURI NEFISCALE =J24 =K24 =L24 =M24 =N24 =O24 =P24 =Q24 =R24 =S24 =T24 =U24 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 =U25+U27 300010 L25 3410 Venituri din taxe administrative, eliberari permise =J26 =K26 =L26 =M26 =N26 =O26 =P26 =Q26 =R26 =S26 =T26 =U26 3410 L26 341050 Alte venituri din taxe administrative, eliberari permise 1900 0 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 =U28 3610 L28 361050 Alte venituri 0 0 0 0 0 0 0 0 0 0 0 0 361050 L30 5000 5000 CHELTUIELI - TOTAL =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 =U31+U41+U43 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) =SUM(U32:U40) 01 L32 10 10 TITLUL I CHELTUIELI DE PERSONAL =J47+J926+J1016 =K47+K926+K1016 =L47+L926+L1016 =M47+M926+M1016 =N47+N926+N1016 =O47+O926+O1016 =P47+P926+P1016 =Q47+Q926+Q1016 =R47+R926+R1016 =S47+S926+S1016 =T47+T926+T1016 =U47+U926+U1016 10 L33 20 20 TITLUL II BUNURI ŞI SERVICII =J48+J927+J1017 =K48+K927+K1017 =L48+L927+L1017 =M48+M927+M1017 =N48+N927+N1017 =O48+O927+O1017 =P48+P927+P1017 =Q48+Q927+Q1017 =R48+R927+R1017 =S48+S927+S1017 =T48+T927+T1017 =U48+U927+U1017 20 L34 30 30 TITLUL III DOBANZI =J49 =K49 =L49 =M49 =N49 =O49 =P49 =Q49 =R49 =S49 =T49 =U49 30 L35 51 51 TITLUL VI TRANSFERURI INTRE UNITATI ALE ADM PUBL =J50 =K50 =L50 =M50 =N50 =O50 =P50 =Q50 =R50 =S50 =T50 =U50 51 L36 55 55 TITLUL VII ALTE TRANSFERURI =J51+J928+J1018 =K51+K928+K1018 =L51+L928+L1018 =M51+M928+M1018 =N51+N928+N1018 =O51+O928+O1018 =P51+P928+P1018 =Q51+Q928+Q1018 =R51+R928+R1018 =S51+S928+S1018 =T51+T928+T1018 =U51+U928+U1018 55 L37 56 56 TITLUL VIII PROIECTE CU FINANTARE DIN FONDURI EXTERNE NERAMBURSABILE (FEN) POSTADERARE =J52+J929 =K52+K929 =L52+L929 =M52+M929 =N52+N929 =O52+O929 =P52+P929 =Q52+Q929 =R52+R929 =S52+S929 =T52+T929 =U52+U929 56 L38 58 58 TITLUL X PROIECTE CU FINANTARE DIN FEN AFERENTE CADRULUI FINANCIAR 2014-2020 =J53+J930 =K53+K930 =L53+L930 =M53+M930 =N53+N930 =O53+O930 =P53+P930 =Q53+Q930 =R53+R930 =S53+S930 =T53+T930 =U53+U930 58 L39 59 59 TITLUL XI ALTE CHELTUIELI =J54 =K54 =L54 =M54 =N54 =O54 =P54 =Q54 =R54 =S54 =T54 =U54 59 L40 65 65 TITLUL XI CHELTUIELI AFERENTE PROGRAMELOR CU FINANTARE RAMBURSABILA =J55 =K55 =L55 =M55 =N55 =O55 =P55 =Q55 =R55 =S55 =T55 =U55 65 L41 70 70 CHELTUIELI DE CAPITAL =J42 =K42 =L42 =M42 =N42 =O42 =P42 =Q42 =R42 =S42 =T42 =U42 70 L42 71 71 TITLUL XIII ACTIVE NEFINANCIARE =J57+J932+J1020 =K57+K932+K1020 =L57+L932+L1020 =M57+M932+M1020 =N57+N932+N1020 =O57+O932+O1020 =P57+P932+P1020 =Q57+Q932+Q1020 =R57+R932+R1020 =S57+S932+S1020 =T57+T932+T1020 =U57+U932+U1020 71 L43 79 79 OPERATIUNI FINANCIARE =J44 =K44 =L44 =M44 =N44 =O44 =P44 =Q44 =R44 =S44 =T44 =U44 79 L44 81 81 TITLUL XVI RAMBURSARI DE CREDITE =J59 =K59 =L59 =M59 =N59 =O59 =P59 =Q59 =R59 =S59 =T59 =U59 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 =U46+U56+U58 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) =SUM(U47:U55) 01 L47 10 10 TITLUL I CHELTUIELI DE PERSONAL =J62 =K62 =L62 =M62 =N62 =O62 =P62 =Q62 =R62 =S62 =T62 =U62 10 L48 20 20 TITLUL II BUNURI ŞI SERVICII =J91 =K91 =L91 =M91 =N91 =O91 =P91 =Q91 =R91 =S91 =T91 =U91 20 L49 30 30 TITLUL III DOBANZI =J132 =K132 =L132 =M132 =N132 =O132 =P132 =Q132 =R132 =S132 =T132 =U132 30 L50 51 51 TITLUL VI TRANSFERURI INTRE UNITATI ALE ADM PUBL =J135 =K135 =L135 =M135 =N135 =O135 =P135 =Q135 =R135 =S135 =T135 =U135 51 L51 55 55 TITLUL VII ALTE TRANSFERURI =J148 =K148 =L148 =M148 =N148 =O148 =P148 =Q148 =R148 =S148 =T148 =U148 55 L52 56 56 TITLUL VIII PROIECTE CU FINANTARE DIN FONDURI EXTERNE NERAMBURSABILE (FEN) POSTADERARE =J158 =K158 =L158 =M158 =N158 =O158 =P158 =Q158 =R158 =S158 =T158 =U158 56 L53 58 58 TITLUL X PROIECTE CU FINANTARE DIN FEN AFERENTE CADRULUI FINANCIAR 2014-2020 =J199 =K199 =L199 =M199 =N199 =O199 =P199 =Q199 =R199 =S199 =T199 =U199 58 L54 59 59 TITLUL XI ALTE CHELTUIELI =J210 =K210 =L210 =M210 =N210 =O210 =P210 =Q210 =R210 =S210 =T210 =U210 59 L55 65 65 TITLUL XI CHELTUIELI AFERENTE PROGRAMELOR CU FINANTARE RAMBURSABILA =J225 =K225 =L225 =M225 =N225 =O225 =P225 =Q225 =R225 =S225 =T225 =U225 65 L56 70 70 CHELTUIELI DE CAPITAL =J57 =K57 =L57 =M57 =N57 =O57 =P57 =Q57 =R57 =S57 =T57 =U57 70 L57 71 71 TITLUL XIII ACTIVE NEFINANCIARE =J228 =K228 =L228 =M228 =N228 =O228 =P228 =Q228 =R228 =S228 =T228 =U228 71 L58 79 79 OPERATIUNI FINANCIARE =J59 =K59 =L59 =M59 =N59 =O59 =P59 =Q59 =R59 =S59 =T59 =U59 79 L59 81 81 TITLUL XVI RAMBURSARI DE CREDITE =J236 =K236 =L236 =M236 =N236 =O236 =P236 =Q236 =R236 =S236 =T236 =U236 81 L60 =CONCATENATE("5001",H60) 5001 5001 CHELTUIELI - BUGET DE STAT =J61+J227+J235 =K61+K227+K235 =L61+L227+L235 =M61+M227+M235 =N61+N227+N235 =O61+O227+O235 =P61+P227+P235 =Q61+Q227+Q235 =R61+R227+R235 =S61+S227+S235 =T61+T227+T235 =U61+U227+U235 5001 L61 =CONCATENATE("5001",H61) =LEFT(A61,4) 01 01 CHELTUIELI CURENTE =J62+J91+J132+J135+J148+J158+J199+J210+J225 =K62+K91+K132+K135+K148+K158+K199+K210+K225 =L62+L91+L132+L135+L148+L158+L199+L210+L225 =M62+M91+M132+M135+M148+M158+M199+M210+M225 =N62+N91+N132+N135+N148+N158+N199+N210+N225 =O62+O91+O132+O135+O148+O158+O199+O210+O225 =P62+P91+P132+P135+P148+P158+P199+P210+P225 =Q62+Q91+Q132+Q135+Q148+Q158+Q199+Q210+Q225 =R62+R91+R132+R135+R148+R158+R199+R210+R225 =S62+S91+S132+S135+S148+S158+S199+S210+S225 =T62+T91+T132+T135+T148+T158+T199+T210+T225 =U62+U91+U132+U135+U148+U158+U199+U210+U225 01 L62 =CONCATENATE("5001",H62) =LEFT(A62,4) 10 10 TITLUL I CHELTUIELI DE PERSONAL =J63+J77+J83 =K63+K77+K83 =L63+L77+L83 =M63+M77+M83 =N63+N77+N83 =O63+O77+O83 =P63+P77+P83 =Q63+Q77+Q83 =R63+R77+R83 =S63+S77+S83 =T63+T77+T83 =U63+U77+U83 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) =SUM(U64:U76) 1001 L64 =CONCATENATE("5001",H64) =LEFT(A64,4) 01 100101 Salarii de baza =SUMIF($H$256:$H$923,$H64,J$256:J$923) =SUMIF($H$256:$H$923,$H64,K$256:K$923) =SUMIF($H$256:$H$923,$H64,L$256:L$923) =SUMIF($H$256:$H$923,$H64,M$256:M$923) =SUMIF($H$256:$H$923,$H64,N$256:N$923) =SUMIF($H$256:$H$923,$H64,O$256:O$923) =SUMIF($H$256:$H$923,$H64,P$256:P$923) =SUMIF($H$256:$H$923,$H64,Q$256:Q$923) =SUMIF($H$256:$H$923,$H64,R$256:R$923) =SUMIF($H$256:$H$923,$H64,S$256:S$923) =SUMIF($H$256:$H$923,$H64,T$256:T$923) =SUMIF($H$256:$H$923,$H64,U$256:U$923) 100101 L65 =CONCATENATE("5001",H65) =LEFT(A65,4) 05 100105 Sporuri pentru conditii de munca =SUMIF($H$256:$H$923,$H65,J$256:J$923) =SUMIF($H$256:$H$923,$H65,K$256:K$923) =SUMIF($H$256:$H$923,$H65,L$256:L$923) =SUMIF($H$256:$H$923,$H65,M$256:M$923) =SUMIF($H$256:$H$923,$H65,N$256:N$923) =SUMIF($H$256:$H$923,$H65,O$256:O$923) =SUMIF($H$256:$H$923,$H65,P$256:P$923) =SUMIF($H$256:$H$923,$H65,Q$256:Q$923) =SUMIF($H$256:$H$923,$H65,R$256:R$923) =SUMIF($H$256:$H$923,$H65,S$256:S$923) =SUMIF($H$256:$H$923,$H65,T$256:T$923) =SUMIF($H$256:$H$923,$H65,U$256:U$923) 100105 L66 =CONCATENATE("5001",H66) =LEFT(A66,4) 06 100106 Alte sporuri =SUMIF($H$256:$H$923,$H66,J$256:J$923) =SUMIF($H$256:$H$923,$H66,K$256:K$923) =SUMIF($H$256:$H$923,$H66,L$256:L$923) =SUMIF($H$256:$H$923,$H66,M$256:M$923) =SUMIF($H$256:$H$923,$H66,N$256:N$923) =SUMIF($H$256:$H$923,$H66,O$256:O$923) =SUMIF($H$256:$H$923,$H66,P$256:P$923) =SUMIF($H$256:$H$923,$H66,Q$256:Q$923) =SUMIF($H$256:$H$923,$H66,R$256:R$923) =SUMIF($H$256:$H$923,$H66,S$256:S$923) =SUMIF($H$256:$H$923,$H66,T$256:T$923) =SUMIF($H$256:$H$923,$H66,U$256:U$923) 100106 L67 =CONCATENATE("5001",H67) =LEFT(A67,4) 100107 Ore suplimentare =SUMIF($H$256:$H$923,$H67,J$256:J$923) =SUMIF($H$256:$H$923,$H67,K$256:K$923) =SUMIF($H$256:$H$923,$H67,L$256:L$923) =SUMIF($H$256:$H$923,$H67,M$256:M$923) =SUMIF($H$256:$H$923,$H67,N$256:N$923) =SUMIF($H$256:$H$923,$H67,O$256:O$923) =SUMIF($H$256:$H$923,$H67,P$256:P$923) =SUMIF($H$256:$H$923,$H67,Q$256:Q$923) =SUMIF($H$256:$H$923,$H67,R$256:R$923) =SUMIF($H$256:$H$923,$H67,S$256:S$923) =SUMIF($H$256:$H$923,$H67,T$256:T$923) =SUMIF($H$256:$H$923,$H67,U$256:U$923) 100107 L68 =CONCATENATE("5001",H68) =LEFT(A68,4) 100108 Fond de premii =SUMIF($H$256:$H$923,$H68,J$256:J$923) =SUMIF($H$256:$H$923,$H68,K$256:K$923) =SUMIF($H$256:$H$923,$H68,L$256:L$923) =SUMIF($H$256:$H$923,$H68,M$256:M$923) =SUMIF($H$256:$H$923,$H68,N$256:N$923) =SUMIF($H$256:$H$923,$H68,O$256:O$923) =SUMIF($H$256:$H$923,$H68,P$256:P$923) =SUMIF($H$256:$H$923,$H68,Q$256:Q$923) =SUMIF($H$256:$H$923,$H68,R$256:R$923) =SUMIF($H$256:$H$923,$H68,S$256:S$923) =SUMIF($H$256:$H$923,$H68,T$256:T$923) =SUMIF($H$256:$H$923,$H68,U$256:U$923) 100108 L69 =CONCATENATE("5001",H69) =LEFT(A69,4) 100109 Prima de vacanta =SUMIF($H$256:$H$923,$H69,J$256:J$923) =SUMIF($H$256:$H$923,$H69,K$256:K$923) =SUMIF($H$256:$H$923,$H69,L$256:L$923) =SUMIF($H$256:$H$923,$H69,M$256:M$923) =SUMIF($H$256:$H$923,$H69,N$256:N$923) =SUMIF($H$256:$H$923,$H69,O$256:O$923) =SUMIF($H$256:$H$923,$H69,P$256:P$923) =SUMIF($H$256:$H$923,$H69,Q$256:Q$923) =SUMIF($H$256:$H$923,$H69,R$256:R$923) =SUMIF($H$256:$H$923,$H69,S$256:S$923) =SUMIF($H$256:$H$923,$H69,T$256:T$923) =SUMIF($H$256:$H$923,$H69,U$256:U$923) 100109 L70 =CONCATENATE("5001",H70) =LEFT(A70,4) 100110 Fondul pentru posturi ocupate prin cumul =SUMIF($H$256:$H$923,$H70,J$256:J$923) =SUMIF($H$256:$H$923,$H70,K$256:K$923) =SUMIF($H$256:$H$923,$H70,L$256:L$923) =SUMIF($H$256:$H$923,$H70,M$256:M$923) =SUMIF($H$256:$H$923,$H70,N$256:N$923) =SUMIF($H$256:$H$923,$H70,O$256:O$923) =SUMIF($H$256:$H$923,$H70,P$256:P$923) =SUMIF($H$256:$H$923,$H70,Q$256:Q$923) =SUMIF($H$256:$H$923,$H70,R$256:R$923) =SUMIF($H$256:$H$923,$H70,S$256:S$923) =SUMIF($H$256:$H$923,$H70,T$256:T$923) =SUMIF($H$256:$H$923,$H70,U$256:U$923) 100110 L71 =CONCATENATE("5001",H71) =LEFT(A71,4) 12 100112 Indemnizatii platite unor persoane din afara unitatii =SUMIF($H$256:$H$923,$H71,J$256:J$923) =SUMIF($H$256:$H$923,$H71,K$256:K$923) =SUMIF($H$256:$H$923,$H71,L$256:L$923) =SUMIF($H$256:$H$923,$H71,M$256:M$923) =SUMIF($H$256:$H$923,$H71,N$256:N$923) =SUMIF($H$256:$H$923,$H71,O$256:O$923) =SUMIF($H$256:$H$923,$H71,P$256:P$923) =SUMIF($H$256:$H$923,$H71,Q$256:Q$923) =SUMIF($H$256:$H$923,$H71,R$256:R$923) =SUMIF($H$256:$H$923,$H71,S$256:S$923) =SUMIF($H$256:$H$923,$H71,T$256:T$923) =SUMIF($H$256:$H$923,$H71,U$256:U$923) 100112 L72 =CONCATENATE("5001",H72) =LEFT(A72,4) 13 100113 Indemnizatii de delegare =SUMIF($H$256:$H$923,$H72,J$256:J$923) =SUMIF($H$256:$H$923,$H72,K$256:K$923) =SUMIF($H$256:$H$923,$H72,L$256:L$923) =SUMIF($H$256:$H$923,$H72,M$256:M$923) =SUMIF($H$256:$H$923,$H72,N$256:N$923) =SUMIF($H$256:$H$923,$H72,O$256:O$923) =SUMIF($H$256:$H$923,$H72,P$256:P$923) =SUMIF($H$256:$H$923,$H72,Q$256:Q$923) =SUMIF($H$256:$H$923,$H72,R$256:R$923) =SUMIF($H$256:$H$923,$H72,S$256:S$923) =SUMIF($H$256:$H$923,$H72,T$256:T$923) =SUMIF($H$256:$H$923,$H72,U$256:U$923) 100113 L73 =CONCATENATE("5001",H73) =LEFT(A73,4) 14 100114 Indemnizatii detasare =SUMIF($H$256:$H$923,$H73,J$256:J$923) =SUMIF($H$256:$H$923,$H73,K$256:K$923) =SUMIF($H$256:$H$923,$H73,L$256:L$923) =SUMIF($H$256:$H$923,$H73,M$256:M$923) =SUMIF($H$256:$H$923,$H73,N$256:N$923) =SUMIF($H$256:$H$923,$H73,O$256:O$923) =SUMIF($H$256:$H$923,$H73,P$256:P$923) =SUMIF($H$256:$H$923,$H73,Q$256:Q$923) =SUMIF($H$256:$H$923,$H73,R$256:R$923) =SUMIF($H$256:$H$923,$H73,S$256:S$923) =SUMIF($H$256:$H$923,$H73,T$256:T$923) =SUMIF($H$256:$H$923,$H73,U$256:U$923) 100114 L74 =CONCATENATE("5001",H74) =LEFT(A74,4) 15 100115 Alocatii pt transport la si de la locul de munca =SUMIF($H$256:$H$923,$H74,J$256:J$923) =SUMIF($H$256:$H$923,$H74,K$256:K$923) =SUMIF($H$256:$H$923,$H74,L$256:L$923) =SUMIF($H$256:$H$923,$H74,M$256:M$923) =SUMIF($H$256:$H$923,$H74,N$256:N$923) =SUMIF($H$256:$H$923,$H74,O$256:O$923) =SUMIF($H$256:$H$923,$H74,P$256:P$923) =SUMIF($H$256:$H$923,$H74,Q$256:Q$923) =SUMIF($H$256:$H$923,$H74,R$256:R$923) =SUMIF($H$256:$H$923,$H74,S$256:S$923) =SUMIF($H$256:$H$923,$H74,T$256:T$923) =SUMIF($H$256:$H$923,$H74,U$256:U$923) 100115 L75 =CONCATENATE("5001",H75) =LEFT(A75,4) 16 100116 Alocatii pentru locuinte =SUMIF($H$256:$H$923,$H75,J$256:J$923) =SUMIF($H$256:$H$923,$H75,K$256:K$923) =SUMIF($H$256:$H$923,$H75,L$256:L$923) =SUMIF($H$256:$H$923,$H75,M$256:M$923) =SUMIF($H$256:$H$923,$H75,N$256:N$923) =SUMIF($H$256:$H$923,$H75,O$256:O$923) =SUMIF($H$256:$H$923,$H75,P$256:P$923) =SUMIF($H$256:$H$923,$H75,Q$256:Q$923) =SUMIF($H$256:$H$923,$H75,R$256:R$923) =SUMIF($H$256:$H$923,$H75,S$256:S$923) =SUMIF($H$256:$H$923,$H75,T$256:T$923) =SUMIF($H$256:$H$923,$H75,U$256:U$923) 100116 L76 =CONCATENATE("5001",H76) =LEFT(A76,4) 30 100130 Alte drepturi salariale in bani =SUMIF($H$256:$H$923,$H76,J$256:J$923) =SUMIF($H$256:$H$923,$H76,K$256:K$923) =SUMIF($H$256:$H$923,$H76,L$256:L$923) =SUMIF($H$256:$H$923,$H76,M$256:M$923) =SUMIF($H$256:$H$923,$H76,N$256:N$923) =SUMIF($H$256:$H$923,$H76,O$256:O$923) =SUMIF($H$256:$H$923,$H76,P$256:P$923) =SUMIF($H$256:$H$923,$H76,Q$256:Q$923) =SUMIF($H$256:$H$923,$H76,R$256:R$923) =SUMIF($H$256:$H$923,$H76,S$256:S$923) =SUMIF($H$256:$H$923,$H76,T$256:T$923) =SUMIF($H$256:$H$923,$H76,U$256:U$923) 100130 L77 =CONCATENATE("5001",H77) =LEFT(A77,4) 02 1002 Cheltuieli salariale în natură =SUM(J78:J82) =SUM(K78:K82) =SUM(L78:L82) =SUM(M78:M82) =SUM(N78:N82) =SUM(O78:O82) =SUM(P78:P82) =SUM(Q78:Q82) =SUM(R78:R82) =SUM(S78:S82) =SUM(T78:T82) =SUM(U78:U82) 1002 L78 =CONCATENATE("5001",H78) =LEFT(A78,4) 100201 Tichete de masa =SUMIF($H$256:$H$923,$H78,J$256:J$923) =SUMIF($H$256:$H$923,$H78,K$256:K$923) =SUMIF($H$256:$H$923,$H78,L$256:L$923) =SUMIF($H$256:$H$923,$H78,M$256:M$923) =SUMIF($H$256:$H$923,$H78,N$256:N$923) =SUMIF($H$256:$H$923,$H78,O$256:O$923) =SUMIF($H$256:$H$923,$H78,P$256:P$923) =SUMIF($H$256:$H$923,$H78,Q$256:Q$923) =SUMIF($H$256:$H$923,$H78,R$256:R$923) =SUMIF($H$256:$H$923,$H78,S$256:S$923) =SUMIF($H$256:$H$923,$H78,T$256:T$923) =SUMIF($H$256:$H$923,$H78,U$256:U$923) 100201 L79 =CONCATENATE("5001",H79) =LEFT(A79,4) 02 100202 Norma de hrana =SUMIF($H$256:$H$923,$H79,J$256:J$923) =SUMIF($H$256:$H$923,$H79,K$256:K$923) =SUMIF($H$256:$H$923,$H79,L$256:L$923) =SUMIF($H$256:$H$923,$H79,M$256:M$923) =SUMIF($H$256:$H$923,$H79,N$256:N$923) =SUMIF($H$256:$H$923,$H79,O$256:O$923) =SUMIF($H$256:$H$923,$H79,P$256:P$923) =SUMIF($H$256:$H$923,$H79,Q$256:Q$923) =SUMIF($H$256:$H$923,$H79,R$256:R$923) =SUMIF($H$256:$H$923,$H79,S$256:S$923) =SUMIF($H$256:$H$923,$H79,T$256:T$923) =SUMIF($H$256:$H$923,$H79,U$256:U$923) 100202 L80 =CONCATENATE("5001",H80) =LEFT(A80,4) 04 100204 Locuinte de serviciu folosita de salariat si familia sa =SUMIF($H$256:$H$923,$H80,J$256:J$923) =SUMIF($H$256:$H$923,$H80,K$256:K$923) =SUMIF($H$256:$H$923,$H80,L$256:L$923) =SUMIF($H$256:$H$923,$H80,M$256:M$923) =SUMIF($H$256:$H$923,$H80,N$256:N$923) =SUMIF($H$256:$H$923,$H80,O$256:O$923) =SUMIF($H$256:$H$923,$H80,P$256:P$923) =SUMIF($H$256:$H$923,$H80,Q$256:Q$923) =SUMIF($H$256:$H$923,$H80,R$256:R$923) =SUM