I'd love to see this concept taken a step further and be able to write back changes (within reason, of course) to a SQL database.<p>The piece I'd most love to see is some form of editable Pivot Table, where the changes get written back to the appropriate place in the database. For example:<p><pre><code> CREATE TABLE Balances(Account varchar, Scenario varchar, Amount numeric, primary key(Account,Scenario));
-- Pretend that this is pre-populated with all Account and Scenario combinations
</code></pre>
Using this schema, I would want to get a Pivot Table out of this where Account makes up the row labels, Scenario forms the column labels, and the Amount values are the data. Where the magic happens is that I want to be able to make changes to the amounts and have it write those back into the database with the appropriate UPDATE statements.