Import Response Data from an Excel Spreadsheet
Before you begin: You must have Microsoft Excel 2007 or later installed to import
test data.
-
From the Calibration Tools section of the action bar, click Import Response Only
Data
.
-
From the file selection dialog box that appears, do the
following:
-
Set the file extension filter to
Excel files.
-
Select the test data file that you want to import, then
click
Open.
The
Material Test Data Import dialog box appears
with your data displayed in a table.
- Optional:
Enter a descriptive
Name.
-
Specify the type of
Deformation mode represented by this
experimental test data. The app supports
Uniaxial,
Biaxial,
Planar,
Simple shear data, and
Volumetric data.
-
From the data table, either highlight the strain data only or highlight the
strain data and the time data. You can click-drag on a subset of the data or
highlight column or rows.
-
Click
Next.
A plot of your test data appears in the panel, with the
quantities and units describing the data in the lower half.
-
From the column headings above the tabular data, specify the
correct data type and units for each column of data you want to import. For
example, your selections for hyperelastic data might be
Time (s),
Nominal Strain (%), and
Nominal Stress (Pa). You can also select
Ignore from the column headings if you do
not want to import a column of highlighted data.
-
Click
Next.
A page appears with temperature and time options, along
with calibration notes.
- Optional:
Specify the
Temperature for the testing and provide any
other testing information in the
Notes. If you did not import any time data,
you can also specify the
Strain rate or
Total time of the data.
-
Click Import.
The import of the test data is completed and the panel remains open
for import of other data.
-
Click Close when done importing test data to close
the panel.
The app imports your test data and plots the data.
Import Response Data from a Text File or a .csv File
-
From the
Calibration Tools section of the
action bar,
click
Import Response Only Data
.
-
From the file selection dialog box that appears, do the
following:
-
Set the file extension filter to
Text files.
-
Select the test data file that you want to import, then
click
Open.
The
Material Test Data Import dialog box appears
with your data displayed in a table.
- Optional:
Enter a descriptive
Name.
-
Specify the type of
Deformation mode represented by this
experimental test data. The app supports
Uniaxial,
Biaxial,
Planar,
Simple shear data, and
Volumetric data.
-
Specify the types of
Delimiters used between data entries.
For example, select Space if your data entries are separated by
spaces; otherwise, the app incorrectly interprets two numbers separated by
only a space as a single number. The app ignores any delimiters you select
that do not appear in the file.
You can also select Treat Consecutive Delimiters As One to handle
cases where multiple delimiters, such as spaces and commas, are present
between data entries. For most situations, the best option is to set all the
available delimiters and treating consecutive delimiters as a single
delimiter.
-
Specify the row from which you want to start importing data by
using either the
Start import at row selector or by directly
highlighting the row.
-
Click
Next.
A plot of your test data appears in the panel, with the
quantities and units describing the data in the lower half.
-
From the column headings above the tabular data, specify the
correct data type and units for each column of data you want to import. For
example, your selections for hyperelastic data might be
Time (s),
Nominal Strain (%), and
Nominal Stress (Pa). You can also select
Ignore from the column headings if you do
not want to import a column of highlighted data.
-
Click
Next.
A page appears with temperature and time options, along with calibration
notes.
- Optional:
Specify
Temperature for the testing and provide any
other testing information in the
Notes. If you did not import any time data,
you can also specify the
Strain rate or
Total time of the data.
-
Click Import.
The import of the test data is completed and the panel remains open
for import of other data.
-
Click Close when done importing test data to close
the panel.
The app imports your test data and plots the data.
|