Skip to content
Workflow · People · Opening soon

First pass yield by line

Export your production log from Excel and upload it to Mammoth. Group the rows by production line and week, then divide units that passed inspection the first time by units started.

Early access opens shortly. Check back soon.

Someone typed

“calculate first pass yield for each production line and week: units that passed inspection the first time divided by units started”

The agent read it as

Calculate first pass yield for each production line and week from Production log.

What the agent built

1 step, each one an ordinary Mammoth step you can open and change.

  1. File
    Production log
    CSV export · 40 rows
  2. Step
    Calculate first pass yield
    Step 1
  3. Result
    First Pass Yield
    40 rows
  4. Schedule
    Runs when you say
    Proposed

Checked on the sample files: every step ran, 40 rows came out.

What you get back

The result of that run, the rows to look at first.

First Pass YieldSample data40 rows
LineWeekFirst pass yield (%)Passed first timeUnits started
Line A2026-09-1492.9910980
Line B2026-09-1492.99481,020
Line C2026-09-1493.3802860
Line D2026-09-1492.41,0401,125
Line A2026-09-2192.9924995
Line B2026-09-2193.39421,010
Line C2026-09-2193.3816875
Line D2026-09-2192.51,0541,140
Line A2026-09-2892.69311,005
Line B2026-09-2893.19641,035
Line C2026-09-2893.3821880
Line D2026-09-2892.61,0461,130
40 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How it works

How to use the First Pass Yield workflow

  1. 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
  2. 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
  3. 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

First Pass Yield: questions

How do you calculate first pass yield by line and week?
Export your production log from Excel and upload it to Mammoth. Group the rows by production line and week, then divide units that passed inspection the first time by units started. The result is first pass yield by line and week.
What export should you use?
Use a spreadsheet export from Excel that includes the columns you need, such as production line, week, units started, and units that passed inspection the first time.
What happens to rows that do not match the grouping?
Rows are only included when they fit the rules you set. Rows that do not match a group stay out of that result until you change the rules or add the right values.
How do you change the calculation rules?
Edit the steps in words. Change the group fields, the source columns, or the formula, then run the workflow again.

Get early access to this workflow

It will open already built and checked on the sample files. Swap in your own exports and see your result.

Early access opens shortly. Check back soon.

Workflows like this

Match payroll to time sheets, track headcount and hiring, and see what changed since last month.

All people and payroll workflows →