Quantcast

Using and Formatting Logical Functions in Calc

classic Classic list List threaded Threaded
36 messages Options
12
snowshed snowshed
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Using and Formatting Logical Functions in Calc

Is there a more detailed set of examples of using the functions
anywhere?  The Help Files have a general outline of each, but only very
generic examples of how to use them.

I need to nest some of the functions, if that's possible.

--
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: [hidden email]
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

Dan Lewis Dan Lewis
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: Using and Formatting Logical Functions in Calc

Ken Springer wrote:
> Is there a more detailed set of examples of using the functions
> anywhere?  The Help Files have a general outline of each, but only
> very generic examples of how to use them.
>
> I need to nest some of the functions, if that's possible.
>
      Have you downloaded the Calc Guide. These things should be in one
of the chapters or appendices.

--Dan

--
For unsubscribe instructions e-mail to: [hidden email]
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

Jay Lozier Jay Lozier
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: Using and Formatting Logical Functions in Calc

In reply to this post by snowshed
Ken,

On 06/27/2012 07:24 PM, Ken Springer wrote:
> Is there a more detailed set of examples of using the functions
> anywhere?  The Help Files have a general outline of each, but only
> very generic examples of how to use them.
>
> I need to nest some of the functions, if that's possible.
>
Generally you can nest functions several levels deep in any spreadsheet.
Typically the maximum is 7 levels but I would not go beyond about 3
because it becomes to difficult to follow the logic. You could have
something like =if( (x or y), if( (a and b),
sum(d:d),average(d:d)),stdev(d:d)).

--
Jay Lozier
[hidden email]


--
For unsubscribe instructions e-mail to: [hidden email]
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

snowshed snowshed
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: Using and Formatting Logical Functions in Calc

In reply to this post by Dan Lewis
On 6/27/12 5:48 PM, Dan wrote:
> Ken Springer wrote:
>> Is there a more detailed set of examples of using the functions
>> anywhere?  The Help Files have a general outline of each, but only
>> very generic examples of how to use them.
>>
>> I need to nest some of the functions, if that's possible.
>>
>        Have you downloaded the Calc Guide. These things should be in one
> of the chapters or appendices.

Hi, Dan.

I haven't checked the Calc Guide, but if it's similar to the Writer
Guide, it won't go to the depth I'm interested in.  :-(


--
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: [hidden email]
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

Dan Lewis Dan Lewis
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: Using and Formatting Logical Functions in Calc

Ken Springer wrote:

> On 6/27/12 5:48 PM, Dan wrote:
>> Ken Springer wrote:
>>> Is there a more detailed set of examples of using the functions
>>> anywhere?  The Help Files have a general outline of each, but only
>>> very generic examples of how to use them.
>>>
>>> I need to nest some of the functions, if that's possible.
>>>
>>        Have you downloaded the Calc Guide. These things should be in one
>> of the chapters or appendices.
>
> Hi, Dan.
>
> I haven't checked the Calc Guide, but if it's similar to the Writer
> Guide, it won't go to the depth I'm interested in.  :-(
      But you won't know until you look will you? Guessing the content
based upon another guide might be a mistake.

--Dan



--
For unsubscribe instructions e-mail to: [hidden email]
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

snowshed snowshed
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: Using and Formatting Logical Functions in Calc

In reply to this post by Jay Lozier
On 6/27/12 6:43 PM, Jay Lozier wrote:

> Ken,
>
> On 06/27/2012 07:24 PM, Ken Springer wrote:
>> Is there a more detailed set of examples of using the functions
>> anywhere?  The Help Files have a general outline of each, but only
>> very generic examples of how to use them.
>>
>> I need to nest some of the functions, if that's possible.
>>
> Generally you can nest functions several levels deep in any spreadsheet.
> Typically the maximum is 7 levels but I would not go beyond about 3
> because it becomes to difficult to follow the logic. You could have
> something like =if( (x or y), if( (a and b),
> sum(d:d),average(d:d)),stdev(d:d)).

Hi, Jay,

It's the actual syntax of the nesting I'm interested in.  I've learned
the syntax varies from one to another, and Calc seems to be slightly
different than Excel, which I used years ago.

Trying to avoid a lot of blind trial and error.   LOL

As for the number of levels, I used to know a guy who hated Excel
because there was a nesting limit.  But he loved Quattro Pro because
there were no nesting level limits.


--
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: [hidden email]
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

snowshed snowshed
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: Using and Formatting Logical Functions in Calc

In reply to this post by Dan Lewis
On 6/27/12 7:57 PM, Dan wrote:

> Ken Springer wrote:
>> On 6/27/12 5:48 PM, Dan wrote:
>>> Ken Springer wrote:
>>>> Is there a more detailed set of examples of using the functions
>>>> anywhere?  The Help Files have a general outline of each, but only
>>>> very generic examples of how to use them.
>>>>
>>>> I need to nest some of the functions, if that's possible.
>>>>
>>>         Have you downloaded the Calc Guide. These things should be in one
>>> of the chapters or appendices.
>>
>> Hi, Dan.
>>
>> I haven't checked the Calc Guide, but if it's similar to the Writer
>> Guide, it won't go to the depth I'm interested in.  :-(
>        But you won't know until you look will you? Guessing the content
> based upon another guide might be a mistake.

Didn't mean that to sound like I wasn't going to check it out.  Call it
getting old and finding my expectations of useability of vendor supplied
publications over the years to be lacking what I want to know.   :-)


--
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: [hidden email]
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

Jay Lozier Jay Lozier
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: Using and Formatting Logical Functions in Calc

In reply to this post by snowshed
On 06/27/2012 09:58 PM, Ken Springer wrote:

> On 6/27/12 6:43 PM, Jay Lozier wrote:
>> Ken,
>>
>> On 06/27/2012 07:24 PM, Ken Springer wrote:
>>> Is there a more detailed set of examples of using the functions
>>> anywhere?  The Help Files have a general outline of each, but only
>>> very generic examples of how to use them.
>>>
>>> I need to nest some of the functions, if that's possible.
>>>
>> Generally you can nest functions several levels deep in any spreadsheet.
>> Typically the maximum is 7 levels but I would not go beyond about 3
>> because it becomes to difficult to follow the logic. You could have
>> something like =if( (x or y), if( (a and b),
>> sum(d:d),average(d:d)),stdev(d:d)).
>
> Hi, Jay,
>
> It's the actual syntax of the nesting I'm interested in.  I've learned
> the syntax varies from one to another, and Calc seems to be slightly
> different than Excel, which I used years ago.
>
> Trying to avoid a lot of blind trial and error.   LOL
>
> As for the number of levels, I used to know a guy who hated Excel
> because there was a nesting limit.  But he loved Quattro Pro because
> there were no nesting level limits.
>
>
Hi, Ken

I have not noticed any major differences in the nesting syntax for my
needs between Calc and Excel. But that does not mean there are none.

--
Jay Lozier
[hidden email]


--
For unsubscribe instructions e-mail to: [hidden email]
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

Tom Tom
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: Using and Formatting Logical Functions in Calc

In reply to this post by snowshed
Hi :)
This link has the guides but also has links to 3rd party documentation and stuff
https://wiki.documentfoundation.org/Documentation/Publications
The official guides are uploaded there before officially released on the website and individual chapters are there before they get put together to form the entire book. 

So, smaller targeted downloads :)
Regards from
Tom :) 



--- On Thu, 28/6/12, Ken Springer <[hidden email]> wrote:

From: Ken Springer <[hidden email]>
Subject: [libreoffice-users] Re: Using and Formatting Logical Functions in Calc
To: [hidden email]
Date: Thursday, 28 June, 2012, 3:06

On 6/27/12 7:57 PM, Dan wrote:

> Ken Springer wrote:
>> On 6/27/12 5:48 PM, Dan wrote:
>>> Ken Springer wrote:
>>>> Is there a more detailed set of examples of using the functions
>>>> anywhere?  The Help Files have a general outline of each, but only
>>>> very generic examples of how to use them.
>>>>
>>>> I need to nest some of the functions, if that's possible.
>>>>
>>>         Have you downloaded the Calc Guide. These things should be in one
>>> of the chapters or appendices.
>>
>> Hi, Dan.
>>
>> I haven't checked the Calc Guide, but if it's similar to the Writer
>> Guide, it won't go to the depth I'm interested in.  :-(
>        But you won't know until you look will you? Guessing the content
> based upon another guide might be a mistake.

Didn't mean that to sound like I wasn't going to check it out.  Call it
getting old and finding my expectations of useability of vendor supplied
publications over the years to be lacking what I want to know.   :-)


--
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: [hidden email]
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


--
For unsubscribe instructions e-mail to: [hidden email]
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

Dan Lewis Dan Lewis
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: Using and Formatting Logical Functions in Calc

In reply to this post by snowshed
Ken Springer wrote:

> On 6/27/12 7:57 PM, Dan wrote:
>> Ken Springer wrote:
>>> On 6/27/12 5:48 PM, Dan wrote:
>>>> Ken Springer wrote:
>>>>> Is there a more detailed set of examples of using the functions
>>>>> anywhere?  The Help Files have a general outline of each, but only
>>>>> very generic examples of how to use them.
>>>>>
>>>>> I need to nest some of the functions, if that's possible.
>>>>>
>>>>         Have you downloaded the Calc Guide. These things should be
>>>> in one
>>>> of the chapters or appendices.
>>>
>>> Hi, Dan.
>>>
>>> I haven't checked the Calc Guide, but if it's similar to the Writer
>>> Guide, it won't go to the depth I'm interested in.  :-(
>>        But you won't know until you look will you? Guessing the content
>> based upon another guide might be a mistake.
>
> Didn't mean that to sound like I wasn't going to check it out. Call it
> getting old and finding my expectations of useability of vendor
> supplied publications over the years to be lacking what I want to
> know.   :-)
      Then perhaps I have been pointing out a possible error in your
attitude. At age 70, my computer has user guides for Calc, Draw,
Impress, and Writer. If I run into a problem, I go to one of them for
the answer. So, what does age have to do with it? Before I made my
second reply, I looked at the table of contents for the Calc Guide. I
notice that Appendix B has 40 pages (8.5x11) on Calc functions.
      If I want to nest functions, I can click a cell and then click the
function wizard. It will help me put them in the proper order. (You did
not mention if you used this or not. Nor do I know if this works on the
number of nesting that you want.)

--Dan


--
For unsubscribe instructions e-mail to: [hidden email]
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

snowshed snowshed
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: Using and Formatting Logical Functions in Calc

In reply to this post by Tom
On 6/28/12 3:29 AM, Tom Davies wrote:
> So, smaller targeted downloads:)

Now that I have DSL, I don't mind downloading the entire book.  Don't
know which chapter to look in anyway.   LOL


--
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: [hidden email]
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

snowshed snowshed
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: Using and Formatting Logical Functions in Calc

In reply to this post by Dan Lewis
On 6/28/12 3:38 AM, Dan wrote:

> Ken Springer wrote:
>> On 6/27/12 7:57 PM, Dan wrote:
>>> Ken Springer wrote:
>>>> On 6/27/12 5:48 PM, Dan wrote:
>>>>> Ken Springer wrote:
>>>>>> Is there a more detailed set of examples of using the functions
>>>>>> anywhere?  The Help Files have a general outline of each, but only
>>>>>> very generic examples of how to use them.
>>>>>>
>>>>>> I need to nest some of the functions, if that's possible.
>>>>>>
>>>>>          Have you downloaded the Calc Guide. These things should be
>>>>> in one
>>>>> of the chapters or appendices.
>>>>
>>>> Hi, Dan.
>>>>
>>>> I haven't checked the Calc Guide, but if it's similar to the Writer
>>>> Guide, it won't go to the depth I'm interested in.  :-(
>>>         But you won't know until you look will you? Guessing the content
>>> based upon another guide might be a mistake.
>>
>> Didn't mean that to sound like I wasn't going to check it out. Call it
>> getting old and finding my expectations of useability of vendor
>> supplied publications over the years to be lacking what I want to
>> know.   :-)
>        Then perhaps I have been pointing out a possible error in your
> attitude. At age 70, my computer has user guides for Calc, Draw,
> Impress, and Writer. If I run into a problem, I go to one of them for
> the answer. So, what does age have to do with it? Before I made my
> second reply, I looked at the table of contents for the Calc Guide. I
> notice that Appendix B has 40 pages (8.5x11) on Calc functions.
>        If I want to nest functions, I can click a cell and then click the
> function wizard. It will help me put them in the proper order. (You did
> not mention if you used this or not. Nor do I know if this works on the
> number of nesting that you want.)

I wouldn't worry errors in my attitude, I've just become so used to
crappy documentation anymore I consider it the norm.  And when I went to
the Writer manual to find out something, it wasn't there.  While in
Calc, open Help and search for "locked documents".  I get a blank page.

I rarely use spreadsheets, as doing mathematical calculations are rare
for me.  Many use spreadsheets for databases, but I would use a
database.  And probably not LO Base, as there was something written
about Base in this list I couldn't believe was true, but sadly, I'm not
sure what that was.   LOL, CRS!

Hopefully, I'll find the time tomorrow to get the manual downloaded.


--
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: [hidden email]
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

Andreas Säger Andreas Säger
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: Using and Formatting Logical Functions in Calc

Hi,

Like any other programming language Calc can nest functions as far as
the data types of the incoming parameters match the data types of the
nested function results. The details are mostly the same as with any
other spreadsheet program of the past 30 years with the only exception
that there is no boolean data type. TRUE equals 1, FALSE equals 0
without any conversion.

A Calc cell can have a number, text, blank and error. All constants are
number or text, a formula may return number, text or error.

=FUNCTION(number ; text ; range ; vector )

*should* be nested like this:

> =FUNCTION( function_number(x) ; function_text(x) ; function_range(x) ; function_vector(x) )

[a vector is a range made of a single row or column. Sometimes this
shape is required]

The function wizard can be of great help when composing nested functions.

Personally, I avoid deeply nested function calls. They are much harder
to maintain and debug.

> http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_Functions_listed_by_category
Apart from the functions of category "Text" all spreadsheet functions
return numbers.
Functions of category "Spreadsheet" return references to other cells.

Am 29.06.2012 04:04, Ken Springer wrote:
>
> I rarely use spreadsheets, as doing mathematical calculations are rare
> for me.  Many use spreadsheets for databases, but I would use a
> database.  And probably not LO Base, as there was something written
> about Base in this list I couldn't believe was true, but sadly, I'm not
> sure what that was.   LOL, CRS!
>

Base is not a database. Please feel free to use your preferred
connectable database and connect it with a Base document in order to use
it in the context of this office suite. I do so successfully since many
years (OOo 1.1) within the limits of this very simple tool set. A decent
database is not exclusively bound to one particular front-end.

Hope that helps,
A.S.


--
For unsubscribe instructions e-mail to: [hidden email]
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

Tom Tom
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: Using and Formatting Logical Functions in Calc

In reply to this post by snowshed
Hi :) 
It makes a lot of sense.  Hopefully the proper LO documentation is far better than most!  The Pdfs allow you to click on items in the Table-of-Contents and has other clickable links to help you navigate to where you want quickly. 

The built-in help is probably fairly poor right now.  The docs team needs more people even to get through the proper full guides let alone important extras like the built-in help or the Faq.  On the plus side they are really getting through the work and the 3.4.x guides have been pulled together in an amazingly short  time. 

