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
- About Newton Excel Bach
- XLDennis, the MSDN Library, and VBA rant
- Downloads
- Filling Blanks with Go To-Special (and local help rant)
- Linking Excel to C - 2
- RCInteract and RC Design Functions 7.03
- Frame Analysis with Excel - 3, Continuous beam or frame
Recent Comments
Author Archives: dougaj4
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
Automating chart scale limits – update
I wrote about this function 2 1/2 years ago, and promptly forgot about it, but a few days ago brian provided an answer to a question that was raised shortly after it was first posted, concerning how to apply the function … Continue reading
Posted in Charts, Excel, UDFs, VBA
Tagged Excel, plot function, set chart scale, UDF, VBA
13 Comments
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
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