Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Daily Download 7: Lateraly loaded pile analysis
- Using LINEST for non-linear curve fitting
- Cubic Splines
- LatPile - Analysis of Lateral Loads on Piles
- Retrieving unique values from a range or array ...
- Fitting high order polynomials
- The angle between two vectors, Python version
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…
Category Archives: UDFs
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
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
Using Python optional arguments from Excel with pyxll
Python functions allow optional arguments to be specified by allocating a default value to each optional argument. The pyxll add-in allows Python functions called from Excel to work in the same way, so any argument with a default value may … Continue reading
Posted in Excel, Link to Python, PyXLL, UDFs
Tagged default arguments, Excel, Python, PyXLL, SciPy, Scipy stats, UDFs
1 Comment