Dates Forecasting Logic

  • Thread starter Thread starter Skien
  • Start date Start date
S

Skien

I'm trying to figure out if there's a way to do this in Access. Here's my
dilemma...
I have multiple start and finish dates, trying to figure out how many hours
resource A is planned to work each month based on the data given, and place
those plan hours in the correct month, starting from Jan thru Dec. Any ideas
on the logic to do this in Access is appreciated.

For example:
Data
Resourc Start Date Finish Date PlanHours

A 24-Dec-07 29-Feb-08 55
A 24-Dec-07 29-May-08 10
A 01-Jan-08 31-Dec-08 40
Output
Resource JanPlan FebPlan MarPlan AprPan etc.......
A 33 33 6 6
 
The hours value you placed in the months defeys logic. How do you arrive at
those numbers?
 
Here's my logic:
First Line: 2 working months: Jan = 27.5 hours, Feb = 27.5 hours
Second Line: 5 working months: Jan =2 hours, Feb=2 hours, Mar=2 hours,
April=2 hours, May=2 hours
Third Line: 12 working months: Jan=3.3 hours, Feb=3.3 hours, Mar=3.3 hours,
Apri=3.3, May=3.3, Jun=3.3, Jul=3.3, Aug=3.3, Sept =3.3, Oct=3.3, Nov=3.3,
Dec=3.3

Jan hours=27.5 hours + 2 hours + 3.3 hours =32.8 hours
Feb hours=27.5 hours + 2 hours + 3.3 hours =32.8 hours
Mar hours=2 hours + 3.3 hours =5.3 hours
Apr hours =2 hours + 3.3 hours = 5.3 hours

Sorry, my initial calculations wasn't very accurate.
Thanks.
 
Next question - what part of a month does not count as a month as your 24 Dec
start does not include Dec in output of plan spread?

Is it any part of month less than half on either end?
 
Back
Top