Overview
The main feature ‘GEOC’ may be one of the most useful tools especially for flight simmers as well as for aeronautical procedure designers. It provides 11 functions each of which can be used for essential calculations of aeronautical matters such as airport or airspace constructions. It may help you a lot to calculate waypoint coordinates in planning RNAV-based flight routes. Also, it may give you a great assistance with ‘topnotch’ precision when you create flight sim sceneries.
This workbook contains 3 other tools (UNIT, AIR, SEP). ‘UNIT’ is for converting measuring units back and forth. ‘AIR’ is for computing aeronautical values such as air speeds, rate of turns, wind triangles, etc. ‘SEP’ is for ATC related separation calculations.
How to Start
1. Download and you will get a zip file
2. Extract it and you will see a folder named 'AWBook'
3. Save that folder to any place you like
4. Open it and find an Excel file named 'AWBook.xlsm'
5. Double click it, then the program starts
6. Read 'AWB_Readme.pdf' for a bit more detailed notes
Version History of Recent Major Updates
1.6 (2022-01-04)
> MODIFIED and trimmed program codes to improve integrity.
1.7 (2022-02-01)
> ADDED menu ‘RECIPROCAL INTERCEPTION’ in SEP sheet.
> DELETED ‘IMPORT’ and ‘EXPORT’ buttons in SEP sheet.
> MODIFIED and trimmed program codes for further integrity.
1.8 (2022-03-01)
> CHANGED ‘RECIPROCAL INTERCEPTION’ to ‘INTERCEPTION’ on SEP sheet.
> ADDED overtaking mode to the ‘INTERCEPTION’ on SEP sheet.
> MODIFIED ‘RANGE AND ALTITUDE’ section on SEP sheet.
1.8.1 (2022-03-05)
> FIXED bug of 'INTERCEPTION’ on SEP sheet.
1.9 (2022-04-01)
> MODIFIED ‘INTERCEPTION’ on SEP sheet.
2.0 (2022-05-03)
> ADDED folder ‘DB’ to store all database related files
> DELETED folder ‘AIRAC’ to be combined into ‘DB’
> ADDED folder ‘HIST’ to store computation histories of GEOC
> FIXED bug in history function of GEOC
2.0.1 (2022-05-06)
> FIXED bug in processing dates for MAGVAR and histories of GEOC