Project Planning without Excel

Are you frustrated with spreadsheet-based project plans?

Do you struggle when creating, editing or updating spreadsheets used as project plans and schedules? Figuring out formulas got you down? Has sharing project data via spreadsheets become cumbersome or untenable during the life of your project? If you answered YES to any of the above, then this post is for you…

Software-wise, struggling with spreadsheets during the planning, execution and closing of projects is one of the most common complaints from planners that are both new to the job or have years of experience. This is not a failing of the manager, but of the tool used! Users of Excel, Smartsheet or other spreadsheet packages face unnecessary difficulties because of the tool itself; here are just three reasons why that software choice is problematic:

  1. Spreadsheet applications (such as Excel) are generic tools that need to be customized to be useful (for example, when formulas and/or macros are written to calculate project data). 
  2. Some spreadsheet applications (such as Excel), are difficult to share with the project team, and these critical project files face problems when emailed or networked with other users. 
  3. Online spreadsheet applications like Smartsheet or Google Sheets are easier to share than say Excel (because online apps are built with sharing in mind), they don’t include means or methods to calculate costs of any resources planned and later used. (And without that, what are you really managing?)

Specifically, let’s take Excel (out-of-the-box) as an example and look at some of the critical PM features that you are not getting from this app: 

  • Excel does not store baseline data on how your plan has changed over time. In fact, there is no log of changes whatsoever, unless you create one on your own.
  • Excel does not calculate critical paths, unless you program it to do so. 
  • Excel does not automatically create Gantt charts, and creating one from scratch is an exercise in futility as data changes over time.
  • Excel does not automatically track resources, thus keeping you in the dark over time.
  • Excel does not have canned reporting tools geared for project management; for example, for creating milestone, budget or resource reports.

This deficiency list goes on a bit longer, but you get the idea; Excel is just not up to the task of being a project management tool without a lot of needless work on your part. Much of the same can be said of another popular spreadsheet tool - Smartsheet - which is advertised specifically for project work, but is lacking the following critical features:

  • Smartsheet does not allow individual calendars for individual resources used within your plan, so precise time management is near impossible.
  • Smartsheet does not facilitate project budgeting, as there is no way to track what the cost of people or material resources are costing during the life of your project.
  • Smartsheet does not allow for offline editing of your plan, at least not without a lot of file manipulation and make-work.

Smartsheet (and other online PM tools) are walled-off gardens, inhibiting the quick growth of teams and making common cloud-file sharing that more difficult.

Looking to Project Plan 365 and/or Microsoft Project…

Both Project Plan 365 and the more expensive Microsoft Project are highly capable and proven PM tools that work for any type of project imaginable, and with little tailoring or setup time. Both of these PM apps provide the project manager with a feature set that covers any need during the life of a project – from custom reporting to advanced budgeting and calendaring – to the precise tracking of tasks, resources and costs. 

Either are excellent choices… but what if you didn’t have to choose at all?

In reality, you don’t. You can use either of these great apps interchangeably with your project files – files created in one or the other! That’s because both tools use a common file format (.MPP). The .MPP file format has been around for decades, and is probably the most popular container of project data in the world (outside of spreadsheets).

The MPP Triad
The .mpp triad - use Project Plan 365 to open files anywhere, on anything!

For example, say you start out with a small project team using Project Plan 365, and your team builds a portfolio of projects. Then say in the future, your small team hooks up with another team of planners using Microsoft Project, and would like to contribute to your established portfolio of plans. Not a problem; as both teams can share their files and exchange them back and forth with no effort at all. (Something that the more expensive Primavera cannot do). This compatibility allows small project teams (or smaller orgs) to grow into larger enterprise teams without any rework whatsoever. 

However, Project Plan 365 works well for small or large enterprises equally as well. That upward migration to the more expensive-per-seat Microsoft Project would only be needed if a feature or function is required that exists only in Microsoft Project; of which there are just a few exceptions (see this comparison chart for details on the differences). Also see this blog post by CEO Sorin Fiscu on leveraging your Microsoft Project investment for those thinking of a mixed environment that includes both Project Plan 365 and its big sister, MS Project.

Closing notes...

To start planning without using a common spreadsheet app, and to begin weaning off inefficient and ineffective project spreadsheets,  download a 30-day free trial of Project Plan 365 - you'll be planning better in no time! 

