# Hydraulic Cylinder Sizing Worksheet

> Source: https://netray.co/tools/hydraulic-cylinder-sizing-worksheet-force-speed-cycle-time
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

An editable multi-cylinder worksheet that computes bore and annulus area, extend and retract force, stroke speeds and total cycle time for every actuator on a machine.

## Category

engineering-plm

## Industry

Hydraulic Equipment Manufacturing

## Audience

- Design engineer
- Estimator
- Machine builder

## Tool

**Kind:** worksheet

**Mode:** editable

**Columns:**

#### Cylinder tag

**Key:** tag

**Type:** text

#### Bore

**Key:** bore

**Type:** number

**Unit:** in

#### Rod dia

**Key:** rod

**Type:** number

**Unit:** in

#### Stroke

**Key:** stroke

**Type:** number

**Unit:** in

#### Pressure

**Key:** psi

**Type:** number

**Unit:** psi

#### Flow to cylinder

**Key:** gpm

**Type:** number

**Unit:** gpm

#### Cap area

**Key:** a_cap

**Type:** number

**Expr:** 3.14159265 * bore * bore / 4

**Format:** decimal

**Unit:** sq in

#### Annulus area

**Key:** a_ann

**Type:** number

**Expr:** 3.14159265 * (bore * bore - rod * rod) / 4

**Format:** decimal

**Unit:** sq in

#### Extend force

**Key:** f_ext

**Type:** number

**Expr:** psi * 3.14159265 * bore * bore / 4

**Format:** integer

**Unit:** lbf

#### Retract force

**Key:** f_ret

**Type:** number

**Expr:** psi * 3.14159265 * (bore * bore - rod * rod) / 4

**Format:** integer

**Unit:** lbf

#### Extend speed

**Key:** v_ext

**Type:** number

**Expr:** gpm * 3.85 / (3.14159265 * bore * bore / 4)

**Format:** decimal

**Unit:** in/s

#### Retract speed

**Key:** v_ret

**Type:** number

**Expr:** gpm * 3.85 / (3.14159265 * (bore * bore - rod * rod) / 4)

**Format:** decimal

**Unit:** in/s

#### Cycle time

**Key:** t_cyc

**Type:** number

**Expr:** stroke / (gpm * 3.85 / (3.14159265 * bore * bore / 4)) + stroke / (gpm * 3.85 / (3.14159265 * (bore * bore - rod * rod) / 4))

**Format:** decimal

**Unit:** s

**Rows:**

**Tag:** Clamp cyl A

**Bore:** 3.5

**Rod:** 1.75

**Stroke:** 8

**Psi:** 2000

**Gpm:** 8

**Tag:** Press main ram

**Bore:** 6

**Rod:** 3

**Stroke:** 24

**Psi:** 2500

**Gpm:** 30

**Tag:** Feed cylinder

**Bore:** 2.5

**Rod:** 1.375

**Stroke:** 18

**Psi:** 1500

**Gpm:** 5

**Tag:** Ejector

**Bore:** 2

**Rod:** 1

**Stroke:** 6

**Psi:** 1800

**Gpm:** 4

**Tag:** Lift gate

**Bore:** 4

**Rod:** 2

**Stroke:** 30

**Psi:** 1800

**Gpm:** 12

**Totals:**

#### Largest extend force check (sum)

**Key:** f_ext

**Agg:** max

**Format:** integer

#### Total flow if all move at once

**Key:** gpm

**Agg:** sum

**Format:** decimal

#### Total sequential cycle time

**Key:** t_cyc

**Agg:** sum

**Format:** decimal

**Summary:**

#### Average cylinder cycle time (s)

**Key:** avg_cyc

**Expr:** avg_t_cyc

**Format:** decimal

#### Peak flow hydraulic hp at 2500 psi

**Key:** peak_flow_hp

**Expr:** sum_gpm * 2500 / 1714

**Format:** decimal

