### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Using LINEST for non-linear curve fitting
- Downloads by category
- Using Goal Seek on Multiple Cells
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Drawing in Excel 7 - Creating drawings from coordinates
- Frame Analysis with Excel
- Using Linest for non-linear curve fitting, examples, hints and warnings
- Section Properties with MeshPY, including torsion and warping
- Downloads
- Commenting a block of code in VBA

### Recent Comments

dougaj4 on Drawing in Excel 7 – Cre… Section Properties w… on Downloads Charalampos Dala on Drawing in Excel 7 – Cre… dougaj4 on The Inverse Quadratic Method 3… Brent’s Method… on The Inverse Quadratic Method 3… dougaj4 on Downloads Hannah on Downloads dougaj4 on ConBeamU 4.13 metrox on ConBeamU 4.13 Austine Adah on The Inverse Quadratic Method 3… dougaj4 on RCInteract and RC Design Funct… Stephen on RCInteract and RC Design Funct… dougaj4 on Solving Quadratic, Cubic, Quar… dougaj4 on RCInteract and RC Design Funct… Stephen on RCInteract and RC Design Funct…

# Tag Archives: Excel

## Using Alglib least-squares solvers

Following the last post on using the Python version of Alglib from Excel, via xlwings, this post looks in more detail at alternatives for fitting a non-linear function to a set of data, using the Levenberg-Marquardt method. The spreadsheet with … Continue reading

Posted in AlgLib, Curve fitting, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings
Tagged AlgLib, Excel, Levenberg Marquardt, lsfit, minlm, Numpy, Python, SciPy, UDF, VBA, xlwings
Leave a comment

## Working with implied units

The Units4Excel spreadsheet provides a number of functions to convert between different units and evaluate functions entered as text on the spreadsheet, taking account of the units of both the inputs and the results. The latest version can be downloaded from: … Continue reading

Posted in Concrete, Excel, Maths, Newton, UDFs, VBA
Tagged ACI 318, Customary US Units, Eval, EvalU, Evaluate text, Excel, Implied units, shear capacity, SI Units, UDF, Units aware, Units4Excel, VBA
2 Comments

## Stepping through 3DFrame

Following a recent comment this post looks at the code for setting up the stiffness matrix for a 3D frame, and how to step through any selected part of the code. The general procedure for setting up a 3D stiffness matrix, … Continue reading

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Newton, UDFs, VBA
Tagged 3DFrame, Debugging UDFs, Debuging VBA, Excel, UDF, VBA
Leave a comment

## Setting up UDF Applications

Following a recent comment, this post looks at setting up a user defined function (UDF) on a blank worksheet, using the ConBeamU function as an example. To use a UDF, the VBA code for the function must either be included … Continue reading

Posted in Arrays, Beam Bending, Excel, Finite Element Analysis, Newton, UDFs, VBA
Tagged ConBeamU, Excel, resize array functions, UDF, VBA
1 Comment

## UDF to replace cell references with values

I recently posted an update to the Eval2 spreadsheet with a subroutine to display a cell formula as a text string, with the cell references replaced by the associated values. I have now added three user defined functions (UDFs) to do … Continue reading

Posted in Excel, UDFs, VBA
Tagged display formula reference values, Evaluate text, Excel, UDF, VBA
Leave a comment

## Evaluating text and calling Python functions from Excel with xlwings

The Alglib spreadsheet presented here includes functions to evaluate formulas entered as text on the spreadsheet, or to call specified Python functions. I have now added a user defined function (UDF) that will perform either of these operations (xl_CallFuncD), and added … Continue reading

Posted in AlgLib, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings
Tagged AlgLib, call Python functions, evaluate text strings, Excel, Numpy, Python, SciPy, UDF, VBA, xlwings
1 Comment

## Converting a formula to values

Excel has a built-in function (FormulaText) to display a formula as cell references, rather than the result value. It would be useful to be able to display the value of each cell reference as well, but there is no built-in … Continue reading