Example of the Extra Columns in Spreadsheets of Results

These extra columns are only for spreadsheets for the base, base rerun or the policy run. [There are no extra columns in differences spreadsheets.]

Consider a base case run for 4 years, say 1998-2001. Consider results for two scalar variables

x3tot (percentage change in household consumption),

delB (change in the balance of trade)

whose results for the 4 years of the base case are

x3tot

2.0000

3.0000

4.0000

5.0000

delB

500.0

600.0

800.0

1000.0

respectively.

The year-on-year spreadsheet for the base will show the results for these as

x3tot

2.0000

3.0000

4.0000

5.0000

14.0000

14.7155

3.4917

delB

500.00

600.00

800.00

1000.0

2900.0

703.01

725.00

The first 4 numbers are the results for the four years 1998-2001. Then there are 3 extra columns. The x3tot result 14.0 in the first (headed Arithmetic) is just the sum of the 4 results. The x3tot result 14.7155 in the second (headed Geometric) is obtained by compounding the results as percentage changes. The delB results in the first two extra columns are obtained similarly; note that the result in the Geometric column is not really relevant for change variables such as delB.

The x3tot result 3.4917 in the third (headed Average) can be interpreted as the average annual result. For percentage-change variables such as x3tot this is the annual percentage change which, when compounded 4 times, would compound to give the geometric result. For change variables such as delB, this is the average change (one-quarter of the arithmetic sum if the run is over 4 years). The delB result 725.00 in the last extra column is the average annual change. [Each variable in the model is either a change or a percentage-change variable. In the example above, x3tot is a percentage change variable while delB is a change variable. For any variable in the model you are working with, you can find out which it is by looking in the TABLO Input file for the model. For more detail about this, consult the GEMPACK documentation.]

The cumulative spreadsheet for the base will show the x3tot and delB results as

x3tot

2.0000

5.0600

9.2624

14.7155

3.4917

delB

500.00

1100.00

1900.00

2900.0

725.00

The first 4 numbers are the cumulative results for the four years 1998-2001. Then there is just 1 extra column (headed Average) which (as for year-on-year spreadsheets) can be interpreted as the average annual change or percentage change (percentage change for x3tot and change for delB) for the variable in question.

For further details of the way the extra columns are calculated, see the GEMPACK documentation about GEMPACK program ACCUM in the GEMPACK manual.


URL of this topic: www.copsmodels.com/webhelp/rundynam/hc_extracols.htm

Link to full GEMPACK Manual

Link to GEMPACK homepage