Results 1 to 4 of 4

Need help with how to create/present a dashboard to consolidate multiple event data-sets.

Threaded View

  1. #1
    Registered User
    Join Date
    12-30-2019
    Location
    Toronto
    MS-Off Ver
    365
    Posts
    10

    Need help with how to create/present a dashboard to consolidate multiple event data-sets.

    I am trying to present an overview of historical data from previous racing events to guide strategy in a current race.
    I currently have strategy data from 60 previous events, this will grow as the season progresses.

    Fixed parameters:
    Race time - 2 hours (there are 4 hour races to be looked at seperately, they are usually 2 of a 10 race season)
    Cars must stop at least once to change driver and refuel.

    I would like to present the data in 5 min blocks from 0:00:00~0:05:00 to 1:55:00~2:00:00.

    I am trying to show on 1 consolidated dashboard in what time block the car came into pit, under what track condition (green or yellow), in what position was the car before and after pit, did the driver change during the pit-stop and if possible to show if the pit-stop was a "dive-in" which means the track condition changed from green to yellow immediately after the pit-stop.

    I have a sample workbook available the size is 48kb, total 8 sheets 6 2hr races, 2 4hr races. Is this too big to post?
    Attached Files Attached Files
    Last edited by Charlie_B; 03-21-2024 at 01:01 PM. Reason: Adding workbook

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Need to consolidate and SUM multiple data sets
    By SgtSaggy in forum Excel General
    Replies: 21
    Last Post: 02-10-2023, 05:08 PM
  2. Replies: 4
    Last Post: 08-27-2019, 02:40 PM
  3. How to present various sets of data
    By rayted in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-01-2018, 07:28 AM
  4. Replies: 1
    Last Post: 03-02-2015, 07:43 AM
  5. create a dashboard or new way to present the data
    By SAMEEP in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-20-2013, 08:56 AM
  6. VBA to fill down for multiple data sets, then consolidate data
    By franklin225 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-07-2012, 02:37 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1