Like Tree0Likes

tomcat's power vs. speed calculator - I need some computer programming help

Reply
Old 01-23-2002, 11:02 PM
  #1
Registered
Thread Starter
 
tomcat's Avatar
 
Join Date: Feb 2001
Posts: 1,484
Post tomcat's power vs. speed calculator - I need some computer programming help

I need some computer programming help. I have written a neat program for predicting boat speed and selecting props. The output is a graph that shows the engine horsepower curve plotted on top of the hull horsepower curve. The intersection of these two curves is where top speed, maximum RPM and maximum realized prop HP occur. By entering different hull types, different engine dyno curves and playing with props, you can put bigger power in your own boat, build your dream boat or set the kilo record. More details are posted in the Technical Q&A forum if you're interested.

I would like to put this program on the OSO site for members to use free of charge. The problem is I wrote the program on a Microsoft Excel spreadsheet, and I don't know how to convert that into a user friendly web page. I have been told that displaying the graph is a problem, but I don't want to drop the graph; it's the best part.

Any advice from the computer literate members would be apreciated.

Tom

[ 01-23-2002: Message edited by: tomcat ]
tomcat is offline  
Reply With Quote
Old 01-24-2002, 12:30 AM
  #2
Enjoy the show
VIP Member
 
Ron P's Avatar
 
Join Date: Feb 2001
Location: The Joisey Shore
Posts: 10,353
Post

I'm pretty good with this stuff. Email me the file and let me take a look.
Ron P is offline  
Reply With Quote
Old 01-24-2002, 07:10 AM
  #3
Registered
 
Join Date: Apr 2001
Location: Glens Falls, NY
My Boats: 1999 36' cutdown Skater
Posts: 131
Post

Hi,
To execute on a web page it is going to have to be written in a language that most people support with their browsers. Obviously HTML, but then there is Java, Active X etc. to the more obscure.

There are converters from Excel to Java, search for them you will find them, but these are not trivial to integrate...not hard but you have to launch the applet in say Java and the code has to be right.

Lastly, there is a growing trend to have less dynamic web content, i.e. waving flags, scrolls and all of the complicated Flash stuff. The reason is it gets old fast and slows downloads and grabs memory.

Why don't you have a link that simply downloads a .xls and let people access it that way. Then they can use it when they want.

Ted
Ted Zoli is offline  
Reply With Quote
Old 01-24-2002, 07:19 AM
  #4
Registered
 
Scott B's Avatar
 
Join Date: Dec 2000
Location: Slightly North of Cuba
My Boats: Donzi Criterion SS, X-18 , 16 OB, Z-235, F-14, Magnum Missile
Posts: 2,914
Question

Excel has a fnction when saving to save it as html. Will that work?

That said, either as an xls file, or posted somewhere, I would love to see the project..

Scott b

newbie to these gates products
Scott B is offline  
Reply With Quote
Old 01-24-2002, 08:41 AM
  #5
Registered
 
Join Date: Apr 2001
Location: Glens Falls, NY
My Boats: 1999 36' cutdown Skater
Posts: 131
Post

Scott, that is a good idea...never dawned on me. You must have a web site that is hosted on an ISP that supports Web Folders and MS Front Page server extensions...most do.

I didn't quite understand if tomcat had his own web site or not. If not, it could go on any site as described above. I'm sure there are volunteers here.

Ted
Ted Zoli is offline  
Reply With Quote
Old 01-24-2002, 09:05 AM
  #6
Registered
 
Milord's Avatar
 
Join Date: Jul 2001
Location: Lake St. Clair, Canada
My Boats: 1986 Four Winns Liberator 241
Posts: 1,213
Post

Tomcat and I have spoken at length about this. In the state the spreadsheet is in you really have to know how to use it. It's not user friendly and only he knows how to use it properly. Therefore he want to dummy it down and put it on the web with drop-downs, radio buttons, etc. We talked about making it into a desktop app first. I'm sure I could write it using VB but it has to spit out graphs. Does anyone know of a VB plug-in for graphing x and y co-ordinates?
Milord is offline  
Reply With Quote
Old 01-24-2002, 10:25 AM
  #7
Registered
 
Join Date: Apr 2001
Location: Glens Falls, NY
My Boats: 1999 36' cutdown Skater
Posts: 131
Post

Looks like http://www.codearchive.com/vbasic/
will help a lot.

Question is do you want to "feed" people .vbx's? They are firewalled on a lot of sites along with .exe's etc. It is an issue, how important is anyone's guess.

Ted
Ted Zoli is offline  
Reply With Quote
Old 01-24-2002, 11:27 AM
  #8
Registered
Thread Starter
 
tomcat's Avatar
 
Join Date: Feb 2001
Posts: 1,484
Post

Thanks for the info guys. Since I spoke to Milord I have cleaned up the spreadsheet as much as possible, so all the user has to do is input data into certain cells. These cells are unprotected, so they are the only ones that can be accessed. The rest of the sheet is protected. I also wrote a set of instructions. The most complicated thing the user has to do is click and drag to enter a table of dyno results for three example engines I included. But the user still needs to know a bit about Excel, and has to have Excel on their computer.

If I save the file as html. it can sit on a web page and be opened if the user has Excel? But to run on its own without the user having Excel, I would have to rewrite or convert to another language? Do I have this right?

I sure don't want to rewrite it from scratch in another language if that can be avoided. There's a lot of formulas on that spreadsheet. It took me hours just to clean it up.
tomcat is offline  
Reply With Quote
Old 01-25-2002, 12:59 AM
  #9
speel chekk this fokker!
Charter Member
 
puder's Avatar
 
Join Date: Feb 2001
Location: Locust Valley, New York
My Boats: 27' Scarab
Posts: 5,329
Post

tomcat send the spreadsheet my way. I know of some thigns that could work. If i can check out teh origonal sxcel it woudl give me a good starting point to make a Cold Fusion web application to mkae it run.
__________________
Pardon me, while I whip this out!
puder is offline  
Reply With Quote
Reply

Related Topics
Thread
Thread Starter
Forum
Replies
Last Post
RBeyer
General Q & A
10
09-17-2006 12:14 PM
GLH
General Boating Discussion
11
12-17-2003 08:00 PM
26sonic
General Q & A
2
05-21-2003 11:05 PM
Scooter
General Boating Discussion
13
05-10-2002 09:17 AM
tomcat
General Q & A
26
01-23-2002 11:56 PM



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -5. The time now is 02:21 PM.


Copyright 2011 OffShoreOnly. All rights reserved.