eFatigue gives you everything you need to perform state-of-the-art fatigue analysis over the web. Click here to learn more about eFatigue.

Variable Amplitude Supported File Types

The supported formats are:

• EXCEL .xls, .xlsb and .xlsx
• ASCII

To download an example .xls multi-sheet loading data file click here.

All formats have the same data recognition rules.
Data is either a histogram or a set of time histories.

Histogram Data:

Histogram data is asssumed to be a To-From matrix. Where:

• X Axis - To
• Y Axis - From

It should be noted that the bin limits defined are the lower edge of the bin. So the bin ranges are:

• Bin 1 : -1000 to -500
• Bin 2 : -500 to 0
• Bin 3 : 0 to 500
• Bin 4 : 500 to 1000

The fatigue software will generally assume the largest cycle that could be formed by the to and from turning points.
So the one cyle shown will be from -1000 to 1000.

Time Histories or Sequential Data:

If the data is not recognised as a histogram then the data will be passed through the history recognition rules.
To be recognised as history data the number of numeric columns is tracked. Non numeric data is treated as a header.
The algorithm searchs for the start of data by skipping rows of data where non-numeric values occur. It then requires
that all subsequent data is numeric and that the number of columns of data should be consistent.
Allowance is made for histories of different lengths.

The example below shows 3 channels of data,
the first with 8 samples,
the second with 4 samples,
and the third with 10 samples.

Initial non-numeric rows are ignored. This allows data with a header to be read, the header is ignored.
The above example with a header would look something like

If the numeric data starts on row 2 then the first row is assumed to be a set of data channel names.
The above example with a header would look something like

Currently 3 Excel formats are supported:

• Excel .xls BIFF 8 (Excel 97-2007)
• Excel .xlsx (Excel 2007 ASCII)
• Excel .xlsb (Excel 2007 Binary)

Excel formats support multiple sheets and each sheet is passed through the data recognition rules as a separate entity.
So there may be a histogram on sheet 1 (Channel 0),
  3 load histories on sheet 2 (channels 1-3),
  sheet 3 could not be recognised as load data,
  and sheet 4 has 2 load histories (channels 4-5).

ASCII data is formed into cells using one of two cell delimiters – a comma, or a tab.
Multiple spaces are allowed between columns of data but a single comma or tab is required to denote the end of a column's data.
If a column's data is blank then the trailing comma or tab is still required. This would occur when multiple histories of different
lengths are defined.
The 3 channel time history example above is replicated below in ASCII format using commas as the delimiter.


Gage 23, Pressure 2, Temperature 9
1000.0, 2000.0, 3000.0
2000.0, 3000.0, 2000.0
3000.0, 2000.0, 1000.0
2000.0, 1000.0, 0.0
1000.0,   , 1000.0
0.0,   , 2000.0
1000.0,   , 3000.0
1000.0,   , 3000.0
  ,   , 2000.0
  ,   , 1000.0