O'Reilly logo

Microsoft® Project 2007 Bible by Elaine Marmel

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Appendix C. Available Fields and Functions for Custom Field Formulas

IN THIS APPENDIX

  • Task fields

  • Resource fields

  • Functions available

This 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 Tor 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.

Table C.1. Task Fields Available for Custom Field Formulas

Category

Subcategory or Field

Field

Cost

Actual Cost

 
 

Actual Overtime Cost

 
 

ACWP

 
 

Baseline Cost

Baseline Cost, Baseline1 Cost - Baseline1 0 Cost, Baseline Budget Cost, Baseline 1 Budget Cost -Baseline10 Budget Cost

 

BCWP

 
 

BCWS

 
 

Budget Cost

 
 

Cost

 
 

Cost Variance

 
 

CPI

 
 

Custom Cost

Cost1 - Cost10

 

CV

 
 

CV%

 
 

EAC

 
 

Enterprise Custom Cost

Enterprise Cost1 -Enterprise Cost10

 

Enterprise Project Custom Cost

Enterprise Project Cost1 - Enterprise Project Cost10

 

Fixed Cost

 
 

Overtime Cost

 
 

Remaining Cost

 
 

Remaining Overtime Cost

 
 

SPI

 
 

SV

 
 

SV%

 
 

TCPI

 
 

VAC

 

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required