### 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
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Using LINEST for non-linear curve fitting
- Drawing in Excel 7 - Creating drawings from coordinates
- Downloads by category
- Problems with UCase and LCase in VBA

### Recent Comments

Graeme Dennes on Numerical Integration; Tanh-Si… Paul on Numerical Integration; Tanh-Si… Graeme Dennes on Numerical Integration; Tanh-Si… Paul on Numerical Integration; Tanh-Si… Paris Altidis on Numerical Integration; Tanh-Si… Erik Wynn on Cubic Splines dougaj4 on Cubic Splines Erik Wynn on Cubic Splines Erik Wynn on Cubic Splines Graeme Dennes on Numerical Integration; Tanh-Si… dougaj4 on Numerical Integration; Tanh-Si… Graeme Dennes on Numerical Integration; Tanh-Si… Paris Altidis on Numerical Integration; Tanh-Si… Kim on ConbeamU 4.10 dougaj4 on Cubic Splines

# Tag Archives: Solver

## Beams may kiss, but do not hug …

… not full length anyway. This post was inspired by a now very long discussion at Eng-Tips on the apparently simple question of what happens when you place one short beam on top of a longer one, and apply a … Continue reading

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, UDFs, VBA
Tagged ConBeamU, Excel, Simply supported beams, Solver, stacked beams, Strand7, UDF, VBA
Leave a comment

## Moving Load Spreadsheet – update and how to use

As noted in the comments on the previous post on this topic, the moving load function (and also the associated continuous beam functions) have been modified to make data entry more flexible; the output results are unchanged. The modified spreadsheet … Continue reading

Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged ConBeamU, continuous beam, Excel, Macaulay's Method, moving load, Solver, UDF, unit aware, VBA
5 Comments

## Non linear regression – 1

Recent posts have described how to fit linear equations (or equations that can be made linear) to a set of data, using the Excel Linest functions, or User Defined Functions (UDF’s) linking to the ALGLIB library (see Using LINEST for non-linear … Continue reading

Posted in AlgLib, Concrete, Excel, Maths, Newton
Tagged AlgLib, Excel, non-linear regression, Solver
4 Comments