skysight-inc/HackerNews huggingface dataset:
Ask HN: What's the most painful thing to do on Excel
Hi! I'm currently trying to find an interesting problem to solve and I've seem that a lot of people keep using Excel in their day-to-day lives. Many products out there try to replace Spreadsheets with some "from-scratch" solution.

However, I think that it'd be interesting to build things on top of Excel that basically improve on top of the main pain points.

With that said, I wanted to ask y'all what's the most painful thing you find yourself needing to do in Excel right now and maybe what have you tried as an alternative that may/may have not worked.

Would love to hear your thoughts on this! :)
If you're both connected to the Internet and NAT didn't exist, you could run a small server and he could get your files
Unpinterested is an extension do do this automatically
This could just be part of the law. In the end it is not that much different than the current situation, every couple of years the minimum wage gets adjusted after looking at the numbers. Having the law state the minimum wage in real dollars and specifying how convert the value would in the end just automate this process and adjust the minimum wage every year or so.
Get FREE $125 in Microsoft ads
Nope! If you want a concrete example I’d recommend looking at the Unity DOTS stuff which is their data-oriented stack and does include an ECS as part of it.
Funnily, I always had the impression that Instagram main (maybe only?) purpose was to watch ads ("influencers" as they call them these days), so I figured out they must be pretty good ads since people are coming there just for them ;)
this is not news about the content hidden behind login. Like come on. This is just a whiny post from a guy that for some reason didn't know this from like a 2 years ago!
Nothing about a pattern or simply coming to the realization that IG wants only users of its platform who log in, to use it and see its content! Not really knew considering in the early days it was an APP only platform....we've only been lucky to have the web desktop version for a short number of years.

Do I like this behaviour - No. But am I not surprised from a company, as mentioned, hasn't exactly supported anything web/open over its existence. I mean look at the never-resolved feud between twitter and instagram that means you stillllll can't post pics to twitter from Instagram or see preview cards on twitter of IG links etc --all because of a spat like 10 years ago.

But not posting nerdy rants about how I have to use bots and shit to workaround logging into a site I am apparently interested in the content of, but don't want to actually use or participate in.
It did not go well after they left Gaza. Hamas was elected soon after. I am sure this comes into the calculation.
You know, when posting rhetorical questions, you should really check to see if it’s not answered in the post you’re replying to.
I have a buddy who will DM Dungeons And Dragons games on Roll20 with random strangers online. He charges $5 per person per campaign. That's not per game, $5 gets almost weekly sessions in a campaign that can go on for months.

He doesn't do it to make any money. He says that the small fee entirely eliminated trolls, and almost entirely eliminated people who join for week 1 and never return.
Brilliant name. We have a winner.
Agree. The highest "normal" BMI for my height would require 15 lbs of weight loss. I'll say I could stand to loose upto 10 lbs. I've never been in the normal range in my adult life.
The big difference here is 4chan threads are ephemeral, they rarely show on on search engines. Youtube vidoes often rank highly
We have this on our interview test. It was the one almost everyone got wrong except for a couple people who ended up being really detail oriented and had deep knowledge (as opposed to broad).

We consider >70% passing.
This is honestly an extremely rude and unnecessarily mean comment. I also strongly disagree with it. Large scale actions are needed. Small scale good-samaritan efforts do not move the needle on large issues that require international, inter-organizational efforts.
I've started having weird redirects on any v.reddit.com posts too - they redirect back to main page instead of taking me to the video.

I haven't fully tested what combinations don't work, but it feels like the beginning of the end of old.reddit.com.
So online you can't read minds and lose your unmatched advantage - becoming a blind mute?
Yep! It sounds like overkill, but the suggestion I've seen that seemed to cover all bases was to store:

(1) The time in the local timezone (+ the timezone itself)
(2) The UTC conversion
(3) The version of the IANA database used to compute (2)

Then you can use (2) the UTC time for most computations/queries, but if a timezone changes then you can use (3) to tell which UTC dates need to be updated, and (1) to recompute the new correct version of (2).
This market cap is assuming that Tesla captures the entire auto market at higher margins than any car company to exist ever. To which, I ask, have you seen the auto market? Do you think the Germans are just going to let BMW and Volkswagen die? These companies used to make tanks, and still could if you pressure them enough. Hyundai is 6% of the entire South Korean economy; do you think they are just going to let another company consume that? And as for China, the world's largest auto market, you are at the entire whims of the CCP, which could decide to kick you out in favor of their favorite local competitor at any time.
Nintendo is a bad example actually, because a lot of the "sexy" games are moving to Nintendo Switch and away from Sony PS4/PS5.
That last part doesn't ring true. It's like saying a championship sports team would just chug along without any particular player or coach.
I don't think I've hear of heard of VerticalScope but I aware of Internet Brands. What niche forums did they kill?
I guess "gameification" isn't so great.
This is demonstrably false.

