frontpage.
newsnewestaskshowjobs

Made with ♥ by @iamnishanth

Open Source @Github

fp.

Zen Tools

http://postmake.io/zen-list
1•Malfunction92•2m ago•0 comments

Is the Detachment in the Room? – Agents, Cruelty, and Empathy

https://hailey.at/posts/3mear2n7v3k2r
1•carnevalem•2m ago•0 comments

The purpose of Continuous Integration is to fail

https://blog.nix-ci.com/post/2026-02-05_the-purpose-of-ci-is-to-fail
1•zdw•4m ago•0 comments

Apfelstrudel: Live coding music environment with AI agent chat

https://github.com/rcarmo/apfelstrudel
1•rcarmo•5m ago•0 comments

What Is Stoicism?

https://stoacentral.com/guides/what-is-stoicism
3•0xmattf•6m ago•0 comments

What happens when a neighborhood is built around a farm

https://grist.org/cities/what-happens-when-a-neighborhood-is-built-around-a-farm/
1•Brajeshwar•6m ago•0 comments

Every major galaxy is speeding away from the Milky Way, except one

https://www.livescience.com/space/cosmology/every-major-galaxy-is-speeding-away-from-the-milky-wa...
2•Brajeshwar•6m ago•0 comments

Extreme Inequality Presages the Revolt Against It

https://www.noemamag.com/extreme-inequality-presages-the-revolt-against-it/
2•Brajeshwar•6m ago•0 comments

There's no such thing as "tech" (Ten years later)

1•dtjb•7m ago•0 comments

What Really Killed Flash Player: A Six-Year Campaign of Deliberate Platform Work

https://medium.com/@aglaforge/what-really-killed-flash-player-a-six-year-campaign-of-deliberate-p...
1•jbegley•7m ago•0 comments

Ask HN: Anyone orchestrating multiple AI coding agents in parallel?

1•buildingwdavid•9m ago•0 comments

Show HN: Knowledge-Bank

https://github.com/gabrywu-public/knowledge-bank
1•gabrywu•14m ago•0 comments

Show HN: The Codeverse Hub Linux

https://github.com/TheCodeVerseHub/CodeVerseLinuxDistro
3•sinisterMage•15m ago•2 comments

Take a trip to Japan's Dododo Land, the most irritating place on Earth

https://soranews24.com/2026/02/07/take-a-trip-to-japans-dododo-land-the-most-irritating-place-on-...
2•zdw•15m ago•0 comments

British drivers over 70 to face eye tests every three years

https://www.bbc.com/news/articles/c205nxy0p31o
17•bookofjoe•16m ago•4 comments

BookTalk: A Reading Companion That Captures Your Voice

https://github.com/bramses/BookTalk
1•_bramses•17m ago•0 comments

Is AI "good" yet? – tracking HN's sentiment on AI coding

https://www.is-ai-good-yet.com/#home
3•ilyaizen•18m ago•1 comments

Show HN: Amdb – Tree-sitter based memory for AI agents (Rust)

https://github.com/BETAER-08/amdb
1•try_betaer•18m ago•0 comments

OpenClaw Partners with VirusTotal for Skill Security

https://openclaw.ai/blog/virustotal-partnership
2•anhxuan•18m ago•0 comments

Show HN: Seedance 2.0 Release

https://seedancy2.com/
2•funnycoding•19m ago•0 comments

Leisure Suit Larry's Al Lowe on model trains, funny deaths and Disney

https://spillhistorie.no/2026/02/06/interview-with-sierra-veteran-al-lowe/
1•thelok•19m ago•0 comments

Towards Self-Driving Codebases

https://cursor.com/blog/self-driving-codebases
1•edwinarbus•19m ago•0 comments

VCF West: Whirlwind Software Restoration – Guy Fedorkow [video]

https://www.youtube.com/watch?v=YLoXodz1N9A
1•stmw•20m ago•1 comments

Show HN: COGext – A minimalist, open-source system monitor for Chrome (<550KB)

https://github.com/tchoa91/cog-ext
1•tchoa91•21m ago•1 comments

FOSDEM 26 – My Hallway Track Takeaways

https://sluongng.substack.com/p/fosdem-26-my-hallway-track-takeaways
1•birdculture•22m ago•0 comments

Show HN: Env-shelf – Open-source desktop app to manage .env files

https://env-shelf.vercel.app/
1•ivanglpz•25m ago•0 comments

Show HN: Almostnode – Run Node.js, Next.js, and Express in the Browser

https://almostnode.dev/
1•PetrBrzyBrzek•25m ago•0 comments

Dell support (and hardware) is so bad, I almost sued them

https://blog.joshattic.us/posts/2026-02-07-dell-support-lawsuit
1•radeeyate•26m ago•0 comments

Project Pterodactyl: Incremental Architecture

https://www.jonmsterling.com/01K7/
1•matt_d•26m ago•0 comments

Styling: Search-Text and Other Highlight-Y Pseudo-Elements

https://css-tricks.com/how-to-style-the-new-search-text-and-other-highlight-pseudo-elements/
1•blenderob•28m ago•0 comments
Open in hackernews

Show HN: Frockly – A visual editor for understanding complex Excel formulas

