Auto Calculating GPA Excel Template

I have several grade reports saved as PDFs. The information is laid out neatly in tables, and each semester contains somewhere between five and ten courses. I need that data brought into Excel and organised so I can change any course entry later and have the semester-level and cumulative GPA update automatically, using a credit-weighted calculation. Here’s the flow I have in mind: • Extract the semester, course name, letter grade, credit hours and any term totals from the PDF tables. • Map each record into a clean Excel table so new rows or semesters can be added without breaking the formulas. • Build formulas (or a light VBA helper if you prefer) that translate each letter grade into its grade-point value, multiply by credits, and divide by total credits for an accurate weighted GPA—both per semester and overall. • Include safeguards such as data validation for letter grades and credits so accidental typos don’t throw off the math. I should be able to open the file, type or paste new courses, and instantly see updated GPAs without touching the logic. If you lean on Power Query or another import method, feel free—just keep the final workbook lightweight and transparent so I can maintain it myself. If that scope sounds clear, let’s get started and I’ll share a sample PDF right away.

Project ID: 40188878