Conquer Club

Boring Stuff

Abandoned challenges and other old information.

Moderator: Clan Directors

Forum rules
Please read the Community Guidelines before posting.

Automated F400 2

Postby Leehar on Sat Mar 22, 2014 3:27 pm

Yeah, the dataset I uploaded onto the dropbox is from a while ago, so it probably hasn't been updated since early december. Ice should have the latest version.

But you do make a good point, it is going to be very tough to reach a perfect match, so we just need to make sure we reach a close approximation of what we're looking for & remove any significant deviations.

Is there any way to match what we have in the database to the F400's dataset without a manual line-by-line analysis?
The crucial elements are the 2 clans scores, and the date?
show
User avatar
Colonel Leehar
 
Posts: 5491
Joined: Fri Mar 06, 2009 12:12 pm
Location: Johannesburg

Re: Clan Database with Labels

Postby bigWham on Sat Mar 22, 2014 3:51 pm

Leehar wrote:Yeah, the dataset I uploaded onto the dropbox is from a while ago, so it probably hasn't been updated since early december. Ice should have the latest version.

But you do make a good point, it is going to be very tough to reach a perfect match, so we just need to make sure we reach a close approximation of what we're looking for & remove any significant deviations.

Is there any way to match what we have in the database to the F400's dataset without a manual line-by-line analysis?
The crucial elements are the 2 clans scores, and the date?


is it quite messy to match the actual file you are using, to say the least. however i can much more easily export a file from the db in your format and try that for comparison.
User avatar
Colonel bigWham
Webmaster
Webmaster
 
Posts: 2869
Joined: Mon Aug 26, 2013 12:08 pm

Re: Clan Database with Labels

Postby bigWham on Sat Mar 22, 2014 5:36 pm

ok, so i just exported all clan wars from the current live database, in the file format of the f400 tool.

the data is below. this is only finished wars with more than 40 games that are not in a league.

the result seems quite different again, and not especially correct.

this is with all default settings, the rating date set to today. just plopping the data in and hitting go.

can anyone see what is wrong here? my thinking is that either the data below is wrong, or some data is missing or something. how does this match to what you are using?

Rank Name Rating
1 PACK 1320
2 ACE 1308
3 TOFU 1302
4 IA 1292
5 TSM 1251
6 KORT 1226
7 OSA 1219
8 LOW 1169
9 AFOS 1159
10 MD 1152

---------------------------

