The World Cup of Microsoft Excel

https://www.theatlantic.com/technology/archive/2022/12/world-cup-microsoft-excel/672320/

by samizdis • 4 years ago

95 40 4 years ago

theatlantic.com

scubbo• 4 years ago

Obligatory Krazam links: https://www.youtube.com/watch?v=xubbVvKbUfY // https://www.youtube.com/watch?v=ICp2-EUKQAI

yeetcode• 4 years ago

Life imitates art

danielodievich• 4 years ago

I showed Krazam video to my wife few months ago, she's pretty excellent at Excel, omg we both were rolling around on the floor at the impactful conclusion. Brilliant!

tonto• 4 years ago

congrats for kos

ivan_ah• 4 years ago

non-paywalled link https://archive.ph/DgDYQ

beau_g• 4 years ago

Is it impossible to dethrone Excel? I feel like almost every SaaS space is heavily inundated with people trying almost every angle to rethink every data visualization and manipulation program, except for the straightforward spreadsheet. Google and Apple with Sheets and Numbers haven't seemed to make any genuine attempt to improve on Excel. I'm aware of Alphasheets which seemed to fizzle out and get acquired, am I missing someone else or is doing a spreadsheet startup just not that exciting?

gambiting• 4 years ago

If your application cannot open a 15 year old spreadsheet full of arcane VB code and "just work" then no serious business will ever adopt you. It's easy to make a spreadsheet app, it's not easy to make one that will work with the insane amount of legacy Excel code that's out there. It's the same reason why there aren't web browser startups.

gunshai• 4 years ago

Laying down the depressing truth.

Our production planning department subverts our erp system via excel spreadsheets that they distribute it has all the problems you'd expect.

I looked in horror the first time I gazed upon this thing. The guy who created it hates it and realizes it's a gigantic crutch, but the will to move off of it is a intracompany political land mine.

yreg2• 4 years ago

I work at a (imo serious) company that runs mostly on Google sheets (since the beginning) and I don't believe we have much need for opening ancient Excel files.

bradrn• 4 years ago

There’s Inflex [0], which has a very interesting (and I think better) approach to spreadsheets. I’ve also been working independently on a very similar idea [1], though it’s early days yet and I’m still busy figuring out the how to build it in a principled way. The Inflex website also has a really nice bibliography [2] with a fairly complete catalogue of what else has been done in this space.

[0] https://chrisdone.com/posts/inflex/

[1] https://github.com/bradrn/nexo

[2] https://chrisdone.com/posts/inflex-bibliography/

sheetjs• 4 years ago

The hardest unsolved problem is document compatibility. It's not enough to have a cool tool -- you need to be able to interchange data with existing users of Excel and other workflows. This was an important piece during Excel's journey to overtake Lotus 1-2-3.

We (https://sheetjs.com/) have been looking into document compatibility for 10 years (celebrating our 10 year birthday this week!), and our eponymous open source project https://github.com/sheetjs/sheetjs is used by companies large and small. It's not a particularly glamorous subject and doesn't tend to electrify people in the same way as build tools or frameworks.

There are ways to improve upon the space, but the problem is that the world has changed. Excel was designed to be the "center of the universe", a creative substrate that bypassed org security policies and enabled extremely flexible line of business tools. Excel was designed to be used by one user at a time, with fundamental inconsistencies blocked at the UI level (for example, try entering a bad custom number format). This made sense 20 years ago, but it doesn't make as much sense now.

The current crop of SaaS companies effectively monetize access to the data. They aren't incentivized to make it easy to export metadata back to Excel -- they want to keep you using the software. This runs at odds with the data portability and freedom that is needed for a successful replacement.

Whatever will replace Excel won't be a facsimile of the current tooling (what Google and Apple are trying to do), nor will it be a siloed experience (what the myriad of SaaS apps are trying to do).

janci• 4 years ago

Hey sheetjs, I have been trying to buy a Pro license from you but only got ghosted :(

analog312• 4 years ago

First you have to know all the things it's used for, and possibly even Microsoft doesn't know. Short of that, you have to duplicate all of its functionality. You can't follow the 80-20 rule if you don't even know the 20. I think this is also one of the causes behind the Second System Effect.

squokko• 4 years ago

1) Excel just has a fucking ton of features, it's really hard to compete with a product that is responsible for at least $100 billion of Microsoft's value as a company. Any competitor tries to convert Excel spreadsheets but is always missing one or two things.

2) There are a bajillion Excel documents out there that people need to interoperate with, but I think this is less important than (1)

