### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Time in hours and minutes between two dates
- Cubic Splines
- Using LINEST for non-linear curve fitting
- Downloads by category
- Latex Maths Text in Excel
- Deflections and Moments in Rectangular Plates
- The history of the theory of beam bending - Part 1
- Retrieving unique values from a range or array ...
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Downloads

### Recent Comments

# Tag Archives: PyXLL

## Downloads update

A list of files available for free download can be found under the Downloads link at the top of the page: The list has now been updated and there are now 189 files available for download, most with open source … Continue reading

Posted in Computing - general, Excel
Tagged Download list, Files for download, open source code, Python, PyXLL, VBA, xlwings
Leave a comment

## A not so easy problem

A seemingly simple problem was posted in my Quora feed: or to put it more mathematically, what three positive integers satisfy the equation: It turns out the answer is not so simple. A full and detailed derivation can be found … Continue reading

## More on combined shear and bending design to AS 3600

Further to the last post on this subject I have been looking at procedures to speed up design for shear to AS 3600 when the “refined” analysis procedure is used. The issues that need to be addressed are: I have … Continue reading

Posted in Beam Bending, Concrete, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Brents method, Combined shear and bending, Excel, Longitudinal shear force, Python, PyXLL, SciPy, shear capacity, UDFs
4 Comments

## Latex Maths Text in Excel

There have been many posts here looking at alternative ways of working with functions entered as text on a spreadsheet, and working with units, most recently here. One drawback with this approach is that text in an Excel cell must … Continue reading

Posted in Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged EvalU, Excel, Latex, Math Text, mpmath, Pint, Python, PyXLL, Sympy, UDFs, Unit-aware calculation
Leave a comment

## Linking to Python help from Excel

The py_Numpy spreadsheet presented in the previous post has been updated: The new version can be downloaded from: py_Numpy.zip As before, the pyxll add-in is required for the connection from Excel to Python. All the available functions are listed on … Continue reading

Posted in Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Display Python help, Excel, Link to Python on-line help, Numpy, Python, PyXLL, UDFs
Leave a comment