Holiday/Training Tracker

В работе Опубликован 4 года (лет) назад Оплачивается при доставке
В работе Оплачивается при доставке

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.

Excel Ввод данных Обработка данных

ID проекта: #20217559

О проекте

38 заявок(-ки) Удаленный проект Последняя активность 4 года (лет) назад



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

$200 USD за 3 дней(-я)
(15 отзывов(-а))

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 Больше

$300 USD за 5 дней(-я)
(42 отзывов(-а))

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 Больше

$150 USD за 3 дней(-я)
(14 отзывов(-а))

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 Больше

$300 USD за 10 дней(-я)
(69 отзывов(-а))

Hello there, This is a default bid made. we'll discuss the price later in the chat after reading your project i can do this for you perfectly.I still have a few questions. please leave a message on my chat so we can di Больше

$335 USD за 3 дней(-я)
(7 отзывов(-а))

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 Больше

$200 USD за 7 дней(-я)
(10 отзывов(-а))

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 Больше

$400 USD за 10 дней(-я)
(9 отзывов(-а))

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

$100 USD за 7 дней(-я)
(0 отзывов(-а))

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

$300 USD за 7 дней(-я)
(0 отзывов(-а))

i will do dis work in 6 days

$500 USD за 6 дней(-я)
(0 отзывов(-а))

Junior web developer specializing in front-end development. Top-notch communication skills, powerful analytical abilities, and workhorse endurance.

$500 USD за 3 дней(-я)
(0 отзывов(-а))

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 Больше

$300 USD за 7 дней(-я)
(0 отзывов(-а))

I can help you

$222 USD за 10 дней(-я)
(0 отзывов(-а))

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

$300 USD за 7 дней(-я)
(0 отзывов(-а))

Saya baru lulus sarjana dan ingin mendapatkan penghasilan sendiri sambil mencari pengalaman bekerja. Saya yakin dan berusaha untuk membantu Anda bekerja. Relevant Skills and Experience Saya mampu menggunakan Excel dan Больше

$388 USD за 10 дней(-я)
(0 отзывов(-а))

i can do this task for you, within short period of time. you can further discuss me about this task

$157 USD за 5 дней(-я)
(0 отзывов(-а))

Yes sir Relevant Skills and Experience No I'm freshers

$333 USD за 10 дней(-я)
(0 отзывов(-а))

I commit to complete the project within the stipulated timelines and according to the guidelines mutually agreed upon

$333 USD за 10 дней(-я)
(0 отзывов(-а))

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 Больше

$166 USD за 5 дней(-я)
(0 отзывов(-а))

Data entry

$333 USD за 10 дней(-я)
(0 отзывов(-а))

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 Больше

$277 USD за 5 дней(-я)
(0 отзывов(-а))