Excel Create

<< Click to Display Table of Contents >>

Navigation:  Features and Operations > Data and Information >

Excel Create

Excel Create is a licensed add-on that allows users to create features for a 3DCS model, such as Points, Moves, Tolerances and Measures, all within Excel. This function can allow users to test multiple build scenarios quickly, just by creating different versions of their 3DCS model and saving the different scenarios within Excel.

 

Users can export an Microsoft Excel or Google Spreadsheet filled with 3DCS information. The Excel file can serve as backup to a 3DCS model, as well as showing Points, Moves, Tolerances and Measures information; vector information; circles and distributions.

 

Users who would like to update or change a 3DCS model through Excel will require a license, otherwise all users will only be able to view the 3DCS information. Please contact your sales representative for more information.

 

Excel export/import can be done in either Google Sheets or with Microsoft Excel.

 

In this section:

Procedure

Changing Names

Different Excel Tabs

Creating New Features

Conditional Logic information

Mechanical Information

User DLL Information

See also...

Preferences - Excel Tab

Search topics for Excel Create in the Community

 

 

Procedure:

1.From 3DCS Tools toolbar, select DVTI_dcsXLW Write to Spreadsheet,

2.Excel will open to the Points tab,

3.Check each tab in excel and make any modifications,

4.The user can then either DVTI_dcsXLR Read from Spreadsheet,

5.Or save the excel file in the same folder as the model and upload later, or to keep as a backup,

6.If importing later, save and then close Excel. In 3DCS, select DVTI_dcsXLR to load a browser dialog and load the latest Excel file with the recent changes.


Creating Points

1.Export a new Spreadsheet from 3DCS.

2.Open to the Points tab.

3.In the row, follow the examples to create a Coordinate Point, with or without a Diameter.

oAdding information up to the Description column will create a Coordinate Point.

oAdding information up to the Diameter column will create a Coordinate Point with a Diameter.

Part

Pts#

Index

Point (Name)

X

Y

Z

i

j

k

Description

FOS

Diameter

#Dir

Type

i

j

k

Root

1

1

'Point1_CoordinateExample

0.00

0.00

0.00

0

0

1


N/A

N/A

N/A

N/A

0

0

1

Root

2

2

'Point2_DiameterExample

0.00

0.00

0.00

0

0

1


Circle

10mm

1

AssocDir

0

0

1

 

Direction Type examples (Only used for the Circle Size tolerance):

Associative Direction (AssocDir)

Type-In (Type-In)

Two Point (Two Pt)

.

 

How to change MTM, Points, GD&T and Spec Study names. Changing Names

 

hmtoggle_arrow1 Excel Tabs for 3DCS

 

hmtoggle_arrow1 Creating New Features

 

hmtoggle_arrow1 Conditional Logic information

 

hmtoggle_arrow1 Mechanical Information

 

hmtoggle_arrow1 User-DLL Information

 

Notes:

Later versions of the 3DCS Excel Create may not be used for earlier versions of 3DCS, or in other words "is not downwards compatible".

It is recommended that the model is saved prior to using Read from Excel function.  Additionally, the model should be fully verified after Read from Excel is executed.

All tabs (Points, Feature Creations, Unit, Feature Examples, Tolerances, Moves, Measurements and GD&T) of the Excel workbook must be present and populated with the current data corresponding to the model.

GD&T cannot be created or deleted through Excel Import. The user can update values, Datum features, material modifier, etc., in Excel.

All the objects that belong to one part must be listed in consecutive rows of Excel without any blank rows in between. For example, if Part1 has 20 points, all the points must be listed in consecutive rows of Excel.

Due to rounding off, numeric values may have a small precision error upon execution of the Read from Excel function.

The Excel Linking Matrix units will be the same as the model units.