Subscribe / Unsubscribe Enewsletters | Login | Register

Pencil Banner

How Anaplan plans to kill off Excel use within the enterprise

By Scott Carey | Nov. 15, 2016
Excel is often overlooked as part of an organisational application.

Anaplan - the cloud-based vendor of business modelling and planning software - wants to eliminate Excel spreadsheet-based business processes within the enterprise.

Speaking at its Hub 16 event in London this week, chief marketing officer Grant Halloran said that Excel is often overlooked as part of an organisation's IT application environment, despite its widespread use.

"What we don't see is the smattering of Excel spreadsheets across this landscape on IT diagrams. It is spread through the business like a virus," he said.

He added: "Excel is a phantom system that works in the shadows."

Excel spreadsheets still form a core part of many business processes in some of the biggest organisations in the world, particularly the financial services and insurance industries.

Anaplan's mission is to eliminate the tedious and error-prone process of teams editing and passing around Excel spreadsheets via email.

Instead, it's software is built on a Java-based, in-memory calculation engine, which means changes made to core models are updated in real time, regardless of data volume and the number of collaborators.

The problem Anaplan founder Michael Gould saw with spreadsheets was that they tended to sit within each business function. They aren't linked up, which creates a fragmented view of the business and makes effective planning and decision making more difficult.

What the customers say

Strahan Wilson - CFO at restaurant chain Cote Brasserie - arrived at an organisation with this exact problem two months ago. "Coming to Cote I found that we were stuck in the Excel dark ages," he told Computerworld UK. "We did one budget a year which was done for July and it was essentially a one man operation."

Wilson admits the new budget planning cycle could be done in Excel, but would be too difficult to implement at any scale. "Having 80 restaurants means 80 spreadsheets. So each time you change a variable you need to change it 80 times if you need to change the approach, therefore you never do.

"The migration to Anaplan means we are able to say that's not right and this is a much better approach to do it. By changing master data once you build the module that affects that line and it doesn't care if there are 80 restaurants or a thousand restaurants, it is just elements within your model and takes all of that into consideration."

Matt Jones, CFO at insurers AXA Art said that although Excel will always have a place within organisations like AXA, it falls down when it comes to modern data volumes.

"The status quo within any organisation is Excel spreadsheets," Jones said. "That's the starting point for planning and analysis.

"Excel had a role to play when data was of a certain quantity and complexity, but all organisations now have to look beyond that and find alternative ways to handle that complexity. Also the expectation around analysis and decision making has increased significantly."


1  2  Next Page 

Sign up for CIO Asia eNewsletters.