Spreadsheet: 715607d1611783135-multiple-if-statements-within-previous-90-days-2021-scorecard-in_progress
Sheet: CORE Process Audits

Assessment | # of Audits
Process Compliance Total | 8
Area for assessment (30 Days) | # of Audits | # of findings | Audits w/findings | Clean Audits |  | Label
Peer Review |  |  |  |  |  | PEER_REVIEW_PROCESS_AUDIT
Peer_Deficient_Description
Peer_Missing_Required_Fields
Peer_No_Participation
Peer_No_Independence
Peer_No_Config_Control
Peer_No_Criteria
Peer_Unresolved_Issue
Peer_Checklist_Issue
Peer_No_Parent_Baseline
Training | 0 | 0 | 0 |  |  | TRAINING
Training_Peer_Review |  | 0
Training_Risk |  | 0
Training_CCB |  | 0
[NAME] |  | 0
Change Mgmt | 0 | 0 | 2 | 6 |  | CHANGE_MGMT
PR_Deficient_Description |  | 0
PR_Unauthorized_Work |  | 0
PR_Implementation_Detail |  | 0
PR_Verification_Detail |  | 0
PR_No_Config_Control |  | 0
PR_No_Independence |  | 0
Risk | 0 | 0 | 0 |  |  | RISK_MGMT_ASSESSMENT
Risk_Opp_No_Management_Plan |  | 0
Risk_Opp_No_Mitigation |  | 0
Risk_Opp_No_Participation |  | 0
Risk_Opp_No_Meetings |  | 0
Risk_Opp_No_Authorized_Tool |  | 0
Risk_Opp_Not_Documented |  | 0
Risk_Opp_No_Owner |  | 0
Risk_Opp_No_Burndown |  | 0
Risk_Opp_No_Participation |  | 0
Trace/Thread | 1 | 0 | 3 |  |  | TRACE_THREAD
Thread_Item_Incorrect |  | 0
Thread_Trace_Incorrect |  | 0
Thread_Incomplete |  | 0
Trace/Gap | 0 | 0 | 1 |  |  | TRACE_GAP
Trace_Missing |  | 0
Trace_Not_Required |  | 0
Trace_Missing_Rationale |  | 0
Test Witness | 0 | 0 | 1 |  |  | TEST_WITNESS
TW_No_CM |  | 0
TW_Test_Not_Followed |  | 0
TW_Incorrect_Test |  | 0
TW_No_Investigation |  | 0
TW_No_PR |  | 0
TW_Log_No_CM |  | 0
TW_Log_Date_Mismatch |  | 0
TW_Log_No_Results |  | 0
TW_Log_No_PR |  | 0
TW_Log_No_Tester |  | 0
TRR | 0 | 0 | 1 |  |  | TEST_READINESS_REVIEW
TRR_PR_Issues |  | 0
TRR_No_Baselines |  | 0
TRR_Peer_Reviews_Not_Complete |  | 0
TRR_Trace_Not_Complete |  | 0
TRR_Configuration_Not_Controlled |  | 0
TRR_Test_Environment_Not_Controlled |  | 0
TRR_Actions_Not_Addressed |  | 0
CCB | 0 | 0 | 0 |  |  | CCB_EVENT
CCB_Entry_Criteria |  | 0
CCB_No_Evidence |  | 0
CCB_Frequency_Not_Met |  | 0
CCB_Missing_Impacts |  | 0
CCB_Deficient_Description |  | 0
CCB_State_Transition |  | 0
LAST 3 MONTHS DATA (90 days) | # of Audits | # of Findings | Audits w/findings | Clean Audits |  | Label
Peer Review |  |  | SUMPRODUCT('CORE Process Audit data'!J:J,TRUE,'CORE Process Audit data'!D:D,G5) + COUNTIFS('CORE Process Audit data'!J:J,TRUE,'CORE Process Audit data'!E:E,G5) + COUNTIFS('CORE Process Audit data'!J:J,TRUE,'CORE Process Audit data'!F:F,G5)*('CORE Process Audit data'!$G$1:$G$1000<=TODAY())*('CORE Process Audit data'!$G$1:$G$1000>=TODAY()-90) |  |  | PEER_REVIEW_PROCESS_AUDIT
Peer_Deficient_Description | 0 |  | 2136
Peer_Missing_Required_Fields | 0 |  | 2136
Peer_No_Participation | 0 |  | 2136
Peer_No_Independence | 0 |  | 2136
Peer_No_Config_Control | 0 |  | 2136
Peer_No_Criteria | 0 |  | 2136
Peer_Unresolved_Issue | 0 |  | 2136
Peer_Checklist_Issue | 0 |  | 2136
Peer_No_Parent_Baseline | 0 |  | 2136
Training |  |  | 0 |  |  | TRAINING
Training_Peer_Review | 0 |  | 0
Training_Risk | 0 |  | 0
Training_CCB | 0 |  | 0
[NAME] | 0 |  | 0
Change Mgmt |  |  | 2 |  |  | CHANGE_MGMT
PR_Deficient_Description | 0 |  | 0
PR_Unauthorized_Work | 0 |  | 0
PR_Implementation_Detail | 0 |  | 0
PR_Verification_Detail | 0 |  | 0
PR_No_Config_Control | 0 |  | 0
PR_No_Independence | 0 |  | 0
Risk |  |  | 0 |  |  | RISK_MGMT_ASSESSMENT
Risk_Opp_No_Management_Plan | 0 |  | 0
Risk_Opp_No_Mitigation | 0 |  | 0
Risk_Opp_No_Participation | 0 |  | 0
Risk_Opp_No_Meetings | 0 |  | 0
Risk_Opp_No_Authorized_Tool | 0 |  | 0
Risk_Opp_Not_Documented | 0 |  | 0
Risk_Opp_No_Owner | 0 |  | 0
Risk_Opp_No_Burndown | 0 |  | 0
Risk_Opp_No_Participation | 0 |  | 0
Trace/Thread |  |  | 3 |  |  | TRACE_THREAD
Thread_Item_Incorrect | 0 |  | 0
Thread_Trace_Incorrect | 0 |  | 0
Thread_Incomplete | 0 |  | 0
Trace/Gap |  |  | 2 |  |  | TRACE_GAP
Trace_Missing | 0 |  | 0
Trace_Not_Required | 0 |  | 0
Trace_Missing_Rationale | 0 |  | 0
Test Witness |  |  | 1 |  |  | TEST_WITNESS
TW_No_CM | 0 |  | 0
TW_Test_Not_Followed | 0 |  | 0
TW_Incorrect_Test | 0 |  | 0
TW_No_Investigation | 0 |  | 0
TW_No_PR | 0 |  | 0
TW_Log_No_CM | 0 |  | 0
TW_Log_Date_Mismatch | 0 |  | 0
TW_Log_No_Results | 0 |  | 0
TW_Log_No_PR | 0 |  | 0
TW_Log_No_Tester | 0 |  | 0
TRR |  |  | 1 |  |  | TEST_READINESS_REVIEW
TRR_PR_Issues | 0 |  | 0
TRR_No_Baselines | 0 |  | 0
TRR_Peer_Reviews_Not_Complete | 0 |  | 0
TRR_Trace_Not_Complete | 0 |  | 0
TRR_Configuration_Not_Controlled | 0 |  | 0
TRR_Test_Environment_Not_Controlled | 0 |  | 0
TRR_Actions_Not_Addressed | 0 |  | 0
CCB |  |  | 0 |  |  | CCB_EVENT
DATA IMPORT:
Run this filter: | FMS - CORE Audits
Columns needed: | Summary | Key | [NAME] | Created
Export as CSV file
select all and copy to CORE data tab | CORE Process Data