Project 2003. Adding calculations into columns

[Terry G]

I wish to add an additional column for hours. I wish it to claculate like the
Works column but to operate seperatley

 

[Jan De Messemaeker]

Hi,

You can insert a duration custom field (duration1-10) and put a formula in
(Tools, customize, fields).
You could also use a number field or a text field but duration will came
with the suffix d or h automatically.
Hope this helps

 

[Terry G]

Thanks Jan for your reply, I have entered a number field but I do not
understand how to enter the formual's, I have tried Help to no avail. What I
am trtying to do is the hours from one division from another. Unfortunately I
aqm using an inherited program and it has not been recoursed so to track we
are just entering hours.

 

[Jan De Messemaeker]

Hi Terry,

To enter a formula:
Tools
Customize
Fields
Select the appropriate field
Click the word "Formula"

Hope this helps,

 

[Terry G]

Jan,

I'm sorry mate I have tried all that what I don't understand is how to make
the column act in the same manner as the work column, that is after I have
entered hours in to each line item I want them calculated into the headers
and subheaders giving me a total at the main header.

 

[JulieS]

Hi Terry,

It's likely that Jan is offline right now. I've been reading the posts
between you and Jan and I have to say, I'm not sure what you are trying
to accomplish.

Based upon your last post below, it sounds as if you want to be able to
manually enter data into one of the custom fields and then have the
custom field total the manual entries at summary task level? If, so,
that cannot be done directly.

Custom fields either allow manual entry OR have formulas, not both. You
could accomplish what I *think* you are looking for with two custom
fields. Add a custom number field (Number1 for example) and use that
field to capture the manual data you want to add. Then add a second
number field (Number2). In the Customize fields dialog box, under
Custom attributes, select formula and enter the following:

[Number1]

This will show the data from the Number1 field. Then to get the summary
tasks to sum the data from the subtasks, in the Customize Fields dialog
box under "Calculation for task and group summary rows" choose Rollup:
Sum

I hope this helps. Let us know how you get along.

Julie

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

 

[Terry G]

Thanyou Julie,

Yes you understood what I wanted. I will try what you have suggested and I
will let you know if I can work it. I'm sorry if I was not clear in my query
I will try harder next time. Again thank you for time and I appreciate yours
and Jan's advice.

Hi Terry,

It's likely that Jan is offline right now. I've been reading the posts
between you and Jan and I have to say, I'm not sure what you are trying
to accomplish.

Based upon your last post below, it sounds as if you want to be able to
manually enter data into one of the custom fields and then have the
custom field total the manual entries at summary task level? If, so,
that cannot be done directly.

Custom fields either allow manual entry OR have formulas, not both. You
could accomplish what I *think* you are looking for with two custom
fields. Add a custom number field (Number1 for example) and use that
field to capture the manual data you want to add. Then add a second
number field (Number2). In the Customize fields dialog box, under
Custom attributes, select formula and enter the following:

[Number1]

This will show the data from the Number1 field. Then to get the summary
tasks to sum the data from the subtasks, in the Customize Fields dialog
box under "Calculation for task and group summary rows" choose Rollup:
Sum

I hope this helps. Let us know how you get along.

Julie

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

Jan,

I'm sorry mate I have tried all that what I don't understand is how to
make
the column act in the same manner as the work column, that is after I
have
entered hours in to each line item I want them calculated into the
headers
and subheaders giving me a total at the main header.

 

[JulieS]

Great Terry. You're welcome for the assistance and thanks for the
feedback. And don't apologize for not being clearer, we'll work it out
eventually.
Do let us know how you get along.

Julie

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

Thanyou Julie,

Yes you understood what I wanted. I will try what you have suggested
and I
will let you know if I can work it. I'm sorry if I was not clear in my
query
I will try harder next time. Again thank you for time and I appreciate
yours
and Jan's advice.

Hi Terry,

It's likely that Jan is offline right now. I've been reading the
posts
between you and Jan and I have to say, I'm not sure what you are
trying
to accomplish.

Based upon your last post below, it sounds as if you want to be able
to
manually enter data into one of the custom fields and then have the
custom field total the manual entries at summary task level? If, so,
that cannot be done directly.

