Dataflow calculators

July 7, 2006

Google spreadsheets lacks some of the “what-if analysis” features of Excel, particulary goal seek and scenarios. That’s ok, of course, because most people use spreadsheets to maintain simple tables and perform simple calculations. Excel is overkill for most people. Instead, I think people might prefer a dataflow calculator, where calculations are performed immediately. Perhaps ZigZag is similar; maybe Subtext, too. Basically, you write out normal program code: “weight=160; height=72; bmi= (weight/height^2)*703”. But like a spreadsheet, the equation is replaced by the answer: 21.70. Maybe the ‘bmi’ variable would have a ‘F’ subscript to indicate it’s a function. Now any change to the height or weight variables immediately changes the BMI. I’m not sure what to do with recursive equations. You don’t want people writing loops. Sometimes you can get away with lazy evaluation, or someone might seed it with initial data: “if n=0, fib = 1”. I’ll need to think about that.


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: