[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [libreoffice-documentation] Possible improvement to Calc Guide
- Subject: Re: [libreoffice-documentation] Possible improvement to Calc Guide
- From: jlhart68 <email@example.com>
- Date: Tue, 17 Mar 2020 17:33:07 -0400
- To: firstname.lastname@example.org, email@example.com
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.
On 3/17/20 14:46, firstname.lastname@example.org 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 aMy suggestion is to break Appendix B out into a book of its own, with
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!).
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.)
_The Pascal Handbook_.
Sybex INC: 1981
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
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: email@example.com
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/documentation/
|[libreoffice-documentation] Possible improvement to Calc Guide||Stephen Fanning <firstname.lastname@example.org>|
|Re: [libreoffice-documentation] Possible improvement to Calc Guideemail@example.com|
- Prev by Date: Re: [libreoffice-documentation] Getting Started Guide for LO 6.4
- Next by Date: [libreoffice-documentation] Writer Guide 6.4
- Previous by thread: Re: [libreoffice-documentation] Possible improvement to Calc Guide
- Next by thread: [libreoffice-documentation] LO Help files - potential improvements