Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Cubic Splines
- About Newton Excel Bach
- XLDennis, the MSDN Library, and VBA rant
- Filling Blanks with Go To-Special (and local help rant)
- Downloads
- Frame Analysis with Excel - 3, Continuous beam or frame
- Writing Arrays to the worksheet - VBA function
- Linking Excel to C - 2
Recent Comments
Category Archives: Maths
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
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