by Flankk on 12/11/21, 3:26 PM
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.
by INTPenis on 12/11/21, 8:25 PM
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.
by booleanbetrayal on 12/11/21, 3:23 PM
by webdoodle on 12/11/21, 7:01 PM
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!
by jackhalford on 12/11/21, 3:26 PM
by wiseleo on 12/12/21, 1:28 AM
by bmsleight_ on 12/11/21, 3:21 PM
Disappointed having watch the earlier rounds there were not much in terms of tips.
Just heavy use of index, left$ and if statements.
by ineedasername on 12/11/21, 8:58 PM
TIL you actually can enable circular references in Excel. Though I struggle to see the practical usefulness except for a few edge cases.
by CactusOnFire on 12/11/21, 4:58 PM
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?
by kingcharles on 12/11/21, 7:49 PM
by SMAAART on 12/11/21, 9:53 PM
I found my people!