{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Screening Tool","Intersection_Interchange ","Translation","Formulas"],"not_rendered":{"charts":0,"images":40,"macros":1,"external_links":0,"defined_names":1,"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":"Screening Tool","index":0,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":false,"merged":[[19,5,19,6],[5,5,5,6],[11,5,11,6],[4,7,4,9],[14,5,14,6],[15,5,15,6],[16,5,16,6],[6,7,6,8]]}
[null,null,null,null,null,null,null,null,null,"last updated : 04/16/20     "]
[null,null,"Traffic Safety Unit Project Screening Tool"]
[]
[]
[null,"A","SIT Type",null,null,null,null," (Optional Project Inputs)"]
[null,"B","Primary Need Category",null,null,null,null," Project Local ID :"]
[]
[null,null,null,null,null,null,null,"  NOTE :"]
[null,"C","Existing Multimodal Features"]
[]
[]
[null,"D","Proposed Multimodal Features"]
[]
[]
[null,"E","Proposed Cross Section Type"]
[null,"F","Project Speed Limit"]
[null,"G","Intersection/Interchange"]
[]
[]
[null,"H","Project Access Control"]
[]
[null,"Screening Tool Results (Next Steps):",null,null,"   Project Conditions Justifying Further NCDOT Traffic Safety Unit Review:"]
[null,null,null,null," 1"]
[null,null,null,null," 2"]
[null,null,null,null," 3"]
[null,null,null,null," 4"]
[null,null,null,null," 5"]

{"sheet":"Intersection_Interchange ","index":1,"n_rows":37,"n_cols":3,"rows_kept":37,"cut":false,"hidden":false,"merged":[[5,2,31,2],[32,2,33,2],[34,2,35,2]]}
[]
[]
[]
[]
[null,"When Submitting:\n(Prioritization Reference)","Select the Following:\n(Analogous Traffic Safety Unit Project Screening Tool selection)"]
[null,"Diamond Interchange","Grade-Separated Intersection/Interchange"]
[null,"Diamond Interchange with 1 Loop"]
[null,"Diamond Interchange with 2 Loops"]
[null,"Tight Urban Diamond Interchange"]
[null,"Modern Roundabout Interchange"]
[null,"Split Diamond Interchange"]
[null,"Half Clover Interchange"]
[null,"Trumpet Interchange"]
[null,"Cloverleaf Interchange with 2 Collector-Distributors"]
[null,"Cloverleaf Interchange with 4 Collector-Distributors"]
[null,"Directional Interchange with 1 Flyover Ramp and 3 Loops"]
[null,"Directional Interchange with 1 Flyover Ramp and 3 Loops with 1 Collector-Distributor"]
[null,"Directional Interchange 1 Flyover Ramp and 3 Loops with 2 Collector-Distributors"]
[null,"Directional Interchange with 2 Flyover Ramps and 2 Loops – Example 1"]
[null,"Directional Interchange with 2 Flyover Ramps and 2 Loops – Example 2"]
[null,"Directional Interchange with 3 Flyover Ramps and 1 Loop"]
[null,"Directional Interchange with 4 Flyover Ramps"]
[null,"Turbine Interchange"]
[null,"Quadrant with Grade Separation"]
[null,"Main Line over Cross Street (Grade Separation)"]
[null,"Main Line over Railroad (Grade Separation)"]
[null,"Cross Street over Main Line (Grade Separation)"]
[null,"Railroad over Mainline (Grade Separation)"]
[null,"Add 1 Flyover to an At-grade Intersection"]
[null,"Add 1 Flyover (1 Lane) and High-Speed Ramp to an At-grade Intersection"]
[null,"Single Point Urban Interchange (SPUI)"]
[null,"Diverging Diamond Interchange (DDI)"]
[null,"1 Lane Roundabout","Roundabout"]
[null,"2 Lane Roundabout"]
[null,"Directional Crossover with 1-Lane Bulb Outs (Superstreet)","Directional Crossover (Reduced-Conflict Intersection)"]
[null,"Directional CrossOver with 2-Lane Bulb Outs with Signals (Superstreet)"]
[null,"At-grade Quadrant (1 quadrant)","At-Grade Quadrant"]

