{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Instructions","Section 1","Section 2","Summary","Reference List","Checks","Lists","OutputForCSV"],"not_rendered":{"macros":1,"defined_names":36,"comments":4},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":21,"n_cols":3,"rows_kept":21}
[]
[null,null,"U.S. Environmental Protection Agency"]
[null,null,"Stratospheric Ozone Protection Program"]
[]
[null,null,"Class II Trades Report (Sec 82.23)"]
[null,null,"Version 1.0 "]
[null,null,"Last Updated: April 2018"]
[]
[null,null,"Instructions"]
[null,null,"Complete this form by filling in the data fields that are highlighted in blue.  Guidance on how to complete individual data fields are provided in comment bubbles. Use the arrows to navigate between the tabs. Once completed, use the 'prepare submission' button on the Summary tab to generate your CSV file.  "]
[null,null,"Copying and Pasting Data: If data are pasted into this reporting form from another spreadsheet, the formatting of specific cells must be consistent with the requirements of the form in order to be "]
[null,null,"accepted into EPA’s ODS Tracking System. Refer to the Reference List to identify the valid naming scheme for specific data fields. Additionally, select \"Paste As Values\" when pasting data into the form."]
[null,null,"Report Submission: This Excel file, the generated CSV file, and all supporting attachments should be submitted to EPA through the Central Data Exchange (CDX). Refer to EPA's website for additional information on form submission:"]
[null,null,"https://www.epa.gov/ods-phaseout/ods-recordkeeping-and-reporting "]
[]
[null,null,"All information submitted to EPA will be treated as confidential in accordance with 40 CFR Part 2, Subpart B, and will only be disclosed by the means set forth in the subpart. "]
[null,null,"The public reporting and recordkeeping burden for this collection of information is estimated to average 4 hours per response.  Send comments on the Agency's need for this information, the accuracy of the provided burden estimates, and any suggested methods for minimizing respondent burden, including through the use of automated collection techniques to the Director, Collection Strategies Division, U.S. Environmental Protection Agency (2822T), 1200 Pennsylvania Avenue, NW, Washington, D.C. 20460.  Include the OMB control number in any correspondence.  Do not send the completed form to this address."]
[]
[null,null,"EPA Form #5900-205"]
[null,null,"OMB Control Number: 2060-0498"]
[null,null,"Expiration Date: 4/30/2019"]

{"sheet":"Section 1","index":1,"n_rows":14,"n_cols":9,"rows_kept":14,"merged":[[2,2,2,3],[7,2,7,3]]}
[]
[null,null,"U.S. Environmental Protection Agency"]
[null,null,"Class II Trades Report "]
[]
[null,null,"   Date Prepared:",{"$f":"TODAY()","v":"2018-05-22"}]
[]
[null,null,"Section 1: Transferor Identification Information "]
[null,null,"Complete all fields below.  No fields may be left blank."]
[null,null,"Company Name: ",null,null,{"$f":"IF(D9=0,1,0)","v":1}]
[null,null,"Submission Type:",null,null,{"$f":"IF(D10=0,1,0)","v":1}]
[null,null,"Reporting Year:",null,null,{"$f":"IF(OR($D$11=0,$D$11>YEAR(TODAY())),1,0)","v":1},null,null,{"$f":"IF(D11>YEAR(TODAY()),\"PLEASE CHOOSE A CURRENT OR PAST YEAR\",\"\")","v":""}]
[{"$nulls":3},""]
[{"$nulls":3},{"$f":"Lists!D3","v":"Original Submission"}]
[{"$nulls":3},{"$f":"Lists!D4","v":"Re-Submittal"}]

