{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Utility Conflic Matrix - Basic","Pole Relocation Summary Sheet","Cost Estimate Analysis","Column Descriptions","Drop down lists"],"not_rendered":{"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"Utility Conflic Matrix - Basic","index":0,"n_rows":69,"n_cols":13,"rows_kept":69,"merged":[[0,0,0,12],[1,1,1,2],[2,1,2,2],[3,1,3,2],[4,1,4,4],[6,7,6,8]]}
["UTILITY UNDERGROUND CONFLICT MATRIX"]
["Project Name: ",{"$nulls":8},"Utility Conflict Matrix Developed/Revised By: "]
["Project Fed No. :",{"$nulls":8},"Date: "]
["Project State No. :",{"$nulls":8},"Reviewed By: "]
["Project Description:",{"$nulls":8},"Date: "]
[{"$nulls":5},"   Note: refer to subsheet for utility conflict cost analysis."]
[{"$nulls":7},"S.U.E."]
["Utility Owner and/or Contact Name","Beginning Station/Offset","Ending Station/Offset","Cut/Fill\n(-/+)","Utility Type","Size and Material","Utility Conflict Description","Utility Quality Level","Test Hole ID","Proposeded Action or Resolution","Proposed Beginning Station/Offset","Proposed Ending Station/Offset","Cut/Fill     (-/+)"]
["COMMINICATIONS CONFLICTS"]
{"$rows_empty":19}
["WATER CONFLICTS"]
{"$rows_empty":19}
["SEWER CONFLICTS"]
{"$rows_empty":19}
["GAS CONFLICTS"]

{"sheet":"Pole Relocation Summary Sheet","index":1,"n_rows":29,"n_cols":13,"rows_kept":29,"merged":[[1,9,1,10],[5,0,5,4],[5,7,5,8],[5,9,5,10],[6,0,6,1],[6,9,6,10],[7,0,7,1],[7,9,7,10],[8,0,8,1],[8,9,8,10],[9,0,9,1],[9,9,9,10],[10,0,10,1],[10,9,10,10],[11,0,11,1],[11,9,11,10],[12,0,12,1],[12,9,12,10],[13,0,13,1],[13,9,13,10],[14,0,14,1],[14,9,14,10],[15,0,15,1],[15,9,15,10],[16,0,16,1],[16,9,16,10],[17,0,17,1],[17,9,17,10],[18,0,18,1],[18,9,18,10],[19,0,19,1],[19,9,19,10],[20,0,20,1],[20,9,20,10],[21,0,21,1],[21,9,21,10],[22,0,22,1],[22,9,22,10],[23,0,23,1],[23,9,23,10],[24,0,24,1],[24,9,24,10],[25,0,25,1],[25,9,25,10]]}
[]
[null,"PROJECT NAME:",{"$f":"'Utility Conflic Matrix - Basic'!B2","v":0},null,null,"FED NUMBER:",{"$f":"'Utility Conflic Matrix - Basic'!B3","v":0},null,"PROJECT NUMBER:",{"$f":"'Utility Conflic Matrix - Basic'!B4","v":0}]
[]
[null,"PREPARED BY:",{"$nulls":3},"DATE:",null,null,"PROPOSED BY:"]
[]
["Existing",{"$nulls":4},"Proposed Grade Change","Design Speed\n\n__________________________","Proposed by\nUtility",null,"Approved by NHDOT",null,"Grade Change"]
["Station/Offset",null,"Pole Identification","Leave/ Remove","Occupant","Cut/Fill (-/+) FT","NHDOT Remarks","Station","Offset","Station/Offset",null,"Cut/Fill (-/+) FT","Remarks"]
[{"$f":"'Utility Conflic Matrix - Basic'!B10","v":0},null,{"$f":"'Utility Conflic Matrix - Basic'!F10","v":0},{"$f":"'Utility Conflic Matrix - Basic'!J10","v":0},{"$f":"'Utility Conflic Matrix - Basic'!A10","v":0},{"$f":"'Utility Conflic Matrix - Basic'!D10","v":0},{"$f":"'Utility Conflic Matrix - Basic'!G10","v":0},null,null,{"$f":"'Utility Conflic Matrix - Basic'!K10","v":0},null,{"$f":"'Utility Conflic Matrix - Basic'!M10","v":0}]
[{"$f":"'Utility Conflic Matrix - Basic'!B11","v":0},null,{"$f":"'Utility Conflic Matrix - Basic'!F11","v":0},{"$f":"'Utility Conflic Matrix - Basic'!J11","v":0},{"$f":"'Utility Conflic Matrix - Basic'!A11","v":0},{"$f":"'Utility Conflic Matrix - Basic'!D11","v":0},{"$f":"'Utility Conflic Matrix - Basic'!G11","v":0},null,null,{"$f":"'Utility Conflic Matrix - Basic'!K11","v":0},null,{"$f":"'Utility Conflic Matrix - Basic'!M11","v":0}]
[{"$f":"'Utility Conflic Matrix - Basic'!B12","v":0},null,{"$f":"'Utility Conflic Matrix - Basic'!F12","v":0},{"$f":"'Utility Conflic Matrix - Basic'!J12","v":0},{"$f":"'Utility Conflic Matrix - Basic'!A12","v":0},{"$f":"'Utility Conflic Matrix - Basic'!D12","v":0},{"$f":"'Utility Conflic Matrix - Basic'!G12","v":0},null,null,{"$f":"'Utility Conflic Matrix - Basic'!K12","v":0},null,{"$f":"'Utility Conflic Matrix - Basic'!M12","v":0}]
[{"$f":"'Utility Conflic Matrix - Basic'!B13","v":0},null,{"$f":"'Utility Conflic Matrix - Basic'!F13","v":0},{"$f":"'Utility Conflic Matrix - Basic'!J13","v":0},{"$f":"'Utility Conflic Matrix - Basic'!A13","v":0},{"$f":"'Utility Conflic Matrix - Basic'!D13","v":0},{"$f":"'Utility Conflic Matrix - Basic'!G13","v":0},null,null,{"$f":"'Utility Conflic Matrix - Basic'!K13","v":0},null,{"$f":"'Utility Conflic Matrix - Basic'!M13","v":0}]
[{"$f":"'Utility Conflic Matrix - Basic'!B14","v":0},null,{"$f":"'Utility Conflic Matrix - Basic'!F14","v":0},{"$f":"'Utility Conflic Matrix - Basic'!J14","v":0},{"$f":"'Utility Conflic Matrix - Basic'!A14","v":0},{"$f":"'Utility Conflic Matrix - Basic'!D14","v":0},{"$f":"'Utility Conflic Matrix - Basic'!G14","v":0},null,null,{"$f":"'Utility Conflic Matrix - Basic'!K14","v":0},null,{"$f":"'Utility Conflic Matrix - Basic'!M14","v":0}]
[{"$f":"'Utility Conflic Matrix - Basic'!B15","v":0},null,{"$f":"'Utility Conflic Matrix - Basic'!F15","v":0},{"$f":"'Utility Conflic Matrix - Basic'!J15","v":0},{"$f":"'Utility Conflic Matrix - Basic'!A15","v":0},{"$f":"'Utility Conflic Matrix - Basic'!D15","v":0},{"$f":"'Utility Conflic Matrix - Basic'!G15","v":0},null,null,{"$f":"'Utility Conflic Matrix - Basic'!K15","v":0},null,{"$f":"'Utility Conflic Matrix - Basic'!M15","v":0}]
[{"$f":"'Utility Conflic Matrix - Basic'!B16","v":0},null,{"$f":"'Utility Conflic Matrix - Basic'!F16","v":0},{"$f":"'Utility Conflic Matrix - Basic'!J16","v":0},{"$f":"'Utility Conflic Matrix - Basic'!A16","v":0},{"$f":"'Utility Conflic Matrix - Basic'!D16","v":0},{"$f":"'Utility Conflic Matrix - Basic'!G16","v":0},null,null,{"$f":"'Utility Conflic Matrix - Basic'!K16","v":0},null,{"$f":"'Utility Conflic Matrix - Basic'!M16","v":0}]
[{"$f":"'Utility Conflic Matrix - Basic'!B17","v":0},null,{"$f":"'Utility Conflic Matrix - Basic'!F17","v":0},{"$f":"'Utility Conflic Matrix - Basic'!J17","v":0},{"$f":"'Utility Conflic Matrix - Basic'!A17","v":0},{"$f":"'Utility Conflic Matrix - Basic'!D17","v":0},{"$f":"'Utility Conflic Matrix - Basic'!G17","v":0},null,null,{"$f":"'Utility Conflic Matrix - Basic'!K17","v":0},null,{"$f":"'Utility Conflic Matrix - Basic'!M17","v":0}]
[{"$f":"'Utility Conflic Matrix - Basic'!B18","v":0},null,{"$f":"'Utility Conflic Matrix - Basic'!F18","v":0},{"$f":"'Utility Conflic Matrix - Basic'!J18","v":0},{"$f":"'Utility Conflic Matrix - Basic'!A18","v":0},{"$f":"'Utility Conflic Matrix - Basic'!D18","v":0},{"$f":"'Utility Conflic Matrix - Basic'!G18","v":0},null,null,{"$f":"'Utility Conflic Matrix - Basic'!K18","v":0},null,{"$f":"'Utility Conflic Matrix - Basic'!M18","v":0}]
[{"$f":"'Utility Conflic Matrix - Basic'!B19","v":0},null,{"$f":"'Utility Conflic Matrix - Basic'!F19","v":0},{"$f":"'Utility Conflic Matrix - Basic'!J19","v":0},{"$f":"'Utility Conflic Matrix - Basic'!A19","v":0},{"$f":"'Utility Conflic Matrix - Basic'!D19","v":0},{"$f":"'Utility Conflic Matrix - Basic'!G19","v":0},null,null,{"$f":"'Utility Conflic Matrix - Basic'!K19","v":0},null,{"$f":"'Utility Conflic Matrix - Basic'!M19","v":0}]
[{"$f":"'Utility Conflic Matrix - Basic'!B20","v":0},null,{"$f":"'Utility Conflic Matrix - Basic'!F20","v":0},{"$f":"'Utility Conflic Matrix - Basic'!J20","v":0},{"$f":"'Utility Conflic Matrix - Basic'!A20","v":0},{"$f":"'Utility Conflic Matrix - Basic'!D20","v":0},{"$f":"'Utility Conflic Matrix - Basic'!G20","v":0},null,null,{"$f":"'Utility Conflic Matrix - Basic'!K20","v":0},null,{"$f":"'Utility Conflic Matrix - Basic'!M20","v":0}]
[{"$f":"'Utility Conflic Matrix - Basic'!B21","v":0},null,{"$f":"'Utility Conflic Matrix - Basic'!F21","v":0},{"$f":"'Utility Conflic Matrix - Basic'!J21","v":0},{"$f":"'Utility Conflic Matrix - Basic'!A21","v":0},{"$f":"'Utility Conflic Matrix - Basic'!D21","v":0},{"$f":"'Utility Conflic Matrix - Basic'!G21","v":0},null,null,{"$f":"'Utility Conflic Matrix - Basic'!K21","v":0},null,{"$f":"'Utility Conflic Matrix - Basic'!M21","v":0}]
[{"$f":"'Utility Conflic Matrix - Basic'!B22","v":0},null,{"$f":"'Utility Conflic Matrix - Basic'!F22","v":0},{"$f":"'Utility Conflic Matrix - Basic'!J22","v":0},{"$f":"'Utility Conflic Matrix - Basic'!A22","v":0},{"$f":"'Utility Conflic Matrix - Basic'!D22","v":0},{"$f":"'Utility Conflic Matrix - Basic'!G22","v":0},null,null,{"$f":"'Utility Conflic Matrix - Basic'!K22","v":0},null,{"$f":"'Utility Conflic Matrix - Basic'!M22","v":0}]
[{"$f":"'Utility Conflic Matrix - Basic'!B23","v":0},null,{"$f":"'Utility Conflic Matrix - Basic'!F23","v":0},{"$f":"'Utility Conflic Matrix - Basic'!J23","v":0},{"$f":"'Utility Conflic Matrix - Basic'!A23","v":0},{"$f":"'Utility Conflic Matrix - Basic'!D23","v":0},{"$f":"'Utility Conflic Matrix - Basic'!G23","v":0},null,null,{"$f":"'Utility Conflic Matrix - Basic'!K23","v":0},null,{"$f":"'Utility Conflic Matrix - Basic'!M23","v":0}]
[{"$f":"'Utility Conflic Matrix - Basic'!B24","v":0},null,{"$f":"'Utility Conflic Matrix - Basic'!F24","v":0},{"$f":"'Utility Conflic Matrix - Basic'!J24","v":0},{"$f":"'Utility Conflic Matrix - Basic'!A24","v":0},{"$f":"'Utility Conflic Matrix - Basic'!D24","v":0},{"$f":"'Utility Conflic Matrix - Basic'!G24","v":0},null,null,{"$f":"'Utility Conflic Matrix - Basic'!K24","v":0},null,{"$f":"'Utility Conflic Matrix - Basic'!M24","v":0}]
[{"$f":"'Utility Conflic Matrix - Basic'!B25","v":0},null,{"$f":"'Utility Conflic Matrix - Basic'!F25","v":0},{"$f":"'Utility Conflic Matrix - Basic'!J25","v":0},{"$f":"'Utility Conflic Matrix - Basic'!A25","v":0},{"$f":"'Utility Conflic Matrix - Basic'!D25","v":0},{"$f":"'Utility Conflic Matrix - Basic'!G25","v":0},null,null,{"$f":"'Utility Conflic Matrix - Basic'!K25","v":0},null,{"$f":"'Utility Conflic Matrix - Basic'!M25","v":0}]
[{"$f":"'Utility Conflic Matrix - Basic'!B26","v":0},null,{"$f":"'Utility Conflic Matrix - Basic'!F26","v":0},{"$f":"'Utility Conflic Matrix - Basic'!J26","v":0},{"$f":"'Utility Conflic Matrix - Basic'!A26","v":0},{"$f":"'Utility Conflic Matrix - Basic'!D26","v":0},{"$f":"'Utility Conflic Matrix - Basic'!G26","v":0},null,null,{"$f":"'Utility Conflic Matrix - Basic'!K26","v":0},null,{"$f":"'Utility Conflic Matrix - Basic'!M26","v":0}]
[{"$f":"'Utility Conflic Matrix - Basic'!B27","v":0},null,{"$f":"'Utility Conflic Matrix - Basic'!F27","v":0},{"$f":"'Utility Conflic Matrix - Basic'!J27","v":0},{"$f":"'Utility Conflic Matrix - Basic'!A27","v":0},{"$f":"'Utility Conflic Matrix - Basic'!D27","v":0},{"$f":"'Utility Conflic Matrix - Basic'!G27","v":0},null,null,{"$f":"'Utility Conflic Matrix - Basic'!K27","v":0},null,{"$f":"'Utility Conflic Matrix - Basic'!M27","v":0}]
[{"$f":"'Utility Conflic Matrix - Basic'!B28","v":0},null,{"$f":"'Utility Conflic Matrix - Basic'!F28","v":0},{"$f":"'Utility Conflic Matrix - Basic'!J28","v":0},{"$f":"'Utility Conflic Matrix - Basic'!A28","v":0},{"$f":"'Utility Conflic Matrix - Basic'!D28","v":0},{"$f":"'Utility Conflic Matrix - Basic'!G28","v":0},null,null,{"$f":"'Utility Conflic Matrix - Basic'!K28","v":0},null,{"$f":"'Utility Conflic Matrix - Basic'!M28","v":0}]
[]
["Notes:","1) Offsets are measured from Construction Centerline to face of pole.",{"$nulls":4},"3) Occupant: P = Power; T = Telephone; C = Cable TV; F = Fire Alarm; J = Joint; tw = traveld way; uvc = urban vertical curb; gr = guardrail"]
[null,"2) Approved locations shall not be changed without approval of the Utilities Engineer.",{"$nulls":4},"4) Guys and push brace easements and locations are the responsibility of the Pole Maintainer"]

