C
A P P E N D I X
Available Fields and Functions for Custom Field Formulas
✦
his appendix contains three tables that help you identify the fields and functions that you can use when creating formulas to include in custom fields. Table C-1 contains a list of all the Task fields that you can include in a formula. The fields are listed according to the submenu on which they appear when you click the Fields button in the Formula dialog box. Table C-2 contains the same information for Resource fields. In each of these tables, the first column contains a field category. The second column contains either fields within the category or a subcategory. If the second column contains a subcategory, then the fields appear in the third column. Table C-3 lists the functions that you can include in a formula, as well as a description of the function’s purpose.
✦
✦
Task Fields Resource Fields Functions Available
✦
T
✦
✦
✦
✦
2
Part VIII ✦ Appendixes
Table C-1 Task Fields Available for Custom Field Formulas Category
Subcategory or Field
Cost
Actual Cost
Field
Actual Overtime Cost ACWP Baseline Cost BCWP BCWS Cost Cost Rate Table Cost Variance Custom Costs
Cost1 – Cost10
CV Fixed Cost Fixed Cost Accrual Overtime Cost Remaining Cost Remaining Overtime Cost SV VAC Date
Actual Finish Actual Start Baseline Finish Baseline Start Constraint Date Created Custom Date
Date1 – Date10
Custom Finish
Finish1 – Finish10
Custom Start
Start1 – Start10
Deadline Early Finish
Appendix C ✦ Available Fields and Functions for Custom Field Formulas
Category
Subcategory or Field
Field
Early Start Finish Finish Variance Late Finish Late Start Preleveled Finish Preleveled SW Resume Start Start Variance Stop Duration
Actual Duration Baseline Duration Custom Duration
Duration1 – Duration10
Duration Duration Variance Finish Slack Free Slack Leveling Delay Remaining Duration Start Slack Total Slack Flag
Confirmed Critical Custom Flag
Flag1 – Flag20
Effort Driven Estimated External Task Group By Summary Hide Bar Continued
3
4
Part VIII ✦ Appendixes
Table C-1 (continued) Category
Subcategory or Field
Field
Ignore Resource Calendar Level Assignments Leveling Can Split Linked Fields Marked Milestone Overallocated Recurring Response Pending Rollup Subproject Read Only Summary TeamStatus Pending Update Needed ID/Code
Custom Outline Code
Outline Code1 – Outline Code10
ID Outline Number Predecessors Successors Unique ID Unique ID Predecessors Unique ID Successors WBS WBS of Predecessors WBS of Successors Number
% Complete Actual Overtime Work Custom Number Objects Outline Level Priority
Number1 – Number20
Appendix C ✦ Available Fields and Functions for Custom Field Formulas
Category
Subcategory or Field
Field
Project
Dates
Creation Date Current Date Default Finish Time Default Start Time Last Update Project Finish Project Start Status Date
Numbers
Minutes Per Day Minutes Per Week Resource Count Task Count
Text
Author Project Calendar Subject Title
Text
Constraint Type Contact Custom Text
Text1 – Text30
Hyperlink Hyperlink Address Hyperlink Href Hyperlink SubAddress Name Notes Project Resource Group Resource Initials Resource Names Resource Phonetics Continued
5
6
Part VIII ✦ Appendixes
Table C-1 (continued) Category
Subcategory or Field
Field
Resource Type Subproject File Task Calendar Type Work
% Work Complete Actual Work Baseline Work Overtime Work Regular Work Remaining Overtime Work Remaining Work Work Work Variance
Table C-2 Resource Fields Available for Custom Field Formulas Category
Subcategory or Field
Cost
Accrue At
Field
Actual Cost Actual Overtime Cost ACWP Baseline Cost BCWP BCWS Cost Cost Per Use Cost Rate Table Cost Variance Custom Cost CV
Cost1 – Cost10
Appendix C ✦ Available Fields and Functions for Custom Field Formulas
Category
Subcategory or Field
Field
Overtime Cost Overtime Rate Remaining Cost Remaining Overtime Cost Standard Rate SV VAC Date
Available From Available To Baseline Finish Baseline Start Custom Date
Date1 – Date10
Custom Duration
Duration1 – Duration10
Custom Finish
Finish1 – Finish10
Custom Start
Start1 – Start10
Start Finish Flag
Can Level Confirmed Custom Flag
Flag1 – Flag20
Linked Fields Overallocated Response Pending TeamStatus Pending Update Needed ID
Custom Outline Code
Outline Code1 – Outline Code10
ID Unique ID Number
Custom Number
Number1 – Number20
Max Units Objects Peak Continued
7
8
Part VIII ✦ Appendixes
Table C-2 (continued) Category
Subcategory or Field
Field
Project
Dates
Creation Date Current Date Default Finish Time Default Start Time Last Update Project Finish Project Start Status Date
Numbers
Minutes Per Day Minutes Per Week Resource Count Task Count
Text
Author Project Calendar Subject Title
Text
Base Calendar Code Custom Text E-mail Address Group GroupBy Summary Hyperlink Hyperlink Address Hyperlink Href Hyperlink SubAddress Initials Material Label Name Notes
Text1 – Text30
Appendix C ✦ Available Fields and Functions for Custom Field Formulas
Category
Subcategory or Field
Field
NTAccount Phonetics Project Workgroup Work
% Work Complete Actual Overtime Work Actual Work Baseline Work Overtime Work Custom Start
Start1 – Start10
Finish Start Regular Work Remaining Overtime Work Remaining Work Type Work Work Variance
Table C-3 Functions Available for Custom Field Formulas Function Category
Function
Description
Conversion
Asc(string)
Returns an Integer representing the character code corresponding to the first letter in a string.
CBool(expression)
Coerces an expression to a Boolean.
CByte(expression)
Coerces an expression to a Byte (0–255).
CCur(expression)
Coerces an expression to a Currency value. Continued
9
10
Part VIII ✦ Appendixes
Table C-3 (continued) Function Category
Function
Description
CDate(expression)
Coerces an expression to a Date.
CDbl(expression)
Coerces an expression to a Double.
CDec(expression)
Coerces an expression to a Decimal.
Chr(charcode)
Returns a string containing the character associated with the specified character code.
CInt(expression)
Coerces an expression to an Integer.
CLng(expression)
Coerces an expression to a Long.
CSng(expression)
Coerces an expression to a Single.
CStr(expression)
Coerces an expression to a String.
CVar(expression)
Coerces an expression to a Variant.
DateSerial(year,month day)
Returns a Variant (Date) for a specified year, month, and day.
DateValue(date)
Returns a Variant (Date).
Day(date)
Returns a Variant (Integer) specifying a whole number between 1 and 31, inclusive, representing the day of the month.
Hex(number)
Returns a String representing the hexadecimal value of a number.
Hour(time)
Returns a Variant (Integer) specifying a whole number between 0 and 23, inclusive, representing the hour of the day.
Minute(time)
Returns a Variant (Integer) specifying a whole number between 0 and 59, inclusive, representing the minute of the hour.
Month(date)
Returns a Variant (Integer) specifying a whole number between 1 and 12, inclusive, representing the month of the year.
Oct(number)
Returns a Variant (String) representing the octal value of a number.
Appendix C ✦ Available Fields and Functions for Custom Field Formulas
Function Category
Date/Time
Function
Description
ProjDurConv(expr, durunits)
Converts a numeric value to a duration value in the specified units.
Second(time)
Returns a Variant (Integer) specifying a whole number between 0 and 59, inclusive, representing the second of the minute.
Str(number)
Returns a Variant (String) representation of a number.
StrConv(string, conversion, LCID)
Returns a Variant (String) converted as specified.
TimeSerial(hour, minute, second)
Returns a Variant (Date) containing the time for a specific hour, minute, and second.
TimeValue(time)
Returns a Variant (Date) containing the time.
Val(string)
Returns the numbers contained in a string as a numeric value of appropriate type.
Weekday(date, firstdayofweek)
Returns a Variant (integer) containing a whole number representing the day of the week.
Year(date)
Returns a Variant (Integer) containing a whole number representing the year.
Cdate(expression)
Coerces an expression to a Date.
Date()
Returns a Variant (Date) containing the current system date.
DateAdd(interval, number, date)
Returns a Variant (Date) containing a date to which a specified time interval has been added.
DateDiff(interval, date1, date2, firstdayofweek, firstweekofyear)
Returns a Variant (Long) specifying the number of time intervals between two specified dates.
DatePart(interval, date, firstdayofweek, firstweekofyear)
Returns a Variant (Integer) containing the specified part of a given date. Continued
11
12
Part VIII ✦ Appendixes
Table C-3 (continued) Function Category
Function
Description
DateSerial(year, month, day)
Returns a Variant (Date) for a specified year, month, and day.
DateValue(date)
Returns a Variant (Date).
Day(date)
Returns a Variant (Integer) specifying a whole number between 1 and 31, inclusive, representing the day of the month.
Hour(time)
Returns a Variant (Integer) specifying a whole number between 0 and 23, inclusive, representing the hour of the day.
IsDate(expression)
Returns a Boolean value indicating whether an expression can be converted to a date.
Minute(time)
Returns a Variant (Integer) specifying a whole number between 0 and 59, inclusive, representing the minute of the hour.
Month(date)
Returns a Variant (Integer) specifying a whole number between 1 and 12, inclusive, representing the month of the year.
Now()
Returns a Variant (Date) specifying the current date and time according your computer system’s date and time.
ProjDateAdd(date, duration, calendar)
Adds a duration to a date to return a new date.
ProjDateDiff(date1, date2, calendar)
Returns the duration between two dates in minutes.
ProjDateSub(date, duration, calendar)
Returns the date that precedes another date by a specified duration.
ProjDurValue(duration)
Returns the number of minutes in a duration.
Second(time)
Returns a Variant (Integer) specifying a whole number between 0 and 59, inclusive, representing the second of the minute.
Appendix C ✦ Available Fields and Functions for Custom Field Formulas
Function Category
General
Math
Function
Description
Time()
Returns a Variant (Date) indicating the current system time.
Timer()
Returns a Single representing the number of seconds elapsed since midnight.
TimeSerial(hour, minute, second)
Returns a Variant (Date) containing the time for a specific hour, minute, and second.
TimeValue(time)
Returns a Variant (Date) containing the time.
Weekday(date, firstdayofweek)
Returns a Variant (Integer) containing a whole number representing the day of the week.
Year(date)
Returns a Variant (Integer) containing a whole number representing the year.
Choose(index, expr1, expr2, expr3)
Selects and returns a value from a list of arguments.
IIf(expr, truepart, falsepart)
Returns one of two parts, depending on the evaluation of an expression.
IsNumeric(expression)
Returns a Boolean value indicating whether an expression can be evaluated as a number.
IsNull(expression)
Returns a Boolean value that indicates whether an expression contains no valid data.
Switch(expr1, value1, expr2, value2, expr3, value3)
Evaluates a list of expressions and returns a Variant value or an expression associated with the first expression in the list that is True.
Abs(number)
Returns a value of the same type that is passed to it specifying the absolute value of a number.
Atn(number)
Returns a Double specifying the arctangent of a number.
Cos(number)
Returns a Double specifying the cosine of an angle. Continued
13
14
Part VIII ✦ Appendixes
Table C-3 (continued) Function Category
Microsoft Project
Function
Description
Exp(number)
Returns a Double specifying e (the base of natural logarithms) raised to a power.
Fix(number)
Returns the integer portion of a number. If the number is negative, Fix returns the first negative integer greater than or equal to number.
Int(number)
Returns the integer portion of a number. If the number is negative, Int returns the first negative integer less than or equal to the number.
Log(number)
Returns a Double specifying the natural logarithm of a number.
Rnd(number)
Returns a Single containing a random number.
Sgn(number)
Returns a Variant (Integer) indicating the sign of a number.
Sin(number)
Returns a Double specifying the sine of an angle.
Sqr(number)
Returns a Double specifying the square root of a number.
Tan(number)
Returns a Double specifying the tangent of an angle.
ProjDateAdd(date, duration, calendar)
Adds a duration to a date to return a new date.
ProjDateDiff(date1, date2, calendar)
Returns the duration between two dates in minutes.
ProjDateSub(date, duration, calendar)
Returns the date that precedes another date by a specified duration.
ProjDurConv(expr, durunits)
Converts a numeric value to a duration value in the specified units.
ProjDurValue(duration)
Returns the number of minutes in a duration.
Appendix C ✦ Available Fields and Functions for Custom Field Formulas
Function Category
Function
Description
Text
Asc(string)
Returns an Integer representing the character code corresponding to the first letter in a string.
Chr(charcode)
Returns a String containing the character associated with the specified character code.
Format(expression, format firstdayofweek, firstweekofyear)
Returns a Variant (String) containing an expression formatted according to instructions contained in a format expression.
InStr(start, string1, string2, compare)
Returns a Variant (Long) specifying the position of the first occurrence of one string within another.
LCase(string)
Returns a String that has been converted to lowercase.
Left(string, length)
Returns a Variant (String) containing a specified number of characters from the left side of a string.
Len(string | varname)
Returns a Long containing the number of characters in a string or the number of bytes required to store a variable.
LTrim(string)
Returns a Variant (String) containing a copy of a specified string without leading spaces.
Mid(string, start, length)
Returns a Variant (String) containing a specified number of characters from a string.
Right(string, length)
Returns a Variant (String) containing a specified number of characters from the right side of a string.
RTrim(string)
Returns a Variant (String) containing a copy of a specified string without trailing spaces.
Space(number)
Returns a Variant (String) consisting of the specified number of spaces. Continued
15
16
Part VIII ✦ Appendixes
Table C-3 (continued) Function Category
Function
Description
StrComp(string1, string2, compare)
Returns a Variant (Integer) indicating the result of a string comparison.
StrConv(string, conversion, LCID)
Returns a Variant (String) converted as specified.
String(number, character)
Returns a Variant (String) containing a repeating character string of the length specified.
Trim(string)
Returns a Variant (String) containing a copy of a specified string without leading and trailing spaces.
UCase(string)
Returns a Variant (String) containing the specified string, converted to uppercase.
✦
✦
✦