Posted February 19, 201213 yr Approximate number of songs above each sales level - by week Basically, I got tired of having to search back every time I wanted to add this comparison info to my weekly YTD lists, so now I can just look it up on my spreadsheet. :) >100k Week : '12 - '11 - '10 - '09 1 : 0 - 0 - 1 - 1 2 : 0 - 1 - 2 - 2 3 : 3 - 4 - 6 - 3 4 : 9 - 7 - 9 - 6 5 : 13 - 10 - 14 - 9 6 : 20 - 18 - 19 - 12 7 : ?? - 30 - 22 - 15 8 : ?? - 32 - 27 - 16 9 : ?? - 33 - 29 - 19 10 : ?? - 34 - 34 - 24 11 : ?? - 38 - 37 - 30 12 : ?? - 43 - 38 - 32 13 : ?? - 45 - 44 - 34 14 : ?? - 47 - 48 - 38 15 : ?? - 52 - 51 - 45 16 : ?? - 54 - 53 - 47 17 : ?? - 56 - 59 - 52 18 : ?? - 59 - 63 - 55 19 : ?? - 63 - 64 - 56 20 : ?? - 66 - 68 - 57 21 : ?? - 68 - 73 - 63 22 : ?? - 74 - 76 - 64 23 : ?? - 79 - 83 - 66 24 : ?? - 85 - 89 - 67 25 : ?? - 88 - 93 - 72 26 : ?? - 90 - 96 - 77 27 : ?? - 96 - 100 - 78 28 : ?? - 98 - 103 - 81 29 : ?? - 101 - 105 - 85 30 : ?? - 101 - 110 - 86 31 : ?? - 104 - 114 - 90 32 : ?? - 108 - 116 - 95 33 : ?? - 111 - 118 - 96 34 : ?? - 117 - 122 - 98 35 : ?? - 119 - 123 - 103 36 : ?? - 122 - 126 - 104 37 : ?? - 127 - 128 - 112 38 : ?? - 130 - 132 - 113 39 : ?? - 133 - 134 - 117 40 : ?? - 138 - 137 - 119 41 : ?? - 140 - 142 - 122 42 : ?? - 146 - 145 - 125 43 : ?? - 152 - 150 - 129 44 : ?? - 156 - 153 - 130 45 : ?? - 159 - 156 - 138 46 : ?? - 159 - 161 - 139 47 : ?? - 164 - 168 - 144 48 : ?? - 168 - 171 - 149 49 : ?? - 173 - 173 - 151 50 : ?? - 175 - 176 - 154 51 : ?? - 178 - 179 - 159 52 : ?? - 188 - 185 - 162 53 : n/a - n/a - n/a - 167 Surprisingly little increase here over the last several years, but watch this space... :) Edited February 24, 201213 yr by vidcapper
February 19, 201213 yr Author > 200k Week : '12 - '11 - '10 - '09 1 : 0 - 0 - 0 - 0 2 : 0 - 0 - 0 - 0 3 : 0 - 1 - 1 - 0 4 : 1 - 1 - 2 - 1 5 : 3 - 2 - 4 - 1 6 : 4 - 3 - 6 - 2 7 : ?? - 7 - 8 - 5 8 : ?? - 8 - 10 - 5 9 : ?? - 12 - 12 - 6 10 : ?? - 14 - 12 - 7 11 : ?? - 15 - 14 - 8 12 : ?? - 15 - 17 - 10 13 : ?? - 17 - 19 - 11 14 : ?? - 19 - 20 - 14 15 : ?? - 23 - 20 - 14 16 : ?? - 24 - 24 - 15 17 : ?? - 27 - 26 - 18 18 : ?? - 30 - 27 - 23 19 : ?? - 35 - 27 - 24 20 : ?? - 35 - 29 - 25 21 : ?? - 39 - 29 - 29 22 : ?? - 41 - 31 - 31 23 : ?? - 43 - 33 - 33 24 : ?? - 46 - 34 - 34 25 : ?? - 48 - 37 - 35 26 : ?? - 51 - 43 - 37 27 : ?? - 53 - 45 - 39 28 : ?? - 56 - 49 - 41 29 : ?? - 58 - 52 - 43 30 : ?? - 62 - 52 - 44 31 : ?? - 64 - 53 - 47 32 : ?? - 66 - 57 - 48 33 : ?? - 68 - 60 - 48 34 : ?? - 68 - 64 - 49 35 : ?? - 71 - 65 - 51 36 : ?? - 75 - 67 - 54 37 : ?? - 79 - 67 - 55 38 : ?? - 81 - 70 - 56 39 : ?? - 83 - 70 - 56 40 : ?? - 85 - 72 - 57 41 : ?? - 87 - 78 - 58 42 : ?? - 91 - 80 - 60 43 : ?? - 92 - 80 - 63 44 : ?? - 95 - 84 - 65 45 : ?? - 97 - 88 - 67 46 : ?? - 101 - 88 - 69 47 : ?? - 102 - 89 - 71 48 : ?? - 105 - 93 - 72 49 : ?? - 105 - 97 - 76 50 : ?? - 109 - 100 - 80 51 : ?? - 111 - 102 - 84 52 : ?? - 114 - 105 - 86 53 : n/a - n/a - n/a - 89 Edited February 19, 201213 yr by vidcapper
February 19, 201213 yr Author >300k Week : '12 - '11 - '10 - '09 1 : 0 - 0 - 0 - 0 2 : 0 - 0 - 0 - 0 3 : 0 - 1 - 0 - 0 4 : 0 - 1 - 0 - 0 5 : 0 - 1 - 1 - 1 6 : 2 - 1 - 2 - 1 7 : ?? - 1 - 3 - 1 8 : ?? - 4 - 3 - 1 9 : ?? - 5 - 5 - 1 10 : ?? - 5 - 6 - 2 11 : ?? - 6 - 8 - 2 12 : ?? - 7 - 8 - 3 13 : ?? - 8 - 10 - 3 14 : ?? - 9 - 10 - 5 15 : ?? - 9 - 11 - 7 16 : ?? - 11 - 11 - 7 17 : ?? - 13 - 12 - 7 18 : ?? - 13 - 15 - 7 19 : ?? - 15 - 15 - 8 20 : ?? - 16 - 16 - 8 21 : ?? - 20 - 18 - 10 22 : ?? - 22 - 19 - 13 23 : ?? - 22 - 19 - 13 24 : ?? - 23 - 19 - 14 25 : ?? - 23 - 20 - 15 26 : ?? - 25 - 21 - 16 27 : ?? - 26 - 23 - 16 28 : ?? - 26 - 24 - 17 29 : ?? - 28 - 26 - 17 30 : ?? - 30 - 29 - 18 31 : ?? - 34 - 30 - 19 32 : ?? - 35 - 30 - 21 33 : ?? - 37 - 31 - 22 34 : ?? - 38 - 31 - 25 35 : ?? - 38 - 33 - 26 36 : ?? - 40 - 35 - 27 37 : ?? - 41 - 36 - 29 38 : ?? - 43 - 37 - 29 39 : ?? - 44 - 38 - 30 40 : ?? - 46 - 39 - 30 41 : ?? - 46 - 40 - 30 42 : ?? - 47 - 42 - 31 43 : ?? - 49 - 45 - 34 44 : ?? - 51 - 46 - 35 45 : ?? - 51 - 47 - 35 46 : ?? - 53 - 48 - 36 47 : ?? - 54 - 50 - 37 48 : ?? - 57 - 51 - 37 49 : ?? - 58 - 52 - 39 50 : ?? - 60 - 55 - 41 51 : ?? - 63 - 60 - 44 52 : ?? - 67 - 61 - 45 53 : n/a - n/a - n/a - 48
February 19, 201213 yr Author >400k Week : '12 - '11 - '10 - '09 1 : 0 - 0 - 0 - 0 2 : 0 - 0 - 0 - 0 3 : 0 - 0 - 0 - 0 4 : 0 - 0 - 0 - 0 5 : 0 - 1 - 0 - 0 6 : 0 - 1 - 1 - 0 7 : ?? - 1 - 2 - 1 8 : ?? - 1 - 2 - 1 9 : ?? - 2 - 3 - 1 10 : ?? - 4 - 3 - 1 11 : ?? - 4 - 3 - 1 12 : ?? - 4 - 3 - 1 13 : ?? - 4 - 3 - 1 14 : ?? - 5 - 3 - 1 15 : ?? - 6 - 5 - 2 16 : ?? - 6 - 5 - 2 17 : ?? - 8 - 5 - 3 18 : ?? - 9 - 6 - 3 19 : ?? - 9 - 7 - 3 20 : ?? - 9 - 7 - 3 21 : ?? - 9 - 8 - 4 22 : ?? - 10 - 8 - 4 23 : ?? - 12 - 8 - 4 24 : ?? - 13 - 8 - 4 25 : ?? - 14 - 8 - 4 26 : ?? - 14 - 8 - 5 27 : ?? - 14 - 10 - 7 28 : ?? - 15 - 10 - 8 29 : ?? - 16 - 11 - 8 30 : ?? - 17 - 12 - 8 31 : ?? - 18 - 13 - 9 32 : ?? - 19 - 15 - 10 33 : ?? - 20 - 16 - 10 34 : ?? - 20 - 16 - 10 35 : ?? - 20 - 16 - 11 36 : ?? - 21 - 16 - 12 37 : ?? - 21 - 16 - 12 38 : ?? - 23 - 16 - 13 39 : ?? - 23 - 17 - 13 40 : ?? - 24 - 18 - 14 41 : ?? - 25 - 19 - 14 42 : ?? - 25 - 20 - 16 43 : ?? - 27 - 20 - 17 44 : ?? - 31 - 20 - 19 45 : ?? - 32 - 21 - 20 46 : ?? - 34 - 24 - 22 47 : ?? - 34 - 25 - 22 48 : ?? - 34 - 25 - 22 49 : ?? - 35 - 25 - 23 50 : ?? - 35 - 26 - 23 51 : ?? - 37 - 27 - 25 52 : ?? - 40 - 32 - 26 53 : n/a - n/a - n/a - 27 And finally...
February 19, 201213 yr Author >500k Week : '12 - '11 - '10 - '09 1 : 0 - 0 - 0 - 0 2 : 0 - 0 - 0 - 0 3 : 0 - 0 - 0 - 0 4 : 0 - 0 - 0 - 0 5 : 0 - 0 - 0 - 0 6 : 0 - 0 - 0 - 0 7 : ?? - 1 - 1 - 0 8 : ?? - 1 - 1 - 0 9 : ?? - 1 - 1 - 0 10 : ?? - 2 - 1 - 0 11 : ?? - 3 - 2 - 0 12 : ?? - 3 - 2 - 1 13 : ?? - 3 - 2 - 1 14 : ?? - 4 - 2 - 1 15 : ?? - 4 - 2 - 1 16 : ?? - 4 - 2 - 1 17 : ?? - 5 - 2 - 2 18 : ?? - 5 - 2 - 2 19 : ?? - 6 - 2 - 2 20 : ?? - 7 - 2 - 2 21 : ?? - 7 - 2 - 2 22 : ?? - 7 - 2 - 2 23 : ?? - 8 - 2 - 2 24 : ?? - 8 - 2 - 2 25 : ?? - 9 - 3 - 2 26 : ?? - 9 - 3 - 3 27 : ?? - 9 - 5 - 3 28 : ?? - 9 - 5 - 3 29 : ?? - 10 - 7 - 3 30 : ?? - 10 - 7 - 3 31 : ?? - 10 - 7 - 3 32 : ?? - 12 - 7 - 4 33 : ?? - 12 - 9 - 4 34 : ?? - 13 - 11 - 4 35 : ?? - 13 - 11 - 4 36 : ?? - 15 - 12 - 4 37 : ?? - 15 - 12 - 4 38 : ?? - 15 - 12 - 5 39 : ?? - 15 - 12 - 6 40 : ?? - 16 - 12 - 6 41 : ?? - 16 - 12 - 6 42 : ?? - 16 - 12 - 6 43 : ?? - 16 - 13 - 6 44 : ?? - 17 - 14 - 6 45 : ?? - 18 - 14 - 7 46 : ?? - 18 - 14 - 7 47 : ?? - 18 - 14 - 7 48 : ?? - 18 - 15 - 7 49 : ?? - 18 - 15 - 8 50 : ?? - 18 - 16 - 8 51 : ?? - 18 - 18 - 9 52 : ?? - 23 - 18 - 12 53 : n/a - n/a - n/a - 12 As you can see, it is at the higher sales levels where the numbers have increased most. Edited February 19, 201213 yr by vidcapper
February 19, 201213 yr Author Oh come on - someone must have a comment, after all the work I did! Edited February 19, 201213 yr by vidcapper
February 20, 201213 yr Author I dont really know what to say, lots of figures confuse me :P At least you said *something*, which is more than anyone else did. :(
February 21, 201213 yr Author Update for 2012, week 7 : 26>100k, 5>200k, 2>300k In case you were wondering, I haven't done the same calculation for albums yet - and the lack of response to this thread doen't make me inclined to do so. Edited February 21, 201213 yr by vidcapper
February 21, 201213 yr The figures are interesting but there really isn't a great deal to say. Plenty of people have viewed the thread and I'm sure the same would apply to the same figures for albums.
February 21, 201213 yr These are interesting numbers for me, I like that kind of stuff. Thanks! :cheer: Good that these numbers have gone up year on year, especially with the higher sellers. Last year there were 23 selling >500k, interestingly 5 of these only passed the mark in the last week of 2011. I wonder if we'll see another increase this year, the charts may be slow moving but at least we have decent sales.
February 21, 201213 yr Author VIDCAPPER I THINK YOU ARE VERY GOOD WITH EXCEL With ordinary formulas, I'm OK - just don't mention the word 'macro'! :P
February 21, 201213 yr I enjoy looking over the figures too, VC - just not sure I have anything to say! Sorry!
February 21, 201213 yr The figures are interesting but there really isn't a great deal to say. Plenty of people have viewed the thread and I'm sure the same would apply to the same figures for albums. Agreed. I read them with interest but the numbers really speak for themselves. That said, it must be rather disheartening to put all that work in and receive little or no feedback.
February 21, 201213 yr Good list VC, could possibly be displayed in a more visually appealing way I guess to increase interest (e.g. graphs on your blueyonder, or all the various thresholds together just for each week to date could be added by you each week of 2012. Interesting and I appreciate, just trying to be constructive due to your desire for comments! I'd like to see the albums too - I think there's more concern about that being that the perception is they are failing and are worth higher revenue, singles are kind of looking after themselves at the moment
February 22, 201213 yr Author Good list VC, could possibly be displayed in a more visually appealing way I guess to increase interest (e.g. graphs on your blueyonder, or all the various thresholds together just for each week to date could be added by you each week of 2012. I *do* have graphs prepared for my website, but I was going to wait until I had the albums done too, before posting them. I'd like to see the albums too - I think there's more concern about that being that the perception is they are failing and are worth higher revenue, singles are kind of looking after themselves at the moment Well, it *would* be easier for me in the long run if I did the albums too... :) Thanks for the comments, everyone.
February 23, 201213 yr Author It suddenly occurred to me that the albums one could be rather interesting, with a slow climb until late autumn, then a massive spike in the Xmas run-up... :)
February 23, 201213 yr Maybe I'm misunderstanding these figures. Are you listing the number of singles that sold over 100k, 200k etc... each week throughout the year? Only reason for being unsure if because Coldplay 'Paradise' sold over 100k when it was #1 yet for Week 1 and 2 for 2012 you have 100k down as 0? Coldplay was no. 1 on 1st January so don't know which week that would come under (are you using w/b dates or w/e dates?) What do the numbers represent if it isn't total number of singles selling over 100k and so on? >100k Week : '12 - '11 - '10 - '09 1 : 0 - 0 - 1 - 1 2 : 0 - 1 - 2 - 2
Create an account or sign in to comment