Regarding the "Official Survery about item power" (
http://forum.c-rpg.net/index.php/topic,5439.0.html).
Results were combined into one row per voter. Each buff vote counts as +1 in the appropriate column, each nerf vote counts as -1 and each novote as 0. Votes were then summed by key-column, so if someone voted to both buff and nerf polearms, result in polechange column is 0.
Vote was then combined with information about main character of each forum account. If no main character was set for the account, vote does not appear in the data set. Main characters classes were detected with a magical algorithm and each given a column in the dataset.
Detection magic pseudo code:
wp_one_handed >= 50 AND power_strike > 0 THEN '1h'
shield >= 3 THEN 'shield'
wp_two_handed >= 50 AND power_strike > 0 THEN '2h'
wp_polearm >= 50 AND power_strike > 0 THEN 'pole'
wp_archery >= 50 AND power_draw > 0 THEN 'archer'
wp_crossbow >= 50 THEN 'xbow'
wp_throwing >= 50 AND power_throw > 0 THEN 'throwing'
riding >= 3 THEN 'cav'
horse_archery >= 1 THEN 'ha'
Yes, you can debate whether those values make sense and so on. That's the way they are in this dataset.
Final dataset is in csv format (semicolon separated). Columns and their explanations:
class: combined class name (1h/2h/shield)
1h, 2h, pole, shield, archer, xbow, throwing, cav, ha: column name if character has said class, else blank
1hchange, 2hchange etc: account vote, +1 for buff, -1 for nerf, 0 for no change
For example this archer here wanted to buff bows but everything else was fine:
archer;;;;;archer;;;;;0;0;0;0;0;0;1;0;0
This polearmer wanted to buff armor and polearms and nerf bows and xbows.
pole;;;pole;;;;;;;0;1;0;0;1;0;0;-1;-1
This selfless xbowman wanted to buff armor and throwing, not himself! A reward will be handed out to him.
xbow;;;;;;xbow;;;;0;1;0;0;0;0;1;0;0
Data can be found here: http://pastebin.com/i84vhz5C (scroll down to raw paste data)
If you make something out of it, please post it here. Some explanation of your analysis is appreciated, pretty pics alone can often be misleading. Extra-awesome analysis might even earn some small reward (like half of a heirloom point) if respect, glory and honour is not enough.