THOTA Bushwhaker 32 10 09/06/07
ID THOTA 47 53 05/16/08
G1 AoD 23 22 08/11/08
THOTA G1 41 19 09/01/08
TSM LOW 34 26 09/02/08
THOTA TheRegula 41 19 10/26/08
ID AoD 37 22 11/13/08
SkyForce LEG 33 27 12/11/08
EternalEm LEG 23 27 03/06/09
AoD SkyForce 23 22 04/16/09
THOTA LOW 32 28 07/09/09
SkyForce ID 24 30 08/06/09
BlackShee Outlaws& 24 22 08/13/09
LOW EMP 36 24 10/19/09
DivineDom Outlaws& 33 27 11/26/09
TLW LOTZ 31 29 12/09/09
EMP Nem 41 23 12/17/09
TOFU MYTH 30 11 01/02/10
EMP AoC 38 22 01/07/10
KORT TheBrethr 38 17 01/25/10
BlackShee AoD 57 63 02/28/10
ID IA 20 22 03/02/10
EternalEm DivineDom 32 28 03/09/10
G1 Outlaws& 28 22 03/13/10
GR DYN 32 24 03/23/10
Nem BlackShee 38 22 03/26/10
MM Snipers 32 13 03/28/10
THOTA TSM 41 39 04/04/10
LEG Outlaws& 33 27 04/09/10
MM ProjectFi 33 27 04/22/10
FOED BlackShee 37 23 04/28/10
Nem BlackShee 31 17 05/02/10
AoC IA 21 27 05/12/10
KORT G1 32 16 05/18/10
AoD TOFU 18 42 05/23/10
FOED LOTZ 36 24 06/04/10
VDLL Left4Dead 25 22 06/25/10
ID FOED 31 29 07/18/10
TheDarkK DYN 33 27 07/21/10
THOTA Nem 21 20 07/21/10
TheBrethr TLW 38 22 07/28/10
MYTH FOED 29 31 08/08/10
LEG BlackShee 43 37 08/23/10
LOTZ TheBrethr 21 39 08/26/10
Knightsof Left4Dead 15 28 09/21/10
TOFU AoC 25 16 09/23/10
EMP TLW 47 13 10/04/10
LEG MYTH 46 44 10/10/10
FOED AoC 22 38 10/21/10
MM BlackShee 29 31 10/28/10
DB AoD 21 20 10/31/10
ID TheBrethr 28 32 10/31/10
BlackShee TIME 33 27 11/03/10
Soldierso EMP 19 41 11/06/10
Nem FOED 36 34 11/07/10
THOTA LOW 33 27 12/01/10
TIME TheBrethr 28 32 12/15/10
LEG Nem 30 40 02/04/11
ID EMP 18 23 02/15/11
OSA AKA 25 17 02/23/11
TheBrethr BlackShee 39 21 02/26/11
DBC RA 26 34 02/28/11
GR MM 28 32 03/04/11
Soldierso LOTZ 24 17 03/05/11
G1 AFOS 20 25 03/06/11
OSA DB 20 21 03/07/11
TOFU TNC 40 10 03/07/11
RA TNC 23 18 03/08/11
AoD FOED 14 29 03/18/11
PACK KOA 27 14 03/18/11
DYN BlackShee 22 38 03/22/11
OSA TNC 18 23 03/30/11
TLW DBC 30 31 04/04/11
DBC OSA 16 25 04/04/11
OSA WelshDrag 32 9 04/06/11
AKA PACK 18 42 04/08/11
RA SoH 19 23 04/09/11
PACK WelshDrag 31 12 04/19/11
AKA PIG 19 24 04/20/11
VDLL AoC 12 29 04/20/11
GR LOTZ 29 12 04/21/11
KORT THOTA 33 27 04/24/11
TSM TNC 33 8 04/25/11
LEG GR 29 12 04/27/11
IA RA 30 11 04/30/11
TLW Nem 18 23 05/01/11
DYN G1 15 26 05/01/11
WildGeese TNC 29 14 05/02/11
IA EMP 20 22 05/04/11
OSA LOW 17 24 05/06/11
FOED LOTZ 31 10 05/09/11
1RFG GR 16 26 05/12/11
AFOS MYTH 24 17 05/13/11
Order66 OSA 14 29 05/13/11
TheBrethr MM 29 12 05/14/11
LEG FOED 28 57 05/19/11
KOA SoH 21 27 05/19/11
EMP DBC 32 9 05/22/11
SoH PACK 16 27 05/25/11
WildGeese OSA 21 22 05/29/11
PACK BlackShee 39 21 05/30/11
TFFS ID 24 17 05/30/11
GR PIG 25 18 05/31/11
Nem DB 27 23 06/02/11
TNC 1RFG 23 19 06/10/11
BPB DB 23 18 06/12/11
AoC TFFS 26 15 06/13/11
THOTA BPB 24 17 06/14/11
TSM AFOS 24 17 06/14/11
EMP Nem 30 11 06/14/11
BlackShee OSA 33 27 06/16/11
RA LOTZ 26 15 06/18/11
DYN OSA 35 25 06/20/11
KORT G1 24 17 06/20/11
GR RA 28 13 06/20/11
AKA VDLL 19 22 06/21/11
FOED IA 29 12 06/24/11
KOA GR 27 21 06/26/11
TheBrethr TOFU 19 22 06/30/11
TNC MYTH 27 33 06/30/11
GR PACK 17 26 07/08/11
LOW LEG 24 17 07/15/11
OSA PACK 18 25 07/15/11
LOTZ OSA 18 23 07/18/11
TLW GR 24 36 07/19/11
RA OSA 24 17 07/19/11
OSA GR 18 25 07/21/11
TLW MM 35 25 07/21/11
AKA RA 25 23 08/01/11
GR MYTH 18 24 08/17/11
PIG TNC 28 15 08/26/11
ID G1 22 27 08/28/11
TSM LOW 41 20 08/29/11
AoC THOTA 26 35 09/07/11
TNC DBC 35 6 09/09/11
EMP TOFU 40 21 09/11/11
VDLL OSA 33 28 09/13/11
PIG DB 35 25 09/14/11
TheBrethr LEG 24 17 09/15/11
LEG AoD 38 23 09/17/11
AKA LOTZ 38 12 09/19/11
KORT FOED 39 22 09/19/11
TFFS TNC 26 15 09/21/11
KOA IF 28 21 09/22/11
BlackShee MYTH 23 37 10/02/11
MM WildGeese 27 26 10/15/11
OSA TNC 28 13 10/18/11
MD HH 16 25 10/20/11
1RFG AKA 26 25 10/21/11
BlackShee TNC 25 36 10/26/11
KOA MB 41 10 10/29/11
RA VDLL 30 25 11/04/11
DBC LOTZ 28 23 11/04/11
ID TLW 27 16 11/07/11
DB RA 31 29 11/09/11
TNC 1RFG 23 18 11/10/11
TLW DYN 22 29 11/11/11
PACK IA 28 23 11/12/11
MB TNC 14 39 11/13/11
AKA DBC 27 16 11/16/11
AKA GR 19 22 11/29/11
KOA LOTZ 43 8 11/29/11
OSA TheBrethr 23 18 12/02/11
HH TNC 20 23 12/09/11
TSM THOTA 34 33 12/10/11
1RFG MB 29 12 12/10/11
KORT EMP 37 23 12/11/11
AFOS Nem 32 21 12/13/11
HH MD 20 21 12/22/11
IF OSA 23 18 12/22/11
DBC ID 15 28 12/26/11
1RFG TLW 27 22 12/28/11
TNC LHDD 20 21 12/29/11
LHDD DBC 31 10 01/01/12
TLW TNC 28 25 01/01/12
TNC DB 39 22 01/03/12
PACK MYTH 39 22 01/05/12
HH VDLL 20 21 01/05/12
MB LOTZ 27 26 01/06/12
AoC LEG 28 13 01/10/12
WAR 1RFG 34 15 01/10/12
G1 AoD 21 24 01/11/12
WAR OSA 26 15 01/14/12
TNC MM 26 33 01/14/12
OSA TFFS 35 26 01/16/12
LEG AKA 30 11 01/19/12
TNC LOTZ 140 61 01/22/12
TNC ID 19 22 01/26/12
TFFS AKA 22 19 02/01/12
TNC UnholyRol 44 17 02/03/12
KOA MD 20 23 02/06/12
WAR MB 35 18 02/07/12
TOFU OSA 33 8 02/07/12
TNC RandomHer 31 14 02/10/12
GR 1RFG 27 16 02/19/12
IA TheBrethr 32 29 02/20/12
OTP AKA 28 13 02/24/12
1RFG OSA 19 22 02/24/12
TNC SoH 46 27 02/26/12
HH 1RFG 30 22 03/02/12
DBC MB 54 45 03/03/12
MB HH 21 32 03/04/12
AKA HH 16 25 03/05/12
TNC NaturalBo 69 22 03/09/12
LHDD DYN 28 15 03/19/12
IF AKA 19 24 03/19/12
PIG VDLL 42 19 03/21/12
AKA TNC 18 23 03/24/12
KOA TFFS 28 23 03/27/12
TNC KNT 31 10 04/01/12
OTP TNC 39 22 04/05/12
ID MM 30 20 04/09/12
TFFS DYN 30 31 04/11/12
AoD TFFS 17 28 04/11/12
EMP PACK 23 38 04/13/12
AoC OSA 29 12 04/15/12
KORT TSM 35 25 04/16/12
OSA SoH 23 20 04/20/12
HH TFFS 34 27 04/21/12
1RFG LOTZ 26 23 04/26/12
AKA WAR 20 21 04/26/12
NaturalBo 1RFG 14 35 04/28/12
UM8 DBC 22 21 04/28/12
MB SoH 14 29 04/29/12
RotS MB 18 25 05/01/12
TOFU PIG 33 18 05/05/12
HH OSA 28 33 05/13/12
KOA UM8 29 14 05/14/12
GR AKA 23 22 05/15/12
LHDD MD 23 22 05/18/12
ID WAR 31 22 05/20/12
TNC RotS 41 20 05/22/12
AKA TLW 26 27 05/25/12
TFFS MB 36 19 05/26/12
DB MM 21 27 05/27/12
TNC KOA 24 27 05/29/12
AoC TheBrethr 27 14 05/29/12
LOTZ MB 22 19 05/30/12
OTP TFFS 24 17 06/01/12
FOED VDLL 27 14 06/03/12
DBC TNC 32 78 06/04/12
TNC HH 35 26 06/10/12
TNC LEG 36 25 06/14/12
DBC FISO 33 10 06/14/12
TOFU DYN 30 11 06/17/12
TNC TFFS 53 42 06/19/12
LHDD ID 18 23 06/19/12
OSA PIG 22 19 06/21/12
TLW OSA 20 33 06/22/12
1RFG AoC 16 25 06/29/12
GR TheBrethr 17 24 06/30/12
IA HH 23 18 07/01/12
AKA EMP 14 27 07/04/12
TFFS GR 26 19 07/08/12
FOED TNC 38 23 07/11/12
NaturalBo UM8 11 32 07/12/12
TNC AFOS 16 25 07/12/12
TSM TLW 33 8 07/13/12
RA PACK 7 34 07/14/12
KORT LOTZ 27 14 07/17/12
TNC FISO 47 22 07/19/12
MD KOA 22 19 07/20/12
MYTH BPB 21 20 07/21/12
TOFU SoH 36 5 07/28/12
UM8 LOTZ 30 19 07/28/12
LEG DYN 18 23 08/02/12
TNC GR 56 43 08/02/12
TNC WAR 30 19 08/07/12
FOED OSA 28 33 08/10/12
TNC TFFS 22 19 08/13/12
EMP TFFS 26 19 08/17/12
AKA RotS 27 14 08/20/12
WAR DB 32 16 08/21/12
IF RandomHer 33 8 08/23/12
KOA OSA 20 23 08/28/12
HH WAR 23 22 08/30/12
MB 1RFG 14 27 08/30/12
LHDD GR 21 26 09/05/12
TNC LOW 22 29 09/06/12
TNC AOK 28 13 09/07/12
OSA AKA 24 17 09/09/12
DBC HH 15 30 09/09/12
FALL UM8 32 11 09/10/12
OTP TOFU 23 38 09/10/12
TheBrethr AoC 24 37 09/11/12
IA AFOS 28 33 09/11/12
IF TNC 16 35 09/13/12
KNT NaturalBo 29 12 09/15/12
RET TNC 20 21 09/16/12
EMP MYTH 37 24 09/16/12
LOTZ WAR 19 29 09/17/12
PIG TFFS 48 43 09/18/12
AKA TNC 14 27 09/23/12
PACK ID 37 24 09/25/12
TSM MD 35 26 09/27/12
WAR TLW 28 21 09/29/12
RandomHer SoH 21 20 09/30/12
AOK KNT 18 23 10/02/12
TNC UM8 44 27 10/03/12
PIG FISO 46 14 10/05/12
DYN RotS 24 17 10/08/12
MM LHDD 25 16 10/14/12
GR HH 43 16 10/15/12
GR WAR 22 19 10/23/12
KORT DYN 44 17 10/24/12
FOED FALL 21 20 10/25/12
OSA WAR 32 28 10/29/12
UM8 DBC 41 19 10/30/12
OSA MYTH 18 23 11/01/12
TNC VDLL 25 18 11/02/12
TheBrethr WAR 20 21 11/03/12
FALL HH 27 14 11/04/12
MB AQOH 16 25 11/06/12
PIG DYN 37 23 11/12/12
MM SoH 24 17 11/14/12
RET FISO 27 14 11/17/12
AKA TFFS 20 25 11/19/12
AKA FOED 12 29 11/20/12
FOED TNC 22 19 11/21/12
FISO AKA 17 26 11/21/12
UM8 HH 24 37 11/22/12
RotS KNT 20 28 11/28/12
TNC IF 30 11 11/29/12
TLW TNC 22 39 11/29/12
G1 TNC 22 19 12/04/12
OSA LEG 25 16 12/05/12
LOW ID 22 25 12/11/12
TNC UM8 37 22 12/12/12
MD GR 32 26 12/12/12
TSM AFOS 30 31 12/14/12
TNC AKA 39 22 12/15/12
LHDD HH 20 23 12/16/12
OTP MYTH 34 29 12/16/12
AKA FALL 14 27 12/19/12
AQOH LOTZ 28 21 12/21/12
FALL LOW 30 20 12/22/12
KORT OSA 32 29 12/22/12
TNC MB 296 117 12/23/12
TNC LOTZ 27 14 12/23/12
FOED IF 41 19 12/25/12
HH RET 27 34 12/30/12
FALL 1RFG 26 17 01/06/13
LEG DBC 28 15 01/07/13
TFFS FOED 28 22 01/07/13
EMP AoC 30 31 01/07/13
TOFU PACK 32 29 01/09/13
KORT AoC 22 19 01/14/13
OTP OSA 26 31 01/16/13
OSA FISO 48 13 01/17/13
KNT FISO 23 18 01/23/13
WAR PIG 33 34 01/25/13
GR FOED 25 24 02/03/13
OSA TNC 39 22 02/07/13
HH AQOH 20 21 02/10/13
LEG AKA 23 18 02/20/13
LHDD TNC 25 18 02/26/13
1RFG VDLL 25 16 02/28/13
FISO YoullNev 30 19 03/01/13
OTP DBC 33 10 03/01/13
IA TNC 30 11 03/02/13
TSM OSA 27 22 03/04/13
LOTZ HH 22 27 03/07/13
OSA LHDD 27 14 03/08/13
HH TPD 35 6 03/09/13
UM8 DB 20 29 03/18/13
MM FOED 29 20 03/18/13
GR LEG 27 18 03/19/13
TNC FALL 24 17 03/19/13
UM8 TLW 27 28 03/19/13
1RFG TNC 30 20 03/21/13
MD MYTH 24 17 03/28/13
PIG RA 30 30 03/29/13
FOED MD 32 28 03/29/13
DYN RET 17 24 03/30/13
G1 TFFS 23 20 04/04/13
AFOS AoC 33 26 04/05/13
AQOH YoullNev 41 13 04/07/13
TFFS 1RFG 35 23 04/10/13
AKA FISO 22 19 04/14/13
TFFS LEG 25 18 04/15/13
FALL VVV 35 8 04/16/13
UM8 SoH 21 20 04/17/13
VVV YoullNev 28 13 04/22/13
AQOH ATL 16 25 04/27/13
OSA ID 37 28 04/30/13
PIG IA 25 36 04/30/13
TOFU KORT 31 29 05/02/13
MD 1RFG 117 86 05/03/13
OSA GR 27 18 05/03/13
FALL EMP 23 26 05/07/13
G1 HH 27 24 05/13/13
AKA RET 15 26 05/15/13
FISO VVV 30 13 05/23/13
FOED OTP 26 23 05/27/13
TNC HH 29 14 06/02/13
AQOH VVV 29 12 06/03/13
TNC PACK 22 19 06/04/13
LOTZ FISO 21 28 06/06/13
TFFS OSA 39 35 06/08/13
LEG MB 31 10 06/16/13
TFFS YoullNev 31 10 06/18/13
FALL TSM 24 19 06/21/13
HH RotS 25 16 06/23/13
SoH VVV 28 13 06/23/13
AQOH UM8 21 20 06/24/13
TLW LHDD 19 36 06/25/13
ATL FISO 30 11 06/25/13
TNC FISO 33 12 06/27/13
HH AQOH 20 21 06/27/13
MD YoullNev 53 14 06/28/13
LHDD AKA 28 13 06/29/13
VVV RET 10 31 07/01/13
TFFS VVV 29 12 07/02/13
LHDD OTP 11 30 07/02/13
WAR KNT 22 19 07/06/13
FISO MB 24 17 07/08/13
DB RA 12 29 07/08/13
DB TPD 42 7 07/11/13
ID MB 35 6 07/15/13
AKA KORT 12 29 07/16/13
LOW YoullNev 34 7 07/21/13
RGX TNC 13 30 07/22/13
PIG FOED 39 34 07/24/13
FALL ATL 19 22 07/26/13
TSM LOTZ 30 11 07/27/13
OSA SoH 22 19 07/27/13
IA LEG 28 13 07/29/13
MM PIG 29 32 07/29/13
AFOS TOFU 18 42 07/30/13
HH ATN 30 19 08/02/13
AQOH LEG 21 20 08/04/13
TFFS ATN 30 19 08/05/13
WAR TFFS 20 21 08/08/13
RA TLW 28 13 08/10/13
RotS VVV 23 18 08/13/13
ACE TNC 25 16 08/13/13
VVV TLW 24 31 08/19/13
G1 OTP 21 20 08/21/13
RA PIG 24 17 08/25/13
WAR VVV 31 10 08/26/13
WAR AKA 32 9 08/30/13
AFOS AQOH 22 19 08/31/13
RET HH 19 22 09/01/13
LHDD TFFS 22 19 09/02/13
MYTH TLW 30 11 09/03/13
WAR MM 16 25 09/05/13
RotS DBC 30 19 09/06/13
GR DYN 14 27 09/15/13
ACE TFFS 26 15 09/16/13
TLW ATN 20 41 10/02/13
ID LOW 21 40 10/02/13
KORT TFFS 44 17 10/02/13
ATL RA 21 20 10/08/13
TFFS PIG 21 30 10/10/13
FOED OSA 23 25 10/12/13
VVV DB 13 35 10/16/13
HH LHDD 14 27 10/16/13
FALL RET 23 20 10/22/13
OSA OTP 33 28 10/28/13
DYN TOFU 15 46 10/29/13
VVV VDLL 25 36 10/31/13
SoH FISO 23 18 11/01/13
PACK OSA 34 27 11/07/13
RotS FISO 20 21 11/16/13
TSM AQOH 27 14 11/20/13
TLW RotS 14 27 11/22/13
TSM MYTH 40 21 11/22/13
RGX RET 23 38 11/23/13
LHDD WAR 26 23 12/08/13
RGX TNC 20 21 12/12/13
IA MM 35 26 12/13/13
ATL RA 32 29 12/14/13
ACE AFOS 44 17 12/16/13
OSA G1 32 23 12/18/13
GoN VVV 30 27 12/19/13
FAD ATL 11 50 12/20/13
VVV ATN 15 46 12/20/13
TNC VVV 38 23 12/20/13
UM8 FISO 19 22 12/20/13
FAD DBC 25 16 12/21/13
PACK LHDD 30 11 12/27/13
FOED HH 19 30 12/30/13
GR AOK 78 25 01/01/14
PIG FALL 20 29 01/01/14
AQOH ATL 14 27 01/08/14
OSA KORT 27 34 01/12/14
TFFS RET 21 40 01/15/14
UM8 VDLL 24 27 01/19/14
OSA FALL 35 26 01/20/14
GoN TPD 52 29 01/20/14
GoN FISO 39 42 01/20/14
RGX KNT 30 11 01/24/14
LOW ACE 21 40 01/27/14
OSA DYN 40 21 01/27/14
LEG MYTH 36 25 01/31/14
HDN FISO 14 27 02/01/14
ATN RotS 41 20 02/07/14
TWD VVV 22 19 02/09/14
HH FAD 29 12 02/10/14
TOFU ATL 37 24 02/17/14
AQOH GR 28 33 03/02/14
LOTZ GoN 17 24 03/04/14
PACK G1 36 15 03/05/14
ATL LHDD 19 22 03/05/14
GoN HDN 79 22 03/05/14
User avatar
Colonel bigWham
Webmaster
Webmaster
 
