### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Using LINEST for non-linear curve fitting
- Using Goal Seek on Multiple Cells
- Cubic Splines
- Commenting a block of code in VBA
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Fitting high order polynomials
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Bridges Over the Tiber -3
- Retrieving unique values from a range or array ...
- Drawing in Excel 7 - Creating drawings from coordinates

### Recent Comments

dougaj4 on Buckling of columns with varyi… Marco Valsecchi on Buckling of columns with varyi… Displaying trend lin… on Using LINEST for non-linear cu… RCInteract and RC De… on RC Design Functions 7.03 Larry Schuster on Using LINEST for non-linear cu… Larry Schuster on Using LINEST for non-linear cu… dougaj4 on Using LINEST for non-linear cu… dougaj4 on Using LINEST for non-linear cu… dougaj4 on Using LINEST for non-linear cu… Larry Schuster on Using LINEST for non-linear cu… dougaj4 on Using LINEST for non-linear cu… Larry Schuster on Using LINEST for non-linear cu… dougaj4 on Using LINEST for non-linear cu… dougaj4 on Using LINEST for non-linear cu… Larry Schuster on Using LINEST for non-linear cu…

# Tag Archives: SciPy

## Weighted Least Squares Regression, using Excel, VBA, Alglib and Python

Least squares linear regression in Excel is easy. That’s what the Linest and Trend functions do. That is, they find the coefficients of a straight line (or higher dimension shape) so that the sum of the squares of the distances of … Continue reading

Posted in AlgLib, Curve fitting, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA
Tagged AlgLib, Linest, Python, SciPy, UDF, VBA, Weighted least squares regression
Leave a comment

## Non-linear frame analysis; moment curvature and self-weight

The Python/Fortran/Excel frame analysis program (previous version here) now has several new features added to the 2D-solver routines: The beam bending behaviour may now be specified with moment-curvature tables, rather than the linear-plastic behaviour required in the previous version. Beam … Continue reading

Posted in Arch structures, Beam Bending, Concrete, Excel, Finite Element Analysis, Fortran, Frame Analysis, Link to dll, Link to Python, NumPy and SciPy, Strand7, VBA
Tagged Excel, FEA, Fortran, Frame Analysis, link to dll, moment curvature, Non-linear concrete, Non-linear geometry, Programming the Finite Element Method, Python, SciPy, sparse solvers, VBA, xlwings
1 Comment

## xlwSciPy 1.09 – update for xlwings 0.10 and Scipy 0.18.1

The xlwSciPy spreadsheet (last presented here) has been updated for the latest version of xlwings and Scipy. The new spreadsheet can be downloaded from: xlScipy-xlw.zip including full open source code. The spreadsheet requires Python, including xlwings, Numpy, Scipy and Pandas … Continue reading

Posted in Arrays, Curve fitting, Excel, Link to Python, Maths, NumPy and SciPy, Python Pandas, UDFs, VBA
Tagged Automatic re-size array functions, Cubic splines, EvalA function, Excel, Python, SciPy, UDF, VBA, xlwings
1 Comment

## Non-linear Frame Analysis – Scipy solvers

The frame analysis spreadsheet presented in the previous post has been updated to use the solvers included in the Scipy package. There is now an option to use either the Cholesky solver, or an iterative sparse solver. The main advantages of … Continue reading

Posted in Arrays, Beam Bending, Excel, Finite Element Analysis, Fortran, Frame Analysis, Link to dll, Link to Python, Newton, NumPy and SciPy, Strand7, UDFs, VBA
Tagged Cholesky factorisation, ctypes, Excel, FEA, Fortran, Frame Analysis, link to dll, Non-linear concrete, Programming the Finite Element Method, Python, SciPy, sparse solvers, VBA, xlwings
1 Comment

## xlwSciPy 1.7

Following recent posts on xlwings 0.7.1, dictionaries, and optional arguments and xlwings – dataframes and statistics, I have added the associated functions and examples to the xlwSciPy spreadsheet, and also updated it to xlwings 0.71. The new spreadsheet can be … Continue reading

Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, Python Pandas, UDFs, VBA
Tagged dataframes, dictionaries, Excel, Numpy, Pandas, Python, SciPy, UDF, VBA
4 Comments

## xlwings 0.7.1, dictionaries, and optional arguments

xlwings 0.7.0 was published at the beginning of March, and introduced direct support for Python dictionaries, which I have used to demonstrate various options for dealing with optional arguments in Excel User Defined Functions (UDFs). The latest version, 0.7.1, published … Continue reading

Posted in Curve fitting, Excel, Link to Python, Maths, NumPy and SciPy, UDFs, VBA
Tagged curve_fit, dictionaries, Excel, optional arguments, Python, SciPy, UDF, VBA, xlwings
1 Comment

## Tanh-Sinh Quadrature via F2PY – Part 2

Lets look at some details of the coding. The original code (available here) includes routines “intdeini” to generate an array of points and weights of the quadrature formula, and “intde” to carry out the integration of any supplied function “f”. … Continue reading

Posted in Excel, Link to dll, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, UDFs, VBA
Tagged Excel, Excel-Python, F2Py, numerical integration, Python, SciPy, Tanh-Sinh Quadrature, UDF, VBA
Leave a comment