How do you estimate pump alignment time?

Divide the sets to align by the sets completed per hour, then add the setup and shimming allowance. 120 sets at 12 an hour is 10 hours; with a 10% allowance it is 11 hours, 1 hour inside a 12-hour window, the Motor-Pump Alignment Time calculator's own example.

Where does the sets per crew-hour rate come from?

From your own alignment records for similar sets and the same method: laser systems are usually quicker to set up and read than dial indicators, and large or coupled-through sets take longer than close-coupled ones. The workbook does not assume a rate.

What should the allowance cover?

Setting up the brackets or laser heads, checking and correcting soft foot, shimming, re-checks after tightening down, and pipe strain corrections. Raise it for sets with a history of problems; the high-lift pumps in the example carry 25%.

What does Over capacity mean here?

The required time is longer than the package's window. Add a crew, use a faster method, lengthen the window, or move sets to another package. Near capacity means the package fills more of its window than the threshold on Setup.

How are crew hours and labour cost worked out?

Required elapsed time × crews × people per crew, times the loaded rate per person-hour. One crew of two for 12.5 hours is 25 crew hours, 2,125 at 85 an hour.

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

Maintenance and Reliability

Pump Alignment Planner Excel Template

Alignment time = pump-motor sets ÷ (crews × sets per crew-hour) × (1 + setup and shimming allowance). Give every alignment package a row and see its required time against the window the schedule gives it, the margin either way, and the crew hours and labour cost it takes.

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 pump alignment planner is a working Excel workbook for maintenance planners, shutdown coordinators, millwrights and pump packagers. Each alignment package is one row with its area, the number of pump-motor sets, the crews working it, the sets a crew completes per hour from your own records, the allowance for setup, soft foot, shimming and re-checks, and the elapsed hours the schedule gives it. The workbook gives the base and required time, the margin to the window and how full the window is, and the crew hours and labour cost at your crew size and rate. It ships with eight packages from a fictional water treatment plant's shutdown, so every tile and chart is filled in when you open it.

In the example the raw water pumps, six sets for one crew at half a set an hour with a 15% allowance, need 13.8 hours of a 16-hour window. The four high-lift pumps carry a 25% allowance after soft foot and pipe strain at the last alignment: 12.5 hours against a 10-hour window, 2.5 hours over, so they need a second crew or a longer window. The backwash pumps and booster station fill 92% of their windows. The 48 sets take 191 crew hours, 16,239 at 85 an hour.

Hours are elapsed time with crews working in parallel; permits, travel and repairs found during alignment belong in the allowance. The download is a plain .xlsx with no macros. A CSV with live formulas is also included for other tools; the dashboard, charts and self-check are in the .xlsx.

What this template includes

Setup sheet with your plant and currency, the near-capacity threshold, the people in a crew and the loaded rate per person-hour
Packages table, one row per package: area, sets, crews, sets per crew-hour, allowance and window, with a Check column
Per package: team rate, base time, required time, allowance hours, window margin and load, a status in words, crew hours and labour cost
Dashboard with four tiles (packages, sets to align, packages over their window, labour cost), required time against window, base and allowance hours by package, and the package table
Method sheet with every formula, and a Verify sheet that re-checks the formulas against an independent reference and the Motor-Pump Alignment Time calculator (Self-check: PASS)
CSV with live formulas for the Packages table; the dashboard, charts and self-check are in the .xlsx

Suggested use case

Use it to plan the alignment work of a shutdown or outage, to see which packages need another crew before the window opens, or to estimate millwright hours for a batch of pump skids.

How to use it

On Setup, type your plant and currency, the near-capacity threshold, the people in a crew and the loaded rate per person-hour.
On Packages, give each package a row: area, sets, crews, sets per crew-hour, setup and shimming allowance, and the window.
Fix anything the Check column names.
Open the Dashboard: required time against the window, and the packages that do not fit.

Frequently Asked Questions

How do you estimate pump alignment time?: Divide the sets to align by the sets completed per hour, then add the setup and shimming allowance. 120 sets at 12 an hour is 10 hours; with a 10% allowance it is 11 hours, 1 hour inside a 12-hour window, the Motor-Pump Alignment Time calculator's own example.
Where does the sets per crew-hour rate come from?: From your own alignment records for similar sets and the same method: laser systems are usually quicker to set up and read than dial indicators, and large or coupled-through sets take longer than close-coupled ones. The workbook does not assume a rate.
What should the allowance cover?: Setting up the brackets or laser heads, checking and correcting soft foot, shimming, re-checks after tightening down, and pipe strain corrections. Raise it for sets with a history of problems; the high-lift pumps in the example carry 25%.
What does Over capacity mean here?: The required time is longer than the package's window. Add a crew, use a faster method, lengthen the window, or move sets to another package. Near capacity means the package fills more of its window than the threshold on Setup.
How are crew hours and labour cost worked out?: Required elapsed time × crews × people per crew, times the loaded rate per person-hour. One crew of two for 12.5 hours is 25 crew hours, 2,125 at 85 an hour.
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 packages and shows Self-check: PASS.