Excel extract of ESO-C Recs

Here you can post about your scenario's, mods, custom maps and YouTube channels!
User avatar
Australia VooDoo_BoSs
Dragoon
Posts: 254
Joined: Jul 7, 2016
ESO: VooDoo_BoSs
Location: Australia

Excel extract of ESO-C Recs

Post by VooDoo_BoSs »

Hi all

A bit of a strange request but not sure where else to post.

I'm playing around with some AOE data and was hoping to get an extract of the ESO-C recorded games.

Ideally, would like to get data on CIVS, game length, and winner (if possible). Bonus happiness for maps and patch as well.

Is this possible? :)
User avatar
Greece BrookG
Retired Contributor
Posts: 2009
Joined: Feb 21, 2016
ESO: BrookG
Location: Thessaloniki

Re: Excel extract of ESO-C Recs

Post by BrookG »

As far as I know @Buckethead is working on that to some extent already. I'm hoping I going to share some data on the previous tournament this week. If you need some help with organising feel free to pm me!
Correlation doesn't mean causation.
http://www.tylervigen.com/spurious-correlations

"mr.brookg go buy jeans and goto the club with somppuli" - Princeofkabul, July 2018
User avatar
Australia VooDoo_BoSs
Dragoon
Posts: 254
Joined: Jul 7, 2016
ESO: VooDoo_BoSs
Location: Australia

Re: Excel extract of ESO-C Recs

Post by VooDoo_BoSs »

BrookG wrote:As far as I know @Buckethead is working on that to some extent already. I'm hoping I going to share some data on the previous tournament this week. If you need some help with organising feel free to pm me!


Thanks!

@Buckethead - are you able to advise on whether this one is going ahead?
User avatar
Brazil Buckethead
Retired Contributor
Posts: 448
Joined: Mar 1, 2015

Re: Excel extract of ESO-C Recs

  • Quote

Post by Buckethead »

I can share all recorded games data that we currently have but Im not sure if I understand the format of the data you want, If you could explain in detail would be great

Anyway Im going to attach the data on the format that we currently store it, maybe this is what you want and/or it might be useful for other users :hmm:
Attachments
player.csv
(2.31 MiB) Downloaded 27 times
replay.csv
(935.11 KiB) Downloaded 19 times
User avatar
Brazil lemmings121
Jaeger
Posts: 2673
Joined: Mar 15, 2015
ESO: lemmings121

Re: Excel extract of ESO-C Recs

Post by lemmings121 »

Buckethead wrote:I can share all recorded games data that we currently have but Im not sure if I understand the format of the data you want, If you could explain in detail would be great

Anyway Im going to attach the data on the format that we currently store it, maybe this is what you want and/or it might be useful for other users :hmm:


nice pic
Image
User avatar
Australia VooDoo_BoSs
Dragoon
Posts: 254
Joined: Jul 7, 2016
ESO: VooDoo_BoSs
Location: Australia

Re: Excel extract of ESO-C Recs

Post by VooDoo_BoSs »

Buckethead wrote:I can share all recorded games data that we currently have but Im not sure if I understand the format of the data you want, If you could explain in detail would be great

Anyway Im going to attach the data on the format that we currently store it, maybe this is what you want and/or it might be useful for other users :hmm:


This is great!

Only thing I was thinking of adding was the player names and civs as columns (eg: Player 1 name, Player 1 Civ, Player 2 name, Player 2 civ....)

Otherwise the format is fine.
User avatar
Brazil Buckethead
Retired Contributor
Posts: 448
Joined: Mar 1, 2015

Re: Excel extract of ESO-C Recs

Post by Buckethead »

Something like that? https://docs.google.com/spreadsheets/d/1I1mpa-sfzKOSrlQqJ-kB_-PTQkzQKXRB8gKvdKaePLY/edit#gid=970419647
(I added a sheet which contains the length in seconds if this helps in anything)

I have filtered some of data:
Only games played on ESO with real players (no bots) and must have a winner
Mode: 1v1
Rules: Standard
Type: Supremacy
Starting Age: Discovery
Speed: Medium
Allow Cheats: Disabled
Handicap: Disabled

https://docs.google.com/spreadsheets/d/ ... =970419647
User avatar
Australia VooDoo_BoSs
Dragoon
Posts: 254
Joined: Jul 7, 2016
ESO: VooDoo_BoSs
Location: Australia

Re: Excel extract of ESO-C Recs

Post by VooDoo_BoSs »

Buckethead wrote:Something like that? https://docs.google.com/spreadsheets/d/1I1mpa-sfzKOSrlQqJ-kB_-PTQkzQKXRB8gKvdKaePLY/edit#gid=970419647
(I added a sheet which contains the length in seconds if this helps in anything)

I have filtered some of data:
Only games played on ESO with real players (no bots) and must have a winner
Mode: 1v1
Rules: Standard
Type: Supremacy
Starting Age: Discovery
Speed: Medium
Allow Cheats: Disabled
Handicap: Disabled

https://docs.google.com/spreadsheets/d/ ... =970419647


Awesome!!

Who is online

Users browsing this forum: No registered users and 7 guests

Which top 10 players do you wish to see listed?

All-time

Active last two weeks

Active last month

Supremacy

Treaty

Official

ESOC Patch

Treaty Patch

1v1 Elo

2v2 Elo

3v3 Elo

Power Rating

Which streams do you wish to see listed?

Twitch

Age of Empires III

Age of Empires IV