# Print Press Run Log Worksheet

> Source: https://netray.co/tools/print-press-run-log-worksheet
> Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems.
> Section: Free Tools

## Short answer

An editable run log that computes total waste, waste percent and average run speed for every job on the press.

## Category

mes-shop-floor

## Industry

Packaging and Printing

## Audience

- Press operator
- Print production manager
- Plant manager

## Tool

**Kind:** worksheet

**Mode:** editable

**Currency:** $

**Columns:**

#### Job

**Key:** job

**Type:** text

#### Press

**Key:** press

**Type:** select

**Options:**

- Flexo 1
- Flexo 4
- Offset 2
- Digital 1

#### Good output (units)

**Key:** good

**Type:** number

**Format:** integer

#### Makeready waste (units)

**Key:** mr_waste

**Type:** number

**Format:** integer

#### Run waste (units)

**Key:** run_waste

**Type:** number

**Format:** integer

#### Run time (min)

**Key:** run_min

**Type:** number

**Format:** integer

#### Material cost per unit

**Key:** unit_cost

**Type:** number

**Format:** currency

#### Total waste

**Key:** waste_total

**Type:** number

**Expr:** mr_waste + run_waste

**Format:** integer

#### Waste %

**Key:** waste_pct

**Type:** number

**Expr:** (mr_waste + run_waste) / (good + mr_waste + run_waste) * 100

**Format:** percent

#### Units per minute

**Key:** speed

**Type:** number

**Expr:** (good + mr_waste + run_waste) / run_min

**Format:** decimal

#### Waste cost

**Key:** waste_cost

**Type:** number

**Expr:** (mr_waste + run_waste) * unit_cost

**Format:** currency

**Rows:**

**Job:** J-24-1187

**Press:** Flexo 4

**Good:** 48000

**Mr waste:** 1800

**Run waste:** 900

**Run min:** 160

**Unit cost:** 0.06

**Job:** J-24-1192

**Press:** Flexo 4

**Good:** 30000

**Mr waste:** 1500

**Run waste:** 700

**Run min:** 105

**Unit cost:** 0.08

**Job:** J-24-1195

**Press:** Offset 2

**Good:** 22000

**Mr waste:** 900

**Run waste:** 450

**Run min:** 75

**Unit cost:** 0.11

**Job:** J-24-1201

**Press:** Digital 1

**Good:** 5200

**Mr waste:** 120

**Run waste:** 60

**Run min:** 90

**Unit cost:** 0.19

**Job:** J-24-1204

**Press:** Flexo 1

**Good:** 61000

**Mr waste:** 2100

**Run waste:** 1700

**Run min:** 210

**Unit cost:** 0.04

**Totals:**

#### Total good output

**Key:** good

**Agg:** sum

**Format:** integer

#### Total waste units

**Key:** waste_total

**Agg:** sum

**Format:** integer

#### Total waste cost

**Key:** waste_cost

**Agg:** sum

**Format:** currency

**Summary:**

#### Overall waste percent

**Key:** overall_waste

**Expr:** sum_waste_total / (sum_good + sum_waste_total) * 100

**Format:** percent

**Primary:** true

#### Average waste cost per job

**Key:** avg_waste_cost

**Expr:** sum_waste_cost / count

**Format:** currency

**Notes:** Units can be sheets, metres, labels or cartons as long as you use one unit throughout. Waste percent here is waste divided by total pieces started, which is the common press definition.

## Content

**Intro:** Waste is the largest controllable cost on most presses, yet it is often tracked on paper or only at month end. This worksheet lets you log each job and see waste percent, speed and waste cost immediately, then export to Excel.

**Sections:**

#### How to use the worksheet

**Body:** Add a row for each job or run segment. Enter good output, makeready waste, run waste, run minutes and the material cost per unit. The computed columns show total waste, waste percent, units per minute and waste cost. The summary block gives the overall waste rate. Export to Excel or CSV to share with the production meeting.

#### The formulas

**Body:** Total waste is makeready plus run waste. Waste percent is total waste divided by good output plus total waste, times 100. Speed is total pieces started divided by run minutes. Waste cost is total waste times the material cost per unit. Keeping makeready and run waste separate matters because they have different fixes.

**Bullets:**

- High makeready waste points to setup, plate mounting or colour matching
- High run waste points to web breaks, ink drift or substrate quality
- Short runs always show higher makeready percentage

#### Reading the results

**Body:** Compare jobs of similar length. A short digital run and a long flexo run cannot be judged against one waste percentage. Sort by waste cost rather than percent when deciding which job to investigate first, since a modest percent on a long expensive run can exceed a high percent on a cheap one.

**Cta:** If waste data is entered twice, once on paper and once in the ERP, we can help capture it once and post it to the production order automatically.

**Faq:**

#### What is a normal waste percentage in printing?

**Answer:** It varies widely by process, job length and substrate. Short-run flexo or offset jobs can show high single digits or more, while long runs can be a few percent. Compare against your own history for similar jobs rather than a generic figure.

#### Should makeready waste be separate from run waste?

**Answer:** Yes. They have different causes and owners. Makeready depends on setup practice and job length, while run waste reflects process stability. Combining them hides which problem to fix first.

#### What unit should I use for good output?

**Answer:** Use the unit you count and sell, such as sheets, cartons, labels or linear metres. The only rule is to use the same unit for good output and waste on every row so the percentages are valid.

#### Can I add more presses to the dropdown?

**Answer:** The press column accepts the listed values. For other presses, export to Excel and edit the column, or note the press in the job field. The calculations do not depend on the press name.

## Search terms

press run log excel, printing waste log template, makeready waste tracking, press production log, print job waste percentage, flexo press log sheet, printing production report excel, press speed tracking

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