U.S. Department of Transportation
Federal Highway Administration
1200 New Jersey Avenue, SE
Washington, DC 20590
202-366-4000
Notice | ||
Subject | ||
FEDERAL-AID HIGHWAY PROGRAM OBLIGATION LIMITATION — FISCAL YEAR 2022 REDISTRIBUTION AFTER AUGUST 1, 2022 (AUGUST REDISTRIBUTION) |
||
Classification Code N 4520.275 |
Date June 30, 2022 |
Office of Primary Interest HCFB-10 |
Best for printing: n4520275.pdf (567 KB)
To view PDF files, you can use the Acrobat® Reader®.
N4520.275 - Attachment 2B - Formulas
Attachment 2B
HQ Program Office/Other Federal Agency
U.S. DEPARTMENT OF TRANSPORTATION
FEDERAL HIGHWAY ADMINISTRATION
FISCAL YEAR (FY) 2022 REDISTRIBUTION AFTER AUGUST 1, 2022
HQ Program Office or Other Federal Agency's Report to HCFB-10 on FY 2022 Obligation Limitation Distributed
in Support of Non-Formula (Allocated) Funds by Delphi Fund Value and BPAC
Name of HQ Program Office or Other Federal Agency:________________________________________
A | B | C | D | E | F | G | H |
---|---|---|---|---|---|---|---|
1 | Name of Non-Formula Program (Appropriations Code) | Delphi Accounting String (Fund Value and BPAC) |
Fiscal Year of the Non-Formula Funds | Unobligated Balance of Non-Formula Funds * | Unobligated Balance of Obligation Limitation Distributed to Support the Non-Formula Funds * | Amount of Non-Formula Obligation Limitation that Will be Obligated by Sept. 27, 2022 |
Non-Formula Obligation Limitation Released for Redistribution Among Other States |
14 | =IF(F14>G14,F14-G14,0) | ||||||
15 | =IF(F15>G15,F15-G15,0) | ||||||
16 | =IF(F16>G16,F16-G16,0) | ||||||
17 | =IF(F17>G17,F17-G17,0) | ||||||
18 | =IF(F18>G18,F18-G18,0) | ||||||
19 | =IF(F19>G19,F19-G19,0) | ||||||
20 | =IF(F20>G20,F20-G20,0) | ||||||
21 | =IF(F21>G21,F21-G21,0) | ||||||
22 | =IF(F22>G22,F22-G22,0) | ||||||
23 | =IF(F23>G23,F23-G23,0) | ||||||
24 | =IF(F24>G24,F24-G24,0) | ||||||
25 | =IF(F25>G25,F25-G25,0) | ||||||
26 | =IF(F26>G26,F26-G26,0) | ||||||
27 | =IF(F27>G27,F27-G27,0) | ||||||
28 | =IF(F28>G28,F28-G28,0) | ||||||
29 | =IF(F29>G29,F29-G29,0) | ||||||
30 | =IF(F30>G30,F30-G30,0) | ||||||
31 | =IF(F31>G31,F31-G31,0) | ||||||
32 | =IF(F32>G32,F32-G32,0) | ||||||
33 | =IF(F33>G33,F33-G33,0) | ||||||
34 | =IF(F34>G34,F34-G34,0) | ||||||
35 | =IF(F35>G35,F35-G35,0) | ||||||
36 | =IF(F36>G36,F36-G36,0) | ||||||
37 | =IF(F37>G37,F37-G37,0) | ||||||
38 | =IF(F38>G38,F38-G38,0) | ||||||
39 | =IF(F39>G39,F39-G39,0) | ||||||
40 | =IF(F40>G40,F40-G40,0) | ||||||
41 | =IF(F41>G41,F41-G41,0) | ||||||
42 | =IF(F42>G42,F42-G42,0) | ||||||
43 | =IF(F43>G43,F43-G43,0) | ||||||
44 | =IF(F44>G44,F44-G44,0) | ||||||
45 | TOTALS | ---- | ---- | =SUM(E14:E44) | =SUM(F14:F44) | =SUM(G14:G44) | =SUM(H14:H44) |
* Note: Amounts should be the same.
** Note: Shaded cells contain formulas.