Spreadsheet: 134086d1325002069-create-a-dynamic-print-range-testprint
Sheet: Sheet1

 |  |  | Customer | Sumitomo |  | Date | 2011-12-23 08:44:58 |  |  |  |  |  |  |  | Clear macro >>>>>
 |  |  | Part Number | CHMA7458 |  | # pcs | 1
 |  |  | Order number | 5104828-02 |  | PO# | PVAZXCX02579
 |  |  |  |  |  | Rev | NONE |  |  |  |  |  |  | -
 |  |  |  |  | [NAME] use only |  |  |  |  |  |  |  |  |  | fail |  |  |  | Vlook up tables
 | Clear sheet press ctl c
 | clear drop downs ctrl b |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Linear
 | File save name |  |  | Sumitomo - CHMA7458 - Rev NONE - 5104828-02 - PO# PVAZXCX02579 |  |  |  |  |  |  | Deviations |  |  |  | Tool list validation |  | Dimension Type | Type
 | Item | Type | Dim | Tol 1 | Tol 2 | Tool | Base | Upper | Lower | Actual | Upper | lower | Allow |  | ------------------------- |  |  | linear | over | upto | tol
 | 1 |  | 20 | 0.0065 | -0.0065 |  | 0.7874015748031497 | 0.7876 | 0.7871 |  | 0 | 0.7871 | 0.0004999999999999449 |  | Dial caliper |  | Hole | linear | 0.5 | 6 | 0.01
 | 2 |  | 19 | 0 | -0.2 |  | 0.7480314960629921 | 0.748 | 0.7401 |  | 0 | 0.7401 | 0.007900000000000018 |  | Digital Mic | ______________ | Angular | linear | 6 | 30 | 0.2
 | 3 |  | 22 | 0.0065 | -0.0065 |  | 0.8661417322834646 | 0.8663 | 0.8658 |  | 0 | 0.8658 | 0.0004999999999999449 |  | guage blocks | Advance Design | Plate | linear | 30 | 120 | 0.3
 | 4 |  | 25 | 0.0065 | 0.0065 |  | 0.984251968503937 | 0.9845 | 0.9845 |  | 0 | 0.9845 | 0 |  | Pin guage | Flowserve | Finish | linear | 120 | 400 | 0.5
 | 5 |  | 36 | 0 | -0.039 |  | 1.417322834645669 | 1.4173 | 1.4157 |  | 0 | 1.4157 | 0.001600000000000046 |  | go /no go | Mitsubishi | Weldments | linear | 400 | 1000 | 0.8
 | 6 |  | 19 | 0.041 | 0.02 |  | 0.7480314960629921 | 0.7496 | 0.7488 |  | 0 | 0.7488 | 0.0008000000000000229 |  | Manual mic | Volvo Penta | linear | linear | 1000 | 2000 | 1.2
 | 7 |  | 35 | 0.3 | -0.3 |  | 1.377952755905512 | 1.3897 | 1.3661 |  | 0 | 1.3661 | 0.02359999999999984 |  | comparitor | BAE | specific | linear | 2000 | 4000 | 2
 | 8 |  | 1.35 | 0.14 | 0 |  | 0.05314960629921261 | 0.0586 | 0.0531 |  | 0 | 0.0531 | 0.005499999999999998 |  | Depth mic | [NAME] | Vlookup | linear | 4000 | 8000 | 3
 | 9 |  | 30 | 0.2 | -0.2 |  | 1.181102362204725 | 1.1889 | 1.1732 |  | 0 | 1.1732 | 0.01570000000000005 |  | Bore guage | [NAME] | Plate3-25
 | 10 |  | 26 | 0.21 | -0.2 |  | 1.023622047244094 | 1.0318 | 1.0157 |  | 0 | 1.0157 | 0.0161 |  | Inter mic | DRS | Plate25-50
 | 11 |  | 19 | 0.2 | -0.2 |  | 0.7480314960629921 | 0.7559 | 0.7401 |  | 0 | 0.7401 | 0.01580000000000004 |  | height | Liebherr | part number |  | Holes |  | Machined
 | 12 |  | 7 | 0.2 | -0.2 |  | 0.2755905511811024 | 0.2834 | 0.2677 |  | 0 | 0.2677 | 0.01569999999999999 |  | Tape measure | Ratheon |  | Type | over | upto | tol 1 | Tol 2
 | 13 |  | 9 | 0.2 | -0.2 |  | 0.3543307086614174 | 0.3622 | 0.3464 |  | 0 | 0.3464 | 0.01580000000000004 |  | square | End Tot End |  | Hole | 0 | 0.35 | 0.05 | -0.013
 | 14 |  | 133 | 0.5 | -0.2 |  | 5.236220472440945 | 5.2559 | 5.2283 |  | 0 | 5.2283 | 0.02759999999999962 |  | optical comp | Millcom |  | Hole | 0.35 | 3 | 0.1 | -0.02
 | 15 |  | 2.8 | 0.01 | -0.01 |  | 0.1102362204724409 | 0.1106 | 0.1098 |  | 0 | 0.1098 | 0.000800000000000009 |  | 1-2 | Sumitomo |  | Hole | 3 | 6.5 | 0.12 | -0.03
 |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 2-3 |  |  | Hole | 6.5 | 13 | 0.15 | -0.03
 | 17 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 3-4 |  |  | Hole | 13 | 19.5 | 0.2 | -0.03
 | 18 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 4-5 |  |  | Hole | 19.5 | 26 | 0.25 | -0.03
 | 19 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 5-6 |  |  | Hole | 26 | 0.5 | 0.3 | -0.03
 | 20 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 6-7 |  |  | Hole | 50 | 10000 | 0.4 | -0.03
 | 21 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 7-8
 | 22 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 8-9
 | 23 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  | 9-10 |  |  |  |  | Angular
 | 24 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  |  |  | Type | over | upto | tol
 | 25 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  |  |  | Angular | 0 | 10 | 1
 | 26 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  |  |  | Angular | 10 | 50 | 30
 | 27 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  |  |  | Angular | 50 | 120 | 20
 | 28 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  |  |  | Angular | 120 | 400 | 10
 | 29 |  |  | 0 |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  |  |  | Angular | 400 | 10000 | 5
 | 30 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 31 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 32 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  |  |  |  |  | Gas Cut Plate
 | 33 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  |  |  | Plate | over | u
 | 34 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  |  |  | Plate3-25 | 0 | 1000 | 1
 | 35 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  |  |  | Plate3-25 | 1000 | 3150 | 1.5
 | 36 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  |  |  | Plate3-25 | 3150 | 6300 | 2
 | 37 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  |  |  | Plate3-25 | 6300 | 10000 | 2
 | 38 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  |  |  | Plate25-50 | 0 | 1000 | 1.5
 | 39 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  |  |  | Plate25-50 | 1000 | 3150 | 2
 | 40 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  |  |  | Plate25-50 | 3150 | 6300 | 2.5
 | 41 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0 |  |  |  |  | Plate25-50 | 6300 | 10000 | 2.5
 | 42 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 43 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 44 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 45 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 46 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 47 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 48 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 49 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 50 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 51 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 52 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 53 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 54 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 55 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 56 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 57 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 58 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 59 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 60 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 61 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 62 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 63 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 64 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 65 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 66 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 67 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 68 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 69 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 70 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 71 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 72 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 73 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 74 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 75 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 76 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 77 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 78 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 79 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 80 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 81 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 82 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 83 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 84 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 85 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 86 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 87 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 88 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 89 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 90 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 91 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 92 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 93 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 94 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 95 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 96 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 97 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 98 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 99 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 100 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 100 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 103 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 104 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 105 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 106 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 107 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 108 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 109 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 110 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 111 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 112 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 113 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 114 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 115 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 116 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 117 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 118 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 119 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 120 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 121 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 122 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 123 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 124 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 125 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 126 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 127 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 128 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 129 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 130 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 | 131 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0