Posts: 2869
Joined: Mon Aug 26, 2013 12:08 pm

Re: Clan Database with Labels

Postby IcePack on Sat Mar 22, 2014 5:54 pm

Hard to compare looking @ this just over the iPhone but I'll try going over and seeing the data list you provided with mine.

I'll also double check by using your data and seeing if it calcs the same
Image

fac vitam incredibilem memento vivere
Knowledge Weighs Nothing, Carry All You Can
Colonel IcePack
Multi Hunter
Multi Hunter
 
Posts: 16801
Joined: Wed Aug 04, 2010 6:42 pm
Location: California

Re: Clan Database with Labels

Postby Leehar on Mon Apr 07, 2014 3:29 pm

I'll try see if I can use excel to compare the 2 data sets
show
User avatar
Colonel Leehar
 
Posts: 5491
Joined: Fri Mar 06, 2009 12:12 pm
Location: Johannesburg

Re: Clan Database with Labels

Postby Leehar on Mon Jun 23, 2014 2:30 pm

Will need to await some spare time to stress-test the system.
show
User avatar
Colonel Leehar
 
Posts: 5491
Joined: Fri Mar 06, 2009 12:12 pm
Location: Johannesburg

Re: Clan Database with Labels

Postby Leehar on Tue Jun 24, 2014 10:42 am

