Self Consistent Excited State Mean Field Theory: Development And Applications