Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Cubic Splines
- Using LINEST for non-linear curve fitting
- RC Design Functions 9.0
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Downloads
- Drawing in Excel 7 - Creating drawings from coordinates
Recent Comments
Tag Archives: Freeze-thaw 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