Available tables

Microsoft Project 2003 provides tables that enable you to show specific information about tasks, resources, and assignments in a sheet view.

ShowTask tables

ShowBaseline

ShowConstraint dates

ShowCost

ShowDelay

ShowEarned Value

ShowEntry

ShowHyperlink

ShowPA_Expected Case

ShowPA_Optimistic Case

ShowPA_PERT Entry

ShowPA_Pessimistic Case

ShowRollup Table

ShowSchedule

ShowSummary

ShowTracking

ShowUsage

ShowVariance

ShowWork

 Note   To save the new estimates to your project baseline, select the tasks you want, point to Tracking on the Tools menu, and then click Save Baseline. Under For, click Selected tasks.

Baseline (baseline plan: The original project plans [up to 11 per project] used to track progress on a project. The baseline plan is a snapshot of your schedule at the time that you save the baseline and includes information about tasks, resources, and assignments.) figures, whether they are durations, start dates (start date: The date when a task is scheduled to begin. This date is based on the duration, calendars, and constraints of predecessor and successor tasks. A task's start date is also based on its own calendars and constraints.), finish dates (finish date: The date that a task is scheduled to be completed. This date is based on the task's start date, duration, calendars, predecessor dates, task dependencies, and constraints.), work effort, or costs, are your initial assessments of what should happen, when, how long it will take, how much effort will be required, and how much it will cost. These baseline figures provide a means of comparison, allowing you to evaluate how you thought the project would progress (baseline) compared to how it is progressing (actual).
Description    The Baseline table (table: A set of columns that shows specific information about tasks, resources, and assignments in a sheet view.) displays estimates for task (task: An activity that has a beginning and an end. Project plans are made up of tasks.) dates, durations (duration: The total span of active working time that is required to complete a task. This is generally the amount of working time from the start to finish of a task, as defined by the project and resource calendar.), work (work: For tasks, the total labor required to complete a task. For assignments, the amount of work to which a resource is assigned. For resources, the total amount of work to which a resource is assigned for all tasks. Work is different from task duration.), and costs (cost: The total scheduled cost for a task, resource, or assignment, or for an entire project. This is sometimes referred to as the current cost. In Project, baseline costs are usually referred to as "budget.").
Views    The Baseline table can be applied to any of the task sheet views, including the Bar Rollup, Detail Gantt, Gantt Chart, Leveling Gantt, Milestone Date Rollup, Milestone Rollup, PA_Expected Gantt, PA_Optimistic Gantt, PA_PERT Entry Sheet, PA_Pessimistic Gantt, Task Entry, Task Sheet, Task Usage, and Tracking Gantt views.
Fields    The Baseline table contains the following fields: ID, Task Name, Baseline Dur. Baseline Start, Baseline Finish, Baseline Work, and Baseline Cost.
Best uses    Use the Baseline table to:
You can display additional fields (field: A location in a sheet, form, or chart that contains a specific kind of information about a task, resource, or assignment. For example, in a sheet, each column is a field. In a form, a field is a named box or a place in a column.) (columns) by inserting new columns into the view and remove currently displayed fields by hiding columns.
    Revise your initial estimates and then save the new estimates as your baseline.
    Set up or view your initial estimates for task dates, durations, work, and costs.
