Gene-Hull VE Canoe 2,4

Please find attached a new upgraded/updated version 2,4 of the Gene-Hull VE Canoe spreadsheet application dedicated to the generation of hull for a Canoe project, including in particular :
- a new formulation of the V and E sections, allowing now a tumblehome shape quite common for a Canoe design
- a subroutine to deal with the various loading and the corresponding stability issue,
- a VPP spreadsheet, connected to the output of the Gene-Hull one, and computing a drag estimation and a speed expectation for a given propulsion net power,

You can use this application with either Open office or Libre Office,

A User guide with a lot of illustrations (and in annex the formulations used), and 2 examples of a Tandem Canoe design without and with tumblehome shape, are also here attached. The spreadsheet application is provided with the input data corresponding to the example with tumblehome shape.

By hoping this can be helpful for your projects,

 

Excellent work! By the way, have you considered writing some analytical software, eg Velocity prediction, structural calculations? Or a sail design program?

 

Thanks Andy for your comment. Within this canoe version, the Velocity prediction is already in place ("VPP" sheet in the file), related assumptions and use are given in the User guide.
No structural calculation, it is not my purpose for this application focused on the early stage design. For the loading and stability study, it is just need to input a mass per unit of hull surface which, according to your experience, should reflect a mode of construction and its scantling. In the proposed examples, I took 4,18 kg/m2.
I have in mind to propose soon a Rowing and Sailing version of Gene-Hull, in the following of the Dolfi R&S that I have posted in the Design Forum. It is quite ready, I have just to finish the user interface and to write the User guide.
Dolfi R&S, a rowing/sailing for quiet balads in inland and coastal waters https://www.boatdesign.net/threads/dolfi-r-s-a-rowing-sailing-for-quiet-balads-in-inland-and-coastal-waters.62665/