Insights into bonding interactions and excitation energies of 3d-4f mixed lanthanide transition metal macrocyclic complexes