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. |