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 2021 Redistribution after August 1, 2021 (August Redistribution) | ||
Classification Code | Date | Office of Primary Interest |
N 4520.270 | July 1, 2021 | HCFB-10 |
Best for printing: n4520270.pdf (310 KB)
To view PDF files, you can use the Acrobat® Reader®.
N4520.270 - Attachment 2B - Formulas
Attachment 2B
HQ Program Office/Other Federal Agency
U.S. DEPARTMENT OF TRANSPORTATION
FEDERAL HIGHWAY ADMINISTRATION
FISCAL YEAR (FY) 2021 REDISTRIBUTION AFTER AUGUST 1, 2021
HQ Program Office or Other Federal Agency's Report to HCFB-10 on FY 2021 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. 28, 2021 |
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.