{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Required Information","QAPP","A Section","B Section"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":0,"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":89,"n_cols":2,"rows_kept":89,"cut":false,"hidden":false,"merged":[[65,0,65,1],[69,0,69,1],[89,0,89,1],[4,0,8,6],[11,0,11,1],[17,0,17,1],[10,0,10,6],[14,0,14,6]]}
["Interim Site-Specific Quality Assurance Project Plan Template for Evaluating Asbestos-Containing Material and Lead-Based Paint in Building Materials"]
["EPA Region 4 Brownfields & Redevelopment Section"]
["Version 1: November 15, 2022"]
["Introduction:"]
["The EPA Region 4 Brownfields & Redevelopment Section is offering this Interim Streamlined Site-Specific Quality Assurance Project Plan (SSQAPP) Template for evaluating the presence of Asbestos-Containing Material (ACM) and Lead-Based Paint (LBP) in building materials. The use of this Interim SSQAPP Template has limitations, as described below: \n•\tThis Interim SSQAPP Template is intended for use in EPA Region 4 at sites undergoing assessment through an EPA Brownfields Grant.\n•\tThis Interim SSQAPP Template is intended for use where the sampling objective is to determine whether ACM and/or LBP are present in building materials.  \n•\tThis Interim SSQAPP Template is intended for use where a Generic QAPP is final and has been approved by EPA, as the Generic QAPP is referenced throughout this document.\n•\tThe final SSQAPP must be approved by EPA prior to sample collection. If any of the required information is not known in advance of mobilization for field sampling activities, please coordinate with the EPA Project Officer regarding the information that may need to be obtained upon mobilization and ensuring that final EPA approval will be obtained prior to sample collection.       "]
[]
[]
[]
[]
[]
["If this Interim SSQAPP Template does not align with a particular project, please submit a standard Site-Specific QAPP Addendum using the EPA Region 4 Brownfields QAPP guidance at: "]
["www.epa.gov/brownfields/region-4-quality-assurance-project-plan-qapp-tool-box"]
[]
["Comments and Revisions:"]
["The EPA Region 4 Brownfields & Redevelopment Section may revise this Interim SSQAPP Template based on comments and/or new information. Before using this Interim SSQAPP Template, please verify that it is the most recent version posted on the EPA Region 4 Brownfields QAPP Tool Box webpage at the link above. Users of this Interim SSQAPP Template are encouraged to provide comments and feedback for improvement. The EPA Region 4 Brownfields & Redevelopment Section is particularly interested in developing default language (where possible) that could be used where the template currently refers to the QAPP Checklist for data entry. Please provide comments and feedback to David Hayes and Freddie Wilson of the EPA Region 4 Brownfields & Redevelopment Section at: hayes.david@epa.gov and wilson.freddie@epa.gov    "]
[]
["Instructions:"]
["All data entry is conducted in the \"Required Information\" Sheet (data entry cells contain no fill color).  Based on the information entered in the \"Required Information\" Sheet, the Site-Specific QAPP is generated in the \"QAPP\" Sheet.  See the instructions below for particular data entry fields and for saving a PDF of the QAPP. "]
["Required Information","Instructions"]
["Constituents of Concern (COCs)","Check off one box for the COC for this QAPP by clicking the check box next to the contaminant name. If this QAPP involves both Asbestos and Lead-Based Paint, Check off \"Both\"."]
["EPA Brownfields Grant Number",{"$f":"_xlfn.CONCAT(\"Enter the \",A21,\" into Column C\")","v":"Enter the EPA Brownfields Grant Number into Column C"}]
["Site Name",{"$f":"_xlfn.CONCAT(\"Enter the \",A22,\" where sampling will be conducted into Column C\")","v":"Enter the Site Name where sampling will be conducted into Column C"}]
["Site Street Address",{"$f":"_xlfn.CONCAT(\"Enter the \",A23,\" into Column C (e.g., 123 Main Street)\")","v":"Enter the Site Street Address into Column C (e.g., 123 Main Street)"}]
["Site Address Line 2",{"$f":"_xlfn.CONCAT(\"Enter the \",A24,\" into Column C\")","v":"Enter the Site Address Line 2 into Column C"}]
["Site City","Enter the Site City into Column C"]
["Site State","Select the Site State from the drop-down list in Column C"]
["Site Zip code","Enter the Site Zip code into Column C"]
["ACRES ID",{"$f":"_xlfn.CONCAT(\"If there is an ACRES ID check off the box in Column D, then enter the \",A28,\" into Column C\")","v":"If there is an ACRES ID check off the box in Column D, then enter the ACRES ID into Column C"}]
["CAR Name",{"$f":"_xlfn.CONCAT(\"Enter the \",A29,\" into Column C\")","v":"Enter the CAR Name into Column C"}]
["CAR Address Line 1",{"$f":"_xlfn.CONCAT(\"Enter the \",A30,\" into Column C\")","v":"Enter the CAR Address Line 1 into Column C"}]
["CAR Address Line 2","Enter the CAR Address Line 2 into Column C"]
["CAR City","Enter the CAR City into Column C"]
["CAR State","Select the CAR State from the drop-down list in Column C"]
["CAR Zip Code","Enter the CAR Zip Code into Column C"]
["Contractor Project Number (optional)",{"$f":"_xlfn.CONCAT(\"Enter the \",A35,\" into Column C\")","v":"Enter the Contractor Project Number (optional) into Column C"}]
["Contractor Name",{"$f":"_xlfn.CONCAT(\"Enter the \",A36,\" into Column C\")","v":"Enter the Contractor Name into Column C"}]
["Contractor Address Line 1","Enter the Contractor Address Line 1 into Column C"]
["Contractor Address Line 2","Enter the Contractor Address Line 2 into Column C"]
["Contractor City","Enter the Contractor City into Column C"]
["Contractor State","Enter the Contractor State into Column C"]
["Contractor Zip Code","Enter the Contractor Zip Code into Column C"]
["CAR QAPP Approver","Enter the CAR QAPP Approver into Column C"]
["Contractor Project Manger","Enter the Contractor Project Manger into Column C"]
["Contractor QA/QC Officer","Enter the Contractor QA/QC Officer into Column C"]
["EPA Project Officer","Enter the EPA Project Officer into Column C"]
["Is Another Signature Required?","Check off if another signature for this QAPP is required by clicking the appropriate box in Column C"]
["Additional Signatory Organization and Title","Enter the Additional person's Organization and Title in Column C (i.e.: ADEM Brownfields Section Chief)"]
["Additional Signatory Name",{"$f":"_xlfn.CONCAT(\"Enter the \",A48,\" into Column C\")","v":"Enter the Additional Signatory Name into Column C"}]
["Is there an approved GQAPP?","Check off if there is a Generic QAPP by clicking the appropriate box in Column C"]
["Project Team Leader Name",{"$f":"_xlfn.CONCAT(\"Enter the \",A50,\" into Column C\")","v":"Enter the Project Team Leader Name into Column C"}]
["Project Team Leader Organization",{"$f":"_xlfn.CONCAT(\"Enter the \",A51,\" into Column C\")","v":"Enter the Project Team Leader Organization into Column C"}]
["EPA Project Officer/ Designated Approving Official (DAO)",{"$f":"_xlfn.CONCAT(\"Enter the \",A52,\" into Column C\")","v":"Enter the EPA Project Officer/ Designated Approving Official (DAO) into Column C"}]
["Are the asbestos and lead-based paint inspector/sampler the same person?",{"$f":"_xlfn.CONCAT(\"Enter the \",A53,\" into Column C\")","v":"Enter the Are the asbestos and lead-based paint inspector/sampler the same person? into Column C"}]
["Asbestos Sampler Name","Enter the Asbestos Sampler Name into Column C"]
["Asbestos Sampler Organization","Enter the Asbestos Sampler Organization into Column C"]
["Lead-Based Paint Sampler Name","Enter the Lead-Based Paint Sampler Name into Column C"]
["Lead-Based Paint Sampler Organization","Enter the Lead-Based Paint Sampler Organization into Column C"]
["A5 Background","Briefly describe the known history of the site. Stick to the facts only.  This section must describe what you are doing and why you are doing it. Some example, but incomplete, text is provided in red"]
["Field Study Start Date","Enter the Field Study Start Date into Column C. (i.e.: 12/12/2022)"]
["Project Lab Turnaround Time in Days","Enter the Project Lab Turnaround time into Column C (i.e.: 20 days)"]
["How long will it take for the final report to be completed in days from receiving final analytical results?","Enter how long will it take for the final report to be completed from receiving the final analytical results into Column C (i.e.: 20 days)"]
["If sampling for Lead-Based Paint is being conducted, describe the method(s) that will be used to analyze for lead (e.g., laboratory, hand-held XRF, or both):","Specify whether representative paint samples will be analyzed for lead using a laboratory method, a hand-held X-Ray Fluorescence (XRF) device, or XRF and laboratory methods, as described in the text in red. Replace the text in red with the appropriate information."]
["Section A7","Double click on the cell and enter the correct information where the text is in red"]
["State Asbestos Inspector Certification Number",{"$f":"_xlfn.CONCAT(\"Enter the \",A64,\" into Column C\")","v":"Enter the State Asbestos Inspector Certification Number into Column C"}]
["State Asbestos Inspector Certification Expiration Date",{"$f":"_xlfn.CONCAT(\"Enter the \",A65,\" into Column C (ie: 12/12/2022)\")","v":"Enter the State Asbestos Inspector Certification Expiration Date into Column C (ie: 12/12/2022)"}]
["Attach a copy of the certification at the end of the QAPP"]
["Does the State where the site is located require Lead-Based Paint Inspectors to be certified?","Check off if the lead-paint inspector is licensed or if your state requires a license by clicking the appropriate box in Column C"]
["State Lead-Based Paint Inspector Certification Number (not applicable for non-LBP sites)","Enter the Lead-Based Paint Inspector Certification number into Column C"]
["State Lead-Based Paint Inspector Certification Expiration Date (not applicable for non-LBP sites)","Enter the Lead-Based Paint Inspector Certification Expiration date into Column C (i.e.: 12/12/2022)"]
["Attach a copy of the certification at the end of the QAPP"]
["Other Trainings?","Enter other trainings into Column C"]
["Is the below statement correct?","Check off the appropriate answer in Column C"]
["Section B1","Enter the Constituent of Concern and Media to be sampled in Column B. Enter the Maximum Number of Samples into Column C. Enter the Analytical Method used into Column D.  Example text is provided in red."]
["Section B2","Check off the applicable SOPs/procedures by clicking the appropriate boxes in Columns B and C, then enter other SOPs/Procedures below (one per cell)."]
["Section B2: Describe your sample identification procedure","Double click on the cell and enter the correct information where the text is in red"]
["Section B3","See the in-cell instructions in red. Replace these instructions with the appropriate information."]
["Section B4","Double click on the cell and enter the correct information where the text is in red"]
["Section B5","Customize the information for Field Quality Control Requirements based on the type of sampling that will be conducted (e.g., bulk sampling for asbestos, paint chip sampling for lead, or both). Describe the field duplicate samples that will be collected and analyzed, as described in the text in red. Replace the instructions in red with the appropriate information."]
["Section B6","See the in-cell instructions in red. Replace these instructions with the appropriate information."]
["Section B7","Customize the data entry based on whether an XRF will be used. See the in-cell instructions in red. Replace these instructions with the appropriate information."]
["Section B8","See the in-cell instructions in red. Replace these instructions with the appropriate information."]
["Section B9","See the in-cell instructions in red. Replace these instructions with the appropriate information."]
["Section B10","See the in-cell instructions in red. Replace these instructions with the appropriate information."]
["Section C1","See the in-cell instructions in red. Replace these instructions with the appropriate information."]
["Section C2","See the in-cell instructions in red. Replace these instructions with the appropriate information."]
["Section D1","See the in-cell instructions in red. Replace these instructions with the appropriate information."]
["Section D2","See the in-cell instructions in red. Replace these instructions with the appropriate information."]
["Section D3","See the in-cell instructions in red. Replace these instructions with the appropriate information."]
["Printing / Saving a PDF of the QAPP\n\nBefore you print:  Make sure to select Print to PDF in the File menu. \n\nAfter ensuring Print to PDF has been selected and you have finished entering in all required information in the appropriate fields, click on the \"Save QAPP\" button at the bottom of the form and enter \"QAPP\" into the pop-up box to save a PDF of the QAPP."]

{"sheet":"Required Information","index":1,"n_rows":299,"n_cols":19,"rows_kept":299,"cut":false,"hidden":false,"merged":[[127,1,137,2],[145,1,176,2],[177,1,188,2],[189,1,192,2],[197,0,210,0],[189,0,192,0],[193,0,196,0],[145,0,176,0],[177,0,188,0],[127,0,137,0],[193,1,196,2],[197,1,210,2],[138,0,144,0],[0,0,40,0],[50,0,59,0],[52,1,52,3],[53,2,53,3],[56,1,56,3],[47,0,49,0],[47,1,47,3],[48,1,48,3],[49,1,49,3],[42,0,46,0],[46,2,46,3],[60,0,61,0],[61,1,61,3],[62,1,62,3],[99,0,111,0],[112,0,126,0],[72,1,72,2],[76,1,85,1],[76,2,85,2],[68,0,85,0],[112,1,112,2],[113,1,120,2],[62,0,67,0],[86,0,98,0],[86,1,98,2],[68,1,68,3],[99,1,111,2],[212,0,241,0],[280,1,297,2],[212,1,241,2],[138,1,144,2],[298,1,298,2],[280,0,297,0],[211,1,211,2]]}
[null,"Fill out the Required Information ",false,false,false,false,false,false,false,false,false,false,{"$f":"IF(C9=\"Florida\",\"Florida Department of Environmental Protection\",IF(C9=\"Kentucky\",\"Kentucky Department for Environmental Protection (KDEP)\",IF(C9=\"Tennessee\",\"Tennessee Department of Environment & Conservation (TDEC)\",IF(C9=\"South Carolina\",\"South Carolina Department of Health and Envrionmental Control (SCDHEC)\",IF(C9=\"North Carolina\",\"North Carolina Department of Environmental Quality (NCDEQ)\",IF(C9=\"Georgia\",\"Georgia Environmental Protection Division (GEPD)\",IF(C9=\"Mississippi\",\"Mississippi Department of Environmental Quality (MDEQ)\",IF(C9=\"Alabama\",\"Alabama Department of Environmental Management (ADEM)\",\"\"))))))))","v":""},"Due to a lack of previous analytical sampling or reconnaissance of the site by ",", field decisions will be made based on observations of building materials encountered, the linear feet of such materials, square feet of material, and/or general location. This sampling is limited to visible materials and will not involve invasive methods to penetrate walls or areas deemed inaccessible or unsafe, such as the roof. Sampling locations will be recorded in the field book and photographed as evidence following the rational presented in A7 (See A7) and documented in the final report submitted to "," and EPA","An inspection will be conducted of all accessible and safe interior and exterior areas of the subject facility to identify ACM by a State licensed asbestos inspector in accordance with the protocols established by the Environmental Protection Agency (EPA) and the ",".  Roofing samples will not be collected if safe access does not exist. Roofing materials will be visually inspected to determine whether presumed asbestos containing materials (PACM) are likely present. The "," Licensed Asbestos Inspector will use professional judgement and experience to determine whether roofing material should be considered PACM."]
[null,false,{"$f":"CONCATENATE(I2,M1,\".\",J2)","v":"The objective of this project is to provide exploratory data through inspection of all accessible and safe interior and exterior areas of the subject site to determine the presence or absence of ACM in accordance with the protocols established by the United States Environmental Protection Agency (U.S. EPA) and the .  Determining the presence or absence of ACM will determine the need for remediation to redevelop or safely reuse the site structure(s). Should ACM be found on site a more comprehensive assessment may be required to quantify the volume of materials present for disposal."},{"$f":"CONCATENATE(K2,M1,\".\",M2)","v":"The objective of this project is to provide exploratory data through inspection of all accessible and safe interior and exterior areas of the subject site to determine the presence or absence of LBP in accordance with the protocols established by the United States Environmental Protection Agency (U.S. EPA) and the .  Determining the presence or absence of LBP will determine the need for remediation to redevelop or safely reuse the site structure(s). Should LBP be found on site a more comprehensive assessment may be required to quantify the volume of materials present for disposal."},{"$f":"CONCATENATE(G2,M1,\". \",H2)","v":"The objective of this project is to provide exploratory data through inspection of all accessible and safe interior and exterior areas of the subject site to determine the presence or absence of ACM and LBP in accordance with the protocols established by the United States Environmental Protection Agency (U.S. EPA) and the . Determining the presence or absence of ACM and LBP will determine the need for remediation to redevelop or safely reuse the site structure(s). Should ACM and LBP be found on site a more comprehensive assessment may be required to quantify the volume of materials present for disposal."},"When LBP is present in a building, OSHA (29 CFR 1926.62), along with state regulations, require some form of controls to be followed during any construction work where an employee may be occupationally exposed to lead. The Department of Housing and Urban Development (HUD) Guidelines for the Evaluation and Control of Lead-Based Paint Hazards in Housing and the EPA Requirements for Lead-Based Paint Activities in Target and Child-Occupied Facilities (40 Code of Federal Regulation (CFR) Part 745) provide regulatory and industry guidelines for conducting lead-based paint sampling. Lead-Based Paint (LBP) means paint or other surface coatings that contain lead equal to or in excess of 1.0 milligram per square centimeter (mg/cm2), or 0.5 percent (0.5%) by weight or 5000 parts per million (ppm). OSHA has no lower threshold for exposure to lead.","The objective of this project is to provide exploratory data through inspection of all accessible and safe interior and exterior areas of the subject site to determine the presence or absence of ACM and LBP in accordance with the protocols established by the United States Environmental Protection Agency (U.S. EPA) and the ","Determining the presence or absence of ACM and LBP will determine the need for remediation to redevelop or safely reuse the site structure(s). Should ACM and LBP be found on site a more comprehensive assessment may be required to quantify the volume of materials present for disposal.","The objective of this project is to provide exploratory data through inspection of all accessible and safe interior and exterior areas of the subject site to determine the presence or absence of ACM in accordance with the protocols established by the United States Environmental Protection Agency (U.S. EPA) and the ","  Determining the presence or absence of ACM will determine the need for remediation to redevelop or safely reuse the site structure(s). Should ACM be found on site a more comprehensive assessment may be required to quantify the volume of materials present for disposal.","The objective of this project is to provide exploratory data through inspection of all accessible and safe interior and exterior areas of the subject site to determine the presence or absence of LBP in accordance with the protocols established by the United States Environmental Protection Agency (U.S. EPA) and the ",{"$f":"_xlfn.CONCAT(\"This assessment is being conducted to confirm the presence or absence of \",H3,\" in building materials to inform future use and/or remediation needs.  A figure depicting lines of authority and the organizational layout is included as Attachment A. Key personnel are detailed below.\")","v":"This assessment is being conducted to confirm the presence or absence of  in building materials to inform future use and/or remediation needs.  A figure depicting lines of authority and the organizational layout is included as Attachment A. Key personnel are detailed below."},"  Determining the presence or absence of LBP will determine the need for remediation to redevelop or safely reuse the site structure(s). Should LBP be found on site a more comprehensive assessment may be required to quantify the volume of materials present for disposal.",null,null," and EPA"]
[null,"Constituents of Concern (COCs)",null,null,null,null,"COC selection:",{"$f":"IF('Required Information'!C1=TRUE,\"Asbestos-Containing Material (ACM)\",IF('Required Information'!D1=TRUE,\"Lead-Based Paint (LBP)\",IF('Required Information'!E1=TRUE,\"Asbestos-Containing Material (ACM) and Lead-Based Paint (LBP)\",\"\")))","v":""}]
[null,"EPA Brownfields Grant Number"]
[null,"Site Name"]
[null,"Site Street Address"]
[null,"Site Address Line 2"]
[null,"Site City"]
[null,"Site State (select from drop-down list)",null,null,null,null,"Site State Selection:"]
[null,"Site Zip Code",null,null,null,null,"Alabama"]
[null,"ACRES ID",null,null,null,null,"Florida"]
[null,"Cooperative Agreement Recipient (CAR) Name",null,null,null,null,"Georgia"]
[null,"CAR Address Line 1",null,null,null,null,"Kentucky"]
[null,"CAR Address Line 2",null,null,null,null,"Mississippi"]
[null,"CAR City",null,null,null,null,"North Carolina"]
[null,"CAR State (select from drop-down list)",null,null,null,null,"South Carolina"]
[null,"CAR Zip Code",null,null,null,null,"Tennessee"]
[null,"Contractor Project Number (optional)"]
[null,"Contractor Name"]
[null,"Contractor Address Line 1"]
[null,"Contractor Address Line 2"]
[null,"Contractor City"]
[null,"Contractor State"]
[null,"Contractor Zip Code"]
[null,"CAR QAPP Approver"]
[null,"Contractor Project Manger"]
[null,"Contractor QA/QC Officer"]
[null,"EPA Project Officer"]
[null,"Is Another Signature Required?"]
[null,"Additional Signatory Organization and Title"]
[null,"Additional Signatory Name"]
[null,"Is there an approved GQAPP?"]
[]
[null,"Project Team Leader Name"]
[null,"Project Team Leader Organization"]
[null,"EPA Project Officer/ Designated Approving Official (DAO)"]
[null,"Are the asbestos and lead-based paint inspector/sampler the same person?"]
[null,"Asbestos Sampler Name"]
[null,"Asbestos Sampler Organization"]
[null,{"$f":"IF(D1=TRUE,\"Lead-Based Paint Sampler Name\",IF(E1=TRUE,\"Lead-Based Paint Sampler Name\",\"\"))","v":""}]
[null,{"$f":"IF(D1=TRUE,\"Lead-Based Paint Sampler Organization\",IF(E1=TRUE,\"Lead-Based Paint Sampler Organization\",\"\"))","v":""}]
["A5","Background:\nBriefly describe the known history of the site. Stick to the facts only.  This section must describe what you are doing and why you are doing it. Some example, but incomplete, text is provided. \n\nEx. The Site was first developed in 1935 as a municipal building and was subsequently sold to a private developer in 2009. The Site has been unoccupied since being acquired in 2009.  Due to the age of the structure and lack of documentation on previous assessments it is believed asbestos containing materials (ACM) and Lead-Based Paint (LBP)  may be present in the structure.\n\n","The Site was first developed in 1935 as a municipal building and was subsequently sold to a private developer in 2009. The Site has been unoccupied since being acquired in 2009.  Due to the age of the structure and lack of documentation on previous assessments it is believed Asbestos-Containing Material (ACM) and Lead-Based Paint (LBP) may be present in the structure."]
["A6","Field Study Start Date:"]
[null,"Project Lab Turnaround Time (number of days):"]
[null,"How long (number of days) will it take for the final report to be completed in days from receiving final analytical results?"]
[null,"Estimated Final Report Completion Date",{"$f":"C43+D46","v":"00:00:00"},{"$f":"C44+C45","v":0}]
[null,"If sampling for Lead-Based Paint is being conducted, describe the method(s) that will be used to analyze for lead (e.g., laboratory, hand-held XRF, or both):","The lead-based paint survey will be conducted of all accessible and safe interior and exterior areas of the subject facility. Representative bulk samples of homogeneous building materials will be sampled and analyzed for lead in paint as described in Section A7, B1, B2, and B4 of this Site-Specific QAPP.  <Specify whether representative paint samples will be analyzed for lead using a laboratory method, a hand-held X-Ray Fluorescence (XRF) device, or both XRF and laboratory methods.> "]
["A7","The purpose of this assessment for ACM and/or LBP is to determine the presence or absence of hazardous materials in common building materials found in older structures. If detections are found they will be screened against the applicable criteria for a determination of being considered ACM and/or LBP. "]
[null,"In planning for this field sampling event no site reconnaissance was completed due to budget constraints and baseline determinations for sampling have been made from user or owner provided information, aerials, age of the structure, and other publicly available information from the local tax assessor office (building permits, deed information, recorded square footage). The initial maximum sample size was determined based on the square feet of the structure at an estimated rate of one (1) per X sq ft of space for a total of XX (XX) samples.  This fits within the budgetary constraints of $x,xxxx in funding to complete the field sampling, analytical, equipment rental, and report preparation."]
[null,"Based on visual inspections of materials or other evidence that allows for classification of materials into homogeneous groupings, if any indications exist, the sampling plan will dictate collecting a minimum of one (1) sample from each classified material per x linear feet /x square feet per room. Variations in a material which cause the contractor to conclude it is not homogeneous will result in additional samples being collected. Before sampling the location will be noted on a sketch/map of the facility with appropriate measurements from permanent fixed points to allow for returning to the sampling location at a future time, along with a photograph of each location.  "]
["A8","State Asbestos Inspector Certification Number"]
[null,"State Asbestos Inspector Certification Expiration Date"]
[null,"Attach a copy of the certification at the end of the QAPP"]
[null,"Does the State where the site is located require Lead-Based Paint Inspectors to be certified?"]
[null,{"$f":"IF(L1=TRUE,\"State Lead-Based Paint Inspector Certification Number\",\"\")","v":""}]
[null,{"$f":"IF(L1=TRUE,\"State Lead-Based Paint Inspector Certification Expiration Date\",\"\")","v":""}]
[null,"Attach a copy of the certification at the end of the QAPP"]
[null,"Other Trainings?"]
[null,"Other Trainings?"]
[null,"Other Trainings?"]
["A9","Is the below statement correct? "]
[null,"In accordance with the Terms and Conditions the CAR will maintain all records and documents associated with the grant for a minimum of three years after the grant is financially and administratively closed. Additionally, any reports, field books, laboratory reports, chains-of-custody, or other relevant data/forms generated by the consultant and/or subcontractors will be maintained by the consultant for a minimum of the grant period of performance plus ninety days. All hardcopies and electronic data will be stored by the CAR and consultant in a manner that will prevent loss or theft in accordance with State Cybersecurity requirements and industry best practices."]
["B1","Complete the Chart below"]
[null,"Constituent of Concern and Media","Maximum Number of Samples","Analytical Method (for laboratory analysis of lead in paint, include the preparation method)"]
[null,"Example: Lead in Paint Chips","Example: 25","Example: EPA SW-846 3050B/7000B"]
[null,"Example: Asbestos in Bulk Building Materials","Example: 25","Example: Polarized Light Microscopy by EPA/600/R-93/116"]
[]
[]
["B2","Check the following SOPs/procedures you will be following"]
[]
[]
[]
[null,"Other SOPs/Procedures? Enter one per cell"]
[]
[]
[]
[null,"Describe your sample identification procedure:","Sample identification numbers will consist of the site initials (XX) followed by the building number (e.g., 1, 2, etc.) and “A” for asbestos and \"P\" for paint bulk samples, then consecutively numbered followed by a number representing the series of samples for a single homogeneous area."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["B3","Instructions for Data Entry: Refer to the QAPP Checklist. If the applicable information for this section is included in the Generic QAPP, enter “This information is included in the Generic QAPP.”  Otherwise, enter the applicable information for this section per the QAPP Checklist.    "]
[]
[]
[]
[]
[null,null,null,"The QAPP Checklist is available at: "]
[null,null,null,"https://www.epa.gov/sites/default/files/2020-07/documents/qapp_checklist_r4_0.pdf"]
[]
[]
[]
[]
[]
[]
["B4","Customize based on the type of sampling that will be conducted: A NVLAP laboratory will perform the analysis for asbestos in bulk samples and an NLLAP laboratory will perform the analysis of lead in paint chips. Once the samples are received and logged in at the laboratory, the samples will be analyzed by the analytical methods listed in B1.  The laboratory that will be conducting the analysis is (please insert the laboratory name).  Available laboratory information and extraction and digestion criteria are included in Laboratory QAM documents, included in the Appendix. The Laboratory (please insert the appropriate personnel) is responsible for overseeing the success of the analysis and for implementing corrective actions as detailed in Section C1."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["B5","Field Quality Control (Adapt as needed)"]
[null,"Instructions for Data Entry: Customize the information for Field Quality Control Requirements based on the type of sampling that will be conducted (e.g., bulk sampling for asbestos, paint sampling for lead, or both):\n\nBulk sampling for asbestos and paint chip sampling for lead is conducted using an object to essentially cut out or off a small amount of material for analysis. Quality control is limited to controls instituted in the field to reduce the risk of cross contamination. Precautions for reducing the chance of cross contamination for asbestos are listed in Section 1.6.2 of SESDGUID-104-R1, Procedural Precautions. Precautions for reducing the chance of cross contamination for lead paint are listed in Section 7 of ASTM E1729-16, Procedures. \n\nThe main objectives for both constituents are cleanliness of the sampling tool and adequate wetting of the material to reduce the risk of airborne exposure to the sampler or other unused sampling tools or equipment.\n\nInstructions for Data Entry: Describe the field duplicate samples that will be collected and analyzed.  For example: Asbestos samples analyzed via PLM will be accompanied by a field duplicate at a rate of one (1) per twenty (20) samples, with a minimum of one field duplicate per sampling event.  Paint screened with the XRF will have paint chip samples collected and sent for laboratory analysis at a rate of one (1) per twenty (20) readings made using the XRF to assess its accuracy in generating field data.\t\t\n\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["B6","Instructions for Data Entry: Describe the Laboratory Quality Control Requirements for the analysis that will be conducted. Determine the laboratory QC data to be routinely included with the laboratory's data package and provide a corresponding laboratory analytical QC table. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["B7","B7 is not applicable to the equipment/tools involved in the collection of bulk building materials for asbestos analysis or paint chips for lead analysis.\n\nInstructions for Data Entry:\nIf a portable XRF analyzer will be used, describe the calibration procedures that will be used.  For example:\nPortable XRF analyzer calibration will be performed routinely, in accordance with HUD guidance, as well as the XRF analyzer operations manual. At the start of each sampling day, an initial calibration will be performed that consists of screening a reference positive detection three times. This reference positive detection will be a National Institute of Standards and Technology (NIST) Standard Reference Material or Certified Reference Material with a nominal value as close as possible to 1.0 mg/cm2. The average of three readings collected using the reference positive detection must fall within 0.8 to 1.2 mg/cm2 for the XRF to be considered operational. In addition, the calibration will be repeated each time the XRF is powered on, or after each 4 hours of operation. A final calibration check will also be performed at the completion of sampling each day, utilizing the same calibration methodology. The results of all XRF calibration will be recorded in the field logbook."]
[]
[]
[]
[]
[]
[]
["B8","Instructions for Data Entry: Describe the Laboratory Equipment Calibration and Corrective Action for the analysis that will be conducted. If contained in laboratory SOPs, reference that appendix in this section. Otherwise, provide a laboratory equipment calibration table for each analytical method. Note the individuals responsible for these activities. "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["B9","Instructions for Data Entry: Use the appropriate language based on the sampling that will be conducted:\n\nFor asbestos analysis of bulk building material samples using Polarized Light Microscopy (PLM) or Transmission Electron Microscopy (TEM), the laboratory reporting limit for asbestos must be 1% or less. \n\nFor laboratory lead analysis of paint chip samples, the reporting limit for lead must be less than 0.5 percent (0.5%) by weight or 5000 parts per million (ppm).\n\nFor lead analysis of paint using a portable XRF analyzer, the reporting limit for lead must be less than 1.0 milligrams per square centimeter (mg/cm2)."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["B10","Instructions for Data Entry: Refer to the QAPP Checklist. If the applicable information for this section is included in the Generic QAPP, enter “This information is included in the Generic QAPP.”  Otherwise, enter the applicable information for this section per the QAPP Checklist.    ",null,"The QAPP Checklist is available at: "]
[null,null,null,"https://www.epa.gov/sites/default/files/2020-07/documents/qapp_checklist_r4_0.pdf"]
[]
[]
["C1","Instructions for Data Entry: Refer to the QAPP Checklist. If the applicable information for this section is included in the Generic QAPP, enter “This information is included in the Generic QAPP.”  Otherwise, enter the applicable information for this section per the QAPP Checklist.    ",null,"The QAPP Checklist is available at: "]
[null,null,null,"https://www.epa.gov/sites/default/files/2020-07/documents/qapp_checklist_r4_0.pdf"]
[]
[]
["C2","Instructions for Data Entry: Refer to the QAPP Checklist. If the applicable information for this section is included in the Generic QAPP, enter “This information is included in the Generic QAPP.”  Otherwise, enter the applicable information for this section per the QAPP Checklist.    "]
[]
[]
[]
[]
[null,null,null,"The QAPP Checklist is available at: "]
[null,null,null,"https://www.epa.gov/sites/default/files/2020-07/documents/qapp_checklist_r4_0.pdf"]
[]
[]
[]
[]
[]
[]
[]
["D1","Instructions for Data Entry: Refer to the QAPP Checklist. If the applicable information for this section is included in the Generic QAPP, enter “This information is included in the Generic QAPP.”  Otherwise, enter the applicable information for this section per the QAPP Checklist.    "]
["D2","Instructions for Data Entry: Refer to the QAPP Checklist for Section D2 Laboratory Data Evaluation. Enter the applicable information for this section per the QAPP Checklist.    "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"The QAPP Checklist is available at: "]
[null,null,null,"https://www.epa.gov/sites/default/files/2020-07/documents/qapp_checklist_r4_0.pdf"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["D3","Instructions for Data Entry: Refer to the QAPP Checklist for Section D3 Evaluating Data in Terms of User Needs. Enter the applicable information for this section per the QAPP Checklist.    "]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"The QAPP Checklist is available at: "]
[null,null,null,"https://www.epa.gov/sites/default/files/2020-07/documents/qapp_checklist_r4_0.pdf"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"**Be sure to read the Instructions detailed in the Instructions Tab before proceeding to save your QAPP**"]

{"sheet":"QAPP","index":2,"n_rows":298,"n_cols":9,"rows_kept":298,"cut":false,"hidden":false,"merged":[[4,1,4,8],[5,1,5,8],[1,1,3,8],[187,1,215,10],[216,0,227,0],[216,1,227,10],[229,0,252,0],[64,0,70,0],[64,1,70,8],[71,0,71,8],[72,1,74,8],[97,0,103,0],[104,0,124,0],[80,0,82,0],[83,0,96,0],[75,6,75,8],[76,6,76,8],[77,6,77,8],[78,6,78,8],[79,6,79,8],[58,0,63,0],[58,1,59,3],[58,4,59,6],[60,1,61,3],[75,4,75,5],[76,4,76,5],[77,4,77,5],[78,4,78,5],[79,4,79,5],[75,1,75,3],[76,1,76,3],[77,1,77,3],[78,1,78,3],[79,1,79,3],[62,7,63,8],[52,1,52,8],[53,1,53,8],[54,1,54,8],[55,1,55,8],[56,1,56,8],[57,1,57,8],[52,0,57,0],[60,4,61,6],[62,1,63,3],[62,4,63,6],[50,1,50,8],[51,1,51,8],[41,1,41,8],[42,1,42,8],[43,1,46,8],[41,0,46,0],[47,0,48,0],[47,1,47,8],[48,1,48,8],[49,1,49,8],[35,0,40,0],[39,1,39,8],[37,1,37,8],[38,1,38,8],[34,5,34,8],[34,0,34,1],[34,2,34,4],[35,1,35,8],[36,1,36,8],[32,5,32,8],[32,0,32,1],[32,2,32,4],[33,5,33,8],[33,0,33,1],[33,2,33,4],[30,0,30,1],[30,2,30,4],[30,5,30,8],[31,5,31,8],[31,0,31,1],[31,2,31,4],[15,4,15,8],[16,4,16,8],[17,4,17,8],[18,4,18,8],[19,4,19,8],[15,1,15,3],[16,1,16,3],[17,1,17,3],[18,1,18,3],[19,1,19,3],[297,0,312,0],[6,1,6,8],[0,1,0,8],[12,1,12,8],[72,0,79,0],[28,1,29,8],[11,1,11,4],[11,5,11,8],[13,1,13,8],[14,1,14,3],[14,4,14,8],[7,1,7,4],[8,1,8,4],[9,1,9,4],[10,1,10,4],[7,5,7,8],[8,5,8,8],[9,5,9,8],[10,5,10,8],[20,0,21,0],[20,1,21,8],[23,0,24,0],[23,1,24,8],[28,0,29,0],[1,0,19,0],[82,1,82,10],[81,1,81,10],[80,1,80,10],[228,0,228,10],[229,1,252,10],[297,1,312,10],[253,1,296,10],[186,0,186,10],[169,1,185,10],[163,1,168,10],[136,1,162,10],[129,1,135,10],[125,1,128,10],[104,1,124,10],[97,1,103,10],[83,1,96,10],[125,0,128,0],[169,0,185,0],[187,0,215,0],[129,0,135,0],[136,0,162,0],[163,0,168,0],[253,0,296,0]]}
[null,"SECTION A: Project Management"]
["A1: Title and Approval",{"$f":"IF('Required Information'!C1=TRUE,\"Site-Specific Quality Assurance Project Plan Addendum for Evaluating Asbestos-Containing Material in Building Materials\",IF('Required Information'!D1=TRUE,\"Site-Specific Quality Assurance Project Plan Addendum for Evaluating Lead-Based Paint in Building Materials\",IF('Required Information'!E1=TRUE,\"Site-Specific Quality Assurance Project Plan Addendum for Evaluating Asbestos-Containing Material and Lead-Based Paint in Building Materials\",\"\")))","v":""}]
[]
[]
[null,"Subject Site:"]
[null,{"$f":"'Required Information'!C5","v":0}]
[null,{"$f":"_xlfn.CONCAT('Required Information'!C6,\", \",'Required Information'!C8,\", \", 'Required Information'!C9)","v":", , "}]
[null,{"$f":"_xlfn.CONCAT(\"Prepared For: \",'Required Information'!C12)","v":"Prepared For: "},null,null,null,{"$f":"_xlfn.CONCAT(\"Prepared By: \",'Required Information'!C19)","v":"Prepared By: "}]
[null,{"$f":"IF('Required Information'!C13=\"\",\"\",'Required Information'!C13)","v":""},null,null,null,{"$f":"IF('Required Information'!C20=\"\",\"\",'Required Information'!C20)","v":""}]
[null,{"$f":"IF('Required Information'!C14=\"\",\"\",'Required Information'!C14)","v":""},null,null,null,{"$f":"IF('Required Information'!C21=\"\",\"\",'Required Information'!C21)","v":""}]
[null,{"$f":"_xlfn.CONCAT('Required Information'!C15,\", \",'Required Information'!C16,\" \",'Required Information'!C17)","v":",  "},null,null,null,{"$f":"_xlfn.CONCAT('Required Information'!C22,\", \",'Required Information'!C23,\" \",'Required Information'!C24)","v":",  "}]
[null,{"$f":"_xlfn.CONCAT(\"EPA Brownfields Grant Number: \",'Required Information'!C4)","v":"EPA Brownfields Grant Number: "},null,null,null,{"$f":"_xlfn.CONCAT(\"Contractor Project Number: \",'Required Information'!C18)","v":"Contractor Project Number: "}]
[null,{"$f":"IF('Required Information'!B2=FALSE,\"\",_xlfn.CONCAT(\"ACRES ID: \",'Required Information'!C11))","v":""}]
[null,{"$f":"TODAY()","v":"2025-05-20"}]
[null,"Approver Organization/Name",null,null,"Signature/Date"]
[null,{"$f":"_xlfn.CONCAT(\"Cooperative Agreement Recipient (CAR) Approver: \",'Required Information'!C25)","v":"Cooperative Agreement Recipient (CAR) Approver: "}]
[null,{"$f":"_xlfn.CONCAT('Required Information'!C19,\" Project Manager: \",'Required Information'!C26)","v":" Project Manager: "}]
[null,{"$f":"_xlfn.CONCAT('Required Information'!C19,\" Technical Director; QA/QC: \",'Required Information'!C27)","v":" Technical Director; QA/QC: "}]
[null,{"$f":"_xlfn.CONCAT('Required Information'!B28,\"/Designated Approving Official: \",'Required Information'!C28)","v":"EPA Project Officer/Designated Approving Official: "}]
[null,{"$f":"_xlfn.CONCAT('Required Information'!C30,\": \",'Required Information'!C31)","v":": "}]
["A2: Table of Contents","Not applicable based on QAPP format. "]
[]
[]
["A3: Distribution List","See Section A1."]
[]
[]
[]
[]
["A4: Project/ Task Organization",{"$f":"CONCATENATE('Required Information'!C12,\" selected \",'Required Information'!C19,\" as their Qualified Environmental Professional (QEP) to conduct and/or oversee assessment work at the \",'Required Information'!C5,\". \", 'Required Information'!L2)","v":" selected  as their Qualified Environmental Professional (QEP) to conduct and/or oversee assessment work at the . This assessment is being conducted to confirm the presence or absence of  in building materials to inform future use and/or remediation needs.  A figure depicting lines of authority and the organizational layout is included as Attachment A. Key personnel are detailed below."}]
[]
["Project Personnel ",null,"Organization",null,null,"Responsibilities"]
[{"$f":"'Required Information'!C34","v":0},null,{"$f":"'Required Information'!C35","v":0},null,null,"Project Team Leader: The primary decision maker for the assessment activities and interpretation of sampling results."]
[{"$f":"'Required Information'!C38","v":0},null,{"$f":"'Required Information'!C39","v":0},null,null,"Licensed Asbestos Sampler/Inspector: This individual will be responsible for conducting the asbestos sampling and making the on-site determination of sampling location and materials to be samples based on a visual determination. "]
[{"$f":"'Required Information'!C40","v":0},null,{"$f":"'Required Information'!C41","v":0},null,null,"Lead-Based Paint Sampler/Inspector: This individual will be responsible for conducting the lead-based paint sampling and making the on-site determination of sampling location and materials to be sampled based on a visual determination."]
[{"$f":"'Required Information'!C36","v":0},null,"EPA",null,null,"The EPA Project Officer (PO) has the responsibility to oversee and monitor the grant. The EPA PO must ensure the activities conducted by the cooperative agreement recipient (CAR) are consistent with those described in the work plan. The DAOs role is to provide technical reviews of the QAPPs."]
["A5: Problem Definition/ Background",{"$f":"'Required Information'!C42","v":"The Site was first developed in 1935 as a municipal building and was subsequently sold to a private developer in 2009. The Site has been unoccupied since being acquired in 2009.  Due to the age of the structure and lack of documentation on previous assessments it is believed Asbestos-Containing Material (ACM) and Lead-Based Paint (LBP) may be present in the structure."}]
[null,{"$f":"CONCATENATE('Required Information'!N1,'Required Information'!C19,'Required Information'!O1,'Required Information'!C12,'Required Information'!P2,\".\")","v":"Due to a lack of previous analytical sampling or reconnaissance of the site by , field decisions will be made based on observations of building materials encountered, the linear feet of such materials, square feet of material, and/or general location. This sampling is limited to visible materials and will not involve invasive methods to penetrate walls or areas deemed inaccessible or unsafe, such as the roof. Sampling locations will be recorded in the field book and photographed as evidence following the rational presented in A7 (See A7) and documented in the final report submitted to  and EPA."}]
[null,{"$f":"IF('Required Information'!C1=TRUE,'Required Information'!C2,\"\")","v":""}]
[null,{"$f":"IF('Required Information'!D1=TRUE,'Required Information'!D2,\"\")","v":""}]
[null,{"$f":"IF('Required Information'!E1=TRUE,'Required Information'!E2,\"\")","v":""}]
[]
["A6: Project/Task Description",{"$f":"IF((OR('Required Information'!E1=TRUE,'Required Information'!C1=TRUE)),'A Section'!C10,\"\")","v":""}]
[null,{"$f":"IF((OR('Required Information'!E1=TRUE,'Required Information'!C1=TRUE)),'A Section'!C12,\"\")","v":""}]
[null,{"$f":"IF((OR('Required Information'!E1=TRUE,'Required Information'!D1=TRUE)),'A Section'!C13,\"\")","v":""}]
[null,{"$f":"IF((OR('Required Information'!E3=TRUE,'Required Information'!C3=TRUE)),'A Section'!C14,\"\")","v":""}]
[null,{"$f":"IF((OR('Required Information'!E4=TRUE,'Required Information'!C4=TRUE)),'A Section'!C15,\"\")","v":""}]
[null,{"$f":"IF((OR('Required Information'!E5=TRUE,'Required Information'!C5=TRUE)),'A Section'!C16,\"\")","v":""}]
["Applicable Regulatory Information and Action Levels:",{"$f":"IF((OR('Required Information'!E1=TRUE,'Required Information'!C1=TRUE)),\"Analytical results for suspect ACM samples will be compared to the ACM definition provided in 29 Code of Federal Regulations (CFR) 1910.1001(b) and 40 CFR 61.141: any material containing more than 1% asbestos.\",\"\")","v":""}]
[null,{"$f":"IF((OR('Required Information'!D1=TRUE, 'Required Information'!E1=TRUE)),'Required Information'!F2,\"\")","v":""}]
["Field Study Start Date:",{"$f":"'Required Information'!C43","v":"00:00:00"}]
["Projected Lab\nCompletion Date:",{"$f":"_xlfn.CONCAT(\"The final Laboratory analytical report will be issued within \",'Required Information'!C44,\" \",'A Section'!C9,\"\")","v":"The final Laboratory analytical report will be issued within  days of sample receipt. "}]
["Final Report Completion Date:",{"$f":"_xlfn.CONCAT(\"A final report will be issued by the QEP for the site within \", 'Required Information'!C45, \" days of receiving the final laboratory report.  The final report will be submitted for review by the CAR and EPA on or before \", TEXT('Required Information'!C46,\"mm/dd/yyyy\"), \".\")","v":"A final report will be issued by the QEP for the site within  days of receiving the final laboratory report.  The final report will be submitted for review by the CAR and EPA on or before 01/00/1900."}]
["A7: Quality Objective Criteria for Measurement Data",{"$f":"'Required Information'!B48","v":"The purpose of this assessment for ACM and/or LBP is to determine the presence or absence of hazardous materials in common building materials found in older structures. If detections are found they will be screened against the applicable criteria for a determination of being considered ACM and/or LBP. "}]
[null,{"$f":"'Required Information'!B49","v":"In planning for this field sampling event no site reconnaissance was completed due to budget constraints and baseline determinations for sampling have been made from user or owner provided information, aerials, age of the structure, and other publicly available information from the local tax assessor office (building permits, deed information, recorded square footage). The initial maximum sample size was determined based on the square feet of the structure at an estimated rate of one (1) per X sq ft of space for a total of XX (XX) samples.  This fits within the budgetary constraints of $x,xxxx in funding to complete the field sampling, analytical, equipment rental, and report preparation."}]
[null,{"$f":"IF('Required Information'!C1=TRUE,'A Section'!C14,\"\")","v":""}]
[null,{"$f":"IF('Required Information'!D1=TRUE,'A Section'!C15,\"\")","v":""}]
[null,{"$f":"IF('Required Information'!E1=TRUE,'A Section'!C16,\"\")","v":""}]
[null,{"$f":"'Required Information'!B50","v":"Based on visual inspections of materials or other evidence that allows for classification of materials into homogeneous groupings, if any indications exist, the sampling plan will dictate collecting a minimum of one (1) sample from each classified material per x linear feet /x square feet per room. Variations in a material which cause the contractor to conclude it is not homogeneous will result in additional samples being collected. Before sampling the location will be noted on a sketch/map of the facility with appropriate measurements from permanent fixed points to allow for returning to the sampling location at a future time, along with a photograph of each location.  "}]
["A8: Special Training / Certification","OSHA 40-hr HAZWOPER Training (all field personnel)",null,null,"State Issued Asbestos Inspector License (Certification attached)",null,null,"Lic. No.",{"$f":"'Required Information'!C51","v":0}]
[null,null,null,null,null,null,null,"Exp. Date ",{"$f":"'Required Information'!C52","v":"00:00:00"}]
[null,"OSHA 8-hr HAZWOPER Annual Refresher Training (all field personnel)",null,null,"State Issued Lead-Paint Inspector License (Certification attached)",null,null,"Lic. No.",{"$f":"'Required Information'!C55","v":0}]
[null,null,null,null,null,null,null,"Exp. Date",{"$f":"'Required Information'!C56","v":"00:00:00"}]
[null,{"$f":"'Required Information'!C58","v":0},null,null,{"$f":"'Required Information'!C59","v":0},null,null,{"$f":"'Required Information'!C60","v":0}]
[]
["A9: Documentation and Records",{"$f":"'Required Information'!B62","v":"In accordance with the Terms and Conditions the CAR will maintain all records and documents associated with the grant for a minimum of three years after the grant is financially and administratively closed. Additionally, any reports, field books, laboratory reports, chains-of-custody, or other relevant data/forms generated by the consultant and/or subcontractors will be maintained by the consultant for a minimum of the grant period of performance plus ninety days. All hardcopies and electronic data will be stored by the CAR and consultant in a manner that will prevent loss or theft in accordance with State Cybersecurity requirements and industry best practices."}]
[]
[]
[]
[]
[]
[]
["SECTION B: MEASRUEMENT DATA ACQUISITION"]
["B1: Sampling Process Design and Site Figures","The sampling design was chosen based on the data quality objectives of the study and the needs identified by the CAR. A site figure is attached. "]
[]
[]
[null,{"$f":"'Required Information'!B64","v":"Constituent of Concern and Media"},null,null,{"$f":"'Required Information'!C64","v":"Maximum Number of Samples"},null,{"$f":"'Required Information'!D64","v":"Analytical Method (for laboratory analysis of lead in paint, include the preparation method)"}]
[null,{"$f":"'Required Information'!B65","v":"Example: Lead in Paint Chips"},null,null,{"$f":"'Required Information'!C65","v":"Example: 25"},null,{"$f":"'Required Information'!D65","v":"Example: EPA SW-846 3050B/7000B"}]
[null,{"$f":"'Required Information'!B66","v":"Example: Asbestos in Bulk Building Materials"},null,null,{"$f":"'Required Information'!C66","v":"Example: 25"},null,{"$f":"'Required Information'!D66","v":"Example: Polarized Light Microscopy by EPA/600/R-93/116"}]
[null,{"$f":"'Required Information'!B67","v":0},null,null,{"$f":"'Required Information'!C67","v":0},null,{"$f":"'Required Information'!D67","v":0}]
[null,{"$f":"'Required Information'!B68","v":0},null,null,{"$f":"'Required Information'!C68","v":0},null,{"$f":"'Required Information'!D68","v":0}]
["B2: Sampling and Analytical Procedures","The following field measurement and sampling procedures will be followed during this field study, as applicable:"]
[null,{"$f":"_xlfn.CONCAT('B Section'!B2,\", \",'B Section'!B3,\", \",'B Section'!B4,\", \", 'B Section'!B5,\", \",'B Section'!B6,\", \",'B Section'!B7,\", \",'Required Information'!$B$74,\", \",'Required Information'!$B$75,\", \",'Required Information'!$B$76,\", \",'Required Information'!$C$74,\", \",'Required Information'!$C$75,\", \",'Required Information'!$C$76)","v":", , , , , , , , , , , "}]
[null,{"$f":"'Required Information'!C77","v":"Sample identification numbers will consist of the site initials (XX) followed by the building number (e.g., 1, 2, etc.) and “A” for asbestos and \"P\" for paint bulk samples, then consecutively numbered followed by a number representing the series of samples for a single homogeneous area."}]
["B3: Sample Handling & Custody ",{"$f":"'Required Information'!B87","v":"Instructions for Data Entry: Refer to the QAPP Checklist. If the applicable information for this section is included in the Generic QAPP, enter “This information is included in the Generic QAPP.”  Otherwise, enter the applicable information for this section per the QAPP Checklist.    "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["B4: Analytical Methods and Requirements",{"$f":"'Required Information'!B100","v":"Customize based on the type of sampling that will be conducted: A NVLAP laboratory will perform the analysis for asbestos in bulk samples and an NLLAP laboratory will perform the analysis of lead in paint chips. Once the samples are received and logged in at the laboratory, the samples will be analyzed by the analytical methods listed in B1.  The laboratory that will be conducting the analysis is (please insert the laboratory name).  Available laboratory information and extraction and digestion criteria are included in Laboratory QAM documents, included in the Appendix. The Laboratory (please insert the appropriate personnel) is responsible for overseeing the success of the analysis and for implementing corrective actions as detailed in Section C1."}]
[]
[]
[]
[]
[]
[]
["B5: Field Quality Control Requirements",{"$f":"'Required Information'!B114","v":"Instructions for Data Entry: Customize the information for Field Quality Control Requirements based on the type of sampling that will be conducted (e.g., bulk sampling for asbestos, paint sampling for lead, or both):\n\nBulk sampling for asbestos and paint chip sampling for lead is conducted using an object to essentially cut out or off a small amount of material for analysis. Quality control is limited to controls instituted in the field to reduce the risk of cross contamination. Precautions for reducing the chance of cross contamination for asbestos are listed in Section 1.6.2 of SESDGUID-104-R1, Procedural Precautions. Precautions for reducing the chance of cross contamination for lead paint are listed in Section 7 of ASTM E1729-16, Procedures. \n\nThe main objectives for both constituents are cleanliness of the sampling tool and adequate wetting of the material to reduce the risk of airborne exposure to the sampler or other unused sampling tools or equipment.\n\nInstructions for Data Entry: Describe the field duplicate samples that will be collected and analyzed.  For example: Asbestos samples analyzed via PLM will be accompanied by a field duplicate at a rate of one (1) per twenty (20) samples, with a minimum of one field duplicate per sampling event.  Paint screened with the XRF will have paint chip samples collected and sent for laboratory analysis at a rate of one (1) per twenty (20) readings made using the XRF to assess its accuracy in generating field data.\t\t\n\n"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["B6: Laboratory Quality Control Requirements",{"$f":"'Required Information'!B128","v":"Instructions for Data Entry: Describe the Laboratory Quality Control Requirements for the analysis that will be conducted. Determine the laboratory QC data to be routinely included with the laboratory's data package and provide a corresponding laboratory analytical QC table. "}]
[]
[]
[]
["B7: Field Equipment Calibration and Corrective Action",{"$f":"'Required Information'!B139","v":"B7 is not applicable to the equipment/tools involved in the collection of bulk building materials for asbestos analysis or paint chips for lead analysis.\n\nInstructions for Data Entry:\nIf a portable XRF analyzer will be used, describe the calibration procedures that will be used.  For example:\nPortable XRF analyzer calibration will be performed routinely, in accordance with HUD guidance, as well as the XRF analyzer operations manual. At the start of each sampling day, an initial calibration will be performed that consists of screening a reference positive detection three times. This reference positive detection will be a National Institute of Standards and Technology (NIST) Standard Reference Material or Certified Reference Material with a nominal value as close as possible to 1.0 mg/cm2. The average of three readings collected using the reference positive detection must fall within 0.8 to 1.2 mg/cm2 for the XRF to be considered operational. In addition, the calibration will be repeated each time the XRF is powered on, or after each 4 hours of operation. A final calibration check will also be performed at the completion of sampling each day, utilizing the same calibration methodology. The results of all XRF calibration will be recorded in the field logbook."}]
[]
[]
[]
[]
[]
[]
["B8: Laboratory Equipment Calibration and Corrective Action",{"$f":"'Required Information'!B146","v":"Instructions for Data Entry: Describe the Laboratory Equipment Calibration and Corrective Action for the analysis that will be conducted. If contained in laboratory SOPs, reference that appendix in this section. Otherwise, provide a laboratory equipment calibration table for each analytical method. Note the individuals responsible for these activities. "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["B9: Analytical Sensitivity and Project Criteria",{"$f":"'Required Information'!B178","v":"Instructions for Data Entry: Use the appropriate language based on the sampling that will be conducted:\n\nFor asbestos analysis of bulk building material samples using Polarized Light Microscopy (PLM) or Transmission Electron Microscopy (TEM), the laboratory reporting limit for asbestos must be 1% or less. \n\nFor laboratory lead analysis of paint chip samples, the reporting limit for lead must be less than 0.5 percent (0.5%) by weight or 5000 parts per million (ppm).\n\nFor lead analysis of paint using a portable XRF analyzer, the reporting limit for lead must be less than 1.0 milligrams per square centimeter (mg/cm2)."}]
[]
[]
[]
[]
[]
["B10: Data Management and Documentation",{"$f":"'Required Information'!B190","v":"Instructions for Data Entry: Refer to the QAPP Checklist. If the applicable information for this section is included in the Generic QAPP, enter “This information is included in the Generic QAPP.”  Otherwise, enter the applicable information for this section per the QAPP Checklist.    "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["SECTION C: ASSESSMENT/OVERSIGHT"]
["C1: Assessments and Corrective Action",{"$f":"'Required Information'!B194","v":"Instructions for Data Entry: Refer to the QAPP Checklist. If the applicable information for this section is included in the Generic QAPP, enter “This information is included in the Generic QAPP.”  Otherwise, enter the applicable information for this section per the QAPP Checklist.    "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["C2: Project Reports",{"$f":"'Required Information'!B198","v":"Instructions for Data Entry: Refer to the QAPP Checklist. If the applicable information for this section is included in the Generic QAPP, enter “This information is included in the Generic QAPP.”  Otherwise, enter the applicable information for this section per the QAPP Checklist.    "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["SECTION D: DATA EVALUATION"]
["D1: Field Data Evaluation",{"$f":"'Required Information'!B212","v":"Instructions for Data Entry: Refer to the QAPP Checklist. If the applicable information for this section is included in the Generic QAPP, enter “This information is included in the Generic QAPP.”  Otherwise, enter the applicable information for this section per the QAPP Checklist.    "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["D2: Laboratory Data Evaluation",{"$f":"'Required Information'!B213","v":"Instructions for Data Entry: Refer to the QAPP Checklist for Section D2 Laboratory Data Evaluation. Enter the applicable information for this section per the QAPP Checklist.    "}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["D3: Evaluating Data in Terms of User Needs",{"$f":"'Required Information'!B281","v":"Instructions for Data Entry: Refer to the QAPP Checklist for Section D3 Evaluating Data in Terms of User Needs. Enter the applicable information for this section per the QAPP Checklist.    "}]

{"sheet":"A Section","index":3,"n_rows":16,"n_cols":106,"rows_kept":16,"cut":false,"hidden":true,"merged":[[2,1,4,1],[9,1,11,1],[8,0,12,0]]}
["Section","Required Information"]
["A4",null,{"$f":"'Required Information'!C12","v":0},"selected ",{"$f":"'Required Information'!C19","v":0}]
["A5","State the Problem Defeinition/Background \n\nBackground: Briefly describe the known history of the site. Stick to the facts only.  This section must describe what you are doing and why you are doing it. Some example, but incomplete, text is provided.\n\nEx. The Site was first developed in 1935 as a municipal building and was susequently sold to a private developer in 2009. The Site has been unoccupied since being acquired in 2009.  Due to the age of the structure and lack of documentation on previous assessments it is believed asbestos containming materials (ACM) and Lead-Based Paint (LBP)  may be present in the structure.\n\n\n\n\n\n\n\n\n\n\n ","Due","to","a","lack","of","previous","analytical","sampling","or","a","reconizance","of","the","site","by",{"$f":"'Required Information'!C35","v":0},"field","descisions","will","be","made","based","on","observations","of","building","materials","encountered,","the","linear","feet","of","such","materials,","square","feet","of","material,","and/or","general","location.","This","sampling","is","limited","to","visible","materials","and","will","not","involve","invasive","methods","to","penetrate","walls","or","areas","deemed","inaccible","or","unsafe,","such","as","the","roof.","Sampling","locations","will","be","recorded","in","the","field","book","and","photographed","as","evidence","following","the","rational","presented","in","A7","(See","A7)","and","documented","in","the","final","report","submitted","to",{"$f":"'Required Information'!C12","v":0},"and","EPA"]
[null,null,"The","objective","of","this","Project","is","to","provide","exploratory","data","through","inspection","of","all","accessible","and","safe","interior","and","exterior","areas","of","the","subject","site","to","determine","the","presence","or","absence","of","ACM","and/or","LBP","in","accordance","with","the","protocols","established","by","the","United","States","Environmental","Protection","Agency","(USEPA)","and","the","Mississippi","Department","of","Environmental","Quality","(MDEQ).","Determining","the","presence","or","absence","of","ACM","and","LBP","will","determine","the","need","for","remediation","to","redvelop","or","safely","reuse","the","site","structure(s).","Should","ACM","and","LBP","be","found","on","site","a","more","comprenehisive","assessment","will","be","required","to","quantify","the","volume","of","materials","present","for","disposal."]
[]
[]
[]
[]
["A6","Projected Lab Conpletion Date","days of sample receipt. "]
[null,"Project/Task Description",{"$f":"CONCATENATE('Required Information'!Q1,'Required Information'!M1,'Required Information'!R1,'Required Information'!C9,'Required Information'!S1)","v":"An inspection will be conducted of all accessible and safe interior and exterior areas of the subject facility to identify ACM by a State licensed asbestos inspector in accordance with the protocols established by the Environmental Protection Agency (EPA) and the .  Roofing samples will not be collected if safe access does not exist. Roofing materials will be visually inspected to determine whether presumed asbestos containing materials (PACM) are likely present. The  Licensed Asbestos Inspector will use professional judgement and experience to determine whether roofing material should be considered PACM."}]
[null,null,{"$f":"_xlfn.CONCAT(\"Representative bulk samples of homogenous materials will be collected and analyzed at NVLAP accredited \",'Required Information'!C19)","v":"Representative bulk samples of homogenous materials will be collected and analyzed at NVLAP accredited "},"l, inc. by polarized light microscopy (PLM) at standard turn-around time (TAT) of approximately 10 working days.  PLM analysis of some non-friable organically bound ACM materials (NOB) such as floor tiles, roofing, etc. may be inconclusive for ACM.  Transmission electron microscopy (TEM) analysis provides lower asbestos detection limits, and will be utilized if PLM analysis is inconclusive. "]
[null,null,"Representative bulk samples of homogeneous building materials will be sampled and analyzed for asbestos at a laboratory accredited by the National Voluntary Laboratory Accreditation Program (NVLAP) as described in Section A7, B1, B2, and B4 of this Site-Specific QAPP. "]
[null,"LBP",{"$f":"'Required Information'!C47","v":"The lead-based paint survey will be conducted of all accessible and safe interior and exterior areas of the subject facility. Representative bulk samples of homogeneous building materials will be sampled and analyzed for lead in paint as described in Section A7, B1, B2, and B4 of this Site-Specific QAPP.  <Specify whether representative paint samples will be analyzed for lead using a laboratory method, a hand-held X-Ray Fluorescence (XRF) device, or both XRF and laboratory methods.> "}]
["A7","ACM","Once the licensed ACM contractor arrives on site, a comprehensive walkthrough of the site will be conducted to identify materials and surfaces for sampling (i.e. painted/peeling walls, mastic, adhesives, floor tiles, caulks, acoustic ceiling tiles, etc.)."]
[null,"LBP","Once the licensed LBP contractor arrives on site, a comprehensive walkthrough of the site will be conducted to identify materials and surfaces for sampling (i.e. painted/peeling walls, mastic, adhesives, floor tiles, caulks, acoustic ceiling tiles, etc.)."]
[null,"Both","Once the licensed ACM/LBP contractor arrives on site, a comprehensive walkthrough of the site will be conducted to identify materials and surfaces for sampling (i.e. painted/peeling walls, mastic, adhesives, floor tiles, caulks, acoustic ceiling tiles, etc.)."]

{"sheet":"B Section","index":4,"n_rows":7,"n_cols":2,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["B2","Procedures"]
[null,{"$f":"IF('Required Information'!$F$1=TRUE, \"SESDPROC-010-R5 Log Books\",\"\")","v":""}]
[null,{"$f":"IF('Required Information'!$G$1=TRUE, \"SFDGUID-001-R0 Superfund X-Ray Fluorescence Field Operations\",\"\")","v":""}]
[null,{"$f":"IF('Required Information'!$H$1=TRUE, \"HUD Guidelines For The Evaluation And Control Of Lead-Based Paint Hazards In Housing Appendix 13.2 Paint Chip Sampling, (2012 Edition)\",\"\")","v":""}]
[null,{"$f":"IF('Required Information'!$I$1=TRUE, \"SESDGUID-104-R1 Bulk Sampling for Asbestos (attach a copy of this document to the QAPP)\",\"\")","v":""}]
[null,{"$f":"IF('Required Information'!$J$1=TRUE, \"SESDPROC-005-R2 Sample and Evidence Management\",\"\")","v":""}]
[null,{"$f":"IF('Required Information'!$K$1=TRUE, \"ASTM E1729 - 16 Standard Practice for Field Collection of Dried Paint Samples for Subsequent Lead Determination\",\"\")","v":""}]