Hoping for some insight / assistance on an excel file we have that has become somewhat burdensome. The data in the file relates primarily to inspection schedules and their current or overdue status, there are several overdue status values which relate to the authorization required to continue operating. Each overdue status is based on a percentage of it inspection frequency (or time between inspections).
What I am trying to achieve is to predict the inspection status at six month intervals through the end of 2017. I can do this manually through a change in the target date in the selection dates tab, but that means I have to re-calculate all the formulas for each target date and lose the values from the previous target date.
My goal is to compare the target date status to the proposed inspection date and predict the status of an equipment without have to make changes to the existing formulas, of course that may not be possible but any help or direction would be much appreciated.
I have attached the file for your review
Thanks and Best Regards