This section of the website shows instructions about how to produce the monthly reports including the run charts, LocSSIP reports and delirium reports. There is also an explanation of how to process the downloads from the Omnicells to look at drug usage for the month
Video explaining how to process the line insertion data
This data is processed from a paginated report in the Critical Care reports section of Business Intelligence. This should be exported as a CSV file for the previous month. This can then be save as an Excel workbook for processing as shown below. The data are then passed into a workbook that has all the results for the current month and for pervious months
How to process the endotracheal intubation data
The video shows how to process the endotracheal intubation data. Again this comes as from the paginated reports in B.I. It should also be exported as a CSV file and then saved as an Excel file for processing. The report actually doesn’t take very long and uses a pivot table. The headings in the file are not very helpful in identifying which columns you need particularly the “intubation achieved by” which is the column that lists if a video laryngoscope is used. The information is pasted into the Power Point slide of endotracheal intubation that is in the LocSSIP report. The % of intubations that are reintubations is also used in the monthly run charts. The sound on the video is very quite so you will need to turn it up full, sorry.
How to produce the delirium report
The video shows how to produce the delirium report, again the raw data is obtained from a download rom a paginated report in the Critical Care reports section of Business Intelligence. This should be exported as a CSV file for the previous month. This can then be save as an Excel workbook for processing as shown below.
How to update the graphs for the run charts
This shows how to update the data produced from the global measures report from Medicus. The other graphs are produced in a similar way
How to process the Omnicell data to produce mg used per month and number of patients treated
There are a couple of videos explaining this below for different drugs. Having every drug isn’t that helpful as they are basically all the same. The first is for Propofol which is the most complex. The other two sedative drugs are Alfentanil and Midazolam
The next one is for one of the antibiotics. The antibiotics that we are audit as of April 2023 are Tazocin, Co-Amoxiclav, Flucloxacillin, Vancomycin and Meropenem