Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- About Newton Excel Bach
- Filling Blanks with Go To-Special (and local help rant)
- XLDennis, the MSDN Library, and VBA rant
- Downloads
- Daily Download 5: Frame Analysis
- Writing Arrays to the worksheet - VBA function
- The history of the theory of beam bending - Part 1
Recent Comments
Author Archives: dougaj4
3DFrame with spring releases
Following the previous post I have added similar functionality to the 3DFrame spreadsheet. The new file can be downloaded from: 3DFrame.zip As before, see Installing C# dll files, reminder for details of installing the supplied dll files, which provide much better … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, VBA
Tagged 3D frame analysis, Excel. VBA, moment release, spring end release, Strand7
8 Comments
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
Can you spare a dime
I enjoyed this rendition of a classic song by Martin Simpson: I also enjoyed this comment: daniel gorney1 year ago Bravo. A very fine rendition. My daddy, Jay Gorney, who wrote the music, would have enjoyed it as much as … Continue reading
More on Lookups
Following my recent post on nearest lookups, I came across a post from Charles Williams on the opposite problem; how to do an exact VLookup on a large amount of data without taking all day, but still retaining the ability to return … Continue reading
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