-
AZAPPER
-
PDF
-
Wiretap
-
RetroActivities
Windows 10 or 11
Microsoft Excel 2021, 2024, or 365
MacOS Compatibility Coming Soon
Setup Wizard for quick installation Creates Desktop Shortcut *Admin Privledges required!
https://drive.google.com/file/d/1auBBG3eg79sjW5WW1963CM89LWyme_kP/view?usp=drive_link
Works on any system regardless of Admin Privileges
https://drive.google.com/file/d/1ZUoLoq665H9JT_DKihTSFNb1W1lon_xG/view?usp=sharing
DataForge2 features assesiblity shortcut buttons to 4 built-in Microsoft Applications essential for any task!
Activates Windows Snipping Tool
Opens of an instance of the Calculator App
Activates your systems Clipboard
Activates the Task View for your system
Combines Multiple spreadsheets
- This will open a blank Workbook in Excel, and launch a File Selection Dialog
Formats WRS P1 spreadsheets into uniform format for closeouts and basic reconciliations
- After You Download your file do not make changes to it! QuikFormat only works on unaltered XLS filetypes.
- DO NOT select any of the other optional display option buttons that "Show/Hide". Doing so will cause your quickformat to produce unintended results.
- Make sure your file is closed in Excel before proceeding
- QuickFormat only transforms raw files still in 'XLS' format.
- Once loaded properly, "Unformatted" will visible in the display pane
- While Running, you will see your spreadsheet flash open.
- After the process has completed, you will see a message that states "Your Report has been generated succesfully!"
- Once Processed, P1 reports will display in the preview window, as well as the Sponsor Name and Project ID
Once formatted, the details button will populate to the right of the information bar
Reconciles LOC drawsheet for drawdown in ASAP.
-
DO NOT MAKE ANY CHANGES TO YOUR LOC REPORT *
-
ANY Manual Changes made prior to processing may result in unintended results *
Formats LOC drawsheet for NSF accounts in Research.gov.
-
DO NOT MAKE ANY CHANGES TO YOUR LOC REPORT *
-
ANY Manual Changes made prior to processing may result in unintended results *
- While running, your report will open up and begin to format itself
- DO NOT MAKE ANY CHANGES UNTIL THE PROCESS COMPLETES
- Interupting this process will cause your run to fail
| Result Type | Description | Sheet Name | Location |
|---|---|---|---|
| Link Account | This account is what allows the program to link your Project ID to the Finaincial information from Research.gov. It is based on the highest numerical project ID in a cluster. For single projects it will be the prime ID, but for project's with mulitple accounts this may not always be the case. | Sheet1 | Column D |
| Project End Date | The program will associate the Project End Date with project ID of the Link Account. If the link account is inactive but the prime is, then the autodraw process will assume the project has ended. | Sheet1 | |
| Overspent Active Accounts Max Draw | Budget Balance Greater less than 0 [Overspent] (Column G), and Today is less than 120 days after the budget end date (Column F), the draw will equal the remaining Draw Balance (Column N) | Sheet1 | |
| Regular Draws & Active Refunds | If there is an avaialbe Draw Balance (Column N), & Today is less than 120 days after the budget end date( Column I), Then the draw amount will equal the cash balance (Column K) | Sheet1 | |
| Draw Summary | List of All Link Accounts, Cash Balances, and Draw Amounts from Sheet1 | Draw Summary | |
| Positibe Cash Report | All Projects with positive cash | Draw Summary | |
| Terminal Refunds | Positive Cash Projects with an end date before Today | Draw Summary | |
| Active Refunds | Positive Cash Projects with an end date after Today | Draw Summary | |
| Unavailable Funding Reports | Projects that need cash / overspent, but have an expired project end date | Draw Summary | |
| Overspent Accounts | Active Project, fully drawn down with a negative Budget Balance (Overspent) | Draw Summary | |
| Max Draw Difference | Active Projects, overbudget but with an availabe draw balance. This is the difference that is not able to be recouped. | Draw Summary | |
| LOC Coversheet | Reconciliation of total draw and all adjustments which include: - Terminal Refunds - Unavailabe Funding - Overspent Accounts - Max Draw Difference Accounts. All accounts are listed out and represent the sum of all logical adjustments needed |
Recompiles LOC drawsheet for NIH accounts.
Converts INVALID RETROACTIVE DISTRIBUTION ACCT_CD REPORT to Excel Format
- The defualt location will be "Documents"
Extracts invoice numbers, dollar amounts, and Vendor Info from Wells Fargo PDF to CSV.
Coverts USDA NIFA ASAP balance PDF into Excel Worksheet.
Composite report for WRS P3 spreadsheets *Draws Formatted via AutoDraw can be imported directly into AZAPPED balance sheet