Spreadsheet: 69694d1270256653-value-error-from-a-countifs-formula-new-qpr-workbook
Sheet: 2010

2010 |  |  |  |  |  | Total | In-House | NONC | QPR | QIR |  | Totals | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  | Total |  |  |  |  |  |  |  |  | Customer
 |  |  | Die Issue |  |  |  |  |  |  |  |  | InHouse
 |  |  |  |  |  |  |  |  |  |  |  | NONC
Type | # | Die # | Rec | Due | Press | Problem | Last PM / Spot PM | Status | Root Cause | P.I.C. | Comments | QPR Link
TTMA | #2 | 55171/5-04020 | 2010-01-06 00:00:00 |  | 2-1 | mis-stamped |  | 4 | Stamping issue | SHANE R | We inspected the die and found no issues with die. We did find some scrap from where a pilot hit the material. This is a mis-feed issue. Not a die issue. Die always has issues at the end of coils. Engineering is  involved. It short feeds when the 2ndary roller feeds material. | 55171-5-04020
TTMA | #3 | 55194-0E020 | 2010-01-07 00:00:00 |  | 5-2 | MIS-STAMPED |  | 4 | Die Issue | Jeff J | After inspecting again with the bad part stamping had one of the tooling marks lined up with the parting cutter. There was a scrap build up on 12-21 caused by the shaker not working. R/C shaker not working C/M /m TIGHTEN SHAKER BOLTS AND OIL AIR LINE WATCH FOR 3 RUNS. | 55194-0E020
TTMA | #7 | 55749-08020 | 2010-01-08 00:00:00 |  | 5-2 | mis-stamped |  | 4 | Stamping issue | Chad R | This is from start up scrap. You can see the nibbler marks on the part. | 55749-08020
TTMA | #9 | 51465-08040 | 2010-01-15 00:00:00 |  | 1-1 | pulled holes |  | 4 | Stamping issue | SHANE R | On 1/11/2010 fingers dropped the part and mis-located part. Sheared the button and many punches. Pulled die to fix. Stamping had to adjust fingers also I did find that the 5th station front feed side finger pilot was loose. | 51465-08040
QPR | 003-10   tttx | 58223/4-0C020 | 2010-01-15 00:00:00 |  | 3-1 | Mis-stamped part |  | 4 | Stamping issue | SHANE R | Inspected die found no issues. Found that the fingers that carry part from 4/6 to 5/6 front were out of adjustment. Taped fingers up. Need to adjust next prod. | 58223/4-0C020
TTMA | #11 | 61145/6-08030 | 2010-01-15 00:00:00 |  | 1-1 | short stamped |  | 4 | Die Issue | SHANE R | The pilot fell out during the run and no one saw it. The pilot that fell out wasn’t designed with a whistle notch to help hold pilot in. We poliched pilot and added a whistle notch to it. Complete 1-15-10. Need to inspect all pilots in this die for notches. | 51145/6-08030
TTMA | #13 | 51152-08010 | 2010-01-19 00:00:00 |  | 5-2 | Wrong Die Height |  | 4 | Stamping issue | Chad R | Operator didn’t change die height from previous run. | 51152-08010
TTMA | Not an actual QPR | 46212-TE011/ 012 | 2010-01-19 00:00:00 |  | 2-1 | pulled holes |  | 4 | Stamping issue | SHANE R | material rubbing pilots. Shortened fee 1.mm now 105.1 part looks good. At 106.1 the part was pulling as die warmed up.
QIR | #02-QIR-107257 | 48622-08030 | 2010-01-19 00:00:00 |  | 4-1 | burr |  | 4 | Die Issue | Chad R | R/C original condition ng. welded and re-ground radius to match 1/2 moon cutter. Good out of spotting press. 1-20-10.Good out of 4-1 | 48622-08030
TTMA | #17 | 57147-0E050 | 2010-01-20 00:00:00 |  | 5-2 | surface part is out of spec on  no id side |  | 4 | Die Issue | Chad R | Found scrap in the die, and all the pilot were gaulded.  The strip is not in correct location while running. Tightened the exit lifter up and adjusted the feed guides. Sharpened the lower trim.  Part is varying. beginning and end of coil is generaly NG.  R/C GUIDES OUT OF LOCATION. | 57147-0E050
TTMA | #18 | 57451-08020 | 2010-01-21 00:00:00 |  | 1-1 | scrap mark |  | 4 | Die Issue | [NAME] | Found the 1/4 has gauld and sharp edges that are dragging on material causing slivers.  We polished gauld and raduised all sharp edges. | 57451-08020
TTMA | Not an actual QPR | 61323/4-0E040 | 2010-01-25 00:00:00 |  | 1-1 | slug mark, [NAME] mark |  | 0 | Die Issue WAM | SHANE R | Scrap build  up caused by bent scrap deflectors. Bent back.  And double checked shaker bolts.The slug was caused in the 3/5. the buttons are wore out. I think there is a location issue. The 3/5 needs to go to the spotting press.
 | Not an actual QPR | 48733/4-08010 | 2010-01-26 00:00:00 |  | 5-2 | mis-stamped |  | 4 | Die Issue | Chad R | Modified part chute and it was still hitting. Lower chute more. Need to watch run.