I know there are other priorities, but is there any way to brighten the front-end of the league section, with tables etc of all the groups?
http://www.conquerclub.com/public.php?mode=showclans3
show
User avatar
Colonel Leehar
 
Posts: 5491
Joined: Fri Mar 06, 2009 12:12 pm
Location: Johannesburg

Re: Clan Database with Labels

Postby Leehar on Tue Oct 21, 2014 3:47 pm

Moving the discussion back to here.

IcePack wrote:
Can I ask how you were able to become the mod for the usergroup? I don't seem to recall the mechanism for processing such a change, so would be interesting to note for future reference.

On that score, I do agree that Lx is the best man for the job now that crown is gone, so could you add him as the mod for the time-being while we brainstorm how to move the project forward?


I can't change Lindax there, but any admin can via submitting and e ticket.
As posted here & discussed with Lx over Skype, I do not wish to be the moderator over there long term.

Good to know about the CL results being one of the likely elements that are screwing up the on-site scoreboard, any other ideas on what is causing major discrepancies between the 2 systems? Otherwise if it's some of these relatively minor areas since I don't think the small sample sizes can cause huge issues, we can perhaps move forward with the current scoreboard if it provides a close enough approximation of the F400. As BW mentioned above, it doesn't really make sense to hold up the useful update for smaller technicalities.


It's really difficult to know exactly what's going on with CC's side of things. I can only guess. I know I spent some time on it awhile ago and things weren't adding up, but it was difficult to pin point why / where the issues were. The last time results were compared in February there was some very odd results on the CC side, but I suppose that all depends on the definition of "close enough approximation". If I recall there was 3-4 very odd results in the top 10, so if 60-70% of the top 10 matching is close enough then I guess your ready to go. I'd have to look again and you / BW are going to have to decide how close is close enough.

I'd prefer in the region of 90%, so lets work on identifying the main differences between the tables, and trying to isolate where exactly they're coming from, and what we can do to fix them.
Otherwise I really do think we just need to bite the bullet and use either only the information that the database has at it's disposal (eg only clan wars etc) or just manually inputting the F400 table's, and see if it could be possible to move forward from there.



However, I feel like I've mentioned these idea's before, so if they truly don't work, it's probably best not to go around in circles either.
show
User avatar
Colonel Leehar
 
Posts: 5491
Joined: Fri Mar 06, 2009 12:12 pm
Location: Johannesburg

Re: Clan Database with Labels

Postby Keefie on Fri Oct 31, 2014 10:55 am

BW,

Looking at that list of wars and the first thing that screams at me is that there are loads of 2014 completed wars missing.

K
Image
User avatar
Major Keefie
Clan Director
Clan Director
 
Posts: 6694
Joined: Sun Dec 03, 2006 1:05 pm
Location: Sleepy Hollow
3

Re: Clan Database with Labels

Postby Leehar on Fri Oct 31, 2014 12:40 pm

Keefie wrote:BW,

Looking at that list of wars and the first thing that screams at me is that there are loads of 2014 completed wars missing.

K

Thats because it was done in early 2014?
show
User avatar
Colonel Leehar
 
Posts: 5491
Joined: Fri Mar 06, 2009 12:12 pm
Location: Johannesburg

Re: Clan Database with Labels

Postby Keefie on Fri Oct 31, 2014 1:29 pm

Leehar wrote:
Keefie wrote:BW,

Looking at that list of wars and the first thing that screams at me is that there are loads of 2014 completed wars missing.

K

Thats because it was done in early 2014?


OK.

I'm quite happy to help out here. Have the two sets of data been thoroughly checked ? I can do that if they haven't.

K
Image
User avatar
Major Keefie
Clan Director
Clan Director
 
Posts: 6694
Joined: Sun Dec 03, 2006 1:05 pm
Location: Sleepy Hollow
3

Re: Clan Database with Labels

Postby bigWham on Fri Oct 31, 2014 8:50 pm

Keefie wrote:
Leehar wrote:
Keefie wrote:BW,

Looking at that list of wars and the first thing that screams at me is that there are loads of 2014 completed wars missing.

K

Thats because it was done in early 2014?


OK.

I'm quite happy to help out here. Have the two sets of data been thoroughly checked ? I can do that if they haven't.

K


Yeah it was done a while ago... and also the data used may not have been right up to date at that time. If you look back in this thread a little you will see the discussion. I believe there was general similarity, but anomalies, and it wasn't clear why. Unfortunately right now the details elude me beyond that it was not especially easy to implement what I did... my general thinking is that if we get caught up on details this may never happen so we need to try and find a path of least resistance that gets the clan world a result that will be better than now, even if not perfect.
User avatar
Colonel bigWham
Webmaster
Webmaster
 
Posts: 2869
Joined: Mon Aug 26, 2013 12:08 pm

Re: Clan Database with Labels

Postby Leehar on Sun Nov 02, 2014 8:35 am

Keefie wrote:
Leehar wrote:
Keefie wrote:BW,

Looking at that list of wars and the first thing that screams at me is that there are loads of 2014 completed wars missing.

K

Thats because it was done in early 2014?


