Google Sheets KPI Dashboard with Filter & Z-Scores | DSMStrength

[@mattinbc007]

Dave, this was great. Quick question: if some athletes have less testing data, how would I manipulate the Z-Score formula so that it is not calculating a score based on empty cells and messing up the scale of my graph?

[@DSMStrength]

Hey Matt first thanks for checking out the video. For the z-score they are definately more powerful the more data you have since it is a measurement of how many standard deviations away from the mean, so having a true measurement of what the mean actually is helps. If you do not have a lot of data yet you could just set what the 0 50 and 100% values are and calculate off of that. For example if 100% squat for your group was 100kg then your athlete squatted 65 they would get 65 points