Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Intersections, interpolations, and rotations
- Linestgap with data in rows
- Working with units in Excel - using VBA and Python
- Installing Python, Scipy and Pyxll
- Frame Analysis with Excel - 3, Continuous beam or frame
- Combining text files
- Using LINEST for non-linear curve fitting
- Reinforced Concrete Section Analysis - 3
- Extracting data from a 3D range
- The history of the theory of beam bending - Part 1
Recent Comments
Tag Archives: Factorial function
Long integers in Python and Excel and py_Fact
I have added a new py_Fact function to the py_Scipy module, that returns the factorial of an integer as a float if it is up to 15 digits long, or a string for longer numbers. The revised code, and the … Continue reading
Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Excel, Factorial function, Python, PyXLL, SciPy, 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
3 Comments