3) Microsoft sells their products as part of a huge bundle, so any one Microsoft product is essentially "free" when compared to the alternatives. This is the toughest nut to crack. You make a better Excel. Well, OK. Your customer is already paying Microsoft $xx/user/month for Word, PowerPoint, Teams, Windows, Active Directory, etc, and that won't change if they stop using Excel. But now they gotta pay you... not a really attractive proposition for them.

JumpCrisscross• 4 years ago

every SaaS space is heavily inundated with people trying almost every angle to rethink every data visualization and manipulation program, except for the straightforward spreadsheet

Excel killers may be the most common start-up idea after dorm delivery.

hermitcrab2• 4 years ago

I'm not sure we need to replace Excel. Just need to just stop using it for things it wasn't designed for and isn't good at.

Airtable does a pretty good job of combining elements of spreadsheet and database in a package that supports collaboration. It's not going to replace Excel though.

cm2187• 4 years ago

The problem is that excel is a lot of things packed into a single application and the attempts I have seen at challenging it typically only consider one usage.

for some people, it is a tool to:

- just to format a table to be printed

- visualise and analyse large amount of data (pivots, chart)

- store data (like a database)

- make complex calculations (financial modelling or else), which can go from a quick, one off throw away calc to an established critical process

- automate tasks (VBA - more often that not with close to zero programming skills)

- just a convenient UI to edit data (I often use .xlsx as configuration files when a script requires lots of mapping to be maintained by end users)

I have seen lots of attempts that address one or two of those points. But all of them at once?

johnwalkr• 4 years ago

It's caught up but, Numbers and especially Sheets worked much better than Excel for collaboration until recently. Sheets is still the best here in my opinion.

Aside from that, Sheets is easier to use for pivot tables. Numbers has one underrated killer feature: independent tables with independent formatting on one screen.

But none of that matters because excel is just the de facto standard, and it's really hard to grow a company to a certain size and not end up with having Office licenses for everyone.

drexlspivey• 4 years ago

BallmerCon 2022

rad_gruchalski3• 4 years ago

Kind of orthogonal questions on spreadsheets.

Does anyone know any good resources describing how the spreadsheet software is actually built? Especially the part where formulas are written using column and row numbers but when columns/rows are added or removed, formulas are updated and remain in sync?

RodgerTheGreat• 4 years ago

One facet of the apparent complexity comes from the fact that Excel's default "A1" cell indexing style is actually a facade for "R1C1" style references, which can express relative cell coordinates. A column of identical R1C1 references appear to change when you add or remove rows and columns around them because they're being shown as A1.

HPsquared• 4 years ago

This, and updating of values when a cell is updated. Formula evaluation is based on a directed acyclic graph. If a node on the graph is updated, everything "downstream" gets updated but the formulas "upstream" don't get re-evaluated.

i_don_t_know• 4 years ago

I don’t know if these books address your specific question, because I haven’t read either one.

Peter Sestoft has looked at spreadsheet implementations:

Spreadsheet Technology http://www.itu.dk/people/sestoft/funcalc/ITU-TR-2011-142.pdf

Which seems to cover similar topics as his book: Spreadsheet Implementation Technology https://mitpress.mit.edu/9780262526647/spreadsheet-implement...

warpech• 4 years ago

Spreadsheet Implementation Technology is really solid

rad_gruchalski3• 4 years ago

Thank you, this is great.

nixpulvis• 4 years ago

Maybe I'm just drunk but... wtf am I reading right now?

mcbishop• 4 years ago

I'd like this article more if it actually went into the sorts of problems these competitors were asked to solve.

jimmySixDOF• 4 years ago

You mean like build "A 3D animated roller coaster in Excel"

https://m.youtube.com/watch?v=IrVA1BBHFHw

rvba• 4 years ago

That is absolutely not one of the problems they solve.

Your link is awesome, but factually incorrect.

dang• 4 years ago

The World Excel Championship is being broadcast on ESPN - https://news.ycombinator.com/item?id=32417534 - Aug 2022 (153 comments)

Excel World Championship Finals - https://news.ycombinator.com/item?id=29521324 - Dec 2021 (36 comments)

Top Excel experts will battle it out in an esports-like competition this weekend - https://news.ycombinator.com/item?id=29520827 - Dec 2021 (4 comments)

Yes, there really is a world championship for Microsoft Office - https://news.ycombinator.com/item?id=14954536 - Aug 2017 (2 comments)

UK student wins Microsoft Excel World Championship - https://news.ycombinator.com/item?id=2847334 - Aug 2011 (2 comments)

The World Cup of Microsoft Excel

Related Stories