Lol how the hell do u calculate this?
I beat my opponent in 5 of the 8 matches and somehow lost
Each match is graded by how close you were
This is the formula.
Each second under the Total Time (10000-(1pt*Second))
Each second over the Total Time (10000-(5pt*Second))
Switch([tbl_Prediction].[Match_1]<[Time],10000-([Time]-[tbl_Prediction].[Match_1]),[tbl_Prediction].[Match_1]>[Time],10000-(([tbl_Prediction].[Match_1]-[Time])*5),[tbl_Prediction].[Match_1]=[Time],10000)