Stream League Table

User avatar
Great Britain Interjection
Howdah
Donator 04
Posts: 1045
Joined: Mar 15, 2015
ESO: Interjection
Location: United Kingdom

Stream League Table

  • Quote

Post by Interjection »

Introducing the Age of Empires 3 Streaming League Table! I originally made this thread to ask for help compiling a complete list of Twitch channels that broadcast AOE3 for the AOE Gameplay YouTube channel https://www.youtube.com/channel/UCYL_kUvJaOgKDeJYUlDVkTg (so post any channels I've missed down below)! With some help though (a lot of help) (okay so @Buckethead basically made it) but we now have a fully functioning hourly updating league table! In time something like this might make it's way onto the http://eso-community.net main page.

In the future it is possible for the table to consider more criteria in it's scores but for now I really think this is amazing (but suggestions are welcome)! The very next feature I'd like to develop though would be a sort of 'monthly hiscores' to replace the 'last 30 days' table. The monthly hiscores would essentially be identical to the current 'last 30 days' table except it would only consider progress made in that particular month (so on Feb 01, there would only be 1 day of data). Ideally, at the end of each month the table would be archived off as a separate sheet so it can be looked back on.

Link to spreadsheet: https://docs.google.com/spreadsheets/d/1vyJoQlnLX3bkXl6xr3_oBS-DyxoKGRw5bxxsmlxKDLA/edit?usp=sharing

_____________

Patch Notes:
*Release Version: v1.00
*
Attachments
Updated hourly here: https://docs.google.com/spreadsheets/d/1vyJoQlnLX3bkXl6xr3_oBS-DyxoKGRw5bxxsmlxKDLA/edit?usp=sharing
Updated hourly here: https://docs.google.com/spreadsheets/d/1vyJoQlnLX3bkXl6xr3_oBS-DyxoKGRw5bxxsmlxKDLA/edit?usp=sharing
User avatar
United States of America site
Lancer
Donator 01
Posts: 713
Joined: Aug 7, 2016
ESO: site
Location: Oklahoma, USA

Re: Stream League Table

Post by site »

This is outstanding on many levels! Very informative.
User avatar
Singapore milku3459
Howdah
Posts: 1216
Joined: Nov 8, 2016
ESO: milku3459
Location: in your base, killing your dudes

Re: Stream League Table

Post by milku3459 »

nice work inter! This table might encourage a little friendly competition among streamers!
does veni stream anymore?
User avatar
Germany Akechi_Mitsuhide
Dragoon
Posts: 245
Joined: Feb 4, 2016
ESO: Akechi_Mitsuhide

Re: Stream League Table

Post by Akechi_Mitsuhide »

Interjection_Mathematics_OP :flowers: ;)
User avatar
Great Britain Interjection
Howdah
Donator 04
Posts: 1045
Joined: Mar 15, 2015
ESO: Interjection
Location: United Kingdom

Re: Stream League Table

Post by Interjection »

Plz can someone help me with this, it's so frustrating. How do I import that "92" followers in the last 30 days. I want the spreadsheet to read that value and auto update so bad >.<

Also, the "3996" figure D:

http://socialblade.com/twitch/user/aiz11
Attachments
How to get that 92.png
No Flag kami_ryu
Retired Contributor
Posts: 2196
Joined: Jan 2, 2017

Re: Stream League Table

Post by kami_ryu »

What you're doing here reminds me a lot of this: https://www.fuzic.nl/
User avatar
Brazil Buckethead
Retired Contributor
Posts: 448
Joined: Mar 1, 2015

Re: Stream League Table

Post by Buckethead »

Interjection wrote:Plz can someone help me with this, it's so frustrating. How do I import that "92" followers in the last 30 days. I want the spreadsheet to read that value and auto update so bad >.<

Also, the "3996" figure D:

http://socialblade.com/twitch/user/aiz11


The fucking tagging system does not let me post the code rofl
Here it is: http://pastebin.com/enEBFuuW
User avatar
Great Britain Interjection
Howdah
Donator 04
Posts: 1045
Joined: Mar 15, 2015
ESO: Interjection
Location: United Kingdom