OK.

I'm quite happy to help out here. Have the two sets of data been thoroughly checked ? I can do that if they haven't.

K

If you can perform an analysis of the differences that could cause the large deviations between the data sets that would be very helpful.
Bear in mind Ice's comments that CL results might be causing some of the differences as well
show
User avatar
Colonel Leehar
 
Posts: 5491
Joined: Fri Mar 06, 2009 12:12 pm
Location: Johannesburg

Re: Clan Database with Labels

Postby Keefie on Mon Nov 10, 2014 3:30 pm

BW,

Could I ask you to run your stuff again with a cut off date of 31st October. If you could post a snap of the data again I'll use that to compare against Ice's F41 for the same date.

Cheers
Keith
Image
User avatar
Major Keefie
Clan Director
Clan Director
 
Posts: 6694
Joined: Sun Dec 03, 2006 1:05 pm
Location: Sleepy Hollow
3

Re: Clan Database with Labels

Postby bigWham on Mon Nov 10, 2014 6:26 pm

Keefie wrote:BW,

Could I ask you to run your stuff again with a cut off date of 31st October. If you could post a snap of the data again I'll use that to compare against Ice's F41 for the same date.

Cheers
Keith


This system is coded and connected to the live database. In the link below you can change the start and end dates to be what you want.

http://www.conquerclub.com/public.php?m ... 2014-10-31
User avatar
Colonel bigWham
Webmaster
Webmaster
 
Posts: 2869
Joined: Mon Aug 26, 2013 12:08 pm

Re: Clan Database with Labels

Postby Keefie on Tue Nov 11, 2014 12:53 am

Thanks BW,

I see that Empire and Agents of Chaos are still included. Both of these clans merged into Agents of the Chaotic Empire and shouldn't be included, along with all other clans that are not 'Active'.

Keith

Edit: Just to clarify. When I say shouldn't be included I mean from display purposes only. Old wars involving non-active clans should still be included in the calculations, not including them will affect other clans overall scores.
Image
User avatar
Major Keefie
Clan Director
Clan Director
 
Posts: 6694
Joined: Sun Dec 03, 2006 1:05 pm
Location: Sleepy Hollow
3

Re: Clan Database with Labels

Postby Leehar on Tue Nov 11, 2014 2:47 pm

Excluding those, the scoreboard doesn't really look too bad?
Although I'm curious how empire can increase in points over the last 15 months
show
User avatar
Colonel Leehar
 
Posts: 5491
Joined: Fri Mar 06, 2009 12:12 pm
Location: Johannesburg

Re: Clan Database with Labels

Postby Keefie on Tue Nov 11, 2014 4:42 pm

Would it be possible to see the full table for all clans, before you make any changes to exclude non-active clans.

Thanks
Image
User avatar
Major Keefie
Clan Director
Clan Director
 
Posts: 6694
Joined: Sun Dec 03, 2006 1:05 pm
Location: Sleepy Hollow
3

Re: Clan Database with Labels

Postby bigWham on Wed Nov 12, 2014 10:56 am

Keefie wrote:Would it be possible to see the full table for all clans, before you make any changes to exclude non-active clans.

Thanks


You can change the number included in the url as below:

http://www.conquerclub.com/public.php?m ... &number=22
User avatar
Colonel bigWham
Webmaster
Webmaster
 
Posts: 2869
Joined: Mon Aug 26, 2013 12:08 pm

Re: Clan Database with Labels

Postby Keefie on Wed Nov 12, 2014 12:43 pm

Thanks for that BW.

Ok, now I can see all of the clans on the CC scoreboard I've isolated one that can be looked at to see where the discrepancies lie. The F41 which is the version of the F400 that only includes wars with 41 games or higher, isn't run that often. But it's still obvious that there's a major difference between BW's and the F41's calculations.

I've selected the clan Hard Day's Night as they're relatively new and all their results are defeats.

Image

and here are the wars that affect their score.

Image

