Category Archives: Excel

Frame Analysis with Excel – 5; Large frames in Excel 2003

Posted on 05/03/2009 by dougaj4

Continuing from: Frame Analysis with Excel – 4, 2D frame analysis Download Frame2.zip – the download file includes complete open source code. The solution presented in the previous post in this series made use of the Excel built in functions MINVERSE() and … Continue reading →

Posted in Excel, Frame Analysis, Newton, VBA | Tagged , , , | 5 Comments

Importing tab delimited files and clearing large ranges

Posted on 01/03/2009 by dougaj4

Wray Sisk commented on Importing text files with VBA – 3, asking if it could be modified to read tab delimited files. It could be, and has been; download here: Text-in2.ZIP It turned out to be a simple task; just … Continue reading →

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

You can’t count on money

Posted on 28/02/2009 by dougaj4

An interesting bug is reported at Daily Dose of Excel: Code snipit to test If you use a variable of data type currency as a counter in VBA you get some very strange behaviour.  The function below returns the result … Continue reading →

Posted in Excel, VBA | Leave a comment

Happy Birthday Newton Excel Bach

Posted on 21/02/2009 by dougaj4

Newton Excel Bach is one year old today.   To mark the occasion I have downloaded the statistics for number of hits on each post, and pasted them into an Excel worksheet.  The link to each post is preserved in the … Continue reading →

Posted in Bach, Computing - general, Excel, Newton | 3 Comments

IP.xls updated

Posted on 16/02/2009 by dougaj4

The spreadsheet IP.xls has been updated (previous post) with the addition of a function to find the minimum perpendicular distance from a point (or series of points) to a polyline: Pdist =PDist(Line,Points) Line is a range with at least two rows containing … Continue reading →

Posted in Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA | 1 Comment