sphere

  1. M

    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. I

    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. F

    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. M

    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. H

    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!

Watch MrExcel Video

This Week's Hot Topics

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top