5 ms·
It's like a TIL post on the front page of Reddit that states something you assumed everybody knew, yet has 30,000 upvotes.
by listenallyall 4y ago
It's like a TIL post on the front page of Reddit that states something you assumed everybody knew, yet has 30,000 upvotes.
- mathteacher1729 4y agoXKCD 1053 is relevant here. You and I knew it, but there are going to be lots of people who learn about it for the first time today, and that's a net positive.
- ms512 4y agohttps://xkcd.com/1053/ https://xkcd.com/1053/ (to make a link available)
- deleted 4y ago[deleted]
- datavirtue 4y agoYeah, but not a post for HN. Did you know Excel has a programming language!!!??? Whahhh!!!
- Strom 4y agoHN still accepts new accounts. It's not an exclusive club for old people. Even beyond that, stories have been repeating here since the beginning. Not everyone has the same life experiences, and not everyone checks HN at the same time.
- Aeolun 4y agoI didn’t know about named ranges, and think it’s pretty cool. Of course, when I thought of places where I could apply them I realized that by the time I use enough Excel to use named ranges, I should probably switch to a real programming language.
- hwayne 4y agoYes but did you know about the yoga pose button
- kurupt213 4y agoi still don't know what that meant
- hwayne 4y agoThe feature name is "linked data types", under the "data" tab. Put, say, "downward dog" into a cell and click the "yoga" linked data type. There's other, more useful data types, like cities and ZIP codes and stocks, I just listed the yoga one because it's the funniest.
- cookie_monsta 4y agoLooks like the yoga button is a thing of the past :( > After June 11, 2023, data types by Wolfram will no longer be supported and can't be refreshed. However, Bing, Power Query, and Organization data types will still be supported. https://support.microsoft.com/en-us/office/what-linked-data-types-are-available-in-excel-6510ab58-52f6-4368-ba0f-6a76c0190772 https://support.microsoft.com/en-us/office/what-linked-data-...
- yen223 4y agoPerhaps there are time zone differences, but it's not 2023 yet where I am =)
- cookie_monsta 4y agohaha good point, but I can't see those data types?
- turtleyacht 4y agoIt's the learn TLA+ person :) Awesome to hear he is exploring Excel. Is that the manual version of crunching models for formal consistency? Management science is all about modeling stuff in Excel and using solvers. Imagine if somehow we could meld the robustness of TLA+ with the immediacy of an in-built macro-lang, ubiquitously installed .exe that is the spreadsheet. Future sprint planning days: everyone prototypes in the spreadsheet! No one estimates until the rules and formulae make sense.