Computed Fields
Online Help > Computed Fields
Field |
Description |
Actual Cost (task field) |
The Actual Cost field shows costs incurred for work already performed by resources on their tasks, together with any other recorded costs associated with the task. |
ACWP (task field) |
The ACWP (actual cost of work performed) field shows costs incurred for work already done on a task, up to the project status date or today's date. |
BCWP (Earned Value or EV) (task field) |
The BCWP (budgeted cost of work performed) field contains the cumulative value of the task's, resource's, or assignments's percent complete multiplied by the timephased baseline costs. |
BCWS (Planned Value or PV) (task field) |
The BCWS (budgeted cost of work scheduled) field contains the cumulative timephased baseline costs up to the status date or today's date. |
Cost (task field) |
The Cost field shows the total scheduled or projected cost for a task, resource, or assignment, based on costs already incurred for work performed by resources assigned to the tasks, in addition to the costs planned for the remaining work. |
Cost Variance |
The Cost Variance assignment fields show the difference between the baseline cost and total cost for a task, resource, or assignment. The total cost is the current estimate of costs based on actual costs and remaining costs. |
CPI (task fields) |
The CPI (cost performance index) field shows the ratio of budgeted (or baseline) costs of work performed to actual costs of work performed, up to the project status date or today's date. |
Created (task field) |
The Created field contains the date and time when a task was added to the project. |
Critical (task field) |
The Critical field indicates whether a task or an assignment's task has any room in the schedule to slip, or if a task is on the critical path. |
CV (task field) |
The CV (earned value cost variance) field shows the difference between the projected cost and the actual cost required to achieve the current level of completion up to the status date or today's date. |
CV% (task field) |
The CV% (cost variance percent) field shows the ratio of cost variance (CV) to budgeted cost of work performed (BCWP), expressed as a percentage. |
Duration (task field) |
The Duration field shows the total span of active working time for a task. |
Duration Variance |
The Duration Variance field contains the difference between the baseline duration of a task and the total duration (current estimate) of a task. |
EAC (task fields) |
The EAC (estimate at completion) field shows the expected total cost of a task based on performance up to the status date. |
Early Finish (task field) |
The Early Finish field contains the earliest date that a task could possibly finish, based on early finish dates of predecessor and successor tasks, other constraints, and any leveling delay. |
Early Start (task field) |
The Early Start field contains the earliest date that a task could possibly begin, based on the early start dates of predecessor and successor tasks and other constraints. |
Finish (task field) |
The Finish field shows the date when a task is scheduled to be completed. |
Finish Variance |
The Finish Variance field contains the amount of time that represents the difference between the baseline finish date of a task or assignment and its current finish date. |
Fixed Cost (task field) |
The Fixed Cost field shows any nonresource task expense. |
Free Slack (task field) |
The Free Slack field contains the time that a task can be delayed without delaying any successor tasks. |
Hyperlink Href (task field) |
The Hyperlink Href field contains the combination, or concatenation, of the Hyperlink Address and Hyperlink SubAddress fields associated with a task, resource, or assignment. |
ID (task field) |
The ID field contains the identifier number that Project automatically assigns to each task or resource as you add them to the project. |
Indicators |
The Indicators field shows symbols that give you a heads-up about different aspects of each task or resource. |
Late Finish (task field) |
The Late Finish field contains the latest date that a task can finish without delaying the finish of the project. |
Late Start (task field) |
The Late Start field contains the latest date that a task can start without delaying the finish of the project. |
Number1-20 (task fields) |
The Number1 through Number20 fields store any numeric information that you want to include in your project that relate to tasks, resources, or assignments. |
Outline Number (task field) |
The Outline Number field contains the number that represents a task's position in the hierarchical outline structure. |
Overallocated (task field) |
The Overallocated field indicates whether a resource is assigned to more work on a specific task or all tasks than can be completed within normal working capacity. |
Percent (%) Complete (task field) |
The % Complete field contains the current status of a task, expressed as the percentage of the task's duration that has been completed. |
Percent (%) Work Complete (task field) |
The % Work Complete field contains the current status of a task, resource, or assignment, expressed as the percentage of work that has been completed. |
Placeholder (task field) |
Placeholder tasks are manually scheduled tasks that do not have enough information to be scheduled. When you enter a manually scheduled task without a valid start or finish date and without a valid duration, Microsoft Project designates the task as having a Placeholder task mode. |
Recurring (task field) |
The Recurring field indicates whether a task is part of a series of recurring tasks. |
Remaining Work (task field) |
The Remaining Work field shows the time, such as person-hours or days, still required to complete a task or set of tasks. |
Resume (task field) |
The Resume field shows the date that the remaining part of a task is scheduled to resume after you enter any progress, for example, % Complete, % Work Complete, Actual Work, Actual Duration, or Actual Start. |
Scheduled Duration (task field) |
The Scheduled Duration field shows the total span of active working time for a task as entered or as calculated by Microsoft Project based on start date, finish date, calendars, and other scheduling factors. |
Scheduled Finish (task field) |
The Scheduled Finish field indicates the date when work on a task is scheduled to be complete as calculated by Microsoft Project based on the start date, duration, dependencies, calendars, and other scheduling factors. |
Scheduled Start (task field) |
The Scheduled Start field indicates the date when work on a task is scheduled to begin as calculated by Microsoft Project, based on dependencies, constraints, calendars, and other scheduling factors. |
SPI (task field) |
The SPI (schedule performance index) field shows the ratio of the budgeted cost of work performed to the budgeted cost of work scheduled (BCWP/BCWS). |
Start fields |
The Start field shows the date when an assigned resource is scheduled to begin working on a task. |
Start Variance |
The Start Variance field contains the amount of time that represents the difference between a baseline start date of a task or assignment and its currently scheduled start date. |
Successors (task field) |
The Successors field lists the task ID numbers for the successor tasks to a task. |
Summary (task field) |
The Summary field indicates whether a task is a summary task. |
SV (task field) |
The SV (earned value schedule variance) field shows the difference in cost between the current progress and the baseline plan of a task, all assigned tasks of a resource, or for an assignment up to the status date or today's date. |
SV Percent (%) (task field) |
The SV% (schedule variance percent) field shows the ratio of schedule variance (SV) to budgeted cost of work scheduled (BCWS), expressed as a percentage. |
Total Slack (task field) |
The Total Slack field contains the amount of time a task's finish date can be delayed without delaying the project's finish date. |
TCPI (task field) |
The TCPI (to complete performance index) field shows the ratio of the work remaining to be done to funds remaining to be spent, as of the status date. |
Unique ID (task field) |
The Unique ID field contains the number that Project automatically designates whenever a new task, resource, or assignment is created in the current project. |
VAC (task field) |
The VAC field shows the variance at completion (VAC), which is the difference between the budgeted at completion (BAC) or baseline cost and estimated at completion (EAC) cost for a task, resource, or assignment on a task. |
WBS (task field) |
The WBS field contains work breakdown structure (WBS) codes. |
Work (task field) |
The Work field shows the total time scheduled on a task for all assigned resources, the total time to which a resource is scheduled on all assigned tasks, or the total amount of time scheduled for a resource on a task. |
Work Variance (task field) |
The Work Variance field contains the difference between baseline work of a task, resource, or assignment and the currently scheduled work. |
Cost (resource field) |
The Cost field shows the total scheduled or projected cost for a task, resource, or assignment, based on costs already incurred for work performed by resources assigned to the tasks, in addition to the costs planned for the remaining work. |
Group (resource field) |
The Group field contains the name of the group that a resource belongs to. |
ID (resource field) |
The ID field contains the identifier number that Project automatically assigns to each task or resource as you add them to the project. |
Initials (resource field) |
The Initials field shows the abbreviation for a resource name. |
Unique ID (resource field) |
The Unique ID field contains the number that Project automatically designates whenever a new task, resource, or assignment is created in the current project. |
Peak (resource field) |
The Peak field contains the maximum percentage or number of units for which a resource is assigned at any one time for tasks. |
Work (resource field) |
The Work field shows the total time scheduled on a task for all assigned resources, the total time to which a resource is scheduled on all assigned tasks, or the total amount of time scheduled for a resource on a task. |
Cost (assignment field) |
The Cost field shows the total scheduled or projected cost for a task, resource, or assignment, based on costs already incurred for work performed by resources assigned to the tasks, in addition to the costs planned for the remaining work. |
Finish (assignment field) |
The Finish field shows the date when an assigned resource is scheduled to complete work on a task. |
Overallocated (assignment field) |
The Overallocated field indicates whether a resource is assigned to more work on a specific task than can be done within the resource's normal working capacity. |
Remaining Cost (resource field) |
The Remaining Cost field shows the remaining scheduled expense that will be incurred in completing the remaining scheduled work. |
Remaining Work (resource field) |
The Remaining Work field shows the time, such as person-hours or days, still required to complete a task or set of tasks. |
Actual Cost (assignment field) |
The Actual Cost field shows costs incurred for work already performed by resources on their tasks together with any other recorded costs associated with the task. |
Actual Work (assignment field) |
The Actual Work field shows the amount of work that has already been done by resources assigned to tasks. The timephased versions of these fields show values distributed over time. |
Peak Units (assignment field) |
The Peak Units field contains the percentage or number of units to which a resource is assigned at any one time for tasks as distributed over time. |
Remaining Work (assignment field) |
The Remaining Work field shows the time, such as person-hours or days, still required to complete a task or set of tasks. |
Resource ID (assignment field) |
The Resource ID field contains the identifier number that Project assigns to each resource. |
Resume (assignment field) |
The Resume field shows the date that the remaining part of a task is scheduled to resume after you enter any progress, for example, % Complete, % Work Complete, Actual Work, Actual Duration, or Actual Start. |
Start (assignment field) |
The Start field shows the date when an assigned resource is scheduled to begin working on a task. |
Task ID (assignment field) |
The Task ID field contains the number that Project assigns to each task as you add it to the project. |
Stop (task field) |
The Stop field shows the date that represents the end of the actual portion of a task. |
Unique ID (assignment field) |
The Unique ID field contains the number that Project automatically designates whenever a new task, resource, or assignment is created in the current project. |
Units (assignment field) |
The Assignment Units fields show the percentage or number that represents the assigned resources' allocation to a task. |
Work (assignment field) |
The Work field shows the total time scheduled on a task for all assigned resources, the total time to which a resource is scheduled on all assigned tasks, or the total amount of time scheduled for a resource on a task. |
Work (assignment-timephased field) |
The Work field shows the total time scheduled on a task for all assigned resources, the total time to which a resource is scheduled on all assigned tasks, or the total amount of time scheduled for a resource on a task. |
