### 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
- Cubic Splines
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Arrays vs Collections vs Dictionary Objects (and Dictionary help)
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Fitting high order polynomials
- Frame Analysis with Excel - 4, 2D frame analysis
- Using LINEST for non-linear curve fitting

### Recent Comments

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… dougaj4 on P-Y Curve function Zhitong Zhang on P-Y Curve function Matt Cornell on Newton’s Cradle Clive James and Pete… on The Barrow Poets dougaj4 on Excel to Alglib via xlwin…

# 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