{"text_format":"3","workbook":"xlsx","n_sheets":10,"sheets":["Instructions","Section 1","Section 2","Section 3","Section 4","Summary","Lists","Checks","OutputForCSV","TempOutput"],"not_rendered":{"macros":1,"defined_names":47,"comments":6},"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 Producer 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 on the Summary tab 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-141"]
[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,"Methyl Bromide Producer 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(OR(SubTSelection=Lists!C3,SubTSelection=Lists!C4),0,1)","v":1},null,null,{"$f":"IF(SubTSelection=\"\",\"\",IF(OR(SubTSelection=Lists!C3,SubTSelection=Lists!C4),\"\",\"PLEASE SELECT A VALID SUBMISSION TYPE FROM THE DROPDOWN LIST\"))","v":""}]
[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(OR(ReportQtr=0,ReportQtr>Lists!F6),1,0)","v":1},null,null,{"$f":"IF(ReportQtr>Lists!F6,\"PLEASE SELECT A VALID QUARTER FROM THE DROPDOWN LIST\",\"\")","v":""}]
[{"$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":19,"rows_kept":13,"merged":[[8,3,8,13],[13,3,13,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[18,3,18,4]]}
[]
[{"$nulls":3},"U.S. Environmental Protection Agency"]
[{"$nulls":3},"Methyl Bromide Producer Quarterly Report"]
[]
[{"$nulls":3},"Company Name:",{"$f":"IF('Section 1'!D9=0,\"\",'Section 1'!D9)","v":""}]
[{"$nulls":3},"Reporting Period:",{"$f":"IF(OR('Section 1'!D11=0,'Section 1'!D12=0),\"\",\"Quarter \"&'Section 1'!D12&\", \"&'Section 1'!D11)","v":""}]
[]
[{"$nulls":3},"Section 2: Production Data"]
[{"$nulls":3},"In the table below, enter the quantity of methyl bromide that was produced during the reporting period.  If no methyl bromide was produced, the table may be left blank. As a reminder, if methyl bromide was produced for QPS applications, global lab, emergency uses, second party transformation, or second party destruction, a copy of the transformation verification, destruction verification, QPS certification, and/or essential use certification from each company for whom material was produced must be provided to EPA along with the submission of this report.\n"]
[{"$nulls":3},"In-House Transformation ","Second Party Transformation ","In-House Destruction ","Second Party Destruction ","QPS","Pre-Plant Critical Use","Post-Harvest Critical Use","Critical Use for Export","Emergency Use","Global Lab","Gross Production"]
[{"$nulls":3},"kg","kg","kg","kg","kg","kg","kg","kg","kg","kg","Autopopulated"]
[{"$nulls":3},{"v":1500,"d":"1,500.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":100.5,"d":"100.50"},{"v":0,"d":"0.00"},{"v":200,"d":"200.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"D12+E12+F12+G12+H12+I12+J12+K12+L12+M12","v":{"v":1800.5,"d":"1,800.50"}},null,null,"Filled Out?","Sec2 Inclusion 2nd Party in Sec 3? - Trans/Dest","Section 3 Inclusion - Global Lab/Emergency"]
[{"$f":"IF(Q13=0,1,\"\")","v":""},{"$nulls":12},{"$f":"IF((D13+E13+F13+G13+H13+I13+J13+K13+L13+M13)=0,\"\",D13+E13+F13+G13+H13+I13+J13+K13+L13+M13)","v":""},null,null,{"$f":"IF(N13=\"\",\"N\",0)","v":"N"},{"$f":"IF(Q13=\"N\",0,IF(OR(AND(E13>0,COUNTIF('Section 3'!$G$15:$G$24,Lists!G3)=0),AND(G13>0,COUNTIF('Section 3'!$G$15:$G$24,Lists!G4)=0),AND(H13>0,COUNTIF('Section 3'!$G$15:$G$24,Lists!G5)=0)),1,0))","v":0},{"$f":"IF(Q13=\"N\",0,IF(OR(AND(M13>0,COUNTIF('Section 3'!$G$15:$G$24,Lists!G6)=0),AND(L13>0,COUNTIF('Section 3'!$G$15:$G$24,Lists!G7)=0)),1,0))","v":0}]

{"sheet":"Section 3","index":3,"n_rows":30,"n_cols":17,"rows_kept":30,"merged":[[8,3,8,6],[9,3,9,6],[10,3,10,6],[11,3,11,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[23,3,23,4]]}
[]
[{"$nulls":3},"U.S. Environmental Protection Agency"]
[{"$nulls":3},"Methyl Bromide Producer Quarterly Report"]
[]
[{"$nulls":3},"Company Name:",{"$f":"IF('Section 1'!D9=0,\"\",'Section 1'!D9)","v":""}]
[{"$nulls":3},"Reporting Period:",{"$f":"IF(OR('Section 1'!D11=0,'Section 1'!D12=0),\"\",\"Quarter \"&'Section 1'!D12&\", \"&'Section 1'!D11)","v":""}]
[]
[{"$nulls":3},"Section 3: Shipment/Sales Data"]
[{"$nulls":3},"Identify the recipient company(s) of the methyl bromide produced for second party transformation, second party destruction, QPS, global lab, and/or emergency uses, and the amount shipped to or purchased by each recipient company during the quarter. "]
[{"$nulls":3},"Note: Due to a potential time lag between the date of production and the date of shipment, it is recognized that for a given quarter the information in Section 3 may not match the information reported in Section 2 for second party transformation, second party destruction, and QPS; however, it is expected that all material produced for second party transformation, second party destruction, and QPS will eventually be shipped to a second party and must be reported as such in the applicable quarterly report. "]
[{"$nulls":3},"As a reminder, a copy of the transformation verification, destruction verification, QPS certification, and/or essential use certification from each second party for whom material was produced must be provided to EPA along with the submission of this report."]
[{"$nulls":3},"Recipient Company Name",null,"Quantity","Purpose"]
[{"$nulls":3},"Text",null,"kg","Selection"]
[{"$nulls":3},"Company A",null,{"v":10,"d":"10.00"},"Transformation",{"$nulls":4},"ActiveRow?","Character Check","Completeness check","Valid Purpose","Sec2 Inclusion in Sec3 - LE","Sec2 Inclusion in Sec3 - 2nd Party/QPS"]
[{"$f":"IF(D15=0,\"\",1)","v":""},{"$nulls":10},{"$f":"IF(A15=\"\",\"N\",\"Y\")","v":"N"},{"$f":"IF(LEN(D15)>200,1,0)","v":0},{"$f":"IF(D15=0,0,IF(OR(F15=0,G15=0),1,0))","v":0},{"$f":"IF(G15=0,0,IF(COUNTIF(Lists!$G$3:$G$7,G15)>0,0,1))","v":0},{"$f":"IF(OR(AND('Section 2'!$M$13=0,G15=Lists!$G$6),AND('Section 2'!$L$13=0,G15=Lists!$G$7)),1,0)","v":0},{"$f":"IF(OR(AND('Section 2'!$E$13=0,G15=Lists!$G$3),AND('Section 2'!$G$13=0,G15=Lists!$G$4),AND('Section 2'!$H$13=0,G15=Lists!$G$5)),1,0)","v":0}]
[{"$f":"IF(D16=0,\"\",MAX($A$15:A15)+1)","v":""},{"$nulls":10},"N",{"$f":"IF(LEN(D16)>200,1,0)","v":0},{"$f":"IF(D16=0,0,IF(OR(F16=0,G16=0),1,0))","v":0},{"$f":"IF(G16=0,0,IF(COUNTIF(Lists!$G$3:$G$7,G16)>0,0,1))","v":0},{"$f":"IF(OR(AND('Section 2'!$M$13=0,G16=Lists!$G$6),AND('Section 2'!$L$13=0,G16=Lists!$G$7)),1,0)","v":0},{"$f":"IF(OR(AND('Section 2'!$E$13=0,G16=Lists!$G$3),AND('Section 2'!$G$13=0,G16=Lists!$G$4),AND('Section 2'!$H$13=0,G16=Lists!$G$5)),1,0)","v":0}]
[{"$f":"IF(D17=0,\"\",MAX($A$15:A16)+1)","v":""},{"$nulls":10},"N",0,{"$f":"IF(D17=0,0,IF(OR(F17=0,G17=0),1,0))","v":0},{"$f":"IF(G17=0,0,IF(COUNTIF(Lists!$G$3:$G$7,G17)>0,0,1))","v":0},{"$f":"IF(OR(AND('Section 2'!$M$13=0,G17=Lists!$G$6),AND('Section 2'!$L$13=0,G17=Lists!$G$7)),1,0)","v":0},{"$f":"IF(OR(AND('Section 2'!$E$13=0,G17=Lists!$G$3),AND('Section 2'!$G$13=0,G17=Lists!$G$4),AND('Section 2'!$H$13=0,G17=Lists!$G$5)),1,0)","v":0}]
[{"$f":"IF(D18=0,\"\",MAX($A$15:A17)+1)","v":""},{"$nulls":10},"N",0,0,{"$f":"IF(G18=0,0,IF(COUNTIF(Lists!$G$3:$G$7,G18)>0,0,1))","v":0},{"$f":"IF(OR(AND('Section 2'!$M$13=0,G18=Lists!$G$6),AND('Section 2'!$L$13=0,G18=Lists!$G$7)),1,0)","v":0},{"$f":"IF(OR(AND('Section 2'!$E$13=0,G18=Lists!$G$3),AND('Section 2'!$G$13=0,G18=Lists!$G$4),AND('Section 2'!$H$13=0,G18=Lists!$G$5)),1,0)","v":0}]
[{"$f":"IF(D19=0,\"\",MAX($A$15:A18)+1)","v":""},{"$nulls":10},"N",0,0,{"$f":"IF(G19=0,0,IF(COUNTIF(Lists!$G$3:$G$7,G19)>0,0,1))","v":0},{"$f":"IF(OR(AND('Section 2'!$M$13=0,G19=Lists!$G$6),AND('Section 2'!$L$13=0,G19=Lists!$G$7)),1,0)","v":0},{"$f":"IF(OR(AND('Section 2'!$E$13=0,G19=Lists!$G$3),AND('Section 2'!$G$13=0,G19=Lists!$G$4),AND('Section 2'!$H$13=0,G19=Lists!$G$5)),1,0)","v":0}]
[{"$f":"IF(D20=0,\"\",MAX($A$15:A19)+1)","v":""},{"$nulls":10},"N",0,0,{"$f":"IF(G20=0,0,IF(COUNTIF(Lists!$G$3:$G$7,G20)>0,0,1))","v":0},{"$f":"IF(OR(AND('Section 2'!$M$13=0,G20=Lists!$G$6),AND('Section 2'!$L$13=0,G20=Lists!$G$7)),1,0)","v":0},{"$f":"IF(OR(AND('Section 2'!$E$13=0,G20=Lists!$G$3),AND('Section 2'!$G$13=0,G20=Lists!$G$4),AND('Section 2'!$H$13=0,G20=Lists!$G$5)),1,0)","v":0}]
[{"$f":"IF(D21=0,\"\",MAX($A$15:A20)+1)","v":""},{"$nulls":10},"N",0,0,{"$f":"IF(G21=0,0,IF(COUNTIF(Lists!$G$3:$G$7,G21)>0,0,1))","v":0},{"$f":"IF(OR(AND('Section 2'!$M$13=0,G21=Lists!$G$6),AND('Section 2'!$L$13=0,G21=Lists!$G$7)),1,0)","v":0},{"$f":"IF(OR(AND('Section 2'!$E$13=0,G21=Lists!$G$3),AND('Section 2'!$G$13=0,G21=Lists!$G$4),AND('Section 2'!$H$13=0,G21=Lists!$G$5)),1,0)","v":0}]
[{"$f":"IF(D22=0,\"\",MAX($A$15:A21)+1)","v":""},{"$nulls":10},"N",0,0,{"$f":"IF(G22=0,0,IF(COUNTIF(Lists!$G$3:$G$7,G22)>0,0,1))","v":0},{"$f":"IF(OR(AND('Section 2'!$M$13=0,G22=Lists!$G$6),AND('Section 2'!$L$13=0,G22=Lists!$G$7)),1,0)","v":0},{"$f":"IF(OR(AND('Section 2'!$E$13=0,G22=Lists!$G$3),AND('Section 2'!$G$13=0,G22=Lists!$G$4),AND('Section 2'!$H$13=0,G22=Lists!$G$5)),1,0)","v":0}]
[{"$f":"IF(D23=0,\"\",MAX($A$15:A22)+1)","v":""},{"$nulls":10},"N",0,0,{"$f":"IF(G23=0,0,IF(COUNTIF(Lists!$G$3:$G$7,G23)>0,0,1))","v":0},{"$f":"IF(OR(AND('Section 2'!$M$13=0,G23=Lists!$G$6),AND('Section 2'!$L$13=0,G23=Lists!$G$7)),1,0)","v":0},{"$f":"IF(OR(AND('Section 2'!$E$13=0,G23=Lists!$G$3),AND('Section 2'!$G$13=0,G23=Lists!$G$4),AND('Section 2'!$H$13=0,G23=Lists!$G$5)),1,0)","v":0}]
[{"$f":"IF(D24=0,\"\",MAX($A$15:A23)+1)","v":""},{"$nulls":10},"N",0,0,{"$f":"IF(G24=0,0,IF(COUNTIF(Lists!$G$3:$G$7,G24)>0,0,1))","v":0},{"$f":"IF(OR(AND('Section 2'!$M$13=0,G24=Lists!$G$6),AND('Section 2'!$L$13=0,G24=Lists!$G$7)),1,0)","v":0},{"$f":"IF(OR(AND('Section 2'!$E$13=0,G24=Lists!$G$3),AND('Section 2'!$G$13=0,G24=Lists!$G$4),AND('Section 2'!$H$13=0,G24=Lists!$G$5)),1,0)","v":0}]
[{"$nulls":6},"x"]
[{"$nulls":6},{"$f":"Lists!G3","v":"Transformation"}]
[{"$nulls":6},{"$f":"Lists!G4","v":"Destruction"}]
[{"$nulls":6},{"$f":"Lists!G5","v":"QPS"}]
[{"$nulls":6},{"$f":"Lists!G6","v":"Global Lab"}]
[{"$nulls":6},{"$f":"Lists!G7","v":"Emergency Use"}]

{"sheet":"Section 4","index":4,"n_rows":17,"n_cols":13,"rows_kept":17,"hidden":true,"merged":[[8,3,8,7],[11,3,11,7],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[16,3,16,4]]}
[]
[{"$nulls":3},"U.S. Environmental Protection Agency"]
[{"$nulls":3},"Methyl Bromide Producer Quarterly Report"]
[]
[{"$nulls":3},"Company Name:",{"$f":"IF('Section 1'!D9=0,\"\",'Section 1'!D9)","v":""}]
[{"$nulls":3},"Reporting Period:",{"$f":"IF(OR('Section 1'!D11=0,'Section 1'!D12=0),\"\",\"Quarter \"&'Section 1'!D12&\", \"&'Section 1'!D11)","v":""}]
[]
[{"$nulls":3},"Section 4: Producers Critical Use Year-End Inventory (Quarter 4 Only)"]
[{"$nulls":3},"Identify the amount of critical use methyl bromide held by your company at the end of the control period.",{"$nulls":7},"Q4 Inventory Check","Q1-Q3 Completeness Check"]
[{"$nulls":4},"  kg owned by reporting company",{"$nulls":6},"IF(ReportQtr=4,IF(ISBLANK(D10),1,0),0)",{"$f":"IF(ReportQtr<4,IF(D10<>0,1,0),0)","v":0}]
[]
[{"$nulls":3},"Identify the name(s) of company(s) for which critical use methyl bromide is being held by the reporting entity, and the associated amounts held for each (excluding end-users)."]
[{"$nulls":3},"Company Name",null,"Pre-Plant ","Post-Harvest "]
[{"$nulls":3},"Text",null,"kg","kg",{"$nulls":3},"ActiveRow","Q4 Completeness Check","Q1-Q3 Completeness Check"]
[{"$f":"IF(D15=0,\"\",1)","v":""},{"$nulls":9},{"$f":"IF(D15=\"\",\"N\",\"Y\")","v":"N"},{"$f":"IF(K15=\"y\",IF(AND(ISBLANK(F15),ISBLANK(G15)),1,0),0)","v":0},{"$f":"IF(ReportQtr<4,IF(OR(K15=\"Y\",F15>0,G15>0),1,0),0)","v":0}]
[{"$f":"IF(D16=0,\"\",MAX($A$15:A15)+1)","v":""},{"$nulls":9},{"$f":"IF(D16=\"\",\"N\",\"Y\")","v":"N"},{"$f":"IF(K16=\"y\",IF(AND(ISBLANK(F16),ISBLANK(G16)),1,0),0)","v":0},{"$f":"IF(ReportQtr<4,IF(OR(K16=\"Y\",F16>0,G16>0),1,0),0)","v":0}]
[{"$f":"IF(D17=0,\"\",MAX($A$15:A16)+1)","v":""},{"$nulls":9},{"$f":"IF(D17=\"\",\"N\",\"Y\")","v":"N"},{"$f":"IF(K17=\"y\",IF(AND(ISBLANK(F17),ISBLANK(G17)),1,0),0)","v":0},{"$f":"IF(ReportQtr<4,IF(OR(K17=\"Y\",F17>0,G17>0),1,0),0)","v":0}]

{"sheet":"Summary","index":5,"n_rows":12,"n_cols":6,"rows_kept":12,"hidden":true,"merged":[[8,3,8,5],[9,3,10,3],[9,4,9,5]]}
[]
[{"$nulls":3},"U.S. Environmental Protection Agency"]
[{"$nulls":3},"Methyl Bromide Producer Quarterly Report"]
[]
[{"$nulls":3},"Company Name:",{"$f":"IF('Section 1'!D9=0,\"\",'Section 1'!D9)","v":""}]
[{"$nulls":3},"Reporting Period:",{"$f":"IF(OR('Section 1'!D11=0,'Section 1'!D12=0),\"\",\"Quarter \"&'Section 1'!D12&\", \"&'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 (kg)"]
[{"$nulls":4},"Pre-Plant Critical Use","Post-Harvest Critical Use"]
[1,null,null,"CH3Br",{"$f":"'Section 2'!I13","v":{"v":0,"d":"0.00"}},{"$f":"'Section 2'!J13","v":{"v":0,"d":"0.00"}}]

{"sheet":"Lists","index":6,"n_rows":25,"n_cols":15,"rows_kept":25,"hidden":true}
[{"$nulls":13},"Variables for Data Submission"]
[null,"Chemical Name","Submission Type","Reporting Year","Current Year","Reporting Quarter","Purpose","Date for CSV Title","Form Name for CSV Title",null,"Form Type","Form Code",null,null,"Row #"]
[null,"CH3Br","Original Submission",2018,{"$f":"YEAR(TODAY())","v":2017},1,"Transformation",{"$f":"MONTH(SubDate)&\"-\"&DAY(SubDate)&\"-\"&YEAR(SubDate)","v":"12-6-2017"},"MeBr Producer",null,"Class I Producer","PROD1",null,"Sec2End",{"$f":"IF(MAX(OutputForCSV!A2:A2)=0,1,MAX(OutputForCSV!A2:A2))","v":1}]
[null,null,"Re-Submittal",2019,null,2,"Destruction",{"$nulls":3},"MeBr Producer","PROD3",null,"Sec3Start",{"$f":"OutputForCSV!A3","v":""}]
[{"$nulls":3},2020,null,3,"QPS",{"$nulls":3},"Class II Producer","PROD2",null,"Sec3End",{"$f":"MAX(OutputForCSV!A3:A12)","v":0}]
[{"$nulls":5},4,"Global Lab",{"$nulls":3},"Class I Importer","IMPT1",null,"Sec4Start",{"$f":"OutputForCSV!A13","v":""}]
[{"$nulls":6},"Emergency Use",{"$nulls":3},"MeBr Importer","IMPT3",null,"Sec4End",{"$f":"MAX(OutputForCSV!A13:A16)","v":0}]
[{"$nulls":10},"Class II Importer","IMPT2",null,"MaxTempRow",{"$f":"IF(MAX(TempOutput!A2:A16)=0,1,MAX(TempOutput!A2:A16))","v":5}]
[{"$nulls":10},"Class I Exporter","EXPT1",null,"Sec3PasteRow",{"$f":"IF(O3=0,2,O3+1)","v":2}]
[{"$nulls":10},"MeBr Exporter","EXPT3",null,"Sec4PasteRow",{"$f":"ROWS(OutputForCSV!A1:A12)-COUNTIF(OutputForCSV!A2:A12,\"\")+1","v":2}]
[{"$nulls":10},"Class II Exporter","EXPT2"]
[{"$nulls":10},"Class I Lab Supplier","LABS1"]
[{"$nulls":10},"Class I Destruction","DEST1"]
[{"$nulls":10},"MeBr Destruction","DEST3"]
[{"$nulls":10},"Class II Destruction","DEST2"]
[{"$nulls":10},"Class I Transformation","TRAN1"]
[{"$nulls":10},"MeBr Transformation","TRAN3"]
[{"$nulls":10},"Class II Transformation","TRAN2"]
[{"$nulls":10},"MeBr Trades","TRAD3"]
[{"$nulls":10},"Class II Trades","TRAD2"]
[{"$nulls":10},"Class II RACA","RACA2"]
[{"$nulls":10},"MeBr Distributor of QPS","MBQPS"]
[{"$nulls":10},"MeBr Pre-2005 Stocks","MB05S"]
[{"$nulls":10},"MeBr Sales of CU","MBCUE"]
[{"$nulls":10},"Petitions","PETIT"]

{"sheet":"Checks","index":7,"n_rows":27,"n_cols":5,"rows_kept":27,"hidden":true}
[]
[null,"Section","Check Description","Status (1 = Incomplete, 0 = Complete)"]
[null,"Section 1","All - Section 1",{"$f":"IF(SUM('Section 1'!F9:F12)>0,1,0)","v":1},"Stopper"]
[null,"Section 2","Error Check","NONE","Error Check"]
[null,"Section 2","Filled Out",{"$f":"IF('Section 2'!Q13=\"N\",1,0)","v":1},"Warning"]
[null,"Section 3","Section 3 Inclusion - Lab/Emergency",{"$f":"'Section 2'!S13","v":0},"Stopper"]
[null,"Section 3","Character Check",{"$f":"IF(SUM('Section 3'!M15:M24)>0,1,0)","v":0},"Stopper"]
[null,"Section 3","Sec 2 Inclusion - Lab/Emergency",{"$f":"IF(SUM('Section 3'!P15:P24)>0,1,0)","v":0},"Stopper"]
[null,"Section 3","Completeness check",{"$f":"IF(SUM('Section 3'!N15:N24)>0,1,0)","v":0},"Stopper"]
[null,"Section 3","Sec3 Valid Purpose",{"$f":"IF(SUM('Section 3'!O15:O24)>0,1,0)","v":0},"Stopper"]
[null,"Section 3","Error Check",{"$f":"IF(SUM(D6:D10)>0,1,0)","v":0},"Error Check"]
[null,"Section 3","Sec2 Inclusion 2nd Party in Sec 3",{"$f":"'Section 2'!R13","v":0},"Warning"]
[null,"Section 3","Sec2 Inclusion 2nd Party in Sec3",{"$f":"IF(SUM('Section 3'!Q15:Q24)>0,1,0)","v":0},"Warning"]
[null,"Section 4","Q4 Completeness Check","IF(SUM('Section 4'!L15:L17)>0,1,0)","Stopper"]
[null,"Section 4","Q1-Q3 Completeness Check","IF(SUM('Section 4'!M15:M17,'Section 4'!M10)>0,1,0)","Stopper"]
[null,"Section 4","Q4 Inventory Check",{"$f":"'Section 4'!L10","v":"IF(ReportQtr=4,IF(ISBLANK(D10),1,0),0)"},"Stopper"]
[null,"Section 4","Error Check","IF(SUM(D14:D16)>0,1,0)","Error Check"]
[null,"All","Error Check",{"$f":"IF(SUM(Sec1Status,Sec2Error,Sec3Error,Sec4Error)>0,1,0)","v":1},"Error Check"]
[]
[]
[]
[]
[null,"Numerical Checks against Output for CSV"]
[null,"Section 2","Production (double counts with total",{"$f":"SUM('Section 2'!D13:N13)-SUM(OutputForCSV!E2:O2)","v":{"v":0,"d":"0.00"}}]
[null,"Section 3","Section 3 Quantity",{"$f":"SUMIF('Section 3'!L15:L24,\"Y\",'Section 3'!F15:F24)-SUM(OutputForCSV!F3:F12)","v":{"v":0,"d":"0.00"}}]
[null,"Section 4","Section 4 Quantities",{"$f":"SUMIF('Section 4'!K15:K17,\"Y\",'Section 4'!F15:F17)+SUMIF('Section 4'!K15:K17,\"Y\",'Section 4'!G15:G17)-SUM(OutputForCSV!E14:F16)","v":{"v":0,"d":"0.00"}}]
[null,"ALL","TOTAL",{"$f":"SUM(D24:D25)","v":{"v":0,"d":"0.00"}}]

{"sheet":"OutputForCSV","index":8,"n_rows":17,"n_cols":16,"rows_kept":17,"hidden":true}
["Row #","Entry",1,"PROD3","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},{"$nulls":5},"LastColumn"]
[{"$f":"IF(D2=\"\",\"\",ROWS($A$1:A2))","v":""},1,{"$f":"IF(D2=\"\",\"\",2)","v":""},{"$f":"IF(O2=\"\",\"\",\"CH3Br\")","v":""},{"$f":"IFERROR(VLOOKUP($B2,'Section 2'!$A$13:$N$13,COLUMNS('Section 2'!$A$13:D$13),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B2,'Section 2'!$A$13:$N$13,COLUMNS('Section 2'!$A$13:E$13),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B2,'Section 2'!$A$13:$N$13,COLUMNS('Section 2'!$A$13:F$13),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B2,'Section 2'!$A$13:$N$13,COLUMNS('Section 2'!$A$13:G$13),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B2,'Section 2'!$A$13:$N$13,COLUMNS('Section 2'!$A$13:H$13),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B2,'Section 2'!$A$13:$N$13,COLUMNS('Section 2'!$A$13:I$13),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B2,'Section 2'!$A$13:$N$13,COLUMNS('Section 2'!$A$13:J$13),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B2,'Section 2'!$A$13:$N$13,COLUMNS('Section 2'!$A$13:K$13),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B2,'Section 2'!$A$13:$N$13,COLUMNS('Section 2'!$A$13:L$13),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B2,'Section 2'!$A$13:$N$13,COLUMNS('Section 2'!$A$13:M$13),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B2,'Section 2'!$A$13:$N$13,COLUMNS('Section 2'!$A$13:N$13),0),\"\")","v":""}]
[{"$f":"IF(D3=\"\",\"\",ROWS($A$1:A3))","v":""},1,{"$f":"IF(D3=\"\",\"\",3)","v":""},{"$f":"IF(E3=\"\",\"\",\"CH3Br\")","v":""},{"$f":"IFERROR(VLOOKUP($B3,'Section 3'!$A$15:$G$24,COLUMNS('Section 3'!$A$15:D$15),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B3,'Section 3'!$A$15:$G$24,COLUMNS('Section 3'!$A$15:F$15),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B3,'Section 3'!$A$15:$G$24,COLUMNS('Section 3'!$A$15:G$15),0),\"\")","v":""}]
[{"$f":"IF(D4=\"\",\"\",ROWS($A$1:A4))","v":""},2,{"$f":"IF(D4=\"\",\"\",3)","v":""},{"$f":"IF(E4=\"\",\"\",\"CH3Br\")","v":""},{"$f":"IFERROR(VLOOKUP($B4,'Section 3'!$A$15:$G$24,COLUMNS('Section 3'!$A$15:D$15),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B4,'Section 3'!$A$15:$G$24,COLUMNS('Section 3'!$A$15:F$15),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B4,'Section 3'!$A$15:$G$24,COLUMNS('Section 3'!$A$15:G$15),0),\"\")","v":""}]
[{"$f":"IF(D5=\"\",\"\",ROWS($A$1:A5))","v":""},3,"","",{"$f":"IFERROR(VLOOKUP($B5,'Section 3'!$A$15:$G$24,COLUMNS('Section 3'!$A$15:D$15),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B5,'Section 3'!$A$15:$G$24,COLUMNS('Section 3'!$A$15:F$15),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B5,'Section 3'!$A$15:$G$24,COLUMNS('Section 3'!$A$15:G$15),0),\"\")","v":""}]
[{"$f":"IF(D6=\"\",\"\",ROWS($A$1:A6))","v":""},4,"","",{"$f":"IFERROR(VLOOKUP($B6,'Section 3'!$A$15:$G$24,COLUMNS('Section 3'!$A$15:D$15),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B6,'Section 3'!$A$15:$G$24,COLUMNS('Section 3'!$A$15:F$15),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B6,'Section 3'!$A$15:$G$24,COLUMNS('Section 3'!$A$15:G$15),0),\"\")","v":""}]
[{"$f":"IF(D7=\"\",\"\",ROWS($A$1:A7))","v":""},5,"","",{"$f":"IFERROR(VLOOKUP($B7,'Section 3'!$A$15:$G$24,COLUMNS('Section 3'!$A$15:D$15),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B7,'Section 3'!$A$15:$G$24,COLUMNS('Section 3'!$A$15:F$15),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B7,'Section 3'!$A$15:$G$24,COLUMNS('Section 3'!$A$15:G$15),0),\"\")","v":""}]
[{"$f":"IF(D8=\"\",\"\",ROWS($A$1:A8))","v":""},6,"","",{"$f":"IFERROR(VLOOKUP($B8,'Section 3'!$A$15:$G$24,COLUMNS('Section 3'!$A$15:D$15),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B8,'Section 3'!$A$15:$G$24,COLUMNS('Section 3'!$A$15:F$15),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B8,'Section 3'!$A$15:$G$24,COLUMNS('Section 3'!$A$15:G$15),0),\"\")","v":""}]
[{"$f":"IF(D9=\"\",\"\",ROWS($A$1:A9))","v":""},7,"","",{"$f":"IFERROR(VLOOKUP($B9,'Section 3'!$A$15:$G$24,COLUMNS('Section 3'!$A$15:D$15),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B9,'Section 3'!$A$15:$G$24,COLUMNS('Section 3'!$A$15:F$15),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B9,'Section 3'!$A$15:$G$24,COLUMNS('Section 3'!$A$15:G$15),0),\"\")","v":""}]
[{"$f":"IF(D10=\"\",\"\",ROWS($A$1:A10))","v":""},8,"","",{"$f":"IFERROR(VLOOKUP($B10,'Section 3'!$A$15:$G$24,COLUMNS('Section 3'!$A$15:D$15),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B10,'Section 3'!$A$15:$G$24,COLUMNS('Section 3'!$A$15:F$15),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B10,'Section 3'!$A$15:$G$24,COLUMNS('Section 3'!$A$15:G$15),0),\"\")","v":""}]
[{"$f":"IF(D11=\"\",\"\",ROWS($A$1:A11))","v":""},9,"","",{"$f":"IFERROR(VLOOKUP($B11,'Section 3'!$A$15:$G$24,COLUMNS('Section 3'!$A$15:D$15),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B11,'Section 3'!$A$15:$G$24,COLUMNS('Section 3'!$A$15:F$15),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B11,'Section 3'!$A$15:$G$24,COLUMNS('Section 3'!$A$15:G$15),0),\"\")","v":""}]
[{"$f":"IF(D12=\"\",\"\",ROWS($A$1:A12))","v":""},10,"","",{"$f":"IFERROR(VLOOKUP($B12,'Section 3'!$A$15:$G$24,COLUMNS('Section 3'!$A$15:D$15),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B12,'Section 3'!$A$15:$G$24,COLUMNS('Section 3'!$A$15:F$15),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B12,'Section 3'!$A$15:$G$24,COLUMNS('Section 3'!$A$15:G$15),0),\"\")","v":""}]
[{"$f":"IF(D13=\"\",\"\",ROWS($A$1:A13))","v":""},null,{"$f":"IF(D13=\"\",\"\",\"4a\")","v":""},{"$f":"IF(ISBLANK('Section 4'!D10),\"\",'Section 4'!D10)","v":""}]
[{"$f":"IF(D14=\"\",\"\",ROWS($A$1:A14))","v":""},1,{"$f":"IF(D14=\"\",\"\",\"4b\")","v":""},{"$f":"IFERROR(VLOOKUP($B14,'Section 4'!$A$15:$G$17,COLUMNS('Section 4'!$A$15:D$17),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B14,'Section 4'!$A$15:$G$17,COLUMNS('Section 4'!$A$15:F$17),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B14,'Section 4'!$A$15:$G$17,COLUMNS('Section 4'!$A$15:G$17),0),\"\")","v":""}]
[{"$f":"IF(D15=\"\",\"\",ROWS($A$1:A15))","v":""},2,{"$f":"IF(D15=\"\",\"\",\"4b\")","v":""},{"$f":"IFERROR(VLOOKUP($B15,'Section 4'!$A$15:$G$17,COLUMNS('Section 4'!$A$15:D$17),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B15,'Section 4'!$A$15:$G$17,COLUMNS('Section 4'!$A$15:F$17),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B15,'Section 4'!$A$15:$G$17,COLUMNS('Section 4'!$A$15:G$17),0),\"\")","v":""}]
[{"$f":"IF(D16=\"\",\"\",ROWS($A$1:A16))","v":""},3,{"$f":"IF(D16=\"\",\"\",\"4b\")","v":""},{"$f":"IFERROR(VLOOKUP($B16,'Section 4'!$A$15:$G$17,COLUMNS('Section 4'!$A$15:D$17),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B16,'Section 4'!$A$15:$G$17,COLUMNS('Section 4'!$A$15:F$17),0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP($B16,'Section 4'!$A$15:$G$17,COLUMNS('Section 4'!$A$15:G$17),0),\"\")","v":""}]
[null,"LastRow"]

{"sheet":"TempOutput","index":9,"n_rows":16,"n_cols":14,"rows_kept":16,"hidden":true}
["MaxRow",1,"PROD3","1","2017-08-22","Name","Original Submission",2017,1]
[{"$f":"IF(OR(B2=\"\",B2=0),\"\",ROWS($A$1:A2))","v":2},2,"CH3Br",0,0,3,4,0,0,0,0,6,7,20]
[{"$f":"IF(OR(B3=\"\",B3=0),\"\",ROWS($A$1:A3))","v":3},3,"CH3Br","A",5,"Global Lab"]
[{"$f":"IF(OR(B4=\"\",B4=0),\"\",ROWS($A$1:A4))","v":4},3,"CH3Br","Company A",8,"Emergency Use"]
[{"$f":"IF(OR(B5=\"\",B5=0),\"\",ROWS($A$1:A5))","v":5},3,"CH3Br","D",7,"Destruction"]
[{"$f":"IF(OR(B6=\"\",B6=0),\"\",ROWS($A$1:A6))","v":""}]
[{"$f":"IF(OR(B7=\"\",B7=0),\"\",ROWS($A$1:A7))","v":""}]
[{"$f":"IF(OR(B8=\"\",B8=0),\"\",ROWS($A$1:A8))","v":""}]
[{"$f":"IF(OR(B9=\"\",B9=0),\"\",ROWS($A$1:A9))","v":""}]
[{"$f":"IF(OR(B10=\"\",B10=0),\"\",ROWS($A$1:A10))","v":""}]
[{"$f":"IF(OR(B11=\"\",B11=0),\"\",ROWS($A$1:A11))","v":""}]
[{"$f":"IF(OR(B12=\"\",B12=0),\"\",ROWS($A$1:A12))","v":""}]
[{"$f":"IF(OR(B13=\"\",B13=0),\"\",ROWS($A$1:A13))","v":""}]
[{"$f":"IF(OR(B14=\"\",B14=0),\"\",ROWS($A$1:A14))","v":""}]
[{"$f":"IF(OR(B15=\"\",B15=0),\"\",ROWS($A$1:A15))","v":""}]
[{"$f":"IF(OR(B16=\"\",B16=0),\"\",ROWS($A$1:A16))","v":""}]