Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Cubic Splines
- About Newton Excel Bach
- Stereograms
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Contour plots with Excel and Matplotlib
- Drawing in Excel 7 - Creating drawings from coordinates
- Solving non-linear equations with two or more unknowns – 5
- Installing AlgLib with Excel VBA
Recent Comments
Tag Archives: Debugging UDFs
New Tricks …
… or in some cases, old but forgotten tricks. The first comes from a Quora question, asking for the most underutilised feature in Excel. When de-bugging a VBA routine you can set a break point where the code will stop: … Continue reading
Stepping through 3DFrame
Following a recent comment this post looks at the code for setting up the stiffness matrix for a 3D frame, and how to step through any selected part of the code. The general procedure for setting up a 3D stiffness matrix, … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, UDFs, VBA
Tagged 3DFrame, Debugging UDFs, Debuging VBA, Excel, UDF, VBA
Leave a comment