Author: Bonnie Biafore

Bonnie Biafore is the author of O'Reilly's Microsoft Project: The Missing Manual (2007, 2010, and 2013 editions) and Microsoft Press' Successful Project Management: Applying Best Practices and Real-World Techniques with Microsoft Project. She's recorded Project Essential Training (for 2010 and 2013), Project Management Fundamentals, Managing Small Projects, and other courses for lynda.com. As a consultant, she manages projects for clients and wins accolades for her ability to herd cats. She has also written a humorous novel about hitmen and stupid criminals. You can learn more at Bonnie's website or email her at bonnie.biafore@gmail.com.

The Project Communication Plan

The Project Communication Plan

For small projects, communication can be quite simple. Communication for the project of heading home after the holidays might be no more than “Call us when you get there.” But good communication grows complex as the scope of the project increases, more people are involved, and teams are scattered around the world. For example, a conference call that includes people in Europe, Asia, and North America is going to keep someone up late and get someone else up early, and you don’t want to make those decisions at the last minute. By planning your approach for communication in advance, you can provide the right information to the right people, at the right time, in the right format, and with the right emphasis. Your road map is the project communication plan, illustrated by the first page of a sample communication plan in Figure 11-1. This section describes the components of a communication plan, how you choose the communication methods appropriate for your project, and how to create a communication plan. Project File: A sample communication plan, Communication_Plan.docx, is available in the Chapter 11 folder on the companion website. See below for instructions. Figure 11-1. A communication plan can be as simple or as sophisticated as your project requires for delivering information to the people who need it. Who Needs to Know? The first step to creating a communication plan is identifying who needs to know something about the project. Stakeholders are obvious audiences for project communications, but other groups often need or want project information. As you build your communication plan, ask stakeholders and other groups you’ve identified as audiences if there’s anyone else who needs to know something about your project. Here are some typical audiences, both stakeholders and ancillary groups, you might include in a communication plan: The project team is the core of communication. Team members work on the project every day. They need to know what’s going on with the project, but they also contribute a lot of the information that you communicate to others. Management stakeholders aren’t dedicated to the project, but they make key decisions about it. Management stakeholders share similar needs for project communication and can include customers, the project sponsor, a steering committee or leadership team, members of the change management board, functional managers, and so on. Note: The customer is part of the management stakeholder group, but often wants different information delivered in different ways. The project sponsor is also part of the management stakeholder group, but is usually involved more intimately with the project. For example, you might send the project sponsor the same information that you provide to other management stakeholder groups, but also meet face to face for in-depth discussions. Supporting groups might be involved in your project from time to time and need to know specific information. For example, sales and marketing might want to know what the product features are and when it’ll be ready to sell. The legal department gets involved only to work on contracts or to review documents for legal issues. Other supporting groups include operations, manufacturing, IT, and other departments. External audiences can be very involved in your project. For example, vendors, suppliers, partners, and the project managers who work for them can belong to your core team. However, you typically don’t tell external audiences as much as you do internal team members. For example, if you’re trying to resolve issues, you’d include external audiences in those discussions only if they are directly affected. Investors and regulatory agencies (such as the IRS or a public utility commission) might represent additional external audiences. For these audiences, the format and schedule of communication is often already specified, such as the financial statements that the SEC requires. Tip: As you develop your communication plan, the golden rule is to give the audience what it wants. Just as a Gantt chart might make perfect sense to you and not one whit to the customer, the methods of communication you choose must actually get the message through to your audience. And if that means you have to prepare a Microsoft PowerPoint presentation for the steering committee, a Microsoft Excel spreadsheet for the accounting department, a Microsoft Word document for project teams, and a Microsoft SharePoint site for the developers, so be it. After all, your job as project manager is to make the project a success, and communicating information successfully is a big part of that. Best Practices: It’s better to send information to too many people than too few, suggests Ron Taylor, founder of the Ron Taylor Group and PMI’s 2008 Leader of the Year. Mr. Taylor’s approach is to give people the opportunity to opt out of receiving specific types of information. However, opting out has one downside that he makes sure everyone understands up front. To make sure responsibility lies where it belongs, anyone who opts out of receiving communications must abide by decisions that are made without their input. What Do You Communicate to Audiences? Sad but true, people hear only what they want to hear. Your customer might care deeply about the return on investment (ROI) of the project, but using ROI to inspire team members to complete their tasks more quickly probably won’t deliver the results you’re hoping for. For all audiences that you’ve identified, the next step is to determine what they need to know, what they want to know, and what information you want to tell them. For example, the customer, project sponsor, and management stakeholders need status reports, but they also want information about the project strategy and issues and risks that might affect the business objectives for the project. Functional managers need status information in order to plan their people’s time. Usually, you want to distribute some information that audiences don’t think to ask for. For example, you communicate the benefits of your project, the problem statement, and the project objectives to everyone involved, even though team members might want to know only what their task assignments are. For another example, if a project is going to change how processes in your organization are going to work, you can begin to tout the benefits of the changes. You can categorize project information in different ways. For example, you might categorize information based on what different groups need to know: planning, day-to-day detailed status, high-level status, and general information. You might also categorize information by whether it’s required, desired, or merely for reference. This section describes information you typically communicate in projects and then categorizes it by the groups that use it. Tip: Keep track of each type of information that you provide to each audience because the distribution method and timetable you choose may vary based on the information. For example, you might distribute project status every week while the stakeholders want a thorough financial update once a month. Types of Project Information The information that you communicate varies depending on whether you’re planning, executing, or closing the project. Here are types of project information that you distribute by phase in a project: Project planning: The components of the project plan help people involved with the project understand the purpose of the project and their roles in completing it successfully. From the problem statement to the schedule and the communication plan, each component describes how you plan to run the project. Some audiences review planning documents in detail and approve them, whereas other groups use them simply as direction for the work they perform. Project execution and control: Once the plan is approved and you begin to execute that plan, people need to know the rules. You have to provide people with procedures, such as reporting time and expenses, requesting time off, escalating issues, and so on. For most of the project duration, people need to know the status of the project and what’s planned for the near future. The status you provide varies by the needs of the audience. For example, the elegant programming shortcut that is helpful and fascinating to the development team would put management stakeholders to sleep. On the other hand, the financial measures that the management stakeholders can’t live without would be equally boring to most technical folks. Project closure: You wrap up projects with reports that summarize the performance of the project. Project publicity: Regardless of the phase a project is in, you want to build enthusiasm and commitment for it. Publicizing a project early on might include announcements in the company newsletter, contests to name the project, or road shows that describe the purpose and benefits of the project. During project execution, you might use a project newsletter to publicize accomplishments, host celebrations upon completion of significant milestones, or distribute pens or coffee cups emblazoned with the project logo. And nothing beats meeting stakeholders and team members one-on-one to build commitment. Management Stakeholders Management stakeholders, including the customer, project sponsor, and other high-level stakeholders, typically care about the overall business goals of a project. Early on, they evaluate the project plan to ensure that it meets their needs. During project execution, they frequently review performance, such as how much progress has been made, how much money has been spent, and the quality of the results that have been achieved. Most of the time, they don’t want to know the details, although they will for significant issues, such as someone absconding with project funds. Note: As internal customers, company executives often require more detailed project information than external customers. They must evaluate project performance compared to the entire portfolio of the company’s projects and business objectives. Here is some of the information that management stakeholders want to receive: The project plan: During planning, management stakeholders must ensure that the proposed plan satisfies their needs. Later, if requirements or criteria change, these stakeholders revisit the project plan while negotiating change orders, contract revisions, or modifications to the Project Goals. Project status: Executive summaries of project status focus on high-level performance and accomplishments. Management stakeholders want to know about major milestones that have been completed, summaries of costs and schedule performance (the project is one month behind schedule and $20,000 over budget), and major issues and risks that could prevent the project from achieving its goals. If you are measuring other aspects of project performance, such as lines of code written or statistics about defects found and fixed, they want to know whether the metrics are good or bad and about the trends in performance. Financial information: These stakeholders understand and care about the financial measures for projects, so they want to know the current financial results, including performance compared to the budget and other metrics, such as ROI. Change requests: Some management stakeholders need to know about change requests. For example, the customer, project sponsor, and members of the change management board must evaluate change requests to see whether they should be approved or rejected. Tip: Executives plan for the long term, so they also want to know what is in store for the project in the future. Is the project going to deliver on time and under budget Will it deliver the financial results they want Will it achieve its objectives Or are changes necessary? Functional Managers Functional managers usually provide the people who perform the project work, so they need to see project plans to understand the skills required, to know when their people are needed, and to be aware of any constraints, such as cost or availability. Once people are working on assignments, functional managers want to know how much longer those people are needed or might ask if they can substitute someone else. Here is typical information you might communicate to functional managers: Project plan: During planning, functional managers must understand the big picture of the project, but they focus on work packages, the skills needed, and when assignments are scheduled to occur. Project status: Functional managers need to know when their people will be done with their assignments, so they can line up more work for them in the future. Team Members Initially, team members must understand the work they are supposed to perform as well as how that work fits into the big picture of the project. This information helps them make good decisions in their day-to-day work. As work progresses on the project, team members need to know detailed status about completed work and the work that’s scheduled for them in the near future. Here are some types of information that team members need: Assignments: Team members want to know what work they are supposed to do and when. Status: Team members need to know the status of their work and related tasks. With status updates, team members can collaborate with their colleagues and help devise solutions to problems. Issues: Team members need to know about issues that might affect them, proposed solutions, and how closed issues were resolved. Lessons learned: Team members can work more effectively if they can take advantage of tips, shortcuts, or practices to avoid. Decisions: Team members must know about any decisions that affect the direction or objectives of the project, so they can conform to the new guidelines. What Communication Method Should You Use? The last step to developing a communication plan is to determine the best methods for getting each type of information to your audiences. You must decide how often audiences need information, the best method for delivering information, and the best format in which to deliver it. For example, everyone involved in the project needs a project status report, which you might distribute via email to the entire team but review in a meeting with stakeholders. Your organization’s executive team meets once a month and wants an executive summary of project status with emphasis on the budget and financial measures. The project sponsor prefers to meet in person to review status, issues, and risks. And team members have asked you to distribute the detailed status reports of team accomplishments every week. Communication methods come in many guises and each one has its advantages and disadvantages. For example, face-to-face communication is best for delicate discussions or to brainstorm solutions. Conference calls and email come in handy for teams that are distributed geographically. Documents in paper or electronic format are ideal for communicating large amounts of information that require study. Here are some considerations for communication methods: Status reports: These can contain different types of information depending on the audience. Moreover, whether you produce paper or electronic status reports depends on the audience as well. Sending status reports to people makes it easy for them to read the information, and they can choose to scan the reports for pertinent topics or ignore them if time is at a premium. Note: When you distribute documents electronically, you have to consider the software formats that your audiences can read. For example, if some team members have older versions of Word, you might choose to distribute reports in Adobe Acrobat or Microsoft XPS Document Writer format. Don’t forget that most people in your audiences won’t have Microsoft Project, so you should save Gantt Charts and other Project views as pictures, PowerPoint files, or web pages. Meetings: These can vary from one-time kickoff meetings to daily meetings of small groups of team members, weekly or monthly executive updates, or occasional all-hands meetings. Although you can’t guarantee that people will pay attention in a meeting, getting people in the same room is ideal for discussions, brainstorming, and decision making. You have options for how you deliver information in face-to-face meetings. For example, an executive update meeting might start with a presentation of project status followed by an energetic discussion. Other meetings, such as lessons learned sessions, can be completely dedicated to group discussion. Conference calls and videoconferencing: These are options for meetings when people are distributed geographically; however, they are not ideal if you are working through issues or dealing with a team that is “storming.” In situations in which tension is high, a videoconference or Microsoft Office LiveMeeting provides more effective interaction. Sending documents to people: This is preferable if you want the recipients to take action. For example, if you want stakeholders to review and approve your project plan, you should send the plan to them for review. However, the best way to obtain approval and signatures is to hold a meeting. Storing documents: This is a reasonable solution for information that only some people need only some of the time. For example, you can store any document-based deliverables, such as the current project plan, requirements, specifications, change requests, and other project information in a shared folder, on a web page, or in a shared workspace. People who need the information can retrieve it when they need it. Newsletters and email distribution lists: These work well for announcements and other information you want to disseminate to broad audiences. You can distribute information to many people without much effort, but the readers can skip the message if it doesn’t apply to them. Note: Many companies use products/services like Microsoft Teams, Slack, or online project management tools. These tools are great for corralling project information and communication in one place. Be sure to use the features in appropriate ways. For instance, don’t post status reports in the chat. Keep them in the doc storage area. Resolution Is What’s Important If you want someone to do something, sending an email or leaving a voice message is not the same as getting something done. If you have an issue that’s delaying your project, you can’t afford to wait until the person you contacted decides to act. The most effective way to obtain a response to a request is to tell people up front what you want them to do and when. For example, an email that scrolls for pages before you get to the point will be deleted long before the recipient knows what you’re asking for. Put requests in the first paragraph of an email, memo, or other written communication. State requests in the first sentence of voice messages. You can follow up with the why’s and how’s after that. After you’ve sent requests for action, you must follow up if you don’t receive a response when you expect. If a return email doesn’t arrive, follow up with another email or a telephone call. (Emails get caught in spam filters all the time, so don’t begin your follow-up with an accusation.) If a voice message goes unanswered, find the person or someone else who can help. Some folks don’t respond no matter what you do. One way to coax responses from people who do that is to tell them what you plan to do if you don’t hear from them by a specific time or day. If your contingency plan is something you know they don’t want, you’re almost guaranteed to receive a response when you need it. For example, “Hi, Dale. I really need the graphic for the brochure by tomorrow morning at 9:00 A.M. If I don’t have it by then, I’m going to use the photograph of the meerkat. Thanks for your help.” If someone still doesn’t respond, diplomatically escalate your request. If you do ask for help, it’s a good idea to tell the managers you ask what you would like them to do. Otherwise, they might apply more pressure than you intended. Of course, you must be willing to go with the picture of the meerkat if you still don’t get a response. When you choose communication options, opt for the ones that get information to audiences with the least amount of effort. For example, don’t send hard copies of status reports if everyone on the project checks email every day. An email distribution list is much easier than printing and distributing dozens of hard-copy memos. However, for some information, such as reports that government agencies require, you have to use their format and transmission methods. Tip: Although the ideal approach is to provide every audience with exactly what they want, some communication methods can be extraordinarily time-consuming. If communication demands threaten to consume every workday, try suggesting to stakeholders alternatives that require less time. Building a Communication Plan The communication plan begins with sections that list the audiences for the project, the information you plan to communicate, how you will compile the information, and the communication methods you plan to use. But the heart of the communication plan is a matrix that shows how you plan to communicate information to each project audience, as illustrated in Figure 11-2. Figure 11-2. A matrix like the one included on page 2 of the sample communication plan is helpful for showing the information you communicate to audiences and the methods you plan to use. Tip: Although the communication plan is often a part of the project plan, it’s a good idea to publish the communication plan as a stand-alone document. That makes it easy to keep a copy handy for quick reference. Project Status Reports Project status reports keep people informed about the progress that’s being made on your project and what’s happened in the recent past. These reports are important and can be chock-full of information, but brevity is a virtue. The key to reporting project status is to be concise while still delivering information that people need or want to hear. Here are some guidelines for producing effective project status reports: Use a standard format: The people in your audience can find the information they need more quickly if you deliver project status in the same format each time, as demonstrated by the project status report template in Figure 11-3. Develop a template for your project status report and include notes about how to fill it in. Figure 11-3. By using a template for your project status report, you won’t forget to include important information, and readers can find the information they need more easily. Begin with a project status summary: Key stakeholders appreciate a summary of status, so they can decide whether they must review the entire report in detail. Include major accomplishments, issues, risks, and plans for the next period. Review the budget and project schedule: Summarize the budgeted and actual costs and the planned and actual dates for the status period, and explain significant variances (more than 10 percent). Note: As project manager, be sure to define the meaning of significant variance during project planning. A 2 percent variance on the backyard remodel project might be insignificant. The same 2 percent variance could be catastrophic if your project has a hard deadline. Focus on accomplishments: Achieving goals and handing over deliverables is more important than the detailed tasks that led up to them. Publicize successes, such as effective practices, shortcuts, clever solutions, and so on. Document lessons learned: By publicizing effective techniques or ill-advised approaches, other team members can be more productive. Report the status of significant issues and risks: Describe the progress made toward resolving issues and managing risks during the last status period. Identify issues that have been closed and risks that have been successfully resolved. Also, document the risks that were avoided by implementing plans to circumvent those risks or because the work packages that were at risk have been delivered without issue. Create and distribute status reports on schedule: If a status report isn’t important enough for you to send it out on time, your readers might not consider it important enough to read. Best Practices Poorly written project status reports can raise more questions than they answer. Here are some tips for producing status reports that truly inform your audience: If you include activities that are in progress, also include when they will be complete. Include the results of meetings, discussions, training sessions, and so on. Include specific, quantitative results. Use numbers rather than terms, such as few or numerous. Take the time to correct typographical errors and grammatical errors. Proofread the report for errors that Word doesn’t catch. Include links to a project repository, so readers who want more information can locate it without calling you. To download the companion content referenced in the text, visit The Microsoft Press Store and click on Downloads in the middle of the page. From Successful Project Management: Applying Best Practices and Real-World Techniques with Microsoft Project by Bonnie Biafore, published with the authorization of Microsoft Corporation by O’Reilly Media, Inc., 1005 Gravenstein Highway North, Sebastopol, CA 95472. Copyright 2011 by Bonnie Biafore. Purchase Successful Project Management: Applying Best Practices and Real-World Techniques with Microsoft Project by Bonnie Biafore here. Related Content Webinars (watch for free now!): Leveraging Project, Project Server and Project Online for Better Communications The Basics of Schedule Planning – It’s ALL about Communication Articles: Communication: 5 Ways to Improve Your Project’s Lessons Learned Size Matters (in Plan Communications)

