Author Archives: dougaj4

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

Download update – Python downloads

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

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

1 Million Page Views

At some time in the next couple of hours or so the number of page views here will pass the 1 million mark, so congratulations in advance one millionth page viewer. I thought it would be interesting to see where … Continue reading

Posted in Computing - general | Tagged , | 3 Comments