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! 

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

Views: 247

See Your Saved Posts Timeline

Download Survey Documents-Members Only
Was this resource helpful? Show your appreciation with a comment below. 

Donations are how we exist and grow for the surveying community worldwide.

☇ Reply to this

Replies to This Discussion

 H i,Joseph.

I do not have it in Excell,so this may not be any help but may be you can use some of it.

it has a lot of Information that you can use.programs from Two calculators,I also have a third.

This includes how to do It,Plus a star shot during the Day,which I have never done, because of the ability to be able to see it,from where you are located,You need a very clear sky.A powerful TS,but it does work and Has more Accuracy than a Solar Observation. We are talking sec.  Solar Observations is a lost art since GPS,but they are sometimes still required on surveys. But here is this link where you will find many more. I have it for PC written in C and C++, But I will have to go through my Files to find,so maybe not.

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

You may also find something helpful here.

https://rplstoday.com/community/threads/solar-observation-program.2...

Hi Belly, 

I hope you can find and share it with me. Yes it is seldom used but our laws has never been change for more thank 30 years heheheh, rules and regulations required us to do solar observation and submit it with as part of the survey returns. Thank you br!

 Hi Joseph,  Have you done a search on the web, for Excell programs for this.

You may find some older ones too. Look here for your Grid programs. and they may have 

a Solar/Star program for a computer too, did you see the Dropbox programs at RPLS.

I do all of these on HP calculators or DC's as you could see in my Discussion. 

https://www.ngs.noaa.gov/PC_PROD/pc_prod.shtml

Hi Joseph, If I can get this to work. look here or do a search at Noaa NGS. for Solar Observations.

https://search.usa.gov/search?affiliate=nationalgeodeticsurvey&...

 Hi Joseph,

There is information on all the links I gave you you need to look at all or you will miss something that you need to know. Also I like to lets you know. If I could see your notes in English, Then I could calculate your Azimuth's too. Just show me your Raw notes,before you solve them.

This would let you know if everything is correct. You need a manual for the Hp 41 CX calculator. Knowing how to type in the codes is no simple matter.

Knowing the difference on what is a name or Prompt or a command and typing each of these, which one's have to be EXQ  alpha command's because some are key commands and others are program command keys.

This calculator has 6 key boards,you are only seeing 2 of them.the Input key board and only half of the Alpha keyboard because the lower case alpha is on the back of the calculator.  So this is no easy matter. This calculator also has indirectly accessing memory key board that indirectly addressing registers above 99 ,this is called IND in this calculator also IDAM or short IAM on others,but it's first name was IND this was for Indirect.

 Have you tried the RPLS page they are through working on the site.

I think you can view without signing in, but this page has a email address

form one of the members he says that he has the excel spreadsheet for this calculation and gave his email. You could check with him. the email may still work.

If you can not view this page let me know. the member is jlwahl read what he says.

The Sokkia Book is most important, look how they keep the field notes,Getting the correct time,your stop watch readings and UT1 time known as Leap seconds adjustment value. Best time of the day to do this and all the other data you need to do this. Also there are HP 41CX Emulators for phones,tablets or pads and even one on a laptop,same program on a PC"s can be taken to the field. But keeping field notes is also important,so it does not matter where you calculate it .It is just convenient to do it in the field, if you need this Azimuth to keep working.

Keep me in touch and if you need some help on the calculator.

https://rplstoday.com/community/threads/solar-observation-program.2...

Hi Billy, 

I visited rpls website and found some old dos base program and in 32 bit. It doesnt work to windows 7 64bit. 

 No Joseph,

That is not it, I saw that too. This is excel spreadsheet.Since he posted his on email address, I will give it to you his member name is jlwahl ,look and you will find his post.

his email,

PS jwahl@qubicle.com

Discussion in 'Surveying & Geomatics' started by Gerry PenaAug 18, 2014.

Solar Observation Program

My GPS conked on me during a survey so I had to use solar observations to determine the azimuth of survey. Upon reaching the office, I could not find the software that I use to compute the azimuth. Apparently last time I used it was maybe before 2008! Since then my PC has changed & reformatted several times & I may have missed backing the software up.

Any of you guys recommend a freeware? I recorded the time, hor angle & vertical angle of the 4 sides of the sun.
Thanks.

Reply

I have an excel spreadsheet to compute hour angle. One version automatically provides ephem data for this current year.

If interested, shoot me an email.

