{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Step 1","Step 2","Step 2-Complexity Factors","Impact Summary"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":16,"comments":1,"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":"Instructions","index":0,"n_rows":19,"n_cols":1,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["SUE Utility Impact Form "]
[]
["Instructions"]
["-Step 1 is a screening processes and determines whether SUE (quality levels A & B) should be utilized for a project.\n-If Step 1 indicates further analysis is required, conduct Step 2.\n"]
[]
["Step 1"]
["Project information such as title, cost, description (general summary), and scope (actual work scope) should be filled out before beginning Step 1. If the scope of the project is changed, the utility impact rating analysis should be performed again for that project. Step 1 determines whether SUE (Quality levels A & B) should be utilized for a project. "]
[]
["The questions in Step 1 can be answered with traditional utility information (Quality levels C & D) provided by a one-call system, utility companies, site visits, etc. If there are no boxes checked in Column 2, then it is generally not practical to perform a SUE Quality levels A & B investigation. If boxes in Column 2 for questions 2, 3 or 4 are checked, the utility impact rating analysis proceeds to Step 2  to calculate a utility impact score and determine the appropriate SUE quality levels."]
[]
["Step 2"]
["Step 2 determines which SUE quality levels QLB or QLA should be selected for a project/section/location. Title, cost, description (general summary), and scope (actual work scope) should be filled out before answering the questions. The Step 2 questions are answered for a project, a section, or a location, while all questions in Step 1  are for a project. One project can have several sections or locations that have different utility impacts. Step 2 should be conducted for each section or location as necessary so that SUE quality levels can be selected for each section or location. "]
[]
["Filing Procedure"]
["File a copy of the SUE Utility Impact Form in the project file and upload to EDMS."]
[]
["NOTE:  When filling out the utility impact form electronically as a Microsoft Excel Spreadsheet:"]
["Yellow shaded fields will be automatically completed."]
["Fields with no shading require input from the user."]

{"sheet":"Step 1","index":1,"n_rows":23,"n_cols":14,"rows_kept":23,"cut":false,"hidden":false,"merged":[[5,0,8,1],[5,2,8,6],[9,0,16,1],[9,2,16,6],[18,1,18,2],[19,1,19,2],[22,0,22,6],[17,3,17,4],[17,5,17,6],[17,1,17,2],[20,1,20,2],[21,1,21,2],[3,2,3,6],[4,0,4,1],[4,2,4,6],[0,0,0,6],[1,0,1,6],[2,0,2,6],[3,0,3,1]]}
["SUE UTILITY IMPACT FORM-STEP 1"]
["Steps 1 is a screening process and Step 2 is an evaluation of the project passing Step 1."]
["Project Information"]
["MPMS Number/Title: "]
["County/SR/Section:"]
["Project Description:\n(General Summary)"]
[]
[]
[]
["Project Scope:\n(Actual Work Scope\nNote: If the scope of the project changes, it is recommended that utility impact analysis be done again.)"]
[]
[]
[]
[]
[]
[]
[]
["No.","QUESTIONS",null,"Column 1",null,"Column 2",null,"Reset Line"]
[1,"Is there evidence of underground utilities in the project area? (based on information from SUE quality level D&C)",null,null,"NO",null,"YES or Unknown",null,null,null,null,2,{"$f":"IF(L19=1,L19,)","v":0},{"$f":"IF(L19=2,L19,)","v":2}]
[2,"Does the project require more than 2 feet of excavation? Note: This includes any temporary construction easements (TCE) or other easements.",null,null,"NO",null,"YES or Unknown",null,null,null,null,3,{"$f":"IF(L20=1,L20,)","v":0},{"$f":"IF(L20=2,L20,)","v":0}]
[3,"What is the likelihood that project will have impact on the existing subsurface utilities?",null,null,"No Impact",null,"Impact",null,null,null,null,3,0,0]
[4,"Do the utility owners in the project area have accurate utility information?",null,null,"Yes",null,"No",null,null,null,null,3,0,0]
["- If there are no boxes checked in Column 2, then it is generally not practicable to perform a SUE quality levels A and B investigation.\n- If the boxes in Column 2 for questions 2, 3 or 4 are checked, please proceed to STEP 2 to calculate utility impact score and determine the appropriate SUE quality levels.\n",null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(M19:M22,\"=1\")","v":0},{"$f":"COUNTIFS(N19:N22,\"=2\")","v":1}]

{"sheet":"Step 2","index":2,"n_rows":28,"n_cols":20,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,7],[0,8,0,15],[15,0,15,1],[4,0,4,1],[17,0,17,7],[10,1,10,5],[5,0,8,1],[14,0,14,7],[13,0,13,6],[16,0,16,1],[12,3,12,5],[11,3,11,5],[1,0,1,7],[3,16,4,16],[4,10,4,11],[4,12,4,13],[4,14,4,15],[18,0,18,7],[4,2,4,7],[11,1,11,2],[12,1,12,2],[5,2,8,7],[3,2,3,7],[16,2,16,7],[15,4,15,5],[15,6,15,7],[15,2,15,3],[1,8,3,15],[3,0,3,1],[19,0,19,7],[2,0,2,7],[20,0,20,2],[21,0,21,2],[20,4,20,5],[21,4,21,5],[20,6,20,7],[21,6,21,7]]}
["SUE UTILITY IMPACT FORM – STEP 2 SUMMARY ANALYSIS",null,null,null,null,null,null,null,"SUE UTILITY IMPACT FORM – STEP 2 DETAILED ANALYSIS"]
["STEP 2 determines which SUE quality level should be selected for a project/section/location.",null,null,null,null,null,null,null,"-Check the utility impact rating to the right that best fits your opinion of the issue. If the answer for the complexity factor is unknown, always check Column 3.  \n-Refer to page 5 for a detailed description of the complexity factors.  \n-When using an electronic version for the Step 2 analysis, place cursor over the cell on the spread sheet for a detailed description of the complexity factor."]
["*NOTE-Step 2 analysis can be conducted at the project level, or for a specific location within the project (e.g., intersection, utility crossing, etc.).  Conduct Step 2 detailed analysis as necessary for each potential impact location."]
["MPMS Number/Title: ",null,{"$f":"IF(ISBLANK('Step 1'!C4),\"\",'Step 1'!C4)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"Reset \nLine"]
["County/SR/Section:",null,{"$f":"IF(ISBLANK('Step 1'!C5),\"\",'Step 1'!C5)","v":""},null,null,null,null,null,"No.","Complexity Factors","Column 1",null,"Column 2",null,"Column 3"]
["SUE Impact Location*-Description & Scope:\n(leave blank when using Step 2 for overall project level impact analysis)\n",null,null,null,null,null,null,null,1,"Density of Utilities (number)",null,"Low",null,"Medium",null,"High",null,4,{"$f":"IF(R6=4,,R6)","v":0},{"$f":"COUNTIF(S6,\">=1\")","v":0}]
[null,null,null,null,null,null,null,null,2,"Type of Utilities",null,"Less Critical",null,"Sub Critical",null,"Critical",null,4,{"$f":"IF(R7=4,,R7)","v":0},{"$f":"COUNTIF(S7,\">=1\")","v":0}]
[null,null,null,null,null,null,null,null,3,"Pattern of Utilities (number)",null,"Simple",null,"Medium",null,"Complex",null,4,0,0]
[null,null,null,null,null,null,null,null,4,"Material of Utilities",null,"Rigid",null,"Flexible",null,"Brittle",null,4,0,0]
[null,null,null,null,null,null,null,null,5,"Access to Utilities",null,"Easy",null,"Medium",null,"Restricted",null,4,0,0]
[null,"STEP 2 UTILITY IMPACT SCORE RESULTS",null,null,null,null,null,null,6,"Age of Utilities (year)",null,"New",null,"Medium",null,"Old",null,4,0,0]
[null,"Utility Impact Score:",null,"Recommended SUE Quality Level:",null,null,null,null,7,"Project Area Description",null,"Rural",null,"Suburban",null,"Urban",null,4,0,0]
[null,{"$f":"IFERROR(R20,\"\")","v":""},null,{"$f":"IFERROR(HLOOKUP(B24,D24:G28,5),\"\")","v":""},null,null,null,null,8,"Type of Project",null,"Simple",null,"Moderate",null,"Complicated",null,4,0,0]
[null,null,null,null,null,null,null,null,9,"Quality of Utility Record",null,"Good",null,"Fair",null,"Poor",null,4,0,0]
["UTILITY IMPACT SCORE CALCULATION DESCRIPTION",null,null,null,null,null,null,null,10,"Estimated Business Impact",null,"Low",null,"Moderate",null,"High",null,4,0,0]
["1:  Total Box Checked",null,"Sum of Column 1",null,"Sum of Column 2",null,"Sum of Column 3",null,11,"Estimated Environmental Impact",null,"Low",null,"Moderate",null,"High",null,4,0,0]
["2: Utility Impact Score",null,"[(1 x Sum of Column 1) + (2 x Sum of Column 2) + (3 x Sum of Column 3)] / n",null,null,null,null,null,12,"Estimated Safety Impact",null,"Low",null,"Moderate",null,"High",null,4,0,0]
["This Table demonstrates the process for calculating the utility impact score based on response.\nn = Number of the complexity factors considered/checked",null,null,null,null,null,null,null,13,"Other Impact-Specify:",null,"Low",null,"Moderate",null,"High",null,4,0,0]
["UTILITY IMPACT SCORING LEVELS AND FACTORS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R6:R18)","v":52},{"$f":"SUM(S6:S18)","v":0},{"$f":"SUM(T6:T18)","v":0}]
["This table provides the recommended SUE quality level based on the utility impact score range.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(S19/T19,2)","v":{"$error":"#DIV/0!"}}]
["Utility Impact Score",null,null,"1.01-1.67","1.68-2.33",null,"2.34-3.00"]
["Recommended Minimum \nSUE Quality Levels",null,null,"QLB","QLB/A",null,"QLA"]
[null,"Impact Value"]
[null,{"$f":"IF(B13=\"\",\"\",IF(B13>=2.34,4,IF(B13>=1.68,3, IF(B13>=1.06,2,\"\"))))","v":""},null,1,2,3,4]
[null,null,"Low",1,1.06,1.68,2.34]
[null,null,"High",1.05,1.67,2.33,3]
[null,null,"Utility Impact Score",null,"1.05-1.67","1.68-2.33","2.34-3.00"]
[null,null,"SUE Quality Levels",null,"QLB","QLB/A","QLA"]

