Energetics of the solar semidiurnal tide in the atmosphere