Category: How-to

Resource allocation in Standard Time®is very straightforward, mostly because ST does not have the complex scheduling capabilities of Microsoft Project.  The image below shows a (compressed) screenshot of the resource allocation window.  We’ll discuss how to display and manage task allocations.

Standard Time Resource Allocation Window

 First, you should realize that the bars represent hours worked in a time period.  The resource allocation window collects all tasks assigned to each employee, and assembles them into time periods based on their starting dates.  If you have ten tasks that all add up to 80 hours, you might see two bars, one for each week.

The red bar in the image above represents a over-allocated week.  That means you have too many tasks to be performed in a single week.  Yellow bars indicate to little work (or under-allocation).  Blue bars are just about right.

Simply create new project tasks and give each one a starting (and optional due date).  When these tasks are assigned to employees, the resource allocation window shows them split up into time periods.  That’s about all you need to do!  It’s pretty simple.

–ray

Milestones are a necessary element of project planning.  They let you stop and evaluate.  Have the objectives been met so far?  Is everything ready to proceed to the next step?  If so, we have achieved a milestone event, and the next phase can begin.  Here’s how to create a milestone in Microsoft Project.

Start by creating three tasks.  Notice that the third task is a zero-duration task.  That is considered a milestone in MS Project.  We’ll be linking into this task so that it gets pushed out if any other tasks go longer than anticipated.

Milestone Task in MS Project

 

Select tasks to link them.  CLick in the selection column to select an entire row, then Ctrl+Click in another row.  Click the Link button to link them.

Selected Tasks

 

Link and move some to illustrate the milestone.  Here we see both tasks linked into the milestone.  If either task is delayed, the milestone will be pushed out.  When the milestone date arrives, you should evaluate your project to make sure it is on track.  Then you can proceed to the next phase.

Linked Tasks

This post will illustrate how to calculate costs in Microsoft Project.  As you will see below, each tasks has a total cost and an actual cost.  The actual cost are those costs that have actually been incurred during the execution of the project.

Costs in Microsoft Project and Standard Time® are very different.  Each task in Microsoft Project may have an arbitrary dollar value.  We’ll assign some below to demonstrate.  This is not true of Standard Time®.  Standard Time calculates task costs by multiplying hours times rates.  (C = H * R)  There are various rates a project may have, but the formula is always true.  Microsoft Project is different.  Follow the steps below to calculate costs in MSP.

Create some tasks:

1. Add a task named “Task 1”
2. Add a task named “Task 2”
3. Set the Duration to 100h and 40h respectively
4. Remove all columns by the Duration column (right-click and choose Hide Column)

 

The results look like this:

 

Insert the following columns:

1. Cost
2. Actual Work
3. % Complete
4. Actual Cost

 

The results will look like this:

Microsoft Project Cost Fields

 

Experiment with the Duration, Cost, and Actual Work fields, and you will see updates costs values.  The image below illustrates this.

Updated Microsoft Project Cost Values

–ray

This post discusses how to display WBS codes in Microsoft Project.  WBS stands for Work Breakdown Structure.  It is an (arguably cryptic) way to number tasks in a project so you can tell the hierarchy position.  The first number in the sequence represents the task id.  Each dot represents a subtask.  Follow the steps below to show the WBS number.

1. Enter three tasks
2. Right-click in the column header area
3. Choose Insert Column
4. Choose the WBS column
5. The results will look like this

 

WBS Codes

 Next, we’ll insert some new tasks and demote them.

1. Right-click in row #2
2. Choose New Task
3. Enter some tasks
4. Demote them
5. The results will look like this (notice the WBS codes)

 

Indented WBS Codes

 

If you really want to make your WBS codes exotic, try these steps.

1. Choose Project, WBS Codes…
2. Enter a prefix
3. Choose a custom numbering scheme
4. Click OK
5. The results may look something like this

 

WBS Prefix

 

–ray

This post will discuss the simplicity of using master projects in MS Project.  The image below shows a master project with two subprojects under it.  Three MS Project MPP files are required to create the project below.  The master project file is independant of the individual subproject files.  Follow the steps below to create a master project with subprojects.  Notice the green icons next to Sub1 and Sub2.  They indicate the sub-files included in the main master mpp file.

 

Master project and two subprojects

 

To create a master project in MS Project:

1. Create a new MS Project file named Sub1.mpp (see the example above)
2. Add some tasks
3. Create another mpp file named Sub2.cpp
4. Add some tasks to it
5. Create a third mpp file to act as the master project
6. Click in the first row of the master project
7. Choose Insert, Project…
8. Choose Sub1.mpp
9. Repeat steps 6 – 8 for the second subproject (the results should be similar to the image above)

 

–ray

Progress lines in Microsoft Project help see where tasks are behind schedule.  They’re hideous to look at, but serve a useful purpose.  This post shows how to add progress lines to a Microsoft Project file.  Buckle up; this may get rough.  🙂

 

Start by adding a few tasks to a new project:

1. Add Task 1, with 10 hours duration
2. Add Task 2, with 20 hours
3. Add Task 3, with 30 hours

The tasks and Gantt bar should look like this.  At this point, we have no progress lines, just simple task bars in the Gantt chart.

 

 

Add a Project Status date:

1. Choose Project, Project Information
2. Enter a ‘Status date’ for when you would like to check task status (the status date progress line will be red)
3. Click OK

 

Add progress lines:

