General Templates

You can find a list of the general templates below, which can be added using the report finder. It can be opened in the navigation menu: “Reports” > “Reports”.

Tip

Using dataviews, you can request a lot of information from Yesplan yourself:

Events per Day§

You can use the templates below to create documents that contain information about events, grouped by day.

Day Program§

A list containing all events in the selected period, grouped by day, with the option of displaying their schedules and booked resources.

Remark

If both the schedule and the booked resources are displayed, the resources appear below the schedule. Use the compact day program if you want to display the schedule and the booked resources next to each other.
The selected period may not exceed one month.

Parameter	Description
Title	The title that appears in the document.
Start Date	Choose the start date of the period to be covered by the document you wish to generate.
End Date	Choose the end date of the period to be covered by the document you wish to generate.
Query	Use the query language to construct a specific query.
Locations (*)	Filter events in the selected period by location.
Profiles (*)	Filter events in the selected period by profile.
Statuses (*)	Filter events in the selected period by status.
Labels (*)	Filter events in the selected period by event label.
Display Schedule	Determine whether or not event schedules appear.
Display Resources	Determine whether or not resource bookings of events appear.
Resource Group	Filter resource bookings by resource group. This is relevant only if you’re displaying resources.
Order	Determine the order of events on the same day, using their location.
Logo	The URL of the logo you wish to use in the document.

(*) Leave the parameter blank if you don’t wish to filter on this property.

Compact Day Program§

A list containing all events in the selected period, grouped by day, with the option of displaying their schedules and any booked resources next to each other.

Remark

If both the schedule and the booked resources are displayed, the resources appear next to the schedule. Use the regular day program if you want to display them below each other.
The selected period may not exceed one month.

Parameter	Description
Title	The title that appears in the document.
Start Date	Choose the start date of the period to be covered by the document you wish to generate.
End Date	Choose the end date of the period to be covered by the document you wish to generate.
Query	Use the query language to construct a specific query.
Locations (*)	Filter events in the selected period by location.
Profiles (*)	Filter events in the selected period by profile.
Statuses (*)	Filter events in the selected period by status.
Labels (*)	Filter events in the selected period by event labels.
Display Schedule	Determine whether or not event schedules appear.
Display Resources	Determine whether or not resource bookings of events appear.
Resource Group	Filter resource bookings by resource group. This is relevant only if you’re displaying resources.
Order	Determine the order of events on the same day, using their location.
Logo	The URL of the logo you wish to use in the document.

(*) Leave the parameter blank if you don’t wish to filter on this property.

Events per Day and per Location (PDF)§

A table containing events per day and per location for the selected period, which a maximum of eight locations.

Structure:

The rows are days.
The columns are locations.
The cells contain events, each with their own name, displayed start time and displayed end time.

Remark

If you select more than eight locations, only the first eight will actually appear.

Parameter	Description
Title	The title that appears in the document.
Start Date	Choose the start date of the period to be covered by the document you wish to generate.
End Date	Choose the end date of the period to be covered by the document you wish to generate.
Statuses (*)	Filter events in the selected period by status.
Profiles (*)	Filter events in the selected period by profile.
Locations	The locations that should appear in the document as columns. You can select only eight locations at maximum.
Canceled	Select statuses that you use for canceled events. Events with such a status will be crossed out with a horizontal line in the document.
Show Unavailabilities	Determine whether or not unavailabilities will be displayed in the document.

(*) Leave the parameter blank if you don’t wish to filter on this property.

Events per Day and per Location (Excel)§

A table containing events per day and per location for the selected period.

Structure:

The rows are days.
The columns are locations.
The cells contain events. Parameters can be used to display or hide any additional information.

Parameter	Description
Title	The title that appears in the document.
Start Date	Choose the start date of the period to be covered by the document you wish to generate.
End Date	Choose the end date of the period to be covered by the document you wish to generate.
Display Schedule Items	Determine whether or not the displayed start time and displayed end time will appear in the document.
Show Name	Determine whether or not the name of the event will appear in the document.
Show Group	Determine whether or not the name of the topmost event group of the event in question will appear in the document.
Show Profile	Determine whether or not the profile of the event will appear in the document.
Show Status	Determine whether or not the status of the event will appear in the document.
Statuses (*)	Filter events in the selected period by status.
Profiles (*)	Filter events in the selected period by profile.
Locations	The locations that should appear in the document as columns.
Canceled	Select statuses that you use for canceled events. Events with such a status will be crossed out with a horizontal line in the document.
Show Unavailabilities	Determine whether or not unavailabilities will be displayed in the document.