Description    The Constraint Dates table (table: A set of columns that shows specific information about tasks, resources, and assignments in a sheet view.) displays task (task: An activity that has a beginning and an end. Project plans are made up of tasks.)constraints (constraint: A restriction set on the start or finish date of a task. You can specify that a task must start on or finish no later than a particular date. Constraints can be flexible [not tied to a specific date] or inflexible [tied to a specific date].), including constraint type and constraint date.
Views    The Constraint Dates table can be applied to any of the task sheet views, including the Bar Rollup, Detail Gantt, Gantt Chart, Leveling Gantt, Milestone Date Rollup, Milestone Rollup, PA_Expected Gantt, PA_Optimistic Gantt, PA_PERT Entry Sheet, PA_Pessimistic Gantt, Task Entry, Task Sheet, Task Usage, and Tracking Gantt views.
Fields    The Constraint Dates table contains the following fields: ID, Task Name, Duration, Constraint Type, and Constraint Date.
Best uses    Use the Constraint Dates table to:
Task constraints are common to most projects and do more to define a task than to limit it. For example, the As Soon As Possible constraint means the task should begin as soon as other task dependencies (task dependencies: A relationship between two linked tasks; linked by a dependency between their finish and start dates. There are four kinds of task dependencies: Finish-to-start [FS], Start-to-start [SS], Finish-to-finish [FF], and Start-to-finish [SF].) allow. However, some constraints do set limits. For example, a task to count election ballots cannot start prior to election day.
You can display additional fields (field: A location in a sheet, form, or chart that contains a specific kind of information about a task, resource, or assignment. For example, in a sheet, each column is a field. In a form, a field is a named box or a place in a column.) (columns) by inserting new columns into the view and remove currently displayed fields by hiding columns. If the constraint type does not require a specific date for a task, then the Constraint Date field for that task reads "NA" (not applicable).
Description    The Cost table (table: A set of columns that shows specific information about tasks, resources, and assignments in a sheet view.) for tasks displays cost information about your project tasks (including cost, planned cost, variance, actual cost, and remaining cost).
Fields    The Cost table contains the following fields: ID, Task Name, Fixed Cost, Fixed Cost Accrual, Total Cost, Baseline, Variance, Actual, and Remaining.
Views    The Cost table for tasks can be applied to the following task views: Bar Rollup, Detail Gantt, Gantt Chart, Leveling Gantt, Milestone Date Rollup, Milestone Rollup, PA_Expected Gantt, PA_Optimistic Gantt, PA_PERT Entry Sheet, PA_Pessimistic Gantt, Task Entry, Task Sheet, Task Usage, and Tracking Gantt.
You can display additional fields (field: A location in a sheet, form, or chart that contains a specific kind of information about a task, resource, or assignment. For example, in a sheet, each column is a field. In a form, a field is a named box or a place in a column.) (columns) by inserting new columns into the view and remove currently displayed fields by hiding columns.
Description    The Delay table (table: A set of columns that shows specific information about tasks, resources, and assignments in a sheet view.) shows information that helps you level resources, including leveling, delay, duration, scheduled start and finish dates, successors, and resource names.
Views    The Delay table can be applied to the task sheet views, including the Gantt Chart, Detail Gantt, Leveling Gantt, Tracking Gantt, Task Usage, Task Entry, and Task Sheet views.
Fields    The Delay table contains the following fields: ID, Indicators, Task Name, Leveling Delay, Duration, Start, Finish, Successors, and Resources.
One of the challenges in scheduling resources is avoiding overallocation (overallocation: The result of assigning more tasks to a resource than the resource can accomplish in the working time available.). The Delay table is designed to help you smooth out overallocations, a process called leveling (leveling: Resolving resource conflicts or overallocations by delaying or splitting certain tasks. When Project levels a resource, its selected assignments are distributed and rescheduled.). In short, the Delay table helps ensure that you have an accurate picture of how long it will take to complete your tasks given the resources that you have and the amount of time they have for a given task. The Delay table also shows the effects of leveling a task.
Typically when you level a task, you delay the task until the resource is available to work on it. When you have a task where the resource assigned to it is overallocated, and you level that task, the amount of time by which the task is delayed appears in the Leveling Delay field as "elapsed time." Elapsed time is the total amount of time that the time period could possibly be. For instance, in Project, a day typically refers to an 8-hour work day. But an elapsed day is 24 hours. Similarly, an elapsed week is not a 5-day work week consisting of 40 hours; it is a 7-day week consisting of 168 hours.
You can display additional fields (field: A location in a sheet, form, or chart that contains a specific kind of information about a task, resource, or assignment. For example, in a sheet, each column is a field. In a form, a field is a named box or a place in a column.) (columns) by inserting new columns into the view and remove currently displayed fields by hiding columns.
Description    The Earned Value table (table: A set of columns that shows specific information about tasks, resources, and assignments in a sheet view.) for tasks uses traditional project management categories to compare the relationship between work and costs. For example, you may want to compare your estimated cost of the work performed (BCWP) with what the work is actually costing (ACWP).
Views    The Earned Value table can be applied to any of the task sheet views, including the Bar Rollup, Detail Gantt, Gantt Chart, Leveling Gantt, Milestone Date Rollup, Milestone Rollup, PA_Expected Gantt, PA_Optimistic Gantt, PA_PERT Entry Sheet, PA_Pessimistic Gantt, Task Entry, Task Sheet, Task Usage, and Tracking Gantt views.
Fields    The Earned Value table contains the following fields: ID, Task Name, BCWS, BCWP, ACWP, SV, CV, EAC, BAC, and VAC.
Best uses    Use the Earned Value table for tasks to:
You can display additional fields (field: A location in a sheet, form, or chart that contains a specific kind of information about a task, resource, or assignment. For example, in a sheet, each column is a field. In a form, a field is a named box or a place in a column.) (columns) by inserting new columns into the view and remove currently displayed fields by hiding columns.
    Evaluate individual tasks for budget efficiency and make decisions about whether some tasks need less money, need more money, or should be cut.
    Evaluate whether you're getting the work you need done for the money you're paying and whether changes need to be made.
    Evaluate your budget to estimate future budget needs.
    Prepare an accounting statement of your project.
