14 April 2015
Steps to convert the Justification Report text file into 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____', 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