logoalt Hacker News

armoredkittentoday at 1:42 PM1 replyview on HN

I generally agree with the logic -- I don't like using spreadsheets for anything complex, or that has the shelf life of more than, say, a month. I can remember my logic for putting together all the complex formulas for a while, but eventually I have to recreate my own logic, reverse engineering everything, and it's frustrating.

But when one of your arguments is "Excel has complicated nested formulas that are difficult to follow" I don't think showing off a Python one-liner as an alternative is the greatest example. That one-liner is doing about five things that could have been separated into steps to show off the relative clarity and flexibility of the approach. It is better...that example just doesn't do a good job showing it.


Replies

kccqzytoday at 2:45 PM

The difference is that the Python one-liner calculates the entire thing whereas in Excel a complicated formula only calculates one cell, and may be different from cell to cell (unless you use array formulas in Excel, which are rare).