TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

Excel World Championship Finals

174 pointsby Silasdevover 3 years ago

11 comments

Flankkover 3 years ago
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.
INTPenisover 3 years ago
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.<p>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&#x27;t up to date, but wow. It blew my mind.
评论 #29525559 未加载
booleanbetrayalover 3 years ago
Wait ... this is a real thing? <a href="https:&#x2F;&#x2F;www.youtube.com&#x2F;watch?v=xubbVvKbUfY" rel="nofollow">https:&#x2F;&#x2F;www.youtube.com&#x2F;watch?v=xubbVvKbUfY</a>
评论 #29522641 未加载
评论 #29522021 未加载
评论 #29522204 未加载
评论 #29523642 未加载
评论 #29522179 未加载
webdoodleover 3 years ago
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!
评论 #29524886 未加载
评论 #29527841 未加载
评论 #29524532 未加载
jackhalfordover 3 years ago
made me think of this [1] parody.<p>1: <a href="https:&#x2F;&#x2F;youtu.be&#x2F;xubbVvKbUfY" rel="nofollow">https:&#x2F;&#x2F;youtu.be&#x2F;xubbVvKbUfY</a>
wiseleoover 3 years ago
If you like using Excel as an app development platform, take a look at <a href="https:&#x2F;&#x2F;youtube.com&#x2F;c&#x2F;ExcelForFreelancers" rel="nofollow">https:&#x2F;&#x2F;youtube.com&#x2F;c&#x2F;ExcelForFreelancers</a><p>He makes apps that look nothing like Excel using custom shapes.
bmsleight_over 3 years ago
Disappointed having watch the earlier rounds there were not much in terms of tips.<p>Just heavy use of index, left$ and if statements.
评论 #29522652 未加载
评论 #29523283 未加载
评论 #29524721 未加载
ineedasernameover 3 years ago
TIL you actually can enable circular references in Excel. Though I struggle to see the practical usefulness except for a few edge cases.
评论 #29524583 未加载
评论 #29524265 未加载
CactusOnFireover 3 years ago
Am I an asshole for just thinking that at this scale of complexity, it&#x27;s just easier to build things using a web-app framework?
评论 #29524089 未加载
评论 #29523072 未加载
评论 #29527323 未加载
评论 #29522649 未加载
kingcharlesover 3 years ago
Obligatory Ian Malcolm:<p><a href="https:&#x2F;&#x2F;www.youtube.com&#x2F;watch?v=g3j9muCo4o0" rel="nofollow">https:&#x2F;&#x2F;www.youtube.com&#x2F;watch?v=g3j9muCo4o0</a>
SMAAARTover 3 years ago
I found my people!