Hi Adam, Thank you for sharing this dashboard. It has been extremely helpful to me and my program. I was wondering if you knew how to edit the overall score formula to an individuals overall score (a score comparing the individual's current attempt to all past attempts by the individual). For reference, the traditional formula measuring overall score that you provided is: =IF(E2="","", 100*(E2-MIN(E:E))/(MAX(E:E)-MIN(E:E))), my best attempt at editing this formula to only evaluate the individuals past attempts is: =IF(E2="","", 100*(E2-MINIFS(E:E,A:A,INDEX(A:A,MATCH("Name",A2,0))/(MAXIFS(E:E,A:A,INDEX(A:A,MATCH("Name",A2,0))-MINIFS(E:E,A:A,INDEX(A:A,MATCH("Name",A2,0)))))))). However, the result from this formula is only multiplying the value of E2 by 100 and providing that as the value. Any insight would be greatly appreciated. Thank you
Hi Luke. This is a great effort, and thank you for the great explanation of your issue. You don't need to use INDEX or MATCH. Good adjustment to MINIFS and MAXIFS. You're very close. I'm assuming your athlete names are in column A. If this is the case, something like this should work: =IF(E2="","", 100*(E2-MINIFS(E:E,A:A,A2))/(MAXIFS(E:E,A:A,A2)-MIN(E:E,A:A,A2))) Let me know if you have any other questions. Thank you!
@@AdamVirgile34 Thank you Adam that did the trick! We've been using the jump mat a lot with our guys to measure readiness, an individual score for each attempt will make our lives a lot easier!
Hi Adam, Thanks for your amazing tutorials. One question:starting this video I see that you delete the 5extra metrics column and also the first row from the previous one(containing: CMJ TRIAL1,CMJ TRIAL2, CMJ TRIALS,ETC…); now building my sheet if I delete the extra metrics and the first row,leaving the same formulas,I have error #REF! I will paste the formula from cell AB2 using the same template : =IF(J2="";""; IF(INDEX(Admin!$F:$F;MATCH(#REF!;Admin!$E:$E;0))=TRUE; 100-100*(J2-MINIFS(J:J;$E:$E;$E2))/(MAXIFS(J:J;$E:$E;$E2)-MINIFS(J:J;$E:$E;$E2)); 100*(J2-MINIFS(J:J;$E:$E;$E2))/(MAXIFS(J:J;$E:$E;$E2)-MINIFS(J:J;$E:$E;$E2)))) How to salve this error? Thanks for your help
Hi Adam,
Thank you for sharing this dashboard. It has been extremely helpful to me and my program. I was wondering if you knew how to edit the overall score formula to an individuals overall score (a score comparing the individual's current attempt to all past attempts by the individual). For reference, the traditional formula measuring overall score that you provided is: =IF(E2="","", 100*(E2-MIN(E:E))/(MAX(E:E)-MIN(E:E))), my best attempt at editing this formula to only evaluate the individuals past attempts is: =IF(E2="","", 100*(E2-MINIFS(E:E,A:A,INDEX(A:A,MATCH("Name",A2,0))/(MAXIFS(E:E,A:A,INDEX(A:A,MATCH("Name",A2,0))-MINIFS(E:E,A:A,INDEX(A:A,MATCH("Name",A2,0)))))))). However, the result from this formula is only multiplying the value of E2 by 100 and providing that as the value. Any insight would be greatly appreciated. Thank you
Hi Luke. This is a great effort, and thank you for the great explanation of your issue. You don't need to use INDEX or MATCH. Good adjustment to MINIFS and MAXIFS. You're very close. I'm assuming your athlete names are in column A. If this is the case, something like this should work:
=IF(E2="","", 100*(E2-MINIFS(E:E,A:A,A2))/(MAXIFS(E:E,A:A,A2)-MIN(E:E,A:A,A2)))
Let me know if you have any other questions. Thank you!
@@AdamVirgile34 Thank you Adam that did the trick! We've been using the jump mat a lot with our guys to measure readiness, an individual score for each attempt will make our lives a lot easier!
@@lukeglancy7870 fantastic!!
Hi Adam,
Thanks for your amazing tutorials.
One question:starting this video I see that you delete the 5extra metrics column and also the first row from the previous one(containing: CMJ TRIAL1,CMJ TRIAL2, CMJ TRIALS,ETC…); now building my sheet if I delete the extra metrics and the first row,leaving the same formulas,I have error #REF!
I will paste the formula from cell AB2 using the same template :
=IF(J2="";"";
IF(INDEX(Admin!$F:$F;MATCH(#REF!;Admin!$E:$E;0))=TRUE;
100-100*(J2-MINIFS(J:J;$E:$E;$E2))/(MAXIFS(J:J;$E:$E;$E2)-MINIFS(J:J;$E:$E;$E2));
100*(J2-MINIFS(J:J;$E:$E;$E2))/(MAXIFS(J:J;$E:$E;$E2)-MINIFS(J:J;$E:$E;$E2))))
How to salve this error?
Thanks for your help