{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Signature 1","3.03.1","3.03.2","3.03.3","3.03.4"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":8,"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":143,"n_cols":12,"rows_kept":143,"cut":false,"hidden":false,"merged":[[142,1,142,11],[53,1,53,13]]}
["STATE OF SOUTH CAROLINA"]
["YEAR-END REPORTING PROCEDURES MANUAL"]
["SECTION 3.03, GRANTS AND CONTRIBUTION REVENUES REPORTING PACKAGE"]
[]
[]
[null,"PURPOSE and OBJECTIVE:"]
[null,"Accurate reporting in accordance with GAAP requires the analysis and recognition of receivables and"]
[null,"deferred revenue in connection with grant awards and contributions.  The reporting package aids in"]
[null,"the identification and reporting of accrual amounts at year-end."]
[]
[null,"Grant information provided in this reporting package should be reported only as the end recipient "]
[null,"in the State's Reporting Entity.  Agency's which pass-through to other agencies or within its agency "]
[null,"should not report pass-through activity within the State's Reporting Entity."]
[null,"Note: internal pass through funds should be zero or have minimal balances at 6/30."]
[null,"If you have substantial balances in funds relating to internal pass through activity, these"]
[null,"should be reported and an explanation as to when the balance will clear and how long the"]
[null,"balance has existed. Substantial is defined as 10% of grant award or more than $500,000."]
[null,"Pass through activity to entities outside of the State's Reporting Entity should be included."]
[]
[null,"Please refer to the Reporting Policies and Procedures Manual for activity which qualifies as grant and"]
[null,"contributions.  The manual also provides helpful guidance, key terms, and exclusions from reporting "]
[null,"in this package."]
[]
[null,"INSTRUCTIONS FOR COMPLETION OF FORMS:"]
[null,"Grants Activity Form",null,null,null,null,null,null,null,null,null,"3.03.1"]
[null,"This form provides details to allow summary information to be provided on Form 3.03.2."]
[null,"The information to be input on this form has been formatted similarly to the SEFA Report from BW"]
[null,"which was distributed to you by email from the Comptroller General's Office for preparation of"]
[null,"this reporting form.  A separate line entry should be made for each grant award (determined from "]
[null,"the grantor's grant award number).  If one grant award is accounted for in multiple accounting funds, "]
[null,"please ensure that the transactions are not duplicated in the amounts reported."]
[null,"● Enter the information requested by the descriptions of each field."]
[null,"♦    The year for reporting is provided as a drop-down menu selection."]
[null,"♦    Provide the agency, preparation, and review information ensuring that signatures are attached "]
[null,"only upon completion."]
[null,"♦    The Fund, SCEIS Grant Number, Sponsor Grant #, and CFDA are as reported on the SEFA."]
[null,"♦    A drop-down menu is provided for the selections for Grant Type."]
[null,"♦    Indicate for each grant whether the eligibility requirements have been met (Y for Yes and N for "]
[null,"No).  If your response is No, further instructions must be obtained from the CG's Office."]
[null,"♦    The Receipts and Qualified Payments should be as reported on the distributed "]
[null,"BW report unless prior year accrual adjustments, errors or omissions were identified."]
[null,"♦    Fund Balance is a calculation.  The Agency is responsible for determining accuracy."]
[null,"♦    An adjustment to the modified accrual basis of accounting is required to recognize an increase in "]
[null,"qualified transactions for which a check has not been disbursed as of year-end.  Please enter any"]
[null,"invoice owed/accounts payable for the grant as of the end of the current year.  Note:  Auditors"]
[null,"are likely to associate amounts reported in this package with those reported in forms of 3.12"]
[null,"for Accounts Payable.  Management should perform reconciliation of the amounts prior to "]
[null,"submission."]
[null,"♦    Other accrual adjustments should be entered when identified.  This should NOT include"]
[null,"accrued payroll as it will be accounted for by the Comptroller General's Office."]
[null,"An explanation for the other accrual adjustments needs to be placed at the bottom of the form."]
[null,"If related to other reporting packages review should be in conjunction with those reported.  "]
[null,"♦    Accrual Fund Balance is a calculation.  The Agency is responsible for determining accuracy."]
[null,"Note:  If a grant has a debit or credit ending fund balance and NO current year activity an explanation needs provided."]
[null,"● Determine the accuracy of Form 3.03.2 prior to printing this form.  When ready to print, perform a"]
[null,"print preview to determine the number of pages that need to be printed.  If over 20 pages are"]
[null,"needed to report all grants for the year, please extend the information to a second copy of the "]
[null,"Reporting Package Form."]
[null,"Upon completion of the information requested:"]
[null,"● The individual completing the form should review the form for accuracy and completeness."]
[null,"● The Finance Director or Executive Director should review the form indicating agreement "]
[null,"with the information’s accuracy and completeness before sending it to the Comptroller General's "]
[null,"Office."]
[null,"●  Both the preparer and approver certify that the information provided on this reporting package"]
[null,"is complete and accurate to the best of their knowledge."]
[null,"● Return the completed Forms to the Comptroller General's Office no later than September 13."]
[null,"● The agency should retain a copy of the completed form as part of its year-end working papers.  The "]
[null,"Comptroller General's Office will contact the individual completing the form if there are any "]
[null,"questions. "]
[]
[]
[null,"Grants Receivables and Deferred Revenue Summary Form",null,null,null,null,null,null,null,null,null,"3.03.2"]
[null,"Note: The receivable balance automatically defaults to noncurrent, the current portion must be entered."]
[null,"This form is to provide information regarding grants receivable and deferred revenue at year-end."]
[null,"The Form should report all funds that receives Grant Revenue."]
[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 populated from the entry on Form 3.03.1."]
[null,"►    A validation check for the appropriate number of characters is included for the fund number."]
[null,"►    The fund description is populated generically based on the fund entered."]
[null,"►    A calculation based on information from Form 3.03.1 determines if a receivable or deferred"]
[null,"revenue is to be reported."]
[null,null,"Note:  the total balance should tie to 3.03.1 for each fund"]
[null,"►    Please enter the current portion of the receivable in the space provided."]
[null,"►    The non-current portion of the receivable is calculated by the form.  The agency must confirm "]
[null,"its accuracy.  A negative amount reported indicates an error."]
[null,"● Verify that if deferred revenue and receivables are reported the information on Form 3.03.1, the "]
[null,"BW report generated by the Comptroller General's Office, and/or work papers retained by the agency "]
[null,"supports that representation."]
[null,"Upon completion of the information requested:"]
[null,"● The individual completing the form should review the form for accuracy and completeness."]
[null,"● The Finance Director or Executive Director should review the form indicating agreement "]
[null,"with the information’s accuracy and completeness before sending it to the Comptroller General's "]
[null,"Office."]
[null,"●  Both the preparer and approver certify that the information provided on this reporting package"]
[null,"is complete and accurate to the best of their knowledge."]
[null,"● Return the completed Forms to the Comptroller General's Office no later than September 13."]
[null,"● The agency should retain a copy of the completed form as part of its year-end working papers.  The "]
[null,"Comptroller General's Office will contact the individual completing the form if there are any "]
[null,"questions. "]
[]
[null,"Contributions Receivables and Deferred Revenue Summary Form",null,null,null,null,null,null,null,null,null,"3.03.3"]
[null,"This form is to provide information regarding receivables and deferred revenue at year-end arising from "]
[null,"contribution transactions.  The Form should report all funds that report Contribution Revenue."]
[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,"►    A validation check for the appropriate number of characters is included for the fund number."]
[null,"►    A validation check for the appropriate number of digits is included for the revenue offset."]
[null,"►    Please enter the receivable amount, net of allowance for uncollectible, to be recognized."]
[null,"►    Please enter the current portion of the receivable in the space provided."]
[null,"►    The non-current portion of the receivable is calculated by the form.  The agency must confirm "]
[null,"its accuracy.  A negative amount reported indicates an error."]
[null,"►    Please enter the deferred revenue to be recognized in the space provided."]
[null,"● Verify that if deferred revenue and receivables are reported in a given fund, sufficient audit evidence is "]
[null,"retained by the agency to document different sources of revenue giving rise to the reported amounts."]
[null,"If you had any outstanding pledges at June 30 that were not recorded as revenue because "]
[null,"they were not measurable at June 30, attach a description of the situation to this Form."]
[null,"Upon completion of the information requested:"]
[null,"● The individual completing the form should review the form for accuracy and completeness."]
[null,"● The Finance Director or Executive Director should review the form indicating agreement "]
[null,"with the information’s accuracy and completeness before sending it to the Comptroller General's "]
[null,"Office."]
[null,"●  Both the preparer and approver certify that the information provided on this reporting package"]
[null,"is complete and accurate to the best of their knowledge."]
[null,"● Return the completed Forms to the Comptroller General's Office no later than September 13."]
[null,"● The agency should retain a copy of the completed form as part of its year-end working papers.  The "]
[null,"Comptroller General's Office will contact the individual completing the form if there are any "]
[null,"questions. "]
[]
[null,"Reviewer's Checklist",null,null,null,null,null,null,null,null,null,"3.03.4"]
[null,"Use this Checklist as a mechanism for review.  It should be completed prior to reviewer's signature on"]
[null,"the information forms.  A No response indicates an error.  If errors are identified, return the package"]
[null,"to the preparer for correction prior to further review.  Written explanation should be retained for "]
[null,"an N/A responses for review by auditors to ensure compliance with reporting requirements."]
[null,"The year for reporting has been derived from the selection made on 3.03.1 or 3.03.3"]
[null,"Upon completion of the checklist:"]
[null,"● A completed reviewer's checklist must accompany the agency submittted 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":137,"n_cols":6,"rows_kept":137,"cut":false,"hidden":false,"merged":[[136,1,136,5],[125,1,125,5],[127,1,127,5],[129,1,129,5],[131,1,131,5],[133,1,133,5]]}
[null,null,"3.03 Grants and Contributions Revenue 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:D110,2,FALSE))=TRUE,\"\",VLOOKUP(AgencyCode,C32:D110,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,"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.03 that is to be submitted in pdf format, all others are submitted via excel format."]

{"sheet":"3.03.1","index":2,"n_rows":987,"n_cols":15,"rows_kept":987,"cut":false,"hidden":false,"merged":[[382,1,382,8],[832,1,832,9],[882,1,882,9],[932,1,932,9],[982,1,982,9],[636,11,636,12],[686,11,686,12],[736,11,736,12],[786,11,786,12],[836,11,836,12],[886,11,886,12],[936,11,936,12],[843,10,843,15],[714,11,714,12],[715,11,715,12],[716,11,716,12],[700,11,700,14],[730,11,730,12],[731,11,731,12],[725,11,725,12],[726,11,726,12],[750,11,750,14],[701,11,701,12],[702,11,702,12],[297,6,300,6],[297,11,297,12],[298,11,298,12],[986,11,986,12],[86,11,86,12],[136,11,136,12],[186,11,186,12],[236,11,236,12],[286,11,286,12],[336,11,336,12],[386,11,386,12],[436,11,436,12],[693,10,693,15],[740,4,740,13],[743,2,743,7],[743,10,743,15],[790,4,790,13],[793,2,793,7],[793,10,793,15],[840,4,840,13],[682,1,682,8],[632,1,632,8],[582,1,582,8],[532,1,532,8],[633,1,637,8],[447,6,450,6],[393,2,393,7],[597,6,600,6],[397,6,400,6],[843,2,843,7],[782,1,782,8],[732,1,732,8],[783,1,787,8],[697,6,700,6],[747,6,750,6],[733,1,737,8],[690,4,690,13],[693,2,693,7],[555,11,555,12],[572,11,572,12],[482,1,482,8],[432,1,432,8],[703,11,703,12],[723,11,723,12],[704,11,704,12],[706,11,706,12],[583,1,587,8],[402,11,402,12],[259,11,259,12],[260,11,260,12],[393,10,393,15],[440,4,440,13],[443,2,443,7],[443,10,443,15],[433,1,437,8],[290,4,290,13],[293,2,293,7],[293,10,293,15],[340,4,340,13],[343,2,343,7],[343,10,343,15],[390,4,390,13],[283,1,287,8],[333,1,337,8],[383,1,387,8],[347,6,350,6],[332,1,332,8],[282,1,282,8],[270,11,270,12],[275,11,275,12],[301,11,301,12],[401,11,401,12],[403,11,403,12],[683,1,687,8],[547,6,550,6],[647,6,650,6],[590,4,590,13],[593,2,593,7],[593,10,593,15],[640,4,640,13],[643,2,643,7],[643,10,643,15],[675,11,675,12],[679,11,679,12],[680,11,680,12],[681,11,681,12],[676,11,676,12],[677,11,677,12],[678,11,678,12],[575,11,575,12],[554,11,554,12],[430,11,430,12],[431,11,431,12],[426,11,426,12],[427,11,427,12],[428,11,428,12],[83,1,87,8],[133,1,137,8],[183,1,187,8],[233,1,237,8],[97,6,100,6],[90,4,90,13],[93,2,93,7],[93,10,93,15],[140,4,140,13],[143,2,143,7],[143,10,143,15],[190,4,190,13],[193,2,193,7],[193,10,193,15],[125,11,125,12],[118,11,118,12],[119,11,119,12],[120,11,120,12],[121,11,121,12],[130,11,130,12],[131,11,131,12],[126,11,126,12],[127,11,127,12],[128,11,128,12],[82,1,82,8],[6,4,6,13],[70,11,70,12],[52,11,52,12],[53,11,53,12],[57,11,57,12],[58,11,58,12],[59,11,59,12],[60,11,60,12],[61,11,61,12],[62,11,62,12],[63,11,63,12],[47,6,50,6],[47,11,47,12],[48,11,48,12],[49,11,49,12],[13,6,16,6],[50,11,50,14],[51,11,51,12],[21,11,21,12],[36,11,36,12],[30,11,30,12],[33,1,37,7],[40,4,40,13],[43,2,43,7],[43,10,43,15],[668,11,668,12],[669,11,669,12],[670,11,670,12],[671,11,671,12],[97,11,97,12],[98,11,98,12],[99,11,99,12],[73,11,73,12],[74,11,74,12],[75,11,75,12],[54,11,54,12],[55,11,55,12],[72,11,72,12],[56,11,56,12],[79,11,79,12],[80,11,80,12],[69,11,69,12],[81,11,81,12],[76,11,76,12],[77,11,77,12],[78,11,78,12],[64,11,64,12],[868,11,868,12],[869,11,869,12],[870,11,870,12],[890,4,890,13],[893,2,893,7],[893,10,893,15],[897,6,900,6],[897,11,897,12],[898,11,898,12],[899,11,899,12],[881,11,881,12],[878,11,878,12],[876,11,876,12],[877,11,877,12],[65,11,65,12],[66,11,66,12],[67,11,67,12],[68,11,68,12],[12,16,22,16],[25,16,36,16],[13,11,13,12],[14,11,14,12],[15,11,15,12],[17,11,17,12],[18,11,18,12],[19,11,19,12],[20,11,20,12],[22,11,22,12],[26,11,26,12],[23,11,23,12],[24,11,24,12],[25,11,25,12],[16,11,16,14],[31,11,31,12],[27,11,27,12],[28,11,28,12],[29,11,29,12],[101,11,101,12],[102,11,102,12],[103,11,103,12],[123,11,123,12],[71,11,71,12],[124,11,124,12],[100,11,100,14],[104,11,104,12],[105,11,105,12],[122,11,122,12],[106,11,106,12],[107,11,107,12],[108,11,108,12],[109,11,109,12],[110,11,110,12],[111,11,111,12],[112,11,112,12],[113,11,113,12],[114,11,114,12],[115,11,115,12],[116,11,116,12],[117,11,117,12],[151,11,151,12],[152,11,152,12],[153,11,153,12],[147,6,150,6],[147,11,147,12],[148,11,148,12],[149,11,149,12],[129,11,129,12],[150,11,150,14],[132,1,132,8],[154,11,154,12],[155,11,155,12],[172,11,172,12],[179,11,179,12],[180,11,180,12],[181,11,181,12],[176,11,176,12],[177,11,177,12],[178,11,178,12],[171,11,171,12],[156,11,156,12],[157,11,157,12],[158,11,158,12],[159,11,159,12],[160,11,160,12],[161,11,161,12],[162,11,162,12],[163,11,163,12],[164,11,164,12],[165,11,165,12],[166,11,166,12],[167,11,167,12],[168,11,168,12],[169,11,169,12],[170,11,170,12],[201,11,201,12],[202,11,202,12],[203,11,203,12],[197,6,200,6],[197,11,197,12],[198,11,198,12],[199,11,199,12],[223,11,223,12],[173,11,173,12],[174,11,174,12],[175,11,175,12],[200,11,200,14],[218,11,218,12],[219,11,219,12],[220,11,220,12],[221,11,221,12],[182,1,182,8],[225,11,225,12],[204,11,204,12],[205,11,205,12],[222,11,222,12],[206,11,206,12],[207,11,207,12],[208,11,208,12],[209,11,209,12],[210,11,210,12],[211,11,211,12],[212,11,212,12],[213,11,213,12],[214,11,214,12],[215,11,215,12],[216,11,216,12],[217,11,217,12],[224,11,224,12],[229,11,229,12],[230,11,230,12],[231,11,231,12],[226,11,226,12],[227,11,227,12],[228,11,228,12],[251,11,251,12],[252,11,252,12],[253,11,253,12],[240,4,240,13],[232,1,232,8],[243,2,243,7],[243,10,243,15],[247,6,250,6],[247,11,247,12],[248,11,248,12],[249,11,249,12],[250,11,250,14],[254,11,254,12],[255,11,255,12],[272,11,272,12],[279,11,279,12],[280,11,280,12],[281,11,281,12],[276,11,276,12],[277,11,277,12],[278,11,278,12],[271,11,271,12],[261,11,261,12],[262,11,262,12],[263,11,263,12],[264,11,264,12],[265,11,265,12],[266,11,266,12],[267,11,267,12],[268,11,268,12],[269,11,269,12],[273,11,273,12],[274,11,274,12],[256,11,256,12],[257,11,257,12],[258,11,258,12],[299,11,299,12],[323,11,323,12],[318,11,318,12],[319,11,319,12],[320,11,320,12],[321,11,321,12],[300,11,300,14],[304,11,304,12],[305,11,305,12],[322,11,322,12],[306,11,306,12],[307,11,307,12],[308,11,308,12],[309,11,309,12],[310,11,310,12],[311,11,311,12],[312,11,312,12],[313,11,313,12],[314,11,314,12],[315,11,315,12],[316,11,316,12],[317,11,317,12],[302,11,302,12],[303,11,303,12],[324,11,324,12],[327,11,327,12],[328,11,328,12],[326,11,326,12],[325,11,325,12],[350,11,350,14],[347,11,347,12],[348,11,348,12],[349,11,349,12],[329,11,329,12],[330,11,330,12],[331,11,331,12],[354,11,354,12],[355,11,355,12],[372,11,372,12],[351,11,351,12],[352,11,352,12],[353,11,353,12],[373,11,373,12],[374,11,374,12],[368,11,368,12],[369,11,369,12],[370,11,370,12],[371,11,371,12],[356,11,356,12],[357,11,357,12],[358,11,358,12],[359,11,359,12],[360,11,360,12],[361,11,361,12],[362,11,362,12],[363,11,363,12],[364,11,364,12],[365,11,365,12],[366,11,366,12],[367,11,367,12],[379,11,379,12],[380,11,380,12],[381,11,381,12],[376,11,376,12],[377,11,377,12],[378,11,378,12],[400,11,400,14],[375,11,375,12],[397,11,397,12],[398,11,398,12],[399,11,399,12],[418,11,418,12],[419,11,419,12],[420,11,420,12],[421,11,421,12],[466,11,466,12],[449,11,449,12],[425,11,425,12],[424,11,424,12],[429,11,429,12],[454,11,454,12],[455,11,455,12],[451,11,451,12],[452,11,452,12],[453,11,453,12],[465,11,465,12],[470,11,470,12],[467,11,467,12],[468,11,468,12],[469,11,469,12],[404,11,404,12],[405,11,405,12],[422,11,422,12],[406,11,406,12],[407,11,407,12],[408,11,408,12],[409,11,409,12],[410,11,410,12],[411,11,411,12],[412,11,412,12],[413,11,413,12],[414,11,414,12],[415,11,415,12],[416,11,416,12],[417,11,417,12],[450,11,450,14],[447,11,447,12],[448,11,448,12],[423,11,423,12],[456,11,456,12],[457,11,457,12],[458,11,458,12],[459,11,459,12],[460,11,460,12],[461,11,461,12],[462,11,462,12],[463,11,463,12],[464,11,464,12],[481,11,481,12],[476,11,476,12],[477,11,477,12],[478,11,478,12],[471,11,471,12],[501,11,501,12],[502,11,502,12],[503,11,503,12],[497,6,500,6],[497,11,497,12],[498,11,498,12],[499,11,499,12],[490,4,490,13],[493,2,493,7],[493,10,493,15],[483,1,487,8],[486,11,486,12],[475,11,475,12],[472,11,472,12],[479,11,479,12],[480,11,480,12],[473,11,473,12],[474,11,474,12],[523,11,523,12],[518,11,518,12],[519,11,519,12],[520,11,520,12],[521,11,521,12],[500,11,500,14],[504,11,504,12],[505,11,505,12],[522,11,522,12],[506,11,506,12],[507,11,507,12],[508,11,508,12],[509,11,509,12],[510,11,510,12],[511,11,511,12],[512,11,512,12],[513,11,513,12],[514,11,514,12],[515,11,515,12],[516,11,516,12],[517,11,517,12],[524,11,524,12],[527,11,527,12],[528,11,528,12],[526,11,526,12],[525,11,525,12],[547,11,547,12],[548,11,548,12],[549,11,549,12],[529,11,529,12],[530,11,530,12],[531,11,531,12],[540,4,540,13],[543,2,543,7],[543,10,543,15],[533,1,537,8],[536,11,536,12],[551,11,551,12],[552,11,552,12],[553,11,553,12],[573,11,573,12],[574,11,574,12],[570,11,570,12],[571,11,571,12],[550,11,550,14],[568,11,568,12],[569,11,569,12],[627,11,627,12],[628,11,628,12],[579,11,579,12],[580,11,580,12],[581,11,581,12],[576,11,576,12],[577,11,577,12],[578,11,578,12],[556,11,556,12],[557,11,557,12],[558,11,558,12],[559,11,559,12],[560,11,560,12],[561,11,561,12],[562,11,562,12],[563,11,563,12],[564,11,564,12],[565,11,565,12],[566,11,566,12],[567,11,567,12],[586,11,586,12],[601,11,601,12],[602,11,602,12],[603,11,603,12],[597,11,597,12],[598,11,598,12],[599,11,599,12],[623,11,623,12],[621,11,621,12],[600,11,600,14],[618,11,618,12],[619,11,619,12],[620,11,620,12],[647,11,647,12],[648,11,648,12],[649,11,649,12],[625,11,625,12],[604,11,604,12],[605,11,605,12],[622,11,622,12],[606,11,606,12],[607,11,607,12],[608,11,608,12],[609,11,609,12],[610,11,610,12],[611,11,611,12],[612,11,612,12],[613,11,613,12],[614,11,614,12],[615,11,615,12],[616,11,616,12],[617,11,617,12],[624,11,624,12],[629,11,629,12],[630,11,630,12],[631,11,631,12],[626,11,626,12],[650,11,650,14],[654,11,654,12],[655,11,655,12],[672,11,672,12],[656,11,656,12],[657,11,657,12],[658,11,658,12],[659,11,659,12],[660,11,660,12],[661,11,661,12],[662,11,662,12],[663,11,663,12],[664,11,664,12],[665,11,665,12],[666,11,666,12],[667,11,667,12],[707,11,707,12],[708,11,708,12],[709,11,709,12],[710,11,710,12],[711,11,711,12],[712,11,712,12],[713,11,713,12],[651,11,651,12],[652,11,652,12],[653,11,653,12],[673,11,673,12],[674,11,674,12],[705,11,705,12],[697,11,697,12],[698,11,698,12],[699,11,699,12],[727,11,727,12],[728,11,728,12],[751,11,751,12],[752,11,752,12],[753,11,753,12],[717,11,717,12],[724,11,724,12],[779,11,779,12],[780,11,780,12],[718,11,718,12],[719,11,719,12],[773,11,773,12],[774,11,774,12],[775,11,775,12],[720,11,720,12],[721,11,721,12],[747,11,747,12],[748,11,748,12],[749,11,749,12],[729,11,729,12],[722,11,722,12],[766,11,766,12],[767,11,767,12],[768,11,768,12],[806,11,806,12],[807,11,807,12],[808,11,808,12],[809,11,809,12],[810,11,810,12],[801,11,801,12],[802,11,802,12],[803,11,803,12],[804,11,804,12],[966,11,966,12],[967,11,967,12],[879,11,879,12],[880,11,880,12],[906,11,906,12],[954,11,954,12],[955,11,955,12],[947,6,950,6],[947,11,947,12],[948,11,948,12],[949,11,949,12],[923,11,923,12],[924,11,924,12],[925,11,925,12],[904,11,904,12],[905,11,905,12],[922,11,922,12],[912,11,912,12],[913,11,913,12],[914,11,914,12],[915,11,915,12],[916,11,916,12],[917,11,917,12],[918,11,918,12],[960,11,960,12],[961,11,961,12],[817,11,817,12],[820,11,820,12],[962,11,962,12],[963,11,963,12],[950,11,950,14],[940,4,940,13],[943,2,943,7],[943,10,943,15],[919,11,919,12],[920,11,920,12],[921,11,921,12],[907,11,907,12],[847,6,850,6],[847,11,847,12],[848,11,848,12],[849,11,849,12],[873,11,873,12],[874,11,874,12],[875,11,875,12],[854,11,854,12],[855,11,855,12],[872,11,872,12],[964,11,964,12],[965,11,965,12],[979,11,979,12],[980,11,980,12],[972,11,972,12],[956,11,956,12],[957,11,957,12],[770,11,770,12],[771,11,771,12],[813,11,813,12],[814,11,814,12],[821,11,821,12],[852,11,852,12],[776,11,776,12],[777,11,777,12],[778,11,778,12],[908,11,908,12],[909,11,909,12],[910,11,910,12],[929,11,929,12],[930,11,930,12],[931,11,931,12],[968,11,968,12],[969,11,969,12],[769,11,769,12],[981,11,981,12],[976,11,976,12],[977,11,977,12],[978,11,978,12],[973,11,973,12],[974,11,974,12],[975,11,975,12],[901,11,901,12],[902,11,902,12],[903,11,903,12],[926,11,926,12],[927,11,927,12],[928,11,928,12],[953,11,953,12],[958,11,958,12],[959,11,959,12],[951,11,951,12],[952,11,952,12],[970,11,970,12],[971,11,971,12],[822,11,822,12],[815,11,815,12],[816,11,816,12],[757,11,757,12],[758,11,758,12],[759,11,759,12],[760,11,760,12],[761,11,761,12],[762,11,762,12],[763,11,763,12],[764,11,764,12],[765,11,765,12],[983,1,987,8],[9,2,9,7],[9,10,9,15],[911,11,911,12],[829,11,829,12],[830,11,830,12],[831,11,831,12],[826,11,826,12],[827,11,827,12],[828,11,828,12],[851,11,851,12],[800,11,800,14],[850,11,850,14],[900,11,900,14],[805,11,805,12],[823,11,823,12],[824,11,824,12],[825,11,825,12],[811,11,811,12],[812,11,812,12],[754,11,754,12],[755,11,755,12],[772,11,772,12],[756,11,756,12],[818,11,818,12],[819,11,819,12],[781,11,781,12],[833,1,837,8],[883,1,887,8],[933,1,937,8],[871,11,871,12],[856,11,856,12],[857,11,857,12],[858,11,858,12],[859,11,859,12],[860,11,860,12],[861,11,861,12],[862,11,862,12],[863,11,863,12],[864,11,864,12],[865,11,865,12],[866,11,866,12],[867,11,867,12],[853,11,853,12],[797,6,800,6],[797,11,797,12],[798,11,798,12],[799,11,799,12]]}
[]
["STATE OF SOUTH CAROLINA"]
["GRANTS ACTIVITY FORM"]
[null,null,null,null,null,null,null,null,"AT JUNE 30,",2019]
[]
[]
[null,"Agency:",{"$f":"'Signature 1'!E5","v":"E120"},null,{"$f":"'Signature 1'!E6","v":"COMPTROLLER GENERAL'S OFFICE\n"}]
[null,null,"Business Area","Name"]
[]
[null,"Preparer:","Employee ABC",null,null,null,null,null,null,"Reviewer:","Supervisor XYZ"]
[null,null,null,"Typed Name",null,null,null,null,null,null,null,"Typed Name"]
[]
[]
[null,null,null,"Grantor's",null,null,"Eligibility ?","Beginning","(+)","(-)","Ending","(-)",null,"Other","June 30"]
[null,"Fund","SCEIS","Award",null,"Grant",null,"Fund","Grant Receipts","Grant Qualified","Fund","Accounts Payable",null,"Accrual","Accrual"]
[null,"Number","Grant No","Reference","CFDA","Type",null,"Balance","through June 30","Payments","Balance","Current June 30",null,"Adjustments","Fund Balance"]
[]
[null,50550000,"E12075489","TM17-457",16.123000000000001,"Operating","Y",-130000,130000,-12500,{"$f":"SUM(H18:J18)","v":-12500},null,null,null,{"$f":"SUM(K18:N18)","v":-12500}]
[null,50550000,"E12045790","TM18-658",16.123000000000001,"Capital","Y",-13000,null,null,-13000,null,null,null,{"$f":"SUM(K19:N19)","v":-13000}]
[null,50550000,"E12036987","TM19-457",16.123000000000001,"Operating","Y",0,0,-157000,-157000,-6875,null,null,-163875]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,"Explanations of other accrual adjustments or if grant has fund balance but no FY activity:",null,null,null,null,null,null,"TOTALS--Capital",null,{"$f":"SUMIF($F18:$F32,\"Capital\",K18:K32)","v":-13000},null,null,null,{"$f":"SUMIF($F18:$F32,\"Capital\",O18:O32)","v":-13000}]
[null,"E12045790 reimbursement request wasn't filed until 7/7/2019, cash will be received in FY2020"]
[null,null,null,null,null,null,null,null,"TOTALS--Operating",null,{"$f":"SUMIF($F18:$F32,\"Operating\",K18:K32)","v":-169500},null,null,null,{"$f":"SUMIF($F18:$F32,\"Operating\",O18:O32)","v":-176375}]
[]
[null,null,null,null,null,null,null,null,"TOTALS--Unrestricted",null,{"$f":"SUMIF($F18:$F32,\"Unrestricted\",K18:K32)","v":0},{"$f":"SUM(L18:M32)","v":-6875},null,{"$f":"SUM(N18:N32)","v":0},{"$f":"SUMIF($F18:$F32,\"Unrestricted\",O18:O32)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Page",2,"of"]
[null,"Agency:",{"$f":"+C7","v":"E120"},null,{"$f":"+E7","v":"COMPTROLLER GENERAL'S OFFICE\n"}]
[null,null,"Business Area","Name"]
[]
[null,"Preparer:",{"$f":"+C10","v":"Employee ABC"},null,null,null,null,null,null,"Reviewer:",{"$f":"+K10","v":"Supervisor XYZ"}]
[null,null,null,"Typed Name",null,null,null,null,null,null,null,"Typed Name"]
[]
[]
[null,null,null,"Grantor's",null,null,"Eligibility ?","Beginning","(+)","(-)","Ending","(-)",null,"Other","June 30"]
[null,"Fund","SCEIS","Award",null,"Grant",null,"Fund","Grant Receipts","Grant Qualified","Fund","Accounts Payable",null,"Accrual","Accrual"]
[null,"Number","Grant No","Reference","CFDA","Type",null,"Balance","through June 30","Payments","Balance","Current June 30",null,"Adjustments","Fund Balance"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H52:J52)","v":0},null,null,null,{"$f":"SUM(K52:N52)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUM(K53:N53)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H82:J82)","v":0},null,null,null,{"$f":"SUM(K82:N82)","v":0}]
[null,"Explanations of other accrual adjustments or if grant has fund balance but no FY activity:",null,null,null,null,null,null,null,"TOTALS--Capital",{"$f":"SUMIF($F52:$F82,\"Capital\",K52:K82)","v":0},null,null,null,{"$f":"SUMIF($F52:$F82,\"Capital\",O52:O82)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"TOTALS--Operating",{"$f":"SUMIF($F52:$F82,\"Operating\",K52:K82)","v":0},null,null,null,{"$f":"SUMIF($F52:$F82,\"Operating\",O52:O82)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"TOTALS--Unrestricted",{"$f":"SUMIF($F52:$F82,\"Unrestricted\",K52:K82)","v":0},{"$f":"SUM(L52:M82)","v":0},null,{"$f":"SUM(N52:N82)","v":0},{"$f":"SUMIF($F52:$F82,\"Unrestricted\",O52:O82)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Page",3,"of"]
[null,"Agency:",{"$f":"+C7","v":"E120"},null,{"$f":"+E7","v":"COMPTROLLER GENERAL'S OFFICE\n"}]
[null,null,"Business Area","Name"]
[]
[null,"Preparer:",{"$f":"+C10","v":"Employee ABC"},null,null,null,null,null,null,"Reviewer:",{"$f":"+K10","v":"Supervisor XYZ"}]
[null,null,null,"Typed Name",null,null,null,null,null,null,null,"Typed Name"]
[]
[]
[null,null,null,"Grantor's",null,null,"Eligibility ?","Beginning","(+)","(-)","Ending","(-)",null,"Other","June 30"]
[null,"Fund","SCEIS","Award",null,"Grant",null,"Fund","Grant Receipts","Grant Qualified","Fund","Accounts Payable",null,"Accrual","Accrual"]
[null,"Number","Grant No","Reference","CFDA","Type",null,"Balance","through June 30","Payments","Balance","Current June 30",null,"Adjustments","Fund Balance"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H102:J102)","v":0},null,null,null,{"$f":"SUM(K102:N102)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUM(K103:N103)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H132:J132)","v":0},null,null,null,{"$f":"SUM(K132:N132)","v":0}]
[null,"Explanations of other accrual adjustments or if grant has fund balance but no FY activity:",null,null,null,null,null,null,null,"TOTALS--Capital",{"$f":"SUMIF($F102:$F132,\"Capital\",K102:K132)","v":0},null,null,null,{"$f":"SUMIF($F102:$F132,\"Capital\",O102:O132)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"TOTALS--Operating",{"$f":"SUMIF($F102:$F132,\"Operating\",K102:K132)","v":0},null,null,null,{"$f":"SUMIF($F102:$F132,\"Operating\",O102:O132)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"TOTALS--Unrestricted",{"$f":"SUMIF($F102:$F132,\"Unrestricted\",K102:K132)","v":0},{"$f":"SUM(L102:M132)","v":0},null,{"$f":"SUM(N102:N132)","v":0},{"$f":"SUMIF($F102:$F132,\"Unrestricted\",O102:O132)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Page",4,"of"]
[null,"Agency:",{"$f":"+C7","v":"E120"},null,{"$f":"+E7","v":"COMPTROLLER GENERAL'S OFFICE\n"}]
[null,null,"Business Area","Name"]
[]
[null,"Preparer:",{"$f":"+C10","v":"Employee ABC"},null,null,null,null,null,null,"Reviewer:",{"$f":"+K10","v":"Supervisor XYZ"}]
[null,null,null,"Typed Name",null,null,null,null,null,null,null,"Typed Name"]
[]
[]
[null,null,null,"Grantor's",null,null,"Eligibility ?","Beginning","(+)","(-)","Ending","(-)",null,"Other","June 30"]
[null,"Fund","SCEIS","Award",null,"Grant",null,"Fund","Grant Receipts","Grant Qualified","Fund","Accounts Payable",null,"Accrual","Accrual"]
[null,"Number","Grant No","Reference","CFDA","Type",null,"Balance","through June 30","Payments","Balance","Current June 30",null,"Adjustments","Fund Balance"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H152:J152)","v":0},null,null,null,{"$f":"SUM(K152:N152)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUM(K153:N153)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H182:J182)","v":0},null,null,null,{"$f":"SUM(K182:N182)","v":0}]
[null,"Explanations of other accrual adjustments or if grant has fund balance but no FY activity:",null,null,null,null,null,null,null,"TOTALS--Capital",{"$f":"SUMIF($F152:$F182,\"Capital\",K152:K182)","v":0},null,null,null,{"$f":"SUMIF($F152:$F182,\"Capital\",O152:O182)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"TOTALS--Operating",{"$f":"SUMIF($F152:$F182,\"Operating\",K152:K182)","v":0},null,null,null,{"$f":"SUMIF($F152:$F182,\"Operating\",O152:O182)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"TOTALS--Unrestricted",{"$f":"SUMIF($F152:$F182,\"Unrestricted\",K152:K182)","v":0},{"$f":"SUM(L152:M182)","v":0},null,{"$f":"SUM(N152:N182)","v":0},{"$f":"SUMIF($F152:$F182,\"Unrestricted\",O152:O182)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Page",5,"of"]
[null,"Agency:",{"$f":"+C7","v":"E120"},null,{"$f":"+E7","v":"COMPTROLLER GENERAL'S OFFICE\n"}]
[null,null,"Business Area","Name"]
[]
[null,"Preparer:",{"$f":"+C10","v":"Employee ABC"},null,null,null,null,null,null,"Reviewer:",{"$f":"+K10","v":"Supervisor XYZ"}]
[null,null,null,"Typed Name",null,null,null,null,null,null,null,"Typed Name"]
[]
[]
[null,null,null,"Grantor's",null,null,"Eligibility ?","Beginning","(+)","(-)","Ending","(-)",null,"Other","June 30"]
[null,"Fund","SCEIS","Award",null,"Grant",null,"Fund","Grant Receipts","Grant Qualified","Fund","Accounts Payable",null,"Accrual","Accrual"]
[null,"Number","Grant No","Reference","CFDA","Type",null,"Balance","through June 30","Payments","Balance","Current June 30",null,"Adjustments","Fund Balance"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H202:J202)","v":0},null,null,null,{"$f":"SUM(K202:N202)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUM(K203:N203)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H232:J232)","v":0},null,null,null,{"$f":"SUM(K232:N232)","v":0}]
[null,"Explanations of other accrual adjustments or if grant has fund balance but no FY activity:",null,null,null,null,null,null,null,"TOTALS--Capital",{"$f":"SUMIF($F202:$F232,\"Capital\",K202:K232)","v":0},null,null,null,{"$f":"SUMIF($F202:$F232,\"Capital\",O202:O232)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"TOTALS--Operating",{"$f":"SUMIF($F202:$F232,\"Operating\",K202:K232)","v":0},null,null,null,{"$f":"SUMIF($F202:$F232,\"Operating\",O202:O232)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"TOTALS--Unrestricted",{"$f":"SUMIF($F202:$F232,\"Unrestricted\",K202:K232)","v":0},{"$f":"SUM(L202:M232)","v":0},null,{"$f":"SUM(N202:N232)","v":0},{"$f":"SUMIF($F202:$F232,\"Unrestricted\",O202:O232)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Page",null,"of"]
[null,"Agency:",{"$f":"+C207","v":0},null,{"$f":"+E207","v":0}]
[null,null,"Business Area","Name"]
[]
[null,"Preparer:",{"$f":"+C210","v":0},null,null,null,null,null,null,"Reviewer:",{"$f":"+K210","v":0}]
[null,null,null,"Typed Name",null,null,null,null,null,null,null,"Typed Name"]
[]
[]
[null,null,null,"Grantor's",null,null,"Eligibility ?","Beginning","(+)","(-)","Ending","(-)",null,"Other","June 30"]
[null,"Fund","SCEIS","Award",null,"Grant",null,"Fund","Grant Receipts","Grant Qualified","Fund","Accounts Payable",null,"Accrual","Accrual"]
[null,"Number","Grant No","Reference","CFDA","Type",null,"Balance","through June 30","Payments","Balance","Current June 30",null,"Adjustments","Fund Balance"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H252:J252)","v":0},null,null,null,{"$f":"SUM(K252:N252)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUM(K253:N253)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H282:J282)","v":0},null,null,null,{"$f":"SUM(K282:N282)","v":0}]
[null,"Explanations of other accrual adjustments or if grant has fund balance but no FY activity:",null,null,null,null,null,null,null,"TOTALS--Capital",{"$f":"SUMIF($F252:$F282,\"Capital\",K252:K282)","v":0},null,null,null,{"$f":"SUMIF($F252:$F282,\"Capital\",O252:O282)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"TOTALS--Operating",{"$f":"SUMIF($F252:$F282,\"Operating\",K252:K282)","v":0},null,null,null,{"$f":"SUMIF($F252:$F282,\"Operating\",O252:O282)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"TOTALS--Unrestricted",{"$f":"SUMIF($F252:$F282,\"Unrestricted\",K252:K282)","v":0},{"$f":"SUM(L252:M282)","v":0},null,{"$f":"SUM(N252:N282)","v":0},{"$f":"SUMIF($F252:$F282,\"Unrestricted\",O252:O282)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Page",null,"of"]
[null,"Agency:",{"$f":"+C257","v":0},null,{"$f":"+E257","v":0}]
[null,null,"Business Area","Name"]
[]
[null,"Preparer:",{"$f":"+C260","v":0},null,null,null,null,null,null,"Reviewer:",{"$f":"+K260","v":0}]
[null,null,null,"Typed Name",null,null,null,null,null,null,null,"Typed Name"]
[]
[]
[null,null,null,"Grantor's",null,null,"Eligibility ?","Beginning","(+)","(-)","Ending","(-)",null,"Other","June 30"]
[null,"Fund","SCEIS","Award",null,"Grant",null,"Fund","Grant Receipts","Grant Qualified","Fund","Accounts Payable",null,"Accrual","Accrual"]
[null,"Number","Grant No","Reference","CFDA","Type",null,"Balance","through June 30","Payments","Balance","Current June 30",null,"Adjustments","Fund Balance"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H302:J302)","v":0},null,null,null,{"$f":"SUM(K302:N302)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUM(K303:N303)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H332:J332)","v":0},null,null,null,{"$f":"SUM(K332:N332)","v":0}]
[null,"Explanations of other accrual adjustments or if grant has fund balance but no FY activity:",null,null,null,null,null,null,null,"TOTALS--Capital",{"$f":"SUMIF($F302:$F332,\"Capital\",K302:K332)","v":0},null,null,null,{"$f":"SUMIF($F302:$F332,\"Capital\",O302:O332)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"TOTALS--Operating",{"$f":"SUMIF($F302:$F332,\"Operating\",K302:K332)","v":0},null,null,null,{"$f":"SUMIF($F302:$F332,\"Operating\",O302:O332)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"TOTALS--Unrestricted",{"$f":"SUMIF($F302:$F332,\"Unrestricted\",K302:K332)","v":0},{"$f":"SUM(L302:M332)","v":0},null,{"$f":"SUM(N302:N332)","v":0},{"$f":"SUMIF($F302:$F332,\"Unrestricted\",O302:O332)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Page",null,"of"]
[null,"Agency:",{"$f":"+C307","v":0},null,{"$f":"+E307","v":0}]
[null,null,"Business Area","Name"]
[]
[null,"Preparer:",{"$f":"+C310","v":0},null,null,null,null,null,null,"Reviewer:",{"$f":"+K310","v":0}]
[null,null,null,"Typed Name",null,null,null,null,null,null,null,"Typed Name"]
[]
[]
[null,null,null,"Grantor's",null,null,"Eligibility ?","Beginning","(+)","(-)","Ending","(-)",null,"Other","June 30"]
[null,"Fund","SCEIS","Award",null,"Grant",null,"Fund","Grant Receipts","Grant Qualified","Fund","Accounts Payable",null,"Accrual","Accrual"]
[null,"Number","Grant No","Reference","CFDA","Type",null,"Balance","through June 30","Payments","Balance","Current June 30",null,"Adjustments","Fund Balance"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H352:J352)","v":0},null,null,null,{"$f":"SUM(K352:N352)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUM(K353:N353)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H382:J382)","v":0},null,null,null,{"$f":"SUM(K382:N382)","v":0}]
[null,"Explanations of other accrual adjustments or if grant has fund balance but no FY activity:",null,null,null,null,null,null,null,"TOTALS--Capital",{"$f":"SUMIF($F352:$F382,\"Capital\",K352:K382)","v":0},null,null,null,{"$f":"SUMIF($F352:$F382,\"Capital\",O352:O382)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"TOTALS--Operating",{"$f":"SUMIF($F352:$F382,\"Operating\",K352:K382)","v":0},null,null,null,{"$f":"SUMIF($F352:$F382,\"Operating\",O352:O382)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"TOTALS--Unrestricted",{"$f":"SUMIF($F352:$F382,\"Unrestricted\",K352:K382)","v":0},{"$f":"SUM(L352:M382)","v":0},null,{"$f":"SUM(N352:N382)","v":0},{"$f":"SUMIF($F352:$F382,\"Unrestricted\",O352:O382)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Page",null,"of"]
[null,"Agency:",{"$f":"+C357","v":0},null,{"$f":"+E357","v":0}]
[null,null,"Business Area","Name"]
[]
[null,"Preparer:",{"$f":"+C360","v":0},null,null,null,null,null,null,"Reviewer:",{"$f":"+K360","v":0}]
[null,null,null,"Typed Name",null,null,null,null,null,null,null,"Typed Name"]
[]
[]
[null,null,null,"Grantor's",null,null,"Eligibility ?","Beginning","(+)","(-)","Ending","(-)",null,"Other","June 30"]
[null,"Fund","SCEIS","Award",null,"Grant",null,"Fund","Grant Receipts","Grant Qualified","Fund","Accounts Payable",null,"Accrual","Accrual"]
[null,"Number","Grant No","Reference","CFDA","Type",null,"Balance","through June 30","Payments","Balance","Current June 30",null,"Adjustments","Fund Balance"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H402:J402)","v":0},null,null,null,{"$f":"SUM(K402:N402)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUM(K403:N403)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H432:J432)","v":0},null,null,null,{"$f":"SUM(K432:N432)","v":0}]
[null,"Explanations of other accrual adjustments or if grant has fund balance but no FY activity:",null,null,null,null,null,null,null,"TOTALS--Capital",{"$f":"SUMIF($F402:$F432,\"Capital\",K402:K432)","v":0},null,null,null,{"$f":"SUMIF($F402:$F432,\"Capital\",O402:O432)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"TOTALS--Operating",{"$f":"SUMIF($F402:$F432,\"Operating\",K402:K432)","v":0},null,null,null,{"$f":"SUMIF($F402:$F432,\"Operating\",O402:O432)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"TOTALS--Unrestricted",{"$f":"SUMIF($F402:$F432,\"Unrestricted\",K402:K432)","v":0},{"$f":"SUM(L402:M432)","v":0},null,{"$f":"SUM(N402:N432)","v":0},{"$f":"SUMIF($F402:$F432,\"Unrestricted\",O402:O432)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Page",null,"of"]
[null,"Agency:",{"$f":"+C407","v":0},null,{"$f":"+E407","v":0}]
[null,null,"Business Area","Name"]
[]
[null,"Preparer:",{"$f":"+C410","v":0},null,null,null,null,null,null,"Reviewer:",{"$f":"+K410","v":0}]
[null,null,null,"Typed Name",null,null,null,null,null,null,null,"Typed Name"]
[]
[]
[null,null,null,"Grantor's",null,null,"Eligibility ?","Beginning","(+)","(-)","Ending","(-)",null,"Other","June 30"]
[null,"Fund","SCEIS","Award",null,"Grant",null,"Fund","Grant Receipts","Grant Qualified","Fund","Accounts Payable",null,"Accrual","Accrual"]
[null,"Number","Grant No","Reference","CFDA","Type",null,"Balance","through June 30","Payments","Balance","Current June 30",null,"Adjustments","Fund Balance"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H452:J452)","v":0},null,null,null,{"$f":"SUM(K452:N452)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUM(K453:N453)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H482:J482)","v":0},null,null,null,{"$f":"SUM(K482:N482)","v":0}]
[null,"Explanations of other accrual adjustments or if grant has fund balance but no FY activity:",null,null,null,null,null,null,null,"TOTALS--Capital",{"$f":"SUMIF($F452:$F482,\"Capital\",K452:K482)","v":0},null,null,null,{"$f":"SUMIF($F452:$F482,\"Capital\",O452:O482)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"TOTALS--Operating",{"$f":"SUMIF($F452:$F482,\"Operating\",K452:K482)","v":0},null,null,null,{"$f":"SUMIF($F452:$F482,\"Operating\",O452:O482)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"TOTALS--Unrestricted",{"$f":"SUMIF($F452:$F482,\"Unrestricted\",K452:K482)","v":0},{"$f":"SUM(L452:M482)","v":0},null,{"$f":"SUM(N452:N482)","v":0},{"$f":"SUMIF($F452:$F482,\"Unrestricted\",O452:O482)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Page",null,"of"]
[null,"Agency:",{"$f":"+C457","v":0},null,{"$f":"+E457","v":0}]
[null,null,"Business Area","Name"]
[]
[null,"Preparer:",{"$f":"+C460","v":0},null,null,null,null,null,null,"Reviewer:",{"$f":"+K460","v":0}]
[null,null,null,"Typed Name",null,null,null,null,null,null,null,"Typed Name"]
[]
[]
[null,null,null,"Grantor's",null,null,"Eligibility ?","Beginning","(+)","(-)","Ending","(-)",null,"Other","June 30"]
[null,"Fund","SCEIS","Award",null,"Grant",null,"Fund","Grant Receipts","Grant Qualified","Fund","Accounts Payable",null,"Accrual","Accrual"]
[null,"Number","Grant No","Reference","CFDA","Type",null,"Balance","through June 30","Payments","Balance","Current June 30",null,"Adjustments","Fund Balance"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H502:J502)","v":0},null,null,null,{"$f":"SUM(K502:N502)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUM(K503:N503)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H532:J532)","v":0},null,null,null,{"$f":"SUM(K532:N532)","v":0}]
[null,"Explanations of other accrual adjustments or if grant has fund balance but no FY activity:",null,null,null,null,null,null,null,"TOTALS--Capital",{"$f":"SUMIF($F502:$F532,\"Capital\",K502:K532)","v":0},null,null,null,{"$f":"SUMIF($F502:$F532,\"Capital\",O502:O532)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"TOTALS--Operating",{"$f":"SUMIF($F502:$F532,\"Operating\",K502:K532)","v":0},null,null,null,{"$f":"SUMIF($F502:$F532,\"Operating\",O502:O532)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"TOTALS--Unrestricted",{"$f":"SUMIF($F502:$F532,\"Unrestricted\",K502:K532)","v":0},{"$f":"SUM(L502:M532)","v":0},null,{"$f":"SUM(N502:N532)","v":0},{"$f":"SUMIF($F502:$F532,\"Unrestricted\",O502:O532)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Page",null,"of"]
[null,"Agency:",{"$f":"+C507","v":0},null,{"$f":"+E507","v":0}]
[null,null,"Business Area","Name"]
[]
[null,"Preparer:",{"$f":"+C510","v":0},null,null,null,null,null,null,"Reviewer:",{"$f":"+K510","v":0}]
[null,null,null,"Typed Name",null,null,null,null,null,null,null,"Typed Name"]
[]
[]
[null,null,null,"Grantor's",null,null,"Eligibility ?","Beginning","(+)","(-)","Ending","(-)",null,"Other","June 30"]
[null,"Fund","SCEIS","Award",null,"Grant",null,"Fund","Grant Receipts","Grant Qualified","Fund","Accounts Payable",null,"Accrual","Accrual"]
[null,"Number","Grant No","Reference","CFDA","Type",null,"Balance","through June 30","Payments","Balance","Current June 30",null,"Adjustments","Fund Balance"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H552:J552)","v":0},null,null,null,{"$f":"SUM(K552:N552)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUM(K553:N553)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H582:J582)","v":0},null,null,null,{"$f":"SUM(K582:N582)","v":0}]
[null,"Explanations of other accrual adjustments or if grant has fund balance but no FY activity:",null,null,null,null,null,null,null,"TOTALS--Capital",{"$f":"SUMIF($F552:$F582,\"Capital\",K552:K582)","v":0},null,null,null,{"$f":"SUMIF($F552:$F582,\"Capital\",O552:O582)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"TOTALS--Operating",{"$f":"SUMIF($F552:$F582,\"Operating\",K552:K582)","v":0},null,null,null,{"$f":"SUMIF($F552:$F582,\"Operating\",O552:O582)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"TOTALS--Unrestricted",{"$f":"SUMIF($F552:$F582,\"Unrestricted\",K552:K582)","v":0},{"$f":"SUM(L552:M582)","v":0},null,{"$f":"SUM(N552:N582)","v":0},{"$f":"SUMIF($F552:$F582,\"Unrestricted\",O552:O582)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Page",null,"of"]
[null,"Agency:",{"$f":"+C557","v":0},null,{"$f":"+E557","v":0}]
[null,null,"Business Area","Name"]
[]
[null,"Preparer:",{"$f":"+C560","v":0},null,null,null,null,null,null,"Reviewer:",{"$f":"+K560","v":0}]
[null,null,null,"Typed Name",null,null,null,null,null,null,null,"Typed Name"]
[]
[]
[null,null,null,"Grantor's",null,null,"Eligibility ?","Beginning","(+)","(-)","Ending","(-)",null,"Other","June 30"]
[null,"Fund","SCEIS","Award",null,"Grant",null,"Fund","Grant Receipts","Grant Qualified","Fund","Accounts Payable",null,"Accrual","Accrual"]
[null,"Number","Grant No","Reference","CFDA","Type",null,"Balance","through June 30","Payments","Balance","Current June 30",null,"Adjustments","Fund Balance"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H602:J602)","v":0},null,null,null,{"$f":"SUM(K602:N602)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUM(K603:N603)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H632:J632)","v":0},null,null,null,{"$f":"SUM(K632:N632)","v":0}]
[null,"Explanations of other accrual adjustments or if grant has fund balance but no FY activity:",null,null,null,null,null,null,null,"TOTALS--Capital",{"$f":"SUMIF($F602:$F632,\"Capital\",K602:K632)","v":0},null,null,null,{"$f":"SUMIF($F602:$F632,\"Capital\",O602:O632)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"TOTALS--Operating",{"$f":"SUMIF($F602:$F632,\"Operating\",K602:K632)","v":0},null,null,null,{"$f":"SUMIF($F602:$F632,\"Operating\",O602:O632)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"TOTALS--Unrestricted",{"$f":"SUMIF($F602:$F632,\"Unrestricted\",K602:K632)","v":0},{"$f":"SUM(L602:M632)","v":0},null,{"$f":"SUM(N602:N632)","v":0},{"$f":"SUMIF($F602:$F632,\"Unrestricted\",O602:O632)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Page",null,"of"]
[null,"Agency:",{"$f":"+C607","v":0},null,{"$f":"+E607","v":0}]
[null,null,"Business Area","Name"]
[]
[null,"Preparer:",{"$f":"+C610","v":0},null,null,null,null,null,null,"Reviewer:",{"$f":"+K610","v":0}]
[null,null,null,"Typed Name",null,null,null,null,null,null,null,"Typed Name"]
[]
[]
[null,null,null,"Grantor's",null,null,"Eligibility ?","Beginning","(+)","(-)","Ending","(-)",null,"Other","June 30"]
[null,"Fund","SCEIS","Award",null,"Grant",null,"Fund","Grant Receipts","Grant Qualified","Fund","Accounts Payable",null,"Accrual","Accrual"]
[null,"Number","Grant No","Reference","CFDA","Type",null,"Balance","through June 30","Payments","Balance","Current June 30",null,"Adjustments","Fund Balance"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H652:J652)","v":0},null,null,null,{"$f":"SUM(K652:N652)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUM(K653:N653)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H682:J682)","v":0},null,null,null,{"$f":"SUM(K682:N682)","v":0}]
[null,"Explanations of other accrual adjustments or if grant has fund balance but no FY activity:",null,null,null,null,null,null,null,"TOTALS--Capital",{"$f":"SUMIF($F652:$F682,\"Capital\",K652:K682)","v":0},null,null,null,{"$f":"SUMIF($F652:$F682,\"Capital\",O652:O682)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"TOTALS--Operating",{"$f":"SUMIF($F652:$F682,\"Operating\",K652:K682)","v":0},null,null,null,{"$f":"SUMIF($F652:$F682,\"Operating\",O652:O682)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"TOTALS--Unrestricted",{"$f":"SUMIF($F652:$F682,\"Unrestricted\",K652:K682)","v":0},{"$f":"SUM(L652:M682)","v":0},null,{"$f":"SUM(N652:N682)","v":0},{"$f":"SUMIF($F652:$F682,\"Unrestricted\",O652:O682)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Page",null,"of"]
[null,"Agency:",{"$f":"+C657","v":0},null,{"$f":"+E657","v":0}]
[null,null,"Business Area","Name"]
[]
[null,"Preparer:",{"$f":"+C660","v":0},null,null,null,null,null,null,"Reviewer:",{"$f":"+K660","v":0}]
[null,null,null,"Typed Name",null,null,null,null,null,null,null,"Typed Name"]
[]
[]
[null,null,null,"Grantor's",null,null,"Eligibility ?","Beginning","(+)","(-)","Ending","(-)",null,"Other","June 30"]
[null,"Fund","SCEIS","Award",null,"Grant",null,"Fund","Grant Receipts","Grant Qualified","Fund","Accounts Payable",null,"Accrual","Accrual"]
[null,"Number","Grant No","Reference","CFDA","Type",null,"Balance","through June 30","Payments","Balance","Current June 30",null,"Adjustments","Fund Balance"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H702:J702)","v":0},null,null,null,{"$f":"SUM(K702:N702)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUM(K703:N703)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H732:J732)","v":0},null,null,null,{"$f":"SUM(K732:N732)","v":0}]
[null,"Explanations of other accrual adjustments or if grant has fund balance but no FY activity:",null,null,null,null,null,null,null,"TOTALS--Capital",{"$f":"SUMIF($F702:$F732,\"Capital\",K702:K732)","v":0},null,null,null,{"$f":"SUMIF($F702:$F732,\"Capital\",O702:O732)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"TOTALS--Operating",{"$f":"SUMIF($F702:$F732,\"Operating\",K702:K732)","v":0},null,null,null,{"$f":"SUMIF($F702:$F732,\"Operating\",O702:O732)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"TOTALS--Unrestricted",{"$f":"SUMIF($F702:$F732,\"Unrestricted\",K702:K732)","v":0},{"$f":"SUM(L702:M732)","v":0},null,{"$f":"SUM(N702:N732)","v":0},{"$f":"SUMIF($F702:$F732,\"Unrestricted\",O702:O732)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Page",null,"of"]
[null,"Agency:",{"$f":"+C707","v":0},null,{"$f":"+E707","v":0}]
[null,null,"Business Area","Name"]
[]
[null,"Preparer:",{"$f":"+C710","v":0},null,null,null,null,null,null,"Reviewer:",{"$f":"+K710","v":0}]
[null,null,null,"Typed Name",null,null,null,null,null,null,null,"Typed Name"]
[]
[]
[null,null,null,"Grantor's",null,null,"Eligibility ?","Beginning","(+)","(-)","Ending","(-)",null,"Other","June 30"]
[null,"Fund","SCEIS","Award",null,"Grant",null,"Fund","Grant Receipts","Grant Qualified","Fund","Accounts Payable",null,"Accrual","Accrual"]
[null,"Number","Grant No","Reference","CFDA","Type",null,"Balance","through June 30","Payments","Balance","Current June 30",null,"Adjustments","Fund Balance"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H752:J752)","v":0},null,null,null,{"$f":"SUM(K752:N752)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUM(K753:N753)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H782:J782)","v":0},null,null,null,{"$f":"SUM(K782:N782)","v":0}]
[null,"Explanations of other accrual adjustments or if grant has fund balance but no FY activity:",null,null,null,null,null,null,null,"TOTALS--Capital",{"$f":"SUMIF($F752:$F782,\"Capital\",K752:K782)","v":0},null,null,null,{"$f":"SUMIF($F752:$F782,\"Capital\",O752:O782)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"TOTALS--Operating",{"$f":"SUMIF($F752:$F782,\"Operating\",K752:K782)","v":0},null,null,null,{"$f":"SUMIF($F752:$F782,\"Operating\",O752:O782)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"TOTALS--Unrestricted",{"$f":"SUMIF($F752:$F782,\"Unrestricted\",K752:K782)","v":0},{"$f":"SUM(L752:M782)","v":0},null,{"$f":"SUM(N752:N782)","v":0},{"$f":"SUMIF($F752:$F782,\"Unrestricted\",O752:O782)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Page",null,"of"]
[null,"Agency:",{"$f":"+C757","v":0},null,{"$f":"+E757","v":0}]
[null,null,"Business Area","Name"]
[]
[null,"Preparer:",{"$f":"+C760","v":0},null,null,null,null,null,null,"Reviewer:",{"$f":"+K760","v":0}]
[null,null,null,"Typed Name",null,null,null,null,null,null,null,"Typed Name"]
[]
[]
[null,null,null,"Grantor's",null,null,"Eligibility ?","Beginning","(+)","(-)","Ending","(-)",null,"Other","June 30"]
[null,"Fund","SCEIS","Award",null,"Grant",null,"Fund","Grant Receipts","Grant Qualified","Fund","Accounts Payable",null,"Accrual","Accrual"]
[null,"Number","Grant No","Reference","CFDA","Type",null,"Balance","through June 30","Payments","Balance","Current June 30",null,"Adjustments","Fund Balance"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H802:J802)","v":0},null,null,null,{"$f":"SUM(K802:N802)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUM(K803:N803)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H832:J832)","v":0},null,null,null,{"$f":"SUM(K832:N832)","v":0}]
[null,"Explanations of other accrual adjustments or if grant has fund balance but no FY activity:",null,null,null,null,null,null,null,null,{"$f":"SUMIF($F802:$F832,\"Capital\",K802:K832)","v":0},null,null,null,{"$f":"SUMIF($F802:$F832,\"Capital\",O802:O832)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"TOTALS--Operating",{"$f":"SUMIF($F802:$F832,\"Operating\",K802:K832)","v":0},null,null,null,{"$f":"SUMIF($F802:$F832,\"Operating\",O802:O832)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"TOTALS--Unrestricted",{"$f":"SUMIF($F802:$F832,\"Unrestricted\",K802:K832)","v":0},{"$f":"SUM(L802:M832)","v":0},null,{"$f":"SUM(N802:N832)","v":0},{"$f":"SUMIF($F802:$F832,\"Unrestricted\",O802:O832)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Page",null,"of"]
[null,"Agency:",{"$f":"+C807","v":0},null,{"$f":"+E807","v":0}]
[null,null,"Business Area","Name"]
[]
[null,"Preparer:",{"$f":"+C810","v":0},null,null,null,null,null,null,"Reviewer:",{"$f":"+K810","v":0}]
[null,null,null,"Typed Name",null,null,null,null,null,null,null,"Typed Name"]
[]
[]
[null,null,null,"Grantor's",null,null,"Eligibility ?","Beginning","(+)","(-)","Ending","(-)",null,"Other","June 30"]
[null,"Fund","SCEIS","Award",null,"Grant",null,"Fund","Grant Receipts","Grant Qualified","Fund","Accounts Payable",null,"Accrual","Accrual"]
[null,"Number","Grant No","Reference","CFDA","Type",null,"Balance","through June 30","Payments","Balance","Current June 30",null,"Adjustments","Fund Balance"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H852:J852)","v":0},null,null,null,{"$f":"SUM(K852:N852)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUM(K853:N853)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H882:J882)","v":0},null,null,null,{"$f":"SUM(K882:N882)","v":0}]
[null,"Explanations of other accrual adjustments or if grant has fund balance but no FY activity:",null,null,null,null,null,null,null,null,{"$f":"SUMIF($F852:$F882,\"Capital\",K852:K882)","v":0},null,null,null,{"$f":"SUMIF($F852:$F882,\"Capital\",O852:O882)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"TOTALS--Operating",{"$f":"SUMIF($F852:$F882,\"Operating\",K852:K882)","v":0},null,null,null,{"$f":"SUMIF($F852:$F882,\"Operating\",O852:O882)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"TOTALS--Unrestricted",{"$f":"SUMIF($F852:$F882,\"Unrestricted\",K852:K882)","v":0},{"$f":"SUM(L852:M882)","v":0},null,{"$f":"SUM(N852:N882)","v":0},{"$f":"SUMIF($F852:$F882,\"Unrestricted\",O852:O882)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Page",null,"of"]
[null,"Agency:",{"$f":"+C857","v":0},null,{"$f":"+E857","v":0}]
[null,null,"Business Area","Name"]
[]
[null,"Preparer:",{"$f":"+C860","v":0},null,null,null,null,null,null,"Reviewer:",{"$f":"+K860","v":0}]
[null,null,null,"Typed Name",null,null,null,null,null,null,null,"Typed Name"]
[]
[]
[null,null,null,"Grantor's",null,null,"Eligibility ?","Beginning","(+)","(-)","Ending","(-)",null,"Other","June 30"]
[null,"Fund","SCEIS","Award",null,"Grant",null,"Fund","Grant Receipts","Grant Qualified","Fund","Accounts Payable",null,"Accrual","Accrual"]
[null,"Number","Grant No","Reference","CFDA","Type",null,"Balance","through June 30","Payments","Balance","Current June 30",null,"Adjustments","Fund Balance"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H902:J902)","v":0},null,null,null,{"$f":"SUM(K902:N902)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUM(K903:N903)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H932:J932)","v":0},null,null,null,{"$f":"SUM(K932:N932)","v":0}]
[null,"Explanations of other accrual adjustments or if grant has fund balance but no FY activity:",null,null,null,null,null,null,null,null,{"$f":"SUMIF($F902:$F932,\"Capital\",K902:K932)","v":0},null,null,null,{"$f":"SUMIF($F902:$F932,\"Capital\",O902:O932)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"TOTALS--Operating",{"$f":"SUMIF($F902:$F932,\"Operating\",K902:K932)","v":0},null,null,null,{"$f":"SUMIF($F902:$F932,\"Operating\",O902:O932)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"TOTALS--Unrestricted",{"$f":"SUMIF($F902:$F932,\"Unrestricted\",K902:K932)","v":0},{"$f":"SUM(L902:M932)","v":0},null,{"$f":"SUM(N902:N932)","v":0},{"$f":"SUMIF($F902:$F932,\"Unrestricted\",O902:O932)","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Page",null,"of"]
[null,"Agency:",{"$f":"+C907","v":0},null,{"$f":"+E907","v":0}]
[null,null,"Business Area","Name"]
[]
[null,"Preparer:",{"$f":"+C910","v":0},null,null,null,null,null,null,"Reviewer:",{"$f":"+K910","v":0}]
[null,null,null,"Typed Name",null,null,null,null,null,null,null,"Typed Name"]
[]
[]
[null,null,null,"Grantor's",null,null,"Eligibility ?","Beginning","(+)","(-)","Ending","(-)",null,"Other","June 30"]
[null,"Fund","SCEIS","Award",null,"Grant",null,"Fund","Grant Receipts","Grant Qualified","Fund","Accounts Payable",null,"Accrual","Accrual"]
[null,"Number","Grant No","Reference","CFDA","Type",null,"Balance","through June 30","Payments","Balance","Current June 30",null,"Adjustments","Fund Balance"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H952:J952)","v":0},null,null,null,{"$f":"SUM(K952:N952)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUM(K953:N953)","v":0}]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,0,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H982:J982)","v":0},null,null,null,{"$f":"SUM(K982:N982)","v":0}]
[null,"Explanations of other accrual adjustments or if grant has fund balance but no FY activity:",null,null,null,null,null,null,null,null,{"$f":"SUMIF($F952:$F982,\"Capital\",K952:K982)","v":0},null,null,null,{"$f":"SUMIF($F952:$F982,\"Capital\",O952:O982)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"TOTALS--Operating",{"$f":"SUMIF($F952:$F982,\"Operating\",K952:K982)","v":0},null,null,null,{"$f":"SUMIF($F952:$F982,\"Operating\",O952:O982)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"TOTALS--Unrestricted",{"$f":"SUMIF($F952:$F982,\"Unrestricted\",K952:K982)","v":0},{"$f":"SUM(L952:M982)","v":0},null,{"$f":"SUM(N952:N982)","v":0},{"$f":"SUMIF($F952:$F982,\"Unrestricted\",O952:O982)","v":0}]

{"sheet":"3.03.2","index":3,"n_rows":59,"n_cols":24,"rows_kept":59,"cut":false,"hidden":false,"merged":[[57,23,57,24],[58,23,58,24],[46,23,46,24],[49,23,49,24],[50,23,50,24],[51,23,51,24],[52,23,52,24],[53,23,53,24],[54,23,54,24],[55,23,55,24],[56,23,56,24],[37,23,37,24],[38,23,38,24],[39,23,39,24],[40,23,40,24],[41,23,41,24],[42,23,42,24],[43,23,43,24],[44,23,44,24],[45,23,45,24],[25,23,25,24],[26,23,26,24],[27,23,27,24],[28,23,28,24],[29,23,29,24],[30,23,30,24],[31,23,31,24],[32,23,32,24],[36,23,36,24],[13,23,14,24],[18,23,18,24],[19,23,19,24],[20,23,20,24],[21,23,21,24],[22,23,22,24],[23,23,23,24],[24,23,24,24],[14,8,14,9],[37,8,37,9],[27,8,27,9],[27,12,27,13],[27,16,27,17],[19,8,19,9],[37,20,37,21],[38,8,38,9],[38,12,38,13],[38,16,38,17],[38,20,38,21],[24,12,24,13],[27,20,27,21],[28,8,28,9],[28,12,28,13],[28,16,28,17],[28,20,28,21],[25,20,25,21],[26,20,26,21],[7,7,7,16],[18,16,18,17],[43,12,43,13],[43,16,43,17],[19,16,19,17],[23,16,23,17],[29,8,29,9],[29,12,29,13],[29,16,29,17],[30,8,30,9],[30,12,30,13],[30,16,30,17],[31,8,31,9],[31,12,31,13],[31,16,31,17],[14,12,14,13],[18,8,18,9],[18,12,18,13],[25,16,25,17],[26,16,26,17],[10,4,10,10],[10,13,10,21],[39,8,39,9],[39,12,39,13],[40,8,40,9],[40,12,40,13],[43,20,43,21],[40,16,40,17],[14,15,14,18],[14,20,14,21],[18,20,18,21],[36,8,36,9],[36,12,36,13],[36,16,36,17],[36,20,36,21],[25,12,25,13],[26,12,26,13],[32,12,32,13],[29,20,29,21],[30,20,30,21],[31,20,31,21],[19,12,19,13],[20,12,20,13],[21,12,21,13],[22,12,22,13],[23,12,23,13],[39,16,39,17],[39,20,39,21],[41,20,41,21],[42,8,42,9],[42,12,42,13],[42,16,42,17],[42,20,42,21],[43,8,43,9],[41,12,41,13],[49,8,49,9],[49,12,49,13],[58,8,58,9],[50,12,50,13],[51,12,51,13],[52,12,52,13],[53,12,53,13],[54,12,54,13],[32,16,32,17],[32,20,32,21],[50,8,50,9],[51,8,51,9],[52,8,52,9],[53,8,53,9],[49,20,49,21],[45,8,45,9],[45,12,45,13],[45,16,45,17],[45,20,45,21],[32,8,32,9],[44,8,44,9],[53,16,53,17],[54,16,54,17],[55,16,55,17],[41,16,41,17],[37,12,37,13],[54,8,54,9],[55,8,55,9],[19,20,19,21],[20,16,20,17],[20,20,20,21],[21,16,21,17],[21,20,21,21],[22,16,22,17],[22,20,22,21],[20,8,20,9],[21,8,21,9],[22,8,22,9],[23,8,23,9],[24,8,24,9],[25,8,25,9],[26,8,26,9],[23,20,23,21],[24,16,24,17],[24,20,24,21],[44,12,44,13],[44,16,44,17],[44,20,44,21],[40,20,40,21],[41,8,41,9],[58,12,58,13],[50,16,50,17],[56,8,56,9],[57,8,57,9],[57,20,57,21],[58,20,58,21],[13,8,13,17],[56,16,56,17],[57,16,57,17],[58,16,58,17],[50,20,50,21],[51,20,51,21],[52,20,52,21],[53,20,53,21],[54,20,54,21],[55,20,55,21],[56,20,56,21],[55,12,55,13],[56,12,56,13],[57,12,57,13],[49,16,49,17],[37,16,37,17],[51,16,51,17],[52,16,52,17]]}
[]
[null,"STATE OF SOUTH CAROLINA"]
[null,"GRANTS RECEIVABLES AND DEFERRED REVENUE"]
[null,"SUMMARY FORM"]
[null,null,null,null,null,null,null,null,null,null,null,"AT JUNE 30,",{"$f":"IF('3.03.1'!J4=\"\",\"\",'3.03.1'!J4)","v":2019}]
[]
[]
[null,null,"Agency:",null,{"$f":"IF('3.03.1'!C7=\"\",\"\",'3.03.1'!C7)","v":"E120"},null,null,{"$f":"+'Signature 1'!E6","v":"COMPTROLLER GENERAL'S OFFICE\n"}]
[null,null,null,null,"Business Area",null,null,null,null,null,null,null,"Name"]
[]
[null,null,"Preparer:",null,"Employee ABC",null,null,null,null,null,null,null,"Reviewer:","Supervisor XYZ"]
[null,null,null,null,null,"Typed Name",null,null,null,null,null,null,null,null,null,null,"Typed Name"]
[]
[null,null,null,null,null,null,null,null,"Receivable Balances",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Accounts Payable"]
[null,null,"Fund No",null,"Account Description",null,null,null,"Total",null,null,null,"Current",null,null,"Non-Current",null,null,null,null,"Deferred Revenue"]
[]
[null,null,"Operating Grants - Federal or other"]
[]
[null,null,50550000,null,{"$f":"IF(C19=\"\",\"\",IF(VALUE(LEFT(C19,1))=5,\"Federal Grant Revenue\",\"Other Grant Revenue\"))","v":"Federal Grant Revenue"},null,null,"$",{"$f":"-SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C19,'3.03.1'!O$18:O$982,\"<0\",'3.03.1'!F$18:F$982,\"Operating\")","v":176375},null,null,"$",176375,null,null,"$",{"$f":"IF(I19<0,\"Error - No current should be reported\",I19-M19)","v":0},null,null,"$",{"$f":"SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C19,'3.03.1'!O$18:O$982,\">0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0},null,"$",{"$f":"SUMIFS('3.03.1'!L$18:L$982,'3.03.1'!B$18:B$982,'3.03.2'!C19,'3.03.1'!L$18:L$982,\"<0\",'3.03.1'!F$18:F$982,\"Operating\")","v":-6875}]
[null,null,null,null,{"$f":"IF(C20=\"\",\"\",IF(VALUE(LEFT(C20,1))=5,\"Federal Grant Revenue\",\"Other Grant Revenue\"))","v":""},null,null,null,{"$f":"-SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C20,'3.03.1'!O$18:O$982,\"<0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0},null,null,null,null,null,null,null,{"$f":"IF(I20<0,\"Error - No current should be reported\",I20-M20)","v":0},null,null,null,{"$f":"SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C20,'3.03.1'!O$18:O$982,\">0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0},null,null,{"$f":"SUMIFS('3.03.1'!L$18:L$982,'3.03.1'!B$18:B$982,'3.03.2'!C20,'3.03.1'!L$18:L$982,\"<0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0}]
[null,null,null,null,"",null,null,null,{"$f":"-SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C21,'3.03.1'!O$18:O$982,\"<0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0},null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C21,'3.03.1'!O$18:O$982,\">0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0},null,null,{"$f":"SUMIFS('3.03.1'!L$18:L$982,'3.03.1'!B$18:B$982,'3.03.2'!C21,'3.03.1'!L$18:L$982,\"<0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0}]
[null,null,null,null,"",null,null,null,{"$f":"-SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C22,'3.03.1'!O$18:O$982,\"<0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0},null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C22,'3.03.1'!O$18:O$982,\">0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0},null,null,{"$f":"SUMIFS('3.03.1'!L$18:L$982,'3.03.1'!B$18:B$982,'3.03.2'!C22,'3.03.1'!L$18:L$982,\"<0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0}]
[null,null,null,null,"",null,null,null,{"$f":"-SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C23,'3.03.1'!O$18:O$982,\"<0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0},null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C23,'3.03.1'!O$18:O$982,\">0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0},null,null,{"$f":"SUMIFS('3.03.1'!L$18:L$982,'3.03.1'!B$18:B$982,'3.03.2'!C23,'3.03.1'!L$18:L$982,\"<0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0}]
[null,null,null,null,"",null,null,null,{"$f":"-SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C24,'3.03.1'!O$18:O$982,\"<0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0},null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C24,'3.03.1'!O$18:O$982,\">0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0},null,null,{"$f":"SUMIFS('3.03.1'!L$18:L$982,'3.03.1'!B$18:B$982,'3.03.2'!C24,'3.03.1'!L$18:L$982,\"<0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0}]
[null,null,null,null,"",null,null,null,{"$f":"-SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C25,'3.03.1'!O$18:O$982,\"<0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0},null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C25,'3.03.1'!O$18:O$982,\">0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0},null,null,{"$f":"SUMIFS('3.03.1'!L$18:L$982,'3.03.1'!B$18:B$982,'3.03.2'!C25,'3.03.1'!L$18:L$982,\"<0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0}]
[null,null,null,null,"",null,null,null,{"$f":"-SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C26,'3.03.1'!O$18:O$982,\"<0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0},null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C26,'3.03.1'!O$18:O$982,\">0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0},null,null,{"$f":"SUMIFS('3.03.1'!L$18:L$982,'3.03.1'!B$18:B$982,'3.03.2'!C26,'3.03.1'!L$18:L$982,\"<0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0}]
[null,null,null,null,"",null,null,null,{"$f":"-SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C27,'3.03.1'!O$18:O$982,\"<0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0},null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C27,'3.03.1'!O$18:O$982,\">0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0},null,null,{"$f":"SUMIFS('3.03.1'!L$18:L$982,'3.03.1'!B$18:B$982,'3.03.2'!C27,'3.03.1'!L$18:L$982,\"<0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0}]
[null,null,null,null,"",null,null,null,{"$f":"-SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C28,'3.03.1'!O$18:O$982,\"<0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0},null,null,null,null,null,null,null,{"$f":"IF(I28<0,\"Error - No current should be reported\",I28-M28)","v":0},null,null,null,{"$f":"SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C28,'3.03.1'!O$18:O$982,\">0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0},null,null,{"$f":"SUMIFS('3.03.1'!L$18:L$982,'3.03.1'!B$18:B$982,'3.03.2'!C28,'3.03.1'!L$18:L$982,\"<0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0}]
[null,null,null,null,"",null,null,null,{"$f":"-SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C29,'3.03.1'!O$18:O$982,\"<0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0},null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C29,'3.03.1'!O$18:O$982,\">0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0},null,null,{"$f":"SUMIFS('3.03.1'!L$18:L$982,'3.03.1'!B$18:B$982,'3.03.2'!C29,'3.03.1'!L$18:L$982,\"<0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0}]
[null,null,null,null,"",null,null,null,{"$f":"-SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C30,'3.03.1'!O$18:O$982,\"<0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0},null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C30,'3.03.1'!O$18:O$982,\">0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0},null,null,{"$f":"SUMIFS('3.03.1'!L$18:L$982,'3.03.1'!B$18:B$982,'3.03.2'!C30,'3.03.1'!L$18:L$982,\"<0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0}]
[null,null,null,null,"",null,null,null,{"$f":"-SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C31,'3.03.1'!O$18:O$982,\"<0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0},null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C31,'3.03.1'!O$18:O$982,\">0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0},null,null,{"$f":"SUMIFS('3.03.1'!L$18:L$982,'3.03.1'!B$18:B$982,'3.03.2'!C31,'3.03.1'!L$18:L$982,\"<0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0}]
[null,null,null,null,"",null,null,null,{"$f":"-SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C32,'3.03.1'!O$18:O$982,\"<0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0},null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C32,'3.03.1'!O$18:O$982,\">0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0},null,null,{"$f":"SUMIFS('3.03.1'!L$18:L$982,'3.03.1'!B$18:B$982,'3.03.2'!C32,'3.03.1'!L$18:L$982,\"<0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0}]
[null,null,null,null,"",null,null,null,{"$f":"-SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C33,'3.03.1'!O$18:O$982,\"<0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0},null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C33,'3.03.1'!O$18:O$982,\">0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0},null,null,{"$f":"SUMIFS('3.03.1'!L$18:L$982,'3.03.1'!B$18:B$982,'3.03.2'!C33,'3.03.1'!L$18:L$982,\"<0\",'3.03.1'!F$18:F$982,\"Operating\")","v":0}]
[]
[null,null,"Capital Grants - Federal or other"]
[]
[null,null,50550000,null,{"$f":"IF(C37=\"\",\"\",IF(VALUE(LEFT(C37,1))=5,\"Federal Grant Revenue\",\"Other Grant Revenue\"))","v":"Federal Grant Revenue"},null,null,"$",{"$f":"-SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C37,'3.03.1'!O$18:O$982,\"<0\",'3.03.1'!F$18:F$982,\"Capital\")","v":13000},null,null,"$",13000,null,null,"$",{"$f":"IF(I37<0,\"Error - No current should be reported\",I37-M37)","v":0},null,null,"$",{"$f":"SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C37,'3.03.1'!O$18:O$982,\">0\",'3.03.1'!F$18:F$982,\"Capital\")","v":0},null,"$",{"$f":"SUMIFS('3.03.1'!L$18:L$982,'3.03.1'!B$18:B$982,'3.03.2'!C37,'3.03.1'!L$18:L$982,\"<0\",'3.03.1'!F$18:F$982,\"Capital\")","v":0}]
[null,null,null,null,"",null,null,null,{"$f":"-SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C38,'3.03.1'!O$18:O$982,\"<0\",'3.03.1'!F$18:F$982,\"Capital\")","v":0},null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C38,'3.03.1'!O$18:O$982,\">0\",'3.03.1'!F$18:F$982,\"Capital\")","v":0},null,null,{"$f":"SUMIFS('3.03.1'!L$18:L$982,'3.03.1'!B$18:B$982,'3.03.2'!C38,'3.03.1'!L$18:L$982,\"<0\",'3.03.1'!F$18:F$982,\"Capital\")","v":0}]
[null,null,null,null,"",null,null,null,{"$f":"-SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C39,'3.03.1'!O$18:O$982,\"<0\",'3.03.1'!F$18:F$982,\"Capital\")","v":0},null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C39,'3.03.1'!O$18:O$982,\">0\",'3.03.1'!F$18:F$982,\"Capital\")","v":0},null,null,{"$f":"SUMIFS('3.03.1'!L$18:L$982,'3.03.1'!B$18:B$982,'3.03.2'!C39,'3.03.1'!L$18:L$982,\"<0\",'3.03.1'!F$18:F$982,\"Capital\")","v":0}]
[null,null,null,null,"",null,null,null,{"$f":"-SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C40,'3.03.1'!O$18:O$982,\"<0\",'3.03.1'!F$18:F$982,\"Capital\")","v":0},null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C40,'3.03.1'!O$18:O$982,\">0\",'3.03.1'!F$18:F$982,\"Capital\")","v":0},null,null,{"$f":"SUMIFS('3.03.1'!L$18:L$982,'3.03.1'!B$18:B$982,'3.03.2'!C40,'3.03.1'!L$18:L$982,\"<0\",'3.03.1'!F$18:F$982,\"Capital\")","v":0}]
[null,null,null,null,"",null,null,null,{"$f":"-SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C41,'3.03.1'!O$18:O$982,\"<0\",'3.03.1'!F$18:F$982,\"Capital\")","v":0},null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C41,'3.03.1'!O$18:O$982,\">0\",'3.03.1'!F$18:F$982,\"Capital\")","v":0},null,null,{"$f":"SUMIFS('3.03.1'!L$18:L$982,'3.03.1'!B$18:B$982,'3.03.2'!C41,'3.03.1'!L$18:L$982,\"<0\",'3.03.1'!F$18:F$982,\"Capital\")","v":0}]
[null,null,null,null,"",null,null,null,{"$f":"-SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C42,'3.03.1'!O$18:O$982,\"<0\",'3.03.1'!F$18:F$982,\"Capital\")","v":0},null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C42,'3.03.1'!O$18:O$982,\">0\",'3.03.1'!F$18:F$982,\"Capital\")","v":0},null,null,{"$f":"SUMIFS('3.03.1'!L$18:L$982,'3.03.1'!B$18:B$982,'3.03.2'!C42,'3.03.1'!L$18:L$982,\"<0\",'3.03.1'!F$18:F$982,\"Capital\")","v":0}]
[null,null,null,null,"",null,null,null,{"$f":"-SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C43,'3.03.1'!O$18:O$982,\"<0\",'3.03.1'!F$18:F$982,\"Capital\")","v":0},null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C43,'3.03.1'!O$18:O$982,\">0\",'3.03.1'!F$18:F$982,\"Capital\")","v":0},null,null,{"$f":"SUMIFS('3.03.1'!L$18:L$982,'3.03.1'!B$18:B$982,'3.03.2'!C43,'3.03.1'!L$18:L$982,\"<0\",'3.03.1'!F$18:F$982,\"Capital\")","v":0}]
[null,null,null,null,"",null,null,null,{"$f":"-SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C44,'3.03.1'!O$18:O$982,\"<0\",'3.03.1'!F$18:F$982,\"Capital\")","v":0},null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C44,'3.03.1'!O$18:O$982,\">0\",'3.03.1'!F$18:F$982,\"Capital\")","v":0},null,null,{"$f":"SUMIFS('3.03.1'!L$18:L$982,'3.03.1'!B$18:B$982,'3.03.2'!C44,'3.03.1'!L$18:L$982,\"<0\",'3.03.1'!F$18:F$982,\"Capital\")","v":0}]
[null,null,null,null,"",null,null,null,{"$f":"-SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C45,'3.03.1'!O$18:O$982,\"<0\",'3.03.1'!F$18:F$982,\"Capital\")","v":0},null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C45,'3.03.1'!O$18:O$982,\">0\",'3.03.1'!F$18:F$982,\"Capital\")","v":0},null,null,{"$f":"SUMIFS('3.03.1'!L$18:L$982,'3.03.1'!B$18:B$982,'3.03.2'!C45,'3.03.1'!L$18:L$982,\"<0\",'3.03.1'!F$18:F$982,\"Capital\")","v":0}]
[null,null,null,null,"",null,null,null,{"$f":"-SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C46,'3.03.1'!O$18:O$982,\"<0\",'3.03.1'!F$18:F$982,\"Capital\")","v":0},null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C46,'3.03.1'!O$18:O$982,\">0\",'3.03.1'!F$18:F$982,\"Capital\")","v":0},null,null,{"$f":"SUMIFS('3.03.1'!L$18:L$982,'3.03.1'!B$18:B$982,'3.03.2'!C46,'3.03.1'!L$18:L$982,\"<0\",'3.03.1'!F$18:F$982,\"Capital\")","v":0}]
[]
[null,null,"Unrestricted Grants - Federal or other"]
[]
[null,null,null,null,{"$f":"IF(C50=\"\",\"\",IF(VALUE(LEFT(C50,1))=5,\"Federal Grant Revenue\",\"Other Grant Revenue\"))","v":""},null,null,"$",{"$f":"-SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C50,'3.03.1'!O$18:O$982,\"<0\",'3.03.1'!F$18:F$982,\"Unrestricted\")","v":0},null,null,"$",null,null,null,"$",{"$f":"IF(I50<0,\"Error - No current should be reported\",I50-M50)","v":0},null,null,"$",{"$f":"SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C50,'3.03.1'!O$18:O$982,\">0\",'3.03.1'!F$18:F$982,\"Unrestricted\")","v":0},null,"$",{"$f":"SUMIFS('3.03.1'!L$18:L$982,'3.03.1'!B$18:B$982,'3.03.2'!C50,'3.03.1'!L$18:L$982,\"<0\",'3.03.1'!F$18:F$982,\"Unrestricted\")","v":0}]
[null,null,null,null,{"$f":"IF(C51=\"\",\"\",IF(VALUE(LEFT(C51,1))=5,\"Federal Grant Revenue\",\"Other Grant Revenue\"))","v":""},null,null,null,{"$f":"-SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C51,'3.03.1'!O$18:O$982,\"<0\",'3.03.1'!F$18:F$982,\"Unrestricted\")","v":0},null,null,null,null,null,null,null,{"$f":"IF(I51<0,\"Error - No current should be reported\",I51-M51)","v":0},null,null,null,{"$f":"SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C51,'3.03.1'!O$18:O$982,\">0\",'3.03.1'!F$18:F$982,\"Unrestricted\")","v":0},null,null,{"$f":"SUMIFS('3.03.1'!L$18:L$982,'3.03.1'!B$18:B$982,'3.03.2'!C51,'3.03.1'!L$18:L$982,\"<0\",'3.03.1'!F$18:F$982,\"Unrestricted\")","v":0}]
[null,null,null,null,"",null,null,null,{"$f":"-SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C52,'3.03.1'!O$18:O$982,\"<0\",'3.03.1'!F$18:F$982,\"Unrestricted\")","v":0},null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C52,'3.03.1'!O$18:O$982,\">0\",'3.03.1'!F$18:F$982,\"Unrestricted\")","v":0},null,null,{"$f":"SUMIFS('3.03.1'!L$18:L$982,'3.03.1'!B$18:B$982,'3.03.2'!C52,'3.03.1'!L$18:L$982,\"<0\",'3.03.1'!F$18:F$982,\"Unrestricted\")","v":0}]
[null,null,null,null,"",null,null,null,{"$f":"-SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C53,'3.03.1'!O$18:O$982,\"<0\",'3.03.1'!F$18:F$982,\"Unrestricted\")","v":0},null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C53,'3.03.1'!O$18:O$982,\">0\",'3.03.1'!F$18:F$982,\"Unrestricted\")","v":0},null,null,{"$f":"SUMIFS('3.03.1'!L$18:L$982,'3.03.1'!B$18:B$982,'3.03.2'!C53,'3.03.1'!L$18:L$982,\"<0\",'3.03.1'!F$18:F$982,\"Unrestricted\")","v":0}]
[null,null,null,null,"",null,null,null,{"$f":"-SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C54,'3.03.1'!O$18:O$982,\"<0\",'3.03.1'!F$18:F$982,\"Unrestricted\")","v":0},null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C54,'3.03.1'!O$18:O$982,\">0\",'3.03.1'!F$18:F$982,\"Unrestricted\")","v":0},null,null,{"$f":"SUMIFS('3.03.1'!L$18:L$982,'3.03.1'!B$18:B$982,'3.03.2'!C54,'3.03.1'!L$18:L$982,\"<0\",'3.03.1'!F$18:F$982,\"Unrestricted\")","v":0}]
[null,null,null,null,"",null,null,null,{"$f":"-SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C55,'3.03.1'!O$18:O$982,\"<0\",'3.03.1'!F$18:F$982,\"Unrestricted\")","v":0},null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C55,'3.03.1'!O$18:O$982,\">0\",'3.03.1'!F$18:F$982,\"Unrestricted\")","v":0},null,null,{"$f":"SUMIFS('3.03.1'!L$18:L$982,'3.03.1'!B$18:B$982,'3.03.2'!C55,'3.03.1'!L$18:L$982,\"<0\",'3.03.1'!F$18:F$982,\"Unrestricted\")","v":0}]
[null,null,null,null,"",null,null,null,{"$f":"-SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C56,'3.03.1'!O$18:O$982,\"<0\",'3.03.1'!F$18:F$982,\"Unrestricted\")","v":0},null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C56,'3.03.1'!O$18:O$982,\">0\",'3.03.1'!F$18:F$982,\"Unrestricted\")","v":0},null,null,{"$f":"SUMIFS('3.03.1'!L$18:L$982,'3.03.1'!B$18:B$982,'3.03.2'!C56,'3.03.1'!L$18:L$982,\"<0\",'3.03.1'!F$18:F$982,\"Unrestricted\")","v":0}]
[null,null,null,null,"",null,null,null,{"$f":"-SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C57,'3.03.1'!O$18:O$982,\"<0\",'3.03.1'!F$18:F$982,\"Unrestricted\")","v":0},null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C57,'3.03.1'!O$18:O$982,\">0\",'3.03.1'!F$18:F$982,\"Unrestricted\")","v":0},null,null,{"$f":"SUMIFS('3.03.1'!L$18:L$982,'3.03.1'!B$18:B$982,'3.03.2'!C57,'3.03.1'!L$18:L$982,\"<0\",'3.03.1'!F$18:F$982,\"Unrestricted\")","v":0}]
[null,null,null,null,"",null,null,null,{"$f":"-SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C58,'3.03.1'!O$18:O$982,\"<0\",'3.03.1'!F$18:F$982,\"Unrestricted\")","v":0},null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C58,'3.03.1'!O$18:O$982,\">0\",'3.03.1'!F$18:F$982,\"Unrestricted\")","v":0},null,null,{"$f":"SUMIFS('3.03.1'!L$18:L$982,'3.03.1'!B$18:B$982,'3.03.2'!C58,'3.03.1'!L$18:L$982,\"<0\",'3.03.1'!F$18:F$982,\"Unrestricted\")","v":0}]
[null,null,null,null,"",null,null,null,{"$f":"-SUMIFS('3.03.1'!O$18:O$982,'3.03.1'!B$18:B$982,'3.03.2'!C59,'3.03.1'!O$18:O$982,\"<0\",'3.03.1'!F$18:F$982,\"Unrestricted\")","v":0},null,null,null,null,null,null,null,0,null,null,null,{"$f":"SUMIFS('3.03.1'!O$18:O$32,'3.03.1'!B$18:B$32,'3.03.2'!C59,'3.03.1'!O$18:O$32,\">0\",'3.03.1'!F$18:F$32,\"Unrestricted\")","v":0},null,null,{"$f":"SUMIFS('3.03.1'!L$18:L$982,'3.03.1'!B$18:B$982,'3.03.2'!C59,'3.03.1'!L$18:L$982,\"<0\",'3.03.1'!F$18:F$982,\"Unrestricted\")","v":0}]

{"sheet":"3.03.3","index":4,"n_rows":59,"n_cols":21,"rows_kept":59,"cut":false,"hidden":false,"merged":[[13,8,13,17],[14,8,14,9],[14,12,14,13],[14,15,14,18],[7,7,7,16],[14,20,14,21],[18,8,18,9],[18,12,18,13],[18,16,18,17],[18,20,18,21],[10,4,10,10],[10,13,10,21],[19,8,19,9],[19,12,19,13],[19,16,19,17],[19,20,19,21],[22,8,22,9],[22,12,22,13],[22,16,22,17],[22,20,22,21],[23,8,23,9],[23,12,23,13],[23,16,23,17],[23,20,23,21],[20,8,20,9],[20,12,20,13],[20,16,20,17],[20,20,20,21],[21,8,21,9],[21,12,21,13],[21,16,21,17],[21,20,21,21],[26,16,26,17],[26,20,26,21],[27,8,27,9],[27,12,27,13],[27,16,27,17],[27,20,27,21],[24,8,24,9],[24,12,24,13],[24,16,24,17],[24,20,24,21],[25,8,25,9],[25,12,25,13],[25,16,25,17],[25,20,25,21],[30,20,30,21],[31,8,31,9],[31,12,31,13],[31,16,31,17],[31,20,31,21],[28,8,28,9],[28,12,28,13],[28,16,28,17],[28,20,28,21],[29,8,29,9],[29,12,29,13],[29,16,29,17],[29,20,29,21],[37,20,37,21],[38,8,38,9],[38,12,38,13],[38,16,38,17],[38,20,38,21],[32,8,32,9],[32,12,32,13],[32,16,32,17],[32,20,32,21],[36,8,36,9],[36,12,36,13],[36,16,36,17],[36,20,36,21],[41,20,41,21],[42,8,42,9],[42,12,42,13],[42,16,42,17],[42,20,42,21],[39,8,39,9],[39,12,39,13],[39,16,39,17],[39,20,39,21],[40,8,40,9],[40,12,40,13],[40,16,40,17],[40,20,40,21],[45,20,45,21],[49,8,49,9],[49,12,49,13],[49,16,49,17],[49,20,49,21],[43,8,43,9],[43,12,43,13],[43,16,43,17],[43,20,43,21],[44,8,44,9],[44,12,44,13],[44,16,44,17],[44,20,44,21],[52,20,52,21],[53,8,53,9],[53,12,53,13],[53,16,53,17],[53,20,53,21],[50,8,50,9],[50,12,50,13],[50,16,50,17],[50,20,50,21],[51,8,51,9],[51,12,51,13],[51,16,51,17],[51,20,51,21],[58,20,58,21],[18,4,18,5],[19,4,19,5],[20,4,20,5],[21,4,21,5],[22,4,22,5],[56,8,56,9],[56,12,56,13],[56,16,56,17],[56,20,56,21],[57,8,57,9],[57,12,57,13],[57,16,57,17],[57,20,57,21],[54,8,54,9],[54,12,54,13],[54,16,54,17],[54,20,54,21],[55,8,55,9],[55,12,55,13],[55,16,55,17],[55,20,55,21],[52,8,52,9],[52,12,52,13],[23,4,23,5],[24,4,24,5],[25,4,25,5],[26,4,26,5],[27,4,27,5],[28,4,28,5],[58,8,58,9],[58,12,58,13],[58,16,58,17],[52,16,52,17],[45,8,45,9],[45,12,45,13],[45,16,45,17],[41,8,41,9],[41,12,41,13],[41,16,41,17],[37,8,37,9],[37,12,37,13],[37,16,37,17],[30,8,30,9],[30,12,30,13],[30,16,30,17],[26,8,26,9],[26,12,26,13],[38,4,38,5],[39,4,39,5],[40,4,40,5],[41,4,41,5],[42,4,42,5],[43,4,43,5],[29,4,29,5],[30,4,30,5],[31,4,31,5],[32,4,32,5],[36,4,36,5],[37,4,37,5],[53,4,53,5],[54,4,54,5],[55,4,55,5],[56,4,56,5],[57,4,57,5],[58,4,58,5],[44,4,44,5],[45,4,45,5],[49,4,49,5],[50,4,50,5],[51,4,51,5],[52,4,52,5]]}
[]
[null,"STATE OF SOUTH CAROLINA"]
[null,"CONTRIBUTIONS RECEIVABLES AND DEFERRED REVENUE"]
[null,"SUMMARY FORM"]
[null,null,null,null,null,null,null,null,null,null,null,"AT JUNE 30,",{"$f":"IF('3.03.1'!J4=\"\",\"\",'3.03.1'!J4)","v":2019}]
[]
[]
[null,null,"Agency:",null,{"$f":"+'3.03.1'!C7","v":"E120"},null,null,{"$f":"+'Signature 1'!E6","v":"COMPTROLLER GENERAL'S OFFICE\n"}]
[null,null,null,null,"Business Area",null,null,null,null,null,null,null,"Name"]
[]
[null,null,"Preparer:",null,"Employee ABC",null,null,null,null,null,null,null,"Reviewer:","Supervisor XYZ"]
[null,null,null,null,null,"Typed Name",null,null,null,null,null,null,null,null,null,null,"Typed Name"]
[]
[null,null,null,null,null,null,null,null,"Receivable Balances"]
[null,null,"Fund No",null,"Revenue GL Account",null,null,null,"Total",null,null,null,"Current",null,null,"Non-Current",null,null,null,null,"Deferred Revenue"]
[]
[null,null,"Operating Contributions"]
[]
[null,null,30350000,null,4235800000,null,null,"$",100000,null,null,"$",100000,null,null,"$",{"$f":"IF(I19<0,\"Error - No current should be reported\",I19-M19)","v":0},null,null,"$"]
[null,null,null,null,null,null,null,"$",null,null,null,"$",null,null,null,"$",0,null,null,"$"]
[null,null,null,null,null,null,null,"$",null,null,null,"$",null,null,null,"$",0,null,null,"$"]
[null,null,null,null,null,null,null,"$",null,null,null,"$",null,null,null,"$",0,null,null,"$"]
[null,null,null,null,null,null,null,"$",null,null,null,"$",null,null,null,"$",0,null,null,"$"]
[null,null,null,null,null,null,null,"$",null,null,null,"$",null,null,null,"$",0,null,null,"$"]
[null,null,null,null,null,null,null,"$",null,null,null,"$",null,null,null,"$",0,null,null,"$"]
[null,null,null,null,null,null,null,"$",null,null,null,"$",null,null,null,"$",0,null,null,"$"]
[null,null,null,null,null,null,null,"$",null,null,null,"$",null,null,null,"$",0,null,null,"$"]
[null,null,null,null,null,null,null,"$",null,null,null,"$",null,null,null,"$",0,null,null,"$"]
[null,null,null,null,null,null,null,"$",null,null,null,"$",null,null,null,"$",0,null,null,"$"]
[null,null,null,null,null,null,null,"$",null,null,null,"$",null,null,null,"$",0,null,null,"$"]
[null,null,null,null,null,null,null,"$",null,null,null,"$",null,null,null,"$",0,null,null,"$"]
[null,null,null,null,null,null,null,"$",null,null,null,"$",null,null,null,"$",0,null,null,"$"]
[null,null,null,null,null,null,null,"$",null,null,null,"$",null,null,null,"$",0,null,null,"$"]
[]
[null,null,"Capital Contributions"]
[]
[null,null,null,null,null,null,null,"$",null,null,null,"$",null,null,null,"$",{"$f":"IF(I37<0,\"Error - No current should be reported\",I37-M37)","v":0},null,null,"$"]
[null,null,null,null,null,null,null,"$",null,null,null,"$",null,null,null,"$",0,null,null,"$"]
[null,null,null,null,null,null,null,"$",null,null,null,"$",null,null,null,"$",0,null,null,"$"]
[null,null,null,null,null,null,null,"$",null,null,null,"$",null,null,null,"$",0,null,null,"$"]
[null,null,null,null,null,null,null,"$",null,null,null,"$",null,null,null,"$",0,null,null,"$"]
[null,null,null,null,null,null,null,"$",null,null,null,"$",null,null,null,"$",0,null,null,"$"]
[null,null,null,null,null,null,null,"$",null,null,null,"$",null,null,null,"$",0,null,null,"$"]
[null,null,null,null,null,null,null,"$",null,null,null,"$",null,null,null,"$",0,null,null,"$"]
[null,null,null,null,null,null,null,"$",null,null,null,"$",null,null,null,"$",0,null,null,"$"]
[null,null,null,null,null,null,null,"$",null,null,null,"$",null,null,null,"$",0,null,null,"$"]
[]
[null,null,"Unrestricted Contributions"]
[]
[null,null,null,null,null,null,null,"$",null,null,null,"$",null,null,null,"$",{"$f":"IF(I50<0,\"Error - No current should be reported\",I50-M50)","v":0},null,null,"$"]
[null,null,null,null,null,null,null,"$",null,null,null,"$",null,null,null,"$",0,null,null,"$"]
[null,null,null,null,null,null,null,"$",null,null,null,"$",null,null,null,"$",0,null,null,"$"]
[null,null,null,null,null,null,null,"$",null,null,null,"$",null,null,null,"$",0,null,null,"$"]
[null,null,null,null,null,null,null,"$",null,null,null,"$",null,null,null,"$",0,null,null,"$"]
[null,null,null,null,null,null,null,"$",null,null,null,"$",null,null,null,"$",0,null,null,"$"]
[null,null,null,null,null,null,null,"$",null,null,null,"$",null,null,null,"$",0,null,null,"$"]
[null,null,null,null,null,null,null,"$",null,null,null,"$",null,null,null,"$",0,null,null,"$"]
[null,null,null,null,null,null,null,"$",null,null,null,"$",null,null,null,"$",0,null,null,"$"]
[null,null,null,null,null,null,null,"$",null,null,null,"$",null,null,null,"$",0,null,null,"$"]

{"sheet":"3.03.4","index":5,"n_rows":95,"n_cols":11,"rows_kept":95,"cut":false,"hidden":false,"merged":[]}
["STATE OF SOUTH CAROLINA"]
["GRANTS AND CONTRIBUTION REVENUES REPORTING PACKAGE"]
["REVIEWER CHECKLIST"]
[null,null,null,null,null,"FISCAL YEAR",{"$f":"IF('3.03.1'!J4=\"\",IF('3.03.3'!M5=\"\",\"\",'3.03.3'!M5),'3.03.1'!J4)","v":2019}]
[]
["Agency:",null,{"$f":"+'3.03.1'!C7","v":"E120"}]
[]
[null,null,null,null,"Date Last Review Step Was Completed:   ","2019-09-09"]
[]
[]
["Reviewer's Responses:"]
[{"$f":"COUNT(A$11:A11)+1","v":1},"Is the reviewer of the form someone other than the person who prepared it?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$11:A13)+1","v":2},"Can all amounts reported on each form be traced to official agency accounting "]
[null,"records?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$11:A14)+1","v":3},"Is the information provided at a detailed level by sponsor grant award number?  ",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$11:A18)+1","v":4},"Has information been reconciled to the report provided by the Comptroller "]
[null,"General's Office?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$11:A21)+1","v":5},"Have all reconciling differences between the accounting records, periodic reports  "]
[null,"to the grantor, and the analysis and summarization for this reporting purpose been "]
[null,"resolved and corrected?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$11:A22)+1","v":6},"Do the completed forms accurately reflect the agency’s position as of June 30 "]
[null,"for grants?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$11:A26)+1","v":7},"Has the activity been compared with the prior year, documenting causes for "]
[null,"any large fluctuations that can be easily obtained and explained to individuals  "]
[null,"not familiar with the daily operations of the agency?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$11:A30)+1","v":8},"Has an accounting of all funds in which grant revenue is reported been performed "]
[null,"to ensure all are reported on Form 3.03.2? ",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$11:A35)+1","v":9},"Are all grant awards reported for each accounting fund?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$11:A37)+1","v":10},"Does the analysis and information on Form 3.03.1 include only grant revenues?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$11:A39)+1","v":11},"Have all Federal grant awards been evaluated using the eligibility requirements?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$11:A41)+1","v":12},"Have all applicable eligibility requirements been met for grant awards for which a "]
[null,"receivable has been reported?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$11:A44)+1","v":13},"Does the beginning fund balance as reported on 3.03.1 match the ending"]
[null,"balances in the prior year submitted packet?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$11:A47)+1","v":14},"Have all reportable accounts payable transactions been reflected for the current "]
[null,"fiscal year?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$11:A50)+1","v":15},"Are the Other Accrual Adjustments reported appropriate based on the underlying"]
[null,"transactions as it relates to the grant award?",null,null,null,null,null,null,null,null,"N/A"]
[]
[{"$f":"COUNT(A$11:A53)+1","v":16},"Are the Other Accrual Adjustments reported explained at the bottom of each form?",null,null,null,null,null,null,null,null,"N/A"]
[]
[18,"Are amounts received after June 30 for expenditures incurred before June 30 "]
[null,"included as receivables?",null,null,null,null,null,null,null,null,"Yes"]
[]
[19,"Have all fund balances for grants with an ending fund balance AND no current year"]
[null,"activity been explained in the box listed below on 3.03.1?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$11:A61)+1","v":19},"Are amounts due from grantors for accounts payable and accrued liabilities "]
[null,"included as receivables?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$11:A64)+1","v":20},"Do all reported receivables exclude payroll expenditures incurred in June"]
[null,"but not paid until July?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$11:A67)+1","v":21},"Have amounts received or expected to be received within the next fiscal"]
[null,"year been reported as current receivables?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$11:A70)+1","v":22},"Is your agency the end recipient within State government for the grants "]
[null,"awards reported?  Likewise are all of the grant awards reported the activity "]
[null,"as the end recipient within your agency?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$11:A74)+1","v":23},"Are all reported Medicaid receivables due directly from the Federal government "]
[null,"(i.e., not payable to your agency from other State agencies under fee for service"]
[null,"contracts)?",null,null,null,null,null,null,null,null,"N/A"]
[]
[{"$f":"COUNT(A$11:A75)+1","v":24},"Is a receivable and deferred revenue reported in a fund only when it occurs "]
[null,"as a result of activity from multiple grant awards being recorded in the same "]
[null,"accounting fund?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$11:A82)+1","v":25},"Are all funds receiving and reporting contributions included on Form 3.03.3?  ",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$11:A84)+1","v":26},"Have amounts received or expected to be received within the next fiscal "]
[null,"year for contributions receivable been reported as current receivables?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$11:A87)+1","v":27},"Has the agency refrained from reporting a negative non-current receivable?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$11:A89)+1","v":28},"Has the agency refrained from reporting a contributions receivable and deferred "]
[null,"revenue from contributions in a fund with the same revenue offset?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$11:A92)+1","v":29},"If you had any outstanding pledges at June 30 that were not recorded as revenue "]
[null,"because they were not measurable at June 30, did you attach a description of the "]
[null,"situation to the packet?",null,null,null,null,null,null,null,null,"N/A"]