{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Introduction","Dictionary","Scenario 1","Scenario 2","Scenario 3","Results"],"not_rendered":{"charts":9,"images":40,"macros":1,"external_links":4,"defined_names":517,"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":"Introduction","index":0,"n_rows":20,"n_cols":14,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,17],[1,0,1,17],[13,0,13,17],[17,2,18,17],[2,0,11,17]]}
["20 Flags Calculator Tool"]
["Instructions"]
["Copy a new Scenario tab for each scenario, such as alternatives assessment or design stage evaluation.  For each tab, suitably name the tab and the title in Row A, fill out the description and intersection data at the top of the tab, and then proceed through each flag in order. Fill in all applicable yellow cells. Blue cells are calculated and grey cells are not applicable. Recommended reference materials included: \n- the 20 Flags Intersection Evaluation Guide, particularly\n      - the Flag Factsheets found in Appendix B of that document (excerpts included in the spreadsheet tool) \n      - the Detailed Use Case guidance as applicable\n- the flag prioritization determined in Step 1\n- the data and intersection imagery/design assembled in Step 2\n- the pedestrian paths and bicycle movements completed in Step 3\n\n A summary table at the top of the sheet provides a total of the flags."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Yellow",null,"Yellow Flag: The flag is applicable and was evaluated and meets yellow flag threshold but not the red flag threshold"]
["Red",null,"Red Flag: The flag is applicable and was evaluated and meets the red flag threshold"]
["No",null,"No Flag: The flag is applicable and was evaluated, but did not meet the yellow or red flag thresholds"]
["N/A",null,"N/A: The flag cannot be applied due to factors including specific flag guidance for the study configuration, no applicable path/movement (e.g., a three-legged intersection), and bicycle flags when bicycles have been deemed to use a multiuse path."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Prepared for TDOT by Kittelson & Associates, Inc., August 2025"]

{"sheet":"Dictionary","index":1,"n_rows":7,"n_cols":18,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
[null,"Intersection List",null,"Yes or No",null,"Flags",null,"Crossing Traffic Control",null,"Left Turn",null,"RT Bicycles",null,"Vehicle Movement",null,"MV Lane Configuration",null,"On-sreet bicycle facility"]
[null,null,null,null,null,"Yellow"]
[null,"Traffic Signal",null,"No",null,"Red",null,"Signalized",null,"Protected",null,"Exclusive Turn Lane",null,"Crossing with Major",null,"Lanes are parallel or diverge",null,"None"]
[null,"2X2",null,"Yes",null,"No Flag",null,"Beacon",null,"Permissive",null,"Shared Thru-Right Lane",null,"Crossing with Minor",null,"Lanes merge",null,"Shared Markings"]
[null,"3X3",null,null,null,"N/A",null,"Unsignalized",null,null,null,"Right Turn are not permitted",null,null,null,null,null,"Bike Lane"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Buffered Bike Lane"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Seperated Bike Lane / Off-street"]

{"sheet":"Scenario 1","index":2,"n_rows":404,"n_cols":26,"rows_kept":404,"cut":false,"hidden":false,"merged":[[100,7,100,9],[34,3,34,4],[34,6,34,7],[34,9,34,10],[221,7,221,9],[401,7,401,9],[367,14,369,25],[399,10,399,13],[399,14,399,25],[365,14,365,25],[385,14,385,25],[353,7,353,9],[388,7,388,9],[385,10,385,13],[178,7,178,9],[173,7,173,9],[219,7,220,9],[319,14,319,25],[321,14,324,25],[114,10,114,13],[201,10,201,13],[132,7,132,9],[148,7,148,9],[166,2,179,6],[399,0,400,1],[256,10,256,13],[256,14,256,25],[261,7,261,9],[262,7,262,9],[259,7,259,9],[260,7,260,9],[256,7,257,9],[290,7,290,9],[281,7,281,9],[263,7,263,9],[279,7,280,9],[279,10,279,13],[279,14,279,25],[282,7,282,9],[283,7,283,9],[284,7,284,9],[285,7,285,9],[399,2,412,6],[365,10,365,13],[365,7,366,9],[319,10,319,13],[319,7,320,9],[387,7,387,9],[319,0,320,1],[320,2,331,6],[321,7,321,9],[322,7,322,9],[323,7,323,9],[324,7,324,9],[325,7,325,9],[336,0,337,1],[384,0,385,1],[384,2,394,6],[369,7,369,9],[370,7,370,9],[385,7,386,9],[402,7,402,9],[403,7,403,9],[356,7,356,9],[367,7,367,9],[114,14,114,25],[116,7,116,9],[117,7,117,9],[336,10,336,13],[336,14,336,25],[338,7,338,9],[340,7,340,9],[339,7,339,9],[225,7,225,9],[171,7,171,9],[174,7,174,9],[175,7,175,9],[172,7,172,9],[176,7,176,9],[177,7,177,9],[166,7,167,9],[166,10,166,13],[166,14,166,25],[170,7,170,9],[351,14,351,25],[185,7,185,9],[299,2,315,6],[183,0,184,1],[183,2,197,6],[201,0,202,1],[201,2,215,6],[235,0,236,1],[235,2,249,6],[238,7,238,9],[239,7,239,9],[240,7,240,9],[241,7,241,9],[243,7,243,9],[242,7,242,9],[244,7,244,9],[245,7,245,9],[201,7,202,9],[354,7,354,9],[355,7,355,9],[351,2,361,6],[299,7,300,9],[286,7,286,9],[287,7,287,9],[288,7,288,9],[351,7,352,9],[336,7,337,9],[279,2,293,6],[98,7,99,9],[256,0,257,1],[156,7,156,9],[366,2,379,6],[368,7,368,9],[337,2,347,6],[51,1,54,2],[98,0,99,1],[114,0,115,1],[114,2,125,6],[114,7,115,9],[72,7,72,9],[70,7,70,9],[71,7,71,9],[118,7,118,9],[59,7,60,8],[149,7,149,9],[169,7,169,9],[365,0,366,1],[219,0,220,1],[168,7,168,9],[222,7,222,9],[206,7,206,9],[235,7,236,9],[8,7,8,18],[61,1,62,2],[55,3,56,4],[59,1,60,2],[57,3,58,4],[57,1,58,2],[55,1,56,2],[61,7,62,8],[59,3,60,4],[61,3,62,4],[53,5,54,6],[55,5,56,6],[57,5,58,6],[59,5,60,6],[61,5,62,6],[53,3,54,4],[53,7,54,8],[57,7,58,8],[61,9,62,10],[49,1,50,2],[53,9,54,10],[55,7,56,8],[61,11,62,12],[69,14,71,25],[72,10,73,13],[67,7,68,9],[81,0,82,1],[81,2,93,6],[81,7,82,9],[81,10,81,13],[81,14,81,25],[83,7,83,9],[83,14,83,16],[83,17,83,19],[83,20,83,22],[83,23,83,25],[84,7,84,9],[67,2,77,6],[67,10,67,13],[67,14,67,25],[69,7,69,9],[86,7,86,9],[85,10,85,13],[84,14,84,25],[73,7,73,9],[74,7,74,9],[85,7,85,9],[55,9,56,10],[57,9,58,10],[59,9,60,10],[51,11,54,12],[55,11,56,12],[57,11,58,12],[59,11,60,12],[49,3,50,10],[51,3,52,10],[49,11,50,12],[130,7,131,9],[130,10,130,13],[130,14,130,25],[133,7,133,9],[134,7,134,9],[183,10,183,13],[183,14,183,25],[157,7,157,9],[146,0,147,1],[150,7,150,9],[151,7,151,9],[152,7,152,9],[153,7,153,9],[154,7,154,9],[155,7,155,9],[183,7,184,9],[166,0,167,1],[203,14,203,25],[185,10,186,13],[186,7,186,9],[146,14,146,25],[301,7,301,9],[146,10,146,13],[146,7,147,9],[351,0,352,1],[341,7,341,9],[219,14,219,25],[227,7,227,9],[228,7,228,9],[229,7,229,9],[230,7,230,9],[235,10,235,13],[235,14,235,25],[223,7,223,9],[219,10,219,13],[224,7,224,9],[226,7,226,9],[279,0,280,1],[351,10,351,13],[299,0,300,1],[187,7,187,9],[399,7,400,9],[8,1,9,1],[8,2,9,2],[237,7,237,9],[258,7,258,9],[289,7,289,9],[299,10,299,13],[299,14,299,25],[302,7,302,9],[303,7,303,9],[98,10,98,13],[98,14,98,25],[101,7,101,9],[102,7,102,9],[103,7,103,9],[104,7,104,9],[105,7,105,9],[106,7,106,9],[107,7,107,9],[201,14,201,25],[203,7,203,9],[205,7,205,9],[204,7,204,9],[204,10,205,13],[2,2,2,6],[3,2,3,6],[4,2,4,6],[5,2,5,6],[6,2,6,6],[67,0,68,1],[146,2,162,6],[219,2,231,6],[256,2,274,6],[130,0,131,1],[130,2,142,6],[8,3,8,6],[98,2,110,6]]}
[null,"Scenario 1"]
[]
[null,"Intersection ID"]
[null,"Intersection Name"]
[null,"Date"]
[null,"Analyst"]
[null,"Scenario"]
[]
[null,"Flag","Flag Type","Pedestrian Assessment",null,null,null,"Bicycle Assessment"]
[null,null,null,"West","East","North","South","NBL","NBT","NBR","SBL","SBT","SBR","EBL","EBT","EBR","WBL","WBT","WBR"]
[null,"A: Undefined Crossing at Intersections","Primary",{"$f":"K75","v":"No"},"No","No","No","N/A","No","N/A","N/A","No","N/A","N/A","No","N/A","N/A","No","N/A"]
[null,"B: Multilane Crossing","Primary",{"$f":"K87","v":"No"},"No","No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[null,"C: Long Red Times","Secondary",{"$f":"K108","v":"No"},"No","No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[null,"D: Bicycle Clearance Times","Secondary",{"$f":"K119","v":"N/A"},{"$f":"L119","v":"N/A"},"N/A","N/A","No","No","N/A","No","No","N/A","No","No","N/A","No","No","N/A"]
[null,"E: Sight Distance for Gap Acceptance Movements","Secondary",{"$f":"K135","v":"No"},"No","No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[null,"F: Motor Vehicle Right Turns","Primary",{"$f":"K158","v":"No"},"No","No","No","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[null,"G: Motor Vehicle Left Turns","Primary",{"$f":"K179","v":"No"},"No","No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[null,"H: Turning Motorists Crossing Bike Path","Primary",{"$f":"K188","v":"N/A"},{"$f":"L188","v":"N/A"},{"$f":"M188","v":"N/A"},{"$f":"N188","v":"N/A"},{"$f":"O188","v":"No"},"No","No","No","No","No","No","No","No","No","No","No"]
[null,"I: Intersecting Driveways and Side Streets","Secondary",{"$f":"K207","v":"No"},{"$f":"L207","v":"No"},"No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[null,"J: Crossing Yield-Controlled or Uncontrolled Vehicle Paths ","Primary",{"$f":"K231","v":"No"},"No","No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[null,"K: Lane Change Across Motor Vehicle Lanes","Primary",{"$f":"K246","v":"N/A"},"N/A","N/A","N/A","No","No","No","No","No","No","No","No","No","No","No","No"]
[null,"L: Channelized Lanes","Primary",{"$f":"K264","v":"N/A"},"N/A","N/A","N/A","No","No","No","No","No","No","No","No","No","No","No","No"]
[null,"M: Riding in Shared Lanes","Primary",{"$f":"K291","v":"N/A"},{"$f":"L291","v":"N/A"},{"$f":"M291","v":"N/A"},{"$f":"N291","v":"N/A"},{"$f":"O291","v":"No"},{"$f":"P291","v":"No"},"No","No","No","No","No","No","No","No","No","No"]
[null,"N: Riding Between Travel Lanes, Lane Additions, or Lane Merges  ","Primary",{"$f":"K304","v":"N/A"},"N/A","N/A","N/A","No","No","No","No","No","No","No","No","No","No","No","No"]
[null,"O: Uncomfortable/ Tight Walking Environment","Secondary",{"$f":"K326","v":"No"},"No","No","No","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[null,"P: Indirect Paths","Secondary",{"$f":"K342","v":"No"},"No","No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[null,"Q: Grade Change","Secondary",{"$f":"K357","v":"No"},{"$f":"L357","v":"No"},"No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[null,"R: Non-Intuitive Motor Vehicle Movements","Secondary",{"$f":"K371","v":"No"},"No","No","No","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[null,"S: Executing Unusual Movements","Secondary",{"$f":"K389","v":"No"},{"$f":"L389","v":"No"},"No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[null,"T: Off-Tracking  in Turns and Curves","Secondary",{"$f":"K404","v":"N/A"},"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[]
[null,"Total Yellow Flags by Movement",null,{"$f":"COUNTIF(D11:D31,\"yellow\")","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total Red Flags by Movement",null,{"$f":"COUNTIF(D11:D30,\"red\")","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,"TOTAL:",null,20,"PRIMARY FLAGS:",null,{"$f":"COUNTIF(C11:C30,\"Primary\")","v":10},"SECONDARY FLAGS:",null,10]
[null,null,null,"All","Ped","Bicycle","All","Ped","Bicycle","All","Ped","Bicycle"]
[null,null,"Total Yellow Flags:",{"$f":"COUNTIF(D11:S30, \"Yellow\")","v":0},{"$f":"COUNTIF(D11:G30, \"Yellow\")","v":0},{"$f":"COUNTIF(H$11:S$30, \"Yellow\")","v":0},{"$f":"COUNTIF(D16:S16, \"Yellow\")+COUNTIF(D17:S17, \"Yellow\")+COUNTIF(D11:S11, \"Yellow\")+COUNTIF(D12:S12, \"Yellow\")+COUNTIF(D18:S18, \"Yellow\")+COUNTIF(D20:S24, \"Yellow\")","v":0},{"$f":"COUNTIF(D16:G16, \"Yellow\")+COUNTIF(D17:G17, \"Yellow\")+COUNTIF(D11:G11, \"Yellow\")+COUNTIF(D12:G12, \"Yellow\")+COUNTIF(D18:G18, \"Yellow\")+COUNTIF(D20:G24, \"Yellow\")","v":0},{"$f":"COUNTIF(H16:S16, \"Yellow\")+COUNTIF(H17:S17, \"Yellow\")+COUNTIF(H11:S11, \"Yellow\")+COUNTIF(H12:S12, \"Yellow\")+COUNTIF(H18:S18, \"Yellow\")+COUNTIF(H20:S24, \"Yellow\")","v":0},{"$f":"D37-G37","v":0},{"$f":"E37-H37","v":0},0]
[null,null,"Total Red Flags:",{"$f":"COUNTIF(D11:S30,\"Red\")","v":0},{"$f":"COUNTIF(D11:G30, \"Red\")","v":0},{"$f":"COUNTIF(H11:S30, \"Red\")","v":0},{"$f":"COUNTIF(D16:S16, \"Red\")+COUNTIF(D17:S17, \"Red\")+COUNTIF(D11:S11, \"Red\")+COUNTIF(D12:S12, \"Red\")+COUNTIF(D18:S18, \"Red\")+COUNTIF(D20:S24, \"Red\")","v":0},{"$f":"COUNTIF(D16:G16, \"Red\")+COUNTIF(D17:G17, \"Red\")+COUNTIF(D11:G11, \"Red\")+COUNTIF(D12:G12, \"Red\")+COUNTIF(D18:G18, \"Red\")+COUNTIF(D20:G24, \"Red\")","v":0},{"$f":"COUNTIF(H16:S16, \"Red\")+COUNTIF(H17:S17, \"Red\")+COUNTIF(H11:S11, \"Red\")+COUNTIF(H12:S12, \"Red\")+COUNTIF(H18:S18, \"Red\")+COUNTIF(H20:S24, \"Red\")","v":0},{"$f":"D38-G38","v":0},0,0]
[null,null,"Total No Flags:",{"$f":"COUNTIF(D11:S30,\"No\")","v":232},{"$f":"COUNTIF(D11:G30, \"No\")","v":52},{"$f":"COUNTIF(H11:S30, \"No\")","v":180},{"$f":"COUNTIF(D16:S16, \"No\")+COUNTIF(D17:S17, \"No\")+COUNTIF(D11:S11, \"No\")+COUNTIF(D12:S12, \"No\")+COUNTIF(D18:S18, \"No\")+COUNTIF(D20:S24, \"No\")","v":120},{"$f":"COUNTIF(D16:G16, \"No\")+COUNTIF(D17:G17, \"No\")+COUNTIF(D11:G11, \"No\")+COUNTIF(D12:G12, \"No\")+COUNTIF(D18:G18, \"No\")+COUNTIF(D20:G24, \"No\")","v":20},{"$f":"COUNTIF(H16:S16, \"No\")+COUNTIF(H17:S17, \"No\")+COUNTIF(H11:S11, \"No\")+COUNTIF(H12:S12, \"No\")+COUNTIF(H18:S18, \"No\")+COUNTIF(H20:S24, \"No\")","v":100},112,32,80]
[null,null,"Total N/A:",{"$f":"COUNTIF(D11:S30,\"N/A\")","v":88},{"$f":"COUNTIF(D11:G30, \"N/A\")","v":28},{"$f":"COUNTIF(H11:S30, \"N/A\")","v":60},{"$f":"COUNTIF(D16:S16, \"N/A\")+COUNTIF(D17:S17, \"N/A\")+COUNTIF(D11:S11, \"N/A\")+COUNTIF(D12:S12, \"N/A\")+COUNTIF(D18:S18, \"N/A\")+COUNTIF(D20:S24, \"N/A\")","v":40},{"$f":"COUNTIF(D16:G16, \"N/A\")+COUNTIF(D17:G17, \"N/A\")+COUNTIF(D11:G11, \"N/A\")+COUNTIF(D12:G12, \"N/A\")+COUNTIF(D18:G18, \"N/A\")+COUNTIF(D20:G24, \"N/A\")","v":20},{"$f":"COUNTIF(H16:S16, \"N/A\")+COUNTIF(H17:S17, \"N/A\")+COUNTIF(H11:S11, \"N/A\")+COUNTIF(H12:S12, \"N/A\")+COUNTIF(H18:S18, \"N/A\")+COUNTIF(H20:S24, \"N/A\")","v":20},48,8,40]
[null,null,"Total Possible:",{"$f":"SUM(D37:D40)-D40","v":232},{"$f":"SUM(E37:E40)-E40","v":52},180,120,20,100,112,32,80]
[null,null,"Percent Yellow:",{"$f":"IFERROR(D37/D41,0)","v":0},0,0,0,{"$f":"IFERROR(H37/H41,0)","v":0},{"$f":"IFERROR(I37/I41,0)","v":0},{"$f":"IFERROR(J37/J41,0)","v":0},{"$f":"IFERROR(K37/K41,0)","v":0},{"$f":"IFERROR(L37/L41,0)","v":0}]
[null,null,"Percent Red:",{"$f":"IFERROR(D38/D41,0)","v":0},0,0,0,{"$f":"IFERROR(H38/H41,0)","v":0},{"$f":"IFERROR(I38/I41,0)","v":0},0,0,0]
[null,null,"Percent Not Flagged:",{"$f":"100%-SUM(D42:D43)","v":1},1,1,1,1,1,1,1,1]
[]
[]
[]
[]
[]
[null,"Master Data Table",null,"Traffic Volume Demand",null,null,null,null,null,null,null,"Approach Speed"]
[]
[null,"LEGS/DIRECTION",null,"Volume (Veh/hr)",null,null,null,null,null,null,null,"Speed (mph)"]
[]
[null,null,null,"U-Turn",null,"Left",null,"Thru",null,"Right"]
[]
[null,"Westbound"]
[]
[null,"Eastbound"]
[]
[null,"North Bound"]
[]
[null,"Southbound"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"A68","v":"A: Undefined Crossing at Intersections"}]
[{"$f":"B11","v":"A: Undefined Crossing at Intersections"},null,"Flag Description:\nUnmarked crossings at an intersection can lower \nthe level of comfort when walking or biking. Right-turning\ndrivers are more likely to encroach on \npedestrian and bicyclist paths when clear pavement \ndemarcation is absent. Additionally, turning vehicles \nmay not expect pedestrians of bicyclists at the \ndownstream crossing point. This flag applies to both \npedestrian and bicyclist movements.\nConsiderations:\n◦ Bicycle lane markings that are present on both \nsides of the intersection but do not extend through \nthe intersection are subject to a yellow flag. \n◦ Right-turn and left-turn bicycle movements are \nexempt from this flag. \n◦ This flag applies to roadways with bicycle facilities. \nIf no on-street bicycle facilities exist, Flag M \napplies instead.",null,null,null,null,null,null,null,"Pedestrian Assessment",null,null,null,"Bicycle Assessment"]
[null,null,null,null,null,null,null,null,null,null,"West","East","North","South","NBL","NBT","NBR","SBL","SBT","SBR","EBL","EBT","EBR","WBL","WBT","WBR"]
[null,null,null,null,null,null,null,"Unmarked crosswalk at \nstop-controlled or \nsignalized movement"]
[null,null,null,null,null,null,null,"Unmarked crosswalk across \nmovement not controlled by a stop sign, beacon, or signal "]
[null,null,null,null,null,null,null,"Signalized movements without pedestrian signal head"]
[null,null,null,null,null,null,null,"No bicycle lane markings through intersection."]
[null,null,null,null,null,null,null,"Do bicycle lane marking end at intersection?"]
[null,null,null,null,null,null,null,"Flag Results",null,null,{"$f":"IF(OR(K71=\"Yes\",K72=\"Yes\"),\"Red\",IF(K70=\"Yes\",\"Yellow\",\"No\"))","v":"No"},{"$f":"IF(OR(L71=\"Yes\",L72=\"Yes\"),\"Red\",IF(L70=\"Yes\",\"Yellow\",\"No\"))","v":"No"},"No","No","N/A",{"$f":"IF(P74=\"Yes\",\"Red\",IF(P73=\"Yes\",\"Yellow\",\"No\"))","v":"No"},"N/A","N/A","No","N/A","N/A","No","N/A","N/A","No","N/A"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"A82","v":"B: Multilane Crossing"}]
[{"$f":"B12","v":"B: Multilane Crossing"},null,"Flag Description:\nLong crossings, particularly with multiple lanes \nin both directions, are a source of stress and risk \nat intersections. Shorter crossings with median \nrefuges, for crossing one direction of travel at a \ntime, and for having raised separation between \nopposing directions of traffic are preferred for \ncomfortable travel.\nConsiderations:\n◦ The number of lanes is irrespective of the direction \nof travel. Lane count is the maximum number of \nlanes of any direction, crossed between refuge areas.\n◦ Bicycle lanes and parking lanes are not counted in \nthis assessment. \n◦ This flag applies to roadways with and without \nbicycle facilities.\n◦ Lane counts for left-turning bicyclist includes the \nnumber of lanes crossed on the adjacent approach \nplus the number of lanes crossed on the opposing \napproach.",null,null,null,null,null,null,null,"Pedestrian Assessment",null,null,null,"Bicycle Assessment"]
[null,null,null,null,null,null,null,null,null,null,"West","East","North","South","NBL","NBT","NBR","SBL","SBT","SBR","EBL","EBT","EBR","WBL","WBT","WBR"]
[null,null,null,null,null,null,null,"Crossing Traffic Control",null,null,null,null,null,null,{"$f":"IF(N84<>\"\",N84,\"\")","v":""},null,null,{"$f":"IF(M84<>\"\", M84,\"\")","v":""},null,null,{"$f":"IF(K84<>\"\",K84,\"\")","v":""},null,null,{"$f":"IF(L84<>\"\", L84,\"\")","v":""}]
[null,null,null,null,null,null,null,"Number of lanes a pedestrian crossed without refuge"]
[null,null,null,null,null,null,null,"Number of lanes a bicyclist crossed without refuge"]
[null,null,null,null,null,null,null,"Flag Results",null,null,{"$f":"IF(OR(K84=\"Signalized\", K84=\"Beacon\", K84=\"Unsignalized\"),\n   IF(AND(K85=3, K84=\"Unsignalized\"), \"Yellow\",\n   IF(AND(K85>=3, K85<=4, K84=\"Beacon\"), \"Yellow\",\n   IF(AND(K85=4, K84=\"Signalized\"), \"Yellow\",\n   IF(AND(K85>3, K84=\"Unsignalized\"), \"Red\",\n   IF(AND(K85>=5, K84=\"Beacon\"), \"Red\",\n   IF(AND(K85>=5, K84=\"Signalized\"), \"Red\", \"No\")))))),\n   \"No\")","v":"No"},{"$f":"IF(OR(L84=\"Signalized\", L84=\"Beacon\", L84=\"Unsignalized\"),\n   IF(AND(L85=3, L84=\"Unsignalized\"), \"Yellow\",\n   IF(AND(L85>=3, L85<=4, L84=\"Beacon\"), \"Yellow\",\n   IF(AND(L85=4, L84=\"Signalized\"), \"Yellow\",\n   IF(AND(L85>3, L84=\"Unsignalized\"), \"Red\",\n   IF(AND(L85>=5, L84=\"Beacon\"), \"Red\",\n   IF(AND(L85>=5, L84=\"Signalized\"), \"Red\", \"No\")))))),\n   \"No\")","v":"No"},"No",{"$f":"IF(OR(N84=\"Signalized\", N84=\"Beacon\", N84=\"Unsignalized\"),\n   IF(AND(N85=3, N84=\"Unsignalized\"), \"Yellow\",\n   IF(AND(N85>=3, N85<=4, N84=\"Beacon\"), \"Yellow\",\n   IF(AND(N85=4, N84=\"Signalized\"), \"Yellow\",\n   IF(AND(N85>3, N84=\"Unsignalized\"), \"Red\",\n   IF(AND(N85>=5, N84=\"Beacon\"), \"Red\",\n   IF(AND(N85>=5, N84=\"Signalized\"), \"Red\", \"No\")))))),\n   \"No\")","v":"No"},{"$f":"IF(OR(O84=\"Signalized\", O84=\"Beacon\", O84=\"Unsignalized\"),\n   IF(AND(O86>=3,O86<=4, O84=\"Unsignalized\"), \"Yellow\",\n   IF(AND(O86>=4, O86<=5, O84=\"Beacon\"), \"Yellow\",\n   IF(AND(O86>=4,O86<=5, O84=\"Signalized\"), \"Yellow\",\n   IF(AND(O86>4, O84=\"Unsignalized\"), \"Red\",\n   IF(AND(O86>5, O84=\"Beacon\"), \"Red\",\n   IF(AND(O86>5, O84=\"Signalized\"), \"Red\", \"No\")))))),\n   \"No\")","v":"No"},{"$f":"IF(OR(O84=\"Signalized\", O84=\"Beacon\", O84=\"Unsignalized\"),\n   IF(AND(P86>=3,P86<=4, O84=\"Unsignalized\"), \"Yellow\",\n   IF(AND(P86>=4, P86<=5, O84=\"Beacon\"), \"Yellow\",\n   IF(AND(P86>=4,P86<=5, O84=\"Signalized\"), \"Yellow\",\n   IF(AND(P86>4, O84=\"Unsignalized\"), \"Red\",\n   IF(AND(P86>5, O84=\"Beacon\"), \"Red\",\n   IF(AND(P86>5, O84=\"Signalized\"), \"Red\", \"No\")))))),\n   \"No\")","v":"No"},{"$f":"IF(OR(O84=\"Signalized\", O84=\"Beacon\", O84=\"Unsignalized\"),\n   IF(AND(Q86>=3,Q86<=4, O84=\"Unsignalized\"), \"Yellow\",\n   IF(AND(Q86>=4, Q86<=5, O84=\"Beacon\"), \"Yellow\",\n   IF(AND(Q86>=4,Q86<=5, O84=\"Signalized\"), \"Yellow\",\n   IF(AND(Q86>4, O84=\"Unsignalized\"), \"Red\",\n   IF(AND(Q86>5, O84=\"Beacon\"), \"Red\",\n   IF(AND(Q86>5, O84=\"Signalized\"), \"Red\", \"No\")))))),\n   \"No\")","v":"No"},{"$f":"IF(OR(R84=\"Signalized\", R84=\"Beacon\", R84=\"Unsignalized\"),\n   IF(AND(R86>=3,R86<=4, R84=\"Unsignalized\"), \"Yellow\",\n   IF(AND(R86>=4, R86<=5, R84=\"Beacon\"), \"Yellow\",\n   IF(AND(R86>=4,R86<=5, R84=\"Signalized\"), \"Yellow\",\n   IF(AND(R86>4, R84=\"Unsignalized\"), \"Red\",\n   IF(AND(R86>5, R84=\"Beacon\"), \"Red\",\n   IF(AND(R86>5, R84=\"Signalized\"), \"Red\", \"No\")))))),\n   \"No\")","v":"No"},{"$f":"IF(OR(R84=\"Signalized\", R84=\"Beacon\", R84=\"Unsignalized\"),\n   IF(AND(S86>=3,S86<=4, R84=\"Unsignalized\"), \"Yellow\",\n   IF(AND(S86>=4, S86<=5, R84=\"Beacon\"), \"Yellow\",\n   IF(AND(S86>=4,S86<=5, R84=\"Signalized\"), \"Yellow\",\n   IF(AND(S86>4, R84=\"Unsignalized\"), \"Red\",\n   IF(AND(S86>5, R84=\"Beacon\"), \"Red\",\n   IF(AND(S86>5, R84=\"Signalized\"), \"Red\", \"No\")))))),\n   \"No\")","v":"No"},{"$f":"IF(OR(R84=\"Signalized\", R84=\"Beacon\", R84=\"Unsignalized\"),\n   IF(AND(T86>=3,T86<=4, R84=\"Unsignalized\"), \"Yellow\",\n   IF(AND(T86>=4, T86<=5, R84=\"Beacon\"), \"Yellow\",\n   IF(AND(T86>=4,T86<=5, R84=\"Signalized\"), \"Yellow\",\n   IF(AND(T86>4, R84=\"Unsignalized\"), \"Red\",\n   IF(AND(T86>5, R84=\"Beacon\"), \"Red\",\n   IF(AND(T86>5, R84=\"Signalized\"), \"Red\", \"No\")))))),\n   \"No\")","v":"No"},{"$f":"IF(OR(U84=\"Signalized\", U84=\"Beacon\", U84=\"Unsignalized\"),\n   IF(AND(U86>=3,U86<=4, U84=\"Unsignalized\"), \"Yellow\",\n   IF(AND(U86>=4, U86<=5, U84=\"Beacon\"), \"Yellow\",\n   IF(AND(U86>=4,U86<=5, U84=\"Signalized\"), \"Yellow\",\n   IF(AND(U86>4, U84=\"Unsignalized\"), \"Red\",\n   IF(AND(U86>5, U84=\"Beacon\"), \"Red\",\n   IF(AND(U86>5, U84=\"Signalized\"), \"Red\", \"No\")))))),\n   \"No\")","v":"No"},{"$f":"IF(OR(U84=\"Signalized\", U84=\"Beacon\", U84=\"Unsignalized\"),\n   IF(AND(V86>=3,V86<=4, U84=\"Unsignalized\"), \"Yellow\",\n   IF(AND(V86>=4, V86<=5, U84=\"Beacon\"), \"Yellow\",\n   IF(AND(V86>=4,V86<=5, U84=\"Signalized\"), \"Yellow\",\n   IF(AND(V86>4, U84=\"Unsignalized\"), \"Red\",\n   IF(AND(V86>5, U84=\"Beacon\"), \"Red\",\n   IF(AND(V86>5, U84=\"Signalized\"), \"Red\", \"No\")))))),\n   \"No\")","v":"No"},{"$f":"IF(OR(U84=\"Signalized\", U84=\"Beacon\", U84=\"Unsignalized\"),\n   IF(AND(W86>=3,W86<=4, U84=\"Unsignalized\"), \"Yellow\",\n   IF(AND(W86>=4, W86<=5, U84=\"Beacon\"), \"Yellow\",\n   IF(AND(W86>=4,W86<=5, U84=\"Signalized\"), \"Yellow\",\n   IF(AND(W86>4, U84=\"Unsignalized\"), \"Red\",\n   IF(AND(W86>5, U84=\"Beacon\"), \"Red\",\n   IF(AND(W86>5, U84=\"Signalized\"), \"Red\", \"No\")))))),\n   \"No\")","v":"No"},{"$f":"IF(OR(X84=\"Signalized\", X84=\"Beacon\", X84=\"Unsignalized\"),\n   IF(AND(X86>=3,X86<=4, X84=\"Unsignalized\"), \"Yellow\",\n   IF(AND(X86>=4, X86<=5, X84=\"Beacon\"), \"Yellow\",\n   IF(AND(X86>=4,X86<=5, X84=\"Signalized\"), \"Yellow\",\n   IF(AND(X86>4, X84=\"Unsignalized\"), \"Red\",\n   IF(AND(X86>5, X84=\"Beacon\"), \"Red\",\n   IF(AND(X86>5, X84=\"Signalized\"), \"Red\", \"No\")))))),\n   \"No\")","v":"No"},{"$f":"IF(OR(X84=\"Signalized\", X84=\"Beacon\", X84=\"Unsignalized\"),\n   IF(AND(Y86>=3,Y86<=4, X84=\"Unsignalized\"), \"Yellow\",\n   IF(AND(Y86>=4, Y86<=5, X84=\"Beacon\"), \"Yellow\",\n   IF(AND(Y86>=4,Y86<=5, X84=\"Signalized\"), \"Yellow\",\n   IF(AND(Y86>4, X84=\"Unsignalized\"), \"Red\",\n   IF(AND(Y86>5, X84=\"Beacon\"), \"Red\",\n   IF(AND(Y86>5, X84=\"Signalized\"), \"Red\", \"No\")))))),\n   \"No\")","v":"No"},{"$f":"IF(OR(X84=\"Signalized\", X84=\"Beacon\", X84=\"Unsignalized\"),\n   IF(AND(Z86>=3,Z86<=4, X84=\"Unsignalized\"), \"Yellow\",\n   IF(AND(Z86>=4, Z86<=5, X84=\"Beacon\"), \"Yellow\",\n   IF(AND(Z86>=4,Z86<=5, X84=\"Signalized\"), \"Yellow\",\n   IF(AND(Z86>4, X84=\"Unsignalized\"), \"Red\",\n   IF(AND(Z86>5, X84=\"Beacon\"), \"Red\",\n   IF(AND(Z86>5, X84=\"Signalized\"), \"Red\", \"No\")))))),\n   \"No\")","v":"No"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"A99","v":"C: Long Red Times"}]
[{"$f":"B13","v":"C: Long Red Times"},null,"Flag Description:\nLong cycle lengths and phases can lead to \nextended delays for pedestrians and bicyclists. \nMultiple stage crossings, such as at median refuge \nislands or left-turning bicyclists via a bike box, are \nparticularly susceptible to long red times.\nA planning level estimation of delay can be made \nusing the equation below and reference table \nbelow can be used to estimate red time. \nConsiderations:\n◦ For bicyclists, the delay is assessed for each turning \nmovement. \n◦ Only signal delay, not extra distance traveled delay, \nshould be included in the calculation of red time.\n◦ Total time is combined across all stages for \npedestrians crossing an approach which requires \nmultiple stages (e.g. due to a short flashing don’t \nwalk indication and a median refuge) and for \nbicycle movements redirected to multi-stage \nmovements (e.g. through a bike box).\n◦ This flag applies to roadways with and without \nbicycle facilities.",null,null,null,null,null,null,null,"Pedestrian Assessment",null,null,null,"Bicycle Assessment"]
[null,null,null,null,null,null,null,null,null,null,"West","East","North","South","NBL","NBT","NBR","SBL","SBT","SBR","EBL","EBT","EBR","WBL","WBT","WBR"]
[null,null,null,null,null,null,null,"Does this flag apply?"]
[null,null,null,null,null,null,null,"Cycle Length (seconds)",null,null,null,{"$f":"IF(ISBLANK($K$102),\"\",$K$102)","v":""},"","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,"Movement Red Time (MRT) (seconds)"]
[null,null,null,null,null,null,null,"Enter # Critical Phases - if MRT is not available"]
[null,null,null,null,null,null,null,"Choose Vehicle Movement - if MRT is not available"]
[null,null,null,null,null,null,null,"Estimated Movement Red Time (seconds)",null,null,{"$f":"IFERROR(IF(OR(K104=\"\", K105=\"\"), \"\",\n   IF(K105=\"Crossing with Major\",\n      CHOOSE(K104, \"\",0.3, 0.5, 0.6),\n      IF(K105=\"Crossing with Minor\",\n         CHOOSE(K104, \"\",0.7, 0.75, 0.85),\n         \"\"\n      )\n   )\n)*K102,\"\")","v":""},{"$f":"IFERROR(IF(OR(L104=\"\", L105=\"\"), \"\",\n   IF(L105=\"Crossing with Major\",\n      CHOOSE(L104, \"\",0.3, 0.5, 0.6),\n      IF(L105=\"Crossing with Minor\",\n         CHOOSE(L104, \"\",0.7, 0.75, 0.85),\n         \"\"\n      )\n   )\n)*L102,\"\")","v":""},"","","","","","","","","","","","","",""]
[null,null,null,null,null,null,null,"Estimated Delay (seconds)",null,null,{"$f":"IFERROR(IF(NOT(ISBLANK(K103)),(POWER(K103,2)/(2*K102)),(POWER(K106,2)/(2*K102))),0)","v":0},{"$f":"IFERROR(IF(NOT(ISBLANK(L103)),(POWER(L103,2)/(2*L102)),(POWER(L106,2)/(2*L102))),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,"Flag Results",null,null,{"$f":"IF(K101=\"No\",\"N/A\",IF(OR(ISBLANK(K101),K101=\"Yes\"),IF(AND(K107>=30,K107<45),\"Yellow\",IF(K107>=45,\"Red\",IF(K107=\"\",\"N/A\",\"No\"))),\"No\"))","v":"No"},{"$f":"IF(L101=\"No\",\"N/A\",IF(OR(ISBLANK(L101),L101=\"Yes\"),IF(AND(L107>=30,L107<45),\"Yellow\",IF(L107>=45,\"Red\",IF(L107=\"\",\"N/A\",\"No\"))),\"No\"))","v":"No"},"No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"A115","v":"D: Bicycle Clearance Times"}]
[{"$f":"B14","v":"D: Bicycle Clearance Times"},null,"Flag Description:\nThe clearance times calculated for motorists \nare likely insufficient for bicyclists to travel \nthrough the intersection during the yellow and \nred indications, exposing bicyclists to conflicting \nvehicles entering the intersection on a subsequent \ngreen indication. This clearance time difference is \ngreater with higher vehicle speeds and at larger \nintersections. \nConsiderations:\n◦ Clearance zone length should include the full \ndistance from the upstream stop bar through the \nfurthest downstream conflicting movement.\n◦ This flag applies to roadways with and without \nbicycle facilities.",null,null,null,null,null,null,null,"Pedestrian Assessment",null,null,null,"Bicycle Assessment"]
[null,null,null,null,null,null,null,null,null,null,"West","East","North","South","NBL","NBT","NBR","SBL","SBT","SBR","EBL","EBT","EBR","WBL","WBT","WBR"]
[null,null,null,null,null,null,null,"Approach Speed (mph)",null,null,null,null,null,null,{"$f":"$L$60","v":0},{"$f":"$L$60","v":0},null,{"$f":"$L$62","v":0},{"$f":"$L$62","v":0},null,{"$f":"$L$58","v":0},{"$f":"$L$58","v":0},null,{"$f":"$L$56","v":0},{"$f":"$L$56","v":0}]
[null,null,null,null,null,null,null,"Clearance Zone Length (ft)"]
[null,null,null,null,null,null,null,"Flag Results",null,null,"N/A","N/A","N/A","N/A",{"$f":"IF(OR(AND(O117<35,O118>72),AND(O117>=35,O118>60)),\"Red\",IF(OR(AND(O117<35,O118>=36,O118<=72),AND(O117>=35,O118>=24,O118<=60)),\"Yellow\",\"No\"))","v":"No"},{"$f":"IF(OR(AND(P117<35,P118>72),AND(P117>=35,P118>60)),\"Red\",IF(OR(AND(P117<35,P118>=36,P118<=72),AND(P117>=35,P118>=24,P118<=60)),\"Yellow\",\"No\"))","v":"No"},"N/A","No","No","N/A","No","No","N/A","No","No","N/A"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"A131","v":"E: Sight Distance for Gap Acceptance Movements"}]
[{"$f":"B15","v":"E: Sight Distance for Gap Acceptance Movements"},null,"Flag Description:\nSight distance must be provided in all aspects of \nan intersection design. Sight distance includes \nstopping sight distance, intersection sight \ndistance, decision sight distance, and view angles.  \nConsiderations:\n◦ Sight distance requirements by vehicle speeds \ncan be found in the AASHTO Green Book and \nNCHRP Report 834 for pedestrians. \n◦ This flag applies to roadways with and without \nbicycle facilities.",null,null,null,null,null,null,null,"Pedestrian Assessment",null,null,null,"Bicycle Assessment"]
[null,null,null,null,null,null,null,null,null,null,"West","East","North","South","NBL","NBT","NBR","SBL","SBT","SBR","EBL","EBT","EBR","WBL","WBT","WBR"]
[null,null,null,null,null,null,null,"Approach Speed (mph)",null,null,{"$f":"$L$58","v":0},{"$f":"$L$56","v":0},{"$f":"$L$62","v":0},{"$f":"$L$60","v":0},{"$f":"$L$60","v":0},{"$f":"$L$60","v":0},0,{"$f":"$L$62","v":0},{"$f":"$L$62","v":0},0,{"$f":"$L$58","v":0},{"$f":"$L$58","v":0},0,{"$f":"$L$56","v":0},{"$f":"$L$56","v":0},0]
[null,null,null,null,null,null,null,"Is the sight distance less than required for Vehicle speed "]
[null,null,null,null,null,null,null,"Flag Results",null,null,{"$f":"IF(K134=\"Yes\",\"Red\",\"No\")","v":"No"},{"$f":"IF(L134=\"Yes\",\"Red\",\"No\")","v":"No"},"No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"A147","v":"F: Motor Vehicle Right Turns"}]
[{"$f":"B16","v":"F: Motor Vehicle Right Turns"},null,"Flag Description:\nMotor vehicle right turns on each approach create \ntwo separate conflicts with crossing pedestrians. \nEach leg is evaluated for a design flag based \non the right-turn movement volume and speed. \nSpeeds can be estimated using the speed-radius \nrelationship found in the AASHTO Green Book, or \nbased on field-collected speed data.\nConsiderations:\n◦ For pedestrian movements with multiple right-turning\nvehicle conflicts, the most severe flag is \nrecorded. This typically involves vehicle exiting \nthe intersection.\n◦ If the vehicle movement is stop controlled \nor signalized with no right-turns-on-red or \nspeeds are below 10 mph (e.g., through a raised \ncrosswalk), this flag is eliminated.\n◦ If channelized right turn lanes are present, vehicle \nspeed is likely higher due to the larger radii.\n◦ At roundabouts, Flag J (Crossing Yield- or \nUncontrolled Vehicle Paths) is generally more \napplicable. Use either Flag F or Flag J, but not both.",null,null,null,null,null,null,null,"Pedestrian Assessment",null,null,null,"Bicycle Assessment"]
[null,null,null,null,null,null,null,null,null,null,"West","East","North","South","NBL","NBT","NBR","SBL","SBT","SBR","EBL","EBT","EBR","WBL","WBT","WBR"]
[null,null,null,null,null,null,null,"Radius of Curve (ft)"]
[null,null,null,null,null,null,null,"Predicted Right Turn Speed (mph)",null,null,{"$f":"3.4415*POWER(K149,0.3861)","v":0},{"$f":"3.4415*POWER(L149,0.3861)","v":0},0,0]
[null,null,null,null,null,null,null,"Right Turn Speed (mph)"]
[null,null,null,null,null,null,null,"Volume (vphpln)",null,null,{"$f":"$J$62","v":0},{"$f":"$J$60","v":0},{"$f":"$J$56","v":0},{"$f":"$J$58","v":0}]
[null,null,null,null,null,null,null,"Is Speed between 20 to 30 Mph and Volume <= 300 vphpln",null,null,{"$f":"IF(OR(AND(K151>=20,K151<=30,K152<=300),AND(K150>=20,K150<=30,K152<=300)),\"Yes\",\"No\")","v":"No"},{"$f":"IF(OR(AND(L151>=20,L151<=30,L152<=300),AND(L150>=20,L150<=30,L152<=300)),\"Yes\",\"No\")","v":"No"},"No","No"]
[null,null,null,null,null,null,null,"Is the Volume greater than \n300 vphpln",null,null,{"$f":"IF(K152>300,\"Yes\",\"No\")","v":"No"},{"$f":"IF(L152>300,\"Yes\",\"No\")","v":"No"},{"$f":"IF(M152>300,\"Yes\",\"No\")","v":"No"},"No"]
[null,null,null,null,null,null,null,"Right Turn on Red is permitted"]
[null,null,null,null,null,null,null,"Is Speed > 20mph and Volume > 300 vphpln",null,null,{"$f":"IF(OR(AND(K151>20,K152>300),AND(K150>20,K152>300)),\"Yes\",\"No\")","v":"No"},{"$f":"IF(OR(AND(L151>20,L152>300),AND(L150>20,L152>300)),\"Yes\",\"No\")","v":"No"},"No","No"]
[null,null,null,null,null,null,null,"Is Speed >30 mph",null,null,{"$f":"IF(OR(K151>30,K150>30),\"Yes\",\"No\")","v":"No"},{"$f":"IF(OR(L151>30,L150>30),\"Yes\",\"No\")","v":"No"},"No","No"]
[null,null,null,null,null,null,null,"Flag Results",null,null,{"$f":"IF(OR(K156=\"Yes\",K157=\"Yes\"),\"Red\",IF(OR(K153=\"Yes\",K154=\"Yes\",K155=\"Yes\"),\"Yellow\",\"No\"))","v":"No"},{"$f":"IF(OR(L156=\"Yes\",L157=\"Yes\"),\"Red\",IF(OR(L153=\"Yes\",L154=\"Yes\",L155=\"Yes\"),\"Yellow\",\"No\"))","v":"No"},{"$f":"IF(OR(M156=\"Yes\",M157=\"Yes\"),\"Red\",IF(OR(M153=\"Yes\",M154=\"Yes\",M155=\"Yes\"),\"Yellow\",\"No\"))","v":"No"},"No","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"A167","v":"G: Motor Vehicle Left Turns"}]
[{"$f":"B17","v":"G: Motor Vehicle Left Turns"},null,"Flag Description:\nBoth permissive and protected motor vehicle \nleft-turns can affect the safety and comfort \nof pedestrians and bicyclists. Drivers making \npermissive left-turns are often focused on finding a \ngap in oncoming traffic and may not be watching \nfor nonmotorized road users crossing the side \nstreet. Pedestrians may not realize the conflicting \nleading protected left-turn has been given the green \nindication but the walk interval has not yet started. \nConsiderations:\n◦ This flag does not apply to roundabouts or to \ncrossings with vehicle speed below 10 mph, such as \nat raised crosswalks. \n◦ Movements with protected-only left turn phasing \ncan only have a yellow flag.\n◦ This flag considers movements with  protected and \npermissive phasing as permissive.\n◦ This flag applies to roadways with dedicated bicycle \nlanes or without exclusive bicycle facilities where \nbicyclists use the sidewalk or shared use path.",null,null,null,null,null,null,null,"Pedestrian Assessment",null,null,null,"Bicycle Assessment"]
[null,null,null,null,null,null,null,null,null,null,"West","East","North","South","NBL","NBT","NBR","SBL","SBT","SBR","EBL","EBT","EBR","WBL","WBT","WBR"]
[null,null,null,null,null,null,null,"Radius of Curve (ft)"]
[null,null,null,null,null,null,null,"Predicted Left Turn Speed (mph)",null,null,{"$f":"3.4415*POWER(K169,0.3861)","v":0},{"$f":"3.4415*POWER(L169,0.3861)","v":0},{"$f":"3.4415*POWER(M169,0.3861)","v":0},{"$f":"3.4415*POWER(N169,0.3861)","v":0},{"$f":"3.4415*POWER(O169,0.3861)","v":0},{"$f":"3.4415*POWER(P169,0.3861)","v":0},{"$f":"3.4415*POWER(Q169,0.3861)","v":0},{"$f":"3.4415*POWER(R169,0.3861)","v":0},{"$f":"3.4415*POWER(S169,0.3861)","v":0},{"$f":"3.4415*POWER(T169,0.3861)","v":0},{"$f":"3.4415*POWER(U169,0.3861)","v":0},{"$f":"3.4415*POWER(V169,0.3861)","v":0},{"$f":"3.4415*POWER(W169,0.3861)","v":0},{"$f":"3.4415*POWER(X169,0.3861)","v":0},{"$f":"3.4415*POWER(Y169,0.3861)","v":0},{"$f":"3.4415*POWER(Z169,0.3861)","v":0}]
[null,null,null,null,null,null,null,"Left Turn Speed (mph)"]
[null,null,null,null,null,null,null,"Volume (vphpln)",null,null,{"$f":"$F$58","v":0},{"$f":"$F$56","v":0},{"$f":"$F$62","v":0},{"$f":"$F$60","v":0},{"$f":"$F$60","v":0},{"$f":"$H$60","v":0},{"$f":"$J$60","v":0},{"$f":"$F$62","v":0},{"$f":"$H$62","v":0},{"$f":"$J$62","v":0},{"$f":"$F$58","v":0},{"$f":"$H$58","v":0},{"$f":"$J$58","v":0},{"$f":"$F$56","v":0},{"$f":"$H$56","v":0},{"$f":"$J$56","v":0}]
[null,null,null,null,null,null,null,"Is it a Protected or Permissive Left Turn?"]
[null,null,null,null,null,null,null,"If Protected is the Left Turn a Leading Left?"]
[null,null,null,null,null,null,null,"Is Speed between 20 to 30 Mph and Volume <= 300 vphpln",null,null,{"$f":"IF(OR(AND(K171>=20,K171<=30,K172<=300),AND(K170>=20,K170<=30,K172<=300)),\"Yes\",\"No\")","v":"No"},{"$f":"IF(OR(AND(L171>=20,L171<=30,L172<=300),AND(L170>=20,L170<=30,L172<=300)),\"Yes\",\"No\")","v":"No"},"No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[null,null,null,null,null,null,null," Permissive Left Turn: \nIs the Volume greater than \n300 vphpln",null,null,{"$f":"IF(K172>300,\"Yes\",\"No\")","v":"No"},"No","No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[null,null,null,null,null,null,null,"Permissive Left Turn: \nIs Speed > 20mph and Volume > 300 vphpln",null,null,{"$f":"IF(K173=\"Permissive\", IF(OR(AND(K171>20,K172>300),AND(K170>20,K172>300)),\"Yes\",\"No\"),\"No\")","v":"No"},{"$f":"IF(L173=\"Permissive\", IF(OR(AND(L171>20,L172>300),AND(L170>20,L172>300)),\"Yes\",\"No\"),\"No\")","v":"No"},"No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[null,null,null,null,null,null,null,"Permissive Left Turn: \nIs Speed >30 mph",null,null,{"$f":"IF(K173=\"Permissive\", IF(OR(AND(K171>30),AND(K170>30)),\"Yes\",\"No\"),\"No\")","v":"No"},{"$f":"IF(L173=\"Permissive\", IF(OR(AND(L171>30),AND(L170>30)),\"Yes\",\"No\"),\"No\")","v":"No"},"No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[null,null,null,null,null,null,null,"Flag Results",null,null,{"$f":"IF(AND(K173=\"Permissive\",OR(K177=\"Yes\",K178=\"Yes\")),\"Red\",IF(AND(K173=\"Permissive\",OR(K175=\"Yes\",K176=\"Yes\")),\"Yellow\",IF(AND(K173=\"Protected\",K174=\"Yes\"),\"Yellow\",\"No\")))","v":"No"},{"$f":"IF(AND(L173=\"Permissive\",OR(L177=\"Yes\",L178=\"Yes\")),\"Red\",IF(AND(L173=\"Permissive\",OR(L175=\"Yes\",L176=\"Yes\")),\"Yellow\",IF(AND(L173=\"Protected\",L174=\"Yes\"),\"Yellow\",\"No\")))","v":"No"},"No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"A184","v":"H: Turning Motorists Crossing Bike Path"}]
[{"$f":"B18","v":"H: Turning Motorists Crossing Bike Path"},null,"Flag Description:\nMotor vehicle lane changes across bicyclists’ \npaths is fraught with complex conflicting \nmaneuvers conducted at speed. This movement \nis subject to bicyclists being in a driver’s blind \nspot and “right hook” crashes across the bicycle \nlane. Exclusive turn lanes provide more space \nto navigate this crossing conflict than shared \nthrough/right turn lanes.\nConsiderations:\n◦ This flag should not be double counted with  \nFlag N.\n◦ This flag is applicable at both channelized and \nnon-channelized locations.",null,null,null,null,null,null,null,"Pedestrian Assessment",null,null,null,"Bicycle Assessment"]
[null,null,null,null,null,null,null,null,null,null,"West","East","North","South","NBL","NBT","NBR","SBL","SBT","SBR","EBL","EBT","EBR","WBL","WBT","WBR"]
[null,null,null,null,null,null,null,"Is there an exclusive on-street bike lane?"]
[null,null,null,null,null,null,null,"Are there adjacent right turning vehicles?"]
[null,null,null,null,null,null,null,"Flag Results",null,null,"N/A","N/A","N/A","N/A",{"$f":"IF(O186=\"Yes\",IF(O187=\"Exclusive Turn Lane\",\"Yellow\",IF(O187=\"Shared Thru-Right Lane\",\"Red\",\"No\")),\"No\")","v":"No"},{"$f":"IF(P186=\"Yes\",IF(P187=\"Exclusive Turn Lane\",\"Yellow\",IF(P187=\"Shared Thru-Right Lane\",\"Red\",\"No\")),\"No\")","v":"No"},{"$f":"IF(Q186=\"Yes\",IF(Q187=\"Exclusive Turn Lane\",\"Yellow\",IF(Q187=\"Shared Thru-Right Lane\",\"Red\",\"No\")),\"No\")","v":"No"},"No","No","No","No","No","No","No","No","No"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"A202","v":"I: Intersecting Driveways and Side Streets"}]
[{"$f":"B19","v":"I: Intersecting Driveways and Side Streets"},null,"Flag Description:\nConflicting movements at driveways and side \nstreets can result in an increased cognitive load \nand distractions for all users. Turning drivers may \nbe more focused on seeking gaps in multiple \ntraffic streams than monitoring crossing users in \nthe immediate vicinity. \nConsiderations:\n◦ An intersection’s influence area is 250 feet in all \ndirections from the center of the intersection.\n◦ Given the increased concern of vehicle/bicycle \nconflicts on two-way bicycle facilities, any access \npoints within the area of influence should be \nclassified as a red flag. \n◦ This flag applies to roadways with and without \nbicycle facilities.",null,null,null,null,null,null,null,"Pedestrian Assessment",null,null,null,"Bicycle Assessment"]
[null,null,null,null,null,null,null,null,null,null,"West","East","North","South","NBL","NBT","NBR","SBL","SBT","SBR","EBL","EBT","EBR","WBL","WBT","WBR"]
[null,null,null,null,null,null,null,"Number of access points in Area of Influence for Pedestrians"]
[null,null,null,null,null,null,null,"Number of access points in Area of Influence for one-way bicycles"]
[null,null,null,null,null,null,null,"Number of access points in Area of Influence for two-way bicycles"]
[null,null,null,null,null,null,null,"Flag Results",null,null,{"$f":"IF(AND(K204>=1,K204<=2),\"Yellow\",IF(K204>2,\"Red\",\"No\"))","v":"No"},{"$f":"IF(AND(L204>=1,L204<=2),\"Yellow\",IF(L204>2,\"Red\",\"No\"))","v":"No"},"No","No",{"$f":"IF(AND(O205>=1,O205<=2),\"Yellow\",IF(OR(O205>2,O206>0),\"Red\",\"No\"))","v":"No"},{"$f":"IF(AND(P205>=1,P205<=2),\"Yellow\",IF(OR(P205>2,P206>0),\"Red\",\"No\"))","v":"No"},"No","No","No","No","No","No","No","No","No","No"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"A220","v":"J: Crossing Yield-Controlled or Uncontrolled Vehicle Paths "}]
[{"$f":"B20","v":"J: Crossing Yield-Controlled or Uncontrolled Vehicle Paths "},null,"Flag Description:\nYield-controlled and uncontrolled crossings lead \nto uncomfortable and potentially unsafe conflicts \nbetween bicyclists, pedestrians, and vehicles. Even \nif a crosswalk is marked, drivers may not perceive \npedestrians and may fail to yield to them. This \nflag applies to both pedestrian and bicycle paths. \nSpeeds can be estimated using the speed-radius \nrelationship found in the AASHTO Green Book, or \nbased on field-collected speed data.\nConsiderations:\n◦ For pedestrian and bicycle movements crossing \nmultiple vehicle flows, the most severe flag is \nrecorded.\n◦ Flag J can be used at roundabouts and is preferred \nover Flag F. \n◦ This flag applies to roadways with dedicated \nbicycle lanes or without exclusive bicycle \nfacilities where bicyclists use the sidewalk or \nshared use path.",null,null,null,null,null,null,null,"Pedestrian Assessment",null,null,null,"Bicycle Assessment"]
[null,null,null,null,null,null,null,null,null,null,"West","East","North","South","NBL","NBT","NBR","SBL","SBT","SBR","EBL","EBT","EBR","WBL","WBT","WBR"]
[null,null,null,null,null,null,null,"Does this flag apply?"]
[null,null,null,null,null,null,null,"Radius of Curve (ft)"]
[null,null,null,null,null,null,null,"Predicted Yield or Uncontrolled conflict speed (mph)",null,null,{"$f":"3.4415*POWER(K223,0.3861)","v":0},{"$f":"3.4415*POWER(L223,0.3861)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,"Yield or Uncontrolled conflict speed (mph)"]
[null,null,null,null,null,null,null,"Volume (vphpln)",null,null,{"$f":"W226","v":0},{"$f":"Z226","v":0},{"$f":"T226","v":0},{"$f":"Q226","v":0},{"$f":"$F$60","v":0},{"$f":"$H$60","v":0},{"$f":"$J$60","v":0},{"$f":"$F$62","v":0},{"$f":"$H$62","v":0},{"$f":"$J$62","v":0},{"$f":"$F$58","v":0},{"$f":"$H$58","v":0},{"$f":"$J$58","v":0},{"$f":"$F$56","v":0},{"$f":"$H$56","v":0},{"$f":"$J$56","v":0}]
[null,null,null,null,null,null,null,"Is Speed between 20 to 30 Mph and Volume <= 300 vphpln",null,null,{"$f":"IF(OR(AND(K225>=20,K225<=30,K226<=300),AND(K224>=20,K224<=30,K226<=300)),\"Yes\",\"No\")","v":"No"},{"$f":"IF(OR(AND(L225>=20,L225<=30,L226<=300),AND(L224>=20,L224<=30,L226<=300)),\"Yes\",\"No\")","v":"No"},"No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[null,null,null,null,null,null,null,"Is the Volume greater than \n300 vphpln",null,null,{"$f":"IF(K226>300,\"Yes\",\"No\")","v":"No"},{"$f":"IF(L226>300,\"Yes\",\"No\")","v":"No"},{"$f":"IF(M226>300,\"Yes\",\"No\")","v":"No"},"No",{"$f":"IF(O226>300,\"Yes\",\"No\")","v":"No"},{"$f":"IF(P226>300,\"Yes\",\"No\")","v":"No"},{"$f":"IF(Q226>300,\"Yes\",\"No\")","v":"No"},"No",{"$f":"IF(S226>300,\"Yes\",\"No\")","v":"No"},{"$f":"IF(T226>300,\"Yes\",\"No\")","v":"No"},{"$f":"IF(U226>300,\"Yes\",\"No\")","v":"No"},"No",{"$f":"IF(W226>300,\"Yes\",\"No\")","v":"No"},{"$f":"IF(X226>300,\"Yes\",\"No\")","v":"No"},{"$f":"IF(Y226>300,\"Yes\",\"No\")","v":"No"},"No"]
[null,null,null,null,null,null,null,"Is Speed > 20mph and Volume > 300 vphpln",null,null,{"$f":"IF(OR(AND(K225>20,K226>300),AND(K224>20,K226>300)),\"Yes\",\"No\")","v":"No"},{"$f":"IF(OR(AND(L225>20,L226>300),AND(L224>20,L226>300)),\"Yes\",\"No\")","v":"No"},"No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[null,null,null,null,null,null,null,"Is Speed >30 mph",null,null,{"$f":"IF(OR(K225>30,K224>30),\"Yes\",\"No\")","v":"No"},{"$f":"IF(OR(L225>30,L224>30),\"Yes\",\"No\")","v":"No"},"No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[null,null,null,null,null,null,null,"Flag Results",null,null,{"$f":"IF(OR(ISBLANK(K222),K222=\"yes\"),IF(OR(K229=\"Yes\",K230=\"Yes\"),\"Red\",IF(OR(K227=\"Yes\",K228=\"Yes\"),\"Yellow\",\"No\")),\"No\")","v":"No"},{"$f":"IF(OR(ISBLANK(L222),L222=\"yes\"),IF(OR(L229=\"Yes\",L230=\"Yes\"),\"Red\",IF(OR(L227=\"Yes\",L228=\"Yes\"),\"Yellow\",\"No\")),\"No\")","v":"No"},"No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"A236","v":"K: Lane Change Across Motor Vehicle Lanes"}]
[{"$f":"B21","v":"K: Lane Change Across Motor Vehicle Lanes"},null,"Flag Description:\nBicycle movements that require lane changes or \nweaving over motor vehicle travel lanes are both \na safety and comfort concern. Bicyclists have to \nlook over their shoulders to assess available gaps \nfor lane changes while maintaining their trajectory \napproaching the intersection. \nConsiderations:\n◦ This flag should not be confused with those \nwhere motor vehicles cross bicycle lanes, such as \nFlag H.\n◦ In absence of operating speed data, design \nspeed and engineering judgement can be used.\n◦ This flag applies to roadways with and without \nbicycle facilities.",null,null,null,null,null,null,null,"Pedestrian Assessment",null,null,null,"Bicycle Assessment"]
[null,null,null,null,null,null,null,null,null,null,"West","East","North","South","NBL","NBT","NBR","SBL","SBT","SBR","EBL","EBT","EBR","WBL","WBT","WBR"]
[null,null,null,null,null,null,null,"Does this flag apply?"]
[null,null,null,null,null,null,null,"Approach Speed (mph)",null,null,null,null,null,null,{"$f":"$L$60","v":0},{"$f":"$L$60","v":0},0,{"$f":"$L$62","v":0},{"$f":"$L$62","v":0},0,{"$f":"$L$58","v":0},{"$f":"$L$58","v":0},0,{"$f":"$L$56","v":0},{"$f":"$L$56","v":0},0]
[null,null,null,null,null,null,null,"Volume (vph)"]
[null,null,null,null,null,null,null,"Volume (vpd)",null,null,null,null,null,null,{"$f":"O240*10","v":0},{"$f":"P240*10","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,"Is the Speed between 25 - 35 mph?",null,null,null,null,null,null,{"$f":"IF(AND(O239>=25, O239<=35),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AND(P239>=25, P239<=35),\"Yes\",\"No\")","v":"No"},"No","No","No","No","No","No","No","No","No","No"]
[null,null,null,null,null,null,null,"Is the volume between 3000 - 7000 vpd?",null,null,null,null,null,null,{"$f":"IF(AND(O241>=3000, O241<=7000),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AND(P241>=3000, P241<=7000),\"Yes\",\"No\")","v":"No"},"No","No","No","No","No","No","No","No","No","No"]
[null,null,null,null,null,null,null,"Is the Speed > 35 mph?",null,null,null,null,null,null,{"$f":"IF(O239>35,\"Yes\",\"No\")","v":"No"},{"$f":"IF(P239>35,\"Yes\",\"No\")","v":"No"},"No","No","No","No","No","No","No","No","No","No"]
[null,null,null,null,null,null,null,"Is the volume > 7000 vpd?",null,null,null,null,null,null,{"$f":"IF(O241>7000,\"Yes\",\"No\")","v":"No"},{"$f":"IF(P241>7000,\"Yes\",\"No\")","v":"No"},"No","No","No","No","No","No","No","No","No","No"]
[null,null,null,null,null,null,null,"Flag Results",null,null,"N/A","N/A","N/A","N/A",{"$f":"IF(OR(ISBLANK(O238),O238=\"Yes\"),IF(ISBLANK(O240),\"No\",IF(OR(O244=\"Yes\",O245=\"Yes\"),\"Red\",IF(OR(O242=\"Yes\",O243=\"Yes\"),\"Yellow\",\"No\"))),\"No\")","v":"No"},{"$f":"IF(OR(P238=\"\",P238=\"Yes\"),IF(ISBLANK(P240),\"No\",IF(OR(P244=\"Yes\",P245=\"Yes\"),\"Red\",IF(OR(P242=\"Yes\",P243=\"Yes\"),\"Yellow\",\"No\"))),\"No\")","v":"No"},"No","No","No","No","No","No","No","No","No","No"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"A257","v":"L: Channelized Lanes"}]
[{"$f":"B22","v":"L: Channelized Lanes"},null,"Flag Description:\nFor bicyclists, sharing a channelized lane with \nmotorized traffic is both a safety and comfort \nconcern. This flag applies to single-lane \nchannelized lanes (narrow shared space between \ncurbs) and multilane facilities. \nConsiderations:\n◦ Channelization length is defined a length of curbs \non both side.\n◦ For multilane facilities, Flag N could be applied. It \nshould not be double-counted.   \n◦ Does not apply to location where bicycle lane \nis between two lanes in a multilane channelized \narea or when channelization is provided by \nstriping only.\n◦ This flag applies to roadways with and without \nbicycle facilities.",null,null,null,null,null,null,null,"Pedestrian Assessment",null,null,null,"Bicycle Assessment"]
[null,null,null,null,null,null,null,null,null,null,"West","East","North","South","NBL","NBT","NBR","SBL","SBT","SBR","EBL","EBT","EBR","WBL","WBT","WBR"]
[null,null,null,null,null,null,null,"Does this flag apply?"]
[null,null,null,null,null,null,null,"Radius of Curve (ft)"]
[null,null,null,null,null,null,null,"Predicted Right Turn Speed (mph)",null,null,null,null,null,null,{"$f":"3.4415*POWER(O260,0.3861)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,"Right Turn Speed (mph)"]
[null,null,null,null,null,null,null,"Length of Channelization (ft)"]
[null,null,null,null,null,null,null,"Flag Results",null,null,"N/A","N/A","N/A","N/A",{"$f":"IF(OR(ISBLANK(O259),O259=\"Yes\"),IF(OR(O261>35,O262>35,O263>50),\"Red\",IF(OR(AND(O261>=25,O261<=35,O263<=50),AND(O262>=25,O262<=35,O263<=50)),\"Yellow\",\"No\")),\"No\")","v":"No"},{"$f":"IF(OR(ISBLANK(P259),P259=\"Yes\"),IF(OR(P261>35,P262>35,P263>50),\"Red\",IF(OR(AND(P261>=25,P261<=35,P263<=50),AND(P262>=25,P262<=35,P263<=50)),\"Yellow\",\"No\")),\"No\")","v":"No"},"No","No","No","No","No","No","No","No","No","No"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"A280","v":"M: Riding in Shared Lanes"}]
[{"$f":"B23","v":"M: Riding in Shared Lanes"},null,"Flag Description:\nBicyclists sharing a lane with heavy volumes of \nhigher speed vehicles can create a high level of \nstress for bicyclists and an increased likelihood \nof severe injury or death if a bicyclist-motorist \ncollision occurs. \nConsiderations:\n◦ In absence of operating speed data, design \nspeed and engineering judgement can be used.\n◦ Buffered bicycle lanes are exempt from the \nyellow flag but subject to the red flag.\n◦ Separated  and off-street bicycle facilities are \nexempt from both the yellow and red flags.",null,null,null,null,null,null,null,"Pedestrian Assessment",null,null,null,"Bicycle Assessment"]
[null,null,null,null,null,null,null,null,null,null,"West","East","North","South","NBL","NBT","NBR","SBL","SBT","SBR","EBL","EBT","EBR","WBL","WBT","WBR"]
[null,null,null,null,null,null,null,"What on-street bicycle facility is present? "]
[null,null,null,null,null,null,null,"Approach Speed (mph)",null,null,null,null,null,null,{"$f":"$L$60","v":0},{"$f":"$L$60","v":0},0,{"$f":"$L$62","v":0},{"$f":"$L$62","v":0},0,{"$f":"$L$58","v":0},{"$f":"$L$58","v":0},0,{"$f":"$L$56","v":0},{"$f":"$L$56","v":0},0]
[null,null,null,null,null,null,null,"Volume (vphpln)",null,null,null,null,null,null,{"$f":"$F$60","v":0},{"$f":"$H$60","v":0},{"$f":"$J$60","v":0},{"$f":"$F$62","v":0},{"$f":"$H$62","v":0},{"$f":"$J$62","v":0},{"$f":"$F$58","v":0},{"$f":"$H$58","v":0},{"$f":"$J$58","v":0},{"$f":"$F$56","v":0},{"$f":"$H$56","v":0},{"$f":"$J$56","v":0}]
[null,null,null,null,null,null,null,"Volume (vpd)",null,null,null,null,null,null,{"$f":"O284*10","v":0},{"$f":"P284*10","v":0},{"$f":"Q284*10","v":0},{"$f":"R284*10","v":0},{"$f":"S284*10","v":0},{"$f":"T284*10","v":0},{"$f":"U284*10","v":0},{"$f":"V284*10","v":0},{"$f":"W284*10","v":0},{"$f":"X284*10","v":0},{"$f":"Y284*10","v":0},{"$f":"Z284*10","v":0}]
[null,null,null,null,null,null,null,"Is the Speed between 25 - 35 mph?",null,null,null,null,null,null,{"$f":"IF(AND(O283>=25, O283<=35),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AND(P283>=25, P283<=35),\"Yes\",\"No\")","v":"No"},"No","No","No","No","No","No","No","No","No","No"]
[null,null,null,null,null,null,null,"Is the volume between 3000 - 7000 vpd?",null,null,null,null,null,null,{"$f":"IF(AND(O285>=3000, O285<=7000),\"Yes\",\"No\")","v":"No"},{"$f":"IF(AND(P285>=3000, P285<=7000),\"Yes\",\"No\")","v":"No"},"No","No","No","No","No","No","No","No","No","No"]
[null,null,null,null,null,null,null,"Is the Speed > 35 mph?",null,null,null,null,null,null,{"$f":"IF(O283>35,\"Yes\",\"No\")","v":"No"},{"$f":"IF(P283>35,\"Yes\",\"No\")","v":"No"},"No","No","No","No","No","No","No","No","No","No"]
[null,null,null,null,null,null,null,"Is the volume > 7000 vpd?",null,null,null,null,null,null,{"$f":"IF(O285>7000,\"Yes\",\"No\")","v":"No"},{"$f":"IF(P285>7000,\"Yes\",\"No\")","v":"No"},"No","No","No","No","No","No","No","No","No","No"]
[null,null,null,null,null,null,null,"Interim flag results",null,null,null,null,null,null,{"$f":"IF(OR(O288=\"Yes\",O289=\"Yes\"),\"Red\",IF(OR(O286=\"Yes\",O287=\"Yes\"),\"Yellow\",\"No\"))","v":"No"},{"$f":"IF(OR(P288=\"Yes\",P289=\"Yes\"),\"Red\",IF(OR(P286=\"Yes\",P287=\"Yes\"),\"Yellow\",\"No\"))","v":"No"},"No","No","No","No","No","No","No","No","No","No"]
[null,null,null,null,null,null,null,"Flag Results",null,null,"N/A","N/A","N/A","N/A",{"$f":"IF(O282=\"\",\"No\", IF(OR(O282=\"Seperated Bike Lane / Off-street\"),\"No\",IF(AND(O290=\"Yellow\",O282=\"Buffered Bike Lane\"),\"No\",O290)))","v":"No"},{"$f":"IF(P282=\"\",\"No\", IF(OR(P282=\"Seperated Bike Lane / Off-street\"),\"No\",IF(AND(P290=\"Yellow\",P282=\"Buffered Bike Lane\"),\"No\",P290)))","v":"No"},"No","No","No","No","No","No","No","No","No","No"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"A300","v":"N: Riding Between Travel Lanes, Lane Additions, or Lane Merges  "}]
[{"$f":"B24","v":"N: Riding Between Travel Lanes, Lane Additions, or Lane Merges  "},null,"Flag Description:\nBicyclists are often intended to travel between \nvehicle travel lanes, with traffic on both sides of \nthe bicyclists. Two common occurrences that \nwarrant this flag are 1) upstream of intersections, \nwith a bicycle lane between the vehicle right-turn-lane\nand through lane(s) and 2) downstream of \nintersections, with a bike lane between a vehicle \nmerge or acceleration lane and through lane(s).  \nConsiderations:\n◦ Less common flag.\n◦ Do not double count with Flag H. Where both \napply, use only Flag H as the crossing movement \nhas more severe risk. Exceptions include where \nthe configuration is long (>300 feet) or otherwise \nsignificant, in which case both Flag H and N may \nbe used.\n◦ This flag exists even if there is not a bicycle lane, \nsuch as if a bicycle lane is dropped before an \nintersection, but bicyclists are continuing straight.",null,null,null,null,null,null,null,"Pedestrian Assessment",null,null,null,"Bicycle Assessment"]
[null,null,null,null,null,null,null,null,null,null,"West","East","North","South","NBL","NBT","NBR","SBL","SBT","SBR","EBL","EBT","EBR","WBL","WBT","WBR"]
[null,null,null,null,null,null,null,"Are bicyclists routed between travel lanes?  \n(Less Common Flag)"]
[null,null,null,null,null,null,null,"Choose the motor vehicle lane configuration relative to the bike or shared lanes."]
[null,null,null,null,null,null,null,"Flag Results",null,null,"N/A","N/A","N/A","N/A",{"$f":"IF(O302=\"Yes\",IF(O303=\"Lanes merge\",\"Red\",IF(O303=\"Lanes are parallel or diverge\", \"Yellow\",\"No\")),\"No\")","v":"No"},{"$f":"IF(P302=\"Yes\",IF(P303=\"Lanes merge\",\"Red\",IF(P303=\"Lanes are parallel or diverge\", \"Yellow\",\"No\")),\"No\")","v":"No"},"No","No","No","No","No","No","No","No","No","No"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"A320","v":"O: Uncomfortable/ Tight Walking Environment"}]
[{"$f":"B25","v":"O: Uncomfortable/ Tight Walking Environment"},null,null,null,null,null,null,null,null,null,"Pedestrian Assessment",null,null,null,"Bicycle Assessment"]
[null,null,"Flag Description:\nMost sidewalks are used for two-way pedestrian \ntraffic, so sufficient width for passing must be \nprovided. Pedestrians avoid walking immediately \nnext to other modes of traffic or buildings, \nreducing the usable width of the sidewalk. \nConsiderations:\n◦ This design flag can only be yellow and primarily \napplies to pedestrians, but can be applied to \nbicyclists on shared use paths.\n◦ Channelizing islands is an example of an \nenvironment with traffic present on more than \none side.\n◦ ADA requirements must still be met.\n◦ If used for a shared-use path next to a vertical \nobject, the effective width of the path is reduced \nby two feet to account for the shy distance.",null,null,null,null,null,null,null,"West","East","North","South","NBL","NBT","NBR","SBL","SBT","SBR","EBL","EBT","EBR","WBL","WBT","WBR"]
[null,null,null,null,null,null,null,"Walkway width \n(One side Traffic)"]
[null,null,null,null,null,null,null,"Walkway width \n(Two side Traffic)"]
[null,null,null,null,null,null,null,"Walkway width Less than 5ft",null,null,{"$f":"IF(K322>=5,\"No\",IF(K322=\"\",\"\",\"Yes\"))","v":""},"","",""]
[null,null,null,null,null,null,null,"Walkway width Less than 10ft",null,null,{"$f":"IF(K323>=10,\"No\",IF(K323=\"\",\"\",\"Yes\"))","v":""},{"$f":"IF(L323>=10,\"No\",IF(L323=\"\",\"\",\"Yes\"))","v":""},"",""]
[null,null,null,null,null,null,null,"Flag Results",null,null,{"$f":"IF(OR(K324=\"Yes\",K325=\"Yes\"),\"Yellow\",\"No\")","v":"No"},{"$f":"IF(OR(L324=\"Yes\",L325=\"Yes\"),\"Yellow\",\"No\")","v":"No"},{"$f":"IF(OR(M324=\"Yes\",M325=\"Yes\"),\"Yellow\",\"No\")","v":"No"},{"$f":"IF(OR(N324=\"Yes\",N325=\"Yes\"),\"Yellow\",\"No\")","v":"No"},"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"A337","v":"P: Indirect Paths"}]
[{"$f":"B26","v":"P: Indirect Paths"},null,null,null,null,null,null,null,null,null,"Pedestrian Assessment",null,null,null,"Bicycle Assessment"]
[null,null,"Flag Description:\nIndirect, or out-of-direction, paths lead to \ninconvenience, delay, and exposure to more \ncrossing risk for pedestrians and bicyclists. Paths \nthat are inefficient may encourage pedestrians or \nbicyclists into risk taking behavior to use a more \nconvenient path. \nConsiderations:\n◦ For approaches with more than four legs, it may be \nappropriate to consider desire lines across multiple \napproaches rather than only desires lines between \nadjacent approaches.\n◦ This flag applies to roadways with and without \nbicycle facilities.",null,null,null,null,null,null,null,"West","East","North","South","NBL","NBT","NBR","SBL","SBT","SBR","EBL","EBT","EBR","WBL","WBT","WBR"]
[null,null,null,null,null,null,null,"Out of direction travel distance \n(ft)"]
[null,null,null,null,null,null,null,"Distance >= 90 ft (Ped.)\nDistance >= 450 ft (Bike)",null,null,{"$f":"IF(K339>=90, \"Yes\", \"No\")","v":"No"},{"$f":"IF(L339>=90, \"Yes\", \"No\")","v":"No"},"No","No",{"$f":"IF(O339>=450, \"Yes\", \"No\")","v":"No"},{"$f":"IF(P339>=450, \"Yes\", \"No\")","v":"No"},"No","No","No","No","No","No","No","No","No","No"]
[null,null,null,null,null,null,null,"Distance >= 135 ft (Ped.)\nDistance >= 675 ft (Bike)",null,null,{"$f":"IF(K339>=135, \"Yes\", \"No\")","v":"No"},{"$f":"IF(L339>=135, \"Yes\", \"No\")","v":"No"},"No","No",{"$f":"IF(O339>=675, \"Yes\", \"No\")","v":"No"},{"$f":"IF(P339>=675, \"Yes\", \"No\")","v":"No"},"No","No","No","No","No","No","No","No","No","No"]
[null,null,null,null,null,null,null,"Flag Results",null,null,{"$f":"IF(K341=\"Yes\",\"Red\",IF(K340=\"Yes\",\"Yellow\",\"No\"))","v":"No"},{"$f":"IF(L341=\"Yes\",\"Red\",IF(L340=\"Yes\",\"Yellow\",\"No\"))","v":"No"},"No","No",{"$f":"IF(O341=\"Yes\",\"Red\",IF(O340=\"Yes\",\"Yellow\",\"No\"))","v":"No"},{"$f":"IF(P341=\"Yes\",\"Red\",IF(P340=\"Yes\",\"Yellow\",\"No\"))","v":"No"},"No","No","No","No","No","No","No","No","No","No"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"A352","v":"Q: Grade Change"}]
[{"$f":"B27","v":"Q: Grade Change"},null,"Flag Description:\nGrade changes within or immediately next \nto an intersection can created challenges for \npedestrians and bicyclists. For example, initiating \na movement uphill can be challenging for stopped \nbicyclists. Pedestrians may move slower when \nwalking up hill. \nConsiderations:\n◦ The slope of curb ramps should not be considered \nin determining the steepest grade but should still \nconform to ADA requirements. \n◦ This flag applies to roadways with and without \nbicycle facilities.",null,null,null,null,null,null,null,"Pedestrian Assessment",null,null,null,"Bicycle Assessment"]
[null,null,null,null,null,null,null,null,null,null,"West","East","North","South","NBL","NBT","NBR","SBL","SBT","SBR","EBL","EBT","EBR","WBL","WBT","WBR"]
[null,null,null,null,null,null,null,"Percent Grade (%)"]
[null,null,null,null,null,null,null,"+3% to +5% \nOR \n-3% to -5%",null,null,{"$f":"IF(OR(AND(K354>=3,K354<=5),AND(K354>=-5,K354<=-3)),\"Yes\",\"No\")","v":"No"},{"$f":"IF(OR(AND(L354>=3,L354<=5),AND(L354>=-5,L354<=-3)),\"Yes\",\"No\")","v":"No"},"No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[null,null,null,null,null,null,null,"<-5% \nOR\n>+5%",null,null,{"$f":"IF(OR(K354>5,K354<-5),\"Yes\",\"No\")","v":"No"},{"$f":"IF(OR(L354>5,L354<-5),\"Yes\",\"No\")","v":"No"},"No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[null,null,null,null,null,null,null,"Flag Results",null,null,{"$f":"IF(K356=\"Yes\",\"Red\",IF(K355=\"Yes\",\"Yellow\",\"No\"))","v":"No"},{"$f":"IF(L356=\"Yes\",\"Red\",IF(L355=\"Yes\",\"Yellow\",\"No\"))","v":"No"},"No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"A366","v":"R: Non-Intuitive Motor Vehicle Movements"}]
[{"$f":"B28","v":"R: Non-Intuitive Motor Vehicle Movements"},null,null,null,null,null,null,null,null,null,"Pedestrian Assessment",null,null,null,"Bicycle Assessment"]
[null,null,"Flag Description:\nWhen a pedestrian begins crossing the street, \nthe normal expectation is that the first conflicting \nmotor vehicle traffic approaches from the left \nfollowed by conflicts from the right. This flag \nidentifies nonintuitive configurations that violate \nthis expectation. \nConsiderations:\n◦ Less common flag.\n◦ Nonintuitive vehicle movements are common at \ninterchanges.\n◦ This flag does not apply to stop-controlled \ncrossings.",null,null,null,null,null,null,null,"West","East","North","South","NBL","NBT","NBR","SBL","SBT","SBR","EBL","EBT","EBR","WBL","WBT","WBR"]
[null,null,null,null,null,null,null,"Does the route include non-intuitive motor vehicle movements? \n(Less Common Flag)"]
[null,null,null,null,null,null,null,"Vehicle decelerating"]
[null,null,null,null,null,null,null,"Vehicle accelerating or free-flowing"]
[null,null,null,null,null,null,null,"Flag Results",null,null,{"$f":"IF(K368=\"Yes\",IF(K370=\"Yes\",\"Red\",IF(K369=\"Yes\",\"Yellow\",\"No\")),\"No\")","v":"No"},{"$f":"IF(L368=\"Yes\",IF(L370=\"Yes\",\"Red\",IF(L369=\"Yes\",\"Yellow\",\"No\")),\"No\")","v":"No"},"No","No","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"A385","v":"S: Executing Unusual Movements"}]
[{"$f":"B29","v":"S: Executing Unusual Movements"},null,"Flag Description:\nRoadway users have expectations for their travel \npaths and vehicle movements at intersections. \nThis flag captures confusion or uncertainty users \nmay experience when being unsure of how to \ncontinue on the desired path. This flag is most \ncommonly seen at interchanges, one way streets, \nalternative intersections, intersections with \nchannelized turns and multiple crossing stages. \nConsiderations:\n◦ Less common flag.\n◦ This design flag can only be yellow. \n◦ Determining if a movement is unusual likely relies on \nlocal context. It is not intended to cover common but \nundesirable movements. \n◦ A first-of-its-kind design in an area may qualify as an \nunusual movement until familiarity with the design \nbecomes common. "]
[null,null,null,null,null,null,null,null,null,null,"Pedestrian Assessment",null,null,null,"Bicycle Assessment"]
[null,null,null,null,null,null,null,null,null,null,"West","East","North","South","NBL","NBT","NBR","SBL","SBT","SBR","EBL","EBT","EBR","WBL","WBT","WBR"]
[null,null,null,null,null,null,null,"Does the route defy local expectations?  \n(Less Common Flag)"]
[null,null,null,null,null,null,null,"Flag Results",null,null,{"$f":"IF(K388=\"Yes\",\"Yellow\",\"No\")","v":"No"},{"$f":"IF(L388=\"Yes\",\"Yellow\",\"No\")","v":"No"},"No","No","No","No","No","No","No","No","No","No","No","No","No","No"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"A400","v":"T: Off-Tracking  in Turns and Curves"}]
[{"$f":"B30","v":"T: Off-Tracking  in Turns and Curves"},null,"Flag Description:\nDepending on curvature and lane widths, vehicles \nmay off-track into adjacent lanes during u-turn or \nother turning maneuvers, resulting in a comfort \nand safety concern for cyclists. This situation \nis common for heavy trucks, intersections with \nu-turns or multiple left or right turn lanes, and for \nunprotected bicycle lanes on the inside of a curve.\nConsiderations:\n◦ Less common flag.\n◦ Applicable only at locations where vehicle \noff-tracking may encroach into bicycle paths, \nparticularly at conventional bicycle lanes without \nvertical barriers.",null,null,null,null,null,null,null,"Pedestrian Assessment",null,null,null,"Bicycle Assessment"]
[null,null,null,null,null,null,null,null,null,null,"West","East","North","South","NBL","NBT","NBR","SBL","SBT","SBR","EBL","EBT","EBR","WBL","WBT","WBR"]
[null,null,null,null,null,null,null,"Does this flag apply? \n(Less Common Flag)"]
[null,null,null,null,null,null,null,"Can design vehicle make turn without encroaching on bicycle lane?"]
[null,null,null,null,null,null,null,"Flag Results",null,null,"N/A","N/A","N/A","N/A",{"$f":"IF(AND(O402=\"Yes\",O403=\"No\"),\"Red\",IF(AND(O402=\"Yes\",O403=\"Yes\"),\"Yellow\",\"N/A\"))","v":"N/A"},{"$f":"IF(AND(P402=\"Yes\",P403=\"No\"),\"Red\",IF(AND(P402=\"Yes\",P403=\"Yes\"),\"Yellow\",\"N/A\"))","v":"N/A"},{"$f":"IF(AND(Q402=\"Yes\",Q403=\"No\"),\"Red\",IF(AND(Q402=\"Yes\",Q403=\"Yes\"),\"Yellow\",\"N/A\"))","v":"N/A"},"N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]

{"sheet":"Scenario 2","index":3,"n_rows":208,"n_cols":19,"rows_kept":208,"cut":false,"hidden":true,"merged":[[29,3,29,5],[29,6,29,8],[29,9,29,11],[0,0,0,19],[5,3,5,6],[5,7,5,18],[20,3,26,6],[5,0,5,1],[7,7,9,18]]}
["Scenario 2"]
[]
["Intersection Type: \n(REQUIRED FIELD)"]
["Analysis Intersection:",{"$f":"'Scenario 1'!C4","v":0},null," "]
[]
[null,null,null,"Pedestrian Assessment",null,null,null,"Bicycle Assessment"]
["Flag #","Flag","Flag Type","West","East","North","South","NBL","NBT","NBR","SBL","SBT","SBR","EBL","EBT","EBR","WBL","WBT","WBR"]
[1,"Motor Vehicle Right Turn","Primary","Red"]
[2,"Uncomfortable/ Tight Walking Environment","Secondary"]
[3,"Non-Intuitive Motor Vehicle Movement","Secondary",null,"Yellow"]
[4,"Crossing Yield or Uncontrolled Vehicle Paths","Primary"]
[5,"Indirect Paths","Secondary"]
[6,"Executing Unusual Movements","Secondary"]
[7,"Multilane Crossing","Primary"]
[8,"Long Red Times","Secondary"]
[9,"Undefined Crossing at Intersections","Secondary"]
[10,"Motor Vehicle Left Turn","Primary"]
[11,"Intersecting Driveways and Side Streets","Secondary"]
[12,"Sight Distance for Gap Acceptance","Secondary"]
[13,"Grade Change","Secondary"]
[14,"Riding in Mixed Traffic","Primary"]
[15,"Bicycle Clearance Times","Secondary"]
[16,"Lane Change Across Motor Vehicle Lanes","Primary"]
[17,"Channelized Lanes","Primary"]
[18,"Turning Motorists Crossing Bicycle Path","Primary"]
[19,"Riding Between Travel Lanes","Primary"]
[20,"Off-Tracking Trucks in Multi-Lane Curves","Secondary"]
[null,"Total Yellow Flags by Movement",null,{"$f":"COUNTIF(D8:D20,\"yellow\")","v":0},{"$f":"COUNTIF(E8:E20,\"yellow\")","v":1},0,0,{"$f":"COUNTIF(H11:H27,\"yellow\")","v":0},{"$f":"COUNTIF(I11:I27,\"yellow\")","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Total Red Flags by Movement",null,{"$f":"COUNTIF(D8:D20,\"red\")","v":1},{"$f":"COUNTIF(E8:E20,\"red\")","v":0},0,0,{"$f":"COUNTIF(H11:H27,\"red\")","v":0},{"$f":"COUNTIF(I11:I27,\"red\")","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,"TOTAL",null,null,"PRIMARY FLAGS",null,null,"SECONDARY FLAGS"]
[null,null,null,"All","Pedestrian","Bicycle","All","Pedestrian","Bicycle","All","Pedestrian","Bicycle"]
[null,null,"Total Yellow Flags:",{"$f":"COUNTIF(D8:S27, \"Yellow\")","v":1},{"$f":"COUNTIF(D8:G20, \"Yellow\")","v":1},{"$f":"COUNTIF(H$11:S$27, \"Yellow\")","v":0},{"$f":"COUNTIF(D8:G8, \"Yellow\")+COUNTIF(D11:S11, \"Yellow\")+COUNTIF(D14:S14, \"Yellow\")+COUNTIF(D17:S17, \"Yellow\")+COUNTIF(H21:S21, \"Yellow\")+COUNTIF(H23:S26, \"Yellow\")","v":0},{"$f":"COUNTIF(D8:G8, \"Yellow\")+COUNTIF(D11:G11, \"Yellow\")+COUNTIF(D14:G14, \"Yellow\")+COUNTIF(D17:G17, \"Yellow\")","v":0},{"$f":"COUNTIF(H11:S11, \"Yellow\")+COUNTIF(H14:S14, \"Yellow\")+COUNTIF(H17:S17, \"Yellow\")+COUNTIF(H21:S21, \"Yellow\")+COUNTIF(H23:S26, \"Yellow\")","v":0},{"$f":"D32-G32","v":1},{"$f":"E32-H32","v":1},0]
[null,null,"Total Red Flags:",{"$f":"COUNTIF(D8:S27,\"Red\")","v":1},{"$f":"COUNTIF(D8:G20, \"Red\")","v":1},{"$f":"COUNTIF(H11:S27, \"Red\")","v":0},{"$f":"COUNTIF(D8:G8, \"red\")+COUNTIF(D11:S11, \"red\")+COUNTIF(D14:S14, \"red\")+COUNTIF(D17:S17, \"red\")+COUNTIF(H21:S21, \"red\")+COUNTIF(H23:S26, \"red\")","v":1},{"$f":"COUNTIF(D8:G8, \"red\")+COUNTIF(D11:G11, \"red\")+COUNTIF(D14:G14, \"red\")+COUNTIF(D17:G17, \"red\")","v":1},{"$f":"COUNTIF(H11:S11, \"red\")+COUNTIF(H14:S14, \"red\")+COUNTIF(H17:S17, \"red\")+COUNTIF(H21:S21, \"red\")+COUNTIF(H23:S26, \"red\")","v":0},{"$f":"D33-G33","v":0},0,0]
[null,null,"Total No Flags:",{"$f":"COUNTIF(D8:S27,\"No Flag\")","v":0},{"$f":"COUNTIF(D8:G20, \"No Flag\")","v":0},{"$f":"COUNTIF(H11:S27, \"No Flag\")","v":0},{"$f":"COUNTIF(D8:G8, \"No Flag\")+COUNTIF(D11:S11, \"No Flag\")+COUNTIF(D14:S14, \"No Flag\")+COUNTIF(D17:S17, \"No Flag\")+COUNTIF(H21:S21, \"No Flag\")+COUNTIF(H23:S26, \"No Flag\")","v":0},{"$f":"COUNTIF(D8:G8, \"No Flag\")+COUNTIF(D11:G11, \"No Flag\")+COUNTIF(D14:G14, \"No Flag\")+COUNTIF(D17:G17, \"No Flag\")","v":0},{"$f":"COUNTIF(H11:S11, \"No Flag\")+COUNTIF(H14:S14, \"No Flag\")+COUNTIF(H17:S17, \"No Flag\")+COUNTIF(H21:S21, \"No Flag\")+COUNTIF(H23:S26, \"No Flag\")","v":0},0,0,0]
[null,null,"Total N/A:",{"$f":"COUNTIF(D8:S27,\"N/A\")","v":0},{"$f":"COUNTIF(D8:G20, \"N/A\")","v":0},{"$f":"COUNTIF(H11:S27, \"N/A\")","v":0},{"$f":"COUNTIF(D8:G8, \"N/A\")+COUNTIF(D11:S11, \"N/A\")+COUNTIF(D14:S14, \"N/A\")+COUNTIF(D17:S17, \"N/A\")+COUNTIF(H21:S21, \"N/A\")+COUNTIF(H23:S26, \"N/A\")","v":0},{"$f":"COUNTIF(D8:G8, \"N/A\")+COUNTIF(D11:G11, \"N/A\")+COUNTIF(D14:G14, \"N/A\")+COUNTIF(D17:G17, \"N/A\")","v":0},{"$f":"COUNTIF(H11:S11, \"N/A\")+COUNTIF(H14:S14, \"N/A\")+COUNTIF(H17:S17, \"N/A\")+COUNTIF(H21:S21, \"N/A\")+COUNTIF(H23:S26, \"N/A\")","v":0},0,0,0]
[null,null,"Total Possible:",{"$f":"(13*4)+(12*17)-D35","v":256},{"$f":"(13*4)-E35","v":52},{"$f":"(12*17)-F35","v":204},{"$f":"(1*4)+(3*16)+5*12","v":112},16,{"$f":"8*12","v":96},144,36,108]
[null,null,"Percent Yellow:",{"$f":"D32/D36","v":3.90625E-3},1.9230769230769232E-2,0,0,0,0,6.9444444444444441E-3,2.7777777777777776E-2,0]
[null,null,"Percent Red:",{"$f":"D33/D36","v":3.90625E-3},1.9230769230769232E-2,0,8.9285714285714281E-3,6.25E-2,0,0,0,0]
[null,null,"Percent Not Flagged:",{"$f":"100%-SUM(D37:D38)","v":0.9921875},0.96153846153846156,1,0.9910714285714286,0.9375,1,0.99305555555555558,0.97222222222222221,1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Input"]
[null,null,null,"Yellow"]
[null,null,null,"Red"]
[null,null,null,"No Flag"]
[null,null,null,"N/A"]

{"sheet":"Scenario 3","index":4,"n_rows":208,"n_cols":19,"rows_kept":208,"cut":false,"hidden":true,"merged":[[29,3,29,5],[29,6,29,8],[29,9,29,11],[0,0,0,19],[5,3,5,6],[5,7,5,18],[20,3,26,6],[5,0,5,1],[7,7,9,18]]}
["Scenario 3"]
[]
["Intersection Type: \n(REQUIRED FIELD)",3]
["Analysis Intersection:",{"$f":"'Scenario 1'!C4","v":0},null," "]
[]
[null,null,null,"Pedestrian Assessment",null,null,null,"Bicycle Assessment"]
["Flag #","Flag","Flag Type","West","East","North","South","NBL","NBT","NBR","SBL","SBT","SBR","EBL","EBT","EBR","WBL","WBT","WBR"]
[1,"Motor Vehicle Right Turn","Primary","Red"]
[2,"Uncomfortable/ Tight Walking Environment","Secondary"]
[3,"Non-Intuitive Motor Vehicle Movement","Secondary"]
[4,"Crossing Yield or Uncontrolled Vehicle Paths","Primary"]
[5,"Indirect Paths","Secondary"]
[6,"Executing Unusual Movements","Secondary"]
[7,"Multilane Crossing","Primary"]
[8,"Long Red Times","Secondary"]
[9,"Undefined Crossing at Intersections","Secondary"]
[10,"Motor Vehicle Left Turn","Primary"]
[11,"Intersecting Driveways and Side Streets","Secondary"]
[12,"Sight Distance for Gap Acceptance","Secondary"]
[13,"Grade Change","Secondary"]
[14,"Riding in Mixed Traffic","Primary"]
[15,"Bicycle Clearance Times","Secondary"]
[16,"Lane Change Across Motor Vehicle Lanes","Primary"]
[17,"Channelized Lanes","Primary"]
[18,"Turning Motorists Crossing Bicycle Path","Primary"]
[19,"Riding Between Travel Lanes","Primary"]
[20,"Off-Tracking Trucks in Multi-Lane Curves","Secondary"]
[null,"Total Yellow Flags by Movement",null,{"$f":"COUNTIF(D8:D20,\"yellow\")","v":0},{"$f":"COUNTIF(E8:E20,\"yellow\")","v":0},0,0,{"$f":"COUNTIF(H11:H27,\"yellow\")","v":0},{"$f":"COUNTIF(I11:I27,\"yellow\")","v":0},0,0,0,0,0,0,0,0,0,0]
[null,"Total Red Flags by Movement",null,{"$f":"COUNTIF(D8:D20,\"red\")","v":1},{"$f":"COUNTIF(E8:E20,\"red\")","v":0},0,0,{"$f":"COUNTIF(H11:H27,\"red\")","v":0},{"$f":"COUNTIF(I11:I27,\"red\")","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,"TOTAL",null,null,"PRIMARY FLAGS",null,null,"SECONDARY FLAGS"]
[null,null,null,"All","Pedestrian","Bicycle","All","Pedestrian","Bicycle","All","Pedestrian","Bicycle"]
[null,null,"Total Yellow Flags:",{"$f":"COUNTIF(D8:S27, \"Yellow\")","v":0},{"$f":"COUNTIF(D8:G20, \"Yellow\")","v":0},{"$f":"COUNTIF(H$11:S$27, \"Yellow\")","v":0},{"$f":"COUNTIF(D8:G8, \"Yellow\")+COUNTIF(D11:S11, \"Yellow\")+COUNTIF(D14:S14, \"Yellow\")+COUNTIF(D17:S17, \"Yellow\")+COUNTIF(H21:S21, \"Yellow\")+COUNTIF(H23:S26, \"Yellow\")","v":0},{"$f":"COUNTIF(D8:G8, \"Yellow\")+COUNTIF(D11:G11, \"Yellow\")+COUNTIF(D14:G14, \"Yellow\")+COUNTIF(D17:G17, \"Yellow\")","v":0},{"$f":"COUNTIF(H11:S11, \"Yellow\")+COUNTIF(H14:S14, \"Yellow\")+COUNTIF(H17:S17, \"Yellow\")+COUNTIF(H21:S21, \"Yellow\")+COUNTIF(H23:S26, \"Yellow\")","v":0},{"$f":"D32-G32","v":0},{"$f":"E32-H32","v":0},0]
[null,null,"Total Red Flags:",{"$f":"COUNTIF(D8:S27,\"Red\")","v":1},{"$f":"COUNTIF(D8:G20, \"Red\")","v":1},{"$f":"COUNTIF(H11:S27, \"Red\")","v":0},{"$f":"COUNTIF(D8:G8, \"red\")+COUNTIF(D11:S11, \"red\")+COUNTIF(D14:S14, \"red\")+COUNTIF(D17:S17, \"red\")+COUNTIF(H21:S21, \"red\")+COUNTIF(H23:S26, \"red\")","v":1},{"$f":"COUNTIF(D8:G8, \"red\")+COUNTIF(D11:G11, \"red\")+COUNTIF(D14:G14, \"red\")+COUNTIF(D17:G17, \"red\")","v":1},{"$f":"COUNTIF(H11:S11, \"red\")+COUNTIF(H14:S14, \"red\")+COUNTIF(H17:S17, \"red\")+COUNTIF(H21:S21, \"red\")+COUNTIF(H23:S26, \"red\")","v":0},{"$f":"D33-G33","v":0},0,0]
[null,null,"Total No Flags:",{"$f":"COUNTIF(D8:S27,\"No Flag\")","v":0},{"$f":"COUNTIF(D8:G20, \"No Flag\")","v":0},{"$f":"COUNTIF(H11:S27, \"No Flag\")","v":0},{"$f":"COUNTIF(D8:G8, \"No Flag\")+COUNTIF(D11:S11, \"No Flag\")+COUNTIF(D14:S14, \"No Flag\")+COUNTIF(D17:S17, \"No Flag\")+COUNTIF(H21:S21, \"No Flag\")+COUNTIF(H23:S26, \"No Flag\")","v":0},{"$f":"COUNTIF(D8:G8, \"No Flag\")+COUNTIF(D11:G11, \"No Flag\")+COUNTIF(D14:G14, \"No Flag\")+COUNTIF(D17:G17, \"No Flag\")","v":0},{"$f":"COUNTIF(H11:S11, \"No Flag\")+COUNTIF(H14:S14, \"No Flag\")+COUNTIF(H17:S17, \"No Flag\")+COUNTIF(H21:S21, \"No Flag\")+COUNTIF(H23:S26, \"No Flag\")","v":0},0,0,0]
[null,null,"Total N/A:",{"$f":"COUNTIF(D8:S27,\"N/A\")","v":0},{"$f":"COUNTIF(D8:G20, \"N/A\")","v":0},{"$f":"COUNTIF(H11:S27, \"N/A\")","v":0},{"$f":"COUNTIF(D8:G8, \"N/A\")+COUNTIF(D11:S11, \"N/A\")+COUNTIF(D14:S14, \"N/A\")+COUNTIF(D17:S17, \"N/A\")+COUNTIF(H21:S21, \"N/A\")+COUNTIF(H23:S26, \"N/A\")","v":0},{"$f":"COUNTIF(D8:G8, \"N/A\")+COUNTIF(D11:G11, \"N/A\")+COUNTIF(D14:G14, \"N/A\")+COUNTIF(D17:G17, \"N/A\")","v":0},{"$f":"COUNTIF(H11:S11, \"N/A\")+COUNTIF(H14:S14, \"N/A\")+COUNTIF(H17:S17, \"N/A\")+COUNTIF(H21:S21, \"N/A\")+COUNTIF(H23:S26, \"N/A\")","v":0},0,0,0]
[null,null,"Total Possible:",{"$f":"(13*4)+(12*17)-D35","v":256},{"$f":"(13*4)-E35","v":52},{"$f":"(12*17)-F35","v":204},{"$f":"(1*4)+(3*16)+5*12","v":112},16,{"$f":"8*12","v":96},144,36,108]
[null,null,"Percent Yellow:",{"$f":"D32/D36","v":0},0,0,0,0,0,0,0,0]
[null,null,"Percent Red:",{"$f":"D33/D36","v":3.90625E-3},1.9230769230769232E-2,0,8.9285714285714281E-3,6.25E-2,0,0,0,0]
[null,null,"Percent Not Flagged:",{"$f":"100%-SUM(D37:D38)","v":0.99609375},0.98076923076923073,1,0.9910714285714286,0.9375,1,1,1,1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Input"]
[null,null,null,"Yellow"]
[null,null,null,"Red"]
[null,null,null,"No Flag"]
[null,null,null,"N/A"]

{"sheet":"Results","index":5,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":true,"merged":[[11,0,13,0],[3,0,4,1],[5,0,7,0],[8,0,10,0],[0,0,0,17],[1,2,1,4],[1,6,1,8],[1,10,1,12]]}
["Results Summary"]
["Intersection:",null,"TOTAL",null,null,null,"PRIMARY FLAGS",null,null,null,"SECONDARY FLAGS"]
[]
[null,null,"Scenario 1","Scenario 2","Scenario 3",null,"Scenario 1","Scenario 2","Scenario 3",null,"Scenario 1","Scenario 2","Scenario 3"]
[null,null,{"$f":"IF(ISBLANK('Scenario 1'!C3),\"-\",'Scenario 1'!C3)","v":"-"},{"$f":"IF(ISBLANK('Scenario 2'!B3),\"-\",'Scenario 2'!B3)","v":"-"},{"$f":"IF(ISBLANK('Scenario 3'!B3),\"-\",'Scenario 3'!B3)","v":3},null,{"$f":"C5","v":"-"},{"$f":"D5","v":"-"},{"$f":"E5","v":3},null,{"$f":"C5","v":"-"},{"$f":"D5","v":"-"},{"$f":"E5","v":3}]
["Pedestrian","Percent Yellow Flags",{"$f":"IF(C5=\"-\",\"-\",'Scenario 1'!E42)","v":"-"},{"$f":"IF(D5=\"-\",\"-\",'Scenario 2'!E37)","v":"-"},{"$f":"IF(E5=\"-\",\"-\",'Scenario 3'!E37)","v":0},null,{"$f":"IF(G5=\"-\",\"-\",'Scenario 1'!H42)","v":"-"},{"$f":"IF(H5=\"-\",\"-\",'Scenario 2'!H37)","v":"-"},{"$f":"IF(I5=\"-\",\"-\",'Scenario 3'!H37)","v":0},null,{"$f":"IF(K5=\"-\",\"-\",'Scenario 1'!K42)","v":"-"},{"$f":"IF(L5=\"-\",\"-\",'Scenario 2'!K37)","v":"-"},{"$f":"IF(M5=\"-\",\"-\",'Scenario 3'!K37)","v":0}]
[null,"Percent Red Flags",{"$f":"IF(C5=\"-\",\"-\",'Scenario 1'!E43)","v":"-"},{"$f":"IF(D5=\"-\",\"-\",'Scenario 2'!E38)","v":"-"},{"$f":"IF(E5=\"-\",\"-\",'Scenario 3'!E38)","v":1.9230769230769232E-2},null,{"$f":"IF(G5=\"-\",\"-\",'Scenario 1'!H43)","v":"-"},{"$f":"IF(H5=\"-\",\"-\",'Scenario 2'!H38)","v":"-"},{"$f":"IF(I5=\"-\",\"-\",'Scenario 3'!H38)","v":6.25E-2},null,{"$f":"IF(K5=\"-\",\"-\",'Scenario 1'!K43)","v":"-"},{"$f":"IF(L5=\"-\",\"-\",'Scenario 2'!K38)","v":"-"},{"$f":"IF(M5=\"-\",\"-\",'Scenario 3'!K38)","v":0}]
[null,"Percent Not Flagged",{"$f":"IF(C5=\"-\",\"-\",'Scenario 1'!E44)","v":"-"},{"$f":"IF(D5=\"-\",\"-\",'Scenario 2'!E39)","v":"-"},{"$f":"IF(E5=\"-\",\"-\",'Scenario 3'!E39)","v":0.98076923076923073},null,{"$f":"IF(G5=\"-\",\"-\",'Scenario 1'!H44)","v":"-"},{"$f":"IF(H5=\"-\",\"-\",'Scenario 2'!H39)","v":"-"},{"$f":"IF(I5=\"-\",\"-\",'Scenario 3'!H39)","v":0.9375},null,{"$f":"IF(K5=\"-\",\"-\",'Scenario 1'!K44)","v":"-"},{"$f":"IF(L5=\"-\",\"-\",'Scenario 2'!K39)","v":"-"},{"$f":"IF(M5=\"-\",\"-\",'Scenario 3'!K39)","v":1}]
["Bicycle","Percent Yellow Flags",{"$f":"IF(C5=\"-\",\"-\",'Scenario 1'!F42)","v":"-"},{"$f":"IF(D5=\"-\",\"-\",'Scenario 2'!F37)","v":"-"},{"$f":"IF(E5=\"-\",\"-\",'Scenario 3'!F37)","v":0},null,{"$f":"IF(G5=\"-\",\"-\",'Scenario 1'!I42)","v":"-"},{"$f":"IF(H5=\"-\",\"-\",'Scenario 2'!I37)","v":"-"},{"$f":"IF(I5=\"-\",\"-\",'Scenario 3'!I37)","v":0},null,{"$f":"IF(K5=\"-\",\"-\",'Scenario 1'!L42)","v":"-"},{"$f":"IF(L5=\"-\",\"-\",'Scenario 2'!L37)","v":"-"},{"$f":"IF(M5=\"-\",\"-\",'Scenario 3'!L37)","v":0}]
[null,"Percent Red Flags",{"$f":"IF(C5=\"-\",\"-\",'Scenario 1'!F43)","v":"-"},{"$f":"IF(D5=\"-\",\"-\",'Scenario 2'!F38)","v":"-"},{"$f":"IF(E5=\"-\",\"-\",'Scenario 3'!F38)","v":0},null,{"$f":"IF(G5=\"-\",\"-\",'Scenario 1'!I43)","v":"-"},{"$f":"IF(H5=\"-\",\"-\",'Scenario 2'!I38)","v":"-"},{"$f":"IF(I5=\"-\",\"-\",'Scenario 3'!I38)","v":0},null,{"$f":"IF(K5=\"-\",\"-\",'Scenario 1'!L43)","v":"-"},{"$f":"IF(L5=\"-\",\"-\",'Scenario 2'!L38)","v":"-"},{"$f":"IF(M5=\"-\",\"-\",'Scenario 3'!L38)","v":0}]
[null,"Percent Not Flagged",{"$f":"IF(C5=\"-\",\"-\",'Scenario 1'!F44)","v":"-"},{"$f":"IF(D5=\"-\",\"-\",'Scenario 2'!F39)","v":"-"},{"$f":"IF(E5=\"-\",\"-\",'Scenario 3'!F39)","v":1},null,{"$f":"IF(G5=\"-\",\"-\",'Scenario 1'!I44)","v":"-"},{"$f":"IF(H5=\"-\",\"-\",'Scenario 2'!I39)","v":"-"},{"$f":"IF(I5=\"-\",\"-\",'Scenario 3'!I39)","v":1},null,{"$f":"IF(K5=\"-\",\"-\",'Scenario 1'!L44)","v":"-"},{"$f":"IF(L5=\"-\",\"-\",'Scenario 2'!L39)","v":"-"},{"$f":"IF(M5=\"-\",\"-\",'Scenario 3'!L39)","v":1}]
["All","Percent Yellow Flags",{"$f":"IF(C5=\"-\",\"-\",'Scenario 1'!D42)","v":"-"},{"$f":"IF(D5=\"-\",\"-\",'Scenario 2'!D37)","v":"-"},{"$f":"IF(E5=\"-\",\"-\",'Scenario 3'!D37)","v":0},null,{"$f":"IF(G5=\"-\",\"-\",'Scenario 1'!G42)","v":"-"},{"$f":"IF(H5=\"-\",\"-\",'Scenario 2'!G37)","v":"-"},{"$f":"IF(I5=\"-\",\"-\",'Scenario 3'!G37)","v":0},null,{"$f":"IF(K5=\"-\",\"-\",'Scenario 1'!J42)","v":"-"},{"$f":"IF(L5=\"-\",\"-\",'Scenario 2'!J37)","v":"-"},{"$f":"IF(M5=\"-\",\"-\",'Scenario 3'!J37)","v":0}]
[null,"Percent Red Flags",{"$f":"IF(C5=\"-\",\"-\",'Scenario 1'!D43)","v":"-"},{"$f":"IF(D5=\"-\",\"-\",'Scenario 2'!D38)","v":"-"},{"$f":"IF(E5=\"-\",\"-\",'Scenario 3'!D38)","v":3.90625E-3},null,{"$f":"IF(G5=\"-\",\"-\",'Scenario 1'!G43)","v":"-"},{"$f":"IF(H5=\"-\",\"-\",'Scenario 2'!G38)","v":"-"},{"$f":"IF(I5=\"-\",\"-\",'Scenario 3'!G38)","v":8.9285714285714281E-3},null,{"$f":"IF(K5=\"-\",\"-\",'Scenario 1'!J43)","v":"-"},{"$f":"IF(L5=\"-\",\"-\",'Scenario 2'!J38)","v":"-"},{"$f":"IF(M5=\"-\",\"-\",'Scenario 3'!J38)","v":0}]
[null,"Percent Not Flagged",{"$f":"IF(C5=\"-\",\"-\",'Scenario 1'!D44)","v":"-"},{"$f":"IF(D5=\"-\",\"-\",'Scenario 2'!D39)","v":"-"},{"$f":"IF(E5=\"-\",\"-\",'Scenario 3'!D39)","v":0.99609375},null,{"$f":"IF(G5=\"-\",\"-\",'Scenario 1'!G44)","v":"-"},{"$f":"IF(H5=\"-\",\"-\",'Scenario 2'!G39)","v":"-"},{"$f":"IF(I5=\"-\",\"-\",'Scenario 3'!G39)","v":0.9910714285714286},null,{"$f":"IF(K5=\"-\",\"-\",'Scenario 1'!J44)","v":"-"},{"$f":"IF(L5=\"-\",\"-\",'Scenario 2'!J39)","v":"-"},{"$f":"IF(M5=\"-\",\"-\",'Scenario 3'!J39)","v":1}]