Sliding interval data ahead or back

Use Slide Interval Data Ahead or Back to copy an existing chunk of data forward or backward into a time frame that has no data or that has invalid data. You can slide interval data for multiple channels simultaneously.

For example, a meter channel reports valid data for ten days. The meter then stops operating properly, so the intervals for the next ten days are missing. If both 10-day periods are considered typical days for the customer, you can slide the first ten days forward and use a copy of those readings for the missing ten days.

Note: Sliding and splitting do not apply when the interval data has a gap. In that case, use manual edit.

This data eventually goes through the validation process. IEE always saves data that is replaced in case restoration becomes necessary.

For additional information on the Additional Channels, Adjust Register Readings, and Review Changes windows that are part of this process, see Universal Editing & Estimation Procedures.

1. Go to Meter Data Management > Tools > Editing > Edit Interval Data.

   Note: As you move through the editing windows, click Cancel to cancel the process and return to the first window. Click Back to move to the previous window. Click Next to advance to the next window.

2. Enter a Service Point ID and Service Point Channel (SP Channel #) or use the Search utility to select the service point and channel. If you opened editing and estimation from the Diagnostics window in a queue or monitor, the service point and channel are already populated.

   For more information about searching, see Using the search utility.

   Note: Some edit modes allow you to make the same edits to other channels simultaneously. If the edit mode includes this feature, IEE presents an Additional Channels window later in the editing process. If you do not want to add any channels, skip the channel selection by clicking Next in the Additional Channels window.

   To add channels, click Add Channels to Edit when IEE presents the Additional Channels window. Use the Search utility to select a service point. The available service point channels appear in the Channels to Edit list. Select the checkbox of each channel to include in the edit process. Clear the checkbox to exclude the channel from the edit process. Repeat to add channels from another service point. Click Next to proceed with the edit mode.

3. Define the time period of the data that you are editing.

   • To define a custom time period, enter a Start Time and End Time.

   • To change the time period fields to Month and Year, select the Select Calendar Months checkbox.

   • To use the time period defined by a reading group, click Reading Groups. For more information about using reading groups, see Reading group selection.

4. Select the Time Zone of the data from the dropdown list.

5. Select Slide Interval Data Ahead or Back.

6. Click Next.

7. Select the data slide method:

   • Amount of Time Moves the data interval by a defined time period. Specify the hours and minutes in the edit field, and click the appropriate radio button to slide ahead or back in time.

   • # of Intervals. Moves the data interval by a whole number of intervals. Set the number of intervals in the edit field and click the appropriate radio button to slide ahead or back in time.

   • New Start Time. Enter the date directly, or click the pop-up button to bring up a calendar on which you can click on the date you want. Enter the time in the edit field.

   • New End Time. Enter the date directly, or click the pop-up button to bring up a calendar on which you can click on the date you want. Enter the time in the edit field.

8. Decide if the gap should be deleted, or if the previous version of data should be restored to the gap. Click the appropriate radio button.

9. Click Next.

   The Additional Channels user interface appears. Add channels (or ignore this option) and then click Next.

10. The Manual Edit on Screen user interface displays where you can make manual changes to the restored data.

11. Click Next.

12. (Optional) Some edit modes allow you to adjust register reads when you edit interval data if the interval channel is linked to a register channel. If the edit mode includes this feature, the editing process includes an Adjust Register Readings window.

    If you do not want to adjust register reads, skip register channel selection by clicking Next in the Adjust Register Readings window.

    To adjust register reads, select an adjustment mode in the Adjust Register Readings window then click Validate.

    Caution: When Correct End Read Values is selected:

    • All options in the Register Readings by Channel section are rendered unavailable.

    • The Use Calculated Read checkbox is, by default, selected. Clearing this checkbox does not cause the options in the Register Readings by Channel section to be made available.

    To make the Register Readings by Channel section options available again, or to change your selection, you must go back one screen.

    Caution: When Correct End Read Values is selected and:

    • The Use Calculated Read checkbox is selected with a new value specified in the End Reading field, then the Final Editing Comments screen reflects the Use Calculated Read selection as False.

    • When Correct End Read Values is selected and the Use Calculated Read checkbox is cleared, with a new value specified in the End Reading field, then the Final Editing Comments screen reflects the Use Calculated Read selection as False. The original end reading and the corrected end read are displayed.

      • Adjust Start Read Values. IEE calculates a new start read by subtracting the total edited interval usage from the stop read. Click in the cell and enter the new Stop Read, or use the existing stop read. You must click Validate for the adjustment to be made.

      • Adjust Stop Read Values. IEE calculates a new stop read by adding the total edited interval usage to the existing start read or to a start read. Click in the cell and enter the new Start Read, or use the existing start read. You must click Validate for the adjust to be made.

      • Correct End Read Values. IEE replaces the existing stop read with a new stop read that you provide, regardless of the edited interval usage that has accumulated for the period. Click in the cell and enter the new Stop Read.

13. Click Next. The Review Changes window shows the editing and estimation results on a graph with the original, unmodified data.

14. (Optional) To view the results in the context of the readings that immediately proceed or follow the edited readings, change the date range shown in the graph. In the Expand View Period pane, enter a new Start Time and End Time, and then click Go.

15. (Optional) To view the validation results without submitting the edited or estimated data for actual validation, click Preview Validation. To select a validation set other than the default set, clear the Use Default Validation checkbox and click Preview Validation. When prompted, select a different validation set and click OK.

    Note: Preview Validation only displays the validation results. It does not save the validation statuses. When the edited interval data is submitted, the validation runs again using the default validation set.

16. To save changes and remain in the Review Changes window to perform more changes, click Save. When you have completed all changes and are ready to advance to the final step of the Editing and Estimation process, click Save ALL. You cannot return to the Review Changes window after you click Save ALL. Save and Save ALL write the edited data and statuses to the IEE logs but do not save the new values to the IEE database.

17. In the Final Editing Comments window, review the editing and estimation summary in the Comments pane. This summary is read-only.

    Note: The Data Editing and Estimation window cannot be closed until the Final Editing Comments panel is completed. If you attempt to close the Data Editing and Estimation window, a dialog appears with the message "Please complete the Final Editing Comments panel to finish this edit." Click OK to close the dialog and complete the editing process.

18. Select an edit code from the Select Edit Code dropdown menu. The edit code describes the reason for the edits.

19. Click Finish. IEE saves the edits and the edit code to the IEE database.