HackerTrans
TopNewTrendsCommentsPastAskShowJobs

jimniels

no profile record

Submissions

Cursed Excel: "1/2"+1=45660

quadratichq.com
136 points·by jimniels·ปีที่แล้ว·134 comments

comments

jimniels
·9 เดือนที่ผ่านมา·discuss
Ah this is a good one! I should maybe start considering this as a default...
jimniels
·9 เดือนที่ผ่านมา·discuss
My first thought on finding this: needs an rss feed! TY
jimniels
·10 เดือนที่ผ่านมา·discuss
Owner of said personal site here: that's nice of you to say. Thank yoU!
jimniels
·12 เดือนที่ผ่านมา·discuss
Author here: I didn’t realize that misspelling until now. But I like it. Gonna leave it. Thanks for pointing it out ha!
jimniels
·ปีที่แล้ว·discuss
author here, thx for pointing these out! I was simultaneously working on some CSS for my blog on localhost and when I looked up some references to older articles to put in my post, I looked them up in the version of my site that was running locally and forgot to change the links lol. Whoops. Fixed now — thanks again!
jimniels
·ปีที่แล้ว·discuss
author here: this is a great point, thx for pointing it out! also love this summation

> We are effectively writing in a fictitious language and pass it through a series of transformations until we finally get syntactically valid JavaScript

that article sounds interesting...
jimniels
·ปีที่แล้ว·discuss
Cool! Made me want to try building it in Quadratic because you can tie the live data source into the spreadsheet.

I didn’t use the more comprehensive dataset in big query [1] and I didn't use the firebase API [2] either because it's so much data to go through. Instead I used the Algolia search API [3] because it was easy ha.

The resulting charts [4] are, if nothing else, interesting to look at and on first glance similar to what I see in the og google sheet.

Disclosure: I work on Quadratic and this was a good exercise in using the product (and finding bugs). The spreadsheet is available to look at publicly [5]

[1] https://console.cloud.google.com/bigquery?p=bigquery-public-...

[2] https://github.com/HackerNews/API?tab=readme-ov-file

[3] https://hn.algolia.com/api

[4] https://github.com/user-attachments/assets/a97ba432-d6dd-4d1...

[5] https://app.quadratichq.com/file/033d2fa7-b205-4c27-9fce-247...