frontpage.
newsnewestaskshowjobs

Made with ♥ by @iamnishanth

Open Source @Github

fp.

Open in hackernews

Ask HN: How do you deal with large, hard-to-read Excel formulas?

2•jack_ruru•2h ago
When Excel formulas get large, I often lose track of what’s actually happening.

I’m wondering whether representing formulas structurally (instead of plain text) could make them easier to read and modify, but I’m not sure if this really helps in practice.

How do you usually handle large formulas?

Comments

Someone1234•1h ago
Break them down into multiple smaller formulas, with a column above explaining what they each do. Then consume the previous result in the next formula. This doesn't even need to be on the same sheet as the actual primary consumer sheet.
jack_ruru•1h ago
Yeah, that’s usually what I do as well. Breaking formulas into helper columns definitely makes things clearer.

What I’ve been running into is cases where large formulas already exist (and refactoring them into multiple columns isn’t always an option), so I started wondering whether a structural representation could help with understanding and small edits, rather than replacing that approach.

I’m not convinced it’s better yet — just exploring the space.

anigbrowl•55m ago
Break them into components and calculate the result iteratively if you can; I prioritize clarity and provability over raw performance. If it's a set of standard formula specific to an industry, consider lambda functions.

Code Coverage

https://keploy.io/blog/community/understanding-code-coverage-in-software-testing
1•sophielane•2m ago•0 comments

A quantum mystery that stumped scientists for decades is solved

https://www.sciencedaily.com/releases/2025/12/251217082509.htm
2•croes•8m ago•0 comments

2026 Apple introducing more ads to increase opportunity in search results

https://ads.apple.com/app-store/help/ad-placements/0082-search-results
1•punnerud•8m ago•2 comments

Gut microbe Turicibacter prevents weight gain

https://newatlas.com/diet-nutrition/weight-gain-gut-microbe/
2•thunderbong•9m ago•0 comments

Getting bitten by Intel's poor naming scenes

https://lorendb.dev/posts/getting-bitten-by-poor-naming-schemes/
3•LorenDB•11m ago•1 comments

Caro – a local offline shell companion for when you forget commands (alpha)

https://www.caro.sh/
1•kobi_kadosh•11m ago•1 comments

Linux Foundation Annual Report 2025

https://www.linuxfoundation.org/resources/publications/linux-foundation-annual-report-2025
1•lawrencejgd•14m ago•0 comments

Brown University Shooting Suspect Found Dead in New Hampshire

https://www.vanityfair.com/news/story/person-of-interest-arrested-in-brown-shooting
1•sampo•15m ago•1 comments

Why OpenAI’s Move to Skills Matters If You’re Shipping AI Agents

https://medium.com/@ohansemmanuel/why-openais-move-to-skills-matters-if-you-re-shipping-ai-agents...
2•ohans•17m ago•1 comments

Nob – Turn any terminal AI-powered (Open Source)

https://github.com/hetpatel-11/nob
1•hkpatel•17m ago•0 comments

Building ScrapeForge in public starting tomorrow

1•Vishwas-Batra•19m ago•0 comments

Meta Is Developing a New AI Image and Video Model Code-Named 'Mango'

https://www.wsj.com/tech/ai/meta-developing-new-ai-image-and-video-model-code-named-mango-16e785c7
1•fortran77•23m ago•1 comments

Blackbox open source agentic coding tool that lives in your terminal

https://github.com/blackboxaicode/cli
1•rizkrob•24m ago•1 comments

Administration Plans to Break Up Premier Weather and Climate Research Center

https://www.nytimes.com/2025/12/17/climate/national-center-for-atmospheric-research-trump.html
1•zekrioca•24m ago•0 comments

Mistakes marred Australian telco firewall upgrade, contributing to deaths

https://www.theregister.com/2025/12/19/optus_emergency_outages_cause_report/
1•defrost•32m ago•0 comments

CDC Spelling Error Dictionary

https://ftp.cdc.gov/pub/health_Statistics/nchs/Software/mmds/2009/spell/mmds_spell.txt
1•gregsadetsky•35m ago•0 comments

I Made UTM Triggered Popups

1•matanblay•38m ago•0 comments

Man suspected in shooting at Brown and nuclear physicist has been found dead

https://www.theguardian.com/us-news/2025/dec/18/suspect-brown-university-shooting
2•pogue•39m ago•0 comments

Show HN: I Built UTMKit to Save Time on Popups Specifically UTM Triggered Popup

https://utmkit.io/
1•matanblay•39m ago•0 comments

An Alternative to Khan Academy

https://books.innings2.com/blog/general/khan_academy_alternative/
2•nutanc•44m ago•0 comments

My Downloads – Chrome Web Store

https://chromewebstore.google.com/detail/my-downloads/ienfdfooajmkbebiaplehejbamefbboi
1•mnunkowme•45m ago•0 comments

AI Vibe Coding, Is It Working? No

https://www.mindprison.cc/p/ai-vibe-coding-is-it-working-no
1•13years•46m ago•0 comments

Jax-JS

https://jax-js.com/
1•aizk•48m ago•0 comments

Google works with Meta on TorchTPU to enhance TPU compatibility with PyTorch

https://www.reuters.com/business/google-works-erode-nvidias-software-advantage-with-metas-help-20...
2•mfiguiere•50m ago•0 comments

Rust's Block Pattern

https://notgull.net/block-pattern/
1•zdw•50m ago•0 comments

The Life Engine

https://thelifeengine.net/
1•andsoitis•53m ago•0 comments

Reinventing the dial-up modem (2019)

https://saket.me/dtmf-tones/
1•todsacerdoti•53m ago•0 comments

Hasbro Think-a-Tron [video]

https://www.youtube.com/watch?v=GXwUiogMd_4
1•gregsadetsky•55m ago•1 comments

How to learn shaders: a beginner's guide

https://www.fragments.supply/writing/25-getting-started-with-shaders
1•msephton•56m ago•0 comments

L.A.'S Richest Man Went from Billions to Bust

https://www.wsj.com/real-estate/luxury-homes/gary-winnick-global-crossing-77595ea6
1•kamaraju•56m ago•0 comments