(*) Leave the parameter blank if you don’t wish to filter on this property.

Visual Schedules per Day§

A table containing events per day and per location for the selected period, in which bars are used to display their time schedules.

Structure:

The rows are events, grouped by day.
The first five columns show properties of the event. The other columns display the hours, divided into fifteen-minute periods.
The cells contain information about the event, and colors to display the time schedules.

Parameter	Description
Title	The title that appears in the document.
Start Date	Choose the start date of the period to be covered by the document you wish to generate.
End Date	Choose the end date of the period to be covered by the document you wish to generate.
Query	Use the query language to construct a specific query.
Locations (*)	Filter events in the selected period by location. The order of the locations also determines their order in the document.
Profiles (*)	Filter events in the selected period by profile.
Statuses (*)	Filter events in the selected period by status.

(*) Leave the parameter blank if you don’t wish to filter on this property.

Events per Location§

You can use the templates below to create documents that contain information about events, grouped by location.

Hall Occupancy§

A table containing the times of the events in the selected period, per location and per day.

Structure:

The rows are locations.
The columns are days, with two columns for the start time and end time per day.
The cells contain start times and end times.

Parameter	Description
Title	The title that appears in the document.
Start Date	Choose the start date of the period to be covered by the document you wish to generate.
End Date	Choose the end date of the period to be covered by the document you wish to generate.
Statuses (*)	Filter events in the selected period by status.
Profiles (*)	Filter events in the selected period by profile.
Locations	Select the locations that should appear in the document as rows.
Default Schedule	Determine which schedule items appear. “Yes”: The cells contain the first displayed start time and the last displayed end time for that particular day. “No”: The cells contain the first and the last schedule items for that particular day.

(*) Leave the parameter blank if you don’t wish to filter on this property.

Booked Events per Week (PDF)§

A table containing the events in the selected week (a maximum of eight days applies), per location and per day.

Structure:

The rows are locations.
The columns are days.
The cells contain events, each with their own name, their displayed start time and their displayed end time.

Remark

A week starts on the chosen start date and includes eight days.

Parameter	Description
Title	The title that appears in the document.
Days	The number of days that must appear in the document as columns. You can select only eight days at maximum.
Start Date	Choose the start date of the period to be covered by the document you wish to generate.
Locations	Select the locations that should appear in the document as rows.
Profiles (*)	Filter events in the selected period by profile.
Statuses (*)	Filter events in the selected period by status.
Canceled	Select statuses that you use for canceled events. Events with such a status will be crossed out with a horizontal line in the document.
Show Unavailabilities	Determine whether or not unavailabilities will be displayed in the document.

(*) Leave the parameter blank if you don’t wish to filter on this property.

Booked Events per Week (Excel)§

A table containing the events in the selected week (a maximum of eight days applies), per location and per day.

Structure:

The rows are locations.
The columns are days.
The cells contain events, each with their own name, their displayed start time and their displayed end time.

Remark

A week starts on the chosen start date and includes eight days.

Parameter	Description
Title	The title that appears in the document.
Days	The number of days that must appear in the document as columns. You can select only eight days at maximum.
Start Date	Choose the start date of the period to be covered by the document you wish to generate.
Locations	Select the locations that should appear in the document as rows.
Profiles (*)	Filter events in the selected period by profile.
Statuses (*)	Filter events in the selected period by status.
Canceled	Select statuses that you use for canceled events. Events with such a status will be crossed out with a horizontal line in the document.
Show Unavailabilities	Determine whether or not unavailabilities will be displayed in the document.

(*) Leave the parameter blank if you don’t wish to filter on this property.

Events per Year§

You can use the templates below to create documents that contain information about events, grouped by year.

Season Calendar§

A calendar for the selected year, grouped by month. No more than three events appear per day.

Structure:

The rows are days.
The columns are months.
The cells contain up to three events at maximum, plus their names and locations. Parameters can be used to display or hide any additional information.

