Comprehensive Excel Template for Staff Allocation

I want to make an excel FILE template to make sure I have enough enough staff available cover the work duties The staff will provide services according to below Market sessions
Saudi
Days: Sunday to Thursday
Session: 11:00 AM – 3:30 PM
Daylight Saving Time: Not applicable
UAE
Days: Monday to Friday
Session: 10:00 AM – 2:00 PM
Daylight Saving Time: Not applicable
London
Days: Monday to Friday
Session:
Standard Time (October to March): 11:00 AM – 7:30 PM (AST)
Daylight Saving Time (March to October): 12:00 PM – 8:30 PM (AST)
US
Days: Monday to Friday
Session:
Standard Time (November to March): 5:30 PM – 12:00 AM (AST)
Daylight Saving Time (March to November): 4:30 PM – 11:00 PM (AST)

I want to make excel template to
-plan and track staff leave and balances
-Track staff number of working days and hours for the day, week, month and year
-1



a setting to list
Staff name
Staff type dealer or supervisor
Staff capabilities to cover the market

Markets settings
Minimum required staff for each market
Minimum required dealer for each market
Minimum required supervisor for each market

holidays
Official local holiday
Market holidays
Market hours

Staff max working hours
Staff max working days

Track Task assignments and equal assing unregular System test request on weekend
If staff is on leave he can't perform the test
Staff must be to working at least one day befor
And one day after

One master file receive staff leave date and
Each Staff have one leave roster file with a calendar to enter his leave

This not fully covering my requirements
Attached examples