Recent Comments
Author Archives: dougaj4
UDF to replace cell references with values
I recently posted an update to the Eval2 spreadsheet with a subroutine to display a cell formula as a text string, with the cell references replaced by the associated values. I have now added three user defined functions (UDFs) to do … Continue reading
Posted in Excel, UDFs, VBA
Tagged display formula reference values, Evaluate text, Excel, UDF, VBA
Leave a comment
Jansch and Renbourn live
Three recently uploaded You Tube recordings of live performances by guitarists Bert Jansch and John Renbourn. As further evidence that the quality of a You Tube video is inversely proportional to the number of views, none of the three have … Continue reading
Scottish Fiddlers
Yesterday I saw “Scotland the Brave” at the Sydney Opera House, featuring the Willoughby Symphony Orchestra and Choir, and fiddler extraordinaire Marcus Holden: whose playing of Scottish fiddle music reminded me of Robin Williamson and the Incredible String Band: and lead … Continue reading
Evaluating text and calling Python functions from Excel with xlwings
The Alglib spreadsheet presented here includes functions to evaluate formulas entered as text on the spreadsheet, or to call specified Python functions. I have now added a user defined function (UDF) that will perform either of these operations (xl_CallFuncD), and added … Continue reading
Posted in AlgLib, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings
Tagged AlgLib, call Python functions, evaluate text strings, Excel, Numpy, Python, SciPy, UDF, VBA, xlwings
1 Comment
Converting a formula to values
Excel has a built-in function (FormulaText) to display a formula as cell references, rather than the result value. It would be useful to be able to display the value of each cell reference as well, but there is no built-in … Continue reading
