• Access exclusive shipbuilding insights: SSI Blog
  • Find out more: Contact SSI
  • en English
SSI 30th Anniversary
        • Design
        • The most significant opportunities to impact the cost of building and operating a ship are found in the design and engineering phase.

          Initial Design  |  Basic Design  |  Detailed Design

        • Build
        • Even a smaller shipbuilding project is immense in scope and scale. Manage the challenges that are unique to ship construction.

          Prepare  |  Fabricate  |  Assemble

        • Maintain
        • With the majority of a ship’s life taking place after it’s been built, it’s crucial to ensure that the organization has a clear picture of the vessel at all times.

          Assess  |  Manage  |  Repair / Refit

        • Nexus
        • SSI Nexus is the place where users, creators, & implementers of SSI software get together. Here they discuss best practices & industry trends, tackle common challenges, gain access to the latest software, and provide input into the future of the products that bring them together.

        • MyLearning
        • SSI MyLearning is where SSI users can access detailed training exercises, materials, courses, and certifications. The self-directed training curriculum ensures that training happens on your schedule and when you need it most.

        • SSI Blogs
        • The SSI blog is your place to get insights into the intersection of shipbuilding and technology, how our industry is moving forward, and keep up with SSI news. It’s the only place to read the latest from Denis Morais and Darren Larkins, SSI’s co-CEOs.

          Lighthouse Waveform  |  Crow’s Nest

        • Company
        • Learn more about SSI and our leadership.

        • Locations & Contact
        • You need a partner with a global presence.

        • News
        • The latest on SSI and shipbuilding.

        • Events
        • Join us at our next event, conference, or trade show.

        • Partners
        • Learn more about our Platform and Development Partners.

        • Clients
        • See the industry leaders who trust SSI.

        • Careers
        • Help us make the business of shipbuilding possible.

July 5, 2016
Best PracticesPublisherLTShipbuildingTips & Tricks
Tips & Tricks Link a Navisworks 3D Model to Excel

The ability to combine several pieces of data from multiple sources and represent it in a visual fashion can significantly improve how we transform data into actionable information. In today’s environment we use many different systems from 3D CAD models, information systems, legacy in-house applications and even the common denominator every company uses, Excel.

In this blog post I will demonstrate how you can connect and link an intelligent light weight 3D model (Navisworks) with information stored in Excel.

I chose Excel because it is still very common for shipyards to have processes which require information to be stored and maintained in Excel. By linking the information stored in these files with the 3D Model we can allow people to better see trends, issues or just conceptualize information.


How-To Video

If you are not able to view YouTube videos you can view the video on SSI Nexus here.


High Level Overview

There are two requirements to be able to support this workflow. The first is a Navisworks model of your ShipConstructor project. I have several blogs about creating a Navisworks model from ShipConstructor:

  1. Automate Generation of Multiple Navisworks Models
  2. PublisherLT: Create a Clean Navisworks Model
  3. PublisherLT: Create an Associative Navisworks Model

The second requirement will be an Excel file that has the information you want to link and display in Navisworks. This may require some additional setup since to link an Excel file to Navisworks it requires the column headers to be the first row in a worksheet. The easiest way to do this is to create a temporary Excel worksheet (tab) that simply references the information from the source sheet(s). This is demonstrated in the video.


Create a Link to an Excel file

The first step will be to create a link to the Excel file. This is using an OBDC Excel driver that is built in to Navisworks. Do not worry if you do not know what OBDC is. This link just creates a relationship to the Excel file and not a specific sheet (tab) inside the file. This link will remember the path to the Excel file so if the Excel file is updated the new information will automatically display in Navisworks once you restart Navisworks.


Create a Relationship between Navisworks and Excel Sheet

We will use Navisworks DataTools features to display the information in Navisworks. When configuring the DataTools connection you will have to specify the Excel Sheet (tab) which contains the information you want to display as well as build the relationship between the Excel file and the Navisworks model.

Waveform Link To Navisworks

Specify the Properties to Display in Navisworks

You will be able to choose what information is displayed in Navisworks. This is a necessity since most of the Excel files you will reference will have much more information than what you want to display.

Waveform Linked Final

Step By Step Instructions

Datatools

1. Open the Navisworks Model (U02.NWD) attached to post
2. Open DataTools on the Home Tab
3. Click New..
4. Enter the name: Waveform NW Excel

This name will be used for the Navisworks Ribbon name

5. Click Setup..
6. Click Select Workbook..
7. Choose the Excel file (NavisworksLinkedToExcel.xlsx) attached to the post
8. Click OK
9. In SQL String enter the string

Edit Link1

SELECT * from [WaveformNavisworks$] where “Part Name” = %prop(“ShipConstructor”, “Part Name”);

Reference Information:

 

SELECT * from [SHEETNAME$] where “EXCELPROPETY ” = %prop(“ShipConstructor”, “SHIPCONSTRUCTORPROPERTY “);

SHEETNAME – Replace with the name of the Excel Worksheet (Tab) you are going to use

EXCELPROPETY – The name of the Excel column in the worksheet you selected which will be the linking key between your Excel and the ShipConstructor model. Ideally this would be a GUID but can be an item name (part name, weld name, etc.)

SHIPCONSTRUCTORPROPERTY – The name of the ShipConstructor property in Navisworks you are linking to the EXCELPROPERTY.

Waveform Field Name and Display Name

10.Enter the Field names and Display Names we want to display from the Excel sheet.

Reference Information:

 

Field Name – Name of the column in the Excel file

Display Name – Name you want to display in the Navisworks property window.

DataToolsComplete1

11. Click OK
12. Make sure Waveform NW Excel is selected

13. Click OK
14. Click parts in the Navisworks Model and see the properties displayed in the Waveform NW Excel property tab


Attached Files

You can access the files here

Post Comments

  1. EiPM Enginyeria PM says:

    Hi,

    It is not possible to download the sample files.

    Xavi.

    1. Denis Morais says:

      You need a free SSI Nexus account. You can get instant access (~15min) to SSI Nexus after you register here: http://hs.ssi-corporate.com/support/nexus

Leave a Reply

Your email address will not be published. Required fields are marked *

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.