So in your example the yellow cell is set at 80%. No problem with the results in the APV column, but the BL column shows 1.8 where 3 of the 7 entries are #1 and two are #2. So 5 of the 7 are either 1 or 2 (5/7)ths = 71.43%. somewhat similarly in the BL/BL# column 5 of the 7 entrants are ranked #1 (again 71.42%)
It appears that if the yellow cell was set at 70% the above would be true answers, as opposed to 80%
Am I missing something?