Boat Design Forums  |  Boat Design Directory  |  Boat Design Gallery  |  Boat Design Book Store  |  Thanks to Our Site Sponsors

Go Back   Boat Design Forums > Design > Software
Register FAQ Members List Calendar Search Today's Posts Mark Forums Read Most Recent Posts Gallery Images Search

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 08-26-2012, 10:30 PM
ancient kayaker ancient kayaker is offline
aka Terry Haines
 
Join Date: Aug 2006
Rep: 2277 Posts: 3,493
Location: Alliston, Ontario, Canada
SS & SW Questions

A few questions:

I was looking at the spreadsheet library for something to aid hull design which ideally would create a file that could be imported into FreeSheet to access the hydrostatic utilities and other analysis. If a hull design must be accurate FreeShip's basic method produces only an approximation.

Not only was I unable to find such an aid, there is not even a category for hull design. This I found surprising. Can new categories be added?

Most if not all of the spreadsheets I did find are Excel. I use Quattro which is a linear descendant of Lotus, the spreadsheet program I first learned to use. Obviously there are more Excel users. Does anyone know if Quattro files load properly into Excel? No point in my uploading any of mine if they won't be of use to anyone.

As well as spreadsheets, is anyone creating compiled applications and if so do they have a category?
__________________
"Boats are like rabbits; you can have one boat or many, but you can't stop at two" - A. Onassis
Boat designs: "a convoluted collection of discontinuous compromise" - Par
". . . ere the end, some work of noble note, may yet be done . . ." -Tennyson
Dances with Turkeys
Reply With Quote


  #2  
Old 08-27-2012, 05:35 PM
Boat Design Net Moderator Boat Design Net Moderator is offline
Moderator
 
Join Date: Feb 2010
Rep: 922 Posts: 328
Location: www.boatdesign.net
I honestly don't know what compatibility issues might exist between Quattro and Excel functions or what is involved in transferring any macros from Quattro Pro to Excel. I hope someone else reading this can share their experience with this.

I've created a 'hull design spreadsheets' category now that you can select when you 'Add' a file to the spreadsheets library if you would be so generous in sharing some of yours. Is the file extension .qpw?

If there is a handful of spreadsheets that would be best grouped in a more specific category, please PM me or post a category suggestion here and I will create new more specific categories as requested. Thanks very much.
__________________
Please be polite to all other members. Please respect those who take their time to give advice freely. And please keep threads on topic. Forum Rules
Reply With Quote
  #3  
Old 08-27-2012, 06:33 PM
Ad Hoc Ad Hoc is offline
Naval Architect
 
Join Date: Oct 2008
Rep: 2285 Posts: 4,214
Location: Japan
Quote:
Originally Posted by ancient kayaker View Post
I was looking at the spreadsheet library for something to aid hull design which ideally would create a file that could be imported into FreeSheet to access the hydrostatic utilities and other analysis.
AK

Unless you're willing to spend telephone numbers on software like this:
http://www.3ds.com/products/catia/mi...acht/overview/

You'll have to do 'it' the same way we all do...carefully and hand-draulically and build up your own library as such!
Reply With Quote
  #4  
Old 08-27-2012, 07:13 PM
ancient kayaker ancient kayaker is offline
aka Terry Haines
 
Join Date: Aug 2006
Rep: 2277 Posts: 3,493
Location: Alliston, Ontario, Canada
Quote:
Originally Posted by Boat Design Net Moderator View Post
I honestly don't know what compatibility issues might exist between Quattro and Excel functions or what is involved in transferring any macros from Quattro Pro to Excel. I hope someone else reading this can share their experience with this . . .
Thanks for the fast reply. There are some issues, apparently. I tried downloading several of the .XLS files, most load OK but a few cause errors of some kind. Perhaps it will work from .QPW to .XLS . . .


Quote:
Originally Posted by Boat Design Net Moderator View Post
. . . I've created a 'hull design spreadsheets' category now that you can select when you 'Add' a file to the spreadsheets library if you would be so generous in sharing some of yours. Is the file extension .qpw? . . .

