This workbook investigates the classes and resources available in the training organization.
This workbook has the following worksheets:
Booked Resources per Class
Class Enrollments
Classes Without Trainer
Classes Without Venue
Overbooked Resources
Required Resources Missing
Resource Checklist
Resource Schedule by Activity
Suppliable Resources
Training Classes
This worksheet enables you to analyze the resources booked for specific training classes.
What are the resources booked for a specific class?
You need to specify values for the following parameters:
Class Start Date
Class End Date
Training center hierarchy
Top training center
This worksheet enables you to investigate the number of students who enroll in a class, and the number of students who successfully attend the class.
Who is enrolled on a specific class?
You need to specify values for the following parameters:
Class Start Date
Class End Date
Training center hierarchy
Top training center
This worksheet enables you to investigate the training classes that have no associated trainer.
Which training classes do not have a trainer booked?
You need to specify values for the following parameters:
Class from date
Class to date
This worksheet enables you to investigate the training classes that have no associated venue.
Which training classes do not have a training location assigned to them?
You need to specify values for the following parameters:
Class from date
Class to date
This worksheet enables you to analyze overbooked resources.
Which resources are booked more than once at the same time for different training classes?
You need to specify values for the following parameters:
Booked from
Booked to
Training center hierarchy
Top training center
This worksheet enables you to investigate the resources that are required but have not been booked for a training class.
Which essential resources are not booked for a particular training course?
What required resources are missing?
There are no parameters for this worksheet.
This worksheet displays the list of resources required to successfully run a training course.
What is the minimum resource required to run a specific training course?
You need to specify values for the following parameters:
Course name
This worksheet enables you to view the schedule for each training resource, to ensure that resources are not booked for more than one class at any one time.
At what level is a specific resource booked, for example, for the next 6 weeks?
What is the booking schedule for the available resources in the training organization?
You need to specify values for the following parameters:
Resource required from
Resource required to
Training center hierarchy
Top training center
This worksheet enables you to analyze the cost and availability of suppliable resources for your training class.
What are the resources available within a training organization in a given period of time?
You need to specify values for the following parameters:
Resource from date
Resource to date
This worksheet enables you to investigate the location, start date, and duration of specific training classes.
Which training classes are scheduled classes with a class status of normal?
How many students are enrolled on a specific class, and how many free seats remain for that class?
What are the actual, budgeted and standard costs for running specific training classes?
For a specific training course, which training classes are running in a given period of time?
You need to specify values for the following parameters:
Class start date
Class end date
Category
Training center hierarchy
Top training center
This worksheet uses the following calculation:
Class duration days
Calculates the number of days between the course start date and the course end date for the page item Class Duration.