03-11-2020, 04:48 PM
(This post was last modified: 03-11-2020, 05:21 PM by Kiwi.
Edit Reason: Added spreadsheet link
)
I just used the city report information to successfully intercept an asteroid.
Here's the math, I used the Solar System coordinates:
I'm denoting the first angle reported as A, the second angle as B and the distance as D.
I'm also using degrees here. If you're putting this into a spreadsheet it may assume radians so you'll need to multiply the angles by π/180.
One AU is 724205m. The asteroid distance is given in m and we need the coordinates in AU, so that's why the division is there.
Asteroid X = sin(A)*cos(B)*D/724205
Asteroid Y = cos(A)*cos(B)*D/724205
Asteroid Z = sin(B)*D/724205
I'm in the process of putting this into a nice, useable google sheet. I'll update my post when it's done.
Edit: Here it is. Go to "File > Make a copy" so you can use / edit it.
https://docs.google.com/spreadsheets/d/1...sp=sharing
Here's the math, I used the Solar System coordinates:
I'm denoting the first angle reported as A, the second angle as B and the distance as D.
I'm also using degrees here. If you're putting this into a spreadsheet it may assume radians so you'll need to multiply the angles by π/180.
One AU is 724205m. The asteroid distance is given in m and we need the coordinates in AU, so that's why the division is there.
Asteroid X = sin(A)*cos(B)*D/724205
Asteroid Y = cos(A)*cos(B)*D/724205
Asteroid Z = sin(B)*D/724205
I'm in the process of putting this into a nice, useable google sheet. I'll update my post when it's done.
Edit: Here it is. Go to "File > Make a copy" so you can use / edit it.
https://docs.google.com/spreadsheets/d/1...sp=sharing