TE
科技回声
首页24小时热榜最新最佳问答展示工作
GitHubTwitter
首页

科技回声

基于 Next.js 构建的科技新闻平台,提供全球科技新闻和讨论内容。

GitHubTwitter

首页

首页最新最佳问答展示工作

资源链接

HackerNews API原版 HackerNewsNext.js

© 2025 科技回声. 版权所有。

Excel World Championship Finals

174 点作者 Silasdev超过 3 年前

11 条评论

Flankk超过 3 年前
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.
INTPenis超过 3 年前
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 未加载
booleanbetrayal超过 3 年前
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 未加载
webdoodle超过 3 年前
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 未加载
jackhalford超过 3 年前
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>
wiseleo超过 3 年前
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_超过 3 年前
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 未加载
ineedasername超过 3 年前
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 未加载
CactusOnFire超过 3 年前
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 未加载
kingcharles超过 3 年前
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>
SMAAART超过 3 年前
I found my people!