Olympus-OM
[Top] [All Lists]

Re: [OM] Completely OT: Pivot Tables

Subject: Re: [OM] Completely OT: Pivot Tables
From: ChrisB <ftog@xxxxxxxxxxxxxx>
Date: Sat, 14 Jan 2017 08:08:22 +0000
Thanks, Larry, I’ll have a look at that today.

I’m off to get the ice off the hens’ water supply . . .

Chris

> On 13 Jan 17, at 18:53, Jez Cunningham <jez@xxxxxxxxxxxxxx> wrote:
> 
> I've done many pivot tables in the past but haven't found the need since
> retirement!!!
> I MAY be able to help if you have specific questions...
> Jez
> 
> Friday, 13 January 2017, Larry Griffin via olympus <
> olympus@xxxxxxxxxxxxxxxxx> wrote:
> 
>> I've recently worked google spreadsheets tracking stocks, no analyst. I
>> thought that it was possible to analyze the spreadsheets and I maybe right.
>> Here is what I got when I google it;
>> 
>> 
>>     Google Sheets – Spreadsheets & Data Analysis for Business
>>     <https://gsuite.google.com/products/sheets/>
>> 
>> https://gsuite.*google*.com/products/*sheets*/
>> Create /spreadsheets/, track projects, analyze data and perform
>> calculations with /Google Sheets/. Includes advanced formulas, embedded
>> charts, filters, pivot ...
>> 
>> I have created spreadsheets on my computer and copied them to google. IIRC
>> google backs up their Doc files every ten minutes. Hope that helps
>> 
>> Larry
>> 
>> On 01/13/2017 07:46 AM, ChrisB wrote:
>> 
>>> I started using Swiftcalc in MS-DOS in about 1988, while based at MacDill
>>> AFB in Florida; I started using Excel 2 or 3 years later, mainly on
>>> Winders/MS-DOS and I have the latest version on my Macs, but it is only in
>>> the last 2 or 3 weeks that I’ve really tried to use Pivot Tables.  I think
>>> that I’ve cracked it, if only partly and using trial and error.
>>> 
>>> I have been running a survey at work, asking pilots their opinions on the
>>> practical Spatial Disorientation training that I give them – as part of
>>> their training in aviation medicine. It’s the first survey of this training
>>> where I work and I’ve promised to publish it as a paper (once I learn how
>>> to do that properly) to present at a conference in September, at Graz.
>>> Well, I was determined to do the analysis myself, and to do it
>>> automatically, but it has taken me many hours to get to grips with Pivot .
>>> . .
>>> 
>>> Does anyone on the list use any other system of analysis with Excel?  And
>>> is there a way to do word clouds without being connected to the Internet?
>>> 
>>> Chris
>>> 
>> 
>> --
>> _________________________________________________________________
>> Options: http://lists.thomasclausen.net/mailman/listinfo/olympus
>> Archives: http://lists.thomasclausen.net/mailman/private/olympus/
>> Themed Olympus Photo Exhibition: http://www.tope.nl/
>> 
>> 
> -- 
> _________________________________________________________________
> Options: http://lists.thomasclausen.net/mailman/listinfo/olympus
> Archives: http://lists.thomasclausen.net/mailman/private/olympus/
> Themed Olympus Photo Exhibition: http://www.tope.nl/
> 

-- 
_________________________________________________________________
Options: http://lists.thomasclausen.net/mailman/listinfo/olympus
Archives: http://lists.thomasclausen.net/mailman/private/olympus/
Themed Olympus Photo Exhibition: http://www.tope.nl/

<Prev in Thread] Current Thread [Next in Thread>
Sponsored by Tako
Impressum | Datenschutz