Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Commenting a block of code in VBA
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Downloads
- Latex Maths Text in Excel
- Retrieving unique values from a range or array ...
Recent Comments
Jose Luna on More updates to ArcSpline and… Lucas Beattie on Drawing in Excel – … marcengineer on More on combined shear and ben… dougaj4 on More on combined shear and ben… Marc on More on combined shear and ben… Sukrit Ghorai on Biaxial bending update dougaj4 on Biaxial bending update Sukrit on Biaxial bending update A not so easy proble… on Pint, MPmath and implied units… dougaj4 on ULS design of circular reinfor… Dakota on ULS design of circular reinfor… Marcus747 on Commenting a block of code in… dougaj4 on Biaxial bending update Sukrit on Biaxial bending update DT67 on Using ConbeamU
Category Archives: Curve fitting
Calling Numpy polynomial functions from Excel
The Numpy polynomial related function discussed in recent posts can now be downloaded from: py_Numpy.zip The download file includes Python code and a sample spreadsheet. Required installed software is Python, Numba and pyxll to call the code from Excel. Some … Continue reading
Posted in Curve fitting, Excel, Link to Python, Maths, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, Link to Python, Numpy, PyXLL, UDFs
Leave a comment
VBA procedures for the Numerical Analysis of Tabular Functions
Long time on-line friend Alfred Vachris has recently been converting Fortran code developed through his working career into VBA: I had the opportunity to work at Grumman while going to Graduate School and they gave me a part-time job as … Continue reading
Posted in Coordinate Geometry, Curve fitting, Excel, Fortran, Maths, Newton, UDFs, VBA
Tagged Aitken Graphical Construction, Alfred Vachris, Arc Length, Excel, Interpolation, Tabular Functions, VBA
1 Comment
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
Deflections and Moments in Rectangular Plates
Following a question here I have compared tabulated coefficients for deflections and bending moments in a rectangular plate with results of a Strand7 analysis using 8 noded plate/shell elements. The results are summarised below, and in a spreadsheet which also … Continue reading
Posted in Beam Bending, Curve fitting, Excel, Finite Element Analysis, Newton
Tagged Excel, FEA, Linest, Moody, Pilkey, plate bending, plate deflections, Plate stresses, Roark, Strand7, Timoshenko
5 Comments
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