Earned Value Analysis and Pivot Tables
Manage Yourself – not Time!
Project Management for Innovation and High Risk
Writing Project Objectives
Writing Project Options
Writing Project Deliverables
Writing a Project Scope
Writing Project Constraints
Assessing Project Risk


Validating Data in Excel
The Purpose of Project Control
Diagnosing Project Problems
Asking the right questions of the team
Taking Corrective Action (Part 1)
Taking Corrective Action (Part 2)


Printing to Impress
Using a Deadline Symbol in Microsoft Project

Using Pivot Tables in Excel
The Power of a Project Management Database
Automatic Colour Changes on the Gantt Chart
Preparing and Entering Data
The Horizontal Screen Split
Scaling for Screen and Print
Improving Gantt Chart Appearance
Durations, Work and Resource Units
Assigning Part-Time Resources
Examining Costs
Costing Material-Type Resources
Tracking a Project - No.1
Tracking a Project - No.2
Grouping Tasks and Resources
Displaying Information in MS Project Tables
Reporting Cash flows
Using Outline Code Fields
Creating Filters
Creating Your Own Tables

Flexible Resource Costing
Project Server 2003


Tactical vs. Value Decision Making
Will Decision-makers learn from Project Managers?
How to Make Decisions
Formulating the Decision
Building a Decision Context
Elements of a Good Decision Process
Decision Options and Criteria
White Paper: Fending off the Lawyers
Overview of Decision-making tools & techniques

 

 

Preparing & Entering Data

Summary
It is important to develop a sound approach toward preparing and entering data in Microsoft Project. Basic project data required by the software includes task names, durations, predecessors, resource attributes and assignments. Think about what works for you and then stick to it. This is our preference.

PROGRAM CONFIGURATION
We recomend you select 'Fixed Duration' . For now,

  • Choose Tools-Options (Schedule Tab)
  • Choose 'Fixed Duration' opposite Default Task Type
  • Clear the 'Effort Driven' option immediately below this.

TASK INFORMATION
We recommend that you enter tasks, duration and predecessors on the default MS Project 2000 screen (the 'Entry' table) in that order. Working column-wise:

  • Enter all the names first in the 'Task Name' column
  • Attend to the durations and predecessors. This allows you to focus on one thing at a time.

RESOURCE ALLOCATION
It is tempting to allocate resources just by typing the names into the Resource Names column of the 'Entry' table. Try resist this! It is far better to define the resources first and then assign them by picking them off a drop-down list. This reduces the chance of errors. First:

  • Define the resource attributes on the Resource Sheet (View Resource Sheet).
  • Ensure that the name, max units, and standard ratesare entered (if you are to track costs).

To assign resources,

  • Click Assign Resource Toolbar button { } or use Tools - Resources - Assign Resources. This will bring the Assign Resource box to the screen.

For each task do the following:

  • Select the task to which resources are to be assigned.
  • Click the Units cell opposite the resource to be assigned in the Assign Resource Box
  • Click the Assign button to assign one unit of the resource. (Alternatively enter a different number including a fraction)

You have now entered all the data Microsoft Project expects before it can produce schedules and budget projections.

 

 

 

Numerix Pty. Ltd. ABN 83 003 504 970 Telephone: 61 2 - 9279 0900 Fax: 61 2 - 9279 4141 email info@numerix.com.au