About 20 years ago, during a consulting visit to a long term care community, the Director of Nursing was sitting at a computer (rare back then) entering incident data into a spreadsheet. When I asked what she was doing, she said, "My QA reports are due today and I haven’t input any of the incident data. I usually take the reports home and update the spreadsheet, but I ran out of time."
When I reviewed the spreadsheet it was pretty impressive. It allowed me to identify trends and produce graphs and charts. It was all that and a bag of chips!
But there are serious issues with spreadsheets. Let’s talk about the pitfalls of using spreadsheets for tracking and trending incidents and accidents in our communities.