Forum Moderators: phranque
Sorry if this is in the wrong forum, but not sure where it should go.
I am wondering if it is possible to achieve something on a webpage where there is a simple form, with a handful of input boxes where the user inputs data (numerical probably) and then when submitted, these inputs are fed into a spreadsheet that has been set up to perform a calculation on these inputs and then display a second web page that is basically the output cell from the spreadsheet with the result?
I think like this as I know how to do excel and to feed data into that when it has already been set up to perform certain calcs is easy.
I am sure there is probably a different way of doing this, perhaps by representing all the calcs in a code of some sort (java? php?) but I am quite new to all that so wouldn't know where to start.
Any ideas?
Cheers everyone.
Jon
i'm sure this could be done in the browser using javascript.
look in the usual places for an open source javascript spreadsheet solution and go from there.
Thanks for that...having a quick look around I see you can get javascript spreadsheets which you can have on a web page and edit directly.
But what I am more after is just the ability to perform pre-determined calculations, where the user just fills in some input boxes and presses submit to perform the calc.
My reference to excel and spreadsheets is purely because, I know I can set up all the calcs I need as equations in excel where certain cells are inputs for the calc, so its just my current way of thinking to how I could solve equations. I would want the calcs and spreadsheet hidden from view... so all the user does is fill in boxes X, Y and Z and hits submit and then the answer is displayed.
Its the taking those input value and running them through calcualtions I am not sure how to achieve.
For (a very simpe) example:
User enters 3 values into boxes X, Y and Z, hits the submit button, then somewhere behind the scenes a calc performs say [X^2/Y]*[Z*0.85]. The answer to this is then just simply displayed on a html page or rather just below the submit button, so the user could fiddle with the inputs.
Many thanks indeed!
Jon
