I was wondering about how well the calculations for Shamir worked as well, or for any character that joins your party with an advanced class.
For characters that you recruit, you have to assume a certain class progression since you don't necessarily know what classes they were before or what level they re-classed at. Most of my recruits joined after level 10, so I just assumed a beginner class for them that made sense. For any of the students, it probably doesn't make too much of a difference because they likely wouldn't spend too much time in a beginner class.
Shamir is interesting because she joins with an advanced class, possibly before the required level of 20. The spreadsheet assumes that she was a Sniper since level 0 to when she joins your party. The expected stat calculations might not work as well, and we don't really know how the game distributes stats to characters you recruit later. I have yet to recruit Alois/Gilbert/Cahterine/Seteth, so it'll be cool to see how their stats compared to the "expected."