Menu
Menu
Using MS Excel as a typewriting tool does work, but by implementing a few hacks, you can get so much more out of it, and most importantly, you can save time. In the video below I will show you how to let MS Excel colour your risk evaluation results automatically.
If you, like many others, colour code your risk evaluation results in your risk analysis, mistakes can easily happen. When you update the Probability of occurrence of harm or Severity and actually change the status of the risk from acceptable to unacceptable, the colour coding should follow. In another video we have made MS Excel fill in the risk evaluation matrix automatically, so you don’t have to worry about that, but what about the colour?
This video will show you how to colour cells using conditional formatting that will reduce the risk for mistakes in your risk analysis.
Remember that when implementing this functionality in MS Excel spreadsheets, you may be required to validate the spreadsheet.
If you want to try the function out for yourself, you can download a free hazard traceability matrix template that includes the formatting described in the video.
Let me know how it works in the comment field!
Get instant access to our online Risk Management course on ISO 14971:2019 right here. In 10 hours, you can learn more about how to estimate risk and perform risk management. This course is taken by both competent authorities, notified bodies and medical device manufacturers and distributors.
Peter Sebelius is a highly esteemed trainer, consultant and entrepreneur in the medical device industry. He is a member of the Joint Working Group that is revising the ISO 13485 and ISO 14971 standards.
He has vast ‘hands on’ experience, having developed, amongst other things, a mechanical chest compression device and an ex vivo perfusion machine for lungs. He has received numerous awards including the Great Design Award and the title “This year’s specialist” by Veckans affärer.
Receive FREE templates and quarterly updates on upcoming courses that can help you in your career! Subscribe to our newsletter now.
When you submit this form, you will be sending personal information to medicaldevicehq.com. To comply with GDPR requirements, we need your consent to store and use the personal data you submit. Take a look at our Privacy policy for more details.
