Spreadsheet: 115300d1310957425-complete-data-linked-from-1-sheet-to-another-w-in-a-date-range-example
Sheet: July 2010

Start date |  | 2010-07-04 00:00:00 |  | End Date |  | 2010-07-31 00:00:00 |  | July 2010 Sales |  | 3000000 |  |  | Total Cost of tooling |  |  |  | % of sales
date |  | Tool Number | HMC Part # | Name |  |  | Shift | Machine | Type of Tool |  | Reason |  | [NAME] | Tool Description |  | Manufacture | Tool Body Part Number |  |  | Body Cost | engineering determined failure mode
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Operator | Machine | Method
2010-07-06 00:00:00 |  | 173 | 600060457 | [NAME] parker |  |  | 1 | MS 200 | [NAME] |  | [NAME] |  | 5.0 | 5" FACE MILL 45 DEG |  | ISCAR | S845F45SXD5.0-8-1.5-R16 |  |  | 275
2010-07-09 00:00:00 |  | 185 | 600060594 | DAVIS, [NAME] |  |  | 1 | MS 300 | [NAME] |  | [NAME] |  | 1.260 (32MM) | 32mm DIA. INSERTED DRILL 3X |  | KENNAMETAL | KSEM1250R3SSF125 |  |  | 250
2010-07-09 00:00:00 |  | 133 | 600-06-0457 | [NAME] parker |  |  | 1 | MS 200 | [NAME] |  | [NAME] |  | 2.00 (50.80MM) | 2.0" INSERTED DRILL |  | OTM | DR2000 X3N |  |  | 500
2010-07-14 00:00:00 |  | 80 | 600060607 | GREEN, CHAD E. |  |  | 1 | MS 400 | [NAME] |  | [NAME] |  | 2.625 (66.67MM) | 2-5/8 DIA. INSERTED DRILL |  | OTM | DR-2625 2X |  |  | 750
2010-07-15 00:00:00 |  | 5 | 600060530 | SELLERS, ROGER D |  |  | 1 | SNK | [NAME] |  | Normal Wear |  | 5.0 | 5" FACE MILL 45 DEG |  | ISCAR | S845F45SXD5.0-8-1.5-R16 |  |  | 275
2010-07-15 00:00:00 |  | 28 | 600060421 | JONES, CHERIE |  |  | 1 | MS 300 | Tap |  | Bad Casting |  | 1.25-7 | 1.25" - 7 SPIRAL FLUTE TAP |  | EMUGE | CU5032005020 (MSC# 95895397) |  |  | 556
2010-07-16 00:00:00 |  | 31 | 600060437 | JONES, CHERIE |  |  | 1 | MS 400 | Tap |  | Bad Casting |  | 1"-8 | 1"-8 SPIRAL FLUTED TAP (COATED) |  | EMUGE | CU5137005018 |  |  | 674.38
2010-07-19 00:00:00 |  | 28 | 600060421 | JONES, CHERIE |  |  | 1 | MS 300 | Tap |  | Bad Casting |  | 1.25-7 | 1.25" - 7 SPIRAL FLUTE TAP |  | EMUGE | CU5032005020 (MSC# 95895397) |  |  | 556
2010-07-22 00:00:00 |  | 68 | 600060530 | [NAME] |  |  | 2 | SNK | [NAME] |  | [NAME] |  | 1.047 (26.59MM) | 1.047" DIA. INSERTED DRILL 3X WITH CHAMFER |  | KENNAMETAL | KSEM1047R3SSF125(DRILL BODY) |  |  | 722
2010-07-23 00:00:00 |  | 28 | 600060421 | JONES, CHERIE |  |  | 1 | MS 300 | Tap |  | Bad Casting |  | 1.25-7 | 1.25" - 7 SPIRAL FLUTE TAP |  | EMUGE | CU5032005020 (MSC# 95895397) |  |  | 556
2010-07-27 00:00:00 |  | 31 | 600060530 | [NAME] |  |  | 2 | SNK | [NAME] |  | Operator Error |  | 3" | 3" 90deg.  FACE MILL (10" HOLDER) |  | ISCAR | H490 F90AX D3.00-5-10-17 |  |  | 400
2010-07-30 00:00:00 |  | 193 | 600060607 | SIMS, WILLIAM "STACY" |  |  | 1 | MS 400 | Chamfer |  | [NAME] |  | 45 DEG. | 45 DEGREE CHAMFER |  | TUNGALOY | ECC31005RU-45 |  |  | 250
Count |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Cost
Failure by Type of Tool |  |  |  |  |  | Failure by Machine |  |  |  | Failure by Shift |  |  |  | Failure by Operator Reason Code |  |  |  |  | Total Tooling Cost
Type |  | Count | % |  |  | Machine | Count | % |  | Shift | Count | % |  | Reason | Count | % |  |  |  |  | $ per month | % of sales
 |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | vending machine build a (MSC) | Carbide Insert
 |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  | CBD DRILL TIP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEBURRING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DRILL BODY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INSERT SCREW
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PROBE STEM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TAP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | vending machine build B (MSC) | Carbide Insert
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CBD DRILL TIP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEBURRING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DRILL BODY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INSERT SCREW
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PROBE STEM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TAP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | vending machine build B (Ingersoll) | Carbide Insert
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CBD DRILL TIP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEBURRING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DRILL BODY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INSERT SCREW
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PROBE STEM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TAP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | CARTRIDGES
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Consumable Cost
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total