How to manually create coherence same as the add in module.

[ken007]

Hey guys, I have manually created the coherence worksheet but when I try to compare with the results from the add-in module (transfer function), the results doesn't seem match. Kindly have a look. =(