Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Commenting a block of code in VBA
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Retrieving unique values from a range or array ...
- Using Goal Seek on Multiple Cells
- Downloads by category
- Deflections and Moments in Rectangular Plates
- Fitting high order polynomials
Recent Comments
Category Archives: Animation
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
1 Comment
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
Dancing Pendulums Revisited
I have previously posted on Dynamically Defined Dancing Pendulums, using the Strand7 FEA program to generate the motion of a series of pendulums of varying length. I have now updated that video using the latest Beta version of the program (Rel … Continue reading
Posted in Animation, Finite Element Analysis, Frame Analysis, Newton, Strand7
Tagged avi, dynamic analysis, mp4, Pendulum animation, Snagit, Strand7
Leave a comment
Arcs and arc-splines
I have added two user defined functions (UDFs) to the IP2 spreadsheet to generate coordinates for a single arc, or a series of arcs connected (if necessary) by straight lines. The new version may be downloaded from: IP2.zip As an example … Continue reading