{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Project Data","Risk Registry","Construction","Template","Sorted","Sort Calculations"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":1,"defined_names":8,"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":"Project Data","index":0,"n_rows":29,"n_cols":14,"rows_kept":29,"cut":false,"hidden":false,"merged":[[23,0,23,15],[24,0,24,15],[25,0,25,15],[6,10,6,12],[8,13,9,15],[10,13,10,15],[11,0,21,15],[22,0,22,15],[6,8,6,9],[6,4,6,5],[6,6,6,7],[8,10,9,10],[8,11,9,11],[8,12,9,12],[26,1,26,15],[28,4,28,14],[28,0,28,3],[6,2,6,3],[6,0,6,1],[7,0,7,3],[8,0,9,0],[8,5,9,6],[10,5,10,6],[8,1,9,1],[8,2,9,2],[8,3,9,3],[8,4,9,4],[7,8,7,12],[8,8,9,8],[8,9,9,9],[4,0,4,1],[4,2,4,3],[4,5,5,7],[4,13,5,15],[5,0,5,1],[5,2,5,3],[5,11,5,12],[4,4,5,4],[4,10,4,12],[5,8,5,10],[4,8,4,9],[0,0,0,15],[1,0,1,1],[2,0,3,1],[2,2,3,7],[2,8,3,9],[2,10,3,15]]}
["Qualitative Risk Input Data"]
["Today's Date :"]
["Project Name:",null,null,null,null,null,null,null,"PIN"]
[]
["Estimate Date :",null,null,null,null,null,null,null,"Submit for Ad Date:"]
["Last Review Date:"]
["Project Manager:",null,null,null,"E-mail:",null,null,null,"Phone #:"]
["Current Cost Est. ($)",null,null,null,null,null,null,null,"Milestone Dates"]
["Programed Amount","Design","RW","Const","Total Cost","Contingency",null,null,"PIH","PS&E","CAD","Beg. Const","Construction Complete","Schedule Input Comments"]
[]
[null,null,null,null,{"$f":"(B11+C11+D11)","v":0},{"$f":"A11-E11","v":0}]
["Notes:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Documentation instructions so this valuable information will be easily accessible to all team members at every stage of the project:"]
["1. Name this file PIN_Risk_Worksheet v2.xlsm"]
["2. File in ProjectWise in the project’s Project Management folder."]
["3. Assign the following ProjectWise attributes to the file:"]
[null,"a. PreConstruction (document type filter)     b. Reviews+ (document type)     c. Risk (document subtype)"]
["Please contact the Deputy Preconstruction Engineer (801-633-6215) if you have questions or suggestions regarding this form.  More information and instructions are available at:"]
["http://www.udot.utah.gov/main/f?p=100:pg:0:::1:T,V:3164,",null,null,null,"(or search the internet for \"UDOT Risk Management Tools\")"]

{"sheet":"Risk Registry","index":1,"n_rows":3,"n_cols":20,"rows_kept":3,"cut":false,"hidden":false,"merged":[[1,0,2,0],[1,7,2,7],[1,17,2,17],[1,18,2,18],[1,19,2,19],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5],[1,6,2,6],[1,8,2,14]]}
[]
["Risk Number","Status","Risk Name","Risk Description","Likelyhood","Cost Impact","Schedule Impact","Risk Score","Pre-Mitigation",null,null,null,null,null,null,null,null,"Risk Owner","Response Strategy","Other"]
["Risk Number"]

{"sheet":"Construction","index":2,"n_rows":3,"n_cols":20,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,5,0,11],[1,6,2,6],[1,8,2,14],[1,0,2,0],[1,7,2,7],[1,17,2,17],[1,18,2,18],[1,19,2,19],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[1,5,2,5]]}
[null,null,null,null,null,"Risks sorted for Construction"]
["Risk Number","Status","Risk Name","Risk Description","Likelyhood","Cost Impact","Schedule Impact","Risk Score","Pre-Mitigation",null,null,null,null,null,null,null,null,"Risk Owner","Response Strategy","Other"]
["Risk Number"]

