# Drilling Feeds and Speeds Planning Worksheet

> Source: https://netray.co/tools/drilling-feeds-and-speeds-planning-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

List each hole with surface speed, feed per revolution and depth, and get RPM, feed rate and drilling time per hole automatically.

## Category

mes-shop-floor

## Industry

Machining

## Audience

- CNC programmer
- Machinist
- Manufacturing engineer

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Hole / feature

**Key:** feature

**Type:** text

#### Material

**Key:** material

**Type:** select

**Options:**

- Mild steel
- Alloy steel
- Stainless
- Aluminum
- Cast iron
- Titanium

#### Drill diameter

**Key:** dia

**Type:** number

**Unit:** in

#### Surface speed

**Key:** sfm

**Type:** number

**Unit:** SFM

#### Feed per rev

**Key:** ipr

**Type:** number

**Unit:** in/rev

#### Hole depth

**Key:** depth

**Type:** number

**Unit:** in

#### Holes per part

**Key:** qty

**Type:** number

#### Spindle speed

**Key:** rpm

**Type:** number

**Expr:** sfm * 3.8197 / dia

**Format:** integer

**Unit:** RPM

#### Feed rate

**Key:** ipm

**Type:** number

**Expr:** rpm * ipr

**Format:** decimal

**Unit:** in/min

#### Drill time per part

**Key:** time

**Type:** number

**Expr:** if(gt(ipm,0), (depth + 0.3 * dia) / ipm * qty * 60, 0)

**Format:** decimal

**Unit:** sec

**Rows:**

**Feature:** Mounting holes

**Material:** Mild steel

**Dia:** 0.375

**Sfm:** 100

**Ipr:** 0.007

**Depth:** 0.5

**Qty:** 4

**Feature:** Clearance holes

**Material:** Alloy steel

**Dia:** 0.25

**Sfm:** 80

**Ipr:** 0.005

**Depth:** 0.75

**Qty:** 6

**Feature:** Cross hole

**Material:** Stainless

**Dia:** 0.1875

**Sfm:** 50

**Ipr:** 0.003

**Depth:** 0.6

**Qty:** 2

**Feature:** Cover plate holes

**Material:** Aluminum

**Dia:** 0.5

**Sfm:** 300

**Ipr:** 0.012

**Depth:** 0.375

**Qty:** 8

**Totals:**

#### Total drilling time per part (sec)

**Key:** time

**Agg:** sum

**Format:** decimal

**Summary:**

#### Total drilling time (minutes)

**Key:** min_total

**Expr:** sum_time / 60

**Format:** decimal

**Notes:** Starting values only. Surface speeds and feeds in the example rows are typical starting points for solid carbide or coated HSS drills in rigid setups; use the tool maker's data for your drill. Time adds 0.3 x diameter for the drill point and excludes rapids, peck retracts and dwell.

## Content

**Intro:** Most drilling programs start with a guess carried over from the last job. This worksheet makes the arithmetic visible: enter diameter, surface speed, feed per revolution and depth, and it returns RPM, feed rate and drilling time.

**Sections:**

#### How to use the worksheet

**Body:** Add one row per hole size, set material and the surface speed in SFM from your tooling data, then enter feed in inches per revolution and the depth. The sheet calculates spindle speed as SFM x 3.82 divided by diameter, feed rate as RPM x feed per revolution, and the time to drill all holes of that size. Totals show drilling time per part so you can compare to the cycle target.

**Bullets:**

- Use the drill maker's SFM range as the start
- Reduce feed for deep holes and add pecking
- Add 0.3 x diameter for the point
- Keep rapids and peck retracts separate

#### The formulas

**Body:** Spindle speed in RPM equals 12 x SFM divided by pi x diameter in inches, which is about 3.82 x SFM divided by diameter. Feed rate in inches per minute equals RPM x feed per revolution. Time in cut equals depth plus the point allowance divided by feed rate. Metric users can convert: RPM = 1000 x m/min divided by pi x diameter in mm.

#### Reading the output

**Body:** Check that RPM is within the machine and tool holder limit, and that feed rate in inches per minute is not so high that the machine cannot hold it through acceleration on shallow holes. Small drills at the calculated RPM may exceed spindle capability, in which case lower the RPM and use the actual feed per revolution to recompute. Compare times by hole size to see which operation dominates the cycle.

#### Common mistakes

**Body:** Do not apply the same SFM to every material in a family; stainless and titanium need far less than mild steel. Do not forget through-spindle coolant or pecking on holes deeper than about three diameters. Avoid entering depth that excludes the point for blind holes where drill depth matters, and watch for programs that dwell at the bottom, which adds time the worksheet does not show.

**Cta:** If you want planned cycle times to flow into routings and quotes inside your ERP, Netray can help connect them.

**Faq:**

#### How do I convert SFM to RPM for a drill?

**Answer:** Use RPM = SFM x 3.82 / diameter in inches. For a 0.375 inch drill at 100 SFM, RPM is about 1019. The worksheet does this for every row and rounds for display.

#### What feed per revolution should I use?

**Answer:** Use the drill manufacturer's recommendation for diameter and material. As a rough guide, feed per revolution rises with diameter, so small drills use a few thousandths and half inch drills about 0.010 or more depending on material and drill type.

#### Does the time include peck cycles?

**Answer:** No. It is a straight-through feed time plus point allowance. Peck cycles add retract and rapid moves; add that time separately or increase the allowance in your own program estimate.

#### Can I use metric units?

**Answer:** Yes, if you change the formula constants. Easier is to convert diameter to inches and surface speed to SFM (1 m/min is about 3.28 SFM) before entering, then convert feed rate back.

## Search terms

drilling speeds and feeds worksheet, drill rpm calculator excel, drilling cycle time worksheet, drill feed rate ipm, drill sfm to rpm, hole drilling planning sheet, cnc drilling parameters table

---
Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json