top of page


Updated: Aug 4, 2021


The progress and profit of any project is influenced by a variety of factors from time available to healthy scheduling processes, but without the right people in place a company is never going to truly deliver on outcomes. Yet leaders and managers continue to use outdated tools when attempting to deploy and schedule their resources in any formal or scientific way. Teams often stagnate as the same people are put on the same types of work and their ‘worth’ skills-wise is stored anecdotally or incorrectly. This knock-on effect isn’t just damaging to the work and to your client’s perception of that work (goodbye repeat business); in the US alone an estimated $122 million dollars is wasted against every $1 billion invested, purely due to lacking project performance (, 2016). Putting the wrong people on your projects is costing your business. Using Excel to mitigate that, well frankly, isn’t going to mitigate that.


You used Excel today right? Or at least this week? The likely answer is yes, and if not then I commend you on either finding the right tools for the job or being able to work without any tool at all. Excel is great for data and, for us millennials, you were probably taught at school this is the organisation tool. It can turn great swathes of data into useful charts and illustrations as well as analyse it. It does mathematics on your behalf and in effect it saves time in completing what would typically be a massively manual task. Also, research tells us your knowledge of Excel probably means you’re probably getting paid more, approx. $100 more per week. Excellent. Whatever your role, there is likely a need for Excel in the day to day. There is a reason the noun for spreadsheet is now, almost universally, Excel.


So obviously this piece was going to have to switch gears; this isn’t an article on the positives of Excel. This switch is framed by a simple question: why as a project manager would your workforce management and resource scheduling be done in a spreadsheet?

The obvious goal of using such a tool relates to anything non-mathematical one puts into Excel - it is done in order to organise and overview. In this case, we are specifically organising and overviewing the workforce so in turn they can be deployed effectively. But let’s put a person into that equation, as you would be doing. Assume you’re doing this exercise to measure a delivery persons availability; we’ll call them Karen. Why are you doing that and for what purpose? Firstly, you shouldn’t be measuring appropriateness for a project simply by time available as it doesn’t equate to productivity, efficiency or effectiveness of that person for the job in hand or within a particular skill set or client requirement. What actually being said is:

“I’m charging the client for X hours so am placing X hours against that task”

OR that

“it took X amount of time to do that same task historically”

But Excel isn’t providing you with the data of how productive, efficient or effective this was previously, all it is saying is Karen does or doesn’t have that time available. The process therefore requires some manual re-evaluation. It doesn’t provide a flexible or agile approach and the employee is then purely a commodity based on units of time, which leads to a plethora of other issues (see our post on finite skills). So we can infer that Excel doesn’t create value from a time perspective.

So then let us evaluate from alternative perspective. Perhaps instead you are using Excel to categorise each employee by skill set and deploy on that basis. Fine, but how are you seeking that information and applying it together with other skills and people with a specific job in mind? How are you combining multiple employees to create the right team for that task? Are you managing to do it quickly and at scale? Are you sticking to your go to traditional teams, which as aforementioned, aren’t flexible and agile? Using the find function in Excel won’t build out any healthy combinations for you, let alone the right one. And when you come to deploying the resources you still have to manually locate and place the time.

Furthermore, in Excel, the filters can only go by keywords or phrases, it can’t find the gaps for you (and as with availability, that isn’t the right way to deploy anyway). So, in effect, you’re still doing all the work and perhaps more importantly, it is still taking time. In Precursive’s Agile Workforce research we discovered that 58% of the c-suite are still using Excel for resourcing, but it was either becoming a more unwieldy tool than intended or the spreadsheet had to be so complex it destroyed the purpose of what it was trying to solve.

58% of companies still use Excel to mitigate capacity issues but admit it is inadequate

For each of the negatives above there is a further point to be made - it all requires extensive maintenance. None of this is updated in real-time, rather updates occur either before or after the fact, not during. In effect, it is never up to date. Plus if anything gets missed or is incomplete the whole efficiency purpose of the spreadsheet becomes lost. As most people appreciate, projects rarely run smoothly 100% of the time and ad hoc changes or new business which likely require attention are inevitable. Does Excel notify you when a project goes off-course? Excel doesn’t know what a project is.

Then to confound the problem, when you go beyond Karen (sorry Karen) to global teams, teams which might not even have a direct touch point with the PM, it is almost impossible to keep track of the multitude of updates required from skillsets and experience to time available and pipeline. You want to be able to use your most valuable asset, the resources available, but without a clear, real-time overview this is near impossible.

