{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Utility Conflcit Matrix","Cost Estimate Analysis","User Guide","Field and Column Descriptions","Drop-Down Lists"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":12,"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":"Utility Conflcit Matrix","index":0,"n_rows":34,"n_cols":18,"rows_kept":34,"cut":false,"hidden":false,"merged":[[6,0,6,1],[0,0,0,17],[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,1]]}
["DelDOT Utility Conflict Matrix"]
[]
["Contract Number: ",null,null,null,null,null,"Section: ",null,null,null,null,null,null,null,"Preliminary UCM Developed By - Date:  ",null,"Date"]
["Project Title: ",null,null,null,null,null,"Project Manager: ",null,null,null,null,null,null,null,"Reviewed By - Date: ",null,"Date"]
["County - MR # : ",null,null,"MR #",null,null,"Project Designer: ",null,null,null,null,null,null,null,"Semi-Final UCM Updated By - Date: ",null,"Date"]
["Road Name : ",null,null,null,null,null,"Project Consultant: ",null,null,null,null,null,null,null,"Reviewed By - Date: ",null,"Date"]
["Project Development Stage: ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Final UCM Updated By - Date: ",null,"Date"]
[null,null,null,null,null,null,"   Note: refer to subsheet for utility conflict cost analysis.",null,null,null,null,null,null,null,"Reviewed By - Date: ",null,"Date"]
[]
["Conflict ID","Drawing or Sheet No. ","Conflict Status","Utility Owner","Utility Type","Size and/or Material","Current Utility Investigation Level","Proposed Infrastructure Conflict Description","Conflict Start Station and  Offset","Conflict End Station and  Offset","Required Utility Investigation Level","Test Hole Number","Utility Top and Bottom Elevation","Conflict Top and Bottom Elevation","Lateral Clearance from Utility to Conflict ","Recommended Action or Resolution","Estimated Resolution Date","Resolution Status"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Key:"]
["[List of acronyms used in the utility conflict matrix]"]

{"sheet":"Cost Estimate Analysis","index":1,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[0,0,0,12],[1,0,1,12],[22,1,22,2],[23,1,23,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[17,1,17,2],[18,1,18,2],[15,1,15,2],[16,1,16,2],[14,1,14,2]]}
["Utility Conflict Resolution Alternatives"]
["Cost Estimate Analysis"]
[]
[null,"Contract Number: ",{"$f":"'Utility Conflcit Matrix'!C3","v":0},null,null,null,null,null,null,"Cost Estimate Analysis Developed/Revised By:"]
[null,"Project Title:",{"$f":"'Utility Conflcit Matrix'!C4","v":0},null,null,null,null,null,null,"Date:"]
[null,"County - MR # :",{"$f":"'Utility Conflcit Matrix'!C5","v":0},{"$f":"'Utility Conflcit Matrix'!D5","v":"MR #"},{"$f":"'Utility Conflcit Matrix'!E5","v":0},null,null,null,null,"Reviewed By:"]
[null,"Road Name :",{"$f":"'Utility Conflcit Matrix'!C6","v":0},null,null,null,null,null,null,"Date:"]
[null,"Project Development Stage:",{"$f":"'Utility Conflcit Matrix'!C7","v":0}]
[]
[null,"Utility Conflict:"]
[null,"Utility Owner:"]
[null,"Utility Type:"]
[null,"Size and/or Material:"]
[]
["Alternative Number","Alternative Description",null,"Alternative Advantage","Alternative Disadvantage","Responsible Party","Engineering Cost (Utility)","Direct Cost (Utility)","Engineering Cost (DOT)","Direct Cost (DOT)","Total Cost","Feasibility","Decision"]

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

{"sheet":"Field and Column Descriptions","index":3,"n_rows":64,"n_cols":2,"rows_kept":64,"cut":false,"hidden":false,"merged":[]}
["Utility Conflict Matrix Column/Field Description"]
[]
[]
["Field","Description"]
["Contract Number","Contract number as shown on the Project Initiation Form."]
["Project Title","Project title as shown on the Project Initiation Form."]
["County - MR # - Name","Select County from drop down list and manually input the maintenance road number (next cell) and the road name (next cell)."]
["Project Development Phase","Select the Project Development Phase from the drop down list."]
["Section","Select the section that the project is assigned to from the drop down list."]
["Project Manager","Name of the Project Manager assigned to the project."]
["Project Designer","Name of the Project Designer assigned to the project."]
["Project Consultant","Name of the Consulting Firm and Consultant PM assigned to the project, if applicable."]
["Utility Conflict Matrix Developed/Updated By","The name of the person who developed and updated the utility conflict matrix at each stage of project development."]
["Reviewed By","The name of the person who reviewed the utility conflict matrix."]
[]
["Column","Description"]
["Utility Owner","Select the name of the utility company who has responsibility for utility facility in conflict from the drop down list."]
["Conflict ID","A unique identifier created by the designer to identify a utility conflict. Additional conflicts found during plan development should receive a new Conflict ID number. DO NOT RENUMBER."]
["Drawing or Sheet No.","A reference to an engineering drawing or sheet number."]
["Conflict Status","Select the status of the utility conflict from the drop down list."]
["Utility Type","Select the type of utility facility from the drop down list. "]
["Size and/or Material","The size and/or material of utility facility.  Example: 8\" (PVC)."]
["Current Utility Investigation Level","Select the utility investigation level at design stage from the drop down list."]
["Utility Conflict Description","A short description of the utility conflict and the cause/reason for the conflict."]
["Start Station and Offset","The station, offset, and side of the beginning of the utility conflict.  Example: 241+22.35, Offset 57.24 (L)."]
["End Station and Offset","The station, offset, and side of the end of the utility conflict.  Example: 241+25.35, Offset 68.78 (L)."]
["Required Utility Investigation Level","Select the level of utility investigation required to determine a resolution strategy for the utility conflict from the drop down list."]
["Test Hole Number","The number of a test hole associated with the utility conflict if QLA is chosen as Required Utility Investigation Level."]
["Utility Top and Bottom","The elevation of top of the utility from test hole results and the calculated utility bottom elevation based on the utility size and material. "]
["Conflict Top and Bottom","The elevation of the top and bottom of the conflict based on the size and type (i.e. 24\" RCP, 48\"x48\" DI, etc) of the conflict with the utility. "]
["Utility to Conflict Lateral Clearance","horizontal lateral clearance from the utility to the conflict."]
["Recommended Action or Resolution","A text description of the recommended action to resolve the utility conflict."]
["Estimated Resolution Date","The estimate date to complete the adjustment or resolve the utility conflict."]
["Resolution Status","The status of the resolution of the utility conflict as of the project stage from drop down list."]
[]
[]
["Cost Estimate Analysis Column/Field Description"]
[]
["Field","Description"]
["Contract Number","Contract number as shown on the Project Initiation Form."]
["Project Title","Project title as shown on the Project Initiation Form."]
["Maint. Rd. No. and Name","Select County from drop down list and manually input the maintenance road number and the road name."]
["Project Development Phase","Select the Project Development Phase from the drop down list."]
["Utility Conflict Matrix Developed/Revised By","The name of the person who developed or revised the utility conflict matrix."]
["Reviewed By","The name of the person who reviewed the utility conflict matrix."]
["Conflict ID","A unique identifier for the utility conflict within the project."]
["Utility Owner","The name of the utility company or a contact at the utility company who has responsibility for utility facility in conflict."]
["Utility Type","The type of utility facility.  Example: Water, sanitary sewer, electricity, communications."]
["Size and/or Material","The size and/or material of utility facility.  Example: 8\" (PVC)."]
["Project Phase:","The phase of the project development process at which this analysis is performed."]
[]
["Column","Description"]
["Alternative Number","A number for a utility conflict resolution strategy that is unique for the utility conflict."]
["Alternative Description","A description of the utility conflict resolution alternative."]
["Alternative Advantage","A description of the advantages of pursuing this utility conflict resolution alternative."]
["Alternative Disadvantage","A description of the disadvantages of pursuing this utility conflict resolution alternative."]
["Responsible Party","The party responsible for resolving the utility conflict from drop down list."]
["Engineering Cost (Utility)","The estimated engineering cost to the utility if this utility conflict resolution alternative would be selected."]
["Direct Cost (Utility)","The estimated direct cost to the utility if this utility conflict resolution alternative would be selected."]
["Engineering Cost (DOT)","The estimated engineering cost to the DOT if this utility conflict resolution alternative would be selected."]
["Direct Cost (DOT)","The estimated direct cost to the DOT if this utility conflict resolution alternative would be selected."]
["Total Cost","The sum of all estimated costs if this utility conflict resolution alternative would be selected."]
["Feasibility","An indicator if the alternative is feasible or not from drop down list."]
["Decision","Status of conflict resolution decision from drop down list."]

{"sheet":"Drop-Down Lists","index":4,"n_rows":77,"n_cols":3,"rows_kept":77,"cut":false,"hidden":false,"merged":[]}
["Utility Owner (previously)",null,"Utility Type"]
["Artesian Water Company ",null,"Communications (OH)"]
["Atlantic Broadband ",null,"Communications (UG)"]
["AT&T ",null,"Electric-Distribution (OH)"]
["B&O RR - Communications",null,"Electric-Distribution (UG)"]
["Century Link (Quest/Level 3) ",null,"Electric- Transmission"]
["Chesapeake Utilities ",null,"Fiber Optic (UG)"]
["City of Dover ",null,"Fiber Optic (OH)"]
["City of Harrington ",null,"Gas - Distribution"]
["City of Lewes ",null,"Gas- Transmission"]
["City of Milford Sanitary ",null,"Oil"]
["City of New Castle ",null,"Sewer"]
["City of Newark ",null,"Steam"]
["City of Rehoboth Beach ",null,"Storm Sewer"]
["City of Seaford ",null,"Water"]
["City of Wilmington",null,"Unknown"]
["Comcast"]
["Conrail Corporation "]
["Crown Castle (Next G, Fibertech, Ligthtower,Sunesys) ",null,"Utility Investigation Quality Level"]
["Delaware Electric Cooperative ",null,"QLA - Test holes"]
["Delaware Pipeline Co. ",null,"QLB - Designation"]
["DSWA ",null,"QLC - Above ground survey"]
["Delaware Storage and Pipeline Co. ",null,"QLD - Existing Utility records"]
["DelDOT ",null,"N/A"]
["Delmarva Power Communications",null,"Undetermined"]
["Delmarva Power Electric"]
["Delmarva Power Gas"]
["Eastern Shore Natural Gas",null,"Responsible Party"]
["Kent County ",null,"Utility"]
["Linde-Airco ",null,"DOT"]
["Long Neck Water Co. ",null,"Utility and DOT"]
["MCI",null,"N/A"]
["Mediacom"]
["New Castle County"]
["Sussex County "]
["Tidewater Utilities Inc ",null,"Resolution Status"]
["Town of Bethany Beach ",null,"Utility conflict created"]
["Town of Bridgeville ",null,"Utility owner informed of  conflict"]
["Town of Camden/Wyoming ",null,"Conflict resolution strategy selected"]
["Town of Dagsboro",null,"Utility conflict resolved"]
["Town of Delmar"]
["Town of Elkton "]
["Town of Georgetown ",null,"Feasibility"]
["Town of Greenwood ",null,"Yes"]
["Town of Laurel",null,"No"]
["Town of Middletown"]
["Town of Millsboro"]
["Town of Milton",null,"Decision"]
["Town of Newport",null,"Under Review"]
["Town of Ocean View",null,"Selected"]
["Town of Smyrna",null,"Rejected"]
["Suez Water (United Water)"]
["University of Delaware "]
["Uniti Fiber (Peg Bandwidth, Gore) ",null,"Conflict Status"]
["Verizon ",null,"Actual"]
["Windstream  (Cavalier)",null,"Potential"]
["Zayo (Above Net)",null,"No Conflict"]
[]
[]
[null,null,"Section"]
[null,null,"Bridge Design"]
[null,null,"Project Development North I"]
[null,null,"Project Development North II"]
[null,null,"Project Development South I"]
[null,null,"Project Development South II"]
[]
[]
[null,null,"County"]
[null,null,"New Castle"]
[null,null,"Kent"]
[null,null,"Sussex"]
[]
[]
[null,null,"Project Stage"]
[null,null,"Preliminary"]
[null,null,"Semi-Final"]
[null,null,"Final"]