Output File
When executing Jabatix NC, an output file is generated as a result. The output file is generated in one of the following formats as specified in the Control File:
Excel (.xlsx or .xls)
OpenOffice (.ods)
csv files
For all combinations of worksheets of the Input Files | Financial-Data and each Scenario Analysis applied, the output file contains a worksheet with the results of the calculation.
If at least one scenario is specified in the Control File, an additional worksheet is generated for each worksheet of the Input Files | Financial-Data, which contains a comparison of the calculation results of all scenarios for all calculation dates.
If the command ‘with comparison’ is specified after the name of the output file in the Control File, comparison columns are integrated in the worksheets of the output files, which show for each calculation date the relative difference between the calculated values and those of the previous calculation date.
The names of the worksheets of the output file are assigned generically depending on the names of the worksheets of the Input Files | Financial-Data and the Scenario Analysis applied.
Example
If the financial data consists of the worksheets BALANCE_SHEET and INCOME_STATEMENT, and two scenarios with the names BEST and WORST have been specified in the control file, the following worksheets are generated in the output file:
BALANCE_SHEET_FORECAST
calculation results of the balance sheet
BALANCE_SHEET_FORECAST_BEST
calculation results of the balance sheet for scenario BEST
BALANCE_SHEET_FORECAST_WORST
calculation results of the balance sheet for scenario WORST
BALANCE_SHEET_FORECAST_ALL
comparison of all calculation results of the balance sheet
INCOME_STATEMENT_FORECAST
calculation results of the income statement
INCOME_STATEMENT_FORECAST_BEST
calculation results of the income statement for scenario BEST
INCOME_STATEMENT_FORECAST_WORST
calculation results of the income statement for scenario WORST
INCOME_STATEMENT_FORECAST_ALL
comparison of all calculation results of the income statement
The output file then has the following structure: