Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Using LINEST for non-linear curve fitting
- Downloads
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Downloads by category
- 3DFrame - 3D Frame analysis for Excel
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Beam actions and deflections by Macaulay's Method
- About Newton Excel Bach
- Using Linest for non-linear curve fitting, examples, hints and warnings
Recent Comments
Tag Archives: Translate VBA to Python
Python for VBA users – 3
In the previous post in this series I looked at translating a routine to solve quadratic equations from VBA to Python. Using the same process I have also created Python code to solve Cubic equations. The only added difficulty for the … Continue reading
Posted in Excel, Link to Python, Maths, UDFs, VBA
Tagged Excel, Python, PyXLL, Quadratic function, Translate VBA to Python, UDF, VBA
2 Comments
Python for VBA users – 2
This post will look in more detail at translating the VBA Quadratic function (described in Python for VBA users – 1) into a Python function, linked to Excel via PyXll. For the purposes of this exercise I created a new Python … Continue reading
Posted in Excel, Link to Python, NumPy and SciPy, UDFs, VBA
Tagged Excel, Python, PyXLL, Quadratic function, Translate VBA to Python, UDF, VBA
11 Comments
Python for VBA users – 1
Following my recent posts on some preliminary experimentation with linking Excel to Python, this will be the first of a more structured series, mainly as a reminder to myself of lessons learnt on the way, but also I hope of … Continue reading
Posted in Excel, Link to Python, UDFs, VBA
Tagged Excel, Python, PyXLL, Translate VBA to Python, UDF, VBA
2 Comments