{"sheet":"Cost Estimate Analysis","index":2,"n_rows":15,"n_cols":13,"rows_kept":15,"merged":[[0,0,0,12],[1,0,1,12],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2]]}
["Utility Conflict Resolution Alternatives"]
["Cost Estimate Analysis"]
[]
[null,"Project Owner: ",{"$nulls":7},"Cost Estimate Analysis Developed/Revised By "]
[null,"Project No. :",{"$nulls":7},"Date "]
[null,"Project Description:",{"$nulls":7},"Reviewed By "]
[null,"Highway or Route:",{"$nulls":7},"Date "]
[]
[null,"Utility Conflict:"]
[null,"Utility Owner:"]
[null,"Utility Type:"]
[null,"Size and/or Material:"]
[null,"Project Phase:"]
[]
["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":"Column Descriptions","index":3,"n_rows":56,"n_cols":2,"rows_kept":56}
["Utility Conflict Matrix Column/Field Description"]
[]
[]
["Field","Description"]
["Project Owner","The owner of the transportation project, typically the DOT."]
["Project No.","A number given by the project owner to identify the project."]
["Project Description","A description of the project."]
["Highway or Route","The highway or route where the project is located."]
["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."]
[]
["Column","Description"]
["Utility Owner and/or Contact Name","The name of the utility company or a contact at the utility company who has responsibility for utility facility in conflict."]
["Conflict ID","A unique identifier for the utility conflict within the project."]
["Drawing or Sheet No.","A reference to an engineering drawing or sheet number."]
["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)."]
["Utility Conflict Description","A short description of the utility conflict and the  work needed to resolve 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)."]
["Utility Investigation Level Needed","The level of utility investigation needed to determine a resolution strategy for the utility conflict. Valid values are QLD, QLC, QLB, QLA, and Undetermined."]
["Test Hole","The number of a test hole associated with the utility conflict if QLA is chosen as Utility Investigation Level Needed"]
["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 date the utility conflict matrix was produced."]
["Cost Analysis","A link to a detailed cost analysis of potential utility conflict resolution alternatives."]
[]
[]
["Cost Estimate Analysis Column/Field Description"]
[]
["Field","Description"]
["Project Owner","The owner of the transportation project, typically the DOT."]
["Project No.","A number given by the project owner to identify the project."]
["Project Description","A description of the project."]
["Highway or Route","The highway or route where the project is located."]
["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.  Example: Utility owner, DOT, both utility owner and DOT, and not available."]
["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."]
["Decision","An indicator if the alternative is under review, has been selected, or has been rejected."]

{"sheet":"Drop down lists","index":4,"n_rows":41,"n_cols":1,"rows_kept":41}
["Drop Down Lists"]
[]
["Utility Type"]
["Communications"]
["Electric"]
["Gas"]
["Oil"]
["Reclaimed Water"]
["Sanitary Sewer"]
["Steam"]
["Storm Sewer"]
["Water"]
["Unknown"]
[]
["Utility Investigation Quality Level"]
["QLA"]
["QLB"]
["QLC"]
["QLD"]
["Undetermined"]
[]
["Responsible Party"]
["Utility"]
["DOT"]
["Utility and DOT"]
["N/A"]
[]
["Resolution Status"]
["Utility conflict created"]
["Utility owner informed of utility conflict"]
["Utility conflict resolution strategy selected"]
["Utility conflict resolved"]
[]
["Feasibility"]
["Yes"]
["No"]
[]
["Decision"]
["Under Review"]
["Selected"]
["Rejected"]