Welcome to WebmasterWorld Guest from 54.161.25.213

Forum Moderators: phranque

Message Too Old, No Replies

Excel Type Calcs on a Web Page

Enter data into a form and perform an excel calc

     
10:50 am on Apr 29, 2008 (gmt 0)

New User

5+ Year Member

joined:Apr 17, 2008
posts: 22
votes: 0


Hi all,

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

7:55 am on Apr 30, 2008 (gmt 0)

Administrator

WebmasterWorld Administrator phranque is a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

joined:Aug 10, 2004
posts:10858
votes: 67


welcome to WebmasterWorld [webmasterworld.com], 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.

11:00 am on Apr 30, 2008 (gmt 0)

New User

5+ Year Member

joined:Apr 17, 2008
posts:22
votes: 0


Hi phranque,

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