{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Annual recordkeeping","Summary and recycling credit","Guidance","HAP List"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":24,"comments":0,"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":29,"n_cols":14,"rows_kept":29,"cut":false,"hidden":false,"merged":[[10,1,11,13],[12,1,12,13],[13,2,13,13],[0,1,2,4],[0,5,0,13],[3,1,3,13],[9,1,9,13],[4,1,5,13],[8,1,8,13],[6,4,7,6],[6,8,7,9],[6,2,7,3],[6,7,7,7],[6,10,7,12],[19,1,20,13],[14,2,14,13],[15,2,15,13],[16,2,16,13],[17,2,17,13],[18,2,18,13],[25,2,25,3],[25,4,25,13],[26,1,26,2],[21,1,21,13],[22,1,22,13],[23,1,23,13],[24,2,24,3],[24,5,24,8]]}
[null,null,null,null,null,"VOC and HAP air emissions calculator\nfor conditionally exempt coating facility and auto body facility"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"p-sbap5-41 •  4/18/19"]
[]
[null,"Instructions"]
[null,"1) Use the blue 'Annual recordkeeping' tab across the bottom to complete the annual volatile organic compound (VOC) and hazardous air pollutant (HAP) total calculations required for facilities following the technical standard for conditionally exempt auto body or coating facilities or conditionally insignificant material usage."]
[]
[null,null,"Limit material usage",null,"Purchase or use less than 2,000 gallons per calendar year",null,null,"OR","Limit emissions to less than",null,"20,000 pounds VOC and 12,000 pounds HAPs per calendar year"]
[]
[null,"2) Use the blue 'Recycling credit' tab to take account for paint/solvent material from coating and cleaning activities that are sent off-site for recycling."]
[null,"3) The gray tabs provide supplemental information to help you find product details necessary for calculating actual emissions."]
[]
[]
[null,"Color key"]
[null,"Blue","Enter information for your facility in the blue boxes."]
[null,"White","Do not change the values/formulas in white boxes. White boxes contain intermediate calculations for determining emissions.  "]
[null,"Green","Your emission totals are in green boxes. These are automatically calculated based on information entered in blue boxes."]
[null,"Yellow","Permit and insignificant activity thresholds."]
[null,"Orange","Orange boxes are filled with standard values. You may change them if you have test results that provide data specific to your site."]
[null,"Blue Text","Important tips"]
[]
[]
[null,"Assistance"]
[null,"This calculator was created by the Minnesota Pollution Control Agency's (MPCA) Business Assistance program."]
[null,"We provide free, confidential, environmental assistance to small businesses. For more information:"]
[null,"Call:","651/282-6143",null,"Email:","smallbizhelp.pca@state.mn.us"]
[null,null,"800/657-3938"]
[]
[null,"Online at the MPCA's website:",null,null,null,"More information found on the MPCA's Conditionally exempt facilities and technical standards webpage: "]
[null,"https://www.pca.state.mn.us/smallbizhelp",null,null,null,"https://www.pca.state.mn.us/regulations/conditionally-exempt-facilities-and-technical-standards"]

