Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Commenting a block of code in VBA
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Arrays vs Collections vs Dictionary Objects (and Dictionary help)
- Cubic Splines
- Using Goal Seek on Multiple Cells
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Fitting high order polynomials
- Using LINEST for non-linear curve fitting
- Beam actions and deflections by Macaulay's Method
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
Leave a comment
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