User defined function for transformation of ellipsoidal coordinates

User defined funkcija za transformaciju elipsoidnih koordinata

  • Aleksandar Ganić University of Belgrade – Faculty of Mining and Geology
  • Aleksandar Milutinović University of Belgrade – Faculty of Mining and Geology
  • Meri Ganić University of Belgrade – Faculty of Mining and Geology
Keywords: WGS84; Bessel ellipsoid; transformation of coordinates


  The topographic plane of the Earth has irregular shape, and for the purpose of mathematical defining, it is to be approximated by rotational ellipsoid. As local geodetic datum, rotational ellipsoids of various sizes are used in the world. More widely usage of the GPS while performing surveying tasks has resulted in the need to define global geodetic datum in order to obtain the best approximation the entire Earth. For this purpose, geocentric rotational ellipsoid WGS84 was defined and the results of the GPS measurements are shown in relation to it. By applying the appropriate equations, the ellipsoidal coordinates are being transformed from WGS84 into the coordinates on the local rotational ellipsoid, i.e. on the view plane. The paper shows User Defined Function created for Excel, by which the coordinates in the territory of Belgrade are being transformed from WGS84 of rotational ellipsoid into the Gauss-Krüger projection plane.


BOŽIĆ, B. (2001) Globalni sistem pozicioniranja. Beograd: Viša građevinsko-geodetska škola.

BOŽIĆ, B. (2006) Geodetski premer 1. Beograd: Univerzitet u Beogradu - Građevinski fakultet.

BULATOVIĆ, V. (2013) Komunalni informacioni sistemi i njihova primena. Novi Sad: Univerzitet u Novom Sadu - Fakultet tehničkih nauka.

FRENCH, G. (1996) Understanding the GPS. Bethesda: GeoResearch Inc.

GANIĆ, A. et al. (2012) The new state reference system of the Republic of Serbia and division into map and layout series. Underground Mining Engineering, 21, pp.177-191.

GANIĆ, M. et al. (2011) Neogene geodynamics in the light of 3-D visualization - an example along the Sava river (Belgrade). In: Proceedings of the 17th Meeting of the Association of European Geological Societies, Belgrade, September 2011. Belgrade: Serbian Geological Society, pp.157-158.

KNEŽEVIĆ, S. et al. (2011) The subsurface geology along the route of the new bridge at Ada Ciganlija Island (Belgrade, Serbia). Anales géologiques de la péninsule Balkanique, 73, pp.9-19.

LIKER, M. et al. (2010) Transformacija DKP-a u HTRS96/TM pomoću jedinstvenog transformacijskog modela. Zbornik radova IV Hrvatski kongres o katastru, Zagreb, veljača 2010. Zagreb: Hrvatsko geodetsko društvo, pp.253-269.

MENDIZABAL, J. et al. (2009) GPS And GALILEO. New York: The McGraw-Hill Companies.

UNIVERSITY OF LJUBLJANA, FACULTY OF CIVIL AND GEODETIC ENGINEERING (2010) Dijagram toka transformacije [WWW]. Available from: [Accessed 07/11/12].

UNIVERSITY OF NOVI SAD, FACULTY OF TECHNICAL SCIENCES (2012) Geoinformacione tehnologije [WWW]. Available from: [Accessed 28/01/13].

VULIĆ, M. and DURGUTOVIĆ, A. (2007) "UDF" for volume calculation with use of "NTF" method. RMZ - Materials and Geoenvironment, 54 (3), pp.412-425.

WALKENBACH, J. (2003) Excel 2003 Bible. Indianapolis: Wiley Publishing, Inc.
How to Cite
Ganić, A., Milutinović, A., & Ganić, M. (2017). User defined function for transformation of ellipsoidal coordinates. Podzemni Radovi, (24), 35-47.