Electrician Performance Appraisal Form

Electrician Performance Appraisal FormIt is a form for evaluation and statistics of employees' work performance, work ability, work attitude and personal morality. This is a set of electrician performance appraisal form downloads that have been carefully screened by Huajun Software Park. The template format is XLSX. After downloading the electrician performance appraisal form Excel for free through Huajun Software Park, you can change the content and style of the template by yourself!

Tips for using electrician performance appraisal form

​​​Electrician Performance Appraisal FormPreparation of:

S: (Specific) ------Clear and specific, the indicators should be clear and specific, so that the assessor and the assessee can accurately understand the goals;
M: (Measurable)------quantifiable. A company must quantify its boss, company, and organizational structure.
A: (Attainable)-----Achievable, goals and assessment indicators must be achievable with hard work, neither too high nor too low.
R: (Relevant) ------actual, realistic, not hypothetical. The definition of reality is having existing resources, being objective and real;
T: (Time bound)-----Time-bound. Goals and indicators must be time-bound and must be completed within the specified time. Once the time is up, the results will be seen.

General Tips for Electrician Performance Appraisal Form

​ ​ 1: How to sum text

In some relatively non-standard tables, there will be a problem of mixing text and numbers, which makes summation difficult.

​​ Enter the formula in cell C12: =SUM(--SUBSTITUTE(C2:C11,"元",""))

              Press the key combination to complete.

​ ​ 2: Summing multiple worksheets

For example, some tables have performance statistics for several months, and Zhang Cheng’s position in each worksheet is the same. Find Zhang Cheng’s commission statistics from a certain month to a certain month.

​ ​ Enter the formula in cell F5: =SUM('January:April'!C2), and press Enter to complete the filling.

Note: The above reference is supported in Excel, but it seems not supported in WPS. And please note that the structure or fixed position of the numbers in each table is the same before you can use this formula.

​ ​ 3: Multi-region joint calculation

In some worksheets, we do not need to sum continuous areas, but may be summing several discontinuous areas.

For example, there is a table that calculates the totals from January to February, March and May to June.

​​Enter the formula in cell H2, press the Enter key to complete and fill downwards.

=SUM(B2:C2,E2,G2)

Recommended by the editor of Huajun Software Park

The Electrician Performance Appraisal Form is a very practical form, and most of the forms are for general purposes. If you happen to need to download the Excel form of the Electrician Performance Appraisal Form, please download it quickly.Hygiene duty schedule,Class safety record sheetIt is also a good form. Welcome to click to download and experience it!