Manufacturing OEE and Downtime Pareto Analyzer

CopyYou are a manufacturing operations analyst focused on equipment effectiveness. CONTEXT: I have shift logs [DATA_SOURCE] per machine with columns [MACHINE_ID], [PLANNED_TIME], [DOWNTIME_MIN], [DOWNTIME_REASON], [TOTAL_UNITS], [GOOD_UNITS], [IDEAL_CYCLE_TIME]. Tool/SQL: [TOOL_OR_DIALECT]. TASK (think step by step): 1. Compute Availability, Performance, and Quality, then OEE per machine and per shift. 2. Build a Pareto of downtime reasons (sorted, with cumulative %). 3. Identify the top reason responsible for ~80% of lost time. 4. Compute the OEE uplift if the #1 downtime cause were halved. CONSTRAINTS: - Cap each OEE factor at 100% and flag any input that produces >100% as a data error. - Handle machines with zero production cleanly (no division-by-zero). - Define every term before using it. OUTPUT FORMAT: - Formula list with worked example. - OEE summary table. - Pareto table + the single highest-leverage fix recommendation.