MS Project 2003 Query

[Nitinn Gokhle]

Hi,

would like to know how to push your custom field value in the built-in field
of MS Project. e.g. % Complete = Number 1 (Number 1 is a calculated % field
using formula)

 

[Projectability]

Nitinn,

You should be able to include the built-in % complete field in custom Number
1 field as follows:

Tools>Customize>Fileds - select Number for task or Project, highlight Number
1 and in the Custom attributes section select the formula button. It will
display Number 1 = , in the dialogue box click the Insert Field button and
from the drop down list select Number and % complete is the first option in
the list. Select it and it will show as [% Complete] in the dialogue box.
Click the OK button. you might want to use the same calculation for Summary
rows. You can also elect to display the value as data or graphical
indicators.

--
Dominic Moss

Projectability - Helping People achieve more with Microsoft Project

Check the Downloads section on our Website for useful documents on both
Project Management and Microsoft Project

www.projectability.co.uk

Why not subscribe to our monthly newsletter for hints tips and views

http://visitor.constantcontact.com/manage/optin/ea?v=001WVdpo956d6lHqIISFtfgVw==

 

[Nitinn Gokhle]

Dominic,

I appreciate your help. But my requirement is the other way i.e. I want to
push my Custom field in % Complete and not % Complete in Custom Field.

Thanks
--
Nitinn Gokhle

Nitinn,

You should be able to include the built-in % complete field in custom Number
1 field as follows:

Tools>Customize>Fileds - select Number for task or Project, highlight Number
1 and in the Custom attributes section select the formula button. It will
display Number 1 = , in the dialogue box click the Insert Field button and
from the drop down list select Number and % complete is the first option in
the list. Select it and it will show as [% Complete] in the dialogue box.
Click the OK button. you might want to use the same calculation for Summary
rows. You can also elect to display the value as data or graphical
indicators.

--
Dominic Moss

Projectability - Helping People achieve more with Microsoft Project

Check the Downloads section on our Website for useful documents on both
Project Management and Microsoft Project

www.projectability.co.uk

Why not subscribe to our monthly newsletter for hints tips and views

http://visitor.constantcontact.com/manage/optin/ea?v=001WVdpo956d6lHqIISFtfgVw==

Hi,

would like to know how to push your custom field value in the built-in
field
of MS Project. e.g. % Complete = Number 1 (Number 1 is a calculated %
field
using formula)

 

[Rod Gill]

That can't be done I'm afraid except be a VBA macro.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

Dominic,

I appreciate your help. But my requirement is the other way i.e. I want to
push my Custom field in % Complete and not % Complete in Custom Field.

Thanks
--
Nitinn Gokhle

Nitinn,

You should be able to include the built-in % complete field in custom
Number
1 field as follows:

Tools>Customize>Fileds - select Number for task or Project, highlight
Number
1 and in the Custom attributes section select the formula button. It will
display Number 1 = , in the dialogue box click the Insert Field button
and
from the drop down list select Number and % complete is the first option
in
the list. Select it and it will show as [% Complete] in the dialogue
box.
Click the OK button. you might want to use the same calculation for
Summary
rows. You can also elect to display the value as data or graphical
indicators.

--
Dominic Moss

Projectability - Helping People achieve more with Microsoft Project

Check the Downloads section on our Website for useful documents on both
Project Management and Microsoft Project

www.projectability.co.uk

Why not subscribe to our monthly newsletter for hints tips and views

http://visitor.constantcontact.com/manage/optin/ea?v=001WVdpo956d6lHqIISFtfgVw==

Hi,

would like to know how to push your custom field value in the built-in
field
of MS Project. e.g. % Complete = Number 1 (Number 1 is a calculated %
field
using formula)

 

[Nitinn Gokhle]

Thanks Rod..I appreciate. I will try to do it using VBA macro.
--
Nitinn Gokhle

That can't be done I'm afraid except be a VBA macro.

--

Rod Gill
Microsoft MVP for Project

Author of the only book on Project VBA, see:
http://www.projectvbabook.com

Dominic,

I appreciate your help. But my requirement is the other way i.e. I want to
push my Custom field in % Complete and not % Complete in Custom Field.

Thanks
--
Nitinn Gokhle

Nitinn,

You should be able to include the built-in % complete field in custom
Number
1 field as follows:

