{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["How To","Risk Assesment"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"comments":0,"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":"How To","index":0,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[null,null,"!","If you are new to Enterprise Risk Management (ERM) please read the \"Basics of ERM\" power point presentation, available on the Risk Management website"]
[null,1,"Office, Name, Date","Start with selecting your office and entering your name and the date",null,null,null,"Please return the completed form to erm@reed.edu"]
[null,2,"Risk name","Begin with a short name that will be used to file the risk and track it in the future"]
[null,3,"Risk description","Enter a detailed description of the risk",null,7,"Response type","Please select the drop down options that you feel best fits the response (if there is no response then please use \"Acceptance\")"]
[null,4,"Risk Type","Please select the drop down options that you feel best fits the risk",null,8,"Response description","Enter a detailed description of the response (if there is no response please leave blank)"]
[null,null,"!","Remember this process is to capture the risk AND what we do to reduce it. The first \"Risk Assessment\" should reflect the risk if we did NOT do any thing to reduce it. We will then capture the risk after mitigation later",null,null,"!","This is the second half of the ranking process. This time we are capturing how we feel about the risk AFTER we have taken steps to reduce or mitigate it"]
[null,5,"Likelihood","How likely is this to happen (if nothing was done to prevent/reduce it) where:",null,9,"Likelihood","How likely is this to happen (after things are done to prevent it) where:"]
[null,null,null,"1 = Rare - not a consideration so not expected and very surprised",null,null,null,"1 = Rare - not a consideration so not expected and very surprised"]
[null,null,null,"2 = Unlikely - considered it but not expected and very surprised",null,null,null,"2 = Unlikely - considered it but not expected and very surprised"]
[null,null,null,"3 = Possible -considered it but not expected and surprised by it",null,null,null,"3 = Possible -considered it but not expected and surprised by it"]
[null,null,null,"4 = Likely - considered it but not expected but not surprised either",null,null,null,"4 = Likely - considered it but not expected but not surprised either"]
[null,null,null,"5 = Almost certain - considered it and expected so not surprised",null,null,null,"5 = Almost certain - considered it and expected so not surprised"]
[null,6,"Impact","What impact would it have (if nothing was done to prevent/reduce it)",null,10,"Impact","What impact would it have (after things are done to prevent it)"]
[null,null,null,"1 = Insignificant - short term effects over a very small scale",null,null,null,"1 = Insignificant - short term effects over a very small scale"]
[null,null,null,"2 = Minor - short term effects over a small scale",null,null,null,"2 = Minor - short term effects over a small scale"]
[null,null,null,"3 = Moderate - short to medium term effect over a medium scale",null,null,null,"3 = Moderate - short to medium term effect over a medium scale"]
[null,null,null,"4 = Major - medium to long-term and/or over a large scale",null,null,null,"4 = Major - medium to long-term and/or over a large scale"]
[null,null,null,"5 = Catastrophic - long-term to permanent over a very large scale",null,null,null,"5 = Catastrophic - long-term to permanent over a very large scale"]

{"sheet":"Risk Assesment","index":1,"n_rows":81,"n_cols":16,"rows_kept":81,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"Reed Risk Assessment form - \"&G55","v":"Reed Risk Assessment form - (Please select)"}]
[null,"# List",null,null,"Type List","Response","Risk Objective","Office","Division"]
[null,1,null,null,"Strategic","Avoidance","Admission & financial aid","Academic support","VP/Dean of Student Services"]
[null,2,null,null,"Operational","Reduction","Disasters & accidents","Admission","VP/Dean of Admission & Financial Aid"]
[null,3,null,null,"Reporting","Sharing","Endowment & gifts","Alumni relations","VP for College Relations"]
[null,4,null,null,"Compliance","Acceptance","Financial management","Audio visual services"]
[null,5,null,null,"Reputational","Innovate","Governance","Bookstore","VP & Treasurer"]
[null,"(Please select)",null,null,"(Please select)",null,"Pedagogical","Business office","VP & Treasurer"]
[null,null,null,null,null,null,"Personnel management","Center for life beyond Reed","VP/Dean of Student Services"]
[null,null,null,null,null,null,"Physical environment","College relations","VP for College Relations"]
[null,null,null,null,null,null,"Reputational risk","Community safety","VP/Dean of Student Services"]
[null,null,null,null,null,null,"Student experience","Community wellness","VP/Dean of Student Services"]
[null,null,null,null,null,null,"Technology","Computing & telecommunications","Dean of the Faculty"]
[null,null,null,null,null,null,"Records","Conference & events planning","VP for College Relations"]
[null,null,null,null,null,null,"Processes","Cooley Gallery","Dean of the Faculty"]
[null,null,null,null,null,null,"(Please select)","Dean of the faculty","Dean of the Faculty"]
[null,null,null,null,null,null,null,"Dean for institutional diversity","Dean for institutional diversity"]
[null,null,null,null,null,null,null,"Development office","VP for College Relations"]
[null,null,null,null,null,null,null,"Disability support services","VP/Dean of Student Services"]
[null,null,null,null,null,null,null,"Environmental health & safety","VP & Treasurer"]
[null,null,null,null,null,null,null,"Facilities services","VP & Treasurer"]
[null,null,null,null,null,null,null,"Financial aid","VP/Dean of Admission & Financial Aid"]
[null,null,null,null,null,null,null,"Food services","VP/Dean of Student Services"]
[null,null,null,null,null,null,null,"Graduate programs","Dean of the Faculty"]
[null,null,null,null,null,null,null,"Health & counseling","VP/Dean of Student Services"]
[null,null,null,null,null,null,null,"Human resources","VP & Treasurer"]
[null,null,null,null,null,null,null,"Inclusive community office","VP/Dean of Student Services"]
[null,null,null,null,null,null,null,"Institutional diversity","Dean for institutional diversity"]
[null,null,null,null,null,null,null,"Institutional research","VP & Treasurer"]
[null,null,null,null,null,null,null,"International programs","Dean of the Faculty"]
[null,null,null,null,null,null,null,"International student services","VP/Dean of Student Services"]
[null,null,null,null,null,null,null,"Library","Dean of the Faculty"]
[null,null,null,null,null,null,null,"Mail services"]
[null,null,null,null,null,null,null,"Physical education","VP/Dean of Student Services"]
[null,null,null,null,null,null,null,"President's office","President of Reed"]
[null,null,null,null,null,null,null,"Printing services"]
[null,null,null,null,null,null,null,"Public affairs","VP for College Relations"]
[null,null,null,null,null,null,null,"Reactor facility","Dean of the Faculty"]
[null,null,null,null,null,null,null,"Registrar's office","Dean of the Faculty"]
[null,null,null,null,null,null,null,"Residence life","VP/Dean of Student Services"]
[null,null,null,null,null,null,null,"S.E.E.D.S. (Students for Education, Empowerment, & Direct Service)"]
[null,null,null,null,null,null,null,"Special programs","Dean of the Faculty"]
[null,null,null,null,null,null,null,"Student activities","VP/Dean of Student Services"]
[null,null,null,null,null,null,null,"Student services","VP/Dean of Student Services"]
[null,null,null,null,null,null,null,"Title IX coordinator","VP/Dean of Student Services"]
[null,null,null,null,null,null,null,"Treasurers office","VP & Treasurer"]
[null,null,null,null,null,null,null,"(Please select)"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Office:","(Please select)"]
[null,null,null,null,null,"Your Name:","(Type here)"]
[null,null,null,null,null,"Date:","(mm/dd/yyyy)"]
[]
[]
[null,"Event Identification",null,null,null,null,null,"Risk","Risk Assessment",null,null,"Risk Response","Control Activity","Residual Risk"]
[null,"#","Division","Office","Risk Objectives","Risk name","Risk Description","Type","Likelihood","Impact","Risk","Response Type","Response Description","Likelihood","Impact","Risk"]
[null,1,{"$f":"IFERROR(IF(VLOOKUP(D62,$H$3:$I$48,2,FALSE)=0,\" \",VLOOKUP(D62,$H$3:$I$48,2,FALSE)),\" \")","v":" "},{"$f":"IF($G$55=\"(Please select)\",\" \",$G$55)","v":" "},"(Please select)","(Please enter a short name: e.g. \"ERM Failure\")","(Please enter a longer description of the risk: e.g. \"Failure of ERM process to capture significant risks\")","(Please select)","(Please select)","(Please select)",{"$f":"IFERROR(I62*J62,\" \")","v":" "},"(Please select)","(Please enter a longer description: e.g. \"Engagement is broad and deep, working with all levels to help capture significant risks and raise awareness of risk in every day activities\")","(Please select)","(Please select)",{"$f":"IFERROR(N62*O62,\" \")","v":" "}]
[null,{"$f":"B62+1","v":2},{"$f":"IFERROR(IF(VLOOKUP(D63,$H$3:$I$48,2,FALSE)=0,\" \",VLOOKUP(D63,$H$3:$I$48,2,FALSE)),\" \")","v":" "}," ","(Please select)","(Type here)","(Type here)","(Please select)","(Please select)","(Please select)",{"$f":"IFERROR(I63*J63,\" \")","v":" "},"(Please select)","(Type here)","(Please select)","(Please select)",{"$f":"IFERROR(N63*O63,\" \")","v":" "}]
[null,{"$f":"B63+1","v":3}," "," ","(Please select)","(Type here)","(Type here)","(Please select)","(Please select)","(Please select)"," ","(Please select)","(Type here)","(Please select)","(Please select)"," "]
[null,4," "," ","(Please select)","(Type here)","(Type here)","(Please select)","(Please select)","(Please select)"," ","(Please select)","(Type here)","(Please select)","(Please select)"," "]
[null,5," "," ","(Please select)","(Type here)","(Type here)","(Please select)","(Please select)","(Please select)"," ","(Please select)","(Type here)","(Please select)","(Please select)"," "]
[null,{"$f":"B66+1","v":6}," "," ","(Please select)","(Type here)","(Type here)","(Please select)","(Please select)","(Please select)",{"$f":"IFERROR(I67*J67,\" \")","v":" "},"(Please select)","(Type here)","(Please select)","(Please select)",{"$f":"IFERROR(N67*O67,\" \")","v":" "}]
[null,7," "," ","(Please select)","(Type here)","(Type here)","(Please select)","(Please select)","(Please select)"," ","(Please select)","(Type here)","(Please select)","(Please select)"," "]
[null,8," "," ","(Please select)","(Type here)","(Type here)","(Please select)","(Please select)","(Please select)"," ","(Please select)","(Type here)","(Please select)","(Please select)"," "]
[null,9," "," ","(Please select)","(Type here)","(Type here)","(Please select)","(Please select)","(Please select)"," ","(Please select)","(Type here)","(Please select)","(Please select)"," "]
[null,{"$f":"B70+1","v":10}," "," ","(Please select)","(Type here)","(Type here)","(Please select)","(Please select)","(Please select)"," ","(Please select)","(Type here)","(Please select)","(Please select)"," "]
[null,11," "," ","(Please select)","(Type here)","(Type here)","(Please select)","(Please select)","(Please select)"," ","(Please select)","(Type here)","(Please select)","(Please select)"," "]
[null,12," "," ","(Please select)","(Type here)","(Type here)","(Please select)","(Please select)","(Please select)"," ","(Please select)","(Type here)","(Please select)","(Please select)"," "]
[null,13," "," ","(Please select)","(Type here)","(Type here)","(Please select)","(Please select)","(Please select)"," ","(Please select)","(Type here)","(Please select)","(Please select)"," "]
[null,{"$f":"B74+1","v":14}," "," ","(Please select)","(Type here)","(Type here)","(Please select)","(Please select)","(Please select)"," ","(Please select)","(Type here)","(Please select)","(Please select)"," "]
[null,15," "," ","(Please select)","(Type here)","(Type here)","(Please select)","(Please select)","(Please select)"," ","(Please select)","(Type here)","(Please select)","(Please select)"," "]
[null,16," "," ","(Please select)","(Type here)","(Type here)","(Please select)","(Please select)","(Please select)"," ","(Please select)","(Type here)","(Please select)","(Please select)"," "]
[null,17," "," ","(Please select)","(Type here)","(Type here)","(Please select)","(Please select)","(Please select)"," ","(Please select)","(Type here)","(Please select)","(Please select)"," "]
[null,18," "," ","(Please select)","(Type here)","(Type here)","(Please select)","(Please select)","(Please select)",{"$f":"IFERROR(I79*J79,\" \")","v":" "},"(Please select)","(Type here)","(Please select)","(Please select)",{"$f":"IFERROR(N79*O79,\" \")","v":" "}]
[null,19," "," ","(Please select)","(Type here)","(Type here)","(Please select)","(Please select)","(Please select)"," ","(Please select)","(Type here)","(Please select)","(Please select)"," "]
[null,20," "," ","(Please select)","(Type here)","(Type here)","(Please select)","(Please select)","(Please select)",{"$f":"IFERROR(I81*J81,\" \")","v":" "},"(Please select)","(Type here)","(Please select)","(Please select)",{"$f":"IFERROR(N81*O81,\" \")","v":" "}]