Description    The Entry table (table: A set of columns that shows specific information about tasks, resources, and assignments in a sheet view.) for tasks displays basic information regarding tasks, including the task name, duration, start date, finish date, predecessors, and resource names.
Fields    The Entry table contains the following fields: ID, Indicators, Task Name, Duration, Start, Finish, Predecessors, and Resource Names.
Views    The Entry table for tasks can be applied to any of the task sheet views, including the Bar Rollup, Detail Gantt, Gantt Chart, Leveling Gantt, Milestone Date Rollup, Milestone Rollup, PA_Expected Gantt, PA_Optimistic Gantt, PA_PERT Entry Sheet, PA_Pessimistic Gantt, Task Entry, Task Sheet, Task Usage, and Tracking Gantt views.
Best uses    Use the Entry table to:
You can display additional fields (field: A location in a sheet, form, or chart that contains a specific kind of information about a task, resource, or assignment. For example, in a sheet, each column is a field. In a form, a field is a named box or a place in a column.) (columns) by inserting new columns into the view and remove currently displayed fields by hiding columns.
Description    The Hyperlink table (table: A set of columns that shows specific information about tasks, resources, and assignments in a sheet view.) for tasks (task: An activity that has a beginning and an end. Project plans are made up of tasks.) is used to create shortcuts and associate them with a task. You can jump to files on your own computer, a network, your organization's intranet (intranet: Any network that provides similar services within an organization to those provided by the Internet. An organization's intranet may or may not be connected to the Internet; its information might be distributed only within the company.), and the World Wide Web (WWW: A subset of the Internet that uses a graphical user interface as opposed to a text-based user interface. The pages or Web sites that display are formatted using by HTML. Web browsers make it possible for users to view Web sites.). After you've created a hyperlink (hyperlink: A portion of text, distinguished by a color, that contains a link to another file or a location within a file. When you click the hyperlink, a Web browser will search for and display the document that is associated with the hyperlink.), you can go to that file by clicking the hyperlink. By default, hyperlink text is blue and underlined. When you return to your project file after visiting another file, the hyperlink color changes to purple.
Fields    The Hyperlink table contains the following fields: ID, Indicators, Task Name, Hyperlink, Hyperlink Address, and Hyperlink SubAddress.
Views    The Hyperlink table for tasks can be applied to any task sheet view, including the Bar Rollup, Detail Gantt, Gantt Chart, Leveling Gantt, Milestone Date Rollup, Milestone Rollup, PA_Expected Gantt, PA_Optimistic Gantt, PA_PERT Entry Sheet, PA_Pessimistic Gantt, Task Entry, Task Sheet, Task Usage, and Tracking Gantt views.
Best uses    Use the Hyperlink table to:
In the Hyperlink field (field: A location in a sheet, form, or chart that contains a specific kind of information about a task, resource, or assignment. For example, in a sheet, each column is a field. In a form, a field is a named box or a place in a column.), you enter text to represent your hyperlink. This text should describe your hyperlink's destination (destination: Where moved, copied, imported, or exported information is inserted; also a view, table, document, or another program. In OLE, the document or program where a linked object resides; also, the document that a hyperlink leads to.). After you've entered your text and set up a destination, your pointer becomes a hand when it passes over the text. Clicking the text launches the Web browser, which then goes to the address specified in the Hyperlink Address field. The file you go to can be an HTML (HTML: An acronym for Hypertext Markup Language, which is a formatting convention for presenting text and graphics on the World Wide Web.) file, a Microsoft Word document, a Microsoft Excel spreadsheet, a Microsoft PowerPoint slide, or a Microsoft Access database. When you associate a hyperlink with a resource, the Indicators field (indicators field: A field containing a graphical indicator that provides information about the state of an assignment, resource, or task. For example, a check mark indicator shows that a task is completed.) for that resource displays the hyperlink indicator (Button image ).
You can display additional fields (field: A location in a sheet, form, or chart that contains a specific kind of information about a task, resource, or assignment. For example, in a sheet, each column is a field. In a form, a field is a named box or a place in a column.) (columns) by inserting new columns into the view and remove currently displayed fields by hiding columns.
You can make your destination even more specific by indicating a particular location in the file. You enter this information in the Hyperlink SubAddress field. How you point to a specific part of a file depends on the file type. For a Word document, you can point to a bookmark. For a Excel spreadsheet, you can point to a named range. For a PowerPoint file, you can point to a slide number. For a Access file, you can point to an <object type><object name>, such as Form Customers.
    Create links to quickly open external data.
    Open files, whether local or remote, without needing to remember their locations.
Description    The PA_Expected Case table (table: A set of columns that shows specific information about tasks, resources, and assignments in a sheet view.) is used in conjunction with other PERT analysis (PERT analysis: PERT [Program, Evaluation, and Review Technique] analysis is a process by which you evaluate a probable outcome based on three scenarios: best-case, expected-case, and worst-case.) features in Project to help you evaluate the expected duration, start date, and finish date of tasks.
Views    The PA_Expected Case table can be applied to any of the task sheet views, including the Bar Rollup, Detail Gantt, Gantt Chart, Leveling Gantt, Milestone Date Rollup, Milestone Rollup, PA_Expected Gantt, PA_Optimistic Gantt, PA_PERT Entry Sheet, PA_Pessimistic Gantt, Task Entry, Task Sheet, Task Usage, and Tracking Gantt views.
Fields    The PA_Expected Case table contains the following fields: ID, Indicators, Task Name, Exp Duration, Exp Start, and Exp Finish.
Best uses    Use the PA_Expected Case table to:
You can display additional fields (field: A location in a sheet, form, or chart that contains a specific kind of information about a task, resource, or assignment. For example, in a sheet, each column is a field. In a form, a field is a named box or a place in a column.) (columns) by inserting new columns into the view and remove currently displayed fields by hiding columns.
    Compare the expected duration estimates with the optimistic duration and pessimistic duration estimates for a project's tasks.
    Enter and display the expected durations, start dates, and finish dates of a project's tasks.
Description    The PA_Optimistic Case table (table: A set of columns that shows specific information about tasks, resources, and assignments in a sheet view.) is used in conjunction with other PERT analysis (PERT analysis: PERT [Program, Evaluation, and Review Technique] analysis is a process by which you evaluate a probable outcome based on three scenarios: best-case, expected-case, and worst-case.) features in Project to help you evaluate the best-case duration, start date, and finish date of tasks.
Views    The PA_Optimistic Case table can be applied to any of the task sheet views, including the Bar Rollup, Detail Gantt, Gantt Chart, Leveling Gantt, Milestone Date Rollup, Milestone Rollup, PA_Expected Gantt, PA_Optimistic Gantt, PA_PERT Entry Sheet, PA_Pessimistic Gantt, Task Entry, Task Sheet, Task Usage, and Tracking Gantt views.
Fields    The PA_Optimistic Case table contains the following fields: ID, Indicators, Task Name, Opt Dur, Opt Start, and Opt Finish.
Best uses    Use the PA_Optimistic Case table to:
You can display additional fields (field: A location in a sheet, form, or chart that contains a specific kind of information about a task, resource, or assignment. For example, in a sheet, each column is a field. In a form, a field is a named box or a place in a column.) (columns) by inserting new columns into the view and remove currently displayed fields by hiding columns.
    Compare the optimistic duration estimates with the expected duration and pessimistic duration estimates for a project's tasks.
    Enter and display the best-case durations, start dates, and finish dates of a project's tasks.