Custom fields either allow manual entry OR have formulas, not both.
You
could accomplish what I *think* you are looking for with two custom
fields. Add a custom number field (Number1 for example) and use that
field to capture the manual data you want to add. Then add a second
number field (Number2). In the Customize fields dialog box, under
Custom attributes, select formula and enter the following:

[Number1]

This will show the data from the Number1 field. Then to get the
summary
tasks to sum the data from the subtasks, in the Customize Fields
dialog
box under "Calculation for task and group summary rows" choose
Rollup:
Sum

I hope this helps. Let us know how you get along.

Julie

Visit http://project.mvps.org/ for the FAQs and additional
information
about Microsoft Project

Jan,

I'm sorry mate I have tried all that what I don't understand is how
to
make
the column act in the same manner as the work column, that is after
I
have
entered hours in to each line item I want them calculated into the
headers
and subheaders giving me a total at the main header.


:

Hi Terry,

To enter a formula:
Tools
Customize
Fields
Select the appropriate field
Click the word "Formula"

Hope this helps,

--
Jan De Messemaeker, Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
For FAQs: http://www.mvps.org/project/faqs.htm
"Terry G" <[email protected]> schreef in bericht
Thanks Jan for your reply, I have entered a number field but I
do
not
understand how to enter the formual's, I have tried Help to no
avail. What
I
am trtying to do is the hours from one division from another.
Unfortunately I
aqm using an inherited program and it has not been recoursed so
to
track
we
are just entering hours.

:

Hi,

You can insert a duration custom field (duration1-10) and put
a
formula
in
(Tools, customize, fields).
You could also use a number field or a text field but duration
will came
with the suffix d or h automatically.
Hope this helps

--
Jan De Messemaeker, Microsoft Project Most Valuable
Professional
http://users.online.be/prom-ade/
For FAQs: http://www.mvps.org/project/faqs.htm
"Terry G" <[email protected]> schreef in
bericht
I wish to add an additional column for hours. I wish it to
claculate
like
the
Works column but to operate seperatley

 

[Terry G]

Julie,

You are a saint it worked fine. I must thank you and Jan again. I think its
amazing that people like yourselves take time to help dummies like me. Again
thankyou for your patience and help, much appreciated.

Great Terry. You're welcome for the assistance and thanks for the
feedback. And don't apologize for not being clearer, we'll work it out
eventually.
Do let us know how you get along.

Julie

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

Thanyou Julie,

Yes you understood what I wanted. I will try what you have suggested
and I
will let you know if I can work it. I'm sorry if I was not clear in my
query
I will try harder next time. Again thank you for time and I appreciate
yours
and Jan's advice.

Hi Terry,

It's likely that Jan is offline right now. I've been reading the
posts
between you and Jan and I have to say, I'm not sure what you are
trying
to accomplish.

Based upon your last post below, it sounds as if you want to be able
to
manually enter data into one of the custom fields and then have the
custom field total the manual entries at summary task level? If, so,
that cannot be done directly.

Custom fields either allow manual entry OR have formulas, not both.
You
could accomplish what I *think* you are looking for with two custom
fields. Add a custom number field (Number1 for example) and use that
field to capture the manual data you want to add. Then add a second
number field (Number2). In the Customize fields dialog box, under
Custom attributes, select formula and enter the following:

[Number1]

This will show the data from the Number1 field. Then to get the
summary
tasks to sum the data from the subtasks, in the Customize Fields
dialog
box under "Calculation for task and group summary rows" choose
Rollup:
Sum

I hope this helps. Let us know how you get along.

Julie

Visit http://project.mvps.org/ for the FAQs and additional
information
about Microsoft Project

Jan,

I'm sorry mate I have tried all that what I don't understand is how
to
make
the column act in the same manner as the work column, that is after
I
have
entered hours in to each line item I want them calculated into the
headers
and subheaders giving me a total at the main header.


:

Hi Terry,

To enter a formula:
Tools
Customize
Fields
Select the appropriate field
Click the word "Formula"

Hope this helps,

