{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Trades Performance Review Form","Data Validation"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Trades Performance Review Form","index":0,"n_rows":163,"n_cols":10,"rows_kept":163,"cut":false,"hidden":false,"merged":[[13,1,13,3],[27,1,34,7],[162,1,162,7],[99,1,106,7],[117,1,124,7],[129,1,138,7],[83,1,90,7],[67,1,74,7],[48,1,55,7],[14,4,14,7],[18,4,18,7],[13,4,13,7],[20,1,20,7]]}
[]
[null,null,null,null,null,null,"Rating Period: ",{"$f":"IF(ISBLANK(D9),\"\",D9)","v":"2019-20"}]
[null,"Auburn University",null,null,null,null,"June 1, 2019-May 31, 2020"]
[null,"Trades Performance Review Form"]
[]
[null,"Employee Last Name:",null,null,null,"First Name:"]
[null,"Employee Banner ID#:",null,null,null,"Division:"]
[null,"Employee in a Job Family?:",null,null,null,"Department:"]
[null,"Rating Period (Year):",null,"2019-20",null,"Job Title:"]
[null,"Supervisor Banner ID#:",null,null,null,"Current Hire Date:"]
[null,"Type of Review:",null,null,null,"Supervisor Name:"]
[]
[null,"Rating Scale"]
[null,"Rating",null,null,"Compliance Requirements"]
[null,"1 - Unacceptable",null,null,"Your department may require a detailed justification for this rating."]
[null,"2 - Marginal",null,null,"Your department may require a detailed justification for this rating."]
[null,"3 - Meets Expectations"]
[null,"4 - Exceeds Expectations",null,null,"Your department may require a detailed justification for this rating."]
[null,"5 - Exemplary",null,null,"Your department may require a detailed justification for this rating."]
[null,"N/A - Leave field blank"]
[null,"Definitions/examples of each rating are available at aub.ie/performance"]
[null,"I. Job Knowledge/Job Skills",null,null,null,null,null,"Rating"]
[null,"A. Consistently demonstrates knowledge to perform assigned tasks"]
[null,"B. Consistently demonstrates skills needed to perform assigned tasks"]
[null,"C. Demonstrates willingness to acquire new skills/increase knowledge and expertise"]
[null,null,null,null,null,null,"Section Rating:",{"$f":"IF(AND(ISBLANK(H23),ISBLANK(H24),ISBLANK(H25)),\"\",AVERAGE(H23:H25))","v":""}]
[null,"Supervisor's Comments (Job Knowledge/Job Skills):"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"II. Productivity",null,null,null,null,null,"Rating"]
[null,"A. Consistently completes expected quantity of work"]
[null,"B. Completes work with high quality (neatly and accurately)"]
[null,"C. Completes work on time"]
[null,"D. Works satisfactorily under pressure"]
[null,"E. Works satisfactorily without constant supervision"]
[null,"F. Shows initiative"]
[null,"G. Consistently demonstrates a positive attitude towards work both verbally and"]
[null,"     non-verbally"]
[null,null,null,null,null,null,"Section Rating:",{"$f":"IF(AND(ISBLANK(H37),ISBLANK(H38),ISBLANK(H39),ISBLANK(H40),ISBLANK(H41),ISBLANK(H42),ISBLANK(H43)),\"\",AVERAGE(H37:H43))","v":""}]
[null,"Employee Name:",null,{"$f":"$D$6&\", \"&$H$6","v":", "},null,null,"Rating Period: ","June 1, 2019-May 31, 2020"]
[]
[null,"Supervisor's Comments (Productivity):"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"III. Dependability/Reliability",null,null,null,null,null,"Rating"]
[null,"A. Can be relied upon consistently to complete assigned tasks"]
[null,"B. Works regularly as scheduled"]
[null,"C. Uses sick and/or vacation leave appropriately"]
[null,"D. Consistently observes work hours responsibly (Consider the beginning and"]
[null,"    ending of the work day, lunches and breaks)"]
[null,"E. Consistently adheres to departmental uniform requirement"]
[null,"F. Consistently presents professional appearance"]
[null,"G. Keeps personal telephone calls and visits to a minimum"]
[null,null,null,null,null,null,"Section Rating:",{"$f":"IF(AND(ISBLANK(H58),ISBLANK(H59),ISBLANK(H60),ISBLANK(H61),ISBLANK(H63),ISBLANK(H64),ISBLANK(H65)),\"\",AVERAGE(H58:H65))","v":""}]
[null,"Supervisor's Comments (Dependability/Reliability):"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"IV. Interpersonal Skills",null,null,null,null,null,"Rating"]
[null,"A. Works well with co-workers"]
[null,"B. Works well with other members of the university community"]
[null,"C. Works well with supervisor"]
[null,"D. Performs duties with courtesy and tact"]
[null,"E. Maintains appropriate grooming and hygiene"]
[null,null,null,null,null,null,"Section Rating:",{"$f":"IF(AND(ISBLANK(H77),ISBLANK(H78),ISBLANK(H79),ISBLANK(H80),ISBLANK(H81)),\"\",AVERAGE(H77:H81))","v":""}]
[null,"Supervisor's Comments (Interpersonal Skills):"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Employee Name:",null,{"$f":"$D$6&\", \"&$H$6","v":", "},null,null,"Rating Period: ","June 1, 2019-May 31, 2020"]
[]
[null,"V. Safety",null,null,null,null,null,"Rating"]
[null,"A. Consistently works in a safe manner"]
[null,"B. Operates tools and equipment using appropriate safety procedures"]
[null,"C. Identifies & effectively communicates work safety issues"]
[null,null,null,null,null,null,"Section Rating:",{"$f":"IF(AND(ISBLANK(H95),ISBLANK(H96),ISBLANK(H97)),\"\",AVERAGE(H95:H97))","v":""}]
[null,"Supervisor's Comments (Safety):"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"VI. Leadership and/or Supervisory Potential (mark only applicable areas)",null,null,null,null,null,"Rating"]
[null,"A. Demonstrates ability to train or guide others"]
[null,"B. Demonstrates ability to lead a crew of co-workers"]
[null,"C. Demonstrates ability to manage and schedule work"]
[null,"D. Demonstrates ability to communicate and keep co-workers informed"]
[null,"E. Implements departmental policies and procedures"]
[null,"F. Takes prompt action to resolve job and performance problems"]
[null,null,null,null,null,null,"Section Rating:",{"$f":"IF(AND(ISBLANK(H110),ISBLANK(H111),ISBLANK(H112),ISBLANK(H113),ISBLANK(H114),ISBLANK(H115)),\"\",AVERAGE(H110:H115))","v":""}]
[null,"Supervisor's Comments (Leadership and/or Supervisory Potential):"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Overall Rating"]
[]
[null,null,null,"Overall Rating:",{"$f":"IF(ISERROR(J128),\"\",J128)","v":""},null,null,null,null,{"$f":"IF(AND(ISBLANK(H26),ISBLANK(H45),ISBLANK(H66),ISBLANK(H82),ISBLANK(H98),ISBLANK(H116)),\"\",AVERAGE(H26,H45,H66,H82,H98,H116))","v":{"$error":"#DIV/0!"}}]
[null,"Supervisor's Comments (Overall Rating):"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Employee Name:",null,{"$f":"$D$6&\", \"&$H$6","v":", "},null,null,"Rating Period: ","June 1, 2019-May 31, 2020"]
[]
[]
[]
[null,"Are additional documents attached?"]
[null,"If so, number of pages attached?"]
[]
[null,"Performance Review Approval Signatures"]
[]
[null,null,"Supervisor Signature",null,null,null,"Date"]
[]
[null,null,"Manager Signature",null,null,null,"Date"]
[null,null,"(Second Level Review)"]
[]
[null,null,"HR Liaison Signature",null,null,null,"Date"]
[]
[null,"Performance Review Conducted"]
[null,"My signature indicates that my supervisor and I have discussed the contents of this document. It does not necessarily"]
[null,"mean that I agree with the results."]
[]
[null,null,"Employee Signature",null,null,null,"Date"]
[]
[]
[null," - - END OF REVIEW - -"]

