Hacker News new | ask | show | jobs
by thanatropism 4485 days ago
> normally financial or market sizing ones

A-ha. Here's the hidden assumption. You're looking at sheets that have a handful of parameters/assumptions and span out their consequences. (You want to stake out the market of people selling Monte Carlo add-ins.)

Many people use spreadsheets as ad hoc accretion calculators/graphers/explorers. This very week -- I estimated about a hundred separate generalized-extreme-value models in Mathematica (working basically by hand to import data from Excel; but this because there was a lot of careful culling), then exported a number of statistics from the distributions. Then I spent a couple of hours a day later looking at scatterplots in Excel -- trying transformations, whatever worked -- that helped me show how those models isolated a particular global feature across the hundred-or-so distributions.

I was looking at your demo and shaking my head -- "is this for cash flow models? But it doesn't even have features for stochastic parameters..." But I guess I see it.