by FarangDemon on Fri Apr 01, 2011 10:43 pm
I'd prefer to discuss the algorithm itself in this thread and have a second thread devoted to maintaining an up-to-date ranking using this system.
The algorithm itselfI'm happy to discuss the method, and maintain and improve my script but I don't want to maintain the Clan War data that it runs on. And I don't want people complaining to me that I did or did not use such and such data. CC isn't comping me in any way for this, so I will only do what I think is fun. I've changed the name of this thread to "Algorithm" to reflect this.
An official ranking based on the algorithmThis would be the thread that discusses data and contains updated ranking lists / graphs.
You'll need someone to maintain the clan war data file and I can link to it from my script page. Then whoever wants to generate an up-to-date ranking can just click on the link, copy and paste the data into my script and churn it out whenever. Or if I improve my script, I can eliminate the need to open the file and manually copy and paste.
This is the format for each line (Clan1, Clan2, Clan1 Wins, Clan2 Wins, Date) separated by tabs.
http://www.killersapp.com/AllData.txtThe file below has the same war results, but each war has a description of whether it was Clan League 1,2,3 or a regular clan war. This should help to refine dates. If you want accurate results, somebody is going to have to look up when each clan war from Season 1 and 2 actually ended (I'd choose 3 weeks after the 2nd and final Home/Away set between the two clans). Dates from Season 3 are pretty good already.
http://www.killersapp.com/AllDataMerged.xls
- Click image to enlarge.

"He came dancin across the water.... FarangDemon, FarangDemon.... mmmhh....what a killer..."