They have an excellent team right now even though some of the regular long-term stars appear to be taking a breather (or are they working hard behind the scenes?  It's difficult to know)

Regards from
Tom :) 



--- On Fri, 29/6/12, Ken Springer <[hidden email]> wrote:

<snip />

I wouldn't worry errors in my attitude, I've just become so used to crappy documentation anymore I consider it the norm.  And when I went to the Writer manual to find out something, it wasn't there.  While in Calc, open Help and search for "locked documents".  I get a blank page.

I rarely use spreadsheets, as doing mathematical calculations are rare for me.  Many use spreadsheets for databases, but I would use a database.

<snip />

Hopefully, I'll find the time tomorrow to get the manual downloaded.


-- 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: [hidden email]
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

Andreas Säger Andreas Säger
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: Using and Formatting Logical Functions in Calc

Am 29.06.2012 09:04, Tom Davies wrote:

> Hi :)
> It makes a lot of sense.  Hopefully the proper LO documentation is far better than most!  The Pdfs allow you to click on items in the Table-of-Contents and has other clickable links to help you navigate to where you want quickly.
>
> The built-in help is probably fairly poor right now.  The docs team needs more people even to get through the proper full guides let alone important extras like the built-in help or the Faq.  On the plus side they are really getting through the work and the 3.4.x guides have been pulled together in an amazingly short  time.
>
> They have an excellent team right now even though some of the regular long-term stars appear to be taking a breather (or are they working hard behind the scenes?  It's difficult to know)
>
> Regards from
> Tom :)
>

BLAH, BLAH, BLAH. Fanboyism by Tom.

Back on topic:
Calc is almost identical to Excel and Gnumeric. Point! Conceptually is
still similar to any spreadsheet since 1979 (a reference sheet for
VisiCalc is still online).
A function reference for Excel or Gnumeric can help you to work with
Calc if you really understand the content and that it does not apply
literally.

There is no need to know each and every function in detail. What you
need to know _and_understand_ is:
- Text vs. Number (and vs. Boolean in other applications)
- Format vs. Value (percent, bool, date/time formatting in particular)
- Relative vs. absolute reference
- The lookup functions of all spreadsheets are somewhat special. In the
first place they had been designed for something that is not that much
required by today's spreadsheet users.
- The most serious incompatibility between Calc and anything else is the
radically awkward string processing which makes it unusable for too many
of today's users.



--
For unsubscribe instructions e-mail to: [hidden email]
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

krackedpress krackedpress
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: Using and Formatting Logical Functions in Calc

On 06/29/2012 04:10 AM, Andreas Säger wrote:

> Am 29.06.2012 09:04, Tom Davies wrote:
>> Hi :)
>> It makes a lot of sense.  Hopefully the proper LO documentation is
>> far better than most!  The Pdfs allow you to click on items in the
>> Table-of-Contents and has other clickable links to help you navigate
>> to where you want quickly.
>>
>> The built-in help is probably fairly poor right now.  The docs team
>> needs more people even to get through the proper full guides let
>> alone important extras like the built-in help or the Faq.  On the
>> plus side they are really getting through the work and the 3.4.x
>> guides have been pulled together in an amazingly short  time.
>>
>> They have an excellent team right now even though some of the regular
>> long-term stars appear to be taking a breather (or are they working
>> hard behind the scenes?  It's difficult to know)
>>
>> Regards from
>> Tom :)
>>
>
> BLAH, BLAH, BLAH. Fanboyism by Tom.
>
> Back on topic:
> Calc is almost identical to Excel and Gnumeric. Point! Conceptually is
> still similar to any spreadsheet since 1979 (a reference sheet for
> VisiCalc is still online).
> A function reference for Excel or Gnumeric can help you to work with
> Calc if you really understand the content and that it does not apply
> literally.
>
> There is no need to know each and every function in detail. What you
> need to know _and_understand_ is:
> - Text vs. Number (and vs. Boolean in other applications)
> - Format vs. Value (percent, bool, date/time formatting in particular)
> - Relative vs. absolute reference
> - The lookup functions of all spreadsheets are somewhat special. In
> the first place they had been designed for something that is not that
> much required by today's spreadsheet users.
> - The most serious incompatibility between Calc and anything else is
> the radically awkward string processing which makes it unusable for
> too many of today's users.
>

I wonder how much of the current functionality of LO is based upon the
early days of OOo?  Excel's functionality goes back towards its early
Office 95/98 days.  Much of it is fixed back then and not totally
re-designed for today's need.

Yes, there are issues with Calc that need resolving, but OOo/LO could
not copy MSO's functions "exactly" due to software copyrights.  So the
designers, in the early days, had to do something different.  We are
living with that decision today.

Yes, no one can/could know all the details of the included functions.  
MS use to boast how many 100's of new functions we in the newest version
of Office.  So with Calc, how many 100's of functions or abilities are
in our resources to do the work we need to do in Calc's spreadsheet?

Yes, there always something in the documentation that needs to be filled
in.  There are always going to be things you want to do that are not
explained in a way that helps you.  I have see that for the past 35-40
years in the tech fields I have dealt with; electronics, computer
hardware, and computer programming.

Is there a place where users can "drop off" a description on how to do
something that is not explained in the current documentation? The
current docs are "guides" and not "how-to" books.  For me, "how-to"
books are more example driven where there are 100's of examples on how
to do specific "things".  Then there is the detailed reference books.  
Look at Python books.  You get a basic guide book, a thicker "how-to"
book, and a thick resource book explaining in detail all the built in
functions in the various resource libraries.  You cannot expect our doc
people to create a "guide" that does all three at the same time.

If there are "pages" missing in the documentation or help system, and
you know what is needed in those missing pages, write it up and offer it
to the doc people so they do not need to "research it" for themselves.  
IF you created some working routine that explains how some function
works properly, then summit it as a working example. There has to be a
place for you to do just that.

I have added to the FAQ wiki page about adding MS fonts to Linux to be
used in LO.  Where to get the MS core fonts and substitute ones. But
that is something not everyone would want to do.  So there has to be a
place to have an example "dropped off" with text explaining how it works
or the details of the example.

sorry if I seem to be rambling. . . I is in the "wee hours" for me here  
Since I could not sleep, I decided to look at the email lists.

--
For unsubscribe instructions e-mail to: [hidden email]
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

Andreas Säger Andreas Säger
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: Using and Formatting Logical Functions in Calc

Am 29.06.2012 10:49, webmaster-Kracked_P_P wrote:

> Is there a place where users can "drop off" a description on how to do
> something that is not explained in the current documentation? The
> current docs are "guides" and not "how-to" books.  For me, "how-to"
> books are more example driven where there are 100's of examples on how
> to do specific "things".  Then there is the detailed reference books.
> Look at Python books.  You get a basic guide book, a thicker "how-to"
> book, and a thick resource book explaining in detail all the built in
> functions in the various resource libraries.  You cannot expect our doc
> people to create a "guide" that does all three at the same time.
>

Being an interactive programming language for non-programmers,
spreadsheets are generic tools for no particular pupose which is why
there are no how-tos.
You need a how-to when you want to learn how to build a wooden house.
Nobody needs how-tos on the use of hammer, the nails, the saw etc. For
the tools you need references about appropriate combinations of woods,
nails and hammers and may be how to mount the correct blades on the saw etc.

Any how-tos will be ignored anyway. Nothing prevents people from using
spradsheets in the exact same manner as paper spreadsheets that used to
be pinned to office walls in the 70ies.
August2012.xls with 31 sheets (one for each day of month) a cross table
with vertical days and horizontal items. Anything beyond mere data entry
is impossible to do with this layout.

