{"product_id":"bad-actor-jack-knife-analysis-toolkit-pareto-failure-analysis-spreadsheet-for-excel-and-google-sheets","title":"Bad Actor \u0026 Jack-Knife Analysis Toolkit — Downtime Pareto (Excel + Sheets)","description":"\u003cp\u003e\u003cstrong\u003eAsk a room of maintenance people which machine is the plant's worst actor and you'll get four answers. This toolkit settles it with arithmetic.\u003c\/strong\u003e\u003c\/p\u003e\n\u003cp\u003eEvery plant has the same hidden pattern: a small share of assets causes most of the failure cost, downtime, and emergency work — but the events are recorded one at a time, closed one at a time, and forgotten one at a time, so nobody ever sees the pile. The Bad Actor \u0026amp; Jack-Knife Analysis Toolkit stacks your failure history up, ranks it, and — the part most bad-actor lists skip — tells you what kind of problem each asset actually is.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eWHAT IT DOES\u003c\/strong\u003e\u003cbr\u003e• Turns your failure log into a per-asset rollup: failure count, total downtime, total cost, average cost per failure, share of total cost, and a Pareto rank by total cost\u003cbr\u003e• Classifies every asset with the classic jack-knife logic — failure FREQUENCY vs. average CONSEQUENCE per failure — using thresholds drawn at the medians of your own data (with a documented manual override)\u003cbr\u003e• Assigns one of four quadrants, each with a different playbook: CRITICAL (high\/high), CHRONIC (fails often, cheap each time), ACUTE (fails rarely, costs a fortune), MONITOR (background noise)\u003cbr\u003e• Dashboards the plant: total events, downtime and cost, a Top 10 bad actors table with cumulative share, Pareto concentration (what the Top 5 \/ Top 10 hold), quadrant counts and cost shares, plus reconciliation checks that flag log rows whose asset name matches nothing on the rollup\u003cbr\u003e• Plots the jack-knife scatter (log-scale cost axis) and a quadrant map table\u003cbr\u003e• Auto-generates an Action Plan: every classified asset gets its phase and the playbook's first action, with blank owner \/ due \/ status columns for your review meeting\u003cbr\u003e• Ships EMPTY — and includes a fully worked fictional plant (Blue Ridge Foods: 14 assets, 60 events, $131,360 of failure cost, where the top 3 assets hold $71,000 of it) on its own tab, so you can watch the engine think before you trust it with your plant\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eHOW IT WORKS — 5 STEPS\u003c\/strong\u003e\u003cbr\u003e1. SET THE WINDOW — one analysis period for every asset (twelve trailing months is the standard)\u003cbr\u003e2. LOG THE EVENTS — one row per failure: asset, date, failure mode, downtime, and cost in four buckets (labor, parts, lost production, other); the total calculates itself\u003cbr\u003e3. READ THE ROLLUP — counts, costs, averages, shares, and Pareto ranks calculate from the log with standard formulas\u003cbr\u003e4. READ THE QUADRANTS — median thresholds classify every asset; the Dashboard shows where the money sits and which kind of problem each asset is\u003cbr\u003e5. WORK THE PLAN — CRITICAL first (contain, then root-cause), then CHRONIC (kill the dominant failure mode) and ACUTE (cut the consequence); MONITOR assets get nothing, on purpose\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eDesigned by a Reliability Engineer.\u003c\/strong\u003e\u003c\/p\u003e\u003cp\u003eThis product was designed by a Reliability Engineer with 15+ years in the industry, including experience across defense, aerospace, and weapons programs. He has built and implemented reliability-centered maintenance programs at multiple facilities — so the logic in these pages is not textbook theory. It is the same structure he has put into practice on real equipment, with real maintenance teams: the calculations are shown, not hidden — every number in this workbook can be traced back to its inputs and its method. Every worksheet is built to be used the way the work is actually done — in a session, on a plant floor, with the people who own the equipment.\u003c\/p\u003e\u003cp\u003eFree updates included — if this product is corrected or improved, the updated edition is delivered free to everyone who purchased it, via the store.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003eWHAT'S INCLUDED\u003c\/strong\u003e\u003cbr\u003e• Bad-Actor-JackKnife-Toolkit.xlsx — 6 tabs: Start Here, Failure Log (200 event rows), Asset Rollup \u0026amp; Jack-Knife (60 assets), Dashboard with jack-knife scatter chart, auto-generated Action Plan, and the fully worked example. Standard formulas only — no macros — works in Microsoft Excel AND Google Sheets\u003cbr\u003e• Bad-Actor-JackKnife-Guide.pdf — 18-page guide: the jack-knife method in five steps, what counts as a failure event and how to capture cost without lying, medians\/thresholds\/overrides explained, a playbook chapter for each quadrant, the complete worked example including its full 60-event log, how to run the bad-actor review meeting, the limits of the method stated plainly, and two printable worksheets\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eWHO IT'S FOR\u003c\/strong\u003e\u003cbr\u003eMaintenance managers, reliability engineers, and planner\/schedulers at any plant with failure history — including plants with no reliability department. Also used by consultants running bad-actor reviews for clients.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eWHAT IT'S NOT \/ SCOPE\u003c\/strong\u003e\u003cbr\u003eThis is an analysis and prioritization tool — it is not a CMMS and it does not connect to your systems. A quadrant is a prioritization, not a verdict on a machine, a crew, or a vendor. Safety-critical and protective functions follow your site's risk processes on their own track, regardless of where any cost plot puts them. Classifications are derived entirely from data you enter; the worked example is fictional and its figures are for instruction.\u003c\/p\u003e\n\u003cp\u003e\u003cstrong\u003eDETAILS\u003c\/strong\u003e\u003cbr\u003eInstant download · Excel (.xlsx) + PDF · Use in Excel or Google Sheets · One purchase covers use within a single company\/site organization · Built by a practicing reliability \u0026amp; maintenance engineer\u003c\/p\u003e","brand":"The Tidy Blueprint","offers":[{"title":"Default Title","offer_id":60801330872606,"sku":null,"price":24.99,"currency_code":"USD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/1100\/5345\/8206\/files\/bad-actor-cover-fixed-2026-11-06.png?v=1793950062","url":"https:\/\/shop.thetidyblueprint.com\/products\/bad-actor-jack-knife-analysis-toolkit-pareto-failure-analysis-spreadsheet-for-excel-and-google-sheets","provider":"The Tidy Blueprint","version":"1.0","type":"link"}