Tracking Growth & Care: Weight Curves, Body Condition, Age Equivalents & Care Calendars

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Turn ten weekly weigh-ins of a fictional puppy into gains in grams and percent, the average daily gain over the whole log and a one-week projection.
• Look up a size-class multiplier for six fictional puppies, estimate each adult weight, put a low–high range around it and spot the puppy that will probably end up heaviest.
• Compare Pepper's weights with a fictional lower and upper reference line, flag each weigh-in as Below, Within or Above, measure it against the middle of the band, count the readings outside and draw the growth chart.
• Turn eight months of weights and body condition scores into an implied ideal weight, the excess kilograms and a status per month, then derive a target from the last three months.
• Convert pet ages into «human years» with the simple ×7 rule and with a log-based formula, compare the two and chart both curves.
• Calculate the next due date of eight care items with EDATE, the days left until each one, an Overdue / Due soon / OK status and a highlight for the overdue rows.
• Add ISO week numbers to three weeks of Pepper's activity entries, total walk and play minutes per week with SUMIFS, compare each week with the family's goal and work out the average per calendar day.
• Build Pepper's dashboard: the weight trend in kg per week with SLOPE, the next open care date with MINIFS, the number of open items due within 30 days and a weight chart.