Description    The PA_PERT Entry table (table: A set of columns that shows specific information about tasks, resources, and assignments in a sheet view.) is used in conjunction with other PERT analysis features in Project to help you evaluate the probable duration of tasks. When you enter optimistic duration, expected duration, and pessimistic duration values for a task and click Calculate PERT Button image on the PERT Analysis toolbar, Project calculates a probable duration for the selected task and places that value in the Duration field. By changing the weight that Project attributes to each of the three estimated durations, you can tailor the probable estimate to be more accurate.
Views    The PA_PERT Entry table can be applied to any of the task sheet views, including the Bar Rollup, Detail Gantt, Gantt Chart, Leveling Gantt, Milestone Date Rollup, Milestone Rollup, PA_Expected Gantt, PA_Optimistic Gantt, PA_PERT Entry Sheet, PA_Pessimistic Gantt, Task Entry, Task Sheet, Task Usage, and Tracking Gantt views.
Fields    The PA_PERT Entry table contains the following fields: ID, Task Name, Duration, Optimistic Dur., Expected Dur., and Pessimistic Dur.
Best uses    Use the PA_PERT Entry table to:
You can display additional fields (field: A location in a sheet, form, or chart that contains a specific kind of information about a task, resource, or assignment. For example, in a sheet, each column is a field. In a form, a field is a named box or a place in a column.) (columns) by inserting new columns into the view and remove currently displayed fields by hiding columns.
Description    The PA_Pessimistic Case table (table: A set of columns that shows specific information about tasks, resources, and assignments in a sheet view.) is used in conjunction with other PERT analysis (PERT analysis: PERT [Program, Evaluation, and Review Technique] analysis is a process by which you evaluate a probable outcome based on three scenarios: best-case, expected-case, and worst-case.) features in Project to help you evaluate the worst-case duration, start date, and finish date of tasks.
Views    The PA_Pessimistic Case table can be applied to task sheet views (sheet: A spreadsheet-like representation [in rows and columns] of task or resource information. Each row specifies an individual task or resource. Each column [field] specifies a type of information, such as start dates or standard rates.), including the Gantt Chart, Task Entry, and Task Usage views.
Fields    The PA_Pessimistic Case table contains the following fields: ID, Indicators, Task Name, Pess Duration, Pess Start, and Pess Finish.
Best uses    Use the PA_Pessimistic Case table to:
You can display additional fields (field: A location in a sheet, form, or chart that contains a specific kind of information about a task, resource, or assignment. For example, in a sheet, each column is a field. In a form, a field is a named box or a place in a column.) (columns) by inserting new columns into the view and remove currently displayed fields by hiding columns.
Best uses    After running the Rollup_Formatting macro, use the Rollup table to:
Description    The Rollup table (table: A set of columns that shows specific information about tasks, resources, and assignments in a sheet view.) is used with the Bar Rollup view (view: The combination of one or more views [Gantt Chart, Resource Sheet, and so on] and if applicable, a table and a filter. Use views to work with information in a variety of formats. There are three types of views: Charts or graphs, Sheets, and Forms.), the Milestone Date Rollup view, and the Milestone Rollup view to optimize the display of rolled-up (roll up: On the Gantt Chart, to display symbols on a summary task bar that represent subtask dates. You can roll up dates from subtasks to make important dates easily visible on a summary task bar.) tasks (task: An activity that has a beginning and an end. Project plans are made up of tasks.). You can best take advantage of this table and its associated views after you have run the Rollup_Formatting macro (macro: An action or a set of actions that you can use to automate tasks. Macros are recorded in the Visual Basic for Applications programming language.). To run the Rollup_Formatting macro, point to Macro on the Tools menu, and then click Macros. In the Macro name list, click Rollup_Formatting, and then click Run. Running this macro does not change any of your project data; it simply optimizes your ability to view your project as subtasks rolled up and overlaid on top of their respective summary tasks.
Views    The Rollup table can be applied to any of the task sheet views, including the Bar Rollup, Detail Gantt, Gantt Chart, Leveling Gantt, Milestone Date Rollup, Milestone Rollup, PA_Expected Gantt, PA_Optimistic Gantt, PA_PERT Entry Sheet, PA_Pessimistic Gantt, Task Entry, Task Sheet, Task Usage, and Tracking Gantt views.
Fields    The Rollup table contains the following fields: ID, Indicators, Task Name, Duration, Text Above, Start, Finish, Predecessors, Resource Names.
You can display additional fields (field: A location in a sheet, form, or chart that contains a specific kind of information about a task, resource, or assignment. For example, in a sheet, each column is a field. In a form, a field is a named box or a place in a column.) (columns) by inserting new columns into the view and remove currently displayed fields by hiding columns.
Description    The Schedule table (table: A set of columns that shows specific information about tasks, resources, and assignments in a sheet view.) displays scheduling information, including scheduled start and finish dates, late start and finish dates, free slack, and total slack. You can see when a task is supposed to begin and end and how late a task can start or finish without affecting the project's finish date. In addition, you can see how long a task can be delayed before it affects the dates of successor (successor: A task that cannot start or finish until another task starts or finishes.) tasks or the project's finish date, a concept in project planning known as slack (slack: The amount of time that a task can slip before it affects another task or the project's finish date. Free slack is how much a task can slip before it delays another task. Total slack is how much a task can slip before it delays the project.).
Views    The Schedule table can be applied to any of the task sheet views, including the Bar Rollup, Detail Gantt, Gantt Chart, Leveling Gantt, Milestone Date Rollup, Milestone Rollup, PA_Expected Gantt, PA_Optimistic Gantt, PA_PERT Entry Sheet, PA_Pessimistic Gantt, Task Entry, Task Sheet, Task Usage, and Tracking Gantt views.
Fields    The Schedule table contains the following fields: ID, Task Name, Start, Finish, Late Start, Late Finish, Free Slack, and Total Slack.
You can display additional fields (field: A location in a sheet, form, or chart that contains a specific kind of information about a task, resource, or assignment. For example, in a sheet, each column is a field. In a form, a field is a named box or a place in a column.) (columns) by inserting new columns into the view and remove currently displayed fields by hiding columns.
Description    The Summary table (table: A set of columns that shows specific information about tasks, resources, and assignments in a sheet view.) for tasks provides an overview of basic project information, including task duration, scheduled start and finish dates, percent work complete, cost, and work. You can see how long a task is scheduled to take, when it is scheduled to begin and end, how far along it is, how much it has cost so far, and how many work hours have been scheduled for the task.
Fields    The Summary table contains the following fields: ID, Task Name, Duration, Start, Finish, % Comp., Cost, and Work.
Views    The Summary table for tasks can be applied to any of the task sheet views, including the Bar Rollup, Detail Gantt, Gantt Chart, Leveling Gantt, Milestone Date Rollup, Milestone Rollup, PA_Expected Gantt, PA_Optimistic Gantt, PA_PERT Entry Sheet, PA_Pessimistic Gantt, Task Entry, Task Sheet, Task Usage, and Tracking Gantt views.
You can display additional fields (field: A location in a sheet, form, or chart that contains a specific kind of information about a task, resource, or assignment. For example, in a sheet, each column is a field. In a form, a field is a named box or a place in a column.) (columns) by inserting new columns into the view and remove currently displayed fields by hiding columns.
Description    The Tracking table (table: A set of columns that shows specific information about tasks, resources, and assignments in a sheet view.)displays actual (actual: Information that shows what has actually occurred. For example, the actual start date for a task is the day that the task actually started.) information about the project, as opposed to scheduled (scheduled: The most current information about a project, including actual and remaining dates, durations, and costs for tasks that have started and the latest projected dates, durations, and costs for tasks that have not yet started.) information. You can see when a task (task: An activity that has a beginning and an end. Project plans are made up of tasks.) actually started and ended, how far along the task is, how long it took, how much time remains before the task is completed, how much money has been spent on the task, and how much labor it has involved so far.
Views    The Tracking table can be applied to any of the task sheet views, including the Bar Rollup, Detail Gantt, Gantt Chart, Leveling Gantt, Milestone Date Rollup, Milestone Rollup, PA_Expected Gantt, PA_Optimistic Gantt, PA_PERT Entry Sheet, PA_Pessimistic Gantt, Task Entry, Task Sheet, Task Usage, and Tracking Gantt views.
Fields    The Tracking table contains the following fields: ID, Task Name, Act. Start, Act. Finish, % Comp., Act. Dur., Rem. Dur., Act. Cost, and Act. Work.
Best uses    Use the Tracking table to:
You can display additional fields (field: A location in a sheet, form, or chart that contains a specific kind of information about a task, resource, or assignment. For example, in a sheet, each column is a field. In a form, a field is a named box or a place in a column.) (columns) by inserting new columns into the view and remove currently displayed fields by hiding columns.
Description    The Usage table (table: A set of columns that shows specific information about tasks, resources, and assignments in a sheet view.) for tasks (task: An activity that has a beginning and an end. Project plans are made up of tasks.) displays your project tasks and shows their work, duration, and start and finish dates.
Fields    The Usage table contains the following fields: ID, Indicators, Task Name, Work, Duration, Start, and Finish.
Views    The Usage table for tasks can be applied to any of the task sheet views, including the Bar Rollup, Detail Gantt, Gantt Chart, Leveling Gantt, Milestone Date Rollup, Milestone Rollup, PA_Expected Gantt, PA_Optimistic Gantt, PA_PERT Entry Sheet, PA_Pessimistic Gantt, Task Entry, Task Sheet, Task Usage, and Tracking Gantt views.
You can display additional fields (field: A location in a sheet, form, or chart that contains a specific kind of information about a task, resource, or assignment. For example, in a sheet, each column is a field. In a form, a field is a named box or a place in a column.) (columns) by inserting new columns into the view and remove currently displayed fields by hiding columns.
Description    The Variance table (table: A set of columns that shows specific information about tasks, resources, and assignments in a sheet view.) emphasizes the variations between actual (actual: Information that shows what has actually occurred. For example, the actual start date for a task is the day that the task actually started.) start and finish dates and baseline (baseline plan: The original project plans [up to 11 per project] used to track progress on a project. The baseline plan is a snapshot of your schedule at the time that you save the baseline and includes information about tasks, resources, and assignments.) start and finish dates.
Views    The Variance table can be applied to any of the task sheet views, including the Bar Rollup, Detail Gantt, Gantt Chart, Leveling Gantt, Milestone Date Rollup, Milestone Rollup, PA_Expected Gantt, PA_Optimistic Gantt, PA_PERT Entry Sheet, PA_Pessimistic Gantt, Task Entry, Task Sheet, Task Usage, and Tracking Gantt views.
Fields    The Variance table contains the following fields: ID, Task Name, Start, Finish, Baseline Start, Baseline Finish, Start Var., and Finish Var.
For this table to be meaningful for your project, you need to have saved your project with a baseline, which is a snapshot of your project as you had initially set it up. A baseline is useful because you can compare it with later versions of your project to see what changes have been made. It is these changes that the Variance table emphasizes.
You can display additional fields (field: A location in a sheet, form, or chart that contains a specific kind of information about a task, resource, or assignment. For example, in a sheet, each column is a field. In a form, a field is a named box or a place in a column.) (columns) by inserting new columns into the view and remove currently displayed fields by hiding columns.
Description    The Work table (table: A set of columns that shows specific information about tasks, resources, and assignments in a sheet view.) for tasks (task: An activity that has a beginning and an end. Project plans are made up of tasks.) displays work (work: For tasks, the total labor required to complete a task. For assignments, the amount of work to which a resource is assigned. For resources, the total amount of work to which a resource is assigned for all tasks. Work is different from task duration.) information, including baseline (baseline plan: The original project plans [up to 11 per project] used to track progress on a project. The baseline plan is a snapshot of your schedule at the time that you save the baseline and includes information about tasks, resources, and assignments.) work, work variance (variance: The difference between baseline and scheduled task or resource information, they usually occur when you set a baseline plan and begin entering actual information into your schedule. Variances can occur in work, costs, and schedule.), actual work (actual work: The amount of work that has been performed on a task or assignment. When you enter actual work on a task, the remaining work is calculated using this formula: Remaining Work = Work - Actual Work. Actual work is often referred to as "actuals."), overtime (overtime: The amount of work on an assignment that is scheduled beyond the regular working hours of an assigned resource and charged at the overtime rate. Overtime work indicates the amount of the assignment's work that is specified as overtime work.) work, and remaining work (remaining work: The amount of work, in terms of a time unit such as hours or days, that is left to be completed on a task. This is calculated as follows: Remaining Work = Work - Actual Work.). You can compare the work currently scheduled against the baseline amount of work, against the actual (actual: Information that shows what has actually occurred. For example, the actual start date for a task is the day that the task actually started.) completed work, or against the remaining work.
Fields    The Work table contains the following fields: ID, Task Name, Work, Baseline, Variance, Actual, Remaining, and % W. Complete.
Views    The Work table for tasks can be applied to any of the task sheet views, including the Bar Rollup, Detail Gantt, Gantt Chart, Leveling Gantt, Milestone Date Rollup, Milestone Rollup, PA_Expected Gantt, PA_Optimistic Gantt, PA_PERT Entry Sheet, PA_Pessimistic Gantt, Task Entry, Task Sheet, Task Usage, and Tracking Gantt views.
For this table to be meaningful for your project, you need to have saved your project with a baseline, which is a snapshot of your project as you had initially set it up. A baseline is useful because you can compare it with later versions of your project to see what changes have been made. It is these changes that the Work table emphasizes.
You can display additional fields (field: A location in a sheet, form, or chart that contains a specific kind of information about a task, resource, or assignment. For example, in a sheet, each column is a field. In a form, a field is a named box or a place in a column.) (columns) by inserting new columns into the view and remove currently displayed fields by hiding columns.

ShowResource tables

ShowCost

ShowEarned Value

ShowEntry

ShowEntry - Material Resources

ShowEntry - Work Resources

ShowExport

ShowHyperlink

ShowSummary

ShowUsage

ShowWork

Description    The Cost table (table: A set of columns that shows specific information about tasks, resources, and assignments in a sheet view.) for resources displays cost information about your project resources (including cost, planned cost, variance, actual cost, and remaining cost).
Fields    The Cost table contains the following fields: ID, Resource Name, Cost, Baseline Cost, Variance, Actual Cost, and Remaining.
Views    The Cost table for resources can be applied to the following resource fields: Resource Sheet, Resource Usage, and Resource Allocation views.
You can display additional fields (field: A location in a sheet, form, or chart that contains a specific kind of information about a task, resource, or assignment. For example, in a sheet, each column is a field. In a form, a field is a named box or a place in a column.) (columns) by inserting new columns into the view and remove currently displayed fields by hiding columns.
Description    The Earned Value table (table: A set of columns that shows specific information about tasks, resources, and assignments in a sheet view.) for resources uses traditional project management categories to compare the relationship between work and costs. For example, you may want to compare your estimated cost of the work performed (BCWP) with what the work is actually costing (ACWP).
Fields    The Earned Value table contains the following fields: ID, Resource Name, BCWS, BCWP, ACWP, SV, CV, EAC, BAC, and VAC.
Views    The Earned Value table for resources can be applied to any resource sheet view, including the Resource Allocation, Resource Usage, and Resource Sheet views.
Best uses    Use the Earned Value table for resources to:
You can display additional fields (field: A location in a sheet, form, or chart that contains a specific kind of information about a task, resource, or assignment. For example, in a sheet, each column is a field. In a form, a field is a named box or a place in a column.) (columns) by inserting new columns into the view and remove currently displayed fields by hiding columns.
    Evaluate individual resources for budget efficiency and make decisions about whether some resources need less money, need more money, or should be cut.
    Evaluate whether you're getting the work you need done for the money you're paying and whether changes need to be made.
    Evaluate your budget to estimate future budget needs.
    Prepare an accounting statement of your project.
Fields    The Entry table contains the following fields: ID, Indicators, Resource Name, Type, Material Label, Initials, Group, Max. Units, Std. Rate, Ovt. Rate, Cost/Use, Accrue At, Base Calendar, and Code.
Description    The Entry table for resources (resources: The people, equipment, and material that are used to complete tasks in a project.) displays basic information regarding resources, including the resource type, group, standard rate, overtime rate, cost per use, and accrual method.
Views    The Entry table for resources can be applied to any of the resource sheet views, including the Resource Sheet, Resource Usage, and Resource Allocation views.
Best uses    Use the Entry table to:
You can display additional fields (field: A location in a sheet, form, or chart that contains a specific kind of information about a task, resource, or assignment. For example, in a sheet, each column is a field. In a form, a field is a named box or a place in a column.) (columns) by inserting new columns into the view and remove currently displayed fields by hiding columns.
    Enter and view resources in your project.
    Group related resources.
    Set up the pay rates and characteristics of resources.

 Note   To assign prices that vary over time, click a resource, click Resource Information Button image, click the Costs tab, and then type the standard rate and the per-use cost in the Cost rate tables.

Description    The Entry - Material Resources table (table: A set of columns that shows specific information about tasks, resources, and assignments in a sheet view.) displays basic information about material resources (material resource: The supplies or other consumable items that are used to complete tasks in a project.), including the resource name, group, standard rate, cost per use, and accrual method.
Views    The Entry - Material Resources table can be applied to resource sheet views, including the Resource Sheet, Resource Usage, and Resource Allocation views.
Fields    The Entry - Material Resources table contains the following fields: ID, Indicators, Resource Name, Type, Material Label, Initials, Group, Std. Rate, Cost/Use, Accrue At, and Code.
Best uses    Use the Entry - Material Resources table to:
You can display additional fields (field: A location in a sheet, form, or chart that contains a specific kind of information about a task, resource, or assignment. For example, in a sheet, each column is a field. In a form, a field is a named box or a place in a column.) (columns) by inserting new columns into the view and remove currently displayed fields by hiding columns.

 Note   To assign variable pay rates that adjust over time, click a resource, click Resource Information Button image, click the Costs tab, and then type the pay rates in the Cost rate tables.

Description    The Entry - Work Resources table (table: A set of columns that shows specific information about tasks, resources, and assignments in a sheet view.) displays basic information about work resources (work resource: People and equipment resources that perform work to accomplish a task. Work resources consume time [hours or days] to accomplish tasks.), including the resource name, type, group, maximum units, standard rate, overtime rate, cost per use, and accrual method.
Views    The Entry - Work Resources table can be applied to resource sheet views (sheet: A spreadsheet-like representation [in rows and columns] of task or resource information. Each row specifies an individual task or resource. Each column [field] specifies a type of information, such as start dates or standard rates.), including the Resource Sheet, Resource Usage, and Resource Allocation views.
Fields    The Entry - Work Resources table includes the following fields: ID, Indicators, Resource Name, Type, Initials, Group, Max. Units, Std. Rate, Ovt. Rate, Cost/Use, Accrue At, Base Calendar, and Code.
Best uses    Use the Entry - Work Resources table to:
You can display additional fields (field: A location in a sheet, form, or chart that contains a specific kind of information about a task, resource, or assignment. For example, in a sheet, each column is a field. In a form, a field is a named box or a place in a column.) (columns) by inserting new columns into the view and remove currently displayed fields by hiding columns.
Description    The Export table (table: A set of columns that shows specific information about tasks, resources, and assignments in a sheet view.) for resources is used to display a broad range of resource-related fields (field: A location in a sheet, form, or chart that contains a specific kind of information about a task, resource, or assignment. For example, in a sheet, each column is a field. In a form, a field is a named box or a place in a column.) (columns).
Fields    The Export table contains the following fields: ID, Unique ID, Resource Name, Initials, Max. Units, Standard Rate, Overtime Rate, Cost Per Use, Accrue At, Cost, Baseline Cost, Actual Cost, Work, Baseline Work, Actual Work, Overtime Work, Group, Code, Text1-5, and Email Address.
Views    The Export table for resources can be applied to any of the resource sheet views, including the Resource Sheet, Resource Usage, and Resource Allocation views.
Best use    Use the Export table to export information from a project file to another file format such as XLS, CSV, or TXT.
You can display additional fields (field: A location in a sheet, form, or chart that contains a specific kind of information about a task, resource, or assignment. For example, in a sheet, each column is a field. In a form, a field is a named box or a place in a column.) (columns) by inserting new columns into the view and remove currently displayed fields by hiding columns.
Description    The Hyperlink table (table: A set of columns that shows specific information about tasks, resources, and assignments in a sheet view.) for resources (resources: The people, equipment, and material that are used to complete tasks in a project.) is used to create shortcuts and associate them with a resource. You can jump to files on your own computer, a network, your organization's intranet (intranet: Any network that provides similar services within an organization to those provided by the Internet. An organization's intranet may or may not be connected to the Internet; its information might be distributed only within the company.), and the World Wide Web (WWW: A subset of the Internet that uses a graphical user interface as opposed to a text-based user interface. The pages or Web sites that display are formatted using by HTML. Web browsers make it possible for users to view Web sites.). After you've created a hyperlink (hyperlink: A portion of text, distinguished by a color, that contains a link to another file or a location within a file. When you click the hyperlink, a Web browser will search for and display the document that is associated with the hyperlink.), you can go to that file by clicking the hyperlink. By default, hyperlink text is blue and underlined. When you return to your project file after visiting another file, the hyperlink color changes to purple.
Fields    The Hyperlink table contains the following fields: ID, Indicators, Resource Name, Hyperlink, Hyperlink Address, and Hyperlink SubAddress.
Views    The Hyperlink table for resources can be applied to any of the resource sheet views, including the Resource Sheet, Resource Usage, and Resource Allocation views.
Best uses    Use the Hyperlink table to:
In the Hyperlink field (field: A location in a sheet, form, or chart that contains a specific kind of information about a task, resource, or assignment. For example, in a sheet, each column is a field. In a form, a field is a named box or a place in a column.), you enter text to represent your hyperlink. This text should describe your hyperlink's destination (destination: Where moved, copied, imported, or exported information is inserted; also a view, table, document, or another program. In OLE, the document or program where a linked object resides; also, the document that a hyperlink leads to.). After you've entered your text and set up a destination, your pointer becomes a hand when it passes over the text. Clicking the text launches the Web browser, which then goes to the address specified in the Hyperlink Address field. The file you go to can be an HTML (HTML: An acronym for Hypertext Markup Language, which is a formatting convention for presenting text and graphics on the World Wide Web.) file, a Microsoft Word document, a Microsoft Excel spreadsheet, a Microsoft PowerPoint slide, or a Microsoft Access database. When you associate a hyperlink with a resource, the Indicators field (indicators field: A field containing a graphical indicator that provides information about the state of an assignment, resource, or task. For example, a check mark indicator shows that a task is completed.) for that resource displays the hyperlink indicator (Button image ).
You can display additional fields (field: A location in a sheet, form, or chart that contains a specific kind of information about a task, resource, or assignment. For example, in a sheet, each column is a field. In a form, a field is a named box or a place in a column.) (columns) by inserting new columns into the view and remove currently displayed fields by hiding columns.
You can make your destination even more specific by indicating a particular location in the file. You enter this information in the Hyperlink SubAddress field. How you point to a specific part of a file depends on the file type. For a Word document, you can point to a bookmark. For a Excel spreadsheet, you can point to a named range. For a PowerPoint file, you can point to a slide number. For a Access file, you can point to an <object type><object name>, such as Form Customers.
    Create links to quickly open external data.
    Open files, whether local or remote, without needing to remember their locations.
Description    The Summary table (table: A set of columns that shows specific information about tasks, resources, and assignments in a sheet view.) for resources provides an overview of the project resources, including the resource name, group, standard and overtime rates, maximum units, and peak units.
Fields    The Summary table contains the following fields: ID, Resource Name, Group, Max. Units, Peak, Std. Rate, Ovt. Rate, Cost, and Work.
Views    The Summary table for resources can be applied to any of the resource sheet views, including the Resource Sheet, Resource Usage, and Resource Allocation views.
You can display additional fields (field: A location in a sheet, form, or chart that contains a specific kind of information about a task, resource, or assignment. For example, in a sheet, each column is a field. In a form, a field is a named box or a place in a column.) (columns) by inserting new columns into the view and remove currently displayed fields by hiding columns.
Description    The Usage table (table: A set of columns that shows specific information about tasks, resources, and assignments in a sheet view.) for resources (resources: The people, equipment, and material that are used to complete tasks in a project.) displays your project resources and shows how much work is assigned to each of them.
Fields    The Usage table contains the following fields: ID, Indicators, Resource Name, and Work.
Views    The Usage table for resources can be applied to any of the resource sheet views, including the Resource Sheet, Resource Usage, and Resource Allocation views.
You can display additional fields (field: A location in a sheet, form, or chart that contains a specific kind of information about a task, resource, or assignment. For example, in a sheet, each column is a field. In a form, a field is a named box or a place in a column.) (columns) by inserting new columns into the view and remove currently displayed fields by hiding columns.
Description    The Work table (table: A set of columns that shows specific information about tasks, resources, and assignments in a sheet view.) for resources displays work information, including baseline work, work variance, actual work, overtime work, and remaining work. You can compare the work currently scheduled with the baseline amount of work, with the actual completed work, or with the remaining work.
Fields    The Work table contains the following fields: ID, Resource Name, % Comp., Work, Overtime, Baseline, Variance, Actual, and Remaining.
Views    The Work table for resources can be applied to any of the resource views, including the Resource Sheet, Resource Usage, and Resource Allocation views.
For this table to be meaningful for your project, you need to have saved your project with a baseline, which is a snapshot of your project as you had initially set it up. A baseline is useful because you can compare it with later versions of your project to see what changes have been made. It is these changes that the Work table emphasizes.
You can display additional fields (field: A location in a sheet, form, or chart that contains a specific kind of information about a task, resource, or assignment. For example, in a sheet, each column is a field. In a form, a field is a named box or a place in a column.) (columns) by inserting new columns into the view and remove currently displayed fields by hiding columns.
 
 
Applies to:
Project 2003