by ETHOSystems

Don’t underestimate spreadsheet errors!


Underestimating a project or losing bids by overestimating can seriously erode profits. Too often these problems are caused by errors in spreadsheets. A PricewaterhouseCoopers study once showed that up to 91 percent of sophisticated spreadsheets contain errors. Another study concludes the error rate is 94%. Regardless, errors are prevalent, so let’s look at ten common estimating spreadsheet errors.

Million-dollar mistakes

According to research done by ZDNet, errors can be extremely costly. Horror stories abound, but here some of the better-known classics:

10 common Estimating spreadsheet errors:

  1. Hardcoding your values in the spreadsheet formulas resulting in right this month and wrong forever
  2. Adding rows or columns that don’t get included in the range of the sum, subtotal and average functions
  3. Losing unsaved changes due to interruptions
  4. Data entry errors such as skipped entries or transposed numbers
  5. Saving “what if” changes over the Excel worksheet you want to keep
  6. Formula errors like parentheses errors in a mathematical formula; formulas pasted over with constants; or formulas no longer calculating properly when you delete an item
  7. A bad query copied into a spreadsheet
  8. A bad sort that destroys the integrity of a row
  9. Old spreadsheet errors copied over and over again
  10. Maintaining a number of templates for specific types of projects, which multiplies the risks of data entry errors, omissions, transposed numbers, and outdated pricing

One way to reduce the number of spreadsheet errors is to limit access to files or locking certain cells. You may also want to implement quality-control procedures for catching data entry errors in spreadsheets, including input controls, validation, and cross-footing.

An example of an input control is reconciling the data entered into the spreadsheet to the source records. A common-sense suggestion is to separate the data entry and formula areas on a spreadsheet.

Finally, it’s a good idea to have the logic of the formulas within the spreadsheet inspected by someone other than the user or developer of the spreadsheet.

Prevent errors with true estimating software!

Reduce your risks by moving to the industry-standard — Sage Estimating software. Win more, bid more with industry-specific cost databases. Learn more here.

Worried about pricing? This article will help: 10 Ways Your Construction Software Can Pay for Itself.