TRACES Justification Report Generation Utility V 2.1 (Needs Excel 2003 or later - Size ~400Kb)
Steps to convert the Justification Report text file into an excel
- Download the zip file from 'Requested Downloads' screen and save to your local machine
- Unzip the file using Winzip. Password to unzip is 'JR_<TAN>_<Form Type>_<Quarter>_<FY>', e.g., JR_AAAAA1235A_24Q_Q3_2010-11. This will save the Justification Report as a text file
- Download the macro utility for Justification Report from this screen
- Double-click the utility, excel sheet will open
- Click on 'Enable Content' in the warning message to enable macros
- Select the Justification Report text file and the folder to save the output excel file and click on button 'Generate TDS CPC Justification Report'
- The text file will be converted into excel spreadsheet and saved in the selected folder
- Open the Justification Report excel file from the folder in which it has been saved
TRACES Offline Correction Generation Utility V 1.0 (Needs Excel 2003 or later. To work on/open offline correction input file, you will need winzip 17 or below installed in your system.)
Steps to convert the Offline Correction file into an excel
- Download the file from 'Requested Downloads' screen and save to your local machine
- Download the macro utility for Offline Correction from this screen
- Double-click the utility, excel sheet will open
- Click on 'Enable Content' in the warning message to enable macros
- Select the Offline Correction text file and the folder to save the output excel file and click on button 'Generate'
- Browse the location where winzip installed location in case winzip not located in default location.
- The text file will be converted into excel spreadsheet and saved in the selected folder
- Open the Offline Correction excel file from the folder in which it has been saved
No comments:
Post a Comment