This is the single most helpful how-to to solve most of today's
spreadsheet problems without a single formula:
> http://wiki.services.openoffice.org/wiki/Documentation/OOo3_User_Guides/Calc_Guide/DataPilot

The problem with that solution is that nobody is willing to organize
data in databases nor sheet lists resembling a normalized database
table. This is a far too simple machine readable data layout when you
wasted so much time with all the formatting options and cell merging.

Another "must read" on spreadsheets in general:
> http://www.burns-stat.com/pages/Tutor/spreadsheet_addiction.html



--
For unsubscribe instructions e-mail to: [hidden email]
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

Andreas Säger Andreas Säger
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: Using and Formatting Logical Functions in Calc

In reply to this post by Jay Lozier
Am 28.06.2012 02:43, Jay Lozier wrote:

> Generally you can nest functions several levels deep in any spreadsheet.
> Typically the maximum is 7 levels but I would not go beyond about 3
> because it becomes to difficult to follow the logic. You could have
> something like =if( (x or y), if( (a and b),
> sum(d:d),average(d:d)),stdev(d:d)).
>

And D:D is exactly the thing that does _NOT_ work in Calc.


--
For unsubscribe instructions e-mail to: [hidden email]
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

snowshed snowshed
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: Using and Formatting Logical Functions in Calc

In reply to this post by Tom
Hi, Tom,

On 6/28/12 3:29 AM, Tom Davies wrote:
> This link has the guides but also has links to 3rd party documentation and stuff
> https://wiki.documentfoundation.org/Documentation/Publications
> The official guides are uploaded there before officially released on the website and individual
> chapters are there before they get put together to form the entire book.

Unfortunately, there's nothing there for 3.5.x.x.    :-(  And the
Formula Wizard is different in 3.5.x.x.


--
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: [hidden email]
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

snowshed snowshed
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Re: Using and Formatting Logical Functions in Calc

In reply to this post by Dan Lewis
On 6/28/12 3:38 AM, Dan wrote:

> Ken Springer wrote:
>> On 6/27/12 7:57 PM, Dan wrote:
>>> Ken Springer wrote:
>>>> On 6/27/12 5:48 PM, Dan wrote:
>>>>> Ken Springer wrote:
>>>>>> Is there a more detailed set of examples of using the functions
>>>>>> anywhere?  The Help Files have a general outline of each, but only
>>>>>> very generic examples of how to use them.
>>>>>>
>>>>>> I need to nest some of the functions, if that's possible.
>>>>>>
>>>>>          Have you downloaded the Calc Guide. These things should be
>>>>> in one
>>>>> of the chapters or appendices.
>>>>
>>>> Hi, Dan.
>>>>
>>>> I haven't checked the Calc Guide, but if it's similar to the Writer
>>>> Guide, it won't go to the depth I'm interested in.  :-(
>>>         But you won't know until you look will you? Guessing the content
>>> based upon another guide might be a mistake.
>>
>> Didn't mean that to sound like I wasn't going to check it out. Call it
>> getting old and finding my expectations of useability of vendor
>> supplied publications over the years to be lacking what I want to
>> know.   :-)
>        Then perhaps I have been pointing out a possible error in your
> attitude. At age 70, my computer has user guides for Calc, Draw,
> Impress, and Writer. If I run into a problem, I go to one of them for
> the answer. So, what does age have to do with it? Before I made my
> second reply, I looked at the table of contents for the Calc Guide. I
> notice that Appendix B has 40 pages (8.5x11) on Calc functions.

Lots of info on the functions and what they do, very little on how to
use them with practical examples.

>        If I want to nest functions, I can click a cell and then click the
> function wizard. It will help me put them in the proper order. (You did
> not mention if you used this or not. Nor do I know if this works on the
> number of nesting that you want.)

So far, I've not been able to get the Function Wizard to give me what I
want.  :-(

And I've not been able to come up with a competent explanation of what
I'm trying to accomplish.   :)

--
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: [hidden email]
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

12
Loading...