PraxIS Mar. 2010

10-03 Contents: Hacker ransom, Spreadsheet Tips PDF, error stories, EuroCACS Spreadsheet Auditing, VBA knowledge test

ISSN 1649-2374 This issue online at http://www.sysmod.com/praxis/prax1003.htm   [Previous] [Index]  [Next]

Systems Modelling Ltd.: Managing reality in Information Systems - strategies for success

IN THIS ISSUE

 Risk
      Hack attack on SMEs demands $700 to unlock data

 Spreadsheets
     Spreadsheet Pitfalls, Best Practices, and Practical Tips
     If a spreadsheet were music...
     Spreadsheet error stories seen in the news
     EuroCACS Spreadsheet Auditing workshop March 21, Budapest
     Test your VBA knowledge

 Off Topic
     Trompe l'oeil 3D street art

About this newsletter and Archives
Disclaimer
Subscribe and Unsubscribe information


Welcome to PraxIS

I'm off to Budapest mid-March  to co-present a workshop on spreadsheet auditing with Ray Butler. Contact me if you'd like such a workshop run in your organisation.

Patrick O'Beirne

____________________________________________________________
____________________________________________________________

  IT Risk

Hack attack on SMEs demands $700 to unlock data

http://www.rte.ie/news/2010/0305/cybercrime.html

The companies say their computer systems were hacked, their data such as order books and customer data had been encrypted, their backup corrupted, and their businesses paralysed. They told gardaí that there was a note left on their computers demanding money - in one case $700 for the code to unlock the information. The Garda Bureau of Fraud Investigation has consulted specialists from the UCD Cybercrime Centre to help with the investigation.

IRISS (www.iriss.ie) recommends the following steps to protect your company falling victim to the attack;

____________________________________________________________
____________________________________________________________

Spreadsheets

Spreadsheet Issues: Pitfalls, Best Practices, and Practical Tips - PDF

Mary Pat Campbell, an actuary, has written articles for an actuarial newsletter on good spreadsheet practice. They have been
compiled together for the Society of Actuaries Actuarial Practice Forum at.

http://www.soa.org/library/journals/actuarial-practice-forum/2010/february/apf-2010-02-toc.aspx#campbell 

____________________________________________________________

If a spreadsheet were music...

Members of the EuSpRIG mail list had some diversion thinking of analogies in music kicked off by Ray Panko's comment "I just finished inspecting a large spreadsheet that was definitely baroque. Should we start referring to keyboarding errors as slack key music?How about customizable ring tones for different types of error messages?"

"Many of the spreadsheets I saw in my tax inspecting days were Punk Rock - An inability to play well was considered a positive advantage by the perpetrators"

"And of course there's the old saying, when something's not quite right: 'Close enough for country music'."

It's the listener who decides whether a performance of even a simple  tune is bad enough to be annoying. If you have a good sense of pitch then even a small error can irritate. Symphonies can be complex but understandable by many; twelve-tone  compositions can be simple but incomprehensible.One of the skills of the craft and art is to make necessarily complex  material accessible

http://sunsite.univie.ac.at/Spreadsite/fourier/fourtone.htm
An Excel application that will allow you to synthesize sounds.

____________________________________________________________

Spreadsheet error stories seen in the news


http://blog.contextures.com/archives/2010/02/01/calculating-ages-in-excel/#comment-4882
DATEDIF works correctly in the initial release of XL2007 and its SP1, but does not work correctly in SP2

http://binnenland.nieuws.nl/566978
A calculation error costs “Waterschap Veluwe” € 2.7M

http://www.gmc-uk.org/9___Cardiff_Medical_School_Examination_Errors___Annex_B.pdf_snapshot.pdf
Wrong exam results attributed to 137 students

http://www.scienceblog.com/cms/update-urban-green-spaces-may-contribute-global-warming-uci-study-finds.html
A spreadsheet error in the scientific paper regarding carbon dioxide emissions during lawn maintenance

http://andyjko.com/2010/03/05/spreadsheet-error-costs-time-and-money-yet-again/
There was an error in the spreadsheet, and after fixing the multiplier cell, my bill was reduced by a factor of 10.

http://www.gofbw.com/news.asp?ID=11451
Both the subtotals and the totals from those states were added [..] leading to a double-count 

Alas, no published source for this anecdote:
"A contractor was installing a number of horizontal steel beams near a railway track.  Due to an error in the spreadsheet a four inch clearance was not subtracted in the calculation of the length to cut the beams. No one noticed the error during installation and as a result the first train hit one of the beams causing extensive body damage and frightening a few passengers. Repair costs were in
the order of £100k."

