{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["calculator venituri","deduceri"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"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":"calculator venituri","index":0,"n_rows":33,"n_cols":13,"rows_kept":33,"cut":false,"hidden":false,"merged":[[2,0,3,0],[4,0,5,0],[4,1,5,2],[2,7,3,8],[2,4,3,5],[4,4,5,6],[4,7,5,9],[4,10,5,12],[2,6,3,6],[2,1,3,2],[2,9,3,9],[2,12,3,12],[0,1,1,2],[1,4,1,6],[1,7,1,9],[1,10,1,12],[0,4,0,12],[2,10,3,11]]}
[null,2017,null,null,2018]
[null,null,null,null,"Acelasi BRUT",null,null,"Acelasi NET",null,null,"Aceleasi Cheltuieli"]
["SALARIU BRUT",4000,null,null,{"$f":"VenitBrut2017","v":4000},null,{"$f":"E3-VenitBrut2017","v":0},4797,null,{"$f":"VenitBrut2018_1-VenitBrut2017","v":797},4803,null,{"$f":"VenitBrut2018_2-VenitBrut2017","v":803}]
[]
["Persoane in intretinere",0,null,null,{"$f":"PersoaneIntretinere","v":0},null,null,{"$f":"PersoaneIntretinere","v":0},null,null,{"$f":"PersoaneIntretinere","v":0}]
[]
[]
[null,null,"RON",null,null,"RON",null,null,"RON",null,null,"RON"]
["Venit net",null,{"$f":"B3-SUM(C14:C16)","v":3340},null,null,{"$f":"E3-SUM(F14:F16)","v":2600},null,null,{"$f":"H3-SUM(I14:I16)","v":3118},null,null,{"$f":"K3-SUM(L14:L16)","v":3122}]
["Deducere personala ",null,{"$f":"IF(B3<=3000,IF(B3<=1500,IF(B5<4,300+B5*100,800),ROUNDUP((IF(B5<4,300+B5*100,800)*(1-(B3-1500)/1500))/10,0)*10),0)","v":0},null,null,{"$f":"IF(E3<=3600,VLOOKUP(E3,deduceri!$A$3:$G$36,3+IF(E5<=4,E5,4),1),0)","v":0},null,null,{"$f":"IF(H3<=3600,VLOOKUP(H3,deduceri!$A$3:$G$36,3+IF(H5<=4,H5,4),1),0)","v":0},null,null,{"$f":"IF(K3<=3600,VLOOKUP(K3,deduceri!$A$3:$G$36,3+IF(K5<=4,K5,4),1),0)","v":0}]
["Venit impozabil",null,{"$f":"C9-C10","v":3340},null,null,{"$f":"IF(F9-F10<0,0,F9-F10)","v":2600},null,null,{"$f":"IF(I9-I10<0,0,I9-I10)","v":3118},null,null,{"$f":"IF(L9-L10<0,0,L9-L10)","v":3122}]
[]
["CONTRIBUTII SALARIAT","Procent","RON",null,"Procent","RON",null,"Procent","RON",null,"Procent","RON"]
["Contributie somaj",5.0000000000000001E-3,{"$f":"ROUND(B3*B14,0)","v":20},null,0,{"$f":"ROUND(E3*E14,0)","v":0},null,0,{"$f":"ROUND(H3*H14,0)","v":0},null,0,{"$f":"ROUND(K3*K14,0)","v":0}]
["Contributie pensii",0.105,{"$f":"ROUND(B3*B15,0)","v":420},null,0.25,{"$f":"ROUND(E3*E15,0)","v":1000},null,0.25,{"$f":"ROUND(H3*H15,0)","v":1199},null,0.25,{"$f":"ROUND(K3*K15,0)","v":1201}]
["Contributie sanatate",5.5E-2,{"$f":"ROUND(B3*B16,0)","v":220},null,0.1,{"$f":"ROUND(E3*E16,0)","v":400},null,0.1,{"$f":"ROUND(H3*H16,0)","v":480},null,0.1,{"$f":"ROUND(K3*K16,0)","v":480}]
["Impozit",0.16,{"$f":"ROUND(C11*B17,0)","v":534},null,0.1,{"$f":"ROUND(F11*E17,0)","v":260},null,0.1,{"$f":"ROUND(I11*H17,0)","v":312},null,0.1,{"$f":"ROUND(L11*K17,0)","v":312}]
["TOTAL CONTRIBUTII SALARIAT",null,{"$f":"SUM(C14:C17)","v":1194},null,null,{"$f":"SUM(F14:F17)","v":1660},null,null,{"$f":"SUM(I14:I17)","v":1991},null,null,{"$f":"SUM(L14:L17)","v":1993}]
[]
["CONTRIBUTII SOCIETATE","Procent","RON",null,"Procent","RON",null,"Procent","RON",null,"Procent","RON"]
["Contributie somaj ",5.0000000000000001E-3,{"$f":"ROUND(B3*B21,0)","v":20},null,0,{"$f":"ROUND(E3*E21,0)","v":0},null,0,{"$f":"ROUND(H3*H21,0)","v":0},null,0,{"$f":"ROUND(K3*K21,0)","v":0}]
["Contributie sanatate",5.1999999999999998E-2,{"$f":"ROUND(B3*B22,0)","v":208},null,0,{"$f":"ROUND(E3*E22,0)","v":0},null,0,{"$f":"ROUND(H3*H22,0)","v":0},null,0,{"$f":"ROUND(K3*K22,0)","v":0}]
["Contributie pensii",0.158,{"$f":"ROUND(B3*B23,0)","v":632},null,0,{"$f":"ROUND(E3*E23,0)","v":0},null,0,{"$f":"ROUND(H3*H23,0)","v":0},null,0,{"$f":"ROUND(K3*K23,0)","v":0}]
["Contributie concedii si indemnizatii ",8.5000000000000006E-3,{"$f":"ROUND(B3*B24,0)","v":34},null,0,{"$f":"ROUND(E3*E24,0)","v":0},null,0,{"$f":"ROUND(H3*H24,0)","v":0},null,0,{"$f":"ROUND(K3*K24,0)","v":0}]
["Fond asigurari accidente",1.7799999999999999E-3,{"$f":"ROUND(B3*B25,0)","v":7},null,0,{"$f":"ROUND(E3*E25,0)","v":0},null,0,{"$f":"ROUND(H3*H25,0)","v":0},null,0,{"$f":"ROUND(K3*K25,0)","v":0}]
["Fond garantare creante salariale",2.5000000000000001E-3,{"$f":"ROUND(B3*B26,0)","v":10},null,0,{"$f":"ROUND(E3*E26,0)","v":0},null,0,{"$f":"ROUND(H3*H26,0)","v":0},null,0,{"$f":"ROUND(K3*K26,0)","v":0}]
["Contributia asiguratorie pentru munca",0,{"$f":"ROUND(B3*B27,0)","v":0},null,2.2499999999999999E-2,{"$f":"ROUND(E3*E27,0)","v":90},null,2.2499999999999999E-2,{"$f":"ROUND(H3*H27,0)","v":108},null,2.2499999999999999E-2,{"$f":"ROUND(K3*K27,0)","v":108}]
["TOTAL CONTRIBUTII SOCIETATE",null,{"$f":"SUM(C21:C27)","v":911},null,null,{"$f":"SUM(F21:F27)","v":90},null,null,{"$f":"SUM(I21:I27)","v":108},null,null,{"$f":"SUM(L21:L27)","v":108}]
[]
[null,null,"RON",null,null,"RON",null,null,"RON",null,null,"RON"]
["SALARIU NET",null,{"$f":"B3-C18","v":2806},null,null,{"$f":"E3-F18","v":2340},{"$f":"F31-VenitNet2017","v":-466},null,{"$f":"H3-I18","v":2806},{"$f":"I31-VenitNet2017","v":0},null,{"$f":"K3-L18","v":2810},{"$f":"L31-VenitNet2017","v":4}]
["TOTAL CONTRIBUTII ",null,{"$f":"C28+C18","v":2105},null,null,{"$f":"F28+F18","v":1750},{"$f":"F32-C32","v":-355},null,{"$f":"I28+I18","v":2099},{"$f":"I32-C32","v":-6},null,{"$f":"L28+L18","v":2101},{"$f":"L32-C32","v":-4}]
["TOTAL COST SOCIETATE",null,{"$f":"C32+C31","v":4911},null,null,{"$f":"F32+F31","v":4090},{"$f":"F33-C33","v":-821},null,{"$f":"I32+I31","v":4905},{"$f":"I33-C33","v":-6},null,{"$f":"L32+L31","v":4911},{"$f":"L33-C33","v":0}]

{"sheet":"deduceri","index":1,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,1,1],[0,2,0,6]]}
["Venit lunar brut        ",null,"Persoane aflate în întreținere"]
[null,null,0,1,2,3,4]
[1,1950,510,670,830,990,1310]
[1951,2000,495,655,815,975,1295]
[2001,2050,480,640,800,960,1280]
[2051,2100,465,625,785,945,1265]
[2101,2150,450,610,770,930,1250]
[2151,2200,435,595,755,915,1235]
[2201,2250,420,580,740,900,1220]
[2251,2300,405,565,725,885,1205]
[2301,2350,390,550,710,870,1190]
[2351,2400,375,535,695,855,1175]
[2401,2450,360,520,680,840,1160]
[2451,2500,345,505,665,825,1145]
[2501,2550,330,490,650,810,1130]
[2551,2600,315,475,635,795,1115]
[2601,2650,300,460,620,780,1100]
[2651,2700,285,445,605,765,1085]
[2701,2750,270,430,590,750,1070]
[2751,2800,255,415,575,735,1055]
[2801,2850,240,400,560,720,1040]
[2851,2900,225,385,545,705,1025]
[2901,2950,210,370,530,690,1010]
[2951,3000,195,355,515,675,995]
[3001,3050,180,340,500,660,980]
[3051,3100,165,325,485,645,965]
[3101,3150,150,310,470,630,950]
[3151,3200,135,295,455,615,935]
[3201,3250,120,280,440,600,920]
[3251,3300,105,265,425,585,905]
[3301,3350,90,250,410,570,890]
[3351,3400,75,235,395,555,875]
[3401,3450,60,220,380,540,860]
[3451,3500,45,205,365,525,845]
[3501,3550,30,190,350,510,830]
[3551,3600,15,175,335,495,815]