Calculate grade reductions for absences using Excel formulas that apply penalty rates, enforce minimum grades, and cap maximum deductions.