{"sheet":"Step 2-Complexity Factors","index":3,"n_rows":67,"n_cols":2,"rows_kept":67,"cut":false,"hidden":false,"merged":[[28,0,28,1],[63,0,63,1],[58,0,58,1],[53,0,53,1],[48,0,48,1],[43,0,43,1],[38,0,38,1],[33,0,33,1],[0,0,0,1],[23,0,23,1],[18,0,18,1],[13,0,13,1],[8,0,8,1],[3,0,3,1],[1,0,1,1]]}
[" SUE UTILITY IMPACT FORM - STEP 2 COMPLEXITY FACTORS"]
["This section presents detailed descriptions of each complexity factor in order to properly evaluate the utility impact rating that best fits the opinion of the issue in STEP 2."]
["1.      Number of Utilities"]
["Number of utilities indicates the number of buried utilities per roadway cross-section that can be expected to be encountered on the project. If there are many utilities expected to be buried within the project, more reliable data/information will be required to successfully locate the utilities. A higher density of utilities means more utility complexity, which requires getting better information related to underground utilities on the project."]
["Low","One pipe/roadway cross-section"]
["Medium","2 or 3 pipes/roadway cross-section"]
["High","More than 3 pipes/roadway cross-section and unknown pipes"]
["2.      Type of Utilities"]
["Type of utilities indicates service types of buried utilities that can be expected to be encountered on the project. Utilities can be broadly divided into three different categories: (1) municipal, (2) energy, and (3) communication. Critical utilities, such as fiber-optic lines, are buried at a more shallow depth than other types of utilities, so the possibility of accidentally hitting these lines is high. In addition, hitting gas or high voltage lines can have serious impacts. Therefore, critical utilities generally require a greater level of data/information than other underground utilities on the project site.  "]
["Less-Critical","Water, forced sewer main, storm water"]
["Sub-Critical","Telephone, electric, television cable, gravity sewer"]
["Critical","Fiber-optic cable, gas, oil, petroleum, high-voltage line, unknowns"]
["3.      Pattern of Utilities"]
["Pattern of utilities indicates configuration of buried utilities that can be expected to be encountered on the project. Some areas may have a simple pattern that consists of a few parallel or crossing utilities, while some areas may have a complex pattern that consists of many parallel and crossing utilities. For instance, an intersection in a downtown area may have a more complex pattern of utilities than other areas. A more complex pattern of utilities requires more reliable information."]
["Simple","One parallel and/or one crossing utility"]
["Medium","2 parallel and/or 2 crossing utilities"]
["Complex","More than 2 parallel and/or crossing utilities"]
["4.      Material of Utilities"]
["Material of utilities indicates the material types of buried utilities that can be expected to be encountered on the project. This factor is separated into three different categories: (1) rigid, (2) flexible, and (3) brittle. Brittle material requires higher quality levels of SUE than other materials. Some utility materials are more susceptible to damage than others."]
["Rigid","Concrete, cast iron, ductile iron"]
["Flexible","PVC, HDPE"]
["Brittle","Such as clay, brick, ceramic, etc., or unknown"]
["5.      Access to Utilities"]
["Access to utilities indicates the difficulty or ease of access to buried utilities that may be encountered on the project. If access to buried utilities is restricted, it will be more difficult to get accurate information on these buried utilities than in areas where access to utilities is easy. It is recommended that higher quality levels of SUE be used when access to utilities is more restricted."]
["Easy","Open land"]
["Medium","Few light structures, pavement, median"]
["Restricted","Bridge pier, other big structures"]
["6.      Age of Utilities"]
["Age of utilities may reveal the type of utility material and the physical condition of the utility. Older pipes may have deteriorated extensively and become more easily damaged by an accidental hit during construction activity. In addition, existing records of old utilities may be less reliable."]
["New","≤ 10 years"]
["Medium","> 10 and ≤ 25 years"]
["Old","> 25 years"]
["7.  Project Area Description"]
["Project area description indicates the location or nature of the project. This factor is separated into three different categories: (1) rural, (2) suburban, and (3) urban. In general, urban areas have more complex and congested utilities because of higher building and infrastructure density. Therefore, an urban area usually means more congested utilities, so higher quality levels are recommended."]
["Rural","Rural areas with lots of open land"]
["Suburban","Suburban areas with few businesses and residences"]
["Urban","Urban areas with many businesses and residences"]
["8.  Type of Project/Section/Location"]
["Type of project quite often may indicate whether SUE is need. As an example, a pavement resurfacing project that generally requires work only on the pavement surface will not need SUE. Project location and, specifically, the section at which the construction work will take place may reveal traffic volume, accessibility, and potential consequences of accidentally damaging the buried utilities. This factor is separated into three different categories: (1) without excavation, (2) shallow excavation, and (3) deep excavation."]
["Simple","Without excavation, i.e., widening, other minor construction work"]
["Moderate","Shallow excavation, i.e., guide rail, low depth pipe replacement, traffic light post, shoulder cutting, minor drainage"]
["Complicated","Deep excavation, i.e., new construction, full-depth reconstruction, bridge foundation, deep-depth pipe replacement, etc."]
["9.  Quality of Utility Record"]
["Quality of utility record indicates the reliability of existing records on buried utilities. The availability of accurate historical utility records for the project will be able to reduce the potential for accidentally hitting unexpected underground utilities. This factor is separated into three different categories: (1) good, (2) fair, and (3) poor. A poor quality of utility records requires higher quality levels of SUE."]
["Good","Very accurate record of utilities"]
["Fair","Not very good record of utilities"]
["Poor","Utilities information/data are not accurate"]
["10.  Estimated Business Impact"]
["Business impact is concerned with the income and property loss of local businesses resulting from accidents due to hitting unexpected buried utilities. At areas near or surrounding high business density, the quality level A of SUE is essential. User impact, access to business, and length of service interruption should also be taken into consideration."]
["Low","Very low business impact in the project area"]
["Moderate","Possibility of some business impact in the project area"]
["High","Great business impact in the project area"]
["11.  Estimated Environmental Impact"]
["Potential environmental problems caused by accidentally hitting an in-service utility, such as a gas explosion, oil spill, and/or water flooding, need to be assessed. Project areas with a high potential of environmental impact require a high quality level of SUE."]
["Low","Very low environmental impact in the project area"]
["Moderate","Possibility of some environmental impact in the project area"]
["High","Great environmental impact in the project area"]
["12.  Estimated Safety Impact"]
["Safety impact is concerned with possible injury to people caused by accidentally hitting an in-service utility. Projects located in densely populated areas require a high quality level of SUE to minimize the likelihood of such an impact."]
["Low","Very low safety impact in the project area"]
["Moderate","Possibility of some safety impact in the project area"]
["High","Great safety impact in the project area"]
["13.  Other Factors-Specify"]
["Projects having a high potential of other impact factors require a high quality level of SUE to avoid or reduce project risks, i.e., blasting of rocks, relocation of other utilities, etc."]
["Low","Very low impact in the project area"]
["Moderate","Possibility of some impact in the project area"]
["High","Greater impact in the project area"]

