I think that a 500 chapter book would be daunting. I would suggest it
be Chapters that cover a group of similar functions. Ones that only vary
slightly or have a common purpose. An example would be all the
amortization, future values, payment amount, and so on.
I do think that the functions need more explanation and examples of how
to be used. I also think that these functions will not change
significantly over the years so a stand alone volume of Calc Functions
would be a good way to go.
John Hart
On 3/17/20 14:46, toki.kant...@gmail.com wrote:
On 13/03/20 5:14 pm, Stephen Fanning wrote:
I would like to hear the opinions of members of the Documentation Team on a
potential improvement to the Calc Guide.
As you probably know, Calc provides a library of over 500 functions. The
6.2 Calc Guide includes an Appendix B entitled Description of Functions
which occupies over 70 pages (not an enjoyable read!).
My suggestion is to break Appendix B out into a book of its own, with
each function having its own chapter. Each chapter provides:
* Where and when the function would usually be used;
* When the function should not be used;
* The limitations of the various variables within the function;
* Where the function fails, and what to do, when it does fail;
I've started writing such a critter several times, but get side tracked
by other things that are semi-documented/undocumented/incorrectly
documented. This is an addition to finding work-arounds for things that
LibO can't do. (Shinji Enoki merely scratched the surface, in his talk
at Almeria last year.)
Jacques Tiberghien
_The Pascal Handbook_.
Sybex INC: 1981
ISBN: 0-89588-053-9
is the guide example I'm following.
But
B Held & T Richardson
_Microsoft Excel Functions and Formulas, Third edition_
Dulles VA: Mercury Learning and Information: 2015
ISBN: 978-1-937585-50-1
as does a book called something like _100 Formulas for Excel_.
(I can't find it on my drive. I'm running a script within Calibre, so it
isn't accessible, to find the correct title, or publication data.)
are pointers towards what I'm envisioning.
In an ideal world, we'd have
* LibreOffice For the Biological Sciences;
* LibreOffice For Business Statistics;
* LibreOffice For Educational and Psychological Statistics;
* LibreOffice For Engineering Statistics;
* LibreOffice For Environmental Sciences and Statistics;
* LibreOffice For Health Services management Statistics;
* LibreOffice For Human Resource Statistics;
* LibreOffice For Marketing Statistics;
* LibreOffice For Social Science Statistics;
* LibreOffice For Data Analysis;
* LibreOffice For Project Management;
* LibreOffice For Financial Analysis;
* LibreOffice For Economic Appraisal and Forecasting;
* LibreOffice For Stock Market Analysis;
* LibreOffice For Financial Simulation Modelling;
FWIW, I simply substituted "Excel" or "Excel 2016" with LibreOffice, to
create those titles.
jonathon
--
To unsubscribe e-mail to: documentation+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
Privacy Policy: https://www.documentfoundation.org/privacy
