Live Chat & Podcast at 1:00PM Eastern on Sunday!
There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
Search
Web Design & Development
Tag Cloud
access acer asus bios bsod computer crash desktop driver drivers error ethernet excel freeze gaming hard drive hardware hdmi internet laptop malware memory modem monitor motherboard network printer problem ram registry router security slow software sound toshiba trojan ubuntu 11.10 uninstall usb video virus vista wifi windows windows 7 windows 7 32 bit windows 7 64 bit windows xp wireless
Search
Search for:
Tech Support Guy Forums > Internet & Networking > Web Design & Development >
Help Converting Excel Formula To Webpage Form

Reply  
Thread Tools
tumbleweeds321's Avatar
Computer Specs
Junior Member with 22 posts.
 
Join Date: Mar 2007
Experience: Advanced
14-Mar-2010, 02:00 PM #1
Help Converting Excel Formula To Webpage Form
Hello,

I have a spreadsheet that uses formulas (http://fairylandfriends.com/alchemy.xls).

I would like to turn the spreadsheet into a webpage where people can enter the required number (in a field), hit 'submit', and the results will display/post on the webpage.

The problem I'm having is I don't know what I'm doing! I used Dreamweaver to try and convert it, but that didn't work. I don't know .css or javascript so am really up against a wall. The formula isn't complicated, though, and it seems like it would be easy enough to do for someone with even basic knowledge of scripting. Is that a fair assumption?

1. Is what I'm trying to do even possible?
2. What would be the best way to go about it? ie. .php, Javascript?
3. Is there a better program that would help me achieve the desired results? Is there one that would automatically convert it to script or html or whatever it is that would make it work?

Thank you for your help. I've been working on this off and on for a couple of weeks and am just fed up and frustrated with my lack of knowledge, but really, really want to get it working already!

Thanks for your help!
tomdkat's Avatar
Computer Specs
Distinguished Member with 7,127 posts.
 
Join Date: May 2006
Location: S.F. Bay Area, CA
Experience: Intermediate
14-Mar-2010, 04:46 PM #2
Without having thought about this much, I'm thinking you would manually implement the forumlas in the spreadsheet in a script, probably server-side in PHP or something would be best. Then, have that script generate the page with the results.

Peace...
tumbleweeds321's Avatar
Computer Specs
Junior Member with 22 posts.
 
Join Date: Mar 2007
Experience: Advanced
14-Mar-2010, 05:26 PM #3
Thanks Tom! I was hoping you'd spot this, you're so helpful and you're advice is spot on! If that's the case, I'm going to have to have someone else do it.

Since I don't really know what's involved...do you think you could give me a general time estimate on how long it might take someone who knew what they were doing to code this? I could probably figure out at least a ballpark fair price from that. I just don't want to get over-charged for something that just doesn't seem that hard...but I could be wrong on that too, so also want to make sure I pay a fair price to whoever's doing it. Since it's just a little fun site, I also don't want to end paying a ton of money for it, but I do know a lot of people that would love having that formula on a regular webpage instead of .pdf files and spreadsheets!
tomdkat's Avatar
Computer Specs
Distinguished Member with 7,127 posts.
 
Join Date: May 2006
Location: S.F. Bay Area, CA
Experience: Intermediate
14-Mar-2010, 05:46 PM #4
Hmmm, my gut tells me it shouldn't take long (maybe a day or two) to get everything working but that's without seeing the actual spreadsheet formulas or anything.

Maybe someone else here might be willing to help you for free. If you could work up a mock up of how you wanted the page where the enter the data to look and one of how you wanted the data to be displayed, that would help those interested in helping you here.

Peace...
tumbleweeds321's Avatar
Computer Specs
Junior Member with 22 posts.
 
Join Date: Mar 2007
Experience: Advanced
14-Mar-2010, 06:27 PM #5
Thank you! I'll do exactly that and post the links. Do you think I should keep it in this post or start a new one? I'm asking because a lot of people have looked at it and you're the only one that answered. I could also change the title to something like 'help a sista out for free!' :-) But I don't know the etiquette on closing up a topic and starting a new one on the same thing.
tomdkat's Avatar
Computer Specs
Distinguished Member with 7,127 posts.
 
Join Date: May 2006
Location: S.F. Bay Area, CA
Experience: Intermediate
14-Mar-2010, 07:12 PM #6
I would keep the links to the pages in this thread.

Peace...
Eriksrocks's Avatar
Computer Specs
Distinguished Member with 2,198 posts.
 
Join Date: Aug 2005
Location: Minnesota
Experience: Advanced
14-Mar-2010, 07:32 PM #7
I would keep this topic open. Just so you know there are programs out there can can do this automatically:
http://www.google.com/search?hl=en&q...adsheet+to+web

However they are quite expensive. It might be worth trying out the trail versions of a couple of them to see if they can do what you need.
__________________
Erik - erikswan.net - Bluehost Hosting!
tomdkat's Avatar
Computer Specs
Distinguished Member with 7,127 posts.
 
Join Date: May 2006
Location: S.F. Bay Area, CA
Experience: Intermediate
14-Mar-2010, 07:36 PM #8
Good to know!

Peace...
tumbleweeds321's Avatar
Computer Specs
Junior Member with 22 posts.
 
Join Date: Mar 2007
Experience: Advanced
14-Mar-2010, 08:20 PM #9
Thanks Erik! I was using the wrong key words 'cause I was finding nothing. I'm looking at the results now, really appreciate it!
Reply

THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
WELCOME TO TECH SUPPORT GUY! Are you looking for the solution to your computer problem? Join our site today to ask your question -- for free! Our site is run completely by volunteers who want to help you solve your computer problems. See our Welcome Guide to get started.
Thread Tools



Facebook Facebook Twitter Twitter TechGuy.tv TechGuy.tv Mobile TSG Mobile
You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 10:05 PM.
Copyright © 1996 - 2011 TechGuy, Inc. All rights reserved.

Powered by Cermak Technologies, Inc.