Here’s a website request and I’m looking to see if it is feasible:
Pull in data using API the imports as CSV, JSON, or XML.
That data occupies first set of columns.
Next, column to input
Next two columns, formula
Ideally, calculate without hitting submit
Calculations to not need to be saved.
Additional info: please do not start you answer with “that’s easy”. By definition, it was easy, a hack like me could have figured it out. Currently, I am pulling the data into Google Docs, protecting the imported data so I can not be changed, adding the additional columns and plopping that in an iFrame in a WordPress page. Works kind of nice but the need to be logged into Google is not ideal.
In the future, would like to have the up-to-the-minute price of the commodity automagically put into the input column or, in a set of fields outside the spreadsheet. The sheet has more that five rows but there are only five prices that need to occupy the input area.