evandwight
Joined 5 years ago
Karma
148
Submissions
91
Member since
Aug 11
Recent submissions
Comment · 3 years ago
What doesn't click? I've found it pretty intuitive, though I've explicitly avoided making complicated types.
Comment · 4 years ago
It's not hard to use tailwind without knowing css. Google answers your question 90% of the time. The other 10% you read about the appropriate css and then translate that to tailwind.
Comment · 4 years ago
Selling derivatives looks great until it doesn't.
Comment · 4 years ago
Not even pedestrians die at 30kmph.
Edit: you are right it's about 3% die at 30kpmh, vs ~35% at 50kpmh. My bad. Still lower speeds dramatically improve the safety of cars.
https://nacto.org/wp-content/uploads/2017/11/2011PedestrianR...
Comment · 4 years ago
Can't you get flagged/dead posts on the new listing or firebase if you really wanted?
Comment · 4 years ago
Why?
Comment · 4 years ago
Can you just plot the histogram and guesstimate based on the distribution?
Comment · 4 years ago
>>>0.4% or 163 books sold 100,000 copies or more
>>>0.7% or 320 books sold between 50,000-99,999 copies
>>>2.2% or 1,015 books sold between 20,000-49,999 copies
>>>3.4% or 1,572 books sold between 10,000-19,999 copies
>>>5.5% or 2,518 books sold between 5,000-9,999 copies
>>>21.6% or 9,863 books sold between 1,000-4,999 copies
>>>51.4% or 23,419 sold between 12-999 copies
>>>14.7% or 6,701 books sold under 12 copies
- Kristen McLean from NPD BookScan
Comment · 4 years ago
The incentives encourage selling the data and there's no reason they can't just change their mind one day.
It's a weak promise and a valid criticism.
Comment · 4 years ago
Ah thanks for clearing that up
Comment · 4 years ago
Someone just created that!
Apparently Microsoft is creating a plugin.
(Not affiliated)
Comment · 4 years ago
Don't they have arrays in single cells?
https://www.lifewire.com/excel-single-cell-array-formula-312...
Comment · 4 years ago
This was inspired by a hn comment that linked to "you suck at excel" [0].
First, I realized how much I suck at excel despite being in love with it. Excel just has so many features and the basics are good enough to solve most excel problems. This means I never search for a better method and only discover features through word of mouth.
Then, I realized many of the suggestions could be automatically applied (named cells, standardized color formatting, defined tables). Other suggestions could just be recommended (you seem to be using formulas to build a pivot table, click here to learn about pivot tables).
This seems to obvious so it probably exists. But I only found Microsoft's excellent excel static analysis addin ExcelLint.