S.Lott-Software Architect

Apple's freebie tools -- Pages, Numbers, Keynote, Garage Band, etc. -- are wonderful things. I really like Numbers. I'm tolerant of ...

See  https://slott56.github.io/replacing-a-spreadsheet/ . This document is really exciting (to me). This is still shaky -- I'm still lea...

Author F. L. Stevens has a hellishly complex (and irregular) spreadsheet with agents, agencies, and query status. (This is how fiction gets ...

I can't emphasize this enough. Some people, when confronted with a problem, think “I know, I'll use a spreadsheet.”   Now they ha...

A common way to save persistent, important data is a spreadsheet. It provides a handy, potentially normalized store that's readily acces...

From someone in the process of becoming a data scientist. They had a question on regular expressions, which made almost no sense. It appears...

See Obstinate Idiocy for some background. Here are three warning signs I was able to deduce. No Rational Justification Ineffective T...

Once in a great while, you see someone engaging in Obstinate Idiocy. Here's my recent example. They're solving some kind of di...

For years, I've been using Apache POI in Java and XLRD in Python to read spreadsheets. Finally, now that .XLSX and .XLSM files are in ...