{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","Signature 1","3.13.1","3.13.2","3.13.3","3.13.4","3.13.5"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":13,"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":163,"n_cols":10,"rows_kept":163,"cut":false,"hidden":false,"merged":[[162,1,162,11],[48,1,48,12]]}
["STATE OF SOUTH CAROLINA"]
["YEAR-END REPORTING PROCEDURES MANUAL"]
["SECTION 3.13, LITIGATION REPORTING PACKAGE"]
[]
[]
[null,"PURPOSE and OBJECTIVE:"]
[null,"Agency personnel is the best source for information required for disclosure which is not available in the"]
[null,"accounting general ledger or subsidiary ledgers.  Litigation, contingencies, and related activity is an area"]
[null,"where reliance on the knowledge of agency personnel is essential.  This reporting package provides"]
[null,"information relating to situations arising or changing during the year and subsequent to year-end where"]
[null,"the agency has consulted private attorney's for legal advice or representation."]
[]
[null,"Please refer to the Reporting Policies and Procedures Manual for definitions of terms included on the forms, "]
[null,"conceptual discussions of the situations, policies and procedures of the State of South Carolina, and the"]
[null,"required GAAP and other reporting guidance followed by the State of South Carolina."]
[]
[null,"Additional guidance is provided by the American Bar Association and the Financial Accounting Standards "]
[null,"Board Accounting Standards Codifications."]
[]
[null,"INSTRUCTIONS FOR COMPLETION OF FORMS:"]
[null,"Litigation Related Expense Explanations",null,null,null,null,null,null,null,"3.13.1"]
[null,"This form provides a mechanism for documenting the review of litigation related payments and insuring "]
[null,"completeness of the information reported on the forms within this reporting package.  It aids in identifying "]
[null,"the other forms necessary for completion."]
[null,"● Enter the information requested through descriptions of the fields."]
[null,"○   Features within the forms to assist in completion:"]
[null,"►    The reporting year, business area, and agency name is derived from the selection made on 3.13.1."]
[null,"►    Responses to Yes/No questions are provided in a drop-down menu."]
[null,"►    Based on the response to the Yes/No question, instructions for the completion"]
[null,"of the remainder of the form will appear.  Follow those instructions."]
[null,"● If required by the instructions, provide sufficient explanation of the attorney’s services for an individual "]
[null,"unfamiliar with your operations to understand the need for the services.  If additional space is "]
[null,"necessary, please attach additional pages. "]
[null,"Upon completion of the information requested:"]
[null,"● The individual completing the form should review the form for accuracy and completeness."]
[null,"● The Finance Director or Executive Director should review 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 July 19."]
[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,"Litigation Overview Form",null,null,null,null,null,null,null,"3.13.2"]
[null,"This form provides a summary of the situations occurring during the year.  It guides the user through the"]
[null,"determination and completion of the related forms."]
[null,"● Cases for which the potential gain or loss is not expected to meet or exceed $1,000,000 do not need to be reported.  Unless they are part of a class action lawsuit and that total is expected to meet or exceed the $1,000,000 threshold."]
[null,null,"Cases which are covered and being handled by the Insurance Reserve Fund need to be reported."]
[null,"● Enter the information requested through descriptions of the fields."]
[null,"○   Features within the forms to assist in completion:"]
[null,"►    The reporting year is provided as a drop-down menu selection."]
[null,"►    Responses to Yes/No questions are provided in a drop-down menu."]
[null,"►    The status of each situation is available from a drop-down menu."]
[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,"►    A control total for the number of each status reported on the form meeting the criteria for"]
[null,"completion of other forms."]
[null,"● Create copies and complete as many forms as is necessary to report all situations occurring during or"]
[null,"subsequent to the year of reporting."]
[null,"Upon completion of the information requested:"]
[null,"● The individual completing the form should review the form for accuracy and completeness."]
[null,"● The Finance Director or Executive Director should review 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 July 19."]
[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,"Settled Litigation Report Form",null,null,null,null,null,null,null,"3.13.3"]
[null,"This form is to convey information relating to situations that were settled during the year.  Create copies of "]
[null,"the form to provide a separate form for each situation required from the responses on the Litigation "]
[null,"Overview Form (Form 3.13.1).  "]
[null,"● Enter the information requested through descriptions of the fields."]
[null,"○   Features within the forms to assist in completion:"]
[null,"►    The reporting year, business area, and agency name is derived from the selection made on 3.13.1."]
[null,"►    A drop-down menu has been added to indicate the initial reporting or an update."]
[null,"►    Responses to Yes/No questions are provided in a drop-down menu."]
[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,"►    A drop-down menu has been added to indicate the type of case."]
[null,"►    A validation check is provided for keying errors in Fund Number."]
[null,"►    Totals are calculated fields.  Please confirm the accuracy of the calculations."]
[null,"● When requested provide sufficient descriptions for someone not familiar with the daily operations of "]
[null,"the agency to understand the case."]
[null,"● If funding for the settlement is expected from more than one accounting fund, attach an additional sheet."]
[null,"● Attach a copy of a payment schedule for the settlement if not previously provided to the Comptroller "]
[null,"General’s Office."]
[null,"● Provide a listing of SCEIS documents representing settlement payments to date.  Attach copies of "]
[null,"documents for any settlement payments processed outside of SCEIS not previously provided to "]
[null,"the Comptroller General’s Office.  "]
[null,"Upon completion of the information requested:"]
[null,"● The agency's attorney should sign and date the summary signature sheet before sending it to the Comptroller"]
[null,"General's Office.  The attorney's signature acknowledges the existence of a liability and confirms that the "]
[null,"general information reported is accurate. "]
[null,"● The individual completing the form should review the form for accuracy and completeness."]
[null,"● The Finance Director or Executive Director should review 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 initial form to the Comptroller General's Office no later than July 19."]
[null,"● Send any update 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,"Litigation Contingency Report Form",null,null,null,null,null,null,null,"3.13.4"]
[null,"This form is to convey information relating to situations that are active during or subsequent to the year.  "]
[null,"Create copies of the form to provide a separate form for each situation required from the responses "]
[null,"on the Litigation Overview Form (Form 3.13.1).  "]
[null,"● Enter the information requested through descriptions of the fields."]
[null,"○   Features within the forms to assist in completion:"]
[null,"►    The reporting year, business area, and agency name is derived from the selection made on 3.13.1."]
[null,"►    A drop-down menu has been added to indicate the initial reporting or an update."]
[null,"►    A drop-down menu has been added to indicate the stage or status of the case."]
[null,"►    A drop-down menu has been added to indicate the type of case."]
[null,"►    A drop-down menu has been added to indicate the likelihood of a loss.  "]
[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,"● When requested provide sufficient descriptions for someone not familiar with the daily operations of "]
[null,"the agency to understand the case.  If the information is an update, provide the date through which the"]
[null,"information has been evaluated."]
[null,"● Provide the funding sources identified to pay the potential loss.  If the case will be covered by insurance "]
[null,"coverage through the Insurance Reserve Fund (IRF) provide the case number assigned by IRF.  If only"]
[null,"a portion is to be covered, report on a separate line the source for the remaining estimated loss.  If the"]
[null,"case is not covered by insurance, provide the accounting fund which holds the resources from which "]
[null,"the loss is planned to be paid.  If the source of payment has not been determined at the time of reporting, "]
[null,"attach an explanation including potential sources being considered."]
[null,"Upon completion of the information requested:"]
[null,"● The agency's attorney should sign and date the summary signature sheet before sending it to the Comptroller"]
[null,"General's Office.  The attorney's signature acknowledges the existence of a liability and confirms that the "]
[null,"general information reported is accurate. "]
[null,"● The individual completing the form should review the form for accuracy and completeness."]
[null,"● The Finance Director or Executive Director should review 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 initial form to the Comptroller General's Office no later than July 19."]
[null,"● Send any update 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.13.5"]
[null,"Use this Checklist as a mechanism for review.  It should be completed prior to reviewer's signature on"]
[null,"the summary signature sheet.  A No response indicates an error.  If errors are identified, return the package"]
[null,"to the preparer for correction prior to further review.  Written explanation should be retained for "]
[null,"an N/A responses for review by auditors to ensure compliance with reporting requirements."]
[null,"►    The year for reporting has been derived from the selection made on 3.13.1."]
[null,"Upon completion of the checklist:"]
[null,"● A completed reviewer's checklist must accompany the submitted agency packet."]
[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."]
[]
[null,"Signature Sheet"]
[null,"Please complete this form and submit via PDF format.  It is the only form to be submitted in PDF format all other tabs are submitted in the excel format."]

{"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.13 Litigation 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,"L060","DIVISION ON AGING"]
[null,null,"L080","CHILDRENS ADVOCACY"]
[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.13 that is to be submitted in pdf format, all others are submitted via excel format."]

{"sheet":"3.13.1","index":2,"n_rows":24,"n_cols":12,"rows_kept":24,"cut":false,"hidden":false,"merged":[[5,4,5,10],[21,16,21,23],[13,1,13,11],[24,1,44,11],[22,16,22,23],[8,4,8,10],[10,4,10,10]]}
[null,"STATE OF SOUTH CAROLINA"]
[null,"LITIGATION RELATED EXPENSE EXPLANATIONS"]
[null,null,null,null,null,"At June 30,","2019"]
[]
[]
[null,"Agency:",{"$f":"+AgencyCode","v":0},null,{"$f":"+'Signature 1'!E6","v":""}]
[null,null,"Bus. Area",null,"Name"]
[]
[null,"Typed name of preparer:"]
[]
[null,"Typed name of reviewer:"]
[]
[]
[null,"From the review of litigation related expenses were:"]
[]
[null,"Payments made for settled litigation?",null,null,null,null,null,null,null,null,null,{"$f":"IF(K16=\"\",\"\",IF(K16=\"Yes\",\"next question\",\"\"))","v":""}]
[]
[null,"Payments made for settled litigation equal to or more than $1,000,000?",null,null,null,null,null,null,null,null,null,{"$f":"IF(K18=\"\",\"\",IF(K18=\"Yes\",\"Form 3.13.2\",\"report below\"))","v":""}]
[]
[null,"Payments made for situations constituting actual or threatened litigation?",null,null,null,null,null,null,null,null,null,{"$f":"IF(K20=\"\",\"\",IF(K20=\"Yes\",\"report below\",\"\"))","v":""}]
[]
[null,"Payments made for situations which did not result in pursuit of litigation?",null,null,null,null,null,null,null,null,null,{"$f":"IF(K22=\"\",\"\",IF(K22=\"Yes\",\"report below\",\"\"))","v":""}]
[]
[null,"Description of other situations requiring attorney or related services:"]

{"sheet":"3.13.2","index":3,"n_rows":47,"n_cols":16,"rows_kept":47,"cut":false,"hidden":false,"merged":[[39,1,39,6],[35,11,35,14],[24,2,24,14],[25,2,25,14],[28,1,28,15],[27,2,27,12],[34,1,34,6],[29,1,29,12],[32,1,32,6],[33,1,33,6],[33,11,33,14],[34,11,34,14],[26,2,26,14],[35,1,35,6],[36,1,36,6],[37,1,37,6],[5,4,5,13],[18,2,18,12],[14,1,14,15],[15,1,15,15],[41,1,41,6],[40,1,40,6],[40,11,40,14],[41,11,41,14],[36,11,36,14],[37,11,37,14],[38,1,38,6],[38,11,38,14],[21,2,21,14],[22,2,22,14],[23,2,23,14],[39,11,39,14],[16,1,16,15],[20,2,20,12],[19,1,19,15],[13,1,13,15],[8,4,8,10],[10,4,10,10]]}
["STATE OF SOUTH CAROLINA"]
["LITIGATION OVERVIEW FORM"]
[null,null,null,null,null,"At June 30,",{"$f":"IF('3.13.1'!G3=\"\",\"\",('3.13.1'!G3))","v":"2019"}]
[]
[]
["Agency:",null,{"$f":"IF('3.13.1'!C6=\"\",\"\",'3.13.1'!C6)","v":0},null,{"$f":"IF('3.13.1'!E6=\"\",\"\",'3.13.1'!E6)","v":""}]
[null,null,"Bus. Area",null,"Name"]
[]
[null,"Typed name of preparer:"]
[]
[null,"Typed name of reviewer:"]
[]
[]
[null,"On the lines below, list the actual and threatened litigation cases that were pending for your agency at "]
[null,"June 30th, that have arisen since June 30th, and any others that you reported last year on a Litigation "]
[null,"Contingency Report Form that still meet the $1,000,000 reporting threshold.  Exclude from reporting any case where the "]
[null,"potential gain or loss is not expected to meet or exceed $1,000,000.  Copy this form as necessary to include all situations."]
[null,"Please note that class action lawsuits need to be evaluated & reported as a whole when looking at the reporting requirements."]
[]
[null,"The following status selections are available below in the drop-down menu."]
[]
[null,"N","-    The situation was settled* this year and will not require the State to make future payments."]
[null,"S","-    The situation was settled* this year and will require the State to make future payments."]
[null,"C1","-    The situation has been decided, but appeal is reasonably possible."]
[null,"C2","-    The case is currently under appeal."]
[null,"C3","-    The case has been filed with a court but has not yet been decided."]
[null,"C4","-    The situation constitutes threatened litigation, but nothing has yet been filed with a court."]
[]
[null,"* Settled cases include those that were dropped and those that were decided for which the probability"]
[null,"of appeal is believed to be remote."]
[null,"Please note that potential gains should be listed as negative or ( ) amounts."]
[null,null,null,null,null,null,null,null,"Status",null,null,"Potential (Gain) Loss"]
[null,"Case Name or Situation"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"For each situation with N marked, nothing more required."]
[null,"For each situation with S marked, complete one Settled Litigation Report Form  (Form 3.13.3).",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(I34:I42,\"=S\")","v":0}]
[null,"For each situation with C1, C2, C3, or C4 marked and Potential (Gain) Loss meeting or exceeding $1,000,000,"]
[null,"complete Litigation Contingency Report Form (Form 3.13.4).  No reporting required if Potential under $1,000,000.",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIFS(I34:I42,\"=C*\",L34:L42,\">499999\")+COUNTIFS(I34:I42,\"=C*\",L34:L42,\"<-499999\")","v":0}]

{"sheet":"3.13.3","index":4,"n_rows":55,"n_cols":14,"rows_kept":55,"cut":false,"hidden":false,"merged":[[4,4,4,12],[16,13,16,14],[21,1,21,6],[16,2,16,9],[17,1,17,2],[18,13,18,14],[20,13,20,14],[7,4,7,10],[9,4,9,10],[22,1,22,14],[23,1,23,14],[54,1,54,10],[54,13,54,14],[52,1,52,10],[40,1,40,10],[35,4,35,7],[48,13,48,14],[48,1,48,10],[50,1,50,10],[50,13,50,14],[52,13,52,14],[43,13,43,14],[38,3,38,4],[41,1,41,10],[41,13,41,14],[40,13,40,14],[45,13,45,14],[25,10,25,12],[27,1,31,14],[43,1,43,10],[33,10,33,14],[33,4,33,8]]}
[null,"STATE OF SOUTH CAROLINA"]
[null,"SETTLED LITIGATION REPORT FORM"]
[]
[]
[null,"Agency:",{"$f":"IF('3.13.1'!C6=\"\",\"\",'3.13.1'!C6)","v":0},null,{"$f":"IF('3.13.1'!E6=\"\",\"\",'3.13.1'!E6)","v":""}]
[null,null,"Bus. Area",null,"Name"]
[]
[null,"Typed name of preparer:"]
[]
[null,"Typed name of reviewer:"]
[]
[]
[null,"GENERAL INFORMATION"]
[null,"Is this the initial report, annual, or an update subsequent "]
[null,"to year-end of information:"]
[]
[null,"Case Name:",null,null,null,null,null,null,null,null,null,null,"Settlement Date:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Settlement Amount:"]
[]
[null,"Are insurance or other recoveries anticipated?",null,null,null,null,null,null,null,null,null,null,"Estimated Recovery:"]
[null,"Name, address, and phone of the State's attorney:"]
[]
[]
[]
[null,"Type of Case:"]
[null,"Case description:"]
[]
[]
[]
[]
[]
[]
[null,"Reviewed by:"]
[null," ","Date",null,"Attorney Name typed",null,null,null,null,null,"Title"]
[]
[]
[]
[null,"Fund Code:"]
[]
[null,"Description",null,null,null,null,null,null,null,null,null,null,null,"Dollar Amount"]
[null,"Amount paid prior to this fiscal year"]
[]
[null,"Amounts paid in the current fiscal year"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N44=\"\",\"\",\"See attached for Doc Numbers and Information\")","v":""}]
[null,"Amount of Settlement Paid to date - provided by this Fund",null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(N42:O45)","v":0}]
[]
[]
[null,"Amount processed for payment in extended period (\"Prior Year Payable\")",null,null,null,null,null,null,null,null,null,null,"$"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N49=\"\",\"\",\"See attached for Doc Numbers and Information\")","v":""}]
[null,"Amount the agency plans to pay within the next fiscal year  (period 1 to 12).",null,null,null,null,null,null,null,null,null,null,"$"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N51=\"\",\"\",\"See attached for Doc Numbers and Information\")","v":""}]
[null,"Amount the agency plans to pay after next June 30",null,null,null,null,null,null,null,null,null,null,"$"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N53=\"\",\"\",\"See attached for Doc Numbers and Information\")","v":""}]
[null,"Future payments required - to be provided by this Fund",null,null,null,null,null,null,null,null,null,null,null,{"$f":"N49+N51+N53","v":0}]

{"sheet":"3.13.4","index":5,"n_rows":67,"n_cols":16,"rows_kept":67,"cut":false,"hidden":false,"merged":[[61,15,61,17],[61,10,61,11],[54,5,54,10],[51,13,51,15],[59,10,59,11],[64,1,64,6],[64,10,64,11],[64,15,64,17],[63,15,63,17],[4,2,4,3],[4,5,4,14],[21,14,21,17],[21,1,21,12],[19,14,19,17],[19,1,19,12],[53,13,53,17],[29,10,29,14],[62,15,62,17],[45,7,45,10],[59,15,59,17],[57,1,57,15],[16,14,16,17],[16,2,16,11],[36,13,36,17],[49,13,49,16],[24,1,27,17],[29,6,29,8],[35,13,35,17],[36,2,36,3],[43,5,43,6],[31,10,31,14],[7,4,7,10],[9,4,9,10],[63,10,63,11],[53,5,53,10],[61,1,61,6],[62,1,62,6],[63,1,63,6],[53,2,53,3],[59,1,59,6],[62,10,62,11],[14,11,14,13]]}
[null,"STATE OF SOUTH CAROLINA"]
[null,"LITIGATION CONTINGENCY REPORT FORM"]
[]
[]
[null,"Agency:",{"$f":"IF('3.13.1'!C6=\"\",\"\",'3.13.1'!C6)","v":0},null,null,{"$f":"IF('3.13.1'!E6=\"\",\"\",'3.13.1'!E6)","v":""}]
[null,null,"Bus. Area",null,null,"Name"]
[]
[null,"Typed name of preparer:"]
[]
[null,"Typed name of reviewer:"]
[]
[]
[null,"GENERAL INFORMATION"]
[]
[null,"Is it a New Case, Update of Prior Year, or Update AFTER Year-End?"]
[]
[null,"Case Name:"]
[]
[null,"Name, address, phone, and email address of the State's Lead attorney:"]
[]
[null,"Name of Lead Attorney and Firm",null,null,null,null,null,null,null,null,null,null,null,null,"email address"]
[]
[null,"Mailing Address for Lead Attorney",null,null,null,null,null,null,null,null,null,null,null,null,"Phone number"]
[null,"Case description:"]
[]
[]
[]
[]
[]
[null,"Status of Case"]
[]
[null,"Type of Case:"]
[]
[]
[null,"CASE IN PROGRESS"]
[null,null,null,null,"Amount (or range of amounts) of the",null,null,null,null,null,null,"Max","$"]
[null,"Date Initiated:",null,null,"estimated loss for the State:",null,null,null,null,null,null,"Min","$"]
[]
[null,null,null,null,null,null,null,null,null,null,"One of these may be the stated demands."]
[]
[]
[null,"THREATENED CASE"]
[]
[null,"Estimated date case may be filed:"]
[]
[null,"Estimated amount lawsuit may ask from State:",null,null,null,null,"$"]
[]
[]
[null,"Please note that gain amounts are entered as negative or ( ) amounts."]
[null,"Amount of (gain) loss expected on case:"]
[]
[null,"Likelihood of (gain)loss"]
[]
[null,"Reviewed by:"]
[null," ","Date",null,null,"Attorney's Name (typed)",null,null,null,null,null,null,null,"Title"]
[]
[]
[]
[null,"Fund(s) responsible for payment if the State loses its case:",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N50=\"\",\"\",IF(N50>SUM(P62:R65),\"ADDITIONAL INFO NEEDED\",\"\"))","v":""}]
[null,"Description of Source",null,null,null,null,null,null,"Fund",null,"IRF Case",null,null,"Percent",null,"Dollar Amount             Claimed"]
[]
[]
[]
[]
[]
[null,"If additional space is needed, type \"Attached\" in the description field and enter the subtotal of the attached schedule."]
[null,"If the funding of the loss has not been determined, attach explanation with the options for funding being considered."]

