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

{"sheet":"Instructions","index":0,"n_rows":19,"n_cols":3,"rows_kept":19}
[]
[null,null,"U.S. Environmental Protection Agency"]
[null,null,"Stratospheric Ozone Protection Program"]
[]
[null,null,"Methyl Bromide Pre-2005 Stocks Annual Report (Sec 82.13)"]
[null,null,"Version 3.0"]
[null,null,"Last Updated: March 2019"]
[]
[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 in Section 2 to generate your CSV file.  "]
[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 1 hour 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-142"]
[null,null,"OMB Control Number: 2010-0170"]
[null,null,"Expiration Date: 8/31/2021"]

{"sheet":"Section 1","index":1,"n_rows":15,"n_cols":14,"rows_kept":15,"merged":[[7,2,7,3]]}
[]
[null,null,"U.S. Environmental Protection Agency"]
[null,null,"Methyl Bromide Pre-2005 Stocks Annual Report"]
[]
[null,null,"   Date Prepared:",{"$f":"TODAY()","v":"2019-03-28"}]
[]
[null,null,"Section 1: Report Identification Information "]
[null,null,"Complete all fields below.  No fields may be left blank."]
[null,null,"Company Name: ",null,null,{"$f":"IF($D$9=0,1,0)","v":1}]
[null,null,"Submission Type:",null,null,{"$f":"IF($D$10=0,1,0)","v":1}]
[null,null,"Reporting Year:",null,null,{"$f":"IF(OR($D$11=0,$D$11>Lists!$E$3),1,0)","v":1},null,null,{"$f":"IF(D11>Lists!E3,\"PLEASE CHOOSE A CURRENT OR PAST YEAR\",\"\")","v":""}]
[null,null,"Company Type \n(Select all that apply):",null,null,{"$f":"IF(COUNTIF(K12:N12,\"TRUE\")>0,0,1)","v":1},{"$nulls":4},false,false,false,false]
[{"$nulls":3},""]
[{"$nulls":3},{"$f":"Lists!C3","v":"Original Submission"}]
[{"$nulls":3},{"$f":"Lists!C4","v":"Re-Submittal"}]

{"sheet":"Section 2","index":2,"n_rows":16,"n_cols":11,"rows_kept":16,"merged":[[8,3,8,4],[10,3,10,4]]}
[]
[{"$nulls":3},"U.S. Environmental Protection Agency"]
[{"$nulls":3},"Methyl Bromide Pre-2005 Stocks Annual Report"]
[]
[{"$nulls":3},{"$f":"\"Company Name: \"&IF('Section 1'!D9=0,\"\",'Section 1'!D9)","v":"Company Name: "}]
[{"$nulls":3},{"$f":"\"Reporting Period: \"&IF('Section 1'!D11=0,\"\",'Section 1'!D11)","v":"Reporting Period: "}]
[]
[{"$nulls":3},"Section 2: Pre-2005 Stocks Data"]
[{"$nulls":3},"Identify the total stocks of pre-phaseout methyl bromide held as of December 31 of the reporting year. Include all quantities owned by your company that are held by other suppliers."]
[{"$nulls":3},"Total Stocks of Pre-Phaseout Methyl Bromide (kg)",{"$nulls":4},"Total Stocks Completeness",{"$f":"IF(E10=\"\",1,0)","v":1}]
[{"$nulls":3},"In addition to stocks that are held by your company, identify the name of company(s) holding pre-phaseout stocks of methyl bromide on behalf of your company (i.e., the owner of the material), and the total stocks held by the respective company(s)."]
[{"$nulls":3},"Company Name","Amount Held on Behalf of Owner"]
[{"$nulls":3},"Text","kg",{"$nulls":3},"ActiveRow?","Character Check","Completeness"]
[{"$f":"IF(D14=0,\"\",1)","v":""},{"$nulls":7},{"$f":"IF(A14=\"\",\"N\",\"Y\")","v":"N"},{"$f":"IF(LEN(D14)>200,1,0)","v":0},{"$f":"IF(AND(I14=\"Y\",OR(E14=0,E14=\"\")),1,0)","v":0}]
[{"$f":"IF(D15=0,\"\",MAX($A$14:A14)+1)","v":""},{"$nulls":7},{"$f":"IF(A15=\"\",\"N\",\"Y\")","v":"N"},{"$f":"IF(LEN(D15)>200,1,0)","v":0},{"$f":"IF(AND(I15=\"Y\",OR(E15=0,E15=\"\")),1,0)","v":0}]
[{"$f":"IF(D16=0,\"\",MAX($A$14:A15)+1)","v":""},{"$nulls":7},{"$f":"IF(A16=\"\",\"N\",\"Y\")","v":"N"},0,0]

{"sheet":"Lists","index":3,"n_rows":25,"n_cols":11,"rows_kept":25,"hidden":true}
[]
[null,"Chemical Name","Submission Type","Reporting Year","Current Year","MeBr Company Types","Date for CSV Title","Form Name for CSV Title",null,"Form Type","Form Code"]
[null,"CH3Br","Original Submission",2018,{"$f":"YEAR(TODAY())","v":2019},"Distributor",{"$f":"MONTH(SubDate)&\"-\"&DAY(SubDate)&\"-\"&YEAR(SubDate)","v":"3-28-2019"},"MeBr Pre-2005 Stocks",null,"Class I Producer","PROD1"]
[null,null,"Re-Submittal",2019,null,"Third Party Applicator",{"$nulls":3},"MeBr Producer","PROD3"]
[{"$nulls":3},2020,null,"Producer",{"$nulls":3},"Class II Producer","PROD2"]
[{"$nulls":5},"Importer ",{"$nulls":3},"Class I Importer","IMPT1"]
[{"$nulls":9},"MeBr Importer","IMPT3"]
[{"$nulls":9},"Class II Importer","IMPT2"]
[{"$nulls":9},"Class I Exporter","EXPT1"]
[{"$nulls":9},"MeBr Exporter","EXPT3"]
[{"$nulls":9},"Class II Exporter","EXPT2"]
[{"$nulls":9},"Class I Lab Supplier","LABS1"]
[{"$nulls":9},"Class I Destruction","DEST1"]
[{"$nulls":9},"MeBr Destruction","DEST3"]
[{"$nulls":9},"Class II Destruction","DEST2"]
[{"$nulls":9},"Class I Transformation","TRAN1"]
[{"$nulls":9},"MeBr Transformation","TRAN3"]
[{"$nulls":9},"Class II Transformation","TRAN2"]
[{"$nulls":9},"MeBr Trades","TRAD3"]
[{"$nulls":9},"Class II Trades","TRAD2"]
[{"$nulls":9},"Class II RACA","RACA2"]
[{"$nulls":9},"MeBr Distributor of QPS","MBQPS"]
[{"$nulls":9},"MeBr Pre-2005 Stocks","MB05S"]
[{"$nulls":9},"MeBr Sales of CU","MBCUE"]
[{"$nulls":9},"Petitions","PETIT"]

{"sheet":"Checks","index":4,"n_rows":13,"n_cols":6,"rows_kept":13,"hidden":true}
[]
[null,"Section","Check Description","Status (1 = Incomplete, 0 = Complete)","Check Type","Added to Code?"]
[null,"Section 1","All",{"$f":"IF(SUM('Section 1'!F9:F12)>0,1,0)","v":1},"Stopper","Yes"]
[null,"Section 2","Total Stocks Completeness",{"$f":"'Section 2'!J10","v":1},"Stopper","Yes"]
[null,"Section 2","Character Check",{"$f":"SUM('Section 2'!J14:J16)","v":0},"Stopper","Yes"]
[null,"Section 2","Completeness",{"$f":"SUM('Section 2'!K14:K16)","v":0},"Stopper","Yes"]
[null,"Section 2","Error Check",{"$f":"IF(SUM(D4:D6)>0,1,0)","v":1},"Error Check","N/A"]
[null,"All","Error Check",{"$f":"IF(SUM(Sec1Status,Sec2Error)>0,1,0)","v":1},"Error Check","Yes"]
[]
[]
[null,"Numerical Checks against Output for CSV"]
[null,"Section 2","Net Production",{"$f":"SUMIF('Section 2'!I14:I16,\"Y\",'Section 2'!E14:E16)+'Section 2'!E10-SUM(OutputForCSV!C2,OutputForCSV!E2,OutputForCSV!G2,OutputForCSV!I2)","v":{"v":0,"d":"0.00"}}]
[null,"ALL","TOTAL",{"$f":"SUM(D12:D12)","v":{"v":0,"d":"0.00"}}]

{"sheet":"OutputForCSV","index":5,"n_rows":3,"n_cols":18,"rows_kept":3,"hidden":true}
["Entry",1,"MB05S",3,{"$f":"'Section 1'!D5","v":"2019-03-28"},{"$f":"'Section 1'!D9","v":0},{"$f":"'Section 1'!D10","v":0},{"$f":"'Section 1'!D11","v":0},"Annual",{"$f":"IF('Section 1'!K12=TRUE,1,0)","v":0},{"$f":"IF('Section 1'!L12=TRUE,1,0)","v":0},{"$f":"IF('Section 1'!M12=TRUE,1,0)","v":0},{"$f":"IF('Section 1'!N12=TRUE,1,0)","v":0},null,"LastColumn"]
[1,{"$f":"IF(C2=\"\",\"\",2)","v":""},{"$f":"IF('Section 2'!E10=\"\",\"\",'Section 2'!E10)","v":""},{"$f":"IF('Section 2'!D14=\"\",\"\",'Section 2'!D14)","v":""},{"$f":"IF('Section 2'!E14=\"\",\"\",'Section 2'!E14)","v":""},{"$f":"IF('Section 2'!D15=\"\",\"\",'Section 2'!D15)","v":""},{"$f":"IF('Section 2'!E15=\"\",\"\",'Section 2'!E15)","v":""},{"$f":"IF('Section 2'!D16=\"\",\"\",'Section 2'!D16)","v":""},{"$f":"IF('Section 2'!E16=\"\",\"\",'Section 2'!E16)","v":""},{"$nulls":5},{"$f":"IFERROR(VLOOKUP($A2,#REF!,COLUMNS(#REF!),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A2,#REF!,COLUMNS(#REF!),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A2,#REF!,COLUMNS(#REF!),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($A2,#REF!,COLUMNS(#REF!),0),\"\")","v":""}]
["LastRow"]