TOTALFLOAT Calculation - Not tied to Critical Path?
I'm looking to rely more on calculated row float to inform my project teams how much flexibility we have on event completion dates relative to impacting critical path. I found the following function and baked this into our standard schedule template:
After working with this for a while, I noticed some odd behavior and decided to do some sandbox testing to see if I can figure out what's going on since I don't have much visibility into the mechanics of the TOTALFLOAT function.
In my test schedule, I start with a clean critical path of sequential tasks:
When I add nested tasks (Task 1 and Task 2), these automatically carry the logical predecessor / successor logic of the parent task (Phase 3), and show up on the critical path without manually tying direct predecessor / successor row logic. Good.
However, the float calculation doesn't follow. With both tasks 1 and 2 being 10d duration, they're equally critical path and should display 0 float. I can accept that the critical path check has to pick one and defaults to the earlier row entry, but I can't accept the float shown for task 2 (40d). If I extend the duration by 1 day, task 2 becomes critical and task 1 now has 41d float:
If I then manually translate the successor logic for Phase 4 to be rows 5, 6, & 7, now I get accurate float:
On complex schedules with hundreds of rows and multi-level nesting, I have to be able to rely on the hierarchy and both row and parent-level logical ties to inform float calculations, otherwise this becomes an administrative nightmare.
It would seem that the critical path function is using the right variables and effectively just applies a true / false flag for float = 0, so I'm struggling with why the TOTALFLOAT function isn't effectively the exact same operation just reporting out the numeric delta between forecast finish and the critical path successor.
Hoping there's some modification I can apply to the TOTALFLOAT formula I'm using to factor in proximity to critical path. Thanks in advance for any suggestions!
Help Article Resources
Check out the Formula Handbook template!