Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Commenting a block of code in VBA
- Arrays vs Collections vs Dictionary Objects (and Dictionary help)
- Cubic Splines
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Using LINEST for non-linear curve fitting
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Using Goal Seek on Multiple Cells
- Fitting high order polynomials
- SectionProperties update
Recent Comments
Category Archives: Maths
VBA procedures for the Numerical Analysis of Tabular Functions
Long time on-line friend Alfred Vachris has recently been converting Fortran code developed through his working career into VBA: I had the opportunity to work at Grumman while going to Graduate School and they gave me a part-time job as … Continue reading
Posted in Coordinate Geometry, Curve fitting, Excel, Fortran, Maths, Newton, UDFs, VBA
Tagged Aitken Graphical Construction, Alfred Vachris, Arc Length, Excel, Interpolation, Tabular Functions, VBA
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
1 Comment
Rounding to significant figures
Edited 19th Feb 22, following comment from Larry Schuster Excel does not have a function to round numbers to a specified number of significant numbers, and (rather to my surprise) neither does Python. It is not too hard to write … Continue reading
Posted in Excel, Link to Python, Maths, NumPy and SciPy, PyXLL, UDFs, VBA
Tagged Excel, Python, PyXLL, Round, Significant figures, UDF, VBA
7 Comments
SectionProperties update 3
The SectionProperties spreadsheets previously posted had limited graphics capabilities due to problems with the plotting routines causing Excel to crash. I have now fixed that problem by updating some Python libraries with pip: installing mkl-service numpy 1.21.2 -> 1.22.1 Pillow … Continue reading
Posted in Beam Bending, Charts, Charts, Coordinate Geometry, Excel, Finite Element Analysis, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL
Tagged Excel, Python, PyXLL, Section-Properties, Torsion, Warping
1 Comment
Plotting Mandelbrot in Excel with Matplotlib
The functions used in the previous post generate an array of integers, the number of iterations for the function return value to exceed 2. This post looks in more detail at how this data can be plotted in Excel using … Continue reading
Posted in Charts, Charts, Drawing, Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged cmap, Excell, imshow, Mandelbrot, MatPlotlib, Python, PyXLL, UDFs
Leave a comment