# sphere

1. ### Globe Coordinate Prediction

Hello my fellow excel people, I'm trying to predict latitude and longitude coordinates within 2 predefined points. If this was a 2D problem then I'm sweet, but it gets tricky with the curvature of the earth (anti flat earther). Once point A & B have been set i want to basically be able to...
2. ### Scan and Copy

Hello! I will start by saying that I don't really know anything about coding or VBA...other than copying the help all of you have given me in the past to a new module and connecting that to a button. So! I'm hoping someone here will find this ridiculously simple and be able to help me. I have...
3. ### Surface areas of a scalene ellipsoid and sphere

Hi all, I was hoping someone could help me out with Excel formulas for calculating the surface areas of a scalene ellipsoid and sphere: The equation are as follows, just not sure how to enter them into Excel. The scalene ellipsoid formula I wish to use 4PI[(apbp+apcp+bpcp/3]1/p p is...
4. ### Lookup with multiple variable

I have the following sample database starting with A1 as the 1st column heading: <colgroup><col><col><col span="5"></colgroup><tbody> Colour Shape Taste Blank Colour Shape Taste Red Sphere Sweet Red Sphere Blue Triangle Bitter Blue Triangle Green Square Hot Green Square...
5. ### Center of Sphere calculation

I have two questions" 1. Given 4 points and the radius, how can I find the center of a sphere? What's the least costly way when programmed in excel vba? 2. Same as 1. but this time only given 3 points and a radius. Thanks in advance!

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back