Search Results

Your search for spreadsheet errors returned the following results.

reasonably consistent with the field audit results discussed above. Lawrence and Lee found that 30% of the spreadsheets they reviewed had errors in over 10% of unique formulae; one spreadsheet had errors in more than one in five of unique formulae. Interestingly, this was the smallest spreadsheet, showing that error rates don’t necessarily increase with…

Tags: , ,

…spam filters. =============== 2. More spreadsheet woes While I’m on the topic of model errors, let’s get a bit more specific about spreadsheet errors. There have been good ones recently – Patrick O’Beirne maintains a good list at http://www.eusprig.org/stories.htm. Just read it if you don’t believe that there are large numbers of spreadsheet errors, and…

test? You should test your spreadsheets because they may contain errors (see item 1). People fail to test their spreadsheets because they underestimate the benefits of doing so: mainly, they simply don’t know how many spreadsheets contain errors. Think about it for a moment. Do 10% of spreadsheets contain errors? Or 20% (for the pessimists…

…rather than after. Making an effort to avoid mistakes in spreadsheets is not enough: what is needed is an effective development process, which includes appropriate testing and review stages. If there are routine ways of performing testing and review they are less likely to be skipped, and more likely to catch errors. And spreadsheet errors

…saying that in four of the models they reviewed over 15% of the unique spreadsheet formulae contained errors, and that one model had errors in over one in five of the formulae. This model was one of the smaller ones, too, so it’s no use saying “it’s only a small model, so it’ll be OK”….

Tags:

…models (100%) that they reviewed contained errors. They are saying that in four of the models they reviewed over 15% of the unique spreadsheet formulae contained errors, and that one model had errors in over one in five of the formulae. This model was one of the smaller ones, too, so it’s no use saying…

A spreadsheet may have the following types of user: A Viewer looks at the results, but makes no changes. A Viewer may never see the actual spreadsheet, but only printouts of selected parts, but they are still using the spreadsheet. A Player changes input cell values, but doesn’t change formulae and layouts. They may execute…

Tags: ,

…http://www.primopdf.com/ http://www.cutepdf.com/ =============== 2. What is a spreadsheet? How many spreadsheets do you have in your organisation? In your department? On your machine? It’s a tricky question to answer: it depends on what you mean by a spreadsheet. You could simply count the files that have an extension of “.xls” (assuming you use Excel). But…

…TransAlta Corporation managed to lose $24m (Canadian) through a “clerical error” in pasting into an Excel spreadsheet. The spreadsheet in question was used to submit bids to the New York Independent System Operator (New York ISO) for May 2003 transmission congestion contracts (TCCs). It’s not really important to understand what TCCs are: the crux of…

able to compare your standards with those of your peers (anonymously, of course). http://www.louisepryor.com/show.do?page=ICAsurvey =============== 2. Spreadsheet compliance I would not be at all surprised to learn that spreadsheets are used in the preparation of every single ICA. In fact, I’d be interested to hear of an ICA whose calculation didn’t involve a spreadsheet; and…

More results »