**Description:** Upper bound if every cylinder runs at the same time at 2500 psi.

**Notes:** Formulas: area = pi x d squared / 4; force = pressure x area; speed in in/s = GPM x 3.85 / area (231 cu in per gallon divided by 60 seconds); cycle time sums extend and retract stroke times. Ignores seal friction (typically 3 to 10 percent), back pressure, acceleration and dwell time. Check long-stroke compression loads for rod buckling using Euler column rules and the maker's stop-tube chart. Rod-side speed is faster than cap-side speed at equal flow in a regenerative-free circuit.

## Content

**Intro:** Machine builders usually have several cylinders on one power unit and need force, speed and cycle time for each. This worksheet computes all of it per row and totals the flow demand so you can size the pump.

**Sections:**

#### How to use it

**Body:** List each cylinder with bore, rod diameter, stroke, working pressure and the flow you plan to give it. The sheet returns cap and annulus areas, extend and retract force in pounds-force, extend and retract speed in inches per second and full cycle time. The totals show the largest extend force, the total flow if everything moves at once and the sequential cycle time. Replace the example rows with your own, add or delete rows, then export the sheet to Excel for a design package.

**Bullets:**

- Use actual bore and rod sizes from the catalog
- Use the pressure at the cylinder, not at the pump
- Enter the flow available during that motion
- Add dwell and acceleration time separately

#### Formulas and assumptions

**Body:** Cap area is pi times bore squared over four. Annulus area subtracts the rod area. Force is pressure times area, which is why retract force is always lower on a single-rod cylinder. Speed equals flow divided by area, with 231 cubic inches per gallon and 60 seconds per minute giving the 3.85 constant. Cycle time is stroke over extend speed plus stroke over retract speed. These are the idealized fluid power relationships. Real force is reduced by seal friction and back pressure, so allow a margin when the load is close to the limit.

#### Reading the results

**Body:** In the example, the 6 inch press ram produces about 70,700 lbf at 2500 psi and travels at roughly 4.1 in/s on extend with 30 GPM, so its 24 inch stroke takes about 5.9 seconds. Its retract is faster because the annulus is smaller, about 5.5 in/s. If the cycle is too slow, increase flow, reduce bore, or add a regenerative circuit. If force is too low, increase bore or pressure, and check that the rod and mounting can take the load.

#### Common mistakes

**Body:** Common errors are using rod diameter in the extend area, assuming the pump delivers full flow during a pressure peak, and ignoring pressure intensification on the rod side when the cap side is fed through a restrictor. Another is sizing for force only and skipping the cycle time check, which can make the machine miss its takt. Long stroke cylinders also need buckling and side-load checks that this worksheet does not do.

**Cta:** Netray can pull equipment and engineering change data into a private assistant so cylinder specifications stay linked to your machine records.

**Faq:**

#### Why is retract force lower than extend force?

**Answer:** On a single-rod cylinder the rod takes up part of the piston area on the rod side. Retract force is pressure times the annular area, so it is lower by the rod area times pressure.

#### What does 3.85 mean in the speed formula?

**Answer:** One US gallon is 231 cubic inches and a minute is 60 seconds, so 231 divided by 60 is 3.85. Speed in inches per second equals GPM times 3.85 divided by area in square inches.

#### Should I include seal friction?

**Answer:** For quick estimates, derate force by 5 to 10 percent for friction, more for low pressure and small bores. The manufacturer's data gives the breakaway pressure of your seal package.

#### How do I add more cylinders?

**Answer:** Use the add row control, fill in tag, bore, rod, stroke, pressure and flow, and the computed columns update. Delete unused rows before export so the totals match your machine.

## Search terms

hydraulic cylinder sizing excel, hydraulic cylinder force table, cylinder extend retract speed calculator, hydraulic cylinder cycle time, cylinder bore rod area worksheet, hydraulic cylinder selection spreadsheet, hydraulic press cylinder force, multi cylinder machine flow budget

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