Getting to Microsoft Project – on a Mac!

Getting to Microsoft Project - on a Mac!

If you are a project manager using Apple devices, then you know that a PC-bias still exists in the software industry, especially when it comes to anything Microsoft Project. But in 2019, we have options. 

While most all software manufactures provide versions of their apps and services that work on both Macs and PCs, Microsoft does not have a macOS version of Project, making your team project work awkward, indeed. To restore harmony in this fractured computer-verse (Mac vs. PC, Apple vs. Google, iOS vs. Android, Siri vs. Alexa, etc.), there are a number of ways for you and your project team to get to Microsoft Project plans:

  1. The long road, where you use an app to create a “virtual” second computer onboard the hard drive of your MacBook, iMac or MacPro (called a virtual machine), and then you install Microsoft Project within a virtual Windows.
  2. The winding road, where you meander from Safari to the Project Online website (through an Office 365 subscription), or you are directed to some other project website running SharePoint with a Project Server, and that’s where you do all of your project work - from within a web browser.
  3. The short cut 

This article discusses the long and winding road (and reveals the shortcut) in terms of pros and cons, as well as providing estimated “travel” costs for your journey…

1) The Long Road: Virtualizing your Mac to run Microsoft Windows + MS Project

What may sound like a quick jog (just run windows on your Mac) this is actually the road less traveled, and for good reason. This slog involves subscribing to one of many providers of a virtualization layer (Parallels Desktop, VMware, etc.) used before you install any flavor of Microsoft Windows that you may have on hand - and finally, once that’s all up and running, then can you install Microsoft Project and get to your work on an Apple device.

1) The Long Road: Virtualizing your Mac to run Microsoft Windows + MS Project

PROS

  • In addition to running Microsoft Project, you can install and run any Windows app that you want.
  • If something goes wrong with Windows or Project (as things sometimes do), you can just “blow away” that virtual machine and use your automatically created backup copy.

CONS

  • Requires one more subscription to a software service (for example, Parallels or VMWare).
  • Adds another layer to your Mac that needs a bit of worrying about (in addition to everything else that worries you).
  • Creates files so large (after all, there’s an entire computer stuffed inside) you may have to upgrade your Mac’s internal hard drive to something gigabytes bigger.

2) The Winding Road: Using Project Online and all the rest to get there....

There are many reasons that you might want to take the meandering path of using your Mac’s web browser to access Microsoft Project data, but simplicity would not be one of them. If all you want to do is to open, edit or create new Microsoft Project files, then don’t install SharePoint Server or any other servers just to do that – that would be silly and overly complex in this age of cloud computing and software-as-a-service (SaaS). Just jump to #3 for a much shorter path.

winding road

PROS

  • This setup may be essential to your large enterprise (in other words, you have no choice but to follow this path).

CONS

  • If you work anywhere that the internet doesn’t, you are out of luck.
  • If you are a small-to-mid sized business, the expense of it all may bust your bottom line.
  • If you are the Project Manager for your team without dedicated IT support, this could be trouble.

    (It’s easier to raise children then to manage all of these systems.)

3) The Shortest Distance Between Two Points: Project Plan 365

If all you want to do is to collaborate with other folks sharing or creating Microsoft project data, then just download the free 30-day trial of either Project Plan 365 for Mac or Project Plan 365 for iOS. This gives you the flexibility to work on any Microsoft Project-created data file, regardless of your hardware or internet connection. Both apps allow you to do exactly the same thing: open, edit or create any Microsoft Project file (.MPP) with no conversions or imports from other odd formats, like .XML or .XLSX - or any other type of file where things can go wrong and mess with your precious project data. This is by far the “shortest distance between two points” for any Project Manager wanting to work on a Mac.

Current users of Microsoft Project will instinctively know how to use Project Plan 365, as the interface is virtually the same – no learning curve here to slow you down.

