Category Archives: UDFs

Precise Angles and XNumbers

Posted on 28/01/2013 by dougaj4

Further to comments by Georg under: The angle between two vectors, in 2D or 3D I have added four alternative ways of calculating the angle between two 3D vectors to the VectorFunc spreadsheet.  The new version can be downloaded from: http://interactiveds.com.au/software/VectorFunc.xlsb. … Continue reading →

Posted in Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , | Leave a comment

Charts and Charting

Posted on 27/01/2013 by dougaj4

I don’t do a lot on Excel charts because there are already a number of excellent blogs and sites that specialise in that area; notably: Peltier Tech Blog but after compiling my “Downloads by Category” page I found that I … Continue reading →

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

New Page

Posted on 26/01/2013 by dougaj4

In an effort to make the information on this site easier to access I have collected all the “Daily Download” posts from last year onto a new page, listing each of the download posts by category. It’s called “Download by … Continue reading →

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

Extracting a hyperlink

Posted on 21/01/2013 by dougaj4

Excel does not have a function to extract the address from a cell containing a hyperlink.  Here is a short UDF that will do the job: The original was a one-liner posted by Rick Rosthstein on Debra Dalgleish’s Contextures Blog.  I … Continue reading →

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

The angle between two vectors, in 2D or 3D

Posted on 12/01/2013 by dougaj4

Finding the angle between two lines in 2D is easy, just find the angle of each line with the x-axis from the slope of the line and take the difference.  In 3D it is not so obvious, but it can … Continue reading →

Posted in Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , , | 9 Comments