Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- About Newton Excel Bach
- Daily Download 5: Frame Analysis
- Downloads
- Cubic Splines
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Deflections and Moments in Rectangular Plates
- Writing Arrays to the worksheet - VBA function
- Contour plots with Excel and Matplotlib
Recent Comments
Category Archives: Drawing
“Yields circularity when preceded by its quotation” …
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 Computer Quine, Douglas Hofstadter, Golfed code, Illusion, MU, Quine
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 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
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