Hello,
I'm not sure if you want the code to do these tasks or simply the results of the calculations for the 540 files. There is no a significant difference for me, since I will write the code in any case, simply the code will be more "friendly" if you want to use it your own.
A few words about me: I'm developing VBA programs for more than 15 years and I'm a VBA and Excel trainer for 12+ years. As you can guess, I have created a plethora of programs and sheets of any kind, for both training purposes and business.
Looking forward to hear from you,
Kind regards,
Chriskerpini