Excel NA Utils Skill

NA/missing value helper functions for Excel data processing

Overview

Consistent NA handling across Python and VBA based on CLAUDE.md guidelines:

• Treat empty cells, #N/A, "NA", "N/A" as missing values
• Exclude from numeric aggregates (mean, SD, min, max)
• Track excluded value counts for auditing
• Works with both Python and VBA

When to Use

• Python: Analyzing Excel data with polars/pandas
• VBA: Building summary macros with NA filtering
• Statistics: Computing aggregates while excluding NA
• Validation: Identifying and counting missing data
• Auditing: Track excluded value counts