Resource planning from date periods
Hi everyone, I have a problem which I'm really stuck on.
On about a dozen schedules, there are hundreds of rows, assigned to 'ID's' (ID1, ID2 or ID3) that have durations from 1 to 9 days.
I need to be able to predict resource capacity for those IDs, up to 6 months in advance, by week. In this example, the ID starts the task on 7 June and ends on 17 June, so there will be 4 days w/c 6 June, and 5 days w/c 13 June.
I have created a report, grouped and summarised, but that shows the whole 9 day period in Wk 23 (w/c 6 June), which won't be accurate for resourcing purposes, because it will suggest we need 2 IDs for Wk 23, but 0 for Wk 24, when in fact, we will need 1 ID for Wks 23-24.
Any suggestions would be most gratefully received.
Help Article Resources
Check out the Formula Handbook template!