### Categories

### RSS Feed

### Search NewtonExcelBach

### Archives

### Top Posts

- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Taming Symbols in Excel
- The angle between two vectors, Python version
- Using LINEST for non-linear curve fitting
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- The angle between two vectors, in 2D or 3D
- Fitting high order polynomials
- Arrays vs Collections vs Dictionary Objects (and Dictionary help)

### Recent Comments

josh on Import Data from a Picture to… Melanie Safka + Mile… on Melanie Safka Mohd Yousef on Biaxial bending update DonB on Biaxial bending update Mohd Yousef on Biaxial bending update dougaj4 on Biaxial bending update DonB on Biaxial bending update dougaj4 on Biaxial bending update DonB on Biaxial bending update Mohd Yousef on Biaxial bending update dougaj4 on Beam Fixed End Actions by Maca… Peka Odendaal (@PKOd… on Beam Fixed End Actions by Maca… Gerardo Freyre on The history of the theory of b… dougaj4 on Time in hours and minutes betw… SDAmy on Time in hours and minutes betw…

# Category Archives: Computing – general

## Spherical Geometry and Vincenty’s Formulae

Wikipedia has detailed articles on: Spherical Geometry and Vincenty’s Formulae (for geometric calculations on an ellipsoid). The spreadsheet Vincenty.xlsb uses those resources to perform the following calculations, using both on-sheet calculations and VBA user-defined functions (UDF’s): Calculation of distance and … Continue reading

Posted in Computing - general, Coordinate Geometry, Excel, Maths, Newton, UDFs, VBA
Tagged ellipsoid area, ellipsoid distance, Excel, Spherical Geometry, UDF, VBA, Vincenty's Formulae
Leave a comment

## Import Data from a Picture to Excel

The myOnlineTraininghub blog recently had a post entitled Import Data from a Picture to Excel which sounded promising, since I often need to extract data from Autocad files saved to a pdf. From the link, it seems that if I … Continue reading

Posted in Computing - general, Excel
Tagged Android, Excel, import data from pictures, Windows
1 Comment

## Building dances to an earthquake’s beat

Adam Pascale from the Seismology Research Centre recently shared this animation (click on controls bottom right for High Quality and Full Screen views): … it’s from a building in the Philippines about 130km (hypocentral distance) from a magnitude 6.1 earthquake … Continue reading

Posted in Animation, Computing - general, Newton
Tagged Earthquake animation, Seismology Research Centre
Leave a comment

## Stepping through Python code called from Excel

Setting up your editor to allow Python code debugging for functions called from Excel can be tricky, depending on the details of your editor and linking software, but using the Visual Studio Code Editor and Pyxll, this works for me: … Continue reading

Posted in Computing - general, Excel, Link to Python, PyXLL, UDFs
Tagged Debugging, Excel, Python, PyXLL, Visual studio code
4 Comments

## DigitGraph Spreadsheet and WebPlot Digitiser

I have posted here previously a spreadsheet that allows XY data to be extracted from images of graphs, maps or other images of objects in a single plane: How to digitise a scanned image. I have updated the instructions for the … Continue reading

Posted in Charts, Charts, Computing - general, Curve fitting, Drawing, Excel, UDFs, VBA
Tagged DigitGraph, digitize scanned image, Excel, UDF, VBA, WebPlot Digitizer
5 Comments