{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Instructions","Signature Page","3.12.1 ","3.12.1 (2)","Reviewer Checklist","Package Response","Package Response (2)","Journal Entry","Journal Entry (2)","Lookup Tables","x3.12.1 ","x3.12.1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":7,"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":98,"n_cols":10,"rows_kept":98,"cut":false,"hidden":false,"merged":[[94,8,94,10],[33,0,33,10],[37,8,37,10],[0,0,0,10],[2,0,2,10],[1,0,1,10],[3,0,3,10]]}
["State of South Carolina"]
["Section 3.12, Accounts Payable Reporting Package"]
["Year-End Reporting Instructions"]
["Fiscal Year 2019"]
[]
["Purpose and Objective:"]
["Generally Accepted Accounting Principles (GAAP) require the State to report accruals of liabilities.  The form(s)"]
["in this reporting package focus on accounts payable, accrued expenses (non-payroll related), and contracts retentions. "]
[]
["Refer to the Reporting Procedures Manual Part III Section _.12 for further guidance regarding the amounts to be"]
["reported in this reporting package.  "]
[]
["If questions arise that can not be answered by the Reporting Policies and Procedures Manual, please contact"]
["the Financial Reporting Division of the Comptroller General's Office."]
[]
["Key Term:"]
["Interfund Payable: Amounts due to other entities within the State's Reporting entity or other funds within your agency. "]
["See Appendix D of the Reporting Policies and Procedures Manual for a list of entities within the State's reporting "]
["entity."]
[]
["Instructions for Completion of the Form(s):"]
["Use the macro button to create as many copies of the form(s) as is required."]
["Enter the information requested by the descriptions of each field."]
["●   Features within the forms to assist in completion include:"]
["►    Validation checks for the appropriate number of characters is included for the fund number. "]
["►    Dollar amounts requested are restricted by edit checks for whole numbers."]
["Upon completion of the information requested:"]
["●   The individual completing the form(s) should review the form(s) for accuracy and completeness prior to "]
["signing the signature page.  "]
["●   The Finance Director or Executive Director should review and approve the form(s) before signing the signature"]
["page and sending the form(s) to the Comptroller General's Office."]
["●   Both the preparer and reviewer certify that the information provided on this reporting package is complete and"]
["accurate to the best of their knowledge."]
["   ●   Send the Excel file to the Comptroller General's Office (CAFR@cg.sc.gov) no later than September 13, 2019"]
["●   The agency should retain a copy of the completed form(s) as part of its year-end working papers.  The"]
["Comptroller General's Office will contact the individual completing the form if there are any questions."]
[]
["Signature Page",null,null,null,null,null,null,null,"Signature Page"]
["This form should be completed, printed, signed and a PDF copy of the signed sheet sent via e-mail to the "]
["Comptroller General's office when the Excel file of the related reporting package is sent."]
[]
["Accounts Payable Summary Form",null,null,null,null,null,null,null,null,"3.12.1"]
["Use this form to report accounts payable, accrued expenses, and contract retentions identified in each fund."]
["●   This package is needed to collect the information on payables (amounts related to goods or services received"]
["prior to June 30 that were not paid with that year’s funds). A/P processing continues past June 30 so a "]
["payable does not exist if amounts due as of June 30 were paid with that year’s funds i.e. paid during extended "]
["period 12 or period 13."]
["►    ",null,"Report payables due to outside entities"]
["►    ",null,"Report interfund payables individually under $100,000"]
["►    ",null,"Do not report interfund payables individually over $100,000 on this package, they should be reported on the"]
[null,null,"interfund package (3.18). Please submit a revised package 3.18 if it did not include all interfund payables "]
[null,null,"individually over $100,000."]
["●   The GAAP contact(s) for your agency will receive two Prior Year Payables reports for this reporting package. "]
["The reports are based on the use of “PRIOR YEAR PAYABLE” in the header text of the transaction when "]
["processing  invoices for payment through SCEIS.  In early September a report will be sent showing payments "]
["made in July and August (periods 1 and 2) and a second report will be sent a few days before this package is due "]
["showing payments made in until the report is created in September (period 3-to-date). The reports provided are "]
["just one tool suggested in the Reporting Policies and Procedures Manual that agencies can use to determine actual "]
["accounts payable. Agencies are no longer required to reconcile actual accounts payable to the reports provided. "]
["●   The Prior Year Payables reports provided for this reporting package are separate from the Inter-Agency Prior Year"]
["Payables report that is provided for package 3.18 (Interfund Payables) but interfund payables individually under "]
["$100,000 are reported on 3.12 and interfund payables individually over $100,000 are reported on 3.18 regardless "]
["of which report they appear or if they don't appear on any report. Actual payables should be reported on this"]
["closing package regardless of what appears on the Prior Year Payables reports."]
["●   College and university payables are considered interfund payables but are processed in SCEIS in the same manner "]
["as outside entities and will appear on the reports provided for this package. Like other interfund payables, college "]
["and university payables individually over $100,000 should not be reported on this package but payables"]
["individually under $100,000 should be included in the totals on this package. Interfund payables individually over "]
["$100,000 should be reported on the interfund package (3.18)."]
["●    Agencies may decide to not report liabilities if 12 months of expenditures have already been recorded in the "]
["current year for recurring items that have been in existence.  Some agencies may choose to follow GAAP "]
["accounting and accrue the full liability but this exception has traditionally been available to agencies."]
["●    Invoices individually under $100,000 with less than 50% related to prior year may be excluded from this package."]
["For invoices exceeding $100,000, the calculation is required based on service dates."]
["●   Do not report any payroll related liabilities on this package. "]
["●   Separate the payables into the following categories.  A classification threshold of $10,000 may be used.  "]
["This classification threshold allows agencies to classify any payable individually under $10,000 as a vendor "]
["payable. All payables need to be reported but only those payables individually over $10,000 must be separated"]
["into the other categories."]
["►    ",null,"Vendor Payables - regular expenditures for which invoices or direct payment is processed."]
["Note: If the classification threshold is used, the vendor payables category will also include all payables"]
["individually under $10,000."]
["►    ",null,"Aid to Individuals Payables - amounts owed to service recipients, typically arising from client services "]
[null,null,"expense or similar expenses."]
["►    ",null,"Sales or Use Tax Payables - sales or use tax amounts related to regular expenditures."]
["►    ",null,"Accrued Expenses - purchases/services for which amounts owed require estimation."]
["►    ",null,"Intergovernmental Payables - amounts owed to other governmental entities outside the State’s financial"]
[null,null,"reporting entity."]
["►    ",null,"Contract Retentions Current - payments on contracts which will be paid within the subsequent fiscal year."]
["►    ",null,"Contract Retentions Non-current - payments on contracts which will be paid more than twelve months"]
[null,null,"after the end of the year. "]
["►    ",null,"Other Current Liabilities - any remaining amounts owed."]
["The amounts entered on this package should be the amounts to be reported in the CAFR for your agency."]
[]
["Reviewer's Checklist",null,null,null,null,null,null,null,"Reviewer Checklist"]
["Use this Checklist as a mechanism for review.  It should be completed prior to reviewer's signature on the signature "]
["page. Upon completion of the checklist, include the responses in the submitted Excel file and retain a copy in the "]
["accounting records of the agency as documentation of the control procedure."]

{"sheet":"Signature Page","index":1,"n_rows":64,"n_cols":7,"rows_kept":64,"cut":false,"hidden":false,"merged":[[3,1,3,6],[2,1,2,6],[1,1,1,6],[0,1,0,6],[29,4,29,5],[5,4,5,5],[6,4,6,5],[19,4,19,5],[21,4,21,5],[23,4,23,5],[25,4,25,5],[27,4,27,5],[9,4,9,5],[11,4,11,5],[13,4,13,5],[15,4,15,5],[17,4,17,5],[52,1,52,5],[53,1,53,5],[54,1,54,5],[55,1,55,5],[31,4,31,5],[63,1,63,5],[35,1,35,5],[57,1,57,5],[58,1,58,5],[59,1,59,5],[60,1,60,5],[61,1,61,5],[62,1,62,5],[56,1,56,5],[41,1,41,5],[43,1,43,5],[45,1,45,5],[47,1,47,5],[49,1,49,5],[50,1,50,5],[51,1,51,5]]}
[null,"State of South Carolina"]
[null,"Section 3.12, Accounts Payable Reporting Package"]
[null,"Signature Page"]
[null,"Fiscal Year 2019"]
[]
[null,null,"S001",null,{"$f":"IF(C6=\"\",\"\",VLOOKUP($C$6,'Lookup Tables'!$A$1:$B$81,2,FALSE))","v":"Sample Agency"}]
[null,null,"Agency",null,"Agency Name"]
[]
[]
[null,null,"Preparer","Signature:",null,null," "]
[]
[null,null,null,"Date:","2019-09-13",null," "]
[]
[null,null,null,"Name:","Sample Preparer",null," "]
[]
[null,null,null,"Title:","Accountant",null," "]
[]
[null,null,null,"e-mail:","spreparer@sampl.sc.gov",null," "]
[]
[null,null,null,"Phone Number:","(803) 123-4567",null," "]
[]
[null,null,"Reviewer","Signature:",null,null," "]
[]
[null,null,null,"Date:","2019-09-13"]
[]
[null,null,null,"Name:","Sample Reviewer"]
[]
[null,null,null,"Title:","Manager",null," "]
[null,null,null,null,null,null," "]
[null,null,null,"e-mail:","sreviewer@sample.sc.gov",null," "]
[null,null,null,null,null,null," "]
[null,null,null,"Phone Number:","(803) 765-4321",null," "]
[]
[null,null,"Signatures are an assertion of the accuracy and completeness of the information reported.  "]
[]
[null,"Note: This is the ONLY tab from packet 3.12 that is to be submitted in pdf format, all others are submitted via excel format."]
[]
["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 reviewer:"]
[]
[null,"I acknowledge and have fulfilled the responsibility for implementation and maintenance of internal control relevant to the preparation \nand fair presentation of 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,"Special and extraordinary items have been appropriately classified and reported."]
[]
[null,"The effects of all known actual or possible litigation, claims, and assessments have been accounted for and disclosed in accordance with U.S. GAAP."]
[]
[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,"The agency has no material amounts of obsolete, damaged, or unusable items included in the inventories at greater than salvage values."]
[]
[null,"The agency has no transfers, reservations or designations of fund equity or interfund borrowings that were not properly authorized and approved, or uncollectible interfund loans that have not been properly reflected in the reporting packets or disclosed to you."]
[]
[null,"Receivables recorded in the reporting packets represent valid claims against debtors for transactions arising on or before the financial statement date and appropriate provisions for uncollectible receivables have been properly identified and recorded."]
[]
[null,"Capital assets have been evaluated for impairment as a result of significant and unexpected decline in service utility. Impairment loss and insurance recoveries have been properly recorded."]
[]
[null,"I am not aware of any intangible assets which would require an adjustment to or disclosure in the financial statements in accordance with GASB 51, Accounting and Reporting for Intangible Assets, except as already reported."]

{"sheet":"3.12.1 ","index":2,"n_rows":40,"n_cols":26,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,26],[1,0,1,26],[2,0,2,26],[3,0,3,26],[13,4,13,22],[6,7,6,25],[7,5,7,22],[9,5,9,10],[9,16,9,21],[12,1,12,25]]}
["State of South Carolina"]
["Section 3.12, Accounts Payable Reporting Package"]
["Accounts Payable Summary Form"]
["At June 30, 2019"]
[]
[]
[null,null,"Agency:",null,{"$f":"'Signature Page'!C6","v":"S001"},null,null,{"$f":"VLOOKUP(AgencyCode,'Lookup Tables'!A:B,2,FALSE)","v":"Sample Agency"}]
[null,null,null,null,null,"Agency Name"]
[]
[null,"Preparer (Type Name):",null,null,null,"Sample Preparer",null,null,null,null,null,null,null,"Reviewer (Type Name):",null,null,"Sample Reviewer"]
[]
[]
[null,"The reports provided are based on the header text of current year expenditures. Actual payables should be reported on this form regardless of what appears on the reports."]
[null,null,null,null,"Dollar Amount in each Category"]
[null,"Fund",null,null,"Vendor",null,null,"Aid to ",null,null,"Sales or Use ",null,null,"Accrued ",null,null,"Intergovernmental",null,null,"Contract ",null,null,"Contract ",null,null,"Other Current "]
[null,"Number",null,null,"Payables",null,null,"Individuals ",null,null,"Tax Payables",null,null,"Expenses",null,null,"Payables",null,null,"Retentions",null,null,"Retentions",null,null,"Liabilities "]
[null,null,null,null,null,null,null,"Payables",null,null,null,null,null,null,null,null,null,null,null,"Current",null,null,"Non-current"]
[]
[null,10010000,null,"$",2500,null,"$",null,null,"$",null,null,"$",null,null,"$",15000,null,"$",null,null,"$",null,null,"$"]
[null,30350000,null,"$",1000,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[]
[null,null,null,null,null,null,null,null,null,"Total (This Page)",{"$f":"SUM(E19:E38)+SUM(H19:H38)+SUM(K19:K38)+SUM(N19:N38)+SUM(Q19:Q38)+SUM(T19:T38)+SUM(W19:W38)+SUM(Z19:Z38)","v":18500},null,null,null,null,null,null,null,"Package Total",{"$f":"K40+'3.12.1 (2)'!K40","v":18500}]

{"sheet":"3.12.1 (2)","index":3,"n_rows":42,"n_cols":26,"rows_kept":42,"cut":false,"hidden":false,"merged":[[0,0,0,26],[1,0,1,26],[2,0,2,26],[3,0,3,26],[13,4,13,22],[6,7,6,25],[7,5,7,22],[9,5,9,10],[9,16,9,21]]}
["State of South Carolina"]
["Section 3.12, Accounts Payable Reporting Package"]
["Accounts Payable Summary Form"]
["At June 30, 2019"]
[]
[]
[null,null,"Agency:",null,{"$f":"IF('3.12.1 '!E7=\"\",\"\",'3.12.1 '!E7)","v":"S001"},null,null,{"$f":"IF('3.12.1 '!H7:Z7=\"\",\"\",'3.12.1 '!H7:Z7)","v":"Sample Agency"}]
[null,null,null,null,null,"Agency Name"]
[]
[null,"Preparer (Type Name):",null,null,null,{"$f":"IF(PREPARER=\"\",\"\",PREPARER)","v":"Sample Preparer"},null,null,null,null,null,null,null,"Reviewer (Type Name):",null,null,{"$f":"IF(REVIEWER=\"\",\"\",REVIEWER)","v":"Sample Reviewer"}]
[]
[]
[]
[null,null,null,null,"Dollar Amount in each Category"]
[null,"Fund",null,null,"Vendor",null,null,"Aid to ",null,null,"Sales or Use ",null,null,"Accrued ",null,null,"Intergovernmental",null,null,"Contract ",null,null,"Contract ",null,null,"Other Current "]
[null,"Number",null,null,"Payables",null,null,"Individuals ",null,null,"Tax Payables",null,null,"Expenses",null,null,"Payables",null,null,"Retentions",null,null,"Retentions",null,null,"Liabilities "]
[null,null,null,null,null,null,null,"Payables",null,null,null,null,null,null,null,null,null,null,null,"Current",null,null,"Non-current"]
[]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[null,null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$",null,null,"$"]
[]
[null,null,null,null,null,null,null,null,null,"Total (This Page)",{"$f":"SUM(E19:E38)+SUM(H19:H38)+SUM(K19:K38)+SUM(N19:N38)+SUM(Q19:Q38)+SUM(T19:T38)+SUM(W19:W38)+SUM(Z19:Z38)","v":0}]
[]
["NOTE:  If additional space is needed, please contact the CG's Office."]

{"sheet":"Reviewer Checklist","index":4,"n_rows":41,"n_cols":11,"rows_kept":41,"cut":false,"hidden":false,"merged":[[1,0,1,11],[3,0,3,11],[2,0,2,11],[0,0,0,11]]}
["State of South Carolina"]
["Section 3.12, Accounts Payable Reporting Package"]
["Reviewer Checklist"]
["Fiscal Year 2019"]
[]
[null,"Business Area",null,{"$f":"IF(AgencyCode=\"\",\"\",AgencyCode)","v":"S001"},null,null,null,null,"Date Last Review Step Was Completed:   ","2019-09-13"]
[]
[]
["Reviewer's Responses:"]
[{"$f":"COUNT(A$9:A9)+1","v":1},"Is the reviewer of the form(s) someone other than the person who prepared it?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$9:A11)+1","v":2},"Is contact information (i.e. title, email, and telephone number) for the preparer "]
[null,"and reviewer accurately reported on the signature page?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$9:A14)+1","v":3},"Can all amounts reported on each form be traced to official agency "]
[null,"accounting records?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$9:A17)+1","v":4},"Were transactions processed between June 30 and the date of this review "]
[null,"examined for proper period recognition?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$9:A20)+1","v":5},"Were control procedures such as a review of a sample of transactions performed"]
[null,"as part of this review?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$9:A23)+1","v":6},"Have all relationships with the agency been considered for potential accrual "]
[null,"transactions?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$9:A26)+1","v":7},"Were interfund payables individually over $100,000 reported on package 3.18 "]
[null,"and excluded from this package?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$9:A29)+1","v":8},"Were payroll and payroll related items excluded from amounts reported?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$9:A31)+1","v":9},"Were Claims Payable that are required to be reported on the Claims "]
[null,"Reporting Package excluded from the amounts reported?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$9:A34)+1","v":10},"Do all estimates, if any, appear to be reasonable and valid?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$9:A36)+1","v":11},"Is the fund number accurately reported?",null,null,null,null,null,null,null,null,"Yes"]
[]
[{"$f":"COUNT(A$9:A38)+1","v":12},"Has the activity been compared with the prior year, documenting causes "]
[null,"for any large fluctuations that can be easily obtained and explained to "]
[null,"individuals not familiar with the daily operations of the agency?",null,null,null,null,null,null,null,null,"Yes"]

