Đang Thực Hiện

Excel (VBA) salary tool (Contract proposals)

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 !!! :-)

Kĩ năng: Excel, Visual Basic, Visual Basic cho Ứng dụng, Kiến trúc phần mềm, PHP

Xem nhiều hơn: excel vba error, excel vba add installation, excel vba contract work, calculate salary using excel vba, excel vba freelance contract, excel vba tool reference, salary excel vba expert, contract programming excel vba, excel vba codes tool bar, excel vba contract hourly rate, excel vba contract, chart tool excel vba, excel vba quote tool, excel vba project estimation tool, excel vba calculation tool, excel vba contract bid, excel vba licensing tool, legal and trusted ways of free lance excel vba programming

Về Bên Thuê:
( 0 nhận xét ) Brussels, Belgium

ID dự án: #20404289

Được trao cho:

paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel application. I plan to use a combination of formulas and VBA code to acc Thêm

€18 EUR / giờ
(225 Đánh Giá)
7.4

22 freelancer đang chào giá trung bình €15/giờ cho công việc này

tudiptechnology

Hi there, To quickly apprise you about our model, our engineers would be working full time on your project only and would be completely integrated into your team. By complete integration, I mean, they would be atten Thêm

€15 EUR / giờ
(18 Nhận xét)
6.6
dvcontact

Hi, Would you like to see a quick demo of your project on developing Excel file with two tabs where data of employment will be entered into one and will appear in the second one which will automatically create graph of Thêm

€15 EUR / giờ
(48 Nhận xét)
6.3
nvchien94

Hello there, I am an Excel VBA expert and I can develop this file for you. I see your attachment but it is really bad for reading. LOL. Please contact me, I understand this task quite clear and we can finish it before Thêm

€20 EUR / giờ
(108 Nhận xét)
5.6
rajanthakor08

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 Thêm

€15 EUR / giờ
(8 Nhận xét)
4.7
shahinrahimi

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 Thêm

€12 EUR / giờ
(20 Nhận xét)
4.2
avto35217

Hi,dear! I am quite interested in your project - 'Excel (VBA) salary tool (Contract proposals)'. :) I am a skillful software developer who has rich experience in this field. If you contact me, you and I will be happy. Thêm

€16 EUR / giờ
(12 Nhận xét)
4.2
albertpopov46

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 Thêm

€15 EUR / giờ
(12 Nhận xét)
4.2
SergeyKyiv

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 Thêm

€15 EUR / giờ
(10 Nhận xét)
4.4
greenguru2018

Hello How are you? I've read carefully your job description. I have more than five years experience in Development. Your satisfaction with the project is my top priority! If you give me a chance to work with you, the Thêm

€15 EUR / giờ
(11 Nhận xét)
4.0
MEGOWORK

Hi, I’m here to help you with your project I’ve excellent working skills, I can do complete your task in a professional manners, lets discuss more if you are interested, I will give you all information regarding your Thêm

€15 EUR / giờ
(7 Nhận xét)
3.6
Fabritech

Hello, I can help you with the web tool and assist launch it with the feature you needs to implement. I also support the web tool once it's launched. I have quoted a fixed cost and I will sure I can make your website Thêm

€12 EUR / giờ
(2 Nhận xét)
3.3
Excelologist

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, Thêm

€15 EUR / giờ
(2 Nhận xét)
2.5
rstrandmark

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 Thêm

€15 EUR / giờ
(2 Nhận xét)
2.2
aouniradhouene

Hi, Almost done, I didn't get some information from your PDF document. Watch this video: [login to view URL] I will finish the file when you explain to Thêm

€15 EUR / giờ
(2 Nhận xét)
2.4
sahumk2000

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 Thêm

€15 EUR / giờ
(4 Nhận xét)
2.6
thanhvinhphan

Hello, I propose a budget $300 for this tool, and pay through paypal, I will completed it over 5 days. Thanks anyway

€15 EUR / giờ
(3 Nhận xét)
2.0
nusystec

Dear Customer Greetings for the day!! Let me introduce as Agnesh Arya and i have 12 + years experience into PHP based development. Recently i am working for one PHP based web ERP ( for India mart) where we are cove Thêm

€12 EUR / giờ
(3 Nhận xét)
0.8
€16 EUR / giờ
(0 Nhận xét)
0.0
aptrise

Hi Just noticed your job description and understands your requirements very clearly. We are Pvt. Ltd. company and our development experts can manage this job easily. Technologies in which we are proficient are Java, PH Thêm

€14 EUR / giờ
(1 Nhận xét)
0.0
GKEvans

Hello, I have 15 year of excel macro experience including creating emails based on excel files in Outlook. I can work on this for you next week. It will take 10 hours at the most, probably less. If you are intereste Thêm

€15 EUR / giờ
(0 Nhận xét)
0.0