PS jwahl@qubicle.com

He last logged in in june 16,2016

 See if you contact  him,first, if not, I will try since i am a member.

Hi Billy, 

Successfully sent a message to him. Thank you.

 Hey joseph ,

I tried, but we might still find some yet. I will see what I can find out.

you would think that someone would have this in excel. I am a member to a lot of computer programming site too. There was also a site for on line calculation

also,but if you learn how to do it on the 41 this is still possible. I tried to make you my associate ,but can not get it to work for along time, you can try,then we would have better access to talk to each other. I am still looking.

Hi Joseph,There is a way to do this,if you have no other way.You can download a HP 41cx calculator Emulator and Enter my program on it. Then your problem is solve ,you would have a HP41 Cx calculator on your computer if you think you can enter this program on it. you would have to have every thing else. A sun Filter for your TS,a accurate watch and the Celestial  Observation handbook and Ephemeris for 2017.

The hard part would be entering the program.I do not know if you have used a RPN calculator before

and this program is alphanumeric RPN  programming. Casio has a Hour Angle program too,but I do not know where you would find it,If you use Casio calculators. But having a HP 41 CX on your computer is a plus anyway even if you do not do this.This short version is 132 lines AZ011.

Good day Billy, 

Where can I download HP41cx calculator and your solar computation program? Thank you so much.

RSS

Where Thousands of Professional Land Surveyors, Students of Surveying and Educators are United through Collaborative Knowledge and Purpose.

Dedicated to the Memory of Skip Farrow (1953-2015)

+ Surveyor Sharer

Drag Button to bookmark bar and view submitted links here.Will soon be moved to a directory

