Formula

[MaryK]

Hi,
Is it possible for MS Project to create additional column (Total Duration)
that would perform a calculation:
Qty column * Duration (per Unit) in minutes column = Total Duration (per
Lot) in minutes

Example:
Qty Duration/Unit Duration/Lot

10 2.6m 26m
1 5m 5m

Presently I have to remember to manually calculate qty * duration time per
unit, so I can enter the duration per lot. Example:
Qty Duration
10 26m
1 5m

Your help will be greatly appreciated,
Mary

 

[JulieS]

Hi Mary,

I'm not sure I fully understand what you are trying to accomplish - but you
can assign material resources at a specific rate per time unit in the Task
Form (Choose Window>Split from the Gantt Chart to show the Task form at the
bottom of the view).

For example if I have a 5 day duration task and assign a material resource
at 1/m, the "work" (consumption) for the material is calculated at 2,400.
If I assign a material resource at 1/h, the "work" (consumption) for the
material is 8.

Is this what you were trying to accomplish?

Hope this helps. Let us know how you get along.

Julie

 

[JackD]

Yes it is possible to use a custom field and a formula for this.
If you are using the Number1 field for Qty and the Duration1 field for
Duration/Unit then using a Text field (Text1 for example) you can have the
value in Text1 be calculated using the formula:

[Number1]*[Duration1] & "m"

Duration1 always stores the values in units of minutes, so there is no
conversion factor necessary. The
& "m"
part simply appends an m onto the result.

Take a look at the article I wrote about using "Working with Custom Field
Formulas" here:
http://zo-d.com/blog/archives/project_management/microsoft_project/programming/index.html

 

[MaryK]

Thank you very much Jack,

Yes, that is what I need Jack. I followed your instructions but Text1 custom
field displays the formula not the result. Where do I enter the formula? Do
I enter the formula in the "entry bar"? I'm sorry but I never used the
formulas in MS Project. I use MS Project 97. ( I entered the formula in the
entry bar many different ways and nothing works). Please help! Thank your
very much Jack!

Yes it is possible to use a custom field and a formula for this.
If you are using the Number1 field for Qty and the Duration1 field for
Duration/Unit then using a Text field (Text1 for example) you can have the
value in Text1 be calculated using the formula:

[Number1]*[Duration1] & "m"

Duration1 always stores the values in units of minutes, so there is no
conversion factor necessary. The
& "m"
part simply appends an m onto the result.

Take a look at the article I wrote about using "Working with Custom Field
Formulas" here:
http://zo-d.com/blog/archives/project_management/microsoft_project/programming/index.html

--
-Jack ... For project information and macro examples visit
http://masamiki.com/project
or http://zo-d.com/blog/index.html
..

Hi,
Is it possible for MS Project to create additional column (Total Duration)
that would perform a calculation:
Qty column * Duration (per Unit) in minutes column = Total Duration (per
Lot) in minutes

Example:
Qty Duration/Unit Duration/Lot

10 2.6m 26m
1 5m 5m

Presently I have to remember to manually calculate qty * duration time per
unit, so I can enter the duration per lot. Example:
Qty Duration
10 26m
1 5m

Your help will be greatly appreciated,
Mary

 

[Jan De Messemaeker]

Hi Mary,

To the best of my knowledge there has never been a Project 97.
Anyway, neither Project 95 nor Project 98 had the possinbility to enter a
formula so it's perfectly logical you couldn't find the way...
In later versions you enter one through Tools, Options, Customize, Fields

And yes, a formula goes for all non-summary tasks at once, not for just one
cell.
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620

Thank you very much Jack,

Yes, that is what I need Jack. I followed your instructions but Text1 custom
field displays the formula not the result. Where do I enter the formula? Do
I enter the formula in the "entry bar"? I'm sorry but I never used the
formulas in MS Project. I use MS Project 97. ( I entered the formula in the
entry bar many different ways and nothing works). Please help! Thank your
very much Jack!

Yes it is possible to use a custom field and a formula for this.
If you are using the Number1 field for Qty and the Duration1 field for
Duration/Unit then using a Text field (Text1 for example) you can have the
value in Text1 be calculated using the formula:

[Number1]*[Duration1] & "m"

Duration1 always stores the values in units of minutes, so there is no
conversion factor necessary. The
& "m"
part simply appends an m onto the result.

Take a look at the article I wrote about using "Working with Custom Field
Formulas" here:

http://zo-d.com/blog/archives/project_management/microsoft_project/programmi
ng/index.html

--
-Jack ... For project information and macro examples visit
http://masamiki.com/project
or http://zo-d.com/blog/index.html
..

 

[MaryK]

JAN: Thank you very much ! I now have to update to a newer version of MS
Project. Mary K......

Hi Mary,

To the best of my knowledge there has never been a Project 97.
Anyway, neither Project 95 nor Project 98 had the possinbility to enter a
formula so it's perfectly logical you couldn't find the way...
In later versions you enter one through Tools, Options, Customize, Fields

And yes, a formula goes for all non-summary tasks at once, not for just one
cell.
HTH

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620

Thank you very much Jack,

Yes, that is what I need Jack. I followed your instructions but Text1 custom
field displays the formula not the result. Where do I enter the formula? Do
I enter the formula in the "entry bar"? I'm sorry but I never used the
formulas in MS Project. I use MS Project 97. ( I entered the formula in the
entry bar many different ways and nothing works). Please help! Thank your
very much Jack!

Yes it is possible to use a custom field and a formula for this.
If you are using the Number1 field for Qty and the Duration1 field for
Duration/Unit then using a Text field (Text1 for example) you can have the
value in Text1 be calculated using the formula:

[Number1]*[Duration1] & "m"

Duration1 always stores the values in units of minutes, so there is no
conversion factor necessary. The
& "m"
part simply appends an m onto the result.

Take a look at the article I wrote about using "Working with Custom Field
Formulas" here:

http://zo-d.com/blog/archives/project_management/microsoft_project/programmi
ng/index.html

--
-Jack ... For project information and macro examples visit
http://masamiki.com/project
or http://zo-d.com/blog/index.html
..
Hi,
Is it possible for MS Project to create additional column (Total Duration)
that would perform a calculation:
Qty column * Duration (per Unit) in minutes column = Total Duration (per
Lot) in minutes

Example:
Qty Duration/Unit Duration/Lot

10 2.6m 26m
1 5m 5m

Presently I have to remember to manually calculate qty * duration time per
unit, so I can enter the duration per lot. Example:
Qty Duration
10 26m
1 5m

Your help will be greatly appreciated,
Mary