Check an Excel workbook before sending it to a customer. Locate hidden sheets, rows and columns, comments and external links. Run the read-only Python scanner locally and review the exact locations without printing cell values. Includes a fictional quotation to try first.
Local CSV, TSV, XLSX and JSONL redaction with Traditional Chinese instructions and reports. Preview first, then explicitly apply field removal, redaction or stable batch pseudonyms. No API required. Same engine as the English edition; choose one.
Build auditable Excel financial models with live formulas, sourced inputs, automated checks, and sensitivity analysis—all generated headlessly with openpyxl.
多個 CSV 一次去重：選擇比對欄位與保留第一筆／最後一筆，取得乾淨 CSV、重複明細及筆數摘要。附離線瀏覽器介面與 Node.js 指令工具，原檔保留、不需 API。支援 UTF-8、逗號分隔及一致欄名；最多 20 檔、合計 20 MB、100,000 筆。下載買斷。
I build small personal productivity tools and repeatedly needed a quick way to track data (books, inventory, expenses, habits) without a server or database. This skill packages that pattern: a reusable HTML/JS template (table, add/edit form, search/filter, chart, JSON/CSV export-import, localStorage) plus a workflow that adapts the template's fields to whatever the user describes in plain language. Output is a single offline HTML file, no account, API key, or server.
Design, debug, and quality-check Excel and Google Sheets formulas, workbook structures, KPI dashboards, data validation, and test cases with clear explanations and explicit assumptions.
Upload payroll and attendance Excel files to automatically match employees, detect discrepancies, calculate payroll differences, and generate a clear reconciliation report.
"중복 제거하고 부서별 합계 내줘"라고 말하면, 당신의 실제 열 이름에 맞춘 복사-붙여넣기 완성 수식이 나옵니다. 실무 레시피 135개(조회 25·집계 25·텍스트/날짜 25·데이터 정리 25·동적 배열 20·2024–2026 최신 함수 15)에 Apps Script 12개·VBA 8개 스니펫 포함, 공백 포함 6만 자 이상. 모든 레시피가 상황→수식→동작 원리→흔한 오류 4단 구성이라 붙여넣고 끝이 아니라 왜 되는지까지 이해됩니다. GROUPBY·PIVOTBY·엑셀 정규식·TRIMRANGE 같은 최신 함수는 지원 버전과 구버전 대체 수식을 병기하고, 엑셀↔구글시트 문법 차이는 자동 변환합니다. 단, 독립 실행 프로그램이 아니라 Claude Code에 장착하는 스킬(지식 팩)이며, 엑셀·구글시트 자체는 포함되지 않습니다.