Alistair Hutchinson

Q: Most popular combinations of things in Numbers iOS

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.

Posted on May 13, 2016 3:15 AM

Close

Q: Most popular combinations of things in Numbers iOS

  • All replies
  • Helpful answers

  • by Kilgore-Trout,

    Kilgore-Trout Kilgore-Trout May 13, 2016 6:16 AM in response to Alistair Hutchinson
    Level 7 (32,519 points)
    iPad
    May 13, 2016 6:16 AM in response to Alistair Hutchinson

    If I understand what you are looking for, you may be able to use COUNTIF across each column to count the number of checked boxes. The syntax is basically COUNTIF(B2:B50,true) where B2:B50 would be the range of cells.

  • by t quinn,

    t quinn t quinn May 13, 2016 7:49 AM in response to Alistair Hutchinson
    Level 5 (4,995 points)
    Mac OS X
    May 13, 2016 7:49 AM in response to Alistair Hutchinson

    Hi Alistair,

     

    I am thinking you will need both COUNTIF() and COUNTIFS().

    Screen Shot 2016-05-13 at 8.24.17 AM.png

    Screen Shot 2016-05-13 at 8.38.37 AM.png

    The footer tries to count the most needed trainings. Higher number would be more needed. You might want to tweak the ">1" to provide a higher threshold.

    You might want an additonal footer that counts the total number of people needing training on each device.

     

    Here is an attempt to automate it further. Higher number is more needed.

    Screen Shot 2016-05-13 at 8.44.12 AM.png

     

    quinn