Seeing these Excel pros compete reminds me of when I found an old server inventory system at work. Someone had in Excel+Visio+VBS made a system where you could see a top-down map of our DCs, and server cabinets. Each cabinet had an alert light indicating if there were any alerts on any server in that cabinet (fetched from Xymon), you could click each cabinet to get a front view of all servers, with graphics of server fronts reflecting the vendor and model of the server.
The person who made this had quit a long time ago, no one was quite sure of who it was. And of course things had slowly started to break down, like API connections, alerts, it wasn't up to date, but wow. It blew my mind.
Wait ... this is a real thing? https://www.youtube.com/watch?v=xubbVvKbUfY
Excel still is used heavily in government. I wrote a VBA macro for an Excel spreadsheet that would take a payroll flat text file, import it into SQL Server using OLE DB, do some data clean up, sort and then export to separate sheets in a different spreadsheet by employee name. Before I wrote this macro (which took a couple days), the payroll department of this government organization had dedicated an entire 40 hour per week person to doing this manually. They had been doing that job for years!
made me think of this [1] parody.
If you like using Excel as an app development platform, take a look at https://youtube.com/c/ExcelForFreelancers
He makes apps that look nothing like Excel using custom shapes.
Disappointed having watch the earlier rounds there were not much in terms of tips.
Just heavy use of index, left$ and if statements.
TIL you actually can enable circular references in Excel. Though I struggle to see the practical usefulness except for a few edge cases.
Am I an asshole for just thinking that at this scale of complexity, it's just easier to build things using a web-app framework?
Obligatory Ian Malcolm:
I found my people!
Excel is good for business office using.
hope this Cement Trailer For Sale is helpful for logistic company.
Cell Shock are heading into the finals with an 8-point lead in macro chaining but they face fierce opposition from the Miami Sheet with their blazing 460 shortcut APM. Five competitors have been caught doping but let's hope the others will recover from their repetitive strain injuries from last season.