The purpose of this project is keyword search in EASA biweekly reports. Keywords include Tc Holder (Manufacturer) and Type (Aircraft type). The program takes data from the .html file and searches for keywords and outputs a processed .xlsx file. If the published instruction is irrelevant for the aircraft manufacturer, "N/A by TC Holder", if it is irrelevant for the aircraft type, "N/A by Type" comments are entered in the excel file. By the way, the instructions published as APPLIANCES are processed automatically as they include every type of aircraft.
To illustrate an example, let's take the 14th biweekly report published on 2021-06-28 as an introduction.
The prepared GUI is shown below.
In the application, you need to select a file with .html extension, otherwise the program will crash and close. You need to enter Keywords like this way: Words, Searching.
For example, keywords are entered for Boeing 737 aircraft type.