Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Cubic Splines
- Installing AlgLib with Excel VBA
- About Newton Excel Bach
- Solving non-linear equations with two or more unknowns – 5
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Downloads
- Using Array Functions and UDFs
- Daily Download 4: Continuous Beam Analysis
- The VBA Decimal data type
Recent Comments
Category Archives: Animation
3D plots with the latest Matplotlib
Installing Python on a new computer, I found I had to downgrade Matplotlib to release 3.5.2 to get my 3D plotting functions to work. Further investigation found that the problem was the Axes3D function. Changing: ax = axes3d.Axes3D(fig)to: … Continue reading
Posted in Animation, Coordinate Geometry, Drawing, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, MatPlotlib, Plot 3D images, Python, PyXLL, Rotate 3D images, UDFs
3 Comments
Installing Python and pyxll from scratch
Updated 28th September 2022. Matplotlib latest version OK. I recently installed Python and pyxll (plus the required additional libraries) on a new computer, which raised a few problems with incompatible versions, so here is a summary of what worked (as … Continue reading
Posted in Animation, Arrays, Charts, Coordinate Geometry, Differential Equations, Excel, Finite Element Analysis, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, Python Pandas, PyXLL, UDFs
Tagged Excel, installation, kaleido, MatPlotlib, mpmath, Numba, Numpy, Pint, plotly, PyPardiso, Python, PyXLL, SciPy, sectionproperties, Sympy
1 Comment
Display Matplotlib animations in Excel
The latest version of pyxll (5.4.0) allows animations generated in Matplotlib to be simply copied to Excel. A spreadsheet with the examples shown below, and the associated Python code can be downloaded from: Animations2.zip The screenshot below shows the simple … Continue reading
Posted in Animation, Drawing, Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged animation, Excel, Mandelbrot animation, Mandelbrot Set, MatPlotlib, Python, PyXLL, UDFs
2 Comments
Animations from VBA
A convenient way to create an animation in Excel is to create on-sheet formulas or user defined functions to generate the required data, then use VBA to iterate through the range of input values so that the chart or image … Continue reading
Posted in Animation, Excel, Link to Python, Maths, Newton, PyXLL, UDFs, VBA
Tagged animation, Excel, Mandelbrot animation, Sleep function, smallscroll, VBA
1 Comment
Building dances to an earthquake’s beat
Adam Pascale from the Seismology Research Centre recently shared this animation (click on controls bottom right for High Quality and Full Screen views): … it’s from a building in the Philippines about 130km (hypocentral distance) from a magnitude 6.1 earthquake … Continue reading
Posted in Animation, Computing - general, Newton
Tagged Earthquake animation, Seismology Research Centre
Leave a comment