Could you attach a .twbx file? It's likely an issue with the TOTAL() function.
I also took a quick look at this and I'm not sure how you are getting those numbers in Tableau, I was able to duplicate exactly what you are reporting for Excel in the attached.
Thanks for your help!
I made some changes with the average (AVG) and the SUM in the calculated fields. Now the calculation is correct.