Create a spreadsheet that will generate spot and thru hole drilling for any set of coordinates given the following information:
- Spreadsheet drills 4 holes (no more, no less)
- (In practice, your first two holes will be off the part for verification)
- Z-Level of top surface of all holes
- Use only one Z for all hole levels
- Z-Depth of bottom of hole
- Use same Z depth for all holes
- Whether or not to jump after drilling
- User enters clamp height
- User enters Yes/No for each hole
- Same spreadsheet – two operations:
- Center Drilling
- Thru hole drilling
STARTER CODE:
%
(Sample Output)
(Begin Header)
G20 (Inch Mode)
G40 G17 G80 (comp cancel, plane, camp cancel)
T10 (Tool Number)
M06 (Tool Change)
G43 H10 (Length comp ON, Offset NO)
G54 (Part Zero Origin)
S1000 (Spindle Speed RPM)
M09 (Coolant Off)
G90 (Absolute)
M03
(End Header)
G00 Z1.7500
F10.0
G83 X2.0000 Y3.0000 Z-0.5751 R0.25 G99 P0.50 Q0.75 (Hole #1)
X2.0000 Y2.0000 Z-0.5751 G99 (Hole #2)
X2.0000 Y1.0000 Z-0.5751 G98 (Hole #3)
X7.0000 Y1.0000 Z-0.5751 G99 (Hole #4)
X7.0000 Y2.0000 Z-0.5751 G99 (Hole #5)
X7.0000 Y3.0000 Z-0.5751 G98 (Hole #6)
X12.0000 Y3.0000 Z-0.5751 G99 (Hole #7)
X12.0000 Y2.0000 Z-0.5751 G99 (Hole #8)
(Begin Footer)
G80 G00 Z6.0000
M30
%