STATUS QUO INEFFICIENT METHOD
Everybody uses excel. To generate updates, everybody must check the forums for results of clan wars. Then they must enter line by line of concluded wars into their excel and must also spend time manipulating data in excel. Each must also separately take time to double check the forums to ensure that all new war results were added.
Clan Directors maintain a file containing raw results from clan wars and post it to a URL whose name does not change. Each line has 5 values separated by comma or some other format (Clan 1 Name, Clan 2 Name, Clan 1 Score, Clan 2 Score, War End Date).
Every few weeks, Clan Directors update the clan war results file and upload this file to the same URL.
To generate updated clan rankings, jpcloet, qwert and FarangDemon merely press a button to launch their script to automatically calculate rankings.
According to my vision, everybody saves time if we all use scripts to automatically process data instead of mucking about in excel every time we get new data. Also only one person spends time scouring the forums tabulating results of clan wars, the CD, who then posts this information to a URL which our scripts use.
Yes this requires an initial investment of time to write the scripts. However, this small investment is far outweighed by the time you save
1 not scouring the forums for clan war results
2 not entering updated clan war results into excel
3 not manipulating excel
You just click a button. FYI I´ve volunteered to help jpcloet and qwert write scripts.
The cool thing is that jpcloet already maintains data files, so it´s just a question of him committing to continue to maintain it and post each update to a URL. The current status is, jpcloet is thinking about doing this.
FarangDemon wrote:FYI - I have a system that objectively measures clan performance, based solely on a clan´s performance against another clan. You can read about it here: