Parametric planing hull generator for Rhino

[Nojjan]

Hi there, I wrote this worksheet a while back and have been using it for some time, mainly when I need a quick start on a hull (for whatever reason) and I thought I should share it. It is simple but useful. Input in Excel, Copy resulting column, paste in Rhino, and you have a boat (or at least the start of a planing hull...).

Note three different base shapes at bottom tabs:
-Planing hull With chine flat
-Planing hull Without chine flat
-Planing hull With chine flat and Monohedron base

Enjoy! / Nojjan

Ps. only monohulls and it's metric, sorry.

[CWTeebs]

Very cool!

Does the red in the spreadsheet mean user interaction is required?

[Nojjan]

No special input at the red text. I used the red bold text to give myself some visual indication for next object (curve). The red at the bottom of the J-column is to remind myself which commands are used to create the surfaces.
Input is done in B4:B18, unless you want to change the sequence of course. / N

[CWTeebs]

Well, I like it a lot, thank you very much for sharing!

[quequen]

Nice! thanks for sharing, thumbs up!

[rwatson]

I am confused. When you say "paste in Rhino", what does that mean ?

[El_Guero]

I am with RW.

I thought I would put in values and it would tell me if the values would produce a planing hull.

[CWTeebs]

You enter the specified values and the Excel sheet computes the keel and chine curves for the family of planing hulls specified. The sheet then turns these into Rhino commands such that the mathematical curves can be turned into CAD geometry, in this case Rhino can loft the curves via the Sweep1 or Sweep2 commands. You quite literally do as Nojjan said: highlight column "J" of his rather nifty spreadsheet, go to any view in Rhino and paste. You get the result shown in the attached screenshot. You can further automate the geometry process by calling Rhino's kernel via VBA commands from Excel. There's also a very useful Rhino geometry manipulation code called Grasshopper, but I have not used it personally.

[rwatson]

oh, you mean paste it into the command window.
the details make all the difference.

[CWTeebs]

I pasted into the perspective viewport.

[Nojjan]

Hi, to clarify, mark J3:128 in the excel sheet, press ctrl+c, start Rhino and activate any view and then hit ctrl+v, the code is then executed in sequence in Rhino's command run generating your specified geometry / N

[Joe Petrich]

Nice routine. The only minor quibble I have with it is that the hull is oriented with Y up instaead of Z being up, but a simple rotation solves that.