Group scores mismatch from Top Groups page and individual Group's pages

Started by pauldunn

LociOiling Lv 1

Just for penance, I did fresh screen-scraping for Go Science, Gargleblasters, and Contenders in a new spreadsheet.

I used the spreadsheet formula below to exclude beginner puzzles in this version. Prior versions relied on manually deleting the rows for beginner puzzles.

This method produced the same "screen scraped" totals shown above for the three groups in question.

The formula below says "if the puzzle description does not contain "Begin" (an error) set the value to the puzzle score, else set it to zero".

=IF(ISERROR(FIND("Begin";A1));D1;0)

LociOiling Lv 1

Good news, sort of - this time the rankings at least appear to be in the correct order.

My screen-scraped results for the Russian Team and the Hun-Magyar Csapat match the
numbers shown on the Groups page.

Otherwise, still a mess. The scores on the Groups page for the other 9 groups
don't match my results. None of scores on the Groups page matches the score on
the corresponding individual group page.

But at least we have good rankings at the moment.

Rank	Group	Global Score	Individual Group Page	Top – Individual	Screen Scraped Scores	Top – SSS	Individual – SSS
#1	Go Science	3304	3333	-29	3183	121	150
#2	Anthropic Dreams	3092	3115	-23	3085	7	30
#3	Beta Folders	3052	2914	138	3065	-13	-151
#4	Gargleblasters	2559	2649	-90	2396	163	253
#5	Contenders	1489	1216	273	1426	63	-210
#6	Marvin's bunch	1097	975	122	1079	18	-104
#7	L'Alliance Francophone	654	783	-129	633	21	150
#8	Void Crushers	580	560	20	551	29	9
#9	Hun-Magyar Csapat	383	282	101	383	0	-101
#10	Russian team	309	355	-46	309	0	46
#11	Hold My Beer	84	181	-97	78	6	103

Bruno Kestemont Lv 1

It doesn't match any more

				
Rank	Group	Global Score	Individual Group Page	Overall
#1	Go Science	3474	3459	2759
#2	Beta Folders	3341	3212	2504
#3	Anthropic Dreams	3222	3291	2655
#4	Gargleblasters	2535	2516	2166
#5	Contenders	1852	1864	1086