Sorry, I've never used the worksheet.  But from the comments that I've read, the worksheet isn't set up particularly well and you need to 'know' how to enter things or it ends up with the wrong numbers (which is what you are seeing now).

If you are comfortable manually calculating it, you may consider just skipping the worksheet and just enter the final result.