Excel dashboard for gymnastics scores

[Dave T]

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

[Steve Kunkel]

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?

[Purfleet]

Lots of good stuff over at https://www.myonlinetraininghub.com/blog, worth a look

[Dave T]

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

[Steve Kunkel]

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.