{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Front Cover","User Guide","Main sheet - Work Categories","List Processing"],"not_rendered":{"charts":0,"images":20,"macros":1,"external_links":0,"defined_names":100,"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":"Front Cover","index":0,"n_rows":70,"n_cols":1,"rows_kept":70,"cut":false,"hidden":false,"merged":[[45,0,45,9],[46,0,46,9],[55,0,55,9],[60,0,60,9],[69,0,69,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["This spreadsheet tool provides the user with a decision support platform designed by the Joint Industry Working Group for Asbestos in Soil and Construction & Demolition Materials (JIWG) to assist in the categorisation of work with asbestos under CAR2012, and supports the JIWG Industry Guidance on the Control of Asbestos Regulations 2012: Interpretation for Managing and Working with Asbestos in Soil and Construction & Demolition Materials (CAR-SOILTM, 2016).  The spreadsheet should be used by competent persons in conjunction with the guidance in this publication. "]
["The tool, which has been refined as part of the development of the JIWG CAR-SOILTM guidance and incorporates changes based on comments received on the earlier BETA version, has been made available to industry practitioners for the purpose of applying its use on real-life situations.\n\nThe JIWG would welcome feedback from users of this version on its applicability and validity to the wide range of scenarios that may be encountered when assessing the potential risk from and asbestos licensing status of work with asbestos and asbestos-containing materials in the ground."]
[]
[]
["ISBN 978-1-905046-28-7"]
[]
["© CL:AIRE 2016"]
[]
["Published by CL:AIRE, 32 Bloomsbury Street, London WC1B 3QJ."]
[]
["All rights reserved.  No part of this publication or tool may be reproduced, stored in a retrieval system, or transmitted in any form or by any other means, electronic, mechanical, photocopying, recording or otherwise, without the written permission of the copyright holder."]
[]
[]
["Acknowledgements"]
[]
["CL:AIRE and the JIWG would like to gratefully acknowledge Simon Cole - AECOM, Garry Burdett - Health and Safety Laboratory and Stephen Forster - Remedia Group for the preparation of this decision support tool."]
[]
[]
[]
[]
[]
[]
["Disclaimer"]
[]
["CL:AIRE and the JIWG will not be responsible for any loss, however arising, the use of, or reliance on, the information contained in this decision support tool and associated user guide, nor do they assume responsibility or liability for errors or omissions contained within.  Competent users are advised to use the information contained herein purely as a guide and to take appropriate professional advice where necessary. "]

{"sheet":"User Guide","index":1,"n_rows":264,"n_cols":2,"rows_kept":264,"cut":false,"hidden":false,"merged":[[241,1,241,14],[243,1,243,14],[248,1,248,14],[372,1,372,14],[137,1,137,14],[175,1,175,14],[192,1,192,14],[154,1,154,14],[209,1,209,14],[226,1,226,14],[288,1,288,14],[121,1,121,13],[6,1,7,14],[8,1,32,14],[34,1,34,14],[35,1,35,14],[36,1,36,14],[38,1,38,14],[65,1,65,14],[79,1,79,14],[107,1,107,13],[51,1,51,14],[93,1,93,14]]}
[]
[]
[]
[]
[]
[]
[null,"Decision Support Tool for the Categorisation of Work Activities Involving Asbestos in Soil or Construction & Demolition Materials in accordance with CAR 2012"]
[]
[null,"This spreadsheet tool provides the user with a decision support platform designed by the Joint Industry Working Group to assist in the categorisation of work under CAR2012, and supports the JIWG Industry Guidance on the Control of Asbestos Regulations 2012: Interpretation for Managing and Working with Asbestos in Soil and Construction & Demolition Materials (CAR-SOILTM,2016).  The spreadsheet should be used by competent persons in conjunction with the guidance in this publication.  The spreadsheet does not replace the sound professional judgement of a competent person.\n\nThe aim of developing this tool is to provide industry with a consistent decision making format that is aligned with UK health & safety and environmental regulatory policies, and is consistent with the wider objectives of the JIWG.\n\nThe hazard and risk ranking approaches take influences from the HSG227 material and priority scoring systems and identifies key hazard and risk factors that are relevant to the management of risk from exposure to asbestos contaminated soils, made ground or construction & demolition materials.\n\nThe spreadsheet is designed to lead the user through a series of options for each identified factor.  These factors are grouped into Stages with each stage providing a numerical and/or qualitative hazard or risk ranking phrase.  The user is lead sequentially through each Stage with the stages ordered from left to right.  A step by step guide to each stage is provided below:\n\nGeneral points:\n\nAlways choose the dropdown option that best fits your understanding of factor under consideration.  If one option does not sufficiently reflect the dominant situation on-site re-run the DST using the most applicable options sequentially.\n\nNB - inputs may be based on a combination of field visual observations and laboratory analysis.  The tool may be used to model actual ground conditions, or to develop outputs for hypothetical and potential scenarios hat may be encountered on site.  Where assumptions are made based on field observations, justification for those must be provided in the Plan of Work.\n\nAcknowledgements:\n\nDST developers: Simon Cole - AECOM, Garry Burdett - Health & Safety Laboratory, Steve Forster - Remedia Group\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"No warranty, expressed or implied, or reliance, is provided in relation to the use of this tool."]
[null,"It is contingent on users to satisfy themselves that the output from the tool is relevant and appropriate to the assessment being made."]
[null,"This tool has been developed and is made freely available by the JIWG."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Decision Support Tool for CAR2012 Work Categories"]
[]
[null,"Stage 1 - Hazard Factors"]
[]
[null,"These five factors are designed to identify at a basic level the inherent hazard of the asbestos content of the ground or stockpiled material."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Factor 1 - Select ACM type (run model for each type to generate 'Worst Case' output)"]
[]
[null,"A choice of eight categories to identify, sequentially, the principal ACM types present and designed to distinguish between the groups of ACMs that have clearly different hazard characteristics.  If more than one type of ACM material is present, the DST should be run for each material.  A comparative analysis can then be done on the respective outputs for the worst and best case scenarios.\n\nNB refer to CAR-SOILTM for guidance on differentiation of clearly identifiable insulation, lagging and AIB from unspecified fibrous board and loose fibrous asbestos debris."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Factor 2 - Extent of degradation of ACMs at outset of work"]
[]
[null,"Four choices to describe the degree of degradation of the ACM at the outset of work to be carried out on the contaminated material.  Note that current HSE guidance suggests that even if the ACMs have been broken up into discernible fragments, this does not necessarily mean that the material is degraded, rather it is the condition of those fragments that determine the degree of degradation.  This dropdown list is conditioned based on the choice of ACM type selected for factor 1."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Factor 3 - Friability and degree of bonding by matrix (ACM matrix, not ground materials)"]
[]
[null,"Three choices to describe the friability of the ACM and the degree of bonding of asbestos fibres in the host matrix.  A material is either friable or non-friable.  \nIf the material is friable, the asbestos fibres will either be not firmly linked in the host ACM matrix, OR, in the case of free dispersed fibres, those fibres will not be firmly linked in any ground material matrix.\nThis dropdown list is conditioned based on the choices for factors 1 and 2."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Factor 4 - Distribution of visible asbestos across affected area"]
[]
[null,"Five qualitative descriptions designed to account for the relative amount of visible ACM contamination present over a site, or within a zone on a site, based on field observations.  This is not necessarily an indication of the mass concentration of asbestos present in the ground matrix.  NB if a material is described as coatings, or clearly identifiable insulation, lagging or AIB, it must be, by definition, visible."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Factor 5 - Amount of asbestos fibre in ACM as % of host material"]
[]
[null,"Five qualitative descriptions linked to banded quantitative estimates/measurements of the weight percentage of asbestos fibre present in the host ground matrix material."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Hazard Ranking - provides a qualitative ranking from negligible to high dependent on the cumulative score for hazard factors 1-5."]
[]
[]
[null,"Stage 2 - Exposure Factors"]
[]
[null,"These five factors are designed to identify the potential for fibre release and airborne exposure.  These factors are independent of the Hazard Factors in Stage 1 with the exception of the anticipated airborne fibre concentration and the respirable fibre index - both of which intentionally build on factor choices at Stage 1.  \n\nNote that host material moisture content is not included in the list of factors considered.  This is an emission mitigating factor that is temporally variable and the effect of host material moisture content should be considered on a daily basis during work activities and factored into the choice of appropriate dust suppression measures."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Factor 1 - Anticipated airborne fibre concentration - Control Limit or SALI?"]
[]
[null,"Two options of banded airborne fibre concentrations to best describe the anticipated - or measured - fibre levels associated with the work, either lower or higher than the Control Limit/STEL, the latter forming the basis for defining Sporadic and Low Intensity exposure under CAR 2012."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Factor 2 - Anticipated duration of exposure to asbestos"]
[null,"Five choices designed to distinguish between the intended duration of works on asbestos-contaminated materials.  These categories relate to phrases in CAR 2012 that allow consideration of whether the work is likely to be Licensed Work, or whether it may be categorised as Notifiable Non-Licensed Work or Non-Licensed Work, according to certain conditions."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Factor 3 - Activity type and effect on deterioration of ACMs during work"]
[]
[null,"Six choices designed to distinguish between activities likely to cause no/minimal deterioration of the ACMs and those that are likely to cause deterioration.  This links to the notification requirements of CAR 2012.  The choice purposefully does not include high intensity activity.  Control measures for activities should be such that high intensity activities should not be an option."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Factor 4 - Best description of primary host material matrix (soil/made ground)"]
[]
[null,"Six choices for the best description of host material that distinguish between the potential dustiness of that material and the potential for fibre release upon disturbance of that material."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Factor 5 - Respirable Fibre Index for Source Material"]
[]
[null,"Use the guidance provided in CIRIA C733 or the original evaluation for the approximation of respirable fibre content in different ACMs provided in RIVM report 711701034 (2003).  This provides an additional layer of exposure characterisation by adjusting the asbestos fibre concentration for the proportion of respirable fibres - those fibres that are most relevant to the exposure hazard.\n\nThis dropdown list is conditioned based on the ACM type chosen at Stage 1."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Exposure ranking - provides a qualitative ranking from very low to high dependent on the cumulative score for hazard factors 1-5."]
[]
[null,"Combined hazard and exposure ranking - provides an additional qualitative ranking from very low to high based on the summation of the hazard and exposure sub-totals."]
[]
[]
[null,"Stage 3 - Risk Assessment Outputs"]
[]
[null,"Based on the combined hazard and exposure scores and answers to specific factors, the outputs provide an indication as to the probable licensing status for the work under consideration.  \n\nFor some activities, default suggestions for RPE, dust suppression and hygiene/welfare are provided based on that licensing status.  For others, e.g. sampling, when this is Non Licensed Work, the default suggestions are based on the combined hazard and exposure rankings.\n\nThe risk assessments outputs do not replace sound professional judgement and are only designed to be a guide.  All decisions regarding the selection and use of RPE and PPE should be made by competent persons and be justified in the Plan of Work."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"The four default output scenarios are:"]

{"sheet":"Main sheet - Work Categories","index":2,"n_rows":29,"n_cols":24,"rows_kept":29,"cut":false,"hidden":false,"merged":[[14,15,14,16],[15,15,15,16],[16,15,16,16],[17,15,17,16],[18,15,18,16],[2,5,2,9],[3,5,3,9],[4,5,4,9],[5,5,5,9],[6,5,6,9],[18,4,18,8],[22,4,22,8],[7,5,7,9],[14,4,14,8],[15,4,15,8],[16,4,16,8],[17,4,17,8]]}
[]
[]
[null,null,null,null,"Project Reference"]
[null,null,null,null,"Site Name"]
[null,null,null,null,"Client"]
[null,null,null,null,"Run by"]
[null,null,null,null,"Date"]
[null,null,null,null,"Scenario details"]
[]
[null,"Decision Support Tool for CAR2012 Work Categories"]
[]
[null,null,"Stage 1",null,null,null,null,null,null,null,null,null,null,null,"Stage 2",null,null,null,null,null,null,null,"Stage 3"]
[null,null,"Hazard Factors",null,null,null,null,null,null,"Score",null,null,null,null,"Exposure Factors",null,null,"Score",null,null,null,null,"Risk Assessment Outputs"]
[]
[null,null,"Select ACM type (run model for each type to generate 'Worst Case' output)",null,"Coatings (excluding textured decorative coatings)",null,null,null,null,{"$f":"VLOOKUP(Work_Cat_ACM_Type,LookupScore_ACMType,2,FALSE)","v":4},null,null,null,null,"Anticipated airborne fibre concentration - Control Limit or SALI?","<0.1 fibres/ml (4 Hr TWA) or <0.6 fibres/ml (10 minute STEL)",null,{"$f":"VLOOKUP(Work_Cat_Air_Conc,LookupScore_AirbourneConc,2,FALSE)","v":2},null,null,null,null,"Probable Licensing Status",{"$f":"LicensingStatus","v":"Non-Licensed Work"}]
[null,null,"Extent of degradation of ACMs at outset of work",null,"Disaggregated (dominated by loose fibrous material; extreme degradation in ACM and/or free asbestos fibres/fibre bundles)",null,null,null,null,{"$f":"VLOOKUP(Work_Cat_Degradation_Extent,LookupScore_DegExtent,2,FALSE)","v":4},null,null,null,null,"Anticipated duration of exposure to asbestos","> 2 hours in a 7 day period and Up to 10 hours in a day (e.g. full time occupational exposure)",null,{"$f":"VLOOKUP(Work_Cat_Exposure_Period,LookupScore_ExposureDuration,2,FALSE)","v":4},null,null,null,null,"RPE*",{"$f":"IF(OR('List Processing'!B114=1,'List Processing'!B115=1),VLOOKUP(Work_Cat_Combined_Rank,'List Processing'!A229:B232,2,FALSE),VLOOKUP(X15,LookupTable_RPE,2,FALSE))","v":"EN140 with P3 filter half mask"}]
[null,null,"Friability and degree of bonding by matrix (ACM matrix, not ground materials)",null,"Friable ACM or ACM with fibres not linked in any matrix (free dispersed fibres/fibre bundles)",null,null,null,null,{"$f":"VLOOKUP(Work_Cat_Friability,LookupScore_Friability,2,FALSE)","v":4},null,null,null,null,"Activity type and effect on deterioration of ACMs during work","Sampling, manual or mechanical (no or minimal deterioration expected)",null,{"$f":"VLOOKUP(Work_Cat_Activity_Type,LookupScore_ActivityType,2,FALSE)","v":0},null,null,null,null,"Dust Suppression**",{"$f":"IF(OR('List Processing'!B110=2,'List Processing'!B109=2),VLOOKUP(Work_Cat_Combined_Rank,'List Processing'!A236:B239,2,FALSE), VLOOKUP(X15,LookupTable_Dust_Suppression,2,FALSE))","v":"Localised mechanical dust suppression"}]
[null,null,"Distribution of Visible Asbestos Across Affected Area",null,"Sporadic/random occurrences of visible contamination by ACMs",null,null,null,null,{"$f":"VLOOKUP(Work_Cat_Asb_Distribution,LookupScore_Distribution,2,FALSE)","v":2},null,null,null,null,"Best description of primary host material matrix (soil/made ground)","Fine Silt and/or Clay",null,{"$f":"VLOOKUP(Work_Cat_Host_Material,LookupScore_HostMaterial,2,FALSE)","v":1},null,null,null,null,"Hygiene/Decontamination***",{"$f":"IF(OR('List Processing'!B110=2,'List Processing'!B109=2),VLOOKUP(Work_Cat_Combined_Rank,'List Processing'!A243:B246,2,FALSE),VLOOKUP(X15,LookupTable_Hygiene,2,FALSE))","v":"Localised and enhanced personal decontamination facilities"}]
[null,null,"Amount of asbestos fibre in selected ACM/fibre type as % of host material",null,"Very Low quantities - <0.001 to 0.01 %wt/wt",null,null,null,null,{"$f":"VLOOKUP(Work_Cat_Amount,LookupScore_AsbestosAmount,2,FALSE)","v":1},null,null,null,null,"Respirable fibre index for ACM - RIVM report 711701034 (2003) ","High",null,{"$f":"VLOOKUP(Work_Cat_Respirable_Fibre_Index,LookupScore_RespFirbreIndex,2,FALSE)","v":4}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"*Where RPE has to be worn continuously for long periods (e.g. more than 1-hour), then powered RPE may be necessary. "]
[null,null,"Sub-total",null,null,null,null,null,null,{"$f":"IF(ISERROR(SUM(J15:J18)*(J19/J19)+J19),0, SUM(J15:J18)*(J19/J19)+J19)","v":15},null,null,null,null,"Sub-total",null,null,{"$f":"SUM(R15:R19)","v":11},null,null,null,null,"**Reduction in control measures possible if natural mitigation factors are present (e.g. raining, wet ground)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"***Guide only; suitability of selected personal hygiene measures may be reviewed on a site/contamination-specific basis"]
[null,null,null,null,"Note: the asbestos licensing regime is unaffected by the type of asbestos fibre present in ACMs"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Exposure ranking",null,null,{"$f":"VLOOKUP(Work_Cat_Stage2_SubTot,LookupTable_Stage2_Ranks_Equivs,2,FALSE)","v":"Medium"}]
[null,null,"Hazard ranking",null,null,null,null,null,null,{"$f":"VLOOKUP(Work_Cat_Stage1_SubTot,LookupTable_Stage1_Ranks,2,FALSE)","v":"Medium"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Combined hazard and exposure ranking",null,{"$f":"Work_Cat_Stage2_SubTot+Work_Cat_Stage1_SubTot","v":26},{"$f":"IF(Work_Cat_Combined_Score>30,\"High\",IF(Work_Cat_Combined_Score>20,\"Medium\",IF(Work_Cat_Combined_Score>10,\"Low\",IF(Work_Cat_Combined_Score<=10,\"Very Low\"))))","v":"Medium"}]
[]
[null,"No warranty, expressed or implied, or reliance, is provided in relation to the use of this tool. \n"]
[null,"It is contingent on users to satisfy themselves that the output from the tool is relevant and appropriate to the assessment being made."]

{"sheet":"List Processing","index":3,"n_rows":246,"n_cols":7,"rows_kept":246,"cut":false,"hidden":true,"merged":[]}
[null,"Select ACM type (run model for each type to generate 'Worst Case' output)"]
[null,"Item","Score","Code1"]
[null,"Bonded ACMs: cement, vinyl, composites,  textured decorative coatings, bitumen products",1,"G"]
[null,"Woven textiles, string, rope, paper, felt, gaskets etc.",1,"F"]
[null,"Unspecified fibrous board",2,"E"]
[null,"Free dispersed fibres/fibre bundles",2,"H"]
[null,"Clearly identifiable insulating board",2,"C"]
[null,"Loose fibrous asbestos debris",3,"D"]
[null,"Clearly identifiable insulation or lagging",3,"B"]
[null,"Coatings (excluding textured decorative coatings)",4,"A"]
[null,null,"Code1:",{"$f":"VLOOKUP(Work_Cat_ACM_Type,'List Processing'!B3:D10,3,FALSE)","v":"A"}]
[]
[null,"Extent of degradation of ACMs at outset of works"]
["Applicability Codes","All Items","All Scores","Code2","Applicable Items","Applicable Scores"]
["B/C/E/F/G","Intact (Very good condition ACM/ACM fragments",1,"T",{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),\"-\",B:B)","v":"-"},{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),NA(),C:C)","v":{"$error":"#N/A"}}]
["B/C/E/F/G","Weathered (Slight degradation in ACM; material still retains its basic integrity)",2,"T",{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),\"-\",B:B)","v":"-"},{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),NA(),C:C)","v":{"$error":"#N/A"}}]
["B/C/E/F/G","Degraded (Significant degradation in ACM; material has lost its basic integrity)",3,"S",{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),\"-\",B:B)","v":"-"},{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),NA(),C:C)","v":{"$error":"#N/A"}}]
["A/B/D/H","Disaggregated (dominated by loose fibrous material; extreme degradation in ACM and/or free asbestos fibres/fibre bundles)",4,"S",{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),\"-\",B:B)","v":"Disaggregated (dominated by loose fibrous material; extreme degradation in ACM and/or free asbestos fibres/fibre bundles)"},{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),NA(),C:C)","v":4}]
[null,null,"Code2:",{"$f":"VLOOKUP(Work_Cat_Degradation_Extent,'List Processing'!B14:D18,3,FALSE)","v":"S"}]
[null,"Friability and degree of bonding by matrix (refers to ACM matrix)"]
["Applicability Codes","All Items","All Scores","Code3","Applicable Items","Applicable Scores","(choice based on Code1 and Code2)"]
["CT/ET/FT/FS/GT/GS","Non-friable ACM or ACM with fibres firmly linked in a matrix",0,"Z",{"$f":"IF(ISERROR(FIND(Code_ACM&Code_DegACM,$A:$A)),\"-\",B:B)","v":"-"},{"$f":"IF(ISERROR(FIND(Code_ACM&Code_DegACM,$A:$A)),NA(),C:C)","v":{"$error":"#N/A"}}]
["AT/AS/BT/BS/CS/DT/DS/ES","Friable ACM or ACM with fibres not firmly linked in a matrix",2,"Y",{"$f":"IF(ISERROR(FIND(Code_ACM&Code_DegACM,$A:$A)),\"-\",B:B)","v":"Friable ACM or ACM with fibres not firmly linked in a matrix"},{"$f":"IF(ISERROR(FIND(Code_ACM&Code_DegACM,$A:$A)),NA(),C:C)","v":2}]
["A/B/D/H","Friable ACM or ACM with fibres not linked in any matrix (free dispersed fibres/fibre bundles)",4,"Y",{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),\"-\",B:B)","v":"Friable ACM or ACM with fibres not linked in any matrix (free dispersed fibres/fibre bundles)"},{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),NA(),C:C)","v":4}]
[null,null,"Code3:",{"$f":"VLOOKUP(Work_Cat_Friability,'List Processing'!B22:D24,3,FALSE)","v":"Y"}]
[]
[null,"Distribution of Visible Asbestos Across Affected Area"]
["Applicability Codes","All Items","All Scores","Applicable Items","Applicable Scores"]
["D/E/F/G/H","No visible ACMs/fibre bundles",0,{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),\"-\",B:B)","v":"-"},{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),NA(),C:C)","v":{"$error":"#N/A"}}]
["A/B/C/D/E/F/G/H","Occasional/random occurrences of visible contamination by ACMs",1,{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),\"-\",B:B)","v":"Occasional/random occurrences of visible contamination by ACMs"},{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),NA(),C:C)","v":1}]
["A/B/C/D/E/F/G/H","Sporadic/random occurrences of visible contamination by ACMs",2,{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),\"-\",B:B)","v":"Sporadic/random occurrences of visible contamination by ACMs"},{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),NA(),C:C)","v":2}]
["A/B/C/D/E/F/G/H","Moderate/frequent occurrences of visible contamination by ACMs",3,{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),\"-\",B:B)","v":"Moderate/frequent occurrences of visible contamination by ACMs"},{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),NA(),C:C)","v":3}]
["A/B/C/D/E/F/G/H","Gross/very frequent occurrences of visible contamination by ACMs",4,{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),\"-\",B:B)","v":"Gross/very frequent occurrences of visible contamination by ACMs"},{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),NA(),C:C)","v":4}]
[]
[null,"Amount of asbestos fibre in selected ACM/fibre type as % of host material"]
["Applicability Codes","All Items","All Scores","Applicable Items","Applicable Scores"]
["D/E/F/G/H","Trace quantities - <0.0001 to 0.001 %wt/wt",0,{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),\"-\",B:B)","v":"-"},{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),NA(),C:C)","v":{"$error":"#N/A"}}]
["A/B/C/D/E/F/G/H","Very Low quantities - <0.001 to 0.01 %wt/wt",1,{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),\"-\",B:B)","v":"Very Low quantities - <0.001 to 0.01 %wt/wt"},{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),NA(),C:C)","v":1}]
["A/B/C/D/E/F/G/H","Low quantities - >0.01 to <0.05 %wt/wt",2,{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),\"-\",B:B)","v":"Low quantities - >0.01 to <0.05 %wt/wt"},{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),NA(),C:C)","v":2}]
["A/B/C/D/E/F/G/H","Moderate quantities - >0.05 to <0.1 %wt/wt",3,{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),\"-\",B:B)","v":"Moderate quantities - >0.05 to <0.1 %wt/wt"},{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),NA(),C:C)","v":3}]
["A/B/C/D/E/F/G/H","Large quantities - >0.1 %wt/wt",4,{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),\"-\",B:B)","v":"Large quantities - >0.1 %wt/wt"},{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),NA(),C:C)","v":4}]
[]
[null,"Anticipated airborne fibre concentration - Control Limit or SALI?"]
["Applicability Codes","All Items","All Scores","Applicable Items","Applicable Scores"]
["A/B/C/D/E/F/G/H","<0.001 fibres/ml",0,{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),\"-\",B:B)","v":"<0.001 fibres/ml"},{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),NA(),C:C)","v":0}]
["A/B/C/D/E/F/G/H","<0.01 fibres/ml",1,{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),\"-\",B:B)","v":"<0.01 fibres/ml"},{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),NA(),C:C)","v":1}]
["A/B/C/D/E/F/G/H","<0.1 fibres/ml (4 Hr TWA) or <0.6 fibres/ml (10 minute STEL)",2,{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),\"-\",B:B)","v":"<0.1 fibres/ml (4 Hr TWA) or <0.6 fibres/ml (10 minute STEL)"},{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),NA(),C:C)","v":2}]
["A/B/C/D/E/F/G/H",">0.1 fibres/ml (4 Hr TWA) or >0.6 fibres/ml (10 minute STEL)",4,{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),\"-\",B:B)","v":">0.1 fibres/ml (4 Hr TWA) or >0.6 fibres/ml (10 minute STEL)"},{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),NA(),C:C)","v":4}]
[]
[null,"Anticipated duration of exposure to asbestos"]
["Applicability Codes","All Items","All Scores","Applicable Items","Applicable Scores","(choice based on Code1 and Code3)"]
["B/C/D/E/F/G/H_Z","Maintenance (small routine tasks); short, non-continuous work",1,{"$f":"IF(OR(ISERROR(FIND(Code_ACM,$A:$A)),ISERROR(FIND(Code_Friability,$A:$A))),\"-\",B:B)","v":"-"},{"$f":"IF(OR(ISERROR(FIND(Code_ACM,$A:$A)),ISERROR(FIND(Code_Friability,$A:$A))),NA(),C:C)","v":{"$error":"#N/A"}}]
["A/B/C/D/E/F/G/H_Z/Y","< 1 hour for any one person in any week (e.g. Short Duration Work)",1,{"$f":"IF(OR(ISERROR(FIND(Code_ACM,$A:$A)),ISERROR(FIND(Code_Friability,$A:$A))),\"-\",B:B)","v":"< 1 hour for any one person in any week (e.g. Short Duration Work)"},{"$f":"IF(OR(ISERROR(FIND(Code_ACM,$A:$A)),ISERROR(FIND(Code_Friability,$A:$A))),NA(),C:C)","v":1}]
["A/B/C/D/E/F/G/H_Z/Y","< 2 hours in a 7 day period for all persons involved (e.g. Short Duration Work)",1,{"$f":"IF(OR(ISERROR(FIND(Code_ACM,$A:$A)),ISERROR(FIND(Code_Friability,$A:$A))),\"-\",B:B)","v":"< 2 hours in a 7 day period for all persons involved (e.g. Short Duration Work)"},{"$f":"IF(OR(ISERROR(FIND(Code_ACM,$A:$A)),ISERROR(FIND(Code_Friability,$A:$A))),NA(),C:C)","v":1}]
["B/C/D/E/F/G/H_Z","Maintenance (not small routine tasks); not short, non-continuous work",2,{"$f":"IF(OR(ISERROR(FIND(Code_ACM,$A:$A)),ISERROR(FIND(Code_Friability,$A:$A))),\"-\",B:B)","v":"-"},{"$f":"IF(OR(ISERROR(FIND(Code_ACM,$A:$A)),ISERROR(FIND(Code_Friability,$A:$A))),NA(),C:C)","v":{"$error":"#N/A"}}]
["A/B/C/D/E/F/G/H_Z/Y","> 2 hours in a 7 day period and Up to 10 hours in a day (e.g. full time occupational exposure)",4,{"$f":"IF(OR(ISERROR(FIND(Code_ACM,$A:$A)),ISERROR(FIND(Code_Friability,$A:$A))),\"-\",B:B)","v":"> 2 hours in a 7 day period and Up to 10 hours in a day (e.g. full time occupational exposure)"},{"$f":"IF(OR(ISERROR(FIND(Code_ACM,$A:$A)),ISERROR(FIND(Code_Friability,$A:$A))),NA(),C:C)","v":4}]
[]
[null,"Activity type and effect on deterioration of ACMs during work"]
["Applicability Codes","All Items","All Scores","Applicable Items","Applicable Scores","(choice based on Code1 and Code3)"]
["A/B/C/D/E/F/G/H_Z/Y","Sampling, manual or mechanical (no or minimal deterioration expected)",0,{"$f":"IF(OR(ISERROR(FIND(Code_ACM,$A:$A)),ISERROR(FIND(Code_Friability,$A:$A))),\"-\",B:B)","v":"Sampling, manual or mechanical (no or minimal deterioration expected)"},{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),NA(),C:C)","v":0}]
["A/B/C/D/E/F/G/H_Z/Y","Low intensity, no or minimal deterioration expected",0,"Low intensity, no or minimal deterioration expected",0]
["A/B/C/D/E/F/G/H_Z","Maintenance tasks, no deterioration expected",0,"-",0]
["A/B/C/D/E/F/G/H_Z/Y","Sampling, manual or mechanical (significant deterioration expected)",2,"Sampling, manual or mechanical (significant deterioration expected)",2]
["A/B/C/D/E/F/G/H_Z","Maintenance tasks, significant deterioration expected",2,"-",2]
["B/C/D/E/F/G/H_Z/Y","Not low intensity, significant deterioration expected",4,"-",{"$error":"#N/A"}]
[]
[null,"Best description of primary host material matrix (soil/made ground)"]
["Applicability Codes","All Items","All Scores","Applicable Items","Applicable Scores"]
["A/B/C/D/E/F/G/H","Fine Silt and/or Clay",1,{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),\"-\",B:B)","v":"Fine Silt and/or Clay"},{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),NA(),C:C)","v":1}]
["A/B/C/D/E/F/G/H","Coarse to Fine Sand",2,"Coarse to Fine Sand",2]
["A/B/C/D/E/F/G/H","Coarse to Fine Gravel",3,"Coarse to Fine Gravel",3]
["A/B/C/D/E/F/G/H","Naturally occurring rock, stone (crushed or not)",4,"Naturally occurring rock, stone (crushed or not)",4]
["A/B/C/D/E/F/G/H","Ceramics - Concrete, Bricks, Mortar, Tiles, Clayware (crushed or not)",4,"Ceramics - Concrete, Bricks, Mortar, Tiles, Clayware (crushed or not)",4]
["A/B/C/D/E/F/G/H","Made Ground - Recycled Aggregate, Track Ballast",4,"Made Ground - Recycled Aggregate, Track Ballast",4]
[]
[null,"Respirable fibre index - RIVM report 711701034 (2003) "]
["Applicability Codes","All Items","All Scores","Applicable Items","Applicable Scores"]
["F/G/H","Negligible",0,{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),\"-\",B:B)","v":"-"},{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),NA(),C:C)","v":{"$error":"#N/A"}}]
["F/G/H","Very low",1,{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),\"-\",B:B)","v":"-"},{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),NA(),C:C)","v":{"$error":"#N/A"}}]
["C/E/H","Low",2,{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),\"-\",B:B)","v":"-"},{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),NA(),C:C)","v":{"$error":"#N/A"}}]
["B/C/D/E/H","Medium",3,{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),\"-\",B:B)","v":"-"},{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),NA(),C:C)","v":{"$error":"#N/A"}}]
["A/B/D/H","High",4,{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),\"-\",B:B)","v":"High"},{"$f":"IF(ISERROR(FIND(Code_ACM,$A:$A)),NA(),C:C)","v":4}]
[]
[null,"Probable Licensing Status"]
["Licence Sort Code","All Items"]
[1,"CAR do not apply","Very Low","CAR do not apply"]
[2,"Non-Licensed Work","Low","Non-Licensed Work"]
[3,"Notifiable Non-Licensed Work","Medium","Notifiable Non-Licensed Work"]
[4,"Licensed Work","High","Licensed Work"]
[]
["Work on asbestos coatings",{"$f":"IF(Work_Cat_ACM_Type = 'List Processing'!B10,4,\"\")","v":4}]
["Work on AIB >CL or not SALI",{"$f":"IF(Work_Cat_ACM_Type='List Processing'!B7, IF(Work_Cat_Air_Conc='List Processing'!B48,4,\"\"),\"\")","v":""}]
["Work on AI>CL or not SALI",{"$f":"IF(Work_Cat_ACM_Type='List Processing'!B9,IF(Work_Cat_Air_Conc='List Processing'!B48,4,\"\"),\"\")","v":""}]
["Short duration work on AIB",{"$f":"IF(Work_Cat_ACM_Type='List Processing'!B7,IF(Work_Cat_Exposure_Period='List Processing'!B53,2,\"\"),\"\")","v":""}]
["Short-duration work on AI",{"$f":"IF(Work_Cat_ACM_Type='List Processing'!B9,IF(Work_Cat_Exposure_Period='List Processing'!B53,2,\"\"),\"\")","v":""}]
["Short duration work on AIB",{"$f":"IF(Work_Cat_ACM_Type='List Processing'!B7,IF(Work_Cat_Exposure_Period='List Processing'!B54,2,\"\"),\"\")","v":""}]
["Short-duration work on AI",{"$f":"IF(Work_Cat_ACM_Type='List Processing'!B9,IF(Work_Cat_Exposure_Period='List Processing'!B54,2,\"\"),\"\")","v":""}]
["Not short-duration work on AIB",{"$f":"IF(Work_Cat_ACM_Type='List Processing'!B7,IF(Work_Cat_Exposure_Period='List Processing'!B56,4,\"\"),\"\")","v":""}]
["Not short-duration work on AI",{"$f":"IF(Work_Cat_ACM_Type='List Processing'!B9,IF(Work_Cat_Exposure_Period='List Processing'!B56,4,\"\"),\"\")","v":""}]
["Work on loose fibrous debris >CL or not SALI",{"$f":"IF(Work_Cat_ACM_Type='List Processing'!B8,IF(Work_Cat_Air_Conc='List Processing'!B48,4,\"\"),\"\")","v":""}]
["Work on unspecified fibrous board >CL or not SALI",{"$f":"IF(Work_Cat_ACM_Type='List Processing'!B5,IF(Work_Cat_Air_Conc='List Processing'!B48,4,\"\"),\"\")","v":""}]
["Any work >CL or not SALI",{"$f":"IF(Work_Cat_Air_Conc='List Processing'!B48,4,\"\")","v":""}]
["Maintenance tasks (not routine, not short duration)",{"$f":"IF(Work_Cat_Exposure_Period='List Processing'!B55,3,\"\")","v":""}]
["Maintenance tasks (routine, short duration)",{"$f":"IF(Work_Cat_Exposure_Period='List Processing'!B52,IF(Work_Cat_Friability='List Processing'!B22,2,\"\"),\"\")","v":""}]
["No degradation, no deterioration overide",{"$f":"IF(Work_Cat_Friability='List Processing'!B22,IF(AND(Work_Cat_Degradation_Extent='List Processing'!B15,Work_Cat_Activity_Type='List Processing'!B61),2,\"\"),\"\")","v":""}]
["No degradation, no deterioration overide",{"$f":"IF(Work_Cat_Friability='List Processing'!B22,IF(AND(Work_Cat_Degradation_Extent='List Processing'!B16,Work_Cat_Activity_Type='List Processing'!B61),2,\"\"),\"\")","v":""}]
["Very low levels of ACM/fibres overide",{"$f":"IF(OR(Work_Cat_Degradation_Extent='List Processing'!B17,Work_Cat_Degradation_Extent='List Processing'!B18),IF(Work_Cat_Amount='List Processing'!B38,2,\"\"),\"\")","v":2}]
["Low levels of ACM/fibres overide",{"$f":"IF(OR(Work_Cat_Degradation_Extent='List Processing'!B17,Work_Cat_Degradation_Extent='List Processing'!B18),IF(OR(Work_Cat_Amount='List Processing'!B39,Work_Cat_Amount='List Processing'!B38),2,3),\"\")","v":2}]
["Sampling overide",{"$f":"IF(Work_Cat_Activity_Type='List Processing'!B60,IF(Work_Cat_Air_Conc='List Processing'!B48,\"\",2),\"\")","v":2}]
["Sampling overide",{"$f":"IF(Work_Cat_Activity_Type='List Processing'!B63,IF(Work_Cat_Air_Conc='List Processing'!B48,\"\",2),\"\")","v":""}]
["Trace overide",{"$f":"IF(Work_Cat_Amount='List Processing'!B37,1,\"\")","v":""}]
[null,"Final Status:",{"$f":"MAX(B91:B109)","v":4},{"$f":"IF(B111=1,D86,IF(B109=2,D87,IF(B110=2, D87,IF(B104=2,D87,IF(C112=0,VLOOKUP(Work_Cat_Combined_Rank,'List Processing'!C86:D89,2,FALSE),VLOOKUP(C112,LookupTable_LicStatus,2,FALSE))))))","v":"Non-Licensed Work"}]
[]
["Sampling flag",{"$f":"IF(OR(Work_Cat_Activity_Type='List Processing'!B60,Work_Cat_Activity_Type='List Processing'!B63),1,\"\")","v":1}]
["Short duration work",{"$f":"IF(OR(Work_Cat_Exposure_Period='List Processing'!B53,Work_Cat_Exposure_Period='List Processing'!B54),1,\"\")","v":""}]
[]
[]
[null,"RPE"]
["CAR do not apply","None"]
["Non-Licensed Work","EN149 type FFP3 disposable"]
["Notifiable Non-Licensed Work","EN140 with P3 filter half mask"]
["Licensed Work","EN136 with P3 filter full face mask"]
[]
[null,"Dust Suppression"]
["CAR do not apply","None"]
["Non-Licensed Work","Manual/localised dust suppression"]
["Notifiable Non-Licensed Work","Localised mechanical dust suppression"]
["Licensed Work","General mechanical dust suppression"]
[]
[null,"Hygiene/Welfare"]
["CAR do not apply","None"]
["Non-Licensed Work","Localised and basic personal decontamination facilities"]
["Notifiable Non-Licensed Work","Localised and enhanced personal decontamination facilities"]
["Licensed Work","Mobile self-contained personal decontamination facilities"]
[]
[]
[null,"Stage 1"]
["Score","Rank"]
[0,"Negligible"]
[1,"Very low"]
[2,"Very low"]
[3,"Very low"]
[4,"Very low"]
[5,"Very low"]
[6,"Low"]
[7,"Low"]
[8,"Low"]
[9,"Low"]
[10,"Low"]
[11,"Medium"]
[12,"Medium"]
[13,"Medium"]
[14,"Medium"]
[15,"Medium"]
[16,"High"]
[17,"High"]
[18,"High"]
[19,"High"]
[20,"High"]
[]
[null,"Stage 2"]
["Score","Rank"]
[1,"Very low"]
[2,"Very low"]
[3,"Very low"]
[4,"Very low"]
[5,"Very low"]
[6,"Low"]
[7,"Low"]
[8,"Low"]
[9,"Low"]
[10,"Low"]
[11,"Medium"]
[12,"Medium"]
[13,"Medium"]
[14,"Medium"]
[15,"Medium"]
[16,"High"]
[17,"High"]
[18,"High"]
[19,"High"]
[20,"High"]
[]
[null,"Stage 3"]
["Score","Rank"]
[0,"Negligible"]
[1,"Very low"]
[2,"Very low"]
[3,"Very low"]
[4,"Very low"]
[5,"Very low"]
[6,"Very low"]
[7,"Very low"]
[8,"Very low"]
[9,"Very low"]
[10,"Very low"]
[11,"Low"]
[12,"Low"]
[13,"Low"]
[14,"Low"]
[15,"Low"]
[16,"Low"]
[17,"Low"]
[18,"Low"]
[19,"Low"]
[20,"Low"]
[21,"Medium"]
[22,"Medium"]
[23,"Medium"]
[24,"Medium"]
[25,"Medium"]
[26,"Medium"]
[27,"Medium"]
[28,"Medium"]
[29,"Medium"]
[30,"Medium"]
[31,"High"]
[32,"High"]
[33,"High"]
[34,"High"]
[35,"High"]
[36,"High"]
[37,"High"]
[38,"High"]
[39,"High"]
[40,"High"]
[]
[null,"RPE"]
["Very Low","None"]
["Low","EN149 type FFP3 disposable"]
["Medium","EN140 with P3 filter half mask"]
["High","EN136 with P3 filter full face mask"]
[]
[]
[null,"Dust Suppression"]
["Very Low","None"]
["Low","Manual/localised dust suppression"]
["Medium","Localised mechanical dust suppression"]
["High","General mechanical dust suppression"]
[]
[]
[null,"Hygiene/Welfare"]
["Very Low","None"]
["Low","Localised and basic personal decontamination facilities"]
["Medium","Localised and enhanced personal decontamination facilities"]
["High","Mobile self-contained personal decontamination facilities"]