{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Instructions","Section 1","Section 2","Lists","Checks","OutputForCSV"],"not_rendered":{"macros":1,"defined_names":21,"comments":3},"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,"Distributer of QPS Methyl Bromide Quarterly Report (Sec 82.13)"]
[null,null,"Version 1.0 "]
[null,null,"Last Updated: December 2017"]
[]
[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 2 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-155"]
[null,null,"OMB Control Number: 2060-0482"]
[null,null,"Expiration Date: 8/31/2018"]

{"sheet":"Section 1","index":1,"n_rows":15,"n_cols":9,"rows_kept":15,"merged":[[7,2,7,3]]}
[]
[null,null,"U.S. Environmental Protection Agency"]
[null,null,"Distributer of QPS Methyl Bromide Quarterly Report"]
[]
[null,null,"   Date Prepared:",{"$f":"TODAY()","v":"2017-12-06"}]
[]
[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,"Reporting Quarter:",null,null,{"$f":"IF($D$12=0,1,0)","v":1}]
[{"$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":13,"n_cols":9,"rows_kept":13,"merged":[[8,3,8,4],[11,3,11,4]]}
[]
[{"$nulls":3},"U.S. Environmental Protection Agency"]
[{"$nulls":3},"Distributer of Methyl Bromide QPS Quarterly 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: Distributer of QPS Data"]
[{"$nulls":3},"Identify the amount of QPS methyl bromide distributed by your company during the reporting period.  If no methyl bromide was distributed for QPS, enter 0."]
[{"$nulls":3},"Total quantity of methyl bromide delivered for use in certified QPS applications (kg)",{"$nulls":3},"Total quantity completeness",{"$f":"IF(E10=\"\",1,0)","v":1}]
[]
[{"$nulls":3},"Supplier Identification: Identify the name(s) of the producer(s) or importer(s) to whom a certification was provided that the quantity of methyl bromide received will be used only for QPS application."]
[{"$nulls":3},"Company Name"]

{"sheet":"Lists","index":3,"n_rows":25,"n_cols":11,"rows_kept":25,"hidden":true}
[]
[null,"Chemical Name","Submission Type","Reporting Year","Current Year","Reporting Quarter","Date for CSV Title","Form Name for CSV Title",null,"Form Type","Form Code"]
[null,"CH3Br","Original Submission",2018,{"$f":"YEAR(TODAY())","v":2017},1,{"$f":"TODAY()","v":"2017-12-06"},"MeBr Distributor of QPS",null,"Class I Producer","PROD1"]
[null,null,"Re-Submittal",2019,null,2,{"$nulls":3},"MeBr Producer","PROD3"]
[{"$nulls":3},2020,null,3,{"$nulls":3},"Class II Producer","PROD2"]
[{"$nulls":5},4,{"$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":12,"n_cols":4,"rows_kept":12,"hidden":true}
[]
[null,"Section","Check Description","Status (1 = Incomplete, 0 = Complete)"]
[null,"Section 1","All",{"$f":"IF(SUM('Section 1'!F9:F12)>0,1,0)","v":1}]
[null,"Section 2","Positive #?",{"$f":"IF('Section 2'!I10>0,1,0)","v":1}]
[null,"Section 2","Error Check",{"$f":"IF(Sec2Positive=1,1,0)","v":1}]
[null,"All","Error Check",{"$f":"IF(SUM(Sec1Status,Sec2Status)>0,1,0)","v":1}]
[]
[]
[]
[null,"Numerical Checks against Output for CSV"]
[null,"Section 2","Total quantity of methyl bromide",{"$f":"'Section 2'!E10-OutputForCSV!D2","v":{"v":0,"d":"0.00"}}]
[null,"ALL","TOTAL",{"$f":"SUM(D11:D11)","v":{"v":0,"d":"0.00"}}]

{"sheet":"OutputForCSV","index":5,"n_rows":3,"n_cols":12,"rows_kept":3,"hidden":true}
["Entry",1,"MBQPS",1,{"$f":"'Section 1'!D5","v":"2017-12-06"},{"$f":"'Section 1'!D9","v":0},{"$f":"'Section 1'!D10","v":0},{"$f":"'Section 1'!D11","v":0},{"$f":"'Section 1'!D12","v":0},null,null,"LastColumn"]
[1,{"$f":"IF(C2=\"\",\"\",2)","v":2},{"$f":"IF(D2=\"\",\"\",Lists!B3)","v":"CH3Br"},{"$f":"'Section 2'!E10","v":0},{"$f":"IF('Section 2'!D14=0,\"\",'Section 2'!D14)","v":""},{"$f":"IF('Section 2'!D15=0,\"\",'Section 2'!D15)","v":""},{"$f":"IF('Section 2'!D16=0,\"\",'Section 2'!D16)","v":""},{"$f":"IF('Section 2'!D17=0,\"\",'Section 2'!D17)","v":""}]
["LastRow"]