Spreadsheets aren’t databases! Spreadsheets are the cornerstone of reconciliation reporting and analysis but are not the best repositories for raw data. Any large spreadsheet which is not locked down is almost certain to have errors, and if this is the main storage area for the raw reconciliation data then there will be problems. Databases, whether through a production tracking system or a custom industrial-strength application, are no-brainers for storing raw reconciliation data.
This week’s 30 Seconds of Info is from Ian Glacken – Director of Geology.