Region | MSA | Next PM Date | Duration Frequency | Frequency Key |
South Atlantic | PA | 8/9/2013 | 12 | Every month |
South Atlantic | NJ | 4/9/2013 | 9 | Every 9 month |
South | GA | 11/28/2012 | 9 | Every 9 month |
Outsourced | WA | 5/24/2011 | 1 | Every Year |
West | CA | 9/2/2013 | 6 | Every 6 months |
Outsourced | ID | 10/1/2010 | 1 | Every Year |
<tbody>
</tbody>
- Create a pivot [or pivot-like] output that displays expected monthly PM workload by region and then MSA. It should show how many PM calls will occur in a given month for the next 24 months.
- Make certain your schedule isn’t just accounting for a given unit’s next PM date but also subsequent expected PMs.(the subsequent dates need to be extedned out for 5 years)
- Assuming all units’ PM schedules remain the same, include a feature that allows the user to change the starting month on the output and view the schedule from that point in time. Meaning if you have a cell that any date can be entered and the Output report will only show the PM schedule from that date on.