Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Using LinEst() on data with gaps
- Continuous Beams With Spring Supports by Macaulay’s Method
- ULS Design Functions 2.13
- About Newton Excel Bach
- Intersections, interpolations, and rotations
- Buckling of columns with varying cross section
- Fitting high order polynomials
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
Recent Comments
Tag Archives: XNumbers
The VBA Decimal data type
This is what the Microsoft on-line help says about using the Decimal data type in VBA “” At least that is what the Microsoft search listed for me, and Google listed nothing from Microsoft related to VBA on the first … Continue reading
Posted in Excel, Maths, Newton, UDFs, VBA
Tagged Decimal data type, high precision math functions, VB and VBA differences, XNumbers
4 Comments
Rabbits, Foxes, and Lorenz Attractors
Following comments here and here I have added two examples to the ODE Solver spreadsheet showing use of the ODE function to solve systems of differential equations with two or more coupled equations. The new version (including full open source … Continue reading
Posted in AlgLib, Differential Equations, Excel, Maths, Newton, UDFs, VBA
Tagged AlgLib, Excel, Lorenz Attractor, Predator-Prey, Solution of ODEs, Systems of ODEs, UDF, VBA, XNumbers
2 Comments
Precise Angles and XNumbers
Further to comments by Georg under: The angle between two vectors, in 2D or 3D I have added four alternative ways of calculating the angle between two 3D vectors to the VectorFunc spreadsheet. The new version can be downloaded from: http://interactiveds.com.au/software/VectorFunc.xlsb. … 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