The quickest decimal to DMS convertion in Excel

Coordinates DMS to decimal and decimal to DMS one cell only Excel

Suppose you work on geographical or astronomical projects requiring transformation between the decimal and degree-minute-second pattern. You probably want to have everything converted as quickly as possible. On the web, some tutorials explain that the most common solution is using the Data -> Text to Columns with the main ribbon. Another way presented in the … Read more

Happy New Year 2025 to everyone

Happy New Year 2025

You might have noticed the long inactivity if you read articles on my website regularly. The last serious article was about the lunar standstill and the entire website went quiet. What is the reason behind it? For over 8 years of running this blog/website I did my best to provide the original approach for various … Read more

Major lunar standstill and moonrise/moonset azimuth fluctuations

Polichna Udeuschle Moonset

The text explains the rare phenomenon, in which the azimuths of moonrise and moonset are more extreme. This situation allows us to see distant landscape features with the lunar disk beyond. Learn more about the lunar standstill and its frequency across the centuries. The changes in moonrise/moonset azimuths can give you a clue of how some Megalithic constructions have been set and how the Moon’s path across the sky would have looked like thousands of years before. Moreover, the declination of the Moon isn’t the same. It changes significantly because of the parallax.

Read more

UK Address sanitizer in Excel 365

UK Address sanitizer tool

This article will shortly describe the tool I needed to develop recently. It is aimed at addressing cleansing. The general lists of addresses are often messy. It means, that the components of the address aren’t ordered well amidst various spaces and commas in the wrong places. It eventually excludes these addresses from proper geocoding and … Read more

Solar eclipse below the horizon – the observation guideline

Solar eclipse below the horizon observation pattern

The 2024 total solar eclipse is coming. Anyone interested will be in North America. We cannot forget about the people, who live or will temporarily stay in Western Europe on the day when the event occurs. Therefore I decided to prepare the text, which presents the guideline for this specific kind of observation. The guideline … Read more

Czym jest tranzycja swiatła? Jakie przykłady możemy zobaczyć?

Światło jest wszechobecne we Wszechświecie oraz środowisku. Jest to promieniowanie elektromagnetyczne wykrywalne przez ludzkie oko. Więcej na temat światła jak i podstawowych sposobów jego pomiaru napisałem tutaj. Teraz chciałbym opisać bardzo powszechne zjawisko, które występuje zarówno w kosmosie jak i w atmosferze ziemskiej jakim jest tranzycja światła. Ten artykuł prezentuje znaczne uproszczenie tego zjawiska,  gdyż  … Read more

Nikon D5300 the first impression

Nikon D5300

I have been taking photos for 10 years. Exactly 10 years and 5 days ago my mother bought me my first camera Canon Powershot A540. I was very, very happy. I use to use that model for over 5 years till November 2011, when finally the camera was down after 84,5k shoots. Sounds impressive, however, … Read more

Witam wszystkich! (Welcome everybody!)

Zdecydowałem dzielić się moimi oryginalnymi przemyśleniami z Wami. Jeśli jesteś zainteresowany przeglądnij poszczególne artykuły by dowiedzieć się więcej. I decided to share my original ideas with you! If you are interested check out the following articles to find more.