Employee Shift details

Hi, I have a team the shift comprises of Morning shift (9 hrs), General shift (9 hrs), Night shift(9 hrs), Afternoon shift (9 hrs), Weekend shifts (12 hrs), comp off and Leave. I need an excel template with columns like Day, Date, Names and submit button in the end. I also need a button called Plan in the bottom. So if I click the Plan button, All the above mentioned shift should be given to the employees with 5 General shift, 5 Morning shift, 5 afternoon shift, 5 Night shifts, 4 weekend shifts and remain Leave and comp off.

Kindly help me in this.