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

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

Re: spreadsheet ergonomics

Show all headers | View raw

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!

-- 
Personal attacks from those who troll show their own insecurity. They cannot
use reason to show the message to be wrong so they try to feel somehow
superior by attacking the messenger.

They cling to their attacks and ignore the message time and time again.

<https://youtu.be/H4NW-Cqh308>

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