Not quite sure where did the 2015 rank was meant to be coming from, as it wasn't in the original data set, so here's my solution without that. Hope I haven't missed anything!
I enjoy Weekly Chllenge - I may not read the story, just look at answer table and on input table and case-based development - easiest way to receive output table.
Either I missed something or there is no 2015 Team Rank field (as there is in the output file in the start workflow.) Let's see if anyone saw this (and maybe what I missed!)
(UPDATE) There is no 2015 Rank! (At least based on the posted solution!)