{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Project Data","Risk Registry","Construction","Template","Sorted","Sort Calculations"],"not_rendered":{"charts":0,"images":5,"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":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[5,2,5,3],[8,0,9,0],[7,0,7,4],[8,5,9,7],[10,5,10,7],[8,3,9,3],[8,4,9,4],[8,1,9,1],[8,2,9,2],[11,0,21,15],[6,8,6,9],[6,4,6,5],[6,6,6,7],[6,10,6,12],[6,2,6,3],[6,0,6,1],[7,8,10,15],[5,11,5,12],[4,4,5,4],[0,0,0,15],[1,0,1,1],[2,0,3,1],[2,2,3,7],[2,8,3,9],[2,10,3,15],[4,10,4,12],[5,8,5,10],[4,8,4,9],[4,0,4,1],[4,2,4,3],[4,5,5,7],[4,13,5,15],[5,0,5,1]]}
["Risk Management Plan and Risk Register"]
["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 #:"]
["Milestone Dates"]
["PIH","PS&E","CAD","Beg. Const","Construction Complete","Schedule Input Comments"]
[]
[]
["Risk Management Plan (Who, When, and How)\nWho: <Enter name of specific leads or general statement about the project team, ex. The project team offering discipline-specific input for risk and opportunities.>\n\nWhen and How: \n1) Team to provide initial list of risks by adding draft items to the TDOT Risk Register template (see tab titled \"Risk Registry\"). Initial risk lists from the various team members are due by <Enter date> (<Enter when, ex. at the Risk and Schedule Workshop or first bi-weekly team meeting>) and then will be confirmed with the team and scored for probability.\n2) After the initial risk register is developed, the team to review the register every month during the team meetings (update, add, or retire risks) and formally update the risk register <Enter when, ex. during the design review for each design milestone>:\n- Risk Update #1 off of the Line and Grade Package: 1/12/2023 (tentative date)\n- Enter next update number and date\n- Enter next update number and date"]

{"sheet":"Risk Registry","index":1,"n_rows":35,"n_cols":20,"rows_kept":35,"cut":false,"hidden":false,"merged":[[3,18,10,18],[3,19,4,19],[3,20,4,20],[4,8,8,8],[6,19,7,19],[6,20,7,20],[10,10,10,14],[3,5,10,5],[3,6,10,6],[3,7,10,7],[3,8,3,14],[3,17,10,17],[3,0,10,0],[3,1,10,1],[3,2,10,2],[3,3,10,3],[3,4,10,4],[11,18,18,18],[11,19,12,19],[11,20,12,20],[12,8,16,8],[14,19,15,19],[14,20,15,20],[18,10,18,14],[11,5,18,5],[11,6,18,6],[11,7,18,7],[11,8,11,14],[11,17,18,17],[11,0,18,0],[11,1,18,1],[11,2,18,2],[11,3,18,3],[11,4,18,4],[19,18,26,18],[19,19,20,19],[19,20,20,20],[20,8,24,8],[22,19,23,19],[22,20,23,20],[26,10,26,14],[19,5,26,5],[19,6,26,6],[19,7,26,7],[19,8,19,14],[19,17,26,17],[19,0,26,0],[19,1,26,1],[19,2,26,2],[19,3,26,3],[19,4,26,4],[27,18,34,18],[27,19,28,19],[27,20,28,20],[28,8,32,8],[30,19,31,19],[30,20,31,20],[34,10,34,14],[27,5,34,5],[27,6,34,6],[27,7,34,7],[27,8,27,14],[27,17,34,17],[27,0,34,0],[27,1,34,1],[27,2,34,2],[27,3,34,3],[27,4,34,4],[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","Likelihood","Cost Impact","Schedule Impact","Risk Score","Pre-Mitigation",null,null,null,null,null,null,null,null,"Risk Owner","Response Strategy","Other"]
["Risk Number"]
[4,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"]
[3,null,null,null,null,null,null,{"$f":"IF($B12=\"Retired\",200,(MATCH(E12,P13:P17,0)*MATCH(F12,P13:P17,0))*MATCH(G12,P13:P17,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,"Likelihood","VH",{"$f":"IF(AND(IF($E12=\"VH\",1,0),IF($F12=\"VL\",1,0)),\"  C\",\"\") & IF(AND(IF($E12=\"VH\",1,0),IF($G12=\"VL\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E12=\"VH\",1,0),IF($F12=\"L\",1,0)),\"  C\",\"\") & IF(AND(IF($E12=\"VH\",1,0),IF($G12=\"L\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E12=\"VH\",1,0),IF($F12=\"M\",1,0)),\"  C\",\"\") & IF(AND(IF($E12=\"VH\",1,0),IF($G12=\"M\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E12=\"VH\",1,0),IF($F12=\"H\",1,0)),\"  C\",\"\") & IF(AND(IF($E12=\"VH\",1,0),IF($G12=\"H\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E12=\"VH\",1,0),IF($F12=\"VH\",1,0)),\"  C\",\"\") & IF(AND(IF($E12=\"VH\",1,0),IF($G12=\"VH\",1,0)),\"  S\",\"\")","v":""},"VH","Active"]
[null,null,null,null,null,null,null,null,null,"H",{"$f":"IF(AND(IF($E12=\"H\",1,0),IF($F12=\"VL\",1,0)),\"  C\",\"\") & IF(AND(IF($E12=\"H\",1,0),IF($G12=\"VL\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E12=\"H\",1,0),IF($F12=\"L\",1,0)),\"  C\",\"\") & IF(AND(IF($E12=\"H\",1,0),IF($G12=\"L\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E12=\"H\",1,0),IF($F12=\"M\",1,0)),\"  C\",\"\") & IF(AND(IF($E12=\"H\",1,0),IF($G12=\"M\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E12=\"H\",1,0),IF($F12=\"H\",1,0)),\"  C\",\"\") & IF(AND(IF($E12=\"H\",1,0),IF($G12=\"H\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E12=\"H\",1,0),IF($F12=\"VH\",1,0)),\"  C\",\"\") & IF(AND(IF($E12=\"H\",1,0),IF($G12=\"VH\",1,0)),\"  S\",\"\")","v":""},"H","Retired"]
[null,null,null,null,null,null,null,null,null,"M",{"$f":"IF(AND(IF($E12=\"M\",1,0),IF($F12=\"VL\",1,0)),\"  C\",\"\") & IF(AND(IF($E12=\"M\",1,0),IF($G12=\"VL\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E12=\"M\",1,0),IF($F12=\"L\",1,0)),\"  C\",\"\") & IF(AND(IF($E12=\"M\",1,0),IF($G12=\"L\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E12=\"M\",1,0),IF($F12=\"M\",1,0)),\"  C\",\"\") & IF(AND(IF($E12=\"M\",1,0),IF($G12=\"M\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E12=\"M\",1,0),IF($F12=\"H\",1,0)),\"  C\",\"\") & IF(AND(IF($E12=\"M\",1,0),IF($G12=\"H\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E12=\"M\",1,0),IF($F12=\"VH\",1,0)),\"  C\",\"\") & IF(AND(IF($E12=\"M\",1,0),IF($G12=\"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($E12=\"L\",1,0),IF($F12=\"VL\",1,0)),\"  C\",\"\") & IF(AND(IF($E12=\"L\",1,0),IF($G12=\"VL\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E12=\"L\",1,0),IF($F12=\"L\",1,0)),\"  C\",\"\") & IF(AND(IF($E12=\"L\",1,0),IF($G12=\"L\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E12=\"L\",1,0),IF($F12=\"M\",1,0)),\"  C\",\"\") & IF(AND(IF($E12=\"L\",1,0),IF($G12=\"M\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E12=\"L\",1,0),IF($F12=\"H\",1,0)),\"  C\",\"\") & IF(AND(IF($E12=\"L\",1,0),IF($G12=\"H\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E12=\"L\",1,0),IF($F12=\"VH\",1,0)),\"  C\",\"\") & IF(AND(IF($E12=\"L\",1,0),IF($G12=\"VH\",1,0)),\"  S\",\"\")","v":""},"L","No"]
[null,null,null,null,null,null,null,null,null,"VL",{"$f":"IF(AND(IF($E12=\"VL\",1,0),IF($F12=\"VL\",1,0)),\"  C\",\"\") & IF(AND(IF($E12=\"VL\",1,0),IF($G12=\"VL\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E12=\"VL\",1,0),IF($F12=\"L\",1,0)),\"  C\",\"\") & IF(AND(IF($E12=\"VL\",1,0),IF($G12=\"L\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E12=\"VL\",1,0),IF($F12=\"M\",1,0)),\"  C\",\"\") & IF(AND(IF($E12=\"VL\",1,0),IF($G12=\"M\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E12=\"VL\",1,0),IF($F12=\"H\",1,0)),\"  C\",\"\") & IF(AND(IF($E12=\"VL\",1,0),IF($G12=\"H\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E12=\"VL\",1,0),IF($F12=\"VH\",1,0)),\"  C\",\"\") & IF(AND(IF($E12=\"VL\",1,0),IF($G12=\"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"]
[2,"Active","Example title: I-40 future compatability","Example risk text: The risk that the interchange design (configuration and tie to I-40) is not forward compatible with future I-40 widening, leading to throwaway infrastructure at a later date. ","L","H","L",{"$f":"IF($B20=\"Retired\",200,(MATCH(E20,P21:P25,0)*MATCH(F20,P21:P25,0))*MATCH(G20,P21:P25,0))","v":32},"Heat Diagram",null,null,null,null,null,null,null,null,null,null,"Pass to Construction?"]
[null,null,null,null,null,null,null,null,"Likelihood","VH",{"$f":"IF(AND(IF($E20=\"VH\",1,0),IF($F20=\"VL\",1,0)),\"  C\",\"\") & IF(AND(IF($E20=\"VH\",1,0),IF($G20=\"VL\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E20=\"VH\",1,0),IF($F20=\"L\",1,0)),\"  C\",\"\") & IF(AND(IF($E20=\"VH\",1,0),IF($G20=\"L\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E20=\"VH\",1,0),IF($F20=\"M\",1,0)),\"  C\",\"\") & IF(AND(IF($E20=\"VH\",1,0),IF($G20=\"M\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E20=\"VH\",1,0),IF($F20=\"H\",1,0)),\"  C\",\"\") & IF(AND(IF($E20=\"VH\",1,0),IF($G20=\"H\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E20=\"VH\",1,0),IF($F20=\"VH\",1,0)),\"  C\",\"\") & IF(AND(IF($E20=\"VH\",1,0),IF($G20=\"VH\",1,0)),\"  S\",\"\")","v":""},"VH","Active"]
[null,null,null,null,null,null,null,null,null,"H",{"$f":"IF(AND(IF($E20=\"H\",1,0),IF($F20=\"VL\",1,0)),\"  C\",\"\") & IF(AND(IF($E20=\"H\",1,0),IF($G20=\"VL\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E20=\"H\",1,0),IF($F20=\"L\",1,0)),\"  C\",\"\") & IF(AND(IF($E20=\"H\",1,0),IF($G20=\"L\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E20=\"H\",1,0),IF($F20=\"M\",1,0)),\"  C\",\"\") & IF(AND(IF($E20=\"H\",1,0),IF($G20=\"M\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E20=\"H\",1,0),IF($F20=\"H\",1,0)),\"  C\",\"\") & IF(AND(IF($E20=\"H\",1,0),IF($G20=\"H\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E20=\"H\",1,0),IF($F20=\"VH\",1,0)),\"  C\",\"\") & IF(AND(IF($E20=\"H\",1,0),IF($G20=\"VH\",1,0)),\"  S\",\"\")","v":""},"H","Retired"]
[null,null,null,null,null,null,null,null,null,"M",{"$f":"IF(AND(IF($E20=\"M\",1,0),IF($F20=\"VL\",1,0)),\"  C\",\"\") & IF(AND(IF($E20=\"M\",1,0),IF($G20=\"VL\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E20=\"M\",1,0),IF($F20=\"L\",1,0)),\"  C\",\"\") & IF(AND(IF($E20=\"M\",1,0),IF($G20=\"L\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E20=\"M\",1,0),IF($F20=\"M\",1,0)),\"  C\",\"\") & IF(AND(IF($E20=\"M\",1,0),IF($G20=\"M\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E20=\"M\",1,0),IF($F20=\"H\",1,0)),\"  C\",\"\") & IF(AND(IF($E20=\"M\",1,0),IF($G20=\"H\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E20=\"M\",1,0),IF($F20=\"VH\",1,0)),\"  C\",\"\") & IF(AND(IF($E20=\"M\",1,0),IF($G20=\"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($E20=\"L\",1,0),IF($F20=\"VL\",1,0)),\"  C\",\"\") & IF(AND(IF($E20=\"L\",1,0),IF($G20=\"VL\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E20=\"L\",1,0),IF($F20=\"L\",1,0)),\"  C\",\"\") & IF(AND(IF($E20=\"L\",1,0),IF($G20=\"L\",1,0)),\"  S\",\"\")","v":"  S"},{"$f":"IF(AND(IF($E20=\"L\",1,0),IF($F20=\"M\",1,0)),\"  C\",\"\") & IF(AND(IF($E20=\"L\",1,0),IF($G20=\"M\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E20=\"L\",1,0),IF($F20=\"H\",1,0)),\"  C\",\"\") & IF(AND(IF($E20=\"L\",1,0),IF($G20=\"H\",1,0)),\"  S\",\"\")","v":"  C"},{"$f":"IF(AND(IF($E20=\"L\",1,0),IF($F20=\"VH\",1,0)),\"  C\",\"\") & IF(AND(IF($E20=\"L\",1,0),IF($G20=\"VH\",1,0)),\"  S\",\"\")","v":""},"L","No"]
[null,null,null,null,null,null,null,null,null,"VL",{"$f":"IF(AND(IF($E20=\"VL\",1,0),IF($F20=\"VL\",1,0)),\"  C\",\"\") & IF(AND(IF($E20=\"VL\",1,0),IF($G20=\"VL\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E20=\"VL\",1,0),IF($F20=\"L\",1,0)),\"  C\",\"\") & IF(AND(IF($E20=\"VL\",1,0),IF($G20=\"L\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E20=\"VL\",1,0),IF($F20=\"M\",1,0)),\"  C\",\"\") & IF(AND(IF($E20=\"VL\",1,0),IF($G20=\"M\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E20=\"VL\",1,0),IF($F20=\"H\",1,0)),\"  C\",\"\") & IF(AND(IF($E20=\"VL\",1,0),IF($G20=\"H\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E20=\"VL\",1,0),IF($F20=\"VH\",1,0)),\"  C\",\"\") & IF(AND(IF($E20=\"VL\",1,0),IF($G20=\"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"]
[1,"Active","Example title: UST (Haz Mat) disturbance","Example risk text: The risk that needed right-of-way strip takes impact existing underground storage tanks in each quadrant of the interchange, leading to hazardous material mitigation, more costly right-of-way impacts to the business, and construction delay.","M","H","L",{"$f":"IF($B28=\"Retired\",200,(MATCH(E28,P29:P33,0)*MATCH(F28,P29:P33,0))*MATCH(G28,P29:P33,0))","v":24},"Heat Diagram",null,null,null,null,null,null,null,null,null,null,"Pass to Construction?"]
[null,null,null,null,null,null,null,null,"Likelihood","VH",{"$f":"IF(AND(IF($E28=\"VH\",1,0),IF($F28=\"VL\",1,0)),\"  C\",\"\") & IF(AND(IF($E28=\"VH\",1,0),IF($G28=\"VL\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E28=\"VH\",1,0),IF($F28=\"L\",1,0)),\"  C\",\"\") & IF(AND(IF($E28=\"VH\",1,0),IF($G28=\"L\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E28=\"VH\",1,0),IF($F28=\"M\",1,0)),\"  C\",\"\") & IF(AND(IF($E28=\"VH\",1,0),IF($G28=\"M\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E28=\"VH\",1,0),IF($F28=\"H\",1,0)),\"  C\",\"\") & IF(AND(IF($E28=\"VH\",1,0),IF($G28=\"H\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E28=\"VH\",1,0),IF($F28=\"VH\",1,0)),\"  C\",\"\") & IF(AND(IF($E28=\"VH\",1,0),IF($G28=\"VH\",1,0)),\"  S\",\"\")","v":""},"VH","Active"]
[null,null,null,null,null,null,null,null,null,"H",{"$f":"IF(AND(IF($E28=\"H\",1,0),IF($F28=\"VL\",1,0)),\"  C\",\"\") & IF(AND(IF($E28=\"H\",1,0),IF($G28=\"VL\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E28=\"H\",1,0),IF($F28=\"L\",1,0)),\"  C\",\"\") & IF(AND(IF($E28=\"H\",1,0),IF($G28=\"L\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E28=\"H\",1,0),IF($F28=\"M\",1,0)),\"  C\",\"\") & IF(AND(IF($E28=\"H\",1,0),IF($G28=\"M\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E28=\"H\",1,0),IF($F28=\"H\",1,0)),\"  C\",\"\") & IF(AND(IF($E28=\"H\",1,0),IF($G28=\"H\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E28=\"H\",1,0),IF($F28=\"VH\",1,0)),\"  C\",\"\") & IF(AND(IF($E28=\"H\",1,0),IF($G28=\"VH\",1,0)),\"  S\",\"\")","v":""},"H","Retired"]
[null,null,null,null,null,null,null,null,null,"M",{"$f":"IF(AND(IF($E28=\"M\",1,0),IF($F28=\"VL\",1,0)),\"  C\",\"\") & IF(AND(IF($E28=\"M\",1,0),IF($G28=\"VL\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E28=\"M\",1,0),IF($F28=\"L\",1,0)),\"  C\",\"\") & IF(AND(IF($E28=\"M\",1,0),IF($G28=\"L\",1,0)),\"  S\",\"\")","v":"  S"},{"$f":"IF(AND(IF($E28=\"M\",1,0),IF($F28=\"M\",1,0)),\"  C\",\"\") & IF(AND(IF($E28=\"M\",1,0),IF($G28=\"M\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E28=\"M\",1,0),IF($F28=\"H\",1,0)),\"  C\",\"\") & IF(AND(IF($E28=\"M\",1,0),IF($G28=\"H\",1,0)),\"  S\",\"\")","v":"  C"},{"$f":"IF(AND(IF($E28=\"M\",1,0),IF($F28=\"VH\",1,0)),\"  C\",\"\") & IF(AND(IF($E28=\"M\",1,0),IF($G28=\"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($E28=\"L\",1,0),IF($F28=\"VL\",1,0)),\"  C\",\"\") & IF(AND(IF($E28=\"L\",1,0),IF($G28=\"VL\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E28=\"L\",1,0),IF($F28=\"L\",1,0)),\"  C\",\"\") & IF(AND(IF($E28=\"L\",1,0),IF($G28=\"L\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E28=\"L\",1,0),IF($F28=\"M\",1,0)),\"  C\",\"\") & IF(AND(IF($E28=\"L\",1,0),IF($G28=\"M\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E28=\"L\",1,0),IF($F28=\"H\",1,0)),\"  C\",\"\") & IF(AND(IF($E28=\"L\",1,0),IF($G28=\"H\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E28=\"L\",1,0),IF($F28=\"VH\",1,0)),\"  C\",\"\") & IF(AND(IF($E28=\"L\",1,0),IF($G28=\"VH\",1,0)),\"  S\",\"\")","v":""},"L","No"]
[null,null,null,null,null,null,null,null,null,"VL",{"$f":"IF(AND(IF($E28=\"VL\",1,0),IF($F28=\"VL\",1,0)),\"  C\",\"\") & IF(AND(IF($E28=\"VL\",1,0),IF($G28=\"VL\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E28=\"VL\",1,0),IF($F28=\"L\",1,0)),\"  C\",\"\") & IF(AND(IF($E28=\"VL\",1,0),IF($G28=\"L\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E28=\"VL\",1,0),IF($F28=\"M\",1,0)),\"  C\",\"\") & IF(AND(IF($E28=\"VL\",1,0),IF($G28=\"M\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E28=\"VL\",1,0),IF($F28=\"H\",1,0)),\"  C\",\"\") & IF(AND(IF($E28=\"VL\",1,0),IF($G28=\"H\",1,0)),\"  S\",\"\")","v":""},{"$f":"IF(AND(IF($E28=\"VL\",1,0),IF($F28=\"VH\",1,0)),\"  C\",\"\") & IF(AND(IF($E28=\"VL\",1,0),IF($G28=\"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":"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?"]