Microsoft Office Project 2003 Inside Out
A
abbreviations, task duration time period, Entering Durations
absolute column references, macro, Understanding the Record Macro Dialog Box, Absolute Column References Can Be Tricky, Troubleshooting: Why doesn't your macro select the right cell ?
absolute row references, macro, Understanding the Record Macro Dialog Box, Troubleshooting: Why doesn't your macro select the right cell?
acceptance, final, Project Management Practices: Administrative Closure
accepting updates, Setting Rules for Accepting Updates
Access\
copying information from, Copying from Another Application to Microsoft Project
exporting to<$endrange>, Microsoft Access yes/no values
exporting to<$startrange>, Storing Data in a Database
file format, Table 16-2: Supported File Types
Project OLE DB Provider and, Understanding Project OLE DB Provider Data
saving projects as databases, Table 29-1: Supported File Formats
yes/no values, Microsoft Access yes/no values
Account Properties dialog box, Setting Up Project Professional for Your Server
accounts
Project Server, Setting Up Project Professional for Your Server
Windows vs. Project Server, Setting Up Project Professional for Your Server
accounts, Windows, Specifying Workgroup Information
accounts\
deactivating user <$endrange>, Customizing Enterprise Resource Fields
deactivating user<$startrange>, Deactivating Users
establishing<$startrange>, Establishing User Accounts and Permissions
managing, Carry out administrative duties
Project Server, Logging On
Windows, Logging On
accrual, cost, Setting Cost Accrual, Planning Fixed Task Costs
accurate information, Keys to Successful Project Management
activation\
UserForm<$endrange>, Integrating Your Form into Microsoft Project
UserForm<$startrange>, Integrating Your Form into Microsoft Project
Active Directory\
e-mail workgroup messaging e-mail addresses from, Entering E-Mail Addresses Automatically
resources and, Working with Your Team through Microsoft Project, Adding and Assigning Resources at the Same Time
synchronizing groups with, Synchronizing with Active Directory Security Groups
synchronizing resources with<$endrange>, Synchronizing with Active Directory Resources
synchronizing resources with<$startrange>, Synchronizing with Active Directory Resources
synchronizing with, Manipulating Microsoft Project the Way You Want
active view, Change the Format of a View
Active View bar, Using Views
ActiveX controls, Using ActiveX Controls
ActiveX Data Objects (ADOs), Understanding Project OLE DB Provider Data, Inside Out: No Data Access Pages for Project 2003
activity definition process, Project Management Practices: Activity Definition
Activity on Node diagrams, Working with Network Diagrams
Actual Cost of Work Performed (ACWP), Reviewing Overall Work Totals, Interpret the Earned Value Figures, Understanding the Earned Value Fields
actual work done and remaining work update method, Establishing the Update Method and Restrictions
Actual Work field, Submitting Progress Information
actuals, Tracking Progress on Your Assignments
actuals, protecting, Protecting actuals information, Protecting Actuals
actuals\
automatic entry of, Automate Tracking with Project Web Access
changing scheduled values when entering, Figure 11-5: Apply the Slipping Tasks filter to quickly see which tasks are in jeopardy.
choosing best method for entering, Choosing the Best Method for Entering Actuals
entering, for earned value analysis, Entering Actuals
entering, using resource work<$endrange>, Protecting Actuals Information
entering, using resource work<$startrange>, Updating Progress Using Resource Work
entering, using task scheduling controls<$endrange>, Design a Custom Tracking View
entering, using task scheduling controls<$startrange>, Updating Progress Using Task Scheduling Controls
progress tracking and, Saving Original Plan Information Using a Baseline, Updating Task Progress
progress tracking and. <charcntd>See also<default para font> progress tracking<$nopage>, Saving Original Plan Information Using a Baseline
project performance and, Baseline, Scheduled, and Actual Project Information
protecting, Protecting Actuals Information, Protecting actuals
Add Group page, Creating a New Group
Add method, Objects
Add New Currency Wizard, Converting an EMU Currency to Euro
Add New Currency Wizard<$endrange>, Converting One Currency to Another
Add New Currency Wizard<$startrange>, Converting One Currency to Another
Add Procedure window, Writing a Macro in the Editor
Add User page, Establishing User Accounts and Permissions
Add Watch window, Using Watches
Additional Controls dialog box, Tools Menu, Using ActiveX Controls
address book, Outlook, Building Your Resource List with Outlook
address books, adding resources from, Entering E-Mail Addresses Automatically
address books, adding resources from e-mail, Adding Resources from Your E-Mail Address Book, Adding and Assigning Resources at the Same Time
addresses, e-mail, Setting Up E-Mail Notifications, Setting Rules for Accepting Updates
Adjust Dates tool, Adapting the Template to Your Project
adjustments, project plan, Keys to Successful Project Management
Admin page, Configuring Your Enterprise and Workgroup, Creating a New Group, Customizing Categories, Synchronizing with Active Directory Resources
Administration Overview page, Carry out administrative duties
administration, enterprise<$endrange>, Tailor Project Web Access for users
administration, enterprise<$startrange>, Figure 21-1: Set up enterprise and workgroup options on the Project Web Access Admin page.
administration, enterprise\
APIs and, Create an interface for enterprise data
categories of tasks, Carry out administrative duties
configuring enterprise and workgroup options<$endrange>, Establishing User Accounts and Permissions
configuring enterprise and workgroup options<$startrange>, Configuring Your Enterprise and Workgroup
customizing fields<$endrange>, Establishing the Update Method and Restrictions
customizing fields<$startrange>, Customizing Enterprise Project Fields
customizing Project Web Access, Tailor Project Web Access for users
enterprise global template<$endrange>, Customizing Enterprise Project Fields
enterprise global template<$startrange>, Working with the Enterprise Global Template
enterprise resource pool. <charcntd>See<default para font> enterprise resource pool, administering<$nopage>, Administering the Enterprise Resource Pool
establishing enterprise portfolios<$endrange>, Working with the Enterprise Global Template
establishing enterprise portfolios<$startrange>, Establishing the Enterprise Portfolio
establishing user accounts and permissions<$startrange>, Establishing User Accounts and Permissions
managing security<$endrange>, Administering the Enterprise Resource Pool
managing security<$startrange>, Managing Security
setting up team member timesheets<$endrange>, Establishing the Default Timesheet Fields
setting up team member timesheets<$startrange>, Setting Up Team Member Timesheets
administration\
Project Server, Understanding the Project Server Database
administrative closure, Project Management Practices: Administrative Closure
administrative projects, Tracking Non-Project Tasks and Time, Creating an Administrative Project
administrative projects<$endrange>, Tracking Nonproject Tasks and Time
administrative projects<$startrange>, Tracking Nonproject Tasks and Time
Administrative Projects\
non-project work and, Allow for Non-Project Work
Administrative Time template, Tracking Non-Project Tasks and Time
Administrator page, Project Web Access, Managing Resources
administrators\
enterprise project, Who's Who in Enterprise Project Management, Understanding Enterprise Project Management
advanced searches, Searching for Files
Alert Me page, Configuring E-Mail Notifications
alias, custom field, Troubleshooting: The custom field name isn't as informative as a column heading in a table
All Cells box, Changing the Table in a View, Showing Assignments by Task or Resource
allocation\
reviewing enterprise resource<$endrange>, Delegating Tasks to Resources
reviewing enterprise resource<$startrange>, Reviewing Resource Allocation and Availability
Alt+End key combination, Navigating to a Specific Location in a View
Alt+F10 key combination, Changing Resource Assignments
ALT+F11 key combination, Windows, Writing a Macro in the Editor, Deciding Where to Create and Store Procedures, Automating with a Library Reference
ALT+F8 key combination, Looking at Macro Code
Alt+Home key combination, Navigating to a Specific Location in a View
Alt+Tab key combination, Switching Among Open Projects
ampersand (&), Creating a New View, Creating Keyboard Shortcuts, Table 27-2: Breakdown of Code in the Friday_Report Macro, Writing Efficient Code
Analysis toolbar, Working with COM Add-Ins, Copying a Picture of a View, Generating Reports from Project XML Data, Capturing a View for Word, PowerPoint, or Visio, Creating Project XML Data, Downloading a Project Template
analysis. <charcntd>See<Default Para Font> Excel reports views<$nopage>, Using this Book
analysis<$endrange>, Charting Project Data Using S-Curves
analysis<$startrange>, Figure 13-1: Specify which of 11 possible saved baselines should be used for the earned value calculations.
analysis\
charting data with Excel S-Curve graphs<$endrange>, Charting Project Data Using S-Curves
charting data with Excel S-Curve graphs<$startrange>, Charting Project Data Using S-Curves
controlling process and, Controlling the Project
earned value. <charcntd>See also<default para font> earned value analysis<$nopage>, Analyzing Progress and Costs Using Earned Value
earned value<$endrange>, Your Earned Value Fields Are All $0.00
earned value<$startrange>, Analyzing Progress and Costs Using Earned Value
Excel. <charcntd>See also<default para font> Excel<$nopage>, Calculating Project Information in Microsoft Excel
Excel<$endrange>, Charting Project Data Using S-Curves
Excel<$startrange>, Calculating Project Information in Microsoft Excel
numeric data in Excel<$endrange>, Analyzing Timephased Project Data in Excel
numeric data in Excel<$startrange>, Analyzing Numeric Project Data in Excel
timephased data in Excel<$endrange>, Analyzing Project Data with Crosstab Tables
timephased data in Excel<$startrange>, Analyzing Timephased Project Data in Excel
variances, Project Management Practices: Schedule Control
with Excel crosstab tables<$endrange>, Analyzing Project Data with Crosstab Tables
with Excel crosstab tables<$startrange>, Analyzing Project Data with Crosstab Tables
Analyze Timescaled Data Wizard, Analyzing Timephased Project Data in Excel, Exporting Timephased Information to Excel
analyzing\
enterprise project activities with Portfolio Analyzer, Analyzing Your Enterprise Project Activities
execution phase and, Chapter 10: Saving a Baseline and Updating Progress
project performance, Analyzing Project Performance
project portfolios<$endrange>, Reviewing Resource Assignments
project portfolios<$startrange>, Analyzing Your Project Portfolio
resource information in Project Web Access<$endrange>, Reviewing Resource Availability
resource information in Project Web Access<$startrange>, Analyzing Resource Information
anchor cells, Copying Sheet Information from Excel, Linking from Excel to Project
angle brackets (>), Linking Tasks Between Different Projects
annotations. <charcntd>See<Default Para Font> notes<$nopage>, Copying a Document into Your Project File
API for Enterprise Custom Fields, Manipulating Microsoft Project the Way You Want, Creating Server interfaces with Other Applications
API for Enterprise Outline Code Fields, Manipulating Microsoft Project the Way You Want, Creating Server interfaces with Other Applications
API for Enterprise Resource Pool Creation, Manipulating Microsoft Project the Way You Want, Creating Server interfaces with Other Applications
API for Project Data Creation, Manipulating Microsoft Project the Way You Want, Creating Server interfaces with Other Applications
API for Timesheets, Manipulating Microsoft Project the Way You Want, Creating Server interfaces with Other Applications
apostrophe ('), Table 27-2: Breakdown of Code in the Friday_Report Macro, Naming Conventions
Application Data folder, Copy Templates that Others Have Created
Application event procedures<$endrange>, Creating Project Event Procedures
Application event procedures<$startrange>, Creating Application Event Procedures
Application object, Parents and Children: The Object Model Hierarchy
application program interfaces (APIs), Manipulating Microsoft Project the Way You Want, Creating Server interfaces with Other Applications
Application Program Interfaces (APIs)\
enterprise projects and, Create an interface for enterprise data
enterprise resource pool, Adding an Individual Enterprise Resource
for Timesheet view, Establishing the Default Timesheet Fields
Application property, Objects
application settings tables, Introducing Common Database Elements
applications, exchanging information with. <charcntd>See<default para font> integration<$nopage>, Chapter 16: Exchanging Information with Other Applications
approving timesheets, Reviewing Resource Timesheets
archived projects, tasks and, Entering Tasks
archives, project, Project Management Practices: Administrative Closure
arguments, Visual Basic, Methods, Understanding Procedures, Named Arguments
arrays, Visual Basic, Understanding Variables, Writing Efficient Code
As Late As Possible date constraint, Understanding Constraint Types, Flexible Constraints, Inside Out: A deadline might affect scheduling after all
As Soon As Possible date constraint, Scheduling Tasks to Achieve Specific Dates, Flexible Constraints, Inside Out: Remove the SNET constraints
Assign Resources dialog box, Adding and Assigning Resources at the Same Time, Filtering for Resources, Defining a Resource Skill Set, Finding the Right Resources for the Job, Assigning Material Resources to Tasks, Changing Resource Assignments, Replacing Overallocated Resources, Checking Availability of Resource Pool Resources, Review a resource's availability graphs
Assign Resources dialog box<$endrange>, Adding and Assigning Resources at the Same Time
Assign Resources dialog box<$startrange>, Creating Work Resource Assignments
assignment delay, lag time vs., Delaying Linked Tasks by Adding Lag Time
Assignment Information dialog box, Showing Assignments by Task or Resource, Contouring Resource Assignments, Entering Percent Work Complete, Entering Actual Work Complete by Time Period
Assignment Notes dialog box, Accepting New and Changed Assignments
Assignment reports<$endrange>, Using the Overallocated Resources Report
Assignment reports<$startrange>, Evaluating Resource Allocation with Assignment Reports
assignment units\
checking, Checking and Adjusting Resource Availability
maximum units vs., Assigning Work Resources to Tasks, Figure 7-1: Use the Assign Resources dialog box to specify which resources are to be assigned to which tasks, and for how much of their available time.
scheduling and, Controlling Schedule Changes with Task Types, Understanding the Fixed Units Task Type
switching, from percentage to decimal, Creating Work Resource Assignments
Assignment Work graph, Finding the Right Resources for the Job
assignments
enterprise project, Assigning Tasks to Enterprise Resources
progress updates, Accepting Updates from Team Members
publishing changed enterprise project, Configuring Update Options, Publishing Information for Team Members
publishing new enterprise project, Publishing Information for Team Members
rejected, Accepting Updates from Team Members
self-assigned, Accepting Updates from Team Members
Assignments table, Appendix B: Field Reference
assignments, work resource<$endrange>, Assigning Material Resources to Tasks
assignments, work resource<$startrange>, Assigning Work Resources to Tasks
assignments, work resource\
adding and assigning resources at the same time<$endrange>, Adding and Assigning Resources at the Same Time
adding and assigning resources at the same time<$startrange>, Adding and Assigning Resources at the Same Time
creating<$endrange>, Adding and Assigning Resources at the Same Time
creating<$startrange>, Creating Work Resource Assignments
default work unit, Assigning Material Resources to Tasks
defining resource skill sets, Defining a Resource Skill Set
dimmed Filter By and Available to Work boxes, Figure 7-4: In the Work version of the Resource Availability Graph, you can review the selected resource's remaining availability over time.
filtering<$endrange>, Review Availability Graphs for Multiple Resources
filtering<$startrange>, Filtering for Resources
finding appropriate resources, Finding the Right Resources for the Job
matching, to tasks, Project Management Practices: Assigning the Right Resources to Tasks
maximum units vs. assignment units, Figure 7-1: Use the Assign Resources dialog box to specify which resources are to be assigned to which tasks, and for how much of their available time.
missing filters, Troubleshooting: Your Filter By or Available To Work boxes are dimmed
multiple, to reduce durations, Assigning Material Resources to Tasks
reviewing availability graphs for multiple resources, Review Availability Graphs for Multiple Resources
summary tasks and, Adding and Assigning Resources at the Same Time
switching assignment units from percentages to decimals, Creating Work Resource Assignments
translating task duration to work amounts, Translate Duration to Work Amounts
work and duration calculations<$endrange>, Assigning Material Resources to Tasks
work and duration calculations<$startrange>, Understanding Assignment Calculations
assignments<$endrange>, Contouring Resource Assignments
assignments<$startrange>, Inside Out: Max units vs. assignment units
assignments\
accepting new and changed<$endrange>, Accepting New and Changed Assignments
accepting new and changed<$startrange>, Accepting New and Changed Assignments
actual work completed for, Entering Actual Work Complete and Remaining Work
adding resource initials to Gantt bars<$endrange>, Adding Initials of Assigned Resources to the Gantt Bar
adding resource initials to Gantt bars<$startrange>, Adding Initials of Assigned Resources to the Gantt Bar
adding resources, Changing Resource Assignments
adding resources to tasks, Adding More Resources to Tasks
adjusting, for resource-constrained projects<$endrange>, Specifying Overtime Work to Account for Overallocations
adjusting, for resource-constrained projects<$startrange>, Adjusting Assignments
adjusting, to balance resource workloads, Balancing the Resource Workload
adjusting, to reduce costs, Adjusting Assignments to Reduce Costs, Realigning the Project with the Budget
annotating, Showing Assignments by Task or Resource
changing<$endrange>, Contouring Resource Assignments
changing<$startrange>, Changing Resource Assignments
contouring<$endrange>, Contouring Resource Assignments
contouring<$startrange>, Contouring Resource Assignments
controlling changes with effort-driven scheduling<$endrange>, Controlling Changes with Effort-Driven Scheduling
controlling changes with effort-driven scheduling<$startrange>, Controlling Changes with Effort-Driven Scheduling
controlling schedule changes with task types<$endrange>, Changing the Task Type
controlling schedule changes with task types<$startrange>, Controlling Schedule Changes with Task Types
cost rate tables and, Setting Multiple Costs for a Resource
custom fields, Establishing Custom Fields
database tables, Introducing Common Database Elements
delays<$endrange>, Delaying a Task or Assignment
delays<$startrange>, Delaying a Task or Assignment
enterprise project, Managing Enterprise Resources
fields, Using Fields, Appendix B: Field Reference
importing, into Outlook Calendar<$endrange>, Importing Project Assignments into the Outlook Calendar
importing, into Outlook Calendar<$startrange>, Importing Project Assignments into the Outlook Calendar
integrating, with Outlook Calendar<$endrange>, Updating Assignments in the Outlook Calendar
integrating, with Outlook Calendar<$startrange>, Integrating Tasks Between Project Web Access and the Outlook Calendar
leveling. <charcntd>See<default para font> leveling, resource<$nopage>, Project Management Practices: The Right Resources for Critical Tasks
material resource<$endrange>, Reviewing Assignment Information
material resource<$startrange>, Assigning Material Resources to Tasks
navigating to, in views, Navigating to a Specific Location in a View
OLE DB Provider tables, Understanding Project OLE DB Provider Data
opening Assignment Information dialog box, Showing Assignments by Task or Resource
percent work complete for, Entering Percent Work Complete
progress tracking and, Updating Progress Using Resource Work
project database information, Understanding Project Information Categories
Project database table, Understanding the Microsoft Project Database
providing status updates, Providing Assignment Status Updates
receiving and responding to, Receiving and Responding to Assignments
receiving responses from team members, Receiving Workgroup Messages from Team Members
removing resources, Changing Resource Assignments
replacing overallocated resources, Replacing Overallocated Resources
replacing resources, Changing Resource Assignments
reports<$endrange>, Using the Overallocated Resources Report
reports<$startrange>, Evaluating Resource Allocation with Assignment Reports
resending, to team members, Resending Task Assignments
reviewing costs, Reviewing Assignment Costs
reviewing<$endrange>, Changing Resource Assignments
reviewing<$startrange>, Reviewing Assignment Information
sending updates to team members, Sending Task Updates to Team Members
sending, to team members, Sending Assignments to Team Members
showing and hiding, Showing Assignments by Task or Resource
Smart Tags and, Changing Resource Assignments, Controlling Schedule Changes with Task Types, Understanding the Fixed Units Task Type
specifying overtime work for overallocated resources<$endrange>, Specifying Overtime Work to Account for Overallocations
specifying overtime work for overallocated resources<$startrange>, Specifying Overtime Work to Account for Overallocations
Task Information dialog box and, Changing Resource Assignments
timephased information, Using Views
timephased views, Working with Usage Views
to enterprise resources<$endrange>, Delegating Tasks to Resources
to enterprise resources<$startrange>, Delegating Tasks to Resources
to-do lists, Managing Risks, Issues, and Documents
updating resource pools for changed, Updating Resource Pool Information
updating, in Outlook Calendar<$endrange>, Updating Assignments in the Outlook Calendar
updating, in Outlook Calendar<$startrange>, Updating Assignments in the Outlook Calendar
viewing projects for, in resource pools, Figure 14-18: Add the Project field to the Resource Usage view to see the source of resources and their assignments.
viewing resource allocations and, Reviewing Resource Allocation
viewing, in Project Web Access, Reviewing Resource Assignments
views, Table 4-5: Microsoft Project Usage Views
work resource. <charcntd>See also<default para font> assignments, work resource<$nopage>, Assigning Work Resources to Tasks
work resource<$endrange>, Assigning Material Resources to Tasks
work resource<$startrange>, Assigning Work Resources to Tasks
workgroup collaboration and<$endrange>, Create a to-do list
workgroup collaboration and<$startrange>, Working with Assignments
Assistance Center, Getting Help and Training
assistance, Project Help, Surfing the Web for Project Assistance, Setting Your Preferences for Project Assistance
assumptions, project\
scope statement and, Developing the Scope Statement
assumptions\
cost, Checking Your Cost Assumptions, Realigning the Project with the Budget
schedule, Correcting the Schedule
schedule<$endrange>, Project Management Practices: Duration Compression
schedule<$startrange>, Checking Your Schedule Assumptions
asterisk (*), Creating Filters
attachments, e-mail\
Project files as, Sending an Entire Project File
team member responses as, Receiving Workgroup Messages from Team Members
authentication, Establishing User Accounts and Permissions
Auto Data Tips option, Using Watches
Auto List Members box, Useful Tools When Learning the Object Model
AutoFilter, Customizing AutoFilter Criteria, Reviewing Your Tasks or Resources by Outline Code
AutoFilters, Filtering Project Information, Troubleshooting: Some of your project information is missing
automated e-mail notifications, Configuring E-Mail Notifications
automated notifications, Introducing Common Database Elements
automatic cost calculation, Manually Updating Project Costs
automatic progress tracking, Updating Task Progress, Automate Tracking with Project Web Access, Protecting Actuals Information, Entering Actuals
automatic project plan recalculation, Turn Automatic Calculation On or Off
automatic resource leveling, Inside Out: Priorities apply only to resource leveling and substitution, Setting Leveling Options, Troubleshooting: Microsoft Project performance has slowed since you last leveled
automatic task linking, Understanding the Dependency Types
automatically substituting generic resources, Adding Resource Names Manually
Automation, Writing Efficient Code
Automation<$endrange>, Automating without a Library Reference
Automation<$startrange>, Automating Microsoft Project
Automation\
with library references, Automating with a Library Reference
without library references<$endrange>, Automating without a Library Reference
without library references<$startrange>, Automating without a Library Reference
autosave feature, Saving Project Files Automatically
availability graphs, Review a resource's availability graphs
availability, resource, Managing Resources, Working with Your Team through Microsoft Project, Working with Supplemental Resource Fields, Project Management Practices: Assigning the Right Resources to Tasks, Finding the Right Resources for the Job, Adjusting Resource Availability, Balancing the Resource Workload
availability, resource pool resource, Checking Availability of Resource Pool Resources
availability, resource<$endrange>, Adding Material Resources to the Project, Review Availability Graphs for Multiple Resources, Adding Resources to Decrease Duration
availability, resource<$startrange>, Specifying Resource Availability, Finding the Right Resources for the Job, Checking and Adjusting Resource Availability
availability\
OLE DB Provider tables, Understanding Project OLE DB Provider Data
Project database table, Understanding the Microsoft Project Database
reviewing enterprise resource<$endrange>, Delegating Tasks to Resources
reviewing enterprise resource<$startrange>, Reviewing Resource Allocation and Availability
viewing, in Project Web Access, Reviewing Resource Availability
Available to Work box, Figure 7-4: In the Work version of the Resource Availability Graph, you can review the selected resource's remaining availability over time.