Recent Comments
dougaj4 on Biaxial bending update 
DonB on Biaxial bending update dougaj4 on Biaxial bending update DonB on Biaxial bending update DonB on Biaxial bending update 
Perko on Installing Adobe Reader non-DC… Python Traps | Newto… on The meaning of = in Pytho… dougaj4 on P-Y Curve function 
Zhitong Zhang on P-Y Curve function 
Matt Cornell on Newton’s Cradle Clive James and Pete… on The Barrow Poets dougaj4 on Excel to Alglib via xlwin… Roulior Halder on Excel to Alglib via xlwin… dougaj4 on Excel to Alglib via xlwin… dougaj4 on Excel to Alglib via xlwin…
Category Archives: Drawing
Plotting Mandelbrot
There are many sites discussing the Mandelbrot Set, but not many examples using VBA to plot the set in Excel, so here is my effort: The spreadsheet (including open source VBA code) may be downloaded from: Mandelbrot chart.zip Note that … Continue reading
Posted in Charts, Charts, Coordinate Geometry, Drawing, Excel, Maths, Newton, VBA
Tagged Charts, Excel, Mandelbrot Set, VBA
3 Comments
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
