I need to take a google sheets (https://docs.google.com/spreadsheets/d/e/2PACX-1vQNYtmgOxV2OCNZPwjXPrksNsZL_Ymvld51MKnoVU6vjql_pRgC3Ywq4A0coVx34nsUQz2S3y1f5r-b/pubhtml) and display it in a user-friendly way. I'll be taking from a few sites for the final product:
From this site: https://goo.gl/nf6tTV
The overall look is nice. Also, can switch between full view and simplier view (classic leaderboard click here vs tv leaderboard click here)
From this site: https://goo.gl/nkyyGP
This one has two charts next to each other. I do not want that, just 1 chart like the first site. However, you can sort through this one by filters. They have a dropdown for divisions (which on the spreadsheet I provide are the different tabs at the bottom and they have a list of event (named WODs 1,2,3 etc) which on my spreadsheet would correspond to the 3 columns after the Points column. On mobile the list of event shows as a dropdown as well. I'd like it as a dropdown on mobile and desktop.
And finally from this site: https://goo.gl/o7nEcs
On mobile you can see you can click on the name and a dropdown with info appears. So the main display is Rank, Name, and Point and when you click it, it displays the rest of the information. In my case, that is the 3 columns after the Points column.
Finally, I should be able to create a new page simply when creating a new google sheet.