Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Commenting a block of code in VBA
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using Goal Seek on Multiple Cells
- Time in hours and minutes between two dates
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Cubic Splines
- Taming Symbols in Excel
- Downloads
- Fitting high order polynomials
- Writing Arrays to the worksheet - VBA function
Recent Comments
dougaj4 on Eval and Let examples dougaj4 on Eval and Let examples TB on Eval and Let examples dougaj4 on Eval and Let examples pgalvan@sigmaingenie… on Eval and Let examples dougaj4 on Eval and Let examples Craig on Eval and Let examples Craig on Eval and Let examples dougaj4 on Downloads Eval and Let example… on Evaluating text – u… Eval and Let example… on Evaluating text with units and… Eval and Let example… on Two New Functions; Let and… rhochoa81gmailcom on Downloads Ebony Buckle, New Sc… on George Gently, Matty Groves, a… dougaj4 on Numerical Integration With Tan…
Author Archives: dougaj4
Eval and Let examples
There are many examples of the use of the new Let function on the web (see my previous post on this topic for links). This post compares use of Let with my Eval user defined function (UDF). More details on … Continue reading
Posted in Excel, Maths, UDFs, VBA
Tagged Eval UDF, Excel, Let function, nested functions, UDFs, VBA
8 Comments
Ebony Buckle, New Scientist, and the 52 Hz Whale
We last heard from Ebony Buckle here nearly 8 years ago, but I noticed her name in an article on the back page of last week’s New Scientist, which noted that her latest work was inspired by the World’s loneliest … Continue reading
Posted in Bach, Newton
Tagged 52 Hz Whale, Ebony Buckle, Feedback, New Scientist, Wonder
Leave a comment
Two New Functions; Let and Lambda
Two new Excel functions have recently attracted a lot of attention; these are: LET (now available to Office 365 subscribers and LAMBDA (currently available to Office Insiders program only) Microsoft documentation can be found at: Announcing LET Have you ever … Continue reading
Posted in Excel, UDFs
Tagged Excel, Lambda examples, Lambda Function, Let examples, Let function
1 Comment
Python callable arguments from Excel
Many Scipy functions have “callable” arguments, i.e. functions that can be called, with the returned data used as input by the calling function. Types of callable arguments include: Functions in the active Python module Functions in any active loaded library … Continue reading
Posted in Excel, Link to Python, NumPy and SciPy, PyXLL, UDFs
Tagged Eval, Excel, getattr, globals, lambda functions, Python, PyXLL, UDFs
Leave a comment
Python optional arguments from Excel – Part 2
The previous post provided a method for using pyxll to pass optional arguments from Excel to Python whilst preserving the default values of any called Python function for arguments that were omitted in the Excel function. One condition where this … Continue reading
Posted in Excel, Link to Python, NumPy and SciPy, PyXLL, UDFs, VBA
Tagged default arguments, Excel, Python, PyXLL, UDFs, VBA
Leave a comment