{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Proposed Stops Checklist"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Proposed Stops Checklist","index":0,"n_rows":110,"n_cols":38,"rows_kept":110,"cut":false,"hidden":false,"merged":[[0,0,0,6],[32,1,32,2],[29,1,29,4],[28,1,28,4],[1,0,1,6]]}
["Checklist for Potential New Transit Stops"]
["FL-AL TPO accepted on July 8, 2015"]
["Analysis Element - ADA Accessibility","Determination","Score","Weighting","Weighted Score","Notes","Other Information"]
["Can the proposed stop location be made ADA compliant?","Yes with modifications",{"$f":"IF(B4=$Y$108, 2, IF(B4=$Y$109, 0, IF(B4=$Y$110, 1, IF(B4=\"\",\"\"))))","v":1},1,{"$f":"IF(C4=\"\",\"\",C4*D4)","v":1},"All new proposed stop locations should be ADA accessible. If it is not feasible (physically or financially) to make the proposed stop ADA accesible an alternate location should be chosen"]
["Analysis Element - Origin Metrics","Determination","Score","Weighting","Weighted Score","Notes","Other Information"]
["How many routes serve the potential stop?","1 Route",{"$f":"IF(B6=$AJ$106,0,IF(B6=$AJ$107,1,IF(B6=$AJ$108,2,IF(B6=$AJ$109,3, IF(B6=\"\",\"\")))))","v":1},1,{"$f":"IF(C6=\"\",\"\",C6*D6)","v":1}]
["Can a short route deviation accommodate a new market/ridership area?","Yes ",{"$f":"IF(B7=$Y$108, 1, IF(B7=$Y$109, 0, IF(B7=\"\",\"\")))","v":1},1,{"$f":"IF(C7=\"\",\"\",C7*D7)","v":1},"Sometimes a small deviation of a current route can be made to access new markets"]
["What is the average number of boarding and alightings at the two nearest existing stops?","Greater than 20 but less than 40 Daily Boardings/Alightings",{"$f":"IF(B8=$AL$108, 0, IF(B8=$AL$109, 1, IF(B8=$AL$110, 2, IF(B8=\"\",\"\"))))","v":1},1,1,"High numbers of boardings and alightings at ajacent stops could signify the need for an additional stop. The average number of daily boardings/alightings at each ECAT bus stop is 12.7"]
["Population density range within 1/4 mile","5 or less people per acre",{"$f":"IF(B9=$Z$107, 0, IF(B9=$Z$108, 1, IF(B9=$Z$109, 2, IF(B9=\"\",\"\"))))","v":0},1,0,"Escambia County has an average of 2.48 persons per household","US Census Bureau"]
["Primary residential dwelling unit type at origin","Single family, large lots",{"$f":"IF(B10=$AA$108, 0, IF(B10=$AA$109, 1, IF(B10=\"\",\"\")))","v":0},1,0,"Neighborhoods with small lot single family homes and multi-family homes are more condusive to transit use","Accessing Transit Version II 2008"]
["What is the predominate type of street grid pattern in the surrounding area?","Rural grid",{"$f":"IF(B11=$AG$107, 2, IF(B11=$AG$108, 1, IF(B11=$AG$109, 0, IF(B11=\"\",\"\"))))","v":0},1,0,"Gridded street patterns allow for better access to transit stops","PACE Transit Supportive Guidelines"]
["Median household income within 1/4 mile","< $20,000 per household",{"$f":"IF(B12=$AB$108, 1, IF(B12=$AB$109, 0, IF(B12=\"\",\"\")))","v":1},1,1,"Households that earn less than $20,000 annually use transit 4 times as much as higher income groups","CHPC Building and Preserving Affordable Homes Near Transit"]
["Zero vehicle households within 1/4 mile","10-20% households",{"$f":"IF(B13=$AE$107,0,IF(B13=$AE$108,1,IF(B13=$AE$109,2,IF(B13=$AE$110,3, IF(B13=\"\",\"\")))))","v":1},1,1,"48.5% of transit riders do not own a car","CHPC Building and Preserving Affordable Homes Near Transit"]
["Persons with disabilities with 1/4 mile",">20%",{"$f":"IF(B14=$AI$107, 0, IF(B14=$AI$108, 1, IF(B14=$AI$109, 2, IF(B14=\"\",\"\"))))","v":2},1,2]
["Percentage of older adults (65 years and older) within 1/4 mile","10-20%",{"$f":"IF(B15=$AI$107, 0, IF(B15=$AI$108, 1, IF(B15=$AI$109, 2, IF(B15=\"\",\"\"))))","v":1},1,1,"Over 20.2% of older adults do not drive compared to 6.9% of adults age 19-64.","Estimating the Impacts of the Aging Population on Transit Ridership NCHRP 20-65"]
["Analysis Element - Destination Metrics","Determination","Score","Weighting","Weighted Score","Notes","Source"]
["Employment density within 1/4 mile","2 or less employees per acre",{"$f":"IF(B17=$AC$107, 0, IF(B17=$AC$108, 1, IF(B17=$AC$109, 2, IF(B17=\"\",\"\"))))","v":0},1,{"$f":"IF(C17=\"\",\"\",C17*D17)","v":0},null,"Accessing Transit Version II 2008"]
["Is a major employment center with greater than 50 employees within 1/4 mile","No",{"$f":"IF(B18=$AD$107, 0, IF(B18=$AD$108, 1, IF(B18=$AD$109, 2, IF(B18=\"\",\"\"))))","v":0},1,0,"Areas with 40-50+ employees per acres support transit service"]
["Is a major activity center located within 1/4 mile","No",{"$f":"IF(B19=$Y$108, 1, IF(B19=$Y$109, 0, IF(B19=\"\",\"\")))","v":0},1,0,"Activity centers typically include education facilities, hospitals/health services, government and social services, shopping centers, entertainment"]
["Analysis Element - Physical Site Characteristics","Determination","Score","Weighting","Weighted Score","Notes"]
["Is there a sidewalk adjacent or near the proposed stop?","Yes ",{"$f":"IF(B21=$Y$108, 1, IF(B21=$Y$109, 0, IF(B21=\"\",\"\")))","v":1},1,1]
["If a sidewalk is present, is the sidewalk at least 5 ft. wide?","Yes",{"$f":"IF(B22=$AK$107, 0, IF(B22=$AK$108, 1, IF(B22=$AK$109, 0, IF(B22=\"\",\"\"))))","v":1},1,1]
["If a sidewalk there is a nearby or adjacent sidewalk, are curb cuts present?","No Sidewalk Present",{"$f":"IF(B23=$AK$107, 0, IF(B23=$AK$108, 1, IF(B23=$AK$109, 0, IF(B23=\"\",\"\"))))","v":0},1,0]
["Is there a pedestrian crossing (i.e. crosswalk) near the proposed stop?","Yes ",{"$f":"IF(B24=$Y$108, 1, IF(B24=$Y$109, 0, IF(B24=\"\",\"\")))","v":1},1,1]
["Is there available ROW to install a 5'x8' loading pad at the proposed stop site?","No",{"$f":"IF(B25=$Y$108, 1, IF(B25=$Y$109, 0, IF(B25=\"\",\"\")))","v":0},1,0]
["Is there available ROW to connect loading pad to nearby sidewalk?","Yes ",{"$f":"IF(B26=$Y$108, 1, IF(B26=$Y$109, 0, IF(B26=\"\",\"\")))","v":1},1,1]
[]
[]
[null,{"$f":"IF(B4=$Y$110,\"Proposed Site Location Will Require Modifications to be Made ADA Accessible \",\"\")","v":"Proposed Site Location Will Require Modifications to be Made ADA Accessible "}]
[null,{"$f":"IF(B4=$Y$109,\"WARNING: Proposed Site Location Cannot Be Made ADA Accessible\",\"\")","v":""}]
[null,"Total Score:",{"$f":"SUM(C4:C27)","v":13},"Total Weighted Score:",{"$f":"SUM(E4:E27)","v":13}]
[]
[null,"Scoring Range"]
[null,"0-10","Least Desirable"]
[null,"11-19","Somewhat Desirable"]
[null,"20+","Most Desirable"]
[]
[]
["Is the proposed location eligible for an amenity?",{"$f":"IF(B8=$AL$108, \"No\", IF(B8=$AL$109, \"Eligible for Bench\", IF(B8=$AL$110, \"Eligible for Shelter\")))","v":"Eligible for Bench"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Not on an existing route"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5 or less people per acre",null,null,"2 or less employees per acre","No","< 10% households",null,"Traditional urban grid","Greater than 20","Less than 10%","1 Route","No Sidewalk Present"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes ","Greater than 5 people per acre","Single family, large lots","< $20,000 per household","2-40 employees per acre","50-100 employees","10-20% households","Yes","Traditional suburban grid","Less than 20","10-20%","2 Routes","Yes","<20 Daily Boardings/Alightings"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No","Greater than 10 people per acre","Single family, small lots and/or multi-family","> $20,000 per household","40+ employees per acre","100+ employees","21-30% households","No","Rural grid",null,">20%","3 or more Routes","No   ","Greater than 20 but less than 40 Daily Boardings/Alightings"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes with modifications",null,null,null,null,null,"> 30% households",null,null,null,null,null,null,">40 Daily Boardings/Alightings"]