I have attached two excel files which show some tasks that have been automated. The files have some calculations that run after clicking buttons which have been written in Macro in Excel. I have been...

I have attached two excel files which show some tasks that have been automated. The files have some calculations that run after clicking buttons which have been written in Macro in Excel. I have been assigned to re-write the code in Python and run them in Excel using VBA. So, the task is to write the exact codes in Python that have been already written in Macro and execute the same tasks. The Python codes must be able to exactly perform the same tasks as the codes in Macro is performing, in the same cells and for the same list of names and conditions. Thank you