Spreadsheet: 703882d1605206233-if-isnumber-search-and-or-with-extra-criteria-erf-log-projects
Sheet: Log

ERF | Site_Customer_Unit_Description | Bay(s) | Date Estimate Completed | Start Date | Need by Date | Probability | Rate | Base Hours (Est) | Base Cost (Est) | Void Date (365 Days) | Current Status | Notes | SN# PO# WBS# STO# | SO# (ZM02, ZM03) | Base  Hours APPRVD | Base  Cost  APPRVD | EWA  Hours  SUBM | EWA SUBM | EWA  Hours  APPRVD | EWA APPRVD | Invoice | Activity Plan | Part Number IN Generic: If comp bladed we could use RTRBLDFCRFBCU If un bladed we could use RTRUNBFCRFBCU ([NAME]) | Part Number OUT (Brown & Brown Refurb) | Serial Number | Note(s) | Won IF FORMULA | Kickoff IF FORMULA | Pending IF FORMULA | In Progress IF FORMULA | TGR View IF FORMULA | WLD IF FORMULA | VLV Parity IF FORMULA | PWPS IF FORMULA | CRI WON or IN PROGRESS
ERF-99-9999 | Do Not Paste Above this line |  |  |  |  |  |  |  |  |  | [NAME]
[NAME] | Termocandelaria_TPL_GT1_Cyl. Housing | 3 | 2020-10-28 00:00:00 | 2020-10-28 00:00:00 | 2020-10-29 00:00:00 | 1 |  |  |  |  | In Progress | 002115-EP  UPPER - $56,131.92 (Standard price for this is $32k) 002116-EP LOWER - $56,131.92 (Standard price for this is $32k) STD004228 - $130.38 each – need 6pcs ($782.28 total) | 300020010 | 100116322
[NAME] | SMW_TGR_501J_Re-rounding plates | 3 | 2020-10-22 00:00:00 | TBD | TBD | 0.25 |  |  |  |  | Pending | Tooling need for M501J re-rounding
[NAME] | MDnA_Columbia_Dominion_Unit 3_RTR WLD N1 Gland RSTR | 3 | 2020-10-08 00:00:00 | 2020-10-19 00:00:00 | ASAP | 0 |  |  |  |  | Lost | Lost - did not fit into the outage schedule Class 8 rotor weld on the N1 Gland
[NAME] | HOU_MCOI_VL0A841-JKA_STG6 SE [NAME] | 3 | 2020-10-27 00:00:00 | 2020-12-01 00:00:00 | 2020-12-08 00:00:00 | 0.1 |  |  |  |  | Lost | Lead time and cost was the reason
ERF-20-SMW009 | OSC Parts_Mitsubuishi Power_W501FD Exhaust Cyl_007734-MFG and 007735-MFG | 4 | 2020-09-29 00:00:00 | 2020-08-01 00:00:00 | 2021-12-30 00:00:00 | 1 |  |  |  |  | Completed | Spare Exhaust Casing W501FD SMW did not receive a CRM opportunity for this casing  so costing at the end of the project could be a mess | [PHONE] _x000D_ [PHONE] | 80071513 80071514 | 224 | 1393558 | #1           9@$250 | #1              $7,913
ERF-20-SMW008 | Glastonbury_PWPS_P9_Shipping Kit Install | 5 | 2020-06-18 00:00:00 | TBD | 2021-01-15 00:00:00 | 1 |  |  |  |  | Pending | Place holder ERF for Shipping Kit Install | 5900004794_x000D_ | 100108978
[NAME] | Glastonbury_PWPS_Tooling [NAME] | 5 | 2020-06-18 00:00:00 | 2020-06-18 00:00:00 | 2021-01-15 00:00:00 | 1 |  |  |  |  | Pending | Place holder for low spool tooling maintenance and modifications.  This amount will be revised as need to support bay 5 tooling requirements. | 5900004656 | 100108449 | NA | 60000
[NAME] | Glastonbury_PWPS_GG4000_P17_Final Assembly | 5 | 2020-06-15 00:00:00 | 2021-07-14 00:00:00 | 2021-01-15 00:00:00 | 0.75 |  |  |  |  | Pending
[NAME] | Glastonbury_PWPS_GG4000_P16_Final Assembly | 5 | 2020-06-15 00:00:00 | 2021-10-25 00:00:00 | 2021-12-07 00:00:00 | 0.75 |  |  |  |  | Pending
[NAME] | Glastonbury_PWPS_GG4000_P15_Final Assembly | 5 | 2020-06-15 00:00:00 | 2021-09-08 00:00:00 | 2021-10-20 00:00:00 | 0.75 |  |  |  |  | Pending
[NAME] | Glastonbury_PWPS_GG4000_P14_Final Assembly | 5 | 2020-06-15 00:00:00 | 2021-07-06 00:00:00 | 2021-08-30 00:00:00 | 0.75 |  |  |  |  | Pending
[NAME] | Glastonbury_PWPS_GG4000_P13_Final Assembly | 5 | 2020-06-15 00:00:00 | 2021-05-01 00:00:00 | 2021-06-30 00:00:00 | 0.75 |  |  |  |  | Pending
[NAME] | Glastonbury_PWPS_GG4000_P12_Final Assembly | 5 | 2020-06-15 00:00:00 | 2021-02-15 00:00:00 | 2021-04-25 00:00:00 | 0.9 |  |  |  |  | Pending
[NAME] | Glastonbury_PWPS_GG4000_P2_Final Assembly | 5 | 2020-06-15 00:00:00 | TBD | TBD | 0.75 |  |  |  |  | Pending
[NAME] | Glastonbury_PWPS_GG4000_P11_Final Assembly | 5 | 2020-06-15 00:00:00 | 2020-12-01 00:00:00 | 2021-02-15 00:00:00 | 0.9 |  |  |  |  | Pending
[NAME] | Glastonbury_PWPS_PT4000_Balance Arbor Mods_ IPJ26136-01 - Shortcut | 5 | 2020-04-29 00:00:00 | TBD |  | 0 |  |  |  |  | Abandoned | Out sourced do to grinding requirements
[NAME] | Glastonbury_PWPS_PT4000_Rotor [NAME] | 5 |  |  |  | 0.75 |  |  |  |  | Abandoned
[NAME] | Glastonbury_PWPS_PT8_Exhaust Case VQ1084548 | 5 | 2020-03-16 00:00:00 | TBD |  | 0 |  |  |  |  | Abandoned | Reviewed with Accounting/Operations/Management and decided to decline the estimate due to risk and lost revenues
[NAME] | Glastonbury_PWPS_PT8_Exhaust Case VQ1084548 | 5 | 2020-03-16 00:00:00 | TBD |  | 0 |  |  |  |  | Abandoned | Reviewed with Accounting/Operations/Management and decided to decline the estimate due to risk and lost revenues
[NAME] | Glastonbury_PWPS_PT8_Exhaust Case VQ1084548 | 5 | 2020-03-16 00:00:00 | TBD |  | 0 |  |  |  |  | Abandoned | Reviewed with Accounting/Operations/Managment and decided to decline the estiamte due to risk and lost revenues
[NAME] | Glastonbury_PWPS_PT8_Exhaust Case VQ1084548 | 5 | 2020-03-16 00:00:00 | TBD |  | 0 |  |  |  |  | Abandoned | Reviewed with Accounting/Operations/Managment and decided to decline the estiamte due to risk and lost revenues
[NAME] | Glastonbury_PWPS_PT8_Exhaust Case VQ1084548 | 5 | 2020-03-16 00:00:00 | TBD |  | 0 |  |  |  |  | Abandoned | Reviewed with Accounting/Operations/Management and decided to decline the estimate due to risk and lost revenues
[NAME] | Saint Louis_MDnA_6FA Bearing Sleeve Material (TD00353A) | 5 | 2020-03-10 00:00:00 | TBD |  | 0.2 |  |  |  |  | Pending | [NAME] disc in bay 5
[NAME] | Glastonbury_PWPS_GG4000_P17_Low Spool Asm | 5 | 2020-01-22 00:00:00 | 2021-10-24 00:00:00 |  | 0.8 |  |  |  |  | Pending | 859 previous quoted hours
[NAME] | Glastonbury_PWPS_GG4000_P16_Low Spool Asm | 5 | 2020-01-22 00:00:00 | 2021-09-07 00:00:00 |  | 0.8 |  |  |  |  | Pending | 921 previous quoted hours
[NAME] | Glastonbury_PWPS_GG4000_P15_Low Spool Asm | 5 | 2020-01-22 00:00:00 | 2021-07-07 00:00:00 |  | 0.8 |  |  |  |  | Pending | 1061 previous quoted hours
[NAME] | Glastonbury_PWPS_GG4000_P14_Low Spool Asm | 5 | 2020-01-22 00:00:00 | 2021-05-01 00:00:00 |  | 0.8 |  |  |  |  | Pending | 1178 previous quoted hours
[NAME] | Glastonbury_PWPS_GG4000_P13_Low Spool Asm | 5 | 2020-01-22 00:00:00 | 2021-02-15 00:00:00 |  | 0.8 |  |  |  |  | Won | 1375 previous quoted hours | 5900004663 |  | 1567 | 294333
[NAME] | [NAME] | 5 | 2020-01-22 00:00:00 | 2020-11-20 00:00:00 |  | 1 |  |  |  |  | Won | 1571 previous quoted hours | 5900004663 |  | 1763 | 294333
[NAME] | Glastonbury_PWPS_GG4000_P11_Low Spool Asm | 5 | 2020-01-22 00:00:00 | 2020-06-01 00:00:00 |  | 1 |  |  |  |  | In Progress | 1768 previous quoted hours | 5900004663 | 100106440 | 1958 | 294333