Tools>Customize>Fileds - select Number for task or Project, highlight
Number
1 and in the Custom attributes section select the formula button. It will
display Number 1 = , in the dialogue box click the Insert Field button
and
from the drop down list select Number and % complete is the first option
in
the list. Select it and it will show as [% Complete] in the dialogue
box.
Click the OK button. you might want to use the same calculation for
Summary
rows. You can also elect to display the value as data or graphical
indicators.

--
Dominic Moss

Projectability - Helping People achieve more with Microsoft Project

Check the Downloads section on our Website for useful documents on both
Project Management and Microsoft Project

www.projectability.co.uk

Why not subscribe to our monthly newsletter for hints tips and views

http://visitor.constantcontact.com/manage/optin/ea?v=001WVdpo956d6lHqIISFtfgVw==





Hi,

would like to know how to push your custom field value in the built-in
field
of MS Project. e.g. % Complete = Number 1 (Number 1 is a calculated %
field
using formula)

 

[Nitinn Gokhle]

Trevor,

You are correct..but my requirement is - % Complete is based on the qty
delivered out of the Orig Qty reqd - which is calculated as qty delivered /
Orig qty reqd *100. I would like this to be shown on the Gantt chart.

In short my gantt chart would be based on the quantification and not the
duration.
--
Nitinn Gokhle

