This support article is used in conjunction with the general article on producing reports found here, whilst we develop a customised search and report function. Medberry only currently supports the full RCoA report but we appreciate any frustration at not being able to see your data in a way you want to and is useful.
What we describe here is a way to search your exported data for Obstetric specific cases. Please note that this is used in conjunction with your full RCoA report which gives you a breakdown in a date range of Obs cases with supervision, ASA etc like in this image:
So download your RCoA report and open the file in Microsoft Word. Edit the table so that only Obstetrics appears and you end up with a table like the one above. You can delete the column that says % as this will end up being confusing for the person reading the report.
For the flooding you need to export your CSV data.
The idea here is that we give you an idea of how to sort your data so that it is a little more meaningful for your ARCP. This can be done by using some basic functions of excel.
- Open your exported file in excel. It is currently a CSV file (which basically means the each bit of data is separated by a comma) and you will need to save it as an XLS or XLSX file.
- Hit File > Save and then select XLS or XLSX at the bottom of the screen.
- Hit OK to save the file.
Next we use some functions of excel.
- Open the XLS file
- Click on the data tab
- Hit filter and the top row should change so that all the items have a little arrow next to them like this:
- If we use Obstetrics as an example we would be looking at trying to get the following data:
- Number of epidurals inserted
- Epidural top-up LSCS
- Spinal LSCS elective
- Spinal LSCS urgent
- GA LSCS
- Although some of this data is included in the RCoA report it may not completely accurate for each speciality. Therefore in order to select only Obstetric cases:
- Click on Speciality and then select Obstetric from the drop down menu:
- A the bottom of the screen it will give you a total number of records which should tally up with your RCoA report.
- In order to work out how many Epidurals you have done in Obs you can then repeat the above steps and click on the arrow next to Regional and select Epidural. Looking at the bottom left corner it will give you a total number of Epidurals.
- And so in screen shot it says I have done 30 Epidurals in Obstetrics.
- This can then be repeated for Epidural top-ups LSCS, Spinal LSCS elective, Spinal LSCS urgent, GA LSCS.
These can all be inserted into a table on your report for your ARCP.
Hope that helps