Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- XLDennis, the MSDN Library, and VBA rant
- Latex Maths Text in Excel
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Cubic Splines
- Filling Blanks with Go To-Special (and local help rant)
- Using LINEST for non-linear curve fitting
- Retrieving unique values from a range or array ...
- Contour plots with Excel and Matplotlib
- Frame Analysis with Excel
- The angle between two vectors, Python version
Recent Comments
Category Archives: Maths
The roof of the Taq-i-Kisra; Analysis
Following the previous post, I have compared the stresses in the Taq-i-Kisra assuming either a catenary or parabolic profile. I have also compared constant depth sections with sections increasing in depth towards the supports. The arch span was taken as … Continue reading
Posted in Arch structures, Finite Element Analysis, Maths, Newton
Tagged analysis, arch, Catenary, finite elemnt analysis, parabola, Taq-i-Kisra
2 Comments
Elegant Proofs – 1
Roger Penrose in his book “The Road to Reality” gives a remarkably simple proof of Pythagoras’ Theorem: Drawing a perpendicular to the hypotenuse from the right angle (line CD) will divide any right angled triangle into two similar triangles, both … Continue reading
Posted in Maths, Newton
Tagged Penrose, Pythagoras, Road to Reality, similar triangles
Leave a comment
Evaluate Function
It would often be convenient to evaluate a function entered as text; for instance if we have the function for the deflection of a cantilever under point loading at the end: F*L^3/(3*E*I) then it would be convenient to be able … Continue reading
Section Properties of Defined Shapes – Spreadsheet
Download section properties spreadsheet from: http://www.interactiveds.com.au/software/Section%20Properties03.zip http://www.interactiveds.com.au/software/Section%20Properties07.zip Section properties for 35 defined shapes Section properties from coordinates Section properties UDF Screen shots:
Posted in Excel, Maths, UDFs
Tagged Section Properties; Area; First Moment of Area; Second
29 Comments
Section Properties from Layers
An alternative to finding the section properties of irregular polygons from the coordinates of the corners is to divide the shape into rectangular or trapezoidal layers. The properties of the shape may then be found by simply summing the properties … Continue reading
Posted in Maths, Newton, Uncategorized
Tagged Area, first moment of area, layers, second moment of area, section properties
1 Comment