I want to make a website that has a form that uses basic excel functions such
as SUM and IF decision variables. More specifically, I want to use check
boxes and I want other values to change based on which check box is clicked
on. Thanks for any help!

SLIPSTREAM wrote:
> I want to make a website that has a form that uses basic excel
> functions such as SUM and IF decision variables. More specifically, I
> want to use check boxes and I want other values to change based on
> which check box is clicked on. Thanks for any help!

You need to write a javascript function.

It has many functions available to help

SUM would be done by looping around elements
An example
var sum= 0 , Lmax = 5
for (var L=1 ; L <= Lmax ; L++)
{sum += document.getElementByID("ident" + L).value }
return sum

IF functions are as simple as
if (var == value)
{ // do something
}

Have a look at http://www.w3schools.com/default.asp or many other sites
(Google for "Javascript")
--
Cheers,
Trevor L.
Website: http://tandcl.homemail.com.au

Hi,

The Excel function are not available in FrontPage or any web design package. To accomplish you'll need to program either the client
side or server side using a programming language.

--
Mike
http://www.websunlimited.com
FrontPage Add-in
MVP FrontPage '97 - '02

"SLIPSTREAM" <(E-Mail Removed)> wrote in message news:49C65729-53D5-4C11-8229-(E-Mail Removed)...
>I want to make a website that has a form that uses basic excel functions such
> as SUM and IF decision variables. More specifically, I want to use check
> boxes and I want other values to change based on which check box is clicked
> on. Thanks for any help!

or- I found a lovely app..
http://www.spreadsheetconverter.com/excel-html-web.htm

Damned if it doesn't do what I wanted.
take a look at
www.ocean7hotel.com/be3.htm

I made a spreadsheet that would compute daily rates.. and this made
(with a little tweaking) html out of it.. it worked very well for me.

largest htm page I have
"MD Websunlimited" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi,
>
> The Excel function are not available in FrontPage or any web design
> package. To accomplish you'll need to program either the client side or
> server side using a programming language.
>
> --
> Mike
> http://www.websunlimited.com
> FrontPage Add-in
> MVP FrontPage '97 - '02
>
> "SLIPSTREAM" <(E-Mail Removed)> wrote in message
> news:49C65729-53D5-4C11-8229-(E-Mail Removed)...
>>I want to make a website that has a form that uses basic excel functions
>>such
>> as SUM and IF decision variables. More specifically, I want to use check
>> boxes and I want other values to change based on which check box is
>> clicked
>> on. Thanks for any help!
>
>

WOW! That's totally what I want my site to do. I'm downloading the program
right now--if this works like I think it will, I will be very indebted to you
(developing this site is supposed to save my company a ton of $$$)

Thanks so much for the tip!!

"MDBJ" wrote:

> or- I found a lovely app..
> http://www.spreadsheetconverter.com/excel-html-web.htm
>
> Damned if it doesn't do what I wanted.
> take a look at
> www.ocean7hotel.com/be3.htm
>
> I made a spreadsheet that would compute daily rates.. and this made
> (with a little tweaking) html out of it.. it worked very well for me.
>
> largest htm page I have
> "MD Websunlimited" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Hi,
> >
> > The Excel function are not available in FrontPage or any web design
> > package. To accomplish you'll need to program either the client side or
> > server side using a programming language.
> >
> > --
> > Mike
> > http://www.websunlimited.com
> > FrontPage Add-in
> > MVP FrontPage '97 - '02
> >
> > "SLIPSTREAM" <(E-Mail Removed)> wrote in message
> > news:49C65729-53D5-4C11-8229-(E-Mail Removed)...
> >>I want to make a website that has a form that uses basic excel functions
> >>such
> >> as SUM and IF decision variables. More specifically, I want to use check
> >> boxes and I want other values to change based on which check box is
> >> clicked
> >> on. Thanks for any help!
> >
> >
>
>
>

happy to help.
you should also know the author is very good about letting you send him a
spreadsheet, and sending back a
version that will work with his converter.

he did this for me, full sheet, once before purchase, once since.. both
times in about a day.

I couldn't use one excel function, he showed me how to do the same thing in
another way
(I had an array-he sent me enough lines to finish the sheet in another
manner- going line by line)
check the list at
http://www.spreadsheetconverter.com/...leview/33/1/1/ for
supported
excel functions..

"SLIPSTREAM" <(E-Mail Removed)> wrote in message
news:41F40789-5CDB-4420-A47F-(E-Mail Removed)...
> WOW! That's totally what I want my site to do. I'm downloading the program
> right now--if this works like I think it will, I will be very indebted to
> you
> (developing this site is supposed to save my company a ton of $$$)
>
> Thanks so much for the tip!!
>
> "MDBJ" wrote:
>
>> or- I found a lovely app..
>> http://www.spreadsheetconverter.com/excel-html-web.htm
>>
>> Damned if it doesn't do what I wanted.
>> take a look at
>> www.ocean7hotel.com/be3.htm
>>
>> I made a spreadsheet that would compute daily rates.. and this made
>> (with a little tweaking) html out of it.. it worked very well for me.
>>
>> largest htm page I have
>> "MD Websunlimited" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>> > Hi,
>> >
>> > The Excel function are not available in FrontPage or any web design
>> > package. To accomplish you'll need to program either the client side or
>> > server side using a programming language.
>> >
>> > --
>> > Mike
>> > http://www.websunlimited.com
>> > FrontPage Add-in
>> > MVP FrontPage '97 - '02
>> >
>> > "SLIPSTREAM" <(E-Mail Removed)> wrote in message
>> > news:49C65729-53D5-4C11-8229-(E-Mail Removed)...
>> >>I want to make a website that has a form that uses basic excel
>> >>functions
>> >>such
>> >> as SUM and IF decision variables. More specifically, I want to use
>> >> check
>> >> boxes and I want other values to change based on which check box is
>> >> clicked
>> >> on. Thanks for any help!
>> >
>> >
>>
>>
>>