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 2019 Redistribution after August 1, 2019 (August Redistribution) |
||
| Classification Code | Date | Office of Primary Interest |
| N 4520.260 | July 10, 2019 | HCFB-10 |
Best for printing: n4520260.pdf (483 KB)
To view PDF files, you can use the Acrobat® Reader®.
N4520.260 - Attachment 2B - Formulas
Attachment 2B
HQ Program Office/Other Federal Agency
U.S. DEPARTMENT OF TRANSPORTATION
FEDERAL HIGHWAY ADMINISTRATION
FISCAL YEAR (FY) 2019 REDISTRIBUTION AFTER AUGUST 1, 2019
HQ Program Office or Other Federal Agency's Report to HCFB-10 on FY 2019Obligation 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. 26, 2019 |
Non-Formula Obligation Limitation Released for Redistribution Among Other States |
| 2 | =IF(F14>G14,F14-G14,0) | ||||||
| 3 | =IF(F15>G15,F15-G15,0) | ||||||
| 4 | =IF(F16>G16,F16-G16,0) | ||||||
| 5 | =IF(F17>G17,F17-G17,0) | ||||||
| 6 | =IF(F18>G18,F18-G18,0) | ||||||
| 7 | =IF(F19>G19,F19-G19,0) | ||||||
| 8 | =IF(F20>G20,F20-G20,0) | ||||||
| 9 | =IF(F21>G21,F21-G21,0) | ||||||
| 10 | =IF(F22>G22,F22-G22,0) | ||||||
| 11 | =IF(F23>G23,F23-G23,0) | ||||||
| 12 | =IF(F24>G24,F24-G24,0) | ||||||
| 13 | =IF(F25>G25,F25-G25,0) | ||||||
| 14 | =IF(F26>G26,F26-G26,0) | ||||||
| 15 | =IF(F27>G27,F27-G27,0) | ||||||
| 16 | =IF(F28>G28,F28-G28,0) | ||||||
| 17 | =IF(F29>G29,F29-G29,0) | ||||||
| 18 | =IF(F30>G30,F30-G30,0) | ||||||
| 19 | =IF(F31>G31,F31-G31,0) | ||||||
| 20 | =IF(F32>G32,F32-G32,0) | ||||||
| 21 | =IF(F33>G33,F33-G33,0) | ||||||
| 22 | =IF(F34>G34,F34-G34,0) | ||||||
| 23 | =IF(F35>G35,F35-G35,0) | ||||||
| 24 | =IF(F36>G36,F36-G36,0) | ||||||
| 25 | =IF(F37>G37,F37-G37,0) | ||||||
| 26 | =IF(F38>G38,F38-G38,0) | ||||||
| 27 | =IF(F39>G39,F39-G39,0) | ||||||
| 28 | =IF(F40>G40,F40-G40,0) | ||||||
| 29 | =IF(F41>G41,F41-G41,0) | ||||||
| 30 | =IF(F42>G42,F42-G42,0) | ||||||
| 31 | =IF(F43>G43,F43-G43,0) | ||||||
| 32 | =IF(F44>G44,F44-G44,0) | ||||||
| 33 | TOTALS | ---- | ---- | =SUM(E14:E44) | =SUM(F14:F44) | =SUM(G14:G44) | =SUM(H14:H44) |
* Note: Amounts should be the same.
** Note: Shaded cells contain formulas.
