Path: csiph.com!eternal-september.org!feeder.eternal-september.org!nntp.eternal-september.org!.POSTED!not-for-mail From: Don Y Newsgroups: sci.electronics.design Subject: Re: Excel and accountants, good post on LinkedIn Date: Sat, 31 Jan 2026 19:31:04 -0700 Organization: A noiseless patient Spider Lines: 39 Message-ID: <10lmdtj$3cdnh$2@dont-email.me> References: <5e0a38da-0e01-3cfa-3eec-cf3b29a5bb41@insomnia247.nl> <10lhb6v$1qjs6$2@dont-email.me> <6s2qnk116ac272mglnt5qu8jb7gqbmrh0s@4ax.com> <10lk2ja$2kic9$4@dont-email.me> <10lm2po$iqv$2@gal.iecc.com> <10lmcsf$hj6j$1@paganini.bofh.team> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Injection-Date: Sun, 01 Feb 2026 02:31:17 +0000 (UTC) Injection-Info: dont-email.me; posting-host="5bf085a0f9556c7042981b04f733a99a"; logging-data="3553009"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+etbNLpunrBY1PqL/3XmcX" User-Agent: Mozilla Thunderbird Cancel-Lock: sha1:17FuLsclAT1cRxUgjlWQX7Dw1Wc= Content-Language: en-US In-Reply-To: <10lmcsf$hj6j$1@paganini.bofh.team> Xref: csiph.com sci.electronics.design:739979 > Oh dear, another example of ineptness triumphing over technical > goodness. There is a mistaken emphasis on usability and deferred error checking -- to make "coding" less difficult for the inept. Even in languages that have scoping rules that allow you to be more pedantic in defining identifiers, people choose to ignore them as an expedient. "The larger the dictionary, the FEWER the number of misspellings the spell-checker will find!" Similarly, laziness in deploying invariants lets errors in *processing* creep into data and persist -- often beyond the point where they COULD have been noticed! ("This value can't exist here! But, once you get PAST this point, the code will treat it as valid data...") The worst misuse (IM) of Excel is in place of a database. Yet, people seem terrified to NOT be able to see their data at a glance (really? can you SPOT an error that would merit its presentation, thusly?) [I have encountered datasets maintained in excel (and other spreadsheets) that were horrendously large and impossible to manage. Yet, offering to restructure the data in a database brings terror to the users...] > I repeatedly complain to an R user which is an Excel user via > quotations like so: "languages like PHP and Mathematica are still > heedless to variable misspellings; [. . .] reversing bad design > decisions, is often impossible once there is a community of users. The > shortcomings of Perl, PHP, CSS, JavaScript, etc, are going to persist > [. . .] JavaScript, Perl, PHP, Excel [. . .] having little type > safety" says > Harold Thimbleby, "Heedless programming: ignoring detectable error is > a widespread hazard", "Software: Practice and Experience"