Feverish wrote: Feverish wrote: reubee wrote:
My geekdom had the following (and an excuse to hit the code button to get alignment).
Being by position, you want the lower number in the Weighted Position column.
What I realised is that if you sum the weighted positions as it stands at the beginning of this season and divide this number by 0.3, you can then simply add this years position to that number and the relative ranking will be maintained. So a little bit easier to figure out what needs to happen this year as you just need to look at the difference between the two numbers and round up to see how many positions ahead you need to be.
Hence with Waterside (5.5) and Petone (7.8), Petone needs to beat Waterside by 3 positions to overtake them.
Similarly Wellington (3.5) and Petone (7.8), Petone needs to beat Wellington by 5 positions to overtake them.
Team |2022|2023|2024|2025|2026|Weighted|Divide
| 10%| 15%| 20%| 25%| 30%|Position|by 0.3
-----------------+----+----+----+----+----+--------+-------
Waterside Karori | 1 | 1 | 2 | 4 | ? | 1.65 | 5.50
Wellington Utd | 3 | 2 | 1 | 1 | ? | 1.05 | 3.50
Petone | 4 | 4 | 3 | 3 | ? | 2.35 | 7.80
PN Marist | 2 | 3 | 4 | 5 | ? | 2.70 | 9.00
Agree
Not sure how people are calculating and getting high weighted averages as being good
Your 2023 is wrong - petone are 3rd. Thought you had something wrong but didn’t know it was the table
Thanks, so with that correction ...
Petone need to beat WK by 2 positions or WU by 4 positions.
Team |2022|2023|2024|2025|2026|Weighted|Divide
| 10%| 15%| 20%| 25%| 30%|Position|by 0.3
-----------------+----+----+----+----+----+--------+-------
Waterside Karori | 1 | 1 | 2 | 4 | ? | 1.65 | 5.50
Wellington Utd | 3 | 2 | 1 | 1 | ? | 1.05 | 3.50
Petone | 4 | 3 | 3 | 3 | ? | 2.20 | 7.33
PN Marist | 2 | 4 | 4 | 5 | ? | 2.85 | 9.50