Need help on formulas to predict and summarize Maintenance schedule

[gustgio]

[TABLE="width: 500"]
<tbody>[TR]
[TD]Region[/TD]
[TD]MSA[/TD]
[TD]Next PM Date
[/TD]
[TD]Duration Frequency
[/TD]
[TD]Frequency Key
[/TD]
[/TR]
[TR]
[TD]South Atlantic[/TD]
[TD]PA[/TD]
[TD]8/9/2013
[/TD]
[TD]12
[/TD]
[TD]Every month
[/TD]
[/TR]
[TR]
[TD]South Atlantic[/TD]
[TD]NJ[/TD]
[TD]4/9/2013
[/TD]
[TD]9
[/TD]
[TD]Every 9 month
[/TD]
[/TR]
[TR]
[TD]South[/TD]
[TD]GA[/TD]
[TD]11/28/2012
[/TD]
[TD]9
[/TD]
[TD]Every 9 month
[/TD]
[/TR]
[TR]
[TD]Outsourced[/TD]
[TD]WA[/TD]
[TD]5/24/2011
[/TD]
[TD]1
[/TD]
[TD]Every Year
[/TD]
[/TR]
[TR]
[TD]West[/TD]
[TD]CA[/TD]
[TD]9/2/2013
[/TD]
[TD]6
[/TD]
[TD]Every 6 months
[/TD]
[/TR]
[TR]
[TD]Outsourced[/TD]
[TD]ID[/TD]
[TD]10/1/2010[/TD]
[TD]1[/TD]
[TD]Every Year[/TD]
[/TR]
</tbody>[/TABLE]

1. 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.
   1. 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)
2. 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.

 

[Special-K99]

Homework?

 

[gustgio]

No actually a work project and Im lost
IF someone can email me or PM an email address i can send the file with the expected output layout
Gio

 

[gustgio]

Bump pls help