Project Management Methodologies: Managing with Your Methodology

Project Management Institute (PMI)® Professional Development Units (PDUs): This Webinar is eligible for 1 PMI® PDU in the Strategic category of the Talent Triangle. Event Description: Regardless which project management methodology you choose, you’ll still guide your projects through a project lifecycle. The methodologies differ in how they progress through the lifecycle’s stages or phases and how you schedule and manage the work that’s performed. In this session, we’ll explore implementing these methodologies in more detail. In addition, we’ll look at scheduling for these methodologies in Microsoft Project. Presenter Info: Bonnie Biafore and John Riopel Have you watched this webinar recording? Tell MPUG viewers what you think! [WPCR_INSERT]

Project Management Methodologies: Methodology Meet-up

Project Management Institute (PMI)® Professional Development Units (PDUs): This Webinar is eligible for 1 PMI® PDU in the Strategic category of the Talent Triangle. Event Description: Project management isn’t one-size-fits-all. The methodology that makes sense for your organization depends on the types of projects you perform, how you manage resources, and your corporate culture. In this session, John Riopel and Bonnie Biafore describe several of the most popular project management methodologies (such as traditional waterfall and rolling wave, as well as agile ones, such as scrum, lean, or Kanban), how they differ from one another, and when to choose each one. Presenter Info: Bonnie Biafore and John Riopel   Have you watched this webinar recording? Tell MPUG viewers what you think! [WPCR_INSERT]

