% Complete Formula

[dingpud]

First off, there might be a better way to do this, but this is what I have. (forgive me, I have been self taught so far)

I have input 3 columns in Project: Actual Complete, Required, Actual % Complete. These column are for actual physical parts which come out of a machine. The Actual % Complete column does the math and gives me my percentage. I then copy that number over to the % Complete column which MS Project has as a default.
Is there a way to get the calculated value to automatically populate the % Complete column?
Is there a better way to do this? I show the % COmplete on the Ghantt chart which is very useful to the shop floor people.
Any suggestions?

Thanks
scott

 

[IRstuff]

%Complete = Actual Work/Work in MSP

TTFN

FAQ731-376

 

[dingpud]

Cool, that's useful. Is there anyway to turn off the units? (hrs.)

 

[IRstuff]

Not that I'm aware of.

TTFN

FAQ731-376

 

[MSPtrainer]

Percent complete is actually 2 types - percent work complete and percent duration complete. The default in the system is that when you update one, you update the other. These can be separated. Here is an article I wrote on this subject:

http://www.lehnertcs.com/pdfs/200812_ezine.pdf

More tips and tricks are on my website at

http://www.lehnertcs.com.