How To Create-Track-Monitor Incident Report Using Excel?

Hak Yek Tan

Incident Reporting in Hospitals

In the healthcare industry, incident reporting is an important task that records all the unusual events occurring at hospitals, nursing homes, and other medical facilities. An incident report is a formal report written by practitioners, nurses, or other staff members to inform facility administrators of incidents that allow the risk management team to consider changes that might prevent similar incidents. The forms used for incident reports are either paper forms or electronic.

Despite all the advances in medical technologies, Incident management remains a paper-based manual process in many hospitals. We understand that multiple factors drive these decisions. We talk about the effects of a paper-based vs a digital system on the incident reporting process here.

The first knock of a transition from paper medical records to electronic come after the American Recovery and Reinvestment Act (ARRA) 2009. This law encouraged healthcare providers in the United States to digitize internal record systems and develop a centralized database so that doctors, physicians, and nurses can easily access health records. 

However, moving from a paper-based system to a paperless one isn’t that simple and easy. That’s why many healthcare facilities haven’t gone completely paperless even after a decade of modern record system. They might be trying to avoid a few hurdles, but in reality, they are facing multiple challenges daily with the paper-based method, such as:

  • Time-consuming
  • Ineffective Data Presentation
  • Not scalable
  • Limited security
  • Missing Audit trail and tracing
  • Prone to error
  • Difficult to analyze

Therefore, healthcare facilities required fast, secure, and quick incident reporting. In short, they need an automated incident reporting system. But, as of now, only two-thirds of hospitals have focused on automation. 

Create-Track-Monitor Incidents using Excel

We have been working with healthcare facilities for years now, so we duly understand that automation isn’t an easy task. It is an expensive and technical process that not all hospitals can adopt.

We are here to help you with an alternative, that won’t cost you a dime. A free, reliable, and effective incident management system for medical facilities— Excel reporting.

For hospitals that are not yet ready to dive into software systems for incident reporting, using Excel is an inexpensive and reliable option, as it can quickly get you off the ground. In this article, we’ll discuss how you can use Excel to maintain and track your incidents.

To manage all incidents in one place, and analyze them effectively, the quality manager needs to organize different sets of data to draw conclusive statistics. However, when incidents are recorded in papers, analyzing the data or locating patterns is a daunting task. Thus, a need for meaningful data emerges where data is easily readable and interpretable.

For Example—

In a paper-based reporting, an incident description will be recorded like this:

“A Patient A was sleeping on his bed in Ward No. 2. While turning in his sleep, he fell from the bed. The attending nurse immediately rushed to him and helped him get back onto the bed and put the bed rails up. The patient did not sustain any injuries.”

Now, if same information is captured in structured format, it will look like this:

Incident Type: Patient fall
Incident Subtype: Fell from bed
Incident Location: Ward 2
Affected People: Patient A
Injury: None

It is evident that the data recorded in the second style is easier to navigate, analyze and interpret. Therefore, the way you record data makes a huge difference in the analytical process.

If you are using paper forms for reporting and managing incidents, we have even eased your  work by creating an Incident Report Excel Template along with a process to custom create incident reports in Excel.

How to structure your data

When you want to gain insightful information from an incident report, you have to record every minute detail in it. However, the amount of report details depends upon your organization’s size, patient safety goals, claim frequency, and other relevant factors. In a hospital incident report, it is essential to add the following details:

Incident occurrence date

The well-informed incident report needs basic information such as the date and time of the incident. This is one of the most important pieces of information especially useful to calculate statistics and performance.

Location of the Incident

Specifically, mention the location of the incident along with the particular area within the hospital—for example, patient X fall in Ward no. 2 near the bed. When you use Excel, it is a good idea to make the Location field into a dropdown field. Generate a list of all possible locations, from the lift lobby to OT, and select from the values, rather than typing it as text. This helps you to convert ‘Location’ into a measurable field and you can generate statistics out of it, such as, “What is the most prone location for a fall?”.

Type of the Incident

This is the key information that will help you in analyzing and processing your data, as well as generating your statistics for the management. You can categorize the incidents as Medication Error, Patient Fall, Equipment Damage, Patient Identification, etc. When you use Excel, it is a good idea to make the Incident type field into a dropdown field. Create a list of all the incident types you want to capture and select from the values, rather than typing it as text. This helps you to convert ‘Incident Type’ into a measurable field and you can generate statistics, such as, “What is the most common incident in my hospital last year?”.

Parties Involved in the Incident

