Holiday/Training Tracker
$100-500 USD
Оплачивается при доставке
I am a manager on a large private yacht that deals with close to 20 crew members, and i am looking for someone to create a spreadsheet (preferably Excel) to efficiently manage employee holiday, training and bonus allowances.
Crew members are divided in 2 categories, department heads and regular crew.
Department heads are entitled to an annual bonus starting at 30% of annual wage, and capping out at 60% after 7 years of employment.
Regular crew members start at 20% and cap at 40% after 5 years.
Holiday and training allowances are the same for department heads and regular crew members.
The allowance is 4 weeks of paid holiday within the first year, and capping at 8 weeks in the 5th year.
Training is 1 week of training AFTER the 1st year, and capping at 4 weeks after the 4th year.
I would like the spreadsheet to backdate to 2008, and for it to be able to track both paid and unpaid leave.
I have attached an example of the existing spreadsheet, but by no means does it have to resemble this at all other than the information it will contain.
ID проекта: #20217559
О проекте
Поручен:
Hi, I can do this job efficiently, i have more than 10 years of experience in this field , Please give me a chance to work with you, Thanks
38 фрилансеров(-а) готовы выполнить эту работу в среднем за $305
I am postgraduate with more than 5 years of experience in financial modeling, leave management system, advanced excel based models and tools, VBA automation and data processing. I have successfully completed similar pr Больше
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I can help you in creating holiday calender. I have already completed several projects lik Больше
Hi, I am an excel VBA expert and have made this kind of tracker before. Please have a look at my review on that project. I see 3 tasks here independent of each other, I saw your excel file but it looks more of a logg Больше
Hello, It would be great to get on board and support the growth of your company. I am great at data entry, very accurate and also experienced in databases - I know how important it is to have clean, well structured d Больше
Hi, I am a data analyst with expertise in expertise in excel, VBA etc. I have worked on several projects for creation of dashboard, automation related tasks, data visualization etc kind of projects . using excel. I Больше
i am the most energetic and punctual girl and ill surely make my employer happy with my works and my deeds and ill surely make good relation with him or her as well
Here! I Am Ready To Work With I Have 4 year Experience In It I Am Done Lot Of Project So You Can Ask Me. Thank You :)
Junior web developer specializing in front-end development. Top-notch communication skills, powerful analytical abilities, and workhorse endurance.
Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have chec Больше
Hi hope you fine i am good in data entry and advance excel i can manage your data easily kindly give me chance for good work
i can do this task for you, within short period of time. you can further discuss me about this task
I commit to complete the project within the stipulated timelines and according to the guidelines mutually agreed upon
I have 18 years experience in it firm as a developer and project manager . Due to some personal reason have taken break. Want to work from home now for couple of months. Very good in excel n ms tools Relevant Skills a Больше
I can provide Excel solution for: Maintain Details of each employee Automated Tracking of Leave Balances Criteria based bonus payout Performance(as per above criteria) linked training time required. Relevant Skills an Больше
