Human: <div class="">please create an excel spread sheet to record information for employee annual reviews. the spread sheet should include the following headers: Employee name, Truly Compassionate: Care deeply: Lead with empathy, Truly Innovative: Be actively curious: Empower every team member, Truly Ambitious: Take the initiative: Unlock potential, Truly Together: Support each other: Build trusting teams, Truly Inclusive: Promote belonging: Lead inclusively, Summary comment and rating, Performance Goals comment and rating, Development plan comment and rating, Overall Performance comment and rating, to each of those fields please add a place to enter employee rating and comment and manager rating and comment, except for the Employee name.</div>
ChatGPT:
Certainly, I can help you design an Excel spreadsheet for employee annual reviews based on the information you provided. Here's a suggested layout:
| Employee Name | Truly Compassionate - Care deeply - Lead with empathy | Employee Rating | Employee Comment | Manager Rating | Manager Comment |
|---|---|---|---|---|---|
| [Employee 1] | [Rating] | [Comment] | [Rating] | [Comment] | |
| [Employee 2] | [Rating] | [Comment] | [Rating] | [Comment] | |
| [Employee 3] | [Rating] | [Comment] | [Rating] | [Comment] | |
| [Employee 4] | [Rating] | [Comment] | [Rating] | [Comment] | |
| ... | ... | ... | ... | ... | ... |
Repeat the same structure for each of the performance areas and summary sections. This format allows you to input employee and manager ratings along with comments for each performance category.
Please customize the placeholders like "[Employee 1]" and "[Rating]" with actual employee names and ratings. Let me know if you need any adjustments or if there's anything else you'd like to include.
Human: <div class="">please include all of the performance areas and summary sections in one spreadsheet complete so that I can copy and paste into excel
</div>
ChatGPT:
Certainly! Here's a complete layout that you can copy and paste into Excel:
plaintext| Employee Name | Truly Compassionate - Care deeply - Lead with empathy | Employee Rating | Employee Comment | Manager Rating | Manager Comment | |---------------|------------------------------------------------------|------------------|------------------|----------------|-----------------| | [Employee 1] | [Rating] | [Comment] | [Rating] | [Comment] | | [Employee 2] | [Rating] | [Comment] | [Rating] | [Comment] | | [Employee 3] | [Rating] | [Comment] | [Rating] | [Comment] | | [Employee 4] | [Rating] | [Comment] | [Rating] | [Comment] | | ... | ... | ... | ... | ... | ... | | Employee Name | Truly Innovative - Be actively curious - Empower every team member | Employee Rating | Employee Comment | Manager Rating | Manager Comment | |---------------|-----------------------------------------------------------------------|------------------|------------------|----------------|-----------------| | [Employee 1] | [Rating] | [Comment] | [Rating] | [Comment] | | [Employee 2] | [Rating] | [Comment] | [Rating] | [Comment] | | [Employee 3] | [Rating] | [Comment] | [Rating] | [Comment] | | [Employee 4] | [Rating] | [Comment] | [Rating] | [Comment] | | ... | ... | ... | ... | ... | ... | | Employee Name | Truly Ambitious - Take the initiative - Unlock potential | Employee Rating | Employee Comment | Manager Rating | Manager Comment | |---------------|---------------------------------------------------------|------------------|------------------|----------------|-----------------| | [Employee 1] | [Rating] | [Comment] | [Rating] | [Comment] | | [Employee 2] | [Rating] | [Comment] | [Rating] | [Comment] | | [Employee 3] | [Rating] | [Comment] | [Rating] | [Comment] | | [Employee 4] | [Rating] | [Comment] | [Rating] | [Comment] | | ... | ... | ... | ... | ... | ... | | Employee Name | Truly Together - Support each other - Build trusting teams | Employee Rating | Employee Comment | Manager Rating | Manager Comment | |---------------|------------------------------------------------------------|------------------|------------------|----------------|-----------------| | [Employee 1] | [Rating] | [Comment] | [Rating] | [Comment] | | [Employee 2] | [Rating] | [Comment] | [Rating] | [Comment] | | [Employee 3] | [Rating] | [Comment] | [Rating] | [Comment] | | [Employee 4] | [Rating] | [Comment] | [Rating] | [Comment] | | ... | ... | ... | ... | ... | ... | | Employee Name | Truly Inclusive - Promote belonging - Lead inclusively | Employee Rating | Employee Comment | Manager Rating | Manager Comment | |---------------|-------------------------------------------------------|------------------|------------------|----------------|-----------------| | [Employee 1] | [Rating] | [Comment] | [Rating] | [Comment] | | [Employee 2] | [Rating] | [Comment] | [Rating] | [Comment] | | [Employee 3] | [Rating] | [Comment] | [Rating] | [Comment] | | [Employee 4] | [Rating] | [Comment] | [Rating] | [Comment] | | ... | ... | ... | ... | ... | ... | | Employee Name | Summary comment and rating | Employee Rating | Employee Comment | Manager Rating | Manager Comment | |---------------|---------------------------|------------------|------------------|----------------|-----------------| | [Employee 1] | [Comment] | [Rating] | [Comment] | [Rating] | [Comment] | | [Employee 2] | [Comment] | [Rating] | [Comment] | [Rating] | [Comment] | | [Employee 3] | [Comment] | [Rating] | [Comment] | [Rating] | [Comment] | | [Employee 4] | [Comment] | [Rating] | [Comment] | [Rating] | [Comment] | | ... | ... | ... | ... | ... | ... | | Employee Name | Performance Goals comment and rating | Employee Rating | Employee Comment | Manager Rating | Manager Comment | |---------------|--------------------------------------|------------------|------------------|----------------|-----------------| | [Employee 1] | [Comment] | [Rating] | [Comment] | [Rating] | [Comment] | | [Employee 2] | [Comment] | [Rating] | [Comment] | [Rating] | [Comment] | | [Employee 3] | [Comment] | [Rating] | [Comment] | [Rating] | [Comment] | | [Employee 4] | [Comment] | [Rating] | [Comment] | [Rating] | [Comment] | | ... | ... | ... | ... | ... | ... | | Employee Name | Development plan comment and rating | Employee Rating | Employee Comment | Manager Rating | Manager Comment | |---------------|-------------------------------------|------------------|------------------|----------------|-----------------| | [Employee 1] | [Comment] | [Rating] | [Comment] | [Rating] | [Comment] | | [Employee 2] | [Comment] | [Rating] | [Comment] | [Rating] | [Comment] | | [Employee 3] | [Comment] | [Rating] | [Comment] | [Rating] | [Comment] | | [Employee 4] | [Comment] | [Rating] | [Comment] | [Rating] | [Comment] | | ... | ... | ... | ... | ... | ... | | Employee Name | Overall Performance comment and rating | Employee Rating | Employee Comment | Manager Rating | Manager Comment | |---------------|----------------------------------------|------------------|------------------|----------------|-----------------| | [Employee 1] | [Comment] | [Rating] | [Comment]
Human: <div class="">format this as a table so I can copy and paste it into an Excel spreadsheet</div>
ChatGPT:
Certainly! Here's the information formatted as a table for easy copying into Excel:
plaintextEmployee Name | Truly Compassionate - Care deeply - Lead with empathy | Employee Rating | Employee Comment | Manager Rating | Manager Comment --------------|------------------------------------------------------|------------------|------------------|----------------|----------------- [Employee 1] | [Rating] | [Comment] | [Rating] | [Comment] | [Employee 2] | [Rating] | [Comment] | [Rating] | [Comment] | [Employee 3] | [Rating] | [Comment] | [Rating] | [Comment] | [Employee 4] | [Rating] | [Comment] | [Rating] | [Comment] | ... | ... | ... | ... | ... | ... Employee Name | Truly Innovative - Be actively curious - Empower every team member | Employee Rating | Employee Comment | Manager Rating | Manager Comment --------------|-----------------------------------------------------------------------|------------------|------------------|----------------|----------------- [Employee 1] | [Rating] | [Comment] | [Rating] | [Comment] | [Employee 2] | [Rating] | [Comment] | [Rating] | [Comment] | [Employee 3] | [Rating] | [Comment] | [Rating] | [Comment] | [Employee 4] | [Rating] | [Comment] | [Rating] | [Comment] | ... | ... | ... | ... | ... | ... Employee Name | Truly Ambitious - Take the initiative - Unlock potential | Employee Rating | Employee Comment | Manager Rating | Manager Comment --------------|---------------------------------------------------------|------------------|------------------|----------------|----------------- [Employee 1] | [Rating] | [Comment] | [Rating] | [Comment] | [Employee 2] | [Rating] | [Comment] | [Rating] | [Comment] | [Employee 3] | [Rating] | [Comment] | [Rating] | [Comment] | [Employee 4] | [Rating] | [Comment] | [Rating] | [Comment] | ... | ... | ... | ... | ... | ... Employee Name | Truly Together - Support each other - Build trusting teams | Employee Rating | Employee Comment | Manager Rating | Manager Comment --------------|------------------------------------------------------------|------------------|------------------|----------------|----------------- [Employee 1] | [Rating] | [Comment] | [Rating] | [Comment] | [Employee 2] | [Rating] | [Comment] | [Rating] | [Comment] | [Employee 3] | [Rating] | [Comment] | [Rating] | [Comment] | [Employee 4] | [Rating] | [Comment] | [Rating] | [Comment] | ... | ... | ... | ... | ... | ... Employee Name | Truly Inclusive - Promote belonging - Lead inclusively | Employee Rating | Employee Comment | Manager Rating | Manager Comment --------------|-------------------------------------------------------|------------------|------------------|----------------|----------------- [Employee 1] | [Rating] | [Comment] | [Rating] | [Comment] | [Employee 2] | [Rating] | [Comment] | [Rating] | [Comment] | [Employee 3] | [Rating] | [Comment] | [Rating] | [Comment] | [Employee 4] | [Rating] | [Comment] | [Rating] | [Comment] | ... | ... | ... | ... | ... | ... Employee Name | Summary comment and rating | Employee Rating | Employee Comment | Manager Rating | Manager Comment --------------|---------------------------|------------------|------------------|----------------|----------------- [Employee 1] | [Comment] | [Rating] | [Comment] | [Rating] | [Comment] | [Employee 2] | [Comment] | [Rating] | [Comment] | [Rating] | [Comment] | [Employee 3] | [Comment] | [Rating] | [Comment] | [Rating] | [Comment] | [Employee 4] | [Comment] | [Rating] | [Comment] | [Rating] | [Comment] | ... | ... | ... | ... | ... | ... Employee Name | Performance Goals comment and rating | Employee Rating | Employee Comment | Manager Rating | Manager Comment --------------|--------------------------------------|------------------|------------------|----------------|----------------- [Employee 1] | [Comment] | [Rating] | [Comment] | [Rating] | [Comment] | [Employee 2] | [Comment] | [Rating] | [Comment] | [Rating] | [Comment] | [Employee 3] | [Comment] | [Rating] | [Comment] | [Rating] | [Comment] | [Employee 4] | [Comment] | [Rating] | [Comment] | [Rating] | [Comment] | ... | ... | ... | ... | ... | ... Employee Name | Development plan comment and rating | Employee Rating | Employee Comment | Manager Rating | Manager Comment --------------|-------------------------------------|------------------|------------------|----------------|----------------- [Employee 1] | [Comment] | [Rating] | [Comment] | [Rating] | [Comment] | [Employee 2] | [Comment] | [Rating] | [Comment] | [Rating] | [Comment] | [Employee 3] | [Comment] | [Rating] | [Comment] | [Rating] | [Comment] | [Employee 4] | [Comment] | [Rating] | [Comment] | [Rating] | [Comment] | ... | ... | ... | ... | ... | ... Employee Name | Overall Performance comment and rating | Employee Rating | Employee Comment | Manager Rating | Manager Comment --------------|----------------------------------------|------------------|------------------|----------------|----------------- [Employee 1] | [Comment] | [Rating] | [Comment] | [Rating] | [Comment] | [Employee 2] | [Comment] | [Rating] | [Comment] | [Rating] | [Comment] | [Employee 3] | [Comment] | [Rating] | [Comment] | [Rating
Human: <div class="">please format as a table for excel</div>
ChatGPT:
Certainly! Here's the information formatted as a table for easy copying into Excel:
plaintext| Employee Name | Truly Compassionate - Care deeply - Lead with empathy | Employee Rating | Employee Comment | Manager Rating | Manager Comment | |---------------|------------------------------------------------------|------------------|------------------|----------------|-----------------| | [Employee 1] | [Rating] | [Comment] | [Rating] | [Comment] | | [Employee 2] | [Rating] | [Comment] | [Rating] | [Comment] | | [Employee 3] | [Rating] | [Comment] | [Rating] | [Comment] | | [Employee 4] | [Rating] | [Comment] | [Rating] | [Comment] | | ... | ... | ... | ... | ... | ... | | Employee Name | Truly Innovative - Be actively curious - Empower every team member | Employee Rating | Employee Comment | Manager Rating | Manager Comment | |---------------|-----------------------------------------------------------------------|------------------|------------------|----------------|-----------------| | [Employee 1] | [Rating] | [Comment] | [Rating] | [Comment] | | [Employee 2] | [Rating] | [Comment] | [Rating] | [Comment] | | [Employee 3] | [Rating] | [Comment] | [Rating] | [Comment] | | [Employee 4] | [Rating] | [Comment] | [Rating] | [Comment] | | ... | ... | ... | ... | ... | ... | | Employee Name | Truly Ambitious - Take the initiative - Unlock potential | Employee Rating | Employee Comment | Manager Rating | Manager Comment | |---------------|---------------------------------------------------------|------------------|------------------|----------------|-----------------| | [Employee 1] | [Rating] | [Comment] | [Rating] | [Comment] | | [Employee 2] | [Rating] | [Comment] | [Rating] | [Comment] | | [Employee 3] | [Rating] | [Comment] | [Rating] | [Comment] | | [Employee 4] | [Rating] | [Comment] | [Rating] | [Comment] | | ... | ... | ... | ... | ... | ... | | Employee Name | Truly Together - Support each other - Build trusting teams | Employee Rating | Employee Comment | Manager Rating | Manager Comment | |---------------|------------------------------------------------------------|------------------|------------------|----------------|-----------------| | [Employee 1] | [Rating] | [Comment] | [Rating] | [Comment] | | [Employee 2] | [Rating] | [Comment] | [Rating] | [Comment] | | [Employee 3] | [Rating] | [Comment] | [Rating] | [Comment] | | [Employee 4] | [Rating] | [Comment] | [Rating] | [Comment] | | ... | ... | ... | ... | ... | ... | | Employee Name | Truly Inclusive - Promote belonging - Lead inclusively | Employee Rating | Employee Comment | Manager Rating | Manager Comment | |---------------|-------------------------------------------------------|------------------|------------------|----------------|-----------------| | [Employee 1] | [Rating] | [Comment] | [Rating] | [Comment] | | [Employee 2] | [Rating] | [Comment] | [Rating] | [Comment] | | [Employee 3] | [Rating] | [Comment] | [Rating] | [Comment] | | [Employee 4] | [Rating] | [Comment] | [Rating] | [Comment] | | ... | ... | ... | ... | ... | ... | | Employee Name | Summary comment and rating | Employee Rating | Employee Comment | Manager Rating | Manager Comment | |---------------|---------------------------|------------------|------------------|----------------|----------------
Human: <div class="">please format the information for Excel</div>
ChatGPT:
Certainly! Below is the information formatted specifically for Excel:
Copy and paste this directly into Excel:
cssEmployee Name,Truly Compassionate - Care deeply - Lead with empathy,Employee Rating,Employee Comment,Manager Rating,Manager Comment
[Employee 1],[Rating],[Comment],[Rating],[Comment],
[Employee 2],[Rating],[Comment],[Rating],[Comment],
[Employee 3],[Rating],[Comment],[Rating],[Comment],
[Employee 4],[Rating],[Comment],[Rating],[Comment],
...
Employee Name,Truly Innovative - Be actively curious - Empower every team member,Employee Rating,Employee Comment,Manager Rating,Manager Comment
[Employee 1],[Rating],[Comment],[Rating],[Comment],
[Employee 2],[Rating],[Comment],[Rating],[Comment],
[Employee 3],[Rating],[Comment],[Rating],[Comment],
[Employee 4],[Rating],[Comment],[Rating],[Comment],
...
Employee Name,Truly Ambitious - Take the initiative - Unlock potential,Employee Rating,Employee Comment,Manager Rating,Manager Comment
[Employee 1],[Rating],[Comment],[Rating],[Comment],
[Employee 2],[Rating],[Comment],[Rating],[Comment],
[Employee 3],[Rating],[Comment],[Rating],[Comment],
[Employee 4],[Rating],[Comment],[Rating],[Comment],
...
Employee Name,Truly Together - Support each other - Build trusting teams,Employee Rating,Employee Comment,Manager Rating,Manager Comment
[Employee 1],[Rating],[Comment],[Rating],[Comment],
[Employee 2],[Rating],[Comment],[Rating],[Comment],
[Employee 3],[Rating],[Comment],[Rating],[Comment],
[Employee 4],[Rating],[Comment],[Rating],[Comment],
...
Employee Name,Truly Inclusive - Promote belonging - Lead inclusively,Employee Rating,Employee Comment,Manager Rating,Manager Comment
[Employee 1],[Rating],[Comment],[Rating],[Comment],
[Employee 2],[Rating],[Comment],[Rating],[Comment],
[Employee 3],[Rating],[Comment],[Rating],[Comment],
[Employee 4],[Rating],[Comment],[Rating],[Comment],
...
Employee Name,Summary comment and rating,Employee Rating,Employee Comment,Manager Rating,Manager Comment
[Employee 1],[Comment],[Rating],[Comment],[Rating],[Comment],
[Employee 2],[Comment],[Rating],[Comment],[Rating],[Comment],
[Employee 3],[Comment],[Rating],[Comment],[Rating],[Comment],
[Employee 4],[Comment],[Rating],[Comment],[Rating],[Comment],
...
Employee Name,Performance Goals comment and rating,Employee Rating,Employee Comment,Manager Rating,Manager Comment
[Employee 1],[Comment],[Rating],[Comment],[Rating],[Comment],
[Employee 2],[Comment],[Rating],[Comment],[Rating],[Comment],
[Employee 3],[Comment],[Rating],[Comment],[Rating],[Comment],
[Employee 4],[Comment],[Rating],[Comment],[Rating],[Comment],
...
Employee Name,Development plan comment and rating,Employee Rating,Employee Comment,Manager Rating,Manager Comment
[Employee 1],[Comment],[Rating],[Comment],[Rating],[Comment],
[Employee 2],[Comment],[Rating],[Comment],[Rating],[Comment],
[Employee 3],[Comment],[Rating],[Comment],[Rating],[Comment],
[Employee 4],[Comment],[Rating],[Comment],[Rating],[Comment],
...
Employee Name,Overall Performance comment and rating,Employee Rating,Employee Comment,Manager Rating,Manager Comment
[Employee 1],[Comment],[Rating],[Comment],[Rating],[Comment],
[Employee 2],[Comment],[Rating],[Comment],[Rating],[Comment],
[Employee 3],[Comment],[Rating],[Comment],[Rating],[Comment],
[Employee 4],[Comment],[Rating],[Comment],[Rating],[Comment],
...
Replace [Employee 1], [Rating], and [Comment] with your actual employee names, ratings, and comments.
Human: <div class="">is not working when I paste it into excel</div>
ChatGPT:
I apologize for the inconvenience. It seems that the formatting might be causing issues. Let me provide you with a revised format that should work better for copying into Excel:
plaintextEmployee Name,Truly Compassionate - Care deeply - Lead with empathy,Employee Rating,Employee Comment,Manager Rating,Manager Comment [Employee 1],[Rating],[Comment],[Rating],[Comment], [Employee 2],[Rating],[Comment],[Rating],[Comment], [Employee 3],[Rating],[Comment],[Rating],[Comment], [Employee 4],[Rating],[Comment],[Rating],[Comment], ... Employee Name,Truly Innovative - Be actively curious - Empower every team member,Employee Rating,Employee Comment,Manager Rating,Manager Comment [Employee 1],[Rating],[Comment],[Rating],[Comment], [Employee 2],[Rating],[Comment],[Rating],[Comment], [Employee 3],[Rating],[Comment],[Rating],[Comment], [Employee 4],[Rating],[Comment],[Rating],[Comment], ... Employee Name,Truly Ambitious - Take the initiative - Unlock potential,Employee Rating,Employee Comment,Manager Rating,Manager Comment [Employee 1],[Rating],[Comment],[Rating],[Comment], [Employee 2],[Rating],[Comment],[Rating],[Comment], [Employee 3],[Rating],[Comment],[Rating],[Comment], [Employee 4],[Rating],[Comment],[Rating],[Comment], ... Employee Name,Truly Together - Support each other - Build trusting teams,Employee Rating,Employee Comment,Manager Rating,Manager Comment [Employee 1],[Rating],[Comment],[Rating],[Comment], [Employee 2],[Rating],[Comment],[Rating],[Comment], [Employee 3],[Rating],[Comment],[Rating],[Comment], [Employee 4],[Rating],[Comment],[Rating],[Comment], ... Employee Name,Truly Inclusive - Promote belonging - Lead inclusively,Employee Rating,Employee Comment,Manager Rating,Manager Comment [Employee 1],[Rating],[Comment],[Rating],[Comment], [Employee 2],[Rating],[Comment],[Rating],[Comment], [Employee 3],[Rating],[Comment],[Rating],[Comment], [Employee 4],[Rating],[Comment],[Rating],[Comment], ... Employee Name,Summary comment and rating,Employee Rating,Employee Comment,Manager Rating,Manager Comment [Employee 1],[Comment],[Rating],[Comment],[Rating],[Comment], [Employee 2],[Comment],[Rating],[Comment],[Rating],[Comment], [Employee 3],[Comment],[Rating],[Comment],[Rating],[Comment], [Employee 4],[Comment],[Rating],[Comment],[Rating],[Comment], ... Employee Name,Performance Goals comment and rating,Employee Rating,Employee Comment,Manager Rating,Manager Comment [Employee 1],[Comment],[Rating],[Comment],[Rating],[Comment], [Employee 2],[Comment],[Rating],[Comment],[Rating],[Comment], [Employee 3],[Comment],[Rating],[Comment],[Rating],[Comment], [Employee 4],[Comment],[Rating],[Comment],[Rating],[Comment], ... Employee Name,Development plan comment and rating,Employee Rating,Employee Comment,Manager Rating,Manager Comment [Employee 1],[Comment],[Rating],[Comment],[Rating],[Comment], [Employee 2],[Comment],[Rating],[Comment],[Rating],[Comment], [Employee 3],[Comment],[Rating],[Comment],[Rating],[Comment], [Employee 4],[Comment],[Rating],[Comment],[Rating],[Comment], ... Employee Name,Overall Performance comment and rating,Employee Rating,Employee Comment,Manager Rating,Manager Comment [Employee 1],[Comment],[Rating],[Comment],[Rating],[Comment], [Employee 2],[Comment],[Rating],[Comment],[Rating],[Comment], [Employee 3],[Comment],[Rating],[Comment],[Rating],[Comment], [Employee 4],[Comment],[Rating],[Comment],[Rating],[Comment], ...
Please copy and paste this revised format into Excel. Replace [Employee 1], [Rating], and [Comment] with your actual employee names, ratings, and comments. This format separates each field with commas, which should be more compatible with Excel.
Add a comment
Add to Chrome - It's free
Add to Firefox - It's free
Add to Edge - It's free