We investigated and found the following to be true:
When rookies were added to the sheet they were unsorted (not in alphabetical order like the rest of the team), then they were sorted by someone other than me who shall remain anonymous until @Bzerkap chooses to reveal that it was him, and doing this apparently affected their player IDs, which means despite me inputting their correct stats they were not updated.
When rookies were added to the sheet they were unsorted (not in alphabetical order like the rest of the team), then they were sorted by someone other than me who shall remain anonymous until @Bzerkap chooses to reveal that it was him, and doing this apparently affected their player IDs, which means despite me inputting their correct stats they were not updated.