The Non-Federal Aid Summaries interface provides options to import, edit, export, and recalculate non-federal aid summary data. 

Location

The Non-Federal Aid interface () can be located by selecting the Submittals tab and navigating to the second section-- Summary Files. The Non-Federal Aid interface is the second/last icon in this section and the fifth on the Submittals menu. 

Summarized AADTs

If the user wishes to edit the Rural Local AADT, Rural Minor Collector AADT, and Small Urban Local AADT values, they can click the corresponding textboxes located in the Summarized AADTs section, edit the value, then click the “Save Changes” button.

Populate 

The user can populate the Non-Federal Aid Summaries table using one of these methods: importing a file or recalculating the data.

Import a File

To import a non-federal aid summary file, follow these steps:

1. Click the "Choose File" button at the bottom left of the interface.
2. Select a file to import.
   • To import the file, it must have the following header columns: BeginDate, StateID, FSystem, UrbanID, VMT, and Comments.
3. After selecting the desired file, click the "Open" button.

Recalculate Data

To recalculate the data, follow these steps:

1. Select a data table in the "Data Table" picklist.
   • The recalculate process uses the data table to retrieve routes that classify as rural minor collectors and local roads for each urbanized area and rural areas.
2. Click the "Recalculate" button.
3. If the new values are sufficient, click the "Save Changes" button to save the new values.

Edit

The first column in the interface table-- Override-- is available to initiate the editing process for the desired record. To fully edit a record, follow these steps:

1. Select the checkbox in the "Override" column for the desired record or click on a record that has been previously overridden.
2. Once selected, a textbox will appear in the Local VMT and Comments columns to allow edits.
3. After entering the desired changes, click the "Save Changes" button.

Overridden records will not be recalculated or be overridden by the import process.

Export

To export the non-federal aid summary table, the user can click the “Export to Pipe Delimited File” link located at the bottom right of the interface. The file will be in a text file in pipe delimited format and will contain the following headers: BeginDate, StateID, FSystem, UrbanID, VMT, and Comments.