For trouble logging in, contact helpdesk@ncigf.org
 

The National Conference of
Insurance Guaranty Funds
300 North Meridian St.
Suite 1020
Indianapolis, IN 46204
tel: 317.464.8199
fax: 317.464.8180

Search Our Site:
[Disclaimer]

Instructions on use of Inception-to-Date Excel Data Sheets

New Format for Reporting
(This information is complete and accurate to the best of our knowledge as of February 2005)

NCIGF has simplified and at the same time expanded its method of representing Financial History information (payments and recoveries for each insolvency). It does require some basic Excel skills which are represented below.

Each of these reports are drawn from the one of three separate base data sources and are presented in summary format - Assessments, Financial History and Capacity. Financial History is also represented on a by-year basis.

To see the desired report, left click on the link, and it will open in a new browser window. If you wish to have the data available for your own manipulation, right click on the link and select "Save target as" and save it to your hard drive.

To see the complete detail of any report, click on the 3 box at the top of the left-hand column. To see the detail for single listed item, click on the + symbol to that item's left. (when you click the "+" symbol, it expands the section. Click the "-" symbol to the left of the section total to re-collapse the section).There are hidden columns between column A and G that contain more information. To display the hidden columns, click on the A in the column labels and roll to G holding your pointer down. This will highlight those two columns. Release your mouse. With your pointer in the highlighted area, right click and select "Unhide".

For additional assistance with these reports, contact the NCIGF helpdesk.


© 2004 NCIGF. All Rights Reserved.