Integrate CWICR cost data with project schedules. Link work items to schedule activities, generate cost-loaded schedules, and cash flow projections.
SkillScore91Maintained
Automatic
◆Project Management pack
Last verified 8/27/2026
What it changes
Passed 20 of 22 test cases with the skill, and 14 of 22 without it.
Without skill64%
With skill91%
Checks it passed that the model alone missed
Creates worksheet named Summary in the Excel workbook.
Sets work_item_code as dataframe index upon initialization.
Uses CostDistribution.S_CURVE as default distribution method.
and 3 more in the full report
6 fixed14 passed either way2 still failing0 broke
Pass-rate lift
+27 pp
Tokens
+126%
Agent turns
0%
Response time
-11%
Model gemini-3.6-flashMeasured 8/27/2026v220 of 22 cases passed with skill
Tokens, turns and time describe resource use, not a dollar price.
See it in action
One of 6 test cases the skill fixed. Same model, same prompt, with and without the skill.
1 of 6
Prompt
When generating a cash flow projection across schedule activities without passing an explicit method parameter, which distribution option is selected as default?
What was checked, without and with the skill
Checked
Without skill
With skill
Uses CostDistribution.S_CURVE as default distribution method.
Missed
Passed
case-14 · 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.md453 linessingle file
CWICR Schedule Integrator
Business Case
Problem Statement
Project planning requires:
Linking costs to schedule activities
Generating cost-loaded schedules
Projecting cash flow requirements
Tracking earned value
Solution
Integrate CWICR cost data with project schedules to create cost-loaded Gantt charts, cash flow curves, and earned value tracking.
Business Value
Cost visibility - See when costs occur
Cash flow - Project funding requirements
Earned value - Track cost/schedule performance
Integration - Connect cost and schedule data
Technical Implementation
import pandas as pd
import numpy as np
from typing import Dict, Any, List, Optional, Tuple
from dataclasses import dataclass, field
from datetime import datetime, timedelta, date
from enum import Enum
from collections import defaultdict
class CostDistribution(Enum):
"""Methods for distributing costs over time."""
UNIFORM = "uniform" # Even distribution
FRONT_LOADED = "front_loaded" # More at start
BACK_LOADED = "back_loaded" # More at end
S_CURVE = "s_curve" # S-curve distribution