Re: Custom fields and internal values

In the original question there was a check on finish date of >100000. I know
that this is comparing to "NA" but why is 100000 or 50000 that I saw in
another formula relating to NA?

It appears in what I read on the information below that this Finish date
must be represented in minutes and I see 480 minutes in the day when doing
comparisons.

Also, the previous information was helpful as I read through it.

Thanks

"JulieS" wrote:

Hello Bud,

You may find the Data Reference document helpful. For Project 2003
the file is PJDB.HTM and details how information is stored in the
project database. For earlier releases, I believe the file is called
PRJDB.HTM. The file is usually found in the install directory for
Project.

There are other alternatives as well.

You can always get help directly on a specific field by clicking the
hyperlink titled "Help on (field name)" that appears in the screen tip
if you hover your mouse over a field column heading. The field help
will tell whether the field is entered or calculated and if the field
is calculated based upon other fields, help will frequently show the
calculation.

For how data is stored you could insert some spare text or number
fields and set the value of the field equal to another field by using
a formula. For example, if I use the Text1 field and create a formula
that reads [Duration], I can see a 4 day duration task is shown as
1920. If I divide 1920 by 4 to get 480 it becomes a bit clearer that
what I am seeing is a duration shown in minutes. The definition of a
"day" is set by me to 8 hours (Tools > Options, Calendar tab) and
therefore there are 480 minutes in each day.

Fellow MVP, Jack Dahlgren also has several posts on his blog about
working with custom fields. See Jack's blog at
http://zo-d.com/blog/index.html .

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

Julie
Project MVP

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

"Bud" <Bud@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AE8A6C22-D84C-47EB-8FB0-A33FF9BF1F84@xxxxxxxxxxxxxxxx
Where does one find the internal values of how MS Project is storing
something. For instance I saw a formula IIf([Baseline
Finish]>100000,"W".
There are others....this is just but one example.

How did the person know to compare Baseline finish to 10000? What
does it
mean? How is MS Project storing this?

Finally where is there a list of fields and what/how MS Project is
storing
them so a proper compare can be made?

Thanks



.

Relevant Pages

  • Re: Custom fields and internal values
    ... You may find the Data Reference document helpful. ... calculation. ... that reads [Duration], I can see a 4 day duration task is shown as ... How is MS Project storing this? ...
    (microsoft.public.project)
  • Re: Setting that stops a Date from being fixed
    ... changed a duration before a task that was started - all the start dates ... It is done - just that I wanted the graph to show it inline with the other ... calculation rules I make up, ... End dates will recalculate as long as %complete is less than ...
    (microsoft.public.project)
  • Re: Need a simple formula to calculate EV and PV seperately
    ... calculation for purposes of basic Earned Value Management. ... Cost of Work Scheduled and associated derived metrics, ... Regardless of whether the user enters the % Complete or Actual Duration ... Complete for summary tasks, we can follow a similar method to establish ...
    (microsoft.public.project)
  • Re: Setting that stops a Date from being fixed
    ... calculation rules I make up, ... would systematically introduce Actual duration and remaining duration ... graph looks as I want it to. ... End dates will recalculate as long as %complete is less than ...
    (microsoft.public.project)
  • Re: Work vs Actual Work
    ... Jano, there's a setting on the Calculation page of the Tools, Options menu that says "Updating task status updates resource status" With that checkbox turned on entering an Actual Work value will enter an Actual Duration value and vice versa. ... "JanoV" wrote in message ... > thanks for your support, ...
    (microsoft.public.project)