Just playing around with (a copy of) the surplus calculator, and I think I found an error. Feel free to trash me if I misunderstand, but…:
On sheet “$ Values Input” column F is called Salary but shows positions. The formula of the fields in that column is =IFERROR(VLOOKUP(A2,Rosters!A:H,8,FALSE),""), but I believe it should be =IFERROR(VLOOKUP(A2,Rosters!A:I,9,FALSE),"") to get the salary rather than the position. My guess is you added a column in the Roster sheet at some point but the formula was not updated?
Thanks for putting this out!