{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Signature Page ","2.1.1","AP Worksheet ","AP Worksheet"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":51,"n_cols":10,"rows_kept":51,"cut":false,"hidden":false,"merged":[[47,1,47,11]]}
["SUBSEQUENT EVENTS REPORTING PACKAGE CHECKLIST"]
["INSTRUCTIONS FOR COMPLETION"]
["Form 2.1.1"]
[]
[null,"PURPOSE AND OBJECTIVES"]
[null,"The purpose of this year-end reporting package is to identify for each agency the information necessary to "]
[null,"inform the Comptroller General's Office of events or information obtained subsequent to submission of the "]
[null,"Master Reporting Package Checklist and the other Year-end Reporting Packages which impacts the "]
[null,"accuracy of the information provided.  The evaluation of accuracy must take into account the completeness "]
[null,"of the previously reported information based on knowledge as of the completion of this reporting package."]
[]
[null,"The Agencies Submitting Financial Statements Year-end Reporting Policies and Procedures Manual "]
[null,"provides guidance with regard to GAAP, policies and procedures, and key terms that may assist agency "]
[null,"personnel in responding accurately to the questions included.  Please utilize this resource in conjunction"]
[null,"with the completion of this form."]
[]
[null,"Information included in this package should only impact the Fiscal Year for which the reporting package is "]
[null,"being completed.  It should not include information on transactions funded, inititated, and recorded for the "]
[null,"next reporting fiscal year."]
[]
[null,"If additional questions arise during the completion, please request guidance from the Comptroller "]
[null,"General's Office Financial Reporting Unit."]
[]
[null,"Signature Page"]
[null,"This form should be completed, printed, signed and a PDF copy of the signed sheet sent via e-mail to the "]
[null,"Comptroller General's office.  The user should choose their agency, then type in the preparer's and "]
[null,"reviewers name, title, date prepared/reviewed, e-mail contact and phone number."]
[]
[null,"INSTRUCTIONS FOR COMPLETING THE FORM",null,null,null,null,null,null,null,"2.1.1"]
[null,"This form should be completed after the submission of all other Year-end Reporting Packages."]
[null,"The checklist walks the users through the thought process for identifying errors and omissions in the"]
[null,"agency's summarized financial records (accounting system trial balance) and identifies the areas for which "]
[null,"additional analysis and reporting is required for subsequent events.  It provides guidance on the methods "]
[null,"of communication required for reporting these subsequent events to the Comptroller General's Office.  "]
[null,"● Respond to each question based on knowledge of the agency's activities, operations, and analysis "]
[null,"of transactions."]
[null,"● Follow the instructions for responding to the questions asked and moving through the checklist."]
[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 provided to select the reporting year."]
[null,"►    Drop-down menus are included for the Yes or No responses.  "]
[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 must review the Form indicating agreement with"]
[null,"the information’s accuracy and completeness before sending it to the 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 Checklist to the Comptroller General's Office NO EARLIER THAN October 7 and no later than October 22."]
[null,"● The completed checklist should be retained by the agency as part of its year-end working papers.  The "]
[null,"Comptroller General's Office will telephone the individual completing the checklist if there are any "]
[null,"questions.  The responses to the checklist determines what additional action is required."]

{"sheet":"Signature Page ","index":1,"n_rows":125,"n_cols":6,"rows_kept":125,"cut":false,"hidden":false,"merged":[[124,1,124,5],[25,3,25,4],[112,0,112,5],[116,1,116,5],[118,1,118,5],[120,1,120,5],[122,1,122,5]]}
[null,null,"Subsequent events - Signature Sheet"]
[]
[]
[null,null,"CAFR Reporting Period:",null,2019]
[null,null,"Agency Number:",null,null,{"$f":"IF(AgencyCode=\"\",\"*\",\"\")","v":"*"}]
[null,null,"Agency Name",null,{"$f":"IF(ISERROR(VLOOKUP(E5,C31:D110,2,FALSE))=TRUE,\"\",VLOOKUP(E5,C31:D110,2,FALSE))","v":""}]
[]
[]
[]
[null,null,"Preparer","Date:",null,{"$f":"IF(E10=\"\",\"*\",\"\")","v":"*"}]
[null,null,null,"Name:",null,{"$f":"IF(E11=\"\",\"*\",\"\")","v":"*"}]
[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,{"$f":"IF(E17=\"\",\"*\",\"\")","v":"*"}]
[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,"*",{"$f":"IF(OR(F5=\"*\",F10=\"*\",F11=\"*\",F12=\"*\",F13=\"*\",F14=\"*\",F17=\"*\",F18=\"*\",F19=\"*\",F20=\"*\",F21=\"*\")=TRUE,\"Please complete the above page where indicated by a red star.\",\"Please print a copy of this signature page, have the preparer and reviewer sign, scan a copy of the signed Signature Page and e-mail it to CAFR@CG.SC.GOV.\")","v":"Please complete the above page where indicated by a red star."}]
[]
[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,"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,"R160","SECOND INJURY FUND"]
[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)"]
[]
[]
["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,"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," Special and extraordinary items have been appropriately classified and reported."]
[]
[null," The agency has no transfers, reservations or designations of fund equity or interfund borrowings that were not properly authorized and approved, or uncollectible interfund loans that have not been properly reflected in the reporting packets or disclosed to you."]

{"sheet":"2.1.1","index":2,"n_rows":391,"n_cols":11,"rows_kept":391,"cut":false,"hidden":false,"merged":[[6,6,6,13],[9,6,9,13],[11,6,11,13],[253,3,253,12],[266,3,266,12],[175,4,175,10],[236,4,236,10]]}
[null,null,"STATE OF SOUTH CAROLINA"]
[null,null,"YEAR-END REPORTING PACKAGE "]
[null,null,"SUBSEQUENT EVENT QUESTIONNAIRE"]
[null,null,null,null,null,null,null,null,null,"For the Fiscal Year Ended June 30, ",2019]
[]
[]
[null,null,"Agency:",{"$f":"+'Signature Page '!AgencyCode","v":0},null,null,{"$f":"+'Signature Page '!E6","v":""}]
[null,null,null,"Business Area",null,null,"Name"]
[]
[null,null,"Typed Preparer name:",null,null,null,{"$f":"+'Signature Page '!E11","v":0}]
[]
[null,null,"Typed Reviewer name:",null,null,null,{"$f":"+'Signature Page '!E18","v":0}]
[]
[]
[{"$f":"IF(B15=\"y\",COUNTA(B$14:B15),\"\")","v":""}]
[{"$f":"IF(B16=\"y\",COUNTA(B$14:B16),\"\")","v":""},null,"The following questions have been established in an outline hierarchy.  A NO response to a question advances to the "]
[{"$f":"IF(B17=\"y\",COUNTA(B$14:B17),\"\")","v":""},null,"next question of the same level (i.e. Number 1 response is NO move to Number 2, or NO is the response to part a "]
[{"$f":"IF(B18=\"y\",COUNTA(B$14:B18),\"\")","v":""},null,"of the question move to part b).  A YES response will require additional action through responses to additional "]
[{"$f":"IF(B19=\"y\",COUNTA(B$14:B19),\"\")","v":""},null,"questions at a sub-level, by completion of a Year-End Reporting Package, or by a requirement for submission of "]
[null,null,"additional information with this Checklist."]
[null,null,"Perform a review of the general ledger on an agency wide level and detail fund level to assist in accurately"]
[null,null,"responding to the questions on this reporting package."]
[]
[{"$f":"IF(B24=\"y\",COUNTA(B$14:B24),\"\")","v":1},"y"]
[{"$f":"IF(B25=\"y\",COUNTA(B$14:B25),\"\")","v":""},null,"Does your agency have ownership in investments that are not managed or accounted for by the State "]
[{"$f":"IF(B26=\"y\",COUNTA(B$14:B26),\"\")","v":""},null,"Treasurer's Office? "]
[]
[null,null,"a.  Have these investments experienced a loss since June 30? "]
[]
[null,null,"i.  Do the losses experienced since June 30 exceed 5% of the June 30 fair value? "]
[{"$f":"IF(B31=\"y\",COUNTA(B$14:B31),\"\")","v":""},null,null,"Action:  Provide to the Comptroller General's Office a copy of the most recent valuation "]
[{"$f":"IF(B32=\"y\",COUNTA(B$14:B32),\"\")","v":""},null,null,"statement reporting the investment loss."]
[{"$f":"IF(B33=\"y\",COUNTA(B$14:B33),\"\")","v":""}]
[{"$f":"IF(B34=\"y\",COUNTA(B$14:B34),\"\")","v":2},"y"]
[{"$f":"IF(B35=\"y\",COUNTA(B$14:B35),\"\")","v":""},null,"Did your agency collect and deposit any tax revenues subsequent to year-end?"]
[{"$f":"IF(B36=\"y\",COUNTA(B$14:B36),\"\")","v":""}]
[{"$f":"IF(B37=\"y\",COUNTA(B$14:B37),\"\")","v":""},null,"a.  Were any amounts reported as collectible been identified as uncollectible since submission"]
[{"$f":"IF(B38=\"y\",COUNTA(B$14:B38),\"\")","v":""},null,"of Section 3.02?"]
[{"$f":"IF(B39=\"y\",COUNTA(B$14:B39),\"\")","v":""},null,null,"Action: Provide to the Comptroller General's Office a summary by type of tax the amount"]
[{"$f":"IF(B40=\"y\",COUNTA(B$14:B40),\"\")","v":""},null,null,"that has been deemed uncollectible subsequent to submission of Section 3.02."]
[null,null,null,"Include a description of the situation, when the circumstances changed, and how"]
[null,null,null,"the agency identified the change in the situation."]
[{"$f":"IF(B43=\"y\",COUNTA(B$14:B43),\"\")","v":""}]
[]
[null,null,"b.  Have amounts been identified as receivables as of year-end in addition to the amounts submitted"]
[null,null,"on Section 3.02?"]
[null,null,null,"Action: Provide to the Comptroller General's Office a summary by type of tax of amounts"]
[null,null,null,"identified subsequent to submission of Section 3.02."]
[null,null,null,"Include a description of the situation, when the circumstances changed, and how"]
[null,null,null,"the agency identified the change in the situation."]
[]
[{"$f":"IF(B52=\"y\",COUNTA(B$14:B52),\"\")","v":3},"y"]
[null,null,"Did your agency report any receivables from federal or private grants or contracts or other "]
[{"$f":"IF(B54=\"y\",COUNTA(B$14:B54),\"\")","v":""},null,"contributions in Section 3.03?"]
[{"$f":"IF(B55=\"y\",COUNTA(B$14:B55),\"\")","v":""},null,"      "]
[{"$f":"IF(B56=\"y\",COUNTA(B$14:B56),\"\")","v":""},null,"a.  Were any amounts reported as collectible been identified as uncollectible since submission"]
[{"$f":"IF(B57=\"y\",COUNTA(B$14:B57),\"\")","v":""},null,"of Section 3.03?"]
[{"$f":"IF(B58=\"y\",COUNTA(B$14:B58),\"\")","v":""},null,null,"Action: Provide to the Comptroller General's Office a detailed list by grantor's grant number "]
[{"$f":"IF(B59=\"y\",COUNTA(B$14:B59),\"\")","v":""},null,null,"of amounts identified as uncollectible subsequent to submission of Section 3.03."]
[null,null,null,"Include a description of the situation, when the circumstances changed, and how"]
[null,null,null,"the agency identified the change in the situation."]
[{"$f":"IF(B62=\"y\",COUNTA(B$14:B62),\"\")","v":""}]
[]
[null,null,"b.  Have amounts been identified as receivables as of year-end in addition to the amounts submitted"]
[null,null,"on Section 3.03?  Hint: if you are submitting additional prior year payables for grant funds"]
[null,null,"then the receivables are impacted by those additional prior year payables."]
[null,null,null,"Please provide an updated 3.03 grants packet to include the additional prior year payables."]
[]
[{"$f":"IF(B69=\"y\",COUNTA(B$14:B69),\"\")","v":4},"y"]
[{"$f":"IF(B70=\"y\",COUNTA(B$14:B70),\"\")","v":""},null,"Did your agency report any receivables in Section 3.04?"]
[]
[null,null,"a.  Have any amounts reported on Section 3.04 been identified as overstated or understated?"]
[null,null,null,"Action: Provide to the Comptroller General's Office a listing by fund of amounts identified as "]
[null,null,null,"overstated or understated subsequent to submission of Section 3.04. Include evaluation "]
[null,null,null,"regarding the timing of expected collection (i.e. current v. noncurrent) and a "]
[null,null,null,"description of the situation, when the circumstances changed, and how the agency "]
[{"$f":"IF(B77=\"y\",COUNTA(B$14:B77),\"\")","v":""},null,null,"identified the change in the situation."]
[]
[{"$f":"IF(B79=\"y\",COUNTA(B$14:B79),\"\")","v":5},"y"]
[{"$f":"IF(B80=\"y\",COUNTA(B$14:B80),\"\")","v":""},null,"Did your agency report any unearned revenue in Section 3.05?"]
[]
[null,null,"a.  Have any amounts reported on Section 3.05 been identified as overstated or understated?"]
[null,null,null,"Action: Provide to the Comptroller General's Office a listing by fund and general ledger "]
[null,null,null,"account of amounts identified as overstated or understated subsequent to submission"]
[null,null,null,"of Section 3.05. Include the classification (i.e. patient services, tuition and student "]
[null,null,null,"services, or other unearned revenue) and a description of the situation, when the  "]
[{"$f":"IF(B87=\"y\",COUNTA(B$14:B87),\"\")","v":""},null,null,"circumstances changed, and how the agency identified the change in the situation."]
[]
[{"$f":"IF(B89=\"y\",COUNTA(B$14:B89),\"\")","v":6},"y"]
[{"$f":"IF(B90=\"y\",COUNTA(B$14:B90),\"\")","v":""},null,"Did your agency report any inventory in Section 3.06? "]
[{"$f":"IF(B91=\"y\",COUNTA(B$14:B91),\"\")","v":""}]
[null,null,"a.  Have any amounts reported on Section 3.06 been identified as overstated or understated?"]
[{"$f":"IF(B93=\"y\",COUNTA(B$14:B93),\"\")","v":""},null,null,"Action: Provide to the Comptroller General's Office a listing by fund and expense account of"]
[null,null,null,"amounts identified as overstated or understated subsequent to submission of Section "]
[null,null,null,"3.06. Include a description of the situation, when the circumstances changed, and how "]
[null,null,null,"the agency identified the change in the situation."]
[{"$f":"IF(B97=\"y\",COUNTA(B$14:B148),\"\")","v":""}]
[{"$f":"IF(B98=\"y\",COUNTA(B$14:B98),\"\")","v":7},"y"]
[{"$f":"IF(B99=\"y\",COUNTA(B$14:B99),\"\")","v":""},null,"Did your agency report any prepaid expenses in Section 3.07?"]
[]
[null,null,"a.  Have any amounts reported on Section 3.07 been identified as overstated or understated?"]
[null,null,null,"Action: Provide to the Comptroller General's Office a listing by fund and general ledger account "]
[null,null,null,"of amounts identified as overstated or understated subsequent to submission of Section "]
[null,null,null,"3.07. Include the classification (i.e. current v. noncurrent) and a description of the "]
[{"$f":"IF(B105=\"y\",COUNTA(B$14:B105),\"\")","v":""},null,null,"situation, when the circumstances changed, and how the agency identified the change in "]
[null,null,null,"the situation."]
[]
[{"$f":"IF(B108=\"y\",COUNTA(B$14:B108),\"\")","v":8},"y"]
[{"$f":"IF(B109=\"y\",COUNTA(B$14:B109),\"\")","v":""},null,"Did your agency submit outstanding balances for loans or notes receivable on forms within "]
[{"$f":"IF(B110=\"y\",COUNTA(B$14:B110),\"\")","v":""},null,"Section 3.10?"]
[]
[null,null,"a.  Were any amounts reported as collectible been identified as uncollectible since submission"]
[null,null,"of Section 3.10?"]
[null,null,null,"Action: Provide to the Comptroller General's Office a detailed list by borrower (counter-party)"]
[null,null,null,"of amounts identified as uncollectible subsequent to submission of Section 3.10."]
[null,null,null,"Include a description of the situation, when the circumstances changed, and how"]
[null,null,null,"the agency identified the change in the situation."]
[]
[{"$f":"IF(B119=\"y\",COUNTA(B$14:B119),\"\")","v":9},"y"]
[{"$f":"IF(B120=\"y\",COUNTA(B$14:B120),\"\")","v":""},null,"Did your agency report any disallowances or penalties in Section 3.14?"]
[{"$f":"IF(B121=\"y\",COUNTA(B$14:B121),\"\")","v":""}]
[{"$f":"IF(B122=\"y\",COUNTA(B$14:B122),\"\")","v":""},null,"a.  Have any amounts reported on Section 3.14 been identified as overstated or understated?"]
[{"$f":"IF(B123=\"y\",COUNTA(B$14:B123),\"\")","v":""},null,null,"Action: Provide to the Comptroller General's Office a listing of amounts identified as overstated "]
[{"$f":"IF(B124=\"y\",COUNTA(B$14:B124),\"\")","v":""},null,null,"or understated subsequent to submission of Section 3.14. Include the fund, State fiscal "]
[null,null,null,"year amounts are due, a description of the situation, when the circumstances changed, "]
[{"$f":"IF(B126=\"y\",COUNTA(B$14:B126),\"\")","v":""},null,null,"and how the agency identified the change in the situation. If possible, send a copy of "]
[null,null,null,"the updated settlement agreement."]
[]
[{"$f":"IF(B129=\"y\",COUNTA(B$14:B129),\"\")","v":10},"y"]
[{"$f":"IF(B130=\"y\",COUNTA(B$14:B130),\"\")","v":""},null,"Did your agency have any disallowance or penalty situations not reported in Section 3.14 that may require "]
[{"$f":"IF(B131=\"y\",COUNTA(B$14:B131),\"\")","v":""},null,"future payments or reduced revenues after year-end (June 30)?"]
[null,null,"a.  Is it probable (likely) that your agency had a disallowance or penalty that occurred before year-end?"]
[{"$f":"IF(B133=\"y\",COUNTA(B$14:B133),\"\")","v":""},null,null,"Action: Provide to the Comptroller General's Office an estimate or estimate range of the payments "]
[null,null,null,"or reduced revenues. If an estimate range is used please also include if some amount within the  "]
[null,null,null,"range appears at the time to be a better estimate than any other amount within the range. Include"]
[null,null,null,"the fund(s) responsible for payment, State fiscal year amounts are due, a description of the "]
[null,null,null,"situation, name of the entity assessing the disallowance or penalty, information about a receivable "]
[null,null,null,"from outside the State reporting entity for a portion or all of this liability (if applicable), and "]
[null,null,null,"pass-through information (if applicable). If possible, send a copy of related correspondences "]
[null,null,null,"with the entity assessing the disallowance or penalty, the outside entity paying a portion or all "]
[null,null,null,"of this liability (if applicable), and the pass-through entity (if applicable)."]
[]
[null,null,"b.  Is it reasonably possible (more than remote but less than likely) that your agency had a disallowance "]
[null,null,"or penalty that occurred before year-end or a disallowance or penalty that occurred after year-end?"]
[{"$f":"IF(B145=\"y\",COUNTA(B$14:B145),\"\")","v":""},null,null,"Action: Provide to the Comptroller General's Office a description of the situation, timing of when it "]
[null,null,null,"was identified, an estimate of the liability or estimate range or explanation why no estimate is "]
[null,null,null,"available, and potential timing for payments (current or non-current )."]
[]
[{"$f":"IF(B149=\"y\",COUNTA(B$14:B149),\"\")","v":11},"y"]
[{"$f":"IF(B150=\"y\",COUNTA(B$14:B150),\"\")","v":""},null,"Did your agency report any capital assets owned as of June 30?"]
[]
[null,null,"a.  Has your agency obtained or received information which indicates impairment in the valuation "]
[null,null,"of any capital asset reported?"]
[null,null,null,"Action: Provide to the Comptroller General's Office a detailed list by asset number, "]
[null,null,null,"circumstance affecting the value, value previously reported and value based on "]
[{"$f":"IF(B156=\"y\",COUNTA(B$14:B156),\"\")","v":""},null,null,"the additional information obtained.  Include a description of the situation, when "]
[{"$f":"IF(B157=\"y\",COUNTA(B$14:B157),\"\")","v":""},null,null,"the circumstances changed, and how the agency identified the change in the "]
[null,null,null,"situation."]
[{"$f":"IF(B159=\"y\",COUNTA(B$14:B159),\"\")","v":""}]
[{"$f":"IF(B160=\"y\",COUNTA(B$14:B160),\"\")","v":12},"y"]
[{"$f":"IF(B161=\"y\",COUNTA(B$14:B161),\"\")","v":""},null,"Has your agency entered into any contractual modifications relating to settlements, leases, claims, or"]
[{"$f":"IF(B162=\"y\",COUNTA(B$14:B162),\"\")","v":""},null,"other transactions with future financial benefit since June 30 not reported previously?"]
[{"$f":"IF(B163=\"y\",COUNTA(B$14:B163),\"\")","v":""},null,null,"Action: Provide to the Comptroller General's Office a detailed list of the contractual "]
[null,null,null,"modifications. Include a description of the situation, the effective date of the  "]
[null,null,null,"modifications, the execution date of the transaction, and the financial impact"]
[null,null,null,"of the modification."]
[{"$f":"IF(B167=\"y\",COUNTA(B$14:B167),\"\")","v":""}]
[{"$f":"IF(B168=\"y\",COUNTA(B$14:B168),\"\")","v":13},"y"]
[{"$f":"IF(B169=\"y\",COUNTA(B$14:B169),\"\")","v":""},null,"Has agency personnel continued the evaluation of liabilities subsequent to the submission of the "]
[{"$f":"IF(B170=\"y\",COUNTA(B$14:B170),\"\")","v":""},null,"forms in Section 3.12?"]
[{"$f":"IF(B171=\"y\",COUNTA(B$14:B171),\"\")","v":""}]
[{"$f":"IF(B172=\"y\",COUNTA(B$14:B172),\"\")","v":""},null,"a.  Were additional liabilities identified in the process? "]
[null,null,null,"IF YES:"]
[null,null,null,"Action:  Complete the Subsequent Events AP Worksheet for payables not reported on "]
[null,null,null,"package 3.12. Do not include payables already reported on the 3.12 package."]
[null,null,null,null,"Show the AP Worksheet"]
[{"$f":"IF(B177=\"y\",COUNTA(B$14:B177),\"\")","v":""}]
[{"$f":"IF(B178=\"y\",COUNTA(B$14:B178),\"\")","v":""},null,null,"IF NO:"]
[{"$f":"IF(B179=\"y\",COUNTA(B$14:B179),\"\")","v":""},null,null,"Action:  Provide the date through which the evaluation was performed."]
[{"$f":"IF(B180=\"y\",COUNTA(B$14:B180),\"\")","v":""}]
[{"$f":"IF(B181=\"y\",COUNTA(B$14:B181),\"\")","v":14},"y"]
[{"$f":"IF(B182=\"y\",COUNTA(B$14:B182),\"\")","v":""},null,"Has the agency identified any late submissions of leave or time without pay for time prior "]
[null,null,"to year-end (PT_BAL00 report can assist with this evaluation)?"]
[{"$f":"IF(B184=\"y\",COUNTA(B$14:B184),\"\")","v":""},null,null,"Action:  Provide a schedule of the submissions including the following information:"]
[{"$f":"IF(B185=\"y\",COUNTA(B$14:B185),\"\")","v":""},null,null,null,"Date submission received or entered"]
[{"$f":"IF(B186=\"y\",COUNTA(B$14:B186),\"\")","v":""},null,null,null,"Number of hours reported"]
[{"$f":"IF(B187=\"y\",COUNTA(B$14:B187),\"\")","v":""},null,null,null,"Wage of the employee(s) concerned"]
[{"$f":"IF(B188=\"y\",COUNTA(B$14:B188),\"\")","v":""},null,null,null,"Valuation of effect of late submission"]
[null,null,null,null,"Fund from which funding for payment was made"]
[{"$f":"IF(B190=\"y\",COUNTA(B$14:B190),\"\")","v":""},null,null,null,"Control in place to prevent from happening."]
[null,null,null,null,"Description of modifications of the controls to prevent in the future"]
[{"$f":"IF(B192=\"y\",COUNTA(B$14:B192),\"\")","v":""}]
[{"$f":"IF(B193=\"y\",COUNTA(B$14:B193),\"\")","v":15},"y"]
[{"$f":"IF(B194=\"y\",COUNTA(B$14:B194),\"\")","v":""},null,"Have any payrolls after July 16th included payments due to employees, "]
[{"$f":"IF(B195=\"y\",COUNTA(B$14:B195),\"\")","v":""},null,"including retirees, who terminated State employment on or before June 30?"]
[{"$f":"IF(B196=\"y\",COUNTA(B$14:B196),\"\")","v":""},null,null,"Action:  Prepare a schedule of payments for these employees which shows total"]
[{"$f":"IF(B197=\"y\",COUNTA(B$14:B197),\"\")","v":""},null,null,"gross pay by fund.  Do not list employees individually.  "]
[{"$f":"IF(B198=\"y\",COUNTA(B$14:B198),\"\")","v":""},null,null,"Provide an explanation of the circumstances giving rise to the incident. "]
[{"$f":"IF(B199=\"y\",COUNTA(B$14:B199),\"\")","v":""},null,null,"Also, please include the name and phone number of a person within "]
[{"$f":"IF(B200=\"y\",COUNTA(B$14:B200),\"\")","v":""},null,null,"your agency that we may contact, if necessary.  "]
[{"$f":"IF(B201=\"y\",COUNTA(B$14:B201),\"\")","v":""}]
[{"$f":"IF(B202=\"y\",COUNTA(B$14:B202),\"\")","v":16},"y"]
[{"$f":"IF(B203=\"y\",COUNTA(B$14:B203),\"\")","v":""},null,"Did your agency offer special termination benefits to any employees after the fiscal year?"]
[{"$f":"IF(B204=\"y\",COUNTA(B$14:B204),\"\")","v":""},null,null,"Action:  Provide a description of the transaction(s) and an estimate of the "]
[{"$f":"IF(B205=\"y\",COUNTA(B$14:B205),\"\")","v":""},null,null,"amount(s) owed at June 30 in a letter or other attachment when you"]
[{"$f":"IF(B206=\"y\",COUNTA(B$14:B206),\"\")","v":""},null,null,"return this completed Reporting Package Checklist to the "]
[{"$f":"IF(B207=\"y\",COUNTA(B$14:B207),\"\")","v":""},null,null,"Comptroller General's Office."]
[{"$f":"IF(B208=\"y\",COUNTA(B$14:B208),\"\")","v":""}]
[{"$f":"IF(B209=\"y\",COUNTA(B$14:B209),\"\")","v":17},"y"]
[null,null,"After submission of the forms in Section 3.18, did your agency identify any IDT's (unpaid) and/or "]
[{"$f":"IF(B211=\"y\",COUNTA(B$14:B211),\"\")","v":""},null,"disbursement vouchers to another agency within the State's financial reporting that were excluded "]
[{"$f":"IF(B212=\"y\",COUNTA(B$14:B212),\"\")","v":""},null,"from that reporting?"]
[{"$f":"IF(B213=\"y\",COUNTA(B$14:B213),\"\")","v":""},null,null,"Action: Provide to the Comptroller General's Office a list by fund of the amounts identified"]
[null,null,null,"and the counter-parties in the transactions."]
[{"$f":"IF(B215=\"y\",COUNTA(B$14:B215),\"\")","v":""}]
[{"$f":"IF(B216=\"y\",COUNTA(B$14:B216),\"\")","v":18},"y"]
[{"$f":"IF(B217=\"y\",COUNTA(B$14:B217),\"\")","v":""},null,"Has your agency reached an agreement subsequent to year-end with another agency that provided or "]
[{"$f":"IF(B218=\"y\",COUNTA(B$14:B218),\"\")","v":""},null,"received resources to/from your agency during the fiscal year that those resources would not be repaid?  "]
[{"$f":"IF(B219=\"y\",COUNTA(B$14:B219),\"\")","v":""},null,"In other words, has a previously recognized receivable/payable (loan or account) been forgiven?"]
[{"$f":"IF(B220=\"y\",COUNTA(B$14:B220),\"\")","v":""},null,null,"Action:  Describe the situation in a letter or other attachment when you return this"]
[{"$f":"IF(B221=\"y\",COUNTA(B$14:B221),\"\")","v":""},null,null,"Reporting Package Control Checklist to the Comptroller General's Office."]
[{"$f":"IF(B222=\"y\",COUNTA(B$14:B222),\"\")","v":""},null,null,"Please provide details of your understanding with the other agency."]
[{"$f":"IF(B223=\"y\",COUNTA(B$14:B223),\"\")","v":""}]
[{"$f":"IF(B224=\"y\",COUNTA(B$14:B224),\"\")","v":19},"y"]
[{"$f":"IF(B225=\"y\",COUNTA(B$14:B225),\"\")","v":""},null,"Has a previously reported note or repayment contract for a borrowing between accounting funds "]
[{"$f":"IF(B226=\"y\",COUNTA(B$14:B226),\"\")","v":""},null,"within your agency been forgiven subsequent to year-end?"]
[{"$f":"IF(B227=\"y\",COUNTA(B$14:B227),\"\")","v":""},null,null,"Action:  Describe the situation in a letter or other attachment when you return this"]
[{"$f":"IF(B228=\"y\",COUNTA(B$14:B228),\"\")","v":""},null,null,"Reporting Package Control Checklist to the Comptroller General's Office."]
[{"$f":"IF(B229=\"y\",COUNTA(B$14:B229),\"\")","v":""},null,null,"Please provide details of the plans for return of resources (repayment) between "]
[{"$f":"IF(B230=\"y\",COUNTA(B$14:B230),\"\")","v":""},null,null,"the funds within your agency."]
[{"$f":"IF(B231=\"y\",COUNTA(B$14:B231),\"\")","v":""}]
[{"$f":"IF(B232=\"y\",COUNTA(B$14:B232),\"\")","v":20},"y"]
[{"$f":"IF(B233=\"y\",COUNTA(B$14:B233),\"\")","v":""},null,"Has your agency identify any additional refunds of revenue owed to other parties (excluding income "]
[{"$f":"IF(B234=\"y\",COUNTA(B$14:B234),\"\")","v":""},null,"tax refunds) after the submission of the forms in Section 3.12?"]
[{"$f":"IF(B235=\"y\",COUNTA(B$14:B235),\"\")","v":""},null,null,"Action:  Complete the Subsequent Events AP Worksheet for payables not reported on "]
[{"$f":"IF(B236=\"y\",COUNTA(B$14:B236),\"\")","v":""},null,null,"package 3.12. Do not include payables already reported on the 3.12 package."]
[{"$f":"IF(B237=\"y\",COUNTA(B$14:B237),\"\")","v":""},null,null,null,"Show the AP Worksheet"]
[{"$f":"IF(B238=\"y\",COUNTA(B$14:B238),\"\")","v":""}]
[{"$f":"IF(B239=\"y\",COUNTA(B$14:B239),\"\")","v":21},"y"]
[{"$f":"IF(B240=\"y\",COUNTA(B$14:B240),\"\")","v":""},null,"Has your agency used installment purchase financing for acquisition of capital assets since year-end?"]
[null,null,null,"Action:  Provide a description of the transaction(s) including the accounting fund(s) involved, "]
[null,null,null,"terms of the borrowing, and the dollar amount of the proceeds."]
[]
[{"$f":"IF(B244=\"y\",COUNTA(B$14:B244),\"\")","v":22},"y"]
[{"$f":"IF(B245=\"y\",COUNTA(B$14:B245),\"\")","v":""},null,"Has your agency issued/executed bonds or notes payable to parties outside State government"]
[{"$f":"IF(B246=\"y\",COUNTA(B$14:B246),\"\")","v":""},null,"since June 30?"]
[{"$f":"IF(B247=\"y\",COUNTA(B$14:B247),\"\")","v":""},null,null,"Action:  Describe the situation in a letter or other attachment to this Reporting"]
[{"$f":"IF(B248=\"y\",COUNTA(B$14:B248),\"\")","v":""},null,null,"Package Checklist to the Comptroller General's Office.  Include authorization,"]
[{"$f":"IF(B249=\"y\",COUNTA(B$14:B249),\"\")","v":""},null,null,"Lender, Amount of Note, Date of Note, Collateral, Terms of repayment, "]
[{"$f":"IF(B250=\"y\",COUNTA(B$14:B250),\"\")","v":""},null,null,"and Balance as of year-end."]
[{"$f":"IF(B251=\"y\",COUNTA(B$14:B251),\"\")","v":""}]
[{"$f":"IF(B252=\"y\",COUNTA(B$14:B252),\"\")","v":23},"y"]
[{"$f":"IF(B253=\"y\",COUNTA(B$14:B253),\"\")","v":""},null,"Did you complete forms within Section 3.13 which reported on-going litigation cases at year-end?"]
[{"$f":"IF(B254=\"y\",COUNTA(B$14:B254),\"\")","v":""},null,null,"Action:  An UPDATED Litigation Reporting Package is required (See Section 3.13) or a letter from the attorney/paralegal providing an update on any cases previously reported and any new cases since the reporting packet was submitted."]
[{"$f":"IF(B255=\"y\",COUNTA(B$14:B255),\"\")","v":""},null,null,"Subsequent should be selected as the period through which evaluated."]
[{"$f":"IF(B256=\"y\",COUNTA(B$14:B256),\"\")","v":""}]
[{"$f":"IF(B257=\"y\",COUNTA(B$14:B257),\"\")","v":24},"y"]
[{"$f":"IF(B258=\"y\",COUNTA(B$14:B258),\"\")","v":""},null,"Were claims payables/liabilities reported in the Claims Reporting Package (Section 3.15) for your "]
[{"$f":"IF(B259=\"y\",COUNTA(B$14:B259),\"\")","v":""},null,"agency this fiscal year?"]
[{"$f":"IF(B260=\"y\",COUNTA(B$14:B260),\"\")","v":""},null,null,"Action:  An UPDATED Claims Reporting Package is required (See Section 3.15.2)."]
[{"$f":"IF(B261=\"y\",COUNTA(B$14:B261),\"\")","v":""},null,null,"Subsequent should be selected as the period through which evaluated."]
[{"$f":"IF(B262=\"y\",COUNTA(B$14:B262),\"\")","v":""}]
[{"$f":"IF(B263=\"y\",COUNTA(B$14:B263),\"\")","v":25},"y"]
[{"$f":"IF(B264=\"y\",COUNTA(B$14:B264),\"\")","v":""},null,"Were estimated loss liabilities, contingencies, or commitments reported (Form 3.16.2) for your "]
[{"$f":"IF(B265=\"y\",COUNTA(B$14:B265),\"\")","v":""},null,"agency this fiscal year?"]
[{"$f":"IF(B266=\"y\",COUNTA(B$14:B266),\"\")","v":""},null,null,"Action:  An UPDATED Miscellaneous Loss Liabilities, Loss Contingencies, and "]
[{"$f":"IF(B267=\"y\",COUNTA(B$14:B267),\"\")","v":""},null,null,"Commitments Reporting Package is required for any changes or additions from the previous reporting but still reflective of FY18 related activity only."]
[null,null,null,"Subsequent should be selected as the period through which evaluated."]
[{"$f":"IF(B269=\"y\",COUNTA(B$14:B269),\"\")","v":""}]
[{"$f":"IF(B270=\"y\",COUNTA(B$14:B270),\"\")","v":26},"y"]
[{"$f":"IF(B271=\"y\",COUNTA(B$14:B271),\"\")","v":""},null,"Did your agency participate in or administer any risk management activities subsequent to the "]
[{"$f":"IF(B272=\"y\",COUNTA(B$14:B272),\"\")","v":""},null,"fiscal year other than those listed in Appendix C of the Year-End Reporting Procedures"]
[{"$f":"IF(B273=\"y\",COUNTA(B$14:B273),\"\")","v":""},null,"Manual?"]
[{"$f":"IF(B274=\"y\",COUNTA(B$14:B274),\"\")","v":""},null,null,"Action:  Describe the situation in a letter or other attachment when you return this"]
[{"$f":"IF(B275=\"y\",COUNTA(B$14:B275),\"\")","v":""},null,null,"Reporting Package Checklist to the Comptroller General's Office."]
[{"$f":"IF(B276=\"y\",COUNTA(B$14:B276),\"\")","v":""},null,null,"Be sure to fully describe the activity and whether you self-insure the"]
[{"$f":"IF(B277=\"y\",COUNTA(B$14:B277),\"\")","v":""},null,null,"activity, purchase insurance to cover the activity, or provide insurance"]
[{"$f":"IF(B278=\"y\",COUNTA(B$14:B278),\"\")","v":""},null,null,"coverage to other entities for this activity.  Also, please include the name"]
[{"$f":"IF(B279=\"y\",COUNTA(B$14:B279),\"\")","v":""},null,null,"and phone number of a person within your agency that we may contact"]
[{"$f":"IF(B280=\"y\",COUNTA(B$14:B280),\"\")","v":""},null,null,"to obtain additional information,  if necessary."]
[{"$f":"IF(B281=\"y\",COUNTA(B$14:B281),\"\")","v":""}]
[{"$f":"IF(B282=\"y\",COUNTA(B$14:B282),\"\")","v":27},"y"]
[{"$f":"IF(B283=\"y\",COUNTA(B$14:B283),\"\")","v":""},null,"Each agency is responsible for designing and implementing processes, procedures, and controls to "]
[{"$f":"IF(B284=\"y\",COUNTA(B$14:B284),\"\")","v":""},null,"prevent and detect fraud.  Are you aware of any instances of fraud or suspected fraud affecting "]
[{"$f":"IF(B285=\"y\",COUNTA(B$14:B285),\"\")","v":""},null,"your agency since the end of the fiscal year (June 30) involving (a) management,  (b) employees "]
[{"$f":"IF(B286=\"y\",COUNTA(B$14:B286),\"\")","v":""},null,"who have significant roles in internal control, or (c) others where the fraud could have a"]
[{"$f":"IF(B287=\"y\",COUNTA(B$14:B287),\"\")","v":""},null,"financial impact on the agency."]
[{"$f":"IF(B288=\"y\",COUNTA(B$14:B288),\"\")","v":""},null,null,"Action:   Describe the situation on agency letterhead signed by the Agency Director"]
[{"$f":"IF(B289=\"y\",COUNTA(B$14:B289),\"\")","v":""},null,null,"or designee when this Reporting Package Checklist is returned to the "]
[{"$f":"IF(B290=\"y\",COUNTA(B$14:B290),\"\")","v":""},null,null,"Comptroller General's Office.  "]
[{"$f":"IF(B291=\"y\",COUNTA(B$14:B291),\"\")","v":""},null,null,"Be sure to fully describe the activity, the amount (or approximate amount) "]
[{"$f":"IF(B292=\"y\",COUNTA(B$14:B292),\"\")","v":""},null,null,"of the fraud or suspected fraud, and the resulting actions by management "]
[{"$f":"IF(B293=\"y\",COUNTA(B$14:B293),\"\")","v":""},null,null,"to prevent further fraudulent activities."]
[{"$f":"IF(B294=\"y\",COUNTA(B$14:B294),\"\")","v":""}]
[{"$f":"IF(B295=\"y\",COUNTA(B$14:B295),\"\")","v":28},"y"]
[null,null,"Are you aware of any allegations of fraud or suspected fraud (in addition to the known reported in "]
[{"$f":"IF(B297=\"y\",COUNTA(B$14:B297),\"\")","v":""},null,"question 27 above) affecting your agency after the end of the fiscal year (June 30) (e.g. that the "]
[{"$f":"IF(B298=\"y\",COUNTA(B$14:B298),\"\")","v":""},null,"agency has received in communications from employees, former employees, analysts, regulators"]
[{"$f":"IF(B299=\"y\",COUNTA(B$14:B299),\"\")","v":""},null,"regulators, short sellers, or others)?"]
[{"$f":"IF(B300=\"y\",COUNTA(B$14:B300),\"\")","v":""},null,null,"Action:   Describe the situation on agency letterhead signed by the Agency Director"]
[{"$f":"IF(B301=\"y\",COUNTA(B$14:B301),\"\")","v":""},null,null,"or designee when this Reporting Package Checklist is returned to the "]
[{"$f":"IF(B302=\"y\",COUNTA(B$14:B302),\"\")","v":""},null,null,"Comptroller General's Office.  "]
[{"$f":"IF(B303=\"y\",COUNTA(B$14:B303),\"\")","v":""},null,null,"Be sure to fully describe the allegation(s) and any actions taken by "]
[{"$f":"IF(B304=\"y\",COUNTA(B$14:B304),\"\")","v":""},null,null,"management to strengthen the internal controls that may have been "]
[{"$f":"IF(B305=\"y\",COUNTA(B$14:B305),\"\")","v":""},null,null,"breached if the allegations prove true."]
[]
[{"$f":"IF(B307=\"y\",COUNTA(B$14:B307),\"\")","v":29},"y"]
[null,null,"Since submission of the Master Reporting Checklist, has your agency had any communications "]
[{"$f":"IF(B309=\"y\",COUNTA(B$14:B309),\"\")","v":""},null,"from regulatory agencies concerning noncompliance with, or deficiencies in, financial reporting "]
[{"$f":"IF(B310=\"y\",COUNTA(B$14:B310),\"\")","v":""},null,"practices that were not previously reported?"]
[{"$f":"IF(B311=\"y\",COUNTA(B$14:B311),\"\")","v":""},null,null,"Action:   Provide copies of the communications and a summary of the corrective"]
[{"$f":"IF(B312=\"y\",COUNTA(B$14:B312),\"\")","v":""},null,null,"actions when this Reporting Package Checklist is returned to the"]
[{"$f":"IF(B313=\"y\",COUNTA(B$14:B313),\"\")","v":""},null,null,"Comptroller General's Office.  "]
[{"$f":"IF(B314=\"y\",COUNTA(B$14:B314),\"\")","v":""}]
[{"$f":"IF(B315=\"y\",COUNTA(B$14:B315),\"\")","v":30},"y"]
[null,null,"Since submission of the Master Reporting Checklist, has your agency identified any new situations "]
[{"$f":"IF(B317=\"y\",COUNTA(B$14:B317),\"\")","v":""},null,"of either of the following:"]
[{"$f":"IF(B318=\"y\",COUNTA(B$14:B318),\"\")","v":""},null,"--  Any violations or possible violations of laws or regulations that will not be reported"]
[{"$f":"IF(B319=\"y\",COUNTA(B$14:B319),\"\")","v":""},null,"in an existing reporting package?"]
[{"$f":"IF(B320=\"y\",COUNTA(B$14:B320),\"\")","v":""},null,"OR"]
[{"$f":"IF(B321=\"y\",COUNTA(B$14:B321),\"\")","v":""},null,"--  Any instances of noncompliance with applicable laws, regulations, contracts and"]
[{"$f":"IF(B322=\"y\",COUNTA(B$14:B322),\"\")","v":""},null,"grants that will not be reported in an existing reporting package or addressed in "]
[{"$f":"IF(B323=\"y\",COUNTA(B$14:B323),\"\")","v":""},null,"the previous question regarding financial reporting practices? "]
[{"$f":"IF(B324=\"y\",COUNTA(B$14:B324),\"\")","v":""},null,null,"Action:  Provide an explanation of the violation or instance of noncompliance "]
[{"$f":"IF(B325=\"y\",COUNTA(B$14:B325),\"\")","v":""},null,null,"as an attachment to this Reporting Package Checklist to the "]
[{"$f":"IF(B326=\"y\",COUNTA(B$14:B326),\"\")","v":""},null,null,"Comptroller General's Office."]
[{"$f":"IF(B327=\"y\",COUNTA(B$14:B327),\"\")","v":""}]
[{"$f":"IF(B328=\"y\",COUNTA(B$14:B328),\"\")","v":31},"y"]
[null,null,"Since submission of the Master Reporting Checklist, has your agency become aware of information "]
[{"$f":"IF(B330=\"y\",COUNTA(B$14:B330),\"\")","v":""},null,"which would indicate a polluted site or the potential of pollution or contamination of a site?"]
[{"$f":"IF(B331=\"y\",COUNTA(B$14:B331),\"\")","v":""},null,"Since the submission of the Master Reporting Checklist,"]
[{"$f":"IF(B332=\"y\",COUNTA(B$14:B332),\"\")","v":""},null,"a. Has your agency been compelled to take remediation action because pollution"]
[{"$f":"IF(B333=\"y\",COUNTA(B$14:B333),\"\")","v":""},null,"creates an imminent endangerment to public health or welfare or the environment?"]
[{"$f":"IF(B334=\"y\",COUNTA(B$14:B334),\"\")","v":""},null,null,"Action:  Please create and attach a list of the events identified, including a brief "]
[{"$f":"IF(B335=\"y\",COUNTA(B$14:B335),\"\")","v":""},null,null,"description of the potential obligation and the status of assessment of the"]
[{"$f":"IF(B336=\"y\",COUNTA(B$14:B336),\"\")","v":""},null,null,"event when this Reporting Package Checklist is returned to the Comptroller "]
[{"$f":"IF(B337=\"y\",COUNTA(B$14:B337),\"\")","v":""},null,null,"General's Office."]
[{"$f":"IF(B338=\"y\",COUNTA(B$14:B338),\"\")","v":""}]
[{"$f":"IF(B339=\"y\",COUNTA(B$14:B339),\"\")","v":""}]
[{"$f":"IF(B340=\"y\",COUNTA(B$14:B340),\"\")","v":""},null,"b. Has your agency violated a pollution prevention-related permit or license? "]
[{"$f":"IF(B341=\"y\",COUNTA(B$14:B341),\"\")","v":""},null,null,"Action:  Please create and attach a list of the events identified, including a brief "]
[{"$f":"IF(B342=\"y\",COUNTA(B$14:B342),\"\")","v":""},null,null,"description of the potential obligation and the status of assessment of the"]
[{"$f":"IF(B343=\"y\",COUNTA(B$14:B343),\"\")","v":""},null,null,"event when this Reporting Package Checklist is returned to the Comptroller "]
[{"$f":"IF(B344=\"y\",COUNTA(B$14:B344),\"\")","v":""},null,null,"General's Office."]
[{"$f":"IF(B345=\"y\",COUNTA(B$14:B345),\"\")","v":""}]
[{"$f":"IF(B346=\"y\",COUNTA(B$14:B346),\"\")","v":""}]
[{"$f":"IF(B347=\"y\",COUNTA(B$14:B347),\"\")","v":""},null,"c. Has your agency been named, or does evidence indicate that your agency will be named,"]
[{"$f":"IF(B348=\"y\",COUNTA(B$14:B348),\"\")","v":""},null,"by a regulator as a responsible party or potentially responsible party for remediation,"]
[{"$f":"IF(B349=\"y\",COUNTA(B$14:B349),\"\")","v":""},null,"or as a government responsible for sharing costs?"]
[{"$f":"IF(B350=\"y\",COUNTA(B$14:B350),\"\")","v":""},null,null,"Action:  Please create and attach a list of the events identified, including a brief "]
[{"$f":"IF(B351=\"y\",COUNTA(B$14:B351),\"\")","v":""},null,null,"description of the potential obligation and the status of assessment of the"]
[{"$f":"IF(B352=\"y\",COUNTA(B$14:B352),\"\")","v":""},null,null,"event when this Reporting Package Checklist is returned to the Comptroller "]
[{"$f":"IF(B353=\"y\",COUNTA(B$14:B353),\"\")","v":""},null,null,"General's Office."]
[{"$f":"IF(B354=\"y\",COUNTA(B$14:B354),\"\")","v":""}]
[{"$f":"IF(B355=\"y\",COUNTA(B$14:B355),\"\")","v":""}]
[{"$f":"IF(B356=\"y\",COUNTA(B$14:B356),\"\")","v":""},null,"d. Has your agency been named, or does evidence indicate that your agency will be named,"]
[{"$f":"IF(B357=\"y\",COUNTA(B$14:B357),\"\")","v":""},null,"in a lawsuit to compel participation in remediation?"]
[{"$f":"IF(B358=\"y\",COUNTA(B$14:B358),\"\")","v":""},null,null,"Action:  Please create and attach a list of the events identified, including a brief "]
[{"$f":"IF(B359=\"y\",COUNTA(B$14:B359),\"\")","v":""},null,null,"description of the potential obligation and the status of assessment of the"]
[{"$f":"IF(B360=\"y\",COUNTA(B$14:B360),\"\")","v":""},null,null,"event when this Reporting Package Checklist is returned to the Comptroller "]
[{"$f":"IF(B361=\"y\",COUNTA(B$14:B361),\"\")","v":""},null,null,"General's Office."]
[{"$f":"IF(B362=\"y\",COUNTA(B$14:B362),\"\")","v":""}]
[{"$f":"IF(B363=\"y\",COUNTA(B$14:B363),\"\")","v":""}]
[{"$f":"IF(B364=\"y\",COUNTA(B$14:B364),\"\")","v":""},null,"e. Has your agency commenced, or legally obligated itself to commence, cleanup activities, "]
[{"$f":"IF(B365=\"y\",COUNTA(B$14:B365),\"\")","v":""},null,"monitoring, or maintenance and operation of the remediation effort?"]
[{"$f":"IF(B366=\"y\",COUNTA(B$14:B366),\"\")","v":""},null,null,"Action:  Please create and attach a list of the events identified, including a brief "]
[{"$f":"IF(B367=\"y\",COUNTA(B$14:B367),\"\")","v":""},null,null,"description of the potential obligation and the status of assessment of the"]
[{"$f":"IF(B368=\"y\",COUNTA(B$14:B368),\"\")","v":""},null,null,"event when this Reporting Package Checklist is returned to the Comptroller "]
[{"$f":"IF(B369=\"y\",COUNTA(B$14:B369),\"\")","v":""},null,null,"General's Office."]
[]
[]
[]
[]
[{"$f":"IF(B375=\"y\",COUNTA(B$14:B375),\"\")","v":""}]
[{"$f":"IF(B376=\"y\",COUNTA(B$14:B376),\"\")","v":""}]
[{"$f":"IF(B377=\"y\",COUNTA(B$14:B377),\"\")","v":""}]
[{"$f":"IF(B378=\"y\",COUNTA(B$14:B378),\"\")","v":""}]
[{"$f":"IF(B379=\"y\",COUNTA(B$14:B379),\"\")","v":""}]
[{"$f":"IF(B380=\"y\",COUNTA(B$14:B380),\"\")","v":""}]
[{"$f":"IF(B381=\"y\",COUNTA(B$14:B381),\"\")","v":""}]
[{"$f":"IF(B382=\"y\",COUNTA(B$14:B382),\"\")","v":""}]
[{"$f":"IF(B383=\"y\",COUNTA(B$14:B383),\"\")","v":""}]
[]
[{"$f":"IF(B385=\"y\",COUNTA(B$14:B385),\"\")","v":""}]
[{"$f":"IF(B386=\"y\",COUNTA(B$14:B386),\"\")","v":""}]
[{"$f":"IF(B387=\"y\",COUNTA(B$14:B387),\"\")","v":""}]
[{"$f":"IF(B388=\"y\",COUNTA(B$14:B388),\"\")","v":""}]
[{"$f":"IF(B389=\"y\",COUNTA(B$14:B389),\"\")","v":""}]
[{"$f":"IF(B390=\"y\",COUNTA(B$14:B390),\"\")","v":""}]
[{"$f":"IF(B391=\"y\",COUNTA(B$14:B391),\"\")","v":""}]
[{"$f":"IF(B392=\"y\",COUNTA(B$14:B392),\"\")","v":""}]

{"sheet":"AP Worksheet ","index":3,"n_rows":126,"n_cols":26,"rows_kept":126,"cut":false,"hidden":false,"merged":[[14,4,14,22],[40,13,40,25],[0,0,0,23],[1,0,1,23],[5,7,5,25],[6,5,6,22],[8,5,8,10],[8,16,8,21]]}
["STATE OF SOUTH CAROLINA"]
["SUBSEQUENT EVENTS ACCOUNTS PAYABLE WORKSHEET"]
[null,null,null,null,null,null,null,null,null,null,null,null,"At June 30,",2019]
[]
[]
[null,null,"Agency:",null,null,null,null,{"$f":"IF(E6=\"\",\"\",VLOOKUP(E6,B49:C126,2,FALSE))","v":""}]
[null,null,null,null,"Business Area","Agency Name"]
[]
[null,"Preparer (Type Name):",null,null,null,null,null,null,null,null,null,null,null,"Reviewer (Type Name):"]
[]
[]
[null,"Use only if additional liabilities were identified subsequent to the submission of the forms in Section 3.12. Do not include payables already reported on the 3.12 package."]
[]
[null,"Provide the date through which the evaluation was performed."]
[null,null,null,null,"Dollar Amount in each Category"]
[null,"Fund",null,null,"Vendor",null,null,"Aid to ",null,null,"Sales or Use ",null,null,"Accrued ",null,null,"Intergovernmental",null,null,"Contract ",null,null,"Contract ",null,null,"Other Current "]
[null,"Number",null,null,"Payables",null,null,"Individuals ",null,null,"Tax Payables",null,null,"Expenses",null,null,"Payables",null,null,"Retentions",null,null,"Retentions",null,null,"Liabilities "]
[null,null,null,null,null,null,null,"Payables",null,null,null,null,null,null,null,null,null,null,null,"Current",null,null,"Non-current"]
[]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[]
[null,null,null,null,null,null,null,null,null,"Total (This Page)",{"$f":"SUM(E20:E39)+SUM(H20:H39)+SUM(K20:K39)+SUM(N20:N39)+SUM(Q20:Q39)+SUM(T20:T39)+SUM(W20:W39)+SUM(Z20:Z39)","v":0}]
[]
[]
["NOTE:  If additional space is needed, please click the button.",null,null,null,null,null,null,null,null,null,null,null,null,null,"MUST ENABLE MACROS"]
[]
[]
[]
[null,"AGCY  CODE","AGENCY NAME"]
[null,"A010","LEGISLATIVE DEPARTMENT - THE SENATE"]
[null,"A050","LEGISLATIVE DEPARTMENT - HOUSE OF REPRESENTATIVES"]
[null,"A150","LEGISLATIVE DEPARTMENT - CODIFICATION OF LAWS & LEGISLATIVE COUNCIL"]
[null,"A170","LEGISLATIVE DEPARTMENT - LEGISLATIVE SERVICES AGENCY"]
[null,"A200","LEGISLATIVE DEPARTMENT - LEGISLATIVE AUDIT COUNCIL"]
[null,"A850","EDUCATION OVERSIGHT COMMITTEE"]
[null,"B040","JUDICIAL DEPARTMENT"]
[null,"C050","ADMINISTRATIVE LAW COURT"]
[null,"D050","GOVERNOR'S OFFICE--EXECUTIVE CONTROL OF STATE"]
[null,"D100","STATE LAW ENFORCEMENT DIVISION"]
[null,"D170","GOVERNOR'S OFFICE-- EXECUTIVE POLICY & PROGRAMS"]
[null,"D200","GOVERNOR'S OFFICE--MANSION & GROUNDS"]
[null,"D250","OFFICE OF INSPECTOR GENERAL"]
[null,"D500","DEPARTMENT OF ADMINISTRATION"]
[null,"E040","LIEUTENANT GOVERNOR'S OFFICE"]
[null,"E080","SECRETARY OF STATE'S OFFICE"]
[null,"E120","COMPTROLLER GENERAL'S OFFICE\n"]
[null,"E160","STATE TREASURER'S OFFICE                                                                       "]
[null,"E190","RETIREMENT SYSTEM  INVESTMENT COMMISSION"]
[null,"E200","ATTORNEY GENERAL'S OFFICE"]
[null,"E210","COMMISSION ON PROSECUTION COORDINATION "]
[null,"E230","COMMISSION ON INDIGENT DEFENSE "]
[null,"E240","ADJUTANT GENERAL'S OFFICE"]
[null,"E280","ELECTION COMMISSION"]
[null,"E500","REVENUE AND FISCAL AFFAIRS OFFICE"]
[null,"E550","STATE FISCAL ACCOUNTABILITY AUTHORITY"]
[null,"F030","BUDGET & CONTROL BOARD       \n    \n"]
[null,"F270","OFFICE OF THE STATE AUDITOR"]
[null,"H030","COMMISSION ON HIGHER EDUCATION"]
[null,"H060","HIGHER EDUCATION TUITION GRANTS COMMISSION"]
[null,"H590","STATE BOARD FOR TECHNICAL & COMPREHENSIVE EDUCATION"]
[null,"H630","DEPARTMENT OF EDUCATION"]
[null,"H670","EDUCATIONAL TELEVISION COMMISSION (ETV)"]
[null,"H710","WIL LOU GRAY OPPORTUNITY SCHOOL"]
[null,"H730","VOCATIONAL REHABILITATION"]
[null,"H750","SCHOOL FOR THE DEAF AND BLIND"]
[null,"H790","DEPARTMENT OF ARCHIVES AND HISTORY"]
[null,"H870","STATE LIBRARY"]
[null,"H910","ARTS COMMISSION"]
[null,"H950","MUSEUM COMMISSION"]
[null,"H960","CONFEDERATE RELIC ROOM AND MILITARY MUSEUM COMMISSION"]
[null,"J020","DEPARTMENT OF HEALTH AND HUMAN SERVICES"]
[null,"J040","DEPARTMENT OF HEALTH AND ENVIRONMENTAL CONTROL"]
[null,"J120","DEPARTMENT OF MENTAL HEALTH"]
[null,"J160","DEPARTMENT OF DISABILITIES AND SPECIAL NEEDS"]
[null,"J200","DEPARTMENT OF ALCOHOL AND OTHER DRUG ABUSE SERVICES"]
[null,"K050","DEPARTMENT OF PUBLIC SAFETY"]
[null,"L040","DEPARTMENT OF SOCIAL SERVICES"]
[null,"L120","JOHN DE LA HOWE SCHOOL"]
[null,"L240","COMMISSION FOR THE BLIND"]
[null,"L360","HUMAN AFFAIRS COMMISSION"]
[null,"L460","STATE COMMISSION FOR MINORITY AFFAIRS"]
[null,"N040","DEPARTMENT OF CORRECTIONS"]
[null,"N080","DEPARTMENT OF PROBATION, PAROLE AND PARDON SERVICES"]
[null,"N120","DEPARTMENT OF JUVENILE JUSTICE"]
[null,"N200","LAW ENFORCEMENT TRAINING COUNCIL"]
[null,"P120","FORESTRY COMMISSION"]
[null,"P160","DEPARTMENT OF AGRICULTURE"]
[null,"P240","DEPARTMENT OF NATURAL RESOURCES"]
[null,"P260","SEA GRANT CONSORTIUM"]
[null,"P280","DEPARTMENT OF PARKS, RECREATION AND TOURISM"]
[null,"P320","DEPARTMENT OF COMMERCE"]
[null,"P400","SOUTH CAROLINA CONSERVATION BANK"]
[null,"P450","RURAL INFASTRUCTURE AUTHORITY"]
[null,"R040","PUBLIC SERVICE COMMISSION"]
[null,"R060","OFFICE OF REGULATORY STAFF"]
[null,"R080","WORKER'S COMPENSATION COMMISSION"]
[null,"R160","SECOND INJURY FUND"]
[null,"R200","DEPARTMENT OF INSURANCE"]
[null,"R230","BOARD OF FINANCIAL INSTITUTIONS"]
[null,"R280","DEPARTMENT OF CONSUMER AFFAIRS"]
[null,"R360","DEPARTMENT OF LABOR, LICENSING, AND REGULATION"]
[null,"R400","DEPARTMENT OF MOTOR VEHICLES"]
[null,"R440","DEPARTMENT OF REVENUE"]
[null,"R520","STATE ETHICS COMMISSION"]
[null,"R600","DEPARTMENT OF EMPLOYMENT AND WORKFORCE"]
[null,"S600","PROCUREMENT REVIEW PANEL"]
[null,"U300","AERONAUTICS DIVISION"]

{"sheet":"AP Worksheet","index":4,"n_rows":120,"n_cols":26,"rows_kept":120,"cut":false,"hidden":true,"merged":[[12,4,12,22],[0,0,0,23],[1,0,1,23],[5,7,5,25],[6,5,6,22],[8,5,8,10],[8,16,8,21]]}
["STATE OF SOUTH CAROLINA"]
["ACCOUNTS PAYABLE SUMMARY FORM"]
[null,null,null,null,null,null,null,null,null,null,null,null,"At June 30,",{"$f":"IF(Year=\"\",\"\",Year)","v":{"$error":"#REF!"}}]
[]
[]
[null,null,"Agency:",null,{"$f":"IF('AP Worksheet '!E6=\"\",\"\",'AP Worksheet '!E6)","v":""},null,null,{"$f":"IF('AP Worksheet '!H6:Z6=\"\",\"\",'AP Worksheet '!H6:Z6)","v":""}]
[null,null,null,null,"Business Area","Agency Name"]
[]
[null,"Preparer (Type Name):",null,null,null,{"$f":"IF('AP Worksheet '!F9:K9=\"\",\"\",'AP Worksheet '!F9:K9)","v":""},null,null,null,null,null,null,null,"Reviewer (Type Name):",null,null,{"$f":"IF('AP Worksheet '!Q9:V9=\"\",\"\",'AP Worksheet '!Q9:V9)","v":""}]
[]
[]
[]
[null,null,null,null,"Dollar Amount in each Category"]
[null,"Fund",null,null,"Vendor",null,null,"Aid to ",null,null,"Sales or Use ",null,null,"Accrued ",null,null,"Intergovernmental",null,null,"Contract ",null,null,"Contract ",null,null,"Other Current "]
[null,"Number",null,null,"Payables",null,null,"Individuals ",null,null,"Tax Payables",null,null,"Expenses",null,null,"Payables",null,null,"Retentions",null,null,"Retentions",null,null,"Liabilities "]
[null,null,null,null,null,null,null,"Payables",null,null,null,null,null,null,null,null,null,null,null,"Current",null,null,"Non-current"]
[]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[]
[null,null,null,null,null,null,null,null,null,"Total (This Page)",{"$f":"SUM(E18:E37)+SUM(H18:H37)+SUM(K18:K37)+SUM(N18:N37)+SUM(Q18:Q37)+SUM(T18:T37)+SUM(W18:W37)+SUM(Z18:Z37)","v":0}]
[]
["NOTE:  If additional space is needed, please click the button.",null,null,null,null,null,null,null,null,null,null,null,null,null,"MUST ENABLE MACROS"]
[]
[]
[]
[null,"AGCY  CODE","AGENCY NAME"]
[null,"A01","LEGISLATIVE DEPARTMENT - THE SENATE"]
[null,"A05","LEGISLATIVE DEPARTMENT - HOUSE OF REPRESENTATIVES"]
[null,"A15","LEGISLATIVE DEPARTMENT - CODIFICATION OF LAWS & LEGISLATIVE COUNCIL"]
[null,"A17","LEGISLATIVE DEPARTMENT - LEGISLATIVE PRINTING & INFORMATION TECHNICAL SYSTEMS"]
[null,"A20","LEGISLATIVE DEPARTMENT - LEGISLATIVE AUDIT COUNCIL"]
[null,"A85","EDUCATION OVERSIGHT COMMITTEE"]
[null,"B04","JUDICIAL DEPARTMENT"]
[null,"C05","ADMINISTRATIVE LAW JUDGES"]
[null,"D05","GOVERNOR'S OFFICE--EXECUTIVE CONTROL OF STATE"]
[null,"D10","GOVERNOR'S OFFICE--STATE LAW ENFORCEMENT DIVISION"]
[null,"D17","GOVERNOR'S OFFICE-- EXECUTIVE POLICY & PROGRAMS"]
[null,"D20","GOVERNOR'S OFFICE--MANSION & GROUNDS"]
[null,"D25","INSPECTOR GENERAL"]
[null,"E04","LIEUTENANT GOVERNOR'S OFFICE"]
[null,"E08","SECRETARY OF STATE'S OFFICE"]
[null,"E12","COMPTROLLER GENERAL'S OFFICE\nW90 - DUES AND CONTRIBUTIONS (Note 1)\nX12 - AID TO SUBDIVISIONS--COMPTROLLER GENERAL (Note 1)"]
[null,"E16","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)                                                                        "]
[null,"E19","RETIREMENT SYSTEM  INVESTMENT COMMISSION"]
[null,"E20","ATTORNEY GENERAL'S OFFICE"]
[null,"E21","PROSECUTION COORDINATION  COMMISSION"]
[null,"E23","COMMISSION ON INDIGENT DEFENSE (Note 9)"]
[null,"E24","ADJUTANT GENERAL'S OFFICE\n(E25) STATE ACTIVITY DUTY (Note 8)"]
[null,"E28","ELECTION COMMISSION"]
[null,"F03","BUDGET & CONTROL BOARD       \n    \n"]
[null,"F27","STATE AUDITOR"]
[null,"H03","COMMISSION ON HIGHER EDUCATION"]
[null,"H06","HIGHER EDUCATION TUITION GRANTS COMMISSION"]
[null,"H59","BOARD FOR TECHNICAL & COMPREHENSIVE EDUCATION"]
[null,"H63","DEPARTMENT OF EDUCATION"]
[null,"H67","EDUCATIONAL TELEVISION COMMISSION (ETV)"]
[null,"H71","WIL LOU GRAY OPPORTUNITY SCHOOL"]
[null,"H73","VOCATIONAL REHABILITATION"]
[null,"H75","SCHOOL FOR THE DEAF AND BLIND"]
[null,"H79","DEPARTMENT OF ARCHIVES AND HISTORY"]
[null,"H87","STATE LIBRARY"]
[null,"H91","ARTS COMMISSION"]
[null,"H95","MUSEUM COMMISSION"]
[null,"J02","DEPARTMENT OF HEALTH AND HUMAN SERVICES"]
[null,"J04","DEPARTMENT OF HEALTH AND ENVIRONMENTAL CONTROL"]
[null,"J12","DEPARTMENT OF MENTAL HEALTH"]
[null,"J16","DEPARTMENT OF DISABILITIES AND SPECIAL NEEDS"]
[null,"J20","DEPARTMENT OF ALCOHOL AND OTHER DRUG ABUSE SERVICES"]
[null,"K05","DEPARTMENT OF PUBLIC SAFETY"]
[null,"L04","DEPARTMENT OF SOCIAL SERVICES"]
[null,"L12","JOHN DE LA HOWE SCHOOL"]
[null,"L24","COMMISSION FOR THE BLIND"]
[null,"L36","HUMAN AFFAIRS COMMISSION"]
[null,"L46","STATE COMMISSION FOR MINORITY AFFAIRS"]
[null,"N04","DEPARTMENT OF CORRECTIONS"]
[null,"N08","DEPARTMENT OF PROBATION, PAROLE AND PARDON"]
[null,"N12","DEPARTMENT OF JUVENILE JUSTICE"]
[null,"N20","LAW ENFORCEMENT TRAINING COUNCIL"]
[null,"P12","FORESTRY COMMISSION"]
[null,"P16","DEPARTMENT OF AGRICULTURE"]
[null,"P24","DEPARTMENT OF NATURAL RESOURCES"]
[null,"P26","SEA GRANT CONSORTIUM"]
[null,"P28","DEPARTMENT OF PARKS, RECREATION AND TOURISM"]
[null,"P32","DEPARTMENT OF COMMERCE\nY08 -  Public Railways Commission (Note 7)"]
[null,"P40","SOUTH CAROLINA CONSERVATION BANK"]
[null,"P45","RURAL INFASTRUCTURE AUTHORITY"]
[null,"R04","PUBLIC SERVICE COMMISSION"]
[null,"R06","OFFICE OF REGULATORY STAFF"]
[null,"R08","WORKER'S COMPENSATION COMMISSION"]
[null,"R20","DEPARTMENT OF INSURANCE"]
[null,"R23","BOARD OF FINANCIAL INSTITUTIONS"]
[null,"R28","DEPARTMENT OF CONSUMER AFFAIRS"]
[null,"R36","DEPARTMENT OF LABOR, LICENSING, AND REGULATION"]
[null,"R40","DEPARTMENT OF MOTOR VEHICLES"]
[null,"R44","DEPARTMENT OF REVENUE AND TAXATION"]
[null,"R52","STATE ETHICS COMMISSION"]
[null,"R60","DEPARTMENT OF EMPLOYMENT WORKFORCE"]
[null,"S60","PROCUREMENT REVIEW PANEL"]
[null,"U30","AERONAUTICS DIVISION"]
[null,"X22","AID TO SUBDIVISIONS--STATE TREASURER   (Note 2)"]
[null,"X44","AID TO SUBDIVISIONS--DEPARTMENT OF REVENUE   (Note 2)"]