Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Using LINEST for non-linear curve fitting
- 3DFrame Ver 1.03 and Frame4 Ver 3.07
- Cubic Splines
- About Newton Excel Bach
- Downloads
- Filling Blanks with Go To-Special (and local help rant)
- XLDennis, the MSDN Library, and VBA rant
- Writing Arrays to the worksheet - VBA function
- Frame Analysis with Excel - 3, Continuous beam or frame
- RCInteract and RC Design Functions 7.03
Recent Comments
Tag Archives: Quadratic function
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