{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["1. Trip Generation","2. MMLOS","3. TDM","SUMMARY","Narrative Prompts","OUTPUT","Maximum Calcs","Neighborhood","Transit","CTR","Assumptions","Info_Notes","Glossary"],"not_rendered":{"charts":0,"images":23,"macros":1,"external_links":0,"defined_names":9,"comments":5,"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":"1. Trip Generation","index":0,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":false,"merged":[[18,1,18,7],[0,0,0,7],[15,1,15,7],[43,0,44,6],[2,0,2,7],[36,1,36,3],[36,4,36,6],[22,2,22,7],[23,2,23,4],[23,5,23,7],[30,0,30,1],[34,1,34,6],[35,1,35,6],[20,0,20,1],[17,1,17,7],[16,1,16,7],[22,1,24,1],[22,0,24,0],[31,0,32,7]]}
["Trip Generation"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"= input"]
[null,"= calculation"]
[]
["DATE:"]
["PROJECT NAME:"]
["PROJECT ADDRESS:"]
["APPLICANT CONTACT INFORMATION:\nNAME, COMPANY, ADDRESS, PHONE, EMAIL","Name\nCompany\nAddress\nPhone\nEmail"]
[]
["Is this a major or minor project?"]
[]
["Proposed Land Use","Net New Units/Square Feet of the Proposed Project","Trips Generated"]
[null,null,"AM Peak-Hour",null,null,"PM Peak-Hour"]
[null,null,"Entering","Exiting","Total","Entering","Exiting","Total"]
["Commercial (sf)",0,{"$f":"(B26/1000)*B39*C39","v":0},{"$f":"B39*D39*(B26/1000)","v":0},{"$f":"(B26/1000)*B39","v":0},{"$f":"(B26/1000)*E39*F39","v":0},{"$f":"(B26/1000)*E39*G39","v":0},{"$f":"(B26/1000)*E39","v":0}]
["Free-Market Housing (Units)",0,{"$f":"B27*B40*C40","v":0},{"$f":"B40*D40*B27","v":0},{"$f":"B27*B40","v":0},{"$f":"B27*E40*F40","v":0},{"$f":"B27*E40*G40","v":0},{"$f":"B27*E40","v":0}]
["Affordable Housing (Units)",0,{"$f":"B28*B41*C41","v":0},{"$f":"B41*D41*B28","v":0},{"$f":"B28*B41","v":0},{"$f":"B28*E41*F41","v":0},{"$f":"B28*E41*G41","v":0},{"$f":"B28*E41","v":0}]
["Lodging (Units)",0,{"$f":"B29*B42*C42","v":0},{"$f":"B42*D42*B29","v":0},{"$f":"B29*B42","v":0},{"$f":"B29*E42*F42","v":0},{"$f":"B29*E42*G42","v":0},{"$f":"B29*E42","v":0}]
["Essential Public Facility (sf)",0,{"$f":"(B30/1000)*B43*C43","v":0},{"$f":"B43*D43*(B30/1000)","v":0},{"$f":"(B30/1000)*B43","v":0},{"$f":"(B30/1000)*E43*F43","v":0},{"$f":"(B30/1000)*E43*G43","v":0},{"$f":"(B30/1000)*E43","v":0}]
["TOTAL NEW TRIPS",null,{"$f":"SUM(C26:C30)","v":0},0,{"$f":"IF(COUNTIF(B26:B30, \">0\")>1,SUM(E26:E30)-(SUM(E26:E30)*0.04),SUM(E26:E30))","v":0},0,0,{"$f":"IF(COUNTIF(B26:B30, \">0\")>1,SUM(H26:H30)-(SUM(H26:H30)*0.14),SUM(H26:H30))","v":0}]
["*For mixed-use (at least two of the established land uses) sites, a 4% reduction for AM Peak-Hour and a 14% reduction for PM Peak-Hour is applied to the trip generation. "]
[]
[]
[null,"ASSUMPTIONS"]
[null,"ASPEN TRIP GENERATION"]
[null,"AM Peak Average",null,null,"PM Peak Average"]
["Land Use","Trip Rate","%Entering","%Exiting","Trip Rate","%Entering","%Exiting"]
["Commercial",2.27,0.69,0.31,4.1399999999999997,0.4,0.6]
["Free-Market Housing",0.67,0.28999999999999998,0.71,0.82,0.56000000000000005,0.44]
["Affordable Housing",0.75,0.48,0.52,0.89,0.55000000000000004,0.45]
["Lodging",0.25,0.56999999999999995,0.43,0.31,0.52,0.48]
["Essential Public Facility",0.86,0.62,0.38,1.66,0.4,0.6]

{"sheet":"2. MMLOS","index":1,"n_rows":123,"n_cols":7,"rows_kept":123,"cut":false,"hidden":false,"merged":[[37,1,37,5],[50,1,50,5],[68,1,68,5],[42,1,49,1],[42,2,46,2],[1,1,1,6],[55,1,67,1],[55,2,62,2],[22,2,22,5],[28,2,28,5],[14,2,16,2],[10,2,12,2],[13,2,13,5],[2,1,2,6],[33,2,33,5],[17,2,17,5],[67,2,67,5],[63,2,63,5],[64,2,66,2],[47,2,47,5],[49,2,49,5],[10,1,36,1],[36,2,36,5],[34,2,35,2],[7,3,7,4],[18,2,21,2],[29,2,32,2],[23,2,27,2]]}
[]
[null,"MMLOS Input Page"]
[null,"Instructions: Answer Yes, No, or Not Applicable to each measure under the Pedestrian, Bike and Transit sections. "]
[]
[null,null,null,null,null,null,"= input"]
[null,null,null,null,null,null,"= calculation"]
[]
[null,null,null,"TOTAL NUMBER OF TRIPS MITIGATED:",null,{"$f":"SUM(G38,G51,G69)","v":-30}]
[]
[null,"Category","Sub.","Measure Number","Question","Answer","Points"]
[null,"Pedestrians","Sidewalk Condition on Project Frontage",1,"Does the project propose a detached sidewalk where an attached sidewalk currently exists? Does the proposed sidewalk and buffer meet standard minimum widths? ",null,{"$f":"IF(F11=\"Yes\",5,IF(F11=\"No\",0,IF(F11=\"NA\",0,0)))","v":0}]
[null,null,null,2,"Is the proposed effective sidewalk width greater than the standard minimum width?",null,{"$f":"IF(F12=\"Yes\",5,IF(F12=\"No\",0,IF(F12=\"NA\",0,0)))","v":0}]
[null,null,null,3,"Does the project propose a landscape buffer greater than the standard minimum width?",null,0]
[null,null,"Subtotal",null,null,null,{"$f":"SUM(G11:G13)","v":0}]
[null,null,"Sidewalk Condition on Adjacent Blocks",4,"Does the project propose a detached sidewalk on an adjacent block? Does the proposed sidewalk and buffer meet standard minimum widths? ",null,0]
[null,null,null,5,"Is the proposed effective sidewalk width on an adjacent block greater than the standard minimum width?",null,0]
[null,null,null,6,"Is the proposed landscape buffer on an adjacent block greater than the standard minimum width?",null,0]
[null,null,"Subtotal",null,null,null,{"$f":"SUM(G15:G17)","v":0}]
[null,null,"Pedestrian Routes",7,"Are slopes between back of curb and sidewalk equal to or less than 5%?",null,{"$f":"IF(F19=\"Yes\",0,IF(F19=\"No\",-10,IF(F19=\"NA\",0,-10)))","v":-10}]
[null,null,null,8,"Are curbs equal to (or less than) 6 inches?",null,{"$f":"IF(F20=\"Yes\",0,-5)","v":-5}]
[null,null,null,9,"Is new large-scale landscaping proposed that improves the pedestrian experience? Properties within the Core do not have ample area to provide the level of landscaping required to receive credit in this category. ",null,0]
[null,null,null,10,"Does the project propose an improved crosswalk? This measure must get City approval before receiving credit. ",null,0]
[null,null,"Subtotal",null,null,null,{"$f":"SUM(G19:G22)","v":-15}]
[null,null,"Driveways, Parking, and Access Considerations",11,"Are existing driveways removed from the street?",null,0]
[null,null,null,12,"Is pedestrian and/or vehicle visibility unchanged by new structure or column?",null,{"$f":"IF(F25=\"Yes\",0,-5)","v":-5}]
[null,null,null,13,"Is the grade (where pedestrians cross) on cross-slope of driveway 2% or less?",null,{"$f":"IF(F26=\"Yes\",0,-5)","v":-5}]
[null,null,null,14,"Does the project propose enhanced pedestrian access points from the ROW? This includes improvements to ADA ramps or creating new access points which prevent pedestrians from crossing a street. ",null,{"$f":"IF(F27=\"Yes\",5,IF(F27=\"No\",0,IF(F27=\"NA\",0,0)))","v":0}]
[null,null,null,15,"Does the project propose enhanced pedestrian or bicyclist interaction with vehicles at driveway areas?",null,{"$f":"IF(F28=\"Yes\",5,IF(F28=\"No\",0,IF(F28=\"NA\",0,0)))","v":0}]
[null,null,"Subtotal",null,null,null,{"$f":"SUM(G24:G28)","v":-10}]
[null,null,"Traffic Calming and Pedestrian Network",16,"Is the project's pedestrian directness factor less than 1.5?",null,{"$f":"IF(F30=\"Yes\",0,-5)","v":-5}]
[null,null,null,17,"Does the project propose new improvements which reduce the pedestrian directness factor to less than 1.2? A site which has an existing pedestrian directness factor less than 1.2 cannot receive credit in this category. ",null,0]
[null,null,null,18,"Is the project proposing an off site improvement that results in a pedestrian directness factor below 1.2?* ",null,0]
[null,null,null,19,"Are traffic calming features proposed that are part of an approved plan (speed humps, rapid flash)?*",null,{"$f":"IF(F33=\"Yes\",10,IF(F33=\"No\",0,IF(F33=\"NA\",0,0)))","v":0}]
[null,null,"Subtotal",null,null,null,{"$f":"SUM(G30:G33)","v":-5}]
[null,null,"Additional Proposed Improvements",20,"Are additional minor improvements proposed which benefit the pedestrian experience and have been agreed upon with City of Aspen staff? ",null,{"$f":"IF(F35=\"Yes\",3,IF(F35=\"No\",0,IF(F35=\"NA\",0,0)))","v":0}]
[null,null,null,21,"Are additional major improvements proposed which benefit the pedestrian experience and have been agreed upon with City of Aspen staff? ",null,{"$f":"IF(F36=\"Yes\",5,IF(F36=\"No\",0,IF(F36=\"NA\",0,0)))","v":0}]
[null,null,"Subtotal",null,null,null,{"$f":"SUM(G35:G36)","v":0}]
[null,"Pedestrian Total*",null,null,null,null,{"$f":"G14+G23+G29+G34+G18+G37","v":-30}]
[]
[]
[]
[null,"Category","Sub.","Measure Number","Question","Answer","Points"]
[null,"Bicycles","Modifications to Existing Bicycle Paths",22,"Is a new bicycle path being implemented with City approved design?",null,{"$f":"IF(F43=\"Yes\",10,0)","v":0}]
[null,null,null,23,"Do new bike paths allow access without crossing a street or driveway?",null,{"$f":"IF(F44=\"Yes\",5,0)","v":0}]
[null,null,null,24,"Is there proposed landscaping, striping, or signage improvements to an existing bicycle path?",null,{"$f":"IF(F45=\"Yes\",5,0)","v":0}]
[null,null,null,25,"Does the project propose additional minor bicycle improvements which have been agreed upon with City of Aspen staff?",null,{"$f":"IF(F46=\"Yes\",5,0)","v":0}]
[null,null,null,26,"Does the project propose additional major bicycle improvements which have been agreed upon with City of Aspen staff?",null,{"$f":"IF(F47=\"Yes\",5,0)","v":0}]
[null,null,"Subtotal",null,null,null,{"$f":"SUM(G43:G47)","v":0}]
[null,null,"Bicycle Parking",27,"Is the project providing bicycle parking?",null,{"$f":"IF(F49=\"Yes\",5,0)","v":0}]
[null,null,"Subtotal",null,null,null,{"$f":"SUM(G49:G49)","v":0}]
[null,"Bicycles Total*",null,null,null,null,{"$f":"G50+G48","v":0}]
[]
[]
[]
[null,"Category","Sub.","Measure Number","Question","Answer","Points"]
[null,"Transit","Basic Amenities",28,"Is seating/bench proposed?",null,{"$f":"IF(F56=\"Yes\",3,0)","v":0}]
[null,null,null,29,"Is a trash receptacle proposed?",null,{"$f":"IF(F57=\"Yes\",3,0)","v":0}]
[null,null,null,30,"Is transit system information (signage) proposed?",null,0]
[null,null,null,31,"Is shelter/shade proposed?",null,{"$f":"IF(F59=\"Yes\",4,0)","v":0}]
[null,null,null,32,"Is enhanced pedestrian-scale lighting proposed?",null,{"$f":"IF(F60=\"Yes\",4,0)","v":0}]
[null,null,null,33,"Is real-time transit information proposed?",null,0]
[null,null,null,34,"Is bicycle parking/storage proposed specifically for bus stop use?",null,0]
[null,null,null,35,"Are ADA improvements proposed?",null,{"$f":"IF(F63=\"Yes\",5,0)","v":0}]
[null,null,"Subtotal",null,null,null,{"$f":"SUM(G56:G63)","v":0}]
[null,null,"Enhanced Amenities",36,"Is a bus pull-out proposed at an existing stop?",null,{"$f":"IF(F65=\"Yes\",10,0)","v":0}]
[null,null,null,37,"Is relocation of a bus stop to improve transit accessibility or roadway operations proposed?",null,{"$f":"IF(F66=\"Yes\",10,0)","v":0}]
[null,null,null,38,"Is a new bus stop proposed (with minimum of two basic amenities)?",null,{"$f":"IF(F67=\"Yes\",15,0)","v":0}]
[null,null,"Subtotal",null,null,null,{"$f":"SUM(G65:G67)","v":0}]
[null,"Transit Total*",null,null,null,null,{"$f":"G64+G68","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"*All proposed measures must be approved by the City of Aspen (included in Conditions of Approval or plan approved by staff)."]

{"sheet":"3. TDM","index":2,"n_rows":112,"n_cols":18,"rows_kept":112,"cut":false,"hidden":false,"merged":[[65,3,65,6],[10,1,10,3],[37,3,37,5],[38,3,38,5],[35,3,35,5],[24,1,38,1],[27,3,27,5],[32,3,32,5],[11,2,12,2],[14,2,17,2],[24,2,26,2],[28,2,31,2],[33,2,34,2],[41,2,42,2],[44,2,46,2],[48,2,49,2],[7,1,8,6],[89,6,90,6],[85,6,87,6],[69,3,69,6],[16,16,16,23],[24,6,26,6],[28,6,31,6],[33,6,34,6],[41,6,42,6],[47,3,47,6],[50,3,50,6],[54,3,54,6],[58,3,58,6],[21,3,21,5],[43,3,43,6],[62,3,62,6],[92,3,92,5],[44,6,46,6],[48,6,49,6],[51,6,53,6],[55,6,57,6],[59,6,61,6],[63,6,64,6],[66,6,68,6],[73,3,73,6],[77,3,77,6],[70,3,72,3],[84,3,84,6],[88,3,88,6],[91,3,91,6],[80,3,80,6],[81,6,83,6],[2,1,3,6],[70,6,72,6],[74,6,76,6],[78,6,79,6],[41,1,92,1],[11,3,12,3],[13,3,13,5],[14,3,17,3],[18,3,18,5],[20,3,20,5],[11,1,21,1],[11,6,12,6],[14,6,17,6],[24,3,26,3],[28,3,31,3],[33,3,34,3],[108,1,108,3],[41,3,42,3],[44,3,46,3],[48,3,49,3],[51,3,53,3],[55,3,57,3],[59,3,61,3],[63,3,64,3],[66,3,68,3],[78,3,79,3],[81,3,83,3],[85,3,87,3],[89,3,90,3],[74,3,76,3],[94,1,94,5],[95,1,95,5],[51,2,53,2],[55,2,57,2],[59,2,61,2],[63,2,64,2],[66,2,68,2],[89,2,90,2],[70,2,72,2],[74,2,76,2],[78,2,79,2],[81,2,83,2],[85,2,87,2]]}
[]
[]
[null,"TDM Input Page"]
[]
[]
[]
[]
[]
[]
[null,"Category","Measure Number","Sub. ","Question","Answer ","Strategy VMT Reductions"]
[null,"General Inputs",null,null,"What is the project location? ",null,"-"]
[null,"Neighborhood/Site Enhancements Strategies",1,"Onsite Servicing","Will an onsite ammenities strategy be implemented?",null,{"$f":"'Maximum Calcs'!D48","v":0}]
[null,null,null,null,"Which onsite ammenities will be implemented?"]
[]
[null,null,2,"Shared Shuttle Service","Will a shared shuttle service strategy be implemented?",null,{"$f":"'Maximum Calcs'!D49","v":0}]
[null,null,null,null,"What is the degree of implementation?"]
[null,null,null,null,"What is the company size?"]
[null,null,null,null,"What percentage of customers are eligible?"]
[]
[null,null,3,"Nonmotorized Zones","Will a nonmotorized zones strategy be implemented?",null,{"$f":"'Maximum Calcs'!D50","v":0}]
[]
[null,null,null,"Maximum Reduction Allowed in Category",null,null,{"$f":"('Maximum Calcs'!D40)","v":0}]
[]
[null,"Category","Measure Number","Sub. ","Question","Answer ","Strategy VMT Reductions"]
[null,"Transit System Improvements Strategies",4,"Network Expansion","Will a network expansion stragtegy be implemented?",null,{"$f":"'Maximum Calcs'!D65","v":0}]
[null,null,null,null,"What is the percentage increase of transit network coverage?"]
[null,null,null,null,"What is the existing transit mode share as a % of total daily trips?"]
[]
[null,null,5,"Service Frequency/Speed","Will a service frequency/speed strategy be implemented?",null,{"$f":"'Maximum Calcs'!D66","v":0}]
[null,null,null,null,"What is the percentage reduction in headways (increase in frequency)? "]
[null,null,null,null,"What is the existing transit mode share as a % of total daily trips?"]
[null,null,null,null,"What is the level of implementation?"]
[]
[null,null,6,"Transit Access Improvement","Will a transit access improvement strategy be implemented?",null,{"$f":"'Maximum Calcs'!D67","v":0}]
[null,null,null,null,"What is the extent of access improvements? "]
[]
[null,null,7,"Intercept Lot","Will an intercept lot strategy be implemented?",null,{"$f":"'Maximum Calcs'!D68","v":0}]
[]
[null,null,null,"Maximum Reduction Allowed in Category",null,null,{"$f":"'Maximum Calcs'!D57","v":0}]
[]
[null,"Category","Measure Number","Sub. ","Question","Answer ","Strategy VMT Reductions"]
[null,"Commute Trip Reduction Programs Strategies",8,"Participation in TOP","Will there be participation in TOP?",null,{"$f":"'Maximum Calcs'!D92","v":0}]
[null,null,null,null,"What percentage of employees are eligible?"]
[]
[null,null,9,"Transit Fare Subsidy","Is a transit fare subsidy strategy implemented?",null,{"$f":"'Maximum Calcs'!D93","v":0}]
[null,null,null,null,"What percentage of employees are eligible?"]
[null,null,null,null,"What is the amount of transit subsidy per passenger (daily equivalent)?"]
[]
[null,null,10,"Employee Parking Cash-Out","Is an employee parking cash-out strategy being implemented?",null,{"$f":"'Maximum Calcs'!D94","v":0}]
[null,null,null,null,"What percentage of employees are eligible?"]
[]
[null,null,11,"Workplace Parking Pricing","Is a workplace parking pricing strategy implemented?",null,{"$f":"'Maximum Calcs'!D95","v":0}]
[null,null,null,null,"What is the daily parking charge?"]
[null,null,null,null,"What percentage of employees are subject to priced parking?"]
[]
[null,null,12,"Compressed Work Weeks","Is a compressed work weeks strategy implemented?",null,{"$f":"'Maximum Calcs'!D96","v":0}]
[null,null,null,null,"What percentage of employees are participating?"]
[null,null,null,null,"What is the workweek schedule?"]
[]
[null,null,13,"Employer Sponsored Vanpool","Is an employer sponsered shuttle program implemented?",null,{"$f":"'Maximum Calcs'!D97","v":0}]
[null,null,null,null,"What is the employer size?"]
[null,null,null,null,"What percentage of employees are eligible?"]
[]
[null,null,14,"Carpool Matching","Is a carpool matching strategy implemented?",null,{"$f":"'Maximum Calcs'!D98","v":0}]
[null,null,null,null,"What percentage of employees are eligble?"]
[]
[null,null,15,"Carshare Program","Is carshare participation being implemented?",null,{"$f":"'Maximum Calcs'!D99","v":0}]
[null,null,null,null,"How many employee memberships have been purchased?"]
[null,null,null,null,"What percentage of employees are eligble?"]
[]
[null,null,16,"Bikeshare Program","Is participation in the bikeshare program WE-cycle being implemented?",null,{"$f":"'Maximum Calcs'!D100","v":0}]
[null,null,null,null,"How many memberships have been purchased?"]
[null,null,null,null,"What percentage of employees/guests are eligble?"]
[]
[null,null,17,"End of Trip Facilities","Is an end of trip facilities strategy being implemented?",null,{"$f":"'Maximum Calcs'!D101","v":0}]
[null,null,null,null,"What is the degree of implementation? "]
[null,null,null,null,"What is the employer size? "]
[]
[null,null,18,"Self-funded Emergency Ride Home","Is a self-funded emergency ride home strategy being implemented?",null,{"$f":"'Maximum Calcs'!D102","v":0}]
[null,null,null,null,"What percentage of employees are eligible?"]
[]
[null,null,19,"Carpool/Vanpool Priority Parking","Is a carpool/vanpool priority parking strategy being implemented?",null,{"$f":"'Maximum Calcs'!D103","v":0}]
[null,null,null,null,"What is the employer size?"]
[null,null,null,null,"What number of parking spots are available for the program?"]
[]
[null,null,20,"Private Employer Shuttle","Is a private employer shuttle strategy being implemented?",null,{"$f":"'Maximum Calcs'!D104","v":0}]
[null,null,null,null,"What is the employer size?"]
[null,null,null,null,"What percentage of employees are eligible?"]
[]
[null,null,21,"Trip Reduction Marketing/Incentive Program","Is a trip reduction marketing/incentive program implemented?",null,{"$f":"'Maximum Calcs'!D105","v":0}]
[null,null,null,null,"What percentage of employees/guests are eligible?"]
[]
[null,null,null,"Maximum Reduction Allowed in Category",null,null,{"$f":"'Maximum Calcs'!D74","v":0}]
[]
[null,"Cross Category Maximum Reduction, Neighborhood and Transit ",null,null,null,null,{"$f":"'Maximum Calcs'!C23","v":{"$error":"#N/A"}}]
[null,"Global Maximum VMT Reductions",null,null,null,null,{"$f":"'Maximum Calcs'!C7","v":{"$error":"#N/A"}}]
[]
[null,"1. 22% work trips represents a mixed-used site (SF Bay Area Travel Survey).  See Assumptions Tab for more detail."]
[]
[null,"Pulldown menu data hidden here:"]
[null,"Do not edit"]
[]
[null,"Minor",null,"housing units per acre","Within Project and Connecting Off-site",0.25,"<50% of lines (within project) improved",0.75,1,"9-day/80-hour","Yes","low","small","peak period variable pricing","congested","urban + comprehensive transit",0.01,"low"]
[null,"Major",null,"jobs per job acre","Within Project Only",0.5,">=50% of lines (within project) improved",1.49,2,"4-day/40-hour","No","medium","medium","static all-day pricing","free-flow","suburban + commuter rail",0.03,"high"]
[null,null,null,null,null,0.75,null,2.98,3,null,"NA","high","large",null,null,"all other",0.05]
[null,null,null,null,null,1,null,5.96,6,null,null,null,null,null,null,null,0.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.25]
[]
[null,"onsite services:"]
[null,"Retail Servicing",null,0.03,null,"Free",1,"Yes"]
[null,"Hotel with Retail Servicing",null,0.1,null,"Subsidized",2,"No"]
[null,null,null,null,"3+",null,"3+"]

{"sheet":"SUMMARY","index":3,"n_rows":53,"n_cols":24,"rows_kept":53,"cut":false,"hidden":false,"merged":[[14,0,14,5],[6,1,6,5],[0,0,1,5],[51,0,51,5],[3,1,3,5],[4,1,4,5],[5,1,5,5],[9,0,9,1],[8,0,8,5],[9,2,9,4],[9,5,10,5],[45,1,45,3],[44,1,44,3],[33,1,33,3],[34,1,34,3],[43,1,43,3],[52,0,52,5],[46,1,46,3],[47,1,47,3],[49,2,49,3],[42,1,42,3],[35,1,35,3],[37,1,37,3],[38,1,38,3],[41,1,41,3],[27,1,27,3],[28,1,28,3],[29,1,29,3],[31,1,31,3],[32,1,32,3],[30,1,30,3],[36,1,36,3],[39,1,39,3],[40,1,40,3]]}
["Summary and Narrative: ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"The Level One TIA Outline:\n1) Introductory Items\n    • Front Cover / Title Page\n    • Table of Contents, List of Figures, and List of Tables\n2) Introduction\n    • Project Description\n    • Project applicant/contact info \n    • Site plan (include proposed driveways, roadways, traffic control, parking facilities, emergency vehicle access, and internal circulation for vehicles,\n        bicyclists, and pedestrians)\n    • Location map (include major streets, study intersections, and neighboring zoning and land uses)\n3) Project Trip Generation using the City of Aspen specific trip generation figures (Table A-1 and A-2 in Appendix A)\n    • AM Peak Trips by Land Use and for entire Project\n    • PM Peak Trips by Land Use and for entire Project\n4) Proposed new and/or improved TDM and MMLOS Mitigation Program (Based off TDM and MMLOS Mitigation Tools)\n    • Copies of completed TDM and MMLOS toolkit spreadsheets \n    • TDM Measure Details (including location of measures, effectiveness of measures for project, implementation details)\n    • MMLOS Measure Details (including location of measures, effectiveness of measures for project, implementation details)\n    • Enforcement & Financing\n    • Scheduling and implementation responsibility of mitigation measures\n5) Monitoring Report\n    • Assessment of Compliance with Guidelines\n    • Results and effectiveness of implemented measures \n    • Identification of Additional Strategies\n    • Surveys and other supporting data\n"]
[]
[]
["DATE:",{"$f":"IF('1. Trip Generation'!B16=\"\",\"\",'1. Trip Generation'!B16)","v":""}]
["PROJECT NAME:",{"$f":"IF('1. Trip Generation'!B17=\"\",\"\",'1. Trip Generation'!B17)","v":""}]
["PROJECT ADDRESS:",{"$f":"IF('1. Trip Generation'!B18=\"\",\"\",'1. Trip Generation'!B18)","v":""}]
["APPLICANT CONTACT INFORMATION:\nNAME, COMPANY, ADDRESS, PHONE, EMAIL",{"$f":"'1. Trip Generation'!B19:H19","v":"Name\nCompany\nAddress\nPhone\nEmail"}]
[]
["SUMMARY"]
["Trip Generation",null,"Trip Mitigation",null,null,"NET TRIPS TO BE MITIGATED"]
["Peak Hour","Max Trips Generated","MMLOS","TDM","Total Trips Mitigated"]
[{"$f":"IF('1. Trip Generation'!E31>'1. Trip Generation'!H31,\"AM\",IF('1. Trip Generation'!H31>='1. Trip Generation'!E31,\"PM\",\"-\"))","v":"PM"},{"$f":"IF('1. Trip Generation'!E31>'1. Trip Generation'!H31,'1. Trip Generation'!E31,IF('1. Trip Generation'!H31>='1. Trip Generation'!E31,'1. Trip Generation'!H31,\"-\"))","v":0},{"$f":"'2. MMLOS'!F8","v":-30},{"$f":"OUTPUT!C3*B12","v":{"$error":"#N/A"}},{"$f":"SUM(C12:D12)","v":{"$error":"#N/A"}},{"$f":"IF(B12-E12<0,0,B12-E12)","v":{"$error":"#N/A"}}]
[{"$f":"IF(ISNA(F12),A23,IF(F12>0,\"The net trips to be mitigated is greater than 0. The project shall propose additional mitigation measures.\",\"\"))","v":"If the above summary states #NA try the following: "}]
[{"$f":"IF('1. Trip Generation'!C21=\"\",SUMMARY!A19,\"\")","v":"Return to Sheet \"1. Trip Generation\" and select the project size. "}]
[{"$f":"IF(ISNA(F12),A24,\"\")","v":"Return to Sheet \"3. TDM\" and ensure each question is answered. If a measure is answered \"Yes\" each question within that subsection must be answered. "}]
[{"$f":"IF(OR('1. Trip Generation'!B26=\"\",'1. Trip Generation'!B27=\"\",'1. Trip Generation'!B28=\"\",'1. Trip Generation'!B29=\"\",'1. Trip Generation'!B30=\"\"),SUMMARY!A20,\"\")","v":""}]
[{"$f":"IF(AND('1. Trip Generation'!C21=\"Major\",'Narrative Prompts'!F66<5),SUMMARY!A22,IF(AND('1. Trip Generation'!C21=\"Minor\",'Narrative Prompts'!F66<2),A21,\"\"))","v":""}]
["Hide the following rows 18-50 (Used for warning notes): DO NOT EDIT BELOW"]
["Return to Sheet \"1. Trip Generation\" and select the project size. "]
["Return to Sheet \"1. Trip Generation\" and complete the required inputs for proposed land use. If there is no net change in land use input 0 in the appropriate cell.  "]
["A minimum of two TDM measures must be utilized for minor projects. Please return to Sheet \"3. TDM\" and select a minimum of two measures.   "]
["A minimum of five TDM measures must be utilized for major projects. Please return to Sheet \"3. TDM\" and select a minimum of five measures. "]
["If the above summary states #NA try the following: "]
["Return to Sheet \"3. TDM\" and ensure each question is answered. If a measure is answered \"Yes\" each question within that subsection must be answered. "]
[]
[]
["Sub. ","Question",null,null,"Answer "]
["Onsite Servicing","Will an onsite ammenities strategy be implemented?",null,null,{"$f":"'3. TDM'!F12","v":0}]
["Shared Shuttle Service","Will a shared shuttle service strategy be implemented?",null,null,{"$f":"'3. TDM'!F15","v":0}]
["Nonmotorized Zones","Will a nonmotorized zones strategy be implemented?",null,null,{"$f":"'3. TDM'!F20","v":0}]
["Network Expansion","Will a network expansion stragtegy be implemented?",null,null,{"$f":"'3. TDM'!F25","v":0}]
["Service Frequency/Speed","Will a service frequency/speed strategy be implemented?",null,null,{"$f":"'3. TDM'!F29","v":0}]
["Transit Access Improvement","Will a transit access improvement strategy be implemented?",null,null,{"$f":"'3. TDM'!F34","v":0}]
["Intercept Lot","Will an intercept lot strategy be implemented?",null,null,{"$f":"'3. TDM'!F37","v":0}]
["Participation in TOP","Will there be participation in TOP?",null,null,{"$f":"'3. TDM'!F42","v":0}]
["Transit Fare Subsidy","Is a transit fare subsidy strategy implemented?",null,null,{"$f":"'3. TDM'!F45","v":0}]
["Employee Parking Cash-Out","Is an employee parking cash-out strategy being implemented?",null,null,{"$f":"'3. TDM'!F49","v":0}]
["Workplace Parking Pricing","Is a workplace parking pricing strategy implemented?",null,null,{"$f":"'3. TDM'!F52","v":0}]
["Compressed Work Weeks","Is a compressed work weeks strategy implemented?",null,null,{"$f":"'3. TDM'!F56","v":0}]
["Employer Sponsored Vanpool","Is an employer sponsered shuttle program implemented?",null,null,{"$f":"'3. TDM'!F60","v":0}]
["Carpool Matching","Is a carpool matching strategy implemented?",null,null,{"$f":"'3. TDM'!F64","v":0}]
["Carshare Program","Is carshare participation being implemented?",null,null,{"$f":"'3. TDM'!F67","v":0}]
["Bikeshare Program","Is a bikeshare program participation being implemented?",null,null,{"$f":"'3. TDM'!F71","v":0}]
["End of Trip Facilities","Is an end of trip facilities strategy being implemented?",null,null,{"$f":"'3. TDM'!F75","v":0}]
["Self-funded Emergency Ride Home","Is a self-funded emergency ride home strategy being implemented?",null,null,{"$f":"'3. TDM'!F79","v":0}]
["Carpool/Vanpool Priority Parking","Is a carpool/vanpool priority parking strategy being implemented?",null,null,{"$f":"'3. TDM'!F82","v":0}]
["Private Employer Shuttle","Is a private employer shuttle strategy being implemented?",null,null,{"$f":"'3. TDM'!F86","v":0}]
["Trip Reduction Marketing/Incentive Program","Is a trip reduction marketing/incentive program implemented?",null,null,{"$f":"'3. TDM'!F90","v":0}]
[]
[null,null,"TotalTDM reduction items",null,{"$f":"COUNTIF(E28:E48,\"yes\")","v":0}]
[]
["Narrative:"]
["Click on the \"Generate Narrative\" Button to the right. \nRespond to each of the prompts in the space provided.\nEach response should cover the following:  \n1. Explain the selected measure. \n2. Call out where the measure is located.\n3. Demonstrate how the selected measure is appropriate to enhance the project site \n     and reduce traffic impacts.\n4. Explain the Enforcement and Financing Plan for the selected measure.   \n5. Explain the scheduling and implementation responsibility of the mitigation measure. \n6. Attach any additional information and a site map to the narrative report. "]

