3 ms·
Seems like this begs to have a simplified web interface, where people can adjust some of the top-level parameters, and see the results. Maybe write a tool that
by Tempest1981 9y ago
Seems like this begs to have a simplified web interface, where people can adjust some of the top-level parameters, and see the results.
Maybe write a tool that reads (a snapshot of) the .xls file, and knows which cells are interesting inputs and outputs, to instrument and monitor. But then you need to "eval" all the formulas... seems tricky. Is there an easier way?
Maybe just automate tweaks to a small set of input parameters -- limiting the number of permutations -- and collect the outputs of interest. Then make a simple visualizer of that data. Perhaps even just visualize 5 primary scenarios.
- outsidetheparty 9y agoFrom the article: > At one point, I asked Komanoff is he’d ever considered converting the BTA into some kind of web app to make it accessible to more people. He expressed interest in the idea, but worried he wouldn’t be able to modify the model as easily. Moreover, he values the spreadsheet’s transparency and flexibility, which would be lost in a basic web platform. Of course, a gigantic spreadsheet with 72 worksheets and hundreds of thousands of cells has its own issues of opaqueness. I agree with you, though; I don't know how you'd even begin to tease this thing apart for bugtesting.