Recent Comments
Author Archives: dougaj4
3D Intersections
Following a discussion at the Eng-Tips Forum, I have written an Excel User Defined Function (UDF) to find the intersection point of two 3D line segments. The UDF has been added to the IP2 spreadsheet, which is available for free … Continue reading
Posted in Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA
Tagged 3D lines, Excel, Intersection Points, UDF, VBA
7 Comments
Laterally Loaded Piles and a Safety Device for Walking on Icy Pavements
What do laterally loaded piles: and a safety device for walking on icy pavements: have in common? Apart from their obvious utility, both are the subject of learned papers, freely available at the Virginia Tech Digital Library and Archives, along … Continue reading
More links
One of the nice things about running a blog is that visitors leave the address of the site that lead them here, and if you follow these links back it sometimes takes you to fascinating sites that you would never … Continue reading
XNumbers and Tropical Events
My on-line friend Al Vachris recently sent me a link to the Tropical Events site, which features a detailed analysis of the orbital motion of the Earth and the other bodies of the solar system, all done in Excel, and … Continue reading
Posted in Excel, Maths, Newton, Numerical integration
Tagged Astronomy, Numerical methods, orbital mechanics, XNumbers
16 Comments
Double Exponential Quadrature
Graeme Dennes has updated his Tanh-Sinh Quadrature spreadsheet to include Double Exponential Quadrature. His brief notes are given below, and more details and links to background information are included in the download file. ================================================================= Double Exponential Quadrature UDFs added to Tanh-Sinh Quadrature … Continue reading
Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged Double exponential quadrature, Excel, numerical integration, Tanh-Sinh method, UDF, VBA
1 Comment
