Convert S.19.01.01.LISTV to QRT layout

There is additional supporting functionality to help the user to visualize the S.19.01.01 data in the standard QRT layout.
To use it go to Tools in the Tabular ribbon and select Convert S.19.01.01.LISTV to QRT layout

This option can output the single S.19.01.01 list QRT into the original QRT layout style i.e. in the separate QRT worksheets per LoB/Currency.

Note: The QRTs in the QRT layout file are those based on the LoB and currency combinations selected in the Return Setup screen i.e. NOT on the contents of S.19.01.01.LISTV C0010

The generated file will be created in Excel Output Files folder with name: ‘S.19.01.01 LISTV converted to QRT layout_date.xlsb’

Also, there are 2 options in Convert S.19.01.01.LISTV to QRT layout to include or exclude Tabular formulas in that generated output file.

So in case, the user will select Include Tabular formulas in output this created output file will include all Tabular formulas needed. And will be created without any Tabular formulas in case user selects Exclude Tabular formulas in output

If the Include Tabular formulas in that generated output file option is selected then the output file will include all applicable Tabular formulas (e.g. total cumulative claims paid subtotals; total LoB sheet populated from currency level sheets) and if the claims development triangles roll-forward option is selected those formulas will also be added. How to run roll-forward for 19.01.01 QTRs here.