Manual correction and recalculation of daily report data

<< Click to Display Table of Contents >>

Manual > Monitoring system construction guide > Construction of main functions > Daily reports > Construction of daily report function >

Manual correction and recalculation of daily report data

overview

Aggregated data such as Daily/Monthly/Yearly Report can be manually corrected or reaggregated from the screen.

 

p_rep_0058

 

 

This section describes the following operations:

 

Manual correction of daily report data

Recalculation of daily report data

 

 

Manual correction of daily report data

Aggregated data such as Daily/Monthly/Yearly Report can be manually corrected from the screen.

 

To perform correction, click "Start Correction" from the Correction menu.

 

p_rep_0050

 

 

When you do this, a check mark will appear to the right of "Start editing" as shown below. This state is called edit mode.

 

p_rep_0051

 

 

To make corrections, in edit mode, double-click the cell you want to edit on the daily report screen.

 

For example, double-click the following cell:

 

p_rep_0052

 

The cursor will then appear and you will be able to edit the text.

 

p_rep_0053

 

Before editing, the average, maximum, and minimum values displayed at the bottom of the daily report screen are as follows:

 

p_rep_0054

 

 

Now edit the cell value. In this example, we have changed it to "7777".

 

p_rep_0055

 

To save the edits, click "Save Edits" from the Edit menu.

 

 

p_rep_0056

 

 

Once the modifications have been saved, the check mark next to "Start modification" in the menu will disappear and "Save modifications" in the menu will revert to being disabled.

 

p_rep_0060

 

 

If you look at the average, maximum, and minimum at the bottom of the screen, you will see the following changes. You can see that the average and maximum values have been recalculated to reflect the manual corrections made above.

 

p_rep_0057

 

 

Re-aggregation of daily report data

Aggregated data such as Daily/Monthly/Yearly Report can be reaggregated.

 

This operation is performed when you want to cancel manual corrections made on the screen and return to the original aggregated data, or when you have manually corrected an aggregate unit at a lower level and want to bring the corrections up to an aggregate unit at a higher level. For example, if you have manually corrected monthly report data and want the corrections to be reflected in the annual report, you need to re-aggregate the annual report for that year.

 

 

Below is the state after manual correction from "4958" to "7777".

 

p_rep_0055

 

 

The average, maximum, and minimum values at the bottom of the daily report screen are displayed as follows:

 

p_rep_0057

 

 

Now, recount the data. To recount the data, click "Recount" from the Modify menu.

 

p_rep_0059

 

Then, the value of the cell that had been manually corrected reverted to its previous state.

 

p_rep_0052

 

 

If you look at the average, maximum, and minimum at the bottom of the screen, you can see that they have returned to their pre-correction state.

 

p_rep_0054

 

 

hint

If you manually correct the daily report, you must recalculate the monthly report and then the annual report in order to reflect the corrections in the monthly and annual reports (make sure to recalculate the monthly report first, then the annual report). Similarly, if you manually correct the monthly report, you must recalculate the annual report.