geoAMPS BLOG

Land Rights & Infrastructure Asset Management Software

All Posts

The Cure for Bad Math in Spreadsheets

bad-math-in-spreadsheets

Research conducted by Raymond R. Panko, professor of IT management at the University of Hawaii, found that bad math runs rampant in the world's spreadsheets. In fact, 88% of spreadsheets contain math errors, which in the right situations can radically corrupt the end data.

According to Microsoft, over 1 billion people have access to a spreadsheet tool like Excel. That’s great when you consider how powerful the software is in the right hands, providing a wealth of information and performing such calculations as family budgets, business expenses and other payments in a convenient package. Panko warns, however, that hiding in these spreadsheets, unbeknownst to the spreadsheet user, are critical errors of mathematics.

The problem is so widespread that some world governments have created groups dedicated to finding and correcting spreadsheet errors. That’s because these unseen problems can have a large impact. One recent example is the math error in a Harvard economics study, which may have resulted in an overstatement of the impact debt burdens have on a nation’s economic growth.

Spreadsheets are being used for processes that they are not cut out to deal with. Consider the multitude of calculations that make up a royalty payment for an oil well or a wind farm. A royalty payment for a single landowner can have several calculations based upon different variables and conditions. Then, depending on the terms of the agreement with the landowner, a different formula may be used to produce a payment to the landowner. A spreadsheet with data for hundreds of landowners would require thousands of calculations, each independently entered.

In Panko’s report, updated in 2008, he comments that spreadsheets contain errors in an average of 1% of all formula cells. This means that in spreadsheets used by large organizations with thousands of formulas, there would be dozens of undetected errors, leading to faulty information, inaccurate or late payments, and possible legal action.

There is, however, a simple solution. geoAMPS, a technology company located in the Columbus,Ohio, area, offers solutions that help organize information in a controlled, accountable environment. geoAMPS’ products provide advancements over spreadsheets with role-based actions and predefined worksheets combined with Web-based computing, making it possible for each member of the organization’s team to work with accurate, real-time information.

geoAMPS products and services create a collaborative environment that benefits projects in a variety of industries. They provide data accuracy, faster project completions and better return on investment, all the while eliminating those pesky spreadsheet errors.

Nathan Mirolo
Nathan Mirolo
I fell completely backwards into what was then a startup in 2012 with 7 employees and no marketing team. Since then the experiences, opportunities and the working environment that geoAMPS has allotted to me and my colleagues has been amazing, I’ve never looked back.

Related Posts

Forbes Magazine Features geoAMPS’ Power Couple

An exclusive article about our very own Yogesh Khandelwal and Leena Madan has been featured in the August edition of India’s leading Business magazine - Forbes. The story shines light on the journey of Yogesh Khandelwal and Leena Madan, their educational background and how they started their career. We also gain insight into how Yogesh and Leena came up with the idea to start geoAMPS, the inception of geoAMPS and what they envision for the future of the company.

  • 1 min read
  • Wednesday, August 21

geoAMPS Participates In Another Successful IRWA Conference

Members of the geoAMPS team have returned from the 65th Annual International Right of Way Association (IRWA) Education Conference in Portland, Oregon. They were pleased to have had the opportunity to meet with many right of way industry representatives.

  • 1 min read
  • Thursday, June 27

geoAMPS Attending SEE Conference in Washington, D.C.

Yogesh Khandelwal, the President, and CEO of geoAMPS, and Guy Allen, the Vice President of Sales will be attending the Southeastern Electric Exchange (S.E.E) Annual Conference and Trade Show this year, which is going to be held from 26th to 28th June at Washington DC. We will represent geoAMPS and meet with industry representatives to discuss how geoAMPS products and services can be beneficial for them to ease the entire process of their projects, existing infrastructure, and overall organization.

  • 2 min read
  • Wednesday, June 26