Groups > comp.os.linux.advocacy > #406687

Re: spreadsheet ergonomics

From	owl <owl@rooftop.invalid>
Newsgroups	comp.os.linux.advocacy
Subject	Re: spreadsheet ergonomics
Date	2017-04-06 19:47 +0000
Organization	O.W.L.
Message-ID	<aciz0b0.3hgv@rooftop.invalid> (permalink)
References	(9 earlier) <D50BC1EF.9D0EC%usenet@gallopinginsanity.com> <aiboo3u0bo.3jau@rooftop.invalid> <D50BDC43.9D128%usenet@gallopinginsanity.com> <ab23gka.9@rooftop.invalid> <D50BE3A9.9D13B%usenet@gallopinginsanity.com>

Show all headers | View raw

Snit <usenet@gallopinginsanity.com> wrote:
> On 4/6/17, 12:09 PM, in article ab23gka.9@rooftop.invalid, "owl"
> <owl@rooftop.invalid> wrote:
> 
>> Snit <usenet@gallopinginsanity.com> wrote:
>>> On 4/6/17, 10:56 AM, in article aiboo3u0bo.3jau@rooftop.invalid, "owl"
>>> <owl@rooftop.invalid> wrote:
>>> 
>>>> Snit <usenet@gallopinginsanity.com> wrote:
>>>>> On 4/6/17, 5:38 AM, in article ahcjz93.g88b@rooftop.invalid, "owl"
>>>>> <owl@rooftop.invalid> wrote:
>>>>> 
>>>>>> DFS <nospam@dfs.com> wrote:
>>>>>>> On 4/5/2017 10:01 PM, DFS wrote:
>>>>>>> 
>>>>>>>>  ActiveCell.FormulaR1C1 = "=SUM(R[-10]C:R[-1]C)"
>>>>>>> 
>>>>>>> Whoops.  Make that           "=SUM(R[-9]C:R[-1]C)"
>>>>>>> 
>>>>>>> 
>>>>>>> http://imgur.com/a/NHHS7
>>>>>>> 
>>>>>>  
>>>>>> Is there not a way to feed it a count instead of just seeing
>>>>>> how many it can create in 15 seconds?
>>>>> 
>>>>> Just for the fun of it I looked up a script for creating and populating a
>>>>> table in Numbers: <https://iworkautomation.com/numbers/table-populate.html>
>>>>> 
>>>>> I ran the first script on the page, unedited. It does not do what yours
>>>>> does
>>>>> but I think it makes the point. While there are certainly ways to speed the
>>>>> script up, such as not having it create random numbers, not watching the
>>>>> results as it runs, not aligning the data, etc., I think we can safely say
>>>>> both sc and Excel kick Number's ass on this one. :)
>>>>> 
>>>>>     <https://youtu.be/l43rtWFrq38>
>>>>> 
>>>>> Impressive, eh?
>>>> 
>>>> Have it just create a few one-column tables with a sum formula an
>>>> don't bother with populating the cells.  That should give a better
>>>> comparison.
>>> 
>>> With quick fiddling could not get it to create a one column table (!) but
>>> here is what I came up with. Can change the number of rows and tables if you
>>> want. 
>>> 
>>>     <https://youtu.be/KhsSa77CTUo>
>>> 
>>> With only 10 rows being made it does it with a blindingly fast half second
>>> or so per table. Wow! Beat that! :)
>>> 
>>> Then re-read your request and stopped populating the cells:
>>> 
>>>     <https://youtu.be/hznjYcr1Kjc>
>>> 
>>> Still, for just 10 tables it took more than a second. Hardly anything to
>>> brag about!
>> 
>> Just work with one of Number's "tables" and add pseudo tables to it.
> 
> Not sure what you mean by "pseudo tables"... columns maybe?
> 

Nevermind.  Explaining it to you is pointless.

Back to comp.os.linux.advocacy | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Re: spreadsheet ergonomics DFS <nospam@dfs.com> - 2017-04-05 11:55 -0400
  Re: spreadsheet ergonomics Snit <usenet@gallopinginsanity.com> - 2017-04-05 09:03 -0700
  Re: spreadsheet ergonomics owl <owl@rooftop.invalid> - 2017-04-05 21:17 +0000
    Re: spreadsheet ergonomics Snit <usenet@gallopinginsanity.com> - 2017-04-05 15:15 -0700
      Re: spreadsheet ergonomics owl <owl@rooftop.invalid> - 2017-04-06 01:49 +0000
        Re: spreadsheet ergonomics Snit <usenet@gallopinginsanity.com> - 2017-04-05 18:55 -0700
          Re: spreadsheet ergonomics owl <owl@rooftop.invalid> - 2017-04-06 02:00 +0000
            Re: spreadsheet ergonomics Snit <usenet@gallopinginsanity.com> - 2017-04-05 19:04 -0700
            Re: spreadsheet ergonomics Silver-Tongued Heel <sl@im.er> - 2017-04-06 08:48 -0400
    Re: spreadsheet ergonomics DFS <nospam@dfs.com> - 2017-04-05 22:01 -0400
      Re: spreadsheet ergonomics DFS <nospam@dfs.com> - 2017-04-05 22:17 -0400
        Re: spreadsheet ergonomics owl <owl@rooftop.invalid> - 2017-04-06 12:38 +0000
          Re: spreadsheet ergonomics DFS <nospam@dfs.com> - 2017-04-06 10:46 -0400
            Re: spreadsheet ergonomics owl <owl@rooftop.invalid> - 2017-04-06 17:48 +0000
          Re: spreadsheet ergonomics Snit <usenet@gallopinginsanity.com> - 2017-04-06 09:59 -0700
            Re: spreadsheet ergonomics owl <owl@rooftop.invalid> - 2017-04-06 17:56 +0000
              Re: spreadsheet ergonomics Snit <usenet@gallopinginsanity.com> - 2017-04-06 11:51 -0700
                Re: spreadsheet ergonomics owl <owl@rooftop.invalid> - 2017-04-06 19:09 +0000
                Re: spreadsheet ergonomics Snit <usenet@gallopinginsanity.com> - 2017-04-06 12:23 -0700
                Re: spreadsheet ergonomics owl <owl@rooftop.invalid> - 2017-04-06 19:47 +0000
                Re: spreadsheet ergonomics Snit <usenet@gallopinginsanity.com> - 2017-04-06 13:30 -0700
      Re: spreadsheet ergonomics owl <owl@rooftop.invalid> - 2017-04-06 02:44 +0000
        Re: spreadsheet ergonomics DFS <nospam@dfs.com> - 2017-04-06 09:51 -0400
          Re: spreadsheet ergonomics owl <owl@rooftop.invalid> - 2017-04-06 14:26 +0000
            Re: spreadsheet ergonomics Snit <usenet@gallopinginsanity.com> - 2017-04-06 09:03 -0700

csiph-web