1. Choose Tools, Tracking, Progress Lines
2. Click ‘Always display current progress line’
3. Click ‘At project status date’
4. Click ‘Display selected progress lines’
5. Click in the list and choose the dropdown arrow
6. Select a date for a progress line (these lines will be black)
7. Click OK

You should now have two progress lines on your Gantt chart, and things may have gotten a little ugly.  As you move the task bars, the progress lines will update.  Tasks before the progress line will cause the line to go leftward (that’s the ugly part).  What good are they?  Backward facing lines are those tasks you need to move forward.  They need to be rearranged to meet your current project plan.  The image below is an example.  Notice how the lines go backwards to tasks that are behind schedule.

 

 

–ray

Here, we’ll be showing how to display critical path tasks in Microsoft Project.  The critical path is the sequence of tasks that take the longest to reach the project goal.  The steps below can be used to display your project’s critical path.  Follow these, and you’ll know which tasks threaten the final completion date of the project.   Create tasks to display the critical path: Enter three tasks Make the second task twice as long (in duration) as the first task Link the first task to the last task Link the second task to the last task At this point, the tasks should look like this.  Both the first and second tasks link to the last one. Two tasks, links to final task   Group the tasks by critical path: Choose Project, Group By, Critical Or, choose ‘Critical’ from the ‘Group By’ dropdown in the toobar After choosing this menu item the tasks will be grouped differently.  All the tasks that are not in the critical path will be displayed first (in the in ‘Critical: No’ group).  All the tasks in the critical path will be in the second group (‘Critical: Yes’). Tasks grouped by ‘Critical’   Format the Gantt column: Right-click in the Gantt column Choose Gantt Chart Wizard Click Next Click the ‘Critical path’ option Click Finish Click Format It Click Edit Wizard After formatting the Gantt column, the task bars in the critical path will turn red. Critical path task bars are red   –ray

Ever wonder how to reduce your Microsoft Project file from thousands of tasks down to a manageable few hundred, without deleting any?  Have you tried filtering?  This post discusses the steps to filter tasks in Microsoft Project.

Filtering is the act of reducing the number of visible tasks so that you only see what you are interested in.  All the tasks will still exist in the MPP file, but you will only see tasks that correspond to your filter criteria.  Follow these steps to filter tasks in Microsoft Project.

Create some tasks to filter by:

1. Enter three tasks
2. Set the durations to 10 hours, 20 hours, and 0 hours
3. The results should look like the image below

 

 

 

Set up a new filter to show long tasks only:

1. Choose Project, Filtered, More Filters…
2. Click New
3. Enter the name “Long tasks” (without the quotes)
4. Click ‘Show in menu’
5. Click in the ‘Field Name’ column, and choose ‘Duration
6. Click in the ‘Test’ column and choose ‘is greater than’
7. Click in the ‘Values(s)’ column and enter 10
8. Click OK to save the new filter
9. Nothing should change in your view

 

Activate your task filter:

1. Choose Project, Filtered, Long Tasks (the new filter you created)
2. Your view should now look like this image (hiding all the short tasks)
3. Choose Project, Filtered, All Tasks to remove the filtering and show all tasks

 

 

 

–ray

Microsoft Project offers calendars that can be used to set the working hours for a project and the resources working on it.  In other words, you can set the base calendar for the project, and then override that with resource work times.  This post discusses how to set the working time in Microsoft Project.

The following steps will illustrate the effect that working time has on a task in a Microsoft Project file.

Set up a new task:

1. Enter a new task
2. Enter 8 hours for the Duration
3. Enter your Name as the Resource
4. You will notice that the task occupies one day  See below.

 

 

 

To change the base calendar for the project:

1. Choose Tools, Change Working Time
2. Choose “Standard (Project Calendar) from the dropdown
3. Hold down the control key and select all the working days of the month
4. Remove the 1:00 PM – 5:00 PM hours (to make half days)
5. Notice that the calendar has changed to show your new choices
6. Click OK, and notice that your task Gantt bar has gotten longer to accommodate the fewer hours per day.

 

 

To change the individual work hours for the resource:

1. Choose Tools, Change Working Time
2. Choose your name from the dropdown
3. Click on the second day of the task
4. Hold the control key down and select three days
5. Click the “Nonworking time” choice to signify a vacation
6. Click OK, and notice that the task has gotten every longer

 

 

–ray

This post discusses how to perform resource leveling in Microsoft Project.  Before we perform the steps, we should first define resource leveling.

Resource leveling is the act of moving project tasks so that employees are not over allocated.  In other words, tasks are moved to new dates so they are not all piled on top of each other.  This ensures that resources have steady work without gaps and without excessive demand.

Microsoft Project can perform a one-time leveling, or automatically perform it each time a task is changed.  Normally, resource leveling is most effective for projects that have tasks with constraints.  For instance, a task may be set to ‘Start No Earlier Than’ a certain date.  This constraint forces the task to start after a specified date.  Other tasks may need to be split to start before and after this task.  In fact, the example below demonstrates this exact scenario.

 

First, setup a new project:

1. Create two new tasks
2. Add resources to the tasks
3. Set the task durations
4. The tasks should look like the image below

 

 

Set a task constraint:

1. Drag the first task to the right so it overlaps the second task
2. Notice the task icon in the information column
3. Double-click on the task to see the Task Information dialog
4. Click the Advanced tab to see the task constraint

 

 

Level the tasks:

1. Choose Tools, Level Resources
2. Click Level Now
3. The results will be a split task that allows the resource to work before and after the first task.

 

 

–Newshirt