Overwrite Calendar

Overwrite Calendar Class

The working time or non-working time is overwritten for the working time built by the calendar table.
You can register working time and non-working time without providing shifts in the shift table, in a specific time span within 1 day or across multiple days.

For calendar tables and shift tables, it is a good idea to set up data to build standard working time, and to register exceptional shifts, overtime, maintenance breaks, and so on, with an overwrite calendar.

The overwrite calendar function is a function available from Ver. 14.


Setting Examples

 ResourceStart timeEnd timeTime seriesResource QuantityTime stamp
(1)R1;R22020/01/012020/01/04 8:00:002020/01/01 00:00:00;2020/01/04 08:00:0002019/12/20 00:00:00
(2)G12020/01/05 11:00:002020/01/05 14:00:002020/01/05 11:00:00;2020/01/05 14:00:002.52019/12/20 00:00:00
(3)R32020/01/05 11:00:00 AM2020/01/05 4:00:00 PM2020/01/05 11:00:00;2020/01/05 14:00:00;2020/01/05 16:00:002;12019/12/20 00:00:00
(4)R32020/01/05 11:00:002020/01/05 2:00:00 PM2020/01/05 11:00:00;2020/01/05 14:00:0002019/12/10 00:00:00

1: In resources R1 and R2, make 2020/1/1 00:00:00-2020/1/4 08:00:00 non-working time.

2: In the group members of resource group G1, make the resource quantity of 2020/1/5 11:00:00-2020/1/5 14:00:00 2.5.

3: In resource R3, make the resource quantity of 2020/1/5 11:00:00-2020/1/5 14:00:00 2, and make the resource quantity of 2020/1/5 14:00:00-2020/1/5 16:00:00 1.

4: In the same resource and same time zone, 3 which has a newer timestamp exists, so it is ignored.


Start time, end time, time series

The start time, end time, and time series are linked.
When you enter a time series, the first time is set to the start time, and the last time is set to the end time.
When you enter the start time, the first time in the time series is changed.
When you enter the end time, the last time in the time series is changed.

If the resource quantity is constant, you can specify the start time, the end time, or a time series.
If the resource quantity changes along the way, it is necessary to specify a time series.


Time stamp and sort order

When there are multiple overwrite calendars in the same time zone of the same resource, the one with the newest time stamp takes precedence.
If the time stamps are the same, the one with the highest sort order takes precedence. The time stamp is automatically set to the current system date and time when you select "Add Overwrite Calendar" or "Bring to Front" from the right-click menu on the Gantt chart.
The time stamp is automatically set to the current system date and time when you select "Add Overwrite Calendar" or "Bring to Front" from the right-click menu on the Gantt chart.

The sort order assumes usage such as setup and import when creating an overwrite calendar in an external database.


The time stamp is automatically set under the following conditions at the time of import.

 Import
Yes (differential)Yes (refresh)/(forced refresh)
Chosen objectsInternal objects with same values in primary keys
External objectsInternal objectsNoneExist
[Time stamp] was set in [Field mapping]Auto arrange 1No changeAuto arrange 1Auto arrange 1
[Time stamp] was not set in [Field mapping]Auto arrange 2No changeAuto arrange 2Auto arrange 2

  • Auto arrange 1
    If the time stamps of external objects are empty, the DBIO update times are set all at once. If the time stamps of external objects are not empty, the time stamps of external objects are set.
  • Auto arrange 2
    If the time stamps of internal objects are empty, the DBIO update times are set all at once.
  • Not changeable
    The time stamps of internal objects remain as is.

* An internal object is an object that exists on Asprova before importing.
* An external object is an object that has been imported from the outside.


References

Calendar settings on the resource Gantt chart and the load graph

Detailed explanation of properties


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