Forum Discussion
Combining 2 duration columns to get one Finish date
Well, it will report that plumbing was starting 10 days later but that's Start Variance, not Duration Variance.
Sorry but you can't add something to the finish date without increasing the Duration field, unless you also change the Start field. Duration is the difference in working days between the start of a task and the finish of a task, unless there is a split, then task duration only tracks the scheduled working days where the span of the split is excluded. For example, in the screen shot below, framing for building one was going along swimmingly for the first three days, then over the weekend a storm blew in and delayed further framing for 3 days. That 3 days is entered into a custom Duration field (Duration1 renamed as "Delays") and a split is applied to the framing task. Note the task Duration field still shows the original 20 days but the split delay shifted the schedule to the right by those 3 long rainy wet days (yuck). If other delays occur, additional splits can be applied. The advantage here is the the delay is graphically very apparent but you could, as Dale suggested, make an entry in the Task Notes field why the split occurred.
So how do you do a split? It can be done manually via Task > Schedule group > Split task icon and then hovering your mouse over the start of the split and pulling it over the 3 days. Or, it could be done programmatically with VBA, enter the delay, run the macro and boom! there it is.
Is you head spinning yet?
John
It may seem like Dale and I are giving you a hard time about your approach and in a way perhaps we are. Our suggestions are based on a whole lot of years of using Project, (20+ for each of us), and fielding a array of questions and misunderstanding by users. Back in 2020 I helped a user, also in the construction industry, who asked for help with translating the dollars associated with their cost codes for each type of construction activity. We went round and round trying to get on common ground but eventually I wrote a set of procedures (VBA macros) for him that interfaced from Excel to Project and back to Excel, one of which was a customized Excel cash flow report for all their properties under construction.
Back to the topic at hand. I don't quite see where you 60 day delay is coming from unless your plan shows all the framing tasks as a single task. Here is an example of 3 buildings with framing followed by rough in plumbing. A baseline is set.
It's raining so the framers are delayed 5 days on building 1 so that 5 days is added to the duration and entered into the Duration field. Note the framing delay shows in the Duration Variance for framing but even though that shifted the overall schedule to the right, rough in plumbing has no delay.
On to building 2, the framers pick up some time so they finish 2 days early but the plumbers run into a material delay so they lose a day. Again, no framing delay on building 2, (actually they get an "attaboy" for finishing early), but there is a plumbing delay on building 2.
Now, what part of that doesn't work for you?
John
Ok so I was confused on Duration Variance(dont use that function very often.), I thought if you had a 5 day delay on framing and plumbing it would add those 2 durations together. Then it would report that plumbing was starting 10 days later than it should have.
So I guess I want a Duration Variance that translates into the finish date of a task, without adding days to my Duration column. Instead I would be adding days to a "Delay" tab. Then both of those columns combined would push the finish date back for that task.
- MSprojecthelpme,
Wait a minute, you never told me if your head was spinning.....I gotta know.
If you want to learn Project VBA, I recommend the Project VBA book by Rod Gill, a former Project MVP. You can find out more at:
http://www.project-systems.co.nz/project-vba-book
However, today only, I'll offer to write the macro for you but you'll have to contact me directly at the address below. I will ask some questions.
John
jmacprojataticlouddotdotcom
(remove obvious redundancies) - Well it wasn't easy but i got my answer haha!! Wish it would have been able to work but this split solution should be able to accomplish what I need. Do you have any resources on the VBAs that I can follow up on?
Thanks again for the help Well, it will report that plumbing was starting 10 days later but that's Start Variance, not Duration Variance.
Sorry but you can't add something to the finish date without increasing the Duration field, unless you also change the Start field. Duration is the difference in working days between the start of a task and the finish of a task, unless there is a split, then task duration only tracks the scheduled working days where the span of the split is excluded. For example, in the screen shot below, framing for building one was going along swimmingly for the first three days, then over the weekend a storm blew in and delayed further framing for 3 days. That 3 days is entered into a custom Duration field (Duration1 renamed as "Delays") and a split is applied to the framing task. Note the task Duration field still shows the original 20 days but the split delay shifted the schedule to the right by those 3 long rainy wet days (yuck). If other delays occur, additional splits can be applied. The advantage here is the the delay is graphically very apparent but you could, as Dale suggested, make an entry in the Task Notes field why the split occurred.
So how do you do a split? It can be done manually via Task > Schedule group > Split task icon and then hovering your mouse over the start of the split and pulling it over the 3 days. Or, it could be done programmatically with VBA, enter the delay, run the macro and boom! there it is.
Is you head spinning yet?
John