Recent Comments
Author Archives: dougaj4
Data Transfer to Python – Update
As noted in the comments here, the main bottleneck in the Python matrix solver functions presented recently was not in the data transfer from Excel, but rather in the creation of the Numpy arrays for very long lists of short … Continue reading
Posted in Arrays, Excel, Frame Analysis, Link to Python, NumPy and SciPy, VBA
Tagged Creating Numpy Arrays, Excel, ExcelPython, Python, slow array creation, VBA
4 Comments
Two Timers
The simplest way to check the execution time of VBA code is with the built in Timer function, but this returns a single precision value in seconds, resulting in a minimum time step of about 10 milliseconds. For VBA code … Continue reading
Feet and inches, and other units
Following a query at Eng-tips I have had a look at options in Excel for converting metres to feet and inches, with the inches displayed as a fraction rather than a decimal. Converting from metres to feet or inches is … Continue reading
Python Matrix Functions with ExcelPython – 2
Following the previous ExcelPython post I have modified the VBA and Python code for improved performance and to simplify the Python coding. The main change is that where Numpy Arrays are required in the Python code, these are now created … Continue reading
Posted in Arrays, Excel, Link to Python, Maths, NumPy and SciPy, UDFs, VBA
Tagged Excel, ExcelPython, Link to Python, Matrix Functions, sparse matrix solvers, UDF, VBA
14 Comments
Planxty and Little Musgrave
Planxty are one of my favourite groups form the early 70’s, consisting of Christy Moore (vocals, acoustic guitar, bodhrán), Andy Irvine (vocals, mandolin, mandola, bouzouki, hurdy-gurdy, harmonica), Dónal Lunny (bouzouki, guitars), and Liam O’Flynn (uilleann pipes, tin whistle), all … Continue reading
Newton Excel Bach, not (just) an Excel Blog 