{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Pg1","Pg2","Pg3","Budget1","BudgetSummary","SignaturePage","dropdowns","Extract_Fields"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":1,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Pg1","index":0,"n_rows":59,"n_cols":17,"rows_kept":59,"cut":false,"hidden":false,"merged":[[58,3,59,20],[61,3,62,20],[17,8,17,12],[21,16,21,20],[25,16,25,20],[19,16,19,20],[23,16,23,20],[23,8,23,11],[17,16,17,20],[52,3,54,20],[48,3,48,18],[2,9,2,20],[2,2,4,8],[36,3,41,20],[25,8,25,11],[33,8,33,20],[9,3,9,13],[9,16,9,18],[21,8,21,11],[27,16,27,20],[19,8,19,11],[27,8,27,12],[29,13,29,20]]}
[]
[]
[null,null,"NON-INFRASTRUCTURE\nDetailed Application",null,null,null,null,null,null,"Find more program information in TxDOT's 2025 TA Call for Projects Program Guide"]
[]
[]
[]
[null,null,"APPLICANT INFORMATION"]
[]
[null,null,"1. Project Sponsor Name (Only one entity can act as project sponsor)",null,null,null,null,null,null,null,null,null,null,null,null,"2.","Jurisdiction Population"]
[]
[]
[null,null,"3. Type of Organization/Agency/Authority (Select from dropdown below)"]
[]
[]
[]
[null,null,"4. Project Sponsor Contact Information (Authorized representative)"]
[]
[null,null,null,"Contact Person:",null,null,null,null,null,null,null,null,null,null,null,"Title:"]
[]
[null,null,null,"Mailing Address:",null,null,null,null,null,null,null,null,null,null,null,"Physical Address:"]
[]
[null,null,null,"Mailing City:",null,null,null,null,null,null,null,null,null,null,null,"Physical City:"]
[]
[null,null,null,"Zip Code:",null,null,null,null,null,null,null,null,null,null,null,"Zip Code:"]
[]
[null,null,null,"Contact's Phone:",null,null,null,null,null,null,null,null,null,null,null,"Entity's Main Phone:"]
[]
[null,null,null,"Email:",null,null,null,null,null,null,null,null,null,null,null,"Website:"]
[]
[null,null,null,"Other partnering governments/ project sponsors"]
[]
[null,null,"PROJECT DESCRIPTION"]
[]
[null,null,"5. Project Name"]
[]
[null,null,"6. Project Description (See Detailed Application Instructions. Description must fit in the space provided.)"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"7. Project Location Information"]
[]
[null,null,null,"TxDOT District:",null,null,null,null,null,null,null,"Texas County:"]
[]
[null,null,"8. Metropolitan Planning Organization (MPO)"]
[null,null,null,"a. Is the project located within Metropolitan Planning Organization (MPO) boundaries?"]
[]
[null,null,null,"b. If yes, please specify which MPO."]
[]
[null,null,null,"c. If this project is located within the boundaries of an MPO, include a letter from the MPO to the project sponsor indicating their willingness to include the project in the local TIP either as a grouped or individually listed project, if funded. Label attachment A- MPO TIP Letter."]
[]
[]
[null,null,"9. Transportation Alternatives (TA), Safe Routes to School (SRTS) and ADA Transition Plans"]
[null,null,null,"a. Is this project part of a Safe Routes to School plan or Program?"]
[]
[null,null,null,"b. Has the project or a substantially similar project been submitted under a prior TxDOT TA \nCall for Projects? Please select the latest program call submission."]

{"sheet":"Pg2","index":1,"n_rows":53,"n_cols":13,"rows_kept":53,"cut":false,"hidden":false,"merged":[[52,4,54,15],[26,4,29,16],[5,4,5,16],[7,4,10,16],[33,4,36,17],[39,4,40,16],[48,4,50,16],[44,4,45,16],[42,4,43,15]]}
[]
[]
[null,null,"PROJECT DETAILS"]
[null,null,"10. Detailed Project Location"]
[null,null,null,null,"Provide a Google map link: see Detailed Application Instructions for guidance."]
[]
[]
[null,null,null,null,"Most detailed applications for the non-infrastructure project category will be proposing city-wide planning documents. For these projects, the project limits will coincide with city boundaries. If the project limits do not coincide with city boundaries, please provide a shared google map link representing the project limits."]
[]
[]
[]
[]
[]
[null,null,"11. Active Transportation Plan Type:"]
[]
[null,null,"12. What area does the proposed plan cover?"]
[]
[null,null,"13. Existing Active Transportation Plans"]
[]
[null,null,null,null,"a. Does your community have any existing Active Transportation Plans?"]
[]
[null,null,null,null,"b. If yes, which modes are included in the plans?"]
[]
[null,null,null,null,null,null,"Micro-mobility",null,"Pedestrian","Bicycle","Transit",null,"ADA Transition Plan"]
[]
[]
[null,null,null,null,"Project sponsors must develop a proposed scope of work for the planning document. This will be reviewed as part of project evaluation and if awarded may be included in a funding agreement.  A template with typical planning project elements is included in the Detailed Application Instructions for your reference.  Label this attachment B- Proposed Scope of Work (required)."]
[]
[]
[]
[]
[null,null,"GEOGRAPHIC BALANCE"]
[]
[null,null,null,null,"TxDOT is interested in how the project improves access to everyday destinations for underserved communities. TxDOT will analyze census data to determine if the project will improve access for seniors, individuals with disabilities, people without private vehicles, or low-income communities. "]
[]
[]
[]
[null,null,"COMMUNITY SUPPORT AND PLANNING"]
[null,null,"14. Project Sponsor Resolution"]
[null,null,null,null,"An adopted resolution from the project sponsor’s governing board is a required attachment to the detailed application. This attachment should be labeled C-Project Sponsor Resolution (required)."]
[]
[null,null,"15. Public Involvement and Support"]
[null,null,null,"a.","List all collaborating partners and their role in developing/implementing the proposed project. Separate each partner in the list with semi-colons. If necessary, attach details as D- Public Outreach and Support."]
[]
[]
[]
[]
[null,null,null,"b.","Letters of Support"]
[null,null,null,null,"Attach letters of support from stakeholders including elected officials, community leaders, bicycle/pedestrian interest groups, school officials, PTA, adjacent property owners, etc. Label attachments as D- Public Outreach and Support."]
[]
[]
[]
[null,null,null,null,"As part of the overall application evaluation, TxDOT will review the Project Sponsor's Proposed Scope of Work and evaluate the proposed scope elements related to public involvement as part of each applicant's Community Support and Planning evaluation score. "]

{"sheet":"Pg3","index":2,"n_rows":54,"n_cols":20,"rows_kept":54,"cut":false,"hidden":false,"merged":[[19,4,22,20],[11,4,14,21],[15,4,15,5],[17,8,17,16],[17,6,17,7],[17,4,17,5],[3,4,7,21],[27,4,30,21],[47,4,47,6],[47,7,47,18],[52,4,52,6],[44,7,45,12],[48,7,49,20],[44,13,45,20],[40,4,40,6],[40,7,40,19],[44,4,44,6],[41,7,42,20],[32,4,32,18],[35,4,35,6],[35,7,35,18],[36,7,38,20]]}
[]
[]
[null,null,"SAFETY"]
[null,null,null,null,"TxDOT is most interested in funding non-infrastructure projects where non-motorized crashes occur. Therefore, TxDOT staff will analyze the total non-motorized crashes and the non-motorized crash rates within the proposed planning area. Additionally, TxDOT will review each Project Sponsor's Proposed Scope of Work for the Planning Document project and provide a professional judgement score on the proposed safety elements therein."]
[]
[]
[]
[]
[null,null,"CONNECTIVITY AND ACCESSIBILITY"]
[]
[null,null,"16. Barrier Elimination"]
[null,null,null,null,"Will the proposed planning document consider eliminating travel barriers for individuals with disabilities, pedestrians, bicyclists, and other non-drivers? For ADA barriers, only count each type of ADA barrier that is being eliminated. For example, if your proposed planning document will be looking at city-wide gaps in ADA access, that would count as one barrier, and accessible pedestrian signals would count as another."]
[]
[]
[]
[null,null,null,null,null,null,"ADA barriers",null,null,null,"Four lane or larger roadways",null,null,null,null,"Waterbody(ies)",null,null,null,"Railroad"]
[]
[null,null,null,null,null,null,"Other"]
[]
[null,null,null,null,"TxDOT is interested in funding non-infrastructure projects that contribute to increased connectivity and accessibility. Therefore, TxDOT will review Project Sponsor's Proposed Scope of Work for the Planning Document project and provide a professional judgement score on the proposed connectivity and accessibility elements therein."]
[]
[]
[]
[]
[null,null,"PROJECT TIMELINE"]
[]
[null,null,"17. Project Timeline"]
[null,null,null,null,"Estimate the number of months it will take to complete this project (from project initiation through planning document adoption). Estimate the time required for each activity listed below. Several activities should be accomplished concurrently; as a result, the Total Project Time Estimate will be less than the total of the time estimated for each activity. Refer to the 2025 TA Program Guide for additional guidance."]
[]
[]
[]
[]
[null,null,null,null,"Label attachment(s) as E- Project Timeline (required) - No more than 2 pages."]
[]
[null,null,null,null,"Months",null,null,"Activities"]
[null,null,null,null,null,null,null,"Project Initiation (before October 2026, 6 months minimum)"]
[null,null,null,null,null,null,null,"(Includes the project in the STIP, execute Advance Funding Agreement (AFA) with the department, complete required local government training, assign local government and department roles and responsibilities, etc. Project Initiation activities cannot be concurrent with reimbursable activities.)"]
[]
[]
[]
[null,null,null,null,null,null,null,"Procurement of consultant (minimum 3 months)"]
[null,null,null,null,null,null,null,"(Solicit, select, negotiate, and execute contract(s) for consultant services according to federal procurement rules. See TA Program Guide for details)"]
[]
[]
[null,null,null,null,null,null,null,"Other- Describe briefly additional milestones not addressed elsewhere."]
[]
[]
[null,null,null,null,null,null,null,"Plan Development and adoption (6 to 24 months)"]
[null,null,null,null,null,null,null,"(Develop the plan items, assign responsibilities for each task, complete tasks, finalize and adopt plan)"]
[]
[]
[]
[null,null,null,null,null,null,null,"Total Project Development Time Estimate (maximum 36 months from award)"]
[null,null,null,null,null,null,null,"All projects must be obligated by October 2028"]

{"sheet":"Budget1","index":3,"n_rows":59,"n_cols":27,"rows_kept":59,"cut":false,"hidden":false,"merged":[[53,14,53,15],[53,16,53,18],[48,14,48,15],[47,3,47,11],[44,3,44,11],[45,3,45,11],[46,3,46,11],[43,3,43,11],[43,14,43,15],[53,3,53,11],[50,3,50,11],[50,14,50,15],[47,16,47,18],[48,16,48,18],[50,16,50,18],[51,3,51,11],[51,14,51,15],[51,16,51,18],[52,3,52,11],[52,14,52,15],[52,16,52,18],[49,3,49,11],[49,14,49,15],[49,16,49,18],[58,16,58,18],[27,3,27,11],[28,3,28,11],[29,3,29,11],[30,3,30,11],[31,3,31,11],[32,3,32,11],[33,3,33,11],[34,3,34,11],[35,3,35,11],[36,3,36,11],[37,3,37,11],[38,3,38,11],[39,3,39,11],[38,16,38,18],[40,16,40,18],[33,14,33,15],[40,3,40,11],[41,3,41,11],[42,3,42,11],[41,14,41,15],[42,14,42,15],[44,14,44,15],[45,14,45,15],[40,14,40,15],[27,16,27,18],[28,16,28,18],[48,3,48,11],[47,14,47,15],[42,16,42,18],[43,16,43,18],[44,16,44,18],[45,16,45,18],[46,16,46,18],[46,14,46,15],[41,16,41,18],[37,14,37,15],[57,3,57,11],[57,14,57,15],[57,16,57,18],[56,3,56,11],[56,14,56,15],[54,3,54,11],[54,14,54,15],[54,16,54,18],[56,16,56,18],[55,3,55,11],[55,14,55,15],[55,16,55,18],[25,16,25,18],[26,3,26,11],[32,16,32,18],[33,16,33,18],[34,16,34,18],[35,16,35,18],[36,16,36,18],[37,16,37,18],[29,16,29,18],[30,16,30,18],[31,16,31,18],[35,14,35,15],[34,14,34,15],[27,14,27,15],[28,14,28,15],[5,3,5,17],[21,3,21,17],[17,7,17,12],[38,14,38,15],[39,14,39,15],[26,14,26,15],[26,16,26,18],[22,16,22,18],[22,14,22,15],[22,3,22,11],[23,3,23,11],[23,14,23,15],[29,14,29,15],[30,14,30,15],[31,14,31,15],[32,14,32,15],[24,14,24,15],[24,16,24,18],[25,3,25,11],[25,14,25,15],[39,16,39,18],[23,16,23,18],[24,3,24,11],[36,14,36,15]]}
[]
[]
[]
[{"$f":"Budget1!Q59","v":0},null,"ITEMIZED BUDGET"]
[null,null,"18. Plan Elements"]
[null,null,null,"With as much detail as necessary, provide a plan development cost estimate."]
[]
[null,null,null,null,null,"exisiting plan/policy review",null,null,null,null,null,null,null,"needs assessment"]
[]
[null,null,null,null,null,"existing conditions assessment",null,null,null,null,null,null,null,"data collection"]
[]
[null,null,null,null,null,"infrastructure recommendations and user typologies",null,null,null,null,null,null,null,"project prioritization and/or recommendations"]
[]
[null,null,null,null,null,"visioning and goal/objective/priority setting",null,null,null,null,null,null,null,"policy recommendations"]
[]
[null,null,null,null,null,"public and stakeholder involvement",null,null,null,null,null,null,null,"implementation strategy"]
[]
[null,null,null,null,null,"other:"]
[]
[]
[null,null,"19. Plan Development Cost Estimates"]
[null,null,null,"With as much detail as necessary, provide a plan development cost estimate."]
[null,null,null,"Planning Activities",null,null,null,null,null,null,null,null,"Quantity","Unit","Unit Price",null,"Amount",null,null,null,null,null,null,null,null,"Units"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M24*O24","v":0},null,null,null,null,null,null,null,null,"AC","Acre"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,"CF","Cubic feet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,"Sq Feet","SF","CY","Cubic yards"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,"Sq Yards","SY","CYC","Cycle"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,"Linear Feet","LF","DAY","Day"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,"Lump Sum","LS","EA","Each"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M30*O30","v":0},null,null,null,null,null,null,null,null,"LF","Linear foot"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,"LMI","Lane mile"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,"LS","Lump sum"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,"MBF","Thousand board feet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,"MG","Thousand Gallons"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,"MI","Mile"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,"MO","Month"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,"SF","Square feet"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,"STA","Station"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,"SY","Square yard"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,"TON","Ton"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,"$/D","Dollars per day"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M58*O58","v":0}]
[null,null,null,"(Continued on next page)",null,null,null,null,null,null,null,null,null,null,null,"Subtotal:",{"$f":"SUM(Q24:S58)","v":0}]

{"sheet":"BudgetSummary","index":4,"n_rows":116,"n_cols":33,"rows_kept":116,"cut":false,"hidden":false,"merged":[[5,2,5,18],[7,4,7,15],[7,17,7,18],[13,17,13,18],[39,5,39,12],[39,14,39,15],[35,5,37,14],[15,17,15,18],[22,4,25,17],[18,4,19,17],[9,4,9,15],[9,17,9,18],[11,4,11,15],[11,17,11,18],[28,4,30,17],[43,8,43,18],[45,12,45,14],[46,12,46,14],[45,15,45,18],[46,15,46,18],[47,15,47,18],[48,15,48,18],[44,12,44,14],[44,15,44,18],[47,4,47,7],[48,4,48,7],[47,9,47,11],[48,9,48,11],[47,12,47,14],[48,12,48,14],[44,9,44,11],[45,9,45,11],[46,9,46,11],[45,4,45,7],[46,4,46,7]]}
[]
[]
[]
[null,null,null,"BUDGET SUMMARY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Formulas"]
[]
[null,null,"20. Project Budget Summary (many lines automatically populate, numbers are rounded up to the nearest $1,000)"]
[]
[null,null,null,null,"Total Plan Development Cost Estimate",null,null,null,null,null,null,null,null,null,null,null,"1.",{"$f":"ROUNDUP(Budget1!Q59,-3)","v":0},null,null,null,null,null,"='Pg8'!Q56"]
[]
[null,null,null,null,"TxDOT Direct State Costs for project oversight (15% of line 1)",null,null,null,null,null,null,null,null,null,null,null,"2.",{"$f":"ROUNDUP(BudgetSummary!R8*0.15,-3)","v":0},null,null,null,null,null,"=$R$12*0.15"]
[]
[null,null,null,null,"Total Project Cost Estimate [line 1 + line 2]",null,null,null,null,null,null,null,null,null,null,null,"3.",{"$f":"ROUNDUP(R8+R10,-3)","v":0},null,null,null,null,null,"=R12+R14+R16"]
[]
[null,null,null,null,"Optional Local Match Increase*",null,null,null,null,null,null,null,0.2,"of line 3",null,null,null,{"$f":"IF(dropdowns!T1=TRUE,\"(see table below)\",BudgetSummary!LocalMatch*BudgetSummary!R12)","v":0},null,null,null,null,null,"=IF(OR(dropdowns!W2=TRUE,dropdowns!W3=TRUE),\"(see line 11)\",$M$20*$R$18)"]
[]
[null,null,null,null,"TxDOT Optional Discretionary Funds**",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(dropdowns!T1=TRUE,\"(see table below)\",M16*BudgetSummary!R12)","v":0}]
[]
[]
[null,null,null,null,"TDCs: If a project sponsor is eligible to use TDCs, these credits will be applied to the project in lieu of the local match. See Cost Participation Summary below. "]
[]
[]
[]
[null,null,null,null,"*Local Match: Project sponsors may increase the required Local Match above 20% by adjusting the Local Match percentage in the box above. If the project is eligible for Transportation Development Credits (amount shown in number 4 below), then the federal share will be fixed at 100% federal participation in lieu of local match."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EDCP can be applied to ALL. PE, CST, and ADM."]
[]
[]
[]
[]
[null,null,null,null,"**TxDOT Discretionary Funds: In a minority of cases, TxDOT Districts may participate financially in projects to reduce the local match. \"Optional Local Match Increase\" percentage and \"TxDOT Optional Discretionary Funds\" percentage must total 20%. See Detailed Application Instructions for more information. "]
[]
[]
[]
[]
[null,null,null,null,"Eligibility for Transportation Development Credits "]
[]
[null,null,null,null,null,"Select Project Sponsor from dropdown. If Project Sponsor is not listed, then it was determined to be ineligible for Transportation Development Credits."]
[]
[]
[]
[null,null,null,null,null,"Eligible Transportation Development Credits",null,null,null,null,null,null,null,"4.",{"$f":"IF(dropdowns!T1=TRUE,$R$12*0.2,0)","v":0},null,null,null,null,null,null,null,null,"=IF(dropdowns!W3=TRUE,R18*0.2,0)"]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Participation"]
[null,null,null,null,null,null,null,null,"Percent","Plan Development Cost Estimate\n(plus inflation adjustment)",null,null,"Direct State Costs",null,null,"Total Project Costs"]
[null,null,null,null,"Federal",null,null,null,{"$f":"SignaturePage!N5","v":0.8},{"$f":"$R$8*SignaturePage!$N$5","v":0},null,null,{"$f":"$R$10*SignaturePage!$N$5","v":0},null,null,{"$f":"SignaturePage!P5","v":0}]
[null,null,null,null,"State",null,null,null,{"$f":"SignaturePage!$N$7","v":0},{"$f":"IF(SignaturePage!N7=\"-\",0,$R$8*SignaturePage!$N$7)","v":0},null,null,{"$f":"IF(SignaturePage!N7=\"-\",0,$R$10*SignaturePage!$N$7)","v":0},null,null,{"$f":"IF(SignaturePage!$P$7=\"-\",0,SignaturePage!$P$7)","v":0}]
[null,null,null,null,"Local",null,null,null,{"$f":"SignaturePage!$N$9","v":0.2},{"$f":"$R$8*SignaturePage!$N$9","v":0},null,null,{"$f":"$R$10*SignaturePage!$N$9","v":0},null,null,{"$f":"SignaturePage!P9","v":0}]
[null,null,null,null,"Total",null,null,null,{"$f":"I46+I47+I48","v":1},{"$f":"J46+J47+J48","v":0},null,null,{"$f":"M46+M47+M48","v":0},null,null,{"$f":"P46+P47+P48","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fed amount"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TDC","EDCP","If elected"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"100%","v":1},"=(.8*proj cost)","x * (Proj cost)"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Local amount options"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No TDC","No TDC","No TDC","Yes TDC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No EDCP","No EDCP","YES EDCP","No EDCP"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No optional increase","Optional increase","No optional increase","No optional increase"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=local match","=local match(opt inc)","=(1-fed %-EDCP%)*Proj Cost","=0"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$R$14","v":0},{"$f":"$R$14","v":0},{"$f":"IF(dropdowns!#REF!=TRUE,(1-SignaturePage!$N$5-SignaturePage!$N$7)*$R$12,\"other option\")","v":{"$error":"#REF!"}},{"$f":"0","v":0}]

{"sheet":"SignaturePage","index":5,"n_rows":41,"n_cols":28,"rows_kept":41,"cut":false,"hidden":false,"merged":[[13,3,13,17],[21,3,21,17],[40,2,40,17],[17,3,17,17],[15,3,15,17],[23,3,23,17],[24,3,25,17],[26,3,26,16],[27,3,27,16],[29,3,29,17],[19,3,19,17],[6,15,6,16],[4,13,4,14],[6,13,6,14],[8,13,8,14],[4,15,4,16],[8,15,8,16]]}
[]
[]
[null,null,"COST PARTICIPATION SUMMARY"]
[]
[null,null,null,"Total Federal Participation ",null,null,null,null,null,null,null,null,null,{"$f":"IF(dropdowns!T1=TRUE,1,1-(BudgetSummary!M14+BudgetSummary!M16))","v":0.8},null,{"$f":"$N$5*BudgetSummary!$R$12","v":0},null,null,null,null,null,"=IF(dropdowns!$W$3=TRUE,$R$18,if(dropdowns!$W$2=TRUE,$R$18*0.8,$R$18*M20))",null,null,null,null,null,"=IF(OR(dropdowns!$W$2=TRUE,$O$47>0),0.8,1-$M$20)"]
[]
[null,null,null,"Total State Participation",null,null,null,null,null,null,null,null,null,{"$f":"IF(dropdowns!T1=TRUE,0,BudgetSummary!$M$16)","v":0},null,{"$f":"$N$7*BudgetSummary!$R$12","v":0},null,null,null,null,null,"=IF(dropdowns!W2=TRUE,'Pg10'!O49,\"--\")"]
[]
[null,null,null,"Total Local Participation",null,null,null,null,null,null,null,null,null,{"$f":"IF(dropdowns!T1=TRUE,0,BudgetSummary!$M$14)","v":0.2},null,{"$f":"$N$9*BudgetSummary!$R$12","v":0},null,null,null,null,null,"=IF(dropdowns!W3=TRUE,0,IF(dropdowns!W2=TRUE,(1-$P$53-$P$55)*$R$18,$R$22))"]
[6]
[null,null,"PROJECT COMMITMENT"]
[]
[null,null,"The applicant confirms understanding of the following requirements by checking boxes and signing below."]
[null,null,null,"This is a reimbursement program. If the project sponsor implements any stage of the project, then they must finance that phase until reimbursement funds are available. Invoices must be submitted with proper documentation on a regular basis (typically monthly, but no less than quarterly). "]
[]
[null,null,null,"If TxDOT implements any phase of the project on behalf of the project sponsor, then any local match would be due in full to TxDOT prior to commencement of each phase (i.e. plan development). Project selection does not guarantee that TxDOT will implement a project on behalf of any recipient."]
[]
[null,null,null,"Until authorized by TxDOT with a notice to proceed, the project sponsor should not enter into a contract or incur costs for any aspect of the project for which the project sponsor is seeking federal participation. Otherwise, the project sponsor risks incurring costs that will not be reimbursed."]
[]
[null,null,null,"Project sponsors may manage elements of the project development process with written TxDOT approval. To receive approval, the project sponsor acknowledges that they must complete a Special Project Approval form in accordance with 43 TAC §15.52 and undergo a Risk Assessment."]
[]
[null,null,null,"The project sponsor understands they are responsible for providing a local match (cash) to cover 20% of the total project cost (including TxDOT Direct State Costs) unless eligible for Transportation Development Credits (TDCs). For project sponsors eligible for TDCs, these credits will be applied as additional federal funds in lieu of local match. Depending on approved local match option, TxDOT will reimburse a portion or all of the total expenses on each invoice submitted with proper documentation of expenses."]
[]
[null,null,null,"The project sponsor must be prepared to fund any project costs in excess of the amounts indicated in the budget entered into this detailed application and/or the amount awarded by the commission (i.e., project cost overruns)."]
[null,null,null,"Once the planning document is completed, the project sponsor agrees to add the completed active transportation planning related document to the Texas Active Transportation Plan Inventory (ATPI):\n"]
[]
[null,null,null,"ATPI- https://maps.txdot.gov/ActiveTransportationPlanInventory/"]
[null,null,null,"Plan submission portal- https://maps.txdot.gov/ActiveTransportationPlanSubmissionPortal/"]
[]
[null,null,null,"TxDOT envisions the funding of active transportation planning documents will lead to a pipeline of infrastructure projects in future TxDOT Transportation Alternatives Program Calls. Once the planning document is completed and adopted, the project sponsor agrees to make every effort to submit active transportation network infrastructure improvement projects into future TxDOT Transportation Alternatives Program Calls."]
[]
[]
[]
[null,null,null,null,"Signature"]
[]
[null,null,null,null,"Print Name and Title"]
[]
[null,null,null,null,"Date",null,null,null,null,null,null,"Telephone Number"]
[]
[]
[null,null,"Refer to TxDOT's 2025 TA Detailed Application Instructions for submittal instructions."]

{"sheet":"dropdowns","index":6,"n_rows":260,"n_cols":26,"rows_kept":260,"cut":false,"hidden":true,"merged":[[9,23,9,25],[32,1,32,2],[72,1,72,2],[16,1,16,2],[151,1,151,2],[159,1,159,2],[143,1,143,2],[133,1,133,2],[3,19,3,20],[14,19,14,20],[25,19,25,20],[24,1,24,2],[1,11,1,12],[115,1,115,2],[81,1,81,2],[64,1,64,2],[54,1,54,2],[1,1,1,2],[1,5,1,6],[1,8,1,9],[106,1,106,2],[221,1,221,2],[229,1,229,2],[167,1,167,2],[175,1,175,2],[213,1,213,2],[184,1,184,2],[195,1,195,2],[204,1,204,2]]}
["Question",null,null,null,"Question",null,null,"Question",null,null,"Question",null,null,null,null,"Budget Summary",null,null,"TDC",{"$f":"IF(Q117=1,FALSE,TRUE)","v":false},{"$f":"IF(T1=TRUE,\"TDCs are eligible for local match\",\"INELIGIBLE for TDCs\")","v":"INELIGIBLE for TDCs"}]
["#3","PROJECT SPONSOR OPTIONS",null,null,"#7b","COUNTIES",null,"#7a","TxDOT DISTRICTS",null,"#8b","MPOs",null,null,null,"PSs determined eligible for TDCs"]
[null,null,"Categories",null,null,null,"County Name",null,null,"District Name",null,null,"MPO Name",null,null,null,"Options"]
[null,1,"(select)",null,null,1,"(select)",null,1,"(select)",null,1,"(select)",null,null,1,"(select)",null,null,"Project Budget Contingency estimate"]
[null,2,"Local Government",null,null,2,"Anderson",null,2,"Abilene",null,2,"Abilene MPO",null,null,2,"Brewster County",null,null,null,"Options"]
[null,3,"Regional Transportation Authority",null,null,3,"Andrews",null,3,"Amarillo",null,3,"Alama Area MPO",null,null,3,"Cameron County DOT",null,null,1,"(select)"]
[null,4,"Transit Agency",null,null,4,"Angelina",null,4,"Atlanta",null,4,"Amarillo MPO",null,null,4,"City of Alamo",null,null,2,0]
[null,5,"Natural Resource or Public Land Agency",null,null,5,"Aransas",null,5,"Austin",null,5,"Bryan-College Station MPO",null,null,5,"City of Alice",null,null,3,0.05]
[null,6,"School District, Local Education Agency, or School",null,null,6,"Archer",null,6,"Beaumont",null,6,"Capital Area MPO",null,null,6,"City of Aransas Pass",null,null,4,0.1]
[null,7,"Tribal Government",null,null,7,"Armstrong",null,7,"Brownwood",null,7,"Corpus Christi MPO",null,null,7,"City of Atlanta",null,null,5,0.15,null,null,"Color Palette"]
[null,8,"Any other governmental entity with responsibility for transportation",null,null,8,"Atascosa",null,8,"Bryan",null,8,"El Paso MPO",null,null,8,"City of Balch Springs",null,null,null,3,null,null,"Header","R",0]
[null,9,"Non-profit organization",null,null,9,"Austin",null,9,"Childress",null,9,"Grayson County MPO",null,null,9,"City of Bay CIty",null,null,null,{"$f":"LOOKUP(U11,T6:T10,U6:U10)","v":0.05},null,null,"Blue","G",86]
[null,10,"Metropolitan Planning Organization (MPO)",null,null,10,"Bailey",null,10,"Corpus Christi",null,10,"Houston-Galveston Area Council MPO",null,null,10,"City of Beaumont",null,null,null,null,null,null,null,"B",169]
[null,null,1,null,null,11,"Bandera",null,11,"Dallas",null,11,"Killeen-Temple MPO",null,null,11,"City of Beeville ",null,null,null,null,null,null,"Blanks","R",197]
[null,null,{"$f":"LOOKUP(C14,B4:B13,C4:C13)","v":"(select)"},null,null,12,"Bastrop",null,12,"El Paso",null,12,"Laredo Webb County Area MPO",null,null,12,"City of Borger",null,null,"Project assumed construction year",null,null,null,"Light brown","G",187]
[null,null,null,null,null,13,"Baylor",null,13,"Fort Worth",null,13,"Longview MPO",null,null,13,"City of Brady",null,null,null,"Options",null,null,null,"B",170]
["#8a","MPO - YES or Nos",null,null,null,14,"Bee",null,14,"Houston",null,14,"Lubbock MPO",null,null,14,"City of Breckenridge",null,null,1,"(select)",null,null,"Border #1","R",128]
[null,null,"Option",null,null,15,"Bell",null,15,"Laredo",null,15,"North Central Texas Council of Governments (NCTCOG)",null,null,15,"City of Bremond",null,null,2,"FY 2026",2026,null,"Gray","G",128]
[null,1,"(select)",null,null,16,"Bexar",null,16,"Lubbock",null,16,"Permian Basin MPO",null,null,16,"City of Bridge City",null,null,3,"FY 2027",2027,null,null,"B",128]
[null,2,"Yes",null,null,17,"Blanco",null,17,"Lufkin",null,17,"Rio Grande Valley MPO",null,null,17,"City of Brownsville",null,null,4,"FY 2028",2028,null,"Border #2 & Gen Header","R",187]
[null,3,"No",null,null,18,"Borden",null,18,"Odessa",null,18,"San Angelo MPO",null,null,18,"City of Brownwood",null,null,5,"FY 2029",2029,null,"Gold brown","G",174]
[null,null,1,null,null,19,"Bosque",null,19,"Paris",null,19,"South East Texas RPC MPO",null,null,19,"City of Calvert",null,null,null,5,null,null,null,"B",5]
[null,null,{"$f":"LOOKUP(C22,B19:B21,C19:C21)","v":"(select)"},null,null,20,"Bowie",null,20,"Pharr",null,20,"Texarkana MPO",null,null,20,"City of Castle Hills",null,null,null,{"$f":"LOOKUP(U22,T17:T21,U17:U21)","v":"FY 2029"},null,null,"Background","R",218]
[null,null,null,null,null,21,"Brazoria",null,21,"San Angelo",null,21,"Tyler MPO",null,null,21,"City of Centerville",null,null,null,{"$f":"IF(U23=\"(select)\",0,(RIGHT(U23,4)-2025))","v":4},null,null,null,"G",222]
["#9a","SRTS related?? - YES or Nos",null,null,null,22,"Brazos",null,22,"San Antonio",null,22,"Waco MPO",null,null,22,"City of Cleveland",null,null,null,null,null,null,null,"B",229]
[null,null,"Option",null,null,23,"Brewster",null,23,"Tyler",null,23,"Wichita Falls MPO",null,null,23,"City of Clute",null,null,"Project Committment"]
[null,1,"(select)",null,null,24,"Briscoe",null,24,"Waco",null,24,"Victoria MPO",null,null,24,"City of Coldspring",null,null,false,"Checkbox"]
[null,2,"Yes",null,null,25,"Brooks",null,25,"Wichita Falls",null,null,1,null,null,25,"City of Copperas Cove",null,null,false,1]
[null,3,"No",null,null,26,"Brown",null,26,"Yoakum",null,null,{"$f":"LOOKUP(M28,L2:L27,M2:M27)","v":"(select)"},null,null,26,"City of Crowley",null,null,false,2]
[null,null,1,null,null,27,"Burleson",null,null,1,null,null,null,null,null,27,"City of Cuero",null,null,false,3]
[null,null,{"$f":"LOOKUP(C30,B27:B29,C27:C29)","v":"(select)"},null,null,28,"Burnet",null,null,{"$f":"LOOKUP(J30,I4:I29,J4:J29)","v":"(select)"},null,null,null,null,null,28,"City of Del Rio",null,null,false,4]
[null,null,null,null,null,29,"Caldwell",null,null,null,null,null,null,null,null,29,"City of Denison",null,null,false,5]
["#9b","Previous submittal??",null,null,null,30,"Calhoun",null,null,null,null,null,null,null,null,30,"City of DeSoto",null,null,false,6]
[null,null,"Option",null,null,31,"Callahan",null,null,null,null,null,null,null,null,31,"City of Duncanville",null,null,false,7]
[null,1,"(select)",null,null,32,"Cameron",null,null,null,null,null,null,null,null,32,"City of Eagle Pass",null,null,false,8]
[null,2,"No prior submittal",null,null,33,"Camp",null,null,null,null,null,null,null,null,33,"City of Early"]
[null,3,"2023 TA",null,null,34,"Carson",null,null,null,null,null,null,null,null,34,"City of East Bernard"]
[null,null,1,null,null,35,"Cass",null,null,null,null,null,null,null,null,35,"City of El Campo"]
[null,null,{"$f":"LOOKUP(C38,B35:B37,C35:C37)","v":"(select)"},null,null,36,"Castro",null,null,null,null,null,null,null,null,36,"City of El Paso "]
[null,null,null,null,null,37,"Chambers",null,null,null,null,null,null,null,null,37,"City of Freeport"]
["#11","ATP type",null,null,null,38,"Cherokee",null,null,null,null,null,null,null,null,38,"City of Gladewater"]
[null,null,"Options",null,null,39,"Childress",null,null,null,null,null,null,null,null,39,"City of Granger"]
[null,1,"(select)",null,null,40,"Clay",null,null,null,null,null,null,null,null,40,"City of Hallettsville"]
[null,2,"Safety Action Plan",null,null,41,"Cochran",null,null,null,null,null,null,null,null,41,"City of Harlingen"]
[null,3,"ADA Transition Plan",null,null,42,"Coke",null,null,null,null,null,null,null,null,42,"City of Hemphill"]
[null,4,"Safe Routes to School Plan",null,null,43,"Coleman",null,null,null,null,null,null,null,null,43,"Town of Holland"]
[null,5,"Pedestrian Plan",null,null,44,"Collin",null,null,null,null,null,null,null,null,44,"City of Huntington"]
[null,6,"Bicycle Plan",null,null,45,"Collingsworth",null,null,null,null,null,null,null,null,45,"City of Huntsville"]
[null,7,"Micro-mobility Plan",null,null,46,"Colorado",null,null,null,null,null,null,null,null,46,"City of Jefferson"]
[null,8,"Active Transportation Plan",null,null,47,"Comal",null,null,null,null,null,null,null,null,47,"City of Jourdanton"]
[null,9,"Other",null,null,48,"Comanche",null,null,null,null,null,null,null,null,48,"City of Kaufman"]
[null,null,1,null,null,49,"Concho",null,null,null,null,null,null,null,null,49,"City of Killeen"]
[null,null,{"$f":"LOOKUP(C52,B43:B51,C43:C51)","v":"(select)"},null,null,50,"Cooke",null,null,null,null,null,null,null,null,50,"City of Kingsville"]
[null,null,null,null,null,51,"Coryell",null,null,null,null,null,null,null,null,51,"City of Lancaster"]
["#12","ATP coverage area",null,null,null,52,"Cottle",null,null,null,null,null,null,null,null,52,"City of Laredo"]
[null,null,"Option",null,null,53,"Crane",null,null,null,null,null,null,null,null,53,"City of Leon Valley"]
[null,1,"(select)",null,null,54,"Crockett",null,null,null,null,null,null,null,null,54,"City of Liberty"]
[null,2,"Community Wide",null,null,55,"Crosby",null,null,null,null,null,null,null,null,55,"City of Liberty Hill"]
[null,3,"Small Area Plan",null,null,56,"Culberson",null,null,null,null,null,null,null,null,56,"City of Livingston"]
[null,4,"Corridor Plan",null,null,57,"Dallam",null,null,null,null,null,null,null,null,57,"City of Longview"]
[null,5,"Other",null,null,58,"Dallas",null,null,null,null,null,null,null,null,58,"City of Lufkin"]
[null,null,1,null,null,59,"Dawson",null,null,null,null,null,null,null,null,59,"Town of Mabank"]
[null,null,{"$f":"LOOKUP(C62,B57:B61,C57:C61)","v":"(select)"},null,null,60,"DeWitt",null,null,null,null,null,null,null,null,60,"City of Marlin"]
[null,null,null,null,null,61,"Deaf Smith",null,null,null,null,null,null,null,null,61,"City of Mathis"]
["#13a","Existing ATP?",null,null,null,62,"Delta",null,null,null,null,null,null,null,null,62,"City of Mineola"]
[null,null,"Option",null,null,63,"Denton",null,null,null,null,null,null,null,null,63,"City of Nacogdoches"]
[null,1,"(select)",null,null,64,"Dickens",null,null,null,null,null,null,null,null,64,"City of Nolanville"]
[null,2,"Yes",null,null,65,"Dimmit",null,null,null,null,null,null,null,null,65,"City of Odessa"]
[null,3,"No",null,null,66,"Donley",null,null,null,null,null,null,null,null,66,"City of Old River-Winfree"]
[null,null,1,null,null,67,"Duval",null,null,null,null,null,null,null,null,67,"City of Orange Grove"]
[null,null,{"$f":"LOOKUP(C70,B67:B69,C67:C69)","v":"(select)"},null,null,68,"Eastland",null,null,null,null,null,null,null,null,68,"City of Palacios"]
[null,null,null,null,null,69,"Ector",null,null,null,null,null,null,null,null,69,"City of Port Lavaca"]
["#13b","Which modes are included?",null,null,null,70,"Edwards",null,null,null,null,null,null,null,null,70,"City of Port Neches"]
[null,null,"Option",null,null,71,"El Paso",null,null,null,null,null,null,null,null,71,"City of Primera"]
[null,false,"Micro-mobility",null,null,72,"Ellis",null,null,null,null,null,null,null,null,72,"City of Progreso"]
[null,false,"Pedestrian",null,null,73,"Erath",null,null,null,null,null,null,null,null,73,"City of Queen City"]
[null,false,"Bicycle",null,null,74,"Falls",null,null,null,null,null,null,null,null,74,"City of Rogers"]
[null,false,"Transit",null,null,75,"Fannin",null,null,null,null,null,null,null,null,75,"City of Rosebud"]
[null,false,"ADA Transition Plan",null,null,76,"Fayette",null,null,null,null,null,null,null,null,76,"City of Sabinal"]
[null,null,null,null,null,77,"Fisher",null,null,null,null,null,null,null,null,77,"City of San Antonio"]
[null,null,null,null,null,78,"Floyd",null,null,null,null,null,null,null,null,78,"City of San Elizario"]
["#18","Plan Elements",null,null,null,79,"Foard",null,null,null,null,null,null,null,null,79,"City of San Marcos"]
[null,false,"Checkbox",null,null,80,"Fort Bend",null,null,null,null,null,null,null,null,80,"City of Schulenburg"]
[null,false,"existing plan/policy review",null,null,81,"Franklin",null,null,null,null,null,null,null,null,81,"City of Sealy"]
[null,false,"existing conditions assessment",null,null,82,"Freestone",null,null,null,null,null,null,null,null,82,"City of Socorro"]
[null,false,"infrastructure recommendations and user typologies",null,null,83,"Frio",null,null,null,null,null,null,null,null,83,"City of Spearman"]
[null,false,"visioning and goal/objective/priority setting",null,null,84,"Gaines",null,null,null,null,null,null,null,null,84,"City of Taft"]
[null,false,"public and stakeholder involvement",null,null,85,"Galveston",null,null,null,null,null,null,null,null,85,"City of Temple"]
[null,false,"needs assessment",null,null,86,"Garza",null,null,null,null,null,null,null,null,86,"City of Texarkana"]
[null,false,"data collection",null,null,87,"Gillespie",null,null,null,null,null,null,null,null,87,"City of Thrall"]
[null,false,"project prioritization and/or recommendations",null,null,88,"Glasscock",null,null,null,null,null,null,null,null,88,"City of Tyler "]
[null,false,"policy recommendations",null,null,89,"Goliad",null,null,null,null,null,null,null,null,89,"City of Uvalde"]
[null,false,"implementation strategy",null,null,90,"Gonzales",null,null,null,null,null,null,null,null,90,"City of Victoria"]
[null,false,"other",null,null,91,"Gray",null,null,null,null,null,null,null,null,91,"City of Vernon"]
[null,null,null,null,null,92,"Grayson",null,null,null,null,null,null,null,null,92,"City of Wharton"]
[null,{"$f":"COUNTIF(B84:B94,\"TRUE\")","v":0},"Total plan activities checkboxes",null,null,93,"Gregg",null,null,null,null,null,null,null,null,93,"City of Wheeler"]
[null,null,null,null,null,94,"Grimes",null,null,null,null,null,null,null,null,94,"Eagle Pass MPO"]
["#15a","Transit Connectivity",null,null,null,95,"Guadalupe",null,null,null,null,null,null,null,null,95,"El Paso County"]
[null,false,"Option",null,null,96,"Hale",null,null,null,null,null,null,null,null,96,"Hidalgo County Precinct #4"]
[null,1,"(select)",null,null,97,"Hall",null,null,null,null,null,null,null,null,97,"Jim Wells County"]
[null,2,"Existing",null,null,98,"Hamilton",null,null,null,null,null,null,null,null,98,"NorthEast Texas Trail Coalition"]
[null,3,"Planned",null,null,99,"Hansford",null,null,null,null,null,null,null,null,99,"Paso del Norte Community Foundation"]
[null,4,"Existing and planned",null,null,100,"Hardeman",null,null,null,null,null,null,null,null,100,"Quitman Lake Country Charitable Foundation"]
[null,null,1,null,null,101,"Hardin",null,null,null,null,null,null,null,null,101,"Red River County"]
[null,null,{"$f":"LOOKUP(C104,B100:B103,C100:C103)","v":"(select)"},null,null,102,"Harris",null,null,null,null,null,null,null,null,102,"Robstown ISD-Police Department"]
[null,null,null,null,null,103,"Harrison",null,null,null,null,null,null,null,null,103,"Salado Independent School District"]
["#15b","Connecting Bicycle Facilities",null,null,null,104,"Hartley",null,null,null,null,null,null,null,null,104,"The University of Texas at San Antonio"]
[null,null,"Option",null,null,105,"Haskell",null,null,null,null,null,null,null,null,105,"The University of Texas at Tyler "]
[null,1,"(select)",null,null,106,"Hays",null,null,null,null,null,null,null,null,106,"Town of Anthony"]
[null,2,"Existing",null,null,107,"Hemphill",null,null,null,null,null,null,null,null,107,"Town of Horizon City"]
[null,3,"Planned",null,null,108,"Henderson",null,null,null,null,null,null,null,null,108,"Town of Woodsboro "]
[null,4,"Existing and planned",null,null,109,"Hidalgo",null,null,null,null,null,null,null,null,109,"Tyler Independent School District"]
[null,null,1,null,null,110,"Hill",null,null,null,null,null,null,null,null,110,"Val Verde County"]
[null,null,{"$f":"LOOKUP(C113,B109:B112,C109:C112)","v":"(select)"},null,null,111,"Hockley",null,null,null,null,null,null,null,null,111,"Village of Vinton"]
[null,null,null,null,null,112,"Hood",null,null,null,null,null,null,null,null,112,"Webb County"]
["#15b","Connecting Pedestrian Facilities",null,null,null,113,"Hopkins",null,null,null,null,null,null,null,null,113,"Walker County Texas"]
[null,null,"Option",null,null,114,"Houston",null,null,null,null,null,null,null,null,null,1]
[null,1,"(select)",null,null,115,"Howard",null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(Q117,P4:P116,Q4:Q116)","v":"(select)"}]
[null,2,"Existing",null,null,116,"Hudspeth"]
[null,3,"Planned",null,null,117,"Hunt"]
[null,4,"Existing and planned",null,null,118,"Hutchinson",null,null,null,null,null,null,null,null,"Transfer to FTA?"]
[null,null,1,null,null,119,"Irion",null,null,null,null,null,null,null,null,1,"(select)"]
[null,null,{"$f":"LOOKUP(C122,B118:B121,C118:C121)","v":"(select)"},null,null,120,"Jack",null,null,null,null,null,null,null,null,2,"Yes"]
[null,null,null,null,null,121,"Jackson",null,null,null,null,null,null,null,null,3,"No"]
["#16","Barrier Elimination Totals",null,null,null,122,"Jasper",null,null,null,null,null,null,null,null,4,"Unsure"]
[null,false,"Option",null,null,123,"Jeff Davis",null,null,null,null,null,null,null,null,null,1]
[null,{"$f":"'Pg3'!$E$16","v":0},"ADA barriers",null,null,124,"Jefferson",null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(Q126,P122:P125,Q122:Q125)","v":"(select)"}]
[null,{"$f":"'Pg3'!$J$16","v":0},"Four lane or larger roadways",null,null,125,"Jim Hogg"]
[null,{"$f":"'Pg3'!$O$16","v":0},"Waterbody(ies)",null,null,126,"Jim Wells"]
[null,{"$f":"'Pg3'!$S$16","v":0},"Railroad",null,null,127,"Johnson"]
[null,{"$f":"'Pg3'!$E$18","v":0},"Other",null,null,128,"Jones"]
[null,{"$f":"SUM(B127:B131)","v":0},"Total barriers eliminated",null,null,129,"Karnes"]
[null,null,null,null,null,130,"Kaufman"]
["#17","Long-distance bicycle tourism (ED)",null,null,null,131,"Kendall"]
[null,null,"Option",null,null,132,"Kenedy"]
[null,1,"[Select]",null,null,133,"Kent"]
[null,2,"Segment of Texas Bicycle Tourism Trails Example Network or locally favored alternative",null,null,134,"Kerr"]
[null,3,"Segment of regional non-motorized route for tourism",null,null,135,"Kimble"]
[null,4,"Segment of contiguous bicycle/pedestrian route connecting regional population centers",null,null,136,"King"]
[null,null,1,null,null,137,"Kinney"]
[null,null,{"$f":"LOOKUP(C140,B136:B139,C136:C139)","v":"[Select]"},null,null,138,"Kleberg"]
[null,{"$f":"IF(C140=1, \"No\",\"Yes\")","v":"No"},"Bicycle tourism efforts involved?",null,null,139,"Knox"]
[null,null,null,null,null,140,"La Salle"]
["#21a","In local transpo plan",null,null,null,141,"Lamar"]
[null,null,"Option",null,null,142,"Lamb"]
[null,1,"(select)",null,null,143,"Lampasas"]
[null,2,"Yes",null,null,144,"Lavaca"]
[null,3,"No",null,null,145,"Lee"]
[null,null,1,null,null,146,"Leon"]
[null,null,{"$f":"LOOKUP(C149,B146:B148,C146:C148)","v":"(select)"},null,null,147,"Liberty"]
[null,null,null,null,null,148,"Limestone"]
["#21b","In ADA transition plan?",null,null,null,149,"Lipscomb"]
[null,null,"Option",null,null,150,"Live Oak"]
[null,1,"(select)",null,null,151,"Llano"]
[null,2,"Yes",null,null,152,"Loving"]
[null,3,"No",null,null,153,"Lubbock"]
[null,null,1,null,null,154,"Lynn"]
[null,null,{"$f":"LOOKUP(C157,B154:B156,C154:C156)","v":"(select)"},null,null,155,"Madison"]
[null,null,null,null,null,156,"Marion"]
["#23a","YES or Nos - ENV issue",null,null,null,157,"Martin"]
[null,null,"Option",null,null,158,"Mason"]
[null,1,"(select)",null,null,159,"Matagorda"]
[null,2,"Yes",null,null,160,"Maverick"]
[null,3,"No",null,null,161,"McCulloch"]
[null,null,1,null,null,162,"McLennan"]
[null,null,{"$f":"LOOKUP(C165,B162:B164,C162:C164)","v":"(select)"},null,null,163,"McMullen"]
[null,null,null,null,null,164,"Medina"]
["#23b","YES or Nos- historic issue",null,null,null,165,"Menard"]
[null,null,"Option",null,null,166,"Midland"]
[null,1,"(select)",null,null,167,"Milam"]
[null,2,"Yes",null,null,168,"Mills"]
[null,3,"No",null,null,169,"Mitchell"]
[null,null,1,null,null,170,"Montague"]
[null,null,{"$f":"LOOKUP(C173,B170:B172,C170:C172)","v":"(select)"},null,null,171,"Montgomery"]
[null,null,null,null,null,172,"Moore"]
["#23c","YES or Nos- approach to solving",null,null,null,173,"Morris"]
[null,null,"Option",null,null,174,"Motley"]
[null,1,"(select)",null,null,175,"Nacogdoches"]
[null,2,"Yes",null,null,176,"Navarro"]
[null,3,"No",null,null,177,"Newton"]
[null,4,"N/A",null,null,178,"Nolan"]
[null,null,1,null,null,179,"Nueces"]
[null,null,{"$f":"LOOKUP(C182,B178:B180,C178:C180)","v":"(select)"},null,null,180,"Ochiltree"]
[null,null,null,null,null,181,"Oldham"]
["#24a","YES or Nos- Prop aqc'd",null,null,null,182,"Orange"]
[null,null,"Option",null,null,183,"Palo Pinto"]
[null,1,"(select)",null,null,184,"Panola"]
[null,2,"Yes",null,null,185,"Parker"]
[null,3,"No",null,null,186,"Parmer"]
[null,4,"Started",null,null,187,"Pecos"]
[null,5,"In progress",null,null,188,"Polk"]
[null,6,"N/A",null,null,189,"Potter"]
[null,null,1,null,null,190,"Presidio"]
[null,null,{"$f":"LOOKUP(C193,B187:B192,C187:C192)","v":"(select)"},null,null,191,"Rains"]
[null,null,null,null,null,192,"Randall"]
["24b","YES or Nos- known encroachments",null,null,null,193,"Reagan"]
[null,null,"Option",null,null,194,"Real"]
[null,1,"(select)",null,null,195,"Red River"]
[null,2,"Yes",null,null,196,"Reeves"]
[null,3,"No",null,null,197,"Refugio"]
[null,4,"N/A",null,null,198,"Roberts"]
[null,null,1,null,null,199,"Robertson"]
[null,null,{"$f":"LOOKUP(C202,B198:B201,C198:C201)","v":"(select)"},null,null,200,"Rockwall"]
[null,null,null,null,null,201,"Runnels"]
["#24c","YES or Nos- property act followed",null,null,null,202,"Rusk"]
[null,null,"Option",null,null,203,"Sabine"]
[null,1,"(select)",null,null,204,"San Augustine"]
[null,2,"Yes",null,null,205,"San Jacinto"]
[null,3,"No",null,null,206,"San Patricio"]
[null,4,"N/A",null,null,207,"San Saba"]
[null,null,1,null,null,208,"Schleicher"]
[null,null,{"$f":"LOOKUP(C211,B207:B210,C207:C210)","v":"(select)"},null,null,209,"Scurry"]
[null,null,null,null,null,210,"Shackelford"]
["#26a","YES or Nos- involves RR ROW",null,null,null,211,"Shelby"]
[null,null,"Option",null,null,212,"Sherman"]
[null,1,"(select)",null,null,213,"Smith"]
[null,2,"Yes",null,null,214,"Somervell"]
[null,3,"No",null,null,215,"Starr"]
[null,null,1,null,null,216,"Stephens"]
[null,null,{"$f":"LOOKUP(C219,B216:B218,C216:C218)","v":"(select)"},null,null,217,"Sterling"]
[null,null,null,null,null,218,"Stonewall"]
["#26b","YES or Nos- coordination begun?",null,null,null,219,"Sutton"]
[null,null,"Option",null,null,220,"Swisher"]
[null,1,"(select)",null,null,221,"Tarrant",null,null,"Historic or systemic pedestrian crash risk as indicated"]
[null,2,"Yes",null,null,222,"Taylor"]
[null,3,"No",null,null,223,"Terrell"]
[null,4,"n/a",null,null,224,"Terry"]
[null,null,1,null,null,225,"Throckmorton"]
[null,null,{"$f":"LOOKUP(C228,B224:B227,C224:C227)","v":"(select)"},null,null,226,"Titus"]
["#26c","YES or Nos- railbanking?",null,null,null,227,"Tom Green"]
[null,null,"Option",null,null,228,"Travis"]
[null,1,"(select)",null,null,229,"Trinity"]
[null,2,"Yes",null,null,230,"Tyler"]
[null,3,"No",null,null,231,"Upshur"]
[null,null,1,null,null,232,"Upton"]
[null,null,{"$f":"LOOKUP(C235,B232:B234,C232:C234)","v":"(select)"},null,null,233,"Uvalde"]
[null,null,null,null,null,234,"Val Verde"]
[null,null,null,null,null,235,"Van Zandt"]
[null,null,null,null,null,236,"Victoria"]
[null,null,null,null,null,237,"Walker"]
[null,null,null,null,null,238,"Waller"]
[null,null,null,null,null,239,"Ward"]
[null,null,null,null,null,240,"Washington"]
[null,null,null,null,null,241,"Webb"]
[null,null,null,null,null,242,"Wharton"]
[null,null,null,null,null,243,"Wheeler"]
[null,null,null,null,null,244,"Wichita"]
[null,null,null,null,null,245,"Wilbarger"]
[null,null,null,null,null,246,"Willacy"]
[null,null,null,null,null,247,"Williamson"]
[null,null,null,null,null,248,"Wilson"]
[null,null,null,null,null,249,"Winkler"]
[null,null,null,null,null,250,"Wise"]
[null,null,null,null,null,251,"Wood"]
[null,null,null,null,null,252,"Yoakum"]
[null,null,null,null,null,253,"Young"]
[null,null,null,null,null,254,"Zapata"]
[null,null,null,null,null,255,"Zavala"]
[null,null,null,null,null,null,1]
[null,null,null,null,null,null,{"$f":"LOOKUP(G259,F4:F258,G4:G258)","v":"(select)"}]

{"sheet":"Extract_Fields","index":7,"n_rows":5,"n_cols":76,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Long Description","0. Filelocation","1. Project Sponsor Name","2. Jurisdiction population","3. Project Sponsor Type","4. Project Sponsor Contact Info - Contact Person","4. Project Sponsor Contact Info - Title","4. Project Sponsor Contact Info - Mailing Address","4. Project Sponsor Contact Info - City","4. Project Sponsor Contact Info - Zip Code","4. Project Sponsor Contact Info - Contact Phone","4. Project Sponsor Contact Info - Email","4. Project Sponsor - Physical Address","4. Project Sponsor Physical City","4. Project Sponsor Physical Zip Code","4. Project Sponsor Entity's Main Phone","4. Project Sponsor Website","4. Project Sponsor Partners","5. Project Name","6. Project Description","7. Project Location Info - County","7. Project Location Info - TX DOT District","8. Project Location Info - MPO","8. Project Location Info - Which MPO","9. SRTS related","9. Prev applied","10. Project Location Info - Google Map Link","11. ATP Type","12. Area coverage type","13a. Existing ATP?","13b. Existing ATP modes- micromobility","13b. Existing ATP modes_ped","13b. Existing ATP modes_bike","13b. Existing ATP modes_transit","13b. Existing ATP modes_ada","13. B/P Safety- Infrastructure Total","15. Public Involvement","16. Barrier Elimination- ADA","16. Barrier Elimination -wide ROW","16. Barrier Elimination- Waterbody","16. Barrier Elimination-rail","16. Barrier Elimination-other","16. Barrier Elimination-other2","17. Projected Time Estimate - TIP/AFA","17. Projected Time Estimate - Procurement","17. Projected Time Estimate - Other (months)","17. Projected Time Estimate - Other Text","17. Projected Time Estimate - Plan Dev","17. Total Projected Time Estimate","18. PlanActivities - PlanReview","18. PlanActivities - ExistCon","18. PlanActivities - InfraRecc","18. PlanActivities - VisioningGoalset","18. PlanActivities - PubInvolve","18. PlanActivities - NeedsAsses","18. PlanActivities - DataColl","18. PlanActivities -ProjPrioritization","18. PlanActivities - PolicyRec","18. PlanActivities - ImplementationStr","18. PlanActivities - Other","18. PlanActivities - OtherText","18. PlanActivities - TotalChecked","19. Itemized Plan Cost","TxDOT Direct State Costs for project oversight (Line 4)","Local Match Percentage","Optional TxDOT Match Percentage","Total Project Estimate (Line 5)","TDCs Used","TDC eligible sponsor","Fed Participation","Fed Participation Percent","State Participation","State Participation Percent","Local Participation","Local Participation Percent"]
[null,"Short Description","File_Location","Project Sponsor Name","Population","ProjSponsor Type","Contact Person","Title","Mailing Address","MailCity","MailZip","Phone","Email","Phys_Address","PhysCity","PhysZip","EntityPhone","Website","Partners","ProjectName","ProjectDesc","ProjectCounty","District","MPO?","Which_MPO","SRTS?","Prevapp?","GoogleMapLink","Plan Type","AreaCovered","ExistingATP?","ExistATP_Micro","ExistATP_Ped","ExistATP_Bike","ExistATP_Transit","ExistATP_ADA","Infra#Checks","Partners","ADA Barriers Eliminated","WideRd Barriers Eliminated","Water Barriers Eliminated","Rail Barriers Eliminated","Other Barriers Eliminated","Otherbarriers_text","Timeline_TIPAFA","Timeline_Procurement","Timeline_Other","OtherText","Timeline_PlanDev","Timeline_TotalProject","PlanReview","ExistCon","InfraRecc","VisioningGoalset","PubInvolve","NeedsAsses","DataColl","ProjPrioritization","PolicyRec","ImplementationStr","Other","OtherText","PlanActivitesNo","Itemized Plan Dev Costs","Dir State Costs","Local Match Percent","Txdotmatch","Total Project Cost","TDCs Used?","TDC eligible sponsor","Fed Participation","Fed Participation %","State Participation","State Participation %","Local Participation","Local Participation %"]
[null,"Input Cell Type",null,"Text","Integer","Dropdown","Text","Text","Text","Text","Text","Text","Text","Text","Text","Text","Text","Text","Text","Text","Text","Dropdown","Dropdown","Dropdown","Dropdown","Dropdown","Dropdown","Text","Dropdown","Dropdown","Dropdown","True/False","True/False","True/False","True/False","True/False","Integer","Text","Integer","Integer","Integer","Integer","Integer","Text","Integer","Integer","Integer","Integer","Integer","Integer","True/False","True/False","True/False","True/False","True/False","True/False","True/False","True/False","True/False","True/False","True/False","True/False","Integer","Real number","Real number","Real number","Real number","Real number","True/False","Dropdown","Real number","Real number","Real number","Real number","Real number","Real number"]
[null,"Input",{"$f":"SUBSTITUTE(LEFT(CELL(\"filename\"),FIND(\"]\",CELL(\"filename\"))-1),\"[\",\"\")","v":"https://jacobsengineering-my.sharepoint.com/personal/carl_seifert_jacobs_com/Documents/01_PTN_BikePed/b_Transportation Alternatives Program/2025 Call/Step2/FINAL DAs/Locked Detailed Applications/2025_TA_Planning_DetailedApplication.xlsm"},{"$f":"'Pg1'!D10","v":0},{"$f":"'Pg1'!Q10","v":0},{"$f":"dropdowns!$C$15","v":"(select)"},{"$f":"'Pg1'!I18","v":0},{"$f":"'Pg1'!Q18","v":0},{"$f":"'Pg1'!I20","v":0},{"$f":"'Pg1'!I22","v":0},{"$f":"'Pg1'!I24","v":0},{"$f":"'Pg1'!I26","v":0},{"$f":"'Pg1'!I28","v":0},{"$f":"'Pg1'!Q20","v":0},{"$f":"'Pg1'!Q22","v":0},{"$f":"'Pg1'!Q24","v":0},{"$f":"'Pg1'!Q26","v":0},{"$f":"'Pg1'!Q28","v":0},{"$f":"'Pg1'!N30","v":0},{"$f":"'Pg1'!I34","v":0},{"$f":"'Pg1'!D37","v":0},{"$f":"dropdowns!G260","v":"(select)"},{"$f":"dropdowns!J31","v":"(select)"},{"$f":"dropdowns!C23","v":"(select)"},{"$f":"dropdowns!M29","v":"(select)"},{"$f":"dropdowns!$C$31","v":"(select)"},{"$f":"dropdowns!C39","v":"(select)"},{"$f":"'Pg2'!E6","v":0},{"$f":"dropdowns!C53","v":"(select)"},{"$f":"dropdowns!C63","v":"(select)"},{"$f":"dropdowns!C71","v":"(select)"},{"$f":"dropdowns!B75","v":false},{"$f":"dropdowns!B76","v":false},{"$f":"dropdowns!B77","v":false},{"$f":"dropdowns!B78","v":false},{"$f":"dropdowns!B79","v":false},{"$f":"[1]dropdowns!$B$226","v":false},{"$f":"'Pg2'!E45","v":0},{"$f":"'Pg3'!E16","v":0},{"$f":"'Pg3'!J16","v":0},{"$f":"'Pg3'!O16","v":0},{"$f":"'Pg3'!S16","v":0},{"$f":"'Pg3'!E18","v":0},{"$f":"'Pg3'!I18","v":0},{"$f":"'Pg3'!E36","v":0},{"$f":"'Pg3'!E41","v":0},{"$f":"'Pg3'!E45","v":0},{"$f":"'Pg3'!N45","v":0},{"$f":"'Pg3'!E48","v":0},{"$f":"'Pg3'!E53","v":0},{"$f":"dropdowns!B84","v":false},{"$f":"dropdowns!B85","v":false},{"$f":"dropdowns!B86","v":false},{"$f":"dropdowns!B87","v":false},{"$f":"dropdowns!B88","v":false},{"$f":"dropdowns!B89","v":false},{"$f":"dropdowns!B90","v":false},{"$f":"dropdowns!B91","v":false},{"$f":"dropdowns!B92","v":false},{"$f":"dropdowns!B93","v":false},{"$f":"dropdowns!B94","v":false},{"$f":"Budget1!H18","v":0},{"$f":"dropdowns!B96","v":0},{"$f":"Budget1!Q59","v":0},{"$f":"BudgetSummary!R10","v":0},{"$f":"BudgetSummary!M14","v":0.2},{"$f":"BudgetSummary!M16","v":0},{"$f":"BudgetSummary!R12","v":0},{"$f":"dropdowns!$T$1","v":false},{"$f":"dropdowns!Q118","v":"(select)"},{"$f":"SignaturePage!P5","v":0},{"$f":"SignaturePage!N5","v":0.8},{"$f":"SignaturePage!P7","v":0},{"$f":"SignaturePage!N7","v":0},{"$f":"SignaturePage!P9","v":0},{"$f":"SignaturePage!$N$9","v":0.2}]