THIS IS A PLACE HOLDER FOR A FUTURE CANOE PROJECT
Introduction
==========
I have been using a spreadsheet to design small boats and canoes for a long time.
While fun it is a rather slow process using Excel. In the end it became too tedious for anything other than simple designs.
Process
=======
The basic process is to model (mathematically) the Rabbet, Chine, Sheer and Deck lines, and then to "unfold" the panels into "cutouts".
There are other calculations to estimate the necessary strength (i.e. plywood thickness etc.) of the design.
Example
=======
Canoe2010.xlsm is an example of the my work for a canoe. I also made some balsa models to check the design.
New and Improved
=================
Last year I wanted to rework the process so I could reasonably handle more complex projects.
I still use a spreadsheet to enter the boat offset table but now I export the data to DeltaCad for the unfold process. It now takes hours rather than days to devel
If you are interested in boat building, especially using “stitch and glue” plywood construction, then Carlson Design Hull Designer (http://carlsondesign.com/projects/hull-designer/) may be of interest to you. You will need to run this program in XP compatibility mode otherwise some of the options will not work.
The main objective of these hull design programs is to create a 3D hull and then to “develop” or “unfold” the frames/bulkheads and planks/cut-outs for construction. Below is an example of a “stitch and glue" pontoon for my outrigger canoe.
The 3D design:
The unfolded (cutout) design:
The cutout offset table:
The lofted design:
The cutout panels:
The wired up (stitched) panels:
The glued (epoxy filleted) seams:
Top glued on, ready for sanding and Dynel (rather than fiberglass) tape:
Coated with epoxy and trial fitted to the canoe:
Done, fitted and painted):
How did I do it?
The following describes the process and the two key programs I use.
BoatOffsetTable.xlsm
The Excel file and macro allow you to enter the offset table and then to export the design to a CSV file for DeltaCad. Blow is an example of an offset table for a kayak:
The actual design is too small to be of practical use as a Kayak (refer to Anderson’s webpage).
The above offset table has three additional features over an offset table:
Chines have a colour for easy identification.
Chines can be invisible (and ignored) if the colour is “0”.
Chines can have a “break” or a sharp bend.
Notes:
The design is in millimetres.
The stations are rounded to the nearest millimetre.
Any duplicate stations are deleted.
Stations within 5 mm of each other will have “breaks” automatically added.
Colour 0 is not processed.
If an interpolated value appears wrong or wildly off then you will need to add “breaks” to the chine stations near the problem area.
No curvature checks are made, the design may not be developable (i.e. the plywood may break).
The offset table is exported to DeltaCad as a CSV file. The name of the CSV file is the same as the Excel WorkSheet name. To execute the macro just click the blue “Make CSV” arrow as shown above.
In DeltaCad the macro (“BoatOffsetTable.bas”) is run to import the CSV file and draw the design. For complex designs, the actual process is iterative (i.e. chine by chine). Below is the imported and unfolded “Mini-Kayak” showing the main drawing components.
Note: The unfolded panels are the cut-outs for the design and only one side is shown.
Macro Options
When you run the DeltaCad macro, it first presents a file manager window. It starts in the DeltaCad macro directory. You will need to navigate to your working directory (i.e. where the Excel file is located) and select and okay the CSV file. For the “Mini-Kayak” it is called “Mini-Kayak.CSV”, as shown below.
The macro then presents the “Hull Sections” options box. Set the number of frames to 7 and zero the remaining entries as shown below. This option adds additional frames to the hull model.
You should see the following design.
Other Options
If the “Frames” entry is set to zero then the offset table as entered in Excel will be drawn as below.
The other option entries, create different sections (cross, long and plan) through the model. For example the...
Our strategic focus is on developing Electron Beam (EB) curing adhesives and next-generation semiconductor materials as we continuously improve the use of adhesives and resin materials. https://www.uvadhesiveglue.com/
Our strategic focus is on developing Electron Beam (EB) curing adhesives and next-generation semiconductor materials as we continuously improve the use of adhesives and resin materials. https://www.uvadhesiveglue.com/