The name and contact details of all the parties involved in the incident to follow up. If there are witnesses available to the incident, it will be helpful to add their statements in your report. While writing witness statements, focus on the following attributes—specific details provided related to the incident, use quotation marks to frame their statements, note witnesses’ location at the time of the incident, and how they are related to the incident.

Detailed Incident Description

The incident description is provided by the person who reported the incident. This can be as detailed as it can get, as more the information in hand, the better it is to investigate it further.

Comments

Once you have all the information from the reporter, you can track the incident in excel by recording all the follow-up discussions, comments given by Supervisor or other managers all in one single row in excel!

Risk Assessment Score

Whether you use a 5×5 Risk matrix or a SAC scoring of 1 to 4, you can enter the severity risk score against the incident, again in the same row!

Contributing Factors

Except for minor incidents, everything else will most likely go through a root cause analysis and investigation process. It is a good practice to maintain a list of all the Contributing factors, (either London Protocol or you can follow your hospital guidelines) and select from the values, rather than typing it as text. This helps you to convert ‘Contributing factors’ into a measurable field and you can generate useful statistics, such as, “What is the top contributing factor for my incidents?”.

What is Meaningful Data?

Meaningful data is, in simple terms, usable statistics and actionable insights that can be used to evaluate the efficiency and effectiveness of your process. The meaningful data answers numerous aggregated questions, provide you useful insights without many efforts

  • How many fall incidents happened last month?
  • How many medication errors occurred last year?
  • What percentage of incidents are still open?
  • What is the most common occurrence?
  • Which location is prone to more falls?

As we have cleared in the above example that paper-based recorded data can’t help you find aggregated results without spending hours or days of effort. But, with excel, you can utilize the features such as a drop-down list and data filters to derive this meaningful information quickly.

Download our ready-to-use Excel template

If you don’t know how to turn a vanilla Excel spreadsheet into an incident report sheet, do not fret! Download our ready-to-use Incident Manager Template. The template contains all the information that you minimally need to capture and provides some incidents for reference. You can customize the template to suit your needs, especially the parent list of incident types, list of departments, and statuses. In the following sections, we also explain how you can do this.

However, if you want to build your own custom incident manager spreadsheet from scratch, read more as we walk you through the process.

Customize your Incident Manager Excel template

How to Create a Drop-down for Columns?

Drop-down is a very useful Excel feature where you can sort relevant information based on your requirements. For instance, using our template you can easily sort information based on incident type and contributing factors. However, to create a custom drop-down list, you can follow these steps:

  • Select the cells that you want to contain the lists.
  • On the ribbon, click DATA > Data Validation.
  • In the dialog, set Allow to List.
  • Click in Source, type the text or numbers (separated by commas, for a comma-delimited list) that you want in your drop-down list, and click OK.

Here is a video explaining this step by step.

How to Use Filter Function?

The filter function allows users to easily extract matching records from a larger set of data based on certain criteria. Suppose you want to know how many open incident cases were present in Ward No. 2, our incident template will immediately show you—just follow these instructions:

  • Select any cell within the range.
  • Click on Data > Filter.
  • Next, select the column header arrow.
  • Now, you can choose between Text Filters or Number Filters.

For eg. To know the number of open incidents, you should select the Status field and select ‘Open’ (unselect ‘Closed’).   To know the number of such open incidents in Ward 2, you should select the Location field and select ‘Ward 2’.  Now you have the narrowed down list of Open incidents from Ward2.

How to Create a PivotTable?

In Excel, you can use PivotTable to calculate, summarise and analyze data present in your report. Additionally, you can easily compare and find trends in your data. With our template, you can create Statistics on Incident Types or by departments or by status.

PivotTable works a little different depending on what platform you are using to run Excel, but the simple way to create PivotTable is:

  • Select a cell where you want to create PivotTable.
  • Select Insert > PivotTable.
  • Under Choose the data that you want to analyze, you can Select a table or range.
  • Verify the cell range in Table/Range.
  • Under Choose where you want the PivotTable report to be placed, you can select a new worksheet or an existing one to add PivotTable and select OK.
  • You can add fields to your PivotTable, click on the field name checkbox in the PivotTables Fields pane.

How to Refresh PivotTable?

When you add new information to our pre-made worksheet, you need to refresh the PivotTable to provide updated statistics to you. To refresh PivotTable:

  • Click anywhere on the PivotTable to appear the PivotTable Tools ribbon.
  • Select Analyze > Options.
  • Go to the Data tab, check the Refresh data when opening the file box.

How to Create Graphs?

