Local density total energy description of ground and excited state properties of the rare earth metals