Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- 2DFrame-py
- Using LINEST for non-linear curve fitting
- Downloads
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Biaxial bending update
- Cubic Splines
- Automatic download of csv files
- XLDennis, the MSDN Library, and VBA rant
- The history of the theory of beam bending - Part 3
Recent Comments
Category Archives: Newton
Two viewers
I have previously looked at using Excel for generation of images from data listing 3D coordinates of points and lists of connections (see https://newtonexcelbach.wordpress.com/2012/09/27/daily-download-11-perspective-projection/ for instance), but this approach is limited in what can be done: It will only generate a “wire-frame” … Continue reading
Posted in Animation, Computing - general, Finite Element Analysis, Newton
Tagged Graphic viewers, Kiwi Viewer, Paraview
Leave a comment
Download update 2
I have updated the Downloads spreadsheet on Skydrive to include all new files added this year, and I have also added two Category columns, which link to the Download by Category page, giving more details and links for each file. … Continue reading
Posted in Computing - general, Excel, Newton, UDFs, VBA
Tagged Downloads, Excel, Skydrive, VBA
Leave a comment
Moving Load Spreadsheet – update and how to use
As noted in the comments on the previous post on this topic, the moving load function (and also the associated continuous beam functions) have been modified to make data entry more flexible; the output results are unchanged. The modified spreadsheet … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged ConBeamU, continuous beam, Excel, Macaulay's Method, moving load, Solver, UDF, unit aware, VBA
7 Comments
Continuous Beam spreadsheet with moving load
I have added a moving load function to the ConBeamU spreadsheet, allowing maximum load actions and deflections to be determined in a continuous beam under the influence of a vehicle defined by a number of point loads. The new version … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
17 Comments
Unit aware continuous beam spreadsheet update
The ConbeamU spreadsheet provides Excel user defined functions (UDFs) for the analysis of continuous and simply supported beams and cantilevers using Macaulay’s method. It allows complex combinations of any number of partial distributed loads, point loads and moments, with changes … Continue reading
Posted in Beam Bending, Excel, Frame Analysis, Newton, UDFs, VBA
Tagged continuous beam analysis, Excel, Macaulay's Method, moment restraint, spring supports, UDF, unit aware, VBA
1 Comment