### 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
- Latex Maths Text in Excel
- Using Goal Seek on Multiple Cells
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Deflections and Moments in Rectangular Plates
- Taming Symbols in Excel
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Retrieving unique values from a range or array ...

### Recent Comments

Latex Maths Text in… on Pint, MPmath and implied units… dougaj4 on The VBA Decimal data type Ludek on The VBA Decimal data type dougaj4 on The VBA Decimal data type Ludek on The VBA Decimal data type dougaj4 on About Newton Excel Bach Reinaldo Chohfi Jr. on About Newton Excel Bach Solving cubic equati… on Solving Quadratic, Cubic, Quar… David N on A Match Function Bug … dougaj4 on A Match Function Bug … SectionProperties up… on SectionProperties update updat… David N on A Match Function Bug … dougaj4 on Fitting 3D circles to scattere… Aaron on Fitting 3D circles to scattere… dougaj4 on 3D plots with the latest …

# Category Archives: Newton

## Latex Maths Text in Excel

There have been many posts here looking at alternative ways of working with functions entered as text on a spreadsheet, and working with units, most recently here. One drawback with this approach is that text in an Excel cell must … Continue reading

Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged EvalU, Excel, Latex, Math Text, mpmath, Pint, Python, PyXLL, Sympy, UDFs, Unit-aware calculation
Leave a comment

## RC Design Functions 9.03; compression strut angle adjustment

The RC Design Functions spreadsheet has now been updated to Version 9.03, and is available for free download from: RC Design Functions9.zip The new version includes a number of corrections to the calculation of beam shear and torsion capacity to … Continue reading

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged AS 3600, AS 5100.5, Compression block angle, Design for Shear, Excel, Longitudinal shear force, Reinforced Concrete Design Functions, UDFs, VBA
Leave a comment

## Linking to Python help from Excel

The py_Numpy spreadsheet presented in the previous post has been updated: The new version can be downloaded from: py_Numpy.zip As before, the pyxll add-in is required for the connection from Excel to Python. All the available functions are listed on … Continue reading

Posted in Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Display Python help, Excel, Link to Python on-line help, Numpy, Python, PyXLL, UDFs
Leave a comment

## 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

## Solving cubic equations – background and timing

For more information on the polynomial functions, including quartic and higher order solvers, see: Solving Quadratic, Cubic, Quartic and higher order equations; examples Re-reading the Wikipedia article on solving cubic equations, I noticed that the trigonometrical solution for finding 3 real … Continue reading

Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs, VBA
Tagged cubic equations, Excel, Numba, Numpy, Polynomials, Pyhon, PyXLL, Quartic equations, UDFs, VBA
Leave a comment