Now the first issue I see is that clans need to reach a minimum weight (# of games] before they should show on the scoreboard. In the case of the F41 it's currently set to 125. As HDN didn't reach the minimum weight requirement until the 5th of March, I wouldn't expect to see them on the scoreboard until 01/04.

The second obvious issue is the size of the points loss when comparing the two scoreboards. It's quite clear that there is a difference in the calculations.

Not having access to the F41 I'm unable to go back and recreated the months that are missing, so this is about as far as I can take this. Hopefully there's enough information for BW to work on.

Keith

ps: What's the significance of the number in brackets after each clans name ?
Image
User avatar
Major Keefie
Clan Director
Clan Director
 
Posts: 6694
Joined: Sun Dec 03, 2006 1:05 pm
Location: Sleepy Hollow
3

Re: Clan Database with Labels

Postby IcePack on Sat Nov 15, 2014 7:11 pm

Image


MM SOH 24 17 11/15/12
z-TFFS z-AKA 25 20 11/19/12
RET FISO 27 14 11/20/12
FOED z-AKA 29 12 11/21/12
z-AKA FISO 27 16 11/21/12
FOED TNC 26 15 11/21/12
HH UM8 37 24 11/24/12
TNC TLW 39 22 11/30/12
TNC z-IGNI 30 11 11/30/12
KNT RotS 28 20 12/01/12
G1 TNC 22 19 12/04/12
TNC MB 296 117 12/12/12
OSA LEG 25 16 12/13/12
AFOS TSM 31 30 12/14/12
HH LHDD 23 20 12/15/12
TNC z-AKA 39 22 12/15/12
OTP MYTH 34 29 12/17/12
ID LOW 25 22 12/19/12
FALL z-AKA 27 14 12/20/12
AQOH LOTZ 28 21 12/22/12
FALL LOW 30 20 12/22/12
KORT OSA 32 29 12/23/12
RET HH 34 27 12/31/12
TNC LOTZ 27 14 12/31/12
FALL z-1RFG 26 17 01/06/13
LEG DBC 28 15 01/07/13
z-TFFS FOED 28 22 01/07/13
z-AOC z-EMP 31 30 01/08/13
TOFU PACK 32 29 01/09/13
KORT z-AOC 22 19 01/13/13
OSA OTP 31 26 01/17/13
OSA FISO 48 13 01/18/13
KNT FISO 23 18 01/25/13
PIG z-WAR 34 33 01/25/13
GR FOED 25 24 02/03/13
AQOH HH 21 20 02/11/13
LEG z-AKA 23 18 02/21/13
LHDD TNC 25 18 02/28/13
z-1RFG VDLL 25 16 02/28/13
FISO z-YNWA 30 19 03/01/13
IA TNC 30 11 03/02/13
OTP DBC 33 10 03/02/13
TSM OSA 27 22 03/04/13
HH LOTZ 27 22 03/07/13
OSA LHDD 27 14 03/08/13
HH TPD 35 6 03/10/13
z-DB UM8 29 20 03/18/13
MM FOED 29 20 03/18/13
GR LEG 27 18 03/19/13
TNC FALL 24 17 03/19/13
TLW UM8 28 27 03/19/13
z-1RFG TNC 30 20 03/21/13
RET z-DYN 24 17 03/30/13
MD MYTH 24 17 04/03/13
G1 z-TFFS 23 20 04/04/13
AFOS z-AOC 33 26 04/05/13
AQOH z-YNWA 41 14 04/07/13
z-AKA FISO 22 19 04/14/13
FALL VVV 35 8 04/16/13
z-TFFS LEG 25 18 04/16/13
UM8 SOH 21 20 04/17/13
IA PIG 36 25 04/20/13
VVV z-YNWA 28 13 04/22/13
ATL AQOH 25 16 04/27/13
OSA ID 37 28 04/30/13
IA PIG 36 25 05/01/13
TOFU KORT 31 29 05/02/13
MD z-1RFG 116 87 05/02/13
OSA GR 27 18 05/03/13
z-EMP FALL 26 23 05/08/13
G1 HH 27 24 05/14/13
RET z-AKA 26 15 05/15/13
FISO VVV 30 13 05/23/13
TNC HH 28 14 05/25/13
FOED OTP 26 23 05/28/13
TNC HH 29 14 06/03/13
AQOH VVV 29 12 06/03/13
TNC PACK 22 19 06/04/13
FISO LOTZ 28 21 06/06/13
LEG MB 31 10 06/17/13
z-TFFS z-YNWA 31 10 06/20/13
FALL TSM 24 19 06/21/13
HH RotS 25 16 06/23/13
SOH VVV 28 13 06/23/13
AQOH UM8 21 20 06/24/13
LHDD TLW 36 19 06/25/13
ATL FISO 30 11 06/26/13
TNC FISO 33 12 06/27/13
AQOH HH 21 20 06/28/13
MD z-YNWA 53 14 06/29/13
LHDD z-AKA 28 13 06/30/13
RET VVV 31 10 07/01/13
z-TFFS VVV 29 12 07/02/13
OTP LHDD 30 11 07/03/13
z-WAR KNT 22 19 07/06/13
FISO MB 24 17 07/09/13
RA z-DB 29 12 07/10/13
z-DB TPD 43 6 07/11/13
ID MB 35 6 07/15/13
KORT z-AKA 29 12 07/16/13
TNC GAL 30 13 07/22/13
PIG FOED 39 34 07/25/13
ATL FALL 22 19 07/26/13
TSM LOTZ 30 11 07/27/13
OSA SOH 22 19 07/27/13
IA LEG 28 13 07/29/13
PIG MM 32 29 07/29/13
TOFU AFOS 42 18 07/31/13
HH ATN 30 19 08/03/13
AQOH LEG 21 20 08/05/13
z-TFFS ATN 30 19 08/06/13
z-TFFS z-WAR 21 20 08/09/13
RA TLW 28 14 08/10/13
RotS VVV 23 18 08/13/13
ACE TNC 25 16 08/14/13
G1 OTP 21 20 08/16/13
TLW VVV 31 24 08/19/13
RA PIG 24 17 08/25/13
z-WAR VVV 31 10 08/26/13
z-WAR z-AKA 32 9 08/30/13
AFOS AQOH 22 19 08/31/13
HH RET 22 19 09/01/13
LHDD z-TFFS 22 19 09/02/13
AFOS AQOH 22 19 09/02/13
MYTH TLW 30 11 09/05/13
MM z-WAR 25 16 09/05/13
RotS DBC 30 19 09/07/13
z-DYN GR 27 14 09/15/13
ACE z-TFFS 26 15 09/17/13
ATN TLW 41 20 10/02/13
LOW ID 40 21 10/03/13
ATL RA 21 20 10/08/13
PIG z-TFFS 22.5 15.5 10/10/13
OSA FOED 25 23 10/13/13
z-DB VVV 35 13 10/16/13
LHDD HH 27 14 10/17/13
FALL RET 23 20 10/22/13
VDLL VVV 36 25 10/23/13
OSA OTP 33 28 10/28/13
TOFU z-DYN 46 15 10/29/13
SOH FISO 23 18 11/01/13
PACK OSA 34 27 11/07/13
ATL RA 32 29 11/15/13
FISO RoTS 21 20 11/16/13
TSM AQOH 28 13 11/20/13
TSM MYTH 39 22 11/22/13
RoTS TLW 27 14 11/22/13
RET RGX 38 23 11/23/13
LHDD z-WAR 26 23 12/08/13
TNC RGX 21 20 12/12/13
IA MM 35 26 12/13/13
ACE AFOS 44 17 12/15/13
OSA G1 32 23 12/18/13
GON VVV 30 27 12/19/13
ATN VVV 46 15 12/20/13
FISO UM8 22 19 12/20/13
TNC VVV 38 23 12/20/13
ATL FAD 50 11 12/20/13
FAD DBC 25 16 12/21/13
PACK LHDD 30 11 12/27/13
HH FOED 30 19 12/30/13
FALL PIG 29 20 01/01/14
GR AOK 78 25 01/01/14
ATL AQOH 27 14 01/08/14
KORT OSA 34 27 01/12/14
RET z-TFFS 41 20 01/15/14
VDLL UM8 27 24 01/19/14
OSA FALL 35 26 01/20/14
FISO GON 42 39 01/20/14
GON TPD 52 29 01/20/14
RGX KNT 30 11 01/24/14
OSA z-DYN 40 21 01/27/14
ACE LOW 40 21 01/27/14
LEG MYTH 36 25 01/31/14
FISO HDN 27 14 02/01/14
ATN ROTS 41 20 02/07/14
TWD VVV 22 19 02/09/14
HH FAD 29 12 02/10/14
TOFU ATL 37 24 02/17/14
GR AQOH 33 28 03/02/14
GON LOTZ 23 18 03/04/14
LHDD ATL 22 19 03/05/14
GON HDN 79 22 03/05/14
PACK G1 36 15 03/05/14
z-TWD FISO 23 18 03/08/14
SOH KNT 28 15 03/12/14
TSM IA 33 28 03/14/14
GON FAD 24 17 03/16/14
VDLL SOH 33 18 03/17/14
GON z-AOK 26 15 03/17/14
MD z-TFFS 113 97 03/19/14
RET TNC 41 30 03/24/14
HH OTP 29 20 03/28/14
FOED ATN 27 22 03/29/14
VVV HDN 32 9 04/04/14
OSA z-AQOH 26 23 04/10/14
LEG MM 32 29 04/15/14
GR ATN 33 28 04/19/14
ATL RGX 32 29 04/19/14
z-TWD KNT 38 23 04/20/14
ATN z-AQOH 29 20 04/25/14
OSA FISO 42 19 04/28/14
LEG FALL 22 21 04/29/14
GR VVV 44 17 04/30/14
PIG HH 26 15 05/02/14
PHNX z-AQOH 22 19 05/02/14
z-TWD ROTS 33 28 05/03/14
LHDD FOED 31 18 05/06/14
PACK LOW 38 23 05/09/14
G1 FAD 40 21 05/09/14
TNC BPB 29 16 05/16/14
OSA ATL 22 19 05/17/14
z-TWD FAD 22 19 05/17/14
AFOS VVV 47 14 05/17/14
UM8 HDN 35 6 05/25/14
RET GR 43 18 05/25/14
TNC z-AQOH 30 19 05/28/14
LHDD GON 39 22 05/29/14
GON ROTS 33 12 05/30/14
FOED HH 34 27 06/01/14
VVV z-AOK 21 20 06/02/14
OSA ATL 35 26 06/03/14
GON KNT 26 15 06/03/14
VVV LOTZ 31 30 06/04/14
FISO UM8 33 28 06/09/14
IA OSA 23 18 06/12/14
GON VDLL 21 20 06/12/14
SOH GON 31 30 06/13/14
z-AQOH FISO 35 14 06/13/14
KORT TSM 35 25 06/14/14
LHDD VDLL 29 12 06/15/14
GON z-TWD 21 20 06/16/14
FISO SOH 36 25 06/19/14
OSA RET 35 26 06/20/14
LOW PHNX 32 29 06/22/14
RGX z-TWD 29 12 06/28/14
RET FAD 34 15 07/02/14
KNT LI 36 5 07/14/14
FALL G1 33 10 07/16/14
GR z-TWD 35 26 07/19/14
LEG z-TWD 27 14 07/27/14
LHDD G1 42 19 07/29/14
VVV FAD 22 21 08/01/14
z-AOK HDN 29 11 08/04/14
PACK z-AQOH 26 15 08/06/14
ATN GON 24 17 08/07/14
TOFU ACE 34 33 08/11/14
z-AQOH FAD 28 21 08/12/14
FOED GR 37 8 08/14/14
RGX HH 25 16 08/15/14
LHDD FISO 26 15 08/15/14
SC VVV 23 18 08/21/14
UM8 z-TWD 24 17 08/22/14
FAD VVV 32 29 08/24/14
FOED KNT 30 11 08/26/14
RET FISO 39 22 08/28/14
TNC FAD 103 48 09/07/14
TSM ATN 29 12 09/10/14
LOW OSA 32 29 09/16/14
ATL GR 29 12 09/23/14
GON FISO 26 15 09/30/14
TNC SOH 26 15 10/13/14
FOED AFOS 37 24 10/21/14
RET FAD 27 14 10/26/14
HH TNC 27 22 10/31/14
ATN UM8 26 15 11/08/14
VDLL FISO 33 18 11/09/14
ACE GON 30 11 11/11/14
RA MYTH 23 18 11/12/14
RGX ROTS 33 18 11/12/14
Image

fac vitam incredibilem memento vivere
Knowledge Weighs Nothing, Carry All You Can
Colonel IcePack
Multi Hunter
Multi Hunter
 
Posts: 16801
Joined: Wed Aug 04, 2010 6:42 pm
Location: California

Re: Clan Database with Labels

Postby IcePack on Sat Nov 15, 2014 7:14 pm

Image


TNC VDLL 25 18 11/02/12
MYTH OSA 23 18 11/02/12
FALL HH 27 14 11/04/12
AQOH MB 25 16 11/07/12
MM SOH 24 17 11/15/12
z-TFFS z-AKA 25 20 11/19/12
RET FISO 27 14 11/20/12
FOED z-AKA 29 12 11/21/12
z-AKA FISO 27 16 11/21/12
FOED TNC 26 15 11/21/12
HH UM8 37 24 11/24/12
TNC TLW 39 22 11/30/12
TNC z-IGNI 30 11 11/30/12
KNT RotS 28 20 12/01/12
G1 TNC 22 19 12/04/12
TNC MB 296 117 12/12/12
OSA LEG 25 16 12/13/12
AFOS TSM 31 30 12/14/12
HH LHDD 23 20 12/15/12
TNC z-AKA 39 22 12/15/12
OTP MYTH 34 29 12/17/12
ID LOW 25 22 12/19/12
FALL z-AKA 27 14 12/20/12
AQOH LOTZ 28 21 12/22/12
FALL LOW 30 20 12/22/12
KORT OSA 32 29 12/23/12
RET HH 34 27 12/31/12
TNC LOTZ 27 14 12/31/12
FALL z-1RFG 26 17 01/06/13
LEG DBC 28 15 01/07/13
z-TFFS FOED 28 22 01/07/13
z-AOC z-EMP 31 30 01/08/13
TOFU PACK 32 29 01/09/13
KORT z-AOC 22 19 01/13/13
OSA OTP 31 26 01/17/13
OSA FISO 48 13 01/18/13
KNT FISO 23 18 01/25/13
PIG z-WAR 34 33 01/25/13
GR FOED 25 24 02/03/13
AQOH HH 21 20 02/11/13
LEG z-AKA 23 18 02/21/13
LHDD TNC 25 18 02/28/13
z-1RFG VDLL 25 16 02/28/13
FISO z-YNWA 30 19 03/01/13
IA TNC 30 11 03/02/13
OTP DBC 33 10 03/02/13
TSM OSA 27 22 03/04/13
HH LOTZ 27 22 03/07/13
OSA LHDD 27 14 03/08/13
HH TPD 35 6 03/10/13
z-DB UM8 29 20 03/18/13
MM FOED 29 20 03/18/13
GR LEG 27 18 03/19/13
TNC FALL 24 17 03/19/13
TLW UM8 28 27 03/19/13
z-1RFG TNC 30 20 03/21/13
RET z-DYN 24 17 03/30/13
MD MYTH 24 17 04/03/13
G1 z-TFFS 23 20 04/04/13
AFOS z-AOC 33 26 04/05/13
AQOH z-YNWA 41 14 04/07/13
z-AKA FISO 22 19 04/14/13
FALL VVV 35 8 04/16/13
z-TFFS LEG 25 18 04/16/13
UM8 SOH 21 20 04/17/13
IA PIG 36 25 04/20/13
VVV z-YNWA 28 13 04/22/13
ATL AQOH 25 16 04/27/13
OSA ID 37 28 04/30/13
IA PIG 36 25 05/01/13
TOFU KORT 31 29 05/02/13
MD z-1RFG 116 87 05/02/13
OSA GR 27 18 05/03/13
z-EMP FALL 26 23 05/08/13
G1 HH 27 24 05/14/13
RET z-AKA 26 15 05/15/13
FISO VVV 30 13 05/23/13
TNC HH 28 14 05/25/13
FOED OTP 26 23 05/28/13
TNC HH 29 14 06/03/13
AQOH VVV 29 12 06/03/13
TNC PACK 22 19 06/04/13
FISO LOTZ 28 21 06/06/13
LEG MB 31 10 06/17/13
z-TFFS z-YNWA 31 10 06/20/13
FALL TSM 24 19 06/21/13
HH RotS 25 16 06/23/13
SOH VVV 28 13 06/23/13
AQOH UM8 21 20 06/24/13
LHDD TLW 36 19 06/25/13
ATL FISO 30 11 06/26/13
TNC FISO 33 12 06/27/13
AQOH HH 21 20 06/28/13
MD z-YNWA 53 14 06/29/13
LHDD z-AKA 28 13 06/30/13
RET VVV 31 10 07/01/13
z-TFFS VVV 29 12 07/02/13
OTP LHDD 30 11 07/03/13
z-WAR KNT 22 19 07/06/13
FISO MB 24 17 07/09/13
RA z-DB 29 12 07/10/13
z-DB TPD 43 6 07/11/13
ID MB 35 6 07/15/13
KORT z-AKA 29 12 07/16/13
TNC GAL 30 13 07/22/13
PIG FOED 39 34 07/25/13
ATL FALL 22 19 07/26/13
TSM LOTZ 30 11 07/27/13
OSA SOH 22 19 07/27/13
IA LEG 28 13 07/29/13
PIG MM 32 29 07/29/13
TOFU AFOS 42 18 07/31/13
HH ATN 30 19 08/03/13
AQOH LEG 21 20 08/05/13
z-TFFS ATN 30 19 08/06/13
z-TFFS z-WAR 21 20 08/09/13
RA TLW 28 14 08/10/13
RotS VVV 23 18 08/13/13
ACE TNC 25 16 08/14/13
G1 OTP 21 20 08/16/13
TLW VVV 31 24 08/19/13
RA PIG 24 17 08/25/13
z-WAR VVV 31 10 08/26/13
z-WAR z-AKA 32 9 08/30/13
AFOS AQOH 22 19 08/31/13
HH RET 22 19 09/01/13
LHDD z-TFFS 22 19 09/02/13
AFOS AQOH 22 19 09/02/13
MYTH TLW 30 11 09/05/13
MM z-WAR 25 16 09/05/13
RotS DBC 30 19 09/07/13
z-DYN GR 27 14 09/15/13
ACE z-TFFS 26 15 09/17/13
ATN TLW 41 20 10/02/13
LOW ID 40 21 10/03/13
ATL RA 21 20 10/08/13
PIG z-TFFS 22.5 15.5 10/10/13
OSA FOED 25 23 10/13/13
z-DB VVV 35 13 10/16/13
LHDD HH 27 14 10/17/13
FALL RET 23 20 10/22/13
VDLL VVV 36 25 10/23/13
OSA OTP 33 28 10/28/13
TOFU z-DYN 46 15 10/29/13
SOH FISO 23 18 11/01/13
PACK OSA 34 27 11/07/13
ATL RA 32 29 11/15/13
FISO RoTS 21 20 11/16/13
TSM AQOH 28 13 11/20/13
TSM MYTH 39 22 11/22/13
RoTS TLW 27 14 11/22/13
RET RGX 38 23 11/23/13
LHDD z-WAR 26 23 12/08/13
TNC RGX 21 20 12/12/13
IA MM 35 26 12/13/13
ACE AFOS 44 17 12/15/13
OSA G1 32 23 12/18/13
GON VVV 30 27 12/19/13
ATN VVV 46 15 12/20/13
FISO UM8 22 19 12/20/13
TNC VVV 38 23 12/20/13
ATL FAD 50 11 12/20/13
FAD DBC 25 16 12/21/13
PACK LHDD 30 11 12/27/13
HH FOED 30 19 12/30/13
FALL PIG 29 20 01/01/14
GR AOK 78 25 01/01/14
ATL AQOH 27 14 01/08/14
KORT OSA 34 27 01/12/14
RET z-TFFS 41 20 01/15/14
VDLL UM8 27 24 01/19/14
OSA FALL 35 26 01/20/14
FISO GON 42 39 01/20/14
GON TPD 52 29 01/20/14
RGX KNT 30 11 01/24/14
OSA z-DYN 40 21 01/27/14
ACE LOW 40 21 01/27/14
LEG MYTH 36 25 01/31/14
FISO HDN 27 14 02/01/14
ATN ROTS 41 20 02/07/14
TWD VVV 22 19 02/09/14
HH FAD 29 12 02/10/14
TOFU ATL 37 24 02/17/14
GR AQOH 33 28 03/02/14
GON LOTZ 23 18 03/04/14
LHDD ATL 22 19 03/05/14
GON HDN 79 22 03/05/14
PACK G1 36 15 03/05/14
z-TWD FISO 23 18 03/08/14
SOH KNT 28 15 03/12/14
TSM IA 33 28 03/14/14
GON FAD 24 17 03/16/14
VDLL SOH 33 18 03/17/14
GON z-AOK 26 15 03/17/14
MD z-TFFS 113 97 03/19/14
RET TNC 41 30 03/24/14
HH OTP 29 20 03/28/14
FOED ATN 27 22 03/29/14
VVV HDN 32 9 04/04/14
OSA z-AQOH 26 23 04/10/14
LEG MM 32 29 04/15/14
GR ATN 33 28 04/19/14
ATL RGX 32 29 04/19/14
z-TWD KNT 38 23 04/20/14
ATN z-AQOH 29 20 04/25/14
OSA FISO 42 19 04/28/14
LEG FALL 22 21 04/29/14
GR VVV 44 17 04/30/14
PIG HH 26 15 05/02/14
PHNX z-AQOH 22 19 05/02/14
z-TWD ROTS 33 28 05/03/14
LHDD FOED 31 18 05/06/14
PACK LOW 38 23 05/09/14
G1 FAD 40 21 05/09/14
TNC BPB 29 16 05/16/14
OSA ATL 22 19 05/17/14
z-TWD FAD 22 19 05/17/14
AFOS VVV 47 14 05/17/14
UM8 HDN 35 6 05/25/14
RET GR 43 18 05/25/14
TNC z-AQOH 30 19 05/28/14
LHDD GON 39 22 05/29/14
GON ROTS 33 12 05/30/14
FOED HH 34 27 06/01/14
VVV z-AOK 21 20 06/02/14
OSA ATL 35 26 06/03/14
GON KNT 26 15 06/03/14
VVV LOTZ 31 30 06/04/14
FISO UM8 33 28 06/09/14
IA OSA 23 18 06/12/14
GON VDLL 21 20 06/12/14
SOH GON 31 30 06/13/14
z-AQOH FISO 35 14 06/13/14
KORT TSM 35 25 06/14/14
LHDD VDLL 29 12 06/15/14
GON z-TWD 21 20 06/16/14
FISO SOH 36 25 06/19/14
OSA RET 35 26 06/20/14
LOW PHNX 32 29 06/22/14
RGX z-TWD 29 12 06/28/14
RET FAD 34 15 07/02/14
KNT LI 36 5 07/14/14
FALL G1 33 10 07/16/14
GR z-TWD 35 26 07/19/14
LEG z-TWD 27 14 07/27/14
LHDD G1 42 19 07/29/14
VVV FAD 22 21 08/01/14
z-AOK HDN 29 11 08/04/14
PACK z-AQOH 26 15 08/06/14
ATN GON 24 17 08/07/14
TOFU ACE 34 33 08/11/14
z-AQOH FAD 28 21 08/12/14
FOED GR 37 8 08/14/14
RGX HH 25 16 08/15/14
LHDD FISO 26 15 08/15/14
SC VVV 23 18 08/21/14
UM8 z-TWD 24 17 08/22/14
FAD VVV 32 29 08/24/14
FOED KNT 30 11 08/26/14
RET FISO 39 22 08/28/14
TNC FAD 103 48 09/07/14
TSM ATN 29 12 09/10/14
LOW OSA 32 29 09/16/14
ATL GR 29 12 09/23/14
GON FISO 26 15 09/30/14
TNC SOH 26 15 10/13/14
FOED AFOS 37 24 10/21/14
RET FAD 27 14 10/26/14
HH TNC 27 22 10/31/14
Image

fac vitam incredibilem memento vivere
Knowledge Weighs Nothing, Carry All You Can
Colonel IcePack
Multi Hunter
Multi Hunter
 
Posts: 16801
Joined: Wed Aug 04, 2010 6:42 pm
Location: California

Re: Clan Database with Labels

Postby bigWham on Mon Nov 17, 2014 7:10 pm

So the above score for HDN from IcePack is different again, can someone clarify?

The algorithm I used was "Algorithm of 400", which I think is different to "F41". It was sent to me in HTML/javascript format, and did what I could to convert the process.
User avatar
Colonel bigWham
Webmaster
Webmaster
 
Posts: 2869
Joined: Mon Aug 26, 2013 12:08 pm

Re: Clan Database with Labels

Postby Keefie on Tue Nov 18, 2014 1:17 am

bigWham wrote:So the above score for HDN from IcePack is different again, can someone clarify?

The algorithm I used was "Algorithm of 400", which I think is different to "F41". It was sent to me in HTML/javascript format, and did what I could to convert the process.


The F41 uses the same algorithm as the F400. The only differences being that the weight is set to 125 and only clan wars of 41 games and over are included. So the two datasets match.

The difference in HDN's score can only come from the two calculations .

This is were we need to investigate more, but I don't have access to either.
Image
User avatar
Major Keefie
Clan Director
Clan Director
 
Posts: 6694
Joined: Sun Dec 03, 2006 1:05 pm
Location: Sleepy Hollow
3

Re: Clan Database with Labels

Postby Keefie on Tue Nov 18, 2014 11:45 pm

BW, can you please posts your dataset for the last run. As a check on it we want to run it thru the F41.

Thanks
Image
User avatar
Major Keefie
Clan Director
Clan Director
 
Posts: 6694
Joined: Sun Dec 03, 2006 1:05 pm
Location: Sleepy Hollow
3

PreviousNext

Return to Clan Archives

Who is online

Users browsing this forum: No registered users