Re: Stream League Table

Post by Interjection »

Holy crap that's amazing, thank you so much. I literally spent all day on this yesterday and went to bed grumpy because I couldn't do it. I put the code in right away except now I have a new problem, it pulls the whole line, not just the number. So it reads: 100 ( +7.38% )

And now the points system can't run properly because it doesn't recognize it as a number, any ideas how to fix this? If not then oh well I'll just reorder the scoreboard to use followers only (or views, not decided yet)
User avatar
United States of America giveuanxiety
Advanced Player
Donator 02
Posts: 1988
Joined: Feb 27, 2015
ESO: GiveUAnxiety

Re: Stream League Table

Post by giveuanxiety »

cool stuff. I might have to try and take that number 1 spot, Also I had a question, If I upload a video to youtube and there is music in the video, (music that comes from a youtube video) will it be fine?, not muted or taken down or anything like that?
Lasol wrote: :hmm: just Saw a YouTube video with giveyouanexiaty. He Said check youre stove, if you Want to improve youre aoe3 skills.

WHAT does check your stove means? And how do you do it?
User avatar
Brazil Buckethead
Retired Contributor
Posts: 448
Joined: Mar 1, 2015

Re: Stream League Table

Post by Buckethead »

User avatar
No Flag fightinfrenchman
Ninja
Donator 04
Posts: 23505
Joined: Oct 17, 2015
Location: Pennsylvania

Re: Stream League Table

Post by fightinfrenchman »

Add twitch.tv/evilcheadaresoc
Dromedary Scone Mix is not Alone Mix
Image
User avatar
Poland pecelot
Retired Contributor
Donator 03
Posts: 10459
Joined: Mar 25, 2015
ESO: Pezet

Re: Stream League Table

Post by pecelot »

Interjection wrote:Originally, the purpose of this thread was to ask for help compiling a complete list of AOE3 Streams (for the Gameplay Channel https://www.youtube.com/channel/UCYL_kUvJaOgKDeJYUlDVkTg). I'm sure I've missed a few (sorry), so please do post anything that needs to be added!

You should have „Age of Empires 3" in the channel title, otherwise you may not get found from the browser :!:
User avatar
Great Britain Interjection
Howdah
Donator 04
Posts: 1045
Joined: Mar 15, 2015
ESO: Interjection
Location: United Kingdom

Re: Stream League Table

Post by Interjection »

GuA,
It actually makes no difference where the music comes from. The worst thing that might happen is that it will not be viewable on mobile devices and in some countries (usually the USA & Germany are the worst for this). The majority of the time, like 90% of the time, nothing will happen, it will play as normal except you won't be able to make money from it.
____________

Chedar,
Added ya!
____________

Buckethead,
<3 you're some kind of wizard... I don't even know. I put the formula in and it gets the data nicely, works like a charm. The weird thing is though that the numbers appear left of the cell instead of the right where they should be (compare the black cells to the the others). Because of this they don't interact with the points calculation and it returns an error.

To get them to appear on the right like normal numbers I copied their values in a new cell and did +0. This fixed them and now they interact just fine with the points formula (weird?).

Two problems have come up though, for some reason Herrknight's new channels views keeps saying 1 (which it isn't, it's 2036). And Divinefire's new views keeps returning an error!

Thank you for the help so far, I really appreciate it! Any more ideas though?

Hopefully once this gets set up, maybe we could even implement a high scores on the ESOC websites for the top 10, a bit like where the ELO widget is :)
User avatar
Canada Lunatic_Fringe
Dragoon
Posts: 200
Joined: Aug 23, 2016
ESO: Nightwing
Location: Canada

Re: Stream League Table

Post by Lunatic_Fringe »

Wow. That is a work of a pro. Hats of Inter!
I didn't even know that people like Boneng and Blackstar were still streaming.
User avatar
Brazil Buckethead
Retired Contributor
Posts: 448
Joined: Mar 1, 2015

Re: Stream League Table

Post by Buckethead »

https://docs.google.com/spreadsheets/d/ ... sp=sharing

