Welcome to WebmasterWorld Guest from 54.157.239.93

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:10747
votes: 43


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

 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members