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

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Shane Roby |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] Chaffin | None
ER over 30 mins |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | StampingTLs
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
# of ER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DPR "Values for Chart" Entries
Hrs
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Press #s
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stamping | Fingers
# of ER Per Press over 30 mins |  |  |  |  |  |  |  | ER Downtime Per Press over 30 mins |  |  |  |  |  |  |  |  |  |  |  |  | Mis-stamp |  |  |  | 1-1
 | 1-1 | 2-1 | 3-1 | 4-1 | 5-1 | 5-2 |  |  | 1-1 | 2-1 | 3-1 | 4-1 | 5-1 | 5-2 |  |  |  |  |  |  | Misfeed |  |  |  | 2-1
Jan |  |  |  |  |  |  |  | Jan |  |  |  |  |  |  |  |  |  |  |  |  | Press Set-up |  |  |  | 3-1
Feb |  |  |  |  |  |  |  | Feb |  |  |  |  |  |  |  |  |  |  |  |  | Press Issues |  |  |  | 4-1
Mar |  |  |  |  |  |  |  | Mar |  |  |  |  |  |  |  |  |  |  |  |  | Die not written up |  |  |  | 5-1
Apr |  |  |  |  |  |  |  | Apr |  |  |  |  |  |  |  |  |  |  |  |  | Human error |  |  |  | 5-2
May |  |  |  |  |  |  |  | May |  |  |  |  |  |  |  |  |  |  |  |  | Stamping Misc
Jun |  |  |  |  |  |  |  | Jun
Jul |  |  |  |  |  |  |  | Jul |  |  |  |  |  |  |  |  |  |  |  | Die Maint | [NAME]
Aug |  |  |  |  |  |  |  | Aug |  |  |  |  |  |  |  |  |  |  |  |  | O/L Burr
Sep |  |  |  |  |  |  |  | Sep |  |  |  |  |  |  |  |  |  |  |  |  | Marks on part
Oct |  |  |  |  |  |  |  | Oct |  |  |  |  |  |  |  |  |  |  |  |  | Misassemble
Nov |  |  |  |  |  |  |  | Nov |  |  |  |  |  |  |  |  |  |  |  |  | Scrap Issue
Dec |  |  |  |  |  |  |  | Dec |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gauld
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Splits
# of ER Per Press |  |  |  |  |  |  |  | ER Downtime Per Press |  |  |  |  |  |  |  |  |  |  |  |  | Breakage
 | 1-1 | 2-1 | 3-1 | 4-1 | 5-1 | 5-2 |  |  | 1-1 | 2-1 | 3-1 | 4-1 | 5-1 | 5-2 |  |  |  |  |  |  | Deformation
Jan |  |  |  |  |  |  |  | Jan |  |  |  |  |  |  |  |  |  |  |  |  | Pulled Hole
Feb |  |  |  |  |  |  |  | Feb |  |  |  |  |  |  |  |  |  |  |  |  | Out of Spec
Mar |  |  |  |  |  |  |  | Mar |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Apr |  |  |  |  |  |  |  | Apr
May |  |  |  |  |  |  |  | May |  |  |  |  |  |  |  |  |  |  |  | Extra | Die Repair Tag
Jun |  |  |  |  |  |  |  | Jun
Jul |  |  |  |  |  |  |  | Jul
Aug |  |  |  |  |  |  |  | Aug
Sep |  |  |  |  |  |  |  | Sep
Oct |  |  |  |  |  |  |  | Oct
Nov |  |  |  |  |  |  |  | Nov
Dec |  |  |  |  |  |  |  | Dec
Top 10 Problem Dies Per Month
 | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10
Jan
ER's
Hrs
Feb
ER's
Hrs
Mar
ER's
Hrs
Apr
ER's
Hrs
May
ER's
Hrs
Jun
ER's
Hrs
Jul
ER's
Hrs
Aug
ER's
Hrs
Sep
ER's
Hrs
Oct
ER's
Hrs
Nov
ER's
Hrs
Dec
ER's
Hrs
Pulled Dies Monthly Averages
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | [NAME]
Cases
Down Time Monthly Averages
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | [NAME]
Hours
Jan | 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
Pulled Dies
Down Time
ER Cases
Feb | 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
Pulled Dies
Down Time
ER Cases
Mar | 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
Pulled Dies
Down Time
ER Cases
Apr | 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
Pulled Dies
Down Time
ER Cases
May | 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
Pulled Dies
Down Time
ER Cases
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
Pulled Dies
Down Time
ER Cases
Jul | 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
Pulled Dies
Down Time
ER Cases
Aug | 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
Pulled Dies
Down Time
ER Cases
Sep | 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
Pulled Dies
Down Time
ER Cases
Oct | 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
Pulled Dies
Down Time
ER Cases
Nov | 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
Pulled Dies
Down Time
ER Cases
Dec | 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
Pulled Dies
Down Time
ER Cases