Simple Athletics Database - Need Google Sheets Developer to create Individual Athlete Improvement Graphs
Budget: $15 – $25 USD
Seeking a Google Sheets expert: I have a simple athletics database. Currently, it is two sheets in Google Sheets.
One sheet is "Efforts" and has lists of names and dates on which athletes recorded marks and times in their training.
On the other sheet, those efforts are selected into lists for "Leaders" in each category. I use the Leaders sheet so that athletes can be inspired to improve each mark.
I would like to create at least a third "Athlete" sheet which displays an athlete's individual improvements, and bests (PRs--personal records.) The most challenging part here is to use the date field and a chart or sparkline graphic to follow improvement across months and perhaps years.
Here is a link to view the database as it currently exists:
https://docs.google.com/spreadsheets/d/1yDbCXFmSIp_FOkm015wu0AzJZUQLiwB58awyxpalnCU/edit?usp=sharing
Interest in athletics or track & field is a plus.
Thank you for reading.
Brian
One sheet is "Efforts" and has lists of names and dates on which athletes recorded marks and times in their training.
On the other sheet, those efforts are selected into lists for "Leaders" in each category. I use the Leaders sheet so that athletes can be inspired to improve each mark.
I would like to create at least a third "Athlete" sheet which displays an athlete's individual improvements, and bests (PRs--personal records.) The most challenging part here is to use the date field and a chart or sparkline graphic to follow improvement across months and perhaps years.
Here is a link to view the database as it currently exists:
https://docs.google.com/spreadsheets/d/1yDbCXFmSIp_FOkm015wu0AzJZUQLiwB58awyxpalnCU/edit?usp=sharing
Interest in athletics or track & field is a plus.
Thank you for reading.
Brian
Related categories:
Google Sheets