{"sheet":"Narrative Prompts","index":4,"n_rows":72,"n_cols":10,"rows_kept":72,"cut":false,"hidden":true,"merged":[[29,1,36,1],[37,1,39,1],[71,0,80,5],[2,1,4,1],[5,1,7,1],[8,1,11,1],[12,1,16,1],[17,1,20,1],[21,1,22,1],[23,1,27,1]]}
["MMLOS"]
["Category","Sub. Category","Question","Does the Measure Require a Narrative Prompt? ","Does the Measure Require a Site Map? ","Did the Applicant Choose the Measure and the Measure Requires a Narrative Prompt? ","Did the Applicant Choose the Measure and the Measure Requires a Site Plan Prompt? ","Narrative Prompt","Site Map Prompt"]
[null,"Sidewalk Condition on Project Frontage",{"$f":"'2. MMLOS'!E11","v":"Does the project propose a detached sidewalk where an attached sidewalk currently exists? Does the proposed sidewalk and buffer meet standard minimum widths? "},"Yes","Yes",{"$f":"IF('2. MMLOS'!$F11=\"Yes\",IF(D3=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},{"$f":"IF('2. MMLOS'!$F11=\"Yes\",IF(E3=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},"In the space provided call out the effective sidewalk width and the percentage of the site which meets or exceeds the minimum standard width. Explain the site constraints for areas which do not meet the minimum width. ","Sidewalk Width and Buffer Width","Display the detached sidewalk and buffer widths. Effective sidewalk width takes into account a 2' shy distance from buildings. Obstructions such as benches, grates, and planters reduce the effective sidewalk width to the width which remains clear at all times. "]
[null,null,{"$f":"'2. MMLOS'!E12","v":"Is the proposed effective sidewalk width greater than the standard minimum width?"},"No","No",{"$f":"IF('2. MMLOS'!$F12=\"Yes\",IF(D4=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},{"$f":"IF('2. MMLOS'!$F12=\"Yes\",IF(E4=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},"NA","NA","NA"]
[null,null,{"$f":"'2. MMLOS'!E13","v":"Does the project propose a landscape buffer greater than the standard minimum width?"},"No","No",{"$f":"IF('2. MMLOS'!$F13=\"Yes\",IF(D5=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},{"$f":"IF('2. MMLOS'!$F13=\"Yes\",IF(E5=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},"NA","NA","NA"]
[null,"Sidewalk Condition on Adjacent Blocks",{"$f":"'2. MMLOS'!E15","v":"Does the project propose a detached sidewalk on an adjacent block? Does the proposed sidewalk and buffer meet standard minimum widths? "},"Yes","Yes",{"$f":"IF('2. MMLOS'!$F15=\"Yes\",IF(D6=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},{"$f":"IF('2. MMLOS'!$F15=\"Yes\",IF(E6=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},"A detached sidewalk is proposed on an adjacent block. Explain below how this improvement ties into the proposed project. ","Detached Sidewalk on Adjacent Property","Show the proposed detached sidewalk on an adjacent block. "]
[null,null,{"$f":"'2. MMLOS'!E16","v":"Is the proposed effective sidewalk width on an adjacent block greater than the standard minimum width?"},"No","Yes",{"$f":"IF('2. MMLOS'!$F16=\"Yes\",IF(D7=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},{"$f":"IF('2. MMLOS'!$F16=\"Yes\",IF(E7=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},"NA","Sidewalk width on adjacent property","The project proposes to install a sidewalk with an effective width greater than the standard minimum width on an adjacent block off-site. Demonstrate on site plan.  "]
[null,null,{"$f":"'2. MMLOS'!E17","v":"Is the proposed landscape buffer on an adjacent block greater than the standard minimum width?"},"No","Yes",{"$f":"IF('2. MMLOS'!$F17=\"Yes\",IF(D8=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},{"$f":"IF('2. MMLOS'!$F17=\"Yes\",IF(E8=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},"NA","Landscape Buffer on Adjacent Property","Proposed landscape buffer width is greater than the standard minimum width on an adjacent block off-site. Demonstrate on site plan. "]
[null,"Pedestrian Routes",{"$f":"'2. MMLOS'!E19","v":"Are slopes between back of curb and sidewalk equal to or less than 5%?"},"No","Yes",{"$f":"IF('2. MMLOS'!$F19=\"Yes\",IF(D9=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},{"$f":"IF('2. MMLOS'!$F19=\"Yes\",IF(E9=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},null,"Slopes Between Back of Curb and Sidewalk","Slopes between back of curb and sidewalk are equal to or less 5%. Call this out on the site plan. "]
[null,null,{"$f":"'2. MMLOS'!E20","v":"Are curbs equal to (or less than) 6 inches?"},"No","No",{"$f":"IF('2. MMLOS'!$F20=\"Yes\",IF(D10=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},{"$f":"IF('2. MMLOS'!$F20=\"Yes\",IF(E10=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},"NA","NA","NA"]
[null,null,{"$f":"'2. MMLOS'!E21","v":"Is new large-scale landscaping proposed that improves the pedestrian experience? Properties within the Core do not have ample area to provide the level of landscaping required to receive credit in this category. "},"Yes","Yes",{"$f":"IF('2. MMLOS'!$F21=\"Yes\",IF(D11=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},{"$f":"IF('2. MMLOS'!$F21=\"Yes\",IF(E11=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},"In the space provided desicribe what  new landscaping is proposed and how the proposed landscaping plan enhances the pedestrian experience. This measure is only applicable to large scale projects and requires more extensive landscaping then a few plantings or lawn area. The project shall establish extensive landscaping which significantly benefits the site and improves the pedestrian comfort and experience.","Landscape Plan","Provide the proposed landscape plan. "]
[null,null,{"$f":"'2. MMLOS'!E22","v":"Does the project propose an improved crosswalk? This measure must get City approval before receiving credit. "},"Yes","Yes",{"$f":"IF('2. MMLOS'!$F22=\"Yes\",IF(D12=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},{"$f":"IF('2. MMLOS'!$F22=\"Yes\",IF(E12=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},"Explain the proposed improved crosswalk and how this improvement benefits the pedestian experience and the site as a whole. An improved crosswalk includes measures such as incorporating a corner bulb out or defining a crosswalk path with colored concrete. Simply re-striping a crosswalk will not recieve credit. This measure must be pre-approved by City staff. ","Crosswalk Improvement(s)","On the site plan provide details on the proposed crosswalk improvement(s). "]
[null,"Driveways, Parking, and Access Considerations",{"$f":"'2. MMLOS'!E24","v":"Are existing driveways removed from the street?"},"Yes","Yes",{"$f":"IF('2. MMLOS'!$F24=\"Yes\",IF(D13=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},{"$f":"IF('2. MMLOS'!$F24=\"Yes\",IF(E13=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},"Explain what driveways are removed and how this benefits the pedestrian experience. ","Removed Driveway(s)","Show removed driveways on the site plan. "]
[null,null,{"$f":"'2. MMLOS'!E25","v":"Is pedestrian and/or vehicle visibility unchanged by new structure or column?"},"No","No",{"$f":"IF('2. MMLOS'!$F25=\"Yes\",IF(D14=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},{"$f":"IF('2. MMLOS'!$F25=\"Yes\",IF(E14=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},"NA","NA","NA"]
[null,null,{"$f":"'2. MMLOS'!E26","v":"Is the grade (where pedestrians cross) on cross-slope of driveway 2% or less?"},"No","Yes",{"$f":"IF('2. MMLOS'!$F26=\"Yes\",IF(D15=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},{"$f":"IF('2. MMLOS'!$F26=\"Yes\",IF(E15=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},"NA","2% Slope at Pedestrian Driveway Crossings"]
[null,null,{"$f":"'2. MMLOS'!E27","v":"Does the project propose enhanced pedestrian access points from the ROW? This includes improvements to ADA ramps or creating new access points which prevent pedestrians from crossing a street. "},"Yes","Yes",{"$f":"IF('2. MMLOS'!$F27=\"Yes\",IF(D16=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},{"$f":"IF('2. MMLOS'!$F27=\"Yes\",IF(E16=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},"Describe the enhanced pedestrian access point(s). This measure is to improve pedestrian access to the site from the ROW. It includes adding additional access points which prevent pedestrians and bicyclists from crossing a street,  improvements to the project's ADA ramps in the ROW, and improvements to existing access points. ","Enhanced Pedestrian Access Point"]
[null,null,{"$f":"'2. MMLOS'!E28","v":"Does the project propose enhanced pedestrian or bicyclist interaction with vehicles at driveway areas?"},"Yes","Yes",{"$f":"IF('2. MMLOS'!$F28=\"Yes\",IF(D17=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},{"$f":"IF('2. MMLOS'!$F28=\"Yes\",IF(E17=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},"Explain the enhanced pedestrian interaction at driveway areas or alley crossings. There must be an existing deficiency on the proposed site to select this mesaure. If the project will increase interaction between pedestrians and vehicles at a driveway this should be mitigated by implementing improvements to that area. New signage, striping, mirrors, and other approved devices are examples to address pedestrian-vehicle conflicts at driveways. ","Enhanced Pedestrian Interaction at Driveway Areas "]
[null,"Traffic Calming and Pedestrian Network",{"$f":"'2. MMLOS'!E30","v":"Is the project's pedestrian directness factor less than 1.5?"},"No","Yes",{"$f":"IF('2. MMLOS'!$F30=\"Yes\",IF(D18=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},{"$f":"IF('2. MMLOS'!$F30=\"Yes\",IF(E18=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},"NA","Pedestrian Directness Factor (See callout number 9 on the MMLOS sheet for an example)","The projects pedestrian directness factor is less than 1.5. On a site map show pedestrian paths from each access point to the furthest point on site and call out the pedestrian directness factor for each path. See callout number 9 on the MMLOS sheet for an example. "]
[null,null,{"$f":"'2. MMLOS'!E31","v":"Does the project propose new improvements which reduce the pedestrian directness factor to less than 1.2? A site which has an existing pedestrian directness factor less than 1.2 cannot receive credit in this category. "},"No","No",{"$f":"IF('2. MMLOS'!$F31=\"Yes\",IF(D19=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},{"$f":"IF('2. MMLOS'!$F31=\"Yes\",IF(E19=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},"NA","NA","The projects pedestrian directness factor is less than 1.2. On a site map show pedestrian paths from each access point to the furthest point on site and call out the pedestrian directness factor for each path. See callout number 9 on the MMLOS sheet for an example. "]
[null,null,{"$f":"'2. MMLOS'!E32","v":"Is the project proposing an off site improvement that results in a pedestrian directness factor below 1.2?* "},"Yes","Yes",{"$f":"IF('2. MMLOS'!$F32=\"Yes\",IF(D20=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},{"$f":"IF('2. MMLOS'!$F32=\"Yes\",IF(E20=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},"Explain offsite improvements which will result in a pedestrian directness factor below 1.2. ","Offsite Pedestrian Directness Factor (See callout number 9 on the MMLOS sheet for an example)","Show offsite improvements which result in a pedestrian directness factor below 1.2. Show pedestrian paths and crow flies distances as done in callout number 9 on the MMLOS sheet. Any proposals must have prior City approval. "]
[null,null,{"$f":"'2. MMLOS'!E33","v":"Are traffic calming features proposed that are part of an approved plan (speed humps, rapid flash)?*"},"Yes","Yes",{"$f":"IF('2. MMLOS'!$F33=\"Yes\",IF(D21=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},{"$f":"IF('2. MMLOS'!$F33=\"Yes\",IF(E21=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},"Explain any planned traffic calming features below. All traffic calming features must be pre-approved by the City. Features include islands, medians, raised crosswalks, speed humps, and rapid flash.","Traffic Calming Features"]
[null,"Additional Proposed Improvements",{"$f":"'2. MMLOS'!E35","v":"Are additional minor improvements proposed which benefit the pedestrian experience and have been agreed upon with City of Aspen staff? "},"Yes","Yes",{"$f":"IF('2. MMLOS'!$F35=\"Yes\",IF(D22=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},{"$f":"IF('2. MMLOS'!$F35=\"Yes\",IF(E22=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},"Explain any additional minor improvements which benefit the pedestrian experience and have been agreed upon with City of Aspen staff. ","Additional Minor Pedestrian Improvement"]
[null,null,{"$f":"'2. MMLOS'!E36","v":"Are additional major improvements proposed which benefit the pedestrian experience and have been agreed upon with City of Aspen staff? "},"Yes","Yes",{"$f":"IF('2. MMLOS'!$F36=\"Yes\",IF(D23=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},{"$f":"IF('2. MMLOS'!$F36=\"Yes\",IF(E23=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},"Explain any additional major improvements which benefit the pedestrian experience and have been agreed upon with City of Aspen staff. ","Additional Major Pedestrian Improvement"]
[null,"Modifications to Existing Bicycle Paths",{"$f":"'2. MMLOS'!E43","v":"Is a new bicycle path being implemented with City approved design?"},"Yes","Yes",{"$f":"IF('2. MMLOS'!$F43=\"Yes\",IF(D24=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},{"$f":"IF('2. MMLOS'!$F43=\"Yes\",IF(E24=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},"Describe the proposed new bicycle path. This measure must have pre-approval from City staff. ","New Bicycle Path"]
[null,null,{"$f":"'2. MMLOS'!E44","v":"Do new bike paths allow access without crossing a street or driveway?"},"Yes","Yes",{"$f":"IF('2. MMLOS'!$F44=\"Yes\",IF(D25=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},{"$f":"IF('2. MMLOS'!$F44=\"Yes\",IF(E25=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},"Describe how the proposed new bike path allows access without crossing a street or driveway. ","New bicycle path which provides access without crossing a street or driveway"]
[null,null,{"$f":"'2. MMLOS'!E45","v":"Is there proposed landscaping, striping, or signage improvements to an existing bicycle path?"},"Yes","Yes",{"$f":"IF('2. MMLOS'!$F45=\"Yes\",IF(D26=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},{"$f":"IF('2. MMLOS'!$F45=\"Yes\",IF(E26=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},"Desribe the proposed landscaping, striping, or signage which benefits an existing bicycle path. ","Proposed landscaping, striping, or signage which benefits an existing bicycle path "]
[null,null,{"$f":"'2. MMLOS'!E46","v":"Does the project propose additional minor bicycle improvements which have been agreed upon with City of Aspen staff?"},"Yes","No",{"$f":"IF('2. MMLOS'!$F46=\"Yes\",IF(D27=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},{"$f":"IF('2. MMLOS'!$F46=\"Yes\",IF(E27=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},"Explain any additional minor bicycle improvements which have been agreed upon with City of Aspen staff. ","Additional Minor Bicycle Improvements"]
[null,null,{"$f":"'2. MMLOS'!E47","v":"Does the project propose additional major bicycle improvements which have been agreed upon with City of Aspen staff?"},"Yes","No",{"$f":"IF('2. MMLOS'!$F47=\"Yes\",IF(D28=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},{"$f":"IF('2. MMLOS'!$F47=\"Yes\",IF(E28=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},"Explain any additional major bicycle improvements which have been agreed upon with City of Aspen staff. ","Additional Major Bicycle Improvements"]
[null,"Bicycle Parking",{"$f":"'2. MMLOS'!E49","v":"Is the project providing bicycle parking?"},"No","Yes",{"$f":"IF('2. MMLOS'!$F49=\"Yes\",IF(D29=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},{"$f":"IF('2. MMLOS'!$F49=\"Yes\",IF(E29=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},"NA","Bicycle Parking"]
[null,"Basic Amenities",{"$f":"'2. MMLOS'!E56","v":"Is seating/bench proposed?"},"Yes","Yes",{"$f":"IF('2. MMLOS'!$F56=\"Yes\",IF(D30=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},{"$f":"IF('2. MMLOS'!$F56=\"Yes\",IF(E30=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},"Describe the proposed seating/bench and the bench location for which existing bus stop. ","Bus Stop Seating/Bench"]
[null,null,{"$f":"'2. MMLOS'!E57","v":"Is a trash receptacle proposed?"},"No","Yes",{"$f":"IF('2. MMLOS'!$F57=\"Yes\",IF(D31=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},{"$f":"IF('2. MMLOS'!$F57=\"Yes\",IF(E31=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},"NA","Bus Stop Trash Recepticle"]
[null,null,{"$f":"'2. MMLOS'!E58","v":"Is transit system information (signage) proposed?"},"Yes","Yes",{"$f":"IF('2. MMLOS'!$F58=\"Yes\",IF(D32=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},{"$f":"IF('2. MMLOS'!$F58=\"Yes\",IF(E32=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},"Explain the proposed transit system information (signage). ","Transit System Information"]
[null,null,{"$f":"'2. MMLOS'!E59","v":"Is shelter/shade proposed?"},"Yes","Yes",{"$f":"IF('2. MMLOS'!$F59=\"Yes\",IF(D33=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},{"$f":"IF('2. MMLOS'!$F59=\"Yes\",IF(E33=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},"Explain the proposed shelter/shade and the location for which existing bus stop. ","Bus Stop Shelter/Shade"]
[null,null,{"$f":"'2. MMLOS'!E60","v":"Is enhanced pedestrian-scale lighting proposed?"},"Yes","Yes",{"$f":"IF('2. MMLOS'!$F60=\"Yes\",IF(D34=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},{"$f":"IF('2. MMLOS'!$F60=\"Yes\",IF(E34=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},"Describe the proposed enhanced pedestrian-scale lighting. ","Bus Stop Pedestrian Scale Lighting"]
[null,null,{"$f":"'2. MMLOS'!E61","v":"Is real-time transit information proposed?"},"Yes","Yes",{"$f":"IF('2. MMLOS'!$F61=\"Yes\",IF(D35=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},{"$f":"IF('2. MMLOS'!$F61=\"Yes\",IF(E35=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},"Describe the proposed real-time transit information. ","Real-time Transit Information"]
[null,null,{"$f":"'2. MMLOS'!E62","v":"Is bicycle parking/storage proposed specifically for bus stop use?"},"Yes","Yes",{"$f":"IF('2. MMLOS'!$F62=\"Yes\",IF(D36=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},{"$f":"IF('2. MMLOS'!$F62=\"Yes\",IF(E36=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},"NA","Bus Stop Bicycle Parking"]
[null,null,{"$f":"'2. MMLOS'!E63","v":"Are ADA improvements proposed?"},"Yes","Yes",{"$f":"IF('2. MMLOS'!$F63=\"Yes\",IF(D37=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},{"$f":"IF('2. MMLOS'!$F63=\"Yes\",IF(E37=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},"Explain the proposed bus stop ADA improvements. ","Bus Stop ADA Improvements"]
[null,"Enhanced Amenities",{"$f":"'2. MMLOS'!E65","v":"Is a bus pull-out proposed at an existing stop?"},"Yes","Yes",{"$f":"IF('2. MMLOS'!$F65=\"Yes\",IF(D38=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},{"$f":"IF('2. MMLOS'!$F65=\"Yes\",IF(E38=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},"In the space provided explain the proposed bus pull-out at an existing stop. ","Bus Pull-out Details"]
[null,null,{"$f":"'2. MMLOS'!E66","v":"Is relocation of a bus stop to improve transit accessibility or roadway operations proposed?"},"Yes","Yes",{"$f":"IF('2. MMLOS'!$F66=\"Yes\",IF(D39=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},{"$f":"IF('2. MMLOS'!$F66=\"Yes\",IF(E39=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},"Explain the relocation of a bus stop to improve transit accessibility or roadway operations. ","Relocated Bus Stop"]
[null,null,{"$f":"'2. MMLOS'!E67","v":"Is a new bus stop proposed (with minimum of two basic amenities)?"},"Yes","Yes",{"$f":"IF('2. MMLOS'!$F67=\"Yes\",IF(D40=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},{"$f":"IF('2. MMLOS'!$F67=\"Yes\",IF(E40=\"Yes\",\"Yes\",\"No\"),\"No\")","v":"No"},"Explain the new proposed bus stop and describe which amenities will be provided. ","Proposed New Bus Stop "]
[null,null,"END NOTE","Yes","No","Yes","No","Include any additional information that pertains to the MMLOS plan in the space provided below. ","NA"]
[null,null,null,null,null,null,{"$f":"COUNTIF(G3:G41,\"Yes\")","v":0}]
[null,"TDM"]
[null,"Onsite Servicing","Will an onsite ammenities strategy be implemented?",null,null,{"$f":"IF('3. TDM'!F12=\"Yes\",\"Yes\",\"No\")","v":"No"},null,"The project proposes onsite amenities. Describe the combination of amenities below.  Providing a combination of creative onsite amenities reduces the need for SOV trips throughout the day. Services within the development that will reduce the need for auto trips include grocery, restaurant, recreation rental, dry cleaning, child care, bicycle repair stations, etc.  A combination of amenities is required. ",null,"Onsite Amenities"]
[null,"Shared Shuttle Service","Will a shared shuttle service strategy be implemented?",null,null,{"$f":"IF('3. TDM'!F15=\"Yes\",\"Yes\",\"No\")","v":"No"},null,"Explain the proposed shared shuttle service strategy in the space below. The use of hotel or other customer service vehicles to shuttle employees can maximize the use of on-site resources while reducing SOV trips. The successful project will creatively consider the use of necessary business vehicles for shuttle purposes. For example, a health club with a guest shuttle could provide employee transfers to a transit center or park and ride. Note, the provision of a hotel shuttle alone does not qualify for this measure.",null,"Shared Shuttle"]
[null,"Nonmotorized Zones","Will a nonmotorized zones strategy be implemented?",null,null,{"$f":"IF('3. TDM'!F20=\"Yes\",\"Yes\",\"No\")","v":"No"},null,"Explain the proposed nonmotorized zones strategy below. Larger areas of non-motorized travel zones provide safe and comfortable space that encourages walking and bicycling, thus reducing SOV trips. Non-motorized zones are applicable for larger redevelopment or specific areas only. Public amenity space already required by the City of Aspen does not qualify for this reduction. ",null,"Nonmotorized Zones Strategy"]
[null,"Network Expansion","Will a network expansion stragtegy be implemented?",null,null,{"$f":"IF('3. TDM'!F25=\"Yes\",\"Yes\",\"No\")","v":"No"},null,"Explain the proposed network expansion strategy below. The successful project will expand the local transit network by adding or modifying existing transit service to enhance the service near the project site. This will encourage the use of transit and therefore reduce SOV trips. The successful project will work with City of Aspen staff to develop a plan that offers the best trip reduction opportunity. Note this is only applicable to major projects. \n",null,"Network Expansion strategy"]
[null,"Service Frequency/Speed","Will a service frequency/speed strategy be implemented?",null,null,{"$f":"IF('3. TDM'!F29=\"Yes\",\"Yes\",\"No\")","v":"No"},null,"Explain the service frequency/speed strategy in the space below. Reducing transit-passenger travel time through reduced headways and increased speed and reliability makes transit service more attractive, reducing SOV trips. The successful project will work with City of Aspen staff to develop a plan for increased service frequency that offers the best trip reduction opportunity. ",null,"Service Frequency/speed strategy"]
[null,"Transit Access Improvement","Will a transit access improvement strategy be implemented?",null,null,{"$f":"IF('3. TDM'!F34=\"Yes\",\"Yes\",\"No\")","v":"No"},null,"A transit access improvement strategy will be implemented. Provision of safe and comfortable access to transit service is important for generating and maintaining transit ridership, thus reducing SOV trips. The successful project will improve pedestrian access to a transit stop via formalization of trails, addition and/or improvement of sidewalk, installation of lighting and/or way finding or other measures.Explain the proposed transit access improvement strategy below. ",null,"transit access improvement strategy"]
[null,"Intercept Lot","Will an intercept lot strategy be implemented?",null,null,{"$f":"IF('3. TDM'!F37=\"Yes\",\"Yes\",\"No\")","v":"No"},null,"Explain the proposed intercept lot strategy below. The provision of a convenient location at which to park a vehicle and transfer onto an alternative mode can reduce SOV trips. The successful project will provide for a safe, convenient intercept lot at an appropriate location. Alternatively, a project can propose methods by which existing intercept lot use can be expanded. Examples include shuttles to/from existing lots, improvements to existing lots, etc. \n",null,"intercept lot strategy "]
[null,"Participation in TOP","Will there be participation in TOP?",null,null,{"$f":"IF('3. TDM'!F42=\"Yes\",\"Yes\",\"No\")","v":"No"},null,"Explain below how the project plans to participate in the Transportation Options Program (TOP). The successful project will work with City of Aspen staff to determine whether TOP membership is appropriate and, if so, to join the program.  Notes: This program is not typically appropriate for employers of less than 20 employees.  Grant funding from the TOP program may not be used to offset mitigation measures until the reporting period has been successfully completed",null,"participation in TOP"]
[null,"Transit Fare Subsidy","Is a transit fare subsidy strategy implemented?",null,null,{"$f":"IF('3. TDM'!F45=\"Yes\",\"Yes\",\"No\")","v":"No"},null,"Explain below the transit fare subsidy strategy. The successful project will provide subsidized/discounted daily or monthly public transit passes for the RFTA valley system. These passes can be partially or wholly subsidized by the project, with additional points being provided for larger subsidies. Many entities use revenue from parking to offset the cost of such a project. ",null,"transit fare subsidy strategy "]
[null,"Employee Parking Cash-Out","Is an employee parking cash-out strategy being implemented?",null,null,{"$f":"IF('3. TDM'!F49=\"Yes\",\"Yes\",\"No\")","v":"No"},null,"Explain the employee parking cash-out strategy below. The term cash-out is used to describe the provision of a choice of forgoing current subsidized/free parking for a cash payment equivalent to the cost of the parking space. The successful project will require employers to offer employee/guest parking cash-outs.\n",null,"employee parking cash-out strategy"]
[null,"Workplace Parking Pricing","Is a workplace parking pricing strategy implemented?",null,null,{"$f":"IF('3. TDM'!F52=\"Yes\",\"Yes\",\"No\")","v":"No"},null,"Explain the proposed workplace parking pricing strategy below.  The successful project will implement workplace parking pricing at its employment centers. This may include: explicitly charging for employee parking, or implementing above market-rate pricing. ",null,"workplace parking pricing strategy "]
[null,"Compressed Work Weeks","Is a compressed work weeks strategy implemented?",null,null,{"$f":"IF('3. TDM'!F56=\"Yes\",\"Yes\",\"No\")","v":"No"},null,"Provide details below for the proposed compressed work weeks strategy.  Compressed work week schedules allow an employee to work the typical 40-hour workweek in an alternative manner such as 4/10s or 9/80s. This eliminates the need for work-related travel on the days not worked, thus reducing SOV trips. The successful project will demonstrate that it will offer compressed work week schedules to 25% of its employees. ",null,"compressed work weeks strategy "]
[null,"Employer Sponsored Vanpool","Is an employer sponsered shuttle program implemented?",null,null,{"$f":"IF('3. TDM'!F60=\"Yes\",\"Yes\",\"No\")","v":"No"},null,"Explain the proposed employer sponsored shuttle program below. Provide details including route, schedule, eligibility and usage. Employer-sponsored vanpool programs entail an employer purchasing or leasing vans for employee use, and subsidizing the cost of at least program administration. The driver usually receives personal use of the van, often for a mileage fee. Scheduling is within the employer’s purview, and rider charges are normally set on the basis of vehicle and operating cost. The successful project will implement an employer-sponsored vanpool, thus reducing the need for SOV trips to and from the workplace. ",null,"employer sponsored shuttle program"]
[null,"Carpool Matching","Is a carpool matching strategy implemented?",null,null,{"$f":"IF('3. TDM'!F64=\"Yes\",\"Yes\",\"No\")","v":"No"},null,"Provide details for the proposed carpool matching strategy below. Facilitating the formation of employee carpool groups is a method of reducing SOV trips. The successful project will include use the city of Aspen Commuter Connect service to allow for the formation of carpools as well as the sharing of other important transportation information via a custom employer web page. ",null,"carpool matching strategy"]
[null,"Carshare Program","Is carshare participation being implemented?",null,null,{"$f":"IF('3. TDM'!F67=\"Yes\",\"Yes\",\"No\")","v":"No"},null,"Provide details in the space provided for the proposed carshare participation. Carshare programs have been linked to increased use of alternative transportation modes and reduced SOV trips. The successful project will provide access to Aspen’s CAR TO GO carshare program. Trip reduction potential will depend on the level to which the development participates.  Car share memberships can be provided to all employees or residents of new developments. ",null,"carshare participation "]
[null,"Bikeshare Program","Is a bikeshare program participation being implemented?",null,null,{"$f":"IF('3. TDM'!F71=\"Yes\",\"Yes\",\"No\")","v":"No"},null,"Provide details for the proposed bike share program participation. Bike sharing provides access to a fleet of bicycles for short trips, thus reducing SOV travel. The successful project will provide memberships to the existing WE-cycle program. Include details on how many WE-cycle memberships will be purchased and whether these will be made available to guests, employees, or both. ",null,"bikeshare program participation "]
[null,"End of Trip Facilities","Is an end of trip facilities strategy being implemented?",null,null,{"$f":"IF('3. TDM'!F75=\"Yes\",\"Yes\",\"No\")","v":"No"},null,"Explain the proposed end of trip facilities strategy below. The provision of convenient facilities for pedestrians and cyclists encourages these types of alternative modes, thus reducing SOV trips. Non-residential projects may provide facilities such as showers, secure bicycle lockers, personal lockers, changing spaces, etc. ",null,"end of trip facilities strategy "]
[null,"Self-funded Emergency Ride Home","Is a self-funded emergency ride home strategy being implemented?",null,null,{"$f":"IF('3. TDM'!F79=\"Yes\",\"Yes\",\"No\")","v":"No"},null,"Explain the proposed self-funded emergency ride home strategy below. Emergency Ride Home programs reduce barriers associated with alternative commute modes, thus reducing SOV trips. The successful project will develop and fund a program to provide commuters who carpool, vanpool, bike, walk or take transit to work with a reliable and free ride home - usually in a taxi or rental car when unexpected emergencies arise.  The use of the TOP program's Emergency Ride Home service is not applicable for mitigation purposes. ",null,"self-funded emergency ride home strategy "]
[null,"Carpool/Vanpool Priority Parking","Is a carpool/vanpool priority parking strategy being implemented?",null,null,{"$f":"IF('3. TDM'!F82=\"Yes\",\"Yes\",\"No\")","v":"No"},null,"Explain the proposed carpool/vanpool priority parking strategy below. Priority parking for carpools and vanpools encourages and incentivizes employees to ride-share to work, thus reducing SOV trips. The successful project will located the carpool and vanpool spaces at the front entrances of the buildings and will monitor use of parking spaces to ensure compliance. ",null,"carpool/vanpool priority parking strategy "]
[null,"Private Employer Shuttle","Is a private employer shuttle strategy being implemented?",null,null,{"$f":"IF('3. TDM'!F86=\"Yes\",\"Yes\",\"No\")","v":"No"},null,"Provide details for the proposed private employer shuttle strategy. Offering employees a customized trip to work via private shuttle reduces the need for SOV trips. The successful project will provide an employee shuttle from nearby transit stations or other identified pick up points to the place of employment. ",null,"private employer shuttle strategy "]
[null,"Trip Reduction Marketing/Incentive Program","Is a trip reduction marketing/incentive program implemented?",null,null,{"$f":"IF('3. TDM'!F90=\"Yes\",\"Yes\",\"No\")","v":"No"},null,"Explain the proposed trip reduction marketing/incentive program in the space provided. A trip reduction marketing programs should include a number of the following strategies: orientation to trip reduction programs and benefits; orientation to specific alternative transportation modes such as bus service information, bike/walk route maps, etc.; publishing of web or traditional informational materials; events and contests such as commuter fairs, new employee orientations, bike to work days, etc.; educational opportunities such bicycle commute/repair classes; web or traditional materials aimed at guests/customers such as bike/walk maps, free transit day passes, etc.; incentive programs such as prizes, rewards or discounts for alternative commuting. ",null,"trip reduction marketing/incentive program "]
[null,null,"END NOTE",null,null,"Yes",null,"Include any additional information that pertains to the TDM plan in the space provided below. "]
[null,null,null,null,"Total TDM Measures",{"$f":"COUNTIF(F44:F64,\"Yes\")","v":0}]
[]
[]
[]
[]
[]
["Level Two TIA Outline\nThe Level Two TIA shall follow this general outline:\n1. Introductory Items\n       • Front Cover / Title Page – signed and sealed by a registered Colorado Professional Engineer\n       • Table of Contents, List of Figures, and List of Tables\n       • Executive Summary\n2. Introduction/Background\n       • Project description\n       • Project applicant/contact info\n       • Type and size of development\n       • Site plan (include proposed driveways, roadways, traffic control, parking facilities, emergency vehicle access, \n           and internal circulation for vehicles, bicyclists, and pedestrians)\n       • Location map (include major streets, study intersections, and neighboring zoning and land uses)\n3. Existing Conditions\n       • Existing roadway system within project site and within the walk shed (within 250 feet radius)\n           o On-street parking configuration\n           o Sight distance limitations\n           o Location of driveways\n       • Location and routes of nearest transit routes and facilities serving the project\n       • Routes, location and width of nearest pedestrian and bicycle facilities serving the project\n       • Figure of study intersections with seasonally adjusted AM and PM peak hour turning movement counts, \n           lane geometries, signal timings, and traffic control\n       • Crash data on study roadways and intersections\n       • Map of study area showing ADT of study roadways\n       • Table of existing AM and PM peak hour average vehicle delay and LOS22 Traffic Impact Analysis Guidelines\n4. Existing Plus Project Conditions\n       • Table of trip generation for Project Trip Generation using the City of Aspen specific trip generation figures \n           (Table A-1 and A-2 in Appendix A)\n       • Figure/map of trip distribution (in percent)\n       • Maps of study area with applicable peak hour turning movements (Project Only and Existing Plus Project)\n       • Table of Existing and Existing Plus Project intersection peak hour average vehicle delay and LOS\n       • Table of Existing and Existing Plus Project MMLOS for pedestrians, bicycles, and transit\n       • Traffic signal and other warrants\n       • Findings of project impacts\n       • Access and Circulation Design\n           o Sight distance limitations\n           o Dimensions from adjacent driveways and intersections\n           o Potential for shared access facilities\n           o Demonstration that the number of proposed driveways is the fewest necessary\n           o Support that the access points will provide safe and efficient multi-modal (traffic, pedestrian, bicycle and transit) flow\n           o Internal circulation design, including adequacy of queuing (stacking) at site access points and other features that may\n               affect traffic operations and safety\n           o Pedestrian circulation system on-site and along frontage\n           o Impact to existing transit routes and facilities\n5. Future Background Conditions\n       • Table of trip generation for approved project(s) – when applicable, apply reduction for pass-by trips, transit, internal \n           capture, and other modes.\n       • Figure and/or table of approved projects trip distribution (in percent)\n       • Map of study area with applicable AM and PM peak hour turning movements (Approved Projects Only)\n       • Table of intersection peak hour average vehicle delay and LOS23 Traffic Impact Analysis Guidelines\n       • Traffic signal and other warrants\n6. Future Background Plus Project Conditions\n       • Similar content to Existing Plus Project Conditions\n7. Proposed Mitigation Program\n       • Copies of completed TDM and MMLOS toolkit spreadsheets\n• TDM Measure Details (including location of measure)\n• MMLOS Measure Details (including location of measure)\n• Enforcement & Financing\n• Scheduling and implementation responsibility of mitigation measures\n• Proposed Significant Impact Mitigation\n8. Conclusion and Recommendations\n• Summary of results, findings, and recommended mitigation measures\n9. Monitoring and Reporting Requirements\n• Vehicle Trip Data Collection\n• Assessment of Compliance with Guidelines\n• Identify Additional Strategies\n• Annual Report Submittal\n10. Appendices\n• Traffic counts\n• Technical calculations for all analyses Level Two TIA Outline\nDetails on requirements for the Level Two TIA outline items are defined later in this section.\nThe Level Two TIA shall follow this general outline:\n1. Introductory Items\n• Front Cover / Title Page – signed and sealed by a registered Colorado Professional\nEngineer\n• Table of Contents, List of Figures, and List of Tables\n• Executive Summary\n2. Introduction/Background\n• Project description\n• Project applicant/contact info\n• Type and size of development\n• Site plan (include proposed driveways, roadways, traffic control, parking facilities,\nemergency vehicle access, and internal circulation for vehicles, bicyclists, and\npedestrians)\n• Location map (include major streets, study intersections, and neighboring zoning and\nland uses)\n3. Existing Conditions\n• Existing roadway system within project site and within the walk shed (within 250 feet\nradius)\no On-street parking configuration\no Sight distance limitations\no Location of driveways\n• Location and routes of nearest transit routes and facilities serving the project\n• Routes, location and width of nearest pedestrian and bicycle facilities serving the\nproject\n• Figure of study intersections with seasonally adjusted AM and PM peak hour turning\nmovement counts, lane geometries, signal timings, and traffic control\n• Crash data on study roadways and intersections\n• Map of study area showing ADT of study roadways\n• Table of existing AM and PM peak hour average vehicle delay and LOS22 Traffic Impact Analysis Guidelines\n4. Existing Plus Project Conditions\n• Table of trip generation for Project Trip Generation using the City of Aspen specific\ntrip generation figures (Table A-1 and A-2 in Appendix A)\n• Figure/map of trip distribution (in percent)\n• Maps of study area with applicable peak hour turning movements (Project Only and\nExisting Plus Project)\n• Table of Existing and Existing Plus Project intersection peak hour average vehicle\ndelay\nand LOS\n• Table of Existing and Existing Plus Project MMLOS for pedestrians, bicycles, and\ntransit\n• Traffic signal and other warrants\n• Findings of project impacts\n• Access and Circulation Design\no Sight distance limitations\no Dimensions from adjacent driveways and intersections\no Potential for shared access facilities\no Demonstration that the number of proposed driveways is the fewest necessary\no Support that the access points will provide safe and efficient multi-modal (traffic,\npedestrian, bicycle and transit) flow\no Internal circulation design, including adequacy of queuing (stacking) at site\naccess points and other features that may affect traffic operations and safety\no Pedestrian circulation system on-site and along frontage\no Impact to existing transit routes and facilities\n5. Future Background Conditions\n• Table of trip generation for approved project(s) – when applicable, apply reduction\nfor pass-by trips, transit, internal capture, and other modes.\n• Figure and/or table of approved projects trip distribution (in percent)\n• Map of study area with applicable AM and PM peak hour turning movements\n(Approved Projects Only)\n• Table of intersection peak hour average vehicle delay and LOS23 Traffic Impact Analysis Guidelines\n• Traffic signal and other warrants\n6. Future Background Plus Project Conditions\n• Similar content to Existing Plus Project Conditions\n7. Proposed Mitigation Program\n• Copies of completed TDM and MMLOS toolkit spreadsheets\n• TDM Measure Details (including location of measure)\n• MMLOS Measure Details (including location of measure)\n• Enforcement & Financing\n• Scheduling and implementation responsibility of mitigation measures\n• Proposed Significant Impact Mitigation\n8. Conclusion and Recommendations\n• Summary of results, findings, and recommended mitigation measures\n9. Monitoring and Reporting Requirements\n• Vehicle Trip Data Collection\n• Assessment of Compliance with Guidelines\n• Identify Additional Strategies\n• Annual Report Submittal\n10. Appendices\n• Traffic counts\n• Technical calculations for all analyses ",null,null,null,null,null,null,"  "]

{"sheet":"OUTPUT","index":5,"n_rows":53,"n_cols":9,"rows_kept":53,"cut":false,"hidden":true,"merged":[[1,2,1,8],[2,2,2,8],[4,2,4,5],[5,2,5,5]]}
[]
[null,null,"Global Maximum Reduction (all VMT)"]
[null,null,{"$f":"'Maximum Calcs'!C7","v":{"$error":"#N/A"}}]
[]
[null,null,"Cross-Category Max Reduction (All VMT)",null,null,null,null,null,"Max Reduction (all VMT):"]
[null,null,{"$f":"'Maximum Calcs'!C23","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"'Maximum Calcs'!D74","v":0}]
[]
[]
[null,null,"Neighborhood/ Site Enhancements",null,null,"Transit System",null,null,"Commute Trip Reduction (CTR) Progams\n(assuming mixed-use development)"]
[null,null,"Category Reduction (all VMT):",null,null,"Category Reduction (all VMT):",null,null,"Category Reduction (work VMT):"]
[null,null,{"$f":"'Maximum Calcs'!D40","v":0},null,null,{"$f":"'Maximum Calcs'!D57","v":0},null,null,{"$f":"'Maximum Calcs'!D84","v":0}]
[]
[null,null,"Onsite Services",null,null,"Network Expansion",null,null,"Participation in TOP"]
[null,null,{"$f":"Neighborhood!D7","v":0},null,null,{"$f":"Transit!D7","v":0},null,null,{"$f":"CTR!D7","v":0}]
[]
[null,null,"Shared Shuttle Service",null,null,"Service Frequnecy/Speed",null,null,"Transit Fare Subsidy"]
[null,null,{"$f":"Neighborhood!D22","v":0},null,null,{"$f":"Transit!D26","v":0},null,null,{"$f":"CTR!D21","v":0}]
[]
[null,null,"Non-Motorized Zones",null,null,"Transit Access Improvements",null,null,"Employee Parking Cash-Out"]
[null,null,{"$f":"Neighborhood!D42","v":0},null,null,{"$f":"Transit!D51","v":0},null,null,{"$f":"CTR!D41","v":0}]
[]
[null,null,null,null,null,"Intercept Lot",null,null,"Workplace Parking Pricing"]
[null,null,null,null,null,{"$f":"Transit!D66","v":0},null,null,{"$f":"CTR!D57","v":0}]
[]
[null,null,null,null,null,"Bus Stops with Real Time Arrival",null,null,"Compressed Work Weeks"]
[null,null,null,null,null,{"$f":"Transit!D80","v":{"$error":"#REF!"}},null,null,{"$f":"CTR!D76","v":0}]
[]
[null,null,null,null,null,null,null,null,"Employer Sponsored Vanpool"]
[null,null,null,null,null,null,null,null,{"$f":"CTR!D97","v":0}]
[]
[null,null,null,null,null,null,null,null,"Carpool Matching"]
[null,null,null,null,null,null,null,null,{"$f":"CTR!D116","v":0}]
[]
[null,null,null,null,null,null,null,null,"Carshare Program"]
[null,null,null,null,null,null,null,null,{"$f":"CTR!D132","v":0}]
[]
[null,null,null,null,null,null,null,null,"Bike Share Program"]
[null,null,null,null,null,null,null,null,{"$f":"CTR!D149","v":0}]
[]
[null,null,null,null,null,null,null,null,"End of Trip Facilities"]
[null,null,null,null,null,null,null,null,{"$f":"CTR!D166","v":0}]
[]
[null,null,null,null,null,null,null,null,"Emergency Ride Home"]
[null,null,null,null,null,null,null,null,{"$f":"CTR!D184","v":0}]
[]
[null,null,null,null,null,null,null,null,"Carpool/Vanpool Priority Parking"]
[null,null,null,null,null,null,null,null,{"$f":"CTR!D196","v":0}]
[]
[null,null,null,null,null,null,null,null,"Private Employer Shuttle"]
[null,null,null,null,null,null,null,null,{"$f":"CTR!D215","v":0}]
[]
[null,null,null,null,null,null,null,null,"Trip Reduction Marketing Program"]
[null,null,null,null,null,null,null,null,{"$f":"CTR!D235","v":0}]

{"sheet":"Maximum Calcs","index":6,"n_rows":110,"n_cols":9,"rows_kept":110,"cut":false,"hidden":true,"merged":[[109,1,109,10],[8,2,9,9],[24,2,25,9],[70,2,70,9],[85,3,86,8],[58,3,59,8],[106,2,106,9],[74,4,76,8],[73,4,73,5],[73,7,73,8],[3,1,3,10],[18,1,18,10],[34,1,34,10],[51,2,51,9],[22,3,22,4],[6,3,6,4],[41,3,42,8]]}
[null,null,"= input"]
[null,null,"= calculation"]
[]
[null,"Maximum Calculations"]
[]
[]
[null,null,{"$f":"MIN(VLOOKUP('1. Trip Generation'!C21,'Maximum Calcs'!D12:E13,2,FALSE),C8)","v":{"$error":"#N/A"}},"% Global VMT Reduction"]
[null,null,{"$f":"1-(1-C16)*(1-C17)","v":{"$error":"#N/A"}},"pre-cap reduction"]
[null,null,"= Minimum (X%, 1- (1-[a])*(1-[b]))\nwhere:"]
[]
[null,null,null,null,"X% ="]
[null,null,null,"major",{"$f":"Assumptions!D70","v":0.75},null,null,null,"see assumptions tab"]
[null,null,null,"minor",{"$f":"Assumptions!D71","v":0.4},null,null,null,"see assumptions tab"]
[]
[null,null,"Cross-Category VMT Reductions"]
[null,"[a]",{"$f":"C23","v":{"$error":"#N/A"}},"Neighborhood + Transit"]
[null,"[b]",{"$f":"D74","v":0},"CTR Programs"]
[]
[null,"Global Maximum"]
[]
[]
[]
[null,null,{"$f":"MIN(VLOOKUP('1. Trip Generation'!C21,'Maximum Calcs'!D28:E29,2,FALSE),C24)","v":{"$error":"#N/A"}},"% Cross-Category VMT Reduction"]
[null,null,{"$f":"1-(1-C32)*(1-C33)","v":0},"pre-cap reduction"]
[null,null,"= Minimum (X%, 1- (1-[a])*(1-[b])*(1-[c])*(1-[d]))\nwhere:"]
[]
[null,null,null,null,"X% ="]
[null,null,null,"Major",{"$f":"Assumptions!D78","v":0.7},null,null,null,"see assumptions tab"]
[null,null,null,"Minor",{"$f":"Assumptions!D79","v":0.35},null,null,null,"see assumptions tab"]
[]
[null,null,"Category VMT Reductions"]
[null,"[a]",{"$f":"D40","v":0},"Neighborhood / Site Enhancements"]
[null,"[b]",{"$f":"D57","v":0},"Transit System Improvements"]
[]
[null,"Cross Category Maximum"]
[]
[]
[]
[]
[null,null,null,{"$f":"MIN(F45,1-(1-D48)*(1-D49)*(1-D50))","v":0},"% Category VMT Reduction"]
[]
[null,null,null,"= Minimum (X%, 1- (1-[a])*(1-[b])*(1-[c])*(1-[d]))\nwhere:"]
[]
[null,null,null,null,null,"X% ="]
[null,null,null,null,"neighborhood shuttle",0.15,null,"see assumptions tab"]
[]
[null,null,null,"Strategy VMT Reductions"]
[null,null,"[a]",{"$f":"Neighborhood!D7","v":0},"Onsite Services"]
[null,null,"[b]",{"$f":"Neighborhood!D22","v":0},"Shared Shuttle Service"]
[null,null,"[c]",{"$f":"Neighborhood!D42","v":0},"Non-motorized zones"]
[]
[null,null,"Neighborhood / Site Enhancements Strategies"]
[]
[]
[]
[]
[null,null,null,{"$f":"MIN(F62, 1-(1-D65)*(1-D66)*(1-D67)*(1-D68)*(1-D69))","v":0},"% Category VMT Reduction"]
[]
[null,null,null,"= Minimum (X%, 1- (1-[a])*(1-[b])*(1-[c]))\nwhere:"]
[]
[null,null,null,null,null,"X% ="]
[null,null,null,null,null,{"$f":"Assumptions!E95","v":0.1},null,"see assumptions tab"]
[]
[null,null,null,"Strategy VMT Reductions"]
[null,null,"[a]",{"$f":"Transit!D7","v":0},"Network Expansion"]
[null,null,"[b]",{"$f":"Transit!D26","v":0},"Service Frequency/Speed"]
[null,null,"[c]",{"$f":"Transit!D51","v":0},"Transit Access Imrovements"]
[null,null,"[d]",{"$f":"Transit!D66","v":0},"Intercept Lot"]
[null,null,"[e]",{"$f":"Transit!D79","v":0},"Bus Stops with Real Time Arrival"]
[]
[null,null,"Transit System Improvements Strategies"]
[]
[]
[null,null,null,{"$f":"MIN(F79,D84*F81)","v":0},"% Category Overall VMT Reduction"]
[null,null,null,null,"= Minimum(X%, %work trips*%category work VMT reduction)\nwhere:"]
[]
[]
[null,null,null,null,null,"X% ="]
[null,null,null,null,null,{"$f":"Assumptions!E101","v":0.15},null,"see assumptions tab"]
[null,null,null,null,null,"Percent of trips which are:"]
[null,null,null,null,"work trips",{"$f":"Assumptions!E104","v":0.218},null,"see assumptions tab"]
[]
[null,null,null,"Work Calculations"]
[null,null,null,{"$f":"MIN(F90,1-(1-D92)*(1-D93)*(1-D94)*(1-D95)*(1-D96)*(1-D97)*(1-D98)*(1-D99)*(1-D100)*(1-D101)*(1-D102)*(1-D103)*(1-D104)*(1-D105))","v":0},"% Category Work VMT Reduction"]
[]
[null,null,null,"= Minimum (X%, 1- (1-Max([a],[b]))*(1-[c])*(1-[d])*(1-[e])...*(1-[i]))\nwhere:"]
[]
[]
[null,null,null,null,null,"X% ="]
[null,null,null,null,null,{"$f":"Assumptions!E102","v":0.4},null,"see assumptions tab"]
[null,null,null,"Strategy VMT Reductions"]
[null,null,"[a]",{"$f":"CTR!D7","v":0},"Particpation in TOP"]
[null,null,"[b]",{"$f":"CTR!D21","v":0},"Transit Fare Subsidy"]
[null,null,"[c]",{"$f":"CTR!D41","v":0},"Employee Parking Cash-Out"]
[null,null,"[d]",{"$f":"CTR!D57","v":0},"Workplace Parking Pricing"]
[null,null,"[e]",{"$f":"CTR!D76","v":0},"Compressed Work Weeks"]
[null,null,"[f]",{"$f":"CTR!D97","v":0},"Employer-Sponsored Vanpool/Shuttle"]
[null,null,"[g]",{"$f":"CTR!D116","v":0},"Carpool Matching"]
[null,null,"[h]",{"$f":"CTR!D132","v":0},"Carshare Program"]
[null,null,"[i]",{"$f":"CTR!D149","v":0},"Bikeshare Program"]
[null,null,"[j]",{"$f":"CTR!D166","v":0},"End of Trip Facilities"]
[null,null,"[k]",{"$f":"CTR!D184","v":0},"Emergency Ride Home"]
[null,null,"[l]",{"$f":"CTR!D196","v":0},"Carpool/Vanpool Priority Parking"]
[null,null,"[m]",{"$f":"CTR!D215","v":0},"Private Employer Shuttle"]
[null,null,"[n]",{"$f":"CTR!D235","v":0},"Trip Reduction Marketing Program "]
[]
[null,null,"Commute Trip Reduction"]
[]
[]
[null,"Category Maximums"]

{"sheet":"Neighborhood","index":7,"n_rows":51,"n_cols":9,"rows_kept":51,"cut":false,"hidden":true,"merged":[[29,5,29,7],[38,2,38,9],[3,1,3,10],[18,2,18,9],[50,2,50,9],[10,4,10,5],[12,5,12,6],[13,5,13,6],[14,5,14,6],[24,3,24,8],[27,5,27,7]]}
[null,null,"= input"]
[null,null,"= calculation"]
[]
[null,"Neighborhood / Site Enhancements Strategies"]
[]
[]
[null,null,null,{"$f":"IF('3. TDM'!$F$12=\"yes\",VLOOKUP(E11,F14:H15,3,FALSE),0)","v":0},"VMT Reduction"]
[]
[null,null,null,"Mitigation Method:"]
[]
[null,null,null,null,{"$f":"'3. TDM'!F13","v":0},null,"extent of ped accommodations",null,"see input tab"]
[]
[null,null,null,null,null,"Description of site amenities",null,"Estimated VMT Reduction"]
[null,null,null,null,null,"Retail Servicing",null,0.03]
[null,null,null,null,null,"Hotel with Retail Servicing",null,0.1]
[]
[]
[]
[null,null,"Onsite Services"]
[]
[]
[null,null,null,{"$f":"IF('3. TDM'!F15=\"yes\",E27*E34*E35,0)","v":0},"commute VMT Reduction"]
[]
[null,null,null,"Mitigation Method:"]
[null,null,null,"% Reduction in VMT =  % shift in shared shuttle mode share of commute trips * % customers eligible * adjustment from shared shuttle mode share to VMT"]
[null,null,null,"where:"]
[null,null,null,"1)",{"$f":"VLOOKUP('3. TDM'!F17,Neighborhood!E31:H33,MATCH('3. TDM'!F16,Neighborhood!E29:H29,0),FALSE)","v":{"$error":"#N/A"}},"percentage shift in vanpool mode share of commute trips"]
[null,null,null,null,null,"Level of Implementation"]
[null,null,null,null,null,"Low","Medium","High"]
[null,null,null,null,"Company Size","% shift in vanpool mode share of commute trips"]
[null,null,null,null,"Small",0.02,0.05,0.1]
[null,null,null,null,"Medium",0.05,0.11,0.15]
[null,null,null,null,"Large",0.1,0.15,0.2]
[null,null,null,"2)",{"$f":"MIN(MAX('3. TDM'!F18,0),1)","v":0},"percentage of customers eligible",null,null,"see input tab"]
[null,null,null,"3)",{"$f":"Assumptions!D24","v":0.69},"Adjustment from vanpool mode share to commute VMT",null,null,"see assumptions tab"]
[]
[]
[]
[null,null,"Shared Shuttle Service"]
[]
[]
[null,null,null,{"$f":"IF('3. TDM'!F20=\"yes\", E46,0)","v":0},"VMT Reduction"]
[]
[null,null,null,"Mitigation Method:"]
[]
[null,null,null,null,1E-3,"VMT Reduction",null,null,"see input tab"]
[]
[]
[]
[]
[null,null,"Non-Motorized Zones"]

{"sheet":"Transit","index":8,"n_rows":88,"n_cols":9,"rows_kept":88,"cut":false,"hidden":true,"merged":[[87,2,87,9],[54,4,54,5],[56,5,56,6],[57,5,57,6],[58,5,58,6],[62,2,62,9],[74,2,74,9],[3,1,3,10],[22,2,22,9],[47,2,47,9],[9,3,10,8],[28,3,29,8],[36,5,36,6]]}
[null,null,"= input"]
[null,null,"= calculation"]
[]
[null,"Transit System Improvements Strategies"]
[]
[]
[null,null,null,{"$f":"IF('3. TDM'!F25=\"yes\",E13*E14*E18*E19,0)","v":0},"VMT Reduction"]
[]
[null,null,null,"Mitigation Method:"]
[null,null,null,"% Reduction in VMT = % increase in transit network coverage * elasticity of transit ridership w.r.t. service coverage * existing transit mode share * adjustment from transit ridership increase to VMT"]
[]
[null,null,null,"where:"]
[null,null,null,"1)",{"$f":"MAX(0, '3. TDM'!F26)","v":0},"percentage increase in transit network coverage",null,null,"see input tab"]
[null,null,null,"2)",{"$f":"VLOOKUP('1. Trip Generation'!C21,Transit!F16:G17,2,FALSE)","v":{"$error":"#N/A"}},"elasticity of transit ridership w.r.t. service coverage"]
[null,null,null,null,null,"Project Setting","elasticity"]
[null,null,null,null,null,"Major",0.65]
[null,null,null,null,null,"Minor",0.72]
[null,null,null,"3)",{"$f":"MIN(MAX(0,'3. TDM'!F27),1)","v":0},"existing transit mode share",null,null,"see input tab"]
[null,null,null,"4)",{"$f":"Assumptions!D32","v":0.69},"adjustment from transit ridership increase to VMT",null,null,"see assumptions tab"]
[]
[]
[]
[null,null,"Network Expansion"]
[]
[]
[null,null,null,{"$f":"IF('3. TDM'!F29=\"yes\", E32*E33*E36*E43*E44,0)","v":0},"VMT Reduction"]
[]
[null,null,null,"Mitigation Method:"]
[null,null,null,"% Reduction in VMT = % reduction in headways * elasticity of transit ridership w.r.t. increased frequency of service * adjustment for level of implementation * existing transit mode share * adjustment from transit ridership increase to VMT"]
[]
[null,null,null,"where:"]
[null,null,null,"1)",{"$f":"MIN(MAX(0,'3. TDM'!F30), 1)","v":0},"percentage reduction in headways (increase in frequency)",null,null,"see input tab"]
[null,null,null,"2)",{"$f":"VLOOKUP('1. Trip Generation'!C21,Transit!F34:G35,2,FALSE)","v":{"$error":"#N/A"}},"elasticity of transit ridership w.r.t. increased frequency of service"]
[null,null,null,null,null,"Major",0.32]
[null,null,null,null,null,"Minor",0.32]
[null,null,null,"3)",{"$f":"IF(F37=\"<50% of lines (within project) improved\",G40,G41)","v":0.85},"adjustment for level of implementation"]
[null,null,null,null,null,{"$f":"'3. TDM'!F32","v":0},null,"level of implementation","see input tab"]
[]
[null,null,null,null,null,"level of implementation","Adjustment"]
[null,null,null,null,null,"<50%",0.5]
[null,null,null,null,null,">=50%",0.85]
[]
[null,null,null,"4)",{"$f":"MIN(MAX(0,'3. TDM'!F31),1)","v":0},"existing transit mode share (as a %)",null,null,"see input tab"]
[null,null,null,"5)",{"$f":"Assumptions!D37","v":0.69},"adjustment from transit ridership increase to VMT",null,null,"see assumptions tab"]
[]
[]
[]
[null,null,"Service Frequency/Speed"]
[]
[]
[null,null,null,{"$f":"IF('3. TDM'!F34=\"yes\",VLOOKUP(E55,F58:H59,3,FALSE),0)","v":0},"VMT Reduction"]
[]
[null,null,null,"Mitigation Method:"]
[]
[null,null,null,null,{"$f":"'3. TDM'!F35","v":0},null,"extent of ped accommodations",null,"see input tab"]
[]
[null,null,null,null,null,"Extent of Access Improvements",null,"Estimated VMT Reduction"]
[null,null,null,null,null,"Within Project and Connecting Off-site",null,0.02]
[null,null,null,null,null,"Within Project Only",null,0.01]
[]
[]
[]
[null,null,"Transit Access Improvements"]
[]
[]
[null,null,null,{"$f":"IF('3. TDM'!F37=\"yes\", E70,0)","v":0},"VMT Reduction"]
[]
[null,null,null,"Mitigation Method:"]
[]
[null,null,null,null,5.0000000000000001E-3,"VMT Reduction",null,null,"see input tab"]
[]
[]
[]
[]
[null,null,"Intercept Lot"]
[]
[]
[]
[null,null,null,0,"VMT Reduction"]
[null,null,null,{"$f":"IF('3. TDM'!#REF!=\"Yes\",Transit!E83*Transit!E84,0)","v":{"$error":"#REF!"}}]
[null,null,null,"Mitigation Method:"]
[]
[null,null,null,null,1.7999999999999999E-2,"VMT Reduction",null,null,"see input tab"]
[null,null,null,null,0,"percentage of bus stops receiving real time arrival"]
[]
[]
[]
[null,null,"Bus Stops with Real Time Arrival"]

{"sheet":"CTR","index":9,"n_rows":246,"n_cols":14,"rows_kept":246,"cut":false,"hidden":true,"merged":[[92,2,92,9],[171,5,171,6],[162,2,162,9],[168,3,168,8],[137,5,137,6],[118,3,118,8],[154,5,154,6],[134,3,134,8],[102,5,102,7],[151,3,151,8],[145,2,145,9],[128,2,128,9],[112,2,112,9],[108,5,108,7],[245,2,245,9],[201,5,201,7],[192,2,192,9],[155,5,155,6],[217,3,217,8],[173,5,173,6],[237,3,237,8],[210,2,210,9],[226,5,226,7],[230,2,230,9],[180,2,180,9],[83,5,83,6],[99,3,99,8],[3,1,3,10],[37,2,37,9],[53,2,53,9],[72,2,72,9],[78,3,78,8],[28,5,28,8],[26,5,26,8],[43,3,43,8],[64,5,64,8],[9,3,9,8],[59,3,59,8],[17,2,17,9],[62,5,62,8],[23,3,23,8]]}
[null,null,"= input"]
[null,null,"= calculation"]
[]
[null,"Commute Trip Reduction (CTR) Programs and School Strategies"]
[]
[]
[null,null,null,{"$f":"IF('3. TDM'!F42=\"yes\",E12*E13*E14,0)","v":0},"commute VMT Reduction"]
[]
[null,null,null,"Mitigation Method:"]
[null,null,null,"% Reduction in commute VMT =  % reduction in commute vehicle trips * % employees eligible * adjustment from commute VT to commute VMT"]
[null,null,null,"where:"]
[null,null,null,"1)",0.04,"percentage reduction in commute VT"]
[null,null,null,"2)",{"$f":"MIN(MAX('3. TDM'!F43,0),1)","v":0},"percentage of employees eligible",null,null,"see input tab"]
[null,null,null,"3)",{"$f":"Assumptions!D47","v":1},"Adjustment from commute VT to commute VMT",null,null,"see assumptions tab"]
[]
[]
[]
[null,null,"Participation in TOP"]
[]
[]
[null,null,null,{"$f":"IF('3. TDM'!F45=\"yes\",CTR!E26*CTR!E33*CTR!E34,0)","v":0},"commute VMT Reduction"]
[]
[null,null,null,"Mitigation Method:"]
[null,null,null,"% Reduction in commute VMT = % reduction in commute vehicle trips * % of employees eligible * Adjustment from commute VT to commute VMT"]
[null,null,null,"where:"]
[null,null,null,"1)",{"$f":"VLOOKUP('1. Trip Generation'!C21,CTR!E30:I31,MATCH('3. TDM'!F47,CTR!E28:I28,0),FALSE)","v":{"$error":"#N/A"}},"percentage reduction in commute VT"]
[null,null,null,null,null,"Daily Transit Subsidy (per passenger)"]
[null,null,null,null,null,0.25,0.5,0.75,1]
[null,null,null,null,"Worksite Setting","% Reduction in Commute VT"]
[null,null,null,null,"Major",6.2E-2,0.129,0.2,0.2]
[null,null,null,null,"Minor",6.2E-2,0.129,0.2,0.2]
[]
[null,null,null,"2)",{"$f":"MIN(MAX('3. TDM'!F46,0),1)","v":0},"percentage of employees eligible",null,null,"see input tab"]
[null,null,null,"3)",{"$f":"Assumptions!D53","v":0.69},"Adjustment from commute VT to commute VMT",null,null,"see assumptions tab"]
[]
[]
[]
[null,null,"Transit Fare Subsidy"]
[]
[]
[null,null,null,{"$f":"IF('3. TDM'!F49=\"yes\", E46*E50,0)","v":0},"commute VMT Reduction"]
[]
[null,null,null,"Mitigation Method:"]
[null,null,null,"% Reduction in commute VMT = % reduction in commute VMT * % of employees eligible"]
[null,null,null,"where:"]
[null,null,null,"1)",{"$f":"VLOOKUP('1. Trip Generation'!C21,CTR!F48:G49,2,FALSE)","v":{"$error":"#N/A"}},"percentage reduction in commute VT"]
[null,null,null,null,null,"Project Setting","% reduction"]
[null,null,null,null,null,"Major",7.6999999999999999E-2]
[null,null,null,null,null,"Minor",7.6999999999999999E-2]
[null,null,null,"2)",{"$f":"MIN(MAX('3. TDM'!F50,0),1)","v":0},"percentage of employees eligible",null,null,"see input tab"]
[]
[]
[]
[null,null,"Employee Parking Cash-Out"]
[]
[]
[null,null,null,{"$f":"IF('3. TDM'!F52=\"yes\",CTR!E62*CTR!E69,0)","v":0},"commute VMT Reduction"]
[]
[null,null,null,"Mitigation Method:"]
[null,null,null,"% Reduction in commute VMT =  % reduction in commute VMT * % of employees subject to priced parking"]
[null,null,null,"where:"]
[null,null,null,"1)",{"$f":"VLOOKUP('1. Trip Generation'!C21,CTR!E66:I67,MATCH('3. TDM'!F53,CTR!E64:I64,0),FALSE)","v":{"$error":"#N/A"}},"percentage reduction in commute VT"]
[null,null,null,null,null,"Daily Parking Charge"]
[null,null,null,null,null,1,2,3,6]
[null,null,null,null,"Worksite Setting","% Reduction in Commute VT"]
[null,null,null,null,"Major",6.9000000000000006E-2,0.125,0.16800000000000001,0.19700000000000001]
[null,null,null,null,"Minor",6.9000000000000006E-2,0.125,0.16800000000000001,0.19700000000000001]
[]
[null,null,null,"2)",{"$f":"MIN(MAX('3. TDM'!F54,0),1)","v":0},"percentage of employees subject to priced parking",null,null,"see input tab"]
[]
[]
[]
[null,null,"Workplace Parking Pricing"]
[]
[]
[null,null,null,{"$f":"IF('3. TDM'!F56=\"yes\",E81,0)","v":0},"commute VMT Reduction"]
[]
[null,null,null,"Mitigation Method:"]
[null,null,null,"% Reduction in commute VMT =  reduction based on employee participation and strategy implemented"]
[null,null,null,"where:"]
[null,null,null,"1)",{"$f":"VLOOKUP('3. TDM'!F57,CTR!E85:G89,MATCH('3. TDM'!F58,CTR!E83:G83,0),TRUE)","v":{"$error":"#N/A"}},"percentage reduction in commute VT"]
[null,null,null,null,null,"Work week:"]
[null,null,null,null,null,"9-day/80-hour","4-day/40-hour"]
[null,null,null,null,"Employee Participation","% Reduction in Commute VT"]
[null,null,null,null,0.01,6.9999999999999999E-4,1.5E-3]
[null,null,null,null,0.03,2.0999999999999999E-3,4.4999999999999997E-3]
[null,null,null,null,0.05,3.5000000000000001E-3,7.4999999999999997E-3]
[null,null,null,null,0.1,7.0000000000000001E-3,1.4999999999999999E-2]
[null,null,null,null,0.25,1.7500000000000002E-2,3.7499999999999999E-2]
[]
[]
[]
[null,null,"Compressed Work Weeks"]
[]
[]
[]
[null,null,null,{"$f":"IF('3. TDM'!F60=\"yes\",CTR!E102*CTR!E108*CTR!E109,0)","v":0},"commute VMT Reduction"]
[]
[null,null,null,"Mitigation Method:"]
[null,null,null,"% Reduction in commute VMT =  % shift in vanpool/shuttle mode share of commute trips * % employees eligible * adjustment from vanpool/shuttle mode share to commute VMT"]
[null,null,null,"where:"]
[null,null,null,"1)",{"$f":"VLOOKUP('3. TDM'!F61,CTR!E105:F107,2,FALSE)","v":{"$error":"#N/A"}},"percentage shift in vanpool/shuttle  mode share of commute trips"]
[]
[null,null,null,null,"Employer Size","% shift in vanpool mode share of commute trips"]
[null,null,null,null,"Small",0.02]
[null,null,null,null,"Medium",0.05]
[null,null,null,null,"Large",0.1]
[null,null,null,"2)",{"$f":"MIN(MAX('3. TDM'!F62,0),1)","v":0},"percentage of employees eligible",null,null,"see input tab"]
[null,null,null,"3)",{"$f":"Assumptions!D53","v":0.69},"Adjustment from vanpool mode share to commute VMT",null,null,"see assumptions tab"]
[]
[]
[]
[null,null,"Employer Sponsored Vanpool/Shuttle"]
[]
[]
[null,null,null,{"$f":"IF('3. TDM'!F64=\"yes\",CTR!E121*CTR!E125,0)","v":0},"commute VMT Reduction"]
[]
[null,null,null,"Mitigation Method:"]
[null,null,null,"% Reduction in commute VMT =  % reduction in commute VMT * % of employees eligible"]
[null,null,null,"where:"]
[null,null,null,"1)",{"$f":"VLOOKUP('1. Trip Generation'!C21,CTR!F123:G124,2,FALSE)","v":{"$error":"#N/A"}},"percentage reduction in commute VMT"]
[null,null,null,null,null,"Project Setting","% Reduction"]
[null,null,null,null,null,"Major",7.4999999999999997E-2]
[null,null,null,null,null,"Minor",7.4999999999999997E-2]
[null,null,null,"2)",{"$f":"MIN(MAX('3. TDM'!F65,0),1)","v":0},"percentage of employees eligible",null,null,"see input tab"]
[]
[]
[]
[null,null,"Carpool Matching"]
[]
[]
[null,null,null,{"$f":"IF('3. TDM'!F67=\"yes\",E137,0)","v":0},"commute VMT Reduction"]
[]
[null,null,null,"Mitigation Method:"]
[null,null,null,"% Reduction in commute VMT =  reduction based on employee participation and strategy implemented"]
[null,null,null,"where:"]
[null,null,null,"1)",{"$f":"VLOOKUP('3. TDM'!F68,CTR!E140:F142,2,FALSE)","v":{"$error":"#N/A"}},"percentage reduction in commute VT"]
[]
[null,null,null,null,"Employer Size","% Reduction in Commute VT"]
[null,null,null,null,"<100",0.02]
[null,null,null,null,"101-500",2.5000000000000001E-2]
[null,null,null,null,">500",0.03]
[]
[]
[]
[null,null,"Carshare Program"]
[]
[]
[null,null,null,{"$f":"IF('3. TDM'!F71=\"yes\",E154,0)","v":0},"commute VMT Reduction"]
[]
[null,null,null,"Mitigation Method:"]
[null,null,null,"% Reduction in commute VMT =  reduction based on employee participation and strategy implemented"]
[null,null,null,"where:"]
[null,null,null,"1)",{"$f":"VLOOKUP('3. TDM'!F72,E157:F159,2,FALSE)","v":{"$error":"#N/A"}},"percentage reduction in commute VT"]
[]
[null,null,null,null,"Employer Size","% Reduction in Commute VT"]
[null,null,null,null,"<100",1.4999999999999999E-2]
[null,null,null,null,"101-500",1.7500000000000002E-2]
[null,null,null,null,">500",0.02]
[]
[]
[]
[null,null,"Bikeshare Program"]
[]
[]
[null,null,null,{"$f":"IF('3. TDM'!F75=\"Yes\",E171,0)","v":0},"commute VMT Reduction"]
[]
[null,null,null,"Mitigation Method:"]
[null,null,null,"% Reduction in commute VMT =  reduction based on employee participation and strategy implemented"]
[null,null,null,"where:"]
[null,null,null,"1)",{"$f":"VLOOKUP('3. TDM'!F77,CTR!E175:G177,MATCH('3. TDM'!F76,CTR!E173:G173,0),FALSE)","v":{"$error":"#N/A"}},"percentage reduction in commute VT"]
[null,null,null,null,null,"Level of Implementation"]
[null,null,null,null,null,"Low","High"]
[null,null,null,null,"Employer Size","% Reduction in Commute VT"]
[null,null,null,null,"Small",0.01,3.5000000000000003E-2]
[null,null,null,null,"Medium",1.4999999999999999E-2,3.7499999999999999E-2]
[null,null,null,null,"Large",1.7500000000000002E-2,0.04]
[]
[]
[]
[null,null,"End of Trip Facilities"]
[]
[]
[null,null,null,{"$f":"IF('3. TDM'!F79=\"yes\",E188*E189,0)","v":0},"VMT Reduction"]
[]
[null,null,null,"Mitigation Method:"]
[]
[null,null,null,null,2.5000000000000001E-3,"VMT Reduction",null,null,"see input tab"]
[null,null,null,null,{"$f":"MIN(MAX('3. TDM'!F80,0),1)","v":0},"percentage of employees eligible",null,null,null,null,null,null,null,"`"]
[]
[]
[]
[null,null,"Self-funded Emergency Ride Home"]
[]
[]
[null,null,null,{"$f":"IF('3. TDM'!F82=\"yes\", E200,0)","v":0},"VMT Reduction"]
[]
[null,null,null,"Mitigation Method:"]
[]
[null,null,null,null,{"$f":"VLOOKUP('3. TDM'!F83,CTR!E204:H206,MATCH('3. TDM'!F84,CTR!E203:H203,0),FALSE)","v":{"$error":"#N/A"}},"VMT Reduction",null,null,"see input tab"]
[]
[null,null,null,null,null,"Number of parking spots"]
[null,null,null,null,"Employer Size",1,2,"3+"]
[null,null,null,null,"Small",2E-3,2E-3,2E-3]
[null,null,null,null,"Medium",1E-3,2E-3,2E-3]
[null,null,null,null,"Large",2E-3,2E-3,3.0000000000000001E-3]
[]
[]
[]
[]
[null,null,"Carpool/Vanpool Parking"]
[]
[]
[]
[null,null,null,{"$f":"IF('3. TDM'!F86=\"yes\",CTR!E220*CTR!E226*CTR!E227,0)","v":0},"commute VMT Reduction"]
[]
[null,null,null,"Mitigation Method:"]
[null,null,null,"% Reduction in commute VMT =  % shift in vanpool mode share of commute trips * % employees eligible * adjustment from vanpool mode share to commute VMT"]
[null,null,null,"where:"]
[null,null,null,"1)",{"$f":"VLOOKUP('3. TDM'!F87,CTR!E223:F225,2,FALSE)","v":{"$error":"#N/A"}},"percentage shift in vanpool/shuttle  mode share of commute trips"]
[]
[null,null,null,null,"Employer Size","% shift in vanpool mode share of commute trips"]
[null,null,null,null,"Small",0.02]
[null,null,null,null,"Medium",0.05]
[null,null,null,null,"Large",0.1]
[null,null,null,"2)",{"$f":"MIN(MAX('3. TDM'!F88,0),1)","v":0},"percentage of employees eligible",null,null,"see input tab"]
[null,null,null,"3)",{"$f":"Assumptions!D53","v":0.69},"Adjustment from vanpool/shuttle mode share to commute VMT",null,null,"see assumptions tab"]
[]
[]
[]
[null,null,"Private Employer Shuttle"]
[]
[]
[]
[null,null,null,{"$f":"IF('3. TDM'!F90=\"yes\",E240*E241*E242,0)","v":0},"commute VMT Reduction"]
[]
[null,null,null,"Mitigation Method:"]
[null,null,null,"% Reduction in commute VMT =  % reduction in commute vehicle trips * % employees eligible * adjustment from commute VT to commute VMT"]
[null,null,null,"where:"]
[null,null,null,"1)",0.04,"percentage reduction in commute VT"]
[null,null,null,"2)",{"$f":"MIN(MAX('3. TDM'!F91,0),1)","v":0},"percentage of employees eligible",null,null,"see input tab"]
[null,null,null,"3)",{"$f":"Assumptions!D59","v":1},"Adjustment from commute VT to commute VMT",null,null,"see assumptions tab"]
[]
[]
[]
[null,null,"Trip Reduction Marketing Program "]

{"sheet":"Assumptions","index":10,"n_rows":120,"n_cols":7,"rows_kept":120,"cut":false,"hidden":true,"merged":[[3,1,3,10],[40,1,40,10],[38,2,38,9],[61,2,61,9],[64,1,64,10],[16,2,16,9],[18,1,18,10],[27,1,27,10],[33,2,33,9],[25,2,25,9],[119,1,119,10],[114,3,114,8],[49,2,49,9],[55,2,55,9],[73,2,73,9],[81,2,81,9],[117,2,117,9],[89,3,89,8],[96,3,96,8]]}
[null,null,"= input"]
[null,null,"= calculation"]
[]
[null,"Assumptions Page"]
[]
[]
[]
[null,null,null,null,"Trip Type","Weekday %"]
[null,null,null,null,"HBW",0.218]
[null,null,null,null,"HBShop",0.25600000000000001]
[null,null,null,null,"HBSocial",0.17299999999999999]
[null,null,null,null,"HBS",0.121]
[null,null,null,null,"NHB",0.23200000000000001]
[null,null,null,null,"Total",{"$f":"SUM(F9:F13)","v":1}]
[null,null,null,null,"Source: SF Bay Area Travel Survey 2000, Regional Travel Characteristics Report, Table 2.1.2"]
[]
[null,null,"Percentage of Work Related VMT"]
[]
[null,"General Input"]
[]
[]
[]
[]
[null,null,null,0.69,"adjustment from transit ridership increase to VMT [see Transit Accessibility assumptions]"]
[]
[null,null,"Shared Shuttle Service"]
[]
[null,"Neighborhood / Site Enhancements Strategies"]
[]
[]
[]
[null,null,null,0.69,"adjustment from transit ridership increase to VMT [see Transit Accessibility assumptions]"]
[]
[null,null,"Network Expansion"]
[]
[]
[null,null,null,0.69,"adjustment from transit ridership increase to VMT [see Transit Accessibility assumptions]"]
[]
[null,null,"Service Frequency/Speed"]
[]
[null,"Transit"]
[]
[]
[]
[]
[]
[null,null,null,1,"Adjustment from commute VT to commute VMT"]
[null,null,null,"See appendix for detailed documentation of assumptions"]
[]
[null,null,"CTR Marketing"]
[]
[]
[null,null,null,0.69,"Adjustment from vanpool mode share to commute VMT [see Transit Accessibility assumptions]"]
[null,null,null,"See appendix for detailed documentation of assumptions"]
[]
[null,null,"Employer Sponsored Vanpool/Shuttle"]
[]
[]
[null,null,null,1,"Adjustment from commute VT to commute VMT"]
[null,null,null,"See appendix for detailed documentation of assumptions"]
[]
[null,null,"Trip Reduction Marketing Program"]
[]
[]
[null,"Commute Trip Reduction (CTR) Programs Strategies"]
[]
[]
[]
[null,null,null,"X% = ","Global Maximum for:"]
[null,null,null,0.75,"Major"]
[null,null,null,0.4,"Minor"]
[null,null,null,"See Introduction Section for detailed documentation of assumptions"]
[]
[null,null,"Global Maximum"]
[]
[]
[null,null,null,"X% = ","Cross Category Maximum for:"]
[null,null,null,0.7,"Major"]
[null,null,null,0.35,"Minor"]
[null,null,null,"See Introduction Section for detailed documentation of assumptions"]
[]
[null,null,"Cross Category Maximum"]
[]
[]
[]
[]
[null,null,null,null,"X% = ","Neighborhood / Site Enhancements Maximum for:"]
[null,null,null,null,0.05,"without NEV"]
[]
[null,null,null,"Neighborhood / Site Enhancements Strategies"]
[]
[]
[]
[null,null,null,null,"X% ="]
[null,null,null,null,0.1,"Transit System Improvements Maximum"]
[]
[null,null,null,"Transit System Improvements Strategies"]
[]
[]
[null,null,null,null,"X% ="]
[null,null,null,null,0.15,"Total Category Maximum"]
[null,null,null,null,0.4,"Work Trip Category Maximum"]
[]
[null,null,null,null,{"$f":"0.218","v":0.218},"percentage of trips which are work trips1"]
[null,null,null,null,null,"1. CAPCOA data updated.  MTC (instead of statewide #s) used. "]
[null,null,null,null,null,"Trip Type","Weekday %"]
[null,null,null,null,null,"HBW",0.218]
[null,null,null,null,null,"HBShop",0.25600000000000001]
[null,null,null,null,null,"HBSocial",0.17299999999999999]
[null,null,null,null,null,"HBS",0.121]
[null,null,null,null,null,"NHB",0.23200000000000001]
[null,null,null,null,null,"Total",{"$f":"SUM(G107:G111)","v":1}]
[null,null,null,null,null,"Source: SF Bay Area Travel Survey 2000, Regional Travel Characteristics Report, Table 2.1.2"]
[]
[null,null,null,"Commute Trip Reduction (CTR) Programs Strategies"]
[]
[]
[null,null,"Category Maximums"]
[]
[null,"Maximum Calculations"]

{"sheet":"Info_Notes","index":11,"n_rows":23,"n_cols":6,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,5,3,5],[4,5,8,5],[9,5,22,5]]}
["Index","Description","Input Instructions","Sources/Notes","Percent Applicable"]
["On-Site Services ","Providing creative onsite amenities reduces the need for SOV trips throughout the day. Services within the development that will reduce the need for auto trips include healthy vending, grocery, restaurant, recreation rental, dry cleaning, child care, bicycle repair stations, etc. ",null,"Seggerman, K., & Hendricks, S. (2005). Incorporating TDM Into the Land Development Process. National Center for Transit Research, Center for Urban Transportation Research.",null,"Neighborhood"]
["Shared Shuttle Service","The use of hotel or other customer service vehicles to shuttle employees can maximize the use of on-site resources while reducing SOV trips. The successful project will creatively consider the use of necessary business vehicles for shuttle purposes. For example, a health club with a guest shuttle could provide employee transfers to a transit center or park and ride.","Degree of implementation: low (< 10 vans), medium (<30 vans), large (>30 vans)                                            Company size: small (< 100 employees), medium (< 500), large (>500) "]
["Non-Motorized Zones","Larger areas of non-motorized travel zones provide safe and comfortable space that encourages walking and bicycling, thus reducing SOV trips. Non-motorized zones are applicable for larger redevelopment or specific areas only. Public amenity space already required by the City of Aspen does not qualify for this reduction. ","Only applicable to Major developments","Federal Highway Administration. (1998). Transportation and Global Climate Change: A Review and Analysis of the Literature. USDOT."]
["Network Expansion","The successful project will expand the local transit network by adding or modifying existing transit service to enhance the service near the project site. This will encourage the use of transit and therefore reduce SOV trips. ","Only applicable to Major developments",null,null,"Transit System"]
["Service Frequency","Reducing transit-passenger travel time through reduced headways and increased speed and reliability makes transit service more attractive, reducing SOV trips. The successful project will work with City of Aspen staff to develop a plan for increased service frequency that offers the best trip reduction opportunity. ","Only applicable to Major developments"]
["Transit Access Improvement","Provision of safe and comfortable access to transit service is important for generating and maintaining transit ridership, thus reducing SOV trips. The successful project will improve pedestrian access to a transit stop via formalization of trails, addition and/or improvement of sidewalk, installation of lighting and/or way finding or other measures. "]
["Intercept Lot","The provision of a convenient location at which to park a vehicle and transfer onto an alternative mode can reduce SOV trips. The successful project will provide for a safe, convenient intercept lot at an appropriate location. Alternatively, a project can propose methods by which existing intercept lot use can be expanded. Examples include shuttles to/from existing lots, improvements to existing lots, etc. ",null,"Federal Highway Administration. (1998). Transportation and Global Climate Change: A Review and Analysis of the Literature. USDOT."]
["Bus Stops with Real Time Arrival","The successful project will provide real time arrival signage to accurately inform users of the bus schedule. ",null,"Study of Chicago Transit Authority implementation of real-time tracking  on 141 of 144 system buses over a one-year periord from 2008 - 2009 found a 1.8 - 2.2% increase in ridership.Tang, L., & Thakuriah, P. (2012, June). Ridership effects of real-time bus information system: A case study in the City of Chicago. Transportation Research Part C: Emerging Technologies, 22, 146-161."]
["Participation in TOP","The Transportation Options Program (TOP) is a City of Aspen operated employer trip reduction service. All TOP employer services are free and include grant opportunities, emergency ride home services, materials, and bus schedule kiosks and distribution. The successful project will work with City of Aspen staff to determine whether TOP membership is appropriate and, if so, to join the program. ",null,null,null,"Commute Trip Reduction"]
["Transit Fare Subsidy","The successful project will provide subsidized/discounted daily or monthly public transit passes for the RFTA valley system. These passes can be partially or wholly subsidized by the project, with additional points being provided for larger subsidies. Many entities use revenue from parking to offset the cost of such a project."]
["Employee Parking Cash-out ","The successful project will require employers to offer employee/guest parking cash-outs. The term cashout is used to describe the provision of a choice of forgoing their current subsidized/free parking for a cash payment equivalent to the cost of the parking space."]
["Workplace Parking Policy ","The successful project will implement workplace parking pricing at its employment centers. This may include: explicitly charging for employee parking, or implementing above market-rate pricing. "]
["Compressed Work Weeks ","Compressed work week schedules allow an employee to work the typical 40-hour workweek in an alternative manner such as 4/10s or 9/80s. This eliminates the need for work-related travel on the days not worked, thus reducing SOV trips. The successful project will demonstrate that it will offer compressed work week schedules to 25% of its employees. "]
["Employer Sponsored Vanpool","The successful project will implement an employer-sponsored vanpool, thus reducing the need for SOV trips to and from the workplace. Employer-sponsored vanpool programs entail an employer purchasing or leasing vans for employee use, and often subsidizing the cost of at least program administration. The driver usually receives personal use of the van, often for a mileage fee. Scheduling is within the employer’s purview, and rider charges are normally set on the basis of vehicle and operating cost. ","Employer size: small (< 100 employees), medium (< 500), large (>500) "]
["Carpool Matching ","Facilitating the formation of employee carpool groups is a method of reducing SOV trips. The successful project will include use the city of Aspen Commuter Connect service to allow for the formation of carpools as well as the sharing of other important transportation information via a custom employer web page. "]
["Carshare Program","Carshare programs have been linked to increased use of alternative transportation modes and reduced SOV trips. The successful project will provide access to Aspen’s CAR TO GO carshare program. Trip reduction potential will depend on the level to which the development participates.  Car share memberships can be provided to all employees or residents of new developments. "]
["Bikeshare Program","Bikesharing provides access to a fleet of bicycles for short trips, thus reducing SOV travel. The successful project will provide memberships to the existing WE-cycle program. ",null,null,1.01]
["End of Trip Facilities ","The provision of convenient facilities for pedestrians and cyclists encourage these types of alternative modes, thus reducing SOV trips. Non-residential projects may provide facilities such as showers, secure bicycle lockers, personal lockers, changing spaces, etc","Level of Implemnation: low = secure bicycle lockers or personal lockers; high = shower and changing area, AND secure bicycle lockers or personal lockers.                      Employer size: small (< 100 employees), medium (< 500), large (>500) ","Victoria Transport Policy Institute. (2013, March 12). TDM Encyclopedia. Retrieved October 24, 2013, from Commute Trip Reduction (CTR): http://www.vtpi.org/tdm/tdm9.htm"]
["Emergency Ride Home ","Emergency Ride Home programs reduce barriers associated with alternative commute modes, thus reducing SOV trips. The successful project will provide commuters who carpool, vanpool, bike, walk or take transit to work with a reliable and free ride home - usually in a taxi or rental car when unexpected emergencies arise."]
["Carpool/Vanpool Priority Parking","Priority parking for carpools and vanpools encourages and incentivizes employees to ride-share to work, thus reducing SOV trips. The carpool and vanpool spaces are located at the front entrances of the buildings. Use of parking spaces is monitored to ensure compliance. ","Employer size: small (< 100 employees), medium (< 500), large (>500) "]
["Trip Reduction Marketing Program","The project will implement marketing strategies to reduce commute trips. Information sharing and marketing are important components to successful commute trip reduction strategies. Implementing commute trip reduction strategies without a complementary educational and marketing strategy will result in lower VMT reductions. A trip reduction marketing program may include the following strategies: orientation of trip reduction and alternative mode options, educational opportunities such as bicycle commute or repair classes, event promotions, and publications."]
["Private Employer Shuttle","Offering employees a customized trip to work via private shuttle reduces the need for SOV trips. The successful project will provide an employee shuttle from nearby transit stations or other identified pick up points to the place of employment. ","Employer size: small (< 100 employees), medium (< 500), large (>500) "]

{"sheet":"Glossary","index":12,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Glossary"]
[]
[null,"Transportation Impact Analysis (TIA)","Transportation Demand Management (TDM) is the application of strategies and policies to reduce travel demand (specifically that of single-occupancy vehicles) "]
[null,"Multi-Modal Level of Service (MMLOS)","Multi-Modal Level of Service (MMLOS) evaluates the safety and quality of access and flow for pedestrians and bicyclists. "]
[null,"Transportation Demand Management (TDM)","Transportation Demand Management (TDM) is the application of strategies and policies to reduce travel demand (specifically that of single-occupancy vehicles)"]
[]
[]
[null,"Access Point","An access point is any location on the site where pedestrians, bicycles, or vehicles access the property. "]
[null,"Detached Sidewalk","A detached sidewalk has a buffer area between the sidewalk and street. "]
[null,"Directness Factor","Pedestrian Route Directness (PRD) is the ratio of route distance to straight-line distance for two selected points. The lowest possible value is 1.00, where the route is the same distance as the \"crow flies\" distance. Numbers closer to 1.00 indicate a more direct route, theoretically representing a more connected network. Providing a pedestrian access network to link areas of the Project site encourages people to walk instead of drive, thus reducing Single Occupancy Vehicles (SOV) trips. "]
[null,"Effective Width","The effective sidewalk width is the width of the sidewalk which is entirely unobstructed. The effective width decreases if doors open into the sidewalk, or if objects such as bollards limit the area pedestrians will walk. Effective sidewalk width is also shortened by a 6\" shy zone next to buildings. Pedestrians typically do not walk within 6\" of a building thus this area is subtracted to determine the effective width. "]
[null,"Landscape Buffer","A landscape buffer is the planting strip located between a sidewalk and street. "]
[null,"Offsite","Offsite refers to any area which is not within the proposed project site. "]