Resources for Calculating Caseloads

Updated November 2024

The MIDC’s Staff has prepared resources to assist funding units in tracking caseloads of attorneys assigned in adult criminal cases. The MIDC Caseload Tracker spreadsheets provide local indigent defense systems with tools to track attorney workloads and calculate attorneys’ proximity to Standard 6 workload maximums.  Use of these resources is optional and provided upon request and for the convenience of stakeholders in the criminal legal system.

• The Basic Version is designed to function as a pre-built calculator for systems looking to analyze attorneys who carry mixed caseloads (i.e., a mix of felonies, misdemeanors, arraignment shifts, etc.). Systems can enter an attorney’s assignments and docket hours into the spreadsheet, and the spreadsheet will calculate how close the attorney is to their workload maximum and how many assignments and hours remain available.
  • Link to instructions, spreadsheet, and video tutorial
• The Individual Assignment Entry spreadsheet is designed to allow systems to enter individual assignments and docket shifts and have the spreadsheet automatically calculate the attorney’s workload – over the last 365 days, any four quarter period, any quarter, or any month – how close the attorney is to their workload maximum, and how many assignments and hours remain available.
  • Link to instructions, spreadsheet, and video tutorial
• The Quarterly Entry – 4Q Rolling Average version is designed to allow systems to enter caseload data on a quarterly basis while having the spreadsheet calculate annual attorney workloads based on any four quarters selected by the user. Systems can enter an attorney’s assignments and docket hours into the spreadsheet on a quarterly basis, and the spreadsheet will calculate how close the attorney is to their workload maximum and how many assignments and hours remain available for the current year.
  • Link to instructions, spreadsheet, and video tutorial

Note: The Individual Assignment Entry and Quarterly Entry – 4Q Rolling Average sheets were updated in November 2024 to add new features and improve functionality for users with older versions of Excel.