6.5.1.3 Providing Shock Values in Excel

To provide shock values for variables from an excel sheet:

1. In Variable Pathways section, to download the excel file, click Export.
   The Select Variables page is displayed.
2. Select the variables you want to import to excel sheet and click Export.
   The file is downloaded in an .XLSM format and the file is named after the scenario name followed by the keyword EST_SCENARIO and followed by the scenario object id: <scenario_name>_<scenario code>_<scenario version>_<timestamp>.XLSM

   Note:

   Ensure you have macros enabled to make changes in the excel sheet.

   The first tab in the excel sheet has two sections. The first section Stress Testing and Scenario Analytics has details about the scenario like the scenario name, scenario id, version number, and the source and time horizon details. The second section, Variable Pathways lists all the exported variables.

   Each variable imported to the excel sheet is listed in a separate tab.

3. Fill the shock type values for a variable in an excel sheet based on the variable type.
   To add the variable values in the excel sheet:

   1. Click the variable name from the Scenario Details tab or the variable tab.
   2. Based on the selected variable type and sub-type, select the shock type from the drop-down menu.
   3. To see the hierarchy code in the display name (default selection) click Yes in the Display Name drop-down menu. Else, click No.
   4. Based on the selected shock type and frequency, columns are generated where you can provide the variable values in the Actual Value section.

      Note:

      Checks are in place to validate the inputs.

      The Computed Value section displays the computed values based on actual values entered.

   5. Click Save to save your changes.

   For more information, see Shock Types for Variables.

4. Upload the updated excel sheet with all the variable details.
   1. Click Import.
   2. Browse and select the file.
      The Excel Data Import Report page is displayed.

      The list of variables in the excel is displayed along with details like version number, shock type, status of the information saved for the variable and details about the status is displayed.

   3. To continue with the upload, click OK.
      If there are any missing values, these are listed as empty in the status. Ensure to add these values before proceeding to the next step.

      If only a few variable values are uploaded and successful, then this partial status is also displayed in the Status column.