Alright, I have some ridiculously simple formulas which are not giving me the correct answer. They are for calculating "Motion in Space" of a star over long periods of time. I'll try to type out the formulas I was given here, then post pics of my spreadsheet formulas and answers.
Here goes...
x = r cos theta cos alpha
y = r cos theta sin alpha
z = r sin theta
then
delta x = (x/r) delta r - z delta theta cos alpha - y delta alpha
delta y = (y/r) delta r - z delta theta sin alpha + x delta alpha
delta z = (z/r) delta r + r delta theta cos theta
then
x' = x + t delta x
y' = y + t delta y
z' = z + t delta z
then
tan alpha = y' / x'
tan theta = z' / sqrt ( x'^2 + y'^2 )
Now, lets see if I can load the pics. First my formulae then the answers I get. My problem is in the section labeled Motion in Space. The answers I should get are at the end of that section in column G. The constants are all above in blue.
Thanks, Scott
Edit: I added a better pic of my answers showing row and column designations. AND "t" is mis-labeled above. So I know it is cell "D13" not "D14". So forget that obvious one.
Bookmarks