I made a weight recording app. But I want employees to know who ranks each week.
Please help an expert please advise me.
Divided into 7 week sequences, each week will display a sequence.
such as
week 1
Mr. A is fat 41.24
Mr. B is fat 35.0
Week 2
Mr. A fat 35.24 (fat reduced by 6)
Mr. B Fat 32 (Lower Fat 3)
Week 3
Mr. A fat 30.24 (fat reduced by 5)
Mr. B fat 24 (lost fat 6 )
Week 2 Mr. A must be 1st and Mr. B 2nd // In the 2nd week Mr. B must be 1st and Mr. A 2nd.
The first image is the one that the user calculates in Excel but wants in the life app to show their weekly ranking.
In the app, want to display the order .
Week 1 = Rank 1
Week 2 = 2nd place
Week 3 = 5th place
Do I have to make the columns separate weeks?