Spreadsheet: 866562d1713470953-sumifs-will-not-work-correctly-copy-of-iso_13485_training_plan_2021_2
Sheet: ISO 13485 Training Plan

 |  |  | Please apply filters below as needed.
Project Phase | Course | Duration  in Minutes | Library | MREP | Internal Auditor | Exec | Mgr Process Owner | [NAME] | Basic User
PLAN | Getting Started on your Certification | 40 | [NAME] | * | * | * | * |  |  | *
PLAN | Business Impact: Overview of ISO 13485 | 15 | Business Impact |  |  | * | * |  |  | *
PLAN | CORE: Just the Basics | 12 | CORE | * | * | * | * | * | * | *
PLAN | 13485 Overview | 10 | ISO 13485 | * | * | * | * | * | * | *
PLAN | MS Planning for 13485 | 30 | ISO 13485 | * |  | * | * |  |  | *
PLAN | Business Impact: Management System Planning & Leadership | 15 | Business Impact |  |  | * |  |  |  | *
PLAN | Risk-Based Thinking | 25 | [NAME] | * |  | * | * |  |  | *
PLAN | RIsk-Based Thinking_13485 Addendum | 10 | ISO 13485 | * |  | * | * |  |  | *
PLAN | Business Impact: Managing Business Risk | 15 | Business Impact |  |  | * |  |  |  | *
PLAN | Process Planning (9001 AS 13485) | 30 | [NAME] | * |  |  | * |  |  | *
PLAN | Measurement Planning | 20 | [NAME] | * |  | * | * |  |  | *
IMPLEMENT | Document and Record Control | 40 | [NAME] | * |  |  |  |  |  | *
IMPLEMENT | Document and Record Control_13485 Addendum | 10 | ISO 13485 | * |  |  |  |  |  | *
IMPLEMENT | Medical Device File | 20 | ISO 13485 | * |  |  | * | * |  | *
IMPLEMENT | CORE: Authoring | [NAME] Part One | 15 | CORE | * |  |  | PO | * |  | *
IMPLEMENT | CORE: Authoring | [NAME] Part Two | 15 | CORE | * |  |  | PO | * |  | *
IMPLEMENT | Leadership Responsibilities | 20 | [NAME] | * |  | * |  |  |  | *
IMPLEMENT | Business Impact:A Culture of Involvement | 15 | Business Impact |  |  | * |  |  |  | *
IMPLEMENT | Resource Planning | 20 | [NAME] | * |  |  |  |  |  | *
IMPLEMENT | Resource Planning_13485 Addendum | 10 | ISO 13485 | * |  |  |  |  |  | *
IMPLEMENT | Work Environment & Contamination Control | 15 | ISO 13485 | * |  |  | * |  |  | *
IMPLEMENT | [NAME] and Awareness | 30 | [NAME] | * |  |  | * |  |  | *
IMPLEMENT | [NAME] and Awareness for ISO 13485 | 10 | ISO 13485 | * |  |  | * |  |  | *
IMPLEMENT | Corrective Action | 30 | [NAME] | * |  |  | * |  |  | *
IMPLEMENT | Corrective Action_13485 Addendum | 10 | ISO 13485 | * |  |  | * |  |  | *
IMPLEMENT | Advisory Notices | 10 | ISO 13485 | * |  |  |  |  |  | *
IMPLEMENT | CORE: Using Autoforms | 10 | CORE | * |  | * | * |  |  | *
IMPLEMENT | Design and Development_13485 | 40 | ISO 13485 | * |  |  | PO |  |  | *
IMPLEMENT | Understanding Customer and Product  Requirements for ISO 13485 | 15 | ISO 13485 | * |  |  | PO |  |  | *
IMPLEMENT | Calibration | 30 | [NAME] | * |  |  | PO |  |  | *
IMPLEMENT | Purchasing | 25 | [NAME] | * |  |  | PO |  |  | *
IMPLEMENT | [NAME] | 10 | ISO 13485 | * |  |  | PO |  |  | *
IMPLEMENT | Providing Products and Services for ISO 13485 | 15 | ISO 13485 | * |  |  | PO |  |  | *
REVIEW | Business Impact: Evaluating Effectiveness | 15 | Business Impact |  |  | * |  |  |  | *
REVIEW | Internal Auditing | 30 | [NAME] | * | * |  |  |  |  | *
REVIEW | Internal Auditing – Mock Audits | 20 | [NAME] | * | * |  |  |  |  | *
REVIEW | 13485 Tour | 60 | ISO 13485 | * | * |  |  |  |  | *
REVIEW | Where is it Found Exercise for ISO 13485 | 30 | ISO 13485 | * | * |  |  |  |  | *
REVIEW | Preparing for Your Registrar's Audit | 20 | [NAME] | * | * |  |  |  |  | *
REVIEW | Business Impact: Improvement and Maintenance | 15 | Business Impact |  |  | * |  |  |  | *
Rev3 |  |  | =SUMIFS($C$4:$C$43,E4:E43,"*")
 |  |  | =SUM(IF(E4:E43<>"", $C$4:$C$43, 0))
 |  |  | =SUMIF(E4:E43, "<>", $C$4:$C$43)