Excel developers' workshop London July 12
Summary of 11th EuSpRIG conference, Greenwich, 15-16 July 2010
Risk and Quality
Spreadsheets
Off Topic
Risk and Quality
Risk and Quality
Spreadsheets
Risk
Spreadsheets
Off Topic
Daragh O'Brien tells me that the few remaining seats for the Information & Data Quality conference next month are FREE for any comers.
They had a lot of people contact IAIDQ saying they wanted to come but there was no training/staff development budget approved yet in their organisations.
The event consists of a one day conference and two half-day tutorials on key issues
in Information Quality and Data Governance, including Data Protection.
http://idq2010dublin-linkedin.eventbrite.com/
Join the Irish Computer Society and the IAIDQ as we host a two-day conference in the
IAIDQ's world-wide IDQ (Information & Data Quality) Seminar Series.
Hear leading Irish and European experts in the field of Information Quality share
with you their insights and experiences. Learn:
Hosted By
IQ Network
1) Risk
2) Quality
3) Spreadsheets
4) Off Topic
WebinarTODAY at 17:00GMT on the 11th of November. In the webinar, you will share a number of stories from the direct experiences of IAIDQ Directors that give an indication of the future trends, issues, risks and opportunities that exist in the Information Quality profession.
Keywords: data quality, information quality, data management, information management, compliance, world quality day, quality management
Systems Modelling can also scan spreadsheet files sent to us. This spreadsheet scanning service suits those who don't wish to install third party software on their servers, or who want an outsourced solution.
Scanxls also reports on other data integrity problems or common formula errors that may exist in the spreadsheet, alerting businesses to problems that they did not know they had.
Contact: Patrick O'Beirne (+353) 5394 22294
UK VAT Rate Change official information
To enter, write an original (and suitable for work!) comment below, describing either:
The submission deadline is 12:00 noon (Eastern Daylight Time) on Tuesday, October 27, 2009. Winners will be announced here on October 28th.
The Ghastly Goodies
Some scarily smart Excel authors, developers and publishers have contributed a monstrous mound of books and utilities for me to give away as treats.
Thanks to all the contributors – Patrick “Ogre” O’Beirne, Jan Karel “The Creeper” Pieterse, Charley “Crypt-Kicker” Kyd, John “Walking Dead” Walkenbach, Jon “Petrifier” Peltier, “Chiller” Chandoo and Matt “Killer” Kennedy.
From Patrick O’Beirne of Systems Modelling Ltd
one copy of XLTest: Spreadsheet testing and auditing add-in — “XLTest helps you to check the integrity of your spreadsheets far more quickly than with tedious cell-by-cell inspection.”
From Jan Karel Pieterse, of JKP Application Development Services:
From Charley Kyd of ExcelUser, Inc.
From John Walkenbach of J-Walk & Associates, Inc.
From Jon Peltier, of Peltier Technical Services:
From Chandoo of Pointy Haired Dilbert
From Matt Kennedy of Apress, 2 prizes – e-books that you can download from the Apress website:
From Debra Dalgleish of Contextures – 3 prizes. The 3 winners can each select one of :
1) Risk 2) Spreadsheets 3) XLTEST Spreadsheet Checking Add-In
Version 1.09 released 5 Web links in this newsletter
Excel Development Guidelines
Named Ranges are being talked about
Eusprig 2010 Conference theme
Two MS employees want your help in making Office Better
Spreadsheet.com auction
Spreadsheet and other Tech Cartoons
To receive updates join the epicenter Community or follow us on Twitter.com/epicenter2009
Kindly Sponsored by
- SUN Microsystems - Vodafone - ESET - Salesforce.com -
- Provident CRM - Realex Payments - Hosting 365 - Agile Technologies - Avnet Technology Solutions -
Barry Alastair says:
We have lined-up world class evangelists, expert technology sessions and a free-to attend expo - so whether you are looking to get stuck into new technology, meet people to do business with, or get a grip on the latest offerings, simply kick back at epicenter because it will be sure to satisfy your needs.
Tickets start at €99.00 and they give you access to all streams.
Additionally, we have put on some complimentary vendor and tech sessions at lunchtime, so feel free to drop in to Trinity College if you're coming by! See expo page for more details.
Keynotes
Web
Microsoft
Java
Open Source
Current Ticket Prices
http://chance.dartmouth.edu/chancewiki/index.php/Chance_News_52
"Cocksure: Banks, battles, and the psychology of overconfidence” by Malcolm Gladwell, The New Yorker, July 27, 2009
1) Risk
2) Software Testing
3) Spreadsheets
4) Off Topic
20 Web links in this newsletter
Experts From Europe and North America meet to discuss the role of spreadsheets in organisational excellence at the 10th annual spreadsheet risks conference on July 2-3 in Paris, France.
Cardiff, UK, June 16, 2009 -- The European Spreadsheet Risks Interest Group (EuSpRIG), is holding its 2009 conference "The Role of Spreadsheets in Organisational Excellence" on the 2nd – 3rd July 2009 at the Ecole Normale Supérieure de Cachan, Paris, France.
The keynote speakers are Dr Louise Pryor, Director of Actuarial Standards for the UK Financial Reporting Council’s Board for Actuarial Standards, and Dr Martin Erwig, Associate Professor of the School of Electrical Engineering and Computer Science at Oregon State University, USA.
Grenville Croll, EuSpRIG chair commented “We welcome our delegates and presenters to Paris and to the 10th Annual EuSpRIG Conference. It is a considerable achievement for any organisation, especially a non-profit and voluntary organisation such as EuSpRIG, to be able to celebrate this important anniversary with such an interesting, expansive and international programme”. Croll cautioned that “Most people do not appreciate the important role that spreadsheets play in our modern society. Nor do they appreciate the risks that we are running with this out of control but ubiquitous technology”. On a happier note, he concluded: “Here at EuSpRIG we offer thought leadership and guidance on the technical and human aspects of examining, containing and controlling spreadsheet technology”.
Speakers include: Susan Allen of HBOS who will be discussing Excel Modelling, Transparency, Auditing and Business use; Grenville Croll of Spreadsheet Engineering Ltd who will be introducing his paper on Spreadsheets and the Financial Collapse; Angela Collins of BDO Stoy Hayward who will describe her work as an Embedded Spreadsheet Modeller and Drs Sriram Iyengar and John Svirbely of www.medal.org and the University of Texas, who will describe their monumental Medical Algorithms project.
Bill Bekenn & Ray Hooper from Fairway Associates will present their curiously, but very appropriately entitled paper “Some Spreadsheet Poka-Yoke”. Professor Tom Grossman and colleagues will be travelling from the University of California, San Francisco to present their work on using the Lookup Technique to Replace Nested-if formulas. The host team of Françoise Tort, François-Marie Blondel and Éric Bruillard will discuss their findings regarding the relationship between errors detection and behaviour observation. They will be joined by their Belgian colleague Étienne Vandeput from the Université de Liège who will look at some milestones involved in teaching spreadsheet programs. A team of five students from the Dundalk Institute of Technology, Ireland, led by Dr Kevin McDaid will present research on Bayesian error estimation, the impact of named ranges on debugging, and a natural language approach to spreadsheet information.
Matthew Dinmore from the University of Maryland Baltimore and a number of individual consultants including Patrick O’Beirne, Angus Dunn, Sebastian Dewhurst and John Hunt complete the line-up of seventeen papers in total.
About EuSpRIG
EuSpRIG (www.eusprig.org) offers Risk Managers the world's only independent, authoritative & comprehensive web based information describing the current state of the art in Spreadsheet Risk Management. We run a well-established annual conference which provides a forum for researchers, practitioners, trainers, vendors, consultants and auditors. EuSpRIG's entire peer reviewed proceedings are published on the publicly accessible Cornell University moderated scientific repository www.arxiv.org. EuSpRIG provide speakers and content for professional societies, associations, conferences and journals. EuSpRIG is a not-for-profit organisation governed by an elected committee operating under the terms of a written constitution. Committee members include senior managers and directors of leading accounting firms and senior academics from European Universities.
EuSpRIG 2009 Conference Co-Sponsors
The following organizations are pleased to support the EuSpRIG 2009 Conference: Baker Tilly, Spreadsheet Engineering Ltd, AuditNet, Systems Modelling, Information Systems Audit and Control Association - Northern UK Chapter, University of Wales Institute Cardiff, University of Greenwich and STEF ENS Cachan. There is an opportunity available for a main conference sponsor.
EuSpRIG Contacts
http://www.eusprig.org
1) Risk
2) Quality
3) Spreadsheets
4) Off Topic
1) IT
1) IT Risk
1) IT Risk
IN THIS ISSUE
1) IT Risk
2) Quality
3) Spreadsheets
4) Off Topic
10 Web links in this newsletter
2) European news
3) Spreadsheets
4) Off Topic
15 links in this newsletter
Systems Modelling can also scan spreadsheet files sent to us. This spreadsheet scanning service suits those who don't wish to install third party software on their servers, or who want an outsourced solution.
Scanxls also reports on other data or formula integrity issues that may exist in the spreadsheet, alerting businesses to problems
that they did not know they had.
Contact: Patrick O'Beirne (+353) 5394 22294
IT Risk
1) Software Testing
2) An appalling Vista
3) Spreadsheets
4) Off Topic
12 Web links in this newsletter
S QC UK conference - 29th to 30th September
http://www.archipelago.gr/en/FieldCourses/MediterraneanDendrology/tabid/76/Default.aspx Archipelagos, Institute of Marine & Environmental of the Aegean Sea, is a
Greek non-profit, non-governmental, environmental organization. It has been
active since 1998 in several parts of the Greek Seas (Ionian Sea, Sporades,
Central Aegean, Lybian Sea, Eastern Aegean). Since 2000, Archipelagos' field of
action has focused on the eastern Aegean, having its main research base on the
island of Ikaria but with activity covering the whole of the Aegean Sea.
Archipelagos action combines scientific research into the biodiversity of the
marine and terrestrial environment of the Aegean Sea and islands, with efficient
conservation work, in which the local communities have an active part.
2) ICT for Development 4)
Off Topic
1) Risk & Security
2) Quality
3) Spreadsheets
4) Off Topic
At Eusprig 2008 I'll be announcing my new XLTest add-in for auditing spreadsheets and looking for beta testers.
1) Risk & Security
3) Spreadsheets 8 Web links in this newsletter
I've read various forums such as
I posted that method to the
Dellcommunity.com forum
but my question is:
Why do I have to go through this rigmarole EVERY TIME I turn on the laptop?
Surely once installed it should recognise the headset the next time I turn it on?
Bluetooth was supposed to make interfacing easier.
With the old plug-in mike+earpieces all I had to do was plug them in and they worked.
Maybe I should go back to them.
UPDATE:
The method I described in my last post does not work any more.
I downloaded what seems to be the latest patch, R140135, but when I run setup I get
I have an email into tech support, got the automated answer, still waiting for a specific answer.
Still waiting, 2 weeks later....
multiply 850 by 77.1 and Excel displays the result to be 100000
David Gainer's Excel blog says:
Powered by Blosxom.
PraxIS July-Aug 2010
Tue, 15 Jun 2010
PraxIS June 2010
http://www.sysmod.com/praxis/prax1006.htm
Michael Bolton in Dublin Sept 2010
Excel developers' workshop London July 12
Eusprig Conference Greenwich July 15-16
XLTest 1.20 update released
ActiveData For Office / SQL is now free
On Programming and Attitude
[]
permanent link
Wed, 19 May 2010
PraxIS May 2010
http://www.sysmod.com/praxis/prax1005.htm
Conferences in Dublin for May & June
Spreadsheets
What not to do in Excel
Off Topic
What not to do in Powerpoint
[]
permanent link
Mon, 12 Apr 2010
Praxis April 2010
www.sysmod.com/praxis/prax1004.htm
Data Protection Commissioner 2009 report
and further resources on the topic
New book: A pocket guide to risk mathematics
Medical errors and their prevention
How to write a successful EuSpRIG paper
Resources for the change from Excel 2003 to 2007
Mon, 15 Mar 2010
PraxIS March 2010
http://www.sysmod.com/praxis/prax1003.htm
Hack attack on SMEs demands $700 to unlock data
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
Trompe l'oeil 3D street art
[]
permanent link
Tue, 09 Feb 2010
PraxIS Feb 2010
Feb 2010
1) Risk
Consumer password worst practices
IDQ Seminar 22-23 Feb 2010 - Dublin
2) In Other news
Social Media, Networking, Twits,etc
Free Accounting software
3) Spreadsheets
EuroCACS Spreadsheet Auditing workshop March 21,
Budapest
XLTEST special offer held open
4) Off Topic
LinkedIn group for Haiti Earthquake Disaster relief
[]
permanent link
Fri, 29 Jan 2010
IDQ Seminar 22-23 Feb 2010 - Dublin
* How Information Quality risks are pervasive in your organisation (and what you can
do to avoid them)
* Proven approaches to communicating the value of information and the value of
information quality to your stakeholders.
* The potential legal ramifications of not managing your Information Assets properly.
* How an Information Quality based approach to other Regulatory and Compliance
challenges can help reap quick rewards in these and other areas of your business.
View/reply to this message on LinkedIn:
http://www.linkedin.com/e/6QL7VHPsRQo-tJSc6kg01B0W/mbi/I1737786114_2/
The IQ Network is a collaboration between the IAIDQ and the
Irish Computer Society that is dedicated to developing and promoting awareness of Information Quality as a Business Challenge and Professional Discipline in Ireland.
The IQ Network operates as a Community of Practice of the IAIDQ for the island of Ireland and as a Professional Network within the Irish Computer Society
[]
permanent link
Fri, 15 Jan 2010
PraxIS Jan 2010
http://www.sysmod.com/praxis/prax1001.htm
Y2K+10
Irish Hospital Data Protection problems
SoftTest Ireland events February 16-18
Irish Computer Society - 6 months free membership
XLTest enhanced with VBA export to folders for Diff
[]
permanent link
Wed, 11 Nov 2009
PraxIS Nov. 09: IRISS, Quality Day, Spreadsheet Safe LinkedIn, Sharpeye
http://www.sysmod.com/praxis/prax0911.htm
1) Risk
IRISS Conference 19th November 2009, Dublin
LinkedIn group Critical Infrastructure
2) Quality
Nov 11 is World Quality Day
3) Spreadsheets
New: Spreadsheet Safe group on LinkedIn
XLTest: Spreadsheet testing and quality check add-in
4) Off Topic
Sharpeye OMR Music scanner software
8 Web links in this newsletter
[]
permanent link
LinkedIn IAIDQ Webinar for World Quality Day
http://events.linkedin.com/Celebrate-World-Quality-Day-IAIDQ/pub/157942
Stories will include:
* The slowly unfolding trends in litigation for poor quality information and what that means for the profession come 2014
* The impact of improved quality information in product development processes in a leading company, how this is increasingly common, and what that means for 2014
* The rising tide of quality information in Environmental sciences and how a leading agency is getting ready to meet the challenges of the future with quality information today.
http://events.linkedin.com/Celebrate-World-Quality-Day-IAIDQ/pub/157942
[]
permanent link
Mon, 02 Nov 2009
ScanXLS helps companies cope with the VAT rate change in spreadsheets
http://www.sysmod.com/scanxls.htm
Companies in the UK and Ireland face another enormous task of changing back price lists in spreadsheets because of the VAT rate reversion from 15% to 17.5% in January 2009.
SCANXLS from Systems Modelling lets you scan your entire hard disk or network for spreadsheets that contain 17.5% or 15%
or combinations that result in gross or net calculations such as 1.175, and 40/47.
http://www.sysmod.com/scanxls.htm
[]
permanent link
Wed, 21 Oct 2009
Scary Fall Giveaway For Excel Nerds
http://blog.contextures.com/archives/2009/10/21/very-scary-fall-giveaway-for-excel-nerds/
A) an Excel related costume (real or imagined).
OR
B) your scariest Excel related experience.
one copy of Professional Excel Development, 2nd Edition
one copy of Excel 2007 VBA Programming For Dummies
one USB key (1 GB) with a set of tools like Name Manager and a free RefTreeAnalyser license (1 copy of this prize is available)
one copy of IncSight® DB: Excel Dashboard Templates Linked to Data — “Set up your first Excel dashboard report in less than an hour. "
one copy of the Power Utility Pak (PUP). — “Power Utility Pak Version 6 (PUP v6) is a useful collection of add-ins that brings significant new functionality to Excel. "
one copy of a PTS Charting Utility – “When installed the utilities provide buttons on the Excel menu or ribbon that allow you to select a regular worksheet range and create a specialized and customized Excel chart.”
one copy of the newly released Project Management Bundle of templates for Excel — “The bundle contains 24 highly reusable excel templates for project planning, task management, timesheets, issue tracking, risk logging, status reporting and more.”
Pro Excel 2007 VBA, by Jim DeMarco (e-book)
Pro Excel Financial Modeling: Building Models for Technology Startups, by Tom Y. Sawyer (e-book)
Beginning Pivot Tables in Excel 2007
Excel 2007 PivotTables Recipes
Excel Pivot Tables Recipe Book
[]
permanent link
Tue, 06 Oct 2009
PraxIS Oct 2009
www.sysmod.com/praxis/prax0910.htm
Fraud check list
"What am I supposed to do with this security prompt?"
Guidelines for Spreadsheet Development
Excel User Conference UK Oct 7,8
[]
permanent link
Wed, 16 Sep 2009
PraxIS Sep 2009
http://www.sysmod.com/praxis/prax0909.htm
[]
permanent link
Wed, 19 Aug 2009
epicenter 2009
The Irish Software Show - epicenter 2009 August 26 - 28th 2009
Weds - Jennifer Condon / Enterprise Irelands 4yr strategy for software companies
Thurs - Prof. Barry Smyth / Co-Founder of ChangingWorlds
The Secrets of an Irish Software Entrepreneur
Friday - Colm Mulcahy / Cloud Evangelist, Founder & CEO of Saaspoint
Why Cloud will shape the Irish Software Industry
Marc Grabanski / MGL Consulting / JQuery Fundamentals / JQuery Advanced
Eugene Ciurana / Independent / Mission Critical Enterprise Cloud Applications
Barry Smyth / ChangingWorlds / Web Search 3.0
Paul Lynch / Hosting 365 / Cloud Computing: The Future Hosting ?
Robin Christopherson / AbilityNet / Don't Make Your Web App a Web Wannabe
Helgi Thormar Thorbjoernsson / Echolibre / Coping with Cyber Monday
Dermot Daly / Tapadoo / Objective C for the iPhone
Damian OSuilleabhain / OS3 / Building iPhone Apps in an Hour
Romans Malinovski / &3% Less Fugly - the Making of epicenter.ie
David Rook / Realex Payments / Web Security #1 / #2
John Wood / iQ Content / Adapting the Agile Agenda to Interaction Design
Eoin Keary / OWASP / Application Security Verification Standard
John Mountjoy / Salesforce.com / The Force.com Cloud Platform
Andy Gibson / Independent / Web Application Testing With Selenium
Peter Kovak / ESET / Malware, Cyber Law & Security Solutions in Practice
Urban Schrott / ESET / Cybercrime
Kevin O'Connor / Hosting 365 / A Market Overview.
Jonathan Forde / Realex Payments / Integrating into Realex Payments
Marco Amoedo (MVP) / MS Dynamics CRM
Jon Skeet (MVP) / Google UK / C# / Code Contracts & Parallel Extensions
Robert Hogg (MVP) / Black Marble / OSLO / PM War Stories
Barry Carr / Independent / F# - What is Functional Testing?
Barry Dorrans (MVP) / Independent / Securing .NET Apps
Bob Duffy (MVP) / ProData/ Microsoft BI / SQL Server Virtualisation
Keith Eccles / Oracle / Oracle & .NET Operability
Richard Fennell (MVP) / Black Marble / ALM with VSTS2008 / Visual Studio & TFS 2010 for the QA/Tester
Niall Flanagan (MVP) / Independent / SQL Server
Aidan Gallagher / Inish Technologies / Software Licensing for .NET Apps
Alex Mackey / Independent / Visual Studio 2010
Craig Murphy (MVP) / Independent / Introducing OpenXML
Phil Bourke (MVP) / Tipperary Institute / A Classic Games Portfolio
To Be Confirmed / Silverlight & Azure
Jeff Genender / Independent / The Rules of SOA
Eugene Ciurana / Independent / Google App Engine - A Java HOWTO
Doug Clarke / Oracle / Developing with JPA and JAXB / JPA 2.0 What's New
Simon Cook / SUN Microsystems / GlassFish / Java & Java FX
Werner Keil / Independent / STEM (Spatio-Temporal Epidemiological Modeler) / JSR-275 Measures and Units
Owen Hughes / Oracle / Oracle Database Evolution
Barry Carr / Independent / Scala - What is Functional Programming
Kevin Noonan / Cannibalising the Google App Engine
Rob Lally / A Scala Web Framework / Intro to Lean, Kanban & Theory of Constraints for Software Managers
Ian Sutton / Visualizing and Measuring Emergent Design
Tim Hodkinson / Liberty IT / Agile Development with Scrum
Anthony Swart / SUN Microsystems / Sun's Identity Management Products
John Meere / Sun Microsystems / Thin Client Computing Live Demo
Tony Jewtushenko / Product Innovator / Software Globalisation for Java Developers
Francesco Cesarini / Erlang Consulting / Erlang
Jan Lehnardt / Independent / Couch DB
John Smedley / Ingres / Ingres CAFE / Ingres within Open Source Community
Helgi Thormar Thorbjoernsson / Websites Releases with PEAR / Migrating databases, just because MySQL sucks
Mel McIntyre / OpenApp / The Health Service Atlas - Python & Zope
Jeff Genender / How to & Being a Good Open Source Committer
Andrea Magnorsky / Monorail MVC
One Day €99.00
Two Day €158.00
Three Days €197.00 plus free O'Reilly book
Contact: Barry Alistair Skype: IrishDev.com LoCall 1890 812 100 / International +353 1 443 4131
[]
permanent link
Fri, 14 Aug 2009
Overconfidence - an optimal margin of illusion
As we grow older and more experienced, we overrate the accuracy of our judgments.
Chance news quotes from an article on the collapse of Bear Sterns:
http://www.newyorker.com/reporting/2009/07/27/090727fa_fact_gladwell?currentPage=all
The author describes examples of a phenomenon that psychologists call the “illusion of control.” This phenomenon obtains when “confidence spills over from areas where it may be warranted (‘I’m savvier than that schnook’) to areas where it isn’t warranted at all (‘and that means I’m going to draw higher cards’).”
[A psychologist] had subjects engage in a betting game against either a self-assured, well-dressed opponent or a shy and badly dressed opponent (in Langer’s delightful phrasing, the “dapper” or the “schnook” condition), and she found that her subjects bet far more aggressively when they played against the schnook. They looked at their awkward opponent and thought, I’m better than he is. Yet the game was pure chance: all the players did was draw cards at random from a deck, and see who had the high hand. ”
[]
permanent link
Thu, 06 Aug 2009
PraxIS August 2009
www.sysmod.com/praxis/prax0908.htm
Hackers unmask fake ATM
450 year old document control processes
McAfee data loss
Salesmanship
Antipodean Spreadsheet Gurus
LinkedIn proliferates Excel groups
Holidays
[]
permanent link
Sat, 11 Jul 2009
PraxIS July 2009 newsletter
http://www.sysmod.com/praxis/prax0907.htm
1) Spreadsheet risk
Report from Eusprig conference in Paris
2) Excel
Hotfix for vanishing range names bug in Excel 2007
3) Off topic: LOL
[]
permanent link
Fri, 10 Jul 2009
Dundalk Inst Tech Student Awarded Prize at Eusprig Conference in Paris
http://irishdev.com/Home/News/581-DKIT-Scoop-Prize-at-Paris-Event.html
Ruth McKeever, Kevin McDaid & Brian Bishop of Dundalk Institute of
Technology, have won the Student Prize this year's annual conference of
the European Spreadsheet Risks Interest Group (EuSpRIG) in Paris.
Their work, "Analysis of the Impact of Named Ranges on the Debugging
Performance of Novice Users," was described by the international panel
of judges, which included Martin Erwig of Oregon State University, as a
'well-designed and thoroughly executed piece of research.'
The research directly challenged the common advice to use range names.
The results show that for novice debuggers "a spreadsheet that contains
range names in formulas will be more difficult to inspect and correct
than a spreadsheet that does not use names in formulas".
http://www.eusprig.org
[]
permanent link
Mon, 22 Jun 2009
EuSpRIG 2009 : Spreadsheet Gurus Meet in Paris
Grenville Croll, EuSpRIG Chair, Spreadsheet Engineering Ltd, +44 (0) 7935 323499
Pat Cleary, EuSpRIG Secretary, UWIC, Cardiff, +44 (0)2920 416070
[]
permanent link
Wed, 03 Jun 2009
PraxIS June 2009
sysmod.com/praxis/prax0906.htm
ISSA Ireland open event on Microsoft Security 10th June
Google Books Settlement Class Action
Softtest Ireland : Professionalism
CSE / ICS free event on Agile
SoftTest free events June 16-18
Eusprig 2009 registration open
Excel 2007 unpredictably losing defined names
Double-take exteriors of buildings by a trompe l'oeil artist
15 Web links in this newsletter
[]
permanent link
Tue, 05 May 2009
PraxIS May 2009
http://www.sysmod.com/praxis/prax0905.htm
Java upskilling in Dublin for only 45 euro
The end of the e-Voting Saga
2) Research
Online Meeting Rooms
DropBox
3) Spreadsheets
Eusprig 2009 Conference
Framework Development Project
Can you describe a financial model as a city?
4) Off Topic
H1N1
19 links in this newsletter
[]
permanent link
Thu, 09 Apr 2009
PraxIS Apr.2009
http://www.sysmod.com/praxis/prax0904.htm
EuroCACS 2009 Frankfurt
2) European research
EuroAfriCa ICT Forum
The Informatics Development and Social Research Institute
3) Spreadsheets
Plus Prefix entry weirdness
Plus wait, there's more...
XLTest 1.06 beta version available
4) Off Topic
April Fool stories
[]
permanent link
Mon, 09 Mar 2009
PraxIS March 2009
http://www.sysmod.com/praxis/prax0903.htm
Survey on risk and rationality
2) Quality
SQC Conference Report
3) Spreadsheets
Ray Butler and Patrick O'Beirne at EuroCACS Frankfurt 15 March 2009
4) Off Topic
Graphing website structure
8 Web links in this newsletter
[]
permanent link
Wed, 04 Feb 2009
PraxIS Feb: Modelling Manifesto, Conferences, 30 years of spreadsheets
http://www.sysmod.com/praxis/prax0902.htm
The Financial Modeler's manifesto
20% Discount on Software Testing Conference Dublin 4 March
Thirty Years of spreadsheets
Ray Butler and Patrick O'Beirne at EuroCACS Frankfurt 15 March 2009
VBA + Excel Performance: MS asks for your Feedback
Michigan man freezes to death after electric company cuts power
[]
permanent link
PraxIS Jan. 2009
09-01 Contents: EuroCACS, SSQC, Euro news,Spreadsheet cleanup
http://www.sysmod.com/praxis/prax0901.htm
1) IT Risk
Presenting at EuroCACS 15-18 March
Software & Systems Quality Conference Dublin 3-4 March
A lesson in application acceptance testing
Slovakia Enters Euro Zone
European art and culture archives online
Unfair commercial practices: advice to consumers
Cleaning up sloppy spreadsheets
Christmas 2008 souvenir
[]
permanent link
Fri, 05 Dec 2008
PraxIS Dec 2008
Dec. 2008
1) IT Risk
Redaction Redux
Irish Reporting and Information Security Service
2) Euro debates
In or out?
3) Spreadsheets
The Daily WTF on the Uncertainty Principle of Spreadsheets
4) Off Topic
Office Offline web comic
14 Web links in this newsletter
[]
permanent link
Thu, 27 Nov 2008
ScanXLS helps UK companies find VAT rates in spreadsheets
http://www.sysmod.com/scanxls.htm
Companies in the UK and Ireland face the staggering task of changing price lists in spreadsheets because of the VAT rate reduction from 17.5% to 15% in Chancellor Darling's stimulus to the British economy, and the increase from 21% to 21.5% in Ireland
SCANXLS from Systems Modelling lets you scan your entire hard disk or network for spreadsheets that contain 17.5% or 21%
or combinations that result in gross or net calculations such as 1.175, and 40/47.
[]
permanent link
Wed, 05 Nov 2008
Barclays plead lawyers' mistake in Lehman purchase
Spreadsheet Safety course
Software to help keep your spreadsheets safe
[]
permanent link
Spreadsheet Safe Company Reaches Dublin Finals of Business Competition
http://www.prlog.org/10136555-novaucds-validus-reaches-dublin-finals-of-prestigious-business-competition.html
NovaUCD’s Q-Validus Reaches Dublin Finals of Prestigious Business Competition
Q-Validus the NovaUCD-based international certification solutions provider has been selected as a Dublin regional finalist in the InterTradeIreland All-Island Seedcorn Business Competition 2008.
Q-Validus, which is based at NovaUCD the Innovation and Technology Transfer Centre at UCD, is developing and delivering innovative assessment and certification programmes designed to improve collaboration, productivity and competitiveness in the modern workplace.
Earlier this year Q-Validus launched Spreadsheet Safe™ an innovative training and certification programme designed to assist businesses in reducing the risks associated with poor spreadsheet design, usage and control.
The Dublin regional finals take place on the 12 November during which Q-Validus will make its investment pitch to a panel of judges followed by a questions and answers session. The winning company in the emerging company category will receive a cheque for €20,000 and a place in the All-Island finals which take place in Belfast on 27 November.
[]
permanent link
Tue, 30 Sep 2008
PraxIS Sep 2008: SoftTest, Appalling Vista, XLTest, Holidays
http://www.sysmod.com/praxis/prax0809.htm
SoftTest Ireland events with Lee Copeland 15-17 Sept.
Vista gets my back up
The cult of statistical significance
XLTest nears release
Holiday snaps
[]
permanent link
Thu, 18 Sep 2008
SQC London Free entry to first 50 respondents
Sep 29-Oct 1
Only six working days left until the SQC - The first 50 people who contact SQC will get a free place to one day of the conference! Call Sam on 020 7448 4682 to book now.
QEII Conference Centre, Westminster
Free entry for one day of the conference to the first 50 people who contact us.
Contact Sam via email or call her on 020 7448 4682 to let her know on which day you would like to attend and quote SQC50.
Industry speakers:
We have a great range of speakers from companies such as Carphone Warehouse, UNUM, Allen & Overy, O2, Lloyds TSB, Microsoft and many more - all of whom will be sharing their experience of testing in the real world.
Topics include:
Running a centralised performance testing service in an Ecommerce world
Testing during the development phase using open source tools
Agile Testing methods in a real world testing environment
The politics of testing: Role plays from the coal face
These are delivered in a variety of formats at SQC which include interactive discussions and workshops so you have much more opportunity to get involved and really understand the topics.
http://www.sqs-conferences.com/uk/
[]
permanent link
Thu, 21 Aug 2008
Our eco-study holiday
In August Megan and I went on a course with
Archipelagos Aigaiou
about Mediterranean flora on the Greek island of
Ikaria and followed up by a few days holiday.
The course was a fascinating insight into the nature of the island and the science of botany and dendrology.
As well as conventional classroom lectures and laboratory examination of specimens that we collected, we went on guided field trips to the Rhanti forest and the Halaris River gorge. Our professor was the botanist Halil Cakan of Cukurova University in Turkey. (On a social note, this illustrates how young scientists can set up normal relations between Greece and Turkey, where there is a long and troubled past, even within living memory.)
Ikaria is an amazing island, unusually green for a Greek island, even in the dry month of August. There are still lakes and reservoirs, and an abundance of pipes strung across the landscape carrying water to the farms.
The Rhanti (Radi) forest is the largest forest of Quercus Ilex holm oak or hollyoak left in the Mediterranean, with some trees 500 years old.
Free-roaming goats eat young tree shoots, so the forest is not being renewed as much as it could be.
It appears that unlike the tethered and cared-for goats that we saw elsewhere on the island, these are simply owned to claim EU grants, and left to fend for themselves. Archipelagos have prepared a video on the consequences of goat breeding on natural environment of Radi forest
We also saw evidence of bark beetle infestation giving the "metro-map" tracks in the cambium (the growing layer of cells just under the bark) similar to those that we saw in the
Banff national park in Canada.
We also walked on one of the hiking trails in Ikaria and I hope to upload some of our photographs later. Because Ikaria has few beaches, it is not spoiled by drunk tourists, so it is mainly favoured by Greek holidaymakers escaping the heat of Athens.
We finished by visiting our friends in Athens who looked after us with true Greek hospitality. As well as the usual museums, we joined thousands of visitors going to see the full harvest moon rise over the Acropolis.
[]
permanent link
Wed, 30 Jul 2008
PraxIS August 2008
1)
Risk & Security
Security flaws plague majority of e-banking sites
The risks of marketing your marketing
The $100,000 keying error
The risks of hacking
IEEE Computer Journal on Computing in Developing
Economies
Eusprig 2008 conference report
More spreadsheet error stories in the news
Ecological Holidays
[]
permanent link
PraxIS Newsletter July 2008
www.sysmod.com/praxis/prax0807.htm
What to do if you suspect or discover fraud
Presentations available on Software Testing
Eusprig 2008
XLTest: A New Addin for Spreadsheet Checking
Don't blame me, I voted ...
5 Web links in this newsletter
[]
permanent link
Fri, 13 Jun 2008
Spreadsheet Hell!
A breakfast briefing for all Chartered Accountants and
colleagues
Date: Thursday, 26th June 2008.
Time: Full Irish breakfast, 7.30am. Presentations 8am sharp, followed by Q&A. Ends 9.30 approx.
Venue: Hilton Hotel, Charlemont Place, Dublin 2.
Cost: €50 per person
CPD: 1.5 hours
The Chartered Accountants IT Services Committee is pleased to host this morning session. Regulatory
pressure for compliance and risk management has created a dependence on spreadsheets which is
increasingly seen as a weakness that needs to be controlled. However, the sheer scale of their use raises
considerable practical challenges in discovery, risk assessment, evaluation, and the control of their
development, maintenance, and use.
These presentations present research and experience into the causes of expensive mistakes from
uncontrolled spreadsheets and describes evolving good practice in both end-user training and management
action to reduce risk.
Contents: Risk and spreadsheet hell : The Spreadsheet control problem : End User Computing (EUC)
issues : Publicly reported problems and what caused them : Real data from those who actually checked :
Evolving good practice recommendations and skills certification : Good practice in detecting and preventing
errors : The appropriate level of review and testing : Software tools, product screenshots : Summary
Patrick O’Beirne, B.Sc. (NUI) MA (Lancs) FICS, is Managing Director of Systems Modelling Ltd. His
current engagements include consulting on spreadsheet compliance methods, best practices in model
development, in-depth training in model audit and review, as well as IT consultancy. He is current chair of
the European Spreadsheet Risks Interest Group (EuSpRIG) and of SoftTest Ireland, and a Fellow of the Irish
Computer Society. He has advised two certification bodies on the content of a syllabus for a new certification
in good spreadsheet practices. His latest book is Spreadsheet Check and Control (Systems Publishing,
ISBN 190540400X)
Dave Carpenter BBS, FCA, is Chief Executive of Q-Validus, a leading provider of international certification
and management services, offering a customized mix of consulting, item and test development, data
management, training, research and software tools to meet the unique needs of its clients. He previously
held the position of Chief Executive of the ECDL-Foundation, the worldwide governing body for the
European Computer Driving Licence (ECDL), and its international counterpart the International Computer
Driving Licence (ICDL), certification programme.
Booking Form
[]
permanent link
Mon, 09 Jun 2008
Eusprig 2008 Programme
www.eusprig.org
An Overview of Spreadsheet Analytics; Tom Grossman
Automating Spreadsheet Discovery & Risk Assessment; E. Perry
Controlling End User Computing Applications- a case study; Jamie Chambers
End User Computing in AIB Capital Markets: A Management Summary; Andrew McGeady
End-User Behaviour Analysis: Supporting Debugging Tool Design and Evaluation; Bishop, McDaid
EuSpRIG and Education and Training; D. Chadwick
Evaluation of an Intelligent Assistive Technology for Voice Navigation of Spreadsheets; Derek Flood, Kevin McDaid, Brian Bishop
Excel and the Accounting and Finance Professional; P Brown, P Alliy
Information and Data Quality in Spreadsheets; Patrick O'Beirne
In Pursuit of Spreadsheet Excellence; G. Croll
Metrics-Based Spreadsheet Visualization; Karen Hodnigg
Overview and Results of DidaTab project; Francois-Marie Blondel, Eric Bruillard
Reducing Spreadsheet Risk with FormulaDataSleuth; Bill Bekenn and Ray Hooper
Revisiting the Panko-Halverson Taxonomy of Spreadsheet Errors; Ray Panko
Self-checks in spreadsheets: a survey of current practice; D. Colver
Spreadsheet Applications - Rules of Engagement; Dick Moffat
Spreadsheet Components For All; J. Paine
Spreadsheet modeling for solving combinatorial problems: The vendor selection problem; Pandelis G. Ipsilandis
[]
permanent link
Wed, 04 Jun 2008
PraxIS June 2008
E-Voting Banned by Dutch Government
Medical IT risks
June SoftTest Ireland events
Eusprig 2008 programme announced
Another Excel problem solved
ICAI Spreadsheet Risk briefing
Quotes
[]
permanent link
Mon, 26 May 2008
25 Aug, 2007: BH200 Vista not working
Dell Bluetooth headset woes
I have a Inspiron E1405/640M with Vista Business
Dell Truemobile 355 Bluetooth + EDR
Driver date 21/06/2006 version 6.0.6000.16398
Bluetooth headset BH200
http://www.notebookforums.com/thread178221.html
http://forum.notebookreview.com/showthread.php?t=137370
and the Dell support troubleshooter:
"Problems With the Dell BH200 Bluetooth 2.0 EDR Stereo Headset"
---------------------------
Bluetooth Software
---------------------------
This installer be run on Windows Vista only.
---------------------------
If that message had 'Aaarrr' in front of it that would be talk-like-a-pirate software, but I presume the word 'must' is missing. Which is useless as I *am* running Vista Business.
[]
permanent link
Sep 27,2007: Excel 2007 float bug at 65535
microsoft.public.excel is discussing this problem:
The Problem
This issue was introduced when we were making changes to the Excel calculation logic in the Office 2007 time frame. Specifically, Excel incorrectly displays the result of a calculation in 12 very specific cases (outlined below). The key here is that the issue is actually not in the calculation itself (the result of the calculation stored in Excel's memory is correct), but only in the result that is shown in the sheet. Said another way, =850*77.1 will display an incorrect value, but if you then multiply the result by 2, you will get the correct answer (i.e. if A1 contains "=850*77.1", and A2 contains "=A1*2", A2 will return the correct answer of 131,070).
So what, specifically, are the values that cause this display problem? Of the 9.214*10^18 different floating point numbers (floating point on wikipedia) that Excel 2007 can store, there are 6 floating point numbers (using binary representation) between 65534.99999999995 and 65535, and 6 between 65535.99999999995 and 65536 that cause this problem. You can't actually enter these numbers into Excel directly (since Excel will round to 15 digits on entry), but any calculation returning one of those results will display this issue if the results of the calculation are displayed in a cell. All other calculation results are not affected.
Other posts on that blog show how the value of 100000 can be propagated rather than just be a display problem.
Joel Spolsky gives his explanation at
http://www.joelonsoftware.com/items/2007/09/26b.html
[]
permanent link