Go Back   IceInSpace > Equipment > ATM and DIY Projects

Reply
 
Thread Tools Rate Thread
  #1  
Old 26-10-2017, 07:45 AM
Astrofriend's Avatar
Astrofriend (Lars)
Registered User

Astrofriend is offline
 
Join Date: Aug 2017
Location: Stockholm, Sweden
Posts: 439
Excel Astronomy calculations

Over the years I have done a lot of Excel calculation to solve my astronomy problem when I try to make parts work together. Most of them has been my private and only in Swedish, some of them I have published on a Swedish forum and I believe some people have found them useful.

Now I decided to translate them into English and put them on my homepage for downloading.

It's always hard to understand Excel sheets that others have put together, but I hope that these ones with a little help of the instructions on my homepage could be interesting and useful to some of you.

http://astrofriend.eu/astronomy/astr...culations.html

Beware that it could be something wrong in the calculations, if I find something I try to correct it.

I don't take any responsible of it, you use them at your own risk !

/Lars
Reply With Quote
  #2  
Old 26-10-2017, 08:24 AM
bojan's Avatar
bojan
amateur

bojan is offline
 
Join Date: Jul 2006
Location: Mt Waverley, VIC
Posts: 6,932
Awesome, thank you!
I am sure there will be something useful for me there.
Reply With Quote
  #3  
Old 26-10-2017, 10:03 PM
Crux's Avatar
Crux (Hayden)
Registered User

Crux is offline
 
Join Date: Apr 2010
Location: Adelaide, Australia
Posts: 21
Lars,

Thank you for the work you have done on this and making it available to the community.
Reply With Quote
  #4  
Old 20-12-2017, 12:04 AM
Astrofriend's Avatar
Astrofriend (Lars)
Registered User

Astrofriend is offline
 
Join Date: Aug 2017
Location: Stockholm, Sweden
Posts: 439
Hi,
Happy to hear that maybe you can find it useful.

Now I'm in the learning process how to do the calculation direct on the web page.

I have started with the first one, which is not in the excel sheet.
In this calculation you find how many pixels a star moves when you have the camera on a tripod (without a motor). It not just calculate for the eclipta, it do it for the DEC angle where the center of sensor is pointing, and the bottom an top of the sensor along the DEC axis. The last two could be important when having wide angle lenses.

Take a look:
http://astrofriend.eu/astronomy/astr...-exposure.html

This is very new for me, what I have understand you must have a HMTL5 compatible web browser.

I will develop it further.

Merry Christmas and a Happy New Year to all of you!

ps.
A curious question from a man living in the northern hemisphere. How do you orient your camera, the top of image to the south pole, which would be most natural, or to the north as the maps are usually orientated in the books?

/Lars
Reply With Quote
  #5  
Old 20-12-2017, 05:35 AM
bojan's Avatar
bojan
amateur

bojan is offline
 
Join Date: Jul 2006
Location: Mt Waverley, VIC
Posts: 6,932
I think North up is a standard.
Same as geographical maps.
Reply With Quote
  #6  
Old 09-01-2018, 10:06 AM
Astrofriend's Avatar
Astrofriend (Lars)
Registered User

Astrofriend is offline
 
Join Date: Aug 2017
Location: Stockholm, Sweden
Posts: 439
Hi,
Get correct focus is always tricky, sometimes the automatic focus function works, sometimes not. Not uncommon that I spend one hour to find the optimal focus point. Now I have done this excel sheet that could assist me. It's still in development process.

I have added a new excel sheet, this one will calculate where the best focus is from a table of your focus positions and FWHM numbers. It fit a second degree polynomial to your numbers and find the focus point even if it's between your numbers.

If you have temperature compensation activated it's better to deactivate it during this process.

http://www.astrofriend.eu/astronomy/...ons-excel.html

/Lars
Reply With Quote
  #7  
Old 29-01-2018, 10:15 AM
Astrofriend's Avatar
Astrofriend (Lars)
Registered User

Astrofriend is offline
 
Join Date: Aug 2017
Location: Stockholm, Sweden
Posts: 439
The last days has been productive, I have now transformed one more page of my Excel sheets, the Light Pollution calculator to a new Web Calculator page.

I added a lot of new links with information, and also now tested that the calculation was correct, It at least look that now.

You can read more here if you find it interesting:
http://www.astrofriend.eu/astronomy/...magnitude.html

I now know that if I move from my balcony to a really dark place the sky background will be 5 magnitudes weaker or 1/100 of the flux. At the summer house I gain 3.6 magnitudes a typical night.

/Lars
Reply With Quote
Reply

Bookmarks

Tags
calculation, excel, optics, telescope

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +10. The time is now 06:55 PM.

Powered by vBulletin Version 3.8.7 | Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Advertisement
Testar
Advertisement
Bintel
Advertisement