Category Archives: Maths

Dots and Crosses

Posted on 21/08/2011 by dougaj4

The comments from Bill Harvey in the previous post prompted me to have a closer look at the functions available in Excel for working with vectors.  Here is a complete list of them: =SUMPRODUCT() (Equivalent to the vector dot product) This … Continue reading →

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

PaulBourke.net

Posted on 23/07/2011 by dougaj4

Another link from Al Vachris: PaulBourke.net. The link above has a general subject index, and google site search; for a full list of the site content go to the detailed site index. Here’s what the author says about it: “The … Continue reading →

Posted in Computing - general, Coordinate Geometry, Maths, Newton, Ray Tracing | Tagged , , , | Leave a comment

Rotating Hypercubes

Posted on 25/06/2011 by dougaj4

The discussion of dancing pendulums in javascript at SSSF led onto Rotating Hypercubes, which resulted in this javascript animation by forum regular mollwollfumble: 4D Rotations (click to view in a new window, right click to download javascript file) See the SSSF thread for discussion on … Continue reading →

Posted in Animation, Maths, Newton | Tagged , , , | 5 Comments

Tanh-Sinh Quadrature V2.0

Posted on 04/04/2011 by dougaj4

I recently received an update of the Tanh-Sinh Quadrature spreadsheet from Graeme Dennes, which can be downloaded from:  Tanh-Sinh Quadrature (including, as usual, full open source code). – Link fixed 5th April 2011 Here is Graeme’s description of the updates: The … Continue reading →

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

PView Function

Posted on 31/03/2011 by dougaj4

As promised in the previous post, here are further details of the PView User Defined Function (UDF), included in the IP2 spreadsheet, which can be downloaded (including full open source code) from IP2.ZIP. The PView UDF works by multiplying the 3D … Continue reading →

Posted in Arrays, Charts, Charts, Coordinate Geometry, Drawing, Excel, Maths, UDFs, VBA | Tagged , , , , , , | 3 Comments