Preventive Maintenance Scheduler based on Meter with multiple Runtime Rules

Hello experts,

I have a rebuildable that need maintenance base on Meter with multiple Runtime Rules

Ex: Meter has initial reading = 0,

        initial reading date = 30-Mar-2017,

Rate (per day) = 1600

UOM = Kg

Number of readings = 999999

In Preventive Maintenance Scheduler, I setup:

- From           0 to 350000 -      Base Interval = 340000

- From 350000 to 650000 -      Base Interval = 290000

- From 650000 to 850000 -      Base Interval = 190000

- From 850000 to 1050000 -    Base Interval = 190000

So, when I run forecast WO, the system generated list WO as below:

   

Suggested Start Date WO	Days	Base interval = Days x Rate (per day)	Note
30/03/2017 0:00	0
28/10/2017 12:00	212.5	340000
29/05/2018 0:00	212.5	340000	Wrong! Value of Meter should be 290000
24/09/2018 18:00	118.75	190000

I have attached a file with screen shots and formula on Excel, please help me to solve this problem.