Notes
Calculated : //additional tie scenarios based on memory scores or rare item permutations if( (([loc_b4_calc_ltmem]=3 and [loc_b4_calc_gtmem]=1) or ([loc_b4_calc_ltmem]=1 and [loc_b4_calc_gtmem]=3)) and [loc_b4_calc_eqmem]=1 and max([loc_b4_calc_eq05], [loc_b4_calc_eq1], [loc_b4_calc_eq2], [loc_b4_calc_eq3],[loc_b4_calc_eq0])=1, [memory], if([memory]=3 and max([loc_b4_calc_eq05], [loc_b4_calc_eq1], [loc_b4_calc_eq2], [loc_b4_calc_eq3],[loc_b4_calc_eq0])=[loc_b4_calc_eq2], '2', if([memory]=3 and max([loc_b4_calc_eq05], [loc_b4_calc_eq1], [loc_b4_calc_eq2], [loc_b4_calc_eq3],[loc_b4_calc_eq0])=[loc_b4_calc_eq1], '1', if([memory]=3 and max([loc_b4_calc_eq05], [loc_b4_calc_eq1], [loc_b4_calc_eq2], [loc_b4_calc_eq3],[loc_b4_calc_eq0])=[loc_b4_calc_eq05], '0.5', if([memory]=3 and max([loc_b4_calc_eq05], [loc_b4_calc_eq1], [loc_b4_calc_eq2], [loc_b4_calc_eq3],[loc_b4_calc_eq0])=[loc_b4_calc_eq0], '0.5', if([memory]=2 and max([loc_b4_calc_eq05], [loc_b4_calc_eq1], [loc_b4_calc_eq2], [loc_b4_calc_eq3],[loc_b4_calc_eq0])=[loc_b4_calc_eq2], '2', if([memory]=2 and max([loc_b4_calc_eq05], [loc_b4_calc_eq1], [loc_b4_calc_eq2], [loc_b4_calc_eq3],[loc_b4_calc_eq0])=[loc_b4_calc_eq1], '1', if([memory]=2 and max([loc_b4_calc_eq05], [loc_b4_calc_eq1], [loc_b4_calc_eq2], [loc_b4_calc_eq3],[loc_b4_calc_eq0])=[loc_b4_calc_eq3], '3', if([memory]=2 and max([loc_b4_calc_eq05], [loc_b4_calc_eq1], [loc_b4_calc_eq2], [loc_b4_calc_eq3],[loc_b4_calc_eq0])=[loc_b4_calc_eq05], '0.5', if([memory]=2 and max([loc_b4_calc_eq05], [loc_b4_calc_eq1], [loc_b4_calc_eq2], [loc_b4_calc_eq3],[loc_b4_calc_eq0])=[loc_b4_calc_eq0], '0.5', if([memory]=1 and max([loc_b4_calc_eq05], [loc_b4_calc_eq1], [loc_b4_calc_eq2], [loc_b4_calc_eq3],[loc_b4_calc_eq0])=[loc_b4_calc_eq1], '1', if([memory]=1 and max([loc_b4_calc_eq05], [loc_b4_calc_eq1], [loc_b4_calc_eq2], [loc_b4_calc_eq3],[loc_b4_calc_eq0])=[loc_b4_calc_eq05], '0.5', if([memory]=1 and max([loc_b4_calc_eq05], [loc_b4_calc_eq1], [loc_b4_calc_eq2], [loc_b4_calc_eq3],[loc_b4_calc_eq0])=[loc_b4_calc_eq0], '0.5', if([memory]=1 and max([loc_b4_calc_eq05], [loc_b4_calc_eq1], [loc_b4_calc_eq2], [loc_b4_calc_eq3],[loc_b4_calc_eq0])=[loc_b4_calc_eq2], '2', if([memory]=1 and max([loc_b4_calc_eq05], [loc_b4_calc_eq1], [loc_b4_calc_eq2], [loc_b4_calc_eq3],[loc_b4_calc_eq0])=[loc_b4_calc_eq3], '3', 9999)))))))))))))))