{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Signature 1","3.16.1","3.16.2","3.16.3","3.16.4"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":9,"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":124,"n_cols":7,"rows_kept":124,"cut":false,"hidden":false,"merged":[[123,1,123,11]]}
["STATE OF SOUTH CAROLINA"]
["YEAR-END REPORTING PROCEDURES MANUAL"]
["SECTION 3.16, MISCELLANEOUS LOSS LIABILITIES, LOSS "]
["CONTINGENCIES, AND COMMITMENTS REPORTING PACKAGE"]
[]
[null,"PURPOSE and OBJECTIVE:"]
[null,"GAAP require the State to record a liability for all known and some potential losses.  "]
[null,"In addition, it requires disclosure in the notes to the financial statements of significant "]
[null,"commitments and for certain potential losses.  This reporting package gathers information"]
[null,"necessary to understand the transactions for known and potential losses and significant"]
[null,"commitments."]
[]
[null,"Please refer to the Reporting Policy and Procedures Manual Section for Miscellaneous Loss "]
[null,"Liabilities for further guidance on the information requested in these forms.  In addition the Key "]
[null,"Terms of the Manual may increase comprehension of the information requested."]
[]
[null,"INSTRUCTIONS FOR COMPLETION OF THE FORMS:"]
[null,"Miscellaneous Loss Liability Report Form",null,null,null,null,"3.16.1"]
[null,"Used to report loss liabilities (known losses) as of year-end.  Please, complete "]
[null,"a separate form for each situation identified.  "]
[null,"● Enter the information requested by the descriptions of each field."]
[null,"○   Features within the form to assist in completion:"]
[null,"►    The year for reporting is provided as a drop-down menu selection."]
[null,"►    Edit checks are included for the amounts to limit responses to whole numbers."]
[null,"● Specific Instructions:"]
[null,"○   Description of situation - Provide an explanation of the identified situation in sufficient "]
[null,"detail for understanding by an individual who is not familiar with the agency's daily "]
[null,"operations.  Include at least:"]
[null,"The nature of the loss and when the loss became known, "]
[null,"Name, business address, email, and phone number of State's attorney(s), "]
[null,"Name, business address, email, and phone number of other expert(s), if applicable."]
[null,"● Verify the accuracy of the results of the calculated field."]
[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 "]
[null,"agreement with the information’s accuracy and completeness before sending it to the "]
[null,"Comptroller General's 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 August 9."]
[null,"● The agency should retain a copy of the completed form as part of its year-end working papers.  "]
[null,"The Comptroller General's Office Financial Reporting Division will contact the individual "]
[null,"completing the form if there are any questions. "]
[]
[null,"Miscellaneous Loss Contingency Report Form",null,null,null,null,"3.16.2"]
[null,"Used to report loss contingencies (potential losses) as of year-end.  Please, complete "]
[null,"a separate form for each situation identified.  In addition complete a subsequent form if additional"]
[null,"information is gained after submission of the initial form."]
[null,"● Enter the information requested by the descriptions of each field."]
[null,"○   Features within the form to assist in completion:"]
[null,"►    A drop down menu is utilized to report the period of evaluation."]
[null,"►    A drop down menu is utilized to report the results of the evaluation of the probability of loss."]
[null,"►    Edit checks are included for the amounts to limit responses to whole numbers."]
[null,"►    Edit checks are included for appropriate characters in the Fund Number."]
[null,"►    Edit checks are included for percentages reported (can not exceed 100%)."]
[null,"● Specific Instructions:"]
[null,"○   Date through which information is evaluated - complete only if subsequent is selected for the period "]
[null,"of evaluation."]
[null,"○   Description of situation - Provide an explanation of the identified situation in sufficient detail for"]
[null,"understanding by an individual who is not familiar with the agency's daily operations.  Include "]
[null,"at least:"]
[null,"The nature of the loss and when the loss became known, "]
[null,"Name, business address, email, and phone number of State's attorney(s), "]
[null,"Name, business address, email, and phone number of other expert(s), if applicable."]
[null,"○   Comments on probability of loss - If desired justification for the selection may be documented."]
[null,"○   Description of lack of estimation - If either the minimum or maximum is not provided, please "]
[null,"explain why the loss could not be estimated."]
[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 "]
[null,"agreement with the information’s accuracy and completeness before sending it to the "]
[null,"Comptroller General's 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 August 9."]
[null,"● Send the subsequent form(s) 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.  "]
[null,"The Comptroller General's Office Financial Reporting Division will contact the individual "]
[null,"completing the form if there are any questions. "]
[]
[null,"Significant Miscellaneous Commitments Report Form",null,null,null,null,"3.16.3"]
[null,"Used to report commitments (not associated with construction or development of software) as of "]
[null,"year-end.  Please, complete a separate form for each situation identified.  In addition complete "]
[null,"a subsequent form if additional information is gained after submission of the initial form."]
[null,"● Enter the information requested by the descriptions of each field."]
[null,"○   Features within the form to assist in completion:"]
[null,"►    The reporting year is derived from the field on 3.16.1."]
[null,"►    Edit checks are included for the amounts to limit responses to whole numbers."]
[null,"● Specific Instructions:"]
[null,"○   Description of commitment - Provide an explanation of the identified commitment in sufficient "]
[null,"detail for understanding by an individual who is not familiar with the agency's daily operations.  "]
[null,"Include at least:"]
[null,"The nature of the loss, "]
[null,"When the contract was signed or promise made, "]
[null,"Name or description of the external party with whom the contract was entered,"]
[null,"Date (if any) by which the commitment terminates."]
[null,"○   Funded by Federal or Local - enter amounts in these fields only if a portion of the commitment"]
[null,"will be paid from resources provided by others."]
[null,"● Verify the accuracy of the results of the calculated field."]
[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 "]
[null,"agreement with the information’s accuracy and completeness before sending it to the "]
[null,"Comptroller General's 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 August 9."]
[null,"● Send the subsequent form(s) 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.  "]
[null,"The Comptroller General's Office Financial Reporting Division will contact the individual "]
[null,"completing the form if there are any questions. "]
[]
[null,"Reviewer's Checklist",null,null,null,null,"3.16.4"]
[null,"Use this Checklist as a mechanism for review.  It should be completed prior to reviewer's signature on"]
[null,"the summay 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,"Upon completion of the checklist:"]
[null,"● A completed reviewer's checklist must accompany the agency submission for this 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":138,"n_cols":6,"rows_kept":138,"cut":false,"hidden":false,"merged":[[137,1,137,5],[126,1,126,5],[128,1,128,5],[130,1,130,5],[132,1,132,5],[134,1,134,5]]}
[null,null,"3.16 Misc Loss and Significant Commitments Packet"]
[]
[]
[null,null,"CAFR Reporting Period:",null,2019]
[null,null,"Agency Number:",null,"E120"," "]
[null,null,"Agency Name",null,{"$f":"IF(ISERROR(VLOOKUP(AgencyCode,C32:D111,2,FALSE))=TRUE,\"\",VLOOKUP(AgencyCode,C32:D111,2,FALSE))","v":"COMPTROLLER GENERAL'S OFFICE\n"}]
[]
[]
[]
[]
[]
[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,"F030","BUDGET & CONTROL BOARD       \n    \n"]
[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,"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.16 that is to be submitted in pdf format, all others are submitted via excel format."]

{"sheet":"3.16.1","index":2,"n_rows":43,"n_cols":11,"rows_kept":43,"cut":false,"hidden":false,"merged":[[26,3,26,7],[29,1,29,7],[8,2,8,5],[11,2,11,5],[5,4,5,9],[15,1,19,11],[27,1,27,2],[42,10,42,11],[38,10,38,11],[34,10,34,11],[42,1,42,7],[30,10,30,11],[37,1,37,7],[34,1,34,7],[38,1,38,7],[30,1,30,7],[33,1,33,7]]}
[null,"STATE OF SOUTH CAROLINA"]
[null,"MISCELLANEOUS LOSS LIABILITY REPORT FORM"]
[null,null,null,null,null,"At June 30,","2019"]
[]
[]
[null,"Agency:",{"$f":"+AgencyCode","v":"E120"},null,{"$f":"+'Signature 1'!E6","v":"COMPTROLLER GENERAL'S OFFICE\n"}]
[null,null,"Business Area",null,"Name"]
[]
[null,"Preparer:","Employee ABC"]
[null,null,"Typed name"]
[]
[null,"Reviewer:","Supervisor XYZ"]
[null,null,"Typed name"]
[]
[null,"Description of situation:"]
[null,"Automobile accident on 5/9/2019, employee at fault personal property damage along with state fleet vehicle damage"]
[]
[]
[]
[]
[]
[]
[null,"Fund Code:",30350000]
[]
[]
[]
[null,null,null,"Description",null,null,null,null,null,"Dollar Amount"]
[]
[]
[null,"Loss liability that the agency processed payment for or plans to process for "]
[null,"payment during the extended period 12 of the current fiscal year",null,null,null,null,null,null,null,"$",0]
[]
[]
[null,"Loss liability that the agency plans to pay during the next fiscal "]
[null,"     year",null,null,null,null,null,null,null,"$",14690]
[]
[]
[null,"Loss liability that the agency plans to pay from future resources (i.e. beyond the"]
[null,"     next fiscal year.)",null,null,null,null,null,null,null,"$",0]
[]
[]
[]
[null,"Fund Total",null,null,null,null,null,null,null,"$",{"$f":"K31+K35+K39","v":14690}]

{"sheet":"3.16.2","index":3,"n_rows":43,"n_cols":15,"rows_kept":43,"cut":false,"hidden":false,"merged":[[4,5,4,13],[25,14,25,15],[33,5,33,7],[41,5,41,11],[33,10,33,13],[15,13,15,15],[20,1,23,15],[28,1,30,15],[36,1,38,15],[41,1,41,3],[41,13,41,14],[17,13,17,14],[18,1,18,3],[44,5,44,11],[42,1,42,3],[43,13,43,14],[43,1,43,3],[44,1,44,3],[43,5,43,11],[44,13,44,14],[42,5,42,11],[42,13,42,14]]}
[null,"STATE OF SOUTH CAROLINA"]
[null,"MISCELLANEOUS LOSS CONTINGENCY REPORT FORM"]
[]
[]
[null,"Agency:",null,{"$f":"IF('3.16.1'!C6=\"\",\"\",'3.16.1'!C6)","v":"E120"},null,{"$f":"IF('3.16.1'!E6=\"\",\"\",'3.16.1'!E6)","v":"COMPTROLLER GENERAL'S OFFICE\n"}]
[null,null,null,"Bus. Area",null,"Name"]
[null,"Preparer:",null,"Employee ABC"]
[null,null,null,"Typed name"]
[]
[null,"Reviewer:",null,"Supervisor XYZ"]
[null,null,null,"Typed name"]
[]
[]
[null,"GENERAL INFORMATION:"]
[]
[null,"Was the evaluation performed through submission of this form or subsequently?",null,null,null,null,null,null,null,null,null,null,null,"Reporting Pkg"]
[]
[null,"If subsequently, Date through which information was evaluated and is reported"]
[]
[null,"Description of situation:"]
[null,"Personal Property Damage- claiming more damage to property once repairs started"]
[]
[]
[]
[]
[null,"The probability that this situation will result in a loss to the State is best described as",null,null,null,null,null,null,null,null,null,null,null,null,"Probable"]
[]
[null,"Comments (if any) on probability of loss:"]
[null,"employee was determined to be at fault in the accident"]
[]
[]
[]
[null,"Estimated future loss (minimum to maximum): "]
[null,null,null,"Approximately    $",null,3560,null,null,"    to    $",null,5000]
[]
[null,"If you cannot estimate the loss amount, please describe why:"]
[]
[]
[]
[]
[null,"Fund(s) responsible for payment if the State loses its case:"]
[null,"Fund Number",null,null,null,"Fund Name",null,null,null,null,null,null,null,"Percent"]
[null,30350000,null,null,null,"Genreal operating",null,null,null,null,null,null,null,1]

{"sheet":"3.16.3","index":4,"n_rows":36,"n_cols":8,"rows_kept":36,"cut":false,"hidden":false,"merged":[[16,1,21,10],[5,4,5,8],[25,1,25,4]]}
[null,"STATE OF SOUTH CAROLINA"]
[null,"SIGNIFICANT MISCELLANEOUS COMMITMENTS FORM"]
[null,null,null,null,null,"At June 30,",{"$f":"IF('3.16.1'!G3=\"\",\"\",'3.16.1'!G3)","v":"2019"}]
[]
[]
[null,"Agency:",{"$f":"IF('3.16.1'!C6=\"\",\"\",'3.16.1'!C6)","v":"E120"},null,{"$f":"IF('3.16.1'!E6=\"\",\"\",'3.16.1'!E6)","v":"COMPTROLLER GENERAL'S OFFICE\n"}]
[null,null,"Business Area",null,"Name"]
[]
[null,"Preparer:",null,"Employee ABC"]
[null,null,null,"Typed name"]
[]
[null,"Reviewer:",null,"Supervisor XYZ"]
[null,null,null,"Typed name"]
[]
[]
[null,"Description of commitment:"]
[null,"Infrastructure improvement grants"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Commitment amount remaining at June 30:",null,null,null,null,"$",2848000]
[]
[]
[null,"If any portion of the commitment is expected to be funded by others, please provide a breakdown as follows:"]
[]
[null,null,"Federal aid",null,null,null,"$",1535000]
[]
[null,null,"Local aid",null,null,null,"$",25000]
[]
[]
[null,null,"     Total commitment funded by others",null,null,null,"$",{"$f":"IF((H31+H33)>0,(H31+H33),\"\")","v":1560000}]

{"sheet":"3.16.4","index":5,"n_rows":81,"n_cols":11,"rows_kept":81,"cut":false,"hidden":false,"merged":[]}
["STATE OF SOUTH CAROLINA"]
["MISCELLANEOUS LOSS REPORTING PACKAGE"]
["REVIEWER CHECKLIST"]
[null,null,null,null,null,"FISCAL YEAR",{"$f":"IF('3.16.1'!G3=\"\",\"\",'3.16.1'!G3)","v":"2019"}]
[]
["Agency:",null,{"$f":"+'3.16.3'!C6","v":"E120"}]
[]
[null,null,null,null,"Date Last Review Step Was Completed:   ","2019-08-14"]
[]
["Responses for Miscellaneous Loss Liability Report Form (Form 3.16.1):"]
[{"$f":"COUNT(A$10:A10)+1","v":1},"Is the description of the situation sufficient for understanding by an individual ",null,null,null,null,null,null,null,null,"Yes"]
[null,"unfamiliar with the daily operations of the agency?"]
[]
[{"$f":"COUNT(A$10:A13)+1","v":2},"Does the description of the situation include the items included in the "]
[null,"instructions?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$10:A16)+1","v":3},"Is the fund number accurately reported?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$10:A18)+1","v":4},"Has the current loss 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?"]
[]
[{"$f":"COUNT(A$10:A22)+1","v":5},"Has a form been completed for each identified situation? ",null,null,null,null,null,null,null,null,"Yes"]
[]
["Responses for Miscellaneous Loss Contingency Report Form (Form 3.16.2):"]
[{"$f":"COUNT(A$10:A25)+1","v":6},"Is the appropriate response for the type of reporting (year-end or subsequent)"]
[null,"been identified?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$10:A28)+1","v":7},"If the reporting is subsequent, has the date through which the information"]
[null,"is updated been properly reported?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$10:A31)+1","v":8},"Is the description of the situation sufficient for understanding by an individual "]
[null,"unfamiliar with the daily operations of the agency?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$10:A34)+1","v":9},"Does the description of the situation include at least the items included in the "]
[null,"instructions?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$10:A37)+1","v":10},"Is the probability reported accurate based on the understanding of the situation?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$10:A39)+1","v":11},"Have comments been provided to assist in understanding why a probability "]
[null,"was selected? ",null,null,null,null,null,null,null,null,"No"]
[]
[{"$f":"COUNT(A$10:A42)+1","v":12},"Is the estimated loss minimum amount reasonable based on the circumstances?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$10:A44)+1","v":13},"Is the estimated loss maximum amount reasonable based on the circumstances?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$10:A46)+1","v":14},"If either the minimum or maximum is not stated, has an explanation been "]
[null,"provided?",null,null,null,null,null,null,null,null,"N/A"]
[]
[{"$f":"COUNT(A$10:A49)+1","v":15},"Are the fund numbers, fund names, and percentage of expected funding "]
[null,"accurately reported?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$10:A52)+1","v":16},"Has a form been completed for each identified situation? ",null,null,null,null,null,null,null,null,"Yes"]
[]
["Responses for Significant Miscellaneous Commitments Form (Form 3.16.3):"]
[{"$f":"COUNT(A$10:A55)+1","v":17},"Is the description of the situation sufficient for understanding by an individual "]
[null,"unfamiliar with the daily operations of the agency?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$10:A58)+1","v":18},"Does the description of the situation include at least the items included in the "]
[null,"instructions?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$10:A61)+1","v":19},"Is the commitment amount reported accurately?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$10:A63)+1","v":20},"Has the funding by others been properly reported?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$10:A65)+1","v":21},"Has the funding by Federal sources been properly segregated for reporting?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$10:A67)+1","v":22},"Is the total of the funding by others accurately calculated?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$10:A69)+1","v":23},"Has a form been completed for each identified situation? ",null,null,null,null,null,null,null,null,"Yes"]
[]
["Responses for All Miscellaneous Loss Reporting Package Forms:"]
[{"$f":"COUNT(A$10:A72)+1","v":24},"Is the reviewer of all forms someone other than the person who prepared them?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$10:A74)+1","v":25},"Are all amounts supported with transactions, analysis or valuations from experts?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$10:A76)+1","v":26},"Can all expended amounts be traced to official agency accounting records?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$10:A78)+1","v":27},"Has the activity been compared with the prior year, documenting causes "]
[null,"for any large fluctuations that can be easily obtained and explained to "]
[null,"individuals not familiar with the daily operations of the agency?",null,null,null,null,null,null,null,null,"Yes"]