So I’m working on the Module for Progress Evolution of Technology.
Ok. So I have Global Properties for Prestige “Score”. Blue, Green, Red, White, yellow. PrestigeB, PrestigeG, … And the “score” for each could be between 0 Prestige to 17 (or 20+ VP)…
Who ever is Highest Score gets 10 VP, 2nd gets 6, 3rd, gets 3 VP, 4th gets 1 VP, Last gets 0. And Ties are half round down. i.e If Blue and Green are tied for first 10+6/2=8 VP. If there is a 3 way tie for 2nd, 3rd, 4th… 6+3+1=10/3… 3 VP each. (i.e. My score only gets me VP if I’m better relative to everyone else.)
So rather than trying to make a filter sort, I realized that with only 5 variables, that it is easier to just calculate each players relative score compared to the other 4. I made a prototype for each players’s final victory points broken down from the various scoring sources…
Step 1. Make a prototype for each player’s score board.
2. On the Prototype made a Calculated property to count PrestigeWins i.e. if (PrestigeX>PrestigeG, 1,0) + if (PrestigeX>PrestigeR, 1,0)+… (Where PrestigeX is one player’s Prestige Score.)
3. Repeat for Prestige Losses.
4. Then make a CP for the PrestigeScore= If(Wins==4, 10 VP, (If wins==3 && Losses==0, 8 VP , If (Wins==3 && Losses==1, 6 VP (2nd place)…
4 wins= 1st. (10)
3 wins & 0 losses = tie for first (8)
3 wins & 1 Loss = 2nd (6)
2 wins & 0 Losses = tie for 1s, 2nd, 3rd (6)
2 wis & 1 Loss == tie for 2nd 3rd
2 wins & 2 losses = 3rd… etc.
And because it is limited to 5 players and some of the results over lap I could even make those an or statement in the Calculated property.
It took me a few days to realize that I don’t need to build a filter sort, since there are only 15 possible results and most overlap. So really only about 7 possible win/loss results.
I hope that helps the next VP score creator.