| PARAMETRIC VALUES | ||||||||||
| Θ | % OF Θ | PRIMARY LAND WIDTH AT TIP | =A2/100 | =A29*H2 | ||||||
| Θ | % OF Θ | RADIAL RELIEF WIDTH | =A3/100 | =A29*H3 | ||||||
| Θ | % OF Θ | RADIAL DROP | =A4/100 | =A29*H4 | ||||||
| Θ | % OF Θ | CORE DIAMETER | =A5/100 | =A29*H5 | ||||||
| Θ | % OF Θ | MAX CORE DIA AT BACK OF L.O.C. | ||||||||
| Θ | % OF Θ | USE MAX CORE DIA. WHEN L.O.C. MEETS OR EXCEEDS THIS VALUE | =A7/100 | =A29*H7 | =H31/I7 | =IF(J7<I7,J7,I7) | ||||
| FORMULA | =K7*(A6-A5)+A5 | CORE DIAMETER AT BACK OF L.O.C. | =B8/100 | =A29*H8 | ||||||
| Θ | deg | RAKE ANGLE | ||||||||
| Θ | 1/X OF FLUTE DEPTH | MEASURING DEPTH | =((A29-I5)/2)/A10 | |||||||
| Θ | deg | TIP DISH | ||||||||
| RANGE | `=LOOKUP(A29,{Θ},{Θ}) | WEB THICKNESS | =B12/2 | |||||||
| Θ | deg | PRIMARY RELIEF ANGLE | TANGENT | =TAN(RADIANS(A13)) | ||||||
| Θ | deg | SECONDARY RELIEF ANGLE | ||||||||
| Θ | deg | GASH 1,2,3 ANGLE | ||||||||
| Θ | deg | GASH 1 WALK LEN ANGLE | ||||||||
| Θ | % OF Θ | GASH 1 WALK LENGTH | =A17/100 | =A29*H17 | =I17/SIN(RADIANS(A16)) | |||||
| Θ | % OF Θ | GASH 2,3 WALK LENGTH | =A18/100 | =A29*H18 | =I18/SIN(RADIANS(K18)) | Θ | ||||
| Θ | % OF Θ | NOTCH START POSITION | =A19/100 | =I2*H19 | TOOTH ARRAY ANGLE | |||||
| Θ | deg | NOTCH GRIND ANGLE | ||||||||
| Θ | % OF Θ | NOTCH GRIND WALK LENGTH | =A21/100 | =A29*H21 | ||||||
| Θ | % OF Θ | NOTCH GRIND DEPTH AT CENTER | =A22/100 | =A29*H22 | ||||||
| RANGE | `=LOOKUP(A29,{Θ},{Θ}) | CHIP BREAKER DEPTH | ||||||||
| RANGE | `=LOOKUP(A29,{Θ},{Θ}) | CHIP BREAKER PITCH | ||||||||
| TOOL DIMENSIONS | ||||||||||
| Θ | HELIX | =(A27)*PI()/180 | =TAN(H27) | =(#REF!)*PI() | ||||||
| =(J27)/(I27) | LEAD (HELIX PITCH) | |||||||||
| Θ | TOOL DIA. | =A29-I29 | =IF(A30>A29,0,LOOKUP(A29,{0,0.125,2.5},{0,0.0005})) | |||||||
| Θ | SHANK DIA. | |||||||||
| Θ | FLUTE LENGTH (LOC) | =A31+(A29*0.08) | ||||||||
| Θ | OVERALL LENGTH | |||||||||
| Θ | CHIP BREAKER WHEEL FULL RADIUS | |||||||||
| Θ | CHIP BREAKER START POSITION (TOOTH 1) | |||||||||
| PARAMETRIC TOLERANCES | ||||||||||
| `=LOOKUP(A29,{Θ},{Θ}) | SHANK TOLERANCE | |||||||||
| `=IF(A30>A29,0.0003,LOOKUP(A29,{Θ},{Θ})) | CUTTING DIA. TOLERANCE | |||||||||
| =A29*0.02 | FLUTE LENGTH (LOC) TOLERANCE | |||||||||
| =A29*0.01 | CORE TOLERANCE | |||||||||
| =A40/2 | CORE TAPER TOLERANCE | |||||||||
| =I1*0.05 | PRIMARY LAND WIDTH AT TIP | |||||||||
| =I2*0.047 | RADIAL RELIEF WIDTH | |||||||||
| =I3*0.1 | RADIAL DROP | |||||||||
| `=LOOKUP(A29,{Θ},{Θ}) | WEB THICKNESS | |||||||||
| =B11/2 | GASH LENGTH PAST CENTER | |||||||||
| =I16*0.1 | GASH 1 WALK LENGTH | |||||||||
| =I17*0.1 | GASH 2,3 WALK LENGTH | |||||||||
| =A29*0.015 | NOTCH GRIND START POSITION | |||||||||
| =I20*0.1 | NOTCH GRIND WALK LENGTH | |||||||||
| DATA INPUT | ||||||||||
| Θ | ITEM NUMBER | |||||||||
| Θ | % OF COBALT | |||||||||
| Θ | MATERIAL FINISH | |||||||||
| =REPLACE(H56,I56,1,"") | PART NUMBER | =CONCATENATE("GS",A57,"6",FIXED(A29,3),) | =LOOKUP(A57,{"L","XL",0,"S"},{6,7,5,6}) | |||||||
| Θ | empty= REG S= STUB L= LONG LENGTH XL= EXTRA LONG | |||||||||
| WHEEL PACKS | ||||||||||
| `=LOOKUP(A29,{Θ},{Θ}) | ROLLOMATIC 620 | |||||||||
| `=LOOKUP(A29,{Θ},{Θ}) | ROLLOMATIC 600 | |||||||||
| `=LOOKUP(A29,{Θ},{Θ}) | SAACKE UW1D | |||||||||
| MAXIMUM WHEEL CORNER RADIUS | ||||||||||
| `=LOOKUP(A29,{Θ},{Θ}) | FLUTING WHEEL | |||||||||
| `=LOOKUP(A29,{Θ},{Θ}) | GASHING WHEEL | |||||||||
| `=LOOKUP(A29,{Θ},{Θ}) | CUP/RELIEF WHEEL | |||||||||