To better analyze incident data, you can convert it into a graph and chart with our template. The graph can be created in Excel as:

  • Select a cell.
  • Choose a graph from the nine graph and chart options.
  • Highlight your data and click on ‘Insert.’
  • Adjust data’s layout and colors.
  • As per your requirements, change the size of the graph and axis labels. 

Here is a video that explains this step-by-step

Download template

Get started today by downloading this Incident Report Template we created for you to easily start managing your incidents. The template contains all the minimal information that you need to capture. You can customize this template to suit your needs, especially customizing the parent list of incident types, contributing factors, list of locations, and departments. 

QUASR Lite

QUASR Lite is the simplest online incident managing software you have been looking for. The main advantage QUASR Lite brings to you over vanilla excel sheets is that: we have built it specifically for hospital incident scenarios. We consolidated our experience working with many hospitals and created a starter tool that will grow with you as you mature into bigger and more involved processes. You’ll be able to attach evidence, share reports with selected staff or departments and notify senior management of serious incidents. Since it is digital, you can effortlessly search, sort, or churn statistics for those important management meetings.

QUASR Lite is aimed at organizations that are just getting started or wanting to digitize their incident management process. Whether you have a simple paper-form method or looking to create your own structure and process, QUASR Lite has you covered.

Check out more features of QUASR Lite. You can sign up for a 14-day free trial here.

Digitization – A Pathway Towards Digital Transformation

Hak Yek Tan
Digitization-vs.-Digitalization-Banner

If we look back two and half decades, businesses have to provide input to their computing devices to convert data into a digital format.

Leaping for a few years, businesses gain capabilities to process data over digital technologies instead of the manual or offline system.

This digital evolution is called digitization to digitalization!

Confused?

Like their spellings—digitization and digitalization are insanely interlocked together that anyone can get confused between both terminologies. However, if we try to explain in one line

—‘digitization is information’ and ‘digitalization is a process.’

We know it still doesn’t give away why digitization and digitalization are different when they both deal with processing and interpreting information?

So, let’s dig deeper and understand what lies in the roots of digitization and digitalization.

What is Digitization?

According to Oxford's Dictionary — “Digitization is the process of changing data into a digital form that can be easily read and processed by a computer.”

In layman’s terminology, digitization is a method to turn information into binary digits (1’s and 0’s) so that computers can easily understand and process it.

In this process, the user takes analog information such as photographs, soundtracks, or documents and converts them into a digital form that can be stored and accessed by digital devices.


For example
, a hospital converting patients’ paper records into Excel sheets for better preservation and access. Additional examples—scanning old documents to PDFs, transforming printed reports to meaningful data, turning a vinyl record into an MP3 file, and so on.

 

Whether you wish to preserve old information or capture new information for later use, the information dealing process will be called digitization

Why is Digitization Important for Your Business?

According to a McKinsey report, the pharmaceutical and medical industry shows the least amount of digital frontier gap for 13.4% and travel sector maximum for 51%. In this, if you are still wondering why to take a step towards digitization, reasons are:

Market Trends:


It doesn’t matter which industry you are part of—the digital wave is everywhere. Thanks to cheap internet services and smart gadgets, today, digital technologies are in everyone’s hands. From booking a cab to consulting a doctor, everything is digital—now, it’s up to you whether you want to be part of the trend or not?

Improve Efficiency:


Your paperback business documents are prone to theft, loss, wear and tear—with no way to replace them. Therefore, if you don’t want to reduce your business efficiency due to inefficient information, safely store your data in a digital format.

Better User Experience:


Presently, a fast and smooth user experience is an imperative way to grow your business, which you can’t achieve via manual services. The progressive businesses have completely understood this phenomenon, such as Pizza Hut started taking their customers’ orders through the interactive touch screen in their restaurants.

Limited Growth:


If you haven’t digitized your data yet, you cannot take leverage from the new growth and marketing metrics such as social media.

What is Digitalization?

If you search for digitalization definition on Oxford’s dictionary, you will receive the same definition as digitization.


Wait, what?

Then, how come both terms are different?

Well, they are different—trust us, just let us break the concept for better understanding. Earlier, we mentioned that when a hospital converts patients’ records into Excel sheets, it’s digitization—but, when a hospital receives patients’ records in email and adds them into Excel sheets, records are already digitized; thus, this concept will be called digitalization.

So, digitalization is a process of converting information into different digital equivalents. For instance, recording a patient’s data using a digital registration method is digitalization, but scanning printed records into digital form is digitization.

Digitalization is an ongoing process as new technologies are emerging and expanding the further scope of digital development. Therefore, twenty-first-century businesses can’t avoid digitalization!

Why Is Digitalization Important for Your Business?

