U.S. Department of Transportation
Federal Highway Administration
1200 New Jersey Avenue, SE
Washington, DC 20590
202-366-4000


Skip to content
Facebook iconYouTube iconTwitter iconFlickr iconLinkedInInstagram

Home / Resources / Legislation, Regulations and Guidance / Directives and Memorandum / Notices / N 4520.254 / Attachment 1

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.

 

Page posted on July 5, 2018
Federal Highway Administration | 1200 New Jersey Avenue, SE | Washington, DC 20590 | 202-366-4000