### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Using LINEST for non-linear curve fitting
- Cubic Splines
- The angle between two vectors, Python version
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Downloads by category
- Downloads
- Using LinEst() on data with gaps
- About Newton Excel Bach

### Recent Comments

dougaj4 on Using Section Properties-… Mattias on Using Section Properties-… dougaj4 on Using Section Properties-… Mattias on Using Section Properties-… dougaj4 on ULS Design Functions – u… hadwao on ULS Design Functions – u… ULS Design Functions… on Concrete ULS spreadsheet … Working with dynamic… on Returning Arrays From VBA and… dougaj4 on Drawing in Excel – … J.D. on Drawing in Excel – … dougaj4 on The Largest Early World Map… Doug Glancy on The Largest Early World Map… Larry Schuster on How Reinforced Earth work… dougaj4 on ConBeamU 4.13 roshan_rai@hotmail.c… on ConBeamU 4.13

# Tag Archives: IP2

## Arcs and arc-splines

I have added two user defined functions (UDFs) to the IP2 spreadsheet to generate coordinates for a single arc, or a series of arcs connected (if necessary) by straight lines. The new version may be downloaded from: IP2.zip As an example … Continue reading

## The Dome of Santa Maria del Fiore – Dimensions

This post is a continuation from The Dome of Santa Maria del Fiore in Florence Different sources give a wide variety of different dimensions for the dome, but there seems to be reasonable agreement that the “across flats” diameter of the … Continue reading

Posted in Dome Structures, Excel, Finite Element Analysis, Newton, Strand7, UDFs, VBA
Tagged DigitGraph, Dome, Excel, FEA, Florence Cathedral, IP2, S& API Tools, UDF, VBA
2 Comments

## Interpolation Update

This post was prompted by a question at Eng-Tips. The question was looking for ways to plot stress contours under a footing, which requires interpolation to find the depth where the stress is at the contour values, given stresses calculated … Continue reading

## IP2 Update, ByRef and ByVal

A recent comment pointed out that the IPPlaneLine function (intersection of a 3D line with a plane) in the IP2 spreadsheet was giving incorrect results. This has now been fixed, and the corrected spreadsheet can be downloaded from IP2.zip. The problem turned out … Continue reading