Subject | Re: spreadsheet ergonomics |
From | Snit |
Date | 04/06/2017 20:51 (04/06/2017 11:51) |
Message-ID | <D50BDC43.9D128%usenet@gallopinginsanity.com> |
Client | |
Newsgroups | comp.os.linux.advocacy |
Follows | owl |
Followups | owl (18m) > Snit |
owlWith 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.
Snit <usenet@gallopinginsanity.com>wrote:Snitowl
On 4/6/17, 5:38 AM, in article ahcjz93.g88b@rooftop.invalid, "owl" <owl@rooftop.invalid>wrote:owlSnit
DFS <nospam@dfs.com>wrote:DFSowl
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.