1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Spent 2 hours reconciling 3 Excel sheets today. Built an AI tool to do it in 30 seconds. Looking for beta testers.

I work in HFT where a manual Excel error isn't just a typo—it's a compliance fine. We spent months fighting with:

  • Macros: Breaking every time a broker added a column.
  • Vision-based AI: Way too slow/unreliable for multi-sheet reconciliation.

We decided to build a custom execution engine that hooks into the Excel object model directly. Instead of "looking" at pixels, it maps the sheet structure dynamically. It turned our 45-minute daily reconciliation into a 30-second automated run.

The Tech: It’s built as an MCP (Model Context Protocol) server. You give an LLM the "intent," and the engine handles the cross-sheet lookups and normalization without the AI having to "guess" where the data is.

Question for the community: For those of you doing high-stakes reconciliations—what’s your biggest "failure point" when trying to automate? Is it the file structure changes, or the cross-referencing logic?

I’m refining the engine and would love to see if this logic holds up against other messy sheet structures. Happy to share what we've built if anyone wants to stress-test it.

submitted by /u/FoodStrict3468
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#Excel compatibility
#real-time data collaboration
#rows.com
#big data management in spreadsheets
#conversational data analysis
#automated anomaly detection
#cloud-based spreadsheet applications
#financial modeling with spreadsheets
#intelligent data visualization
#google sheets
#HFT
#Excel sheets
#reconciliation
#AI tool
#execution engine
#Excel object model
#automation