{"text_format":"1","workbook":"xlsx","n_sheets":37,"sheets":["Macro Instructions","Instructions","Agency Information","IV.","V.A.","V.B.1.","V.B.2.","V.B.3.","VI.A.","VI.B.","VI.C.1.","VI.C.2.","VI.C.3.","VI.C.4.","VI.C.5.","VII.A.","VII.B.","VII.C.1.","VII.C.2.","VII.C.3.","VII.D.","VII.E.","VIII.A.","VIII.B.","IX.","X.","XI.A.","XI.B.","XII.A.","XII.B.","XII.C.","XII.D.1.","XII.D.2.","XII.E.1.","XII.E.2.","wksUISettings","Implementation Notes"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":494,"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":"Macro Instructions","index":0,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,1,39,11]]}
[]
[null,"You must enable Excel macros to use this workbook. If this is the only page you can view, macros are currently disabled.\n\nDepending on the version of Excel you are using, and on your macro security settings, the process for enabling\nmacros can vary.\n\nIf Excel presents an option for enabling macros when you open this workbook, you must choose the option to\nenable macros. This workbook cannot be used with macros disabled.\n\nIf Excel does not present an option for enabling macros, please read the Excel-version-specific notes below for\nguidance on enabling macros.\n\nIf you are using Excel 2003:\n1. In Excel, choose \"Tools\" from the menu, then \"Macro\", then \"Security...\". Select the \"Security Level\" tab, then\nchoose \"Medium\".\n2. Close and reopen this workbook. You should now be presented with an option for enabling macros.\n\nSee \"http://msdn.microsoft.com/en-us/library/aa203729(office.11).aspx\" for more information.\n\nIf you are using Excel 2007 or 2010:\nOption 1 - Place FOIA template (.XLT) in a \"Trusted Location\" on your computer.\n1. On the Developer tab, in the Code group, click Macro Security. If the Developer tab is not displayed, click the\nMicrosoft Office Button (upper left corner of Excel), click Excel Options, and then in the Popular category, under\nTop options for working with Excel, click Show Developer tab in the Ribbon.\n2. Choose \"Trusted Locations\" in the menu on the left of the dialog, and either make note of a current directory\nwhere you will place the FOIA template, or add a new trusted location.\n3. Copy the FOIA template to the trusted location, then close and reopen that copy.\n\nOption 2 - Change Excel Macro Security Level\n1. On the Developer tab, in the Code group, click Macro Security. If the Developer tab is not displayed, click the\nMicrosoft Office Button (upper left corner of Excel), click Excel Options, and then in the Popular category, under\nTop options for working with Excel, click Show Developer tab in the Ribbon.\n2. Choose \"Macro Setting\" in the menu on the left of the dialog, then choose \"Disable all macros with\nnotification\" in the pane to the right.\n3. Close and reopen this workbook. You should now be presented with an option for enabling macros.\n\nSee \"http://office.microsoft.com/en-us/excel-help/change-macro-security-settings-in-excel-HP010096919.aspx\"\nfor more information."]

{"sheet":"Instructions","index":1,"n_rows":51,"n_cols":2,"rows_kept":51,"cut":false,"hidden":true,"merged":[[1,1,1,11],[2,1,2,11],[3,1,6,11],[31,1,33,11],[7,1,7,11],[8,1,8,11],[9,1,9,11],[11,1,11,11],[13,1,16,11],[17,1,23,11],[55,1,55,11],[25,1,29,11],[44,1,45,11],[47,1,48,11],[50,1,53,11],[35,1,36,11],[38,1,42,11]]}
[]
[null,"FOIA ANNUAL REPORT WORKBOOK"]
[]
[null,"FOIA Annual Reports are published in a standardized XML format designed specifically for FOIA annual reports, which adheres to the NIEM (National Information Exchange Model) standard (http://niem.gov). This standardized XML format allows interchange of FOIA information between systems in a machine-readable format. We refer to these documents here as \"FOIA format XML documents\"."]
[]
[]
[]
[null,"This Excel template allows creation and modification of FOIA format XML documents."]
[]
[null,"Please contact Jessica Sanet or Patrick DeKlotz of the Office of Information Policy at (202) 514-3642 with questions."]
[]
[null,"Important Workbook Usage Information:"]
[]
[null,"1) The DOJ Office of Information Policy provides this workbook as an Excel 2003 template (.XLT) file. When you open the template, load or enter information, then save the workbook, you do not overwrite the template, but rather create a new XLS document containing the information you entered. Thus, your copy of the template itself remains unmodified, and can be used in the future to create another report."]
[]
[]
[]
[null,"2) You can work with the XLS file to enter and save your information as you would with any Excel spreadsheet. However, it is important to understand that the FOIA annual report is not published as an XLS file, but rather as FOIA format XML documents introduced above. A custom 'Add-In' menu is added to Excel when the macros in this workbook initialize. This menu provides the following toolbar buttons to allow working with FOIA format XML documents:\n        A) Export as NIEM XML - export all FOIA information in the workbook to a FOIA format XML document.\n        B) Import from NIEM XML - REPLACE all FOIA information in the workbook with information from the FOIA format XML\n             document.\n        C) Clear All Entries - delete all FOIA information in the workbook."]
[]
[]
[]
[]
[]
[]
[]
[null,"3) If you wish to Paste data into the spreadsheet, please only use the 'Copy' and 'Paste Values' buttons on the FOIA Add-In menu. Excel offers numerous ways to initiate cut/copy/paste operations (toolbar buttons, menu options, context menu options, keyboard shortcuts, ribbon buttons in Excel 2007, etc.) These have all been disabled to the greatest degree possible, since unrestricted Cut/Copy/Paste operations can alter the special formatting and validation which allows creation of properly-formatted FOIA XML files."]
[]
[]
[]
[]
[]
[null,"4) When entering information, you should have a copy of the FOIA guidelines (2008 Guidelines for Agency Preparation of Annual FOIA Reports) available for reference. This workbook lays out information as it is presented there. Details about meaning of specific entries are described in these guidelines, and are not duplicated in this workbook."]
[]
[]
[]
[null,"5) When entering information, it is best to proceed through the worksheets in order, since some worksheets validate information against entries on previous worksheets."]
[]
[]
[null,"6) Each worksheet has sheet-specific instructions at the top of the page, formatted like the instructions you're reading now. The sheet-specific instructions describe how to use the sheet, and detail how information entered on the sheet is validated. A number of user interface conventions are used throughout this workbook. These are described in detail on the first sheet where they apply. On subsequent sheets it is assumed that the user will be familiar with the convention. So again, it is best to work through the sheets in order and read the sheet instructions before entering information into each worksheet."]
[]
[]
[]
[]
[]
[null,"7) Cell colors are used consistently to aid in understanding how to fill out each sheet. Yellow - Instructions; Blue - Headings; White - User-entry; Green - Calculated; Red - Errors or invalid values."]
[]
[]
[null,"8) If it is unclear why certain cells are red, the sheet instructions may help. While cells are red, the workbook will not allow exporting as FOIA XML, since the resulting XML file would not be valid."]
[]
[]
[null,"9) Each worksheet allows entry of footnotes at the bottom of the sheet. If you are unable to comply with a specific reporting requirement, please use this area to include an explanatory footnote associated with the report section. Note that no means is provided for flagging a specific cell or cells to which the footnote applies. The wording of the footnote itself must make it clear to which data the footnote applies."]

{"sheet":"Agency Information","index":2,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":true,"merged":[[2,2,2,3]]}
["HasError"]
[]
[null,null,"This sheet should be filled out first. General information about the report, and the reporting agency, is defined here.\n\nIf the agency's FOIA information is reported by 'component' (sub-organization, office, division), the components must be defined here. Component abbreviations entered here are available throughout this workbook in drop-down lists, allowing entry of information for each component.\n\nYou can make room to enter additional components by right-clicking on any editable cell in the component definition table and choosing 'Add Row'. A new, empty component row will be added at the bottom of the table. If you select multiple existing rows within the component definition table, right-click over the selected area, then choose 'Add Row', a corresponding number of component rows will be added at the bottom of the table. This convention is used throughout this workbook for expanding the size of entry tables."]
[]
[null,null,"Agency Information"]
[]
[{"$f":"ISBLANK(AgencyName)","v":false},null,"Agency","United States International Trade Commission"]
[{"$f":"ISBLANK(AgencyAbbreviation)","v":false},null,"Agency Abbreviation","USITC"]
[{"$f":"ISBLANK(AnnualReportYear)","v":false},null,"FOIA Annual Report Year",2019]
[{"$f":"ISBLANK(DatePrepared)","v":false},null,"Date Prepared","2019-11-04"]
[]
[]
[null,null,"Component Definition"]
[]
[null,null,"Component Abbreviation","Component Name"]
[{"$f":"OR(NOT(BothOrNeither(C16,D16)),COUNTIF($C$16:$C$18,C16)>1)","v":false}]
[{"$f":"OR(NOT(BothOrNeither(C17,D17)),COUNTIF($C$16:$C$18,C17)>1)","v":false}]
[{"$f":"COUNTIF(A6:ptrCellAbove,TRUE)<>0","v":false}]

{"sheet":"IV.","index":3,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":true,"merged":[[2,2,2,7],[7,2,8,2],[7,7,8,7],[15,2,15,7],[13,2,13,7],[14,2,14,7],[12,2,12,7]]}
["hasError"]
[]
[null,null,"List all Exemption 3 statutes relied upon to withhold information and the number of times each was relied upon.\n\nEnter a single statute in the merged cell in the 'Statute' column. You can make room to enter additional statutes by right-clicking on any editable cell in the statute table and choosing 'Add Statute'. A new, empty statute entry area will be added at the bottom of the table.\n\nThe columns to the right of each statute allow entry of information associated with the statute. You can make room for additional associated information by right-clicking on any editable cell associated with the statute and choosing 'Add Detail Row'.\n\nThe Footnotes section allows entry of any free-format notes associated with this section of the report. Again, if you need more than two footnotes, right-click on an editable cell in the Footnotes section, and choose 'Add Row'."]
[]
[null,null,"IV. Exemption 3 Statutes "]
[]
[null,null,"Statute","Type of Information\nWithheld","Case Citation","Agency / Component","Number of Times\nRelied upon\nby Agency / Component","Total Number of\nTimes Relied upon\nby Agency Overall"]
[{"$f":"OR(IF(COUNTA(F8:G8)=0,FALSE,COUNTA(F8:G8)<>2),AND(NOT(ISBLANK(F8)),ISNA(MATCH(F8,ComponentAbbreviation,0))))","v":false},null,"1667(f)","Information specifically exempt from disclosure by statute.","Mudge Rose Guthrie Alexander & Ferdon v. U.S. International Trade Commission, 846 F.2d 1527, 1530\n(D.C. Cir. 1988).\n","USITC",1,{"$f":"SUM($G$8:$G$9)","v":1}]
[false]
[{"$f":"COUNTIF(A8:ptrCellAbove,TRUE)<>0","v":false}]
[]
[null,null,"Footnotes"]

{"sheet":"V.A.","index":4,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":true,"merged":[[2,5,2,9],[4,5,4,9],[16,5,16,9],[14,5,14,9],[15,5,15,9],[13,5,13,9]]}
["Component Valid","Start","Received","Processed"]
[]
[null,null,null,null,null,"Each row represents values for a single component. Enter the component abbreviation, or choose it from the drop-down, then enter values for that component in the editable columns to the right. Component abbreviations must match those set up on the 'Agency Information' sheet. If the report is not broken out by component, the agency abbreviation must be entered, which is the only option offered in the drop-down.\n\nBlank lines are ignored, but if the component column is filled in, all other editable columns must be filled in. All values must be non-negative integers.\n\nAdditional entry rows may be added by right-clicking on any editable cell in the table and choosing 'Add Row'. An additional component row will be added at the bottom of the table. If you select multiple rows before right clicking, a corresponding number of rows will be added at the bottom."]
[]
[null,null,null,null,null,"V. FOIA REQUESTS / A. Received, Processed and Pending FOIA Requests"]
[]
[null,null,null,null,null,"Agency / Component","Number of Requests\nPending as of Start\nof Fiscal Year","Number of\nRequests Received\nin Fiscal Year","Number of\nRequests Processed\nin Fiscal Year","Number of Requests\nPending as of End\nof Fiscal Year"]
[{"$f":"OR(COUNTIF(V_A_Components,F8)>1,AND(NOT(ISBLANK(F8)),ISNA(MATCH(F8,ComponentAbbreviation,0))))","v":false},{"$f":"OR(AND(ISBLANK($F8),NOT(ISBLANK(G8))),AND(NOT(ISBLANK($F8)),NOT(IsNonNegativeInteger(G8))))","v":false},false,false,null,"USITC",0,31,28,{"$f":"G8+H8-I8","v":3}]
[false,false,false,false,null,null,null,null,null,0]
[null,null,null,null,null,"AGENCY OVERALL",{"$f":"SUM(G8:ptrCellAbove)","v":0},{"$f":"SUM(H8:ptrCellAbove)","v":31},{"$f":"SUM(I8:ptrCellAbove)","v":28},{"$f":"SUM(J8:ptrCellAbove)","v":3}]
[{"$f":"OR(A8:D10)","v":false}]
[]
[null,null,null,null,null,"Footnotes"]

{"sheet":"V.B.1.","index":5,"n_rows":14,"n_cols":30,"rows_kept":14,"cut":false,"hidden":true,"merged":[[2,16,2,29],[6,20,6,28],[4,16,4,24],[6,17,7,17],[6,18,7,18],[15,16,15,29],[16,16,16,29],[14,16,14,29],[17,16,17,29],[6,19,7,19],[6,16,7,16]]}
["Component",null,null,null,null,null,null,null,null,null,null,null,null,"Corresponding V.A. Processed","Total matches V.A. Processed"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Each row represents values for a single component. Enter the component abbreviation, or choose it from the drop-down, then enter values for that component in the editable columns to the right. Component abbreviations must match those set up on the 'Agency Information' sheet. If the report is not broken out by component, the agency abbreviation must be entered, which is the only option offered in the drop-down.\n\nBlank lines are ignored, but if the component column is filled in, all other editable columns must be filled in. All values must be non-negative integers.\n\nThe sum of all columns (calculated column titled 'TOTAL') must match the number entered on sheet V.A., column 'Number of Requests Processed in Fiscal Year' for the component, and for the agency overall."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V. FOIA REQUESTS / B. (1) Disposition of FOIA Requests - All Processed Requests"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Agency / Component","Number of Full Grants","Number of Partial Grants / Partial Denials","Number of Full Denials Based on Exemptions","Number of Full Denials Based on Reasons Other than Exemptions"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No Records","All Records Referred to Another Component or Agency","Request Withdrawn","Fee-Related Reason","Records not Reasonably Described","Improper FOIA Request for Other Reason","Not Agency Record","Duplicate Request","Other *Explain in Chart Below","TOTAL"]
[{"$f":"OR(COUNTIF(V_B_1_Components,Q9)>1,AND(NOT(ISBLANK(Q9)),ISNA(MATCH(Q9,ComponentAbbreviation,0))))","v":false},{"$f":"OR(AND(ISBLANK($Q9),NOT(ISBLANK(R9))),AND(NOT(ISBLANK($Q9)),NOT(IsNonNegativeInteger(R9))))","v":false},{"$f":"OR(AND(ISBLANK($Q9),NOT(ISBLANK(S9))),AND(NOT(ISBLANK($Q9)),NOT(IsNonNegativeInteger(S9))))","v":false},false,false,false,false,false,false,false,false,false,false,{"$f":"INDEX(V_A_Processed,MATCH(Q9,V_A_Components,0))","v":28},{"$f":"IF(ISBLANK(Q9),FALSE,IF(ISNA(N9),TRUE,N9<>AD9))","v":false},null,"USITC",8,10,2,8,0,0,0,0,0,0,0,0,{"$f":"SUM(R9:AC9)","v":28}]
[false,false,{"$f":"OR(AND(ISBLANK($Q10),NOT(ISBLANK(S10))),AND(NOT(ISBLANK($Q10)),NOT(IsNonNegativeInteger(S10))))","v":false},false,false,false,false,false,false,false,false,false,false,{"$error":"#N/A"},false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"FALSE","v":false},{"$f":"FALSE","v":false},null,null,null,null,null,null,null,null,null,null,null,28,false,null,"AGENCY OVERALL",{"$f":"SUM(R9:ptrCellAbove)","v":8},{"$f":"SUM(S9:ptrCellAbove)","v":10},{"$f":"SUM(T9:ptrCellAbove)","v":2},{"$f":"SUM(U9:ptrCellAbove)","v":8},{"$f":"SUM(V9:ptrCellAbove)","v":0},{"$f":"SUM(W9:ptrCellAbove)","v":0},{"$f":"SUM(X9:ptrCellAbove)","v":0},{"$f":"SUM(Y9:ptrCellAbove)","v":0},{"$f":"SUM(Z9:ptrCellAbove)","v":0},{"$f":"SUM(AA9:ptrCellAbove)","v":0},{"$f":"SUM(AB9:ptrCellAbove)","v":0},{"$f":"SUM(AC9:ptrCellAbove)","v":0},{"$f":"SUM(AD9:ptrCellAbove)","v":28}]
[]
[{"$f":"OR(A9:M11,O9:O11)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Footnotes"]

{"sheet":"V.B.2.","index":6,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":true,"merged":[[2,6,2,9],[4,6,4,7],[7,0,8,0],[7,3,8,3],[7,4,8,4],[15,6,15,9],[13,6,13,9],[12,6,12,9],[14,6,14,9],[7,6,8,6],[7,9,8,9]]}
["ComponentValid","Description","Number","TotalValid","Corresponding V.B.1 Other"]
[]
[null,null,null,null,null,null,"Information for a single component may span multiple rows. The merged cell in the 'Component' column indicates the detail rows to the right which are associated with each component. To add additional components, right-click on any editable cell in the table and choose 'Add Component'. A new, empty component entry area will be added at the bottom of the table.\n\nThe columns to the right of each component allow entry of information associated with the component. You can make room for additional associated information by right-clicking on any editable cell associated with the component and choosing 'Add Detail Row'.\n\nBlank components are ignored, but if the component column is filled in, at least one description must also be entered. If a description is entered, an associated count must be entered. Counts must be non-negative integers.\n\nThe calculated column titled 'COMPONENT TOTAL' must match the number entered on sheet V.B.1., column 'Other' for the component, and for the agency overall."]
[]
[null,null,null,null,null,null,"V. FOIA REQUESTS / B. (2) Disposition of FOIA Requests - Other Reasons"]
[]
[null,null,null,null,null,null,"Agency / Component","Description of \"Other\" Reasons for Denials from Chart B(1)","Number of Times \"Other\" Reason Was Relied Upon","TOTAL"]
[{"$f":"OR(COUNTIF($G$8:$G$10,G8)>1,AND(NOT(ISBLANK(G8)),ISNA(MATCH(G8,ComponentAbbreviation,0))))","v":false},{"$f":"OR(NOT(BothOrNeither(G8,H8)),NOT(BothOrNeither(H8,I8)))","v":false},{"$f":"NOT(BothOrNeither(H8,I8))","v":false},{"$f":"IF(ISBLANK(G8),FALSE,IF(ISNA(E8),TRUE,E8<>J8))","v":false},{"$f":"INDEX(V_B_1_Other,MATCH(G8,V_B_1_Components,0))","v":0},null,"USITC","N/A",0,{"$f":"SUM($I$8:$I$9)","v":0}]
[null,{"$f":"NOT(BothOrNeither(H9,I9))","v":false},false]
[null,null,null,{"$f":"IF(ISBLANK(G10),FALSE,IF(ISNA(E10),TRUE,E10<>J10))","v":false},{"$f":"INDEX(V_B_1_Other,MATCH(G10,V_B_1_Components,0))","v":0},null,"AGENCY OVERALL",null,null,{"$f":"SUM(J8:ptrCellAbove)","v":0}]
[]
[{"$f":"OR(A8:D10)","v":false},null,null,null,null,null,"Footnotes"]

{"sheet":"V.B.3.","index":7,"n_rows":13,"n_cols":31,"rows_kept":13,"cut":false,"hidden":true,"merged":[[15,16,15,30],[13,16,13,30],[16,16,16,30],[2,16,2,30],[4,16,4,26],[14,16,14,30]]}
["Component"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Each row represents values for a single component. Enter the component abbreviation, or choose it from the drop-down, then enter values for that component in the editable columns to the right.\n\nBlank lines are ignored, but if the component column is filled in, all other editable columns must be filled in. All values must be non-negative integers.\n"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"V. FOIA REQUESTS / B. (3) Disposition of FOIA Requests - Number of Times Exemptions Applied"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Agency / Component","Ex. 1","Ex. 2","Ex. 3","Ex. 4","Ex. 5","Ex. 6","Ex. 7(A)","Ex. 7(B)","Ex. 7(C)","Ex. 7(D)","Ex. 7(E)","Ex. 7(F)","Ex. 8","Ex. 9"]
[{"$f":"OR(COUNTIF($Q$8:$Q$10,Q8)>1,AND(NOT(ISBLANK(Q8)),ISNA(MATCH(Q8,ComponentAbbreviation,0))))","v":false},{"$f":"OR(AND(ISBLANK($Q8),NOT(ISBLANK(R8))),AND(NOT(ISBLANK($Q8)),NOT(IsNonNegativeInteger(R8))))","v":false},{"$f":"OR(AND(ISBLANK($Q8),NOT(ISBLANK(S8))),AND(NOT(ISBLANK($Q8)),NOT(IsNonNegativeInteger(S8))))","v":false},false,false,false,false,false,false,false,false,false,false,false,false,null,"USITC",0,0,1,1,10,11,0,0,0,0,2,0,0,0]
[{"$f":"OR(COUNTIF($Q$8:$Q$10,Q9)>1,AND(NOT(ISBLANK(Q9)),ISNA(MATCH(Q9,ComponentAbbreviation,0))))","v":false},false,{"$f":"OR(AND(ISBLANK($Q9),NOT(ISBLANK(S9))),AND(NOT(ISBLANK($Q9)),NOT(IsNonNegativeInteger(S9))))","v":false},false,false,false,false,false,false,false,false,false,false,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AGENCY OVERALL",{"$f":"SUM(R8:ptrCellAbove)","v":0},{"$f":"SUM(S8:ptrCellAbove)","v":0},{"$f":"SUM(T8:ptrCellAbove)","v":1},{"$f":"SUM(U8:ptrCellAbove)","v":1},{"$f":"SUM(V8:ptrCellAbove)","v":10},{"$f":"SUM(W8:ptrCellAbove)","v":11},{"$f":"SUM(X8:ptrCellAbove)","v":0},{"$f":"SUM(Y8:ptrCellAbove)","v":0},{"$f":"SUM(Z8:ptrCellAbove)","v":0},{"$f":"SUM(AA8:ptrCellAbove)","v":0},{"$f":"SUM(AB8:ptrCellAbove)","v":2},{"$f":"SUM(AC8:ptrCellAbove)","v":0},{"$f":"SUM(AD8:ptrCellAbove)","v":0},{"$f":"SUM(AE8:ptrCellAbove)","v":0}]
[{"$f":"OR(A8:O10)","v":false}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Footnotes"]

{"sheet":"VI.A.","index":8,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":true,"merged":[[16,5,16,9],[4,5,4,10],[2,5,2,9],[13,5,13,9],[14,5,14,9],[15,5,15,9]]}
["Component Valid","Start","Received","Processed"]
[]
[null,null,null,null,null,"Each row represents values for a single component. Enter the component abbreviation, or choose it from the drop-down, then enter values for that component in the editable columns to the right. Component abbreviations must match those set up on the 'Agency Information' sheet. If the report is not broken out by component, the agency abbreviation must be entered, which is the only option offered in the drop-down.\n\nBlank lines are ignored, but if the component column is filled in, all other editable columns must be filled in. All values must be non-negative integers."]
[]
[null,null,null,null,null,"VI. ADMINISTRATIVE APPEALS / A. Received, Processed and Pending Administrative Appeals"]
[]
[null,null,null,null,null,"Agency / Component","Number of Appeals\nPending as of Start\nof Fiscal Year","Number of\nAppeals Received\nin Fiscal Year","Number of\nAppeals Processed\nin Fiscal Year","Number of Appeals\nPending as of End\nof Fiscal Year"]
[{"$f":"OR(COUNTIF(VI_A_Components,F8)>1,AND(NOT(ISBLANK(F8)),ISNA(MATCH(F8,ComponentAbbreviation,0))))","v":false},{"$f":"OR(AND(ISBLANK($F8),NOT(ISBLANK(G8))),AND(NOT(ISBLANK($F8)),NOT(IsNonNegativeInteger(G8))))","v":false},false,false,null,"USITC",0,0,0,{"$f":"G8+H8-I8","v":0}]
[{"$f":"OR(COUNTIF(VI_A_Components,F9)>1,AND(NOT(ISBLANK(F9)),ISNA(MATCH(F9,ComponentAbbreviation,0))))","v":false},false,false,false,null,null,null,null,null,{"$f":"G9+H9-I9","v":0}]
[null,null,null,null,null,"AGENCY OVERALL",{"$f":"SUM(G8:ptrCellAbove)","v":0},{"$f":"SUM(H8:ptrCellAbove)","v":0},{"$f":"SUM(I8:ptrCellAbove)","v":0},{"$f":"SUM(J8:ptrCellAbove)","v":0}]
[{"$f":"OR(A8:D10)","v":false}]
[]
[null,null,null,null,null,"Footnotes"]

{"sheet":"VI.B.","index":9,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":true,"merged":[[16,8,16,13],[2,8,2,13],[4,8,4,13],[14,8,14,13],[15,8,15,13],[13,8,13,13]]}
["Component",null,null,null,null,"Corresponding V.A. Processed","Total matches V.A. Processed"]
[]
[null,null,null,null,null,null,null,null,"Blank lines are ignored, but if the component column is filled in, all other editable columns must be filled in. All values must be non-negative integers.\n\nThe sum of all columns (calculated column titled 'TOTAL') must match the number entered on sheet VI.A., column 'Number of Appeals Processed in Fiscal Year' for the component, and for the agency overall."]
[]
[null,null,null,null,null,null,null,null,"VI. ADMINISTRATIVE APPEALS / B. Disposition of Administrative Appeals - All Processed Appeals"]
[]
[null,null,null,null,null,null,null,null,"Agency / Component","Number Affirmed on Appeal","Number Partially Affirmed & Partially Reversed/Remanded on Appeal","Number Completely Reversed/Remanded on Appeal","Number of Appeals Closed for Other Reasons","TOTAL"]
[{"$f":"OR(COUNTIF(VI_B_Components,I8)>1,AND(NOT(ISBLANK(I8)),ISNA(MATCH(I8,ComponentAbbreviation,0))))","v":false},{"$f":"OR(AND(ISBLANK($I8),NOT(ISBLANK(J8))),AND(NOT(ISBLANK($I8)),NOT(IsNonNegativeInteger(J8))))","v":false},false,false,false,{"$f":"INDEX(VI_A_Processed,MATCH(I8,VI_A_Components,0))","v":0},{"$f":"IF(ISBLANK(I8),FALSE,IF(ISNA(F8),TRUE,F8<>N8))","v":false},null,"USITC",0,0,0,0,{"$f":"SUM(J8:M8)","v":0}]
[{"$f":"OR(COUNTIF(VI_B_Components,I9)>1,AND(NOT(ISBLANK(I9)),ISNA(MATCH(I9,ComponentAbbreviation,0))))","v":false},false,false,false,false,{"$f":"INDEX(VI_A_Processed,MATCH(I9,VI_A_Components,0))","v":{"$error":"#N/A"}},{"$f":"IF(ISBLANK(I9),FALSE,IF(ISNA(F9),TRUE,F9<>N9))","v":false},null,null,null,null,null,null,{"$f":"SUM(J9:M9)","v":0}]
[null,null,null,null,null,{"$f":"INDEX(VI_A_Processed,MATCH(I10,VI_A_Components,0))","v":0},{"$f":"IF(ISBLANK(I10),FALSE,IF(ISNA(F10),TRUE,F10<>N10))","v":false},null,"AGENCY OVERALL",{"$f":"SUM(J8:ptrCellAbove)","v":0},{"$f":"SUM(K8:ptrCellAbove)","v":0},{"$f":"SUM(L8:ptrCellAbove)","v":0},{"$f":"SUM(M8:ptrCellAbove)","v":0},{"$f":"SUM(N8:ptrCellAbove)","v":0}]
[{"$f":"OR(A8:E10,G8:G10)","v":false}]
[]
[null,null,null,null,null,null,null,null,"Footnotes"]

{"sheet":"VI.C.1.","index":10,"n_rows":13,"n_cols":31,"rows_kept":13,"cut":false,"hidden":true,"merged":[[2,16,2,30],[14,16,14,30],[15,16,15,30],[13,16,13,30],[16,16,16,30],[4,16,4,28]]}
["Component"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Each row represents values for a single component. Enter the component abbreviation, or choose it from the drop-down, then enter values for that component in the editable columns to the right.\n\nBlank lines are ignored, but if the component column is filled in, all other editable columns must be filled in. All values must be non-negative integers.\n"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VI. ADMINISTRATIVE APPEALS / C. (1) Reasons for Denial on Appeal - Number of Times Exemptions Applied"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Agency / Component","Ex. 1","Ex. 2","Ex. 3","Ex. 4","Ex. 5","Ex. 6","Ex. 7(A)","Ex. 7(B)","Ex. 7(C)","Ex. 7(D)","Ex. 7(E)","Ex. 7(F)","Ex. 8","Ex. 9"]
[{"$f":"OR(COUNTIF($Q$8:$Q$10,Q8)>1,AND(NOT(ISBLANK(Q8)),ISNA(MATCH(Q8,ComponentAbbreviation,0))))","v":false},{"$f":"OR(AND(ISBLANK($Q8),NOT(ISBLANK(R8))),AND(NOT(ISBLANK($Q8)),NOT(IsNonNegativeInteger(R8))))","v":false},{"$f":"OR(AND(ISBLANK($Q8),NOT(ISBLANK(S8))),AND(NOT(ISBLANK($Q8)),NOT(IsNonNegativeInteger(S8))))","v":false},false,false,false,false,false,false,false,false,false,false,false,false,null,"USITC",0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"OR(COUNTIF($Q$8:$Q$10,Q9)>1,AND(NOT(ISBLANK(Q9)),ISNA(MATCH(Q9,ComponentAbbreviation,0))))","v":false},{"$f":"OR(AND(ISBLANK($Q9),NOT(ISBLANK(R9))),AND(NOT(ISBLANK($Q9)),NOT(IsNonNegativeInteger(R9))))","v":false},false,false,false,false,false,false,false,false,false,false,false,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AGENCY OVERALL",{"$f":"SUM(R8:ptrCellAbove)","v":0},{"$f":"SUM(S8:ptrCellAbove)","v":0},{"$f":"SUM(T8:ptrCellAbove)","v":0},{"$f":"SUM(U8:ptrCellAbove)","v":0},{"$f":"SUM(V8:ptrCellAbove)","v":0},{"$f":"SUM(W8:ptrCellAbove)","v":0},{"$f":"SUM(X8:ptrCellAbove)","v":0},{"$f":"SUM(Y8:ptrCellAbove)","v":0},{"$f":"SUM(Z8:ptrCellAbove)","v":0},{"$f":"SUM(AA8:ptrCellAbove)","v":0},{"$f":"SUM(AB8:ptrCellAbove)","v":0},{"$f":"SUM(AC8:ptrCellAbove)","v":0},{"$f":"SUM(AD8:ptrCellAbove)","v":0},{"$f":"SUM(AE8:ptrCellAbove)","v":0}]
[{"$f":"OR(A8:O10)","v":false}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Footnotes"]

{"sheet":"VI.C.2.","index":11,"n_rows":13,"n_cols":25,"rows_kept":13,"cut":false,"hidden":true,"merged":[[16,13,16,24],[4,13,4,22],[2,13,2,24],[14,13,14,24],[15,13,15,24],[13,13,13,24]]}
["Component"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Each row represents values for a single component. Enter the component abbreviation, or choose it from the drop-down, then enter values for that component in the editable columns to the right.\n\nBlank lines are ignored, but if the component column is filled in, all other editable columns must be filled in. All values must be non-negative integers.\n"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"VI. ADMINISTRATIVE APPEALS / C. (2) Reasons for Denial on Appeal - Reasons Other than Exemptions"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Agency / Component","No Records","Records Referred at Initial Request Level","Request Withdrawn","Fee-Related Reason","Records not Reasonably Described","Improper Request for Other Reasons","Not Agency Record","Duplicate Request or Appeal","Request in Litigation","Appeal Based Solely on Denial of Request for Expedited Processing","Other *Explain in chart below"]
[{"$f":"OR(COUNTIF($N$8:$N$10,N8)>1,AND(NOT(ISBLANK(N8)),ISNA(MATCH(N8,ComponentAbbreviation,0))))","v":false},{"$f":"OR(AND(ISBLANK($N8),NOT(ISBLANK(O8))),AND(NOT(ISBLANK($N8)),NOT(IsNonNegativeInteger(O8))))","v":false},{"$f":"OR(AND(ISBLANK($N8),NOT(ISBLANK(P8))),AND(NOT(ISBLANK($N8)),NOT(IsNonNegativeInteger(P8))))","v":false},false,false,false,false,false,false,false,false,false,null,"USITC",0,0,0,0,0,0,0,0,0,0,0]
[{"$f":"OR(COUNTIF($N$8:$N$10,N9)>1,AND(NOT(ISBLANK(N9)),ISNA(MATCH(N9,ComponentAbbreviation,0))))","v":false},{"$f":"OR(AND(ISBLANK($N9),NOT(ISBLANK(O9))),AND(NOT(ISBLANK($N9)),NOT(IsNonNegativeInteger(O9))))","v":false},{"$f":"OR(AND(ISBLANK($N9),NOT(ISBLANK(P9))),AND(NOT(ISBLANK($N9)),NOT(IsNonNegativeInteger(P9))))","v":false},false,false,false,false,false,false,false,false,false]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"AGENCY OVERALL",{"$f":"SUM(O8:ptrCellAbove)","v":0},{"$f":"SUM(P8:ptrCellAbove)","v":0},{"$f":"SUM(Q8:ptrCellAbove)","v":0},{"$f":"SUM(R8:ptrCellAbove)","v":0},{"$f":"SUM(S8:ptrCellAbove)","v":0},{"$f":"SUM(T8:ptrCellAbove)","v":0},{"$f":"SUM(U8:ptrCellAbove)","v":0},{"$f":"SUM(V8:ptrCellAbove)","v":0},{"$f":"SUM(W8:ptrCellAbove)","v":0},{"$f":"SUM(X8:ptrCellAbove)","v":0},{"$f":"SUM(Y8:ptrCellAbove)","v":0}]
[{"$f":"OR(A8:L10)","v":false}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Footnotes"]

{"sheet":"VI.C.3.","index":12,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":true,"merged":[[7,0,8,0],[7,3,8,3],[7,4,8,4],[14,6,14,9],[15,6,15,9],[13,6,13,9],[12,6,12,9],[2,6,2,9],[4,6,4,9],[7,6,8,6],[7,9,8,9]]}
["ComponentValid","Description","Number","TotalValid","Corresponding V.B.1 Other"]
[]
[null,null,null,null,null,null,"Information for a single component may span multiple rows. The merged cell in the 'Component' column indicates the detail rows to the right which are associated with each component. To add additional components, right-click on any editable cell in the table and choose 'Add Component'. A new, empty component entry area will be added at the bottom of the table.\n\nThe columns to the right of each component allow entry of information associated with the component. You can make room for additional associated information by right-clicking on any editable cell associated with the component and choosing 'Add Detail Row'.\n\nBlank components are ignored, but if the component column is filled in, at least one description must also be entered. If a description is entered, an associated count must be entered. Counts must be non-negative integers.\n\nThe calculated column titled 'COMPONENT TOTAL' must match the number entered on sheet VI.C.2., column 'Other' for the component, and for the agency overall."]
[]
[null,null,null,null,null,null,"VI. ADMINISTRATIVE APPEALS / C. (3) Reasons for Denial on Appeal - Other Reasons"]
[]
[null,null,null,null,null,null,"Agency / Component","Description of \"Other\" Reasons for Denial on Appeal from Chart C(2)","Number of Times \"Other\" Reason Was Relied Upon","TOTAL"]
[{"$f":"OR(COUNTIF($G$8:$G$10,G8)>1,AND(NOT(ISBLANK(G8)),ISNA(MATCH(G8,ComponentAbbreviation,0))))","v":false},{"$f":"OR(NOT(BothOrNeither(G8,H8)),NOT(BothOrNeither(H8,I8)))","v":false},{"$f":"NOT(BothOrNeither(H8,I8))","v":false},{"$f":"IF(ISBLANK(G8),FALSE,IF(ISNA(E8),TRUE,E8<>J8))","v":false},{"$f":"INDEX(VI_C_2_Other,MATCH(G8,VI_C_2_Components,0))","v":0},null,"USITC","N/A",0,{"$f":"SUM($I$8:$I$9)","v":0}]
[null,{"$f":"NOT(BothOrNeither(H9,I9))","v":false},false]
[null,null,null,{"$f":"IF(ISBLANK(G10),FALSE,IF(ISNA(E10),TRUE,E10<>J10))","v":false},{"$f":"INDEX(VI_C_2_Other,MATCH(G10,VI_C_2_Components,0))","v":0},null,"AGENCY OVERALL",null,null,{"$f":"SUM(J8:ptrCellAbove)","v":0}]
[]
[{"$f":"OR(A8:D10)","v":false},null,null,null,null,null,"Footnotes"]

{"sheet":"VI.C.4.","index":13,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":true,"merged":[[2,6,2,10],[13,6,13,10],[14,6,14,10],[15,6,15,10],[16,6,16,10],[4,6,4,9]]}
["Component Valid"]
[]
[null,null,null,null,null,null,"This is the first sheet in which the \"AGENCY OVERALL\" information cannot be calculated from component information, and must be entered. Notice that the cells in the AGENCY OVERALL line are not green (calculated), but are instead editable.\n\nIf the report is broken out by component, enter each component individually, then manually enter agency total information.\n\nIf the report is NOT broken out by component, no choices will be available in the component drop-down. In this case, enter only the agency total information in the AGENCY OVERALL row.\n\nBlank component lines are ignored, but if the component column is filled in, all other editable columns must be filled in. All values must be non-negative numeric values, or the special value \"<1\". A right-click context menu item is available to enter the special value \"<1\" into selected cells."]
[]
[null,null,null,null,null,null,"VI. ADMINISTRATIVE APPEALS / C. (4) Response Time for Administrative Appeals"]
[]
[null,null,null,null,null,null,"Agency / Component","Median Number of Days","Average Number of Days","Lowest Number of Days","Highest Number of Days"]
[{"$f":"OR(COUNTIF($G$8:$G$10,G8)>1,AND(NOT(ISBLANK(G8)),ISNA(MATCH(G8,ComponentAbbrevNoAgency,0))))","v":false},{"$f":"OR(AND(ISBLANK($G8),NOT(ISBLANK(H8))),AND(NOT(ISBLANK($G8)),NOT(IsNonNegativeDecimal(H8,FALSE,FALSE,TRUE))))","v":false},false,false,false]
[{"$f":"OR(COUNTIF($G$8:$G$10,G9)>1,AND(NOT(ISBLANK(G9)),ISNA(MATCH(G9,ComponentAbbrevNoAgency,0))))","v":false},false,false,false,false]
[null,{"$f":"NOT(IsNonNegativeDecimal(H10,FALSE,FALSE,TRUE))","v":false},{"$f":"NOT(IsNonNegativeDecimal(I10,FALSE,FALSE,TRUE))","v":false},{"$f":"NOT(IsNonNegativeDecimal(J10,FALSE,FALSE,TRUE))","v":false},{"$f":"NOT(IsNonNegativeDecimal(K10,FALSE,FALSE,TRUE))","v":false},null,"AGENCY OVERALL",0,0,0,0]
[{"$f":"OR(A8:E10)","v":false}]
[]
[null,null,null,null,null,null,"Footnotes"]

{"sheet":"VI.C.5.","index":14,"n_rows":14,"n_cols":24,"rows_kept":14,"cut":false,"hidden":true,"merged":[[16,12,16,23],[17,12,17,23],[4,12,4,17],[9,12,10,12],[7,12,8,12],[7,0,8,0],[9,0,10,0],[2,12,2,23],[15,12,15,23],[14,12,14,23]]}
["Component Valid","10th Valid","9th Valid","8th Valid","7th Valid","6th Valid","5th Valid","4th Valid","3rd Valid","2nd Valid","1st Valid"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"\"AGENCY OVERALL\" information cannot be calculated from component information, and must be entered.\n\nA component, or the agency overall, may not have ten appeals pending. Thus, some columns may be not applicable. In this case, \"N/A\" should be entered in the \"Date of Appeal\" cell, and \"0\" should be entered in the \"Number of Days Pending\" cell. However, if a column is used for a valid date, all columns to the right of it must also be filled in with a valid date. If a date is filled in, the number of days associated with the date must also be filled in. \"Number of Days Pending\" values must be non-negative integers.  A right-click context menu item is available to enter the special value \"N/A\" into selected cells."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"VI. ADMINISTRATIVE APPEALS / C. (5) Ten Oldest Administrative Appeals"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Agency / Component",null,"10th Oldest Appeal","9th","8th","7th","6th","5th","4th","3rd","2nd","Oldest Appeal"]
[{"$f":"OR(COUNTIF($M$8:$M$10,M8)>1,AND(NOT(ISBLANK(M8)),ISNA(MATCH(M8,ComponentAbbrevNoAgency,0))))","v":false},{"$f":"NOT(AND(BothOrNeither($M8,O8),IsValidOldestDate(O8,N8)))","v":false},false,false,false,false,false,false,false,false,false,null,null,"Date of Appeal"]
[null,{"$f":"NOT(AND(BothOrNeither($M8,O9),IsValidOldestPendingDays(O9,N9,O8)))","v":false},false,false,false,false,false,false,false,false,false,null,null,"Number of Days Pending"]
[{"$f":"FALSE","v":false},{"$f":"NOT(IsValidOldestDate(O10,N10))","v":false},{"$f":"NOT(IsValidOldestDate(P10,O10))","v":false},false,false,false,false,false,false,false,false,null,"AGENCY OVERALL","Date of Appeal","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[null,{"$f":"NOT(IsValidOldestPendingDays(O11,N11,O10))","v":false},{"$f":"NOT(IsValidOldestPendingDays(P11,O11,P10))","v":false},false,false,false,false,false,false,false,false,null,null,"Number of Days Pending",0,0,0,0,0,0,0,0,0,0]
[{"$f":"OR(A8:K11)","v":false}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Footnotes"]

{"sheet":"VII.A.","index":15,"n_rows":14,"n_cols":27,"rows_kept":14,"cut":false,"hidden":true,"merged":[[14,14,14,26],[15,14,15,26],[16,14,16,26],[17,14,17,26],[2,14,2,26],[6,15,6,18],[6,19,6,22],[6,23,6,26],[6,14,7,14],[4,14,4,22]]}
["Component Valid"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"\"AGENCY OVERALL\" information cannot be calculated from component information, and must be entered.\n\nBlank component lines are ignored, but if the component column is filled in, all other editable columns must be filled in. Similarly, all columns on the AGENCY OVERALL row must be filled in. Values must either be non-negative numeric values, the special value \"<1\", or the special value \"N/A\".\n"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VII. A. Processed Requests - Response Time for All Processed Perfected Requests"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Agency / Component","SIMPLE",null,null,null,"COMPLEX",null,null,null,"EXPEDITED PROCESSING"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Median Number of Days","Average Number of Days","Lowest Number of Days","Highest Number of Days","Median Number of Days","Average Number of Days","Lowest Number of Days","Highest Number of Days","Median Number of Days","Average Number of Days","Lowest Number of Days","Highest Number of Days"]
[{"$f":"OR(COUNTIF($O$9:$O$11,O9)>1,AND(NOT(ISBLANK(O9)),ISNA(MATCH(O9,ComponentAbbrevNoAgency,0))))","v":false},{"$f":"OR(AND(ISBLANK($O9),NOT(ISBLANK(P9))),AND(NOT(ISBLANK($O9)),NOT(IsNonNegativeDecimal(P9,FALSE,TRUE,TRUE))))","v":false},{"$f":"OR(AND(ISBLANK($O9),NOT(ISBLANK(Q9))),AND(NOT(ISBLANK($O9)),NOT(IsNonNegativeDecimal(Q9,FALSE,TRUE,TRUE))))","v":false},false,false,false,false,false,false,false,false,false,false]
[{"$f":"OR(COUNTIF($O$9:$O$11,O10)>1,AND(NOT(ISBLANK(O10)),ISNA(MATCH(O10,ComponentAbbrevNoAgency,0))))","v":false},false,{"$f":"OR(AND(ISBLANK($O10),NOT(ISBLANK(Q10))),AND(NOT(ISBLANK($O10)),NOT(IsNonNegativeDecimal(Q10,FALSE,TRUE,TRUE))))","v":false},false,false,false,false,false,false,false,false,false,false]
[null,{"$f":"NOT(IsNonNegativeDecimal(P11,FALSE,TRUE,TRUE))","v":false},{"$f":"NOT(IsNonNegativeDecimal(Q11,FALSE,TRUE,TRUE))","v":false},false,false,false,false,false,false,false,false,false,false,null,"AGENCY OVERALL",19,16.3,7,20,30,40.1,25,84,"N/A","N/A","N/A","N/A"]
[{"$f":"OR(A9:M11)","v":false}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Footnotes"]

{"sheet":"VII.B.","index":16,"n_rows":14,"n_cols":27,"rows_kept":14,"cut":false,"hidden":true,"merged":[[2,14,2,26],[14,14,14,26],[15,14,15,26],[16,14,16,26],[17,14,17,26],[6,23,6,26],[6,14,7,14],[6,15,6,18],[6,19,6,22],[4,14,4,24]]}
["Component Valid"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"\"AGENCY OVERALL\" information cannot be calculated from component information, and must be entered.\n\nBlank component lines are ignored, but if the component column is filled in, all other editable columns must be filled in. Similarly, all columns on the AGENCY OVERALL row must be filled in. Values must either be non-negative numeric values, the special value \"<1\", or the special value \"N/A\"."]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VII. B. Processed Requests - Response Time for Perfected Requests in Which Information Was Granted"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Agency / Component","SIMPLE",null,null,null,"COMPLEX",null,null,null,"EXPEDITED PROCESSING"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Median Number of Days","Average Number of Days","Lowest Number of Days","Highest Number of Days","Median Number of Days","Average Number of Days","Lowest Number of Days","Highest Number of Days","Median Number of Days","Average Number of Days","Lowest Number of Days","Highest Number of Days"]
[{"$f":"OR(COUNTIF($O$9:$O$11,O9)>1,AND(NOT(ISBLANK(O9)),ISNA(MATCH(O9,ComponentAbbrevNoAgency,0))))","v":false},{"$f":"OR(AND(ISBLANK($O9),NOT(ISBLANK(P9))),AND(NOT(ISBLANK($O9)),NOT(IsNonNegativeDecimal(P9,FALSE,TRUE,TRUE))))","v":false},{"$f":"OR(AND(ISBLANK($O9),NOT(ISBLANK(Q9))),AND(NOT(ISBLANK($O9)),NOT(IsNonNegativeDecimal(Q9,FALSE,TRUE,TRUE))))","v":false},false,false,false,false,false,false,false,false,false,false]
[{"$f":"OR(COUNTIF($O$9:$O$11,O10)>1,AND(NOT(ISBLANK(O10)),ISNA(MATCH(O10,ComponentAbbrevNoAgency,0))))","v":false},false,{"$f":"OR(AND(ISBLANK($O10),NOT(ISBLANK(Q10))),AND(NOT(ISBLANK($O10)),NOT(IsNonNegativeDecimal(Q10,FALSE,TRUE,TRUE))))","v":false},false,false,false,false,false,false,false,false,false,false]
[null,false,false,false,false,false,false,false,false,false,false,false,false,null,"AGENCY OVERALL",20,18.8,16,20,30,29.2,27,30,"N/A","N/A","N/A","N/A"]
[{"$f":"OR(A9:M11)","v":false}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Footnotes"]

{"sheet":"VII.C.1.","index":17,"n_rows":13,"n_cols":30,"rows_kept":13,"cut":false,"hidden":true,"merged":[[16,15,16,29],[2,15,2,29],[4,15,4,24],[13,15,13,29],[14,15,14,29],[15,15,15,29]]}
["Component"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blank lines are ignored, but if the component column is filled in, all other editable columns must be filled in. All values must be non-negative integers.\n"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VII. C. Processed Requests - Response Time in Day Increments - Simple Requests"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Agency / Component","<1-20\nDays","21-40\nDays","41-60\nDays","61-80\nDays","81-100 Days","101-120 Days","121-140 Days","141-160 Days","161-180 Days","181-200 Days","201-300 Days","301-400 Days","401+\nDays","TOTAL"]
[{"$f":"OR(COUNTIF($P$8:$P$10,P8)>1,AND(NOT(ISBLANK(P8)),ISNA(MATCH(P8,ComponentAbbreviation,0))))","v":false},{"$f":"OR(AND(ISBLANK($P8),NOT(ISBLANK(Q8))),AND(NOT(ISBLANK($P8)),NOT(IsNonNegativeInteger(Q8))))","v":false},false,false,false,false,false,false,false,false,false,false,false,false,null,"USITC",20,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Q8:AC8)","v":20}]
[{"$f":"OR(COUNTIF($P$8:$P$10,P9)>1,AND(NOT(ISBLANK(P9)),ISNA(MATCH(P9,ComponentAbbreviation,0))))","v":false},false,false,false,false,false,false,false,false,false,false,false,false,false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AGENCY OVERALL",{"$f":"SUM(Q8:ptrCellAbove)","v":20},{"$f":"SUM(R8:ptrCellAbove)","v":0},{"$f":"SUM(S8:ptrCellAbove)","v":0},{"$f":"SUM(T8:ptrCellAbove)","v":0},{"$f":"SUM(U8:ptrCellAbove)","v":0},{"$f":"SUM(V8:ptrCellAbove)","v":0},{"$f":"SUM(W8:ptrCellAbove)","v":0},{"$f":"SUM(X8:ptrCellAbove)","v":0},{"$f":"SUM(Y8:ptrCellAbove)","v":0},{"$f":"SUM(Z8:ptrCellAbove)","v":0},{"$f":"SUM(AA8:ptrCellAbove)","v":0},{"$f":"SUM(AB8:ptrCellAbove)","v":0},{"$f":"SUM(AC8:ptrCellAbove)","v":0},{"$f":"SUM(AD8:ptrCellAbove)","v":20}]
[{"$f":"OR(A8:N10)","v":false}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Footnotes"]

{"sheet":"VII.C.2.","index":18,"n_rows":13,"n_cols":30,"rows_kept":13,"cut":false,"hidden":true,"merged":[[16,15,16,29],[4,15,4,24],[2,15,2,29],[13,15,13,29],[14,15,14,29],[15,15,15,29]]}
["Component"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blank lines are ignored, but if the component column is filled in, all other editable columns must be filled in. All values must be non-negative integers.\n"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VII. C. Processed Requests - Response Time in Day Increments - Complex Requests"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Agency / Component","<1-20\nDays","21-40\nDays","41-60\nDays","61-80\nDays","81-100 Days","101-120 Days","121-140 Days","141-160 Days","161-180 Days","181-200 Days","201-300 Days","301-400 Days","401+\nDays","TOTAL"]
[{"$f":"OR(COUNTIF($P$8:$P$10,P8)>1,AND(NOT(ISBLANK(P8)),ISNA(MATCH(P8,ComponentAbbreviation,0))))","v":false},{"$f":"OR(AND(ISBLANK($P8),NOT(ISBLANK(Q8))),AND(NOT(ISBLANK($P8)),NOT(IsNonNegativeInteger(Q8))))","v":false},false,false,false,false,false,false,false,false,false,false,false,false,null,"USITC",0,5,1,0,1,0,0,0,0,0,0,0,0,{"$f":"SUM(Q8:AC8)","v":7}]
[{"$f":"OR(COUNTIF($P$8:$P$10,P9)>1,AND(NOT(ISBLANK(P9)),ISNA(MATCH(P9,ComponentAbbreviation,0))))","v":false},false,false,false,false,false,false,false,false,false,false,false,false,false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AGENCY OVERALL",{"$f":"SUM(Q8:ptrCellAbove)","v":0},{"$f":"SUM(R8:ptrCellAbove)","v":5},{"$f":"SUM(S8:ptrCellAbove)","v":1},{"$f":"SUM(T8:ptrCellAbove)","v":0},{"$f":"SUM(U8:ptrCellAbove)","v":1},{"$f":"SUM(V8:ptrCellAbove)","v":0},{"$f":"SUM(W8:ptrCellAbove)","v":0},{"$f":"SUM(X8:ptrCellAbove)","v":0},{"$f":"SUM(Y8:ptrCellAbove)","v":0},{"$f":"SUM(Z8:ptrCellAbove)","v":0},{"$f":"SUM(AA8:ptrCellAbove)","v":0},{"$f":"SUM(AB8:ptrCellAbove)","v":0},{"$f":"SUM(AC8:ptrCellAbove)","v":0},{"$f":"SUM(AD8:ptrCellAbove)","v":7}]
[{"$f":"OR(A8:N10)","v":false}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Footnotes"]

{"sheet":"VII.C.3.","index":19,"n_rows":13,"n_cols":30,"rows_kept":13,"cut":false,"hidden":true,"merged":[[2,15,2,29],[13,15,13,29],[14,15,14,29],[15,15,15,29],[16,15,16,29],[4,15,4,26]]}
["Component"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Blank lines are ignored, but if the component column is filled in, all other editable columns must be filled in. All values must be non-negative integers.\n"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"VII. C. Processed Requests - Response Time in Day Increments - Requests Granted Expedited Processing"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Agency / Component","<1-20\nDays","21-40\nDays","41-60\nDays","61-80\nDays","81-100 Days","101-120 Days","121-140 Days","141-160 Days","161-180 Days","181-200 Days","201-300 Days","301-400 Days","401+\nDays","TOTAL"]
[{"$f":"OR(COUNTIF($P$8:$P$10,P8)>1,AND(NOT(ISBLANK(P8)),ISNA(MATCH(P8,ComponentAbbreviation,0))))","v":false},{"$f":"OR(AND(ISBLANK($P8),NOT(ISBLANK(Q8))),AND(NOT(ISBLANK($P8)),NOT(IsNonNegativeInteger(Q8))))","v":false},{"$f":"OR(AND(ISBLANK($P8),NOT(ISBLANK(R8))),AND(NOT(ISBLANK($P8)),NOT(IsNonNegativeInteger(R8))))","v":false},false,false,false,false,false,false,false,false,false,false,false,null,"USITC",0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Q8:AC8)","v":0}]
[{"$f":"OR(COUNTIF($P$8:$P$10,P9)>1,AND(NOT(ISBLANK(P9)),ISNA(MATCH(P9,ComponentAbbreviation,0))))","v":false},false,{"$f":"OR(AND(ISBLANK($P9),NOT(ISBLANK(R9))),AND(NOT(ISBLANK($P9)),NOT(IsNonNegativeInteger(R9))))","v":false},false,false,false,false,false,false,false,false,false,false,false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"AGENCY OVERALL",{"$f":"SUM(Q8:ptrCellAbove)","v":0},{"$f":"SUM(R8:ptrCellAbove)","v":0},{"$f":"SUM(S8:ptrCellAbove)","v":0},{"$f":"SUM(T8:ptrCellAbove)","v":0},{"$f":"SUM(U8:ptrCellAbove)","v":0},{"$f":"SUM(V8:ptrCellAbove)","v":0},{"$f":"SUM(W8:ptrCellAbove)","v":0},{"$f":"SUM(X8:ptrCellAbove)","v":0},{"$f":"SUM(Y8:ptrCellAbove)","v":0},{"$f":"SUM(Z8:ptrCellAbove)","v":0},{"$f":"SUM(AA8:ptrCellAbove)","v":0},{"$f":"SUM(AB8:ptrCellAbove)","v":0},{"$f":"SUM(AC8:ptrCellAbove)","v":0},{"$f":"SUM(AD8:ptrCellAbove)","v":0}]
[{"$f":"OR(A8:N10)","v":false}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Footnotes"]

{"sheet":"VII.D.","index":20,"n_rows":14,"n_cols":21,"rows_kept":14,"cut":false,"hidden":true,"merged":[[2,11,2,20],[14,11,14,20],[15,11,15,20],[16,11,16,20],[17,11,17,20],[6,18,6,20],[4,11,4,15],[6,11,7,11],[6,12,6,14],[6,15,6,17]]}
["Component Valid"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"\"AGENCY OVERALL\" information cannot be calculated from component information, and must be entered.\n\nBlank lines are ignored, but if the component column is filled in, all other editable columns must be filled in, as well as all 'AGENCY OVERALL' columns. \"Number Pending\" columns must contain non-negative integer, or the special value \"N/A\". \"Median\" and \"Average\" columns must contain non-negative decimal numbers, or the special value \"N/A\"."]
[]
[null,null,null,null,null,null,null,null,null,null,null,"VII. D. Pending Requests - All Pending Perfected Requests"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Agency / Component","SIMPLE",null,null,"COMPLEX",null,null,"EXPEDITED PROCESSING"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Number Pending","Median Number of Days","Average Number of Days","Number Pending","Median Number of Days","Average Number of Days","Number Pending","Median Number of Days","Average Number of Days"]
[{"$f":"OR(COUNTIF($L$9:$L$11,L9)>1,AND(NOT(ISBLANK(L9)),ISNA(MATCH(L9,ComponentAbbrevNoAgency,0))))","v":false},{"$f":"OR(AND(ISBLANK($L9),NOT(ISBLANK(M9))),AND(NOT(ISBLANK($L9)),NOT(IsNonNegativeInteger(M9))))","v":false},{"$f":"OR(AND(ISBLANK($L9),NOT(ISBLANK(N9))),AND(NOT(ISBLANK($L9)),NOT(IsNonNegativeDecimal(N9,FALSE,TRUE))))","v":false},{"$f":"OR(AND(ISBLANK($L9),NOT(ISBLANK(O9))),AND(NOT(ISBLANK($L9)),NOT(IsNonNegativeDecimal(O9,FALSE,TRUE))))","v":false},{"$f":"OR(AND(ISBLANK($L9),NOT(ISBLANK(P9))),AND(NOT(ISBLANK($L9)),NOT(IsNonNegativeInteger(P9))))","v":false},{"$f":"OR(AND(ISBLANK($L9),NOT(ISBLANK(Q9))),AND(NOT(ISBLANK($L9)),NOT(IsNonNegativeDecimal(Q9,FALSE,TRUE))))","v":false},{"$f":"OR(AND(ISBLANK($L9),NOT(ISBLANK(R9))),AND(NOT(ISBLANK($L9)),NOT(IsNonNegativeDecimal(R9,FALSE,TRUE))))","v":false},{"$f":"OR(AND(ISBLANK($L9),NOT(ISBLANK(S9))),AND(NOT(ISBLANK($L9)),NOT(IsNonNegativeInteger(S9))))","v":false},{"$f":"OR(AND(ISBLANK($L9),NOT(ISBLANK(T9))),AND(NOT(ISBLANK($L9)),NOT(IsNonNegativeDecimal(T9,FALSE,TRUE))))","v":false},{"$f":"OR(AND(ISBLANK($L9),NOT(ISBLANK(U9))),AND(NOT(ISBLANK($L9)),NOT(IsNonNegativeDecimal(U9,FALSE,TRUE))))","v":false}]
[{"$f":"OR(COUNTIF($L$9:$L$11,L10)>1,AND(NOT(ISBLANK(L10)),ISNA(MATCH(L10,ComponentAbbrevNoAgency,0))))","v":false},false,false,false,false,false,false,false,false,false]
[null,{"$f":"NOT(IsNonNegativeInteger(M11))","v":false},{"$f":"NOT(IsNonNegativeDecimal(N11,FALSE,TRUE))","v":false},false,{"$f":"NOT(IsNonNegativeInteger(P11))","v":false},false,false,{"$f":"NOT(IsNonNegativeInteger(S11))","v":false},false,false,null,"AGENCY OVERALL",0,0,0,3,29,26,0,0,0]
[{"$f":"OR(A9:J11)","v":false}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Footnotes"]

{"sheet":"VII.E.","index":21,"n_rows":14,"n_cols":24,"rows_kept":14,"cut":false,"hidden":true,"merged":[[7,0,8,0],[7,12,8,12],[9,0,10,0],[9,12,10,12],[2,12,2,23],[15,12,15,23],[16,12,16,23],[14,12,14,23],[17,12,17,23],[4,12,4,17]]}
["Component Valid","10th Valid","9th Valid","8th Valid","7th Valid","6th Valid","5th Valid","4th Valid","3rd Valid","2nd Valid","1st Valid"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"\"AGENCY OVERALL\" information cannot be calculated from component information, and must be entered.\n\nA component, or the agency overall, may not have ten perfected requests pending. Thus, some columns may be not applicable. In this case, \"N/A\" should be entered in the \"Date of Receipt\" cell, and \"0\" should be entered in the \"Number of Days Pending\" cell. However, if a column is used for a valid date, all columns to the right of it must also be filled in with a valid date. If a date is filled in, the number of days associated with the date must also be filled in. \"Number of Days Pending\" values must be non-negative integers.\n"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"VII. E. Pending Requests - Ten Oldest Pending Perfected Requests"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Agency / Component",null,"10th Oldest Request","9th","8th","7th","6th","5th","4th","3rd","2nd","Oldest Request"]
[{"$f":"OR(COUNTIF($M$8:$M$10,M8)>1,AND(NOT(ISBLANK(M8)),ISNA(MATCH(M8,ComponentAbbrevNoAgency,0))))","v":false},{"$f":"NOT(AND(BothOrNeither($M8,O8),IsValidOldestDate(O8,N8)))","v":false},false,false,false,false,false,false,false,false,false,null,null,"Date of Receipt"]
[null,{"$f":"NOT(AND(BothOrNeither($M8,O9),IsValidOldestPendingDays(O9,N9,O8)))","v":false},false,false,false,false,false,false,false,false,false,null,null,"Number of Days Pending"]
[{"$f":"FALSE","v":false},{"$f":"NOT(IsValidOldestDate(O10,N10))","v":false},{"$f":"NOT(IsValidOldestDate(P10,O10))","v":false},false,false,false,false,false,false,false,false,null,"AGENCY OVERALL","Date of Receipt","N/A","N/A","N/A","N/A","N/A","N/A","N/A","2019-09-25","2019-09-18","2019-08-22"]
[null,{"$f":"NOT(IsValidOldestPendingDays(O11,N11,O10))","v":false},{"$f":"NOT(IsValidOldestPendingDays(P11,O11,P10))","v":false},false,false,false,false,false,false,false,false,null,null,"Number of Days Pending",0,0,0,0,0,0,0,3,8,25]
[{"$f":"OR(A8:K11)","v":false}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Footnotes"]

{"sheet":"VIII.A.","index":22,"n_rows":12,"n_cols":13,"rows_kept":12,"cut":false,"hidden":true,"merged":[[2,7,2,12],[12,7,12,12],[13,7,13,12],[14,7,14,12],[15,7,15,12],[4,7,4,9]]}
["Component","Number Granted","Number Denied","Median","Average","Within Ten"]
[]
[null,null,null,null,null,null,null,"\"AGENCY OVERALL\" information cannot be calculated from component information, and must be entered.\n\nBlank lines are ignored, but if the component column is filled in, all other editable columns must be filled in, as well as all 'AGENCY OVERALL' columns.\n* \"Number Granted\" and \"Number Denied\" columns must contain non-negative integers.\n* \"Median\" and \"Average\" columns must contain non-negative decimal numbers, or the special value \"N/A\".\n* \"Number Adjudicated within Ten Calendar Days\" column must contain non-negative integers, or the special value \"N/A\"."]
[]
[null,null,null,null,null,null,null,"VIII. A. Requests for Expedited Processing"]
[]
[null,null,null,null,null,null,null,"Agency / Component","Number Granted","Number Denied","Median Number of Days to Adjudicate","Average Number of Days to Adjudicate","Number Adjudicated Within Ten Calendar Days"]
[{"$f":"OR(COUNTIF($H$8:$H$10,H8)>1,AND(NOT(ISBLANK(H8)),ISNA(MATCH(H8,ComponentAbbrevNoAgency,0))))","v":false},{"$f":"OR(AND(ISBLANK($H8),NOT(ISBLANK(I8))),AND(NOT(ISBLANK($H8)),NOT(IsNonNegativeInteger(I8))))","v":false},{"$f":"OR(AND(ISBLANK($H8),NOT(ISBLANK(J8))),AND(NOT(ISBLANK($H8)),NOT(IsNonNegativeInteger(J8))))","v":false},{"$f":"OR(AND(ISBLANK($H8),NOT(ISBLANK(K8))),AND(NOT(ISBLANK($H8)),NOT(IsNonNegativeDecimal(K8,FALSE,TRUE))))","v":false},{"$f":"OR(AND(ISBLANK($H8),NOT(ISBLANK(L8))),AND(NOT(ISBLANK($H8)),NOT(IsNonNegativeDecimal(L8,FALSE,TRUE))))","v":false},{"$f":"OR(AND(ISBLANK($H8),NOT(ISBLANK(M8))),AND(NOT(ISBLANK($H8)),NOT(IsNonNegativeInteger(M8,FALSE,TRUE))))","v":false}]
[{"$f":"OR(COUNTIF($H$8:$H$10,H9)>1,AND(NOT(ISBLANK(H9)),ISNA(MATCH(H9,ComponentAbbrevNoAgency,0))))","v":false},false,false,false,false,false]
[null,{"$f":"NOT(IsNonNegativeInteger(I10))","v":false},{"$f":"NOT(IsNonNegativeInteger(J10))","v":false},{"$f":"NOT(IsNonNegativeDecimal(K10,FALSE,TRUE))","v":false},{"$f":"NOT(IsNonNegativeDecimal(L10,FALSE,TRUE))","v":false},{"$f":"NOT(IsNonNegativeInteger(M10,FALSE,TRUE))","v":false},null,"AGENCY OVERALL",0,2,8,5.3,2]
[{"$f":"COUNTIF(A8:F10,TRUE)<>0","v":false}]
[null,null,null,null,null,null,null,"Footnotes"]

{"sheet":"VIII.B.","index":23,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":true,"merged":[[2,6,2,11],[12,6,12,10],[13,6,13,10],[14,6,14,10],[15,6,15,10],[4,6,4,7]]}
["Component","Number Granted","Number Denied","Median","Average"]
[]
[null,null,null,null,null,null,"\"AGENCY OVERALL\" information cannot be calculated from component information, and must be entered.\n\nBlank lines are ignored, but if the component column is filled in, all other editable columns must be filled in, as well as all 'AGENCY OVERALL' columns.\n* \"Number Granted\" and \"Number Denied\" columns must contain non-negative integers.\n* \"Median\" and \"Average\" columns must contain non-negative decimal numbers, or the special value \"N/A\"."]
[]
[null,null,null,null,null,null,"VIII. B. Requests for Fee Waiver"]
[]
[null,null,null,null,null,null,"Agency / Component","Number Granted","Number Denied","Median Number of Days to Adjudicate","Average Number of Days to Adjudicate"]
[{"$f":"OR(COUNTIF($G$8:$G$10,G8)>1,AND(NOT(ISBLANK(G8)),ISNA(MATCH(G8,ComponentAbbrevNoAgency,0))))","v":false},{"$f":"OR(AND(ISBLANK($G8),NOT(ISBLANK(H8))),AND(NOT(ISBLANK($G8)),NOT(IsNonNegativeInteger(H8))))","v":false},{"$f":"OR(AND(ISBLANK($G8),NOT(ISBLANK(I8))),AND(NOT(ISBLANK($G8)),NOT(IsNonNegativeInteger(I8))))","v":false},{"$f":"OR(AND(ISBLANK($G8),NOT(ISBLANK(J8))),AND(NOT(ISBLANK($G8)),NOT(IsNonNegativeDecimal(J8,FALSE,TRUE))))","v":false},{"$f":"OR(AND(ISBLANK($G8),NOT(ISBLANK(K8))),AND(NOT(ISBLANK($G8)),NOT(IsNonNegativeDecimal(K8,FALSE,TRUE))))","v":false}]
[{"$f":"OR(COUNTIF($G$8:$G$10,G9)>1,AND(NOT(ISBLANK(G9)),ISNA(MATCH(G9,ComponentAbbrevNoAgency,0))))","v":false},false,false,false,false]
[{"$f":"FALSE","v":false},{"$f":"NOT(IsNonNegativeInteger(H10))","v":false},{"$f":"NOT(IsNonNegativeInteger(I10))","v":false},{"$f":"NOT(IsNonNegativeDecimal(J10,FALSE,TRUE))","v":false},{"$f":"NOT(IsNonNegativeDecimal(K10,FALSE,TRUE))","v":false},null,"AGENCY OVERALL",0,0,"N/A","N/A"]
[{"$f":"COUNTIF(A8:E10,TRUE)<>0","v":false}]
[null,null,null,null,null,null,"Footnotes"]

{"sheet":"IX.","index":24,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":true,"merged":[[16,6,16,12],[6,6,7,6],[6,7,6,9],[6,10,6,12],[2,6,2,12],[4,6,4,7],[13,6,13,12],[14,6,14,12],[15,6,15,12]]}
["Component","FTE","EFTE","Processing","Litigation"]
[]
[null,null,null,null,null,null,"If the component column is filled in, all other editable columns must be filled in. All values must be non-negative numeric."]
[]
[null,null,null,null,null,null,"IX. FOIA Personnel and Costs"]
[]
[null,null,null,null,null,null,"Agency / Component","PERSONNEL",null,null,"COSTS"]
[null,null,null,null,null,null,null,"Number of \"Full-Time FOIA Employees\"","Number of \"Equivalent Full-Time FOIA Employees\"","Total Number of \"Full-Time FOIA Staff\"","Processing Costs","Litigation-Related Costs","Total Costs"]
[{"$f":"OR(COUNTIF($G$9:$G$11,G9)>1,AND(NOT(ISBLANK(G9)),ISNA(MATCH(G9,ComponentAbbreviation,0))))","v":false},{"$f":"OR(AND(ISBLANK($G9),NOT(ISBLANK(H9))),AND(NOT(ISBLANK($G9)),NOT(IsNonNegativeDecimal(H9))))","v":false},{"$f":"OR(AND(ISBLANK($G9),NOT(ISBLANK(I9))),AND(NOT(ISBLANK($G9)),NOT(IsNonNegativeDecimal(I9))))","v":false},{"$f":"OR(AND(ISBLANK($G9),NOT(ISBLANK(K9))),AND(NOT(ISBLANK($G9)),NOT(IsNonNegativeDecimal(K9))))","v":false},{"$f":"OR(AND(ISBLANK($G9),NOT(ISBLANK(L9))),AND(NOT(ISBLANK($G9)),NOT(IsNonNegativeDecimal(L9))))","v":false},null,"USITC",0,4,{"$f":"SUM(H9:I9)","v":4},10441.41,0,{"$f":"SUM(K9:L9)","v":10441.41}]
[{"$f":"OR(COUNTIF($G$9:$G$11,G10)>1,AND(NOT(ISBLANK(G10)),ISNA(MATCH(G10,ComponentAbbreviation,0))))","v":false},false,false,false,false,null,null,null,null,0,null,null,0]
[null,null,null,null,null,null,"AGENCY OVERALL",{"$f":"SUM(H9:ptrCellAbove)","v":0},{"$f":"SUM(I9:ptrCellAbove)","v":4},{"$f":"SUM(J9:ptrCellAbove)","v":4},{"$f":"SUM(K9:ptrCellAbove)","v":10441.41},{"$f":"SUM(L9:ptrCellAbove)","v":0},{"$f":"SUM(M9:ptrCellAbove)","v":10441.41}]
[{"$f":"COUNTIF(A9:E11,TRUE)<>0","v":false}]
[null,null,null,null,null,null,"Footnotes"]

{"sheet":"X.","index":25,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":true,"merged":[[2,4,2,6],[14,4,14,6],[15,4,15,6],[12,4,12,6],[13,4,13,6],[4,4,4,5]]}
["Component","Fees","Corresponding IX. Processing Costs"]
[]
[null,null,null,null,"If the component column is filled in, the \"Total Amount of Fees Collected\" column must also be filled in. The value must be non-negative numeric.\n\nThe \"Percentage of Total Costs\" column is calculated by comparing the Fees Collected column with Processing Costs from sheet IX."]
[]
[null,null,null,null,"X. Fees Collected for Processing Requests"]
[]
[null,null,null,null,"Agency / Component","Total Amount of Fees Collected","Percentage of Total Costs"]
[{"$f":"OR(COUNTIF($E$8:$E$10,E8)>1,AND(NOT(ISBLANK(E8)),ISNA(MATCH(E8,ComponentAbbreviation,0))))","v":false},{"$f":"OR(AND(ISBLANK($E8),NOT(ISBLANK(F8))),AND(NOT(ISBLANK($E8)),NOT(IsNonNegativeDecimal(F8))))","v":false},{"$f":"INDEX(IX_Processing_Costs,MATCH(E8,IX_Components,0))","v":10441.41},null,"USITC",0,{"$f":"IF(ISNA(C8),\"\",IF(C8=0,0,F8/C8))","v":0}]
[{"$f":"OR(COUNTIF($E$8:$E$10,E9)>1,AND(NOT(ISBLANK(E9)),ISNA(MATCH(E9,ComponentAbbreviation,0))))","v":false},false,{"$error":"#N/A"},null,null,null,""]
[null,null,10441.41,null,"AGENCY OVERALL",{"$f":"SUM(F8:ptrCellAbove)","v":0},0]
[{"$f":"COUNTIF(A8:B10,TRUE)<>0","v":false}]
[null,null,null,null,"Footnotes"]

{"sheet":"XI.A.","index":26,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":true,"merged":[[15,4,15,8],[2,4,2,8],[4,4,4,5],[12,4,12,8],[13,4,13,8],[14,4,14,8]]}
["Component"]
[]
[null,null,null,null,"Blank lines are ignored, but if the component column is filled in, all other editable columns must be filled in.\n* \"Number of Times Subsection Used\" column must contain non-negative integers."]
[]
[null,null,null,null,"XI.A. Number of Times Subsection (C) Used"]
[]
[null,null,null,null,"Agency / Component","Number of Times Subsection Used"]
[{"$f":"OR(COUNTIF($E$8:$E$10,E8)>1,AND(NOT(ISBLANK(E8)),ISNA(MATCH(E8,ComponentAbbreviation,0))))","v":false},{"$f":"OR(AND(ISBLANK($E8),NOT(ISBLANK(F8))),AND(NOT(ISBLANK($E8)),NOT(IsNonNegativeInteger(F8,FALSE,TRUE))))","v":false},null,null,"USITC",0]
[{"$f":"OR(COUNTIF($E$8:$E$10,E9)>1,AND(NOT(ISBLANK(E9)),ISNA(MATCH(E9,ComponentAbbreviation,0))))","v":false},{"$f":"OR(AND(ISBLANK($E9),NOT(ISBLANK(F9))),AND(NOT(ISBLANK($E9)),NOT(IsNonNegativeInteger(F9,FALSE,TRUE))))","v":false}]
[null,null,null,null,"AGENCY OVERALL",{"$f":"SUM(F8:ptrCellAbove)","v":0}]
[{"$f":"COUNTIF(A8:B10,TRUE)<>0","v":false}]
[null,null,null,null,"Footnotes"]

{"sheet":"XI.B.","index":27,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":true,"merged":[[15,4,15,9],[2,4,2,9],[4,4,4,6],[12,4,12,9],[13,4,13,9],[14,4,14,9]]}
["Component"]
[]
[null,null,null,null,"Blank lines are ignored, but if the component column is filled in, all other editable columns must be filled in.\n* \"Number of Records Posted by the FOIA Office\" column must contain non-negative integers.\n* \"Number of Records Posted by Program Offices\" column must contain non-negative integers."]
[]
[null,null,null,null,"XI.B. Number of Subsection (A)(2) Postings"]
[]
[null,null,null,null,"Agency / Component","Number of Records Posted by the FOIA Office","Number of Records Posted by Program Offices"]
[{"$f":"OR(COUNTIF($E$8:$E$10,E8)>1,AND(NOT(ISBLANK(E8)),ISNA(MATCH(E8,ComponentAbbreviation,0))))","v":false},{"$f":"OR(AND(ISBLANK($E8),NOT(ISBLANK(F8))),AND(NOT(ISBLANK($E8)),NOT(IsNonNegativeInteger(F8))))","v":false},{"$f":"OR(AND(ISBLANK($E8),NOT(ISBLANK(G8))),AND(NOT(ISBLANK($E8)),NOT(IsNonNegativeInteger(G8,FALSE,TRUE))))","v":false},null,"USITC",0,233]
[{"$f":"OR(COUNTIF($E$8:$E$10,E9)>1,AND(NOT(ISBLANK(E9)),ISNA(MATCH(E9,ComponentAbbreviation,0))))","v":false},false,false]
[null,null,null,null,"AGENCY OVERALL",{"$f":"SUM(F8:ptrCellAbove)","v":0},{"$f":"SUM(G8:ptrCellAbove)","v":233}]
[{"$f":"COUNTIF(A8:C10,TRUE)<>0","v":false}]
[null,null,null,null,"Footnotes"]

{"sheet":"XII.A.","index":28,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":true,"merged":[[2,4,2,9],[13,4,13,9],[14,4,14,9],[12,4,12,9],[15,4,15,9],[4,4,4,6]]}
["Component"]
[]
[null,null,null,null,"Blank lines are ignored, but if the component column is filled in, all other editable columns must be filled in.\n* \"Number of Backlogged Requests\" column must contain non-negative integers.\n* \"Number of Backlogged Appeals\" column must contain non-negative integers, or the special value \"N/A\"."]
[]
[null,null,null,null,"XII.A. Backlogs of FOIA Requests and Administrative Appeals"]
[]
[null,null,null,null,"Agency / Component","Number of Backlogged Requests as of End of Fiscal Year","Number of Backlogged Appeals as of End of Fiscal Year"]
[{"$f":"OR(COUNTIF($E$8:$E$10,E8)>1,AND(NOT(ISBLANK(E8)),ISNA(MATCH(E8,ComponentAbbreviation,0))))","v":false},{"$f":"OR(AND(ISBLANK($E8),NOT(ISBLANK(F8))),AND(NOT(ISBLANK($E8)),NOT(IsNonNegativeInteger(F8))))","v":false},{"$f":"OR(AND(ISBLANK($E8),NOT(ISBLANK(G8))),AND(NOT(ISBLANK($E8)),NOT(IsNonNegativeInteger(G8,FALSE,TRUE))))","v":false},null,"USITC",3,0]
[{"$f":"OR(COUNTIF($E$8:$E$10,E9)>1,AND(NOT(ISBLANK(E9)),ISNA(MATCH(E9,ComponentAbbreviation,0))))","v":false},false,false]
[null,null,null,null,"AGENCY OVERALL",{"$f":"SUM(F8:ptrCellAbove)","v":3},{"$f":"SUM(G8:ptrCellAbove)","v":0}]
[{"$f":"COUNTIF(A8:C10,TRUE)<>0","v":false}]
[null,null,null,null,"Footnotes"]

{"sheet":"XII.B.","index":29,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":true,"merged":[[16,5,16,9],[4,5,4,9],[2,5,2,9],[13,5,13,9],[14,5,14,9],[15,5,15,9]]}
["Component Valid","Start","Received","Processed"]
[]
[null,null,null,null,null,"Each row represents values for a single component. Enter the component abbreviation, or choose it from the drop-down, then enter values for that component in the editable columns to the right. Component abbreviations must match those set up on the 'Agency Information' sheet. If the report is not broken out by component, the agency abbreviation must be entered, which is the only option offered in the drop-down.\n\nBlank lines are ignored, but if the component column is filled in, all other editable columns must be filled in. All values must be non-negative integers."]
[]
[null,null,null,null,null,"XII. B. Consultations on FOIA Requests - Received, Processed, and Pending Consultations"]
[]
[null,null,null,null,null,"Agency / Component","Number of Consultations Received from Other Agencies that were Pending at the Agency as of Start\nof the Fiscal Year","Number of\nConsultations Received from Other Agencies During the Fiscal Year","Number of Consultations Received from Other Agencies that were Processed by the Agency During the Fiscal Year","Number of Consultations Received from Other Agencies that were Pending at the Agency as of End\nof the Fiscal Year"]
[{"$f":"OR(COUNTIF(V_A_Components,$F8)>1,AND(NOT(ISBLANK(F8)),ISNA(MATCH(F8,ComponentAbbreviation,0))))","v":false},{"$f":"OR(AND(ISBLANK($F8),NOT(ISBLANK(G8))),AND(NOT(ISBLANK($F8)),NOT(IsNonNegativeInteger(G8))))","v":false},false,false,null,"USITC",0,0,0,{"$f":"G8+H8-I8","v":0}]
[false,false,false,false,null,null,null,null,null,0]
[null,null,null,null,null,"AGENCY OVERALL",{"$f":"SUM(G8:ptrCellAbove)","v":0},{"$f":"SUM(H8:ptrCellAbove)","v":0},{"$f":"SUM(I8:ptrCellAbove)","v":0},{"$f":"SUM(J8:ptrCellAbove)","v":0}]
[{"$f":"OR(A8:D10)","v":false}]
[]
[null,null,null,null,null,"Footnotes"]

{"sheet":"XII.C.","index":30,"n_rows":14,"n_cols":24,"rows_kept":14,"cut":false,"hidden":true,"merged":[[7,0,8,0],[7,12,8,12],[9,0,10,0],[9,12,10,12],[17,12,17,23],[4,12,4,22],[2,12,2,23],[14,12,14,23],[15,12,15,23],[16,12,16,23]]}
["Component Valid","10th Valid","9th Valid","8th Valid","7th Valid","6th Valid","5th Valid","4th Valid","3rd Valid","2nd Valid","1st Valid"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"\"AGENCY OVERALL\" information cannot be calculated from component information, and must be entered.\n\nA component, or the agency overall, may not have ten consultations pending. Thus, some columns may be not applicable. In this case, \"N/A\" should be entered in the \"Date\" cell, and \"0\" should be entered in the \"Number of Days\" cell. However, if a column is used for a valid date, all columns to the right of it must also be filled in with a valid date. If a date is filled in, the number of days associated with the date must also be filled in. \"Number of Days\" values must be non-negative integers.\n"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"XII. C. Consultations on FOIA Requests - Ten Oldest Consultations Received from Other Agencies Pending at Your Agency"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Agency / Component",null,"10th Oldest Consultation","9th","8th","7th","6th","5th","4th","3rd","2nd","Oldest Consultation"]
[{"$f":"OR(COUNTIF($M$8:$M$10,M8)>1,AND(NOT(ISBLANK(M8)),ISNA(MATCH(M8,ComponentAbbrevNoAgency,0))))","v":false},{"$f":"NOT(AND(BothOrNeither($M8,O8),IsValidOldestDate(O8,N8)))","v":false},false,false,false,false,false,false,false,false,false,null,null,"Date"]
[null,{"$f":"NOT(AND(BothOrNeither($M8,O9),IsValidOldestPendingDays(O9,N9,O8)))","v":false},false,false,false,false,false,false,false,false,false,null,null,"Number of Days"]
[{"$f":"FALSE","v":false},{"$f":"NOT(IsValidOldestDate(O10,N10))","v":false},{"$f":"NOT(IsValidOldestDate(P10,O10))","v":false},false,false,false,false,false,false,false,false,null,"AGENCY OVERALL","Date","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A","N/A"]
[null,{"$f":"NOT(IsValidOldestPendingDays(O11,N11,O10))","v":false},{"$f":"NOT(IsValidOldestPendingDays(P11,O11,P10))","v":false},false,false,false,false,false,false,false,false,null,null,"Number of Days",0,0,0,0,0,0,0,0,0,0]
[{"$f":"OR(A8:K11)","v":false}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Footnotes"]

{"sheet":"XII.D.1.","index":31,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":true,"merged":[[2,8,2,12],[15,8,15,12],[16,8,16,12],[4,8,4,12],[6,8,7,8],[6,9,6,10],[6,11,6,12],[13,8,13,12],[14,8,14,12]]}
["Component","Received Last","Received Current","Processed Last","Processed Current","Corresponding V.A. Received","Corresponding V.A. Processed"]
[]
[null,null,null,null,null,null,null,null,"If the component column is filled in, all other editable columns must be filled in. All values must be non-negative integers.\n\nThe values entered for the current fiscal year must match those entered on sheet V.A."]
[]
[null,null,null,null,null,null,null,null,"XII. D. 1. Comparison of Numbers of Requests from Previous and Current Annual Report"]
[]
[null,null,null,null,null,null,null,null,"Agency / Component","NUMBER OF REQUESTS RECEIVED",null,"NUMBER OF REQUESTS PROCESSED"]
[null,null,null,null,null,null,null,null,null,"Number Received During Fiscal Year from Last Year's Annual Report","Number Received During Fiscal Year from Current Annual Report","Number Processed During Fiscal Year from Last Year's Annual Report","Number Processed During Fiscal Year from Current Annual Report"]
[{"$f":"OR(COUNTIF($I$9:$I$11,I9)>1,AND(NOT(ISBLANK(I9)),ISNA(MATCH(I9,ComponentAbbreviation,0))))","v":false},{"$f":"OR(AND(ISBLANK($I9),NOT(ISBLANK(J9))),AND(NOT(ISBLANK($I9)),NOT(IsNonNegativeInteger(J9))))","v":false},{"$f":"OR(AND(ISBLANK($I9),NOT(ISBLANK(K9))),AND(NOT(ISBLANK($I9)),IF(ISNA(F9),TRUE,K9<>F9)))","v":false},{"$f":"OR(AND(ISBLANK($I9),NOT(ISBLANK(L9))),AND(NOT(ISBLANK($I9)),NOT(IsNonNegativeInteger(L9))))","v":false},{"$f":"OR(AND(ISBLANK($I9),NOT(ISBLANK(M9))),AND(NOT(ISBLANK($I9)),IF(ISNA(G9),TRUE,M9<>G9)))","v":false},{"$f":"INDEX(V_A_Received,MATCH(I9,V_A_Components,0))","v":31},{"$f":"INDEX(V_A_Processed,MATCH(I9,V_A_Components,0))","v":28},null,"USITC",34,31,34,28]
[{"$f":"OR(COUNTIF($I$9:$I$11,I10)>1,AND(NOT(ISBLANK(I10)),ISNA(MATCH(I10,ComponentAbbreviation,0))))","v":false},false,false,false,false,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,false,null,false,31,28,null,"AGENCY OVERALL",{"$f":"SUM(J9:ptrCellAbove)","v":34},{"$f":"SUM(K9:ptrCellAbove)","v":31},{"$f":"SUM(L9:ptrCellAbove)","v":34},{"$f":"SUM(M9:ptrCellAbove)","v":28}]
[{"$f":"COUNTIF(A9:E11,TRUE)<>0","v":false}]
[null,null,null,null,null,null,null,null,"Footnotes"]

{"sheet":"XII.D.2.","index":32,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":true,"merged":[[2,5,2,7],[13,5,13,11],[14,5,14,11],[12,5,12,11],[15,5,15,11],[4,5,4,10]]}
["Component","Last","Current","Corresponding XII.A. Requests"]
[]
[null,null,null,null,null,"If the component column is filled in, all other editable columns must be filled in. All values must be non-negative integers.\n\nThe values entered for the current fiscal year must match those entered on sheet XII.A."]
[]
[null,null,null,null,null,"XII. D. 2. Comparison of Backlogged Requests from Previous and Current Annual Report"]
[]
[null,null,null,null,null,"Agency / Component","Number of Backlogged Requests as of End of the Fiscal Year from Previous Annual Report","Number of Backlogged Requests as of End of the Fiscal Year from Current Annual Report"]
[{"$f":"OR(COUNTIF($F$8:$F$10,F8)>1,AND(NOT(ISBLANK(F8)),ISNA(MATCH(F8,ComponentAbbreviation,0))))","v":false},{"$f":"OR(AND(ISBLANK($F8),NOT(ISBLANK(G8))),AND(NOT(ISBLANK($F8)),NOT(IsNonNegativeInteger(G8))))","v":false},{"$f":"OR(AND(ISBLANK(F8),NOT(ISBLANK(H8))),AND(NOT(ISBLANK(F8)),IF(ISNA(D8),TRUE,H8<>D8)))","v":false},{"$f":"INDEX(XII_A_BackloggedRequests,MATCH(F8,XII_A_Components,0))","v":3},null,"USITC",0,3]
[{"$f":"OR(COUNTIF($F$8:$F$10,F9)>1,AND(NOT(ISBLANK(F9)),ISNA(MATCH(F9,ComponentAbbreviation,0))))","v":false},false,false,{"$error":"#N/A"}]
[null,null,false,3,null,"AGENCY OVERALL",{"$f":"SUM(G8:ptrCellAbove)","v":0},{"$f":"SUM(H8:ptrCellAbove)","v":3}]
[{"$f":"COUNTIF(A8:C10,TRUE)<>0","v":false}]
[null,null,null,null,null,"Footnotes"]

{"sheet":"XII.E.1.","index":33,"n_rows":13,"n_cols":13,"rows_kept":13,"cut":false,"hidden":true,"merged":[[2,8,2,12],[4,8,4,12],[15,8,15,12],[16,8,16,12],[6,8,7,8],[6,9,6,10],[6,11,6,12],[13,8,13,12],[14,8,14,12]]}
["Component","Received Last","Received Current","Processed Last","Processed Current","Corresponding VI.A. Received","Corresponding VI.A. Processed"]
[]
[null,null,null,null,null,null,null,null,"If the component column is filled in, all other editable columns must be filled in. All values must be non-negative integers.\n\nThe values entered for the current fiscal year must match those entered on sheet VI.A."]
[]
[null,null,null,null,null,null,null,null,"XII. E. 1. Comparison of Numbers of Administrative Appeals from Previous and Current Annual Report"]
[]
[null,null,null,null,null,null,null,null,"Agency / Component","NUMBER OF APPEALS RECEIVED",null,"NUMBER OF APPEALS PROCESSED"]
[null,null,null,null,null,null,null,null,null,"Number Received During Fiscal Year from Last Year's Annual Report","Number Received During Fiscal Year from Current Annual Report","Number Processed During Fiscal Year from Last Year's Annual Report","Number Processed During Fiscal Year from Current Annual Report"]
[{"$f":"OR(COUNTIF($I$9:$I$11,I9)>1,AND(NOT(ISBLANK(I9)),ISNA(MATCH(I9,ComponentAbbreviation,0))))","v":false},{"$f":"OR(AND(ISBLANK($I9),NOT(ISBLANK(J9))),AND(NOT(ISBLANK($I9)),NOT(IsNonNegativeInteger(J9))))","v":false},{"$f":"OR(AND(ISBLANK(I9),NOT(ISBLANK(K9))),AND(NOT(ISBLANK(I9)),IF(ISNA(F9),TRUE,K9<>F9)))","v":false},{"$f":"OR(AND(ISBLANK($I9),NOT(ISBLANK(L9))),AND(NOT(ISBLANK($I9)),NOT(IsNonNegativeInteger(L9))))","v":false},{"$f":"OR(AND(ISBLANK(I9),NOT(ISBLANK(M9))),AND(NOT(ISBLANK(I9)),IF(ISNA(G9),TRUE,M9<>G9)))","v":false},{"$f":"INDEX(VI_A_Received,MATCH(I9,VI_A_Components,0))","v":0},{"$f":"INDEX(VI_A_Processed,MATCH(I9,VI_A_Components,0))","v":0},null,"USITC",2,0,2,0]
[{"$f":"OR(COUNTIF($I$9:$I$11,I10)>1,AND(NOT(ISBLANK(I10)),ISNA(MATCH(I10,ComponentAbbreviation,0))))","v":false},{"$f":"OR(AND(ISBLANK($I10),NOT(ISBLANK(J10))),AND(NOT(ISBLANK($I10)),NOT(IsNonNegativeInteger(J10))))","v":false},{"$f":"OR(AND(ISBLANK(I10),NOT(ISBLANK(K10))),AND(NOT(ISBLANK(I10)),IF(ISNA(F10),TRUE,K10<>F10)))","v":false},{"$f":"OR(AND(ISBLANK($I10),NOT(ISBLANK(L10))),AND(NOT(ISBLANK($I10)),NOT(IsNonNegativeInteger(L10))))","v":false},{"$f":"OR(AND(ISBLANK(I10),NOT(ISBLANK(M10))),AND(NOT(ISBLANK(I10)),IF(ISNA(G10),TRUE,M10<>G10)))","v":false},{"$f":"INDEX(VI_A_Received,MATCH(I10,VI_A_Components,0))","v":{"$error":"#N/A"}},{"$f":"INDEX(VI_A_Processed,MATCH(I10,VI_A_Components,0))","v":{"$error":"#N/A"}}]
[null,null,{"$f":"OR(AND(ISBLANK(I11),NOT(ISBLANK(K11))),AND(NOT(ISBLANK(I11)),IF(ISNA(F11),TRUE,K11<>F11)))","v":false},null,{"$f":"OR(AND(ISBLANK(I11),NOT(ISBLANK(M11))),AND(NOT(ISBLANK(I11)),IF(ISNA(G11),TRUE,M11<>G11)))","v":false},{"$f":"INDEX(VI_A_Received,MATCH(I11,VI_A_Components,0))","v":0},{"$f":"INDEX(VI_A_Processed,MATCH(I11,VI_A_Components,0))","v":0},null,"AGENCY OVERALL",{"$f":"SUM(J9:ptrCellAbove)","v":2},{"$f":"SUM(K9:ptrCellAbove)","v":0},{"$f":"SUM(L9:ptrCellAbove)","v":2},{"$f":"SUM(M9:ptrCellAbove)","v":0}]
[{"$f":"COUNTIF(A9:E11,TRUE)<>0","v":false}]
[null,null,null,null,null,null,null,null,"Footnotes"]

{"sheet":"XII.E.2.","index":34,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":true,"merged":[[2,5,2,7],[12,5,12,11],[13,5,13,11],[14,5,14,11],[15,5,15,11],[4,5,4,11]]}
["Component","Last","Current","Corresponding XII.A. Appeals"]
[]
[null,null,null,null,null,"If the component column is filled in, all other editable columns must be filled in. All values must be non-negative integers.\n\nThe values entered for the current fiscal year must match those entered on sheet XII.A."]
[]
[null,null,null,null,null,"XII. E. 2. Comparison of Backlogged Administrative Appeals from Previous and Current Annual Report"]
[]
[null,null,null,null,null,"Agency / Component","Number of Backlogged Appeals as of End of the Fiscal Year from Previous Annual Report","Number of Backlogged Appeals as of End of the Fiscal Year from Current Annual Report"]
[{"$f":"OR(COUNTIF($F$8:$F$10,F8)>1,AND(NOT(ISBLANK(F8)),ISNA(MATCH(F8,ComponentAbbreviation,0))))","v":false},{"$f":"OR(AND(ISBLANK($F8),NOT(ISBLANK(G8))),AND(NOT(ISBLANK($F8)),NOT(IsNonNegativeInteger(G8))))","v":false},{"$f":"OR(AND(ISBLANK(F8),NOT(ISBLANK(H8))),AND(NOT(ISBLANK(F8)),IF(ISNA(D8),TRUE,H8<>D8)))","v":false},{"$f":"INDEX(XII_A_BackloggedAppeals,MATCH(F8,XII_A_Components,0))","v":0},null,"USITC",0,0]
[{"$f":"OR(COUNTIF($F$8:$F$10,F9)>1,AND(NOT(ISBLANK(F9)),ISNA(MATCH(F9,ComponentAbbreviation,0))))","v":false},{"$f":"OR(AND(ISBLANK($F9),NOT(ISBLANK(G9))),AND(NOT(ISBLANK($F9)),NOT(IsNonNegativeInteger(G9))))","v":false},{"$f":"OR(AND(ISBLANK(F9),NOT(ISBLANK(H9))),AND(NOT(ISBLANK(F9)),IF(ISNA(D9),TRUE,H9<>D9)))","v":false},{"$f":"INDEX(XII_A_BackloggedAppeals,MATCH(F9,XII_A_Components,0))","v":{"$error":"#N/A"}}]
[null,null,{"$f":"OR(AND(ISBLANK(F10),NOT(ISBLANK(H10))),AND(NOT(ISBLANK(F10)),IF(ISNA(D10),TRUE,H10<>D10)))","v":false},{"$f":"INDEX(XII_A_BackloggedAppeals,MATCH(F10,XII_A_Components,0))","v":0},null,"AGENCY OVERALL",{"$f":"SUM(G8:ptrCellAbove)","v":0},{"$f":"SUM(H8:ptrCellAbove)","v":0}]
[{"$f":"COUNTIF(A8:C10,TRUE)<>0","v":false}]
[null,null,null,null,null,"Footnotes"]

{"sheet":"wksUISettings","index":35,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
["Worksheets","setProgRows","setProgCols","setEnableSelect","setRowColHeaders","setVisible","setProtect"]
["wksAgencyInformation",1,1,{"$f":"xlUnlockedCells","v":1},false,true,true]
["wksExemption3Statutes",1,1,1,false,true,true]
["wksProcessedRequest",1,4,1,false,true,true]
["wksRequestDisposition",1,15,1,false,true,true]
["wksOtherDenialReason",1,5,1,false,true,true]
["wksRequestDispositionExemptions",1,15,1,false,true,true]
["wksProcessedAppeal",1,4,1,false,true,true]
["wksAppealDisposition",1,7,1,false,true,true]
["wksAppealDispositionExemptions",1,15,1,false,true,true]
["wksAppealNonExemptionDenial",1,12,1,false,true,true]
["wksAppealDenialOtherReason",1,5,1,false,true,true]
["wksAppealResponseTime",1,5,1,false,true,true]
["wksOldestPendingAppeal",1,11,1,false,true,true]
["wksProcessedResponseTime",1,13,1,false,true,true]
["wksInfoGrantedResponseTime",1,13,1,false,true,true]
["wksSimpleTimeIncrements",1,14,1,false,true,true]
["wksComplexTimeIncrements",1,14,1,false,true,true]
["wksExpeditedTimeIncrements",1,14,1,false,true,true]
["wksPendingPerfectedRequests",1,10,1,false,true,true]
["wksOldestPendingRequest",1,11,1,false,true,true]
["wksExpeditedProcessing",1,6,1,false,true,true]
["wksFeeWaiver",1,5,1,false,true,true]
["wksPersonnelAndCost",1,5,1,false,true,true]
["wksFeesCollected",1,3,1,false,true,true]
["wksBacklog",1,3,1,false,true,true]
["wksProcessedConsultation",1,4,1,false,true,true]
["wksOldestPendingConsultation",1,11,1,false,true,true]
["wksRequestComparison",1,7,1,false,true,true]
["wksBackloggedRequestComparison",1,4,1,false,true,true]
["wksAppealComparison",1,7,1,false,true,true]
["wksBackloggedAppealComparison",1,4,1,false,true,true]
["wksEnableMacros",0,0,{"$f":"xlNoRestrictions","v":0},false,false,true]
["wksInstructions",0,0,{"$f":"xlNoRestrictions","v":0},false,true,true]
["wksImplementationNotes",0,0,{"$f":"xlNoRestrictions","v":0},true,false,false]
["wksUISettings",0,0,{"$f":"xlNoRestrictions","v":0},true,false,false]

{"sheet":"Implementation Notes","index":36,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}