Calendar settings

Calendar Class

When Asprova searches for a working time pattern of a certain resource on a certain day, it scans the calendar table starting with the records with the biggest sort order values until it finds a record which matches the resource and date, and then uses that shift and resource quantity. The following explains this using an example.

ResourceDate or day of the weekSort orderShift codes 
*Mon-Fri1Day shift1
*2020/7/20;2020/8/13-2020/8/152Holiday2
MachinesMon3Morning;DayShift3
Squad1;Squad2;Squad3Mon-Fri10DayShift=104
Squad1Mon;Thu11DayShift=10;NightShift=55
Squad32020/7/20;2020/7/13-2020/8/24100[9:00-12:00]=10;[13:00-17:30]=96
*HOLS200Holiday7

(1) The resource code is specified as an asterisk ( * ) to mean "all resources". If the resource code were left blank, it would be interpreted that the record applies to no resource at all. The date can be specified as either a day of the week, or as a numerical date. Here a hyphen is used to express "Monday through Friday".

(1) As this record has the smallest sort order value, the "Daytime" shift specified here will be used for all Monday through Friday cases whose date and resource do not match any of the other records. If a resource/date combination fails to match even record (1), then a 24-hour non-working period is assumed.

(2) This record specifies the vacation days. You can also define a period by concatenating two dates with a hyphen. In this example, 7/20 and a period from 8/13 through 8/15 are specified as vacation days.

(3) "Machines" is a resource group code. Multiple resource codes can be specified as group codes, as well as by listing multiple codes separated by semicolons. If the semicolon notation is used with shift codes, the shift patterns are combined. Thus, since "Morning" stands for 6:00-9:00 and "Daytime" stands for 9:00-12:00;13:00-18:00, "Morning;Daytime" becomes 6:00-9:00;9:00-12:00;13:00-18:00.

(4) This is an example of how to specify a resource quantity for a shift. The notation is to follow the shift code with "=" and a real number. In this example, we are saying that Squad1, Squad2, and Squad3 each have 10 workers from Monday through Friday. Shifts with no description after “=” will be Resource qty 1.0.

(5) This is an example of combining multiple shifts with resource quantities defined. Since resource quantities are summed at the points where the shifts overlap, the result is that during 9:00-12:00;13:00-17:00 the resource quantity is 10.0, during 17:00-18:00 the resource quantity is 15.0, and during 18:00-23:00;1:00-4:00 the resource quantity is 5.0.

(6) This is an example of directly specifying a shift pattern without using a shift code (i.e. without registering the shift table.) By enclosing a pattern written in the same form as a shift pattern of a shift record using square brackets ([ ]), you can use the pattern in the same way as shift codes. You can also specify the resource quantity by writing "=" and real number after [ (shift pattern)].

(7) is an example that specifies a holiday in a holiday table. HOLS is a reserved word that references the holiday table settings.

The holiday table and resource table have a "country" property, and the setting of this property affects the way they are reflected to the calendar.
The following are examples.

Resource Table
Resource codeCountry
R1Japan
R2China
R3 

Holiday table
DatesCountryHoliday name
2018/2/10Not specifiedCompany founding anniversary
2018/2/11JapanNational Foundation Day
2018/2/16ChinaSpring Festival Eve

Calendar table
Resource codeDate or day of the weekShift codeSort order
*HOLSHoliday20
**Day shift10

In this case, the operation pattern will be as follows.
ResourceCountry2018/2/102018/2/112018/2/122018/2/132018/2/142018/2/152018/2/16
R1JapanHolidayHolidayDay shiftDay shiftDay shiftDay shiftDay shift
R2ChinaHolidayDay shiftDay shiftDay shiftDay shiftDay shiftHoliday
R3 HolidayDay shiftDay shiftDay shiftDay shiftDay shiftDay shift

 

Application to month is possible by setting the date as follows. ( After Ver.12.0.3 )

Resource codeSpecified date(s)Sorting orderShift codes 
*101Day shift8
*12-152Holiday9
*25-EOM3Morning;DayShift10

Setting the date value for the date specification as shown by 8 causes the shift to be applied to that date every month. In the above example, it is the 10th of each month.

As shown by 9, connecting date values with a hyphen indicates a range. Shifts can be applied to the applicable date range of each month. Shifts can be applied to the applicable date range of each month. In the above example, this is the 12th to the 15th of each month.

Using EOM means the end of the month, as shown by 10. In the above example, this is the 12th to the 15th of each month.


 

Sort order

The basic idea of the calendar table sort order is to assign small sort orders to ordinary settings and big sort orders to special case settings.


Resource Quantity

In each calendar object, you can specify the resource quantity. If you specify the resource quantity for a calendar, this value will be applied to the shift(s) that are specified in that calendar.

If you specify resource quantity for a shift, the actual resource quantity will be the value calculated by multiplication of the resource quantity by the shift's resource quantity. For example, if the resource quantity is 2 and resource quantity for the shift is 2, the actual resource quantity will be 4.

If no value is specified as the resource quantity, resource quantity is regarded as 1.


Resource group quantity (From Ver.13)

If you use the group assign option, you can assign operation groups to resource groups.
A resource group to which an operation group is assigned must have its resource type set to “operation group”.
In the case of a resource group whose resource type is “operation group”, the resource quantity can be set in “Resource group quantity” in the calendar table.

Here is an example in which the following settings are made in the resource table.

Resource
Resource codeResource groupResource type
A1A 
A2A 
A Operation group

Example 1
Resource codeSpecified date(s)Sorting orderShift codesResource QuantityResource group quantity
A*10All day31

A1, A2 resource quantity = 3
A resource quantity = 1
* The values displayed in green in the above table are the default values.


Example 2
Resource codeSpecified date(s)Sorting orderShift codesResource QuantityResource group quantity
A*10All day32

A1, A2 resource quantity = 3
A resource quantity = 2


Example 3
Resource codeSpecified date(s)Sorting orderShift codesResource QuantityResource group quantity
A*10All day12
A1;A2*20Day shift31

A1, A2 shift = day shift, resource quantity = 3
A shift = all day, resource quantity = 2
* The values displayed in green in the above table are the default values.


References

Calendar settings on the resource Gantt chart and the load graph

Overwrite Calendar


HelpNo.:757000
© 2017 Asprova Corporation, All rights reserved.