[libreoffice-users] Re: Using and Formatting Logical Functions in Calc

On 6/30/12 5:28 AM, Dan wrote:
>        When it comes to databases, it is always a matter of planning and
> designing. Doing this correctly may result in a subcompact car rather
> than a Mack truck for a simple database. Obviously, when you want more a
> more complex output, it will increase in complexity.

That is so true.  You have to cover all of the "bases" of what your want 
to be able to do with the data before you even begin to design.

What frustrates me is there seems to be very few "simple and easy" to 
grasp and use database programs anymore.  Everything is migrating to the 
power that MS Access (the Mack truck) has, when possibly all you need is 
an electronic 3X5 file card system (compact pickup).

I was going to create a simple relational database for my inlaws, but it 
didn't require the complexity and sophistication of Access.  I thought 
I'd found one, I knew exactly what I wanted and needed it to do, but 
when I got far enough along, I found out the reporting section couldn't 
access data from multiple databases.  That did me no good.

>        I would think that the same thing holds for creating a
> spreadsheet: take the time to plan and design what you want. This plan
> must contain enough detail to describe every function to be used in the
> spreadsheet, and the functions' input requirements and output
> characteristics. Without a good plan and design, the results are likely
> to be rather poor. Problems are likely that have to be corrected which
> takes time and can create frustration.

As I just wrote to Andreas, it wasn't the logic or anything else that 
was the issue, it was how to get it correctly entered that was the 
problem.  And I personally didn't find the Function Wizard to be that 
helpful the first time out.  I found it easier to just experiment 
manually entering various combinations till I found the answer.  Maybe 
that way was easier for me, as the first spreadsheet I ever used was 
VisiCalc for the Atari 800.


--
Ken

Mac OS X 10.6.8
Firefox 13.0.1
Thunderbird 13.0.1
LibreOffice 3.5.2.2




--
For unsubscribe instructions e-mail to: users+help@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