### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- The angle between two vectors, Python version
- Cubic Splines
- Downloads by category
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Using LINEST for non-linear curve fitting
- Drawing in Excel 7 - Creating drawings from coordinates
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Fitting high order polynomials

### Recent Comments

Peak Warming Man on Australian Greenhouse Gas… AS 3600 and RC Desig… on New AS 3600 and RC Design Func… dougaj4 on Brent’s Method and a daf… Craig on Brent’s Method and a daf… Craig on Brent’s Method and a daf… dougaj4 on Solving Quadratic, Cubic, Quar… brian on Solving Quadratic, Cubic, Quar… brian on Solving Quadratic, Cubic, Quar… metroxx on Using Section Properties-… dougaj4 on Using Section Properties-… More iterative solve… on Iterative solvers and arr… metroxx on Using Section Properties-… Craig on Arc-spline update dougaj4 on Arc-spline update Craig on Arc-spline update

# Category Archives: Coordinate Geometry

## Arc-spline update

The input for the first version of the Arcspline function required the coordinates of the centre of each arc, as well as the angle of the tangents at each end of the arc. I have now added a new version with … Continue reading

Posted in Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA
Tagged Arc-spline function, Excel, IP2.xlsb, UDFs, VBA
7 Comments

## Using VBA Evaluate as an Array Function

I recently discovered from a thread at Chandoo’s Excel Forum that the VBA Evaluate function can be used as an array function. As a simple example: Range(“A11:A16”).Value = Evaluate(“= B11:B16 + C11:C16”) will add the values in columns B and C, … Continue reading

Posted in Arrays, Coordinate Geometry, Excel, Maths, UDFs, VBA
Tagged array functions, Evaluate, Excel, UDFs, VBA
2 Comments

## 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

## Using Section Properties- Group

Following a recent comment I have updated the documentation for finding the section properties of groups of shapes in the Section-Properties-Group spreadsheet. The revised file can be downloaded from: Section Properties07-Group.zip The screenshots below illustrate use of the Group function to … Continue reading

## IP2_py Update for Python3

The spreadsheet IP2_py provides a large number of geometric functions, including intersection points of lines, circles and planes, interpolation, rotations, and converting between coordinate systems. Many of the functions are available in VBA and Python versions. The Python code has now … Continue reading

## xlwSciPy update for Python 3

The xlwSciPy spreadsheet allows a wide variety of the science and maths functions in the Python Numpy and Scipy libraries to be called directly from Excel. The spreadsheet has now been updated for use with Python 3. The spreadsheet and … Continue reading

Posted in Coordinate Geometry, Differential Equations, Excel, Link to Python, Maths, Newton, Numerical integration, NumPy and SciPy, Python Pandas, UDFs, VBA, xlwings
Tagged Excel, Numpy, Python, SciPy, UDF, VBA, xlwings
1 Comment

## More circle fitting options with Scipy

A comment on the first post on this topic found that the method used did not work well for short arcs of large radius circles. An example of the problem can be seen in the screen shots below: The function … Continue reading

Posted in Coordinate Geometry, Curve fitting, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings
Tagged curve fitting, Excel, least squares, Numpy, ODR, Python, SciPy, VBA
Leave a comment