Accurately computing excited states and lattice dependent tight-binding models from first principles simulations