### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Time in hours and minutes between two dates
- Using Goal Seek on Multiple Cells
- Commenting a block of code in VBA
- Downloads by category
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Fitting high order polynomials
- Downloads
- Using LINEST for non-linear curve fitting
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python

### Recent Comments

dougaj4 on Weighted Least Squares Regress… NotOP on Weighted Least Squares Regress… Installing PyPardiso… on Making Finite Element Analysis… John Maddock on Numerical Integration With Tan… Graeme Dennes on Numerical Integration With Tan… dougaj4 on Numerical Integration With Tan… dougaj4 on Numerical Integration With Tan… John Maddock on Numerical Integration With Tan… Making Finite Elemen… on Making Finite Element Analysis… Chartree on ULS Design Functions 2.13 dougaj4 on ULS Design Functions 2.13 Chartree L. on ULS Design Functions 2.13 dougaj4 on ULS Design Functions 2.13 Chatree L. on ULS Design Functions 2.13 ConbeamU update | Ne… on ConbeamU 4.10

# Tag Archives: Solver

## Asymmetric Catenary Function

Back in 2009, I posted a user defined function (UDF) to generate a catenary curve, that could be used together with the Excel Solver to generate a curve of a specified span and sag: A catenary function Following a discussion … Continue reading

Posted in Coordinate Geometry, Curve fitting, Excel, Maths, Newton, UDFs, xlwings
Tagged Catenary, Excel, Solver, UDF, VBA
Leave a comment

## Using Excel Solver from VBA

Using the “record macro” icon in Excel to record the solver process, I had a couple of problems: When I tried to run the recorded macro, I got the message “Compile Error – Sub or Function not defined”. When that … Continue reading

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