Importing x,y,z from excel

Discussion in 'Software' started by member 65051, Aug 3, 2018.

  1. member 65051
    Joined: Aug 2018
    Posts: 4
    Likes: 0, Points: 1
    Location: Australia

    member 65051 New Member

    Hi guys n gals, I’m currently in the process of reverse engineering my 47ft alloy hard chine sailing ketch. I've tediously measured almost every square inch of the vessel and compiled a series of measurements in excel. I have around 600 x,y,z points that I would very much like to avoid typing again. Perhaps a wise mind around these parts might suggest a good software to import these numbers into from which I can connect the dots and ultimately create my model. Cheers
     
  2. Mr Efficiency
    Joined: Oct 2010
    Posts: 6,613
    Likes: 162, Points: 63, Legacy Rep: 702
    Location: Australia

    Mr Efficiency Senior Member

    600 sounds like a lot of points to define the shape of a hard chine boat, what is the purpose of the exercise ?
     
  3. member 65051
    Joined: Aug 2018
    Posts: 4
    Likes: 0, Points: 1
    Location: Australia

    member 65051 New Member

    There’s points measured every 300mm fore/ aft at significant edges, eg. chines, Center Line, gunnel etc. Also points for every stay, Stauntion, hatch, winch, water inlet, fuel, and so on. I have some OCD, and plenty of time. Ive found quite a few discrepancies in the build. The purpose of the excercise is primarily to do the foot work for the architect as the budget is not excessive. I could buy the original plans but I’d rather not spend $6000 there. I’ll be making some changes to the design once a few discussions have been had with the architect.There’s a business model behind all this but that’s not something for this forum.
     
  4. TANSL
    Joined: Sep 2011
    Posts: 5,220
    Likes: 125, Points: 73, Legacy Rep: 300
    Location: Spain

    TANSL Senior Member

    I have the software that allows you to read Excel data and draw the curves, using splines or polylines in AutoCAD. But I should see what format you have given your data to give a more concrete answer. Reverse engineering is one of the challenges I intend to overcome
     
  5. DCockey
    Joined: Oct 2009
    Posts: 3,984
    Likes: 150, Points: 63, Legacy Rep: 1485
    Location: Midcoast Maine

    DCockey Senior Member

    Do you currently use any CAD or 3D design software?
     
  6. TANSL
    Joined: Sep 2011
    Posts: 5,220
    Likes: 125, Points: 73, Legacy Rep: 300
    Location: Spain

    TANSL Senior Member

  7. DCockey
    Joined: Oct 2009
    Posts: 3,984
    Likes: 150, Points: 63, Legacy Rep: 1485
    Location: Midcoast Maine

    DCockey Senior Member

    Question was intended for the original poster. My apologies for not being clear.
     
  8. TANSL
    Joined: Sep 2011
    Posts: 5,220
    Likes: 125, Points: 73, Legacy Rep: 300
    Location: Spain

    TANSL Senior Member

    No, on the contrary, my apologies for getting into a private conversation. Cheers.
     
  9. member 65051
    Joined: Aug 2018
    Posts: 4
    Likes: 0, Points: 1
    Location: Australia

    member 65051 New Member

    upload_2018-8-6_17-14-22.png
    Left hand column is fore aft measurement, center column is vertical axis, right hand column is offset from Center Line (all to port in this case). All measurements relate back to a single datum point as the bow.
     
  10. ludesign
    Joined: Aug 2003
    Posts: 211
    Likes: 5, Points: 18, Legacy Rep: 60
    Location: Sweden

    ludesign Senior Member

    TouchCAD can import tab based points exports from Excel and convert it into both curves and surfaces.
     
  11. TANSL
    Joined: Sep 2011
    Posts: 5,220
    Likes: 125, Points: 73, Legacy Rep: 300
    Location: Spain

    TANSL Senior Member

    @member 65051, if you decide not to use TouchCAD, send mi your Excel file. I can return the points drawn in the space, and the corresponding curve, in one of these formats, dwg, dxf, igs .... or what format do you prefer?
     

  12. member 65051
    Joined: Aug 2018
    Posts: 4
    Likes: 0, Points: 1
    Location: Australia

    member 65051 New Member

    I think Ill give Touch CAD a go for now, it looks as though it will do everything I need, thanks for suggestion
     
Loading...
Forum posts represent the experience, opinion, and view of individual users. Boat Design Net does not necessarily endorse nor share the view of each individual post.
When making potentially dangerous or financial decisions, always employ and consult appropriate professionals. Your circumstances or experience may be different.