Even if it is possible (it's not), there is no need to attempt to use a
formula to feed data into the % Complete field because it is already a
calculated field.
Why not just input the actual duration in the actual duration field in the
tracking table?
% Complete will then be calculated for you from:
% Complete = actual duration/total duration
--
Trevor Rabey
0407213955
61 8 92727485
PERFECT PROJECT PLANNING
www.perfectproject.com.au

Dominic,

I appreciate your help. But my requirement is the other way i.e. I want to
push my Custom field in % Complete and not % Complete in Custom Field.

Thanks
--
Nitinn Gokhle

Nitinn,

You should be able to include the built-in % complete field in custom
Number
1 field as follows:

Tools>Customize>Fileds - select Number for task or Project, highlight
Number
1 and in the Custom attributes section select the formula button. It will
display Number 1 = , in the dialogue box click the Insert Field button
and
from the drop down list select Number and % complete is the first option
in
the list. Select it and it will show as [% Complete] in the dialogue
box.
Click the OK button. you might want to use the same calculation for
Summary
rows. You can also elect to display the value as data or graphical
indicators.

--
Dominic Moss

Projectability - Helping People achieve more with Microsoft Project

Check the Downloads section on our Website for useful documents on both
Project Management and Microsoft Project

www.projectability.co.uk

Why not subscribe to our monthly newsletter for hints tips and views

http://visitor.constantcontact.com/manage/optin/ea?v=001WVdpo956d6lHqIISFtfgVw==





Hi,

would like to know how to push your custom field value in the built-in
field
of MS Project. e.g. % Complete = Number 1 (Number 1 is a calculated %
field
using formula)

 

[Steve House]

Percent Complete is defined as a duration measure - 4 days into a 10 day
task it is 40% Complete, no matter how much work has been done or how much
deliverable has been created, period, end of story, as firm a law of nature
as 2+2=4.<grin> This isn't an arbitrary definition, it's part of the
fundamental concepts of critical path methodology. But you can have what
you want, just it's not called Percent Complete. Project has three measures
of progress towards completion: Percent Complete, Percent Work Complete, and
Physical % Complete. They're related concepts but each measures something
different. What you are describing is the Physical % Complete field which
is a measure of the amount of deliverable achieved compared to the amount of
deliverable required.

Since the Gantt chart is a plot of work along a time axis, having a Gantt
chart where the basic bar length is based on quantity produced makes no
sense and in fact would not be a Gantt chart at all. It may certainly be a
valid tool and one that would be of use in managing certain kinds of
projects, but it's not a Gantt chart. If that's what you need, why not use
the graphing tools in Excel to generate it - a classic bar chart seems like
just the ticket.

That's not to say you can't have your number and graphic appear in your
Gantt chart. The Tracking Gant normally shows the % Complete to the right
of the task bar. Use the Bar Styles to redefine the text so it shows
Physical % Complete instead. Then create a calculated date field that
multiplies the Duration by the Physical % Complete and adds it to the Start
date. You will have created an "effective worked to" date based on the
percentage of deliverable created. Change the "drawn to" field in the
definition of the progress bars to be the resulting computed date. Now the
length of the task bar itself will be the duration and the progress bar
superimposed on it will reflect the Physical % Complete in its length as
compared to the task bar itself. Just make sure that everyone looking at
the chart knows what it's showing because such a representation is extremely
non-standard and will be confusing without some documentation.
--
Steve House
MS Project Trainer & Consultant

Trevor,

You are correct..but my requirement is - % Complete is based on the qty
delivered out of the Orig Qty reqd - which is calculated as qty delivered
/
Orig qty reqd *100. I would like this to be shown on the Gantt chart.

In short my gantt chart would be based on the quantification and not the
duration.
--
Nitinn Gokhle

Even if it is possible (it's not), there is no need to attempt to use a
formula to feed data into the % Complete field because it is already a
calculated field.
Why not just input the actual duration in the actual duration field in
the
tracking table?
% Complete will then be calculated for you from:
% Complete = actual duration/total duration
--
Trevor Rabey
0407213955
61 8 92727485
PERFECT PROJECT PLANNING
www.perfectproject.com.au

Dominic,

I appreciate your help. But my requirement is the other way i.e. I want
to
push my Custom field in % Complete and not % Complete in Custom Field.

Thanks
--
Nitinn Gokhle


:

Nitinn,

You should be able to include the built-in % complete field in custom
Number
1 field as follows:

Tools>Customize>Fileds - select Number for task or Project, highlight
Number
1 and in the Custom attributes section select the formula button. It
will
display Number 1 = , in the dialogue box click the Insert Field button
and
from the drop down list select Number and % complete is the first
option
in
the list. Select it and it will show as [% Complete] in the dialogue
box.
Click the OK button. you might want to use the same calculation for
Summary
rows. You can also elect to display the value as data or graphical
indicators.

--
Dominic Moss

Projectability - Helping People achieve more with Microsoft Project

Check the Downloads section on our Website for useful documents on
both
Project Management and Microsoft Project

www.projectability.co.uk

Why not subscribe to our monthly newsletter for hints tips and views

http://visitor.constantcontact.com/manage/optin/ea?v=001WVdpo956d6lHqIISFtfgVw==





message
Hi,

would like to know how to push your custom field value in the
built-in
field
of MS Project. e.g. % Complete = Number 1 (Number 1 is a calculated
%
field
using formula)

 

[Jim Aksel [MVP]]

Then you want Physical%Complete. Go here: www.msprojectblog.com and click
on the Project Tips link. You will see some white papers on the subject to
help you understand the different type of %Complete and some forumulas to
help you. If you care to, send me some comments from the website, I just
revamped it.

Jim Aksel MVP

Trevor,

You are correct..but my requirement is - % Complete is based on the qty
delivered out of the Orig Qty reqd - which is calculated as qty delivered
/
Orig qty reqd *100. I would like this to be shown on the Gantt chart.

In short my gantt chart would be based on the quantification and not the
duration.
--
Nitinn Gokhle

Even if it is possible (it's not), there is no need to attempt to use a
formula to feed data into the % Complete field because it is already a
calculated field.
Why not just input the actual duration in the actual duration field in
the
tracking table?
% Complete will then be calculated for you from:
% Complete = actual duration/total duration
--
Trevor Rabey
0407213955
61 8 92727485
PERFECT PROJECT PLANNING
www.perfectproject.com.au

Dominic,

I appreciate your help. But my requirement is the other way i.e. I want
to
push my Custom field in % Complete and not % Complete in Custom Field.

Thanks
--
Nitinn Gokhle


:

Nitinn,

You should be able to include the built-in % complete field in custom
Number
1 field as follows:

Tools>Customize>Fileds - select Number for task or Project, highlight
Number
1 and in the Custom attributes section select the formula button. It
will
display Number 1 = , in the dialogue box click the Insert Field button
and
from the drop down list select Number and % complete is the first
option
in
the list. Select it and it will show as [% Complete] in the dialogue
box.
Click the OK button. you might want to use the same calculation for
Summary
rows. You can also elect to display the value as data or graphical
indicators.

--
Dominic Moss

Projectability - Helping People achieve more with Microsoft Project

Check the Downloads section on our Website for useful documents on
both
Project Management and Microsoft Project

www.projectability.co.uk

Why not subscribe to our monthly newsletter for hints tips and views

http://visitor.constantcontact.com/manage/optin/ea?v=001WVdpo956d6lHqIISFtfgVw==





message
Hi,

would like to know how to push your custom field value in the
built-in
field
of MS Project. e.g. % Complete = Number 1 (Number 1 is a calculated
%
field
using formula)