Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Cubic Splines
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Frame Analysis with Excel - 3, Continuous beam or frame
- Linking Excel to C - 2
- Writing Arrays to the worksheet - VBA function
- Frame Analysis with Excel – 7; Shear deflections and support displacements
- Daily Download 4: Continuous Beam Analysis
- Fitting high order polynomials
- RCInteract and RC Design Functions 7.03
Recent Comments
Category Archives: Newton
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
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
Non linear regression – 2; ALGLIB functions
The previous post looked at using the Excel Solver to fit a non-linear equation to a given set of data, using the least squares method. This approach is reasonably convenient and straightforward, but it has a number of disadvantages: The … Continue reading
Posted in AlgLib, Concrete, Excel, Maths, Newton, UDFs, VBA
Tagged AlgLib, Excel, Least Squares fit, non-linear regression, UDF, VBA
8 Comments
Non linear regression – 1
Recent posts have described how to fit linear equations (or equations that can be made linear) to a set of data, using the Excel Linest functions, or User Defined Functions (UDF’s) linking to the ALGLIB library (see Using LINEST for non-linear … Continue reading
Posted in AlgLib, Concrete, Excel, Maths, Newton
Tagged AlgLib, Excel, non-linear regression, Solver
6 Comments