S4-1 PAT328, Section 4, September 2004 Copyright 2004 MSC.Software Corporation SECTION 4 FIELD IMPORT AND EXPORT

S4-2 PAT328, Section 4, September 2004 Copyright 2004 MSC.Software Corporation

S4-3 PAT328, Section 4, September 2004 Copyright 2004 MSC.Software Corporation FIELD ENHANCEMENT n Patran will import an externally defined excel spreadsheet (in CSV format) into a Patran Field spreadsheet. u Accessible from Input Data form in Create Field form u Data may be separated by commas, semi-colons, tabs or spaces u Data must be arranged in columns, with one column for each independent variable and one column for the dependent variable. n Patran will also export the field spreadsheet out to an external excel spreadsheet. u Accessible from Input Data form by selecting CSV Export option.

S4-4 PAT328, Section 4, September 2004 Copyright 2004 MSC.Software Corporation n An options menu allows you to set the separator and whether to read the first line or write column headings n Import completely replaces what is in the current spreadsheet n Export writes everything in the current spreadsheet n CSV files written on Windows are incompatible with UNIX unless the ctrl M's are removed from each line. IMPORT / EXPORT

S4-5 PAT328, Section 4, September 2004 Copyright 2004 MSC.Software Corporation IMPORT / EXPORT FORMS n All Fields spreadsheet input forms now have a new "Import/Export..." button in the upper right u with the exception of complex data tables

S4-6 PAT328, Section 4, September 2004 Copyright 2004 MSC.Software Corporation IMPORT / EXPORT FORMS n Both Import and Export options allow for various types of delimiters.

S4-7 PAT328, Section 4, September 2004 Copyright 2004 MSC.Software Corporation IMPORT / EXPORT FORMS n The first line of a file may be ignored by selecting the check box on the Import Options form. u Useful for files which have titles listed as the first entry of each column.

S4-8 PAT328, Section 4, September 2004 Copyright 2004 MSC.Software Corporation INCOMPLETE DATA n Data must be entered completely u If data is entered for a Y value at one X value, then data must be entered at that Y value for every X value. u This extends to three dimensions. Data must be entered for every value if entered for a single value. u In the example below, the data is incomplete since there is no information at x=1 or x=2 for Y=40. X,Y,Value E+000, E+001, E E+000, E+001, E E+000, E+001, E E+000, E+001, E E+000, E+001, E E+000, E+001, E E+000, E+001, E+001 The value for x = 1, y = 40 and x = 2 and y = 40 are missing. They will be set to the value specified on import.

S4-9 PAT328, Section 4, September 2004 Copyright 2004 MSC.Software Corporation INCOMPLETE DATA n The Options form on the Fields/Create,Modify forms has a new frame for specifying the action for incomplete data u Abort: ends the process if data is incomplete u Set to Zero: sets value of any incomplete data to zero u Set to User Specified Value: sets the value of any incomplete data to a value that the user specifies on the form.

S4-10 PAT328, Section 4, September 2004 Copyright 2004 MSC.Software Corporation EXTRAPOLATION n After a complete set of data is input, you may choose how the spreadsheet data is extrapolated throughout the model. u Closest Table Value: uses the exact value from the nearest data point u Linear Extrapolation: extrapolates linearly throughout the model u Set to Zero: uses a value of zero for all points not entered in the spreadsheet

S4-11 PAT328, Section 4, September 2004 Copyright 2004 MSC.Software Corporation EXERCISE Perform Workshop 1: Import Thermal Field Perform Workshop 2: Import Pressure Field

S4-12 PAT328, Section 4, September 2004 Copyright 2004 MSC.Software Corporation