Generating oil consumption trend report

This report enables you to analyze the consumption rate of the attached engine components. You can carry out a search based on the Part # / Serial #, Component # or Aircraft Reg #, date range and the Timeline Label. The report displays details such as date, log number, total flying hours, difference of flying hours, consumption, consumption rate and the aircraft registration number.

A linear graph is displayed in the report which enables detailed analysis of the consumption rate of the engine on a daily basis, weekly basis or fortnightly basis.

The “Oil Consumption Trend Analysis” tab appears by default, on launch of the “Oil Consumption Analysis Report” page.

Enter the following fields in the “Search Criteria” group box:

Part # / Serial #

The part # / serial # for which you wish to generate the oil consumption trend report. A valid Part # - Serial # combination must be entered here. The part number entered must be of type “Component”.

Help facility available.

Component #

The component number for which you wish to generate the oil consumption trend report. A valid component number must be entered here.

Help facility available.

Aircraft Reg #

The aircraft generation number against which the report has to be generated. A valid aircraft registration number must be entered here.

Help facility available.

Note: You must enter either ‘Part # / Serial #’ or ‘Component #’ or ‘Aircraft Reg #’ to generate the report. You must not enter Aircraft Reg # - Component # combination or Aircraft Reg # - Part # / Serial # combination.

From / To Date

The date range for which you wish to generate the oil consumption trend report. Mandatory. The ‘From / To Date’ entered must be earlier than or equal to the current date. ‘To Date’ must be equal to or later than ‘From Date’ but not later than the current date. The date range must be lesser than or equal to 2 years.

The system defaults ‘From Date’ with 1 month earlier than ‘To Date” and defaults ‘To Date’ with the current date.

Timeline Label

Use the drop-down list box and select the following values to display the consumption rates in the oil consumption rate graph accordingly. Mandatory.

Daily - Select this option if the consumption rate in the oil consumption rate graph needs to be displayed on a daily basis. You cannot select this option for a date range greater than 1 month.
Weekly - Select this option if the consumption rate in the oil consumption rate graph needs to be displayed on a weekly basis. You cannot select this option for a date range greater than 6 months.
Fortnightly - Select this option if the consumption rate in the oil consumption rate graph needs to be displayed fortnightly.

By default, the system displays “Weekly”.

Select the “Print Oil Consumption Trend Report” to generate the oil consumption trend report.

The oil consumption trend report displays the consumption of the engine attached components. The report is displayed for the specified Component # or Aircraft Reg. #. The consumption rate is displayed dynamically based on the number of engines in the given aircraft. If there are two oil uplift entries made on a single day, only one of the entries will be considered for the report.

Report Details - Consumption Rate:

The report displays details such as date, log number, total flying hours, difference of flying hours, consumption, consumption rate and the aircraft registration number in PDF format. The consumption rate (defined in “Set Base Parameters” activity of the “Aircraft” business component) is calculated using the following formula:

Consumption Rate = Oil Consumption / Flight Hours Difference

Where,

Flight Hours Difference = Total Flight Hours as of the entry date and time - Total Flight Hours as of the previous entry date and time.

Note: If the engine has been attached to another aircraft, the ‘Flight Hours’ column in the report varies as it is a different aircraft. The oil consumption rate calculation, in this case, is reset (the first value in the new aircraft is taken as reference and the calculation begins only from second value).

Graphical Representation:

The report also displays a linear graph which enables detailed analysis of the consumption rate of the engine on a daily basis, weekly basis or fortnight basis. The graph is plotted with the ‘Timeline’ (Daily / Weekly / Fortnightly) along X-axis and Consumption Rate (Engine Oil UOM / hour) along Y-axis. The Maximum Oil Consumption Rate is indicated by a horizontal line in the graph. The maximum value is mentioned in the graph header.

Note: When Component # / Part Serial is input, the graph displays the consumption rate, even if the Component record is in-active, if oil consumption recording exists for the component.

When Aircraft is input, the graph displays the consumption rate, even if the Aircraft is not in ‘Active’ status, if oil consumption recording exists for the components attached to the aircraft.

The report can only be exported in PDF or sent to a printer. Any other form of export is currently not supported.

If an engine does not have any oil uplift entries and the report is printed for that engine, only the table and graph headers are printed.

To proceed carry out the following:

Select the “Oil Uplift Analysis” tab to generate / print the oil uplift report.