Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Cubic Splines
- Downloads
- About Newton Excel Bach
- XLDennis, the MSDN Library, and VBA rant
- Daily Download 4: Continuous Beam Analysis
- Frame Analysis with Excel – 7; Shear deflections and support displacements
- Automatic download of csv files
- Linking Excel to C
Recent Comments
Tag Archives: Frame Analysis
Extending Frame4 with on sheet formulas
Still on Frame4, Julien asked if provision could be made for application of local loads, i.e. loads perpendicular to sloping members, rather than just horizontal or vertical. This will actually be incorporated in the spreadsheet “real soon now”, but it … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, VBA
Tagged Excel, Frame Analysis, Frame4 spreadsheet, local loads, VBA
3 Comments
Frame4 Version 3.05; with support displacements
Hot on the heels of Version 3.04 comes Version 3.05. A few days ago Julien asked if the Frame4 allowed for specified support deflections, to which I replied it would be added in the future. Searching Google on the topic I … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, VBA
Tagged C# matrix functions, Excel, Frame Analysis, link to dll, VBA
7 Comments
Frame4 Version 3.04
In preparation for adding 3D functionality to the Frame4 spreadsheet I have rearranged the load input sheet, and in doing so I noticed that the fixed end reaction calculation was incorrect for cases where loads were applied to one member over … Continue reading
Posted in Excel, Finite Element Analysis, Frame Analysis, Link to dll, Newton, VBA
Tagged C# matrix functions, Excel, Frame Analysis, link to dll, VBA
1 Comment
Frame4; now with added Alglib
Edit 29 Nov 2012: I have now added an xls version to the download zip file. This also has a much smaller example model, which will solve quickly using the VBA solver, so will be more useable for anyone having … Continue reading
Posted in AlgLib, Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to dll, Newton, UDFs, VBA
Tagged C# matrix functions, column buckling, Excel, Frame Analysis, link to dll, VBA
24 Comments
Daily Download 5: Frame Analysis
Leading on from yesterday’s continuous beam functions, today’s download covers four frame analysis spreadsheets, with increasing levels of complexity. For those interested in the workings of the program I recommend working through each spreadsheet, but for practical applications the final … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Newton, UDFs, VBA
Tagged Excel, Frame Analysis, UDF, VBA
12 Comments