Excel (VBA) salary tool (Contract proposals)
€12-18 EUR / hour
The finality of the project is to send emails to candidates and to future managers about the proposed salary package offered to a candidate about to be hired in a company.
At the start, I have a global existing excel file with all people working in the company, their salary, their start date, their position, the department they work in, etc.
This existing file is of course constantly changing : salaries sometimes go higher, people leave the company, change of roles, etc.
What I would need to be created is another excelfile which would consist in two tabs (see document here attached). On the first tab, once you would insert the position name and the department, "salary max " and "salary min" tabs would be automatically filled in by checking in the main existing file the lowest and highest salaries for the other employees in the same position. "Salary max" should however be 20% lower than the highest salary (the aim is to limit somehow new salaries in the company…).
Once salaries have been filled in, the tabs below (about extra legal advantages) would have to be filled in manually.
Once all data have been completed in tab 1, I would have to go to tab 2 where all prefilled data would appear on a kind of proposal document. Below, there would be a graph with all salaries of other people in the same department and same position. Points in blue would represent people in same position and in same department. Points in red would represent employees in the same department.
Two "buttons" would be reprsented on the side of this tab and allowing to send an email to the candidate : the salary proposal would appear with all details in the body of the email (but without the graph (the employee does not have to know how his salary compares to his colleagues !)
The second button would allow to send an email to the manager, but this time with a graph.
Please note the company will not pay me for this job : so I expect reasonnable offers, thank you very much !!! :-)
Project ID: #20404289
About the project
19 freelancers are bidding on average €15/hour for this job
Hello Nicolas Schiltz, We are 85+ developer Team and we are working last 14+ years in I.T. I have gone through your requirements and understood that you are looking for Excel (VBA) salary tool. We will happy t More
Hi, good day. I'm interested in your project and want to participate, I read your description carefully and saw your attachment test pdf file, I know what exactly your needs on this project and we could have quick chat More
Hi There I've excellent programming and development skills in C#, ASP.NET, MySQL, and knowledge. I can provide an efficient, perfect, well-documented development of your Programming and Computer project according to 10 More
Greetings! My name is Sergey Murzin, I'm from Kyiv, Ukraine. I have 20 years experience with MS Excel/Access/VBA: databases, finance, statistics, accounting, CRM etc. Any code I provide is well structured and commen More
Hi Greetings of the Day, I am interested in this task, I am full time freelancer carrying 15 yrs of experience in VBA, Mobile development, Web and Windows development using ASP.Net, C#, SQL server, Xamarin, WebAPI, X More
Hi...Please allow me to share my work related to Performance Management of employees and Payroll/Incentives. I have strong Work Flow and Work Force Management and exp - Neeerience. With an expertise on VBA and Macros, More
Hello, I propose a budget $300 for this tool, and pay through paypal, I will completed it over 5 days. Thanks anyway
This sounds like a day or two of solid developing, then some time for review and finishing. My idea to do all of the requirements requires automating excel, outlook, and word to be able to create a rich text or html bo More
Hello, I have a strong expertise in excel. I expect to finish this task very shortly. You would be able to update the file yourself, in order to keep it running after we have discussed. Thank you