Five Tips for Building your Organization’s Methodology

Five Tips for Building your Organization’s Methodology

Many people are confused about what a methodology is, because the word is misused frequently. According to PMI’s PMBOK® Sixth Edition,  methodology is “a system of practices, techniques, procedures, and rules used by those who work in a discipline.” But, what does that mean? Are the phases in a WBS a methodology? No, a WBS is simply a way of organizing work, whether by project phase, deliverable, or financial categories. What about the critical path method? Is that a methodology? Nope, it’s a method for calculating the longest path of activities in a schedule. What, then, is a methodology? And, just as important, how do you use it effectively? Let’s break down what goes into a methodology according to the PMBOK definition: Practices: One example is a set of best practices for project schedules, such as having complete network logic, not using date constraints, and eliminating redundant task dependencies. Techniques: The critical path method counts as a technique—in this case, to calculate project duration and identify the critical path tasks. Tools (such as Microsoft Project, Primavera, VersionOne, Rally, and Jira) and templates (like a change request tracking spreadsheet or a requirements template) also fall into the techniques category. Procedures: The documented steps for requesting, managing, and tracking change requests are an example of procedures you might define as part of your project management methodology. Procedures also include guidance on when to use specific tools. For example, a procedure might indicate that specific procurement processes and tools must be used for projects that cost more than $500,000 and use third-party resources. Rules: An example of a rule is that a change request estimated to cost less than $1,000 and require less than two days effort can be approved by the project manager without going to the change control board. We will argue that a methodology requires another thing: that people in the organization actually use the components of the methodology. If no one follows the practices, techniques, procedures, and rules, you have a wishful thought, not a methodology. When you have a methodology in place, it’s important to assess whether people in the organization are using the methodology correctly. That’s not all. In the interest of continuous improvement, you also need to measure results to see whether the methodology adds value to the organization. Just like with cookie recipes for great cookies, there are many ways to build an effective methodology. The following tips will help you develop an efficient and effective methodology for your organization: Identify processes and procedures: Processes describe functions at a higher level. For example, in the PMBOK®, Develop Project Management Plan is a process. Step-by-step guides for building resource management plan and your project schedule are procedures. As you build your methodology, you need to identify the processes and procedures people will use to manage projects. Document the components: Creating templates and defining processes and procedures isn’t enough. It’s just as important to document how, when, and why to use each template, process, or procedure, so people in the organization can apply them appropriately and efficiently. Keep it simple: Most organizations try to do too much too quickly. You don’t have to do everything at once. Instead, develop processes, procedures, and tools to address the most problematic area before moving to the next. That way, changes are smaller and easier to implement, and results are easier to measure. After you implement a new aspect of the methodology with a small team, determine whether it provides value. If it does, make it an official part of your organizational methodology. Use procedures and techniques correctly: Tools can be implemented in several ways. Think about all the different ways people use a tool like Microsoft Project. You need to make sure that people follow the defined procedures and techniques. For example, if your organization has customized Microsoft Project, project managers need to follow naming conventions or fill in custom fields correctly, in order for the customizations to work. Another example is to follow the best practices your organization has defined for project scheduling. It’s important to make sure that people follow the instructions. You might hold a review session to evaluate whether a project schedule has followed all the guidelines. Measure and report on the methodology’s value: A methodology isn’t supposed to be just another checkbox to mark. It’s meant to provide value to your organization. Don’t require everyone to use it and stop there. To see whether the methodology adds value, you need to evaluate the practices, processes, procedures, templates, tools, and rules. Work with stakeholders to identify the improvements you want to measure, such as percentage of schedules adhering to the scheduling best practices. In addition, you might want to measure time spent managing the schedule to see if the best practices are producing more accurate, more flexible schedules. Once you identify the measures, develop reports so it’s easy to evaluate the methodology. Watch our webinar on-demand to learn more about Project Management Methodologies. Also, check out our book Practical Project Management with Microsoft Project 2016. Related Content Webinars (watch for free now!): Share the Knowledge: Integrating Your Project Lifecycle Methodology with Microsoft Project Shared Understanding Among Project Stakeholders: A New Methodology for Agile Project Management Articles: The Most Basic Project Management Framework Simple, Powerful, Proven: Logical Framework Approach What is Agile Project Management? Written by John Riopel John Riopel, MCP, MCTS, PMP has over 25 years of experience as a Program/Project Manager in government service and commercial industries. His technical background in Microsoft Project spans the entire evolution of the Microsoft Project toolset, with a deep understanding of how to apply these technology constructs and concepts to real-world project management challenges.He is President and CEO of PM Providers, a full-service project management consulting firm dedicated to delivering business results with project management solutions. View all posts by: John Riopel

