HI all,
I"m not sure my subject/heading accurately describes what I'm struggling with but I'll try and explain it here a bit better.
I work at a Hospital as a Charge Nurse and as such use a variety of medical devices on a regular basis. All of these devices are subject to different levels of training and different time scales for the training to be done. To facilitate keeping a record of this all staff are required to complete a "Medical Devices Training Record" on a yearly basis, to identify which devices they currently require training for. This is all normally done by hand on paper but this year I have decided to try and let Numbers on my iPad Pro help me out a bit.
I have a spreadsheet that has a list of staff names on the left and the medical devices listed along the top, with each cell simply being a checkbox to indicate whether training is required or not. Using this has allowed me to quickly see which device(s) have the most number of staff saying they require training for (if you're interested it's the paediatric ventilator) and therefore which training is required urgently.
So far so good. What I'm hoping I can do though is identify a number of devices that require training to be organised and have a day or half day of training for the staff that need it. However, simply identifying this through simple numbers i.e. 44 staff say they need training on this device, 39 on that device etc may not work as it may not be the same st that require training on those two devices (or three, or four etc). So what I'm looking for is a way to identify say the top 5 devices that have the same staff saying they need training on. Does that make sense?
Does anyone know how I would go about doing this?
Thanks in advance everyone.
