Geo Stars Library  0.9.3
Geodetic and Astrometry library
geoStarsExcel.h
Go to the documentation of this file.
1 /*!
2 \file geoStarsExcel.h
3 \brief This file documents the Microsoft Excel file that contains macros to link to
4  geoStarsLib.dll. This file tests some of the functions in geoStarsLib by
5  exercising site conversion information.
6 
7 \section xls Excel functions available through the DLL
8 
9 The file geo.xls contains a Microsoft Excel spreadsheet employing some of the functions
10 of geoStarsLib. It is meant as an example of how to call the DLL functions directly from Excel.
11 
12 Here are the steps to use this file and/or incorporate the functions into your own spreadsheet.
13 
14  1. Load geoStars.bas into Excel via the Visual Basic Editor
15 
16  - Choose Tools->Macros->Visual Basic Editor
17 \image html geoExcelMenu.jpg "Opening the VB editor"
18 
19  - From the editor choose File->Import File
20 \image html geoExcelImport.jpg "Importing the gelStars.bas file"
21 
22  2. call the functions directly. These functions are used in this example:
23  - geoDms2DD() - Degrees Minutes Seconds to Decimal Degrees conversion
24  - geoLlh2E() - Latitude, Longitude, and Height converted to E component of earth fixed coordinates
25  - geoLlh2F() - Latitude, Longitude, and Height converted to F component of earth fixed coordinates
26  - geoLlh2G() - Latitude, Longitude, and Height converted to G component of earth fixed coordinates
27  - geoMagGetDecNow() - get the current magnetic north of a site
28  - geoSunNowAz() - get the azimuth angle of the sun at the current location and time
29  - geoSunNowEl() - get the elevation angle of the sun at the current location and time
30  - geoLlh2DiffX() - Latitude, Longitude, and Height converted to East component of local plane (tangential)
31  - geoLlh2DiffY() - Latitude, Longitude, and Height converted to North component of local plane (tangential)
32  - geoLlh2DiffX() - Latitude, Longitude, and Height converted to Up component of local plane (tangential)
33  - geoXyz2A() - convert the East, North, and Up (X,Y,Z) of a site to polar coordinates - Azimuth
34  - geoXyz2E() - convert the East, North, and Up (X,Y,Z) of a site to polar coordinates - Elevation
35  - geoXyz2R() - convert the East, North, and Up (X,Y,Z) of a site to polar coordinates - Range
36 
37 Most of these calls are condensed into structured in the main library. However, breaking these out into
38 separate components allows Excel to call them directly by mere mortals.
39 
40 \image html geoExcel.jpg "Excel test program"
41 
42 
43 
44 */