### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Using LINEST for non-linear curve fitting
- Downloads by category
- Clearing excess formats
- Cubic Splines
- Using Goal Seek on Multiple Cells
- Drawing in Excel 7 - Creating drawings from coordinates
- Commenting a block of code in VBA
- Writing an array to a worksheet range - correction
- Downloads
- Arrays vs Collections vs Dictionary Objects (and Dictionary help)

### Recent Comments

Edson on 3DFrame Ver 1.03 and Frame4 Ve… dougaj4 on Tanh-Sinh Quadrature V4.0 Katto Ishimura on Tanh-Sinh Quadrature V4.0 Graeme Dennes on Tanh-Sinh Quadrature V4.0 Katto Ishimura on Tanh-Sinh Quadrature V4.0 dougaj4 on Linestgap with data in ro… Ben on Linestgap with data in ro… dougaj4 on Non linear regression – 2; ALG… Trevor on Non linear regression – 2; ALG… online excel trainin… on Evaluating text and Integratio… Evaluating text and… on Evaluating text – u… online excel trainin… on Evaluating text – u… Evaluating text… on Eval.xls and the ALGLIB integr… Evaluating text… on Tanh-Sinh Quadrature V4.1 maurizio on Data Transfer to Python…

# Category Archives: UDFs

## Evaluating text and Integration with Python and ALGLIB

Following the previous post on evaluating mathematical functions entered as text on the spreadsheet, I have now written a spreadsheet with similar functionality using Python functions, and the Excel-Python add-in. Also included are integration functions using the SciPy Python library, … Continue reading

Posted in AlgLib, Arrays, Excel, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, UDFs, VBA
Tagged AlgLib, evaluation of text strings, Excel, Integration, Python, SciPy, VBA
1 Comment

## Evaluating text – update

One disadvantage of the spreadsheet style interface is that even simple formulae are difficult to check. For instance, the deflection of a cantilever loaded at the end is given by: F*L^3/(3*E*I) which is much easier to read than the Excel … Continue reading

Posted in AlgLib, Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged Eval function, evaluation of text strings, Excel, UDF, Unit conversion, Units, Units aware, VBA
2 Comments

## Reinforced Concrete – ULS capacity under combined axial load and biaxial bending

I have modified the ULS Design Functions spreadsheet, last presented here, to analyse sections subject to bi-axial bending, and non-symmetrical sections. The new version makes use of the routines for splitting any section defined by XY coordinates into trapezoidal layers, described … Continue reading

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged biaxial bending, Combined bending and axial load, Excel, Prestressed concrete, Reinforced Concrete, UDF, VBA
2 Comments

## Feet and inches, and other units

Following a query at Eng-tips I have had a look at options in Excel for converting metres to feet and inches, with the inches displayed as a fraction rather than a decimal. Converting from metres to feet or inches is … Continue reading

## Python Matrix Functions with ExcelPython – 2

Following the previous ExcelPython post I have modified the VBA and Python code for improved performance and to simplify the Python coding. The main change is that where Numpy Arrays are required in the Python code, these are now created … Continue reading

Posted in Arrays, Excel, Link to Python, Maths, NumPy and SciPy, UDFs, VBA
Tagged Excel, ExcelPython, Link to Python, Matrix Functions, sparse matrix solvers, UDF, VBA
14 Comments