Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index

Am 06.02.2012 18:24, Paul D. Mirowsky wrote:
Everybody knows how write simple math statement as a formula. Everybody
doesn't know how to right an SQL statement.

"My users" can not fill out spreadsheets properly. They have no idea how to write formulas, they don't understand cell formats, subtile input methods nor do they want to expand any formulas for growing lists.

Even for the most simple protocols and item inventories I provide them a set of input forms. They pick options from list boxes, write dates into date fields (or pick them from a calendar), check boolean options, type numbers into numeric fields and remarks into multi-line boxes.
Automatic time stamps and user names are not even visible.
I use to keep older versions of my forms so everybody can choose the preferred input form for the job. For each virtual item they use, they see who has introduced it at which time, who else used that item today and how many items are left. "My users" never have to think about storing any file in some file format. Every record is stored on a server when they move to another record unless the record is invalid. "My users" update/insert/delete full records without bothering about references nor formattings. When you pull the plug out of the wall the currently edited record is the maximum you lose. When they want to print something, they hit a button which generates a spreadsheet from template with charts and formulas dumping the requested data into preformatted import range(s) and print areas.
The whole system works with a tiny amount of macro programming.

For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


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.