hi it's laurence
spreadsheet ppl -- is there such a resource out there that dives into excel best practices, functions, etc? especially one that explains various baffling quirks baked into excel due to its history
i've been searching things like "excel for programmers" but that just nets me guides on how to program excel in. fucking visual basic. not what i want,
not really. due to the broad applicability of the application, there's several dozen competing industry standard guides for a number of given industries.
I usually just try to apply sql/db knowledge and make everything xlookup()s and filter()s, do thinks as atomically per-cell as I can.
fair enough! thanks for the advice.
re: atomic per-cell operations, do you mean breaking complex formulas over multiple cells, or something else?
yeah, I try to have each cell [or row/column, as the case may be] do one transformation, so like, one conditional, or one math op.
I do it that way because while RAM is cheap and execution time basically the same, debugging/fixing time is my limited commodity I design around.
