I have an asset maintenance system that schedules services and maintenance tasks for pieces of mobile plant and cranes.
Services appear on the schedule predicted by the utilisation of the asset, and each service is calculated on multiples of 500 and can be made obsolete by a higher level. For example:
500hr Service
1000hr Service
2000hr Service
Until they trigger and the higher level makes the lower one(s) obsolete, they are all simultaneously planned in the predictive calendar. So my issue is, I have a table with the planned services and I want to ignore the ones that are made obsolete by an existing record.
| Asset | Task | Replaced By |
1 | AVB1 | PM106 | PM108 |
2 | AVB1 | PM108 | PM109 |
3 | AVB1 | PM109 | |
4 | AVB2 | PM122 | PM126 |
5 | AVB2 | PM126 | PM128 |
6 | AVB3 | PM141 | |
I’ve tried several options and to think of ways around it but can’t see the wood for the trees now that I’m so deep. I’m sure someone far more intelligent than myself will see the answer straight away or know of a simple solution.