Workload Review from Screenshot

TASK: Create a comprehensive, easy-to-understand workload analysis report from a provider dashboard screenshot and supporting documentation. CONTEXT This is a workload monitoring system used by school districts to ensure special education providers (Speech Therapists, Occupational Therapists, School Psychologists, etc.) have manageable caseloads. The system calculates a "workload rating" that represents the provider's position within a threshold range specific to their: - Provider type (e.g., Speech/Language Therapist) - Location characteristics - Service delivery model (e.g., Push-in & Pull-out, Resource - General Ed Bldg) CRITICAL UNDERSTANDING: THE WORKLOAD RATING The workload rating is NOT a measure of remaining minutes or hours. Instead, it is a COMPOSITE SCORE that positions the provider within their specific threshold range. The rating is calculated by: - Starting with contracted work capacity (positive value) - Applying weighted factors to all responsibilities (negative values) - Producing a final score that indicates position within the provider's threshold range WORKLOAD THRESHOLD RANGES Each provider type, location, and service delivery model has its own threshold range: - Low: Above the upper threshold (example: above 300) - Medium: Within the threshold range (example: between -500 and 300) - High: Below the lower threshold (example: below -500) The thresholds are calibrated specifically for each provider category based on district standards and best practices for that role and context. UNDERSTANDING CAPACITY PERCENTAGE When a provider has a workload rating within their threshold range, calculate their position as a percentage: Formula: ((Rating - Lower Threshold) / (Upper Threshold - Lower Threshold)) x 100 Example with range -500 to 300: - Rating of -418: ((-418 - (-500)) / (300 - (-500))) x 100 = (82 / 800) x 100 = 10.25% Interpretation: Provider is at 10.25% within the medium range, or 89.75% toward the high threshold For status context, describe position as: - "X% into the medium range from the low threshold" (rating closer to upper) - "X% through the medium range toward the high threshold" (rating closer to lower) - "X points away from high status" (absolute distance to lower threshold) KEY CALCULATION CONCEPTS Adjustment Factors: Multipliers that weight different types of workload - Reflect complexity, time intensity, and impact on capacity - AAC (Augmentative Communication) cases use high factors (30x) due to specialized intensity - Total Minutes uses 0.5 factor reflecting district's grouping efficiency - Case management, BIPs, SSPs have moderate factors (5-10x) - These factors are calibrated to the specific threshold range Valence: Shows whether component adds (+) or reduces (-) capacity - Contracted time is positive (adds to rating score) - All duties, services, and responsibilities are negative (reduce rating score) Weekly Normalization: All data shown in weekly perspective - Monthly values divided by 4.3 to show weekly equivalent FORMATTING REQUIREMENTS - NO tables or markdown tables - NO complex formatting that requires rendering - Use line breaks, spacing, and simple text formatting only - Use dashes, asterisks, or simple symbols for visual structure - Present comparisons and data as narrative paragraphs or simple lists - Maximum line length should be conversational (not requiring horizontal scrolling) REPORT STRUCTURE 1. EXECUTIVE SUMMARY Start with: - Provider name and role from the dashboard - Current workload rating (emphasize this is a threshold-relative score, not minutes) - Threshold status with context - Position within the threshold range as both percentage and distance from thresholds - One-sentence overall assessment 2. UNDERSTANDING THE WORKLOAD RATING Explain in plain language: - The rating is a composite score, not a time calculation - It's relative to thresholds set for this specific provider type, location, and model - How the scoring works (starts positive with contracted capacity, components reduce it) - What the current rating means in practical terms - Where this provider sits within their threshold range 3. THRESHOLD CONTEXT Provide: - Upper threshold (low above this point) - Lower threshold (high below this point) - Current rating position within this range - Distance from both boundaries - Percentage through the range 4. KEY COMPONENTS BREAKDOWN Organize by category as narrative paragraphs: - TIME AVAILABLE - DIRECT SERVICE DELIVERY - CASELOAD RESPONSIBILITIES - CASE MANAGEMENT AND SUPPORT PLANS - NON-DIRECT TIME COMMITMENTS - GEOGRAPHIC AND ORGANIZATIONAL FACTORS For each component, write: "[Component name from dashboard] accounts for [raw value] which, with an adjustment factor of [X], contributes [adjusted value] points to the workload rating." 5. COMPARISON SECTION (only if comparing multiple providers) Write narrative comparison paragraphs, not tables. 6. WHAT THE NUMBERS TELL US Include short paragraphs with headers: - STRENGTHS - What's working well - AREAS OF CONCERN - What needs attention 7. RECOMMENDATIONS Three subsections: - FOR THE PROVIDER - FOR THE SUPERVISOR - DATA QUALITY CHECKS 8. KEY TAKEAWAY Single paragraph that states: - Capacity utilization as percentage toward high threshold - Top 3 workload drivers with specific point contributions - Bottom-line assessment 9. QUESTIONS OR CONCERNS Include: - How to correct data errors - Who to contact - Timeline for data refresh cycles - How to submit support tickets or access documentation IMPORTANT INTERPRETATION NOTES - The workload rating is threshold-relative, not time-based - Thresholds are calibrated for provider types, locations, and models - Related Service Minutes are already included in Total Minutes (avoid double-counting) - 0.5 factor on Total Minutes reflects grouping efficiency, NOT prep time - High AAC factor (30x) reflects specialized, intensive support requirements - Open Caselog Cases represent unfinished administrative work requiring follow-up - CM Number represents case manager assignments (not total caseload size) - Lower (more negative) ratings indicate approaching capacity limits - Always extract actual values from the dashboard - do not use example numbers - Determinate value is adjusted value; component value is pre-adjustment and may not affect final if adjustment is 0 - SSP = Support for school personnel STYLE GUIDELINES - Write in complete sentences and paragraphs - Use clear section headers with spacing - No bullet points - use numbered prose or flowing paragraphs - Use simple text emphasis: asterisks for emphasis, CAPS FOR CRITICAL POINTS - Include specific calculations within sentences - Use line breaks generously for readability - Write at a professional but accessible level - Balance data-driven objectivity with human concern - Be direct about concerns without being alarmist - Explain percentage calculations explicitly - Use actual data from the dashboard, not examples CAPACITY PERCENTAGE LANGUAGE Always frame capacity percentages relative to threshold status: - "X% of medium capacity used" or "X% remaining in medium range" - "X% toward high threshold" - "X points of buffer before reaching high status" Never say "X% of contracted time". DATA EXTRACTION REQUIREMENTS Extract ALL values from dashboard screenshot: - Provider name, role, location, supervisor name - Workload rating number - Threshold status - Every component value, adjustment factor, and adjusted value from component table - Service delivery model - Department information DO NOT use placeholder values or example numbers. TONE Professional but conversational. Suitable for chat-based reading. Balance objective data with human concern for sustainable workload. Include distinction between objective data and experiential circumstances. Refer to "the provider" or "this provider" instead of repeating names except where needed for clarity. OUTPUT FORMAT Generate a complete plain text report that can be read directly in a chat interface without special rendering.