Recent Comments
dougaj4 on Beam actions and deflections b… Stephen Ward on Beam actions and deflections b… dougaj4 on Beam actions and deflections b… Steve Ward on Beam actions and deflections b… dougaj4 on Using Goal Seek on Multiple… Using Goal Seek on a… on Using Goal Seek on Multiple… John Pollard on Using Goal Seek on Multiple… Using RC Design Func… on Using RC Design Functions… dougaj4 on Using RC Design Functions… Omar Khan on 5 Year Report hadwao on Using RC Design Functions… dougaj4 on Using RC Design Functions… hadwao on Using RC Design Functions… Marina Lindon on More from the Low Countri… China Amazing Archit… on World’s Largest Natural…
Category Archives: Drawing
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 Excel, Section Properties; Area; First Moment of Area; Second Moment of Area, UDF, VBA, vectors
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 Excel, interpolations, intersections, perspective projection, polar coordinates, rotations, UDF, VBA
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
Leave a 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 DigitGraph, digitize scanned image, Excel, UDF, VBA
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
