I want to create an employee rating system.

Employee Rating = (Weight of Retention Score * Total Retention Score + Weight of Feedback * Total Feedback Score + Weight of Leadership Reaction * Average Leadership Reaction Score + Weight of Blogs * Total Blogs) / Total Weight

Given the new table, we can calculate the employee rating for each employee using the following weights:

    Weight of Retention Score: 0.3
    Weight of Feedback: 0.4
    Weight of Leadership Reaction: 0.2
    Weight of Blogs: 0.1

We can then use the following values for each category:

    Maximum Retention Score: 10
    Maximum Feedback Score: 30 (10 from each leader)
    Maximum Leadership Reaction Score: 10
    Maximum Blogs Score: 2

| Employee            | Title                                        | Op's Notes                | NAME_1 Feedback | NAME_2 Feedback | NAME_3 Feedback | NAME_1 (left) | NAME_2 (left) | NAME_3 (left) | Blogs | 
|---------------------|----------------------------------------------|---------------------------|----------------|------------------|----------------|----------------------------------|------------------------------------|------------------------------------|---------------------------------|-------|
| NAME_4 NAME_5.             | NAME_6| Lead Adjustment           | NAME_7| NAME_7  | NAME_7| distressed                       | distressed                         | anxious                         | 4     |
| Cully NAME_8.            | Lead Engineer 