Solving Players Being Duplicated | NBA Model Update (Patreon)

G'day lads,

In the video above I run through how I solved a small issue with the Excel LADZ NBA Model. In some  teams, players like Jimmy Butler were showing up twice; once in the starting lineup and once on the bench. This is obviously an error, and has been fixed. The Excel LADZ NBA Model files on the original post have been updated, and will not show this error again 👍 The models are also included as attachments to this post lads.

The issue was two players were given the same rank, as their Minutes Played (MP) was the same. This caused the RANK.EQ function to give players the same rank, and literally skip the next rank. This 'skipped' rank was then included as the first player on the bench. This would cause a player to appear twice, if their MP exactly matched somebody else's on the team.

To fix this, I used the ROW() function to add a very small decimal (insignificant to the final result) to each player's MP in the 'Player Working' spreadsheet. This way, no player's MP would match another's (while the integrity and efficiency of the model is maintained).

If you have any questions lads let me know! 💪