Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Br. Columbia, Canada
    Posts
    109
    Thanks
    1
    Thanked 0 Times in 0 Posts

    want to create a calculator

    I have created a calculator in an Excel spread sheet to calculate how many gallons/liters of paint required to paint a room.
    Now what I can't figure out is how to use this spreadsheet on the web with the user only seeing the cells for width/height etc. to get a gallon/liters needed to paint the room. followed the manual and just got the spreadsheet on the web page. Not what I'm looking for. Can I do this with FP2000?

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: want to create a calculator

    In addition to the components that come with FrontPage, which do not enable "live" spreadsheets, there are some "office server extensions" that might do that. I haven't investigated them, and it sounds as though you don't really want the user to go off and edit the spreadsheet.

    To create a calculator in an HTML form, you can choose either: (1) local calculation in the browser (using JavaScript or, if it is IE only, VBScript), or (2) server calculation (using ASP or CGI, etc.).

    I have to believe someone has posted a freely available calculator on the web somewhere. There are a number of JavaScript sites (none come immediately to mind), and a <A target="_blank" HREF=http://www.google.com/search?q=Javascript+calculator>Google search for javascript calculator</A> might be all the leads you need.

  3. #3
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: want to create a calculator

    The has many examples of calculations, including this one <A target="_blank" HREF=http://javascript.internet.com/calculators/5-function.html>here - described as
    "a really simple JavaScript calculator - with just 5 functions! (Add, subtract, multiply, divide, and power) This example can help you see how JavaScript evaluates math functions."

  4. #4
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Br. Columbia, Canada
    Posts
    109
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: want to create a calculator

    Boy this is really the best place for newbies (dummies) like me. Thank you jscher and Leif you have sent me into the twilight zone of a new language "javascript" one I never knew existed! Thank you both. I will travel the learning curve, and just maybe be able to create the calculator I need. Just might take a little while... <img src=/S/bow.gif border=0 width=15 height=15>Thanx again.

  5. #5
    Lounger
    Join Date
    Mar 2001
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: want to create a calculator

    I've done the same type of thing at work also. What I did was to save the spreadsheet as a web page with interactivity (spreadsheet functionality), and just select the cells that you need. I found that I did have to select one row below what I needed to avoid the bottom cell getting cut off. I then used the html file created as a base for the page I needed to create. You will need to open the toolbar for the spreadsheet when you are editing the page to remove the row and column labels, menus, etc, so that all the end user sees is the cells that you want. I also protected the cells that contain the labels, so the user can only type into the cells that they need to.
    Forgive me if this sounds a little vague, but it's been about a year and a half since I did this. Let me know if you'd like me to e-mail you the page I created so you can see if it's what you're looking to do.
    Let me know if you have any other questions about this.

    Gary

  6. #6
    2 Star Lounger
    Join Date
    Mar 2001
    Location
    Br. Columbia, Canada
    Posts
    109
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: want to create a calculator

    Thanx Gary, I'll try your way too. May be easier than learning a new and foriegn language. Appreciate your input and your offer.
    Joan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •