Librecalc automatic grading of columns

We can use the following Pyoo based python script to automatically assign grades based on CGPA values in a column.

For example, consider the following file with CGPAs listed in the column B

If we want to assign grades based on  the CGPA values, we can use the script attached.

The script needs Pyoo to be installed, the steps for the same can be seen here .

Please note that to be able to run the script the following command needs to be run in the terminal,

  
 
soffice --accept="socket,host=localhost,port=2002;urp;" --norestore --nologo --nodefault
 

If the script is saved as column_grade.py run the script from the terminal.

$ python column_grade.py Enter the column header of which grading is needed CGPA Assigned 1th grade Assigned 2th grade Assigned 3th grade Assigned 4th grade Assigned 5th grade Assigned 6th grade Assigned 7th grade Assigned 8th grade Assigned 9th grade Assigned 10th grade Assigned 11th grade Assigned 12th grade Assigned 13th grade Assigned 14th grade

The file should get updated and look as below.