Spreadsheet: 690205d1596947993-i-need-formula-to-get-details-of-last-6-month-5-years-and-aircraft-wise-logbook-jitu-copy_gw
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
 | 2020-02-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
 | 2020-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
 | 2020-04-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
 | 2020-05-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
 | 2020-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
 | 2020-07-01 00: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
From: |  | DAY |  | NIGHT |  | DAY |  |  |  | NIGHT |  |  |  |  | On Aircraft |  | Synthetic Simulator hrs (AB)
2020-01-01 00:00:00 |  | 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)
To: |  | (1) | (2) | (3) | (4) | (5) | (6) | (7) | (8) | (9) | (10) | (11) | (12) | (13) | (14) | (15) | (16) | (17) | (18)
2020-06-30 00:00:00 | B737-700 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
 | B737-800 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -
 | 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……………………………………………………………………
 |  |  |  |  |  | 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-01-01 00:00:00
 | 2017-01-01 00:00:00
 | 2018-01-01 00:00:00
 | 2019-01-01 00:00:00
 | 2020-01-01 00: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 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
From: |  | DAY |  | NIGHT |  | DAY |  |  |  | NIGHT |  |  |  |  | On Aircraft |  | Synthetic Simulator hrs (AB)
2015-01-01 00:00:00 |  | 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)
To: |  | (1) | (2) | (3) | (4) | (5) | (6) | (7) | (8) | (9) | (10) | (11) | (12) | (13) | (14) | (15) | (16) | (17) | (18)
2019-12-31 00:00:00 | 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……………………………………………………………………