From the archive
Day 40
Saturday, 12 September 2026
Weigh a GPA by credit hours instead of by course count
AVERAGE treats every course the same regardless of size — SUMPRODUCT paired with SUM lets a 4-credit lecture course count four times as much as a 1-credit lab.
Task:
You handle transcript calculations in a university registrar's office. A student's fall semester grades are in front of you, and each course carries a different number of credit hours — a 1-credit lab should not pull the GPA as hard as a 4-credit lecture course. Work out the credit-weighted GPA in C6.
The daily challenge is part of Pro
A new exercise every morning, plus every day that came before it — a back catalogue that grows by one a day, whether or not you were here for it.
Recent days
The last 14 days. Today's challenge is free while your streak is alive; Pro opens every past day too.
- 48Day 48 · Sunday, 20 September 2026Flag over- and under-budget departments in a quarterly variance reportLatest
- Day 47 · Saturday, 19 September 2026Bill only the memberships that are actually still active
- Day 46 · Friday, 18 September 2026Price a pick list against a supplier catalogue that no longer lists everything
- Day 45 · Thursday, 17 September 2026Find how much to deposit today to cover a multi-year scholarship payout
- Day 44 · Wednesday, 16 September 2026Report a fair "typical" salary when one outlier skews the average
- Day 43 · Tuesday, 15 September 2026Look up a placement fee from a category-by-level fee grid
- Day 42 · Monday, 14 September 2026Clean migrated customer names for a CRM import
- Day 41 · Sunday, 13 September 2026Sort machined shafts into Pass, Rework, or Scrap from two tolerance windows
- Day 40 · Saturday, 12 September 2026Weigh a GPA by credit hours instead of by course count
- Day 39 · Friday, 11 September 2026Report a call center's hold times without one outlier setting the headline number
- Day 38 · Thursday, 10 September 2026Split shipping addresses into city and state
- Day 37 · Wednesday, 9 September 2026Read a CD rate off a table laid out by term, not by row
- Day 36 · Tuesday, 8 September 2026Average order value for one channel and one region — then a threshold on top
- Day 35 · Monday, 7 September 2026Work out when equipment has to ship, counting backward from a start date