Turbo-charging Your PM Tools for Better Construction Productivity

Turbo-charging Your PM Tools for Better Construction Productivity

According to Mckinsey Research, the number one laggard in global productivity for the past several decades has been the Construction Industry, which even falls well below the total economic average for just about everything. This dismal state of affairs comes on the eve of what is expected to be an infrastructure boon spanning the next few decades. One has to wonder: isn’t this the perfect time to revolutionize and retool? Yet a recent Economist report as well as a McKinsey Research study shows an industrial-size reluctance to make the move.

This reluctance to digitize and revolutionize the industry by turbo-charging industry software tools and methodologies is clearly holding us back and limiting our growth. Study after study tells us this. However, a shift in spending is starting to occur; this from the same study:

Clearly, the industry is starting to move towards productivity tools fit for the modern age. Are you? But what exactly are we moving towards, in terms of tools? What software innovations actually improve productivity? These are all valid questions to ask...

How Does a Good PM Tool Improve Productivity?

Unlike general business tools, project management software deals specifically with what, say, a construction manager would be most concerned with: costs / scope / schedule and of course quality with a little risk management thrown in. Tools like Microsoft Excel and many new “project management” websites cannot help us much in this regard, at least not without a lot of effort and expense.

However, tools like Microsoft Project and Oracle Primavera do just that; they help you balance costs over schedule over scope with ease and precision, which is just what you want to do in order to improve your productivity. These two heavy hitters have been around for decades, but they come with a high price tag and constrictions for the average construction manager. For example, with these two “top-tier” products, the project manager is constricted to working behind a desk, instead of on the job site where they might want to be. In addition, tools such as these can run into the dark side of margins and might not be affordable for small-to-midsize businesses. So better project-management software would have these important attributes:

  • Be able to juggle project costs, scope and schedule with ease.

  • Have built-in or automated methods for the construction industry.

  • Be portable enough to work on the job-site, and sharable across team members

  • Be relatively inexpensive, as not to negatively influence the bottom line.

Project Planning Construction Projects
"Our survey revealed that more than 44 percent of respondents have adopted some type of digital technology, and planned adoption within the next three years is expected to reach 70 percent.”
McKinsey Research, 2018
“The trade as a whole is reluctant to spend money on the sorts of technologies, from project-management software to mass production, that have revolutionized so many other industries”
The Economist, 2017
“The construction sector has much to do…infuse digital technology, new materials, and advanced automation. Construction lags significantly behind other sectors in its use of digital tools and is slow to adopt new materials, methods, and technology”
McKinsey Research, 2018

Introducing Project Plan 365: A Turbo Tool Built for Construction

Project Plan 365 is a project management tool that helps the construction manager do what they need to do; all without the heavy price tag of say a Microsoft Project installation. Project Plan 365 allows you juggle project costs, scope and schedules like a pro, and even allows you to take your plan out to the field - so you can collaborate & coordinate with your on-site teams.

With a Project Plan 365 schedule, you can clearly see factors causing delays or balance resources in real-time while communicating any changes to others that need to know. Even if you are already working with Microsoft Project files, you can open those in Project Plan 365 with no data conversion needed – just pop open the file and go, even if all you have on hand is a simple smartphone or tablet.

Project Planning Construction Projects Screen Capture
Sample Construction Project within Project Plan 365 for Mac

How Project Plan 365 Benefits the Construction Manager…

  • Project Plan 365 connects the head office with teams working on-site; in essence allowing team collaboration no matter where managers or workers are located.

  • Allows everyone to view the schedule in whatever format suits them: Gantt charts, calendars, data sheets, etc.

  • Project Plan 365 is driven by real numbers, making updating in real-time possible; never work from an old plan again!

  • Project Plan 365 is the most cost-effective tool in the industry, yet is compatible with the most expensive (Microsoft Project 2016 and Primavera P6).

How to Start Your Next Construction Project Plan…

  1. Download and install the Project Plan 365 trial for whatever platform or device that you prefer.

  2. a) Start a new plan, or b) open an existing plan (in MPP format) or c) use the built-in starter template called Commercial Construction

  3. Edit your plan and save to any convenient cloud location like Dropbox, OneDrive SharePoint, etc.

  4. For more help, see the Project Plan 365 support library or check out this case study video for the Construction Industry. Also available is the popular Quick Start video.