StoFlo™
Rainflow Cycle Counting Excel Template with Macros
About
StoFlo is a free software application within Microsoft Excel. It contains code that will perform rainflow cycle
counting. The required input is
ASCII data. The output is the range and mean of each cycle, as shown in the image on the right.
Notes about StoFlo:
* Must have a legal copy of Microsoft Excel installed on your computer for StoFlo to work.
* Must have macros enabled within Excel to use StoFlo (Tools->Macro->Security->Medium)
* Use at your own risk. No implied warranty of any kind.
Thank you VERY much!
For people without PayPal accounts (credit card, check):
Thank you VERY much!
If you have any comments or questions regarding StoFlo, please send an email with the subject "Rainflow" to the following address:
Fatigue Life Plots
Sample Time Series Input
Actual Rainflow Cycle Output
Changelog
13.05:
- Added ability to process up to 1048576 rows (over 1 million) of data - More compatible with Excel 2007 13.04:
- Added Ctrl+T option in case PV slice button doesn't work for users 10.08:
- Corrected time series data display to show 1-32000 and 32001-64000 rows - For bin sort, shut off screen updating and added userform to show progress of bin sorting, 10.04:
- Updated instructions on first tab
- Added capability to process up to 65536 rows of data
9.12:
- Corrected issue with rearranging data greater than 32000 rows
- Added button to easily clear time series data
9.11:
- Thanks to feedback, corrected issue with following data not cycle counting correctly: 1t 95Mpa, 2t 126Mpa, 3t 65Mpa. Fix was to ignore PV slicing for data that contains 3 data points or fewer. Also added PV slicing after data is rearranged to make the highest absolute value magnitude the starting and ending point.
9.08c:
- Cut time to perform rainflow counting to about 1/3 of what it was using new progress bar (thanks to Cameron Rout) - Multiplied cell D32 on RangeMean tab by 1.001 to be more robust when bin sorting
9.08b:
- Changed the button that Macro15extremes is assigned to - Corrected issue with last couple rainflow cycles being wrong on some sets of data - Corrected issue with clearing data on the Input tab
9.08:
- Corrected issue with data set (2,5,3,7,-100,-200) <-- This should work now - Added the following critical pre-processing step which has been missing since Stoflo inception: - "Arrange time history to start and end with the maximum absolute value point" - Changed how clear data works on Nf RF tab
9.06:
- Added plots to display strain life and stress life curves for specimen of interest.
- Due to additional plots, overall file size now exceeds 4 MB. To reduce file size significantly, delete the tab titled "Nf RF Graphs"
9.04c:
- Added stress life with no mean stress correction to Nf RF tab
- Reduced overall file size to 366 kB!
- Eliminated the "Extremes" tab and moved data to the "Input" tab
- Cleaned up appearance and order of Nf RF tab
9.04b:
- Corrected issue with incorrect local stress on sheet Nf RF when K<2 for notched specimens.
9.04:
- Added Nf RF sheet that calculates overall fatigue life for specimen by using stress life and strain life equations
9.03g:
- Even after filtering out user-selected max and min threshholds, rainflow counting process made 3x faster
9.03f:
- Fixed issue with last few rainflow cycles not getting counted
- Made rainflow counting process three times faster with new peak filtering algorithm
9.03e:
- Fixed link to "input" sheet on start page
9.03d:
- Improved method for filtering out non-peaks and non-valleys
- Moved bin sorting execute button to the RangeMean sheet
- Simplified names of tabs at bottom of screen for each sheet
9.03c:
- Corrected issue with max min filter not working on last row
- Corrected issue with bin sorting not working on last row
9.03b:
- added support for MS Office 2000
- added support for 65536 rows of data
- reduced file size to 554 kb
- added option for user to enter "filter" values for minimum and/or maximum. This would prevent count data below a certain threshold and ignore spikes (if needed).
13.05:
- Added ability to process up to 1048576 rows (over 1 million) of data - More compatible with Excel 2007 13.04:
- Added Ctrl+T option in case PV slice button doesn't work for users 10.08:
- Corrected time series data display to show 1-32000 and 32001-64000 rows - For bin sort, shut off screen updating and added userform to show progress of bin sorting, 10.04:
- Updated instructions on first tab
- Added capability to process up to 65536 rows of data
9.12:
- Corrected issue with rearranging data greater than 32000 rows
- Added button to easily clear time series data
9.11:
- Thanks to feedback, corrected issue with following data not cycle counting correctly: 1t 95Mpa, 2t 126Mpa, 3t 65Mpa. Fix was to ignore PV slicing for data that contains 3 data points or fewer. Also added PV slicing after data is rearranged to make the highest absolute value magnitude the starting and ending point.
9.08c:
- Cut time to perform rainflow counting to about 1/3 of what it was using new progress bar (thanks to Cameron Rout) - Multiplied cell D32 on RangeMean tab by 1.001 to be more robust when bin sorting
9.08b:
- Changed the button that Macro15extremes is assigned to - Corrected issue with last couple rainflow cycles being wrong on some sets of data - Corrected issue with clearing data on the Input tab
9.08:
- Corrected issue with data set (2,5,3,7,-100,-200) <-- This should work now - Added the following critical pre-processing step which has been missing since Stoflo inception: - "Arrange time history to start and end with the maximum absolute value point" - Changed how clear data works on Nf RF tab
9.06:
- Added plots to display strain life and stress life curves for specimen of interest.
- Due to additional plots, overall file size now exceeds 4 MB. To reduce file size significantly, delete the tab titled "Nf RF Graphs"
9.04c:
- Added stress life with no mean stress correction to Nf RF tab
- Reduced overall file size to 366 kB!
- Eliminated the "Extremes" tab and moved data to the "Input" tab
- Cleaned up appearance and order of Nf RF tab
9.04b:
- Corrected issue with incorrect local stress on sheet Nf RF when K<2 for notched specimens.
9.04:
- Added Nf RF sheet that calculates overall fatigue life for specimen by using stress life and strain life equations
9.03g:
- Even after filtering out user-selected max and min threshholds, rainflow counting process made 3x faster
9.03f:
- Fixed issue with last few rainflow cycles not getting counted
- Made rainflow counting process three times faster with new peak filtering algorithm
9.03e:
- Fixed link to "input" sheet on start page
9.03d:
- Improved method for filtering out non-peaks and non-valleys
- Moved bin sorting execute button to the RangeMean sheet
- Simplified names of tabs at bottom of screen for each sheet
9.03c:
- Corrected issue with max min filter not working on last row
- Corrected issue with bin sorting not working on last row
9.03b:
- added support for MS Office 2000
- added support for 65536 rows of data
- reduced file size to 554 kb
- added option for user to enter "filter" values for minimum and/or maximum. This would prevent count data below a certain threshold and ignore spikes (if needed).
2015 STOTERA INC. ALL RIGHTS RESERVEDProgram Visual Basic VB VBA Algorithm Block Cycle Testing Fatigue Life Estimation Estimator