Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Using LinEst() on data with gaps
- Continuous Beams With Spring Supports by Macaulay’s Method
- Intersections, interpolations, and rotations
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Smart Indenter and Excel 2013
- Converting from global to local coordinates (and vice versa)
- Buckling of columns with varying cross section
- Fitting high order polynomials
Recent Comments
Tag Archives: improving performance
Transfer of arrays to/from Python with Pyxll – Part 2; Speed
Following the previous post, which looked at the way different data types worked when transferring data between Excel and Python, this post looks at ways t0 get the best performance. As a benchmark I have used a short routine that: … Continue reading
Posted in Arrays, Excel, Link to Python, NumPy and SciPy, VBA
Tagged Excel, improving performance, Numba, Python, PyXLL, transferring data, VBA
1 Comment