Spreadsheets Lack Functionality Facilities Managers Need
Facilities managers have tools available to them for managing everything from construction and energy to recycling and security.
So, it’s surprising that in an age of automated buildings and smart cities that facilities managers are still using spreadsheets. Spreadsheets are “flat” tools that can organize and sum sets of data, but they lack the rich functionality of a dedicated capital planning software solution. Spreadsheets can’t support common facility planning scenarios. Using spreadsheets, managers often struggle to build a comprehensive plan for their facility and asset portfolios.
For example, managers often need deeper functionality to:
- Perform what-if analyses of various funding scenarios.
- Align capital budgets with organizational priorities, and, ultimately, sort needs with a systematic ranking strategy.
- Centralize deferred maintenance data to develop cost-saving project bundles.
- Create and share operational and strategic reports with relevant stakeholders.
Download the white paper – The 5 Limits of Spreadsheets for Facilities Capital Planning – learn more about the key problems of managing your facilities with spreadsheets.
Facilities managers often ask us why they would need something beyond spreadsheets for their facility capital planning. While they suspect that there could be a better way, they are hesitant to jump to a new system without fully understanding the benefits.
Key functions include:
- The ability to easily model scenarios to assess and compare the impact of alternate funding strategies on building condition.
- A systematic ranking methodology that includes pair-wise comparisons to effectively link requirements to organizational priorities.
- Centralized requirements across buildings and sites that help identify opportunities to cost-effectively bundle projects and determine key relationships between them.
- Business intelligence dashboards and reports that provide the insight needed for better decisions by stakeholders across the organization.
Every day, facilities managers like you see the limitations of using spreadsheets for facility capital planning. The lack of specialized functionality is just another reason to move beyond spreadsheets for your facility capital planning.
Want to read more on this topic? See these blog posts:
The Perils of Manual Data Entry in Facilities Capital Planning
How Spreadsheets Limit Facilities Capital Planning Collaboration
Facilities Managers Won’t Find Cost Estimation Norms Data in Spreadsheets
How Capital Planners Measure Performance (It’s Not with Spreadsheets)