top | item 35669694

(no title)

calmlynarczyk | 2 years ago

Spreadsheets get a bad rap, particularly from software developers. However, even as a dev myself, I've always found them to be surprisingly powerful and a great tool for people who can bridge their gap in coding skills using formulas to build data-driven declarative capabilities. It might not be as powerful or performant as SQL or Pandas, but it's rather impressive given that you can do it off-the-shelf within a widely-used application.

I've seen non-technical people build some really cool things off of the back of spreadsheet data using things like AppSheet and Google Looker Studio (not sure why they changed the name from Data Studio). And now with Excel adding a ChatGPT formula and Google Sheets adding their own AI-driven features, power and non-power users alike will be able to really up their capabilities using only plain-language queries without having to devise complex algorithms or formulas (I realize ChatGPT isn't flawless yet).

discuss

order

turtleyacht|2 years ago

I would love to introduce Visual Basic for Applications (VBA) as a gateway to software development, but even positive receptiveness to model and simulate requirements is welcome.

If only we could onboard a friction-free process from Excel to git! Some way to configure Github Actions, say, and have them upload their sheet somewhere. #ExcelOps

I think it would be easier then to say, "Here's why a real app would scale better." And they would be 100% behind that.