Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Time in hours and minutes between two dates
- Using LINEST for non-linear curve fitting
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Cubic Splines
- The history of the theory of beam bending - Part 1
- Downloads
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Fitting high order polynomials
Recent Comments
Elastic Biaxial Bend… on Biaxial bending update Bill Harvey on Floating Point Precision … Floating Point Preci… on When does 35 not equal 35… dougaj4 on mpmath for Excel dougaj4 on mpmath for Excel Kapt Blasto on mpmath for Excel mktisis on 3D Frame with zero stiffness… dougaj4 on 3D Frame with zero stiffness… dougaj4 on 3D Frame with zero stiffness… mktisis on 3D Frame with zero stiffness… th3budd on Time in hours and minutes betw… dougaj4 on Moving Load Spreadsheet… Ario on Moving Load Spreadsheet… dougaj4 on About Newton Excel Bach David Graves on About Newton Excel Bach
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