[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [libreoffice-documentation] Possible improvement to Calc Guide

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.kantoor@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.

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.


To unsubscribe e-mail to: documentation+unsubscribe@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

Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.