I'm Brendan Hyland. I help regulated facilities transform their software, spreadsheets, workflows and documents from time-consuming, deviation-invoking, regulatory burdens, to the competitive advantage they were meant to be. Join me every week as we take a few minutes to explore, design, test and improve the critical systems we use in our facilities.
What are some of the hazards of using a data processing spreadsheet?
Let’s say you want to develop a spreadsheet that’s used over and over again to process batches of data.
What are the some of the hazards to data integrity associated with using such a spreadsheet?
- It might have bugs in it at the time of release.
- Its functionality might change unintentionally during use.
- Someone could use it incorrectly.
- Someone could enter incorrect data.
- Someone could accidentally change data that’s already been entered.
- The software or computer could crash during data entry or processing.
- The spreadsheet full of data could get lost or corrupted.
- The spreadsheet could give different results on different computers with different versions of Excel.
- You could end up with multiple versions of the spreadsheet without knowing which is the ‘correct’ one.
… and so on.
That’s a lot of hazards, and we haven’t yet gone into any specifics about the functionality of the spreadsheet, or even the kind of data it will be processing! Which of these should we be concerned about?
Until next time, thanks for reading!
– Brendan
p.s. Enjoy this message? Read more at the Hyland Quality Systems website.
The Daily HaiQu
I'm Brendan Hyland. I help regulated facilities transform their software, spreadsheets, workflows and documents from time-consuming, deviation-invoking, regulatory burdens, to the competitive advantage they were meant to be. Join me every week as we take a few minutes to explore, design, test and improve the critical systems we use in our facilities.
It’s the first step of the problem solving framework that I was taught back in Engineering school. Not ‘Plan’. Not “Define”. “I want to and I can”. That particular framework - the McMaster Six Step - never gained the popularity of the ones now used today, but in the end they all contain the same basic elements - research, planning & design, implementation, evaluation and iteration - just stated in different ways. However I’ve never really seen this particular element called out explicitly...
My eight year old son figured out a hack to make the music service work better for him. The kids have a Google smart speaker that is attached to a Spotify account so they can just ask for any of their favourite music. Anyone who has pre-teens in the house probably knows how much such a setup is used - all day every day. Coming from someone who had to run to the double-cassette boom box to press the record button any time a new favourite song came on the radio just so I could listen to it...
I’ve seen several quality leaders complain this week about their disappointment with generative AI - they’re not getting the results they expected. And I understand why - context is king! If you just ask AI to write a procedure or generate a quality document, you’ll get generic, mediocre output. Without enough context, AI can only produce something generic based on its training data. But how do you give it that context? By the time you’ve gone back and forth trying to “engineer the prompt” to...