If there is a handful of spreadsheets that would be best grouped in a more specific category, please PM me or post a category suggestion here and I will create new more specific categories as requested. Thanks very much.
- thank you! Yes it's a .QPW file but on investigation I find that Quattro can create a .XLS file - or so it claims. I am in the early stages of the hull design SS so it will be a while but as soon as I have something useful I will post it in both flavors, in the hope that at least one will work. Perhaps someone can download it and advise if it's OK.

The "Hull design" category describes very well what I am trying to develop. The first version is aimed at generating radius chine designs with somewhat limited hull shape options.


Ad Hoc: I know what you mean about SW costs! Even before I retired from engineering my employer -who had a great deal more money than I have ever had - was too cheap to buy me a licence to for ACAD. My biggest problem now is organizing the dozens of little utilities I have developed across the years . . .
__________________
"Boats are like rabbits; you can have one boat or many, but you can't stop at two" - A. Onassis
Boat designs: "a convoluted collection of discontinuous compromise" - Par
". . . ere the end, some work of noble note, may yet be done . . ." -Tennyson
Dances with Turkeys
Reply With Quote
  #5  
Old 08-27-2012, 08:28 PM
DCockey DCockey is offline
Senior Member
 
Join Date: Oct 2009
Rep: 1399 Posts: 2,965
Location: SE Michigan
Quote:
Originally Posted by ancient kayaker View Post
A few questions:

I was looking at the spreadsheet library for something to aid hull design which ideally would create a file that could be imported into FreeSheet to access the hydrostatic utilities and other analysis. If a hull design must be accurate FreeShip's basic method produces only an approximation.

......
I'm curious about how large the errors are in FreeShip's calculations. Have you tried any test cases for which you know the exact answer?
__________________
David Cockey
Reply With Quote
  #6  
Old 08-27-2012, 08:43 PM
DCockey DCockey is offline
Senior Member
 
Join Date: Oct 2009
Rep: 1399 Posts: 2,965
Location: SE Michigan
Rhino does the basic volume, centroid, etc calculations for hydrostatics with the Hydrostatics and other analysis commands. My experience is the accuracy of the results is as good as or better than the relative accuracy specified for the project. The results can be copied and pasted into a simple Excel spreadsheet to calculate the quantaties of interest. Some interation is needed to maintain displacement when heeling. Rhino falls in between free and telephone number costs at around $1000 in the US. Whether that is low cost depends on the individual or organization.

Example results:

Hydrostatics
Volume Displacement = 1632.57
Center of Buoyancy = 1.465, 0, -1.22094
Wetted Surface Area = 2394.63
Waterline Length = 62.6877
Maximum Waterline Beam = 18.6171
Water Plane Area = 853.411
Center of Floatation = 1.71573, 0,0

VolumeMoments
Volume = 1632.54 (+/- 0.00036) cubic inches
Volume Centroid = 1.464683,-4.67967431e-14,-1.22097326 (+/- 4.1e-06,1.8e-06,2.1e-06)
Volume Moments:
First Moments
x: 2391.154 (+/- 0.0061)
y: -7.63975549e-11 (+/- 0.0029)
z: -1993.28769 (+/- 0.003)
Second Moments
xx: 266556.81 (+/- 0.047)
yy: 22889.267 (+/- 0.0067)
zz: 3606.767 (+/- 0.0092)
Product Moments
xy: 8e-10 (+/- 0.0098)
yz: 1e-10 (+/- 0.0047)
zx: -2623.91237 (+/- 0.016)
Volume Moments of Inertia about World Coordinate Axes
Ix: 26496.033 (+/- 0.016)
Iy: 270163.57 (+/- 0.056)
Iz: 289446.07 (+/- 0.054)