____________________________________________________________

EuroCACS Spreadsheet Auditing workshop March 21, Budapest

http://www.isaca.org/Template.cfm?Section=North_America_CACS&CONTENTID=53374&TEMPLATE=/ContentManagement/ContentDisplay.cfm#pre

Ray Butler and I are giving a one-day workshop on Auditing Spreadsheet Risk and Quality

If you're at the conference, say hello!

____________________________________________________________


Test your VBA knowledge

http://www.tykoh.com/vbfba_assesment.php
Trainer Alex Palfi in Australia offers  a free on-line assessment of your Visual Basic skills. They range from simple to non-trivial, and cover practical aspects in about 40 questions. Comments from those who took the test can be read at

http://www.dailydoseofexcel.com/archives/2010/02/09/vba-assessment/

____________________________________________________________


XLTEST special offer held open

XLTest is my spreadsheet auditing addin. It provides static analysis and dynamic testing of spreadsheet models in both easy-to-see colour map views and exhaustive listings of suspicious elements.

http://www.sysmod.com/xltest/index.htm

If you own the book "Spreadsheet Check and Control" you save the cost of the book - 30 euro! Simply enter into the discount code box on that page, the first word on the top left of page 131.

If you buy the spreadsheet inventory/assessment workbook  ScanXLS you can get it free! Simply say you want XLTest free when placing your ScanXLS order.

Spreadsheet Check and Control: 47 best practices to detect and prevent errors

http://www.sysmod.com/scc.htm

____________________________________________________________
____________________________________________________________

FEEDBACK

Simply send your comments to FEEDBACK (at) SYSMOD (dot) COM

Thank you! Patrick O'Beirne, Editor

_______________________________________________________
_______________________________________________________

 Off Topic

http://www.metanamorph.com/

Trompe-l'oeil 3D Pavement art by Edgar Mueller uses the street as a canvas. If one looks from the right spot, its three-dimensional painting becomes the perfect illusion. He paints over large areas of urban public life and gives them a new appearance, thereby challenging the perceptions of passers-by.

http://www.youtube.com/watch?v=3SNYtd0Ayt0

_______________________________________________________
_______________________________________________________

Copyright (c) Systems Modelling Limited, http://www.sysmod.com . Reproduction allowed provided this copyright notice is included.

We appreciate any feedback or suggestions for improvement. If you have received this newsletter from anybody else, we urge you to sign up for your personal copy by sending a blank email to   EuroIS-subscribe (at) yahoogroups (dot) com

For those who would like to do more than receive the monthly newsletter, the EuroIS list makes it easy for you to discuss issues raised, to share experiences with the rest of the group, and to contribute files to a common user community pool independent of the sysmod.com web site. I moderate posts to the EuroIS list, to screen out inappropriate material.

Patrick O'Beirne, Editor
_______________________________________________________
ABOUT THIS NEWSLETTER
"Praxis" means model or example, from the Greek verb "to do". The name is chosen to reflect our focus on practical solutions to IS problems, avoiding hype. If you like acronyms, think of it as "Patrick's reports and analysis across Information Systems".
Please tell a friend about this newsletter.
We especially appreciate a link to www.sysmod.com from your web site!
______________________________________________________
ARCHIVES
To read previous issues of this newsletter please visit our web site at http://www.sysmod.com/praxis.htm

DISCLAIMER
This newsletter is prepared in good faith and the information has been taken from observation and other sources believed to be reliable. Systems Modelling Ltd. (SML) does not represent expressly or by implication the accuracy, truthfulness or reliability of any information provided. It is a condition of use that users accept that SML has no liability for any errors, inaccuracies or omissions. The information is not intended to constitute legal or professional advice. You should consult a professional at Systems Modelling Ltd. directly for advice that is specifically tailored to your particular circumstances.
_______________________________________________________
PRIVACY POLICY:
We guarantee not to sell, trade or give your e-mail address to anyone.
To subscribe to this Newsletter send an email to
EuroIS-subscribe (at) yahoogroups (dot) com
To unsubscribe from this Newsletter send an email to
EuroIS-unsubscribe (at) yahoogroups (dot) com
EuroIS is the distribution list server of the PraxIS newsletter. It also offers a moderated discussion list for readers and a free shared storage area for user-contributed files. The archives of this group are on YahooGroups website http://finance.groups.yahoo.com/group/EuroIS/
_______________________________________________________