This collection of spreadsheet horror stories gathers high-profile spreadsheet errors, highlighting common problems that can occur and how to avoid them.
This Cautionary Tales podcast episode wrong tools cost lives discusses: ‘Microsoft Excel is great for business accounts… but maybe don’t use it to track a deadly disease. The British Government promised to create a “world-beating” system to track deadly Covid 19 infections – but it included an outdated version of the off-the-shelf spreadsheet software Microsoft Excel. The result was disastrous.’
In these presentations staff from Microsoft Research discuss the programming possibilities opened up by LAMBDA in Excel - new feature that allows you to define custom functions using Excel’s formula language.
In this blog post SSI Deputy Director Simon Hettrick discusses the difficulties he faced in reproducing analysis that was originally conducted in Excel and his journey in moving onto more reproducible tools.
Keep an eye on our blog for an upcoming post on resources to help you move beyond spreadsheets.
If you know of a useful guide or article you’d like added to this list then please let us know at firstname.lastname@example.org. Our future Camps will cover a variety of topics relating to research software – join our mailing list for updates on upcoming Camps.