File formats¶
Reference
Test data (import)¶
Two numeric columns, x then y, in the module's current units. Accepted: .xlsx, .xls, .csv, .txt. Header rows, unit rows, text cells and any delimiter are tolerated. A file with more than two numeric columns opens a column chooser. Details and example files are under Test data files.
Project file (.mat)¶
A MATLAB data file holding one structure named parameters. It stores the geometry, the material laws in normalized form (cracking strain, \(\mu_i\), \(\beta_i\), \(\gamma\), \(\omega\), \(\mu_c\), \(\lambda_{cu}\), and the steel ratios where present), the reinforcement, the loading type, the plastic length, the imported experimental curves, the unit system and the software version. Project files are opened by the module that wrote them.
Output workbook (.xlsx)¶
Every module writes an Input_Parameters sheet plus one sheet per curve. The Input_Parameters sheet is a two-column list: parameter name in column A, value in column B, grouped under the headings Metadata, Geometry, Tension Model, Compression Model and, when present, Steel Properties, Reinforcement Details and Reinforcement Areas.
| Sheet | Columns |
|---|---|
Tension_Data |
epsilon_t_pct, sigma_t |
Compression_Data |
epsilon_c_pct, sigma_c |
Reinforcement_Data |
epsilon_s_pct, sigma_s (with rebar only) |
Moment_Curvature_Data |
moment, curvature, normalized bottom strain |
Deflection_Load_Data |
deflection, load |
Strain_Values |
delta, Load, epsilon_bot_pct, epsilon_top_pct, NA_from_bot |
Input_Parameters |
key, value |
| Sheet | Columns |
|---|---|
Tension_Data |
branch, crack opening \(w\), stress |
Compression_Data |
strain, stress |
Moment_Rotation_Data |
rotation, moment, \(k\) |
Moment_CrackWidth_Data |
CTOD_Model, CMOD_Model, moment |
Load_CMOD_Data |
CMOD_Model, CTOD_Model, load |
Flexural_Stress_CrackWidth_Data |
CTOD_Model, CMOD_Model, flexural stress, moment, load |
Experimental_Data |
curve id, curve type, CMOD_Measured, load |
Input_Parameters |
key, value |
Version note. These EN 14651 sheet and column names belong to the change listed under Unreleased in the release notes. Workbooks from builds using the earlier workflow carry the earlier column names.
Every response sheet carries both crack-opening coordinates, and the
column names say which is which: CTOD_Model is the model opening at the
notch tip, \(w + \varepsilon_{cr} L_p\), the coordinate the tension law
lives on; CMOD_Model is the crack-mouth opening the same model predicts
at the gauge line. The experimental sheet is headed CMOD_Measured
because it holds the record exactly as imported.
| Sheet | Columns |
|---|---|
Input_Parameters |
key, value |
Section_Vertices |
x, y of the polygon (and the void) |
Rebar_Layers |
depth, area, yield strength per layer |
Moment_Curvature_Data |
curvature, moment, neutral axis |
Limit_States |
one row per limit state |
Keys read by Import Material¶
The Hybrid, FRP and Cross-Sectional modules read these keys from an Input_Parameters sheet. Stresses are absolute values in the workbook's unit system, strains are in percent.
| Group | Keys |
|---|---|
| Metadata | Module Output Type (strain-based or crack-width-based), Unit System (SI or US) |
| Tension Model | E, epsilon_cr (%), sigma_cr, epsilon_1 (%), sigma_1, epsilon_2 (%), sigma_2, epsilon_3 (%), sigma_3 |
| Compression Model | Ec, f'c, f'cu, epsilon_cu (%) |
A crack-width based workbook carries w_1, w_2, w_3 instead of the strain coordinates. The design modules convert them to strains with the plastic length before use.
Engineering report (.html)¶
One self-contained file: summary metrics, geometry and loading, the experimental data table when a curve was imported, the final stress-strain coordinates, the key limit states and every figure embedded as an image. Open it in a browser and print to PDF if a PDF is needed.
Log file¶
%LOCALAPPDATA%\HRCDesigner\hrc_designer.log, plain text, rotated at 2 MB. Every error dialog is written there with its stack. Help → Open Log Folder opens the folder.