How do you convert RPM to surface speed?

Multiply the RPM by π and the diameter in inches, and divide by 12 for feet per minute. 8,000 RPM on a 0.5 in tool is 8,000 × π × 0.5 ÷ 12 = 1,047 SFM, or 319 m/min, the Surface Speed calculator's own example.

How do you convert SFM to RPM?

RPM = SFM × 12 ÷ (π × diameter in inches). An 800 SFM minimum on a 0.5 in tool is 6,112 RPM; on a 1/8 in tool it is 24,446 RPM.

Which diameter do I use for turning?

The diameter being cut, not the tool. Surface speed in turning is the speed of the work surface past the insert, so it changes with every pass; enter the diameter you want to check.

What does Catalog min reachable mean?

Whether the machine's maximum spindle speed is enough to reach the tool maker's minimum surface speed. Small tools on slow spindles often cannot; they need a faster spindle, a speeder head, or a lower feed per tooth.

How is the suggested RPM chosen?

The RPM at the middle of the catalog range, capped at the machine's maximum. It is a starting point; tune it for chatter, finish and tool life, and set the feed from the same catalog.

Does the workbook use macros?

No. It is a plain .xlsx with ordinary formulas, tables and native charts. The Verify sheet re-checks the formulas against fixed test tools and shows Self-check: PASS.

Production and Throughput

Surface Speed and RPM Sheet Excel Template

Surface speed (SFM) = spindle RPM × π × diameter ÷ 12, and RPM = SFM × 12 ÷ (π × diameter). List every cutting tool or turned diameter in the shop and see the surface speed it runs at its programmed RPM against the tool maker's range, the RPM at both ends of the range, a suggested RPM the machine can run, and the tools no spindle on the machine can bring up to speed.

Free, and a plain .xlsx with no macros to enable. A CSV with live formulas and a printed how-to guide come with it.

Overview

This surface speed and RPM sheet is a working Excel workbook for CNC programmers, machinists, manufacturing engineers and tooling buyers. Each tool, or each turned diameter on a lathe, is one row with its description, machine, work material, cutting diameter, the RPM in the program and the surface speed range from the tool maker's catalog; each machine's maximum spindle speed comes from Setup. The workbook gives the surface speed in SFM and m/min, the RPM at both ends of the catalog range, how close the tool runs to the maximum, a suggested RPM at the middle of the range capped at what the machine can do, and whether the machine can reach the range at all. It ships with nine tools on two machining centres and a lathe at a fictional job shop, so every tile and chart is filled in when you open it.

In the example a 1/2 in carbide end mill at 8,000 RPM runs at 1,047 SFM, 70% of its 1,500 maximum in aluminium. A 3/8 in carbide drill in 304 stainless was left at 3,500 RPM from an aluminium job: 344 SFM against a 150 to 250 range, 137% of maximum, so the suggested RPM is 2,037. A 1/8 in end mill needs 24,446 RPM to reach its 800 SFM minimum and the machine tops out at 10,000, so it runs at 327 SFM whatever the program says. A 1 in turned diameter at 1,200 RPM is under its range and should run at about 2,300.

Feed, depth of cut and tool life are not checked; take the feed from the same catalog. The download is a plain .xlsx with no macros. A CSV with live formulas is also included for other tools; the dashboard, charts, dropdowns and self-check are in the .xlsx.

What this template includes

Setup sheet with your shop and the machines with their maximum spindle speed
Tools table, one row per tool or turned diameter: description, machine, work material, diameter, programmed RPM and catalog minimum and maximum surface speed, with a Check column
Per tool: surface speed in SFM and m/min, RPM at the catalog minimum and maximum, share of the catalog maximum, a status in words, a suggested RPM capped at the machine's maximum, and whether the catalog minimum is reachable
Dashboard with four tiles (tools, inside the catalog range, outside it, machine cannot reach the range), surface speed against the catalog range, share of the catalog maximum, and the tool table
Method sheet with every formula, and a Verify sheet that re-checks the formulas against an independent reference and the Surface Speed calculator (Self-check: PASS)
CSV with live formulas for the Tools table; the dashboard, charts, dropdowns and self-check are in the .xlsx

Suggested use case

Use it to audit the speeds in a program library against the tool makers' ranges, to set RPM for a new tool or material, or to find small tools that need a faster spindle.

How to use it

On Setup, type your shop and list your machines with their maximum spindle speed.
On Tools, give each tool a row: description, machine, work material, diameter, programmed RPM and the catalog surface speed range.
Fix anything the Check column names.
Open the Dashboard: each tool's surface speed against its range, and the tools the machine cannot spin fast enough.

Frequently Asked Questions

How do you convert RPM to surface speed?: Multiply the RPM by π and the diameter in inches, and divide by 12 for feet per minute. 8,000 RPM on a 0.5 in tool is 8,000 × π × 0.5 ÷ 12 = 1,047 SFM, or 319 m/min, the Surface Speed calculator's own example.
How do you convert SFM to RPM?: RPM = SFM × 12 ÷ (π × diameter in inches). An 800 SFM minimum on a 0.5 in tool is 6,112 RPM; on a 1/8 in tool it is 24,446 RPM.
Which diameter do I use for turning?: The diameter being cut, not the tool. Surface speed in turning is the speed of the work surface past the insert, so it changes with every pass; enter the diameter you want to check.
What does Catalog min reachable mean?: Whether the machine's maximum spindle speed is enough to reach the tool maker's minimum surface speed. Small tools on slow spindles often cannot; they need a faster spindle, a speeder head, or a lower feed per tooth.
How is the suggested RPM chosen?: The RPM at the middle of the catalog range, capped at the machine's maximum. It is a starting point; tune it for chatter, finish and tool life, and set the feed from the same catalog.
Does the workbook use macros?: No. It is a plain .xlsx with ordinary formulas, tables and native charts. The Verify sheet re-checks the formulas against fixed test tools and shows Self-check: PASS.