Subtotals Results on Cumulative Difference Spreadsheets

Suppose that you want subtotals results in the spreadsheets covering all or several years.

•If you are rerunning the Base with Policy closures, cumulative differences compare results from the Policy run with those from the Rerun. The subtotals in the Rerun are those subtotals specified in the CMFSTART file in the Policy Closures column on the Closure/Shocks page. The subtotals in the Policy are those subtotals specified in the CMFSTART file in the Policy Shocks column on the Closure/Shocks page. So, if you want subtotals results in the cumulative differences spreadsheet, you must ensure that the same subtotals are on the CMFSTART files in the Policy Closures and the Policy Shocks columns on the Closure/Shocks page. [Otherwise the DEVIA part of the SS job will crash.]

•If you are not rerunning the Base with Policy closures, cumulative differences compare results from the Policy run with those from the Base. The subtotals in the Base are those subtotals specified in the CMFSTART file in the Base Closures column on the Closure/Shocks page. The subtotals in the Policy are those subtotals specified in the CMFSTART file in the Policy Shocks column on the Closure/Shocks page. So, if you want subtotals results in the cumulative differences spreadsheet, you must ensure that the same subtotals are on the CMFSTART files in the Base Closures and the Policy Shocks columns on the Closure/Shocks page. [Otherwise the DEVIA part of the SS job will crash.]

•Even if you include subtotals for all shocks in the Policy Shocks column on the Closure/Shocks page, you will usually find that subtotal results do not add up to the cumulative differences (Deviation) results. The reason why is explained in the GEMPACK manual at a topic headed:

Do subtotals for policy shocks add up to the policy deviation?

See : http://www.copsmodels.com/gpmanual.htm#dyndevsubtot

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

Link to full GEMPACK Manual

Link to GEMPACK homepage