Everything is updated only by running a function and it is only using one IMPORTXML per stream (ie: no issues with data limit)
User avatar
Great Britain Interjection
Howdah
Donator 04
Posts: 1045
Joined: Mar 15, 2015
ESO: Interjection
Location: United Kingdom

Re: Stream League Table

Post by Interjection »

I'm genuinely amazed you can even do that. So you're telling me it's definitely still autoupdating? Even though I see no special formula? Is it easy to add new streams if needed?
User avatar
Netherlands edeholland
ESOC Community Team
Donator 01
Posts: 5033
Joined: Feb 11, 2015
ESO: edeholland
GameRanger ID: 4053888
Clan: ESOC

Re: Stream League Table

Post by edeholland »

I don't want to underplay what Bucket achieved, but it is relatively easy if you know Excel/Google Spreadsheet commands. You basically import the XML first, then joins the outcome with another string (CONCATENATE) and then filters that outcome with a regular expression.

I think in his document this is done by a script, which is why you don't see any code. Nice job Buckethead :p

And thank you Interjection for this idea, it's awesome!
User avatar
Brazil Buckethead
Retired Contributor
Posts: 448
Joined: Mar 1, 2015

Re: Stream League Table

Post by Buckethead »

Interjection wrote:I'm genuinely amazed you can even do that. So you're telling me it's definitely still autoupdating? Even though I see no special formula? Is it easy to add new streams if needed?

It will update every hour (from now)
The script are doing everything behind the scenes, and will be there that you will add new streams (send me your email to allow you to edit)
Image
User avatar
Brazil Buckethead
Retired Contributor
Posts: 448
Joined: Mar 1, 2015

Re: Stream League Table

  • Quote

Post by Buckethead »

I just found an awesome website :o :o :o
http://sullygnome.com/Channel/aiz11
User avatar
Great Britain Interjection
Howdah
Donator 04
Posts: 1045
Joined: Mar 15, 2015
ESO: Interjection
Location: United Kingdom

Re: Stream League Table

Post by Interjection »

That is an awesome website! Now I can make a more detailed league table using more criteria :P

Also I'll PM you my email address :)
User avatar
Great Britain Interjection
Howdah
Donator 04
Posts: 1045
Joined: Mar 15, 2015
ESO: Interjection
Location: United Kingdom

Re: Stream League Table

Post by Interjection »

Are we able to get the data to auto sort? Or should we manually redorder it every now and again?

Also, the all time table is currently being sorted by most views to least rather than points :P
User avatar
Spain yoqpasa
Lancer
Posts: 750
Joined: Sep 16, 2015
ESO: yoqpasa

Re: Stream League Table

Post by yoqpasa »

Are you going to stream AOE3 again any time soon Interjection? You have x4 Tibia's followers, with a regular streaming time you could reach +100 viewers really easily. I think you are one of those who can ''recruit'' more ESOicans.
Image

Image
User avatar
Brazil Buckethead
Retired Contributor
Posts: 448
Joined: Mar 1, 2015

Re: Stream League Table

Post by Buckethead »

Interjection wrote:That is an awesome website! Now I can make a more detailed league table using more criteria :P

Also I'll PM you my email address :)


@Interjection
Added you as editor.
The table auto-sort in each update, but it was ordering the wrong table, I fixed it.
If you want to add something new let me know, It should be added in the script instead of directly on the sheet.

Update post #1 with new sheet
User avatar
Netherlands Mr_Bramboy
Retired Contributor
Donator 01
Posts: 8219
Joined: Feb 26, 2015
ESO: [VOC] Bram
Location: Amsterdam

Re: Stream League Table

Post by Mr_Bramboy »

This is great. @Buckethead Can we add this to the sidebar?

Add my stream as well please (mr_bramboy). Also Jim's stream is named SirCallen.
Belgium stanleywinston
Dragoon
Beginner Division WinnerDonator 01
Posts: 275
Joined: Jun 29, 2015
ESO: Stanley_Winston
Location: Belgium

Re: Stream League Table

Post by stanleywinston »

Stanley_Winston left out :(. https://www.twitch.tv/stanley_winston

Who is online

Users browsing this forum: No registered users and 15 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