Prompts tagged "除錯" in the PromptCraft library.
Nine times out of ten, asking AI for a formula fails because it doesn't know what your table actually looks like. This template gives you a fill-in-the-blanks format for describing your column structure; the formula you get back comes with a step-by-step breakdown, a 5-row mini sample table, and two common gotchas flagged, with both legacy and modern function syntax provided.
Forces Codex through a closed loop — write a failing test that reproduces the bug, find the root cause, make the minimal fix, watch that same test go from red to green, then run the full test suite to confirm no regressions — eliminating both 'fixed it without verifying' and 'changed a bunch of unrelated stuff along the way.'