Classification of the work schedule
Document Structure
File Menu
Save as
Load from Github
Three Elements of Constraints
Staff
Editing staff names
Editing in Cells
Moving the Staff Cell
Drag & Drop Staff Cells
Applying the staff name
Group Definition
Describe the attributes of each staff member
Group Set
Shifts for each staff member
Day Set
Scheduling Period
StartDate
StartDate is base
Predefined Days
Sunday Definition
National Holidays
Month Characteristic Days
Day Aggregates
WeekEnds
ConsultationDay
Any Set of Day can be created by set operation
Shift Definition
Alias
Time, Counts in Shift Definition
Shift Aggregate
Not Operator sometimes makes it simpler
Shifts per Staff member
Using Shift Aggregates
Summary of three elements in constraints
Task Type Work Schedule
What is task?
We may have tasks within a shift
What is phase?
Basic relations shift task phase
Binding a Shift to phases
Binding a Shift to inconsecutive phases
Task
Task Aggregates
Tasks per Staff
NoTaskVar
Phase Object
Phase variable
Phase Vars Set
Constraints
Relationship to set definitions
Direction on Constraints
Row Constraints Summary
Descriptions required for row constraints
First/Last pattern daytype
Row Time Constraint
Row Integer Count Constraint
Row constraint Vectorized max/min
New page for phase constraint group
Row phase constraint
Group Management
Usage of Macro
Column Constraints
Column Time Constraint
Column Soft Staffs Max-Min
Column Task Constraint
Column Vectorized max-min
Entering Schedule
Undo
Redo
Multiple Entering
Locked state
Copy to Excel
A staff to appear at the top while I'm typing
Entering Task Schedule
Specifying Max/Min Tasks in Column Constraint
Task Max/Min in Schedule
Pair Prohibition Constraint
Pair Implication Constraint
Excel Operation
Excel Import
Set Excel imported file name
SchedulingPeriod
StaffProperty
StaffSchedule
ProcessRequirement
task_phase2_with_many_skills.xlsx imported
StaffTaskProperty
Excel Export Sample
Set Exported Excel file name
Export to Excel
Notes on Excel Export
Excel User Formatted Export
Notes on Excel User Formatted Export
Move to Next Month
When you can't see the columns of the window?
When the window is hidden?
Random Schedule Generation
Days Selection on Random Schedule Generation