How do you calculate press strokes per minute?

Divide the counter strokes by the running minutes: scheduled hours minus stop hours, times 60. 12,960 strokes in 8 hours with 0.8 hours of stops is 12,960 ÷ 432 = 30 SPM running and 27 SPM over the whole window, the Press Strokes per Minute calculator's own example.

What is the difference between running and scheduled SPM?

Running SPM counts only the time the press was cycling, so it measures speed. Scheduled SPM spreads the same strokes over the whole planned window, so it includes the stops. The gap between them is the output lost to stops.

How are strokes lost worked out?

At the approved rate the scheduled time could make approved SPM × scheduled minutes. Lost to stops = approved SPM × stop minutes; lost to speed = approved SPM × running minutes − strokes made. Made + lost to speed + lost to stops adds back to the total.

What does Out of limits mean?

The run's measured rate was faster than the die's approved rate. Check the counter and timing records first; if the press really ran faster, restore the setup card speed, because feed timing and die protection are set for it.

What strokes per minute should my press run at?

The approved rate on the die and press setup card, set by the press and die makers and your setup for that part. The workbook measures the rate against it; it does not set a safe speed.

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 runs and shows Self-check: PASS.

Production and Throughput

Press Strokes per Minute Log Excel Template

Running strokes per minute = counter strokes ÷ (scheduled hours − stop hours) ÷ 60. Log every press run and see its running and scheduled stroke rate, availability and speed against the die's approved rate, and the strokes the scheduled time could have made split into made, lost to stops and lost 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 press strokes per minute template is a working Excel workbook for press shop supervisors, stamping process and industrial engineers, and production managers. Each press run is one row with the date, shift, press and die, the strokes from the press counter, the scheduled hours and the stop hours from the stop log; the die's approved strokes per minute and parts per stroke come from a list on Setup. The workbook gives the running and scheduled stroke rates, availability, the running rate against the approved rate with a status in words, the parts stamped, and the strokes lost to stops and to running under speed. It totals every press and every die. It ships with twelve runs on three presses at a fictional press shop, so every tile and chart is filled in when you open it.

In the example a hinge die approved at 30 SPM made 13,500 strokes in 7.4 running hours: 30.4 SPM, faster than its setup card, so the run shows Out of limits. The 600 t transfer press averaged 17.3 SPM while running against 18 approved, but lost a full shift's worth of strokes to stops, 6,912 over four days against 1,098 lost to speed; one transfer fault alone cost 3,348. Across the twelve runs the presses made 103,500 strokes with 84.9% availability, running at 97.1% of approved speed.

Strokes come from the counter and include rejects; good-part output is a separate measure. 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 plant and speed band, the presses, and the dies with their approved strokes per minute and parts per stroke
Runs table, one row per press run: date, shift, press, die, strokes from the counter, scheduled hours and stop hours, with a Check column
Per run: running hours, running and scheduled SPM, availability, rate against approved, speed ratio, a status in words, parts stamped, and strokes lost to stops and to speed
Dashboard with four tiles (strokes, availability, speed against approved, runs above approved speed), strokes made and lost by press, running SPM against approved by die, and the press and die tables
Method sheet with every formula, and a Verify sheet that re-checks the formulas against an independent reference and the Press Strokes per Minute calculator (Self-check: PASS)
CSV with live formulas for the Runs table; the dashboard, charts, dropdowns and self-check are in the .xlsx

Suggested use case

Use it to see whether presses lose more output to stops or to running under speed, to catch a die run faster than its setup card, or to compare shifts on the same press.

How to use it

On Setup, type your plant and speed band, list your presses, and your dies with their approved strokes per minute and parts per stroke.
On Runs, give each press run a row: date, shift, press, die, strokes from the counter, scheduled hours and stop hours.
Fix anything the Check column names.
Open the Dashboard: strokes made and lost on every press, and each die's running rate against its approved speed.

Frequently Asked Questions

How do you calculate press strokes per minute?: Divide the counter strokes by the running minutes: scheduled hours minus stop hours, times 60. 12,960 strokes in 8 hours with 0.8 hours of stops is 12,960 ÷ 432 = 30 SPM running and 27 SPM over the whole window, the Press Strokes per Minute calculator's own example.
What is the difference between running and scheduled SPM?: Running SPM counts only the time the press was cycling, so it measures speed. Scheduled SPM spreads the same strokes over the whole planned window, so it includes the stops. The gap between them is the output lost to stops.
How are strokes lost worked out?: At the approved rate the scheduled time could make approved SPM × scheduled minutes. Lost to stops = approved SPM × stop minutes; lost to speed = approved SPM × running minutes − strokes made. Made + lost to speed + lost to stops adds back to the total.
What does Out of limits mean?: The run's measured rate was faster than the die's approved rate. Check the counter and timing records first; if the press really ran faster, restore the setup card speed, because feed timing and die protection are set for it.
What strokes per minute should my press run at?: The approved rate on the die and press setup card, set by the press and die makers and your setup for that part. The workbook measures the rate against it; it does not set a safe speed.
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 runs and shows Self-check: PASS.