HN Showcase
Back to browse
MonteSheet – 100k Monte Carlo runs in ~1.9s in Google Sheets

MonteSheet – 100k Monte Carlo runs in ~1.9s in Google Sheets

by hackiku·Jul 21, 2026·1 point·0 comments
Visit ProjectView on HN

AI Analysis

●●●BangerBig BrainSolve My Problem

Clones your formula graph to run 100k sims locally when @RISK costs thousands.

Strengths
  • •Formula graph cloning means zero data leaves your machine — genuine privacy win.
  • •Seeded RNG with mulberry32 gives auditors reproducible results they actually need.
  • •Bundled Svelte UI in 1.5MB sidebar is impressive constraint engineering for Sheets.
Weaknesses
  • •Google Apps Script V8 runtime limits raw compute speed vs native WebAssembly alternatives.
  • •Niche audience: only matters if you're already doing risk modeling in spreadsheets.
Category
Finance
Target Audience

Financial analysts, risk managers, spreadsheet power users

Similar To

@RISK · Crystal Ball · RiskAMP

Post Description

Pushing Svelte and Google Apps Script to the limit.

Built this Monte Carlo simulation suite that clones the spreadsheet's formula graph (using fast-formula-parser) and runs statistical analysis in sidebar V8. No server round trip or data leaks.

What's interesting: uses Vite to bundle the Svelte UI and math into a 1.5Mb Index.html that Sheets sidebar renders. `bun ship` -> refresh sidebar.

Also mulberry32 for reproducible sim runs to "work on my machine."

The math is open source: https://www.npmjs.com/package/@veenie/risk

Try out the addon in GSheets https://workspace.google.com/u/0/marketplace/app/montesheet/...

Would love some feedback from the finance heads among you. Load examples and break 'em apart!

Similar Projects