calculated fields help

T

Tim Eitniear

hi,
I am trying to create a schedule templete of tests that need to be completed
when a change is made to the product. That part is easy enough, but the
difficult part for me is to change the number of units to be tested and have it
automatically update the duration of the tasks.

I was wondering if I could use a text field called "# test units" when a number
of units is entered into this field, it would calculate the following:

# test units * duration of 1 units = new duration.

I hope this is possible. Im also open to any other soultions that would
accomplish the same outcome.

tks

Tim
 
D

Dale Howard [MVP]

Tim --

There is no default method to accomplish what you wish to do. Instead, you
could use two custom fields containing the number of test units and the
Duration of one test unit, along with writing a macro to use these values in
calculating the Duration of each task. Hope this helps.

--
Dale A. Howard [MVP]
Enterprise Project Trainer/Consultant
Denver, Colorado
http://www.msprojectexperts.com
"We wrote the book on Project Server"
 
T

Tim Eitniear

I guess I don't. I see how I can utilize the custom fields, put the equation
editor will not allow be to change the duration, thus change my schedule.

Thansk


Tim
 
D

Dale Howard [MVP]

Tim --

You will have to write a macro to use the values in the custom fields. The
default Duration equation in Microsoft Projecct calculates the Duration
based on the Units and Work entered, or allows you to simply type a
Duration. The macro will use the two custom numbers, calculate the
Duration, and then type the Duration in the field. You can't do this
without writing a macro. Hope this helps.
 
T

Ted M.

Hi!
I'm trying to get a graphical indicator to show up comparing dates for slipped tasks to today's date. I don't want only if today is greater than Start, but want gradations, i.e, today is 5 days more than the start date (w/no Actual Start value - already done in the filter) would be red; 3 - 4 days to be yellow, etc.

Any suggestions?

also, any suggestions on how I can have MSP calculate and display today's date in m/d/yyyy format in a custom number field?

Thanks,
Ted
 
Top