Excel is poor for a PM specifically for these reasons. The functionality of the tool isn’t fit for purpose with regards to maintaining a modern agile workforce. It’s fit for accountants accounting, not project managers project managing. For dynamic teams you need a real-time, automated tool and not a full-time project in itself.


So why match people and projects outside of simple time metrics? Well companies with successful and agile resource management are finding that salience to a project results in significantly improved output. For example, passion areas are rarely contemplated in deployment, mainly as skill is seen as the true identifier for appropriate fit to a role. But matching skill and passion to a piece of work means that:

  • The client is happier their needs are being met, not just because they are more likely to have been in the first place but also the interactions between client and employee are more positive.

  • The work is likely to have been completed faster as the employee doesn’t have to adapt to align with the work, they’ll already have the mindset.

  • The employee is more engaged, either from doing work they enjoy or work that they selected as it will develop their skill set (as well the businesses potential with it).

Therefore finding the right person for a project is significant; Excel can’t highlight the detail required to achieve this. At scale Excel is also difficult to share without losing updates and data, so people can’t really put their hand up for work in order to create this salience between client and employee. Nor does it evaluate competency levels to order to plug skill gaps. There is no threshold criteria to flag what skill gaps might be coming down the pipeline - all Excel is telling you is Karen has time on that day for that many hours.


Now a brief point on Agile Project Management (APM). APM is now more iterative than its historically been and therefore one has to react faster than ever. To adopt scrum methodologies and have the visibility that APM demands then you need a dynamic tool. For too long operations haven’t had the tools to work in a manner geared perfectly for success. Excel is not the tool to solve this, but other tools are now available which can. For years there has been HR tech, Martech, Fintech; what about Opstech? For too long project management has been approached more as a box ticking exercise perhaps for the fact it was very hard not to be with the toolbox at the time. Now there are systems that provide the option to generate dynamic, global teams with ready to use, multi-disciplined skill sets that satisfy your customer ever time.

Can you truly say Excel does that?


So what are the alternatives? Get in contact to discover what tools are available at

Have you heard? Precursive has been identified as one of the best resource management solutions based on its high levels of customer satisfaction and 'likeliness to recommend ratings' from real users on G2 Crowd, the world’s leading business solutions review website. As such it have been rewarded with the High Performer Award for Summer 2019, following it's Best User Adoption Award in Spring.

To discover more about Precursive's features, content and awards subscribe to us on our homepage.

155 views0 comments


Find out more about the people and company. You can learn more about what makes us tick. 


We are passionate about changing the game for the world’s best services teams. 


Our mission is to help you improve time-to-value and make every customer a success story.

Asset 27.png


About Us

Find out more about us including our mission, values and get to know the team

Salesforce Native

Give sales, services, support and customer success teams a single, shared view of the customer


Hear from customers on why they prefer Precursive to help them scale and grow their business

Professional Services Delivery

Our services team provides expertise in how the best companies improve services delivery

Support & Success Hub

Find the answer you need at our success-hub where you will find a mix of documentation, video assets and training materials

The Precursive Platform is 100% native to the Salesforce platform. Our solutions can be tailored to your needs and support a range of use cases.


Learn how we take the pain out of complex service delivery activities. 


Do the work, not the admin! 

Asset 22.png

Professional Services Automation

Increase operational efficiency with predictable services delivery and insights on performance

Project Management

Powerful project management capability designed to support high-velocity services delivery

Resource Management

Quickly mobilize your project teams, manage demand and avoid capacity crunches

Customer Workspace

An interactive community portal to collaborate, share dependencies and updates in real-time

Services Billing

Easily manage accurate professional services billing, raise invoices and track payments

Revenue Management

Recognize and forecast revenue with ease and accuracy

Precursive AI ✨

Leverage AI capabilities for better project management and boosting customer success. 

Asset 18.png

Get actionable tips and insight on customer onboarding, resource management and professional services automation via podcasts, blogs, whitepapers, product guide videos and our on-demand webinars.


A vault of knowledge from in-house & guest writers


Repeatable & scalable insight on a platter

Product Guides

Video guides for the Precursive Platform


Industry trends and benchmarking


Listen to all episodes of ‘Precursive Perspective’ with host Jonathan Corrie

Toolkits, templates, tips and more 


Stay in the loop of what Precursive is up to


Watch anytime, anywhere, on-demand


Asset 17.png

Manage people, projects and revenues in one place

Asset 20.png

Staff projects faster with resource planning

Asset 21.png


Improve your implementation experience