At a glance, it looks like the sheet author is doing some autocalc shenanigans that probably aren't necessary and may be resulting in unexpected values due to floating point errors. I can't delve much deeper (on a tablet in a hotel at the moment), but I can check again when I'm back on my computer tomorrow, assuming nobody else has a solution for you.