Look-Ahead Planner Skill

Overview

The Look-Ahead Planner generates 3-week (configurable) lookahead schedules by synthesizing project intelligence into interactive, actionable documents. It maps schedule activities to subcontractors, locations (grid lines, building areas), material requirements, equipment needs, and weather constraints.

The skill reads historical schedule data, integrates pending items (RFIs, submittals), and cross-references material procurement status. It fetches weather forecasts for the project location and renders the result as an interactive HTML or PDF document—a forward-looking view of exactly what work, by whom, where, using what materials and equipment, under what conditions.

Key Outputs

• W Principles 4WLA Excel Spreadsheet (.xlsx) — Gantt-style bar chart matching the company template exactly. See references/w-principles-4wla-template-spec.md for the full template specification.
• Interactive HTML Lookahead with color-coded activities, milestone markers, and weather alerts
• Structured daily breakdown showing crew requirements, material deliveries, and blockers
• Searchable, self-contained document for field distribution
• Archive-friendly format stored in project config's lookahead_history

Template Loading

The skill uses the W Principles 4WLA template (AI - Project Brain/Templates/3WLA TEMPLATE.xlsx). If this file cannot be read (common when files are stored in OneDrive and not yet synced locally), the skill should generate the .xlsx from the template specification at references/w-principles-4wla-template-spec.md.