AreaMoments
Area = 853.491788 (+/- 1e-07) square inches
Area Centroid = 1.713976,9e-14,0 (+/- 1.7e-06,1.2e-06,0)
Area Moments:
First Moments
x: 1462.864 (+/- 0.0015)
y: 8e-11 (+/- 0.001)
z: 0 (+/- 0)
Second Moments
xx: 191589.469 (+/- 0.0076)
yy: 17869.9364 (+/- 0.00048)
zz: 0 (+/- 0)
Product Moments
xy: 2e-09 (+/- 0.012)
yz: 0 (+/- 0)
zx: 0 (+/- 0)
Area Moments of Inertia about World Coordinate Axes
Ix: 17869.9364 (+/- 0.00048)
Iy: 191589.469 (+/- 0.0076)
Iz: 209459.405 (+/- 0.0081)
Area Radii of Gyration about World Coordinate Axes
Rx: 4.57574517 (+/- 6.1e-08)
Ry: 14.9825641 (+/- 3e-07)
Rz: 15.6657164 (+/- 3e-07)
Area Moments of Inertia about Centroid Coordinate Axes
Ix: 17869.9364 (+/- 0.00048)
Iy: 189082.155 (+/- 0.0026)
Iz: 206952.092 (+/- 0.0031)
Area Principal Moments of Inertia about Centroid and Principal Axes
I1: 189082.155 , Direction ( -1, -1.34820842e-14 ,-0)
I2: 17869.9364 , Direction ( 1.34820842e-14, -1 ,0)
I3: 0 , Direction ( 0, 0 ,1)
Area Radii of Gyration about Centroid Coordinate Axes
Rx: 4.57574517 (+/- 6.1e-08)
Ry: 14.8842035 (+/- 1e-07)
Rz: 15.5716716 (+/- 1.2e-07)
__________________
David Cockey
Reply With Quote
  #7  
Old 08-28-2012, 12:17 AM
ancient kayaker ancient kayaker is offline
aka Terry Haines
 
Join Date: Aug 2006
Rep: 2277 Posts: 3,493
Location: Alliston, Ontario, Canada
Sorry David, I guess I wasn't being clear, but it's not the accuracy of FreeShip's calculations that I am questioning. Sometimes I want to create a precise shape of hull; that can only be done with certain simple hard-chine hull shapes in FreeShip. It isn't practical to get a precise shape in a reasonable time by moving the control points, and for a rounded hull more points are needed and the time seems to increase as a factorial of the points count.
__________________
"Boats are like rabbits; you can have one boat or many, but you can't stop at two" - A. Onassis
Boat designs: "a convoluted collection of discontinuous compromise" - Par
". . . ere the end, some work of noble note, may yet be done . . ." -Tennyson
Dances with Turkeys
Reply With Quote
  #8  
Old 02-11-2013, 11:05 AM
ancient kayaker ancient kayaker is offline
aka Terry Haines
 
Join Date: Aug 2006
Rep: 2277 Posts: 3,493
Location: Alliston, Ontario, Canada
Protoype Hull Design Spreadsheet Results

I've been working on a hull design spreadsheet. I gave up on the first attempt, way too complex. Also I had to learn about FreeShip's import file formats and experiment to establish their capabilities and limitations. Sorry it's taking so long! Finally I went back to an old spreadsheet I have used for years to predict wood bending patterns. I decided not to bother with the stuff that FreeShip handles quickly and easily. This one looks promising.

The stems generated by this spreadsheet are plumb and vertical but can be changed in a minute using FreeShip. I restricted hull shapes to constant bilge radius with a flat-bottom. Again, these limits are easy to change in FreeShip to provide elliptical bilges and vee bottom if preferred, and either hard chine or rounded bilge can be had in FreeShip.

The result of the first test is shown. Itís not ready to publish yet, as it doesnít handle transoms and I want to add a bit more flexibility, also make it easier to use. It took about 10 minutes to do this canoe design including reshaping the stems. Also I want to experiment with the spreadsheet to see how to get the best out of it, maybe write a tutorial.

Changes to image Feb 12/13: added recurved stems and decks to simulate appearance of Walter dean's Sunnyside Cruiser canoe and firmed bilges to increase stability to allow higher seat position.
Attached Thumbnails
SS & SW Questions-sunnysidefromquattrovn3.jpg  
__________________
"Boats are like rabbits; you can have one boat or many, but you can't stop at two" - A. Onassis
Boat designs: "a convoluted collection of discontinuous compromise" - Par
". . . ere the end, some work of noble note, may yet be done . . ." -Tennyson
Dances with Turkeys

Last edited by ancient kayaker : 02-12-2013 at 07:15 PM.
Reply With Quote
  #9  
Old 02-11-2013, 11:57 AM
rxcomposite's Avatar
rxcomposite rxcomposite is online now
Senior Member
 
