This is a google sheet that helps you in calculating grade point,grade_score,SGPA , CGPA and more.
This is a general project in which I created a template for calculating your overall result for all the 8 semesters.
There are 8 sheets as of now in this single google sheet one for each semester.
Each semseter sheet consists of the following structure
- Grade
- Grade Point
- Credits
- Grade Score
- Total Marks
- Entering the following data
- Internals and Externals
- Grades
- Credits ( You have to refer to the syllabus for this there is no way currently to adjust it or automate it ๐ฟ )
GRADE_POINT_GENERATOR(grade)
: This takes the value of your grade and automatically returns the grade points.GRADE_SCORE(grade_sem,credit_sem)
: This takes the grade of that sem and credit of that sem and returns the grade score accordingly.SGPA(total_grade_score_sem,total_credits_sem)
:This takes the total grade score of the sem and total credits of that sem and returns the SGPA.
Thus you don't have to enter the grade point,grade score and SGPA it will be automatically calculated based on other values.
Note: Here in this sheet there are two SGPA columns one is manually entered and another is dynamically generated your CGPA is generated over manually entered SGPA to be accurate.But can be generated over dynamic ones also as described below.
This sheet is your overall result and hence contains all the details including the following
- SGPA(statically entered)
- Total Credits
- Total Marks
- Total Grade Score
- Recalculated SGPA ( dynamically calculated)
- Charts of sgpa vs sem and total_marks vs sem
- Total marks
- CGPA
- SGPA
CGPA(sgpa_sem1, credit_sem1, sgpa_sem2, credit_sem2, sgpa_sem3, credit_sem3, sgpa_sem4, credit_sem4, sgpa_sem5, credit_sem5, sgpa_sem6, credit_sem6, sgpa_sem7, credit_sem7, sgpa_sem8, credit_sem8, range_cells_credits)
- The above function takes the semester wise sgpa and credits and then gives back the cgpa
In future I would convert this into web-app maybe for ease of use case but as of right now this is what I am using.If anyone wants to collaborate for this project please contact me.Hope this helps!!
My socials are all here : https://bento.me/prakhargarg