AFGHANISTAN SURVEYORS ALBANIA SURVEYORS ALGERIA SURVEYORS AMERICAN SAMOA SURVEYORS ANDORRA SURVEYORS
ANGOLA SURVEYORS ANGUILLA SURVEYORS ANTIGUA & BARBUDA SURVEYORS ARGENTINA SURVEYORS ARMENIA SURVEYORS
ARUBA SURVEYORS AUSTRALIA SURVEYORS AUSTRIA SURVEYORS AZERBAIJAN SURVEYORS BAHAMAS SURVEYORS
BAHRAIN SURVEYORS BANGLADESH SURVEYORS BARBADOS SURVEYORS BELARUS SURVEYORS BELGIUM SURVEYORS
BELIZE SURVEYORS BENIN SURVEYORS BERMUDA SURVEYORS BHUTAN SURVEYORS BOLIVIA SURVEYORS
BOSNIA & HERZEGOWINA SURVEYORS BOTSWANA SURVEYORS BRAZIL SURVEYORS BRITISH INDIAN OCEAN TERRITORY SURVEYORS
BRUNEI DARUSSALAM SURVEYORS BULGARIA SURVEYORS BURKINA FASO SURVEYORS BURUNDI SURVEYORS CAMBODIA SURVEYORS
CAMEROON SURVEYORS CANADA SURVEYORS CAPE VERDE SURVEYORS CAYMAN ISLANDS SURVEYORS CENTRAL AFRICAN REPUBLIC SURVEYORS
CHAD SURVEYORS CHILE SURVEYORS CHINA SURVEYORS COLOMBIA SURVEYORS COMOROS SURVEYORS
CONGO SURVEYORS DEMOCRATIC REPUBLIC OF THE CONGO SURVEYORS COOK ISLANDS SURVEYORS COSTA RICA SURVEYORS COTE D'IVOIRE SURVEYORS
CROATIA SURVEYORS CUBA SURVEYORS CURACAO SURVEYORS CYPRUS SURVEYORS CZECH REPUBLIC SURVEYORS
DENMARK SURVEYORS DJIBOUTI SURVEYORS DOMINICA SURVEYORS DOMINICAN REPUBLIC SURVEYORS ECUADOR SURVEYORS
EGYPT SURVEYORS EL SALVADOR SURVEYORS EQUATORIAL GUINEA SURVEYORS ERITREA SURVEYORS ESTONIA SURVEYORS
ETHIOPIA SURVEYORS EUROPEAN UNION SURVEYORS FAROE ISLANDS SURVEYORS FIJI SURVEYORS FINLAND SURVEYORS
FRANCE SURVEYORS FRENCH GUIANA SURVEYORS FRENCH POLYNESIA SURVEYORS GABON SURVEYORS GAMBIA SURVEYORS
GEORGIA SURVEYORS GERMANY SURVEYORS GHANA SURVEYORS GIBRALTAR SURVEYORS GREECE SURVEYORS
GREENLAND SURVEYORS GRENADA SURVEYORS GUADELOUPE SURVEYORS GUAM SURVEYORS GUATEMALA SURVEYORS
GUERNSEY SURVEYORS GUINEA SURVEYORS GUINEA-BISSAU SURVEYORS GUYANA SURVEYORS HAITI SURVEYORS
HOLY SEE SURVEYORS HONDURAS SURVEYORS HONG KONG SURVEYORS HUNGARY SURVEYORS ICELAND SURVEYORS
INDIA SURVEYORS INDONESIA SURVEYORS IRAN SURVEYORS IRAQ SURVEYORS IRELAND SURVEYORS
ISLE OF MAN SURVEYORS ISRAEL SURVEYORS ITALY SURVEYORS JAMAICA SURVEYORS JAPAN SURVEYORS
JERSEY SURVEYORS JORDAN SURVEYORS KAZAKHSTAN SURVEYORS KENYA SURVEYORS KIRIBATI SURVEYORS
KOREA SURVEYORS KOREA REPUBLIC OF SURVEYORS KUWAIT SURVEYORS KYRGYZSTAN SURVEYORS LAO PEOPLE'S DEMOCRATIC REPUBLIC SURVEYORS
LATVIA SURVEYORS LEBANON SURVEYORS LESOTHO SURVEYORS LIBERIA SURVEYORS LIBYAN ARAB JAMAHIRIYA SURVEYORS
LIECHTENSTEIN SURVEYORS LITHUANIA SURVEYORS LUXEMBOURG SURVEYORS MACAU SURVEYORS MACEDONIA SURVEYORS
MADAGASCAR SURVEYORS MALAWI SURVEYORS MALAYSIA SURVEYORS MALDIVES SURVEYORS MALI SURVEYORS
MALTA SURVEYORS MARSHALL ISLANDS SURVEYORS MARTINIQUE SURVEYORS MAURITANIA SURVEYORS MAURITIUS SURVEYORS
MAYOTTE SURVEYORS MEXICO SURVEYORS MICRONESIA SURVEYORS MOLDOVA SURVEYORS MONACO SURVEYORS
MONGOLIA SURVEYORS MONTENEGRO SURVEYORS MONTSERRAT SURVEYORS MOROCCO SURVEYORS MOZAMBIQUE SURVEYORS
MYANMAR SURVEYORS NAMIBIA SURVEYORS NAURU SURVEYORS NEPAL SURVEYORS NETHERLANDS SURVEYORS
NEW CALEDONIA SURVEYORS NEW ZEALAND SURVEYORS NICARAGUA SURVEYORS NIGER SURVEYORS NIGERIA SURVEYORS
NIUE SURVEYORS NON-SPEC ASIA PAS LOCATION SURVEYORS NORFOLK ISLAND SURVEYORS NORTHERN MARIANA ISLANDS SURVEYORS NORWAY SURVEYORS
OMAN SURVEYORS PAKISTAN SURVEYORS PALAU SURVEYORS PALESTINIAN TERRITORY OCCUPIED SURVEYORS PANAMA SURVEYORS
PAPUA NEW GUINEA SURVEYORS PARAGUAY SURVEYORS PERU SURVEYORS PHILIPPINES SURVEYORS POLAND SURVEYORS
PORTUGAL SURVEYORS PUERTO RICO SURVEYORS QATAR SURVEYORS RESERVED SURVEYORS REUNION SURVEYORS
ROMANIA SURVEYORS RUSSIAN FEDERATION SURVEYORS RWANDA SURVEYORS SAINT KITTS & NEVIS SURVEYORS SAINT LUCIA SURVEYORS
SAINT MARTIN SURVEYORS SAINT VINCENT & THE GRENADINES SURVEYORS SAMOA SURVEYORS SAN MARINO SURVEYORS SAO TOME & PRINCIPE SURVEYORS
SAUDI ARABIA SURVEYORS SENEGAL SURVEYORS SERBIA SURVEYORS SEYCHELLES SURVEYORS SIERRA LEONE SURVEYORS
SINGAPORE SURVEYORS SINT MAARTEN SURVEYORS SLOVAKIA (SLOVAK REPUBLIC) SURVEYORS SLOVENIA SURVEYORS SOLOMON ISLANDS SURVEYORS
SOMALIA SURVEYORS SOUTH AFRICA SURVEYORS SOUTH SUDAN SURVEYORS SPAIN SURVEYORS SRI LANKA SURVEYORS
ST. PIERRE AND MIQUELON SURVEYORS SUDAN SURVEYORS SURINAME SURVEYORS SWAZILAND SURVEYORS SWEDEN SURVEYORS
SWITZERLAND SURVEYORS SYRIAN ARAB REPUBLIC SURVEYORS TAIWAN; REPUBLIC OF CHINA (ROC) SURVEYORS TAJIKISTAN SURVEYORS TANZANIA UNITED REPUBLIC OF SURVEYORS
THAILAND SURVEYORS TIMOR-LESTE SURVEYORS TOGO SURVEYORS TOKELAU SURVEYORS TONGA SURVEYORS
TRINIDAD AND TOBAGO SURVEYORS TUNISIA SURVEYORS TURKEY SURVEYORS TURKMENISTAN SURVEYORS TURKS AND CAICOS ISLANDS SURVEYORS
TUVALU SURVEYORS UGANDA SURVEYORS UKRAINE SURVEYORS UNITED ARAB EMIRATES SURVEYORS UNITED KINGDOM SURVEYORS
UNITED STATES SURVEYORS URUGUAY SURVEYORS UZBEKISTAN SURVEYORS VANUATU SURVEYORS VENEZUELA SURVEYORS
VIET NAM SURVEYORS VIRGIN ISLANDS (BRITISH) SURVEYORS VIRGIN ISLANDS (U.S.) SURVEYORS WALLIS AND FUTUNA ISLANDS SURVEYORS YEMEN SURVEYORS
ZAMBIA SURVEYORS ZIMBABWE SURVEYORS SURVEYORS

