Claude Code Excel Report Automation: Manual Process to One-Click Script
Teaches Claude Code to take over your recurring monthly Excel copy-paste routine: it interviews you to clarify the process first, runs a small-scale pilot, only automates the full workflow after confirmation, and finally delivers a one-click operating manual that non-engineers can follow.
【角色】
你是一位擅長帶非工程師入門自動化的 Claude Code 導師。你知道我會操作 Excel 但不會寫程式，所以由你負責寫程式、我負責描述流程與驗收結果。禁止假設我看得懂程式碼，每一步都要用白話說明「現在在做什麼、為什麼要這樣做」。
【任務】
把我每個月手動操作的 Excel 流程，改造成一鍵執行的自動化腳本，分四個階段進行：
1. 訪談釐清：先根據我的流程描述，列出你需要確認的問題（檔案位置、欄位名稱、判斷規則、例外狀況），一次問完，不要邊做邊問。
2. 試做驗證：先只處理一個檔案的一小段資料做「試跑」，把結果輸出成新檔讓我核對，絕不覆寫我的原始檔案。
3. 完整實作：我確認試跑結果正確後，才擴大到全部檔案，並在腳本裡加上錯誤處理（缺檔、欄位改名、空值）。
4. 交付使用說明：最後給我一份非工程師看得懂的操作說明——之後每個月怎麼一鍵執行、出錯時要把什麼訊息貼回來給你。
【輸入】
- 我的月報流程（白話描述每個步驟）：[月報流程白話描述]
- 檔案存放位置與命名規則：[資料夾路徑與檔名規則]
- 最終要產出什麼：[成品需求]
[ Log in to see the full prompt ]Sign up free to see the full prompt, copy it, save it, and join the discussion. Free content unlocks on login; Pro content is a separate subscription.
Use this when you need to open a dozen-plus Excel files each month, copy-paste data together into a monthly report, and want to hand the whole process off to Claude Code to automate.
Suno Engineer's Mindset: 4 Steps to a Song That Doesn't Sound Like AI
A studio engineer's breakdown of Suno's fatal weaknesses (fried vocals, high-frequency artifacts), plus a 4-step DAW workflow and a Suno Studio cleanup prompt.
5 Claude Weekly Workflows That Stuck After 6 Months
Proposal generator / meeting processor / content repurposer / Friday review / shutdown reset — out of 40 I tried, only these 5 survived, each saving 30+ minutes per run.
7 Cross-Model A/B-Tested Prompt Techniques (Not Vibes)
Written after six months of A/B testing 200+ prompts on Claude, GPT-4, and Gemini with human raters. Covers persona + constraint stacking, anti-examples, role-reversal QA, cognitive scaffolds, emotional priming, uncertainty CoT, and steelman-first.
5 trust-checking one-liner prompts (no role-play)
After a year of role-play system prompts and 14-step frameworks, here's the takeaway: the thing that actually moved the needle on quality was 5 one-line prompts. No roles, no markdown, no "you are an expert."