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 , , , , , | 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 , , | 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 , , , | 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 , , , , , , , , | 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