TWDA Analysis
21 Jul 2018 00:32 #89129
by skimflux
TWDA Analysis was created by skimflux
I've finished sanitizing and processing the TWDA and am finally confortable enough to get some statistics out of it. This is the main result: the most used cards for each year from 1997 to 2017.
Dreams is the most featured card of all time, but it only ranks 3rd for the past 10 years - interestingly, Pentex only became really popular after 2006.
The number of a cards that have never been used in winning deck is actually 691 cards. There are also 337 that featured only once...
If we count copies used, Deflection and GtU blow everything else out of the water - each has more than 6000 uses - the next most common cards are On The Qui Vive and Blood Doll, sitting at just above 4000 each.
The full Excel file is too big to attach here, but I'll send it to whoever is interested. Since a lot of the parsing had to be tuned and corrected, it's possible some mistakes have gone through - just as I was posting this I noticed that all Telepathic Misdirections had been classified as Misdirections (again!). Luckily that was easy to fix, not like the Flash Grenades...
Year | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 |
Total Tournaments/Decks | 4 | 15 | 23 | 35 | 75 | 93 | 119 | 100 | 117 | 114 |
Dreams of the Sphinx | 1 | 6 | 11 | 16 | 23 | 31 | 57 | 38 | 45 | 37 |
Pentex(TM) Subversion | 1 | 1 | 6 | 5 | 19 | 9 | 19 | 29 | ||
On the Qui Vive | 5 | |||||||||
Blood Doll | 3 | 10 | 18 | 17 | 50 | 64 | 88 | 75 | 82 | 92 |
Deflection | 2 | 8 | 10 | 19 | 29 | 32 | 47 | 36 | 49 | 35 |
Giant's Blood | 2 | 3 | 5 | 11 | 18 | 20 | 30 | 31 | 33 | 41 |
Direct Intervention | 2 | 6 | 8 | 17 | 23 | 13 | 27 | 25 | 46 | 33 |
Govern the Unaligned | 2 | 8 | 10 | 14 | 25 | 24 | 32 | 26 | 30 | 26 |
Telepathic Misdirection | 3 | 8 | 9 | 21 | 23 | 48 | 39 | 33 | 29 | |
Wake with Evening's Freshness | 3 | 9 | 18 | 19 | 34 | 52 | 73 | 52 | 67 | 54 |
Conditioning | 1 | 7 | 5 | 13 | 17 | 20 | 21 | 18 | 28 | 27 |
Vessel | ||||||||||
Information Highway | 1 | 8 | 7 | 14 | 16 | 33 | 23 | 20 | 26 | 18 |
Lost in Crowds | 2 | 3 | 7 | 11 | 27 | 21 | 27 | 34 | 39 | 25 |
Villein | ||||||||||
Delaying Tactics | 2 | 1 | 5 | 9 | 13 | 17 | 13 | 15 | 21 | |
Kine Resources Contested | 2 | 4 | 8 | 13 | 17 | 18 | 25 | 18 | 37 | 25 |
Sudden Reversal | 2 | 7 | 13 | 24 | 40 | 37 | 39 | 28 | 33 | 23 |
Taste of Vitae | 2 | 4 | 4 | 4 | 10 | 18 | 23 | 15 | 20 | 23 |
Powerbase: Montreal | 1 | 10 | 16 | 29 | 9 | 14 | 22 | |||
Majesty | 1 | 6 | 11 | 10 | 13 | 21 | 28 | 22 | 17 | 21 |
Forced Awakening | 2 | 11 | 10 | 24 | 35 | 41 | 31 | 23 | 28 | |
Carlton Van Wyk | 18 | 31 | ||||||||
Faceless Night | 3 | 5 | 19 | 15 | 16 | 28 | 33 | 20 | ||
Swallowed by the Night | 1 | 5 | 6 | 20 | 14 | 18 | 34 | 29 | 20 | |
Ivory Bow | 1 | 4 | 6 | 7 | 10 | 21 | 21 | 11 | 13 | 16 |
Fame | 1 | 1 | 2 | 8 | 12 | 17 | 12 | 21 | 34 | |
Heart of Nizchetus | 4 | |||||||||
Cloak the Gathering | 2 | 3 | 4 | 9 | 22 | 22 | 20 | 31 | 29 | 21 |
Elder Impersonation | 2 | 2 | 2 | 1 | 7 | 12 | 20 | 16 | 30 | 17 |
Freak Drive | 1 | 3 | 4 | 8 | 10 | 16 | 18 | 17 | 15 | 20 |
Archon Investigation | 4 | 1 | 4 | 8 | 10 | 13 | 16 | 11 | 18 | 10 |
My Enemy's Enemy | 2 | 3 | 4 | 8 | 12 | 18 | 12 | 10 | 11 | |
Entrancement | 2 | 4 | 4 | 5 | 12 | 12 | 7 | 12 | 15 | |
Parthenon, The | 2 | 2 | 12 | 10 | 11 | 15 | 13 | 17 | 16 | |
Parity Shift | 1 | 3 | 4 | 8 | 8 | 12 | 21 | 11 | 17 | 15 |
Rack, The | 4 | 3 | 6 | 10 | 17 | 19 | 13 | 12 | 15 | |
Minion Tap | 1 | 9 | 13 | 17 | 29 | 28 | 36 | 27 | 35 | 24 |
Banishment | 2 | 2 | 9 | 9 | 8 | 8 | 15 | 6 | 19 | 18 |
Second Tradition: Domain | 5 | 8 | 11 | 22 | 15 | 25 | 11 | 17 | 13 | |
Eagle's Sight | 5 | 5 | 14 | 14 | 23 | 13 | 14 | 9 | ||
Eyes of Argus | ||||||||||
Secure Haven | 1 | 3 | 5 | 6 | 7 | 10 | 22 | 15 | 22 | 16 |
Aranthebes, The Immortal | 7 | 10 | 13 | 17 | ||||||
Enhanced Senses | 1 | 3 | 6 | 5 | 12 | 16 | 23 | 19 | 13 | 10 |
Wider View | ||||||||||
Wash | 2 | |||||||||
Voter Captivation | 3 | 5 | 5 | 6 | 8 | 18 | 13 | 15 | 15 | |
Jake Washington | 4 | 6 | 7 | 9 | 14 | 8 | ||||
Perfectionist | 2 | 16 | 18 |
Year | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 |
Total Tournaments/Decks | 200 | 221 | 240 | 213 | 270 | 219 | 244 | 182 | 137 | 109 | 89 |
Dreams of the Sphinx | 67 | 80 | 103 | 121 | 141 | 108 | 134 | 99 | 79 | 59 | 41 |
Pentex(TM) Subversion | 61 | 99 | 113 | 129 | 151 | 145 | 170 | 103 | 88 | 79 | 60 |
On the Qui Vive | 102 | 124 | 144 | 123 | 147 | 134 | 142 | 117 | 87 | 74 | 50 |
Blood Doll | 127 | 109 | 89 | 79 | 57 | 49 | 58 | 37 | 17 | 15 | 13 |
Deflection | 66 | 100 | 104 | 91 | 81 | 97 | 101 | 79 | 49 | 44 | 38 |
Giant's Blood | 58 | 65 | 93 | 93 | 118 | 104 | 106 | 86 | 73 | 62 | 47 |
Direct Intervention | 82 | 93 | 70 | 57 | 80 | 75 | 75 | 50 | 41 | 42 | 34 |
Govern the Unaligned | 46 | 67 | 80 | 65 | 56 | 79 | 71 | 60 | 37 | 36 | 25 |
Telepathic Misdirection | 43 | 53 | 72 | 59 | 76 | 56 | 74 | 57 | 37 | 39 | 24 |
Wake with Evening's Freshness | 61 | 64 | 59 | 39 | 45 | 41 | 34 | 31 | 23 | 13 | 10 |
Conditioning | 51 | 64 | 86 | 64 | 59 | 80 | 80 | 57 | 35 | 34 | 26 |
Vessel | 12 | 114 | 102 | 70 | 88 | 65 | 81 | 78 | 53 | 51 | 39 |
Information Highway | 39 | 42 | 55 | 47 | 63 | 52 | 66 | 49 | 40 | 34 | 24 |
Lost in Crowds | 51 | 52 | 59 | 51 | 58 | 53 | 43 | 30 | 30 | 29 | 15 |
Villein | 1 | 37 | 65 | 102 | 94 | 94 | 85 | 63 | 55 | 48 | |
Delaying Tactics | 33 | 61 | 68 | 59 | 82 | 62 | 74 | 41 | 28 | 26 | 22 |
Kine Resources Contested | 50 | 53 | 52 | 38 | 55 | 48 | 48 | 24 | 29 | 19 | 13 |
Sudden Reversal | 27 | 34 | 32 | 27 | 43 | 43 | 37 | 29 | 23 | 12 | 8 |
Taste of Vitae | 26 | 38 | 44 | 54 | 66 | 49 | 47 | 46 | 20 | 19 | 17 |
Powerbase: Montreal | 25 | 46 | 55 | 45 | 57 | 37 | 57 | 37 | 32 | 35 | 22 |
Majesty | 43 | 40 | 52 | 30 | 57 | 47 | 47 | 26 | 23 | 21 | 15 |
Forced Awakening | 33 | 56 | 33 | 35 | 32 | 21 | 40 | 33 | 24 | 25 | 13 |
Carlton Van Wyk | 48 | 62 | 56 | 50 | 62 | 46 | 49 | 29 | 36 | 27 | 22 |
Faceless Night | 41 | 39 | 52 | 38 | 51 | 39 | 36 | 26 | 25 | 25 | 15 |
Swallowed by the Night | 43 | 47 | 41 | 39 | 49 | 30 | 32 | 26 | 28 | 24 | 14 |
Ivory Bow | 40 | 38 | 44 | 49 | 55 | 35 | 51 | 35 | 24 | 27 | 14 |
Fame | 38 | 36 | 43 | 42 | 64 | 39 | 51 | 34 | 26 | 17 | 19 |
Heart of Nizchetus | 34 | 49 | 55 | 45 | 64 | 61 | 67 | 46 | 26 | 29 | 20 |
Cloak the Gathering | 47 | 40 | 40 | 39 | 45 | 39 | 29 | 14 | 15 | 19 | 12 |
Elder Impersonation | 30 | 34 | 43 | 41 | 51 | 36 | 33 | 29 | 34 | 32 | 18 |
Freak Drive | 23 | 41 | 55 | 32 | 47 | 41 | 38 | 30 | 25 | 24 | 14 |
Archon Investigation | 32 | 29 | 35 | 42 | 56 | 33 | 47 | 38 | 30 | 18 | 20 |
My Enemy's Enemy | 25 | 27 | 45 | 31 | 42 | 27 | 56 | 36 | 26 | 24 | 19 |
Entrancement | 33 | 22 | 38 | 39 | 52 | 39 | 49 | 34 | 19 | 17 | 18 |
Parthenon, The | 34 | 34 | 26 | 33 | 39 | 43 | 39 | 26 | 24 | 11 | 23 |
Parity Shift | 23 | 27 | 48 | 29 | 43 | 35 | 41 | 27 | 19 | 16 | 14 |
Rack, The | 24 | 35 | 37 | 30 | 48 | 22 | 35 | 27 | 16 | 24 | 13 |
Minion Tap | 43 | 44 | 33 | 5 | 11 | 10 | 13 | 8 | 7 | 11 | 3 |
Banishment | 25 | 21 | 28 | 29 | 45 | 40 | 41 | 23 | 23 | 23 | 10 |
Second Tradition: Domain | 20 | 22 | 37 | 30 | 43 | 33 | 29 | 27 | 13 | 7 | 11 |
Eagle's Sight | 20 | 30 | 33 | 26 | 32 | 25 | 38 | 32 | 16 | 24 | 15 |
Eyes of Argus | 2 | 35 | 49 | 55 | 50 | 55 | 45 | 31 | 33 | 22 | |
Secure Haven | 29 | 23 | 23 | 26 | 40 | 22 | 29 | 24 | 27 | 26 | 13 |
Aranthebes, The Immortal | 39 | 44 | 42 | 35 | 39 | 31 | 36 | 24 | 19 | 19 | 9 |
Enhanced Senses | 19 | 34 | 30 | 25 | 35 | 22 | 32 | 28 | 17 | 21 | 12 |
Wider View | 26 | 70 | 65 | 64 | 46 | 39 | 30 | 29 | |||
Wash | 24 | 39 | 52 | 40 | 44 | 33 | 43 | 25 | 24 | 28 | 19 |
Voter Captivation | 27 | 26 | 42 | 23 | 39 | 34 | 38 | 20 | 16 | 13 | 6 |
Jake Washington | 21 | 28 | 41 | 45 | 45 | 37 | 40 | 29 | 17 | 5 | 12 |
Perfectionist | 24 | 38 | 32 | 31 | 42 | 17 | 31 | 37 | 31 | 21 | 18 |
Dreams is the most featured card of all time, but it only ranks 3rd for the past 10 years - interestingly, Pentex only became really popular after 2006.
The number of a cards that have never been used in winning deck is actually 691 cards. There are also 337 that featured only once...
If we count copies used, Deflection and GtU blow everything else out of the water - each has more than 6000 uses - the next most common cards are On The Qui Vive and Blood Doll, sitting at just above 4000 each.
The full Excel file is too big to attach here, but I'll send it to whoever is interested. Since a lot of the parsing had to be tuned and corrected, it's possible some mistakes have gone through - just as I was posting this I noticed that all Telepathic Misdirections had been classified as Misdirections (again!). Luckily that was easy to fix, not like the Flash Grenades...

