4 ms·
> Mysterious constants in formulae, unexpected quick side calculations left over, and poor structure. This could be about any programming language/codebase. I
by Someone1234 4y ago
> Mysterious constants in formulae, unexpected quick side calculations left over, and poor structure.
This could be about any programming language/codebase.
In Excel, you could move those "mysterious constants" into named/described cells in a constants sheet if you wanted. You could also put your formulas in one place and reference them.
This reminds me of the old "Why does Visual Basic suck? Because it attracts BAD programmers" discussions. The reality is that almost no language stops you writing bad code, and older codebases often are worse in terms of maintainability regardless of language choice.
I've seen some absolutely terrifying C code for example.
PS - Excel's CSV support is complete trash. If you open a CSV and just hit "save" it may corrupt data in an unrecoverable way. For example turning long numbers like UPCs, medical codes, or DNA sequences, into scientific notation or dates, dropping leading zeros even if you convert them back.