### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Downloads
- Using LINEST for non-linear curve fitting
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- The angle between two vectors, Python version
- Time in hours and minutes between two dates
- Fitting high order polynomials
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Retrieving unique values from a range or array ...

### Recent Comments

Kurt Clark on Working with units in Excel… dougaj4 on Working with units in Excel… Kurt Clark on Working with units in Excel… Kurt Clark on Working with units in Excel… Kurt Clark on Working with units in Excel… dougaj4 on Numerical integration with on-… Tanh-Sinh Quadrature… on Numerical integration with on-… esfand on Open Source FEA Code Link… Craig on Numerical integration with on-… dougaj4 on Numerical integration with on-… Milos Cipovic on Numerical integration with on-… dougaj4 on Numerical integration with on-… Milos Cipovic on Numerical integration with on-… dougaj4 on Numerical integration with on-… Milos Cipovic on Numerical integration with on-…

# Tag Archives: Cubic

## Solving cubic and quartic equations with Excel

Although in earlier posts (such as this one) I have referred to some User Defined Functions (UDFs) for solving cubic and quartic equations, I just realised recently that I haven’t actually talked about them here, and since they are in … Continue reading

## Approximate Solutions of Polynomial Equations

Following on from the previous post, this post presents a number of methods of solving polynomial equations using approximate iterative methods in Excel. Similar methods can be used to find solutions to any other equation that can be evaluated numerically. … Continue reading

Posted in Excel, Maths, Newton, UDFs, VBA
Tagged Cubic, Excel, Newton-Raphson Method, Polynomial, Quartic, UDA, VBA
3 Comments

## Linking Excel to Fortran – 2

In this post the procedures described for C++ here will be replicated for Fortran: The spreadsheet, fortran source code, and compiled dll described in this code may be downloaded from Cubic.zip As always, it is better to use the downloaded code, … Continue reading

Posted in Excel, Fortran, Link to dll, Maths, UDFs, Uncategorized, VBA
Tagged Cubic, Excel, Fortran, Quadratic, UDF, VBA
23 Comments

## Reinforced Concrete Section Analysis – 3

Previous post -1 Previous post -2 The theory presented in the previous 2 posts in this series has been incorporated into an Excel UDF, allowing concrete and reinforcement stresses and strains to be evaluated quickly and easily for reinforced and … Continue reading

Posted in Beam Bending, Excel, Newton, UDFs
Tagged Cubic, Plot Shapes, Polynomial, Quadratic, Quartic, Reinforced Concrete, Section Analysis, UDF, VBA
8 Comments