### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- The angle between two vectors, Python version
- Using Goal Seek on Multiple Cells
- Downloads by category
- Cubic Splines
- Downloads
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Passing variable argument lists from Excel to Python via xlwings
- Drawing in Excel 7 - Creating drawings from coordinates
- Automating chart scale limits

### Recent Comments

Brian Dolan on LatPilePY 1.04 dougaj4 on LatPilePY 1.04 Brian Dolan on LatPilePY 1.04 Asymmetric Catenary… on Using Excel Solver from V… Asymmetric Catenary… on A catenary function OliviaHoros on Commenting a block of code in… Column buckling unde… on Using Frame4Buckle with the Al… Column buckling unde… on Buckling of columns with varyi… dougaj4 on Biaxial bending update DonB on Biaxial bending update dougaj4 on Biaxial bending update DonB on Biaxial bending update DonB on Biaxial bending update Perko on Installing Adobe Reader non-DC… Python Traps | Newto… on The meaning of = in Pytho…

# Tag Archives: Excel

## The answer to Life the Universe and Everything …

is 42, as is well-known: The actual question, to which the answer is 42, is not known, but a lesser known long standing question involving this number has recently been solved: The original problem, set in 1954 at the University … Continue reading

Posted in Computing - general, Excel, Maths, Newton, PyXLL
Tagged 42, Excel, Life the Universe and Everything, mpmath, PyXLL
5 Comments

## Plotting Mandelbrot

There are many sites discussing the Mandelbrot Set, but not many examples using VBA to plot the set in Excel, so here is my effort: The spreadsheet (including open source VBA code) may be downloaded from: Mandelbrot chart.zip Note that … Continue reading

Posted in Charts, Charts, Coordinate Geometry, Drawing, Excel, Maths, Newton, VBA
Tagged Charts, Excel, Mandelbrot Set, VBA
3 Comments

## Using conditional formatting with array formulas

A recent Quora question asked “How do I highlight the number closest to an initial number in a row in Excel?“. The answer by Bill Jelen provides a good example of using conditional formatting with an array formula: In my … Continue reading

Posted in Arrays, Excel
Tagged Array Formula, conditional formatting, Excel, Office Insider
Leave a comment

## 64 bit Excel and PtrSafe

Installing my Office 365 subscription on a new computer I discovered it had decided (without asking) to upgrade itself to the 64 bit version, which resulted in some of my spreadsheets not working on the new system. The main problem … Continue reading

## Solving the Lagrangian Point equation for the Moon

This post was prompted by a recent question at Fitting high order polynomials, asking for Excel methods to solve the equations for the radius of the Moon’s Lagrangian Point 1. All the methods described in this post have been added to … Continue reading

Posted in Excel, Maths, Newton, UDFs, VBA
Tagged Excel, iterative solution, Lagrangian point, Newton, polynomial solution, UDFs, VBA
3 Comments

## ULS design of circular reinforced concrete columns

The RC Design Functions spreadsheet has been updated (to Version 8.04) with the addition of a CircU function for ULS design of circular reinforced concrete sections under combined bending and axial load. The new version, including full open-source code, may … Continue reading

## ULS Design Functions – update for AS 3600

The ULS Design Functions spreadsheet (last posted here) has been updated to the new Australian Standard for concrete structures; AS 3600-2018. The new version can be downloaded from: ULS Design Functions.zip Note that the biaxial version included in the download … Continue reading

Posted in Beam Bending, Concrete, Excel, Newton, UDFs, VBA
Tagged AS 3600, AS 5100, circular section, Excel, Reinforced Concrete, UDF, ULS Design Functions, VBA
2 Comments