Formula to Calculate Games Back - MLB Baseball Wild Card

Attached is my document....

My games back for the division is calculated correctly, but I can't figure out the wild card games back...

I feel like I'm really close, but I just can't get it. See the attached document for my formulas. My desired result is in the far right column. Thank you!!

Edit: I apologize for not providing context and explanation... wasn't aware this was required when posting a excel workbook. As for the problem, I'm trying to get the games back for a wild card team based on MLB record results. My columns are the following:

Name: Team name
Wins: Actual wins
Losses: Actual Losses
Division: Team Division
League: Team League
Win %: Win % based on record
Division Rank: Formula to calculate where the team ranks in the division using a COUNTIFS function
WC Help: If a team is not leading a division (doesn't have a 1 in the Division Rank), then this fills with a "YES", otherwise fills with "-"
WC Rank: Uses a COUNTIFS function to give a rank of where teams stand based on win% compared to all non-division winners split up by league (AL and NL have their own Wild Card)
Division Games Back: Uses MAX and MIN with nested IF statements to calculate the games back of everyone behind their division leader

WC Games Back (DESIRED RESULT): Looking to calculate the games back of everyone behind the top two teams not leading a division (Teams with a "YES" in the WC Rank Column) split up by AL and NL leagues... the top 2 teams in the WC ranking (if they have a 1 or a 2 in the WC Rank Column) will have a "+" and however many games they are above the 3rd place team, whereas everyone from 3-15 rank in the league will show how many games back they are behind the 2nd ranked team in the Wild Card

rosetc16,

We ask that you wait at least 24 hours before bumping your thread.

We are "staffed" by volunteers from all over the world many of whom are asleep at any given time.
Please be patient.

I went about this differently as in I used the teams games above or below the .500 mark to determine the games ahead or behind in the wild card races.
This proposal employs multiple helper columns (N:X) which may be moved and/or hidden for aesthetic purposes.
I am not going to post all of the formulas involved but will post some examples.
The array entered formulas that calculate a teams 1st, 2nd or 3rd wild card position are similar to: =IF(Q3=MAX(IF(F$3:F$32=F3,IF(R$3:R$32>1,Q$3:Q$32))),Q3,"")
The array entered formulas that calculate how far ahead a 1st or 2nd place team of the 3rd place team is similar to: =IF(S3<>"",S3-INDEX(U$3:U$32,MATCH(1,1/(F$3:F$32=F3)*(U$3:U$32<>""),0)),"")
The formula that calculates how far the rest of the teams are from the 2nd place team is similar to: =IF(OR(R3=1,S3<>"",T3<>""),"",Q3-INDEX(T$3:T$32,MATCH(1,1/(F$3:F$32=F3)*(T$3:T$32<>""),0)))
The formula for the wild card games ahead/behind is: =IF(R3=1,"-",SUM(V3:X3))
Note that some of the results differ from those listed as 'Desired WC results' however I feel that the formula calculated correctly.
Let us know if you have any questions.