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.
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.
File
Production log
CSV export · 40 rows
Step
Calculate first pass yield
Step 1
Result
First Pass Yield
40 rows
Schedule
Runs when you say
Proposed
- FileProduction logCSV export · 40 rows
- StepCalculate first pass yieldStep 1
- ResultFirst Pass Yield40 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 40 rows came out.
- Download Production log sample (40 rows)Excel: Open the workbook sheet for the production log and save as CSV
What you get back
The result of that run, the rows to look at first.
First Pass YieldSample data40 rows
| Line | Week | First pass yield (%) | Passed first time | Units started |
|---|---|---|---|---|
| Line A | 2026-09-14 | 92.9 | 910 | 980 |
| Line B | 2026-09-14 | 92.9 | 948 | 1,020 |
| Line C | 2026-09-14 | 93.3 | 802 | 860 |
| Line D | 2026-09-14 | 92.4 | 1,040 | 1,125 |
| Line A | 2026-09-21 | 92.9 | 924 | 995 |
| Line B | 2026-09-21 | 93.3 | 942 | 1,010 |
| Line C | 2026-09-21 | 93.3 | 816 | 875 |
| Line D | 2026-09-21 | 92.5 | 1,054 | 1,140 |
| Line A | 2026-09-28 | 92.6 | 931 | 1,005 |
| Line B | 2026-09-28 | 93.1 | 964 | 1,035 |
| Line C | 2026-09-28 | 93.3 | 821 | 880 |
| Line D | 2026-09-28 | 92.6 | 1,046 | 1,130 |
How it works
How to use the First Pass Yield workflow
- 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.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 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.
Workflows like this
Match payroll to time sheets, track headcount and hiring, and see what changed since last month.
- Resource capacity by weekCompare booked project hours to weekly availability in an Excel export and show who is over or under capacity.See the workflow Built by the agent
- Salary bands compa-ratioExport employees from BambooHR, pair them with salary bands, and work out each employee's compa-ratio against the band midpoint.See the workflow Built by the agent
- On-time shipping rateCalculate on-time delivery rate from a ShipStation shipments export, grouped by carrier and week.See the workflow Built by the agent
- PTO balance reportShow each employee’s PTO accrued, taken, carryover, and remaining balance this year from BambooHR exports.See the workflow Built by the agent
- Billable utilization by employeeCalculate each employee's utilization rate by month from exported Harvest time entries and capacity files.See the workflow Built by the agent
- Employee turnover rateCalculate monthly employee turnover rate by department from a BambooHR employee export, with turnover, cleaned department names, and a status check.See the workflow Built by the agent