Loading...
Loading...
Found 248 Skills
万行以上 Excel 数据集的高性能分析引擎。提供 openpyxl read_only 流式读取（iter_rows 支持 10 万行以上）、Parquet 转换加速、内存优化、分块处理和大文件写入模式。**遇到以下任一情况就主动使用本 skill**：①数据行数 ≥ 10k（由 sn-da-excel-workflow 的行数评估步骤触发）；②用户出现触发词：大文件 / 大数据量 / 性能优化 / 内存不足 / OOM / 百万行 / 十万行 / 流式读取 / Parquet / 分块处理 / large file / big data / streaming read / chunked processing；③直接使用 pd.read_excel() 导致超时或内存溢出；④用户明确要求对大规模数据集进行高性能处理。仅不用于：小于 10k 行的常规 Excel 分析（使用 sn-da-excel-workflow 即可）。
Apply XP practices including pair programming, ensemble programming, continuous integration, and sustainable pace. Use when implementing agile development practices, improving team collaboration, or adopting technical excellence practices.
Import/export pipeline for UnoPim. Activates when configuring imports, exports, debugging job pipelines, or creating data transfer profiles; or when the user mentions import, export, CSV, Excel, job, queue, batch, or data transfer.
Implement Syncfusion Windows Forms Pivot Chart control for visualizing multidimensional data with interactive drill-down capabilities. Use this when working with pivot charts, pivot data visualization, drill-down charts, hierarchical chart data, or business intelligence visualizations. Supports 11+ chart types (Line, Spline, Column, Area, Stacking), data binding with IEnumerable/DataTable, drill up/down operations, pivot table field list, grouping bar, legend customization, Excel export, zooming, scrolling, and touch support.
Build professional financial services data packs from various sources including CIMs, offering memorandums, SEC filings, web search, or MCP servers. Extract, normalize, and standardize financial data into investment committee-ready Excel workbooks with consistent structure, proper formatting, and documented assumptions. Use for M&A due diligence, private equity analysis, investment committee materials, and standardizing financial reporting across portfolio companies. Do not use for simple financial calculations or working with already-completed data packs.
Auto-activated foundation layer for the Architect Skills plugin providing practitioner-grade reference across 50+ architects and theorists (Vitruvius through Kere), 100+ quantitative rules of thumb sourced from IBC, ASHRAE 90.1, ADA/ABA, NFPA 101, BS EN 1991-1995, Neufert Architects' Data, and Architectural Graphic Standards. Covers all major building typologies (residential, commercial, institutional, industrial, special), design quality frameworks (RIBA Plan of Work 2020, AIA Framework for Design Excellence, CABE Building for Life 12), sustainability rating systems (LEED BD+C v4.1, BREEAM New Construction 2024, Passive House Classic/Plus/Premium, WELL v2, Living Building Challenge 4.0, Fitwel), fire and life safety codes (NFPA 101, IBC Ch. 7-10, BS 9999, Approved Document B), accessibility standards (ADA 2010, BS 8300, EN 17210, DDA), acoustic performance (ASTM E90 STC, ASTM E492 IIC, BB93, DIN 4109), structural systems, envelope performance, daylighting metrics, and an anti-pattern catalog of common design failures. Routes to 17 specialized downstream skills based on user query context.
Turn the business data the user already has (Airtable, Notion, Google Sheets, Lark Base, Excel, CSV exports, or a database someone once set up for them) into three things in one sitting: a plain-language account of what their database actually records, a findings list of data problems and blind spots, and a one-page dashboard answering the single most urgent money question, with alerts ranked by money at risk. Use when the user wants a dashboard or a read of their data ("build me a dashboard", "turn my spreadsheet into a dashboard", "what is my data telling me", "帮我做仪表板", "分析我的数据/表格"), pastes a link or drops files from one of those products and asks what the data says, or returns with a fresh export to refresh a page built earlier. NOT for designing or restructuring the database itself (that is breakthrough-base-schema-design), NOT for setting up a second brain or vault, and NOT a live auto-updating dashboard: every page is a snapshot of one export.
Use when working with think-cell — the McKinsey/BCG-standard PowerPoint plugin for consulting-grade charts. Triggers on: "think-cell" / "thinkcell", "use waterfall (瀑布图) for ...", "stacked column visualization tips", "make budget-vs-actual comparison in PPT", "how do I customize think-cell default colors", "think-cell decoration arrows / CAGR labels", "value lines (静值线 / 进值线) in think-cell 14", or any PowerPoint chart task where the user has confirmed access to the think-cell plugin. Do NOT activate for: native PowerPoint charts (use slide-data-viz-principles), Excel charts, web charts, or general data viz philosophy. Activate ONLY when think-cell is in scope.
Manage Otter Drive artifacts with the otterdrive CLI. Use when an agent needs to authenticate with Otter Drive, select an organization, create or publish HTML, Markdown, CSV, TSV, Excel, image, or other static content, inspect or retrieve artifact files, manage immutable versions, update metadata, move artifacts between teams, open previews, or archive and restore artifacts.
Protocol-driven study screening for systematic, scoping and rapid reviews. Turns a proposal or PROSPERO protocol into confirmed eligibility rules, then screens titles/abstracts and full texts with two blinded AI reviewers and a third-reviewer adjudicator: ordered exclusion codes, no silent defaults, resumable batch runs, QC (seed studies, near-miss rechecks, kappa and PABAK), PRISMA 2020 counts, EndNote/Zotero RIS groups, an Excel log, a methods draft and a literature_corpus handoff to academic-paper. Reads RIS, PubMed .nbib, Web of Science and CSV exports; removes duplicates. 8 modes: protocol, quick, pilot, ta-screen, ft-screen, adjudicate, audit, report. Use it to screen records against eligibility criteria, pilot screening, resolve screening conflicts, audit exclusions or report the selection process. Triggers on: screen these papers, title/abstract screening, full-text screening, screening conflicts, inclusion criteria, PRISMA flow, غربالگری مقالات, اسکرینینگ عنوان و چکیده, معیارهای ورود و خروج.
Tạo bộ test case / checklist UAT cho người dùng nghiệp vụ NON-IT (C&B, kế toán, vận hành) — 1 file HTML offline-proof gồm bảng kịch bản tuần tự có mã Ctrl+F, phạm vi check/không-check theo nguồn dữ liệu, step-by-step kèm ảnh màn hình thật đã blur PII, Đạt/Không đạt + xuất Excel/CSV/PDF. Trigger: "tạo test case cho non-IT", "checklist UAT cho nghiệp vụ", "kịch bản kiểm thử cho C&B", "/uat-nonit-testcase".
Full KYC customer onboarding with mandatory Step 0 independent verification (5+1 searches), 17 sequential stagegates requiring explicit analyst consent, deterministic four-factor risk scoring, case folder auto-creation, 4-sheet Excel dashboard, 17-section PDF report, and immutable audit trail. Covers UK/EU (AMLD5), US (FinCEN CDD), and MENA jurisdictions.