{"sheet":"Template","index":3,"n_rows":11,"n_cols":20,"rows_kept":11,"cut":false,"hidden":false,"merged":[[3,5,10,5],[3,6,10,6],[3,7,10,7],[1,8,2,14],[1,19,2,20],[3,20,4,20],[6,19,7,19],[6,20,7,20],[4,8,8,8],[3,19,4,19],[1,18,2,18],[3,18,10,18],[3,0,10,0],[1,5,2,5],[1,6,2,6],[1,7,2,7],[1,17,2,17],[3,17,10,17],[3,1,10,1],[3,2,10,2],[1,1,2,1],[1,2,2,2],[1,3,2,3],[1,4,2,4],[10,10,10,14],[3,8,3,14],[3,3,10,3],[3,4,10,4]]}
[]
[null,"Status","Risk Name","Risk Description","Likelyhood","Cost Impact","Schedule Impact","Risk Score","Pre-Mitigation",null,null,null,null,null,null,null,null,"Risk Owner","Response Strategy","Other"]
["Risk Number"]
[null,null,null,null,null,null,null,{"$f":"IF($B4=\"Retired\",200,(MATCH(E4,P5:P9,0)*MATCH(F4,P5:P9,0))*MATCH(G4,P5:P9,0))","v":{"$error":"#N/A"}},"Heat Diagram",null,null,null,null,null,null,null,null,null,null,"Pass to Construction?"]
[null,null,null,null,null,null,null,null,"Likelyhood","VH",{"$f":"IF(AND(IF($E4=\"VH\",1,0),IF($F4=\"VL\",1,0)),\"  C\",\"\") & IF(AND(IF($E4=\"VH\",1,0),IF($G4=\"VL\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E4=\"VH\",1,0),IF($F4=\"L\",1,0)),\"  C\",\"\") & IF(AND(IF($E4=\"VH\",1,0),IF($G4=\"L\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E4=\"VH\",1,0),IF($F4=\"M\",1,0)),\"  C\",\"\") & IF(AND(IF($E4=\"VH\",1,0),IF($G4=\"M\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E4=\"VH\",1,0),IF($F4=\"H\",1,0)),\"  C\",\"\") & IF(AND(IF($E4=\"VH\",1,0),IF($G4=\"H\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E4=\"VH\",1,0),IF($F4=\"VH\",1,0)),\"  C\",\"\") & IF(AND(IF($E4=\"VH\",1,0),IF($G4=\"VH\",1,0)),\"  S\",\"\")","v":""},"VH","Active"]
[null,null,null,null,null,null,null,null,null,"H",{"$f":"IF(AND(IF($E4=\"H\",1,0),IF($F4=\"VL\",1,0)),\"  C\",\"\") & IF(AND(IF($E4=\"H\",1,0),IF($G4=\"VL\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E4=\"H\",1,0),IF($F4=\"L\",1,0)),\"  C\",\"\") & IF(AND(IF($E4=\"H\",1,0),IF($G4=\"L\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E4=\"H\",1,0),IF($F4=\"M\",1,0)),\"  C\",\"\") & IF(AND(IF($E4=\"H\",1,0),IF($G4=\"M\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E4=\"H\",1,0),IF($F4=\"H\",1,0)),\"  C\",\"\") & IF(AND(IF($E4=\"H\",1,0),IF($G4=\"H\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E4=\"H\",1,0),IF($F4=\"VH\",1,0)),\"  C\",\"\") & IF(AND(IF($E4=\"H\",1,0),IF($G4=\"VH\",1,0)),\"  S\",\"\")","v":""},"H","Retired"]
[null,null,null,null,null,null,null,null,null,"M",{"$f":"IF(AND(IF($E4=\"M\",1,0),IF($F4=\"VL\",1,0)),\"  C\",\"\") & IF(AND(IF($E4=\"M\",1,0),IF($G4=\"VL\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E4=\"M\",1,0),IF($F4=\"L\",1,0)),\"  C\",\"\") & IF(AND(IF($E4=\"M\",1,0),IF($G4=\"L\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E4=\"M\",1,0),IF($F4=\"M\",1,0)),\"  C\",\"\") & IF(AND(IF($E4=\"M\",1,0),IF($G4=\"M\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E4=\"M\",1,0),IF($F4=\"H\",1,0)),\"  C\",\"\") & IF(AND(IF($E4=\"M\",1,0),IF($G4=\"H\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E4=\"M\",1,0),IF($F4=\"VH\",1,0)),\"  C\",\"\") & IF(AND(IF($E4=\"M\",1,0),IF($G4=\"VH\",1,0)),\"  S\",\"\")","v":""},"M","Yes",null,null,"Due Date"]
[null,null,null,null,null,null,null,null,null,"L",{"$f":"IF(AND(IF($E4=\"L\",1,0),IF($F4=\"VL\",1,0)),\"  C\",\"\") & IF(AND(IF($E4=\"L\",1,0),IF($G4=\"VL\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E4=\"L\",1,0),IF($F4=\"L\",1,0)),\"  C\",\"\") & IF(AND(IF($E4=\"L\",1,0),IF($G4=\"L\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E4=\"L\",1,0),IF($F4=\"M\",1,0)),\"  C\",\"\") & IF(AND(IF($E4=\"L\",1,0),IF($G4=\"M\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E4=\"L\",1,0),IF($F4=\"H\",1,0)),\"  C\",\"\") & IF(AND(IF($E4=\"L\",1,0),IF($G4=\"H\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E4=\"L\",1,0),IF($F4=\"VH\",1,0)),\"  C\",\"\") & IF(AND(IF($E4=\"L\",1,0),IF($G4=\"VH\",1,0)),\"  S\",\"\")","v":""},"L","No"]
[null,null,null,null,null,null,null,null,null,"VL",{"$f":"IF(AND(IF($E4=\"VL\",1,0),IF($F4=\"VL\",1,0)),\"  C\",\"\") & IF(AND(IF($E4=\"VL\",1,0),IF($G4=\"VL\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E4=\"VL\",1,0),IF($F4=\"L\",1,0)),\"  C\",\"\") & IF(AND(IF($E4=\"VL\",1,0),IF($G4=\"L\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E4=\"VL\",1,0),IF($F4=\"M\",1,0)),\"  C\",\"\") & IF(AND(IF($E4=\"VL\",1,0),IF($G4=\"M\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E4=\"VL\",1,0),IF($F4=\"H\",1,0)),\"  C\",\"\") & IF(AND(IF($E4=\"VL\",1,0),IF($G4=\"H\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E4=\"VL\",1,0),IF($F4=\"VH\",1,0)),\"  C\",\"\") & IF(AND(IF($E4=\"VL\",1,0),IF($G4=\"VH\",1,0)),\"  S\",\"\")","v":""},"VL"]
[null,null,null,null,null,null,null,null,null,null,"VL","L","M","H","VH"]
[null,null,null,null,null,null,null,null,"_____",null,"Impact"]

{"sheet":"Sorted","index":4,"n_rows":1,"n_cols":20,"rows_kept":1,"cut":false,"hidden":false,"merged":[[0,0,1,0],[0,6,1,6],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,1,4],[0,5,1,5],[0,8,1,14],[0,7,1,7],[0,17,1,17],[0,18,1,18],[0,19,1,19]]}
["Risk Number","Status","Risk Name","Risk Description","Likelyhood","Cost Impact","Schedule Impact","Risk Score","Pre-Mitigation",null,null,null,null,null,null,null,null,"Risk Owner","Response Strategy","Other"]

{"sheet":"Sort Calculations","index":5,"n_rows":1,"n_cols":5,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Risk #","risk value",null,"Risk #","Const?"]