Land Surveyors United

Earth's Largest Land Surveyor Community

Solar Observation Program in spreadsheet and program for grid to geographic vice versa

Good day fellows,

I am trying to have a program (maybe in excell/text format) for determining azimuth by solar observation with the details are listed such as set of horizontal readings, altitude, time, mean observations,corrections,hourly variations,npd,p,h,l,s,azimuth etc.

This is needed in the submission of survey return to government agency.

I am also trying to have the geographic to grid conversion and vice versa with the details on the tabulated figures.

Please see the attachment as it is similar to these pictures.

Many thanks to all!

Save This

1 member favorited this

This Content Originally Published by a land surveyor to Land Surveyors United Network

Views: 471

See Your Saved Posts Timeline

∗Was this resource helpful? Show your appreciation with a comment below. Donations are how we exist and grow for the surveying community worldwide.

2.JPG, 53 KB
3.JPG, 62 KB
4.JPG, 100 KB

▶ ☇ Reply to this

Replies to This Discussion

Permalink Reply by joseph Uy on August 19, 2017 at 1:56am

Hi Billy,

I am successful in downloading HP41cx calculator. I am lacking the solar computation program. Thank you.

▶ Reply

Permalink Reply by joseph Uy on August 24, 2017 at 10:49pm

Hi Billy,

Can I have your program so that I will begin to encode the program in the HP41 CX?

▶ Reply

Permalink Reply by Billy Brooks on August 25, 2017 at 7:25pm

Hi Joseph, I just went and look at my program AZSUN , because I was comparing it with a older one for a HP41C and it is corrupted, I do not know how this has happen. When I looked at it the other day for you, I use it to program a real calculator there was nothing wrong with it. Now it is all mess up. ??? Give me time to fix it. I will talk to Justin about this.

▶ Reply

Permalink Reply by Billy Brooks on August 25, 2017 at 9:43pm

Hi Joseph,

I tried to fix it but, the program lines are still not in line like I want them to be . They where correct a few days ago, I do not know what is going on. I will check the program to see if the inputs are correct, but I sent you two files let me know if you can open them.

▶ Reply

Permalink Reply by Billy Brooks on August 19, 2017 at 4:51am

Hi Joseph,First where did you download it some version that have the Survey Pac lose memory when you turn off ,or close out the program. This keeps you from copying the programs that are wrote in ROM encryption because you can copy them and save them in two different place then exit the survey pac. This then lets you see the program without encryption. That is why they do this. Make sure the calculator can close out and reopen without saying Memory Lost. You can have both on your computer one to run the survey pac,and one for your own programs, but that is, if you want one with the survey pac. The PAC has a lot of good survey programs. so maybe later.

I used this one from Educalc.net it is Warren Furlow's, If you think the one you have is good,then keep it.

https://www.educalc.net/326089.page

The programs are in the link I gave you that has the 2008 handbook. you need it because it gives you instruction and examples on how to used this program. I how every also show my version, AZSUN ,the algorithms are the same as in AZ011 they are basically the same program some alpha notation is different but it is the same algorithms,so you get the same answer, They have both been tested.

you will find mine and it is easier to see in my Discussion on page 2 the last reply Oct 8,2016 . The link is at the bottom of this reply.

I also have AZ009 which is the longer version of this program but it is 50 miles from where I live.. I have been meaning to go there and get it and some other material, just have not done it yet. But this one will work.You have to run each Observation one at a time ,my other programs you can take 6 readings and it averages them for you and the calculator keeps the time and angles, you remove the bad before this,but AZ011 will work just as good ,you removed the bad, if any, then average them yourself plus you will be keeping time yourself on a watch so you need the real calculator to use AZ009. So read this discussion

and look at all the links and you will need all the 2017 info,some of the links I gave you give the information for this year. But lets get this program to work first and you doing the examples in the 2008 book. I already give you this link. Joseph there are a lot of Emulators you could be using on your computer the HP 35s and the HP 50 g the 50 g you can get Jacob Wall SGS survey programs

