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
- XLDennis, the MSDN Library, and VBA rant
- About Newton Excel Bach
- 3DFrame - 3D Frame analysis for Excel
- Filling Blanks with Go To-Special (and local help rant)
- Downloads
- Writing Arrays to the worksheet - VBA function
- Automatic download of csv files
Recent Comments
Category Archives: Newton
Python for VBA users- 7; Making Python go Faster
As reported in the previous post in this series, although the compiled routines included in packages such as Numpy, Scipy, and Pysparse are very fast, other parts of the code turned out to be slower than the equivalent in VBA. … Continue reading
Posted in Arrays, Excel, Finite Element Analysis, Frame Analysis, Link to Python, Newton, NumPy and SciPy, UDFs, VBA
Tagged Excel, Frame Analysis, PYsparse, Python, sparse matrices. Numba, VBA
Leave a comment
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