Methodological Advances In Theoretical Spectroscopy For Bio And Inorganic Molecules