Category Archives: Excel

Two viewers

Posted on 17/12/2013 by dougaj4

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

Posted on 08/12/2013 by dougaj4

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

Download update – Python downloads

Posted on 08/12/2013 by dougaj4

Download files related to linking to Python from Excel are to be found in: Python matrix functions in Excel, using Pyxll: Download file: http://interactiveds.com.au/software/Matrixpyxll.zip Python for VBA users – 4; Python data types:  The main Python data types, including numpy arrays, with examples … Continue reading →

Posted in Excel, Link to Python, UDFs, VBA | Tagged , , , , , | Leave a comment

Extracting numbers from text strings

Posted on 07/12/2013 by dougaj4

There is often a need to extract numbers from the start or end of text strings.  It’s not too hard to do with on-sheet formulas, but after having done it a few thousand times I decided it would be worth … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , , , , , | 13 Comments

Moving Load Spreadsheet – update and how to use

Posted on 03/12/2013 by dougaj4

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