Team-capacity tracking with over-allocation alerts

The scenario calculates team load from Jira Software issues, keeps a history in Google Sheets, and on overload emails a report to the manager at Gmail.

  • Each person's load calculated automatically
  • Load history kept in Google Sheets
  • Overload — an email to the manager at Gmail
  • The problem seen ahead of the miss