IdeaWell

Project ideas from Hacker News discussions.

Ireland’s Diarmuid Early wins world Microsoft Excel title

Original Article

Hacker News Discussion

📝 Discussion Summary (Click to expand)

1. Excel's Maturity and Persistent Legacy Quirks

Excel is seen as feature-complete for decades, with unfixable issues like date/number conversions due to compatibility.
"Excel was completed at least a decade ago (probably two)." - lysace
"Excel is not 'complete' until they stop forcibly converting long strings of numbers into scientific notation" - eszed
"the earliest request for exactly the fix I want is from nineteen-eighty-fricking-five." - eszed

2. Excel's Power as a Programmable Environment

Users highlight Excel's advanced features (VBA, LAMBDA, Python) for complex tasks, akin to functional programming or code golf.
"Excel is the most widely installed functional programming language IDE." - shagie
"Excel is probably the most widely-deployed functional programming environment in the world." - yoan9224
"It was entirely in Excel... a complete aircraft maintenance planning... system." - stackghost

3. Impressive Excel Competitions and Power User Skills

The event showcases algorithmic puzzles via Excel, evolving from joke to esports, with marketing skepticism.
"This is obviously 99% marketing." - lysace
"they're algorithmic puzzles where Excel is the constraint... similar to code golf." - yoan9224
"Excel has been OP for a long time" - INTPenis

🚀 Project Ideas

FormulaLinter: The Excel Logic Optimizer

Summary

  • A specialized IDE-like linter and formatter for Excel formulas that converts "spaghetti" nested strings into readable, indented blocks.
  • It solves the problem of "unreadable and unmanageable" single-line functions identified by users who currently rely on manual Alt+Enter hacks and LET functions to maintain complex logic.

Details

Key Value
Target Audience Financial analysts, Actuaries, and Excel Power Users
Core Feature Automatic indentation of nested functions and variable renaming for LET blocks
Tech Stack TypeScript, React (Office Add-in), Peggy.js (for formula parsing)
Difficulty Medium
Monetization Revenue-ready: SaaS ($10/mo) or Enterprise Site License

Notes

  • HN users specifically highlighted the need for this: "Once you know it, writing single-line functions of any complexity is absurd... it stays in the new size when you move to other cells."
  • It addresses the "undocumented pseudo APIs" and "total shit show" mentioned by enterprise users by enforcing a standard style guide across shared workbooks.

RosettaCell: The Localization & Format Guard

Summary

  • A cross-platform utility and Excel Add-in that handles "syntax translation" between localized versions of Excel (commas vs. semicolons) and protects sensitive data from aggressive "auto-formatting."
  • Prevents the "Genomics problem" (renaming genes to dates) and the "Scientific notation" frustration that has existed since 1985.

Details

Key Value
Target Audience International organizations and Scientific researchers
Core Feature One-click "Clean Import" and dynamic formula localization (e.g., ; to ,)
Tech Stack Python (FastAPI), Excel JavaScript API
Difficulty Low
Monetization Hobby / Freemium for research use

Notes

  • Solves a 40-year-old pain point: "Excel is not 'complete' until they stop forcibly converting long strings of numbers into scientific notation... earliest request for exactly the fix I want is from nineteen-eighty-fricking-five."
  • Directly mitigates the risk discussed regarding international teams: "On my system, all parameter-separating commas have to be replaced with semicolons... That implies the user has to manually change the syntax."

SheetGolf: Competitive Logic Training

Summary

  • A gamified learning platform (similar to LeetCode or Vimgolf) specifically for Excel formulas and logic puzzles.
  • It bridges the gap between "Business users" and "Functional programmers" by teaching advanced concepts like LAMBDA, FILTER, and MAP through time-pressured challenges.

Details

Key Value
Target Audience CS students, Finance interns, and Competitive programming enthusiasts
Core Feature Browser-based Excel emulator with real-time scoring and time-trial modes
Tech Stack WebAssembly (running a logic engine), Next.js, PostgreSQL
Difficulty High
Monetization Revenue-ready: Corporate recruitment tool / Skill assessment

Notes

  • Responds to the fascination with the Microsoft Excel World Championship: "I'd rather see finance/business majors stumble upon their version of LeetCode."
  • Capitalizes on the realization that "Excel is the most widely installed functional programming language IDE" and provides the "Montessori" learning experience users suggested for those moving from formulas to traditional code.

Read Later