TTMA | #19 | 55741-08021 | 2010-01-25 00:00:00 |  | 1-1 | mis-stamped |  | 4 | Die Issue | SHANE R | Found a bunch of scrp from the part in the 1/6. Blank rubbing on sharp corner cut into material enough to rip it off as part was being formed. Following production was good. | 55741-08021
QPR | 007-10 TTTX | 48514-0C010 | 2010-01-28 00:00:00 |  | 5-1 | mis-stamped |  | 4 | Stamping issue | Chad R | Talked to operator. He said they had the wrong vacuum cup on and blanks would not always feed up correctly. He changed the vaccuum cup out and it ran good. D/M did find 2 bent guides.cleaned out scrap all else ok. | 48514-0C010
TTMA | #25 | 61145/6-08030 | 2010-01-29 00:00:00 |  | 2-1 | BOLT MARK |  | 4 | DIE ISSUE | [NAME] | MARKS ARE COMING FROM THE BLANKER. THERE WAS A LIFTER BOLT THAT WAS LOOSE. WE TIGHTENED IT AT PRESS AND CHECKED OTHERS. OK. HALFWAY THROUGH RUN THE SAME LIFTER THE OTHER BOLT WAS LOOSE. INSPECTED IN THE SHOP NO ISSUES FOUND. PUT LOCTITE ON CENTER LIFTER BOLTS. CHECKED ALL BOLTS AND SNUGGED UP A FEW THAT WEREN'T REAL TIGHT. | 61145/6-08030
QIR | #26 | 64115-04040 | 2010-02-01 00:00:00 |  | 2-1 | [NAME] |  | 4 | Stamping issue | SHANE R | Part was not bent in the die. | 64115-04040
QPR | 008-10-- TTTX | 48514-0C010 | 2010-02-05 00:00:00 |  | 5-1 | Mis-Stamp |  | 4 | Stamping issue |  | [NAME] need to be modified. Skid bar, finger issue. Straightened and polished 1/5 and 2/5 guides. 3/5 welded and ground the guide. Also had o/l burr issues in the 4/5 and 5/5. welded and ground in. good to go. QPR CANCELLED AS PER SUSAN FUNK. | 48514-0C010
NONC | 438-TMMI | 57161-08020 | 2010-02-09 00:00:00 |  | 2-1 | Mark on part |  | 4 | Die Issue | SHANE R | Found evidence of a bolt that was loose in the die. We couldn’t find where bolt came from. It is probably a 6mm bolt. No bolts were missing from the die. Could it have come from the feed, press. I don’t know. We welded and ground in the hobbed in areas. The actual QPR issue may be coming from part exit chute. This hasnt been looked at yet. | 57161-08020
TTMA | #29 | 53216-08020 | 2010-02-11 00:00:00 |  | 1-1 | [NAME] |  | 4 | Stamping issue |  | inspect die and found nothing wrong. I tink bent while offloading. | 53216-08020
TTMA | #34 | 57113/4-08020 | 2010-02-11 00:00:00 |  | 2-1 | Fold in Part |  | 4 | Material issue | [NAME] | We inspected this die and found nothing that would cause the defect. Possibly a material issue. Delamination. | 57113/4-08020
NONC | 440-TMMI | 53213/4-08020 | 2010-02-16 00:00:00 |  | 1-1 | SPLIT |  | 4 | Die issue | [NAME] | We found scrap in the die draw section. We champhered the bolt hole in that area and also polished the seam between 2 forms. Were it could have caused scrap. We removed the draw pad and removed scrap. There is also the possibility of wrinkled blanks. We found a cracked form block in the upper. very bad design. We welded and ground in. | 53213/4-08020
QPR | 010-10 TTTX | 55171/5-0C010 | 2010-02-18 00:00:00 |  | 2-1 | [NAME] |  | 4 | Die issue | [NAME] | FOUND 2 LIFTER GUIDE PINS MISSING OUT OF THE LAST LIFTER. REPLACED THOSE AND LOCKTITED WITH RED, THEN ADDED SET SCREWS TO HELP KEEP THEM IN. IN THE UPPER CHANGED 2 BUSHINGS IN EXIT STRIPPER. | 55171/5-0c010
TTMA | #45 | 51466-08040 | 2010-02-25 00:00:00 |  | 1-1 | pulled hole |  | 4 | Die issue | [NAME] | On 2-23-10 we pulled the die for part deformation. The punch lost its stripper and the cam stayed forward which bent part. This was at the beginning of the run. 2 parts ran. This issue started the previous run. The stripper bolt hole was stripped. We drilled and tapped in a differant locarion then added loctite. (Looking into another style of stripper) | 51466-08040
NONC | 447- TTTX | 48621/2-0C010 | 2010-02-23 00:00:00 |  | 4-1 | Splits |  | 4 | Die Issue | Jeff J | Welded and ground in all chips in trim cutters, for both 48621 and 48622 in the 2/6 and 3/6.  Lamination was found on this material. | 48621/2-0C010
QPR | 013-10 TTTX | 57688-0C030 | 2010-03-01 00:00:00 |  | 2-1 | miss-stamped hole |  | 3 | Stamping issue | [NAME] | This is a decoiler issue. The stock guides were out of adjustment. [NAME] adjusted stock guides and made same part. | 57688-0C030
TTMA | #48 | 57478-08010 | 2010-03-02 00:00:00 |  | 3-1 | bent |  | 4 | Stamping issue | SHANE R | Part bent due to stamping. | 57478-08010
TTMA | #51 | 58215/6-08010 | 2010-03-04 00:00:00 |  | 5-2 | mis-stamped |  | 3 | Stamping issue | [NAME] | Die was inspected and everything was good. This isnt a die issue. Strip was short fed.  Tried to recreate it at press with no luck. | 58215/6-08010
TTMA | #52 | 55749-08020 | 2010-03-04 00:00:00 |  | 5-2 | mis-stamped |  | 4 | Stamping issue | [NAME] | start up scrap. You can see nibbler marks. | 55749-08020
TTMA | #58 | 57413/4-08020/30 | 2010-03-05 00:00:00 |  | 3-1 | O/L burr |  | 4 | Die Issue | SHANE R | This die is still trialing. In the shop we welded up the chipped cutter. Still had burr. In the press on 3-3-10 we caulked the lower cutter to close up the clearance. | 57413/4-08020/30
QPR | 022-10-TTTX | 58223/4-0C020 | 2010-03-11 00:00:00 |  |  | Material Fold |  | 4 | Die Issue | SHANE R | Found scrap under the draw pad. Also 3 broken bolts and at least 3 more that were about broke holding the lower draw. Only 1 was tight. In the press found the rear exit material guide in the 1/6 was out about an inch. The guides to the rear fingers were out as well. | 58223/4-0C020
QPR | 024-10 TTTX | 48628/9-0C010 | 2010-03-10 00:00:00 |  | 2-1 | mis-stamp |  | 4 | Stamping issue | [NAME] | Start up parts not contained. Stamping issue. | 48628/9-0C010
TTMA | #66 | 55741-08010 | 2010-03-12 00:00:00 |  | 1-1 | short stamped |  | 4 | Stamping issue | [NAME] | Found evidence the blank mislocated in the draw. Fingers were out od adjustment next run. Had to adjust all of them | 55741-08010
TTMA | #67 | 57313/4-08010 | 2010-03-12 00:00:00 |  | 1-1 | [NAME] |  | 4 | Stamping issue | [NAME] | This isnt a die issue. | 57313/4-08010
QIR | #68 | 55741-08010 | 2010-03-12 00:00:00 |  | 1-1 | hole unpunched |  | 4 | Die issue | [NAME] | Punch only enters 1mm from TIW. Punch needs to stay original size until we can kaizen it to use longer punch. | 55741-08010
QPR | 02-QPR-108746 | 55741-08010 | 2010-03-15 00:00:00 |  | 1-1 | splits |  | 4 | Stamping issue | [NAME] | [NAME] out of adjustment caused scrap which caused split. | 55741-08010
TTMA | #73 | 57652-08030 | 2010-03-18 00:00:00 |  | 3-1 | Deformed O/L |  | 3 | Stamping issue | Jeff J | This isnt die issue. Forklift hit parts | 57652-08030
TTMA | #74 | 68369-08021 | 2010-03-18 00:00:00 |  | 5-1 | Scrap mark |  | 3 | Die Issue | [NAME] | Found scrap under draw pad. Also had broken form block bolt in lower. The rest of the die checked ok. The run on 3-22-10 the first 3 fingers front and back the finger guides were out. Too wide. Found a few sharp corners in the draw pad upper form. Those have been polished. | 68369-08021
TTMA | #75 | 55712-08040 | 2010-03-22 00:00:00 |  | 1-1 | scrap mark |  | 4 | Die Issue | [NAME] | Found that scrap came from a scrap buildup on 3-17-10. We modified trim cutters to hold less scrap. 1st run after mod. Was good.
TTMA | #78 | 55725-08030 | 2010-03-23 00:00:00 |  | 5-2 | scrap mark |  | 3 | Die issue | Chad R | Found that scrap from the parting process pulled up and landed on lower. One of the spring plungers in both the parting cutters backed out. This would cause the  scrap to get wedged and pull up. add locktite to small spring plungers.
TTMA | #79 | 68369-08021 | 2010-03-23 00:00:00 |  | 5-1 | O/L BURR |  | 3 | Die issue | [NAME] | This is caused by cutter clearance. CM welding up clearance and took it to spotting press. Now needs datum built up.
TTMA | #82 | 61321-0E040 | 2010-03-25 00:00:00 |  | 4-1 | Pulled hole |  | 3 | Die issue | Jeff J | 5/6 Scrap built up and caused pulled hole. We adjusted angle and added a ball vibrator. Need to watch run to confirm fix. 3-30-10 scrap flow ok.
TTMA | #86 | 57478-08010 | 2010-03-30 00:00:00 |  | 3-1 | mis-stamped |  | 3 | Stamping Issue | SHANE R | Part mis-located in the 6/6. The upper is smashed were part was folded.  This appears to just be mis-located part. Stamping issue. As of now reason unknown. Did find that a part has mis-located in the 1/6, but this mislocated part definetly occurred in 6/6.
TTMA | #89 | 61211/2-0E040 | 2010-03-30 00:00:00 |  | 4-1 | Bent |  | 2 | Stamping Issue | Jeff J | This was caused by the fingers allowing the part to sag. Then part would hit cam and get bent. Finger guide broke off.  Fixed fingers part is good. Im not sure about this one. [NAME] said we fixed it a month ago. If that’s the case we wouldn’t be having parts know. Need to inspect fingers. Guide may have broke off again.
TTMA | #91 | 51466-08040 | 2010-03-30 00:00:00 |  | 3-1 | Pulled hole |  | 0