Spreadsheet: 115305d1310965791-complete-data-linked-from-1-sheet-to-another-w-in-a-date-range-example-1-
Sheet: June 2010

Start date |  | 2010-06-01 00:00:00 |  | End Date |  | 2010-06-30 00:00:00 |  | Jun 2010 Sales |  | 3000000 |  |  | Total Cost of tooling |  |  |  | % of sales
Note: The following formula is based the month of date in cell # C1. It is an array formula and should be confirm through Ctrl+Shift+Enter
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
 |  |  |  |  |  |  |  | Copy paste formula on the reminig range to get the result
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