Category Archives: Drawing

Section Properties – Lunes and Groups

Following a discussion at Eng-Tips and resulting comments I have updated my Section Properties spreadsheet to include calculation of the area and centroid of a “Lune” (the shape of a crescent moon).  I have also added a “Re-draw Shape” button because … Continue reading

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

“Yields circularity when preceded by its quoation” …

yields circularity when preceded by its quotation. Today’s post takes us on a little circular tour of the internet, starting with: Grumpy Old Programmer (Mike Woodhouse) who returns from a long holiday from blogging to publish a nice little routine … Continue reading

Posted in Computing - general, Drawing, Newton | Tagged , , , , , | Leave a comment

Daily Download 20: Section Properties

The download spreadsheets today provide functions to find section properties of shapes either defined by coordinates or selected from a list of shape types.  The section properties found are: area, first and second moments of area about the X and Y … Continue reading

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

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