Cool idea. Found this from a @worrydream tweet. Some comments after playing with it for a few minutes:
* A bit disappointing that I can only have uniform or Gaussian distributions. At minimum I'd like a binary distribution (coin flip, probably biased coin flip). A lot of things I would want to model need this (e.g., will we close this sale? will we close this investor? that kind of thing.)
* I'm really confused by the arbitrary two-letter codes assigned to things for formulas. Makes the formulas impossible to read. Why not just use the names I give to the cells, or something derived from the names?
Really nice start though! I'm co-founder & CEO of fieldbook.com, another spreadsheet-like tool, so I love information tools and anything that expands the mind's capacity. Best of luck and let me know how I can help!
In response to your points:
- Other distribution types are the #1 most requested feature at this time. Binary distributions are possible using functions instead of the built in distributions, though obviously not intuitive. It's built using math.js, which has several random functions of different kinds. (In this case, you could use '=randomInt(0,1)' to produce a coin flip.
http://getguesstimate.com/models/365
- The arbitrary two-letter codes were simply the easiest thing to begin with. I started with something derived from the names, but this presented problems with cells with empty names, especially ones that started empty and later become non-empty. Excel has a pretty sophisticated model for referencing cells. For the sake of getting something shipped, I started with a very simple one. Definitely an area to improve.
- I'd love to talk sometime. I'm also in SF, will send you an email. Thanks for the advice!
Re the two-letter codes, I totally get doing the simple thing just to launch and get it out there. We face a similar problem in Fieldbook, by the way. Would be happy to explain how our solution works sometime.
Give me beta access! I want to play with this thing.
Wow! The developer tools are amazing too: https://www.youtube.com/watch?v=stwlaJGeLoM
It will be a bit of a challenge to make it intuitive, but I'm sure I'll figure out something.
Just so you know, right now there is a second distribution, uniform. You can access it by clicking the 'normal' icon in a normal distribution, where a short list is shown below.
* Prediction markets are usually for binary outcomes. I imagine the most useful role of binary variables in Guesstimate would be to mix two different distributions. "If Clinton wins, student debt in 2018 will look like distribution A; if Sanders wins, student debt in 2018 will look like distribution B".
* I'm not sure how Augur (or any other market) reports likelihoods, but it's good to keep in mind that market prices do NOT generally reflect any sort of average belief. See https://www.aeaweb.org/assa/2006/0106_1015_0703.pdf.
In the future, one idea would be to keep track of people's metric estimates in Guesstimate, and later score and rank them on how well they do. So if Charles always reports a 90% confidence interval that's far too optimistic, we could help adjust it automatically next time. This would also allow us to aggregate different opinions directly, essentially being like a mini prediction challenge. This would be a ways off though, and it really depends on what direction the product goes.
Only request would be to allow for private spreadsheets. I can download and run the code locally but this would help many people who are less tech savvy.
Great product - looking forward to seeing how it evolves!