effective_status_report:
  principles:
    - name: "Consistent Formatting"
      description: "Use consistent structure and hierarchy across all reports"

    - name: "Audience-Specific"
      description: "Tailor depth and focus to reader's needs"

    - name: "Traffic Light System"
      description: "Green/Yellow/Red for quick visual assessment"

    - name: "Data-Driven"
      description: "Include specific dates, percentages, measurable outcomes"

    - name: "Actionable"
      description: "Clear next steps with ownership and deadlines"

    - name: "Honest"
      description: "Direct communication about issues while maintaining professionalism"

undefined

undefined

undefined

undefined

undefined

undefined

undefined

---

undefined

undefined

undefined

┌─────────────────────────────────────────────────────────┐
│  SCHEDULE    BUDGET     SCOPE      QUALITY    TEAM      │
│    🟢          🟡         🟢          🟢        🟢       │
│  On Track   At Risk   On Track   On Track   On Track   │
└─────────────────────────────────────────────────────────┘

---

undefined

Velocity (Story Points)
50 │         ╭─────╮
40 │    ╭────╯     ╰────
30 │────╯
   └──────────────────────
     S1  S2  S3  S4  S5  S6

undefined

undefined

                    LOW IMPACT    MED IMPACT    HIGH IMPACT
                   ┌────────────┬────────────┬────────────┐
HIGH PROBABILITY   │    🟡      │    🟠      │    🔴      │
                   ├────────────┼────────────┼────────────┤
MED PROBABILITY    │    🟢      │    🟡      │    🟠      │
                   ├────────────┼────────────┼────────────┤
LOW PROBABILITY    │    🟢      │    🟢      │    🟡      │
                   └────────────┴────────────┴────────────┘

undefined

undefined

Scope Growth Rate
  15% │    ╭──── Warning Zone ────
  10% │────╯
   5% │
   0% │════════════════════════
      Week 1   2   3   4   5   6

---

undefined

undefined

undefined

---

best_practices:
  timing:
    - "Send reports consistently (same day/time each period)"
    - "Allow 24 hours for review before meetings"
    - "Distribute before, not during, status meetings"

  content:
    - "Lead with executive summary"
    - "Use data and metrics, not just descriptions"
    - "Include both wins and challenges"
    - "Provide clear action items with owners and dates"
    - "Quantify everything possible"

  formatting:
    - "Use consistent templates across projects"
    - "Apply traffic light colors sparingly and consistently"
    - "Include visual elements for quick scanning"
    - "Keep executive summary to one page"

  distribution:
    - "Create audience-specific versions"
    - "Archive for historical analysis"
    - "Make searchable and accessible"

common_mistakes:
  - mistake: "Burying critical issues"
    impact: "Stakeholders blindsided by problems"
    fix: "Lead with issues requiring attention"

  - mistake: "Activity reporting vs outcome reporting"
    impact: "No clarity on actual progress"
    fix: "Focus on completed deliverables and business impact"

  - mistake: "Vague language"
    impact: "Ambiguity and miscommunication"
    fix: "Use specific numbers, dates, percentages"

  - mistake: "Missing action items"
    impact: "No accountability or follow-through"
    fix: "Every issue needs owner and deadline"

  - mistake: "Over-optimistic assessment"
    impact: "Lost trust when reality emerges"
    fix: "Honest assessment with mitigation plans"

  - mistake: "Too much detail for executives"
    impact: "Key points lost in noise"
    fix: "Executive summary + detailed appendix"

-- Sprint progress query for status report
SELECT
    sprint_name,
    COUNT(CASE WHEN status = 'Done' THEN 1 END) as completed,
    COUNT(CASE WHEN status = 'In Progress' THEN 1 END) as in_progress,
    COUNT(CASE WHEN status = 'To Do' THEN 1 END) as todo,
    SUM(CASE WHEN status = 'Done' THEN story_points ELSE 0 END) as completed_points,
    SUM(story_points) as total_points,
    ROUND(SUM(CASE WHEN status = 'Done' THEN story_points ELSE 0 END) * 100.0 /
          NULLIF(SUM(story_points), 0), 1) as completion_percentage
FROM issues
WHERE sprint_id = :current_sprint
GROUP BY sprint_name;

// Automated status collection bot
const statusPrompt = {
  blocks: [
    {
      type: "section",
      text: {
        type: "mrkdwn",
        text: "*Weekly Status Update*\nPlease provide your status for the week:"
      }
    },
    {
      type: "input",
      element: {
        type: "plain_text_input",
        action_id: "accomplishments",
        multiline: true,
        placeholder: { type: "plain_text", text: "What did you accomplish?" }
      },
      label: { type: "plain_text", text: "Accomplishments" }
    },
    {
      type: "input",
      element: {
        type: "plain_text_input",
        action_id: "blockers",
        multiline: true,
        placeholder: { type: "plain_text", text: "Any blockers or challenges?" }
      },
      label: { type: "plain_text", text: "Blockers" }
    },
    {
      type: "input",
      element: {
        type: "plain_text_input",
        action_id: "next_week",
        multiline: true,
        placeholder: { type: "plain_text", text: "What's planned for next week?" }
      },
      label: { type: "plain_text", text: "Next Week's Focus" }
    }
  ]
};