Math nerd ranking pokemon types

I do not have much experience playing pokemon competitively. I'm much more casual player that plays only in niche formats with friends. But I have always been curious if there was a best type combination in pokemon. After watching a video, [1], I decided to encode the author's suggestion for ranking pokemon types. [2]

I'm curious if your experience is consistent with the ranks. If not, why not?

1. https://youtu.be/Ov85T9xO3Wk?si=fj8dgbl1_dy-00TZ

2. https://docs.google.com/spreadsheets/d/1QEde01hvgzPdO1cZWEKo8MSEnMjSruaxM0JR7WtHQoU/edit?usp=drivesdk