How do I import an Excel file to Loss Forecaster?

Excel Template

Begin by downloading our Excel import template from RISK66.com. If you are logged in to RISK66, this template can be found in our Resource Library, or by clicking here.

We also have a sample template, complete with sample data which can be downloaded here. We will use this sample template below.

The Excel template contains four tabs:

• Setup
• Losses
• ExcessLosses
• WorkersComp

Setup Tab

On the Setup tab, only one line of data is required, as highlighted below on line 2.  

The Industry field must contain one of our 25 supported industry types. To select a value, click in the B2 cell and select from the drop-down menu:

The Line of Coverage field must contain one of our 5 supported lines of coverage. To select a value, click in the C2 cell and select from the drop-down menu:

The Method field must contain one of our supported loss development methods. To select a value, click in the D2 cell and select from the drop-down menu:

The Analysis Type field must contain one of the two supported analyses. To select a value, click in the E2 cell and select from the drop-down menu:

The Exposure field must contain one of the 9 supported exposures. To select a value, click in the F2 cell and select from the drop-down menu:

Complete the remaining items on line two by entering the necessary data directly into the corresponding cell. Some cells will be left blank depending on the selected exposure type.

Line 3 should be left blank. Anything entered on line 5 or below will be imported into the "Comments" field in Loss Forecaster.

Losses Tab

On the Losses tab, loss data can be entered on rows 2 through 16, as Loss Forecaster allows 15 policy periods per projection. The index field should always start with 1 and increment by 1.  

The number of policy periods you enter on this screen should correspond with the number of policy periods you indicated on the Setup tab. In this example, 5 policy periods were indicated on the Setup tab so data for 5 policies is included below.

Column K through S is also dependent on what was entered on the Setup tab. In this example, we entered an exposure of Payroll, so Payroll data should be entered into column K.

 Line 19 should be left blank.  

ExcessLosses Tab

This tab should include any excess loss amounts for the losses entered on the Losses Tab. This worksheet can have unlimited rows, if needed. Simply insert additional rows above the text on line 22.

The Index column should reflect the Index number from the Losses tab in which the loss applies. In the example below, lines 2 and 3 have an index of "1". These two excess losses, will be applied to the 1/1/2014 to 1/1/2015 period as entered on the Losses Tab. Line 3 has an index value of "3". This excess loss will be applied to the 1/1/2016 and to the 1/1/2017 period.

The Loss Type field must contain one of the 3 supported loss types:

• Incurred
• Paid
• Threshold

WorkersComp Tab

The WorkersComp Tab is available if you would like to apply weighting on worker's compensation percentages by state. Select a state value from the drop-down menu as shown below. The value CW will apply country wide figures. The value CX will exclude California.

The weighted values entered in the percent field should always total 100% as shown below:

Importing into Loss Forecaster

Once you have completed your Excel import file, you can import it into Loss Forecaster.

Open the Loss Forecaster tool from the toolbar. Navigate to the client that you want to import the file. If the client does not exist, click the  button to create it.

Once you have selected the correct client, hover over the "Add" button and click the "Import Excel File" option.

 The import screen will open. This screen allows you to select up to 20 files to import at one time. Select "Excel Forecast Files" as the import type. Then click  to select the file(s) you want to import.  

Once you have selected your file(s) for import, click the Upload button:

5. Once the import is complete, you will see the following screen:

You can click the  to edit any file from here or you can click the  button to return to the previous screen. The newly imported files will be listed under the selected client. All imported files will have the title "Imported from" followed by the Excel file's title, as well as the import date. The title can be changed by clicking the "Edit" button under the  "Settings" button to edit the file.