Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Using LinEst() on data with gaps
- Continuous Beams With Spring Supports by Macaulay’s Method
- Intersections, interpolations, and rotations
- Converting from global to local coordinates (and vice versa)
- Fitting high order polynomials
- Smart Indenter and Excel 2013
- Buckling of columns with varying cross section
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
Recent Comments
Tag Archives: sigmoid curve
Plotting Freeze-Thaw Data …
… or other irregular cyclic data. Another Eng-Tips question asked how to approximate ice area over a freeze-thaw cycle using a function based on a sine or cosine curve. The screen-shot below shows three alternatives: Using built in Excel functions requires … Continue reading
Posted in Arrays, Curve fitting, Excel, Maths, Newton, UDFs, VBA
Tagged cyclic data, Excel, Freeze-thaw curve, sigmoid curve, UDF, VBA
1 Comment