{"sheet":"Annual recordkeeping","index":1,"n_rows":95,"n_cols":33,"rows_kept":95,"cut":false,"hidden":false,"merged":[[6,1,7,1],[6,2,7,3],[3,30,5,32],[6,30,7,30],[6,31,7,32],[6,4,7,6],[3,1,5,3],[6,7,7,8],[3,4,5,8],[3,10,5,12],[6,11,7,12],[6,10,7,10],[3,14,5,16],[6,14,7,14],[3,18,5,20],[6,18,7,18],[8,30,10,30],[8,31,10,31],[8,32,10,32],[11,1,12,1],[11,3,12,3],[11,2,12,2],[8,10,10,10],[8,11,10,11],[8,12,10,12],[8,18,10,18],[8,19,10,19],[8,20,10,20],[8,0,10,0],[8,1,10,1],[8,2,10,2],[8,3,10,3],[10,4,10,8],[8,4,9,4],[8,5,9,5],[8,6,9,6],[8,7,9,7],[8,8,9,8],[6,19,7,20],[6,15,7,16],[8,14,10,14],[8,15,10,15],[8,16,10,16],[3,22,5,24],[6,22,7,22],[6,23,7,24],[8,22,10,22],[8,23,10,23],[8,24,10,24],[3,26,5,28],[6,26,7,26],[6,27,7,28],[8,26,10,26],[8,27,10,27],[8,28,10,28]]}
[null,null,null,null,null,null,null,null,{"$f":"Instructions!N2","v":"p-sbap5-41 •  4/18/19"}]
["Annual recordkeeping"]
[]
[null,"Enter information in the rows below that will relate the product entry to its SDS and to help your business know which product is being referenced in business records. ",null,null,"For each product, choose one - enter the\n • density with %VOC and %HAP total (Option A), or\n • pound of pollutant per gallon of product (Option B)",null,null,null,null,null,"Enter the amount of each product that was purchased or used in gallons for each product. Enter the current calendar year."]
[]
[]
[null,"Facility name",null,null,"Option A",null,null,"Option B",null,null,2018,"Report totals are \nin the green boxes",null,null,2019,"Report totals are \nin the green boxes",null,null,2020,"Report totals are \nin the green boxes",null,null,2021,"Report totals are \nin the green boxes",null,null,2022,"Report totals are \nin the green boxes",null,null,2023,"Report totals are \nin the green boxes"]
[]
["Entry","Type of Product","Manufacturer & Product Name","In-house Name","Density","VOC","Total of all \nHAPs","VOC","Total of all \nHAPs",null,"Amount purchased or used","VOC emissions","HAP total emissions",null,"Amount purchased or used","VOC emissions","HAP total emissions",null,"Amount purchased or used","VOC emissions","HAP total emissions",null,"Amount purchased or used","VOC emissions","HAP total emissions",null,"Amount purchased or used","VOC emissions","HAP total emissions",null,"Amount purchased or used","VOC emissions","HAP total emissions"]
[]
[null,null,null,null,"If you are having a difficult time finding these on your SDS, see the Guidance tab for help."]
[null,"(Solvent, primer, etc.)","(on SDS)","(for your business)","from SDS","from SDS","from SDS","from SDS","from SDS",null,{"$f":"SUM(K16:K80)","v":0},{"$f":"SUM(L16:L80)","v":0},0,null,{"$f":"SUM(O16:O80)","v":0},{"$f":"SUM(P16:P80)","v":0},0,null,{"$f":"SUM(S16:S80)","v":0},{"$f":"SUM(T16:T80)","v":0},0,null,{"$f":"SUM(W16:W80)","v":0},{"$f":"SUM(X16:X80)","v":0},0,null,{"$f":"SUM(AA16:AA80)","v":0},{"$f":"SUM(AB16:AB80)","v":0},0,null,{"$f":"SUM(AE16:AE80)","v":0},{"$f":"SUM(AF16:AF80)","v":0},0]
["#",null,null,null,"(lb./gallon)","(% by weight)","(% by weight)","(lbVOC / gallonproduct)","(lbHAP / gallonproduct)",null,"(gallons/year)","(lbVOC/year)","(lbHAP/year)",null,"(gallons/year)","(lbVOC/year)","(lbHAP/year)",null,"(gallons/year)","(lbVOC/year)","(lbHAP/year)",null,"(gallons/year)","(lbVOC/year)","(lbHAP/year)",null,"(gallons/year)","(lbVOC/year)","(lbHAP/year)",null,"(gallons/year)","(lbVOC/year)","(lbHAP/year)"]
["Ex. A","Primer","SW - B72W8010","PR8010",8.5399999999999991,0.36499999999999999,5.1999999999999998E-2,null,null,null,520,{"$f":"IF(($E14*$F14*$K14)=0,($H14*$K14),($E14*$F14*$K14))","v":1620.8919999999998},{"$f":"IF(($E14*$G14*$K14)=0,($I14*$K14),($E14*$G14*$K14))","v":230.92159999999996}]
["Ex. B","Primer","SW - B72W8011","PR8011",null,null,null,{"$f":"E14*F14","v":3.1170999999999998},{"$f":"E14*G14","v":0.44407999999999992},null,240,748.10399999999993,106.57919999999999]
[1,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($E16*$F16*$K16)=0,($H16*$K16),($E16*$F16*$K16))","v":0},{"$f":"IF(($E16*$G16*$K16)=0,($I16*$K16),($E16*$G16*$K16))","v":0},null,null,{"$f":"IF(($E16*$F16*O16)=0,($H16*O16),($E16*$F16*O16))","v":0},{"$f":"IF(($E16*$G16*O16)=0,($I16*O16),($E16*$G16*O16))","v":0},null,null,{"$f":"IF(($E16*$F16*S16)=0,($H16*S16),($E16*$F16*S16))","v":0},{"$f":"IF(($E16*$G16*S16)=0,($I16*S16),($E16*$G16*S16))","v":0},null,null,{"$f":"IF(($E16*$F16*W16)=0,($H16*W16),($E16*$F16*W16))","v":0},{"$f":"IF(($E16*$G16*W16)=0,($I16*W16),($E16*$G16*W16))","v":0},null,null,{"$f":"IF(($E16*$F16*AA16)=0,($H16*AA16),($E16*$F16*AA16))","v":0},{"$f":"IF(($E16*$G16*AA16)=0,($I16*AA16),($E16*$G16*AA16))","v":0},null,null,{"$f":"IF(($E16*$F16*AE16)=0,($H16*AE16),($E16*$F16*AE16))","v":0},{"$f":"IF(($E16*$G16*AE16)=0,($I16*AE16),($E16*$G16*AE16))","v":0}]
[2,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($E17*$F17*$K17)=0,($H17*$K17),($E17*$F17*$K17))","v":0},{"$f":"IF(($E17*$G17*$K17)=0,($I17*$K17),($E17*$G17*$K17))","v":0},null,null,{"$f":"IF(($E17*$F17*O17)=0,($H17*O17),($E17*$F17*O17))","v":0},{"$f":"IF(($E17*$G17*O17)=0,($I17*O17),($E17*$G17*O17))","v":0},null,null,{"$f":"IF(($E17*$F17*S17)=0,($H17*S17),($E17*$F17*S17))","v":0},{"$f":"IF(($E17*$G17*S17)=0,($I17*S17),($E17*$G17*S17))","v":0},null,null,{"$f":"IF(($E17*$F17*W17)=0,($H17*W17),($E17*$F17*W17))","v":0},{"$f":"IF(($E17*$G17*W17)=0,($I17*W17),($E17*$G17*W17))","v":0},null,null,{"$f":"IF(($E17*$F17*AA17)=0,($H17*AA17),($E17*$F17*AA17))","v":0},{"$f":"IF(($E17*$G17*AA17)=0,($I17*AA17),($E17*$G17*AA17))","v":0},null,null,{"$f":"IF(($E17*$F17*AE17)=0,($H17*AE17),($E17*$F17*AE17))","v":0},{"$f":"IF(($E17*$G17*AE17)=0,($I17*AE17),($E17*$G17*AE17))","v":0}]
[3,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[4,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[5,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[6,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[7,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[8,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[9,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[10,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[11,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[12,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[13,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[14,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[15,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[16,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[17,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[18,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[19,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[20,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[21,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[22,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[23,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[24,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[25,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[26,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[27,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[28,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[29,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[30,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[31,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[32,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[33,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[34,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[35,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[36,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[37,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[38,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[39,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[40,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[41,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[42,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[43,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[44,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[45,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[46,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[47,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[48,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[49,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[50,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[51,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[52,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[53,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[54,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[55,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[56,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[57,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[58,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[59,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[60,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[61,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[62,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[63,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[64,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[65,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[66,null,null,null,null,null,null,null,null,null,null,0,0,null,null,{"$f":"IF(($E81*$F81*O81)=0,($H81*O81),($E81*$F81*O81))","v":0},{"$f":"IF(($E81*$G81*O81)=0,($I81*O81),($E81*$G81*O81))","v":0},null,null,{"$f":"IF(($E81*$F81*S81)=0,($H81*S81),($E81*$F81*S81))","v":0},{"$f":"IF(($E81*$G81*S81)=0,($I81*S81),($E81*$G81*S81))","v":0},null,null,{"$f":"IF(($E81*$F81*W81)=0,($H81*W81),($E81*$F81*W81))","v":0},{"$f":"IF(($E81*$G81*W81)=0,($I81*W81),($E81*$G81*W81))","v":0},null,null,{"$f":"IF(($E81*$F81*AA81)=0,($H81*AA81),($E81*$F81*AA81))","v":0},{"$f":"IF(($E81*$G81*AA81)=0,($I81*AA81),($E81*$G81*AA81))","v":0},null,null,{"$f":"IF(($E81*$F81*AE81)=0,($H81*AE81),($E81*$F81*AE81))","v":0},{"$f":"IF(($E81*$G81*AE81)=0,($I81*AE81),($E81*$G81*AE81))","v":0}]
[67,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(($E82*$F82*$K82)=0,($H82*$K82),($E82*$F82*$K82))","v":0},{"$f":"IF(($E82*$G82*$K82)=0,($I82*$K82),($E82*$G82*$K82))","v":0},null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[68,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[69,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[70,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[71,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[72,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[73,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[74,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[75,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[76,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[77,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[78,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[79,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]
[80,null,null,null,null,null,null,null,null,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0,null,null,0,0]

{"sheet":"Summary and recycling credit","index":2,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[[1,0,1,8],[15,0,15,8],[22,6,24,6],[4,7,4,8],[5,8,7,8],[21,7,21,8],[22,8,24,8],[22,1,24,1],[22,2,24,2],[22,3,24,3],[22,4,24,4],[22,5,24,5],[5,1,7,1],[22,7,24,7],[5,0,8,0],[22,0,25,0],[5,7,7,7],[5,2,7,2],[5,3,7,3],[5,4,7,4],[5,5,7,5],[5,6,7,6]]}
[null,null,null,null,null,null,null,null,{"$f":"Instructions!N2","v":"p-sbap5-41 •  4/18/19"}]
["Summary emissions and recycling credit option"]
[]
[]
["Actual annual emissions",null,null,null,null,null,null,"Comply with one"]
["Before recycling credit\nThese numbers are from the annual recordkeeping tab.",{"$f":"'Annual recordkeeping'!K7","v":2018},{"$f":"'Annual recordkeeping'!O7","v":2019},{"$f":"'Annual recordkeeping'!S7","v":2020},{"$f":"'Annual recordkeeping'!W7","v":2021},{"$f":"'Annual recordkeeping'!AA7","v":2022},{"$f":"G18","v":2023},"Below emission limits","Amount purchased or used"]
[]
[]
[null,"(lb/year)","(lb/year)","(lb/year)","(lb/year)","(lb/year)","(lb/year)","(lb/yr)","(gallons)"]
["VOC",{"$f":"'Annual recordkeeping'!L12:L12","v":0},{"$f":"'Annual recordkeeping'!P12","v":0},{"$f":"'Annual recordkeeping'!T12","v":0},{"$f":"'Annual recordkeeping'!X12","v":0},{"$f":"'Annual recordkeeping'!AB12","v":0},{"$f":"'Annual recordkeeping'!AF12","v":0},20000]
["HAP Total",{"$f":"'Annual recordkeeping'!M12","v":0},{"$f":"'Annual recordkeeping'!Q12","v":0},{"$f":"'Annual recordkeeping'!U12","v":0},{"$f":"'Annual recordkeeping'!Y12","v":0},{"$f":"'Annual recordkeeping'!AC12","v":0},{"$f":"'Annual recordkeeping'!AG12","v":0},12000]
["Total Gallons Used",{"$f":"'Annual recordkeeping'!K12","v":0},{"$f":"'Annual recordkeeping'!O12","v":0},{"$f":"'Annual recordkeeping'!S12","v":0},{"$f":"'Annual recordkeeping'!W12","v":0},{"$f":"'Annual recordkeeping'!AA12","v":0},{"$f":"'Annual recordkeeping'!AE12","v":0},null,2000]
[]
[]
["Paint and solvent recycling"]
["If your business ships waste material from coating and cleaning activities off-site for recycling, enter the quantity in the blue cell below."]
[]
[null,{"$f":"B6","v":2018},{"$f":"C6","v":2019},{"$f":"D6","v":2020},{"$f":"E6","v":2021},{"$f":"F6","v":2022},{"$f":"'Annual recordkeeping'!AE7","v":2023}]
["Total gallons paint/solvent recycled",0,0,0,0,0,0]
["Percent amount emitted (after recycling)",{"$f":"IFERROR(((B12-B19)/B12),0)","v":0},0,0,0,0,0]
[]
[null,null,null,null,null,null,null,"Comply with one"]
["With recycling credit\nThese numbers are your actual emissions which account for recycling paint/solvent waste.",{"$f":"B6","v":2018},2019,2020,2021,2022,2023,"Below emission limits","Amount purchased or used"]
[]
[]
[null,{"$f":"B9","v":"(lb/year)"},"(lb/year)","(lb/year)","(lb/year)","(lb/year)",{"$f":"G9","v":"(lb/year)"},"(lb/yr)","(gallons)"]
[{"$f":"A10","v":"VOC"},{"$f":"IF($B$20>0,B10*$B$20,0)","v":0},{"$f":"IF(C$20>0,C10*C$20,0)","v":0},0,0,0,0,20000]
[{"$f":"A11","v":"HAP Total"},{"$f":"IF($B$20>0,B11*$B$20,0)","v":0},0,0,0,0,0,12000]
["Total gallons used",{"$f":"B12-B19","v":0},0,0,0,0,0,null,2000]

{"sheet":"Guidance","index":3,"n_rows":61,"n_cols":23,"rows_kept":61,"cut":false,"hidden":false,"merged":[[52,15,52,23],[42,15,43,23],[44,18,44,20],[44,21,44,23],[44,15,44,17],[45,17,45,18],[45,20,45,21],[47,15,47,17],[47,18,47,20],[47,21,47,23],[49,15,49,23],[50,15,50,17],[50,18,50,20],[50,21,50,23],[1,26,1,28],[39,8,39,13],[42,2,42,4],[42,5,42,7],[42,8,42,10],[42,11,42,13],[27,1,27,3],[28,1,36,3],[26,4,26,7],[27,4,27,7],[28,4,36,7],[41,8,41,13],[28,8,30,11],[31,8,31,11],[36,10,36,11],[36,8,36,9],[20,1,20,11],[33,8,35,9],[14,2,14,13],[15,2,16,13],[17,2,18,13],[21,2,22,13],[26,1,26,3],[32,8,32,9],[26,8,26,11],[28,12,36,13],[1,19,1,25],[11,0,11,11],[12,1,12,11],[15,1,16,1],[17,1,18,1],[60,8,60,13],[26,12,26,13],[27,8,27,11],[32,10,32,11],[33,10,35,11],[52,8,57,13],[47,8,51,13],[43,8,45,13],[27,12,27,13],[40,8,40,13],[60,2,60,7],[49,2,49,4],[50,2,50,4],[51,2,51,4],[52,2,53,4],[58,2,59,7],[56,2,57,7],[55,2,55,7],[51,5,51,7],[52,5,53,7],[39,1,39,7],[48,2,48,7],[43,1,48,1],[41,2,41,7],[43,2,47,7],[50,1,61,1],[0,26,0,31],[0,19,0,25],[49,5,49,7],[50,5,50,7],[2,1,2,11],[3,1,3,11],[4,1,4,11],[6,1,8,1],[5,2,5,13],[6,2,8,13],[9,2,10,13],[1,0,1,13],[9,1,10,1],[25,1,25,8],[40,2,40,7]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Instructions!N2","v":"p-sbap5-41 •  4/18/19"}]
["Guidance for finding and entering product data"]
["1)","Obtain a copy of the Safety Data Sheet (SDS) for each VOC- and HAP-containing product used at your facility. "]
[null,"There are several types of data sheets and some do not have the information you need."]
[null,"The most useful data sheets are:"]
[null,null,"Description and contents"]
[null,"SDS or MSDS","Safety Data Sheets (SDS), formerly known as Material Safety Data Sheets (MSDS), are prepared as an informational document with physical and chemical properties of the product. They focus on safety and hazardous/toxic properties. An SDS contains the information needed for coating calculations and is often the most readily available data sheet because it is required by law."]
[]
[]
[null,"EDS","An Environmental Data Sheet lists environmental impacts of the product (air quality, water quality, and toxic wastes). An EDS is likely to contain the pollutant content and product data you need."]
[]
[]
[null,"These data sheets may also be available to you, but do not contain the information needed for emission calculations:"]
[]
[null,null,"Description and contents"]
[null,"PDS","Product Data Sheets give an in-depth description of coating characteristics and potential uses. A PDS may list VOC content but does not list the HAP content or all the information needed for coating calculations."]
[]
[null,"TDS","Technical Data Sheets are prepared with the applicator in mind and contain information on how to apply the product, how to dilute the product, and temperature requirements. The TDS does not contain the information needed for coating calculations. "]
[]
[]
[null,"Note: When an SDS is updated or reissued from the manufacturer, check whether the pollutant contents have changed. "]
[null,null,"If there are changes, create a new entry (a new row) for the product in the blue 'Actual Emissions' tab. Stop using the old entry row, but do not change or delete information in it. The 'old' data is used for annual calculations."]
[]
[]
[]
["2)","Product description"]
[null,"Entry",null,null,"Type of Product",null,null,null,"Manufacturer & Product Name",null,null,null,"In-house Name"]
[null,"#",null,null,"(Solvent, primer, etc.)",null,null,null,"(on SDS)",null,null,null,"(for your business)"]
[null,"This column counts the number of products you have. It will remain stationary as you scroll right on the sheet to enter HAPs or product use.\n\nIf you print the 'Actual Emissions' tab, the entry number will be on the left side of each printed page.",null,null,"Enter the \"type\" of product (such as solvent, color, paint, stain, etc.) or emission point (where the product is used).\n\nYou can customize the 'type' for your business.\n\nThis will allow you to group products by how they are used, where they are used, or what they are used for. \n\n",null,null,null,"Enter the product's manufacturer (or initials) and enter the product name or code from the SDS.",null,null,null,"Use the name or numbering system that your business identifies the product by: description, part number, SKU, sales code, color, etc."]
[]
[]
[null,null,null,null,null,null,null,null,"Example 1: "]
[null,null,null,null,null,null,null,null,"Sherwin Williams",null,"SW"]
[null,null,null,null,null,null,null,null," Interior Latex Primer White",null,"Int. White \n('Primer' listed in 'Type of Product' column)"]
[]
[]
[null,null,null,null,null,null,null,null,"Product Code",null,"B72W8010"]
[]
[]
["3)","Product information"]
[null,"Density","VOC",null,null,null,null,null,"HAP total "]
[null,"from SDS","from SDS",null,null,null,null,null,"from SDS"]
[null,"(lb/gallon)","(% by weight)",null,null,"(lb/gallon)",null,null,"(% by weight)",null,null,"(lb/gallon)",null,null,null,"Conversion Equations:"]
[null,"Density, listed in pounds/gallon, will be found in the Physical and Chemical Properties section of the SDS.","VOC content is usually listed in the Physical and Chemical Properties section of the SDS. VOC information can also be listed in sections such as Regulatory Information, Composition/Ingredient Information, or Other Information on the SDS. If VOC content is not listed, contact the manufacturer.",null,null,null,null,null,"HAPs will be in the composition/information on ingredients or similar section on the SDS. Not all compounds listed on the SDS chemical composition are HAPs. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Specific Gravity (no units)",null,null,"Density of Water (lb/gal)",null,null,"Density  (lb/gal)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,"x",null,8.34,"=",null,{"$f":"Q46*T46","v":0}]
[]
[null,null,null,null,null,null,null,null,"A full list of the HAPs and their CAS# is in the grey 'HAP list' tab. Use the 'HAP list' tab to find out if a compound is a HAP or not. In the 'HAP list' tab, you can use a search to type in part of the CAS# without hyphens (-) to see if the compound listed on the data sheet is a HAP.",null,null,null,null,null,null,"VOC from SDS (lb/gal)",null,null,"Density from SDS (lb/gal)",null,null,"VOC (% by weight)"]
[null,null,"Which VOC number to use?",null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,0,"→",null,{"$f":"Q49/T49","v":{"$error":"#DIV/0!"}}]
[null,null,"Use one of these",null,null,"Do NOT use"]
[null,"If density is not listed, use the specific gravity listed and multiply the number by 8.34 lb/gal. This will equal product density.","VOC percent-by-weight",null,null,"Do not use percent-by-volume",null,null,null,null,null,null,null,null,null,"VOC from SDS (gram/Liter)",null,null,"Density from SDS (lb/gal)",null,null,"VOC (% by weight)"]
[null,null,"VOC EPA Method 24",null,null,"Do not use volatile volume",null,null,null,null,null,null,null,null,null,null,0,null,null,0,"→",null,{"$f":"(Q52*0.00220462*3.78541)/T52","v":{"$error":"#DIV/0!"}}]
[null,null,"VOC less water and federally exempt solvents",null,null,"Do not use \"as applied\"",null,null,"(%) is the 'units' the HAP content needs to be entered in. The content provided on the SDS generally is provided in %. If the SDS gives a percent range of the HAP, enter the highest % provided. For example, if the HAP Xylene (CAS# 1330207) is listed as 5-7%, enter 7% for Xylene content."]
[]
[]
[null,null,"If VOC is in g/L: convert to %VOC"]
[null,null," (# gram/liter * 0.00220462 lb/gram * 3.78541 liter/gallon)  = VOC lb/gallon then divide by density (lb/gal) = %VOC"]
[]
[null,null,"If % solids-by-weight is given and not VOC, you can assume \n%VOC = 100 - %PM          or         %VOC = 100 - %PM - %water"]
[]
[null,null,"See conversion equations to the right.",null,null,null,null,null,"Enter the total percent of HAPs in each product."]

{"sheet":"HAP List","index":4,"n_rows":198,"n_cols":5,"rows_kept":198,"cut":false,"hidden":false,"merged":[[1,1,1,4],[2,1,5,4],[7,1,8,4]]}
[null,null,null,null,{"$f":"Instructions!N2","v":"p-sbap5-41 •  4/18/19"}]
[null,"Select \"Ctrl + F\" to search for HAPs"]
[null,"Press the \"Ctrl\" and \"F\" keys on your keyboard at the same time or click on 'Find' on the home tab. \nA search box will appear for you to type in part of a compound name or the CAS# without hyphens (-) to see if the compound listed on the data sheet is a HAP."]
[]
[]
[]
[null," "]
[null,"Note: Metal compounds and few other HAPs do not have a CAS#. \nThese are listed in the main HAP Name list and in the list on the right. "]
[]
[]
[null,"HAP Name ","CAS#",null,"Metals and HAPs without a CAS#"]
[null,"1,1 Dimethyl hydrazine",57147,null,"Antimony compounds"]
[null,"1,1,2,2,-Tetrachloroethane",79345,null,"Arsenic compounds (inorganic including arsine)"]
[null,"1,1,2-Trichloroethane",79005,null,"Beryllium compounds"]
[null,"1,2,4-Trichlorobenzene",120821,null,"Cadmium compounds"]
[null,"1,2-Dibromo-3-chloropropane",96128,null,"Chromium compounds"]
[null,"1,2-Diphenylhydrazine",122667,null,"Cobalt compounds"]
[null,"1,2-Epoxybutane",106887,null,"Coke oven emissions"]
[null,"1,2-Propylenimine (2-Methyl aziridine)",75558,null,"Cyanide compounds"]
[null,"1,3-Butadiene",106990,null,"Glycol ethers"]
[null,"1,3-Dichloropropene",542756,null,"Lead compounds"]
[null,"1,3-Propane sultone",1120714,null,"Manganese compounds"]
[null,"1,4-Dichlorobenzene (p)",106467,null,"Mercury compounds"]
[null,"1,4-Dioxane (1,4-Diethyleneoxide)",123911,null,"Mineral fibers"]
[null,"2,2,4-Trimethylpentane",540841,null,"Nickel compounds"]
[null,"2,3,7,8-Tetrachlorodibenzo-p-dioxin",1746016,null,"Polycyclic organic matter"]
[null,"2,4,5-Trichlorophenol",95954,null,"Radionuclides"]
[null,"2,4,6-Trichlorophenol",88062,null,"Selenium compounds"]
[null,"2,4-D, salts and esters",94757]
[null,"2,4-Dinitrophenol",51285]
[null,"2,4-Dinitrotoluene",121142]
[null,"2,4-Toluene diamine",95807]
[null,"2,4-Toluene diisocyanate",584849]
[null,"2-Acetylaminofluorene",53963]
[null,"2-Chloroacetophenone",532274]
[null,"2-Nitropropane",79469]
[null,"3,3-Dichlorobenzidene",91941]
[null,"3,3-Dimethoxybenzidine",119904]
[null,"3,3-Dimethyl benzidine",119937]
[null,"4,4-Methylene bis (2-chloroaniline)",101144]
[null,"4,4-Methylenedianiline",101779]
[null,"4,6-Dinitro-o-cresol, and salts",534521]
[null,"4-Aminobiphenyl",92671]
[null,"4-Nitrobiphenyl",92933]
[null,"4-Nitrophenol",100027]
[null,"Acetaldehyde",75070]
[null,"Acetamide",60355]
[null,"Acetonitrile",75058]
[null,"Acetophenone",98862]
[null,"Acrolein",107028]
[null,"Acrylamide",79061]
[null,"Acrylic Acid",79107]
[null,"Acrylonitrile",107131]
[null,"Allyl chloride",107051]
[null,"Aniline",62533]
[null,"Asbestos",1332214]
[null,"Benzene",71432]
[null,"Benzidine",92875]
[null,"Benzotrichloride",98077]
[null,"Benzyl chloride",100447]
[null,"beta-Propiolactone",57578]
[null,"Biphenyl",92524]
[null,"Bis (2-ethylhexyl) phthalate (DEHP)",117817]
[null,"Bis (chloromethyl) ether",542881]
[null,"Bromoform",75252]
[null,"Calcium cyanamide",156627]
[null,"Captan",133062]
[null,"Carbaryl",63252]
[null,"Carbon disulfide",75150]
[null,"Carbon tetrachloride",56235]
[null,"Carbonyl sulfide",463581]
[null,"Catechol",120809]
[null,"Chloramben",133904]
[null,"Chlordane",57749]
[null,"Chlorine",7782505]
[null,"Chloroacetic acid",79118]
[null,"Chlorobenzene",108907]
[null,"Chlorobenzilate",510156]
[null,"Chloroform",67663]
[null,"Chloromethyl methyl ether",107302]
[null,"Chloroprene",126998]
[null,"Cresols/Cresylic acid (isomers and mixtures)",1319773]
[null,"Cumene",98828]
[null,"DDE",3547044]
[null,"Diazomethane",334883]
[null,"Dibenzofurans",132649]
[null,"Dibutyl phthalate",84742]
[null,"Dichloroethyl ether (Bis (2-chloroethyl) ether)",111444]
[null,"Dichlorovos",62737]
[null,"Diethanolamine",111422]
[null,"Diethyl sulfate",64675]
[null,"Dimethyl aminoazobenzene",60117]
[null,"Dimethyl carbamoyl chloride",79447]
[null,"Dimethyl formamide",68122]
[null,"Dimethyl phthalate",131113]
[null,"Dimethyl sulfate",77781]
[null,"Epichlorohydrin (1-Chloro-2,3-epoxypropane)",106898]
[null,"Ethyl acrylate",140885]
[null,"Ethyl benzene",100414]
[null,"Ethyl carbamate (Urethane)",51796]
[null,"Ethyl chloride (Chloroethane)",75003]
[null,"Ethylene dibromide (Dibromoethane)",106934]
[null,"Ethylene dichloride (1,2-Dichloroethane)",107062]
[null,"Ethylene glycol",107211]
[null,"Ethylene imine (Aziridine)",151564]
[null,"Ethylene oxide",75218]
[null,"Ethylene thiourea",96457]
[null,"Ethylidene dichloride (1,1-Dichloroethane)",75343]
[null,"Formaldehyde",50000]
[null,"Heptachlor",76448]
[null,"Hexachlorobenzene",118741]
[null,"Hexachlorobutadiene",87683]
[null,"Hexachlorocyclopentadiene",77474]
[null,"Hexachloroethane",67721]
[null,"Hexamethylene-1,6-diisocyanate",822060]
[null,"Hexamethylphosphoramide",680319]
[null,"Hexane",110543]
[null,"Hydrazine",302012]
[null,"Hydrochloric acid",7647010]
[null,"Hydrogen fluoride (hydrofluoric acid)",7664393]
[null,"Hydroquinone",123319]
[null,"Isophorone",78591]
[null,"Lindane (all isomers)",58899]
[null,"Maleic anhydride",108316]
[null,"m-Cresol",108394]
[null,"Methanol",67561]
[null,"Methoxychlor",72435]
[null,"Methyl bromide (Bromomethane)",74839]
[null,"Methyl chloride (Chloromethane)",74873]
[null,"Methyl chloroform (1,1,1,-Trichloroethane)",71556]
[null,"Methyl hydrazine",60344]
[null,"Methyl iodide (Iodomethane)",74884]
[null,"Methyl isobutyl ketone (Hexone)",108101]
[null,"Methyl isocyanate",624839]
[null,"Methyl methacrylate",80626]
[null,"Methyl tert butyl ether",1634044]
[null,"Methylene chloride (Dichloromethane)",75092]
[null,"Methylene diphenyl diisocyanate (MDI)",101688]
[null,"m-Xylenes",108383]
[null,"N,N-Dimethylaniline",121697]
[null,"Naphthalene",91203]
[null,"Nitrobenzene",98953]
[null,"N-Nitrosodimethylamine",62759]
[null,"N-Nitrosomorpholine",59892]
[null,"N-Nitroso-N-methylurea",684935]
[null,"o-Anisidine",90040]
[null,"o-Cresol",95487]
[null,"o-Toluidine",95534]
[null,"o-Xylenes",95476]
[null,"Parathion",56382]
[null,"p-Cresol",106445]
[null,"Pentachloronitrobenzene (Quintobenzene)",82688]
[null,"Pentachlorophenol",87865]
[null,"Phenol",108952]
[null,"Phosgene",75445]
[null,"Phosphine",7803512]
[null,"Phosphorus",7723140]
[null,"Phthalic anhydride",85449]
[null,"Polychlorinated biphenyls (aroclors)",1336363]
[null,"p-Phenylenediamine",106503]
[null,"Propionaldehyde",123386]
[null,"Propoxur (Baygon)",114261]
[null,"Propylene dichloride (1,2-Dichloropropane)",78875]
[null,"Propylene oxide",75569]
[null,"p-Xylenes",106423]
[null,"Quinoline",91225]
[null,"Quinone",106514]
[null,"Styrene",100425]
[null,"Styrene oxide",96093]
[null,"Tetrachloroethylene (Perchloroethylene)",127184]
[null,"Titanium tetrachloride",7550450]
[null,"Toluene","108883"]
[null,"Toxaphene (chlorinated camphene)",8001352]
[null,"Trichloroethylene",79016]
[null,"Triethylamine",121448]
[null,"Trifluralin",1582098]
[null,"Vinyl acetate",108054]
[null,"Vinyl bromide",593602]
[null,"Vinyl chloride",75014]
[null,"Vinylidene chloride (1,1-Dichloroethylene)",75354]
[null,"Xylenes (isomers and mixtures)",1330207]
[null,"Antimony compounds","0"]
[null,"Arsenic compounds (inorganic including arsine)","0"]
[null,"Beryllium compounds","0"]
[null,"Cadmium compounds","0"]
[null,"Chromium compounds","0"]
[null,"Cobalt compounds","0"]
[null,"Coke oven emissions","0"]
[null,"Cyanide compounds","0"]
[null,"Glycol ethers","0"]
[null,"Lead compounds","0"]
[null,"Manganese compounds","0"]
[null,"Mercury compounds","0"]
[null,"Mineral fibers","0"]
[null,"Nickel compounds","0"]
[null,"Polycyclic organic matter","0"]
[null,"Radionuclides","0"]
[null,"Selenium compounds","0"]