The Dashboard Spy

May 17, 2009

Gasoline Prices Dashboard

Filed under: Dashboard Screenshots — Tags: , — dashboardspy @ 2:35 pm

Excel web query was used in this business dashboard to display and track gasoline prices from AAA’s Daily Fuel Gauge Report.

Excel web query powers this fuel price report dashboard

Excel web query powers this fuel price report dashboard

Kaylan Verma (myxcelsius.com) is the creator of this dashboard and had this to say:

I used Excel Web Queries connected to AAA data. The data is being pulled from http://www.fuelgaugereport.com/. The IQY files were modified to pick up parameters from certain cells and those cells were dynamically changed by the List Box input. So when the user clicks on a state from the list box, it inserts the state value in the destination cell which is linked to the parameter of the Web Query. The web query is set to refresh when there is a change in the parameter cell.

The web query results were mapped to certain cells which make up the source data for the charts. I had to use Lookups since the web query had a state abbreviation in it.

Advertisements

Create a free website or blog at WordPress.com.