Is there a spec requirement for Excel for use with Sailwave NHC?
I normally do the scoring at home on my desktop, which has Office 2010.
We have racing tomorrow (Sunday), for which I have to complete the scoring at the club in order to hand out the trophy, using a laptop with Office 2003
However, using external mode on the laptop, the NHC scoring doesn't work - many of the excel columns are populated with #NAME?
I'm using external mode as my ratings are in Portsmouth format.
As I see it, I can either convert ratings to the other (fractional) format to use internal mode, or to source another laptop.
···
--
regards,
Malcolm Osborne
Rondevlei, South Africa
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
Hi Malcom - 2007 onwards is fine - for 2003 you have to change the formula for the standard deviation. Someone posted a while ago an alternative for the 2003. If you can use the internal then that doesn’t need Excel.
MS changed the formula names for the Standard Deviation
Jon
···
On 27 January 2018 at 23:03, Malcolm Osborne malcolmo@telkomsa.net [sailwave] sailwave@yahoogroups.com wrote:
Is there a spec requirement for Excel for use with Sailwave NHC?
I normally do the scoring at home on my desktop, which has Office 2010.
We have racing tomorrow (Sunday), for which I have to complete the
scoring at the club in order to hand out the trophy, using a laptop with
Office 2003
However, using external mode on the laptop, the NHC scoring doesn’t
work - many of the excel columns are populated with #NAME?
I’m using external mode as my ratings are in Portsmouth format.
As I see it, I can either convert ratings to the other (fractional)
format to use internal mode, or to source another laptop.
–
regards,
Malcolm Osborne
Rondevlei, South Africa
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
Jon Eskdale
07530 112233
Skype “eskdale”
Found the previous post - I’ve not tested it - Jon
13/08/2017
to sailwave
For those who may be still using an older version of Excel the equivalent function for “=STDEV.P(S9:S49)” is “=STDEVP(S9:S49)”
Cheers,
Alan.
A quick search on the internet found that STDEVP works for ALL versions
of Excel (for backward compatibility) whereas STDEV.P only works on
later versions. The version to use in any spreadsheets being circulated
to others should be clear. Standard Excel macro programming protocols
indicate to use the version that will work for everyone.
···
On 1/27/2018 3:36 PM, jon@sailwave.com [sailwave] wrote:
Found the previous post - I've not tested it - Jon
Al alanky@tpg.com.au [sailwave] <sailwave@yahoogroups.com>
13/08/2017
to sailwave
For those who may be still using an older version of Excel the
equivalent function for "=STDEV.P(S9:S49)" is "=STDEVP(S9:S49)"
Cheers,
Alan.
Hi Art thank you for your post but as it turns out they are not identical and so would require verification (Although its very likely it will work)
STDEV.P and STDEVP differ only in the way they handle text and logical values that are supplied as a part of an array or range of cells. So could produce different results
STDEVP has also been deprecated and it is bad practice to issue new programs using deprecated functions. In Microsoft’s words you should be using the new functions from now on, because this function may not be available in future versions of Excel. So the clear version in my opinion that should be used is the STDEV.P
At the time of writing the spreadsheet I was not aware of the old version anyway as documentation for the Excel I was using lists STDEV.P as the function to use.
Jon
···
On 28 January 2018 at 08:53, Art Engel art@racingrules.org [sailwave] sailwave@yahoogroups.com wrote:
A quick search on the internet found that STDEVP works for ALL versions
of Excel (for backward compatibility) whereas STDEV.P only works on
later versions. The version to use in any spreadsheets being circulated
to others should be clear. Standard Excel macro programming protocols
indicate to use the version that will work for everyone.
On 1/27/2018 3:36 PM, jon@sailwave.com [sailwave] wrote:
Found the previous post - I’ve not tested it - Jon
Al alanky@tpg.com.au [sailwave] sailwave@yahoogroups.com
13/08/2017
to sailwave
For those who may be still using an older version of Excel the
equivalent function for “=STDEV.P(S9:S49)” is “=STDEVP(S9:S49)”
Cheers,
Alan.
Jon Eskdale
03333 443377
07530 112233