Manufacturing Spreadsheet Analysis With Jolene.pro: Output, Scrap, Downtime and Materials
A manufacturing workbook can tell several stories at once. Production met the unit target, but scrap rose. One line ran longer, but made fewer usable parts. The warehouse has stock, although some of it is already promised to another order. The useful analysis starts by connecting those records.
Jolene.pro lets you ask questions of Excel and CSV files, including workbooks with multiple sheets and separate tables. For a manufacturing analyst, that provides a way to examine production and operating data, request charts and inspect the source records behind a result. Here are four practical places to start.
Bring the production records that define the question
Use production-order and shift-output exports with order ID, product code, line, date, planned units, total units and good units. Add scrap or defect records, downtime events, inventory balances and the applicable bill of materials when those analyses are needed. Keep the original units and reporting cutoff visible.
Identify what one row represents in each table. A production order may have several downtime events and several defect records. Ask Jolene.pro to summarize those event tables at the required level before combining them with output. Otherwise, repeating an order across its events can repeat the production quantity too.
1. Compare planned output with usable output
Ask: “Compare planned units and good units by week, production line and product. Show the unit shortfall and percentage of plan achieved. Keep orders without a valid plan separate and cite the rows used.”
Review good units divided by planned units, using totals for the group rather than averaging row percentages. Compare like products or report their mix separately. A line making a slower, more complex product should not be judged solely on its raw unit count. The result helps planners identify the orders behind a shortfall.
2. Locate scrap and rework patterns
Ask: “Calculate scrapped units as a percentage of total units produced by product and line. Rank the largest scrap quantities and show the recorded defect reasons. Report rework separately.”
Agree whether reworked units are included in total production and whether the same unit appears in more than one quality record. A scrap quantity and a count of inspection failures are different measures. Examine both the rate and the volume: a small batch can have a striking percentage while contributing little to the factory’s total loss.
3. Examine downtime without guessing the cause
With event start and end times, ask Jolene.pro to compare recorded downtime minutes by machine, shift and reason. Request a bar chart of the largest recorded losses and the supporting events. Specify how to handle overlapping events, events spanning shifts and missing end times.
A downtime increase alongside lower output is a lead for investigation. Maintenance and production staff can establish what happened. If you want OEE, the workbook also needs planned production time, run time, ideal cycle times and suitable good/total counts. Output alone cannot supply those inputs.
4. Assess material constraints against the order plan
Upload the bill of materials, planned order quantities and dated stock balances. Ask: “Calculate component requirements for these orders. Compare them with usable, uncommitted stock. List shortages by component, retaining unit conversions and source references.”
In a hypothetical one-component example, 1,000 units on hand minus 350 already committed leaves 650. An order requiring 800 has a gap of 150 before further restrictions. Confirm quality holds, other reservations and purchase-order arrival dates. This is a material-coverage analysis, not a completed capacity schedule.
Make the review repeatable
Inspect the source rows and calculation steps, then pin the charts useful to the weekly production meeting. Reuse the saved analysis with the next comparable export and review changes in fields or definitions. Start with one line and one reporting week. The first useful output is a specific production question with records attached.
Metric reference: Vorne’s OEE overview. These are suggested workflows, not results from a completed customer analysis.