Conduct staff performance evaluations.

Complete the Q2 staff performance evaluation for the forensic lab team. Put Accounting Manager Priya Nair and two direct reports, Sam Ortega and Li Chen, into the file, fill scored goals for productivity, accuracy and compliance, add manager comments about training needs, and route to HR Cassidy Morales for signature by next Tuesday. Check the formulas that average scores and ensure the overall rating matches the written summary before sending.

Before I share these evaluations with HR, make them easy to read and hard to dispute. Pull the productivity numbers to the top, show the error rate that produced the accuracy score, call out any missing training completions, and highlight any changes greater than one rating point from last review that would make a reviewer pause.

I just updated Sam Ortega's scores and his overall jumped unexpectedly. I don't know whether a weighted formula was altered, a cell was overwritten, or I misentered a subscore. HR will flag inconsistencies. What is the likely cause and the best immediate fix: restore last saved version, inspect formulas for overwritten cells, or recalc weights and document the change?

Over several cycles we spend hours reconciling final ratings because managers edit individual cells instead of updating source metrics. This costs credibility with HR and delays merit recommendations by weeks. What habit change and sheet redesign would prevent direct overwrites while making it easier for managers to correct source numbers?