Understanding Project Ole Db Provider Data

Use Access to take advantage of the capabilities of the Project OLE DB Provider. After you use the Project OLE DB Provider to connect to a project file in Access, you can access OLE data stored in a Microsoft Project file. Use the Microsoft Project data to create custom reports or break out and manipulate specific pieces of data. You can use this data across a wide variety of data sources, including relational databases, spreadsheets, and the Internet. Project Server uses an OLE DB add-on...

Protecting Baseline Information

If you're using Microsoft Office Project Professional 2003 with Microsoft Office Project Server 2003 and the enterprise project management features, your project server administrator grants or denies the ability to save baselines in enterprise projects. Only those who have the Save Baseline permission set by the administrator can save or potentially overwrite a baseline in your project. This baseline protection feature, new in Project 2003, is used by organizations who want to lock down...

Sharing Resources Using a Resource Pool

Typically, when you create a project file, you set up and schedule your tasks and then add resources and assign tasks to them. Often however, resources are assigned to tasks in multiple projects. You might be the manager of these different projects and use the same resources in all of them. Or multiple project managers might share the same resources for their projects. To prevent conflicts between projects and avoid resource overallocation among multiple projects, you can create a resource...

Updating Progress Using Task Scheduling Controls

You can update progress by entering actual information from task scheduling controls such as percent complete, duration, start date, and finish date. You can use these methods whether or not resources are assigned in Microsoft Project. Probably the easiest method of entering tracking information is to provide information to Microsoft Project that shows that your project is going exactly according to plan. You can use today's date or another date as the reference complete through date. With this...

Inside Out

The leveling indicator often suggests that the resource be leveled on a Day By Day basis because Microsoft Project has found that this resource is overallocated by at least one minute over the resource availability for a day. You might find that level of detail too fine for your purposes. It might be more effective to level resources on a Week By Week basis or a Month By Month basis. Although the overal-location is still detected when you're overallocated by just one minute, looking at the...

Storing Data in a Database

Information in a database is stored in a set of predefined tables, each made up of a set of predefined columns. A table can have an unlimited number of rows. Think of rows as a collection of data with a set of individual components, also known as records. Think of columns as all the individual components that make up a collection of data, also known as fields. To demonstrate what this means in a project database, each task displayed on a separate row in a table is a different task record. Each...

Trapping Errors

Try as you might to be perfect, you will introduce errors into your code. Many of them will be simple typing or syntax errors that will be caught by Visual Basic. Still others will be errors of action, in which your code works differently from what you intended, that you will catch when testing your code. The remainder consists of situations that you didn't think would arise or actions you didn't think your users would take. It is for this last class of errors that error trapping is so...

Exporting Selected Data to Excel

To export only information you choose, follow these steps 1 In Microsoft Project, open the project plan that contains the project information you want to export. 3 Browse to the drive and folder where you want to save your information. 4 In the Save As File Type list, click Microsoft Excel Workbook (*.xls). 5 In the File Name box, enter a name for your new Excel file. By default, the project file name is adopted with the .xls extension. The first page of the Export Wizard appears. 7 On the...

Downloading and Installing the Workgroup Message Handler

Files and information for installing and enabling workgroup e-mail messaging are available on the Web. To download and install the workgroup message handler, follow these steps 1 Open your Web browser and go to the Microsoft Download Center at www. microsoft. com downloads. 2 Under Search For A Download in the Product Technology box, click Microsoft Project. 3 In the Keywords box, type workgroup message handler. A list of related downloads appear. Click the download link related to Project...

Protect project baselines

As project server administrator, you might be called upon to intervene in projects when baselines are involved. In many organizations, baseline information is the basis for proposals, contracts, and payment. Variances might be tracked in minute detail. Earned value calculations, which rely on baseline information, might be crucial to measuring project success. In any of these cases, the project is carefully planned and built, and then the details are approved by all the managing stakeholders....

Implementing a Straight Block Hierarchy

A third example is a company that uses a pure project management model for its organization. Some construction companies are set up in this way. This model is considered a straight block. The level of authority and responsibility below the president is the project manager. All the work in the company is planned, performed, and tracked as projects. For example, suppose that there are 12 different projects being done, each independent and equal in importance to the company. The 12 project...

