Spreadsheet: 222143d1363774687-linking-data-from-a-query-to-additional-data-example-workbook
Sheet: Raw Mats

RAW MATS |  | Start | 01-mar-13
 |  | End | 31-dec-13
NS_CODE | NS_DESCRIPTION | DATE_OCCURRED | CAST_NUMBER | ALLOY_CODE | TOTAL_COST | REASON_CODE | EVENT_DESC | REMEDIAL_ACTION | INSPECTION_ACTION | RESOLUTION_TEXT | EQUIPMENT_CODE | [NAME] | RESOLUTION_STATUS | PROBLEM_OWNER | COMMENTS | Week Number | Year
AF | [NAME] REWELDS | 2013-03-14 00:00:00 | FX99196 | Ti64 | 200 | D | At the start of seam 1, welding was aborted due to low volts to gun 1. Electrode cooled for 30mins, then removed from the chamber whilst the gun was worked on. Electrode inspected to QAS2 page 3. Once repaired, return electrode to chamber for welding to be completed. Electrode rewelded and 9th seams added to straighten. Final inspection to QAS 2 page 3. | Electrode rewelded and 9th seams added to straighten. Final inspection to QAS 2 page 3. |  |  | PL301 | 179564 | B | SROBINSON
AC | [NAME] | 2013-03-14 00:00:00 | FR99275 | Ti6246 | 200 | M | Midway through welding the 8th seam the operator noticed a water leak from gun 2. The welding was aborted immediately and the chamber left to cool for 1 hour. The electrode was then removed from the chamber and inspected to QAS2, pg3. After repair, the electrode was reloaded and the welding completed. It was noted during the breakdown that the Argon gas feed had also been close to running out. The operator reported later that when the welding cycle had finished gun 2 was still leaking. The electrode was inspected when removed from the chamber after normal cool down. Final inspection to 5a on central ring to check for straightness across 2 seams only. | Weld aborted, chamber cooled for 1hr, electrode removed and inspected. Check O and N. | Check ingot gases. Check all routine billet trests satisfactory including ultrasonics. |  | PL302 | 179539 | B | SROBINSON | Leak on gun 2 during welding of 8th seam
AF | [NAME] REWELDS | 2013-03-11 00:00:00 | FR98591 | Ti834 | 200 | T | POST WELD INSPECTION SHOWED ELECTRODE TO BE CRACKED ACROSS 3 SEAMS IN 2 PLACES, 1/3 DOWN FROM TOP AND 1/3 UP FROM BOTTOM. ELECTRODE INSPECTED TO QAS 2 PAGE 2. LOADED BACK INTO CHAMBER AND REPAIR WELDS DONE TO STRENGTHEN . FINAL INSPECTION TO QAS 2 PAGE 3. | Electrode stitched to dress cracks.  Note for record. Check O and N. | Check ingot gases. Check / confirm all routine billet release tests satisfactory including ultrasonics. | Ti 834 is prone to cracking post welding due to it being heavily alloyed. The issue is to be reviewed via the Raw Mats FMEA as to what activity is required to address it. | PL3GE | 179421 | R | ODUNNE | Cracked electrode, Ti 834
AC | [NAME] | 2013-03-08 00:00:00 | FR99315 | Ti6246 | 200 | M | During stitching, gun 2 suffered a gun leak. The welding was aborted and electrode put into cooldown. The gun carried on dripping on the electrode during the whole of the cooldown despite the water pump being closed off. Area inspected to QAS2 page 5a (see photos) OPD/RG/LPH. No further action required.Stitching operation not started but electrode weld integrity satisfactory, electrode inspected to QAS 2 Page 3 stitching not required. | Affected area inspected to QAS 2 Page 5a. Ok to proceed. Check O and N. | Check gases on final ingot. Confirm all routine billet release tests satisfactory. ENDORSE FORGE CARDS FOR LEVEL 3 NDT OVERCHECK OF ULTRASONIC RECORDS. [NAME] to Technical Manager prior to final product release. |  | PL302 | 179367 | B | SROBINSON | Gun 2 leak
AK | COMPACT PROBLEMS | 2013-03-07 00:00:00 | HU99170 | Ti64 | 500 | M | 2 compacts fell on the floor due to a sequence problem on the bogie in front of the beauford track. Compacts assessed, brushed off and put back on the beauford track at the bottom of the electrode. All surfaces wiped and visually inspected OK. Final melt slot increased from 6" to 8" as a precaution to retain any effect in the [NAME] melt remains. | Final melt slot increased from 6" to 8" as a precaution to retain any effect in the [NAME] melt remains. Check ingot chemistry. Final disposition of electrode to be decided by Technical Manager. | Note yield loss of ~100kg due to extra slot length. Check chemistry on final ingot. Swansea plant to confirm all routine product release tests satisfactory, to specifically include ultrasonics. |  | PR200 | 179342 | B | SROBINSON | Compacts fell from Beauford track.
AS | MISC RAW MATERIALS | 2013-03-05 00:00:00 | HR99534 | Ti64 | 50 | OP | This cast was a duplicated heat number, HR99167 and BU99167 6242 were both in existence on the blend list and were in the plant at the same time. HR99167 had its cast number changed to HR99534 after the welding stage. A new set of SAP cards issued and electrode re-identified. | Change Star blend from HR99167 to HR99534. Re-identify electrode. Replace SAP cards from M1 onwards with HR99534. | Note for record |  | NA-WITT | 179202 | B | CDAVIES | Duplicate cast number in plant
AS | MISC RAW MATERIALS | 2013-03-03 00:00:00 | MR99174 | Ti6246 | 50 | E | RECORDER FAILED TO RECORD PUMPDOWN AND FIRST LEAK RATE DUE TO CHART JAM AND GREEN PEN NOT MARKING PROPERLY. EUROTHERM RECORDER CONFIRMED THAT PUMP DOWN AND FIRST LEAK RATE (FAILED) WERE WITHIN NORMAL, EXPECTED LIMITS. PEN AND RECORDER REPAIRED AND ELECTRODE WELDED WITH NO FURTHER ISSUE. | Note for record. Missing portion does not apertain to the welding cycle. The leak rate prior to welding is recorded and all the following trace is present and correct. Check O and N. | Check O and N on final ingot. Check / confirm all routine billet release tests satisfactory including ultrasonics. |  | PL2GE | 179100 | B | SROBINSON | Missing portion of trace prior to welding.
AF | [NAME] REWELDS | 2013-03-03 00:00:00 | BU99168 | Ti6242 | 200 | EB | At strike up for welding,  guns 1 & 3 fired but there were no amps registering for gun 2 which did not fire. Welding was aborted and the chamber put in cool down for 1 hour. Maintenance advised that gun 2 required changing.  The electrode was inspected to QAS 2 Page 2 and admitted back into chamber. After gun 2 was changed, the welding cycle was completed without further incident. Final electrode inspection was to QAS 2 Page 2. | Weld aborted and chamber cooled for 1 hour- followed by electrode inspection. Gun 2 replaced. Check O and N. | Check gases on final ingot. Swansea plant to confirm all routine product release tests satisfactory. Note for records. |  | PL202 | 179109 | B | SROBINSON | Gun 2 failed to strike at beginning of welding.