taff — Sun, 31 Mar 2002 15:18:27 +0000

Well, this was easily doable in Javascript - just not easily doable by me!

Gotta love subcontracting!

taff — Thu, 28 Mar 2002 21:01:16 +0000

ok. This is way too freakin' complicated for my mathematically-challenged, javascript-deficient mind to wrap itself around!

There aren't THAT many input fields (perhaps 10?) but the formulae are complex and conditional. Stuff like:

=IF(D12>MIN(D21,15000),5000,IF(D12<10000,0,MIN(15000,D21)-D12))

eek!

I was expecting things like X=(A+B)/C*D
I would even have a hard time with that!

Detox, you say that this would be doable in PHP? As of now, I have no idea what the client has lined up for hosting but it looks like I need to go back to the well for funding on this one. Luckily, I didn't lock myself in on the price for this one.

taff

'rithmetic never WAS one of my strong R's

detox — Thu, 28 Mar 2002 02:02:55 +0000

Seems to me the data driven / server side way of doing this is better. Are you just wanting to apply calculations toa set of returned form fields?

My solution:
If so then wrap it up in an ASP/VB class and apply the transformation. That would be a lot faster than incorporating excel plus it would decrease server load.......

The majority of Users solution:

PHP PHP PHP PHP PHP PHP PHP PHP PHP PHP PHP PHP PHP PHP!!!!!!!

taff — Wed, 27 Mar 2002 22:49:20 +0000

Yeah, I guess I should elaborate some. There is no data here per se. It is basically a calculation form - plug in a, b, c (and d, e, f, g, h, etc!) to calculate x, y, z.

My original plan was to just create a form and function from scratch but I somewhat underestimated the complexity of the form. Odds are I'll just have to bite the bullet and start from scratch but I would hate to do that and THEN find a shortcut

mairving — Wed, 27 Mar 2002 21:55:20 +0000

I dunno there Taff. I would think that first you would need to get your excel info into a database, then build a form to the data, which you could use js for. Is this a spreadsheet with a lot of formulas?

dk01 — Wed, 27 Mar 2002 21:47:57 +0000

Ok I am new here but the way I see it you have 2 options and both would include using some sort of server side language (ie. ASP, PHP, CGI) if you decide you would like to read directly from the Excel database then you could use ASP's excel data connection at 7host.com:
http://www.7host.com/example_detail.asp?example_id=10
The other option would be to export your database to a text file and then have the server-side language read the text file. (In ASP you can try 4guysfromrolla.com) At any rate I hope you get what your looking for!
-dk