Log In
Register
Home
New Member
Dashboards
Power Pivot
Xtreme Pivot Tables
Power BI
May 26, 2016
Offline
Hello,
Question I have is in regards to a maintenance service sheet I am building.
Currently the service frequencies entered (cells E11-E14) do not suppress.
What I would like to create but failed after many attempts is adjust the IF formula (cells K19 to T23) so that it looks at the service frequencies (cells E19-E22)and suppress them eg. The 500hr won't happen during the 1,000hr, 1,500hr and 2,000hr. The 1,000hr won't happen during the 2,000hr.
Any help on this would be appreciated.
October 5, 2010
Offline
Hi Branden,
What do you mean by 'suppress'?
In cells E11:E14, how do you want these values to 'suppress each other'?
If you can provide a workbook with some examples of the data entered as you would like it maybe we can figure out a solution.
Regards
Phil
New Member
Dashboards
Power Pivot
Xtreme Pivot Tables
Power BI
May 26, 2016
Offline
Hi Phil,
Currently the formula is just dividing the 6000hr machine hrs by the service interval.
e.g. In a 6000hr the 500hr service is happening 12 times, 1000hr 6 times, 1500 4 times, 2000 3 times.
What I would like to happen is the 500hr will only happen 3 times because it gets cancelled out at 1000, 1500 and 2000. The 1000hr only 3 times because it gets cancelled by the 2000hr.
I hope that makes sense sorry if I haven't explained it clearly.
I have attached a sheet on the example tab shows the result I am chasing.
Thanks
Branden
October 5, 2010
Offline
Hi Branden,
This seems overly complicated to me, but maybe I'm not understanding exactly what you are trying to do.
If services happen every 500hrs then just keep track of how many groups of 500hrs have passed.
You say that the 500hr service will only happen 3 times, but I don't really understand why hrs seem to reset at 2000hrs?
But anyway, if the machine has been in service for 3500 then divide that by 500 to get 7. You know that you're past the 2000hr limit/reset plus are on to the next 1500hr service?
Regards
Phil
1 Guest(s)
