skills.rest
Wkayaobama
WkayaobamaCOMMUNITY
Explore all skills by this author →
GitHub

computed-columns-calculator

Calculate weighted forecast, net amount, and net weighted amount for pandas DataFrames.

Updated Aug 23, 2026
One-click install
npx skills add https://github.com/Wkayaobama/icalps_pipeline --skill computed-columns-calculator
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: computed-columns-calculator
Source: https://github.com/Wkayaobama/icalps_pipeline/tree/main/Documents/AnthonySalesOps/Codebase/IC_Load/computed-columns-calculator
Command: npx skills add https://github.com/Wkayaobama/icalps_pipeline --skill computed-columns-calculator

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, and includes scripts (resource) components.

What problem does it solves? Manually calculating financial metrics like weighted forecasts and net amounts for deal data is repetitive and prone to spreadsheet errors. This Skill automates these calculations, ensuring consistency and accuracy across your pipeline, freeing you from manual number crunching.

Core Features & Use Cases

  • Standardized Financial Metrics: Automatically compute Weighted Forecast, Net Amount, and Net Weighted Amount based on defined business logic for deals and opportunities.
  • DataFrame Integration: Seamlessly apply calculations to pandas DataFrames, integrating effortlessly into existing data pipelines.
  • Use Case: Process a DataFrame of sales opportunities, automatically adding columns for weighted forecast and net weighted amount, providing immediate, accurate insights for sales reporting.

Quick Start

Use the computed-columns-calculator skill to calculate 'weighted_forecast', 'net_amount', and 'net_weighted_amount' for the attached DataFrame 'opportunity_data.csv' which contains 'amount', 'certainty', and 'cost' columns.