How to pick a Project Management Methodology

How to pick a Project Management Methodology

Companies that perform project after project usually pick a project management methodology, such as PRINCE2 or Agile, and stick with it. That way, all their projects follow approximately the same project management processes. Teams learn what works and what doesn’t, and everyone learns what to do and expect. The approach you choose depends a lot on the environment in which you work. Complex environments with large projects, widely distributed teams, or multiple vendors usually need a robust project management methodology with formal, well-documented procedures, standardized forms and documents, and project management software like Microsoft’s Enterprise Project Management Solutions to keep track of everything. Simpler, smaller projects would bog down with that kind of overhead but run just fine with a more informal approach. If you want a ready-made methodology to adopt, check out the following resources: Featured excerpt from Practical Project Management, Bonnie Biafore and John Riopel Related Content Webinars (watch for free now!): Share the Knowledge: Integrating Your Project Lifecycle Methodology with Microsoft Project Shared Understanding Among Project Stakeholders: A New Methodology for Agile Project Management Articles:The Most Basic Project Management Framework Simple, Powerful, Proven: Logical Framework Approach What is Agile Project Management?

6 Tips on Microsoft Project Templates

Microsoft Project 2013 has two types of templates: The global template and the project template. Here’s a rundown: 1. The global template acts as a storage facility for built-in and customized Project elements, such as views, tables, groups, filters, and calendars. It also contains the settings for Project options that determine how the program behaves, such as which task mode it uses when you create new tasks. If you customize the ribbon and Quick Access toolbar, those changes are kept in the global template, too. Project attaches the global template to every new project file you create. That way, built-in elements, customizations, and settings are available whenever you work on a Project file. 2. The project template does double-duty. You can store customized elements in a project template, just like you do in the global template. You can also save some settings, like scheduling options or calculation options, in this type of template. However, a project template can also contain task and resource information—a task list, task links, typical durations, generic resources, and more. For example, once you hold your first fundraiser and find out what it really takes, you can save a project template with all that information. Then, when it’s time to start working on next year’s event, you don’t have to reinvent the wheel. 3. If you’re just getting started with projects, you don’t have to create your own templates. Project 2013 offers dozens of templates covering an array of project types. In addition, many companies offer specialized project templates that you can download. Or your colleagues may have templates they’re willing to share. 4. It’s a good idea to make a backup copy of your global template before you add or remove elements in it. If you want to get rid of elements you added, or retrieve elements you deleted, then you can replace the active global template with the backup copy. Be careful about deleting elements from the global template, because you can delete some built-in elements: views, groups, filters, tables, and so on. If you make a habit of deleting elements in the global template, it’s a good idea to keep a backup copy in case you want to get something back. 5. If you use templates frequently, pinning your templates folder to the folders list makes it easy to access. To do this, in Backstage view, click Open, and then click Computer. On the right side of the Open page, click Browse. In the Open dialog box, navigate to your templates folder, and then double-click it. Click Cancel to close the dialog box and return to the Open page. Now your templates folder appears at the top of the Recent Folders list. Put your pointer over the folder’s entry in that list, and then click the pushpin icon that appears on the right side of the page. From then on, your templates folder will always appear at the top of the Recent Folders list. 6. If you share templates with other project managers, you want the files in a location that everyone can get to, like a shared network drive. You can create a new Project file from a template simply by double-clicking the template’s filename in Windows Explorer. This excerpt was taken from Microsoft Project 2013: The Missing Manual by Bonnie Biafore. Published with the permission of O’Reilly Media, which holds the copyright.

