2023-02-22 at

Variable Assignment in Spreadsheet Formulae

I ... just prototyped the spreadsheet hackery required to count invalid values in a column of CSVs, and report the first offending row number ... all in a one-cell formula.

The hackery : three to four bits of code are completely redundant. The missing feature here is the explicit assignment of intermediate results to a variable, allowing in-cell code-reuse ( the intermediate results are probably already re-used, under the hood, implicitly ... I hope ).

So, if spreadsheet formula semantics included assignment operations, we would probably see an uptick in spreadsheet utilisation, and a reduction in code length across the industry.

Maybe the feature is banned because it would just make spreadsheets even more complex than they are already. But I would see it as a marginal improvement overall.

Being in Formation

Many do not realise that information refers to being in-formation. Technology for being in-formation, services for being in-formation, sciences of being in-formation, the commerce of being in-formation. The opposite of being in-formation, is being out-of-formation. 

2023-02-21 at

Pounds for Flesh

I used to say, I lack the inferiority complex which provides the drive to prove oneself, that makes the richest rich. 

Flip it around, I guess, and it just means I have a superiority complex which is destined to keep me poor. Hahaha.

We were discussing pay ( of course ), and I've tended to say that whatever I get paid ( it goes up and down with every job ), I am just grateful not to be fired. But symmetrically, I expect that employers are grateful that staff have not quit ... I don't think either party should entertain nonsense.