In addition, by subscribing to the Business (PMO) plan, project managers (especially those working in small-to-medium sized businesses) can augment their Microsoft Project experience as well, by using such Project Plan 365 features as real-time collaboration, portfolio and resource management and more. In short, a Project Management Office (PMO) can be set up on the cheap and within a few hours after your team subscribes to this plan.

PROS

  • The simplest solution for the stated problem.
  • The cheapest solution for the stated problem.
  • Adds even more to the experience of being a Microsoft Project user, and gives your team more capabilities as you roll out your projects.

CONS

  • None to speak of 🙂 

The Bottom Line...

The bottom line depends on how far you are willing to go, just to get to a Microsoft Project file, or to collaborate with your team who are all using the same set of Microsoft Project data. Must your team use Project Online / SharePoint / Project Server because your management team has made that edict? Well, we feel for you… perhaps a new Microsoft laptop is in your future, leaving your shiny new Mac in the dust. But if not, taking the shortcut (#3 above) is going to save you time and money: 

Road Taken...

1. The long road:

2. The winding road:

3. The shortcut:

Cost per user, per year (in USD)

Approximately $1000

Mega-bucks in Enterprise dollars!

$200

Which solves the problem? #1 yes, #2 not really and #3, sure thing! 

In addition to user cost savings per year, other intangibles are gained, such as the convenience of working on your project plans (or having someone else updating your plan) no matter where in the world you or anyone on your team is working (say on the plains of the Sudan, the beaches of Fiji or atop Mt. Everest) – you will always have a way to edit your Microsoft Project plans on your favorite Apple device.

Project Plan 365 also allows you to take Microsoft Project files and go well beyond what you can do within the Microsoft app; for example, with Project Plan 365 you can build a PMO on the cheap, manage and report on your entire portfolio of projects, and store your files in a private and secure cloud - without having to purchase expensive software servers or buy any more new hardware. 

Leverage your Microsoft Project Investment

Leverage your Microsoft Project Investment

Increasingly, fellow Mac users come to me with this common challenge: how to open, edit, view or even print MPP files (the file format for Microsoft Project) when using standalone versions of Microsoft Project. After researching the problem, I found that Microsoft flat out does not provide a solution, as there is no Mac version of this popular PM planning tool. PMs using Apple computer users are simply left out in the cold.

Of course, one can run Parallels Desktop or some other brand of virtualization software on a Mac, but that seems like a lot of trouble and overhead to accomplish what should be a very simple task: to manipulate Microsoft Project plans using an Apple computer. Virtualization was a non-starter for me, as that would require a hardware upgrade to my simple MacBook.

Many of my clients and even team members here at Housatonic also needed this functionality, so we developed a commercial solution: Project Plan 365 for Mac. Using this solution, existing users of Microsoft Project can leverage their investment and extend their PM activities to any Apple computer, or even work on an Apple device such as an iPad. For teams considering expanding their PMO software suite to include options for Mac users, this solution is also appropriate.

How to…

To work on your Microsoft Project plans while using a Mac, all you need to do is try or buy Project Plan 365 for Mac. Once installed on your Mac, you simply open up any MPP file created in Microsoft Project and then you do what you normally would: manage the schedule, produce Gantt charts, balance resources, monitor costs, etc. etc.

Sample MPP started in MS Project and finished in Project Plan 365
Sample MPP started in MS Project and finished in Project Plan 365

 Project Plan 365 for Mac opens Microsoft Project plans directly and seamlessly (no conversions or importing/exporting needed), and the interface for Project Plan 365 is nearly identical to what you are accustomed to inside of Microsoft Project - no retraining required! And even if some aspect of Project Plan 365 for Mac is unfamiliar, we have a website full of training videos and help articles (in addition to a 24/7 support ticketing system).

Once you are working in Project Plan 365 for Mac, there is the added benefit of being able to edit and view your plans on an iPhone or an iPad – for example, in case you have left your Mac in the office and you are out on a job site with only your iPad in hand. (See this video case study that documents just this situation.)

Next Step…

To start leveraging your investment in Microsoft Project and to start working on your plans using a Mac, simply download and install Project Plan 365 – its free to try and inexpensive to buy.

The Importance of Resource Calendaring

The Importance of Resource Calendaring

With so many projects of late either failing, partially failing or coming in way over budget, those of us in the business of managing projects are concerned, and rightly so.

The reason for project failures and cost bloats are many fold, and this article only covers one problem that falls under the category of resource management - future posts here will cover other reasons, such as problems in task, cost and collaboration management.

While proper calendaring is just one important aspect of resource management, it is often forgotten about amid the furry of rapid project design and implementation.

In our rush to meet project-design deadlines, our up front estimates for human or material resources are often more vague than accurate, and this lack of precision often proves detrimental later on down the project road.

So let's take a look at just how that dynamic works (imprecise calendaring), or in this case, doesn't work to the benefit of project outcomes.

Proper calendaring (or in other words, knowing when your workforce is available for work) is important during all phases of project management, from the initial proposal & budget work-up, to the final analysis conducted once the project is complete.

While your organization may have a standard working calendar (start/end times, company days off, corporate holidays, etc.), it’s important to realize that individuals - and even materials - can have unique calendars that will deviate from the standard one used by your organization, and if not taken into consideration, can skew any plan calculations significantly.

So let's first look at the relationship between a human resource, and their related calendar data points. Figure 1 shows the many related data points for any given human resource.

In addition to these human resource calendar deviations, even materials can be considered to have their own calendar data points - see Figure 2.

 Although with specific materials, you usually have them or not, but machines that use material resources can certainly be thought of as having a calendar with data points.

These points of concern (shift-work times, special leaves and holidays, etc.) are all factors that affect the bottom line, in terms of workforce availability, project costs and length of task durations.

One must look at all of these points combined to get a more complete picture of your project's scope.

Implications during the Initial Phase

So when preparing a proposal for any project, instead of picking a number out of a hat (for resource costs) or relying on an enterprises standard 8-hour / 5-day work week, you can use the above data points to get an much better estimate all of these data points are factored in.

One common example of an error during this phase, is when a globalized company uses a standard US calendar for work being performed in Asia, where workers may be using a 10-hour / 6-day workweek - see Figure 3.

But regardless of location, if these often forgotten factors are not considered, you might be proposing a planned budget and schedule that can never be met.

Implications during the Middle Phase

When scheduling the work, unless precise calendaring is used that takes into account all possible calendaring points, planned schedules will most likely be shorter than the actual outcome, and cause your project to have needless cost overruns and delays.

Implications during the Final Phase

When evaluating project performance during the post-mortem, the results will be skewed by the initial errors in calendaring, and that will not be helpful when repurposing previous project data in order to project costs and schedules for the next like-project coming down the road.

In Conclusion…

So, in this post we have 1) explored the importance of calendaring across all phases of project planning, 2) shown how a single resource has many calendar data points, and 3) been given a simple procedure for getting a handle on your project's workforce availability (and how that affects project scope).

The benefit of proper calendaring should become evident in your next project that takes this knowledge into consideration, so give that a try – since as they say - the proof is in the pudding!

Watch this space for future posts that will help ensure that your project is successful, and never placed into the category of "failed" or "partially failed."

Project Success Rates
Machine Resource Calendar
Figure 2. While materials are not thought to have calendar data points, the machines or processes that use them certainly can! (click to enlarge)
Human Resource Calendar
Figure 1. Human resource calendar data points that may deviate from a standard calendar. (click to enlarge)
Granular calendaring tool
Figure 3. Use a scheduling tool (such as Project Plan 365, Microsoft Project, etc.) that is granular enough to capture important calendaring data points, on a per resource basis. (click to enlarge)