Quote Originally Posted by fulminating View Post
Ty, numbers are numbers, but some people find them kind of tricky to abstract- for ease of parsing them, it might be helpful to have some kind of bar chart just with the average scores. It could use the role colours for an all in one one or the fforbidden calculator site scheme if being all on the same chart would be more helpful.

E: don’t worry too much about it if it’s tricky though, excel and the like are annoying to use at the best of times
I tried to include graphs like that, but there isn’t a good way to do it on google sheets. The best option would look misleading, as instead of showing how many votes were a 1, a 2 a 3, etc… it would show you how many votes were between 0.0 and 1.0, between 1.1 and 2.0, etc. So I decided against including that.

Instead, if you return to the actual form for each job, you should have the option to view results, and not only will you be able to see those graphs the way you describe (love that google forms displays info that way but google sheets doesn’t have a similar option), but you’ll also be able to see what percentage of players selected which categories to see more of/less of.

Those results can only be viewed one at a time, it doesn’t show the average, median, and mode values for the 1-10 ranges, and reading through the written feedback is less clear. So the spreadsheets still help communicate that info.