←back to thread

291 points 1659447091 | 2 comments | | HN request time: 0.405s | source
Show context
mndgs ◴[] No.46340638[source]
Watch this, where he goes through the questions and explains how he did it: https://www.youtube.com/watch?v=1Mx_xhiIRpw

I'm pretty good with Excel, my main tool at the job for over 20 years. I understand how he did it, but it's just really humbling...

I still think quality of what you do with Excel (idea) is more important than how you do it (skill).

replies(1): >>46345901 #
INTPenis ◴[] No.46345901[source]
I'll never forget a past job where they used a lot of Excel in ways I did not know was possible.

First of all they had an invoicing system in Excel, that pulled in data using VBS, into Excel templates, and at the press of a button in the UI generated invoices from these templates.

And the craziest part was their server inventory system made in Excel, where they had drawn all the rack cabinets, you could click on each, to drill down and show all the servers in that rack. Also a ton of VBS, you could even get monitoring status of each rack.

Excel has been OP for a long time, long before its Python capabilities.

replies(2): >>46346453 #>>46346502 #
1. not_kurt_godel ◴[] No.46346502[source]
Did either of those systems have unit or integration tests?
replies(1): >>46347179 #
2. NetMageSCW ◴[] No.46347179[source]
Do any of the competitive solutions?