Re: [libreoffice-users] Large spreadsheet does not open in LibreOffice.

On 14/11/2015 17:43, Harvey Nimmo wrote:

> > ^1: More than one researcher has argued that The Human Genome Project
was a complete waste of money, time, and effort,
> It would be interesting to have some references for this claim

Which claim:
* That researchers called the Human Genome Project a waste of money,
time, etc;
* That Excel destroys data by silent transformation;
* Something else;

Regardless, here are some pages that discuss known errors in using
spreadsheets:
* http://panko.shidler.hawaii.edu/SSR/Mypapers/whatknow.htm;
* http://www.eusprig.org/horror-stories.htm;
* http://www.eusprig.org/stories.htm
*
http://www.strategy-at-risk.com/2009/03/03/the-risk-of-spreadsheet-errors/;
* http://www.excellentones.com/resources/spreadsheet-mistakes.html;
* http://www.pages.drexel.edu/~bdm25/excel2007.pdf
*
http://andrewgelman.com/2013/04/16/memo-to-reinhart-and-rogoff-i-think-its-best-to-admit-your-errors-and-go-on-from-there/

Doing a cut and paste from a /. about the deficits of spreadsheets in
statistical analysis.

author = {Yalta, A.T.},
title = {The accuracy of statistical distributions in Microsoft® Excel
2007},
journal = {Computational Statistics and Data Analysis},

author = {B.D. McCullough and David A. Heiser},
title = {On the accuracy of statistical procedures in Microsoft Excel 2007},
journal = {Computational Statistics \& Data Analysis},

author = {B.D. McCullough},
title = {Special section on Microsoft Excel 2007},
journal = {Computational Statistics \& Data Analysis},

author = {Altman,Micah and McDonald,Michaell P.},
title = {Choosing Reliable Statistical Software},
journal = {PS: Political Science \& Politics},

author = {B. D. McCullough and Berry Wilson},
title = {On the accuracy of statistical procedures in Microsoft Excel 97},
journal = {Computational Statistics \& Data Analysis},

And for a fun read, http://www2.odn.ne.jp/~cbl97790/kakikataJO.htm

jonathon




-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted