Kalkulasi Skor Komposit Performance Review

HR business partner ngerjain performance review semesteran.

Score komposit = weighted average dari 3 dimensi dengan bobot beda:

• Productivity → 50%
• Quality → 30%
• Soft Skills → 20%

Threshold rating berdasarkan score komposit:

• ≥ 85 → "Outstanding"
• 70 – 84 → "Meet"
• < 70 → "Below"

Isi kolom Score Komposit (E2:E4) dan Rating (F2:F4).

Pastikan bobot total 100% (0.5 + 0.3 + 0.2 = 1.0).