Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
% Complete - 2 decimals
- Thread starter rbvcbr
- Start date
Why?
For each 0.01% you are referring to less than half-an-hour of work in the course of a week. Nobody I know can get estimates that accurate and that's what you're measuring against. I'm ecstatic if the estimate is within +/- 10% and you're trying to track to something 1000 times more accurate than that.
Display one of the Number fields (say Number1). Put this formula in the field:
([Actual Work]*100)/[Work]
Technically, %Complete works on elapsed duration but I've never understood why anyone would track a project against a calendar instead of against work (i.e. Deliverables) so I've given you a formula that tracks against "stuff".
For each 0.01% you are referring to less than half-an-hour of work in the course of a week. Nobody I know can get estimates that accurate and that's what you're measuring against. I'm ecstatic if the estimate is within +/- 10% and you're trying to track to something 1000 times more accurate than that.
Display one of the Number fields (say Number1). Put this formula in the field:
([Actual Work]*100)/[Work]
Technically, %Complete works on elapsed duration but I've never understood why anyone would track a project against a calendar instead of against work (i.e. Deliverables) so I've given you a formula that tracks against "stuff".
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question