Domain: eusprig.org
Stories and comments across the archive that link to eusprig.org.
Comments · 6
-
Re:Ob
Maybe it's version dependent, but I've had that kind of error with data that's been copy-pasted or exported from other systems, and even using the functions to clean it ( trim()?
... it was a while ago) didn't work.Or take a look at item 67 here. http://www.eusprig.org/stories.htm
-
Re:incongruous
Yes it probably applies to OpenOffice.org Calc as well. Spreadsheets are just not a good tool for sophisticated data analysis whether it be in the finacial or scientific fields. Have a look at the Don't Do It link posted above for some reasons. Also have a look at http://www.eusprig.org/ and click on Public Report of Errors or have a look at Ray Panko's Human Errors Website http://panko.shidler.hawaii.edu/HumanErr/index.htm. Some estimates say that even moderately complicated spreadsheets contain errors and are even more error prone when modified.
-
UK Spreadsheet Errors Conference 6-7 JulyThe news stories are from EUSPRIG : next month is their SIXTH annual conference on spreadsheet errors ; it takes a while to get attention, but it's attracting some significant attendees this year. Ray Panko has of course spoken there:
http://www.eusprig.org/ European Spreadsheet Risks Interest Group
http://www.uwic.ac.uk/eusprig/2006/index.htm The Sixth annual conference theme is Managing Spreadsheets: Improving corporate performance, compliance and governance.And I'll add a plug got my book:
http://www.sysmod.com/scc.htm
If spreadsheet users had a driving licence, this would be their seat belt, air bag, navigation aid, repair kit, hazard indicators, and the rules of the road. This new book describes how to produce well-crafted spreadsheets that are easy to understand, maintain, audit, and operate. It shows how to ensure data quality and accuracy and protect against formula and operational errors. -
Errors in Spreadsheets are Pandemic
Modern spreadsheet programs have killed that need.
Yet studies show that most spreadsheets have critical errors in one percent of their cells, well beyond a permissible level.Here are some news stories about spreadsheet errors.
Spreadsheets won't protect a firm from liability when they are audited and spreadsheet errors found: Spreadsheets are not secure, provide no audit trail and won't pass HIPAA or Sarbanes-Oxley auditing.
-
Re:Does anyone understand this?
Thanks for the story, dykofone! May I add it to the collection at http://www.eusprig.org/stories.htm , please? For those interested in these things, check out the sixth annual European Spreadsheet Risks Conference at http://www.eusprig.org/
-
Re:Does anyone understand this?
Thanks for the story, dykofone! May I add it to the collection at http://www.eusprig.org/stories.htm , please? For those interested in these things, check out the sixth annual European Spreadsheet Risks Conference at http://www.eusprig.org/