Spreadsheet: 117878d1313178258-help-with-getting-a-cell-value-from-another-sheet-nestedif
Sheet: REMAC998RT

 |  |  |  |  |  |  |  |  |  | 10000.33333333333 |  | 4862.149999999994
 |  |  |  |  |  |  |  | Engine     Install | Engine Removal | Time Since Install | Aircraft at     Install | Aircraft at Removal | Since Last Vendor Visit
Engine Serial Number: |  |  |  | A/C # Pos: | 998RT |  | Total Cycles: | 14735 | 18000 |  | 11177 | 13025 | 3265 |  | A319 Cyc | [NAME] | A321 Cyc
Currently Operating At: |  | A321 |  | Installation Date: | XX-XX-XXXX |  | Total Time: | 34851.08 | 44851.28 |  | 31075.53 | 35938.02 | 10000:20 |  | Since Inst | Since Inst | Since Inst
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
M&E Part Number | Description | Mfg. P/N | MFG S/N | Cyc Accum at -5B6/P - A319 Operation | Cyc Accum at    -5B4/P- A320 Operation | Cyc Accum at -5B3/P - A321 Operation | Total Cycles Operated Since New | Calculated Cyc Limit at -5B6/P - A319 Operation | -5B6/P - A319 Cycles Remaining | Calculated Cyc Limit at -5B4/P- A320 Operation | -5B4/P - A320 Cycles Remaining | Calculated Cyc Limit at -5B3/P-  A321 Operation | -5B3/P - A321 Cycles Remaining |  | A319 Cyc  At Instl | [NAME] At Instl | A321 Cyc At Instl |  | A319 Limit | A320 Limit | A321 Limit
27-7221-9-0002 | [NAME] | 338-001-905-0 | DB082945 | 0 | 12887 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | 0 | 12887 | 0 |  | 30000 | 30000 | 30000
27-7221-9-0003 | [NAME] | 338-001-504-0 | BB281462 | 0 | 12887 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | 0 | 12887 | 0 |  | 30000 | 30000 | 30000
27-7222-9-0001 | [NAME] | 338-010-601-0 | DB468266 | 0 | 12887 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | 0 | 12887 | 0 |  | 30000 | 30000 | 30000
27-7231-9-0012 | HPC Fwd Shaft | 1386M56P03 | GWN0M1J3 (2013) | 0 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | 0 | 0 | 0 |  | 20000 | 20000 | 20000
27-7231-9-0005 | HPC 1 & 2 Stage Disk | 1558M31G04 | GWN0M07K (5007) | 0 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | 0 | 0 | 0 |  | 20000 | 20000 | 20000
99-7231-9-0002 | HPC 3rd Stage Disk | 1590M59P01 | XAEL8845 | 0 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | 0 | 0 | 0 |  | 20000 | 20000 | 20000
99-7231-9-0003 | 4th-9th Spool | 1588M89G03 | GWN0M1RE (0114) | 0 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | 0 | 0 | 0 |  | 20000 | 20000 | 20000
27-7231-9-0006 | Air CDP Seal | 1523M35P01 | GFF5EWM6 (7056) | 0 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | 0 | 0 | 0 |  | 20000 | 20000 | 17200
27-7252-9-0002 | Front Shaft | 1873M73P01 | XAEM6374 | 0 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | 0 | 0 | 0 |  | 20000 | 20000 | 20000
27-7252-9-0006 | HPT Air Seal | 1795M36P02 | TMT6Y261 | 0 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | 0 | 0 | 0 |  | 20000 | 20000 | 20000
27-7252-9-0007 | HPT Disk | 1498M43P06 | GWN0LT5D  (5005) | 0 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | 0 | 0 | 0 |  | 20000 | 20000 | 20000
27-7252-9-0004 | HPT Rear Shaft | 1864M90P05 | TMT3SA65 | 0 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | 0 | 0 | 0 |  | 20000 | 20000 | 20000
27-7254-9-0008 | LPT Case | 338-117-404-0 | DB674482 | 0 | 12887 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | 0 | 12887 | 0 |  | 30500 | 30500 | 30500
27-7254-9-0009 | 1st Stage LPT Disk | 336-001-804-0 | BB366180 | 0 | 12887 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | 0 | 12887 | 0 |  | 25000 | 25000 | 25000
27-7254-9-0010 | 2nd Stage LPT Disk | 336-001-909-0 | BB398241 | 0 | 12887 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | 0 | 12887 | 0 |  | 25000 | 25000 | 25000
27-7254-9-0011 | 3rd Stage LPT Disk | 336-002-006-0 | BB393605 | 0 | 12887 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | 0 | 12887 | 0 |  | 25000 | 25000 | 25000
27-7254-9-0012 | 4th Stage LPT Disk | 336-002-105-0 | BB190166 | 0 | 12887 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | 0 | 12887 | 0 |  | 25000 | 25000 | 25000
27-7254-9-0001 | LPT Support | 338-077-502-0 | BB366432 | 0 | 12887 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | 0 | 12887 | 0 |  | 25000 | 25000 | 25000
27-7255-9-0002 | LPT Shaft | 338-010-003-0 | LA075963 | 0 | 12887 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  | 0 | 12887 | 0 |  | 25000 | 25000 | 25000
27-7256-9-0004 | Frame LPT | 338-102-908-0 | LA074298 | 0 | 12887 | #N/A | #N/A | N/L | N/L | N/L | N/L | N/L | N/L |  | 0 | 12887 | 0 |  | N/L | N/L | N/L
 | Signature: |  |  |  | Report Date:
A319
A320
A321
Installation Date:
Removal Date:
 |  |  |  |  |  |  |  |  | FORMULA BOX
 |  |  |  |  |  |  |  |  | // FULL FILE NAME
 |  |  |  |  |  |  |  |  | E:\[Nestedif.xls]VVINSTAC998RT
 |  |  |  |  |  |  |  |  | // CURRENT SHEET NAME
 |  |  |  |  |  |  | // global -------------------------> |  | 14735
 |  |  |  |  |  |  |  |  | //IF REM/AUDIT CYCLES
 |  |  |  |  |  |  |  |  | 3265
 |  |  |  |  |  |  |  |  | // CALC TIME SINCE INSTALL IN DECIMAL
 |  |  |  |  |  |  |  |  | 10000.33333333333
 |  |  |  |  |  |  |  |  | // CONVERT J46 BACK TO MINUTES
 |  |  |  |  |  |  |  |  | 10000:20
 |  |  |  |  |  |  |  |  | // IF STATEMENT FOR INSTALL CYCLES
 |  |  |  |  |  |  |  |  | // IF STATEMENT FOR INSTALL TIMES