Green's Functions and Infinite Products: Bridging the Divide