How to Read Results in an Excel File
Download a PDF version of this how-to guide here:
()
1. Where is the UNI-Results.xlsx File?
The ”UNI-results.xlsx” file is an Excel file that is included in the UNI-CGE ZIP file that you downloaded and installed in the directory that you created for this project. After the UNI-CGE model solves successfully, a utility in the model (file RepBase.inc) writes selected results into the Excel file. You can locate and open the file by searching for it in your directory.
2. What is in the UNI.Results.xlsx file?
The results file includes selected results from your experiments. Results are organized into worksheets (Figure 1). The worksheets report results for macro variables, GDP, quantities, prices, taxes, production, and factors.
Figure 1. Worksheets in the UNI-Results.xlsx file
Each worksheet displays the data in table formats that facilitate your finding results and exporting them to other apps for presentation. The example in Figure 2 shows the table that displays macro results.
Figure 2. Table of macro results in the UNI-Results.xlsx file
The UNI-CGE model searches for the Excel file in the directory that you have
created for this project and writes results into it. After the model is solved, open the file from
your directory and view the results.
You do not need to close the Results file before running the model again. But it is a good idea to do so.
*IMPORTANT. Every time the model is run,
it will overwrite the Excel results file with new model results. To save
results from a scenario, rename the results file to something like
“ProductivityShock.xlsx” and save it.
You can run repeated experiments and then compare results in your
renamed and saved Excel files.