Help building a database for athlete loading

Joined
Nov 21, 2016
Messages
37
Hi all,

This is my first time posting so not sure how this goes.

Basically, I am creating an athlete monitoring database and need to give individual players specific thresholds. I have graphs showing player load during a week, and on the graph i would like to put these individual threshold on the graphs to the specific athletes given 'bar'. Is there a way of putting these into the graph fast?

Also, players have an individual absolute maximum speed. Each session of training they have a maximum speed they achieve. I have their individual absolute maximum speed on a control panel is there a formual as to which i can do a Vlookup the absolute of a player against the sessions max speed and gain a percentage difference between the two?

Not sure if i have explained this well sorry!

Cheers and thank you for the help
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Forum statistics

Threads
1,216,099
Messages
6,128,820
Members
449,469
Latest member
Kingwi11y

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top