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

2009 |  |  |  |  |  | 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
QIR | #02- QIR- 103023- TMMI | 55132-08010 | 2009-07-08 00:00:00 |  | 2-1 | Parts Bent |  | 4 | Stamping Issues | Chad R | Have inspected this die and found no issues. Stamping Issue
TTMA | #143 | 64117- 04030 | 2009-07-09 00:00:00 |  | 2-1 | [NAME] |  | 4 | Die Issue | [NAME] | We inspected and cleaned out Carbon build-up in the 1/6 and 4/6. No scrap was found  (DM polished edge and sharpened cutter so no scrap would stack up)
TTMA | #150 | 57021- 0E010 | 2009-07-23 00:00:00 |  | 1-1 | [NAME] |  | 4 | Stamping Issues | Jeff J | Press Issue | 57021-0E010 #150
TTMA | #153 | 53218- 08010 | 2009-07-27 00:00:00 |  | 5-2 | [NAME] |  | 4 | Die Issue | Chad R | Parts built up in part exit chute. Fixed exit chute | 53218-08010 #153
TTMA | #159 | 48623/4- 08020-BL | 2009-08-04 00:00:00 |  | 2-1 | Mis- stamped outline |  | 4 | Stamping Issues | Shane R | Not a 4-1 Die issue. No mis-grip to tell when press short feeds. Blanks from the 2-1 were NG | 48623/4-08020-BL #159
TTMA | #164 | 47110- 0E020 | 2009-08-08 00:00:00 |  | 5-2 | Mis- stamped outline |  | 4 | Stamping Issues | Jeff J | The Die was inspected and nothing was wrong. Appears to be a feed issue. | 47110-0E020 #164
TTMA | #165 | 63132-04040 | 2009-08-08 00:00:00 |  | 2-1 | Mis-Stamped Outline in several Locations |  | 4 | Die Issue | [NAME] | Replaced broken pilot and replaced 2 spring plungers. Looks like the spring plunger backed out and got caught in the pilot hole, which caused it to break. Need to loctite plungers. | 63132-04040 #165
TTMA | #184 | 55194- 0E020 | 2009-08-28 00:00:00 |  | 5-1 | Mis- stamped Part |  | 4 | Die Issue | Jeff J | 8/26/09 lifter stuck. During last run, 8/25/09 it stuck down, which probably caused the bad part. | 55194-0E020 #184
NONC | #421-TTTX | 48621- 0C010 | 2009-09-02 00:00:00 |  | 4-1 | Dent and Pinched |  | 4 | Material Issue | Shane R | The Dented and Pinched effect is what is happening as the material is stretching, right before it splits. I think the splits are material related. Too random to be the die. | 48621-0C010 #421 TTTX
TTMA | #190 | 53273- 08010 | 2009-09-09 00:00:00 |  | 5-2 | [NAME] |  | 4 | Die Issue | Chad R | Repaired scrap chute on RH side. Inspected the die.  Strip some times feeds on top of guide. Then when it gets hit can cause that mark. Then the next station flattens it. | 53273-08010 #190
TTMA | #192 | 58193- 08020 | 2009-09-11 00:00:00 |  | 5-1 | Scrap was not trimmed off |  | 4 | Die Issue | Jeff J | Root Cause: Scrap BU. Die crashed and parts were not contained. | 58193-08020 #192
TTMA | #195 | 58193- 08020 | 2009-09-11 00:00:00 |  | 5-1 | Burr |  | 4 | Die Issue | Jeff J | Root Cause: Scrap BU. Die crashed and parts were not contained. | 58193-08020 #195
TTMA | #199 | 55172- 0E011 | 2009-09-17 00:00:00 |  | 5-2 | [NAME] |  | 4 | Stamping Issues | Jeff J | Found nothing wrong with the die. Stamping Issue. | 55172-0E011 #199
TTMA | #200 | 48733-08010 | 2009-09-17 00:00:00 |  | 5-2 | Bent |  | 4 | Die Issue | Chad R | The parts were hanging on the exit chute and getting bent. Chute didn’t have enough support. | 48733-08010 #200
TTMA | #203 | 67185- 08020 | 2009-09-18 00:00:00 |  | 5-1 | [NAME] | 2009-03-10 00:00:00 | 4 | Die Issue | Jeff J | On 9-22-09 wiped die out . Didn’t find anything. | 67185-08020 #203
TTMA | #214 | 53732- 08020 | 2009-09-25 00:00:00 |  | 1-1 | Burrs |  | 4 | Die Issue | [NAME] | Fixed. Same old issues. Cracks chips. This is a problem die we have never totally had under control. | 53732-08020 #214
TTMA | #222 | 55194- 0E020 | 2009-09-30 00:00:00 |  | 5-2 | [NAME] |  | 4 | Stamping Issues | Jeff J | Die wasn’t all the way to the stops. Stamping was having alignment issues | 55194-0E020 #222
TTMA | #225 | 58371- 08020 | 2009-10-05 00:00:00 |  | 3-1 | Wrinkled---- [NAME] |  | 4 | Stamping Issues | Shane R | Before this die was inspected it ran again at least once with no problems. This was a miss-located part. Stamping Issue. The part was miss-located in the 1/6. You can tell that the part was formed and then reformed out of location. The die is in good condition. | 58371-08020 #225
TTMA | #233 | 57312- 08010 | 2009-10-06 00:00:00 |  | 1-1 | Burr |  | 4 | Stamping Issues | [NAME] | Die was inspected and no issues found. Appears that it was a double hit.
TTMA | #250 | 57795- 08010 | 2009-10-19 00:00:00 |  | 5-2 | Short Stamped |  | 4 | Stamping Issues | Jeff J | Adjusted the material guides 10-20-09 and reinstalled the guides on 10-26-09 when R.S. had it out.   We found out that a non-standard coil was ran and entry guides had to be moved. After run there was issues getting them set to original location. We had to set them out of the press. | 57795-08010 #250
TTMA | #252 | 42111- 08020 | 2009-10-22 00:00:00 |  | 4-1 | Nut Impression in part | 2009-07-15 00:00:00 | 4 | Die Issue | Shane R | This is from the blanker. It was found that there was a broken bolt head in the die. We replaced this on 10-23-09. R/C this is a hard hitting die. | 42111-08020 #252
TTMA | #253 | 57161- 08020 | 2009-10-28 00:00:00 |  | 2-1 | Mis-Stamped- Scrap Mark |  | 4 | Stamping Issues | Jeff J | miss-stamp and scrap mark were caused by a feed issue. We found scrap in die caused by a short stamp. Not a die issue | 57161-08020 #253
TTMA | #254 | 57653- 08020 | 2009-10-28 00:00:00 |  | 3-1 | Split |  | 4 | Stamping Issues | [NAME] | Not Split. Mis-grip rod got smashed. Welded and ground in forms in the 4/6 on 10/23/09. Changed spring in the upper | 57653-08020 #254
TTMA | #255 | 48232/3- 08010 | 2009-10-28 00:00:00 |  | 1-1 | Tooling mark | 2008-10-06 00:00:00 | 4 | miss-located part | [NAME] | we polished 1/6 2/6 for gauld. 5/6 we replaced 73d and repaired a chip in 59b. | 48232/3-08010 #255
TTMA | #260 | 61211/2-0E040 | 2009-10-30 00:00:00 |  | 4-1 | SCRAP MARK |  | 4 | Die Issue | SHANE R | There were 2 spring plungers on the rear 2/6 that would trap between plunger and stripper and hold scrap then drop it on the die. We removed the spring plungers.  [NAME] flowing good. | 61211/2-0E040 #260
NONC | #426 TTTX | 48623-0C020 | 2009-11-04 00:00:00 |  | 4-1 | Split | 2009-07-15 00:00:00 | 4 | Die Issue | Shane R | Busted cutter found in the split area. Replaced 33C- 33B- 33E -33A.  Stressed cutters. Normal wear and tear. | 48623-0C020 #426 TTTX
TTMA | #265 | 42111-02070 | 2009-11-06 00:00:00 |  | 4-1 | Burr | 2009-11-01 00:00:00 | 4 | Die Issue | Shane R | The cutter was  wore. Welded and ground in. replaced punch as well it was laid back a bit. RC:  Incorrect clearance wore out cutter. Missed during pm. Retrain tm on checking cutters and last part ran for pms. | 42111-02070 #265
QPR | 109-09 TTTX | 48621-0C010 | 2009-11-10 00:00:00 |  | 4-1 | Split | 2009-10-20 00:00:00 | 4 | Material Issue | Shane R | Splits coming and going. Material issue.  I think the splits are material related. Too random to be the die. | 48621-0C010 109-09 TTTX
TTMA | #269 | 61323/4-0E040 | 2009-11-13 00:00:00 |  | 1-1 | MIS_GRIP ALLEN WRENCH STUCK IN PART |  | 4 | Stamping Issues | Chad R | Operator left wrench in the die. Inspected at the press. Had o/l burr.  Fixed 11/11/09. | 61323/4-0E040 #269
NONC | #423  TTTX | 48621-0C010 | 2009-10-16 00:00:00 |  | 4-1 | OUTLINE BURR |  | 4 | Die Issue | Shane R | chipped cutters. Incorrect cutting clearance. Retrain tm on cutting clearance of 1/2 moon cutters. | 48621-0C010 #423 TTTX
QPR | #02-QPR-106014-TMMI | 42111-08020-BL | 2009-10-17 00:00:00 |  | 4-1 | Sliver burr | 2009-06-11 00:00:00 | 4 | Die Issue | Shane R | The Slivers are on the blanks before they go to the 4-1. during inspection we found an upper trim cutter that had a low spot, allowing a sliver to form. We ground the cutter and shimmed it up. 11-18-09 CM: refresh tm on keeping die sections in original condition. | 42111-08020-BL #02-QPR-106014-TMMI
QIR | #277 | 57117/8-0E010 | 2009-11-20 00:00:00 |  | 1-1 | DIE MARK | 2009-11-10 00:00:00 | 4 | Die Issue | Jeff J | A bolt in the 7/8 front cam stripper came loose. Tightened it up. Ready to go. May need new bolt . | 57117/8-0E010 #277
QPR | 118-09 TTTX | 48514-0C010 | 2009-11-23 00:00:00 |  | 5-1 | MISS-LOCATED PART |  | 4 | Stamping Issues | [NAME] | The blanks are coming up crooked bending the fingers which caused a miss-located part. Fingers need to be fixed. R/C vac. Cups
QPR | 119-09 TTTX | 48624-0C020 | 2009-11-24 00:00:00 |  | 4-1 | MIS-LOCATED PART |  | 4 | Stamping Issues | Shane R | FINGERS OUT OF ADJUSTMENT. ON 11-16-09 FINGERS WERE ADJUSTED IN PRESS. | 48624-0C020 #119-09 TTTX
QPR | #02-QPR-106187--TMM1 | 42111-08020 | 2009-11-24 00:00:00 |  | 4-1 | MISSING DATUM HOLE |  | 4 | Die Issue | [NAME] | The punch broke due to fatigue.  We pulled die to repair. Stamping missed during sort. | 42111-08020 #02-QPR-106187-TMMI
TTMA | #279 | 55743-08020 | 2009-11-30 00:00:00 |  | 5-2 | MIS-STAMPED |  | 4 | Stamping Issues | Shane R | Start up part not scrapped. You can see where the coil was cut with a nibbler. | 55743-08020 #279
TTMA | #280 | 57147-0E050 | 2009-11-30 00:00:00 |  | 5-2 | mis-stamped |  | 4 | Stamping Issues | Shane R | The die was inspected and pm'd. The only issues found were a couple of compressed lifter springs which would be enough to cause mis-feed. Press issue. | 57147-0E050 #280
TTMA | #281 | 53216-08021 | 2009-11-30 00:00:00 |  | 1-1 | Weld slag on part. |  | 4 | Welding issue | ? | Die was inspected and found a very small amount of slag in the 3/6 upper. 1st shift ground and stoned the strippper 12-1-09. | 53216-08021 #281
QPR | #121-09 TTTX | 48628/9-0C010 | 2009-11-25 00:00:00 |  | 2-1 | Start up parts not scrapped |  | 4 | Stamping Issues | Jeff J | Start up part not scrapped. | 48628/9-0C010 #121-09 TTTX
NONC | #435-TTTX | 55171/5-0C010 | 2009-12-08 00:00:00 |  | 2-1 | Bent tab. Holes out of alignment |  | 4 | Die Issue | Jeff J | [NAME] restrike bolts and loose clamps. These bolts and clamps need to be added to the special check items to check every time it s in the shop or when a strip gets folded. Also modified lifter by adding pads to the side to help with location. And tightened up the clamps thst hold the restrike in place.
QPR | #130-09--TTTX | 55171/5-0C010 | 2009-12-16 00:00:00 |  | 2-1 | Bent tab. Holes out of alignment |  | 4 | Die Issue | Jeff J | [NAME] restrike bolts and loose clamps. These bolts and clamps need to be added to the special check items to check every time it s in the shop or when a strip gets folded. Also modified lifter by adding pads to the side to help with location. And tightened up the clamps thst hold the restrike in place.
QPR | #288 | 51165/66-04010 | 2009-12-18 00:00:00 |  | 3-1 | mis-stamped hole |  | 4 | Die Issue | Chad R | Found a chip in the punch and found that the button was lower than the rest, so we shimmed it up  [NAME] and ground it in. The button hasn’t been worked on in over a year. Wear on button allowed the slug to pull out.