Re: [GZG] Space, Excel, and the reoccuring project

It will be a bit later in the day before I can get to Excel to check,
but
sounds good, and I've OpenOffice at the shoppe even later, so no problem
there!.

I know how difficult it can be to write with vague specs. ;->=

Thanks!

The_Beast

Roger Burton West wrote on 03/31/2011 06:50:26 AM:

> On Mon, Mar 21, 2011 at 10:31:29PM +0000, Roger Burton West wrote:
>
> >Coordinate transformations are relatively easy. I'll see what I can
> >knock together.
>
> OK, here's a coordinate transformer.
>
> http://firedrake.org/roger/ft/coordtransform.ods
> http://firedrake.org/roger/ft/coordtransform.xls
>
> I wrote it in OpenOffice; I don't do Windows, so I have no idea how
well
> it'll work under Excel.
>
> Put into the first column of cells the XYZ coordinates of your base
> system, and the rotation angles you want to use (these are Euler
angles,
> http://en.wikipedia.org/wiki/Euler_angles - if you don't care, just
put
> a value from -180 to +180 into each cell).
>
> The rows at the bottom show star system names and coordinates -
> paste in pre-transformation on the left, get post-transformation on
the
> right. (Ignore the "1" column in each case.) Duplicate the last row to
> get more stars.
>
> You'll probably want to reformat the numbers! This isn't meant to be
> pretty, just to get the job done reasonably quickly.
>
> Is this roughly the sort of thing you were after?
>
> Roger

_______________________________________________
Gzg-l mailing list
Gzg-l@mail.csua.berkeley.edu
http://mail.csua.berkeley.edu:8080/mailman/listinfo/gzg-l