Spreadsheet: 64406d1265268223-help-using-vlookup-in-a-conditonal-formating-consumable-usage-trial
Sheet: Usage Report 2007-2009

From: 11/1/2007  Last updated: 2/2/2010/ USAGE REPORT |  |  |  |  | BLANKS | ERRORS / ADJUSTMENTS | BLUE / NEGATIVE | 5PE Dies | Service Dies |  |  |  |  | MODIFIED | QTYADJUST | USEDBYOTHERDEPT | 9001 | 9002 | 9003 | 9004
 |  |  |  |  |  |  | ORANGE / ERRORS | Grinding Wheels | Mounted Point |  |  |  |  | 42111-02070-BL | 42111-08030-T1 | 42111-08020-00 | 48232/3-08010-T1 | 48232/3-08020-T1 | 48621-0C010-T1 | 48622-0C010-T1 | 48623-0C020-T1 | 48711/2-08010-00 | 48621-08030-T1 | 48622-08030-T1 | 42111-02070-00 | 42111-08030-BL | 42111-08020-BL | 48232/3-08010-BL | 48232/3-08020-BL | 48621/2-0C010-BL | 48624-0C020-T1 | 48623/4-0C020-BL | 48711/2-08010-BL | 48623-08030-T1 | 48624-08030-T1