Parameter	Description
Title	The title that appears in the document.
Start Date	Choose the start date of the period to be covered by the document you wish to generate. The generated document will start on the first day of the month of the selected start date.
Query	Use the query language to construct a specific query.
Profiles (*)	Filter events in the selected period by profile.
Statuses (*)	Filter events in the selected period by status.
Locations (*)	Filter events in the selected period by location.
Option	Select statuses that you use for options. Events with such a status will be displayed in italics in the document.
Canceled	Select statuses that you use for canceled events. Events with such a status will be crossed out with a horizontal line in this document.
Highlight	Select specific profiles. Events with such a profile have a pale yellow background and are displayed in bold.

(*) Leave the parameter blank if you don’t wish to filter on this property.

Teamplanner – Bookings§

You can use these templates only if you also use Teamplanner in Yesplan. Contact your Customer Success Manager if you want to know more about this module.

Roster per Day§

A table containing the times of the bookings, the shifts, the breaks and the unavailabilities in the selected period, per day and per human resource.

Structure:

The rows are bookings, grouped by day.
The columns are human resources.
The cells are the titles of bookings, shifts, breaks and unavailabilities, with additional information such as start time, end time, location etc.

Tip

You can use the parameters to adapt the generated document to your needs:

You can, for example, generate a compact roster by selecting “Yes” for the “Show Summary” parameter, and “No” for “Show Booking”, “Show Shift”, “Show Breaks” and “Show Unavailabilities”. In that case, you’ll receive a summary per day showing only the start time, the last end time, and the number of hours to be worked.
You can obtain a summary of planned human resources and their absences by selecting “Yes” for “Show Unavailabilities” and “Show Only Planned Hours”, and “No” for the other parameters.

Parameter	Description
Title	The title that appears in the document.
Start Date	Choose the start date of the period to be covered by the document you wish to generate.
End Date	Choose the end date of the period to be covered by the document you wish to generate.
Human Resources (*)	Select the human resources that should appear in the document as columns.
Teams (*)	Select the teams of which the human resources should appear in the document as columns.
Show Summary	Determine whether or not the bookings for that day will be summarized in one line showing the first start time, the last end time, and the total hours to be worked.
Show Booking	Determine whether or not bookings will be displayed in the document.
Show Shift	Determine whether or not shifts will be displayed in the document.
Shift	Enter the name used for a shift in the document. If this parameter is empty, “Shift” is used.
Show Breaks	Determine whether or not breaks will be displayed in the document.
Break	Enter the name used for a break in the document. If this parameter is empty, “Break” is used.
Show Unavailabilities	Determine whether or not unavailabilities will be displayed in the document.
Show Only Planned Hours	Determine whether or not only columns containing human resources with planned hours in the selected period should appear. Human resources without planned hours will, in that case, not be displayed in the document.

(*) Either “Human Resources” or “Teams” must be filled out. They can, however, both be entered. If so, they complement one another.

Bookings and Unavailabilities for a Week§

A table containing only bookings and unavailabilities in the selected week (eight days), with the role, start time and end time, per day and per human resource.

Structure:

The rows are bookings, grouped by human resource.
The columns are the days in the selected week, from Monday up to and including the following Monday.
The cells are the names of bookings, with their start times and end times.

Remark

This report shows only bookings and unavailabilities. Shifts and breaks aren’t displayed. See Roster for a Week for a similar template with more parameters.

Parameter	Description
Title	The title that appears in the document.
Week	Choose a day in the week for which you wish to generate a document.
Human Resources (*)	Select the human resources that should appear in the document as a group of rows.
Teams (*)	Select the teams of which the human resources should appear in the document as a group of rows.
Show Only Planned Hours	Determine whether or not only rows containing human resources with planned hours in the selected period should appear. Human resources without planned hours will, in that case, not be displayed in the document.

(*) Either “Human Resources” or “Teams” must be filled out. They can, however, both be entered. If so, they complement one another.

Roster for a Week§

A table containing bookings, shifts, breaks and unavailabilities in the selected week (eight days), with the role, start time and end time, per day and per human resource.

Structure:

