Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Commenting a block of code in VBA
- Using LINEST for non-linear curve fitting
- Using Goal Seek on Multiple Cells
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Cubic Splines
- Downloads
- Fitting high order polynomials
- Downloads by category
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
Recent Comments
Tag Archives: CSpline2
CSpline and Malware
I was recently informed that the Malwarebyte program was raising a warning for the CSpline2 download. On checking I found that the spreadsheet had a VBA module called frmPickwb which was not my code. The file has now been updated, … Continue reading
Posted in Computing - general, Curve fitting, UDFs, VBA
Tagged CSpline2, malware, Malwarebyte
Leave a comment
Re-sizing Array Functions
The recent updates to the ConBeamU spreadsheet contained two new functions for entering and re-sizing array functions, and since they will be useful on any spreadsheet containing array functions (which here means almost all of them) I thought they deserved … Continue reading
Posted in Arrays, Excel, UDFs, VBA
Tagged array functions, CSpline2, Cubic Spline functions, Excel, re-size arrays, UDF, VBA
4 Comments
Interpolation Update
This post was prompted by a question at Eng-Tips. The question was looking for ways to plot stress contours under a footing, which requires interpolation to find the depth where the stress is at the contour values, given stresses calculated … Continue reading