It's job done and magic returned to the world, the Shiny Rod disintegrates and returns to the skies and becomes the Big Dipper once again. The furtherest star in the Big Dipper, Dubhe, is 124 lightyears from the Earth (or 1.173e+15km).
T = 1.173e+15km/9s
= 1.30333333e17/299792458
= 434745203 C
Final Results
Shiny Rod becomes the Big Dipper = 434745203 C
