Welcome!

XML Authors: Katharine Hadow, Greg Schulz, Ambal Balakrishnan, Jeff Scholes, Brad Abrams

Related Topics: XML, AJAX & REA

XML: Case Study

Segro Selects ComplyXL to Speed Up the Spreadsheet Reporting Process Across Europe

A solution was needed to control and manage the information held in spreadsheets

Segro (SGRO) is Europe's leading property investment and development company providing business space across Europe, and is one of the largest REITs in the world. With headquarters in the UK, Segro has locations across Europe in Belgium, the Czech Republic, France, Germany, Hungary, Italy, the Netherlands, Poland and Spain.

Issues
As the spreadsheets were being updated on a daily basis, with no real way to check the spreadsheets or control the changes except manually, it became imperative that spreadsheet controls were put in place in a non intrusive way, that could be rolled out easily throughout Europe with minimal disruption.

Rob Healey, Service Delivery Manager for Europe was tasked with finding a solution that would link into the new initiative to analyze the information, both the financial and property details, held in spreadsheets across Europe, to be able to report on the changes all the way to cell level and then to send notifications to the owners of the spreadsheets that the document had changed, all in a fast and verifiable way.

The project was initiated in France with 45 users spread across 9 different countries in Europe. These users included the Finance Accountants, Property Managers and Country Managers with the information feeding into the central store, the changed spreadsheets saved, with their full version then analyzed every day.

Benefits of ComplyXL
"Once ComplyXL was installed, it saved us enormous amounts of time in the analysis of spreadsheet changes. With the property information when it changes it causes a ripple effect, now with the changes being easy to track down and easy to see and approve, we have confidence in the information. For instance in Germany we have 110 properties, so any changes to information in our spreadsheets, we can now easily filter and understand, we know and trust the quality of information" said Rob Healey.

He goes on to say "the support from Lyquidity has been tremendous, from the initial contact with the demonstration of ComplyXL, all the way through to loading license files, they have helped us at very short notice. It's always nice to get good service from a software vendor, as some just sell you the product and you have to struggle to get the right resource to help. Lyquidity have been tremendous and I would recommend them"

For more information, please visit our website at http://www.lyquidity.com or to arrange a presentation contact sarah.hothersall@lyquidity.com Price for a typical enterprise solution is $10,000/€7,000

More Stories By Sarah Seddon

I am the Marketing/PR Manager for Lyquidity and as such my focus is on the controls organizations put around spreadsheets.