Maybe that implies that we just need to start teaching analysts to write code, but the problem is that when you switch from spreadsheets to honest-to-goodness t

Maybe that implies that we just need to start teaching analysts to write code, but the problem is that when you switch from spreadsheets to honest-to-goodness text-based code, you're just trading one set of problems (spreadsheet mistakes) for another (bugs in your code). In the end I'm personally still in favor of Excel because it has a much gentler learning curve, though you are right that bulk operations in Excel are ripe territory for errors. I don't think it's "nearly impossible" though, it comes down to following best practices the same way you would in any programming language.