Join Date: Jan 2005
Rep: 1035 Posts: 1,255
Location: Philippines
AK
I started with Lotus until upgrades are no longer available and hard to come by. I started using Excel and find it easy to use sans the bells and whistles of Lotus. But excel has Visual Basic programming which is great.

I am building up my Excel files on boat design but it seems there are too many categories that I have not found the time to piece everything together or possibly link it together. So far I have monohull, catamaran, at least nine different groups of displacement ships, then I have to fit in the materials in steel, aluminum, and composite.

I am following the path of design spiral and now into weight estimation WBS system. What is your goal?

Last edited by rxcomposite : 02-11-2013 at 11:59 AM. Reason: typo
Reply With Quote
  #10  
Old 02-11-2013, 12:05 PM
Remmlinger Remmlinger is offline
engineer
 
Join Date: Jan 2011
Rep: 148 Posts: 121
Location: Germany
Quote:
Originally Posted by ancient kayaker View Post
I've been working on a hull design spreadsheet. I gave up on the first attempt, way too complex. Also I had to learn about FreeShip's import file formats and experiment to establish their capabilities and limitations.
Did you have a look at the thread New Lines Prediction Program ?
UliLines creates an input file for Delftship and FreeShip
Uli
Reply With Quote
  #11  
Old 02-11-2013, 02:42 PM
ancient kayaker ancient kayaker is offline
aka Terry Haines
 
Join Date: Aug 2006
Rep: 2277 Posts: 3,493
Location: Alliston, Ontario, Canada
Quote:
Originally Posted by rxcomposite View Post
AK
I started with Lotus until upgrades are no longer available and hard to come by. I started using Excel and find it easy to use sans the bells and whistles of Lotus. But excel has Visual Basic programming which is great.

I am building up my Excel files on boat design but it seems there are too many categories that I have not found the time to piece everything together or possibly link it together. So far I have monohull, catamaran, at least nine different groups of displacement ships, then I have to fit in the materials in steel, aluminum, and composite.

I am following the path of design spiral and now into weight estimation WBS system. What is your goal?
- I too started with Lotus; I now use Corel’s Quattro which is it’s linear descendant. I also have an old Visual Basic set but haven’t used it since I retired. Maybe I should get Excel too: I used to use it at work.

I didn’t know Excel would do VB; does it generate a compiled program for distribution or just run it as an interpreter?

My goal with the current effort is to generate a predecessor program for FreeShip (PreShip?) to simplify creating a design and still allow access to the tools in FreeShip. I have also used Carene2008 which creates a design in a more "linear" way than FreeShip but lacks it's flexibility and analytical tools. Basically I just want to have the best of both worlds . . .


Quote:
Originally Posted by Remmlinger View Post
Did you have a look at the thread New Lines Prediction Program ?
UliLines creates an input file for Delftship and FreeShip
Uli
- I reviewed the manual briefly. It seems to be aimed at a professional audience with more training than I have in ship design. Many of the professional designers here would find it of interest. My own endevour starts at a much lower level which might appeal to some who wish to try their hand at hull design, or perhaps - as I do - wish to recreate several classic hulls in FreeShip for analysis using FreeShip's tools. Thank you for your interest.
__________________
"Boats are like rabbits; you can have one boat or many, but you can't stop at two" - A. Onassis
Boat designs: "a convoluted collection of discontinuous compromise" - Par
". . . ere the end, some work of noble note, may yet be done . . ." -Tennyson
Dances with Turkeys
Reply With Quote
  #12  
Old 02-11-2013, 03:45 PM
rxcomposite's Avatar
rxcomposite rxcomposite is online now
Senior Member
 
Join Date: Jan 2005
Rep: 1035 Posts: 1,255
Location: Philippines
My latest version of Excel has an add on which is activated using a procedure. I will post it. The add on contains the VB, and the usual macro and active X controls.

I look at your post again and I think you are only interested in hull design. It can be expanded to to hull optimization. My nephew wrote the VB for me in a few hours. One sheet is used as a output/scratchpad that I can save or erase if I dont like the result.

In the early days, I create waterline graphs and sectional graphs from the table of offsets in Excel. From the table of offsets, another sheet calculates the displacement using simpsons or trapezoidal rule. It calculates also the LCG. The old excel allows me to pick a point in the graph, move it using the cursor and the corresponding cell recalculate. It also has the smoothing function. I can;t use that anymore with the new version.

