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: Excel
Getting Excel Solver working
Recently I found that for unknown reasons the Excel Solver add-in was not working. Opening the add-ins list from the Devloper tab showed that it had become deactivated (also accessible from File-Options-Add-ins): Clicking the Solver check box returned a message … Continue reading
Posted in Computing - general, Excel
Tagged Excel, Office 365, Solver add-in, Solver disabled
Leave a comment
Listing Python modules and getting help docs from Excel
Python functions include detailed help documentation but to access this you need the full path to the function, including the names of all code modules and submodules. This post looks at how this information can be found using Excel with … Continue reading
Posted in Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, Function help, Getmembers, Numpy, Pkgutil, Python, PyXLL, SciPy
Leave a comment
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
Python functools – cache and lru_cache
Update 3rd April 2022: Following the comment from Larry Schuster I have modified the code so that the factorial0 function actually uses cache as intended, rather than lru_cache. I also added code to clear the cache after each timer run, … Continue reading
Posted in Excel, Link to Python, PyXLL, UDFs
Tagged cache, Excel, Factorial function, Functools, lru_cache, Numba, Python, PyXLL
2 Comments