Spreadsheet: 75490d1276064118-adjusting-ranking-formula-to-only-include-certain-entries-dpr-2010-trial
Sheet: Jun

 |  |  | Daily Problem Report |  |  |  | Monthly Totals |  |  |  | Breakdown of ER and PR |  |  |  |  |  | Color coding of "Value for Chart" field |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  | Jun | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
Daily Avg/Monthly Total |  |  |  |  |  |  | ER | PR | Downtime Hrs |  | Stamping |  |  | DieMaint |  | Today's Date |  |  |  |  |  |  | Pull Repairs
ER Hrs |  |  |  |  |  | Weekdays |  |  |  |  | ER | PR |  | ER | PR |  | DM |  |  |  |  |  | Total |  |  |  |  |  |  |  |  |  |  |  |  |  | Pulled Dies
PR |  |  |  |  |  | Total |  |  |  |  |  |  |  |  |  |  | STAMPING |  |  |  |  |  |  |  |  | #1 | #2 | #3 | #4 | #5 | #6 | #7 | #8 | #9 | #10 |  | Daily Avg/Mth
 |  |  |  |  |  |  | Die Repair Tags |  |  |  | HRS |  |  | HRS |  |  |  |  |  |  |  |  | 1st |  |  |  |  |  |  |  |  |  |  |  |  |  | Down Time
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2nd |  |  |  |  |  |  |  |  |  |  |  |  |  | Daily Avg/Mth
Date | Column1 | Shift | ER/PR | LINE# | DIE# | TYPE | PROBLEM | STATION | RAN | D/T | T/M | Call Time | End Time | ST T/L | ROOT CAUSE: | EXPLAIN: | Value for Chart | Stamping ERs | DM ERs | Stamping PRs2 | DM PRs |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ER Cases
2010-06-01 00:00:00 |  | 1st | ER | 2-1 | 48628/9-0C010 | Die | bent material guide | prog | start of run | 0.25 | greg | 3:00 | 4:15 | [NAME] | material had up bow and with the bent tail out feeder it wouldn’t run. Guide bent due to feed issues. | m/m bent tail out feeder back. We straightened out the guide. Stamping adjusted straightener. Ok. | Press Issues
2010-06-01 00:00:00 |  | 2nd | ER | 1-1 | 61418-0E040 | Die | scrap mark | 1/5 | 80 of 1200 | 0.25 | Greg | 6:25 | 6:54 | [NAME] | punch doesn’t have ejector pin. | pulling slugs ground edge of button. Ok now. | Marks on part
2010-06-01 00:00:00 |  | 2nd | ER | 4-1 | 42111-02070 | Die | coolant line leaking/ repair tag | 3/6 | start of run | 0.75 | Jaylon | 6:00 | 6:45 | [NAME] Chaffin | damaged in shop during repair. | replaced coolant line.  Tightened process bolts. | [NAME]
2010-06-01 00:00:00 |  | 2nd | PR | 4-1 | 42111-02070 | Die | slivers | 3/6 5/6 | 4 containers | 0 | Jaylon | 10:00 | 10:00 | None | unknown | they were going to run 19 containers but they started getting more slivers pulled after 4. | O/L Burr
2010-06-01 00:00:00 |  | 2nd | ER | 3-1 | 57169-08030 | Die | Mark on part | 6/6 | 161 of 1000 | 0.25 | PJ | 2:00 | 2:12 | None | push pin bottoming out | Ground off the bottom of the push pin. | Marks on part
2010-06-01 00:00:00 |  | 2nd | ER | 5-2 | 58296-08010 | Die | strip folded | Prog | 100 of 1000 | 0.25 | [NAME] | 12:00 | 12:10 | None | part got hung on lifter | inspected the die. Removed the strip. | [NAME]
2010-06-01 00:00:00 |  | 1st | ER | 3-1 | 58213-0C040 | Die | o/l burr | 2/6 and 6/6 | 45 / 1500 | 0.25 | [NAME] | 8:48 | 8:58 | Shane Roby | dull cutters | sharpened cutters in press. | O/L Burr
2010-06-01 00:00:00 |  | 1st | PR | 5-2 | 51151-08010 | Press | misfeed | prog | 70 / 1000 | 0.25 | Darrell | 10:00 | 10:20 | None | Operator said it was running in continuous. | Pulle die due to lifter sticking in rear lower. | Misfeed
2010-06-01 00:00:00 |  | 1st | ER | 1-1 | 55741-08010 | Die | scrap buildup | 2/6 | 500 / 1300 | 0.25 | [NAME] | 9:38 | 10:30 | [NAME] | could not tell due to the buildup. | cleaned out the scrap and watched it run. | Scrap Issue
2010-06-01 00:00:00 |  | 1st | ER | 5-1 | 57622-08010 | Operator | finger hitting guide in die | 5/5 | 500 / 1300 | 0.5 | Kenny | 12:00 | 12:30 | None | [NAME] were made or adjusted for SPM trial and the feed side finger is now hitting the material guide. | Took guide off and milled about 10mm off top. | Fingers
2010-06-02 00:00:00 |  | 2nd | ER | 5-1 | 55747/9-08020/30 | Press | strip mis-locating in continuous | prog | 60 of 1080 | 0.25 | Greg | 7:10 | 7:30 | [NAME] | roll lift angle NG. | roll lift angle is opening up too late. At a little past ninety degrees the strip had full contact with lifters and strippers. Changed to 110 deg. Running good now. | Press Set-up
2010-06-02 00:00:00 |  | 2nd | ER | 4-1 | 61343-0E040 | Operator | mis-located part. | 1/5 | 500 of all blanks | 0.25 | [NAME] | 6:35 | 6:55 | [NAME] Chaffin | Mag-chain and fingers. | removed part , inspected. Ok. Adj fingers. | Human error
2010-06-02 00:00:00 |  | 2nd | ER | 4-1 | 61321-0E040 | Die | gauld | 4/6 | 200 of 1200 | 0.25 | Billy | 9:55 | 10:00 | None | coated section gaulded. No spare | inspected. Ok for now. | Gauld
2010-06-02 00:00:00 |  | 2nd | ER | 3-1 | 51145/6-04010/20 | Die | o/l burr | 6/6 | start of 1200 | 0.75 | Travis a | 8:50 | 9:40 | None | bad repair prblem area. | caulked lower cutter. Got better. Same as last run. Need to fix after prod. | O/L Burr
2010-06-02 00:00:00 |  | 2nd | ER | 3-1 | 57615/6-0E040 | Operator | scrap build-up | 3/6 | 750 of 1200 | 0.25 | [NAME] | 1:05 | 1:25 | None | scrap caught on hydrulic hose and built up into die | removed the scrap. It had buldged out the lower cutter because it is soft. Ground this back a little bit and it finished its run. | Human error
2010-06-02 00:00:00 |  | 2nd | PR | 2-1 | 48711/2-08010 | Press | Broken pilot | Prog | 40 of 1500 | 0.25 | [NAME] | 12:56 | 1:37 | [NAME] | Feeder fed up too soon, maybe | removed the broken pilot. Pulled die. | Press Issues
2010-06-02 00:00:00 |  | 2nd | ER | 1-1 | 57663-0E030 | Die | Scrap build-up | 2/6 | 550 of 1250 | 0.25 | [NAME] | 12:55 | 1:15 | [NAME] | [NAME] on lug | removed the scrap | Scrap Issue
2010-06-02 00:00:00 |  | 2nd | ER | 4-1 | 48622-08030 | Die | mislocated part | 1/8 | 150 of 1400 | 0.25 | PJ | 3:35 | 3:45 | None | bowed blanks | removed the part and helped adjust the fingers | Mis-stamp
2010-06-02 00:00:00 |  | 2nd | ER | 4-1 | 48622-08030 | Die | mislocated part | 1/8 | 909 of 900 | 0.25 | [NAME] | 3:37 | 3:47 | None | bowed blanks | removed the part and inspected the die. They were finishing up their run. | Mis-stamp
2010-06-02 00:00:00 |  | 1st | ER | 4-1 | 57451-0E040 | Die | scrap buildup | 2/6 front exit | 623 / 1000 | 0.5 | [NAME] | 7:20 | 7:45 | Shane Roby | still kaizening chute | removed scrap and bent deflectors. | Scrap Issue
2010-06-02 00:00:00 |  | 1st | ER | 2-1 | 57161-08020 | Die | misgrip rod hitting | exit area | startup | 0.25 | [NAME] | 10:20 | 10:35 | [NAME] | we had modified chute bin the shop and the bottom of the misgrip plate was hitting the new chute. | ground bottom of the plate off so misgrip will clear. | [NAME]
2010-06-02 00:00:00 |  | 1st | ER | 2-1 | 55171/5-08030 | Die | parts not falling fast enough | exit area | startup | 0.25 | [NAME], KA | 1:05 | 1:30 | [NAME] | The force of gravity could not keep up with the new speed of 50SPM. | Slowed SPM to 48 ran good. Called Troy and he changed the setup sheet and the program. | Stamping Misc
2010-06-02 00:00:00 |  | 1st | ER | 5-2 | 57796-08010 | Operator | hole burr | prog hole #3 rear | startup | 0.25 | Jeremy | 1:13 | 1:29 | None | strip misfed at stratup | sharpened punch and button | Misfeed
2010-06-03 00:00:00 |  | 1st | ER | 5-1 | 57622-08010 | Die | part bouncing | 5/5 | start of run | 0.25 | Jaylon | 3:10 | 3:45 | [NAME] | broken springs | rolled lower out and replaced sprin in lifter. Ok | Breakage
2010-06-03 00:00:00 |  | 1st | ER | 2-1 | 48621/4-08030 | Die | mis-located strip | prog | 800 of 877 | 0.25 | Greg | 3:20 | 3:40 | [NAME] | blank didn’t fall, strip hung on blank | removed blank and  mis-located strip. Ok. | [NAME]
2010-06-03 00:00:00 |  | 2nd | ER | 4-1 | 42111-02070 | Die | part stuck | 1/6 | ? | 0.25 | Billy | 7:15 | 7:25 | None | bad blank. Blank too wide. Made that way at 2-1 | removed blank and adjusted fingers. Ok. | Human error
2010-06-03 00:00:00 |  | 2nd | ER | 1-1 | 61419-0E40 | Die | scrap build up | 1/5 | 50 of 1200 | 0.25 | Rex | 9:20 | 9:25 | None | gap In chute | removed scra[ and inspected. Need to bring to shoop and fill gap in chute. | Scrap Issue
2010-06-03 00:00:00 |  | 2nd | ER | 2-1 | 55171/5-0C010 | Press | Strip sticking | Prog | 50 of 1200 | 0.25 | PJ | 10:40 | 10:50 | None | feed pitch was off | polished the pilots. Changed the feed pitch from 149.5 to 149.7 to match the setup sheet. | Press Set-up
2010-06-03 00:00:00 |  | 2nd | ER | 4-1 | 61344-0E040 | Operator | Scrap mark | 4/5 | 297 of 1600 | 0.25 | PJ | 11:10 | 11:20 | None | die setter left scrap chute up | built-up into the die. Cleaned it all out and wiped it down. Took some pictures of it. Running good. | Human error
2010-06-03 00:00:00 |  | 2nd | ER | 3-1 | 57471/2-0E030 | Die | Scrap mark | 5/6 | 150 of 1000 | 0.25 | PJ | 2:15 | 2:30 | None | soft cutters in 1/6 | removed the scrap and inspected the die. Finished it run. | Marks on part
2010-06-03 00:00:00 |  | 1st | ER | 2-1 | 48711/2-08010 | Press | strip pulling | front pilot | startup | 0.5 | KA,Hodgy | 8:35 | 9:30 | [NAME] | Press feed angle was no longer right | Pilot was gaulded due to the strip advancing early. Ground and polished pilot, changed feed angle from 240 to 180 degrees. | Press Set-up
2010-06-03 00:00:00 |  | 1st | ER | 5-1 | 48514-0C010 | Die | scarp buildup | 5/5 | 200 / 1000 | 0.5 | Hodgy | 10:00 | 10:30 | [NAME] | air nozzle that blows scrap was knocked out of center. | cleaned scrap out and adjusted airline to blow scrap. | Scrap Issue
2010-06-04 00:00:00 |  | 1st | ER | 1-1 | 53216-08030 | Operator | finger crash | 2/6 | 200 of 800 | 0.5 | Travis a | 4:40 | 5:15 | Shane Roby | finger issue | straightened and adjusted fingers. | Fingers
2010-06-04 00:00:00 |  | 2nd | PR | 3-1 | 58223/4-0C020 | Die | hole not pierced all the way out. | 6/6 | 1000 of 2000 | 0.25 | Rex | 7:35 | 7:40 | None | slug build up | punch may be ok, but button is busted out. The matris holding button is also damaged. Pulled. | Scrap Issue
2010-06-04 00:00:00 |  | 2nd | ER | 3-1 | 57533-0E030 | Die | scrap build up | 5/6 | 1056 of 1200 | 0.25 | Billy | 9:30 | 9:45 | None | [NAME] stopped working | started shaker back and cleaned scrap. Needs repair after run. | Scrap Issue
2010-06-04 00:00:00 |  | 2nd | PR | 5-1 | 55715/6-08010 | Die | mislocated part | 3/5 | 570 of 1400 | 0.25 | [NAME] | 12:00 | 12:15 | [NAME] | broken scrap cutter in the 2/5 caused part to stick in 3/5 | removed the stuck part. Removed the scrap build-up around broken cutter and pulled. | Fingers
2010-06-04 00:00:00 |  | 2nd | PR | 2-1 | 53213/4-08020 | Die | broken bolts | Prog | 350 of 1200 | 0.25 | Dustin | 1:41 | 1:56 | [NAME] | bolts backed out? | inspected and found some other loose and/or broken bolts | Breakage
2010-06-04 00:00:00 |  | 2nd | ER | 3-1 | 51145/6-04010/20 | Press | fringer dropping parts | 6/6 | 720 of 1350 | 0 | PJ | 1:25 | 1:35 | None | fingers out of adjustment | Helped adjust the fingers. | Fingers
2010-06-04 00:00:00 |  | 2nd | ER | 1-1 | 61323/4-0E040 | Die | scrap build-up | 5/5 | 640 of 1500 | 0.75 | PJ | 1:45 | 2:30 | [NAME] | air shakers suck | removed scrap on both front and back side | Scrap Issue
2010-06-04 00:00:00 |  | 2nd | ER | 4-1 | 48623-0C020 | Die | mislocated part | 1/6 | 500 of 1800 | 0 | PJ | 5:05 | 5:20 | None | Fingers | removed the part and helped adjust the fingers | Fingers
2010-06-04 00:00:00 |  | 2nd | PR | 2-1 | 48711/2-08010 | Press | strip hanging on pilot | Prog | 0 of 800 | 0.25 | [NAME] | 3:50 | 4:50 | [NAME] | gaulded pilot and feeding issues (No stamping engineering present to help support like they are supposed to be) | polished the pilot the best we could. Strip was still trying to feed before die was fully opened. Inched out some blanks so they could run some production. | Press Issues
2010-06-04 00:00:00 |  | 2nd | ER | 1-1 | 61323/4-0E040 | Die | scrap build-up | 5/5 | 1360 of 1500 | 0.25 | [NAME] | 3:25 | 3:45 | [NAME] | shakers are junk | oiled the shakers and cleaned out the scrap. Touched up the cutter with a grinder, they were a little rough | Scrap Issue
2010-06-04 00:00:00 |  | 2nd | ER | 4-1 | 48623-0C020 | Operator | part mislocated | 2/6 | 600 / 1800 | 0.25 | PJ | 5:40 | 6:10 | None | Bowed blanks and fingers out, probably knocked out due to the blanks | inspected and adjusted fingers. | Fingers
2010-06-07 00:00:00 |  | 1st | ER | 4-1 | 42111-08030 | Operator | Blank stuck in lower | 1/6 | 730 of 1100 | 0.25 | Greg | 2:55 | 3:00 | None | purchased Blanks 4mm too wide and 1mm too long. | removed blank.ok. | Stamping Misc
2010-06-07 00:00:00 |  | 1st | ER | 5-1 | 55715/6-08010 | Operator | mark on part | 4/5 | 660 of 1200 | 0.25 | Rex | 3:00 | 3:05l | [NAME] | fingers out of adjustment. | adjusted fingers. Ok | Fingers
2010-06-07 00:00:00 |  | 1st | ER | 4-1 | 48711/2-08010 | Die | part stuck in upper | 8/8 | start of run | 0.25 | Greg | 4:50 | 5:10 | [NAME] | no coolant on 1st piece and gaulded sections. | removed part stamping adjusted fingers. Parts got coated with coolant. Ok. There is gauld that needs to be looked into. | Gauld
2010-06-07 00:00:00 |  | 2nd | ER | 4-1 | 48711/2-08010 | Die | part stuck in upper. | 8/8 | end of run. | 0.25 | Greg | 6:10 | 6:28 | None | gaulded sections | polished a bit to finish. Need to bring to the shop after run. | Gauld
2010-06-07 00:00:00 |  | 2nd | ER | 5-1 | 53735/6-08010 | Operator | mis-fed causing hole burrs | 1/6 | 167 of 1200 | 0.25 | Billy h | 7:15 | 7:35 | [NAME] | looks like its running to fast. | removed parts and scrap.  Ground on buttons. OK for now. | Stamping Misc
2010-06-07 00:00:00 |  | 2nd | ER | 4-1 | 48622-0C010 | Die | Split | 2/6 | 0 of 1900 | 0.25 | [NAME], [NAME] | 2:15 | 2:30 | [NAME] Chaffin | [NAME] was low in this area | Changed out section 33C in the upper. Good, finished production | O/L Burr
2010-06-07 00:00:00 |  | 2nd | ER | 5-2 | 58296-08010 | Die | Strip pulling up | Prog | 50 of 400 | 0.25 | Dustin | 3:30 | 3:57 | [NAME] | unknown. Material was really wavy coming out of the feeder | cut out strip, sprayed pilots with WD-40, put in material bridge and raised up the feed roller bridge | [NAME]
2010-06-07 00:00:00 |  | 2nd | PR | 1-1 | 61371-0E040 | Die | O/L burr | 6/6 | 200 of 1200 | 0.25 | [NAME], [NAME] | 3:45 | 4:05 | [NAME] | gap in cast and chute casued scrap build-up and got on cutters | sheared the upper and lower trim cutters. Removed these sections at the press. Pulled | Scrap Issue
2010-06-07 00:00:00 |  | 1st | ER | 3-1 | 58213-0C040 | Die | gauld | 1/6 | 200 / 1500 | 0.5 | Darrell | 7:30 | 8:30 | None | draw pad wore in 1 spot | Polished in press, stayed and polished again after 100 pieces | Gauld
2010-06-07 00:00:00 |  | 1st | PR | 1-1 | 53216-0C010 | Die | [NAME] | 6/6 | 20 / 1500 | 0.5 | Darrell | 12:10 | 12:50 | None | Service die, punches and buttons wore | ground on buttons in press, running what they need, then pulling. | [NAME]