Quote:
Originally Posted by p45cal
I've managed, using Power Query (green columns below), to get the rankings for week 24 to tally with your expected rankings in columns N:O :
Attachment 19993
I've done this by including the missing teams ( par & udi) rank values from their most recent rank values before week 24 (from week 23 in this case):
Attachment 19994 |
If you do that then you would be excluding their result obtained in week 23 which then would lead to wrong rank value and thus possibly wrong ranking if there are teams close to them.
Quote:
Originally Posted by p45cal
However, with week 29, when the postponed par/udi fixture was played, there are 2 fixtures each played by udi & par:
Attachment 19995
Here, par and udi have both taken part in 2 fixtures each in week 29, you can see that cells BJ283:BJ284 are blank because it's taken account only the most recent (last) fixtures' rank values for those 2 teams when calculating ranking. I see you've got the same ranks (20 and 13) for week 29 when there are in fact different rank values which would alter their ranks. |
Yes, as I explained some weeks have more than 10 matches. I purposely did that. The reasons for that are explained in my previos comment.
Quote:
Originally Posted by p45cal
How did you go about assigning those ranks/positions?
|
I obtained those ranking with my built table. It's flawless but very time consuming for massive data and almost impractical. I'd be happy to share a basic version on here if you would like.
Also, please note that 'par' were given points penalty that season and were deducted points at different times so if you happen to calculate their points and see different points tally to mine then that would be the reason. However, Udi's point tally should come out same as mine.
01-07-2024, 08:21 PM
Similar Threads
Calculate a Date
Windows 11 
Office 2021
Threaded Mode