Hi there, I hope everybody is doing great.
I’ve been trying to crack this nut for some hours, but I’m not finding the right way to do it - so I rather ask for help.
the situation is simple - I have projects that have start and end dates , total requested hours and I want to be able to spread the requested hours over the months since the project start till it ends.
For example a project that has 100hrs requested over two months , I want to be able to put that into a visual but instead of seeing 100hrs on the starting date of the project , I want to be able to see 50 hrs on month 1 and 50 hrs on month 2. - if the project runs for 10 months and its a 1000 hrs project , then I want to be able to see 100 hrs x month over the 10 months of the project.
Unfortunately there’s no granularity on the data I’m getting and I don’t know how create that table .
I’m attaching a picture of the issue (not the solution but I hope the explanation makes it easy to follow). and adding a simple table with the minimum data I guess we need to create a solution (the model is way to big and sensitive to share more than this).
thanks in advance
spread requested hours over time.xlsx (21.2 KB)