Skip to main content
news

Re: spreadsheet ergonomics

Snit
SubjectRe: spreadsheet ergonomics
FromSnit
Date2017-03-31 21:23 (2017-03-31 12:23)
Message-ID<D503FAB8.99172%usenet@gallopinginsanity.com>
Client
Newsgroupscomp.os.linux.advocacy
Followsowl
Followupsowl (3h & 56m) > Snit

On 3/31/17, 4:48 AM, in article ab003g.hi4@rooftop.invalid, "owl" <owl@rooftop.invalid>wrote:

owl
https://vid.me/UgNo Spread your work out how you want it with sc. There are two views of the main sheet (green), and two sets (yellow and blue) of other sheets. Data enterened into any of the auxilliary sheets gets totaled and sent to the main sheet.

Right... you can have related tables, but you can only have one table per window, right? You cannot, for example, have someone open a page and get something like this (hmmm, though I had an old video of this... maybe not, so made a new one):

<https://youtu.be/V2bRLDuaVOk>

That is from something I helped some high school kids do (I also had my own system open in another tab, MUCH more simple... just a single table).

Not shown: of course I can have different tabs open and have formulas flow from one tab to another. Hmmm, not sure about one file to another -- never tried. With a quick attempt now seems like that does NOT work.

And, just because such disclaimers seem needed in COLA to not hurt weak egos of some, of course this does not mean sc is a bad tool, or that Numbers is the best tool for all people and all jobs (it most certainly is NOT). But I like how I can easily have simple tables with, generally, basic calculations (and in my case never anything real complex), as well as charts and graphs, and do it quickly and easily and in a way I can even share it online with others (though, to be honest, I rarely do that... but I did with the one shown in the video).

-- 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.

owl (3h & 56m) > Snit