{"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":19,"rows_kept":34,"cut":false,"hidden":false,"merged":[[0,0,0,18]]}
["DelDOT Utility Conflict Matrix"]
[]
["Contract Number: ",null,null,null,null,null,null,"Section: ",null,null,null,null,null,null,null,"Preliminary UCM Developed Dy - Date:  "]
["Project Title: ",null,null,null,null,null,null,"Project Manager: ",null,null,null,null,null,null,null,"Reviewed By - Date: "]
["County - MR # - Name: ",null,null,null,null,null,null,"Project Designer: ",null,null,null,null,null,null,null,"Semi-Final UCM Updated By - Date: "]
["Project Development Stage: ",null,null,null,null,null,null,"Project Consultant: ",null,null,null,null,null,null,null,"Reviewed By - Date: "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Final UCM Updated By - Date: "]
[null,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: "]
[]
["Utility Owner","Conflict ID","Drawing or Sheet No. ","Conflict Status","Utility Type","Size and/or Material","Current Utility Investigation Level","Utility Conflict Description","Start Station","Start Offset","End Station","End Offset","Required Utility Investigation Level","Test Hole Number","Utility Top and Bottom","Conflict Top and Bottom","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],[21,1,21,2],[22,1,22,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[16,1,16,2],[17,1,17,2],[14,1,14,2],[15,1,15,2],[13,1,13,2]]}
["Utility Conflict Resolution Alternatives"]
["Cost Estimate Analysis"]
[]
[null,"Contract Number: ",{"$f":"'Utility Conflcit Matrix'!B3","v":0},null,null,null,null,null,null,"Cost Estimate Analysis Developed/Revised By:"]
[null,"Project Title:",{"$f":"'Utility Conflcit Matrix'!B4","v":0},null,null,null,null,null,null,"Date:"]
[null,"County - MR # -  Name :",{"$f":"'Utility Conflcit Matrix'!B5","v":0},{"$f":"'Utility Conflcit Matrix'!C5","v":0},{"$f":"'Utility Conflcit Matrix'!D5","v":0},null,null,null,null,"Reviewed By:"]
[null,"Project Development Stage:",{"$f":"'Utility Conflcit Matrix'!B6","v":0},null,null,null,null,null,null,"Date:"]
[]
[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"]
[null,null,null,null,null,"Utility and DOT"]

{"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":63,"n_cols":2,"rows_kept":63,"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 and the road name."]
["Project Development Phase","Select the Project Development Phase from the drop down list."]
["Section","Section that the project is assigned to from 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 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","The name of the utility company who has responsibility for utility facility in conflict."]
["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","Status of the utility conflict from drop down list."]
["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)."]
["Current Utility Investigation Level","Utility investigation level at design stage from 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","The level of utility investigation required to determine a resolution strategy for the utility conflict from drop down list."]
["Test Hole Number","The number of a test hole associated with the utility conflict if QLA is chosen as Utility Investigation Level Needed."]
["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. "]
["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 conflcit resolution decision from drop down list."]

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