Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Excel Schedule

 

Key Information

 

Report Options

Filter

Mode. Denotes that you wish the data to be displayed by Schedule Group

Schedule Group. Allows you to select which Schedule Groups should be included in the report.

Display

Date Range. Allows you to determine the date the report begins and ends.

Employee Data. Allows you to denote that you want the employee's Name and/or Employee ID included in the report.

Scheduled Shifts. Allows you to denote whether you wish to see the time the shifts starts and how long the shift lasts or the Start Time and End Time of the shift. You can also choose to have the time shown in 24-hour format.

Unscheduled (Show as). Denotes that Unscheduled employees will be shown as "Off."

Miscellaneous. Allows you to denote whether you wish to see Employee Totals on the report.

 

Running the Report

To run the report:

  1. Choose Scheduling from the Reports menu.
  2. Click All Scheduling.
  3. Select Excel Schedule.
  4. Select the appropriate Schedule Group(s).
  5. Select Start Time / Shift Duration or Start Time / End Time from the drop-down menu.
  6. Select or de-select Show time in 24-hour format.
  7. Select or de-select Options.
  8. Click OK. The report is displayed.

...