BooAi Gantt and Double-Code Network Diagram Generator

Problem

In bid preparation and construction planning, schedule tables often require manually extracting activities, durations, and dependencies from tender documents and BOQ files, then rebuilding Gantt charts and double-code network diagrams. This skill turns that repetitive work into a reviewable pipeline: it extracts schedule data from Excel, Word, or PDF documents and generates CPM-aware table-format Gantt charts and interactive double-code network diagrams for critical-path review and tender output.

Core workflow and capabilities

• Document parsing: parse_bid_docs.py detects BOQ table structures, classifies items into construction phases, and merges them into schedulable activities; options include --no-merge, --duration N, and --start-date YYYY-MM-DD.
• Manual review: parsed data is written to schedule_data.json, where activity lists can be checked, predecessor relationships adjusted, durations overridden, and parallel activities added.
• Gantt output: generate_gantt.py produces 施工进度横道图.xlsx and 施工进度横道图.html, with month/day axes, colored bars, and CPM fields such as ES, EF, LS, LF, and TF; the critical path is highlighted in red.
• Network diagram output: generate_network.py produces an interactive SVG double-code network diagram and a CPM parameter table, with zooming, critical-path filtering, tooltips, and dashed lines for virtual activities.

Boundaries

This skill works best for construction projects with relatively clear activity structures and recognizable BOQ headers. For large projects with more than 50 activities, HTML output is usually more practical for review, while Excel Gantt output is better for printing and inclusion in bid documents. Auto-estimated durations and dependencies still require manual verification, especially to ensure the critical path matches actual construction logic.