README_2.txt for au_nz_uk_merged_twa_bio_2.zip Revision 2 files (Rev 1 files were removed on 1 May 2020. Available on request) Files are automatically recreated during data pumping operations and duplicates are merged and removed. These Rev 2 files represent the adjusted input data imported into the production SharedSDS database on 9 April 2020. ================================================================================= If you have trouble downloading a zip file please get in touch and we can provide an alternative facility. Files in the zip include this file plus ... merged_au_nz_uk_twa_2.csv merged_au_nz_uk_twa_2.xlsx merged_nz_uk_bio_2.csv merged_nz_uk_bio_2.xlsx output_hse_eh40_bmgv_2020_2.csv (UK bio) output_hse_eh40_wel_2020_2.csv (UK twa) output_hswa_bei_2019_2.csv (NZ bio) output_hswa_wes_2019_2.csv (NZ twa) output_swa_wes_2019_2.csv (Au twa) All csv files here use the vertical bar ( | ) as field separator and all fields are delimited with double quotation marks (" "). Excel or LibreOffice spreadsheets are available for output_ files on request. --------------------------------------------------------------------------------- All the information is publically available[1]. We thank and hereby acknowledge UK government copyright licensed under the Open Government Licence v3.0; NZ government copyright licensed under the Creative Commons Attribution-Non-commercial 3.0 NZ Licence; and Australian government copyright licensed under the Creative Commons Attribution 4.0 International Licence. These spreadsheets have been tweaked from original pdf files published by their respective governments. The changes include making substance names more consistent across all spreadsheets. This we believe has corrected some published errors but may have inadvertently introduced other errors. We hope they are reported if seen. Some substance names in the originals are repeated for different types of contaminant which have different twa/stel values. We have merged that data and labelled each value accordingly. For example in the original Australian pdf ... +-------------------------------+-----------------+----------+----+----+----+-----+---+----+--+ | Ethylene glycol (particulate) | Ethane-1,2-diol | 107-21-1 | - | 10 | - | - | - | Sk | | +-------------------------------+-----------------+----------+----+----+----+-----+---+----+--+ | Ethylene glycol (vapour) | Ethane-1,2-diol | 107-21-1 | 20 | 52 | 40 | 104 | - | Sk | | +-------------------------------+-----------------+----------+----+----+----+-----+---+----+--+ In the output file this has been adjusted to a single entry for Ethylene glycol which has been duplicated for its synonym Ethane-1,2-diol and the 'Sk' code has been decoded in the note column. It can be seen that the particulate value of 10 mg/m3 has been identified alongside the value of 52 for the vapour. +----+-----------------+----------+-----------+---------------------------+-----------+------------+--------------------------------------------------------------------------------------------------+ | au | Ethylene glycol | 107-21-1 | 20 vapour | 10 particulate, 52 vapour | 40 vapour | 104 vapour | See also Ethane-1,2-diol \n Absorption through the skin may be a significant source of exposure. | +----+-----------------+----------+-----------+---------------------------+-----------+------------+--------------------------------------------------------------------------------------------------+ | au | Ethane-1,2-diol | 107-21-1 | 20 vapour | 10 particulate, 52 vapour | 40 vapour | 104 vapour | See also Ethylene glycol \n Absorption through the skin may be a significant source of exposure. | +----+-----------------+----------+-----------+---------------------------+-----------+------------+--------------------------------------------------------------------------------------------------+ Our reasoning for this type of adjustment is that when a substance is searched for and found, all the pertinent data is seen. Otherwise it is possible some people may not even realise that a second search is necessary to discover the other values. Obviously this isn't a consideration with a printed copy of the original document but for computer-based operations it becomes important. The data is now imported into the SharedSDS database. The merged spreadsheets have been sorted. Sadly the sort algorithm places names starting with numerals ahead of all other names. One day we might write a chemical name sort. Your co-operation in reporting any errors you see will be greatly appreciated. Errors will be promptly fixed, files will be replaced and notification emailed to those on our shared@sharedsds.com mailing list. Please ask to be included on that list so you are not left with out-of-date or incorrect information. Mike Dewhirst Director Climate Pty Ltd +61(0)3 9034 3977 +61(0)411 704 143 [1] URLs for the respective pdf source files https://www.safeworkaustralia.gov.au/doc/workplace-exposure-standards-airborne-contaminants https://worksafe.govt.nz/topic-and-industry/work-related-health/monitoring/exposure-standards-and-biological-exposure-indices/ https://www.hseni.gov.uk/publications/eh402005-workplace-exposure-limits [2] Changes for Revision 2 In addition to the changes listed below, Revision 2 has the three words "creatinine in urine" in the Biological Determinant column copied to the Guidance Value column for all applicable rows in the UK BMGV spreadsheet. In splitting the single column we have decided to make it abundantly clear that considering creatinine in urine is part of the guidance value as well as part of the determinant. Repaired (up to 4 letter) acronyms to all upper case eg Tdi to TDI everywhere Changed 2-(2-Methoxyethoxy) ethanol ...to... 2-(2-Methoxyethoxy)ethanol (UK WEL) Changed (2-Methoxymethylethoxy) propanol ...to... (2-Methoxymethylethoxy)propanol (UK WEL) Added 1,1'-Dimethyl-4,4'-bipyridinium dichloride as a synonym for Paraquat dichloride for consistency with Au and NZ (UK WEL) Added "Styrene, monomer" and "Styrol" as synonyms for Styrene for consistency with Au and NZ (UK WEL) Added PAH as a synonym for Polycyclic aromatic hydrocarbons (UK BMGV) Changed Dichlorodiphenyl-trichloroethane ...to... Dichlorodiphenyltrichloroethane (Au WES) Changed p,p-Dichlorodiphenyl trichloroethane ...to... p,p'-Dichlorodiphenyltrichloroethane (Au WES) Changed 2,2-bis(p-Chlorophenyl)-1,1,1 trichloroethane ...to... 2,2-bis(p-Chlorophenyl)-1,1,1-trichloroethane (Au WES) Changed 1,1,1-Trichloro bis(chlorophenyl) ethane ...to... 1,1,1-Trichloro-2,2-bis(p-chlorophenyl)ethane (Au WES) Changed (2-Methoxymethylethoxy) propanol ...to... (2-Methoxymethylethoxy)propanol (Au WES)