Recent Comments
Patrick O'Beirne, Ex… on Excel formula to test if a wor… Peter Bartholomew on Excel formula to test if a wor… Rick Rothstein on Excel formula to test if a wor… Patrick O'Beirne, Ex… on Excel formula to test if a wor… Peter Bartholomew on Excel formula to test if a wor…
Category Archives: Software Testing
A look ahead to Eusprig 2019
The 20th annual conference of the European Spreadsheet Risk Special Interest Group (http://www.eusprig.org) will be held on July 11 & 12 at The Barrister’s Court, Browns, 82-84 St Martin’s Ln, Covent Garden, London WC2N 4AG, UK. David Lyford-Smith of the … Continue reading
Posted in eusprig, Excel/VBA, Research, Software Quality, Software Testing
Tagged Excel tutorials, Spreadsheet management, spreadsheet risk
Leave a comment
Extend Excel: London 18 Oct
Charles Williams is organising a conference in London on October 18th, 2018. I’ll be there! This is a rare chance to meet leading developers from all over the world and hear directly from MS on Excel Extensibility. Expect to be … Continue reading
Posted in Excel/VBA, ExcelDna, Open Source, Productivity, Research, Software Quality, Software Testing, Uncategorized
Tagged Conference, Excel Developers
Leave a comment
Free Add-In to profile VBA speed and coverage
This post is now replaced by an update: https://sysmod.wordpress.com/2021/07/06/vba-performance-profiler-timing-procedure-execution/ ———————————————- I’m making available a beta version of my VBA performance profiler for people to try it out and let me know what they think. I’m interested in seeing what kinds … Continue reading
Posted in Excel/VBA, Software Testing
11 Comments
Tracing & Profiling VBA speed with TraceSpy
I’m interested in measuring VBA performance. I add tracing calls to the routines so I get the time on entrance and exit. I also optionally add a call to trace every line executed, which I use when I get unexpected … Continue reading
Posted in Software Testing, Uncategorized
Leave a comment
Rubberduck VBA addin
The Rubberduck VBA (@rubberduckvba) open source project has been going for a couple of years, and when I was reminded of it recently I decided to give it a try. It’s definitely a help in VBA development and I’ll go on … Continue reading
Posted in Excel/VBA, Open Source, Software Testing, Uncategorized
Leave a comment
Excel & Genes: mutation and curation
On 23 Aug a paper by three Australian authors gained much publicity about how Excel interprets data entry and how the users don’t check their data. http://genomebiology.biomedcentral.com/articles/10.1186/s13059-016-1044-7 Gene name errors are widespread in the scientific literature. By Mark Ziemann, Yotam … Continue reading
Posted in Excel/VBA, Research, Risk, Software Testing
4 Comments
Eusprig 2016 July 7, London
The European Spreadsheet Risks Interest Group 17th Annual Conference (EuSpRIG 2016) will be held at the Institute of Chartered Accountants in England and Wales (ICAEW), Moorgate, London, on the 7th July 2016. http://www.eusprig.org/annual-conference.htm The programme is now available. Register now to … Continue reading
Posted in Excel/VBA, Research, Risk, Software Testing
Tagged Audit, Conference, eusprig
Leave a comment
VBA Code Tracer / Profiler
A VBA module to insert code to trace the execution of VBA code. Continue reading
Posted in Excel/VBA, Software Testing, Uncategorized
Leave a comment
SoftTest Ireland Conference 2015 – Future Proof your Software Testing
SoftTest Ireland in association with the ISA Software Skillnet are hosting a one-day national conference for software test professionals. Date: Wednesday 23rd September 2015 9am – 5.30pm Venue: Clyde Court Hotel, Ballsbridge, Dublin 4 Cost: €100.00 per delegate Book here: … Continue reading
Irish Computer Society evening talk on Spreadsheet Controls
My talk on “Spreadsheet Management and Controls” is next month at the ICS. Monday 18:00 – 19:30 9th Jun This session outlines current concerns about risks from the uncontrolled use of spreadsheet-based information systems. The session will cover how to … Continue reading
Patrick O'Beirne @ sysmod 