{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Pg1","Pg2","Pg3","Pg4","Pg5","Pg6","TransformativeElmts","Budget1","Budget2","Budget3","Budget4","BudgetSummary","SignaturePage","dropdowns","Extract_Fields"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":8,"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":60,"n_cols":17,"rows_kept":60,"cut":false,"hidden":false,"merged":[[56,3,57,20],[59,3,60,20],[62,3,63,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,"LARGE SCALE\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 J- MPO TIP Letter."]
[]
[]
[null,null,"9. Transportation Alternatives (TA), Safe Routes to School (SRTS) and ADA Transition Plans"]
[null,null,null,"a. Does this project connect children to schools or school-related activities, or part of a \nSafe 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 \nor SRTS Call for Projects? Please select the latest program call submission"]

{"sheet":"Pg2","index":1,"n_rows":71,"n_cols":17,"rows_kept":71,"cut":false,"hidden":false,"merged":[[5,4,5,17],[18,4,20,17],[31,15,31,16],[33,15,33,16],[51,11,51,17],[10,12,10,14],[12,12,12,14],[10,7,10,9],[10,3,10,6],[13,4,15,17],[22,9,22,17],[29,13,29,14],[31,13,31,14],[33,13,33,14],[47,4,50,17],[70,7,70,9],[70,11,70,17],[24,4,24,10],[61,11,61,17],[63,11,63,17],[59,11,59,17],[65,11,65,17],[57,11,57,17],[55,11,55,17],[67,11,67,17],[53,11,53,17]]}
[]
[]
[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,"Project location in relation to roadways:"]
[]
[null,null,null,null,"Project location: Describe using street name, adjacent waterway, or other identifying landmark."]
[null,null,null,"On or adj. to:",null,null,null,null,null,null,null,"From:",null,null,null,"(ex. 1st Avenue)"]
[]
[null,null,null,null,null,null,null,"(ex. Main Street)",null,null,null,"To:",null,null,null,"(ex. 3rd Avenue)"]
[null,null,null,null,"If project involves multiple locations, please provide project limits for the major segment in above blanks. Additionally, please create a complete list of all improvement locations using the descriptive limits and beginning and ending latitude/longitude and label this attachment as A-Project Location Information - No more than 2 pages."]
[]
[]
[]
[null,null,"11. Project Details"]
[null,null,null,null,"Provide a project layout (required) at scale with clearly labeled streets, end points, and all construction locations as an attachment. Additional recommended attachments include typical sections and photographs that describe & provide details about the project. Attachments should be labeled as B-Project Details (required) - No more than 15 pages."]
[]
[]
[null,null,null,null,"If the project plans are 30% or more complete, include only example sheets as attachments and provide"]
[null,null,null,null,"a weblink for plan review here: "]
[]
[null,null,null,null,"The construction plans for this project are currently: ",null,null,null,null,null,null,null,null,null,null,null,"% complete"]
[]
[]
[null,null,null,null,null,null,null,"Primary facility type:",null,null,null,null,"Secondary facility type:"]
[]
[null,null,null,null,null,null,"Total length:",null,null,null,null,null,"Total length:"]
[]
[null,null,null,null,null,null,"Facility width:",null,"feet",null,null,null,"Facility width:",null,null,"feet"]
[]
[null,null,null,null,null,null,"Material depth:",null,"inches",null,null,null,"Material depth:",null,null,"inches"]
[]
[null,null,null,null,"Surface type/material:",null,null,null,null,null,null,null,"Surface type/material:"]
[]
[null,null,null,null,"Does the project propose lighting adjacent to a roadway within state-maintained right-of-way?"]
[]
[null,null,null,null,"Does this project include bridge improvements?",null,null,null,null,null,null,null,null,null,null,null,"Total # of proposed bridges:"]
[null,null,null,null,null,"Note: If more than one bridge is proposed, identify the bridge with the longest span length in the detailed application"]
[null,null,null,null,null,"and identify additional bridges in Attachment B.",null,null,null,null,null,null,null,null,"Structural Materials (Deck/ Beams):"]
[]
[null,null,null,null,"Bridge construction:",null,null,null,null,"Bridge length:",null,"ft","Bridge width:",null,null,"Rail type:"]
[null,null,null,null,"Label attachment(s) as Project Details- Attachment B - No more than 15 pages."]
[null,null,"SAFETY"]
[null,null,"12. Identified bicycle and/or pedestrian safety hazards and countermeasures"]
[null,null,null,null,"Check all of the safety hazards located within the project limits. Next to each checked safety hazard, state the proposed countermeasure(s) addressing the hazard identified. Provide additional information about proposed countermeasures and photos of safety hazards as an attachment: C-Safety Hazards and Countermeasures. Clearly identify these features on Map 1-Safety and include in attachment C."]
[]
[]
[]
[null,null,null,null,null,null,"High roadway speed (45 mph or greater)",null,null,null,null,"Countermeasure…"]
[]
[null,null,null,null,null,null,"Hazardous intersection/conflict point",null,null,null,null,"Countermeasure…"]
[]
[null,null,null,null,null,null,"Uncontrolled intersection/crossing",null,null,null,null,"Countermeasure…"]
[]
[null,null,null,null,null,null,"Lack of bike/ped infrastructure ",null,null,null,null,"Countermeasure…"]
[]
[null,null,null,null,null,null,"High motor vehicle traffic volume",null,null,null,null,"Countermeasure…"]
[]
[null,null,null,null,null,null,"On-street parking",null,null,null,null,"Countermeasure…"]
[]
[null,null,null,null,null,null,"Wide roadway crossing (4 or more lanes)",null,null,null,null,"Countermeasure…"]
[]
[null,null,null,null,null,null,"Lack of lighting",null,null,null,null,"Countermeasure…"]
[]
[null,null,null,null,null,null,"Historic or systemic pedestrian crash risk as indicated",null,null,null,null,"Countermeasure…"]
[null,null,null,null,null,null,"on the Texas PSAP Pedestrian Screening Tool"]
[]
[null,null,null,null,null,null,"Other",null,null,null,null,"Countermeasure…"]

{"sheet":"Pg3","index":2,"n_rows":52,"n_cols":22,"rows_kept":52,"cut":false,"hidden":false,"merged":[[3,4,4,21],[8,6,8,10],[33,4,34,21],[51,4,54,20],[24,4,26,21],[36,4,37,21],[41,4,45,21],[46,4,46,5],[48,8,48,16],[48,6,48,7],[48,4,48,5],[17,4,19,21],[13,4,16,21]]}
[]
[]
[null,null,"13. Bicycle and/or pedestrian infrastructure elements"]
[null,null,null,null,"Which of the following features are part of the proposed project? Check all that apply. Clearly identify these features on Map 1-Safety (required). New bicycle/pedestrian infrastructure…"]
[]
[null,null,null,null,null,null,"closes a gap in bicycle or pedestrian network",null,null,null,null,null,null,null,"features traffic markings/signage"]
[null,null,null,null,null,null,"features new traffic signalization*",null,null,null,null,null,null,null,"improves railroad/highway/water crossing"]
[null,null,null,null,null,null,"features traffic calming elements",null,null,null,null,null,null,null,"new bicycle &/or pedestrian infrastructure"]
[null,null,null,null,null,null,"separates bicycles &/or pedestrians from ",null,null,null,null,null,null,null,"includes a vertical separation element"]
[null,null,null,null,null,null,"motor vehicle traffic",null,null,null,null,null,null,null,"(e.g. curb, flexible delineator, bollard)"]
[null,null,null,null,null,null,"facility is offset from road (>5')"]
[null,null,null,null,null,null,"features safety lighting",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Documentation of signal warrants MUST be included in Attachment C."]
[]
[null,null,null,null,"Projects that add new off-street bicycle or pedestrian facilities along independent rights-of-way, such as creeks, railroads, or utility corridors, may have different benefits or impacts than projects following the alignment of existing roadways.  TxDOT will review the response to question 10 to determine whether the project is proposed on independent right-of-way."]
[]
[]
[]
[null,null,null,null,"TxDOT is interested in projects that respond to documented safety issues. TxDOT will review the Texas Pedestrian Safety Action Plan and analyze crash records to determine the documented bicycle and/or pedestrian crash count and rate in proximity to the proposed project."]
[]
[]
[]
[null,null,"CONNECTIVITY AND ACCESSIBILITY"]
[]
[null,null,"14. Connectivity to destinations"]
[null,null,null,null,"Does the project provide bicycle and pedestrian access to major destinations immediately surrounding the project area that are likely to attract bicycling or walking trips?  Please check destinations below and clearly label on Map 2- Connectivity (required) and include in attachment D- Connectivity."]
[]
[]
[null,null,null,null,null,null,"School",null,null,null,"Major employer",null,null,null,null,"Fresh foods (grocery stores, farmers mkts)"]
[null,null,null,null,null,null,"Park",null,null,null,"Central Business District",null,null,null,null,"Health facility (medical center, sports field)"]
[null,null,null,null,null,null,"Neighborhood",null,null,null,"Commercial Center",null,null,null,null,"Community center"]
[null,null,null,null,null,null,"Library",null,null,null,"High density residential",null,null,null,null,"Other special trip generator (label on map)"]
[]
[null,null,"15. Connectivity to multimodal transportation"]
[null,null,null,"a.","Transit: Does the project support multi-modal transportation by providing access to a rail station, streetcar, and/or a bus stop? Please clearly label on Map 2- Connectivity. "]
[]
[null,null,null,null,"Project connections to transit infrastructure are:"]
[null,null,null,"b.","Bike/ped: Does the project connect to existing or planned bicycle and pedestrian facilities? Please check the facilities to which this project would connect and clearly label on Map 2- Connectivity. Project connects to:"]
[]
[null,null,null,null,"Bicycle facilities:",null,null,null,null,null,null,null,null,null,null,null,"Pedestrian facilities:"]
[]
[null,null,"16. Barrier Elimination"]
[null,null,null,null,"Does the project eliminate an existing barrier to travel and provide safe crossing of that barrier by individuals with disabilities, pedestrians, bicyclists, and other non-drivers of all ages and abilities? For ADA barriers, only count each type of ADA barrier that is being eliminated. For example, if your project includes curb ramps that would count as one barrier, and accessible pedestrian signals would count as another.\nPlease clearly label on Map 2- Connectivity and indicate the number of barriers below."]
[]
[]
[]
[]
[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,"17. Long-distance bicycle route and tourism"]
[null,null,null,null,"Does the project implement a segment or locally favored alternative on the Bicycle Tourism Trail Example Network, improve non-motorized connections between population centers, and/or extend or develop other regional nonmotorized route for tourism? \nLabel attachments to support your answer as E- Long Distance Bicycle Routes."]

{"sheet":"Pg4","index":3,"n_rows":53,"n_cols":5,"rows_kept":53,"cut":false,"hidden":false,"merged":[[4,4,7,18],[11,4,14,18],[22,4,24,17],[18,4,20,17],[27,4,29,17],[38,4,40,17],[49,10,49,17],[46,4,48,17],[31,2,31,12],[52,4,54,17],[43,2,43,17],[44,4,45,17],[32,4,33,17],[34,5,34,17],[36,5,36,17],[41,4,41,17]]}
[]
[]
[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,"DEMAND"]
[]
[null,null,null,null,"TxDOT is interested in projects that improve access to higher density residential and/or employment centers.  TxDOT will analyze US Census data to determine whether projects are located in areas with higher residential and employment density.  TxDOT will compare projects within the Medium Urban population size and within the Large Scale project category."]
[]
[]
[]
[]
[null,null,"COMMUNITY SUPPORT AND PLANNING"]
[null,null,"18. 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 F-Project Sponsor Resolution (required)."]
[]
[]
[null,null,"19. Public Involvement and Support"]
[null,null,null,"a.","Public outreach events in the last five years which engaged the public on this project should be summarized as a bulleted list or table, then attached with supporting documentation as G- Public Outreach and Support (required). "]
[]
[]
[]
[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 G- Public Outreach and Support."]
[]
[]
[]
[null,null,"20. Funding, Development, Maintenance, and Operation Partners"]
[null,null,null,"a.","List collaborating partners and their role in developing/implementing the proposed project. Attach letters of commitment and label them Attachment H- Partners."]
[]
[null,null,null,null,"1)"]
[]
[null,null,null,null,"2)"]
[]
[null,null,null,"b.","Name the entity responsible for project maintenance and operation after construction. Attach a letter of commitment if maintenance and operation will be conducted by a third party and label it H- Partners."]
[]
[]
[]
[]
[null,null,"21. Planning"]
[null,null,null,"a.","Projects may be referenced in various planning documents, such as local Bicycle, Pedestrian, Safe Route to School, Corridor, Traffic Safety, Hazardous Route List, or other Transportation Plans (if applicable)"]
[]
[null,null,null,null,"Is the proposed project included in a local transportation plan?\nIf yes, include as an attachment ONLY the cover and pages of the plan referring to this project. \nLabel attachment(s) as I- Local Planning - No more than 10 pages."]
[]
[]
[null,null,null,null,"Insert transportation plan weblink:"]
[]
[null,null,null,"b.","Transition Plan for ADA Compliance"]
[null,null,null,null,"Is the proposed project included in the project sponsor's Transition Plan for ADA compliance? \nIf yes, include as an attachment only the cover and pages from the plan relevant to this project. \nLabel attachment(s) as I- Local Planning - No more than 10 pages."]

{"sheet":"Pg5","index":4,"n_rows":53,"n_cols":6,"rows_kept":53,"cut":false,"hidden":false,"merged":[[36,4,39,17],[41,16,41,17],[43,5,46,17],[42,5,42,13],[27,5,27,17],[30,5,32,17],[19,5,24,18],[17,5,18,15],[5,4,9,18],[10,4,10,11],[13,4,15,17]]}
[]
[]
[null,null,"PROJECT COMPLEXITY"]
[]
[null,null,"23. Environmental Documentation"]
[null,null,null,null,"An environmental document is required for all federally funded transportation projects. Some project characteristics have the potential to trigger additional environmental mitigation, coordination, and/or permitting. To better understand the potential environmental risks of this project and to aid in eventual project scheduling if awarded, please completed the linked environmental scoping document (required) and include as part of K-Environmental Documentation. "]
[]
[]
[]
[]
[null,null,null,null,"Link to Environmental Scoping Document (required)"]
[]
[null,null,"24. Property Ownership and Acquisition Information"]
[null,null,null,null,"All proposals must provide documentary evidence of the project sponsor's property rights by title of ownership, lease, or easement for all property within the project limits. Examples are included in instructions. Respond to a, b, & c below."]
[]
[]
[]
[null,null,null,null,"a.","Does the project sponsor have current ownership through Deeds/Easements/Dedications or any other form of ownership rights?"]
[]
[null,null,null,null,null,"If Yes - please include proof of ownership (Deeds, Easements, dedications, or other) in Attachment L.\nIf No - How many parcels will be acquired? Describe in the attachment how the property will be acquired. Include a commitment letter from current owner(s) demonstrating a willingness to transfer the property to project sponsor in accordance with state and federal laws.\nIf projects have a direct effect on an existing state-maintained roadway, see Detailed Application Instructions for getting TxDOT District approval."]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"b.","Are there any known encroachments? (utilities, fences, adjacent property improvements)"]
[null,null,null,null,null,"If Yes, identify known encroachments in an attachment. "]
[]
[null,null,null,null,"c.","Was property acquired after 1971 in accordance with the Uniform Act?\n"]
[null,null,null,null,null,"Project property acquired after 1971 must have been acquired in accordance with the Uniform \nRelocation Assistance and Real Property Acquisition Act (Uniform Act). If No, describe briefly when and how the property was acquired in an attachment. "]
[]
[]
[null,null,null,null,"Include details as attachment(s) L- Property Ownership/Acquisition (required)."]
[]
[null,null,"25. Requirements - Signals, Beacons, and School Zones"]
[null,null,null,null,"Projects proposing new traffic control devices including flashing beacons (RRFBs and PHBs) and school zones MUST attach supporting documentation demonstrating these improvements meet warrant/conditions in accordance with the TMUTCD and TxDOT policy. Label attachment(s) M- Signals, Beacons, and School Zones."]
[]
[]
[]
[]
[null,null,"26. Railroad (RR) Support/Right of Entry Letter (if applicable)"]
[null,null,null,null,"a.","Does the project encroach (within 50') or cross RR right-of-way (ROW)?\n"]
[null,null,null,null,null,"If yes, the project sponsor must include documentary evidence from the railroad in support of the project and, where appropriate, a willingness by the railroad to enter into an agreement/contract with the local government for project implementation and provisions for right-of-entry for project construction. Where applicable, a cost for railroad work must be included in the budget."]
[]
[]
[]
[]
[null,null,null,null,"b.","If the project encroaches or crosses RR ROW, has coordination with the RR begun?"]
[]
[null,null,null,null,"c.","Does this project include rail banked right-of-way?"]
[]
[null,null,null,null,null,"Label attachment(s) as N- RR Support/Right-of-Entry Letter - No more than 10 pages."]

{"sheet":"Pg6","index":5,"n_rows":54,"n_cols":8,"rows_kept":54,"cut":false,"hidden":false,"merged":[[18,4,18,6],[18,7,18,18],[19,7,20,18],[35,4,35,6],[35,7,35,18],[36,7,36,18],[22,4,22,6],[22,7,22,19],[23,7,25,18],[27,4,27,6],[27,7,27,18],[28,7,30,18],[32,4,32,6],[32,7,32,18],[33,7,33,18],[3,4,8,18],[10,4,10,18],[13,4,13,6],[13,7,13,18],[14,7,16,18],[53,4,57,17],[38,4,38,6],[38,7,38,18],[44,4,44,6],[48,4,48,6],[48,7,48,18],[49,7,50,18],[40,4,40,6],[40,7,41,10],[40,11,41,18]]}
[]
[]
[null,null,"27. Project Timeline"]
[null,null,null,null,"Estimate the number of months it will take to complete this project (from planning through construction). Estimate the time required for each activity listed below. Several activities should be accomplished concurrently (such as environmental documentation, PS&E development, railroad coordination, and property acquisition); as a result, the Total Projected 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 O- 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 (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,"Project Design and Plan Preparation (minimum 6 months)"]
[null,null,null,null,null,null,null,"(Develop construction Plans, Specifications, and Estimates (PS&E) to state and federal standards. Include time for review by TxDOT District and Division staff, a registered accessibility specialist, and other agencies as needed.)"]
[]
[]
[]
[null,null,null,null,null,null,null,"Environmental Clearance (minimum 6 months)"]
[null,null,null,null,null,null,null,"(Complete the NEPA Scope Development Tool, environmental documentation, and appropriate resource studies; consider environmental mitigation, permits, and review by resource agencies). All documentation and exhibits must meet state and federal standards."]
[]
[]
[]
[null,null,null,null,null,null,null,"ROW Acquisition (acquisitions should occur after environmental clearance)"]
[null,null,null,null,null,null,null,"(Include time for surveying, appraisals, title transfer, etc.)"]
[]
[null,null,null,null,null,null,null,"Railroad coordination (12 to 24 months)"]
[null,null,null,null,null,null,null,"(Include time for railroad owner review of plan documents and execution of railroad agreement.)"]
[]
[null,null,null,null,null,null,null,"Utility Adjustments (if applicable, minimum 6 months)"]
[]
[null,null,null,null,null,null,null,"Other- Describe briefly additional milestones not addressed elsewhere."]
[]
[]
[]
[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"]
[]
[]
[null,null,null,null,null,null,null,"Project Construction/Implementation"]
[null,null,null,null,null,null,null,"(Include time for advertising, procurement of construction contractor, contract negotiations, site preparation, construction, inspection, project close-out, etc.)"]
[]
[]
[]
[null,null,null,null,"Reminder:  All responses in the Detailed Application MUST be supported by the attachments.  Proposed countermeasures and infrastructure elements MUST be specified in the Itemized Budget.  Items missing supporting documentation will not be considered during project evaluation."]

{"sheet":"TransformativeElmts","index":6,"n_rows":34,"n_cols":7,"rows_kept":34,"cut":false,"hidden":false,"merged":[[5,4,8,18],[26,4,26,5],[26,6,28,18],[30,6,31,18],[33,4,33,5],[33,6,35,18],[30,4,30,5],[10,4,10,5],[10,6,15,18],[17,4,17,5],[17,6,19,18],[21,4,21,5],[21,6,24,18]]}
[]
[]
[]
[null,null,"TRANSFORMATIONAL ELEMENTS"]
[]
[null,null,null,null,"For the Large Scale Project Category, TxDOT is interested in funding projects that transform communities. Provide a narrative response to the following six prompts in no more than 5 pages.\nLabel attachment as P- Transformational Elements Narrative"]
[]
[]
[]
[]
[null,null,null,null,"1.",null,"Explain how the project addresses a significant barrier for pedestrians and/or bicyclists. How does the barrier limit pedestrian and/or bicycle access and how will access improve by addressing the barrier? Does the project close a significant gap, provide new connections, address a deficiency in an active transportation network, or meet an important community need? Will the project result in a convenient and logical route that offers improved access to destinations the community was previously unable to easily reach using non-motorized modes of transportation?"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"2.",null,"Explain how this project will improve pedestrian and/or bicycle access for underserved community residents. If applicable, illustrate and provide documentation on how the project was requested or supported by the underserved community residents with other supporting documentation. "]
[]
[]
[]
[null,null,null,null,"3.",null,"Describe how this project leverages other new or proposed funded projects or other community initiatives that will attribute to the transformative nature of this project. As you address the question, consider how this project relates to a) transit, b) land use, c) the overall non-motorized network, and d) local policies and/or ordinances."]
[]
[]
[]
[]
[null,null,null,null,"4.",null,"If applicable, describe how this project features significant economic development potential by transforming the non-motorized environment. As you address this question, consider how this project relates to a) tourism, b) commercial/ service centers, and c) employment centers."]
[]
[]
[]
[null,null,null,null,"5.",null,"Describe any innovative local, regional or interregional partnerships involved in the development and implementation of this project."]
[]
[]
[null,null,null,null,"6.",null,"Will this project propose any solutions that are new to the region? Are there any innovative elements, smart, or connected technologies included in this project?"]

{"sheet":"Budget1","index":7,"n_rows":56,"n_cols":27,"rows_kept":56,"cut":false,"hidden":false,"merged":[[8,4,9,15],[5,4,5,15],[11,4,11,15],[13,4,14,15],[47,16,47,18],[48,3,48,11],[48,14,48,15],[48,16,48,18],[49,3,49,11],[49,14,49,15],[49,16,49,18],[17,16,17,18],[17,14,17,15],[17,3,17,11],[18,3,18,11],[18,14,18,15],[18,16,18,18],[19,3,19,11],[19,14,19,15],[19,16,19,18],[20,3,20,11],[20,14,20,15],[20,16,20,18],[21,3,21,11],[50,16,50,18],[45,14,45,15],[44,3,44,11],[41,3,41,11],[42,3,42,11],[43,3,43,11],[40,3,40,11],[40,14,40,15],[50,3,50,11],[47,3,47,11],[47,14,47,15],[44,16,44,18],[45,16,45,18],[21,14,21,15],[21,16,21,18],[46,3,46,11],[46,14,46,15],[46,16,46,18],[38,3,38,11],[39,3,39,11],[22,14,22,15],[23,14,23,15],[24,14,24,15],[25,14,25,15],[26,14,26,15],[27,14,27,15],[28,14,28,15],[29,14,29,15],[30,14,30,15],[31,14,31,15],[32,14,32,15],[40,16,40,18],[41,16,41,18],[42,16,42,18],[43,16,43,18],[36,14,36,15],[37,14,37,15],[55,16,55,18],[22,3,22,11],[23,3,23,11],[24,3,24,11],[25,3,25,11],[26,3,26,11],[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],[39,14,39,15],[41,14,41,15],[54,3,54,11],[54,14,54,15],[54,16,54,18],[53,3,53,11],[50,14,50,15],[53,14,53,15],[51,3,51,11],[51,14,51,15],[51,16,51,18],[53,16,53,18],[30,16,30,18],[31,16,31,18],[32,16,32,18],[33,16,33,18],[34,16,34,18],[35,16,35,18],[36,16,36,18],[37,16,37,18],[38,16,38,18],[52,3,52,11],[52,14,52,15],[52,16,52,18],[42,14,42,15],[43,14,43,15],[39,16,39,18],[45,3,45,11],[44,14,44,15],[34,14,34,15],[35,14,35,15],[38,14,38,15],[22,16,22,18],[23,16,23,18],[24,16,24,18],[25,16,25,18],[26,16,26,18],[27,16,27,18],[28,16,28,18],[29,16,29,18],[33,14,33,15]]}
[]
[]
[]
[{"$f":"Budget1!Q56","v":0},null,"ITEMIZED BUDGET"]
[null,null,"28. Itemized Construction Cost Estimate"]
[null,null,null,null,"a. Please provide the contingency estimate this project cost estimate is using:"]
[null,null,null,null,null,"Contingency is only allowable if the project PS&E is less than 60% complete."]
[]
[null,null,null,null,"b. Inflation percent increase assumed as part of this project cost estimate is equal to 4%."]
[]
[]
[null,null,null,null,"c. What year does this cost estimate assume construction begins?"]
[]
[null,null,null,null,"d. Provide a detailed cost estimate of all construction costs - use appropriate units (SY, SF, LF, LS, EA, etc.)\nRefer to TxDOT's 2019 TA/SRTS Program Guide for guidance."]
[]
[]
[]
[null,null,null,"Work 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":"M19*O19","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,0,null,null,null,null,null,null,"Each","EA","GAL","Gallon"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M26*O26","v":0},null,null,null,null,null,null,null,null,"HR","Hour"]
[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,"LB","Pound"]
[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,"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,{"$f":"M55*O55","v":0}]
[null,null,null,"(Continued on next page)",null,null,null,null,null,null,null,null,null,null,null,"Subtotal:",{"$f":"SUM(Q19:S55)","v":0}]

{"sheet":"Budget2","index":8,"n_rows":56,"n_cols":26,"rows_kept":56,"cut":false,"hidden":false,"merged":[[22,14,22,15],[23,14,23,15],[24,14,24,15],[25,14,25,15],[26,14,26,15],[27,14,27,15],[28,14,28,15],[29,14,29,15],[30,14,30,15],[47,3,47,11],[47,14,47,15],[47,16,47,18],[5,3,5,11],[5,14,5,15],[5,16,5,18],[18,3,18,11],[18,14,18,15],[18,16,18,18],[15,3,15,11],[6,14,6,15],[7,14,7,15],[6,16,6,18],[7,16,7,18],[8,14,8,15],[9,14,9,15],[14,14,14,15],[8,16,8,18],[9,16,9,18],[10,16,10,18],[11,16,11,18],[15,14,15,15],[10,14,10,15],[11,14,11,15],[46,3,46,11],[46,14,46,15],[46,16,46,18],[12,14,12,15],[21,3,21,11],[21,14,21,15],[31,3,31,11],[31,14,31,15],[19,3,19,11],[19,14,19,15],[20,3,20,11],[20,14,20,15],[13,14,13,15],[42,3,42,11],[42,16,42,18],[43,3,43,11],[44,3,44,11],[43,16,43,18],[44,16,44,18],[45,3,45,11],[12,16,12,18],[13,16,13,18],[14,16,14,18],[15,16,15,18],[48,16,48,18],[50,3,50,11],[50,14,50,15],[50,16,50,18],[49,3,49,11],[49,14,49,15],[49,16,49,18],[16,3,16,11],[17,3,17,11],[16,16,16,18],[16,14,16,15],[17,14,17,15],[22,3,22,11],[23,3,23,11],[24,3,24,11],[25,3,25,11],[26,3,26,11],[17,16,17,18],[21,16,21,18],[31,16,31,18],[19,16,19,18],[20,16,20,18],[32,16,32,18],[33,16,33,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],[55,16,55,18],[6,3,6,11],[7,3,7,11],[8,3,8,11],[9,3,9,11],[10,3,10,11],[11,3,11,11],[12,3,12,11],[13,3,13,11],[14,3,14,11],[53,3,53,11],[53,14,53,15],[53,16,53,18],[54,3,54,11],[54,14,54,15],[54,16,54,18],[48,3,48,11],[48,14,48,15],[34,16,34,18],[33,3,33,11],[34,3,34,11],[35,3,35,11],[36,3,36,11],[37,3,37,11],[27,3,27,11],[28,3,28,11],[29,3,29,11],[30,3,30,11],[32,3,32,11],[32,14,32,15],[33,14,33,15],[34,14,34,15],[35,14,35,15],[36,14,36,15],[37,14,37,15],[22,16,22,18],[23,16,23,18],[24,16,24,18],[25,16,25,18],[26,16,26,18],[27,16,27,18],[28,16,28,18],[29,16,29,18],[30,16,30,18],[40,16,40,18],[41,16,41,18],[45,16,45,18],[35,16,35,18],[36,16,36,18],[37,16,37,18],[38,16,38,18],[39,16,39,18],[38,3,38,11],[39,3,39,11],[40,3,40,11],[41,3,41,11],[38,14,38,15],[39,14,39,15],[40,14,40,15],[41,14,41,15],[42,14,42,15],[43,14,43,15],[44,14,44,15],[45,14,45,15]]}
[]
[]
[]
[null,null,null,"Itemized Construction Cost Estimate (continued)"]
[]
[null,null,null,"Work 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":"M7*O7","v":0},null,null,null,null,null,null,null,null,"AC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M8*O8","v":0},null,null,null,null,null,null,null,null,"CF"]
[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,"CY"]
[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,"CYC"]
[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,"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,"EA"]
[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,"GAL"]
[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,"HR"]
[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,"LB"]
[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,"LF"]
[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"]
[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"]
[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"]
[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"]
[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"]
[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"]
[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"]
[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"]
[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"]
[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"]
[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"]
[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,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,"Total:",{"$f":"SUM(Q7:Q55)+Budget1!Q56","v":0}]

{"sheet":"Budget3","index":9,"n_rows":56,"n_cols":26,"rows_kept":56,"cut":false,"hidden":false,"merged":[[55,16,55,18],[53,3,53,11],[53,14,53,15],[53,16,53,18],[54,3,54,11],[54,14,54,15],[54,16,54,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],[50,3,50,11],[50,14,50,15],[50,16,50,18],[47,3,47,11],[47,14,47,15],[47,16,47,18],[48,3,48,11],[48,14,48,15],[48,16,48,18],[45,3,45,11],[45,14,45,15],[45,16,45,18],[46,3,46,11],[46,14,46,15],[46,16,46,18],[43,3,43,11],[43,14,43,15],[43,16,43,18],[44,3,44,11],[44,14,44,15],[44,16,44,18],[41,3,41,11],[41,14,41,15],[41,16,41,18],[42,3,42,11],[42,14,42,15],[42,16,42,18],[39,3,39,11],[39,14,39,15],[39,16,39,18],[40,3,40,11],[40,14,40,15],[40,16,40,18],[37,3,37,11],[37,14,37,15],[37,16,37,18],[38,3,38,11],[38,14,38,15],[38,16,38,18],[35,3,35,11],[35,14,35,15],[35,16,35,18],[36,3,36,11],[36,14,36,15],[36,16,36,18],[33,3,33,11],[33,14,33,15],[33,16,33,18],[34,3,34,11],[34,14,34,15],[34,16,34,18],[31,3,31,11],[31,14,31,15],[31,16,31,18],[32,3,32,11],[32,14,32,15],[32,16,32,18],[29,3,29,11],[29,14,29,15],[29,16,29,18],[30,3,30,11],[30,14,30,15],[30,16,30,18],[27,3,27,11],[27,14,27,15],[27,16,27,18],[28,3,28,11],[28,14,28,15],[28,16,28,18],[25,3,25,11],[25,14,25,15],[25,16,25,18],[26,3,26,11],[26,14,26,15],[26,16,26,18],[23,3,23,11],[23,14,23,15],[23,16,23,18],[24,3,24,11],[24,14,24,15],[24,16,24,18],[21,3,21,11],[21,14,21,15],[21,16,21,18],[22,3,22,11],[22,14,22,15],[22,16,22,18],[19,3,19,11],[19,14,19,15],[19,16,19,18],[20,3,20,11],[20,14,20,15],[20,16,20,18],[17,3,17,11],[17,14,17,15],[17,16,17,18],[18,3,18,11],[18,14,18,15],[18,16,18,18],[15,3,15,11],[15,14,15,15],[15,16,15,18],[16,3,16,11],[16,14,16,15],[16,16,16,18],[13,3,13,11],[13,14,13,15],[13,16,13,18],[14,3,14,11],[14,14,14,15],[14,16,14,18],[11,3,11,11],[11,14,11,15],[11,16,11,18],[12,3,12,11],[12,14,12,15],[12,16,12,18],[10,3,10,11],[10,14,10,15],[10,16,10,18],[7,3,7,11],[7,14,7,15],[7,16,7,18],[8,3,8,11],[8,14,8,15],[8,16,8,18],[5,3,5,11],[5,14,5,15],[5,16,5,18],[6,3,6,11],[6,14,6,15],[6,16,6,18],[9,3,9,11],[9,14,9,15],[9,16,9,18]]}
[]
[]
[]
[null,null,null,"Itemized Construction Cost Estimate (continued)"]
[]
[null,null,null,"Work 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":"M7*O7","v":0},null,null,null,null,null,null,null,null,"AC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M8*O8","v":0},null,null,null,null,null,null,null,null,"CF"]
[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,"CY"]
[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,"CYC"]
[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,"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,"EA"]
[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,"GAL"]
[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,"HR"]
[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,"LB"]
[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,"LF"]
[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"]
[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"]
[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"]
[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"]
[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"]
[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"]
[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"]
[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"]
[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"]
[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"]
[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"]
[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,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,"Total:",{"$f":"SUM(Q7:Q55)+Budget2!Q56","v":0}]

{"sheet":"Budget4","index":10,"n_rows":56,"n_cols":29,"rows_kept":56,"cut":false,"hidden":false,"merged":[[4,4,7,19],[10,17,10,19],[11,17,11,19],[13,17,13,19],[12,17,12,19],[9,17,9,19],[10,4,10,12],[11,4,11,12],[12,4,12,12],[13,4,13,12],[9,4,9,12],[9,15,9,16],[10,15,10,16],[11,15,11,16],[13,15,13,16],[12,15,12,16],[15,4,15,12],[21,4,21,12],[14,17,14,19],[15,17,15,19],[21,17,21,19],[14,4,14,12],[17,4,17,12],[18,4,18,12],[19,4,19,12],[20,4,20,12],[17,17,17,19],[18,17,18,19],[16,4,16,12],[16,15,16,16],[17,15,17,16],[16,17,16,19],[15,15,15,16],[14,15,14,16],[55,17,55,19],[53,17,53,19],[54,17,54,19],[25,17,25,19],[26,17,26,19],[30,4,30,17],[20,17,20,19],[22,17,22,19],[23,17,23,19],[50,17,50,19],[32,14,32,17],[44,4,44,16],[45,4,45,16],[49,4,49,16],[34,17,34,19],[44,17,44,19],[45,17,45,19],[49,17,49,19],[21,15,21,16],[24,17,24,19],[19,17,19,19],[52,4,52,16],[53,4,53,16],[55,4,55,16],[25,4,25,12],[26,4,26,12],[25,15,25,16],[38,4,41,19],[48,17,48,19],[43,17,43,19],[46,17,46,19],[47,17,47,19],[46,4,46,16],[47,4,47,16],[48,4,48,16],[42,5,42,9],[51,4,51,16],[54,4,54,16],[51,17,51,19],[52,17,52,19],[50,4,50,16],[18,15,18,16],[19,15,19,16],[22,15,22,16],[23,15,23,16],[34,5,34,12],[24,4,24,12],[24,15,24,16],[20,15,20,16],[22,4,22,12],[23,4,23,12]]}
[]
[]
[]
[null,null,null,null,"29. Additional Construction-Related Costs:"]
[null,null,null,null,"Appropriate costs for this section might include: construction engineering and inspection, construction-phase project administration, contract administration, land survey for right of way demarcation, materials testing, permitting, or geotechnical work.  Items ineligible for reimbursement include right-of-way acquisition (e.g., appraisal, parcel survey, title transfer) and legal services."]
[]
[]
[]
[]
[null,null,null,null,"Work Activities",null,null,null,null,null,null,null,null,"Quantity","Unit","Unit Price",null,"Amount",null,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,null,{"$f":"N11*P11","v":0},null,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,null,{"$f":"N12*P12","v":0},null,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,null,0,null,null,null,null,null,null,null,null,null,"CY","Cubic yards"]
[null,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,"CYC","Cycle"]
[null,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,"DAY","Day"]
[null,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,"EA","Each"]
[null,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,"GAL","Gallon"]
[null,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,"HR","Hour"]
[null,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,null,0]
[null,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,"LB","Pound"]
[null,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,"LF","Linear foot"]
[null,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,"LMI","Lane mile"]
[null,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,"LS","Lump sum"]
[null,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,"MBF","Thousand board feet"]
[null,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,"MG","Thousand Gallons"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total:",{"$f":"SUM(R11:R26)","v":0},null,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,null,null,null,null,null,null,null,null,null,null,null,"MO","Month"]
[]
[null,null,null,null,"Preliminary Engineering (PS&E and Environmental) Costs Eligibility "]
[]
[null,null,null,null,null,"Project plans percent complete ",null,null,null,null,null,{"$f":"'Pg2'!P25","v":0},"%",null,{"$f":"IF(L33<31,\"PE Costs are Eligible\",\"PE Costs are NOT eligible\")","v":"PE Costs are Eligible"}]
[]
[null,null,null,null,null,"Eligible Preliminary Engineering Costs ",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O33=\"PE Costs are Eligible\",$R$56,0)","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,"SF","Square feet"]
[]
[null,null,null,null,"30. Preliminary Engineering (PS&E and Environmental) Costs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"STA","Station"]
[null,null,null,null,"Identify proposed preliminary engineering costs to be incurred by the project sponsor after project selection and after authorization to proceed. \nLabel attachment(s) as P - Preliminary Engineering (PS&E and Environmental) Costs - No more than 2 pages.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,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,null,null,null,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,null,null,null,null,null,null,null,null,null,null,null,"$/D","Dollars per day"]
[]
[]
[null,null,null,null,"Work Activities",null,null,null,null,null,null,null,null,null,null,null,null,"Cost/Value"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Total:",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O33=\"PE Costs are Eligible\",SUM(R45:R55),\"Not eligible\")","v":0}]

{"sheet":"BudgetSummary","index":11,"n_rows":129,"n_cols":33,"rows_kept":129,"cut":false,"hidden":false,"merged":[[5,2,5,18],[17,4,17,12],[23,17,23,18],[57,12,57,13],[52,5,52,12],[52,14,52,15],[25,17,25,18],[28,4,30,17],[31,4,33,17],[34,4,36,17],[39,4,42,17],[44,4,45,17],[49,4,50,17],[7,4,7,15],[7,17,7,18],[13,4,13,15],[13,17,13,18],[9,17,9,18],[11,17,11,18],[15,4,15,15],[15,17,15,18],[58,9,58,11],[59,9,59,11],[58,4,58,7],[59,4,59,7],[57,17,57,18],[56,8,56,18],[57,14,57,16],[17,17,17,18],[21,4,21,15],[21,17,21,18],[57,9,57,11],[19,4,19,15],[19,17,19,18],[17,13,17,15],[60,4,60,7],[61,4,61,7],[60,17,60,18],[58,12,58,13],[59,12,59,13],[60,12,60,13],[61,12,61,13],[58,17,58,18],[59,17,59,18],[61,17,61,18],[60,9,60,11],[61,9,61,11],[58,14,58,16],[59,14,59,16],[60,14,60,16],[61,14,61,16]]}
[]
[]
[]
[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,"31. Project Budget Summary (many lines automatically populate, numbers are rounded up to the nearest $1,000)"]
[]
[null,null,null,null,"Total Itemized Construction Cost Estimate (topic 28 total, from Budget Page 3)",null,null,null,null,null,null,null,null,null,null,null,"1.",{"$f":"ROUNDUP(Budget3!Q56,-3)","v":0},null,null,null,null,null,{"$f":"R8+R10+R12","v":0}]
[]
[null,null,null,null,"Contingency Costs (line 1 x contingency percentage)",null,null,null,null,null,null,null,null,null,null,null,"2.",{"$f":"ROUNDUP($R$8*IF(dropdowns!U$12=\"(select)\",0,(dropdowns!$U$12)),-3)","v":0},null,null,null,null,null,{"$f":"IF(R16>5000000,0.08,IF(R16>2000000,0.1,0.15))","v":0.15}]
[]
[null,null,null,null,"Inflation Adjustment (line 1 x 4% x assumed years until construction)",null,null,null,null,null,null,null,null,null,null,null,"3.",{"$f":"ROUNDUP(dropdowns!U24*$R$8*0.04,-3)","v":0},null,null,null,null,null,{"$f":"IF(X10=0.08,\"8%\",IF(X10=0.1,\"10%\",\"15%\"))","v":"15%"}]
[]
[null,null,null,null,"Total Additional Construction-Related Costs (topic 29 total, from Budget Page 4)",null,null,null,null,null,null,null,null,null,null,null,"4.",{"$f":"ROUNDUP(Budget4!R27,-3)","v":0}]
[]
[null,null,null,null,"Total Construction Cost Estimate (Sum of lines 1 through 4)",null,null,null,null,null,null,null,null,null,null,null,"5.",{"$f":"ROUNDUP($R$8+$R$10+$R$12+$R$14,-3)","v":0}]
[]
[null,null,null,null,"TxDOT Direct State Costs for project oversight1",null,null,null,null,null,null,null,null,{"$f":"\"(\"&X12&\" of lines 1-3)\"","v":"(15% of lines 1-3)"},null,null,"6.",{"$f":"SUM(ROUNDUP(X8*X10*0.7,-3),ROUNDUP(X8*X10*0.15,-3),ROUNDUP(X8*X10*0.1,-3),ROUNDUP(X8*X10*0.03,-3),ROUNDUP(X8*X10*0.02,-3))","v":0}]
[]
[null,null,null,null,"Total Preliminary Engineering Cost (topic 30 total, from Budget Page 4)",null,null,null,null,null,null,null,null,null,null,null,"7.",{"$f":"ROUNDUP(Budget4!$R$35,-3)","v":0}]
[]
[null,null,null,null,"Total Project Cost Estimate [Sum of lines 5 through 7]",null,null,null,null,null,null,null,null,null,null,null,"8.",{"$f":"ROUNDUP($R$16+$R$18+$R$20,-3)","v":0}]
[]
[null,null,null,null,"Optional Local Match Increase2",null,null,null,null,null,null,null,0.2,"of line 8",null,null,null,{"$f":"IF(dropdowns!T1=TRUE,\"(see table below)\",BudgetSummary!LocalMatch*BudgetSummary!R22)","v":0}]
[]
[null,null,null,null,"TxDOT Optional Discretionary Funds3",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(dropdowns!T1=TRUE,\"(see table below)\",M26*BudgetSummary!R22)","v":0}]
[]
[]
[null,null,null,null,"1Direct State Costs: TxDOT calculates the Direct State Costs (DSCs) relative to the Total Construction Cost Estimate (line 5) such that DSCs are 8% for projects over $5M, 10% for projects between $2M-$5M, and 15% for projects less than $2M."]
[]
[]
[null,null,null,null,"2Local 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 9 below), then the federal share will be fixed at 100% federal participation in lieu of local match."]
[]
[]
[null,null,null,null,"3TxDOT 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,"Transfers to FTA: TA funds may be transferred to a compatibile Federal Transit Administration (FTA) grant program for implementation when a project has a transit nexus and when all project components are eligible under the receiving FTA Program rules. Does the project sponsor intend to transfer this project to FTA? See Program Guide for more detail."]
[]
[]
[]
[]
[null,null,null,null,"Transportation Development Credits (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,"Eligibility for Transportation Development Credits "]
[]
[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,"9.",{"$f":"IF(dropdowns!T1=TRUE,$R$22*0.2,0)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Participation"]
[null,null,null,null,null,null,null,null,"Percent","Preliminary Engineering Costs",null,null,"Construction Costs",null,"Direct State Costs",null,null,"Total Project Costs"]
[null,null,null,null,"Federal",null,null,null,{"$f":"SignaturePage!N4","v":0.8},{"$f":"$R$20*SignaturePage!$N$4","v":0},null,null,{"$f":"$R$16*SignaturePage!$N$4","v":0},null,{"$f":"$R$18*SignaturePage!$N$4","v":0},null,null,{"$f":"SignaturePage!P4","v":0}]
[null,null,null,null,"State",null,null,null,{"$f":"SignaturePage!$N$6","v":0},{"$f":"IF(SignaturePage!N6=\"-\",0,$R$20*SignaturePage!$N$6)","v":0},null,null,{"$f":"IF(SignaturePage!N6=\"-\",0,$R$16*SignaturePage!$N$6)","v":0},null,{"$f":"IF(SignaturePage!N6=\"-\",0,$R$18*SignaturePage!$N$6)","v":0},null,null,{"$f":"IF(SignaturePage!$P$6=\"-\",0,SignaturePage!$P$6)","v":0}]
[null,null,null,null,"Local",null,null,null,{"$f":"SignaturePage!$N$8","v":0.2},{"$f":"$R$20*SignaturePage!$N$8","v":0},null,null,{"$f":"$R$16*SignaturePage!$N$8","v":0},null,{"$f":"$R$18*SignaturePage!$N$8","v":0},null,null,{"$f":"SignaturePage!P8","v":0}]
[null,null,null,null,"Total",null,null,null,{"$f":"I59+I60+I61","v":1},{"$f":"J59+J60+J61","v":0},null,null,{"$f":"M59+M60+M61","v":0},null,{"$f":"O59+O60+O61","v":0},null,null,{"$f":"R59+R60+R61","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$24","v":0},{"$f":"$R$24","v":0},{"$f":"IF(dropdowns!#REF!=TRUE,(1-SignaturePage!$N$4-SignaturePage!$N$6)*$R$22,\"other option\")","v":{"$error":"#REF!"}},{"$f":"0","v":0}]

{"sheet":"SignaturePage","index":12,"n_rows":31,"n_cols":28,"rows_kept":31,"cut":false,"hidden":false,"merged":[[12,3,12,17],[18,3,18,17],[30,2,30,17],[16,3,16,17],[14,3,14,17],[20,3,20,17],[5,15,5,16],[3,13,3,14],[5,13,5,14],[7,13,7,14],[3,15,3,16],[7,15,7,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!M24+BudgetSummary!M26))","v":0.8},null,{"$f":"$N$4*BudgetSummary!$R$22","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$26)","v":0},null,{"$f":"$N$6*BudgetSummary!$R$22","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$24)","v":0.2},null,{"$f":"$N$8*BudgetSummary!$R$22","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))"]
[]
[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. preliminary engineering or construction). 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,"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,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":13,"n_rows":351,"n_cols":26,"rows_kept":351,"cut":false,"hidden":true,"merged":[[3,19,3,20],[14,19,14,20],[25,19,25,20],[24,1,24,2],[9,23,9,25],[16,1,16,2],[1,11,1,12],[53,1,53,2],[72,1,72,2],[1,1,1,2],[1,5,1,6],[1,8,1,9],[45,1,45,2],[32,1,32,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,1,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":"(select)"},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,1,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":"(select)"},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":0},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,27,"Multiple Districts",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,1,null,null,null,null,null,28,"City of Del Rio",null,null,false,5]
[null,null,null,null,null,29,"Caldwell",null,null,{"$f":"LOOKUP(J31,I4:I29,J4:J29)","v":"(select)"},null,null,null,null,null,29,"City of Denison",null,null,false,7]
["#9b","Previous submittal??",null,null,null,30,"Calhoun",null,null,null,null,null,null,null,null,30,"City of DeSoto"]
[null,null,"Option",null,null,31,"Callahan",null,null,null,null,null,null,null,null,31,"City of Duncanville"]
[null,1,"(select)",null,null,32,"Cameron",null,null,null,null,null,null,null,null,32,"City of Eagle Pass"]
[null,2,"No prior submittal",null,null,33,"Camp",null,null,null,null,null,null,null,null,33,"City of Early"]
[null,3,"2015 TAP",null,null,34,"Carson",null,null,null,null,null,null,null,null,34,"City of East Bernard"]
[null,4,"2017 TASA",null,null,35,"Cass",null,null,null,null,null,null,null,null,35,"City of El Campo"]
[null,5,"2019 TA/SRTS",null,null,36,"Castro",null,null,null,null,null,null,null,null,36,"City of El Paso "]
[null,6,"2021 TA",null,null,37,"Chambers",null,null,null,null,null,null,null,null,37,"City of Freeport"]
[null,7,"2023 TA",null,null,38,"Cherokee",null,null,null,null,null,null,null,null,38,"City of Gladewater"]
[null,null,1,null,null,39,"Childress",null,null,null,null,null,null,null,null,39,"City of Granger"]
[null,null,{"$f":"LOOKUP(C42,B35:B41,C35:C41)","v":"(select)"},null,null,40,"Clay",null,null,null,null,null,null,null,null,40,"City of Hallettsville"]
[null,null,null,null,null,41,"Cochran",null,null,null,null,null,null,null,null,41,"City of Harlingen"]
[null,null,null,null,null,42,"Coke",null,null,null,null,null,null,null,null,42,"City of Hemphill"]
["#9d","ADA transition plan related?",null,null,null,43,"Coleman",null,null,null,null,null,null,null,null,43,"Town of Holland"]
[null,null,"Option",null,null,44,"Collin",null,null,null,null,null,null,null,null,44,"City of Huntington"]
[null,1,"(select)",null,null,45,"Collingsworth",null,null,null,null,null,null,null,null,45,"City of Huntsville"]
[null,2,"Yes",null,null,46,"Colorado",null,null,null,null,null,null,null,null,46,"City of Jefferson"]
[null,3,"No",null,null,47,"Comal",null,null,null,null,null,null,null,null,47,"City of Jourdanton"]
[null,null,2,null,null,48,"Comanche",null,null,null,null,null,null,null,null,48,"City of Kaufman"]
[null,null,{"$f":"LOOKUP(C51,B48:B50,C48:C50)","v":"Yes"},null,null,49,"Concho",null,null,null,null,null,null,null,null,49,"City of Killeen"]
[null,null,null,null,null,50,"Cooke",null,null,null,null,null,null,null,null,50,"City of Kingsville"]
["#10a","Project Location in relation to roadways",null,null,null,51,"Coryell",null,null,null,null,null,null,null,null,51,"City of Lancaster"]
[null,null,"Option",null,null,52,"Cottle",null,null,null,null,null,null,null,null,52,"City of Laredo"]
[null,1,"(select)",null,null,53,"Crane",null,null,null,null,null,null,null,null,53,"City of Leon Valley"]
[null,2,"On/along a TxDOT maintained roadway",null,null,54,"Crockett",null,null,null,null,null,null,null,null,54,"City of Liberty"]
[null,3,"On/along a non-TxDOT roadway",null,null,55,"Crosby",null,null,null,null,null,null,null,null,55,"City of Liberty Hill"]
[null,4,"On/along both TxDOT and non-TxDOT roadways",null,null,56,"Culberson",null,null,null,null,null,null,null,null,56,"City of Livingston"]
[null,5,"Not within the right-of-way of any roadway",null,null,57,"Dallam",null,null,null,null,null,null,null,null,57,"City of Longview"]
[null,null,1,null,null,58,"Dallas",null,null,null,null,null,null,null,null,58,"City of Lufkin"]
[null,null,{"$f":"LOOKUP(C61,B56:B58,C56:C60)","v":"(select)"},null,null,59,"Dawson",null,null,null,null,null,null,null,null,59,"Town of Mabank"]
[null,null,null,null,null,60,"DeWitt",null,null,null,null,null,null,null,null,60,"City of Marlin"]
["#11a","CONSTRUCTION PLANS",null,null,null,61,"Deaf Smith",null,null,null,null,null,null,null,null,61,"City of Mathis"]
[null,null,"Options",null,null,62,"Delta",null,null,null,null,null,null,null,null,62,"City of Mineola"]
[null,1,"(select)",null,null,63,"Denton",null,null,null,null,null,null,null,null,63,"City of Nacogdoches"]
[null,2,"Not Started",null,null,64,"Dickens",null,null,null,null,null,null,null,null,64,"City of Nolanville"]
[null,3,"Under development",null,null,65,"Dimmit",null,null,null,null,null,null,null,null,65,"City of Odessa"]
[null,4,"Complete",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,B66:B69,C66: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"]
["#11ba","Primary Facility Types",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,1,"(select)",null,null,72,"Ellis",null,null,null,null,null,null,null,null,72,"City of Progreso"]
[null,2,"Bike Lane",null,null,73,"Erath",null,null,null,null,null,null,null,null,73,"City of Queen City"]
[null,3,"Buffered Bike Lane",null,null,74,"Falls",null,null,null,null,null,null,null,null,74,"City of Rogers"]
[null,4,"Other Safety Improvements",null,null,75,"Fannin",null,null,null,null,null,null,null,null,75,"City of Rosebud"]
[null,5,"Separated Bike Lane/Cycletrack",null,null,76,"Fayette",null,null,null,null,null,null,null,null,76,"City of Sabinal"]
[null,6,"Shoulders",null,null,77,"Fisher",null,null,null,null,null,null,null,null,77,"City of San Antonio"]
[null,7,"Shared Use Path",null,null,78,"Floyd",null,null,null,null,null,null,null,null,78,"City of San Elizario"]
[null,8,"Sidewalks",null,null,79,"Foard",null,null,null,null,null,null,null,null,79,"City of San Marcos"]
[null,null,1,null,null,80,"Fort Bend",null,null,null,null,null,null,null,null,80,"City of Schulenburg"]
[null,null,{"$f":"LOOKUP(C83,B75:B82,C75:C82)","v":"(select)"},null,null,81,"Franklin",null,null,null,null,null,null,null,null,81,"City of Sealy"]
[null,null,null,null,null,82,"Freestone",null,null,null,null,null,null,null,null,82,"City of Socorro"]
["#11bb","Primary Surface Type/Material",null,null,null,83,"Frio",null,null,null,null,null,null,null,null,83,"City of Spearman"]
[null,null,"Option",null,null,84,"Gaines",null,null,null,null,null,null,null,null,84,"City of Taft"]
[null,1,"(select)",null,null,85,"Galveston",null,null,null,null,null,null,null,null,85,"City of Temple"]
[null,2,"Concrete",null,null,86,"Garza",null,null,null,null,null,null,null,null,86,"City of Texarkana"]
[null,3,"Asphalt",null,null,87,"Gillespie",null,null,null,null,null,null,null,null,87,"City of Thrall"]
[null,4,"Crushed Rock",null,null,88,"Glasscock",null,null,null,null,null,null,null,null,88,"City of Tyler "]
[null,5,"Other",null,null,89,"Goliad",null,null,null,null,null,null,null,null,89,"City of Uvalde"]
[null,null,1,null,null,90,"Gonzales",null,null,null,null,null,null,null,null,90,"City of Victoria"]
[null,null,{"$f":"LOOKUP(C93,B88:B92,C88:C92)","v":"(select)"},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"]
["#10bc","Feet or Miles",null,null,null,93,"Gregg",null,null,null,null,null,null,null,null,93,"City of Wheeler"]
[null,null,"Option",null,null,94,"Grimes",null,null,null,null,null,null,null,null,94,"Eagle Pass MPO"]
[null,1,"(select)",null,null,95,"Guadalupe",null,null,null,null,null,null,null,null,95,"El Paso County"]
[null,2,"feet",null,null,96,"Hale",null,null,null,null,null,null,null,null,96,"Hidalgo County Precinct #4"]
[null,3,"miles",null,null,97,"Hall",null,null,null,null,null,null,null,null,97,"Jim Wells County"]
[null,null,1,null,null,98,"Hamilton",null,null,null,null,null,null,null,null,98,"NorthEast Texas Trail Coalition"]
[null,null,{"$f":"LOOKUP(C101,B98:B100,C98:C100)","v":"(select)"},null,null,99,"Hansford",null,null,null,null,null,null,null,null,99,"Paso del Norte Community Foundation"]
[null,null,null,null,null,100,"Hardeman",null,null,null,null,null,null,null,null,100,"Quitman Lake Country Charitable Foundation"]
["#11ca","Secondary Facility Types",null,null,null,101,"Hardin",null,null,null,null,null,null,null,null,101,"Red River County"]
[null,null,"Option",null,null,102,"Harris",null,null,null,null,null,null,null,null,102,"Robstown ISD-Police Department"]
[null,1,"(select)",null,null,103,"Harrison",null,null,null,null,null,null,null,null,103,"Salado Independent School District"]
[null,2,"Bike Lane",null,null,104,"Hartley",null,null,null,null,null,null,null,null,104,"The University of Texas at San Antonio"]
[null,3,"Buffered Bike Lane",null,null,105,"Haskell",null,null,null,null,null,null,null,null,105,"The University of Texas at Tyler "]
[null,4,"Other Safety Improvements",null,null,106,"Hays",null,null,null,null,null,null,null,null,106,"Town of Anthony"]
[null,5,"Separated Bike Lane/Cycletrack",null,null,107,"Hemphill",null,null,null,null,null,null,null,null,107,"Town of Horizon City"]
[null,6,"Shoulders",null,null,108,"Henderson",null,null,null,null,null,null,null,null,108,"Town of Woodsboro "]
[null,7,"Shared Use Path",null,null,109,"Hidalgo",null,null,null,null,null,null,null,null,109,"Tyler Independent School District"]
[null,8,"Sidewalks",null,null,110,"Hill",null,null,null,null,null,null,null,null,110,"Val Verde County"]
[null,9,"N/A",null,null,111,"Hockley",null,null,null,null,null,null,null,null,111,"Village of Vinton"]
[null,null,1,null,null,112,"Hood",null,null,null,null,null,null,null,null,112,"Webb County"]
[null,null,{"$f":"LOOKUP(C115,B106:B114,C106:C114)","v":"(select)"},null,null,113,"Hopkins",null,null,null,null,null,null,null,null,113,"Walker County Texas"]
[null,null,null,null,null,114,"Houston",null,null,null,null,null,null,null,null,null,1]
["#11cb","Secondary Surface Type/Material",null,null,null,115,"Howard",null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(Q117,P4:P116,Q4:Q116)","v":"(select)"}]
[null,null,"Option",null,null,116,"Hudspeth"]
[null,1,"(select)",null,null,117,"Hunt"]
[null,2,"Concrete",null,null,118,"Hutchinson",null,null,null,null,null,null,null,null,"Transfer to FTA?"]
[null,3,"Asphalt",null,null,119,"Irion",null,null,null,null,null,null,null,null,1,"(select)"]
[null,4,"Crushed Rock",null,null,120,"Jack",null,null,null,null,null,null,null,null,2,"Yes"]
[null,5,"Other",null,null,121,"Jackson",null,null,null,null,null,null,null,null,3,"No"]
[null,6,"N/A",null,null,122,"Jasper",null,null,null,null,null,null,null,null,4,"Unsure"]
[null,null,1,null,null,123,"Jeff Davis",null,null,null,null,null,null,null,null,null,1]
[null,null,{"$f":"LOOKUP(C126,B120:B125,C120:C125)","v":"(select)"},null,null,124,"Jefferson",null,null,null,null,null,null,null,null,null,{"$f":"LOOKUP(Q126,P122:P125,Q122:Q125)","v":"(select)"}]
[null,null,null,null,null,125,"Jim Hogg"]
["#11cc","Feet or Miles",null,null,null,126,"Jim Wells"]
[null,null,"Option",null,null,127,"Johnson"]
[null,1,"(select)",null,null,128,"Jones"]
[null,2,"feet",null,null,129,"Karnes"]
[null,3,"miles",null,null,130,"Kaufman"]
[null,4,"N/A",null,null,131,"Kendall"]
[null,null,1,null,null,132,"Kenedy"]
[null,null,{"$f":"LOOKUP(C135,B131:B134,C131:C134)","v":"(select)"},null,null,133,"Kent"]
[null,null,null,null,null,134,"Kerr"]
["#11d","Lighting along State Road",null,null,null,135,"Kimble"]
[null,null,"Option",null,null,136,"King"]
[null,1,"(select)",null,null,137,"Kinney"]
[null,2,"Yes",null,null,138,"Kleberg"]
[null,3,"No",null,null,139,"Knox"]
[null,4,"n/a",null,null,140,"La Salle"]
[null,null,1,null,null,141,"Lamar"]
[null,null,{"$f":"LOOKUP(C144,B140:B143,C140:C143)","v":"(select)"},null,null,142,"Lamb"]
[null,null,null,null,null,143,"Lampasas"]
["#11e","Project has bridges?",null,null,null,144,"Lavaca"]
[null,null,"Option",null,null,145,"Lee"]
[null,1,"(select)",null,null,146,"Leon"]
[null,2,"Yes, rehab only",null,null,147,"Liberty"]
[null,3,"Yes, new bridge(s)",null,null,148,"Limestone"]
[null,4,"No",null,null,149,"Lipscomb"]
[null,5,"N/A",null,null,150,"Live Oak"]
[null,null,1,null,null,151,"Llano"]
[null,null,{"$f":"LOOKUP(C154,B149:B153,C149:C153)","v":"(select)"},null,null,152,"Loving"]
[null,null,null,null,null,153,"Lubbock"]
["#11f","Bridge Construction type",null,null,null,154,"Lynn"]
[null,null,"Option",null,null,155,"Madison"]
[null,1,"(select)",null,null,156,"Marion"]
[null,2,"Prefab",null,null,157,"Martin"]
[null,3,"On-site",null,null,158,"Mason"]
[null,4,"N/A",null,null,159,"Matagorda"]
[null,null,1,null,null,160,"Maverick"]
[null,null,{"$f":"LOOKUP(C163,B159:B162,C159:C162)","v":"(select)"},null,null,161,"McCulloch"]
["#11g","Deck/Beam",null,null,null,162,"McLennan"]
[null,null,"Option",null,null,163,"McMullen"]
[null,1,"(select)",null,null,164,"Medina"]
[null,2,"Concrete/ Steel",null,null,165,"Menard"]
[null,3,"Wood/ Wood",null,null,166,"Midland"]
[null,4,"Concrete/ Concrete",null,null,167,"Milam"]
[null,5,"Concrete/ Truss",null,null,168,"Mills"]
[null,6,"Wood/ Truss",null,null,169,"Mitchell"]
[null,7,"Wood/ Steel",null,null,170,"Montague"]
[null,8,"Masonry",null,null,171,"Montgomery"]
[null,9,"N/A",null,null,172,"Moore"]
[null,null,1,null,null,173,"Morris"]
[null,null,{"$f":"LOOKUP(C176,B167:B175,C167:C175)","v":"(select)"},null,null,174,"Motley"]
[null,null,null,null,null,175,"Nacogdoches"]
["#11h","Bridge Rail Type",null,null,null,176,"Navarro"]
[null,null,"Option",null,null,177,"Newton"]
[null,1,"(select)",null,null,178,"Nolan"]
[null,2,"Pedestrian",null,null,179,"Nueces"]
[null,3,"Traffic",null,null,180,"Ochiltree"]
[null,4,"N/A",null,null,181,"Oldham"]
[null,null,1,null,null,182,"Orange"]
[null,null,{"$f":"LOOKUP(C185,B181:B184,C181:C184)","v":"(select)"},null,null,183,"Palo Pinto"]
[null,null,null,null,null,184,"Panola"]
["#12","Identified Safety Hazards",null,null,null,185,"Parker"]
[null,null,"Checkbox",null,null,186,"Parmer"]
[null,false,"High roadway speed (45 mph or greater)",null,null,187,"Pecos"]
[null,false,"Hazardous intersection/conflict point",null,null,188,"Polk"]
[null,false,"Uncontrolled intersection/crossing",null,null,189,"Potter"]
[null,false,"Lack of bike/ped infrastructure ",null,null,190,"Presidio"]
[null,false,"High motor vehicle traffic volume",null,null,191,"Rains"]
[null,false,"On-street parking",null,null,192,"Randall"]
[null,false,"Wide roadway crossing (4 or more lanes)",null,null,193,"Reagan"]
[null,false,"Lack of lighting",null,null,194,"Real"]
[null,false,"Historic or systemic pedestrian crash risk as indicated by PSAP Ped Safety Screening tool",null,null,195,"Red River"]
[null,false,"Other",null,null,196,"Reeves"]
[null,{"$f":"COUNTIF(B190:B199,\"TRUE\")","v":0},"Number of identified Safety hazard Check-marks",null,null,197,"Refugio"]
[null,null,null,null,null,198,"Roberts"]
["#13","Safety Elements",null,null,null,199,"Robertson"]
[null,null,"Checkbox",null,null,200,"Rockwall"]
[null,false,"closes a gap in bicycle or pedestrian network ",null,null,201,"Runnels"]
[null,false,"separates bicycles &/or pedestrians from motor vehicle traffic",null,null,202,"Rusk"]
[null,false,"is on-street with a vertical separation element",null,null,203,"Sabine"]
[null,false,"improves railroad/highway/water crossing",null,null,204,"San Augustine"]
[null,false,"features traffic markings/signage",null,null,205,"San Jacinto"]
[null,false,"features new traffic signalization",null,null,206,"San Patricio"]
[null,false,"new bicycle &/or pedestrian infrastructure",null,null,207,"San Saba"]
[null,false,"features traffic calming elements",null,null,208,"Schleicher"]
[null,false,"facility is offset from road (>5')",null,null,209,"Scurry"]
[null,false,"features safety lighting",null,null,210,"Shackelford"]
[null,{"$f":"COUNTIF(B204:B212,\"TRUE\")","v":0},"Number of Safety Element Check-marks",null,null,211,"Shelby"]
[null,null,null,null,null,212,"Sherman"]
["#14","Connectivity to Destinations",null,null,null,213,"Smith"]
[null,false,"Checkbox",null,null,214,"Somervell"]
[null,false,"School",null,null,215,"Starr"]
[null,false,"Park",null,null,216,"Stephens"]
[null,false,"Neighborhood",null,null,217,"Sterling"]
[null,false,"Library",null,null,218,"Stonewall"]
[null,false,"Other school facility",null,null,219,"Sutton"]
[null,false,"Community center",null,null,220,"Swisher"]
[null,false,"High Density Residential",null,null,221,"Tarrant"]
[null,false,"Other special trip generator",null,null,222,"Taylor"]
[null,false,"Commercial center",null,null,223,"Terrell"]
[null,false,"Central Business District",null,null,224,"Terry"]
[null,false,"Major employer",null,null,225,"Throckmorton"]
[null,false,"Fresh foods (grocery stores, farmers mkts)",null,null,226,"Titus"]
[null,false,"Health facility (exercise center, sports field, etc.)",null,null,227,"Tom Green"]
[null,null,null,null,null,228,"Travis"]
[null,{"$f":"COUNTIF(B218:B230,\"TRUE\")","v":0},"Total destinations checkboxes",null,null,229,"Trinity"]
[null,null,null,null,null,230,"Tyler"]
["#15a","Transit Connectivity",null,null,null,231,"Upshur"]
[null,false,"Option",null,null,232,"Upton"]
[null,1,"(select)",null,null,233,"Uvalde"]
[null,2,"No transit connections",null,null,234,"Val Verde"]
[null,3,"Existing",null,null,235,"Van Zandt"]
[null,4,"Planned",null,null,236,"Victoria"]
[null,5,"Existing and planned",null,null,237,"Walker"]
[null,null,2,null,null,238,"Waller"]
[null,null,{"$f":"LOOKUP(C241,B236:B240,C236:C240)","v":"No transit connections"},null,null,239,"Ward"]
[null,null,null,null,null,240,"Washington"]
["#15b","Connecting Bicycle Facilities",null,null,null,241,"Webb"]
[null,null,"Option",null,null,242,"Wharton"]
[null,1,"(select)",null,null,243,"Wheeler"]
[null,2,"No bicycle infrastructure connections",null,null,244,"Wichita"]
[null,3,"Existing",null,null,245,"Wilbarger"]
[null,4,"Planned",null,null,246,"Willacy"]
[null,5,"Existing and planned",null,null,247,"Williamson"]
[null,null,1,null,null,248,"Wilson"]
[null,null,{"$f":"LOOKUP(C251,B246:B250,C246:C250)","v":"(select)"},null,null,249,"Winkler"]
[null,null,null,null,null,250,"Wise"]
["#15b","Connecting Pedestrian Facilities",null,null,null,251,"Wood"]
[null,null,"Option",null,null,252,"Yoakum"]
[null,1,"(select)",null,null,253,"Young"]
[null,2,"No pedestrian infrastructure connections",null,null,254,"Zapata"]
[null,3,"Existing",null,null,255,"Zavala"]
[null,4,"Planned",null,null,256,"Multiple Counties"]
[null,5,"Existing and planned",null,null,null,1]
[null,null,1,null,null,null,{"$f":"LOOKUP(G260,F4:F258,G4:G258)","v":"(select)"}]
[null,null,{"$f":"LOOKUP(C261,B256:B260,C256:C260)","v":"(select)"}]
[]
["#16","Barrier Elimination Totals"]
[null,false,"Option"]
[null,{"$f":"'Pg3'!$E$47","v":0},"ADA barriers"]
[null,{"$f":"'Pg3'!$J$47","v":0},"Four lane or larger roadways"]
[null,{"$f":"'Pg3'!$O$47","v":0},"Waterbody(ies)"]
[null,{"$f":"'Pg3'!$S$47","v":0},"Railroad"]
[null,{"$f":"'Pg3'!$E$49","v":0},"Other"]
[null,{"$f":"SUM(B266:B270)","v":0},"Total barriers eliminated"]
[]
["#17","Long-distance bicycle tourism (ED)"]
[null,null,"Option"]
[null,1,"[Select]"]
[null,2,"Segment of Texas Bicycle Tourism Trails Example Network or locally favored alternative"]
[null,3,"Segment of regional non-motorized route for tourism"]
[null,4,"Segment of contiguous bicycle/pedestrian route connecting regional population centers"]
[null,null,1]
[null,null,{"$f":"LOOKUP(C279,B275:B278,C275:C278)","v":"[Select]"}]
[null,{"$f":"IF(C279=1, \"No\",\"Yes\")","v":"No"},"Bicycle tourism efforts involved?"]
[]
["#21a","In local transpo plan"]
[null,null,"Option"]
[null,1,"(select)"]
[null,2,"Yes"]
[null,3,"No"]
[null,null,1]
[null,null,{"$f":"LOOKUP(C288,B285:B287,C285:C287)","v":"(select)"}]
[]
["#21b","In ADA transition plan?"]
[null,null,"Option"]
[null,1,"(select)"]
[null,2,"Yes"]
[null,3,"No"]
[null,null,1]
[null,null,{"$f":"LOOKUP(C296,B293:B295,C293:C295)","v":"(select)"}]
[]
[]
["#24a","YES or Nos- Prop aqc'd"]
[null,null,"Option"]
[null,1,"(select)"]
[null,2,"Yes"]
[null,3,"No"]
[null,4,"Started"]
[null,5,"In progress"]
[null,6,"N/A"]
[null,null,1]
[null,null,{"$f":"LOOKUP(C308,B302:B307,C302:C307)","v":"(select)"}]
[]
["24b","YES or Nos- known encroachments"]
[null,null,"Option"]
[null,1,"(select)"]
[null,2,"Yes"]
[null,3,"No"]
[null,4,"N/A"]
[null,null,1]
[null,null,{"$f":"LOOKUP(C317,B313:B316,C313:C316)","v":"(select)"}]
[]
["#24c","YES or Nos- property act followed"]
[null,null,"Option"]
[null,1,"(select)"]
[null,2,"Yes"]
[null,3,"No"]
[null,4,"N/A"]
[null,null,1]
[null,null,{"$f":"LOOKUP(C326,B322:B325,C322:C325)","v":"(select)"}]
[]
["#26a","YES or Nos- involves RR ROW"]
[null,null,"Option"]
[null,1,"(select)"]
[null,2,"Yes"]
[null,3,"No"]
[null,null,1]
[null,null,{"$f":"LOOKUP(C334,B331:B333,C331:C333)","v":"(select)"}]
[]
["#26b","YES or Nos- coordination begun?"]
[null,null,"Option"]
[null,1,"(select)"]
[null,2,"Yes"]
[null,3,"No"]
[null,4,"n/a"]
[null,null,1]
[null,null,{"$f":"LOOKUP(C343,B339:B342,C339:C342)","v":"(select)"}]
["#26c","YES or Nos- railbanking?"]
[null,null,"Option"]
[null,1,"(select)"]
[null,2,"Yes"]
[null,3,"No"]
[null,null,1]
[null,null,{"$f":"LOOKUP(C350,B347:B349,C347:C349)","v":"(select)"}]

{"sheet":"Extract_Fields","index":14,"n_rows":5,"n_cols":129,"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","10. Project Location Info - Relation to TxDOT Rd","10. Project Location Info - ON","10. Project Location Info - From","10. Project Location Info - To","11. Project Details - Construction Plans current status","11. Project Details - Construction Plans Percent Complete","11. Project Details - Construction Plans weblink","11. Project Details - Primary Activity","11. Project details - Prim Project Length ","11. Project details - Prim Project Length (ft/miles)","11. Project details - Prim Project Width","11. Project details - Prim Project Depth","11. Project details - Prim Project Surface","11. Project Details - Secondary Activity","11. Project details - Sec Project Length ","11. Project details - Sec Project Length (ft/miles)","11. Project details - Sec Project Width","11. Project details - Sec Project Depth","11. Project details - Sec Project Surface","11. Project details - Lighting","11. Project details - Bridge","11. Project details - Bridge number","12. Safety Hazards- Highspeed","12. Safety Hazards- Haz Conflict pt","12. Safety Hazards- Uncontrolled int","12. Safety Hazards- lack of bp","12. Safety Hazards- High traffic vol","12. Safety Hazards- OnSt parking","12. Safety Hazards- Wide Xing","12. Safety Hazards- Lack of lighting","12. Safety Hazards- PSAP","12. Safety Hazards- Other","12. Safety- B/P Safety Hazards Checked","12. Safety- B/P Countermeasures","13. B/P Safety- Infrastructure1","13. B/P Safety- Infrastructure2","13. B/P Safety- Infrastructure3","13. B/P Safety- Infrastructure4","13. B/P Safety- Infrastructure5","13. B/P Safety- Infrastructure6","13. B/P Safety- Infrastructure6","13. B/P Safety- Infrastructure7","13. B/P Safety- Infrastructure8","13. B/P Safety- Infrastructure9","13. B/P Safety- Infrastructure Total","14. Connectivity to Destinations","15A. Connectivity to transit","15B. Bicycle infrastructure connectivity","15C. Pedestrian infrastructure connectivity","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. LongDistance BikeTourism","17. LongDistance BikeTourism y/n","20A. Public Involvement-A","20A. Public Involvement-B","20B. Maintenance and Operations -Responsible Parties","21A. Local Plans","21A. Local Plans","21B. ADA Transition Plan","24A. Property Ownership - Property already acquired","24B. Property Ownership - Encroachments","24C. Property Ownership - Property Act followed for acquisition?","26A. Railroad - encroach or cross RR ROW?","26B. Railroad - Coordination begun?","26C. Railroad - Railbanked ROW?","27. Projected Time Estimate - Project Initiation","27. Projected Time Estimate - Procurement","27. Projected Time Estimate - Project Design and Plan of PS&E","27. Projected Time Estimate - Env. Clearance","27. Projected Time Estimate - ROW Acquisition","27. Projected Time Estimate - RRD Coord","27. Projected Time Estimate - Utility Coord","27. Projected Time Estimate - Other (months)","27. Projected Time Estimate - Other Text","27. Total Projected Time Estimate","27. Projected Time Estimate - Project Construction / Implimentation","28. Assumed Construction Year","28. Itemized Construction Cost Estimate - Line 1","28. Additional Contruction Related Costs - Line 2","29. Project Design (PS&E & Env) Costs","Project Design Eligibility?","Construction Cost Estimate (Line 3)","Contingency Costs","Inflation Adjustment","TxDOT Direct State Costs for project oversight (Line 4)","Local Match Percentage","Optional TxDOT Match Percentage","Total Project Estimate (Line 5)","Possible transfer to FTA","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","Relation to Rdway","Roadway","From","To","Construction Plans status","Plan%_Complete","PlansWeblink","ProjActivity_Prim","ProjLength_Prim","LengthUnit_Prim","ProjWidth_Prim","ProjDepth_Prim","ProjSurface_Prim","ProjActivity_Sec","S Project Length","LengthUnit_Sec","ProjWidth_Sec","ProjDepth_Sec","ProjSurface_Sec","Lighting?","Bridge?","No_of_Bridges","HighSpeed","Int/conflict pt","Uncontrolled Int","Lack of BP infra","High traffic vol","On st parking","Wide Xing","Lack of lighting","PSAP ","Other","SafetyHazardsChkd#","Countermeasures","closes_gap_bike_ped_network","features_new_traffic_signalization","features_new_traffic_calming_elements","separates_bicycles_and_or_pedestrians","facility_offset_five_feet","features_safety_lighting","features_traffic_marking_signage","improves_railroad_highway_water_crossing","new_bicycle_pedestrian_infrastructure","includes_vertical_separation_element","Infra#Checks","TAConnectivity#","TransitConnectivity","Connect to bike infra","Connect to ped infra","ADA Barriers Eliminated","WideRd Barriers Eliminated","Water Barriers Eliminated","Rail Barriers Eliminated","Other Barriers Eliminated","Otherbarriers_text","BikeTourismType","BikeTourism y/n","PartnersA","PartnersB","MNT_Parties","Local Plan?","Plan link","ADA Plan?","Property Acquired?","Encroachments?","Property Act?","Involve RR ROW?","RRDCoordination?","Railbanked ROW?","Timeline_ProjInitiation","Timeline_Procurement","Timeline_Design","Timeline_Env.Clear","Timeline_ROWAcq","Timeline_RRCoord","Timeline_UtilityCoord","Timeline_Other","OtherText","Timeline_TotalProject","Timeline_ProjConstruction","CSTYear","Itemized Construction Costs","OtherCST Costs","Proj Design costs","PE Costs?","TA Const Costs","ContingencyCosts","InflationAdj","Dir State Costs","Local Match Percent","Txdotmatch","Total Project Cost","FTA transfer?","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","Text","Text","Text","Dropdown","integer","Text","Dropdown","Decimal number","Dropdown","Integer","Integer","Dropdown","Dropdown","Decimal number","Dropdown","Integer","Integer","Dropdown","Dropdown","Dropdown","Integer","True/False","True/False","True/False","True/False","True/False","True/False","True/False","True/False","True/False","True/False","Integer","Text","True/False","True/False","True/False","True/False","True/False","True/False","True/False","True/False","True/False","True/False","Integer","Integer","Dropdown","Dropdown","Dropdown","Integer","Integer","Integer","Integer","Integer","Text","Dropdown","Dropdown","Text","Text","Text","Dropdown","Text","Dropdown","Dropdown","Dropdown","Dropdown","Dropdown","Dropdown","Dropdown","Integer","Integer","Integer","Integer","Integer","Integer","Integer","Integer","Integer","Integer","Integer","dropdown","Real number","Real number","Real number","Text","Real number","Real number","Real number","Real number","Real number","Real number","Real number","True/False","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_LS_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'!$I$20","v":0},{"$f":"'Pg1'!I22","v":0},{"$f":"'Pg1'!$I$24","v":0},{"$f":"'Pg1'!$I$26","v":0},{"$f":"'Pg1'!$I$28","v":0},{"$f":"'Pg1'!$Q$20","v":0},{"$f":"'Pg1'!$Q$22","v":0},{"$f":"'Pg1'!$Q$24","v":0},{"$f":"'Pg1'!$Q$26","v":0},{"$f":"'Pg1'!Q28","v":0},{"$f":"'Pg1'!N30","v":0},{"$f":"'Pg1'!$I$34","v":0},{"$f":"'Pg1'!$D$37","v":0},{"$f":"dropdowns!$G$261","v":"(select)"},{"$f":"dropdowns!$J$32","v":"(select)"},{"$f":"dropdowns!$C$23","v":"(select)"},{"$f":"dropdowns!$M$29","v":"(select)"},{"$f":"dropdowns!$C$31","v":"(select)"},{"$f":"dropdowns!C43","v":"(select)"},{"$f":"'Pg2'!E6","v":0},{"$f":"dropdowns!$C$62","v":"(select)"},{"$f":"'Pg2'!H11","v":0},{"$f":"'Pg2'!M11","v":0},{"$f":"'Pg2'!M13","v":0},{"$f":"dropdowns!C71","v":"(select)"},{"$f":"'Pg2'!$P$25","v":0},{"$f":"'Pg2'!$J$23","v":0},{"$f":"dropdowns!$C$84","v":"(select)"},{"$f":"'Pg2'!$H$30","v":0},{"$f":"dropdowns!C102","v":"(select)"},{"$f":"'Pg2'!$H$32","v":0},{"$f":"'Pg2'!$H$34","v":0},{"$f":"dropdowns!$C$94","v":"(select)"},{"$f":"dropdowns!$C$116","v":"(select)"},{"$f":"'Pg2'!$N$30","v":0},{"$f":"dropdowns!$C$136","v":"(select)"},{"$f":"'Pg2'!$N$32","v":0},{"$f":"'Pg2'!$N$34","v":0},{"$f":"dropdowns!$C$127","v":"(select)"},{"$f":"dropdowns!C145","v":"(select)"},{"$f":"dropdowns!$C$155","v":"(select)"},{"$f":"'Pg2'!$R$40","v":0},{"$f":"dropdowns!B190","v":false},{"$f":"dropdowns!B191","v":false},{"$f":"dropdowns!B192","v":false},{"$f":"dropdowns!B193","v":false},{"$f":"dropdowns!B194","v":false},{"$f":"dropdowns!B195","v":false},{"$f":"dropdowns!B196","v":false},{"$f":"dropdowns!B197","v":false},{"$f":"dropdowns!B198","v":false},{"$f":"dropdowns!B199","v":false},{"$f":"dropdowns!$B$200","v":0},{"$f":"CONCATENATE(\"(1)\",'Pg2'!L52,\"(2)\",'Pg2'!L54,\"(3)\",'Pg2'!L56,\"(4)\",'Pg2'!L58,\"(5)\",'Pg2'!L60,\"(6)\",'Pg2'!L62,\"(7)\",'Pg2'!L64,\"(8)\",'Pg2'!L66,\"(9)\",'Pg2'!L68,\"(10)\",'Pg2'!L71)","v":"(1)Countermeasure…(2)Countermeasure…(3)Countermeasure…(4)Countermeasure…(5)Countermeasure…(6)Countermeasure…(7)Countermeasure…(8)Countermeasure…(9)Countermeasure…(10)Countermeasure…"},{"$f":"dropdowns!B204","v":false},{"$f":"dropdowns!B209","v":false},{"$f":"dropdowns!B211","v":false},{"$f":"dropdowns!B205","v":false},{"$f":"dropdowns!B212","v":false},{"$f":"dropdowns!B213","v":false},{"$f":"dropdowns!B208","v":false},{"$f":"dropdowns!B207","v":false},{"$f":"dropdowns!B210","v":false},{"$f":"dropdowns!B206","v":false},{"$f":"dropdowns!$B$214","v":0},{"$f":"dropdowns!$B$232","v":0},{"$f":"dropdowns!$C$242","v":"No transit connections"},{"$f":"dropdowns!$C$252","v":"(select)"},{"$f":"dropdowns!$C$262","v":"(select)"},{"$f":"'Pg3'!$E$47","v":0},{"$f":"'Pg3'!$J$47","v":0},{"$f":"'Pg3'!$O$47","v":0},{"$f":"'Pg3'!$S$47","v":0},{"$f":"'Pg3'!$E$49","v":0},{"$f":"'Pg3'!$I$49","v":0},{"$f":"dropdowns!C280","v":"[Select]"},{"$f":"dropdowns!B281","v":"No"},{"$f":"'Pg4'!$F$35","v":0},{"$f":"'Pg4'!F37","v":0},{"$f":"'Pg4'!E42","v":0},{"$f":"dropdowns!C289","v":"(select)"},{"$f":"'Pg4'!K50","v":0},{"$f":"dropdowns!$C$297","v":"(select)"},{"$f":"dropdowns!$C$309","v":"(select)"},{"$f":"dropdowns!C318","v":"(select)"},{"$f":"dropdowns!C327","v":"(select)"},{"$f":"dropdowns!C335","v":"(select)"},{"$f":"dropdowns!C344","v":"(select)"},{"$f":"dropdowns!C351","v":"(select)"},{"$f":"'Pg6'!E14","v":0},{"$f":"'Pg6'!E19","v":0},{"$f":"'Pg6'!E23","v":0},{"$f":"'Pg6'!E28","v":0},{"$f":"'Pg6'!E33","v":0},{"$f":"'Pg6'!E36","v":0},{"$f":"'Pg6'!E39","v":0},{"$f":"'Pg6'!E41","v":0},{"$f":"'Pg6'!L41","v":0},{"$f":"'Pg6'!E45","v":0},{"$f":"'Pg6'!E49","v":0},{"$f":"dropdowns!U23","v":"(select)"},{"$f":"Budget3!Q56","v":0},{"$f":"Budget4!$R$27","v":0},{"$f":"Budget4!$R$56","v":0},{"$f":"Budget4!O33","v":"PE Costs are Eligible"},{"$f":"BudgetSummary!$R$16","v":0},{"$f":"BudgetSummary!R10","v":0},{"$f":"BudgetSummary!R12","v":0},{"$f":"BudgetSummary!$R$18","v":0},{"$f":"BudgetSummary!$M$24","v":0.2},{"$f":"BudgetSummary!M26","v":0},{"$f":"BudgetSummary!$R$22","v":0},{"$f":"dropdowns!Q127","v":"(select)"},{"$f":"dropdowns!$T$1","v":false},{"$f":"dropdowns!Q118","v":"(select)"},{"$f":"SignaturePage!P4","v":0},{"$f":"SignaturePage!$N$4","v":0.8},{"$f":"SignaturePage!P6","v":0},{"$f":"SignaturePage!N6","v":0},{"$f":"SignaturePage!P8","v":0},{"$f":"SignaturePage!$N$8","v":0.2}]