Accurate Prediction for Dynamic Hybrid Local and Charge Transfer Excited States from Optimally Tuned Range-Separated Density Functionals