Spreadsheet: 690102d1596873265-i-need-formula-to-get-details-of-last-6-month-5-years-and-aircraft-wise-logbook-jitu-copy
Sheet: CA39

 |  |  |  |  |  | PRECEDING 6 MONTHS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CA-39
 | EXPERIENCE IN LAST 6 MONTHS FROM THE DATE OF SUBMISSION OF PAPERS IN DGCA (FROM ………………………….... TO ………………………………….……)
 | Name of License Holder …………………………………………………………………………………………………………………………………….
 | License Class ………………………...….………………License Number ……………………..…………    Valid upto …………………...………
 | Aircrafts flown …………………………………………………………………………………………………………………………...……………………………
 | Month wise - flying Details preceding 6 months
 | Month Wise (A) | SINGLE ENGINE AIRCRAFT |  |  |  | MULTI ENGINE AIRCRAFT |  |  |  |  |  |  |  | Total | INSTRUMENT TIME |  |  | Instructional Flying | Remarks |  | I need this table to take values automatically from sheet LOGBOOK for the last 6 months. These are the values I have fed in manually. Logbook column letters are specied in () for each column
 |  | DAY |  | NIGHT |  | DAY |  |  |  | NIGHT |  |  |  |  | On Aircraft |  | Synthetic Simulator hrs (AB)
 |  | Dual (L) | Solo (K) | Dual (N) | Solo (M) | U/T (R) | Co-pilot (P) | P1 U/S (Q) | PIC (O) | U/T (V) | Co-pilot (T) | P1 U/S (U) | PIC (S) |  | Simulated (X) | Actual (W)
 |  | (1) | (2) | (3) | (4) | (5) | (6) | (7) | (8) | (9) | (10) | (11) | (12) | (13) | (14) | (15) | (16) | (17) | (18)
 | FEB | - | - | - | - | - | 1 day, 1:03:00 | - | - | - | 4:16:00 | - | - |  | - | 16:00:00 | - | - | -
 | MAR | - | - | - | - | - | 1 day, 1:58:00 | - | - | - | 23:35:00 | - | - |  | - | 1 day, 7:00:00 | 6:00:00 | - | -
 | APR | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | MAY | - | - | - | - | - | 13:24:00 | - | - | - | - | - | - |  | - | 9:00:00 | - | - | -
 | JUN | - | - | - | - | - | 15:39:00 | - | - | - | 3:25:00 | - | - |  | - | 13:00:00 | - | - | -
 | JUL | - | - | - | - | - | 20:20:00 | - | - | - | 5:10:00 | - | - |  | - | 21:00:00 | - | - | -
 |  | - | - | - | - | - | - | - | - | - |  | - | - | - | - | - | - | - | -
 | Total | - | - | - | - | - |  | - | - | - |  | - | - |  | - |  |  | - | -
 | This is to certify that I have examined the logbooks of Mr. .………………………………………………………………………………………………………………………………
 | and the above is a true summary.
 |  |  |  |  |  |  |  |  |  | Countersigned………………………………………………………..
 |  |  |  |  |  |  |  |  |  | Name………………………………………………………………….
 |  |  |  |  |  |  |  |  |  | Designation…………………………………………………………..
 |  |  |  |  |  |  |  |  |  | Company name………………………………………………………
 | Signature of License Holder…………………………………………………………… |  |  |  |  |  |  |  |  | Seal……………………………………………………………………
 | Date……………………………………………………………………………………… |  |  |  |  |  |  |  |  | Date……………………………………………………………………
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CA-39
 | EXPERIENCE IN LAST 6 MONTHS FROM THE DATE OF SUBMISSION OF PAPERS IN DGCA (FROM ………………………….... TO ………………………………….……)
 | Name of License Holder …………………………………………………………………………………………………………………………………….
 | License Class ………………………...….………………License Number ……………………..…………    Valid upto …………………...………
 | Aircrafts flown …………………………………………………………………………………………………………………………...……………………………
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I need this table to take values automatically from sheet LOGBOOK for the last 6 months of the specific Aircraft. These are the values I have fed in manually. Logbook column letters are specied in () for each column
 | Aircraft wise - flying Details preceding 6 months
 | A/c Wise (B) | SINGLE ENGINE AIRCRAFT |  |  |  | MULTI ENGINE AIRCRAFT |  |  |  |  |  |  |  | Total | INSTRUMENT TIME |  |  | Instructional Flying | Remarks
 |  | DAY |  | NIGHT |  | DAY |  |  |  | NIGHT |  |  |  |  | On Aircraft |  | Synthetic Simulator hrs (AB)
 |  | Dual (L) | Solo (K) | Dual (N) | Solo (M) | U/T (R) | Co-pilot (P) | P1 U/S (Q) | PIC (O) | U/T (V) | Co-pilot (T) | P1 U/S (U) | PIC (S) |  | Simulated (X) | Actual (W)
 |  | (1) | (2) | (3) | (4) | (5) | (6) | (7) | (8) | (9) | (10) | (11) | (12) | (13) | (14) | (15) | (16) | (17) | (18)
 | B737-700 | - | - | - | - | - | 17:48:00 | - | - | - | 1:52:00 | - | - |  | - | 9:00:00 | - | - | -
 | B737-800 | - | - | - | - | - | 2 days, 2:00:00 | - | - | - | 1 day, 6:34:00 | - | - |  | - | 2 days, 4:30:00 | - | - | -
 | B737-FR7 | - | - | - | - | - | 1 day, 8:36:00 | - | - | - | 4:00:00 | - | - |  | - | 1 day, 4:30:00 | - | - | -
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 | Total | - | - | - | - | - |  | - | - | - |  | - | - |  | - |  | - | - | -
 | This is to certify that I have examined the logbooks of Mr. .………………………………………………………………………………………………………………………………
 | and the above is a true summary.
 |  |  |  |  |  |  |  |  |  | Countersigned………………………………………………………..
 |  |  |  |  |  |  |  |  |  | Name………………………………………………………………….
 |  |  |  |  |  |  |  |  |  | Designation…………………………………………………………..
 |  |  |  |  |  |  |  |  |  | Company name………………………………………………………
 | Signature of License Holder…………………………………………………………… |  |  |  |  |  |  |  |  | Seal……………………………………………………………………
 | Date……………………………………………………………………………………… |  |  |  |  |  |  |  |  | Date……………………………………………………………………
 |  |  |  |  |  | PRECEDING 5 YEARS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CA-39
 | EXPERIENCE IN LAST 5 YEARS FROM THE DATE OF SUBMISSION OF PAPERS IN DGCA (FROM ………………………….... TO ………………………………….……)
 | Name of License Holder …………………………………………………………………………………………………………………………………….
 | License Class ………………………...….………………License Number ……………………..…………    Valid upto …………………...………
 | Aircrafts flown …………………………………………………………………………………………………………………………...……………………………
 | Year Wise - flying Details preceding 5 years
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I need this table to take values automatically from sheet LOGBOOK for the last 5 years. Logbook column letters are specied in () for each column
 | Year Wise (A) | SINGLE ENGINE AIRCRAFT |  |  |  | MULTI ENGINE AIRCRAFT |  |  |  |  |  |  |  | Total | INSTRUMENT TIME |  |  | Instructional Flying | Remarks
 |  | DAY |  | NIGHT |  | DAY |  |  |  | NIGHT |  |  |  |  | On Aircraft |  | Synthetic Simulator hrs (AB)
 |  | Dual (L) | Solo (K) | Dual (N) | Solo (M) | U/T (R) | Co-pilot (P) | P1 U/S (Q) | PIC (O) | U/T (V) | Co-pilot (T) | P1 U/S (U) | PIC (S) |  | Simulated (X) | Actual (W)
 |  | (1) | (2) | (3) | (4) | (5) | (6) | (7) | (8) | (9) | (10) | (11) | (12) | (13) | (14) | (15) | (16) | (17) | (18)
 | 2016
 | 2017
 | 2018
 | 2019
 | 2020
 | Total
 | This is to certify that I have examined the logbooks of Mr. .………………………………………………………………………………………………………………………………
 | and the above is a true summary.
 |  |  |  |  |  |  |  |  |  | Countersigned………………………………………………………..
 |  |  |  |  |  |  |  |  |  | Name………………………………………………………………….
 |  |  |  |  |  |  |  |  |  | Designation…………………………………………………………..
 |  |  |  |  |  |  |  |  |  | Company name………………………………………………………
 | Signature of License Holder…………………………………………………………… |  |  |  |  |  |  |  |  | Seal……………………………………………………………………
 | Date……………………………………………………………………………………… |  |  |  |  |  |  |  |  | Date……………………………………………………………………
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CA-39
 | EXPERIENCE IN LAST 5 YEARS FROM THE DATE OF SUBMISSION OF PAPERS IN DGCA (FROM ………………………….... TO ………………………………….……)
 | Name of License Holder …………………………………………………………………………………………………………………………………….
 | License Class ………………………...….………………License Number ……………………..…………    Valid upto …………………...………
 | Aircrafts flown …………………………………………………………………………………………………………………………...……………………………
 | Aircraft Wise - flying Details preceding 5 years |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I need this table to take values automatically from sheet LOGBOOK for the last 5 years of the specific Aircraft. Logbook column letters are specied in () for each column
 | A/c Wise (B) | SINGLE ENGINE AIRCRAFT |  |  |  | MULTI ENGINE AIRCRAFT |  |  |  |  |  |  |  | Total | INSTRUMENT TIME |  |  | Instructional Flying | Remarks
 |  | DAY |  | NIGHT |  | DAY |  |  |  | NIGHT |  |  |  |  | On Aircraft |  | Synthetic Simulator hrs (AB)
 |  | Dual (L) | Solo (K) | Dual (N) | Solo (M) | U/T (R) | Co-pilot (P) | P1 U/S (Q) | PIC (O) | U/T (V) | Co-pilot (T) | P1 U/S (U) | PIC (S) |  | Simulated (X) | Actual (W)
 |  | (1) | (2) | (3) | (4) | (5) | (6) | (7) | (8) | (9) | (10) | (11) | (12) | (13) | (14) | (15) | (16) | (17) | (18)
 | C172
 | PA28-161
 | PA34
 | B737-700
 | B737-800
 | B737-900
 | B737-MAX
 | B737-FR7
 | Total
 | This is to certify that I have examined the logbooks of Mr. .………………………………………………………………………………………………………………………………
 | and the above is a true summary.
 |  |  |  |  |  |  |  |  |  | Countersigned………………………………………………………..
 |  |  |  |  |  |  |  |  |  | Name………………………………………………………………….
 |  |  |  |  |  |  |  |  |  | Designation…………………………………………………………..
 |  |  |  |  |  |  |  |  |  | Company name………………………………………………………
 | Signature of License Holder…………………………………………………………… |  |  |  |  |  |  |  |  | Seal……………………………………………………………………
 | Date……………………………………………………………………………………… |  |  |  |  |  |  |  |  | Date……………………………………………………………………