Another method to plot a line in Excel is to use and algebraic expresion to generate a set of points for a parabolic or polynomial curve. Or you can input manually the coordinates in the cell, create a graph, then use the trendline function of the SS to know the equation. The trendline has a polynomial function up to the 6th order. With the equation known, you can create another graph set and vary the shape by varying the inputs in the P function.

Or you can create the function using Taylor's mathematecal method. It uses a sixth order polynomial function. Each set correspond to a parameter like length, breadth, Cp, LCB,.......ect. so by varying the input parameter, the graph changes. You can create sectional area curve, waterline, sections and even profiles. The link was posted here sometime ago about "Design of Naval Ships". If you can't find it, I will fwd the link. I have saved it.

P.S.
I use to make Lotus play a tune whenever I strike an invalid key. It has a set of tone functions. Nice to remember my programming days.

Last edited by rxcomposite : 02-11-2013 at 03:54 PM. Reason: Added PS
Reply With Quote
  #13  
Old 02-12-2013, 11:36 AM
rxcomposite's Avatar
rxcomposite rxcomposite is online now
Senior Member
 
Join Date: Jan 2005
Rep: 1035 Posts: 1,255
Location: Philippines
Attached instructions for the activating VB.

Here is the link for Modern Naval Design tool. http://mnvdet.com/MNVDET.shtml
Attached Files
File Type: doc Open_Excel_Macro[1].doc (179.5 KB, 92 views)
Reply With Quote
  #14  
Old 02-13-2013, 12:19 AM
ancient kayaker ancient kayaker is offline
aka Terry Haines
 
Join Date: Aug 2006
Rep: 2277 Posts: 3,493
Location: Alliston, Ontario, Canada
If I have to I will get Excel but Quattro can export ,XLS files so hopefully I will be able to put this spreadsheet into the library once completed. I have been testing the Alpha version extensively yesterday and today and the basic math is solid, so I will work on completing and civilizing it into a Beta version. It needs transoms, more control over sheers, and hopefully to eliminate a repeated calculation that is currently needed to prevent circular calculation errors, and a better user interface with graphics. I'll need to add some kind of instructions too.
__________________
"Boats are like rabbits; you can have one boat or many, but you can't stop at two" - A. Onassis
Boat designs: "a convoluted collection of discontinuous compromise" - Par
". . . ere the end, some work of noble note, may yet be done . . ." -Tennyson
Dances with Turkeys
Reply With Quote


  #15  
Old 02-13-2013, 01:05 AM
rxcomposite's Avatar
rxcomposite rxcomposite is online now
Senior Member
 
Join Date: Jan 2005
Rep: 1035 Posts: 1,255
Location: Philippines
Better stick with Quattro then. Excel is good but lacks flexibility as it works wit a set of programmed commands. They touted it as the 3G (third generation) way of computing. The old Excel is in binary format. The new one isn't. I programmed the Lotto 6/49 combinations in the .xlsx version but it won't fit so I saved it in the old version. For purely number crunching, the old system is the best.

I don't think it is the accuracy. It is the way it is used. The only inaccuracy that is in the Excel is the way it handles statistic. You can search the net for Excel's accuracy before you think of switching.

Excel is is getting sophisticated though and I have not explored other possibilities.

I started with Framework by Ashton Tate, then Lotus. I consider both a programming tool because you create.
Reply With Quote
Reply



Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Forward Keel Location & Angle Questions viking north Boat Design 14 04-10-2011 09:59 AM
Two questions: polyester + polyurethane foam & any underwater use contact adhesives? Mr Efficiency Materials 2 01-31-2011 07:49 PM
1959 Penn Yan Magellan Restoration Status & Questions gillam77 Wooden Boat Building and Restoration 3 09-23-2010 12:29 PM
Alodyne & blisters; Questions on Re-painting an older mast. RyanN Metal Boat Building 1 11-04-2008 08:04 AM
Mast & Rig Design questions ege Sailboats 10 04-10-2008 04:19 PM


All times are GMT -4. The time now is 09:02 AM.


Powered by: vBulletin Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
Web Site Design and Content Copyright ©1999 - 2014 Boat Design Net