Roughly 4.66 billion people around the globe are using the internet at the beginning of 2021—that means 60% of the world’s population has embraced digitalization. However, if you haven’t digitalized your business yet, you should because:

Collaborated Team: When marketing and technical teams collaborate together, they can better understand customers’ needs and find better solutions to satisfy them. Using the analytical tool, the marketing team can effectively analyze market trends and provide correct data to the sales team to quickly convert potential leads into customers.

Improved Data Collection: Nowadays, businesses are busy collecting mountains of data related to their customers, but the real benefit is optimizing collected data for analysis. With digitalization, a system can gather the right data and intelligently analyze it.

Resource Allocation: Digitalization can consolidate business resources into a centralized software for easy access. In 2020, businesses used an average of 900+ applications to run their operations, which makes it very hard to derive information from the various portal. Digitalization can help in streamlining different data silos to provide efficiency across units.

Elevated Profits: Digitization pushes businesses towards better efficiency and profitability. According to the SAP Center for Business Insights and Oxford Economics report, —80% of fully digitalized companies have recorded upward growth in their profits. Now, this fact is sufficient to know to prove how digitalization can improve business profits.

Key Differences Between Digitization and Digitalization

For better clarification on the notion—‘digitization is information’ and ‘digitalization is process’—let’s understand what primarily set both terms apart.

Information Conversion

In both terms, information is converted from one form to another. Where digitization is converting analog information into a digital form, on the contrary, digitalization transfers information to equivalent digital devices. The information might be a common factor here, but the way to deal with it is completely different

Basic Purpose

Digitization is performed to make information highly accessible to a company. Imagine, when a hospital wants to retrieve the gynecologist department’s records for 2012, the manual search might take lots of time—even if all the documents are chronologically arranged. On the other hand, digitized records can be retrieved with one click, which makes it easy to access information.

 

The purpose of digitalization is beyond accessing information; it is a process of analyzing and interpreting information to improve productivity and efficiency. Such as, once the hospital has received information, they can analyze the gynecologist department’s data and interpret comparisons between 2012 and 2021 performance rates.

Functionality

Both terms are polar apart on the functionality grounds—digitization operates to store information permanently, and digitalization focuses on improving data accuracy.

For instance, a healthcare clinic can create permanent data backup digitally so that natural calamities, theft, or other incidents won’t damage their vital information. Next, they can form a correlation between information and arrange systematically to provide solutions. In a way, digitization stores information, and digitalization process that information.

Nature of Data

Digitization is performed to make information highly accessible to a company. Imagine, when a hospital wants to retrieve the gynecologist department’s records for 2012, the manual search might take lots of time—even if all the documents are chronologically arranged. On the other hand, digitized records can be retrieved with one click, which makes it easy to access information.

 

The purpose of digitalization is beyond accessing information; it is a process of analyzing and interpreting information to improve productivity and efficiency. Such as, once the hospital has received information, they can analyze the gynecologist department’s data and interpret comparisons between 2012 and 2021 performance rates.

Tools

Digitization and digitalization aren’t possible without adequate tools. For digitization, input tools are mainly used like Scanner, Digital Camera, Storage & Retrieval Systems, OCR Software, and others.

Multiple software solutions are used to accomplish the digitalization process, such as ERP Software, Messaging & Conferencing Software, Predictive Maintenance Systems, Robotics & Controller Systems,, and more.

Example

Suppose a doctor is conducting a study on traditional chronic diseases. For research purposes, he collected multiple handwritten paper manuscripts of his old patients and converted them into a checklist app to easily access the relevant information for his research.

Next, he used digital technologies to process and analyze data in real-time and draw insightful conclusions to include in his study.

Future of Digitization & Digitalization — Digital Transformation

Digitization was started around 25 years back when computer systems became part of mainstream activities—so we can say that it’s now completed.

After digitization, the digitalization process began and continued to evolve with the introduction of new technologies. Slowly, digitalization is moving towards the digital formation—the future.

Digital transformation is a high-level digital business perspective where strategic decisions are made to take leverage from all digital technologies and change the overall approach of the business to create a resilient environment.

It is a broad framework, which is still evolving with the help of new technologies. It is projected that the global digital transformation market size will expand at a CAGR of 22.5% between 2020 to 2027

Wrap Up


On parting thoughts, digitization deals with information, digitalization manages processes, and digital transformation happens to be a reformation. If we say digitization was the past and digitalization is the present, digital transformation is definitely the future.

 

So, it is step after step, which businesses should embrace to stay ahead of the competition and prepare themselves for the future.