Fix item utilization history with physical meter changes
When a physical meter is changed, the metric reading may change drastically but the LTD will change very little, if at all. Consider the following example:
Date
|
Metric Value
|
Current LTD Reading
|
New LTD Reading
|
Should be LTD Reading
|
|
96/12/01
|
1300
|
0
|
5000
|
5000
|
|
96/11/02
|
1200
|
0
|
4900
|
4900
|
Physical Meter Change
|
96/11/01
|
2000
|
0
|
4100
|
4900
|
|
96/10/05
|
1900
|
0
|
4000
|
4800
|
|
96/09/05
|
1800
|
0
|
3900
|
4700
|
|
The "New" column should what the fix routine will set the LTD to. The "Should be" column shows what we want the LTD to be. In this situation, you will have to:
-
Perform the Fix LTD Metric Readings program in update mode. The LTD readings from 96/11/01 will be changed to 4100, but that will still be 800 short because they were adjusted at the physical meter change.
-
Manually adjust the LTD reading for 96/11/01. We want to increase the LTD by 800 (4900 - 4100), so change the metric reading to 2800, then back to 2000 as described in Step 3. The LTD on 96/11/01 is not correct, but the LTDs from 96/11/02 are over by 800.
-
Manually adjust the LTD reading for 96/11/02. We want to decrease the LTD by 800, so change the metric reading to 400, then back to 1200 as described in Step 3. The LTDs on 96/11/01, 96/11/02, and on are now correct, but the LTDs prior to 96/11/01 are still incorrect.
-
Perform the Fix LTD Readings Steps 2-5 again, but use a beginning date of 96/11/01 so as not to "mess up" the LTD fixes just made.
This is one situation where you may be forced to run the update mode when there are errors on the audit trail. Consider the following example:
Date
|
Metric Value
|
Current LTD Reading
|
New LTD Reading
|
Should be LTD Reading
|
|
96/12/01
|
1300
|
0
|
5000
|
5000
|
|
96/11/02
|
1200
|
0
|
4900
|
4900
|
Physical meter change
|
96/11/01
|
8000
|
0
|
1900-
|
4900
|
|
|
Error: LTD has become negative. LTD will not be updated.
|
96/10/05
|
8900
|
0
|
1800-
|
4800
|
|
|
Error: LTD has become negative. LTD will not be updated.
|
96/09/05
|
8800
|
0
|
1700-
|
4700
|
|
|
Error: LTD has become negative. LTD will not be updated.
|
The "New" column shows what the fix routine will set the LTD to. The "Should be" column shows what we want the LTD to be. In this situation you will have to:
-
Perform the Fix LTD Metric Readings in update mode, even though there are errors. Only the LTD readings after 96/11/02 will be changed. LTDs for 96/11/01 and earlier will not be changed and will remain at zero because of the errors. We must manually set the LTD for 96/11/01.
-
Manually adjust the LTD reading for 96/11/01. We want to increase the LTD by 4900 (4900 - 0), so change the metric reading to 12,900, then back to 8000 as described in Step 3. The LTD on 96/11/01 is now correct, but the LTDs from 96/11/02 and on are over by 4900.
-
Manually adjust the LTD reading for 96/11/02. We want to decrease the LTD by 4900, so change the metric reading to -3700, then back to 1200 as described in Step 3. The LTDs on 96/11/01, 96/11/02, and on are now correct, but the LTDs prior to 96/11/01 are still incorrect. NOTE: If you cannot enter negative readings, first increase the metric to a large enough value (without affecting LTD), change the LTD using the method just described (NOTE: Numbers will be different.), then decrease the metric back to the original value (without affecting LTD).
-
Perform the Fix LTD Readings Steps 2-5 again, but use a beginning date of 96/11/01 so as not to "mess up" the LTD fixes you just made.