Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

Re: spreadsheet ergonomics

Show all headers | View raw

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.

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