Tag Archives: Excel

Another update to IP.xls

Posted on 07/04/2009 by dougaj4

Following some suggestions from Mike Seymour I have modified my polyline intersection function, and added a new version. The changes are: The data ranges for the new function, IP4(), are entered as four separate ranges, so the X and Y … Continue reading →

Posted in Excel, Maths, UDFs, VBA | Tagged , , , , | 1 Comment

Evaluate integrals to a specified tolerance

Posted on 10/03/2009 by dougaj4

A previous post presented a user defined function (UDF) to perform a numerical integration of a function specified as a text string.  The UDF allowed the number of subdivisions of the integration range to be specified, but the number of subdivisions required to … Continue reading →

Posted in Excel, Maths, Newton, UDFs | Tagged , , , , , | 2 Comments

Splitters!

Posted on 07/03/2009 by dougaj4

A recent post on the Tek-Tips VBA forum reminded me that VBA has a split function, which will split a string into sub-strings at any specified character (such as a space).  D’oh I thought, why did I waste my time writing … Continue reading →

Posted in Excel, UDFs, VBA | Tagged , , | Leave a comment

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