{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["CRP ","HIP-CRRSA and CRP"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"CRP ","index":0,"n_rows":22,"n_cols":28,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
["HRTPO Carbon Reduction Program (CRP) Tracking Table - Revised as of 12/16/2025"]
[]
["Jurisdiction/Agency","UPC Number","Project Name","Year of Project Selection","In Current\nFY 2024-2027\nTIP   ","In Current\nFY 2026-2031\nSYIP ","Active\nProject","FY-22 Allocation (Federal Share)","FY-22 Allocation (State Match)","FY-23 Allocation (Federal Share)","FY-23 Allocation (State Match)","FY-24 Allocation (Federal Share)","FY-24 Allocation (State Match)","FY-25 Allocation (Federal Share)","FY-25 Allocation (State Match)","FY-26 Allocation (Federal Share)","FY-26 Allocation (State Match)","FY-27 Allocation (Federal Share)","FY-27 Allocation (State Match)","FY-28 Allocation (Federal Share)","FY-28 Allocation (State Match)","FY-29 Allocation (Federal Share)","FY-29 Allocation (State Match)","FY-30 Allocation (Federal Share)","FY-30 Allocation (State Match)","FY-31 Allocation (Federal Share)","FY-31 Allocation (State Match)","Total CRP Allocations"]
["HRT","T22709","Victoria Bouelvard Facility Upgrades - Phase 2",2024,"Yes","Yes","Yes",null,null,null,null,80000,20000,717680,179420,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H5:AA5)","v":997100}]
["James City County",102980,"US Route 60 (Pocahontas Trail) Widening and Complete Street ",2023,"Yes","Yes","Yes",{"$f":"800000-800000","v":0},{"$f":"200000-200000","v":0},800000,200000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H6:AA6)","v":1000000}]
["James City County",115512,"Longhill Road Shared Use Path - Phase 2",2024,"Yes","Yes","Yes",null,null,400000,100000,712000,178000,null,null,329483,82371,null,null,null,null,null,null,null,null,null,null,1801854]
["Newport News",109076,"Amtrak Multimodal Station - Station, Platform, Parking Lot (child project of UPC 102734)",2023,"Yes","Yes","Closing",1765754,441439,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2207193]
["Newport News",121108,"Trail 757 Multi-Use Path - Yorktown Road to Newport News Park",2024,"Yes","Yes","Yes",800000,200000,{"$f":"400000","v":400000},{"$f":"100000","v":100000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1500000]
["Norfolk",113866,"Emergency Vehicle Preemption",2023,"Yes","Yes","Closing",80000,20000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,100000]
["Norfolk",125975,"Signal System Upgrade for Incident Management ",2024,"Yes","Yes","Yes",null,null,null,null,596446,149112,800000,200000,800000,200000,null,null,null,null,null,null,null,null,null,null,2745558]
["Port of Virginia ",103928,"Green Operator - Near Zero Emission Trucks",2023,"Yes","Yes","Yes",382626,95657,2240377,560094,800000,200000,513901,128475,{"$f":"1086099-279654","v":806445},{"$f":"271525-69914","v":201611},null,null,null,null,null,null,null,null,null,null,5929186]
["Virginia Beach",110802,"Dam Neck Road/Holland Road Intersection Improvements",2023,"Yes","Yes","Yes",520000,130000,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,650000]
["Virginia Beach",125974,"Pacific Avenue at 17th Street and 22nd Street Improvements",2024,"Yes","Yes","Yes",null,null,null,null,800000,200000,800000,200000,800000,200000,null,null,null,null,null,null,null,null,null,null,3000000]
["WATA",127832,"Electric/Hybrid Expansion Support Vehicle",2024,"Yes","Yes","Yes",null,null,null,null,88000,22000]
[]
["Total",null,null,null,null,null,null,{"$f":"SUM(H5:H14)","v":3548380},{"$f":"SUM(I5:I14)","v":887096},{"$f":"SUM(J5:J14)","v":3840377},{"$f":"SUM(K5:K14)","v":960094},{"$f":"SUM(L5:L15)","v":3076446},{"$f":"SUM(M5:M15)","v":769112},{"$f":"SUM(N5:N14)","v":2831581},707895,2735928,683982,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(H17:AA17)","v":20040891}]
[]
["HRTPO CRP Reserve Account","T27909","HRTPO CRP Reserve Account (VDOT's Balance Entry)",null,null,null,null,{"$f":"800000-800000","v":0},{"$f":"200000-200000","v":0},{"$f":"800000-400000-400000","v":0},{"$f":"200000-100000-100000","v":0},{"$f":"800000-88000-712000","v":0},{"$f":"200000-22000-178000","v":0},0,0,0,0,{"$f":"3075894-180363","v":2895531},{"$f":"768974-45091","v":723883},{"$f":"3137412-183970","v":2953442},{"$f":"784353-45993","v":738360},{"$f":"3200160-187650","v":3012510},{"$f":"800040-46912","v":753128},{"$f":"3264163-191402","v":3072761},{"$f":"816041-47851","v":768190},3134216,783554,{"$f":"SUM(H19:AA19)","v":18835575}]
[]
["State CRP funds on UPC 123832 (below) - not tracked by the HRTPO"]
["York County",123832,"I-64 Gap Widening - Segment C - Park and Ride",2024,"Yes","Yes","Yes",2020713,505178]

{"sheet":"HIP-CRRSA and CRP","index":1,"n_rows":31,"n_cols":5,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
[]
[]
["Receive HIP-CRRSA (even RSTP swap)","FY 2022","Transfer UPC T16054 to UPC 111036",2000000,"HIP-CRRSA funds transferred on 1/26/2024 through even swaps with out-year RSTP funds.  HIP-CRRSA funds were to be rescinded if not obligated by 5/31/2023 - VDOT CO made the transfers on 5/31/2023 with projects that could obligate the HIP-CRRSA funds immediately.  \nTPO Amendment on 3/21/2024 to do transfer"]
["Transfer RSTP even swap with HIP-CRRSA","FY 2023","From UPC 111036 to UPC T16054","$40,000, plus $10,000 RSTP match","HIP-CRRSA funds transferred on 1/26/2024 through even swaps with out-year RSTP funds.  HIP-CRRSA funds were to be rescinded if not obligated by 5/31/2023 - VDOT CO made the transfers on 5/31/2023 with projects that could obligate the HIP-CRRSA funds immediately.  \nTPO Amendment on 3/21/2024 to do transfer"]
["Transfer RSTP even swap with HIP-CRRSA","FY 2024","From UPC 111036 to UPC T16054","$1,560,000, plus $390,000 RSTP match","HIP-CRRSA funds transferred on 1/26/2024 through even swaps with out-year RSTP funds.  HIP-CRRSA funds were to be rescinded if not obligated by 5/31/2023 - VDOT CO made the transfers on 5/31/2023 with projects that could obligate the HIP-CRRSA funds immediately.  \nTPO Amendment on 3/21/2024 to do transfer"]
[]
["Transfer RSTP even swap with HIP-CRRSA","FY 2025","From UPC 69050 to UPC T16054","$782,030, plus $195,508 RSTP match","HIP-CRRSA funds transferred on 1/26/2024 through even swaps with out-year RSTP funds.  HIP-CRRSA funds were to be rescinded if not obligated by 5/31/2023 - VDOT CO made the transfers on 5/31/2023 with projects that could obligate the HIP-CRRSA funds immediately.  \nTPO Amendment on 3/21/2024 to do transfer"]
["Transfer RSTP even swap with HIP-CRRSA","FY 2022","UPC 69050 - receive from UPC T16054","HIP-CRRSA $977,538","HIP-CRRSA funds transferred on 1/26/2024 through even swaps with out-year RSTP funds.  HIP-CRRSA funds were to be rescinded if not obligated by 5/31/2023 - VDOT CO made the transfers on 5/31/2023 with projects that could obligate the HIP-CRRSA funds immediately.  \nTPO Amendment on 3/21/2024 to do transfer"]
[]
["HIP-CRRSA Allocation in Reserve","FY 2022",null,220759,"$220,759 transferred to UPC 69050 - VDOT stated these funds in the reserve after the original HIP-CRRSA funds allocated in 2021.  TPO staff was unaware of this.  Funds now transferred to UPC 69050 and swapping RSTP Reserve funds - 1/18/2024 TIP Amendment."]
["HIP-CRRSA Allocation","FY 2022","PO 107035",1584234,"$1,034,234 transferred to UPC 69050\n$550,000 obligated immediately by UPC 107035"]
["HIP-CRRSA Allocation","FY 2022","GL 110627",1000000,"Obligated immediately UPC 110627"]
["HIP-CRRSA Allocation","FY 2022","JC 102980",2619574,"$914,044 transferred to UPC 69050\n$1,560,530 transferred to UPC 112318\n$145,000 obligated immediately by UPC 102980"]
["HIP-CRRSA Allocation","FY 2022","HRT T16054",2977538,"$2,000,000 transferred to UPC 111036\n$977,538 transferred to UPC 69050"]
["HIP-CRRSA Allocation","FY 2022","VB 112317",1901573,"$1,501,573 transferred to UPC 69050\n$400,000 obligated immediately by UPC 112317"]
["HIP-CRRSA Allocation","FY 2022","CH 115423",1000000,"$1,000,000 transferred to UPC 69050 - VDOT had this in the reserve and transferred to UPC 115423 in 9/2021; however, it was an allocation to 115423 from the start as the original allocation."]
[null,null,null,{"$f":"SUM(D10:D16)","v":11303678},11303678]
[]
["HIP >200K (CRRSA) Allocation","FY 2022","VB 112317",2035514,"Per VDOT this into CRRSA only HIP - already corrected with new TIP data in FY 2024-2027"]
[]
[]
[]
[]
["July 20, 2023 Approval"]
["CRP Allocation","FY 2022","JC 102980",1000000]
["CRP Allocation","FY 2023","JC 102980",1000000]
["CRP Allocation","FY 2022","POV 103928",478283]
["CRP Allocation","FY 2023","POV 103928",2800471]
["CRP Allocation","FY 2022","NN 109076",2207193]
["CRP Allocation","FY 2022","VB 110802",650000]
["CRP Allocation","FY 2022","NO 113866",100000]