### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- The angle between two vectors, Python version
- Cubic Splines
- Downloads by category
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using LINEST for non-linear curve fitting
- Drawing in Excel 7 - Creating drawings from coordinates
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Fitting high order polynomials

### Recent Comments

Peak Warming Man on Australian Greenhouse Gas… AS 3600 and RC Desig… on New AS 3600 and RC Design Func… dougaj4 on Brent’s Method and a daf… Craig on Brent’s Method and a daf… Craig on Brent’s Method and a daf… dougaj4 on Solving Quadratic, Cubic, Quar… brian on Solving Quadratic, Cubic, Quar… brian on Solving Quadratic, Cubic, Quar… metroxx on Using Section Properties-… dougaj4 on Using Section Properties-… More iterative solve… on Iterative solvers and arr… metroxx on Using Section Properties-… Craig on Arc-spline update dougaj4 on Arc-spline update Craig on Arc-spline update

# Category Archives: Drawing

## Arcs and arc-splines

I have added two user defined functions (UDFs) to the IP2 spreadsheet to generate coordinates for a single arc, or a series of arcs connected (if necessary) by straight lines. The new version may be downloaded from: IP2.zip As an example … Continue reading

## More Python rotation functions

The code described in the previous post includes a Python function that rotates 3D coordinates by an angle defined with two vectors, using Rodrigue’s Rotation. I have now added this function to the IP2_py spreadsheet, where it is used in the … Continue reading

Posted in Coordinate Geometry, Drawing, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings
Tagged Excel, fit 3D circle, Numpy, Python, RPView, UDF, VBA, xlwings, xl_RPView
Leave a comment

## Use Matplotlib from Excel with xlwings

Xlwings is another free and open source package allowing communication between Excel and Python. It now incorporates ExcelPython, and is included in the Anaconda Python package, so will support my ExcelPython based spreadsheets after installation of xlwings using: conda install … Continue reading

Posted in Drawing, Excel, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, VBA
Tagged Excel, ExcelPython, link Excel to Python, MatPlotlib, Python, VBA, xlwings
8 Comments

## 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 Excel, group properties, Lune, section properties, VBA
2 Comments

## “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