Get GPA from Academic records in HIS (Hochschul-Informations-System)

script.js

const parseCell = (cell) => Number(cell.textContent.trim().replace(",", "."));
const grades = Array.from(document.querySelectorAll(".content > table")[1].querySelectorAll("tr"))
     .filter((tr) => tr.querySelector(".tabelle1_aligncenter")) // No "Groups"
     .filter((tr) => parseCell(tr.children[5]) > 0) // Only rows where a grade is available
     .filter((tr) => tr.children[6].textContent.trim() === "BE") // Only passed exams
     .reduce((acc, curr) => {
       acc.grades.push(parseCell(curr.children[5]));
       acc.ects.push(parseCell(curr.children[7]));
       return acc;
     }, { grades: [], ects: [] });
if(grades.grades.length !== grades.ects.length) throw new Error("Couldn't parse grades/ects");
const ectsSum = grades.ects.reduce((acc, curr) => acc + curr, 0);
const gradeSum = grades.grades.reduce((acc, curr, idx) => acc + (curr * grades.ects[idx]), 0);
const gpa = ectsSum === 0 ? 0.0 : gradeSum / ectsSum;
console.log(`%c GPA: ${gpa} ECTS: ${ectsSum}`, 'background: #222; color: #bada55');