Holiday/Training Tracker

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.