Location Based Surveying Practices

Land Surveyors United is the world's FIRST Global Social Network for geospatial professionals. We have dedicated, geolocated support groups for practically every country, continent and state on earth, for you to utilize for building your personal network. We are all essentially concerned with the same issues, no matter where we are located on earth. However, surveying practices and methods vary depending on the geographic location where we work. If you have noticed similarities and differences between the conditions, laws and practices between two or more areas of the world,discuss it in this forum. Build your reputation online by posting relevant discussions in your local group below.

Join and Introduce Yourself in Your Local Geosocial Forum:

Alabama Alaska Arizona Arkansas California
Colorado Connecticut Delaware Florida Georgia
Hawaii Idaho Illinois Indiana Iowa
Kansas Kentucky Louisiana Maine Maryland
Massachusetts Michigan Minnesota Mississippi Missouri
Montana Nebraska Nevada New Hampshire New Jersey
New Mexico New York North Carolina North Dakota Ohio
Oklahoma Oregon Pennsylvania Rhode Island South Carolina
South Dakota Tennessee Texas Utah Vermont
Virginia Washington West Virginia Wisconsin Wyoming

Not based in the US? Here are other groups for surveyors around the world to join and contribute knowledge and experiences as a land surveyor:

Africa Asia Australia Europe Russia Canada
Antarctica S.America N. America India Malaysia Caribbean

And more... Find your group forum based on location.

Choose Your Equipment Group Here

Handheld US Social Support for Land SurveyorsNIKON Social Support for Land SurveyorsTrimble Social Support for Land SurveyorsTopcon Social Support for Land SurveyorsSokkia Social Support for Land SurveyorsAshtech Social Support for Land SurveyorsNAVCOM Social Support for Land SurveyorsMagellan Social Support for Land SurveyorsLeica Social Support for Land SurveyorsAltus Positioning Social Support for Land SurveyorsMicroSurvey Social Support for Land SurveyorsJuniper Systems Social Support for Land SurveyorsTraverse PC Social Support for Land SurveyorsCarlson Software Social Support for Land Surveyors

what where  
job title, keywords or company
city, state or zip jobs by job search

PLEASE DONATE TODAY. Your generosity preserves surveying and mapping knowledge for future generations. Thank you.

Survey Equipment Troubles?

Geo Visitors Map

Choose Your Group Here

Surveying Equipment Support for Leica, Carlson, Sokkia, Trimble, Topcon, Altus, Nikon equipment


Surveyor Birthdays

© 2017   © Created by Land Surveyors United   Powered by

Badges  |  Contact LSU  |  Privacy Policy  |  Terms of Service

Live Support