Individual skill

evo-proteomics-excel-formulas

Use when populating Excel workbooks for quantitative proteomics tasks - writing INDEX/MATCH lookups, AVERAGE/STDEV.S group statistics, and log2 fold-change formulas while preserving cell formatting via openpyxl 3.1.5.

tasks-evolved/protein-expression-analysis/environment/skills/evo-proteomics-excel-formulas/SKILL.md

Read pinned source

Source commit 84ca182da055fafb6453dcec4a6defdbbfd987c1

What was checked

Matches the observed repository HEAD: Yes
Scanner rules are current: Yes
Repository scan complete: No
Skill scan complete: No
Observed behavior: Local scripts
Last checked: Nov 6, 2026

These are observations at the recorded commit, not a guarantee of safety. Review the source before running it.

Install this skill

Choose an agent in your Stack or copy a command below. Commands fetch the pinned commit and copy only this skill directory. Existing destinations are refused. Copying a command does not install anything.

An install command is unavailable: current rules, complete repository and skill scans, an eligible behavior level and a permitted license are required.

Repository context

Repository stars (not skill ratings): 97
Repository last updated: Sep 10, 2026
License: Apache-2.0

Observed agent integration: No specific integration evidence. Standard SKILL.md installation does not imply verified compatibility.

agent-skills Repository topic
ai-agents Repository topic
llm-agents Repository topic
open-world Repository topic
self-evolving-agents Repository topic
writing Derived category
data Derived category

Files and excerpt

File metadata and permitted, redacted excerpts come from the recorded scan. Source links are pinned to that commit.

Browse files

SKILL.mdcore · 3,452 bytes
SKILL.mdcore · 3,452 bytes
SKILL.mdcore · 3,452 bytes
scripts/utils.pyruns · 7,313 bytes

Read excerpt


# evo-proteomics-excel-formulas

Utilities for populating Excel workbooks with proteomics Excel formulas
(INDEX-MATCH lookups, AVERAGE, STDEV.S, fold-change) while preserving formatting.

## Key Principles

1. **Write Excel FORMULAS, not computed values** - The task requires formulas.
2. **Load with data_only=False** to preserve existing formulas and formatting.
3. **_xlfn. prefix** for STDEV.S: openpyxl requires `_xlfn.STDEV.S(...)` to avoid #NAME? errors.
4. **AVERAGE** is a core OOXML function - no prefix needed.
5. **Data is log2-transformed**: Log2FC = Treated_Mean - Control_Mean; FC = 2^Log2FC.
6. **Preserve formatting**: Setting cell.value preserves existing fill, font, border.
7. **Use wb["SheetName"]** not deprecated get_sheet_by_name().