{"sheet":"Package Response","index":5,"n_rows":24,"n_cols":16,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,2010000000,2010150000,2010010000,2010030000,2010120000,2010070000,2050030000,2400130000]
["Line","Agency Code","LOOKUP\nBusiness Area","LOOKUP\nAgency Name","LOOKUP\nExpense G/L","Fund \nNumber","Vendor \nPayables","Aid","Sales/Use","Accrued\nExpenses ","Intergov","Contract\nCurrent","Contract\nNon-current","Other","GAAP Individual Code","Agency Total"]
[1,{"$f":"AgencyCode","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:C,3,FALSE)","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:B,2,FALSE)","v":"Sample Agency"},{"$f":"VLOOKUP(C:C,'Lookup Tables'!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'3.12.1 '!B19","v":10010000},{"$f":"'3.12.1 '!E19","v":2500},{"$f":"'3.12.1 '!H19","v":0},{"$f":"'3.12.1 '!K19","v":0},{"$f":"'3.12.1 '!N19","v":0},{"$f":"'3.12.1 '!Q19","v":15000},{"$f":"'3.12.1 '!T19","v":0},{"$f":"'3.12.1 '!W19","v":0},{"$f":"'3.12.1 '!Z19","v":0},null,{"$f":"SUM(G3:N3)","v":17500}]
[2,"S001",{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:C,3,FALSE)","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:B,2,FALSE)","v":"Sample Agency"},{"$f":"VLOOKUP(C:C,'Lookup Tables'!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'3.12.1 '!B20","v":30350000},{"$f":"'3.12.1 '!E20","v":1000},{"$f":"'3.12.1 '!H20","v":0},{"$f":"'3.12.1 '!K20","v":0},{"$f":"'3.12.1 '!N20","v":0},{"$f":"'3.12.1 '!Q20","v":0},{"$f":"'3.12.1 '!T20","v":0},{"$f":"'3.12.1 '!W20","v":0},{"$f":"'3.12.1 '!Z20","v":0},null,{"$f":"SUM(G4:N4)","v":1000}]
[3,"S001",{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:C,3,FALSE)","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:B,2,FALSE)","v":"Sample Agency"},{"$f":"VLOOKUP(C:C,'Lookup Tables'!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'3.12.1 '!B21","v":0},{"$f":"'3.12.1 '!E21","v":0},{"$f":"'3.12.1 '!H21","v":0},{"$f":"'3.12.1 '!K21","v":0},{"$f":"'3.12.1 '!N21","v":0},{"$f":"'3.12.1 '!Q21","v":0},{"$f":"'3.12.1 '!T21","v":0},{"$f":"'3.12.1 '!W21","v":0},{"$f":"'3.12.1 '!Z21","v":0},null,0]
[4,"S001",{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:C,3,FALSE)","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:B,2,FALSE)","v":"Sample Agency"},{"$f":"VLOOKUP(C:C,'Lookup Tables'!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'3.12.1 '!B22","v":0},{"$f":"'3.12.1 '!E22","v":0},{"$f":"'3.12.1 '!H22","v":0},{"$f":"'3.12.1 '!K22","v":0},{"$f":"'3.12.1 '!N22","v":0},{"$f":"'3.12.1 '!Q22","v":0},{"$f":"'3.12.1 '!T22","v":0},{"$f":"'3.12.1 '!W22","v":0},{"$f":"'3.12.1 '!Z22","v":0},null,0]
[5,"S001",{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:C,3,FALSE)","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:B,2,FALSE)","v":"Sample Agency"},{"$f":"VLOOKUP(C:C,'Lookup Tables'!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'3.12.1 '!B23","v":0},{"$f":"'3.12.1 '!E23","v":0},{"$f":"'3.12.1 '!H23","v":0},{"$f":"'3.12.1 '!K23","v":0},{"$f":"'3.12.1 '!N23","v":0},{"$f":"'3.12.1 '!Q23","v":0},{"$f":"'3.12.1 '!T23","v":0},{"$f":"'3.12.1 '!W23","v":0},{"$f":"'3.12.1 '!Z23","v":0},null,0]
[6,"S001",{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:C,3,FALSE)","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:B,2,FALSE)","v":"Sample Agency"},{"$f":"VLOOKUP(C:C,'Lookup Tables'!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'3.12.1 '!B24","v":0},{"$f":"'3.12.1 '!E24","v":0},{"$f":"'3.12.1 '!H24","v":0},{"$f":"'3.12.1 '!K24","v":0},{"$f":"'3.12.1 '!N24","v":0},{"$f":"'3.12.1 '!Q24","v":0},{"$f":"'3.12.1 '!T24","v":0},{"$f":"'3.12.1 '!W24","v":0},{"$f":"'3.12.1 '!Z24","v":0},null,0]
[7,"S001",{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:C,3,FALSE)","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:B,2,FALSE)","v":"Sample Agency"},{"$f":"VLOOKUP(C:C,'Lookup Tables'!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'3.12.1 '!B25","v":0},{"$f":"'3.12.1 '!E25","v":0},{"$f":"'3.12.1 '!H25","v":0},{"$f":"'3.12.1 '!K25","v":0},{"$f":"'3.12.1 '!N25","v":0},{"$f":"'3.12.1 '!Q25","v":0},{"$f":"'3.12.1 '!T25","v":0},{"$f":"'3.12.1 '!W25","v":0},{"$f":"'3.12.1 '!Z25","v":0},null,0]
[8,"S001",{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:C,3,FALSE)","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:B,2,FALSE)","v":"Sample Agency"},{"$f":"VLOOKUP(C:C,'Lookup Tables'!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'3.12.1 '!B26","v":0},{"$f":"'3.12.1 '!E26","v":0},{"$f":"'3.12.1 '!H26","v":0},{"$f":"'3.12.1 '!K26","v":0},{"$f":"'3.12.1 '!N26","v":0},{"$f":"'3.12.1 '!Q26","v":0},{"$f":"'3.12.1 '!T26","v":0},{"$f":"'3.12.1 '!W26","v":0},{"$f":"'3.12.1 '!Z26","v":0},null,0]
[9,"S001",{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:C,3,FALSE)","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:B,2,FALSE)","v":"Sample Agency"},{"$f":"VLOOKUP(C:C,'Lookup Tables'!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'3.12.1 '!B27","v":0},{"$f":"'3.12.1 '!E27","v":0},{"$f":"'3.12.1 '!H27","v":0},{"$f":"'3.12.1 '!K27","v":0},{"$f":"'3.12.1 '!N27","v":0},{"$f":"'3.12.1 '!Q27","v":0},{"$f":"'3.12.1 '!T27","v":0},{"$f":"'3.12.1 '!W27","v":0},{"$f":"'3.12.1 '!Z27","v":0},null,0]
[10,"S001",{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:C,3,FALSE)","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:B,2,FALSE)","v":"Sample Agency"},{"$f":"VLOOKUP(C:C,'Lookup Tables'!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'3.12.1 '!B28","v":0},{"$f":"'3.12.1 '!E28","v":0},{"$f":"'3.12.1 '!H28","v":0},{"$f":"'3.12.1 '!K28","v":0},{"$f":"'3.12.1 '!N28","v":0},{"$f":"'3.12.1 '!Q28","v":0},{"$f":"'3.12.1 '!T28","v":0},{"$f":"'3.12.1 '!W28","v":0},{"$f":"'3.12.1 '!Z28","v":0},null,0]
[11,"S001",{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:C,3,FALSE)","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:B,2,FALSE)","v":"Sample Agency"},{"$f":"VLOOKUP(C:C,'Lookup Tables'!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'3.12.1 '!B29","v":0},{"$f":"'3.12.1 '!E29","v":0},{"$f":"'3.12.1 '!H29","v":0},{"$f":"'3.12.1 '!K29","v":0},{"$f":"'3.12.1 '!N29","v":0},{"$f":"'3.12.1 '!Q29","v":0},{"$f":"'3.12.1 '!T29","v":0},{"$f":"'3.12.1 '!W29","v":0},{"$f":"'3.12.1 '!Z29","v":0},null,0]
[12,"S001",{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:C,3,FALSE)","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:B,2,FALSE)","v":"Sample Agency"},{"$f":"VLOOKUP(C:C,'Lookup Tables'!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'3.12.1 '!B30","v":0},{"$f":"'3.12.1 '!E30","v":0},{"$f":"'3.12.1 '!H30","v":0},{"$f":"'3.12.1 '!K30","v":0},{"$f":"'3.12.1 '!N30","v":0},{"$f":"'3.12.1 '!Q30","v":0},{"$f":"'3.12.1 '!T30","v":0},{"$f":"'3.12.1 '!W30","v":0},{"$f":"'3.12.1 '!Z30","v":0},null,0]
[13,"S001",{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:C,3,FALSE)","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:B,2,FALSE)","v":"Sample Agency"},{"$f":"VLOOKUP(C:C,'Lookup Tables'!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'3.12.1 '!B31","v":0},{"$f":"'3.12.1 '!E31","v":0},{"$f":"'3.12.1 '!H31","v":0},{"$f":"'3.12.1 '!K31","v":0},{"$f":"'3.12.1 '!N31","v":0},{"$f":"'3.12.1 '!Q31","v":0},{"$f":"'3.12.1 '!T31","v":0},{"$f":"'3.12.1 '!W31","v":0},{"$f":"'3.12.1 '!Z31","v":0},null,0]
[14,"S001",{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:C,3,FALSE)","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:B,2,FALSE)","v":"Sample Agency"},{"$f":"VLOOKUP(C:C,'Lookup Tables'!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'3.12.1 '!B32","v":0},{"$f":"'3.12.1 '!E32","v":0},{"$f":"'3.12.1 '!H32","v":0},{"$f":"'3.12.1 '!K32","v":0},{"$f":"'3.12.1 '!N32","v":0},{"$f":"'3.12.1 '!Q32","v":0},{"$f":"'3.12.1 '!T32","v":0},{"$f":"'3.12.1 '!W32","v":0},{"$f":"'3.12.1 '!Z32","v":0},null,0]
[15,"S001",{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:C,3,FALSE)","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:B,2,FALSE)","v":"Sample Agency"},{"$f":"VLOOKUP(C:C,'Lookup Tables'!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'3.12.1 '!B33","v":0},{"$f":"'3.12.1 '!E33","v":0},{"$f":"'3.12.1 '!H33","v":0},{"$f":"'3.12.1 '!K33","v":0},{"$f":"'3.12.1 '!N33","v":0},{"$f":"'3.12.1 '!Q33","v":0},{"$f":"'3.12.1 '!T33","v":0},{"$f":"'3.12.1 '!W33","v":0},{"$f":"'3.12.1 '!Z33","v":0},null,0]
[16,"S001",{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:C,3,FALSE)","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:B,2,FALSE)","v":"Sample Agency"},{"$f":"VLOOKUP(C:C,'Lookup Tables'!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'3.12.1 '!B34","v":0},{"$f":"'3.12.1 '!E34","v":0},{"$f":"'3.12.1 '!H34","v":0},{"$f":"'3.12.1 '!K34","v":0},{"$f":"'3.12.1 '!N34","v":0},{"$f":"'3.12.1 '!Q34","v":0},{"$f":"'3.12.1 '!T34","v":0},{"$f":"'3.12.1 '!W34","v":0},{"$f":"'3.12.1 '!Z34","v":0},null,0]
[17,"S001",{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:C,3,FALSE)","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:B,2,FALSE)","v":"Sample Agency"},{"$f":"VLOOKUP(C:C,'Lookup Tables'!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'3.12.1 '!B35","v":0},{"$f":"'3.12.1 '!E35","v":0},{"$f":"'3.12.1 '!H35","v":0},{"$f":"'3.12.1 '!K35","v":0},{"$f":"'3.12.1 '!N35","v":0},{"$f":"'3.12.1 '!Q35","v":0},{"$f":"'3.12.1 '!T35","v":0},{"$f":"'3.12.1 '!W35","v":0},{"$f":"'3.12.1 '!Z35","v":0},null,0]
[18,"S001",{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:C,3,FALSE)","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:B,2,FALSE)","v":"Sample Agency"},{"$f":"VLOOKUP(C:C,'Lookup Tables'!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'3.12.1 '!B36","v":0},{"$f":"'3.12.1 '!E36","v":0},{"$f":"'3.12.1 '!H36","v":0},{"$f":"'3.12.1 '!K36","v":0},{"$f":"'3.12.1 '!N36","v":0},{"$f":"'3.12.1 '!Q36","v":0},{"$f":"'3.12.1 '!T36","v":0},{"$f":"'3.12.1 '!W36","v":0},{"$f":"'3.12.1 '!Z36","v":0},null,0]
[19,"S001",{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:C,3,FALSE)","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:B,2,FALSE)","v":"Sample Agency"},{"$f":"VLOOKUP(C:C,'Lookup Tables'!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'3.12.1 '!B37","v":0},{"$f":"'3.12.1 '!E37","v":0},{"$f":"'3.12.1 '!H37","v":0},{"$f":"'3.12.1 '!K37","v":0},{"$f":"'3.12.1 '!N37","v":0},{"$f":"'3.12.1 '!Q37","v":0},{"$f":"'3.12.1 '!T37","v":0},{"$f":"'3.12.1 '!W37","v":0},{"$f":"'3.12.1 '!Z37","v":0},null,0]
[20,"S001",{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:C,3,FALSE)","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:B,2,FALSE)","v":"Sample Agency"},{"$f":"VLOOKUP(C:C,'Lookup Tables'!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'3.12.1 '!B38","v":0},{"$f":"'3.12.1 '!E38","v":0},{"$f":"'3.12.1 '!H38","v":0},{"$f":"'3.12.1 '!K38","v":0},{"$f":"'3.12.1 '!N38","v":0},{"$f":"'3.12.1 '!Q38","v":0},{"$f":"'3.12.1 '!T38","v":0},{"$f":"'3.12.1 '!W38","v":0},{"$f":"'3.12.1 '!Z38","v":0},null,0]
[]
[null,null,null,null,null,null,{"$f":"SUM(G3:G23)","v":3500},0,0,0,15000,0,0,0,null,18500]

{"sheet":"Package Response (2)","index":6,"n_rows":24,"n_cols":16,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,2010000000,2010150000,2010010000,2010030000,2010120000,2010070000,2050030000,2400130000]
["Line","Agency Code","LOOKUP\nBusiness Area","LOOKUP\nAgency Name","LOOKUP\nExpense G/L","Fund \nNumber","Vendor \nPayables","Aid","Sales/Use","Accrued\nExpenses ","Intergov","Contract\nCurrent","Contract\nNon-current","Other","GAAP Individual Code","Agency Total"]
[21,{"$f":"AgencyCode","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:C,3,FALSE)","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:B,2,FALSE)","v":"Sample Agency"},{"$f":"VLOOKUP(C:C,'Lookup Tables'!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'3.12.1 '!B19","v":10010000},{"$f":"'3.12.1 (2)'!E19","v":0},{"$f":"'3.12.1 (2)'!H19","v":0},{"$f":"'3.12.1 (2)'!K19","v":0},{"$f":"'3.12.1 (2)'!N19","v":0},{"$f":"'3.12.1 (2)'!Q19","v":0},{"$f":"'3.12.1 (2)'!T19","v":0},{"$f":"'3.12.1 (2)'!W19","v":0},{"$f":"'3.12.1 (2)'!Z19","v":0},null,{"$f":"SUM(G3:N3)","v":0}]
[22,"S001",{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:C,3,FALSE)","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:B,2,FALSE)","v":"Sample Agency"},{"$f":"VLOOKUP(C:C,'Lookup Tables'!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'3.12.1 '!B20","v":30350000},{"$f":"'3.12.1 (2)'!E20","v":0},{"$f":"'3.12.1 (2)'!H20","v":0},{"$f":"'3.12.1 (2)'!K20","v":0},{"$f":"'3.12.1 (2)'!N20","v":0},{"$f":"'3.12.1 (2)'!Q20","v":0},{"$f":"'3.12.1 (2)'!T20","v":0},{"$f":"'3.12.1 (2)'!W20","v":0},{"$f":"'3.12.1 (2)'!Z20","v":0},null,{"$f":"SUM(G4:N4)","v":0}]
[23,"S001",{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:C,3,FALSE)","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:B,2,FALSE)","v":"Sample Agency"},{"$f":"VLOOKUP(C:C,'Lookup Tables'!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'3.12.1 '!B21","v":0},{"$f":"'3.12.1 (2)'!E21","v":0},{"$f":"'3.12.1 (2)'!H21","v":0},{"$f":"'3.12.1 (2)'!K21","v":0},{"$f":"'3.12.1 (2)'!N21","v":0},{"$f":"'3.12.1 (2)'!Q21","v":0},{"$f":"'3.12.1 (2)'!T21","v":0},{"$f":"'3.12.1 (2)'!W21","v":0},{"$f":"'3.12.1 (2)'!Z21","v":0},null,0]
[24,"S001",{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:C,3,FALSE)","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:B,2,FALSE)","v":"Sample Agency"},{"$f":"VLOOKUP(C:C,'Lookup Tables'!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'3.12.1 '!B22","v":0},{"$f":"'3.12.1 (2)'!E22","v":0},{"$f":"'3.12.1 (2)'!H22","v":0},{"$f":"'3.12.1 (2)'!K22","v":0},{"$f":"'3.12.1 (2)'!N22","v":0},{"$f":"'3.12.1 (2)'!Q22","v":0},{"$f":"'3.12.1 (2)'!T22","v":0},{"$f":"'3.12.1 (2)'!W22","v":0},{"$f":"'3.12.1 (2)'!Z22","v":0},null,0]
[25,"S001",{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:C,3,FALSE)","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:B,2,FALSE)","v":"Sample Agency"},{"$f":"VLOOKUP(C:C,'Lookup Tables'!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'3.12.1 '!B23","v":0},{"$f":"'3.12.1 (2)'!E23","v":0},{"$f":"'3.12.1 (2)'!H23","v":0},{"$f":"'3.12.1 (2)'!K23","v":0},{"$f":"'3.12.1 (2)'!N23","v":0},{"$f":"'3.12.1 (2)'!Q23","v":0},{"$f":"'3.12.1 (2)'!T23","v":0},{"$f":"'3.12.1 (2)'!W23","v":0},{"$f":"'3.12.1 (2)'!Z23","v":0},null,0]
[26,"S001",{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:C,3,FALSE)","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:B,2,FALSE)","v":"Sample Agency"},{"$f":"VLOOKUP(C:C,'Lookup Tables'!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'3.12.1 '!B24","v":0},{"$f":"'3.12.1 (2)'!E24","v":0},{"$f":"'3.12.1 (2)'!H24","v":0},{"$f":"'3.12.1 (2)'!K24","v":0},{"$f":"'3.12.1 (2)'!N24","v":0},{"$f":"'3.12.1 (2)'!Q24","v":0},{"$f":"'3.12.1 (2)'!T24","v":0},{"$f":"'3.12.1 (2)'!W24","v":0},{"$f":"'3.12.1 (2)'!Z24","v":0},null,0]
[27,"S001",{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:C,3,FALSE)","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:B,2,FALSE)","v":"Sample Agency"},{"$f":"VLOOKUP(C:C,'Lookup Tables'!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'3.12.1 '!B25","v":0},{"$f":"'3.12.1 (2)'!E25","v":0},{"$f":"'3.12.1 (2)'!H25","v":0},{"$f":"'3.12.1 (2)'!K25","v":0},{"$f":"'3.12.1 (2)'!N25","v":0},{"$f":"'3.12.1 (2)'!Q25","v":0},{"$f":"'3.12.1 (2)'!T25","v":0},{"$f":"'3.12.1 (2)'!W25","v":0},{"$f":"'3.12.1 (2)'!Z25","v":0},null,0]
[28,"S001",{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:C,3,FALSE)","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:B,2,FALSE)","v":"Sample Agency"},{"$f":"VLOOKUP(C:C,'Lookup Tables'!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'3.12.1 '!B26","v":0},{"$f":"'3.12.1 (2)'!E26","v":0},{"$f":"'3.12.1 (2)'!H26","v":0},{"$f":"'3.12.1 (2)'!K26","v":0},{"$f":"'3.12.1 (2)'!N26","v":0},{"$f":"'3.12.1 (2)'!Q26","v":0},{"$f":"'3.12.1 (2)'!T26","v":0},{"$f":"'3.12.1 (2)'!W26","v":0},{"$f":"'3.12.1 (2)'!Z26","v":0},null,0]
[29,"S001",{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:C,3,FALSE)","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:B,2,FALSE)","v":"Sample Agency"},{"$f":"VLOOKUP(C:C,'Lookup Tables'!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'3.12.1 '!B27","v":0},{"$f":"'3.12.1 (2)'!E27","v":0},{"$f":"'3.12.1 (2)'!H27","v":0},{"$f":"'3.12.1 (2)'!K27","v":0},{"$f":"'3.12.1 (2)'!N27","v":0},{"$f":"'3.12.1 (2)'!Q27","v":0},{"$f":"'3.12.1 (2)'!T27","v":0},{"$f":"'3.12.1 (2)'!W27","v":0},{"$f":"'3.12.1 (2)'!Z27","v":0},null,0]
[30,"S001",{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:C,3,FALSE)","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:B,2,FALSE)","v":"Sample Agency"},{"$f":"VLOOKUP(C:C,'Lookup Tables'!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'3.12.1 '!B28","v":0},{"$f":"'3.12.1 (2)'!E28","v":0},{"$f":"'3.12.1 (2)'!H28","v":0},{"$f":"'3.12.1 (2)'!K28","v":0},{"$f":"'3.12.1 (2)'!N28","v":0},{"$f":"'3.12.1 (2)'!Q28","v":0},{"$f":"'3.12.1 (2)'!T28","v":0},{"$f":"'3.12.1 (2)'!W28","v":0},{"$f":"'3.12.1 (2)'!Z28","v":0},null,0]
[31,"S001",{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:C,3,FALSE)","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:B,2,FALSE)","v":"Sample Agency"},{"$f":"VLOOKUP(C:C,'Lookup Tables'!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'3.12.1 '!B29","v":0},{"$f":"'3.12.1 (2)'!E29","v":0},{"$f":"'3.12.1 (2)'!H29","v":0},{"$f":"'3.12.1 (2)'!K29","v":0},{"$f":"'3.12.1 (2)'!N29","v":0},{"$f":"'3.12.1 (2)'!Q29","v":0},{"$f":"'3.12.1 (2)'!T29","v":0},{"$f":"'3.12.1 (2)'!W29","v":0},{"$f":"'3.12.1 (2)'!Z29","v":0},null,0]
[32,"S001",{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:C,3,FALSE)","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:B,2,FALSE)","v":"Sample Agency"},{"$f":"VLOOKUP(C:C,'Lookup Tables'!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'3.12.1 '!B30","v":0},{"$f":"'3.12.1 (2)'!E30","v":0},{"$f":"'3.12.1 (2)'!H30","v":0},{"$f":"'3.12.1 (2)'!K30","v":0},{"$f":"'3.12.1 (2)'!N30","v":0},{"$f":"'3.12.1 (2)'!Q30","v":0},{"$f":"'3.12.1 (2)'!T30","v":0},{"$f":"'3.12.1 (2)'!W30","v":0},{"$f":"'3.12.1 (2)'!Z30","v":0},null,0]
[33,"S001",{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:C,3,FALSE)","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:B,2,FALSE)","v":"Sample Agency"},{"$f":"VLOOKUP(C:C,'Lookup Tables'!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'3.12.1 '!B31","v":0},{"$f":"'3.12.1 (2)'!E31","v":0},{"$f":"'3.12.1 (2)'!H31","v":0},{"$f":"'3.12.1 (2)'!K31","v":0},{"$f":"'3.12.1 (2)'!N31","v":0},{"$f":"'3.12.1 (2)'!Q31","v":0},{"$f":"'3.12.1 (2)'!T31","v":0},{"$f":"'3.12.1 (2)'!W31","v":0},{"$f":"'3.12.1 (2)'!Z31","v":0},null,0]
[34,"S001",{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:C,3,FALSE)","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:B,2,FALSE)","v":"Sample Agency"},{"$f":"VLOOKUP(C:C,'Lookup Tables'!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'3.12.1 '!B32","v":0},{"$f":"'3.12.1 (2)'!E32","v":0},{"$f":"'3.12.1 (2)'!H32","v":0},{"$f":"'3.12.1 (2)'!K32","v":0},{"$f":"'3.12.1 (2)'!N32","v":0},{"$f":"'3.12.1 (2)'!Q32","v":0},{"$f":"'3.12.1 (2)'!T32","v":0},{"$f":"'3.12.1 (2)'!W32","v":0},{"$f":"'3.12.1 (2)'!Z32","v":0},null,0]
[35,"S001",{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:C,3,FALSE)","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:B,2,FALSE)","v":"Sample Agency"},{"$f":"VLOOKUP(C:C,'Lookup Tables'!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'3.12.1 '!B33","v":0},{"$f":"'3.12.1 (2)'!E33","v":0},{"$f":"'3.12.1 (2)'!H33","v":0},{"$f":"'3.12.1 (2)'!K33","v":0},{"$f":"'3.12.1 (2)'!N33","v":0},{"$f":"'3.12.1 (2)'!Q33","v":0},{"$f":"'3.12.1 (2)'!T33","v":0},{"$f":"'3.12.1 (2)'!W33","v":0},{"$f":"'3.12.1 (2)'!Z33","v":0},null,0]
[36,"S001",{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:C,3,FALSE)","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:B,2,FALSE)","v":"Sample Agency"},{"$f":"VLOOKUP(C:C,'Lookup Tables'!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'3.12.1 '!B34","v":0},{"$f":"'3.12.1 (2)'!E34","v":0},{"$f":"'3.12.1 (2)'!H34","v":0},{"$f":"'3.12.1 (2)'!K34","v":0},{"$f":"'3.12.1 (2)'!N34","v":0},{"$f":"'3.12.1 (2)'!Q34","v":0},{"$f":"'3.12.1 (2)'!T34","v":0},{"$f":"'3.12.1 (2)'!W34","v":0},{"$f":"'3.12.1 (2)'!Z34","v":0},null,0]
[37,"S001",{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:C,3,FALSE)","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:B,2,FALSE)","v":"Sample Agency"},{"$f":"VLOOKUP(C:C,'Lookup Tables'!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'3.12.1 '!B35","v":0},{"$f":"'3.12.1 (2)'!E35","v":0},{"$f":"'3.12.1 (2)'!H35","v":0},{"$f":"'3.12.1 (2)'!K35","v":0},{"$f":"'3.12.1 (2)'!N35","v":0},{"$f":"'3.12.1 (2)'!Q35","v":0},{"$f":"'3.12.1 (2)'!T35","v":0},{"$f":"'3.12.1 (2)'!W35","v":0},{"$f":"'3.12.1 (2)'!Z35","v":0},null,0]
[38,"S001",{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:C,3,FALSE)","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:B,2,FALSE)","v":"Sample Agency"},{"$f":"VLOOKUP(C:C,'Lookup Tables'!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'3.12.1 '!B36","v":0},{"$f":"'3.12.1 (2)'!E36","v":0},{"$f":"'3.12.1 (2)'!H36","v":0},{"$f":"'3.12.1 (2)'!K36","v":0},{"$f":"'3.12.1 (2)'!N36","v":0},{"$f":"'3.12.1 (2)'!Q36","v":0},{"$f":"'3.12.1 (2)'!T36","v":0},{"$f":"'3.12.1 (2)'!W36","v":0},{"$f":"'3.12.1 (2)'!Z36","v":0},null,0]
[39,"S001",{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:C,3,FALSE)","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:B,2,FALSE)","v":"Sample Agency"},{"$f":"VLOOKUP(C:C,'Lookup Tables'!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'3.12.1 '!B37","v":0},{"$f":"'3.12.1 (2)'!E37","v":0},{"$f":"'3.12.1 (2)'!H37","v":0},{"$f":"'3.12.1 (2)'!K37","v":0},{"$f":"'3.12.1 (2)'!N37","v":0},{"$f":"'3.12.1 (2)'!Q37","v":0},{"$f":"'3.12.1 (2)'!T37","v":0},{"$f":"'3.12.1 (2)'!W37","v":0},{"$f":"'3.12.1 (2)'!Z37","v":0},null,0]
[40,"S001",{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:C,3,FALSE)","v":"S001"},{"$f":"VLOOKUP(B:B,'Lookup Tables'!A:B,2,FALSE)","v":"Sample Agency"},{"$f":"VLOOKUP(C:C,'Lookup Tables'!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"'3.12.1 '!B38","v":0},{"$f":"'3.12.1 (2)'!E38","v":0},{"$f":"'3.12.1 (2)'!H38","v":0},{"$f":"'3.12.1 (2)'!K38","v":0},{"$f":"'3.12.1 (2)'!N38","v":0},{"$f":"'3.12.1 (2)'!Q38","v":0},{"$f":"'3.12.1 (2)'!T38","v":0},{"$f":"'3.12.1 (2)'!W38","v":0},{"$f":"'3.12.1 (2)'!Z38","v":0},null,0]
[]
[null,null,null,null,null,null,{"$f":"SUM(G3:G23)","v":0},0,0,0,0,0,0,0,null,0]

{"sheet":"Journal Entry","index":7,"n_rows":200,"n_cols":9,"rows_kept":200,"cut":false,"hidden":true,"merged":[]}
["Row","GL Acct","Description","Row Amt","D/C","Cost","Functional Area","Fund","Row Text"]
[{"$f":"'Package Response'!A3","v":1},{"$f":"'Package Response'!E3","v":{"$error":"#N/A"}},"CAFR Expense",{"$f":"'Package Response'!P3","v":17500},"D",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$3","v":10010000},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" Row 1\"","v":"Accounts Payable S001 Row 1"}]
[null,2010000000,{"$f":"VLOOKUP(B3,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accounts Payable"},{"$f":"'Package Response'!G3","v":2500},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$3","v":10010000},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" Row 1\"","v":"Accounts Payable S001 Row 1"}]
[null,2010150000,{"$f":"VLOOKUP(B4,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Pay-Aid Indiv/Fam"},{"$f":"'Package Response'!H3","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$3","v":10010000},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" Row 1\"","v":"Accounts Payable S001 Row 1"}]
[null,2010010000,{"$f":"VLOOKUP(B5,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Sales Tax Payable"},{"$f":"'Package Response'!I3","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$3","v":10010000},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" Row 1\"","v":"Accounts Payable S001 Row 1"}]
[null,2010030000,{"$f":"VLOOKUP(B6,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accrued Accounts Payable"},{"$f":"'Package Response'!J3","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$3","v":10010000},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" Row 1\"","v":"Accounts Payable S001 Row 1"}]
[null,2010120000,{"$f":"VLOOKUP(B7,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Intergov Payable"},{"$f":"'Package Response'!K3","v":15000},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$3","v":10010000},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" Row 1\"","v":"Accounts Payable S001 Row 1"}]
[null,2010070000,{"$f":"VLOOKUP(B8,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Payable"},{"$f":"'Package Response'!L3","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$3","v":10010000},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" Row 1\"","v":"Accounts Payable S001 Row 1"}]
[null,2050030000,{"$f":"VLOOKUP(B9,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Non-Current"},{"$f":"'Package Response'!M3","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$3","v":10010000},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" Row 1\"","v":"Accounts Payable S001 Row 1"}]
[null,2400130000,{"$f":"VLOOKUP(B10,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Other Current Liabilities"},{"$f":"'Package Response'!N3","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$3","v":10010000},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" Row 1\"","v":"Accounts Payable S001 Row 1"}]
[]
[2,{"$f":"'Package Response'!E4","v":{"$error":"#N/A"}},"CAFR Expense",{"$f":"'Package Response'!P4","v":1000},"D",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$4","v":30350000},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" Row 2\"","v":"Accounts Payable S001 Row 2"}]
[null,2010000000,{"$f":"VLOOKUP(B13,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accounts Payable"},{"$f":"'Package Response'!G4","v":1000},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$4","v":30350000},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" Row 2\"","v":"Accounts Payable S001 Row 2"}]
[null,2010150000,{"$f":"VLOOKUP(B14,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Pay-Aid Indiv/Fam"},{"$f":"'Package Response'!H4","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$4","v":30350000},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" Row 2\"","v":"Accounts Payable S001 Row 2"}]
[null,2010010000,{"$f":"VLOOKUP(B15,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Sales Tax Payable"},{"$f":"'Package Response'!I4","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$4","v":30350000},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" Row 2\"","v":"Accounts Payable S001 Row 2"}]
[null,2010030000,{"$f":"VLOOKUP(B16,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accrued Accounts Payable"},{"$f":"'Package Response'!J4","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$4","v":30350000},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" Row 2\"","v":"Accounts Payable S001 Row 2"}]
[null,2010120000,{"$f":"VLOOKUP(B17,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Intergov Payable"},{"$f":"'Package Response'!K4","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$4","v":30350000},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" Row 2\"","v":"Accounts Payable S001 Row 2"}]
[null,2010070000,{"$f":"VLOOKUP(B18,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Payable"},{"$f":"'Package Response'!L4","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$4","v":30350000},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" Row 2\"","v":"Accounts Payable S001 Row 2"}]
[null,2050030000,{"$f":"VLOOKUP(B19,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Non-Current"},{"$f":"'Package Response'!M4","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$4","v":30350000},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" Row 2\"","v":"Accounts Payable S001 Row 2"}]
[null,2400130000,{"$f":"VLOOKUP(B20,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Other Current Liabilities"},{"$f":"'Package Response'!N4","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$4","v":30350000},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" Row 2\"","v":"Accounts Payable S001 Row 2"}]
[]
[3,{"$f":"'Package Response'!E14","v":{"$error":"#N/A"}},"CAFR Expense",{"$f":"'Package Response'!P5","v":0},"D",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$5","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" Row 3\"","v":"Accounts Payable S001 Row 3"}]
[null,2010000000,{"$f":"VLOOKUP(B23,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accounts Payable"},{"$f":"'Package Response'!G5","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$5","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" Row 3\"","v":"Accounts Payable S001 Row 3"}]
[null,2010150000,{"$f":"VLOOKUP(B24,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Pay-Aid Indiv/Fam"},{"$f":"'Package Response'!H5","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$5","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" Row 3\"","v":"Accounts Payable S001 Row 3"}]
[null,2010010000,{"$f":"VLOOKUP(B25,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Sales Tax Payable"},{"$f":"'Package Response'!I5","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$5","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" Row 3\"","v":"Accounts Payable S001 Row 3"}]
[null,2010030000,{"$f":"VLOOKUP(B26,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accrued Accounts Payable"},{"$f":"'Package Response'!J5","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$5","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" Row 3\"","v":"Accounts Payable S001 Row 3"}]
[null,2010120000,{"$f":"VLOOKUP(B27,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Intergov Payable"},{"$f":"'Package Response'!K5","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$5","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" Row 3\"","v":"Accounts Payable S001 Row 3"}]
[null,2010070000,{"$f":"VLOOKUP(B28,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Payable"},{"$f":"'Package Response'!L5","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$5","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" Row 3\"","v":"Accounts Payable S001 Row 3"}]
[null,2050030000,{"$f":"VLOOKUP(B29,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Non-Current"},{"$f":"'Package Response'!M5","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$5","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" Row 3\"","v":"Accounts Payable S001 Row 3"}]
[null,2400130000,{"$f":"VLOOKUP(B30,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Other Current Liabilities"},{"$f":"'Package Response'!N5","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$5","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" Row 3\"","v":"Accounts Payable S001 Row 3"}]
[]
[4,{"$f":"'Package Response'!E6","v":{"$error":"#N/A"}},"CAFR Expense",{"$f":"'Package Response'!P6","v":0},"D",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$6","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 4\"","v":"Accounts Payable S001  Row 4"}]
[null,2010000000,{"$f":"VLOOKUP(B33,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accounts Payable"},{"$f":"'Package Response'!G6","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$6","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 4\"","v":"Accounts Payable S001  Row 4"}]
[null,2010150000,{"$f":"VLOOKUP(B34,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Pay-Aid Indiv/Fam"},{"$f":"'Package Response'!H6","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$6","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 4\"","v":"Accounts Payable S001  Row 4"}]
[null,2010010000,{"$f":"VLOOKUP(B35,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Sales Tax Payable"},{"$f":"'Package Response'!I6","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$6","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 4\"","v":"Accounts Payable S001  Row 4"}]
[null,2010030000,{"$f":"VLOOKUP(B36,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accrued Accounts Payable"},{"$f":"'Package Response'!J6","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$6","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 4\"","v":"Accounts Payable S001  Row 4"}]
[null,2010120000,{"$f":"VLOOKUP(B37,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Intergov Payable"},{"$f":"'Package Response'!K6","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$6","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 4\"","v":"Accounts Payable S001  Row 4"}]
[null,2010070000,{"$f":"VLOOKUP(B38,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Payable"},{"$f":"'Package Response'!L6","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$6","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 4\"","v":"Accounts Payable S001  Row 4"}]
[null,2050030000,{"$f":"VLOOKUP(B39,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Non-Current"},{"$f":"'Package Response'!M6","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$6","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 4\"","v":"Accounts Payable S001  Row 4"}]
[null,2400130000,{"$f":"VLOOKUP(B40,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Other Current Liabilities"},{"$f":"'Package Response'!N6","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$6","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 4\"","v":"Accounts Payable S001  Row 4"}]
[]
[5,{"$f":"'Package Response'!E7","v":{"$error":"#N/A"}},"CAFR Expense",{"$f":"'Package Response'!P7","v":0},"D",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$7","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 5\"","v":"Accounts Payable S001  Row 5"}]
[null,2010000000,{"$f":"VLOOKUP(B43,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accounts Payable"},{"$f":"'Package Response'!G7","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$7","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 5\"","v":"Accounts Payable S001  Row 5"}]
[null,2010150000,{"$f":"VLOOKUP(B44,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Pay-Aid Indiv/Fam"},{"$f":"'Package Response'!H7","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$7","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 5\"","v":"Accounts Payable S001  Row 5"}]
[null,2010010000,{"$f":"VLOOKUP(B45,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Sales Tax Payable"},{"$f":"'Package Response'!I7","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$7","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 5\"","v":"Accounts Payable S001  Row 5"}]
[null,2010030000,{"$f":"VLOOKUP(B46,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accrued Accounts Payable"},{"$f":"'Package Response'!J7","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$7","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 5\"","v":"Accounts Payable S001  Row 5"}]
[null,2010120000,{"$f":"VLOOKUP(B47,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Intergov Payable"},{"$f":"'Package Response'!K7","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$7","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 5\"","v":"Accounts Payable S001  Row 5"}]
[null,2010070000,{"$f":"VLOOKUP(B48,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Payable"},{"$f":"'Package Response'!L7","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$7","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 5\"","v":"Accounts Payable S001  Row 5"}]
[null,2050030000,{"$f":"VLOOKUP(B49,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Non-Current"},{"$f":"'Package Response'!M7","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$7","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 5\"","v":"Accounts Payable S001  Row 5"}]
[null,2400130000,{"$f":"VLOOKUP(B50,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Other Current Liabilities"},{"$f":"'Package Response'!N7","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$7","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 5\"","v":"Accounts Payable S001  Row 5"}]
[]
[6,{"$f":"'Package Response'!E8","v":{"$error":"#N/A"}},"CAFR Expense",{"$f":"'Package Response'!P8","v":0},"D",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$8","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 6\"","v":"Accounts Payable S001  Row 6"}]
[null,2010000000,{"$f":"VLOOKUP(B53,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accounts Payable"},{"$f":"'Package Response'!G8","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$8","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 6\"","v":"Accounts Payable S001  Row 6"}]
[null,2010150000,{"$f":"VLOOKUP(B54,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Pay-Aid Indiv/Fam"},{"$f":"'Package Response'!H8","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$8","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 6\"","v":"Accounts Payable S001  Row 6"}]
[null,2010010000,{"$f":"VLOOKUP(B55,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Sales Tax Payable"},{"$f":"'Package Response'!I8","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$8","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 6\"","v":"Accounts Payable S001  Row 6"}]
[null,2010030000,{"$f":"VLOOKUP(B56,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accrued Accounts Payable"},{"$f":"'Package Response'!J8","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$8","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 6\"","v":"Accounts Payable S001  Row 6"}]
[null,2010120000,{"$f":"VLOOKUP(B57,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Intergov Payable"},{"$f":"'Package Response'!K8","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$8","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 6\"","v":"Accounts Payable S001  Row 6"}]
[null,2010070000,{"$f":"VLOOKUP(B58,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Payable"},{"$f":"'Package Response'!L8","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$8","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 6\"","v":"Accounts Payable S001  Row 6"}]
[null,2050030000,{"$f":"VLOOKUP(B59,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Non-Current"},{"$f":"'Package Response'!M8","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$8","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 6\"","v":"Accounts Payable S001  Row 6"}]
[null,2400130000,{"$f":"VLOOKUP(B60,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Other Current Liabilities"},{"$f":"'Package Response'!N8","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$8","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 6\"","v":"Accounts Payable S001  Row 6"}]
[]
[7,{"$f":"'Package Response'!E9","v":{"$error":"#N/A"}},"CAFR Expense",{"$f":"'Package Response'!P9","v":0},"D",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$9","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 7\"","v":"Accounts Payable S001  Row 7"}]
[null,2010000000,{"$f":"VLOOKUP(B63,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accounts Payable"},{"$f":"'Package Response'!G9","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$9","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 7\"","v":"Accounts Payable S001  Row 7"}]
[null,2010150000,{"$f":"VLOOKUP(B64,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Pay-Aid Indiv/Fam"},{"$f":"'Package Response'!H9","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$9","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 7\"","v":"Accounts Payable S001  Row 7"}]
[null,2010010000,{"$f":"VLOOKUP(B65,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Sales Tax Payable"},{"$f":"'Package Response'!I9","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$9","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 7\"","v":"Accounts Payable S001  Row 7"}]
[null,2010030000,{"$f":"VLOOKUP(B66,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accrued Accounts Payable"},{"$f":"'Package Response'!J9","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$9","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 7\"","v":"Accounts Payable S001  Row 7"}]
[null,2010120000,{"$f":"VLOOKUP(B67,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Intergov Payable"},{"$f":"'Package Response'!K9","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$9","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 7\"","v":"Accounts Payable S001  Row 7"}]
[null,2010070000,{"$f":"VLOOKUP(B68,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Payable"},{"$f":"'Package Response'!L9","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$9","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 7\"","v":"Accounts Payable S001  Row 7"}]
[null,2050030000,{"$f":"VLOOKUP(B69,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Non-Current"},{"$f":"'Package Response'!M9","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$9","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 7\"","v":"Accounts Payable S001  Row 7"}]
[null,2400130000,{"$f":"VLOOKUP(B70,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Other Current Liabilities"},{"$f":"'Package Response'!N9","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$9","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 7\"","v":"Accounts Payable S001  Row 7"}]
[]
[8,{"$f":"'Package Response'!E10","v":{"$error":"#N/A"}},"CAFR Expense",{"$f":"'Package Response'!P10","v":0},"D",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$10","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 8\"","v":"Accounts Payable S001  Row 8"}]
[null,2010000000,{"$f":"VLOOKUP(B73,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accounts Payable"},{"$f":"'Package Response'!G10","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$10","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 8\"","v":"Accounts Payable S001  Row 8"}]
[null,2010150000,{"$f":"VLOOKUP(B74,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Pay-Aid Indiv/Fam"},{"$f":"'Package Response'!H10","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$10","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 8\"","v":"Accounts Payable S001  Row 8"}]
[null,2010010000,{"$f":"VLOOKUP(B75,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Sales Tax Payable"},{"$f":"'Package Response'!I10","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$10","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 8\"","v":"Accounts Payable S001  Row 8"}]
[null,2010030000,{"$f":"VLOOKUP(B76,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accrued Accounts Payable"},{"$f":"'Package Response'!J10","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$10","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 8\"","v":"Accounts Payable S001  Row 8"}]
[null,2010120000,{"$f":"VLOOKUP(B77,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Intergov Payable"},{"$f":"'Package Response'!K10","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$10","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 8\"","v":"Accounts Payable S001  Row 8"}]
[null,2010070000,{"$f":"VLOOKUP(B78,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Payable"},{"$f":"'Package Response'!L10","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$10","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 8\"","v":"Accounts Payable S001  Row 8"}]
[null,2050030000,{"$f":"VLOOKUP(B79,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Non-Current"},{"$f":"'Package Response'!M10","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$10","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 8\"","v":"Accounts Payable S001  Row 8"}]
[null,2400130000,{"$f":"VLOOKUP(B80,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Other Current Liabilities"},{"$f":"'Package Response'!N10","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$10","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 8\"","v":"Accounts Payable S001  Row 8"}]
[]
[9,{"$f":"'Package Response'!E11","v":{"$error":"#N/A"}},"CAFR Expense",{"$f":"'Package Response'!P11","v":0},"D",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F11","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 9\"","v":"Accounts Payable S001  Row 9"}]
[null,2010000000,{"$f":"VLOOKUP(B83,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accounts Payable"},{"$f":"'Package Response'!G11","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$11","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 9\"","v":"Accounts Payable S001  Row 9"}]
[null,2010150000,{"$f":"VLOOKUP(B84,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Pay-Aid Indiv/Fam"},{"$f":"'Package Response'!H11","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$11","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 9\"","v":"Accounts Payable S001  Row 9"}]
[null,2010010000,{"$f":"VLOOKUP(B85,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Sales Tax Payable"},{"$f":"'Package Response'!I11","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$11","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 9\"","v":"Accounts Payable S001  Row 9"}]
[null,2010030000,{"$f":"VLOOKUP(B86,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accrued Accounts Payable"},{"$f":"'Package Response'!J11","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$11","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 9\"","v":"Accounts Payable S001  Row 9"}]
[null,2010120000,{"$f":"VLOOKUP(B87,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Intergov Payable"},{"$f":"'Package Response'!K11","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$11","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 9\"","v":"Accounts Payable S001  Row 9"}]
[null,2010070000,{"$f":"VLOOKUP(B88,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Payable"},{"$f":"'Package Response'!L11","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$11","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 9\"","v":"Accounts Payable S001  Row 9"}]
[null,2050030000,{"$f":"VLOOKUP(B89,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Non-Current"},{"$f":"'Package Response'!M11","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$11","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 9\"","v":"Accounts Payable S001  Row 9"}]
[null,2400130000,{"$f":"VLOOKUP(B90,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Other Current Liabilities"},{"$f":"'Package Response'!N11","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$11","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 9\"","v":"Accounts Payable S001  Row 9"}]
[]
[10,{"$f":"'Package Response'!E12","v":{"$error":"#N/A"}},"CAFR Expense",{"$f":"'Package Response'!P12","v":0},"D",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$12","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 10\"","v":"Accounts Payable S001  Row 10"}]
[null,2010000000,{"$f":"VLOOKUP(B93,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accounts Payable"},{"$f":"'Package Response'!G12","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$12","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 10\"","v":"Accounts Payable S001  Row 10"}]
[null,2010150000,{"$f":"VLOOKUP(B94,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Pay-Aid Indiv/Fam"},{"$f":"'Package Response'!H12","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$12","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 10\"","v":"Accounts Payable S001  Row 10"}]
[null,2010010000,{"$f":"VLOOKUP(B95,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Sales Tax Payable"},{"$f":"'Package Response'!I12","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$12","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 10\"","v":"Accounts Payable S001  Row 10"}]
[null,2010030000,{"$f":"VLOOKUP(B96,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accrued Accounts Payable"},{"$f":"'Package Response'!J12","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$12","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 10\"","v":"Accounts Payable S001  Row 10"}]
[null,2010120000,{"$f":"VLOOKUP(B97,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Intergov Payable"},{"$f":"'Package Response'!K12","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$12","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 10\"","v":"Accounts Payable S001  Row 10"}]
[null,2010070000,{"$f":"VLOOKUP(B98,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Payable"},{"$f":"'Package Response'!L12","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$12","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 10\"","v":"Accounts Payable S001  Row 10"}]
[null,2050030000,{"$f":"VLOOKUP(B99,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Non-Current"},{"$f":"'Package Response'!M12","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$12","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 10\"","v":"Accounts Payable S001  Row 10"}]
[null,2400130000,{"$f":"VLOOKUP(B100,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Other Current Liabilities"},{"$f":"'Package Response'!N12","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$12","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 10\"","v":"Accounts Payable S001  Row 10"}]
[]
[11,{"$f":"'Package Response'!E13","v":{"$error":"#N/A"}},"CAFR Expense",{"$f":"'Package Response'!P13","v":0},"D",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$13","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 11\"","v":"Accounts Payable S001  Row 11"}]
[null,2010000000,{"$f":"VLOOKUP(B103,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accounts Payable"},{"$f":"'Package Response'!G13","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$13","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 11\"","v":"Accounts Payable S001  Row 11"}]
[null,2010150000,{"$f":"VLOOKUP(B104,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Pay-Aid Indiv/Fam"},{"$f":"'Package Response'!H13","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$13","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 11\"","v":"Accounts Payable S001  Row 11"}]
[null,2010010000,{"$f":"VLOOKUP(B105,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Sales Tax Payable"},{"$f":"'Package Response'!I13","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$13","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 11\"","v":"Accounts Payable S001  Row 11"}]
[null,2010030000,{"$f":"VLOOKUP(B106,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accrued Accounts Payable"},{"$f":"'Package Response'!J13","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$13","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 11\"","v":"Accounts Payable S001  Row 11"}]
[null,2010120000,{"$f":"VLOOKUP(B107,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Intergov Payable"},{"$f":"'Package Response'!K13","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$13","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 11\"","v":"Accounts Payable S001  Row 11"}]
[null,2010070000,{"$f":"VLOOKUP(B108,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Payable"},{"$f":"'Package Response'!L13","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$13","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 11\"","v":"Accounts Payable S001  Row 11"}]
[null,2050030000,{"$f":"VLOOKUP(B109,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Non-Current"},{"$f":"'Package Response'!M13","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$13","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 11\"","v":"Accounts Payable S001  Row 11"}]
[null,2400130000,{"$f":"VLOOKUP(B110,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Other Current Liabilities"},{"$f":"'Package Response'!N13","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$13","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 11\"","v":"Accounts Payable S001  Row 11"}]
[]
[12,{"$f":"'Package Response'!E14","v":{"$error":"#N/A"}},"CAFR Expense",{"$f":"'Package Response'!P14","v":0},"D",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$14","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 12\"","v":"Accounts Payable S001  Row 12"}]
[null,2010000000,{"$f":"VLOOKUP(B113,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accounts Payable"},{"$f":"'Package Response'!G14","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$14","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 12\"","v":"Accounts Payable S001  Row 12"}]
[null,2010150000,{"$f":"VLOOKUP(B114,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Pay-Aid Indiv/Fam"},{"$f":"'Package Response'!H14","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$14","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 12\"","v":"Accounts Payable S001  Row 12"}]
[null,2010010000,{"$f":"VLOOKUP(B115,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Sales Tax Payable"},{"$f":"'Package Response'!I14","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$14","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 12\"","v":"Accounts Payable S001  Row 12"}]
[null,2010030000,{"$f":"VLOOKUP(B116,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accrued Accounts Payable"},{"$f":"'Package Response'!J14","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$14","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 12\"","v":"Accounts Payable S001  Row 12"}]
[null,2010120000,{"$f":"VLOOKUP(B117,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Intergov Payable"},{"$f":"'Package Response'!K14","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$14","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 12\"","v":"Accounts Payable S001  Row 12"}]
[null,2010070000,{"$f":"VLOOKUP(B118,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Payable"},{"$f":"'Package Response'!L14","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$14","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 12\"","v":"Accounts Payable S001  Row 12"}]
[null,2050030000,{"$f":"VLOOKUP(B119,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Non-Current"},{"$f":"'Package Response'!M14","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$14","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 12\"","v":"Accounts Payable S001  Row 12"}]
[null,2400130000,{"$f":"VLOOKUP(B120,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Other Current Liabilities"},{"$f":"'Package Response'!N14","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$14","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 12\"","v":"Accounts Payable S001  Row 12"}]
[]
[13,{"$f":"'Package Response'!E15","v":{"$error":"#N/A"}},"CAFR Expense",{"$f":"'Package Response'!P15","v":0},"D",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$15","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 13\"","v":"Accounts Payable S001  Row 13"}]
[null,2010000000,{"$f":"VLOOKUP(B123,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accounts Payable"},{"$f":"'Package Response'!G15","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$15","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 13\"","v":"Accounts Payable S001  Row 13"}]
[null,2010150000,{"$f":"VLOOKUP(B124,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Pay-Aid Indiv/Fam"},{"$f":"'Package Response'!H15","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$15","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 13\"","v":"Accounts Payable S001  Row 13"}]
[null,2010010000,{"$f":"VLOOKUP(B125,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Sales Tax Payable"},{"$f":"'Package Response'!I15","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$15","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 13\"","v":"Accounts Payable S001  Row 13"}]
[null,2010030000,{"$f":"VLOOKUP(B126,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accrued Accounts Payable"},{"$f":"'Package Response'!J15","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$15","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 13\"","v":"Accounts Payable S001  Row 13"}]
[null,2010120000,{"$f":"VLOOKUP(B127,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Intergov Payable"},{"$f":"'Package Response'!K15","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$15","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 13\"","v":"Accounts Payable S001  Row 13"}]
[null,2010070000,{"$f":"VLOOKUP(B128,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Payable"},{"$f":"'Package Response'!L15","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$15","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 13\"","v":"Accounts Payable S001  Row 13"}]
[null,2050030000,{"$f":"VLOOKUP(B129,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Non-Current"},{"$f":"'Package Response'!M15","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$15","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 13\"","v":"Accounts Payable S001  Row 13"}]
[null,2400130000,{"$f":"VLOOKUP(B130,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Other Current Liabilities"},{"$f":"'Package Response'!N15","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$15","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 13\"","v":"Accounts Payable S001  Row 13"}]
[]
[14,{"$f":"'Package Response'!E16","v":{"$error":"#N/A"}},"CAFR Expense",{"$f":"'Package Response'!P16","v":0},"D",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$16","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 14\"","v":"Accounts Payable S001  Row 14"}]
[null,2010000000,{"$f":"VLOOKUP(B133,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accounts Payable"},{"$f":"'Package Response'!G16","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$16","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 14\"","v":"Accounts Payable S001  Row 14"}]
[null,2010150000,{"$f":"VLOOKUP(B134,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Pay-Aid Indiv/Fam"},{"$f":"'Package Response'!H16","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$16","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 14\"","v":"Accounts Payable S001  Row 14"}]
[null,2010010000,{"$f":"VLOOKUP(B135,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Sales Tax Payable"},{"$f":"'Package Response'!I16","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$16","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 14\"","v":"Accounts Payable S001  Row 14"}]
[null,2010030000,{"$f":"VLOOKUP(B136,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accrued Accounts Payable"},{"$f":"'Package Response'!J16","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$16","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 14\"","v":"Accounts Payable S001  Row 14"}]
[null,2010120000,{"$f":"VLOOKUP(B137,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Intergov Payable"},{"$f":"'Package Response'!K16","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$16","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 14\"","v":"Accounts Payable S001  Row 14"}]
[null,2010070000,{"$f":"VLOOKUP(B138,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Payable"},{"$f":"'Package Response'!L16","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$16","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 14\"","v":"Accounts Payable S001  Row 14"}]
[null,2050030000,{"$f":"VLOOKUP(B139,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Non-Current"},{"$f":"'Package Response'!M16","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$16","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 14\"","v":"Accounts Payable S001  Row 14"}]
[null,2400130000,{"$f":"VLOOKUP(B140,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Other Current Liabilities"},{"$f":"'Package Response'!N16","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$16","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 14\"","v":"Accounts Payable S001  Row 14"}]
[]
[15,{"$f":"'Package Response'!E17","v":{"$error":"#N/A"}},"CAFR Expense",{"$f":"'Package Response'!P17","v":0},"D",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$17","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 15\"","v":"Accounts Payable S001  Row 15"}]
[null,2010000000,{"$f":"VLOOKUP(B143,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accounts Payable"},{"$f":"'Package Response'!G17","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$17","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 15\"","v":"Accounts Payable S001  Row 15"}]
[null,2010150000,{"$f":"VLOOKUP(B144,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Pay-Aid Indiv/Fam"},{"$f":"'Package Response'!H17","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$17","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 15\"","v":"Accounts Payable S001  Row 15"}]
[null,2010010000,{"$f":"VLOOKUP(B145,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Sales Tax Payable"},{"$f":"'Package Response'!I17","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$17","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 15\"","v":"Accounts Payable S001  Row 15"}]
[null,2010030000,{"$f":"VLOOKUP(B146,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accrued Accounts Payable"},{"$f":"'Package Response'!J17","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$17","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 15\"","v":"Accounts Payable S001  Row 15"}]
[null,2010120000,{"$f":"VLOOKUP(B147,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Intergov Payable"},{"$f":"'Package Response'!K17","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$17","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 15\"","v":"Accounts Payable S001  Row 15"}]
[null,2010070000,{"$f":"VLOOKUP(B148,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Payable"},{"$f":"'Package Response'!L17","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$17","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 15\"","v":"Accounts Payable S001  Row 15"}]
[null,2050030000,{"$f":"VLOOKUP(B149,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Non-Current"},{"$f":"'Package Response'!M17","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$17","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 15\"","v":"Accounts Payable S001  Row 15"}]
[null,2400130000,{"$f":"VLOOKUP(B150,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Other Current Liabilities"},{"$f":"'Package Response'!N17","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$17","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 15\"","v":"Accounts Payable S001  Row 15"}]
[]
[16,{"$f":"'Package Response'!E18","v":{"$error":"#N/A"}},"CAFR Expense",{"$f":"'Package Response'!P18","v":0},"D",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$18","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 16\"","v":"Accounts Payable S001  Row 16"}]
[null,2010000000,{"$f":"VLOOKUP(B153,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accounts Payable"},{"$f":"'Package Response'!G18","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$18","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 16\"","v":"Accounts Payable S001  Row 16"}]
[null,2010150000,{"$f":"VLOOKUP(B154,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Pay-Aid Indiv/Fam"},{"$f":"'Package Response'!H18","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$18","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 16\"","v":"Accounts Payable S001  Row 16"}]
[null,2010010000,{"$f":"VLOOKUP(B155,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Sales Tax Payable"},{"$f":"'Package Response'!I18","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$18","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 16\"","v":"Accounts Payable S001  Row 16"}]
[null,2010030000,{"$f":"VLOOKUP(B156,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accrued Accounts Payable"},{"$f":"'Package Response'!J18","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$18","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 16\"","v":"Accounts Payable S001  Row 16"}]
[null,2010120000,{"$f":"VLOOKUP(B157,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Intergov Payable"},{"$f":"'Package Response'!K18","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$18","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 16\"","v":"Accounts Payable S001  Row 16"}]
[null,2010070000,{"$f":"VLOOKUP(B158,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Payable"},{"$f":"'Package Response'!L18","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$18","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 16\"","v":"Accounts Payable S001  Row 16"}]
[null,2050030000,{"$f":"VLOOKUP(B159,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Non-Current"},{"$f":"'Package Response'!M18","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$18","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 16\"","v":"Accounts Payable S001  Row 16"}]
[null,2400130000,{"$f":"VLOOKUP(B160,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Other Current Liabilities"},{"$f":"'Package Response'!N18","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$18","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 16\"","v":"Accounts Payable S001  Row 16"}]
[]
[17,{"$f":"'Package Response'!E19","v":{"$error":"#N/A"}},"CAFR Expense",{"$f":"'Package Response'!P19","v":0},"D",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$19","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 17\"","v":"Accounts Payable S001  Row 17"}]
[null,2010000000,{"$f":"VLOOKUP(B163,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accounts Payable"},{"$f":"'Package Response'!G19","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$19","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 17\"","v":"Accounts Payable S001  Row 17"}]
[null,2010150000,{"$f":"VLOOKUP(B164,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Pay-Aid Indiv/Fam"},{"$f":"'Package Response'!H19","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$19","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 17\"","v":"Accounts Payable S001  Row 17"}]
[null,2010010000,{"$f":"VLOOKUP(B165,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Sales Tax Payable"},{"$f":"'Package Response'!I19","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$19","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 17\"","v":"Accounts Payable S001  Row 17"}]
[null,2010030000,{"$f":"VLOOKUP(B166,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accrued Accounts Payable"},{"$f":"'Package Response'!J19","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$19","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 17\"","v":"Accounts Payable S001  Row 17"}]
[null,2010120000,{"$f":"VLOOKUP(B167,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Intergov Payable"},{"$f":"'Package Response'!K19","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$19","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 17\"","v":"Accounts Payable S001  Row 17"}]
[null,2010070000,{"$f":"VLOOKUP(B168,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Payable"},{"$f":"'Package Response'!L19","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$19","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 17\"","v":"Accounts Payable S001  Row 17"}]
[null,2050030000,{"$f":"VLOOKUP(B169,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Non-Current"},{"$f":"'Package Response'!M19","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$19","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 17\"","v":"Accounts Payable S001  Row 17"}]
[null,2400130000,{"$f":"VLOOKUP(B170,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Other Current Liabilities"},{"$f":"'Package Response'!N19","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$19","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 17\"","v":"Accounts Payable S001  Row 17"}]
[]
[18,{"$f":"'Package Response'!E20","v":{"$error":"#N/A"}},"CAFR Expense",{"$f":"'Package Response'!P20","v":0},"D",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$20","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 18\"","v":"Accounts Payable S001  Row 18"}]
[null,2010000000,{"$f":"VLOOKUP(B173,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accounts Payable"},{"$f":"'Package Response'!G20","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$20","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 18\"","v":"Accounts Payable S001  Row 18"}]
[null,2010150000,{"$f":"VLOOKUP(B174,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Pay-Aid Indiv/Fam"},{"$f":"'Package Response'!H20","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$20","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 18\"","v":"Accounts Payable S001  Row 18"}]
[null,2010010000,{"$f":"VLOOKUP(B175,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Sales Tax Payable"},{"$f":"'Package Response'!I20","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$20","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 18\"","v":"Accounts Payable S001  Row 18"}]
[null,2010030000,{"$f":"VLOOKUP(B176,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accrued Accounts Payable"},{"$f":"'Package Response'!J20","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$20","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 18\"","v":"Accounts Payable S001  Row 18"}]
[null,2010120000,{"$f":"VLOOKUP(B177,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Intergov Payable"},{"$f":"'Package Response'!K20","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$20","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 18\"","v":"Accounts Payable S001  Row 18"}]
[null,2010070000,{"$f":"VLOOKUP(B178,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Payable"},{"$f":"'Package Response'!L20","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$20","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 18\"","v":"Accounts Payable S001  Row 18"}]
[null,2050030000,{"$f":"VLOOKUP(B179,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Non-Current"},{"$f":"'Package Response'!M20","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$20","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 18\"","v":"Accounts Payable S001  Row 18"}]
[null,2400130000,{"$f":"VLOOKUP(B180,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Other Current Liabilities"},{"$f":"'Package Response'!N20","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$20","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 18\"","v":"Accounts Payable S001  Row 18"}]
[]
[19,{"$f":"'Package Response'!E21","v":{"$error":"#N/A"}},"CAFR Expense",{"$f":"'Package Response'!P21","v":0},"D",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$21","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 19\"","v":"Accounts Payable S001  Row 19"}]
[null,2010000000,{"$f":"VLOOKUP(B183,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accounts Payable"},{"$f":"'Package Response'!G21","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$21","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 19\"","v":"Accounts Payable S001  Row 19"}]
[null,2010150000,{"$f":"VLOOKUP(B184,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Pay-Aid Indiv/Fam"},{"$f":"'Package Response'!H21","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$21","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 19\"","v":"Accounts Payable S001  Row 19"}]
[null,2010010000,{"$f":"VLOOKUP(B185,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Sales Tax Payable"},{"$f":"'Package Response'!I21","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$21","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 19\"","v":"Accounts Payable S001  Row 19"}]
[null,2010030000,{"$f":"VLOOKUP(B186,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accrued Accounts Payable"},{"$f":"'Package Response'!J21","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$21","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 19\"","v":"Accounts Payable S001  Row 19"}]
[null,2010120000,{"$f":"VLOOKUP(B187,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Intergov Payable"},{"$f":"'Package Response'!K21","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$21","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 19\"","v":"Accounts Payable S001  Row 19"}]
[null,2010070000,{"$f":"VLOOKUP(B188,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Payable"},{"$f":"'Package Response'!L21","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$21","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 19\"","v":"Accounts Payable S001  Row 19"}]
[null,2050030000,{"$f":"VLOOKUP(B189,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Non-Current"},{"$f":"'Package Response'!M21","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$21","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 19\"","v":"Accounts Payable S001  Row 19"}]
[null,2400130000,{"$f":"VLOOKUP(B190,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Other Current Liabilities"},{"$f":"'Package Response'!N21","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$21","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 19\"","v":"Accounts Payable S001  Row 19"}]
[]
[20,{"$f":"'Package Response'!E22","v":{"$error":"#N/A"}},"CAFR Expense",{"$f":"'Package Response'!P22","v":0},"D",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$22","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 20\"","v":"Accounts Payable S001  Row 20"}]
[null,2010000000,{"$f":"VLOOKUP(B193,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accounts Payable"},{"$f":"'Package Response'!G22","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$22","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 20\"","v":"Accounts Payable S001  Row 20"}]
[null,2010150000,{"$f":"VLOOKUP(B194,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Pay-Aid Indiv/Fam"},{"$f":"'Package Response'!H22","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$22","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 20\"","v":"Accounts Payable S001  Row 20"}]
[null,2010010000,{"$f":"VLOOKUP(B195,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Sales Tax Payable"},{"$f":"'Package Response'!I22","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$22","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 20\"","v":"Accounts Payable S001  Row 20"}]
[null,2010030000,{"$f":"VLOOKUP(B196,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accrued Accounts Payable"},{"$f":"'Package Response'!J22","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$22","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 20\"","v":"Accounts Payable S001  Row 20"}]
[null,2010120000,{"$f":"VLOOKUP(B197,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Intergov Payable"},{"$f":"'Package Response'!K22","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$22","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 20\"","v":"Accounts Payable S001  Row 20"}]
[null,2010070000,{"$f":"VLOOKUP(B198,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Payable"},{"$f":"'Package Response'!L22","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$22","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 20\"","v":"Accounts Payable S001  Row 20"}]
[null,2050030000,{"$f":"VLOOKUP(B199,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Non-Current"},{"$f":"'Package Response'!M22","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$22","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 20\"","v":"Accounts Payable S001  Row 20"}]
[null,2400130000,{"$f":"VLOOKUP(B200,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Other Current Liabilities"},{"$f":"'Package Response'!N22","v":0},"C",{"$f":"'Package Response'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response'!$F$22","v":0},{"$f":"\"Accounts Payable \" &'Package Response'!$B$3&\" \"&\" Row 20\"","v":"Accounts Payable S001  Row 20"}]

{"sheet":"Journal Entry (2)","index":8,"n_rows":200,"n_cols":9,"rows_kept":200,"cut":false,"hidden":true,"merged":[]}
["Row","GL Acct","Description","Row Amt","D/C","Cost","Functional Area","Fund","Row Text"]
[{"$f":"'Package Response (2)'!A3","v":21},{"$f":"'Package Response (2)'!E3","v":{"$error":"#N/A"}},"CAFR Expense",{"$f":"'Package Response (2)'!P3","v":0},"D",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$3","v":10010000},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" Row 21\"","v":"Accounts Payable S001 Row 21"}]
[null,2010000000,{"$f":"VLOOKUP(B3,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accounts Payable"},{"$f":"'Package Response (2)'!G3","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$3","v":10010000},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" Row 21\"","v":"Accounts Payable S001 Row 21"}]
[null,2010150000,{"$f":"VLOOKUP(B4,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Pay-Aid Indiv/Fam"},{"$f":"'Package Response (2)'!H3","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$3","v":10010000},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" Row 21\"","v":"Accounts Payable S001 Row 21"}]
[null,2010010000,{"$f":"VLOOKUP(B5,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Sales Tax Payable"},{"$f":"'Package Response (2)'!I3","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$3","v":10010000},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" Row 21\"","v":"Accounts Payable S001 Row 21"}]
[null,2010030000,{"$f":"VLOOKUP(B6,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accrued Accounts Payable"},{"$f":"'Package Response (2)'!J3","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$3","v":10010000},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" Row 21\"","v":"Accounts Payable S001 Row 21"}]
[null,2010120000,{"$f":"VLOOKUP(B7,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Intergov Payable"},{"$f":"'Package Response (2)'!K3","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$3","v":10010000},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" Row 21\"","v":"Accounts Payable S001 Row 21"}]
[null,2010070000,{"$f":"VLOOKUP(B8,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Payable"},{"$f":"'Package Response (2)'!L3","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$3","v":10010000},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" Row 21\"","v":"Accounts Payable S001 Row 21"}]
[null,2050030000,{"$f":"VLOOKUP(B9,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Non-Current"},{"$f":"'Package Response (2)'!M3","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$3","v":10010000},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" Row 21\"","v":"Accounts Payable S001 Row 21"}]
[null,2400130000,{"$f":"VLOOKUP(B10,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Other Current Liabilities"},{"$f":"'Package Response (2)'!N3","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$3","v":10010000},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" Row 21\"","v":"Accounts Payable S001 Row 21"}]
[]
[2,{"$f":"'Package Response (2)'!E4","v":{"$error":"#N/A"}},"CAFR Expense",{"$f":"'Package Response (2)'!P4","v":0},"D",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$4","v":30350000},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" Row 22\"","v":"Accounts Payable S001 Row 22"}]
[null,2010000000,{"$f":"VLOOKUP(B13,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accounts Payable"},{"$f":"'Package Response (2)'!G4","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$4","v":30350000},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" Row 22\"","v":"Accounts Payable S001 Row 22"}]
[null,2010150000,{"$f":"VLOOKUP(B14,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Pay-Aid Indiv/Fam"},{"$f":"'Package Response (2)'!H4","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$4","v":30350000},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" Row 22\"","v":"Accounts Payable S001 Row 22"}]
[null,2010010000,{"$f":"VLOOKUP(B15,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Sales Tax Payable"},{"$f":"'Package Response (2)'!I4","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$4","v":30350000},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" Row 22\"","v":"Accounts Payable S001 Row 22"}]
[null,2010030000,{"$f":"VLOOKUP(B16,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accrued Accounts Payable"},{"$f":"'Package Response (2)'!J4","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$4","v":30350000},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" Row 22\"","v":"Accounts Payable S001 Row 22"}]
[null,2010120000,{"$f":"VLOOKUP(B17,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Intergov Payable"},{"$f":"'Package Response (2)'!K4","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$4","v":30350000},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" Row 22\"","v":"Accounts Payable S001 Row 22"}]
[null,2010070000,{"$f":"VLOOKUP(B18,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Payable"},{"$f":"'Package Response (2)'!L4","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$4","v":30350000},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" Row 22\"","v":"Accounts Payable S001 Row 22"}]
[null,2050030000,{"$f":"VLOOKUP(B19,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Non-Current"},{"$f":"'Package Response (2)'!M4","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$4","v":30350000},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" Row 22\"","v":"Accounts Payable S001 Row 22"}]
[null,2400130000,{"$f":"VLOOKUP(B20,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Other Current Liabilities"},{"$f":"'Package Response (2)'!N4","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$4","v":30350000},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" Row 22\"","v":"Accounts Payable S001 Row 22"}]
[]
[3,{"$f":"'Package Response (2)'!E14","v":{"$error":"#N/A"}},"CAFR Expense",{"$f":"'Package Response (2)'!P5","v":0},"D",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$5","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" Row 23\"","v":"Accounts Payable S001 Row 23"}]
[null,2010000000,{"$f":"VLOOKUP(B23,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accounts Payable"},{"$f":"'Package Response (2)'!G5","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$5","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" Row 23\"","v":"Accounts Payable S001 Row 23"}]
[null,2010150000,{"$f":"VLOOKUP(B24,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Pay-Aid Indiv/Fam"},{"$f":"'Package Response (2)'!H5","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$5","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" Row 23\"","v":"Accounts Payable S001 Row 23"}]
[null,2010010000,{"$f":"VLOOKUP(B25,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Sales Tax Payable"},{"$f":"'Package Response (2)'!I5","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$5","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" Row 23\"","v":"Accounts Payable S001 Row 23"}]
[null,2010030000,{"$f":"VLOOKUP(B26,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accrued Accounts Payable"},{"$f":"'Package Response (2)'!J5","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$5","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" Row 23\"","v":"Accounts Payable S001 Row 23"}]
[null,2010120000,{"$f":"VLOOKUP(B27,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Intergov Payable"},{"$f":"'Package Response (2)'!K5","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$5","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" Row 23\"","v":"Accounts Payable S001 Row 23"}]
[null,2010070000,{"$f":"VLOOKUP(B28,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Payable"},{"$f":"'Package Response (2)'!L5","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$5","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" Row 23\"","v":"Accounts Payable S001 Row 23"}]
[null,2050030000,{"$f":"VLOOKUP(B29,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Non-Current"},{"$f":"'Package Response (2)'!M5","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$5","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" Row 23\"","v":"Accounts Payable S001 Row 23"}]
[null,2400130000,{"$f":"VLOOKUP(B30,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Other Current Liabilities"},{"$f":"'Package Response (2)'!N5","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$5","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" Row 23\"","v":"Accounts Payable S001 Row 23"}]
[]
[4,{"$f":"'Package Response (2)'!E6","v":{"$error":"#N/A"}},"CAFR Expense",{"$f":"'Package Response (2)'!P6","v":0},"D",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$6","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 24\"","v":"Accounts Payable S001  Row 24"}]
[null,2010000000,{"$f":"VLOOKUP(B33,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accounts Payable"},{"$f":"'Package Response (2)'!G6","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$6","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 24\"","v":"Accounts Payable S001  Row 24"}]
[null,2010150000,{"$f":"VLOOKUP(B34,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Pay-Aid Indiv/Fam"},{"$f":"'Package Response (2)'!H6","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$6","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 24\"","v":"Accounts Payable S001  Row 24"}]
[null,2010010000,{"$f":"VLOOKUP(B35,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Sales Tax Payable"},{"$f":"'Package Response (2)'!I6","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$6","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 24\"","v":"Accounts Payable S001  Row 24"}]
[null,2010030000,{"$f":"VLOOKUP(B36,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accrued Accounts Payable"},{"$f":"'Package Response (2)'!J6","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$6","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 24\"","v":"Accounts Payable S001  Row 24"}]
[null,2010120000,{"$f":"VLOOKUP(B37,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Intergov Payable"},{"$f":"'Package Response (2)'!K6","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$6","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 24\"","v":"Accounts Payable S001  Row 24"}]
[null,2010070000,{"$f":"VLOOKUP(B38,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Payable"},{"$f":"'Package Response (2)'!L6","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$6","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 24\"","v":"Accounts Payable S001  Row 24"}]
[null,2050030000,{"$f":"VLOOKUP(B39,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Non-Current"},{"$f":"'Package Response (2)'!M6","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$6","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 24\"","v":"Accounts Payable S001  Row 24"}]
[null,2400130000,{"$f":"VLOOKUP(B40,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Other Current Liabilities"},{"$f":"'Package Response (2)'!N6","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$6","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 24\"","v":"Accounts Payable S001  Row 24"}]
[]
[5,{"$f":"'Package Response (2)'!E7","v":{"$error":"#N/A"}},"CAFR Expense",{"$f":"'Package Response (2)'!P7","v":0},"D",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$7","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 25\"","v":"Accounts Payable S001  Row 25"}]
[null,2010000000,{"$f":"VLOOKUP(B43,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accounts Payable"},{"$f":"'Package Response (2)'!G7","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$7","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 25\"","v":"Accounts Payable S001  Row 25"}]
[null,2010150000,{"$f":"VLOOKUP(B44,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Pay-Aid Indiv/Fam"},{"$f":"'Package Response (2)'!H7","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$7","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 25\"","v":"Accounts Payable S001  Row 25"}]
[null,2010010000,{"$f":"VLOOKUP(B45,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Sales Tax Payable"},{"$f":"'Package Response (2)'!I7","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$7","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 25\"","v":"Accounts Payable S001  Row 25"}]
[null,2010030000,{"$f":"VLOOKUP(B46,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accrued Accounts Payable"},{"$f":"'Package Response (2)'!J7","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$7","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 25\"","v":"Accounts Payable S001  Row 25"}]
[null,2010120000,{"$f":"VLOOKUP(B47,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Intergov Payable"},{"$f":"'Package Response (2)'!K7","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$7","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 25\"","v":"Accounts Payable S001  Row 25"}]
[null,2010070000,{"$f":"VLOOKUP(B48,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Payable"},{"$f":"'Package Response (2)'!L7","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$7","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 25\"","v":"Accounts Payable S001  Row 25"}]
[null,2050030000,{"$f":"VLOOKUP(B49,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Non-Current"},{"$f":"'Package Response (2)'!M7","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$7","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 25\"","v":"Accounts Payable S001  Row 25"}]
[null,2400130000,{"$f":"VLOOKUP(B50,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Other Current Liabilities"},{"$f":"'Package Response (2)'!N7","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$7","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 25\"","v":"Accounts Payable S001  Row 25"}]
[]
[6,{"$f":"'Package Response (2)'!E8","v":{"$error":"#N/A"}},"CAFR Expense",{"$f":"'Package Response (2)'!P8","v":0},"D",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$8","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 26\"","v":"Accounts Payable S001  Row 26"}]
[null,2010000000,{"$f":"VLOOKUP(B53,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accounts Payable"},{"$f":"'Package Response (2)'!G8","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$8","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 26\"","v":"Accounts Payable S001  Row 26"}]
[null,2010150000,{"$f":"VLOOKUP(B54,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Pay-Aid Indiv/Fam"},{"$f":"'Package Response (2)'!H8","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$8","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 26\"","v":"Accounts Payable S001  Row 26"}]
[null,2010010000,{"$f":"VLOOKUP(B55,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Sales Tax Payable"},{"$f":"'Package Response (2)'!I8","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$8","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 26\"","v":"Accounts Payable S001  Row 26"}]
[null,2010030000,{"$f":"VLOOKUP(B56,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accrued Accounts Payable"},{"$f":"'Package Response (2)'!J8","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$8","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 26\"","v":"Accounts Payable S001  Row 26"}]
[null,2010120000,{"$f":"VLOOKUP(B57,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Intergov Payable"},{"$f":"'Package Response (2)'!K8","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$8","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 26\"","v":"Accounts Payable S001  Row 26"}]
[null,2010070000,{"$f":"VLOOKUP(B58,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Payable"},{"$f":"'Package Response (2)'!L8","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$8","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 26\"","v":"Accounts Payable S001  Row 26"}]
[null,2050030000,{"$f":"VLOOKUP(B59,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Non-Current"},{"$f":"'Package Response (2)'!M8","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$8","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 26\"","v":"Accounts Payable S001  Row 26"}]
[null,2400130000,{"$f":"VLOOKUP(B60,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Other Current Liabilities"},{"$f":"'Package Response (2)'!N8","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$8","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 26\"","v":"Accounts Payable S001  Row 26"}]
[]
[7,{"$f":"'Package Response (2)'!E9","v":{"$error":"#N/A"}},"CAFR Expense",{"$f":"'Package Response (2)'!P9","v":0},"D",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$9","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 27\"","v":"Accounts Payable S001  Row 27"}]
[null,2010000000,{"$f":"VLOOKUP(B63,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accounts Payable"},{"$f":"'Package Response (2)'!G9","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$9","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 27\"","v":"Accounts Payable S001  Row 27"}]
[null,2010150000,{"$f":"VLOOKUP(B64,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Pay-Aid Indiv/Fam"},{"$f":"'Package Response (2)'!H9","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$9","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 27\"","v":"Accounts Payable S001  Row 27"}]
[null,2010010000,{"$f":"VLOOKUP(B65,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Sales Tax Payable"},{"$f":"'Package Response (2)'!I9","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$9","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 27\"","v":"Accounts Payable S001  Row 27"}]
[null,2010030000,{"$f":"VLOOKUP(B66,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accrued Accounts Payable"},{"$f":"'Package Response (2)'!J9","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$9","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 27\"","v":"Accounts Payable S001  Row 27"}]
[null,2010120000,{"$f":"VLOOKUP(B67,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Intergov Payable"},{"$f":"'Package Response (2)'!K9","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$9","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 27\"","v":"Accounts Payable S001  Row 27"}]
[null,2010070000,{"$f":"VLOOKUP(B68,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Payable"},{"$f":"'Package Response (2)'!L9","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$9","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 27\"","v":"Accounts Payable S001  Row 27"}]
[null,2050030000,{"$f":"VLOOKUP(B69,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Non-Current"},{"$f":"'Package Response (2)'!M9","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$9","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 27\"","v":"Accounts Payable S001  Row 27"}]
[null,2400130000,{"$f":"VLOOKUP(B70,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Other Current Liabilities"},{"$f":"'Package Response (2)'!N9","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$9","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 27\"","v":"Accounts Payable S001  Row 27"}]
[]
[8,{"$f":"'Package Response (2)'!E10","v":{"$error":"#N/A"}},"CAFR Expense",{"$f":"'Package Response (2)'!P10","v":0},"D",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$10","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 28\"","v":"Accounts Payable S001  Row 28"}]
[null,2010000000,{"$f":"VLOOKUP(B73,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accounts Payable"},{"$f":"'Package Response (2)'!G10","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$10","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 28\"","v":"Accounts Payable S001  Row 28"}]
[null,2010150000,{"$f":"VLOOKUP(B74,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Pay-Aid Indiv/Fam"},{"$f":"'Package Response (2)'!H10","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$10","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 28\"","v":"Accounts Payable S001  Row 28"}]
[null,2010010000,{"$f":"VLOOKUP(B75,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Sales Tax Payable"},{"$f":"'Package Response (2)'!I10","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$10","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 28\"","v":"Accounts Payable S001  Row 28"}]
[null,2010030000,{"$f":"VLOOKUP(B76,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accrued Accounts Payable"},{"$f":"'Package Response (2)'!J10","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$10","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 28\"","v":"Accounts Payable S001  Row 28"}]
[null,2010120000,{"$f":"VLOOKUP(B77,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Intergov Payable"},{"$f":"'Package Response (2)'!K10","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$10","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 28\"","v":"Accounts Payable S001  Row 28"}]
[null,2010070000,{"$f":"VLOOKUP(B78,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Payable"},{"$f":"'Package Response (2)'!L10","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$10","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 28\"","v":"Accounts Payable S001  Row 28"}]
[null,2050030000,{"$f":"VLOOKUP(B79,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Non-Current"},{"$f":"'Package Response (2)'!M10","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$10","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 28\"","v":"Accounts Payable S001  Row 28"}]
[null,2400130000,{"$f":"VLOOKUP(B80,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Other Current Liabilities"},{"$f":"'Package Response (2)'!N10","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$10","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 28\"","v":"Accounts Payable S001  Row 28"}]
[]
[9,{"$f":"'Package Response (2)'!E11","v":{"$error":"#N/A"}},"CAFR Expense",{"$f":"'Package Response (2)'!P11","v":0},"D",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F11","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 29\"","v":"Accounts Payable S001  Row 29"}]
[null,2010000000,{"$f":"VLOOKUP(B83,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accounts Payable"},{"$f":"'Package Response (2)'!G11","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$11","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 29\"","v":"Accounts Payable S001  Row 29"}]
[null,2010150000,{"$f":"VLOOKUP(B84,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Pay-Aid Indiv/Fam"},{"$f":"'Package Response (2)'!H11","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$11","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 29\"","v":"Accounts Payable S001  Row 29"}]
[null,2010010000,{"$f":"VLOOKUP(B85,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Sales Tax Payable"},{"$f":"'Package Response (2)'!I11","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$11","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 29\"","v":"Accounts Payable S001  Row 29"}]
[null,2010030000,{"$f":"VLOOKUP(B86,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accrued Accounts Payable"},{"$f":"'Package Response (2)'!J11","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$11","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 29\"","v":"Accounts Payable S001  Row 29"}]
[null,2010120000,{"$f":"VLOOKUP(B87,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Intergov Payable"},{"$f":"'Package Response (2)'!K11","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$11","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 29\"","v":"Accounts Payable S001  Row 29"}]
[null,2010070000,{"$f":"VLOOKUP(B88,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Payable"},{"$f":"'Package Response (2)'!L11","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$11","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 29\"","v":"Accounts Payable S001  Row 29"}]
[null,2050030000,{"$f":"VLOOKUP(B89,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Non-Current"},{"$f":"'Package Response (2)'!M11","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$11","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 29\"","v":"Accounts Payable S001  Row 29"}]
[null,2400130000,{"$f":"VLOOKUP(B90,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Other Current Liabilities"},{"$f":"'Package Response (2)'!N11","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$11","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 29\"","v":"Accounts Payable S001  Row 29"}]
[]
[10,{"$f":"'Package Response (2)'!E12","v":{"$error":"#N/A"}},"CAFR Expense",{"$f":"'Package Response (2)'!P12","v":0},"D",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$12","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 30\"","v":"Accounts Payable S001  Row 30"}]
[null,2010000000,{"$f":"VLOOKUP(B93,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accounts Payable"},{"$f":"'Package Response (2)'!G12","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$12","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 30\"","v":"Accounts Payable S001  Row 30"}]
[null,2010150000,{"$f":"VLOOKUP(B94,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Pay-Aid Indiv/Fam"},{"$f":"'Package Response (2)'!H12","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$12","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 30\"","v":"Accounts Payable S001  Row 30"}]
[null,2010010000,{"$f":"VLOOKUP(B95,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Sales Tax Payable"},{"$f":"'Package Response (2)'!I12","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$12","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 30\"","v":"Accounts Payable S001  Row 30"}]
[null,2010030000,{"$f":"VLOOKUP(B96,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accrued Accounts Payable"},{"$f":"'Package Response (2)'!J12","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$12","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 30\"","v":"Accounts Payable S001  Row 30"}]
[null,2010120000,{"$f":"VLOOKUP(B97,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Intergov Payable"},{"$f":"'Package Response (2)'!K12","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$12","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 30\"","v":"Accounts Payable S001  Row 30"}]
[null,2010070000,{"$f":"VLOOKUP(B98,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Payable"},{"$f":"'Package Response (2)'!L12","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$12","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 30\"","v":"Accounts Payable S001  Row 30"}]
[null,2050030000,{"$f":"VLOOKUP(B99,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Non-Current"},{"$f":"'Package Response (2)'!M12","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$12","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 30\"","v":"Accounts Payable S001  Row 30"}]
[null,2400130000,{"$f":"VLOOKUP(B100,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Other Current Liabilities"},{"$f":"'Package Response (2)'!N12","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$12","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 30\"","v":"Accounts Payable S001  Row 30"}]
[]
[11,{"$f":"'Package Response (2)'!E13","v":{"$error":"#N/A"}},"CAFR Expense",{"$f":"'Package Response (2)'!P13","v":0},"D",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$13","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 31\"","v":"Accounts Payable S001  Row 31"}]
[null,2010000000,{"$f":"VLOOKUP(B103,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accounts Payable"},{"$f":"'Package Response (2)'!G13","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$13","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 31\"","v":"Accounts Payable S001  Row 31"}]
[null,2010150000,{"$f":"VLOOKUP(B104,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Pay-Aid Indiv/Fam"},{"$f":"'Package Response (2)'!H13","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$13","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 31\"","v":"Accounts Payable S001  Row 31"}]
[null,2010010000,{"$f":"VLOOKUP(B105,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Sales Tax Payable"},{"$f":"'Package Response (2)'!I13","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$13","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 31\"","v":"Accounts Payable S001  Row 31"}]
[null,2010030000,{"$f":"VLOOKUP(B106,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accrued Accounts Payable"},{"$f":"'Package Response (2)'!J13","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$13","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 31\"","v":"Accounts Payable S001  Row 31"}]
[null,2010120000,{"$f":"VLOOKUP(B107,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Intergov Payable"},{"$f":"'Package Response (2)'!K13","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$13","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 31\"","v":"Accounts Payable S001  Row 31"}]
[null,2010070000,{"$f":"VLOOKUP(B108,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Payable"},{"$f":"'Package Response (2)'!L13","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$13","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 31\"","v":"Accounts Payable S001  Row 31"}]
[null,2050030000,{"$f":"VLOOKUP(B109,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Non-Current"},{"$f":"'Package Response (2)'!M13","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$13","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 31\"","v":"Accounts Payable S001  Row 31"}]
[null,2400130000,{"$f":"VLOOKUP(B110,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Other Current Liabilities"},{"$f":"'Package Response (2)'!N13","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$13","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 31\"","v":"Accounts Payable S001  Row 31"}]
[]
[12,{"$f":"'Package Response (2)'!E14","v":{"$error":"#N/A"}},"CAFR Expense",{"$f":"'Package Response (2)'!P14","v":0},"D",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$14","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 32\"","v":"Accounts Payable S001  Row 32"}]
[null,2010000000,{"$f":"VLOOKUP(B113,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accounts Payable"},{"$f":"'Package Response (2)'!G14","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$14","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 32\"","v":"Accounts Payable S001  Row 32"}]
[null,2010150000,{"$f":"VLOOKUP(B114,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Pay-Aid Indiv/Fam"},{"$f":"'Package Response (2)'!H14","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$14","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 32\"","v":"Accounts Payable S001  Row 32"}]
[null,2010010000,{"$f":"VLOOKUP(B115,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Sales Tax Payable"},{"$f":"'Package Response (2)'!I14","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$14","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 32\"","v":"Accounts Payable S001  Row 32"}]
[null,2010030000,{"$f":"VLOOKUP(B116,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accrued Accounts Payable"},{"$f":"'Package Response (2)'!J14","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$14","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 32\"","v":"Accounts Payable S001  Row 32"}]
[null,2010120000,{"$f":"VLOOKUP(B117,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Intergov Payable"},{"$f":"'Package Response (2)'!K14","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$14","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 32\"","v":"Accounts Payable S001  Row 32"}]
[null,2010070000,{"$f":"VLOOKUP(B118,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Payable"},{"$f":"'Package Response (2)'!L14","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$14","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 32\"","v":"Accounts Payable S001  Row 32"}]
[null,2050030000,{"$f":"VLOOKUP(B119,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Non-Current"},{"$f":"'Package Response (2)'!M14","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$14","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 32\"","v":"Accounts Payable S001  Row 32"}]
[null,2400130000,{"$f":"VLOOKUP(B120,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Other Current Liabilities"},{"$f":"'Package Response (2)'!N14","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$14","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 32\"","v":"Accounts Payable S001  Row 32"}]
[]
[13,{"$f":"'Package Response (2)'!E15","v":{"$error":"#N/A"}},"CAFR Expense",{"$f":"'Package Response (2)'!P15","v":0},"D",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$15","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 33\"","v":"Accounts Payable S001  Row 33"}]
[null,2010000000,{"$f":"VLOOKUP(B123,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accounts Payable"},{"$f":"'Package Response (2)'!G15","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$15","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 33\"","v":"Accounts Payable S001  Row 33"}]
[null,2010150000,{"$f":"VLOOKUP(B124,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Pay-Aid Indiv/Fam"},{"$f":"'Package Response (2)'!H15","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$15","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 33\"","v":"Accounts Payable S001  Row 33"}]
[null,2010010000,{"$f":"VLOOKUP(B125,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Sales Tax Payable"},{"$f":"'Package Response (2)'!I15","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$15","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 33\"","v":"Accounts Payable S001  Row 33"}]
[null,2010030000,{"$f":"VLOOKUP(B126,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accrued Accounts Payable"},{"$f":"'Package Response (2)'!J15","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$15","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 33\"","v":"Accounts Payable S001  Row 33"}]
[null,2010120000,{"$f":"VLOOKUP(B127,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Intergov Payable"},{"$f":"'Package Response (2)'!K15","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$15","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 33\"","v":"Accounts Payable S001  Row 33"}]
[null,2010070000,{"$f":"VLOOKUP(B128,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Payable"},{"$f":"'Package Response (2)'!L15","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$15","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 33\"","v":"Accounts Payable S001  Row 33"}]
[null,2050030000,{"$f":"VLOOKUP(B129,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Non-Current"},{"$f":"'Package Response (2)'!M15","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$15","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 33\"","v":"Accounts Payable S001  Row 33"}]
[null,2400130000,{"$f":"VLOOKUP(B130,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Other Current Liabilities"},{"$f":"'Package Response (2)'!N15","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$15","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 33\"","v":"Accounts Payable S001  Row 33"}]
[]
[14,{"$f":"'Package Response (2)'!E16","v":{"$error":"#N/A"}},"CAFR Expense",{"$f":"'Package Response (2)'!P16","v":0},"D",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$16","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 34\"","v":"Accounts Payable S001  Row 34"}]
[null,2010000000,{"$f":"VLOOKUP(B133,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accounts Payable"},{"$f":"'Package Response (2)'!G16","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$16","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 34\"","v":"Accounts Payable S001  Row 34"}]
[null,2010150000,{"$f":"VLOOKUP(B134,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Pay-Aid Indiv/Fam"},{"$f":"'Package Response (2)'!H16","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$16","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 34\"","v":"Accounts Payable S001  Row 34"}]
[null,2010010000,{"$f":"VLOOKUP(B135,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Sales Tax Payable"},{"$f":"'Package Response (2)'!I16","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$16","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 34\"","v":"Accounts Payable S001  Row 34"}]
[null,2010030000,{"$f":"VLOOKUP(B136,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accrued Accounts Payable"},{"$f":"'Package Response (2)'!J16","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$16","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 34\"","v":"Accounts Payable S001  Row 34"}]
[null,2010120000,{"$f":"VLOOKUP(B137,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Intergov Payable"},{"$f":"'Package Response (2)'!K16","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$16","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 34\"","v":"Accounts Payable S001  Row 34"}]
[null,2010070000,{"$f":"VLOOKUP(B138,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Payable"},{"$f":"'Package Response (2)'!L16","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$16","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 34\"","v":"Accounts Payable S001  Row 34"}]
[null,2050030000,{"$f":"VLOOKUP(B139,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Non-Current"},{"$f":"'Package Response (2)'!M16","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$16","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 34\"","v":"Accounts Payable S001  Row 34"}]
[null,2400130000,{"$f":"VLOOKUP(B140,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Other Current Liabilities"},{"$f":"'Package Response (2)'!N16","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$16","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 34\"","v":"Accounts Payable S001  Row 34"}]
[]
[15,{"$f":"'Package Response (2)'!E17","v":{"$error":"#N/A"}},"CAFR Expense",{"$f":"'Package Response (2)'!P17","v":0},"D",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$17","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 35\"","v":"Accounts Payable S001  Row 35"}]
[null,2010000000,{"$f":"VLOOKUP(B143,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accounts Payable"},{"$f":"'Package Response (2)'!G17","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$17","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 35\"","v":"Accounts Payable S001  Row 35"}]
[null,2010150000,{"$f":"VLOOKUP(B144,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Pay-Aid Indiv/Fam"},{"$f":"'Package Response (2)'!H17","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$17","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 35\"","v":"Accounts Payable S001  Row 35"}]
[null,2010010000,{"$f":"VLOOKUP(B145,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Sales Tax Payable"},{"$f":"'Package Response (2)'!I17","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$17","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 35\"","v":"Accounts Payable S001  Row 35"}]
[null,2010030000,{"$f":"VLOOKUP(B146,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accrued Accounts Payable"},{"$f":"'Package Response (2)'!J17","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$17","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 35\"","v":"Accounts Payable S001  Row 35"}]
[null,2010120000,{"$f":"VLOOKUP(B147,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Intergov Payable"},{"$f":"'Package Response (2)'!K17","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$17","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 35\"","v":"Accounts Payable S001  Row 35"}]
[null,2010070000,{"$f":"VLOOKUP(B148,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Payable"},{"$f":"'Package Response (2)'!L17","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$17","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 35\"","v":"Accounts Payable S001  Row 35"}]
[null,2050030000,{"$f":"VLOOKUP(B149,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Non-Current"},{"$f":"'Package Response (2)'!M17","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$17","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 35\"","v":"Accounts Payable S001  Row 35"}]
[null,2400130000,{"$f":"VLOOKUP(B150,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Other Current Liabilities"},{"$f":"'Package Response (2)'!N17","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$17","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 35\"","v":"Accounts Payable S001  Row 35"}]
[]
[16,{"$f":"'Package Response (2)'!E18","v":{"$error":"#N/A"}},"CAFR Expense",{"$f":"'Package Response (2)'!P18","v":0},"D",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$18","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 36\"","v":"Accounts Payable S001  Row 36"}]
[null,2010000000,{"$f":"VLOOKUP(B153,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accounts Payable"},{"$f":"'Package Response (2)'!G18","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$18","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 36\"","v":"Accounts Payable S001  Row 36"}]
[null,2010150000,{"$f":"VLOOKUP(B154,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Pay-Aid Indiv/Fam"},{"$f":"'Package Response (2)'!H18","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$18","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 36\"","v":"Accounts Payable S001  Row 36"}]
[null,2010010000,{"$f":"VLOOKUP(B155,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Sales Tax Payable"},{"$f":"'Package Response (2)'!I18","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$18","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 36\"","v":"Accounts Payable S001  Row 36"}]
[null,2010030000,{"$f":"VLOOKUP(B156,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accrued Accounts Payable"},{"$f":"'Package Response (2)'!J18","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$18","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 36\"","v":"Accounts Payable S001  Row 36"}]
[null,2010120000,{"$f":"VLOOKUP(B157,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Intergov Payable"},{"$f":"'Package Response (2)'!K18","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$18","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 36\"","v":"Accounts Payable S001  Row 36"}]
[null,2010070000,{"$f":"VLOOKUP(B158,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Payable"},{"$f":"'Package Response (2)'!L18","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$18","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 36\"","v":"Accounts Payable S001  Row 36"}]
[null,2050030000,{"$f":"VLOOKUP(B159,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Non-Current"},{"$f":"'Package Response (2)'!M18","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$18","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 36\"","v":"Accounts Payable S001  Row 36"}]
[null,2400130000,{"$f":"VLOOKUP(B160,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Other Current Liabilities"},{"$f":"'Package Response (2)'!N18","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$18","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 36\"","v":"Accounts Payable S001  Row 36"}]
[]
[17,{"$f":"'Package Response (2)'!E19","v":{"$error":"#N/A"}},"CAFR Expense",{"$f":"'Package Response (2)'!P19","v":0},"D",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$19","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 37\"","v":"Accounts Payable S001  Row 37"}]
[null,2010000000,{"$f":"VLOOKUP(B163,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accounts Payable"},{"$f":"'Package Response (2)'!G19","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$19","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 37\"","v":"Accounts Payable S001  Row 37"}]
[null,2010150000,{"$f":"VLOOKUP(B164,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Pay-Aid Indiv/Fam"},{"$f":"'Package Response (2)'!H19","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$19","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 37\"","v":"Accounts Payable S001  Row 37"}]
[null,2010010000,{"$f":"VLOOKUP(B165,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Sales Tax Payable"},{"$f":"'Package Response (2)'!I19","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$19","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 37\"","v":"Accounts Payable S001  Row 37"}]
[null,2010030000,{"$f":"VLOOKUP(B166,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accrued Accounts Payable"},{"$f":"'Package Response (2)'!J19","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$19","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 37\"","v":"Accounts Payable S001  Row 37"}]
[null,2010120000,{"$f":"VLOOKUP(B167,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Intergov Payable"},{"$f":"'Package Response (2)'!K19","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$19","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 37\"","v":"Accounts Payable S001  Row 37"}]
[null,2010070000,{"$f":"VLOOKUP(B168,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Payable"},{"$f":"'Package Response (2)'!L19","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$19","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 37\"","v":"Accounts Payable S001  Row 37"}]
[null,2050030000,{"$f":"VLOOKUP(B169,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Non-Current"},{"$f":"'Package Response (2)'!M19","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$19","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 37\"","v":"Accounts Payable S001  Row 37"}]
[null,2400130000,{"$f":"VLOOKUP(B170,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Other Current Liabilities"},{"$f":"'Package Response (2)'!N19","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$19","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 37\"","v":"Accounts Payable S001  Row 37"}]
[]
[18,{"$f":"'Package Response (2)'!E20","v":{"$error":"#N/A"}},"CAFR Expense",{"$f":"'Package Response (2)'!P20","v":0},"D",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$20","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 38\"","v":"Accounts Payable S001  Row 38"}]
[null,2010000000,{"$f":"VLOOKUP(B173,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accounts Payable"},{"$f":"'Package Response (2)'!G20","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$20","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 38\"","v":"Accounts Payable S001  Row 38"}]
[null,2010150000,{"$f":"VLOOKUP(B174,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Pay-Aid Indiv/Fam"},{"$f":"'Package Response (2)'!H20","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$20","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 38\"","v":"Accounts Payable S001  Row 38"}]
[null,2010010000,{"$f":"VLOOKUP(B175,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Sales Tax Payable"},{"$f":"'Package Response (2)'!I20","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$20","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 38\"","v":"Accounts Payable S001  Row 38"}]
[null,2010030000,{"$f":"VLOOKUP(B176,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accrued Accounts Payable"},{"$f":"'Package Response (2)'!J20","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$20","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 38\"","v":"Accounts Payable S001  Row 38"}]
[null,2010120000,{"$f":"VLOOKUP(B177,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Intergov Payable"},{"$f":"'Package Response (2)'!K20","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$20","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 38\"","v":"Accounts Payable S001  Row 38"}]
[null,2010070000,{"$f":"VLOOKUP(B178,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Payable"},{"$f":"'Package Response (2)'!L20","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$20","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 38\"","v":"Accounts Payable S001  Row 38"}]
[null,2050030000,{"$f":"VLOOKUP(B179,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Non-Current"},{"$f":"'Package Response (2)'!M20","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$20","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 38\"","v":"Accounts Payable S001  Row 38"}]
[null,2400130000,{"$f":"VLOOKUP(B180,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Other Current Liabilities"},{"$f":"'Package Response (2)'!N20","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$20","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 38\"","v":"Accounts Payable S001  Row 38"}]
[]
[19,{"$f":"'Package Response (2)'!E21","v":{"$error":"#N/A"}},"CAFR Expense",{"$f":"'Package Response (2)'!P21","v":0},"D",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$21","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 39\"","v":"Accounts Payable S001  Row 39"}]
[null,2010000000,{"$f":"VLOOKUP(B183,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accounts Payable"},{"$f":"'Package Response (2)'!G21","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$21","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 39\"","v":"Accounts Payable S001  Row 39"}]
[null,2010150000,{"$f":"VLOOKUP(B184,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Pay-Aid Indiv/Fam"},{"$f":"'Package Response (2)'!H21","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$21","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 39\"","v":"Accounts Payable S001  Row 39"}]
[null,2010010000,{"$f":"VLOOKUP(B185,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Sales Tax Payable"},{"$f":"'Package Response (2)'!I21","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$21","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 39\"","v":"Accounts Payable S001  Row 39"}]
[null,2010030000,{"$f":"VLOOKUP(B186,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accrued Accounts Payable"},{"$f":"'Package Response (2)'!J21","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$21","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 39\"","v":"Accounts Payable S001  Row 39"}]
[null,2010120000,{"$f":"VLOOKUP(B187,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Intergov Payable"},{"$f":"'Package Response (2)'!K21","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$21","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 39\"","v":"Accounts Payable S001  Row 39"}]
[null,2010070000,{"$f":"VLOOKUP(B188,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Payable"},{"$f":"'Package Response (2)'!L21","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$21","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 39\"","v":"Accounts Payable S001  Row 39"}]
[null,2050030000,{"$f":"VLOOKUP(B189,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Non-Current"},{"$f":"'Package Response (2)'!M21","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$21","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 39\"","v":"Accounts Payable S001  Row 39"}]
[null,2400130000,{"$f":"VLOOKUP(B190,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Other Current Liabilities"},{"$f":"'Package Response (2)'!N21","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$21","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 39\"","v":"Accounts Payable S001  Row 39"}]
[]
[20,{"$f":"'Package Response (2)'!E22","v":{"$error":"#N/A"}},"CAFR Expense",{"$f":"'Package Response (2)'!P22","v":0},"D",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$22","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 40\"","v":"Accounts Payable S001  Row 40"}]
[null,2010000000,{"$f":"VLOOKUP(B193,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accounts Payable"},{"$f":"'Package Response (2)'!G22","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$22","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 40\"","v":"Accounts Payable S001  Row 40"}]
[null,2010150000,{"$f":"VLOOKUP(B194,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Pay-Aid Indiv/Fam"},{"$f":"'Package Response (2)'!H22","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$22","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 40\"","v":"Accounts Payable S001  Row 40"}]
[null,2010010000,{"$f":"VLOOKUP(B195,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Sales Tax Payable"},{"$f":"'Package Response (2)'!I22","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$22","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 40\"","v":"Accounts Payable S001  Row 40"}]
[null,2010030000,{"$f":"VLOOKUP(B196,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Accrued Accounts Payable"},{"$f":"'Package Response (2)'!J22","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$22","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 40\"","v":"Accounts Payable S001  Row 40"}]
[null,2010120000,{"$f":"VLOOKUP(B197,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Intergov Payable"},{"$f":"'Package Response (2)'!K22","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$22","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 40\"","v":"Accounts Payable S001  Row 40"}]
[null,2010070000,{"$f":"VLOOKUP(B198,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Payable"},{"$f":"'Package Response (2)'!L22","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$22","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 40\"","v":"Accounts Payable S001  Row 40"}]
[null,2050030000,{"$f":"VLOOKUP(B199,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Retainage Non-Current"},{"$f":"'Package Response (2)'!M22","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$22","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 40\"","v":"Accounts Payable S001  Row 40"}]
[null,2400130000,{"$f":"VLOOKUP(B200,'Lookup Tables'!$H$2:$I$9,2,FALSE)","v":"Other Current Liabilities"},{"$f":"'Package Response (2)'!N22","v":0},"C",{"$f":"'Package Response (2)'!$C$3&\"00CAFR\"","v":"S00100CAFR"},{"$f":"'Package Response (2)'!$C$3&\"_CAFR\"","v":"S001_CAFR"},{"$f":"'Package Response (2)'!$F$22","v":0},{"$f":"\"Accounts Payable \" &'Package Response (2)'!$B$3&\" \"&\" Row 40\"","v":"Accounts Payable S001  Row 40"}]

