Find substitute materials using CWICR data. Identify equivalent alternatives based on function, cost, and availability.
SkillScore96Maintained
Automatic
◆Procurement pack
Last verified 8/27/2026
What it changes
Passed 22 of 23 test cases with the skill, and 12 of 23 without it.
Without skill52%
With skill96%
Checks it passed that the model alone missed
The total_cost column is checked next.
The substitution type is assigned as direct.
The compatibility level is designated as exact.
and 9 more in the full report
10 fixed12 passed either way1 still failing0 broke
Pass-rate lift
+43 pp
Tokens
+175%
Agent turns
0%
Response time
-34%
Model gemini-3.6-flashMeasured 8/27/2026v222 of 23 cases passed with skill
Tokens, turns and time describe resource use, not a dollar price.
See it in action
One of 10 test cases the skill fixed. Same model, same prompt, with and without the skill.
1 of 10
Prompt
If a dataset material row does not contain a value in the 'material_cost' column, which field is checked as the secondary fallback for unit pricing?
What was checked, without and with the skill
Checked
Without skill
With skill
The total_cost column is checked next.
Missed
Passed
case-17 · gemini-3.6-flash · 8/27/2026 · answers are capped and redacted
What's inside
The instructions your model reads when the skill loads.
SKILL.md388 linessingle file
CWICR Material Substitution
Business Case
Problem Statement
Material substitution challenges:
Supply chain issues
Cost optimization
Specification compliance
Equivalent performance
Solution
Systematic material substitution using CWICR data to find functionally equivalent alternatives with cost and performance analysis.
Business Value
Supply flexibility - Alternative sources
Cost savings - Lower-cost equivalents
Compliance - Specification matching
Quick decisions - Rapid alternative search
Technical Implementation
import pandas as pd
import numpy as np
from typing import Dict, Any, List, Optional, Tuple
from dataclasses import dataclass
from enum import Enum
from difflib import SequenceMatcher
class SubstitutionType(Enum):
"""Types of substitution."""
DIRECT = "direct" # Drop-in replacement
EQUIVALENT = "equivalent" # Same function, different material
UPGRADE = "upgrade" # Better performance
DOWNGRADE = "downgrade" # Lower performance (cost saving)
class CompatibilityLevel(Enum):