Recent Comments
Author Archives: dougaj4
xlwings 0.7.1, dictionaries, and optional arguments
xlwings 0.7.0 was published at the beginning of March, and introduced direct support for Python dictionaries, which I have used to demonstrate various options for dealing with optional arguments in Excel User Defined Functions (UDFs). The latest version, 0.7.1, published … Continue reading
Posted in Curve fitting, Excel, Link to Python, Maths, NumPy and SciPy, UDFs, VBA
Tagged curve_fit, dictionaries, Excel, optional arguments, Python, SciPy, UDF, VBA, xlwings
1 Comment
Seeing through Mingus eyes -2; Luluc
“Making the simple complicated is commonplace; making the complicated simple, awesomely simple, that’s creativity” Charles Mingus LULUC
xlScipy with xlwings
Following a new release of xlwings, I have updated the xlScipy spreadsheet to work with it, and added a few new features: The Matplotlib routines to plot a function entered as text (previously posted as xlMatPlot.zip) have been incorporated on … Continue reading
Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA
Tagged Akima Spline, Cubic splines, Excel, MatPlotlib, Python, Python space functions, UDF, VBA, xlwings
Leave a comment
Two new links
Following the blog theme of using Excel for working with numbers without a $ on the front, I have added to my links: EngineerExcel EngineerExcel.com was founded by Charlie Young. He is a licensed professional engineer with a degree in … Continue reading
Cubic splines with descending x
In response to a recent comment, I have modified the CSpline2 spreadsheet so that the CSplineA and CHSplineA functions will accept x values list in descending order, as well as ascending. For more details of the background to the functions, … Continue reading
Posted in Excel, Maths, Newton, UDFs, VBA
Tagged Cubic splines, descending x, Excel, UDF, VBA
Leave a comment
Newton Excel Bach, not (just) an Excel Blog 