top | item 41781483

(no title)

Stoids | 1 year ago

I do consulting for a few restaurants, and despite my experience building full-stack web applications, I find myself reaching for Excel for most of my deliverables. These are "applications" that "non-technical" restaurant operators need to be comfortable in. Having a sheet where they paste in some data and get their needed output has required the least amount of continued maintenance and training. They can drag the file around in Dropbox / Google Drive and that works for them.

I still try to "engineer" to the best of my ability—separating raw input from derived data from configuration, data normalization, etc. With Lambda functions in Excel now, I kinda just pretend I'm writing Lisp in an FRP editor / runtime environment. The ETL tools with PowerQuery are quite good for the scale that these restaurants operate at.

Hard for me to turn off my brain in my full-time job when I am tasked with poorly recreating a feature that Excel nailed years ago.

discuss

order

jasonkester|1 year ago

It’s a shame that Access died, because that’s what you would have built this in 25 years ago, and it would have been better for your client in every respect.

rekabis|1 year ago

> It’s a shame that Access died

Gesundheit? It’s still in Office 365 (subscription) and Office 2024 Pro (standalone).

EasyMark|1 year ago

You can create web pages in excel??

swiftcoder|1 year ago

These are presumably more along the lines of custom inventory management software