Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Cubic Splines
- Using LINEST for non-linear curve fitting
- Lateral pile analyis with PY curves ...
- Deflections and Moments in Rectangular Plates
- Fitting high order polynomials
- Downloads
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
Recent Comments
Tag Archives: UDFs
Pint, MPmath and implied units, working with Excel
Spreadsheets linking to the Python Pint and MPmath libraries have been presented here before at: Units and solvers with Pint and Sympy mpmath for Excel I have now updated the spreadsheet to work with pyxll, and with some new functions and … Continue reading
Posted in Concrete, Excel, Link to Python, Newton, PyXLL, UDFs
Tagged defining units, Excel, Implied units, mpmath, Pint, Python, PyXLL, Sympy, UDFs
Leave a comment
3D Matplotlib Plots in Excel
As well as Excel, the code shown in this post requires current versions of Python, Numpy, Matplotlib, and pyxll. The required import statements at the head of the Python code are: The spreadsheets and Python code described below may be … Continue reading
Posted in Charts, Charts, 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
Leave a 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
Contour plots with Excel and Matplotlib
Contour plots are widely used for a great variety of purposes, but facilities for producing them in Excel are very limited, and those that are provided are very well hidden. In this post I will look at some simple examples … Continue reading
Posted in Arrays, Charts, Charts, Excel, Finite Element Analysis, Link to Python, NumPy and SciPy, PyXLL, Strand7, UDFs
Tagged Contour plots, Excel, MatPlotlib, Python, PyXLL, UDFs
Leave a 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