The Kayak Forum is Sponsored By
|
|
|
| |
Kayak and Canoe Design Bulletin Board
Re: Computer assisted design
Posted By: Nick Schade In Response To: Computer assisted design (John Fereira)
Date: Thursday, 18 February 1999, at 12:39 p.m.
In the first printing there were a couple typos in the offset table. Go to my book page to see the corrections.
However, these typos are relatively small. The trickiest part of converting the offsets to a set of points you can graph successfully is to get the points in the right order. The tables are organized so they are easy to deal with when you are plotting the points by hand, however this is not optimum for graphing in a spread sheet.
For each form you must create a column containing "heights" like column "A" in fig 4-3. This column contains some numbers from the left most column in figure 4-9, such as cell A2 in fig 4-3 is a "1" which is the "1 in" buttock number from fig 4-9.
cell B2 in figure 4-3 is "8.27" which comes from the "7" column of fig 4-9.
When you get to the waterlines you need to switch this around cell A4 contains "2.07 which is in the 7 column of fig 4-9 where cell B4 contains the "8" which is the waterline number in the leftmost colummn of fig 4-9.
Once you get all the numbers entered, they still will not be in an order that will make good looking graphs. To get the order right, select both column and sort by the height column so the height numbers increase incrementally. When you graph this, the numbers should be in correct order for the graph to look right.
Unfortunately, the proportions may be off in your graph, this is why you may need to move the graph to a program where you can do some scaling.
If this doesn't help, feel free to ask more questions.
Nick
> I haven't seen any threads in this forum yet on computer assisted design
> since, the Design specific BBS was created so I thought I'd start one.> I have been playing around with the form data from Nicks book and can
> enter the X/Y data into an Excel spreadsheet but when I graph it, the
> results just doesn't come out quite right. Does anyone have any detailed
> instructions on how to create graphs using Excel.> I also recently bought a copy of Autodesk's "QuickCAD" product
> and was hoping that I could enter X/Y coordinates in an Excel spreadsheet
> or something and import it so that it could plot a curve. Is anyone else
> using QuickCAD?
| |
Kayak and Canoe Design Bulletin Board is maintained by Nick Schade - Guillemot Kayaks with WebBBS 5.12.
|
Boat Design |
|
|
|
