Spreadsheet: 877375d1724199163-vlookup-and-mean-formulas-new-pcm-draft-megans-copy-no-macros
Sheet: Air Results

ASBESTOS INSPECTION AIR MONITORING RESULTS
Location: |  |  |  |  |  |  |  |  | Date(s):
 |  |  |  |  |  |  |  |  | Project No.:
Client: |  |  |  |  |  | Analysis Method:
Sample Date  (DD-MMM-YY) | SAMPLE NO. | SAMPLE LOCATION | SAMPLE TIME |  |  | FLOW (L/min) | SAMPLE VOLUME (L) | FIBRE COUNT | REPORTED FIBRES | NO. OF FIELDS | Vlookup for blanks | (H) Raw Fibre Density (f/mm2) | [NAME] (f/mm2) | (H) Raw Fibre Conc. (f/mm2) | [NAME]. (f/cc)
 |  |  | ON | OFF | MINS
2024-08-24 00:00:00 | 24220-1 | Clean Room (Back Entry) | 1904-01-01 09:35:00 | 1904-01-01 12:15:00 |  | 16 |  | 15.5 |  | 100
2024-08-24 00:00:00 | 24220-2 | North Ext. (Neg Air Exhaust) | 1904-01-01 09:35:00 | 1904-01-01 12:15:00 |  | 11 |  | 0 |  | 100
2024-08-24 00:00:00 | 24220-3 | Basement | 1904-01-01 09:40:00 | 1904-01-01 12:17:00 |  | 16 |  | 17 |  | 100
2024-08-24 00:00:00 | 24220-4 | Field Blank |  |  |  | 0 |  | 5 |  | 100
2024-08-24 00:00:00 | 24220-5 | North Ext. (Neg Air Exhaust) | 1904-01-01 12:15:00 | 1904-01-01 15:40:00 |  | 11 |  | 5 |  | 100
 |  |  | 1904-01-01 12:17:00 | 1904-01-01 15:45:00 |  | 16 |  | 11 |  | 100
2024-08-25 00:00:00 | 24220-7 | Occupational: [NAME] | 1904-01-01 15:23:00 | 1904-01-01 15:44:00 |  | 2.5 |  | 18.5 |  | 100
2024-08-25 00:00:00 | 24220-8 | Clean Room (Back Entry) | 1904-01-01 09:10:00 | 1904-01-01 11:50:00 |  | 16 |  | 14 |  | 100
2024-08-25 00:00:00 | 24220-9 | North Ext. (Neg Air Exhaust) | 1904-01-01 09:10:00 | 1904-01-01 11:50:00 |  | 11 |  | 2 |  | 100
2024-08-25 00:00:00 | 24220-10 | Basement | 1904-01-01 09:12:00 | 1904-01-01 11:53:00 |  | 16 |  | 16.5 |  | 100
2024-08-25 00:00:00 | 24220-11 | Clean Room (Back Entry) | 1904-01-01 11:50:00 | 1904-01-01 15:45:00 |  | 16 |  | 6 |  | 100
2024-08-25 00:00:00 | 24220-12 | North Ext. (Neg Air Exhaust) | 1904-01-01 11:50:00 | 1904-01-01 15:45:00 |  | 11 |  | 4 |  | 100
2024-08-25 00:00:00 | 24220-13 | Basement | 1904-01-01 11:53:00 | 1904-01-01 15:47:00 |  | 16 |  | 18 |  | 100
 | 24220-14 | Main Floor FINAL | 1904-01-01 09:05:00 | 1904-01-01 11:50:00 |  | 16 |  | 0 |  | 100
2024-08-26 00:00:00 | 24220-15 | Field Blank |  |  | 0 | 0 | 0 | 3 |  | 100
 |  |  |  |  |  | 0 |  | 0 |  | 100
 |  |  |  |  |  | 0 |  | 0 |  | 100
Note: |  |  |  |  |  | mean of blanks
1. Due to inherent limitations of the referenced method, fibers measuring <0.25 µm in diameter cannot be detected.
2. Samples collected for excursion purposes and below the minimum recommended volume of 400L, have been reported with a higher degree of precision for determined fibre       densities and should be compared to the maximum use concentration for the respiratory protective equipment (RPE) donned by workers (Half Mask/Full Face - 1.0 f/cc when      qualitatively fit  tested, Full Face – 50.0 f/cc when quantitatively fit tested, and Powered Air Purifying Respirator - 100.0 f/cc)
3. Area or ambient samples with adequate total volumes and counts below the limit of detection (LOD) of 5.0 fibres, have been reported with final count of <5.5 fibres and      concentration of < 0.01 fibres/cc.
4. Area or ambient samples with adequate total volumes and counts below the limit of detection (LOD) for the specified methodology, 7 fibres/mm 2 and determined equivalencies,      have been reported with final density of < 7 fibres/mm2 and a concentration of <0.01 fibres/cc.
5. Fibre counts outside of the working range of 100 - 1300 fibres/mm2 have a greater than optimal variability and therefore, are probably biased.
6. Samples with a particulate loading obscuring 50% or more of the filter area are considered overloaded. Fibre counts from these samples cannot be accurately determined and      therefore, have been reported as "uncountable" or "VOID"