{"sheet":"Lookup Tables","index":9,"n_rows":81,"n_cols":9,"rows_kept":81,"cut":false,"hidden":true,"merged":[]}
["Agency","Agency Name","CAFR Business Area",null,"CAFR Business Area","Expense Account",null,"Payable Account","Account Name"]
["A010","Legislative Department - The Senate","A000",null,"A000",5510101010,null,2010000000,"Accounts Payable"]
["A050","Legislative Department - House of Representatives","A000",null,"H000",5510201020,null,2010150000,"Pay-Aid Indiv/Fam"]
["A150","Legislative Department - Codification of Laws & Legislative Council","A000",null,"J000",5510251025,null,2010010000,"Sales Tax Payable"]
["A170","Legislative Department - Legislative Services Agency","A000",null,"L000",5510351035,null,2010030000,"Accrued Accounts Payable"]
["A200","Legislative Department - Legislative Audit Council","A000",null,"N000",5510401040,null,2010120000,"Intergov Payable"]
["A850","Education Oversight Committee","A000",null,"P000",5510501050,null,2010070000,"Retainage Payable"]
["B040","Judicial Department","N000",null,"U000",5510601060,null,2050030000,"Retainage Non-Current"]
["C050","Administrative Law Court","A000",null,null,null,null,2400130000,"Other Current Liabilities"]
["D050","Governor's office--Executive Control of State","A000"]
["D100","State Law Enforcement Division","N000"]
["D170","Governor's office-- Executive Policy & Programs","A000"]
["D200","Governor's office--Mansion & Grounds","A000"]
["D250","office of Inspector General","A000"]
["D500","Department of Administration","A000"]
["E040","Lieutenant Governor's office","A000"]
["E080","Secretary of State's office","A000"]
["E120","Comptroller General's office","A000"]
["E160","State Treasurer's office                                                                       ","A000"]
["E200","Attorney General's office","A000"]
["E210","Commission On Prosecution Coordination ","A000"]
["E230","Commission On Indigent Defense ","A000"]
["E240","Adjutant General's office","A000"]
["E280","Election Commission","A000"]
["E500","Revenue And Fiscal Affairs office","A000"]
["E550","State Fiscal Accountability Authority","A000"]
["F030","Budget & Control Board       \n    \n","A000"]
["F270","office of The State Auditor","A000"]
["H030","Commission On Higher Education","H000"]
["H060","Higher Education Tuition Grants Commission","H000"]
["H590","State Board for Technical & Comprehensive Education","H000"]
["H630","Department of Education","H000"]
["H670","Educational Television Commission (Etv)","H000"]
["H710","Wil Lou Gray Opportunity School","H000"]
["H730","Vocational Rehabilitation","H000"]
["H750","School for The Deaf And Blind","H000"]
["H790","Department of Archives And History","H000"]
["H870","State Library","H000"]
["H910","Arts Commission","H000"]
["H950","Museum Commission","H000"]
["H960","Confederate Relic Room And Military Museum Commission","H000"]
["J020","Department of Health And Human Services","J000"]
["J040","Department of Health And Environmental Control","J000"]
["J120","Department of Mental Health","J000"]
["J160","Department of Disabilities And Special Needs","J000"]
["J200","Department of Alcohol And Other Drug Abuse Services","J000"]
["K050","Department of Public Safety","N000"]
["L040","Department of Social Services","L000"]
["L060","Division  on Aging","L000"]
["L080","Children’s Advocacy","L000"]
["L120","John De La Howe School","L000"]
["L240","Commission for The Blind","L000"]
["L360","Human Affairs Commission","L000"]
["L460","State Commission for Minority Affairs","L000"]
["N040","Department of Corrections","N000"]
["N080","Department of Probation, Parole And Pardon Services","N000"]
["N120","Department of Juvenile Justice","N000"]
["N200","Law Enforcement Training Council","N000"]
["P120","Forestry Commission","P000"]
["P160","Department of Agriculture","P000"]
["P240","Department of Natural Resources","P000"]
["P260","Sea Grant Consortium","P000"]
["P280","Department of Parks, Recreation And Tourism","P000"]
["P320","Department of Commerce","P000"]
["P400","South Carolina Conservation Bank","P000"]
["P450","Rural Infastructure Authority","P000"]
["R040","Public Service Commission","A000"]
["R060","office of Regulatory Staff","A000"]
["R080","Worker's Compensation Commission","A000"]
["R160","Second Injury Fund","A000"]
["R200","Department of Insurance","A000"]
["R230","Board of Financial Institutions","A000"]
["R280","Department of Consumer Affairs","A000"]
["R360","Department of Labor, Licensing, And Regulation","A000"]
["R400","Department of Motor Vehicles","A000"]
["R440","Department of Revenue","A000"]
["R520","State Ethics Commission","A000"]
["R600","Department of Employment And Workforce","A000"]
["S001","Sample Agency","S001"]
["S600","Procurement Review Panel","A000"]
["U300","Aeronautics Division","U000"]

