$45.00 USD
NOTE, the Google Sheet version is included in the purchase and the link for that is in the Excel file download. Just go to the link and then hit File and Make a Copy for your editable version in G sheets.
In general, the flow works as follows:
1. The user enters the start date of the week and the start hour of the workday.
2. The user populates the availability of each employee over a 7-day span.
3. The user populates the schedule with actual start/end times for each employee for that week.
You will then have two summaries. The first is the main summary which will show how many people you have scheduled for each 30-minute time slot in the day for seven days. It will highlight red if you have any gaps of time with 0 people scheduled.
The second is a summary that looks at what you have scheduled people for and will highlight any employees name in red for each of the days if they have been scheduled for a time frame that is outside of their availability that has been entered.
The main data entry is done through drop-downs but you can also type the direct hour into the cells or start typing the hour and the dropdown will auto-populate with all options that start with that number in Google Sheets.
I have also included a version of this for Excel, which works in the same way.
You can easily go to print the schedule page off in google sheets or excel (see the first part of the video for details on this).
1. The user enters the start date of the week and the start hour of the workday.
2. The user populates the availability of each employee over a 7-day span.
3. The user populates the schedule with actual start/end times for each employee for that week.
You will then have two summaries. The first is the main summary which will show how many people you have scheduled for each 30-minute time slot in the day for seven days. It will highlight red if you have any gaps of time with 0 people scheduled.
The second is a summary that looks at what you have scheduled people for and will highlight any employees name in red for each of the days if they have been scheduled for a time frame that is outside of their availability that has been entered.
The main data entry is done through drop-downs but you can also type the direct hour into the cells or start typing the hour and the dropdown will auto-populate with all options that start with that number in Google Sheets.
I have also included a version of this for Excel, which works in the same way.
You can easily go to print the schedule page off in google sheets or excel (see the first part of the video for details on this).
More HR Management Spreadsheets:
- Payroll KPI
- HR Tool - Hiring/Firing
- Employee Data Tracker for HR
- Employee Training Tracker
- Employee Time Sheets
- Sales Team Hiring Plan + R&D / Customer Service
- Gantt Scheduling
- Project Management
- Layoff Financial Impact Analysis
- General Contractor KPI Dashboard
- KPI Dashboard with A Scoring System
- Payroll Calculator and Tracker - Budget vs. Actual
- Sales Person Commissions: Incentivization Structures
- To-Do List Tracker
- Consultant Tracker and Rankings
- Tracking Billable Hours
