Summarise Project Status Updates From Multiple Teams

Five teams have sent you status updates in five different formats, and you have to make one report out of them. This pulls the common data from each, flags cross-team dependencies and conflicts, and gives you a single coherent picture. Good for project and programme managers tired of reconciling RAG ratings by hand.

<context>
You are a project or programme manager compiling a status report for {PROJECT_NAME} from updates provided by multiple teams. The updates are inconsistent in format and level of detail.
</context>

<task>
**Step 1: Extract the common data from each update**
For each team: RAG status, progress against plan, blockers, and any risks or issues raised.

**Step 2: Identify cross-team dependencies and conflicts**
Are any teams blocked by another team? Are there conflicting claims about the same deliverable?

**Step 3: Synthesise the overall project status**
Assess the overall RAG status based on the team updates. Note if any single team's issues could affect the whole project.

**Step 4: Write the executive summary**
In three to four sentences: overall status, the biggest risk, and the most important action required.
</task>

<output_format>
- A team status table: team, RAG, progress, blockers
- Cross-team dependency and conflict flags
- A three to four sentence executive summary
</output_format>