### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Using LINEST for non-linear curve fitting
- Using Goal Seek on Multiple Cells
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Commenting a block of code in VBA
- Cubic Splines
- Drawing in Excel 7 - Creating drawings from coordinates
- Using Linest for non-linear curve fitting, examples, hints and warnings
- The angle between two vectors, Python version
- Arrays vs Collections vs Dictionary Objects (and Dictionary help)
- Retrieving unique values from a range or array ...

### Recent Comments

# 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