Multi-scale energy systems modeling of the renewable energy transition