evandwight

What doesn't click? I've found it pretty intuitive, though I've explicitly avoided making complicated types.

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.

Selling derivatives looks great until it doesn't.

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...

Can't you get flagged/dead posts on the new listing or firebase if you really wanted?

Why?

Can you just plot the histogram and guesstimate based on the distribution?

>>>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

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.

Ah thanks for clearing that up

Someone just created that!

https://excelformulabot.com/

Apparently Microsoft is creating a plugin.

(Not affiliated)

Don't they have arrays in single cells?

https://www.lifewire.com/excel-single-cell-array-formula-312...

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

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!

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)

For those who are wondering how this equation is true:

https://en.wikipedia.org/wiki/Law_of_total_variance

2015. This is not a new take on the current state.

Unlikely to ever find a gp - Victoria Bc

Ah. That makes sense. It's a tool that tests certain things.

My question was what percentage of results in mice generalize to humans?

To confirm I'm interpreting your answer directly. It depends on how the scientists use the tool. It is good at verifying certain aspects but not others.

How good are mice models? My uneducated thoughts are they are unlikely to generalize to humans - like testing carcinogens in petri dishes

I agree that as a community diversifies beyond a single group a referendum will give a more generic answer.

It works well so long as you are like the group. I think subreddits are a good way of focusing on a topic.

I'm trying to solve this by crowd sourcing curation.

Most votes != Weekly news letter worthy

I separated them by making a "deeply important" flag. That flag gets set by efficiently estimating a referendum (elected mods, statical sampling, referendum).

https://efficientdemocracy.com

I need feedback.

How hard is it to actually get mail delivered?

I have the dumb idea of trying to make SMTP as cheap as http. Make spam expensive using proof of stake.

I find it frustrating I have to pay Amazon to send text for me. I was going to setup my own SMTP server but it seemed like too much work.

2015

> We nevertheless stress that such improvements are only of theoretical interest, since the huge constants involved in the complexity of fast matrix multiplication usually make these algorithms impractical.

It's only for mathematical interest

Currently, there are two features:

* A weekly newsletter of top hacker news posts [0]

* Filtering hacker news to just technical posts [1]

What makes it special is the categorization is decided by an estimation of a referendum. We estimate referedums using elected representatives, statistical samples and referendums. The efficient corrected by the accurate. The goal is to spread the work of curation so the signal to noise ratio improves. Consensus among your peers is a good signal. For more details see the longer explanation of democratic moderation[2].

Next steps:

* Curate hacker news comments

* Curate /r/science

* Content creation - submitting posts/comments

* New name

Eventually:

* reimagine reddit so the discussion reflects the desires of all users and not just the most active and passionate [3]

The code is available on github [4]. It's a mess (cashier's first website). Some silly things I've done:

* Using ReactDOMServer.renderToStaticMarkup to replace EJS so the compiler catches view type errors

* Cache using a global object on my single webserver - no memcache/redis

Biggest regret:

* Not using a more opinionated framework as I've rewritten many things 3 times and focused more the optimality of plumbing than user experience - fun as that is.

[0] https://efficientdemocracy.com/about/what-is-this

[1] https://efficientdemocracy.com/r/hackernews/technical-and-ho...

[2] https://efficientdemocracy.com/about/democratic-moderation

[3] https://efficientdemocracy.com/about/how-we-are-different

[4] https://github.com/evandwight/efficientdemocracy

I didn't say you didn't. I was trying to show what would happen if you didn't vote and therefore why your vote matters.