United States Department of Transportation - Federal Highway Administrationskip to content FHWA Home Feedback

Best for printing: n4520203.pdf (182 KB)

To view PDF files, you can use the Acrobat® Reader®.

N4520.203 - Attachment 2 - Formulas


U.S. DEPARTMENT OF TRANSPORTATION
FEDERAL HIGHWAY ADMINISTRATION

FISCAL YEAR (FY) 2009 REDISTRIBUTION AFTER AUGUST 1, 2009
Report to HCFB-1 on FY 2009 Obligation Limitation Distributed in Support of Non-Formula (Allocated) Funds

Name of State, HQ Program Office, or other Federal Agency: ________________________________________

A B C D E F G H
1 Name of Non-Formula
(Allocated) Program
(Appropriations Code)
FMIS Program Code
(if applicable)
Fiscal Year of the
Non-Formula
(Allocated) 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, 2009
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


FHWA Home | Directives | Feedback
FHWA
United States Department of Transportation - Federal Highway Administration