Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-14-2021, 09:32 PM
Dave T Dave T is offline Excel dashboard for gymnastics scores Windows 7 64bit Excel dashboard for gymnastics scores Office 2013
Advanced Beginner
Excel dashboard for gymnastics scores
 
Join Date: Nov 2014
Location: Australia
Posts: 66
Dave T is on a distinguished road
Default Excel dashboard for gymnastics scores

Hello All,



Might not be the right place to post this question, but I am hoping someone can point me in the right direction.

My daughter competes in Women's Artistic Gymnastics (bars, beam, floor and vault).
She has been competing for quite a few years now.

I would like to be able to enter the scores from the various competitions she has done over the years in an Excel workbook and view her progress.

Does anyone know of an Excel workbook that has a dashboard where various years or improving performance could be entered and viewed.

Regards, Dave T
Reply With Quote
  #2  
Old 04-15-2021, 06:43 AM
Steve Kunkel Steve Kunkel is offline Excel dashboard for gymnastics scores Windows 10 Excel dashboard for gymnastics scores Office 2019
Advanced Beginner
 
Join Date: May 2019
Location: Seattle area
Posts: 77
Steve Kunkel is on a distinguished road
Default

You might try a google search for "free excel dashboards." And/or start entering the data into a sheet, then post the sheet so people can see how the data is formatted. I'm guessing there would be 4 components (the areas you lists)? Is it like one score per week? Scale of 1-10?
Reply With Quote
  #3  
Old 04-15-2021, 06:59 PM
Purfleet Purfleet is offline Excel dashboard for gymnastics scores Windows 10 Excel dashboard for gymnastics scores Office 2019
Expert
 
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default

Lots of good stuff over at https://www.myonlinetraininghub.com/blog, worth a look
Reply With Quote
  #4  
Old 04-18-2021, 04:39 PM
Dave T Dave T is offline Excel dashboard for gymnastics scores Windows 7 64bit Excel dashboard for gymnastics scores Office 2013
Advanced Beginner
Excel dashboard for gymnastics scores
 
Join Date: Nov 2014
Location: Australia
Posts: 66
Dave T is on a distinguished road
Default

Hello All,

Sorry about the delay in posting back (competing with gamer son for access to our home computer).

I have realised that from the responses so far that I should have attached a workbook with my data.
I have removed any personal information, except for the scores. In some of the earlier scores I only saved data relevant for my daughter (Gymnast A), so ranking for each element and overall ranking is obviously wrong.

I my searches I have not found much on a dashboard for an individual gymnast or even a team where you can drill down to the gymnast level.

An interesting dashboard I found was produced by JKJL Excel Solutions produced for the Washington Huskies https://www.jkjl.com/projects

So far, all except one of the competitions my daughter has participated in have been individual competitions. She has only competed in one team competition, which is why I have not done any work on say the top three scores of the clubs competing in a specific competition.

I hope this helps with people pointing me to an appropriate site.

I have never used much of the newer features as in the Washington Huskies example, or even produced a dashboard, so if anyone can modify my attached workbook I would appreciate that.

Regards, Dave T
Attached Files
File Type: xlsx Dashboard for Gymnastics Scores.xlsx (33.8 KB, 18 views)
Reply With Quote
  #5  
Old 04-20-2021, 02:12 PM
Steve Kunkel Steve Kunkel is offline Excel dashboard for gymnastics scores Windows 10 Excel dashboard for gymnastics scores Office 2019
Advanced Beginner
 
Join Date: May 2019
Location: Seattle area
Posts: 77
Steve Kunkel is on a distinguished road
Default

It occurs to me that I'm at a loss for recommendations. I will say that it appears whoever made the Huskies sheet utilized 'sparklines.' Also note: If you right-click the tabs, and choose 'unhide' you can get a peek at their raw data. It looks different from yours, but will probably make sense to you. Sorry I'm not more help.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel dashboard for gymnastics scores Interactive Quiz with Scores at the end? VisionAvenger PowerPoint 10 03-08-2016 05:40 AM
Exporting quiz scores from powerpoint to excel spreadsheet/word rjagile PowerPoint 1 02-08-2016 02:26 PM
Excel Dashboard: Attempt to integrate Boxplot (clusted bar chart) into KPI Display (stacked bar) Confused_Robin Excel 0 11-02-2015 12:30 PM
Excel dashboard for gymnastics scores Scores returning ranked results TerryStevenson Excel 1 09-16-2013 12:20 PM
Keeping scores in ppt, please please help piper7971 PowerPoint 0 07-24-2010 07:10 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:54 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft