On 11/25/2022 1:44 PM, rbowman wrote:
> On Fri, 25 Nov 2022 09:53:03 -0500, DFS wrote:
>
>> And "spreadsheets are just a crutch for digital illiterates."
>
> There is some truth in that statement.
It's another stupid Feeb proclamation.
> I cringe when I get an xsl document
I assume you meant .xls.
The only cringing I felt related to Excel was generally due to
formatting and structure: some monthly data feed would be changed
(columns now in a different order, columns removed, tabs renamed).
> because I know it will be some sort of free form text entry, usually
> stream of consciousness, that should have been a coherent text document.
>
> I can't remember if I've ever seen a spreadsheet used as a spreadsheet.
> The first one I ran into was SuperCalc which was bundled with CP/M on the
> Osborne 1.
I, on the other hand, don't recall ever seeing an .xls document used
like a .doc file. Not once.
> I never found a use for it; 40 years later I still don't know
> what to do with Excel.
Analyze data (business and scientific and engineering). Build
budgets/forecasts. Maintain simple and complex lists. Build financial
and statistical models. Build full-blown apps (that don't look at all
like spreadsheets). Powerful charting, etc
An Excel sheet nowadays has 1,048,576 rows by 16,384 columns, so it can
store an enormous amt of info.
To get the most out of Excel you have to write VBA code, though.
> I'm sure it's a valuable tool for accountants and
> other number crunchers.
From what I've read, Excel is the dominant tool used in finance /
accounting / statistics / data science / engineering / science all over
the world. No exaggeration.
R programming is widely-used for stats and "big data", too.
And Excel/.xls is very likely the most common data interchange format in
the world. I know it was rare for me to get/send .csv files at any
company I ever worked.