Category Archives: Excel

Charting a Mathematical Function with Defined Names

Posted on 15/12/2010 by dougaj4

This post is a compilation of information from Stephen Bullen, Jan Karel Pieterse, and George Lungu.  To quote JKP “When doing mathematics, wouldn’t it be nice if we could type an equation into a cell in Excel and immediately see … Continue reading →

Posted in Arrays, Charts, Excel, Maths | Tagged , , , , | 7 Comments

More on the Excel Evaluate function

Posted on 14/12/2010 by dougaj4

Previous posts have presented the Eval() User Defined Function, using the Evaluate function in VBA to evaluate mathematical functions displayed as text (Evaluate Function, Evaluate Function – Update).  It was recently pointed out by Jeff Weir that the Evaluate function has its origins … Continue reading →

Posted in Excel, Newton, Numerical integration, UDFs, VBA | Tagged , , , , , , , | 4 Comments

Interpolation Update

Posted on 07/12/2010 by dougaj4

The interpolation functions in IP2.xls have been given an overhaul: The linear and quadratic interpolations routines have been modified to accept negative values. All the routines have been modified to convert the table range to an array, rather than using a … Continue reading →

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , , | 4 Comments

Maximum distance between two points

Posted on 27/11/2010 by dougaj4

I have just written a short User Defined Function (UDF) to find the maximum distance between any two points from a list of coordinates, and since it may be useful to others, I will post it here.  Here is the … Continue reading →

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

New Excel Engineering Blog

Posted on 26/11/2010 by dougaj4

I just found Excel Unusual, which has been going since September this year.  Here’s what the Author says: “Finding engineering work quite un-challenging lately I decided to start this blog in which to share cool ways of solving engineering problems or … Continue reading →

Posted in Animation, Excel, Newton | Tagged , , , , | 13 Comments