质量与维护记录
Quality & maintenance records
Run SPC on inspection data and manage CMMS work orders.
20 条本项目编写的提案 · 分类 v1.1 · 新增基准运行 0 次。下方验证方式与部分得分规则是设计，不是执行结果。
- 典型应用
- Minitab · CMMS · Excel
- 小类 GUI 需求标签
HY· 混合
任务提案 · 20
展开查看完整原文与建议检查方式；两种界面均保留提案英文原文。
R07.07.02.04-T01 Build an Xbar-R chart and list Western Electric rule violations
原始指令
In Minitab 22 open input/shaft_od.xlsx (25 subgroups of 5 diameters, mm). Create an Xbar-R chart with tests 1, 2, 5 and 6 enabled (Western Electric rules 1-4 equivalents), save the chart to out/xbar_r.png, and list each violating subgroup with the rule number in out/violations.csv.
- 平台
win· Windowsmac· macOS- 应用
- Minitab
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
HY· 混合- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
click· 指向与点击type· 文字与表单vis· 视觉判断- 工作产物
WP12· 答案 / 决策- 条件
licensed· 授权专业软件- 提案难度
- 3 / 5
建议验证方式
violations.csv equals grader computation (subgroup, rule) exactly; control limits read from Minitab session output within 0.001 mm; chart file exists; Minitab project (.mpx) saved with the chart command in history.
建议部分得分
25% limits correct; 60% violations list (F1); 15% outputs saved
R07.07.02.04-T02 Compute Cpk for three CMM features and flag those below 1.33
原始指令
input/cmm_lot_4417.csv has 60 measurements for bore Ø, flatness and position with specs in docs/drawing_specs.pdf. Compute Cp, Cpk (within, unbiased) for each feature, and write out/capability.xlsx with the values and a FLAG column for Cpk <1.33.
- 平台
win· Windowsmac· macOS- 应用
- Minitab · Excel
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
HY· 混合- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
click· 指向与点击type· 文字与表单- 工作产物
WP02· 记录 / 表格- 条件
- 未声明
- 提案难度
- 2 / 5
建议验证方式
Cp/Cpk within 0.01 of reference; one-sided specs handled for flatness/position (Cpk = CPU); flags correct.
建议部分得分
30% spec limits read correctly; 50% indices; 20% flags
R07.07.02.04-T03 Build a live SPC chart in Excel with phase-I limits and rule highlighting
原始指令
In Excel create out/fill_weight_spc.xlsx from input/fill_weights.csv: compute I-MR limits from the first 30 points (phase I), plot individual values with CL/UCL/LCL lines for all 120 points, and use conditional formatting to highlight points beyond limits or 8 in a row on one side. The chart must update if a new row is appended.
- 平台
win· Windowsmac· macOS- 应用
- Excel
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
HY· 混合- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
type· 文字与表单click· 指向与点击vis· 视觉判断- 工作产物
WP02· 记录 / 表格- 条件
- 未声明
- 提案难度
- 3 / 5
建议验证方式
openpyxl: limit cells are formulas over rows 2-31 and values match reference; chart series ranges reference a Table/dynamic range (append test via LibreOffice recalc); highlighted rows equal rule set.
建议部分得分
30% limits; 25% chart series; 30% rule highlighting; 15% dynamic range
R07.07.02.04-T04 Run a crossed Gage R&R study and judge measurement system adequacy
原始指令
In Minitab analyze input/grr_caliper.xlsx (10 parts × 3 operators × 3 trials) with Gage R&R Study (Crossed), ANOVA method, process tolerance 0.40 mm. Report %StudyVar, %Tolerance, number of distinct categories and an accept/conditional/reject verdict per AIAG MSA in out/grr.json.
- 平台
win· Windowsmac· macOS- 应用
- Minitab
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
HY· 混合- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
click· 指向与点击type· 文字与表单- 工作产物
WP12· 答案 / 决策- 条件
licensed· 授权专业软件- 提案难度
- 3 / 5
建议验证方式
grr.json values within 0.5 points of reference; ndc integer exact; verdict per thresholds (<10% accept, 10-30% conditional).
建议部分得分
40% %StudyVar/%Tol; 20% ndc; 25% verdict; 15% interaction term handled
R07.07.02.04-T05 Set up preventive maintenance schedules for twelve assets in Odoo
原始指令
In the sandbox Odoo 17 Maintenance app create equipment records for the 12 assets in input/pm_plan.xlsx (category, serial, location, team) and preventive maintenance requests with the stated intervals (days) and durations, assigned to the 'Mechanical' team, first due dates as listed.
- 平台
web· 任意系统（网页）- 应用
- CMMS · Odoo
- 交互表面
brow· 浏览器- GUI 需求 · 任务设定
HY· 混合- GUI 需求 · 普通权限
G2· GUI 必要- 交互原语
type· 文字与表单click· 指向与点击multi· 跨应用- 工作产物
WP08· 应用 / 系统状态- 条件
multiapp· 多应用- 提案难度
- 3 / 5
建议验证方式
Grader XML-RPC: 12 equipment with fields exact; preventive requests with period, duration, team, schedule date per plan; no duplicates. Agent has UI login only.
建议部分得分
40% equipment records; 45% PM schedules; 15% no duplicates
R07.07.02.04-T06 Close completed work orders with labour and parts in a CMMS
原始指令
In the sandbox MaintainX organization, close the 8 work orders listed in input/tech_sheets.pdf (scanned technician sheets): enter labour hours per technician, parts used (decrementing inventory), failure code and completion notes, and set status Done with the actual completion date.
- 平台
web· 任意系统（网页）- 应用
- CMMS · MaintainX
- 交互表面
brow· 浏览器- GUI 需求 · 任务设定
HY· 混合- GUI 需求 · 普通权限
G2· GUI 必要- 交互原语
type· 文字与表单click· 指向与点击vis· 视觉判断- 工作产物
WP08· 应用 / 系统状态- 条件
- 未声明
- 提案难度
- 2 / 5
建议验证方式
Grader API: 8 WOs Done with dates; labour entries per tech ±0.1 h; parts quantities and inventory levels decremented correctly; failure codes exact.
建议部分得分
25% status/dates; 25% labour; 30% parts & inventory; 20% failure codes
R07.07.02.04-T07 Create and release a corrective maintenance order from a notification in SAP PM
原始指令
In the SAP S/4HANA training client via SAP GUI, open notification 10004711 (M2, pump P-301 seal leak), create a PM01 order from it (IW34) with two operations (isolate & replace seal 3 h; test 1 h) on work center MECH-01, reserve material 100-3355 (1 EA) from plant 1000, schedule and release the order. Record the order number in out/order.txt.
- 平台
win· Windows- 应用
- SAP GUI · CMMS
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
G3· 仅 GUI- GUI 需求 · 普通权限
G3· 仅 GUI- 交互原语
type· 文字与表单click· 指向与点击nav· 平移 / 缩放 / 滚动- 工作产物
WP08· 应用 / 系统状态- 条件
licensed· 授权专业软件- 提案难度
- 4 / 5
建议验证方式
Grader reads order via RFC: type PM01 linked to notification; 2 operations with times/work center; reservation for 100-3355 qty 1; status REL; order.txt matches. SAP GUI scripting disabled and no RFC/BAPI user issued to the agent; the order's change documents must show the agent's dialog user.
建议部分得分
20% order from notification; 30% operations; 25% component reservation; 25% released
R07.07.02.04-T08 Run a non-normal capability analysis with distribution identification
原始指令
input/runout.xlsx (n=150, one-sided USL 0.05 mm) is skewed. In Minitab use Individual Distribution Identification to choose between Weibull, lognormal and Box-Cox, then run the matching non-normal capability analysis and report Ppk, expected PPM > USL and the chosen model with its AD p-value in out/capability.json.
- 平台
win· Windowsmac· macOS- 应用
- Minitab
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
HY· 混合- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
click· 指向与点击type· 文字与表单vis· 视觉判断- 工作产物
WP12· 答案 / 决策- 条件
licensed· 授权专业软件- 提案难度
- 4 / 5
建议验证方式
Chosen model equals best-fitting by AD among valid candidates (reference); Ppk within 0.02; PPM within 5%; p-value within 0.01.
建议部分得分
35% model choice; 35% Ppk; 20% PPM; 10% p-value
R07.07.02.04-T09 Update a process FMEA with new detection ratings and reprioritize actions
原始指令
In input/pfmea_line4.xlsx update the Detection ratings for the 9 failure modes covered by the new vision inspection (docs/vision_capability.pdf maps to the AIAG-VDA scale), recompute Action Priority (AP) per the AIAG-VDA table on the 'AP_table' sheet, and sort the open actions by AP then severity. Save out/pfmea_line4_rev2.xlsx.
- 平台
win· Windowsmac· macOS- 应用
- Excel
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
HY· 混合- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
type· 文字与表单click· 指向与点击- 工作产物
WP02· 记录 / 表格- 条件
- 未声明
- 提案难度
- 3 / 5
建议验证方式
Detection values equal key for 9 rows; AP column computed by formula (lookup) and values equal reference; open actions sorted; other cells unchanged.
建议部分得分
35% detection ratings; 40% AP values via formula; 15% sorting; 10% no collateral
R07.07.02.04-T10 Analyze a 2^4 factorial with center points and find the optimal settings
原始指令
input/coating_doe.mtw holds a 2^4 full factorial with 4 center points for coating thickness (target 25 µm, minimize variation). In Minitab analyze the factorial, reduce the model to significant terms (α=0.05, keep hierarchy), check curvature, and use Response Optimizer to hit 25 µm. Save out/doe.json with significant terms, curvature p-value and optimal settings.
- 平台
win· Windowsmac· macOS- 应用
- Minitab
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
HY· 混合- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
click· 指向与点击type· 文字与表单vis· 视觉判断- 工作产物
WP12· 答案 / 决策- 条件
licensed· 授权专业软件- 提案难度
- 4 / 5
建议验证方式
Significant term set equals reference; curvature p within 0.01; optimal settings predict 25±0.2 µm under the reduced model.
建议部分得分
40% term selection; 20% curvature; 40% optimizer settings
R07.07.02.04-T11 Compute MTBF and MTTR from work-order history and a downtime Pareto
原始指令
Export the last 12 months of corrective work orders from the sandbox CMMS (Odoo Maintenance, 'Line 2' equipment) and compute per-asset MTBF and MTTR (hours), plus a Pareto chart of downtime by failure cause. Save out/reliability.xlsx with the table and chart.
- 平台
web· 任意系统（网页）win· Windowsmac· macOS- 应用
- CMMS · Odoo · Excel
- 交互表面
brow· 浏览器desk· 桌面 GUI- GUI 需求 · 任务设定
HY· 混合- GUI 需求 · 普通权限
HY· 混合- 交互原语
click· 指向与点击multi· 跨应用type· 文字与表单- 工作产物
WP02· 记录 / 表格- 条件
multiapp· 多应用- 提案难度
- 3 / 5
建议验证方式
Table MTBF/MTTR within 1% of grader computation from DB; Pareto categories sorted descending with cumulative %; only corrective WOs in window used.
建议部分得分
20% correct export filter; 50% MTBF/MTTR; 30% Pareto
R07.07.02.04-T12 Define quality control points in Odoo and route a failed check to a quality alert
原始指令
In the sandbox Odoo 17 (Manufacturing + Quality), create quality control points on operation 'Assembly' of product 'Pump PX-20': a measure check (torque 22±2 N·m) and a pass/fail visual check. Process manufacturing order MO/00042, record a torque of 25.1 N·m, and create the quality alert from the failed check assigned to team 'Line QA'.
- 平台
web· 任意系统（网页）- 应用
- CMMS · Odoo
- 交互表面
brow· 浏览器- GUI 需求 · 任务设定
HY· 混合- GUI 需求 · 普通权限
G2· GUI 必要- 交互原语
type· 文字与表单click· 指向与点击- 工作产物
WP08· 应用 / 系统状态- 条件
- 未声明
- 提案难度
- 4 / 5
建议验证方式
Grader XML-RPC: 2 control points with type, tolerances, operation; check on MO/00042 with value 25.1 and state fail; alert linked to check and team.
建议部分得分
35% control points; 30% check recorded; 35% alert routed
R07.07.02.04-T13 Run an attribute agreement analysis for visual inspectors
原始指令
input/aaa_visual.xlsx has 3 inspectors rating 30 parts twice (pass/fail) with a known standard. In Minitab run Attribute Agreement Analysis and report within-appraiser, each-vs-standard and all-vs-standard % agreement and Fleiss' kappa in out/aaa.json, naming any inspector below 90% vs standard.
- 平台
win· Windowsmac· macOS- 应用
- Minitab
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
HY· 混合- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
click· 指向与点击type· 文字与表单- 工作产物
WP12· 答案 / 决策- 条件
licensed· 授权专业软件- 提案难度
- 3 / 5
建议验证方式
Percentages within 0.5 points and kappa within 0.01 of reference; flagged inspector set exact.
建议部分得分
50% agreement stats; 25% kappa; 25% flagged inspectors
R07.07.02.04-T14 Fit a Weibull to bearing failures and set a PM interval from B10 life
原始指令
input/bearing_failures.xlsx lists hours-to-failure for 23 bearings plus 11 suspended (still running) units. Fit a 2-parameter Weibull with suspensions (MLE), compute β, η and B10 life, and propose a PM replacement interval at 80% of B10. Put results and a probability plot in out/weibull.xlsx.
- 平台
win· Windowsmac· macOS- 应用
- Excel · Minitab
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
HY· 混合- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
click· 指向与点击type· 文字与表单vis· 视觉判断- 工作产物
WP02· 记录 / 表格- 条件
licensed· 授权专业软件- 提案难度
- 4 / 5
建议验证方式
β and η within 2% of reference MLE with right-censoring; B10 within 3%; interval = 0.8×B10; plot present. Ignoring suspensions yields outside tolerance.
建议部分得分
40% β/η with censoring; 30% B10; 15% interval; 15% plot
R07.07.02.04-T15 Record inspection results and a usage decision for an SAP QM lot
原始指令
In the SAP S/4HANA training client via SAP GUI, record results (QE51N) for inspection lot 040000001234 from input/inspection_sheet.pdf (5 quantitative characteristics, sample size 5), let the system valuate, record a defect for the out-of-spec characteristic, and make the usage decision (QA11) 'R - Reject' with stock posting to blocked stock.
- 平台
win· Windows- 应用
- SAP GUI
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
G3· 仅 GUI- GUI 需求 · 普通权限
G3· 仅 GUI- 交互原语
type· 文字与表单click· 指向与点击nav· 平移 / 缩放 / 滚动- 工作产物
WP08· 应用 / 系统状态- 条件
licensed· 授权专业软件risk· 高风险 / 不可逆- 提案难度
- 4 / 5
建议验证方式
Grader RFC read: 25 results equal sheet; valuations; defect record for the failing characteristic; UD code R and stock posted to blocked; lot status UD. SAP GUI scripting disabled and no RFC/BAPI user issued to the agent; the inspection lot's change documents must show the agent's dialog user.
建议部分得分
40% results entered; 15% valuation; 15% defect; 30% UD & stock posting
R07.07.02.04-T16 Build a P chart with varying subgroup sizes and flag out-of-control days
原始指令
input/daily_defectives.xlsx has 40 days of inspected counts (varying 180-420) and defectives. In Minitab create a P chart with varying limits (and check overdispersion with the P chart diagnostic; use Laney P' if indicated), and list out-of-control days in out/p_chart.csv with the chart type used.
- 平台
win· Windowsmac· macOS- 应用
- Minitab
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
HY· 混合- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
click· 指向与点击type· 文字与表单vis· 视觉判断- 工作产物
WP12· 答案 / 决策- 条件
licensed· 授权专业软件- 提案难度
- 3 / 5
建议验证方式
Chart type equals diagnostic outcome (reference); flagged days exact for that chart; limits per day within 0.001.
建议部分得分
30% diagnostic & chart choice; 50% flagged days; 20% limits
R07.07.02.04-T17 Import a 200-asset hierarchy into a CMMS with parent-child links
原始指令
Import input/assets_plant2.csv (200 assets with IDs, parent IDs, location, criticality) into the sandbox MaintainX organization using its CSV import, fix the 6 rows whose parent IDs reference a misspelled area, and verify the hierarchy shows Plant 2 → 5 areas → lines → assets.
- 平台
web· 任意系统（网页）- 应用
- CMMS · MaintainX
- 交互表面
brow· 浏览器- GUI 需求 · 任务设定
HY· 混合- GUI 需求 · 普通权限
G2· GUI 必要- 交互原语
click· 指向与点击type· 文字与表单- 工作产物
WP08· 应用 / 系统状态- 条件
- 未声明
- 提案难度
- 2 / 5
建议验证方式
Grader API: 200 assets; parent links equal corrected key; no orphans; criticality and location fields exact.
建议部分得分
40% assets imported; 40% hierarchy correct; 20% fields
R07.07.02.04-T18 Turn an SPC out-of-control signal into a linked corrective work order
原始指令
Minitab project fixtures/press_force.mpx shows an I-MR chart for press P-12 force. Identify the first out-of-control point (test 1) and its timestamp, then in the sandbox Odoo Maintenance create a corrective request for equipment P-12 with priority High, the timestamp and value in the description, and attach the exported chart PNG. Do not change other requests.
- 平台
win· Windowsmac· macOSweb· 任意系统（网页）- 应用
- Minitab · CMMS · Odoo
- 交互表面
desk· 桌面 GUIbrow· 浏览器- GUI 需求 · 任务设定
HY· 混合- GUI 需求 · 普通权限
G2· GUI 必要- 交互原语
vis· 视觉判断multi· 跨应用type· 文字与表单- 工作产物
WP08· 应用 / 系统状态- 条件
licensed· 授权专业软件multiapp· 多应用- 提案难度
- 5 / 5
建议验证方式
Request on P-12 with type corrective, priority High, description includes correct timestamp/value, attachment PNG of chart (image hash shows I-MR); no other requests modified.
建议部分得分
30% correct signal found; 40% request fields; 20% attachment; 10% no collateral
R07.07.02.04-T19 Track gauge calibration due dates and flag overdue instruments in Excel
原始指令
input/gauge_register.xlsx lists 85 gauges with last calibration date and interval (months). Add Next Due (EDATE), Days Remaining relative to 2026-10-14, a Status column (Overdue/Due ≤30 d/OK), conditional formatting, and a pivot of Status by department. Save out/gauge_register_2026-10.xlsx.
- 平台
win· Windowsmac· macOS- 应用
- Excel
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
HY· 混合- GUI 需求 · 普通权限
G2· GUI 必要- 交互原语
type· 文字与表单click· 指向与点击- 工作产物
WP02· 记录 / 表格- 条件
- 未声明
- 提案难度
- 3 / 5
建议验证方式
Formulas (EDATE) present; computed values equal reference; status counts per department in pivot cache match; conditional formatting rules exist for Overdue and Due.
建议部分得分
30% next due; 25% status; 25% pivot; 20% formatting
R07.07.02.04-T20 Monitor four correlated characteristics with a T² chart and find the driver
原始指令
input/extrusion_mv.xlsx has 100 subgroups (n=4) of 4 correlated dimensions. In Minitab build a Tsquared-Generalized Variance chart using the first 40 subgroups as historical (phase I), identify out-of-control subgroups in phase II, and for each give the variable contributing most (decomposition). Save out/t2.csv.
- 平台
win· Windowsmac· macOS- 应用
- Minitab
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
HY· 混合- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
click· 指向与点击type· 文字与表单vis· 视觉判断- 工作产物
WP12· 答案 / 决策- 条件
licensed· 授权专业软件- 提案难度
- 5 / 5
建议验证方式
Flagged subgroups exact vs reference using phase-I parameters; top contributor per signal equals decomposition key for ≥90%.
建议部分得分
25% phase-I setup; 45% flagged subgroups; 30% contributors
已有研究映射
当前映射未给此小类指定基准参考。