Monthly Archives: November 2011

Dictionary VBA Class update

I’ve uploaded a new version of the Dictionary Class and a helper KeyValuePair Class. This exposes the KeyValuePairs collection so iteration is now very fast, about 2 seconds to iterate 1 million items using a for each loop:   dim oKeyValuePair … Continue reading

Posted in Excel/VBA | Tagged , , , , | 23 Comments

The Science of Spreadsheet Risk Management, July 5-6 2012, Manchester UK

The European Spreadsheet Risks Interest Group (www.eusprig.org) has issued a call for papers for their 13th Annual Conference on the theme “The Science of Spreadsheet Risk Management”. The conference will be held on the 5th and 6th of July 2012 … Continue reading

Posted in Excel/VBA, Risk | Tagged , , , , , , , , | Leave a comment

SoftTest Event With Geoff Thompson and Graham Thomas in Galway, Dublin and Belfast

SoftTest Ireland (www.softtest.ie) in association with its sponsors (InterTrade Ireland, Sogeti and Software Skillnet) would like to announce the following events in Belfast, Galway and Dublin featuring two international speakers Geoff Thompson and Graham Thomas. Full details at http://softtest.ie/sign-up-for-our-next-event-with-geoff-thompson-and-graham-thomas/ “Testing, … Continue reading

Posted in Software Quality | Tagged , , , , | Leave a comment

Software Development Productivity Analytics?

Does anyone know of current methods to record developer time with some kind of analysis either post hoc review or concurrent notetaking to show where time is being spent? In the Personal Software Process (PSP) the first stage is to … Continue reading

Posted in Software Quality | Tagged , , , , , | Leave a comment

Spreadsheet Guru Contest, CA, April 15th 2012

From the INFORMS Spreadsheet Productivity Interest Group (SPRIG) “Speaking of conferences, we’re extremely excited to announce that the First Annual SPRIG World Spreadsheet Guru Contest will be held at the 2012 Analytics Conference in Huntington Beach, CA on Sunday, April … Continue reading

Posted in Excel/VBA | Tagged , , , , , , , , | Leave a comment

Free Excel formula highlighting tool

My main product is the XLTest addin that does a comprehensive shakedown of Excel workbooks. I’ve picked out the most popular feature, colour coding cells by formula region, and give it away as a free taster, the XLTest Colorizer. It … Continue reading

Posted in Excel/VBA, Risk | Tagged , , , , , , , , , , , , , | Leave a comment

Excel developer conference London Jan-2012

Agenda is being formed by leading European Excel dev Simon Murphy, proposals still being welcomed: http://smurfonspreadsheets.wordpress.com/2011/11/03/excel-developer-conference-london-jan-2012/

Posted in Excel/VBA | Tagged , , | Leave a comment