Video Codex Lesson3 Bonus Rules is an English video tutorial note from Hooosberg. It keeps the Bilibili lesson link, cleaned-up course structure, prompts, and workflow notes together.
The original Chinese note is tagged with video tutorial, Codex, Claude Code, Excel, build note. The goal is not a transcript, but a clearer companion note for people who want slides, prompts, and repeatable steps.
Future course updates can add the episode URL at the top, then summarize the goal, materials, prompts, checks, and reusable workflow.
Lesson approach
This companion note follows the same order as the video: understand the work problem first, prepare the files and rules, run the prompts in sequence, then verify the output before treating it as usable.
The Chinese source lesson covers 这节课的目标（最终交付物）, 案例环境与教学锚点, 第1步：生产奖金规则标准化与明细计算, 第2步：抽样公式反算与部门总额复核, 最后检查. It is designed as a practical workflow note, not a detached summary: the reader should be able to pause the video, complete one step, and return to the next step with evidence of what changed.
How to study with the video
On the first pass, watch for the inputs, constraints, and expected outputs. On the second pass, reproduce the workflow in a separate test folder. Keep source files unchanged and save generated reports, cleaned data, drafts, or exports in the designated output location.
Do not treat an AI response as a final decision. Check whether the task was fully specified, whether uncertain values were labelled, whether the result can be traced back to source material, and whether a human approval is needed before any submission, purchase, application, or external action.
Copy-ready source prompts
The original prompts are kept below in Chinese so that the operational meaning used in the video is not weakened by translation. Replace every sample file name, person, company, amount, rule, and destination with verified information from your own task.
读取《员工产量_2026-07.xlsx》《岗位奖金口径.md》和《事后调整记录.md》，生成《2026年7月生产奖金核算明细表.xlsx》：根据各工段规则计算员工奖金，必须包含“基础产量、超额产量、阶梯单价、出勤系数、质量扣款、事后调整、实发奖金”等完整计算列；准确关联事后调整记录；对缺失工号或异常产量的员工标记“待确认”；同时输出《奖金规则计算字典》和《异常调整清单》。对《2026年7月生产奖金核算明细表.xlsx》进行反向抽查：分别抽取注塑组、组装组、质检组各1名员工，列出其详细手工反算步骤与公式比对；汇总各工段奖金总额及事后调整净额；确认无重复计算或负数溢出。输出《奖金反算复核报告》。Knowledge points and checks
The transferable skill is not a single prompt. It is the ability to turn scattered materials into a repeatable system: inputs have fixed locations, rules are written down, intermediate work is separated from final deliverables, and exceptions are visible instead of silently invented.
Before closing the task, verify four things: the input set is complete; unknown information is marked rather than guessed; the output is saved where the workflow expects it; and a small sample can be checked against the original files. High-impact decisions always remain subject to human review.
Wrap-up
Reuse the structure rather than copying the example blindly: define the objective and boundary, organize files and rules, run the steps in order, verify the result, and keep the workflow for the next similar task.
That is the central lesson behind this WorkBuddy series: AI becomes more reliable when work is expressed as a clear, inspectable process instead of a vague request for a finished answer.