{"sheet":"Section 2","index":2,"n_rows":234,"n_cols":24,"rows_kept":234,"merged":[[9,3,10,3],[9,4,10,4],[9,5,10,5],[9,6,10,6],[9,7,10,7],[9,8,10,8],[9,9,10,9],[9,10,10,10],[16,3,16,14],[17,3,18,3],[17,4,17,6],[17,7,17,9],[17,10,17,11],[17,12,17,14]]}
[]
[{"$nulls":3},"U.S. Environmental Protection Agency"]
[null,null,{"$f":"IFERROR(VLOOKUP($A3,'Section 2'!E$22:$O$31,COLUMNS('Section 2'!$D$18:D$19),0),\"\")","v":""},"Class II Trades Report "]
[]
[{"$nulls":3},"Company Name:",{"$f":"IF('Section 1'!D9=0,\"\",'Section 1'!D9)","v":""}]
[{"$nulls":3},"Reporting Period:",{"$f":"IF('Section 1'!D11=0,\"\",'Section 1'!D11)","v":""}]
[]
[{"$nulls":3},"Section 2: Transaction Data"]
[{"$nulls":3},"In the table below, enter the contact information for the recipient of the trade.  If reporting on an inter-pollutant, intra-company trade, enter your company's name as the transferee company; the other fields may be left blank. "]
[{"$nulls":3},"Transferee Company Name","Transferee Contact Name","Transferee Contact Phone Number","Transferee Street Address","Transferee City","Transferee State/Province","Transferee Country","Transferee Postal Code"]
[]
[{"$nulls":3},"Text","Text","Text","Text","Text","Selection/Text","Selection","Text",{"$nulls":8},"Checks"]
[{"$nulls":3},"Company A","John Smith","202 555 5555","1 Main Street","Los Angeles","California","United States of America","90001",{"$nulls":8},"Row Completed","Valid State/Province","Valid Country"]
[{"$f":"IF($D$14=\"\",\"\",1)","v":""},{"$nulls":16},{"$f":"IF($T$14>0,\"ROW INCOMPLETE OR INVALID DATA ENTERED; ENTER/EDIT DATA IN REQUIRED FIELDS\",\"\")","v":""},null,{"$f":"IF(AND($D$14<>'Section 1'!$D$9,$A$14=1),IF(OR($D$14=0,$E$14=0,$F$14=0,$G$14=0,$H$14=0,$I$14=0,$J$14=0,$K$14=0),1,0),0)","v":0},{"$f":"IF($J$14=Lists!$B$196,IF(COUNTIF(States,'Section 2'!$I$14)>0,0,1),0)","v":0},{"$f":"IF($J$14=0,0,IF(COUNTIF(Countries,$J$14)>0,0,1))","v":0}]
[]
[{"$nulls":3},"In the table below, enter data for each trade request.  For all controlled substances that are transferred, all fields are required unless otherwise indicated.  Note that inter-pollutant trades of baseline year allowances will not be approved."]
[{"$nulls":3},"If copying and pasting data into the table, please refer to the Reference List and the accompanying instructions.\n"]
[{"$nulls":3},"Transaction Number","Allowance Type",null,null,"Allowances Being Transferred",null,null,"Allowances Being Received",null,"Conversion Calculation"]
[{"$nulls":4},"Production, Consumption, or Article 5","Current or Baseline","Domestic or International","Class II Chemical Name","ODP of Class II Chemical Being Transferred","Quantity of Class II Allowances","Class II Chemical Name","ODP of Class II Chemical Being Received","Amount of Offset","Number of Allowances Subtracted from Transferor's Class II Allowance Balance","Number of Class II Allowances Being Received"]
[{"$nulls":3},"Autopopulated","Selection","Selection","Selection","Selection","Autopopulated","kg","Selection","Autopopulated","Autopopulated","Autopopulated","Autopopulated",{"$nulls":4},"Checks"]
[{"$nulls":3},1,"Production","Current","Domestic","HCFC-22",{"$f":"IF(H21=\"\",\"\",VLOOKUP(H21,Lists!$K$2:$L$9,2,FALSE))","v":0.055},{"v":1000,"d":"1,000.00"},"HCFC-123",{"$f":"IF(K21=\"\",\"\",VLOOKUP(K21,Lists!$K$2:$L$9,2,FALSE))","v":0.02},{"$f":"IF(J21=\"\",\"\",0.001*J21)","v":{"v":1,"d":"1.00"}},{"$f":"IFERROR(ROUND(M21+J21,0), \"\")","v":{"v":1001,"d":"1,001"}},{"$f":"IF(M21=\"\",\"\",ROUND(J21*I21/L21,0))","v":{"v":2750,"d":"2,750"}},{"$nulls":4},"ActiveRow?","Row Completed?","Valid Chemical","Valid Chem To","Inter-pollutant check"]
[{"$f":"IF(H22=0, \"\", 1)","v":""},null,null,{"$f":"IF(H22=\"\",\"\",1)","v":""},{"$nulls":4},{"$f":"IF(H22=\"\",\"\",VLOOKUP(H22,Lists!$K$2:$L$9,2,FALSE))","v":""},null,null,{"$f":"IF(K22=\"\",\"\",VLOOKUP(K22,Lists!$K$2:$L$9,2,FALSE))","v":""},"",{"$f":"IFERROR(ROUND(M22+J22,0), \"\")","v":""},{"$f":"IF(M22=\"\",\"\",ROUND(J22*I22/L22,0))","v":""},null,null,{"$f":"IF(SUM(U22:X22)>0,\"ROW INCOMPLETE OR INVALID DATA ENTERED; ENTER/EDIT DATA IN REQUIRED FIELDS\",\"\")","v":""},null,{"$f":"IF(D22=\"\",\"N\",\"Y\")","v":"N"},{"$f":"IF(D22=\"\",0,IF(OR(E22=0, F22=0, G22=0, H22=0, J22=0, K22=0),1,0))","v":0},{"$f":"IF(H22=0,0,IF(COUNTIF(ClassIIChemAllowance,H22)>0,0,1))","v":0},{"$f":"IF(K22=0,0,IF(COUNTIF(ClassIIChemAllowance,K22)>0,0,1))","v":0},{"$f":"IF(F22=Lists!$H$4,IF('Section 2'!H22='Section 2'!K22,0,1),0)","v":0}]
[{"$f":"IF(H23=0, \"\", IF(COUNTIF($H$22:H22, H23)>0, \"\", MAX($A$22:A22)+1))","v":""},null,null,{"$f":"IF(H23=\"\",\"\",MAX($D$22:D22)+1)","v":""},{"$nulls":4},{"$f":"IF(H23=\"\",\"\",VLOOKUP(H23,Lists!$K$2:$L$9,2,FALSE))","v":""},null,null,{"$f":"IF(K23=\"\",\"\",VLOOKUP(K23,Lists!$K$2:$L$9,2,FALSE))","v":""},"","",{"$f":"IF(M23=\"\",\"\",ROUND(J23*I23/L23,0))","v":""},null,null,{"$f":"IF(SUM(U23:X23)>0,\"ROW INCOMPLETE OR INVALID DATA ENTERED; ENTER/EDIT DATA IN REQUIRED FIELDS\",\"\")","v":""},null,"N",{"$f":"IF(D23=\"\",0,IF(OR(E23=0, F23=0, G23=0, H23=0, J23=0, K23=0),1,0))","v":0},0,0,{"$f":"IF(F23=Lists!$H$4,IF('Section 2'!H23='Section 2'!K23,0,1),0)","v":0}]
[{"$f":"IF(H24=0, \"\", IF(COUNTIF($H$22:H23, H24)>0, \"\", MAX($A$22:A23)+1))","v":""},null,null,{"$f":"IF(H24=\"\",\"\",MAX($D$22:D23)+1)","v":""},{"$nulls":4},{"$f":"IF(H24=\"\",\"\",VLOOKUP(H24,Lists!$K$2:$L$9,2,FALSE))","v":""},null,null,{"$f":"IF(K24=\"\",\"\",VLOOKUP(K24,Lists!$K$2:$L$9,2,FALSE))","v":""},"","","",null,null,"",null,"N",0,0,0,{"$f":"IF(F24=Lists!$H$4,IF('Section 2'!H24='Section 2'!K24,0,1),0)","v":0}]
[{"$f":"IF(H25=0, \"\", IF(COUNTIF($H$22:H24, H25)>0, \"\", MAX($A$22:A24)+1))","v":""},null,null,{"$f":"IF(H25=\"\",\"\",MAX($D$22:D24)+1)","v":""},{"$nulls":4},{"$f":"IF(H25=\"\",\"\",VLOOKUP(H25,Lists!$K$2:$L$9,2,FALSE))","v":""},null,null,{"$f":"IF(K25=\"\",\"\",VLOOKUP(K25,Lists!$K$2:$L$9,2,FALSE))","v":""},"","","",null,null,"",null,"N",0,0,0,{"$f":"IF(F25=Lists!$H$4,IF('Section 2'!H25='Section 2'!K25,0,1),0)","v":0}]
[{"$f":"IF(H26=0, \"\", IF(COUNTIF($H$22:H25, H26)>0, \"\", MAX($A$22:A25)+1))","v":""},null,null,{"$f":"IF(H26=\"\",\"\",MAX($D$22:D25)+1)","v":""},{"$nulls":4},{"$f":"IF(H26=\"\",\"\",VLOOKUP(H26,Lists!$K$2:$L$9,2,FALSE))","v":""},null,null,{"$f":"IF(K26=\"\",\"\",VLOOKUP(K26,Lists!$K$2:$L$9,2,FALSE))","v":""},"","","",null,null,"",null,"N",0,0,0,{"$f":"IF(F26=Lists!$H$4,IF('Section 2'!H26='Section 2'!K26,0,1),0)","v":0}]
[{"$f":"IF(H27=0, \"\", IF(COUNTIF($H$22:H26, H27)>0, \"\", MAX($A$22:A26)+1))","v":""},null,null,{"$f":"IF(H27=\"\",\"\",MAX($D$22:D26)+1)","v":""},{"$nulls":4},{"$f":"IF(H27=\"\",\"\",VLOOKUP(H27,Lists!$K$2:$L$9,2,FALSE))","v":""},null,null,{"$f":"IF(K27=\"\",\"\",VLOOKUP(K27,Lists!$K$2:$L$9,2,FALSE))","v":""},"","",{"$f":"IF(M27=\"\",\"\",ROUND(J27*I27/L27,0))","v":""},null,null,"",null,"N",0,0,0,{"$f":"IF(F27=Lists!$H$4,IF('Section 2'!H27='Section 2'!K27,0,1),0)","v":0}]
[{"$f":"IF(H28=0, \"\", IF(COUNTIF($H$22:H27, H28)>0, \"\", MAX($A$22:A27)+1))","v":""},null,null,{"$f":"IF(H28=\"\",\"\",MAX($D$22:D27)+1)","v":""},{"$nulls":4},{"$f":"IF(H28=\"\",\"\",VLOOKUP(H28,Lists!$K$2:$L$9,2,FALSE))","v":""},null,null,{"$f":"IF(K28=\"\",\"\",VLOOKUP(K28,Lists!$K$2:$L$9,2,FALSE))","v":""},"","","",null,null,{"$f":"IF(SUM(U28:X28)>0,\"ROW INCOMPLETE OR INVALID DATA ENTERED; ENTER/EDIT DATA IN REQUIRED FIELDS\",\"\")","v":""},null,"N",0,0,0,{"$f":"IF(F28=Lists!$H$4,IF('Section 2'!H28='Section 2'!K28,0,1),0)","v":0}]
[{"$f":"IF(H29=0, \"\", IF(COUNTIF($H$22:H28, H29)>0, \"\", MAX($A$22:A28)+1))","v":""},null,null,{"$f":"IF(H29=\"\",\"\",MAX($D$22:D28)+1)","v":""},{"$nulls":4},{"$f":"IF(H29=\"\",\"\",VLOOKUP(H29,Lists!$K$2:$L$9,2,FALSE))","v":""},null,null,{"$f":"IF(K29=\"\",\"\",VLOOKUP(K29,Lists!$K$2:$L$9,2,FALSE))","v":""},"","","",null,null,"",null,"N",0,0,0,{"$f":"IF(F29=Lists!$H$4,IF('Section 2'!H29='Section 2'!K29,0,1),0)","v":0}]
[{"$f":"IF(H30=0, \"\", IF(COUNTIF($H$22:H29, H30)>0, \"\", MAX($A$22:A29)+1))","v":""},null,null,{"$f":"IF(H30=\"\",\"\",MAX($D$22:D29)+1)","v":""},{"$nulls":4},{"$f":"IF(H30=\"\",\"\",VLOOKUP(H30,Lists!$K$2:$L$9,2,FALSE))","v":""},null,null,{"$f":"IF(K30=\"\",\"\",VLOOKUP(K30,Lists!$K$2:$L$9,2,FALSE))","v":""},"","","",null,null,"",null,"N",0,0,0,{"$f":"IF(F30=Lists!$H$4,IF('Section 2'!H30='Section 2'!K30,0,1),0)","v":0}]
[{"$f":"IF(H31=0, \"\", IF(COUNTIF($H$22:H30, H31)>0, \"\", MAX($A$22:A30)+1))","v":""},{"$f":"IF(COUNTA(N31:N31)>0,0,1)","v":0},null,{"$f":"IF(H31=\"\",\"\",MAX($D$22:D30)+1)","v":""},{"$nulls":4},{"$f":"IF(H31=\"\",\"\",VLOOKUP(H31,Lists!$K$2:$L$9,2,FALSE))","v":""},null,null,{"$f":"IF(K31=\"\",\"\",VLOOKUP(K31,Lists!$K$2:$L$9,2,FALSE))","v":""},"","","",null,null,"",null,"N",0,0,0,{"$f":"IF(F31=Lists!$H$4,IF('Section 2'!H31='Section 2'!K31,0,1),0)","v":0}]
[{"$nulls":4},"x","x","x","x",null,null,"x"]
[{"$nulls":9},{"$f":"Lists!C3","v":"Alaska"},{"$f":"Lists!B3","v":"Afghanistan"},null,{"$f":"Lists!G3","v":"Production"},{"$f":"Lists!H3","v":"Current"},{"$f":"Lists!I3","v":"Domestic"},null,null,{"$f":"Lists!J3","v":"HCFC-22"}]
[{"$nulls":9},{"$f":"Lists!C4","v":"Alabama"},{"$f":"Lists!B4","v":"Albania"},null,{"$f":"Lists!G4","v":"Consumption"},{"$f":"Lists!H4","v":"Baseline"},{"$f":"Lists!#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"Lists!J4","v":"HCFC-123"}]
[{"$nulls":9},{"$f":"Lists!C5","v":"Arkansas"},{"$f":"Lists!B5","v":"Algeria"},null,{"$f":"Lists!G5","v":"Article 5"},{"$nulls":4},{"$f":"Lists!J5","v":"HCFC-124"}]
[{"$nulls":9},{"$f":"Lists!C6","v":"Arizona"},{"$f":"Lists!B6","v":"Andorra"},{"$nulls":6},{"$f":"Lists!J6","v":"HCFC-141b"}]
[{"$nulls":9},{"$f":"Lists!C7","v":"California"},{"$f":"Lists!B7","v":"Angola"},{"$nulls":6},{"$f":"Lists!J7","v":"HCFC-142b"}]
[{"$nulls":9},{"$f":"Lists!C8","v":"Colorado"},{"$f":"Lists!B8","v":"Antigua and Barbuda"},{"$nulls":6},{"$f":"Lists!J8","v":"HCFC-225ca"}]
[{"$nulls":9},{"$f":"Lists!C9","v":"Connecticut"},{"$f":"Lists!B9","v":"Argentina"},{"$nulls":6},{"$f":"Lists!J9","v":"HCFC-225cb"}]
[{"$nulls":9},{"$f":"Lists!C10","v":"District of Columbia"},{"$f":"Lists!B10","v":"Armenia"}]
[{"$nulls":9},{"$f":"Lists!C11","v":"Delaware"},{"$f":"Lists!B11","v":"Australia"}]
[{"$nulls":9},{"$f":"Lists!C12","v":"Florida"},{"$f":"Lists!B12","v":"Austria"}]
[{"$nulls":9},{"$f":"Lists!C13","v":"Georgia"},{"$f":"Lists!B13","v":"Azerbaijan"}]
[{"$nulls":9},{"$f":"Lists!C14","v":"Hawaii"},{"$f":"Lists!B14","v":"Bahamas"}]
[{"$nulls":9},{"$f":"Lists!C15","v":"Iowa"},{"$f":"Lists!B15","v":"Bahrain"}]
[{"$nulls":9},{"$f":"Lists!C16","v":"Idaho"},{"$f":"Lists!B16","v":"Bangladesh"}]
[{"$nulls":9},{"$f":"Lists!C17","v":"Illinois"},{"$f":"Lists!B17","v":"Barbados"}]
[{"$nulls":9},{"$f":"Lists!C18","v":"Indiana"},{"$f":"Lists!B18","v":"Belarus"}]
[{"$nulls":9},{"$f":"Lists!C19","v":"Kansas"},{"$f":"Lists!B19","v":"Belgium"}]
[{"$nulls":9},{"$f":"Lists!C20","v":"Kentucky"},{"$f":"Lists!B20","v":"Belize"}]
[{"$nulls":9},{"$f":"Lists!C21","v":"Louisiana"},{"$f":"Lists!B21","v":"Benin"}]
[{"$nulls":9},{"$f":"Lists!C22","v":"Massachusetts"},{"$f":"Lists!B22","v":"Bermuda"}]
[{"$nulls":9},{"$f":"Lists!C23","v":"Maryland"},{"$f":"Lists!B23","v":"Bhutan"}]
[{"$nulls":9},{"$f":"Lists!C24","v":"Maine"},{"$f":"Lists!B24","v":"Bolivia (Plurinational State of)"}]
[{"$nulls":9},{"$f":"Lists!C25","v":"Michigan"},{"$f":"Lists!B25","v":"Bosnia and Herzegovina"}]
[{"$nulls":9},{"$f":"Lists!C26","v":"Minnesota"},{"$f":"Lists!B26","v":"Botswana"}]
[{"$nulls":9},{"$f":"Lists!C27","v":"Missouri"},{"$f":"Lists!B27","v":"Brazil"}]
[{"$nulls":9},{"$f":"Lists!C28","v":"Mississippi"},{"$f":"Lists!B28","v":"Brunei Darussalam"}]
[{"$nulls":9},{"$f":"Lists!C29","v":"Montana"},{"$f":"Lists!B29","v":"British Virgin Islands"}]
[{"$nulls":9},{"$f":"Lists!C30","v":"North Carolina"},{"$f":"Lists!B30","v":"Bulgaria"}]
[{"$nulls":9},{"$f":"Lists!C31","v":"North Dakota"},{"$f":"Lists!B31","v":"Burkina Faso"}]
[{"$nulls":9},{"$f":"Lists!C32","v":"Nebraska"},{"$f":"Lists!B32","v":"Burundi"}]
[{"$nulls":9},{"$f":"Lists!C33","v":"New Hampshire"},{"$f":"Lists!B33","v":"Cambodia"}]
[{"$nulls":9},{"$f":"Lists!C34","v":"New Jersey"},{"$f":"Lists!B34","v":"Cameroon"}]
[{"$nulls":9},{"$f":"Lists!C35","v":"New Mexico"},{"$f":"Lists!B35","v":"Canada"}]
[{"$nulls":9},{"$f":"Lists!C36","v":"Nevada"},{"$f":"Lists!B36","v":"Cape Verde"}]
[{"$nulls":9},{"$f":"Lists!C37","v":"New York"},{"$f":"Lists!B37","v":"Central African Republic"}]
[{"$nulls":9},{"$f":"Lists!C38","v":"Ohio"},{"$f":"Lists!B38","v":"Chad"}]
[{"$nulls":9},{"$f":"Lists!C39","v":"Oklahoma"},{"$f":"Lists!B39","v":"Chile"}]
[{"$nulls":9},{"$f":"Lists!C40","v":"Oregon"},{"$f":"Lists!B40","v":"China"}]
[{"$nulls":9},{"$f":"Lists!C41","v":"Pennsylvania"},{"$f":"Lists!B41","v":"Colombia"}]
[{"$nulls":9},{"$f":"Lists!C42","v":"Puerto Rico"},{"$f":"Lists!B42","v":"Comoros"}]
[{"$nulls":9},{"$f":"Lists!C43","v":"Rhode Island"},{"$f":"Lists!B43","v":"Congo"}]
[{"$nulls":9},{"$f":"Lists!C44","v":"South Carolina"},{"$f":"Lists!B44","v":"Cook Islands"}]
[{"$nulls":9},{"$f":"Lists!C45","v":"South Dakota"},{"$f":"Lists!B45","v":"Costa Rica"}]
[{"$nulls":9},{"$f":"Lists!C46","v":"Tennessee"},{"$f":"Lists!B46","v":"Côte d'Ivoire"}]
[{"$nulls":9},{"$f":"Lists!C47","v":"Texas"},{"$f":"Lists!B47","v":"Croatia"}]
[{"$nulls":9},{"$f":"Lists!C48","v":"Utah"},{"$f":"Lists!B48","v":"Cuba"}]
[{"$nulls":9},{"$f":"Lists!C49","v":"Virginia"},{"$f":"Lists!B49","v":"Cyprus"}]
[{"$nulls":9},{"$f":"Lists!C50","v":"US Virgin Islands"},{"$f":"Lists!B50","v":"Czech Republic"}]
[{"$nulls":9},{"$f":"Lists!C51","v":"Vermont"},{"$f":"Lists!B51","v":"Democratic Republic of the Congo"}]
[{"$nulls":9},{"$f":"Lists!C52","v":"Washington"},{"$f":"Lists!B52","v":"Denmark"}]
[{"$nulls":9},{"$f":"Lists!C53","v":"Wisconsin"},{"$f":"Lists!B53","v":"Djibouti"}]
[{"$nulls":9},{"$f":"Lists!C54","v":"West Virginia"},{"$f":"Lists!B54","v":"Dominica"}]
[{"$nulls":9},{"$f":"Lists!C55","v":"Wyoming"},{"$f":"Lists!B55","v":"Dominican Republic"}]
[{"$nulls":10},{"$f":"Lists!B56","v":"Ecuador"}]
[{"$nulls":10},{"$f":"Lists!B57","v":"Egypt"}]
[{"$nulls":10},{"$f":"Lists!B58","v":"El Salvador"}]
[{"$nulls":10},{"$f":"Lists!B59","v":"Equatorial Guinea"}]
[{"$nulls":10},{"$f":"Lists!B60","v":"Eritrea"}]
[{"$nulls":10},{"$f":"Lists!B61","v":"Estonia"}]
[{"$nulls":10},{"$f":"Lists!B62","v":"Ethiopia"}]
[{"$nulls":10},{"$f":"Lists!B63","v":"European Union"}]
[{"$nulls":10},{"$f":"Lists!B64","v":"Fiji"}]
[{"$nulls":10},{"$f":"Lists!B65","v":"Finland"}]
[{"$nulls":10},{"$f":"Lists!B66","v":"France"}]
[{"$nulls":10},{"$f":"Lists!B67","v":"Gabon"}]
[{"$nulls":10},{"$f":"Lists!B68","v":"Gambia"}]
[{"$nulls":10},{"$f":"Lists!B69","v":"Georgia"}]
[{"$nulls":10},{"$f":"Lists!B70","v":"Germany"}]
[{"$nulls":10},{"$f":"Lists!B71","v":"Ghana"}]
[{"$nulls":10},{"$f":"Lists!B72","v":"Greece"}]
[{"$nulls":10},{"$f":"Lists!B73","v":"Grenada"}]
[{"$nulls":10},{"$f":"Lists!B74","v":"Guatemala"}]
[{"$nulls":10},{"$f":"Lists!B75","v":"Guinea"}]
[{"$nulls":10},{"$f":"Lists!B76","v":"Guinea-Bissau"}]
[{"$nulls":10},{"$f":"Lists!B77","v":"Guyana"}]
[{"$nulls":10},{"$f":"Lists!B78","v":"Haiti"}]
[{"$nulls":10},{"$f":"Lists!B79","v":"Holy See"}]
[{"$nulls":10},{"$f":"Lists!B80","v":"Honduras"}]
[{"$nulls":10},{"$f":"Lists!B81","v":"Hong Kong"}]
[{"$nulls":10},{"$f":"Lists!B82","v":"Hungary"}]
[{"$nulls":10},{"$f":"Lists!B83","v":"Iceland"}]
[{"$nulls":10},{"$f":"Lists!B84","v":"India"}]
[{"$nulls":10},{"$f":"Lists!B85","v":"Indonesia"}]
[{"$nulls":10},{"$f":"Lists!B86","v":"Iran (Islamic Republic of)"}]
[{"$nulls":10},{"$f":"Lists!B87","v":"Iraq"}]
[{"$nulls":10},{"$f":"Lists!B88","v":"Ireland"}]
[{"$nulls":10},{"$f":"Lists!B89","v":"Israel"}]
[{"$nulls":10},{"$f":"Lists!B90","v":"Italy"}]
[{"$nulls":10},{"$f":"Lists!B91","v":"Jamaica"}]
[{"$nulls":10},{"$f":"Lists!B92","v":"Japan"}]
[{"$nulls":10},{"$f":"Lists!B93","v":"Jordan"}]
[{"$nulls":10},{"$f":"Lists!B94","v":"Kazakhstan"}]
[{"$nulls":10},{"$f":"Lists!B95","v":"Kenya"}]
[{"$nulls":10},{"$f":"Lists!B96","v":"Kiribati"}]
[{"$nulls":10},{"$f":"Lists!B97","v":"Kuwait"}]
[{"$nulls":10},{"$f":"Lists!B98","v":"Kyrgyzstan"}]
[{"$nulls":10},{"$f":"Lists!B99","v":"Lao People's Democratic Republic"}]
[{"$nulls":10},{"$f":"Lists!B100","v":"Latvia"}]
[{"$nulls":10},{"$f":"Lists!B101","v":"Lebanon"}]
[{"$nulls":10},{"$f":"Lists!B102","v":"Lesotho"}]
[{"$nulls":10},{"$f":"Lists!B103","v":"Liberia"}]
[{"$nulls":10},{"$f":"Lists!B104","v":"Libya"}]
[{"$nulls":10},{"$f":"Lists!B105","v":"Liechtenstein"}]
[{"$nulls":10},{"$f":"Lists!B106","v":"Lithuania"}]
[{"$nulls":10},{"$f":"Lists!B107","v":"Luxembourg"}]
[{"$nulls":10},{"$f":"Lists!B108","v":"Madagascar"}]
[{"$nulls":10},{"$f":"Lists!B109","v":"Malawi"}]
[{"$nulls":10},{"$f":"Lists!B110","v":"Malaysia"}]
[{"$nulls":10},{"$f":"Lists!B111","v":"Maldives"}]
[{"$nulls":10},{"$f":"Lists!B112","v":"Mali"}]
[{"$nulls":10},{"$f":"Lists!B113","v":"Malta"}]
[{"$nulls":10},{"$f":"Lists!B114","v":"Marshall Islands"}]
[{"$nulls":10},{"$f":"Lists!B115","v":"Mauritania"}]
[{"$nulls":10},{"$f":"Lists!B116","v":"Mauritius"}]
[{"$nulls":10},{"$f":"Lists!B117","v":"Mexico"}]
[{"$nulls":10},{"$f":"Lists!B118","v":"Micronesia (Federated States of)"}]
[{"$nulls":10},{"$f":"Lists!B119","v":"Monaco"}]
[{"$nulls":10},{"$f":"Lists!B120","v":"Mongolia"}]
[{"$nulls":10},{"$f":"Lists!B121","v":"Montenegro"}]
[{"$nulls":10},{"$f":"Lists!B122","v":"Morocco"}]
[{"$nulls":10},{"$f":"Lists!B123","v":"Mozambique"}]
[{"$nulls":10},{"$f":"Lists!B124","v":"Myanmar"}]
[{"$nulls":10},{"$f":"Lists!B125","v":"Namibia"}]
[{"$nulls":10},{"$f":"Lists!B126","v":"Nauru"}]
[{"$nulls":10},{"$f":"Lists!B127","v":"Nepal"}]
[{"$nulls":10},{"$f":"Lists!B128","v":"Netherlands"}]
[{"$nulls":10},{"$f":"Lists!B129","v":"New Zealand"}]
[{"$nulls":10},{"$f":"Lists!B130","v":"Nicaragua"}]
[{"$nulls":10},{"$f":"Lists!B131","v":"Niger"}]
[{"$nulls":10},{"$f":"Lists!B132","v":"Nigeria"}]
[{"$nulls":10},{"$f":"Lists!B133","v":"Niue"}]
[{"$nulls":10},{"$f":"Lists!B134","v":"North Korea (Democratic People's Republic of Korea)"}]
[{"$nulls":10},{"$f":"Lists!B135","v":"Norway"}]
[{"$nulls":10},{"$f":"Lists!B136","v":"Oman"}]
[{"$nulls":10},{"$f":"Lists!B137","v":"Pakistan"}]
[{"$nulls":10},{"$f":"Lists!B138","v":"Palau"}]
[{"$nulls":10},{"$f":"Lists!B139","v":"Panama"}]
[{"$nulls":10},{"$f":"Lists!B140","v":"Papua New Guinea"}]
[{"$nulls":10},{"$f":"Lists!B141","v":"Paraguay"}]
[{"$nulls":10},{"$f":"Lists!B142","v":"Peru"}]
[{"$nulls":10},{"$f":"Lists!B143","v":"Philippines"}]
[{"$nulls":10},{"$f":"Lists!B144","v":"Poland"}]
[{"$nulls":10},{"$f":"Lists!B145","v":"Portugal"}]
[{"$nulls":10},{"$f":"Lists!B146","v":"Qatar"}]
[{"$nulls":10},{"$f":"Lists!B147","v":"Republic of Moldova"}]
[{"$nulls":10},{"$f":"Lists!B148","v":"Romania"}]
[{"$nulls":10},{"$f":"Lists!B149","v":"Russian Federation"}]
[{"$nulls":10},{"$f":"Lists!B150","v":"Rwanda"}]
[{"$nulls":10},{"$f":"Lists!B151","v":"Saint Kitts and Nevis"}]
[{"$nulls":10},{"$f":"Lists!B152","v":"Saint Lucia"}]
[{"$nulls":10},{"$f":"Lists!B153","v":"Saint Vincent and the Grenadines"}]
[{"$nulls":10},{"$f":"Lists!B154","v":"Samoa"}]
[{"$nulls":10},{"$f":"Lists!B155","v":"San Marino"}]
[{"$nulls":10},{"$f":"Lists!B156","v":"Sao Tome and Principe"}]
[{"$nulls":10},{"$f":"Lists!B157","v":"Saudi Arabia"}]
[{"$nulls":10},{"$f":"Lists!B158","v":"Senegal"}]
[{"$nulls":10},{"$f":"Lists!B159","v":"Serbia"}]
[{"$nulls":10},{"$f":"Lists!B160","v":"Seychelles"}]
[{"$nulls":10},{"$f":"Lists!B161","v":"Sierra Leone"}]
[{"$nulls":10},{"$f":"Lists!B162","v":"Singapore"}]
[{"$nulls":10},{"$f":"Lists!B163","v":"Slovakia"}]
[{"$nulls":10},{"$f":"Lists!B164","v":"Slovenia"}]
[{"$nulls":10},{"$f":"Lists!B165","v":"Solomon Islands"}]
[{"$nulls":10},{"$f":"Lists!B166","v":"Somalia (Federal Republic of)"}]
[{"$nulls":10},{"$f":"Lists!B167","v":"South Africa"}]
[{"$nulls":10},{"$f":"Lists!B168","v":"South Korea (Republic of Korea)"}]
[{"$nulls":10},{"$f":"Lists!B169","v":"South Sudan"}]
[{"$nulls":10},{"$f":"Lists!B170","v":"Spain"}]
[{"$nulls":10},{"$f":"Lists!B171","v":"Sri Lanka"}]
[{"$nulls":10},{"$f":"Lists!B172","v":"Sudan"}]
[{"$nulls":10},{"$f":"Lists!B173","v":"Suriname"}]
[{"$nulls":10},{"$f":"Lists!B174","v":"Swaziland"}]
[{"$nulls":10},{"$f":"Lists!B175","v":"Sweden"}]
[{"$nulls":10},{"$f":"Lists!B176","v":"Switzerland"}]
[{"$nulls":10},{"$f":"Lists!B177","v":"Syrian Arab Republic"}]
[{"$nulls":10},{"$f":"Lists!B178","v":"Tahiti"}]
[{"$nulls":10},{"$f":"Lists!B179","v":"Taiwan"}]
[{"$nulls":10},{"$f":"Lists!B180","v":"Tajikistan"}]
[{"$nulls":10},{"$f":"Lists!B181","v":"Thailand"}]
[{"$nulls":10},{"$f":"Lists!B182","v":"The Former Yugoslav Republic of Macedonia"}]
[{"$nulls":10},{"$f":"Lists!B183","v":"Timor-Leste"}]
[{"$nulls":10},{"$f":"Lists!B184","v":"Togo"}]
[{"$nulls":10},{"$f":"Lists!B185","v":"Tonga"}]
[{"$nulls":10},{"$f":"Lists!B186","v":"Trinidad and Tobago"}]
[{"$nulls":10},{"$f":"Lists!B187","v":"Tunisia"}]
[{"$nulls":10},{"$f":"Lists!B188","v":"Turkey"}]
[{"$nulls":10},{"$f":"Lists!B189","v":"Turkmenistan"}]
[{"$nulls":10},{"$f":"Lists!B190","v":"Tuvalu"}]
[{"$nulls":10},{"$f":"Lists!B191","v":"Uganda"}]
[{"$nulls":10},{"$f":"Lists!B192","v":"Ukraine"}]
[{"$nulls":10},{"$f":"Lists!B193","v":"United Arab Emirates"}]
[{"$nulls":10},{"$f":"Lists!B194","v":"United Kingdom of Great Britain and Northern Ireland"}]
[{"$nulls":10},{"$f":"Lists!B195","v":"United Republic of Tanzania"}]
[{"$nulls":10},{"$f":"Lists!B196","v":"United States of America"}]
[{"$nulls":10},{"$f":"Lists!B197","v":"Uruguay"}]
[{"$nulls":10},{"$f":"Lists!B198","v":"Uzbekistan"}]
[{"$nulls":10},{"$f":"Lists!B199","v":"Vanuatu"}]
[{"$nulls":10},{"$f":"Lists!B200","v":"Venezuela (Bolivarian Republic of)"}]
[{"$nulls":10},{"$f":"Lists!B201","v":"Viet Nam"}]
[{"$nulls":10},{"$f":"Lists!B202","v":"Yemen"}]
[{"$nulls":10},{"$f":"Lists!B203","v":"Zambia"}]
[{"$nulls":10},{"$f":"Lists!B204","v":"Zimbabwe"}]

{"sheet":"Summary","index":3,"n_rows":18,"n_cols":7,"rows_kept":18,"merged":[[2,3,2,6],[8,3,8,6],[9,3,10,3],[9,4,9,6]]}
[]
[{"$nulls":3},"U.S. Environmental Protection Agency"]
[{"$nulls":3},"Class II Trades Report "]
[]
[{"$nulls":3},"Company Name:",{"$f":"IF('Section 1'!D9=0,\"\",'Section 1'!D9)","v":""}]
[{"$nulls":3},"Reporting Period:",{"$f":"IF('Section 1'!D11=0,\"\",'Section 1'!D11)","v":""}]
[]
[{"$nulls":3},"Allowance Summary"]
[{"$nulls":3},"The values in the table below are calculated based on data entered in Section 2.  If the totals appear to be incorrect, please return to Section 2 to review your data."]
[{"$nulls":3},"Chemical Name","Allowances Expended by Transferor (kg)"]
[{"$nulls":4},"Production","Consumption","Article 5"]
[1,null,null,{"$f":"IFERROR(VLOOKUP(A12, 'Section 2'!A22:H31, 8, FALSE), \"\")","v":""},{"$f":"IF(D12=\"\", \"\", SUMIFS('Section 2'!$N$22:$N$31, 'Section 2'!$H$22:$H$31, Summary!$D12, 'Section 2'!$E$22:$E$31, Lists!$G$3))","v":""},{"$f":"IF(D12=\"\", \"\", SUMIFS('Section 2'!$N$22:$N$31, 'Section 2'!$H$22:$H$31, Summary!$D12, 'Section 2'!$E$22:$E$31, Lists!$G$4))","v":""},{"$f":"IF(D12=\"\",\"\", SUMIFS('Section 2'!$N$22:$N$31, 'Section 2'!$H$22:$H$31, Summary!$D12, 'Section 2'!$E$22:$E$31, Lists!$G$5))","v":""}]
[2,null,null,{"$f":"IFERROR(VLOOKUP(A13, 'Section 2'!A23:H32, 8, FALSE), \"\")","v":""},{"$f":"IF(D13=\"\", \"\", SUMIFS('Section 2'!$N$22:$N$31, 'Section 2'!$H$22:$H$31, Summary!$D13, 'Section 2'!$E$22:$E$31, Lists!$G$3))","v":""},{"$f":"IF(D13=\"\", \"\", SUMIFS('Section 2'!$N$22:$N$31, 'Section 2'!$H$22:$H$31, Summary!$D13, 'Section 2'!$E$22:$E$31, Lists!$G$4))","v":""},{"$f":"IF(D13=\"\",\"\", SUMIFS('Section 2'!$N$22:$N$31, 'Section 2'!$H$22:$H$31, Summary!$D13, 'Section 2'!$E$22:$E$31, Lists!$G$5))","v":""}]
[3,null,null,{"$f":"IFERROR(VLOOKUP(A14, 'Section 2'!A24:H33, 8, FALSE), \"\")","v":""},{"$f":"IF(D14=\"\", \"\", SUMIFS('Section 2'!$N$22:$N$31, 'Section 2'!$H$22:$H$31, Summary!$D14, 'Section 2'!$E$22:$E$31, Lists!$G$3))","v":""},{"$f":"IF(D14=\"\", \"\", SUMIFS('Section 2'!$N$22:$N$31, 'Section 2'!$H$22:$H$31, Summary!$D14, 'Section 2'!$E$22:$E$31, Lists!$G$4))","v":""},{"$f":"IF(D14=\"\",\"\", SUMIFS('Section 2'!$N$22:$N$31, 'Section 2'!$H$22:$H$31, Summary!$D14, 'Section 2'!$E$22:$E$31, Lists!$G$5))","v":""}]
[4,null,null,{"$f":"IFERROR(VLOOKUP(A15, 'Section 2'!A25:H34, 8, FALSE), \"\")","v":""},{"$f":"IF(D15=\"\", \"\", SUMIFS('Section 2'!$N$22:$N$31, 'Section 2'!$H$22:$H$31, Summary!$D15, 'Section 2'!$E$22:$E$31, Lists!$G$3))","v":""},{"$f":"IF(D15=\"\", \"\", SUMIFS('Section 2'!$N$22:$N$31, 'Section 2'!$H$22:$H$31, Summary!$D15, 'Section 2'!$E$22:$E$31, Lists!$G$4))","v":""},{"$f":"IF(D15=\"\",\"\", SUMIFS('Section 2'!$N$22:$N$31, 'Section 2'!$H$22:$H$31, Summary!$D15, 'Section 2'!$E$22:$E$31, Lists!$G$5))","v":""}]
[5,null,null,{"$f":"IFERROR(VLOOKUP(A16, 'Section 2'!A26:H35, 8, FALSE), \"\")","v":""},{"$f":"IF(D16=\"\", \"\", SUMIFS('Section 2'!$N$22:$N$31, 'Section 2'!$H$22:$H$31, Summary!$D16, 'Section 2'!$E$22:$E$31, Lists!$G$3))","v":""},{"$f":"IF(D16=\"\", \"\", SUMIFS('Section 2'!$N$22:$N$31, 'Section 2'!$H$22:$H$31, Summary!$D16, 'Section 2'!$E$22:$E$31, Lists!$G$4))","v":""},{"$f":"IF(D16=\"\",\"\", SUMIFS('Section 2'!$N$22:$N$31, 'Section 2'!$H$22:$H$31, Summary!$D16, 'Section 2'!$E$22:$E$31, Lists!$G$5))","v":""}]
[6,null,null,{"$f":"IFERROR(VLOOKUP(A17, 'Section 2'!A27:H36, 8, FALSE), \"\")","v":""},{"$f":"IF(D17=\"\", \"\", SUMIFS('Section 2'!$N$22:$N$31, 'Section 2'!$H$22:$H$31, Summary!$D17, 'Section 2'!$E$22:$E$31, Lists!$G$3))","v":""},{"$f":"IF(D17=\"\", \"\", SUMIFS('Section 2'!$N$22:$N$31, 'Section 2'!$H$22:$H$31, Summary!$D17, 'Section 2'!$E$22:$E$31, Lists!$G$4))","v":""},{"$f":"IF(D17=\"\",\"\", SUMIFS('Section 2'!$N$22:$N$31, 'Section 2'!$H$22:$H$31, Summary!$D17, 'Section 2'!$E$22:$E$31, Lists!$G$5))","v":""}]
[7,null,null,{"$f":"IFERROR(VLOOKUP(A18, 'Section 2'!A28:H37, 8, FALSE), \"\")","v":""},{"$f":"IF(D18=\"\", \"\", SUMIFS('Section 2'!$N$22:$N$31, 'Section 2'!$H$22:$H$31, Summary!$D18, 'Section 2'!$E$22:$E$31, Lists!$G$3))","v":""},{"$f":"IF(D18=\"\", \"\", SUMIFS('Section 2'!$N$22:$N$31, 'Section 2'!$H$22:$H$31, Summary!$D18, 'Section 2'!$E$22:$E$31, Lists!$G$4))","v":""},{"$f":"IF(D18=\"\",\"\", SUMIFS('Section 2'!$N$22:$N$31, 'Section 2'!$H$22:$H$31, Summary!$D18, 'Section 2'!$E$22:$E$31, Lists!$G$5))","v":""}]

{"sheet":"Reference List","index":4,"n_rows":78,"n_cols":9,"rows_kept":78,"merged":[[5,2,5,8],[6,2,6,4],[6,6,6,8],[8,2,8,4],[8,6,8,8],[13,2,14,4],[16,2,16,4],[51,8,52,8],[64,8,65,8],[71,7,72,7]]}
[]
[null,null,"U.S. Environmental Protection Agency"]
[null,null,"Class II Trades Report "]
[null,null,"Reference List"]
[]
[null,null,"Copying and Pasting Data: If data is pasted into this reporting form from another spreadsheet, the formatting of specific cells must be consistent with the requirements of the form in order to be accepted into EPA’s ODS tracking system. When copying and pasting data into the form, please ensure consistency with the formatting of the lists provided below."]
[null,null,"Chemical Name List: The table below lists the valid chemical names that may be used when entering data into Section 2 of this form. ",{"$nulls":3},"Country List: The table below lists the valid country names that may be used when entering data into Section 2 of this form. "]
[]
[null,null,"Class II Chemicals with Allowances",{"$nulls":3},"Source Country "]
[null,null,"HCFC-22 ","HCFC-123 ","HCFC-124",null,"Afghanistan","Greece","Papua New Guinea"]
[null,null,"HCFC-141b ","HCFC-142b ","HCFC-225ca",null,"Albania","Grenada","Paraguay"]
[null,null,"HCFC-225cb ",{"$nulls":3},"Algeria","Guatemala","Peru"]
[{"$nulls":6},"Andorra","Guinea","Philippines"]
[null,null,"State List: The table below lists the valid state names that may be used when entering data into Section 2 of this form. ",{"$nulls":3},"Angola","Guinea-Bissau","Poland"]
[{"$nulls":6},"Antigua and Barbuda","Guyana","Portugal"]
[{"$nulls":6},"Argentina","Haiti","Qatar"]
[null,null,"States",{"$nulls":3},"Armenia","Holy See","Republic of Moldova"]
[null,null,"Alaska","Louisiana","Oklahoma",null,"Australia","Honduras","Romania"]
[null,null,"Alabama","Massachusetts","Oregon",null,"Austria","Hong Kong","Russian Federation"]
[null,null,"Arkansas","Maryland","Pennsylvania",null,"Azerbaijan","Hungary","Rwanda"]
[null,null,"Arizona","Maine","Puerto Rico",null,"Bahamas","Iceland","Saint Kitts and Nevis"]
[null,null,"California","Michigan","Rhode Island",null,"Bahrain","India","Saint Lucia"]
[null,null,"Colorado","Minnesota","South Carolina",null,"Bangladesh","Indonesia","Saint Vincent and the Grenadines"]
[null,null,"Connecticut","Missouri","South Dakota",null,"Barbados","Iran (Islamic Republic of)","Samoa"]
[null,null,"District of Columbia","Mississippi","Tennessee",null,"Belarus","Iraq","San Marino"]
[null,null,"Delaware","Montana","Texas",null,"Belgium","Ireland","Sao Tome and Principe"]
[null,null,"Florida","North Carolina","Utah",null,"Belize","Israel","Saudi Arabia"]
[null,null,"Georgia","North Dakota","Virginia",null,"Benin","Italy","Senegal"]
[null,null,"Hawaii","Nebraska","US Virgin Islands",null,"Bermuda","Jamaica","Serbia"]
[null,null,"Iowa","New Hampshire","Vermont",null,"Bhutan","Japan","Seychelles"]
[null,null,"Idaho","New Jersey","Washington",null,"Bolivia (Plurinational State of)","Jordan","Sierra Leone"]
[null,null,"Illinois","New Mexico","Wisconsin",null,"Bosnia and Herzegovina","Kazakhstan","Singapore"]
[null,null,"Indiana","Nevada","West Virginia",null,"Botswana","Kenya","Slovakia"]
[null,null,"Kansas","New York","Wyoming",null,"Brazil","Kiribati","Slovenia"]
[null,null,"Kentucky","Ohio",null,null,"Brunei Darussalam","Kuwait","Solomon Islands"]
[{"$nulls":6},"British Virgin Islands","Kyrgyzstan","Somalia (Federal Republic of)"]
[{"$nulls":6},"Bulgaria","Lao People's Democratic Republic","South Africa"]
[{"$nulls":6},"Burkina Faso","Latvia","South Korea (Republic of Korea)"]
[{"$nulls":6},"Burundi","Lebanon","South Sudan"]
[{"$nulls":6},"Cambodia","Lesotho","Spain"]
[{"$nulls":6},"Cameroon","Liberia","Sri Lanka"]
[{"$nulls":6},"Canada","Libya","Sudan"]
[{"$nulls":6},"Cape Verde","Liechtenstein","Suriname"]
[{"$nulls":6},"Central African Republic","Lithuania","Swaziland"]
[{"$nulls":6},"Chad","Luxembourg","Sweden"]
[{"$nulls":6},"Chile","Madagascar","Switzerland"]
[{"$nulls":6},"China","Malawi","Syrian Arab Republic"]
[{"$nulls":6},"Colombia","Malaysia","Tahiti"]
[{"$nulls":6},"Comoros","Maldives","Taiwan"]
[{"$nulls":6},"Congo","Mali","Tajikistan"]
[{"$nulls":6},"Cook Islands","Malta","Thailand"]
[{"$nulls":6},"Costa Rica","Marshall Islands","The Former Yugoslav Republic of Macedonia"]
[{"$nulls":6},"Côte d'Ivoire","Mauritania"]
[{"$nulls":6},"Croatia","Mauritius","Timor-Leste"]
[{"$nulls":6},"Cuba","Mexico","Togo"]
[{"$nulls":6},"Cyprus","Micronesia (Federated States of)","Tonga"]
[{"$nulls":6},"Czech Republic","Monaco","Trinidad and Tobago"]
[{"$nulls":6},"Democratic Republic of the Congo","Mongolia","Tunisia"]
[{"$nulls":6},"Denmark","Montenegro","Turkey"]
[{"$nulls":6},"Djibouti","Morocco","Turkmenistan"]
[{"$nulls":6},"Dominica","Mozambique","Tuvalu"]
[{"$nulls":6},"Dominican Republic","Myanmar","Uganda"]
[{"$nulls":6},"Ecuador","Namibia","Ukraine"]
[{"$nulls":6},"Egypt","Nauru","United Arab Emirates"]
[{"$nulls":6},"El Salvador","Nepal","United Kingdom of Great Britain and Northern Ireland"]
[{"$nulls":6},"Equatorial Guinea","Netherlands"]
[{"$nulls":6},"Eritrea","New Zealand","United Republic of Tanzania"]
[{"$nulls":6},"Estonia","Nicaragua","United States of America"]
[{"$nulls":6},"Ethiopia","Niger","Uruguay"]
[{"$nulls":6},"European Union","Nigeria","Uzbekistan"]
[{"$nulls":6},"Fiji","Niue","Vanuatu"]
[{"$nulls":6},"Finland","North Korea (Democratic People's Republic of Korea)","Venezuela (Bolivarian Republic of)"]
[{"$nulls":6},"France",null,"Viet Nam"]
[{"$nulls":6},"Gabon","Norway","Yemen"]
[{"$nulls":6},"Gambia","Oman","Zambia"]
[{"$nulls":6},"Georgia","Pakistan","Zimbabwe"]
[{"$nulls":6},"Germany","Palau"]
[{"$nulls":6},"Ghana","Panama"]

{"sheet":"Checks","index":5,"n_rows":16,"n_cols":5,"rows_kept":16,"hidden":true}
[]
[null,"Section","Check Description","Status (1 = Incomplete, 0 = Complete)","Check Type"]
[null,"Section 1","All",{"$f":"IF(SUM('Section 1'!F9:F11)>0,1,0)","v":1},"Error"]
[null,"Section 2","Complete?",{"$f":"IF(SUM('Section 2'!$U$22:$U$31,'Section 2'!$T$14:$V$14)>0,1,0)","v":0},"Stopper"]
[null,"Section 2","Valid State if USA",{"$f":"IF('Section 2'!$U$14>0,1,0)","v":0},"Stopper"]
[null,"Section 2","Valid Country",{"$f":"IF('Section 2'!$V$14>0,1,0)","v":0},"Stopper"]
[null,"Section 2","Valid Chemical",{"$f":"IF(SUM('Section 2'!V22:W31)>0, 1, 0)","v":0},"Stopper"]
[null,"Section 2","Inter-pollutant check (Baseline)",{"$f":"IF(SUM('Section 2'!$X$22:$X$31)>0,1,0)","v":0},"Stopper"]
[null,"Section 2","Error Check",{"$f":"IF(SUM(D4:D8)>0,1,0)","v":0},"Error"]
[null,"All","Error Check",{"$f":"IF(SUM(Sec1Status,Sec2Error)>0,1,0)","v":1},"Error"]
[]
[]
[]
[null,"Numerical Checks against Output for CSV"]
[null,"Section 2","Total Quantity of Class II Chemical Allowances Traded",{"$f":"SUMIF('Section 2'!$T$22:$T$31,\"Y\",'Section 2'!J22:J31)-SUM(OutputForCSV!J3:J11)","v":{"v":0,"d":"0.00"}}]
[null,"ALL","TOTAL CHECK",{"$f":"SUM(D15:D15)","v":{"v":0,"d":"0.00"}}]

{"sheet":"Lists","index":6,"n_rows":204,"n_cols":16,"rows_kept":204,"hidden":true,"merged":[[0,10,0,11],[0,14,0,15]]}
[{"$nulls":10},"ODP Table",{"$nulls":3},"FOR REFERENCE ONLY"]
[null,"Country List","States","Submission Type","Reporting Year","Year Range","Class II Allownace Types","Allowance Type: Current or Baseline","Allowance Type: Domestic or International","Class II Chemicals w/ Allowances","Class II Chemicals","ODP","Date for CSV Title","Form Name for CSV Title","Form Type","Form Code"]
[null,"Afghanistan","Alaska","Original Submission",2018,{"$f":"IF(ReportYr=Lists!$E$3,DATE(Lists!$E$3,1,1),IF(ReportYr=Lists!$E$4,DATE(Lists!$E$4,1,1),IF(ReportYr=Lists!$E$5,DATE(Lists!$E$5,1,1),0)))","v":"00:00:00"},"Production","Current","Domestic","HCFC-22","HCFC-22",0.055,{"$f":"MONTH('Section 1'!D5)&\"-\"&DAY('Section 1'!D5)&\"-\"&YEAR('Section 1'!D5)","v":"5-22-2018"},"Class II Trades","Class I Producer","PROD1"]
[null,"Albania","Alabama","Re-Submittal",2019,{"$f":"IF(ReportYr=Lists!$E$3,DATE(Lists!$E$3,12,31),IF(ReportYr=Lists!$E$4,DATE(Lists!$E$4,12,31),IF(ReportYr=Lists!$E$5,DATE(Lists!$E$5,12,31),0)))","v":"00:00:00"},"Consumption","Baseline",null,"HCFC-123","HCFC-123",0.02,null,null,"MeBr Producer","PROD3"]
[null,"Algeria","Arkansas",null,2020,null,"Article 5",null,null,"HCFC-124","HCFC-124",0.022,null,null,"Class II Producer","PROD2"]
[null,"Andorra","Arizona",{"$nulls":6},"HCFC-141b","HCFC-141b",0.11,null,null,"Class I Importer","IMPT1"]
[null,"Angola","California",{"$nulls":6},"HCFC-142b","HCFC-142b",0.065,null,null,"MeBr Importer","IMPT3"]
[null,"Antigua and Barbuda","Colorado",{"$nulls":6},"HCFC-225ca","HCFC-225ca",0.025,null,null,"Class II Importer","IMPT2"]
[null,"Argentina","Connecticut",{"$nulls":6},"HCFC-225cb","HCFC-225cb",0.033,null,null,"Class I Exporter","EXPT1"]
[null,"Armenia","District of Columbia",{"$nulls":11},"MeBr Exporter","EXPT3"]
[null,"Australia","Delaware",{"$nulls":11},"Class II Exporter","EXPT2"]
[null,"Austria","Florida",{"$nulls":11},"Class I Lab Supplier","LABS1"]
[null,"Azerbaijan","Georgia",{"$nulls":11},"Class I Destruction","DEST1"]
[null,"Bahamas","Hawaii",{"$nulls":11},"MeBr Destruction","DEST3"]
[null,"Bahrain","Iowa",{"$nulls":11},"Class II Destruction","DEST2"]
[null,"Bangladesh","Idaho",{"$nulls":11},"Class I Transformation","TRAN1"]
[null,"Barbados","Illinois",{"$nulls":11},"MeBr Transformation","TRAN3"]
[null,"Belarus","Indiana",{"$nulls":11},"Class II Transformation","TRAN2"]
[null,"Belgium","Kansas",{"$nulls":11},"MeBr Trades","TRAD3"]
[null,"Belize","Kentucky",{"$nulls":11},"Class II Trades","TRAD2"]
[null,"Benin","Louisiana",{"$nulls":11},"Class II RACA","RACA2"]
[null,"Bermuda","Massachusetts",{"$nulls":11},"MeBr Distributor of QPS","MBQPS"]
[null,"Bhutan","Maryland",{"$nulls":11},"MeBr Pre-2005 Stocks","MB05S"]
[null,"Bolivia (Plurinational State of)","Maine",{"$nulls":11},"MeBr Sales of CU","MBCUE"]
[null,"Bosnia and Herzegovina","Michigan"]
[null,"Botswana","Minnesota"]
[null,"Brazil","Missouri"]
[null,"Brunei Darussalam","Mississippi"]
[null,"British Virgin Islands","Montana"]
[null,"Bulgaria","North Carolina"]
[null,"Burkina Faso","North Dakota"]
[null,"Burundi","Nebraska"]
[null,"Cambodia","New Hampshire"]
[null,"Cameroon","New Jersey"]
[null,"Canada","New Mexico"]
[null,"Cape Verde","Nevada"]
[null,"Central African Republic","New York"]
[null,"Chad","Ohio"]
[null,"Chile","Oklahoma"]
[null,"China","Oregon"]
[null,"Colombia","Pennsylvania"]
[null,"Comoros","Puerto Rico"]
[null,"Congo","Rhode Island"]
[null,"Cook Islands","South Carolina"]
[null,"Costa Rica","South Dakota"]
[null,"Côte d'Ivoire","Tennessee"]
[null,"Croatia","Texas"]
[null,"Cuba","Utah"]
[null,"Cyprus","Virginia"]
[null,"Czech Republic","US Virgin Islands"]
[null,"Democratic Republic of the Congo","Vermont"]
[null,"Denmark","Washington"]
[null,"Djibouti","Wisconsin"]
[null,"Dominica","West Virginia"]
[null,"Dominican Republic","Wyoming"]
[null,"Ecuador"]
[null,"Egypt"]
[null,"El Salvador"]
[null,"Equatorial Guinea"]
[null,"Eritrea"]
[null,"Estonia"]
[null,"Ethiopia"]
[null,"European Union"]
[null,"Fiji"]
[null,"Finland"]
[null,"France"]
[null,"Gabon"]
[null,"Gambia"]
[null,"Georgia"]
[null,"Germany"]
[null,"Ghana"]
[null,"Greece"]
[null,"Grenada"]
[null,"Guatemala"]
[null,"Guinea"]
[null,"Guinea-Bissau"]
[null,"Guyana"]
[null,"Haiti"]
[null,"Holy See"]
[null,"Honduras"]
[null,"Hong Kong"]
[null,"Hungary"]
[null,"Iceland"]
[null,"India"]
[null,"Indonesia"]
[null,"Iran (Islamic Republic of)"]
[null,"Iraq"]
[null,"Ireland"]
[null,"Israel"]
[null,"Italy"]
[null,"Jamaica"]
[null,"Japan"]
[null,"Jordan"]
[null,"Kazakhstan"]
[null,"Kenya"]
[null,"Kiribati"]
[null,"Kuwait"]
[null,"Kyrgyzstan"]
[null,"Lao People's Democratic Republic"]
[null,"Latvia"]
[null,"Lebanon"]
[null,"Lesotho"]
[null,"Liberia"]
[null,"Libya"]
[null,"Liechtenstein"]
[null,"Lithuania"]
[null,"Luxembourg"]
[null,"Madagascar"]
[null,"Malawi"]
[null,"Malaysia"]
[null,"Maldives"]
[null,"Mali"]
[null,"Malta"]
[null,"Marshall Islands"]
[null,"Mauritania"]
[null,"Mauritius"]
[null,"Mexico"]
[null,"Micronesia (Federated States of)"]
[null,"Monaco"]
[null,"Mongolia"]
[null,"Montenegro"]
[null,"Morocco"]
[null,"Mozambique"]
[null,"Myanmar"]
[null,"Namibia"]
[null,"Nauru"]
[null,"Nepal"]
[null,"Netherlands"]
[null,"New Zealand"]
[null,"Nicaragua"]
[null,"Niger"]
[null,"Nigeria"]
[null,"Niue"]
[null,"North Korea (Democratic People's Republic of Korea)"]
[null,"Norway"]
[null,"Oman"]
[null,"Pakistan"]
[null,"Palau"]
[null,"Panama"]
[null,"Papua New Guinea"]
[null,"Paraguay"]
[null,"Peru"]
[null,"Philippines"]
[null,"Poland"]
[null,"Portugal"]
[null,"Qatar"]
[null,"Republic of Moldova"]
[null,"Romania"]
[null,"Russian Federation"]
[null,"Rwanda"]
[null,"Saint Kitts and Nevis"]
[null,"Saint Lucia"]
[null,"Saint Vincent and the Grenadines"]
[null,"Samoa"]
[null,"San Marino"]
[null,"Sao Tome and Principe"]
[null,"Saudi Arabia"]
[null,"Senegal"]
[null,"Serbia"]
[null,"Seychelles"]
[null,"Sierra Leone"]
[null,"Singapore"]
[null,"Slovakia"]
[null,"Slovenia"]
[null,"Solomon Islands"]
[null,"Somalia (Federal Republic of)"]
[null,"South Africa"]
[null,"South Korea (Republic of Korea)"]
[null,"South Sudan"]
[null,"Spain"]
[null,"Sri Lanka"]
[null,"Sudan"]
[null,"Suriname"]
[null,"Swaziland"]
[null,"Sweden"]
[null,"Switzerland"]
[null,"Syrian Arab Republic"]
[null,"Tahiti"]
[null,"Taiwan"]
[null,"Tajikistan"]
[null,"Thailand"]
[null,"The Former Yugoslav Republic of Macedonia"]
[null,"Timor-Leste"]
[null,"Togo"]
[null,"Tonga"]
[null,"Trinidad and Tobago"]
[null,"Tunisia"]
[null,"Turkey"]
[null,"Turkmenistan"]
[null,"Tuvalu"]
[null,"Uganda"]
[null,"Ukraine"]
[null,"United Arab Emirates"]
[null,"United Kingdom of Great Britain and Northern Ireland"]
[null,"United Republic of Tanzania"]
[null,"United States of America"]
[null,"Uruguay"]
[null,"Uzbekistan"]
[null,"Vanuatu"]
[null,"Venezuela (Bolivarian Republic of)"]
[null,"Viet Nam"]
[null,"Yemen"]
[null,"Zambia"]
[null,"Zimbabwe"]

{"sheet":"OutputForCSV","index":7,"n_rows":12,"n_cols":23,"rows_kept":12,"hidden":true}
["Entry",1,"TRAD2",1,{"$f":"'Section 1'!D5","v":"2018-05-22"},{"$f":"'Section 1'!D9","v":0},{"$f":"'Section 1'!D10","v":0},{"$f":"'Section 1'!D11","v":0},"N/A",{"$nulls":13},"LastColumn"]
[1,{"$f":"IF(C2=\"\",\"\",2)","v":""},{"$f":"IFERROR(VLOOKUP($A2,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:D$19),0),\"\")","v":""},{"$f":"IF(C2=\"\",\"\",'Section 2'!$D$14)","v":""},{"$f":"IF('Section 2'!$E$14=0,\"\",'Section 2'!$E$14)","v":""},{"$f":"IF('Section 2'!$F$14=0,\"\",'Section 2'!$F$14)","v":""},{"$f":"IF('Section 2'!$G$14=0,\"\",'Section 2'!$G$14)","v":""},{"$f":"IF('Section 2'!$H$14=0,\"\",'Section 2'!$H$14)","v":""},{"$f":"IF('Section 2'!$I$14=0,\"\",'Section 2'!$I$14)","v":""},{"$f":"IF('Section 2'!$J$14=0,\"\",'Section 2'!$J$14)","v":""},{"$f":"IF('Section 2'!$K$14=0,\"\",'Section 2'!$K$14)","v":""},{"$f":"IFERROR(VLOOKUP($A2,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:E$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A2,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:F$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A2,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:G$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A2,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:H$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A2,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:I$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A2,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:J$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A2,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:K$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A2,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:L$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A2,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:M$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A2,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:N$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A2,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:O$19),0),\"\")","v":""}]
[2,{"$f":"IF(C3=\"\",\"\",2)","v":""},{"$f":"IFERROR(VLOOKUP($A3,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:D$19),0),\"\")","v":""},{"$f":"IF(C3=\"\",\"\",'Section 2'!$D$14)","v":""},{"$f":"IF(C3=\"\",\"\",IF('Section 2'!$E$14=0,\"\",'Section 2'!$E$14))","v":""},{"$f":"IF(C3=\"\",\"\",IF('Section 2'!$F$14=0,\"\",'Section 2'!$F$14))","v":""},{"$f":"IF(C3=\"\",\"\",IF('Section 2'!$G$14=0,\"\",'Section 2'!$G$14))","v":""},{"$f":"IF(C3=\"\",\"\",IF('Section 2'!$H$14=0,\"\",'Section 2'!$H$14))","v":""},{"$f":"IF(C3=\"\",\"\",IF('Section 2'!$I$14=0,\"\",'Section 2'!$I$14))","v":""},{"$f":"IF(C3=\"\",\"\",IF('Section 2'!$J$14=0,\"\",'Section 2'!$J$14))","v":""},{"$f":"IF(C3=\"\",\"\",IF('Section 2'!$K$14=0,\"\",'Section 2'!$K$14))","v":""},{"$f":"IFERROR(VLOOKUP($A3,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:E$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A3,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:F$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A3,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:G$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A3,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:H$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A3,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:I$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A3,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:J$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A3,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:K$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A3,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:L$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A3,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:M$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A3,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:N$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A3,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:O$19),0),\"\")","v":""}]
[3,"",{"$f":"IFERROR(VLOOKUP($A4,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:D$19),0),\"\")","v":""},{"$f":"IF(C4=\"\",\"\",'Section 2'!$D$14)","v":""},{"$f":"IF(C4=\"\",\"\",IF('Section 2'!$E$14=0,\"\",'Section 2'!$E$14))","v":""},{"$f":"IF(C4=\"\",\"\",IF('Section 2'!$F$14=0,\"\",'Section 2'!$F$14))","v":""},{"$f":"IF(C4=\"\",\"\",IF('Section 2'!$G$14=0,\"\",'Section 2'!$G$14))","v":""},{"$f":"IF(C4=\"\",\"\",IF('Section 2'!$H$14=0,\"\",'Section 2'!$H$14))","v":""},{"$f":"IF(C4=\"\",\"\",IF('Section 2'!$I$14=0,\"\",'Section 2'!$I$14))","v":""},{"$f":"IF(C4=\"\",\"\",IF('Section 2'!$J$14=0,\"\",'Section 2'!$J$14))","v":""},{"$f":"IF(C4=\"\",\"\",IF('Section 2'!$K$14=0,\"\",'Section 2'!$K$14))","v":""},{"$f":"IFERROR(VLOOKUP($A4,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:E$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A4,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:F$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A4,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:G$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A4,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:H$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A4,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:I$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A4,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:J$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A4,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:K$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A4,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:L$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A4,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:M$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A4,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:N$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A4,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:O$19),0),\"\")","v":""}]
[4,"",{"$f":"IFERROR(VLOOKUP($A5,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:D$19),0),\"\")","v":""},{"$f":"IF(C5=\"\",\"\",'Section 2'!$D$14)","v":""},{"$f":"IF(C5=\"\",\"\",IF('Section 2'!$E$14=0,\"\",'Section 2'!$E$14))","v":""},{"$f":"IF(C5=\"\",\"\",IF('Section 2'!$F$14=0,\"\",'Section 2'!$F$14))","v":""},{"$f":"IF(C5=\"\",\"\",IF('Section 2'!$G$14=0,\"\",'Section 2'!$G$14))","v":""},{"$f":"IF(C5=\"\",\"\",IF('Section 2'!$H$14=0,\"\",'Section 2'!$H$14))","v":""},{"$f":"IF(C5=\"\",\"\",IF('Section 2'!$I$14=0,\"\",'Section 2'!$I$14))","v":""},{"$f":"IF(C5=\"\",\"\",IF('Section 2'!$J$14=0,\"\",'Section 2'!$J$14))","v":""},{"$f":"IF(C5=\"\",\"\",IF('Section 2'!$K$14=0,\"\",'Section 2'!$K$14))","v":""},{"$f":"IFERROR(VLOOKUP($A5,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:E$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A5,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:F$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A5,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:G$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A5,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:H$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A5,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:I$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A5,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:J$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A5,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:K$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A5,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:L$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A5,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:M$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A5,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:N$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A5,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:O$19),0),\"\")","v":""}]
[5,"",{"$f":"IFERROR(VLOOKUP($A6,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:D$19),0),\"\")","v":""},{"$f":"IF(C6=\"\",\"\",'Section 2'!$D$14)","v":""},{"$f":"IF(C6=\"\",\"\",IF('Section 2'!$E$14=0,\"\",'Section 2'!$E$14))","v":""},{"$f":"IF(C6=\"\",\"\",IF('Section 2'!$F$14=0,\"\",'Section 2'!$F$14))","v":""},{"$f":"IF(C6=\"\",\"\",IF('Section 2'!$G$14=0,\"\",'Section 2'!$G$14))","v":""},{"$f":"IF(C6=\"\",\"\",IF('Section 2'!$H$14=0,\"\",'Section 2'!$H$14))","v":""},{"$f":"IF(C6=\"\",\"\",IF('Section 2'!$I$14=0,\"\",'Section 2'!$I$14))","v":""},{"$f":"IF(C6=\"\",\"\",IF('Section 2'!$J$14=0,\"\",'Section 2'!$J$14))","v":""},{"$f":"IF(C6=\"\",\"\",IF('Section 2'!$K$14=0,\"\",'Section 2'!$K$14))","v":""},{"$f":"IFERROR(VLOOKUP($A6,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:E$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A6,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:F$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A6,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:G$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A6,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:H$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A6,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:I$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A6,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:J$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A6,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:K$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A6,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:L$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A6,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:M$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A6,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:N$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A6,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:O$19),0),\"\")","v":""}]
[6,"",{"$f":"IFERROR(VLOOKUP($A7,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:D$19),0),\"\")","v":""},{"$f":"IF(C7=\"\",\"\",'Section 2'!$D$14)","v":""},{"$f":"IF(C7=\"\",\"\",IF('Section 2'!$E$14=0,\"\",'Section 2'!$E$14))","v":""},{"$f":"IF(C7=\"\",\"\",IF('Section 2'!$F$14=0,\"\",'Section 2'!$F$14))","v":""},{"$f":"IF(C7=\"\",\"\",IF('Section 2'!$G$14=0,\"\",'Section 2'!$G$14))","v":""},{"$f":"IF(C7=\"\",\"\",IF('Section 2'!$H$14=0,\"\",'Section 2'!$H$14))","v":""},{"$f":"IF(C7=\"\",\"\",IF('Section 2'!$I$14=0,\"\",'Section 2'!$I$14))","v":""},{"$f":"IF(C7=\"\",\"\",IF('Section 2'!$J$14=0,\"\",'Section 2'!$J$14))","v":""},{"$f":"IF(C7=\"\",\"\",IF('Section 2'!$K$14=0,\"\",'Section 2'!$K$14))","v":""},{"$f":"IFERROR(VLOOKUP($A7,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:E$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A7,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:F$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A7,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:G$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A7,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:H$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A7,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:I$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A7,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:J$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A7,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:K$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A7,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:L$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A7,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:M$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A7,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:N$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A7,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:O$19),0),\"\")","v":""}]
[7,"",{"$f":"IFERROR(VLOOKUP($A8,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:D$19),0),\"\")","v":""},{"$f":"IF(C8=\"\",\"\",'Section 2'!$D$14)","v":""},{"$f":"IF(C8=\"\",\"\",IF('Section 2'!$E$14=0,\"\",'Section 2'!$E$14))","v":""},{"$f":"IF(C8=\"\",\"\",IF('Section 2'!$F$14=0,\"\",'Section 2'!$F$14))","v":""},{"$f":"IF(C8=\"\",\"\",IF('Section 2'!$G$14=0,\"\",'Section 2'!$G$14))","v":""},{"$f":"IF(C8=\"\",\"\",IF('Section 2'!$H$14=0,\"\",'Section 2'!$H$14))","v":""},{"$f":"IF(C8=\"\",\"\",IF('Section 2'!$I$14=0,\"\",'Section 2'!$I$14))","v":""},{"$f":"IF(C8=\"\",\"\",IF('Section 2'!$J$14=0,\"\",'Section 2'!$J$14))","v":""},{"$f":"IF(C8=\"\",\"\",IF('Section 2'!$K$14=0,\"\",'Section 2'!$K$14))","v":""},{"$f":"IFERROR(VLOOKUP($A8,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:E$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A8,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:F$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A8,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:G$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A8,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:H$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A8,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:I$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A8,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:J$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A8,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:K$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A8,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:L$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A8,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:M$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A8,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:N$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A8,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:O$19),0),\"\")","v":""}]
[8,"",{"$f":"IFERROR(VLOOKUP($A9,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:D$19),0),\"\")","v":""},{"$f":"IF(C9=\"\",\"\",'Section 2'!$D$14)","v":""},{"$f":"IF(C9=\"\",\"\",IF('Section 2'!$E$14=0,\"\",'Section 2'!$E$14))","v":""},{"$f":"IF(C9=\"\",\"\",IF('Section 2'!$F$14=0,\"\",'Section 2'!$F$14))","v":""},{"$f":"IF(C9=\"\",\"\",IF('Section 2'!$G$14=0,\"\",'Section 2'!$G$14))","v":""},{"$f":"IF(C9=\"\",\"\",IF('Section 2'!$H$14=0,\"\",'Section 2'!$H$14))","v":""},{"$f":"IF(C9=\"\",\"\",IF('Section 2'!$I$14=0,\"\",'Section 2'!$I$14))","v":""},{"$f":"IF(C9=\"\",\"\",IF('Section 2'!$J$14=0,\"\",'Section 2'!$J$14))","v":""},{"$f":"IF(C9=\"\",\"\",IF('Section 2'!$K$14=0,\"\",'Section 2'!$K$14))","v":""},{"$f":"IFERROR(VLOOKUP($A9,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:E$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A9,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:F$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A9,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:G$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A9,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:H$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A9,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:I$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A9,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:J$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A9,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:K$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A9,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:L$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A9,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:M$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A9,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:N$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A9,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:O$19),0),\"\")","v":""}]
[9,"",{"$f":"IFERROR(VLOOKUP($A10,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:D$19),0),\"\")","v":""},{"$f":"IF(C10=\"\",\"\",'Section 2'!$D$14)","v":""},{"$f":"IF(C10=\"\",\"\",IF('Section 2'!$E$14=0,\"\",'Section 2'!$E$14))","v":""},{"$f":"IF(C10=\"\",\"\",IF('Section 2'!$F$14=0,\"\",'Section 2'!$F$14))","v":""},{"$f":"IF(C10=\"\",\"\",IF('Section 2'!$G$14=0,\"\",'Section 2'!$G$14))","v":""},{"$f":"IF(C10=\"\",\"\",IF('Section 2'!$H$14=0,\"\",'Section 2'!$H$14))","v":""},{"$f":"IF(C10=\"\",\"\",IF('Section 2'!$I$14=0,\"\",'Section 2'!$I$14))","v":""},{"$f":"IF(C10=\"\",\"\",IF('Section 2'!$J$14=0,\"\",'Section 2'!$J$14))","v":""},{"$f":"IF(C10=\"\",\"\",IF('Section 2'!$K$14=0,\"\",'Section 2'!$K$14))","v":""},{"$f":"IFERROR(VLOOKUP($A10,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:E$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A10,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:F$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A10,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:G$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A10,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:H$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A10,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:I$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A10,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:J$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A10,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:K$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A10,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:L$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A10,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:M$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A10,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:N$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A10,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:O$19),0),\"\")","v":""}]
[10,"",{"$f":"IFERROR(VLOOKUP($A11,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:D$19),0),\"\")","v":""},{"$f":"IF(C11=\"\",\"\",'Section 2'!$D$14)","v":""},{"$f":"IF(C11=\"\",\"\",IF('Section 2'!$E$14=0,\"\",'Section 2'!$E$14))","v":""},{"$f":"IF(C11=\"\",\"\",IF('Section 2'!$F$14=0,\"\",'Section 2'!$F$14))","v":""},{"$f":"IF(C11=\"\",\"\",IF('Section 2'!$G$14=0,\"\",'Section 2'!$G$14))","v":""},{"$f":"IF(C11=\"\",\"\",IF('Section 2'!$H$14=0,\"\",'Section 2'!$H$14))","v":""},{"$f":"IF(C11=\"\",\"\",IF('Section 2'!$I$14=0,\"\",'Section 2'!$I$14))","v":""},{"$f":"IF(C11=\"\",\"\",IF('Section 2'!$J$14=0,\"\",'Section 2'!$J$14))","v":""},{"$f":"IF(C11=\"\",\"\",IF('Section 2'!$K$14=0,\"\",'Section 2'!$K$14))","v":""},{"$f":"IFERROR(VLOOKUP($A11,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:E$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A11,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:F$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A11,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:G$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A11,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:H$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A11,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:I$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A11,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:J$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A11,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:K$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A11,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:L$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A11,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:M$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A11,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:N$19),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A11,'Section 2'!$D$22:$O$31,COLUMNS('Section 2'!$D$18:O$19),0),\"\")","v":""}]
["LastRow"]