### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Daily Download 7: Lateraly loaded pile analysis
- Using LINEST for non-linear curve fitting
- Cubic Splines
- LatPile - Analysis of Lateral Loads on Piles
- Retrieving unique values from a range or array ...
- Fitting high order polynomials
- The angle between two vectors, Python version

### Recent Comments

dougaj4 on Eval and Let examples dougaj4 on Eval and Let examples TB on Eval and Let examples dougaj4 on Eval and Let examples pgalvan@sigmaingenie… on Eval and Let examples dougaj4 on Eval and Let examples Craig on Eval and Let examples Craig on Eval and Let examples dougaj4 on Downloads Eval and Let example… on Evaluating text – u… Eval and Let example… on Evaluating text with units and… Eval and Let example… on Two New Functions; Let and… rhochoa81gmailcom on Downloads Ebony Buckle, New Sc… on George Gently, Matty Groves, a… dougaj4 on Numerical Integration With Tan…

# Tag Archives: VBA

## Eval and Let examples

There are many examples of the use of the new Let function on the web (see my previous post on this topic for links). This post compares use of Let with my Eval user defined function (UDF). More details on … Continue reading

Posted in Excel, Maths, UDFs, VBA
Tagged Eval UDF, Excel, Let function, nested functions, UDFs, VBA
8 Comments

## Python optional arguments from Excel – Part 2

The previous post provided a method for using pyxll to pass optional arguments from Excel to Python whilst preserving the default values of any called Python function for arguments that were omitted in the Excel function. One condition where this … Continue reading

Posted in Excel, Link to Python, NumPy and SciPy, PyXLL, UDFs, VBA
Tagged default arguments, Excel, Python, PyXLL, UDFs, VBA
Leave a comment

## Units4Excel Update

As discussed here, I have updated the Units4Excel spreadsheet, with the list of non-SI units updated from the latest Wikipedia table. The EvalU user defined function (UDF) has also been modified with three output options, as shown in the screen-shot … Continue reading

Posted in Excel, Maths, Newton, UDFs, VBA
Tagged Evaluate text functions, Excel, UDFs, Unit aware calculations, VBA
5 Comments

## More on RC design of circular sections

Following the last post on this topic (Reinforced Concrete Design for Circular Sections to Eurocode 2) I have added provision for parabolic-linear concrete stress blocks to the ULS Design Functions spreadsheet. The Circu function in the RC Design Functions spreadsheet has … Continue reading

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged ACI 318, AS 3600, Circular reinforced concrete sections, Comparison of codes, Eurocode 2, Excel, UDF, ULS Design Functions, VBA
4 Comments

## Extracting text from an Internet table

For use in my Units spreadsheet (Units4Excel) I want to extract the unit conversion values from the comprehensive Wikipedia unit conversion table. On Wikipedia the table looks like this: and when copied and pasted as Unicode text into Excel, like … Continue reading

Posted in Excel, Newton, UDFs, VBA
Tagged Excel, Extract from text, UDFs, Unit conversion, Units, Units4Excel, VBA, Wikipedia
3 Comments