View Single Post
  #1  
Old 04-10-2007, 12:28 PM
campbell's Avatar
campbell campbell is offline
Mary Pat Campbell
SOA AAA
 
Join Date: Nov 2003
Location: NY
Studying for duolingo and coursera
Favorite beer: Murphy's Irish Stout
Posts: 83,767
Blog Entries: 6
Default "How do you know your spreadsheet is right?"

"How do you know your spreadsheet is right?" (PDF) is an excellent article from Philip Bewig, from July 2005.

It mainly deals with Excel and some of its features that can help make your spreadsheets more robust. He goes through various practices that may reduce your error rate in developing complicated spreadsheets (also to prevent some deliberate errors, aka fraud, from being undetectable). I've used some of these techniques myself, but some I had never heard or thought of. Most useful of all is his extensive footnotes that provide jumping off points into particular issues. Lots and lots of links.



A few other useful links:
European spreadsheet risks interest group: http://www.eusprig.org/

Ray Panko’s spreadsheet research pages:http://panko.cba.hawaii.edu/SSR/index.htm
__________________
It's STUMP

LinkedIn Profile
Reply With Quote
 
Page generated in 0.11314 seconds with 9 queries