{"sheet":"Impact Summary","index":4,"n_rows":29,"n_cols":17,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,0,7],[0,8,0,15],[0,16,0,24],[1,0,1,7],[1,8,1,15],[1,16,1,24],[8,2,16,7],[17,0,17,1],[17,2,17,3],[17,4,17,5],[18,0,18,1],[18,2,18,3],[18,4,18,5],[2,0,2,1],[2,2,2,7],[3,0,3,1],[3,2,3,7],[21,10,21,15],[9,9,9,10],[10,9,10,10],[20,8,20,9],[20,10,20,11],[20,12,20,13],[4,0,7,1],[4,2,7,7],[18,8,18,15],[19,8,19,15],[8,9,8,14],[8,0,16,1],[23,0,23,7],[17,6,17,7],[24,8,24,10],[28,8,28,10],[28,11,28,15],[19,0,19,7],[25,8,25,10],[21,1,21,7],[18,6,18,7],[22,1,22,7],[26,8,26,15],[27,8,27,10],[27,11,27,15],[24,14,24,15],[25,14,25,15],[24,11,24,12],[18,16,28,24],[3,9,3,13],[4,9,7,14],[12,8,13,15],[14,8,17,15],[17,16,17,24],[10,11,10,14],[9,11,9,14],[2,16,3,24],[4,16,4,24],[5,16,16,24],[25,11,25,12],[22,8,22,15],[23,8,23,15],[20,14,20,15],[21,8,21,9]]}
["SUE UTILITY IMPACT REPORT",null,null,null,null,null,null,null,"SUE UTILITY IMPACT REPORT",null,null,null,null,null,null,null,"SUE UTILITY IMPACT REPORT"]
["Project Information",null,null,null,null,null,null,null,"Step 2 QL Recommendation and Selection",null,null,null,null,null,null,null,"Step 2-Selected SUE Quality Level Justification"]
["MPMS Number/Title: ",null,{"$f":"IF(ISBLANK('Step 1'!C4),\"\",'Step 1'!C4)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"-Include a justification of the SUE quality level selected.  Include a discussion of the reasons why a SUE quality level chosen is different that the SUE quality level recommended in the Step 2 analysis."]
["County/SR/Section:",null,{"$f":"IF(ISBLANK('Step 1'!C5),\"\",'Step 1'!C5)","v":""},null,null,null,null,null,null,"SELECTED SUE QUALITY LEVEL(S):"]
["Project Description:\n(General Summary)",null,{"$f":"IF(ISBLANK('Step 1'!C6),\"\",'Step 1'!C6)","v":""},null,null,null,null,null,null,"The Project Manager, along with the District Utility  Administrator, must work together to select the SUE Quality Level(s) intended for use on the project.  The Project Manager has the final decision to use or not to use SUE on a project. \n-The selection justification must be documented on the SUE Quality Level Justification.\n-Site specific areas may require re-evaluation of Step 2 to determine appropriate SUE Quality Level.",null,null,null,null,null,null,"QLB Selected Locations and/or Utilities and Justification"]
[]
[]
[]
["Project Scope:\n(Actual Work Scope\nNote: If the scope of the project changes, it is recommended that utility impact analysis be done again.)",null,{"$f":"IF(ISBLANK('Step 1'!C10),\"\",'Step 1'!C10)","v":""},null,null,null,null,null,null,"Utility Impact Score Results:"]
[null,null,null,null,null,null,null,null,null,"Utility Impact Score:",null,"Recommended Minimum SUE Quality Level:"]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR('Step 2'!B13,\"\")","v":""},null,{"$f":"IFERROR('Step 2'!D13,\"\")","v":""}]
[]
[null,null,null,null,null,null,null,null,"SUE Impact Location-Description & Scope:\n(blank for overall project level impact analysis)"]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK('Step 2'!C6),\"\",'Step 2'!C6)","v":""}]
[]
[]
["DUA Approval:",null,null,null,"Date:",null,null,null,null,null,null,null,null,null,null,null,"QLA Recommended Test Hole Locations and Justification"]
["Project Manager\n Approval:",null,null,null,"Date:",null,null,null,"Utility Impact Score Calculation Description"]
["Step 1 Summary",null,null,null,null,null,null,null,"This Table demonstrates the process for calculating the utility impact score based on response.\n*n = Number of the complexity factors considered/checked"]
["Step 1 Analysis Recommendation:",null,null,null,null,null,null,null,"1:  Total Box Checked",null,"Sum of Column 1",null,"Sum of Column 2",null,"Sum of Column 3"]
[{"$f":"IF('Step 1'!M23>=1, (IF(A23=\"\",\"X\",\"\")),\"\")","v":""},"Generally not practicable to perform a SUE QLA or QLB investigation.",null,null,null,null,null,null,"2: Utility Impact Score",null,"[(1 x Sum of Column 1) + (2 x Sum of Column 2) + (3 x Sum of Column 3)] / n*"]
[null,"Proceed to STEP 2 to calculate utility impact score and determine the appropriate SUE quality levels.",null,null,null,null,null,null,"Utility Impact Scoring Levels"]
[null,null,null,null,null,null,null,null,"All factors are based on the result utility impact score calculation. \n"]
[null,null,null,null,null,null,null,null,"Utility Impact Score",null,null,"1.01 – 1.67",null,"1.68– 2.33","2.34 – 3.00"]
[null,null,null,null,null,null,null,null,"Recommended Minimum SUE QL",null,null,"QLB",null,"QLB/A","QLA"]
[null,null,null,null,null,null,null,null,"Impact Level Descriptions:"]
[null,null,null,null,null,null,null,null,"Utility Impact Score",null,null,"Result of utility impact score calculation."]
[null,null,null,null,null,null,null,null,"Recommended Minimum \nSUE Quality Levels",null,null,"The minimum SUE quality level recommended by the step 2 analysis.\nThe ultimate SUE quality level selected for a project requires the judgement of the Project Manager."]