South Africa’s biggest forum. Discuss, discover, and connect with thousands of members.
But there is no fun in thatI would say just list it alphabetically by user.
I get you, but this is a support group, not a competition.But there is no fun in that![]()
Cannot get that to work with PHP - looking at other ways now.But for the exported image to use on this thread, just alphabetical I think.
Rounding error or wrong calc?@Thor it seems the percent progress calculation is out?
$user_stats['starting_weight'] - $user_stats['current_weight'])/($user_stats['starting_weight'] - $user_stats['goal_weight'])
On the spreadsheet it's formatted as a percentage. So on your table you need to multiply by 100Rounding error or wrong calc?
This is what I use (from the excel sheet):
Code:$user_stats['starting_weight'] - $user_stats['current_weight'])/($user_stats['starting_weight'] - $user_stats['goal_weight'])
AhaOn the spreadsheet it's formatted as a percentage. So on your table you need to multiply by 100
Make the leader board page accessible without logging in?Fixed
Code:SUM(((user_stats.starting_weight - user_stats.current_weight) / (user_stats.starting_weight - user_stats.goal_weight))*100)
The leaderboard now highlights your place in the world and it ordered by the progress %
(The progress % is not ideal yet ot rank by, because my progress barriers might be very different than yours. Any math guys in the house that want to create an algorithm I can implement for us?)
View attachment 774866
Not a bad idea (but I have a lot more kilos to lose so I will win becase for me to go from 140 to 120 is not as much as one guy going from 120 ro 100 and that is very different than 100 to 80.Amazing work Thor - well done.
Perhaps in order of grams lost - most will be aiming for more or less a kg a week?
I appreciate it!Amazing work Thor - well done.
ThanksPublic MyBB Leaderboard
erikthiart.com
BoringThe knowledge that you accomplished your goal. And the resolve that you might accomplish your next one.