DATE | EMPLOYEE# | EMPLOYEE FIRST NAME | EMPLOYEE LAST NAME | TTMA PART # | VENDOR PART # | MACHINE DIE # | QTY | UNIT COST | TOTAL COST
01/14/10 | 1485 | [NAME] | YOUNG | P00600 | H-APAL13-100-P8.2 | 42111-02070 | 1 | 29.76 | 29.76
01/14/10 | 0273 | JEREMY | MEDCALF | P00600 | H-APAL13-100-P8.2 | 42111-02070 | 1 | 29.76 | 29.76
01/15/10 | 0978 | [NAME] | SHOEMAKER | SP00008 | PJH16-40 | 55712-08040-T1 | 1 | 19 | 19
01/15/10 | 1412 | SAMMY | KUBOTA | P00489 | S-RTP22-125-P19.1 B85-S30 | 61145/6-08030-T1 | 2 | 113 | 226
01/16/10 | 1135 | PATRICK | PAFF | P00231 | SJAL-C32-80-P28.0 | 48621-0C010-T1 | 1 | 25.41 | 25.41
01/16/10 | 0971 | DUSTIN | SALLEE | S00211 | SWF40-80 | 46212-TE0011/12-T1 | 2 | 3.06 | 6.12
01/16/10 | 0971 | DUSTIN | SALLEE | S00495 | SWL50-60 | 46212-TE0011/12-T1 | 4 | 5.01 | 20.04
01/18/10 | 0972 | GREGORY | HAIRE | [NAME] | [NAME] | 57663-0E040-T1 | 1 | 14.06 | 14.06
01/18/10 | 0972 | GREGORY | HAIRE | [NAME] | [NAME] | QTYADJUST | 4 | 14.06 | 56.24
01/18/10 | 0972 | GREGORY | HAIRE | B00467 | KDE22-16-P12.3-W7.3 | 57663-0E040-T1 | 1 | 34.8 | 34.8
01/18/10 | 0972 | GREGORY | HAIRE | P00614 | T-SJEL13-80-P12.0-W7.0 | 57663-0E040-T1 | 1 | 33.24 | 33.24
01/19/10 | 1413 | JASON | CARLTON | P00048 | SJAL10-80-P8.6 | 57832-0E040-T1 | 1 | 9.06 | 9.06
01/19/10 | 0978 | [NAME] | SHOEMAKER | B00229 | [NAME]-P12.3 | MODIFIED | 1 | 9.8 | 9.8
01/19/10 | 0978 | [NAME] | SHOEMAKER | P00150 | T-SJAL16-80-P13.1 | 55731-08020-T1 | 1 | 25.36 | 25.36
01/19/10 | 1485 | [NAME] | YOUNG | P00092 | SJAL13-90-P10.0 | 57486/7-0C020-T1 | 1 | 9.84 | 9.84
01/19/10 | 1455 | DANIEL | EDDS | R00003 | DPAR13 | 57486/7-0C020-T1 | 1 | 14.1 | 14.1
01/19/10 | 0978 | [NAME] | SHOEMAKER | MP00014 | Y-MO 321 ORANGE | 57468/9-08020-00 | 1 | 0.98 | 0.98
01/19/10 | 9002 | MACHINE MAINT |  | S01360 | SWY20.5-100 | USEDBYOTHERDEPT | 1 | 3.56 | 3.56
01/20/10 | 0978 | [NAME] | SHOEMAKER | P00213 | SJAL25-80-P21.0 | 61321-0E040-T1 | 1 | 0.1 | 0.1
01/20/10 | 0978 | [NAME] | SHOEMAKER | P00660 | T-APJAL25-80-P21.0 | QTYADJUST | 6 | 92.94 | 557.64
01/20/10 | 0935 | CHRISTOPHER | EARLY | S01489 | [NAME] | 46212-TE0011/12-T1 | 1 | 2.2 | 2.2
01/20/10 | 0925 | MIKE | STONE | SP00003 | PJH12-15 | 63132-04040-T1 | 8 | 5.7 | 45.6
01/20/10 | 0925 | MIKE | STONE | S00777 | SWM50-275 | 63132-04040-T1 | 1 | 20.68 | 20.68
01/21/10 | 1413 | JASON | CARLTON | GP00032 | SGRN60-280-W | 57475-08020-T1 | 2 | 116.1 | 232.2
01/21/10 | 1455 | DANIEL | EDDS | B00329 | KSD25-22-P15.6 | 57791/2-08010-00 | 1 | 11.1 | 11.1
01/21/10 | 0978 | [NAME] | SHOEMAKER | P00213 | SJAL25-80-P21.0 | 61321-0E040-T1 | 1 | 0.1 | 0.1
01/21/10 | 0978 | [NAME] | SHOEMAKER | P00214 | SJAL25-80-P22.0 | MODIFIED | 1 | 14.76 | 14.76
01/21/10 | 0725 | JEFFREY | COOMES | S01447 | SWR31-140 | 57791/2-08010-00 | 3 | 4.03 | 12.09
01/21/10 | 0221 | BILLY | HOUSEHOLDER | S01427 | SWR21-35 | 57635-0E010-T1 | 4 | 2.05 | 8.2
01/21/10 | 0221 | BILLY | HOUSEHOLDER | S01427 | SWR21-35 | 57635-0E010-T1 | 4 | 2.05 | 8.2
01/22/10 | 1432 | MIKE | SHEERAN | P00037 | SJAL10-80-P7.4 | 55741-08010-T1 | -11 | 8.6 | -94.6
01/22/10 | 0504 | CHRISTOPHER | MCDONALD | GB00081 | GBW-50 | 48711/2-08010-00 | 4 | 29.4 | 117.6
01/22/10 | 0273 | JEREMY | MEDCALF | GB00081 | GBW-50 | 48711/2-08010-00 | 1 | 29.4 | 29.4
01/25/10 | 0129 | CHRISTOPHER | HODSKINS | P00026 | SJAL10-80-P7.0 | 55712-08030-00 | 2 | 9.06 | 18.12
01/25/10 | 0971 | DUSTIN | SALLEE | B00184 | KSD20-25-P10.3 | 57479-08010-T1 | 1 | 9.06 | 9.06
01/25/10 | 0971 | DUSTIN | SALLEE | B00184 | KSD20-25-P10.3 | 57479-08010-T1 | 1 | 9.06 | 9.06
01/25/10 | 0971 | DUSTIN | SALLEE | B00184 | KSD20-25-P10.3 | 57479-08010-T1 | -1 | 9.06 | -9.06
01/25/10 | 0978 | [NAME] | SHOEMAKER | [NAME] | DPFR20 | 61211/2-0E040-T1 | 1 | 16.2 | 16.2
01/25/10 | 0978 | [NAME] | SHOEMAKER | SP00012 | PJH16-80 | 61211/2-0E040-T1 | 1 | 38 | 38
01/27/10 | 1413 | JASON | CARLTON | P00090 | T-SJAL13-80-P10.0 | 48621-08030-T1 | 1 | 25.02 | 25.02
01/27/10 | 0154 | DARRELL | WALTHALL | P00014 | SJAL10-80-P6.0 | 61344-0E040-T1 | 1 | 9.06 | 9.06
01/27/10 | 0154 | DARRELL | WALTHALL | B00041 | KSD13-20-P6.3 | 61344-0E040-T1 | 1 | 8.4 | 8.4
01/27/10 | 0504 | CHRISTOPHER | MCDONALD | MP00022 | MWDR6-17-3-30-220 | 46212-TE0011/12-T1 | 4 | 2 | 8
01/27/10 | 0504 | CHRISTOPHER | MCDONALD | MP00021 | MWDR10-20-3-30-220 | 46212-TE0011/12-T1 | 4 | 2.19 | 8.76
01/27/10 | 1342 | JAYLON | HAYDEN | P00620 | APJAL16-80-P14.0 | 57663-0E040-T1 | 1 | 50.88 | 50.88
01/28/10 | 0725 | JEFFREY | COOMES | [NAME] | SWF40-150 | 51158/67-04010-00 | 2 | 5.35 | 10.7
01/28/10 | 0725 | JEFFREY | COOMES | R00026 | BPC13 | 51158/67-04010-00 | 1 | 9 | 9
01/29/10 | 0129 | CHRISTOPHER | HODSKINS | B00011 | 46212-TE011/12-150L DET64 | 46212-TE0011/12-T1 | 2 | 90.85 | 181.7
01/29/10 | 0129 | CHRISTOPHER | HODSKINS | B00011 | 46212-TE011/12-150L DET64 | 46212-TE0011/12-T1 | 1 | 90.85 | 90.85
01/29/10 | 0154 | DARRELL | WALTHALL | R00021 | AP-AP16 | 57471/2-0E030-T1 | 1 | 23.4 | 23.4
01/29/10 | 0154 | DARRELL | WALTHALL | P00544 | T-APJAL16-80-P13.0 | 57471/2-0E030-T1 | 1 | 64.68 | 64.68
01/30/10 | 1413 | JASON | CARLTON | P00089 | SJAL13-80-P10.0 | 57117/8-0E010-00 | 1 | 8.9 | 8.9
01/30/10 | 1413 | JASON | CARLTON | B00178 | KSD20-20-P10.2 | 57117/8-0E010-00 | 1 | 9.06 | 9.06
01/30/10 | 1413 | JASON | CARLTON | S00217 | SWF40-250 | 57117/8-0E010-00 | 4 | 8.45 | 33.8
01/29/10 | 0154 | DARRELL | WALTHALL | SP00002 | PJH12-10 | 48711/2-08010-00 | 2 | 6.1 | 12.2
01/29/10 | 0273 | JEREMY | MEDCALF | P00231 | SJAL-C32-80-P28.0 | 48621-0C010-T1 | 1 | 25.41 | 25.41
02/01/10 | 0925 | MIKE | STONE | P00026 | SJAL10-80-P7.0 | 57451-08020-T1 | 1 | 9.06 | 9.06
02/01/10 | 0154 | DARRELL | WALTHALL | P00026 | SJAL10-80-P7.0 | 57451-08020-T1 | 1 | 9.06 | 9.06
02/01/10 | 1121 | CHAD | ROSS | P00026 | SJAL10-80-P7.0 | QTYADJUST | -9 | 9.06 | -81.54
02/01/10 | 0925 | MIKE | STONE | P00623 | T-SJAL10-80-P7.0 | 57451-08020-T1 | 1 | 22.74 | 22.74
02/01/10 | 0925 | MIKE | STONE | P00168 | SJAL16-80-P15.0 | 57451-08020-T1 | 2 | 10.27 | 20.54
02/01/10 | 0129 | CHRISTOPHER | HODSKINS | S01052 | SWH60-175 | 61344-0E040-T1 | 1 | 21.2 | 21.2
02/01/10 | 0935 | CHRISTOPHER | EARLY | S01426 | SWR14.5-125 | 48514-0C010-T1 | 1 | 2.94 | 2.94
02/01/10 | 1084 | KEVIN | SEXTON | P00039 | SJAL10-80-P8.0 | 46212-TE0011/12-T1 | 2 | 9.06 | 18.12
02/01/10 | 1084 | KEVIN | SEXTON | P00145 | T-SJAL16-80-P13.0 | 46212-TE0011/12-T1 | 1 | 26.7 | 26.7
02/01/10 | 1084 | KEVIN | SEXTON | R00004 | DPAR16 | 46212-TE0011/12-T1 | 1 | 14.8 | 14.8
02/01/10 | 1084 | KEVIN | SEXTON | S00045 | SWF12-45 | 46212-TE0011/12-T1 | 2 | 1.06 | 2.12
02/02/10 | 1084 | KEVIN | SEXTON | S01428 | SWR21-40 | 46212-TE0011/12-T1 | 4 | 1.85 | 7.4
02/02/10 | 0925 | MIKE | STONE | B00178 | KSD20-20-P10.2 | 46523-TE001-00 | 1 | 9.06 | 9.06
02/02/10 | 0154 | DARRELL | WALTHALL | P00087 | SJAL13-80-P9.9 | 57117/8-0E010-00 | 1 | 9.34 | 9.34
02/02/10 | 0273 | JEREMY | MEDCALF | P00173 | SJAL16-80-P15.2 | 48515-0C010-BL | 1 | 10.27 | 10.27
02/02/10 | 0154 | DARRELL | WALTHALL | P00144 | SJAL16-80-P13.0 | 57615/6-0E040-T1 | 13 | 10.27 | 133.51
 |  |  |  |  |  | 48621-0C010-T1