{"sheet":"x3.12.1 ","index":10,"n_rows":145,"n_cols":22,"rows_kept":145,"cut":false,"hidden":true,"merged":[[0,0,0,9],[1,0,1,9],[8,3,8,4],[6,4,6,7],[34,4,34,7],[21,4,21,7],[22,4,22,7],[8,7,8,9],[5,4,5,9],[28,4,28,7],[29,4,29,7],[30,4,30,7],[31,4,31,7],[32,4,32,7],[23,4,23,7],[24,4,24,7],[55,4,55,7],[56,4,56,7],[49,4,49,7],[50,4,50,7],[51,4,51,7],[52,4,52,7],[53,4,53,7],[54,4,54,7],[46,4,46,7],[47,4,47,7],[48,4,48,7],[35,4,35,7],[33,4,33,7],[41,4,41,7],[42,4,42,7],[43,4,43,7],[44,4,44,7],[45,4,45,7],[25,4,25,7],[26,4,26,7],[27,4,27,7],[18,4,18,7],[19,4,19,7],[20,4,20,7]]}
["STATE OF SOUTH CAROLINA"]
["AP RECONCILIATION FORM"]
[null,null,null,null,null,"At June 30,",2016]
[]
[]
[null,"Agency:",null,null,{"$f":"IF(AgencyCode=\"\",\"\",VLOOKUP(AgencyCode,B68:C145,2))","v":"DEPARTMENT OF EMPLOYMENT AND WORKFORCE"},null,null,null,null,null,null,null,"AP Reconciliation Form",null,null,null,null,null,null,null,null,"3.12.1"]
[null,null,"Business Area",null,"Agency Name",null,null,null,null,null,null,null,"Use this form to reconcile the SCEIS Yearend Rptg - Prior Year Payables report provided to the payables"]
[null,null,null,null,null,null,null,null,null,null,null,null,"categorized on the Accounts Payable Summary Form (form 3.12.2)."]
[null,"Preparer (Type Name):",null,null,null,null,"Reviewer (Type Name):"]
[]
[]
[null,"Total dollar amount from the SCEIS - Prior Year Payables report provided for periods 1 and 2:",null,null,null,null,null,null,"$"]
[null,"Total dollar amount from the SCEIS - Prior Year Payables report provided for period 3-to date:",null,null,null,null,null,null,"$"]
[null,"Total dollar amount from the two SCEIS - Prior Year Payables reports provided:",null,null,null,null,null,null,"$",{"$f":"J12+J13","v":0}]
[null,"Subtract amounts on the Prior Year Payables reports that were reported on package 3.18 (read Instructions lines 40-50):",null,null,null,null,null,null,"$"]
[null,"Subtract amounts on the Prior Year Payables reports that should not be reported on this package:"]
[null,null,"Fund","Document"]
[null,null,"Number","Number","Reason/Explanation",null,null,null,null,"Amount"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Total (This Page)","$",{"$f":"SUM(J19:J36)","v":0}]
[null,null,null,null,null,null,null,"Totals from additional worksheets, if needed","$"]
[null,"Add amounts that should be reported on this package but are not included on the Prior Year Payables reports:"]
[null,null,"Fund","Document"]
[null,null,"Number","Number","Reason/Explanation",null,null,null,null,"Amount"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Total (This Page)","$",{"$f":"SUM(J42:J57)","v":0}]
[null,null,null,null,null,null,null,"Totals from additional worksheets, if needed","$"]
[null,"Actual accounts payables to be reported in the CAFR, categorize on form 3.12.2:",null,null,null,null,null,null,"$",{"$f":"J14-J15-J37-J38+J58+J59","v":0}]
[]
[]
["NOTE:  If additional space is needed, please click the button."]
[null,null,null,null,null,null,"SET MACROS TO ENABLE"]
[]
[]
[null,"AGCY  CODE","AGENCY NAME"]
[null,"A010","LEGISLATIVE DEPARTMENT - THE SENATE"]
[null,"A050","LEGISLATIVE DEPARTMENT - HOUSE OF REPRESENTATIVES"]
[null,"A150","LEGISLATIVE DEPARTMENT - CODIFICATION OF LAWS & LEGISLATIVE COUNCIL"]
[null,"A170","LEGISLATIVE DEPARTMENT - LEGISLATIVE SERVICES AGENCY"]
[null,"A200","LEGISLATIVE DEPARTMENT - LEGISLATIVE AUDIT COUNCIL"]
[null,"A850","EDUCATION OVERSIGHT COMMITTEE"]
[null,"B040","JUDICIAL DEPARTMENT"]
[null,"C050","ADMINISTRATIVE LAW COURT"]
[null,"D050","GOVERNOR'S OFFICE--EXECUTIVE CONTROL OF STATE"]
[null,"D100","STATE LAW ENFORCEMENT DIVISION"]
[null,"D170","GOVERNOR'S OFFICE-- EXECUTIVE POLICY & PROGRAMS"]
[null,"D200","GOVERNOR'S OFFICE--MANSION & GROUNDS"]
[null,"D250","OFFICE OF INSPECTOR GENERAL"]
[null,"D500","DEPARTMENT OF ADMINISTRATION"]
[null,"E040","LIEUTENANT GOVERNOR'S OFFICE"]
[null,"E080","SECRETARY OF STATE'S OFFICE"]
[null,"E120","COMPTROLLER GENERAL'S OFFICE\n"]
[null,"E160","STATE TREASURER'S OFFICE                                                                       "]
[null,"E190","RETIREMENT SYSTEM  INVESTMENT COMMISSION"]
[null,"E200","ATTORNEY GENERAL'S OFFICE"]
[null,"E210","COMMISSION ON PROSECUTION COORDINATION "]
[null,"E230","COMMISSION ON INDIGENT DEFENSE "]
[null,"E240","ADJUTANT GENERAL'S OFFICE"]
[null,"E280","ELECTION COMMISSION"]
[null,"E500","REVENUE AND FISCAL AFFAIRS OFFICE"]
[null,"E550","STATE FISCAL ACCOUNTABILITY AUTHORITY"]
[null,"F030","BUDGET & CONTROL BOARD       \n    \n"]
[null,"F270","OFFICE OF THE STATE AUDITOR"]
[null,"H030","COMMISSION ON HIGHER EDUCATION"]
[null,"H060","HIGHER EDUCATION TUITION GRANTS COMMISSION"]
[null,"H590","STATE BOARD FOR TECHNICAL & COMPREHENSIVE EDUCATION"]
[null,"H630","DEPARTMENT OF EDUCATION"]
[null,"H670","EDUCATIONAL TELEVISION COMMISSION (ETV)"]
[null,"H710","WIL LOU GRAY OPPORTUNITY SCHOOL"]
[null,"H730","VOCATIONAL REHABILITATION"]
[null,"H750","SCHOOL FOR THE DEAF AND BLIND"]
[null,"H790","DEPARTMENT OF ARCHIVES AND HISTORY"]
[null,"H870","STATE LIBRARY"]
[null,"H910","ARTS COMMISSION"]
[null,"H950","MUSEUM COMMISSION"]
[null,"H960","CONFEDERATE RELIC ROOM AND MILITARY MUSEUM COMMISSION"]
[null,"J020","DEPARTMENT OF HEALTH AND HUMAN SERVICES"]
[null,"J040","DEPARTMENT OF HEALTH AND ENVIRONMENTAL CONTROL"]
[null,"J120","DEPARTMENT OF MENTAL HEALTH"]
[null,"J160","DEPARTMENT OF DISABILITIES AND SPECIAL NEEDS"]
[null,"J200","DEPARTMENT OF ALCOHOL AND OTHER DRUG ABUSE SERVICES"]
[null,"K050","DEPARTMENT OF PUBLIC SAFETY"]
[null,"L040","DEPARTMENT OF SOCIAL SERVICES"]
[null,"L120","JOHN DE LA HOWE SCHOOL"]
[null,"L240","COMMISSION FOR THE BLIND"]
[null,"L360","HUMAN AFFAIRS COMMISSION"]
[null,"L460","STATE COMMISSION FOR MINORITY AFFAIRS"]
[null,"N040","DEPARTMENT OF CORRECTIONS"]
[null,"N080","DEPARTMENT OF PROBATION, PAROLE AND PARDON SERVICES"]
[null,"N120","DEPARTMENT OF JUVENILE JUSTICE"]
[null,"N200","LAW ENFORCEMENT TRAINING COUNCIL"]
[null,"P120","FORESTRY COMMISSION"]
[null,"P160","DEPARTMENT OF AGRICULTURE"]
[null,"P240","DEPARTMENT OF NATURAL RESOURCES"]
[null,"P260","SEA GRANT CONSORTIUM"]
[null,"P280","DEPARTMENT OF PARKS, RECREATION AND TOURISM"]
[null,"P320","DEPARTMENT OF COMMERCE"]
[null,"P400","SOUTH CAROLINA CONSERVATION BANK"]
[null,"P450","RURAL INFASTRUCTURE AUTHORITY"]
[null,"R040","PUBLIC SERVICE COMMISSION"]
[null,"R060","OFFICE OF REGULATORY STAFF"]
[null,"R080","WORKER'S COMPENSATION COMMISSION"]
[null,"R160","SECOND INJURY FUND"]
[null,"R200","DEPARTMENT OF INSURANCE"]
[null,"R230","BOARD OF FINANCIAL INSTITUTIONS"]
[null,"R280","DEPARTMENT OF CONSUMER AFFAIRS"]
[null,"R360","DEPARTMENT OF LABOR, LICENSING, AND REGULATION"]
[null,"R400","DEPARTMENT OF MOTOR VEHICLES"]
[null,"R440","DEPARTMENT OF REVENUE"]
[null,"R520","STATE ETHICS COMMISSION"]
[null,"R600","DEPARTMENT OF EMPLOYMENT AND WORKFORCE"]
[null,"S600","PROCUREMENT REVIEW PANEL"]
[null,"U300","AERONAUTICS DIVISION"]

{"sheet":"x3.12.1","index":11,"n_rows":200,"n_cols":10,"rows_kept":200,"cut":false,"hidden":true,"merged":[[82,4,82,8],[83,4,83,8],[84,4,84,8],[93,4,93,8],[94,4,94,8],[95,4,95,8],[59,4,59,8],[75,4,75,8],[76,4,76,8],[77,4,77,8],[78,4,78,8],[79,4,79,8],[70,4,70,8],[71,4,71,8],[72,4,72,8],[73,4,73,8],[74,4,74,8],[90,4,90,8],[91,4,91,8],[92,4,92,8],[85,4,85,8],[86,4,86,8],[87,4,87,8],[88,4,88,8],[89,4,89,8],[80,4,80,8],[81,4,81,8],[96,4,96,8],[33,4,33,8],[34,4,34,8],[35,4,35,8],[36,4,36,8],[37,4,37,8],[38,4,38,8],[39,4,39,8],[40,4,40,8],[41,4,41,8],[42,4,42,8],[43,4,43,8],[53,4,53,8],[54,4,54,8],[55,4,55,8],[46,4,46,8],[47,4,47,8],[48,4,48,8],[49,4,49,8],[50,4,50,8],[45,4,45,8],[69,4,69,8],[51,4,51,8],[52,4,52,8],[25,4,25,8],[26,4,26,8],[27,4,27,8],[28,4,28,8],[29,4,29,8],[68,4,68,8],[20,4,20,8],[21,4,21,8],[22,4,22,8],[23,4,23,8],[24,4,24,8],[32,4,32,8],[65,4,65,8],[66,4,66,8],[67,4,67,8],[30,4,30,8],[56,4,56,8],[57,4,57,8],[58,4,58,8],[108,4,108,8],[109,4,109,8],[97,4,97,8],[98,4,98,8],[99,4,99,8],[100,4,100,8],[101,4,101,8],[102,4,102,8],[103,4,103,8],[104,4,104,8],[105,4,105,8],[106,4,106,8],[112,4,112,8],[113,4,113,8],[114,4,114,8],[115,4,115,8],[116,4,116,8],[117,4,117,8],[0,0,0,9],[1,0,1,9],[5,4,5,9],[6,4,6,7],[8,3,8,4],[8,7,8,9],[14,4,14,8],[31,4,31,8],[44,4,44,8],[15,4,15,8],[16,4,16,8],[17,4,17,8],[18,4,18,8],[19,4,19,8],[110,4,110,8],[111,4,111,8],[64,4,64,8],[107,4,107,8]]}
["STATE OF SOUTH CAROLINA"]
["AP RECONCILIATION FORM"]
[null,null,null,null,null,"At June 30,",{"$f":"IF(YEAR=\"\",\"\",YEAR)","v":""}]
[]
[]
[null,"Agency:",{"$f":"IF(AgencyCode=\"\",\"\",AgencyCode)","v":"S001"},null,{"$f":"IF(AgencyName=\"\",\"\",AgencyName)","v":{"$error":"#NAME?"}}]
[null,null,"Business Area",null,"Agency Name"]
[]
[null,"Preparer (Type Name):",null,{"$f":"IF(PREPARER=\"\",\"\",PREPARER)","v":"Sample Preparer"},null,null,"Reviewer (Type Name):",{"$f":"IF(REVIEWER=\"\",\"\",REVIEWER)","v":"Sample Reviewer"}]
[]
[]
[null,"Subtract amounts on the Prior Year Payables reports that should not be reported on this package:"]
[null,null,"Fund","Document"]
[null,null,"Number","Number","Reason/Explanation",null,null,null,null,"Amount"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J15:J60)","v":0}]
[null,"Add amounts that should be reported on this package but are not included on the Prior Year Payables reports:"]
[null,null,"Fund","Document"]
[null,null,"Number","Number","Reason/Explanation",null,null,null,null,"Amount"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"SUM(J65:J118)","v":0}]
[]
["NOTE:  If additional space is needed, please click the button."]
[null,null,null,null,null,null,"SET MACROS TO ENABLE"]
[]
[]
[null,"AGCY  CODE","AGENCY NAME"]
[null,"A01","LEGISLATIVE DEPARTMENT - THE SENATE"]
[null,"A05","LEGISLATIVE DEPARTMENT - HOUSE OF REPRESENTATIVES"]
[null,"A15","LEGISLATIVE DEPARTMENT - CODIFICATION OF LAWS & LEGISLATIVE COUNCIL"]
[null,"A17","LEGISLATIVE DEPARTMENT - LEGISLATIVE PRINTING & INFORMATION TECHNICAL SYSTEMS"]
[null,"A20","LEGISLATIVE DEPARTMENT - LEGISLATIVE AUDIT COUNCIL"]
[null,"A85","EDUCATION OVERSIGHT COMMITTEE"]
[null,"B04","JUDICIAL DEPARTMENT"]
[null,"C05","ADMINISTRATIVE LAW JUDGES"]
[null,"D05","GOVERNOR'S OFFICE--EXECUTIVE CONTROL OF STATE"]
[null,"D10","GOVERNOR'S OFFICE--STATE LAW ENFORCEMENT DIVISION"]
[null,"D17","GOVERNOR'S OFFICE-- EXECUTIVE POLICY & PROGRAMS"]
[null,"D20","GOVERNOR'S OFFICE--MANSION & GROUNDS"]
[null,"D25","INSPECTOR GENERAL"]
[null,"E04","LIEUTENANT GOVERNOR'S OFFICE"]
[null,"E08","SECRETARY OF STATE'S OFFICE"]
[null,"E12","COMPTROLLER GENERAL'S OFFICE\nW90 - DUES AND CONTRIBUTIONS (Note 1)\nX12 - AID TO SUBDIVISIONS--COMPTROLLER GENERAL (Note 1)"]
[null,"E16","STATE TREASURER'S OFFICE  \nE17-TOBACCO SETTLEMENT REVENUE MANAGEMENT AUTHORITY\nV04 - DEBT SERVICE C/O STATE TREASURER (Note 2)   \nX22 - AID TO SUBDIVISIONS--STATE TREASURER   (Note 2)                                                                        "]
[null,"E19","RETIREMENT SYSTEM  INVESTMENT COMMISSION"]
[null,"E20","ATTORNEY GENERAL'S OFFICE"]
[null,"E21","PROSECUTION COORDINATION  COMMISSION"]
[null,"E23","COMMISSION ON INDIGENT DEFENSE (Note 9)"]
[null,"E24","ADJUTANT GENERAL'S OFFICE\n(E25) STATE ACTIVITY DUTY (Note 8)"]
[null,"E28","ELECTION COMMISSION"]
[null,"F03","BUDGET & CONTROL BOARD       \n    \n"]
[null,"F27","STATE AUDITOR"]
[null,"H03","COMMISSION ON HIGHER EDUCATION"]
[null,"H06","HIGHER EDUCATION TUITION GRANTS COMMISSION"]
[null,"H59","BOARD FOR TECHNICAL & COMPREHENSIVE EDUCATION"]
[null,"H63","DEPARTMENT OF EDUCATION"]
[null,"H67","EDUCATIONAL TELEVISION COMMISSION (ETV)"]
[null,"H71","WIL LOU GRAY OPPORTUNITY SCHOOL"]
[null,"H73","VOCATIONAL REHABILITATION"]
[null,"H75","SCHOOL FOR THE DEAF AND BLIND"]
[null,"H79","DEPARTMENT OF ARCHIVES AND HISTORY"]
[null,"H87","STATE LIBRARY"]
[null,"H91","ARTS COMMISSION"]
[null,"H95","MUSEUM COMMISSION"]
[null,"J02","DEPARTMENT OF HEALTH AND HUMAN SERVICES"]
[null,"J04","DEPARTMENT OF HEALTH AND ENVIRONMENTAL CONTROL"]
[null,"J12","DEPARTMENT OF MENTAL HEALTH"]
[null,"J16","DEPARTMENT OF DISABILITIES AND SPECIAL NEEDS"]
[null,"J20","DEPARTMENT OF ALCOHOL AND OTHER DRUG ABUSE SERVICES"]
[null,"K05","DEPARTMENT OF PUBLIC SAFETY"]
[null,"L04","DEPARTMENT OF SOCIAL SERVICES"]
[null,"L12","JOHN DE LA HOWE SCHOOL"]
[null,"L24","COMMISSION FOR THE BLIND"]
[null,"L36","HUMAN AFFAIRS COMMISSION"]
[null,"L46","STATE COMMISSION FOR MINORITY AFFAIRS"]
[null,"N04","DEPARTMENT OF CORRECTIONS"]
[null,"N08","DEPARTMENT OF PROBATION, PAROLE AND PARDON"]
[null,"N12","DEPARTMENT OF JUVENILE JUSTICE"]
[null,"N20","LAW ENFORCEMENT TRAINING COUNCIL"]
[null,"P12","FORESTRY COMMISSION"]
[null,"P16","DEPARTMENT OF AGRICULTURE"]
[null,"P24","DEPARTMENT OF NATURAL RESOURCES"]
[null,"P26","SEA GRANT CONSORTIUM"]
[null,"P28","DEPARTMENT OF PARKS, RECREATION AND TOURISM"]
[null,"P32","DEPARTMENT OF COMMERCE\nY08 -  Public Railways Commission (Note 7)"]
[null,"P40","SOUTH CAROLINA CONSERVATION BANK"]
[null,"P45","RURAL INFASTRUCTURE AUTHORITY"]
[null,"R04","PUBLIC SERVICE COMMISSION"]
[null,"R06","OFFICE OF REGULATORY STAFF"]
[null,"R08","WORKER'S COMPENSATION COMMISSION"]
[null,"R20","DEPARTMENT OF INSURANCE"]
[null,"R23","BOARD OF FINANCIAL INSTITUTIONS"]
[null,"R28","DEPARTMENT OF CONSUMER AFFAIRS"]
[null,"R36","DEPARTMENT OF LABOR, LICENSING, AND REGULATION"]
[null,"R40","DEPARTMENT OF MOTOR VEHICLES"]
[null,"R44","DEPARTMENT OF REVENUE AND TAXATION"]
[null,"R52","STATE ETHICS COMMISSION"]
[null,"R60","DEPARTMENT OF EMPLOYMENT WORKFORCE"]
[null,"S60","PROCUREMENT REVIEW PANEL"]
[null,"U30","AERONAUTICS DIVISION"]
[null,"X22","AID TO SUBDIVISIONS--STATE TREASURER   (Note 2)"]
[null,"X44","AID TO SUBDIVISIONS--DEPARTMENT OF REVENUE   (Note 2)"]