{"sheet":"3.13.5","index":6,"n_rows":87,"n_cols":7,"rows_kept":87,"cut":false,"hidden":false,"merged":[]}
["STATE OF SOUTH CAROLINA"]
["LITIGATION REPORTING PACKAGE"]
["REVIEWER CHECKLIST"]
[null,null,null,null,null,"FISCAL YEAR",{"$f":"IF('3.13.1'!G3=\"\",\"\",'3.13.1'!G3)","v":"2019"}]
[]
["Agency:",null,{"$f":"+'3.13.4'!C5:D5","v":0}]
[]
[null,null,null,null,"Date Last Review Step Was Completed:   "]
[]
[]
["Reviewer's Responses for Litigation Related Explanation Form (Form 3.13.1):"]
[{"$f":"COUNT(A$11:A11)+1","v":1},"If YES was selected as the response to the questions regarding litigation payments ,"]
[null,"was Form 3.13.2 completed for cases meeting the threshold?"]
[]
[{"$f":"COUNT(A$11:A14)+1","v":2},"Was the SCEIS report all inclusive of litigation related services including Private "]
[null,"attorneys?  (If No please provide written explanation in the box provided on 3.13.1 "]
[null,"or as an attachment to Form 3.13.1 and include consideration of the excluded"]
[null,"information in the responses for Forms 3.13.2, 3.13.3, and 3.13.4)"]
[]
[{"$f":"COUNT(A$11:A19)+1","v":3},"Has the services related to each payment been examined and properly "]
[null,"classified on the form?"]
[]
["Reviewer's Responses for Litigation Overview Form (Form 3.13.2):"]
[]
[{"$f":"COUNT(A$11:A21)+1","v":4},"Are all the cases reported in last year’s reporting package as contingent (form 3.13.4)"]
[null,"accounted for on the Litigation Overview Form (Form 3.13.2)?"]
[]
[{"$f":"COUNT(A$11:A27)+1","v":5},"For each case name or situation, is a status and estimated (gain) loss reported?"]
[]
[{"$f":"COUNT(A$11:A29)+1","v":6},"Does the total number of S’s equal the total number of Settled Litigation "]
[null,"Forms (Form 3.13.3) completed for submission?"]
[]
[{"$f":"COUNT(A$11:A32)+1","v":7},"Does the total number of C’s equal the total number of Litigation Contingency"]
[null," Forms (Form 3.13.4) completed for submission?"]
[]
[{"$f":"COUNT(A$11:A35)+1","v":8},"Was there consideration given to any class action lawsuits to ensure proper"]
[null,"reporting based upon total potential gain or loss in the lawsuit?"]
[]
["Reviewer's Responses for Settled Litigation Report Form (Form 3.13.3):"]
[{"$f":"COUNT(A$11:A39)+1","v":9},"Does each form contain the name of the attorney "]
[null,"representing the agency in the situation?"]
[]
[{"$f":"COUNT(A$11:A42)+1","v":10},"Is each form complete including:  case name, settlement date, Fund name, "]
[null,"Fund number, and amount?"]
[]
[{"$f":"COUNT(A$11:A45)+1","v":11},"If payments are required, is the payment schedule completed at the bottom of 3.13.3?"]
[]
[]
["Reviewer's Responses for Litigation Contingency Report Form (Form 3.13.4):"]
[{"$f":"COUNT(A$11:A49)+1","v":12},"Does each form contain the name of the attorney "]
[null,"representing the agency in the situation?"]
[]
[{"$f":"COUNT(A$11:A52)+1","v":13},"Is a date reported in the initiated or estimated fields for case in progress "]
[null,"or threatened, respectively?"]
[]
[{"$f":"COUNT(A$11:A55)+1","v":14},"Is an amount entered for the estimated loss?  Undetermined is not an"]
[null,"acceptable amount.  Should be expressed in whole dollars."]
[]
[{"$f":"COUNT(A$11:A58)+1","v":15},"Is the likelihood of loss indicated as either probable, reasonably possible, "]
[null,"or remote?  No other choices should be conveyed."]
[]
[{"$f":"COUNT(A$11:A61)+1","v":16},"If the case has been filed with the Insurance Reserve Fund (IRF), is the IRF "]
[null,"case number included?"]
[]
[{"$f":"COUNT(A$11:A64)+1","v":17},"If an IRF Case number is provided, has the percentage of coverage been"]
[null,"reported?  Unknown is not acceptable.  "]
[]
[{"$f":"COUNT(A$11:A67)+1","v":18},"If an IRF Case number is provided, has a dollar amount of the claim been"]
[null,"reported?"]
[]
[{"$f":"COUNT(A$11:A70)+1","v":19},"If an IRF Case number is not provided, has the Fund number and name from "]
[null,"which resources will be provided been identified?  A plan should be "]
[null,"established and communicated in the form."]
[]
[{"$f":"COUNT(A$11:A74)+1","v":20},"Is the amount of estimated loss agreed to by the attorney as indicated by his/her"]
[null,"signature on the summary signature sheet within the range reported in"]
[null,"the Case in Progress section?"]
[]
[{"$f":"COUNT(A$11:A77)+1","v":21},"Is the total in the Funds responsible for payment equal to the estimated loss"]
[null,"to which the attorney has affirmed agreement?"]
[]
["Reviewer's Responses for All Litigation Reporting Package Forms:"]
[]
[{"$f":"COUNT(A$11:A80)+1","v":22},"Is the reviewer of the form someone other than the person who prepared it?"]
[]
[{"$f":"COUNT(A$11:A84)+1","v":23},"Based on the overall review of the activities of the agency for the year, is the"]
[null,"information provided in the forms complete and comprehensive?"]