The rows are bookings, grouped by human resource.
The columns are the days in the selected week, from Monday up to and including the following Monday.
The cells are the names of bookings, with the allocated role, the start time and the end time.

Remark

This report shows bookings, the allocated role, shifts, breaks and unavailabilities. See Bookings and Unavailabilities for a Week for a similar template with fewer parameters.

Parameter	Description
Title	The title that appears in the document.
Week	Choose a day in the week for which you wish to generate a document.
Human Resources (*)	Select the human resources that should appear in the document as a group of rows.
Teams (*)	Select the teams of which the human resources should appear in the document as a group of rows.
Show Booking	Determine whether or not bookings will be displayed in the document.
Show Shift	Determine whether or not shifts will be displayed in the document.
Shift	The name used for a shift in the document. If this parameter is empty, “Shift” is used.
Show Breaks	Determine whether or not breaks will be displayed in the document.
Break	Enter the name used for a break in the document. If this parameter is empty, “Break” is used.
Show Unavailabilities	Determine whether or not unavailabilities will be displayed in the document.
Show Only Planned Hours	Determine whether or not only columns containing human resources with planned hours in the selected period should appear. Human resources without planned hours will, in that case, not be displayed in the document.

(*) Either “Human Resources” or “Teams” must be filled out. They can, however, both be entered. If so, they complement one another.

Planned Times per Day§

A table containing the planned start time, the planned end time and the total number of planned working hours in the selected period, per day and per human resource.

Structure:

The rows are the times, grouped by date: the planned start time, the planned end time and the planned total working time.
The columns are human resources.
The cells are the values for the times.

Parameter	Description
Title	The title that appears in the document.
Start Date	Choose the start date of the period to be covered by the document you wish to generate.
End Date	Choose the end date of the period to be covered by the document you wish to generate.
Human Resources (*)	Select the human resources that should appear in the document as columns.
Teams (*)	Select the teams of which the human resources should appear in the document as columns.
Show Booking	Determine whether or not bookings will be displayed in the document.
Show Shift	Determine whether or not shifts will be displayed in the document.
Show Breaks	Determine whether or not breaks will be displayed in the document.
Show Unavailabilities	Determine whether or not unavailabilities will be displayed in the document.
Show Only Planned Hours	Determine whether or not only columns containing human resources with planned hours in the selected period should appear. Human resources without planned hours will, in that case, not be displayed in the document.

(*) Either “Human Resources” or “Teams” must be filled out. They can, however, both be entered. If so, they complement one another.

Planned/Actual Times per Day, Grouped by Week§

A worksheet for each human resource for the selected period, with their bookings, contract, planned/actual start times and end times, grouped by week.

Structure:

The worksheets are human resources.
The rows are bookings, grouped by day.
The columns are properties of the bookings: the name, the contract, the planned times (the start time and end time), and the actual times (start time and end time).
The cells are the values for the bookings.

Parameter	Description
Title	The title that appears in the document.
Start Date	Choose the start date of the period to be covered by the document you wish to generate.
End Date	Choose the end date of the period to be covered by the document you wish to generate.
Human Resources (*)	Select the human resources that should appear in the document as worksheets.
Teams (*)	Select the teams of which the human resources should appear in the document as worksheets.
Show Booking	Determine whether or not bookings will be displayed in the document.
Show Shift	Determine whether or not shifts will be displayed in the document.
Shift	The name used for a shift in the document. If this parameter is empty, “Shift” is used.
Show Breaks	Determine whether or not breaks will be displayed in the document.
Break	The name used for a break in the document. If this parameter is empty, “Break” is used.
Show Unavailabilities	Determine whether or not unavailabilities will be displayed in the document.

(*) Either “Human Resources” or “Teams” must be filled out. They can, however, both be entered. If so, they complement one another.

Visual Bookings per Day§

A table containing human resources, grouped by day in the selected period, and their bookings, displayed as bars.

Structure:

The rows are human resources, grouped by day.
The first column contains the total number of planned hours. The other columns display the hours, divided into fifteen-minute periods.
The cells contain information about the booking (name, location, abbreviation of the location, and role), and colors to display the bookings.

