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

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

Re: spreadsheet ergonomics

Path csiph.com!xmission!news.alt.net!not-for-mail
From owl <owl@rooftop.invalid>
Newsgroups comp.os.linux.advocacy
Subject Re: spreadsheet ergonomics
Date Thu, 6 Apr 2017 19:09:57 +0000 (UTC)
Organization O.W.L.
Lines 58
Message-ID <ab23gka.9@rooftop.invalid> (permalink)
References <ab003g.hi4@rooftop.invalid> <guc8892.a@rooftop.@gallopinginsanitD.9C996%usenet@gallopinginsanity.com> <zb3ugoa00.aulu@rooftop.invalid> <D509180F.9CA33%usenet@gallopinginsanity.com> <avz003.ahbu3@rooftop.invalid> <oc33rd$8p0$3@dont-email.me> <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> <aiboo3u0bo.3jau@rooftop.invalid> <D50BDC43.9D128%usenet@gallopinginsanity.com>
NNTP-Posting-Host boom.rooftop.invalid
X-Face $BHf)vM$6p_?9L`jmOQ54JeNyL+%MZGGRfH8&grb[Y%-jU`MCPAQN=/SVDa{<KrBxl"%XcV >(/67bP(YB}rjV^h><g$kPGE_caHX,aa}4A1~sto7YJo#ob/SgNiMsoaMMXiOX9%DjyJM_-=$`F5b' JM,?/R/;V1RI%|eClL6ymI}LbZERB=q+"pJ)uI{ngj1DRF1;E5[r$f[4mgt9=7Pw@vl8@I%eYs6KWJ e%LU3#U@M[X^YBp2VY]-'1*reGDbk%#n1ve'*RffQ3j,(TCYivjb*M`qmuC5rHgbN)nSsx)697q/vt //''?=gM'C.salgG^f)>cUh
User-Agent tin/2.2.1-20140504 ("Tober an Righ") (UNIX) (Linux/3.16.0-4-amd64 (x86_64))
Xref csiph.com comp.os.linux.advocacy:406680

Show key headers only | 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