Awesome Table

Awesome Table is a web app that has built in analysis tools to provide visual representation of data. This allows to quickly filter and analyze how each ensemble has performed. This data can then be exported into Excel spreadsheets for more specific analysis. It is very simple to setup:

  1. Navigate to awesome-table.com.
  2. Login to Google using the same account in which you created your Google Sheet.
  3. Click the green plus sign labeled Blank under Create a new view.
  4. Select a spreadsheet from your Google Drive.
    1. Project Name is the name of the Awesome Table.
    2. Select a sheet is the specific tab within the Google Sheet. In our case, Form Responses 1.
    3. Range are the cells you want included from the Sheet in 4.2.
    4. Click Create.
  5. In the Right Hand Column, there should be several options:
    1. Data Source is all the information we entered in Step 4.
    2. View Configuration
      1. Change the Visualization type to Advanced summary.
      2. Change Layout to Filters, chart.
    3. Formatting - No changes are necessary.
    4. Advanced parameters - No changes are necessary.
  6. Click Update View.

Now, you may need to do some editing to your Google Sheet to make your Awesome Table work best for you. In the second row of the sheet you are analyzing, you may want to label specific columns based on the Documentation Google provides. As a brief summary,

  • StringFilter filters columns containing string text. This shows up as an empty text box.
  • NumberRangeFilter filters columns containing numbers. This shows up as an adjustable number line.
  • CategoryFilter filters columns containing a list of similar values. This shows up as a pull-down menu.
  • DateFilter filters columns containing date data. This shows up as an adjustable number line. This is adjustable based on the Date format in filters as you set up your table above.
  • csvFilter filters columns containing comma separated values. This shows up as a pull-down menu.
  • NoFilter does not filter the table using this column.
  • Hidden does not include the data from this column in the table.