The following user(s) said Thank You: Damnans, Brum, Lönkka, Loughman, Ashur, ReverendRevolver, TryDeflectingThisGrapple, Lech, Snodig, LivesByProxy
Please Log in or Create an account to join the conversation.
21 Jul 2018 01:51 #89130
by self biased
Please Log in or Create an account to join the conversation.
- self biased
-
- Offline
- Antediluvian
-
- I pray at an altar of farts.
Less
More
- Posts: 823
- Thank you received: 357
21 Jul 2018 06:37 #89134
by beslin igor
Replied by beslin igor on topic TWDA Analysis
im suprised how Ashur Tablets not in this list.
and great joab skimflux,i also like statistic
and great joab skimflux,i also like statistic

Please Log in or Create an account to join the conversation.
- beslin igor
-
- Offline
- Antediluvian
-
Less
More
- Posts: 687
- Thank you received: 136
21 Jul 2018 09:17 #89136
by Ashur
Hi! I´m interested in that file. Please send a copy to henrik dot klippstrom at blackchantry dot com. Thanks in advance!
"My strategy? Luck is my strategy, of course."
Replied by Ashur on topic TWDA Analysis
The full Excel file is too big to attach here, but I'll send it to whoever is interested.
Hi! I´m interested in that file. Please send a copy to henrik dot klippstrom at blackchantry dot com. Thanks in advance!
"My strategy? Luck is my strategy, of course."
Please Log in or Create an account to join the conversation.
21 Jul 2018 09:45 #89139
by skimflux
I've put the results file on OneDrive:
1drv.ms/x/s!Arz0OfxudeZ7lswuit4JbdgZRAqvGA
Enjoy!
Replied by skimflux on topic TWDA Analysis
could this be posted as a spreadsheet?
I've put the results file on OneDrive:
1drv.ms/x/s!Arz0OfxudeZ7lswuit4JbdgZRAqvGA
Enjoy!
Please Log in or Create an account to join the conversation.
21 Jul 2018 09:46 #89140
by Lech

Sabbat.Black Hand Shakar: Lech loathe ranged weapons. Once each action, he may burn 1 blood to become Camarilla Prince of Krakow until the end of the action.
Replied by Lech on topic TWDA Analysis
Nice, but due to constant need to compare to total twda there should be percentage table too.






Sabbat.Black Hand Shakar: Lech loathe ranged weapons. Once each action, he may burn 1 blood to become Camarilla Prince of Krakow until the end of the action.
Please Log in or Create an account to join the conversation.
Time to create page: 0.279 seconds
- You are here:
-
Home
-
Forum
-
V:TES Discussion
-
Generic V:TES Discussion
- TWDA Analysis