Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
Recent Comments
Category Archives: Strand7
ConbeamU Update Update
Following some comments from 4Step on the last ConbeamU update, and a thorough check of results against Strand7 results, I have posted a new version that fixes a number of issues with the previous one. The new version number is … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, Strand7, UDFs, VBA
Tagged ConBeamU, continuous beam analysis, Excel, Strand7, UDF, VBA
4 Comments
Global to Local for plates (and three node beams)
The Glob_to_Loc function (see Converting from global to local coordinates (and vice versa) ) converts forces and deflections of a beam from the global coordinate system to the local system, defined by the longitudinal axis of the beam and a rotation angle … Continue reading
Posted in Coordinate Geometry, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Maths, Newton, Strand7, UDFs, VBA
Tagged Excel, Glob_to_Loc3, IP2.xls, Loc_to_Glob3, Python, PyXLL, UDF, VBA
3 Comments
Beam actions and deflections, 3D or 2D
Two new functions have been added to the ConBeamU spreadsheet, last discussed here. The new version can be downloaded from ConBeamU.zip, including full open-source code. The new functions, BeamAct3D and BeamAct2D calculate forces, moments, deflections and rotations along a 3D … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, Strand7, UDFs, VBA
Tagged 2D beam, 3D beam, beam analysis, BeamAct functions, Excel, UDF, VBA
2 Comments
3DFrame – 3D Frame analysis for Excel
I have now extended the Frame4 spreadsheet to deal with 3D frames. As well as making the necessary changes to the input ranges and stiffness matrix generation routines I have revised the Sparse solver routine, added a new compiled solver, and … Continue reading
Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to dll, Newton, Strand7, VBA
Tagged 3D frame analysis, Excel, sparse solver, Spreadsheet frame analysis, VBA
21 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