Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- XLDennis, the MSDN Library, and VBA rant
- About Newton Excel Bach
- Filling Blanks with Go To-Special (and local help rant)
- Cubic Splines
- Writing Arrays to the worksheet - VBA function
- Frame Analysis with Excel - 3, Continuous beam or frame
- Downloads
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
Recent Comments
Category Archives: Newton
Elegant proofs 2 – The area of a circle
We are so familiar with the formula for the area enclosed by a circle that we tend not to think much about how it was derived, at least I don’t. The proofs of the formula are in fact many and … Continue reading
Pythagoras, Penrose and Pov-Ray
Images based on Pythagorean tiling, Penrose tiling, and projections onto the Riemann Sphere by PM2ring, a regular contributor to the ABC Self-Service Science Forum (words by the artist): Various renderings of a Pythagorean tiling. Mostly using the 3,4,5 triangle. This … Continue reading
Irish Graffiti
On the 16th October 1843 the Irish mathematician William Hamilton was taking a walk with his wife, alongside the Royal Canal in Dublin, when the answer to a problem that he had been puzzling over came to him, and he … Continue reading
Posted in Arch structures, Maths, Newton
Tagged Brougham Bridge, Irish Graffiti, John Baez
Leave a comment
Drawing in Excel – 2
Before getting down to basics, the attached file: Animation demo Illustrates how Excel shapes can be simply animated. Screen shot: The code for the animation (having previously drawn a circle and a rectangle with no fill, and noted their names): … Continue reading
Reinforced Concrete Section Analysis – 4
Previous post The spreadsheet presented in the previous post in this series uses the basic equation given below to find the location of the neutral axis: For a cross section with any applied axial load at eccentricity e, measured from … Continue reading
Posted in Beam Bending, Excel, Newton, UDFs, Uncategorized
Tagged Polynomial, Reinforced Concrete, Section Analysis, UDF, VBA
1 Comment