Time Sheet , Salary and Bonuses

Dear L&G

I would like to create and excecell to track Total Salary monthly of Personnel

Case

Personnel : 100 people
Rotation Schedule : 42 on and 24 days off , 30 day on 30 days off
Travel : 100 dolar/ day
Monthly Salary has categories :
Total Salary each : Basic salary + Bonus ( daily = 50 dollars + high risk = 150 dollars ) + overtime 100 per day after exceed the days on ( based on date )

Please help to create some excell so that I can get monthly salary for each by clicking the date of on and date off and the travel date

I want to print in one page as monthly report = Name and salary of each and total for all

Apprecited

Find attached the data.

Final result want to have as in summary

Thanks

Agus