Welcome to WebmasterWorld Guest from 220.127.116.11
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.
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!