{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Section 1","Section 2","Lists","Checks","OutputForCSV"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":24,"comments":5,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":19,"n_cols":3,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"OMB Control Number: 2060-0170"]
[null,null,"Expiration Date: 4/30/2023"]
[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 4.1"]
[null,null,"Last Updated: July 2020"]
[]
[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,"This collection of information is approved by OMB under the Paperwork Reduction Act, 44 U.S.C. 3501 et seq. (OMB Control No. 2060-0170). Responses to this collection of information are mandatory (40 CFR 82.13). An agency may not conduct or sponsor, and a person is not required to respond to, a collection of information unless it displays a currently valid OMB control number. The number and expiration date are displayed in the upper right corner of the form. The public reporting and recordkeeping burden for this collection of information is estimated to be 1 hours per response. Send comments on the Agency’s need this formation, 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, Regulatory Support Division, U.S. Environmental Protection Agency (2821T), 1200 Pennsylvania Ave., 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"]

{"sheet":"Section 1","index":1,"n_rows":15,"n_cols":14,"rows_kept":15,"cut":false,"hidden":false,"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":"2020-07-15"}]
[]
[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},null,null,null,null,false,false,false,false]
[null,null,null,""]
[null,null,null,{"$f":"Lists!C3","v":"Original Submission"}]
[null,null,null,{"$f":"Lists!C4","v":"Re-Submittal"}]

{"sheet":"Section 2","index":2,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[8,3,8,4],[10,3,10,4]]}
[]
[null,null,null,"U.S. Environmental Protection Agency"]
[null,null,null,"Methyl Bromide Pre-2005 Stocks Annual Report"]
[]
[null,null,null,{"$f":"\"Company Name: \"&IF('Section 1'!D9=0,\"\",'Section 1'!D9)","v":"Company Name: "}]
[null,null,null,{"$f":"\"Reporting Period: \"&IF('Section 1'!D11=0,\"\",'Section 1'!D11)","v":"Reporting Period: "}]
[]
[null,null,null,"Section 2: Pre-2005 Stocks Data"]
[null,null,null,"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."]
[null,null,null,"Total Stocks of Pre-Phaseout Methyl Bromide (kg)",null,null,null,null,"Total Stocks Completeness",{"$f":"IF(E10=\"\",1,IF(E10<0,1,0))","v":1}]
[null,null,null,"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)."]
[null,null,null,"Company Name","Amount Held on Behalf of Owner"]
[null,null,null,"Text","kg",null,null,null,"ActiveRow?","Character Check","Completeness","Neg Number?"]
[{"$f":"IF(D14=0,\"\",1)","v":""},null,null,null,null,null,null,null,{"$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(E14<0,1,0)","v":0}]
[{"$f":"IF(D15=0,\"\",MAX($A$14:A14)+1)","v":""},null,null,null,null,null,null,null,{"$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(E15<0,1,0)","v":0}]
[{"$f":"IF(D16=0,\"\",MAX($A$14:A15)+1)","v":""},null,null,null,null,null,null,null,{"$f":"IF(A16=\"\",\"N\",\"Y\")","v":"N"},0,0,0]

{"sheet":"Lists","index":3,"n_rows":31,"n_cols":14,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
[]
[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,"Invalid Character","Replacement Character"]
[null,"CH3Br","Original Submission",2018,{"$f":"YEAR(TODAY())","v":2020},"Distributor",{"$f":"MONTH(SubDate)&\"-\"&DAY(SubDate)&\"-\"&YEAR(SubDate)","v":"7-15-2020"},"MeBr Pre-2005 Stocks",null,"Class I Producer","PROD1",null,"À","A"]
[null,null,"Re-Submittal",2019,null,"Third Party Applicator",null,null,null,"MeBr Producer","PROD3",null,"Á","A"]
[null,null,null,2020,null,"Producer",null,null,null,"Class II Producer","PROD2",null,"Ã","A"]
[null,null,null,2021,null,"Importer ",null,null,null,"Class I Importer","IMPT1",null,"Ä","A"]
[null,null,null,2022,null,null,null,null,null,"MeBr Importer","IMPT3",null,"Â","A"]
[null,null,null,2023,null,null,null,null,null,"Class II Importer","IMPT2",null,"Å","A"]
[null,null,null,2024,null,null,null,null,null,"Class I Exporter","EXPT1",null,"È","E"]
[null,null,null,2025,null,null,null,null,null,"MeBr Exporter","EXPT3",null,"É","E"]
[null,null,null,2026,null,null,null,null,null,"Class II Exporter","EXPT2",null,"Ê","E"]
[null,null,null,2027,null,null,null,null,null,"Class I Lab Supplier","LABS1",null,"Ë","E"]
[null,null,null,2028,null,null,null,null,null,"Class I Destruction","DEST1",null,"Ì","I"]
[null,null,null,2029,null,null,null,null,null,"MeBr Destruction","DEST3",null,"Í","I"]
[null,null,null,null,null,null,null,null,null,"Class II Destruction","DEST2",null,"Í","I"]
[null,null,null,null,null,null,null,null,null,"Class I Transformation","TRAN1",null,"Ï","I"]
[null,null,null,null,null,null,null,null,null,"MeBr Transformation","TRAN3",null,"Ò","O"]
[null,null,null,null,null,null,null,null,null,"Class II Transformation","TRAN2",null,"Ó","O"]
[null,null,null,null,null,null,null,null,null,"MeBr Trades","TRAD3",null,"Ô","O"]
[null,null,null,null,null,null,null,null,null,"Class II Trades","TRAD2",null,"Ö","O"]
[null,null,null,null,null,null,null,null,null,"Class II RACA","RACA2",null,"Õ","O"]
[null,null,null,null,null,null,null,null,null,"MeBr Distributor of QPS","MBQPS",null,"Ù","U"]
[null,null,null,null,null,null,null,null,null,"MeBr Pre-2005 Stocks","MB05S",null,"Ú","U"]
[null,null,null,null,null,null,null,null,null,"MeBr Sales of CU","MBCUE",null,"Û","U"]
[null,null,null,null,null,null,null,null,null,"Petitions","PETIT",null,"Ü","U"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ç","C"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ñ","N"]
[null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null," "," "]
[null,null,null,null,null,null,null,null,null,null,null,null,"–"," "]
[null,null,null,null,null,null,null,null,null,null,null,null,"—"," "]

{"sheet":"Checks","index":4,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[]
[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","Negative Amount?",{"$f":"IF(SUM('Section 2'!L14:L16)>0,1,0)","v":0},"Stopper"]
[null,"Section 2","Error Check",{"$f":"IF(SUM(D4:D7)>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":0}]
[null,"ALL","TOTAL",{"$f":"SUM(D13:D13)","v":0}]

{"sheet":"OutputForCSV","index":5,"n_rows":3,"n_cols":18,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Entry",1,"MB05S",4,{"$f":"'Section 1'!D5","v":"2020-07-15"},{"$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":""},null,null,null,null,null,{"$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"]