Downloading a Project Template

Project Management Clipart

You can download additional templates for different industries and endeavors from the Office Online Web site. To do this, follow these steps 2 In the New Project pane, click the Templates On Office Online link. Your Web browser launches and goes to the Office Online Web site (see Figure 28-7). Figure 28-7. The Office Online Web site contains more templates, as well as clip art, training, and articles that are continually being updated and expanded. Figure 28-7. The Office Online Web site...

Understanding Enterprise Project Management

The enterprise features of Project Professional scale up the power of Microsoft Project beyond the individual project to multiple departments and groups in a mid- to large-size multiple-project business. With enterprise project management, information stored in the Project Server database from every resource and every project in the entire company can be quickly collated and reported. Enterprise project management is implemented through Project Professional together with Project Server, Project...

Scheduling Tasks

Setting Task Durations 138 Setting Deadline Reminders 165 Establishing Task Dependencies 149 Creating Milestones in Your Schedule . . 167 Scheduling Tasks to Achieve Specific Working with Task Calendars 169 Dates 157 You've developed your task list, and it's sequenced and outlined. Perhaps you've even applied a work breakdown structure. You have a good task list, but you don't have a schedule .yet. Although there are many knowledge areas (including scope management, cost management, and...

Understanding Project Workgroup Collaboration

Communication is a critical component of effective project management. There's no question that establishing an effective two-way information flow prevents a host of problems. Project Server and Project Web Access provide a highly efficient process for exchanging project information with team members. As the project manager working in Project Professional and Project Web Access, you can transmit project information through Project Server to do the following Submit assignments and task changes...

Table of Contents

We'd Like to Hear from About the What's on the Using the System Support Conventions and Features Used in This Book xxvii Text Design Introducing Microsoft Project 2003 3 Using This Using Microsoft Project An Microsoft Project 2003 Microsoft Project Server and Microsoft Project Web Access 10 What's New in Microsoft Project 2003 10 What's New in Project Standard 2003 11 What's New in Project Professional 2003 15 What's New in Project Server and Project Web Access 2003 16 Learning as You Getting...

Specify multiple properties for a single resource

If you're set up for enterprise project management using Microsoft Office Project Server 2003 and Project Professional, your project server administrator can identify enterprise resources as having multiple properties, such as skills, locations, or certifications. These multiple properties are set up with the Enterprise Resource Multi-Value (ERMV) fields, which are the enterprise resource outline codes numbered 20-29. Your project server administrator sets up the multi-value codes and then...

NCalculating Project Information in Microsoft Excel

T Because Microsoft Excel is such a powerful tool for manipulating and calculating numeric data, in some cases you might find it beneficial to move some of the numeric data from w Microsoft Project for more in-depth analyses in Excel. For example, you can export project cost or earned value data to Excel. Or perhaps you want to crunch tracking data or assignment information. You can also create pivot tables and generate graphs such as S-curves to show project performance information. Exporting...

Assigning Yourself to Existing Tasks

Your project manager might have published project information without assigning tasks to resources. Team members can assign themselves to tasks in a published project. To do this, follow these steps 1 In the side pane of the Tasks page, click Assign Myself To An Existing Task (see Figure 23-5). Figure 23-5. Sign up for tasks in a project. 2 In the Project box, select the project to which the task belongs. All tasks are grouped by all published projects in which you are listed as a resource,...

Understanding Data in the Database

A database is made up of lots of little pieces of data. In the case of Microsoft Project, there are task names, task durations, calendars, resource costs, and so on. Each of these pieces of data that has a column in a database table also has a data type associated with it. Data types are used to define the way the data is stored in the database. For example, a resource cost field needs to hold a number that might not be a whole number, so it needs a data type that allows a number such as 20.50....

Named Arguments

When supplying arguments for a method, each argument is separated from the next with a comma for example ActiveProject.Tasks.Add Write chapter, 3 When it comes to self-documenting code, however, that code isn't especially descriptive. You can probably guess that Write chapter is the name of the new task, but it's harder to guess what the 3 is for. This is one way in which named arguments can be valuable. Using named arguments means that instead of supplying just the values for each argument,...

Understanding Work Breakdown Structure Codes

Each item and level in a work breakdown structure is described by a unique WBS code. Each digit in the code typically represents a level in the structure's hierarchy, such as 2.1.4.3 or c 5.B.c.3. A WBS code such as 1.2.3 might represent the third deliverable for the second activity p in the first phase of the project. Note In some industries or application areas, the work breakdown structure is also known as the project breakdown structure, or PBS. In Microsoft Project, any outline structure...

Understanding Assignment Calculations

Work is the amount of effort it takes to complete a task. As soon as you assign a resource to a task, the duration is translated into work. A simple example If you have a task with a 3-day duration and you assign a single full-time resource to it, that resource now has an assignment with 24 hours of work spread across three days (assuming default calendar settings). You can see this principle in action by adding the Work field to the Gantt Chart or other task sheet, as follows 1 Display the...

Project Management Practices Assigning the Right Resources to Tasks

As the project manager, you consider several factors when deciding whom to assign to which tasks. One of the most important factors is the resource's skill set, competencies, and proficiencies. His or her ability to carry out the assigned task is essential to the success of the task. You can set up your resources in Microsoft Project so that you can find and assign resources based on their skill sets. Another important factor is the resource's availability. If the perfect resource is 100...

Project Management Terminology

The following is a list of project management-related terms Baseline. A snapshot of key project information for tasks, such as their start dates, finish dates, durations, and costs. With baseline information, you have a means of comparison against actual progress on tasks. Date Constraint. A specific date associated with a specific task. A date constraint dictates that a task must be finished by a certain date, for example, or started no earlier than a certain date. Deliverable. A tangible...

Importing a Project Task List from Excel

You can make your project plan more accurate and inclusive by integrating the suggestions and concrete input of team members and stakeholders into the project plan. Specifically, you can have others on the team create a task list from an Excel workbook and quickly incorporate it into Microsoft Project. Using the Microsoft Project Task List template in Excel, introduced in Project 2002, this process becomes seamless. The standard Excel importing process involves mapping the Excel columns to the...

Working with Costs and Budgeting

Cost estimating Top-down cost estimating is the practice of using the actual cost of a previous similar project as the basis for estimating the cost of the current project. Bottom-up cost estimating involves estimating the cost of individual tasks and then summarizing those estimates to arrive at a project cost total. The estimate should take into consideration labor, materials, supplies, and any other costs. With Microsoft Project, you can see the planned costs of resources, as well as the...

Integrating Tasks Between Project Web Access and the Outlook Calendar

Through the use of the Outlook Integration Component Object Model (COM) add-in provided with Project Web Access 2003, team members using Project Web Access can now keep track of their assigned tasks in their Outlook Calendars, along with their other appointments. They can update progress on those project assignments in the Calendar and report the status back to Microsoft Project Server 2003 directly from Outlook. Project tasks can be displayed as free or busy time, just like any other Calendar...

Project Management Practices Working with the Baseline

The primary schedule baseline is the approved project schedule. This plan has been adjusted and refined to the point where it meets the scope, the targeted finish date, and the budget of the project. The baseline plan has been deemed technically feasible given available resources. The baseline plan has been approved as the plan of record by the managing stakeholders. This baseline plan is a component of the overall project plan. It provides the basis for measuring the schedule and cost...

Understanding Projects and Project Management

Understanding Project Management Facilitating Your Project with Microsoft Basics 39 Project 45 Understanding Project Management Understanding Project Stakeholders . . . . 52 Processes 42 Keys to Successful Project You use a word processing program to create a text document. You use a spreadsheet program to calculate sales data. You use a publishing program to design and lay out a brochure. In these cases, the application helps you create the end result. With Microsoft Office Project 2003, this...

Tracking Nonproject Tasks and Time

Not every minute of every day can be devoted to your project assignments. You know that you have to take time taken for nonproject tasks such as attending staff meetings and participating in training workshops. And then there are also vacations, holidays, and personal time off. To handle nonproject tasks and nonworking time, your project server administrator or resource manager creates and publishes a special administrative project. This administrative project contains tasks such as vacations,...

Reducing Project Costs

A budget-constrained project is one in which costs are the most important factor in the project plan. Although you still need to balance schedule requirements and satisfy the project scope, the costs are at the forefront of your decision-making processes as you plan and execute the project. If your project plan calculates that your total costs are above the allowed budget, you need cost-cutting strategies. Your best approach will involve cutting resources because resources and costs are...

Project Management Practices Duration Compression

In project management, there are two commonly used methods of shortening a series of tasks without changing the project scope. These two duration compression methods are as follows Crashing the schedule. The schedule and associated project costs are analyzed to determine how a series of tasks (such as the critical path) can be shortened, or crashed, for the least additional cost. Fast tracking. Tasks normally done in sequence are rescheduled to be done simultaneously (for example, starting to...

Match the Columns

Copying and pasting information is one of the easiest ways to get information from Excel to Microsoft Project. However, to paste successfully, the columns of Excel information must match the Microsoft Project columns into which you're pasting. For example, suppose that your Excel worksheet contains four columns you want to copy to your project plan Task Name, Resource, Duration, and Fixed Cost. Add, remove, and rearrange columns in a Microsoft Project task table so that these four columns...

Working with Project Tasks in Your Outlook Calendar

If you use Microsoft Outlook, you can keep track of your assigned tasks in your Outlook Calendar, along with your other appointments. You can update progress on your project assignments in the Calendar and report the status back to Project Server directly from Outlook. Project tasks can be displayed as free or busy time, just like any other Calendar entries. Note Outlook integration with Project Web Access allows integration with the Outlook Calendar, but not with Outlook Tasks. If you choose...

Rearranging View Information

In project and resource views, you can sort, group, or filter information by criteria you choose. To sort items in a view by a particular field, follow these steps 1 In the view, click the heading of the field column you want to sort by. The field is sorted in either ascending or descending order. 2 To sort in the other direction, click the column heading a second time. To group items by a particular field in a view, follow these steps Display the view you want to work with. Above the table,...

Create a Status Report

You can use Project Web Access to design a status report for other project resources to complete and submit to you periodically. You set up the time period and the headings. At the designated time periods, the individuals write their status report and submit it to the project server. You can review the status reports individually or have the project server compile them for an integrated project status report. You need to request the status report only when you first set it up. Resources see...

Project Management Practices Cost Control

Cost control is the means for a project to stay within the bounds of the prescribed project budget. It involves continual monitoring of the project plan, tracking actual work and cost information, and taking corrective action where needed. If a task early in the project costs more than expected, costs might have to be trimmed in later tasks. In addition, outside forces might affect the project budget. For example, certain material costs might have gone up from the time you developed your plan...

Importing Detailed Project Information from Excel

If certain team members or other project stakeholders are doing more than just building a task list in Excel, have them use the Microsoft Project Import Export Template. This template can be used in Excel to build a project with tasks, resources, and assignments. Then you have a properly formatted worksheet for many of the essential elements of a plan for importing into Microsoft Project. The standard Excel importing process involves mapping the Excel columns to the corresponding Microsoft...

Setting Up Team Member Timesheets

Whether you're working with enterprise project management or workgroup features only, you need to set up the default team member Timesheets. The Timesheet is the primary view that team members work with to track and update their tasks assigned from one, two, or more projects (see Figure 21-30). You establish the assignment progress tracking method that is then reflected in the Timesheet. The tracking method can be as simple as noting whether an assignment is not started, in progress, or...

Introducing Common Database Elements

A database is a collection of information broken into categories or groups of data that have predefined relationships to each other. Each group of data, in turn, is a collection of specific details that is distinct from other groups of data for example, task information is distinct from resource information. If you can imagine a project as a set of tasks, a set of resources, and a set of assignments, you're already on your way to understanding how the Microsoft Project database fits together....

Working with Your Team through Microsoft Project

In addition to helping you create your project plan, Microsoft Project helps with resource management, cost management, and team communications. Understanding Projects and Project Management With Microsoft Project resource management features, you can perform the following tasks Enter resources in the Microsoft Project resource list. Enter resources from your organization's e-mail address book, Active Directory, or Project Server accounts. Maintain a reusable pool of resources available across...

Date Fields

Table B-2 lists all date fields available in Microsoft Project. For information about working with the project schedule and associated date fields, see Chapter 9, Checking and Adjusting the Project Plan, and Monitoring and Adjusting the Schedule on page 327. ASSN_ACT_FINISH RES_ACT_FINISH TASK ACT FINISH The actual date and time when a task is completed. The actual date and time when a task began. The start date that a resource is available to start work on a project. The end date that a...

Linking from Another Application to Microsoft Project

The data connection of a linked object can be made using another application as the source and Microsoft Project as the target, which can be a handy way to show currently updated information from a different origin. Linked graphical information can be pasted only in select locations in Microsoft Project for example, the Gantt Chart, Notes areas, and the Task and Resource Forms. Linked textual information can also be pasted into the table cell. To link data from another application, follow these...

Exchanging Information with Other Applications

Copying Information 471 Embedding Information 479 Linking Information 489 Hyperlinking to Documents in Other to the Web 493 Creating Project XML Data 496 Importing and Exporting Information. . . 497 You can exchange data in Microsoft Office Project 2003 with other applications. This capability can save everyone involved an immense amount of time and effort and can also provide for the flexibility of information so essential in an efficient project. For example, you might want to provide a set...

Whos Who in Enterprise Project Management

Given the nature of project workgroups and enterprise project management, it's obvious that Project 2003 users represent a variety of roles. Roles in enterprise project management are as follows Project manager. The traditional user of Microsoft Project, the project manager is still the hub around which all other roles rotate. The project manager primarily uses Project Professional 2003 and occasionally also uses Project Web Access. The project manager g builds and adjusts the project, assigns...

Creating a Project File

To start creating your new project plan, you simply start Microsoft Project and choose whether you're creating a new project from scratch or from a template. If you haven't Installed Microsoft Project yet, refer to Appendix A, Installing Microsoft Project 2003, for installation details and guidelines. To start Microsoft Project, click the Windows Start menu. Point to All Programs, point to Microsoft Office, and then click Microsoft Project. Microsoft Project starts (see Figure 3-1). Note If...

Structuring Master Projects with Subprojects

With Microsoft Project, you can insert one project into another. Inserted projects look and act like summary tasks in any task view, with their subordinate tasks readily available. You can view and change all tasks within that inserted project. The task information is changed in the source project file as well, because the two projects are linked by default. Although you might insert projects for a variety of reasons, the most effective use of this capability is to create a master project...

Automating Microsoft Project

Automating a program such as Microsoft Project means that you control the program remotely, even invisibly, as if you were actually using the interface. This means, for example, that you can use the Spelling Checker feature of Microsoft Word in Microsoft Project or the math functions of Microsoft Excel from within Microsoft Project. In fact, you can even automate Microsoft Project from a Web page. Programs that support making references to the Microsoft Project object model, such as Microsoft...

Calculating Your Most Probable Duration

In the course of researching task duration information, you might get conflicting results. Maybe the team member who will carry out a major task says it will take 3 weeks. Perhaps an expert stakeholder says it should take 2 weeks. And maybe the industry standard states that the same task should take 4 weeks. These are large discrepancies and they're all coming from credible sources. How do you schedule a task with three possible durations Or maybe you have a single reliable duration or a...

Understanding Project Information Categories

The means for organizing, managing, and storing the thousands of pieces of project information is the Microsoft Project database. There are three major categories in the project database a When you start entering project information, typically you enter tasks and associated infor te mation such as duration, date constraints, deadlines, and task dependencies. These all fall Z under the task information category. Then you enter resource names and associated information such as standard rate,...

Importing from Excel without a Template

If team members or other project stakeholders created an Excel workbook containing project information before they knew of the existence of the templates, you can still import Excel worksheets. 1 On the Standard toolbar in Microsoft Project, click Open. 2 Go to the location on your computer or network where the Excel workbook is saved. 3 In the Files Of Type list, click Microsoft Excel Workbooks (*.xls). The workbook appears in the list of folders and files. 4 Click the workbook file and then...

Working with the Enterprise Global Template

When a project manager or other authorized user checks out an enterprise project, the latest update of the enterprise global is automatically attached. The enterprise global is akin to a global template, or the global global over the standard project global template. The enterprise global dictates standards being enforced and customizations made available to Microsoft Project interface elements in projects throughout the enterprise. These standards provide for customization and consistency...

Project Management Practices Activity Definition

The stage of the project management process in which you're entering tasks is often referred to as activity definition. Here, the planning team identifies the specific activities, or tasks, that must be done to produce the project deliverables and meet the project objectives as specified in the scope statement. Activity definition is typically done with the guidance provided in the scope statement and the work breakdown structure (WBS). The deliverables, or work packages, described in the WBS...

Saving and Opening with Different File Formats

A file format is an arrangement of data in a file that specifies the file type and defines the file in a way that allows any application that can open the file to open it correctly. When you cre ate and save a regular project file, it's saved as an MPP file with the .mpp extension. The .mpp extension indicates that this is indeed a regular project file. However, you can save project files in other file formats. You can also open files with other file formats in Microsoft Project. Table 29-1...

Importing Tasks from an Excel Worksheet

Many project managers do well by having others on the team develop a task list of their specific areas of responsibility. A great way to automate this process is to have these individuals use Microsoft Excel to create their task lists and then import the worksheets into the Microsoft Project Gantt Chart. The standard Excel importing process involves mapping the Excel columns to the corresponding Project columns to ensure that the right information ends up in the right places in your Gantt Chart...

Project Management Practices Administrative Closure

As you complete each major milestone or phase, you've probably been getting formal acceptance of that phase by the sponsor or customer. The sponsor reviews the deliverables and checks that the scope and quality of work are completed satisfactorily and then signs off his or her acceptance of that phase. When you reach the end of the project, you get your final acceptance and signoff, which at this point should be a formality because the sponsor has been involved and signing off on the interim...

Understanding the Microsoft Project Database

The Microsoft Project database can be viewed in Access or Excel 2003 if you open a project file saved in the proper format. When viewed in either Access or Excel, the Microsoft Project database has more tables than you would see in a project file that has been accessed using the Project OLE DB Provider. Nevertheless, whether you view project data through the Microsoft Project database or the Project OLE DB Provider, you're seeing almost exactly the same set of data. If you open a project...

Understanding Project Server Components

The core components of Microsoft Project workgroup collaboration and enterprise project management are as follows Project Professional. The origin of all project data, including tasks, resources, assignments, scheduling dates, costs, and tracking information. The Microsoft Project database stores all project information managed from Project Professional. Through the Microsoft Project database, Project Professional interfaces with Project Server. Project Server. Essentially a server and database...

Routing a Project File

Note You can route a project file if you're using Outlook or any other 32-bit MAPI-based e-mail program. Sometimes you need specific information from certain individuals regarding the project plan. Maybe one team member is developing the task list, someone else is adding the resources, and someone else is assigning those resources to tasks. Or perhaps you want various leads to update progress on their segments of the project. One very effective way to give a comprehensive picture of your work...

Exporting Complete Project Data to Excel

You can export more complete information about tasks, resources, and assignments. With this method, Microsoft Project organizes data into Task, Resource, and Assignment data types, which in turn are presented in their own separate worksheets in the single Excel workbook. To create a complete Excel workbook of project information from your project file, follow these steps 1 In Microsoft Project, open the project whose information you want to export to Excel. 3 Browse to the drive and folder...

Make Earned Value Tables and Views More Accessible

If you review the earned value table often, you might do well to add it to the Table menu. To do this, follow these steps 1 Click View, Table, More Tables. 2 In the More Tables dialog box, click Earned Value or one of the other earned value tables you want to add to the Table menu. 4 At the top of the Table Definition dialog box, select the Show In Menu check box. The selected table is now listed in the Table menu in the current project, and you can get to it with fewer clicks. You can also...

Planning Resource and Task Costs

Working with Costs and Budgeting. . . . 231 231 Reviewing Planned Costs 232 Working with Multiple Currencies 238 Planning Resource Costs . Planning Fixed Task Costs Microsoft Office Project 2003 can help you plan, forecast, and track costs associated with the performance of the project. The bulk of your costs is likely to be generated by the resources assigned to tasks. There might also be costs directly associated with tasks. The starting point is to enter unit resource costs and any fixed...

Organizing Tasks into an Outline

Now that your task list is sequenced to your satisfaction, you're ready to organize the tasks into a structure representing the hierarchy of tasks from the broader perspective to the deep and detailed perspective where the real work actually takes place. A task at a higher outline level than other tasks is called a summary task the tasks beneath that summary task are called subtasks (see Figure 3-18). Summary tasks typically represent phases in a project. For example, in a new business startup...

Working with Project Smart Tags

When you make certain types of adjustments to your project plan, Microsoft Project can present Smart Tag indicators with option buttons (see Figure 1-26). These Smart Tags specify the action you've just taken, along with any possible implications that action might have. You get information, especially in certain ambiguous situations, to make sure that the result is really your intention. You also see options to switch to a different action if your intention was for a different outcome. Only...

Enumerated Fields

Table B-4 lists all fields that store enumerated values in Microsoft Project. Table B-4. Enumerated Fields The way in which resource costs are accrued at the start, at the end, or prorated across the span of the project. The base calendar to be used with a particular resource. The collaboration method used to communicate with resources on a project team. Assignment-BookingType Resource-BookingType The booking type for a resource, either Committed or Proposed. The type of constraint applied to a...

Looking at Macro Code

For many people, knowing how to record and play back a macro is sufficient for most of their needs. But what if you made a minor mistake while recording a macro What if you recorded a complex macro that referenced a project by filename and then the filename was changed Although you might not ever need to know how to write VBA code, much less create an entire macro with it, the first step to making simple changes or corrections is to understand how simple and logical the macro code can be. For...

Configuring Your Enterprise and Workgroup

Your organization can set up Microsoft Office Project 2003 for enterprise project management with workgroup collaboration or for workgroup collaboration only. As the project server administrator, you configure enterprise and workgroup options on the Admin page in Project Web Access. To go to this page, follow these steps 1 Open your Web browser, and in the Address bar enter the URL for the location of the project server. 2 In the logon page, enter your user ID and password that was set up for...

Duration Fields

Table B-3 lists all duration fields available in Microsoft Project. For more information about durations, see Setting Task Durations on page 138. The amount of time that actual work has been performed on a task, up to the current date. Assignment AssignmentTime- Timephased OvertimeWork Resource ResourceTime- Timephased OvertimeWork The amount of overtime work already completed by a resource on a task. The amount of work already completed by a resource on a task. The amount of actual overtime...

Maintaining Your Enterprise Projects

Now that your projects are stored on the project server, you can work with them as enterprise projects. What does that mean to you Essentially, it means that you check the project out of the server when you want to work on it and check it back in when you're done for the day, for example. It also means that you're now using the enterprise global template containing any standard project elements that have been defined for your organization, including custom fields, outline codes, macros, views,...

Establishing User Accounts and Permissions

Project Server is loaded with a set of built-in user groups, each of which is associated with a set of permissions having to do with various aspects of enterprise project management and workgroup collaboration. Consider using the built-in groups and permission sets as a starting point. As you and your organization gain more experience with Project Server and start to get a better idea about how you want to implement enterprise and workgroup features, you can make adjustments and customizations....

Currency Fields

Table B-1 lists all currency and currency rate fields available in Microsoft Project. For more information about working with costs, see Chapter 8, Planning Resource and Task Costs, and Monitoring and Adjusting Costs on page 338. For more information about analyzing project information with earned value, see Chapter 13, Analyzing Project Information. cost for work performed, plus fixed costs. value budgeted costs of work performed BCWP costs. value budgeted cost of work scheduled BCWS costs....

Integrating Microsoft Project with Microsoft Excel

Embedding Between Microsoft Project and Excel....................... Linking Between Microsoft Project 504 and Excel.................... Importing and Exporting with Excel . . . . 521 Several techniques for information interchange are at your disposal to exchange information in Microsoft Office Project 2003 with Microsoft Excel. Not only can you integrate Excel information into your project plan, but you can also feed information from Project 2003 to an Excel workbook. Such capabilities provide...

Importing Information into Microsoft Project

You can bring information into Microsoft Project from another application and another file format by importing it. Importing converts another application s file format into the Microsoft Project file format. You start an import process by simply using the File, Open command. To import data to Microsoft Project, follow these steps 1 In Microsoft Project, click File, Open. 2 In the Files of Type list of the Open dialog box, click the file format of the file you are importing for example,...