PowerPivot Temperature Mashup Pt 2

(See http://powerpivotpro.com for more PowerPivot content.) Using PowerPivot to build a report that lets users "slice" sales data by the temperature range being experienced by customers on the date of the sale, at the location of the sale. Mashups like that - where data from a corporate data warehouse is "mashed together" with data from another source that would never be found in a corporate db - are one of the strengths of PowerPivot.