Dear all
Just to note, it appears the plant 'model' cell does not work for any new organic contaminants on the soil-to-plant concentration factor. When you go to the 'chemical data' it says 'model' but when you run the model it does not appear to work. Not sure how to fix that one.
Paul
Dr Paul Quimby (PhD, BSC (hons), CSci, MIEnvSc)
Technical Director
0161 763 7200 - 07912 894078 www.thelkgroup.com
Manchester | Liverpool | Glasgow
Disclaimer Information Here
-----Original Message-----
From: Contaminated Land Management Discussion List [mailto:[log in to unmask]] On Behalf Of Dombowsky, Lauren
Sent: 27 August 2015 17:28
To: [log in to unmask]
Subject: Re: Government publishes new version of CLEA software
Hi Paul,
I have found the same thing. I fixed it by unhiding and unprotecting the sheet 'Chemical Data' and correcting the vlookups so that it picks up the correct cells. In that sheet, you can see that there are no vlookups for user chemicals under the 'Top two' columns and the vlookups pick up the wrong column number in the columns to the right of the Top 2.
Kind regards,
Lauren Dombowsky
Graduate Environmental Scientist, Water, Ground and Environment
ATKINS
Explore our world of opportunities - www.atkinsglobal.com/careers
Epsom Gateway, 2 Ashley Avenue, Epsom, Surrey, KT18 5AL | Tel: +44 1372 756024
Email: [log in to unmask] Web: www.atkinsglobal.com | Careers: www.atkinsglobal.com/careers
-----Original Message-----
From: Contaminated Land Management Discussion List [mailto:[log in to unmask]] On Behalf Of Paul Quimby
Sent: 27 August 2015 16:55
To: [log in to unmask]
Subject: Re: Government publishes new version of CLEA software
Dear members
I anyone having trouble putting in new contaminants and running the model. It seems the cells don't get propagated properly from the top 2 cells onwards and an error occurs. Even if you manually change the cells that are not propagated properly the model doesn't run.
Paul
Dr Paul Quimby (PhD, BSC (hons), CSci, MIEnvSc) Technical Director
0161 763 7200 - 07912 894078 www.thelkgroup.com Manchester | Liverpool | Glasgow
Disclaimer Information Here
-----Original Message-----
From: Contaminated Land Management Discussion List [mailto:[log in to unmask]] On Behalf Of Paul Nathanail
Sent: 24 August 2015 19:08
To: [log in to unmask]
Subject: Government publishes new version of CLEA software
Dear all,
The long-heralded update to the CLEA software (v 1.07) was finally published on the .gov.uk website today.
The web page is a bit messy - it purports to provide a link to v1.06 but the .XLS spreadsheet downloaded says it is v1.07. I have reported this 'feature' to the webmasters of .gov.uk
Details of what has changed between v1.06 and v1.07 are hard to find; only by clicking on the 'full page history' could I see the following advisory:
"24 August 2015 3:59pm CLEA Software update. Version 1.07 incorporates the approach and library data sets to support the outcome of the Defra Category 4 Screening Levels research project and is now Open Government Licence. "
This seems at odds with the statement on the main page that " The handbook referring to version 1.05 is still valid as the functionality has not changed." I have also reported this to the .gov.uk webmasters.
Anyway, I am sure all will become CLEArer in due course,
Happy risk assessing!
Paul
PS The link to the CLEA web pages is:
https://www.gov.uk/government/publications/contaminated-land-exposure-assessment-clea-tool
___________________________________________________________________________
The IS team in Atkins has scanned this email and any attachments for viruses and other threats; however no technology can be guaranteed to detect all threats. Always exercise caution before acting on the content of an email and before opening attachments or following links contained within the email.
This email and any attached files are confidential and copyright protected. If you are not the addressee, any dissemination of this communication is strictly prohibited. Unless otherwise expressly agreed in writing, nothing stated in this communication shall be legally binding.
The ultimate parent company of the Atkins Group is WS Atkins plc. Registered in England No. 1885586. Registered Office Woodcote Grove, Ashley Road, Epsom, Surrey KT18 5BW. A list of wholly owned Atkins Group companies registered in the United Kingdom and locations around the world can be found at http://www.atkinsglobal.com/site-services/group-company-registration-details
Consider the environment. Please don't print this e-mail unless you really need to.
|