Is there a way to check/constrain a column?

I am building a Top 25 college football voting system for my website and I keep going back and forth on how to structure everyone 🫠 🙃 yay analysis paralysis. Anyways... I have been trying to figure out what is the "best" way to associate a ranking to points (a first place vote gets 25 points down to 1 point for a 25th place vote). I think I have figured out a decent way to accomplish this by basically making each rank in the ballot a row in the table. However, is there a way to make sure that the rank and points are 1-25? I want to then compile another table that calculates all the votes each team got and how many points they got for a particular week in the season. Also, open to any other suggestions on the best way to do this.