{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Instructions","Signature 1","3.15.1","3.15.1 (Cont 1)","3.15.1 (Cont 2)","3.15.1 (Cont 3)","3.15.1 (Cont 4)","3.15.1 (Cont 5)","3.15.2","3.15.2 (Cont 1)","3.15.2 (Cont 2)","3.15.2 (Cont 3)","3.15.2 (Cont 4)","3.15.2 (Cont 5)","3.15.3","Summary"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":11,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":82,"n_cols":10,"rows_kept":82,"cut":false,"hidden":false,"merged":[]}
["STATE OF SOUTH CAROLINA"]
["YEAR-END REPORTING PROCEDURES MANUAL"]
["SECTION 3.15, CLAIMS REPORTING PACKAGE"]
[]
[]
[null,"PURPOSE and OBJECTIVE:"]
[null,"The State is required by GAAP to report liabilities for the estimated future costs of all events giving rise to "]
[null,"claims that occurred on or before June 30 if it is probable that an asset has been impaired or a liability has "]
[null,"been incurred as of that date and the loss amount can be reasonably estimated.  Disclosure of events during "]
[null,"the year and subsequent to year-end that may materially affect future claims costs are also required. "]
[]
[null,"Please refer to the Reporting Policies and Procedures Manual for definitions of terms used in the forms, "]
[null,"conceptual understanding of the reporting, related GAAP, and State reporting policies."]
[]
[null,"INSTRUCTIONS FOR COMPLETION OF FORMS:"]
[null,"Claims Summary Form",null,null,null,null,null,null,null,"3.15.1"]
[null,"This form provides information regarding the liabilities to be reported as of year-end and its financial"]
[null,"statement classification."]
[null,"● Complete a separate form for each claim-paying program or type of self-insured risk.  Create copies of the"]
[null,"form as needed for complete reporting."]
[null,"● Enter the information required as indicated with field descriptions."]
[null,"○   Features within the form to assist in completion:"]
[null,"►    The reporting year is provided as a drop-down menu selection."]
[null,"►    A validation check is provided for keying errors in Fund Number."]
[null,"►    An edit check is included to restrict the dollar amount to the requested range."]
[null,"►    An instruction box is included on the dollar amounts for accurate reporting."]
[null,"►    The total is a calculated field.  Please confirm the accuracy of the calculation."]
[null,"Upon completion of the information requested:"]
[null,"● The individual completing the form should review the form for accuracy and completeness prior to signing"]
[null,"the summary signature sheet as an assertion of the accuracy and completeness of the information reported.  "]
[null,"● The Finance Director or Executive Director should review and approve the form indicating agreement "]
[null,"with the information’s accuracy and completeness before sending it to the Comptroller General's "]
[null,"Office."]
[null,"● Both the preparer and approver certify that the information provided on this reporting package"]
[null,"is complete and accurate to the best of their knowledge."]
[null,"● Send the completed form to the Comptroller General's Office no later than Friday, August 9, 2019.  "]
[null,"● The agency should retain a copy of the completed form as part of its year-end working papers.  The "]
[null,"Comptroller General's Office will contact the individual completing the form if there are any "]
[null,"questions. "]
[]
[null,"Additional Claims Information Form",null,null,null,null,null,null,null,"3.15.2"]
[null,"This form provides additional information relating to the evaluation of liabilities and potential losses under each"]
[null,"claim-paying program or self-insurance risk.  "]
[null,"● A separate form should be completed for each program or self-insurance risks.  "]
[null,"● In addition a form should be completed for any program or self-insurance risk for which subsequent "]
[null,"information is obtained that could affect the liabilities or potential losses."]
[null,"● Enter the information required as indicated with field descriptions."]
[null,"○   Features within the form to assist in completion:"]
[null,"►    Whether the reporting is initial or an update is provided as a drop-down menu selection."]
[null,"►    An instruction box is included on the dollar amounts for accurate reporting."]
[null,"►    Responses to Yes/No questions are provided in a drop-down menu."]
[null,"● The valuation date should be June 30 for the Year-End reporting.  In an updated form submission please "]
[null,"provide the valuation date as the date through which the evaluation  occurred."]
[null,"● If Incurred But Not Reported (IBNR) claims are actuarially determined, attach a copy of the actuary's "]
[null,"report to the form for submission."]
[null,"● In the explanation for events that changed the future claims, please include a description of the event, "]
[null,"how it affects previously reported claims liabilities, and the dollar effect on future claims costs."]
[null,"Upon completion of the information requested:"]
[null,"● The individual completing the form should review the form for accuracy and completeness prior to signing"]
[null,"the summary signature sheet as an assertion of the accuracy and completeness of the information reported.  "]
[null,"● The Finance Director or Executive Director should review and approve the form indicating agreement "]
[null,"with the information’s accuracy and completeness before sending it to the Comptroller General's "]
[null,"Office."]
[null,"● Both the preparer and approver certify that the information provided on this reporting package"]
[null,"is complete and accurate to the best of their knowledge."]
[null,"● Send the completed form to the Comptroller General's Office no later than Friday, August 9, 2019.  "]
[null,"● Send any update (subsequent) forms to the Comptroller General's Office as soon as possible.  "]
[null,"● The agency should retain a copy of the completed form as part of its year-end working papers.  The "]
[null,"Comptroller General's Office will contact the individual completing the form if there are any "]
[null,"questions. "]
[]
[null,"Reviewer's Checklist",null,null,null,null,null,null,null,"3.15.3"]
[null,"Note:  It is mandatory to submit the reviewers checklist with the packet submission."]
[null,"Use this Checklist as a mechanism for review.  It should be completed prior to reviewer's signature on"]
[null,"the information forms.  A No response indicates an error.  If errors are identified, return the package"]
[null,"to the preparer for correction prior to further review.  A N/A response requires documentation in writing"]
[null,"of an explanation why the question is not applicable to the agency to be retained for audit purposes."]
[null,"►    The year for reporting has been derived from the selection made on 3.15.1."]
[null,"Upon completion of the checklist:"]
[null,"● Send the completed form to the Comptroller General's Office no later than Friday, August 9, 2019.  "]
[null,"● Retain a copy in the accounting records of the agency as documentation of the control procedure."]
[null,"● An auditor may request to examine the completed document."]

{"sheet":"Signature 1","index":1,"n_rows":135,"n_cols":6,"rows_kept":135,"cut":false,"hidden":false,"merged":[[134,1,134,5],[123,1,123,5],[125,1,125,5],[127,1,127,5],[129,1,129,5],[131,1,131,5]]}
[null,null,"3.15 Claims Packet"]
[]
[]
[null,null,"CAFR Reporting Period:",null,2019]
[null,null,"Agency Number:",null,null," "]
[null,null,"Agency Name",null,{"$f":"IF(ISERROR(VLOOKUP(AgencyCode,C32:D108,2,FALSE))=TRUE,\"\",VLOOKUP(AgencyCode,C32:D108,2,FALSE))","v":""}]
[]
[]
[]
[]
[]
[null,null,"Preparer","Date:",null," "]
[null,null,null,"Name:",null," "]
[null,null,null,"Title:",null," "]
[null,null,null,"e-mail:",null," "]
[null,null,null,"Phone Number:",null," "]
[null,null,null,"Signature:",null," "]
[]
[null,null,"Reviewer","Date:",null," "]
[null,null,null,"Name:",null," "]
[null,null,null,"Title:",null," "]
[null,null,null,"e-mail:",null," "]
[null,null,null,"Phone Number:",null," "]
[null,null,null,"Signature:",null," "]
[]
[null,null,"Signatures are an assertion of the accuracy and completeness of the information reported.  "]
[]
[]
[null,null,"The following information must be reviewed and updated as necessary anually:"]
[]
[null,null,"AGCY  CODE","AGENCY NAME","Year"]
[null,null,"A010","LEGISLATIVE DEPARTMENT - THE SENATE"]
[null,null,"A050","LEGISLATIVE DEPARTMENT - HOUSE OF REPRESENTATIVES"]
[null,null,"A150","LEGISLATIVE DEPARTMENT - CODIFICATION OF LAWS & LEGISLATIVE COUNCIL"]
[null,null,"A170","LEGISLATIVE DEPARTMENT - LEGISLATIVE SERVICES AGENCY"]
[null,null,"A200","LEGISLATIVE DEPARTMENT - LEGISLATIVE AUDIT COUNCIL"]
[null,null,"A850","EDUCATION OVERSIGHT COMMITTEE"]
[null,null,"B040","JUDICIAL DEPARTMENT"]
[null,null,"C050","ADMINISTRATIVE LAW JUDGES"]
[null,null,"D050","GOVERNOR'S OFFICE--EXECUTIVE CONTROL OF STATE"]
[null,null,"D100","GOVERNOR'S OFFICE--STATE LAW ENFORCEMENT DIVISION"]
[null,null,"D170","GOVERNOR'S OFFICE-- EXECUTIVE POLICY & PROGRAMS"]
[null,null,"D200","GOVERNOR'S OFFICE--MANSION & GROUNDS"]
[null,null,"D250","INSPECTOR GENERAL"]
[null,null,"D500","DEPARTMENT OF ADMINSTRATION"]
[null,null,"E040","LIEUTENANT GOVERNOR'S OFFICE"]
[null,null,"E080","SECRETARY OF STATE'S OFFICE"]
[null,null,"E120","COMPTROLLER GENERAL'S OFFICE\n"]
[null,null,"E160","STATE TREASURER'S OFFICE                                                                       "]
[null,null,"E190","RETIREMENT SYSTEM  INVESTMENT COMMISSION"]
[null,null,"E200","ATTORNEY GENERAL'S OFFICE"]
[null,null,"E210","PROSECUTION COORDINATION  COMMISSION"]
[null,null,"E230","COMMISSION ON INDIGENT DEFENSE "]
[null,null,"E240","ADJUTANT GENERAL'S OFFICE"]
[null,null,"E280","ELECTION COMMISSION"]
[null,null,"E500","REVENUE AND FISCAL AFFAIRS OFFICE"]
[null,null,"E550","STATE FISCAL ACCOUNTABILITY AUTHORITY"]
[null,null,"F270","STATE AUDITOR"]
[null,null,"H030","COMMISSION ON HIGHER EDUCATION"]
[null,null,"H060","HIGHER EDUCATION TUITION GRANTS COMMISSION"]
[null,null,"H590","BOARD FOR TECHNICAL & COMPREHENSIVE EDUCATION"]
[null,null,"H630","DEPARTMENT OF EDUCATION"]
[null,null,"H670","EDUCATIONAL TELEVISION COMMISSION (ETV)"]
[null,null,"H710","WIL LOU GRAY OPPORTUNITY SCHOOL"]
[null,null,"H730","VOCATIONAL REHABILITATION"]
[null,null,"H750","SCHOOL FOR THE DEAF AND BLIND"]
[null,null,"H790","DEPARTMENT OF ARCHIVES AND HISTORY"]
[null,null,"H870","STATE LIBRARY"]
[null,null,"H910","ARTS COMMISSION"]
[null,null,"H950","MUSEUM COMMISSION"]
[null,null,"H960","CONFEDERATE RELIC ROOM AND MILITARY MUSEUM COMMISSION"]
[null,null,"J020","DEPARTMENT OF HEALTH AND HUMAN SERVICES"]
[null,null,"J040","DEPARTMENT OF HEALTH AND ENVIRONMENTAL CONTROL"]
[null,null,"J120","DEPARTMENT OF MENTAL HEALTH"]
[null,null,"J160","DEPARTMENT OF DISABILITIES AND SPECIAL NEEDS"]
[null,null,"J200","DEPARTMENT OF ALCOHOL AND OTHER DRUG ABUSE SERVICES"]
[null,null,"K050","DEPARTMENT OF PUBLIC SAFETY"]
[null,null,"L040","DEPARTMENT OF SOCIAL SERVICES"]
[null,null,"L120","JOHN DE LA HOWE SCHOOL"]
[null,null,"L240","COMMISSION FOR THE BLIND"]
[null,null,"L360","HUMAN AFFAIRS COMMISSION"]
[null,null,"L460","STATE COMMISSION FOR MINORITY AFFAIRS"]
[null,null,"N040","DEPARTMENT OF CORRECTIONS"]
[null,null,"N080","DEPARTMENT OF PROBATION, PAROLE AND PARDON"]
[null,null,"N120","DEPARTMENT OF JUVENILE JUSTICE"]
[null,null,"N200","LAW ENFORCEMENT TRAINING COUNCIL"]
[null,null,"P120","FORESTRY COMMISSION"]
[null,null,"P160","DEPARTMENT OF AGRICULTURE"]
[null,null,"P240","DEPARTMENT OF NATURAL RESOURCES"]
[null,null,"P260","SEA GRANT CONSORTIUM"]
[null,null,"P280","DEPARTMENT OF PARKS, RECREATION AND TOURISM"]
[null,null,"P320","DEPARTMENT OF COMMERCE"]
[null,null,"P400","SOUTH CAROLINA CONSERVATION BANK"]
[null,null,"P450","RURAL INFASTRUCTURE AUTHORITY"]
[null,null,"R040","PUBLIC SERVICE COMMISSION"]
[null,null,"R060","OFFICE OF REGULATORY STAFF"]
[null,null,"R080","WORKER'S COMPENSATION COMMISSION"]
[null,null,"R200","DEPARTMENT OF INSURANCE"]
[null,null,"R230","BOARD OF FINANCIAL INSTITUTIONS"]
[null,null,"R280","DEPARTMENT OF CONSUMER AFFAIRS"]
[null,null,"R360","DEPARTMENT OF LABOR, LICENSING, AND REGULATION"]
[null,null,"R400","DEPARTMENT OF MOTOR VEHICLES"]
[null,null,"R440","DEPARTMENT OF REVENUE AND TAXATION"]
[null,null,"R520","STATE ETHICS COMMISSION"]
[null,null,"R600","DEPARTMENT OF EMPLOYMENT WORKFORCE"]
[null,null,"S600","PROCUREMENT REVIEW PANEL"]
[null,null,"U300","AERONAUTICS DIVISION"]
[null,null,"X440","AID TO SUBDIVISIONS--DEPARTMENT OF REVENUE   (Note 2)"]
[]
[]
[null,null,"3.01.1 Only"]
[null,null,"3.01.2 Only"]
[null,null,"3.01.3 Only"]
[null,null,"3.01.1 & 3.01.2 Only"]
[null,null,"3.01.1 & 3.01.3 Only"]
[null,null,"3.01.2 & 3.01.3 Only"]
[null,null,"3.01.1, 3.01.2 & 3.01.3"]
[]
[]
["Your signature on this form certifies that the information provided on the reporting packages is complete and accurate to the best of your knowledge."]
[]
["Representations made by signing as the approver:"]
[]
[null,"I acknowledge and have fulfilled the responsibility for implementation and maintenance of internal control relevant to the preparation and fair presentation of the year end packets that are free from material misstatement, whether due to fraud or error."]
[]
[null,"We have recorded or disclosed all accounting estimates that could be material to the financial statements in accordance with the requirements of U.S. GAAP. "]
[]
[null,"Related party relationships and transactions, including, but not limited to, revenues, expenditures/expenses, loans, transfers, leasing arrangements, and guarantees, and amounts receivable from or payable to related parties have been appropriately accounted for and disclosed in accordance with the requirements of U.S. GAAP."]
[]
[null,"All events occurring subsequent to the date of the financial statements and for which U.S. GAAP requires adjustment or disclosure have been adjusted or disclosed."]
[]
[null,"Guarantees, whether written or oral, under which the State is contingently liable, if any, have been properly recorded or disclosed in accordance with U.S. GAAP."]
[]
[]
[null,"Note: This is the ONLY form from packet 3.15 that is to be submitted in pdf format, all others are submitted via excel format."]

{"sheet":"3.15.1","index":2,"n_rows":161,"n_cols":10,"rows_kept":161,"cut":false,"hidden":false,"merged":[[31,0,31,7],[21,0,21,1],[24,0,24,7],[27,0,27,7],[5,3,5,8],[20,2,20,7],[23,0,23,7],[13,5,13,9],[28,0,28,7],[8,3,8,8],[10,3,10,8]]}
["STATE OF SOUTH CAROLINA"]
["CLAIMS SUMMARY FORM"]
[null,null,null,null,"At June 30,"]
[]
[]
["Agency:",null,null,{"$f":"IF(AgencyCode=\"\",\"\",VLOOKUP(AgencyCode,A45:B161,2))","v":""}]
[null,"Bus. Area",null,"Name"]
[]
["Preparer (Type Name):"]
[]
["Reviewer (Type Name):"]
[]
[]
["Name of Claim-Paying Program/Type of Self-Insured Risk:"]
[]
[]
["Fund:"]
[]
[]
[]
[null,null,"Description",null,null,null,null,null,"Dollar Amount"]
[]
[]
["Liability for Claims that the agency paid or plans to process for payment in the "]
["     extended 12th period of the current fiscal year (marked as \"Prior Year Payable\").",null,null,null,null,null,null,null,"$"]
[]
[]
["Liability for Claims that the agency plans to pay during period 1 - 12 of"]
["     the next fiscal year.",null,null,null,null,null,null,null,"$"]
[]
[]
["Liability for Claims that the agency plans to pay after June 30 of next fiscal year",null,null,null,null,null,null,null,"$"]
[]
[]
[]
["              Total Claims to be Paid by this Fund",null,null,null,null,null,null,null,"$",{"$f":"J25+J29+J32","v":0}]
[]
["Form 3.15.1,  Rev. 6/30/18"]
[]
["Note:  To open an additional five claim summary worksheets,"]
["click the following button"]
[]
[]
["AGCY  CODE","AGENCY NAME"]
["A010","LEGISLATIVE DEPARTMENT - THE SENATE"]
["A050","LEGISLATIVE DEPARTMENT - HOUSE OF REPRESENTATIVES"]
["A150","LEGISLATIVE DEPARTMENT - CODIFICATION OF LAWS & LEGISLATIVE COUNCIL"]
["A170","LEGISLATIVE DEPARTMENT - LEGISLATIVE PRINTING & INFORMATION TECHNICAL SYSTEMS"]
["A200","LEGISLATIVE DEPARTMENT - LEGISLATIVE AUDIT COUNCIL"]
["A850","EDUCATION OVERSIGHT COMMITTEE"]
["B040","JUDICIAL DEPARTMENT"]
["C050","ADMINISTRATIVE LAW JUDGES"]
["D050","GOVERNOR'S OFFICE--EXECUTIVE CONTROL OF STATE"]
["D100","GOVERNOR'S OFFICE--STATE LAW ENFORCEMENT DIVISION"]
["D170","GOVERNOR'S OFFICE-- EXECUTIVE POLICY & PROGRAMS"]
["D200","GOVERNOR'S OFFICE--MANSION & GROUNDS"]
["D250","INSPECTOR GENERAL"]
["D500","DEPARTMENT OF ADMINISTRATION"]
["E040","LIEUTENANT GOVERNOR'S OFFICE"]
["E080","SECRETARY OF STATE'S OFFICE"]
["E120","COMPTROLLER GENERAL'S OFFICE\nW90 - DUES AND CONTRIBUTIONS (Note 1)\nX12 - AID TO SUBDIVISIONS--COMPTROLLER GENERAL (Note 1)"]
["E160","STATE TREASURER'S OFFICE  \nE17-TOBACCO SETTLEMENT REVENUE MANAGEMENT AUTHORITY\nV04 - DEBT SERVICE C/O STATE TREASURER (Note 2)   \nX22 - AID TO SUBDIVISIONS--STATE TREASURER   (Note 2)                                                                        "]
["E190","RETIREMENT SYSTEM  INVESTMENT COMMISSION"]
["E200","ATTORNEY GENERAL'S OFFICE"]
["E210","PROSECUTION COORDINATION  COMMISSION"]
["E230","COMMISSION ON INDIGENT DEFENSE (Note 9)"]
["E240","ADJUTANT GENERAL'S OFFICE\n(E25) STATE ACTIVITY DUTY (Note 8)"]
["E280","ELECTION COMMISSION"]
["E500","REVENUE AND FISCAL AFFAIRS OFFICE"]
["E550","STATE FISCAL ACCOUNTABILITY AUTHORITY"]
["F270","STATE AUDITOR"]
["F290","RETIREMENT SYSTEMS"]
["F300","BUDGET & CONTROL BOARD--EMPLOYEE BENEFITS"]
["F310","BUDGET & CONTROL BOARD--CAPITAL RESERVE FUND"]
["F350","BUDGET & CONTROL BOARD--OHR TEMPORARY SERVICES"]
["F500","PUBLIC EMPLOYEE BENEFIT AUTHORITY"]
["H030","COMMISSION ON HIGHER EDUCATION"]
["H060","HIGHER EDUCATION TUITION GRANTS COMMISSION"]
["H090","THE CITADEL (LUMP SUM)"]
["H120","CLEMSON UNIVERSITY  (LUMP SUM)\nP20 - CLEMSON PUBLIC SERVICE AUTHORITY (Note 4)"]
["H150","UNIVERSITY OF CHARLESTON (LUMP SUM)"]
["H170","COASTAL CAROLINA UNIVERSITY (LUMP SUM)"]
["H180","FRANCIS MARION UNIVERSITY (LUMP SUM)"]
["H210","LANDER UNIVERSITY (LUMP SUM)"]
["H240","SOUTH CAROLINA STATE UNIVERSITY (LUMP SUM)\nP21 SCSU PUBLIC SERVICE ACTIVITY  (Note 5)"]
["H270","UNIVERSITY OF SOUTH CAROLINA (LUMP SUM)"]
["H290","UNIVERSITY OF SOUTH CAROLINA--AIKEN CAMPUS (LUMP SUM)"]
["H340","UNIVERSITY OF SOUTH CAROLINA--SPARTANBURG CAMPUS (LUMP SUM) "]
["H360","UNIVERSITY OF SOUTH CAROLINA--BEAUFORT CAMPUS (LUMP SUM)"]
["H370","UNIVERSITY OF SOUTH CAROLINA--LANCASTER CAMPUS (LUMP SUM)"]
["H380","UNIVERSITY OF SOUTH CAROLINA--SALKEHATCHIE CAMPUS (LUMP SUM)"]
["H390","UNIVERSITY OF SOUTH CAROLINA--SUMTER CAMPUS (LUMP SUM)"]
["H400","UNIVERSITY OF SOUTH CAROLINA--UNION CAMPUS (LUMP SUM)"]
["H470","WINTHROP UNIVERSITY (LUMP SUM)"]
["H510","MEDICAL UNIVERSITY OF SOUTH CAROLINA (LUMP SUM)     \n  H53 - CONSORTIUM OF COMMUNITY TEACHING HOSPITALS   (Note 6)\n"]
["H590","BOARD FOR TECHNICAL & COMPREHENSIVE EDUCATION"]
["H630","DEPARTMENT OF EDUCATION"]
["H670","EDUCATIONAL TELEVISION COMMISSION (ETV)"]
["H710","WIL LOU GRAY OPPORTUNITY SCHOOL"]
["H730","VOCATIONAL REHABILITATION"]
["H750","SCHOOL FOR THE DEAF AND BLIND"]
["H790","DEPARTMENT OF ARCHIVES AND HISTORY"]
["H870","STATE LIBRARY"]
["H910","ARTS COMMISSION"]
["H950","MUSEUM COMMISSION"]
["J020","DEPARTMENT OF HEALTH AND HUMAN SERVICES"]
["J040","DEPARTMENT OF HEALTH AND ENVIRONMENTAL CONTROL"]
["J120","DEPARTMENT OF MENTAL HEALTH"]
["J160","DEPARTMENT OF DISABILITIES AND SPECIAL NEEDS"]
["J200","DEPARTMENT OF ALCOHOL AND OTHER DRUG ABUSE SERVICES"]
["K050","DEPARTMENT OF PUBLIC SAFETY"]
["L040","DEPARTMENT OF SOCIAL SERVICES"]
["L120","JOHN DE LA HOWE SCHOOL"]
["L240","COMMISSION FOR THE BLIND"]
["L320","HOUSING FINANCE & DEVELOPMENT AUTHORITY"]
["L360","HUMAN AFFAIRS COMMISSION"]
["L460","STATE COMMISSION FOR MINORITY AFFAIRS"]
["N040","DEPARTMENT OF CORRECTIONS"]
["N080","DEPARTMENT OF PROBATION, PAROLE AND PARDON"]
["N120","DEPARTMENT OF JUVENILE JUSTICE"]
["N200","LAW ENFORCEMENT TRAINING COUNCIL"]
["P120","FORESTRY COMMISSION"]
["P160","DEPARTMENT OF AGRICULTURE"]
["P200","CLEMSON PUBLIC SERVICE AUTHORITY (Note 4)"]
["P210","SCSU PUBLIC SERVICE ACTIVITY (Note 5)"]
["P240","DEPARTMENT OF NATURAL RESOURCES"]
["P260","SEA GRANT CONSORTIUM"]
["P280","DEPARTMENT OF PARKS, RECREATION AND TOURISM"]
["P320","DEPARTMENT OF COMMERCE\nY08 -  Public Railways Commission (Note 7)"]
["P340","JOBS-ECONOMIC DEVELOPMENT AUTHORITY"]
["P350","SOUTH CAROLINA RESOURCES AUTHORITY"]
["P360","PATRIOTS POINT DEVELOPMENT AUTHORITY"]
["P380","SOUTH CAROLINA RESEARCH AUTHORITY"]
["P400","SOUTH CAROLINA CONSERVATION BANK"]
["P450","RURAL INFASTRUCTURE AUTHORITY"]
["R040","PUBLIC SERVICE COMMISSION"]
["R060","OFFICE OF REGULATORY STAFF"]
["R080","WORKER'S COMPENSATION COMMISSION"]
["R120","STATE ACCIDENT FUND"]
["R140","PATIENTS' COMPENSATION FUND "]
["R160","SECOND INJURY FUND"]
["R200","DEPARTMENT OF INSURANCE"]
["R230","BOARD OF FINANCIAL INSTITUTIONS"]
["R280","DEPARTMENT OF CONSUMER AFFAIRS"]
["R360","DEPARTMENT OF LABOR, LICENSING, AND REGULATION"]
["R400","DEPARTMENT OF MOTOR VEHICLES"]
["R440","DEPARTMENT OF REVENUE AND TAXATION"]
["R520","STATE ETHICS COMMISSION"]
["R600","DEPARTMENT OF EMPLOYMENT WORKFORCE"]
["S600","PROCUREMENT REVIEW PANEL"]
["U120","DEPARTMENT OF TRANSPORTATION\nU15-SOUTH CAROLINA TRANSPORTATION INFRASTRUCTURE BANK\nU20-COUNTY TRANSPORTATION FUND"]
["U300","AERONAUTICS DIVISION"]
["V040","DEBT SERVICE C/O STATE TREASURER  (Note 2)"]
["W900","DUES AND CONTRIBUTIONS (Note 1)"]
["X120","AID TO SUBDIVISIONS--COMPTROLLER GENERAL'S OFFICE   (Note 1)                                                        "]
["X220","AID TO SUBDIVISIONS--STATE TREASURER   (Note 2)"]
["X440","AID TO SUBDIVISIONS--DEPARTMENT OF REVENUE   (Note 2)"]
["Y080","PUBLIC RAILWAYS COMMISSION  (Note 7)"]
["Y140","PORTS AUTHORITY"]
["Y180","PUBLIC SERVICE AUTHORITY"]
["Y200","SOUTH CAROLINA LOTTERY COMMISSION"]

{"sheet":"3.15.1 (Cont 1)","index":3,"n_rows":35,"n_cols":10,"rows_kept":35,"cut":false,"hidden":true,"merged":[[20,0,20,7],[23,0,23,7],[24,0,24,7],[27,0,27,7],[5,3,5,8],[9,5,9,9],[16,2,16,7],[17,0,17,1],[19,0,19,7]]}
["STATE OF SOUTH CAROLINA"]
["CLAIMS SUMMARY FORM"]
[null,null,null,null,"At June 30,",{"$f":"IF(Year=\"\",\"\",Year)","v":""}]
[]
[]
["Agency:",{"$f":"IF(AgencyCode=\"\",\"\",AgencyCode)","v":""},null,{"$f":"IF(AgencyName=\"\",\"\",AgencyName)","v":""}]
[null,"Bus. Area",null,"Name"]
[]
[]
["Name of Claim-Paying Program/Type of Self-Insured Risk:"]
[]
[]
["Fund:"]
[]
[]
[]
[null,null,"Description",null,null,null,null,null,"Dollar Amount"]
[]
[]
["Liability for Claims that the agency paid or plans to process for payment in the "]
["     extended 12th period of the current fiscal year (marked as \"Prior Year Payable\").",null,null,null,null,null,null,null,"$"]
[]
[]
["Liability for Claims that the agency plans to pay during period 1 - 12 of"]
["     the next fiscal year.",null,null,null,null,null,null,null,"$"]
[]
[]
["Liability for Claims that the agency plans to pay after June 30 of next fiscal year",null,null,null,null,null,null,null,"$"]
[]
[]
[]
["              Total Claims to be Paid by this Fund",null,null,null,null,null,null,null,"$",{"$f":"J21+J25+J28","v":0}]
[]
[]
["Form 3.15.1,  Rev. 6/30/14"]

{"sheet":"3.15.1 (Cont 2)","index":4,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":true,"merged":[[20,0,20,7],[23,0,23,7],[24,0,24,7],[27,0,27,7],[5,3,5,8],[9,5,9,9],[16,2,16,7],[17,0,17,1],[19,0,19,7]]}
["STATE OF SOUTH CAROLINA"]
["CLAIMS SUMMARY FORM"]
[null,null,null,null,"At June 30,",{"$f":"IF(Year=\"\",\"\",Year)","v":""}]
[]
[]
["Agency:",{"$f":"IF(AgencyCode=\"\",\"\",AgencyCode)","v":""},null,{"$f":"IF(AgencyName=\"\",\"\",AgencyName)","v":""}]
[null,"Bus. Area",null,"Name"]
[]
[]
["Name of Claim-Paying Program/Type of Self-Insured Risk:"]
[]
[]
["Fund:"]
[]
[]
[]
[null,null,"Description",null,null,null,null,null,"Dollar Amount"]
[]
[]
["Liability for Claims that the agency paid or plans to process for payment in the "]
["     extended 12th period of the current fiscal year (marked as \"Prior Year Payable\").",null,null,null,null,null,null,null,"$"]
[]
[]
["Liability for Claims that the agency plans to pay during period 1 - 12 of"]
["     the next fiscal year.",null,null,null,null,null,null,null,"$"]
[]
[]
["Liability for Claims that the agency plans to pay after June 30 of next fiscal year",null,null,null,null,null,null,null,"$"]
[]
[]
[]
["              Total Claims to be Paid by this Fund",null,null,null,null,null,null,null,"$",{"$f":"J21+J25+J28","v":0}]
[]
["Form 3.15.1,  Rev. 6/30/14"]

{"sheet":"3.15.1 (Cont 3)","index":5,"n_rows":35,"n_cols":10,"rows_kept":35,"cut":false,"hidden":true,"merged":[[20,0,20,7],[23,0,23,7],[24,0,24,7],[27,0,27,7],[5,3,5,8],[9,5,9,9],[16,2,16,7],[17,0,17,1],[19,0,19,7]]}
["STATE OF SOUTH CAROLINA"]
["CLAIMS SUMMARY FORM"]
[null,null,null,null,"At June 30,",{"$f":"IF(Year=\"\",\"\",Year)","v":""}]
[]
[]
["Agency:",{"$f":"IF(AgencyCode=\"\",\"\",AgencyCode)","v":""},null,{"$f":"IF(AgencyName=\"\",\"\",AgencyName)","v":""}]
[null,"Bus. Area",null,"Name"]
[]
[]
["Name of Claim-Paying Program/Type of Self-Insured Risk:"]
[]
[]
["Fund:"]
[]
[]
[]
[null,null,"Description",null,null,null,null,null,"Dollar Amount"]
[]
[]
["Liability for Claims that the agency paid or plans to process for payment in the "]
["     extended 12th period of the current fiscal year (marked as \"Prior Year Payable\").",null,null,null,null,null,null,null,"$"]
[]
[]
["Liability for Claims that the agency plans to pay during period 1 - 12 of"]
["     the next fiscal year.",null,null,null,null,null,null,null,"$"]
[]
[]
["Liability for Claims that the agency plans to pay after June 30 of next fiscal year",null,null,null,null,null,null,null,"$"]
[]
[]
[]
["              Total Claims to be Paid by this Fund",null,null,null,null,null,null,null,"$",{"$f":"J21+J25+J28","v":0}]
[]
[]
["Form 3.15.1,  Rev. 6/30/14"]

{"sheet":"3.15.1 (Cont 4)","index":6,"n_rows":34,"n_cols":10,"rows_kept":34,"cut":false,"hidden":true,"merged":[[20,0,20,7],[23,0,23,7],[24,0,24,7],[27,0,27,7],[5,3,5,8],[9,5,9,9],[16,2,16,7],[17,0,17,1],[19,0,19,7]]}
["STATE OF SOUTH CAROLINA"]
["CLAIMS SUMMARY FORM"]
[null,null,null,null,"At June 30,",{"$f":"IF(Year=\"\",\"\",Year)","v":""}]
[]
[]
["Agency:",{"$f":"IF(AgencyCode=\"\",\"\",AgencyCode)","v":""},null,{"$f":"IF(AgencyName=\"\",\"\",AgencyName)","v":""}]
[null,"Bus. Area",null,"Name"]
[]
[]
["Name of Claim-Paying Program/Type of Self-Insured Risk:"]
[]
[]
["Fund:"]
[]
[]
[]
[null,null,"Description",null,null,null,null,null,"Dollar Amount"]
[]
[]
["Liability for Claims that the agency paid or plans to process for payment in the "]
["     extended 12th period of the current fiscal year (marked as \"Prior Year Payable\").",null,null,null,null,null,null,null,"$"]
[]
[]
["Liability for Claims that the agency plans to pay during period 1 - 12 of"]
["     the next fiscal year.",null,null,null,null,null,null,null,"$"]
[]
[]
["Liability for Claims that the agency plans to pay after June 30 of next fiscal year",null,null,null,null,null,null,null,"$"]
[]
[]
[]
["              Total Claims to be Paid by this Fund",null,null,null,null,null,null,null,"$",{"$f":"J21+J25+J28","v":0}]
[]
["Form 3.15.1,  Rev. 6/30/14"]

{"sheet":"3.15.1 (Cont 5)","index":7,"n_rows":36,"n_cols":10,"rows_kept":36,"cut":false,"hidden":true,"merged":[[20,0,20,7],[23,0,23,7],[24,0,24,7],[27,0,27,7],[5,3,5,8],[9,5,9,9],[16,2,16,7],[17,0,17,1],[19,0,19,7]]}
["STATE OF SOUTH CAROLINA"]
["CLAIMS SUMMARY FORM"]
[null,null,null,null,"At June 30,",{"$f":"IF(Year=\"\",\"\",Year)","v":""}]
[]
[]
["Agency:",{"$f":"IF(AgencyCode=\"\",\"\",AgencyCode)","v":""},null,{"$f":"IF(AgencyName=\"\",\"\",AgencyName)","v":""}]
[null,"Bus. Area",null,"Name"]
[]
[]
["Name of Claim-Paying Program/Type of Self-Insured Risk:"]
[]
[]
["Fund:"]
[]
[]
[]
[null,null,"Description",null,null,null,null,null,"Dollar Amount"]
[]
[]
["Liability for Claims that the agency paid or plans to process for payment in the "]
["     extended 12th period of the current fiscal year (marked as \"Prior Year Payable\").",null,null,null,null,null,null,null,"$"]
[]
[]
["Liability for Claims that the agency plans to pay during period 1 - 12 of"]
["     the next fiscal year.",null,null,null,null,null,null,null,"$"]
[]
[]
["Liability for Claims that the agency plans to pay after June 30 of next fiscal year",null,null,null,null,null,null,null,"$"]
[]
[]
[]
["              Total Claims to be Paid by this Fund",null,null,null,null,null,null,null,"$",{"$f":"J21+J25+J28","v":0}]
[]
["Form 3.15.1,  Rev. 6/30/14"]
[]
["NOTE:  If additional space is needed, please contact the Financial Reporting Division of the Comptroller General's office."]

{"sheet":"3.15.2","index":8,"n_rows":51,"n_cols":5,"rows_kept":51,"cut":false,"hidden":false,"merged":[[32,1,35,11],[40,1,43,11],[36,0,36,10],[25,0,25,10],[8,3,8,9],[5,3,5,9],[19,0,19,1],[13,5,13,11],[13,0,13,4],[21,1,24,11]]}
["STATE OF SOUTH CAROLINA"]
["ADDITIONAL CLAIMS INFORMATION FORM"]
[null,null,null,null,"At June 30,"]
[]
[]
["Agency:",{"$f":"IF(AgencyCode=\"\",\"\",AgencyCode)","v":""},null,{"$f":"IF(AgencyName=\"\",\"\",AgencyName)","v":""}]
[null,"Bus. Area",null,"Name"]
[]
["Preparer (Type Name):"]
[]
["Reviewer (Type Name):"]
[]
[]
["Name of Claim-Paying Program/Type of Self-Insured Risk:"]
[]
[]
["Is this the initial (Year-end) report or an update of information:"]
[]
["Date through which the update is provided"]
[]
["Please briefly explain how you compute claims known but not paid for claims in process at the valuation date."]
[]
[]
[]
[]
[]
[]
[]
["Did an actuary compute the IBNR?"]
["If YES, please attach a copy of the actuary's report."]
[]
["If NO, Please briefly explain how you compute claims incurred but not reported (IBNR) at the valuation date."]
[]
[]
[]
[]
[]
["Since the last Additional Claims Information Form you submitted, has anything happened that may"]
["materially change future claims costs?"]
["If \"Yes,\" please explain."]
[]
[]
[]
[]
[]
[]
[]
["Form 3.15.2,  Rev. 6/30/18"]
[]
["Note:  To open an additional five claim information worksheets,"]
["click the following button"]

{"sheet":"3.15.2 (Cont 1)","index":9,"n_rows":43,"n_cols":4,"rows_kept":43,"cut":false,"hidden":true,"merged":[[27,1,30,11],[31,0,31,10],[35,1,38,11],[14,0,14,1],[4,3,4,9],[8,0,8,4],[8,5,8,11],[16,1,19,11],[20,0,20,10]]}
["STATE OF SOUTH CAROLINA"]
["ADDITIONAL CLAIMS INFORMATION FORM"]
[]
[]
["Agency:",{"$f":"IF(AgencyCode=\"\",\"\",AgencyCode)","v":""},null,{"$f":"IF(AgencyName=\"\",\"\",AgencyName)","v":""}]
[null,"Bus. Area",null,"Name"]
[]
[]
["Name of Claim-Paying Program/Type of Self-Insured Risk:"]
[]
[]
["Is this the initial (Year-end) report or an update of information:"]
[]
["Date through which the update is provided"]
[]
["Please briefly explain how you compute claims known but not paid for claims in process at the valuation date."]
[]
[]
[]
[]
[]
[]
[]
["Did an actuary compute the IBNR?"]
["If YES, please attach a copy of the actuary's report."]
[]
["If NO, Please briefly explain how you compute claims incurred but not reported (IBNR) at the valuation date."]
[]
[]
[]
[]
[]
["Since the last Additional Claims Information Form you submitted, has anything happened that may"]
["materially change future claims costs?"]
["If \"Yes,\" please explain."]
[]
[]
[]
[]
[]
[]
[]
["Form 3.15.2,  Rev. 6/30/14"]

{"sheet":"3.15.2 (Cont 2)","index":10,"n_rows":43,"n_cols":4,"rows_kept":43,"cut":false,"hidden":true,"merged":[[27,1,30,11],[31,0,31,10],[35,1,38,11],[14,0,14,1],[4,3,4,9],[8,0,8,4],[8,5,8,11],[16,1,19,11],[20,0,20,10]]}
["STATE OF SOUTH CAROLINA"]
["ADDITIONAL CLAIMS INFORMATION FORM"]
[]
[]
["Agency:",{"$f":"IF(AgencyCode=\"\",\"\",AgencyCode)","v":""},null,{"$f":"IF(AgencyName=\"\",\"\",AgencyName)","v":""}]
[null,"Bus. Area",null,"Name"]
[]
[]
["Name of Claim-Paying Program/Type of Self-Insured Risk:"]
[]
[]
["Is this the initial (Year-end) report or an update of information:"]
[]
["Date through which the update is provided"]
[]
["Please briefly explain how you compute claims known but not paid for claims in process at the valuation date."]
[]
[]
[]
[]
[]
[]
[]
["Did an actuary compute the IBNR?"]
["If YES, please attach a copy of the actuary's report."]
[]
["If NO, Please briefly explain how you compute claims incurred but not reported (IBNR) at the valuation date."]
[]
[]
[]
[]
[]
["Since the last Additional Claims Information Form you submitted, has anything happened that may"]
["materially change future claims costs?"]
["If \"Yes,\" please explain."]
[]
[]
[]
[]
[]
[]
[]
["Form 3.15.2,  Rev. 6/30/14"]

{"sheet":"3.15.2 (Cont 3)","index":11,"n_rows":43,"n_cols":4,"rows_kept":43,"cut":false,"hidden":true,"merged":[[27,1,30,11],[31,0,31,10],[35,1,38,11],[14,0,14,1],[4,3,4,9],[8,0,8,4],[8,5,8,11],[16,1,19,11],[20,0,20,10]]}
["STATE OF SOUTH CAROLINA"]
["ADDITIONAL CLAIMS INFORMATION FORM"]
[]
[]
["Agency:",{"$f":"IF(AgencyCode=\"\",\"\",AgencyCode)","v":""},null,{"$f":"IF(AgencyName=\"\",\"\",AgencyName)","v":""}]
[null,"Bus. Area",null,"Name"]
[]
[]
["Name of Claim-Paying Program/Type of Self-Insured Risk:"]
[]
[]
["Is this the initial (Year-end) report or an update of information:"]
[]
["Date through which the update is provided"]
[]
["Please briefly explain how you compute claims known but not paid for claims in process at the valuation date."]
[]
[]
[]
[]
[]
[]
[]
["Did an actuary compute the IBNR?"]
["If YES, please attach a copy of the actuary's report."]
[]
["If NO, Please briefly explain how you compute claims incurred but not reported (IBNR) at the valuation date."]
[]
[]
[]
[]
[]
["Since the last Additional Claims Information Form you submitted, has anything happened that may"]
["materially change future claims costs?"]
["If \"Yes,\" please explain."]
[]
[]
[]
[]
[]
[]
[]
["Form 3.15.2,  Rev. 6/30/14"]

{"sheet":"3.15.2 (Cont 4)","index":12,"n_rows":43,"n_cols":4,"rows_kept":43,"cut":false,"hidden":true,"merged":[[27,1,30,11],[31,0,31,10],[35,1,38,11],[14,0,14,1],[4,3,4,9],[8,0,8,4],[8,5,8,11],[16,1,19,11],[20,0,20,10]]}
["STATE OF SOUTH CAROLINA"]
["ADDITIONAL CLAIMS INFORMATION FORM"]
[]
[]
["Agency:",{"$f":"IF(AgencyCode=\"\",\"\",AgencyCode)","v":""},null,{"$f":"IF(AgencyName=\"\",\"\",AgencyName)","v":""}]
[null,"Bus. Area",null,"Name"]
[]
[]
["Name of Claim-Paying Program/Type of Self-Insured Risk:"]
[]
[]
["Is this the initial (Year-end) report or an update of information:"]
[]
["Date through which the update is provided"]
[]
["Please briefly explain how you compute claims known but not paid for claims in process at the valuation date."]
[]
[]
[]
[]
[]
[]
[]
["Did an actuary compute the IBNR?"]
["If YES, please attach a copy of the actuary's report."]
[]
["If NO, Please briefly explain how you compute claims incurred but not reported (IBNR) at the valuation date."]
[]
[]
[]
[]
[]
["Since the last Additional Claims Information Form you submitted, has anything happened that may"]
["materially change future claims costs?"]
["If \"Yes,\" please explain."]
[]
[]
[]
[]
[]
[]
[]
["Form 3.15.2,  Rev. 6/30/14"]

{"sheet":"3.15.2 (Cont 5)","index":13,"n_rows":45,"n_cols":4,"rows_kept":45,"cut":false,"hidden":true,"merged":[[44,0,44,11],[14,0,14,1],[4,3,4,9],[8,0,8,4],[8,5,8,11],[16,1,19,11],[20,0,20,10],[27,1,30,11],[31,0,31,10],[35,1,38,11]]}
["STATE OF SOUTH CAROLINA"]
["ADDITIONAL CLAIMS INFORMATION FORM"]
[]
[]
["Agency:",{"$f":"IF(AgencyCode=\"\",\"\",AgencyCode)","v":""},null,{"$f":"IF(AgencyName=\"\",\"\",AgencyName)","v":""}]
[null,"Bus. Area",null,"Name"]
[]
[]
["Name of Claim-Paying Program/Type of Self-Insured Risk:"]
[]
[]
["Is this the initial (Year-end) report or an update of information:"]
[]
["Date through which the update is provided"]
[]
["Please briefly explain how you compute claims known but not paid for claims in process at the valuation date."]
[]
[]
[]
[]
[]
[]
[]
["Did an actuary compute the IBNR?"]
["If YES, please attach a copy of the actuary's report."]
[]
["If NO, Please briefly explain how you compute claims incurred but not reported (IBNR) at the valuation date."]
[]
[]
[]
[]
[]
["Since the last Additional Claims Information Form you submitted, has anything happened that may"]
["materially change future claims costs?"]
["If \"Yes,\" please explain."]
[]
[]
[]
[]
[]
[]
[]
["Form 3.15.2,  Rev. 6/30/14"]
[]
["NOTE:  If additional space is needed, please contact the Financial Reporting Division of the Comptroller General's office."]

{"sheet":"3.15.3","index":14,"n_rows":45,"n_cols":7,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["STATE OF SOUTH CAROLINA"]
["CLAIMS REPORTING PACKAGE"]
["REVIEWER CHECKLIST"]
[null,null,null,null,null,"FISCAL YEAR",{"$f":"'Signature 1'!Year","v":2019}]
[]
["Reviewer's Responses for the Claims Summary Form (Form 3.15.1):"]
[{"$f":"COUNT(A$6:A6)+1","v":1},"Has a separate form been completed for each claim-paying program?"]
[]
[{"$f":"COUNT(A$6:A8)+1","v":2},"Has the claim-paying program or type of self-insured risk been properly identified?"]
[]
[{"$f":"COUNT(A$6:A10)+1","v":3},"Is the fund number provided accurate for the current year and the claim-paying "]
[null,"program?"]
[]
[{"$f":"COUNT(A$6:A13)+1","v":4},"Has the current claims liability been split between amounts to be processed in "]
[null,"the extended period 12 of the current fiscal year and amounts to be paid "]
[null,"during the next fiscal year?"]
[]
["Reviewer's Responses for the Additional Claims Information Form (Form 3.15.2):"]
[{"$f":"COUNT(A$6:A17)+1","v":5},"If the initial reporting, has an equal number of this form been completed for each "]
[null,"completed Form 3.15.1?"]
[]
[{"$f":"COUNT(A$6:A20)+1","v":6},"Is the period for which reporting is being provided accurately reflected?"]
[]
[{"$f":"COUNT(A$6:A22)+1","v":7},"If the subsequent reporting, has the date through which information is being provided"]
[null,"accurately reported?"]
[]
[{"$f":"COUNT(A$6:A25)+1","v":8},"Are the explanations and descriptions provided in sufficient detail for someone "]
[null,"unfamiliar with the operations of the agency and this claim-paying program "]
[null,"to understand?"]
[]
[{"$f":"COUNT(A$6:A29)+1","v":9},"If available, is the Actuarial Report attached to the form for submission?"]
[]
["Reviewer's Responses for All Forms in the Claims Reporting Package:"]
[{"$f":"COUNT(A$6:A32)+1","v":10},"Is the reviewer of the form someone other than the person who prepared it?"]
[]
[{"$f":"COUNT(A$6:A35)+1","v":11},"Is the contact information (title and telephone numbers) for the preparer and "]
[null,"reviewer accurately reported on the summary sheet?"]
[]
[{"$f":"COUNT(A$6:A38)+1","v":12},"Can all amounts reported on the form be traced to the official agency "]
[null,"accounting records?"]
[]
[{"$f":"COUNT(A$6:A41)+1","v":13},"Have the balances and activity reporting been compared with the prior "]
[null,"year, documenting causes for any large fluctuations that can be easily "]
[null,"obtained and explained to individuals not familiar with the daily operations "]
[null,"of the agency?"]

{"sheet":"Summary","index":15,"n_rows":196,"n_cols":7,"rows_kept":196,"cut":false,"hidden":true,"merged":[]}
["Worksheet","Agnecy Code","Agency Name","Year","QUESTION","Cell","Answers"]
["3.15.1",{"$f":"IF(AgencyCode=\"\",\"\",AgencyCode)","v":""},{"$f":"IF(AgencyName=\"\",\"\",AgencyName)","v":""},{"$f":"IF(Year=\"\",\"\",Year)","v":""},"Prepared Date","B9",{"$f":"IF('3.15.1'!#REF!=\"\",\"\",'3.15.1'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1","","","","Preparers Title","D12:F12",{"$f":"IF('3.15.1'!#REF!=\"\",\"\",'3.15.1'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1","","","","Preparers eMail","H9:K9",{"$f":"IF('3.15.1'!#REF!=\"\",\"\",'3.15.1'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1","","","","Preparers Phone No","H12",{"$f":"IF('3.15.1'!#REF!=\"\",\"\",'3.15.1'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1","","","","Approved Date","B14",{"$f":"IF('3.15.1'!#REF!=\"\",\"\",'3.15.1'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1","","","","Approvers Title","D17:F17",{"$f":"IF('3.15.1'!#REF!=\"\",\"\",'3.15.1'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1","","","","Approvers eMail","H14:K14",{"$f":"IF('3.15.1'!#REF!=\"\",\"\",'3.15.1'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1","","","","Approvers Phone No","H17",{"$f":"IF('3.15.1'!#REF!=\"\",\"\",'3.15.1'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1","","","","Name of Claim-Paying Program/Type of Self-Insured Risk:","F20:K20",{"$f":"IF('3.15.1'!F14=\"\",\"\",'3.15.1'!F14)","v":""}]
["3.15.1","","","","Fund:","B23",{"$f":"IF('3.15.1'!B17=\"\",\"\",'3.15.1'!B17)","v":""}]
["3.15.1","","","","Liability for Claims that the agency paid or plans to process for payment in the extended 12th period of the current fiscal year (marked as \"Prior Year Payable\").","J31:K31",{"$f":"IF('3.15.1'!J25=\"\",\"\",'3.15.1'!J25)","v":""}]
["3.15.1","","","","Liability for Claims that the agency plans to pay during period 1 - 12 of  the next fiscal year.","J35:K35",{"$f":"IF('3.15.1'!J29=\"\",\"\",'3.15.1'!J29)","v":""}]
["3.15.1","","","","Liability for Claims that the agency plans to pay after June 30 of next fiscal year","J38:K38",{"$f":"IF('3.15.1'!J32=\"\",\"\",'3.15.1'!J32)","v":""}]
["3.15.1","","","","Total Claims to be Paid by this Fund","J42:K42",{"$f":"IF('3.15.1'!J36=\"\",\"\",'3.15.1'!J36)","v":0}]
["3.15.2","","","","Prepared Date","B8",{"$f":"IF('3.15.2'!#REF!=\"\",\"\",'3.15.2'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2","","","","Preparers Title","D11:G11",{"$f":"IF('3.15.2'!#REF!=\"\",\"\",'3.15.2'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2","","","","Preparers eMail","K8:M8",{"$f":"IF('3.15.2'!#REF!=\"\",\"\",'3.15.2'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2","","","","Preparers Phone No","J11:L11",{"$f":"IF('3.15.2'!#REF!=\"\",\"\",'3.15.2'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2","","","","Approved Date","B13",{"$f":"IF('3.15.2'!#REF!=\"\",\"\",'3.15.2'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2","","","","Approvers Title","D16:G16",{"$f":"IF('3.15.2'!#REF!=\"\",\"\",'3.15.2'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2","","","","Approvers eMail","K13:M13",{"$f":"IF('3.15.2'!#REF!=\"\",\"\",'3.15.2'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2","","","","Approvers Phone No","J16:L16",{"$f":"IF('3.15.2'!#REF!=\"\",\"\",'3.15.2'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2","","","","Name of Claim-Paying Program/Type of Self-Insured Risk:","G19:M19",{"$f":"IF('3.15.2'!F14=\"\",\"\",'3.15.2'!F14)","v":""}]
["3.15.2","","","","Is this the initial (Year-end) report or an update of information:","I22:J22",{"$f":"IF('3.15.2'!H17=\"\",\"\",'3.15.2'!H17)","v":""}]
["3.15.2","","","","Date through which the update is provided","I24",{"$f":"IF('3.15.2'!H19=\"\",\"\",'3.15.2'!H19)","v":""}]
["3.15.2","","","","Please briefly explain how you compute claims known but not paid for claims in process at the valuation date.","B27:M30",{"$f":"IF('3.15.2'!B22=\"\",\"\",'3.15.2'!B22)","v":""}]
["3.15.2","","","","Did an actuary compute the IBNR?","J34",{"$f":"IF('3.15.2'!I29=\"\",\"\",'3.15.2'!I29)","v":""}]
["3.15.2","","","","If NO, Please briefly explain how you compute claims incurred but not reported (IBNR) at the valuation date.","B38:M41",{"$f":"IF('3.15.2'!B33=\"\",\"\",'3.15.2'!B33)","v":""}]
["3.15.2","","","","Since the last Additional Claims Information Form you submitted, has anything happened that may materially change future claims costs?","J44",{"$f":"IF('3.15.2'!I39=\"\",\"\",'3.15.2'!I39)","v":""}]
["3.15.2","","","","If \"Yes,\" please explain.","B46:M49",{"$f":"IF('3.15.2'!B41=\"\",\"\",'3.15.2'!B41)","v":""}]
["3.15.3","","","","Date Last Review Step Was Completed:   ","F8",{"$f":"IF('3.15.3'!#REF!=\"\",\"\",'3.15.3'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.3","","","",1,"K11",{"$f":"IF('3.15.3'!K7=\"\",\"\",'3.15.3'!K7)","v":""}]
["3.15.3","","","",2,"K13",{"$f":"IF('3.15.3'!K9=\"\",\"\",'3.15.3'!K9)","v":""}]
["3.15.3","","","",3,"K16",{"$f":"IF('3.15.3'!K12=\"\",\"\",'3.15.3'!K12)","v":""}]
["3.15.3","","","",4,"K20",{"$f":"IF('3.15.3'!K16=\"\",\"\",'3.15.3'!K16)","v":""}]
["3.15.3","","","",5,"K23",{"$f":"IF('3.15.3'!K19=\"\",\"\",'3.15.3'!K19)","v":""}]
["3.15.3","","","",6,"K26",{"$f":"IF('3.15.3'!K22=\"\",\"\",'3.15.3'!K22)","v":""}]
["3.15.3","","","",7,"K29",{"$f":"IF('3.15.3'!K25=\"\",\"\",'3.15.3'!K25)","v":""}]
["3.15.3","","","",8,"K33",{"$f":"IF('3.15.3'!K29=\"\",\"\",'3.15.3'!K29)","v":""}]
["3.15.3","","","",9,"K35",{"$f":"IF('3.15.3'!K31=\"\",\"\",'3.15.3'!K31)","v":""}]
["3.15.3","","","",10,"K38",{"$f":"IF('3.15.3'!K34=\"\",\"\",'3.15.3'!K34)","v":""}]
["3.15.3","","","",11,"K41",{"$f":"IF('3.15.3'!#REF!=\"\",\"\",'3.15.3'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.3","","","",12,"K44",{"$f":"IF('3.15.3'!K37=\"\",\"\",'3.15.3'!K37)","v":""}]
["3.15.3","","","",13,"K47",{"$f":"IF('3.15.3'!K40=\"\",\"\",'3.15.3'!K40)","v":""}]
["3.15.3","","","",14,"K52",{"$f":"IF('3.15.3'!K45=\"\",\"\",'3.15.3'!K45)","v":""}]
["3.15.1 (Cont 1)","","","","Prepared Date","B9",{"$f":"IF('3.15.1 (Cont 1)'!#REF!=\"\",\"\",'3.15.1 (Cont 1)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1 (Cont 1)","","","","Preparers Title","D12:F12",{"$f":"IF('3.15.1 (Cont 1)'!#REF!=\"\",\"\",'3.15.1 (Cont 1)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1 (Cont 1)","","","","Preparers eMail","H9:K9",{"$f":"IF('3.15.1 (Cont 1)'!#REF!=\"\",\"\",'3.15.1 (Cont 1)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1 (Cont 1)","","","","Preparers Phone No","H12",{"$f":"IF('3.15.1 (Cont 1)'!#REF!=\"\",\"\",'3.15.1 (Cont 1)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1 (Cont 1)","","","","Approved Date","B14",{"$f":"IF('3.15.1 (Cont 1)'!#REF!=\"\",\"\",'3.15.1 (Cont 1)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1 (Cont 1)","","","","Approvers Title","D17:F17",{"$f":"IF('3.15.1 (Cont 1)'!#REF!=\"\",\"\",'3.15.1 (Cont 1)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1 (Cont 1)","","","","Approvers eMail","H14:K14",{"$f":"IF('3.15.1 (Cont 1)'!#REF!=\"\",\"\",'3.15.1 (Cont 1)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1 (Cont 1)","","","","Approvers Phone No","H17",{"$f":"IF('3.15.1 (Cont 1)'!#REF!=\"\",\"\",'3.15.1 (Cont 1)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1 (Cont 1)","","","","Name of Claim-Paying Program/Type of Self-Insured Risk:","F20:K20",{"$f":"IF('3.15.1 (Cont 1)'!F10=\"\",\"\",'3.15.1 (Cont 1)'!F10)","v":""}]
["3.15.1 (Cont 1)","","","","Fund:","B23",{"$f":"IF('3.15.1 (Cont 1)'!B13=\"\",\"\",'3.15.1 (Cont 1)'!B13)","v":""}]
["3.15.1 (Cont 1)","","","","Liability for Claims that the agency paid or plans to process for payment in the extended 12th period of the current fiscal year (marked as \"Prior Year Payable\").","J31:K31",{"$f":"IF('3.15.1 (Cont 1)'!J21=\"\",\"\",'3.15.1 (Cont 1)'!J21)","v":""}]
["3.15.1 (Cont 1)","","","","Liability for Claims that the agency plans to pay during period 1 - 12 of  the next fiscal year.","J35:K35",{"$f":"IF('3.15.1 (Cont 1)'!J25=\"\",\"\",'3.15.1 (Cont 1)'!J25)","v":""}]
["3.15.1 (Cont 1)","","","","Liability for Claims that the agency plans to pay after June 30 of next fiscal year","J38:K38",{"$f":"IF('3.15.1 (Cont 1)'!J28=\"\",\"\",'3.15.1 (Cont 1)'!J28)","v":""}]
["3.15.1 (Cont 1)","","","","Total Claims to be Paid by this Fund","J42:K42",{"$f":"IF('3.15.1 (Cont 1)'!J32=\"\",\"\",'3.15.1 (Cont 1)'!J32)","v":0}]
["3.15.1 (Cont 2)","","","","Prepared Date","B9",{"$f":"IF('3.15.1 (Cont 2)'!#REF!=\"\",\"\",'3.15.1 (Cont 2)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1 (Cont 2)","","","","Preparers Title","D12:F12",{"$f":"IF('3.15.1 (Cont 2)'!#REF!=\"\",\"\",'3.15.1 (Cont 2)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1 (Cont 2)","","","","Preparers eMail","H9:K9",{"$f":"IF('3.15.1 (Cont 2)'!#REF!=\"\",\"\",'3.15.1 (Cont 2)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1 (Cont 2)","","","","Preparers Phone No","H12",{"$f":"IF('3.15.1 (Cont 2)'!#REF!=\"\",\"\",'3.15.1 (Cont 2)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1 (Cont 2)","","","","Approved Date","B14",{"$f":"IF('3.15.1 (Cont 2)'!#REF!=\"\",\"\",'3.15.1 (Cont 2)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1 (Cont 2)",{"$f":"IF(AgencyCode=\"\",\"\",AgencyCode)","v":""},{"$f":"IF(AgencyName=\"\",\"\",AgencyName)","v":""},{"$f":"IF(Year=\"\",\"\",Year)","v":""},"Approvers Title","D17:F17",{"$f":"IF('3.15.1 (Cont 2)'!#REF!=\"\",\"\",'3.15.1 (Cont 2)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1 (Cont 2)","","","","Approvers eMail","H14:K14",{"$f":"IF('3.15.1 (Cont 2)'!#REF!=\"\",\"\",'3.15.1 (Cont 2)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1 (Cont 2)","","","","Approvers Phone No","H17",{"$f":"IF('3.15.1 (Cont 2)'!#REF!=\"\",\"\",'3.15.1 (Cont 2)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1 (Cont 2)","","","","Name of Claim-Paying Program/Type of Self-Insured Risk:","F20:K20",{"$f":"IF('3.15.1 (Cont 2)'!F10=\"\",\"\",'3.15.1 (Cont 2)'!F10)","v":""}]
["3.15.1 (Cont 2)","","","","Fund:","B23",{"$f":"IF('3.15.1 (Cont 2)'!B13=\"\",\"\",'3.15.1 (Cont 2)'!B13)","v":""}]
["3.15.1 (Cont 2)","","","","Liability for Claims that the agency paid or plans to process for payment in the extended 12th period of the current fiscal year (marked as \"Prior Year Payable\").","J31:K31",{"$f":"IF('3.15.1 (Cont 2)'!J21=\"\",\"\",'3.15.1 (Cont 2)'!J21)","v":""}]
["3.15.1 (Cont 2)","","","","Liability for Claims that the agency plans to pay during period 1 - 12 of  the next fiscal year.","J35:K35",{"$f":"IF('3.15.1 (Cont 2)'!J25=\"\",\"\",'3.15.1 (Cont 2)'!J25)","v":""}]
["3.15.1 (Cont 2)","","","","Liability for Claims that the agency plans to pay after June 30 of next fiscal year","J38:K38",{"$f":"IF('3.15.1 (Cont 2)'!J28=\"\",\"\",'3.15.1 (Cont 2)'!J28)","v":""}]
["3.15.1 (Cont 2)","","","","Total Claims to be Paid by this Fund","J42:K42",{"$f":"IF('3.15.1 (Cont 2)'!J32=\"\",\"\",'3.15.1 (Cont 2)'!J32)","v":0}]
["3.15.1 (Cont 3)","","","","Prepared Date","B9",{"$f":"IF('3.15.1 (Cont 3)'!#REF!=\"\",\"\",'3.15.1 (Cont 3)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1 (Cont 3)","","","","Preparers Title","D12:F12",{"$f":"IF('3.15.1 (Cont 3)'!#REF!=\"\",\"\",'3.15.1 (Cont 3)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1 (Cont 3)","","","","Preparers eMail","H9:K9",{"$f":"IF('3.15.1 (Cont 3)'!#REF!=\"\",\"\",'3.15.1 (Cont 3)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1 (Cont 3)","","","","Preparers Phone No","H12",{"$f":"IF('3.15.1 (Cont 3)'!#REF!=\"\",\"\",'3.15.1 (Cont 3)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1 (Cont 3)","","","","Approved Date","B14",{"$f":"IF('3.15.1 (Cont 3)'!#REF!=\"\",\"\",'3.15.1 (Cont 3)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1 (Cont 3)","","","","Approvers Title","D17:F17",{"$f":"IF('3.15.1 (Cont 3)'!#REF!=\"\",\"\",'3.15.1 (Cont 3)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1 (Cont 3)","","","","Approvers eMail","H14:K14",{"$f":"IF('3.15.1 (Cont 3)'!#REF!=\"\",\"\",'3.15.1 (Cont 3)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1 (Cont 3)","","","","Approvers Phone No","H17",{"$f":"IF('3.15.1 (Cont 3)'!#REF!=\"\",\"\",'3.15.1 (Cont 3)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1 (Cont 3)","","","","Name of Claim-Paying Program/Type of Self-Insured Risk:","F20:K20",{"$f":"IF('3.15.1 (Cont 3)'!F10=\"\",\"\",'3.15.1 (Cont 3)'!F10)","v":""}]
["3.15.1 (Cont 3)","","","","Fund:","B23",{"$f":"IF('3.15.1 (Cont 3)'!B13=\"\",\"\",'3.15.1 (Cont 3)'!B13)","v":""}]
["3.15.1 (Cont 3)","","","","Liability for Claims that the agency paid or plans to process for payment in the extended 12th period of the current fiscal year (marked as \"Prior Year Payable\").","J31:K31",{"$f":"IF('3.15.1 (Cont 3)'!J21=\"\",\"\",'3.15.1 (Cont 3)'!J21)","v":""}]
["3.15.1 (Cont 3)","","","","Liability for Claims that the agency plans to pay during period 1 - 12 of  the next fiscal year.","J35:K35",{"$f":"IF('3.15.1 (Cont 3)'!J25=\"\",\"\",'3.15.1 (Cont 3)'!J25)","v":""}]
["3.15.1 (Cont 3)","","","","Liability for Claims that the agency plans to pay after June 30 of next fiscal year","J38:K38",{"$f":"IF('3.15.1 (Cont 3)'!J28=\"\",\"\",'3.15.1 (Cont 3)'!J28)","v":""}]
["3.15.1 (Cont 3)","","","","Total Claims to be Paid by this Fund","J42:K42",{"$f":"IF('3.15.1 (Cont 3)'!J32=\"\",\"\",'3.15.1 (Cont 3)'!J32)","v":0}]
["3.15.1 (Cont 4)","","","","Prepared Date","B9",{"$f":"IF('3.15.1 (Cont 4)'!#REF!=\"\",\"\",'3.15.1 (Cont 4)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1 (Cont 4)","","","","Preparers Title","D12:F12",{"$f":"IF('3.15.1 (Cont 4)'!#REF!=\"\",\"\",'3.15.1 (Cont 4)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1 (Cont 4)","","","","Preparers eMail","H9:K9",{"$f":"IF('3.15.1 (Cont 4)'!#REF!=\"\",\"\",'3.15.1 (Cont 4)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1 (Cont 4)","","","","Preparers Phone No","H12",{"$f":"IF('3.15.1 (Cont 4)'!#REF!=\"\",\"\",'3.15.1 (Cont 4)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1 (Cont 4)","","","","Approved Date","B14",{"$f":"IF('3.15.1 (Cont 4)'!#REF!=\"\",\"\",'3.15.1 (Cont 4)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1 (Cont 4)","","","","Approvers Title","D17:F17",{"$f":"IF('3.15.1 (Cont 4)'!#REF!=\"\",\"\",'3.15.1 (Cont 4)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1 (Cont 4)","","","","Approvers eMail","H14:K14",{"$f":"IF('3.15.1 (Cont 4)'!#REF!=\"\",\"\",'3.15.1 (Cont 4)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1 (Cont 4)","","","","Approvers Phone No","H17",{"$f":"IF('3.15.1 (Cont 4)'!#REF!=\"\",\"\",'3.15.1 (Cont 4)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1 (Cont 4)","","","","Name of Claim-Paying Program/Type of Self-Insured Risk:","F20:K20",{"$f":"IF('3.15.1 (Cont 4)'!F10=\"\",\"\",'3.15.1 (Cont 4)'!F10)","v":""}]
["3.15.1 (Cont 4)","","","","Fund:","B23",{"$f":"IF('3.15.1 (Cont 4)'!B13=\"\",\"\",'3.15.1 (Cont 4)'!B13)","v":""}]
["3.15.1 (Cont 4)","","","","Liability for Claims that the agency paid or plans to process for payment in the extended 12th period of the current fiscal year (marked as \"Prior Year Payable\").","J31:K31",{"$f":"IF('3.15.1 (Cont 4)'!J21=\"\",\"\",'3.15.1 (Cont 4)'!J21)","v":""}]
["3.15.1 (Cont 4)","","","","Liability for Claims that the agency plans to pay during period 1 - 12 of  the next fiscal year.","J35:K35",{"$f":"IF('3.15.1 (Cont 4)'!J25=\"\",\"\",'3.15.1 (Cont 4)'!J25)","v":""}]
["3.15.1 (Cont 4)","","","","Liability for Claims that the agency plans to pay after June 30 of next fiscal year","J38:K38",{"$f":"IF('3.15.1 (Cont 4)'!J28=\"\",\"\",'3.15.1 (Cont 4)'!J28)","v":""}]
["3.15.1 (Cont 4)","","","","Total Claims to be Paid by this Fund","J42:K42",{"$f":"IF('3.15.1 (Cont 4)'!J32=\"\",\"\",'3.15.1 (Cont 4)'!J32)","v":0}]
["3.15.1 (Cont 5)","","","","Prepared Date","B9",{"$f":"IF('3.15.1 (Cont 5)'!#REF!=\"\",\"\",'3.15.1 (Cont 5)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1 (Cont 5)","","","","Preparers Title","D12:F12",{"$f":"IF('3.15.1 (Cont 5)'!#REF!=\"\",\"\",'3.15.1 (Cont 5)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1 (Cont 5)","","","","Preparers eMail","H9:K9",{"$f":"IF('3.15.1 (Cont 5)'!#REF!=\"\",\"\",'3.15.1 (Cont 5)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1 (Cont 5)","","","","Preparers Phone No","H12",{"$f":"IF('3.15.1 (Cont 5)'!#REF!=\"\",\"\",'3.15.1 (Cont 5)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1 (Cont 5)","","","","Approved Date","B14",{"$f":"IF('3.15.1 (Cont 5)'!#REF!=\"\",\"\",'3.15.1 (Cont 5)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1 (Cont 5)","","","","Approvers Title","D17:F17",{"$f":"IF('3.15.1 (Cont 5)'!#REF!=\"\",\"\",'3.15.1 (Cont 5)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1 (Cont 5)","","","","Approvers eMail","H14:K14",{"$f":"IF('3.15.1 (Cont 5)'!#REF!=\"\",\"\",'3.15.1 (Cont 5)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1 (Cont 5)","","","","Approvers Phone No","H17",{"$f":"IF('3.15.1 (Cont 5)'!#REF!=\"\",\"\",'3.15.1 (Cont 5)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.1 (Cont 5)","","","","Name of Claim-Paying Program/Type of Self-Insured Risk:","F20:K20",{"$f":"IF('3.15.1 (Cont 5)'!F10=\"\",\"\",'3.15.1 (Cont 5)'!F10)","v":""}]
["3.15.1 (Cont 5)","","","","Fund:","B23",{"$f":"IF('3.15.1 (Cont 5)'!B13=\"\",\"\",'3.15.1 (Cont 5)'!B13)","v":""}]
["3.15.1 (Cont 5)","","","","Liability for Claims that the agency paid or plans to process for payment in the extended 12th period of the current fiscal year (marked as \"Prior Year Payable\").","J31:K31",{"$f":"IF('3.15.1 (Cont 5)'!J21=\"\",\"\",'3.15.1 (Cont 5)'!J21)","v":""}]
["3.15.1 (Cont 5)","","","","Liability for Claims that the agency plans to pay during period 1 - 12 of  the next fiscal year.","J35:K35",{"$f":"IF('3.15.1 (Cont 5)'!J25=\"\",\"\",'3.15.1 (Cont 5)'!J25)","v":""}]
["3.15.1 (Cont 5)","","","","Liability for Claims that the agency plans to pay after June 30 of next fiscal year","J38:K38",{"$f":"IF('3.15.1 (Cont 5)'!J28=\"\",\"\",'3.15.1 (Cont 5)'!J28)","v":""}]
["3.15.1 (Cont 5)","","","","Total Claims to be Paid by this Fund","J42:K42",{"$f":"IF('3.15.1 (Cont 5)'!J32=\"\",\"\",'3.15.1 (Cont 5)'!J32)","v":0}]
["3.15.2 (Cont 1)","","","","Prepared Date","B8",{"$f":"IF('3.15.2 (Cont 1)'!#REF!=\"\",\"\",'3.15.2 (Cont 1)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2 (Cont 1)","","","","Preparers Title","D11:G11",{"$f":"IF('3.15.2 (Cont 1)'!#REF!=\"\",\"\",'3.15.2 (Cont 1)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2 (Cont 1)","","","","Preparers eMail","K8:M8",{"$f":"IF('3.15.2 (Cont 1)'!#REF!=\"\",\"\",'3.15.2 (Cont 1)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2 (Cont 1)","","","","Preparers Phone No","J11:L11",{"$f":"IF('3.15.2 (Cont 1)'!#REF!=\"\",\"\",'3.15.2 (Cont 1)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2 (Cont 1)","","","","Approved Date","B13",{"$f":"IF('3.15.2 (Cont 1)'!#REF!=\"\",\"\",'3.15.2 (Cont 1)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2 (Cont 1)","","","","Approvers Title","D16:G16",{"$f":"IF('3.15.2 (Cont 1)'!#REF!=\"\",\"\",'3.15.2 (Cont 1)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2 (Cont 1)","","","","Approvers eMail","K13:M13",{"$f":"IF('3.15.2 (Cont 1)'!#REF!=\"\",\"\",'3.15.2 (Cont 1)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2 (Cont 1)","","","","Approvers Phone No","J16:L16",{"$f":"IF('3.15.2 (Cont 1)'!#REF!=\"\",\"\",'3.15.2 (Cont 1)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2 (Cont 1)","","","","Name of Claim-Paying Program/Type of Self-Insured Risk:","G19:M19",{"$f":"IF('3.15.2 (Cont 1)'!F9=\"\",\"\",'3.15.2 (Cont 1)'!F9)","v":""}]
["3.15.2 (Cont 1)","","","","Is this the initial (Year-end) report or an update of information:","I22:J22",{"$f":"IF('3.15.2 (Cont 1)'!H12=\"\",\"\",'3.15.2 (Cont 1)'!H12)","v":""}]
["3.15.2 (Cont 1)","","","","Date through which the update is provided","I24",{"$f":"IF('3.15.2 (Cont 1)'!H14=\"\",\"\",'3.15.2 (Cont 1)'!H14)","v":""}]
["3.15.2 (Cont 1)","","","","Please briefly explain how you compute claims known but not paid for claims in process at the valuation date.","B27:M30",{"$f":"IF('3.15.2 (Cont 1)'!B17=\"\",\"\",'3.15.2 (Cont 1)'!B17)","v":""}]
["3.15.2 (Cont 1)","","","","Did an actuary compute the IBNR?","J34",{"$f":"IF('3.15.2 (Cont 1)'!I24=\"\",\"\",'3.15.2 (Cont 1)'!I24)","v":""}]
["3.15.2 (Cont 1)",{"$f":"IF(AgencyCode=\"\",\"\",AgencyCode)","v":""},{"$f":"IF(AgencyName=\"\",\"\",AgencyName)","v":""},{"$f":"IF(Year=\"\",\"\",Year)","v":""},"If NO, Please briefly explain how you compute claims incurred but not reported (IBNR) at the valuation date.","B38:M41",{"$f":"IF('3.15.2 (Cont 1)'!B28=\"\",\"\",'3.15.2 (Cont 1)'!B28)","v":""}]
["3.15.2 (Cont 1)","","","","Since the last Additional Claims Information Form you submitted, has anything happened that may materially change future claims costs?","J44",{"$f":"IF('3.15.2 (Cont 1)'!I34=\"\",\"\",'3.15.2 (Cont 1)'!I34)","v":""}]
["3.15.2 (Cont 1)","","","","If \"Yes,\" please explain.","B46:M49",{"$f":"IF('3.15.2 (Cont 1)'!B36=\"\",\"\",'3.15.2 (Cont 1)'!B36)","v":""}]
["3.15.2 (Cont 2)","","","","Prepared Date","B8",{"$f":"IF('3.15.2 (Cont 2)'!#REF!=\"\",\"\",'3.15.2 (Cont 2)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2 (Cont 2)","","","","Preparers Title","D11:G11",{"$f":"IF('3.15.2 (Cont 2)'!#REF!=\"\",\"\",'3.15.2 (Cont 2)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2 (Cont 2)","","","","Preparers eMail","K8:M8",{"$f":"IF('3.15.2 (Cont 2)'!#REF!=\"\",\"\",'3.15.2 (Cont 2)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2 (Cont 2)","","","","Preparers Phone No","J11:L11",{"$f":"IF('3.15.2 (Cont 2)'!#REF!=\"\",\"\",'3.15.2 (Cont 2)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2 (Cont 2)","","","","Approved Date","B13",{"$f":"IF('3.15.2 (Cont 2)'!#REF!=\"\",\"\",'3.15.2 (Cont 2)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2 (Cont 2)","","","","Approvers Title","D16:G16",{"$f":"IF('3.15.2 (Cont 2)'!#REF!=\"\",\"\",'3.15.2 (Cont 2)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2 (Cont 2)","","","","Approvers eMail","K13:M13",{"$f":"IF('3.15.2 (Cont 2)'!#REF!=\"\",\"\",'3.15.2 (Cont 2)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2 (Cont 2)","","","","Approvers Phone No","J16:L16",{"$f":"IF('3.15.2 (Cont 2)'!#REF!=\"\",\"\",'3.15.2 (Cont 2)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2 (Cont 2)","","","","Name of Claim-Paying Program/Type of Self-Insured Risk:","G19:M19",{"$f":"IF('3.15.2 (Cont 2)'!F9=\"\",\"\",'3.15.2 (Cont 2)'!F9)","v":""}]
["3.15.2 (Cont 2)","","","","Is this the initial (Year-end) report or an update of information:","I22:J22",{"$f":"IF('3.15.2 (Cont 2)'!H12=\"\",\"\",'3.15.2 (Cont 2)'!H12)","v":""}]
["3.15.2 (Cont 2)","","","","Date through which the update is provided","I24",{"$f":"IF('3.15.2 (Cont 2)'!H14=\"\",\"\",'3.15.2 (Cont 2)'!H14)","v":""}]
["3.15.2 (Cont 2)","","","","Please briefly explain how you compute claims known but not paid for claims in process at the valuation date.","B27:M30",{"$f":"IF('3.15.2 (Cont 2)'!B17=\"\",\"\",'3.15.2 (Cont 2)'!B17)","v":""}]
["3.15.2 (Cont 2)","","","","Did an actuary compute the IBNR?","J34",{"$f":"IF('3.15.2 (Cont 2)'!I24=\"\",\"\",'3.15.2 (Cont 2)'!I24)","v":""}]
["3.15.2 (Cont 2)","","","","If NO, Please briefly explain how you compute claims incurred but not reported (IBNR) at the valuation date.","B38:M41",{"$f":"IF('3.15.2 (Cont 2)'!B28=\"\",\"\",'3.15.2 (Cont 2)'!B28)","v":""}]
["3.15.2 (Cont 2)","","","","Since the last Additional Claims Information Form you submitted, has anything happened that may materially change future claims costs?","J44",{"$f":"IF('3.15.2 (Cont 2)'!I34=\"\",\"\",'3.15.2 (Cont 2)'!I34)","v":""}]
["3.15.2 (Cont 2)","","","","If \"Yes,\" please explain.","B46:M49",{"$f":"IF('3.15.2 (Cont 2)'!B36=\"\",\"\",'3.15.2 (Cont 2)'!B36)","v":""}]
["3.15.2 (Cont 3)","","","","Prepared Date","B8",{"$f":"IF('3.15.2 (Cont 3)'!#REF!=\"\",\"\",'3.15.2 (Cont 3)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2 (Cont 3)","","","","Preparers Title","D11:G11",{"$f":"IF('3.15.2 (Cont 3)'!#REF!=\"\",\"\",'3.15.2 (Cont 3)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2 (Cont 3)","","","","Preparers eMail","K8:M8",{"$f":"IF('3.15.2 (Cont 3)'!#REF!=\"\",\"\",'3.15.2 (Cont 3)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2 (Cont 3)","","","","Preparers Phone No","J11:L11",{"$f":"IF('3.15.2 (Cont 3)'!#REF!=\"\",\"\",'3.15.2 (Cont 3)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2 (Cont 3)","","","","Approved Date","B13",{"$f":"IF('3.15.2 (Cont 3)'!#REF!=\"\",\"\",'3.15.2 (Cont 3)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2 (Cont 3)","","","","Approvers Title","D16:G16",{"$f":"IF('3.15.2 (Cont 3)'!#REF!=\"\",\"\",'3.15.2 (Cont 3)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2 (Cont 3)","","","","Approvers eMail","K13:M13",{"$f":"IF('3.15.2 (Cont 3)'!#REF!=\"\",\"\",'3.15.2 (Cont 3)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2 (Cont 3)","","","","Approvers Phone No","J16:L16",{"$f":"IF('3.15.2 (Cont 3)'!#REF!=\"\",\"\",'3.15.2 (Cont 3)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2 (Cont 3)","","","","Name of Claim-Paying Program/Type of Self-Insured Risk:","G19:M19",{"$f":"IF('3.15.2 (Cont 3)'!F9=\"\",\"\",'3.15.2 (Cont 3)'!F9)","v":""}]
["3.15.2 (Cont 3)","","","","Is this the initial (Year-end) report or an update of information:","I22:J22",{"$f":"IF('3.15.2 (Cont 3)'!H12=\"\",\"\",'3.15.2 (Cont 3)'!H12)","v":""}]
["3.15.2 (Cont 3)","","","","Date through which the update is provided","I24",{"$f":"IF('3.15.2 (Cont 3)'!H14=\"\",\"\",'3.15.2 (Cont 3)'!H14)","v":""}]
["3.15.2 (Cont 3)","","","","Please briefly explain how you compute claims known but not paid for claims in process at the valuation date.","B27:M30",{"$f":"IF('3.15.2 (Cont 3)'!B17=\"\",\"\",'3.15.2 (Cont 3)'!B17)","v":""}]
["3.15.2 (Cont 3)","","","","Did an actuary compute the IBNR?","J34",{"$f":"IF('3.15.2 (Cont 3)'!I24=\"\",\"\",'3.15.2 (Cont 3)'!I24)","v":""}]
["3.15.2 (Cont 3)","","","","If NO, Please briefly explain how you compute claims incurred but not reported (IBNR) at the valuation date.","B38:M41",{"$f":"IF('3.15.2 (Cont 3)'!B28=\"\",\"\",'3.15.2 (Cont 3)'!B28)","v":""}]
["3.15.2 (Cont 3)","","","","Since the last Additional Claims Information Form you submitted, has anything happened that may materially change future claims costs?","J44",{"$f":"IF('3.15.2 (Cont 3)'!I34=\"\",\"\",'3.15.2 (Cont 3)'!I34)","v":""}]
["3.15.2 (Cont 3)","","","","If \"Yes,\" please explain.","B46:M49",{"$f":"IF('3.15.2 (Cont 3)'!B36=\"\",\"\",'3.15.2 (Cont 3)'!B36)","v":""}]
["3.15.2 (Cont 4)","","","","Prepared Date","B8",{"$f":"IF('3.15.2 (Cont 4)'!#REF!=\"\",\"\",'3.15.2 (Cont 4)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2 (Cont 4)","","","","Preparers Title","D11:G11",{"$f":"IF('3.15.2 (Cont 4)'!#REF!=\"\",\"\",'3.15.2 (Cont 4)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2 (Cont 4)","","","","Preparers eMail","K8:M8",{"$f":"IF('3.15.2 (Cont 4)'!#REF!=\"\",\"\",'3.15.2 (Cont 4)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2 (Cont 4)","","","","Preparers Phone No","J11:L11",{"$f":"IF('3.15.2 (Cont 4)'!#REF!=\"\",\"\",'3.15.2 (Cont 4)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2 (Cont 4)","","","","Approved Date","B13",{"$f":"IF('3.15.2 (Cont 4)'!#REF!=\"\",\"\",'3.15.2 (Cont 4)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2 (Cont 4)","","","","Approvers Title","D16:G16",{"$f":"IF('3.15.2 (Cont 4)'!#REF!=\"\",\"\",'3.15.2 (Cont 4)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2 (Cont 4)","","","","Approvers eMail","K13:M13",{"$f":"IF('3.15.2 (Cont 4)'!#REF!=\"\",\"\",'3.15.2 (Cont 4)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2 (Cont 4)","","","","Approvers Phone No","J16:L16",{"$f":"IF('3.15.2 (Cont 4)'!#REF!=\"\",\"\",'3.15.2 (Cont 4)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2 (Cont 4)","","","","Name of Claim-Paying Program/Type of Self-Insured Risk:","G19:M19",{"$f":"IF('3.15.2 (Cont 4)'!F9=\"\",\"\",'3.15.2 (Cont 4)'!F9)","v":""}]
["3.15.2 (Cont 4)","","","","Is this the initial (Year-end) report or an update of information:","I22:J22",{"$f":"IF('3.15.2 (Cont 4)'!H12=\"\",\"\",'3.15.2 (Cont 4)'!H12)","v":""}]
["3.15.2 (Cont 4)","","","","Date through which the update is provided","I24",{"$f":"IF('3.15.2 (Cont 4)'!H14=\"\",\"\",'3.15.2 (Cont 4)'!H14)","v":""}]
["3.15.2 (Cont 4)","","","","Please briefly explain how you compute claims known but not paid for claims in process at the valuation date.","B27:M30",{"$f":"IF('3.15.2 (Cont 4)'!B17=\"\",\"\",'3.15.2 (Cont 4)'!B17)","v":""}]
["3.15.2 (Cont 4)","","","","Did an actuary compute the IBNR?","J34",{"$f":"IF('3.15.2 (Cont 4)'!I24=\"\",\"\",'3.15.2 (Cont 4)'!I24)","v":""}]
["3.15.2 (Cont 4)","","","","If NO, Please briefly explain how you compute claims incurred but not reported (IBNR) at the valuation date.","B38:M41",{"$f":"IF('3.15.2 (Cont 4)'!B28=\"\",\"\",'3.15.2 (Cont 4)'!B28)","v":""}]
["3.15.2 (Cont 4)","","","","Since the last Additional Claims Information Form you submitted, has anything happened that may materially change future claims costs?","J44",{"$f":"IF('3.15.2 (Cont 4)'!I34=\"\",\"\",'3.15.2 (Cont 4)'!I34)","v":""}]
["3.15.2 (Cont 4)","","","","If \"Yes,\" please explain.","B46:M49",{"$f":"IF('3.15.2 (Cont 4)'!B36=\"\",\"\",'3.15.2 (Cont 4)'!B36)","v":""}]
["3.15.2 (Cont 5)","","","","Prepared Date","B8",{"$f":"IF('3.15.2 (Cont 5)'!#REF!=\"\",\"\",'3.15.2 (Cont 5)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2 (Cont 5)","","","","Preparers Title","D11:G11",{"$f":"IF('3.15.2 (Cont 5)'!#REF!=\"\",\"\",'3.15.2 (Cont 5)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2 (Cont 5)","","","","Preparers eMail","K8:M8",{"$f":"IF('3.15.2 (Cont 5)'!#REF!=\"\",\"\",'3.15.2 (Cont 5)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2 (Cont 5)","","","","Preparers Phone No","J11:L11",{"$f":"IF('3.15.2 (Cont 5)'!#REF!=\"\",\"\",'3.15.2 (Cont 5)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2 (Cont 5)","","","","Approved Date","B13",{"$f":"IF('3.15.2 (Cont 5)'!#REF!=\"\",\"\",'3.15.2 (Cont 5)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2 (Cont 5)","","","","Approvers Title","D16:G16",{"$f":"IF('3.15.2 (Cont 5)'!#REF!=\"\",\"\",'3.15.2 (Cont 5)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2 (Cont 5)","","","","Approvers eMail","K13:M13",{"$f":"IF('3.15.2 (Cont 5)'!#REF!=\"\",\"\",'3.15.2 (Cont 5)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2 (Cont 5)","","","","Approvers Phone No","J16:L16",{"$f":"IF('3.15.2 (Cont 5)'!#REF!=\"\",\"\",'3.15.2 (Cont 5)'!#REF!)","v":{"$error":"#REF!"}}]
["3.15.2 (Cont 5)","","","","Name of Claim-Paying Program/Type of Self-Insured Risk:","G19:M19",{"$f":"IF('3.15.2 (Cont 5)'!F9=\"\",\"\",'3.15.2 (Cont 5)'!F9)","v":""}]
["3.15.2 (Cont 5)","","","","Is this the initial (Year-end) report or an update of information:","I22:J22",{"$f":"IF('3.15.2 (Cont 5)'!H12=\"\",\"\",'3.15.2 (Cont 5)'!H12)","v":""}]
["3.15.2 (Cont 5)","","","","Date through which the update is provided","I24",{"$f":"IF('3.15.2 (Cont 5)'!H14=\"\",\"\",'3.15.2 (Cont 5)'!H14)","v":""}]
["3.15.2 (Cont 5)","","","","Please briefly explain how you compute claims known but not paid for claims in process at the valuation date.","B27:M30",{"$f":"IF('3.15.2 (Cont 5)'!B17=\"\",\"\",'3.15.2 (Cont 5)'!B17)","v":""}]
["3.15.2 (Cont 5)","","","","Did an actuary compute the IBNR?","J34",{"$f":"IF('3.15.2 (Cont 5)'!I24=\"\",\"\",'3.15.2 (Cont 5)'!I24)","v":""}]
["3.15.2 (Cont 5)",{"$f":"IF(AgencyCode=\"\",\"\",AgencyCode)","v":""},{"$f":"IF(AgencyName=\"\",\"\",AgencyName)","v":""},{"$f":"IF(Year=\"\",\"\",Year)","v":""},"If NO, Please briefly explain how you compute claims incurred but not reported (IBNR) at the valuation date.","B38:M41",{"$f":"IF('3.15.2 (Cont 5)'!B28=\"\",\"\",'3.15.2 (Cont 5)'!B28)","v":""}]
["3.15.2 (Cont 5)","","","","Since the last Additional Claims Information Form you submitted, has anything happened that may materially change future claims costs?","J44",{"$f":"IF('3.15.2 (Cont 5)'!I34=\"\",\"\",'3.15.2 (Cont 5)'!I34)","v":""}]
["3.15.2 (Cont 5)","","","","If \"Yes,\" please explain.","B46:M49",{"$f":"IF('3.15.2 (Cont 5)'!B36=\"\",\"\",'3.15.2 (Cont 5)'!B36)","v":""}]