Question description:
This user has given permission to use the problem statement for this
blog.
Need a spreadsheet for a performance review 1-5 with explanations. I would like to have the scores sum at the end
Solved by K. U. in 50 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
31/07/2018 - 03:45
Hi
User
31/07/2018 - 03:45
Hello
User
31/07/2018 - 03:45
I would like to have either radio buttons or a drop down list in the field next to RATING
Excelchat Expert
31/07/2018 - 03:46
sure
User
31/07/2018 - 03:46
Those are the options
Excelchat Expert
31/07/2018 - 03:47
you are building the excel for the peformace from the start?
User
31/07/2018 - 03:47
To get even more tricky, I would like the value selected in the rating box to convert to a number in C1
User
31/07/2018 - 03:47
Yes, from scratch
Excelchat Expert
31/07/2018 - 03:48
So let start from the top..!st will you have individual sheet for each employee?
Excelchat Expert
31/07/2018 - 03:48
Usually there is a list of enployee followed by a list of things you want to rate them on
Excelchat Expert
31/07/2018 - 03:48
employee
User
31/07/2018 - 03:48
In my perfect world, I will send the spreadsheet to the supervisor that will complete and email back to me.
User
31/07/2018 - 03:49
I will type the name into the name box.
Excelchat Expert
31/07/2018 - 03:49
oh ok then what are the points on which your rated like here you have aAttitude
User
31/07/2018 - 03:49
Everything will be scored 1-5
Excelchat Expert
31/07/2018 - 03:50
so in the drop down you want 1-5 to be displayed along with the explanation?
User
31/07/2018 - 03:50
The "Supervisor Comments" will be a free form box to type anything valuable or to explain.
User
31/07/2018 - 03:50
Yes
Excelchat Expert
31/07/2018 - 03:51
hmm how about next to it?
Excelchat Expert
31/07/2018 - 03:51
can the description come next to the rating box?
User
31/07/2018 - 03:51
I know how to make it a drop down but I don't know how to make the Score number sum what the total is
User
31/07/2018 - 03:51
Yes, next to is perfect!
User
31/07/2018 - 03:51
I just need 3 to be meets expectations, etc.
Excelchat Expert
31/07/2018 - 03:52
got it..
Excelchat Expert
31/07/2018 - 03:52
now Score is just waht you would select in rating?
Excelchat Expert
31/07/2018 - 03:52
1-5?
User
31/07/2018 - 03:53
Yes, the supervisor selects the score in the rating box and then the score adds up all of the different topics (attitude, perfomance, customer service, etc)
Excelchat Expert
31/07/2018 - 03:53
how would you want the topics to be displayed
User
31/07/2018 - 03:53
radio button or drop down.
User
31/07/2018 - 03:54
Oh, topics, will be listed
Excelchat Expert
31/07/2018 - 03:54
where will perfomance come based on that i can build the formula
User
31/07/2018 - 03:54
THey will rate attitude first, then perfomance below and below that will be customer serivce
User
31/07/2018 - 03:55
Make sense/
Excelchat Expert
31/07/2018 - 03:56
yes
Excelchat Expert
31/07/2018 - 03:56
perfect
Excelchat Expert
31/07/2018 - 03:56
so score is individual?
User
31/07/2018 - 03:57
Each topic has an individual and then a Grand total at the bottom
Excelchat Expert
31/07/2018 - 03:57
ok give me few min to work on it please stay here
User
31/07/2018 - 03:57
OK, thanks
User
31/07/2018 - 04:02
No pressure, but time is ticking. What happens at 0:00
Excelchat Expert
31/07/2018 - 04:02
he he :)
[Uploaded an Excel file]
Excelchat Expert
31/07/2018 - 04:02
we get extension for 20 min when clock hits 2
Excelchat Expert
31/07/2018 - 04:02
can you check this excel
User
31/07/2018 - 04:03
OMG it's amazing!!
Excelchat Expert
31/07/2018 - 04:03
:)
User
31/07/2018 - 04:03
If I lock the fields, will they still be able to select a score?
Excelchat Expert
31/07/2018 - 04:04
no
User
31/07/2018 - 04:04
OK, that's fine.
Excelchat Expert
31/07/2018 - 04:04
the cell cannot be protected
User
31/07/2018 - 04:05
Is there a way to alert if they skip a topic?
Excelchat Expert
31/07/2018 - 04:06
hmm i need to change the formula a bit do you want that?
Excelchat Expert
31/07/2018 - 04:06
also if you want to add more topics..copy one of the topics
User
31/07/2018 - 04:06
If it's not too much to ask
Excelchat Expert
31/07/2018 - 04:07
say attitude a16:k21
Excelchat Expert
31/07/2018 - 04:07
then paste it at the bottom
User
31/07/2018 - 04:07
Perfect
Excelchat Expert
31/07/2018 - 04:09
[Uploaded an Excel file]
Excelchat Expert
31/07/2018 - 04:09
[Uploaded an Excel file]
Excelchat Expert
31/07/2018 - 04:09
then right click and do a inset copied cell all the formulas will work
Excelchat Expert
31/07/2018 - 04:10
reference will change automatically
User
31/07/2018 - 04:10
Ok, I'm fairly comfortable with that.
Excelchat Expert
31/07/2018 - 04:10
good let me update the formula then
Excelchat Expert
31/07/2018 - 04:16
just few min there isn't a direct way to do it so just few min to get a hack
User
31/07/2018 - 04:16
OK
User
31/07/2018 - 04:22
What is a Beta Period?
Excelchat Expert
31/07/2018 - 04:26
HI
Excelchat Expert
31/07/2018 - 04:26
Not sure
User
31/07/2018 - 04:26
Hello
Excelchat Expert
31/07/2018 - 04:27
Building formula
Excelchat Expert
31/07/2018 - 04:27
Few more min
User
31/07/2018 - 04:27
OK
Excelchat Expert
31/07/2018 - 04:31
[Uploaded an Excel file]
Excelchat Expert
31/07/2018 - 04:31
can you please check
Excelchat Expert
31/07/2018 - 04:32
you there
User
31/07/2018 - 04:32
Yes, checking now
User
31/07/2018 - 04:33
It looks the same as the first one. Is it suppose to have fireworks or something when they skip lol
Excelchat Expert
31/07/2018 - 04:33
:) no i was trying to get the average of score in the 1st one
Excelchat Expert
31/07/2018 - 04:33
then figured it cannot be one when you skip the ratting as score ia automated to 0
User
31/07/2018 - 04:34
Ok, this will work. Thank you so much for your help
Excelchat Expert
31/07/2018 - 04:34
welcome :)
Excelchat Expert
31/07/2018 - 04:34
please do leave a feedback once you end the session
User
31/07/2018 - 04:34
Will do. thanks again
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.