_dain_

63 ms·

961.
by _dain_ 4y ago
Visit Copenhagen sometime, you'll see most people on bikes just do it in normal clothes. They just ride at a comfortable speed. They're not racing.
962.
by _dain_ 4y ago
Ebikes make hills irrelevant, and make it less unpleasant to ride in poor weather. This is the golden age of the bicycle.
963.
by _dain_ 4y ago
> That said, the vulnerability of cyclists to cars poses its own lethal risks. But these aren't anywhere close enough to outweigh the benefits from lower obesity. (They'd add about 90,000 and 160,000 additional deaths per year
964.
by _dain_ 4y ago
agreed on everything except acceleration
965.
by _dain_ 4y ago
Trainline.com is for buying train tickets in the UK/EU, doesn't require any signup at all. Pretty good.
966.
by _dain_ 4y ago
You joke, but: https://www.reddit.com/r/excel/comments/a0wot5/excelgore_sto... >A elderly guy - maybe in his 60s - was writing his book of poems on his computer and brought in a floppy disk because he
967.
by _dain_ 4y ago
>It is literally impossible. You can do this in Powerquery. >VLOOKUP when the data type of the 2 columns is not exactly the same for example). Use XLOOKUP.
968.
by _dain_ 4y ago
Use the LET formula. It gives you lexically scoped variables inside a formula. =LET(foo, ComplicatedExpression(), bar, AnotherComplicatedExpression(), baz, AnExpressionInvolvingPreviousVariables(foo, bar), E
969.
by _dain_ 4y ago
>I'm not sure what "proper tables" would look like This is the third time this has come up on Hackernews in the past week. Excel lets you designate a specific rectangle of cells as a named "table" (this is not
970.
by _dain_ 4y ago
>It has near 1:1 function compatibility. You're kidding, right? LibreOffice Calc does not have: - tables - powerquery - dynamic array formulae - XLOOKUP, LET, FILTER, and the rest of the extremely useful new formulae These four thin
971.
by _dain_ 4y ago
I like it for precisely that reason.
972.
by _dain_ 4y ago
the dinosaurs didn't die out though. there are birds. they make a tweet-tweet-tweet noise.
973.
by _dain_ 4y ago
great, now do versailles. or brest-litovsk. a bad peace treaty is not an excuse for barbarism.
974.
by _dain_ 4y ago
>Can you learn how to play the piano with Spaced Repetition? No. care to back up this claim?
975.
by _dain_ 4y ago
no? I'm adding to it
976.
by _dain_ 4y ago
Oooh, this looks lovely, thank you for showing me this. EDIT, hm he seems to be missing some obvious cognates, e.g. >propio, own (adj.); proper (cognate). Proper in modern English no longer has the meaning "own", but this word
977.
by _dain_ 4y ago
“It is a profoundly erroneous truism, repeated by all copy-books and by eminent people when they are making speeches, that we should cultivate the habit of thinking of what we are doing. The precise opposite is the case. Civilization advanc
978.
by _dain_ 4y ago
This is good. It's the first decent post I've seen about this instead of someone either giving advice so vague as to be useless, or sneeringly dismissing the value of memorization in mathematics. Actionable advice. I tried SRS a w
979.
by _dain_ 4y ago
I don't think you're actually a real frog.
980.
by _dain_ 4y ago
>You learn that lunch is "almuerzo" in Spanish, but is it learning or just memorization/association? To me the lines are blurred, even at first sight of the word. I think there's a difference. "Almuerzo" -&g
981.
by _dain_ 4y ago
>I mean, isn't this just a button that adds some named ranges for you? No, named ranges don't automatically expand when you add new rows, and they aren't automatically created when you add new columns. And they don't
982.
by _dain_ 4y ago
Vertical space is at a premium, no sense in having lines with nothing but a single close paren. You don't want to drag down the formula bar and start hearing the Star Wars title crawl music in your head. It's worth checking out th
983.
by _dain_ 4y ago
DUDE, please for the love of god, implement/fix the following following few things and I'll be a happy spreadsheeter: - INCREMENTAL FIND WITHOUT A FAILURE MODAL in the ctrl-f window. Right now, when no match is found, it pops up a
984.
by _dain_ 4y ago
Do you know about the LET function? It lets you make lexically scoped variables. And the IFS function is basically an if-elif(-elif...)-else chain, eliminating nested IF. So your example would be: =LET( foo, LongExpression,
985.
by _dain_ 4y ago
I wrote another comment that also answers yours for the most part: https://news.ycombinator.com/item?id=32365128 tldr your problem with Excel is that you don't grok tables. They eliminate the need to know the number of
986.
by _dain_ 4y ago
>It seems like your argument is that alternatives don't have PowerQuery. That might be true (I don't even know what it is), but isn't that like saying Linux can't compete with Windows, because it doesn't have Int
987.
by _dain_ 4y ago
PowerQuery. It's a tool built into Excel. It's a GUI that wraps an almost purely-functional DSL designed for ETL and data munging, called the M language. You can either use the GUI or write the code directly. It has first class fu
988.
by _dain_ 4y ago
>an Excel-with-SQL-querying product This is basically what Powerquery is, and it's been built into Excel for years. And it does other things too.
989.
by _dain_ 4y ago
Can you give a more detailed description of what you were trying? I can't know for sure, but it sounds like Excel can easily handle what you've described, if you use it right. >the entire paradigm revolves around knowing the sh
990.
by _dain_ 4y ago
It doesn't let me enter the letter P.

More ›