{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Instructions","Signature Page","3.06.1 ","3.06.1 (2)","Reviewer Checklist","Package Response","Inventory JE Prep INV01","Business Area Lookup"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":8,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":60,"n_cols":6,"rows_kept":60,"cut":false,"hidden":false,"merged":[[0,0,0,9],[40,1,40,10],[56,4,56,6],[44,4,44,6],[2,0,2,9],[1,0,1,9]]}
["State of South Carolina"]
["Section 3.06, Inventory Reporting Package"]
["Fiscal Year 2019 GAAP Reporting"]
[]
[null,"Purpose and Objective:"]
[null,"It is the State's policy to report the value of United States Department of Agriculture food supplies "]
[null,"(commodities) on hand as of the end of the fiscal year as inventory.  This reporting package collects "]
[null,"information regarding the value of inventories held by agencies."]
[]
[null,"The agency is responsible for tracking items held in inventory and valuing that inventory as of June 30."]
[null,"The physical count of inventory is an important control for protecting assets and accurate reporting that "]
[null,"should be performed at least annually.  Therefore the agency is required to perform a physical count of "]
[null,"inventory as close to year-end as possible.  See the Reporting Policies and Procedures Manual for "]
[null,"further guidance."]
[]
[null,"If questions arise that can not be answered by the Reporting Policies and Procedures Manual, please contact"]
[null,"the Financial Reporting Division of the Comptroller General's Office."]
[]
[null,"Instructions for Completion of the Form(s):"]
[null,"Use the macro button to create as many copies of the form(s) as is required."]
[null,"Enter the information requested by the descriptions of each field."]
[null,"●   Features within the forms to assist in completion include:"]
[null,"►    Drop-down menus are available to assist in the responses to questions on the forms."]
[null,"►    Validation checks for the appropriate number of characters is included for the fund number and "]
[null,"general ledger account number."]
[null,"►    Dollar amounts requested are restricted by edit checks for positive whole numbers."]
[null,"►    Further instructions are generated by the forms based on information input into the forms, follow the "]
[null,"instructions as they appear."]
[null,"►    Where appropriate fields are calculated. The agency is responsible for confirming the accuracy"]
[null,"of the calculations.  "]
[null,"●   State policy requires a physical count be taken between  April 1 and year-end.  Agencies must"]
[null,"notify the State Auditor's Office of inventory dates. Reconciliations between the physical count and "]
[null,"the June 30 valuation reported on this form should be retained in the accounting records of the agency. "]
[null,"Upon completion of the information requested:"]
[null,"●   The individual completing the form(s) should review the form(s) for accuracy and completeness prior to "]
[null,"signing the signature page.  "]
[null,"●   The Finance Director or Executive Director should review and approve the form(s) before signing the  "]
[null,"signature page and sending the form(s) to the Comptroller General's Office."]
[null,"●   Both the preparer and reviewer certify that the information provided on this reporting package"]
[null,"is complete and accurate to the best of their knowledge."]
[null,"●   Send the Excel file to the Comptroller General's Office (CAFR@cg.sc.gov) no later than August 9, 2019"]
[null,"●   The agency should retain a copy of the completed form(s) as part of its year-end working papers.  The"]
[null,"Comptroller General's Office will contact the individual completing the form if there are any questions."]
[]
[null,"Signature Page",null,null,"Signature Page"]
[null,"This form should be completed, printed, signed and a PDF copy of the signed sheet sent via e-mail to the "]
[null,"Comptroller General's office when the Excel file of the related reporting package is sent."]
[]
[null,"Inventory Summary Form",null,null,null,"3.06.1"]
[null,"Use this form to report all inventory including commodity inventory. This form provides a means to adjust what"]
[null,"is recorded in SCEIS as inventory to actual inventory. The SCEIS Yearend Rptg - Inventory report will be "]
[null,"e-mailed to the GAAP contact(s) for your agency in early August. This report is based on what is recorded in "]
[null,"SCEIS for your agency and will be reported in the CAFR as inventory if no adjustments are made on this form."]
[null,"If your agency did not notify the State Auditor's Office when you planned to take inventory, please notify them of "]
[null,"the inventory dates. In the future please notify the State Auditor's Office before the inventories are performed."]
[]
[null,"Reviewer Checklist",null,null,"Reviewer Checklist"]
[null,"Use this Checklist as a mechanism for review.  It should be completed prior to reviewer's signature on"]
[null,"the signature page.  Upon completion of the checklist, include the responses in the submitted Excel file and "]
[null,"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":[[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],[17,4,17,5],[52,1,52,5],[53,1,53,5],[54,1,54,5],[55,1,55,5],[31,4,31,5],[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]]}
[null,"State of South Carolina"]
[null,"Section 3.06, Inventory Reporting Package"]
[null,"Signature Page"]
[null,"Fiscal Year 2019"]
[]
[null,null,"Agency",null,{"$f":"IF(C6=\"\",\"\",VLOOKUP(C6,'Business Area Lookup'!A5:B85,2,FALSE))","v":"Agency Name"}]
[null,null,"Business Area",null,"Agency Name"]
[]
[]
[null,null,"Preparer","Signature:",null,null," "]
[]
[null,null,null,"Date:",null,null," "]
[]
[null,null,null,"Name:",null,null," "]
[]
[null,null,null,"Title:",null,null," "]
[]
[null,null,null,"e-mail:",null,null," "]
[]
[null,null,null,"Phone Number:",null,null," "]
[]
[null,null,"Reviewer","Signature:",null,null," "]
[]
[null,null,null,"Date:"]
[]
[null,null,null,"Name:"]
[]
[null,null,null,"Title:",null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,"e-mail:",null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,"Phone Number:",null,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.06 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.06.1 ","index":2,"n_rows":54,"n_cols":16,"rows_kept":54,"cut":false,"hidden":false,"merged":[[47,1,47,3],[47,9,47,10],[48,1,48,3],[48,9,48,10],[46,1,46,3],[46,9,46,10],[39,9,39,10],[41,9,41,10],[42,9,42,10],[43,9,43,10],[44,9,44,10],[32,1,32,3],[32,9,32,10],[0,0,0,11],[5,0,5,2],[6,0,6,2],[6,5,6,10],[2,0,2,11],[3,0,3,11],[1,0,1,11],[30,1,30,3],[30,9,30,10],[31,1,31,3],[31,9,31,10],[9,8,9,10],[28,9,28,10],[7,0,7,2],[7,5,7,10],[12,0,12,2],[26,0,26,2],[24,1,24,10],[9,3,9,5],[44,1,44,3],[45,1,45,3],[33,9,33,10],[37,1,37,3],[37,9,37,10],[34,9,34,10],[35,1,35,3],[35,9,35,10],[36,1,36,3],[36,9,36,10],[42,1,42,3],[43,1,43,3],[41,1,41,3],[34,1,34,3],[33,1,33,3],[45,9,45,10]]}
["State of South Carolina"]
["Section 3.06, Inventory Reporting Package"]
["Inventory Summary Form"]
["At June 30, 2019"]
[]
[]
["  Agency:",null,null,{"$f":"'Signature Page'!C6","v":"Agency"},null,{"$f":"IF(AgencyCode=\"\",\"\",VLOOKUP(AgencyCode,'Business Area Lookup'!A4:C85,2,FALSE))","v":"Agency Name"}]
[null,null,null,null,null,"Agency Name"]
[]
[null,"Preparer:",null,null,null,null,null,"Reviewer:"]
[null,null,null,null,"(Type Name)",null,null,null,null,"(Type Name)"]
[]
[]
["The report provided is based on what is recorded in SCEIS for your agency, the amount from the report should be",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["adjusted to actual inventory."]
[]
["Total dollar amount from the SCEIS Inventory report provided",null,null,null,null,null,null,null,null,"$"]
[]
["Does the report provided accurately report all inventory balances as of June 30?"]
[]
[null,{"$f":"IF(K19=\"\",\"\",IF(K19=\"Yes\",\"STOP. Submit the form.\",\"Answer Next Question.\"))","v":""}]
[]
["Enter the value of the inventory based on the physical count and any required reconciliation.",null,null,null,null,null,null,null,null,"$"]
[]
[null,{"$f":"IF(B21=\"STOP. Submit the form.\",\"\",IF(K17=\"\",\"Enter the value of the inventory from the Yearend Rptg - Inventory report.\",IF(K23=\"\",\"Enter the value of the inventory based on the physical count.\",IF(K23=K17,\"STOP. Submit the form.\",\"ENTER THE INFORMATION REQUESTED BELOW to adjust the general ledger to the value from physical count.\"))))","v":"Enter the value of the inventory from the Yearend Rptg - Inventory report."}]
[]
[]
[null,"Add amounts that should be reported on this package but are not included on the Inventory report:"]
[null,null,null,null,null,"Fund",null,"Dollar Amount","Exp Acct","Comments"]
[]
[null,null,null,null,null,null,"$"]
[]
[]
[]
[]
[]
[]
[]
[null,"Subtract amounts on the Inventory report that should not be reported on this package:"]
[null,null,null,null,null,"Fund",null,"Dollar Amount","Exp Acct","Comments"]
[]
[null,null,null,null,null,null,"$"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Enter amount from additional worksheet(s), if necessary",null,null,null,null,null,{"$f":"'3.06.1 (2)'!H40","v":0}]
["ENTRY TOTAL",null,null,null,null,null,"$",{"$f":"SUM(H31:H38)-SUM(H42:H49)+H51","v":0},null,null,{"$f":"IF(K19=\"Yes\",\"\",K23-K17)","v":0}]
[]
[null,{"$f":"IF(K$23=\"\",\"\",IF(K$17=K$23,\"THANK YOU, the general ledger is in balance with your physical count.\",IF(K$52<>H$52,\"ADDITIONAL INFORMATION IS NEEDED, the total difference is not equal to the total from the lines of the entry entered.\",\"THANK YOU, the entry provided will allow for adjustment of the general ledger for proper reporting.\")))","v":""}]

{"sheet":"3.06.1 (2)","index":3,"n_rows":44,"n_cols":10,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,0,0,11],[1,0,1,11],[2,0,2,11],[3,0,3,11],[9,3,9,5],[9,8,9,10],[12,0,12,2],[27,9,27,10],[5,0,5,2],[6,0,6,2],[6,5,6,10],[7,0,7,2],[7,5,7,10],[14,9,14,10],[16,1,16,3],[16,9,16,10],[17,1,17,3],[17,9,17,10],[18,1,18,3],[18,9,18,10],[19,1,19,3],[19,9,19,10],[31,1,31,3],[31,9,31,10],[36,1,36,3],[36,9,36,10],[29,1,29,3],[29,9,29,10],[30,1,30,3],[30,9,30,10],[32,1,32,3],[32,9,32,10],[38,1,38,3],[38,9,38,10],[33,1,33,3],[33,9,33,10],[34,1,34,3],[34,9,34,10],[35,1,35,3],[35,9,35,10],[37,1,37,3],[37,9,37,10],[20,1,20,3],[20,9,20,10],[24,1,24,3],[24,9,24,10],[25,1,25,3],[25,9,25,10],[21,1,21,3],[21,9,21,10],[22,1,22,3],[22,9,22,10],[23,1,23,3],[23,9,23,10]]}
["State of South Carolina"]
["Section 3.06, Inventory Reporting Package"]
["Inventory Summary Form"]
["At June 30, 2019"]
[]
[]
["  Agency:",null,null,{"$f":"IF('3.06.1 '!AgencyCode=\"\",\"\",'3.06.1 '!AgencyCode)","v":"Agency"},null,{"$f":"IF('3.06.1 '!F7=\"\",\"\",'3.06.1 '!F7)","v":"Agency Name"}]
[null,null,null,"Business Area",null,"Agency Name"]
[]
[null,"Preparer:",null,{"$f":"IF('3.06.1 '!D10=\"\",\"\",'3.06.1 '!D10)","v":""},null,null,null,"Reviewer:",{"$f":"IF('3.06.1 '!I10=\"\",\"\",'3.06.1 '!I10)","v":""}]
[null,null,null,null,"(Type Name)",null,null,null,null,"(Type Name)"]
[]
[]
[null,"Add additional amounts that should be reported on this package but are not included on the Inventory report:"]
[null,null,null,null,null,"Fund",null,"Dollar Amount","Exp Acct","Comments"]
[]
[null,null,null,null,null,null,"$"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Subtract additional amounts on the Inventory report that should not be reported on this package:"]
[null,null,null,null,null,"Fund",null,"Dollar Amount","Exp Acct","Comments"]
[]
[null,null,null,null,null,null,"$"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["SHEET TOTAL",null,null,null,null,null,"$",{"$f":"SUM(H17:H26)-SUM(H30:H39)","v":0}]
[]
[]
[]
["NOTE:  If additional space is needed, please contact the CG's Office."]

{"sheet":"Reviewer Checklist","index":4,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,1,0,11],[1,1,1,11],[2,1,2,11],[3,1,3,11]]}
[null,"State of South Carolina"]
[null,"Section 3.06, Inventory Reporting Package"]
[null,"Reviewer Checklist"]
[null,"Fiscal Year 2019"]
[]
[null,null,{"$f":"IF('3.06.1 '!AgencyCode=\"\",\"\",'3.06.1 '!AgencyCode)","v":"Agency"}]
[null,null,"Business Area",null,null,null,null,"Date Last Review Step Was Completed:   "]
[]
["Reviewer's Responses:"]
[{"$f":"IF(B10=\"y\",COUNTA(B$9:B10),\"\")","v":1},"y","Is the reviewer of the form(s) someone other than the person who prepared it?"]
[{"$f":"IF(B11=\"y\",COUNTA(B$9:B11),\"\")","v":""}]
[{"$f":"IF(B12=\"y\",COUNTA(B$9:B12),\"\")","v":2},"y","Is the contact information (i.e. title, email, and telephone number) for the preparer"]
[{"$f":"IF(B13=\"y\",COUNTA(B$9:B13),\"\")","v":""},null," and reviewer accurately reported on the signature page?"]
[{"$f":"IF(B14=\"y\",COUNTA(B$9:B14),\"\")","v":""}]
[{"$f":"IF(B15=\"y\",COUNTA(B$9:B15),\"\")","v":3},"y","Has all inventory been accounted for and included in the official agency accounting "]
[{"$f":"IF(B16=\"y\",COUNTA(B$9:B16),\"\")","v":""},null,"records?"]
[{"$f":"IF(B17=\"y\",COUNTA(B$9:B17),\"\")","v":""}]
[{"$f":"IF(B18=\"y\",COUNTA(B$9:B18),\"\")","v":4},"y","Can all amounts reported on each form be traced to official agency "]
[{"$f":"IF(B19=\"y\",COUNTA(B$9:B19),\"\")","v":""},null,"accounting records?"]
[{"$f":"IF(B20=\"y\",COUNTA(B$9:B20),\"\")","v":""}]
[{"$f":"IF(B21=\"y\",COUNTA(B$9:B21),\"\")","v":5},"y","Is the relationship between the SCEIS balance and the inventory records "]
[{"$f":"IF(B22=\"y\",COUNTA(B$9:B22),\"\")","v":""},null,"properly reported?"]
[{"$f":"IF(B23=\"y\",COUNTA(B$9:B23),\"\")","v":""}]
[{"$f":"IF(B24=\"y\",COUNTA(B$9:B24),\"\")","v":6},"y","Have the instructions invoked by completion of form(s) fields been accurately "]
[{"$f":"IF(B25=\"y\",COUNTA(B$9:B25),\"\")","v":""},null,"followed?"]
[{"$f":"IF(B26=\"y\",COUNTA(B$9:B26),\"\")","v":""}]
[{"$f":"IF(B27=\"y\",COUNTA(B$9:B27),\"\")","v":7},"y","If required by conditional form instructions, has accurate fund numbers"]
[{"$f":"IF(B28=\"y\",COUNTA(B$9:B28),\"\")","v":""},null,"been provided?"]
[{"$f":"IF(B29=\"y\",COUNTA(B$9:B29),\"\")","v":""}]
[{"$f":"IF(B30=\"y\",COUNTA(B$9:B30),\"\")","v":8},"y","If required by conditional form instructions, has accurate expense "]
[{"$f":"IF(B31=\"y\",COUNTA(B$9:B31),\"\")","v":""},null,"account numbers been provided for each amount?"]
[{"$f":"IF(B32=\"y\",COUNTA(B$9:B32),\"\")","v":""}]
[{"$f":"IF(B33=\"y\",COUNTA(B$9:B33),\"\")","v":9},"y","Do the balances reported on the form agree with the physical count "]
[{"$f":"IF(B34=\"y\",COUNTA(B$9:B34),\"\")","v":""},null,"valuation reports as adjusted for June 30 valuation, if necessary?"]
[{"$f":"IF(B35=\"y\",COUNTA(B$9:B35),\"\")","v":""}]
[{"$f":"IF(B36=\"y\",COUNTA(B$9:B36),\"\")","v":10},"y","Has the activity been compared with the prior year, documenting causes "]
[{"$f":"IF(B37=\"y\",COUNTA(B$9:B37),\"\")","v":""},null,"for any large fluctuations that can be easily obtained and explained to "]
[{"$f":"IF(B38=\"y\",COUNTA(B$9:B38),\"\")","v":""},null,"individuals not familiar with the daily operations of the agency?"]

{"sheet":"Package Response","index":5,"n_rows":47,"n_cols":14,"rows_kept":47,"cut":false,"hidden":true,"merged":[]}
["Line","Business Area","CAFR Business Area","Agency Name","SCEIS Balance","Actual SCEIS Report","SCEIS Report Check","Is Report Accurate?","Value Based on Physical Count","Fund","Amount","GL Account","Comments","Line Text"]
[1,{"$f":"'3.06.1 '!AgencyCode","v":"Agency"},{"$f":"VLOOKUP(B2,'Business Area Lookup'!A6:C86,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"'3.06.1 '!AgencyName","v":"Agency Name"},{"$f":"'3.06.1 '!$K$17","v":0},null,null,{"$f":"'3.06.1 '!$K$19","v":0},{"$f":"'3.06.1 '!$K$23","v":0},{"$f":"'3.06.1 '!F31","v":0},{"$f":"'3.06.1 '!H31","v":0},{"$f":"'3.06.1 '!I31","v":0},{"$f":"'3.06.1 '!J31","v":0},{"$f":"\"Inventory Adjustment - \"&B2&\" Row \"&A2","v":"Inventory Adjustment - Agency Row 1"}]
[2,{"$f":"B2","v":"Agency"},{"$f":"C2","v":{"$error":"#N/A"}},{"$f":"D2","v":"Agency Name"},null,null,null,null,null,{"$f":"'3.06.1 '!F32","v":0},{"$f":"'3.06.1 '!H32","v":0},{"$f":"'3.06.1 '!I32","v":0},{"$f":"'3.06.1 '!J32","v":0},{"$f":"\"Inventory Adjustment - \"&B3&\" Row \"&A3","v":"Inventory Adjustment - Agency Row 2"}]
[3,{"$f":"B3","v":"Agency"},{"$f":"C3","v":{"$error":"#N/A"}},{"$f":"D3","v":"Agency Name"},null,null,null,null,null,{"$f":"'3.06.1 '!F33","v":0},{"$f":"'3.06.1 '!H33","v":0},{"$f":"'3.06.1 '!I33","v":0},{"$f":"'3.06.1 '!J33","v":0},"Inventory Adjustment - Agency Row 3"]
[4,"Agency",{"$error":"#N/A"},"Agency Name",null,null,null,null,null,{"$f":"'3.06.1 '!F34","v":0},{"$f":"'3.06.1 '!H34","v":0},{"$f":"'3.06.1 '!I34","v":0},{"$f":"'3.06.1 '!J34","v":0},"Inventory Adjustment - Agency Row 4"]
[5,"Agency",{"$error":"#N/A"},"Agency Name",null,null,null,null,null,{"$f":"'3.06.1 '!F35","v":0},{"$f":"'3.06.1 '!H35","v":0},{"$f":"'3.06.1 '!I35","v":0},{"$f":"'3.06.1 '!J35","v":0},"Inventory Adjustment - Agency Row 5"]
[6,"Agency",{"$error":"#N/A"},"Agency Name",null,null,null,null,null,{"$f":"'3.06.1 '!F36","v":0},{"$f":"'3.06.1 '!H36","v":0},{"$f":"'3.06.1 '!I36","v":0},{"$f":"'3.06.1 '!J36","v":0},"Inventory Adjustment - Agency Row 6"]
[7,"Agency",{"$error":"#N/A"},"Agency Name",null,null,null,null,null,{"$f":"'3.06.1 '!F37","v":0},{"$f":"'3.06.1 '!H37","v":0},{"$f":"'3.06.1 '!I37","v":0},{"$f":"'3.06.1 '!J37","v":0},"Inventory Adjustment - Agency Row 7"]
[8,"Agency",{"$error":"#N/A"},"Agency Name",null,null,null,null,null,{"$f":"'3.06.1 '!F38","v":0},{"$f":"'3.06.1 '!H38","v":0},{"$f":"'3.06.1 '!I38","v":0},{"$f":"'3.06.1 '!J38","v":0},"Inventory Adjustment - Agency Row 8"]
[]
[9,{"$f":"B9","v":"Agency"},{"$f":"C9","v":{"$error":"#N/A"}},{"$f":"D9","v":"Agency Name"},null,null,null,null,null,{"$f":"'3.06.1 '!F42","v":0},{"$f":"-'3.06.1 '!H42","v":0},{"$f":"'3.06.1 '!I42","v":0},{"$f":"'3.06.1 '!J42","v":0},{"$f":"\"Inventory Adjustment - \"&B11&\" Row \"&A11","v":"Inventory Adjustment - Agency Row 9"}]
[10,{"$f":"B11","v":"Agency"},{"$f":"C11","v":{"$error":"#N/A"}},{"$f":"D11","v":"Agency Name"},null,null,null,null,null,{"$f":"'3.06.1 '!F43","v":0},{"$f":"-'3.06.1 '!H43","v":0},{"$f":"'3.06.1 '!I43","v":0},{"$f":"'3.06.1 '!J43","v":0},"Inventory Adjustment - Agency Row 10"]
[11,{"$f":"B12","v":"Agency"},{"$f":"C12","v":{"$error":"#N/A"}},{"$f":"D12","v":"Agency Name"},null,null,null,null,null,{"$f":"'3.06.1 '!F44","v":0},{"$f":"-'3.06.1 '!H44","v":0},{"$f":"'3.06.1 '!I44","v":0},{"$f":"'3.06.1 '!J44","v":0},"Inventory Adjustment - Agency Row 11"]
[12,"Agency",{"$error":"#N/A"},"Agency Name",null,null,null,null,null,{"$f":"'3.06.1 '!F45","v":0},{"$f":"-'3.06.1 '!H45","v":0},{"$f":"'3.06.1 '!I45","v":0},{"$f":"'3.06.1 '!J45","v":0},"Inventory Adjustment - Agency Row 12"]
[13,"Agency",{"$error":"#N/A"},"Agency Name",null,null,null,null,null,{"$f":"'3.06.1 '!F46","v":0},{"$f":"-'3.06.1 '!H46","v":0},{"$f":"'3.06.1 '!I46","v":0},{"$f":"'3.06.1 '!J46","v":0},"Inventory Adjustment - Agency Row 13"]
[14,"Agency",{"$error":"#N/A"},"Agency Name",null,null,null,null,null,{"$f":"'3.06.1 '!F47","v":0},{"$f":"-'3.06.1 '!H47","v":0},{"$f":"'3.06.1 '!I47","v":0},{"$f":"'3.06.1 '!J47","v":0},"Inventory Adjustment - Agency Row 14"]
[15,"Agency",{"$error":"#N/A"},"Agency Name",null,null,null,null,null,{"$f":"'3.06.1 '!F48","v":0},{"$f":"-'3.06.1 '!H48","v":0},{"$f":"'3.06.1 '!I48","v":0},{"$f":"'3.06.1 '!J48","v":0},"Inventory Adjustment - Agency Row 15"]
[16,{"$f":"B17","v":"Agency"},{"$error":"#N/A"},"Agency Name",null,null,null,null,null,{"$f":"'3.06.1 '!F49","v":0},{"$f":"-'3.06.1 '!H49","v":0},{"$f":"'3.06.1 '!I49","v":0},{"$f":"'3.06.1 '!J49","v":0},"Inventory Adjustment - Agency Row 16"]
[]
[17,{"$f":"'3.06.1 '!AgencyCode","v":"Agency"},{"$f":"C18","v":{"$error":"#N/A"}},{"$f":"'3.06.1 '!AgencyName","v":"Agency Name"},null,null,null,null,null,{"$f":"'3.06.1 (2)'!F17","v":0},{"$f":"'3.06.1 (2)'!H17","v":0},{"$f":"'3.06.1 (2)'!I17","v":0},{"$f":"'3.06.1 (2)'!J17","v":0},{"$f":"\"Inventory Adjustment - \"&B20&\" Row \"&A20","v":"Inventory Adjustment - Agency Row 17"}]
[18,{"$f":"B20","v":"Agency"},{"$f":"C20","v":{"$error":"#N/A"}},{"$f":"D20","v":"Agency Name"},null,null,null,null,null,{"$f":"'3.06.1 (2)'!F18","v":0},{"$f":"'3.06.1 (2)'!H18","v":0},{"$f":"'3.06.1 (2)'!I18","v":0},{"$f":"'3.06.1 (2)'!J18","v":0},"Inventory Adjustment - Agency Row 18"]
[19,{"$f":"B21","v":"Agency"},{"$error":"#N/A"},"Agency Name",null,null,null,null,null,{"$f":"'3.06.1 (2)'!F19","v":0},{"$f":"'3.06.1 (2)'!H19","v":0},{"$f":"'3.06.1 (2)'!I19","v":0},{"$f":"'3.06.1 (2)'!J19","v":0},"Inventory Adjustment - Agency Row 19"]
[20,"Agency",{"$error":"#N/A"},"Agency Name",null,null,null,null,null,{"$f":"'3.06.1 (2)'!F20","v":0},{"$f":"'3.06.1 (2)'!H20","v":0},{"$f":"'3.06.1 (2)'!I20","v":0},{"$f":"'3.06.1 (2)'!J20","v":0},"Inventory Adjustment - Agency Row 20"]
[21,"Agency",{"$error":"#N/A"},"Agency Name",null,null,null,null,null,{"$f":"'3.06.1 (2)'!F21","v":0},{"$f":"'3.06.1 (2)'!H21","v":0},{"$f":"'3.06.1 (2)'!I21","v":0},{"$f":"'3.06.1 (2)'!J21","v":0},"Inventory Adjustment - Agency Row 21"]
[22,"Agency",{"$error":"#N/A"},"Agency Name",null,null,null,null,null,{"$f":"'3.06.1 (2)'!F22","v":0},{"$f":"'3.06.1 (2)'!H22","v":0},{"$f":"'3.06.1 (2)'!I22","v":0},{"$f":"'3.06.1 (2)'!J22","v":0},"Inventory Adjustment - Agency Row 22"]
[23,"Agency",{"$error":"#N/A"},"Agency Name",null,null,null,null,null,{"$f":"'3.06.1 (2)'!F23","v":0},{"$f":"'3.06.1 (2)'!H23","v":0},{"$f":"'3.06.1 (2)'!I23","v":0},{"$f":"'3.06.1 (2)'!J23","v":0},"Inventory Adjustment - Agency Row 23"]
[24,"Agency",{"$error":"#N/A"},"Agency Name",null,null,null,null,null,{"$f":"'3.06.1 (2)'!F24","v":0},{"$f":"'3.06.1 (2)'!H24","v":0},{"$f":"'3.06.1 (2)'!I24","v":0},{"$f":"'3.06.1 (2)'!J24","v":0},"Inventory Adjustment - Agency Row 24"]
[25,{"$f":"B27","v":"Agency"},{"$f":"C27","v":{"$error":"#N/A"}},{"$f":"D27","v":"Agency Name"},null,null,null,null,null,{"$f":"'3.06.1 (2)'!F25","v":0},{"$f":"'3.06.1 (2)'!H25","v":0},{"$f":"'3.06.1 (2)'!I25","v":0},{"$f":"'3.06.1 (2)'!J25","v":0},"Inventory Adjustment - Agency Row 25"]
[26,"Agency",{"$error":"#N/A"},"Agency Name",null,null,null,null,null,{"$f":"'3.06.1 (2)'!F26","v":0},{"$f":"'3.06.1 (2)'!H26","v":0},{"$f":"'3.06.1 (2)'!I26","v":0},{"$f":"'3.06.1 (2)'!J26","v":0},"Inventory Adjustment - Agency Row 26"]
[]
[27,{"$f":"B27","v":"Agency"},{"$f":"C27","v":{"$error":"#N/A"}},{"$f":"D27","v":"Agency Name"},null,null,null,null,null,{"$f":"'3.06.1 (2)'!F30","v":0},{"$f":"-'3.06.1 (2)'!H30","v":0},{"$f":"'3.06.1 (2)'!I30","v":0},{"$f":"'3.06.1 (2)'!J30","v":0},{"$f":"\"Inventory Adjustment - \"&B31&\" Row \"&A31","v":"Inventory Adjustment - Agency Row 27"}]
[28,{"$f":"B31","v":"Agency"},{"$f":"C31","v":{"$error":"#N/A"}},{"$f":"D31","v":"Agency Name"},null,null,null,null,null,{"$f":"'3.06.1 (2)'!F31","v":0},{"$f":"-'3.06.1 (2)'!H31","v":0},{"$f":"'3.06.1 (2)'!I31","v":0},{"$f":"'3.06.1 (2)'!J31","v":0},"Inventory Adjustment - Agency Row 28"]
[29,"Agency",{"$error":"#N/A"},"Agency Name",null,null,null,null,null,{"$f":"'3.06.1 (2)'!F32","v":0},{"$f":"-'3.06.1 (2)'!H32","v":0},{"$f":"'3.06.1 (2)'!I32","v":0},{"$f":"'3.06.1 (2)'!J32","v":0},"Inventory Adjustment - Agency Row 29"]
[30,"Agency",{"$error":"#N/A"},"Agency Name",null,null,null,null,null,{"$f":"'3.06.1 (2)'!F33","v":0},{"$f":"-'3.06.1 (2)'!H33","v":0},{"$f":"'3.06.1 (2)'!I33","v":0},{"$f":"'3.06.1 (2)'!J33","v":0},"Inventory Adjustment - Agency Row 30"]
[31,"Agency",{"$error":"#N/A"},"Agency Name",null,null,null,null,null,{"$f":"'3.06.1 (2)'!F34","v":0},{"$f":"-'3.06.1 (2)'!H34","v":0},{"$f":"'3.06.1 (2)'!I34","v":0},{"$f":"'3.06.1 (2)'!J34","v":0},"Inventory Adjustment - Agency Row 31"]
[32,"Agency",{"$error":"#N/A"},"Agency Name",null,null,null,null,null,{"$f":"'3.06.1 (2)'!F35","v":0},{"$f":"-'3.06.1 (2)'!H35","v":0},{"$f":"'3.06.1 (2)'!I35","v":0},{"$f":"'3.06.1 (2)'!J35","v":0},"Inventory Adjustment - Agency Row 32"]
[33,"Agency",{"$error":"#N/A"},"Agency Name",null,null,null,null,null,{"$f":"'3.06.1 (2)'!F36","v":0},{"$f":"-'3.06.1 (2)'!H36","v":0},{"$f":"'3.06.1 (2)'!I36","v":0},{"$f":"'3.06.1 (2)'!J36","v":0},"Inventory Adjustment - Agency Row 33"]
[34,"Agency",{"$error":"#N/A"},"Agency Name",null,null,null,null,null,{"$f":"'3.06.1 (2)'!F37","v":0},{"$f":"-'3.06.1 (2)'!H37","v":0},{"$f":"'3.06.1 (2)'!I37","v":0},{"$f":"'3.06.1 (2)'!J37","v":0},"Inventory Adjustment - Agency Row 34"]
[35,"Agency",{"$error":"#N/A"},"Agency Name",null,null,null,null,null,{"$f":"'3.06.1 (2)'!F38","v":0},{"$f":"-'3.06.1 (2)'!H38","v":0},{"$f":"'3.06.1 (2)'!I38","v":0},{"$f":"'3.06.1 (2)'!J38","v":0},"Inventory Adjustment - Agency Row 35"]
[36,"Agency",{"$error":"#N/A"},"Agency Name",null,null,null,null,null,{"$f":"'3.06.1 (2)'!F39","v":0},{"$f":"-'3.06.1 (2)'!H39","v":0},{"$f":"'3.06.1 (2)'!I39","v":0},{"$f":"'3.06.1 (2)'!J39","v":0},{"$f":"\"Inventory Adjustment - \"&B40&\" Row \"&A40","v":"Inventory Adjustment - Agency Row 36"}]
[]
[]
[null,null,null,null,{"$f":"SUM(E2:E40)","v":0},{"$f":"SUM(F2:F40)","v":0},null,null,{"$f":"SUM(I2:I40)","v":0},null,{"$f":"SUM(K2:K40)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"E43+K43","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"I43=K45","v":true}]

{"sheet":"Inventory JE Prep INV01","index":6,"n_rows":83,"n_cols":31,"rows_kept":83,"cut":false,"hidden":true,"merged":[]}
["O-1-1-03 Pkg Resp",null,null,null,null,null,null,null,null,null,null,null,"INV01",null,null,null,null,{"$f":"SUMIF(S$5:S$76,S1,R$5:R$76)","v":0},"D"]
[null,null,null,null,null,null,null,null,null,null,null,2019,null,null,null,null,null,{"$f":"SUMIF(S$5:S$76,S2,R$5:R$76)","v":0},"C"]
["E120","KG",{"$f":"TODAY()","v":"2019-03-20"},{"$f":"MOD(NOW(),1)","v":"15:44:02.070"},"GLCA",null,null,null,"0001","BE",{"$f":"C3","v":"2019-03-20"},{"$f":"L$2&\"0630\"","v":"20190630"},null,"YE Inventory Adjustment",null,{"$f":"SUM(R5:R76)","v":0},1400030000,"J","D","00CAFR","_CAFR","H","NOT RELEVANT",null,null,"Inventory adjustment - "," Row ",null,null,null,15]
["Bus Area","SSI","File Dt","File Tm","Trans Key","Appr Stat","Process","Appr Grp","Seq #","Doc Typ","Doc Dt","Post Dt","Ref","HeadTxt","Line #","Doc Amt","GL Acct","Line Amt","D/C","Cost","Funct","Fund","Grant","In Order","WBS","Line Text","Tax","EF-Doc#","EF-Line#","Assign#","FisPd"]
["E120","KG",{"$f":"$C$3","v":"2019-03-20"},{"$f":"$D$3","v":"15:44:02.070"},"GLCA",null,null,null,"0001","BE",{"$f":"$K$3","v":"2019-03-20"},{"$f":"$L$3","v":"20190630"},"INV01","YE Inventory Adjustment",1,{"$f":"$P$3","v":0},{"$f":"IF($A5=\"\",\"\",Q$3)","v":1400030000},{"$f":"'Package Response'!K2","v":0},"D",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!J2","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N2","v":"Inventory Adjustment - Agency Row 1"},null,null,null,null,15]
["E120","KG",{"$f":"$C$3","v":"2019-03-20"},{"$f":"$D$3","v":"15:44:02.070"},"GLCA",null,null,null,"0001","BE",{"$f":"$K$3","v":"2019-03-20"},{"$f":"$L$3","v":"20190630"},"INV01","YE Inventory Adjustment",2,{"$f":"$P$3","v":0},{"$f":"'Package Response'!L2","v":0},{"$f":"R5","v":0},"C",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"V5","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N2","v":"Inventory Adjustment - Agency Row 1"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",3,0,{"$f":"IF($A7=\"\",\"\",Q$3)","v":1400030000},{"$f":"'Package Response'!K3","v":0},"D",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!J3","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N3","v":"Inventory Adjustment - Agency Row 2"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",4,0,{"$f":"'Package Response'!L3","v":0},{"$f":"R7","v":0},"C",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"V7","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N3","v":"Inventory Adjustment - Agency Row 2"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",5,0,{"$f":"IF($A9=\"\",\"\",Q$3)","v":1400030000},{"$f":"'Package Response'!K4","v":0},"D",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!J4","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N4","v":"Inventory Adjustment - Agency Row 3"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",6,0,{"$f":"'Package Response'!L4","v":0},{"$f":"R9","v":0},"C",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"V9","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N4","v":"Inventory Adjustment - Agency Row 3"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",7,0,{"$f":"IF($A11=\"\",\"\",Q$3)","v":1400030000},{"$f":"'Package Response'!K5","v":0},"D",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!J5","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N5","v":"Inventory Adjustment - Agency Row 4"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",8,0,{"$f":"'Package Response'!L5","v":0},{"$f":"R11","v":0},"C",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"V11","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N5","v":"Inventory Adjustment - Agency Row 4"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",9,0,{"$f":"IF($A13=\"\",\"\",Q$3)","v":1400030000},{"$f":"'Package Response'!K6","v":0},"D",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!J6","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N6","v":"Inventory Adjustment - Agency Row 5"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",10,0,{"$f":"'Package Response'!L6","v":0},{"$f":"R13","v":0},"C",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"V13","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N6","v":"Inventory Adjustment - Agency Row 5"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",11,0,{"$f":"IF($A15=\"\",\"\",Q$3)","v":1400030000},{"$f":"'Package Response'!K7","v":0},"D",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!J7","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N7","v":"Inventory Adjustment - Agency Row 6"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",12,0,{"$f":"'Package Response'!L7","v":0},{"$f":"R15","v":0},"C",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"V15","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N7","v":"Inventory Adjustment - Agency Row 6"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",13,0,{"$f":"IF($A17=\"\",\"\",Q$3)","v":1400030000},{"$f":"'Package Response'!K8","v":0},"D",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!J8","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N8","v":"Inventory Adjustment - Agency Row 7"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",14,0,{"$f":"'Package Response'!L8","v":0},{"$f":"R17","v":0},"C",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"V17","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N8","v":"Inventory Adjustment - Agency Row 7"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",15,0,{"$f":"IF($A19=\"\",\"\",Q$3)","v":1400030000},{"$f":"'Package Response'!K9","v":0},"D",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!J9","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N9","v":"Inventory Adjustment - Agency Row 8"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",16,0,{"$f":"'Package Response'!L9","v":0},{"$f":"R19","v":0},"C",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"V19","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N9","v":"Inventory Adjustment - Agency Row 8"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",17,0,{"$f":"IF($A21=\"\",\"\",Q$3)","v":1400030000},{"$f":"-'Package Response'!K11","v":0},"C",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!J11","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N11","v":"Inventory Adjustment - Agency Row 9"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",18,0,{"$f":"'Package Response'!L11","v":0},{"$f":"R21","v":0},"D",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"V21","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N11","v":"Inventory Adjustment - Agency Row 9"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",19,0,{"$f":"IF($A23=\"\",\"\",Q$3)","v":1400030000},{"$f":"-'Package Response'!K12","v":0},"C",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!J12","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N12","v":"Inventory Adjustment - Agency Row 10"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",20,0,{"$f":"'Package Response'!L12","v":0},{"$f":"R23","v":0},"D",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"V23","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N12","v":"Inventory Adjustment - Agency Row 10"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",21,0,{"$f":"IF($A25=\"\",\"\",Q$3)","v":1400030000},{"$f":"-'Package Response'!K13","v":0},"C",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!J13","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N13","v":"Inventory Adjustment - Agency Row 11"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",22,0,{"$f":"'Package Response'!L13","v":0},{"$f":"R25","v":0},"D",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"V25","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N13","v":"Inventory Adjustment - Agency Row 11"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",23,0,{"$f":"IF($A27=\"\",\"\",Q$3)","v":1400030000},{"$f":"-'Package Response'!K14","v":0},"C",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!J14","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N14","v":"Inventory Adjustment - Agency Row 12"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",24,0,{"$f":"'Package Response'!L14","v":0},{"$f":"R27","v":0},"D",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"V27","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N14","v":"Inventory Adjustment - Agency Row 12"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",25,0,{"$f":"IF($A29=\"\",\"\",Q$3)","v":1400030000},{"$f":"-'Package Response'!K15","v":0},"C",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!J15","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N15","v":"Inventory Adjustment - Agency Row 13"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",26,0,{"$f":"'Package Response'!L15","v":0},{"$f":"R29","v":0},"D",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"V29","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N15","v":"Inventory Adjustment - Agency Row 13"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",25,0,{"$f":"IF($A31=\"\",\"\",Q$3)","v":1400030000},{"$f":"-'Package Response'!K16","v":0},"C",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!J16","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N16","v":"Inventory Adjustment - Agency Row 14"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",28,0,{"$f":"'Package Response'!L16","v":0},{"$f":"R31","v":0},"D",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"V31","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N16","v":"Inventory Adjustment - Agency Row 14"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",29,0,{"$f":"IF($A33=\"\",\"\",Q$3)","v":1400030000},{"$f":"-'Package Response'!K17","v":0},"C",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!J17","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N17","v":"Inventory Adjustment - Agency Row 15"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",30,0,{"$f":"'Package Response'!L17","v":0},{"$f":"R33","v":0},"D",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"V33","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N17","v":"Inventory Adjustment - Agency Row 15"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",31,0,{"$f":"IF($A35=\"\",\"\",Q$3)","v":1400030000},{"$f":"-'Package Response'!K18","v":0},"C",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!J18","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N18","v":"Inventory Adjustment - Agency Row 16"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",32,0,{"$f":"'Package Response'!L18","v":0},{"$f":"R35","v":0},"D",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"V35","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N18","v":"Inventory Adjustment - Agency Row 16"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",33,0,{"$f":"IF($A37=\"\",\"\",Q$3)","v":1400030000},{"$f":"'Package Response'!K20","v":0},"D",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!J20","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N20","v":"Inventory Adjustment - Agency Row 17"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",34,0,{"$f":"'Package Response'!L20","v":0},{"$f":"R37","v":0},"C",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"V37","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N20","v":"Inventory Adjustment - Agency Row 17"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",35,0,{"$f":"IF($A39=\"\",\"\",Q$3)","v":1400030000},{"$f":"'Package Response'!K21","v":0},"D",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!J21","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N21","v":"Inventory Adjustment - Agency Row 18"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",36,0,{"$f":"'Package Response'!L21","v":0},{"$f":"R39","v":0},"C",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"V39","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N21","v":"Inventory Adjustment - Agency Row 18"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",37,0,{"$f":"IF($A41=\"\",\"\",Q$3)","v":1400030000},{"$f":"'Package Response'!K22","v":0},"D",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!J22","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N22","v":"Inventory Adjustment - Agency Row 19"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",38,0,{"$f":"'Package Response'!L22","v":0},{"$f":"R41","v":0},"C",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"V41","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N22","v":"Inventory Adjustment - Agency Row 19"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",39,0,{"$f":"IF($A43=\"\",\"\",Q$3)","v":1400030000},{"$f":"'Package Response'!K23","v":0},"D",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!J23","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N23","v":"Inventory Adjustment - Agency Row 20"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",40,0,{"$f":"'Package Response'!L23","v":0},{"$f":"R43","v":0},"C",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"V43","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N23","v":"Inventory Adjustment - Agency Row 20"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",41,0,{"$f":"IF($A45=\"\",\"\",Q$3)","v":1400030000},{"$f":"'Package Response'!K24","v":0},"D",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!J24","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N24","v":"Inventory Adjustment - Agency Row 21"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",42,0,{"$f":"'Package Response'!L24","v":0},{"$f":"R45","v":0},"C",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"V45","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N24","v":"Inventory Adjustment - Agency Row 21"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",43,0,{"$f":"IF($A47=\"\",\"\",Q$3)","v":1400030000},{"$f":"'Package Response'!K25","v":0},"D",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!J25","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N25","v":"Inventory Adjustment - Agency Row 22"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",44,0,{"$f":"'Package Response'!L25","v":0},{"$f":"R47","v":0},"C",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"V47","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N25","v":"Inventory Adjustment - Agency Row 22"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",45,0,{"$f":"IF($A49=\"\",\"\",Q$3)","v":1400030000},{"$f":"'Package Response'!K26","v":0},"D",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!J26","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N26","v":"Inventory Adjustment - Agency Row 23"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",46,0,{"$f":"'Package Response'!L26","v":0},{"$f":"R49","v":0},"C",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"V49","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N26","v":"Inventory Adjustment - Agency Row 23"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",47,0,{"$f":"IF($A51=\"\",\"\",Q$3)","v":1400030000},{"$f":"'Package Response'!K27","v":0},"D",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!J27","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N27","v":"Inventory Adjustment - Agency Row 24"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",48,0,{"$f":"'Package Response'!L27","v":0},{"$f":"R51","v":0},"C",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"V51","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N27","v":"Inventory Adjustment - Agency Row 24"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",49,0,{"$f":"IF($A53=\"\",\"\",Q$3)","v":1400030000},{"$f":"'Package Response'!K28","v":0},"D",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!J28","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N28","v":"Inventory Adjustment - Agency Row 25"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",50,0,{"$f":"'Package Response'!L28","v":0},{"$f":"R53","v":0},"C",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"V53","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N28","v":"Inventory Adjustment - Agency Row 25"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",51,0,{"$f":"IF($A55=\"\",\"\",Q$3)","v":1400030000},{"$f":"'Package Response'!K29","v":0},"D",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!J29","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N29","v":"Inventory Adjustment - Agency Row 26"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",52,0,{"$f":"'Package Response'!L29","v":0},{"$f":"R55","v":0},"C",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"V55","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N29","v":"Inventory Adjustment - Agency Row 26"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",53,0,{"$f":"IF($A57=\"\",\"\",Q$3)","v":1400030000},{"$f":"-'Package Response'!K31","v":0},"C",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!J31","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N31","v":"Inventory Adjustment - Agency Row 27"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",54,0,{"$f":"'Package Response'!L31","v":0},{"$f":"R57","v":0},"D",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"V57","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N31","v":"Inventory Adjustment - Agency Row 27"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",55,0,{"$f":"IF($A59=\"\",\"\",Q$3)","v":1400030000},{"$f":"-'Package Response'!K32","v":0},"C",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!J32","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N32","v":"Inventory Adjustment - Agency Row 28"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",56,0,{"$f":"'Package Response'!L32","v":0},{"$f":"R59","v":0},"D",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"V59","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N32","v":"Inventory Adjustment - Agency Row 28"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",57,0,{"$f":"IF($A61=\"\",\"\",Q$3)","v":1400030000},{"$f":"-'Package Response'!K33","v":0},"C",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!J33","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N33","v":"Inventory Adjustment - Agency Row 29"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",58,0,{"$f":"'Package Response'!L33","v":0},{"$f":"R61","v":0},"D",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"V61","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N33","v":"Inventory Adjustment - Agency Row 29"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",59,0,{"$f":"IF($A63=\"\",\"\",Q$3)","v":1400030000},{"$f":"-'Package Response'!K34","v":0},"C",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!J34","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N34","v":"Inventory Adjustment - Agency Row 30"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",60,0,{"$f":"'Package Response'!L34","v":0},{"$f":"R63","v":0},"D",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"V63","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N34","v":"Inventory Adjustment - Agency Row 30"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",61,0,{"$f":"IF($A65=\"\",\"\",Q$3)","v":1400030000},{"$f":"-'Package Response'!K35","v":0},"C",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!J35","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N35","v":"Inventory Adjustment - Agency Row 31"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",62,0,{"$f":"'Package Response'!L35","v":0},{"$f":"R65","v":0},"D",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"V65","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N35","v":"Inventory Adjustment - Agency Row 31"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",63,0,{"$f":"IF($A67=\"\",\"\",Q$3)","v":1400030000},{"$f":"-'Package Response'!K36","v":0},"C",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!J36","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N36","v":"Inventory Adjustment - Agency Row 32"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",64,0,{"$f":"'Package Response'!L36","v":0},{"$f":"R67","v":0},"D",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"V67","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N36","v":"Inventory Adjustment - Agency Row 32"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",65,0,{"$f":"IF($A69=\"\",\"\",Q$3)","v":1400030000},{"$f":"-'Package Response'!K37","v":0},"C",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!J37","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N37","v":"Inventory Adjustment - Agency Row 33"},null,null,null,null,15]
["E120","KG",{"$f":"$C$3","v":"2019-03-20"},{"$f":"$D$3","v":"15:44:02.070"},"GLCA",null,null,null,"0001","BE",{"$f":"$K$3","v":"2019-03-20"},{"$f":"$L$3","v":"20190630"},"INV01","YE Inventory Adjustment",66,{"$f":"$P$3","v":0},{"$f":"'Package Response'!L37","v":0},{"$f":"R69","v":0},"D",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"V69","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N37","v":"Inventory Adjustment - Agency Row 33"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",67,0,{"$f":"IF($A71=\"\",\"\",Q$3)","v":1400030000},{"$f":"-'Package Response'!K38","v":0},"C",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!J38","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N38","v":"Inventory Adjustment - Agency Row 34"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",68,0,{"$f":"'Package Response'!L38","v":0},{"$f":"R71","v":0},"D",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"V71","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N38","v":"Inventory Adjustment - Agency Row 34"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",69,0,{"$f":"IF($A73=\"\",\"\",Q$3)","v":1400030000},{"$f":"-'Package Response'!K39","v":0},"C",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!J39","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N39","v":"Inventory Adjustment - Agency Row 35"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",70,0,{"$f":"'Package Response'!L39","v":0},{"$f":"R73","v":0},"D",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"V73","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N39","v":"Inventory Adjustment - Agency Row 35"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",71,0,{"$f":"IF($A75=\"\",\"\",Q$3)","v":1400030000},{"$f":"-'Package Response'!K40","v":0},"C",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!J40","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N40","v":"Inventory Adjustment - Agency Row 36"},null,null,null,null,15]
["E120","KG","2019-03-20","15:44:02.070","GLCA",null,null,null,"0001","BE","2019-03-20","20190630","INV01","YE Inventory Adjustment",72,0,{"$f":"'Package Response'!L40","v":0},{"$f":"R75","v":0},"D",{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$T$3","v":{"$error":"#N/A"}},{"$f":"'Package Response'!$C$2&'Inventory JE Prep INV01'!$U$3","v":{"$error":"#N/A"}},{"$f":"V75","v":0},"NOT RELEVANT",null,null,{"$f":"'Package Response'!N40","v":"Inventory Adjustment - Agency Row 36"},null,null,null,null,15]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1400030000,{"$f":"SUMIFS($R$5:$R$76,$Q$5:$Q$76,Q79,$S$5:$S$76,S79)","v":0},"D"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1400030000,{"$f":"SUMIFS($R$5:$R$76,$Q$5:$Q$76,Q80,$S$5:$S$76,S80)","v":0},"C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(R79:R80)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R81*2","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"R82=P76","v":true}]

{"sheet":"Business Area Lookup","index":7,"n_rows":85,"n_cols":3,"rows_kept":85,"cut":false,"hidden":true,"merged":[]}
[null,"STATE OF SOUTH CAROLINA"]
[null,"REPORTING ENTITY BUSINESS AREAS BY FUNCTION"]
[]
["AGCY  CODE","AGENCY NAME","CAFR Lkup"]
["Agency","Agency Name"]
["A010","LEGISLATIVE DEPARTMENT - THE SENATE","A000"]
["A050","LEGISLATIVE DEPARTMENT - HOUSE OF REPRESENTATIVES","A000"]
["A150","LEGISLATIVE DEPARTMENT - CODIFICATION OF LAWS & LEGISLATIVE COUNCIL","A000"]
["A170","LEGISLATIVE DEPARTMENT - LEGISLATIVE SERVICES AGENCY","A000"]
["A200","LEGISLATIVE DEPARTMENT - LEGISLATIVE AUDIT COUNCIL","A000"]
["A850","EDUCATION OVERSIGHT COMMITTEE","A000"]
["B040","JUDICIAL DEPARTMENT","N000"]
["C050","ADMINISTRATIVE LAW COURT","A000"]
["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\n","A000"]
["E160","STATE TREASURER'S OFFICE                                                                       ","A000"]
["E190","RETIREMENT SYSTEM  INVESTMENT COMMISSION","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"]
["S600","PROCUREMENT REVIEW PANEL","A000"]
["U300","AERONAUTICS DIVISION","U000"]