Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Time in hours and minutes between two dates
- Using LINEST for non-linear curve fitting
- Cubic Splines
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Commenting a block of code in VBA
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Removing Add-ins
- Downloads by category
- Using Goal Seek on Multiple Cells
- Contour plots with Excel and Matplotlib
Recent Comments
Sukrit Ghorai on Biaxial bending update dougaj4 on Biaxial bending update Sukrit on Biaxial bending update A not so easy proble… on Pint, MPmath and implied units… dougaj4 on ULS design of circular reinfor… Dakota on ULS design of circular reinfor… Marcus747 on Commenting a block of code in… dougaj4 on Biaxial bending update Sukrit on Biaxial bending update DT67 on Using ConbeamU DT67 on Using ConbeamU dougaj4 on Using ConbeamU DT67 on Using ConbeamU DT67 on Using ConbeamU dougaj4 on Biaxial bending update
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