--
Jan De Messemaeker, Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
For FAQs: http://www.mvps.org/project/faqs.htm
"Terry G" <[email protected]> schreef in bericht
Thanks Jan for your reply, I have entered a number field but I
do
not
understand how to enter the formual's, I have tried Help to no
avail. What
I
am trtying to do is the hours from one division from another.
Unfortunately I
aqm using an inherited program and it has not been recoursed so
to
track
we
are just entering hours.

:

Hi,

You can insert a duration custom field (duration1-10) and put
a
formula
in
(Tools, customize, fields).
You could also use a number field or a text field but duration
will came
with the suffix d or h automatically.
Hope this helps

--
Jan De Messemaeker, Microsoft Project Most Valuable
Professional
http://users.online.be/prom-ade/
For FAQs: http://www.mvps.org/project/faqs.htm
"Terry G" <[email protected]> schreef in
bericht
I wish to add an additional column for hours. I wish it to
claculate
like
the
Works column but to operate seperatley

 

[JulieS]

Hi Terry,

You are most welcome and thanks for the enthusiastic feedback Glad
to help and let us know if we can assist again.

Julie

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

Julie,

You are a saint it worked fine. I must thank you and Jan again. I
think its
amazing that people like yourselves take time to help dummies like me.
Again
thankyou for your patience and help, much appreciated.

Great Terry. You're welcome for the assistance and thanks for the
feedback. And don't apologize for not being clearer, we'll work it
out
eventually.
Do let us know how you get along.

Julie

Visit http://project.mvps.org/ for the FAQs and additional
information
about Microsoft Project

Thanyou Julie,

Yes you understood what I wanted. I will try what you have
suggested
and I
will let you know if I can work it. I'm sorry if I was not clear in
my
query
I will try harder next time. Again thank you for time and I
appreciate
yours
and Jan's advice.

:

Hi Terry,

It's likely that Jan is offline right now. I've been reading the
posts
between you and Jan and I have to say, I'm not sure what you are
trying
to accomplish.

Based upon your last post below, it sounds as if you want to be
able
to
manually enter data into one of the custom fields and then have
the
custom field total the manual entries at summary task level? If,
so,
that cannot be done directly.

Custom fields either allow manual entry OR have formulas, not
both.
You
could accomplish what I *think* you are looking for with two
custom
fields. Add a custom number field (Number1 for example) and use
that
field to capture the manual data you want to add. Then add a
second
number field (Number2). In the Customize fields dialog box, under
Custom attributes, select formula and enter the following:

[Number1]

This will show the data from the Number1 field. Then to get the
summary
tasks to sum the data from the subtasks, in the Customize Fields
dialog
box under "Calculation for task and group summary rows" choose
Rollup:
Sum

I hope this helps. Let us know how you get along.

Julie

Visit http://project.mvps.org/ for the FAQs and additional
information
about Microsoft Project

Jan,

I'm sorry mate I have tried all that what I don't understand is
how
to
make
the column act in the same manner as the work column, that is
after
I
have
entered hours in to each line item I want them calculated into
the
headers
and subheaders giving me a total at the main header.


:

Hi Terry,

To enter a formula:
Tools
Customize
Fields
Select the appropriate field
Click the word "Formula"

Hope this helps,

--
Jan De Messemaeker, Microsoft Project Most Valuable
Professional
http://users.online.be/prom-ade/
For FAQs: http://www.mvps.org/project/faqs.htm
"Terry G" <[email protected]> schreef in bericht
Thanks Jan for your reply, I have entered a number field but
I
do
not
understand how to enter the formual's, I have tried Help to
no
avail. What
I
am trtying to do is the hours from one division from another.
Unfortunately I
aqm using an inherited program and it has not been recoursed
so
to
track
we
are just entering hours.

:

Hi,

You can insert a duration custom field (duration1-10) and
put
a
formula
in
(Tools, customize, fields).
You could also use a number field or a text field but
duration
will came
with the suffix d or h automatically.
Hope this helps

--
Jan De Messemaeker, Microsoft Project Most Valuable
Professional
http://users.online.be/prom-ade/
For FAQs: http://www.mvps.org/project/faqs.htm
"Terry G" <[email protected]> schreef in
bericht
I wish to add an additional column for hours. I wish it
to
claculate
like
the
Works column but to operate seperatley