MATERIAL EXCEL PARSER¶
Parses one or more material test Excel files from lab vendors (OSU, Waterloo, Datapoint, Axel Products, Henkel, WSU Occupant, and others) into structured test datasets, automatically detecting or applying a user-specified format and test type. Use this worker to ingest raw coupon test spreadsheets and route results into typed output channels (uniaxial, shear, notch, punch, compression, etc.) for downstream characterization or calibration workflows.
When to use¶
Tagged: Axel, Datapoint, Henkel, OSU, WSU, Waterloo, biaxial, compression.
Inputs¶
| Label | ID | Type | Default | Required | Description |
|---|---|---|---|---|---|
| Excel File | excel_file | file | — | ✓ | One or more Excel workbooks (.xlsx / .xls) containing raw material coupon test data exported from a laboratory vendor; multiple files are accepted and processed together. |
| Format | format | select | auto | ✓ | Vendor/lab spreadsheet format to apply when parsing; defaults to ‘auto’ (format auto-detected), but should be set explicitly (e.g., ‘OSU’, ‘Waterloo’, ‘Axel’, ‘Henkel’) when auto-detection is unreliable for a known vendor template. |
| Test Type | test_type | select | auto | Coupon test type to expect in the file (e.g., ‘uni-axial-tension’, ‘shear’, ‘notch’, ‘biaxial_compression’); defaults to ‘auto’ so the parser infers the type from the file contents — override when the file contains a single known test type. | |
| Create Physicaltest | create_pt | select | no | Controls whether parsed results are registered as Physical Test records in the platform: ‘no’ (default) skips registration, ‘yes’ creates one Physical Test record per coupon test, and ‘yes_merged’ consolidates all tests into a single merged Physical Test record. | |
| Import Media Files | process_media | select | no | When set to ‘yes’, any media files referenced or embedded in the Excel workbook (images, DIC frames, etc.) are imported alongside the test data; defaults to ‘no’ to skip media processing and speed up ingestion. | |
| Uniaxial Test Identifier | uniaxial_test_pattern | scalar | uniaxial | ✓ | |
| Shear Test Identifier | shear_test_pattern | scalar | shear | ✓ | |
| Punch Test Identifier | punch_test_pattern | scalar | punch | ✓ | |
| Notch Test Identifier | notch_test_pattern | scalar | notch | ✓ | |
| Regularization Test Identifier | regular_test_pattern | scalar | regular | ✓ | |
| R45 Test Identifier | r45_test_pattern | scalar | 45 | ✓ | |
| R90 Test Identifier | r90_test_pattern | scalar | 90 | ✓ | |
| Drop Test Pattern | drop_test_pattern | scalar | DT | ||
| Linear Compression Pattern | linear_compression_pattern | scalar | ICompression | ||
| Bi-axial Compression Pattern | biaxial_compression_pattern | scalar | BC | ||
| Rules File | rules_file | file | — | Excel or CSV file that contains rules | |
| Test Prefix | test_prefix | scalar | — | ||
| DIC Uniaxial Component | dic_uniaxial_comp | text | exx | ||
| DIC Shear Component | dic_shear_comp | text | gamma_xy | ||
| DIC Punch Components | dic_punch_comps | text | e1,e2 | ||
| Test Type Pattern Source | test_type_pattern_source | select | filename | ||
| Test Type Pattern Location | test_type_pattern_location | select | contains | ||
| Cone Push Pattern | cone_push_pattern | scalar | ConePush | ||
| Strain Rate Pattern | strain_rate_pattern | scalar | Tension-SR | ||
| Notch DIC Component | dic_notch_comp | text | eyy | ||
| UDEC | dic_ua_eyy_comp | text | eyy | Uniaxial DIC EYY Component |
Outputs¶
| Label | ID | Type | Description |
|---|---|---|---|
| All Tests | all_tests | dataset | Unified dataset containing every parsed test record from all input files, regardless of test type — use as the single consolidated output when downstream steps do not require type-based routing. |
| Uniaxial Tests | uniaxial_tests | dataset | Dataset of uniaxial tension and compression coupon tests (force–displacement or engineering stress–strain curves) extracted from the input files. |
| Shear Tests | shear_tests | dataset | Dataset of shear coupon tests (e.g., Iosipescu, lap-shear) with shear stress–strain or load–displacement curves. |
| Notch Tests | notch_tests | dataset | Dataset of notched-specimen tests used for fracture locus and triaxiality characterization. |
| Punch Tests | punch_tests | dataset | Dataset of punch (Nakazima / Marciniak) or dome tests used for forming-limit and biaxial characterization. |
| Regular Tests | regular_tests | dataset | Dataset of regularization tests, typically used for mesh-size-dependent fracture strain scaling inputs in GISSMO or similar damage models. |
| R45 Tests | r45_tests | dataset | Dataset of 45-degree off-axis (R45) anisotropy tests for Lankford coefficient and yield-surface calibration. |
| R90 Tests | r90_tests | dataset | Dataset of 90-degree transverse (R90) anisotropy tests for Lankford coefficient and yield-surface calibration. |
| Drop Tests | drop_tests | dataset | Dataset of drop-weight impact tests, capturing force–time or energy–displacement histories from dynamic coupon loading. |
| Compression Tests | compression_tests | dataset | Dataset of uniaxial compression tests (linear compression) providing compressive stress–strain behavior, often used for foam or adhesive material models. |
| Biaxial Compression Tests | biaxial_compression_tests | dataset | Dataset of biaxial compression tests providing multi-axial compressive response data for advanced material model fitting. |
| Unclassified Tests | unclassified_tests | dataset | Dataset of test records that could not be assigned to any recognized test-type category — inspect these for unsupported vendor formats or ambiguous column headers. |
Disciplines¶
- data.dataset.ingest
- data.io.excel
- engineering.material.characterization
- engineering.material.specimen
Auto-generated from platform schema. Worker id: material_excel_parser. Schema hash: 573838c74d36. Hand-curated docs in workerexamples/ override this page when present.