Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Downloads
- The history of the theory of beam bending - Part 1
- Frame Analysis with Excel 1 - Single beam
- Function roots with the Inverse Quadratic Method
- Frame Analysis with Excel - 4, 2D frame analysis
- Contour plots with Excel and Matplotlib
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Latex Maths Text in Excel
- Drawing in Excel 7 - Creating drawings from coordinates
Recent Comments
Tag Archives: Exponential curves
LinEstGap with non-linear functions
The LinEstGap user defined function (UDF) allows the built-in Linest function to be used on data with empty cells or hidden rows, returning results that agree with the chart trend-line function, which automatically ignores blank cells and hidden data. It … Continue reading
Posted in Arrays, Curve fitting, Excel, Maths, Newton, UDFs, VBA
Tagged Excel, Exponential curves, Linest, Linest with gaps, Log curves, non-linear curve fitting, Polynomial curves, Power curves, UDF, VBA
4 Comments