Automatic ranking in Google sheets, how to implement?

Question

Google

There is a table in which grades for the subject are constantly put down, that is, the student and in the line of his grade, at the end the average value. I wanted the new sheet to automatically generate a rating for academic performance, who has a higher average value. This question was already on the forum, but there was no specific answer to it, there were just links to the general Google manual.

Answer 1

They will not give you a specific answer, since no one will write the script for you.
Google has a JS-based language and an API for Sheets .
You need to implement the following in the script: when updating any of the cells of the specified range (you can subscribe to such an event), perform the necessary calculations and display the result in the specified cells on the second page of the document.
Some links as starting points:
I think a couple of hours of experimentation and you will come to a decision.
PS
The document of reading and the document of record - can be different. This is very convenient for access control.