it works like a Data collector he has 3 kinds of programs Cogo LT is Free. You can have all these calculators on your computer Free and if you never used RPN and RPL OSs here is your chance to learn

how to use them. There are tons of survey programs for them.

here is this link again

http://landsurveyorsunited.com/forum/topics/sun-star-shots-astronom...

▶ Reply

Permalink Reply by joseph Uy on August 24, 2017 at 12:21am

Hi Billy,

I downloaded the it on the same link on your message above. Thank you and now I have to study it. I'm still hoping that spreadsheet format for solar computation by tangent quadrant method will be available soon. Sorry late reply.

▶ Reply

Permalink Reply by joseph Uy on August 24, 2017 at 2:44am

Hi Billy,

I visited this site below and found out that there is a program for solar computation but it is no longer available on this site. The program ASTRO*CARD.

http://www.rollanet.org/~eksi/Handbook.htm

▶ Reply

Permalink Reply by Billy Brooks on August 25, 2017 at 5:02am

Hi Joseph,

ASTRO* CARD is a pre-written program similar to the program AZ009 that came on a magnetic card that the HP 41Cx could read if you had a card reader.

The ASTRO*CARD the same or the ASTRO * MOD however came in a computer chip module that plug into one of the ports on the calculator,it had 4. These were like flash cards today. There may be more software on these than has ever been written for any calculator. Even if you had one it will not do you any good because you need the real calculator. HP survey PAC is written in one of these module. They were call MOD, You can download a Emulator that has the survey PAC,but any other program key input is erase when you exit the program. So it can only be used for MOD programs in away. You can still program

but you will lose your keyed in programs,( this is not the Emulator you are using) there is suppose to be away to not lose memory by creating a new directory, but this is in theory ,but any way ASTRO will not help you. It is the same as my program and AZ011, these have to be key input. All these programs in these MOD or ROM protected you can not view every line, HP has the copyrights to them. They are written in encryption code every so many lines.

You already have my program and AZ011 is in the sokkia book in the above link

that you found the ASTRO program. My program is in my Discussion on page 2 the last reply Oct 8,2016 . Look in this discussion you will see it for the HP41 CX on page 2. It is 132 Lines AZSUN

http://landsurveyorsunited.com/forum/topics/sun-star-shots-astronom...

▶ Reply

Permalink Reply by Billy Brooks on August 19, 2017 at 4:53pm

Hi Joseph ,

I was looking thru some of my older files, and found these, thought you might like to see them.

I put them in PDF., so there easy to open.

∗Was this resource helpful? Show your appreciation with a comment below. Donations are how we exist and grow for the surveying community worldwide.

04.pdf, 100 KB
ASTRONOMICALobservationsWithTransit.pdf, 496 KB
AZU_TD_BOX14_E9791_1964_38.pdf, 3.4 MB

▶ Reply

Permalink Reply by Billy Brooks on August 20, 2017 at 1:42am

Hi Joseph, Just wanted to make sure you had these links.This is the Book if you have not found it. The program is also in this book with Instruction and notes. But mine are easier to read. This program is a very advanced program this is Saturn alphanumeric RPN,programming,good luck This is a big jump if you never used a RPN calculator,because this is the most advanced made. I believe I can help you through it.

But this book data is 2008 so you will need 2017 data only, everything else is good.

http://www.rollanet.org/~eksi/Handbook.htm

The one's below has books and N O Time and alot more. look at all of it

Plus Greenwich mt

http://fer3.com/arc/m2.aspx/2008-Sokkia-Celestial-Observation-Handb...

http://aa.usno.navy.mil/data/docs/celnavtable.php

http://tycho.usno.navy.mil/what.html

http://tycho.usno.navy.mil/frontpage.html

https://greenwichmeantime.com

Here are some more links on UT1

https://www.nist.gov/pml/time-and-frequency-division/atomic-standar...

https://www.timeanddate.com/time/aboututc.html