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

Re: spreadsheet ergonomics

From	owl <owl@rooftop.invalid>
Newsgroups	comp.os.linux.advocacy
Subject	Re: spreadsheet ergonomics
Date	2017-04-06 17:56 +0000
Organization	O.W.L.
Message-ID	<aiboo3u0bo.3jau@rooftop.invalid> (permalink)
References	(9 earlier) <9tolkigyu.anh@rooftop.invalid> <oc479v$oou$4@dont-email.me> <oc488k$ret$2@dont-email.me> <ahcjz93.g88b@rooftop.invalid> <D50BC1EF.9D0EC%usenet@gallopinginsanity.com>

Show all headers | View raw

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.

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