### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- The history of the theory of beam bending - Part 1
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- The angle between two vectors, Python version
- Filling Blanks with Go To-Special (and local help rant)
- Taming Symbols in Excel
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Arrays vs Collections vs Dictionary Objects (and Dictionary help)

### Recent Comments

Melanie Safka + Mile… on Melanie Safka Mohd Yousef on Biaxial bending update DonB on Biaxial bending update Mohd Yousef on Biaxial bending update dougaj4 on Biaxial bending update DonB on Biaxial bending update dougaj4 on Biaxial bending update DonB on Biaxial bending update Mohd Yousef on Biaxial bending update dougaj4 on Beam Fixed End Actions by Maca… Peka Odendaal (@PKOd… on Beam Fixed End Actions by Maca… Gerardo Freyre on The history of the theory of b… dougaj4 on Time in hours and minutes betw… SDAmy on Time in hours and minutes betw… Concrete Stress Bloc… on Equivalent Stress Blocks

# Tag Archives: Exce

## Solving non-linear equations with two or more unknowns – 2

The previous post presented a simple but slow procedure for solving non-linear equations with two unknowns. In this post I will describe a much faster method, that also has the advantage that it can simply be extended to work with … Continue reading

Posted in Beam Bending, Concrete, Excel, Maths, Newton, UDFs, VBA
Tagged Exce, moment curvature, Newton's Method, solving non-linear equations, two or more unknowns, UDF, VBA
5 Comments

## Using Frame4Buckle with the Alglib solver

The Frame4Buckle spreadsheet carries out a buckling analysis of a column or strut, which may be divided into any number of segments with varying cross section details, allowing the analysis of stepped or tapered members. The spreadsheet includes a VBA … Continue reading

Posted in AlgLib, Computing - general, Finite Element Analysis, Frame Analysis, Link to dll, Newton, VBA
Tagged AlgLib, Exce, Frame4, Frame4Buckle, installing dlls, VBA
5 Comments

## Showing numerical values of formulae cell references

This post follows from a discussion at Eng-Tips The original question was for a way of displaying the value of each component of an Excel formula. It is easy to display the formula, rather than the result, for all the … Continue reading

Posted in Excel, VBA
Tagged .precedents, display formula reference values, Exce, GetRefs, VBA
9 Comments