### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using Goal Seek on Multiple Cells
- Using LINEST for non-linear curve fitting
- Open Source FEA Code Links
- The angle between two vectors, Python version
- Solving cubic and quartic equations with Excel
- Fitting high order polynomials
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Time in hours and minutes between two dates

### Recent Comments

josh on Import Data from a Picture to… Melanie Safka + Mile… on Melanie Safka Mohd Yousef on Biaxial bending update DonB on Biaxial bending update Mohd Yousef on Biaxial bending update dougaj4 on Biaxial bending update DonB on Biaxial bending update dougaj4 on Biaxial bending update DonB on Biaxial bending update Mohd Yousef on Biaxial bending update dougaj4 on Beam Fixed End Actions by Maca… Peka Odendaal (@PKOd… on Beam Fixed End Actions by Maca… Gerardo Freyre on The history of the theory of b… dougaj4 on Time in hours and minutes betw… SDAmy on Time in hours and minutes betw…

# Tag Archives: UDFs

## Reinforced Concrete Design for Circular Sections to Eurocode 2

As mentioned in the previous post, the Reinforced Concrete Design Functions spreadsheet includes a function for ULS analysis of circular sections, using either a rectangular or a parabolic-linear stress block. A new CircuPF function has now been added, for codes … Continue reading

## ULS Design Functions and EurocodeApplied

The ULS Design Functions spreadsheet (last updated here) has had another update (2.09) to fix a problem when bars in different layers had different E values. The new version assigns the correct E and strain at yield to each layer. … Continue reading

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged Eurocode 2, Eurocodeapplied, Excel, Reinforced concrete design, UDFs, ULS Design Functions, ULS design of circular section, VBA
7 Comments

## Numerical integration with on-sheet calculations

Following a comment here I have prepared a spreadsheet that works through the Tanh-Sinh Quadrature process with on-sheet calculations. For that purpose Graeme Dennes has provided a simplified version of the code: QUAD_RODRIGUEZ_TANH_SINH for finite intervals. Translated from HP RPN … Continue reading

Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA
Tagged Excel, numerical integration, on-sheet calculations, Tanh-Sinh Quadrature, UDFs, VBA
Leave a comment

## XY Chart problems – 2

The previous chart post (XY Chart problems – 1) looked at problems plotting charts with very short data ranges. An associated problem is plotting XY charts with data with gaps (see When is an XY chart not an XY chart …? and … Continue reading

Posted in Arrays, Charts, Charts, Excel, UDFs, VBA
Tagged Charts, Excel, UDFs, VBA, XY chart, XY chart displays as line, XY chart with gaps
Leave a comment

## Getting near matches from a list with Python

To return a list of near matches from a long list of strings would be quite difficult in VBA (unless I’m missing something), but in Python it is very simple. Here is the code for this operation, using pyxll to … Continue reading

Posted in Excel, Link to Python, PyXLL, UDFs
Tagged close matches, Excel, Python, PyXLL, UDFs, using Excel function wizard
Leave a comment