News for hackers. Stuff that matters.
Re:Show HN: Visualise the structure of a spreadsheet by thanatropism on Thursday March 13, 2014 @12:21PM (#7392793)
> 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.

There are no comments on this comment yet.