Escape Excel Hell
Latest posts by Eric Beser (see all)
- 3 Things NonProfit Organizations Need to Do Immediately to Strengthen the Equipment Management Process - October 22, 2014
- Get eQuip! FREE for Windows Mobile - August 25, 2014
- eQuip! 6.4.10: Integrated Applications, PDF Reports, Search Improvements, and More - June 30, 2014
As a facility or property manager, one of your most important goals must be the accurate tracking of organizational equipment. So I must ask: how are you currently tracking vital asset information like location, quantity, condition, custody and chain of command, depreciation and retirement? Are you like so many other property custodians that rely on Excel to manage this data? If so, you’re probably drowning in spreadsheets and spend more time chasing inventory information than managing your equipment.
Well, the Intelligent Asset Manager is here to say: It’s time to escape Excel hell.
It’s helpful to understand one thing: Excel spreadsheets will always be a part of your equipment management process. What I mean by “escaping Excel hell,” is reducing the unnecessary time spent sorting through disorganized spreadsheets. Spreadsheets can be a useful property management tool as long as you don’t waste valuable time searching for data.
Excel sheets are a great tool. I am not disputing their usefulness. It’s how you use excel sheets that will determine the quality of your life as a property manager.
Does your spreadsheet tool automatically search the asset inventory to fill in asset information? Will your spreadsheet tool automatically update the inventory each time an employee checks out an asset? Is your excel tool a seamless part of your equipment management workflow? Can your excel tool aggregate all the data and push out key performance metrics? If your answer to any of these questions is “no,” you might want to think about how to supplement your spreadsheet tools with an equipment management platform. This solution will not only make your life much easier, it can also advance your individual professional goals. Imagine how impressed your boss will be when you tell him or her: “We reduced the asset loss rate by X% and can save X amount of dollars in tax expenses if we retire these specific assets – we’re not using them anyway.” I bet consistent deliverables like that will get you closer to your promotion. After all, who doesn’t love a team player striving to improve the operations?
How impressed will your boss be when you tell him or her: “We reduced the asset loss rate by X% and can save X amount of dollars in tax expenses if we retire these specific assets – we’re not using them anyway.” I bet consistent deliverable like that will get you closer to a promotion. After all, who doesn’t love a team player striving to improve operations?
These dynamic insights into your organization’s inventory are known as total asset visibility and can only be derived from a purpose built equipment management platform. So, again, ask yourself: what are my goals for achieving job satisfaction as a property custodian, office administrator or facility manager? The answer is implanting an equipment management solution which will minimize all asset management headaches and save you from drowning in spreadsheets.
We love to hear your comments about managing your company’s assets – what would contribute to your career satisfaction as a property custodian?