{"sheet":"Translation","index":2,"n_rows":59,"n_cols":18,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[null,{"$f":"VLOOKUP(A1,A3:B28,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(A1,A3:C28,3,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(D1,D3:E9,2,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(F1,F3:G11,2,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(H1,H3:I11,2,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(J1,J3:K59,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(J1,J3:L59,3,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(M1,M3:N5,2,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(O1,O3:P8,2,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP(Q1,Q3:R6,2,FALSE)","v":{"$error":"#N/A"}}]
["SIT Type","Project Type","SPOT Project Type","Identified Needs","Proposed Identified Need","Existing Multimodal Features","Existing Bike/Ped/Transit","Proposed Multimodal Features","Proposed Bike/Ped/Transit","Proposed Cross Section Type","Proposed Facility Laneage","Proposed Median","Project Speed Limit","Proposed Speed","Intersection/Interchange","Proposed Intersection Types","Project Access Control","Proposed Control of Access"]
["1 – Widen Existing Roadway","Upgrade Existing","Other","System Linkage/Connectivity","Other","None","No","None","No","2A – 2 Lane Undivided with Paved Shoulders, 55 mph","Single","No","0-35mph","Low","Grade-Separated Intersection/Interchange","Median(Not Full movement)","Full","Full"]
["2 – Upgrade Arterial to Freeway/Expressway","Upgrade Existing","Other","Capacity/Congestion","Other","Sidewalks","Yes","Sidewalks","Yes","2B – 2 Lane Undivided with Paved Shoulders, 25-45 mph","Single","No","36-45mph","Medium/High","Roundabout","Median(Not Full movement)","Limited","Partial/Limited"]
["3 – Upgrade Expressway to Freeway","Upgrade Existing","Other","Modal Interrelationships","Other","Pedestrian Crossings","Yes","Pedestrian Crossings","Yes","2C – 2 Lane Undivided with Paved Shoulders, 25-35 mph","Single","No","Over 45mph","Medium/High","Directional Crossover","Median(Not Full movement)","Partial","Partial/Limited"]
["4 – Upgrade Arterial to Superstreet","Upgrade Existing","Other","Safety","Safety","Striped Bicycle Lanes","Yes","Striped Bicycle Lanes","Yes","2D – 2 Lane Undivided with Paved Shoulders and Sidewalks, 25-45 mph","Single","No",null,null,"At-Grade Quadrant","Median(Not Full movement)","None","None"]
["5 – Construct Roadway on New Location","New Location","Other","Facility Deficiencies","Other","Sidepaths/ Multi-Use Paths","Yes","Sidepaths/ Multi-Use Paths","Yes","2E – 2 Lane Undivided with Curb & Gutter, Bike Lanes, and Sidewalks, 25-45 mph","Single","No",null,null,"Other At-Grade Intersection","Full Movement"]
["6 – Widen Existing Roadway and Construct Part on New Location","New Location","Other","Mobility","Other","Wide Outside Lanes","Yes","Wide Outside Lanes","Yes","2F – 2 Lane Undivided with Paved Shoulders and Sidewalks in CAMA Counties, 25-45 mph","Single","No",null,null,"Median","Median"]
["7 – Upgrade At-grade Intersection to Interchange or Grade Separation","Upgrade Existing","Other","Other","Other","Paved Shoulders","Yes","Paved Shoulders","Yes","2G – 2 Lane Undivided with Curb & Gutter, Parking Both Sides, Bike Lanes, and Sidewalks, 25-45 mph","Single","No"]
["8 – Improve Interchange","Upgrade Existing","Other",null,null,"Fixed Transit Routes","Yes","Fixed Transit Routes","Yes","2H – 2 Lane Undivided with Curb & Gutter, Parking One Side, Bike Lanes, and Sidewalks, 25-45 mph","Single","No"]
["9 – Convert Grade Separation to Interchange","Upgrade Existing","Other",null,null,"Yes","Yes","Yes","Yes","2I – 2 Lane Divided (23' Raised Median) with Curb & Gutter and Sidewalks, 25-45 mph","Single","Yes"]
["10 – Improve Intersection","Upgrade Existing","Other",null,null,null,null,null,null,"2J – 2 Lane Divided (23' Raised Median) with Curb & Gutter, Bike Lanes, and Sidewalks, 25-45 mph","Single","Yes"]
["11 – Access Management","Upgrade Existing","Access Mgmt",null,null,null,null,null,null,"2K – 2 Lane Divided (17'-6\" ft Raised Median) with Curb & Gutter and Sidewalks, 25-45 mph","Single","Yes"]
["12 – Ramp Metering","Upgrade Existing","Other",null,null,null,null,null,null,"2L – 2 Lane Divided (17'-6\" Raised Median) with Curb & Gutter, Bike Lanes, and Sidewalks, 25-45 mph","Single","Yes"]
["13 – Citywide Signal System","Upgrade Existing","Other",null,null,null,null,null,null,"2M – 2 Lane Undivided with Paved Shoulders, and Sidepath, 55 mph","Single","No"]
["14 – Closed Loop Signal System","Upgrade Existing","Other",null,null,null,null,null,null,"2N – 2 Lane Undivided with Paved Shoulders, and Sidepath, 25-45 mph","Single","No"]
["15 – Install Cameras and DMS","Upgrade Existing","Other",null,null,null,null,null,null,"2O – 2 Lane Undivided with Paved Shoulders, and Sidepath, 25-35 mph","Single","No"]
["16 – Modernize Roadway","Upgrade Existing","Modernization",null,null,null,null,null,null,"2P – 2 Lane Undivided with Paved Shoulders, Sidewalk, and Sidepath in CAMA Counties, 25-45 mph","Single","No"]
["17 – Upgrade Freeway to Interstate Standards","Upgrade Existing","Modernization",null,null,null,null,null,null,"2Q – 2 Lane Divided (23' Raised Median) with Curb & Gutter, Sidewalk, and Sidepath, 25-45 mph","Single","Yes"]
["18 – Widen Existing or Construct New Local (Non-State) Roadway","New Location","Other",null,null,null,null,null,null,"2R – 2 Lane Divided (17'-6\" ft Raised Median) with Curb & Gutter, and Sidewalk, and Sidepath, 25-45 mph","Single","Yes"]
["19 – Improve Intersection on Local (Non-State) Roadway","Upgrade Existing","Other",null,null,null,null,null,null,"3A – 2 Lane with Two Way Left Turn Lane, and Paved Shoulders, 25-55 mph.","Multi","No"]
["20 – Convert Grade Separation to Interchange to Relieve Existing Congested Interchange","Upgrade Existing","Other",null,null,null,null,null,null,"3B – 2 Lane with Two Way Left Turn Lane, Curb & Gutter, and Sidewalks, 25-45 mph","Multi","No"]
["21 – Realign Multiple Intersections","Upgrade Existing","Other",null,null,null,null,null,null,"3C – 2 Lane with Two Way Left Turn Lane, Curb & Gutter, Bike Lanes, and Sidewalks, 25-45 mph","Multi","No"]
["22 – Construct Auxiliary Lanes or Other Operational Improvements","Upgrade Existing","Other",null,null,null,null,null,null,"3D – 2 Lane with Two Way Left Turn Lane, Paved Shoulders and Sidepath, 25-55 mph","Multi","No"]
["23 – Improve Highway / Railroad Crossing","Upgrade Existing","Other",null,null,null,null,null,null,"3E – 2 Lane with Two Way Left Turn Lane, Curb & Gutter, Sidewalk,and Sidepath, 25-45 mph","Multi","No"]
["24 – Implement Road Diet to Improve Safety","Upgrade Existing","Road Diet",null,null,null,null,null,null,"4A - 4 Lane Divided (46' Depressed Median) with Paved Shoulders, 45-70 mph","Multi","Yes"]
["25 –Improve Multiple Intersections along Corridor","Upgrade Existing","Other",null,null,null,null,null,null,"4B – 4 Lane Divided (23' Raised Median) with Paved Shoulders and Sidewalks, 35-55 mph","Multi","Yes"]
["26 – Upgrade Roadway","Upgrade Existing","Other",null,null,null,null,null,null,"4C – 4 Lane Divided (23' Raised Median) with Curb & Gutter, and Sidewalks, 35-45 mph","Multi","Yes"]
[null,null,null,null,null,null,null,null,null,"4D – 4 Lane Divided (23' Raised Median) with Curb & Gutter, Bike Lanes, and Sidewalks, 35-45mph","Multi","Yes"]
[null,null,null,null,null,null,null,null,null,"4E – 4 Lane Divided (17'-6\" Raised Median) with Paved Shoulders and Sidewalks, 35-55 mph","Multi","Yes"]
[null,null,null,null,null,null,null,null,null,"4F – 4 Lane Divided (17'-6\" Raised Median) with Curb & Gutter, and Sidewalks, 35-45 mph","Multi","Yes"]
[null,null,null,null,null,null,null,null,null,"4G – 4 Lane Divided (17'-6\" Raised Median) with Curb & Gutter, Bike Lanes, and Sidewalks, 35-45mph","Multi","Yes"]
[null,null,null,null,null,null,null,null,null,"4H – 4 Lane Divided (46' Depressed Median) with Paved Shoulders, and Sidepath, 45-55 mph","Multi","Yes"]
[null,null,null,null,null,null,null,null,null,"4I – 4 Lane Divided (23' Raised Median) with Paved Shoulders, and Sidepath, 35-55 mph","Multi","Yes"]
[null,null,null,null,null,null,null,null,null,"4J – 4 Lane Divided (23' Raised Median) with Curb & Gutter, Sidewalk and Sidepath, 35-45 mph","Multi","Yes"]
[null,null,null,null,null,null,null,null,null,"4K – 4 Lane Divided (17'-6\" Raised Median) with Paved Shoulders, and Sidepath, 35-55 mph","Multi","Yes"]
[null,null,null,null,null,null,null,null,null,"4L – 4 Lane Divided (17'-6\" Raised Median) with Curb & Gutter, Sidewalk, and Sidepath, 35-45 mph","Multi","Yes"]
[null,null,null,null,null,null,null,null,null,"5A – 4 Lane with Two Way Left Turn Lane, Curb & Gutter, and Sidewalks, 35-45 mph","Multi","No"]
[null,null,null,null,null,null,null,null,null,"5B – 4 Lane with Two Way Left Turn Lane, Curb & Gutter, Sidewalk, and Sidepath, 35-45 mph","Multi","No"]
[null,null,null,null,null,null,null,null,null,"6A – 6 Lane Divided (46' Depressed Median) with Paved Shoulders, 45-70 mph","Multi","Yes"]
[null,null,null,null,null,null,null,null,null,"6B – 6 Lane Divided (27' Median with Jersey Barrier with Paved Shoulders, 55-70mph","Multi","Yes"]
[null,null,null,null,null,null,null,null,null,"6C – 6 Lane Freeway (27' Median with Jersey Barrier) with Paved Shoulders and 2 Lane One-Way Service Roads each side, 55-70mph","Multi","Yes"]
[null,null,null,null,null,null,null,null,null,"6D – 6 Lane Freeway (4 General Purpose Lanes, 2 Managed Lanes, and 27' Median with Jersey Barrier) with Paved Shoulders, 55-70mph","Multi","Yes"]
[null,null,null,null,null,null,null,null,null,"6E – 6 Lane Divided (23' Raised Median) with Curb & Gutter, and Sidewalks, 35-45 mph","Multi","Yes"]
[null,null,null,null,null,null,null,null,null,"6F – 6 Lane Divided (17'-6\" Raised Median) with Curb & Gutter, and Sidewalks, 35-45 mph","Multi","Yes"]
[null,null,null,null,null,null,null,null,null,"6G – 6 Lane Divided (46' Depressed Median) with Paved Shoulders, and Sidepath, 45-55 mph","Multi","Yes"]
[null,null,null,null,null,null,null,null,null,"6H – 6 Lane Divided (23' Raised Median) with Curb & Gutter, Sidewalk, and Sidepath, 35-45 mph","Multi","Yes"]
[null,null,null,null,null,null,null,null,null,"6I – 6 Lane Divided (17'-6\" Raised Median) with Curb & Gutter, Sidewalk, and Sidepath, 35-45 mph","Multi","Yes"]
[null,null,null,null,null,null,null,null,null,"8A – 8 Lane Divided (46' Depressed Median) with Paved Shoulders, 45-70 mph","Multi","Yes"]
[null,null,null,null,null,null,null,null,null,"8B – 8 Lane Divided (27' Median with Jersey Barrier) with Paved Shoulders, 55-70mph","Multi","Yes"]
[null,null,null,null,null,null,null,null,null,"8C – 8 Lane Freeway (27' Median with Jersey Barrier) with Paved Shoulders and 2 Lane One-Way Service Roads each side, 55-70mph","Multi","Yes"]
[null,null,null,null,null,null,null,null,null,"8D – 8 Lane Freeway (6 General Purpose Lanes, 2 Managed Lanes, and 27' Median with Jersey Barrier) with Paved Shoulders, 55-70mph","Multi","Yes"]
[null,null,null,null,null,null,null,null,null,"8E – 8 Lane Freeway (4 General Purpose Lanes, 4 Managed Lanes, and 27' Median with Jersey Barrier) with Paved Shoulders, 55-70mph","Multi","Yes"]
[null,null,null,null,null,null,null,null,null,"8F – 8 Lane Divided (23' Raised Median) with Curb & Gutter, and Sidewalks, 35-45 mph","Multi","Yes"]
[null,null,null,null,null,null,null,null,null,"8G – 6 Lane Divided (17'-6\" Raised Median) with Curb & Gutter, and Sidewalks, 35-45 mph","Multi","Yes"]
[null,null,null,null,null,null,null,null,null,"10A – 10 Lane Divided (27' Median with Jersey Barrier with Paved Shoulders, 55-70mph","Multi","Yes"]
[null,null,null,null,null,null,null,null,null,"10B – 10 Lane Freeway (8 General Purpose Lanes, 2 Managed Lanes, and 27' Median with Jersey Barrier) with Paved Shoulders, 55-70mph","Multi","Yes"]
[null,null,null,null,null,null,null,null,null,"10C – 10 Lane Freeway (6 General Purpose Lanes, 4 Managed Lanes, and 27' Median with Jersey Barrier) with Paved Shoulders, 55-70mph","Multi","Yes"]
[null,null,null,null,null,null,null,null,null,"12A – 12 Lane Freeway (8 General Purpose Lanes, 4 Managed Lanes, and 27' Median with Jersey Barrier) with Paved Shoulders, 55-70mph","Multi","Yes"]

{"sheet":"Formulas","index":3,"n_rows":24,"n_cols":16,"rows_kept":24,"cut":false,"hidden":false,"merged":[[10,5,10,13]]}
["Dataset Attributes"]
["Project Type","SPOT Project Type","Proposed Identified Need","Existing Bike/Ped/Transit Accommodation","Proposed Bike/Ped/Transit Accommodation","Proposed Facility Laneage","Proposed Median","Proposed Speed","Proposed Intersection Types","Proposed Control of Access"]
["New Location","Access Mgmt","Safety","Yes","Yes","Single","Yes","Low","Full Movement","None"]
["Upgrade Existing","Modernization","Other","No","No","Multi","No","Medium/High","Median","Partial/Limited"]
[null,"Road Diet",null,null,null,null,null,null,null,"Full"]
[null,"Other"]
["Current Selection"]
[{"$f":"Translation!B1","v":{"$error":"#N/A"}},{"$f":"Translation!C1","v":{"$error":"#N/A"}},{"$f":"Translation!E1","v":{"$error":"#N/A"}},{"$f":"Translation!G1","v":{"$error":"#N/A"}},{"$f":"Translation!I1","v":{"$error":"#N/A"}},{"$f":"Translation!K1","v":{"$error":"#N/A"}},{"$f":"Translation!L1","v":{"$error":"#N/A"}},{"$f":"Translation!N1","v":{"$error":"#N/A"}},{"$f":"Translation!P1","v":{"$error":"#N/A"}},{"$f":"Translation!R1","v":{"$error":"#N/A"}}]
[]
["Conditions"]
["Formula","Green (good to go)","Red (contact TSU)",null,null,"Condition Description"]
["F1; unless (B1, B2, B3 or C1)",{"$f":"IF(AND(F8=F3,B8=B6,C8<>C3),\"X\",\"\")","v":{"$error":"#N/A"}},null,null,{"$f":"IFERROR(INDEX($D$12:$D$23,_xlfn.AGGREGATE(15,6,(ROW($D$12:$D$23)-11)/($D$12:$D$23<>\"\"),ROWS(D$12:D12))),\"\")","v":""},"All two-lane cross sections are exempt from further Traffic Safety Unit review at this point in project development (excepting ‘Modernization’,'Access Mgmt', and 'Road Diet' projects and projects with an anticipated “Safety” purpose & need)."]
["J3; unless C1",{"$f":"IF(AND(J8=J5,C8<>C3),\"X\",\"\")","v":{"$error":"#N/A"}},null,null,{"$f":"IFERROR(INDEX($D$12:$D$23,_xlfn.AGGREGATE(15,6,(ROW($D$12:$D$23)-11)/($D$12:$D$23<>\"\"),ROWS(D$12:D13))),\"\")","v":""},"All projects with full control of access are exempt from further Traffic Safety Unit review at this point in project development (excepting projects with an anticipated “Safety” purpose & need)."]
["H1; unless C1",{"$f":"IF(AND(H8=H3,C8<>C3),\"X\",\"\")","v":{"$error":"#N/A"}},null,null,{"$f":"IFERROR(INDEX($D$12:$D$23,_xlfn.AGGREGATE(15,6,(ROW($D$12:$D$23)-11)/($D$12:$D$23<>\"\"),ROWS(D$12:D14))),\"\")","v":""},"All low speed projects are exempt from further Traffic Safety Unit review at this point in project development (excepting projects with an anticipated “Safety” purpose & need). "]
["J2; unless [B1, B2, B3, C1 or {(D1 or E1) + H2}]",{"$f":"IF(J8=J4, IF(OR(B8<>B6,C8=C3,AND(H8=H4,OR(D8=D3,E8=E3))),\"\",\"X\"),\"\")","v":{"$error":"#N/A"}},null,null,{"$f":"IFERROR(INDEX($D$12:$D$23,_xlfn.AGGREGATE(15,6,(ROW($D$12:$D$23)-11)/($D$12:$D$23<>\"\"),ROWS(D$12:D15))),\"\")","v":""},"Partial/limited control of access projects are exempt from further Traffic Safety Unit review at this point in project development (excepting ‘Modernization’,'Access Mgmt', and 'Road Diet' projects and projects with existing or proposed multimodal elements when they are also medium or high speed roadways and projects with an anticipated “Safety” purpose & need)."]
["A1 + C1",null,{"$f":"IF(AND(A8=A3,C8=C3),\"X\",\"\")","v":{"$error":"#N/A"}},{"$f":"IF(C16=\"X\",F16,\"\")","v":{"$error":"#N/A"}},{"$f":"IFERROR(INDEX($D$12:$D$23,_xlfn.AGGREGATE(15,6,(ROW($D$12:$D$23)-11)/($D$12:$D$23<>\"\"),ROWS(D$12:D16))),\"\")","v":""},"All projects with an anticipated purpose & need of ‘Safety’ require further Traffic Safety Unit review. "]
["A1 + H2 + J1",null,{"$f":"IF(AND(A8=A3,H8=H4,J8=J3),\"X\",\"\")","v":{"$error":"#N/A"}},{"$f":"IF(C17=\"X\",F17,\"\")","v":{"$error":"#N/A"}},{"$f":"IFERROR(INDEX($D$12:$D$23,_xlfn.AGGREGATE(15,6,(ROW($D$12:$D$23)-11)/($D$12:$D$23<>\"\"),ROWS(D$12:D17))),\"\")","v":""},"All new location projects with no proposed control of access require further Traffic Safety Unit review (excepting low speed projects). "]
["A1 + E1",null,{"$f":"IF(AND(A8=A3,E8=E3),\"X\",\"\")","v":{"$error":"#N/A"}},{"$f":"IF(C18=\"X\",F18,\"\")","v":{"$error":"#N/A"}},{"$f":"IFERROR(INDEX($D$12:$D$23,_xlfn.AGGREGATE(15,6,(ROW($D$12:$D$23)-11)/($D$12:$D$23<>\"\"),ROWS(D$12:D18))),\"\")","v":""},"All projects with existing or proposed multimodal elements require further Traffic Safety Unit review. "]
["A2 + (B1 or B2 or B3)",null,{"$f":"IF(AND(A8=A4,OR(B8=B3,B8=B4,B8=B5)),\"X\",\"\")","v":{"$error":"#N/A"}},{"$f":"IF(C19=\"X\",IF(B8=B3,F19,IF(B8=B4,O19,IF(B8=B5,P19,\"\"))),\"\")","v":{"$error":"#N/A"}},{"$f":"IFERROR(INDEX($D$12:$D$23,_xlfn.AGGREGATE(15,6,(ROW($D$12:$D$23)-11)/($D$12:$D$23<>\"\"),ROWS(D$12:D19))),\"\")","v":""},"All ‘Access Management’ projects require further Traffic Safety Unit review.",null,null,null,null,null,null,null,null,"All ‘Modernization’ projects require further Traffic Safety Unit review.","All ‘Road Diet’ projects require further Traffic Safety Unit review."]
["A2 + C1",null,{"$f":"IF(AND(A8=A4,C8=C3),\"X\",\"\")","v":{"$error":"#N/A"}},{"$f":"IF(C20=\"X\",F20,\"\")","v":{"$error":"#N/A"}},{"$f":"IFERROR(INDEX($D$12:$D$23,_xlfn.AGGREGATE(15,6,(ROW($D$12:$D$23)-11)/($D$12:$D$23<>\"\"),ROWS(D$12:D20))),\"\")","v":""},"All projects with an anticipated “Safety” purpose & need require further Traffic Safety Unit review."]
["A2 + H2 + I1",null,{"$f":"IF(AND(A8=A4,H8=H4,I8=I3),\"X\",\"\")","v":{"$error":"#N/A"}},{"$f":"IF(C21=\"X\",F21,\"\")","v":{"$error":"#N/A"}},{"$f":"IFERROR(INDEX($D$12:$D$23,_xlfn.AGGREGATE(15,6,(ROW($D$12:$D$23)-11)/($D$12:$D$23<>\"\"),ROWS(D$12:D21))),\"\")","v":""},"All projects with full movement intersections require further Traffic Safety Unit review."]
["A2 + (D1 or E1)",null,{"$f":"IF(AND(A8=A4,OR(D8=D3,E8=E3)),\"X\",\"\")","v":{"$error":"#N/A"}},{"$f":"IF(C22=\"X\",F22,\"\")","v":{"$error":"#N/A"}},{"$f":"IFERROR(INDEX($D$12:$D$23,_xlfn.AGGREGATE(15,6,(ROW($D$12:$D$23)-11)/($D$12:$D$23<>\"\"),ROWS(D$12:D22))),\"\")","v":""},"All projects with existing or proposed multimodal elements require further Traffic Safety Unit review."]
["A2 + F2 + G2",null,{"$f":"IF(AND(A8=A4,F8=F4,G8=G4),\"X\",\"\")","v":{"$error":"#N/A"}},{"$f":"IF(C23=\"X\",F23,\"\")","v":{"$error":"#N/A"}},{"$f":"IFERROR(INDEX($D$12:$D$23,_xlfn.AGGREGATE(15,6,(ROW($D$12:$D$23)-11)/($D$12:$D$23<>\"\"),ROWS(D$12:D23))),\"\")","v":""},"Multilane projects require further Traffic Safety Unit review when there are no proposed medians. "]
["Condition Result",{"$f":"IF(OR(B12=\"X\",B13=\"X\",B14=\"X\",B15=\"X\"),\"Green\",\"\")","v":{"$error":"#N/A"}},{"$f":"IF(OR(C16=\"X\",C17=\"X\",C18=\"X\",C19=\"X\",C20=\"X\",C21=\"X\",C22=\"X\",C23=\"X\"),\"Red\",\"\")","v":{"$error":"#N/A"}},{"$f":"IF(B24=\"Green\",\"Green\",IF(C24=\"Red\",\"Red\",\"Red\"))","v":{"$error":"#N/A"}}]