{"sheet":"Data Validation","index":1,"n_rows":39,"n_cols":5,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
["Employee in a Job Family?","Rating Period (Year)","Type of Review","Division","Rating-5"]
["Yes","2015-16","Interim Review","100 - Office of the President",1]
["No","2016-17","Annual Review","102 - Asst Vice President Facilities",2]
[null,"2017-18",null,"103 - Vice Pres for Alumni Affairs",3]
[null,null,null,"104 - Vice President for Development",4]
[null,null,null,"105 - Graduate Studies",5]
[null,null,null,"108 - Dean of Enrollment Services"]
[null,null,null,"110 - Executive Vice President"]
[null,null,null,"111 - Asst VP for Auxiliary Services"]
[null,null,null,"113 - VP for Bus-Fin & CFO"]
[null,null,null,"114 - Alumni & Dvlmt Supt Services"]
[null,null,null,"115 - Risk Management & Safety"]
[null,null,null,"120 - College of Agriculture"]
[null,null,null,"123 - College of Business"]
[null,null,null,"126 - College of Education"]
[null,null,null,"128 - Samuel Ginn Col of Engineering"]
[null,null,null,"130 - Director Intercollegiate Athl"]
[null,null,null,"133 - Jule Collins Smith Museum"]
[null,null,null,"134 - College of Liberal Arts"]
[null,null,null,"136 - College of Sciences & Math"]
[null,null,null,"139 - College of Veterinary Medicine"]
[null,null,null,"140 - Exec Dir Communication & Mkt"]
[null,null,null,"142 - Architecture Design Construct"]
[null,null,null,"144 - Forestry & Wildlife Sciences"]
[null,null,null,"146 - College of Human Sciences"]
[null,null,null,"148 - School of Nursing"]
[null,null,null,"150 - School of Pharmacy"]
[null,null,null,"151 - Chief Information Office"]
[null,null,null,"152 - Library"]
[null,null,null,"153 - Diversity&MulticulturalAffairs"]
[null,null,null,"155 - Office of Info Technology"]
[null,null,null,"157 - Provost and VP Academic Affair"]
[null,null,null,"160 - Assoc Prov & VP for Outreach"]
[null,null,null,"169 - Vice President Student Affairs"]
[null,null,null,"170 - VP for Research & Economic Dev"]
[null,null,null,"180 - Undergraduate Studies"]
[null,null,null,"300 - Agriculture Experiment Station"]
[null,null,null,"400 - AL Cooperative Extension Sys"]
[null,null,null,"999 - AU Affiliated"]