Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- About Newton Excel Bach
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Downloads by category
- Retrieving unique values from a range or array ...
- Downloads
- Latex Maths Text in Excel
- Taming Symbols in Excel
- Daily Download 3: ULS design of reinforced concrete sections
Recent Comments
Category Archives: Newton
Circle Limit III animation
Enjoy: And papers by the artist on how to do it available at: http://bulatov.org/math/1107/ Update 16th Nov 12: Comments and more links from PM2Ring: That image is an example of a tessellation of the hyperbolic plane, in the Poincaré disc … Continue reading
Compiled Matrix Functions for Excel
This is a follow on from the previous post, showing how the C# version of the ALGLIB maths library can be accessed from Excel, with very little additional coding. The download file, Matrixdll-c#.zip includes compiled .dll and .tlb files which can be used … Continue reading
Posted in AlgLib, Arrays, Excel, Finite Element Analysis, Frame Analysis, Link to dll, Maths, Newton, UDFs, VBA
Tagged AlgLib, C++, Eigen values, eigen vectors, Excel, linear equations solver, matrix determinant, Matrix Functions, matrix inverse, sparse solver, UDF, VBA
4 Comments
Polynomial Update
Following a comment here: Solving cubic and quartic equations with Excel the Quartic and CubicC User Defined Functions (UDFs) have been amended to fix a problem occurring with some combinations of coefficients. The updated spreadsheet (including full open source code) can be … Continue reading
Posted in Excel, Maths, Newton, UDFs, VBA
Tagged Cubic, Evaluate polynomial, Excel, Jenkins-Traub, Quartic, Solve polynomial, UDF, VBA
12 Comments
Mohr’s Circle and Plate Stresses and Actions
The functions described in this post can be found in the download file PlateStress.zip, including examples and full open source code. The function MCircle returns the plane stress components (XX, YY and XY stress) for any specified stress field, when rotated through a … Continue reading
Posted in Arrays, Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, UDFs, VBA
Tagged Excel, Gauss Points, Mohr's Circle, Plate stresses, Strand7, UDF, VBA
1 Comment