### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- The angle between two vectors, Python version
- Cubic Splines
- Using LINEST for non-linear curve fitting
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Taming Symbols in Excel
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Daily Download 8: Drawing in Excel

### Recent Comments

OliviaHoros on Commenting a block of code in… Column buckling unde… on Using Frame4Buckle with the Al… Column buckling unde… on Buckling of columns with varyi… dougaj4 on Biaxial bending update DonB on Biaxial bending update dougaj4 on Biaxial bending update DonB on Biaxial bending update DonB on Biaxial bending update Perko on Installing Adobe Reader non-DC… Python Traps | Newto… on The meaning of = in Pytho… dougaj4 on P-Y Curve function Zhitong Zhang on P-Y Curve function Matt Cornell on Newton’s Cradle Clive James and Pete… on The Barrow Poets dougaj4 on Excel to Alglib via xlwin…

# Category Archives: Newton

## Column buckling under multiple loads

Following another buckling discussion at Eng-tips I have modified my Frame4-buckle spreadsheet to allow input of multiple axial loads at any point along the column, along with any number of sections with different section properties. Background on the method used … Continue reading

Posted in AlgLib, Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, UDFs, VBA
Tagged AlgLib, column buckling, Euler buckling, Excel, Frame Analysis, multiple load buckling, stepped column, tapered column, VBA, Vianello
Leave a comment

## Trinity Bridge and Bridge of the Month

Bill Harvey has been doing a monthly report on historical bridges for many years, but recent issues have the added interest of interactive 3D models of the selected bridges. The Trinity Bridge at Crowland in South Lincolnshire is an excellent … Continue reading

Posted in Arch structures, Historic Bridges, Newton
Tagged 3D Model, Bill Harvey, stone arch bridge, Trinity Bridge
Leave a comment

## Python Traps

When converting existing VBA code to Python there are a number of obvious changes to the syntax that need to be made for the code to run at all, but there are also a number of not so obvious traps … Continue reading

Posted in Arrays, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs, VBA
Tagged Excel, for loop counters |, Numpy, Passing variables, Python, python traps, PyXLL, UDF, VBA
Leave a comment

## Biaxial bending update

The reinforced concrete biaxial bending spreadsheet has now been updated: Stress block and capacity reduction factors updated for AS 3600-2018 ACI factors for US customary units used when stress is entered in ksi or psi units Example data updated The … Continue reading

Posted in Beam Bending, Concrete, Newton
Tagged ACI 318, AS 3600, biaxial bending, Eurocode 2, Excel, Reinforced Concrete, UDFs, ULS Design Functions, VBA
8 Comments

## More powers of 3

Following the discovery of a question to which the answer is 42, the same team has now reported a sum of three cubes equal to 3. As before, the result can be checked from Excel, linking to mpmath, via pyxll. … Continue reading

Posted in Computing - general, Excel, Link to Python, Maths, Newton, PyXLL
Tagged 42, Excel, Life the Universe and Everything, mpmath, PyXLL, sum of 3 cubes
Leave a comment

## The answer to Life the Universe and Everything …

is 42, as is well-known: The actual question, to which the answer is 42, is not known, but a lesser known long standing question involving this number has recently been solved: The original problem, set in 1954 at the University … Continue reading

Posted in Computing - general, Excel, Maths, Newton, PyXLL
Tagged 42, Excel, Life the Universe and Everything, mpmath, PyXLL
5 Comments

## Plotting Mandelbrot

There are many sites discussing the Mandelbrot Set, but not many examples using VBA to plot the set in Excel, so here is my effort: The spreadsheet (including open source VBA code) may be downloaded from: Mandelbrot chart.zip Note that … Continue reading

Posted in Charts, Charts, Coordinate Geometry, Drawing, Excel, Maths, Newton, VBA
Tagged Charts, Excel, Mandelbrot Set, VBA
3 Comments