Hacker News Reader

I think almost the opposite. Excel is useful for quick exploration or entry of data. If I need data entry from many people, a web spreadsheet can be useful, too.

At the point that others will be dependent on the output, I want version control and tests. You can make that happen with excel but it's not easy.

Yes, or, do I want to be on point to maintain this until the end of days? If no, use Excel.

Absolutely, if you're generating any kind of ad-hoc reports for biz/marketing folks it is often a much better to implement it in a way that they understand and update than to write your own code to produce it.

"Paste the export from {business system} in this tab, then drag down column F in the first tab to update the vlookups." Boom, no more 5-minutes-before-the-board-meeting-can-you-just-rerun-this-report-with-different-parameters emergencies. For the most part.

This is how I do it as well.