### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Cubic Splines
- Using Goal Seek on Multiple Cells
- The angle between two vectors, Python version
- Using LINEST for non-linear curve fitting
- Downloads by category
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Problems with UCase and LCase in VBA
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Retrieving unique values from a range or array ...

### Recent Comments

More Numpy with Exce… on Using Array Functions and… More Numpy with Exce… on Sorting with Python and N… Office Insiders and… on JavaScript UDFs in Excel Sorting with Python… on Sorting with VBA and Pyth… Sorting with VBA and… on Dynamic sorting with Excel, VB… Luis on Okenyo dougaj4 on Drawing in Excel 7 – Cre… rva on Drawing in Excel 7 – Cre… dougaj4 on Numerical Integration; Tanh-Si… srabutdotcom on Numerical Integration; Tanh-Si… dougaj4 on Converting from global to loca… Joan Gonzalez on Converting from global to loca… dougaj4 on Beam geometric non-linear… Bob Jordan on Beam geometric non-linear… David Lim on Frame Analysis Resources

# Category Archives: Newton

## More Numpy with Excel and xlwings

The spreadsheet presented in the last post on sorting also includes links to many other Numpy functions. The spreadsheet and associated Python file can be downloaded from: xlNumpy.zip The Numpy functions require xlwings and Numpy to be installed, which are included in … Continue reading

Posted in Arrays, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings
Tagged Anaconda, Excel, math functions, Numerical ranges, Numpy, Polynomial functions, Python, Trig functions, UDF, VBA, xlwings
Leave a comment

## Sorting with Python and Numpy

Following the previous post, lets look at sorting functions in the Numpy library. The spreadsheet xlwNumpy links to a variety of Numpy functions, including the sorting functions described below. The spreadsheet and associated Python code can be downloaded from: xlNumpy.zip … Continue reading

## IP2_py Update for Python3

The spreadsheet IP2_py provides a large number of geometric functions, including intersection points of lines, circles and planes, interpolation, rotations, and converting between coordinate systems. Many of the functions are available in VBA and Python versions. The Python code has now … Continue reading

## Beam geometric non-linear effects

A quick and convenient way to allow for the effect of deformations on the behaviour of beams and columns under axial load is to adjust the beam stiffness matrix, so that the calculated deflections are in equilibrium with the applied … Continue reading

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, UDFs, VBA
Tagged Euler buckling, Excel, Frame Analysis, Non-linear geometry, Second order effects, UDF, VBA
2 Comments

## Frame Analysis Resources

I recently discovered: Matrix Structural Analysis, 2nd Edition, by McGuire, Gallagher, and Ziemian. which is available for free download: Description The aims of the first edition of Matrix Structural Analysis were to place proper emphasis on the methods of matrix … Continue reading

Posted in Finite Element Analysis, Frame Analysis, Newton
Tagged Frame Analysis, free download, MASTAN2
1 Comment

## xlwSciPy update for Python 3

The xlwSciPy spreadsheet allows a wide variety of the science and maths functions in the Python Numpy and Scipy libraries to be called directly from Excel. The spreadsheet has now been updated for use with Python 3. The spreadsheet and … Continue reading

Posted in Coordinate Geometry, Differential Equations, Excel, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, Python Pandas, UDFs, VBA, xlwings
Tagged Excel, Numpy, Python, SciPy, UDF, VBA, xlwings
Leave a comment

## Jørn Utzon and David Moore

Tomorrow (9th April 2018) is the centenary of the birth of Jørn Utzon, the architect of the Sydney Opera House, which is celebrated in an article at the Sydney-Morning Herald. The article quotes a grand-son of Utson, Mika Utzon Popov, … Continue reading

Posted in Arch structures, Bach, Newton
Tagged construction photographs, David Moore, Jorn Utzon, Sydney Opera House
Leave a comment