56•jack_ruru•1mo ago
I built a visual editor that represents Excel formulas as blocks, making it easier to inspect, refactor, and reason about complex formulas structurally. Frockly is not an Excel replacement. It focuses on understanding and refactoring formulas before bringing them back to Excel. Demo: https://ryuu12358.github.io/Frockly/ GitHub: https://github.com/ryuu12358/Frockly Write-up: https://note.com/ryuu12358/n/naa65d9d5facd (Japanese)

Comments

leobg•1mo ago
Thanks for sharing.

I often have this problem in Google Sheets. So far, i’ve resorted to copying the formula into Sublime Text and then splitting it into multiple lines. Your editor looks much more intuitive.

As demo, it would be nice if one could press a button to load some real data abd formulas. I’m reading HN on my phone. I guess many people do. Coming up with a formula and example data is an extra hurdle, and doing it using just a thumb and dumb autocorrect doubly so.

I did see the screenshots on GitHub. Thumbs up for those!

bthallplz•1mo ago
I haven't been able to try out the OP's link yet (I'm also on mobile right now), but for your current usage of splitting formulas across lines, I've used this tool a bunch to do that for me: https://www.excelformulabeautifier.com
tcho•1mo ago
In case this is helpful, you can get newlines within the Excel cell itself by doing the following.

> 1. You can drag down the bottom of the formula bar/field and make it multi-line.

> 2. You can insert arbitrary newlines in an Excel formula.

> For example:

  =INDEX(
  $C$17:$S$24,
  MATCH(A6,$A$17:$A$24,0),
  MATCH(C6,$C$15:$S$15,0)
  )
I learned this from this comment from last week: https://news.ycombinator.com/item?id=46341227
knollimar•1mo ago
The "let" function may be of interest to those wanting to excel more programmatically. There's also lambda that is interesting for the more modern excel use cases.

=Let(table,$C$17:$S$24,

rowName,A6,

colName,C6,

headerRow,$C$15:$S$15,

headerCol,$A$17:$A$24,

rowIndex,MATCH(rowName,headerCol,0),

colIndex,MATCH(colName,headerRow,0),

index(table,rowIndex,colIndex)

)

or even

=LAMBDA(table,rowNames,colNames,rowToFind,colToFind,

     LET(

          rowIndex,MATCH(rowToFind,rowNames,0),

          colIndex,MATCH(colToFind,colNames,0),

          INDEX(table,rowIndex,colIndex)

     )
)($C$17:$S$24,$A$17:$A$24,$C$15:$S$15,A6,C6)

(Also alt+enter to input the newlines)

Cordiali•1mo ago
You can also put the lambda function inside the let function, which is handy.

Also, almost everyone should be using tables instead of ranges. The references are missing a few features, but it makes formulas a brazillion times more readable.

croisillon•1mo ago
you might enjoy "You Suck at Excel, by Joel Spolsky" https://www.youtube.com/watch?v=JxBg4sMusIg
paulmooreparks•1mo ago
One of the best videos ever. This set me on the path to having respectable Excel kung fu that was the envy of all my colleagues.
jimnotgym•1mo ago
I use Excel a lot, and run a team that use it more. One of biggest tips I give is to not write complex formulae if you can help it. Split it into more cells, so it goes step by step. It looks less cool, but when you have to edit it in 6 months you will thank me.

It is not always possible, of course. But it normally is. For the edge cases a helper like this must be nice. Maybe some fields have lots of edge cases, mine has few.

trollbridge•1mo ago
Excel is often an exercise in the equivalent of writing Perl one-liners, except without the charm of wondering to yourself if you could win an IOCC contest.
gabrielsroka•1mo ago
The animated gifs on your readme are completely useless. They change way too fast to read and there's no way to pause it.

Either make it a video so you can pause it or just have static screenshots without animation.

jack_ruru•1mo ago
That’s fair feedback — I’ll add static screenshots or a slower demo. Thanks for pointing it out.
SuperNinKenDo•1mo ago
I'm one of those sick, sad puppies that enjoys Excel shenanigans. Haven't been able to trst it out since I'm on my phone, but screenshots look promising, I look forward to trying it out.
remark5396•1mo ago
This made me wonder, why there is no syntax highlighting support for Excel? I've never thought about that before.
radial_symmetry•1mo ago
Very cool, it is so easy to get lost in Excel formulas and I am amazed that something like this hasn't been built into Excel already!

I noticed there is no license on the Github, do you intend for this to be open source?

jack_ruru•1mo ago
Good catch — I’ve added an MIT license to the repository. Thanks for pointing it out.
montesito•1mo ago
This is a great job! I like it. Congratulations. And thanks for sharing it. I have made lots of improvements and I would like to share with you if you accept. How?
jack_ruru•1mo ago
Thanks! Please feel free to open an issue or a PR on GitHub. I’d be happy to discuss improvements there.
jack_ruru•1mo ago
Thanks for all the comments! I just added mobile view support and updated the README based on the feedback.
phonon•1mo ago
Seems similar to https://github.com/Nekomajin42/spreadsheet-blocks ?
jack_ruru•1mo ago
Yes, they’re related in spirit — thanks for the link!

Spreadsheet-blocks focuses more on building spreadsheets visually, while Frockly is primarily about inspecting and refactoring existing Excel formulas and making their structure explicit.

I think they’re exploring adjacent but slightly different problems.

jack_ruru•1mo ago
Larger update since the last post:

– Added the i18n foundation – Introduced an initial French translation – Implemented URL parameter support for loading state and navigation

Thanks again for the feedback — it directly influenced this refactor.