This Excel workbook is composed of 4 worksheets (UNIT, AIR, SEP, GEOC) and 1 data sheet (DB). ‘UNIT’ sheet is for converting measuring units back and forth. ‘AIR’ sheet is for computing aeronautical values such as air speeds, rate of turns, wind triangles, etc. ‘SEP’ sheet is just for reference to ATC related procedural separations.
GEOC is the main and maybe the most useful tool especially for flight simmers as well as for aeronautical procedure designers. It provides 11 functions each of which is used for essential calculations of aeronautical matters such as airport or airspace constructions.
Those functions may give you a great assistance with ‘topnotch’ precision when you make or modify the data of flight sim sceneries.
Version History with Major Updates
1.0 (2021-08-03) The first upload.
> FIXED ‘CLEAR’ button of SCRATCHPAD in GEOC sheet.
> ADDED error recovery for some buttons in SEP sheet.
> EDITED several comments through workbook.
> FIXED auto ID naming scheme on hand-input coordinates in GEOC sheet.
> CHANGED label in DB sheet (‘DATABASE’ => ‘USER DATABASE’)
> ADDED ‘MAKE DAW’ button to DB sheet and job to make AIRAC database.
> ADDED job of GEOC to back up external files.
> ADDED folders ‘AIRAC’ and ‘BAK’ for the jobs above.
> FIXED retrieved data information cell in GEOC sheet.
> FIXED bug on ATD value in TANGENT menu of GEOC sheet.
> FIXED abort function of ‘MAKE DAW’
> ADDED basic format check routines for saving CSV files.
> CHANGED comp example to the instance of ILS offset in “Readme”.
> MODIFIED copy & paste functions.
> CHANGED symbols of coordinate format and distance in GEOC sheet.
> FIXED bug on editing DB sheet.
> MODIFIED and trimmed program codes to improve integrity.