HNHacker News
TopNewBestAskShowJobs

countmora

88 karma · joined March 14, 2021

submissionscomments
countmora··on Like MS Excel, Pivot tables never die
If you import with PowerQuery you can explicitly specify the data type for each column.
countmora··on Like MS Excel, Pivot tables never die
I wish more people stop hating on Excel. It's an incredible tool with cool stuff baked in (Python support, PowerQuery, etc.). Just because some people misuse it as database or it doesn't scale well beyond a couple of 10k rows does not make it a bad product. For 90% of daily office tasks it's just fine.
countmora··on IMDB Terminal Browser
Don't want to be that guy, but [1] says

>Robots and Screen Scraping: You may not use data mining, robots, screen scraping, or similar data gathering and extraction tools on this site, except with our express written consent as noted below.

[1] www.imdb.com/conditions/

countmora··on Is my vision that bad? No, it's just a bug in Apple's Calculator
> "Unicode" button label way off center

Its actually the center of the button, I made a video for context: https://imgur.com/a/1Y9O8dS

> The 8/10/16 selector being off center in its own position

Might be due to the image compression, it looks fine on my MB.

countmora··on Spotify demonetizes all tracks under 1k streams
I think royalties from <1k streams are basically nothing anyway. Giving up the ability to distribute your music for free and reach more people would be a terrible idea.
countmora··on Sora: Creating video from text
> We’re also building tools to help detect misleading content such as a detection classifier that can tell when a video was generated by Sora.

I am curious of how optimised their approach is and what hardware you would need to analyse videos at reasonable speed.

countmora··on *@gmail.com
I was still curious about the exact response, therefore I see no harm in posting that.
countmora··on Ask HN: Loud MacBook fan ruining my audio in meetings. Help?
If you have a newer macOS version on an entry Intel machine, ordinary tasks can cause a lot of fan noise. You can activate Low Power Mode [1] to reduce clock speed and therefore the fan will not be as loud. See if the reduced clock speed does not interfere with your daily tasks.

[1] https://www.howtogeek.com/771767/how-to-enable-low-power-mod...

countmora··on Weird GPT-4 behavior for the specific string “ davidjl”
> unfortunately the tokenizer was trained on this subreddit

Do you have a source for that or was it just an assumption?

countmora··on Vanilla Handbook
It is so frustrating when there is nothing at the top that forwards to the main page,e.g., a project name or logo.

I managed it by clicking on the How to Install guide and then on the download image link.

countmora··on The apps that Americans search to “delete” the most
> My decision to delete Facebook is not captured in their data.

I think for some people, it is. If I want to "delete Facebook" then I want to delete my account and every data associated with it. This is often not a straight forward process because sometimes the delete account option is buried in settings, you have to contact support, fill out a form, etc. Hence a quick search will guide you through the deletion process.

countmora··on All the streaming boxes suck now
There is a bug since at least two years where Netflix streams at roughly < 480p if you have a ATV4K hooked up to a 1080p screen.
countmora··on Show HN: I trained an AI model on 120M+ songs from iTunes
I've spun up Hitchin' a Ride by Green Day and I think the results are quite interesting. Despite them being completely different from one another, they somehow manage to catch the vibe of certain sections of the song.

Here's the link: https://maroofy.com/songs/1159778217

Really cool project.

countmora··on A secret message in a Colombian song gave hostages hope
Just to add: The sentences start a bit after 1:30, 2:30 and 3:30 respectively.
countmora··on Ask HN: Where are the simple Git GUIs?
I am using https://www.git-tower.com.
countmora··on How a QR code works
This is also greatly covered in the second edition of Charles Petzold's Code.
countmora··on Excel: Getting rid of everything except numbers
So a lot of comments here suggest copying it to another application and process it there.

Two points from my side why I would not do that:

First, you can do this directly in Excel either with a regex expression in a macro [0] or PowerQuery [1].

Secondly, I don’t know about the authors example but generally if you have to do something like this the column is likely to be one out of many, i.e., part of a table. I can’t point my finger to it but I imagine there might be a lot of steps in that process that could go wrong (formatting issues, altering table scheme, etc.)

[0] https://software-solutions-online.com/vba-regex-guide/

[1] https://www.myonlinetraininghub.com/extract-letters-numbers-...

countmora··on The first dating app made for developers
How did you find out that it uses stuff from other websites? Reverse image search?
countmora··on The most satisfying checkbox
The tile animation on your website is also really well done!
countmora··on Epic gives away the entire Bioshock series for free
They once gave away GTA V for free if you set up MFA. They also did the new Tomb Raider Triology a while back.
countmora··on Ask HN: Is Gmail mistakenly reporting legitimate emails as spam?
Yes, I am under the same impression that the spam detection takes some false positives lately. Even an official government mail which was a .gov equivalent. Glad I am not the only one noticing.
countmora··on Move myself to inactive
I always managed to get getter speeds using the aria2 parameter.
countmora··on Avy Can Do Anything
As someone who has only experience with vim and not Emacs, are there any advantages to Emacs or is it just „different“?
countmora··on Show HN: 4K Desktop Wallpaper Generator
On Safari (macOS) it is as impossible to download this easy-to-download-picture as it is possible to download the impossible-to-download-picture[1] from yesterday.

[1] https://news.ycombinator.com/item?id=29358880

countmora··on You can't download this image
I chuckled about this. However you can drag and drop it to your Desktop on macOS.
countmora··on BibTeX Tidy
First I used a VS Code extension for formatting. After getting into my thesis I switched to Zotero[1] to manage my resources. Its extension BetterBibtex[2] can export into a prettyprinted *.bib which refreshes automatically on change. Works on Zoteros subcollections too.

[1]: https://www.zotero.org

[2]: https://retorque.re/zotero-better-bibtex/

countmora··on New MacBook Pro Models Include HDMI 2.0 Port Instead of HDMI 2.1
I have a similar issue with a M1 MacBook Air.

My 1440p 144 Hz monitor works fine on my Intel MacBook Pro via USB C, but the M1 MacBook can’t do more than 60fps on the same connection.

Have not found much info about it at the time either.

countmora··on Ask HN: What're some great cities to live for $2k USD per month?
It won’t be a problem if you don’t know German. Everybody is at least capable of basic English so you will almost never be able to not communicate with somebody. You can take your time with learning the German basics but you can also totally live there for 1-2 years without speaking German. Australian/Irish pubs are generally hosted by people with English as their mother tongue.
countmora··on Ask HN: What're some great cities to live for $2k USD per month?
Vienna.

A great public transport system, fast-ish internet and classical culture. The budget would totally fit the lifestyle but not as cheap as Bucharest and Bratislava.

countmora··on Ask HN: US-Based Fastmail Alternatives?
Maybe https://hey.com?
Page 1 of 2Next →