{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Risk Profile","Reference Card","Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Risk Profile","index":0,"n_rows":15,"n_cols":18,"rows_kept":15,"cut":false,"hidden":false,"merged":[[4,15,5,15],[4,5,5,5],[4,6,5,6],[0,3,1,8],[0,9,1,17],[3,13,3,17],[4,17,5,17],[4,16,5,16],[4,1,5,1],[4,2,5,2],[3,6,3,12],[3,0,3,5],[2,3,2,8],[4,0,5,0],[4,4,5,4],[4,3,5,3],[4,7,4,9],[4,12,4,14],[4,11,5,11]]}
[null,null,null,"Note: To remove or edit any entries, please use \"Delete\" or \"Clear Contents\" in order to clear contents in the cell first and then re-enter the correct information; otherwise the existing entry and edit/change will continue to repeat themselves in the cell."]
[]
[null,null,null,"If you need to add additional lines, copy an existing row to ensure all formulas remain."]
[]
["Risk #  \n (*  Internal Control Deficiency)","Country/ Bureau/IO","Subject","Objective","Objective \nType","Risk","Risk\nCategory","Current Risk",null,null,null,"Treatment","Target Risk",null,null,"Owner","Completion \nDate","Comments"]
[null,null,null,null,null,null,null,"Likelihood","Impact","Rating\n(Automatic)","Risk Response",null,"Likelihood","Impact","Rating\n(Automatic)"]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(H7,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(I7,'Reference Card'!$A$41:$C$46,3,FALSE)/2>2,\"H\",IF(VLOOKUP(H7,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(I7,'Reference Card'!$A$41:$C$46,3,FALSE)/2>1,\"M\",IF(VLOOKUP(H7,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(I7,'Reference Card'!$A$41:$C$46,3,FALSE)/2>0,\"L\",\"X\"))),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M7,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(N7,'Reference Card'!$A$41:$C$46,3,FALSE)/2>2,\"H\",IF(VLOOKUP(M7,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(N7,'Reference Card'!$A$41:$C$46,3,FALSE)/2>1,\"M\",IF(VLOOKUP(M7,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(N7,'Reference Card'!$A$41:$C$46,3,FALSE)/2>0,\"L\",\"X\"))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(H8,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(I8,'Reference Card'!$A$41:$C$46,3,FALSE)/2>2,\"H\",IF(VLOOKUP(H8,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(I8,'Reference Card'!$A$41:$C$46,3,FALSE)/2>1,\"M\",IF(VLOOKUP(H8,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(I8,'Reference Card'!$A$41:$C$46,3,FALSE)/2>0,\"L\",\"X\"))),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M8,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(N8,'Reference Card'!$A$41:$C$46,3,FALSE)/2>2,\"H\",IF(VLOOKUP(M8,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(N8,'Reference Card'!$A$41:$C$46,3,FALSE)/2>1,\"M\",IF(VLOOKUP(M8,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(N8,'Reference Card'!$A$41:$C$46,3,FALSE)/2>0,\"L\",\"X\"))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(H9,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(I9,'Reference Card'!$A$41:$C$46,3,FALSE)/2>2,\"H\",IF(VLOOKUP(H9,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(I9,'Reference Card'!$A$41:$C$46,3,FALSE)/2>1,\"M\",IF(VLOOKUP(H9,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(I9,'Reference Card'!$A$41:$C$46,3,FALSE)/2>0,\"L\",\"X\"))),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M9,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(N9,'Reference Card'!$A$41:$C$46,3,FALSE)/2>2,\"H\",IF(VLOOKUP(M9,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(N9,'Reference Card'!$A$41:$C$46,3,FALSE)/2>1,\"M\",IF(VLOOKUP(M9,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(N9,'Reference Card'!$A$41:$C$46,3,FALSE)/2>0,\"L\",\"X\"))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(H10,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(I10,'Reference Card'!$A$41:$C$46,3,FALSE)/2>2,\"H\",IF(VLOOKUP(H10,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(I10,'Reference Card'!$A$41:$C$46,3,FALSE)/2>1,\"M\",IF(VLOOKUP(H10,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(I10,'Reference Card'!$A$41:$C$46,3,FALSE)/2>0,\"L\",\"X\"))),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M10,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(N10,'Reference Card'!$A$41:$C$46,3,FALSE)/2>2,\"H\",IF(VLOOKUP(M10,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(N10,'Reference Card'!$A$41:$C$46,3,FALSE)/2>1,\"M\",IF(VLOOKUP(M10,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(N10,'Reference Card'!$A$41:$C$46,3,FALSE)/2>0,\"L\",\"X\"))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(H11,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(I11,'Reference Card'!$A$41:$C$46,3,FALSE)/2>2,\"H\",IF(VLOOKUP(H11,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(I11,'Reference Card'!$A$41:$C$46,3,FALSE)/2>1,\"M\",IF(VLOOKUP(H11,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(I11,'Reference Card'!$A$41:$C$46,3,FALSE)/2>0,\"L\",\"X\"))),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M11,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(N11,'Reference Card'!$A$41:$C$46,3,FALSE)/2>2,\"H\",IF(VLOOKUP(M11,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(N11,'Reference Card'!$A$41:$C$46,3,FALSE)/2>1,\"M\",IF(VLOOKUP(M11,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(N11,'Reference Card'!$A$41:$C$46,3,FALSE)/2>0,\"L\",\"X\"))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(H12,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(I12,'Reference Card'!$A$41:$C$46,3,FALSE)/2>2,\"H\",IF(VLOOKUP(H12,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(I12,'Reference Card'!$A$41:$C$46,3,FALSE)/2>1,\"M\",IF(VLOOKUP(H12,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(I12,'Reference Card'!$A$41:$C$46,3,FALSE)/2>0,\"L\",\"X\"))),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M12,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(N12,'Reference Card'!$A$41:$C$46,3,FALSE)/2>2,\"H\",IF(VLOOKUP(M12,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(N12,'Reference Card'!$A$41:$C$46,3,FALSE)/2>1,\"M\",IF(VLOOKUP(M12,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(N12,'Reference Card'!$A$41:$C$46,3,FALSE)/2>0,\"L\",\"X\"))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(H13,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(I13,'Reference Card'!$A$41:$C$46,3,FALSE)/2>2,\"H\",IF(VLOOKUP(H13,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(I13,'Reference Card'!$A$41:$C$46,3,FALSE)/2>1,\"M\",IF(VLOOKUP(H13,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(I13,'Reference Card'!$A$41:$C$46,3,FALSE)/2>0,\"L\",\"X\"))),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M13,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(N13,'Reference Card'!$A$41:$C$46,3,FALSE)/2>2,\"H\",IF(VLOOKUP(M13,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(N13,'Reference Card'!$A$41:$C$46,3,FALSE)/2>1,\"M\",IF(VLOOKUP(M13,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(N13,'Reference Card'!$A$41:$C$46,3,FALSE)/2>0,\"L\",\"X\"))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(H14,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(I14,'Reference Card'!$A$41:$C$46,3,FALSE)/2>2,\"H\",IF(VLOOKUP(H14,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(I14,'Reference Card'!$A$41:$C$46,3,FALSE)/2>1,\"M\",IF(VLOOKUP(H14,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(I14,'Reference Card'!$A$41:$C$46,3,FALSE)/2>0,\"L\",\"X\"))),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M14,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(N14,'Reference Card'!$A$41:$C$46,3,FALSE)/2>2,\"H\",IF(VLOOKUP(M14,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(N14,'Reference Card'!$A$41:$C$46,3,FALSE)/2>1,\"M\",IF(VLOOKUP(M14,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(N14,'Reference Card'!$A$41:$C$46,3,FALSE)/2>0,\"L\",\"X\"))),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(H15,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(I15,'Reference Card'!$A$41:$C$46,3,FALSE)/2>2,\"H\",IF(VLOOKUP(H15,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(I15,'Reference Card'!$A$41:$C$46,3,FALSE)/2>1,\"M\",IF(VLOOKUP(H15,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(I15,'Reference Card'!$A$41:$C$46,3,FALSE)/2>0,\"L\",\"X\"))),\"\")","v":""},null,null,null,null,{"$f":"IFERROR(IF(VLOOKUP(M15,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(N15,'Reference Card'!$A$41:$C$46,3,FALSE)/2>2,\"H\",IF(VLOOKUP(M15,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(N15,'Reference Card'!$A$41:$C$46,3,FALSE)/2>1,\"M\",IF(VLOOKUP(M15,'Reference Card'!$A$34:$C$39,3,FALSE)*VLOOKUP(N15,'Reference Card'!$A$41:$C$46,3,FALSE)/2>0,\"L\",\"X\"))),\"\")","v":""}]

