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 2018 Redistribution after August 1, 2018 (August Redistribution) |
||
Classification Code | Date | Office of Primary Interest |
N 4520.254 | July 5, 2018 | HCFB-10 |
Best for printing: n4520254.pdf (483 KB)
To view PDF files, you can use the Acrobat® Reader®.
N4520.254 - Attachment 2B - Formulas
Attachment 2B
HQ Program Office/Other Federal Agency
U.S. DEPARTMENT OF TRANSPORTATION
FEDERAL HIGHWAY ADMINISTRATION
FISCAL YEAR (FY) 2018 REDISTRIBUTION AFTER AUGUST 1, 2018
HQ Program Office or Other Federal Agency's Report to HCFB-10 on FY 2018 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 Could be Obligated by Sept. 25, 2018 |
Non-Formula Obligation Limitation Released for Redistribution Among Other States |
2 | =IF(F2>G2,F2-G2,0) | ||||||
3 | =IF(F3>G3,F3-G3,0) | ||||||
4 | =IF(F4>G4,F4-G4,0) | ||||||
5 | =IF(F5>G5,F5-G5,0) | ||||||
6 | =IF(F6>G6,F6-G6,0) | ||||||
7 | =IF(F7>G7,F7-G7,0) | ||||||
8 | =IF(F8>G8,F8-G8,0) | ||||||
9 | =IF(F9>G9,F9-G9,0) | ||||||
10 | =IF(F10>G10,F10-G10,0) | ||||||
11 | =IF(F11>G11,F11-G11,0) | ||||||
12 | =IF(F12>G12,F12-G12,0) | ||||||
13 | =IF(F13>G13,F13-G13,0) | ||||||
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 | TOTALS | ---- | ---- | =SUM(E2:E20) | =SUM(F2:F20) | =SUM(G2:G20) | =SUM(H2:H20) |
* Note: Amounts should be the same.
** Note: Shaded cells contain formulas.