### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Cubic Splines
- Using Goal Seek on Multiple Cells
- The angle between two vectors, Python version
- Using LINEST for non-linear curve fitting
- Downloads by category
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Problems with UCase and LCase in VBA
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Retrieving unique values from a range or array ...

### Recent Comments

More Numpy with Exce… on Using Array Functions and… More Numpy with Exce… on Sorting with Python and N… Office Insiders and… on JavaScript UDFs in Excel Sorting with Python… on Sorting with VBA and Pyth… Sorting with VBA and… on Dynamic sorting with Excel, VB… Luis on Okenyo dougaj4 on Drawing in Excel 7 – Cre… rva on Drawing in Excel 7 – Cre… dougaj4 on Numerical Integration; Tanh-Si… srabutdotcom on Numerical Integration; Tanh-Si… dougaj4 on Converting from global to loca… Joan Gonzalez on Converting from global to loca… dougaj4 on Beam geometric non-linear… Bob Jordan on Beam geometric non-linear… David Lim on Frame Analysis Resources

# Category Archives: Coordinate Geometry

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

## More Python rotation functions

The code described in the previous post includes a Python function that rotates 3D coordinates by an angle defined with two vectors, using Rodrigue’s Rotation. I have now added this function to the IP2_py spreadsheet, where it is used in the … Continue reading

Posted in Coordinate Geometry, Drawing, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings
Tagged Excel, fit 3D circle, Numpy, Python, RPView, UDF, VBA, xlwings, xl_RPView
Leave a comment

## Fitting 3D circles to scattered points

Following a comment at update-to-glob_to_loc3-and-loc_to_glob3-functions, I have modified the Python code at the linked site, so it can be run from Excel, via xlwings. The spreadsheet described below, and the associated Python code, can be download from: 3DCirc.zip The original … Continue reading

Posted in Coordinate Geometry, Excel, Link to Python, Maths, Newton, NumPy and SciPy, UDFs, VBA, xlwings
Tagged 3DCirc, Excel, fit 3D circle, Numpy, Python, UDF, VBA, xlwings
5 Comments

## Update to Glob_to_loc3 and Loc_to_glob3 functions

Following a comment here I have updated the Glob_to_loc3 and Loc_to_glob3 functions to deal with some problems when the local longitudinal axis is parallel to the global Y or Z axes. The IP2 spreadsheet, including the revised functions, can be downloaded from: … Continue reading

Posted in Coordinate Geometry, Excel, Finite Element Analysis, Frame Analysis, Newton, UDFs, VBA
Tagged Excel, global axes, Glob_to_Loc3, local axes, Loc_to_Glob3, UDF, VBA
6 Comments

## Nearest Lookup Function

The Excel Lookup functions (including VLookup, HLookup and Match) all allow for an “exact” or “closest” match on numerical data, but the closest option has a number of problems: The data must be sorted For VLookup and HLookup the data … Continue reading

Posted in Coordinate Geometry, Excel, Maths, UDFs, VBA
Tagged Dist, Excel, HLookup, Match/Index, Nearest, Problems with Lookups, UDF, VBA, VLookup
2 Comments