Category Archives: Drawing

Daily Download 16: Intersections, interpolations, and rotations

There is only one download file today: http://interactiveds.com.au/software/IP2.ZIP , but it contains a wealth of different functions dealing with 2D and 3D geometry, including intersections of lines, circles and spheres, simple interpolation functions, and functions for rotating points in 2D … Continue reading

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

Daily Download 11: Perspective Projection

The last of the daily downloads dealing with drawing is an extension of the drawing spreadsheet providing 3D perspective projection of wireframes defined by lists of 3D coordinates and connected points.  The spreadsheet was described in:Drawing in Excel 9 – … Continue reading

Posted in Drawing, Excel, VBA | 1 Comment

Daily Download 10: Excel Digitiser

See How to digitise a scanned image and Digitising logarithmic scales.  This spreadsheet provides a function to retrieve coordinates of lines traced over a scanned image. Download from: http://interactiveds.com.au/software/DigitGraph.zip Example images:

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

Daily Download 8: Drawing in Excel

Today’s download includes all download files and posts relating to drawing in Excel, other than those dealing with animation, digitising, or 3D perspective projection, which will be covered in the next three days. Blog posts dealing with drawing in Excel: … Continue reading

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

PView Function

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

Revision to CSpline2.xls

It was recently reported to me that the cubic spline spreadsheet CSpline2.xls (posted here) was crashing on loading in Excel 2003.  It seems that the problem was with the ChartSpline function, and that there are no problems if this function is … Continue reading

Posted in Drawing, Excel, Maths, UDFs, VBA | Tagged , , | 6 Comments

Faster Ferns

I have modified the fern input parameters in the spreadsheet presented in the previous post to match the layout used by Barnsley and others, so that examples such as those given at the Wikipedia article can be entered directly.  The … Continue reading

Posted in Arrays, Charts, Charts, Drawing, Excel, Maths, Newton, VBA | Tagged , , , | 4 Comments