I was lucky to have a firm background in using formula functions in MS Excel, and confidence changing cell formats (merging, colours, sizes, fonts, formatting in terms of number display as %, etc.).
However, for linking formulae and cells between different pages within one workbook (as I do here), I had to search for online tutorials. I ended up watching a couple of short YouTube videos produced by the University of Toronto (HERE), though I'm sure there are many other valuable resources that would work just as well.
The formulae for the % complete (by 2 week increments) are as follows:
Week 2: =MIN(D8/600,1)
Week 4: =MIN(D8/1200, 1)
Week 6: =MIN(D8/1800, 1)
Week 8: =MIN(D8/2400, 1)
Week 10: =MIN(D8/3000, 1)
Week 12: =MIN(D8/3600, 1)
Week 14: =MIN(D8/4200, 1)
Week 16: =MIN(D8/4800, 1)
Having the row display whichever is least (MIN) of the XP/total expected for 100% according to the recommended pacing, or 1, means that the displayed weekly % will not exceed 100. This looks less confusing for the students, in my opinion.