Build Employee Performance Tracker Spreadsheet

Create a comprehensive employee performance tracker spreadsheet for [DEPARTMENT] with [NUMBER_OF_EMPLOYEES] employees. The tracker should monitor performance over [TIME_PERIOD] and include the following requirements: **Core Structure:** 1. Employee information columns: Name, ID, Position, Start Date, Manager 2. Performance metrics relevant to [DEPARTMENT] including both quantitative and qualitative measures 3. Monthly/quarterly tracking columns for the specified time period 4. Automated scoring system with weighted categories 5. Visual indicators (conditional formatting) for performance levels **Key Features to Include:** - Goal-setting section with target vs. actual performance - Comments/notes section for manager feedback - Overall performance score calculation using formulas - Performance trend analysis (improvement/decline indicators) - Dashboard summary section with key statistics **Specific Requirements:** - Use appropriate Excel/Google Sheets formulas for calculations - Include data validation for consistent data entry - Create drop-down menus for standardized ratings - Add conditional formatting rules for visual performance indicators - Include instructions for managers on how to use the tracker **Output Format:** Provide the column headers, sample data for 2-3 employees, all necessary formulas, conditional formatting rules, and step-by-step setup instructions. Focus on [PRIMARY_PERFORMANCE_METRIC] as the main success indicator.