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.

2 Comments »

  1. Though it truly is known as some sort of “slot bonus”, the bucks of which they give
    you can be used almost all in the course of their own Casino.

    Occasionally the particular online Casinos will request a player
    in the event that he could be staying at your resort of course, if these are not necessarily they may
    consult if you want to this is simply not a
    great offer you of any free area, although many people
    think it is right up until they have a look at every day and
    have to pay the $200 space bill.

    Comment by online Casinos — July 9, 2013 @ 4:40 am

  2. As the outdated declaring is going it will require cash to generate funds, along with in order to acquire a new amount on the Online Casino money you
    are going to ought to be sensible. This amenities are generally quite a few,
    the particular buy-ins often high and the practical knowledge memorable.

    Comment by Online Casino — July 9, 2013 @ 7:05 am


RSS feed for comments on this post. TrackBack URI

Leave a comment

Blog at WordPress.com.