When it comes to resource planning, it's amazing what a capable user of Excel can do. But spreadsheets, while ubiquitous and cheap, do have their drawbacks. Once your contact center has grown above a relatively low level of scale and complexity, the limitations of spreadsheet-based planning become apparent.
No time to read the full article? Just download it as a PDF and read it offline, anytime, anywhere.
As well as functional limitations, spreadsheets are prone to errors. In 2013, a University of Hawaii study found that 88% of spreadsheets contain errors. Can you ever be sure that your complicated Excel sheets are doing what they are supposed to be doing?
Here are some indicators that you have outgrown Excel for staff planning. See how many you recognize.
1. You waste lots of time getting data for forecasting
It’s normally possible to extract reports from your ACD that show call volumes and AHT by interval. These reports can be copy/pasted into a spreadsheet. But this is labor-intensive and error-prone. And it’s such a pain that you probably don’t want to do it more than once a day, so you can’t update your planning in the light of unexpected spikes or drops in call volume.
Wouldn’t it be better if the forecast data were automatically imported as soon as published by the ACD, typically at 15 or 30-minute intervals, without needing to lift a finger?
2. Your forecasts are inaccurate
If your forecast is wrong, your staffing will be wrong and your service level will be all over the place. Remember the expression ‘garbage in, garbage out’.
The problem is even bigger when you are forecasting for anything except inbound calls that are handled by single-skilled agents. There are lots of spreadsheet Erlang calculators out there but these run out of road if you want to calculate staffing for chats, emails, social media — or agents with 2 or more skills. Sadly, all but the cleverest Excel sheets will fall short here.
How would it be if you had artificial intelligence to identify anomalies, spot trends and always have the most accurate forecast ready for all channels?
3. You spend ages creating agent schedules and you still struggle with over and under-staffing
Excel is not bad when it comes to displaying agent shifts. You can have one row for each agent, one column for each time interval and a value in each cell to indicate what the agent is scheduled to do. But to display a 24 hour period in 15-minute intervals, you’ll need 96 columns. That’s a lot of scrolling. Even worse, it needs a lot of work to put the shifts in the right place.
Life is easier if all the agents are on fixed shifts or simple rotations, but in limiting your scheduling like this, you are leaving big efficiency gains on the table. In reality, at least some of your agents are probably willing to have flexible start and finish times, which opens the door to optimization and lets you improve your service KPIs without hiring. This is a big mathematical problem that gets even bigger with multi-skilled agents.
Imagine you could automatically generate fully optimized schedules for all your agents with a few clicks? Including a mix of fixed and flexible contracts? And a mix of single and multi-skilled agents? What if you could quickly reschedule tasks or breaks to take care of unexpected spikes and absences?
4. Agents keep ‘forgetting’ their shifts; time off requests and shift swaps are a pain
Once you’ve built the schedules, you’ve got to get them to the agents. With spreadsheets that could mean emailing all the agents, storing a PDF in a shared folder, or just printing and pinning up the schedules in the canteen.
And do agents always remember their shifts, no matter how you share the spreadsheet with them? What if you need to update the schedules during the week? With spreadsheets that’s a recipe for chaos and you probably just don’t attempt it.
How much time do you spend processing time-off requests and shift swaps? This can be a very time-consuming process, not to mention an emotive subject with serious impact on staff morale. Much better if agents could access their shifts anytime and anywhere on the device they all carry nowadays — the smartphone. What if agents could book time off and swap shifts with their colleagues on a self-service basis?
5. You keep inadvertently breaking the rules
The objective of staff planning is always to maximize ‘workload fit’, i.e. make supply (agents in their seats) match demand (workload) as closely as possible at all times. This is a big task in theory — see point 3 above – but is even more onerous in practice.
In the real world, any shifts that you create must satisfy all the constraints. For instance, you must respect the agents’ contracts (min/max hours per week, working days, etc.) as well as labor laws.
If you are brave enough to update shifts once they are published, you need to make sure that any changes you make remain compliant with the constraints. In short, it is very easy to break the rules when creating and modifying shifts using Excel. We can all live without the strife that this causes.
Wouldn’t it be better if you could automatically generate optimized and rule-compliant schedules, every time? And how about if any manual changes you make to shifts are checked in real-time for rule compliance?
6. Agents don’t adhere to their schedules
All your effort in forecasting and scheduling is wasted unless the agents actually turn up when you need them and leave when they’re done. You really want them to go on break and come back on time as well. When depending on spreadsheets, it is almost impossible for planners and supervisors to track adherence in real-time, except in a very small operation. Think about the boost to adherence that you’d get if you had a dashboard that compares schedules with actual attendance, flagging up those agents who are not doing the right thing at the right time.
And can you remember how well agents adhered to their schedules last week or last month? At appraisal time, wouldn’t it be great to have a summary adherence report?
7. You are frequently in fire-fighting mode
A spreadsheet offers limited or zero opportunities for collaboration, since typically only one user has write access. Spreadsheets do nothing to highlight upcoming issues, like that campaign that marketing ‘forgot’ to mention. And spreadsheets don’t help you to take corrective action on an informed basis.
The result: KPIs are not achieved, SLAs are broken, customers complain, agents get burned out and planners get stressed. When things start to go wrong, the only possible reaction when using spreadsheets is to rely on gut instinct. Experienced planners and managers can often trust their gut feelings but can you honestly say that intuition always leads to the right outcome?
How much more in control would you be if you had a real-time dashboard that helps you react quickly and correctly to deviations from plan? It’s a sad fact that in call centers, nobody gets rewarded for saving the day with heroic rearguard actions. Brownie points are awarded for delivering consistently high performance.
8. Your Excel sheet has become a monster
Part of the appeal of spreadsheets is that you can quickly create a solution that works quite well. And as the business changes, you can make changes just as quickly. Excel contains a myriad of functions that can be used effectively to create a bespoke application. All this without needing to make a purchase request or asking IT to get involved. What’s not to like?
Quite a lot, it turns out. Complicated Excel sheets quickly become ‘write only’. Clever formulas and macros that made perfect sense when you wrote them become unfathomable if you try to modify them after a few months. After a few rounds of modification, what started as a simple and elegant spreadsheet becomes a tangle of formulas.
The challenge is multiplied when the ‘spreadsheet wizard’ leaves the company. There is a danger that the contact center becomes dependent on an application that nobody fully understands and upon which the operation depends to achieve its KPI goals. That’s a recipe for disaster.
What are the alternatives to Excel?
The stand-out alternative is a professional WFM software application. Unlike Excel, WFM applications are not general-purpose tools. They are designed from the ground up to do one thing, and do it well: To support the entire process of staff planning in contact centers. The topic of switching from Excel to WFM is explored in this post.
Of course, acquiring a professional WFM application will cost money. Think you can’t afford a WFM application? It's time to do a return-on-investment calculation. injixo WFM probably costs less than you think!
Did you find the article interesting and would like to share it with your colleagues? Download the article as a PDF.
Originally published on Feb 03, 2021, updated on Feb 24, 2021.