Overview

This page provides step by step instructions for using the IND-GEN offline Excel feature to complete the IND-GEN form on your Annual Performance Review. Any program with IND-GEN forms can download an Excel file with data already entered in the form, edit or add new data, and upload the file back into the APR to process the data. 

Main Home Page

From the main home page:

A: Select Tasks from the top navigation bar

B: Select Submission from the Drop down menu.

This allows you to view your Annual Performance Reviews (APR).

Screenshot of Homepage navigation

From this screen, find the report that you want to work on, go to the right side of the screen under options and find the option of your report.

Screenshot of Performance Report Selection

Select the down arrow dropdown and select Performance Report .

A new window appears that leads you to the Performance Reports – Status Overview Page.

Screenshot of Status Overview Page

Before the INDGEN form can be accessed, the Grant Purpose Form, located on the left side of the screen, must be completed.

Select Grant Purpose from the left navigation menu.

Grant Purpose – Setup

From the Grant Purpose – Setup screen, select the Grant Purposes that apply to the Grant.

Screenshot of Grant Purpose Form - Save

After selecting all that apply, click the Save and Validate button at the bottom right of the screen.

You are taken to the Training Program – Set up Page, where a Success Message is displayed at the top of the screen, confirming the information saved successfully on the previous page.

Success Message

NOTE: Depending on the grant that you selected, you may need to fill out a Training Program form, which is located under the Grant Purposes form you just filled out.

If this is the case, Select the required fields of Type of Program Type Offered from the drop-down menu.

You have the option to Add a Record to this Training Program, but it is not required. To do so, select the Add Record button and upload your file.

If you choose to delete the file after adding it, select Delete under the Options column on the right side of the screen. 

Screenshot of Add Record Button

When you are done, select Save and Validate at the bottom right of the screen.


Screenshot of Save and Validate

IND-GEN: Individual Characteristics Page

You now navigate to the IND-GEN: Individual Characteristics Page.

Screenshot of Individual Characteristics Page

Here, answer the required question, as pointed out by the asterisk.

If you select No, click Save and Validate at the bottom right of the screen.

If you select Yes, you are taken to the form to complete.

Follow the "Notes" at the top of the page for instructions.

screen shot of Notes section

Click the Generate Template with the most recent IND-GEN Data. During this time, the Download Template button is disabled.

Screenshot of Generate Template

NOTE: You receive an email when the template is generated and ready to download. 

HELPFUL TIP: While waiting for the email, you can work on other forms, switch around, and return to this page when the template is ready.

The Download Template button is disabled when a template generation is in progress. It remains enabled at all other times. and iIf there is a change to the setup forms or if new data was added directly to the IND-GEN form below, generate a new template and download the template to get the latest changes in the Excel download.

You receive an email when the template is ready for download.

A Success message lets you know the template generation has successfully started.

The Download Template button is now enabled.

Click Download Template.

Screenshot of Download Template

NOTE: This downloads an Excel to your local drive. This allows you to work offline and upload your most up-to-date information back into the system. 

Important Note: Make sure the downloaded template is saved to your C Drive (Local Disk)

IND-GEN Excel Spreadsheet

Opening the Template, you see advisory messages about the spreadsheet’s status, signatures, and save status. Click Edit, Enable, and View if you wish to continue.  

Screenshot of Advisory Messages

Continue to the second tab of the spreadsheet to enter data.

Screenshot of Excel Second Tab

Enter your information in the columns. 

Screenshot of Excel Data Entry

NOTE: Not all Columns are required to save.

Uploading Excel Spreadsheet

Back to the browser and APR, there is an option to Attach File on the right side of the screen.

Screenshot of Attach File button

Click Attach File.

Important Note: Only one spreadsheet can be uploaded at a time.

A section appears to Choose File for upload.

A description window is given and is not required.

Screenshot of Choose File and Upload Window

When ready, click Upload to upload your Excel Spreadsheet.

When the spreadsheet is loaded, click Process Data.

Screenshot of Process Data Button

A Success Banner appears at the top of the screen, and the system autofills the data into the table on the APR.

Screenshot of Success Message

NOTE: If you wish to work offline once again, click Generate Template again to get the most up-to-date data and spreadsheet.

Notes/pop ups have been added to each option to inform you to get the most up-to-date information.

When you are done adding information, click Save and Validate at the bottom right of the screen.

Screenshot of Save and validate