YouTube endorses everything it does not censor.

edit: And you should not put blind trust in any "news" organization either. Every observation deserves your full cognition to figure out what is plausible, consistent, implausible, inconsistent, let alone "true" or "false".
Have you tried hiding the div element with ublock, inspecting the html, and removing the y scrolling hidden rule?

It's common on many websites.

Ublock doesn't remove that rule but you can add it for each site.
Work-to-rule arises due to misaligned goals.

Poor objective functions can be gamed; good ones align goals such that gaming and aligned goal attainment become the same.

I'd rather face the (admittedly formidable) challenge of designing such objective functions in the open than rely on undefined or secretive policy that's hidden.

Assessment requires definition, by definition.
We don't really enforce rules against genocide, I'd be surprised if there was enough international will to enforce ecocide rules.
I thought they already did, this little company called Reddit that went on to benefit from the banality of digg.
While nice in theory, people can generate low effort BS comments far faster than one can properly refute them.
Could you give some insight into how you use Anki for language learning? Thanks.
Siemens Siamatics PLC controllers can achieve real time response in the 250μs range.
That's fair. I didn't relate that my friend went on to say that the reason math is a young man's game is that it's only the young who can read and memorize results fast enough, and keep enough of that information in their head at one time, to do important work at the frontiers of math. The brain has physical limits, just as the rest of the body does.

I am revolted by that idea. And I'm certainly a better coder than I was in my thirties, and I was better then than I was in my twenties. (Not that I'm under the illusion that my work compares to PhD-level math.)
They could, but it looks like waiting a few hours did the trick. https://twitter.com/GerritD/status/1409608525601443840
Of course your carpenter would also be required to cope with regular updates of his hammer, even when he was using it?
I mean no, you're not going to get banned for posting support for universal healthcare, ending the drug war, ending for-profit prisons, etc even though these are extreme left positions in current US politics.

If you post misinformation telling people that it's illegal to charge for healthcare and that you can just throw out any medical bills you receive without recourse, or that drug laws are unconstitutional so you can't actually go to jail for them, or that private prisons don't count so you are allowed to break out of them, well yeah you might get banned!
This obsession hasn't always been good, and often caused Elon Musk to make dishonest statements about the overall state of the business and its future. This should scare anyone who is attempting to value Elon Musk at a realistic level.
As I spent more than 700 hours in application development, I think ... no I decided that I should never give up easily and I will try all possible channels, thank you very much for your explanation and motivation
SUSE CEO Buys Herself a “Woman in IT Award”
The lowlives are now all creating accounts here to come and try to justify their depravity. Liars and sociopaths, the lot of them.
TFA blames "big pharma's stranglehold" for high insulin prices, but interestingly the cheapinsulin.org explanation [1] seems to be much more about "big insurance", with pharma companies basically forced to kow-tow if they want their products to be covered.

[1] https://cheapinsulin.org/high-insulin-prices
Did you ignore the GP's first sentence? For 0.15% to be right either the death #s have to be significantly overinflated, or more than 100% of the U.S. population must have been infected with COVID.

0.5 and 0.27 are both larger #s than 0.15, so that supports the GP's point.
That “order” contains recommendations, encouragements, and suggestions. It doesn’t seem to be legally enforceable.

I think every state had its own variation but ultimately after around April 2020 everyone has been free to get in a car and drive anywhere or get on a plane and fly anywhere within the USA. Some states had compliance regimes where you were supposed to quarantine or be tested after arriving, or be fined, but many did not. I traveled to one state with such an order twice and each time it was essentially voluntary - there was a theoretical fine if I didn’t follow the rules, but no one ever checked up on me to make sure I had a negative test. Unlike overseas governments (Singapore, Australia, China, vietnam, etc) our restrictions were basically on the honor system everywhere.

I believe one major exception is Hawaii where they actually did enforce quarantines somewhat and jailed or expelled tourists, and also had the lowest cumulative per-capita covid death tolls.
> CBC

The Canadian Broadcasting Company: https://cbc.ca

While it's a TV station, and a set of radio stations, they also provide a news website.

> up here

That would be Canada. Like Americans, many of us assume we're talking to Americans when writing online.
Using a VPN, I'm completely locked out of any Facebook page, business or not. It just shows a login form.
The 3 per day per the article is for 1ZJ which is an estimate of total energy consumption, not just replacing the electrical grid.
“When a private company says take your content elsewhere, no one's First Amendment rights are violated.”

I think the concern is moreso regarding massive corporations like Facebook and Twitter working together in lockstep to remove people from their platform that they ideologically disagree with, thus preventing them from reaching their audience.

