Formula Grant IMPACT Tool FAQs

A:

The Indicators* Measurements* Performance* Achievements* Challenges* Technical Assistance Tool (IMPACT tool) is a web-based tool that all OVW grantees and subgrantees will use to prepare their performance data for submission to OVW, beginning with the July – December 2024 (JD 2024) reporting period. It is easy to use and reflects a reduction of about 50% in the volume of data grantees are asked to report. Its purpose is to simplify reporting and alleviate burden on grantees while generating better, timely, and more accurate information on how grantees use their funds.

For more Frequently Asked Questions please see the IMPACT Tool FAQs for Discretionary Grantees or and IMPACT Tool FAQs for Formula State Administrators

A:

State Administrators: VAWA MEI will reach out to Formula State Administrators and request information about who should have access to their State Dashboard in the tool. VAWA MEI will create the needed accounts and work with State Administrators to ensure everyone who needs access gets access.

Subgrantees: State Administrators will send their Subgrantees an email containing a URL that will bring them to a blank report. Once the Subgrantee starts a report, a new, unique URL will be generated which will be emailed to them and will also be available to copy from the site itself. They will need to save this unique URL so that you can return to your report.

For more Frequently Asked Questions please see the IMPACT Tool FAQs for Formula State Administrators

A:

The Indicators* Measurements* Performance* Achievements* Challenges* Technical Assistance Tool (IMPACT tool) is a web-based tool that all OVW grantees will use to prepare their performance data for submission to OVW, beginning with the July – December 2024 (JD 2024) reporting period. It is easy to use and reflects a reduction of about 50% in the volume of data grantees are asked to report. Its purpose is to simplify reporting and alleviate burden on grantees while generating better, timely, and more accurate information on how grantees use their funds.

For more Frequently Asked Questions please see the IMPACT Tool FAQs for Discretionary Grantees

A:

There is not currently a way to download pdf versions of completed subgrantee reports. MEI is working on developing this feature for the future. The tool currently exports the data into a .csv file, which looks like an excel sheet but has limited functionality. Once the data is downloaded, re-save it as an excel so you can access all the functions available in excel, such as formatting.

A:

1. Re-save the exported data as an excel file.

  1. The tool currently exports the data into a .csv file, which looks like an excel sheet but has limited functionality. With the exported .csv file open, go to File, Save As. A dialogue box will appear, where it says, “Save as type,” select Excel Workbook from the drop-down menu. Be sure to save it to a location where you can find it.

2. Transform the data from a horizontal view to a vertical view.

  1. After saving the file as an excel, select and copy the information in rows 2 and 3.
  2. Create a “new sheet” in the excel document by clicking the “+” symbol at the bottom of the excel file.
  3. In the new sheet, right-click in cell A-1 and do a special paste using the Transpose Paste function. This changes the data from horizontal to vertical. Column A will contain the descriptions of the data points and column B will contain the data entered into the subgrantee report.

3. Adjust the columns’ widths so you can see all the text.

  1. Select columns A and B, and expand the width by clicking on the border between columns A and B and dragging the width of column A to the right.
  2. Apply “wrap text” formatting.

A:

1. Re-save the exported data as an excel file.

  1. The tool currently exports the data into a .csv file, which looks like an excel sheet but has limited functionality. With the exported .csv file open, go to File, Save As. A dialogue box will appear, where it says, “Save as type,” select Excel Workbook from the drop-down menu. Be sure to save it to a location where you can find it.

2. Transform the data from a horizontal view to a vertical view.

  1. After saving the file as an excel, select and copy the information in rows 2 and 3.
  2. Create a “new sheet” in the excel document by clicking the “+” symbol at the bottom of the excel file.
  3. In the new sheet, right-click in cell A-1 and do a special paste using the Transpose Paste function. This changes the data from horizontal to vertical. Column A will contain the descriptions of the data points and column B will contain the data entered into the subgrantee report.

3. Adjust the columns’ widths so you can see all the text.

  1. Select columns A and B, and expand the width by clicking on the border between columns A and B and dragging the width of column A to the right.
  2. Apply “wrap text” formatting.

A:

In the exported file, the first row lists the names for each data field as it exists in the backend of the tool. The second row has labels describing what each data field is. The third row is the data entered into the subgrantee report. State Admins or subgrantees may need to expand the column widths or use the “wrap text” function in excel to see all the entered information.