{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Risk Assessment","IMPACT_LIKELIHOOD_DROPDOWN","PURPOSE_DROPDOWN","ADMINISTRATIVE_DROPDOWN","Heat Map","Risk Register"],"not_rendered":{"charts":2,"images":3,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Heat Map","index":4,"reason":"not_a_worksheet"}],"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 Assessment","index":0,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[[2,0,2,12],[3,0,3,12],[11,6,11,8]]}
[]
[]
["Risk Assessment Tool"]
["Use to identify, assess and take action to reduce risk"]
["Purpose of Risk Assessment:","Over the Side Deployment "]
["Department/Unit Name:","CEOAS"]
["Administrative Structure:","College of Earth, Ocean and Atmospheric Sciences"]
["Completed By:","Principal Investigator"]
["Date Completed:","2019-02-08"]
["Date of Next Risk Assessment:","Next deployment"]
[]
[null,null,null,null,null,null,"Risk Calculation"]
["What is the risk?*","Describe the identified risk","How is risk currently managed?**","Comments/Concerns","Impact","Likelihood","Impact","Likelihood","Risk Score","Do you need to do anything else to reduce or control the risk?","Responsible Person/Job Title","Target Completion Date"]
["Safety of Personnel","Keeping all personnel safe. ","Safety training; \nStandard Operations Plan; \nExperienced crew; \nDivers are AAUS certified;\nClearly delineating duties & responsibilities;\nFollow the Guidelines outlined in UNOLS RVSS Appendix A & B","All personnel have been appropriately trained and certified.\nCruise plan completed and reviewed with team.\nPre-cruise meeting to discuss duties & responsibilities.","Significant","Medium",{"$f":"VLOOKUP(E14,IMPACT_LIKELIHOOD_DROPDOWN!$A$6:$B$10,2,FALSE)","v":4},{"$f":"VLOOKUP(F14,IMPACT_LIKELIHOOD_DROPDOWN!$A$14:$B$18,2,FALSE)","v":3},{"$f":"G14*H14","v":12},"Completed.\nWork in accordance with training, responsibilities, procedures, etc. ","Principal Investigator","2019-04-15"]
["Loss/Damage to Equipment","Keeping subsea/over the side equipment safe and free of damage. ","Follow the Winch and Wire Guidelines outlined in UNOLS RVSS Appendix A & B;\nDefined procedures for deployment and recovery of equipment;\nDaily inspection and recordkeeping activities;\nUse of GPS tracker and acoustic beacon;\nSufficient buoyancy to remain on surface for emergency recovery; \nEquipment will be tethered to the ship during deployment; \nShip will be anchored during operations to prevent dragging or bending;\nTopside equipment will be firmly tied to the benchtop in the cabin using eye hooks & appropriate line;\nWork will be conducted in the daylight hours; \nAUV or ROV can visually search the area if recovery is necessary; \nOver the side insurance.","Complete Over the side Registration Form.","Moderate","Medium",{"$f":"VLOOKUP(E15,IMPACT_LIKELIHOOD_DROPDOWN!$A$6:$B$10,2,FALSE)","v":3},{"$f":"VLOOKUP(F15,IMPACT_LIKELIHOOD_DROPDOWN!$A$14:$B$18,2,FALSE)","v":3},{"$f":"G15*H15","v":9},"Confirm that insurance is bound before deployment. Explain any deviations from the policy that may be needed.","Principal Investigator","2019-04-29"]
["Weather","Changes in weather could impact visibility, affect ocean conditions, etc.","Deployment will be dependent on particular weather conditions.\nNot operated in adverse weather conditions.","Weather conditions are forecast to be clear; will be monitoring the weather conditions daily.","Mild","Low-Medium",{"$f":"VLOOKUP(E16,IMPACT_LIKELIHOOD_DROPDOWN!$A$6:$B$10,2,FALSE)","v":2},{"$f":"VLOOKUP(F16,IMPACT_LIKELIHOOD_DROPDOWN!$A$14:$B$18,2,FALSE)","v":2},4,"Ongoing monitoring.","Principal Investigator","Ongoing"]
["Insurance Compliance","If the Insurance terms, conditions, and obligations are not complied with, there is a risk that a loss will not be covered.","Review the Marine & Offshore Equipment - Terms and Conditions.  Ensure that any deviation is submitted to Underwriter, and the Underwriter has agreed to such prior to deployment.","Over the side equipment will be transported via ground transportation and will be packed for travel by trained and qualified personnel.  There will be one day in storage, will be in a locked in an enclosed compound/locker under security supervision.  Exhibition - N/A.  No hazardous/dangerous goods will be transported with the equipment.","Moderate","Medium",{"$f":"VLOOKUP(E17,IMPACT_LIKELIHOOD_DROPDOWN!$A$6:$B$10,2,FALSE)","v":3},{"$f":"VLOOKUP(F17,IMPACT_LIKELIHOOD_DROPDOWN!$A$14:$B$18,2,FALSE)","v":3},9,"Confirm agreement with storage facility.\nFollow all the Marine & Offshore Equipment - Terms and Conditions during transit and deployment to ensure compliance.","Principal Investigator","2019-04-17"]
[null,null,null,null,null,null,{"$f":"VLOOKUP(E18,IMPACT_LIKELIHOOD_DROPDOWN!$A$6:$B$10,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F18,IMPACT_LIKELIHOOD_DROPDOWN!$A$14:$B$18,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$f":"VLOOKUP(E19,IMPACT_LIKELIHOOD_DROPDOWN!$A$6:$B$10,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F19,IMPACT_LIKELIHOOD_DROPDOWN!$A$14:$B$18,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$f":"VLOOKUP(E20,IMPACT_LIKELIHOOD_DROPDOWN!$A$6:$B$10,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F20,IMPACT_LIKELIHOOD_DROPDOWN!$A$14:$B$18,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$f":"VLOOKUP(E21,IMPACT_LIKELIHOOD_DROPDOWN!$A$6:$B$10,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F21,IMPACT_LIKELIHOOD_DROPDOWN!$A$14:$B$18,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,null,null,null,{"$f":"VLOOKUP(E22,IMPACT_LIKELIHOOD_DROPDOWN!$A$6:$B$10,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F22,IMPACT_LIKELIHOOD_DROPDOWN!$A$14:$B$18,2,FALSE)","v":{"$error":"#N/A"}},{"$error":"#N/A"}]

{"sheet":"IMPACT_LIKELIHOOD_DROPDOWN","index":1,"n_rows":18,"n_cols":2,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
["IMPACT","Value"]
["Insignificant",1]
["Mild",2]
["Moderate",3]
["Significant",4]
["Catastrophic",5]
[]
[]
["LIKELIHOOD","Value"]
["Low",1]
["Low-Medium",2]
["Medium",3]
["Medium-High",4]
["High",5]

{"sheet":"PURPOSE_DROPDOWN","index":2,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Contract"]
["Departmental"]
["Event"]
["Other (simply type in purpose of risk assessment in function bar)"]

{"sheet":"ADMINISTRATIVE_DROPDOWN","index":3,"n_rows":25,"n_cols":1,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
["Academic Affairs"]
["Athletics"]
["College of Agricultural Sciences"]
["College of Business"]
["College of Earth, Ocean and Atmospheric Sciences"]
["College of Education"]
["College of Engineering"]
["College of Forestry"]
["College of Liberal Arts"]
["College of Pharmacy"]
["College of Pulic Health and Human Sciences"]
["College of Science"]
["College of Veterinary Medicine"]
["Finance and Administration"]
["Graduate School"]
["Information Services"]
["OSU - Cascades"]
["OSU Alumni Association"]
["President's Office"]
["Provost's Office"]
["Research"]
["Student Affairs"]
["University Honors College"]
["University Outreach & Engagement"]
["University Relations and Marketing"]

{"sheet":"Risk Register","index":5,"n_rows":29,"n_cols":11,"rows_kept":29,"cut":false,"hidden":false,"merged":[[2,0,2,11],[11,9,11,10],[25,9,25,10]]}
[]
[]
["Risk Register"]
[]
["Purpose of Risk Assessment:",{"$f":"'Risk Assessment'!B5","v":"Over the Side Deployment "}]
["Department/Unit Name:",{"$f":"'Risk Assessment'!B6","v":"CEOAS"}]
["Administrative Structure:",{"$f":"'Risk Assessment'!B7","v":"College of Earth, Ocean and Atmospheric Sciences"}]
["Completed By:",{"$f":"'Risk Assessment'!B8","v":"Principal Investigator"}]
["Date:",{"$f":"'Risk Assessment'!B9","v":"2019-02-08"}]
["Date of Next Risk Assessment:",{"$f":"'Risk Assessment'!B10","v":"Next deployment"}]
[]
[null,null,null,null,null,null,null,null,null,"Risk Calculation Comparison"]
["Identified Risk","Actions to take to reduce risk","Responsible Person/Job Title","Updates/Status","Actual Completion Date","Impact","Likelihood","Impact","Likelihood","Risk Score (Original)","Risk Score (New)"]
[{"$f":"'Risk Assessment'!A14","v":"Safety of Personnel"},{"$f":"'Risk Assessment'!J14","v":"Completed.\nWork in accordance with training, responsibilities, procedures, etc. "},{"$f":"'Risk Assessment'!K14","v":"Principal Investigator"},null,null,null,null,{"$f":"VLOOKUP(F14,IMPACT_LIKELIHOOD_DROPDOWN!$A$6:$B$10,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(G14,IMPACT_LIKELIHOOD_DROPDOWN!$A$14:$B$18,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'Risk Assessment'!I14","v":12},{"$f":"H14*I14","v":{"$error":"#N/A"}}]
[{"$f":"'Risk Assessment'!A15","v":"Loss/Damage to Equipment"},{"$f":"'Risk Assessment'!J15","v":"Confirm that insurance is bound before deployment. Explain any deviations from the policy that may be needed."},{"$f":"'Risk Assessment'!K15","v":"Principal Investigator"},null,null,null,null,{"$f":"VLOOKUP(F15,IMPACT_LIKELIHOOD_DROPDOWN!$A$6:$B$10,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(G15,IMPACT_LIKELIHOOD_DROPDOWN!$A$14:$B$18,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'Risk Assessment'!I15","v":9},{"$error":"#N/A"}]
[{"$f":"'Risk Assessment'!A16","v":"Weather"},{"$f":"'Risk Assessment'!J16","v":"Ongoing monitoring."},{"$f":"'Risk Assessment'!K16","v":"Principal Investigator"},null,null,null,null,{"$f":"VLOOKUP(F16,IMPACT_LIKELIHOOD_DROPDOWN!$A$6:$B$10,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(G16,IMPACT_LIKELIHOOD_DROPDOWN!$A$14:$B$18,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'Risk Assessment'!I16","v":4},{"$error":"#N/A"}]
[{"$f":"'Risk Assessment'!A17","v":"Insurance Compliance"},{"$f":"'Risk Assessment'!J17","v":"Confirm agreement with storage facility.\nFollow all the Marine & Offshore Equipment - Terms and Conditions during transit and deployment to ensure compliance."},{"$f":"'Risk Assessment'!K17","v":"Principal Investigator"},null,null,null,null,{"$f":"VLOOKUP(F17,IMPACT_LIKELIHOOD_DROPDOWN!$A$6:$B$10,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(G17,IMPACT_LIKELIHOOD_DROPDOWN!$A$14:$B$18,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'Risk Assessment'!I17","v":9},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(F18,IMPACT_LIKELIHOOD_DROPDOWN!$A$6:$B$10,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(G18,IMPACT_LIKELIHOOD_DROPDOWN!$A$14:$B$18,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'Risk Assessment'!I18","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(F19,IMPACT_LIKELIHOOD_DROPDOWN!$A$6:$B$10,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(G19,IMPACT_LIKELIHOOD_DROPDOWN!$A$14:$B$18,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'Risk Assessment'!I19","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(F20,IMPACT_LIKELIHOOD_DROPDOWN!$A$6:$B$10,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(G20,IMPACT_LIKELIHOOD_DROPDOWN!$A$14:$B$18,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'Risk Assessment'!I20","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(F21,IMPACT_LIKELIHOOD_DROPDOWN!$A$6:$B$10,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(G21,IMPACT_LIKELIHOOD_DROPDOWN!$A$14:$B$18,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'Risk Assessment'!I21","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[null,null,null,null,null,null,null,{"$f":"VLOOKUP(F22,IMPACT_LIKELIHOOD_DROPDOWN!$A$6:$B$10,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(G22,IMPACT_LIKELIHOOD_DROPDOWN!$A$14:$B$18,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'Risk Assessment'!I22","v":{"$error":"#N/A"}},{"$error":"#N/A"}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Risk Score Key"]
[null,null,null,null,null,null,null,null,null,null,"Low Risk"]
[null,null,null,null,null,null,null,null,null,null,"Moderate Risk"]
[null,null,null,null,null,null,null,null,null,null,"High Risk"]