Calculate the % that should be complete based on two dates and the projected completion

[preyesone]

Hi

I want to calculate the % a worker should be complete on a deliverable based on the projected completion % and the start and end date of the deliverable. I've attached a spreadsheet so demonstrate

Your help is GREATLY appreciated!

[jhren]

What's the difference between the % a worker should be complete ...and... the projected completion %. It seems to me they are equivalent to each other...???

As such, in your file I'd put =NETWORKDAYS(C2,NOW())/B2 in both E2 and G2 and format as %.

[preyesone]

the difference between the % a worker should be complete ...and... the projected completion % is the projected is my estimate of how much they should be complete based on the number of tasks and overall timeline vs a calculated projection

Thank you. I'll let you know if it works

Pam

[Ace_XL]

In F2
=MAX(0,NETWORKDAYS(TODAY(),D2))

In G2
=IF(E2="",MAX(0,1-F2/B2),E2)

Copy down. Is this what you're looking for?

[jhren]

the difference between the % a worker should be complete ...and... the projected completion % is the projected is my estimate of how much they should be complete based on the number of tasks and overall timeline vs a calculated projection

Thank you. I'll let you know if it works

Pam

Okay... then I guess the appropriate question is how do "Projected %..." and "Guestimated Completion" relate to each other arithmetically? You said "projected" is your estimate, so what is "Guestimated Completion" then? I guess the reason I'm asking is in the logic (or illogic ) my mind uses, "Guestimated Completion" would be what you estimate % complete should be... but that is what you are saying the "projected completion %" is...???

Ace is correct in that F2 should be calculated in NETWORKDAYS, and not "calendar days". Whichever heading the calculated % complete based on start and end dates falls under, its formula should be =MAX(0,1-F2/B2).

[preyesone]

Thank you both! I actually want to get rid of my guess and use the calculations...