Skill UI

Guidance for creating, editing, and analyzing .xlsx workbooks while preserving formulas, formatting, and assumptions, leveraging pandas/openpyxl for data work and LibreOffice recalc to ensure error-free financial models.

Guides structured hypothesis generation by combining literature searches, evidence synthesis, competing explanations, and experimental design, with mandatory AI-generated scientific schematics for complete reports.

PyDESeq2 brings the DESeq2 differential expression workflow to Python, letting users load bulk RNA-seq counts, specify design formulas, fit DESeq2 models, run Wald tests with FDR correction, optionally apply apeGLM shrinkage, and export gene-level statistics within pandas/AnnData pipelines.

Generates a single formula-driven Excel dashboard from CSV/tabular data, complete with KPI cards, charts, sparklines, and conditional formatting so analysts can instantly review metrics and share an executive-ready .xlsx output.

Guides a Power BI DAX expert through performance, readability, best-practice, and maintainability reviews; recommends variable reuse, context tuning, and error handling; then outputs an optimized formula plus justification for analytics models.

This skill enhances research query formulation by translating vague, colloquial, or generalized descriptions into precise, standard academic terminology. When initial search terms are broad (e.g., "conjugal happiness"), this technique suggests multiple plausible academic synonyms (e.g., "marital satisfaction," "relationship quality"). By improving the precision of the search query and incorporating structured constraints (like keywords, years, or sample sizes), it significantly boosts the relevance and effectiveness of academic paper retrieval.

This advanced research technique is designed for deep dives into football topics. Instead of relying solely on the original query, it mandates tracking every discovered entity—such as player names, club names, or coaches—from search results. By treating these entities as new leads, the user must formulate follow-up searches using the discovered names and remaining constraints, ensuring nothing relevant is overlooked and building a comprehensive knowledge chain.

A comprehensive framework for transforming raw observations into rigorous, evidence-bounded, and testable research plans. It guides users through establishing research questions (PICO/PECO), formulating candidate hypotheses and rival explanations, defining causal estimands, and creating preregistration-ready analysis plans, all while maintaining strict ethical and scientific guardrails.

PyDESeq2 is a robust Python implementation of DESeq2, designed for comprehensive differential expression analysis using bulk RNA-seq count data. It supports complex formulaic designs, performs Wald tests with multiple testing correction (FDR), and includes advanced features like LFC shrinkage, enabling researchers to analyze gene expression changes between various experimental conditions within Python pipelines.

A comprehensive tutor designed to build robust statistical thinking. It guides users through the entire data analysis lifecycle, from exploratory data visualization and descriptive statistics to complex hypothesis testing and regression modeling. The focus is on understanding the 'why' and 'how' of statistical logic using real datasets and practical problems, rather than just memorizing formulas. It is tool-agnostic, supporting concepts learned in Python, R, SPSS, or Stata.

A comprehensive skill for creating, editing, and analyzing complex spreadsheets (.xlsx, .csv, etc.). This skill excels in financial modeling, ensuring all calculations are managed via dynamic Excel formulas rather than hardcoded values. It supports data analysis using pandas, rigorous formatting standards, and complex formula integrity checks, making it ideal for financial reporting and data visualization.

Bilig WorkPaper provides a code-first runtime environment for complex spreadsheet business logic. It allows agents to interact with structured data using formulas and JSON workbooks via deterministic API calls (MCP/TypeScript). This is ideal for replacing unreliable UI automation in use cases like quote calculators, budget modeling, and data validation, ensuring calculation integrity through explicit read-back proof.