wbs-excel

Automate WBS creation and editing in Excel with WORKDAY-based scheduling and Gantt chart generation.

Updated Aug 27, 2026
One-click install
npx skills add https://github.com/kz-flux/slide-skills --skill wbs-excel
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: wbs-excel
Source: https://github.com/kz-flux/slide-skills/tree/main/wbs-excel
Command: npx skills add https://github.com/kz-flux/slide-skills --skill wbs-excel

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires openpyxl.

What problem does it solve?

This Skill helps create and edit a WBS in Excel with automated calendar calculations and built-in Gantt-chart generation, streamlining project planning.

Core Features & Use Cases

  • WBS structure in Excel: task lists, phases, owners, start dates, durations.
  • WORKDAY-based scheduling: automatic end dates with holiday support.
  • Gantt chart generation: visual timeline within the workbook.
  • Versioning: saves with versioned filenames for traceability.

Quick Start

Prepare a workbook with Start Date and Planned Duration; run the tool to auto-calculate end dates and generate the Gantt chart.

Frequently Asked Questions about wbs-excel

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I automate Work Breakdown Structure creation in Excel with automatic scheduling?

WBS-excel automates WBS creation by reading task lists with start dates and durations, then calculating end dates using WORKDAY formulas that account for holidays and weekends. It generates a Gantt chart visualization within the same workbook, eliminating manual date calculations and timeline drawings.

Can I use WORKDAY functions in Excel for holiday-aware project scheduling?

Yes. WORKDAY-based scheduling in Excel calculates end dates by excluding weekends and holidays automatically. WBS-excel applies this through openpyxl to create project schedules where every task respects holiday calendars without manual adjustment.

How do I generate a Gantt chart directly in an Excel workbook?

WBS-excel generates Gantt charts programmatically within Excel using conditional formatting and weekday headers to visualize task timelines. The chart updates automatically when you modify task durations or start dates in the WBS structure.

What's the best way to manage multiple versions of project schedules in Excel?

WBS-excel saves workbooks with versioned filenames automatically, creating a traceable history of schedule iterations. This prevents accidental overwrites and lets you compare schedule changes across versions without manual file management.

Can I programmatically edit Excel files without using the Excel application?

Yes. WBS-excel uses openpyxl to read, modify, and write Excel workbooks directly from Python code. You can automate WBS updates, Gantt generation, and formatting without opening Excel or requiring manual intervention.

Do I need special setup to apply holiday calendars to Excel project dates?

WBS-excel requires only a workbook with task start dates and durations. It handles holiday-aware calculations internally using WORKDAY functions, so you don't need external calendar tools or complex Excel configuration.