I don't think the heroism/bloodlust value is being turned off for the stat-affected DPS tables when you change the heroism/bloodlust value from 1 to 0 on the "current" sheet.
The following is the content of the AG38 cell in the broken form:
=IF(U38<(40+AF38*300);IF(U38<$B$12;1;IF(AF38<$B$13;1;0));0)
And I believe the following is the correct formula for that cell:
=IF(U38<(40+AF38*300);IF(U38<$B$12;IF(AF38<$B$13;1;0);0);0)
The problem appears to affect columns AG, BA, BP, and BU from cells 38 to 65535+.