Text this: Quantum computing for molecular vibrational energies: A comprehensive study