If Twitter wants to curate which people are allowed to post, then they are a publisher and should be regulated as such. That also means that they need to be held responsible for everything on their platform that they don’t remove.
RIP recent memory (2012-2018)
> 48-bit static IP addresses. 70 trillion should be enough. 128 bits was overkill.

What if humanity becomes a Kardashev type-2 or an interstellar civilization? In that case the population of humans, much less computers, could easily succeed 70 trillion.
Does the ID get registered or do you just show it like when buying alcohol?
This falls down if the timezones themselves change. e.g. if DST was planned, but was then cancelled. You really want to store the original time with timezone as well as UTC.
That's a good argument in favor starting to enforce rules against genocide then, not a reason to stop progress elsewhere.

I guess we may as well let the world burn at the hands of corporations, rather than bother to even say something about it. I'm really surprised at the defeatest attitude on HN about climate issues. This isn't the end. Time is still going, the clock is ticking.
They are both in the video game console market though...
Everyone's trying to shoehorn tech into existing frameworks because they know passing new laws is too hard. As the judge pointed out though, you can't just make shit up and expect to get away with it.
A few seconds after your starting point in that first video, you can see a loop of tape vibrating back in forth in a rectangular channel. That's a vacuum column, with a (mild) vacuum pulling the tape loop to the right. This lets the servomotors that move the tape past the heads start and stop rapidly, while the heavy tape reels can spin up and down more slowly.

See how the vibrating loop passes back and forth across a hole in the middle of the column? That's a pressure sensor. As the loop moves across the hole, the pressure in the hole changes, telling the drive whether it's time to reel in or dispense more tape.

More info: https://en.wikipedia.org/wiki/9_track_tape
Does the ID get recorded though?
Ground breaking bridges would be dangerous
Maybe it's a fine article, but I didn't make it past "imagined anti-conservative bias"
Stream crashing was pretty bad. I work at Microsoft (not in anything related to Windows) and had to watch it on YouTube.
This is not action at all. The ICC is an institution that incinerates money while doing nothing significant to prevent any of the crimes already under its jurisdiction.
Interesting. Didn’t think about that… are you not worried about things getting censored in the other direction?
for Reddit, you can "sign up" with a bogus email address and still interact (browse, join, comment, vote, message) freely. the only possible downside is it asks you to verify your email address every launch, but I don't see this as a downside since I am using Reddit anonymously, and it is easily dismissed. been doing this for over a year now
OOP only strives to encapsulate private state (though don’t forget that too strict rules never make sense. In the end, every design pattern needs an escape hatch). All the methods of the object should modify these in a way that upholds the class invariants. In your example, B can easily be part of the “public state” of the object, or we can make even more gradual distinctions, like only B’s identity is relevant for A’s state. For example, if A only needs B as optional cache, its modification or even removal will not be a problem.
> Minus the animation, isn't this something any smart high-schooler could do with pen and paper?

Our 8 year old does this with pen and paper, and sometimes also with some website that lets you draw molecules (there's a few, forget which one(s) he uses). That said, his molecules aren't always possible (he understands valence but sometimes he makes mistakes with it or just stops caring about it).
That is not really a problem as long as inflation or deflation is not crazy over a year or so. Just make the minimum wage X real dollars based on method such and such and the numbers from last year.
From the FAQ:

> Are reposts ok?

> If a story has not had significant attention in the last year or so, a small number of reposts is ok. Otherwise we bury reposts as duplicates.

It's intentional unclear what significant attention means, but the last submission has (3 points | 64 days ago | 3 comments) that is not very significant.
And oddly ineffective at actually prompting action on closing out those bugs.
My challenge with this is that, I believe, you think instagram is a free service. It isn't, you pay for the service by selling your data to advertisers and using your data for advertisement. If they don't have your data, you aren't paying for the service.

I hate this and also, I don't use their service - same for facebook.
> the current situation, every couple of years the minimum wage gets adjusted after looking at the numbers.

For large values of “couple” (counting the last few back: 2007, 1996, 1989, 1977.) Each of those spread out increases over a few years, but even then there was a wide gap between the last incrrease.and the next adjustment.)
The use of "religious" in my comment might be better phrased as "dogmatic".
Permutation City has another take, where people virtually meet one another but use masks to hide their emotions.
yes you can, but that means less profits, and america puts up with it - https://www.iheart.com/podcast/105-behind-the-bastards-29236...
Congratulations on ignoring the qualifying adjective so that you can look like you’ve constructed a counter-example without actually managing it.
I guess what I've read about fuel economy is outdated. My main point is that: we shouldn't drive faster than our vehicle's limit of optimal fuel economy, since after that point fuel economy drops sharply.

