HackerTrans
TopNewTrendsCommentsPastAskShowJobs

evandwight

no profile record

Submissions

Show HN: An Excel addin to automatically use cell names in formulas

github.com
4 points·by evandwight·4 ปีที่แล้ว·1 comments

Show HN: Stop writing Excel like it's assembly

github.com
5 points·by evandwight·4 ปีที่แล้ว·5 comments

comments

evandwight
·4 ปีที่แล้ว·discuss
What doesn't click? I've found it pretty intuitive, though I've explicitly avoided making complicated types.
evandwight
·4 ปีที่แล้ว·discuss
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.
evandwight
·4 ปีที่แล้ว·discuss
Selling derivatives looks great until it doesn't.
evandwight
·4 ปีที่แล้ว·discuss
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...
evandwight
·4 ปีที่แล้ว·discuss
Can't you get flagged/dead posts on the new listing or firebase if you really wanted?
evandwight
·4 ปีที่แล้ว·discuss
Why?
evandwight
·4 ปีที่แล้ว·discuss
Can you just plot the histogram and guesstimate based on the distribution?
evandwight
·4 ปีที่แล้ว·discuss
>>>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
evandwight
·4 ปีที่แล้ว·discuss
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.
evandwight
·4 ปีที่แล้ว·discuss
Ah thanks for clearing that up
evandwight
·4 ปีที่แล้ว·discuss
Someone just created that!

https://excelformulabot.com/

Apparently Microsoft is creating a plugin.

(Not affiliated)
evandwight
·4 ปีที่แล้ว·discuss
Don't they have arrays in single cells?

https://www.lifewire.com/excel-single-cell-array-formula-312...
evandwight
·4 ปีที่แล้ว·discuss
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.

[0] https://www.youtube.com/watch?v=0nbkaYsR94c
evandwight
·4 ปีที่แล้ว·discuss
Wow! No, probably not. I don't scan macros or other plugins.

I only have 1 recommendation right now and it's super simple: look at formula references to find interesting cells then check for a label to the left.

It's all heuristics and easily broken. It doesn't need to be perfect to help though.

Sidenote: I can't believe excel formulas are Turing complete now! Excel is truly a beast!
evandwight
·4 ปีที่แล้ว·discuss
Why not an index on created for speeding up the "new" sort?

What indexes should you create? One for each sort you have?

(I'm just playing around cloning Reddit and running into all sorts of performance problems. Mostly due to celery taking all my memory)
evandwight
·4 ปีที่แล้ว·discuss
For those who are wondering how this equation is true:

https://en.wikipedia.org/wiki/Law_of_total_variance
evandwight
·4 ปีที่แล้ว·discuss
2015. This is not a new take on the current state.