{"sheet":"Reference Card","index":1,"n_rows":63,"n_cols":3,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
["NOTE:","To remove or edit any entries, please use \"Delete\" or \"Clear Contents\" in order to clear contents in the cell first and then re-enter the correct information; otherwise the existing entry and edit/change will continue to repeat themselves in the cell."]
[]
["Objective ","Risk must be analyzed in relationship to achievement of specific strategic or other appropriate operational objectives."]
[]
["Objective Types"]
["Strategic Objective","Relating to the strategic goals and objectives aligned with and supporting the organization's mission."]
["Operational Objective","Relating to the effective and efficient use of the organization's resources related to administrative and major program operations, including financial and fraud objectives."]
["Reporting Objective","Relating to the reliability of  the organization's reporting."]
["Compliance Objective","Relating to the organization's compliance with applicable laws and regulations."]
[]
["Risk ","The effect of uncertainty on objectives. Risk is both positive (opportunity) and negative (challenge). "]
[]
["Risk Category"]
["Programmatic Risk","Events or circumstances that could potentially improve or undermine the effectiveness of USAID development or humanitarian assistance.  "]
["Security Risk","Events or circumstances that potentially improve or compromise the security of USAID staff, partners, property, information, funding or facilities. "]
["Reputational Risk","Events or circumstances that could potentially improve or compromise USAID’s standing or credibility with Congress, the interagency, the American public, host country governments, multilateral institutions, implementing partners, beneficiaries, or other stakeholders."]
["Legal Risk","Events or circumstances that could potentially improve or compromise compliance with law, regulation, Executive Order, or other legal requirement."]
["Fiduciary risk ","Events or circumstances that could result in fraud, waste, loss, or unauthorized use of U.S. government funds, property, or other assets. It also refers to conflicts of interest that could adversely affect the accountability of U.S. taxpayer dollars or the realization of development or humanitarian outcomes."]
["Human Capital risk","Events or circumstances that could potentially improve or compromise the capacity, productivity, wellbeing, hiring, or retention of our employees. "]
["Information Technology Risks ","Events or circumstances that could potentially improve or compromise the processing, security, stability, capacity, performance, or resilience of information technology."]
[]
["Risk Identification Sources:"]
["MCRC","Organization's Management Control and Review Committee meeting results"]
["Portfolio Review","Organization's mid-course stock taking of programs"]
["OIG/GAO report","Audits conducted by OIG or GAO"]
["QFR","Organization's Quarterly Financial Reviews"]
["Other","Other sources."]
[]
["Risk Definition"]
["Current Risk","Is the exposure arising from a specific risk before any action has been taken to manage it beyond normal operations."]
["Target Risk","Is the exposure remaining from a current risk after action has been taken to manage the risk."]
["Treatment ","Is the action taken to respond to the risk. It could involve one or more of the following: Accept, Avoid, Reduce/Mitigate, Share/Transfer. "]
[]
["Likelihood Definition",null,"Value"]
["Rare","Less than 5% chance that event will occur",1]
["Unlikely","5%  to 20% chance that event will occur",1.5]
["Possible","20% to 40% chance that event will occur",2]
["Likely","40% to 80% chance that event will occur",2.5]
["Almost Certain","Greater than 80% chance that event will occur",3]
[]
["Impact Definition ",null,"Value"]
["Insignificant","An event that, if it occurred, would have no appreciable effect on achieving stated objective.",1]
["Minor","An event that, if it occurred, would cause only a small deviation from achieving stated objective's requirements or indicators.",1.5]
["Moderate","An event that, if it occurred, would cause moderate deviation from achieving stated objective's important requirements or indicators.",2]
["Significant","An event that, if it occurred, would cause failing in achieving stated objective's minimum requirements or indicators.",2.5]
["Major","An event that, if it occurred, would cause stated objective to be unachievable. ",3]
[]
["Ratings & Formula\n(Matrix found below)","Automatically calculated based on Likelihood and Impact assigned: \nRisk Score = (Likelihood Value x Impact Value) /2","Risk Score"]
["Low","Low uncertainty in achieving the stated objectives",">0"]
["Medium","Moderate uncertainty in achieving stated objectives",">1"]
["High","High uncertainty in achieving stated objectives",">2"]
[]
["Respond to Risks","A dropdown list of risk response options"]
["Accept","No action is taken to respond to the risk based on the insignificance of the risk; or the risk is knowingly assumed to seize an opportunity."]
["Avoid","Action is taken to stop the operational process, or the part of the operational process, causing the risk."]
["Mitigate","Action is taken to reduce the likelihood or impact of the risk."]
["Transfer","Action is taken to transfer or share risks across the entity or with external parties, such as insuring against losses."]
[]
["Owner","Enter the responsible person for putting the treatment in place or monitoring the risk. This could include the Mission Director, Office Director, or Bureau Assistant Administrator. Please include a person and a position."]
["Completion Date ","Treatments should have an end date for accountability. However, an AU can enter “N/A” if no end date is foreseeable, or “TBD” if the date isn’t known at the time of entry. If an AU enters N/A or TBD they must include an explanation in the Comments column."]
["Comments","Include any additional information people reviewing the risk profile might need, as deemed appropriate, or if directed in these instructions."]
[]
["Matrix"]

{"sheet":"Sheet1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}