Need to develop 2 Matrix
1. For salary increment based on Employee performance & Difference Vs. Min of New basic and then based on conditions inputs has to go into 4 columns
ie. If Gap is between 0-20% then close the full Gap in Year 1, if 21- 40 then divide it in Y1 & Y2 etc.
2. Bonus Matrix is based in individual performance, Compa-ratio & Employee performance.
28 freelancers are bidding on average $114 for this job
I am an Excel and VBA specialist with a lot of experience in creating complex formulas and macros. You may check some of my projects here: [login to view URL]
Hi - I have prepared compensation review models before and it would be a good idea to make it like a what if model so that you can play with it by changing the numbers and view impact. Lets discuss.
as an engineer in statistics and applied economics and computer development technician.I am very proficient in programming language R, Python and Minitab. I am able and ready to perform this task
Hi, i am well versed with Excel macros and other functions. i have used extensively. I can solve your problem. But require your sample input and output file , so that the instructions and requirements are clear