Satellite Pointing Spreadsheet

[bpalone]

I put this spreadsheet together so that I would have aiming information without access to internet. There could be any number of reasons for not having internet access at a site. It could be a remote cabin or could be that you are camping in an area that does not have cell service or land line access for dial up.

All you need is your latitude, longitude and magnetic declination. Insert that data and you have pointing data for all the listed satellites. They can be changed, so it is flexible.

Hope it is of help to someone other than myself.

 

[FTA4PA]

Nice work! Thanks!

 

[KE4EST]

Wow thanks!

 

[iBoston]

Fantastic.. Thank you!

 

[migold]

Thanks, looks helpful.

 

[lost_mesa]

Really appreciate this. Works great in OpenOffice and it was easy to add a few more satellites.

 

[mc6809e]

Thanks. Very handy to have.

 

[RimaNTSS]

bpalone Good job! How it is possible to enter Eastern arc satellites? I used to use Satellite Antenna Alignment (SAA) program for calculations. It also works without internet, but should be installed locally.
On screenshot you can see that your spreadsheet and SAA make same calculations.

 

[a33]

bpalone:
I had such a spreadsheet, but without the calculation of (theoretical) skew!

So this is a usefull completion!
Just a few satellites have deviant skew (the 3 Astras in Europe I believe, and two satellites for New Zealand I read recently), but most follow the theoretical skew as far as I know. Do all in the United States?

And nice to have the theoretical basis for the formulas. I always wondered where the value 0.1513 came from, and if it was a metric number or a milage number, or indifferent. It's indifferent, I now know, so the formula is 'universal'!

Greetz,
A33

RimaNTSS : Adding Eastern satellites shoudn't be difficult. Have you tried negative numbers?
Maybe we have to change the spreadsheet a little to be convenient to european use .

 

[bpalone]

RimmaNTSS and A33,

On the first page of the geosynch.pdf note the asterisk (*) at the end of the definition of "L". The only asterisk I found was at the bottom of that page under the first column. That might apply to Eastern satellites, didn't check, as I was scratching my own itch, which is Western arc.

Everyone, is very welcome. Thought it might be of interest to others. Glad it is of use.

 

[Mr Tony]

very cool

 

[FaT Air]

but most follow the theoretical skew as far as I know. Do all in the United States?

They do now, since AMC-3 has been replaced with SES-3 (only the Ku was 'wonky' on AMC-3, C band was 'normal'))