PraxIS Jan. 2007

07-01 Contents: Risk Management Resources, WiFi ICS, Euro-13, EU-27, Spreadsheet shrinking

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

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

IN THIS ISSUE

1) Risk & Security
     Resource websites on risk management
     The risk of not reading flight reservations closely
2) IT Tech
     Wireless Internet Connection Sharing
3) Europe
     Slovenia joins the Euro zone
     Bulgaria and Romania join the EU
4) Spreadsheets
     Data processing optimization
5) Off Topic
     Robert Fisk on the Middle East
11 Web links in this newsletter
About this newsletter and Archives
Disclaimer
Subscribe and Unsubscribe information

_______________________________________________________

Welcome to PraxIS

I wish all my readers success in their endeavours in 2007.

Patrick O'Beirne

_______________________________________________________ _______________________________________________________

1)  IT Risk and Security

Resource websites on risk management

Dan Swanson posted his year end list to various mail lists. To subscribe to his list, visit

http://finance.groups.yahoo.com/group/Dans_SECemails/join

His links include such staples as:

http://csrc.nist.gov/ Computer Security Resource Center of the National Institute of Science and Technology, USA. In December 2006 alone, they released:

 http://www.cica.ca/index.cfm/ci_id/3083/la_id/1.htm

The Risk Management and Governance (RMG) Board of the Chartered Accountants of Canada has the "20 Questions Directors Should Ask about ...." series.

http://www.riskreports.com/protected/archive/rmr-MontyPython.html

Felix Kloman takes an irreverent look at risk management using the dead parrot and 'Bruce's sketches.

The risk of not reading flight reservations closely

http://www.cnn.com/2006/WORLD/europe/12/29/germany.tourist.reut/

Reuters: Web typing error takes German tourist 13,000 km (8,077 miles) wrong. 21-year-old set out for Sydney, Australia but ended up near Sidney, Montana. Mother who helped send refund says: "He is usually good with computers"

____________________________________________________________
____________________________________________________________   

2) IT Tech

Wireless Internet Connection Sharing

With the party week before Christmas, and then the bridge from Christmas to New Year, not much real work got done here recently! So I took the opportunity of re-setting the PC used by my wife Megan. The old hard disk that was beginning to cause blue-screen errors, so I backed it up to another PC on the LAN and replaced it with a new one. At first, Windows XP could not format the 250Gb drive. Win2K saw half the capacity, so I figured it was related to older Windows drivers. Paul Thurrott's web site showed me how to create a 'slipstream' CD with Windows XP plus Service Patch 2 (SP2):

http://www.winsupersite.com/showcase/windowsxp_sp2_slipstream.asp

I used that CD to format, and got all the capacity. I reinstalled all the software ... in the right order! I checked the Nikon support forums for her film scanner which explained how to avoid the most common complaints. Then I installed the wireless LAN card, which talked to a wireless access point which connected to our LAN hub. I set up Internet Connection Sharing (ICS) for the dial-up connection but I could not get any browser to work, even after hours of Googling for possible solutions. Annoyingly, I could see the connection was working because Windows Update was running and downloading the XP updates. In the end, I installed AnalogX Proxyi.exe and it worked first time, no problems:

http://www.analogx.com/contents/download/network/proxy.htm

So if you've given up on ICS, take a look at that proxy. There are a number of other freeware utilities available on the AnalogX.com site.

____________________________________________________________
____________________________________________________________

3) Europe

Slovenia joins the Euro zone

http://www.eubusiness.com/Euro/slovenia-euro.97

The Alpine nation (pop: 2M) became on 1st Jan 2007 the first former communist state to join the EU's common currency. It is the 13th country in the eurozone. Finance Minister Andrej Bajuk said (optimistically?) "The biggest problem we might face is the one concerning rounding upwards of prices, but I'm convinced citizens are well informed and will show their good will."

http://www.evro.si/en/ Slovenian changeover site

To help the Slovenians with checking their conversions, I give below some sample conversions along with the likely misconversions. These are sampled from the test data set created by my euro compliance toolkit:

6124 Tolar converts to Eur 25.55, not 25.56

5858 Tolar converts to Eur 24.45, not 24.44

10.28 Euro converts to 2463 Tolar, not 2464

12.50 Euro converts to 2996 Tolar, not 2995

http://www.sysmod.com/eurocalc One euro equals 239.64 tolars.

Cyprus and Malta are expected to follow Slovenia into the eurozone in 2008 and Slovakia is aiming to adopt the single currency in 2009.

Bulgaria and Romania join the EU

http://www.ireland.com/newspaper/breaking/2007/0101/breaking1.htm

The accession of the poor, ex-communist duo raises the EU's membership to 27 states, almost half of them former eastern bloc countries cut off from the West by the Iron Curtain until 1989. Romania - the larger of the two - and Bulgaria will together boost the EU's population by 30 million, to 490 million, but will add just 1 per cent to its economic output. Other EU hopefuls such as Turkey and countries in the western Balkans now face the prospect of a long wait.

 

____________________________________________________________
____________________________________________________________

4) Spreadsheets

Data processing optimization

A friend gave me a spreadsheet and asked me if I could make it work better. To update it, he had to run one of 700+ macros, depending on what was needed. I found a module with more than 16,000 lines of code totalling over 400K. It consisted mainly of similar macros shuffling data around. They had to be repeated because all the addresses were hard coded by the macro recorder. After looking at all the combinations of data movement, I gave him one 30-line subroutine that did everything the previous bunch did, using the right relative referencing and some mathematics.

If that sounds like any of your spreadsheet files, talk to me ... I may be able to get you more flexibility, speed, and simplicity with less work.

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

http://www.sysmod.com/az.php?a=190540400X&b=Spreadsheet+Check+Control Available worldwide from Amazon.

http://sysmod.buy.ie/catalog/product_info.php?products_id=188  Our offer - free shipping to the 27 EU member countries.

 

_______________________________________________________
_______________________________________________________

FEEDBACK

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

Thank you! Patrick O'Beirne, Editor

_______________________________________________________ _______________________________________________________

5) Off Topic

Usually, this is a light hearted finish to the newsletter. However, this year my holiday reading was Robert Fisk's "The Great War for Civilisation". It would make you want to weep for the hopelessness of suffering humankind, in a problem that has been unresolved in the same span of time as my lifetime. June 2007 is the 40th anniversary of the Six-Day war that had a pivotal role in the troubles before and since. Let's hope that those charged with responsibility still retain enough courage and doggedness to keep trying for a long-term solution.

The Great War for Civilisation: The conquest of the Middle East.

http://sysmod.com/az.php?a=1841150088&b=The+Great+War+for+Civilisation by Robert Fisk

 

_______________________________________________________
_______________________________________________________

Copyright (c) Systems Modelling Limited, http://www.sysmod.com . Reproduction allowed provided the newsletter is copied in its entirety and with this copyright notice.

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 - it's free!

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 will be moderating 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/
_______________________________________________________