All that said, I don't know what to say about driving 3-4 hours a day. After working 8-10 hours, and driving for 3-4 hours, there's not a lot day left before you have to start all over. Driving a total of 150 miles for groceries blows my mind; that's basically the width of the top half of Louisiana.
>I simply don't understand the healthcare system in the US. Its meant to be a free market, yet insulin costs a ridiculous amount.

the problem? patents https://www.hopkinsmedicine.org/news/media/releases/why_peop...
And furthermore all the content should be delisted from Google for cloaking https://developers.google.com/search/docs/advanced/guideline...
I don't understand why Zoom doesn't get more flak for this. Their web version is intentionally crippled and broken in an attempt to force users to download their app. They won't even show the link to join a meeting with the web version until you have failed to join with the app (it used to require 3 failed attempts, but they seem to have dropped that to a single failed attempt).
There’s the question of what sort of feedstocks they’re using and where they come from.

I would assume that it’s something like what the animals they’re replacing eat, but presumably in smaller quantities since they’re only growing muscle tissue and not an entire animal.

There’s something to be said for a device that transports itself around marginally-arable land eating grass and pumping out fertilizer while creating edible protein. Especially if the alternative is intensively-farmed row crops like corn and soy that tend to require tons of fertilizer and herbicides.

IMO an equally exciting area of research is taking something like algae that only need water, sunlight, and some minerals to produce food. Which could then be further processed into lab-grown meat or be eaten as is.
If you manage to build a large enough empire, then... and only then, can you make the world a better place.
I literally cannot think of any more correct political mission for our media to pursue than holding politicians accountable using their own words. It's not "cancelation" when people hear something a politician said and vote them out of office, we just call it voting.
> This is not action at all.

I mean, it is, though? Did we read the same article?

> incinerates money while doing nothing significant to prevent any of the crimes already under its jurisdiction.

They should improve their actions to prevent the crimes under its jurisdiction, then. I'm not sure how this is relevant to the topic.

Your extreme use of language is making me doubt your points, by the way - I am certain the ICC does not do anything I would approximate with incinerating money.
Even a truly random die is not guaranteed to ever roll a 6.
I bookmarked this comment from a few months ago on how one might make such a trade: https://news.ycombinator.com/item?id=26174690
Why would a government not consider it monopolistic to own both the charging infrastructure and the vehicles themselves?
Magnetic Bubble Memory Fundamentals
Using Fibre-Reinforced Polymer for pedestrian bridges isn’t new, is it?

A few minutes of googling gives me https://www.fibercore-europe.com/en/projects/, which has dozens of FRP bridges. I doubt that’s the only producer in the world. I don’t see what’s special about this one (but feel free to educate me)

That leaves the shape. I would guess the corners in the road are there to avoid having to use land that isn’t owned by the railway. If so, what’s left is the specific design. That’s nice, but other nice designs are possible.

Now, as to the idea of making a pedestrian bridge over a railway: it’s better than no pedestrian connection, but the stairs on such bridges necessarily are fairly high. Train tracks often lie above ground level, and even if they don’t, the total height to the top of the overhead line, plus some safety, plus the height of the bridge’s deck means you’re easily going two floors up and down.
Yeah, I'm an eco-fanatic and this seems unproductive to me. The first thought I had was "Do cars count?" as they seem to fit the description.

FWIW, I think the most useful political-economic thing to do would be to attempt to measure and account for "ecosystem services" both on the degradation/cost and improvement/benefit sides of the balance sheet.
I would make packets over the MTU truncate (with a flag indicating the truncation), adjusting the IP checksum (the same way it's currently adjusted for changes in other fields like the TTL) to match, instead of fragmenting or dropping. That would avoid all the issues with PMTU blackholes or non-initial fragments.
I requested that they turn on 2FA, since they themselves will become an attack target by requesting so much PII

That said, my experience with trying to use any opt-out service (automated or otherwise) is filled with a lot of "Oops, server error, try again later" responses at the end of filling out a ton of forms about oneself, so I wonder if Optery has some secret sauce, is persistent in the face of server errors, or just is fire-and-forget and thus follows the "spray and pray" method of account removal

If I paid actual money for this, I'd want some observable metric showing that I had 166 public listings in June, followed by 66 in July, or something of the sort.
Pay with a coin.
I think you severely underestimate the quantity of top scoring STEM graduates.

What you really mean is “the richest/privileged move to US and Europe”
They add a unique identifier to EFIVARS. That's why if you install a MS store application without being logged in, completely wipe/replace your disks you can still see the list of previous installed applications in the store.
The GP parent said "most" while you're listing obvious outliers.
> advertising

This one would be hard to enforce. Still a good idea.
Instagram have a paywall, to be able to see the content you must pay with your data by creating an account, and later hopefully become addicted to the platform to give more data and eat as many ads as possible.