It should clearly be withdrawn until it has been debugged - whatever happened to beta testing and peer review. Amateurish at best.
Regards,
Mike Smith
Sent from my iPad
> On 28 Aug 2015, at 09:13, [log in to unmask] wrote:
>
> Morning all.
>
> Whilst I am really enjoying the master class in Excel, would it not make sense to send a copy of the corrected software back to its originators for re-uploading to the website ?
>
> I am sure the level of tweaking the software needs will have many of us tied up in knots......
>
> Cheers
>
> Steve
>
> -----Original Message----- From: Clive Williams
> Sent: Friday, August 28, 2015 8:37 AM
> To: [log in to unmask]
> Subject: Re: Government publishes new version of CLEA software
>
> Thanks Lauren, I think I've fixed mine. Its a good job they decided to publish it without protection.
>
> I think that what has happened is that in including the option to select the 90%ile for the 2 chosen food crops they have forgotten to copy across the VLookup formula so that the VLookup command for the soil to dust transport factor was still trying to load the value from column 63 (which is now a Yes or a No) rather than column 69 where the correct number now lives.
>
> At least I've now learnt how to unhide worksheets, although I'll probably have forgotten how by the next time I need to.
>
> Cheers
> Clive
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 2015.0.6125 / Virus Database: 4409/10528 - Release Date: 08/28/15
|