Parameter	Description
Title	The title that appears in the document.
Start Date	Choose the start date of the period to be covered by the document you wish to generate.
End Date	Choose the end date of the period to be covered by the document you wish to generate.
Human Resources (*)	Select the human resources that should appear in the document as rows.
Teams (*)	Select the teams of which the human resources should appear in the document as rows.
Show Booking	Determine whether or not bookings will be displayed in the document.
Show Shift	Determine whether or not shifts will be displayed in the document.
Show Breaks	Determine whether or not breaks will be displayed in the document.
Show Unavailabilities	Determine whether or not unavailabilities will be displayed in the document.
Show Abbreviation of the Location	Show the abbreviation of the location in the bar for the booking.
Show Event Name	Show the event name in the bar for the booking.
Show the Role	Show the role of the human resource in the bar for the booking.
Show Location	Show the name of the location in the bar for the booking.

(*) Either “Human Resources” or “Teams” must be filled out. They can, however, both be entered. If so, they complement one another.

Teamplanner – Counters§

You can use these templates only if you also use Teamplanner in Yesplan. Contact your Customer Success Manager if you want to know more about this module.

Counters per Day, Grouped by Week§

A worksheet for each human resource for the selected period, with counters for shifts and breaks per day, grouped by week.

Structure:

The worksheets are human resources.
The rows are days, grouped by week, including a weekly total.
The columns are the various types of working hours: planned working times, actual working times, the difference between the two, overtime, planned duration of breaks and actual duration of breaks.
The cells are the values for the different working hours.

Parameter	Description
Title	The title that appears in the document.
Start Date	Choose the start date of the period to be covered by the document you wish to generate.
End Date	Choose the end date of the period to be covered by the document you wish to generate.
Human Resources (*)	Select the human resources that should appear in the document as worksheets.
Teams (*)	Select the teams of which the human resources should appear in the document as worksheets.
Show Only Planned Hours	Determine whether or not only columns containing human resources with planned hours in the selected period should appear. Human resources without planned hours will, in that case, not be displayed in the document.

(*) Either “Human Resources” or “Teams” must be filled out. They can, however, both be entered. If so, they complement one another.

Counters per Week, Month and Year§

A worksheet for each human resource for the selected period, with counters for shifts, overtime work and vacations in the selected period, with tables per week, month and year.

Structure:

The worksheets are human resources.
Each worksheet contains tables for hours per week, month and year.
The rows in these tables are weeks, months and years.
The columns in these tables are the different types of working hours: shifts, overtime and vacations.
The cells are the values for the different types of working hours.

Parameter	Description
Title	The title that appears in the document.
Start Date	Choose the start date of the period to be covered by the document you wish to generate.
End Date	Choose the end date of the period to be covered by the document you wish to generate.
Human Resources (*)	Select the human resources that should appear in the document as worksheets.
Teams (*)	Select the teams of which the human resources should appear in the document as worksheets.
Show Only Planned Hours	Determine whether or not only columns containing human resources with planned hours in the selected period should appear. Human resources without planned hours will, in that case, not be displayed in the document.

(*) Either “Human Resources” or “Teams” must be filled out. They can, however, both be entered. If so, they complement one another.

Tasks§

This template can be used to create a document for tasks in a specific period.

List of Tasks§

A table with all tasks and fields with a due date in the selected period.

Structure:

The rows are tasks.
The columns are fields for tasks: the status, the due date, the start time of the task, the duration, the unit of duration, the event and the event group to which the task is linked, the name of the task, a description of the human resource allocated the task, that human resource’s team, the user who created the task and the cost price.
The cells are the values for the different fields.

Attention

Tasks without a due date won’t appear in the report.

Parameter	Description
Start Date	Choose the start date of the period to be covered by the document you wish to generate. Yesplan looks for tasks with a due date in the selected period.
End Date	Choose the end date of the period to be covered by the document you wish to generate. Yesplan looks for tasks with a due date in the selected period.

Teams§

This template can be used to create a document showing teams and their members.

Team Members§

A table showing all human resources in the selected teams, their roles and their contact details.

Structure:

The rows are human resources, grouped by team.
The columns are information about the human resources: the name of the team, the name of the human resource, their roles, their telephone numbers and their e-mail addresses.
The cells contain values for the different fields.

Parameter	Description
Teams	The teams for which you wish to generate a document.