Looking for Tasks Heading for Trouble

Looking for Tasks Heading for Trouble

When you’re trying to keep your project on schedule, keep an eye on tasks. Task delays can push the project finish date later and upset the resource workloads you so carefully balanced during planning, creating resource over-allocations you need to resolve. Watching for ballooning work hours is one way to spot tasks that are in trouble. Just like time that slips away when attic cleaning turns into reminiscing over old pictures, the time it takes to perform tasks can expand beyond your estimates. These extra hours can produce longer task durations and higher resource costs, so it’s especially important to nip these excesses in the bud. This article, excerpted from my book, Microsoft Project 2013: The Missing Manual, shows you how to look for delayed tasks and tasks whose work hours exceed baseline work, even if they haven’t yet delayed the finish date. Here are different ways to look for these at-risk tasks. Tasks That Are Slipping The Slipping Tasks filter shows, well, slipping tasks — that is, tasks whose finish dates are later than their baseline finish dates. These tasks may be scheduled to start late, have already started late or are taking longer than planned. By looking for slipping tasks every week, you may have time to recover from the slip or to prevent it from getting worse. By applying different tables to the current view, you can see dates, variances, work amounts or costs for the tasks in the filtered list. To apply this filter, in the View tab’s Data section, click the Filter down arrow and then choose More Filters. In the More Filters dialog box, select Slipping Tasks and then click Apply. Tasks That Are Slipping or Falling Behind The Slipped/Late Progress filter (View | Filter | More Filters | Slipped/Late Progress) looks for slipping tasks and checks for tasks whose completed work is less than the amount that should be done. The finish dates of these tasks haven’t changed yet, but they’re likely to unless you do something. To look for schedule trends, sort the Variance table by finish date: On the View tab, click Tables | Variance and then, in the table’s header area, click the triangle next to the Finish heading and choose “Sort Earliest to Latest.” That way, tasks appear from the earliest finish date to the latest. If the values in the Finish Variance field grow larger as the finish dates progress, the project is falling further behind over time. On the other hand, if the Finish Variance values are growing smaller, it may be a sign that your corrective actions are working. Assignments That Are Slipping It makes sense that an assignment that slips can turn into a task that slips. The Slipping Assignments filter (View | Filter | More Filters | Slipping Assignments) is a resource filter that you can apply to Resource Usage view to find assignments whose scheduled finish dates are later than their baseline finish dates. One resource with several slipping assignments is a sure sign of someone who could use some help. The problem may be too many tasks at the same time, the wrong skillset or too many distractions. For Power Users: Seeing Status Project offers a couple of features that can help you spot troubled tasks without filtering task lists, which is great because scanning for visual status cues is often easier than wading through numbers. You can customize fields so that they turn red, yellow or green based on progress. In addition, progress lines show whether tasks are ahead, behind or right on schedule in the Gantt Chart timescale. The figure below includes examples of the following status indicators: Custom graphical indicators. To display graphics based on how late or over budget a task is, you can set up a custom field with graphical indicators like a green happy face if Cost Variance is less than 10 percent of the baseline cost and a red unhappy face if Cost Variance is greater than 25 percent of the baseline cost. The custom field “Number4 (Cost Status)” in ProjectMM_Customizations.mpp (available at does that and more, as long as you’ve already set a baseline and have some actual values in your schedule. Progress lines. In the Gantt Chart Tools | Format tab’s Format section, choose Gridlines | Progress Lines. In the Progress Line dialog box that appears, turn on the Display checkbox and then click OK. Voila — Project displays progress lines in the Gantt Chart timescale. A progress line drops vertically from the project status date in the timescale heading and then points to the progress in each task bar. If the task is on schedule, then the progress line continues its vertical drop. If the task is behind schedule, then the progress line points sharply to the left. If you add a deadline to a task, you can visually see when that task is due. If the task expands beyond its deadline date, Project displays a missed deadline indicator in the Indicators column of the view’s table.   Watching Work Hours Work hours that exceed a task’s baseline hours can increase your project’s duration and cost. For completed tasks, of course, it’s too late to make corrections. Still, it’s a good idea to investigate the reason why such overruns occurred, particularly if the same resources are over budget on task after task. You can also check tasks in progress to see if the amount of work you expect is complete. To do that, use one or more of the following Project features. Work Table The Work table shows several work fields: scheduled, baseline, actual and remaining work and work variance. It also includes % Work Complete, which is the percentage of the current scheduled work that’s done. (The sidebar below explains the difference between % Complete and % Work Complete.) Positive values in the Variance column show tasks whose scheduled work hours are greater than the baseline work hours. You can look for tasks that may be falling behind by inserting the % Complete field next to the % Work Complete column in this table. If a task’s % Work Complete value is less than its % Complete value, time is passing faster than work is being completed, which is often early warning for future delays. Work Overbudget Filter The Work Overbudget filter (View | Filter | More Filters | Work Overbudget) shows tasks whose actual work has already exceeded the baseline work, so it’s already too late to recover from this overindulgence. However, if several tasks using the same resource are all completed over their work budget, you can try replacing that resource with one who’s more productive. Slipped/Late Progress Filter Although this filter tests for schedule slip, it has a work aspect, too. It looks for tasks in which the completed work is less than what you’d planned at this point. To apply it, choose View | Filter | More Filters | Slipped/Late Progress. How Much Is Complete? The Tracking table includes columns for actual dates, duration, cost and work, which are self-explanatory. However, the table’s other two columns, % Complete and Physical % Complete, may not be so obvious. The % Complete field shows the percentage of a task’s duration that has passed; it says nothing about how much progress has been made during that time. For example, if five days of a 10-day task have passed, the task’s % Complete is 50 percent regardless of how much work has been done. On the other hand, the Physical % Complete field lets you specify how much of the task is complete for earned-value calculations. Project doesn’t calculate this field. You have to type values like 20%, 50% and so on to tell Project the amount of completion to use. For example, suppose you’re working on a task to put up signs along the route of the cycling event. You have 100 signs to put up and you’ve stuck 40 in the ground so far. In that case, Physical % Complete is 40%. % Work Complete is yet another field for percentage completion, although it appears initially in the Work table, not the Tracking table. % Work Complete is the percentage of actual work compared with scheduled work. If a task’s % Work Complete value is less than its % Complete value, that means the amount of work performed isn’t keeping up with the time consumed, meaning the task could be headed for trouble. This excerpt was taken from Microsoft Project 2013: The Missing Manual by Bonnie Biafore. Published with the permission of O’Reilly Media, which holds the copyright.

Customize ‘Out of the Box’ Reports

A short clip from MPUG’s webinar with Bonnie Biafore and John Riopel. Bonnie demonstrates how to customize a Microsoft Project ‘out of the box’ report to make it more useful. Join MPUG to watch the remainder of this session and hundreds more on-demand. MPUG Premium Members have access to weekly live webinars and recorded sessions including: The Art of Reporting with Bonnie Biafore and John Riopel 1. Learn about Microsoft Project Out of the Box reports 2. Create custom reports using the new Report Designer 3. Create time-phased reports  

  • 1
  • 2
  • 6