| Sheet Name | Content | |------------|---------| | | Purpose, confidentiality notice, rating scale (e.g., 1–5), and step-by-step guidance for raters. | | Rater List | Columns: Rater ID, Rater Name, Role (Self, Manager, Peer, Subordinate, Client), Ratee Name. | | Competencies | List of competencies (e.g., Communication, Leadership, Teamwork) with definitions. | | Evaluation Form | Rows: Competencies + open-ended questions. Columns: Ratee name, rater role, scores, comments. | | Data Entry | One row per rater-response per competency (normalized format for analysis). | | Consolidation | Aggregated scores by competency and rater role. | | Dashboard | Visual charts (radar, bar) and gap analysis (self vs. others). | 4. Typical Rating Scale Used Most Excel 360 templates use a Likert scale (1 to 5 or 1 to 10):
| Ratee | Rater Email | Role | Competency | Score | Strengths | Improve | |-------|-------------|------|------------|-------|-----------|---------| | Ana | peer1@co.com | Peer | Teamwork | 4 | Collaborative | Speed | formato evaluacion 360 grados excel
| Score | Label | |-------|----------------| | 1 | Never / Below Expectations | | 2 | Rarely / Partially Meets | | 3 | Sometimes / Meets Expectations | | 4 | Often / Exceeds Expectations | | 5 | Always / Outstanding | | Sheet Name | Content | |------------|---------| |