Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Using LinEst() on data with gaps
- Continuous Beams With Spring Supports by Macaulay’s Method
- ULS Design Functions 2.13
- About Newton Excel Bach
- Intersections, interpolations, and rotations
- Buckling of columns with varying cross section
- Fitting high order polynomials
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
Recent Comments
Category Archives: Link to dll
64 bit Excel and the Strand7 API
Back in May 2017 I posted a sample spreadsheet using the Strand7 API to allow Excel to read and write Strand7 node data and results. A comment noted at the time that the spreadsheet was not working with 64 bit … Continue reading
Posted in Excel, Finite Element Analysis, Frame Analysis, Link to dll, Newton, Strand7
Tagged 64 bit Excel, Strand7 API
Leave a comment
Installing Frame4 and 3DFrame
Following a recent comment I have added a VBA only version to the download files of the frame analysis spreadsheets: 3DFrame.zip Frame4.zip The VBA versions should work on any version of Excel from 2007, with macros enabled, without any further installation. The … Continue reading
Posted in AlgLib, Excel, Frame Analysis, Link to dll, Newton, VBA
Tagged 3D frame analysis, 3DFrame, Excel, Frame Analysis, Frame4, link to dll, VBA
1 Comment
February Links
Two new links with valuable free resources: .net and office automation follies : including many advanced VBA resources. Thanks to Alfred Vachris for the link. AET VBE Tools : Tools for the Visual Basic editor from Andrew Engwirda (via Daily Dose of … Continue reading
Frame analysis with spring releases; 2D
I have updated the Frame4 spreadsheet to allow a rotational spring stiffness to be specified for members with a rotational end release. The new file can be downloaded from: Frame4.zip See Installing C# dll files, reminder for details of installing the … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to dll, Newton, Strand7, VBA
Tagged Excel. VBA, Frame Analysis, moment release, spring hinges, Strand7
1 Comment
Installing C# dll files, reminder
Installing the Frame4 spreadsheet on a new computer I had some problems registering the dll files required for the compiled solver routines, so here is a reminder of the procedure: Copy the alglibnet2.dll and ALMatrixLib.dll files to the appropriate folder (see … Continue reading